Returns the equivalent annualized rate of return of a US Treasury Bill based on a given discount rate.
Sample Usage
TBILLEQ(A2,A3,A4)
TBILLEQ(DATE(2010,1,2), DATE(2010,12,31), .09)
Syntax
TBILLEQ(settlement, maturity, discount)
- settlement - The settlement date of the Treasury bill.
- maturity - The maturity date of the Treasury bill.
- discount - The discount rate of the Treasury bill at the time of purchase.
Examples
TBILLEQ(A2,A3,A4) returns the the bond equivalent yield, for the Treasury bill using the terms in A2, A3, and A4.
Notes
- Problems can occur if dates are entered as text. You can use the DATE function to enter dates for settlement and maturity. For example, use DATE(2020,2,3) for the 3rd day of January, 2020.