What this calculator does
Inventory turnover measures how many times a business sells and replaces its stock during a period. It connects the cost of the goods sold with the average value of inventory held. The result is useful for spotting slow-moving stock, comparing operations, and estimating how long cash stays tied up on shelves. This calculator uses the standard cost-of-goods-sold method and shows the answer in turns and in days.
How to use it
- Enter cost of goods sold for the period.
- Enter average inventory for the same period.
- Review inventory turnover and days inventory.
- Compare the result with prior periods or similar businesses.
- If inventory is seasonal, use an average of several months.
How it works
Example calculations
Example 1: $500,000 COGS, $100,000 average inventory
Turnover is 5.0, so inventory turns five times. Days inventory is 365 / 5 = 73 days. On average, stock sits for about ten and a half weeks before it is sold.
Example 2: $1,000,000 COGS, $250,000 average inventory
Turnover is 4.0 and days inventory is 91.25, or about 91 days. Each dollar of average inventory supports four dollars of annual cost of goods sold.
Example 3: $200,000 COGS, $50,000 average inventory
Turnover is 4.0 again, with about 91 days of inventory. The smaller business holds the same number of turns but a much smaller stock.
What the result means
Turnover is a ratio, so context decides whether it is good. A grocery store may turn stock many times a month because perishable goods must move quickly, while a luxury retailer may hold inventory for months. A rising turnover can mean demand is strong or that the business is running lean; it can also mean shelves are too empty and sales are being lost. A falling turnover can signal weak demand, poor buying, or a deliberate build-up before a busy season. Days inventory translates the ratio into a holding period, which is easier to picture. Neither figure includes storage, insurance, obsolescence, or profit margin. Use turnover alongside gross margin and cash flow rather than as a stand-alone score.
Common mistakes
- Using sales revenue instead of cost of goods sold.
- Comparing beginning inventory with full-year COGS.
- Mixing periods, such as quarterly COGS with annual inventory.
- Reading high turnover as good without checking stockouts.
- Ignoring seasonal swings that make an average misleading.
Assumptions and limits
- COGS and average inventory cover the same period.
- Average inventory is the mean of beginning and ending balances.
- The period is one year, so 365 days is used.
- Inventory values use a consistent accounting basis.
- The business sells a mix of products, so the ratio is an average.
Frequently asked questions
What is a good inventory turnover?
It varies by industry. Perishable goods usually turn faster than furniture or luxury items. Compare with your own trend and similar businesses rather than one target.
Should I use sales or cost of goods sold?
Use cost of goods sold. Sales include markup, so dividing sales by inventory inflates the ratio and makes comparisons harder.
How do I find average inventory?
Add beginning and ending inventory and divide by two. For a seasonal business, average several monthly balances for a more representative figure.
What does days inventory mean?
It estimates how many days, on average, stock sits before it is sold. For an annual period, it is 365 divided by turnover.
Can turnover be too high?
Yes. Very high turnover can mean inventory is too lean, leading to stockouts and lost sales. The right balance depends on demand and lead times.
Does this include work-in-progress inventory?
The formula uses total average inventory, which can include raw materials, work in progress, and finished goods. Separate ratios can help a manufacturer.
Sources
2026 update
How to use the professional output
This page is not just a formula box. The result is designed to be checked, compared, and taken away.
- Professional worksheet. The result includes the inputs used, the method and scope, and a one-variable sensitivity check for finance calculators.
- A/B scenarios. Save two input sets in the browser and compare the primary, secondary, and breakdown figures side by side.
- Print / PDF and CSV. Print a branded worksheet, or export the year-by-year table when the calculator produces one.
The formulas and assumptions above still govern the number. The worksheet makes the estimate auditable; it does not make it a lender quote, tax return, or personalized advice.
Part of a decision center
Business Decision Center
See the companion tools, decision guides, and patterns that go with this calculator.
Go deeper
