In: Finance
The Robinson Corporation has $39 million of bonds outstanding that were issued at a coupon rate of 12.150 percent seven years ago. Interest rates have fallen to 11.150 percent. Mr. Brooks, the Vice-President of Finance, does not expect rates to fall any further. The bonds have 17 years left to maturity, and Mr. Brooks would like to refund the bonds with a new issue of equal amount also having 17 years to maturity. The Robinson Corporation has a tax rate of 30 percent. The underwriting cost on the old issue was 3.90 percent of the total bond value. The underwriting cost on the new issue will be 2.40 percent of the total bond value. The original bond indenture contained a five-year protection against a call, with a call premium of 9 percent starting in the sixth year and scheduled to decline by one-half percent each year thereafter. (Consider the bond to be seven years old for purposes of computing the premium.) Use Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. Assume the discount rate is equal to the aftertax cost of new debt rounded up to the nearest whole percent (e.g. 4.06 percent should be rounded up to 5 percent)
a. Compute the discount rate. (Do not round intermediate
calculations. Input your answer as a percent rounded up to the
nearest whole percent.)
b. Calculate the present value of total
outflows. (Do not round intermediate calculations and round
your answer to 2 decimal places.)
c. Calculate the present value of total
inflows. (Do not round intermediate calculations and round
your answer to 2 decimal places.)
d. Calculate the net present value.
(Negative amount should be indicated by a minus sign. Do
not round intermediate calculations and round your answer to 2
decimal places.)
a. Compute the discount rate. (Do not round intermediate calculations. Input your answer as a percent rounded up to the nearest whole percent.)
Characteristics of new bond:
Face Value, FV = $ 39 mn = $ 39,000,000
Annual payment = Coupon = 11.150% = 11.15% x 39,000,000 = $ 4,348,500
Market value, PV = FV - Underwriting cost = 39,000,000 x (1 - 2.4%) = $ 38,064,000
Period = 17 years
Yield to maturity = y = RATE(Period, payment, PV, FV) = RATE(17, 4348500, 38064000, 39000000) = 11.48%
Tax rate = T = 30%
After tax cost of new debt = y x (1 - T) = 11.48% x (1 - 30%) = 8.03% = 9% (rounded up to the nearest whole percent)
Discount rate, R = 9%
Please enter your answer as 9%.
b. Calculate the
present value of total outflows. (Do not round intermediate
calculations and round your answer to 2 decimal
places.)
Outflows comprise of following:
Hence NPV of outflows = 2,047,500 + 936,000 + PV of annuity of $ 2,494.85 over 17 years = $ 2,983,500.00 + $ 21,315.10 = $ 3,004,815.10
c. Calculate the
present value of total inflows. (Do not round intermediate
calculations and round your answer to 2 decimal
places.)
Inflows comprise of following:
Hence, NPV of inflows = $ 323,212.50 + $ 2,332,411.36 = $ 2,655,623.86
d. Calculate the net present value. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places.)
NPV = NPV of Inflows - NPV of
outflows = $ 2,655,623.86 - $ 3,004,815.10 = - $
349,191.24