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
Results
Net Present Value
$16,328,829.00
≈ 39 average U.S. homes
Payback Period
8 months
How to Use This Calculator
- Enter well cost (CAPEX $), initial production rate (bbl/day), and annual decline rate (%).
- Enter oil price ($/bbl), monthly operating cost ($/mo), royalty rate (%), and tax rate (%).
- Enter the discount rate (%) used to calculate net present value.
- Read net present value (NPV $) and payback period (months).
- 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 Rate | Net Present Value | Payback Period |
|---|---|---|
| 250 | $5,259,070.00 | 18 months |
| 375 | $10,795,379.00 | 11 months |
| 750 | $27,392,072.00 | 5 months |
| 1,250 | $49,512,892.00 | 3 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
- Identify Input Parameters4 parametersWell Cost = 5000000, Initial Rate = 500, Annual Decline Rate = 30, Oil Price = 75 = 8 input(s) provided
- Calculate Net Present ValueNet Present Value16328829 = $16,328,829
- Calculate Payback PeriodPayback Period8 = 8
- Calculate 20-Year ROI20-Year ROI453 = 453
- Calculate Total Gross RevenueTotal Gross Revenue44979857 = $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.
Related Calculators
The questions that sit next to this one — chosen by subject, including calculators filed under a different category.
Drilling Cost Calculator
Estimate per-foot and total drilling cost from rig rate and depth.
Oil & GasDecline Curve Calculator
Forecast production decline using exponential or hyperbolic models.
Precision IrrigationIrrigation Return on Investment Calculator
Evaluate irrigation system ROI with NPV, IRR, payback period, and benefit-cost ratio from yield improvement, water savings, and energy savings.
Project ManagementProject ROI Calculator
Calculate NPV, IRR, and payback period for project investments.
Oil & GasGas Compression Calculator
Calculate compressor horsepower from pressure and flow requirements.
More in Energy & Utilities.