Please make a 2-way data table (using the attached excel data) which calculates the value per share that varies the terminal growth rate and WACC. Please explain the steps on excel for how to make this data table (i do not know how to make a 2-way data table).

Additional info that may be helpful: Sales will grow by 2% each year ? All recurring operating expenses and depreciation are a percent of sales based on 2019 levels. ? The tax rate is 21%.; After year 3 of the forecast, free cash flows will grow by 2%. Assume that working capital is a constant percent of sales based on 2019 levels and capital spending equals depreciation each year. Assume that they will use 50% debt financing and use WACC = 7.40%. There are 40 million shares outstanding.

Here is the excel data from which you will make the table:

Year 2019 Historical 2020 2021 2022 Sales 1000.00 1020.00 1040.40 1061.21 Growth rate 0.02 0.02 0.02 Cost of Goods Sold (50% of Sales) 510.00 520.20 630.60 Gross Profit SG&A Research and Development Gain on sale of assets EBITDA Depreciation EBT Taxes @ 21% EAT 221.20 225.62 230.14 234.74 Working Capital current Assets , Current Liabilities 32070 Less: Increase in Working Capital Cash Flows Terminal value Cash flows in year 2022*(1+g)/(WACCg) 205.84*(1+.O2) / 9409112 %) 3888.089 Total Cash Flows 4117.63 PVF @ 7.40% PV of Cash flows 0.81 3323.79 Total value of business (Unlevered) 3724.31 Number of shares outstanding 100 Value per share 37.24