Inventory Turnover Calculator
Measure how efficiently your business moves inventory and identify tied-up cash.
What Is Inventory Turnover?
Inventory turnover measures how many times a business sells and replaces its inventory within a given period, typically one year. The formula is: Turnover Ratio = Cost of Goods Sold / Average Inventory. A higher ratio means you are selling through inventory quickly, which is generally healthy. A low ratio suggests overstocking, slow-moving products, or declining demand. The companion metric, Days Sales of Inventory (DSI), converts the ratio into something more intuitive: the average number of days it takes to sell through your inventory. DSI = 365 / Turnover Ratio. If your turnover ratio is 5, your DSI is 73 days -- meaning your average item sits on shelves or in a warehouse for about 2.5 months before being sold. Inventory is cash tied up in physical form. Every dollar sitting in unsold inventory is a dollar that cannot be used to pay bills, invest in marketing, hire staff, or earn interest. Companies with poor inventory management often face cash flow crises despite appearing profitable on paper. This is why Amazon, Walmart, and other supply chain leaders obsess over inventory turnover -- it is the difference between thriving and running out of cash.
How to Use This Calculator
Enter Cost of Goods Sold
Use your annual COGS from your income statement, not revenue. COGS represents the actual cost of the inventory you sold, which is the correct denominator for this calculation.
Calculate Average Inventory
Average inventory = (Beginning Inventory + Ending Inventory) / 2. Use the inventory values from your balance sheet at the start and end of the period. For more accuracy, average all 12 monthly inventory figures.
Interpret the Results
Compare your turnover ratio to industry benchmarks. Grocery: 14-20. Retail: 4-8. Manufacturing: 4-6. Luxury goods: 1-3. The goal is not the highest possible number -- too high can mean you are constantly running out of stock and losing sales.
Key Concepts
Turnover Ratio
COGS divided by average inventory. A ratio of 5 means you sell through your entire inventory 5 times per year. Higher is typically better, but context matters by industry.
Days Sales of Inventory (DSI)
365 divided by turnover ratio. Shows how many days the average item sits before being sold. A DSI of 30 is fast-moving; 180 suggests serious overstocking or demand problems.
Carrying Cost
The annual cost of holding inventory, typically 20-30% of inventory value. Includes warehousing, insurance, obsolescence, damage, and opportunity cost of tied-up capital.
Dead Stock
Inventory that has not sold in 12+ months. Dead stock ties up cash and warehouse space. Industry best practice: liquidate dead stock at a loss rather than paying to store it indefinitely.
Stockout Cost
The revenue and customer goodwill lost when items are out of stock. Retail studies show 31% of customers buy from a competitor when their preferred item is unavailable.
Expert Insights
The Carrying Cost Trap: Most businesses underestimate inventory carrying costs. The true annual cost of holding inventory is 20-30% of its value when you account for warehouse space, insurance, shrinkage (theft/damage), obsolescence, and the opportunity cost of capital. On $100,000 of average inventory, you are spending $20,000-$30,000 per year just to store it. This is why lean inventory management has such a massive impact on profitability.
Segmented Analysis: Do not calculate one turnover number for your entire inventory. Segment by product category, SKU, or supplier. You may find that 20% of your SKUs account for 80% of sales (the Pareto principle in action), while the bottom 20% have turnover ratios below 1 and should be discontinued or heavily discounted. ABC analysis (A = top 20% of SKUs, B = middle 30%, C = bottom 50%) is the standard framework.
Frequently Asked Questions
This calculator provides estimates for educational purposes only. Actual results depend on your specific business circumstances, market conditions, and accounting methods. Consult a qualified CPA or business advisor before making major financial decisions.
Run These Numbers Too
Break-Even Calculator
Find the exact sales volume where your business starts generating profit.
Profit Margin Calculator
Calculate your gross, operating, and net margins to understand exactly where your money goes.
Accounts Receivable Aging Calculator
Analyze your outstanding invoices and identify collection bottlenecks by aging bucket.
Need Working Capital for Inventory?
Compare inventory financing, business lines of credit, and merchant cash advances.
Compare Inventory Financing