When you are architecting a complex financial model dealing specifically with government-issued Treasury bills, calculating the true annual yield is mathematically complex because these instruments are sold at a discount and do not pay periodic interest. To force the Microsoft Excel engine to execute the correct chronological calculus and determine the absolute Bond-Equivalent Yield (BEY) for a T-bill, you must deploy the specialized TBILLEQ function.
Understanding the TBILLEQ Architecture
The TBILLEQ (Treasury Bill Equivalent Yield) function is a rigid, highly specialized algorithmic engine designed exclusively for short-term government debt. It calculates the annualized yield of a T-bill, assuming a 365-day year, allowing you to mathematically compare its performance directly against standard bonds that pay periodic coupons. It ingests the chronological parameters and the bank-discount rate to output the BEY.
The syntax requires exactly three mandatory arguments: =TBILLEQ(settlement, maturity, discount)
- settlement: The absolute chronological date the Treasury bill is purchased.
- maturity: The absolute chronological date the Treasury bill expires (must be within one year of settlement).
- discount: The annual discount rate at which the Treasury bill was sold.
Executing the Yield Extraction
Imagine your firm purchases a 90-day US Treasury bill. The settlement date is April 1, 2024 (Cell A1). The maturity date is June 30, 2024 (Cell A2). The stated bank-discount rate at the time of purchase is exactly 4.50% (Cell A3).
To execute the precise extraction, click an empty cell and type:
=TBILLEQ(A1, A2, A3)The exact millisecond you press Enter, the Excel engine executes the calculus. It calculates the exact geometric distance between the settlement and maturity dates (90 days). It algorithmically reverses the discount calculation to find the true purchase price, and then mathematically annualizes that return based on a 365-day year. It outputs the highly precise absolute decimal integer: 0.04603 (or 4.603% when formatted as a percentage).
This provides mathematical proof that, despite the 4.50% stated discount rate, the true bond-equivalent yield of this specific T-bill is 4.603%.