Stock Analysis on Net

Lowe’s Cos. Inc. (NYSE:LOW)

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Lowe’s Cos. Inc., liquidity ratios (quarterly data)

Microsoft Excel
Nov 3, 2023 Aug 4, 2023 May 5, 2023 Feb 3, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 May 1, 2020 Jan 31, 2020 Nov 1, 2019 Aug 2, 2019 May 3, 2019 Feb 1, 2019 Nov 2, 2018 Aug 3, 2018 May 4, 2018 Feb 2, 2018 Nov 3, 2017 Aug 4, 2017 May 5, 2017
Current ratio 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 1.06 1.02 1.03 1.04
Quick ratio 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 0.06 0.06 0.13 0.14
Cash ratio 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 0.06 0.06 0.13 0.14

Based on: 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04), 10-K (reporting date: 2018-02-02), 10-Q (reporting date: 2017-11-03), 10-Q (reporting date: 2017-08-04), 10-Q (reporting date: 2017-05-05).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Lowe’s Cos. Inc. current ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Lowe’s Cos. Inc. quick ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Lowe’s Cos. Inc. cash ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Current Ratio

Lowe’s Cos. Inc., current ratio calculation (quarterly data)

Microsoft Excel
Nov 3, 2023 Aug 4, 2023 May 5, 2023 Feb 3, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 May 1, 2020 Jan 31, 2020 Nov 1, 2019 Aug 2, 2019 May 3, 2019 Feb 1, 2019 Nov 2, 2018 Aug 3, 2018 May 4, 2018 Feb 2, 2018 Nov 3, 2017 Aug 4, 2017 May 5, 2017
Selected Financial Data (US$ in millions)
Current assets 19,968 22,236 23,918 21,442 24,991 22,667 25,611 20,060 24,849 25,083 26,816 22,326 26,916 27,717 21,926 15,318 15,662 16,796 19,335 14,228 15,138 15,483 16,033 12,772 14,009 14,033 15,276
Current liabilities 16,496 17,612 19,210 19,511 20,876 20,366 21,831 19,668 20,834 21,664 22,892 18,730 19,564 21,370 18,325 15,182 15,063 15,835 17,781 14,497 15,069 14,581 15,774 12,096 13,738 13,625 14,686
Liquidity Ratio
Current ratio1 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 1.06 1.02 1.03 1.04
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
Home Depot Inc. 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
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 1.66 1.53 1.63 1.64

Based on: 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04), 10-K (reporting date: 2018-02-02), 10-Q (reporting date: 2017-11-03), 10-Q (reporting date: 2017-08-04), 10-Q (reporting date: 2017-05-05).

1 Q3 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 19,968 ÷ 16,496 = 1.21

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. Lowe’s Cos. Inc. current ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Quick Ratio

Lowe’s Cos. Inc., quick ratio calculation (quarterly data)

Microsoft Excel
Nov 3, 2023 Aug 4, 2023 May 5, 2023 Feb 3, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 May 1, 2020 Jan 31, 2020 Nov 1, 2019 Aug 2, 2019 May 3, 2019 Feb 1, 2019 Nov 2, 2018 Aug 3, 2018 May 4, 2018 Feb 2, 2018 Nov 3, 2017 Aug 4, 2017 May 5, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,210 3,494 2,950 1,348 3,192 1,482 3,414 1,133 6,121 4,835 6,692 4,690 8,249 11,641 5,955 716 794 1,796 2,973 511 1,668 2,251 1,565 588 743 1,696 1,963
Short-term investments 321 374 423 384 464 450 368 271 552 1,420 454 506 1,852 1,085 201 160 127 275 190 218 208 391 205 102 85 119 84
Total quick assets 1,531 3,868 3,373 1,732 3,656 1,932 3,782 1,404 6,673 6,255 7,146 5,196 10,101 12,726 6,156 876 921 2,071 3,163 729 1,876 2,642 1,770 690 828 1,815 2,047
 
Current liabilities 16,496 17,612 19,210 19,511 20,876 20,366 21,831 19,668 20,834 21,664 22,892 18,730 19,564 21,370 18,325 15,182 15,063 15,835 17,781 14,497 15,069 14,581 15,774 12,096 13,738 13,625 14,686
Liquidity Ratio
Quick ratio1 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 0.06 0.06 0.13 0.14
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
Home Depot Inc. 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
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 0.70 0.59 0.70 0.75

Based on: 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04), 10-K (reporting date: 2018-02-02), 10-Q (reporting date: 2017-11-03), 10-Q (reporting date: 2017-08-04), 10-Q (reporting date: 2017-05-05).

1 Q3 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 1,531 ÷ 16,496 = 0.09

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. Lowe’s Cos. Inc. quick ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Cash Ratio

Lowe’s Cos. Inc., cash ratio calculation (quarterly data)

Microsoft Excel
Nov 3, 2023 Aug 4, 2023 May 5, 2023 Feb 3, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 May 1, 2020 Jan 31, 2020 Nov 1, 2019 Aug 2, 2019 May 3, 2019 Feb 1, 2019 Nov 2, 2018 Aug 3, 2018 May 4, 2018 Feb 2, 2018 Nov 3, 2017 Aug 4, 2017 May 5, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,210 3,494 2,950 1,348 3,192 1,482 3,414 1,133 6,121 4,835 6,692 4,690 8,249 11,641 5,955 716 794 1,796 2,973 511 1,668 2,251 1,565 588 743 1,696 1,963
Short-term investments 321 374 423 384 464 450 368 271 552 1,420 454 506 1,852 1,085 201 160 127 275 190 218 208 391 205 102 85 119 84
Total cash assets 1,531 3,868 3,373 1,732 3,656 1,932 3,782 1,404 6,673 6,255 7,146 5,196 10,101 12,726 6,156 876 921 2,071 3,163 729 1,876 2,642 1,770 690 828 1,815 2,047
 
Current liabilities 16,496 17,612 19,210 19,511 20,876 20,366 21,831 19,668 20,834 21,664 22,892 18,730 19,564 21,370 18,325 15,182 15,063 15,835 17,781 14,497 15,069 14,581 15,774 12,096 13,738 13,625 14,686
Liquidity Ratio
Cash ratio1 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 0.06 0.06 0.13 0.14
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
Home Depot Inc. 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
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 0.64 0.53 0.63 0.68

Based on: 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04), 10-K (reporting date: 2018-02-02), 10-Q (reporting date: 2017-11-03), 10-Q (reporting date: 2017-08-04), 10-Q (reporting date: 2017-05-05).

1 Q3 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 1,531 ÷ 16,496 = 0.09

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. Lowe’s Cos. Inc. cash ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.