Question

Suppose your company needs to raise $36.2 million and you want to issue 22-year bonds for this purpose. Assume the required return on your bond issue will be 8.7 percent, and you’re evaluating two issue alternatives: an 8.7 percent semiannual coupon bond and a zero coupon bond. Your company’s tax rate is 35 percent. Both bonds would have a face value of $1,000.

a. How many of the coupon bonds would you need to issue to raise the $36.2 million? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

I was able to find the number of coupon bonds, which is: 36200

How many of the zeroes would you need to issue? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Number of zero coupon bonds would be: 235709.19

I need help with the following portion of the question (B & C):

b. In 22 years, what will your company’s repayment be if you issue the coupon bonds? (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Coupon bonds repayment $

What if you issue the zeroes? (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Zero coupon bonds repayment $

c. Assume that the IRS amortization rules apply for the zero coupon bonds. Calculate the firm’s aftertax cash outflows for the first year under the two different scenarios. (Input a cash outflow as a negative value and a cash inflow as a positive value. Enter your answers in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Coupon bond cash flow $

Zero coupon bond cash flow $

Answer 1

I have answered the question below using excel and have attached the image below.

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer: