Perform a financial analysis for a project where the projected costs and benefits are spread over five years with the following data:

Estimated costs are $$100,000$ in Year $1$ and $$25,000$ each for years $2,3,4,$ and $5.$

Estimated benefits are $$0$ in Year $1$ and $$80,000$ each for years $2,3,4,$ and $5.$

Use a discount rate of $8\%$

$1.$ Create an Excel spreadsheet to show costs and benefits over the five$-$year period.

$2.$ Calculate cash flow.

$3.$ Show the discount factor.

$4.$ Show discounted costs and discounted benefits.

$5.$ Calculate and clearly display the NPV $($Net Present Value$),$ ROI $($Return on Investment$),$ and year in which payback $($break$-$even point$)$ occurs.

$6.$ Depict the Payback in a line plot chart