Business

Inventory Turnover: How to Calculate It and What It Tells You

Learn how to calculate inventory turnover and days in inventory, read the result by product line, and free up cash sitting on your shelves.

Table of contents

Every product on your shelf is cash you already spent. Until it sells, that money can’t pay rent, cover payroll or buy the stock that actually moves. Inventory turnover tells you how quickly that cash comes back to you. The formula is short: cost of goods sold divided by average inventory. The useful part is what you do with the answer.

This guide walks through the calculation, a worked example for a small bike shop, and the practical moves that improve the number without leaving you with empty shelves.

What inventory turnover measures

Inventory turnover counts how many times you sell through and replace your average stock in a period, usually a year. A turnover of 4 means you cycled through your average inventory four times. A turnover of 12 means roughly once a month.

It matters because stock sitting still has costs. It ties up cash, takes up space, can go out of style or expire, and often ends up sold at a discount. That is one reason a business can look profitable on paper and still feel short of money, a gap explained in cash flow vs profit.

The formula

  • Inventory turnover = Cost of goods sold ÷ Average inventory
  • Average inventory = (Inventory at start of period + Inventory at end of period) ÷ 2
  • Days in inventory = 365 ÷ Inventory turnover

Use cost of goods sold (COGS), not sales revenue. Your inventory is recorded at what you paid for it, so comparing it to sales at retail prices would inflate the result. You’ll find COGS near the top of your income statement; if you’re not sure where, see how to read a profit and loss statement.

Days in inventory is often easier to act on. “Our stock sits for about 90 days” is more concrete than “our turnover is 4.”

Worked example: a small bike shop

Ridgeway Cycles is a neighborhood bike shop that sells new bikes, parts and accessories, and cycling clothing. Over the past year:

  • Cost of goods sold: $240,000
  • Inventory on January 1: $55,000
  • Inventory on December 31: $65,000

Average inventory is ($55,000 + $65,000) ÷ 2 = $60,000. Turnover is $240,000 ÷ $60,000 = 4. Days in inventory is 365 ÷ 4 ≈ 91 days.

That single number hides a lot. Here is the same shop broken down by product line:

Product lineAnnual COGSAverage inventoryTurnoverDays in inventory
New bikes$150,000$42,0003.6about 102
Parts and accessories$60,000$8,0007.5about 49
Clothing$30,000$10,0003.0about 122
Whole shop$240,000$60,0004.0about 91

Now the picture is clearer. Parts and accessories move fast. Clothing sits for about four months. New bikes hold most of the money: $42,000 of the shop’s $60,000 in stock.

What a small improvement is worth

Say the owner tightens bike ordering so bikes turn 5 times a year instead of 3.6, with the same $150,000 in bike COGS. The average bike inventory needed drops to $150,000 ÷ 5 = $30,000. That frees about $12,000 in cash, and bikes would sit for about 73 days instead of about 102.

Nothing about sales changed. The shop simply stopped holding $12,000 of stock it didn’t need at any given time. For a small business, that can be the difference between a tight month and a comfortable one.

Is a higher number always better?

Not always. Turnover that is too high can mean you are running out of stock and losing sales, or ordering in small batches that cost more per unit. A grocery store and a furniture showroom will have very different normal ranges, so comparing yourself with a business in another industry tells you little.

The more useful comparisons are:

  • Against yourself over time. Is turnover rising or falling year over year, or season over season?
  • Between your own product lines. Which categories tie up cash and which earn their shelf space?
  • Against margin. A slow item with a high gross margin may still be worth carrying. A slow item with a thin margin rarely is. If you need a refresher on margin, see gross profit vs net profit.

Common mistakes when calculating it

  • Using sales instead of COGS. This overstates turnover because sales include your markup.
  • Using only year-end inventory. If you stock up for a busy season or clear out before year-end, one snapshot can mislead. Averaging monthly inventory counts gives a truer picture for seasonal businesses.
  • Looking only at the total. As the bike shop shows, one strong category can hide a weak one.
  • Counting dead stock as inventory. Items that will never sell at full price still sit in your average and make turnover look worse, but they also hide the real problem. Count them separately.

How to improve inventory turnover

There are only two levers: sell more of what you hold, or hold less for what you sell. In practice:

  • Order smaller, more often for steady sellers, as long as shipping and minimum order costs don’t wipe out the gain.
  • Talk to your suppliers about lower minimums, faster delivery or consignment for slow lines. Shorter lead times let you carry less safety stock. Our guide on how to find suppliers for your business covers what to ask.
  • Cut the long tail. Stop reordering items that sell a few units a year unless they bring customers in for other purchases.
  • Clear aging stock deliberately. A planned markdown on old clothing is better than letting it sit another season. Just know what the discount costs you before you set it.
  • Use sales history to order. Even a simple spreadsheet of units sold per month per item beats ordering from memory.

What to do this week

  1. Pull last year’s COGS and your inventory value at the start and end of the year.
  2. Calculate turnover and days in inventory for the whole business.
  3. Repeat the calculation for your three to five biggest product lines.
  4. Pick the slowest line that holds the most cash and set one change for it: a smaller next order, a supplier conversation, or a clearance plan.
  5. Recalculate every quarter so you can see whether the change worked.

Inventory turnover is one of the core numbers in small business finance basics. Once you know it, you know how long your cash is locked up on the shelf, and you can start getting it back sooner.

This article is general information, not professional accounting advice; how you value inventory for tax and reporting purposes can depend on your country and your accountant’s guidance.

]

About Devin Haney

Writes practical business guides for GlaadVoice.

More guides by this author

Running the numbers for your business?

Free invoice, pricing, margin, and ROI tools — no sign-up.

Try our free tools