Initial outlay Required rate of return Year 1 cash flow Year 2 cash flow Year 3 cash flow Year 4 cash flow Year 5 cash flow NPV (Project Solar) IRR (Project Solar) Profitiability Index (Project Solar) $ $ 210,000.00 12% $ 60,000.00 $ 65,000.00 $ 70,000.00 $ 75,000.00 $ 80,000.00 $38,271.65 Initial outlay Required rate of return Year 1 cash flow Year 2 cash flow Year 3 cash flow Year 4 cash flow Year 5 cash flow NPV (Project Wind) IRR (Project Wind) Profitiability Index (Project Wind) $ (0.18) $ 210,000.00 12% $ 65,000.00 $ 65,000.00 $ 65,000.00 $ 65,000.00 $ 65,000.00 $ 24,310.45 (0.12)

Hello! Please help with IRR. Also, if my other figures for NPV and/or PI look wrong, please let me know.

\begin{tabular}{|c|c|c|} \hline Initial outlay & $ & 210,000.00 \\ \hline Required rate of return & & 12% \\ \hline Year 1 cash flow & $ & 60,000.00 \\ \hline Year 2 cash flow & $ & 65,000.00 \\ \hline Year 3 cash flow & $ & 70,000.00 \\ \hline Year 4 cash flow & $ & 75,000.00 \\ \hline Year 5 cash flow & $ & 80,000.00 \\ \hline NPV (Project Solar) & & $38,271.65 \\ \hline \multicolumn{3}{|l|}{ IRR (Project Solar) } \\ \hline Profitiability Index (Project Solar) & $ & (0.18) \\ \hline Initial outlay & $ & 210,000.00 \\ \hline Required rate of return & & 12% \\ \hline Year 1 cash flow & $ & 65,000.00 \\ \hline Year 2 cash flow & $ & 65,000.00 \\ \hline Year 3 cash flow & $ & 65,000.00 \\ \hline Year 4 cash flow & $ & 65,000.00 \\ \hline Year 5 cash flow & $ & 65,000.00 \\ \hline NPV (Project Wind) & $ & 24,310.45 \\ \hline \multicolumn{3}{|l|}{ IRR (Project Wind) } \\ \hline Profitiability Index (Project Wind) & $ & (0.12) \\ \hline \end{tabular}