Calculates the price of a US Treasury Bill based on a given discount rate.
Sample Usage
TBILLPRICE(A2,A3,A4)
TBILLPRICE(DATE(2010,1,2), DATE(2010,12,31), .0125)
Syntax
TBILLPRICE(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
TBILLPRICE(A2,A3,A4) returns the price 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.
- maturity must be one year or less from the settlement date.
- discount is a percentage and must be entered as a positive number from zero to one.