Boneyard Tools

Inventory Turnover Calculator

See how quickly your stock sells through. Enter your cost of goods sold (COGS) and your average inventory value to get the inventory turnover ratio and the average days inventory outstanding.

How to calculate inventory turnover

  1. Enter your cost of goods sold (COGS) for the period.
  2. Enter your average inventory value at cost (typically beginning plus ending inventory, divided by two).
  3. Read the turnover ratio and days inventory outstanding; set the period to 90 days for a quarter.

Examples

Annual turnover

COGS 500,000 and average inventory 100,000 over 365 days
Turnover ratio 5.0 and days inventory outstanding 73

Frequently asked questions

How is inventory turnover calculated?

Inventory turnover ratio is cost of goods sold (COGS) divided by average inventory value at cost. Days inventory outstanding is the period length (365 days by default) divided by that ratio, so it shows the average number of days stock sits before it sells.

What is a good inventory turnover ratio?

It depends heavily on the industry. Many retail and ecommerce businesses aim for a ratio of roughly 4 to 8 (turning stock over every 45 to 90 days). Fast-moving groceries can run far higher, while high-ticket or seasonal goods are often lower. Compare against your own niche and history rather than a single benchmark.

Should I use COGS or revenue?

Use cost of goods sold, not sales revenue. Average inventory is recorded at cost, so dividing by COGS keeps both sides on the same cost basis. Using revenue would inflate the ratio because it includes your markup.

How do I find average inventory value?

A common approach is to add your beginning inventory and ending inventory for the period and divide by two. For a smoother figure you can average several month-end balances. Use the value at cost, matching how COGS is measured.

What does days inventory outstanding mean?

Days inventory outstanding (DIO), also called days sales of inventory, estimates how many days it takes on average to sell your current stock. A lower number means inventory converts to sales faster, freeing up cash; a high number can signal overstocking or slow-moving products.

Is my data sent anywhere?

No. The calculation runs entirely in your browser. Nothing you enter is uploaded, logged or stored.

Related tools