Upstream energy modeling turns reservoir estimates into production schedules and cash flows that lenders and investors can rely on. The goal is simple: translate reserves into a defendable plan that feeds a reserve-based lending model, informs capital allocation, and survives diligence by auditors and credit teams.
Model scope and cash flow boundaries that credit trusts
The model should mirror the lease or unit and the operator’s working interest under the joint operating agreement. Midstream returns are excluded except where tariffs and processing affect realized prices and lifting costs. Cash flows start with gross revenue, pay royalty and overriding royalty, and then fund operating costs, capital, interest, and distributions. Non-operated interests and division orders must pass through the math so that net revenue interest and burdened netbacks are accurate at the well level.
Stakeholders and incentives you must surface
Operators often favor expansive type curves and generous inventory counts to lower their cost of capital. RBL banks haircut volumes, require hedges, and limit credit to proved undeveloped reserves. Private equity wants fast paybacks and proved developed producing cash flow that supports leverage. Reserve auditors prioritize documentation, analogs, and compliance with booking rules. Model assumptions should make these differences visible instead of burying them in a black box.
Reserve categories and booking rules that steer capital
SEC proved taxonomy and economic limit tests
SEC proved reserves break into proved developed producing, proved developed non-producing, and proved undeveloped. PUDs must be reasonably certain to be developed within five years of initial booking under SEC Rule 4-10 unless facts clearly support more time. Booking PUDs requires an adopted development plan, committed capital, and accessible takeaway. PDPs must be on production or capable of production with only minor spend. Run economic limit tests well by well using adopted operating costs and differentials, not pooled averages.
PRMS rollups for decision-making
The PRMS framework supports deterministic or probabilistic methods and defines 1P, 2P, and 3P categories. Public SEC filings present proved only and use standardized price. Track both frameworks in parallel: one internal rollup for 1P, 2P, and 3P decision-making and a proved-only set for SEC and RBL use. Bridge reserve changes to the engineer’s report by category and driver – price, performance, extensions, acquisitions, divestitures – so anyone can audit the trail.
Price decks and disclosure bases that prevent confusion
SEC standardized measure uses the unweighted arithmetic average of first-day-of-month prices for the prior 12 months, adjusted for quality and location. Internal economics should run at forward strip and upside or downside cases, plus any lender base price. Keep price bases consistent across reserve categories within each valuation. If you mix, reconcile explicitly and show the crosswalk; that discipline saves time in committee.
Decline and type curves that stand up to audits
DCA guardrails
Decline curve analysis converts booked volumes into production forecasts. The standard Arps forms – exponential, hyperbolic, and harmonic – fit most shale wells when combined with terminal exponential decline floors. Constrain b-factors to physically reasonable ranges, set a terminal floor, and define well-level economic limits. Expect auditors and credit teams to challenge hyperbolic tails that stretch without analog support.
Early-time fits and interference
Rate transient analysis can sharpen early-time fits when you have pressure and rate data, but it rarely scales across large datasets. On multi-well pads, model interference and parent-child effects by vintage and spacing. Normalize type curves for lateral length and proppant so you can compare across benches and vintages. Document every normalization choice and anchor to accepted practices.
The EIA Drilling Productivity Report offers a public baseline for basin productivity trends and decline parameters. Use it as a reasonableness check, not as a direct input to asset-level models. Local geology and completion design drive dispersion in outcomes.
Building type curves that balance upside and risk
Segment by reservoir bench and landing zone, then by operator and vintage. Clean time series for shut-ins, workovers, and curtailments before fitting. Fit to P50 cohort behavior and define P10 and P90 bounds to inform risked schedules. Set terminal decline floors using mature analog wells from the same reservoir. Cap tail life by the economic limit, not by a calendar guess.
Spacing and frac hits can degrade children relative to parents. Where downspacing or cube development pushed limits, expect stagnation or lower ultimate recoveries. Apply degraders by spacing distance and pad design, not just by year.
Realizations, basis, and contracts that drive netbacks
Price by commodity stream. Crude oil realization is the benchmark price, such as WTI, plus or minus quality and location, net of transport. Midland-Cushing and basin differentials widen under pipeline constraints and tighten as capacity expands, so forecast them separately from flat price. Natural gas realizations tie to Henry Hub or a regional hub less basis and gathering. Basis can swing and go negative during constraints. Only cap downside if firm transport or price floors exist in the contracts. NGLs price off Mont Belvieu by component or composite, with shrink and processing fees deducted.
Processing agreements matter. Percent-of-proceeds and percent-of-index put price exposure on NGLs and make shrink endogenous. Fee-based contracts raise visible midstream expense but simplify price. Model plant fuel and shrink explicitly. Tie contract terms by well or pad when systems differ.
Hedge accounting that separates cash from optics
Split hedging into realized cash settlements and noncash mark-to-market. Swaps lock price. Collars and three-ways set floors with limited upside. Basis swaps protect location. RBLs often require hedges on a share of PDP volumes for the borrowing base tenor. Put hedge premia and collateral flows in financing cash flows, not in operating realizations.
Interests and burdens that determine the take
Net revenue interest equals working interest times one minus royalty and overriding royalty. Complex chains of assignments can drive different burdens across tracts within a unit, so model at tract or well level from division orders. Royalties are off the top and usually gross of severance tax. In Texas, severance taxes are generally 4.6% for oil and 7.5% for gas. Adjust for exemptions where the documentation supports it. Under COPAS accounting, operator overhead loads into lease operating expense; include it in LOE rather than corporate G&A.
Capital, cycle times, and supply chains that convert PUDs
Capex converts undeveloped reserves into cash flow. Break it into drilling, completions, facilities, artificial lift, pad infrastructure, flowlines, water handling, and land. Model refracs and recompletions as discrete projects with uplift and incremental decline. Cycle time matters: spud to total depth, frac, flowback, first sales. Pad drilling brings batch efficiency but can delay first revenue. Reflect supplier payment terms in cash outflows. For RBLs, tie cadence to PUD conversion plans within five years.
Well costs eased after 2022 inflation, with mixed deflation across basins through 2024. Anchor assumptions to recent AFEs and vendor quotes by operator and county. Where midstream or water disposal needs buildout, include that capital or you will strand PUDs.
Operating costs and environmental rules that shift the curve
LOE includes gathering and processing, compression, power, water, chemicals, supervision, insurance, and field G&A. Treat workovers as capex or LOE per policy and stay consistent. Index LOE to power and service rates where they move.
Environmental costs are rising. The EPA Waste Emissions Charge applies to facilities above methane thresholds starting with 2024 emissions, with per-ton fees increasing over time. High methane intensity and flaring can add cost. Model compliance investments and per-unit fees. Some states limit flaring permits for non-emergencies. Gas takeaway constraints can cause shut-ins, so do not assume unconstrained gas sales without transport.
Cash flow waterfall and valuation that committees understand
Build a clear waterfall so reviewers see exactly where dollars go. A simple sequence usually works:
- Gross revenue: Track by commodity and stream.
- Less royalties: Include overriding royalty burdens.
- Less production taxes: Include severance and ad valorem where applicable.
- Equals working interest revenue: The operator’s burdened top line.
- Less LOE: Include field overhead and COPAS charges.
- Equals netback: Field netback before corporate items.
- Less corporate G&A: Add insurance and other central costs.
- Equals EBITDAX: Comparable operating earnings.
- Less capex: Fund development and maintenance projects.
- Equals unlevered free cash flow: Pre-debt cash generation.
- Less interest and principal: Based on the debt schedule.
- Equals levered free cash flow: Post-debt cash for distributions.
Use PV-10 for comparability on proved reserves at SEC pricing. Reserve reports will show PDP PV-10 and PUD PV-10. For decisions, use a risk-appropriate WACC and your internal price deck, not the SEC base. Lenders will haircut PDNP and PUDs and may exclude some categories entirely.
RBL mechanics and flow of funds you must model
Borrowing bases lean on semiannual reserve reports by independent engineers. Collateral covers property mortgages, UCC filings on equipment and proceeds, and assignments of revenues and hedges. Advance rates apply to discounted PDP PVs, with limited or no value for PUDs. Credit agreements include covenants on liquidity, interest coverage, and leverage. Borrowing base deficiencies require cures. Mandatory prepayment from asset sales and hedge settlements is common. Hedges sit under secured ISDAs with control agreements. For SPE borrowers, cash dominion and lockboxes are typical.
Purchasers pay the operator, who disburses royalties and pays marketing and transport per contract. Non-ops receive revenue net of severance tax and allowable deductions. Joint interest billing invoices charge partners for their share of LOE and capex under COPAS. If cash dominion applies, borrower cash sweeps to lender-controlled accounts and releases per the agreement, so build the cash sweep logic to monitor covenant headroom and liquidity.
For a deeper review of how borrowing bases work in practice, see this overview of advance rates and reserves in asset based structures: Asset Based Lending: Borrowing Base, Reserves, and Field Exams.
Scheduling, documentation, and consent pathways
Respect lease terms, continuous drilling clauses, and unitization rules. Align PUD timing with JOA consent rights and preferential purchase rights. Sequence high-capex PUDs with pad efficiency and infrastructure readiness. Model planned downtime for frac hits and tie-ins. Keep a current inventory of key documents and consents so development is not blocked by title, ROFRs, or midstream change-of-control language.
Accounting and taxes that alter comparability
Under US GAAP, most E&Ps use successful efforts accounting. Depreciation, depletion, and amortization typically follow units of production on proved reserves. Impairments occur when carrying value exceeds undiscounted cash flows. Under IFRS, development capex is capitalized when feasibility and viability are established and impairment follows IAS 36. Asset retirement obligations are recognized at fair value and accreted. Public filers disclose the standardized measure based on SEC pricing. Use it for comparability, not as the investment hurdle, and reconcile management valuations to the standardized measure by price, cost, and taxes with a quick DCF checklist.
In the United States, intangible drilling costs may be expensed for tax in the year incurred, affecting cash taxes and deferreds. Percentage depletion can benefit small producers up to statutory limits, while large producers generally use cost depletion. State production taxes reduce pre-tax income. Align any gross-up to GAAP presentation. In cross-border structures, watch withholding and hybrid rules on debt. Keep intercompany marketing and tariffs at arm’s length.
Risk controls, governance, and stop signs
Key risks to emphasize include overstated type curves or unmodeled interference trimming EURs, basis widening or negative regional gas prices cutting realizations without firm transport, service cost shifts and supply chain delays pushing first sales, methane and flaring limits adding cost and capex, midstream terms eroding netbacks, and understated asset retirement obligations creating late-life cash drains.
Governance that helps includes an independent reserve auditor with access and clear scope, type curve reviews that include geoscience and completion input, a contract inventory with economic annotations, monthly reconciliations of model to actuals with variance notes, and sensitivities that break the thesis quickly when assumptions move.
Stop signs worth encoding are PUD plans extending beyond five years without credible exceptions or capital capacity, missing parent-child degraders despite offset evidence, net revenue interests lower than represented, unhedged basis exposure in constrained basins, and emissions fees or flaring limits that make gas handling uneconomic without new capital.
Timeline that gets you to committee
Weeks 0 to 2: Collect logs, completion reports, production histories, AFEs, midstream and marketing agreements, JOAs, COPAS schedules, tax records, title opinions, and reserve reports. Build tract level ownership and net revenue interest schedules. Map contracts to wells.
Weeks 2 to 5: Build type curves and decline fits. Clean and cluster wells, normalize inputs, define P50 and bounds. Cross-check against public basin baselines and peers. Draft the PUD schedule with cycle times and infrastructure sequencing.
Weeks 4 to 6: Build the price deck, basis curves, and hedge book. Translate processing terms into realized prices and shrink. Map gathering and transport fees.
Weeks 5 to 7: Construct the waterfall from EBITDAX to free cash flow. Overlay RBL, hedging covenants, and liquidity. Iterate to meet development and covenant constraints and present headroom using simple covenant modeling.
Weeks 6 to 8: Independent engineer review, legal review of consents and rights of first refusal, and packaging for investment committee with sensitivities and stop signs.
Structures and alternatives that shift cash priorities
Alternatives to outright funding include volumetric production payments that monetize PDP streams with limited recourse, overriding royalty interests and net profits interests that transfer revenue without operating control, and drillcos or development carries that trade capex for back-in rights or promoted terms. Each changes the flow of funds, tax profile, and security package. Lenders will require intercreditor arrangements to preserve collateral cash flow.
Practical modeling tips that save time
- Book with evidence: Do not book PUDs without takeaway or settled title.
- Set terminal floors: Use mature analogs in the same reservoir and lift regime.
- Build bottom up: Create type curves at the bench level, then roll up.
- Model power explicitly: Electrification can lower LOE but needs upfront capex.
- Treat water as core: Transport and disposal can dominate LOE, while recycling can lower cost with facilities capex.
- Separate disclosure from value: Reconcile SEC and GAAP constructs to the investment case, but do not let them steer capital.
Sensitivity design that reveals break points
Run five vectors: commodity prices and basis, well costs and cycle times, LOE and midstream fees, EUR and declines, and scheduling or spacing. Combine into downside and covenant cases. Make a PDP-only case explicit, then stage PDNP and PUD conversions to test liquidity and borrowing base coverage. For private credit, build cash dominion and distribution-restricted cases to verify debt service. For a structured approach to stress tests, this guide offers a practical roadmap: Stress Testing Financial Models. If you prefer Excel-driven grids, add compact sensitivity tables to show price and decline interactions at a glance.
One-page audit checks for fast IC and lender reviews
When time is tight, a quick read can catch big errors before they reach committee. A simple one page audit reduces surprises:
- Reserves bridge: Show start to end reserves by driver and category with sign checks.
- Curve sanity: Display 10 sample wells with fits and a b-factor histogram.
- Price alignment: Prove that realized prices reconcile to benchmarks plus basis and quality.
- Contract tie-outs: List top 10 midstream and processing contracts with economics summarized.
- Cash controls: Reconcile purchaser statements to modeled revenue and JIB to LOE and capex.
- RBL math: Show advance rates, haircuts, and the borrowing base vs. PV with a simple headroom chart.
Conclusion
A credible upstream model is a chain of verifiable links from reserves to cash. The taxonomy defines what counts, decline curves place volumes across time with physics and analogs, prices and contracts translate barrels and molecules into realizations, and capex and LOE set the cost to access and sustain them. The credit overlay turns cash into a borrowing base and covenants. Evidence each link, lean conservative where uncertainty is high, and align with the legal and commercial documents that control cash flow. That discipline protects returns when prices swing and when tail barrels disappoint.
Closeout and retention
Archive the full analytical record, including index, versions, Q&A, users, and audit logs. Then hash, set retention, obtain vendor deletion with a destruction certificate, and document that legal holds supersede deletion. That record keeps future redeterminations, audits, and disputes fast and low friction.