Inventory valuation calculator
Under FIFO the oldest stock is used first, so what is left is valued at the newest prices. Under weighted average, every unit is valued at the average cost of all lots.
Your result
- Result
- Press "Work it out" to see it here.
These are your own figures. We show no market averages.
Zentaro Serve free calculator: https://serve.zentaro.cloud/tools/inventory-valuation-calculator. Worked out in the browser. The numbers you typed were not sent to us. If you agreed to measurement, we count only that a calculator was used.
The problem this solves
You need to know what your stock is worth on a given day.
Stock sits on shelves as money you cannot spend.
This adds up each item at its cost.
How to use it
- List each item you hold in stock.
- Type its quantity and its unit cost.
- Press "Work it out" to see the value of each item and the total.
The formula
FIFO closing value = the quantity in stock, taken from the newest lot backward, at each lot's cost. Weighted average cost = total cost of all lots ÷ total quantity. Average closing value = average cost × quantity in stock. Cost of stock used = total cost of all lots − closing value.
A worked example (made-up numbers)
- You bought 10 units at ₹100, then 10 at ₹120, then 10 at ₹140. You count 15 units in stock.
- FIFO: the 15 left are the newest. 10 × 140 + 5 × 120 = ₹2,000.
- Weighted average: total cost 3,600 ÷ 30 units = ₹120 a unit. 15 × 120 = ₹1,800.
- Cost of stock used: FIFO 3,600 − 2,000 = ₹1,600. Average 3,600 − 1,800 = ₹1,800.
What this does not cover
- The lots and prices above are made-up examples. List your own, oldest first.
- Put opening stock in as the first lot, with its cost.
- It values one item at a time. For many items, do each one, or use stock software.
- Which method you use for your accounts is a choice to make with your accountant. This tool only shows both sums.
- It does not write down spoiled stock. Take wastage off the quantity you count.
Questions about this calculator
What does FIFO mean?
First in, first out. The oldest stock is used first, so the stock still in the store is the newest.
Why do the two methods differ?
Prices move. When prices rise, FIFO values what is left higher than the average does. When prices fall, it is the other way round.
Which method should I use?
Ask your accountant. Either way, use the same method every month so the months can be compared.
What if I have more stock than the lots add up to?
Add the missing lot, such as opening stock. The tool will not accept a stock count above what you bought.
Is my data saved?
No. The sum runs in your browser. Nothing you type is sent to us, and there is no sign-up.
Keep going
More calculators: Food cost calculator · Recipe cost calculator · Restaurant profit calculator · Break-even calculator · Reorder point calculator · Food wastage calculator · Menu engineering calculator · Labour cost calculator · Delivery order profit calculator
Want these numbers without the typing?
Zentaro Serve launches in 2027. It keeps your sales, stock and recipes in one place. Tell us what you run today and we will get in touch.