What Is Days Sales of Inventory (DSI)? Formula and Calculation

Search Fintrev

Search our guides, reviews and glossary.

Days sales of inventory (DSI) is the average number of days a company takes to turn its inventory into sales. It is calculated by dividing inventory by cost of goods sold (COGS) and multiplying by the number of days in the period. The result tells you how long, on average, cash stays tied up in stock before that stock is sold. A DSI of 45 means the inventory on hand equals about 45 days of the cost of goods the company sells.

The standard DSI formula is:

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

For a full fiscal year, the number of days is usually 365. For a quarter, it is usually 90 or 91. Some analysts use 360 for a year.

What Is Days Sales of Inventory (DSI)?

DSI is an efficiency ratio. It converts the inventory figure on a balance sheet into a time measure: how many days the current stock would last if the company kept selling at its recent pace of cost of goods sold. Because it describes how quickly inventory becomes sales, it is also described as a measure of the liquidity of inventory.

The same metric appears under several names, which can make textbooks and financial databases look inconsistent when they are describing one calculation:

• Days inventory outstanding (DIO)
• Days in inventory (DII)
• Days sales in inventory
• Average age of inventory
• Days inventory or inventory days
• Days of inventory on hand (DOH), a name used more often in operations and supply chain work

Whichever label is used, the core idea is the same: inventory measured against the daily cost of the goods being sold. When a source says “inventory days” for a company, it almost always means this figure. “DSI” in this context stands for days sales of inventory, although the acronym has unrelated meanings in other fields.

There is one naming wrinkle. In supply chain planning, “days of supply” or “days of inventory on hand” is sometimes calculated in units rather than dollars, using a forecast of future daily demand instead of historical COGS. That version answers a forward-looking operational question (“how many days until we run out?”). The accounting version covered here answers a backward-looking financial one (“how long has our stock been taking to sell?”). The two can produce different numbers for the same warehouse.

Generally, a lower DSI is preferred, because it means a shorter time to clear the stock. What counts as low, however, depends heavily on the industry.

How Days Sales of Inventory Works

To make a salable product, a company buys raw materials and other inputs, which sit in inventory at cost. Manufacturing adds further costs, such as direct labor and factory utilities. When the product is sold, all of those costs leave inventory and appear on the income statement as cost of goods sold. COGS is the cost of acquiring or producing the goods a company sold during the period.

DSI links these two figures. Inventory is valued at cost on the balance sheet, and COGS is also measured at cost, so dividing one by the other compares like with like.

Calculating Days Sales of Inventory

The formula can be read in two equivalent ways.

Version 1, ratio times days:

DSI = (Inventory ÷ COGS) × Days in period

Version 2, inventory divided by daily cost:

DSI = Inventory ÷ (COGS ÷ Days in period)

The second form shows what the number means. COGS divided by the days in the period is the average cost of goods the company sells per day. Dividing the inventory balance by that daily figure gives the number of days the inventory would cover.

Working through it step by step:

1. Find inventory on the balance sheet. Include every category: raw materials, work in progress, finished goods and, where reported, progress payments.
2. Decide whether to use the ending balance or an average of the beginning and ending balances (see below).
3. Find cost of goods sold (sometimes labeled cost of sales or cost of revenue) on the income statement for the same period.
4. Divide inventory by COGS.
5. Multiply by the number of days in the period that the COGS figure covers.

Ending Inventory or Average Inventory

Two versions of the formula are in common use, and they answer slightly different questions.

Ending inventory version. The inventory figure is the balance reported at the end of the period, for example at a fiscal year ending June 30. This gives DSI as of that date: how many days of sales the stock on hand at year end represents.

Average inventory = Ending inventory

This is the version sometimes described as “ending inventory divided by cost of goods sold, times 365.”

Average inventory version. The inventory figure is the mean of the beginning and ending balances for the period. This gives DSI during the period, which smooths out a year-end balance that may be unusually high or low.

Average inventory = (Beginning inventory + Ending inventory) ÷ 2

COGS is the same in both versions. Only the inventory figure changes. When inventory is growing, the ending-balance version produces a higher DSI than the average version; when inventory is shrinking, it produces a lower one. Neither is wrong, but comparisons are only valid when every company or period uses the same method.

Where monthly or quarterly balance sheets are available, some analysts average more than two points (for example, five quarter-end balances for a year) to reduce the effect of seasonal peaks and troughs.

Choosing the Number of Days

The day count must match the period the COGS figure covers:

Using 360 days for a year is a simplifying convention; it produces a DSI about 1.4% lower than using 365. The bigger error is a mismatch: annual COGS with a 90-day multiplier, or quarterly COGS with 365, will produce a figure off by a factor of roughly four. Trailing twelve months (TTM) COGS paired with 365 days is a common way to compute an annual-basis DSI from quarterly filings.

Where the Inputs Come From

Inventory appears under current assets on the balance sheet. Manufacturers often break it into raw materials, work in progress and finished goods in the notes to the financial statements; the DSI calculation uses the total. A retailer that buys finished goods for resale typically carries only finished goods, so its total and its finished-goods inventory are the same.

COGS comes from the income statement. Companies label it differently (cost of sales, cost of revenue, cost of products sold), and some service-heavy companies include costs in this line that have nothing to do with physical inventory. If a company sells both products and services, the product-related cost line, where disclosed separately, gives a cleaner DSI.

Days Sales of Inventory Example

Hypothetical Example: Full-Year Calculation

The following figures are a hypothetical illustration, not any real company’s results.

A manufacturer reports:

• Beginning inventory: $4.2 million
• Ending inventory: $5.0 million
• Cost of goods sold for the year: $27.6 million

Average inventory method:

Average inventory = ($4.2 million + $5.0 million) ÷ 2 = $4.6 million

DSI = ($4.6 million ÷ $27.6 million) × 365 = 0.1667 × 365 ≈ 60.8 days

Daily cost check: $27.6 million ÷ 365 ≈ $75,616 of goods sold per day. $4.6 million ÷ $75,616 ≈ 60.8 days. Both forms of the formula give the same result.

Ending inventory method:

DSI = ($5.0 million ÷ $27.6 million) × 365 = 0.1812 × 365 ≈ 66.1 days

Because inventory rose during the year, the ending-balance method shows about five more days than the average method. The year-end stock covers about 66 days of sales, while the average stock over the year covered about 61.

Using 360 days with the average method: 0.1667 × 360 = 60.0 days.

Hypothetical Example: Quarterly Calculation

Suppose the same company’s next quarter shows average inventory of $4.8 million and quarterly COGS of $7.5 million.

DSI = ($4.8 million ÷ $7.5 million) × 90 = 0.64 × 90 = 57.6 days

Using 91 days instead gives 58.2 days. The quarterly DSI is directly comparable to the annual DSI because both are expressed in days, even though the COGS figures cover different lengths of time. Here the drop from about 61 days to about 58 suggests inventory moved somewhat faster in the quarter, although a single quarter can be distorted by seasonality.

Real-Company Illustration: Walmart

Walmart, a retailer, reported inventory of about $54.9 billion and cost of goods sold of about $490 billion for fiscal year 2024. Using the reported year-end inventory:

DSI = ($54.9 billion ÷ $490 billion) × 365 ≈ 0.1120 × 365 ≈ 40.9 days

As a retailer, Walmart does not carry raw materials or work in progress; its inventory consists of finished goods bought for resale. For a manufacturer, the calculation would need to sum all inventory categories to avoid understating DSI.

The roughly 41-day result is a year-end snapshot. Walmart’s fiscal year ends in late January, after the holiday selling season, when retail inventory is typically drawn down from its pre-holiday level. An average-inventory calculation using quarterly balances could give a different figure.

Interpreting Days Sales of Inventory

DSI tells you how long a company’s cash is locked up in inventory. Inventory is money already spent on goods that have not yet generated revenue, and it carries costs while it sits: storage, insurance, handling, financing, and the risk of damage, theft or obsolescence.

What a Low DSI Indicates

A low DSI means the company sells through its stock quickly. That generally points to efficient purchasing and production planning and good alignment between what is stocked and what customers buy. Faster turnover frees up cash and creates the potential for higher profits, provided the goods are being sold at a profit. Selling inventory quickly at a loss does not improve anything.

A DSI that is too low can be a problem. It may mean the company does not hold enough stock to meet demand, which risks stockouts, lost sales, rush orders at higher cost, and customers going to competitors. A falling DSI driven by a company running its shelves bare reads well on a ratio and badly in the sales line.

What a High DSI Indicates

A high DSI means inventory is sitting longer before it sells. Possible causes include:

• Overbuying or overproducing relative to demand
• Slow-moving, outdated or obsolete products that are hard to sell
• A weakening of demand that the company has not yet matched with lower purchases
• Poor inventory management or forecasting

A rising DSI can be an early warning. If inventory grows faster than COGS for several periods, the company may eventually need to discount goods or write down their value, both of which hit margins.

A high DSI is not always a bad sign. A company may deliberately hold more stock to achieve high order-fill rates, for example by building inventory ahead of a holiday season. If management expects a supply shortage in a coming quarter, holding inventory and selling it later at a higher price can improve profits over time. A company may also buy in bulk to secure a volume discount or to protect against rising input costs. In these cases, the question is whether the build is explained and whether it unwinds as planned.

The aim for management is a balance: enough stock to meet demand reliably, without so much that cash and margins suffer.

Why Industry Context Matters

DSI varies widely across industries because of the nature of the product and the business model. Companies selling perishable goods or fast-moving consumer goods (FMCG) cannot hold inventory for long, because the products spoil or lose relevance quickly. Businesses in sectors such as technology hardware, automobiles and furniture can hold inventory longer, and some (such as makers of complex equipment with long production cycles) carry large work-in-progress balances by necessity.

Because of this, a DSI figure on its own says little. It becomes useful in two kinds of comparison:

• Against the same company over time. A change from 45 to 60 days at one company is a signal worth investigating.
• Against direct peers. A grocery chain should be compared with other grocery chains, not with an aircraft manufacturer.

Questions such as what normal inventory days look like for a particular carmaker are best answered by calculating DSI for that company and its close competitors from their own filings, using the same method for each.

Is There a Good DSI Number?

There is no universal target. One rule of thumb places a balanced DSI somewhere between 30 and 60 days, as a range that avoids both excessive idle stock and frequent shortages. That range is a loose guide only. The right level depends on the industry, company size, product type, supply chain lead times and the company’s strategy. A DSI well outside the range can be entirely normal for a given sector.

DSI and Inventory Turnover

Inventory turnover measures how many times a company sells or uses up its inventory over a period, such as a quarter or a year. It is calculated as:

Inventory turnover = COGS ÷ Average inventory

DSI is the same relationship expressed in days instead of times per period:

DSI = (1 ÷ Inventory turnover) × 365

or equivalently, DSI = 365 ÷ Inventory turnover.

Using the hypothetical full-year example above: turnover = $27.6 million ÷ $4.6 million = 6.0 times. DSI = 365 ÷ 6.0 ≈ 60.8 days, which matches the direct calculation. For the Walmart figures, turnover = $490 billion ÷ $54.9 billion ≈ 8.9 times, and 365 ÷ 8.9 ≈ 41 days.

Because one is the inverse of the other, a higher DSI always means lower turnover, and vice versa. Higher turnover generally indicates stronger sales relative to stock. Note that turnover can rise for two reasons: higher sales on the same inventory, or the same sales on smaller inventory. Both produce the same ratio, but the second does not mean demand improved.

Turnover can also look strong while the business loses sales. If demand exceeds the inventory on hand, a company sells everything it has, posts a high turnover and a low DSI, and still misses revenue it could have earned. That is another reason these ratios need context from competitors and from the sales trend.

Many analysts find DSI easier to use than turnover because days are intuitive. “Inventory covers 61 days of sales” is easier to act on than “inventory turns 6.0 times a year,” and days line up directly with other working capital measures in the cash conversion cycle.

DSI in the Cash Conversion Cycle

DSI is the first of three parts of the cash conversion cycle (CCC), which measures how long each dollar invested in operations is tied up before it comes back as cash from customers. The cycle covers turning cash into raw materials or goods, then into sales, then into collected cash.

The three components are:

• Days sales of inventory (DSI): how long goods sit before they are sold.
• Days sales outstanding (DSO): how long it takes to collect payment from customers after a sale (accounts receivable).
• Days payable outstanding (DPO): how long the company takes to pay its own suppliers (accounts payable).

CCC = DSI + DSO − DPO

Supplier credit offsets part of the time cash is tied up in inventory and receivables, which is why DPO is subtracted.

Hypothetical example: a company with a DSI of 61 days, a DSO of 35 days and a DPO of 45 days has a cash conversion cycle of 61 + 35 − 45 = 51 days. If it cut DSI to 50 days, with the other components unchanged, the cycle would shorten to 40 days, meaning each operating dollar returns as cash 11 days sooner. For a company that funds working capital with borrowing, that shorter cycle can mean lower interest costs.

The sum of DSI and DSO alone is sometimes called the operating cycle: the time from acquiring inventory to collecting cash from its sale, before considering supplier credit.

Why Days Sales of Inventory Matters

Managing inventory is central for most businesses that sell physical goods, especially retailers, wholesalers and manufacturers. For many of them, inventory is one of the largest current assets and a major part of the capital needed to run the business. DSI puts that capital into a daily context, which makes it easier to see how efficiently it is being used.

For management, DSI supports decisions on purchasing, production scheduling, pricing and markdowns. A rising DSI in a particular product line can prompt reduced orders or clearance pricing before the goods lose more value.

For investors and analysts, DSI and inventory turnover help show whether a company manages inventory better or worse than its competitors. A 2013 working paper studying retailers examined whether inventory productivity predicts future stock returns and found that companies with higher inventory turnover tended to outperform. One reason is that efficient inventory management can lead to gross margins above what the market expects. Conversely, weak turnover can point to overstocking, product or market problems, or poorly managed inventory, conditions that tend to weigh on performance.

Inventory efficiency also feeds into broader return measures. Holding less inventory for the same sales lowers the asset base, which raises asset turnover, one of the drivers of return on equity (ROE) in a DuPont breakdown. In valuation work, analysts often forecast future inventory balances by projecting DSI, because changes in inventory affect working capital and therefore free cash flow in a discounted cash flow (DCF) model. A company that lets DSI drift upward is investing more cash in stock for each dollar of sales.

For lenders, inventory is often collateral, and a rising DSI can signal that the collateral is becoming harder to convert into cash.

Limitations of Days Sales of Inventory

DSI is simple to calculate, which is part of its appeal, but several factors can distort it or make comparisons misleading.

It lacks context on its own. A single DSI figure does not say whether the level is healthy. It needs a trend line or a peer group to mean anything, and peers must be genuinely comparable in product mix and business model.

Inventory accounting methods differ. Inventory and COGS depend on the cost-flow method a company uses. Under US GAAP, companies may use LIFO (last in, first out), while IFRS does not permit LIFO. When costs are rising, LIFO leaves older, lower costs on the balance sheet and pushes newer, higher costs into COGS. That combination lowers the numerator and raises the denominator, so a LIFO company tends to show a lower DSI than an otherwise identical FIFO company. Companies using LIFO under US GAAP disclose a LIFO reserve, which analysts can use to restate inventory on a FIFO basis for a cleaner comparison.

Snapshot timing and seasonality. The ending-balance method depends on inventory on a single date. Many retailers end their fiscal year after the holiday season, when stock is low, which can make year-end DSI look leaner than the company’s typical level. A company can also time purchases or shipments around a reporting date. Averaging several balances reduces this problem but does not remove it.

Write-downs and reserves. When a company writes down obsolete or damaged inventory, the balance falls and DSI improves, even though the write-down reflects a loss. A sudden improvement in DSI that coincides with an inventory charge says more about past overstocking than about better efficiency.

Mix effects. DSI is an average across all products. A company can have a reasonable overall DSI while one product line is badly overstocked and another is constantly short. Segment or category data, where disclosed, is needed to see that.

Denominator choice. Some sources calculate inventory days using revenue instead of COGS. That mixes a cost-based numerator with a price-based denominator and understates the days. In the hypothetical example, if the company had a 40% gross margin, revenue would be $46 million, and a revenue-based figure would be $4.6 million ÷ $46 million × 365 = 36.5 days, versus 60.8 days on a COGS basis. A revenue-based figure is not wrong as long as it is applied consistently, but it should never be compared against a COGS-based DSI.

Growth and acquisitions. A fast-growing company may build inventory ahead of sales it has not yet booked, and an acquisition can add a full inventory balance while only a partial year of the acquired company’s COGS appears in the period. Both can inflate DSI temporarily without indicating a management problem.

Not relevant for every company. Service businesses and many software companies carry little or no inventory, so DSI is close to zero or meaningless for them. That reflects the business model, not superior inventory management.

FAQs

The Bottom Line

DSI matters most to managers, investors and lenders looking at retailers, wholesalers and manufacturers, where inventory ties up a large share of capital. A lower figure usually means cash returns faster, but a very low or very high DSI each has more than one explanation. The number becomes useful when tracked over time or set against direct peers, with the same inventory method, day count and COGS basis used for every comparison.