please attach excel formulas

VALUING HOUDA MOTORS 22.000.000 2 Base year FCF 4 High growth rate Oy 5 Normal growth rate, 6 Number of Nghgrowth years 7 Term 1 factor: (+9.M[1+WACC) 9 WACC 10 Det 11 Cash #NAME? NAME? INAME? NAME? ANAME? INAME? INAME? #NAME? 13 Term 1: PV of high-growth cash flows 14 Term 2 PV of normal growth cash flows 15 Enterprise valu 16 Add cash 17 Subtract det 18 Value of equity NAME? INAME? NAME? INAME? 20 Number of shares, and 200 21 Share NAME? 24 cash flows occur in mid-year, there 25 Value of equity NAME? NAME? NRRRRRRRRRRRRRRR99939808985088 3. (DCF valuation) Houda Motors has a just announced results that show that the FCF for the past year is $23 million. An experienced analyst believes that the growth rate of the FCF for the next 10 years will be 25% per year and that after 10 years the growth rate will be 7% annually. Houda's WACC is 18%, and the company has 100 million shares outstanding. a. Value the shares assuming that the FCFs occur at year-end. Houda has no debt and no excess cash reserves. b. Suppose that the FCFs occur in mid-year. What would your answer be now