Inventory Turnover Calculator

How this inventory turnover calculator works

Enter your cost of goods sold (COGS) for the period — typically a year — along with your beginning and ending inventory values, both valued at cost. The calculator averages the two inventory figures, divides your COGS by that average to get your turnover ratio, and then converts that ratio into days inventory outstanding (DIO), the average number of days a dollar of inventory sits in stock before it's sold. All three figures update instantly as you type, and the calculator flags when your inputs can't produce a meaningful ratio — for example, if both beginning and ending inventory are zero.

The exact formulas

Average inventory is (beginning inventory + ending inventory) ÷ 2. Inventory turnover is annual COGS ÷ average inventory — it tells you how many times, on average, your entire inventory balance was sold and replaced during the period. Days inventory outstanding converts that ratio into a time figure: DIO = 365 ÷ turnover. A higher turnover ratio corresponds to a lower DIO, and vice versa — they're two ways of expressing the exact same underlying speed of inventory movement, one as a frequency, the other as a duration.

A worked example

Suppose a business had $500,000 in cost of goods sold over the year, started the year with $80,000 of inventory (at cost), and ended the year with $120,000. Average inventory = ($80,000 + $120,000) ÷ 2 = $100,000. Turnover = $500,000 ÷ $100,000 = 5.0× — the business sold and replaced its entire inventory balance five times over the year. Days inventory outstanding = 365 ÷ 5.0 = 73 days — on average, a dollar of inventory sat on the shelf (or in the warehouse) for about 73 days before it sold. Those two numbers, 5.0× and 73 days, describe the exact same underlying reality from two different angles.

Why inventory turnover matters

Inventory sitting in a warehouse is cash that isn't earning a return, and it carries real ongoing costs — storage, insurance, financing, shrinkage, and the risk that it becomes obsolete or has to be discounted to move. Turnover and DIO turn that abstract risk into a concrete, trackable number: a business that turns inventory 12 times a year (DIO ≈ 30 days) has its cash cycle back in about a month, while one that turns it twice a year (DIO ≈ 183 days) has capital locked up for roughly six months per cycle. Lenders and investors look at turnover trends to judge how efficiently a company manages working capital, and operators use it internally to catch slow-moving categories before they become write-offs. Because the "right" number varies enormously by industry — fresh groceries and fast fashion sell through in days or weeks, while furniture, jewelry and industrial equipment can reasonably sit for months — the most useful comparison is usually your own ratio over time or against direct competitors, not a single universal benchmark.

Common mistakes and limitations

The most common error is using ending inventory alone instead of an average — ending inventory is a single snapshot that can be skewed by a bulk purchase just before period-end, a seasonal restock, or a temporary stockout, and using it alone can make turnover look artificially high or low. A second mistake is mismatching the valuation basis — COGS is a cost figure, so beginning and ending inventory must also be valued at cost, not at retail selling price; mixing the two produces a ratio that looks reasonable but means nothing. A third mistake is comparing turnover ratios across companies in different industries as if a single "good" number exists everywhere — it doesn't. Finally, this calculator uses a simple two-point average (beginning and ending); if your inventory swings heavily within the year — a strongly seasonal business, for instance — a more granular average using several points throughout the year (monthly or quarterly) will give a more accurate picture than the two-point method alone.

Turnover by category, and why one blended number can mislead

A single company-wide turnover ratio can hide very different realities across product lines. A retailer might carry a fast-moving core catalog turning 10 times a year alongside a long tail of slow, seasonal or discontinued items turning less than once a year — blended together, the overall ratio can look perfectly healthy while a meaningful chunk of capital sits frozen in stock that barely moves. Calculating turnover separately for major categories, or even individual SKUs above a certain value, surfaces this kind of hidden imbalance far earlier than a single blended figure ever will, and it's a standard practice in inventory-heavy businesses precisely because the average conceals more than it reveals once a catalog has any real spread in sell-through speed.

Turnover, cash flow, and the operating cycle

Inventory turnover is one leg of a business's broader cash conversion cycle — the time between paying cash out for inventory and collecting cash in from the eventual sale. A shorter DIO, paired with reasonable payment terms from suppliers and prompt collection from customers, means less of a business's own cash is tied up funding the gap between purchase and sale; a business that turns inventory in 30 days but pays suppliers on 60-day terms can, in effect, sell the goods and collect the cash before its own supplier invoice is even due. Conversely, a long DIO combined with tight supplier terms is a classic recipe for a cash squeeze even in a business that is nominally profitable on paper — profit and cash are not the same thing, and slow-moving inventory is one of the most common reasons a profitable-looking business runs short on cash. Tracking DIO alongside accounts receivable and payable days gives a much fuller picture of a company's working-capital health than any one of the three numbers alone.