- Please Show Me How To Solve It In Excel Step By Step 1 (60.58 KiB) Viewed 41 times
Please show me how to solve it in Excel step by step.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Please show me how to solve it in Excel step by step.
Please show me how to solve it in Excel step by step.
Weston Enterprises is an all-equity firm with two divisions. The soft drink division has an asset beta of 0.68, expects to generate free cash flow of $55 million this year, and anticipates a 3% perpetual growth rate. The industrial chemicals division has an asset beta of 1.04, expects to generate free cash flow of $70 million this year, and anticipates a 2% perpetual growth rate. Suppose the risk-free rate is 2% and the market risk premium is 4%. a. Estimate the value of each division. b. Estimate Weston's current equity beta and cost of capital. Is this cost of capital useful for valuing Weston's projects? How is Weston's equity beta likely to change over time?
Weston Enterprises is an all-equity firm with two divisions. The soft drink division has an asset beta of 0.68, expects to generate free cash flow of $55 million this year, and anticipates a 3% perpetual growth rate. The industrial chemicals division has an asset beta of 1.04, expects to generate free cash flow of $70 million this year, and anticipates a 2% perpetual growth rate. Suppose the risk-free rate is 2% and the market risk premium is 4%. a. Estimate the value of each division. b. Estimate Weston's current equity beta and cost of capital. Is this cost of capital useful for valuing Weston's projects? How is Weston's equity beta likely to change over time?