2. You are responsible for doing an NPV, ROI and Break-even analysis for the New Parking Meter information system project. The information system has a projected lifespan of 6 years. Assume estimated monetary benefits for the system of $3m in the first year (i.e. year 1, the year after the current year, which is year 0), with those benefits increasing by $1m a year for the next 3 years and then decreasing $2m a year for the remainder. One-time development and procurement costs are $4m in the current year (year 0) and recurring costs (beginning in year 1) are estimated to start at $1m a year and increase by 5.8% per year over the duration of the system's scheduled life. The discount rate the company concerned uses is 4 percent. This project is using new technology and involves a community currently uses manual processes (coin operated meters). As a result the project is regarded as high risk. Note that a spreadsheet is ideal for working out the answer to a question like this. You can find such a spreadsheet on the course website. You are not assessed on your ability to do maths, many of the calculations are done in formulas, so just fill in the shaded cells for discount rate, benefits and costs. Complete the spreadsheet to calculate the net present value, return on investment and present a break-even analysis for the proposed information system. Think carefully about how to present this information within the single file you submit (e.g. copy and paste the chart to show BEA but still include discussion to explain figures). 2. You are responsible for doing an NPV, ROI and Break-even analysis for the New Parking Meter information system project. The information system has a projected lifespan of 6 years. Assume estimated monetary benefits for the system of $3m in the first year (i.e. year 1, the year after the current year, which is year 0), with those benefits increasing by $1m a year for the next 3 years and then decreasing $2m a year for the remainder. One-time development and procurement costs are $4m in the current year (year 0) and recurring costs (beginning in year 1) are estimated to start at $1m a year and increase by 5.8% per year over the duration of the system's scheduled life. The discount rate the company concerned uses is 4 percent. This project is using new technology and involves a community currently uses manual processes (coin operated meters). As a result the project is regarded as high risk. Note that a spreadsheet is ideal for working out the answer to a question like this. You can find such a spreadsheet on the course website. You are not assessed on your ability to do maths, many of the calculations are done in formulas, so just fill in the shaded cells for discount rate, benefits and costs. Complete the spreadsheet to calculate the net present value, return on investment and present a break-even analysis for the proposed information system. Think carefully about how to present this information within the single file you submit (e.g. copy and paste the chart to show BEA but still include discussion to explain figures)