70.2K

Verified Solution

Link Copied!

Excel Online Structured Activity: Convertible Bond Analysis

Niendorf Incorporated needs to raise $25 million to construct production facilities for a new type of USB memory device. The firm's straight nonconvertible debentures currently yield 8.5%. Its stock sells for $23.00 per share, has an expected constant growth rate of 7.0%, and has an expected dividend yield of 7%, for a total expected return on equity of 14%. Investment bankers have tentatively proposed that the firm raise the $25 million by issuing convertible debentures. These convertibles would have a $1,000 par value, carry a coupon rate of 7.5%, have a 20-year maturity, and be convertible into 34 shares of stock. Coupon payments would be made annually. The bonds would be noncallable for 5 years, after which they would be callable at a price of $1,075; this call price would decline by $5 per year in Year 6 and each year thereafter. For simplicity, assume that the bonds may be called or converted only at the end of a year, immediately after the coupon and dividend payments. Also assume that management would call eligible bonds if the conversion value exceeded 20% of par value (not 20% of call price).

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

1. At what year do you expect the bonds will be forced into conversion with a call? Do not round your intermediate calculations. Round your answer up to the nearest whole number.

   at Year_____

   What is the bond's value in conversion when it is converted at this time? Do not round your intermediate calculations. Round your answer to the nearest cent.

   $______

   What is the cash flow to the bondholder when it is converted at this time (Hint: The cash flow includes the conversion value and the coupon payment, because the conversion occurs immediately after the coupon is paid.) Do not round your intermediate calculations. Round your answer to the nearest cent.

   $_______

2. What is the expected rate of return (i.e., before-tax component cost) on the proposed convertible issue? Do not round your intermediate calculations. Round your answer to two decimal places.

   _______%

Answer & Explanation Solved by verified expert

See Answer