When you invest initial capital into a fully invested security (such as a commercial paper or a short-term discount note) that features a fixed discount rate rather than periodic coupon payments, you must mathematically calculate the absolute final cash payout you will acquire at maturity. To force the Microsoft Excel engine to bypass standard compound interest models and execute this highly specific, linear financial calculus, you must deploy the RECEIVED function.
Understanding the RECEIVED Architecture
The RECEIVED function is an algorithmic engine designed exclusively to calculate the terminal redemption value of a fully invested security. It ingests the chronological settlement and maturity dates, the exact amount of initial capital invested, and the annualized discount rate. It executes a fractional calculation to determine the exact numerical value of the final payout.
The syntax requires exactly four mandatory arguments: =RECEIVED(settlement, maturity, investment, discount, [basis])
- settlement: The absolute chronological date the security is purchased.
- maturity: The absolute chronological date the security expires and pays out.
- investment: The exact amount of initial capital invested (the purchase price).
- discount: The annual discount rate mathematically attached to the security.
Executing the Terminal Payout Calculus
Imagine your firm purchases a short-term discount note on March 1, 2024 (Cell A1). It matures on September 1, 2024 (Cell A2). You invest exactly $50,000 in capital (Cell A3). The fixed annualized discount rate is 4.50% (Cell A4).
To execute the precise extraction of the final redemption value, click an empty cell and type:
=RECEIVED(A1, A2, A3, A4)The exact millisecond you press Enter, the Excel engine intercepts the data array. It calculates the exact fractional year (approximately 0.5 years) between March and September. It mathematically applies the 4.50% discount rate across that specific timeframe against the $50,000 base. It calculates the required capital appreciation to satisfy that rate and outputs the highly precise absolute decimal integer: 51,137.50.
This provides absolute mathematical proof that your initial $50,000 investment will result in a final cash payout of exactly $51,137.50 at maturity.