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

Need a custom LAMBDA? Suggest a New Lambda