Inventory Period Calculator

What this calculator does

Stock does not sell the moment it arrives. It sits, sometimes for weeks, sometimes for the better part of a year, and this calculator measures how long that is on average:

Inventory period = 365 × Average inventory ÷ Annual cost of goods sold

The answer comes back in days, and it goes by several names: days inventory outstanding, days sales of inventory, or simply days in inventory. Whatever it is called, it converts a balance sheet figure into a length of time, which is a far more useful way to think about stock than a currency amount.

Days on the shelf, and what each one is costing you

A result of 118 days means the typical item spends roughly four months in the business between arriving and being sold. That framing matters because it makes visible something a balance sheet hides: inventory is not just an asset, it is money that has already left and has not come back yet.

The business paid suppliers for those goods. Until a customer buys them, that cash is sitting in a warehouse in the form of things. Every day on the shelf is a day the money cannot be used for anything else, and it is a day of storage costs, insurance, handling, and the risk that the goods go out of fashion, expire, or are quietly written down. Long inventory periods are how profitable-looking businesses end up short of cash.

So lower is generally better, but not without limit. Push the period down too far and you run out of stock, disappoint customers, and lose sales you could have made. The right number is the shortest one that still keeps the shelves adequately full, and where that sits depends entirely on what you sell.

This figure is the mirror image of inventory turnover, which counts how many times stock is sold and replaced in a year. Divide 365 by the turnover and you get this period, and vice versa. Turnover expresses the same fact as a frequency, and days express it as a duration, which most people find easier to act on.

Two figures, and keeping them on the same year

1. Annual cost of goods sold. A full year's cost of sales from the income statement. Cost, not revenue, because inventory is carried at cost and the two must be measured on the same basis.
2. Average inventory. Opening inventory plus closing inventory, divided by two.

Two habits keep the answer honest. The 365 in the formula assumes the cost of goods sold figure covers a full year, so if you only have a quarter's figures, either multiply the quarter by four or replace the annual logic in your head with roughly 91 days. Feeding a quarter's cost of sales into a formula built for a year will inflate the period by about four times.

The averaging matters most for seasonal businesses. A retailer measured just after the festive season has almost empty shelves; the same retailer measured a month earlier is stacked to the ceiling. Averaging opening and closing figures smooths some of that, though for a genuinely seasonal trade it is worth looking at several points across the year rather than trusting a single reading.

Three trades, three shelf lives

Take three businesses and watch how far apart a perfectly healthy answer can sit.

• Grocer with average inventory of 50,000 against annual cost of sales of 900,000: 20.3 days. Stock turns over eighteen times a year, which is what fresh food demands.
• General retailer with 275,000 against 850,000: 118.1 days. Around four months on the shelf, turning just over three times a year.
• Jeweller with 600,000 against 400,000: 547.5 days. Eighteen months of stock, which sounds alarming until you remember that a jeweller sells a small number of expensive, slow-moving items and must hold a range for customers to choose from.

None of these is right or wrong on its own. The grocer would be in serious trouble at 118 days because the goods would have rotted; the jeweller at 20 days would have almost nothing in the window. What each business should watch is its own figure over time, and its close competitors.

Where this number sits in the cash conversion cycle

The inventory period is genuinely useful on its own, but its real job is as one leg of a bigger measurement, and seeing that structure is what turns it from a statistic into a management tool.

Follow a unit of cash through a business. It leaves when you pay your supplier. It comes back when your customer pays you. The gap between those two moments is the cash conversion cycle, and it has three parts:

Cash conversion cycle = Inventory period + Receivables period − Payables period

The inventory period is this calculator's number, the time goods spend in stock. The receivables period is how long customers take to pay after buying. Those two together are the operating cycle, the full journey from goods arriving to cash arriving. Then you subtract the payables period, the time you take to pay your own suppliers, because during that window your suppliers are effectively financing you for free.

Put numbers to it. A business with an inventory period of 118 days, customers who take 45 days to pay, and suppliers it pays after 60 days has a cash conversion cycle of 118 + 45 − 60 = 103 days. That is how long the company must fund its own operations out of its own pocket, and it is the number that explains why a growing, profitable business can still run out of money: growth means buying more stock sooner, and the cash gap widens with it.

What makes the inventory period the most interesting of the three is that it is usually both the largest and the most controllable. You cannot easily make customers pay faster, and stretching suppliers has limits before relationships suffer. But how much stock you hold and how quickly it moves is genuinely within the business's control, which is why shaving days off this figure is one of the most reliable ways to free up cash without borrowing any.

Questions people ask

What is a good inventory period?

It depends entirely on what is being sold. Fresh food turns over in days, heavy machinery or jewellery in many months. Compare against direct competitors and against the company's own trend rather than a universal target.

Why use cost of goods sold rather than sales?

Because inventory is carried at cost. Using sales would compare a figure that includes profit margin against one that does not, which understates the period.

How does this relate to inventory turnover?

They are the same information in different units. Divide 365 by the turnover to get the period in days, or divide 365 by the period to get the turnover.

Our inventory period is rising. What does that mean?

Stock is moving more slowly relative to sales. That can be deliberate, such as building up before a busy season, or it can mean goods are not selling and may eventually need writing down.

References

Days' sales in inventory measures the average number of days stock is held before being sold, and is derived from inventory turnover, which compares cost of goods sold against average inventory. The measure forms one component of the cash conversion cycle, alongside the receivables and payables periods, which together describe how long a company's cash is committed to its operating cycle before being recovered.

1. OpenStax, Principles of Finance, 6.2 Operating Efficiency Ratios. https://openstax.org/books/principles-finance/pages/6-2-operating-efficiency-ratios
2. Wall Street Prep, Cash Conversion Cycle. https://www.wallstreetprep.com/knowledge/cash-conversion-cycle-ccc/