Question

In: Finance

Excel Online Structured Activity: Recapitalization Currently, Forever Flowers Inc. has a capital structure consisting of 25%...

Excel Online Structured Activity: Recapitalization

Currently, Forever Flowers Inc. has a capital structure consisting of 25% debt and 75% equity. Forever's debt currently has an 7% yield to maturity. The risk-free rate (rRF) is 4%, and the market risk premium (rM - rRF) is 5%. Using the CAPM, Forever estimates that its cost of equity is currently 12%. 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.

Open spreadsheet

  1. What is Forever's current WACC? Round your answer to two decimal places.

    %

  2. What is the current beta on Forever's common stock? Round your answer to two decimal places.

  3. 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 10%. The proposed change will have no effect on the company's tax rate.

  4. 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.

    %

  5. What would be the company's new WACC if it adopted the proposed change in capital structure? Round your answer to two decimal places.

    %

  6. Based on your answer to part e, would you advise Forever to adopt the proposed change in capital structure?

    _____YesNo

Check My Work

Reset Problem

Solutions

Expert Solution


Related Solutions

Excel Online Structured Activity: Recapitalization Currently, Forever Flowers Inc. has a capital structure consisting of 20%...
Excel Online Structured Activity: Recapitalization Currently, Forever Flowers Inc. has a capital structure consisting of 20% debt and 80% equity. Forever's debt currently has an 9% yield to maturity. The risk-free rate (rRF) is 6%, and the market risk premium (rM - rRF) is 8%. Using the CAPM, Forever estimates that its cost of equity is currently 12%. The company has a 40% tax rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet...
Currently, Forever Flowers Inc. has a capital structure consisting of 30% debt and 70% equity. Forever's...
Currently, Forever Flowers Inc. has a capital structure consisting of 30% debt and 70% equity. Forever's debt currently has an 7% yield to maturity. The risk-free rate (rRF) is 4%, and the market risk premium (rM- rRF) is 8%. Using the CAPM, Forever estimates that its cost of equity is currently 12%. 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...
Currently, Forever Flowers Inc. has a capital structure consisting of 30% debt and 70% equity. Forever's...
Currently, Forever Flowers Inc. has a capital structure consisting of 30% debt and 70% equity. Forever's debt currently has an 8% yield to maturity. The risk-free rate (rRF) is 3%, and the market risk premium (rM - rRF) is 4%. Using the CAPM, Forever estimates that its cost of equity is currently 14.5%. 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...
Currently, Forever Flowers Inc. has a capital structure consisting of 20% debt and 80% equity. Forever's...
Currently, Forever Flowers Inc. has a capital structure consisting of 20% debt and 80% equity. Forever's debt currently has an 9% yield to maturity. The risk-free rate (rRF) is 6%, and the market risk premium (rM - rRF) is 8%. Using the CAPM, Forever estimates that its cost of equity is currently 12%. 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...
36. Currently, Bloom Flowers Inc. has a capital structure consisting of 20% debt and 80% equity....
36. Currently, Bloom Flowers Inc. has a capital structure consisting of 20% debt and 80% equity. Bloom’s debt currently has an 8.5% yield to maturity. The risk-free rate (rRF) is 4.3%, and the market risk premium (rM – rRF) is 7%. Using the CAPM, Bloom estimates that its cost of equity is currently 16%. The company has a 33% tax rate. Bloom’s financial staff is considering changing its capital structure to 40% debt and 60% equity. If the company went...
Excel Online Structured Activity: Foreign capital budgeting Sandrine Machinery is a Swiss multinational manufacturing company. Currently,...
Excel Online Structured Activity: Foreign capital budgeting Sandrine Machinery is a Swiss multinational manufacturing company. Currently, Sandrine's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar-denominated cash flows consist of an initial investment of $2000 and a cash inflow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 12%. Currently, 1 U.S. dollar will buy 0.82 Swiss franc. In addition, 1-year risk-free securities in the United States are...
Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently needs to retain...
Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $1.00 coming 3 years from today. The dividend should grow rapidly - at a rate of 43% per year - during Years 4 and 5; but after Year 5, growth should be a constant 9% per year. The data has been...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $18,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance...
Excel Online Structured Activity: WACC and optimal capital budget Adamson Corporation is considering four average-risk projects...
Excel Online Structured Activity: WACC and optimal capital budget Adamson Corporation is considering four average-risk projects with the following costs and rates of return: Project Cost Expected Rate of Return 1 $2,000 16.00% 2 3,000 15.00 3 5,000 13.75 4 2,000 12.50 The company estimates that it can issue debt at a rate of rd = 11%, and its tax rate is 35%. It can issue preferred stock that pays a constant dividend of $6 per year at $47 per...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 30% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 30.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT