Purchase Solution

NPV of Bond Refunding: Reasons for Growth in Government

Not what you're looking for?

Ask Custom Question

Need help with a problem in Excel using goal seek function. Any help would be appreciated.

Attachments
Purchase this Solution
Solution Summary

Calculates NPV of a bond refunding decision and calculates the break even coupon rate using Goal Seek function in Excel. The Excel document required is attached.

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

View More Free Quizzes
Related BrainMass Solutions

  • Bond-refunding problem and capital budgeting

    Corporate bonds allow for a lot of flexiblity in design, and so give rise to the greatest variety. The NPV of refunding compares the interest savings benefit with the costs of the refunding.

  • Discussing Bond Refunding

    NPV = Benefits (savings in interest) - Cost (refunding costs and call premium) For Bond 1, the savings in interest is 1% or 750,000 per year. The present value is 750,000/7%=10,714,285 (since it is a perpetual bond, the PV is amount/rate).

  • Bond refunding

    NPV = Benefits (savings in interest) - Cost (refunding costs and call premium) For Bond 1, the savings in interest is 1% or 750,000 per year. The present value is 750,000/7%=10,714,285 (since it is a perpetual bond, the PV is amount/rate).

  • Bond refunding

    336203 Bond refunding: NPV Please show steps. A firm is considering the refunding of an outstanding 30-year bond issue.

  • Bond Pricing and Refunding Analysis

    In terms of the refunding decision, how should Barton be influenced if he thinks interest rates might go down even more? A. First compute the price of the old bonds in the open market. Use the valuation procedures for a bond (Use annual analysis).

  • Bond Refunding Analysis for Mullet Technologies

    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% annually during the interim period. a. Perform a complete bond refunding analysis.

  • Bond refunding

    For the Bond Refunding NPV inputs, the Initial Outlay = Total-After Tax Investment. The PV of Flotation Costs is the number you calculated in cell D54. The PV of Interest Savings is the number you calculated in cell I54. 16.

  • Net Present Value of a City's Refunding

    The NPV of the bond refunding = Inflows - Outflow =693,443-240,000=453,443 The solution explains how to calculate the net present value of refunding in displayed calculations.

  • Description of Bond refunding

    The PV of interest savings is 20,000X3.79079=75,816. The NPV of the bond refunding is Inflows - Outflow =75,816-60,000=$15,816 The solution explains the evaluation of a bond refunding decision.

View More Related Solutions