Please help with case study. All work must be done in excel and word (provide excel formulas). Also, provide a complete write up and not just the calculations. The followings are needed for this assignment...

Background and intro to the case scenario

Problems at hand

Case objective

Calculations and analyses explanation

Case decision and your recommendations.

Please see case below and thank you so much for your help!

the corporation could merely call in the bonds The Proposed Refunding Decision at par. Since in this case five years had Gina thought if passed, the call premium would be exactly she could present a cifi he would have a better eight percent. 92 Case 2 Gina knew that the underwriting cost on the old issue was important to the calculations related to the refunding decision. She checked with the chief accountant and found out they had initially been $400,000. a The firm was currently paying taxes at of 30 percent and would use discount rate of 7 percent for bond refunding decisions. 1. Before you do the bond refunding analysis, determine what the Required current price of the old bonds would be for the previously issued bonds in the marketplace. Do the example based on a $1,000 bond using semiannual analysis. As specified in the case, the bonds have 15 years remaining. The interest rate at the time of issue was 11.50 percent, but is now 10 percent. 2. As a result of paying the 8 percent call premium over par instead of the market price determined in question l, how much will the firm save on each old S1,000 bond in reacquiring it? 3. Using the four steps outlined in Chapter 16 of the text for a bond refunding decision, determine whether the potential refunding has a positive net present value. (Round all values to the nearest dollar). 4. Assuming you did your calculations comectly in question 3, you should have gotten a positive net present value. If not, you will want to rerun your numbers. Now assume Gina goes to Al Rosen with these numbers and suggests they do the refunding because there i a positive net present value. What is an additional important consideration that Gina and Al must consider before they go ahead with the refunding and all the associated costs? 5. Assume that before Warner Motor Oil Company can get the refunding completed, interest rates on new 15 year bonds goes up to 10.4 percent. Assume all other numbers previously given are the same, should the refunding be undertaken