Bullock Gold Mining Input area: Year 5868 CAWN10 2 3 NPV 4 5 7 9 Required return Payback period IRR IRR Profitability index $ $ $ Cash flow (950,000,000) 190,000,000 215,000,000 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. $ 225,000,000 $ 285,000,000 $ 275,000,000 $ 235,000,000 205,000,000 $ $ 165,000,000 (75,000,000) 12% [[| Q2. Based on your analysis, should the company open the mine? Please explain the reaso