Accounting & Financial Statement Analysis Activity, Turnover & Cash Conversion Cycle US GAAP ASC 330 / IFRS IAS 2 · 365-day convention

Inventory Turnover Ratio Calculator

Inventory turnover counts how many times a year you sell and replace your entire stock. Enter cost of goods sold and the opening and closing inventory balances, and this calculator returns the turnover ratio, the average inventory behind it, days inventory on hand, the gross margin every dollar of stock earns, and the annual cost of simply owning the warehouse. One day of inventory is worth exactly one day of cost of sales, so the calculator also prices what taking a week off the shelf releases in cash.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Cost of goods sold for the periodThe cost-of-sales line from the income statement for the same period the inventory balances come from — not revenue.7800000 $
Beginning inventoryTotal inventory at cost on the balance sheet at the start of the period: raw materials, work in progress and finished goods.1200000 $
Ending inventoryTotal inventory at cost at the close of the same period, valued on the same cost-flow basis.1400000 $
Days in the periodMatch this to the period your cost of goods sold figure covers, or days on hand will be wrong by that ratio.365 — full year
Inventory balance to useAnalysts average the two balances; buyers often use the closing balance so the ratio reacts this month.Average of beginning and ending
Revenue for the same periodNet sales for the same period, used only to work out gross margin return on inventory investment.12000000 $
Annual inventory carrying costCapital, storage, handling, insurance, tax, shrink and obsolescence as a percent of inventory value; 18% to 30% is the usual range.22 % / yr

It returns

  • Inventory turnover — How many times the average stock on hand was sold and replaced during the period.
  • Days inventory on hand
  • Average inventory at cost
  • Cost of sales per day — The cash value of one day of stock — the exchange rate between days and dollars.
  • GMROI — gross margin per $1 of inventory
  • Annual cost of holding the stock

The formula

Tinv=COGS(I0+I1)/2
Days on hand=DTinv=I¯DCOGS
GMROI=RevenueCOGSI¯

In plain text: Inventory turnover = Cost of goods sold ÷ Average inventory

  • TᵢₙᵥInventory turnover for the period (times)
  • COGSCost of goods sold for the period, at cost ($)
  • I₀Inventory at cost at the start of the period ($)
  • I₁Inventory at cost at the end of the period ($)
  • DDays in the period — 365, 360, 91 or 30 (days)

Both halves must be measured at cost and must cover the same period and the same entity. Inventory includes raw materials, work in progress and finished goods, valued under whichever cost-flow assumption the company applies.

Updated Category Activity, Turnover & Cash Conversion Cycle Verified against published test cases Reading time 12 min

What inventory turnover actually measures

Inventory turnover counts how many times you sell and rebuild your whole stock in a period. A turnover of 6 means the average item you bought sat in the warehouse for one-sixth of a year — about 61 days — before it left as a sale. The ratio is a velocity, not a size: a $50m distributor can turn faster than a $5m one, and usually does, because scale buys tighter replenishment.

Velocity matters because inventory is cash in a box. Every dollar of stock is funded by equity or by a revolver you pay interest on, and interest is the small part of what it costs to keep. Add storage, handling, insurance, personal property tax, shrink, and the item that dominates in most businesses — obsolescence. Practitioners size total carrying cost at roughly 18% to 30% of inventory value a year, so a distributor holding $1.3m of stock spends about $286,000 a year simply to own it.

Four groups read the ratio for different reasons. Merchants pair it with margin to judge whether a line earns its shelf space. Operations treat it as the scoreboard for replenishment and lead-time discipline. Lenders read a book that turns slower each year as stock that will be written down, and haircut it in the borrowing base. Analysts feed it into total asset turnover and into the cash conversion cycle.

The formula explained variable by variable

You divide cost of goods sold by average inventory. Both halves must be measured at cost, and both halves have a trap in them.

The numerator is COGS, not revenue. Inventory sits on the balance sheet at cost, so the flow that drains it has to be measured at cost too. Using revenue overstates turnover by exactly 1 ÷ (1 − gross margin): at a 35% gross margin, revenue divided by inventory is 1.54 times the true ratio. If you only have purchases and inventory movements, build the cost figure first with the cost of goods sold calculator.

The denominator is a stock, so it needs averaging. COGS accrues across 365 days; an inventory balance exists at one instant. The convention averages opening and closing balances, which works for a steady business and fails badly for a seasonal one: a toy distributor whose October inventory runs four times its February inventory gets a two-point average that describes neither month. Where you have monthly closes, average all 13 month-end balances. Note too that retailers with a January year-end close deliberately after the season, when stock is lowest, which flatters the ratio for reasons unconnected to efficiency.

Include everything that is inventory. Raw materials, work in progress and finished goods all belong in the denominator, because all three consume cash and all three are relieved through cost of sales. Leave out supplies you expense as incurred and consignment stock you do not own. And match the day count to the numerator: quarterly COGS against 365 days makes days on hand four times too long.

Watch the cost-flow assumption. Under LIFO with rising costs, ending inventory is carried at old, low prices, which shrinks the denominator and inflates turnover against an otherwise identical FIFO competitor. The FIFO valuation calculator shows how the same purchases split differently between the balance sheet and the income statement under each cost-flow assumption.

Worked example: a wholesale distributor with $7.8m of cost of sales

A distributor reports cost of goods sold of $7,800,000 on revenue of $12,000,000. Inventory was $1,200,000 at January 1 and $1,400,000 at December 31. Take carrying cost at 22% a year.

  1. Average the inventory. ($1,200,000 + $1,400,000) ÷ 2 = $1,300,000.
  2. Divide cost of sales by that average. $7,800,000 ÷ $1,300,000 = 6.0 turns.
  3. Convert to days. 365 ÷ 6.0 = 60.8 days on hand.
  4. Find one day of cost of sales. $7,800,000 ÷ 365 = $21,370 per day. This is the exchange rate between days and dollars, and it is the most useful number on the page.
  5. Check it the other way. $1,300,000 ÷ $21,370 = 60.8 days. The two routes always agree.
  6. Price the margin the stock earns. Gross margin is $12,000,000 − $7,800,000 = $4,200,000, so GMROI = $4,200,000 ÷ $1,300,000 = 3.23.
  7. Price the holding. $1,300,000 × 22% = $286,000 a year to own the stock — 6.8% of the entire gross margin.

Now test an improvement. Taking 10 days off the shelf moves days on hand to 50.83, raising turnover to 365 ÷ 50.83 = 7.18 turns and cutting average inventory by 10 × $21,370 = $213,700. That is a one-off cash release that stays released, plus about $47,000 a year of carrying cost you stop paying, plus a GMROI that rises to $4,200,000 ÷ $1,086,300 = 3.87. Nothing on the income statement changed. Only the speed did.

How to read the result: what counts as good

No universal target exists, because turnover is set mostly by what you sell. Judge yours against three yardsticks, in this order.

Against your own trend. This needs no external data and it is the most reliable signal on the page. Turnover falling while revenue grows means inventory is growing faster than sales, the classic precursor of a write-down. Three consecutive quarters of decline deserve a SKU-level aging report, not an explanation.

Against your sector. The reference table below gives the usual ranges: 25 to 40 turns in perishable food, the teens and twenties in grocery and fuel, 4 to 8 in industrial distribution, and 1 to 3 in machinery, furniture and jewellery, where margins are set to compensate for the slowness. A jeweller turning 1.5 times a year is normal; a grocer turning 1.5 times a year has spoiled stock.

Against margin, using GMROI. Turnover alone rewards cheap fast-moving goods and punishes profitable slow ones. Because annual cost of sales equals turnover times average inventory, GMROI reduces to turnover × gross margin ÷ (1 − gross margin). A 40%-margin line turning three times returns 3 × 0.40 ÷ 0.60 = 2.0; a 12%-margin line turning ten times returns 10 × 0.12 ÷ 0.88 = 1.36. The slower, richer line is the better use of the shelf, and turnover alone would have ranked it last. Retail buyers commonly treat a GMROI of 3.0 as the floor for a line that pays its way, though your real threshold is set by occupancy and labour cost.

Beware of turnover that is too high. Past a point, speed becomes stockouts: expedited freight, split shipments, back orders and lost sales that appear in no ratio at all. If turnover rises while fill rate falls, you are converting inventory into service failures. Set the floor from lead time and demand variability with the safety stock calculator, not from a benchmark table.

Turnover, days on hand and inventory per $1m of cost of sales

Each row is one consistent picture of the same business on a 365-day year. The last column is the inventory you must fund for every $1,000,000 of annual cost of goods sold.
TurnoverDays on handWhere that is typicalInventory per $1m of COGS
36.5×10 daysFresh produce, bakery, restaurant kitchens$27,397
24.3×15 daysFuel retail, dairy, newspapers$41,096
12.2×30 daysPackaged grocery, fast fashion$82,192
8.1×45 daysConsumer electronics retail, auto assembly$123,288
6.1×60 daysIndustrial distribution, general merchandise$164,384
4.1×90 daysApparel retail, building products$246,575
3.0×120 daysMachinery dealers, furniture$328,767
2.0×180 daysJewellery, spirits, aerospace spares$493,151

Turnover = 365 ÷ days on hand. Inventory per $1m = days on hand × ($1,000,000 ÷ 365) = days × $2,739.73. The sector column is a practitioner rule of thumb, not survey data — verify against your own peers. Moving from 90 days to 60 releases about $82,000 of cash for every $1m of cost of sales, permanently.

Which standard governs the inventory figure

Inventory measurement sits in FASB ASC Topic 330 under US GAAP and in IAS 2 under IFRS. Both carry inventory at the lower of cost and net realisable value, with US GAAP retaining the older lower-of-cost-or-market test for LIFO and retail-method inventories. The difference that matters here is that LIFO is permitted under US GAAP and prohibited under IAS 2. A US filer on LIFO in an inflationary period shows a smaller inventory balance, and therefore a higher turnover, than an identical IFRS competitor — purely because of the accounting election, so add back the disclosed LIFO reserve before comparing them. Take cost of goods sold from the face of the income statement, and check whether it carries freight-in or production depreciation.

Mistakes that make this ratio wrong

  • Using revenue instead of cost of goods sold. This inflates turnover by 1 ÷ (1 − gross margin) — over 50% at a 35% margin — and makes your figure incomparable with anyone else's.
  • Mismatching the period and the day count. Quarterly cost of sales against 365 days quadruples the apparent days on hand.
  • Two-point averaging in a seasonal business. Average 13 month-end balances, and state the method — changing it looks exactly like changing performance.
  • Comparing a LIFO filer with a FIFO filer. Add back the LIFO reserve first, or you are measuring an accounting election rather than an operation.
  • Handling work in progress inconsistently. Finished goods only is defensible for a retailer and misleading for a manufacturer. Pick one definition and hold it.
  • Counting consignment stock you do not own. It is in your building but not on your balance sheet, and including it double-counts the supplier's investment.
  • Reading a rising ratio as good news. A write-down cuts the denominator and lifts turnover while destroying value; a sales collapse does the same with a lag.
  • Benchmarking across sectors. Two turns is healthy for a jeweller and fatal for a grocer.

Inventory turnover, days on hand, order quantity and safety stock answer four different questions about the same pile of goods.

Turnover is the comparison metric. It is dimensionless, it appears in credit-scoring models and covenant packages, and it decomposes cleanly alongside receivables turnover in a DuPont-style breakdown of return on assets.

Days inventory on hand is the same information in the unit operating teams manage against, and it is the only form that adds up: inventory days plus receivable days minus payable days gives the cash conversion cycle. Use the days inventory outstanding calculator when you want a target, a gap, and the carrying cost of the gap.

Economic order quantity answers how much to buy each time by trading ordering cost against holding cost — see the EOQ calculator. Turnover reports the result; order quantity, safety stock and supplier lead time are the levers that produce it, and lead time usually beats the other two.

Working capital is where it all lands. Inventory plus receivables minus payables is the cash your operations consume; the days payable outstanding calculator covers the funding suppliers give you — but do not fund a slow warehouse by stretching payables without pricing it, because giving up a 2/10 net 30 discount to hold the cash 20 extra days costs (2 ÷ 98) × (365 ÷ 20), about 37% a year. Remember too that an average hides concentration: a turnover of 6 can mean every SKU moves twice a quarter, or that 30% of the catalogue has not moved in two years.

Key terms

Inventory turnover
Cost of goods sold divided by average inventory at cost — how many times the average stock on hand was sold and replaced.
Average inventory
The mean inventory balance over the period. Two-point averaging uses opening and closing balances; 13-point averaging uses every month-end and suits seasonal businesses.
Days inventory on hand
Days in the period divided by turnover — the average age of a unit of cost when it is finally sold. Also called days inventory outstanding.
GMROI
Gross margin return on inventory investment: gross margin dollars divided by average inventory at cost. Ranks fast-cheap lines against slow-rich ones fairly.
Carrying cost
The annual cost of owning inventory as a percent of its value: capital, storage, handling, insurance, property tax, shrink and obsolescence. Commonly 18% to 30%.
LIFO reserve
The disclosed gap between a LIFO company's reported inventory and what it would report on FIFO.

Frequently asked questions

Should I use cost of goods sold or sales in the numerator?

Use cost of goods sold. Inventory is carried at cost, so the flow that drains it must be measured at cost too. Putting revenue on top overstates turnover by 1 ÷ (1 − gross margin), a 54% overstatement at a 35% margin. A sales-to-inventory ratio mixes margin into a measure of speed, so companies with different margins cannot be compared on it.

What is a good inventory turnover ratio?

It depends almost entirely on what you sell. Perishable food runs 25 to 40 turns, packaged grocery and fast fashion around 12, industrial distribution 4 to 8, and machinery, furniture, jewellery and aerospace spares 1 to 3. Rather than chase a benchmark, compare your ratio with last year and pair it with GMROI: a line that turns slowly but returns $3 of gross margin per dollar of stock is doing its job.

Why does my turnover differ from the figure in a stock screener?

Screeners make different choices and all of them move the number. Many use revenue rather than cost of goods sold, which raises the ratio. Many use the closing balance rather than a two-point average, which raises it again in a growing business. None is wrong, but they are different definitions — check which one a covenant or peer table uses before arguing about it.

Does a higher turnover always mean better management?

No. Past a point, high turnover is a symptom of running too lean: stockouts, expedited freight, split shipments and lost sales that show up in no ratio. It can also be an artefact — a write-down cuts the denominator and lifts turnover while destroying value. Read turnover next to fill rate, freight per unit, gross margin and the direction of revenue.

How should I average inventory in a seasonal business?

Average all 13 month-end balances and divide by 13. A two-point average of a seasonal book can be badly wrong in either direction, depending on where the year-end falls relative to the peak. If you only have quarterly data, use the five quarter-end balances. State the method beside the ratio, because switching methods looks identical to a real change in performance.

How is GMROI different from inventory turnover?

Turnover measures speed only; GMROI measures the profit that speed produces. Because cost of sales equals turnover times average inventory, GMROI works out to turnover × gross margin ÷ (1 − gross margin). A 40%-margin line turning three times returns 2.0, while a 12%-margin line turning ten times returns 1.36 — the slower line is the better use of the shelf even though turnover ranks it last.

What does an inventory write-down do to the ratio?

It raises turnover, which is exactly the wrong signal. A write-down reduces the carrying value of inventory, shrinking the denominator, and it usually runs through cost of goods sold, enlarging the numerator. Both effects push the ratio up in the period the loss is recognised. When you see turnover jump, check the inventory note and the cost-of-sales line for an impairment before crediting anyone with better replenishment.

Can I calculate turnover in units instead of dollars?

Yes, and for a single SKU it is often clearer: divide units sold by average units on hand. Unit turnover strips out cost inflation and cost-flow assumptions, which makes it the better measure for reviewing one product line. It does not aggregate, though — you cannot add units of steel bar to units of fasteners — so company-level reporting stays in dollars.

References

  • FASB Accounting Standards Codification Topic 330, Inventory — Financial Accounting Standards Board
  • IAS 2 Inventories — International Accounting Standards Board
  • Intermediate Accounting, 18th ed. — Chapters 8 and 9, Inventories — Wiley (Kieso, Weygandt & Warfield)
  • Financial Reporting, Financial Statement Analysis and Valuation, 10th ed. — Cengage (Wahlen, Baginski & Bradshaw)
  • Inventory Management and Production Planning and Scheduling, 3rd ed. — Wiley (Silver, Pyke & Peterson)