I need help answer the question below. I am unable to upload the excel spreadsheet so I provided a link to google drives where I saved it .

https://drive.google.com/file/d/1mUN1ZGQ18lkqn23CwD7SE-cvl-e3GIu2/view?usp=sharing

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 9%. Its stock sells for $21.00 per share, has an expected constant growth rate of 6.0%, and has an expected dividend yield of 7%, for a total expected return on equity of 13%. 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 8.0%, have a 20-year maturity, and be convertible into 33 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).

a.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 Yearfill in the blank 2

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.

$fill in the blank 3

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.

$fill in the blank 4

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

fill in the blank 5%