TBILLEQ


Definition of TBILLEQ

Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

Sample Usage

TBILLEQ(DATE(2010,1,2), DATE(2010,12,31), .09)

TBILLEQ(A2,B2,C2)

Syntax

TBILLEQ(settlement, maturity, discount)

  • settlement - The settlement date of the security, the date after issuance when the security is delivered to the buyer.

  • maturity - The maturity or end date of the security, when it can be redeemed at face or par value.

  • discount - The discount rate of the bill at time of purchase.

Notes

  • settlement and maturity should be entered using DATETO_DATE or other date parsing functions rather than by entering text.

See Also

TBILLYIELD: Calculates the yield of a US Treasury Bill based on price.

TBILLPRICE: Calculates the price of a US Treasury Bill based on discount rate.

In order to use the TBILLEQ formula, start with your edited Excellentable:

Screen Shot 2016-06-07 at 2.17.29 PM.png

Then type in the TBILLEQ Formula in the area you would like to display the outcome:

Screen Shot 2016-06-07 at 2.17.46 PM.png

By adding the values you would like to calculate the TBILLEQ formula for, Excellentable will generate the outcome:

Screen Shot 2016-06-07 at 2.15.45 PM.png