Finance Excel Problems

Finance Excel Problems - new 25-year issue at an interest...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Current bond issue information Par value $75,000,000 coupon rate 12% original maturity 30 remaining maturity 25 original flotation costs $5,000,000 Call premium 12% Tax rate 40% New issue information Coupon rate 10.0000% maturity 25 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) 6% a. Perform a complete bond refunding analysis. What is the bond refunding's NPV? Mullet Technologies is considering whether or not to refund a $75 million, 12 percent coupon, 30 year bond issue that was sold 5 years ago. It is amortizing $5 million of flotation costs on the 12 percent bonds over the issue's 30-year life. Mullet's investment bankers have indicated that the company could sell a
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: new 25-year issue at an interest rate of 10 percent in today's market. Neither they nor Mullet's management anticipate that interest rates will fall below 10 percent any time soon, but there is a chance that interest rates will increase. A call premium of 12 percent would be required to retire the old bonds, and flotation costs on the new issue would amount to $5 million. Mullet'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 6 percent annually during the interim period. A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31...
View Full Document

Ask a homework question - tutors are online