helpe me find the NPV AND IRR FOR PROJECT A AND B.

return rate: 9.53%

periods: 16

please use excel. thanks!

\begin{tabular}{|c|c|c|} \hline Year & Project A & Project B \\ \hline 1 & 200 & 830 \\ \hline 2 & 600 & 830 \\ \hline 3 & 800 & 830 \\ \hline 4 & 900 & 830 \\ \hline 5 & 1500 & 830 \\ \hline 6 & 1000 & 830 \\ \hline 7 & 1000 & 830 \\ \hline 8 & 900 & 830 \\ \hline 9 & 900 & 830 \\ \hline 10 & 800 & 830 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Year & Project A & Project B \\ \hline 1 & 200 & 830 \\ \hline 2 & 600 & 830 \\ \hline 3 & 800 & 830 \\ \hline 4 & 900 & 830 \\ \hline 5 & 1500 & 830 \\ \hline 6 & 1000 & 830 \\ \hline 7 & 1000 & 830 \\ \hline 8 & 900 & 830 \\ \hline 9 & 900 & 830 \\ \hline 10 & 800 & 830 \\ \hline \end{tabular}