Chapter 5 Bullock Gold Mining Input area: \begin{tabular}{|ccc|} \hline Year & \multicolumn{2}{c|}{ Cash flow } \\ \cline { 2 - 3 } & $(950,000,000) \\ 1 & $ & 190,000,000 \\ 2 & $ & 215,000,000 \\ 3 & $ & 225,000,000 \\ 4 & $ & 285,000,000 \\ 5 & $ & 275,000,000 \\ 6 & $ & 235,000,000 \\ 7 & $ & 205,000,000 \\ 8 & $ & 165,000,000 \\ 9 & $ & (75,000,000) \\ \hline \end{tabular} Output area: Q1. Construct the following spreadsheet to calculate the payback period, internal rate of return, profitability index, and net present value of the proposed mine. Payback period IRR IRR Profitability index NPV Q2. Based on your analysis, should the company open the mine? Please explain the reasol