Excel Online Structured ActivityNeca Currently, Forever Flowers Inc. has a capital structure consisting of 25% debt and 75% equity, Forever's debt currently has an 7% yleld to maturity. The risk-free rate () is 4%, and the market risk premium (Pop) is 4%. Using the CAPM, Forever estimates that its cost of equity is currently 14%. The company has a 40% tax rate. The data has been collected in the Microsoft Excel Online fille below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round Intermediate calculations Open spreadsheet a. What is Forever's current WACC Round your answer to two decimal places b. 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 answ 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 e. What would be the company's new WACC if it adopted the proposed change in capital structure? Round your answer to two decimal places. %% f. Based on your answer to part e, would you advise Forever to adopt the proposed change in capital structure? Excel Online Structured ActivityNeca Currently, Forever Flowers Inc. has a capital structure consisting of 25% debt and 75% equity, Forever's debt currently has an 7% yleld to maturity. The risk-free rate () is 4%, and the market risk premium (Pop) is 4%. Using the CAPM, Forever estimates that its cost of equity is currently 14%. The company has a 40% tax rate. The data has been collected in the Microsoft Excel Online fille below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round Intermediate calculations Open spreadsheet a. What is Forever's current WACC Round your answer to two decimal places b. 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 answ 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 e. What would be the company's new WACC if it adopted the proposed change in capital structure? Round your answer to two decimal places. %% f. Based on your answer to part e, would you advise Forever to adopt the proposed change in capital structure