Finance & Economics · Corporate Finance & Valuation · Efficiency Ratios
Inventory Turnover Calculator
Calculates inventory turnover ratio and days inventory outstanding (DIO) from cost of goods sold and average inventory values.
Calculator
Formula
COGS is the Cost of Goods Sold over the period (typically one fiscal year). Average Inventory is calculated as (Beginning Inventory + Ending Inventory) / 2, representing the mean stock held during the period. Inventory Turnover measures how many times inventory is fully sold and replaced in the period. Days Inventory Outstanding (DIO) converts the ratio into the average number of days it takes to sell through the entire inventory.
Source: Brigham, E. F. & Houston, J. F. (2019). Fundamentals of Financial Management, 15th ed. Cengage Learning. Chapter 4: Financial Statement Analysis.
How it works
Inventory turnover is a core efficiency metric that quantifies how many times a company's average inventory is sold and replenished within a specific accounting period — typically a fiscal year. When a business sells inventory quickly, it ties up less cash in stock, reduces storage and obsolescence costs, and generally improves its cash conversion cycle. Retailers and manufacturers routinely track this ratio alongside Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO) as part of the broader Cash Conversion Cycle (CCC) framework.
The formula divides Cost of Goods Sold (COGS) by Average Inventory. COGS is preferred over revenue because it represents the actual cost of the goods sold, making it directly comparable to the inventory balance on the balance sheet (which is also recorded at cost). Average inventory — the mean of beginning and ending inventory for the period — smooths out seasonal fluctuations and gives a more accurate picture of typical stock levels. Days Inventory Outstanding (DIO) inverts the ratio and multiplies by 365, expressing the result as the average number of days inventory sits on the shelf before being sold.
Different industries have vastly different benchmark turnover rates. Grocery and food retail businesses may achieve turnovers of 15–25x per year (DIO of 15–25 days) due to perishable goods and high volume. Automotive manufacturers or luxury goods retailers might see turnovers of 3–6x (DIO of 60–120 days). Comparing a company's inventory turnover to industry peers and tracking it over time is far more informative than assessing it in isolation. Analysts also use DIO as one leg of the Cash Conversion Cycle: CCC = DIO + DSO − DPO, where a lower CCC typically signals superior operational efficiency.
Worked example
Consider a mid-sized electronics retailer with the following figures from its annual income statement and balance sheet:
- Cost of Goods Sold (COGS): $500,000
- Beginning Inventory: $80,000
- Ending Inventory: $120,000
Step 1 — Calculate Average Inventory:
Average Inventory = ($80,000 + $120,000) / 2 = $100,000
Step 2 — Calculate Inventory Turnover Ratio:
Inventory Turnover = $500,000 / $100,000 = 5.00x
This means the company sold through its entire average inventory stock five times during the year.
Step 3 — Calculate Days Inventory Outstanding (DIO):
DIO = 365 / 5.00 = 73.0 days
On average, inventory sits in the warehouse for 73 days before being sold. For an electronics retailer, this would be considered reasonable but potentially improvable compared to fast-moving consumer goods competitors.
If the company's main competitor operates with a DIO of 45 days, management might investigate whether procurement processes, demand forecasting, or pricing strategies can be improved to increase the turnover ratio closer to industry best practice.
Limitations & notes
The inventory turnover ratio is a powerful but simplified metric with several important caveats. First, using year-end inventory values instead of averaging beginning and ending inventory can distort results for highly seasonal businesses — for example, a toy company with very low post-holiday inventory will show an artificially high turnover ratio. For even greater accuracy, analysts sometimes average quarterly or monthly inventory balances when data is available. Second, the ratio is meaningless without industry context: a turnover of 4x is excellent in aerospace manufacturing but alarming in grocery retail. Always benchmark against direct industry peers using the same COGS-based formula, since some analysts mistakenly use revenue instead of COGS, producing incomparable results. Third, a very high inventory turnover is not automatically positive — it can signal that a company is chronically understocked, leading to lost sales and poor customer satisfaction (stockout risk). Fourth, COGS can include fixed overhead allocations that distort comparisons between companies with different cost structures. Finally, inventory write-downs or one-time charges embedded in COGS can temporarily spike the ratio, so always read the notes to financial statements alongside this calculation.
Frequently asked questions
What is a good inventory turnover ratio?
A 'good' inventory turnover ratio is highly industry-dependent. Grocery and fast-moving consumer goods companies typically achieve 10–25x per year, while manufacturers of heavy equipment or luxury goods may see 2–4x. The most meaningful benchmark is to compare your ratio against direct competitors and track its trend over time. Generally, a rising turnover trend signals improving efficiency, while a declining trend warrants investigation into demand, pricing, or procurement practices.
Should I use COGS or revenue in the inventory turnover formula?
COGS is the academically correct numerator for inventory turnover because both COGS and inventory are recorded at cost on the financial statements, making the comparison apples-to-apples. Using revenue (which includes a profit margin) artificially inflates the ratio and makes cross-company comparisons unreliable. Some industry databases use revenue for simplicity, so always check which definition is being used before comparing your results to external benchmarks.
What is the difference between inventory turnover and Days Inventory Outstanding (DIO)?
Inventory turnover ratio (expressed as a multiple, e.g., 5x) tells you how many full cycles of inventory were sold in a year. Days Inventory Outstanding (DIO) converts that into the average number of days a unit of inventory is held before sale, calculated as 365 divided by the turnover ratio. DIO is often easier to communicate to non-financial stakeholders — saying 'our inventory sits for 73 days on average' is more intuitive than saying 'our turnover ratio is 5x.'
How does inventory turnover relate to the Cash Conversion Cycle?
The Cash Conversion Cycle (CCC) measures the total time it takes a company to convert its investments in inventory and other resources into cash flows. The formula is CCC = DIO + DSO − DPO, where DSO is Days Sales Outstanding (time to collect receivables) and DPO is Days Payable Outstanding (time before paying suppliers). A lower CCC indicates that a company operates with less working capital tied up in operations. Reducing DIO — by improving inventory turnover — is one of the primary levers management can pull to shorten the CCC and improve free cash flow.
Can a very high inventory turnover ratio be a bad sign?
Yes. While high inventory turnover generally indicates efficiency, an extremely high ratio can signal chronic underinvestment in inventory, leading to frequent stockouts, lost sales, and dissatisfied customers. This is known as 'stockout risk.' Companies in just-in-time supply chains must carefully balance turnover speed against supply chain disruption risk. During periods of supply chain instability (such as global logistics shocks), companies with very lean inventories may be disproportionately harmed by sudden supply disruptions compared to peers with slightly lower but more resilient inventory levels.
Last updated: 2025-01-15 · Formula verified against primary sources.