📦 Inventory Turnover Calculator
By ToolNimba Finance Team · Reviewed by ToolNimba Editorial Review, business finance content · Updated 2026-06-19
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. It 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. Enter your cost of goods sold (COGS) and average inventory, and this calculator 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?
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 is consistent. Average inventory smooths out seasonal swings and is usually taken as the beginning inventory plus the ending inventory, divided by two. The result 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, converts the ratio into a more intuitive figure: DSI = 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 are two views of the same thing: high turnover means low DSI, and vice versa.
There is no single good number. 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.
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.
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).
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
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 |
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.
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.
- Dead stock
- Inventory that is not selling and ties up cash and storage space, often a cause of a low turnover ratio.
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 may turn over 10 to 15 times a year, while furniture, jewelry or machinery may turn over only 2 to 4 times. Compare your ratio against your own history and against direct competitors rather than a universal target.
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.
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.
Sources
- Inventory Turnover , Investopedia
- Days Sales of Inventory (DSI) , Investopedia