Stock Analysis on Net
Stock Analysis on Net

3M Co. (NYSE:MMM)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel LibreOffice Calc

Liquidity Ratios (Summary)

3M Co., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Current ratio 1.70 1.73 1.83 1.89 1.90 1.94 1.65 1.41 2.30 1.93 2.02 1.89 1.97 1.56 1.65 1.86 2.07 2.22 1.99 1.89 1.90 1.58 1.51
Quick ratio 1.11 1.11 1.19 1.23 1.24 1.23 1.02 0.79 1.63 1.15 1.21 1.14 1.21 0.96 1.04 1.18 1.30 1.35 1.17 1.14 1.16 0.90 0.84
Cash ratio 0.60 0.58 0.61 0.63 0.62 0.61 0.49 0.27 0.99 0.41 0.49 0.45 0.48 0.36 0.46 0.54 0.52 0.49 0.39 0.43 0.42 0.26 0.21

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

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

Current Ratio

3M Co., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Current assets 16,426  16,343  15,345  14,982  14,110  14,106  15,090  12,971  18,020  14,051  14,374  13,709  14,419  13,890  14,818  14,277  13,656  12,641  11,901  11,726  12,179  11,436  10,874 
Current liabilities 9,635  9,440  8,363  7,948  7,410  7,282  9,134  9,222  7,821  7,265  7,125  7,244  7,336  8,902  8,959  7,687  6,598  5,697  5,995  6,219  6,400  7,254  7,178 
Liquidity Ratio
Current ratio1 1.70 1.73 1.83 1.89 1.90 1.94 1.65 1.41 2.30 1.93 2.02 1.89 1.97 1.56 1.65 1.86 2.07 2.22 1.99 1.89 1.90 1.58 1.51
Benchmarks
Current Ratio, Competitors2
Boeing Co. 1.36 1.35 1.33 1.39 1.42 1.41 1.17 1.05 1.11 1.03 1.07 1.08 1.10 1.11 1.15 1.16 1.18 1.19 1.25 1.25 1.28 1.27 1.32
Caterpillar Inc. 1.61 1.56 1.60 1.53 1.54 1.50 1.42 1.47 1.44 1.43 1.43 1.37 1.48 1.37 1.36 1.35 1.44 1.31 1.29 1.22 1.27 1.24 1.29
General Electric Co. 1.80 1.81 1.96 1.58 1.27 1.22 1.14 0.99 1.07 1.11 1.13 1.08 0.97 1.07 1.05 1.16 1.15 1.14 1.13 1.17 1.21 1.19 1.18
Honeywell International Inc. 1.29 1.41 1.43 1.47 1.64 1.63 1.30 1.34 1.31 1.19 1.24 1.29 1.49 1.38 1.36 1.38 1.35 1.34 1.36 1.41 1.20 1.28 1.25
Illinois Tool Works Inc. 2.20 2.20 2.50 2.52 2.37 2.75 2.71 2.90 2.81 2.87 1.53 1.63 1.62 1.73 2.20 2.38 2.41 2.32 2.24 2.22 1.77 2.18 2.30
Lockheed Martin Corp. 1.42 1.36 1.38 1.39 1.33 1.31 1.23 1.22 1.28 1.20 1.17 1.12 1.11 1.19 1.27 1.38 1.32 1.21 1.22 1.20 1.19 1.03 1.06
Raytheon Technologies Corp. 1.23 1.17 1.17 1.21 1.22 1.20 1.23 1.08 1.06 1.05 1.13 1.13 1.52 1.46 1.32 1.35 1.31 1.37 1.24 1.30 1.27 1.26 1.34

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

1 Q3 2021 Calculation
Current ratio = Current assets ÷ Current liabilities
= 16,426 ÷ 9,635 = 1.70

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. 3M Co.’s current ratio deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Quick Ratio

3M Co., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 4,878  4,695  4,636  4,634  4,121  4,219  4,253  2,353  7,731  2,849  2,938  2,853  3,185  2,801  3,491  3,053  2,831  2,654  2,173  2,398  2,308  1,688  1,337 
Marketable securities, current 855  805  501  404  440  247  224  98  30  139  539  380  338  385  604  1,076  586  140  141  280  358  177  176 
Accounts receivable, net of allowances 4,916  4,991  4,817  4,705  4,623  4,459  4,821  4,791  5,020  5,374  5,173  5,020  5,329  5,383  5,252  4,911  5,156  4,919  4,722  4,392  4,743  4,667  4,485 
Total quick assets 10,649  10,491  9,954  9,743  9,184  8,925  9,298  7,242  12,781  8,362  8,650  8,253  8,852  8,569  9,347  9,040  8,573  7,713  7,036  7,070  7,409  6,532  5,998 
 
Current liabilities 9,635  9,440  8,363  7,948  7,410  7,282  9,134  9,222  7,821  7,265  7,125  7,244  7,336  8,902  8,959  7,687  6,598  5,697  5,995  6,219  6,400  7,254  7,178 
Liquidity Ratio
Quick ratio1 1.11 1.11 1.19 1.23 1.24 1.23 1.02 0.79 1.63 1.15 1.21 1.14 1.21 0.96 1.04 1.18 1.30 1.35 1.17 1.14 1.16 0.90 0.84
Benchmarks
Quick Ratio, Competitors2
Boeing Co. 0.38 0.38 0.37 0.41 0.42 0.47 0.30 0.23 0.28 0.25 0.26 0.28 0.29 0.29 0.30 0.37 0.39 0.39 0.38 0.38 0.40 0.39 0.37
Caterpillar Inc. 1.00 1.02 1.08 1.02 1.01 0.98 0.91 0.98 0.93 0.94 0.91 0.90 0.95 0.90 0.90 0.91 0.98 0.92 0.89 0.83 0.82 0.82 0.84
General Electric Co. 0.90 0.90 1.06 1.27 1.01 0.97 0.91 0.69 0.65 0.71 0.73 0.79 0.63 0.70 0.72 0.84 0.80 0.81 0.79 0.87 0.92 0.90 0.93
Honeywell International Inc. 0.96 1.06 1.08 1.15 1.27 1.26 0.93 0.99 1.00 0.87 0.92 0.97 1.13 1.02 1.02 1.04 1.03 1.02 1.03 1.07 0.83 0.87 0.82
Illinois Tool Works Inc. 1.57 1.64 1.92 1.96 1.84 1.94 1.90 2.06 1.95 1.97 1.13 1.16 1.19 1.27 1.65 1.87 1.90 1.81 1.75 1.75 1.38 1.69 1.78
Lockheed Martin Corp. 1.18 1.10 1.09 1.05 1.08 1.04 0.96 0.93 1.03 0.93 0.93 0.88 0.86 0.93 1.01 0.91 0.91 0.82 0.82 0.80 0.82 0.68 0.68
Raytheon Technologies Corp. 0.82 0.79 0.79 0.78 0.84 0.75 0.81 0.73 0.71 0.70 0.75 0.76 1.12 1.05 0.90 0.88 0.86 0.92 0.80 0.85 0.83 0.83 0.88

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

1 Q3 2021 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 10,649 ÷ 9,635 = 1.11

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. 3M Co.’s quick ratio deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Cash Ratio

3M Co., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 4,878  4,695  4,636  4,634  4,121  4,219  4,253  2,353  7,731  2,849  2,938  2,853  3,185  2,801  3,491  3,053  2,831  2,654  2,173  2,398  2,308  1,688  1,337 
Marketable securities, current 855  805  501  404  440  247  224  98  30  139  539  380  338  385  604  1,076  586  140  141  280  358  177  176 
Total cash assets 5,733  5,500  5,137  5,038  4,561  4,466  4,477  2,451  7,761  2,988  3,477  3,233  3,523  3,186  4,095  4,129  3,417  2,794  2,314  2,678  2,666  1,865  1,513 
 
Current liabilities 9,635  9,440  8,363  7,948  7,410  7,282  9,134  9,222  7,821  7,265  7,125  7,244  7,336  8,902  8,959  7,687  6,598  5,697  5,995  6,219  6,400  7,254  7,178 
Liquidity Ratio
Cash ratio1 0.60 0.58 0.61 0.63 0.62 0.61 0.49 0.27 0.99 0.41 0.49 0.45 0.48 0.36 0.46 0.54 0.52 0.49 0.39 0.43 0.42 0.26 0.21
Benchmarks
Cash Ratio, Competitors2
Boeing Co. 0.23 0.24 0.24 0.29 0.29 0.35 0.16 0.10 0.12 0.10 0.09 0.10 0.13 0.13 0.13 0.18 0.18 0.20 0.18 0.20 0.20 0.19 0.17
Caterpillar Inc. 0.36 0.39 0.43 0.36 0.37 0.35 0.27 0.31 0.29 0.27 0.26 0.28 0.31 0.31 0.29 0.31 0.37 0.36 0.34 0.27 0.24 0.25 0.22
General Electric Co. 0.52 0.50 0.67 0.78 0.70 0.70 0.67 0.47 0.41 0.44 0.47 0.50 0.36 0.40 0.42 0.54 0.49 0.54 0.52 0.58 0.62 0.61 0.69
Honeywell International Inc. 0.60 0.68 0.71 0.79 0.87 0.87 0.51 0.58 0.62 0.50 0.55 0.58 0.65 0.55 0.55 0.57 0.56 0.55 0.56 0.57 0.35 0.32 0.29
Illinois Tool Works Inc. 0.66 0.70 0.93 0.99 0.85 0.89 0.70 0.92 0.82 0.77 0.44 0.42 0.43 0.46 0.66 1.01 0.97 0.88 0.87 0.90 0.66 0.83 0.90
Lockheed Martin Corp. 0.18 0.18 0.20 0.23 0.24 0.19 0.13 0.11 0.16 0.08 0.06 0.05 0.06 0.09 0.17 0.23 0.22 0.18 0.16 0.15 0.20 0.08 0.10
Raytheon Technologies Corp. 0.22 0.23 0.24 0.25 0.28 0.20 0.25 0.21 0.21 0.19 0.20 0.20 0.52 0.44 0.31 0.37 0.34 0.39 0.30 0.33 0.32 0.31 0.35

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

1 Q3 2021 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 5,733 ÷ 9,635 = 0.60

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. 3M Co.’s cash ratio deteriorated from Q1 2021 to Q2 2021 but then slightly improved from Q2 2021 to Q3 2021.