Evaluate 4 mutually exclusive investment projects, - All: useful life = 10 years & Redemption Value 20% of initial investment - TERM: 12%. Which project is selected?

PLIS USE EXCEL AND PUT THE FORMULAS

\begin{tabular}{|c|c|c|c|c|} \hline & Project A & Project B & Project C & Project D \\ \hline Initial Investment & 495 & 180 & 275 & 310 \\ \hline Cash Flow / year & 110 & 40 & 45 & 70 \\ \hline IRR & ? & ? & ? & ? \\ \hline \end{tabular}