11. Based on the features, the CRM review committee has recommended the purchase of either CRMI or CRM3 software. CRM3 is less expensive as compared to CRM1, but the automation features of CRM1 result in higher cost savings in the future years. Initially, CRMI provides a lower benefit than CRM3, but the benefit increases later. The committee believes that both the CRM software will reach their end of useful life at the end of 5 years The finance department has projected the potential earnings and savings after the implementation of the CRM Software. You are being asked to compute the net present values for both CRMI and CRM3 and present your findings to the committee Cell B17 and C17 has the initial investment for CRM and CRM3 respectively The future years cash flows for CRM1 and CRM3 are in range 818:B22 and C18:022 respectively. Compute the net present values for both CRM1 and CRM3 and recommend which product should be purchased. Write formula to compute NPV for CRMI and CRM3 in cells F18 and F19 respectively. In cell F21 choose CRM1 if your recommendation is CRM1; else choose CRM3 if your recommendation is CRM3. Year 10% Correct Answer 0 1 2 3 Cash Flows CRM CRM3 S (15,000,00) S (12,000.00) $ 2,000.00 $ 3.000.00 $ 2,500.00 $3,200.00 $3,500.00 $ 3,500.00 $5,000.00 $ 3,700.00 $7,000.00 $3,800.00 Required Rate NPV CRMI NPV CRM3 NPV CRM NPV CRM $ $ (724.58) 888.15 14 Your Recommendation Select from the list Is