Inventory Turnover Calculator

Inventory turnover measures how many times the average inventory balance is sold or used through cost of goods sold during a reporting period. It is an efficiency ratio, but interpretation requires care: a higher ratio can indicate faster movement, while an excessively lean inventory position can also create stockouts and lost sales.

How to use the Inventory Turnover Calculator

Enter cost of goods sold for the reporting period. Then choose how you want to supply average inventory.

If you only have beginning and ending inventory, use the default method. The calculator averages those two values. If you already have a more representative average—perhaps from monthly balances, weekly balances, or an internal inventory report—choose Average inventory already known and enter it directly.

The reporting-period setting is used for days inventory on hand and annualized turnover. For a full year, 365 days is a common choice, while some financial analyses use 360. For a quarter, month, or custom period, select the matching number of days so the time-based outputs remain consistent.

The currency selector changes display only. COGS and inventory must be entered in the same currency and on the same cost basis.

What does inventory turnover mean?

Inventory turnover compares the cost of inventory sold during a period with the average inventory held during that same period. A turnover ratio of 4 over a year means the company's average inventory balance was turned over approximately four times during that year.

It does not mean every SKU turned exactly four times. One product may sell weekly while another sits for months. The company-wide ratio is an aggregate average.

Inventory turnover is often used to evaluate inventory efficiency, purchasing, merchandising, production planning, liquidity, and the risk of excess or obsolete stock.

Inventory turnover formula

The standard cost-based formula is:

If annual COGS is 280,000 and representative average inventory is 70,000:

The numerator and denominator must describe the same period and accounting scope.

How to calculate average inventory

A common shortcut uses beginning and ending inventory:

If beginning inventory is 65,000 and ending inventory is 75,000, the two-point average is 70,000.

This shortcut is easy because beginning and ending balance-sheet values are often available. But two points do not always represent the inventory held throughout the period.

If inventory is seasonal, grows rapidly, declines sharply, or fluctuates materially, an average based on monthly, weekly, or other representative balances can provide a more meaningful denominator. This is why the calculator offers a direct-average mode instead of forcing the two-point shortcut.

Why inventory turnover normally uses COGS instead of sales

Inventory on the balance sheet is generally recorded at cost, not at selling price. Cost of goods sold is also measured at cost. Using COGS therefore compares two cost-based amounts.

Using sales revenue in the numerator mixes a selling-price figure with a cost-based inventory figure and can overstate the apparent number of turns when products are sold above cost.

For example, suppose average inventory is 200,000, COGS is 600,000, and sales are 800,000. The cost-based turnover is 3.0. Using sales would produce 4.0, but that larger figure partly reflects markup rather than faster physical or cost turnover.

Some analytical sources or industries may report a sales-based variant. If you encounter one, label it clearly and do not compare it directly with a COGS-based ratio without understanding the definition.

Days inventory on hand

Inventory turnover can be converted into an average number of days per turn:

With annual turnover of 4 and a 365-day year:

This is an average. It does not mean every unit spends exactly 91.25 days in inventory.

Days inventory is sometimes called days' sales in inventory, days inventory outstanding, or days to sell inventory. Definitions can vary slightly between contexts, so use consistent formulas when comparing results.

Annualizing turnover from a shorter reporting period

A turnover ratio calculated from one quarter of COGS and one quarter's representative average inventory describes that quarter. Comparing it directly with a full-year turnover ratio is misleading because the time windows differ.

The calculator therefore reports an annualized equivalent:

If a 90-day period produces turnover of 1.2, the simple annualized equivalent is approximately 4.87 turns per 365 days.

Annualization assumes the period's pace continues. That can be unrealistic for seasonal businesses, promotional periods, or rapidly changing inventory. Use it as a normalization tool, not a forecast guarantee.

How to interpret a high or low turnover ratio

A higher turnover ratio can indicate that inventory is moving efficiently and less capital is tied up in stock. It can also reduce exposure to storage cost, spoilage, fashion risk, and obsolescence.

But higher is not automatically better. Inventory that is too lean can create stockouts, missed sales, production interruptions, expedited replenishment costs, or poor customer experience.

A lower ratio can indicate slow-moving or excess inventory, but it may also reflect deliberate safety stock, long replenishment lead times, seasonality, bulk buying, or the nature of the industry.

There is no universal “good” inventory turnover ratio. Compare against your own history, relevant products, realistic service levels, business model, and comparable industry definitions.

Seasonality can distort average inventory

Consider a retailer that builds inventory heavily before a holiday season and ends its fiscal year soon after selling down that stock. Beginning and ending balances may both be relatively low even though inventory was much higher for several months.

Using only those two dates can understate average inventory and therefore overstate turnover.

A more representative average can be calculated from several inventory observations throughout the period. For example, averaging beginning inventory plus twelve month-end balances gives thirteen points rather than two.

The best sampling frequency depends on how volatile inventory is and what data are available.

Company-wide turnover can hide slow-moving SKUs

An aggregate turnover ratio blends products together. A few fast-moving products can make the overall ratio look healthy while other items remain in stock for a long time.

For operational decisions, calculate turnover at a category, brand, location, or SKU level when the data support it. At unit level, a useful approximation is units sold during the period divided by average units in inventory during that period.

Segment-level analysis can identify slow-moving inventory that disappears inside a company-wide average.

Worked inventory turnover examples

What can increase or decrease inventory turnover?

Turnover can rise when sales demand strengthens, purchasing becomes more responsive, replenishment lead times shorten, obsolete stock is reduced, forecasting improves, or the product mix shifts toward faster-moving items.

It can fall when inventory is built ahead of demand, sales slow, products become obsolete, safety-stock targets rise, lead times worsen, or the business intentionally prepares for a seasonal peak.

Changes in COGS valuation, inventory accounting, acquisitions, product mix, and classification can also affect the ratio. Use consistent accounting definitions across comparison periods.

Common inventory turnover mistakes

Using sales instead of COGS without labeling the variant. Standard turnover normally compares COGS with inventory because both are cost-based.

Using ending inventory only. A point-in-time balance may not represent inventory held throughout the period.

Mixing periods. Annual COGS should not be divided by a quarterly average inventory unless the scope is intentionally normalized.

Ignoring seasonality. Beginning and ending balances can be unrepresentative in seasonal businesses.

Comparing ratios built with different accounting definitions. Inventory costing and COGS classifications can affect comparability.

Assuming higher turnover is always better. Excessively lean inventory can cause stockouts and lost sales.

Relying only on company-wide averages. Slow-moving SKUs can be hidden by fast-moving products.

Frequently asked questions

What is the inventory turnover formula?

Inventory Turnover = Cost of Goods Sold / Average Inventory.

How do I calculate average inventory?

A common shortcut is (Beginning Inventory + Ending Inventory) / 2. If inventory changes materially during the period, an average from more frequent balances can be more representative.

Should I use sales or COGS?

COGS is generally preferred for the standard inventory turnover ratio because both COGS and inventory are measured at cost.

What is days inventory on hand?

It is the reporting-period days divided by the inventory turnover ratio, giving an average number of days represented by one inventory turn.

Can inventory turnover be zero?

Yes. If COGS is zero while average inventory is positive, turnover is zero for the selected period.

What if average inventory is zero?

The ratio is undefined because COGS cannot be divided by zero average inventory.

What is a good inventory turnover ratio?

There is no universal target. Appropriate turnover varies by industry, product life cycle, lead time, service level, seasonality, and business model.

Why might my annualized turnover be misleading?

Annualization assumes a shorter period continues at the same pace. Seasonal or unusual periods may not represent the rest of the year.