PO.RES.Reserves.EconLimit
Description
The production rate at which a well or field stops paying for itself: the rate at which the net revenue from each barrel (or Mscf), after royalty, production tax and variable operating cost, just covers the fixed operating cost. A decline forecast ends where it falls to this rate, which fixes the reserves and the cessation date (`PO.ECON.COP.Date`).
Formula
=LAMBDA(Price, Royalty, Tax, Opex, Fixed, LET(
netback, Price*(1-Royalty)*(1-Tax)-Opex,
IF(netback>0, Fixed/netback, NA())))Parameters
| Parameter | Unit | Description |
|---|---|---|
Price |
currency/unit | Realised price per barrel or per Mscf |
Royalty |
fraction | Royalty share of the gross revenue |
Tax |
fraction | Production (severance) tax on the revenue after royalty; 0 if none |
Opex |
currency/unit | Variable operating cost per barrel or per Mscf |
Fixed |
currency/period | Fixed operating cost per period (per month for a monthly forecast) |
Examples
| Invocation | Expected |
|---|---|
=PO.RES.Reserves.EconLimit(70, 0.125, 0.05, 12, 30000) |
649.526387 |
=PO.RES.Reserves.EconLimit(3.5, 0.2, 0, 0.8, 15000) |
7500 |
=IF(ISERROR(PO.RES.Reserves.EconLimit(10, 0.2, 0, 8, 1000)), 1, 0) |
1 |