A software project will cost $45,000 to develop in year 0. after it is operational, it will have a five-year useful life. operational costs will be $19,000 per year for years 1-4, and $45,000 inyear 5. project benefits will be $40,000 in year 1, and will increase 10% in each of the following years.
a. Create a worksheet that shows costs and benefits for Years 0— 5.
b. Now add columns to worksheet for cumulative costs and benefits. Based on these values, estimate the payback period. Explain your answer.
c. Use the worksheet values to create a line chart that shows the payback period.