Oil & Gas Model Validation
Executive Summary
Key Takeaways
- ✓ Validating an oil and gas financial model requires procedures beyond general model validation practice, reserve engineering reconciliation, borrowing base replication, and fiscal waterfall verification.
- ✓ Reserve engineering reconciliation confirms the model's decline curve and reserve category assumptions match the current reserve report, the necessary first validation step before any downstream check.
- ✓ Borrowing base replication testing independently recalculates a reserve-based lending facility's borrowing base using the lender's own methodology, rather than accepting the model's stated output.
- ✓ Fiscal waterfall verification confirms cost recovery, profit split, or royalty-tax mechanics are correctly built against the actual contract or regulation, not a generic approximation.
Objective¶
This guide sets out the specific procedures oil and gas financial model validation requires, within Oil & Gas Financial Modelling, consistent with the general model risk discipline addressed in Model Risk.
Reserve Engineering Reconciliation¶
The first validation step confirms the model's decline curve parameters and reserve category, proved, 2P, or 3P, match the current reserve engineering report, addressed in Upstream Financial Models. Every downstream revenue, borrowing base, or valuation calculation depends on this reconciliation being correct first.
Borrowing Base Replication Testing¶
For any model supporting a reserve-based lending facility, validation should independently recalculate the available borrowing base using the lender's own stated methodology, rather than accepting the model's calculated output as given. This replication test is the specific check that confirms the model implements the facility's actual redetermination mechanics, not an approximation of them.
Fiscal Waterfall Verification¶
Where the asset is governed by a production sharing contract or another sector-specific fiscal regime, validation should confirm the cost recovery ceiling, carry-forward balance, and profit split or royalty-tax mechanics are built against the actual contract terms, addressed in full in Fiscal Regime Modelling and Production Sharing Contract Models, rather than a generic approximation standing in for the specific formula.
Common Validation Failures¶
- Validating downstream calculations before confirming the underlying reserve and decline assumptions match the current reserve report.
- Accepting a model's stated borrowing base output without independently replicating the lender's methodology.
- Testing fiscal mechanics against a simplified approximation rather than the actual contract terms.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Industries¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
How does oil and gas model validation differ from general model validation?
It adds procedures specific to the sector's structural mechanics, reserve engineering reconciliation, reserve-based lending borrowing base replication, and fiscal regime waterfall verification, none of which a generic model validation process addresses.
What does reserve engineering reconciliation involve?
Confirming that the decline curve parameters and reserve category used in the financial model match the current reserve engineering report, the necessary first step before validating any downstream revenue, borrowing base, or valuation calculation built on those assumptions.
What is borrowing base replication testing?
Independently recalculating a reserve-based lending facility's available borrowing base using the lender's own stated methodology, rather than accepting the model's calculated output as given, confirming the model actually implements the facility's specific mechanics correctly.
What does fiscal waterfall verification check?
That cost recovery, profit split, or royalty-tax mechanics are built against the actual contract terms or regulatory formula applicable to the asset, addressed in full in Fiscal Regime Modelling and Production Sharing Contract Models, rather than a generic effective tax rate approximation.
Related Articles
Oil & Gas Financial Modelling
Oil and gas financial modelling is the practice of building financial models across the four structurally distinct segments of the hydrocarbon value chain, upstream exploration and production, midstream transport and processing, downstream refining and petrochemicals, and LNG, each governed by different revenue mechanics, contract structures and risk drivers. This page is the hub for the Knowledge Centre's oil and gas financial modelling content: industry structure and segment definitions, the financial KPIs the sector is measured against, the investment lifecycle from exploration through decommissioning, and how this domain builds toward asset and project-level models, commercial and investment analysis, and governance and assurance practice as it expands.
Upstream Financial Models
Upstream financial models project revenue and debt capacity from a depleting reserve base using a production decline curve rather than a steady-state or growth volume forecast common to most other industries. This guide sets out how upstream models are structured around exploration and production economics, reserve categories, decline mechanics, fiscal terms, and the reserve-based lending structures that finance the segment, the foundational technical grounding this domain's asset-level and commercial analysis content builds on.
Reserve-Based Lending
Reserve-based lending (RBL) is the dominant financing structure for upstream oil and gas assets, tying the available borrowing base to the discounted value of proved reserves under a bank-defined price deck, redetermined periodically, typically semi-annually, against updated reserve and price estimates. The financial model supporting an RBL facility must replicate the lender's specific borrowing base methodology precisely, since an approximated version will not match the actual facility mechanics.
Production Sharing Contract Models
Building a production sharing contract (PSC) into a financial model requires a specific waterfall structure: a cost recovery ceiling limiting how much cost oil or cost gas can be claimed in a period, a carry-forward mechanism for unrecovered cost, and a profit oil or profit gas split that frequently varies with production rate or a cumulative revenue-to-cost ratio known as an R-factor. This guide sets out how to construct that waterfall as a modelling exercise, extending the conceptual definition covered in the Production Sharing Contract glossary entry.
Financial Model Audit for Oil & Gas
Upstream oil and gas financial models project revenue and debt capacity from a depleting reserve base, using production decline curves rather than a going-concern volume forecast. Reserve-based lending structures, where the borrowing base is periodically redetermined against updated reserve and price estimates, fiscal terms specific to production sharing contracts or concession agreements, and mandatory decommissioning liabilities each interact with that declining production profile in ways a standard corporate model does not test. This page sets out the modelling risks specific to oil and gas, the audit findings that recur in upstream financing models, and what lenders typically expect under a reserve-based lending structure.
What Is Model Risk?
Model risk is the risk that a decision is wrong not because the underlying business or investment case was flawed, but because the model used to evaluate it was. It is a distinct category of risk from market risk, credit risk, or operational risk, and it applies to any organisation that relies on a financial model, spreadsheet or otherwise, to support a material decision. Most published model risk content addresses statistical and regulatory capital models used inside banks. This page defines model risk specifically as it applies to Excel based financial models, the kind used every day for investment decisions, lending, and transaction evaluation, which is a related but distinct problem from the quantitative model risk literature most search results return.