How many times a year does your inventory renew? The inventory turnover answers in a number: how many times, in the period, you have sold and rebuilt the stock. It is the key indicator of inventory efficiency: a high turnover means stock that sells quickly and little capital tied up; a low one means goods sitting and liquidity blocked. This calculator determines the turnover ratio, the days inventory outstanding (DIO) and the share of inventory over the cost of goods. It is the essential tool for retail, e-commerce and manufacturing.

What inventory turnover is

The inventory turnover is the number of times, in a period, the stock is sold and rebuilt. It is calculated by dividing the cost of goods sold (COGS) by the average inventory. With €800,000 of annual COGS and €200,000 of average inventory, the turnover is 4: the inventory renews 4 times a year. It is a measure of operational efficiency: the higher it is, the faster the stock turns into sales, and the less capital stays blocked in unsold goods.

Why turnover is important

Inventory is capital tied up: money spent on goods that have not yet become revenue. A low turnover means excess stock, obsolescence risk, storage costs and blocked liquidity. A high turnover frees up capital and reduces risks, but if too high it may signal insufficient stock and lost sales from stockouts. The optimal balance depends on the sector. That is why turnover is a key indicator for those who manage inventory: it measures how well the warehouse works.

How turnover is calculated

The formula is: turnover = cost of goods sold / average inventory. The cost of goods sold (COGS) is the cost of the goods actually sold in the period, from the income statement. The average inventory is the average between beginning and ending inventory of the period: (beginning + ending) / 2, to smooth seasonal swings. It is important to use the cost of goods and not the revenue: inventory is valued at cost, so the comparison must be made at cost, otherwise the turnover is inflated by the margin.

The average inventory

The average inventory is the average between the inventory at the beginning and at the end of the period. Using the average, instead of the ending balance alone, reduces the effect of seasonal peaks: a company that closes the year with a full warehouse for the next season would have a distorted turnover using only the ending figure. With €180,000 beginning and €220,000 ending, the average inventory is €200,000. It is the denominator of the turnover and the basis for calculating the days of inventory.

The days inventory outstanding (DIO)

The days inventory outstanding (DIO) translate the turnover into days: how many days on average the goods stay in the warehouse before being sold. They are calculated as days in the period divided by the turnover. A turnover of 4 corresponds to a DIO of about 91 days (365 / 4): on average goods stay on the shelf three months. It is the most intuitive indicator for those who think in time: fewer days of inventory means a more efficient warehouse and capital freed up faster.

The daily cost of goods sold

The daily cost of goods sold is the COGS divided by the days in the period: how much value of goods, at cost, leaves the warehouse each day on average. On €800,000 a year, it is about €2,192 a day. It serves to translate the days of inventory into money and to size the warehouse: every extra day of inventory equals a day of cost of goods tied up in stock. It is the bridge between the measure in days (DIO) and the capital blocked in inventory.

The inventory as a percentage of COGS

The inventory to cost of goods ratio measures how much capital is tied up in stock relative to the volume of goods sold. A value of 25% means the average inventory is worth a quarter of the annual COGS, consistent with a turnover of 4. The lower the ratio, the more efficient the use of capital: you sell a lot with little stock. It is useful for comparisons between companies and over time, because it relates the inventory to the volume of activity and not to absolute values.

How the calculator works

Enter the cost of goods sold, the beginning and ending inventory and the days in the period. The calculator determines the average inventory, the turnover ratio, the days inventory outstanding, the daily cost of goods sold and the share of inventory over the COGS. The verdict tells you whether the inventory is very fast, good, average or slow. It is the quickest way to measure inventory efficiency and understand how much capital you have tied up in stock.

The values you need

The cost of goods sold (COGS) is read from the income statement: it is the cost of the goods sold in the period. The beginning and ending inventory are read from the balance sheet at the beginning and end of the period, valued at cost. The days are those of the COGS period (365 for the year, 90 for a quarter). Use consistent values among COGS, inventory and days for a correct result: all at cost, not at selling price.

Interpreting the days of inventory

How to read the days inventory outstanding (DIO):

The ideal reference depends on the sector: food and fashion turn quickly, durables and jewelry much more slowly.

Turnover and days of inventory

Turnover and DIO are the inverse of each other (DIO = days / turnover):

The higher the turnover, the fewer days the goods stay in the warehouse: the stock turns into sales faster.

Example: same COGS, different inventory

With an annual cost of goods sold of €800,000, how turnover and inventory days change:

At the same sales, the lower the stock, the higher the turnover and the less capital tied up in inventory.

How to improve the turnover

Several levers increase the turnover. Reduce excess stock and slow-moving products. Improve demand forecasting to order the right quantities. Adopt just-in-time or more frequent and smaller reorders. Liquidate the unsold with discounts before it becomes obsolete. Analyze the mix and focus on the products that turn. Beware of overdoing it: a turnover that is too high risks stockouts and lost sales. The goal is the balance between efficiency and availability.

Turnover, DSO and the cash cycle

The DIO is one of the three elements of the cash conversion cycle. The DIO measures how long the inventory stays unsold; the DSO (Days Sales Outstanding) how long you take to collect from customers; the DPO (Days Payable Outstanding) how long you take to pay suppliers. Cash cycle = DIO + DSO − DPO. Reducing the DIO shortens the cash cycle and frees up liquidity. A slow inventory lengthens the cycle and blocks capital: the turnover is the most direct operational lever to speed it up.

What the calculation does not consider

The calculator uses the cost of goods and inventory at value: it assumes a consistent inventory valuation (FIFO, LIFO or average cost). It uses the average of two extremes (beginning and end), which may not capture the intra-period swings of a seasonal business. It does not distinguish slow-moving or obsolete products from those that turn well: the average turnover can hide dead stock. It does not consider storage costs nor stockouts. It is a managerial estimate to orient decisions.

Common mistakes

• Using revenue instead of the cost of goods sold (inflates the turnover with the margin).
• Using only the ending inventory instead of the average (distorts with seasonality).
• Comparing the turnover between different sectors (food and jewelry are not comparable).
• Ignoring obsolete products: the average turnover hides dead stock.
• Aiming for maximum turnover, ignoring the risk of stockouts.

How to use the calculator

Enter the cost of goods sold, the beginning and ending inventory and the days in the period. Read the average inventory, the turnover, the days of inventory, the daily cost and the share over the COGS. Compare the DIO with the references of your sector. Try reducing the inventory to see how the turnover rises and the days fall. It is the quickest way to measure inventory efficiency and set a concrete stock reduction target.

Practical example

Your company has €800,000 of annual cost of goods sold, €180,000 of beginning inventory, €220,000 ending and 365 days. The result: average inventory €200,000, a turnover ratio of 4 times a year, 91 days of inventory, a daily cost of goods sold of €2,192 and an inventory equal to 25% of COGS, with the verdict "average: acceptable turnover, room to improve". By bringing the turnover to 6 (DIO 61 days) you would free up about €67,000 of capital. Enter your numbers for your real situation. The calculation uses values at cost and the average of two extremes; it does not distinguish slow-moving products nor storage costs. It is an informational managerial estimate, not financial advice.

Frequently asked questions

What is inventory turnover?

It is the number of times, in a period, the stock is sold and rebuilt. It is calculated by dividing the cost of goods sold by the average inventory. A turnover of 4 means the inventory renews 4 times a year.

How is inventory turnover calculated?

Turnover = cost of goods sold / average inventory. With €800,000 of COGS and €200,000 of average inventory: 800,000 / 200,000 = 4 times. The average inventory is the average between beginning and ending.

What is days inventory outstanding (DIO)?

It is the days the goods stay on average in the warehouse before being sold: days in the period divided by the turnover. A turnover of 4 corresponds to a DIO of about 91 days (365 / 4).

Should I use revenue or cost of goods sold?

The cost of goods sold (COGS), not the revenue. Inventory is valued at cost, so the comparison must be made at cost. Using revenue inflates the turnover with the margin, giving an artificially high value.

Why use average inventory?

Because the ending balance alone can be distorted by seasonality: a company that closes the year with a full warehouse for the next season would have a skewed turnover. The average between beginning and ending smooths these swings.

What is a good inventory turnover?

It depends a lot on the sector. Food and fashion turn quickly (high turnover, low DIO); durables, furniture and jewelry much more slowly. Compare your turnover with that of competitors in the same sector, not between different sectors.

Is a higher turnover always better?

Not necessarily. A high turnover frees up capital and reduces obsolescence, but if too high it may indicate insufficient stock and lost sales from stockouts. The goal is the balance between efficiency and product availability.

How do you reduce the days (increase the turnover)?

By reducing excess stock, improving demand forecasting, adopting more frequent and smaller reorders, liquidating the unsold before it becomes obsolete and focusing on the products that turn well. Even small improvements free up capital.

What does turnover have to do with the cash cycle?

The DIO is one of the three components of the cash conversion cycle: DIO + DSO − DPO. Reducing the days of inventory shortens the cash cycle and frees up liquidity. A slow inventory blocks capital and lengthens the time to turn sales into cash.

Does the calculation distinguish obsolete products?

No, it uses the total inventory value. The average turnover can hide slow-moving or obsolete products (dead stock) mixed with products that turn well. For a precise analysis you need the turnover per single product or category.

Does it work for periods other than the year?

Yes: enter the days of the period of your data (90 for a quarter, 30 for a month) with consistent COGS and inventory. The calculator adapts the days of inventory to the indicated period.

Does it work for any country and currency?

Yes, the calculation is universal and uses the values and currency you enter. Inventory turnover and days of inventory are standard managerial concepts valid everywhere; the turnover is a pure number, the days are in days.

Updated July 2026