Calculates the price per $100 face value for a Treasury bill.
Syntax
TBILLPRICE(settlement, maturity, discount)Argumente
settlementerforderlich
The Treasury bill's settlement date, which is the date after the issue date when the T-bill is traded to the buyer.
maturityerforderlich
The Treasury bill's maturity date, which is the date when the T-bill expires.
discounterforderlich
The Treasury bill's discount rate.
The TBILLPRICE function determines the price of a Treasury bill based on its settlement date, maturity date, and discount rate. It uses the standard bond market convention where the price is expressed as a value per $100 of face value.
=TBILLPRICE("2023-01-01", "2023-06-01", 0.05)→97.91667Calculates the price of a T-bill with a 5% discount rate maturing in 5 months.
Enter the dates
Ensure your settlement and maturity dates are in a format Excel recognizes, such as DATE(2023,1,1).
Apply the formula
Input the settlement date, maturity date, and discount rate into the TBILLPRICE function.
The maturity date must be within one year of the settlement date.