Analysis of Liquidity Ratios
Quarterly Data
Liquidity ratios measure the company’s ability to meet its short-term obligations.
Liquidity Ratios (Summary)
Sherwin-Williams Co., liquidity ratios (quarterly data)
Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).
Liquidity ratio | Description | The company |
---|---|---|
Current ratio | A liquidity ratio calculated as current assets divided by current liabilities. | Sherwin-Williams Co.’s current ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Quick ratio | A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. | Sherwin-Williams Co.’s quick ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Cash ratio | A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. | Sherwin-Williams Co.’s cash ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
Current Ratio
Sherwin-Williams Co., current ratio calculation (quarterly data)
Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).
1 Q3 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 5,175,600 ÷ 4,358,300 = 1.19
Liquidity ratio | Description | The company |
---|---|---|
Current ratio | A liquidity ratio calculated as current assets divided by current liabilities. | Sherwin-Williams Co.’s current ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Quick Ratio
Sherwin-Williams Co., quick ratio calculation (quarterly data)
Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).
1 Q3 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 3,074,400 ÷ 4,358,300 = 0.71
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.’s quick ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Cash Ratio
Sherwin-Williams Co., cash ratio calculation (quarterly data)
Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).
1 Q3 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 619,900 ÷ 4,358,300 = 0.14
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.’s cash ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |