In: Finance
EXCEL TEMPLATE) Watchstone Concrete Products issued 30-year maturity bonds 15 years ago with a coupon rate of 10.75%. The principal amount was $15,000,000. Interest rates have steadily decreased and the company could issue new bonds today at a coupon rate of 9.50%. The new issue would be used to pay off the old bonds and would have a maturity of 15 years. The original issue had flotation costs of $375,000 which were set up on an amortization schedule over 30 years with equal amounts each year. The old bonds are callable with a premium of 4.5%. An investment banking firm would charge a flotation fee of $225,000 on the new issue that would be amortized over the life of the new bonds. Rover’s marginal tax rate is 25%. Calculate the NPV of the bond refund
a.Old and nwe Bond Principal?
b.Old and new Bond Interest Rate?
c.Old and new Bond Flotation Cost?
d.Old and new Bond Maturity (Years)?
e.Tax Rate?
f.Call Premium Rate?
Step 1: Incremental Initial flow
Raise the fund | 15,000,000 |
Repay the old bond | (15,000,000) |
Floatation cost on new bond | (225,000) |
Call Premium (15,000,000*4.5%) | (675,000) |
Tax saved on call premium (675,000*25%) | 168,750 |
Tax saved on unamortised portion of floatation cost of old bond (WN 1) | 46,875 |
Sum (684,375)
Step 2: Incremental inbetween flows
Payment of interest in new bond (15,000,000*9.5%) | (1,425,000) |
Tax saved on above @25% | 356,250 |
old interest saved (15,000,000*10.75%) | 1,612,500 |
Tax lost on old interest @25% | (403,125) |
Tax saved on floatation cost of new bond (WN 2) | 3,750 |
Tax lost on floatation cost of old bond (12,500*25%) | (3,125) |
sum 141,250
Step 3: Incremental terminal flow
Repayment of new bond | (15,000,000) |
Savings in repayment of old bond | 15,000,000 |
Sum 0
Step 4: Calculation of NPV
In the absence of discount rate being given, the coupon rate associated with new bond is the pre tax discount rate. So post tax discount rate=9.5%(no tax here)
Year | Cashflow | [email protected]% | Cashflow*PVF |
0 | (684,375) | 1 | -684375.00 |
1-15 | 141,250 | 7.8282 | 1105733.25 |
15 | - | 0.2563 | 0.00 |
NPV = PV of Inflows - PV of outflows
= 1105733.25-684375
= 421358.25
Decision: Since the NPV is positive, refund the bonds.