Stock Analysis on Net

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

Analysis of Liquidity Ratios 

Microsoft Excel

Liquidity Ratios (Summary)

Lowe’s Cos. Inc., liquidity ratios

Microsoft Excel
Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017
Current ratio 1.02 1.19 1.01 0.98 1.06 1.00
Quick ratio 0.07 0.28 0.06 0.05 0.06 0.05
Cash ratio 0.07 0.28 0.06 0.05 0.06 0.05

Based on: 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01), 10-K (reporting date: 2018-02-02), 10-K (reporting date: 2017-02-03).

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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.
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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.
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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.

Current Ratio

Lowe’s Cos. Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017
Selected Financial Data (US$ in millions)
Current assets 20,060  22,326  15,318  14,228  12,772  12,000 
Current liabilities 19,668  18,730  15,182  14,497  12,096  11,974 
Liquidity Ratio
Current ratio1 1.02 1.19 1.01 0.98 1.06 1.00
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.14 1.05 1.10 1.10 1.04
Bed Bath & Beyond Inc. 1.14 1.58 1.55 1.88 1.83 1.87
Booking Holdings Inc. 2.10 3.56 1.83 2.36 2.58
Dollar Tree Inc. 1.34 1.35 1.20 2.05 1.60 1.87
Home Depot Inc. 1.01 1.23 1.08 1.11 1.17 1.25
Target Corp. 0.99 1.03 0.89 0.83 0.95 0.94
Ulta Beauty Inc. 1.46 1.87 1.81 2.32 2.64 2.90
Current Ratio, Sector
Retailing 1.18 1.10 1.12 1.16 1.15
Current Ratio, Industry
Consumer Discretionary 1.22 1.16 1.07 1.12 1.11

Based on: 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01), 10-K (reporting date: 2018-02-02), 10-K (reporting date: 2017-02-03).

1 2022 Calculation
Current ratio = Current assets ÷ Current liabilities
= 20,060 ÷ 19,668 = 1.02

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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.

Quick Ratio

Lowe’s Cos. Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,133  4,690  716  511  588  558 
Short-term investments 271  506  160  218  102  100 
Accounts receivable —  —  —  —  —  — 
Total quick assets 1,404  5,196  876  729  690  658 
 
Current liabilities 19,668  18,730  15,182  14,497  12,096  11,974 
Liquidity Ratio
Quick ratio1 0.07 0.28 0.06 0.05 0.06 0.05
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.86 0.83 0.83 0.80 0.70
Bed Bath & Beyond Inc. 0.21 0.59 0.56 0.48 0.33 0.24
Booking Holdings Inc. 2.00 3.38 1.68 2.20 2.46
Dollar Tree Inc. 0.24 0.38 0.18 0.25 0.42 0.45
Home Depot Inc. 0.20 0.47 0.23 0.22 0.34 0.32
Target Corp. 0.33 0.48 0.24 0.18 0.27 0.26
Ulta Beauty Inc. 0.43 0.92 0.56 0.66 0.77 0.95
Quick Ratio, Sector
Retailing 0.76 0.69 0.63 0.63 0.57
Quick Ratio, Industry
Consumer Discretionary 0.88 0.85 0.74 0.79 0.77

Based on: 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01), 10-K (reporting date: 2018-02-02), 10-K (reporting date: 2017-02-03).

1 2022 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 1,404 ÷ 19,668 = 0.07

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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.

Cash Ratio

Lowe’s Cos. Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,133  4,690  716  511  588  558 
Short-term investments 271  506  160  218  102  100 
Total cash assets 1,404  5,196  876  729  690  658 
 
Current liabilities 19,668  18,730  15,182  14,497  12,096  11,974 
Liquidity Ratio
Cash ratio1 0.07 0.28 0.06 0.05 0.06 0.05
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.68 0.67 0.63 0.60 0.54
Bed Bath & Beyond Inc. 0.21 0.59 0.56 0.48 0.33 0.24
Booking Holdings Inc. 1.79 3.23 1.36 1.77 2.12
Dollar Tree Inc. 0.24 0.38 0.15 0.20 0.38 0.41
Home Depot Inc. 0.08 0.34 0.12 0.11 0.22 0.18
Target Corp. 0.27 0.42 0.18 0.10 0.20 0.20
Ulta Beauty Inc. 0.28 0.78 0.44 0.50 0.62 0.78
Cash Ratio, Sector
Retailing 0.61 0.56 0.47 0.48 0.44
Cash Ratio, Industry
Consumer Discretionary 0.68 0.67 0.53 0.58 0.58

Based on: 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01), 10-K (reporting date: 2018-02-02), 10-K (reporting date: 2017-02-03).

1 2022 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 1,404 ÷ 19,668 = 0.07

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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.