\begin{tabular}{ccc} 0Year & Cash flow \\ \cline { 2 - 3 } 1 & $ & (795,000,000) \\ 2 & $ & 127,000,000 \\ 3 & $ & 135,000,000 \\ 4 & $ & 145,000,000 \\ 5 & $ & 185,000,000 \\ 6 & $ & 225,000,000 \\ 7 & $ & 165,000,000 \\ 8 & $ & 134,000,000 \\ 8 & $ & (52,000,000) \\ 9 & & \end{tabular} Required return 11.5% QUESTIONS 1. Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposed mine. Payback period IRR MIRR Profitability index NPV