Blog · Finance metrics and formulas · Oil and gas
Separate production, realized prices, operating costs and capital spending in an oil and gas operating review. Work from sales and finance exports to a reconciled business-unit comparison.
Financial analysis of oil and gas companies separates price, sales volume, operating costs and capital spending so managers can see what changed. Start with the company's operating exports, reconcile them to finance records, and explain the movement by business unit. A stronger production report can coexist with weaker contribution and less available cash.
Bring sales statements with quantities and recognized revenue, production reports, field expense detail and capital spending records. Keep period, business unit, product, unit of measure and ownership basis on every relevant row. Record whether volumes are gross field volumes or the company's entitlement; never combine the two.
Calculate revenue effects separately for oil, gas and natural gas liquids before adding the dollar results. Barrels and gas volumes are different measures. A barrel-of-oil-equivalent convention can help an operating summary, but it does not turn unlike products into one realized sales price.
Realized price means recognized product sales revenue divided by the matching sold quantity. Use the company's actual revenue rather than substituting a market benchmark: the EIA explains that crude grades have persistent price differentials. Keep derivative settlements and other income on separate lines so the operating comparison has a consistent boundary.
For the overall statement review, use financial analysis; the steps here concentrate on operating drivers.
Consider an illustrative US producer comparing April and May 2026. This simplified example contains oil sales only, with identical ownership and revenue policies across periods. Field costs are the defined operating-expense accounts for these units; capital spending is cash paid for capital projects.
Place the following columns in A:H, with April rows first. All inputs are illustrative, and no rounded figures feed later calculations.
| Unit | Month | Sold oil (bbl) | Realized price (USD/bbl) | Revenue (USD) | Field costs (USD) | Contribution (USD) | Capital paid (USD) |
|---|---|---|---|---|---|---|---|
| Permian | April | 100,000 | 70 | 7,000,000 | 2,300,000 | 4,700,000 | 3,000,000 |
| Gulf | April | 50,000 | 60 | 3,000,000 | 1,200,000 | 1,800,000 | 1,000,000 |
| Permian | May | 110,000 | 65 | 7,150,000 | 2,640,000 | 4,510,000 | 3,800,000 |
| Gulf | May | 45,000 | 62 | 2,790,000 | 1,170,000 | 1,620,000 | 900,000 |
Revenue in E2 and contribution in G2, filled down through row 5, are:
=C2*D2
=E2-F2
In a real export, start with recorded revenue and derive price using =E2/C2; investigate any zero-volume revenue adjustment separately. Contribution here is a management subtotal before corporate costs, depletion, depreciation, interest and taxes. It is not net income.
The April and May contribution totals are $6,500,000 and $6,130,000. Confirm each period's revenue and expense totals against the mapped ledger accounts before interpreting the decline.
Use one stated sequence: reprice the old volume first, then value the volume change at the new price.
Price effect = Old sold volume × (New price − Old price)
Volume effect = (New sold volume − Old sold volume) × New price
This sequence assigns the interaction between price and volume to the volume effect. Another sequence can work, but switching sequences makes comparisons harder to read.
| Unit | Price effect (USD) | Volume effect (USD) | Revenue change (USD) |
|---|---|---|---|
| Permian | -500,000 | 650,000 | 150,000 |
| Gulf | 100,000 | -310,000 | -210,000 |
| Total | -400,000 | 340,000 | -60,000 |
For Permian, use these formulas against the first table; Gulf uses the corresponding rows:
=C2*(D4-D2)
=(C4-C2)*D4
=E4-E2
The proof is $10,000,000 − $400,000 + $340,000 = $9,940,000, equal to May revenue. Permian sold more oil but received less per barrel; Gulf received more per barrel but sold less. Assign commercial questions to the revenue team and output or delivery questions to operations. For forward planning after this review, see oil and gas financial modeling.
Company field costs rose from $3,500,000 to $3,810,000. Therefore the $60,000 revenue decline plus $310,000 additional costs explains the entire $370,000 contribution decline.
Use =F2/C2 for field cost per sold barrel. Permian moves from $23 to $24; Gulf moves from $24 to $26. Gulf's total costs fall while its unit cost rises, which is why a lower expense total alone does not establish better performance.
Inspect maintenance, labor, water handling and other mapped expense rows with the field manager. Also compare costs with produced volumes where that is the relevant operating denominator. Sold-volume unit cost above is a financial comparison and can move with inventory timing.
Service contractors need a different comparison of billed activity, utilization and delivery costs; use oilfield services financial analysis for that job.
Capital paid rises from $4,000,000 to $4,700,000. It belongs beside the contribution comparison, with project approvals and payment dates, rather than being treated as another field operating expense.
The SEC's financial statement guide distinguishes operating, investing and financing cash flows and explains why income differs from cash. Reconcile recorded expenses to payments, include working-capital movements and add the remaining company cash flows before describing available cash. Contribution less capital paid alone cannot establish the change in the bank balance.
Finance owns that reconciliation; operating managers explain field spending, and project owners explain capital commitments and payments. Keep any request to defer spending tied to the relevant project and operational consequences.
Upload your sales, field-cost and capital-spending file or Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the price, volume and spending movements with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for oil and gas businesses for supporting industry context.
Use production and sales statements, revenue postings, field expense detail and capital expenditure records for matching periods. Include business unit, product, ownership basis and units. Add receivables, payables and cash movement reports when the review needs to explain cash as well as operating results.
Use sold volume for the revenue calculation because it matches the sales value. Compare production with sales separately, explaining inventory, delivery timing and ownership differences. A production increase does not establish a revenue increase when the additional output has not been sold.
No. A subtotal defined as sales revenue less field operating expenses excludes other items, such as corporate overhead, depreciation, depletion, financing and income taxes. Label its scope and reconcile it to the applicable ledger accounts before using it to compare operating units.