Please show excel formula

1 Part A. Valuing the firm Year $2,527,674.14 $2.584,518.99 $2,648.952.93 16% 4% $3,000,000 1,000,000 3 Free cash flow for the next 3 years 4 Weighted average cost of capital, WACC 5 Long-term growth rate of FCFs, g (since year 4 6 Debt 7 Number of shares Initial cash and marketable 8 securities 9 10 Terminal value 11 Enterprise value 12 Total asset value 13 Equity value 14 Equity value per share 15 $460,000 16 17 Part B. Use Data Table function to calculate equity value per share at different combinations of WACC and long-term growth rate WACC 19 0% growth rate of sales 8% 10% 12% 14% 16%