Perform a financial analysis for a project

Assume the projected costs and benefits for this project are spread over the amount of time as scenario 1, but:

• Estimated costs are $100,000 in year 1 and $70,000 in each of years 2, 3, 4, and 5.
• Estimated benefits are $0 in year 1, $100,000 in year 2, and 150,000 each of years 3, 4, and 5.
• Use the same discount rate and discount factors as scenario 1.

Create a spreadsheet to:

1. show benefits and costs for each year with the corresponding rates and discounted values, as well as the total costs and benefits.
2. calculate and clearly display the NPV, ROI, and year in which payback occurs.