What Is the Stock Days Formula? Inventory Days Explained Simply
30 July 2026
What Is the Stock Days Formula? Inventory Days Explained Simply
It is 11:45 PM. You are staring at a spreadsheet that looks like a crime scene, wondering where all the cash went.
On paper, your business had a brilliant month. Sales are up, customers are buying, and the order book looks full. But when you check the bank account to pay next month’s suppliers and run payroll, the balance is bafflingly low.
The money isn’t lost. It is sitting in the warehouse.
It is wrapped up in cardboard boxes, raw materials, or finished goods that looked like a great deal when you bought them in bulk six months ago, but are now just gathering dust and eating your working capital alive. If you have ever felt that knot in your stomach, wondering how long your cash is trapped on shelves before it turns back into actual money, you have run headfirst into the core puzzle of inventory management.
To solve it, you need one specific tool: the stock days formula.
Let’s pull up a chair, open that spreadsheet together, and figure out how to calculate it, what the numbers are actually telling you, and how to get your cash moving again.
What Are "Stock Days" (And Why Should You Care)?
Stock days—often called Days Sales of Inventory (DSI) or days inventory outstanding (DIO)—measures the average number of days it takes a business to turn its inventory into sales.
In plain English: If you stopped buying inventory today, how many days would it take to sell every single item currently in your warehouse?
If your answer is 15 days, your cash is cycling through your business at a healthy clip. You sell things, you get paid, you buy more stock. But if your answer is 180 days, you have a massive problem. That means half a year’s worth of operating cash is frozen in a back room somewhere, waiting for a buyer.
Before we dive into calculators and ratios, it helps to understand the wider financial ecosystem of your business. When you are looking at cash flow, inventory is just one piece of the puzzle alongside loans, payroll, and overall business health — tools like our Business Finance categories are designed to help you see the whole picture.
For now, let's look at the math behind how your stock is actually performing.
The Stock Days Formula
The formula itself is surprisingly straightforward. You don't need an MBA or a fancy financial terminal to run it.
Here is the standard stock days formula:
$$\text{Stock Days} = \left( \frac{\text{Average Inventory}}{\text{Cost of Goods Sold (COGS)}} \right) \times 365$$
Let's break down those two moving parts so you don't feed bad data into your spreadsheet and get a terrifying (or falsely comforting) result.
1. Average Inventory
Why do we use average inventory instead of what is sitting on your shelves right now?
Because inventory fluctuates. If you run a seasonal business, your stock might peak at £100,000 in November for the holidays and drop to £20,000 in February. If you only look at your February snapshot, your numbers will be wildly skewed.
To find Average Inventory, take your starting inventory for a period (say, the start of the year) and your ending inventory, add them together, and divide by two:
$$\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}$$
(Pro tip: If you want even more accuracy, you can take the average of all 12 month-end inventory balances, but the two-point average works fine for most small-to-medium businesses.)
2. Cost of Goods Sold (COGS)
This is the direct cost of producing the goods you sold during that same time period. It includes raw materials, direct labor, and manufacturing overhead.
A common trap: Do not use your total revenue or sales figure here. You must use COGS. Revenue includes your profit markup, which would artificially shrink your stock days and make your inventory efficiency look much better than it actually is.
A Walkthrough: Following Sarah’s Boutique
Let’s look at a real, ground-level example.
Meet Sarah, who runs an independent apparel business. Sarah has a good eye for style, but lately, she feels like she is constantly scrambling for cash despite having a full warehouse. She decides to sit down and calculate her stock days for the past year to see where her money is hiding.
Step 1: Gather the raw numbers
Sarah pulls her year-end financial statements and finds the following:
- Beginning Inventory (January 1): £40,000
- Ending Inventory (December 31): £60,000
- Cost of Goods Sold (COGS) for the year: £150,000
Step 2: Calculate Average Inventory
First, Sarah figures out what her typical inventory investment looked like over the course of the year:
$$\text{Average Inventory} = \frac{£40,000 + £60,000}{2} = £50,000$$
So, on average, Sarah kept £50,000 worth of clothing sitting in her warehouse at any given moment.
Step 3: Apply the Stock Days Formula
Now, Sarah plugs her numbers into the formula:
$$\text{Stock Days} = \left( \frac{£50,000}{£150,000} \right) \times 365$$
Let's do that math step by step:
- Divide £50,000 by £150,000 = 0.3333
- Multiply 0.3333 by 365 days = 121.66 days
Sarah rounds it up: 122 days.
What does this mean for Sarah?
It takes Sarah an average of four months (122 days) to sell a piece of clothing from the moment she buys it from the manufacturer to the moment a customer buys it.
Suddenly, her cash flow crunch makes sense. Her money is trapped in winter coats and summer dresses for a third of the year. If suppliers demand payment in 30 days, but Sarah’s inventory takes 122 days to sell, she is financing a massive gap out of her own pocket.
She needs to get that 122-day figure down. But how?
What Trips People Up: Common Mistakes in Inventory Math
When business owners first calculate their stock days, they often make a few classic missteps. If your number looks suspiciously high—or impossibly low—check whether you've fallen into one of these traps.
Mistake #1: Mixing Retail Price with Cost
This is the number one error we see. If your inventory is valued at what you hope to sell it for (retail price), but your COGS is valued at what it actually cost you to make or buy, your ratio will be completely distorted. Always use cost value for both sides of the equation.
Mistake #2: Ignoring Seasonality
If you calculate your stock days annually, you are smoothing over wild operational swings. A toy store might have stock days of 30 in December, but 300 in March. Running a rolling 12-month calculation or looking at quarterly stock days gives you a much truer picture of your operational health.
Mistake #3: Treating "Slow Stock" Like Healthy Stock
The stock days formula calculates an average. If you have 90% of your inventory turning over in 20 days, but 10% of your stock has been sitting in a dark corner of the warehouse for five years, that dead stock will drag your overall average up and mask the rot. Always audit your physical inventory lines alongside your financial ratios.
How to Interpret Your Number: Is 30 Days Good or Bad?
There is no universal "good" or "bad" number for stock days. It depends entirely on your industry.
- Grocery Stores & Supermarkets: These businesses deal in perishables with razor-thin margins. Their stock days might be 5 to 15 days. If milk sits for a month, you have a disaster.
- Fast Fashion & Apparel: Typically runs between 60 to 90 days. Styles change quickly, so sitting on inventory too long forces heavy clearance discounts.
- Heavy Machinery & Industrial Parts: Can easily run 180 to 365+ days. Specialized parts for aircraft or construction equipment take a long time to build and an even longer time to find the right buyer, which is normal for that sector.
The golden rule isn't chasing an industry benchmark blindly—it is improving your own trend over time. If your stock days were 150 last year and 120 this year, your cash is freeing up, and your operational efficiency is improving.
The Ripple Effect: How Stock Days Connect to the Rest of Your Finances
Inventory doesn’t live in a vacuum. The stock days formula is actually part of a larger financial triad known as the Cash Conversion Cycle (CCC).
The cash conversion cycle tracks the exact lifespan of a pound, dollar, or rupee inside your business:
- Days Inventory Outstanding (DIO): How long stock sits on shelves (our stock days formula).
- Days Sales Outstanding (DSO): How long it takes customers to pay their invoices.
- Days Payable Outstanding (DPO): How long you take to pay your own suppliers.
[Cash Leaves] ---> [Buy Inventory (DIO)] ---> [Sell to Customer] ---> [Collect Cash (DSO)] ---> [Cash Returns]
^
|--- (Delayed by Supplier Terms / DPO) ---|
If your stock days are high (DIO is long) and your customers take forever to pay you (high DSO), but your suppliers want their money right now (low DPO), your cash flow will break—even if your profit margins look great on paper.
Managing this balance is why business owners spend so much time looking at working capital. When you are projecting how much cash your business needs to survive a growth phase or a seasonal dip, understanding your inventory velocity is just as important as knowing your payroll or debt obligations.
Taking Action: Three Ways to Lower Your Stock Days
If your stock days calculation came back higher than you’d like, take a deep breath. This is a fixable problem. You don't have to overhaul your entire business model overnight; you just need to pull a few strategic levers.
1. Negotiate Smaller, More Frequent Orders
Many business owners fall in love with bulk-buying discounts. Suppliers will say, "If you buy 1,000 units, the price per unit is £10. If you buy 5,000 units, it drops to £7."
It sounds like a bargain. But if those extra 4,000 units sit in your warehouse for two years, the cost of warehousing, insurance, and—most importantly—tied-up cash completely wipes out that initial per-unit savings. Run the numbers on holding costs before you sign up for massive bulk orders.
2. Implement Just-In-Time (JIT) Principles
You don’t need to be Toyota to use Just-In-Time thinking. Look at your supply chain and ask: Can we have suppliers ship materials in smaller batches closer to the exact date we need to build or sell them? Reducing batch sizes is one of the fastest ways to slash your average inventory balance.
3. Run Aggressive Promotions on Dead Stock
Every week that slow-moving item sits on your shelf, it is costing you money in storage space and opportunity cost. It is often better to sell old inventory at cost—or even at a slight loss—just to turn that dead weight back into liquid cash that you can reinvest into fast-moving, high-margin products.
You Can Clear the Fog
Staring at complex financial formulas late at night can make business feel overwhelming. When the cash is low and the warehouse is full, it's easy to feel like you're losing control.
But numbers like stock days aren't there to judge you—they are there to illuminate the path forward. Once you calculate your inventory turnover, the mystery of the missing cash disappears. You stop guessing where your money went, and you start seeing the exact levers you can pull to bring it back home.
Take it one step at a time. Pull your inventory and COGS numbers, run the formula, and see where your business stands today. Armed with that clarity, you can make smarter purchasing decisions tomorrow—and finally get some sleep.
Frequently Asked Questions
What is the difference between stock days and inventory turnover ratio?
They are two sides of the same coin. Inventory turnover ratio measures how many times your inventory is sold and replaced over a period (e.g., 4 times a year). Stock days (DSI) translates that frequency into how many days it takes for a single cycle to complete.
- To find stock days:
(365 / Inventory Turnover Ratio). - Both tell you the same story; stock days just frames it in units of time, which makes cash flow planning much easier to visualize.
Can stock days be too low?
Yes! While low stock days generally mean your cash is moving fast, having an inventory level that is too low can lead to frequent stockouts. If you run out of popular items before new shipments arrive, you lose sales and frustrate customers who will simply take their business to a competitor. The goal is balance: efficient turnover without sacrificing product availability.
Should I use total revenue or COGS in the stock days formula?
Always use Cost of Goods Sold (COGS). Using total revenue will artificially lower your stock days because revenue includes your profit markup. Since inventory is recorded on your balance sheet at cost, comparing it to revenue creates an apples-to-oranges mismatch that will give you inaccurate results.
Disclaimer: This article is for informational and educational purposes and does not constitute formal financial advice. Every business has unique operational needs; consider consulting a qualified accountant or financial professional before making major structural changes to your inventory or supply chain.
When you want to run your business numbers on the go, check out the free Finlas app to make calculations simple anywhere, anytime.
