Yield to maturity (YTM) is the total return you’ll earn if you buy a bond today and hold it until it matures, assuming all coupon payments are reinvested at the same rate. If you are learning how to calculate yield to maturity, it’s important to know that the exact formula is a “trial and error” process because it solves for the interest rate ($r$) that makes the present value of all future cash flows equal to the bond’s current price:
(Where $C$ = coupon payment, $F$ = face value, and $n$ = years to maturity). For a quick estimate, many use the Approximate YTM formula:
Like IRR, YTM has no simple algebraic solution. It must be calculated iteratively or with Excel.
The YTM Formula (Approximation)
For a quick estimate, use the approximation formula:
> YTM ≈ [C + (F − P) / n] / [(F + P) / 2]
Where:
- C = Annual coupon payment (coupon rate × face value)
- F = Face value (par value, typically $1,000)
- P = Current market price of the bond
- n = Years to maturity
Worked Example: Step by Step
Bond details:
- Face value: $1,000
- Coupon rate: 6% (pays $60/year)
- Current market price: $950 (trading at a discount)
- Years to maturity: 5
Using the approximation formula:
> YTM ≈ [$60 + ($1,000 − $950) / 5] / [($1,000 + $950) / 2]
> YTM ≈ [$60 + $10] / [$975]
> YTM ≈ $70 / $975
> YTM ≈ 7.18%
This bond yields approximately 7.18% annually – higher than its 6% coupon rate because you bought it below par and will receive $1,000 at maturity.
Calculating Exact YTM in Excel
=RATE(nper, pmt, pv, fv)
For our example:
=RATE(5, 60, −950, 1000) = 7.13%
Or use the dedicated YTM function:
=YIELD(settlement, maturity, rate, pr, redemption, frequency)
YTM vs Other Bond Yield Measures
| Yield Measure | Formula | What It Captures |
|---|---|---|
| Coupon rate | Annual coupon / Face value | Fixed interest rate on the bond |
| Current yield | Annual coupon / Current price | Income return only; ignores capital gain/loss |
| Yield to maturity | Exact IRR of all cash flows | Total return including capital gain/loss |
| Yield to call | IRR assuming bond is called early | For callable bonds |
Current yield only tells you the income return. If you buy a bond at a discount (below par), you’ll also gain as the price moves toward $1,000 – YTM captures this. If you buy at a premium, YTM will be lower than the current yield.
The Relationship Between Bond Price and YTM
This inverse relationship is fundamental to fixed income:
| Market Condition | Bond Price | YTM |
|---|---|---|
| Interest rates rise | Falls | Rises |
| Interest rates fall | Rises | Falls |
| Bond at par | $1,000 | = Coupon rate |
| Bond at discount | Below $1,000 | > Coupon rate |
| Bond at premium | Above $1,000 | < Coupon rate |
When existing bond prices fall (because new bonds offer higher rates), the YTM on those existing bonds rises to make them competitive.
YTM Limitations
| Limitation | Why It Matters |
|---|---|
| Assumes hold to maturity | If you sell early, actual return differs |
| Assumes coupon reinvestment at YTM | Reinvestment rate may be lower |
| Doesn’t account for taxes | After-tax yield may differ significantly |
| Ignores default risk | YTM assumes all payments are made |
For corporate bonds, credit risk is a major factor – a high YTM may reflect default risk premium, not just return potential.
The Bottom Line
Yield to maturity is the gold standard for comparing bonds – it accounts for price, coupon, and time in one comprehensive return figure. Use Excel’s RATE function for precise calculation, the approximation formula for quick estimates, and always compare YTM across bonds of similar credit quality when making investment decisions.
