activity 2.5 financial analysis exercise

Perform a financial analysis for a project using the format provided in Fig. 2-5 (page 48 of your textbook). Assume the costs and benefits for this project are spread over four years as follows. Estimated costs are $155,000 in Year 1 and $5,000 each year in Years 2, 3 and 4. The discount factors will automatically be recalculated. Estimated benefits are $0 in Year 1 and $42,000 each year in Years 2, 3 and 4. Use a 12% discount rate (interest rate). Use this

template

to calculate NPV and ROI, and year in which payback occurs. Write a paragraph explaining whether you would recommend investing in this project based on your financial analysis. Please, follow the current APA Manual standards in writing and editing your paper.