Mullet Technologies is considering whether or not to refund a $75 million, 13% coupon, 30-year bond issue that was sold 5 years ago. It is amortizing $8 million of flotation costs on the 13% bonds over the issue's 30-year life. Mullet's investmen banks have indicated that the company could sell a new 25-year issue at an interest rate of 9% in today's market. Neither they nor Mullet's management anticipate that interest rates will fall below 9% any time soon, but there is a chance that rates will increase. A call premium of 11% would be required to retire the old bonds, and flotation costs on the new issue would amount to $6 million. Mullet's marginal federal-plus-state tax rate is 30%. The new bonds would be issued 1 month before the old bond are called, with the proceeds being invested in short-term government securities returning 5% annually during the interim period. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. b

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
New bond issue
Coupon rate on new bond issue
Maturity (in years) of new bond issue
Flotation cost on new bond issue
Tax rate
Interest rate on short-term government securities
Number of months new bonds issued before old bonds called
Investment Outlay (After Taxes):
Call premium on old bond issue
Flotation cost on new bond issue
Tax savings on old bond issue flotation cost expense
Additional interest on old bond issue
Interest earned on short-term government securities
Total after-tax investment
Annual Flotation Cost Tax Effects:
Annual tax savings on new issue flotation costs
Annual lost tax savings from old issue flotation costs
Net flotation cost tax savings
Annual Interest Savings Due to Refunding:
Annual interest on old bond issue
Annual interest on new bond issue
Net interest savings
Annual cash flows (flotation cost and interest savings)
NPV of bond refunding decision
$75,000,000
9%
25
$6,000,000
30%
5%
Formulas
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Transcribed Image Text:New bond issue Coupon rate on new bond issue Maturity (in years) of new bond issue Flotation cost on new bond issue Tax rate Interest rate on short-term government securities Number of months new bonds issued before old bonds called Investment Outlay (After Taxes): Call premium on old bond issue Flotation cost on new bond issue Tax savings on old bond issue flotation cost expense Additional interest on old bond issue Interest earned on short-term government securities Total after-tax investment Annual Flotation Cost Tax Effects: Annual tax savings on new issue flotation costs Annual lost tax savings from old issue flotation costs Net flotation cost tax savings Annual Interest Savings Due to Refunding: Annual interest on old bond issue Annual interest on new bond issue Net interest savings Annual cash flows (flotation cost and interest savings) NPV of bond refunding decision $75,000,000 9% 25 $6,000,000 30% 5% Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Mullet Technologies is considering whether or not to refund a $75 million, 13% coupon, 30-year bond issue that was sold 5 years ago. It is amortizing $8 million of flotation costs on the 13% bonds over the issue's 30-year life. Mullet's investment
banks have indicated that the company could sell a new 25-year issue at an interest rate of 9% in today's market. Neither they nor Mullet's management anticipate that interest rates will fall below 9% any time soon, but there is a chance that
rates will increase.
A call premium of 11% would be required to retire the old bonds, and flotation costs on the new issue would amount to $6 million. Mullet's marginal federal-plus-state tax rate is 30%. 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% annually during the interim period.
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
Open spreadsheet
Conduct a complete bond refunding analysis. What is the bond refunding's NPV? Do not round intermediate calculations. Round your answer to the nearest dollar.
$ 20,359,532 X
Transcribed Image Text:Mullet Technologies is considering whether or not to refund a $75 million, 13% coupon, 30-year bond issue that was sold 5 years ago. It is amortizing $8 million of flotation costs on the 13% bonds over the issue's 30-year life. Mullet's investment banks have indicated that the company could sell a new 25-year issue at an interest rate of 9% in today's market. Neither they nor Mullet's management anticipate that interest rates will fall below 9% any time soon, but there is a chance that rates will increase. A call premium of 11% would be required to retire the old bonds, and flotation costs on the new issue would amount to $6 million. Mullet's marginal federal-plus-state tax rate is 30%. 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% annually during the interim period. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet Conduct a complete bond refunding analysis. What is the bond refunding's NPV? Do not round intermediate calculations. Round your answer to the nearest dollar. $ 20,359,532 X
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education