a$)$ The table shown below lists the cash flow of two IT projects. Complete missing items and find the NPV$,$ ROI, and Payback for each project. Which project should be selected?

$\backslash$table$[[,$Year$0,$Year$1,$Year$2,$Year$3,$Year$4,$total$],[$Discount Rate $=9\%,],[$Project$1],[\backslash$table$[[$Discounted$],[$factor$]]],[$Costs$,$$$70,000,$$$80,000,$$$35,000,$$$30,000,$$$20,000,],[\backslash$table$[[$Discounted$],[$costs$]]],[$Benefits$,$$$0,$$$65,000,$$$75,000,$$$120,000,$$$150,000,],[\backslash$table$[[$Discounted$],[$benefits$]]],[\backslash$table$[[$Discounted$],[$Cash flow$]]],[$Net cash flow$],[$Project$2],[$Costs$,$$$110,000,$$$90,000,$$$30,000,$$$37,000,$$$50,000,],[\backslash$table$[[$Discounted$],[$costs$]]],[$Benefits$,$$$0,$$$65,000,$$$100,000,$$$170,000,$$$170,000,],[\backslash$table$[[$Discounted$],[$benefits$]]],[\backslash$table$[[$Discounted$],[$Cash flow$]]],[$Net cash flow,,,,,,$]]$

Answer:

$\backslash$table$[[$Project $1,$Project $2],[NPV=,NPV=$