Dalal Street Blogs provides information for educational purposes only and does not constitute investment advice. Please consult a SEBI-registered investment adviser before making any investment decisions.
CAUTION: Dalal Street Blogs publishes market news and educational content only. We do not promote, recommend or endorse any stock, and nothing here is a solicitation to buy or sell securities. Please consult a SEBI-registered adviser before investing.

Indian Stock Market News, Analysis and Trading Guides

Earnings & Quarterly Results

Inventory Days Meaning: How to Read Stock Build-Ups in Quarterly Results

Inventory days meaning: warehouse racks stacked with boxed stock and a forklift moving past

Photo: delphinmedia via Pixabay

By Dalal Street Blogs Editorial10 min read

Every quarterly results season, someone on a trading desk says “margins look fine, but check the inventory.” They’re usually right to. Inventory days meaning, in plain words, is the number of days a company’s stock of goods would last at its current rate of cost. When that number climbs, cash is sitting in warehouses instead of the bank. Sometimes that’s smart planning. Sometimes it’s the first quiet sign that demand is slipping.

This guide covers how inventory days are calculated, where Indian investors actually find the inputs in results filings, how to read a stock build-up honestly, and the traps that make the ratio lie. We lean on Investopedia’s explainer on days sales of inventory and the text of Ind AS 2, the Indian accounting standard on inventories. Company K and every rupee figure in the worked examples are made up to show the arithmetic.

In this article
  1. Inventory days meaning and the basic formula
  2. Where Indian investors find the numbers
  3. Reading a stock build-up: good reasons and bad ones
  4. Where inventory days fit in the cash cycle
  5. What the accounting standard adds
  6. Common traps when you calculate it yourself
  7. A simple checklist for the next results filing
  8. What to take away

Inventory days meaning and the basic formula

Investopedia notes that the same measure goes by several names: days sales of inventory (DSI), days inventory outstanding (DIO), days in inventory, or simply inventory days. They all mean one thing. How many days, on average, does it take the company to turn its stock into sales?

The standard formula is:

Inventory days = (Average inventory ÷ Cost of goods sold) × Number of days in the period

Investopedia uses 365 days for a year and 90 for a quarter, and mentions that some analysts use 360. Average inventory is usually the opening and closing figures added together and divided by two. There’s a second version that just uses closing inventory, which gives you a reading “as of” the balance sheet date rather than across the period. Neither is wrong, but you have to pick one and stick with it.

Why cost of goods sold and not sales? Inventory sits on the balance sheet at cost, while sales include the company’s markup. Investopedia’s inventory turnover page points out that using sales instead of cost tends to inflate the turnover ratio. The same distortion shrinks inventory days and makes the business look leaner than it is.

Worked example: Company K’s full year

Say Company K, a hypothetical maker of kitchen appliances, reports:

  • Inventory at the start of the year: ₹400 crore
  • Inventory at the end of the year: ₹500 crore
  • Cost of goods sold for the year: ₹3,285 crore
  • Revenue for the year: ₹4,380 crore

Average inventory is (400 + 500) ÷ 2 = ₹450 crore. Inventory days = 450 ÷ 3,285 × 365 = 50 days.

Inventory turnover is the flip side: 3,285 ÷ 450 = 7.3 times a year. Divide 365 by 7.3 and you’re back at 50 days. Investopedia describes DSI as simply the inverse of turnover scaled to days, so if you know one, you know the other.

Now do it the wrong way, with revenue. 450 ÷ 4,380 × 365 = 37.5 days. Same company, same warehouse, and suddenly it looks like stock moves 12-13 days faster. If you compare a company you’ve calculated on cost against one some website calculated on sales, you’ll draw the wrong conclusion.

Where Indian investors find the numbers

Here’s a practical wrinkle. Indian listed companies file results every quarter, but the balance sheet doesn’t show up every quarter. SEBI’s FAQ on the LODR Regulations confirms that under regulation 33(3)(f), the half-yearly results must include a statement of assets and liabilities as at the end of the half year, plus cash flows for the half year.

So the inventory figure you need comes twice a year in results filings: with the September quarter (Q2) and with the March quarter (full year). The Q1 and Q3 results give you the profit and loss account, but you usually won’t get a fresh inventory number from them. That’s why Q2 season, which is running right now, is a good time to check inventory trends. If you want a refresher on reading that statement, our guide on how to read a balance sheet of a company walks through each line.

Cost of goods sold is the other headache. Indian results don’t always print a single “COGS” line. You often have to build it from the material cost lines, purchases of traded goods and the change-in-inventory line in the expense section. Whatever you include, include the same items every time.

Worked example: Company K’s first half

Company K’s Q2 filing shows a half-year balance sheet. April 1 to September 30 is 183 days.

  • Inventory on March 31: ₹500 crore
  • Inventory on September 30: ₹650 crore
  • Cost of goods sold for the half year: ₹1,800 crore

Using the average method: (500 + 650) ÷ 2 = ₹575 crore. Inventory days = 575 ÷ 1,800 × 183 = about 58 days.

Using closing inventory only: 650 ÷ 1,800 × 183 = about 66 days.

That’s an eight-day gap from the method alone. Neither number is “the” answer. The useful move is comparing like with like. Pull last year’s Q2 filing. Suppose it showed September-end inventory of ₹520 crore against first-half cost of goods sold of ₹1,650 crore. On the closing-inventory basis, that’s 520 ÷ 1,650 × 183 = about 58 days. So on a like-for-like basis, Company K’s inventory days have gone from roughly 58 to roughly 66 in a year.

Another way to feel the size of it: first-half cost of goods sold works out to 1,800 ÷ 183 = about ₹9.8 crore a day. The ₹150 crore build since March is roughly 15 days of cost sitting on the shelves.

A rise in inventory days isn’t a verdict. It’s a question, and the answer is usually somewhere in the management commentary or the next quarter’s sales.

Reading a stock build-up: good reasons and bad ones

A higher number isn’t automatically bad. Investopedia lists several legitimate reasons a company may carry more stock than usual:

  • Getting ahead of a busy season. A company may hold more inventory to fill orders it expects in an upcoming peak selling period.
  • Buying before price hikes. The inventory turnover page notes that low turnover can be an advantage during inflation if it reflects stocking up before supplier prices rise.
  • Supply chain worries. During disruptions, companies may deliberately raise inventory to avoid running short.
  • Expected shortages. Investopedia’s DSI page gives the example of a business holding stock when it expects short supply next quarter, so it can sell later at a better price.

The worrying reasons look different. Across its two pages, Investopedia ties high inventory days to obsolete stock, overinvestment in inventory, weak sales and stock that’s hard to sell. The tell is usually that inventory grows much faster than sales for more than one period, and management’s explanation keeps changing.

For Company K, here’s what we’d want to know. Did revenue in the September quarter grow roughly in line with that inventory build? Did management talk about pre-buying ahead of the festive quarter, or did it go quiet on demand? Is the build in finished goods, which is closer to unsold product, or in raw materials, which might just be a purchase timing call? Ind AS 2 requires companies to disclose inventory in “classifications appropriate to the entity”, so the notes in the annual report usually split it out.

Compare within the sector, not across it

There’s no universal “good” level. Investopedia says inventory days vary widely by industry, and that technology, automobile and furniture businesses can hold inventory for long periods, while companies selling perishables or fast-moving consumer goods can’t. A packaged-foods company with the inventory days of a capital goods maker would be in trouble. The reverse would be unusual too.

So the honest comparisons are two: the company against its own history, and the company against close peers that sell similar products.

Where inventory days fit in the cash cycle

Inventory days are one piece of a bigger picture. Investopedia’s cash conversion cycle page sets out the formula: inventory days plus receivable days (DSO) minus payable days (DPO). A shorter cycle means cash spends less time tied up in stock and unpaid customer bills.

Say Company K’s half-year numbers work out to 58 inventory days, 40 receivable days and 45 payable days. Its cash conversion cycle is 58 + 40 – 45 = 53 days. Each extra day of inventory adds a day to that cycle, unless suppliers give more credit to offset it.

That’s why a stock build often shows up as weak operating cash flow even when reported profit looks healthy. Money spent on inventory doesn’t pass through the profit and loss account until the goods are sold. Our explainer on operating cash flow vs net profit covers how to spot that gap in the cash flow statement.

Profit can look fine for a quarter or two while cash quietly piles up in the warehouse. Inventory days are often where that story shows first.

What the accounting standard adds

Ind AS 2 sets the core rule: inventories are measured at the lower of cost and net realisable value. Net realisable value is the estimated selling price in the ordinary course of business, minus the estimated costs to complete and sell. The standard says cost may not be recoverable if inventory is damaged, wholly or partly obsolete, or if selling prices have fallen.

When that happens, the write-down is recognised as an expense in the period it occurs. If conditions later improve, the write-down can be reversed, but only up to the amount originally written down, so that the carrying amount ends up at the lower of cost and the revised realisable value.

A quick example with made-up figures. Company K holds finished goods that cost ₹20 crore. Prices fall and it now expects to realise only ₹17 crore after selling costs. It writes the stock down by ₹3 crore and takes that as an expense. Next quarter the expected realisable value recovers to ₹19 crore. It can reverse ₹2 crore, bringing the carrying amount to ₹19 crore. It can’t go above the ₹20 crore cost.

Why does this matter for inventory days? Two reasons. A write-down reduces the inventory figure, which mechanically lowers inventory days and can make a problem look like an improvement. And a recurring write-down line is itself a signal that stock is going stale. Ind AS 2 requires companies to disclose the amount of any write-down and any reversal, along with the circumstances behind a reversal, so these numbers are in the notes if you look.

One more disclosure worth a glance: Ind AS 2 also asks for the carrying amount of inventories pledged as security for liabilities. If a big chunk of stock backs working capital loans, a build-up isn’t just a cash question. It’s a borrowing question too.

Common traps when you calculate it yourself

  1. Mixing period lengths. A half-year figure multiplied by 365 instead of 183 roughly doubles inventory days. Match the day count to the cost period.
  2. Mixing methods. Average-inventory days and closing-inventory days can differ by a week or more, as Company K showed. Don’t compare one with the other.
  3. Using sales instead of cost. It flatters the number. If you use sales for one company, use it for all, and know it’s an approximation.
  4. Ignoring acquisitions. Buying a company adds its inventory to the closing balance overnight, while only part of its cost of goods sold lands in your period. Inventory days jump for reasons that have nothing to do with demand.
  5. Reading one period in isolation. Investopedia’s turnover page makes the point that the ratio may not mean much on its own, and becomes useful when you track it over time or against similar companies. Look at three or four half-year readings before you form a view.

A simple checklist for the next results filing

When a company you follow posts its Q2 or full-year numbers, run through this:

  • Work out inventory days on a consistent basis, and compare with the same half last year.
  • Check whether inventory growth is running well ahead of revenue growth.
  • Read the notes for the split between raw materials, work in progress and finished goods, and for any write-downs or reversals.
  • Look at operating cash flow alongside reported profit.
  • Listen to what management says about the build in the earnings call, and check whether the next quarter’s sales back it up.

For the wider routine of reading a results filing line by line, see our pillar guide on how to analyse quarterly results of a company.

What to take away

Inventory days turn a balance sheet number into something you can picture: how long goods sit before they’re sold. The maths is easy. The judgment isn’t. A rising figure can mean a company is planning well for demand it can see, or that it’s stuck with product nobody wants. Get the method consistent, compare against history and peers, and treat any sharp change as a reason to dig into the notes and the next quarter’s numbers rather than a signal on its own.

Disclaimer: This article is for information and education only and is not investment advice or a recommendation to buy or sell any security. Company K and every inventory, cost, revenue, receivable, payable and write-down figure in the worked examples are hypothetical and used only to show the calculations. Investing involves risk, including the loss of capital. Please consult a SEBI-registered investment adviser before making investment decisions.

Leave a Reply

Join the conversation

Commenting is open to registered readers. Sign up with just your email — no password needed, and it takes under a minute.

Sign up to comment Log in