Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Home Depot Inc., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 1.35 1.30 1.31 1.27 1.41 1.39 1.18 1.11 1.01 1.13 1.06 1.10 1.23 1.36 1.30 1.17 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17
Quick ratio 0.32 0.25 0.27 0.22 0.26 0.26 0.18 0.22 0.20 0.32 0.30 0.37 0.47 0.68 0.69 0.48 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33
Cash ratio 0.17 0.09 0.12 0.05 0.12 0.10 0.05 0.09 0.08 0.19 0.17 0.24 0.34 0.58 0.58 0.37 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20

Based on: 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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Home Depot Inc. current ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Home Depot Inc. quick ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Home Depot Inc. cash ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Current Ratio

Home Depot Inc., current ratio calculation (quarterly data)

Microsoft Excel
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 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
Current liabilities 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
Liquidity Ratio
Current ratio1 1.35 1.30 1.31 1.27 1.41 1.39 1.18 1.11 1.01 1.13 1.06 1.10 1.23 1.36 1.30 1.17 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.05 0.98 0.95 0.92 0.94 0.94 0.95 0.96 1.14 1.12 1.20 1.05 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09
Lowe’s Cos. Inc. 1.21 1.26 1.25 1.10 1.20 1.11 1.17 1.02 1.19 1.16 1.17 1.19 1.38 1.30 1.20 1.01 1.04 1.06 1.09 0.98 1.00 1.06 1.02
TJX Cos. Inc. 1.19 1.20 1.20 1.21 1.16 1.17 1.25 1.27 1.29 1.33 1.52 1.46 1.41 1.51 2.20 1.24 1.22 1.25 1.23 1.53 1.55 1.64 1.69

Based on: 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 Q4 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 29,775 ÷ 22,015 = 1.35

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Home Depot Inc. current ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Quick Ratio

Home Depot Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 3,760 2,058 2,814 1,260 2,757 2,462 1,259 2,844 2,343 5,067 4,566 6,648 7,895 14,652 14,139 8,696 2,133 2,193 2,547 1,882 1,778 1,764 3,490 3,599
Receivables, net 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
Total quick assets 7,088 5,990 6,650 5,473 6,074 6,194 4,984 6,780 5,769 8,600 7,888 10,272 10,887 17,318 16,701 11,306 4,239 4,424 4,821 4,199 3,714 3,935 5,654 5,895
 
Current liabilities 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
Liquidity Ratio
Quick ratio1 0.32 0.25 0.27 0.22 0.26 0.26 0.18 0.22 0.20 0.32 0.30 0.37 0.47 0.68 0.69 0.48 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.53 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Lowe’s Cos. Inc. 0.09 0.22 0.18 0.09 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.42 0.49 0.53 0.59 0.35 0.40 0.49 0.64 0.65 0.77 0.95 1.01 0.93 0.92 0.96 0.50 0.33 0.39 0.40 0.61 0.52 0.63 0.70

Based on: 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 Q4 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 7,088 ÷ 22,015 = 0.32

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Home Depot Inc. quick ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Cash Ratio

Home Depot Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 3,760 2,058 2,814 1,260 2,757 2,462 1,259 2,844 2,343 5,067 4,566 6,648 7,895 14,652 14,139 8,696 2,133 2,193 2,547 1,882 1,778 1,764 3,490 3,599
Total cash assets 3,760 2,058 2,814 1,260 2,757 2,462 1,259 2,844 2,343 5,067 4,566 6,648 7,895 14,652 14,139 8,696 2,133 2,193 2,547 1,882 1,778 1,764 3,490 3,599
 
Current liabilities 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
Liquidity Ratio
Cash ratio1 0.17 0.09 0.12 0.05 0.12 0.10 0.05 0.09 0.08 0.19 0.17 0.24 0.34 0.58 0.58 0.37 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.53 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Lowe’s Cos. Inc. 0.09 0.22 0.18 0.09 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.37 0.44 0.48 0.53 0.30 0.35 0.43 0.59 0.60 0.71 0.89 0.97 0.90 0.87 0.92 0.45 0.27 0.33 0.34 0.55 0.45 0.56 0.63

Based on: 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 Q4 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 3,760 ÷ 22,015 = 0.17

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Home Depot Inc. cash ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.