Skip to content
Menu
Finabase Learn

Fundamentals · Ratios

Inventory turnover: how fast stock sells, and days of inventory

How to calculate inventory turnover and days of inventory from cost of sales, why Home Depot holds stock 82 days and Costco 26, and what rising stock warns of.

On this page
  1. The idea
  2. The formula
  3. Seven companies, from groceries to machines
  4. Inventory growing faster than cost of sales
  5. Where it misleads
  6. Compared with its neighbours
  7. Where to find it in Finabase
  8. Frequently asked questions
  9. Summary
  10. Check your understanding

Inventory turnover is the number of times in a year a company sells through its stock of goods. It is the cost of what was sold divided by the average inventory on hand, and its mirror image, days of inventory, says how long a typical item waits before it is sold.

Stock is cash in another form. Every pallet in a warehouse was paid for and earns nothing until a customer takes it. Goods that sit also age: fashion goes out of season, electronics are replaced by newer models, food spoils. A company that sells its stock quickly needs less money to run, and has less to mark down when tastes change. A company whose stock is piling up is often seeing demand weaken before that shows in its revenue.

This page computes Home Depot's inventory turnover from its latest annual report, compares it with six other companies, and explains what a change in the ratio can and cannot tell you. For how inventory fits with receivables and payables, see Working capital and the cash conversion cycle, with Apple’s numbers.

The idea

A greengrocer buys $1,000 of fruit on Monday and has sold all of it by Sunday. Over a year the same $1,000 of stock is bought and sold 52 times. A jeweler holds $1,000,000 of pieces and sells goods that cost $500,000 in a year, so the stock turns half a time, and the average piece waits two years for a buyer.

The grocer's money is back in the till within a week and can buy fruit again. The jeweler's money is locked in a display case. That is why the jeweler needs a far higher markup on each sale: the profit has to pay for two years of holding the stock. Fast turnover with a small markup and slow turnover with a large one can both be sound businesses. What should worry an owner of either is turnover that slows without a reason, because unsold stock is the first place a drop in demand shows up.

The formula

Cost of sales (also called cost of goods sold or cost of revenue, see the glossary) is the line directly under revenue on the income statement. Inventory is on the balance sheet at what it cost the company, so cost belongs on top as well. Both sides of the fraction are then measured the same way.

Days of inventory is also called days inventory outstanding (DIO) or days sales of inventory. The names differ and the sum is the same.

Home Depot FY2025: inventory turned 4.5 times ($ billions) Cost of sales $109.8B Inventory, 2025-02-02 $23.5B Inventory, 2026-02-01 $25.8B Cost of sales ÷ average inventory ($24.6B) = 4.46, or 82 days on the shelf. Source: Form 10-K.
Home Depot, fiscal year ended February 1, 2026: cost of sales against inventory at the start and end of the year. Cost of sales ÷ average inventory of $24.6 billion = 4.46, or 82 days. Source: Home Depot’s Form 10-K (SEC EDGAR).

Why not sales on top

Many websites and some textbooks divide revenue by inventory instead. For Home Depot that gives 164,683 ÷ 24,634 = 6.69, half again as high as 4.46. Nothing about the stock changed. Revenue is counted at selling prices and inventory at cost, so the sales-based figure mixes the markup into a measure that is meant to count physical movement.

The distortion grows with the gross margin. Costco sells at a small markup, and its two figures are 16.19 and 14.12, about 15% apart. Nike's are 6.19 and 3.53, about 75% apart. A sales-based comparison would put Nike close to Home Depot, when its stock in fact takes three weeks longer to sell. If a source does not say which version it uses, test it against the filing.

Seven companies, from groceries to machines

Each row uses the latest Form 10-K. The fiscal years ended on August 30, 2026 for Costco (its fiscal 2026), May 31, 2026 for Nike (fiscal 2026), January 31, 2026 for Walmart (which calls it fiscal 2026) and Target (which calls it fiscal 2025), and February 1, 2026 for Home Depot (fiscal 2025). Caterpillar and Tesla report on the calendar year, here 2025. Turnover and days use average inventory.

Company Turnover Days Inventory change Cost of sales change
Costco 14.12 26 +6.7% +10.2%
Walmart 9.29 39 +4.3% +4.6%
Tesla 6.37 57 +3.1% −3.1%
Target 6.03 61 −3.4% −1.3%
Home Depot 4.46 82 +10.1% +3.4%
Nike 3.53 103 +0.2% −0.1%
Caterpillar 2.56 143 +7.8% +11.3%
Days of inventory on hand, latest fiscal year Costco FY2026 26 days Walmart FY2026 39 days Home Depot FY2025 82 days Target FY2025 61 days Nike FY2026 103 days Caterpillar FY2025 143 days Tesla FY2025 57 days 365 ÷ (cost of sales ÷ average inventory). Groceries leave in weeks; machines and tools take months.
Days of inventory on hand, latest fiscal year (fiscal 2026 for Costco, Walmart and Nike; fiscal 2025 for Home Depot and Target, years ended February 1 and January 31, 2026; calendar 2025 for Caterpillar and Tesla): 365 ÷ (cost of sales ÷ average inventory). Sources: each company’s Form 10-K (SEC EDGAR).

The spread from 26 to 143 days comes mostly from what each company sells and how it is made.

  • Costco and Walmart sell food and household goods that people buy every week. A store that carries a limited range in large volumes clears its shelves faster than one that offers many versions of each item, which fits Costco's 26 days against Walmart's 39.
  • Target sells more clothing and home goods alongside its groceries, and holds its stock for 61 days.
  • Home Depot has to keep a very wide range on hand, from lumber to appliances to single plumbing fittings, because a contractor who cannot find a part goes elsewhere. Slow-moving items are part of the offer. Its 82 days are normal for home improvement and would be alarming for a grocer.
  • Nike designs products months ahead of the season and ships them across oceans before they reach a store. Long lead times mean more stock in transit and in warehouses: 103 days.
  • Caterpillar builds heavy machines. A manufacturer's inventory includes raw materials and half-finished work as well as finished goods, and a machine takes far longer to build than a box takes to cross a loading dock.
  • Tesla is also a manufacturer, at 57 days. Its inventory is only 9.0% of its total assets, against 24.6% for Home Depot, so inventory matters less to its balance sheet.

Inventory growing faster than cost of sales

Within one company, the useful test is whether inventory and cost of sales grow together. If a company sells 5% more goods, holding about 5% more stock is unremarkable. When inventory grows much faster than cost of sales, turnover falls, and there are several possible reasons:

  • demand came in below what the company ordered for, and unsold goods are building up;
  • the company bought early on purpose, ahead of price rises, tariffs or supply problems;
  • it opened new stores or warehouses that had to be filled before they sold anything;
  • it acquired another business, whose stock is counted in full at year end while its cost of sales is counted only from the purchase date.

The first of these leads to markdowns and lower margins in the following quarters. The others do not. The ratio cannot say which applies, so read what management writes about inventory in the 10-K.

Home Depot is the row that stands out in the table: inventory up 10.1%, cost of sales up 3.4% (the year before had 53 weeks and this one 52; per week, cost of sales grew about 5.4%). On year-end balances its days of inventory rose from roughly 81 to 86. The table cannot say why. Tesla shows a milder version, with inventory up 3.1% while cost of sales fell 3.1%. Costco and Caterpillar show the opposite, with cost of sales growing faster than stock, which means each dollar of inventory supported more sales than the year before. Target cut its inventory by 3.4% in a year when cost of sales slipped 1.3%.

Where it misleads

  • The balance sheet date is chosen by the company. Retailers usually end their fiscal year just after the holiday season, when shelves are at their emptiest. Two balance sheet dates a year apart say nothing about the peak in between. Quarterly balances give a fuller picture.
  • LIFO and FIFO give different inventory figures. Under first-in, first-out (FIFO), the oldest costs go to cost of sales and the balance sheet holds recent costs. Under last-in, first-out (LIFO), the newest costs go to cost of sales and the balance sheet can hold costs from many years ago. US GAAP permits LIFO and IFRS does not. When prices have risen, a LIFO company reports lower inventory, and so higher turnover, than the same company would under FIFO. Caterpillar's filing reports a LIFO reserve of $4,305 million against inventory of $18,135 million: valued without LIFO, its inventory would be about 24% larger. The glossary entry explains both methods.
  • High turnover can mean empty shelves. A company can raise the ratio by holding too little stock and losing sales when items run out. Turnover has no upper limit that is safe to chase.
  • Write-downs raise turnover. When a company writes off unsellable stock, inventory falls and the charge usually goes through cost of sales. Both moves push the ratio up in the year the goods proved worthless.
  • Mix hides trends. A retailer that sells more groceries and fewer clothes will show rising turnover even if neither category sells any faster.
  • It does not apply to everything. Software companies, banks and most service businesses hold little or no inventory, and the ratio means nothing for them.

Compared with its neighbours

Measure Formula What it tells you
Inventory turnover Cost of sales ÷ average inventory How many times stock sells in a year
Days of inventory 365 ÷ inventory turnover How long an average item waits
Sales-based turnover Revenue ÷ average inventory Looser version, inflated by the markup
Days sales outstanding Receivables ÷ revenue × 365 How long customers take to pay
Days payable outstanding Payables ÷ cost of sales × 365 How long the company takes to pay

Home Depot's fiscal 2025 figures for the first three rows are 4.46, 82 days and 6.69. Days of inventory is one of the three parts of the cash conversion cycle, with days sales outstanding and days payable outstanding. Stock is also one of the assets inside asset turnover, which looks at the whole balance sheet at once.

Where to find it in Finabase

Finabase does not show inventory turnover or days of inventory. It shows the two rows you need.

Open Home Depot's balance sheet and read the Inventory row for the latest fiscal year and the one before. Then open the income statement and read Cost of Revenue for the latest year. Average the two inventory figures, divide cost of revenue by the average, and divide 365 by the result for days. The Financials overview has five-fiscal-year summary tables, and selecting a line there charts its full history, which is a quick way to see whether a balance has been climbing. A row appears only when the company reports it, so companies without inventory have no Inventory row.

On the Valuation tab, the Financial position card shows the balance sheet as shares of total assets, with Inventory as one of the slices. A large share tells you the ratio on this page matters for the company. For Home Depot, inventory was 24.6% of total assets at the end of fiscal 2025 (February 1, 2026).

Frequently asked questions

What is a good inventory turnover ratio?

A good ratio is one in line with, or better than, direct competitors and the company's own past, because the normal level depends on the product. In this page's table, a warehouse club turns its stock about 14 times a year and a maker of heavy machinery about 2.6 times.

Is high or low inventory turnover better?

Higher is usually better, because less cash is tied up and less stock is at risk of going stale. It stops being better when it comes from running out of products customers wanted, or from a write-down that removed stock without selling it.

How do you calculate days of inventory?

Divide 365 by inventory turnover, or divide average inventory by cost of sales and multiply by 365. Home Depot's turnover of 4.46 gives 365 ÷ 4.46, about 82 days.

Should inventory turnover use cost of goods sold or sales?

Cost of goods sold is the better choice, because inventory is recorded at cost. Using sales adds the markup to the top of the fraction and overstates how fast stock moves, by about half for Home Depot and by about three-quarters for Nike.

Why does rising inventory matter to investors?

It matters because stock that grows faster than sales often has to be cleared at lower prices later, which cuts margins. It also absorbs cash: an increase in inventory is subtracted in the operating section of the cash flow statement.

Summary

Inventory turnover divides cost of sales by average inventory, and 365 divided by the result gives the days an average item waits to be sold. Home Depot turned its stock 4.46 times in the fiscal year ended February 1, 2026, about 82 days, against 26 days at Costco and 143 at Caterpillar. Those levels reflect the goods, so the comparison that counts is with similar companies and with the same company a year earlier. Use cost of sales on top, check whether the company uses LIFO, remember that the balance sheet date may flatter the figure, and treat inventory that grows much faster than cost of sales as a question to answer from the filing, not as an answer.

Check your understanding

5 questions on this lesson. Each answer comes with the reason, and nothing is scored.

  1. A company had cost of sales of $900, inventory of $130 at the start of the year and $170 at the end. What is its inventory turnover?

    1. 6.0
    2. 5.3
    3. 6.9
    Show the answer

    A. 6.0 Average inventory is (130 + 170) ÷ 2 = 150, and 900 ÷ 150 = 6.0. Dividing by the year-end 170 gives 5.3 and by the opening 130 gives 6.9.

  2. A company’s inventory turnover is 5. About how many days does an average item wait to be sold?

    1. 5 days
    2. 50 days
    3. 73 days
    Show the answer

    C. 73 days Days of inventory is 365 ÷ turnover: 365 ÷ 5 = 73 days.

  3. Home Depot’s turnover is 4.46 on cost of sales and 6.69 on revenue. Why is the revenue version higher?

    1. Revenue covers a longer period than cost of sales
    2. Revenue includes the markup, while inventory is recorded at cost
    3. Revenue leaves out returned goods
    Show the answer

    B. Revenue includes the markup, while inventory is recorded at cost Inventory sits on the balance sheet at cost. Dividing selling prices by cost counts the gross margin as if it were stock movement, so the wider the margin, the more the sales-based version overstates turnover.

  4. A retailer’s inventory rose 12% in a year in which its cost of sales rose 2%. What is the most reasonable reading?

    1. Turnover fell; the cause could be weak demand, early buying, new stores or an acquisition, and the filing should say which
    2. The retailer is certain to report a loss next year
    3. Turnover rose, because the retailer has more to sell
    Show the answer

    A. Turnover fell; the cause could be weak demand, early buying, new stores or an acquisition, and the filing should say which Stock growing faster than the cost of goods sold lowers turnover. Unsold goods are one explanation and the one that leads to markdowns, but buying ahead, filling new stores and acquisitions produce the same numbers.

  5. Prices have risen for years. Two otherwise identical companies differ only in that one uses LIFO and the other FIFO. Which reports the higher inventory turnover?

    1. The FIFO company, because its inventory is valued at older costs
    2. They report the same turnover
    3. The LIFO company, because its balance sheet inventory is valued at older, lower costs
    Show the answer

    C. The LIFO company, because its balance sheet inventory is valued at older, lower costs Under LIFO the newest costs go to cost of sales and old costs stay on the balance sheet. With rising prices that means a smaller inventory figure and a larger cost of sales, so a higher ratio for the same physical stock.

Sources and further reading

  1. The Home Depot, Inc. — Form 10-K for the fiscal year ended February 1, 2026, filed March 18, 2026 (SEC EDGAR)
  2. Costco Wholesale Corporation — Form 10-K for the fiscal year ended August 30, 2026, filed October 7, 2026 (SEC EDGAR)
  3. Walmart Inc. — Form 10-K for the fiscal year ended January 31, 2026, filed March 13, 2026 (SEC EDGAR)
  4. Target Corporation — Form 10-K for the fiscal year ended January 31, 2026, filed March 11, 2026 (SEC EDGAR)
  5. NIKE, Inc. — Form 10-K for the fiscal year ended May 31, 2026, filed July 15, 2026 (SEC EDGAR)
  6. Caterpillar Inc. — Form 10-K for the fiscal year ended December 31, 2025, filed February 13, 2026 (SEC EDGAR)
  7. Tesla, Inc. — Form 10-K for the fiscal year ended December 31, 2025, filed January 29, 2026 (SEC EDGAR)
  8. SEC EDGAR — XBRL company facts (cost of revenue, inventory, revenue, LIFO reserve) for Home Depot, Costco, Walmart, Target, Nike, Caterpillar and Tesla, read November 18, 2026