As an investor, you are considering an investment in the bonds of the Conifer Coal Company. The
Question:
As an investor, you are considering an investment in the bonds of the Conifer Coal Company. The bonds, which pay interest semiannually, will mature in eight years, and have a coupon rate of 9.5% on a face value of $1,000. Currently, the bonds are selling for $872.
a. If your required return is 11% for bonds in this risk class, what is the highest price you would be willing to pay?
(Note: use the PV function.)
b. What is the yield to maturity on these bonds if you purchase them at the current price? (Note: use the RATE function.)
c. If the bonds can be called in three years with a call premium of 4% of the face value, what is the yield to call on these bonds? (Note: use the RATE function.)
d. Now assume that the settlement date for your purchase would be 7/30/2004, the maturity date is 7/28/2012, and the first call date is 7/29/2007. Using the PRICE and YIELD functions recalculate your answers to Parts
a, b, and c.
e. If market interest rates remain unchanged, do you think it is likely that the bond will be called in three years? Why or why not?
f. Create a chart that shows the relationship of the bondís price to your required return. Use a range of 0% to 15% in calculating the prices. L01
Step by Step Answer:
Financial Analysis With Microsoft Excel 2002
ISBN: 9780324178241
3rd Edition
Authors: Timothy R. Mayes, Todd M. Shank