In order to understand yield to maturity (YTM), we first need to discuss how you price a bond in general.  The price of a traditional bond is the present value of all future cash flows the bond delivers (interest payments), plus the repayment of principal (the face value or par value) at maturity. The rate used to discount these cash flows and principal is called the required rate of return, which is the rate of return required by investors considering the risk of the investment.  

How to Price a Bond

The formula to price a traditional bond is: 

  • PV = Payment / (1+r)+ Payment / (1+r)+ ... + Payment + Principle / (1+r)+


  • PV = price of the bond
  • Payment = coupon payment, which is the coupon rate * par value ÷ number of payments per year
  • r = required rate of return, which is required rate of return ÷ number of payments per year
  • Principal = par value/face value of the bond
  • N = number of years until maturity

The pricing of a bond is therefore critically dependent on the difference between the coupon rate (which is known) and the required rate which is inferred.

Suppose the coupon rate is on a $100 bond is 5%, meaning the bond pays $5 per year, and the required rate – given the risk of the bond – is 5%. Because they are equal, the bond will be priced at par, or $100.  

This is shown below (note: if tables are hard to read, please right-click and choose "view image"):

Pricing a Bond After It's Issued

Bonds trade at par when they are first issued. Frequently, the coupon rate and required return don't match in the subsequent months and years, as events impact the interest rate environment. When the two rates don't match, it causes the price of the bond to appreciate above par (trade at a premium to its face value) or decline below par (trade at a discount to its face value) to compensate for the difference in rates.

Take the same bond as above (5% coupon, pays out $5 a year on $100 principal) with five years left until maturity.  The current Federal Reserve rate is 1%, and other similar-risk bonds are at 2.5% (they pay out $2.50 a year on $100 principal). So, this bond is very attractive: offering 5% in interest, double that of comparable debt instruments.

Given this, the market will adjust the price of the bond proportionally to reflect this difference in rates. In this case, the bond would trade at a premium, $111.61.  The current price of 111.61 is higher than the $100 you will receive at maturity, and that $11.61 is the difference in present value of the extra cash flow you get over the life of the bond (the 5% vs. the required return of 2.5%).  

In other words, in order to get that 5% interest when all other rates are much lower, you have to buy something today for $111.61 that you know in the future will only be worth $100.  The rate that normalizes this difference is the yield to maturity. 

Calculating the Yield to Maturity in Excel


The above examples break out each cash flow stream by year.  This is a good method for most financial modeling because best practices dictate that the sources and assumptions of all calculations should be easily auditable.  

However, when it comes to pricing a bond, we can make an exception to this rule because:

  • Some bonds have many years (decades) to maturity and a yearly analysis, like that shown above, may not be practical
  • Most of the info is known, and fixed: We know the par value, we know the coupon, we know the years to maturity, etc.  

For these reasons, we'll set up the calculator as shown below:

In the above example, we made the scenario slightly more realistic by using two coupon payments per year, which is why the YTM is 2.51%, slightly above the required rate of return of 2.5% in the first examples.  



  1. Should investors focus more on the current yield or face value of a bond?

    Find out when investors should focus on a bond's current yield versus its face value, including an example of how current ... Read Answer >>
  2. How does the effective interest method treat the interest on a bond?

    Find out why you should look at the effective interest of a bond rather than simply relying on its stated coupon rate when ... Read Answer >>
  3. How do debit spreads impact the trading of options?

    Find out what it means when a bond has a coupon rate of zero and how a bond's coupon rate and par value affect its selling ... Read Answer >>
Related Articles
  1. Investing

    Comparing Yield To Maturity And The Coupon Rate

    Investors base investing decisions and strategies on yield to maturity more so than coupon rates.
  2. Financial Advisor

    Using Excel PV Function to compute Bonds PV

    To determine the value of a bond today - for a fixed principal (par value) to be repaid in the future at any predetermined time - we can use an Excel spreadsheet.
  3. Investing

    An Introduction to Individual Bonds

    Individual bonds are better than bond funds and can be a key component to one’s investment strategy.
  4. Investing

    Top 6 Uses For Bonds

    We break down the stodgy stereotype to see what these investments can do for you.
  5. Managing Wealth

    How Bond Prices and Yields Work

    Understanding bond prices and yields can help any investor in any market.
  6. Investing

    How Do I Calculate Yield To Maturity Of A Zero Coupon Bond?

    Yield to maturity is a basic investing concept used by investors to compare bonds of different coupons and times until maturity.
  7. Investing

    Understanding Face Value

    Face value is the dollar value stated on a security.
  1. Discount Bond

    A discount bond is a bond that is issued for less than its par ...
  2. Zero-Coupon Bond

    A zero-coupon bond is a debt security that doesn't pay interest ...
  3. Yield To Maturity (YTM)

    Yield to maturity (YTM) is the total return expected on a bond ...
  4. Bond

    A bond is a fixed income investment in which an investor loans ...
  5. Current Yield

    Annual income (interest or dividends) divided by the current ...
  6. Pull To Par

    The movement of a bond's price toward its face value as it approaches ...
Hot Definitions
  1. Retirement Planning

    Retirement planning is the process of determining retirement income goals and the actions and decisions necessary to achieve ...
  2. Drawdown

    The peak-to-trough decline during a specific record period of an investment, fund or commodity. A drawdown is usually quoted ...
  3. Inverse Transaction

    A transaction that can cancel out a forward contract that has the same value date.
  4. Redemption

    The return of an investor's principal in a fixed income security, such as a preferred stock or bond; or the sale of units ...
  5. Solvency

    The ability of a company to meet its long-term financial obligations. Solvency is essential to staying in business, but a ...
  6. Dilution

    A reduction in the ownership percentage of a share of stock caused by the issuance of new stock. Dilution can also occur ...
Trading Center