Assume you are working as a systems analyst in Company XYZ, and is conducting (along with...

  

Transcribed Image Text:

Assume you are working as a systems analyst in Company XYZ, and is conducting (along with your team-mates) a cost-benefit analysis for a customer who has hired your organization to design/develop a new information system. While doing this analysis, you estimate that the new system will cost $40,000 to construct (time 0) and will have ongoing maintenance and operational costs of $20,000, $15,000 and $8,000 over three years, respectively. The benefits from the system have been estimated to be $19,500 per year. Your customer estimates that the system will have 3- year useful life and currently has a discount rate of 12%. Calculate the following: (6 points) You may optionally complete this question using Excel and submit vour Excel spreadsheet. a. What is the total Net Present Value (NPV) of the benefits? b. What is the total Net Present Value (NPV) of the costs? c. What is the total NPV (benefits minus costs)? d. When does the project break-even (if ever) (BE SPECIFIC)? e. What is the Return of Investment? Description Year 0 Year 1 Year 2 Year 3 Total Assume you are working as a systems analyst in Company XYZ, and is conducting (along with your team-mates) a cost-benefit analysis for a customer who has hired your organization to design/develop a new information system. While doing this analysis, you estimate that the new system will cost $40,000 to construct (time 0) and will have ongoing maintenance and operational costs of $20,000, $15,000 and $8,000 over three years, respectively. The benefits from the system have been estimated to be $19,500 per year. Your customer estimates that the system will have 3- year useful life and currently has a discount rate of 12%. Calculate the following: (6 points) You may optionally complete this question using Excel and submit vour Excel spreadsheet. a. What is the total Net Present Value (NPV) of the benefits? b. What is the total Net Present Value (NPV) of the costs? c. What is the total NPV (benefits minus costs)? d. When does the project break-even (if ever) (BE SPECIFIC)? e. What is the Return of Investment? Description Year 0 Year 1 Year 2 Year 3 Total

Answer rating: 100% (QA)

A What is the total Net Present Value NPV of the benefits Year Cash flow PVIF PV 1 19500 089... View the full answer