Consider the net cash flows shown in the table below and find the following:

a$.$ Internal rate of return for each project $($using MS Excel Solver$)$

b$.$ Plot the NPV versus interest rate from $0\%-45\%$ in increments of $1\%$ for both Project using a line graph on the same chart.

c$.$ Use MS Excel Solver to determine the interest rate that gives both projects the same internal rate of return. Expand the plot to show this intersection. Do not use the IRR function.

Year Project A Project B

$0-$$$35,000-$$$35,000$

$1$ $$2000$ $$11,000$

$2$ $$6000$ $$10,000$

$3$ $$10,000$ $$10,000$

$4$ $$24,800$ $$8,000$

$5$ $$27,050$ $$5,000$