Complete Exercise $2\mathrm{.}1-$ Perform a financial analysis for a project using the format provided in Figure $2-5.$ Assume the projected costs and benefits for this project are spread over $4$ years as follows:

Estimated costs are $$100,000$ in Year $1$ and $$25,000$ each year in Years $2,3,$ and $4.($Hint: Just change the years in the template you will use below from $0,1,2,3,$ and $4$ to $1,2,3,$ and $4.$ The discount factors will automatically be recalculated.$)$ Estimated benefits are $$0$ in Year $1$ and $$80,000$ each year in Years $2,3,$ and $4.$ Use an $8\%$ discount rate. Use the Financial Analysis $($Business Case Financials template$)$ linked in this assignment to calculate and clearly display the NPV$,$ ROI, the year in which payback occurs, and assumptions. In addition, write a paragraph explaining whether you would recommend investing in this project based on your financial analysis.

Tips for completing the worksheet below

$1.$Enter the discount rate

$2.$Enter the costs per year starting with Year $1$

$3.$Enter the discount factor on row $10$ and row $14$

$4.$Enter the benefts per year starting with Year $1$

$5.$Identify the Payback year $(1$st year the cummulative benefits are postive$)$ and move the arrow to the correct year column.

$6.$ Type up the analysis by answering the question in the instructions.