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.

Page 2: A. Change the cash-flows as follows: Investment $ 600,000,000 Year 5 $ 195,000,000 Year 1 $ 79,000,000 Year 6 $ 145,000,000 Year 2 $ 95,000,000 Year 7 $135,000,000 Year 3 $ 120,000,000 Year 8 $112,000,000 Year 4 $ 163,000,000 Year 9 ($ 55,000,000) Salvage value Page 3: A. Use the same data from Page 2 above. Change the discount rate to 12.5%. B. Answer the same questions from the previous pages.