Inventory Turnover Calculator
Solve the standard efficiency ratio for any of its three unknowns — turnover, cost of goods sold, or average inventory — with step-by-step math, a scaled flow-versus-stock schematic, and companion working-capital metrics including days inventory outstanding.
Turnover ties two sides of the business together
Inventory turnover measures how efficiently a business converts its stock into sales. It connects the income statement (COGS, a flow) with the balance sheet (inventory, a stock). A high turnover means the business does not sit on idle stock — it buys, sells, and replenishes quickly, which frees up working capital and reduces the risk of obsolescence. A low turnover suggests slow-moving stock, over-ordering, or weak demand.
Higher is not always better
Turnover can be too high. A ratio far above industry norms may mean the company is under-stocking and risking stockouts, losing sales, or paying rush freight to replenish. Extremely high turnover in a low-margin business can also signal aggressive price cuts or inventory liquidation. The right turnover is the one that balances carrying cost against availability — and it varies enormously by industry, from 2× for luxury cars to 20×+ for grocery.
Industry context is everything
Turnover ratios are meaningless without comparison. A supermarket running at 12× and a jeweller at 1.5× can both be efficiently managed — the difference reflects the nature of the goods, not management quality. When benchmarking, always compare to the sector median, and remember that within a sector, differences in vertical integration, product mix, and accounting policy (FIFO vs. LIFO) can all move the ratio without any change in operational performance.
Watch the trend, not just the level
A single turnover figure is a snapshot. The more useful signal is the direction over several periods. A turnover ratio falling over four quarters while revenue is flat or rising is a warning sign — it usually means inventory is building up faster than sales. Conversely, turnover rising while margins hold steady is a strong indicator of improving operational discipline. Always compare like periods (e.g., Q3 to Q3) to control for seasonality.
How to Use This Calculator
The turnover relation links three quantities: cost of goods sold, average inventory, and the number of turns per period. Pick which one you want the tool to solve, then fill in the other two.
1. Choose what to solve for
Pick Turnover, COGS, or Avg Inventory. The calculator rearranges the formula automatically for whichever variable you choose and locks that field.
2. Match the period across all inputs
COGS and average inventory must cover the same period — both annual, both quarterly, or both monthly. Never mix an annual COGS with a quarterly inventory figure.
3. Use average, not ending, inventory
Average inventory is normally (beginning + ending) ÷ 2. In Advanced mode you can enter both balances and apply the average with a single click, which smooths out seasonal or one-off swings.
4. Read the result and verdict
The result card shows the solved value plus a colour-coded verdict from very slow through healthy and fast to extreme — always read it against your industry's norms, not in isolation.
5. Check the schematic
The schematic draws COGS as a scaled flow bar, average inventory as a scaled stock bar, and the resulting turnover on a 0× to 20× gauge — the flow-vs-stock relationship at a glance.
6. Switch to Advanced for depth
Advanced mode adds a period-length input, begin/end inventory with one-click averaging, a second chart, sensitivity, and fifteen working-capital metrics including DIO, weeks of stock, and COGS per day.
What This Tool Offers
Built around the standard inventory turnover ratio — the key measure of how efficiently a business converts stock into sales.
Three-way solving
Solve for turnover, COGS, or average inventory. The calculator rearranges the formula for whichever variable you choose.
One-click averaging
Enter beginning and ending inventory and apply (Begin + End) ÷ 2 to the average in a single click — no manual arithmetic required.
Efficiency verdict
Each result is graded from very slow through slow, moderate, healthy, strong, fast, and extreme, with a coloured badge and context note.
Flow-versus-stock schematic
A scaled COGS flow bar, a scaled average inventory stock bar, and a 0× to 20× turnover gauge with a live marker.
Days inventory outstanding
Convert turnover into DIO (days of stock on hand), weeks of inventory, and COGS per day — with the period adjustable to 365, 360, 90, or 30 days.
Dual comparison charts
Turnover versus COGS for three average inventory levels, plus turnover versus average inventory for three COGS levels.
Reference Tables & Conversions
A turnover lookup grid, typical turnover ratios by industry, and the underlying variables.
Turnover lookup grid
Computed from Turnover = COGS / Avg Inventory. Rows are COGS; columns are average inventory. Values are the resulting turnover (× per period).
| COGS \ Avg Inv | 100k | 250k | 500k | 1M | 2M | 5M |
|---|
Typical Inventory Turnover by Industry
Representative annual turnover ratios. Actual values vary with business model, product mix, and accounting policy.
| Industry | Typical turnover | DIO (days) | Notes |
|---|---|---|---|
| Luxury cars / high-end jewelry | 0.5× – 2× | 180 – 730 | Long selling cycles; made-to-order or bespoke stock |
| Heavy machinery / aerospace | 2× – 4× | 90 – 180 | Large items, long lead times, project-based revenue |
| Automotive (dealers) | 4× – 8× | 45 – 90 | New and used car dealerships; varies with model year |
| Furniture / home goods | 4× – 6× | 60 – 90 | Large, low-frequency purchases |
| Apparel / fashion retail | 4× – 8× | 45 – 90 | Seasonal; sensitive to markdown policy |
| Consumer electronics | 6× – 10× | 36 – 60 | Fast obsolescence; high risk of write-downs |
| Consumer staples / FMCG | 6× – 12× | 30 – 60 | Steady demand; efficient replenishment chains |
| Grocery / supermarkets | 12× – 20× | 18 – 30 | Perishable goods; extremely high velocity |
| Convenience stores / fuel | 15× – 30× | 12 – 24 | Small baskets, rapid replenishment, thin margins |
| E-commerce (dropship) | 15× – 40× | 9 – 24 | Often near-zero inventory; ratio distorted by model |
Variable Reference
| Symbol | Meaning | Typical range | Notes |
|---|---|---|---|
| COGS | Cost of goods sold | 0 – 1e12 | Direct cost of inventory sold over the period |
| Avg Inv | Average inventory | 0 – 1e12 | (Beginning + Ending) ÷ 2 |
| Turnover | Inventory turns per period | 0.5 – 40 | Higher is generally better, but industry-dependent |
| DIO | Days inventory outstanding | 9 – 730 | Days in period ÷ Turnover |
| Days | Days in the reporting period | 30 / 90 / 365 | Must match the COGS and inventory period |
| Weeks of stock | Weeks of inventory on hand | — | DIO ÷ 7 |
What Does the Inventory Turnover Ratio Measure?
Inventory turnover measures how many times a business sells and replaces its entire inventory over a period. It is one of the most important efficiency ratios in financial analysis, because it directly ties the income statement (COGS, a flow) to the balance sheet (inventory, a stock). A high turnover means the business does not sit on idle stock — it converts inventory into revenue quickly, freeing up working capital and reducing the risk of obsolescence. A low turnover suggests over-stocking, weak demand, or poor inventory management.
The formula is deliberately simple — COGS divided by average inventory — but its simplicity is what makes it so broadly useful. The same ratio applies to a small retailer, a multinational manufacturer, or a grocery chain. What changes is the industry benchmark you compare against, not the mathematics.
For investors and creditors, the ratio matters because inventory is often the largest current asset on a company's balance sheet. A business that ties up cash in slow-moving stock has less cash for operations, growth, or debt repayment. Turnover is therefore a proxy for liquidity, operational discipline, and the quality of the underlying demand for the company's products.
The Inventory Turnover Formula
The defining relationship is:
Rearranged to solve for the other two unknowns:
Average Inventory = COGS / Turnover
The average inventory used in the formula is normally:
Days inventory outstanding (DIO) — the number of days of stock on hand — is derived from the turnover:
Inventory Turnover Variables
| Symbol | Meaning | Notes |
|---|---|---|
| COGS | Cost of goods sold | Direct cost of inventory sold over the period |
| Avg Inv | Average inventory | (Beginning + Ending) ÷ 2, or a monthly average for greater accuracy |
| Turnover | Inventory turns per period | Higher generally means better efficiency — but must be compared to industry norms |
| DIO | Days inventory outstanding | Days in period ÷ Turnover |
| Days | Days in the reporting period | 365 for annual, 90 for quarterly, 30 for monthly |
How Each Variable Affects the Result
The turnover ratio is linear in COGS and inversely proportional to average inventory. Doubling COGS doubles the turnover at the same inventory level — the business is selling twice as much stock in the same period. Doubling average inventory halves the turnover — the business is holding twice as much stock for the same sales volume.
This asymmetry is important. To improve turnover you can either increase sales (raise COGS) or reduce inventory (lower the denominator). The second path is often easier and always lower risk, because reducing inventory frees up cash immediately and reduces the risk of write-downs. But it has limits: cutting stock too aggressively risks stockouts, which lose sales and damage customer relationships.
The choice of inventory valuation method (FIFO, LIFO, or weighted average) also affects the ratio. In periods of rising prices, FIFO produces a higher COGS — and therefore a higher turnover — than LIFO for the same physical flow. This is an accounting artefact, not an operational improvement. When comparing ratios across companies, always check which method is being used.
Inventory Turnover Calculation Examples
Turnover = 2,000,000 / 400,000 = 5.00× per year
COGS = 5 × 400,000 = 2,000,000
Avg Inv = 2,000,000 / 5 = 400,000
Avg Inv = (350,000 + 450,000) / 2 = 400,000
DIO = 365 / 5 = 73 days of inventory on hand
Frequently Asked Questions
Inventory turnover is a financial ratio that measures how many times a company sells and replaces its entire stock of inventory over a period — usually a year. It is calculated by dividing cost of goods sold (COGS) by average inventory for the period. A turnover of 5× means the company sold and restocked its entire inventory five times in the year. It is one of the most important efficiency ratios because it directly measures how well the business converts stock into sales, and how much working capital is tied up in inventory.
No. Very high turnover can signal that a company is under-stocking and risking stockouts — running out of the products customers want to buy and losing sales as a result. In extreme cases, turnover above 30× can also be an artefact of aggressive discounting or inventory liquidation. Conversely, low turnover is not always bad — a jewellery store or a luxury car dealer will naturally turn over stock far more slowly than a supermarket, because the goods are expensive and the selling cycle is long. The right turnover is the one that balances carrying cost against product availability, and it is almost always defined by the industry.
Use average inventory. The standard formula is (beginning inventory + ending inventory) ÷ 2, which smooths out seasonal swings, one-off purchases, and end-of-period distortions. Using ending inventory alone is a common shortcut, but it can produce a distorted ratio if the ending balance happens to be unusually high or low — for example, right before a major restocking cycle. For companies with highly seasonal businesses, quarterly or even monthly averages give a more accurate picture than a simple two-point average.
They measure the same thing in different units. Turnover counts how many times the inventory is sold and replaced per period; Days Inventory Outstanding (DIO) counts how many days, on average, inventory sits on the shelf before it is sold. The two are related by the formula DIO = Days in period / Turnover. A turnover of 5× on an annual basis gives a DIO of 365 / 5 = 73 days. DIO is often preferred by operators because "days of stock" is more intuitive to manage than "turns per year."
Inventory is a use of cash. Every dollar sitting in inventory is a dollar that cannot be spent on operations, growth, or debt repayment. Higher turnover means the business holds less inventory for a given level of sales, which frees up cash. A company with $1M in inventory turning over 4× per year holds an average of 91 days of stock; the same company turning over 8× holds only 46 days. The difference — 45 days of inventory — represents cash released back into the business. This is why working capital management focuses so heavily on inventory turnover.
Inventory turnover reflects the nature of the goods being sold. Perishable goods like groceries must be sold within days, so turnover is naturally high (12–20×). High-value, low-frequency purchases like luxury cars or fine jewellery turn over slowly (0.5–2×) because customers take time to decide and inventory sits on the floor for weeks or months. Between these extremes, most industries cluster by product lifecycle, margin structure, and the cost of holding stock. Any comparison of turnover ratios between companies in different industries is therefore meaningless — always benchmark against the sector.
There are three levers. First, reduce inventory — cut slow-moving SKUs, tighten ordering, negotiate smaller and more frequent supplier deliveries. Second, increase sales velocity — better merchandising, pricing, marketing, or discontinuing products that do not sell. Third, improve accuracy of demand forecasting so you hold exactly what you need. The most effective interventions usually combine all three. Cutting stock without improving demand forecasting simply shifts the problem from over-stocking to stockouts, and losing sales is more expensive than carrying a bit of extra inventory.
Yes, meaningfully. FIFO, LIFO, and weighted-average cost all produce different COGS and inventory values from the same physical flow of goods, and therefore different turnover ratios. In periods of rising prices, FIFO produces a lower ending inventory value and a higher COGS than LIFO, which raises the turnover ratio without any change in operations. When comparing ratios across companies — or even across years for the same company that has changed method — always check the accounting policy note. The most reliable comparison is between companies that use the same method.
Variables
| Symbol | Quantity | Unit |
|---|---|---|
| Inventory Turnover | Inventory turnover ratio | |
| Cost of Goods Sold | Total cost of goods sold | currency |
| Average Inventory | Average inventory value over the period | currency |
What it means
Inventory turnover is a measure of how frequently a company sells and replenishes its inventory over a period. It is calculated by dividing the cost of goods sold (COGS) by the average inventory. A higher turnover indicates efficient inventory management and strong sales, while a low turnover may signal overstocking or weak demand. It is used to evaluate operational performance, to manage cash flow, and to compare with industry benchmarks. Understanding inventory turnover is essential for supply chain and operations managers.
Worked example
Inventory Turnover – Two Detailed Examples
Real‑World| Parameter | Value |
|---|---|
| COGS | 600000 |
| Average Inventory | 100000 |
| Parameter | Value |
|---|---|
| COGS | 300000 |
| Average Inventory | 75000 |
Common mistakes
- Inventory turnover: Cost of goods sold divided by average inventory – measures how quickly inventory is sold.
- Cost of Goods Sold: The total cost of merchandise sold during the period.
- Average inventory: (Beginning inventory + Ending inventory) / 2.
- Higher turnover: Indicates efficient inventory management – but too high may mean stockouts.
- Industry variation: Perishable goods have higher turnover.
Applications
Inventory turnover ratio measures how many times a company's inventory is sold and replaced over a period, indicating the efficiency of inventory management. A high turnover suggests strong sales and effective inventory control, while low turnover may indicate overstocking or obsolescence. Retailers, wholesalers, and manufacturers use this ratio to optimise stocking levels, to reduce carrying costs, and to improve cash flow. By monitoring inventory turnover, managers can identify slow‑moving items and adjust purchasing decisions. Investors use it to assess operational efficiency. This metric is essential for working capital management and supply chain optimisation.
- Inventory management and optimisation
- Cash flow and working capital improvement
- Product demand assessment and assortment planning
- Supplier performance and replenishment strategies
- Financial analysis and operational benchmarking
Related calculators · Corporate Finance
Recently updated formulas
Suggest an improvement
Found a mistake? Have a better example? Let us know.
You may send up to 3 suggestions per 24 hours.