Excel Function : TBILLEQ
Category
Financial
Description
Returns the bond-equivalent yield for a Treasury bill
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TBILLEQ-function-2ab72d90-9b4d-4efe-9fc2-0f81f2c19c8c
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.
