Free Excel templates

A free successful efforts vs full cost model in Excel

Two fields over two years, booked twice: successful efforts and full cost, depletion, the ceiling test, the two results and the gap explained.

A producer spends the same money on leases, seismic, a dry hole and new wells. Under successful efforts it earns $8,169,855 before income tax in 2025; under full cost, $17,534,098. A year later the SEC price falls from $72 to $58 and the order reverses: successful efforts still earns $8,176,357, while the full cost pool is written down by $25,049,175. The model books both methods side by side from one sheet of inputs, ready for your own figures.

Get the model

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Oil_and_Gas_Successful_Efforts_vs_Full_Cost_Model.xlsx (20 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model is a simplified version of the companion workbook of The Oil and Gas Accounting Handbook, which follows one listed producer through two year-ends: reserves estimated and signed, leases, dry holes and a suspended well, depletion field by field, impairment, the full cost pool and its ceiling, asset retirement obligations and the ASC 932 disclosures.

Paperback PDF edition, $19.99

What is in the file

Six tabs. Inputs are blue on yellow cells; everything else is a formula; the Checks tab shows one status, ALL PASS or FAIL.

1. Start here
What the model does, how to fill it, the example, and what it leaves out, with the rules as read and their dates.
2. Inputs
Two columns, 2025 and 2026: production and year-end reserves by field, price and operating costs, every kind of spending (leases, seismic, delay rentals, dry holes, discoveries, suspended wells, development, retirement costs), lease write-offs, excluded costs, future development costs and the present value from the reserve report; opening balances under both methods, carried into 2026 by formula.
3. SE
Successful efforts: the costs expensed, the ledger of each field, depletion of leasehold over total proved reserves and of wells over proved developed reserves, unproved properties, suspended wells and the result.
4. FC
Full cost: the pool, the amortization base with future development costs, DD&A, the ceiling test, the write-down and the result.
5. Compare
The two pre-tax results and the gap explained line by line, and net capitalized costs under each method.
6. Checks
Nine controls: each ledger rolled forward by two routes in each year, the gap explained in each year, the carry-forward to 2026, the same spending under both methods, and the inputs.

What the worked example returns

Measure, 2025 / 2026Value
Successful efforts DD&A$10,410,145 / $12,088,243
Full cost DD&A$16,045,902 / $19,116,819
Full cost ceiling$288,334,330 / $179,808,104
Full cost write-downnone / $25,049,175
Result before income tax, successful efforts$8,169,855 / $8,176,357
Result before income tax, full cost$17,534,098 / ($18,481,394)
Net capitalized costs, successful efforts$107,289,855 / $119,101,612
Net capitalized costs, full cost$194,654,098 / $179,808,104

The example is the book's fictional case, and every figure is a teaching assumption, not a market figure. Every check of the example reads PASS.

How to use it on your own figures

  1. Take production and year-end reserves by field from the signed reserve report, developed and undeveloped apart.
  2. Classify each cost of the year as the methods require: leases, seismic, delay rentals, dry holes, discoveries, suspended wells, development.
  3. Type the present value at 10 percent of proved reserves at SEC prices, without the cash flows of recorded retirement obligations, from the reserve report.
  4. Read the Checks tab before any figure: anything but ALL PASS means a cell to fix.

Rules described as read in November 2026 (FASB ASC Topic 932, SEC Regulation S-X Rule 4-10). Education only, not accounting, engineering or audit advice: your company's facts govern, and its accountants, reserve engineers and auditors decide.

Questions people ask

What does the model do?

For one producer with two proved fields over two years, it books the same spending under successful efforts and under full cost: costs expensed, the ledger by field, units-of-production depletion, unproved properties and suspended wells; the full cost pool, its amortization base with future development costs, and the ceiling test. It compares the two pre-tax results and explains the gap. Nine checks reach the key figures by two routes.

Which rules does it apply?

As read in November 2026: ASC 932 for successful efforts (leasehold depleted over total proved reserves, wells over proved developed reserves, exploratory dry holes and geological and geophysical costs expensed) and SEC Regulation S-X Rule 4-10 for full cost (one cost center, future development costs in the base, a ceiling at the 10 percent present value plus unevaluated costs).

What does it leave out?

The reserve valuation itself (you type the present value from your reserve report), income taxes, the ASC 360 impairment test of successful efforts fields, more than two fields or one cost center, the standardized measure and the other disclosures. The book's full workbook covers most of them on one case.

Can I rely on it for a filing?

No. It is built to check a first pass and to learn the mechanics. The figures belong to your company, its reserve engineers, its accountants and its auditors.

Is this model really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbook of The Oil and Gas Accounting Handbook goes further: the reserves roll-forward, the reserve valuations year by year, the impairment test of each field, asset retirement obligations, the standardized measure and its changes, the disclosure tables and an operator month.

See the book and its free files →

Related reading