In: Finance
The Robinson Corporation has $32 million of bonds outstanding that were issued at a coupon rate of 11.450 percent seven years ago. Interest rates have fallen to 10.450 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.20 percent of the total bond value. The underwriting cost on the new issue will be 2.10 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. | Discount Rate: | ||||||||||
Interest Rate | 10.45% | ||||||||||
After tax interest cost | 7.32% | (10.45*(1-0.3) | |||||||||
Underwriting cost | 2.10% | ||||||||||
After tax cost of new debt=7.32/(1-0.021) | 7.47% | ||||||||||
Discount Rate: | 8% | ||||||||||
b. | Present Value of Total Outflows: | ||||||||||
Call Premium =8%*32Million= | $2,560,000 | ||||||||||
Underwriting cost =2.1%*32million= | $672,000 | ||||||||||
Present Value of Total Outflows: | $3,232,000.00 | (2560000+672000) | |||||||||
c | Present Value of Total In flows: | ||||||||||
Annual interest payment on old bond | $3,664,000 | (11.45%*32 million) | |||||||||
Annual interest payment on New bond | $3,344,000 | (10.45%*32 million) | |||||||||
Annual Savings before tax | $320,000 | ||||||||||
Pmt | Annual after tax savings | $224,000 | (320000*(1-0.3) | ||||||||
Nper | Number of years | 17 | |||||||||
Rate | Discount Rate | 8% | |||||||||
PV | Present Value of Total In flows: | $2,043,246.94 | (Using PV function of excelwith Rate=8%, Nper=17, Pmt=-224000) | ||||||||
Excel Command: PV(8%,17,-224000) | |||||||||||
d | Net Present value | ($1,188,753.06) | (2043247.94-3232000) | ||||||||