Inventory Turnover Calculator

What This Calculator Does

Inventory turnover measures how many times a company sells and replaces its inventory over a given period, usually a year. It tells you how efficiently stock moves through the business. A ratio of 6x means you sell and replenish your entire inventory six times per year, or roughly every 61 days. This calculator takes your cost of goods sold and your beginning and ending inventory values, computes the average inventory, and gives you both the turnover ratio and the days inventory on hand.

Turnover is one of the most telling operational metrics for any business that carries stock. High turnover usually means strong sales, efficient purchasing, and minimal obsolete inventory. Low turnover signals slow-moving stock, overbuying, or weak demand. Either extreme has costs. Too low and capital sits idle in a warehouse, racking up storage, insurance, and obsolescence charges. Too high and you risk stockouts, lost sales, and rushed reordering at premium freight rates. The goal is a ratio that fits your industry and business model.

Turnover ties directly to working capital and cash flow. To see the broader liquidity picture, use our Current Ratio / Quick Ratio Calculator. For the cash flow impact of inventory changes, our Cash Flow Calculator shows how inventory build or drawdown affects operating cash. And to understand how inventory costs feed into profitability, our Net Profit Margin Calculator walks the full income statement.

Inputs Required

• Cost of Goods Sold (COGS): Total cost of goods sold for the period, from your income statement
• Beginning Inventory: Inventory value at the start of the period, from your balance sheet
• Ending Inventory: Inventory value at the end of the period, from your balance sheet

Outputs Provided

• Inventory Turnover Ratio: COGS divided by average inventory, expressed as a multiple (e.g. 6x)
• Days Inventory on Hand: 365 divided by the turnover ratio, showing how many days of inventory you hold on average
• Average Inventory: The mean of beginning and ending inventory
• Industry Reference Ranges: Directional benchmarks for common sectors

How the Calculation Works

Average inventory smooths out the difference between what you held at the start and end of the period. Using only ending inventory can mislead if you made a large purchase right before the period ended or ran stock down to clear a season. The two-point average is the standard approach. Some businesses with seasonal swings use a four-quarter average for more accuracy, but the formula is the same.

The formula uses COGS, not revenue, because revenue includes markup that inflates the ratio. Using COGS keeps both the numerator and denominator at cost, giving an apples-to-apples comparison. Some sources use sales instead of COGS, which produces a higher ratio but is less accurate. Stick with COGS unless you are comparing to a specific source that uses sales.

How to Use the Calculator

1. Pull your income statement and balance sheet for the period, usually one year
2. Enter total COGS from the income statement
3. Enter beginning inventory from the opening balance sheet
4. Enter ending inventory from the closing balance sheet
5. Review the turnover ratio and days on hand
6. Compare your result to the industry reference ranges shown in the calculator

Example Calculations

Example 1: Grocery Store

A grocery store reports $2.4 million in annual COGS, beginning inventory of $150,000, and ending inventory of $170,000. Average inventory is $160,000. Turnover is $2.4M / $160K = 15x. Days on hand is 365 / 15 = 24 days. That fits the grocery sector, where perishability demands rapid turnover of 14 to 20 times per year. The store is turning stock about every three and a half weeks, which is healthy for fresh food retail.

Example 2: Furniture Retailer

A furniture store reports $800,000 in COGS, beginning inventory of $300,000, and ending inventory of $340,000. Average inventory is $320,000. Turnover is $800K / $320K = 2.5x. Days on hand is 365 / 2.5 = 146 days. Furniture is a slow-turn category, with typical ranges of 2 to 5x annually. This store is at the low end, holding inventory for nearly five months on average. The owner should check whether a portion of the stock is obsolete or slow-moving and dragging the ratio down.

Real World Scenarios

Identifying Obsolete Stock

An electronics retailer sees turnover drop from 8x to 5x over two years while COGS stayed flat at $1.5 million. Average inventory rose from $187,500 to $300,000. The increase in inventory is the cause. Digging into the SKU list, the owner finds $80,000 of product from two generations ago that has not sold in 18 months. That dead stock inflates average inventory and depresses the ratio. After clearing it at a discount, average inventory drops to $220,000 and turnover recovers to 6.8x. The ratio served as an early warning that something was sitting in the warehouse costing money.

Evaluating a Supplier Minimum Order

A specialty retailer is offered a 15% discount on a key product line if she doubles her order quantity. Her current COGS on the line is $200,000 per year, and she turns inventory 6x, holding about $33,000 in average inventory. Doubling the order would push average inventory to $66,000 and drop turnover to 3x, or 122 days on hand. The 15% discount saves $30,000 in COGS, but the extra inventory ties up $33,000 in cash and adds carrying costs. Supply chain benchmarking data puts carrying costs at 20% to 30% of inventory value per year, meaning $6,600 to $9,900 in additional holding costs. The net saving is roughly $20,000 to $23,000, still positive but much smaller than the headline 15% suggests. The calculator lets her model the turnover impact before committing.

Seasonal Business Planning

A sporting goods store does 70% of its sales in two seasons. Annual COGS is $900,000, beginning inventory is $250,000, and ending inventory is $200,000. Average inventory is $225,000, giving a turnover of 4x and 91 days on hand. That looks slow for retail, but sporting goods typically runs 3 to 7x because of seasonality. The owner knows the annual average masks the reality: inventory builds before each season and draws down after. She tracks turnover monthly during peak seasons and finds it spikes to 12x in spring and fall while dropping to 1x in off months. The annual figure is a planning baseline, but the monthly view drives purchasing decisions.

Common Mistakes to Avoid

• Using revenue instead of COGS: Revenue includes markup, which inflates the ratio. Always use COGS so both numerator and denominator are at cost. A 40% margin business will show a turnover 1.67x higher if you use sales, which is meaningless for comparison
• Comparing across industries: Grocery turns 14 to 20 times per year. Furniture turns 2 to 5 times. A 4x ratio is healthy in one and alarming in the other. Always benchmark against your specific sector and business model
• Ignoring the blend: A single company-wide ratio can hide a fast-moving bestseller next to a dead SKU. Calculate turnover by product category or SKU to find what is actually moving and what is dragging the average down
• Forgetting carrying costs: Low turnover is not just a ratio problem. It ties up cash and racks up storage, insurance, obsolescence, and opportunity costs that typically run 20% to 30% of inventory value per year. The ratio is a symptom; the cash drain is the disease

Limitations of This Calculator

This calculator uses a two-point average of beginning and ending inventory, which can distort results for seasonal businesses or companies with large mid-period swings. It does not compute turnover by SKU or category, which is where most operational insight comes from. It uses COGS as the numerator, which is the standard approach, but some sources use sales, so confirm the basis when comparing to external benchmarks. The industry reference ranges shown are directional planning guides drawn from 2026 benchmarking data, not precise targets. For detailed inventory analysis, use inventory management software that tracks turnover by SKU, aging, and season.

Authoritative Research & Resources

• Investopedia - Inventory Turnover Ratio - A comprehensive reference defining inventory turnover, the formula, and how to interpret the ratio across different business models.
• ReadyRatios - Inventory Turnover by Industry (SEC data) - Inventory turnover benchmarks calculated from US public company filings, broken down by industry and year.
• Corporate Finance Institute - Inventory Turnover Guide - A finance-focused explanation of inventory turnover, days inventory on hand, and how the ratio connects to working capital management.