Analysis of Liquidity Ratios
Quarterly Data
Liquidity ratios measure the company ability to meet its short-term obligations.
Liquidity Ratios (Summary)
Home Depot Inc., liquidity ratios (quarterly data)
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)
| 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)
| 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)
| 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. |