Dollar-Value LIFO Layer Calculator with Price Index

What do these figures come to once the work is shown?

Ending dollar-value LIFO inventory from the base-year layer, one prior layer and a current price index, including a new layer or a liquidation.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Ending dollar-value LIFO inventory
$261,900
Each layer carried at the index of the year it was added
Ending inventory at base-year prices
$257,143
New layer at current cost
$30,400
Drawn to one scale
Ending dollar-value LIFO inventory$261,900
Ending inventory at base-year prices$257,143
New layer at current cost$30,400
LIFO reserve (current cost less LIFO value)$26,100
All results
MeasureResult
Ending dollar-value LIFO inventory$261,900
Ending inventory at base-year prices$257,143
New layer at current cost$30,400
Layer movementNew layer added
LIFO reserve (current cost less LIFO value)$26,100
How this was worked out
Work shownrecomputed as you type
Ending inventory at base prices = ending cost / current index
If above prior layers: new layer = (increase at base prices) x current index
LIFO value = base layer + each layer x its index + new layer
If below prior layers: remove layers from the most recent

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Ending inventory at base prices = ending cost / current index
  • If above prior layers: new layer = (increase at base prices) x current index
  • LIFO value = base layer + each layer x its index + new layer
  • If below prior layers: remove layers from the most recent

How it works

Dollar-value LIFO treats the inventory pool as dollars of purchasing power. Ending cost is deflated to base-year prices with a price index. An increase becomes a new layer priced at the current index. A decrease removes the newest layers first.

This version handles the base layer, one earlier layer and one new year. Real pools with many layers need the full layer table carried forward. Choose and support the index method (for example an external index or double-extension) in your documentation.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

What is a liquidation?

When ending inventory at base prices falls below earlier layers, those layers are removed and older, lower costs flow to cost of goods sold.

Where does the index come from?

It is computed by the entity, for example by double-extension or from an external index. Document the method.

Why is LIFO value lower than current cost?

Older layers sit at older, lower prices. The gap is the LIFO reserve.

Formulas on this page are the standard definitions.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required