Use the sheet to answer the following questions.

Q3) Calculate WACC (Use 2 decimals and no % sign)

Q4) Cacluate the FCFF for the next 5 years and also for the terminal year. What is the PV of the terminal year FCFF? Do not use the $ sign in your answer and no decimals. (For example: 123456)

2018 1 2 3 4 5 Calculate the intrensic value of Schwab. Make sure you Forcast the Free Cash Flow to 5 years 49.98% 34.00% Sales growth% -Use the average of 2017 and 2018 growth rate EBIT Margin % Tax % EBIT(1-T) Depreciation Margin % -Use 2018 margin CAPX Margin % -Use 2018 margin NWC Margin % -Use 2018 margin 1,196.00 11.80% tax 34.00% fcff shares 1280 PV of FCFF Total PV of FCFF beta stock price A2 rf ERP Long Term growth rate 1.32 40.867207 1.50% 1.50% 5.96% 3% PV of TV of FCFF EV -debt +cash Equity debt equity 0 00 00 rd capm intrinsic value current value 40.867207 WACC recommendation Q3 10 points Save Answer Calculate WACC Use 2 decimals and no % sign 04 10 points Save Answer Cacluate the FCFF for the next 5 years and also for the terminal year. What is the PV of the terminal year FCFF? DO not use the $ sign in your answer and no decimals. For example, 123456 2018 1 2 3 4 5 Calculate the intrensic value of Schwab. Make sure you Forcast the Free Cash Flow to 5 years 49.98% 34.00% Sales growth% -Use the average of 2017 and 2018 growth rate EBIT Margin % Tax % EBIT(1-T) Depreciation Margin % -Use 2018 margin CAPX Margin % -Use 2018 margin NWC Margin % -Use 2018 margin 1,196.00 11.80% tax 34.00% fcff shares 1280 PV of FCFF Total PV of FCFF beta stock price A2 rf ERP Long Term growth rate 1.32 40.867207 1.50% 1.50% 5.96% 3% PV of TV of FCFF EV -debt +cash Equity debt equity 0 00 00 rd capm intrinsic value current value 40.867207 WACC recommendation Q3 10 points Save Answer Calculate WACC Use 2 decimals and no % sign 04 10 points Save Answer Cacluate the FCFF for the next 5 years and also for the terminal year. What is the PV of the terminal year FCFF? DO not use the $ sign in your answer and no decimals. For example, 123456