THE SHERWIN-WILLIAMS COMPANY (SHW) Quick Ratio
- Quick ratio · latest quarter: Value (m); Formula and calculation Cash, cash equivalents, current marketable securities and trade receivables / current liabilities. Period ending 2026-06-30..
Quick ratio
Overview →Financial period ending 2026-06-30; current quote (m). Amounts retain their stated periods and units.
| Metric | Value | Formula and calculation |
|---|---|---|
| Quick ratio · latest quarter | (m) | Cash, cash equivalents, current marketable securities and trade receivables / current liabilities. Period ending 2026-06-30. Calculation unavailable: missing inputs remain (m). |
Calculation inputs
| Input | Amount with unit | Raw financial data |
|---|---|---|
| Cash, securities and trade receivables | (m) | Cash and Cash Equivalents, at Carrying Value · Accounts Receivable, after Allowance for Credit Loss, Current |
| Current obligations | 9.63B USD | Liabilities, Current |
| Cash and equivalents | 293.50M USD | Cash and Cash Equivalents, at Carrying Value |
| Short-term securities | (m) | |
| Customer receivables | 3.57B USD | Accounts Receivable, after Allowance for Credit Loss, Current |
| Inventory · excluded from quick assets | 2.53B USD | Inventory, Net |
Calculated history
Changes compare with the next older row (previous quarter), unless explicitly labeled otherwise. Rolling 12-month growth compares two successive quarter-end rolling totals; it is not year-over-year growth.
| Period ending | Cash, securities and trade receivables (USD) | Current obligations (USD) | Cash and equivalents (USD) | Short-term securities (USD) | Customer receivables (USD) | Inventory · excluded from quick assets (USD) | Quick ratio |
|---|---|---|---|---|---|---|---|
| 2026-06-30 | (m) | $9.63B | $293.50M | (m) | $3.57B | $2.53B | (m) |
| 2026-03-31 | (m) | $7.53B | $216.90M | (m) | $3.19B | $2.47B | (m) |
| 2025-12-31 | (m) | $6.92B | $207.20M | (m) | $2.79B | $2.32B | (m) |
| 2025-09-30 | (m) | $7.47B | $241.50M | (m) | $3.12B | $2.28B | (m) |
| 2025-06-30 | (m) | $8.20B | $269.80M | (m) | $3.11B | $2.48B | (m) |
| 2025-03-31 | (m) | $7.88B | $199.80M | (m) | $2.81B | $2.52B | (m) |
| 2024-12-31 | (m) | $6.81B | $210.40M | (m) | $2.39B | $2.29B | (m) |
| 2024-09-30 | (m) | $7.22B | $238.20M | (m) | $2.97B | $2.27B | (m) |
| 2024-06-30 | (m) | $7.47B | $200.00M | (m) | $3.05B | $2.29B | (m) |
| 2024-03-31 | (m) | $7.48B | $179.90M | (m) | $2.81B | $2.38B | (m) |
| 2023-12-31 | (m) | $6.63B | $276.80M | (m) | $2.47B | $2.33B | (m) |
| 2023-09-30 | (m) | $6.62B | $503.40M | (m) | $2.94B | $2.24B | (m) |
| 2023-06-30 | (m) | $6.34B | $209.40M | (m) | $3.12B | $2.44B | (m) |
| 2023-03-31 | (m) | $6.31B | $151.40M | (m) | $2.91B | $2.71B | (m) |
| 2022-12-31 | (m) | $5.96B | $198.80M | (m) | $2.56B | $2.63B | (m) |
| 2022-09-30 | (m) | $6.10B | $130.50M | (m) | $2.90B | $2.55B | (m) |
| 2022-06-30 | (m) | $7.20B | $312.60M | (m) | $2.98B | $2.41B | (m) |
| 2022-03-31 | (m) | $6.95B | $401.10M | (m) | $2.78B | $2.33B | (m) |
| 2021-12-31 | (m) | $5.72B | $165.70M | (m) | $2.35B | $1.93B | (m) |
| 2021-09-30 | (m) | $6.48B | $313.30M | (m) | $2.60B | $1.82B | (m) |
| 2021-06-30 | (m) | $6.19B | $219.60M | (m) | $2.59B | $1.80B | (m) |
| 2021-03-31 | (m) | $5.65B | $314.70M | (m) | $2.41B | $1.85B | (m) |
| 2020-12-31 | (m) | $4.59B | $226.60M | (m) | $2.08B | $1.80B | (m) |
| 2020-09-30 | (m) | $4.36B | $619.90M | (m) | $2.45B | $1.67B | (m) |
| 2020-06-30 | (m) | $4.46B | $188.10M | (m) | $2.47B | $1.79B | (m) |
| 2020-03-31 | (m) | $5.22B | $238.50M | (m) | $2.29B | $1.95B | (m) |
| 2019-12-31 | (m) | $4.52B | $161.80M | (m) | $2.09B | $1.89B | (m) |
| 2019-09-30 | (m) | $4.87B | $189.65M | (m) | $2.48B | $1.82B | (m) |
| 2019-06-30 | (m) | $6.34B | $145.58M | (m) | $2.66B | $1.89B | (m) |
| 2019-03-31 | (m) | $5.00B | $94.39M | (m) | $2.34B | $1.99B | (m) |
| 2018-12-31 | (m) | $4.30B | $155.50M | (m) | $2.02B | $1.82B | (m) |
| 2018-09-30 | (m) | $4.84B | $181.51M | (m) | $2.58B | $1.86B | (m) |
| 2018-06-30 | (m) | $4.19B | $154.97M | (m) | $2.63B | $1.87B | (m) |
| 2018-03-31 | (m) | $4.33B | $158.61M | (m) | $2.33B | $2.00B | (m) |
| 2017-12-31 | (m) | $3.99B | $204.21M | (m) | $2.10B | $1.80B | (m) |
| 2017-09-30 | (m) | $4.37B | $207.94M | (m) | $2.43B | $1.70B | (m) |
| 2017-06-30 | (m) | $4.15B | $210.05M | (m) | $2.38B | $1.85B | (m) |
| 2017-03-31 | (m) | $2.94B | $1.02B | (m) | $1.36B | $1.25B | (m) |
| 2016-12-31 | (m) | $2.83B | $889.79M | (m) | $1.23B | $1.07B | (m) |
| 2016-09-30 | (m) | $2.52B | $702.57M | (m) | $1.46B | $1.11B | (m) |
| 2016-06-30 | (m) | $2.63B | $402.66M | (m) | $1.47B | $1.15B | (m) |
| 2016-03-31 | (m) | $2.26B | $70.55M | (m) | $1.29B | $1.15B | (m) |
| 2015-12-31 | (m) | $2.14B | $205.74M | (m) | $1.11B | $1.02B | (m) |
| 2015-09-30 | (m) | $2.29B | $91.03M | (m) | $1.41B | $1.05B | (m) |
| 2015-06-30 | (m) | $3.36B | $75.07M | (m) | $1.45B | $1.13B | (m) |
| 2015-03-31 | (m) | $3.38B | $64.01M | (m) | $1.23B | $1.16B | (m) |
| 2014-12-31 | (m) | $2.68B | $40.73M | (m) | $1.13B | $1.03B | (m) |
| 2014-09-30 | (m) | $2.87B | $261.35M | (m) | $1.41B | $1.05B | (m) |
| 2014-06-30 | (m) | $2.73B | $267.20M | (m) | $1.40B | $1.09B | (m) |
| 2014-03-31 | (m) | $2.45B | $366.46M | (m) | $1.17B | $1.10B | (m) |
| 2013-12-31 | (m) | $2.53B | $744.89M | (m) | $1.10B | $970.82M | (m) |
| 2013-09-30 | (m) | $2.41B | $1.04B | (m) | $1.35B | $1.02B | (m) |
| 2013-06-30 | (m) | $1.97B | $741.08M | (m) | $1.30B | $984.84M | (m) |
| 2013-03-31 | (m) | $1.78B | $613.93M | (m) | $1.13B | $1.01B | (m) |
| 2012-12-31 | (m) | $1.88B | $862.59M | (m) | $1.03B | $920.32M | (m) |
| 2012-09-30 | (m) | $2.29B | $55.18M | (m) | $1.26B | $963.70M | (m) |
| 2012-06-30 | (m) | $2.53B | $46.62M | (m) | $1.24B | $1.03B | (m) |
| 2012-03-31 | (m) | $2.40B | $25.49M | (m) | $1.14B | $1.02B | (m) |
| 2011-12-31 | (m) | $2.16B | $32.70M | (m) | $989.87M | $926.81M | (m) |
| 2011-09-30 | (m) | $2.35B | $46.03M | (m) | $1.17B | $966.76M | (m) |
| 2011-06-30 | (m) | $2.39B | $71.56M | (m) | $1.18B | $1.07B | (m) |
| 2011-03-31 | (m) | $2.33B | $53.95M | (m) | $1.01B | $1.06B | (m) |
| 2010-12-31 | (m) | $2.06B | $58.59M | (m) | $916.66M | $917.70M | (m) |
| 2010-09-30 | (m) | $2.13B | $64.95M | (m) | $1.07B | $858.99M | (m) |
| 2010-06-30 | (m) | $1.83B | $48.40M | (m) | $986.33M | $793.83M | (m) |
| 2010-03-31 | (m) | $1.56B | $91.17M | (m) | $797.82M | $787.32M | (m) |
| 2009-12-31 | (m) | $1.39B | $69.33M | (m) | $696.05M | $738.49M | (m) |
| 2009-09-30 | (m) | $1.89B | $32.77M | (m) | $901.20M | $726.49M | (m) |
| 2009-06-30 | (m) | $1.90B | $49.26M | (m) | $908.66M | $769.99M | (m) |
| 2009-03-31 | (m) | $1.96B | $42.24M | (m) | $785.64M | $838.82M | (m) |
| 2008-12-31 | (m) | $1.94B | $26.21M | (m) | $769.99M | $864.20M | (m) |
| 2008-09-30 | (m) | $2.41B | $40.93M | (m) | $1.07B | $863.46M | (m) |
| 2008-06-30 | (m) | $2.57B | $45.57M | (m) | $1.09B | $920.64M | (m) |
| 2007-12-31 | (m) | (m) | $27.32M | (m) | (m) | (m) | (m) |
| 2006-12-31 | (m) | (m) | $469.17M | (m) | (m) | (m) | (m) |
(m) means missing inputs. Historical market-based ratios use the saved close on or immediately before period ending and that period’s reported shares; current quotes are not substituted. Five-year projections repeat historical CAGR, not analyst forecasts.
Similar stocks
| Stock Name | Country | Market Cap | PE Ratio |
|---|---|---|---|
| FASTENAL CO (FAST) | United States | $58.218B | 40.75 |
| TRACTOR SUPPLY CO /DE/ (TSCO) | United States | $16.376B | 16.09 |
| GrowGeneration Corp. (GRWG) | United States | $0.093B | -5.31 |
| iPower Inc. (IPW) | United States | $0.006B | -45,669.89 |