Analysis of Liquidity Ratios
Quarterly Data
Liquidity ratios measure the company ability to meet its short-term obligations.
Liquidity Ratios (Summary)
Sherwin-Williams Co., liquidity ratios (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
| Liquidity ratio | Description | The company |
|---|---|---|
| Current ratio | A liquidity ratio calculated as current assets divided by current liabilities. | Sherwin-Williams Co. current ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Quick ratio | A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. | Sherwin-Williams Co. quick ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022. |
| Cash ratio | A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. | Sherwin-Williams Co. cash ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022. |
Current Ratio
Sherwin-Williams Co., current ratio calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Current assets | 6,259,500) | 6,086,400) | 5,053,700) | 5,378,400) | 5,185,700) | 5,109,600) | 4,591,400) | 5,175,600) | 4,883,200) | 4,928,000) | 4,631,700) | 4,907,739) | 5,089,964) | 4,815,144) | 4,344,487) | 5,038,032) | 5,037,205) | 4,886,903) | 4,465,840) | 4,683,904) | 4,854,001) | 3,876,664) | |||||||
| Current liabilities | 7,198,200) | 6,953,100) | 5,719,500) | 6,478,500) | 6,190,400) | 5,651,600) | 4,594,400) | 4,358,300) | 4,459,600) | 5,220,200) | 4,521,900) | 4,865,790) | 6,342,640) | 5,000,556) | 4,297,747) | 4,842,065) | 4,190,087) | 4,327,152) | 3,987,180) | 4,371,661) | 4,151,913) | 2,939,002) | |||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||
| Current ratio1 | 0.87 | 0.88 | 0.88 | 0.83 | 0.84 | 0.90 | 1.00 | 1.19 | 1.09 | 0.94 | 1.02 | 1.01 | 0.80 | 0.96 | 1.01 | 1.04 | 1.20 | 1.13 | 1.12 | 1.07 | 1.17 | 1.32 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Current Ratio, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.74 | 0.84 | 0.74 | 0.81 | 0.71 | 0.74 | 0.80 | 0.83 | 0.80 | 0.74 | 0.85 | 0.90 | 1.02 | 1.35 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Current ratio = Current assets ÷ Current liabilities
= 6,259,500 ÷ 7,198,200 = 0.87
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. | Sherwin-Williams Co. current ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Quick Ratio
Sherwin-Williams Co., quick ratio calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cash and cash equivalents | 312,600) | 401,100) | 165,700) | 313,300) | 219,600) | 314,700) | 226,600) | 619,900) | 188,100) | 238,500) | 161,800) | 189,645) | 145,577) | 94,393) | 155,505) | 181,511) | 154,973) | 158,613) | 204,213) | 207,937) | 210,049) | 1,017,808) | |||||||
| Accounts receivable, net | 2,982,500) | 2,783,600) | 2,352,400) | 2,598,000) | 2,590,600) | 2,414,100) | 2,078,100) | 2,454,500) | 2,472,500) | 2,291,500) | 2,088,900) | 2,479,043) | 2,659,051) | 2,339,551) | 2,018,768) | 2,584,280) | 2,625,066) | 2,326,411) | 2,104,555) | 2,426,222) | 2,377,874) | 1,356,851) | |||||||
| Total quick assets | 3,295,100) | 3,184,700) | 2,518,100) | 2,911,300) | 2,810,200) | 2,728,800) | 2,304,700) | 3,074,400) | 2,660,600) | 2,530,000) | 2,250,700) | 2,668,688) | 2,804,628) | 2,433,944) | 2,174,273) | 2,765,791) | 2,780,039) | 2,485,024) | 2,308,768) | 2,634,159) | 2,587,923) | 2,374,659) | |||||||
| Current liabilities | 7,198,200) | 6,953,100) | 5,719,500) | 6,478,500) | 6,190,400) | 5,651,600) | 4,594,400) | 4,358,300) | 4,459,600) | 5,220,200) | 4,521,900) | 4,865,790) | 6,342,640) | 5,000,556) | 4,297,747) | 4,842,065) | 4,190,087) | 4,327,152) | 3,987,180) | 4,371,661) | 4,151,913) | 2,939,002) | |||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||
| Quick ratio1 | 0.46 | 0.46 | 0.44 | 0.45 | 0.45 | 0.48 | 0.50 | 0.71 | 0.60 | 0.48 | 0.50 | 0.55 | 0.44 | 0.49 | 0.51 | 0.57 | 0.66 | 0.57 | 0.58 | 0.60 | 0.62 | 0.81 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Quick Ratio, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.56 | 0.65 | 0.55 | 0.63 | 0.52 | 0.56 | 0.59 | 0.64 | 0.61 | 0.54 | 0.61 | 0.62 | 0.72 | 0.94 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 3,295,100 ÷ 7,198,200 = 0.46
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. | Sherwin-Williams Co. quick ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022. |
Cash Ratio
Sherwin-Williams Co., cash ratio calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cash and cash equivalents | 312,600) | 401,100) | 165,700) | 313,300) | 219,600) | 314,700) | 226,600) | 619,900) | 188,100) | 238,500) | 161,800) | 189,645) | 145,577) | 94,393) | 155,505) | 181,511) | 154,973) | 158,613) | 204,213) | 207,937) | 210,049) | 1,017,808) | |||||||
| Total cash assets | 312,600) | 401,100) | 165,700) | 313,300) | 219,600) | 314,700) | 226,600) | 619,900) | 188,100) | 238,500) | 161,800) | 189,645) | 145,577) | 94,393) | 155,505) | 181,511) | 154,973) | 158,613) | 204,213) | 207,937) | 210,049) | 1,017,808) | |||||||
| Current liabilities | 7,198,200) | 6,953,100) | 5,719,500) | 6,478,500) | 6,190,400) | 5,651,600) | 4,594,400) | 4,358,300) | 4,459,600) | 5,220,200) | 4,521,900) | 4,865,790) | 6,342,640) | 5,000,556) | 4,297,747) | 4,842,065) | 4,190,087) | 4,327,152) | 3,987,180) | 4,371,661) | 4,151,913) | 2,939,002) | |||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||
| Cash ratio1 | 0.04 | 0.06 | 0.03 | 0.05 | 0.04 | 0.06 | 0.05 | 0.14 | 0.04 | 0.05 | 0.04 | 0.04 | 0.02 | 0.02 | 0.04 | 0.04 | 0.04 | 0.04 | 0.05 | 0.05 | 0.05 | 0.35 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Cash Ratio, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.24 | 0.31 | 0.21 | 0.32 | 0.21 | 0.27 | 0.27 | 0.35 | 0.33 | 0.26 | 0.22 | 0.19 | 0.26 | 0.52 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 312,600 ÷ 7,198,200 = 0.04
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. | Sherwin-Williams Co. cash ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022. |