What this calculator does
This stock turnover calculator measures how many times a year you sell and replace your inventory. Enter cost of sales and average stock, and it returns the turnover ratio together with days sales of inventory — the same measure expressed as the number of days a typical item sits before it sells.
Turnover is really a question about capital efficiency rather than about stock levels. Every pound held in inventory is a pound unavailable for wages, marketing, or reducing debt. The ratio shows how hard that capital works, and the days figure shows how long each pound stays trapped before returning.
When to use it
The routine use is quarterly monitoring, because turnover deteriorates gradually and invisibly. Slow lines accumulate one purchase order at a time, and by the point the effect shows in the bank balance it reflects a year of accumulated buying decisions.
The more decisive use is when cash is tight and you need to find money inside the business rather than borrowing it. Stock is usually the largest pool of trapped capital available, and moving turnover from five to six and a half releases real cash with no new facility. It is also the calculation to run before a seasonal buy, to test whether last year's assumptions held.
Understanding the inputs
Cost of sales should be the annual figure at cost, consistent with how stock is valued on your balance sheet. Using turnover instead inflates the ratio by your full gross margin, which is much the most common error in this calculation.
Average stock is conventionally opening plus closing divided by two. For seasonal businesses that approach is unreliable, since measuring at a post-season low overstates turnover, so average monthly balances where your system allows. Both figures must cover the same period — if you use a quarterly cost of sales figure, annualise it or the days calculation will be out by a factor of four.
How is this calculated?
Inventory Turnover = COGS / Average Inventory. Days Sales of Inventory (DSI) = 365 / Turnover.
A worked example
A wholesaler reports £1,150,000 of cost of sales against average stock of £230,000. Turnover is 5 times a year and days of stock is about 73 — meaning a typical item sits for two and a half months before selling.
Raising turnover to 6.5 would mean holding roughly £177,000 of average stock to support the same sales, releasing about £53,000 of cash permanently and cutting days to around 56. At a 25 percent carrying cost, the smaller holding also saves roughly £13,000 a year. Set against a cash conversion cycle of 73 days of stock plus 45 debtor days less 40 creditor days, that is 17 days off a 78-day cycle.
Limitations and assumptions
A single blended ratio hides the distribution that matters. Most stockholdings follow a pattern where a minority of lines turn quickly and a long tail barely moves, so an acceptable overall figure can sit alongside substantial dead stock. Calculate by category or line wherever the system permits.
The two-point average also distorts badly for seasonal businesses, and the ratio captures nothing about stockouts, since a sale you could not fulfil appears in no inventory measure. Read turnover alongside fill rates, aged stock reports, and the full cash conversion cycle rather than treating it as a verdict on its own.
Common Questions
- What is a good stock turnover ratio?
- It varies widely by sector, so treat benchmarks loosely. As common rules of thumb, food retail runs 12 to 20 times a year, fashion 4 to 6, industrial distribution 4 to 8, and builders' merchants 3 to 5. The comparison that matters is against your own sector and your own prior year.
- How does turnover relate to days of stock?
- They are the same measure in different clothing. Days is 365 divided by turnover, so 5 turns a year means roughly 73 days of stock on hand. Days tends to be more intuitive in operational discussions, while turnover is the format used in benchmarking and financial analysis.
- Why use cost of sales rather than turnover in the numerator?
- Because stock is carried at cost in your accounts, and dividing a sales-priced figure by a cost-based one inflates the ratio by your entire gross margin. A business on 40 percent margin would report a ratio around 67 percent too high. Some published benchmarks still use sales, which makes comparison unreliable.
- Can stock turnover be too high?
- Yes. Very high turnover often signals stockouts, lost sales, and costly expedited deliveries. Where the ratio sits well above your sector norm, examine fill rates and backorder data before celebrating — the cost of a sale you could not fulfil appears in no stock metric at all.
- How should average stock be calculated?
- Opening plus closing divided by two is standard and works for stable businesses. For anything seasonal it distorts significantly, since measuring at a post-Christmas low will overstate turnover considerably. Averaging monthly balances gives a far more representative figure where your system can produce them.
- What does it cost to hold stock?
- Considerably more than the purchase price. Storage, insurance, shrinkage, obsolescence, and the cost of capital typically add 20 to 30 percent of stock value each year. On £230,000 of average stock that is roughly £46,000 to £69,000 annually — a cost that never appears as a line in the accounts.
- Should I measure turnover by line or across the business?
- By line or category wherever possible. A blended figure conceals the pattern that matters: a small proportion of items usually moves quickly while a long tail sits for a year or more. The aggregate can look respectable while a large share of your capital is effectively dead.
- What is the cash conversion cycle?
- Days of stock plus debtor days minus creditor days — the time your cash is tied up between paying a supplier and being paid by a customer. Stock is usually the largest component, which makes turnover the single most powerful working capital lever available to most trading businesses.
- What is the quickest way to improve turnover?
- Address the slow tail first. Discounting aged stock feels like crystallising a loss, but the capital is already impaired and every further month adds carrying cost. Beyond that, tighter reorder points, shorter supplier lead times, and sale-or-return arrangements on slow lines all move the ratio.