New File Home Insert Page Layout Formulas Data View Help Chemic20 O PROTECTED VIEW Beetrom the conside E31 D G COMPARING TWO PROJECTS UNSING NET PRESENT VALUE (NPV) Year 0 Year 1 Year 2 Year 3 Year 5 Year 6 Total ($700,000) $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 1$700,000) 1.125.000.00 $425,000 B 1 2 3 Question 1: 4 5 Project A Interest rate 6 Required 15% 7 Outfiow 8 Inflow 9 Net Inflow 10 NPV $54,234.90 11 12 13 Project B 14 Required 15% 15 Outflow 16 Inflow 17 Net Inflow 18 NPV ($31,262.94) 19 ($400,000) $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $400,000 $550,000 $150,000 New File Home Insert Page Layout Formulas Data View Help Chemic20 O PROTECTED VIEW Beetrom the conside E31 D G COMPARING TWO PROJECTS UNSING NET PRESENT VALUE (NPV) Year 0 Year 1 Year 2 Year 3 Year 5 Year 6 Total ($700,000) $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 1$700,000) 1.125.000.00 $425,000 B 1 2 3 Question 1: 4 5 Project A Interest rate 6 Required 15% 7 Outfiow 8 Inflow 9 Net Inflow 10 NPV $54,234.90 11 12 13 Project B 14 Required 15% 15 Outflow 16 Inflow 17 Net Inflow 18 NPV ($31,262.94) 19 ($400,000) $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $400,000 $550,000 $150,000