With rising prices, FIFO gives a lower cost of goods sold and higher profit than LIFO, and an ending inventory close to current prices. FIFO is permitted under IFRS (LIFO is not) and is the most common method worldwide. Everything is calculated in your browser, so nothing you type is sent to our server.
How to use the FIFO Calculator for Inventory
- Method
- Units in each purchase (oldest first)
- Cost per unit of each purchase
- Units sold
- Selling price per unit
Everything runs in your browser, so results appear instantly and nothing you type is sent to a server.
How it works
Enter the units and unit cost of each purchase in date order (separate with commas), the units sold and the selling price.
Formula
FIFO: units sold are costed from the earliest purchases first
COGS = Σ (units taken from each lot × lot cost)
Ending inventory = total purchases − COGS
Gross profit = units sold × price − COGS
Worked example
Inputs: Method: FIFO – first in, first out; Units in each purchase (oldest first): 100, 150, 120; Cost per unit of each purchase: 10, 12, 13; Units sold: 260; Selling price per unit: $20.
Results: Units available = 370; Total cost of goods available = $4,360; Cost of goods sold = $2,930; Ending inventory value = $1,430; Units left = 110; Revenue = $5,200.
Frequently asked questions
What is FIFO?
First in, first out: the oldest stock is treated as sold first.
Is FIFO allowed under IFRS?
Yes; LIFO is not allowed under IFRS, only under U.S. GAAP.
Why does FIFO give higher profit when prices rise?
Older, cheaper stock is expensed first, lowering COGS.