Excel Online Structured Activity: Recapitalization Currently, Forever Flowers Inc has a capital structure consisting of 35% debt and 6 equity Forever debt currently has an 74 yield to maturity. The risk free rate C 6% and the market risk premium ( Mis 49. Using the CAPM. Forever estimates that is cost of equity is currently 11.59. The company has a 40% tax rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations X1 Open spreadsheet .. What is Forever's current WACC? Round your answer to two decimal places What is the current bets on Forever's common stock? Round your answer to two decimal places c. What would Forever's beta be if the company had no debt in its capital structure? (That is what is Forever's unlevered beta, bu) Round your answer to two decimal places Forever's financial staff is considering changing its capital structure to 40% debt and 60% equity. If the company went ahead with the proposed change, the yield to maturity on the company's bonds would rise to 9.5%. The proposed change will have no effect on the company's tax rate. d. What would be the company's new cost of equity if it adopted the proposed change in capital structure? Round your answer to two decimal places d. What would be the company's new cost of equity fit adopted the proposed change in capital structure Round your answer to two deomar places % e. What would be the company's new WACC It adopted the proposed change in capital structure? Round your answer to two decimal places Based on your answer to parte, would you advise Forever to adopt the proposed change in capital structure? B C D E 3 4 35.00% 65.00% 7.00% 6.00% 4.00% 11.50% 40.00% 1 Recapitalization 2 % debt in original capital structure, W. 4 % common equity in original capital structure, W. 5 Yield to maturity on debt, I'd 6 Risk-free rate, IRF 7 Market risk premium (RF) 8 Cost of common equity.rs 9 Tax rate 10 11 % debt in new capital structure, Wd New 12 % common equity in new capital structure, We New 13 Changed yield to maturity on debt. Id New 14 15 Current WACC calculation: 16 WACC 17 18 Current beta calculation: 19 Levered beta, bu 40.00% 60.00% 9.50% Formulas NA #N/A 20 ANA 21 Unlevered beta calculation: 22 bu 23 24 Cost of equity calculation with changed capital structure: 25 Levered beta, 26 Cost of equity with new capital strucutre, Is New 27 28 WACC calculation with new capital structure: ANA #N/A 29 WACC ww #N/A 30 31 Recommendation on capital structure: 32 Change or Do Not Change 32 34 #N/A