PRICEDISC
Returns the price per $100 face value of a discounted security.
FinancialFinance & Accounting
What it does
Calculates price of a discounted security (no interest).
Syntax
PRICEDISC(settlement, maturity, discount, redemption, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.discount(number) — Discount rate.redemption(number) — Redemption value.
Examples
Discounted Price
Calculate price.
FORMULA
=PRICEDISC(A2, B2, 0.05, 100)
RESULT
97.5
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2023-07-01 |