Now, once you have acquired the company and are doing well, you decide to open up one more plant for expanding the production facility. But there are three options from which you have to choose which location you want to invest. These options are provided in the data set shared below.

1)Choose one location that is most suitable for investing (2 marks)

2) Determine the NPV and IRR for each project. (6 marks)

Return given 15%

\begin{tabular}{|c|c|c|c|} \hline \multirow[t]{12}{*}{ Return } & 15% & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & \multicolumn{3}{|c|}{ Project 1} \\ \hline & Year & Investment & Revenue Stream \\ \hline & 0 & -10000 & 0 \\ \hline & 1 & 1000 & 1000 \\ \hline & 2 & 3000 & 3000 \\ \hline & 3 & 3500 & 3500 \\ \hline & 4 & 4000 & 4000 \\ \hline & 5 & 2000 & 2000 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline \multicolumn{3}{|c|}{ Project 2 } \\ \hline \multicolumn{1}{|c|}{ Year } & Investment & Revenue Stream \\ \hline 0 & -10000 & 1500 \\ \hline 1 & 1500 & 2000 \\ \hline 2 & 2000 & 3000 \\ \hline 3 & 3000 & 5000 \\ \hline 4 & 5000 & 4000 \\ \hline 5 & 4000 & \\ \hline \multicolumn{3}{|c|}{} \\ \hline Year & Investment & Revenue Stream \\ \hline 0 & -10000 & 1000 \\ \hline 1 & 1000 & 2000 \\ \hline 2 & 2000 & 3500 \\ \hline 3 & 3500 & 4000 \\ \hline 4 & 4000 & 4000 \\ \hline 5 & 4000 & \\ \hline \end{tabular}