Asset Retirement Obligation Calculator (ASC 410-20)

Measures the initial ARO liability from an inflated settlement cost, then tracks it as layers — each revision carrying its own credit-adjusted risk-free rate — through accretion, asset retirement cost depreciation, and settlement gain or loss. Built for controllers and technical accounting staff in oil and gas, mining, utilities, and anyone with a leasehold restoration obligation, who currently rebuild this schedule by hand because no tool does the layering.

✓ Discounts upward revisions at the rate prevailing when the estimate changed, and downward revisions at the rate the original layer was measured at✓ Accretes each layer at its own rate rather than a single blended one✓ Prices what a one-rate schedule gets wrong, in both directions✓ Depreciates each revision's asset retirement cost over its own remaining life✓ Reproduces the standard published initial-measurement example exactly✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your own retirement obligations and rate history, and publish as a web tool using Sheetflow.

A Rate Per Layer, Not One Rate

Upward revisions are discounted at the rate prevailing when the estimate changed; downward revisions unwind at the rate the original layer was measured at. Each layer then accretes at its own rate. The blended 6.7133% is reported as an output, never taken as an input.

Both One-Rate Errors, Priced

Use the original rate on an upward revision and the liability is understated by $2,951.59 at the defaults. Use today's rate on a downward revision and it is cut $1,272.93 too far. Both errors flatter the balance sheet, which is exactly the bias an auditor looks for.

It Ties Back To The Obligation

Each layer accreted forward at its own rate reaches exactly its undiscounted amount — $163,343.01 in total at the defaults. If your schedule doesn't land on that figure, a rate or a period is wrong somewhere, and the reconciliation line tells you before the auditor does.

Frequently Asked Questions

How is an asset retirement obligation initially measured?

Two steps: inflate, then discount.

Start with what retirement would cost in today's money, apply an inflation rate over the years until settlement to get the expected future cash outflow, then discount that back at the credit-adjusted risk-free rate — a risk-free rate adjusted upward for your own credit standing, which is why two companies with identical obligations can carry different liabilities.

The calculator's defaults follow the standard published example. An $83,000 settlement cost inflated at 2% over 30 years becomes $150,343. Discounted at a 7% credit-adjusted risk-free rate, the initial liability is $19,750.

That same $19,750 is capitalized as asset retirement cost into the carrying amount of the related long-lived asset, then depreciated over the asset's useful life — $658.34 a year over 30 years here. So the obligation hits the income statement through two separate lines that behave differently: depreciation is flat, accretion compounds.

One classification point that trips people up, and it connects directly to interest capitalization. Accretion is an operating expense. It is not interest cost, it cannot be presented as interest expense, and under ASC 835-20-15-7 it cannot be included in capitalized interest. If you're also running a capitalized interest computation on the same construction project, accretion has no place in it.

How do revisions to an ARO estimate work?

Asymmetrically, and that asymmetry is the whole difficulty.

An upward revision is a new liability. The incremental cash flows are treated as a fresh ARO and discounted at the current credit-adjusted risk-free rate — the rate prevailing when the estimate changed, not the original one. It becomes a new layer on the schedule with its own rate.

A downward revision unwinds an existing layer. It's discounted at the rate that existed when the original liability was recognized. Where you can't identify which layer the reduction relates to, a weighted-average rate across layers is permitted.

The calculator carries three layers.

LayerRate appliedPresent valueBalance at year 12
Original7% (original)$19,750$41,571.10
Upward revision, year 3 ($25,000 undiscounted)5.5% (rate then prevailing)$5,583.05$9,039.48
Downward revision, year 8 ($12,000 undiscounted)7% (original rate)−$2,531.36−$3,318.10
Total liability$47,292.47

Note what a revision does not do: there's no immediate income statement impact in the period of change. It adjusts both the liability and the asset by the same amount, and only changes prospective accretion and depreciation.

Why can't I just use one discount rate for the whole obligation?

Because the standard tells you which rate applies to which movement, and getting it wrong misstates the liability in a way that compounds for decades.

The calculator prices both errors.

Using the original rate for an upward revision. Discounting the year-3 $25,000 increase at the original 7% instead of the prevailing 5.5% gives $3,760.06 instead of $5,583.05. By year 12 that understates the liability by $2,951.59. The direction is intuitive once you see it: rates fell, so the same future obligation is worth more today, and applying a stale higher rate makes it look smaller than it is.

Using today's rate for a downward revision. Discounting the year-8 $12,000 reduction at 5.5% instead of the original 7% cuts the liability by $1,272.93 more than permitted.

Here's the uncomfortable part. Both errors understate the liability. Standardize on the original rate and you understate the increase; standardize on the current rate and you over-credit the decrease. Whichever single rate you pick, the error flatters the balance sheet — which is exactly the kind of bias an auditor looks for.

The calculator also reports a blended accretion rate of 6.7133% at the defaults. That's an output, never an input: it's what falls out of accreting each layer at its own rate. Feeding a blended rate back in as an assumption is circular and wrong.

How is asset retirement cost depreciated after a revision?

Prospectively, with each layer on its own schedule over its own remaining life.

LayerAmountLife depreciated overAnnual depreciation
Original$19,75030 years (full useful life)$658.34
Upward layer, year 3$5,583.0528 years remaining$199.39
Downward layer, year 8−$2,531.3623 years remaining−$110.06
Total depreciation in year 12$747.67

That layered treatment follows the change-in-estimate rules — you adjust the amount allocated to expense in the period of change and future periods, without restating what's already been recorded.

Gross asset retirement cost at year 12 is $22,801.81, accumulated depreciation is $9,343.70, and the net carrying amount is $13,458.11.

Worth watching the divergence between the two sides. The liability is $47,292.47 and climbing at over 6.7% a year; the asset is $13,458.11 and falling on a straight line. They start equal and end far apart, because accretion compounds while depreciation doesn't. That gap is not an error — it's the design — but it surprises people reading the schedule for the first time, and it's why the balance sheet presentation needs explaining in the footnotes.

What happens when the obligation is finally settled?

The liability should have accreted to exactly the undiscounted obligation, and the difference against what you actually pay is a settlement gain or loss.

The calculator verifies the first half arithmetically: each layer accreted forward at its own rate reaches exactly its undiscounted amount — $150,343.01 for the original, $25,000 for the upward layer, −$12,000 for the downward — totalling $163,343.01. If your schedule doesn't land on that figure, a rate or a period is wrong somewhere.

Against an actual settlement cost of $158,000, that's a $5,343.01 gain. Retirement came in under the accreted obligation, and the difference goes to the income statement in the period of settlement.

Two scope limits worth stating plainly.

Timing-only changes aren't modelled. ASC 410-20 gives no explicit guidance on remeasuring the liability when only the expected settlement date changes, with the amount unchanged. Companies adopt a policy and apply it consistently. This calculator handles changes in amount; if your settlement date moves, that's a judgement call to document, not an arithmetic one to look up.

Three layers is the practical limit here. A thirty-year obligation revised every few years accumulates more, and each carries its own rate and remaining life. The mechanics are identical, just repeated. If you're past three layers you need a schedule, not a calculator — but the rate discipline this tool demonstrates is exactly what that schedule has to get right.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes and do not constitute accounting, audit or legal advice. This calculator models up to three revision layers and does not remeasure the liability for changes in expected settlement timing alone, which is a policy judgement to document. Selection of the credit-adjusted risk-free rate, identification of which layer a downward revision relates to, and presentation in the financial statements depend on facts specific to each entity, and users should verify important results for their specific situations. No signup required. Calculations performed securely.