Excel Function : TBILLEQ

Download now!

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.