1
2
3
4
5
6
7
8
9
10
11
12
18
19
20
21
22
23
Tax rate 40%
Coupon rate 8.0000%
29
30
31
32
33
34
Initial investment outlay to refund old issue:
Call premium on old issue = 7,000,000.00$
After-tax call premium = 4,200,000.00$
New flotation cost = 5,000,000.00$
Old flotation costs already expensed = 1,200,000.00$
40
41
42
Schumann’s marginal federal-plus-state tax rate is 40 percent. The new bonds would be issued 1 month before the old bonds are called,
with the proceeds being invested in short-term government securities returning 5 percent annually during the interim period.
43
44
45
48
Annual Flotation Cost Tax Effects:
Annual tax savings on new flotation = 90,909.09$
Tax savings lost on old flotation = 60,000.00$
49
50
51
52
A B C D E
Solution
Chapter: 18
Problem: 9
Par value 70,000,000$
Coupon rate 10%
Original maturity 30
Remaining maturity 22
Original flotation costs 4,500,000$
Call premium 10%
Flotation costs 5,000,000$
Time between issuing new bonds and calling old bonds (months) 1
Rate earned on proceeds of new bonds before calling old bonds (annual)
5%
a. Perform a complete bond refunding analysis. What is the bond refunding’s NPV?
Remaining flotation costs to expense = 3,300,000.00$
Tax savings from old flotation costs = 1,320,000.00$ You get to expense the remaining flotation costs
Additional interest on old issue after tax = 350,000.00$ This is interest paid on the old bond issue between when the new bonds are issued and the old bonds are retired
Interest earned on investment in T-bonds after tax = 175,000.00$ This is interest earned on the proceeds from the new bonds before they are used to pay off the old bonds.
Total investment outlay = 8,055,000.00$
Total amortization tax effects = 30,909.09$
Annual interest savings due to refunding:
Annual after tax interest on old bond = 4,200,000.00$
Schumann Shoe Manufacturer is considering whether or not to refund a $70 million, 10% coupon, 30-year bond issue that was sold 8 years
ago. It is amortizing $4.5 million of flotation costs on the 10% bonds over the issue’s 30-year life. Schumann’s investment bankers have
indicated that the company could sell a new 22-year issue at an interest rate of 8 percent in today‘s market. Neither they nor Schumann’s
management anticipate that interest rates will fall below 6 percent any time soon, but there is a chance that interest rates will increase.
53
54
55
56
57
58
59
60
61
62
63
64
65
66
A B C D E
Annual after tax interest on new bond = 3,360,000.00$
Net after tax interest savings = 840,000.00$
Annual cash flows = 870,909.09$
After-tax cost of new debt = 4.80%
NPV of refunding decision = 3,620,740.46$
b. At what interest rate on the new debt is the NPV of the refunding no longer positive?
Use Goal Seek to set cell D60 to zero by changing cell C27.
“Break-even” interest rate = 8.596%
1
2
3
4
5
F G H I J K L M N
7/16/2015