Stock Analysis on Net
Stock Analysis on Net

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

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

Liquidity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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 Feb 3, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 May 1, 2015
Current ratio 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
Quick ratio 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
Cash ratio 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

Based on: 10-Q (filing date: 2021-05-27), 10-K (filing date: 2021-03-22), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-26), 10-Q (filing date: 2020-05-28), 10-K (filing date: 2020-03-23), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-03), 10-Q (filing date: 2019-06-03), 10-K (filing date: 2019-04-02), 10-Q (filing date: 2018-12-06), 10-Q (filing date: 2018-09-04), 10-Q (filing date: 2018-06-05), 10-K (filing date: 2018-04-02), 10-Q (filing date: 2017-12-05), 10-Q (filing date: 2017-09-05), 10-Q (filing date: 2017-06-06), 10-K (filing date: 2017-04-04), 10-Q (filing date: 2016-11-29), 10-Q (filing date: 2016-09-02), 10-Q (filing date: 2016-05-31), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-01), 10-Q (filing date: 2015-06-02).

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

Current Ratio

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

Microsoft Excel LibreOffice Calc
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 Feb 3, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 May 1, 2015
Selected Financial Data (US$ in millions)
Current assets 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  12,000  12,728  13,351  16,473  10,561  12,395  11,366  12,791 
Current liabilities 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  11,974  12,633  13,183  14,121  10,492  12,162  12,141  12,970 
Liquidity Ratio
Current ratio1 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
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 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.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
Home Depot Inc. 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
Target Corp. 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.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 (filing date: 2021-05-27), 10-K (filing date: 2021-03-22), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-26), 10-Q (filing date: 2020-05-28), 10-K (filing date: 2020-03-23), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-03), 10-Q (filing date: 2019-06-03), 10-K (filing date: 2019-04-02), 10-Q (filing date: 2018-12-06), 10-Q (filing date: 2018-09-04), 10-Q (filing date: 2018-06-05), 10-K (filing date: 2018-04-02), 10-Q (filing date: 2017-12-05), 10-Q (filing date: 2017-09-05), 10-Q (filing date: 2017-06-06), 10-K (filing date: 2017-04-04), 10-Q (filing date: 2016-11-29), 10-Q (filing date: 2016-09-02), 10-Q (filing date: 2016-05-31), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-01), 10-Q (filing date: 2015-06-02).

1 Q1 2022 Calculation
Current ratio = Current assets ÷ Current liabilities
= 26,816 ÷ 22,892 = 1.17

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.’s current ratio deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.

Quick Ratio

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

Microsoft Excel LibreOffice Calc
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 Feb 3, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 May 1, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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  558  960  1,988  4,561  405  1,227  901  1,434 
Short-term investments 454  506  1,852  1,085  201  160  127  275  190  218  208  391  205  102  85  119  84  100  123  168  174  307  158  188  95 
Total quick assets 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  658  1,083  2,156  4,735  712  1,385  1,089  1,529 
 
Current liabilities 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  11,974  12,633  13,183  14,121  10,492  12,162  12,141  12,970 
Liquidity Ratio
Quick ratio1 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
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 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.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
Home Depot Inc. 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
Target Corp. 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.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 (filing date: 2021-05-27), 10-K (filing date: 2021-03-22), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-26), 10-Q (filing date: 2020-05-28), 10-K (filing date: 2020-03-23), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-03), 10-Q (filing date: 2019-06-03), 10-K (filing date: 2019-04-02), 10-Q (filing date: 2018-12-06), 10-Q (filing date: 2018-09-04), 10-Q (filing date: 2018-06-05), 10-K (filing date: 2018-04-02), 10-Q (filing date: 2017-12-05), 10-Q (filing date: 2017-09-05), 10-Q (filing date: 2017-06-06), 10-K (filing date: 2017-04-04), 10-Q (filing date: 2016-11-29), 10-Q (filing date: 2016-09-02), 10-Q (filing date: 2016-05-31), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-01), 10-Q (filing date: 2015-06-02).

1 Q1 2022 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 7,146 ÷ 22,892 = 0.31

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.’s quick ratio deteriorated from Q3 2021 to Q4 2021 but then slightly improved from Q4 2021 to Q1 2022.

Cash Ratio

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

Microsoft Excel LibreOffice Calc
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 Feb 3, 2017 Oct 28, 2016 Jul 29, 2016 Apr 29, 2016 Jan 29, 2016 Oct 30, 2015 Jul 31, 2015 May 1, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 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  558  960  1,988  4,561  405  1,227  901  1,434 
Short-term investments 454  506  1,852  1,085  201  160  127  275  190  218  208  391  205  102  85  119  84  100  123  168  174  307  158  188  95 
Total cash assets 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  658  1,083  2,156  4,735  712  1,385  1,089  1,529 
 
Current liabilities 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  11,974  12,633  13,183  14,121  10,492  12,162  12,141  12,970 
Liquidity Ratio
Cash ratio1 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
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 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. 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
Home Depot Inc. 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
Target Corp. 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.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 (filing date: 2021-05-27), 10-K (filing date: 2021-03-22), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-26), 10-Q (filing date: 2020-05-28), 10-K (filing date: 2020-03-23), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-03), 10-Q (filing date: 2019-06-03), 10-K (filing date: 2019-04-02), 10-Q (filing date: 2018-12-06), 10-Q (filing date: 2018-09-04), 10-Q (filing date: 2018-06-05), 10-K (filing date: 2018-04-02), 10-Q (filing date: 2017-12-05), 10-Q (filing date: 2017-09-05), 10-Q (filing date: 2017-06-06), 10-K (filing date: 2017-04-04), 10-Q (filing date: 2016-11-29), 10-Q (filing date: 2016-09-02), 10-Q (filing date: 2016-05-31), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-01), 10-Q (filing date: 2015-06-02).

1 Q1 2022 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 7,146 ÷ 22,892 = 0.31

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.’s cash ratio deteriorated from Q3 2021 to Q4 2021 but then slightly improved from Q4 2021 to Q1 2022.