Inventory Turnover Calculator

The Inventory Turnover Calculator shows how many times your inventory sells through in a year by dividing cost of goods sold by average inventory, then converts that into days of stock on hand and the cash tied up in inventory.

How It Works

1. Enter cost of goods sold (COGS). Use the COGS for the same period as your inventory figures, normally a full year from your income statement.
2. Enter beginning inventory. The value of stock on hand at the start of the period, recorded at cost.
3. Enter ending inventory. Stock value at the end of the period. If you leave it blank, the calculator uses the beginning figure for both points, which suits a quick estimate from a single stock count.
4. Read the results. You get average inventory, the turnover ratio, days and months of inventory on hand, daily COGS, the capital tied up in stock, and a verdict comparing your turnover with the bands this tool uses: under 3 is slow, 3 to 12 is healthy for most product businesses, and over 12 is fast enough to watch for stockouts.

Formula

$\text{Average inventory} = \frac{\text{Beginning inventory} + \text{Ending inventory}}{2}$

$\text{Inventory turnover} = \frac{\text{COGS}}{\text{Average inventory}}$

$\text{Days in inventory} = \frac{365}{\text{Turnover}}$

$\text{Months of inventory} = \frac{\text{Days in inventory}}{30.4}$

$\text{Daily COGS} = \frac{\text{COGS}}{365}$

The capital tied up is simply the average inventory value, since that is the cash sitting in stock on a typical day of the period.

Input Parameters

| Input | Unit | Realistic range | Notes | | --- | --- | --- | --- | | Cost of goods sold | Currency per period | USD 10,000 to USD 10,000,000 per year | Must match the inventory period | | Beginning inventory | Currency | USD 0 and up | Valued at cost, not retail price | | Ending inventory | Currency | USD 0 and up | Optional; defaults to the beginning value |

Average inventory cannot be zero; if both inventory figures are zero the calculation cannot run.

Worked Example

A retailer reports annual COGS of USD 480,000, beginning inventory of USD 55,000, and ending inventory of USD 65,000.

1. Average inventory: (USD 55,000 + USD 65,000) / 2 = USD 60,000.
2. Turnover: USD 480,000 / USD 60,000 = 8.0 times per year.
3. Days in inventory: 365 / 8.0 = 45.6 days of stock on hand on average.
4. Months of inventory: 45.6 / 30.4 = 1.5 months.
5. Daily COGS: USD 480,000 / 365 = USD 1,315.07 of inventory cost flowing out per day.
6. Capital tied up: USD 60,000.

A turnover of 8.0 falls in this calculator's healthy band, and the verdict reflects that: stock converts to sales roughly every month and a half without the stockout risk of a very lean shelf.

Interpreting Your Results

Turnover is a balancing act, and both extremes cost money. Below 3 turns a year, stock sits for more than four months on average; the tied-up capital figure shows exactly how much cash is parked in slow lines, and storage, insurance, and markdown risk grow with it. Above 12 turns, the shelves cycle in under a month, which is normal for groceries and perishables but dangerous for general retail, because a single late delivery can empty the shelf and lose sales that never appear in any report.

Days in inventory is often the more actionable number. Multiply it by daily COGS and you recover the capital figure, which makes the trade concrete: trimming 10 days of stock in the example frees roughly USD 13,150 (10 x USD 1,315.07) of cash without selling a single extra unit.

Compare like with like. Turnover differs enormously by trade, because jewellery and furniture are designed to turn slowly at high margins while food turns quickly at low ones. Track your own trend and compare within your sector, not against a universal ideal.

Choosing the Right Tool

• Use this Inventory Turnover Calculator to judge stock efficiency and the cash locked inside inventory.
• Use the Break-Even Calculator to find the sales volume your business needs before any of this stock movement produces profit.
• Use the Contribution Margin Calculator to see what each product line contributes after variable costs, which helps identify which slow lines deserve their shelf space.
• Use the Profit Margin Calculator to check whether a low-turnover line earns its keep through margin, or a high-turnover line is actually profitable at all.

Limitations

A two-point average (beginning and ending stock) hides seasonality: a business that stocks up before a peak season and empties out after it can look efficient or bloated depending on where the period boundaries fall. Using monthly inventory averages is more accurate if you have them. The result also depends on inventory being valued consistently at cost; mixing retail-value and cost figures distorts the ratio. Shrinkage, write-offs, and product mix changes are invisible to the formula, and the verdict bands are general guides rather than industry-audited benchmarks.

Questions

Should I use sales revenue instead of COGS?

No, use COGS. Inventory is carried at cost, so dividing revenue (which includes markup) by inventory value would inflate turnover and make periods with different margins impossible to compare. The standard formula uses COGS for both consistency and accuracy.

What if I only have one inventory figure?

Enter it as beginning inventory and leave ending inventory blank. The calculator then uses that single value as the average. It is a reasonable shortcut for a rough check, but a real beginning-and-end pair is better when stock levels have changed over the period.

How often should I measure turnover?

Annually for the headline figure, and quarterly if your trade is seasonal. Measuring a single month and annualizing it can badly mislead when that month is a peak or a trough, because the inventory snapshot will not represent the year.

Sources and Methodology

Inventory turnover as COGS divided by average inventory, and its companion days inventory outstanding measure, are the standard definitions in managerial accounting and financial statement analysis, used in textbooks and in ratio analysis by lenders and operators. The capital tied up figure is the average inventory balance itself. The health bands applied in the verdict (under 3 slow, 3 to 12 healthy, over 12 very fast) are this calculator's general retail guideposts; sector norms vary, so verify expectations for your specific trade before acting on them.