Please provide a full worked out soltuion explaining how to do each step clearly and explain every excel formula, show your excel work step by step:

$\backslash$table$[[$Project$,$A$,$B$,$C$,$D$,$E$],[$Initial Cost,$$2,400,$$$2,700,$$$3,600,$$$1,600,$$$2,700],[$Annual Revenue,$$630,$$$900,$$$1,050,$$$4,100,$$$3,250],[\backslash$table$[[$Annual$],[$Maintenance$]],$$$100,$$$160,$$$240,$$$3,670,$$$2,640],[$Salvage Value,$$290,$$$230,$$$350,$$$350,$$$260]]$

Jacob is in charge of resource development and investment in his firm, and he was recently presented with $5$ different $9-$year investment projects as shown below. Jacob$$s determine that it is not in his firm$$s best interest to invest in any project that will earn less than $20\%.$ He is also given the go ahead by the board of governors for the firm to choose any and all projects that he finds acceptable, so he does not have to choose only $1$ project. Calculate the IRR for each of the projects presented

below using an excel spreadsheet graph of present worth vs rate of return. Attach the graph for each project and indicate which projects should Jacob invest in$,$ and which projects he has to stay away from.