Question

An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.9%. Bond C pays a 10% annual coupon, while Bond Z is a zero coupon bond. Assuming that the yield to maturity of each bond remains at 8.9% over the next 4 years, calculate the price of the bonds at each of the following years to maturity.
Years to Maturity Price of Bond C Price of Bond Z
4 $ $
3 $ $
2 $ $
1 $ $
0 $ $

Answer 1

Answer:

Years to maturity       Price of Bond C            Price of Bond Z

         4                               $1,084.42                       $711.03

         3                               $1,065.93                       $774.31

         2                               $1,045.80                      $843.23

         1                                $1,023.88                       $918.27

Explanation:

Note: See the attached excel for the calculations of the prices of Bond C and Bond Z.

The price of each bond of the bond can be calculated using the following excel function:

Bond price = -PV(rate, NPER, PMT, FV) ........... (1)

Where;

rate = Yield to maturity of each of the bonds

NPER = Years to maturity

PMT = Payment = Coupon rate * Face value

FV = Face value

Substituting all the relevant values into equation (1) for each of the Years to Maturity and inputting them into relevant cells in the attached excel sheet, we have:

Years to maturity       Price of Bond C            Price of Bond Z

         4                               $1,084.42                       $711.03

         3                               $1,065.93                       $774.31

         2                               $1,045.80                      $843.23

         1                                $1,023.88                       $918.27

Download xlsx