Business Finance

Inventory Turnover Calculator

Calculate inventory turnover ratio and days sales of inventory from COGS and inventory values.

Inventory Data

Cost of Goods Sold (Annual) ($)

Beginning Inventory ($)

Ending Inventory ($)

Annual Revenue (Optional) ($)

Enter to calculate GMROI and stock-to-sales ratio.

Units Received (Optional)

Units Sold (Optional)

Annual Carrying Cost % (Optional)

Storage, insurance, depreciation. Typically 20-30% of inventory value.

Turnover Analysis

Enter COGS and inventory values, then click calculate.

Download Your Results

Includes formulas & explanations

A 10-second preparation delay applies before each download begins.

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

Dead inventory is dead capital. Every unit sitting in a warehouse that is not selling represents cash that was spent but not yet recovered -- and until it sells, it cannot fund payroll, supplier payments, or growth. The National Retail Federation reports that US retailers hold an estimated $1.43 in inventory for every $1 in sales, with overstocking and shrink costing the industry billions annually. Inventory turnover measures how many times a business sells and replaces its inventory stock over a period -- typically one year. A high turnover signals efficient inventory management and strong demand. A low turnover signals slow-moving stock, over-purchasing, or demand forecasting errors. This calculator computes your inventory turnover ratio, average days inventory outstanding (DIO), and the cost of capital tied up in slow-moving stock -- giving you a precise view of inventory health rather than a feeling.

What This Calculator Does

This inventory turnover calculator takes your annual cost of goods sold (COGS) and average inventory value (beginning plus ending inventory divided by 2) to produce the inventory turnover ratio and days inventory outstanding (DIO). Optionally enter your cost of capital rate to calculate the annual cost of holding your current inventory level, and enter an industry benchmark turnover ratio to see how your performance compares.

The Formula

Inventory Turnover = COGS / Average Inventory | Days Inventory Outstanding (DIO) = 365 / Inventory Turnover

COGS is used in the numerator rather than revenue because inventory is recorded at cost, not at selling price. Using revenue would inflate the apparent turnover rate. Average inventory is calculated as (Beginning Inventory + Ending Inventory) / 2 to smooth out seasonal fluctuations in stock levels. DIO expresses the same ratio in days: how many days of COGS-worth of inventory is held on average. A DIO of 45 means the business holds 45 days' worth of inventory at current consumption rates.

Step-by-Step Example

Gather COGS and inventory figures

An electronics retailer reports annual COGS of $4,800,000. Beginning inventory (January 1): $620,000. Ending inventory (December 31): $740,000. Average inventory: ($620,000 + $740,000) / 2 = $680,000.

Calculate inventory turnover

Inventory turnover: $4,800,000 / $680,000 = 7.06 times per year.

Calculate days inventory outstanding

DIO: 365 / 7.06 = 51.7 days. The business holds approximately 52 days of inventory on hand at any given time.

Benchmark and calculate holding cost

Industry benchmark for electronics retail: 8 to 12 turns. At 7.06 turns, the business is below benchmark. With a 6% cost of capital, the annual holding cost of $680,000 in inventory is $40,800. Improving to 9 turns would reduce average inventory to $533,000 and save $8,820 in annual holding cost -- plus freeing $147,000 in cash.

Real-World Use Cases

Identifying Slow-Moving SKUs Before Year-End

A hardware distributor calculates turnover at the SKU level, not just the aggregate. 80% of SKUs turn at 8 to 14 times per year. The bottom 15% turn fewer than 3 times annually. Running the DIO calculation on the slow movers reveals $148,000 in stock with an average DIO of 187 days. Management implements a clearance pricing strategy for these SKUs before the year-end inventory audit, recovering $112,000 in cash and reducing storage costs.

Evaluating a New Supplier's Minimum Order Requirement

A supplier offers a 12% price discount for orders of 2,000 units minimum versus the current 500-unit orders. The current turnover on this SKU is 9 times per year (DIO 41 days). At 2,000 units, the inventory would last approximately 146 days before depletion at current sales velocity -- a DIO of 146, well above the acceptable threshold. The discount is rejected because the carrying cost and cash lock-up outweigh the price benefit.

Working Capital Line of Credit Sizing

A manufacturer applies for a revolving credit facility. The lender uses DIO as one input in collateral-based lending. With a DIO of 60 days and monthly COGS of $350,000, the average inventory eligible as collateral is approximately $700,000. The lender advances 50% against eligible inventory, supporting a $350,000 credit line. Understanding DIO helps the owner understand and optimize their borrowing capacity.

Comparison

Industry	Typical Inventory Turnover	Typical DIO (Days)	Notes
Grocery / Food Retail	15 - 25x	15 - 24 days	Perishables drive high frequency
Consumer Electronics	8 - 12x	30 - 45 days	Short product cycles increase risk
Apparel Retail	4 - 6x	60 - 90 days	Seasonal patterns create spikes
Automotive Parts	3 - 5x	73 - 120 days	Wide SKU range; tail is slow
Industrial / B2B Distribution	4 - 7x	52 - 90 days	MRO items turn slower
Manufacturing	4 - 8x	45 - 90 days	WIP adds to holding time

Common Mistakes to Avoid

Using revenue instead of COGS in the numerator. Inventory is valued at cost, so comparing it to revenue introduces a margin-distorted ratio. A business with 60% gross margins using revenue would appear to turn inventory nearly 2.5 times faster than the COGS-based calculation -- which overstates inventory efficiency. Always use COGS.
Using ending inventory only instead of average inventory. Ending inventory may be artificially low (after year-end clearance) or high (before seasonal buildup), making the turnover ratio look better or worse than the true operational reality. Average inventory smooths these distortions.
Optimizing turnover at the expense of stockout risk. Pushing inventory turnover too high without improving demand forecasting or lead time management increases the frequency of stockouts. The goal is the optimal turnover for your service level, not the maximum possible turnover.

Frequently Asked Questions

What is a good inventory turnover ratio?

There is no universal good number -- it depends heavily on the industry and business model. Grocery retailers turning perishables 20 times a year are performing well. A fine jewelry retailer turning inventory 2 to 3 times is normal for that category. The most relevant benchmark is your industry peer group. Risk Management Association (RMA) annual statement studies and industry associations publish sector-specific turnover benchmarks. Your trend over time matters as much as the absolute number.

How does inventory turnover affect cash flow?

Every day of DIO represents cash invested in inventory rather than available for operations or debt repayment. Reducing DIO by 10 days releases cash equal to 10 days of average daily COGS. For a business with $3M annual COGS, 10 days of improvement ($82,000 in released cash) can be the difference between needing a line of credit draw and not needing one. Inventory is working capital -- turning it faster improves liquidity without requiring external financing.

Can inventory turnover be too high?

Yes. An excessively high turnover ratio can indicate chronic stockouts, insufficient safety stock, or over-reliance on just-in-time replenishment with no buffer for supply disruptions. During the COVID-19 supply chain crisis, businesses with very lean inventory policies lost revenue because they could not source product. The right turnover level balances efficiency with supply chain resilience.

What is the difference between inventory turnover and the inventory turn rate?

They are the same concept, expressed the same way. 'Inventory turns' or 'inventory turn rate' refers to the number of times inventory is sold and replaced in a period. The terms are interchangeable in practice. Some industries express the concept differently (e.g., 'stock turns' in UK retail), but the underlying calculation and interpretation are identical.

Accuracy and Disclaimer

Inventory turnover calculations use COGS and average inventory values as provided. Actual inventory holding costs vary by product type, storage conditions, insurance, and financing structure. Industry benchmarks cited are general estimates; actual benchmarks for specific industries and business sizes should be sourced from applicable trade associations or financial data providers. Results are for planning purposes only.

Conclusion

Inventory turnover is a leading indicator of cash flow health, not a lagging one. If turnover is declining while revenue is stable or growing, the problem is upstream: over-purchasing, expanding SKU count without demand validation, or supplier minimum order quantities that exceed actual usage. To see how inventory performance affects your short-term liquidity position, use the Working Capital Calculator. For businesses modeling reorder decisions to optimize turnover, the Inventory Reorder Point Calculator provides the demand-based reorder framework.