Directions: Using the information below, calculate the capital budgeting metrics in green. Answer the associated questions. **You must use Excel for these calculations***

Year Cash flow

Year 0: $(700,000,000)

Year 1: $150,000,000

Year 2: $165,000

Year 3: $195,000,000

Year 4: $235,000,000

Year 5: $200,000,000

Year 6: $185,000,000

Year 7: $165,000,000

Year 8: $145,000,000

Year 9: $(105,000,000)

WACC: 11.5%

What is the payback period, the IRR, the IRR with a guess of -0.99 in calculations, the MIRR, the profitability index, and the NPV of the cash flow?