Financial Model Audit for Oil & Gas

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.

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.

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.

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.

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 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 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.

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.