TBILLYIELD Function Explained
The TBILLYIELD Function in Microsoft Excel calculates the yield of a Treasury bill, given the price, face value, and days to maturity. It returns the yield as a percentage.
TBILLYIELD Function Syntax
TBILLYIELD(settlement, maturity, pr)
- settlement: The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- maturity: The security’s maturity date. The maturity date is the date when the security expires.
- pr: The security’s price per $100 face value.