Calculates the yield for a Treasury bill.
Syntax
TBILLYIELD(settlement, maturity, pr)Argument
settlementobligatoriskt
The Treasury bill's settlement date (the date after the issue date when the bill is traded to the buyer).
maturityobligatoriskt
The Treasury bill's maturity date (the date when the bill expires).
probligatoriskt
The Treasury bill's price per $100 face value.
The TBILLYIELD function returns the annual yield for a Treasury bill based on its settlement date, maturity date, and price per $100 face value. It uses the standard bond yield calculation method based on a 360-day year.
=TBILLYIELD("2023-01-01", "2023-06-01", 98.5)→0.036585Calculates the yield for a T-bill purchased at 98.5 with a 5-month duration.
Prepare your dates
Ensure your settlement and maturity dates are entered as valid Excel date formats or references to cells containing dates.
Enter the function
Input the TBILLYIELD function with the settlement date, maturity date, and the price per $100 face value.
The maturity date must be less than one year after the settlement date.