Construct a spreadsheet and calculate the following (the required rate of return is 12%):

Payback period

Discounted payback period

Internal rate of return (IRR)

Modified IRR

The discounting approach

The reinvestment approach

The combination approach

Net present value (NPV)

Based on your analysis, should the company take the project? Why?

\begin{tabular}{|c|c|} \hline Year & Cashflow \\ \hline 0 & $300,000,000 \\ \hline 1 & $63,000,000 \\ \hline 2 & $85,000,000 \\ \hline 3 & $50,000,000 \\ \hline 4 & $145,000,000 \\ \hline 5 & $175,000,000 \\ \hline 6 & $50,000,000 \\ \hline 7 & $70,000,000 \\ \hline 8 & $72,000,000 \\ \hline \end{tabular}