Explain fully how to find the values for net income, Cash Flow and NPV for the Base case, Worst case and Best case.

AutoSave OF A AvG... Worksheet in pp11 - Compatibility Mode - Compatibility Mode View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Arial v 18 X G * " Wrap Text General 2 Insert Delete Y Paste B I U UV AY = = = Sort & Merge & Center % ? Conditional Format Cell Formatting es Table Styles Find & Select Format v Analyze Data Sensitivity G34 Xfx M . C T U AM Depreciation 40000 D TE LOACT Loper GICO 6500 8500 BO 75 95 10 58 82 500CO 450001 55000 Unt Sales Price per unit VC per unit FC per unit No NWC Base Case Analyse Pro Forma Statement Selas + VC FC Depreciation EBIT Taxes NI 180500 360000 50500 40300 30000 10200 19900 Best Case Pro Forma Stalement Salee 552500 VC 377000 FC 45000 Depreciation 40000 EBIT 50500 TAXAS 30770 NI 59730 Worst Case Pro Forme Statement Sales 412500 VC 341000 FC 55000 Depreciation 40000 EBIT - 23500 Taxes -7990 NI -15610) Cash Flows YRAT Year YEA CCF NCS CFFA 0 -200000 -200000 11 59900 59900 2 2 69900 59930 3 31 69900 59000 4 69900 59000 5 59900 59000 NPV E15.565.82 OCE NCS CEFA a -200000 -200000 1 99730 99730 2 99720 99733 349720 99733 4 4 99720 99730 5 99720 99730 NPV $159,504.32 OCH NCS CEFA 0 -2003CO -200000 1 1 24490 24490 2 24490 24490 3 3 24490 24490 4 4 24490 24490 5 24490 24480 NPM 15111, 710.091 Sens live Analysis for Unil Sales Pro Forms Statement Selas VC FC Depreciation EBIT Taxes X NI Base Luned Loger 480000 400000 520000 360000 330000 3800001 50500 50000 50000 40000 40000 30000 20000 40000 10200 6300 13650 19800 132001 26410 10000 Cash Flows Vaer 0 1 2 3 4 6 -200 CHCO -2010 CHID -210 0:1) 000 ANCO 53200 ) 1640 59900 153200 16400 59900 $3200 66400 69900 58200 66400 69900 63200 6400 $15,665.62 (59,225.91 $39,267.14 NPV Scenario + Enter 62% AutoSave OF A AvG... Worksheet in pp11 - Compatibility Mode - Compatibility Mode View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Arial v 18 X G * " Wrap Text General 2 Insert Delete Y Paste B I U UV AY = = = Sort & Merge & Center % ? Conditional Format Cell Formatting es Table Styles Find & Select Format v Analyze Data Sensitivity G34 Xfx M . C T U AM Depreciation 40000 D TE LOACT Loper GICO 6500 8500 BO 75 95 10 58 82 500CO 450001 55000 Unt Sales Price per unit VC per unit FC per unit No NWC Base Case Analyse Pro Forma Statement Selas + VC FC Depreciation EBIT Taxes NI 180500 360000 50500 40300 30000 10200 19900 Best Case Pro Forma Stalement Salee 552500 VC 377000 FC 45000 Depreciation 40000 EBIT 50500 TAXAS 30770 NI 59730 Worst Case Pro Forme Statement Sales 412500 VC 341000 FC 55000 Depreciation 40000 EBIT - 23500 Taxes -7990 NI -15610) Cash Flows YRAT Year YEA CCF NCS CFFA 0 -200000 -200000 11 59900 59900 2 2 69900 59930 3 31 69900 59000 4 69900 59000 5 59900 59000 NPV E15.565.82 OCE NCS CEFA a -200000 -200000 1 99730 99730 2 99720 99733 349720 99733 4 4 99720 99730 5 99720 99730 NPV $159,504.32 OCH NCS CEFA 0 -2003CO -200000 1 1 24490 24490 2 24490 24490 3 3 24490 24490 4 4 24490 24490 5 24490 24480 NPM 15111, 710.091 Sens live Analysis for Unil Sales Pro Forms Statement Selas VC FC Depreciation EBIT Taxes X NI Base Luned Loger 480000 400000 520000 360000 330000 3800001 50500 50000 50000 40000 40000 30000 20000 40000 10200 6300 13650 19800 132001 26410 10000 Cash Flows Vaer 0 1 2 3 4 6 -200 CHCO -2010 CHID -210 0:1) 000 ANCO 53200 ) 1640 59900 153200 16400 59900 $3200 66400 69900 58200 66400 69900 63200 6400 $15,665.62 (59,225.91 $39,267.14 NPV Scenario + Enter 62%