Can you please show work and formulas used? I'd like to actually understand the process. Thank you.

Heavy Metal Corporation is expected to generate the free cash flows in the table below over the next five years. After 5 years, the free cash flows are expected to grow at the industry average of 4% per year. Using the discounted free cash flow model and a weighted average cost of capital of 14% : a. Estimate the enterprise value of Heavy Metal. b. If Heavy Metal has no excess cash, debt of $300 million, and 40 million shares outstanding, estimate its share price. a. Estimate the enterprise value of Heavy Metal. b. If Heavy Metal has no excess cash, debt of $300 million, and 40 million shares outstanding, estimate its share price. quirements 1 In cell D17, by using cell references, calculate the cash flow in year 6 (1 pt.). 2 In cell D18, by using cell references, calculate the value of the company in year 5 (1 pt.). 3 In cell D19, by using cell references, calculate the enterprise value of the company. Note: (1) Use the NPV function for the cash flows from years 1-5. (2) Refer to the present value formula in order to write an expression that computes the present value of the cash flow calculated in cell D18. (1 pt.) 4 In cell D27, by using cell references, calculate the price per share (1 pt.)