Yield to Maturity (YTM): Definition, Calculations, Meaning, and Excel Examples

Yield to Maturity Definition: The Yield to Maturity (YTM) of a bond is the annualized return an investor will receive if they buy a bond at its current market price and hold it until maturity, assuming the company makes all the required payments, and the investor reinvests the interest payments at the same rate as the overall return.

The YTM measures “what should happen” when an investor buys a bond – but often does not.

In many cases, investors decide to sell bonds early because of changes in the macro environment or the company’s credit profile.

The YTM ignores all these possibilities and assumes that the investor does hold the bond until the official maturity date, at which point, the company repays it in full.

Unlike metrics such as the Current Yield, the Yield to Maturity measures the annualized return over many years.

Unlike metrics such as the Yield to Call or Yield to Worst, the Yield to Maturity assumes NO early repayment.

The Yield to Maturity changes based on the bond’s current market price, its coupon rate, the time until maturity, and the repayment probability – though this probability is assumed to be 100% for healthy companies.

Here’s a simple Excel example for the YTM calculation of a discount bond that trades at $900 vs. a par value of $1,000:

Files & Resources:

Bond Yields – Formulas and Examples (XL)

Yield to Maturity – Calculation Methods (XL)

There are several ways to calculate or approximate the Yield to Maturity, which we’ll describe below:

YTM Formula: How to Calculate the Yield to Maturity in Excel

The easiest method, by far, is to use the YIELD function in Excel, which accounts for all the assumptions mentioned above.

We use this YIELD function in the screenshot shown above, and you can see it directly in the Excel download available on this page.

The assumptions here are as follows:

Bond Price: $900 (vs. par value of $1,000, so it’s trading at a 10% discount)

Coupon Rate: 5% (so, interest payments will be $1,000 * 5% = $50 per year)

Settlement Date (Purchase Date): December 31, 2024

Maturity Date: December 31, 2029 (5-year holding period)

The output is as follows:

The Excel function is:

=YIELD (Settlement Date, Maturity Date, Coupon Rate, Bond Price % Par Value out of Number 100, 100, Coupon Frequency)

The intuition here is that this 10% discount gives investors an “extra boost” over the 5% coupon rate.

Since they hold the bond for 5 years, this 10% discount is spread out over 5 years, and since 10% / 5 = 2%, the annualized return is ~2% higher than 5% (it’s actually closer to ~2.5% higher due to compounding).

YTM Formula: How to Calculate the Yield to Maturity with the IRR Function

Since the Yield to Maturity represents the annualized return on a bond, you can also use the Internal Rate of Return (IRR) function in Excel to calculate it.

However, this approach takes far more time and effort because you must project the cash flows of the bond, including the initial purchase, the interest payments, and the repayment upon maturity.

You can see our setup below:

Just like how the IRR in an LBO model tells you what a PE firm could earn, annualized, on its equity investment in a company, it’s the same principle here with a single bond.

Applying the IRR function to this stream of cash flows confirms that it’s nearly the same as the output from the YIELD function:

YTM Formula: How to Calculate the Yield to Maturity with a Quick Approximation

Another option to calculate YTM is to skip Excel entirely and make a “quick and dirty estimate” using the following formula:

We can apply this formula to the ongoing example here:

Annual Interest = $1,000 * 5% = $50

(Par Value – Bond Price) = $1,000 – $900 = $100

(Par Value + Bond Price) / 2 = ($1,000 + $900) / 2 = $950

Approximate YTM = ($50 + $100 / 5) / $950 = $70 / $950 = ~7.4%

To do the math quickly yourself, you can say: $50 + $100 / 5 = $70.

Then, $950 is “halfway” between $1,000 and $900.

$70 / $1,000 = 7%, so you can say that $70 / $950 is “just above 7%” if you had to answer this question in an interview.

The intuition for this formula is that the top part shows how much interest you are earning each year PLUS the “annualized gain” (if the bond is purchased at a discount) or MINUS the “annualized loss” (if the bond is purchased at a premium).

Then, you divide by the “average price” of the bond in the denominator to reflect how the interest + gain or loss are earned relative to this “average price” over the holding period.

If you compare the numbers in Excel, you’ll see that the approximate YTM is lower than the real YTM:

This happens because of compounding (i.e., when you earn 10% on a $1,000 investment and re-invest it, you now start with $1,100 the next year rather than $1,000 – so the annualized gain or loss is not just a simple percentage divided by the years in the holding period, as the principal keeps increasing over time).

The Excel YIELD and IRR functions account for compounding, but our approximation method does not.

Also, this bond trades at a relative high discount of 10% (it’s a high discount for a healthy, non-distressed company); this method is more accurate when the discount is much lower.

Limitations of the “Approximation Method” for the Yield to Maturity

In general, this trick works best for bonds that trade at a low premium or discount and mature soon (e.g., within ~5 years rather than 10 – 15 years).

The longer the holding period and the greater the discount or premium, the less accurate this formula will be.

For example, if this bond traded at a 50% discount, the YTM approximation would be far less accurate:

Current Yield vs. Yield to Maturity vs. Yield to Call vs. Yield to Worst

These yield metrics all measure the returns an investor can expect to receive on a bond, but they do it in different ways.

–Current Yield: This tells you the percentage investors would earn on a bond if they bought it today and held it for a year, factoring in the market price and the coupon rate on the bond.

–Yield to Maturity: This gives the annualized return investors earn if they buy a bond at its current market price and hold it until maturity, assuming the company makes all the required payments and the investor reinvests the interest payments at the same rate as the overall return.

–Yield to Call: This is similar to the YTM, but investors hold the bond only until an earlier call date, not the maturity date, and also receive some type of penalty fee paid by the company in exchange for this early repayment.

–Yield to Worst: This is the lowest annualized return an investor might receive from buying and holding a bond until either early repayment or maturity, i.e., it is the minimum of all the YTCs and the YTM.