3-4
PPT Bond Price Table (Table 10-1)
Perspective 10-2: Table 10-1 illustrates the impact of differences between yield to maturity
and coupon rates on bond prices and reinforces the inverse relationship between bond prices and
required yield to maturity.
2. The impact of the change in required rate of return on the bond price is
dependent upon the remaining time to maturity. The impact will be greater as
the time to maturity increases.
PPT Impact of Time to Maturity on Bond Prices (Table 10-2)
Perspective 10-3: Table 10-2 shows the critical effect of time to maturity on bond price
sensitivity. The longer the time to maturity, the bigger the change in bond price.
PPT Relationship between Time to Maturity and Bond Price (Figure 10-2)
Perspective 10-4: The critical effect of time to maturity on bond price sensitivity is further
supported by this figure.
F. Determining yield to maturity from the bond price
1. If the bond price, interest rate on the bond, and number of years to maturity
2. The yield to maturity can most easily be found using a financial calculator.
The keystrokes are as follows:
N Number of years to maturity
PV Present value of the bond (current bond price)
3. The yield to maturity can also be found by using the Goal Seek function in
Excel. The Goal Seek function can be found in the most recent version of
PPT Finding the Goal Seek Function in Excel (Figure 10-3)