🌐 EN

πŸ“¦ FIFO/LIFO Inventory Costing Calculator

Enter up to 3 purchase lots (quantity, unit cost) and units sold to compare cost of goods sold and ending inventory value under FIFO and LIFO.

Purchase Lots (enter oldest first)
FIFO
Cost of Goods Sold (COGS) β€” Ending Inventory Value β€”
LIFO
Cost of Goods Sold (COGS) β€” Ending Inventory Value β€”
Related Calculators Working Capital Calculator Contribution Margin Calculator Safety Stock Calculator Reorder Point Calculator EOQ Calculator Six Sigma Cpk Calculator
GUIDE

Learn more

01

FIFO vs. LIFO: What Is the Difference?

FIFO (First-In-First-Out) is a standard inventory costing method that assumes the oldest inventory is sold (expensed as COGS) first, while LIFO (Last-In-First-Out) assumes the most recently purchased inventory is sold first. For example, purchasing Lot 1 (100 units @ $10), Lot 2 (100 units @ $12), and Lot 3 (100 units @ $14) in that order, then selling 150 units: FIFO expenses all of Lot 1 (100 Γ— $10) plus part of Lot 2 (50 Γ— $12) as COGS = $1,600, leaving ending inventory of the remaining Lot 2 (50 Γ— $12) plus all of Lot 3 (100 Γ— $14) = $2,000. LIFO expenses all of Lot 3 (100 Γ— $14) plus part of Lot 2 (50 Γ— $12) as COGS = $2,000, leaving ending inventory of the remaining Lot 2 (50 Γ— $12) plus all of Lot 1 (100 Γ— $10) = $1,600.
02

Which Method to Use, and When

In a period of rising unit costs, FIFO tends to report lower COGS and a higher ending inventory value, which can make reported profit look larger; LIFO does the opposite and can reduce taxable income in jurisdictions where it is permitted (LIFO is not allowed under IFRS and has restrictions in some countries β€” always confirm which method your jurisdiction's accounting standards permit before using this for actual financial reporting; this tool is for learning and conceptual comparison).

MethodCOGSEnding Inventory
FIFO1,6002,000
LIFO2,0001,600

Frequently asked questions

Does FIFO or LIFO match the actual physical flow of goods?
Neither has to. These are accounting cost-flow assumptions, independent of physical movement β€” though perishable goods are often physically managed FIFO-style in practice.
Why does the calculator only support 3 lots?
This is a simplified tool for learning and conceptual comparison. Real inventory management systems track unlimited purchase history.
What happens if units sold exceeds total units purchased?
The calculator shows a warning and caps the calculation at the total quantity actually purchased, since you cannot sell more than you have in stock.