A B Question 1: COMPARING TWO PROJECTS UNSING NET PRESENT VALUE (NPV) Year 0 Year 1 Year 2 Year 3 Year 5 Year 6 Total Interest rate 15% Project A Required Outflow Inflow Net Inflow NPV ($700,000) $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 ($700,000) $225,000 1,125,000.00 $225,000 $425,000 $54,234.90 3 Project B Required 15% 5 Outflow ($400,000) ($400,000) 6 Inflow $110,000 $110,000 $110,000 $110,000 $110,000 $550,000 7 Net Inflow $110,000 $110,000 $110,000 $110,000 $110,000 $150,000 8 NPV ($31,262.94) 9 Based on the information above, identify which project (Project A or B) should be accepted? Explain why. By changing the figures in the excel template (above), assume the interest rate for Project A fell to 13%, and Cash Questions: outflow (The initial investment) was $950,000, Cash Inflows was $350,000 per annum for the 6 years, and Net inflows was also $250,000. For Project B, assume interest rate also fell to 13% but Cash outflow, Inflow and Net 20 Inflows remain the same. What is the new NPV for each of the project? Would you receommend that any of these project be accepted by the investor? Why/Why not? 21