NPV and IRR Analysis for Petroleum Projects - Decline Curve Integration, WACC Calculation, and Capital Allocation

NPV and IRR Analysis for Petroleum Projects - Decline Curve Integration, WACC Calculation, and Capital Allocation

The net present value and internal rate of return are the two most widely used investment criteria in the petroleum industry, and they are also the two most widely misapplied. NPV is misapplied when engineers use an arbitrary or incorrect discount rate a project that generates $500M NPV at 10% generates only $180M NPV at 20%, and the choice of discount rate determines not just the magnitude of the economic result but sometimes the sign. IRR is misapplied when it is used to rank competing projects of different sizes a small well workover with a 45% IRR does not necessarily create more value than a large offshore development with a 22% IRR, because the workover invests $500,000 while the offshore development invests $800 million. Understanding when each metric is appropriate, how to calculate it correctly from production forecasts built on decline curve analysis, and how to use it in capital allocation decisions under budget constraints requires both theoretical rigor and practical calibration against real project data. This guide builds the complete analytical framework from the production forecast through the after-tax cash flow model to the investment decision criteria with every number grounded in the engineering and financial reality of petroleum projects.

1. Production Forecasting - Decline Curve Analysis

1.1 Arps Decline Curve Equations

The production forecast is the foundation of every petroleum economics calculation. Before NPV or IRR can be calculated, the engineer must have a credible estimate of how much oil or gas the well or field will produce in each future year. Decline curve analysis uses the observed historical production behavior of the well to project future performance. The Arps equations describe three mathematically distinct decline behaviors that correspond to different reservoir and drive mechanisms:

Arps decline curve equations:

Exponential decline (b = 0):
q(t) = qi x exp(-Di x t)
EUR = qi / Di

Where: qi = initial rate (STB/day), Di = nominal decline rate (fraction/year), t = time (years)

Hyperbolic decline (0 < b < 1):
q(t) = qi / (1 + b x Di x t)^(1/b)
EUR = qi^b / ((1-b) x Di) x (qi^(1-b) - q_abandonment^(1-b))

Harmonic decline (b = 1):
q(t) = qi / (1 + Di x t)
EUR = qi/Di x ln(qi/q_abandonment)

Example: Tight oil well production forecast
Initial rate: qi = 485 STB/day
Initial decline rate: Di = 0.72/year (72% annual nominal decline - typical for tight oil)
Hyperbolic exponent: b = 0.85 (typical for hydraulically fractured tight oil)
Economic abandonment rate: q_aban = 15 STB/day

Annual production calculation:
Year 1 average rate: q(0.5) = 485/(1 + 0.85 x 0.72 x 0.5)^(1/0.85)
= 485/(1 + 0.306)^1.176 = 485/(1.306)^1.176
(1.306)^1.176: ln(1.306) = 0.2669, 0.2669 x 1.176 = 0.3139, e^0.3139 = 1.3688
q(0.5) = 485/1.3688 = 354.3 STB/day average for Year 1
Annual production Year 1 = 354.3 x 365 = 129,320 STB

Year 3 average: q(2.5) = 485/(1 + 0.85 x 0.72 x 2.5)^1.176
= 485/(1 + 1.530)^1.176 = 485/(2.530)^1.176
(2.530)^1.176: ln(2.530) = 0.9282, 0.9282 x 1.176 = 1.0916, e^1.0916 = 2.979
q(2.5) = 485/2.979 = 162.8 STB/day average Year 3
Annual production Year 3 = 162.8 x 365 = 59,422 STB

Year 5 average: q(4.5) = 485/(1 + 0.85 x 0.72 x 4.5)^1.176
= 485/(1 + 2.754)^1.176 = 485/(3.754)^1.176
(3.754)^1.176: ln(3.754) = 1.3236, 1.3236 x 1.176 = 1.5565, e^1.5565 = 4.740
q(4.5) = 485/4.740 = 102.3 STB/day average Year 5
Annual production Year 5 = 102.3 x 365 = 37,340 STB

EUR calculation (to abandonment at 15 STB/day):
Time to abandonment: 15 = 485/(1 + 0.85 x 0.72 x t)^1.176
(485/15)^0.85 = 1 + 0.612 x t
32.33^0.85 = 1 + 0.612 x t
32.33^0.85: ln(32.33) = 3.476, 3.476 x 0.85 = 2.955, e^2.955 = 19.22
19.22 = 1 + 0.612 x t → t = 18.22/0.612 = 29.8 years to abandonment

Numerical EUR integration ≈ sum of annual productions = approximately 285,000 STB EUR

1.2 Converting Decline Curve to Annual Cash Flow Profile

Year	Average Rate (STB/day)	Annual Production (STB)	Gross Revenue ($68/bbl)	Opex ($18/STB)	Net Revenue (35% fiscal)
0	-	-	-	-	Capex: -$4,800,000
1	354.3	129,320	$8,793,760	$2,327,760	$4,201,940
2	218.5	79,753	$5,423,204	$1,435,554	$2,589,075
3	162.8	59,422	$4,040,696	$1,069,596	$1,929,915
4	127.6	46,574	$3,167,032	$838,332	$1,513,065
5	102.3	37,340	$2,539,120	$672,120	$1,213,100

Net revenue per barrel calculation (after fiscal):
Net revenue per STB = (Oil price - Opex) x (1 - fiscal_rate)
= ($68 - $18) x (1 - 0.35) = $50 x 0.65 = $32.50/STB net after fiscal

Year 1 net cash flow = 129,320 x $32.50 = $4,202,900 ≈ $4,201,940 (table above, small rounding)

Cumulative undiscounted cash flow:
5-year total net = $4,202 + $2,589 + $1,930 + $1,513 + $1,213 = $11,447K
Minus initial Capex: $11,447K - $4,800K = $6,647K undiscounted 5-year profit

Simple payback: Capex $4,800K recovered in Year 2 (cumulative net CF after Year 2 = $4,202 + $2,589 = $6,791K > $4,800K)
Simple payback period = approximately 1.6 years

2. Discount Rate: WACC Calculation

2.1 Weighted Average Cost of Capital

The discount rate used in petroleum project NPV calculations should reflect the actual cost of the capital being invested. For a company that finances its operations with a combination of debt (borrowed money) and equity (shareholder capital), the correct discount rate is the Weighted Average Cost of Capital (WACC) - the blended cost of all capital sources weighted by their proportion in the capital structure:

WACC formula:
WACC = (E/V) x Re + (D/V) x Rd x (1 - Tc)

Where:
E = market value of equity, D = market value of debt, V = E + D (total capital)
Re = cost of equity (required return demanded by shareholders)
Rd = cost of debt (interest rate on borrowings)
Tc = corporate tax rate (debt interest is tax-deductible, reducing effective debt cost)

Cost of equity - CAPM (Capital Asset Pricing Model):
Re = Rf + beta x (Rm - Rf)

Where:
Rf = risk-free rate (10-year government bond yield) = 4.2% (2026)
beta = systematic risk of oil company equity vs market (typically 0.9-1.4 for E&P companies)
(Rm - Rf) = equity risk premium = 5.5% (long-run historical average)

For a mid-size E&P company with beta = 1.15:
Re = 4.2% + 1.15 x 5.5% = 4.2% + 6.325% = 10.525% cost of equity

WACC calculation example:
Capital structure: 35% debt, 65% equity
Cost of debt (Rd) = 6.8% (corporate bond yield for investment grade E&P)
Cost of equity (Re) = 10.525%
Corporate tax rate (Tc) = 30%

WACC = 0.65 x 10.525% + 0.35 x 6.8% x (1 - 0.30)
= 6.841% + 0.35 x 4.76%
= 6.841% + 1.666% = 8.507% WACC

Project-specific discount rate adjustment:
WACC represents the company's average cost of capital across all its operations. A specific project may warrant a higher or lower discount rate depending on its risk profile relative to the company average:

Frontier exploration (high geological risk): WACC + 5-8% = 13.5-16.5%
Appraisal/development (moderate risk): WACC + 2-4% = 10.5-12.5%
Near-field development (low risk, established basin): WACC + 0-2% = 8.5-10.5%
Infrastructure/pipeline (very low risk, contracted tariff): WACC - 1-2% = 6.5-7.5%

The 10-12% discount rate commonly used in petroleum project evaluations represents the WACC + risk premium for a typical development project in an established basin. Using 15% for a low-risk North Sea infill development over-penalizes future cash flows; using 8% for a frontier deepwater exploration program under-penalizes them.

3. NPV Calculation: From Cash Flow to Investment Decision

3.1 Complete NPV Calculation for the Tight Oil Well

10-year NPV calculation at 12% discount rate:

Year 0: CF = -$4,800,000 (well + completion Capex)
Year 1: CF = +$4,201,940
Year 2: CF = +$2,589,075
Year 3: CF = +$1,929,915
Year 4: CF = +$1,513,065
Year 5: CF = +$1,213,100
Year 6: CF = +$985,750 (rate ~83 STB/day)
Year 7: CF = +$812,400 (rate ~69 STB/day)
Year 8: CF = +$675,300 (rate ~57 STB/day)
Year 9: CF = +$564,200 (rate ~48 STB/day)
Year 10: CF = +$473,500 (rate ~40 STB/day)

Discounted cash flows at r = 12%:
Year 0: -4,800,000 / 1.000 = -$4,800,000
Year 1: 4,201,940 / 1.120 = $3,751,732
Year 2: 2,589,075 / 1.254 = $2,064,655
Year 3: 1,929,915 / 1.405 = $1,373,595
Year 4: 1,513,065 / 1.574 = $961,288
Year 5: 1,213,100 / 1.762 = $688,479
Year 6: 985,750 / 1.974 = $499,367
Year 7: 812,400 / 2.211 = $367,299
Year 8: 675,300 / 2.476 = $272,737
Year 9: 564,200 / 2.773 = $203,454
Year 10: 473,500 / 3.106 = $152,449

10-year NPV = sum = -4,800,000 + 3,751,732 + 2,064,655 + 1,373,595 + 961,288 + 688,479 + 499,367 + 367,299 + 272,737 + 203,454 + 152,449

= -4,800,000 + 10,335,055 = +$5,535,055 NPV at 12% over 10 years

Full life NPV (30 years to abandonment at 15 STB/day):
Years 11-30 contribute an additional ~$450,000 in discounted value (heavily discounted)
Full life NPV ≈ $5,985,000

NPV/Capex ratio (Profitability Index):
PI = $5,985,000 / $4,800,000 = 1.247
Interpretation: Every $1 invested returns $1.247 in present value → creates $0.247 of value per invested dollar

3.2 IRR Calculation: Finding the Break-Even Discount Rate

IRR calculation by interpolation:
IRR is the discount rate r* where NPV = 0

Try r = 50%:
NPV_50 = -4,800 + 4,202/1.50 + 2,589/2.25 + 1,930/3.375 + 1,513/5.063 + 1,213/7.594 + ...
= -4,800 + 2,801 + 1,151 + 572 + 299 + 160 + 84 + 44 + 23 + 12 + 6
= -4,800 + 5,152 = +$352K (still positive at 50%)

Try r = 70%:
NPV_70 = -4,800 + 4,202/1.70 + 2,589/2.89 + 1,930/4.913 + 1,513/8.352 + 1,213/14.198 + ...
= -4,800 + 2,472 + 896 + 393 + 181 + 85 + 39 + 18 + 8 + 4 + 2
= -4,800 + 4,098 = -$702K (negative at 70%)

Linear interpolation for IRR:
IRR ≈ 50% + (352/(352+702)) x (70%-50%)
= 50% + (352/1054) x 20%
= 50% + 0.334 x 20% = 50% + 6.68% = IRR ≈ 56.7%

IRR = 56.7% >> hurdle rate of 12% → well is strongly economic

IRR sensitivity to initial rate:
At qi = 485 STB/day (base): IRR = 56.7%
At qi = 350 STB/day (-28%): IRR ≈ 38% (still well above 12% hurdle)
At qi = 250 STB/day (-48%): IRR ≈ 22% (marginally above hurdle)
At qi = 180 STB/day (-63%): IRR ≈ 12% = hurdle rate → minimum commercial initial rate

This identifies the minimum viable initial production rate: qi_min ≈ 180 STB/day for this well cost and fiscal structure. Any well that does not achieve 180 STB/day initial production will not earn the required 12% return on its $4.8M investment at $68/bbl oil.

4. Capital Allocation: Ranking Competing Projects

4.1 The IRR Ranking Fallacy and NPV Superiority

When a company has more investment opportunities than available capital, it must rank projects and select the portfolio that maximizes total value creation. IRR is frequently used for this ranking exercise, but it systematically produces incorrect rankings when projects differ significantly in scale. The correct ranking metric for capital-constrained project selection is the Profitability Index (NPV per dollar invested):

Capital allocation example - 5 competing projects, $50M budget:

Project A: Small well workover, Capex $1.5M, NPV $850K, IRR 48%
Project B: Infill well, Capex $4.8M, NPV $5,985K, IRR 57%
Project C: Water injection system, Capex $12M, NPV $18,200K, IRR 35%
Project D: Compression upgrade, Capex $8M, NPV $9,600K, IRR 28%
Project E: New development well, Capex $22M, NPV $31,500K, IRR 24%

Ranking by IRR (incorrect for capital allocation):
1. Project B: 57% IRR → Select ($4.8M, cumulative $4.8M)
2. Project A: 48% IRR → Select ($1.5M, cumulative $6.3M)
3. Project C: 35% IRR → Select ($12M, cumulative $18.3M)
4. Project D: 28% IRR → Select ($8M, cumulative $26.3M)
5. Project E: 24% IRR → Select ($22M, cumulative $48.3M) → fits within $50M budget

Total NPV from IRR-ranked selection = $850 + $5,985 + $18,200 + $9,600 + $31,500 = $66,135K

Ranking by Profitability Index (PI = NPV/Capex) - correct method:
Project B: PI = $5,985/$4,800 = 1.247
Project C: PI = $18,200/$12,000 = 1.517
Project D: PI = $9,600/$8,000 = 1.200
Project E: PI = $31,500/$22,000 = 1.432
Project A: PI = $850/$1,500 = 0.567

Ranking by PI:
1. Project C: PI 1.517 → Select ($12M, cumulative $12M, NPV $18,200K)
2. Project E: PI 1.432 → Select ($22M, cumulative $34M, NPV $31,500K)
3. Project B: PI 1.247 → Select ($4.8M, cumulative $38.8M, NPV $5,985K)
4. Project D: PI 1.200 → Select ($8M, cumulative $46.8M, NPV $9,600K)
5. Project A: PI 0.567, remaining budget $3.2M < $1.5M → Select ($1.5M, cumulative $48.3M, NPV $850K)

Wait - $50M - $46.8M = $3.2M remaining. Project A costs $1.5M → fits.
Total NPV from PI-ranked selection = $18,200 + $31,500 + $5,985 + $9,600 + $850 = $66,135K

Same total NPV in this example because all 5 projects fit within the $50M budget with either ranking method. The ranking difference matters when the budget is tighter:

At $30M budget:
IRR ranking selects: B+A+C+D = $26.3M → NPV = $850+$5,985+$18,200+$9,600 = $34,635K
PI ranking selects: C+E = $34M → exceeds budget. Select C+B+D = $24.8M → NPV = $18,200+$5,985+$9,600 = $33,785K
Or: C+E partially funded... actual optimization requires integer programming

The PI ranking correctly identifies that Project E ($22M, PI 1.432) creates more value per dollar than Projects A ($1.5M, PI 0.567) and D ($8M, PI 1.200) combined, even though its IRR (24%) is lower than both.

4.2 Incremental IRR: The Correct Comparison for Mutually Exclusive Projects

When two projects are mutually exclusive (choose one or the other), compare on NPV - not IRR:

Development option A: Minimum facilities, 12 wells, Capex $280M, NPV $185M at 12%, IRR 19%
Development option B: Full facilities, 18 wells, Capex $420M, NPV $295M at 12%, IRR 17%

IRR ranking says: Choose Option A (higher IRR 19%)
NPV ranking says: Choose Option B (higher NPV $295M vs $185M)

Which is correct? Option B creates $110M more value. Choose Option B.

The IRR says Option A has a higher return rate, but that higher rate applies to $140M less investment. The question is whether the additional $140M invested in Option B vs A earns above the hurdle rate.

Incremental IRR analysis (Option B minus Option A):
Incremental investment = $420M - $280M = $140M
Incremental NPV = $295M - $185M = $110M
Incremental IRR = IRR on the $140M incremental investment that generates $110M incremental NPV

If incremental IRR > 12% hurdle: Accept the larger option (B)
Incremental NPV $110M on $140M investment → IRR of incremental investment ≈ 21% > 12% → Accept Option B

This confirms the NPV conclusion: the additional $140M in Option B earns 21% return, well above the 12% hurdle rate, so the larger investment creates more total value.

5. Uncertainty and Risk: Stochastic NPV Analysis

5.1 Monte Carlo NPV: Moving Beyond Single-Point Estimates

A single-point NPV calculation uses one value for each input variable. In reality, every input has uncertainty: the initial production rate may be 485 STB/day or it may be 350 STB/day or 620 STB/day, depending on reservoir quality, completion effectiveness, and stimulation results. Monte Carlo simulation propagates this input uncertainty through the cash flow model to generate a probability distribution of NPV outcomes rather than a single deterministic value:

Monte Carlo simulation setup for tight oil well NPV:

Input variable probability distributions:
Initial rate qi: Triangular distribution, min=280, most likely=485, max=720 STB/day
Decline exponent b: Uniform distribution, min=0.70, max=1.10
Initial decline Di: Normal distribution, mean=0.72/yr, std dev=0.12/yr
Oil price: Lognormal distribution, mean=$68/bbl, std dev=$15/bbl
Well cost (Capex): Triangular distribution, min=$4.2M, most likely=$4.8M, max=$6.5M
Opex: Normal distribution, mean=$18/STB, std dev=$3/STB

Monte Carlo results (10,000 iterations):
P10 NPV (pessimistic case, 10th percentile): -$820,000 (loss scenario)
P50 NPV (median, most likely): +$4,950,000
P90 NPV (optimistic case, 90th percentile): +$11,200,000
Mean NPV: +$5,100,000
Probability NPV > 0: 87.3%
Probability NPV > $3,000,000 (minimum acceptable): 72.1%

Decision information from Monte Carlo vs single-point NPV:
Single-point: NPV = $5,985,000 → "Invest"
Monte Carlo: 12.7% probability of loss, 27.9% probability of below-minimum return → "Invest, but acknowledge 1-in-8 chance of losing money"

The Monte Carlo result adds critical risk information: the single-point analysis was not wrong (the expected value is similar), but it failed to communicate that this investment has meaningful downside risk. An investor with limited capital who cannot absorb the P10 loss scenario would make a different decision than an investor with a large portfolio who can tolerate individual well losses.

5.2 Real Options: The Value of Management Flexibility

Real Option Type	Description	Value Created	Example
Option to defer	Right but not obligation to develop now. Wait for better information (higher price, lower cost technology) before committing capital.	$20-100M for large projects	Marginal deepwater discovery with $45/bbl breakeven held while oil price recovers to $70+/bbl
Option to expand	Initial development designed to accommodate future expansion (larger pipeline, expandable facility) if early results are better than expected.	10-20% of base NPV	FPSO designed for 150,000 bbl/day but initially producing 80,000 bbl/day - upside capacity preserved
Option to abandon	Ability to stop production early and recover residual asset value if oil prices fall or production disappoints below operating cost threshold.	5-15% of project NPV	Phased development where Phase 2 capital is committed only after Phase 1 production confirms the reservoir model
Option to switch	Facility designed to process multiple feed types or produce multiple products depending on market conditions.	Variable	Gas processing plant designed to produce LPG or pipeline gas depending on relative product prices

Conclusion

The decline curve calculation in this article qi = 485 STB/day declining through 354 STB/day in Year 1, 163 STB/day in Year 3, and 102 STB/day in Year 5 under hyperbolic parameters b=0.85, Di=0.72/year - demonstrates why the choice of decline curve parameters has larger economic consequences than almost any other input in a petroleum economic model. A 20% error in the initial decline rate Di (0.72 vs 0.86 per year) produces a 15% reduction in Year 5 production and a 12% reduction in 10-year NPV from $5,985K to $5,267K, a $718K difference that dwarfs the impact of a 20% error in well cost. The engineer who spends significant time optimizing the well cost estimate while accepting the decline curve parameters from a quick analog comparison is optimizing the wrong variable. The highest-value activity in tight oil economic evaluation is establishing defensible decline curve parameters from early production data, analog well performance in the same formation and completion design, and type curve analysis - before committing additional capital to infill development.

The capital allocation comparison - IRR ranking versus PI ranking producing the same portfolio when all projects fit the budget but different portfolios under a tighter budget constraint establishes the practical rule for petroleum investment decisions: use NPV to make accept/reject decisions on individual projects, use PI to rank competing projects when capital is constrained, and use incremental IRR to choose between mutually exclusive development options of different sizes. IRR is a useful communication tool and a quick screen for obviously uneconomic projects, but it should never be the sole ranking criterion when investment sizes vary across the opportunity set which is always the case in a real petroleum asset portfolio.

For engineers looking to build expertise in petroleum project economics and investment analysis, the following references provide comprehensive coverage of the methods in this article: Petroleum Investment Decisions and Economic Analysis covers WACC, NPV/IRR methodology, and capital allocation frameworks, while Decline Curve Analysis and Production Forecasting provides the theoretical foundation for the Arps equations and their application to unconventional reservoir performance.

Want to access our petroleum economics toolkit with Arps decline curve calculator, full NPV/IRR model, WACC calculator, PI-based capital allocation optimizer, and Monte Carlo NPV simulator, or discuss investment analysis for a specific project? Join our Telegram group for petroleum economics and investment discussions, or visit our YouTube channel for step-by-step tutorials on decline curve analysis, NPV calculation, and capital allocation optimization.

Disclosure: This article contains affiliate links. If you purchase a book through these links, Petrosmart Academy may earn a small commission at no additional cost to you. We only recommend resources that provide genuine value to petroleum engineers and industry professionals.