A:

In order to understand yield to maturity (YTM), we first need to discuss how toÂ 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)1Â +Â Payment / (1+r)2Â + ... +Â Payment + Principle / (1+r)nÂ +

where:

• 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 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. If 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), this bond looks 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 information is knownÂ and fixed: we know the par value, we know the coupon, and we know the years to maturity.

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

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 above.

RELATED FAQS
1. ### When is a bond's coupon rate and yield to maturity the same?

Find out when a bond's yield to maturity is equal to its coupon rate, and learn about the components of bonds and how they ... Read Answer >>
2. ### What is the difference between yield to maturity and the coupon rate?

A bond's coupon rate is the actual amount of interest income earned on the bond each year based on its face value. Read Answer >>

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 >>
4. ### How a bond's face value differs from its price

Discover how bonds are traded as investment securities and understand the various terms used in bond trading, including par ... Read Answer >>
Related Articles
1. Investing

### Simple Math for Fixed-Coupon Corporate Bonds

A guide to help to understand the simple math behind fixed-coupon corporate bonds.
2. Investing

### 4 basic things to know about bonds

Learn the basic lingo of bonds to unveil familiar market dynamics and open to the door to becoming a competent bond investor.
3. Investing

Corporate bonds can provide compelling returns, even in low-yield environments. But they are not without risk.
4. Managing Wealth

### How Bond Prices and Yields Work

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

### Top 6 Uses For Bonds

We break down the stodgy stereotype to see what these investments can do for you.
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

### Why Bond Prices Fall When Interest Rates Rise

Never invest in something you donâ€™t understand. Bonds are no exception.
RELATED TERMS
1. ### Bond Valuation

Bond valuation is a technique for determining the theoretical ...
2. ### Bond Discount

Bond discount is the amount by which the market price of a bond ...
3. ### Current Yield

The current yield is calculated by dividing an investment's, ...
4. ### Discount Bond

A discount bond is a bond that is issued for less than its par ...
5. ### Below Par

Below par is a term describing a bond whose market price is below ...
6. ### Straight Bond

A straight bond is a bond that pays interest at regular intervals, ...
Hot Definitions
1. ### Leverage

Leverage results from using borrowed capital as a source of funding when investing to expand the firm's asset base and generate ...
2. ### Financial Risk

Financial risk is the possibility that shareholders will lose money when investing in a company if its cash flow fails to ...
3. ### Enterprise Value (EV)

Enterprise Value (EV) is a measure of a company's total value, often used as a more comprehensive alternative to equity market ...
4. ### Relative Strength Index - RSI

Relative Strength Indicator (RSI) is a technical momentum indicator that compares the magnitude of recent gains to recent ...
5. ### Dividend

A dividend is a distribution of a portion of a company's earnings, decided by the board of directors, to a class of its shareholders.
6. ### Inventory Turnover

Inventory turnover is a ratio showing how many times a company has sold and replaces inventory over a period.