1. Using a spreadsheet, Calculate the following:

a. NPV

b. IRR

c. MIRR

d. EAA

2. Assuming all 5 projects are mutually exclusive and can be repeated. Based on your results, which project should you choose and why?

Photo attached shows table. Please ensure formulas are visible for understanding.

\begin{tabular}{|l|r|r|r|r|r|} \hline Project & A & B & C & D & \multicolumn{1}{|c|}{ E } \\ \hline Project Life & 3 & 4 & 6 & 8 & 10 \\ \hline I(0) & 800 & 1100 & 1600 & 1900 & 2700 \\ \hline CF(1) & 300 & 310 & 313 & 300 & 357 \\ \hline CF(annual growth) & 4.0% & 3.5% & 3.0% & 1.0% & 0.0% \\ \hline WACC & 7.0% & 6.5% & 6.1% & 5.5% & 5.0% \\ \hline Reinvestment Rate & 5.0% & 5.0% & 5.0% & 5.0% & 5.0% \\ \hline \end{tabular}