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.

Please 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$)$