Skip to content
Allin
Sign up · Sign in

FIFO and LIFO inventory calculator

Value inventory and cost of goods sold three ways at once — FIFO, LIFO and weighted average. Add each purchase batch with its quantity and unit cost, enter the units sold, and it computes the COGS, ending inventory value and units on hand under all three methods so you can compare their profit impact side by side.

Related tools

All Planning & operations tools →
Inventory period calculatorDays Inventory Outstanding — how long stock sits before it sells: average inventory ÷ cost of goods sold × days, or simply days ÷ inventory turnover if you already know the ratio. Lower is faster turnover and better cash flow.Inventory shrinkage calculatorMeasure inventory shrinkage as a percentage and value from book vs counted stock.Inventory turnover calculatorCompute inventory turnover and days of inventory from COGS and average stock.Average collection period calculatorHow many days, on average, it takes to collect payment after a credit sale: average receivables ÷ net credit sales × days in the period. A lower number means faster cash collection and healthier cash flow.Capacity utilization calculatorCompute how much of your production capacity is actually being used.Capital employed calculatorCapital employed — the total capital a business uses to generate profit — by any of the three standard methods: total assets minus current liabilities, non-current assets plus working capital, or equity plus non-current liabilities. Add operating profit (EBIT) and it also returns the ROCE.Cost of goods sold (COGS) calculatorCompute cost of goods sold from beginning inventory, purchases and ending inventory.Current ratio calculatorCompute the current ratio from current assets and current liabilities.

Open FIFO and LIFO inventory calculator and you get an answer straight away, with no account to create. You will find it under Planning & operations, with Inventory period calculator and Inventory shrinkage calculator for the neighbouring cases.

How to use it

  1. Open the tool — no signup or install needed.
  2. Enter your input or adjust the available options.
  3. Get your result instantly, then copy or download it.

Frequently asked questions

What is FIFO and LIFO inventory calculator?

Value inventory and cost of goods sold three ways at once — FIFO, LIFO and weighted average. Add each purchase batch with its quantity and unit cost, enter the units sold, and it computes the COGS, ending inventory value and units on hand under all three methods so you can compare their profit impact side by side.

What does a concrete case look like?

100 @ 10 + 100 @ 12, −150 → FIFO 1 600, LIFO 1 700 — the tool shows every step in between, not just the final figure.

When would I actually use this?

Running the week: issuing an invoice or a quote, knowing what is in stock and what to reorder, and seeing whether cash covers what is due.

What is the most common mistake?

Reading profit as cash. A profitable month with sixty-day payment terms can still leave the account empty — the two numbers answer different questions.

How is FIFO and LIFO inventory calculator different from Inventory period calculator?

They sit next to each other but answer different questions: Inventory period calculator is the one to open when you need it to days Inventory Outstanding — how long stock sits before it sells: average inventory ÷ cost of goods sold × days, or simply days ÷ inventory turnover if you already know the ratio. Lower is faster turnover and better cash flow. Pick whichever matches what you're starting from — both are free.

Is there a tool for the next step?

Inventory shrinkage calculator is the closest one after this: Measure inventory shrinkage as a percentage and value from book vs counted stock.

Where do the figures come from?

The arithmetic is exact for what you enter. Invoice content, VAT treatment and mandatory mentions are set by national rules — an invoice that computes correctly can still be non-compliant.

Further reading

All guides →
ComparisonFIFO vs LIFO: What Actually Changes, and What Does NotFIFO and LIFO are assumptions about which cost you attach to a sale, not about which box leaves the warehouse. Worked through identical purchases and sales, they move cost of sales, inventory, profit and tax — but operating cash before tax is identical to the cent.ExplainerProcess Capability: Cp, Cpk and What Six Sigma Actually ClaimsCp compares the spec width to the process spread; Cpk penalises being off-centre. A process can have an excellent Cp and still make scrap — here is the case, with defect rates computed from the normal distribution rather than read off a table.ExplainerThe Cash Conversion Cycle: the Number That Explains Why You Are Out of CashCCC = DIO + DSO − DPO. It is the number of days your cash is out of your hands, and it is the reason a profitable, growing business runs out of money. Worked end to end, with the negative-cycle case that makes suppliers your cheapest lender.ExplainerAsset Turnover: Diagnosing Capital That Is AsleepNet sales divided by net fixed assets is one of the easiest ratios to compute and one of the least comparable. The same retailer scored 10× before the lease standard and 1.39× after it — same shops, same sales, same year.ExplainerGMROI: the Inventory Number That Outranks MarginGross margin return on inventory investment divides gross margin by the cash tied up in stock. It exists because margin alone ranks products wrongly: a 60% margin turning twice a year loses to a 25% margin turning twelve times.ExplainerReturn on Assets: What the Ratio Says About a Business, and What It HidesReturn on assets, return on net assets and return on capital employed are one family with two moving parts. On the same balance sheet they read 8.3%, 10.2% and 15.6% — and the two steps between them are exactly the two decisions you are making.