Directions: Using the information below, calculate the capital budgeting metrics in green. Answer the associated questions. **You must use Excel for these calculations*** IRR Year 0 1 2 IRR 3 4 5 6 MIRR 7 8 9 WACC Cash flow -700,000,000 150,000,000 165,000 195,000,000 235,000,000 200,000,000 185,000,000 165,000,000 Payback period Delete and replace with the interpretation of your payback period calculation. 145,000,000 -105,000,000 11.5% Delete and replace with the interpretation of your IRR calculation. do not include the "goess" input include a guess of *-0.99" in this calculation Delete and replace with your answer to the following: What do the differences in the 2 IRR results suggest about the weakness of the IRR calculation? - assume a reivestment rate equal to the WACC Delete and replace with the interpretation of your MIRR calculation. Profitability index Delete and replace with the interpretation of your MIRR calculation. NPV Delete and replace with the interpretation of your NPV calculation.