Free tools · Inventory valuation calculator
Free calculator

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 numbers

The boxes start with an example. Replace it with your own numbers.

Purchase lots, oldest first (include opening stock as the first lot)

Count the stock. Use the same unit as the lots, such as kg.

The sum runs in your browser and the numbers you type are not sent to us. If you agreed to measurement, we count only that a calculator was used, never what you typed. A copied link holds only the numbers in the boxes.

Your result

Result
Press "Work it out" to see it here.

These are your own figures. We show no market averages.

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

  1. List each item you hold in stock.
  2. Type its quantity and its unit cost.
  3. Press "Work it out" to see the value of each item and the total.

Embed this calculator

Show this calculator on your own website. Paste this code into your page. It shows the same boxes and the same sum, with a small link back to Zentaro Serve. It needs no sign-up.

Preview the embed

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)

  1. You bought 10 units at ₹100, then 10 at ₹120, then 10 at ₹140. You count 15 units in stock.
  2. FIFO: the 15 left are the newest. 10 × 140 + 5 × 120 = ₹2,000.
  3. Weighted average: total cost 3,600 ÷ 30 units = ₹120 a unit. 15 × 120 = ₹1,800.
  4. 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.

Formula version 1.2. Last reviewed 18 November 2026. This is a guide, not financial or tax advice.

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.

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.

Talk to us Join the early access list

Pricing is coming soon

We are keeping pricing simple. We will share it when Zentaro Serve launches in 2027. Join early access and we will tell you first.