How to Calculate Inventory Value: FIFO, LIFO and Weighted Average
Metrics · 8 min read
Nothing you paste is stored.
The scan could not run.
A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. The full product connects to your POS and store and runs this continuously.
To calculate inventory value, multiply the quantity of each item on hand by its unit cost, then add every line together. The judgment call is which unit cost to use when you bought the same item at different prices over time, and that is decided by your costing method: FIFO (first in, first out), LIFO (last in, first out) or weighted average cost. All three value the same physical stock differently, so the method you pick changes your reported inventory value, your cost of goods sold and your taxable profit. Most US businesses use FIFO or weighted average; whichever you choose, apply it consistently, because switching methods mid-stream distorts the comparison from one period to the next.
Inventory value is not just a bookkeeping number. It sits on your balance sheet as an asset, it drives cost of goods sold on your income statement, and it decides how much cash is locked in stock. Getting it right is the difference between knowing your real margin and guessing at it.
What is inventory value?
Inventory value is the total cost of all the goods you are holding to sell, measured at what you paid for them, not what you will sell them for. It is recorded at cost under standard US accounting, and it appears as a current asset on the balance sheet. The figure matters because it feeds two others: the cost of goods sold you expense when items sell, and the working capital tied up in stock at any moment. A clear read on that second number is the whole point of watching inventory carrying cost.
How do you calculate inventory value?
Take the quantity on hand for each SKU, multiply by its unit cost, and sum across every SKU. If you bought a SKU at one steady price, that is the whole calculation. The complication is real inventory: you buy the same item repeatedly at prices that move, so at any moment your on-hand units were bought at a mix of costs. The costing method decides which of those costs you assign to the units still on the shelf.
A worked example
Say you bought 100 units at $10 in January and 100 units at $14 in March, then sold 120 units. You have 80 units left. Under FIFO, the 120 you sold are the oldest first, so the 80 remaining are the newest, valued at $14 each: inventory value is $1,120. Under LIFO, the 120 sold are the newest first, so the 80 remaining are the oldest, valued at $10 each: inventory value is $800. Under weighted average, every unit is valued at the blended cost of $12 ($2,400 spent on 200 units), so 80 units are worth $960. Same physical stock, three different values.
FIFO vs LIFO vs weighted average
The three methods differ only in which cost they attach to units sold versus units held. Here is how they compare on the points that matter for a US business.
| Method | Units sold valued at | Effect when costs are rising | Notes |
|---|---|---|---|
| FIFO | Oldest costs first | Lower COGS, higher profit, higher ending inventory value | Most common; matches how most goods actually flow |
| LIFO | Newest costs first | Higher COGS, lower profit, lower taxable income | Allowed under US GAAP and IRS rules, but banned under IFRS; rarely used outside the US |
| Weighted average | Blended average cost | Smooths price swings; sits between FIFO and LIFO | Simplest to run at scale; common in software |
When prices are rising, FIFO reports a higher inventory value and higher profit, while LIFO reports lower profit and so a lower tax bill. That tax effect is the main reason a US business would choose LIFO, but it is banned under international standards, so companies that report globally avoid it. Weighted average is the pragmatic middle and the easiest to automate across thousands of SKUs.
Why does inventory value matter for your business?
Because it flows straight into the numbers you run the business on. Ending inventory value sets your cost of goods sold, which sets gross margin. It is the largest current asset on many balance sheets, so it shapes how lenders and buyers read the company. And it is a direct measure of cash you cannot spend until the stock sells. When you value inventory accurately, the figure flows cleanly onto your financial statements and your margin stops being a guess.
How often should you value inventory?
At minimum at each period close for your financial statements, but a perpetual system that updates value on every receipt and sale gives you the number any day you need it. The gap between the two approaches is the gap between finding out your true stock position once a quarter and knowing it continuously. Continuous valuation also makes ratios like inventory turnover and days of inventory on hand trustworthy, because they depend on an accurate average inventory value.
From value to decision
Knowing what your inventory is worth is the start; the payoff is using it to hold less of the wrong stock. The SKUs carrying the most value are the ones where a costing error or a slow-moving pile hurts most, so they deserve the tightest review. Feeding an accurate per-SKU value into inventory control software is what turns a static balance-sheet number into a live signal about which stock to reorder and which to clear.
To see which SKUs are holding the most value and moving the slowest right now, paste your stock and sales into the live stock scan at the top of the site. It returns per-SKU verdicts on cover and slow movers, so the stock quietly locking up the most cash is the first thing you see.
See this math run itself
The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.
Run the stock scanMore from the stockroom
- Working capital GMROI: Formula, Benchmarks and How to Improve It
- Practice ABC vs XYZ Analysis: The Difference and How to Combine Them
- Working capital How to Value Inventory for Taxes: Methods, Rules and COGS
- Practice Consignment Inventory: How It Works, Pros and Cons, and the Accounting
- Practice Par Level Inventory: What It Is and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT): How It Works and When to Use It
- Practice Min/Max Inventory: How the System Works and How to Set Levels
- Lost sales How to Avoid Stockouts: 7 Ways to Stop Running Out of Stock
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Practice How to Do a Physical Inventory Count (Step by Step)
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How to Forecast Inventory Demand (Methods and a Practical Process)
- Metrics How to Calculate Inventory Turnover (Formula, Example, Days)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Inventory KPIs: The 7 Metrics That Actually Matter
- Metrics Days of Inventory on Hand (DIO): Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization: Techniques to Cut Stock Without Stocking Out
- Practice Perpetual vs Periodic Inventory: Which System to Use and How COGS Differs
- Working capital Inventory Shrinkage: Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost: Formula, Percentage and How to Lower It
- Practice Cycle Counting: What It Is, Methods and How Often to Count
- Metrics ABC Analysis in Inventory Management: Formula, Classes and a Worked Example
- Metrics Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ): The Formula and When to Trust It
- Practice Inventory Management in Excel: How to Build It, and When to Stop
- Formulas Safety Stock: What It Is and How to Calculate It
- Formulas Reorder Point Formula: How to Calculate When to Reorder
- Working capital Dead Stock: Why It Happens and How to Clear It
- Lost sales Stockouts: The True Cost of Running Out