Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

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
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Turnover Ratios
Inventory turnover 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 5.25 5.13 5.83 4.93 5.00 4.65 4.91 4.65 5.10
Receivables turnover 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 44.15 47.12 46.57 42.95 52.34 49.72 48.38 47.32 55.89
Payables turnover 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 7.52 6.42 6.73 7.35 9.33 7.91 7.62 6.99 9.16
Working capital turnover 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 24.87 13.79 16.66 28.53 76.81 68.95 57.87 124.59 59.68
Average No. Days
Average inventory processing period 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Add: Average receivable collection period 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9 8 8 8 8 7 7 8 8 7
Operating cycle 99 96 91 83 90 91 99 95 99 101 100 88 86 80 84 78 79 71 82 80 85 82 86 79
Less: Average payables payment period 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52 40
Cash conversion cycle 51 48 46 47 49 48 54 55 56 50 45 39 36 31 27 29 22 17 32 41 39 34 34 39

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Home Depot Inc. inventory turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Receivables turnover An activity ratio equal to revenue divided by receivables. Home Depot Inc. receivables turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Home Depot Inc. payables turnover ratio decreased from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Home Depot Inc. working capital turnover ratio improved from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Home Depot Inc. number of days of inventory outstanding deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Home Depot Inc. number of days of receivables outstanding deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Home Depot Inc. operating cycle deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Home Depot Inc. cash conversion cycle deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Inventory Turnover

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Cost of sales 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 21,430 22,080 25,112 18,635 17,046 17,836 20,407 17,364 17,464 17,151 20,098 16,330
Merchandise inventories 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 16,627 16,155 13,498 14,989 14,531 15,711 14,741 15,495 13,925 14,754 14,044 14,432
Short-term Activity Ratio
Inventory turnover1 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 5.25 5.13 5.83 4.93 5.00 4.65 4.91 4.65 5.10
Benchmarks
Inventory Turnover, Competitors2
Amazon.com Inc. 8.86 9.21 9.94 9.15 8.41 8.01 8.49 8.40 7.80 7.30 7.90 8.34 8.69 10.90 10.54 9.80 8.76 9.81 9.33 8.08
Lowe’s Cos. Inc. 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 3.71 3.64 3.90 3.52 3.73 3.57 3.58 3.26 3.85
TJX Cos. Inc. 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 5.66 5.08 6.88 5.59 6.13 4.64 5.64 5.59 6.08

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Inventory turnover = (Cost of salesQ3 2025 + Cost of salesQ2 2025 + Cost of salesQ1 2025 + Cost of salesQ4 2024) ÷ Merchandise inventories
= (26,792 + 28,759 + 23,985 + 23,278) ÷ 23,897 = 4.30

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Home Depot Inc. inventory turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Receivables Turnover

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net sales 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 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
Receivables, net 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 2,992 2,666 2,562 2,610 2,106 2,231 2,274 2,317 1,936 2,171 2,164 2,296
Short-term Activity Ratio
Receivables turnover1 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 44.15 47.12 46.57 42.95 52.34 49.72 48.38 47.32 55.89
Benchmarks
Receivables Turnover, Competitors2
TJX Cos. Inc. 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 69.69 72.02 75.94 213.66 108.00 91.76 106.12 100.60 112.54

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Receivables turnover = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Receivables, net
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 5,782 = 26.74

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Home Depot Inc. receivables turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Payables Turnover

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Cost of sales 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 21,430 22,080 25,112 18,635 17,046 17,836 20,407 17,364 17,464 17,151 20,098 16,330
Accounts payable 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 11,606 12,899 11,691 10,056 7,787 9,240 9,494 10,311 7,755 9,054 9,407 9,726
Short-term Activity Ratio
Payables turnover1 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 7.52 6.42 6.73 7.35 9.33 7.91 7.62 6.99 9.16
Benchmarks
Payables Turnover, Competitors2
Amazon.com Inc. 3.78 3.84 4.24 3.59 4.14 4.22 4.34 3.63 4.22 3.91 4.03 3.46 3.76 3.98 3.93 3.22 3.57 3.77 4.39 3.51
Lowe’s Cos. Inc. 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 5.51 4.48 4.18 4.63 6.42 5.54 5.18 4.26 5.85
TJX Cos. Inc. 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 5.09 4.13 10.64 25.79 11.17 8.45 11.00 10.97 10.53

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Payables turnover = (Cost of salesQ3 2025 + Cost of salesQ2 2025 + Cost of salesQ1 2025 + Cost of salesQ4 2024) ÷ Accounts payable
= (26,792 + 28,759 + 23,985 + 23,278) ÷ 13,506 = 7.61

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Home Depot Inc. payables turnover ratio decreased from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Working Capital Turnover

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Current assets 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 28,477 34,505 31,361 27,277 19,810 21,174 20,699 20,553 18,529 19,809 20,802 21,214
Less: Current liabilities 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 23,166 25,395 24,199 23,348 18,375 19,565 18,798 19,673 16,716 18,196 18,426 18,133
Working capital 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 5,311 9,110 7,162 3,929 1,435 1,609 1,901 880 1,813 1,613 2,376 3,081
 
Net sales 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 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
Short-term Activity Ratio
Working capital turnover1 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 24.87 13.79 16.66 28.53 76.81 68.95 57.87 124.59 59.68
Benchmarks
Working Capital Turnover, Competitors2
Amazon.com Inc. 43.32 39.93 53.59 77.32 24.33 31.50 19.23 69.81 60.82 31.47 18.92 47.22 32.92
Lowe’s Cos. Inc. 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 24.92 11.60 12.67 20.57 530.50 119.81 74.71 46.13
TJX Cos. Inc. 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 6.51 6.91 8.72 6.55 23.97 24.08 23.99 26.62 13.27

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Working capital turnover = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Working capital
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 3,857 = 40.08

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Home Depot Inc. working capital turnover ratio improved from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Average Inventory Processing Period

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data
Inventory turnover 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 5.25 5.13 5.83 4.93 5.00 4.65 4.91 4.65 5.10
Short-term Activity Ratio (no. days)
Average inventory processing period1 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Amazon.com Inc. 41 40 37 40 43 46 43 43 47 50 46 44 42 33 35 37 42 37 39 45
Lowe’s Cos. Inc. 110 117 107 106 102 111 104 113 111 116 100 96 100 106 98 100 94 104 98 102 102 112 95
TJX Cos. Inc. 61 59 57 81 66 65 59 86 72 72 63 74 60 68 65 72 53 65 60 79 65 65 60

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 4.30 = 85

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Home Depot Inc. number of days of inventory outstanding deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Average Receivable Collection Period

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data
Receivables turnover 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 44.15 47.12 46.57 42.95 52.34 49.72 48.38 47.32 55.89
Short-term Activity Ratio (no. days)
Average receivable collection period1 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9 8 8 8 8 7 7 8 8 7
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
TJX Cos. Inc. 3 4 4 4 4 4 4 4 4 4 4 5 5 6 5 5 5 2 3 4 3 4 3

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 26.74 = 14

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Home Depot Inc. number of days of receivables outstanding deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Operating Cycle

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

No. days

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data
Average inventory processing period 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Average receivable collection period 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9 8 8 8 8 7 7 8 8 7
Short-term Activity Ratio
Operating cycle1 99 96 91 83 90 91 99 95 99 101 100 88 86 80 84 78 79 71 82 80 85 82 86 79
Benchmarks
Operating Cycle, Competitors2
TJX Cos. Inc. 64 63 61 85 70 69 63 90 76 76 67 79 65 74 70 77 58 67 63 83 68 69 63

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 85 + 14 = 99

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Home Depot Inc. operating cycle deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Average Payables Payment Period

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

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data
Payables turnover 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 7.52 6.42 6.73 7.35 9.33 7.91 7.62 6.99 9.16
Short-term Activity Ratio (no. days)
Average payables payment period1 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52 40
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Amazon.com Inc. 96 95 86 102 88 87 84 101 86 93 91 105 97 92 93 113 102 97 83 104
Lowe’s Cos. Inc. 67 75 55 60 61 68 59 70 72 79 65 65 69 81 66 81 87 79 57 66 70 86 62
TJX Cos. Inc. 42 39 37 53 44 43 38 51 42 45 47 61 52 59 72 88 34 14 33 43 33 33 35

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.61 = 48

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.

Cash Conversion Cycle

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

No. days

Microsoft Excel
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 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data
Average inventory processing period 85 83 81 75 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Average receivable collection period 14 13 10 8 9 9 10 8 9 9 9 8 9 8 9 8 8 8 8 7 7 8 8 7
Average payables payment period 48 48 45 36 41 43 45 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52 40
Short-term Activity Ratio
Cash conversion cycle1 51 48 46 47 49 48 54 55 56 50 45 39 36 31 27 29 22 17 32 41 39 34 34 39
Benchmarks
Cash Conversion Cycle, Competitors2
TJX Cos. Inc. 22 24 24 32 26 26 25 39 34 31 20 18 13 15 -2 -11 24 53 30 40 35 36 28

Based on: 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), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 85 + 1448 = 51

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Home Depot Inc. cash conversion cycle deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.