Perform a financial analysis for a project using the format provided in Figure $4-5.$ Assume that the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $$300,000$ in Year $1$ and $$40,000$ each year in Years $2,3,$ and $4.$ Estimated benefits are $$0$ in Year $1$ and $$120,000$ each year in Years $2,3,$ and $4.$ Use a $7$ percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet or use the business case financials template on the Companion website to calculate and clearly display the NPV$,$ ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis.Details

A table shows a JWD Consulting net present value and return on investment example.

Across three years, it looks at costs, discount factor, discounted costs, benefits,

discount factor, discounted benefits discounted benefits $-$ costs and cumulative

benefits $-$ costs. R O I, $112\%.$ NPV$,272,800.$