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.
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.
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.
Six tabs. Inputs are blue on yellow cells; everything else is a formula; the Checks tab shows one status, ALL PASS or FAIL.
| Measure, 2025 / 2026 | Value |
|---|---|
| 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-down | none / $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.
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.
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.
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).
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.
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.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
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.