The following table shows the cash flows of two projects from year $0$ to year $10.$ You can copy and paste the table for Excel for easier computation.

$\backslash$table$[[,$Project A$,$Project B$],[$Year $0,\backslash$table$[[5],[(600)]],\backslash$table$[[$S$],[(800)]]],[$Year $1,\backslash$table$[[$$$],[170]],\backslash$table$[[$$$],[280]]],[$Year $2,\backslash$table$[[5],[160]],\backslash$table$[[$S$],[170]]],[$Year $3,\backslash$table$[[5],[180]],\backslash$table$[[$$$],[200]]],[$Year $4,\backslash$table$[[5],[190]],\backslash$table$[[5],[200]]],[$Year $5,\backslash$table$[[5],[100]],\backslash$table$[[$S$],[100]]],[$Year $6,\backslash$table$[[5],[60]],\backslash$table$[[$S$],[100]]],[$Year $7,\backslash$table$[[5],[60]],\backslash$table$[[$S$],[100]]],[$Year $8,\backslash$table$[[],[20]],\backslash$table$[[$$$],[20]]],[$Year $9,\backslash$table$[[5],[20]],\backslash$table$[[5],[20]]],[$Year $10,\backslash$table$[[5],[200]],\backslash$table$[[5],[250]]]]$

lease complete the following tasks:

$($a$)$ Solve the IRR of EACH project $(1$ points$)$

$($b$)$ Solve the NPV of EACH project when required return is $10\%(1$ points$)$

$($c$)$ Solve the NPV of EACH project when required return is $20\%(1$ points$)$

$($d$)$ Solve the crossover rate for the two projects $(2$ points$)$

$($e$)$ Explain how to use the crossover rate to choose the better project, assume Project A and Project B are mutually exclusive to each other. $(2$ points$)$

$($f$)$ List the advantages and disadvantages of using IRR to make capital budgeting decisions, especially when compared to using NPV$.(5$ points$)$