Question: **Please solve the problem using excel and show all formulas used in the excel** The following are projected free cash flows to equity for the

**Please solve the problem using excel and show all formulas used in the excel** **Please solve the problem using excel and show all formulas used

The following are projected free cash flows to equity for the ABM CO. That is expected to be in high growth for the next 3 years. The firm's beta is also expected to change over the 3-year period: Year Expected Growth Rate Beta Revenues EPS - (Cap Ex - Deprec'n) (1-DR) - Change in WC (1 - DR) FCFE $ $ $ $ $ 1 12% 1.5 22.40 $ 2.24 $ 0.90 $ 0.36 $ 0.98 $ 2 10% 1.3 24.64 $ 2.46 $ 0.75 $ 0.33 $ 1.38 $ 3 8% 1.1 26.61 2.66 0.60 0.29 1.77 4 6% 1.0 $28.21 $2.82 $0.45 $0.24 $2.13 Assume that after year 3, the beta will stay at 1.00, and that the growth rate will remain 6% forever. The riskfree rate is 5%, and you can assume a risk premium of 5.5%. a. Estimate the price at the end of the third year. b. Estimate the value per share today

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!