📦 Inventory Turnover Calculator
By Shihab Mia · Reviewed by ToolNimba Review Team, business finance content · Updated 2026-08-01
This calculator gives an estimate for general analysis only. The right turnover ratio varies widely by industry, business model and accounting method (FIFO, LIFO or weighted average), and the figures depend on how you define your period and value your inventory. The industry ranges shown on this page are general, commonly cited benchmarks, not precise or authoritative statistics, and actual results vary by business. This tool is not financial, accounting or investment advice. Confirm figures against your audited financial statements and speak to a qualified accountant before making business decisions.
Inventory turnover measures how many times a business sells and replaces its stock over a period, usually a year. A higher ratio means stock moves quickly and ties up less cash; a low ratio can signal overstocking or weak sales. This inventory turnover calculator takes your cost of goods sold (COGS) and average inventory and instantly returns the inventory turnover ratio plus the days sales of inventory (DSI), which is the average number of days an item sits before it is sold.
What is the Inventory Turnover Calculator?
The inventory turnover ratio is defined as cost of goods sold divided by average inventory. COGS is used, rather than sales revenue, because both COGS and inventory are valued at cost, so the comparison stays consistent. Average inventory smooths out seasonal swings and is usually taken as the beginning inventory plus the ending inventory, divided by two. The result an inventory turnover calculator returns is a number of times: a turnover of 6 means the business cycled through its average stock six times during the period.
Days sales of inventory (DSI), also called days inventory outstanding (DIO), converts the ratio into a more intuitive figure: DSI equals the number of days in the period divided by the turnover ratio. With a 365-day year and a turnover of 6, DSI is about 61 days, meaning an average item sits in the warehouse for roughly two months before selling. DSI and turnover describe the same thing from two angles: high turnover means low DSI, and vice versa, so once you know one you can always derive the other.
There is no single good inventory turnover ratio that applies to every business. Grocers and fast-fashion retailers run very high turnover because food and trend items must move fast, while jewelry, heavy machinery and luxury goods turn over slowly by nature. The useful comparison is against your own history and against direct competitors in the same industry. A ratio that is far below peers may point to dead stock, overbuying or falling demand; a ratio far above peers can mean lean, efficient operations or, in the extreme, frequent stockouts and lost sales. Running the numbers through an inventory turnover calculator every month or quarter, rather than once a year, surfaces these swings while there is still time to act on them.
You can pull the two inputs an inventory turnover calculator needs straight from standard financial statements. Cost of goods sold appears on the income statement, just below revenue. Beginning and ending inventory come from the balance sheet: ending inventory is the balance at the close of the period, and beginning inventory is simply the prior period's ending balance. If you only have one snapshot, using it alone instead of an average will distort the ratio, especially for seasonal businesses, so pull both dates whenever you can.
When turnover is lower than you want, the usual levers are tighter demand forecasting so you buy closer to actual sales, clearing dead or slow-moving stock through bundles or markdowns rather than letting it sit, negotiating smaller and more frequent supplier deliveries instead of large infrequent ones, and running an ABC analysis to focus attention on the small share of SKUs that hold most of the value. None of these fixes should be applied blindly: cutting stock too aggressively to push the ratio up is a common overcorrection that trades a turnover problem for a stockout problem, so track fill rate or lost-sales alongside the ratio.
Finally, remember that the inventory turnover ratio is a diagnostic signal, not a target to hit in isolation. Two businesses with identical turnover can be in very different health if one is chronically out of stock and the other comfortably serves every order. Use this calculator alongside gross margin, sell-through rate and stockout data, and revisit the number on a regular schedule so a single seasonal quarter does not get mistaken for a long-term trend.
When to use it
- Tracking whether your stock is moving faster or slower than in previous quarters or years.
- Benchmarking your turnover and DSI against competitors in the same industry.
- Spotting overstocking or dead inventory that is tying up working capital.
- Supporting cash-flow and purchasing decisions about how much to reorder and when.
- Preparing inventory turnover figures for a loan application, investor update or board report.
- Comparing turnover across multiple product lines, categories or store locations to find where inventory is stuck.
How to use the Inventory Turnover Calculator
- Enter your cost of goods sold (COGS) for the period.
- Either enter the average inventory directly, or switch to beginning + ending inventory and let the tool average them.
- Set the period length in days (365 for a full year, 90 for a quarter, and so on).
- Read off the inventory turnover ratio and the days sales of inventory (DSI).
- Compare the result against your own prior periods and against the industry benchmark table below before drawing conclusions.
Formula & method
Worked examples
A shop has COGS of $500,000 and average inventory of $100,000 over a full year.
- Inventory turnover = COGS ÷ average inventory
- Turnover = 500,000 ÷ 100,000 = 5.00
- DSI = 365 ÷ turnover = 365 ÷ 5 = 73 days
Result: Turnover = 5.00x, DSI = 73.0 days
A business reports COGS of $1,200,000, beginning inventory of $120,000 and ending inventory of $180,000.
- Average inventory = (120,000 + 180,000) ÷ 2 = 150,000
- Turnover = 1,200,000 ÷ 150,000 = 8.00
- DSI = 365 ÷ 8 = 45.625, about 45.6 days
Result: Average inventory $150,000, turnover = 8.00x, DSI = 45.6 days
A footwear retailer reports COGS of $600,000 for a single quarter (91 days) and average inventory of $300,000 for that quarter.
- Quarterly turnover = 600,000 ÷ 300,000 = 2.00
- Quarterly DSI = 91 ÷ 2 = 45.5 days
- Annualized turnover = 2.00 x 4 = 8.00 (approx.), for comparison against annual benchmarks
Result: Quarterly turnover = 2.00x, DSI = 45.5 days, annualized turnover approx. 8.00x
How inventory turnover maps to days sales of inventory (DSI) over a 365-day year
| Turnover ratio | Days sales of inventory (DSI) | Reading |
|---|---|---|
| 2x | 182.5 days | Slow moving, stock held about 6 months |
| 4x | 91.3 days | Stock held about a quarter |
| 6x | 60.8 days | Roughly two months on hand |
| 8x | 45.6 days | Brisk, about six weeks on hand |
| 12x | 30.4 days | Fast, about one month on hand |
| 15x | 24.3 days | Very fast, typical of groceries |
Commonly cited annual inventory turnover ranges by industry (general benchmarks, actual results vary by business)
| Industry | Typical turnover ratio | Typical DSI |
|---|---|---|
| Grocery and perishable foods | 14x to 20x | 18 to 26 days |
| Fashion and apparel | 6x to 12x | 30 to 60 days |
| Electronics and technology | 4.5x to 8x | 45 to 80 days |
| General retail (blended average) | 5x to 10x | 37 to 73 days |
| Automotive dealers | 6x to 8x | 46 to 61 days |
| Furniture and home goods | 2.5x to 5x | 75 to 145 days |
| Heavy machinery and industrial equipment | 1x to 3x | 120 to 365 days |
What a high or low inventory turnover ratio usually signals
| Signal | Possible cause | Action to consider |
|---|---|---|
| Turnover much higher than industry peers | Lean stock levels, strong sales, or too little safety stock | Check stockout rates and lost sales before treating it as purely good news |
| Turnover much lower than industry peers | Overbuying, slow sales, or obsolete stock | Review slow-moving SKUs and consider bundling, clearance or markdown |
| Turnover rising over time | Improved demand forecasting or leaner purchasing | Confirm service levels and fill rate have not suffered |
| Turnover falling over time | Demand slowdown or purchasing ahead of need | Investigate before placing the next replenishment order |
Common mistakes to avoid
- Using sales revenue instead of COGS. Some formulas divide sales by inventory, but sales include profit margin while inventory is valued at cost. Mixing the two inflates the ratio. The standard, comparable measure uses COGS divided by average inventory.
- Using a single point-in-time inventory figure. Taking only the year-end balance can be misleading if stock swings seasonally. Averaging the beginning and ending inventory (or several monthly readings) gives a fairer picture of what was actually held during the period.
- Comparing across different industries. A turnover of 4 might be excellent for a furniture store and alarming for a supermarket. Always benchmark against your own history and against close competitors in the same sector, not against unrelated businesses.
- Mismatching the period and the day count. If your COGS covers a single quarter, the period for DSI should be about 90 days, not 365. Using 365 days with a quarterly turnover figure overstates how long stock sits.
- Not annualizing a partial-period ratio before comparing it to annual benchmarks. A quarterly turnover of 2.0 is not automatically "low"; multiplied by four to annualize it, that is 8.0, which may sit comfortably within an industry benchmark range. Compare like with like.
- Letting shrinkage, write-offs or obsolete stock hide inside the inventory balance. Damaged, expired or unsellable stock that has not been written off still counts as inventory on the books, which understates true turnover. Reconcile inventory records against physical counts before running the ratio for an important decision.
Glossary
- Inventory turnover ratio
- How many times a business sells and replaces its average inventory over a period, equal to COGS divided by average inventory.
- COGS
- Cost of goods sold, the direct cost of the products a business sold during the period, valued at cost rather than at selling price.
- Average inventory
- A smoothed inventory figure, usually beginning inventory plus ending inventory divided by two, used to avoid distortion from a single date.
- Days sales of inventory (DSI)
- The average number of days an item stays in inventory before it is sold, equal to days in the period divided by the turnover ratio. Also called days inventory outstanding (DIO).
- Dead stock
- Inventory that is not selling and ties up cash and storage space, often a cause of a low turnover ratio.
- Safety stock
- Extra inventory held above expected demand to cushion against supply delays or demand spikes, which can lower turnover slightly in exchange for fewer stockouts.
- Stockout
- A point at which a business runs out of a product it could otherwise have sold, often a side effect of pushing inventory turnover too high.
- GMROI (Gross Margin Return on Investment)
- A related metric that measures gross profit earned per dollar of average inventory cost, useful alongside turnover when margins differ widely between products.
Frequently asked questions
How is inventory turnover calculated?
Inventory turnover is cost of goods sold (COGS) divided by average inventory. Average inventory is usually the beginning inventory plus the ending inventory divided by two. For example, COGS of $500,000 with average inventory of $100,000 gives a turnover of 5.0 times.
What is days sales of inventory (DSI)?
DSI is the average number of days an item sits in stock before it is sold. It is the number of days in the period divided by the turnover ratio, commonly 365 divided by turnover for a full year. A turnover of 5 gives a DSI of about 73 days.
What is a good inventory turnover ratio?
It depends heavily on the industry. Grocery and fast-fashion businesses commonly turn over stock 10 to 20 times a year, while furniture, jewelry or heavy machinery may turn over only 1 to 5 times. Compare your ratio against your own history and against direct competitors rather than a universal target.
What is a bad inventory turnover ratio?
A ratio that sits well below your own industry's typical range, or that is falling steadily quarter over quarter, usually signals a problem: overbuying, slowing demand, or dead stock building up. There is no single bad number without comparing it to your sector and your own trend.
Should I use COGS or sales in the formula?
Use COGS. Both COGS and inventory are valued at cost, so the comparison is consistent. Using sales, which includes profit margin, inflates the ratio and makes it harder to compare with the standard measure that analysts and accountants use.
Why is a very high turnover not always good?
High turnover usually signals efficient stock management, but an extremely high ratio can mean inventory is too lean. That raises the risk of stockouts, where you cannot meet demand and lose sales. The goal is fast turnover that still keeps enough stock to serve customers reliably.
Can I calculate turnover for a quarter or a month?
Yes. Use the COGS for that shorter period, then set the period length to match, about 90 days for a quarter or 30 for a month, when computing DSI. Keep the period of the COGS, the inventory and the day count consistent so the result is meaningful, and multiply by 4 or 12 to annualize before comparing to annual benchmarks.
Where do I find COGS and average inventory on financial statements?
Cost of goods sold appears on the income statement, just below revenue. Beginning and ending inventory both come from the balance sheet: ending inventory is the closing balance for the period, and beginning inventory is the prior period's ending balance.
Does a higher inventory turnover ratio always mean more profit?
Not necessarily. Turnover measures how fast stock moves, not how profitable each sale is. A business can have high turnover on thin-margin items and lower overall profit than a competitor with slower turnover but fatter margins, so read turnover alongside gross margin and GMROI.
How often should I calculate inventory turnover?
Monthly or quarterly is common for active management, since it catches problems while there is still time to act, while a full-year figure is more useful for benchmarking against competitors or reporting to lenders and investors. Use this inventory turnover calculator on whatever cadence matches your reporting cycle.
Sources
- Inventory Turnover , Investopedia
- Days Sales of Inventory (DSI) , Investopedia