Inventory Turnover Calculator

๐Ÿ’ผ Finance & Money

Inventory Turnover Calculator

Measure how many times your inventory sells through per year โ€” and how many days your cash sits on the shelf.

Advertisement
๐Ÿ“ฆ
Inventory Turnover Calculator

Enter your annual cost of goods sold and inventory values. Get your turnover ratio, days inventory outstanding, and a health read.

Your Figures (Annual)
From your income statement โ€” what the goods you sold cost you, not your sales revenue
Leave blank to use beginning inventory as the average
Please enter annual COGS and at least a beginning inventory value greater than zero.
Inventory Turnover Ratio
0ร—
times your average inventory sold through this year
Turnover per Year
โ€”
Days Inventory Outstanding
โ€”
Average Inventory
โ€”
Months of Stock
โ€”
Capital Tied Up
โ€”
COGS per Day
โ€”
Reminder: Healthy turnover is industry-specific โ€” a grocer at 15ร— and a jeweller at 2ร— can both be perfectly run. Compare your ratio against your own industry's norms and your own prior years, not a universal target.
Advertisement

What Is Inventory Turnover?

Inventory turnover measures how many times a business sells through its average inventory in a year. A turnover of 6ร— means your typical stock level converts into sales six times annually โ€” equivalently, product sits about 61 days before selling. It's the core efficiency metric for any business that holds stock, because inventory is cash in physical form: every dollar on the shelf is a dollar not paying rent, funding marketing, or extending your runway.

How Inventory Turnover Is Calculated

Average Inventory = (Beginning + Ending Inventory) รท 2
Inventory Turnover = Annual COGS รท Average Inventory
Days Inventory Outstanding (DIO) = 365 รท Turnover

Use cost of goods sold, not revenue, in the numerator โ€” inventory is valued at cost, so dividing sales revenue by cost-valued inventory inflates the ratio by your markup and makes results incomparable. Some analysts do quote a sales-based version; it's fine for trend-watching within one company but useless for benchmarking. This calculator uses the standard COGS method, consistent with how Investopedia defines inventory turnover.

What Is a Good Inventory Turnover Ratio?

Entirely industry-dependent โ€” the spread across sectors is enormous:

  • Grocery & supermarkets: 12โ€“20ร— (perishables force fast cycles)
  • General retail & e-commerce: 4โ€“8ร— is a common healthy band
  • Apparel & fashion: 4โ€“6ร—, with seasonal spikes and markdown risk
  • Consumer electronics: 6โ€“10ร— โ€” obsolescence punishes slow movers
  • Furniture, jewellery, luxury: 1.5โ€“4ร— is normal; high margins compensate for slow cycles
  • Restaurants: 25ร—+ on food inventory

Within any industry, the pattern holds: too low means capital trapped in slow or dead stock plus storage and obsolescence costs; too high can mean chronic stockouts, lost sales, and expensive rush reordering. The optimum is the fastest turnover you can run without missing sales.

How to Use This Calculator

Pull annual COGS from your income statement and inventory values from your balance sheet (beginning = last year's closing figure). Enter both inventory values for a proper average โ€” or just the beginning value if that's all you have. You'll get your turnover ratio, days inventory outstanding, months of stock on hand, and the capital currently tied up in inventory, plus a health read. Rerun it quarterly with trailing-twelve-month COGS to catch trend changes early โ€” deteriorating turnover shows up here quarters before it shows up as a cash crunch.

Worked Example

An e-commerce store's annual COGS is $480,000. Inventory started the year at $90,000 and ended at $70,000, so average inventory is $80,000. Turnover is $480,000 รท $80,000 = 6ร—, and DIO is 365 รท 6 = 61 days. That sits comfortably in the healthy retail band: stock converts to cash every two months, with $80,000 of working capital doing the job. If the owner cut average inventory to $60,000 at the same sales rate (8ร— turnover), they'd free $20,000 of cash permanently โ€” real money for a business watching its burn rate.

How to Improve Inventory Turnover

  • Find your dead stock: rank SKUs by individual turnover โ€” the blended average always hides a tail of items that haven't moved in months; discount or bundle them out
  • Reorder on data, not habit: set reorder points from actual sales velocity and supplier lead times rather than gut feel
  • Buy smaller, more often: bulk discounts frequently lose to the carrying cost of the extra months of stock they create
  • Forecast seasonality explicitly: most overstock is bought for a peak that was predicted from optimism instead of last year's numbers
  • Negotiate consignment or returns for risky new lines so slow movers become the supplier's problem, not your balance sheet's
๐Ÿ’ก DIO is one leg of the cash conversion cycle: DIO + days sales outstanding โˆ’ days payable outstanding = the days between paying for stock and collecting cash from its sale. Cutting DIO by 20 days shortens that entire cycle by 20 days โ€” often worth more than a point of margin.

Connected Numbers Worth Checking

Turnover interacts directly with your profit margin โ€” the classic retail trade-off is margin ร— turnover, and a 30%-margin product turning 8ร— out-earns a 50%-margin product turning 3ร—. It also feeds your break-even point through carrying costs, and any cash it frees flows straight into the balance your runway calculator starts from.

Frequently Asked Questions

How do you calculate inventory turnover?
Divide annual cost of goods sold by average inventory, where average inventory is (beginning + ending) รท 2. Annual COGS of $480,000 against $80,000 average inventory gives 6ร— turnover, meaning stock sells through six times per year.
Should I use sales or COGS for inventory turnover?
COGS. Inventory is carried at cost, so dividing cost-valued inventory into revenue inflates the ratio by your markup and breaks comparability with industry benchmarks. A revenue-based version exists but is only useful for tracking your own trend, never for comparison.
What is a good inventory turnover ratio?
It varies enormously by industry: grocery runs 12โ€“20ร—, general retail and e-commerce 4โ€“8ร—, apparel 4โ€“6ร—, and furniture or jewellery 1.5โ€“4ร— quite healthily. Compare against your own sector and your own prior periods rather than a universal number.
What is days inventory outstanding (DIO)?
DIO converts turnover into days: 365 รท turnover ratio. A 6ร— turnover equals roughly 61 days of inventory on hand โ€” the average time between receiving stock and selling it, and one of the three legs of the cash conversion cycle.
Is a higher inventory turnover always better?
Up to a point. Higher turnover means less cash trapped in stock, but extremely high turnover often coincides with stockouts, lost sales, and premium rush-shipping costs. The goal is the fastest turnover that still keeps shelves full enough to never miss a sale.
What does low inventory turnover indicate?
Capital tied up in slow-moving or dead stock, with storage, insurance, and obsolescence costs compounding the problem. It can also be structurally normal for high-margin slow-cycle goods โ€” a jeweller at 2ร— may be perfectly healthy while a grocer at 2ร— is in crisis.
How can I improve my inventory turnover?
Rank SKUs individually to expose dead stock and clear it, set reorder points from real sales velocity, buy smaller quantities more frequently, forecast seasonal demand from last year's data rather than optimism, and push slow-mover risk to suppliers via consignment terms.
How often should I calculate inventory turnover?
Quarterly at minimum, using trailing-twelve-month COGS against the current average inventory. Turnover deteriorates quietly โ€” checking it quarterly surfaces slow-moving stock and over-ordering months before they become a visible cash-flow problem.
Is my data private?
Yes. Every calculation on this page runs entirely inside your browser using JavaScript. Nothing you type is stored, logged, or sent to any server, and you can use the calculator offline once the page has loaded.
Advertisement
Scroll to Top