---
cid: po.bp.econ.decline.economics
hub: econ
tags: [economics, decline, economic-limit, cessation-of-production, reserves, PV, economic-life, Arps, forecast, one-well]
facets: { discipline: economics, method-type: analytical }
title: Decline Economics
summary: "How much oil is left in a producing well, what it is worth and when it stops paying, from its decline forecast to the economic limit."
slug: po.econ.decline.economics
type: worksheet
---

# Decline Economics

## Description

How much oil is left in a producing well, what is it worth, and when does the well stop paying? You enter the well's Arps type curve and months on production, the price deck, interests, taxes and costs. You read off the economic limit, the date the forecast falls to it (the cessation of production), the remaining reserves to that date, their PV after operating costs and plugging, and the economic life left.

**Parameters:**
- **The well**: the months it has produced `DEC_Age`, the date the forecast starts `DEC_Start`, the forecast's horizon `DEC_Horizon` (months), the type curve's initial rate `DEC_IP` (STB/d), Arps exponent `DEC_b`, effective secant initial decline `DEC_Dei` and effective terminal decline `DEC_Dterm`, the gas-oil ratio `DEC_GOR` (scf/STB) and the type-curve factor `DEC_TC`
- **Prices, interests and taxes**: oil `DEC_Oil` ($/STB) less `DEC_OilDiff`, gas `DEC_Gas` ($/MMBtu) less `DEC_GasDiff`, the escalation `DEC_Esc`, working interest `DEC_WI`, net revenue interest `DEC_NRI`, severance `DEC_SevOil` and `DEC_SevGas`, and ad valorem `DEC_AdVal`
- **Costs**: fixed LOE `DEC_LOE` ($/well-month), variable LOE `DEC_LOEVar` ($/STB), gathering `DEC_Gath` ($/Mscf) and plugging `DEC_PA` ($)
- **Discounting**: the discount rate `DEC_Disc`

**How to use it:** The defaults are an illustrative well, not a forecast. Fit the well's own decline to its history (the Arps or modified hyperbolic forecast sheets), then type its parameters, its months on production and today's date, and its own deck and costs. For a forecast that is not an Arps curve, type its mid-month rates over the Oil rate column and keep the columns to its right. The chart draws the forecast rate on a log scale against the years from today, with the economic limit and the cessation of production on it. The sheet checks that the forecast reaches the limit inside the horizon, flagging a well still above the limit at the horizon and a well that already makes less than its limit, and it reconciles the interpolated cessation date with the closed-form Arps time to the limit, to within a day.

**Method:** The rate follows the type curve, Arps hyperbolic with Di = ((1 − Dei)^(−b) − 1)/b switching to an exponential tail of Dt = −ln(1 − Dterm) at ts = (Di/Dt − 1)/(b·Di). It is read at mid-month of the well's age, t = (2·(age + m) − 1)/24 years in forecast month m, and dated Start + (m − ½)·30.4375. The economic-limit function takes one price, royalty, tax and variable cost, so the deck is folded into them. The value per barrel of oil, with its gas, is V = (Oil − OilDiff) + GOR/1000·(Gas − GasDiff), and the royalty is 1 − NRI/WI. The blended tax is 1 − ((Oil − OilDiff)·(1 − SevOil − AdVal) + GOR/1000·(Gas − GasDiff)·(1 − SevGas − AdVal))/V, and the variable cost is LOEVar + GOR/1000·Gath. The netback is V·(1 − royalty)·(1 − tax) − variable cost, which is the economics family's margin per barrel over WI. The limit is LOE/netback barrels a month (the WI cancels). The cessation date is the first month whose oil is at or below the limit, interpolated log-linearly from the month before; that is exact on the exponential tail. The well produces in the months above the limit and is plugged the month after. Each producing month earns WI·(netback·oil − LOE), escalated by (1 + Esc)^((m − 1)/12), and the PV discounts end-of-month flows by (1 + Disc)^(m/12). The closed-form time to the limit is ((Qi/qEL)^b − 1)/(b·Di) on the hyperbolic and ts + ln(Qi·Qs/qEL)/Dt on the tail.

**Example:** The default well is the economics family's well (the well-program workbook's base case for one well, as on the One-Well NPV and IRR sheet) after two years on production, with the forecast starting on 1 January 2026 and running at most 40 years. The well has 800 STB/d initial on an Arps hyperbolic with b = 1 and a 65 %/yr effective secant decline switching to an 8 %/yr exponential tail, and 1,500 scf/STB. The deck is $70/STB oil less $1.50 and $3.00/MMBtu gas less $1.00, flat, with 100 % WI and 75 % NRI. The well pays Texas severance of 4.6 % on oil and 7.5 % on gas and 2.5 % ad valorem, $8,000 a month of fixed LOE, $4/STB of variable LOE, $0.50/Mscf of gathering and $150,000 to plug. Cash is discounted at 10 %. The D&C is sunk, so it is not in the cash flow.

After 24 months the well makes 800/(1 + 1.857 × 49/24) = 167.0 STB/d. The value per barrel is 68.50 + 1.5 × 2.00 = $71.50, the royalty 25 %, the blended tax 1 − (68.50 × 0.929 + 3.00 × 0.900)/71.50 = 7.22 % and the variable cost 4 + 1.5 × 0.50 = $4.75/STB. The netback is 71.50 × 0.75 × 0.9278 − 4.75 = $45.00/STB, the margin of the One-Well NPV and IRR sheet. So the limit is 8,000/45.00 = 177.8 STB a month, or 5.84 STB/d. The tail reaches it at 11.45 + ln(35.92/5.840)/0.08338 = 33.24 years from first production, 31.24 years from today. The interpolated cessation falls on 29 March 2057 (serial 57433.13), the same 31.24 years: the dates agree to the day. The well has 375 producing months left and 376.1 MSTB of remaining reserves, worth $8.40MM at 10 % ($13.77MM undiscounted), plugging included.

At $40 oil the netback falls to $24.10/STB and the limit rises to 332.0 STB a month. The life left falls to 23.75 years, the reserves to 353.9 MSTB and the PV to $4.06MM. A 10-year horizon stops the forecast while the well is still above the limit, so there is no cessation date. Thirty-five years on (age 420) the well makes 5.03 STB/d, already below its limit; plugging it is worth −$0.149MM.

## Validity

A before-income-tax, deterministic, one-well forecast on an Arps-shaped decline with a constant GOR. The limit uses today's prices and costs; with escalation the true limit moves and the cessation date is approximate. On the hyperbolic part of the curve the log-linear interpolation between monthly points is close but not exact (a fraction of a day for the usual b), which the cessation-date check reports. The reserves are the forecast's, not a PRMS booking: risking, reserves categories and income tax are out of scope. Named alternatives: the One-Well NPV and IRR sheet for a new well with its capital; the Workover Decision sheet to value a workover on this well; the Arps decline forecast, modified hyperbolic decline and Arps EUR sensitivity sheets to fit and test the decline; the well-program workbook for a program of wells with a price strip. Field units.

## References

- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228–247.
- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 1, 2nd ed. PennWell (the economic limit and the cessation of production).
- Society of Petroleum Evaluation Engineers (2016). *Monograph 4: Estimating Ultimate Recovery of Developed Wells in Low-Permeability Reservoirs* (the hyperbolic with a terminal decline).
- SPE/WPC/AAPG/SPEE/SEG/SPWLA/EAGE (2018). *Petroleum Resources Management System* (the economic limit that ends reserves).

## Functions used

`PO.RES.Reserves.EconLimit`, `PO.ECON.COP.Date`, `PO.ECON.NPV.Monthly`

## Spreadsheet: DeclineEconomics

|     | A                                                                                                                                                                          | B                                                                                                                                                 | C                                                                                                                                                                                                                                                                                                                                                         | D                                          | E                                                                                | F                                                                                                                                                                                                                                              | G                                                                                          | H                                                                             |
|-----|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------|----------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------|
| 1   | Decline Economics                                                                                                                                                          |                                                                                                                                                   | Petroleum Office                                                                                                                                                                                                                                                                                                                                          |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 2   | Blue cells on yellow are inputs: the economics family's well after two years on production. The economic limit, cessation date, reserves and PV follow.                    |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 3   | The Well, Its Age and the Forecast                                                                                                                                         |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 4   | Months the well has produced before the forecast starts                                                                                                                    | 24                                                                                                                                                | months                                                                                                                                                                                                                                                                                                                                                    |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 5   | Date the forecast starts                                                                                                                                                   | 46023                                                                                                                                             | date                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 6   | Months the forecast runs, at most 1,200                                                                                                                                    | 480                                                                                                                                               | months                                                                                                                                                                                                                                                                                                                                                    |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 7   | Initial oil rate of the type curve                                                                                                                                         | 800                                                                                                                                               | STB/d                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 8   | Arps hyperbolic exponent b                                                                                                                                                 | 1                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 9   | Initial decline, effective secant                                                                                                                                          | 0.65                                                                                                                                              | %/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 10  | Terminal decline, effective (exponential tail)                                                                                                                             | 0.08                                                                                                                                              | %/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 11  | Gas-oil ratio, constant over life                                                                                                                                          | 1500                                                                                                                                              | scf/STB                                                                                                                                                                                                                                                                                                                                                   |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 12  | Type-curve factor (scales the initial rate)                                                                                                                                | 1                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 13  | Prices, Interests and Texas Taxes                                                                                                                                          |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 14  | Oil price (WTI)                                                                                                                                                            | 70                                                                                                                                                | $/STB                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 15  | Oil differential, deducted (quality and transport)                                                                                                                         | 1.5                                                                                                                                               | $/STB                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 16  | Gas price (Henry Hub, 1 MMBtu per Mscf)                                                                                                                                    | 3                                                                                                                                                 | $/MMBtu                                                                                                                                                                                                                                                                                                                                                   |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 17  | Gas differential, deducted (Waha basis)                                                                                                                                    | 1                                                                                                                                                 | $/MMBtu                                                                                                                                                                                                                                                                                                                                                   |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 18  | Escalation of prices and operating costs                                                                                                                                   | 0                                                                                                                                                 | %/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 19  | Working interest (scales costs and capital)                                                                                                                                | 1                                                                                                                                                 | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 20  | Net revenue interest (25 % royalty at 100 % WI)                                                                                                                            | 0.75                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 21  | Oil severance tax (Texas, of the oil's value)                                                                                                                              | 0.046                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 22  | Gas severance tax (Texas, of the gas's value)                                                                                                                              | 0.075                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 23  | Ad valorem tax, as a share of net revenue                                                                                                                                  | 0.025                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 24  | Operating and Plugging Costs                                                                                                                                               |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 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  | Discounting                                                                                                                                                                |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 30  | Discount rate, end-of-month cash flows                                                                                                                                     | 0.1                                                                                                                                               | %/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 32  | Calculation Constants                                                                                                                                                      |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 33  | Days in a month, 365.25/12                                                                                                                                                 | 30.4375                                                                                                                                           | days/month                                                                                                                                                                                                                                                                                                                                                |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 34  | Months in a year                                                                                                                                                           | 12                                                                                                                                                | months/yr                                                                                                                                                                                                                                                                                                                                                 |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 35  | Days in a year                                                                                                                                                             | 365.25                                                                                                                                            | days/yr                                                                                                                                                                                                                                                                                                                                                   |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 36  | Dollars in a million                                                                                                                                                       | 1000000                                                                                                                                           | $/$MM                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 38  | The Decline Today                                                                                                                                                          |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 39  | Initial nominal decline, from the effective secant                                                                                                                         | =((1-DEC_Dei)^(-DEC_b)-1)/DEC_b                                                                                                                   | 1/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 40  | Terminal nominal decline, from the effective                                                                                                                               | =-LN(1-DEC_Dterm)                                                                                                                                 | 1/yr                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 41  | Time the hyperbolic switches to the terminal decline                                                                                                                       | =MAX(0,(DEC_Di/DEC_Dt-1)/(DEC_b*DEC_Di))                                                                                                          | years                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 42  | Rate at the switch over the initial rate                                                                                                                                   | =(1+DEC_b*DEC_Di*DEC_Ts)^(-1/DEC_b)                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 43  | Initial oil rate, IP × type-curve factor                                                                                                                                   | =DEC_IP*DEC_TC                                                                                                                                    | STB/d                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 44  | Oil rate in the forecast's first month                                                                                                                                     | =LET(dn_t,(2*DEC_Age+1)/2/DEC_MoYr,(dn_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dn_t)^(-1/DEC_b)+(dn_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dn_t-DEC_Ts))) | STB/d                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 46  | The Economic Limit and the Cessation Date                                                                                                                                  |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 47  | Wellhead value per barrel of oil, with its gas                                                                                                                             | =DEC_Oil-DEC_OilDiff+DEC_GOR/1000*(DEC_Gas-DEC_GasDiff)                                                                                           | $/STB                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 48  | Royalty, 1 − NRI/WI                                                                                                                                                        | =1-DEC_NRI/DEC_WI                                                                                                                                 | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 49  | Severance and ad valorem, blended over oil and gas                                                                                                                         | =1-((DEC_Oil-DEC_OilDiff)*(1-DEC_SevOil-DEC_AdVal)+DEC_GOR/1000*(DEC_Gas-DEC_GasDiff)*(1-DEC_SevGas-DEC_AdVal))/DEC_Value                         | %                                                                                                                                                                                                                                                                                                                                                         |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 50  | Variable cost per barrel, LOE and the gas's gathering                                                                                                                      | =DEC_LOEVar+DEC_GOR/1000*DEC_Gath                                                                                                                 | $/STB                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 51  | Netback per barrel, value less royalty, taxes and variable cost                                                                                                            | =DEC_Value*(1-DEC_Roy)*(1-DEC_Tax)-DEC_Opex                                                                                                       | $/STB                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 52  | Economic limit, oil a month                                                                                                                                                | =PO.RES.Reserves.EconLimit(DEC_Value,DEC_Roy,DEC_Tax,DEC_Opex,DEC_LOE)                                                                            | STB                                                                                                                                                                                                                                                                                                                                                       |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 53  | Cessation-of-production date                                                                                                                                               | =PO.ECON.COP.Date(TAKE($B$101:$B$1300,DEC_Horizon),TAKE($D$101:$D$1300,DEC_Horizon),DEC_ELimit)                                                   | date                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 54  | Economic-limit oil rate                                                                                                                                                    | =DEC_ELimit/DEC_Days                                                                                                                              | STB/d                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 55  | Time from first production to the limit, Arps                                                                                                                              | =IF(DEC_QLimit>=DEC_Qi,0,IF(DEC_QLimit>=DEC_Qi*DEC_Qs,((DEC_Qi/DEC_QLimit)^DEC_b-1)/(DEC_b*DEC_Di),DEC_Ts+LN(DEC_Qi*DEC_Qs/DEC_QLimit)/DEC_Dt))   | years                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 56  | Life left to the limit, Arps                                                                                                                                               | =MAX(0,DEC_TLimit-DEC_Age/DEC_MoYr)                                                                                                               | years                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 57  | Life left to the COP date, or to the horizon                                                                                                                               | =IF(ISNUMBER(DEC_COP),(DEC_COP-DEC_Start)/DEC_DaysYr,DEC_Horizon/DEC_MoYr)                                                                        | years                                                                                                                                                                                                                                                                                                                                                     |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 58  | Producing months left, the forecast above the limit                                                                                                                        | =SUM((TAKE($D$101:$D$1300,DEC_Horizon)>DEC_ELimit)*1)                                                                                             | months                                                                                                                                                                                                                                                                                                                                                    |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 59  | Remaining Reserves and Their Value                                                                                                                                         |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 60  | Remaining reserves, oil to the economic limit                                                                                                                              | =SUM(TAKE($E$101:$E$1300,DEC_Horizon))/1000                                                                                                       | MSTB                                                                                                                                                                                                                                                                                                                                                      |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 61  | PV of the net cash, plugging included                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($F$101:$F$1300,DEC_Horizon),DEC_Disc)/DEC_PerMM                                                                         | $MM                                                                                                                                                                                                                                                                                                                                                       |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 62  | Net cash, undiscounted                                                                                                                                                     | =SUM(TAKE($F$101:$F$1300,DEC_Horizon))/DEC_PerMM                                                                                                  | $MM                                                                                                                                                                                                                                                                                                                                                       |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 64  | Economic limit check                                                                                                                                                       | =IF(DEC_Months=0,"FAIL",IF(ISNUMBER(DEC_COP),"PASS","WARN"))                                                                                      | =IF(DEC_Months=0,"the well makes "&FIXED(DEC_RateNow,2)&" STB/d, already below its limit of "&FIXED(DEC_QLimit,2)&" STB/d: plug it or rework it",IF(ISNUMBER(DEC_COP),"reaches its limit of "&FIXED(DEC_QLimit,2)&" STB/d in "&FIXED(DEC_Life,1)&" years","still above its limit of "&FIXED(DEC_QLimit,2)&" STB/d at the horizon: lengthen the horizon")) |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 65  | COP date against Arps                                                                                                                                                      | =IF(AND(ISNUMBER(DEC_COP),DEC_Months>0),IF(ABS(DEC_Life-DEC_Remain)*DEC_DaysYr<=1,"PASS","WARN"),"WARN")                                          | =IF(AND(ISNUMBER(DEC_COP),DEC_Months>0),IF(ABS(DEC_Life-DEC_Remain)*DEC_DaysYr<=1,"the COP date and the Arps time to the limit agree within a day","the COP date and the Arps time to the limit differ by "&FIXED(ABS(DEC_Life-DEC_Remain)*DEC_DaysYr,1)&" days"),"no cessation inside the forecast to reconcile")                                        |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 67  | How to use it: type the well's own decline from a fit to its history (the Arps Decline Forecast sheet), its months on production, today's date and its own deck and costs. |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 68  | The defaults are the economics family's illustrative well, not a forecast; the limit uses today's prices and costs, so with escalation it is approximate.                  |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 70  | The Forecast and the Limit by Year (nothing to edit)                                                                                                                       |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 71  | Years from today (years)                                                                                                                                                   | Oil rate (STB/d)                                                                                                                                  | Economic limit (STB/d)                                                                                                                                                                                                                                                                                                                                    |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 72  | =0                                                                                                                                                                         | =LET(dy_t,A72+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 73  | =2                                                                                                                                                                         | =LET(dy_t,A73+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 74  | =4                                                                                                                                                                         | =LET(dy_t,A74+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 75  | =6                                                                                                                                                                         | =LET(dy_t,A75+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 76  | =8                                                                                                                                                                         | =LET(dy_t,A76+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 77  | =10                                                                                                                                                                        | =LET(dy_t,A77+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 78  | =12                                                                                                                                                                        | =LET(dy_t,A78+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 79  | =14                                                                                                                                                                        | =LET(dy_t,A79+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 80  | =16                                                                                                                                                                        | =LET(dy_t,A80+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 81  | =18                                                                                                                                                                        | =LET(dy_t,A81+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 82  | =20                                                                                                                                                                        | =LET(dy_t,A82+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 83  | =22                                                                                                                                                                        | =LET(dy_t,A83+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 84  | =24                                                                                                                                                                        | =LET(dy_t,A84+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 85  | =26                                                                                                                                                                        | =LET(dy_t,A85+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 86  | =28                                                                                                                                                                        | =LET(dy_t,A86+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 87  | =30                                                                                                                                                                        | =LET(dy_t,A87+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 88  | =32                                                                                                                                                                        | =LET(dy_t,A88+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 89  | =34                                                                                                                                                                        | =LET(dy_t,A89+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 90  | =36                                                                                                                                                                        | =LET(dy_t,A90+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 91  | =38                                                                                                                                                                        | =LET(dy_t,A91+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 92  | =40                                                                                                                                                                        | =LET(dy_t,A92+DEC_Age/DEC_MoYr,(dy_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dy_t)^(-1/DEC_b)+(dy_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dy_t-DEC_Ts)))     | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 94  | The Cessation of Production on the Chart (nothing to edit)                                                                                                                 |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 95  | Point                                                                                                                                                                      | Years from today (years)                                                                                                                          | Oil rate (STB/d)                                                                                                                                                                                                                                                                                                                                          |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 96  | Cessation of production                                                                                                                                                    | =DEC_Life                                                                                                                                         | =DEC_QLimit                                                                                                                                                                                                                                                                                                                                               |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 98  | Monthly Forecast (each column spills from its first row to the horizon)                                                                                                    |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 99  | Mid-month rates and dates; money is end of month, escalated from month 1. The well produces while its month's oil is above the limit and is plugged the month after.       |                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                           |                                            |                                                                                  |                                                                                                                                                                                                                                                |                                                                                            |                                                                               |
| 100 | Month (month)                                                                                                                                                              | Mid-month date (date)                                                                                                                             | Oil rate (STB/d)                                                                                                                                                                                                                                                                                                                                          | Oil, forecast (STB)                        | Oil, produced (STB)                                                              | Net cash ($)                                                                                                                                                                                                                                   | Discounted net cash ($)                                                                    | Cumulative oil produced (STB)                                                 |
| 101 | =SEQUENCE(DEC_Horizon)                                                                                                                                                     | =DEC_Start+(2*TAKE($A$101:$A$1300,DEC_Horizon)-1)/2*DEC_Days                                                                                      | =LET(dm_t,(2*(TAKE($A$101:$A$1300,DEC_Horizon)+DEC_Age)-1)/2/DEC_MoYr,(dm_t<=DEC_Ts)*DEC_Qi*(1+DEC_b*DEC_Di*dm_t)^(-1/DEC_b)+(dm_t>DEC_Ts)*DEC_Qi*DEC_Qs*EXP(-DEC_Dt*(dm_t-DEC_Ts)))                                                                                                                                                                      | =TAKE($C$101:$C$1300,DEC_Horizon)*DEC_Days | =TAKE($D$101:$D$1300,DEC_Horizon)*(TAKE($A$101:$A$1300,DEC_Horizon)<=DEC_Months) | =(1+DEC_Esc)^((TAKE($A$101:$A$1300,DEC_Horizon)-1)/DEC_MoYr)*(DEC_WI*DEC_Netback*TAKE($E$101:$E$1300,DEC_Horizon)-DEC_LOE*DEC_WI*(TAKE($A$101:$A$1300,DEC_Horizon)<=DEC_Months))-(TAKE($A$101:$A$1300,DEC_Horizon)=DEC_Months+1)*DEC_PA*DEC_WI | =TAKE($F$101:$F$1300,DEC_Horizon)/(1+DEC_Disc)^(TAKE($A$101:$A$1300,DEC_Horizon)/DEC_MoYr) | =SCAN(0,TAKE($E$101:$E$1300,DEC_Horizon),LAMBDA(acc_sum,oil_m,acc_sum+oil_m)) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.Reserves.EconLimit | =LAMBDA(Price, Royalty, Tax, Opex, Fixed, LET(netback, Price*(1-Royalty)*(1-Tax)-Opex, IF(netback>0, Fixed/netback, NA()))) | Economic-limit rate: fixed cost per period over the netback per unit after royalty, production tax and variable opex; #N/A if the netback is not positive |
| PO.ECON.COP.Date | =LAMBDA(Dates, Rate, Limit, LET(i, SEQUENCE(ROWS(Rate)), hit, IFERROR(MATCH(1, (Rate<=Limit)*1, 0), 0), qb, SUM((i=hit)*Rate), qa, SUM((i=hit-1)*Rate), tb, SUM((i=hit)*Dates), ta, SUM((i=hit-1)*Dates), IF(hit=0, "none", IF(hit=1, tb, IF(qb>0, ta+(tb-ta)*LN(qa/Limit)/LN(qa/qb), ta+(tb-ta)*(qa-Limit)/(qa-qb)))))) | Cessation-of-production date: where a rate forecast first falls to the economic limit, interpolated log-linearly between dates; "none" if it never does |
| 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. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| DEC_Age | $B$4 | Months the well has produced before the forecast starts, months |
| DEC_Start | $B$5 | Date the forecast starts, date |
| DEC_Horizon | $B$6 | Months the forecast runs, at most 1,200, months |
| DEC_IP | $B$7 | Initial oil rate of the type curve, STB/d |
| DEC_b | $B$8 | Arps hyperbolic exponent b |
| DEC_Dei | $B$9 | Initial decline, effective secant, %/yr |
| DEC_Dterm | $B$10 | Terminal decline, effective (exponential tail), %/yr |
| DEC_GOR | $B$11 | Gas-oil ratio, constant over life, scf/STB |
| DEC_TC | $B$12 | Type-curve factor (scales the initial rate) |
| DEC_Oil | $B$14 | Oil price (WTI), $/STB |
| DEC_OilDiff | $B$15 | Oil differential, deducted (quality and transport), $/STB |
| DEC_Gas | $B$16 | Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
| DEC_GasDiff | $B$17 | Gas differential, deducted (Waha basis), $/MMBtu |
| DEC_Esc | $B$18 | Escalation of prices and operating costs, %/yr |
| DEC_WI | $B$19 | Working interest (scales costs and capital), % |
| DEC_NRI | $B$20 | Net revenue interest (25 % royalty at 100 % WI), % |
| DEC_SevOil | $B$21 | Oil severance tax (Texas, of the oil's value), % |
| DEC_SevGas | $B$22 | Gas severance tax (Texas, of the gas's value), % |
| DEC_AdVal | $B$23 | Ad valorem tax, as a share of net revenue, % |
| DEC_LOE | $B$25 | Fixed LOE, $/well-month |
| DEC_LOEVar | $B$26 | Variable LOE per barrel of oil, $/STB |
| DEC_Gath | $B$27 | Gas gathering and processing, $/Mscf |
| DEC_PA | $B$28 | Plugging and abandonment, the month after the last production, $ |
| DEC_Disc | $B$30 | Discount rate, end-of-month cash flows, %/yr |
| DEC_Inputs | $B$4:$B$30 | The well's age, the forecast's start and horizon, the type curve, prices, interests and taxes, operating and plugging costs, and the discount rate |
| DEC_Days | $B$33 | Days in a month, 365.25/12, days/month |
| DEC_MoYr | $B$34 | Months in a year, months/yr |
| DEC_DaysYr | $B$35 | Days in a year, days/yr |
| DEC_PerMM | $B$36 | Dollars in a million, $/$MM |
| DEC_Di | $B$39 | Initial nominal decline, from the effective secant, 1/yr |
| DEC_Dt | $B$40 | Terminal nominal decline, from the effective, 1/yr |
| DEC_Ts | $B$41 | Time the hyperbolic switches to the terminal decline, years |
| DEC_Qs | $B$42 | Rate at the switch over the initial rate |
| DEC_Qi | $B$43 | Initial oil rate, IP × type-curve factor, STB/d |
| DEC_RateNow | $B$44 | Oil rate in the forecast's first month, STB/d |
| DEC_Value | $B$47 | Wellhead value per barrel of oil, with its gas, $/STB |
| DEC_Roy | $B$48 | Royalty, 1 − NRI/WI, % |
| DEC_Tax | $B$49 | Severance and ad valorem, blended over oil and gas, % |
| DEC_Opex | $B$50 | Variable cost per barrel, LOE and the gas's gathering, $/STB |
| DEC_Netback | $B$51 | Netback per barrel, value less royalty, taxes and variable cost, $/STB |
| DEC_ELimit | $B$52 | Economic limit, oil a month, STB |
| DEC_COP | $B$53 | Cessation-of-production date, date |
| DEC_QLimit | $B$54 | Economic-limit oil rate, STB/d |
| DEC_TLimit | $B$55 | Time from first production to the limit, Arps, years |
| DEC_Remain | $B$56 | Life left to the limit, Arps, years |
| DEC_Life | $B$57 | Life left to the COP date, or to the horizon, years |
| DEC_Months | $B$58 | Producing months left, the forecast above the limit, months |
| DEC_Reserves | $B$60 | Remaining reserves, oil to the economic limit, MSTB |
| DEC_PV | $B$61 | PV of the net cash, plugging included, $MM |
| DEC_NetCash | $B$62 | Net cash, undiscounted, $MM |
| DEC_LimitCheck | $B$64 | Economic limit check verdict |
| DEC_LimitCheckNote | $C$64 | Economic limit check comment |
| DEC_CopCheck | $B$65 | COP date against Arps verdict |
| DEC_CopCheckNote | $C$65 | COP date against Arps comment |
| DEC_Results | $B$39:$B$65 | The decline terms and today's rate, the economic limit from the deck and the COP date, the Arps time to the limit, the life left, the remaining reserves, their PV and two checks |
| DEC_Rates | $A$72:$C$92 | Years from today, the forecast oil rate and the economic-limit rate |
| DEC_Cessation | $A$96:$C$96 | The life left to the COP date, and the economic-limit rate there |
| DEC_ForecastCurve | $A$72:$C$92 | The Forecast to the Economic Limit |

---

## Related Blueprints
- [Break-Even Oil Price](/blueprint/po.econ.breakeven.price.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)

