Inventory Turnover Calculator

Compute inventory turnover and days in inventory from COGS and average stock — and the excess inventory versus your target turnover.

Inventory is cash sitting on shelves. Enter cost of goods sold and your beginning and ending inventory to get the turnover ratio, how many days stock sits before selling, and — against a target turnover you choose — how much inventory value is excess and could be converted back into cash.

How this calculator works

Average Inventory = (Beginning Inventory + Ending Inventory) / 2. Turnover = Cost of Goods Sold / Average Inventory. Days in Inventory = 365 / Turnover. Target Average Inventory = COGS / Target Turnover; Excess = Average − Target Average (when positive).

Key benefits

Assumptions & exclusions

Frequently asked questions

What is a good inventory turnover ratio?

It depends entirely on the goods: grocery and fresh food turn 10-20+ times a year, furniture or machinery dealers perhaps 2-4. Perishability, margin and stock-out cost set the right range. Compare against your industry and your own history — this tool measures you against a target you set.

Why use COGS instead of sales revenue?

Inventory is valued at cost, so the numerator must also be at cost. Using revenue (which includes markup) inflates the ratio and makes periods with different margins incomparable. COGS keeps both sides of the division in the same units.

Is higher turnover always better?

No. Extremely high turnover can mean chronic stock-outs, lost sales and expensive rush replenishment. The goal is enough stock to serve demand profitably — the excess-inventory figure here targets the cash trapped beyond your chosen operating level, not a drive to zero.

How can a business improve turnover?

Tighter demand forecasting, smaller and more frequent orders, clearing slow movers with markdowns before they age further, and fixing the assortment: a small share of SKUs usually accounts for most of the stuck value. The days-in-inventory number tells you whether changes are working.

What is the difference between turnover and sell-through?

Turnover measures how many times average inventory value sells in a period across the whole assortment. Sell-through is unit-based for a specific product or season: units sold divided by units received. Retailers use sell-through for buying decisions and turnover for financial health.

How do I calculate turnover for a single product instead of the whole business?

Use the same formula with product-level figures: that product's cost of goods sold for the period divided by its average inventory value over the same period. Product-level turnover is often more useful than the company average, because a healthy overall ratio can hide a long tail of slow items sitting behind a few fast sellers.

Formula-Based Calculator · By QalcTools Editorial Team. Formulas tested against independent reference values · Content reviewed November 2026 by the QalcTools Editorial Team.

Methodology note: Standard financial ratio analysis definitions (turnover on COGS over average inventory) as used in corporate financial statement analysis.

Related calculators

Category: Business & Commercial Calculators

About this calculator

Inventory earns nothing while it sits. Every dollar on the shelf is a dollar that cannot pay a bill, fund marketing or reduce a loan — yet too little stock means empty shelves and lost sales. The turnover ratio threads that needle: it counts how many times your average inventory sells through in a year, measured properly on cost rather than on marked-up selling prices. This calculator adds the two translations managers actually act on — how many days stock sits before selling, and, against a target turnover you set, how many dollars of inventory are excess and could be converted back into cash.

How it works

Enter annual cost of goods sold and the inventory values at the start and end of the period. The tool averages the two balances, because stock is bought and sold continuously and neither endpoint alone represents the year. Dividing cost of goods sold by that average gives the turnover ratio; dividing 365 by the ratio gives days in inventory, the average shelf life of a dollar of stock. Finally it works backwards from your target turnover: cost of goods sold divided by the target is the average inventory that turnover would require, and any amount your actual average sits above it is reported as excess inventory.

The formula, explained

Average inventory = (Beginning + Ending) ÷ 2; Turnover = COGS ÷ Average inventory; Days in inventory = 365 ÷ Turnover; Excess = Average − (COGS ÷ Target turnover), when positive

The engine floors every input at zero, averages the beginning and ending balances, and divides cost of goods sold by that average, returning zero turnover if the average is zero. Days in inventory is 365 divided by the unrounded turnover. The target average is cost of goods sold divided by your target turnover (zero when no target is entered), and excess inventory is the actual average minus the target average, floored at zero so an under-stocked position never shows a negative excess. The ratio is rounded to two decimals, days to one decimal, and dollar figures to whole dollars.

Inputs and variables

VariableMeaningExample
Cost of Goods Sold (Annual)The cost, not the selling price, of everything sold in the year. Using cost keeps the numerator on the same basis as the inventory values it is divided by.$600,000 per year
Beginning InventoryThe value of stock on hand at the start of the period, at cost. Together with the ending balance it forms the average the ratio is measured against.$90,000
Ending InventoryThe value of stock on hand at the end of the period, at cost. A rising balance against flat sales is the classic early warning this ratio surfaces.$110,000
Your Target TurnoverThe sell-through speed you want to operate at, chosen for your goods and margins. It sets the target average inventory and therefore the excess figure.7.5× per year

Worked example

A retailer records $600,000 of annual cost of goods sold, began the year with $90,000 of inventory and ended with $110,000, and sets a target turnover of 7.5 times a year.

  1. Average inventory: ($90,000 + $110,000) ÷ 2 = $100,000.
  2. Turnover: $600,000 ÷ $100,000 = 6.0 times per year. Days in inventory: 365 ÷ 6.0 = 60.8 days.
  3. Average inventory at the 7.5× target: $600,000 ÷ 7.5 = $80,000.
  4. Excess inventory: $100,000 − $80,000 = $20,000 of stock value above the operating level the target implies.

Turnover of 6.0× per year on $100,000 of average inventory, 60.8 days in inventory, and $20,000 of excess inventory against a 7.5× target that would need only $80,000 on average.

Sixty days is the figure a warehouse team can feel: on average, a dollar of stock waits two months to become a sale, and during that wait it is exposed to shrinkage, damage, obsolescence and storage cost. The $20,000 excess is the actionable number — it is cash that faster-moving assortment decisions, smaller reorder quantities or clearing slow lines could release without changing sales at all. Whether 6.0× is good depends on the goods: comfortable for furniture, sluggish for packaged food, which is why the target is yours to set.

Understanding your results

Turnover and days are the same fact in two dialects: the ratio suits financial comparison across periods and businesses, while days suit operations, because purchasing and shelf decisions are made in days. Watch them move together over several periods rather than judging one reading — a single year-end count, a seasonal build-up or a one-off bulk buy can distort a lone snapshot in either direction.

The excess figure deserves a careful read. It is measured against your target, not against zero: it estimates the stock beyond the level your chosen operating speed requires, which is the portion that could realistically be released as cash. It is not a instruction to dump inventory — cutting the fastest lines would raise turnover while costing sales — but a sizing of what slow stock is costing the business in trapped capital.

Assumptions and limitations

Two balance-sheet snapshots stand in for a true average here, and for a seasonal business that approximation can mislead badly: inventory counted right after a holiday clear-out and right before a stock-up will average to something the business rarely held. Averaging monthly balances gives a fairer denominator when they are available. The calculation also aggregates the whole assortment into one ratio, so a healthy average can hide a tail of dead stock behind a few fast lines, and the result depends on how inventory and cost of goods sold are valued under your accounting method. Use the ratio to direct attention, then work at product level to act on it.

Common mistakes to avoid

Sources