978-1305637108 Build Model Solution Ch18 P09 Build a Model Solution

subject Type Homework Help
subject Pages 3
subject Words 484
subject Authors Eugene F. Brigham, Michael C. Ehrhardt

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
1
2
3
4
5
6
7
8
9
10
11
12
18
19
20
21
22
23
29
30
31
32
33
34
40
41
42
43
44
45
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.
page-pf2
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%
page-pf3
1
2
3
4
5
F G H I J K L M N
7/16/2015

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.