Skip to content
UseCalcNow
Finance

Inventory Turnover Calculator — Turns & Days on Hand

Enter COGS and inventory levels to calculate your inventory turnover ratio, days of inventory on hand, and how your number stacks up by industry.

About This Calculator

Inventory turnover tells you how many times your business sells through its average stock in a period, and it is one of the clearest signals of operational health on the balance sheet. This calculator divides your cost of goods sold by average inventory, then converts the result into days of inventory on hand so you can see how long cash sits on shelves. A ratio of 4.55 turns with the default inputs, for example, means inventory cycles roughly every 80 days. Compare your number against the industry benchmarks below to judge whether your purchasing, pricing, and stock mix are working together.

The Formula Behind This Calculator

The core formula is inventory turnover = COGS ÷ average inventory, where average inventory = (beginning inventory + ending inventory) ÷ 2. The calculator runs both steps: it averages your opening and closing stock, divides your cost of goods sold by that figure, and reports the ratio rounded to two decimals. It then divides the period length you select (365, 91, or 30 days) by the turnover ratio to produce days of inventory on hand — how long an average dollar of stock waits before being sold. The averaging step matters because a single point-in-time inventory snapshot can be distorted by seasonal buying, so most analysts use at least a two-point average; for volatile businesses, a 13-point monthly average gives a steadier denominator.

Understanding the math helps you verify results and make better decisions for your project.

How to Use

  1. 1Pull cost of goods sold from your income statement for a full period — a year works best for benchmarking.
  2. 2Enter beginning inventory (the balance at the start of the period) and ending inventory (the closing balance) from your balance sheet.
  3. 3Pick the period length — annual for standard benchmarks, quarterly or monthly for tighter operational tracking.
  4. 4Read the ratio: 4.55 turns means you sold and replaced your entire stock 4.55 times; higher is generally better up to the stockout line.
  5. 5Use the days-on-hand figure to plan reorder points and to compare against supplier lead times and shelf life.

When to Use

  • →Preparing monthly or quarterly management accounts and tracking whether stock efficiency is improving.
  • →Benchmarking your business against industry averages before a lender meeting or valuation discussion.
  • →Deciding whether slow-moving categories need markdowns, bundle deals, or tighter purchasing.
  • →Reviewing a potential acquisition or supplier whose inventory position looks unusual.

Tips

  • ✓Use COGS, never sales revenue, in the numerator — revenue inflates the ratio by your markup percentage and makes cross-company comparison meaningless.
  • ✓Match the period precisely: if COGS covers 12 months, beginning inventory should be the balance exactly 12 months before the ending date.
  • ✓A falling ratio across several quarters usually points to over-ordering or shrinking demand — check both before cutting prices.
  • ✓Very high turnover can be a problem too: it often signals stockouts, lost sales, and expensive emergency replenishment.
  • ✓Segment the calculation by category; a blended 6-turn average can hide a 12-turn grocery aisle dragging along a 1-turn equipment line.

What Inventory Turnover Measures

Inventory turnover counts how many times a business sells and replaces its average stock during a period. Four turns means the entire shelf clears and refills four times a year; twelve turns means the cycle repeats monthly. Because inventory ties up cash that earns nothing while it sits, the ratio is one of the fastest ways to judge whether working capital is being used well.

The metric matters to more than operations teams. Lenders review it when sizing working capital lines, buyers use it during due diligence, and investors watch the trend because a steady slide from 6 turns to 4 turns often precedes margin trouble and forced markdowns. The numerator comes straight off the income statement — a COGS calculator isolates that figure from revenue and operating costs if your statements do not break it out.

Turnover also feeds directly into return-on-assets style analysis. DuPont decomposition splits return on equity into margin, asset turnover, and leverage, and inventory is usually the largest current asset a product business holds — so a one-turn improvement shows up quickly in the overall asset efficiency picture. Managers who lift turns without hurting fill rates effectively raise the return on every dollar the balance sheet carries.

The Formula and Why Averaging Matters

The calculation runs in two steps. First, average inventory = (beginning inventory + ending inventory) ÷ 2 — with the default inputs, (100,000 + 120,000) ÷ 2 = 110,000. Second, turnover = COGS ÷ average inventory, so 500,000 ÷ 110,000 = 4.55 turns per year, which the calculator also converts to about 80 days of stock on hand.

The averaging step exists because point-in-time inventory balances swing with the seasons. A garden center measured in March carries a fraction of its November stock, so a single snapshot would make the March ratio look heroic and the November ratio look lazy for the same business.

For businesses with monthly data, a 13-point average (each month-end balance plus the starting balance, divided by 13) smooths the swings further. The two-point average used here is the standard convention in textbooks and annual reports, so your result stays comparable with published benchmarks.

What Counts as a Good Turnover Ratio

Benchmarks only make sense within an industry. Perishable retail runs hot: grocery chains commonly post 12–20 turns, which works out to roughly 18–30 days of stock on hand. Apparel retailers sit near 4–6 turns (about 60–90 days), home improvement stores run 4–7, and industrial manufacturers cluster around 4–8.

Slow-turn sectors are not automatically unhealthy. Heavy equipment dealers, jewelers, and boat sellers often run 2–3 turns, but their gross margins are wide enough that each sale still pays for months of carrying cost. Speed and margin trade off against each other, which is why the profitability section below pairs turnover with margin instead of judging speed alone.

The trend matters more than the level. A business holding steady at 4.5 turns for three years is in better shape than one sliding from 7 to 5 to 4, whatever the industry average says. Run the calculator on several consecutive periods before drawing conclusions.

Days of Inventory on Hand

Dividing the period length by the turnover ratio flips it into days: 365 ÷ 4.55 = about 80 days of inventory on hand. The days framing is easier to act on because it can be compared directly against supplier lead times, shelf lives, and payment terms. If stock sits 80 days but suppliers deliver in 30 days and payment is due in 45, the timing works; if those numbers invert, cash gets squeezed.

Analysts call this metric DIO, and it appears as a component inside the cash conversion cycle discussed below. A dedicated days inventory outstanding calculator works the problem from the days side if you need that figure as the primary output rather than a by-product of the ratio.

Days on hand also sets the floor for how lean a business can run. Safety stock, minimum order quantities, and supplier reliability together determine the lowest achievable days figure; pushing below it produces empty shelves rather than efficiency. Many retailers treat 30–45 days as a practical floor for general merchandise, while pharmacies and food retailers operate at 15–25 days using daily deliveries and dense supplier networks.

Practical Levers for Turning Stock Faster

Purchasing discipline moves the ratio fastest. Ordering smaller lots more often cuts average stock without cutting sales, though it raises freight costs and order admin — the EOQ calculator finds the order size that balances those two forces instead of guessing at it.

Lead time is the second lever. Every day a supplier shaves off delivery lets you hold roughly one day less of safety stock. Before renegotiating anything, measure actual supplier performance with a lead time calculator so the conversation starts from data rather than impressions.

On the demand side, markdowns, bundles, and better forecasts clear slow movers, and SKU rationalization stops repurchasing items that never turn. The classic mistake is treating a one-time clearance sale as an efficiency gain — it lifts the ratio for a quarter and returns nothing if the buying pattern that caused the buildup continues.

Margin Buys Speed: The Profitability Pair

Turnover alone says nothing about profit per sale. A 50% margin turning twice a year earns the same annual gross profit per dollar of inventory as a 25% margin turning four times — both return $1.00 per year per inventory dollar. GMROI (gross margin return on inventory investment) makes that product explicit, and a GMROI calculator handles the full version with category benchmarks.

This pairing explains why discounting to chase turns can backfire. Cutting price 10 points might lift turns from 4 to 5, but if the margin fell from 40% to 30%, annual profit per inventory dollar dropped from $1.60 to $1.50 — more movement, less money. Rerun the margin math before celebrating a faster ratio, using your gross margin calculator figures alongside this tool.

Benchmarks exist for the pair as well. General merchandise retailers commonly target GMROI above 2.0, meaning every dollar invested in inventory returns at least two dollars of gross profit per year. At a 30% margin that target implies roughly 7 turns, while a 45% margin business reaches the same return at about 4.5 turns. The two numbers are always best read together.

Turnover Inside the Cash Conversion Cycle

Inventory days is one of three timing components that determine how long a dollar is trapped between paying suppliers and collecting from customers. The cash conversion cycle adds days inventory outstanding plus receivable days, then subtracts the days payable outstanding. With 80 inventory days, 45 receivable days, and 30 payable days, the cycle runs 95 days — cash goes out and comes back a full quarter later.

That framing shows why the same turnover ratio can feel different across businesses. Two companies at 4.5 turns have identical inventory days, but the one collecting in 30 days and paying in 45 funds its stock almost entirely with supplier credit, while the one collecting in 60 and paying in 30 needs a working capital line. A cash conversion cycle calculator combines all three into the single net number lenders look at.

Accounting Choices, Valuation, and Comparisons

Inventory method quietly distorts cross-company comparisons. In inflationary stretches, a business using FIFO sends older, cheaper costs through COGS, which lifts margin and slightly lowers the measured turnover ratio relative to weighted average. When benchmarking against a competitor, check the inventory method footnote first — a FIFO inventory calculator shows how cost layers flow differently under each convention.

Valuation work leans on the ratio too. Buyers often price inventory-heavy businesses as a multiple of earnings, and a deteriorating turnover trend lowers what they will pay because working capital needs will grow after the deal. A business valuation calculator treats working capital as an explicit input, and inventory efficiency is what feeds it.

For internal reporting, run the ratio quarterly by category rather than once a year company-wide. The blended number hides the spread between fast and dead stock, and purchasing decisions get made at the category level anyway.

FAQ

What is a good inventory turnover ratio?

It depends on the industry. Grocery and convenience retail run 12–20 turns because food spoils fast; apparel sits around 4–6; industrial manufacturing runs 4–8; heavy equipment and jewelry can sit at 2–3 and still be healthy because margins are wide. Judge your ratio against direct competitors, not the whole market.

Should I use revenue or COGS in the formula?

Use COGS. Inventory on the balance sheet is recorded at cost, so dividing cost by cost keeps both sides consistent. Dividing revenue by inventory inflates the result by your markup — a business with a 50% margin would look 2 turns faster than it really is.

Why average inventory instead of ending inventory?

Ending inventory is a single snapshot that seasonal peaks distort. A retailer measured right after the holidays looks artificially lean; measured in November, bloated. Averaging the beginning and ending balances smooths this out, and using monthly balances for a 13-point average is even better when the data exists.

How is days of inventory on hand calculated?

Divide the period length by the turnover ratio: 365 ÷ 4.55 turns gives about 80 days. Days on hand is the mirror image of the ratio — the same information expressed as time, which is easier to compare against supplier lead times and product shelf life.

Can inventory turnover be too high?

Yes. A ratio far above your industry norm combined with frequent stockouts means you are under-buying. Every missed sale costs margin, and rush freight to cover gaps eats the savings from carrying less stock. The target is the highest ratio that still keeps fill rates near 98–99%.

How does the inventory accounting method affect the ratio?

FIFO, LIFO, and weighted average push different costs into COGS. During inflation, FIFO sends older, cheaper costs through COGS, which lifts reported margin and slightly lowers the measured turnover ratio versus weighted average. Comparisons are cleanest when both companies use the same method.

Related Calculators