When you are analyzing the mathematical yield of a deeply discounted bond (like a US Treasury Bill that pays no periodic interest but is sold at a massive discount to its face value), standard yield formulas are functionally useless. To force the Microsoft Excel engine to calculate the exact, annualized discount rate for this highly specific class of security, you must use the DISC function.
Understanding the DISC Architecture
The DISC (Discount) function is a rigid financial engine. It ingests the purchase price and the final redemption value, and algorithmically outputs the security’s absolute discount rate (expressed as an annual percentage) based on the exact number of chronological days between the purchase and the maturity date.
The syntax requires exactly four mandatory arguments and one optional argument: =DISC(settlement, maturity, pr, redemption, [basis])
- settlement: The absolute date the buyer takes possession of the security.
- maturity: The absolute final date the security expires and pays out the face value.
- pr: The exact mathematical price you paid per $100 of face value.
- redemption: The exact payout value per $100 of face value at maturity (usually 100).
- [basis]: An optional integer (0 to 4) dictating the specific day-count methodology. If omitted, Excel defaults to the US (NASD) 30/360 system.
Executing the Financial Calculation
Imagine you are purchasing a zero-coupon bond. The settlement date is February 1, 2024 (A2). The absolute maturity date is August 1, 2024 (A3). You are paying exactly $97.50 per $100 of face value (A4). The redemption value is a pristine $100 (A5). You require the highly precise Actual/360 day-count basis commonly used in money markets (A6, value 2).
To calculate the exact annualized discount rate, click an empty cell and type:
=DISC(A2, A3, A4, A5, A6)The exact millisecond you press Enter, the Excel engine executes the calculus. It determines the physical number of days the capital is locked up, calculates the $2.50 absolute spread against the $100 redemption, and outputs the annualized percentage (e.g., 4.95%). This proves mathematically what your capital is actually yielding on an annualized basis.