Normal No Spacing Heading1 Heading 2 Company Performance Govt. Performance Indicate the value of the variable Variable Year Cash Flow is Positive NPV IRR NPV Level 1 Level 2 RoyaltyLevel 3 Level 4 Level 5 Level 1 Level 2 Depreciation Level 3 20% Level 4 Level 5 Level 1 Level 2 Level 3 | 50% Level 4 Level 5 Level 1 Level 2 Cost Recovery Signature Level 3 $5000 Bonus Level 4 Level 5 Level 1 Level 2 With Holding | Level 3 | 10% Level 4 Level 5 Part 1. Run various_ cases varying one variable at a time and record your output in the table above. Use values on either side of the mid value indicated in the table Part 2. Find the optimal combination of the above variables that will maximize return for the Oil Company while maintaining the NPV for the Host Govt. above $295 MM. (Hint: use Solver) s English (United States) Focus Normal No Spacing Heading1 Heading 2 Company Performance Govt. Performance Indicate the value of the variable Variable Year Cash Flow is Positive NPV IRR NPV Level 1 Level 2 RoyaltyLevel 3 Level 4 Level 5 Level 1 Level 2 Depreciation Level 3 20% Level 4 Level 5 Level 1 Level 2 Level 3 | 50% Level 4 Level 5 Level 1 Level 2 Cost Recovery Signature Level 3 $5000 Bonus Level 4 Level 5 Level 1 Level 2 With Holding | Level 3 | 10% Level 4 Level 5 Part 1. Run various_ cases varying one variable at a time and record your output in the table above. Use values on either side of the mid value indicated in the table Part 2. Find the optimal combination of the above variables that will maximize return for the Oil Company while maintaining the NPV for the Host Govt. above $295 MM. (Hint: use Solver) s English (United States) Focus