FIFO Calculator for Inventory

Estimate ending inventory value and cost of goods sold using the first-in, first-out method. This page also keeps the formula, examples, FAQs, and references close by so you can check the result with confidence.

What This FIFO Calculator for Inventory Helps You Do

FIFO assumes the oldest inventory units are sold first, so ending inventory comes from the newest layers. Review the formula and examples below if you want to see how the result is derived.

This page is meant to give you a fast answer, but it also helps you double-check the math before you make a decision. Start with the inputs that you already know, run the calculation, and then compare the output with the formula, examples, and FAQs below so you can see whether the answer fits the situation you are modeling.

If the result looks off, the usual causes are a unit mismatch, a missing decimal, the wrong scenario, or a value that needs to be entered as a rate instead of a total. The notes on this page are designed to make those checks easy without forcing you to leave the calculator and search for context elsewhere.

  • Use the calculator first for a quick estimate.
  • Use the formula to understand how the result is built.
  • Use the examples to compare common use cases.
  • Use the references when the answer depends on a standard or assumption.

Common Checks

A quick result is useful, but the best result is one that still makes sense when you look at it a second time. If you are comparing scenarios, try changing one input at a time so you can see which variable has the biggest impact on the final answer. That makes it much easier to spot whether the calculation matches your expectations.

It also helps to keep the context of the problem in mind. A calculator can tell you the math, but you still need to decide whether the input represents a total, a rate, an average, or a category-specific assumption. When in doubt, start with a simple example from the page and scale up from there.

  • Check that every unit matches the rest of the problem.
  • Keep rates, totals, and averages separate.
  • Adjust one variable at a time when testing scenarios.
  • Use the smallest realistic input first, then scale upward.

Scenario Planning

This calculator is especially useful when you want a quick answer before you commit time, money, or effort. Try one baseline input set, then change a single number and compare the result so you can see how sensitive the answer is to that variable.

That makes the page useful for more than just arithmetic. It becomes a small decision aid that helps you compare options, test assumptions, and explain the final number with confidence when you need to share it with someone else.

units
$
units
$
units
$
units

Result

--

Quick Answer: FIFO assumes the oldest inventory units are sold first, so ending inventory comes from the newest layers. Review the formula and examples below if you want to see how the result is derived.

How to Calculate FIFO Calculator for Inventory

  1. Enter purchase layers: Add up to three purchase batches with unit counts and costs.
  2. Enter units sold: The calculator removes the oldest inventory first.
  3. Review ending inventory: You will see ending inventory value and FIFO cost of goods sold.

FIFO Calculator for Inventory Formula

Ending inventory = total inventory value - FIFO cost of goods sold.
Variable Meaning Unit
q Units in each purchase batch units
p Unit price for each batch $
sold units Units sold during the period units

Worked Examples

USA - Three purchase layers
  • Sold: 150 units
  • Layer 1: 100 @ $10
  • Layer 2: 120 @ $12

Result: $1,500 ending value

The oldest stock is removed first, leaving newer inventory on hand.

UK - Higher replacement cost
  • Sold: 180 units
  • Layer 1: 100 @ £8
  • Layer 2: 100 @ £9

Result: Lower COGS than recent prices

FIFO often leaves a higher ending inventory during inflation.

EU - Small sale
  • Sold: 50 units
  • Layer 1: 60 @ €5
  • Layer 2: 40 @ €7

Result: Most old inventory remains

A small sale consumes only the earliest inventory layer.

How to Interpret Your Results

Range Meaning Action
Low ending inventory Most stock sold Review replenishment needs.
Moderate ending inventory Some older stock remains Compare against target stock levels.
High ending inventory Large stock on hand Check carrying cost and demand assumptions.

Frequently Asked Questions

FIFO means first-in, first-out: the oldest inventory is assumed to be sold first.

It outputs ending inventory value and the FIFO cost of goods sold.

Yes. It is a common inventory accounting method.
Planning note: Inventory accounting should follow your accounting policies and applicable standards.

References

Last reviewed: March 2026