Use this inventory turnover calculator to estimate how many times your business sells and replaces its average inventory during a reporting period. It divides cost of goods sold by average inventory and also calculates inventory days using a fixed 365-day basis.
How to use the inventory turnover calculator
- Initial Inventory Value: Enter the value of inventory at the beginning of your reporting period.
- Ending Inventory Value: Enter the value at the end of the same period. If you need help finding this amount, use the ending inventory calculator.
- Cost of Goods Sold: Enter COGS for that period, not sales revenue. For a retailer, this generally represents the cost of merchandise sold; for a manufacturer, it includes applicable production costs assigned to goods sold.
- Period: This field is labeled in days, but the current formulas do not use it. Changing it does not change either result; the Inventory Days calculation always uses 365 days.
Enter inventory values at cost, not their expected selling prices, and use a consistent accounting basis throughout. The dollar inputs must all cover the same business or product group.
For consistent annual results, use a full year of COGS and inventory balances from the beginning and end of that year. If you use a shorter reporting period, the turnover ratio remains a ratio for that period, but you will need to adjust inventory days separately.
Inventory turnover formula
The calculator first estimates average inventory from the two balances you enter:
Average inventory = (Initial inventory + Ending inventory) ÷ 2
It then applies the inventory turns formula:
Inventory turnover = Cost of goods sold ÷ Average inventory
Inventory turnover is measured in times, or turns, per reporting period—not days. Read the Inventory Turnover result this way even if a days unit appears beside it.
The second result uses this calculation:
Inventory days = 365 ÷ Unrounded inventory turnover
The calculator rounds turnover to two decimal places and inventory days to the nearest whole day. It uses the unrounded turnover when calculating inventory days, so dividing 365 by the displayed, rounded ratio may produce a slightly different result.
For a nonannual reporting period, calculate the corresponding days measure separately:
Inventory days for your period = Days in the reporting period ÷ Unrounded inventory turnover for that period
Average inventory must be greater than zero for the turnover ratio to be meaningful. If COGS is zero and average inventory is positive, turnover is zero and inventory days has no finite value.
Worked example: a handmade ornament store
Suppose a store reports the following figures for one year:
| Measure | Value |
|---|---|
| Initial inventory | $10,000 |
| Ending inventory | $12,000 |
| Cost of goods sold | $40,000 |
| Average inventory | ($10,000 + $12,000) ÷ 2 = $11,000 |
Inventory turnover = $40,000 ÷ $11,000 = 3.64 times per year, rounded.
Inventory days = 365 ÷ ($40,000 ÷ $11,000) = 100 days, rounded.
The store sold goods costing about 3.64 times its average inventory value during the year. Its average inventory represented approximately 100 days of COGS. This does not mean every ornament took exactly 100 days to sell.
What does your inventory turnover ratio mean?
Turnover measures how quickly inventory moves relative to the amount held. It does not, on its own, establish whether a business is profitable or carrying the right stock.
- Higher turnover can indicate strong demand or lean inventory levels. It may reduce storage needs and exposure to obsolescence, but it can also signal insufficient stock if customers regularly encounter shortages.
- Lower turnover can indicate slow-moving goods, excess purchasing, or weaker demand. It may also reflect a deliberate seasonal buildup, long supplier lead times, or a business model that requires a broad product range.
There is no universally good inventory turnover ratio. Compare your result with prior periods of the same length and, where reliable data is available, similar businesses with comparable products and accounting methods.
Read turnover alongside gross margin, stockout frequency, inventory aging, and customer service levels. Heavy discounting may move goods faster while reducing profit; cutting stock too aggressively may improve the ratio while causing lost sales.
Limitations to keep in mind
- Two balances can miss seasonal peaks. The calculator averages beginning and ending inventory only. If stock varies substantially during the year, an average of monthly or more frequent balances may be more representative.
- An overall ratio can hide problem products. Fast-selling lines may offset slow-moving stock. Repeat the analysis by category using matching inventory and COGS figures.
- Accounting choices affect comparisons. Inventory costing methods and write-downs can change both inventory values and COGS without a matching change in physical sales activity.
- Turnover is not a cash collection measure. Selling inventory on credit does not immediately produce cash. Receivable collection and supplier payment terms also affect liquidity.
How to improve inventory turnover without creating shortages
Start by identifying why inventory is moving slowly rather than trying to maximize the ratio at any cost.
- Review aged stock: Identify items with little recent demand, then consider targeted promotions, supplier returns where available, or discontinuing unnecessary reorders. Check the margin impact before discounting.
- Refine purchasing: Compare forecasts with actual sales by product and season. Smaller, more frequent orders may reduce average inventory when supplier terms and delivery costs allow.
- Protect essential stock: Set replenishment levels around demand variability and supplier lead times so that reducing inventory does not create avoidable stockouts.
- Separate product groups: Manage perishable, seasonal, high-value, and slow-moving products according to their different risks rather than applying one turnover target to everything.
- Track results consistently: Compare equivalent periods and monitor margins, stock availability, and purchasing costs alongside turnover.
Related inventory and financial calculators
- The Days Inventory Outstanding Calculator focuses on inventory holding time, a useful companion measure when discussing replenishment and working capital.
- The FIFO and LIFO calculators help you explore how different cost-flow assumptions affect inventory valuation and COGS.
- The ROA Calculator provides a broader view of profit relative to assets, while the Defensive Interval Ratio Calculator examines how long liquid assets could cover operating expenses.
For distributors helping customers plan replenishment, Calcopolis lets you build a custom quote calculator that estimates order costs from product quantities and helps buyers prepare more specific quote requests.