Inventory Turnover Ratio Retail: Turns, DIO, and Markdown Risk

Key Takeaways

• Inventory turnover ratio retail equals COGS divided by average inventory; warehouse clubs run 12–13 turns while department stores and specialty apparel run 3–5 turns.
• Walmart reported 9.1 turns and Costco 13.2 turns for their most recent fiscal years, reflecting structurally different business models rather than relative operating quality.
• A common mistake is using revenue instead of COGS as the numerator, which inflates the ratio because revenue includes gross margin while inventory is held at cost.
• Inventory growing faster than sales for two consecutive quarters is the most reliable warning sign that margin-eroding markdowns are coming within one to two reporting periods.

What It Is

Inventory turns, also called the inventory turnover ratio, equals Cost of Goods Sold (COGS) divided by average inventory. A turns figure of 8 means the retailer sold through its average stock eight times during the year, or roughly every 46 days.

The inverse, Days Inventory Outstanding (DIO), expresses the same idea in time units: 365 divided by turns. A chain with 8 turns holds about 46 days of inventory; a chain with 4 turns holds about 91 days. Investors use turns to judge whether a retailer is moving goods at a healthy clip or sitting on stock that may need to be marked down.

The Intuition

Inventory is cash in another form. Every dollar parked in a warehouse is a dollar not earning a return somewhere else, and every extra week that product sits on the shelf raises the risk it has to be discounted. The retailers with the best long-run economics almost always have the highest turns in their category.

High turns also tell you something about the value proposition. Costco sells fewer SKUs at thin margins, but those SKUs move fast, which lets it run on razor-thin gross margin and still earn attractive returns on capital. Luxury retailers run the opposite model, carrying slow-turning inventory at fat margins. Neither is wrong; turns simply need to be read against the operating model.

How It Works

The basic formula uses Cost of Goods Sold, not revenue, so inventory (held at cost) and the numerator are on the same accounting basis:

Inventory Turns = COGS / Average Inventory

Average inventory is usually (Beginning Inventory + Ending Inventory) / 2. For quarterly data, analysts sometimes average four quarter-end balances instead of two, which smooths out seasonal swings.

Days Inventory Outstanding is the inverse:

DIO = 365 / Inventory Turns

Typical retail ranges:

• Warehouse clubs (Costco, Sam's Club): 12 to 13 turns.
• Mass merchants and discount (Walmart, Target): 8 to 9 turns.
• Grocery: 12 to 15 turns for perishables-heavy formats.
• Department stores: 3 to 5 turns.
• Specialty apparel: 3 to 5 turns, with wide seasonal swings.
• Luxury and jewelry: 1 to 3 turns.

Walmart reported inventory turnover of 9.10 for the fiscal year ending January 2026, while Costco reported 13.24 for its fiscal year ending August 2025. That gap reflects two different business models, not that one is "better" than the other.

Worked Example

A specialty apparel retailer reports for the year:

• Revenue: $2,000 million
• COGS: $1,200 million
• Beginning inventory: $280 million
• Ending inventory: $320 million

Average inventory = ($280M + $320M) / 2 = $300M.

Inventory turns = $1,200M / $300M = 4.0. DIO = 365 / 4.0 = 91 days.

A year later, the retailer ends with inventory of $420 million on $1,260 million in COGS. Average inventory rises to $370 million, and turns fall to 3.4 (DIO = 107 days). COGS barely grew, but inventory ballooned. That is the classic warning sign that the retailer has overbought or that demand is softening, and it usually precedes margin-crushing markdowns in the following quarters.

Common Mistakes

1. Using revenue instead of COGS. Some sources compute turns as Revenue divided by inventory, which inflates the number because revenue includes margin while inventory is booked at cost. The result is not directly comparable to standard turns and can mislead when margin mix changes.

2. Ignoring the seasonal pattern. A toy retailer measured at October 31 looks stuffed with inventory; the same retailer on January 31 looks nearly empty. Year-end snapshots in cyclical categories can distort turns in both directions. Using four-point quarterly averages or a 13-month average helps.

3. Celebrating falling days without context. Turns that rise because stock is being deliberately starved will show up later as stockouts and lost sales. In 2020, several retailers reported outstanding turns simply because they could not get product through the supply chain. Pair turns with same-store sales and gross margin to read the story.

4. Comparing across models. A luxury jeweler with 2 turns is not "worse" than a warehouse club with 12. The jeweler earns 60% gross margins on slow-moving diamonds; the warehouse club earns 11% on fast-moving groceries. Benchmark within peer group.

5. Missing LIFO versus FIFO adjustments. US retailers can choose LIFO (last-in-first-out) or FIFO (first-in-first-out) accounting. During inflation, LIFO raises reported COGS and lowers reported inventory, which mechanically raises turns. Investors comparing a LIFO company to a FIFO company should note the disclosed LIFO reserve before drawing conclusions.

Frequently Asked Questions

Q: What is inventory turnover ratio retail in simple terms? Inventory turnover ratio retail equals COGS divided by average inventory, showing how many times a retailer sells through its stock per year. Higher turns mean goods move quickly with less cash tied up and less markdown risk; lower turns indicate slow-moving inventory that may need discounting to clear.

Q: How does inventory turnover ratio retail affect investment decisions? Turns are a leading indicator of gross margin health. When a retailer's inventory grows faster than sales across two or more quarters, the typical outcome is a markdown-driven margin compression one to two quarters later. Investors who track the turns trend can anticipate gross margin guidance cuts before management delivers them.

Q: What is a real-world example of retail inventory turnover analysis? In the worked example, a specialty retailer's turns fell from 4.0 to 3.4 as inventory jumped 31 percent on flat COGS growth. Days inventory outstanding widened from 91 to 107 days. That inventory buildup typically precedes promotional activity and gross margin pressure in the following selling season.

Q: How can investors use inventory turnover ratio retail analysis? Track the year-over-year change in average inventory versus year-over-year revenue growth each quarter. A two-quarter streak of inventory growing faster than revenue is the primary warning signal. Pair with gross margin trend and any markdown commentary in the MD&A to assess severity. Also verify LIFO versus FIFO accounting when comparing across retailers.

Q: How is inventory turnover ratio different from days inventory outstanding? Inventory turnover and DIO are mathematical inverses: DIO equals 365 divided by turns. They measure the same thing in different units. Turns express how many cycles per year; DIO expresses how many days of supply the company is holding on average. Investors often prefer DIO because it is easier to visualize, 91 days of inventory is more intuitive than 4.0 turns.

Sources

1. Corporate Finance Institute. "Inventory Turnover: Formula, Calculation & Examples." https://corporatefinanceinstitute.com/resources/accounting/inventory-turnover/
2. NetSuite. "Inventory Turnover Ratio Defined: Formula, Tips, & Examples." https://www.netsuite.com/portal/resource/articles/inventory-management/inventory-turnover-ratio.shtml
3. AlphaQuery. "Walmart Inc. (WMT) Inventory Turnover (Annual)." https://www.alphaquery.com/stock/WMT/fundamentals/annual/inventory-turnover
4. AlphaQuery. "Costco Wholesale Corporation (COST) Inventory Turnover (Annual)." https://www.alphaquery.com/stock/COST/fundamentals/annual/inventory-turnover

Disclaimer

This article is educational content only and is not financial advice. Nothing here is a recommendation to buy, sell, or hold any security. Consult a licensed advisor before making investment decisions.