YIELD
Returns the yield on a security that pays periodic interest.
FinancialFinance & Accounting
What it does
Calculates yield of a bond.
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Arguments
settlement(date) — Settlement.maturity(date) — Maturity.rate(number) — Coupon rate.pr(number) — Price.redemption(number) — Redemption.frequency(number) — Freq.
Examples
Bond Yield
Calculate yield.
FORMULA
=YIELD(A2, B2, 0.05, 95, 100, 2)
RESULT
0.056
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2030-01-01 |