Oil & Gas Financial Modelling Best Practices
Executive Summary
Key Takeaways
- ✓ Oil and gas financial modelling best practice synthesises into three disciplines, segment-correct structure, reserve-and-contract fidelity, and connected governance.
- ✓ Segment-correct structure means building each segment, upstream, midstream, downstream, and LNG, on its own structurally correct basis rather than applying one segment's mechanics to another.
- ✓ Reserve-and-contract fidelity means the model's decline, fiscal, and contractual assumptions remain precisely reconciled to their underlying technical and legal sources, never approximated for convenience.
- ✓ Connected governance means validation, independent assurance, and named ownership operate as a single, demonstrable, ongoing programme, not isolated, disconnected review events.
Objective¶
This guide synthesises Oil & Gas Financial Modelling into three disciplines that together define institutional best practice, extending the Knowledge Centre's general Financial Modelling Best Practices pillar with the sector-specific synthesis this domain has built.
Discipline One: Segment-Correct Structure¶
Every model should be built on the structurally correct basis for the segment it represents, upstream decline curve and reserve mechanics, midstream and downstream contracted throughput and margin mechanics, or LNG's combination of both, addressed throughout Oil & Gas Industry Overview and the asset-level guides across this domain. Applying one segment's structural logic to another is a structural error no amount of formula accuracy elsewhere in the model can correct.
Discipline Two: Reserve-and-Contract Fidelity¶
The model's decline curve, reserve category, and fiscal or commercial contract assumptions should remain precisely reconciled to their underlying technical and legal sources, the current reserve engineering report and the actual contract terms, addressed throughout Oil & Gas Model Validation, rather than approximated for modelling convenience. This fidelity is what separates a genuinely bankable model from one that merely looks complete.
Discipline Three: Connected Governance¶
Validation, independent assurance, and named ownership should operate as a single, demonstrable, ongoing programme, addressed in Oil & Gas Model Governance, Oil & Gas Independent Model Assurance, and Oil & Gas Documentation Standards, rather than isolated review events disconnected from one another and from the model's actual maintenance cadence.
Using This Guide as a Standing Reference¶
This guide functions as the standing reference point for evaluating any new oil and gas financial model, or any model under periodic review, against the domain's accumulated guidance. It should be used alongside, not in place of, the detailed Oil & Gas Project Model Checklist and the Common Oil & Gas Modelling Errors catalogue, both of which provide the granular, checkable detail this synthesis draws together.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
- Oil & Gas Model Validation
- Oil & Gas Model Governance
- Oil & Gas Independent Model Assurance
- Common Oil & Gas Modelling Errors
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What are the three disciplines this domain synthesises into?
Segment-correct structure, building each segment on its own structurally correct basis; reserve- and-contract fidelity, keeping the model precisely reconciled to its underlying technical and legal sources; and connected governance, operating validation, assurance, and ownership as a single ongoing programme.
What does segment-correct structure mean in practice?
Building upstream on decline curve and reserve mechanics, midstream and downstream on contracted throughput and margin mechanics, and LNG on the combination of both, addressed throughout Oil & Gas Industry Overview and the asset-level guides in this domain, rather than applying one segment's structural logic to another.
What does reserve-and-contract fidelity require?
That the model's decline curve, reserve category, and fiscal or commercial contract assumptions remain precisely reconciled to the current reserve engineering report and actual contract terms, addressed throughout Oil & Gas Model Validation, rather than approximated for modelling convenience.
What does connected governance mean for an oil and gas model?
That named ownership, change control, independent assurance, and documentation, addressed in Oil & Gas Model Governance, Oil & Gas Independent Model Assurance, and Oil & Gas Documentation Standards, operate together as a single, demonstrable, ongoing programme rather than isolated review events disconnected from one another.
How should this guide be used?
As a standing reference point for evaluating any oil and gas financial model against the domain's accumulated guidance, checked alongside the detailed Oil & Gas Project Model Checklist rather than as a replacement for that structured review.
References
- Society of Petroleum Engineers, World Petroleum Council, American Association of Petroleum Geologists, Society of Petroleum Evaluation Engineers — Petroleum Resources Management System (PRMS 2018)
- U.S. Securities and Exchange Commission — Modernization of Oil and Gas Reporting (17 CFR Part 210, Rule 4-10)
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.
Oil & Gas Industry Overview
The oil and gas industry is not a single business but four structurally distinct segments, upstream exploration and production, midstream transport and processing, downstream refining and petrochemicals, and LNG, each governed by different revenue mechanics, asset lives and risk drivers. This guide sets out the industry structure that underlies every model built anywhere in the value chain, and why a modeller's first task is correctly identifying which segment, or combination of segments, a given asset or company sits in before selecting a modelling approach.
Oil & Gas Model Validation
Validating an oil and gas financial model requires procedures beyond general model validation practice: reconciling the model's decline and reserve assumptions against the current reserve engineering report, independently replicating any reserve-based lending borrowing base calculation, and verifying fiscal regime waterfall mechanics against the actual contract terms. This guide sets out these procedures as a step-by-step validation methodology, extending the general model validation discipline with the sector-specific checks this domain requires.
Oil & Gas Model Governance
Model governance for an oil and gas financial model requires an explicit connection between the reserve engineering function, which owns the underlying technical basis, and the finance function, which owns the financial model built on it, since the two are frequently maintained separately and can drift apart without a defined governance link. This guide sets out how oil and gas model governance should structure named ownership, change control triggers, and review cadence around this cross-functional dependency, extending the Knowledge Centre's general financial model governance discipline.
Oil & Gas Independent Model Assurance
Independent model assurance for an oil and gas financial model is most effective when its review cadence is tied to the events that actually change the model's basis, a new reserve engineering report, a reserve-based lending redetermination, or a material fiscal or contractual change, rather than a generic annual cadence alone. This guide sets out how to structure an ongoing assurance cycle around these trigger events, connecting periodic independent review with the validation and governance practices covered elsewhere in this domain.
Common Oil & Gas Modelling Errors
This guide consolidates the recurring structural errors identified throughout the Oil & Gas Financial Modelling domain into a single reference catalogue: decline curve drift from the reserve report, reserve-based lending borrowing base approximation, flat fiscal regime splits, and decommissioning under-provisioning, among others. Each entry links to the specific guide addressing it in full, so this page functions as a quick-reference index rather than a duplicate treatment of content covered elsewhere in the domain.
Financial Modelling Best Practices — Standards Compared
Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.
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.