The inventory turnover calculator above converts cost of goods sold and average inventory into three related numbers: how many times stock cycles through the business in a period, how many days of stock you are holding, and how much cash is sitting in it. It then shows what improving turnover to a target level would release.
Arb Digital works with retailers and product businesses where marketing spend and stock purchasing compete for the same cash. Inventory is usually the largest and least examined use of working capital in those businesses, and turnover is the fastest way to see it.
What This Inventory Turnover Calculator Does
It averages opening and closing inventory, divides cost of goods sold by that average to produce the turnover ratio, and converts the ratio into days inventory outstanding. It also applies your holding cost percentage to the average stock balance to show the annual cost of carrying it — a figure that rarely appears anywhere in management accounts despite being real money.
The target turnover field answers the practical question. Enter the turns you think are achievable and the calculator shows the inventory level that implies and the cash difference between that and where you are now. That difference is a one-off release of working capital, and for many product businesses it is larger than any cost saving available elsewhere.
How to Use It
- Enter cost of goods sold for the period. Use cost, not revenue. Mixing revenue with inventory at cost inflates the ratio and makes it incomparable to any benchmark.
- Enter opening and closing inventory. Both valued at cost. If your stock is highly seasonal, a monthly average across the year is more accurate than two endpoints.
- Set the holding cost percentage. Storage, insurance, handling, shrinkage, obsolescence, and the cost of capital tied up in stock.
- Set a target turnover. Something achievable for your category rather than aspirational, then read the cash release.
- Match days in period to the COGS figure — 365 for a full year, 90 for a quarter.
The Formula / How It's Calculated
Average inventory is (Opening + Closing) ÷ 2, or ($180,000 + $220,000) ÷ 2 = $200,000. Inventory turnover is COGS ÷ Average Inventory = $1,200,000 ÷ $200,000 = 6.0x. Stock cycles through the business six times a year.
Days inventory outstanding is Days in Period ÷ Turnover = 365 ÷ 6.0 = 60.8 days. On average, an item sits in stock for about two months before it sells. Annual holding cost is average inventory × holding rate = $200,000 × 25% = $50,000.
At a target of 8.0 turns, required average inventory is COGS ÷ target = $1,200,000 ÷ 8 = $150,000, releasing $50,000 of cash and reducing holding cost by $12,500 a year. That is the same amount as the entire current holding cost, freed once and available for anything else.
Why Turnover Must Use Cost, Not Revenue
The most frequent error in this calculation is dividing revenue by inventory. Because inventory is carried at cost and revenue includes margin, the result is inflated by exactly the gross margin percentage — a business with a 50% margin will appear to turn stock twice as fast as it does. Since published benchmarks and industry ratios are built on cost, a revenue-based figure is not comparable to anything.
There is a related trap in inventory valuation itself. The cost assigned to stock depends on the accounting method used, and different methods produce different balances from identical physical stock, particularly when purchase prices are moving. The IRS sets out permitted inventory and accounting methods in Publication 538, Accounting Periods and Methods. For turnover the practical point is consistency: compare like with like across periods, and be cautious comparing your ratio to a business using a different valuation method.
Days on Hand Is the Number Operations Can Act On
Turnover is the ratio finance uses; days inventory outstanding is the number that changes decisions. "We hold 61 days of stock" can be set directly against supplier lead times, reorder points, and safety-stock policy in a way that "we turn stock six times" cannot. If lead time is 30 days and you hold 61 days of cover, the buffer is roughly one lead time — a specific, discussable position.
It also exposes where the stock actually sits. A blended 61 days can hide fast lines turning in three weeks and slow lines sitting for six months. Running the calculation by category, or at least splitting the fastest and slowest quartiles, almost always reveals that a small share of SKUs holds a large share of the cash. That is where the release identified by the target-turns figure usually comes from.
Faster Is Not Automatically Better
Turnover can be improved by holding too little stock, and the cost of that shows up somewhere other than this calculation. Stockouts lose sales that never appear in any report, damage repeat purchase rates, and in some channels harm search ranking and account standing. Ordering smaller quantities more frequently also forfeits volume discounts and raises inbound freight cost per unit.
The balance point depends on gross margin and lead time. A high-margin product with a long lead time justifies more cover, because a lost sale costs more than the carrying cost of the buffer. A low-margin, short-lead-time item justifies less. The gross margin calculator gives the margin side of that trade, and the product pricing calculator covers how holding and freight costs feed into a price that supports the stock position.
Benchmarks Only Mean Something Within a Category
Turnover varies enormously by what is being sold. Fresh food turns in days because it must; heavy machinery and jewellery turn a few times a year and always have. Comparing your ratio to a general figure produces a false result in one direction or the other. Sector-level data is a better reference: the U.S. Census Bureau publishes Manufacturing and Trade Inventories and Sales, including inventory-to-sales ratios by sector, from survey data rather than estimation.
Even within a category, business model matters. A retailer stocking depth for immediate availability will turn more slowly than one running a made-to-order or drop-ship model with almost no stock at all. Your own trend over time is usually a more useful comparison than any external figure, because it holds the business model constant and shows whether the position is improving.
Inventory Sits Inside the Cash Conversion Cycle
Days inventory outstanding is one of three components of the cash conversion cycle, alongside how long customers take to pay and how long you take to pay suppliers. A business holding 61 days of stock, collecting in 45 days, and paying suppliers in 30 has its cash out of reach for 76 days on every cycle. Reducing inventory days is one of three available levers, and often the slowest to move.
Because those levers interact, it is worth looking at the full picture rather than optimising one number. The working capital calculator computes the full cycle from all three inputs, and the burn rate calculator shows how the resulting cash position translates into monthly consumption.
Arb Digital builds the demand side for product businesses — search visibility, shopping campaigns, and site performance that move stock rather than store it.
Talk to Arb Digital Browse Free ToolsCommon Mistakes to Avoid
- Dividing revenue by inventory — it inflates turnover by your gross margin and makes the result incomparable to any benchmark.
- Using a single year-end stock figure — many businesses deliberately run stock down at year end, which flatters the ratio.
- Reading a blended ratio as the whole story — fast and slow lines average into a number that describes neither.
- Chasing turnover without counting stockouts — lost sales are invisible in the accounts and can cost more than the carrying cost saved.
- Comparing across categories — fresh goods and capital equipment have structurally different turnover, and neither figure informs the other.
Related Free Tools From Arb Digital
See the full cash cycle with the working capital calculator, check margin on the stock you hold with the gross margin calculator, price with carrying costs included using the product pricing calculator, and find the volume that covers fixed costs with the break-even calculator. Browse the full free online tools hub for more.
Frequently Asked Questions
Divide cost of goods sold for a period by average inventory at cost for the same period. Average inventory is usually opening plus closing divided by two, though a monthly average is more accurate for seasonal businesses.
The average number of days stock is held before it sells, calculated as days in the period divided by the turnover ratio. At 6.0 turns over a 365-day year, that is about 61 days.
Cost of goods sold. Inventory is carried at cost, so using revenue inflates the ratio by the gross margin percentage and breaks any comparison with published benchmarks, which are built on cost.
It depends entirely on the category. Perishable goods turn many times a year by necessity; high-value durable goods turn a few times. Comparing your own trend over time, or sector data such as the Census Bureau's inventory-to-sales ratios, is more meaningful than a general figure.
The average inventory balance is cash already spent and not yet recovered. This calculator shows that balance plus the annual holding cost of carrying it, and what a higher turnover rate would release.
Yes. Turnover improved by holding too little stock produces stockouts, lost sales, and lost repeat custom, and smaller more frequent orders can forfeit volume discounts and raise freight cost per unit.
Storage and warehousing, insurance, handling and counting labour, shrinkage and damage, obsolescence and markdowns, and the cost of the capital tied up in the stock rather than being used elsewhere.
Figures produced by this tool are planning estimates only and do not constitute financial, tax, or accounting advice. Inventory valuation methods and their tax treatment vary by jurisdiction and by the accounting method in use.
