THE SHERWIN-WILLIAMS COMPANY (SHW) Current Ratio
- Current ratio · latest quarter: Value 0.73×; Formula and calculation Current assets / current liabilities..
Current ratio
Overview →Financial period ending 2026-06-30; current quote (m). Amounts retain their stated periods and units.
| Metric | Value | Formula and calculation |
|---|---|---|
| Current ratio · latest quarter | 0.73× | Current assets / current liabilities. $7.00B ÷ $9.63B ≈ 0.73× |
Calculation inputs
| Input | Amount with unit | Raw financial data |
|---|---|---|
| Current assets | 7.00B USD | Assets, 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 | 2.53B USD | Inventory, Net |
| Payables | 2.83B USD | Accounts Payable, Current |
| Borrowing debt due within one year | 1.50B USD | Long-term Debt, Current Maturities |
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 | Current assets (USD) | Current obligations (USD) | Cash and equivalents (USD) | Short-term securities (USD) | Customer receivables (USD) | Inventory (USD) | Payables (USD) | Borrowing debt due within one year (USD) | Current ratio |
|---|---|---|---|---|---|---|---|---|---|
| 2026-06-30 | $7.00B | $9.63B | $293.50M | (m) | $3.57B | $2.53B | $2.83B | $1.50B | 0.73× |
| 2026-03-31 | $6.50B | $7.53B | $216.90M | (m) | $3.19B | $2.47B | $2.60B | $100.00K | 0.86× |
| 2025-12-31 | $6.01B | $6.92B | $207.20M | (m) | $2.79B | $2.32B | $2.35B | $350.10M | 0.87× |
| 2025-09-30 | $6.15B | $7.47B | $241.50M | (m) | $3.12B | $2.28B | $2.44B | $350.50M | 0.82× |
| 2025-06-30 | $6.43B | $8.20B | $269.80M | (m) | $3.11B | $2.48B | $2.57B | $1.15B | 0.78× |
| 2025-03-31 | $6.04B | $7.88B | $199.80M | (m) | $2.81B | $2.52B | $2.51B | $1.15B | 0.77× |
| 2024-12-31 | $5.40B | $6.81B | $210.40M | (m) | $2.39B | $2.29B | $2.25B | $1.05B | 0.79× |
| 2024-09-30 | $5.97B | $7.22B | $238.20M | (m) | $2.97B | $2.27B | $2.54B | $1.05B | 0.83× |
| 2024-06-30 | $6.05B | $7.47B | $200.00M | (m) | $3.05B | $2.29B | $2.49B | $849.70M | 0.81× |
| 2024-03-31 | $5.84B | $7.48B | $179.90M | (m) | $2.81B | $2.38B | $2.45B | $1.35B | 0.78× |
| 2023-12-31 | $5.51B | $6.63B | $276.80M | (m) | $2.47B | $2.33B | $2.31B | $1.10B | 0.83× |
| 2023-09-30 | $6.20B | $6.62B | $503.40M | (m) | $2.94B | $2.24B | $2.42B | $1.10B | 0.94× |
| 2023-06-30 | $6.35B | $6.34B | $209.40M | (m) | $3.12B | $2.44B | $2.49B | $499.50M | 1.00× |
| 2023-03-31 | $6.29B | $6.31B | $151.40M | (m) | $2.91B | $2.71B | $2.51B | $600.00K | 1.00× |
| 2022-12-31 | $5.91B | $5.96B | $198.80M | (m) | $2.56B | $2.63B | $2.44B | $600.00K | 0.99× |
| 2022-09-30 | $6.12B | $6.10B | $130.50M | (m) | $2.90B | $2.55B | $2.81B | $600.00K | 1.00× |
| 2022-06-30 | $6.26B | $7.20B | $312.60M | (m) | $2.98B | $2.41B | $2.99B | $600.00K | 0.87× |
| 2022-03-31 | $6.09B | $6.95B | $401.10M | (m) | $2.78B | $2.33B | $2.86B | $260.70M | 0.88× |
| 2021-12-31 | $5.05B | $5.72B | $165.70M | (m) | $2.35B | $1.93B | $2.40B | $260.60M | 0.88× |
| 2021-09-30 | $5.38B | $6.48B | $313.30M | (m) | $2.60B | $1.82B | $2.68B | $662.10M | 0.83× |
| 2021-06-30 | $5.19B | $6.19B | $219.60M | (m) | $2.59B | $1.80B | $2.50B | $687.10M | 0.84× |
| 2021-03-31 | $5.11B | $5.65B | $314.70M | (m) | $2.41B | $1.85B | $2.22B | $428.50M | 0.90× |
| 2020-12-31 | $4.59B | $4.59B | $226.60M | (m) | $2.08B | $1.80B | $2.12B | $25.10M | 1.00× |
| 2020-09-30 | $5.18B | $4.36B | $619.90M | (m) | $2.45B | $1.67B | $2.06B | $24.10M | 1.19× |
| 2020-06-30 | $4.88B | $4.46B | $188.10M | (m) | $2.47B | $1.79B | $1.85B | $700.00K | 1.09× |
| 2020-03-31 | $4.93B | $5.22B | $238.50M | (m) | $2.29B | $1.95B | $1.96B | $429.50M | 0.94× |
| 2019-12-31 | $4.63B | $4.52B | $161.80M | (m) | $2.09B | $1.89B | $1.88B | $429.80M | 1.02× |
| 2019-09-30 | $4.91B | $4.87B | $189.60M | (m) | $2.48B | $1.82B | $2.03B | $429.60M | 1.01× |
| 2019-06-30 | $5.09B | $6.34B | $145.60M | (m) | $2.66B | $1.89B | $2.07B | $1.44B | 0.80× |
| 2019-03-31 | $4.82B | $5.00B | $94.40M | (m) | $2.34B | $1.99B | $1.89B | $303.90M | 0.96× |
| 2018-12-31 | $4.34B | $4.30B | $155.50M | (m) | $2.02B | $1.82B | $1.80B | $307.20M | 1.01× |
| 2018-09-30 | $4.98B | $4.84B | $181.51M | (m) | $2.58B | $1.80B | $2.17B | $310.56M | 1.03× |
| 2018-06-30 | $4.98B | $4.19B | $154.97M | (m) | $2.63B | $1.82B | $2.05B | $1.18M | 1.19× |
| 2018-03-31 | $4.83B | $4.33B | $158.61M | (m) | $2.33B | $1.94B | $1.98B | $1.18M | 1.12× |
| 2017-12-31 | $4.41B | $3.99B | $204.20M | (m) | $2.10B | $1.74B | $1.79B | $1.20M | 1.11× |
| 2017-09-30 | $4.68B | $4.37B | $207.94M | (m) | $2.43B | $1.70B | $1.83B | $701.42M | 1.07× |
| 2017-06-30 | $4.85B | $4.15B | $210.05M | (m) | $2.38B | $1.85B | $1.78B | $701.10M | 1.17× |
| 2017-03-31 | $3.88B | $2.94B | $1.02B | (m) | $1.36B | $1.25B | $1.22B | $700.79M | 1.32× |
| 2016-12-31 | $3.63B | $2.83B | $889.79M | (m) | $1.23B | $1.07B | $1.03B | $700.48M | 1.28× |
| 2016-09-30 | $3.71B | $2.52B | $702.57M | (m) | $1.46B | $1.11B | $1.22B | $1.68M | 1.47× |
| 2016-06-30 | $3.48B | $2.63B | $402.66M | (m) | $1.47B | $1.15B | $1.29B | $2.18M | 1.33× |
| 2016-03-31 | $2.89B | $2.26B | $70.55M | (m) | $1.29B | $1.15B | $1.15B | $2.18M | 1.28× |
| 2015-12-31 | $2.66B | $2.14B | $205.74M | (m) | $1.11B | $1.02B | $1.16B | $3.15M | 1.24× |
| 2015-09-30 | $2.92B | $2.29B | $91.03M | (m) | $1.41B | $1.05B | $1.22B | $3.18M | 1.27× |
| 2015-06-30 | $3.00B | $3.36B | $75.07M | (m) | $1.45B | $1.13B | $1.25B | $3.18M | 0.89× |
| 2015-03-31 | $2.76B | $3.38B | $64.01M | (m) | $1.23B | $1.16B | $1.17B | $3.14M | 0.82× |
| 2014-12-31 | $2.57B | $2.68B | $40.73M | (m) | $1.13B | $1.03B | $1.04B | $3.27M | 0.96× |
| 2014-09-30 | $3.08B | $2.87B | $261.35M | (m) | $1.41B | $1.05B | $1.27B | $502.28M | 1.07× |
| 2014-06-30 | $3.11B | $2.73B | $267.20M | (m) | $1.40B | $1.09B | $1.24B | $502.13M | 1.14× |
| 2014-03-31 | $2.97B | $2.45B | $366.46M | (m) | $1.17B | $1.10B | $1.13B | $502.22M | 1.21× |
| 2013-12-31 | $3.16B | $2.53B | $744.89M | (m) | $1.10B | $970.82M | $998.48M | $502.95M | 1.25× |
| 2013-09-30 | $3.77B | $2.41B | $1.04B | (m) | $1.35B | $1.02B | $1.12B | $2.39M | 1.57× |
| 2013-06-30 | $3.34B | $1.97B | $741.08M | (m) | $1.30B | $984.84M | $1.12B | $2.63M | 1.70× |
| 2013-03-31 | $3.09B | $1.78B | $613.93M | (m) | $1.13B | $1.01B | $1.02B | $3.39M | 1.73× |
| 2012-12-31 | $3.15B | $1.88B | $862.59M | (m) | $1.03B | $920.32M | $923.00M | $3.69M | 1.68× |
| 2012-09-30 | $2.61B | $2.29B | $55.18M | (m) | $1.26B | $963.70M | $1.03B | $3.94M | 1.14× |
| 2012-06-30 | $2.62B | $2.53B | $46.62M | (m) | $1.24B | $1.03B | $1.10B | $4.25M | 1.04× |
| 2012-03-31 | $2.48B | $2.40B | $25.49M | (m) | $1.14B | $1.02B | $999.68M | $6.91M | 1.03× |
| 2011-12-31 | $2.26B | $2.16B | $32.70M | (m) | $989.87M | $926.81M | $965.15M | $7.82M | 1.05× |
| 2011-09-30 | $2.51B | $2.35B | $46.03M | (m) | $1.17B | $966.76M | $996.73M | $10.08M | 1.07× |
| 2011-06-30 | $2.64B | $2.39B | $71.56M | (m) | $1.18B | $1.07B | $1.02B | $9.51M | 1.10× |
| 2011-03-31 | $2.47B | $2.33B | $53.95M | (m) | $1.01B | $1.06B | $954.22M | $10.02M | 1.06× |
| 2010-12-31 | $2.21B | $2.06B | $58.59M | (m) | $916.66M | $917.70M | $909.65M | $7.88M | 1.07× |
| 2010-09-30 | $2.33B | $2.13B | $64.95M | (m) | $1.07B | $858.99M | $927.62M | $6.31M | 1.09× |
| 2010-06-30 | $2.14B | $1.83B | $48.40M | (m) | $986.33M | $793.83M | $881.14M | $9.27M | 1.17× |
| 2010-03-31 | $1.95B | $1.56B | $91.17M | (m) | $797.82M | $787.32M | $705.31M | $12.18M | 1.25× |
| 2009-12-31 | $1.77B | $1.39B | $69.33M | (m) | $696.05M | $738.49M | $674.77M | $12.27M | 1.27× |
| 2009-09-30 | $1.92B | $1.89B | $32.77M | (m) | $901.20M | $726.49M | $728.42M | $10.56M | 1.02× |
| 2009-06-30 | $1.98B | $1.90B | $49.26M | (m) | $908.66M | $769.99M | $704.75M | $10.52M | 1.04× |
| 2009-03-31 | $1.91B | $1.96B | $42.24M | (m) | $785.64M | $838.82M | $629.97M | $14.99M | 0.97× |
| 2008-12-31 | $1.91B | $1.94B | $26.21M | (m) | $769.99M | $864.20M | $738.09M | $13.57M | 0.99× |
| 2008-09-30 | $2.28B | $2.41B | $40.93M | (m) | $1.07B | $863.46M | $882.31M | $13.46M | 0.94× |
| 2008-06-30 | $2.37B | $2.57B | $45.57M | (m) | $1.09B | $920.64M | (m) | $11.43M | 0.92× |
| 2007-12-31 | $2.07B | $2.14B | $27.32M | (m) | $870.67M | $887.47M | $740.80M | $14.91M | 0.97× |
(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 |