Stock Analysis on Net

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Home Depot Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Turnover Ratios
Inventory turnover 4.08 4.25 4.23 4.43 4.22 4.53 4.30 4.38 4.51 4.85 4.49 4.43 4.08 4.20 4.07 3.96 4.01 4.55 4.76 5.06 4.87
Receivables turnover 25.15 29.42 24.57 28.08 27.68 32.53 26.74 27.64 36.99 45.87 39.09 40.37 36.97 47.45 42.15 41.67 38.76 44.12 41.81 43.47 39.00
Payables turnover 7.75 9.56 8.37 8.41 7.39 8.90 7.61 7.65 8.04 10.13 8.92 8.51 8.20 9.14 8.43 7.19 6.59 7.45 7.32 7.47 6.44
Working capital turnover 104.64 83.72 95.07 36.32 55.43 52.78 40.08 36.65 18.37 19.67 21.62 20.37 22.32 16.81 16.73 30.40 43.84 417.56 41.45 90.49 48.51
Average No. Days
Average inventory processing period 89 86 86 82 87 81 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75
Add: Average receivable collection period 15 12 15 13 13 11 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9
Operating cycle 104 98 101 95 100 92 99 96 91 83 90 91 99 95 99 101 100 88 86 80 84
Less: Average payables payment period 47 38 44 43 49 41 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57
Cash conversion cycle 57 60 57 52 51 51 51 48 46 47 49 48 54 55 56 50 45 39 36 31 27

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


An analysis of short-term operating activity indicates a general deceleration in operational efficiency over the observed period, characterized by a lengthening of the cash conversion cycle and a reduction in the velocity of asset turnover.

Inventory Management
Inventory turnover experienced an initial decline from a peak of 5.06 in August 2021 to a low of 3.96 in July 2022. While a recovery to 4.85 was noted by January 2024, the ratio subsequently stabilized between 4.08 and 4.53. This trend is mirrored in the average inventory processing period, which increased from 72-75 days in early 2021 to a range of 81-89 days in the final quarters of the period, suggesting a slower movement of goods through the supply chain.
Receivables Performance
A significant downward trend is observed in receivables turnover, which declined from a high of 47.45 in January 2023 to 25.15 by May 2026. Consequently, the average receivable collection period expanded from a consistent 8-9 days during 2021-2023 to between 12 and 15 days in the 2024-2026 period. This indicates a decrease in the efficiency of credit collection and an increase in the time required to convert receivables into cash.
Payables and Liquidity
Payables turnover showed a general upward trajectory, peaking at 10.13 in January 2024 before stabilizing between 7.39 and 9.56. The average payables payment period fluctuated, reaching a minimum of 36 days in January 2024 and ending at 47 days in May 2026. These fluctuations suggest periodic shifts in supplier payment strategies or changing terms of trade.
Operational Cycles and Working Capital
The operating cycle has lengthened steadily, moving from 80-86 days in 2021 to a peak of 104 days in May 2026. This expansion is primarily driven by the cumulative effects of slower inventory turnover and delayed receivable collections. The cash conversion cycle reflects this deterioration, rising from 27 days in May 2021 to 57-60 days in the latter part of the analysis period, indicating that capital is tied up in operating activities for a significantly longer duration.
Working Capital Turnover
Working capital turnover exhibited extreme volatility, with an anomalous peak of 417.56 in January 2022. Following this, the ratio experienced a prolonged period of contraction, dipping to 16.73 in October 2022. A subsequent recovery is evident, with the ratio rising to 104.64 by May 2026, reflecting substantial changes in the relationship between net working capital and net sales.

AI Ask an analyst for more


Turnover Ratios


Average No. Days



Inventory Turnover

Home Depot Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data (US$ in millions)
Cost of sales 27,984 25,732 27,537 30,152 26,397 26,670 26,792 28,759 23,985 23,278 24,972 28,759 24,700 23,905 25,648 29,309 25,763 23,857 24,257 27,453 24,758
Merchandise inventories 27,280 25,817 26,203 24,843 25,763 23,451 23,897 23,060 22,416 20,976 22,805 23,265 25,371 24,886 25,719 26,088 25,297 22,068 20,582 18,909 19,178
Short-term Activity Ratio
Inventory turnover1 4.08 4.25 4.23 4.43 4.22 4.53 4.30 4.38 4.51 4.85 4.49 4.43 4.08 4.20 4.07 3.96 4.01 4.55 4.76 5.06 4.87
Benchmarks
Inventory Turnover, Competitors2
Amazon.com Inc. 10.04 9.30 8.32 8.27 9.22 9.54 8.86 9.21 9.94 9.15 8.41 8.01 8.49 8.40 7.80 7.30 7.90
Lowe’s Cos. Inc. 3.20 3.32 3.26 3.40 3.03 3.21 3.18 3.33 3.13 3.41 3.43 3.57 3.28 3.50 3.23 3.29 3.14 3.65 3.82 3.66 3.44
TJX Cos. Inc. 5.51 5.71 4.36 5.46 5.56 6.09 4.69 5.99 6.16 6.36 4.48 5.56 5.64 6.21 4.26 5.04 5.10 5.82 4.90 6.04 5.35

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Inventory turnover = (Cost of salesQ1 2027 + Cost of salesQ4 2026 + Cost of salesQ3 2026 + Cost of salesQ2 2026) ÷ Merchandise inventories
= (27,984 + 25,732 + 27,537 + 30,152) ÷ 27,280 = 4.08

2 Click competitor name to see calculations.


The analysis of inventory turnover reveals a fluctuating efficiency cycle characterized by an initial period of high velocity, followed by a period of decline and subsequent stabilization.

Inventory Turnover Trends
The turnover ratio peaked early in the observed period, reaching 5.06 in August 2021. A downward trend followed, with the ratio hitting a trough of 3.96 by July 2022. This indicates a period where inventory was moving more slowly relative to the cost of goods sold. A recovery phase occurred throughout late 2023 and early 2024, peaking at 4.85 in January 2024, before the ratio stabilized into a volatile range between 4.08 and 4.53 through May 2026.
Inventory Level Dynamics
A significant expansion in merchandise inventories is observed between May 2021 and May 2022, where levels rose from 19,178 million USD to 25,297 million USD. This increase in stock holdings correlates directly with the decline in the turnover ratio during the same window, suggesting that inventory accumulation outpaced the growth in sales volume. For the remainder of the period, inventory levels remained elevated, fluctuating between a low of 20,976 million USD in January 2024 and a high of 27,280 million USD in May 2026.
Correlation with Cost of Sales
Cost of sales exhibits consistent seasonal volatility, with recurring peaks typically occurring in the third quarter of each year, often exceeding 28,000 million USD. While these surges in sales activity generally drive higher turnover, the simultaneous maintenance of higher average inventory levels has prevented the turnover ratio from returning to the 5.00 level seen in 2021. The relationship suggests a strategic shift toward higher inventory buffers, which has moderated the overall efficiency of the inventory cycle.

AI Ask an analyst for more


Receivables Turnover

Home Depot Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data (US$ in millions)
Net sales 41,765 38,198 41,352 45,277 39,856 39,704 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500
Receivables, net 6,624 5,597 6,765 5,878 5,886 4,903 5,782 5,503 4,105 3,328 3,932 3,836 4,213 3,317 3,732 3,725 3,936 3,426 3,533 3,322 3,624
Short-term Activity Ratio
Receivables turnover1 25.15 29.42 24.57 28.08 27.68 32.53 26.74 27.64 36.99 45.87 39.09 40.37 36.97 47.45 42.15 41.67 38.76 44.12 41.81 43.47 39.00
Benchmarks
Receivables Turnover, Competitors2
Lowe’s Cos. Inc. 76.83 79.16 69.29
TJX Cos. Inc. 95.93 100.29 90.60 96.54 95.95 102.66 94.19 106.76 101.32 102.49 93.44 93.48 85.71 88.70 86.31 89.32 86.53 93.79 74.20 70.21 60.88

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Receivables turnover = (Net salesQ1 2027 + Net salesQ4 2026 + Net salesQ3 2026 + Net salesQ2 2026) ÷ Receivables, net
= (41,765 + 38,198 + 41,352 + 45,277) ÷ 6,624 = 25.15

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a distinct shift in collection efficiency over the observed period, transitioning from a phase of high turnover to a period of marked deceleration.

Net Sales Patterns
Revenue exhibits consistent seasonal volatility, with recurring peaks typically occurring in the mid-year quarters. Despite these periodic fluctuations, sales volumes remained robust, reaching a peak of 45,277 million US dollars in August 2025.
Receivables Balance Evolution
Net receivables remained relatively stable from May 2021 through January 2024, generally fluctuating between 3,317 million and 4,213 million US dollars. A significant upward trend is observed starting in April 2024, with the balance escalating to a peak of 6,765 million US dollars by November 2025, indicating a substantial expansion of the outstanding receivables balance.
Receivables Turnover Performance
A high level of collection efficiency was maintained between May 2021 and January 2024, with the turnover ratio frequently exceeding 40.0 and peaking at 47.45 in January 2023. A notable decline occurred beginning in April 2024, as the ratio dropped into the 24.0 to 32.0 range. This downward trend reflects a slower conversion of receivables into cash, directly correlating with the increase in the net receivables balance.

The divergence between sustained net sales and rapidly increasing receivables suggests a change in credit terms or a slowdown in collection velocity. The resulting decline in the turnover ratio indicates that the company is taking longer to collect its outstanding debts compared to the efficiency levels observed in the 2021-2023 period.

AI Ask an analyst for more



Payables Turnover

Home Depot Inc., payables turnover calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data (US$ in millions)
Cost of sales 27,984 25,732 27,537 30,152 26,397 26,670 26,792 28,759 23,985 23,278 24,972 28,759 24,700 23,905 25,648 29,309 25,763 23,857 24,257 27,453 24,758
Accounts payable 14,373 11,491 13,237 13,086 14,696 11,938 13,506 13,206 12,563 10,037 11,478 12,104 12,630 11,443 12,402 14,348 15,367 13,462 13,375 12,817 14,494
Short-term Activity Ratio
Payables turnover1 7.75 9.56 8.37 8.41 7.39 8.90 7.61 7.65 8.04 10.13 8.92 8.51 8.20 9.14 8.43 7.19 6.59 7.45 7.32 7.47 6.44
Benchmarks
Payables Turnover, Competitors2
Amazon.com Inc. 2.94 2.92 3.26 3.44 3.70 3.46 3.78 3.84 4.24 3.59 4.14 4.22 4.34 3.63 4.22 3.91 4.03
Lowe’s Cos. Inc. 4.93 5.88 5.47 5.85 4.94 6.01 5.27 5.43 4.86 6.61 6.07 6.02 5.39 6.16 5.22 5.03 4.59 5.65 5.62 5.28 4.52
TJX Cos. Inc. 8.71 9.11 6.87 8.56 8.98 9.19 6.99 8.61 9.41 9.83 6.85 8.26 8.43 9.53 7.11 8.74 8.16 7.77 5.97 6.96 6.17

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Payables turnover = (Cost of salesQ1 2027 + Cost of salesQ4 2026 + Cost of salesQ3 2026 + Cost of salesQ2 2026) ÷ Accounts payable
= (27,984 + 25,732 + 27,537 + 30,152) ÷ 14,373 = 7.75

2 Click competitor name to see calculations.


The analysis of payables turnover reveals a period of significant escalation in the efficiency of supplier payments, followed by a phase of increased volatility and stabilization. The ratio transitioned from a relatively stable range in 2021 to a peak in early 2024, suggesting a shift in working capital management and supplier credit terms.

Long-term Turnover Trends
Between May 2021 and May 2022, the payables turnover ratio remained largely consistent, fluctuating between 6.44 and 7.47. However, starting in October 2022, a consistent upward trend emerged, with the ratio climbing from 8.43 to a peak of 10.13 by January 28, 2024. This increase indicates a faster conversion of accounts payable or a reduction in the average time taken to settle obligations with suppliers.
Peak and Correction Phase
The maximum turnover ratio of 10.13 observed in January 2024 represents the point of highest payment velocity in the analyzed period. Following this peak, a sharp correction occurred in April 2024, where the ratio dropped to 8.04. This suggests a strategic adjustment in payment timing or a significant increase in the volume of outstanding payables relative to the cost of sales.
Recent Volatility and Stabilization
From April 2024 through May 2026, the ratio exhibited cyclical fluctuations, ranging from a low of 7.39 in May 2025 to a high of 9.56 in February 2026. This volatility correlates with fluctuations in the cost of sales, which peaked at 30,152 million USD in August 2025, and corresponding adjustments in accounts payable balances.
Relationship Between Cost of Sales and Payables
The data indicates that the payables turnover is sensitive to the seasonal nature of the cost of sales. Periods of higher expenditure on goods often align with shifts in the turnover ratio, though the acceleration observed between 2022 and 2024 suggests structural changes in supplier relations or credit policies rather than purely seasonal effects.

AI Ask an analyst for more


Working Capital Turnover

Home Depot Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data (US$ in millions)
Current assets 37,172 34,391 36,115 35,391 34,529 31,683 32,949 32,273 32,622 29,775 30,682 31,830 32,423 32,471 33,681 32,941 33,867 29,055 30,466 28,262 30,672
Less: Current liabilities 35,580 32,424 34,367 30,846 31,589 28,661 29,092 28,123 24,359 22,015 23,572 24,227 25,446 23,110 24,280 27,834 30,387 28,693 26,903 26,666 27,758
Working capital 1,592 1,967 1,748 4,545 2,940 3,022 3,857 4,150 8,263 7,760 7,110 7,603 6,977 9,361 9,401 5,107 3,480 362 3,563 1,596 2,914
 
Net sales 41,765 38,198 41,352 45,277 39,856 39,704 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500
Short-term Activity Ratio
Working capital turnover1 104.64 83.72 95.07 36.32 55.43 52.78 40.08 36.65 18.37 19.67 21.62 20.37 22.32 16.81 16.73 30.40 43.84 417.56 41.45 90.49 48.51
Benchmarks
Working Capital Turnover, Competitors2
Amazon.com Inc. 19.34 64.72 413.97 148.93 76.74 55.79 43.32 39.93 53.59 77.32
Lowe’s Cos. Inc. 46.84 57.83 109.57 82.22 290.03 52.26 33.09 20.54 26.32 24.66 25.98 20.16 20.34 50.26 23.32 41.46 25.26 245.54 23.72 27.67 24.04
TJX Cos. Inc. 34.50 32.79 44.92 29.40 32.24 28.42 24.16 24.51 23.78 24.50 24.16 25.35 24.41 23.22 28.07 29.41 20.26 17.40 14.05 12.91 7.40

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Working capital turnover = (Net salesQ1 2027 + Net salesQ4 2026 + Net salesQ3 2026 + Net salesQ2 2026) ÷ Working capital
= (41,765 + 38,198 + 41,352 + 45,277) ÷ 1,592 = 104.64

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a period of significant volatility in working capital management, which has directly dictated the fluctuations in the working capital turnover ratio. While net sales have remained relatively stable, fluctuating between approximately 34.7 billion and 45.3 billion US dollars, the working capital levels have experienced drastic swings, leading to inconsistent capital efficiency metrics over the observed period.

Working Capital Volatility and Ratio Anomalies
A critical anomaly is observed on January 30, 2022, where the working capital turnover ratio peaked at 417.56. This extreme value was not driven by a surge in sales, but rather by a sharp contraction in working capital to 362 million US dollars. Such a spike indicates a period of minimal liquidity cushion or a significant alignment of current assets and liabilities, resulting in an atypically high turnover rate.
Efficiency Compression Period (2022-2023)
Between July 2022 and January 2024, a marked decline in efficiency is evident. Working capital increased substantially, reaching a peak of 9.4 billion US dollars in October 2022. Consequently, the working capital turnover ratio dropped to its lowest levels, ranging between 16.73 and 22.32. This trend suggests a period where the company maintained higher levels of current assets relative to its sales volume, potentially indicating strategic inventory buildup or a decrease in the efficiency of short-term asset utilization.
Operational Recovery and Optimization (2024-2026)
Starting in July 2024, a consistent upward trend in the turnover ratio is observable, moving from 36.65 to a high of 104.64 by May 3, 2026. This improvement is attributed to a systematic reduction in working capital—dropping from 8.26 billion US dollars in January 2024 to 1.59 billion US dollars by May 2026—while net sales remained robust. This pattern indicates a shift toward leaner working capital management and a significant increase in the efficiency with which short-term assets are being used to generate revenue.

Overall, the data demonstrates a transition from a period of high liquidity and lower turnover efficiency (2022-2023) toward a leaner operational model characterized by higher turnover ratios and reduced working capital requirements in the final quarters of the analysis.

AI Ask an analyst for more



Average Inventory Processing Period

Home Depot Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data
Inventory turnover 4.08 4.25 4.23 4.43 4.22 4.53 4.30 4.38 4.51 4.85 4.49 4.43 4.08 4.20 4.07 3.96 4.01 4.55 4.76 5.06 4.87
Short-term Activity Ratio (no. days)
Average inventory processing period1 89 86 86 82 87 81 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Amazon.com Inc. 36 39 44 44 40 38 41 40 37 40 43 46 43 43 47 50 46
Lowe’s Cos. Inc. 114 110 112 107 121 114 115 110 117 107 106 102 111 104 113 111 116 100 96 100 106
TJX Cos. Inc. 66 64 84 67 66 60 78 61 59 57 81 66 65 59 86 72 72 63 74 60 68

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 4.08 = 89

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a cyclical pattern in inventory management, characterized by a consistent inverse correlation between the inventory turnover ratio and the average inventory processing period. Over the observed timeframe, inventory efficiency experienced distinct phases of contraction and optimization, with the processing period fluctuating between a minimum of 72 days and a maximum of 92 days.

Operational Efficiency Decline
A notable deceleration in inventory movement occurred between May 1, 2022, and October 30, 2022. During this period, the average inventory processing period peaked at 92 days, while the inventory turnover ratio fell to its lowest point of 3.96. This trend indicates a period of increased stock retention and a slowdown in the conversion of inventory into revenue.
Recovery and Peak Performance
A significant improvement in operational velocity was observed between July 30, 2023, and January 28, 2024. The average inventory processing period declined from 82 days to 75 days, coinciding with an increase in the inventory turnover ratio to 4.85. This interval represents the highest level of inventory efficiency since the initial 2021 readings, suggesting optimized supply chain management or a surge in sales demand.
Recent Trend Analysis
From April 28, 2024, through May 3, 2026, a gradual upward trend in the inventory processing period is evident, rising from 81 days to 89 days. Simultaneously, the inventory turnover ratio experienced a downward trajectory, moving from 4.51 to 4.08. The most recent data points indicate a continuing trend toward slower inventory processing, suggesting a possible buildup of stock or a decrease in sales velocity toward the end of the observed period.

AI Ask an analyst for more


Average Receivable Collection Period

Home Depot Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data
Receivables turnover 25.15 29.42 24.57 28.08 27.68 32.53 26.74 27.64 36.99 45.87 39.09 40.37 36.97 47.45 42.15 41.67 38.76 44.12 41.81 43.47 39.00
Short-term Activity Ratio (no. days)
Average receivable collection period1 15 12 15 13 13 11 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Lowe’s Cos. Inc. 5 5 5
TJX Cos. Inc. 4 4 4 4 4 4 4 3 4 4 4 4 4 4 4 4 4 4 5 5 6

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 25.15 = 15

2 Click competitor name to see calculations.


An analysis of the company's short-term operating activity indicates a perceptible shift in the efficiency of receivable collections over the period from May 2021 through May 2026.

Receivables Turnover Trends
From May 2021 to January 2023, the receivables turnover ratio remained relatively high and stable, reaching a peak of 47.45 in January 2023. A gradual decline began in April 2023, accelerating into 2024, where the ratio dropped significantly to 26.74 by October 2024. Although there was a slight recovery in early 2025, the turnover ratio remained consistently lower than the 2021-2022 baseline, ending the period at 25.15 in May 2026.
Average Receivable Collection Period
The collection period demonstrated high stability between May 2021 and January 2024, consistently oscillating between 8 and 10 days. A distinct upward trend emerged in April 2024, with the collection period increasing to 13 days. This upward trajectory continued through 2025 and 2026, hitting a maximum of 15 days in November 2025 and May 2026, signaling a slowdown in the conversion of receivables to cash.
Comparative Analysis and Insights
The data reveals a strong inverse correlation between the turnover ratio and the collection period. The transition from a collection cycle of approximately 9 days to a cycle of 12 to 15 days reflects a decline in credit collection efficiency. This trend suggests that receivables are remaining outstanding for longer durations, which extends the overall operating cycle of the business.

AI Ask an analyst for more


Operating Cycle

Home Depot Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data
Average inventory processing period 89 86 86 82 87 81 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75
Average receivable collection period 15 12 15 13 13 11 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9
Short-term Activity Ratio
Operating cycle1 104 98 101 95 100 92 99 96 91 83 90 91 99 95 99 101 100 88 86 80 84
Benchmarks
Operating Cycle, Competitors2
Lowe’s Cos. Inc. 119 115 117
TJX Cos. Inc. 70 68 88 71 70 64 82 64 63 61 85 70 69 63 90 76 76 67 79 65 74

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 89 + 15 = 104

2 Click competitor name to see calculations.


The operating cycle has exhibited a general expansion from May 2021 through May 2026, increasing from 84 days to 104 days. This trend indicates a lengthening of the duration between the initial outlay for inventory and the final receipt of cash from sales.

Average Inventory Processing Period
A gradual upward trend is observed, beginning at 75 days in May 2021 and reaching a peak of 92 days by July 2022. Although the period experienced a moderate decline to 75 days by January 2024, it subsequently rose again, concluding at 89 days in May 2026. This suggests an overall decrease in inventory turnover efficiency compared to the baseline period.
Average Receivable Collection Period
The collection period remained highly stable, fluctuating narrowly between 8 and 10 days from May 2021 through April 2023. A shift in this metric is observable starting in July 2024, as the period expanded to range between 12 and 15 days. This indicates a modest slowdown in the conversion of receivables into cash during the latter portion of the analyzed timeframe.
Operating Cycle Dynamics
The total operating cycle is primarily driven by the inventory processing period, which represents the dominant component of the cycle. The overall increase of 20 days in the operating cycle is the result of a combined effect: the sustained increase in inventory holding times and the recent expansion of the receivable collection period. The most significant period of expansion occurred between early 2024 and mid-2026.

AI Ask an analyst for more


Average Payables Payment Period

Home Depot Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data
Payables turnover 7.75 9.56 8.37 8.41 7.39 8.90 7.61 7.65 8.04 10.13 8.92 8.51 8.20 9.14 8.43 7.19 6.59 7.45 7.32 7.47 6.44
Short-term Activity Ratio (no. days)
Average payables payment period1 47 38 44 43 49 41 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Amazon.com Inc. 124 125 112 106 99 106 96 95 86 102 88 87 84 101 86 93 91
Lowe’s Cos. Inc. 74 62 67 62 74 61 69 67 75 55 60 61 68 59 70 72 79 65 65 69 81
TJX Cos. Inc. 42 40 53 43 41 40 52 42 39 37 53 44 43 38 51 42 45 47 61 52 59

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.75 = 47

2 Click competitor name to see calculations.


An analysis of short-term operating activity reveals a notable shift in the management of accounts payable between May 2021 and May 2026. The primary trend is a significant contraction of the average payables payment period, which reached a cyclical low in early 2024 before stabilizing within a narrower range throughout 2025 and 2026.

Payables Turnover Trends
The turnover ratio exhibits a clear inverse correlation with the payment period. Beginning at 6.44 in May 2021, the ratio trended generally upward, peaking at 10.13 in January 2024. This escalation indicates an acceleration in the frequency with which supplier obligations were settled. In the subsequent period from April 2024 to May 2026, the ratio fluctuated between 7.39 and 9.56, suggesting a move away from the peak acceleration toward a more moderate settlement cadence.
Average Payables Payment Period Analysis
The average payment period started at 57 days in May 2021 and underwent a steady decline, reaching a minimum of 36 days by January 2024. This compression suggests a reduction in the time elapsed before vendors are paid, which may be attributed to tighter credit terms imposed by suppliers or a strategic internal shift to accelerate payments. From April 2024 through May 2026, the period stabilized, oscillating between 38 and 49 days, indicating the establishment of a new operational equilibrium that remains lower than the 2021 levels.
Operational Insights and Working Capital Impact
The synchronization between the rise in turnover and the fall in payment days confirms a systematic acceleration of the cash-to-supplier cycle during the 2022-2024 window. The transition from a 57-day cycle to a stabilized range of approximately 38 to 49 days implies a more aggressive use of cash to satisfy short-term liabilities. The recent volatility observed in 2025 and 2026, specifically the dip to 38 days in February 2026 followed by a rise to 47 days in May 2026, suggests ongoing adjustments in working capital management.

AI Ask an analyst for more


Cash Conversion Cycle

Home Depot Inc., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021
Selected Financial Data
Average inventory processing period 89 86 86 82 87 81 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75
Average receivable collection period 15 12 15 13 13 11 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9
Average payables payment period 47 38 44 43 49 41 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57
Short-term Activity Ratio
Cash conversion cycle1 57 60 57 52 51 51 51 48 46 47 49 48 54 55 56 50 45 39 36 31 27
Benchmarks
Cash Conversion Cycle, Competitors2
Lowe’s Cos. Inc. 45 53 50
TJX Cos. Inc. 28 28 35 28 29 24 30 22 24 24 32 26 26 25 39 34 31 20 18 13 15

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).

1 Q1 2027 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 89 + 1547 = 57

2 Click competitor name to see calculations.


The Cash Conversion Cycle (CCC) exhibits a general upward trajectory over the analyzed period, indicating a lengthening of the time required to convert resource inputs into cash flows. The CCC began at 27 days in May 2021 and reached a peak of 60 days by February 2026, ending the period at 57 days. This trend suggests a decrease in operational liquidity efficiency over the long term.

Average Inventory Processing Period
Inventory management shows significant volatility with an overall increasing trend. The processing period rose from 75 days in May 2021 to a peak of 92 days in July 2022. While a temporary improvement occurred in early 2024, returning to 75 days, the period climbed again to 89 days by May 2026. This indicates a general slowing in the turnover of stock.
Average Receivable Collection Period
The collection period remained highly stable, fluctuating between 8 and 10 days for the first several years of the analysis. However, a gradual increase is observed starting in April 2024, with the period rising to a maximum of 15 days by May 2026. While the absolute change is minimal, it represents a marginal shift toward slower cash recovery from credit sales.
Average Payables Payment Period
A general contraction in the payables payment period is evident. The period started at 57 days in May 2021 and reached a low of 36 days in January 2024. Although the period fluctuated between 38 and 49 days in the subsequent years, it remained consistently lower than the initial levels. This trend indicates that obligations to suppliers are being settled more rapidly.
Cash Conversion Cycle Synthesis
The expansion of the CCC is the result of a compounding effect across all three operational components. The increase in the inventory processing period and the slight rise in receivable collections have been further exacerbated by the reduction in the payables payment period. By paying suppliers faster while taking longer to move inventory and collect receivables, the company has increased its net working capital requirement.

AI Ask an analyst for more