In: Finance
"An oil producer is trying to decide if and when it should abandon an oil field. For simplicity, assume the producer will abandon immediately (year 0), at the end of year 1, at the end of year 2, or stay at least through the next two years. The major uncertainty is the price of oil, which can go up or down in any year. In each year, there is a 0.49 probability the oil price will go up and a 0.51 probability the oil price will go down. The oil producer decides whether or not to abandon the oil field and then observes whether the price of oil increases or decreases in the following year. The NPV includes all the relevant costs of abandoning the oil field and producing oil and the revenue gained from producing oil. It also already incorporates the producer's MARR. After the producer makes a decision at the end of year 2, we assume there is no more uncertainty. If the producer abandons the oil field at the end of a year, the price of oil in the following years does not impact the producer's NPV. Solve a decision tree to calculate what the oil producer should do immediately, at the end of year 1, and at the end of year 2. You should assume an expected-value decision maker. Enter the expected NPV of the best alternative. The best alternative may have a negative expected NPV.
- If the producer decides to abandon the oil field immediately, the NPV is -$41,000 - If the producer decides to abandon at the end of year 1 and the oil price goes up, the NPV is $0 - If the producer decides to abandon at the end of year 1 and the oil price goes down, the NPV is -$59,000 - If the producer decides to abandon at the end of year 2 and the oil price goes up in years 1 and 2, the NPV is $64,000 - If the producer decides to abandon at the end of year 2 and the oil price goes up in year 1 and goes down in year 2, the NPV is $36,000 - If the producer decides to abandon at the end of year 2 and the oil price goes down in year 1 and goes up in year 2, the NPV is -$5,000 - If the producer decides to abandon at the end of year 2 and the oil price goes down in years 1 and 2, the NPV is -$112,000 - If the producer decides to not abandon the oil field and the oil price goes up in years 1 and 2, the NPV is $65,000 - If the producer decides to not abandon and the oil price goes up in year 1 and goes down in year 2, the NPV is $13,000 - If the producer decides not to abandon and the oil price goes down in year 1 and goes up in year 2, the NPV is -$22,000 - If the producer decides not to abandon and the oil price goes down in years 1 and 2, the NPV is -$69,000"
We have the following calculations based on different scenarios:
Break down of formulas for probability is mentioned below: