please use excel formulas for answers

$ $ LIT DEBT [000s] CAP SPEND/SHARE SHARES [000s] EPS WORKING CAPITAL (000) 2017 257,000 $ 1.35 $ 10,000 1.70 $ 275,000 $ 2018 230,000 $ 1.41 $ 10,000 1.84 $ 297,000 $ 2019 236,667 1.47 10,000 2.13 300,000 2020 233,333 $ 1.54 $ 10,000 2.40 $ 308,000 $ 2021 230,000 1.61 10,000 2.68 311,000 $ $ $ 11 Alls 000 12 PROFITS (AFTER TAX] 13 INTEREST [AFTER TAX] 14 CHG WORKING CAP 15 DEPRECIATION 16 CAP SPENDING 9,600 $ 10,100 $ 10,367 $ 10,833 $ 11,000 19 TAX RATE 20 COST OF DEBT 21 RISK FREE RATE 31.000% 3.750% 3.000% 19 TAX RATE 20 COST OF DEBT 21 RISK FREE RATE 22 MKT RISK PREMIUM 23 WACC 31.000% 3.750% 3.000% 7.500% 7.45% 7.50% 7.55% 7.60% 7.70% 7.70% Terminal vol 550,000 CALCULATE Intrinsic Value Equity Value Intrinsic/Share $ $ LIT DEBT [000s] CAP SPEND/SHARE SHARES [000s] EPS WORKING CAPITAL (000) 2017 257,000 $ 1.35 $ 10,000 1.70 $ 275,000 $ 2018 230,000 $ 1.41 $ 10,000 1.84 $ 297,000 $ 2019 236,667 1.47 10,000 2.13 300,000 2020 233,333 $ 1.54 $ 10,000 2.40 $ 308,000 $ 2021 230,000 1.61 10,000 2.68 311,000 $ $ $ 11 Alls 000 12 PROFITS (AFTER TAX] 13 INTEREST [AFTER TAX] 14 CHG WORKING CAP 15 DEPRECIATION 16 CAP SPENDING 9,600 $ 10,100 $ 10,367 $ 10,833 $ 11,000 19 TAX RATE 20 COST OF DEBT 21 RISK FREE RATE 31.000% 3.750% 3.000% 19 TAX RATE 20 COST OF DEBT 21 RISK FREE RATE 22 MKT RISK PREMIUM 23 WACC 31.000% 3.750% 3.000% 7.500% 7.45% 7.50% 7.55% 7.60% 7.70% 7.70% Terminal vol 550,000 CALCULATE Intrinsic Value Equity Value Intrinsic/Share