Excel Function : TBILLEQ
Returns the bond-equivalent yield for a Treasury bill
Microsoft Excel Reference Page
Syntax and Description of the TBILLEQ Excel Function
The syntax for the TBILLEQ function in Microsoft Excel is: =TBILLEQ(settlement, maturity, rate, pr, discount) Where: settlement – The date of the security's issuance. maturity – The date of the security's maturity. rate – The security's annual coupon rate. pr – The security's price. discount – The security's discount rate.
About TBILLEQ Excel Function
The TBILLEQ function returns the number of days between two dates, using a 360-day year.