Skip to main content

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:

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

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

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.