Free inventory valuation calculator for 2026: enter beginning inventory and purchases, see COGS and ending inventory under FIFO, LIFO and weighted average cost side by side, layer by layer, with gross profit, LIFO reserve and the cash-tax difference between methods.
Enter beginning inventory as the first layer, then each purchase in date order with its units and unit cost (up to eight layers). The running total shows units available, cost of goods available and the weighted average cost.
Enter the units sold during the period. If you enter more than were available the calculator says how many units cannot be costed, which usually means a purchase is missing.
Optionally add the selling price per unit and your income tax rate. The price adds gross profit and margin for each method; the rate shows the cash-tax difference between FIFO and LIFO.
Read the comparison table: cost of goods sold, ending inventory and cost per unit sold under FIFO, LIFO and weighted average side by side, with the FIFO − LIFO gap and the LIFO reserve. Pick a method to see exactly which layers it consumes.
Links from the old FIFO, LIFO and weighted average pages land here with that method shown first.
The three methods split the same pool of cost between what was sold and what is still on the shelf; they differ only in which costs they assume left first. On the calculator's example (100 at $10.00, 150 at $12.00, 120 at $13.50; 260 sold) FIFO charges $2,935.00 to COGS, LIFO $3,300.00 and weighted average $3,105.95, and the ending inventory moves the other way by the same amounts. Because costs usually rise, FIFO shows the highest profit and the most valuable inventory, LIFO the lowest profit and the lowest tax, and weighted average sits between them. This page uses the periodic method: one calculation for the period, which is what the IRS and most small-business accounting software do at year end.
100 × $10.00 + 150 × $12.00 + 120 × $13.50 = $4,420.00 available. FIFO COGS 100 × $10.00 + 150 × $12.00 + 10 × $13.50 = $2,935.00, ending $1,485.00. LIFO COGS 140 × $12.00 + 120 × $13.50 = $3,300.00, ending $1,120.00. Weighted average $4,420.00 ÷ 370 = $11.95; COGS $3,105.95, ending $1,314.05. LIFO reserve $365.00.
FIFO: 100 × $10 + 100 × $12 = $2,200.00, ending 50 × $12 = $600.00. LIFO: 150 × $12 + 50 × $10 = $2,300.00, ending 50 × $10 = $500.00. Weighted average $2,800 ÷ 250 = $11.20; COGS $2,240.00, ending $560.00.
200 × $48 + 300 × $42 + 250 × $39 = $31,950.00; 560 sold at $79. FIFO COGS $24,540.00 (gross profit $19,700.00), LIFO COGS $22,830.00 (gross profit $21,410.00), average COGS $23,856.00. With deflating costs FIFO now shows the lower profit and LIFO the higher, so the usual "LIFO saves tax" rule reverses; the LIFO reserve is negative (-$1,710.00).
| Method | Layers charged to COGS | COGS | Ending inventory | Gross profit | Income tax |
|---|---|---|---|---|---|
| FIFO | 100 × $10.00 + 150 × $12.00 + 10 × $13.50 | $2,935.00 | $1,485.00 | $3,305.00 (53.0%) | $694.05 |
| LIFO | 140 × $12.00 + 120 × $13.50 | $3,300.00 | $1,120.00 | $2,940.00 (47.1%) | $617.40 |
| Weighted average | 260 × $11.95 | $3,105.95 | $1,314.05 | $3,134.05 (50.2%) | $658.15 |
Revenue is $6,240.00 in every row; only the cost split changes. LIFO reserve $365.00; LIFO saves $76.65 of tax this period versus FIFO at 21%, a timing difference that reverses if the inventory is ever drawn down.
| FIFO | LIFO | Weighted average | |
|---|---|---|---|
| Assumes you sell | Oldest units first | Newest units first | A blend of all units |
| When costs rise: COGS / profit | Lowest / highest | Highest / lowest | In between |
| When costs rise: ending inventory | Highest (recent costs) | Lowest (old costs, can be decades old) | In between |
| Matches physical flow of most goods | Yes | Rarely | Partly |
| Allowed under US GAAP / US tax | Yes / yes | Yes / yes, with a Form 970 election and the conformity rule | Yes / yes |
| Allowed under IFRS | Yes | No | Yes |
| Typical users | Most businesses, perishables, fashion | US retailers, auto dealers, oil & gas, metals | Commodities, bulk goods, fuel, businesses with many identical SKUs |
Inventory accounting never asks which physical box left the warehouse; it asks which cost should leave the balance sheet. The example buys 100 units at $10.00, 150 at $12.00 and 120 at $13.50 and sells 260. FIFO sends the two oldest layers and 10 units of the newest to cost of goods sold, $2,935.00, leaving 110 units on the shelf at $13.50 each ($1,485.00). LIFO sends the newest layer first: $3,300.00 to COGS and an ending inventory of $1,120.00 made of the $10.00 and $12.00 units. Weighted average prices everything at $11.95: $3,105.95 sold, $1,314.05 left.
The gap matters because it goes straight to profit and tax. At a $24.00 selling price the gross profit is $3,305.00 under FIFO and $2,940.00 under LIFO, a $365.00 difference, worth $76.65 of tax at 21%. That saving is a deferral, not a gift: the cheap old layers are still on the balance sheet, and the day the business sells more than it buys (a "LIFO liquidation") those old costs flow through COGS and the deferred profit is taxed.
FIFO is the default for most businesses because it follows the physical flow of goods, produces an ending inventory close to current replacement cost, and is accepted everywhere. LIFO is a US tax strategy for businesses with large, slow-turning, steadily inflating inventories; it must be elected on IRS Form 970, used in the financial statements too (the conformity rule), and is not permitted under IFRS, which is why foreign-owned or dual-reporting companies avoid it. Weighted average suits fuel, grain, chemicals and any stock where units are interchangeable and purchases frequent.
The method is not a dial to turn each year: changing it is a change in accounting method that needs IRS consent (Form 3115) and restatement in the financials. Run both directions through the calculator before choosing. When costs fall, the ranking flips — in the falling-cost example below FIFO charges $24,540.00 to COGS against LIFO's $22,830.00, so FIFO reports the lower profit.
Find answers to the most common questions about inventory valuation calculator.
Both split the cost of goods available between cost of goods sold and ending inventory; FIFO assumes the oldest costs are sold first, LIFO the newest. On the example above, FIFO's COGS is $2,935.00 and LIFO's $3,300.00, so with rising costs LIFO reports $365.00 less profit and leaves $365.00 less inventory on the balance sheet. The physical goods are identical; only the cost assigned to them differs.
Divide the total cost of goods available by the total units available: $4,420.00 ÷ 370 = $11.95 per unit in the example. COGS is units sold × that average ($3,105.95) and ending inventory is units left × the average ($1,314.05). This is the periodic version; a perpetual "moving average" recomputes the average after every purchase and gives slightly different figures when sales happen between purchases.
When costs are rising, LIFO: it charges the newest, most expensive units to COGS, so profit and tax are lower now. The example saves $76.65 at a 21% rate. It is a deferral rather than a permanent saving, it requires an IRS election (Form 970) and the same method in your financial statements, and it is not allowed under IFRS. When costs are falling the result reverses and FIFO produces the lower tax.
The difference between what inventory would be worth under FIFO and what it is carried at under LIFO: $365.00 in the example. Companies that use LIFO disclose it so readers can compare them with FIFO users; a growing reserve is deferred profit that has not yet been taxed, and a shrinking one (a LIFO liquidation) means old low-cost layers are flowing through COGS and boosting reported profit.
Yes, but it is a change in accounting method: for US tax you file Form 970 to adopt LIFO and Form 3115 to change methods, and the financial statements must be restated or disclosed. Businesses normally choose once and stay. Use the calculator to compare the methods on a typical year before deciding, and remember that LIFO must then be used for financial reporting as well (the conformity rule).
Because every method is dividing one fixed amount — the cost of goods available, $4,420.00 here — between the income statement and the balance sheet. Whatever a method puts into COGS it takes out of ending inventory, which is why the calculator shows the two moving in opposite directions by exactly the same amount.
It uses the periodic method: one calculation for the whole period, which is what most small businesses and tax returns use. Under a perpetual system FIFO gives the same answer, LIFO and weighted average can differ because they depend on the timing of each sale. Specific identification (tracking the actual cost of each serial-numbered item), the retail method and lower-of-cost-or-net-realizable-value write-downs are not modeled.
They are this page. Their links redirect here and show that method first; the layer table under the result reproduces exactly what each single-method page used to compute, now from up to eight purchase layers instead of two.
The figures and rules behind this calculator come from the publications below. Each link goes to the issuing agency, so you can check the current rate yourself.
Internal Revenue Service — Permitted inventory valuation methods (FIFO, LIFO, specific identification)
Internal Revenue Service — Beginning inventory + purchases - ending inventory
Results are estimates for planning and double-checking, not tax, legal or payroll advice. How we choose sources, how often rates are updated and how to report an error: editorial policy.
Enter beginning inventory and each purchase in date order, then the units sold in the period. The calculator values cost of goods sold and ending inventory under FIFO, LIFO and weighted average cost (periodic) side by side, and shows which layers each method consumes.
| Layer (oldest first) | Units | Unit cost | Layer cost | |
|---|---|---|---|---|
$ | $1,000.00 | |||
$ | $1,800.00 | |||
$ | $1,620.00 |
Adds gross profit and margin by method
Shows the cash-tax difference between methods
Cost of goods sold — FIFO (first in, first out)
$2,935.00
ending inventory $1,485.00 (110 units) · $11.29 per unit sold · gross profit $3,305.00 (53.0%)
| Method | COGS | Ending inventory | Cost / unit sold | Gross profit | Income tax |
|---|---|---|---|---|---|
| FIFO (first in, first out) | $2,935.00 | $1,485.00 | $11.29 | $3,305.00 (53.0%) | $694.05 |
| LIFO (last in, first out) | $3,300.00 | $1,120.00 | $12.69 | $2,940.00 (47.1%) | $617.40 |
| Weighted average cost | $3,105.95 | $1,314.05 | $11.95 | $3,134.05 (50.2%) | $658.15 |
FIFO − LIFO COGS
-$365.00
LIFO reserve (FIFO − LIFO ending)
$365.00
Unit costs are
rising
LIFO cash-tax saving vs FIFO
$76.65
| Layer | Units | Unit cost | Sold | → COGS | Left | → Ending |
|---|---|---|---|---|---|---|
| Beginning inventory | 100 | $10.00 | 100 | $1,000.00 | 0 | $0.00 |
| Purchase 1 | 150 | $12.00 | 150 | $1,800.00 | 0 | $0.00 |
| Purchase 2 | 120 | $13.50 | 10 | $135.00 | 110 | $1,485.00 |
With rising costs, LIFO reports the highest COGS and lowest profit, FIFO the lowest COGS and the highest ending inventory. LIFO is allowed for US tax (IRS Form 970 election, conformity rule) but not under IFRS. Specific identification, retail method and lower-of-cost-or-market write-downs are not modeled.