Please make a 2-way data table (using the attached excel data) that 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 Sales Growth rate Cost of Goods Sold (50% of Sales) Gross Profit SG&A Research and Development Gain on sale of assets EBITDA Depreciation EBT Taxes @ 21% EAT 2019 Historical 1000.00 -500.00 500.00 -200.00 -50.00 100.00 350.00 -70.00 280.00 -58.80 221.20 2020 1020.00 0.02 -510.00 510.00 -204.00 -51.00 102.00 357.00 -71.40 285.60 -59.98 225.62 2021 1040.40 0.02 -520.20 520.20 -208.08 -52.02 104.04 364.14 -72.83 291.31 -61.18 230.14 2022 1061.21 0.02 -530.60 530.60 -212.24 -53.06 106.12 371.42 -74.28 297.14 -62.40 234.74