Construct a spreadsheet to calculate the payback period, internal rate of return, and net present values.

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

A. Use the same data from above. Change the discount rate to 12.5%. B. Answer the same questions from the previous pages.