OG
AshToolbox Oil & Gas Petroleum Engineering Suite
SPEE • Upstream DCF Valuation Standard

Well Cash Flow & Petroleum Economics Simulator

Evaluate capital allocation, project profitability, and risk margins across global upstream fiscal regimes. Model multi-year production decline schedules, CAPEX drilling and completions, fixed and variable OPEX, mineral royalties, production taxes, corporate tax shields, and calculate Net Present Value (NPV), Internal Rate of Return (IRR), and breakeven commodity prices.

Engineering Disclaimer:Calculations are estimates for screening, planning, and academic evaluation. Not a substitute for certified commercial simulators, certified well-control software, API/ASME standards, or qualified engineering judgement.

Well Cash Flow & Petroleum Economics Suite

100% In-Browser • Field Confidential • Offline-Ready

Upstream discounted cash flow (DCF), NPV (8/10/15/20%), IRR, DPI, payout time, and breakeven pricing

Capital Expenditure (CAPEX) & Pricing

Fiscal Burden & Operating Costs

Cross-Tool Workflow: Pipe Results To...

Seamlessly transfer calculated fluid properties, EUR forecasts, or hydraulics into the next engineering phase (zero server upload).

NPV (10%)
$10.07M
Undisc: $17.43M
Internal Rate of Return
64.8%
Hurdl: 10%
Payout Duration
2.0 yrs
DPI: 2.06x
Breakeven Oil Price
$29.65
Per bbl @ NPV10=0

Cash Flow Profile & Capital Recovery

NPV Sensitivity Across Discount Hurdle Rates
NPV 8%$11.58M
NPV 10% (Base)$10.07M
NPV 15%$7.25M
NPV 20%$5.14M

NPV10 Sensitivity Impact (% ΔNPV10 relative to base)

Impact on Target Output when inputs swing ±20% while holding other parameters constant.

Oil Price ($/bbl)56.25 → 93.75 (Δ 42)
Initial Production (Bbl)144,000 → 216,000 (Δ 36)
Drilling & Completion CAPEX7,600,000 → 11,400,000 (Δ 28)
Royalty Burden (%)15 → 25 (Δ 18)

Petroleum Economic Evaluation & Discounted Cash Flow (DCF) Architecture

Exploration and production (E&P) capital projects are distinguished by front-loaded capital investment followed by decaying revenue streams subject to volatile commodity markets and geological uncertainty. Petroleum economics bridges reservoir engineering production forecasts with corporate finance to inform drilling approvals, property acquisitions, and divestitures.

The standard evaluation framework utilizes annual or monthly Discounted Cash Flow (DCF) accounting, governed by guidelines from the Society of Petroleum Evaluation Engineers (SPEE) and the SPE-PRMS.

1. Upstream Cash Flow Waterfall & Fiscal Deductions

In a concessionary / royalty-tax fiscal system (standard in the United States, Canada, and the UK North Sea), annual Net Cash Flow (NCF) is computed through sequential deductions:

Gross Revenue = (Q_oil × P_oil) + (Q_gas × P_gas)
Royalty Burden = Gross Revenue × Royalty_Rate   (12.5% to 25.0%)
Net Revenue = Gross Revenue - Royalty Burden
OPEX = Fixed_OPEX + (Variable_OPEX × Q_oil)
Severance & Ad Valorem Taxes = Net Revenue × Production_Tax_Rate
Operating Income (EBITDAX) = Net Revenue - OPEX - Production Taxes
Taxable Income = EBITDAX - CAPEX_Depreciation
Net Cash Flow (NCF) = EBITDAX - Total_CAPEX - Corporate_Income_Tax

2. Core Investment Decision Metrics: NPV, IRR & DPI

Petroleum investment committees rely on four principal metrics to screen and rank competing drilling prospects:

Net Present Value (NPV)
NPV = ∑ [ NCF_t / (1 + r)^t ]

Total present dollar value generated above the corporate cost of capital. A 10% discount rate (NPV10) represents the universal benchmark standard for reserve reporting.

Internal Rate of Return (IRR)
NPV(IRR) = 0

The effective compound interest yield generated by invested capital. Unconventional tight-oil projects generally require a minimum hurdle IRR of 20% to 30% at base price decks.

Discounted Profit-to-Investment (DPI)
DPI = (NPV + PV_Capex) / PV_Capex

Also known as the Profitability Index (PI). Measures value created per dollar of capital exposed. A DPI of 1.30 indicates 30 cents of net present value created per capital dollar.

Breakeven Oil Price
P_oil where NPV10 = 0

The minimum flat commodity price required across the project life to fully recover all capital, operating, and tax expenses plus earn a 10% annual return.

Frequently Asked Questions (Answer-First)

Why is a 10% discount rate (NPV10) the industry standard?

The US Securities and Exchange Commission (SEC) and the Society of Petroleum Engineers (SPE) standardized on 10% as a proxy for the long-term weighted average cost of capital (WACC) and risk premium in the petroleum industry, enabling uniform comparability across diverse asset portfolios.

What is the difference between undiscounted and discounted payout?

Undiscounted payout is the calendar time required for cumulative net cash flow to equal zero, recovering initial capital. Discounted payout accounts for the time value of money, determining the point when discounted revenues recover discounted capital at the specified hurdle rate.

How does mineral royalty burden impact well economic life?

Royalties represent a top-line deduction taken before operating expenses are subtracted. A higher royalty burden (e.g., 25% vs 12.5%) directly reduces net realized revenue per barrel, accelerating the calendar date when the well reaches its economic limit (q_ab) and shortening total reserve life.