Skip to main content
Calcimator

Well Economics Calculator

Calculate IRR, NPV, and payback period for an oil or gas well.

About this calculator

This calculator projects a well's economics month by month across a full 20-year (240-month) production life, since a well's value depends entirely on the shape of its production decline, not just its starting output. Production follows an exponential decline curve — a standard oil and gas typecurve shape — where the initial rate shrinks continuously at the entered annual decline percentage, meaning output falls fastest in absolute terms early in the well's life and gradually tapers to a slow trickle in later years, exactly the pattern real unconventional wells typically show. Each month's production converts to revenue at the entered oil price, then royalty owners are paid off the top before operating costs and taxes come out of what's left, so the cash flow that actually belongs to the well's economics is what remains after all three of those claims.

Net present value discounts every future month's cash flow back to today's dollars at your entered discount rate, reflecting that a dollar of cash flow five years from now is worth less than a dollar in hand today — a well can show strong nominal total revenue over 20 years while still having a modest or negative NPV if too much of that cash arrives too far in the future relative to the discount rate applied. Payback period identifies the first month cumulative (undiscounted) cash flow turns positive, meaning the well has fully recouped its upfront drilling and completion cost; if that never happens within the 20-year projection window, the calculator reports a payback of 999 months as a sentinel value meaning the well never pays back within the modeled horizon under these assumptions.

Inputs

$
bbl/day
%
$/bbl
$/mo
%
%
%

Results

Net Present Value

$16,328,829.00

≈ 39 average U.S. homes

Payback Period

8 months

20-Year ROI453%
Total Gross Revenue$44,979,857.00
Total Production599,731 bbl
Roi453.05
How to Use This Calculator
  1. Enter well cost (CAPEX $), initial production rate (bbl/day), and annual decline rate (%).
  2. Enter oil price ($/bbl), monthly operating cost ($/mo), royalty rate (%), and tax rate (%).
  3. Enter the discount rate (%) used to calculate net present value.
  4. Read net present value (NPV $) and payback period (months).
  5. Review 20-year ROI (%), total gross revenue ($), and total production (bbl) to assess the well's economics.

How the result changes with Initial Rate

Initial RateNet Present ValuePayback Period
250$5,259,070.0018 months
375$10,795,379.0011 months
750$27,392,072.005 months
1,250$49,512,892.003 months

What each input means

Well Cost
Total cost to drill, complete, and equip the well.
Initial Rate
Initial oil production rate.
Annual Decline Rate
Annual exponential decline rate.
Oil Price
Expected oil price per barrel.
Monthly Operating Cost
Monthly lease operating expenses.
Royalty Rate
Mineral royalty percentage.
Tax Rate
Combined severance and income tax rate.
Discount Rate
Discount rate for NPV calculation.

How this is calculated

Worked example, using the default values

  1. Identify Input Parameters
    4 parameters
    Well Cost = 5000000, Initial Rate = 500, Annual Decline Rate = 30, Oil Price = 75 = 8 input(s) provided
  2. Calculate Net Present Value
    Net Present Value
    16328829 = $16,328,829
  3. Calculate Payback Period
    Payback Period
    8 = 8
  4. Calculate 20-Year ROI
    20-Year ROI
    453 = 453
  5. Calculate Total Gross Revenue
    Total Gross Revenue
    44979857 = $44,979,857

Engine last updated . Checked against 1 independently-derived test — how we verify calculators. Built by Paul Gunder, a software engineer, not a licensed financial, medical, or legal professional.

Frequently Asked Questions

Why does production decline exponentially instead of just dropping by a fixed amount each year?

Exponential decline is the standard model for oil and gas well production because the underlying physics — reservoir pressure depleting as fluid is withdrawn — produces a curve that falls by a constant percentage of the remaining rate each period, not a constant absolute amount. This means a well loses more barrels per month early in its life when rates are high, and progressively fewer barrels per month later on even though the percentage decline rate stays the same.

Why can a well have strong total revenue but still show a low or negative NPV?

Total revenue simply adds up every dollar earned over 20 years with no regard for when it arrived, while NPV specifically discounts cash flow that arrives later to reflect that money in the future is worth less than money today. A well with most of its production and revenue concentrated in the first few years (typical of a steep decline rate) will show a healthier NPV than one earning the same total revenue spread thin over two decades, because the discounting penalty compounds the longer cash flow takes to arrive.

What does a payback period of 999 months actually mean?

It's a sentinel value indicating the well's cumulative cash flow never turned positive within the full 240-month (20-year) projection window used by this calculator — in other words, under the entered assumptions, the well never fully recoups its upfront drilling and completion cost within that horizon. It isn't a literal prediction that payback would occur at month 999; it's a flag that payback wasn't reached in the modeled timeframe at all.

Why are royalties subtracted before operating costs and taxes rather than at the end?

Royalty owners have a claim on gross production revenue itself, independent of how much it costs to operate the well, so royalty is calculated and removed first to arrive at the operator's net revenue. Operating costs and taxes are then applied to that already royalty-reduced figure, which mirrors how real oil and gas revenue distribution works — royalty interest is paid off the top, before the working interest owner's operating expenses and tax liability are ever considered.

The questions that sit next to this one — chosen by subject, including calculators filed under a different category.

More in Energy & Utilities.