Question: Please solve on excel and include cell equations Houda Motors has just announced results that show that the FCF for the past year is $23

Please solve on excel and include cell equations Houda Motors has justPlease solve on excel and include cell equations

Houda Motors has just announced results that show that the FCF for the past year is $23 million. An experienced analyst believes that the growth rate of FCF for the next 10 years will be 25% per year and that after 10 years the growth rate will stabilize at 7% annually. Houda's WACC is 18% and it has 100 million shares outstanding. (Hint: You can find the FCFs for each year, but you can also value this using only formulas, you've got a fast-growing annuity and then a growing perpetuity as the two components of value here!) PUT YOUR ANSWERS HERE! a) Value the shares assuming that the FCFs occur at year-end. Houda has no debt and no excess cash reserves. b) Re-value the shares assuming that the FCFs occur at mid-year

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!