Description
The Excel TBILLEQ function calculates the bond-equivalent yield for a Treasury Bill.
The syntax of the function is :
TBILLEQ( settlement, maturity, discount )
Where the arguments are as follows:
Excel Tbilleq Function Example
The following example shows the Excel Tbilleq function used to calculate the bond-equivalent yield for a treasury bill with settlement date 01-Feb-2011, maturity date 30-Jun-2011 and a discount of 2.5%:
Tbilleq Function Errors
The most common Excel Tbilleq function errors and their causes are listed in the following table:
Common Errors
No comments:
Post a Comment