I am having trouble with the sensitivity analysis. I have the numbers but am not sure how to use excel's What-If-Analysis and Data Table function. It would be a great help if you could provide screenshots of the steps with values -- I attempted multiple times and failed. Thanks!

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Terminal Year 0 8,50,000 3,50,000 5,00,000 Project ($) Initial Investment Real Estate Cost Equipment Cost Salvage Value Sales Value Additional Working Capital Change in Working Capital Depreciation % MACRS - 5 year Depreciation - MACRS 3,50,000 16,00,000 30,000 30,000 65,000 5,000 -65,000 35,000 5,000 20.00% 1,00,000 40,000 5,000 32.00% 1,60,000 45,000 5,000 19.20% 96,000 50,000 5,000 11.52% 57,600 55,000 5,000 11.52% 57,600 60,000 5,000 5.76% 28,800 2,00,000 2,20,000 2,42,000 2,66,200 2,92,820 3,22,102 3,54,312 12,50,000 1,77,156 68,000 Revenue Other Income Variable Cost @ 50% Fixed Cost Depreciation EBT Tax @ 21% Net Income 1,00,000 50,000 1,00,000 -50,000 -10,500 -39,500 1,10,000 53,000 1,60,000 -1,03,000 -21,630 -81,370 1,21,000 56,000 96,000 -31,000 -6,510 -24,490 1,33,100 59,000 57,600 16,500 3,465 13,035 1,46,410 62,000 57,600 26,810 5,630 21,180 1,61,051 65,000 28,800 67,251 14,123 53,128 1,09,156 22,923 86,233 12,50,000 2,62,500 9,87,500 Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow -8,80,000 1 -8,80,000 -8,80,000 55,500 0.9009 50,000 -8,30,000 73,630 0.8116 59,760 -7,70,240 66,510 0.7312 48,632 -7,21,609 65,635 0.6587 43,236 -6,78,373 73,780 0.5935 43,785 -6,34,588 76,928 0.5346 41,129 -5,93,459 81,233 0.4817 39,127 -5,54,332 14,02,500 0.4817 6,75,526 1,21,194 NPV 1,21,194 Discounting Factor 11.00% Sensitivity Analysis Cash Flows Sales increase by 20% Sales at the same level Sales decrease by 20% 240000 200000 160000 55,500 71,300 55,500 39,700 73,630 91,010 73,630 56,250 66,510 85,628 66,510 47,392 65,635 86,665 65,635 44,605 73,780 96,913 73,780 50,647 76,928 1,02,374 76,928 51,482 81,233 1,09,224 81,233 53,243 Sensitivity Analysis NPV Sales increase by 20% Sales at the same level Sales decrease by 20% 240000 200000 160000 1,21,194 2,18,180 1,21,194 24,207 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Terminal Year 0 8,50,000 3,50,000 5,00,000 Project ($) Initial Investment Real Estate Cost Equipment Cost Salvage Value Sales Value Additional Working Capital Change in Working Capital Depreciation % MACRS - 5 year Depreciation - MACRS 3,50,000 16,00,000 30,000 30,000 65,000 5,000 -65,000 35,000 5,000 20.00% 1,00,000 40,000 5,000 32.00% 1,60,000 45,000 5,000 19.20% 96,000 50,000 5,000 11.52% 57,600 55,000 5,000 11.52% 57,600 60,000 5,000 5.76% 28,800 2,00,000 2,20,000 2,42,000 2,66,200 2,92,820 3,22,102 3,54,312 12,50,000 1,77,156 68,000 Revenue Other Income Variable Cost @ 50% Fixed Cost Depreciation EBT Tax @ 21% Net Income 1,00,000 50,000 1,00,000 -50,000 -10,500 -39,500 1,10,000 53,000 1,60,000 -1,03,000 -21,630 -81,370 1,21,000 56,000 96,000 -31,000 -6,510 -24,490 1,33,100 59,000 57,600 16,500 3,465 13,035 1,46,410 62,000 57,600 26,810 5,630 21,180 1,61,051 65,000 28,800 67,251 14,123 53,128 1,09,156 22,923 86,233 12,50,000 2,62,500 9,87,500 Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow -8,80,000 1 -8,80,000 -8,80,000 55,500 0.9009 50,000 -8,30,000 73,630 0.8116 59,760 -7,70,240 66,510 0.7312 48,632 -7,21,609 65,635 0.6587 43,236 -6,78,373 73,780 0.5935 43,785 -6,34,588 76,928 0.5346 41,129 -5,93,459 81,233 0.4817 39,127 -5,54,332 14,02,500 0.4817 6,75,526 1,21,194 NPV 1,21,194 Discounting Factor 11.00% Sensitivity Analysis Cash Flows Sales increase by 20% Sales at the same level Sales decrease by 20% 240000 200000 160000 55,500 71,300 55,500 39,700 73,630 91,010 73,630 56,250 66,510 85,628 66,510 47,392 65,635 86,665 65,635 44,605 73,780 96,913 73,780 50,647 76,928 1,02,374 76,928 51,482 81,233 1,09,224 81,233 53,243 Sensitivity Analysis NPV Sales increase by 20% Sales at the same level Sales decrease by 20% 240000 200000 160000 1,21,194 2,18,180 1,21,194 24,207