Returns the price per $100 face value for a treasury bill.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Settlement is the treasury bill's settlement date. The security settlement date is the date after the issue date when the treasury bill is traded to the buyer.
Maturity is the treasury bill's maturity date. The maturity date is the date when the treasury bill expires.
Discount is the treasury bill's discount rate.
- Settlement and maturity are truncated to integers.
- If any argument is nonnumeric, TBILLPRICE returns the #VALUE! error value.
- If settlement or maturity is not a valid date, TBILLPRICE returns the #NUM! error value.
- If discount £ 0, TBILLPRICE returns the #NUM! error value.
- If settlement > maturity, or if maturity is more than one year after settlement, TBILLPRICE returns the #NUM! error value.
- TBILLPRICE is calculated as follows:
DSM = number of days from settlement to maturity, excluding any maturity date that is more than one calendar year after the settlement date.
A treasury bill has the following terms:
March 31, 1993, settlement date
June 1, 1993, maturity date
9 percent discount rate
The treasury bill price (in the 1900 date system) is:
TBILLPRICE("3/31/93","6/1/93",0.09) equals 98.45