As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs$-$benefits analysis prior to project presentation. Assume that the project is expected to return monetary benefits of $$55,000$ per year, one$-$time costs of $$75,000,$ and recurring costs of $$15,000$ per year. The project has a discount rate of $10\%$ and a five$-$year time horizon.

a$)$ Create a costs$-$benefits analysis spreadsheet similar to Figure $5-6$ in Chapter $5.$

b$)$ Calculate net present value $($NPV$)$ of benefits for each year.

c$)$ Calculate net present value $($NPV$)$ of costs for each year.

d$)$ Calculate overall net present value $($NPV$)$ at the end of project life.

e$)$ Calculate overall return on investment $($ROI$)$ at the end of project life.

f$)$ Perform break$-$even analysis $($BEA$)$ for the project.

g$)$ Calculate break$-$even point for this project.