Saturday 6 May 2017

Excel - Microsoft Excel Tbillprice Function

Description

The Excel TBILLPRICE function returns the price, per $100 face value, of a Treasury Bill. 

The syntax of the function is : 

TBILLPRICE( settlement, maturity, discount ) 


Where the arguments are as follows: 

Note that the supplied maturity date must be greater than, but no more than one year after the settlement date. 
Note also, that these dates should be supplied to the function as either: 


Excel Tbillprice Function Example
The following example shows the Excel Tbillprice function used to calculate the price, per $100 face value, of a treasury bill with settlement date 01-Feb-2011, maturity date 30-Jun-2011 and a discount rate of 2.75%: 




Tbillprice Function Errors
If you get an error from the Tbillprice function, find the likely cause, using the table below: 

Common Errors 













No comments:

Post a Comment