---
cid: po.bp.econ.breakeven.price
hub: econ
tags: [economics, break-even, oil-price, NPV, sensitivity, well-cost, D&C, one-well, Newton, cash-flow]
facets: { discipline: economics, method-type: analytical }
title: Break-Even Oil Price
summary: "Finds the oil price at which one well's NPV falls to zero and how that break-even price moves with the well cost."
slug: po.econ.breakeven.price
type: worksheet
---

# Break-Even Oil Price

## Description

At what oil price does a well stop paying for itself, and how much does that price move with the well's cost? You enter one well's type curve, prices, interests, taxes, costs and discount rate, a sweep of oil prices and a range of well costs. You read off the break-even, the oil price at which the well's NPV is zero, how far the input price clears it, and the break-even at each well cost.

**Parameters:**
- **The well**: the month it comes online `BE_Online`, the life cap `BE_LifeCap` (months), the type curve's initial rate `BE_IP` (STB/d), Arps exponent `BE_b`, effective secant initial decline `BE_Dei`, effective terminal decline `BE_Dterm`, the gas-oil ratio `BE_GOR` (scf/STB) and the type-curve factor `BE_TC`
- **Prices**: oil `BE_Oil` ($/STB) less `BE_OilDiff`, gas `BE_Gas` ($/MMBtu) less `BE_GasDiff`, and escalation `BE_Esc`
- **Interests and taxes**: `BE_WI`, `BE_NRI`, severance `BE_SevOil` and `BE_SevGas`, and ad valorem `BE_AdVal`
- **Costs**: the D&C `BE_DC` ($MM), fixed LOE `BE_LOE` ($/well-month), variable LOE `BE_LOEVar` ($/STB), gathering `BE_Gath` ($/Mscf), plugging `BE_PA` ($), and the D&C phasing `BE_Phase4` to `BE_Phase1`
- **Discounting and the search**: the discount rate `BE_Disc`, the cushion the oil price must clear the break-even by `BE_Cushion`, and the largest price change the last pass may make `BE_Tol` ($/STB)
- **Sweep and well costs**: the oil prices of the sweep table, and the D&C values of the well-cost table

**How to use it:** The well is the workbook's illustrative case, not a forecast. Type the well's own type curve, costs and gas price over the inputs, set the sweep across the prices the well may see so that its NPVs straddle zero, and the well costs across the range of AFEs being weighed. The sheet prices the well's monthly cash flow at each sweep price, takes the sweep's zero crossing as a first estimate and refines it with three Newton passes on the full model; the same search at five well costs gives the break-even against the D&C. The first chart draws the NPV against the oil price, with the zero line and the break-even marked; the second draws the break-even against the well cost. Check that the input oil price is above the break-even and clears it by at least the cushion, that the sweep's NPVs straddle zero so that it brackets a break-even, and that the last pass moves the price by less than the tolerance.

**Method:** Each NPV is the full monthly model of the NPV and IRR sheet, written as one cell, with the capital phased over the months before first production: the type curve sampled at mid-month to the economic limit, the operating margin per barrel u = (Oil − OilDiff)·NRI·(1 − SevOil − AdVal) + GOR/1000·((Gas − GasDiff)·NRI·(1 − SevGas − AdVal) − Gath·WI) − LOEVar·WI, a month's cash esc·(u·oil − LOE·WI) − capital − plugging, discounted end of month. For a fixed producing life the NPV is linear in the oil price, slope NRI·(1 − SevOil − AdVal) times the discounted oil; the life shortens as the price falls, so the NPV is only nearly linear. Pass 0 is the crossing of the sweep's NPV line with zero, by linear interpolation between the sweep's prices. Each pass then prices its oil price on the full model and steps by −NPV/S, S the sweep's least-squares slope, $MM per $/STB; the passes are rows, not a circular reference, and the last row's next price is the break-even. The D&C enters the cash flow linearly, through the discounted capital per $MM of D&C, K = WI·Σ shareᵢ·(1 + Disc)^(−monthᵢ/12)/Σ shareᵢ, so a well cost's first estimate is the base break-even plus (D&C − base D&C)·K/S, refined by two passes.

**Example:** The well-program workbook's base case for one well, the same well as the NPV and IRR sheet: one Texas horizontal, 800 STB/d on an Arps hyperbolic with b = 1 and a 65 %/yr secant decline to an 8 %/yr tail, 1,500 scf/STB, a 100 % WI and 75 % NRI, Texas severance and ad valorem, a $7MM well spent the month before it comes online in month 3, $8,000 a month of fixed LOE and 10 % discounting. Oil is $70/STB and gas $3.00/MMBtu. The sweep runs from $20 to $100 in $10 steps and the well costs from $5MM to $9MM; the cushion is 25 % and the tolerance $0.01/STB.

The NPV at $70 oil is $9.80MM, the NPV and IRR sheet's. The sweep runs from −$3.82MM at $20 to $17.98MM at $100, with a least-squares slope of $0.2726MM per $/STB, and crosses zero at $34.09/STB by interpolation between $30 (−$1.11MM) and $40 (+$1.61MM). Three passes settle the break-even at $34.09/STB to a millionth of a dollar; the input price clears it by 105 %. A $1MM well costs 1.1^(−2/12) = $0.984MM discounted, so the break-even rises by 0.984/0.2726 = $3.61/STB per $MM: the table gives $26.85, $30.47, $34.09, $37.71 and $41.32/STB at $5MM to $9MM, a least-squares slope of $3.618/STB per $MM. At $40 oil the NPV is $1.61MM, 17.3 % above the break-even, inside the 25 % cushion; at $30 it is −$1.11MM, below the break-even. At $1.50/MMBtu gas the NPV is $9.20MM and the break-even $36.27/STB. These break-evens match a bisection on a plain monthly loop of the workbook's model to the cent.

## Validity

A before-income-tax, single-well break-even on a flat oil price with the gas price held, so it is the oil price at which this well's NPV at this discount rate is zero, not a full-cycle or corporate break-even. The life is cut at the economic limit, which moves with the price, so the break-even includes the shorter life of a cheaper barrel. The Newton steps converge because the NPV is nearly linear in price; a sweep that does not straddle zero leaves no crossing to start from, and the sheet flags it. A break-even at a higher discount rate is higher: discount at the company's hurdle for a hurdle break-even. Named alternatives: the NPV and IRR sheet for the NPV, IRR and payout at one price; the tornado sensitivity sheet for price ranked against the other inputs; the well-program workbook for a program of wells on a price strip.

## References

- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 1, 2nd ed. PennWell (break-even analysis).
- Seba, R.D. (1998). *Economics of Worldwide Petroleum Production*. OGCI Publications.
- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228–247.
- Press, W.H., Teukolsky, S.A., Vetterling, W.T. and Flannery, B.P. (2007). *Numerical Recipes*, 3rd ed. Cambridge University Press, ch. 9 (Newton's method and root bracketing).

## Functions used

`PO.ECON.NPV.Monthly`, `PO.ECON.Capex.Phasing`, `PO.Spline.Linear.Intersect`

## Spreadsheet: BreakevenPrice

|     | A                                                                                                                                                | B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | D                   | E                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | F                   |
|-----|--------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|
| 1   | Break-Even Oil Price                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 2   | Blue cells on yellow are inputs: the well-program workbook's base case for one well, the price sweep and the well costs. The break-even follows. |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 3   | The Well, Its Timing and Type Curve                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 4   | Month the well comes online (month 1 starts the evaluation)                                                                                      | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | months                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 5   | Longest producing life of the well                                                                                                               | 360                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | months                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 6   | Initial oil rate of the type curve                                                                                                               | 800                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 7   | Arps hyperbolic exponent b                                                                                                                       | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 8   | Initial decline, effective secant                                                                                                                | 0.65                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 9   | Terminal decline, effective (exponential tail)                                                                                                   | 0.08                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 10  | Gas-oil ratio, constant over life                                                                                                                | 1500                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 11  | Type-curve factor (scales the initial rate)                                                                                                      | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 12  | Prices, Interests and Texas Taxes                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 13  | Oil price (WTI)                                                                                                                                  | 70                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 14  | Oil differential, deducted (quality and transport)                                                                                               | 1.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 15  | Gas price (Henry Hub, 1 MMBtu per Mscf)                                                                                                          | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $/MMBtu                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 16  | Gas differential, deducted (Waha basis)                                                                                                          | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $/MMBtu                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 17  | Escalation of prices and operating costs                                                                                                         | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 18  | Working interest (scales costs and capital)                                                                                                      | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 19  | Net revenue interest (25 % royalty at 100 % WI)                                                                                                  | 0.75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 20  | Oil severance tax (Texas, of the oil's value)                                                                                                    | 0.046                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 21  | Gas severance tax (Texas, of the gas's value)                                                                                                    | 0.075                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 22  | Ad valorem tax, as a share of net revenue                                                                                                        | 0.025                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 23  | Costs and the Capital Phasing                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 24  | Drilling and completion of the well                                                                                                              | 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 25  | Fixed LOE                                                                                                                                        | 8000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | $/well-month                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 26  | Variable LOE per barrel of oil                                                                                                                   | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 27  | Gas gathering and processing                                                                                                                     | 0.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | $/Mscf                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 28  | Plugging and abandonment, the month after the last production                                                                                    | 150000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | $                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 29  | D&C share spent four months before online                                                                                                        | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 30  | D&C share spent three months before online                                                                                                       | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 31  | D&C share spent two months before online                                                                                                         | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 32  | D&C share spent the month before online                                                                                                          | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 33  | Discounting                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 34  | Discount rate, end-of-month cash flows                                                                                                           | 0.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 35  | Margin the oil price must clear the break-even by                                                                                                | 0.25                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 36  | Largest price change the last pass may make                                                                                                      | 0.01                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 38  | Calculation Constants                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 39  | Days in a month, 365.25/12                                                                                                                       | 30.4375                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | days/month                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 40  | Months in a year                                                                                                                                 | 12                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | months/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 41  | Dollars in a million                                                                                                                             | 1000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | $/$MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 43  | The Decline, the Economic Limit and the Well's Life at the Input Prices                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 44  | Initial nominal decline, from the effective secant                                                                                               | =((1-BE_Dei)^(-BE_b)-1)/BE_b                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 45  | Terminal nominal decline, from the effective                                                                                                     | =-LN(1-BE_Dterm)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 46  | Time the hyperbolic switches to the terminal decline                                                                                             | =MAX(0,(BE_Di/BE_Dt-1)/(BE_b*BE_Di))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | years                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 47  | Rate at the switch over the initial rate                                                                                                         | =(1+BE_b*BE_Di*BE_Ts)^(-1/BE_b)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 48  | Initial oil rate, IP × type-curve factor                                                                                                         | =BE_IP*BE_TC                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 49  | Operating margin per barrel of oil, net of royalty and taxes                                                                                     | =(BE_Oil-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 50  | Economic-limit oil rate, fixed LOE over the margin                                                                                               | =IF(AND(BE_Margin>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*BE_Margin),BE_Qi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 51  | Time the decline takes to reach the limit                                                                                                        | =IF(BE_QLimit>=BE_Qi,0,IF(BE_QLimit>=BE_Qi*BE_Qs,((BE_Qi/BE_QLimit)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(BE_Qi*BE_Qs/BE_QLimit)/BE_Dt))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | years                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 52  | Producing life, to the economic limit or the cap                                                                                                 | =IF(BE_Margin<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*BE_TLimit))))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | months                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 54  | The Break-Even Oil Price                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 55  | NPV at the input oil price                                                                                                                       | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(BE_Oil-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 56  | NPV per $/STB of oil price, the sweep's slope                                                                                                    | =SLOPE($B$81:$B$89,$A$81:$A$89)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 57  | Discounted capital per $MM of D&C                                                                                                                | =BE_WI*SUMPRODUCT(BE_Phasing,(1+BE_Disc)^(-BE_Spend/BE_MoYr))/SUM(BE_Phasing)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 58  | Break-even oil price, NPV = 0                                                                                                                    | =$D$96                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 59  | Change in the last pass                                                                                                                          | =$D$96-$B$96                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 60  | Oil price over the break-even, less one                                                                                                          | =BE_Oil/BE_Breakeven-1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 61  | Break-even per $MM of D&C, the sensitivity's slope                                                                                               | =SLOPE($F$100:$F$104,$A$100:$A$104)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 62  | Lowest NPV of the sweep                                                                                                                          | =MIN($B$81:$B$89)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 63  | Highest NPV of the sweep                                                                                                                         | =MAX($B$81:$B$89)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 64  | Price check                                                                                                                                      | =IF(BE_Oil<BE_Breakeven,"FAIL",IF(BE_Headroom<BE_Cushion,"WARN","PASS"))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =IF(BE_Oil<BE_Breakeven,"$"&FIXED(BE_Oil,2)&" oil is below the $"&FIXED(BE_Breakeven,2)&" break-even",IF(BE_Headroom<BE_Cushion,"$"&FIXED(BE_Oil,2)&" oil clears the break-even by under "&FIXED(BE_Cushion*100,0)&" %","$"&FIXED(BE_Oil,2)&" oil clears the $"&FIXED(BE_Breakeven,2)&" break-even by "&FIXED(BE_Headroom*100,0)&" %"))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 65  | Sweep check                                                                                                                                      | =IF(AND(BE_SweepMin<0,BE_SweepMax>0),"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =IF(AND(BE_SweepMin<0,BE_SweepMax>0),"the sweep crosses zero NPV","the sweep does not cross zero NPV, so it does not bracket the break-even: widen its prices")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 66  | Convergence check                                                                                                                                | =IF(ABS(BE_LastChange)<=BE_Tol,"PASS","WARN")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(ABS(BE_LastChange)<=BE_Tol,"the last pass moved the price by under $"&FIXED(BE_Tol,2)&"/STB","the last pass still moved the price by $"&FIXED(BE_LastChange,2)&"/STB")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 69  | How to use it: type the well's own type curve, costs and gas price, and set the sweep across the prices it may see.                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 70  | The defaults are the well-program workbook's illustrative base case for one well. Only the oil price moves; gas stays at its input.              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 72  | Capital Phasing (nothing to edit)                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 73  | Spent, months before online                                                                                                                      | Share                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Month spent (month)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 74  | =4                                                                                                                                               | =BE_Phase4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | =MAX(1,BE_Online-A74)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 75  | =3                                                                                                                                               | =BE_Phase3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | =MAX(1,BE_Online-A75)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 76  | =2                                                                                                                                               | =BE_Phase2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | =MAX(1,BE_Online-A76)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 77  | =1                                                                                                                                               | =BE_Phase1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | =MAX(1,BE_Online-A77)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 79  | NPV Against the Oil Price                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 80  | Oil price ($/STB)                                                                                                                                | NPV ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Zero NPV ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 81  | 20                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A81-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 82  | 30                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A82-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 83  | 40                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A83-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 84  | 50                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A84-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 85  | 60                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A85-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 86  | 70                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A86-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 87  | 80                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A87-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 88  | 90                                                                                                                                               | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A88-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 89  | 100                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(A89-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM    | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 91  | The Search, Pass by Pass (nothing to edit)                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 92  | Pass                                                                                                                                             | Oil price ($/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | NPV there ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Next price ($/STB)  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 93  | =0                                                                                                                                               | =PO.Spline.Linear.Intersect($A$81:$A$89,$B$81:$B$89,$A$81:$A$89,$C$81:$C$89,1)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B93-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B93-C93/BE_Slope   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 94  | =1                                                                                                                                               | =D93                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B94-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B94-C94/BE_Slope   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 95  | =2                                                                                                                                               | =D94                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B95-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B95-C95/BE_Slope   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 96  | =3                                                                                                                                               | =D95                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B96-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(BE_DC*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B96-C96/BE_Slope   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 98  | Break-Even Against the Well Cost                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |
| 99  | D&C ($MM)                                                                                                                                        | First estimate ($/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | NPV there ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Pass 1 ($/STB)      | NPV there ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Break-even ($/STB)  |
| 100 | 5                                                                                                                                                | =BE_Breakeven+(A100-BE_DC)*BE_CapitalPv/BE_Slope                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B100-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A100*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B100-C100/BE_Slope | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(D100-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A100*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =D100-E100/BE_Slope |
| 101 | 6                                                                                                                                                | =BE_Breakeven+(A101-BE_DC)*BE_CapitalPv/BE_Slope                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B101-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A101*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B101-C101/BE_Slope | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(D101-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A101*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =D101-E101/BE_Slope |
| 102 | 7                                                                                                                                                | =BE_Breakeven+(A102-BE_DC)*BE_CapitalPv/BE_Slope                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B102-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A102*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B102-C102/BE_Slope | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(D102-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A102*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =D102-E102/BE_Slope |
| 103 | 8                                                                                                                                                | =BE_Breakeven+(A103-BE_DC)*BE_CapitalPv/BE_Slope                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B103-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A103*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B103-C103/BE_Slope | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(D103-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A103*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =D103-E103/BE_Slope |
| 104 | 9                                                                                                                                                | =BE_Breakeven+(A104-BE_DC)*BE_CapitalPv/BE_Slope                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(B104-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A104*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =B104-C104/BE_Slope | =PO.ECON.NPV.Monthly(LET(cs_qi,BE_IP*BE_TC,cs_u,(D104-BE_OilDiff)*BE_NRI*(1-BE_SevOil-BE_AdVal)+BE_GOR/1000*((BE_Gas-BE_GasDiff)*BE_NRI*(1-BE_SevGas-BE_AdVal)-BE_Gath*BE_WI)-BE_LOEVar*BE_WI,cs_ql,IF(AND(cs_u>0,BE_LOE>0),BE_LOE*BE_WI/(BE_Days*cs_u),cs_qi),cs_qs,cs_qi*BE_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^BE_b-1)/(BE_b*BE_Di),BE_Ts+LN(cs_qs/cs_ql)/BE_Dt)),cs_life,IF(cs_u<=0,0,IF(BE_LOE<=0,BE_LifeCap,MIN(BE_LifeCap,INT(BE_MoYr*cs_yr)))),cs_mon,SEQUENCE(BE_Online+cs_life),cs_age,cs_mon-BE_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/BE_MoYr,cs_oil,cs_on*((cs_t<=BE_Ts)*cs_qi*(1+BE_b*BE_Di*cs_t)^(-1/BE_b)+(cs_t>BE_Ts)*cs_qs*EXP(-BE_Dt*(cs_t-BE_Ts)))*BE_Days,cs_esc,(1+BE_Esc)^((cs_mon-1)/BE_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(BE_Spend))*1,PO.ECON.Capex.Phasing(A104*BE_PerMM*BE_WI,BE_Phasing)),cs_esc*(cs_oil*cs_u-BE_LOE*BE_WI*cs_on)-cs_cap-(cs_mon=BE_Online+cs_life)*BE_PA*BE_WI),BE_Disc)/BE_PerMM | =D104-E104/BE_Slope |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.ECON.NPV.Monthly | =LAMBDA(cash,annual_rate,NPV((1+annual_rate)^(1/12)-1,cash)) | NPV of end-of-month cash flows at an annual discount rate, in the units of cash. |
| PO.ECON.Capex.Phasing | =LAMBDA(total,profile,total*profile/SUM(profile)) | Spreads a capital total over periods in proportion to a phasing profile; returns an array the shape of the profile, in the units of total. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| BE_Online | $B$4 | Month the well comes online (month 1 starts the evaluation), months |
| BE_LifeCap | $B$5 | Longest producing life of the well, months |
| BE_IP | $B$6 | Initial oil rate of the type curve, STB/d |
| BE_b | $B$7 | Arps hyperbolic exponent b |
| BE_Dei | $B$8 | Initial decline, effective secant, %/yr |
| BE_Dterm | $B$9 | Terminal decline, effective (exponential tail), %/yr |
| BE_GOR | $B$10 | Gas-oil ratio, constant over life, scf/STB |
| BE_TC | $B$11 | Type-curve factor (scales the initial rate) |
| BE_Oil | $B$13 | Oil price (WTI), $/STB |
| BE_OilDiff | $B$14 | Oil differential, deducted (quality and transport), $/STB |
| BE_Gas | $B$15 | Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
| BE_GasDiff | $B$16 | Gas differential, deducted (Waha basis), $/MMBtu |
| BE_Esc | $B$17 | Escalation of prices and operating costs, %/yr |
| BE_WI | $B$18 | Working interest (scales costs and capital), % |
| BE_NRI | $B$19 | Net revenue interest (25 % royalty at 100 % WI), % |
| BE_SevOil | $B$20 | Oil severance tax (Texas, of the oil's value), % |
| BE_SevGas | $B$21 | Gas severance tax (Texas, of the gas's value), % |
| BE_AdVal | $B$22 | Ad valorem tax, as a share of net revenue, % |
| BE_DC | $B$24 | Drilling and completion of the well, $MM |
| BE_LOE | $B$25 | Fixed LOE, $/well-month |
| BE_LOEVar | $B$26 | Variable LOE per barrel of oil, $/STB |
| BE_Gath | $B$27 | Gas gathering and processing, $/Mscf |
| BE_PA | $B$28 | Plugging and abandonment, the month after the last production, $ |
| BE_Phase4 | $B$29 | D&C share spent four months before online, % |
| BE_Phase3 | $B$30 | D&C share spent three months before online, % |
| BE_Phase2 | $B$31 | D&C share spent two months before online, % |
| BE_Phase1 | $B$32 | D&C share spent the month before online, % |
| BE_Disc | $B$34 | Discount rate, end-of-month cash flows, %/yr |
| BE_Cushion | $B$35 | Margin the oil price must clear the break-even by, % |
| BE_Tol | $B$36 | Largest price change the last pass may make, $/STB |
| BE_Phasing | $B$29:$B$32 | The D&C phasing shares, four months before the well comes online down to the month before |
| BE_Inputs | $B$4:$B$36 | The well's timing and type curve, prices, interests and taxes, costs and capital phasing, the discount rate, the price cushion and the search tolerance |
| BE_Days | $B$39 | Days in a month, 365.25/12, days/month |
| BE_MoYr | $B$40 | Months in a year, months/yr |
| BE_PerMM | $B$41 | Dollars in a million, $/$MM |
| BE_Di | $B$44 | Initial nominal decline, from the effective secant, 1/yr |
| BE_Dt | $B$45 | Terminal nominal decline, from the effective, 1/yr |
| BE_Ts | $B$46 | Time the hyperbolic switches to the terminal decline, years |
| BE_Qs | $B$47 | Rate at the switch over the initial rate |
| BE_Qi | $B$48 | Initial oil rate, IP × type-curve factor, STB/d |
| BE_Margin | $B$49 | Operating margin per barrel of oil, net of royalty and taxes, $/STB |
| BE_QLimit | $B$50 | Economic-limit oil rate, fixed LOE over the margin, STB/d |
| BE_TLimit | $B$51 | Time the decline takes to reach the limit, years |
| BE_Life | $B$52 | Producing life, to the economic limit or the cap, months |
| BE_NPV | $B$55 | NPV at the input oil price, $MM |
| BE_Slope | $B$56 | NPV per $/STB of oil price, the sweep's slope, $MM |
| BE_CapitalPv | $B$57 | Discounted capital per $MM of D&C |
| BE_Breakeven | $B$58 | Break-even oil price, NPV = 0, $/STB |
| BE_LastChange | $B$59 | Change in the last pass, $/STB |
| BE_Headroom | $B$60 | Oil price over the break-even, less one, % |
| BE_CostSlope | $B$61 | Break-even per $MM of D&C, the sensitivity's slope, $/STB |
| BE_SweepMin | $B$62 | Lowest NPV of the sweep, $MM |
| BE_SweepMax | $B$63 | Highest NPV of the sweep, $MM |
| BE_PriceCheck | $B$64 | Price check verdict |
| BE_PriceCheckNote | $C$64 | Price check comment |
| BE_SweepCheck | $B$65 | Sweep check verdict |
| BE_SweepCheckNote | $C$65 | Sweep check comment |
| BE_ConvergenceCheck | $B$66 | Convergence check verdict |
| BE_ConvergenceCheckNote | $C$66 | Convergence check comment |
| BE_Results | $B$44:$B$66 | The decline terms, the economic limit and life, the NPV at the input price, the sweep's slope, the discounted capital per $MM, the break-even and its headroom, the cost slope and three checks |
| BE_CapitalPhasing | $A$74:$C$77 | Each D&C share's lead, its share and the month it is spent (before month 1 it falls in month 1) |
| BE_Spend | $C$74:$C$77 | The month each D&C share is spent, four months before online down to the month before |
| BE_Sweep | $A$81:$C$89 | Oil prices, the well's NPV at each with the rest at the inputs, and the zero line |
| BE_Search | $A$93:$D$96 | Pass 0 reads the sweep's crossing; each pass prices its oil price and steps by minus the NPV over the slope |
| BE_Costs | $A$100:$F$104 | Well costs, a first estimate of each break-even, two Newton passes and the break-even |
| BE_SweepCurve | $A$81:$C$89 | NPV Against the Oil Price |
| BE_CostCurve | $A$100:$F$104 | Break-Even Oil Price Against the Well Cost |

---

## Related Blueprints
- [Decline Economics](/blueprint/po.econ.decline.economics.md)
- [One-Well NPV and IRR](/blueprint/po.econ.npv.irr.md)
- [One-Well NPV Tornado](/blueprint/po.econ.tornado.sensitivity.md)
- [Workover Decision](/blueprint/po.econ.workover.decision.md)
- [Production Sharing Contract Split](/blueprint/po.econ.psc.split.md)
- [Injector Hall Plot and Voidage Replacement](/blueprint/po.res.hall.plot.md)

