4. Eagle Energy is an upstream oil and gas company and has made a new crude oil discovery near a processing facility they own. Eagle needs to decide whether to develop the discovery and whether to enlarge their facility. Their alternatives are to do one of the following: 1. Do nothing, no development. No cost but no potential revenue above current operations. 2. Develop the field without enlarging their 20,000 barrel per day facility. 3. Develop the field and enlarge their facility to a total of 40,000 barrel per day capacity. 4. Develop the field and enlarge their facility to a total of 50,000 barrel per day capacity. The different design capacities have different capital costs (CAPEX), operating costs (OPEX), and construction schedules. The well costs are the same regardless of which development option is selected. Details are in the appendix to this exam. The information in the appendix is in the Eagle Oil.xlsx file so you do not need to retype anything that is in the appendix. Eagle Energy bases their decisions on NPV. You are only concerned about this decision - no need to worry about other Eagle projects or decisions. Tasks: 1. Open the Eagle Oil.xlsx file. Rename the file with your name in front, for example if your last name is Smith, rename it as "Smith Eagle Oil.xlsx." In the Eagle Oil.xlsx file a decision tree has been started on the Inputs worksheet. It is in or near cell A11. Complete the decision tree by adding these nodes: a. The facility size decision (links to dCapacityFacility). b. The year of first oil uncertainty (links to u1stOilYear). c. The oil production uncertainty (links to uProductionOIlPercentile). d. The oil price uncertainty (links to uOilPrice). Hint: Consider if the tree is symmetric or not. Do all the uncertainties apply to all the alternatives? Notes about building the tree: ? Link to the cell with the range name (they marked as yellow cells on the input worksheet). PrecisionTree will link to the cell address not the range name. For example, when you link an uncertainty node to u1stOilYear it will appear as C276 (or whatever the correct cell address is in your copy) not "u1stOilYear." ? When linking the uncertainty nodes to the spreadsheet, use these branch values: o P10 = 1 o P50 = 2 o P90 = 3 ? The facility decision uses 1 through 4 to indicate the four alternatives. ? These indicator variables are used in the spreadsheet to pull up the correct values for calculations. Inspect the spreadsheet to make sure you understand how this works. For example, the year of first oil should have three branches, one with value of 1, one with a value of 2, and one with a value of 3. These values are used by the spreadsheet to place the correct value in the blue cells on the input sheet. Those values are then used on the calculations worksheet. ? Use the Extended Swanson-Megill Method (ESM) for the probabilities for the decision tree uncertainties. (See Lectures 17.5 and 17.6 for details if needed.) ? Keep the start year (range name "YearStart") set to 2025. ? Keep the discount rate (range name "RateDiscount") at 15%. 2. Generate the cumulative risk profiles for the four development options. (17 points) a. What is the expected value of each alternative, and which is most attractive from an expected value perspective? (4 points) b. Discuss if any dominance among the alternatives is present and what it means? (6 points) c. What is the probability of having a negative NPV for each of the four alternatives? (4 points) d. The local government would like you to enlarge your facility to provide more local jobs and is willing to offer incentives such as tax refunds. In present value terms, what is the minimum amount they need to offer to make a larger facility (larger than your preferred alternative) attractive to you? (3 points) 3. On the dashboard in the Excel file note that the NPV and the investment efficiency are displayed (based on the settings on the input sheet). Answer these questions in general, not specifically for the Eagle Energy decision. (18 points) a. What does NPV tell you? When would it be an attractive as a decision criterion to a company? b. What does investment efficiency tell you? When would it be an attractive as a decision criterion to a company? c. What does cash sink tell you? When would it be an attractive as a decision criterion to a company? Save your work in the Eagle Oil.xlsx file by renaming it with your name in front, for example if your last name is Smith, as "Smith Eagle Oil.xlsx." In your Excel file show the decision tree from Task 1. Upload this file along with your answer sheet.

Appendix: Eagle Energy Details These data are in the Excel File Eagle Oil.xlsx on the Inputs worksheet. You do not need to retype any data into the Excel file. It is provided here for your reference. The year of first oil production depends on the selected facility size and the construction schedule uncertainty Schedule Uncertainty Facility Size P10 250 P90 20,000 barrel per day facility 2025 2025 1025 40,000 barrel per day facility 2026 2027 2029 50,000 barrel per day facility 202 2028 2029 Facility CAPEX Facility Size CAPEX, million USD 20,000 barrel per day facility 100 10,000 barrel per day facility 540 50,000 barrel per day facility 570 Well CAPEX. If developed, the well CAPEX is, in millions of USD per given year: Year 1 t Oil Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 20 10 10 10 5 5 5 OPEX Facility Size OPEX, million USD per year 20,000 barrel per day facility 20 40,000 barrel per day facility 34 50,000 barrel per day facility 44 Production Estimates: Facility Size Production, million barrels total P10 96 P50 173 P90 182Production Estimates 30 25 20 Million BPY 15 10 5 2020 2025 2030 2035 2040 2045 Series1 . P50 . p10 Figure 1. Oil Production Profiles (Estimates) if production starts in 2025. Details are in the Excel file. Oil Price forecast: Crude Oil Price, USD per barrel P10 25 P50 45 P90 65 Tax Rate: 21% Depreciation: 7 year straight line Discount Rate: 15%