Please provide the formula in each cell please. Would like to know how you got the answer in excel please. When providing the your screenshot of the excel please if you could screenshot the cells like how I did my screenshot where you see cell A - G and the row numbers as well please.

a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. c. Calculate the estimated Year- 0 price per share of common equity. Value of operations Plus value of narketable securities Total value of company Less value of debt Less value of preferred stock Estimated value of common equity Divided by number of shares Price per share a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. c. Calculate the estimated Year- 0 price per share of common equity. Value of operations Plus value of narketable securities Total value of company Less value of debt Less value of preferred stock Estimated value of common equity Divided by number of shares Price per share