DISC
Returns the discount rate for a security.
FinancialFinance & Accounting
What it does
Calculates the discount rate for a security.
Syntax
DISC(settlement, maturity, pr, redemption, [basis])
Arguments
settlement(date) — The security's settlement date.maturity(date) — The security's maturity date.pr(number) — The security's price per $100 face value.redemption(number) — The security's redemption value per $100 face value.
Examples
Calculate Discount
Find the discount rate.
FORMULA
=DISC(A2, B2, 98, 100)
RESULT
0.04
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-01 | 2023-07-01 |