Assume you are working as a systems analyst in Company XYZ and is conducting along
with your teammates a costbenefit analysis for a customer who has hired your organization to
designdevelop a new information system. While doing this analysis, you estimate that the new
system will cost $ to construct time and will have ongoing maintenance and operational
costs of $$ and $ over three years, respectively. The benefits from the system
have been estimated to be $ per year. Your customer estimates that the system will have
year useful life and currently has a discount rate of Calculate the following: points
You may optionally complete this question using Excel and submit your Excel spreadsheet.
a What is the total Net Present Value NPV of the benefits? points
b What is the total Net Present Value NPV of the costs? points
c What is the total NPV benefits minus costs points
d When does the project breakeven if everBE SPECIFIC points
e What is the Return of Investment? points
Please solve using excel show the completed and formula version. Also include written statements regarding questions ae Thank you :)
