Oil & Gas Financial Modelling
Executive Summary
Key Takeaways
- ✓ Oil and gas financial modelling spans four structurally distinct segments, upstream, midstream, downstream and LNG, each with different revenue mechanics, contract structures and risk drivers, and a single generic model template cannot represent all four reliably.
- ✓ Upstream models are built from a depleting reserve base and a production decline curve rather than a steady-state or growth volume forecast, the single most consequential structural difference from a conventional corporate model.
- ✓ Midstream and downstream segments behave far more like conventional infrastructure and industrial models, contracted throughput, tariffs, and refining margins, than like the reserve-depletion mechanics of upstream.
- ✓ LNG models combine upstream-style reserve dependency with long-term offtake contract structures and liquefaction capacity economics unique to the segment.
- ✓ This pillar is distinct from, and complements, the Knowledge Centre''s existing Financial Model Audit for Oil & Gas content, which addresses audit risk in already-built upstream financing models rather than the construction and analysis of models across the full value chain.
- ✓ A defined set of financial KPIs, reserve replacement ratio, finding and development cost, lifting cost, netback and reserve life index, are how the sector measures performance in a way generic corporate metrics do not capture.
- ✓ The investment lifecycle, from exploration through Final Investment Decision to production and eventual decommissioning, is the organising structure for how oil and gas capital allocation and financial modelling requirements change at each stage.
- ✓ Asset and project-level models, exploration and production, field development, offshore and onshore facility choice, refinery and petrochemical process detail, pipeline, storage and gas processing contract structures, and decommissioning, extend the segment-level guidance with the granularity a specific asset or project decision requires.
- ✓ Decommissioning is a mandatory, often substantial, end-of-life obligation that should be provisioned progressively across the production life against the applicable regulatory requirement, not treated as an unplanned late-life cost.
- ✓ Commercial and investment analysis, portfolio-level production forecasting, reserve-based valuation, probabilistic decline curve modelling, production sharing contract waterfalls, joint venture economics, price scenario analysis, fiscal regime identification, sensitivity analysis and Monte Carlo simulation, extends this domain from asset construction into the analytical techniques used to value and stress-test what has been built.
- ✓ Oil and gas fiscal regimes take one of three principal forms, concession and royalty-tax, production sharing contracts, or service contracts, and identifying which one actually applies to a given asset and jurisdiction is the necessary first step before any government take calculation can be modelled correctly.
- ✓ Governance and assurance for this domain rests on three connected disciplines, segment-correct structure, reserve-and-contract fidelity, and connected governance, synthesised as the domain's institutional best practice capstone.
- ✓ Assurance cadence for an oil and gas model is most effective when tied to specific trigger events, a new reserve report, a redetermination, or a material contractual change, rather than a generic annual schedule alone.
Institutional Definition¶
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. 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.
Why This Pillar Is Distinct From Existing Oil & Gas Audit Content¶
The Knowledge Centre already covers Financial Model Audit for Oil & Gas, the audit risks specific to already-built upstream financing models, reserve-based lending mechanics and decline curve consistency in particular. This pillar sits alongside that content rather than duplicating it: it addresses the construction, structure and analysis of financial models across the full value chain, upstream, midstream, downstream and LNG, not the independent verification of a model that already exists. A model is built and analysed using the guidance in this pillar, and separately audited using the discipline set out in Financial Model Audit for Oil & Gas and the Knowledge Centre's general Financial Model Auditing content; the two are complementary stages of a model's life, not competing definitions of the same term.
Foundations: Industry Structure and Segment Definitions¶
Oil and gas industry overview. How the hydrocarbon value chain divides into upstream, midstream, downstream and LNG, and why each segment requires a distinct financial modelling approach. See Oil & Gas Industry Overview.
Upstream financial models. Exploration and production modelling built from a depleting reserve base and a production decline curve, the segment's defining structural feature. See Upstream Financial Models.
Midstream financial models. Pipeline, gathering, processing and storage modelling built from contracted throughput, tariffs and take-or-pay structures on effectively non-depleting physical assets. See Midstream Financial Models.
Downstream financial models. Refining and petrochemical modelling built from crack spreads, refining margins and utilization rates rather than reserve depletion. See Downstream Financial Models.
LNG financial models. Liquefaction, offtake and shipping economics combining upstream-style reserve dependency with long-term contract structures unique to LNG. See LNG Financial Models.
Integrated energy company models. How majors consolidate upstream, midstream, downstream and chemicals segments into a single financial model, and the commodity-price diversification this integration provides. See Integrated Energy Company Models.
Measuring Performance and the Investment Lifecycle¶
Oil & Gas Financial KPIs. The defined KPI set, reserve replacement ratio, finding and development cost, lifting cost, netback price, reserve life index and EBITDAX, read together to assess sector performance. See Oil & Gas Financial KPIs.
Oil & Gas Investment Lifecycle. The staged progression from exploration through appraisal, Final Investment Decision, construction, production and decommissioning, and how financial modelling requirements change at each stage. See Oil & Gas Investment Lifecycle.
Core Terminology¶
Production decline curve. The mathematical function describing how upstream production output falls over time from an initial rate — see Production Decline Curve.
Reserve-based lending. A financing structure tying the available borrowing base to the value of proved reserves, redetermined periodically — see Reserve-Based Lending.
Production sharing contract. A fiscal arrangement defining how produced hydrocarbons are split between operator and host government — see Production Sharing Contract.
Proved and probable reserves. The 1P/2P/3P reserve classification system underlying reserve-based valuation and lending — see Proved and Probable Reserves.
Netback price. The realized price for produced hydrocarbons after transport, processing and royalty deductions — see Netback Price.
Final Investment Decision. The formal gate at which a project's financing, contracts and reserves are locked in before major capital commitment — see Final Investment Decision.
Lifting cost. The operating cost of producing each barrel of oil equivalent from an already-developed field — see Lifting Cost.
Reserve replacement ratio. The ratio of reserves added to reserves produced in a period, a key indicator of production sustainability — see Reserve Replacement Ratio.
Asset & Project Models¶
Exploration & production models. Well and pad-level modelling, type curves, drilling schedules, and per-well cost, extending the segment-level upstream economics above with buildable, granular detail. See Exploration & Production Models.
Field development financial models. Phased capital expenditure, first oil timing, and the tie-back-versus-standalone facility decision for a specific discovered field. See Field Development Financial Models.
Offshore project models. Facility type choice (fixed platform, FPSO, subsea tieback), weather-driven downtime, and marine logistics cost. See Offshore Project Models.
Onshore project models. Land access, well pad economics across a typically larger well count, and pipeline-versus-truck takeaway. See Onshore Project Models.
Refinery financial models. Process unit-level complexity, crude slate flexibility, and turnaround capex scheduling, extending downstream segment economics. See Refinery Financial Models.
Petrochemical financial models. Steam cracker feedstock flexibility, product slate economics, and integration with refinery feedstock supply. See Petrochemical Financial Models.
Pipeline financial models. Tariff methodology, firm-versus-interruptible capacity allocation, and debt sculpting against contracted capacity fees. See Pipeline Financial Models.
Storage terminal financial models. Working versus shell capacity, forward curve-driven storage demand, and terminalling agreements. See Storage Terminal Financial Models.
Gas processing plant models. NGL extraction recovery rates and fee-for-service, percent-of-proceeds, and keep-whole contract structures. See Gas Processing Plant Models.
Decommissioning cost models. End-of-life obligation estimation, progressive provisioning, and the financial security mechanisms regulators require. See Decommissioning Cost Models.
Comparisons in this wave include Offshore vs. Onshore Development Models and Refinery vs. Petrochemical Financial Models, with verification supported by the Oil & Gas Project Model Checklist.
Commercial & Investment Analysis¶
Production forecast models. Aggregating well and field-level building blocks into a company or portfolio-level production forecast, separating organic decline from new development additions. See Production Forecast Models.
Decline curve financial models. Translating the reserve engineering decline curve into a full cash flow schedule with probabilistic P10/P50/P90 uncertainty bands. See Decline Curve Financial Models.
Reserve-based valuation models. PV-10 and reserve-based valuation construction, and its relationship to general DCF valuation practice. See Reserve-Based Valuation Models.
Production sharing contract models. Building the cost recovery ceiling, carry-forward, and R-factor-driven profit split waterfall a PSC requires. See Production Sharing Contract Models.
Joint venture financial models. Working interest versus net revenue interest, cash calls, and the authorization for expenditure process. See Joint Venture Financial Models.
Oil price scenario analysis. Forward curve and bank price deck base cases, alongside explicit upside and downside stress cases. See Oil Price Scenario Analysis.
Gas price scenario analysis. Regional hub variation and long-term contract indexation conventions distinct from oil price modelling. See Gas Price Scenario Analysis.
Fiscal regime modelling. Identifying which of the three principal fiscal regime types applies before modelling government take. See Fiscal Regime Modelling.
Oil & gas sensitivity analysis. The sector-specific variable set, price, decline rate, cost, and fiscal terms, tested individually and in combination. See Oil & Gas Sensitivity Analysis.
Oil & gas Monte Carlo risk analysis. Stacking reserve, price, and decline uncertainty into a probability distribution, reconciled against P10/P50/P90 reserve cases. See Oil & Gas Monte Carlo Risk Analysis.
Illustrative case studies in this wave include A Reserve-Based Lending Model Understates Redetermination Risk After a Price Deck Revision and An Unmodelled R-Factor Threshold Understates Government Take in a Production Sharing Contract Model, with a practical build structure provided by the Oil & Gas Project Model Template.
Governance & Assurance¶
Oil & gas model validation. Reserve engineering reconciliation, borrowing base replication testing, and fiscal waterfall verification, beyond general model validation practice. See Oil & Gas Model Validation.
Oil & gas due diligence. Reserve report reconciliation, contract assignment verification, and decommissioning liability quantification for a transaction. See Oil & Gas Due Diligence.
Oil & gas lender model review. Independent borrowing base replication, reserve report currency, and hedging programme compliance. See Oil & Gas Lender Model Review.
Oil & gas investment committee review. Reserve category disclosure, fiscal regime confirmation, and price scenario presentation for an FID submission. See Oil & Gas Investment Committee Review.
Common oil & gas modelling errors. A consolidated catalogue of the recurring structural errors identified across this domain. See Common Oil & Gas Modelling Errors.
Oil & gas documentation standards. Reserve report reference, contract citation, price deck source, and decommissioning security evidence. See Oil & Gas Documentation Standards.
Oil & gas independent model assurance. A trigger-based assurance cadence tied to reserve report updates and redetermination dates, rather than a generic annual schedule. See Oil & Gas Independent Model Assurance.
Oil & gas model governance. Named ownership connecting the reserve engineering and finance functions, and change control tied to reserve and contractual trigger events. See Oil & Gas Model Governance.
Oil & Gas Financial Modelling Best Practices. This domain's capstone synthesis into three disciplines, segment-correct structure, reserve-and-contract fidelity, and connected governance, the standing reference point for evaluating any oil and gas financial model. See Oil & Gas Financial Modelling Best Practices.
Domain Status¶
This pillar and its supporting technical guides, glossary terms, comparisons, checklist, case studies and template are complete across all four waves: industry foundations, asset and project models, commercial and investment analysis, and governance and assurance. Knowledge graph integrity, JSON-LD schema validity, internal linking and search indexing across the full domain are verified through the Knowledge Centre's automated content validation.
Relationship to Adjacent Knowledge Centre Content¶
See Financial Model Audit for Oil & Gas for audit risk specific to already-built upstream financing models, Project Finance Model Audit for the general project finance discipline midstream and LNG financing frequently draws on, Energy Financial Modelling for power and renewable generation modelling, Financial Model Auditing for the general independent verification discipline that applies once an oil and gas model is built, Financial Model Due Diligence and Transaction Due Diligence for the general transaction disciplines this domain's due diligence guidance extends, Financial Model Governance and Model Risk for the general governance and risk disciplines this domain's assurance guidance extends, Discounted Cash Flow (DCF) Valuation for cross-industry valuation construction this domain's sector-specific guidance extends, Climate Finance for transition risk and stranded asset considerations relevant to reserve-based portfolios, and Infrastructure Asset Management & Operations Financial Modelling for the owner/operator lifecycle perspective relevant to midstream infrastructure.
References & Further Reading¶
- 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)
Continue Reading¶
Related Technical Guides¶
- Oil & Gas Industry Overview
- Upstream Financial Models
- Midstream Financial Models
- Downstream Financial Models
- LNG Financial Models
- Integrated Energy Company Models
- Oil & Gas Financial KPIs
- Oil & Gas Investment Lifecycle
- Exploration & Production Models
- Field Development Financial Models
- Offshore Project Models
- Onshore Project Models
- Refinery Financial Models
- Petrochemical Financial Models
- Pipeline Financial Models
- Storage Terminal Financial Models
- Gas Processing Plant Models
- Decommissioning Cost Models
- Production Forecast Models
- Decline Curve Financial Models
- Reserve-Based Valuation Models
- Production Sharing Contract Models
- Joint Venture Financial Models
- Oil Price Scenario Analysis
- Gas Price Scenario Analysis
- Fiscal Regime Modelling
- Oil & Gas Sensitivity Analysis
- Oil & Gas Monte Carlo Risk Analysis
- Oil & Gas Model Validation
- Oil & Gas Due Diligence
- Oil & Gas Lender Model Review
- Oil & Gas Investment Committee Review
- Common Oil & Gas Modelling Errors
- Oil & Gas Documentation Standards
- Oil & Gas Independent Model Assurance
- Oil & Gas Model Governance
- Oil & Gas Financial Modelling Best Practices
Related Glossary¶
- Production Decline Curve
- Reserve-Based Lending
- Production Sharing Contract
- Proved and Probable Reserves
- Netback Price
- Final Investment Decision
- Lifting Cost
- Reserve Replacement Ratio
- Sensitivity Analysis
- Monte Carlo Simulation
Related Comparisons¶
Related Checklists¶
Related Case Studies¶
- A Reserve-Based Lending Model Understates Redetermination Risk After a Price Deck Revision
- An Unmodelled R-Factor Threshold Understates Government Take in a Production Sharing Contract Model
Related Resources¶
Related Industries¶
Sibling Pillars¶
- Project Finance Model Audit
- Energy Financial Modelling
- Financial Model Auditing
- Discounted Cash Flow (DCF) Valuation
- Financial Model Due Diligence
- Transaction Due Diligence
- Financial Model Governance
- Model Risk
- Climate Finance
- Infrastructure Asset Management & Operations Financial Modelling
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is oil and gas financial modelling?
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 requiring different revenue mechanics, contract structures and modelling approaches.
Why can't one generic financial model template cover the whole oil and gas value chain?
Because the segments behave fundamentally differently. Upstream output depletes from a finite reserve base on a decline curve; midstream and downstream revenue is driven by contracted throughput, tariffs and refining margins on effectively non-depleting physical assets; and LNG combines elements of both. A template built for one segment misrepresents the others.
How does oil and gas financial modelling relate to the Knowledge Centre's existing Financial Model Audit for Oil & Gas content?
They are complementary rather than overlapping. Financial Model Audit for Oil & Gas addresses audit risk in already-built upstream financing models, reserve-based lending and decline curve consistency in particular. This pillar addresses the construction, structure and analysis of models across the full value chain, upstream, midstream, downstream and LNG, which then become subject to that same audit discipline once built.
What financial KPIs is the oil and gas sector measured against?
A defined set including reserve replacement ratio, finding and development cost per barrel of oil equivalent, lifting cost, netback price, reserve life index and EBITDAX, each addressed in full in Oil & Gas Financial KPIs.
What is the investment lifecycle in oil and gas, and why does it matter for modelling?
The staged progression from exploration through appraisal, Final Investment Decision, construction, production and eventual decommissioning. Each stage carries different capital intensity, risk profile and financial modelling requirements, addressed in full in Oil & Gas Investment Lifecycle.
Who is this domain written for?
National oil companies, international oil companies, energy developers, EPC contractors, infrastructure investors, project finance lenders, sovereign wealth funds, investment banks, financial modellers and financial model auditors working across any segment of the oil and gas value chain.
How does this domain cover asset and project-level modelling beyond segment-level economics?
Through dedicated guides on exploration and production well-level detail, field development planning, offshore and onshore facility choice, refinery and petrochemical process detail, pipeline, storage terminal and gas processing contract structures, and decommissioning cost provisioning, each extending the segment-level guidance with the granularity a specific asset or project decision requires.
How should decommissioning be treated in an oil and gas financial model?
As a mandatory obligation provisioned progressively across the production life against the applicable regulatory requirement, addressed in full in Decommissioning Cost Models, not as an unplanned cost appended at the end of the model.
How does this domain cover valuation and commercial analysis?
Through dedicated guides on portfolio-level production forecasting, reserve-based valuation (PV-10), probabilistic decline curve modelling, production sharing contract waterfalls, joint venture economics, oil and gas price scenario analysis, fiscal regime identification, sensitivity analysis and Monte Carlo simulation, extending the domain from asset construction into the techniques used to value and stress-test those assets.
What are the main types of oil and gas fiscal regime, and why does identifying the right one matter?
Concession and royalty-tax regimes, production sharing contracts, and service contracts, each dividing value between operator and government through a fundamentally different mechanism, addressed in full in Fiscal Regime Modelling. Applying one regime's mechanics to an asset actually governed by another produces a structurally wrong government take calculation regardless of how carefully the wrong mechanics are built.
What governance and assurance guidance does this domain provide?
Model validation procedures specific to reserve reconciliation and borrowing base replication, due diligence checks for transactions, lender and investment committee review guidance, a consolidated catalogue of common modelling errors, documentation standards, an independent assurance cadence tied to trigger events rather than a fixed calendar, model governance connecting the reserve engineering and finance functions, and a capstone best-practices synthesis.
Is the Oil & Gas Financial Modelling domain complete?
Yes, across all four planned waves, industry foundations, asset and project models, commercial and investment analysis, and governance and assurance, addressed in full in the Domain Status section below.
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 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.
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.
Midstream Financial Models
Midstream financial models cover the gathering, transport, processing and storage of produced hydrocarbons, assets that are effectively non-depleting and whose revenue is instead driven by contracted throughput volumes, regulated or negotiated tariffs, and take-or-pay commitments. This guide sets out how midstream models are structured, the contract mechanics that determine revenue certainty, and why the segment is modelled closer to conventional project finance infrastructure than to upstream reserve depletion.
Downstream Financial Models
Downstream financial models cover refining and petrochemical manufacturing, where revenue and margin are driven by the spread between crude oil or feedstock input cost and refined product or petrochemical output prices, combined with plant utilization and complexity. This guide sets out how downstream models are structured around crack spread economics, capacity and turnaround planning, and product yield, and why the segment's modelling risk centres on margin volatility rather than reserve or volume risk.
LNG Financial Models
LNG financial models sit across the upstream and midstream boundary, depending on a depleting natural gas reserve base for feed gas while also requiring capital-intensive liquefaction infrastructure and long-term offtake sale and purchase agreements to underpin financing. This guide sets out how LNG models are structured around liquefaction train capacity, offtake pricing mechanisms, shipping and regasification economics, and the specific risks, boil-off, price indexation mismatch, and offtake counterparty concentration, that distinguish LNG from both pure upstream and pure midstream modelling.
Integrated Energy Company Models
Integrated energy companies, international majors and national oil companies, operate across upstream, midstream, downstream and, frequently, petrochemicals simultaneously. This guide sets out how a consolidated model for an integrated company should build each segment on its own correct structural basis before consolidating, why segment-level reporting is preserved for capital allocation and valuation purposes, and how integration provides a degree of natural commodity price diversification a single-segment company does not have.
Oil & Gas Financial KPIs
Oil and gas performance is measured against a defined set of sector-specific KPIs that a generic corporate metric set does not capture: reserve replacement ratio, finding and development cost, lifting cost, netback price, reserve life index and EBITDAX. This guide sets out what each KPI measures, how it is calculated, and why reading them together, rather than any single metric in isolation, is required to assess whether a company or asset's production is genuinely sustainable.
Oil & Gas Investment Lifecycle
Oil and gas capital projects move through a defined lifecycle, exploration, appraisal, Final Investment Decision, construction, production, and eventual decommissioning, and the financial model's purpose, structure and level of detail should change at each stage. This guide sets out what each stage requires from a financial model, why Final Investment Decision is the single most consequential gate in the sequence, and how a model appropriate to an early stage becomes inadequate, and a model appropriate to a late stage becomes excessive, at a different stage.
Production Decline Curve
A production decline curve is a mathematical function, exponential, hyperbolic or harmonic, describing how upstream oil and gas production output falls over time from an initial rate as a reservoir depletes. It is the central structural basis for upstream revenue and debt capacity projection, and its parameters must be kept consistent with the underlying reserve engineering report, a recurring source of divergence and audit finding when the two are maintained separately.
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
A production sharing contract (PSC) is a fiscal arrangement, common in many oil and gas jurisdictions, under which the host government retains ownership of the resource while the contractor bears exploration and development risk in exchange for cost recovery from a capped share of production and a further split of remaining, "profit," production against the government. PSC mechanics vary materially by jurisdiction and require dedicated modelling of the actual contract formula rather than a generic effective tax rate.
Proved and Probable Reserves
Proved (1P), proved plus probable (2P), and proved plus probable plus possible (3P) reserves are the standard classification system, set out in the Petroleum Resources Management System, for the certainty of estimated recoverable hydrocarbon volumes. Which category is appropriate depends on the model's purpose: reserve-based lending typically sizes against proved reserves alone, while planning models sometimes incorporate 2P volumes, and using the wrong category for a given purpose materially distorts the resulting analysis.
Netback Price
Netback price is the realized price a producer actually receives for hydrocarbons after deducting transport, processing and royalty costs from the gross sale price, a more accurate measure of an asset's actual realized economics than a gross benchmark price. It is used throughout upstream and LNG modelling to translate a market reference price into the specific, asset-level realized value a financial model should actually project.
Final Investment Decision
Final Investment Decision (FID) is the formal gate at which an oil and gas project's financing, offtake or sales contracts, and reserve estimates are locked in ahead of major capital commitment. It is the single most consequential stage in the oil and gas investment lifecycle, the point at which a project's financial model shifts from representing probabilistic planning ranges to reflecting specific, binding, negotiated terms.
Lifting Cost
Lifting cost is the operating cost of producing each barrel of oil equivalent from an already-developed field, typically expressed per boe. It is distinct from finding and development cost, which measures the capital cost of adding new reserves rather than producing existing ones, and is one of the core KPIs used to assess the operating efficiency of a producing asset.
Reserve Replacement Ratio
Reserve replacement ratio is the ratio of reserves added, through discovery, extension or acquisition, to reserves produced in a given period. A ratio above 100% indicates a company is adding reserves faster than it depletes them; below 100% indicates its reserve base is shrinking. It should always be read alongside finding and development cost, since a strong ratio achieved at disproportionately high cost is not equivalent to sustainable, economic reserve growth.
Exploration & Production Models
Exploration and production (E&P) asset models translate segment-level upstream economics into a specific, buildable model at the well and pad level: type curves for individual wells, a rig-count-driven drilling schedule, per-well capital and operating cost, and the production ramp-up that results from drilling activity over time. This guide sets out how E&P models are structured at this granular level, complementing the segment-wide reserve and fiscal mechanics covered in Upstream Financial Models.
Field Development Financial Models
Field development financial models translate a discovered, appraised field into a specific development plan: phased capital expenditure, first oil or first gas timing, plateau production rate, and the facility sizing and tie-back-versus-standalone decisions that shape the project's capital intensity. This guide sets out how a field development model is structured around these decisions and how it feeds into the Final Investment Decision that follows.
Offshore Project Models
Offshore project models must account for the specific cost and risk drivers of developing hydrocarbons at sea, fixed platforms, floating production storage and offloading (FPSO) vessels, and subsea tiebacks, each with materially different capital cost and operating profiles, alongside weather-driven downtime and logistics costs that do not arise onshore. This guide sets out how offshore models are structured around these facility choices and risk factors.
Onshore Project Models
Onshore project models are shaped by land access and surface rights, well pad-level economics across a typically larger well count than offshore developments, and the choice between pipeline and trucking takeaway for produced volumes ahead of pipeline connection. This guide sets out how onshore models are structured around these drivers, and how they differ from the facility-centric economics of offshore development.
Refinery Financial Models
Refinery financial models build on the segment-level crack spread economics covered in Downstream Financial Models with process unit-level detail: refinery complexity and its effect on achievable product yield, crude slate flexibility, and the explicit scheduling of periodic turnaround capital expenditure. This guide sets out how a refinery model is structured at this level of detail, and the modelling errors that arise from collapsing unit-level detail into a single blended margin assumption.
Petrochemical Financial Models
Petrochemical financial models centre on the steam cracker, the plant that converts hydrocarbon feedstock, ethane or naphtha, into base petrochemicals such as ethylene and propylene, and the further conversion of those base products into polymers such as polyethylene and polypropylene. This guide sets out how petrochemical models are structured around feedstock flexibility, product slate economics, and the frequent integration between petrochemical operations and refinery feedstock supply.
Pipeline Financial Models
Pipeline financial models extend the segment-level midstream economics covered in Midstream Financial Models with the specific tariff methodology, capacity allocation structure, and debt sculpting mechanics that apply to a pipeline asset. This guide sets out how a pipeline model is structured around cost-of-service and negotiated tariff regimes, firm versus interruptible capacity contracts, and the project finance-style debt structuring these contracted revenues typically support.
Storage Terminal Financial Models
Storage terminal financial models are built around tank capacity, working capacity available for active use versus total shell capacity, and revenue structures typically based on capacity reservation fees rather than pure throughput. This guide sets out how storage terminal economics are modelled, including the effect of forward curve shape (contango and backwardation) on storage demand, and how terminalling agreements provide the revenue certainty underlying terminal financing.
Gas Processing Plant Models
Gas processing plant financial models centre on the extraction of natural gas liquids, ethane, propane, butane and natural gasoline, from raw wellhead gas, and the specific contract structure, fee-for-service, percent-of-proceeds, or keep-whole, under which the plant is compensated. This guide sets out how gas processing economics are modelled around plant recovery rates and the commodity price exposure each contract structure creates for the processor.
Decommissioning Cost Models
Decommissioning cost models estimate and provision the mandatory end-of-life obligation to plug wells and remove oil and gas infrastructure, an obligation that should be funded progressively across the production life rather than treated as a single terminal-year cost. This guide sets out how decommissioning cost is estimated, the funding mechanisms, sinking funds, parent company guarantees, and letters of credit, regulators typically require, and why timing and discounting of the liability matter to how it is represented in a financial model.
Offshore vs. Onshore Development Models
Offshore and onshore oil and gas developments require structurally different financial models. Offshore developments are shaped by facility type choice, fixed platform, FPSO, or subsea tieback, higher per-unit capital cost, weather-driven downtime, and materially higher decommissioning cost. Onshore developments are shaped by land access, well pad economics across a typically larger well count, and takeaway logistics. This comparison sets out these differences and why a model built for one cannot be directly repurposed for the other.
Refinery vs. Petrochemical Financial Models
Refinery and petrochemical financial models both sit in the downstream segment but are built around different core processes and margin drivers. A refinery model centres on crude distillation and conversion units producing fuels, sized by complexity and crude slate flexibility, while a petrochemical model centres on the steam cracker converting ethane or naphtha feedstock into base petrochemicals and polymers. This comparison sets out the differences and the internal transfer pricing discipline required where the two are integrated.
Oil & Gas Project Model Checklist
This checklist covers the verification checks specific to an oil and gas asset or project financial model, on top of the general financial model audit baseline. It focuses on confirming that well-level or facility-level detail is correctly represented, that contract structures (take-or-pay, tariff, processing agreements) are modelled against their actual terms, and that decommissioning is properly provisioned. It is intended for energy developers, EPC contractors, project finance lenders and financial modellers reviewing an asset or project model before it supports a development or financing decision.
Production Forecast Models
A company or portfolio-level production forecast aggregates the individual production profiles of many wells and fields, each at a different stage of its own decline, into a single consolidated volume forecast. This guide sets out how production forecasts are built at this aggregate level, the distinction between organic decline and the effect of an ongoing drilling or development programme, and why a portfolio forecast requires reconciliation back to its underlying asset-level building blocks rather than being projected directly from historical aggregate volume.
Reserve-Based Valuation Models
Reserve-based valuation discounts the future net revenue expected from producing a defined reserve base, most commonly reported as PV-10, the present value of estimated future net revenue from proved reserves discounted at 10%, a standardized measure under U.S. SEC reporting requirements. This guide sets out how reserve-based valuation is constructed, how it relates to general discounted cash flow valuation practice, and the reserve category and price deck choices that most affect the resulting value.
Decline Curve Financial Models
A decline curve financial model translates the underlying production decline curve into a full revenue, cost and cash flow schedule, and represents the genuine uncertainty in future production through probabilistic P10, P50 and P90 cases rather than a single deterministic line. This guide sets out how decline parameters flow through into a bankable cash flow model, and why the model's uncertainty treatment should reflect the same probabilistic basis used in the underlying reserve estimate.
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.
Joint Venture Financial Models
Oil and gas assets are frequently developed and operated through joint ventures, with an operator managing day-to-day activity on behalf of itself and non-operating partners holding working interests. This guide sets out how joint venture financial models represent working interest versus net revenue interest, the cash call process funding joint operations, and the authorization for expenditure (AFE) mechanism governing capital commitments under a joint operating agreement.
Oil Price Scenario Analysis
Oil price is one of the single most influential variables in any oil and gas financial model, and should be tested through a defined set of scenarios, a forward curve or bank price deck base case, and explicit upside and downside stress cases, rather than a single flat assumed price held constant across the model's full life. This guide sets out how oil price scenarios are constructed, the difference between forward curve pricing and a flat long-term assumption, and how scenario results should be presented alongside the base case rather than replacing it.
Gas Price Scenario Analysis
Natural gas price scenario analysis differs from oil price scenario analysis in one key respect: gas trades at materially different prices across regional hubs, and long-term contracts, particularly in LNG, are frequently priced against a specific indexation formula rather than a single global benchmark. This guide sets out how gas price scenarios should reflect the relevant regional hub or contract indexation basis, and why applying an oil-style single global benchmark misrepresents gas price exposure.
Fiscal Regime Modelling
Oil and gas fiscal regimes take one of several forms across jurisdictions, concession and royalty-tax regimes, production sharing contracts, or service contracts, each dividing value between operator and host government through a different mechanism. This guide sets out how to identify which fiscal regime applies to a given asset and jurisdiction, the modelling implications of each type, and why a generic effective tax rate cannot substitute for the actual regime's specific mechanics.
Oil & Gas Sensitivity Analysis
Sensitivity analysis in oil and gas financial modelling applies the general sensitivity analysis technique to the specific variables that matter most in this sector: commodity price, production decline rate, capital and operating cost, and fiscal regime terms. This guide sets out which variables to flex, why decline rate sensitivity is distinct from price sensitivity, and why fiscal terms should be tested in combination with price given their frequent interaction through mechanisms such as an R-factor.
Oil & Gas Monte Carlo Risk Analysis
Monte Carlo simulation applies the general Monte Carlo technique to the specific, overlapping sources of uncertainty in an oil and gas financial model, reserve volume, commodity price, and production decline rate, running many combined iterations to produce a probability distribution of outcomes rather than a fixed set of discrete scenarios. This guide sets out how Monte Carlo simulation should be applied in this sector, how it complements rather than replaces the P10/P50/P90 reserve-based cases and defined sensitivity scenarios covered elsewhere in this domain, and where it adds genuine value over a simpler scenario-based approach.
A Reserve-Based Lending Model Understates Redetermination Risk After a Price Deck Revision
This is an illustrative, composite scenario, not a specific real transaction. It follows an upstream operator financed under a reserve-based lending facility whose internal financial model continued to use an outdated, more favourable price deck after the lender's own price deck was revised downward, masking an emerging borrowing base shortfall until the actual redetermination arrived. The core lesson: a reserve-based lending model should be updated to reflect the lender's current price deck proactively, not only at the point of formal redetermination.
An Unmodelled R-Factor Threshold Understates Government Take in a Production Sharing Contract Model
This is an illustrative, composite scenario, not a specific real transaction. It follows an international oil company operating under a production sharing contract whose internal financial model applied a flat profit oil split throughout the contract life, rather than the contract's actual R-factor-based sliding scale, overstating the contractor's projected share of profit production in later years. The core lesson: an R-factor-based profit split must be modelled as a running, cumulative calculation, not a static figure carried forward unchanged.
Oil & Gas Project Model Template
A bankable oil and gas asset or project financial model needs a consistent structure connecting its reserve and decline basis, fiscal regime waterfall, contracted revenue mechanics, and decommissioning provisioning. This template sets out that structure section by section, so a model is built with each sector-specific mechanic represented explicitly rather than collapsed into generic corporate model assumptions.
Sensitivity Analysis
Sensitivity analysis is the quantitative assessment of how much a financial model's output changes when a single input variable is changed by a defined amount, while all other variables are held at their base case values. It measures the responsiveness — or sensitivity — of outputs to individual assumption changes. Sensitivity analysis is distinct from scenario analysis, which changes multiple assumptions simultaneously to reflect a coherent alternative state. Sensitivity analysis isolates the effect of individual variables; scenario analysis tests the combined effect of assumption sets.
Monte Carlo Simulation
Monte Carlo simulation is a quantitative technique that builds a distribution of possible outcomes by running a large number of trials, each drawing its inputs from specified probability distributions, rather than relying on a single point estimate or a small set of discrete scenarios. In financial modelling and investment analysis, it is applied wherever a decision depends on several uncertain inputs whose combined effect is difficult to characterize through sensitivity or scenario analysis alone, most prominently in capital budgeting and DCF valuation, where the DCF-specific application of the technique is treated as its own dedicated guide.
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 Due Diligence
Financial model due diligence on an oil and gas transaction requires checks beyond general transaction due diligence practice: reconciling the target model against its underlying reserve engineering report, confirming production sharing contract or joint venture terms transfer correctly to the acquirer, and quantifying any decommissioning liability being assumed. This guide sets out these sector-specific due diligence checks, extending the general financial model due diligence and transaction due diligence disciplines already covered in the Knowledge Centre.
Oil & Gas Lender Model Review
A lender reviewing an oil and gas financial model, whether ahead of a reserve-based lending redetermination or a project finance drawdown, applies checks specific to the sector on top of the general lender model review discipline: independent borrowing base replication, reserve report currency, and hedging programme compliance. This guide sets out these sector-specific review points and how they extend the Knowledge Centre's general Lender Model Review Checklist.
Oil & Gas Investment Committee Review
An investment committee reviewing an oil and gas Final Investment Decision submission should confirm a set of sector-specific disclosures beyond a general investment committee review: the reserve category basis presented, the fiscal regime and its specific mechanics, and whether both base and stress price scenarios have been presented rather than a single case. This guide sets out these confirmation points and extends the Knowledge Centre's general Investment Committee Model Checklist with oil and gas-specific review requirements.
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.
Oil & Gas Documentation Standards
An oil and gas financial model requires documentation beyond standard model documentation practice: a clear reference to the specific reserve engineering report and its version, citation of the actual fiscal or commercial contract terms modelled, the source and date of the price deck used, and evidence of the decommissioning financial security in place. This guide sets out these documentation requirements, so a model's technical and commercial basis remains traceable and independently verifiable after the fact.
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.
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 Financial Modelling Best Practices
This guide synthesises the Oil & Gas Financial Modelling domain into three disciplines that together define institutional best practice: building each segment, upstream, midstream, downstream, and LNG, on its own structurally correct basis; maintaining fidelity between the model and its underlying reserve, fiscal, and contractual basis rather than approximating any of them; and connecting validation, assurance, and governance into a single, demonstrable, ongoing programme rather than isolated review events. This page is the standing reference point for evaluating any oil and gas financial model against the domain's accumulated guidance.
Financial Model Due Diligence
Financial model due diligence is the discipline of testing whether the financial model used to price, structure, or finance a transaction is itself structurally sound — a distinct question from whether the target business's historical financials are reliable (the domain of financial due diligence) or whether its commercial prospects are durable (commercial due diligence). A model can be structurally unsound — an untraceable synergy figure, a broken purchase price allocation link, a hardcoded override masking the true output of a formula — independent of whether the underlying business is fundamentally healthy, and this risk is what financial model due diligence is specifically built to catch. This page is the hub for the Knowledge Centre's model-risk-in-transactions content: how model review differs by audience (independent, lender, investor, vendor), how it differs from a quality of earnings review, and how transaction-specific model risk maps onto FMAE's own structural rule set.
M&A and Transaction Due Diligence
Transaction due diligence is the structured process by which a party to a proposed transaction — most often a buyer, but also a seller preparing for sale or a lender financing the deal — investigates a target business before committing capital. It is organized into distinct workstreams (financial, commercial, operational, technical, legal, tax, ESG), run from one of three process postures (buy-side, sell-side, or vendor), and its findings feed directly into the financial model used to price the transaction and support the investment decision. This page is the hub for the Knowledge Centre's transaction due diligence content: what due diligence is, how each workstream and process posture differs, and how model risk specifically enters a transaction — the angle this platform is built to address in depth.
What Is Financial Model Governance?
Financial model governance is the set of policies, roles, and controls an organisation puts in place to manage the risk that comes from relying on financial models for material decisions. It is the organisational layer that sits above any individual financial model audit: governance determines when a model gets audited, who owns that decision, how versions are tracked, and what happens to findings once they exist. Most published governance content online is written for large, tier one banks operating under formal regulatory regimes. A private equity firm, a family office, or a mid market corporate finance team rarely has that scale of infrastructure, and does not need it, but still carries real exposure if no governance exists at all. This page defines governance at the level that actually applies to most organisations relying on Excel models, not just the largest ones.
Independent Model Audit
An independent model audit is a financial model audit performed by a party who is separate from both the model's author and the party relying on the model's output. Independence is one of the two features, alongside systematic coverage, that distinguish an audit from a lighter touch review. Independence can be provided by an internal team separate from the model's builder, a third-party advisory firm, or a deterministic audit engine run by a party other than the model's author — what matters is the structural separation between who built the model and who is checking it, not the specific form the checking party takes.
Climate Finance & Climate Financial Modelling
Climate finance is the mobilisation and allocation of capital toward mitigation, adaptation, and transition activity, and climate financial modelling is the discipline of representing that activity's cash flows, risk, and concessionality in a financial model. This page is the hub for the Knowledge Centre's climate finance content: how sustainable, green, and transition finance are distinct but related capital allocation frames, how a climate investment model differs from a standard project or corporate model in its treatment of concessional capital and additionality, how physical and transition climate risk are quantified at portfolio and entity level, and how carbon markets, climate-sector investment, and institutional governance practice build on these foundations as this domain expands.
Infrastructure Asset Management Financial Modelling
Infrastructure asset management financial modelling is the discipline of modelling an infrastructure asset's ongoing operation, maintenance, and renewal across its full economic life, from the perspective of the owner or operator responsible for that asset once it is in service, rather than the transaction-close or lender perspective covered elsewhere. This page is the hub for the Knowledge Centre's asset management and operations modelling content: how a lifecycle model is structured across planning, construction, operations, renewal, and disposal, how whole-life cost and lifecycle cost analysis compare competing options, and how maintenance, renewal, and capital replacement should be planned and funded. Sector-specific operations models, performance and reliability modelling, and institutional assurance practice for this domain are indexed here as it expands.
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 a Project Finance Model Audit?
A project finance model audit is a financial model audit applied to the specific class of model used to finance infrastructure, energy, and long dated capital projects: debt sculpted, multi decade, cash flow driven structures with mechanics that do not appear in a typical corporate model. It is frequently a formal condition of financial close, not an optional check, and lender requirements for it exist almost entirely inside non public bank credit policy rather than any single consolidated public source. This page defines what makes project finance models structurally distinct, why lenders require independent verification of them specifically, and what the audit process looks like in this context.
Energy Financial Modelling
Energy financial modelling is the discipline of building financial models for power generation assets, independent power producers, and renewable energy projects — structured around a technical output schedule and an electricity revenue stack that a standard corporate or general project finance model has no direct equivalent for. This page is the hub for the Knowledge Centre's energy and power modelling content: how a power project model is architected, how electricity markets and dispatch mechanics translate into revenue, and how power purchase agreements, capacity payments, and merchant exposure combine into a project's revenue structure. Technology-specific renewable energy models (solar, wind, storage, hydro, and others), technical and commercial modelling mechanics, and institutional practice for this asset class are indexed here as the domain expands.
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.
Discounted Cash Flow (DCF) Valuation
Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.