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