---
cid: po.bp.econ.npv.irr
hub: econ
tags: [economics, NPV, IRR, payout, PV-I, cash-flow, discounting, one-well, type-curve, severance, royalty]
facets: { discipline: economics, method-type: analytical }
title: One-Well NPV and IRR
summary: "Tests whether one well earns its cost of capital from a monthly cash flow, giving NPV, IRR, payout month, PV/I and the NPV profile."
slug: po.econ.npv.irr
type: worksheet
---

# One-Well NPV and IRR

## Description

Does one well earn its cost of capital, and by how much? You enter the well's type curve, prices, interests, Texas taxes, operating costs and phased capital. The sheet builds its monthly cash flow, and you read off the NPV at the discount rate, the IRR, the payout month, PV/I (the NPV over the discounted capital) and the NPV profile against the discount rate.

**Parameters:**
- **The well**: the month it comes online `NI_Online` (month 1 starts the evaluation), the life cap `NI_LifeCap` (months), the type curve's initial rate `NI_IP` (STB/d), Arps exponent `NI_b`, effective secant initial decline `NI_Dei` and effective terminal decline `NI_Dterm`, the gas-oil ratio `NI_GOR` (scf/STB) and the type-curve factor `NI_TC`
- **Prices**: oil `NI_Oil` ($/STB) less its differential `NI_OilDiff`, gas `NI_Gas` ($/MMBtu, 1 MMBtu per Mscf) less `NI_GasDiff`, and the escalation of prices and costs `NI_Esc`
- **Interests and taxes**: working interest `NI_WI`, net revenue interest `NI_NRI`, oil and gas severance `NI_SevOil` and `NI_SevGas`, and ad valorem `NI_AdVal`
- **Costs**: the D&C `NI_DC` ($MM), fixed LOE `NI_LOE` ($/well-month), variable LOE `NI_LOEVar` ($/STB of oil), gathering `NI_Gath` ($/Mscf) and plugging `NI_PA` ($)
- **Capital phasing**: the D&C shares spent four, three, two and one months before online, `NI_Phase4` to `NI_Phase1`
- **Discounting and limits**: the discount rate `NI_Disc`, the IRR hurdle `NI_Hurdle` and the longest acceptable payout `NI_PayoutMax` (months)

**How to use it:** The defaults are the well-program workbook's illustrative well, not a forecast; the sheet is that workbook's Cash Flow sheet reduced to one well. Type the well's own type curve, prices, interests and costs over the inputs; for a forecast that is not an Arps curve, type its mid-month oil rates over the Mid-month rate column, one a month to the plugging month, and keep the columns to its right. The chart draws the NPV against the discount rate, with the IRR marked where the curve crosses zero and the NPV at the sheet's rate marked on it. The sheet compares the IRR with the hurdle (and flags a well with no IRR) and the payout with the payout limit (and flags a well that never pays out).

**Method:** The type curve is Arps hyperbolic with nominal initial decline Di = ((1 − Dei)^(−b) − 1)/b per year, switching to an exponential tail of nominal decline Dt = −ln(1 − Dterm) when its decline falls to Dt, at ts = (Di/Dt − 1)/(b·Di) years. Each month's oil is the rate at mid-month, t = (2·age − 1)/24 years, times 30.4375 days; gas is GOR × oil. The operating margin per barrel is u = (Oil − OilDiff)·NRI·(1 − SevOil − AdVal) + GOR/1000·((Gas − GasDiff)·NRI·(1 − SevGas − AdVal) − Gath·WI) − LOEVar·WI, and the well produces until its rate falls to the economic limit LOE·WI/(30.4375·u), in whole months, or the life cap; it is plugged the month after. Net revenue is (oil·(Oil − OilDiff) + gas·(Gas − GasDiff))·NRI; severance is charged on the oil and gas value and ad valorem on net revenue; operating cost is (LOE + LOEVar·oil + Gath·gas)·WI; all escalate by (1 + Esc)^((month − 1)/12). Each D&C share is spent its lead before the well comes online, in month 1 if that is earlier. NPV discounts end-of-month cash flows, the month-k flow by (1 + Disc)^(k/12); IRR is the first monthly rate, scanning up from −5 %, where the NPV falls through zero, annualised; payout is the month the cumulative cash climbs back to zero after its low point; PV/I is NPV over the discounted capital.

**Example:** The default well is the economics workbook's base case for one of its eight wells: a Texas horizontal online in month 3, 800 STB/d on an Arps hyperbolic with b = 1 and a 65 %/yr effective secant decline switching to an 8 %/yr exponential tail, 1,500 scf/STB of gas, capped at 360 months. Oil sells at $70/STB less $1.50 and gas at $3.00/MMBtu less $1.00, flat. The well has a 100 % WI and a 75 % NRI, pays Texas severance of 4.6 % on oil and 7.5 % on gas and 2.5 % ad valorem, costs $7MM all spent the month before it comes online, $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 %, against a 15 % hurdle and a 36-month payout limit.

Di = (0.35⁻¹ − 1)/1 = 1.857/yr and Dt = −ln 0.92 = 0.0834/yr, so the hyperbolic runs for ts = (1.857/0.0834 − 1)/1.857 = 11.45 years, to 4.49 % of the initial rate (35.9 STB/d), before the tail. The margin is 68.50 × 0.75 × 0.929 + 1.5 × (2.00 × 0.75 × 0.900 − 0.50) − 4 = $45.00/STB, so the economic limit is 8,000/(30.4375 × 45.00) = 5.84 STB/d, which the decline reaches after 33.2 years: the well runs to its 360-month cap and is plugged in month 363. Its EUR is 611.9 MSTB. The NPV at 10 % is $9.80MM, the IRR 112.5 % a year, the payout month 14, the discounted capital $6.89MM (7 × 1.1^(−2/12)) and PV/I 1.42; the undiscounted net cash is $17.51MM. These are the workbook's eight-well numbers for one well: its program NPV of $76.23MM over the 7.782 discount-weighted wells (one a month from month 3, Σ 1.1^(−k/12) for k = 0 to 7), its net cash of $140.07MM over eight, and the same IRR, PV/I, EUR and life. The NPV profile falls from $17.51MM at 0 % through $0.31MM at 100 % to −$0.26MM at 125 %.

At $5 oil the margin is negative and the well never produces: the cash flow is the D&C and the plugging alone, −$7.04MM of NPV, with no IRR and no payout. The workbook's P90 type curve (factor 0.75) earns $5.39MM at a 54.4 % IRR, paying out in month 21 and producing 458.4 MSTB over 357 months. A 40 % partner, with its revenue interest in proportion, earns exactly 40 % of the NPV, $3.92MM, at the same IRR and PV/I. With the D&C spread 10/20/30/40 % over the four months before a month-6 start, the discounted capital is 0.7/1.1^(2/12) + 1.4/1.1^(3/12) + 2.1/1.1^(4/12) + 2.8/1.1^(5/12) = $6.78MM, the workbook's hand check.

## Validity

A before-income-tax, single-well, deterministic evaluation on a flat or escalated price. It holds for an Arps-shaped type curve with a constant GOR; the economic limit uses the start-of-life prices and costs, so with escalation it is approximate. The IRR is the first root above −5 %/month and is "n/a" when there is none, or when it is above 45 %/month; the plugging cost at the end of life gives the cash flow a second, spurious root at a negative rate, which the grid scan steps over. PV/I and IRR rank wells; NPV sizes them. A price strip, income tax, risking and reserves booking are out of scope. Named alternatives: the well-program workbook for a program of wells with a price strip and scenarios; the break-even oil price sheet for the oil price that zeroes this NPV; the One-Well NPV Tornado sheet for the inputs that move it most; the Arps decline forecast or modified hyperbolic decline sheets to fit the type curve to a well's history. Field units.

## References

- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 1, 2nd ed. PennWell.
- Seba, R.D. (1998). *Economics of Worldwide Petroleum Production*. OGCI Publications.
- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228–247.
- Society of Petroleum Evaluation Engineers (2016). *Monograph 4: Estimating Ultimate Recovery of Developed Wells in Low-Permeability Reservoirs* (the hyperbolic with a terminal decline).
- Texas Tax Code, chapters 201 and 202 (the 4.6 % oil and 7.5 % gas production taxes).

## Functions used

`PO.ECON.NPV.Monthly`, `PO.ECON.IRR.Monthly`, `PO.ECON.Payout`, `PO.ECON.Capex.Phasing`

## Spreadsheet: NpvIrr

|    | A                                                                                                                                                                                        | B                                                                                                                                                                                                                                          | C                                                                                                                                                                                                                                                                                                                                               | D                                     | E                                                                                                                                                     | F                                                                                                                                                                                               | G                                                                                                                                                                  | H                                                                                                               | I                                                         | J                                                                                                                             | K                                                                        | L                                                                   |
|----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------|---------------------------------------------------------------------|
| 1  | One-Well NPV and IRR                                                                                                                                                                     |                                                                                                                                                                                                                                            | Petroleum Office                                                                                                                                                                                                                                                                                                                                |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 2  | Blue cells on yellow are inputs: the well-program workbook's base case for one well. The cash flow, NPV, IRR, payout and PV/I follow.                                                    |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 3  | The Well, Its Timing and Type Curve                                                                                                                                                      |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 4  | Month the well comes online (month 1 starts the evaluation)                                                                                                                              | 3                                                                                                                                                                                                                                          | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 5  | Longest producing life of the well                                                                                                                                                       | 360                                                                                                                                                                                                                                        | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 6  | Initial oil rate of the type curve                                                                                                                                                       | 800                                                                                                                                                                                                                                        | STB/d                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 7  | Arps hyperbolic exponent b                                                                                                                                                               | 1                                                                                                                                                                                                                                          | —                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 8  | Initial decline, effective secant                                                                                                                                                        | 0.65                                                                                                                                                                                                                                       | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 9  | Terminal decline, effective (exponential tail)                                                                                                                                           | 0.08                                                                                                                                                                                                                                       | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 10 | Gas-oil ratio, constant over life                                                                                                                                                        | 1500                                                                                                                                                                                                                                       | scf/STB                                                                                                                                                                                                                                                                                                                                         |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 11 | Type-curve factor (scales the initial rate)                                                                                                                                              | 1                                                                                                                                                                                                                                          | —                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 12 | Prices, Interests and Texas Taxes                                                                                                                                                        |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 13 | Oil price (WTI)                                                                                                                                                                          | 70                                                                                                                                                                                                                                         | $/STB                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 14 | Oil differential, deducted (quality and transport)                                                                                                                                       | 1.5                                                                                                                                                                                                                                        | $/STB                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 15 | Gas price (Henry Hub, 1 MMBtu per Mscf)                                                                                                                                                  | 3                                                                                                                                                                                                                                          | $/MMBtu                                                                                                                                                                                                                                                                                                                                         |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 16 | Gas differential, deducted (Waha basis)                                                                                                                                                  | 1                                                                                                                                                                                                                                          | $/MMBtu                                                                                                                                                                                                                                                                                                                                         |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 17 | Escalation of prices and operating costs                                                                                                                                                 | 0                                                                                                                                                                                                                                          | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 18 | Working interest (scales costs and capital)                                                                                                                                              | 1                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 19 | Net revenue interest (25 % royalty at 100 % WI)                                                                                                                                          | 0.75                                                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 20 | Oil severance tax (Texas, of the oil's value)                                                                                                                                            | 0.046                                                                                                                                                                                                                                      | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 21 | Gas severance tax (Texas, of the gas's value)                                                                                                                                            | 0.075                                                                                                                                                                                                                                      | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 22 | Ad valorem tax, as a share of net revenue                                                                                                                                                | 0.025                                                                                                                                                                                                                                      | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 23 | Costs and the Capital Phasing                                                                                                                                                            |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 24 | Drilling and completion of the well                                                                                                                                                      | 7                                                                                                                                                                                                                                          | $MM                                                                                                                                                                                                                                                                                                                                             |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 25 | Fixed LOE                                                                                                                                                                                | 8000                                                                                                                                                                                                                                       | $/well-month                                                                                                                                                                                                                                                                                                                                    |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 26 | Variable LOE per barrel of oil                                                                                                                                                           | 4                                                                                                                                                                                                                                          | $/STB                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 27 | Gas gathering and processing                                                                                                                                                             | 0.5                                                                                                                                                                                                                                        | $/Mscf                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 28 | Plugging and abandonment, the month after the last production                                                                                                                            | 150000                                                                                                                                                                                                                                     | $                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 29 | D&C share spent four months before online                                                                                                                                                | 0                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 30 | D&C share spent three months before online                                                                                                                                               | 0                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 31 | D&C share spent two months before online                                                                                                                                                 | 0                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 32 | D&C share spent the month before online                                                                                                                                                  | 1                                                                                                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 33 | Discounting                                                                                                                                                                              |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 34 | Discount rate, end-of-month cash flows                                                                                                                                                   | 0.1                                                                                                                                                                                                                                        | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 35 | IRR hurdle                                                                                                                                                                               | 0.15                                                                                                                                                                                                                                       | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 36 | Longest acceptable payout, from month 1                                                                                                                                                  | 36                                                                                                                                                                                                                                         | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 38 | Calculation Constants                                                                                                                                                                    |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 39 | Days in a month, 365.25/12                                                                                                                                                               | 30.4375                                                                                                                                                                                                                                    | days/month                                                                                                                                                                                                                                                                                                                                      |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 40 | Months in a year                                                                                                                                                                         | 12                                                                                                                                                                                                                                         | months/yr                                                                                                                                                                                                                                                                                                                                       |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 41 | Dollars in a million                                                                                                                                                                     | 1000000                                                                                                                                                                                                                                    | $/$MM                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 43 | The Decline, the Economic Limit and the Well's Life                                                                                                                                      |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 44 | Initial nominal decline, from the effective secant                                                                                                                                       | =((1-NI_Dei)^(-NI_b)-1)/NI_b                                                                                                                                                                                                               | 1/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 45 | Terminal nominal decline, from the effective                                                                                                                                             | =-LN(1-NI_Dterm)                                                                                                                                                                                                                           | 1/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 46 | Time the hyperbolic switches to the terminal decline                                                                                                                                     | =MAX(0,(NI_Di/NI_Dt-1)/(NI_b*NI_Di))                                                                                                                                                                                                       | years                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 47 | Rate at the switch over the initial rate                                                                                                                                                 | =(1+NI_b*NI_Di*NI_Ts)^(-1/NI_b)                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 48 | Initial oil rate, IP × type-curve factor                                                                                                                                                 | =NI_IP*NI_TC                                                                                                                                                                                                                               | STB/d                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 49 | Operating margin per barrel of oil, net of royalty and taxes                                                                                                                             | =(NI_Oil-NI_OilDiff)*NI_NRI*(1-NI_SevOil-NI_AdVal)+NI_GOR/1000*((NI_Gas-NI_GasDiff)*NI_NRI*(1-NI_SevGas-NI_AdVal)-NI_Gath*NI_WI)-NI_LOEVar*NI_WI                                                                                           | $/STB                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 50 | Economic-limit oil rate, fixed LOE over the margin                                                                                                                                       | =IF(AND(NI_Margin>0,NI_LOE>0),NI_LOE*NI_WI/(NI_Days*NI_Margin),NI_Qi)                                                                                                                                                                      | STB/d                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 51 | Time the decline takes to reach the limit                                                                                                                                                | =IF(NI_QLimit>=NI_Qi,0,IF(NI_QLimit>=NI_Qi*NI_Qs,((NI_Qi/NI_QLimit)^NI_b-1)/(NI_b*NI_Di),NI_Ts+LN(NI_Qi*NI_Qs/NI_QLimit)/NI_Dt))                                                                                                           | years                                                                                                                                                                                                                                                                                                                                           |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 52 | Producing life, to the economic limit or the cap                                                                                                                                         | =IF(NI_Margin<=0,0,IF(NI_LOE<=0,NI_LifeCap,MIN(NI_LifeCap,INT(NI_MoYr*NI_TLimit))))                                                                                                                                                        | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 53 | Months in the cash flow, to the plugging month                                                                                                                                           | =NI_Online+NI_Life                                                                                                                                                                                                                         | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 55 | NPV, IRR, Payout and PV/I                                                                                                                                                                |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 56 | NPV at the discount rate                                                                                                                                                                 | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),NI_Disc)/NI_PerMM                                                                                                                                                                            | $MM                                                                                                                                                                                                                                                                                                                                             |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 57 | IRR, annualised                                                                                                                                                                          | =PO.ECON.IRR.Monthly(TAKE($J$99:$J$1298,NI_N))                                                                                                                                                                                             | %/yr                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 58 | Payout month, undiscounted                                                                                                                                                               | =PO.ECON.Payout(TAKE($J$99:$J$1298,NI_N))                                                                                                                                                                                                  | months                                                                                                                                                                                                                                                                                                                                          |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 59 | Discounted capital                                                                                                                                                                       | =PO.ECON.NPV.Monthly(TAKE($H$99:$H$1298,NI_N),NI_Disc)/NI_PerMM                                                                                                                                                                            | $MM                                                                                                                                                                                                                                                                                                                                             |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 60 | PV/I, NPV over the discounted capital                                                                                                                                                    | =NI_NPV/NI_PvCapital                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                               |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 61 | Oil EUR over the producing life                                                                                                                                                          | =SUM(TAKE($C$99:$C$1298,NI_N))/1000                                                                                                                                                                                                        | MSTB                                                                                                                                                                                                                                                                                                                                            |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 62 | Net cash, undiscounted                                                                                                                                                                   | =SUM(TAKE($J$99:$J$1298,NI_N))/NI_PerMM                                                                                                                                                                                                    | $MM                                                                                                                                                                                                                                                                                                                                             |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 63 | IRR check                                                                                                                                                                                | =IF(ISNUMBER(NI_IRR),IF(NI_IRR>=NI_Hurdle,"PASS","WARN"),"FAIL")                                                                                                                                                                           | =IF(ISNUMBER(NI_IRR),IF(NI_IRR>=NI_Hurdle,"IRR "&FIXED(NI_IRR*100,1)&" % a year, at or above the "&FIXED(NI_Hurdle*100,1)&" % hurdle","IRR "&FIXED(NI_IRR*100,1)&" % a year, below the "&FIXED(NI_Hurdle*100,1)&" % hurdle"),"no IRR, the NPV never falls through zero between -5 % and +45 % a month: the well does not pay back its capital") |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 64 | Payout check                                                                                                                                                                             | =IF(ISNUMBER(NI_Payout),IF(NI_Payout<=NI_PayoutMax,"PASS","WARN"),"FAIL")                                                                                                                                                                  | =IF(ISNUMBER(NI_Payout),IF(NI_Payout<=NI_PayoutMax,"pays out in month "&NI_Payout&", within the "&NI_PayoutMax&" allowed","pays out in month "&NI_Payout&", after the "&NI_PayoutMax&" allowed"),"never pays out, the cumulative cash never climbs back from its low point")                                                                    |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 66 | How to use it: type the well's own type curve, prices and costs over the inputs, or type a forecast's mid-month rates over the Mid-month rate column and keep the formulas to its right. |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 67 | The defaults are the well-program workbook's illustrative base case, not a forecast; its eight-well program is eight of these wells, one a month.                                        |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 69 | Capital Phasing (nothing to edit)                                                                                                                                                        |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 70 | Spent, months before online                                                                                                                                                              | Share                                                                                                                                                                                                                                      | Month spent (month)                                                                                                                                                                                                                                                                                                                             | Capital ($MM)                         |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 71 | =4                                                                                                                                                                                       | =NI_Phase4                                                                                                                                                                                                                                 | =MAX(1,NI_Online-A71)                                                                                                                                                                                                                                                                                                                           | =NI_DC*NI_WI*B71/SUM(NI_Phasing)      |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 72 | =3                                                                                                                                                                                       | =NI_Phase3                                                                                                                                                                                                                                 | =MAX(1,NI_Online-A72)                                                                                                                                                                                                                                                                                                                           | =NI_DC*NI_WI*B72/SUM(NI_Phasing)      |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 73 | =2                                                                                                                                                                                       | =NI_Phase2                                                                                                                                                                                                                                 | =MAX(1,NI_Online-A73)                                                                                                                                                                                                                                                                                                                           | =NI_DC*NI_WI*B73/SUM(NI_Phasing)      |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 74 | =1                                                                                                                                                                                       | =NI_Phase1                                                                                                                                                                                                                                 | =MAX(1,NI_Online-A74)                                                                                                                                                                                                                                                                                                                           | =NI_DC*NI_WI*B74/SUM(NI_Phasing)      |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 76 | NPV Against the Discount Rate                                                                                                                                                            |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 77 | Discount rate (%/yr)                                                                                                                                                                     | NPV ($MM)                                                                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 78 | 0                                                                                                                                                                                        | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A78)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 79 | 0.05                                                                                                                                                                                     | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A79)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 80 | 0.1                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A80)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 81 | 0.15                                                                                                                                                                                     | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A81)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 82 | 0.2                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A82)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 83 | 0.3                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A83)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 84 | 0.4                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A84)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 85 | 0.6                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A85)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 86 | 0.8                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A86)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 87 | 1                                                                                                                                                                                        | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A87)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 88 | 1.25                                                                                                                                                                                     | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A88)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 89 | 1.5                                                                                                                                                                                      | =PO.ECON.NPV.Monthly(TAKE($J$99:$J$1298,NI_N),A89)/NI_PerMM                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 91 | The IRR and the Discount Rate on the Profile (nothing to edit)                                                                                                                           |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 92 | Point                                                                                                                                                                                    | Rate (%/yr)                                                                                                                                                                                                                                | NPV ($MM)                                                                                                                                                                                                                                                                                                                                       |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 93 | IRR, where the NPV is zero                                                                                                                                                               | =NI_IRR                                                                                                                                                                                                                                    | =0                                                                                                                                                                                                                                                                                                                                              |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 94 | NPV at the discount rate                                                                                                                                                                 | =NI_Disc                                                                                                                                                                                                                                   | =NI_NPV                                                                                                                                                                                                                                                                                                                                         |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 96 | Monthly Cash Flow (each column spills from its first row to the plugging month)                                                                                                          |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 97 | Mid-month rates on the type curve; money is end of month, escalated from month 1. Capital is the phasing table's; plugging falls the month after the last production.                    |                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                 |                                       |                                                                                                                                                       |                                                                                                                                                                                                 |                                                                                                                                                                    |                                                                                                                 |                                                           |                                                                                                                               |                                                                          |                                                                     |
| 98 | Month (month)                                                                                                                                                                            | Mid-month rate (STB/d)                                                                                                                                                                                                                     | Oil (STB)                                                                                                                                                                                                                                                                                                                                       | Gas (Mscf)                            | Net revenue ($)                                                                                                                                       | Severance + ad valorem ($)                                                                                                                                                                      | Operating cost ($)                                                                                                                                                 | Capital ($)                                                                                                     | Plugging ($)                                              | Net cash ($)                                                                                                                  | Discounted net cash ($)                                                  | Cumulative net cash ($)                                             |
| 99 | =SEQUENCE(NI_N)                                                                                                                                                                          | =LET(nm_age,TAKE($A$99:$A$1298,NI_N)-NI_Online+1,nm_t,((nm_age>=1)*(2*nm_age-1)+(nm_age<1))/2/NI_MoYr,(nm_age>=1)*(nm_age<=NI_Life)*((nm_t<=NI_Ts)*NI_Qi*(1+NI_b*NI_Di*nm_t)^(-1/NI_b)+(nm_t>NI_Ts)*NI_Qi*NI_Qs*EXP(-NI_Dt*(nm_t-NI_Ts)))) | =TAKE($B$99:$B$1298,NI_N)*NI_Days                                                                                                                                                                                                                                                                                                               | =TAKE($C$99:$C$1298,NI_N)*NI_GOR/1000 | =(1+NI_Esc)^((TAKE($A$99:$A$1298,NI_N)-1)/NI_MoYr)*(TAKE($C$99:$C$1298,NI_N)*(NI_Oil-NI_OilDiff)+TAKE($D$99:$D$1298,NI_N)*(NI_Gas-NI_GasDiff))*NI_NRI | =(1+NI_Esc)^((TAKE($A$99:$A$1298,NI_N)-1)/NI_MoYr)*NI_NRI*(TAKE($C$99:$C$1298,NI_N)*(NI_Oil-NI_OilDiff)*(NI_SevOil+NI_AdVal)+TAKE($D$99:$D$1298,NI_N)*(NI_Gas-NI_GasDiff)*(NI_SevGas+NI_AdVal)) | =(1+NI_Esc)^((TAKE($A$99:$A$1298,NI_N)-1)/NI_MoYr)*(NI_LOE*(TAKE($B$99:$B$1298,NI_N)>0)+NI_LOEVar*TAKE($C$99:$C$1298,NI_N)+NI_Gath*TAKE($D$99:$D$1298,NI_N))*NI_WI | =MMULT((TAKE($A$99:$A$1298,NI_N)=TRANSPOSE(NI_Spend))*1,PO.ECON.Capex.Phasing(NI_DC*NI_PerMM*NI_WI,NI_Phasing)) | =(TAKE($A$99:$A$1298,NI_N)=NI_Online+NI_Life)*NI_PA*NI_WI | =TAKE($E$99:$E$1298,NI_N)-TAKE($F$99:$F$1298,NI_N)-TAKE($G$99:$G$1298,NI_N)-TAKE($H$99:$H$1298,NI_N)-TAKE($I$99:$I$1298,NI_N) | =TAKE($J$99:$J$1298,NI_N)/(1+NI_Disc)^(TAKE($A$99:$A$1298,NI_N)/NI_MoYr) | =SCAN(0,TAKE($J$99:$J$1298,NI_N),LAMBDA(acc_sum,cf_m,acc_sum+cf_m)) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.ECON.NPV.Monthly | =LAMBDA(cash,annual_rate,NPV((1+annual_rate)^(1/12)-1,cash)) | NPV of end-of-month cash flows at an annual discount rate, in the units of cash. |
| PO.ECON.IRR.Monthly | =LAMBDA(cash,LET(cash_col,cash,grid_step,0.0025,rates,SEQUENCE(1,201,-0.05,grid_step),periods,SEQUENCE(ROWS(cash_col)),npv_grid,MMULT(TRANSPOSE(cash_col),(1+rates)^(-periods)),first_pos,IFERROR(XMATCH(TRUE,npv_grid>0),0),crossing,IF(first_pos=0,0,IFERROR(XMATCH(1,(SEQUENCE(1,201)>first_pos)*(npv_grid<=0)),0)),IF(crossing=0,"n/a",LET(r_lo,INDEX(rates,1,crossing-1),v_lo,INDEX(npv_grid,1,crossing-1),v_hi,INDEX(npv_grid,1,crossing),r_interp,r_lo+grid_step*v_lo/(v_lo-v_hi),r_refined,IFERROR(IRR(cash_col,r_lo),r_interp),(1+IF(AND(r_refined>=r_lo,r_refined<=r_lo+grid_step),r_refined,r_interp))^12-1)))) | Annualised IRR of monthly cash flows: the first rate, scanning up from -5 %/month, at which NPV falls through zero; "n/a" when it never does |
| PO.ECON.Payout | =LAMBDA(cash,LET(cumulative,SCAN(0,cash,LAMBDA(running,flow,running+flow)),trough,MATCH(MIN(cumulative),cumulative,0),IFERROR(MATCH(1,(SEQUENCE(ROWS(cumulative))>trough)*(cumulative>=0),0),"none"))) | Month in which cumulative cash flow climbs back to zero after its low point; "none" if it never does |
| PO.ECON.Capex.Phasing | =LAMBDA(total,profile,total*profile/SUM(profile)) | Spreads a capital total over periods in proportion to a phasing profile; returns an array the shape of the profile, in the units of total. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| NI_Online | $B$4 | Month the well comes online (month 1 starts the evaluation), months |
| NI_LifeCap | $B$5 | Longest producing life of the well, months |
| NI_IP | $B$6 | Initial oil rate of the type curve, STB/d |
| NI_b | $B$7 | Arps hyperbolic exponent b |
| NI_Dei | $B$8 | Initial decline, effective secant, %/yr |
| NI_Dterm | $B$9 | Terminal decline, effective (exponential tail), %/yr |
| NI_GOR | $B$10 | Gas-oil ratio, constant over life, scf/STB |
| NI_TC | $B$11 | Type-curve factor (scales the initial rate) |
| NI_Oil | $B$13 | Oil price (WTI), $/STB |
| NI_OilDiff | $B$14 | Oil differential, deducted (quality and transport), $/STB |
| NI_Gas | $B$15 | Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
| NI_GasDiff | $B$16 | Gas differential, deducted (Waha basis), $/MMBtu |
| NI_Esc | $B$17 | Escalation of prices and operating costs, %/yr |
| NI_WI | $B$18 | Working interest (scales costs and capital), % |
| NI_NRI | $B$19 | Net revenue interest (25 % royalty at 100 % WI), % |
| NI_SevOil | $B$20 | Oil severance tax (Texas, of the oil's value), % |
| NI_SevGas | $B$21 | Gas severance tax (Texas, of the gas's value), % |
| NI_AdVal | $B$22 | Ad valorem tax, as a share of net revenue, % |
| NI_DC | $B$24 | Drilling and completion of the well, $MM |
| NI_LOE | $B$25 | Fixed LOE, $/well-month |
| NI_LOEVar | $B$26 | Variable LOE per barrel of oil, $/STB |
| NI_Gath | $B$27 | Gas gathering and processing, $/Mscf |
| NI_PA | $B$28 | Plugging and abandonment, the month after the last production, $ |
| NI_Phase4 | $B$29 | D&C share spent four months before online, % |
| NI_Phase3 | $B$30 | D&C share spent three months before online, % |
| NI_Phase2 | $B$31 | D&C share spent two months before online, % |
| NI_Phase1 | $B$32 | D&C share spent the month before online, % |
| NI_Disc | $B$34 | Discount rate, end-of-month cash flows, %/yr |
| NI_Hurdle | $B$35 | IRR hurdle, %/yr |
| NI_PayoutMax | $B$36 | Longest acceptable payout, from month 1, months |
| NI_Phasing | $B$29:$B$32 | The D&C phasing shares, four months before the well comes online down to the month before |
| NI_Inputs | $B$4:$B$36 | The well's timing and type curve, prices, interests and taxes, costs and capital phasing, the discount rate, the IRR hurdle and the payout limit |
| NI_Days | $B$39 | Days in a month, 365.25/12, days/month |
| NI_MoYr | $B$40 | Months in a year, months/yr |
| NI_PerMM | $B$41 | Dollars in a million, $/$MM |
| NI_Di | $B$44 | Initial nominal decline, from the effective secant, 1/yr |
| NI_Dt | $B$45 | Terminal nominal decline, from the effective, 1/yr |
| NI_Ts | $B$46 | Time the hyperbolic switches to the terminal decline, years |
| NI_Qs | $B$47 | Rate at the switch over the initial rate |
| NI_Qi | $B$48 | Initial oil rate, IP × type-curve factor, STB/d |
| NI_Margin | $B$49 | Operating margin per barrel of oil, net of royalty and taxes, $/STB |
| NI_QLimit | $B$50 | Economic-limit oil rate, fixed LOE over the margin, STB/d |
| NI_TLimit | $B$51 | Time the decline takes to reach the limit, years |
| NI_Life | $B$52 | Producing life, to the economic limit or the cap, months |
| NI_N | $B$53 | Months in the cash flow, to the plugging month, months |
| NI_NPV | $B$56 | NPV at the discount rate, $MM |
| NI_IRR | $B$57 | IRR, annualised, %/yr |
| NI_Payout | $B$58 | Payout month, undiscounted, months |
| NI_PvCapital | $B$59 | Discounted capital, $MM |
| NI_PVI | $B$60 | PV/I, NPV over the discounted capital |
| NI_EUR | $B$61 | Oil EUR over the producing life, MSTB |
| NI_NetCash | $B$62 | Net cash, undiscounted, $MM |
| NI_IrrCheck | $B$63 | IRR check verdict |
| NI_IrrCheckNote | $C$63 | IRR check comment |
| NI_PayoutCheck | $B$64 | Payout check verdict |
| NI_PayoutCheckNote | $C$64 | Payout check comment |
| NI_Results | $B$44:$B$64 | The decline terms, the economic limit and life, the months in the cash flow, the NPV, IRR, payout, discounted capital, PV/I, EUR and net cash, and two checks |
| NI_CapitalPhasing | $A$71:$D$74 | Each D&C share's lead, its share, the month it is spent (before month 1 it falls in month 1) and its capital |
| NI_Spend | $C$71:$C$74 | The month each D&C share is spent, four months before online down to the month before |
| NI_Profile | $A$78:$B$89 | Discount rates, and the well's NPV at each |
| NI_Points | $A$93:$C$94 | The IRR at zero NPV, and the NPV at the sheet's discount rate |
| NI_ProfileCurve | $A$78:$C$89 | NPV Against the Discount Rate |

---

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

