Excel Function : TBILLEQ

Download now!

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.