Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel LibreOffice Calc

Liquidity Ratios (Summary)

Home Depot Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jan 28, 2018 Oct 29, 2017 Jul 30, 2017 Apr 30, 2017 Jan 29, 2017 Oct 30, 2016 Jul 31, 2016 May 1, 2016 Jan 31, 2016 Nov 1, 2015 Aug 2, 2015 May 3, 2015
Current ratio 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 1.17 1.23 1.30 1.21 1.25 1.34 1.30 1.25 1.36 1.16 1.19 1.06
Quick ratio 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 0.34 0.36 0.44 0.35 0.32 0.39 0.41 0.35 0.33 0.31 0.40 0.27
Cash ratio 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 0.22 0.22 0.31 0.22 0.18 0.25 0.28 0.21 0.18 0.19 0.30 0.17

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

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 Q1 2022 to Q2 2022 but then improved from Q2 2022 to Q3 2022 exceeding Q1 2022 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 Q1 2022 to Q2 2022 but then slightly improved from Q2 2022 to Q3 2022.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Home Depot Inc. cash ratio deteriorated from Q1 2022 to Q2 2022 but then slightly improved from Q2 2022 to Q3 2022.

Current Ratio

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

Microsoft Excel LibreOffice Calc
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 Jan 28, 2018 Oct 29, 2017 Jul 30, 2017 Apr 30, 2017 Jan 29, 2017 Oct 30, 2016 Jul 31, 2016 May 1, 2016 Jan 31, 2016 Nov 1, 2015 Aug 2, 2015 May 3, 2015
Selected Financial Data (US$ in millions)
Current assets 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  18,933  19,682  20,511  19,896  17,724  19,348  18,941  19,010  16,993  18,606  19,531  17,995 
Current liabilities 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  16,194  16,002  15,823  16,438  14,133  14,431  14,525  15,149  12,526  15,976  16,399  17,005 
Liquidity Ratio
Current ratio1 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 1.17 1.23 1.30 1.21 1.25 1.34 1.30 1.25 1.36 1.16 1.19 1.06
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.12 1.20 1.05 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09 1.10 1.08 1.07 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08
Booking Holdings Inc. 2.48 2.05 2.18 3.56 3.17 2.93 2.24 1.83 1.82 1.58 1.27 2.36 2.41 1.92 2.14 2.58 2.52 2.20 2.15 1.89 2.01 2.68 2.45
Lowe’s Cos. Inc. 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 1.06 1.02 1.03 1.04 1.00 1.01 1.01 1.17 1.01 1.02 0.94 0.99
Target Corp. 0.97 1.04 1.07 1.03 1.05 1.11 1.01 0.89 0.83 0.84 0.88 0.83 0.83 0.82 0.90 0.95 0.96 0.91 0.95 0.94 1.02 1.05 1.16 1.12 1.10 1.15 1.24
TJX Cos. Inc. 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 1.66 1.53 1.63 1.64 1.63 1.62 1.58 1.60 1.54 1.55 1.63 1.66

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

1 Q3 2022 Calculation
Current ratio = Current assets ÷ Current liabilities
= 30,466 ÷ 26,903 = 1.13

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 Q1 2022 to Q2 2022 but then improved from Q2 2022 to Q3 2022 exceeding Q1 2022 level.

Quick Ratio

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

Microsoft Excel LibreOffice Calc
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 Jan 28, 2018 Oct 29, 2017 Jul 30, 2017 Apr 30, 2017 Jan 29, 2017 Oct 30, 2016 Jul 31, 2016 May 1, 2016 Jan 31, 2016 Nov 1, 2015 Aug 2, 2015 May 3, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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  3,595  3,549  4,830  3,565  2,538  3,589  4,018  3,257  2,216  3,040  4,936  2,827 
Receivables, net 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  1,952  2,166  2,187  2,164  2,029  1,995  1,995  1,989  1,890  1,942  1,696  1,839 
Total quick assets 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  5,547  5,715  7,017  5,729  4,567  5,584  6,013  5,246  4,106  4,982  6,632  4,666 
 
Current liabilities 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  16,194  16,002  15,823  16,438  14,133  14,431  14,525  15,149  12,526  15,976  16,399  17,005 
Liquidity Ratio
Quick ratio1 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 0.34 0.36 0.44 0.35 0.32 0.39 0.41 0.35 0.33 0.31 0.40 0.27
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56
Booking Holdings Inc. 2.37 1.94 2.05 3.38 3.04 2.81 1.90 1.68 1.67 1.38 1.04 2.20 2.25 1.73 1.89 2.46 2.40 2.02 1.94 1.81 1.89 2.42 2.13
Lowe’s Cos. Inc. 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 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12
Target Corp. 0.25 0.38 0.42 0.42 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26
TJX Cos. Inc. 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 0.70 0.59 0.70 0.75 0.78 0.64 0.58 0.61 0.61 0.51 0.60 0.69

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

1 Q3 2022 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 8,600 ÷ 26,903 = 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 Q1 2022 to Q2 2022 but then slightly improved from Q2 2022 to Q3 2022.

Cash Ratio

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

Microsoft Excel LibreOffice Calc
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 Jan 28, 2018 Oct 29, 2017 Jul 30, 2017 Apr 30, 2017 Jan 29, 2017 Oct 30, 2016 Jul 31, 2016 May 1, 2016 Jan 31, 2016 Nov 1, 2015 Aug 2, 2015 May 3, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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  3,595  3,549  4,830  3,565  2,538  3,589  4,018  3,257  2,216  3,040  4,936  2,827 
Total cash assets 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  3,595  3,549  4,830  3,565  2,538  3,589  4,018  3,257  2,216  3,040  4,936  2,827 
 
Current liabilities 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  16,194  16,002  15,823  16,438  14,133  14,431  14,525  15,149  12,526  15,976  16,399  17,005 
Liquidity Ratio
Cash ratio1 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 0.22 0.22 0.31 0.22 0.18 0.25 0.28 0.21 0.18 0.19 0.30 0.17
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56
Booking Holdings Inc. 2.11 1.74 1.96 3.23 2.82 2.66 1.74 1.36 1.35 1.07 0.77 1.77 1.81 1.40 1.54 2.12 2.00 1.69 1.65 1.50 1.51 1.98 1.70
Lowe’s Cos. Inc. 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 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12
Target Corp. 0.25 0.38 0.42 0.42 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26
TJX Cos. Inc. 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 0.64 0.53 0.63 0.68 0.73 0.58 0.52 0.55 0.56 0.45 0.54 0.63

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

1 Q3 2022 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 5,067 ÷ 26,903 = 0.19

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 Q1 2022 to Q2 2022 but then slightly improved from Q2 2022 to Q3 2022.