PRICEMAT
Returns the price per $100 face value of a security that pays interest at maturity.
FinancialFinance & Accounting
What it does
Calculates price of a bond paying interest at maturity.
Syntax
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.issue(date) — Issue date.rate(number) — Interest rate.yld(number) — Yield.
Examples
Price at Maturity
Calculate price.
FORMULA
=PRICEMAT(B2, C2, A2, 0.05, 0.06)
RESULT
99.5
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Iss | Set | Mat |
| 2 | 2023-01-01 | 2023-06-01 | 2024-01-01 |