See how fast you sell through stock — your inventory turnover ratio and the average days inventory sits on the shelf.
Use inventory at cost, not retail. Higher turnover ties up less cash but risks stockouts; the right level depends on your industry and lead times. Estimate only.
Turnover is how many times you sell and replace your average inventory in a year. Higher turnover frees up cash and reduces spoilage and obsolescence; too high can mean lost sales from stockouts.
Turnover = COGS ÷ average inventory · Days on hand = 365 ÷ turnover
Inventory turnover is a velocity ratio: how many times in a year you sell through the stock you hold on average. Both halves have to be measured the same way — at cost — which is why cost of goods sold sits on top rather than revenue. What it measures is how hard your inventory dollars are working. What it ignores is almost everything else: it has no margin term, so it cannot tell you whether those turns were profitable; it has no service term, so it cannot tell you what the stockouts cost; and because it is an average it hides the difference between a fast-moving core and a tail that has not moved since last year.
The calculator opens with $120,000 of annual COGS and $20,000 of average inventory. $120,000 ÷ $20,000 = 6×, and 365 ÷ 6 = 60.83, which the tool rounds to 61 days on hand. The useful way to read that is as a standing cash position: to support $120,000 of annual cost of sales you are keeping $20,000 permanently parked on a shelf. Push to seven turns and the same sales need $120,000 ÷ 7 = $17,142.86 of inventory — $2,857.14 of cash released, and 52 days on hand. Slip to four turns and you need $30,000, which is $10,000 of extra cash out the door and 91 days on hand. In both directions the profit and loss account is unchanged; only the cash moved. Turnover is a working-capital metric before it is an operations one.
There is no universally good number, and anyone who quotes you one without naming a sector is guessing. Grocery turns dozens of times a year; furniture and jewellery turn a handful. Compare against your own trend first and your own sector second. To judge whether the turns are worth having, pair the ratio with margin: at a 40% gross margin, $120,000 of COGS implies $200,000 of revenue and $80,000 of gross profit, so every dollar of inventory returned $80,000 ÷ $20,000 = $4.00 of gross profit. That figure — gross margin return on inventory investment — is what stops you preferring a twelve-turn product at 5% margin to a four-turn product at 50%. On carrying cost, be careful: the widely repeated “20–30% of inventory value a year” is a rule of thumb we could not trace to a primary study, and benchmark data from APQC puts the floor nearer 10%. Build your own rate instead from what you actually pay — financing, storage, insurance, shrinkage and the markdowns you eventually take — and apply it to the $20,000 to price what one extra turn is worth.
The first is putting revenue on top. $200,000 ÷ $20,000 = 10× and 37 days, which looks like a well-run business and is simply your markup double-counted. The second is an “average” that is not one. Count inventory only at the financial year end, after the clearance sale — say $16,000 — and you get 7.5× and 49 days, the seasonal low posing as normal. A two-point average of opening and closing stock is the minimum defensible method; a monthly average is what a seasonal business actually needs. The third is reading the company-wide figure alone: the same 6× can be a core range turning fifteen times carrying a tail turning once, and the decision you need — what to discount, what to stop buying — only appears when you compute it by category or by SKU. The fourth is managing the ratio rather than the business. Starve purchasing and turnover rises beautifully; the lost sales never appear in the formula.
One division answers “how fast, on average, right now.” Every decision that follows is narrower than that: which lines to reorder, which to mark down, how much cash the next buying cycle needs. That takes inventory value by month, COGS split by category, and a reorder point per line — a small table, but one that has to be maintained rather than calculated once. Our Business Inventory & Asset Tracker is the ready-made version; the column that makes any of them earn their keep is the date each line last sold.
Highly industry-dependent — grocery turns very fast, furniture slowly. Track your own trend and compare within your sector.
Use COGS, matched to inventory at cost. Using revenue overstates turnover because it includes your markup.
Related: inventory tracker · gross profit calculator · ecommerce profit calculator · all free calculators.
More free business metrics tools — no signup, works on any device.
Yes. The Inventory Turnover Calculator is completely free, runs in your browser, and never asks for a signup, email, or download. Enter your numbers and the result updates instantly.
It uses standard formulas and recalculates the moment you change a value, so the math is exact for the inputs you enter. Treat the result as a reliable planning estimate; for decisions with legal or tax consequences, confirm the figures with a qualified professional.
Yes. The calculator is mobile-friendly and works on any phone, tablet, or computer — there is no app to install and nothing to save.
Yes. Scroll to “Add this free calculator to your site” above and copy the embed snippet to place the live calculator on your blog or website for free.
Last reviewed: September 2026. Free to use, no signup — Inventory Turnover Calculator by ToolWise Digital.
Copy the snippet to embed the live calculator on your blog or website — free for any site. The small “Calculator by ToolWise Digital” credit line keeps it free; you're welcome to remove it, but we appreciate you leaving it.
Ready-made Google Sheets & Excel trackers for money, taxes, and small business — each with a free phone version.
Browse the shop →Simple Monthly Budget and our Small Business Bookkeeping template (Google Sheets & Excel) — no signup, no wall, just the files. If you also want the occasional short note on pricing, bookkeeping and the money side of a small business, the list is here. No spam — unsubscribe anytime.