Definition of TBILLEQ
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
TBILLEQ(DATE(2010,1,2), DATE(2010,12,31), .09)
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.
maturityshould be entered using
TO_DATEor other date parsing functions rather than by entering text.
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: