Perform a financial analysis for this project. Assume the projected costs and benefits for this project are spread over four years as follows: estimated costs are
1,500,000inyear1and
300,000 each year in years 2,3 and 4. Estimated benefits are
0inyear1and
1,000,000 each year in years 2,3 and 4. Use a 10 percent discount are. Create a spreadsheet to calculate and clearly display the NPV, ROI and year in which payback occurs. In addition, a paragraph explaining whether you would recommend investing in this project, based on your financial analysis.
Select the correct answer from above options