Inventory Turnover Calculator
Created by: Ethan Brooks
Last updated:
Enter COGS and average inventory to calculate how many times inventory is sold and replaced per year, plus days inventory outstanding (DIO) — the first leg of the cash conversion cycle.
Inventory Turnover Calculator
FinanceCalculate how many times inventory is sold and replaced in a period, and convert that to days inventory outstanding (DIO) to understand cash cycle speed.
What Is the Inventory Turnover Ratio?
The inventory turnover ratio measures how efficiently a company manages its inventory by showing how many times inventory is sold and replaced over a specific period.
A high ratio means the company is selling goods quickly; a low ratio suggests slow-moving stock that ties up cash and risks obsolescence.
This metric is central to working capital management, supply chain optimization, and operational efficiency analysis.
Retailers, manufacturers, and distributors use it to benchmark against competitors and identify over-stocking or under-stocking problems before they affect cash flow.
How to Calculate Inventory Turnover
The formula divides COGS by average inventory.
Average inventory smooths out seasonal fluctuations by averaging the balance at the start and end of the period.
Days inventory outstanding (DIO) converts the ratio into a more intuitive days metric by dividing 365 by the turnover ratio.
Inventory Turnover Formulas
Inventory turnover = COGS / average inventory
Days inventory outstanding (DIO) = 365 / inventory turnover
Average inventory = (beginning inventory + ending inventory) / 2
Example Scenarios
Retail Grocery Chain
COGS = $50M, average inventory = $3M. Inventory turnover = 50 / 3 = 16.7×. DIO = 365 / 16.7 = 21.9 days. Groceries turn over every 22 days — consistent with the perishable nature of the inventory.
Industrial Equipment Manufacturer
COGS = $12M, average inventory = $4M. Inventory turnover = 12 / 4 = 3×. DIO = 365 / 3 = 121.7 days. Each unit of equipment takes about 4 months to move from raw materials to sale — typical for heavy manufacturing.
How People Use This Calculator
- CFOs reviewing working capital efficiency on a quarterly basis.
- Supply chain managers identifying slow-moving SKUs that tie up cash.
- Investors comparing inventory management across peer companies before making a buy decision.
- Lenders using DIO as part of a borrowing base calculation for asset-backed loans.
- Analysts building the cash conversion cycle from its three components.
Tips for Interpreting Inventory Turnover
Always compare to industry benchmarks — a turnover of 5× is excellent for jewelry but alarming for a supermarket.
Seasonal businesses should compute turnover over the appropriate period rather than annualizing a single quarter.
A sudden drop in inventory turnover warrants investigation: it could mean weakening demand, a change in ordering strategy, or inventory build-up ahead of an anticipated price increase.
A sudden spike might signal stockout risk.
Frequently Asked Questions
What is the inventory turnover ratio?
The inventory turnover ratio measures how many times a company sells and replaces its inventory over a period. It is calculated by dividing the cost of goods sold (COGS) by average inventory. A ratio of 8 means the company turned over its inventory 8 times during the year — roughly every 45 days.
What is a good inventory turnover ratio?
There is no single good number — it depends on the industry. Grocery stores typically turn inventory 20–30 times per year while luxury goods retailers might turn 2–4 times. The key is comparing to industry peers and tracking the trend over time. A sudden drop in turnover may signal slow-moving or obsolete inventory.
What is days inventory outstanding (DIO)?
Days inventory outstanding (DIO) is the average number of days a company holds inventory before selling it. It is calculated as 365 divided by the inventory turnover ratio. A DIO of 45 days means inventory sits on shelves for 45 days on average before being converted to a sale.
Why use COGS instead of revenue for inventory turnover?
COGS is used instead of revenue because it represents what was actually spent producing the goods — at the same cost basis as inventory on the balance sheet. Using revenue would mix two different measurement bases (cost and selling price), inflating the ratio. Some analysts use net sales for simplicity, but COGS provides a more accurate comparison.
How does inventory turnover relate to the cash conversion cycle?
Inventory turnover is the first leg of the cash conversion cycle. A lower DIO shortens the time from raw material purchase to sale, which improves the CCC. Reducing DIO from 60 days to 40 days frees up 20 days of COGS in working capital — a significant source of liquidity without borrowing.
Can inventory turnover be too high?
Yes. An excessively high inventory turnover ratio can signal stockouts — the company is running out of inventory before it can reorder. Frequent stockouts lead to lost sales, customer dissatisfaction, and expedited-shipping costs. The optimal turnover maximizes sales velocity while maintaining enough safety stock to meet demand peaks.
Sources and References
- Brigham, E.F. and Ehrhardt, M.C. Financial Management: Theory and Practice, 16th ed.
- Subramanyam, K.R. Financial Statement Analysis, 11th ed. McGraw-Hill.
- CFA Institute. CFA Program Curriculum — Financial Reporting and Analysis.