Saturday 6 May 2017

Excel - Microsoft Excel Tbilleq Function

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