The Sherwin-Williams Company (SHW) quarterly balance sheet — complete assets, liabilities & equity history
| Metric | Q1'26 | Q4'25 | Q3'25 | Q2'25 | Q1'25 | Q4'24 | Q3'24 | Q2'24 | Q1'24 | Q4'23 | Q3'23 | Q2'23 | Q1'23 | Q4'22 | Q3'22 | Q2'22 | Q1'22 | Q4'21 | Q3'21 | Q2'21 |
|---|
| Total Current Assets | 6.5B | 6.01B | 6.15B | 6.43B | 6.04B | 5.4B | 5.97B | 6.05B | 5.84B | 5.51B | 6.2B | 6.35B | 6.29B | 5.91B | 6.12B | 6.26B | 6.09B | 5.05B | 5.38B | 5.19B |
| Cash & Short-Term Investments | 216.9M | 207.2M | 241.5M | 269.8M | 199.8M | 210.4M | 238.2M | 200M | 179.9M | 276.8M | 503.4M | 209.4M | 151.4M | 198.8M | 130.5M | 312.6M | 401.1M | 165.7M | 313.3M | 219.6M |
| Cash Only | 216.9M | 207.2M | 241.5M | 269.8M | 199.8M | 210.4M | 238.2M | 200M | 179.9M | 276.8M | 503.4M | 209.4M | 151.4M | 198.8M | 130.5M | 312.6M | 401.1M | 165.7M | 313.3M | 219.6M |
| Short-Term Investments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Receivable | 3.19B | 2.79B | 3.12B | 3.11B | 2.81B | 2.39B | 2.97B | 3.05B | 2.81B | 2.47B | 2.94B | 3.12B | 2.91B | 2.56B | 2.9B | 2.98B | 2.78B | 2.35B | 2.6B | 2.59B |
| Days Sales Outstanding | 47.51 | 48.61 | 45.1 | 42.69 | 44.12 | 46.56 | 44.95 | 42.49 | 44.73 | 47.37 | 45.56 | 43.94 | 45.25 | 48.03 | 44.73 | 44.68 | 46.24 | 47.82 | 46.37 | 42.33 |
| Inventory | 2.47B | 2.32B | 2.28B | 2.48B | 2.52B | 2.29B | 2.27B | 2.29B | 2.38B | 2.33B | 2.24B | 2.44B | 2.71B | 2.63B | 2.55B | 2.41B | 2.33B | 1.93B | 1.82B | 1.8B |
| Days Inventory Outstanding | 74.7 | 73.83 | 67.75 | 71.18 | 78.7 | 76.93 | 66.86 | 66.19 | 75.52 | 77.83 | 67.31 | 69.52 | 79.45 | 79.43 | 65.97 | 63 | 65.01 | 59.74 | 55.38 | 55.97 |
| Other Current Assets | 617.5M | 690.8M | 506M | 559M | 511.6M | 513.5M | 495.3M | 513.4M | 475.4M | 438.4M | 510.2M | 584.4M | 524.4M | 518.8M | 541.3M | 552.8M | 573.1M | 608.4M | 651.1M | 571.4M |
| Total Non-Current Assets | 19.88B | 18.14B | 20.06B | 18.94B | 18.6B | 18.23B | 17.99B | 17.68B | 17.59B | 17.44B | 16.81B | 16.82B | 16.84B | 16.69B | 16.13B | 15.79B | 15.64B | 15.61B | 15.36B | 15.33B |
| Property, Plant & Equipment | 6.21B | 4.14B | 7.49B | 5.82B | 5.64B | 5.49B | 5.23B | 5.03B | 4.89B | 4.72B | 4.46B | 4.31B | 4.22B | 4.07B | 3.89B | 3.8B | 3.75B | 3.69B | 3.6B | 3.57B |
| Fixed Asset Turnover | 1.09x | 0.96x | 0.96x | 1.10x | 0.95x | 0.99x | 1.20x | 1.27x | 1.12x | 1.14x | 1.40x | 1.46x | 1.31x | 1.31x | 1.57x | 1.56x | 1.34x | 1.31x | 1.44x | 1.52x |
| Goodwill | 8B | 8.04B | 7.79B | 7.81B | 7.71B | 7.58B | 7.66B | 7.61B | 7.62B | 7.63B | 7.41B | 7.45B | 7.45B | 7.58B | 7.32B | 7.11B | 7.06B | 7.13B | 7B | 7.02B |
| Intangible Assets | 3.89B | 3.97B | 3.47B | 3.54B | 3.49B | 3.53B | 3.66B | 3.69B | 3.78B | 3.88B | 3.82B | 3.93B | 4.1B | 4B | 3.96B | 3.96B | 4B | 4B | 4.07B | 4.17B |
| Long-Term Investments | 0 | 0 | 1.08B | 1.11B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Non-Current Assets | 1.78B | 2B | 231.6M | 660.7M | 1.76B | 1.63B | 1.45B | 1.36B | 1.3B | 1.21B | 1.11B | 1.12B | 1.07B | 1.03B | 957.9M | 927.8M | 836M | 789M | 691.5M | 580.1M |
| Total Assets | 26.38B | 25.9B | 26.21B | 25.36B | 24.64B | 23.63B | 23.97B | 23.73B | 23.43B | 22.95B | 23B | 23.17B | 23.13B | 22.59B | 22.25B | 22.05B | 21.73B | 20.67B | 20.74B | 20.52B |
| Asset Turnover | 0.22x | 0.21x | 0.25x | 0.25x | 0.22x | 0.22x | 0.26x | 0.27x | 0.23x | 0.23x | 0.26x | 0.27x | 0.24x | 0.23x | 0.27x | 0.27x | 0.24x | 0.23x | 0.25x | 0.26x |
| Asset Growth % | 7.07% | 9.6% | 9.34% | 6.87% | 5.16% | 2.95% | 4.19% | 2.45% | 1.29% | 1.6% | 3.41% | 5.05% | 6.44% | 9.33% | 7.28% | 7.47% | 6.34% | 1.3% | -0.35% | 0.12% |
| Total Current Liabilities | 7.53B | 6.92B | 7.47B | 8.2B | 7.88B | 6.81B | 7.22B | 7.47B | 7.48B | 6.63B | 6.62B | 6.34B | 6.31B | 5.96B | 6.1B | 7.2B | 6.95B | 5.72B | 6.48B | 6.19B |
| Accounts Payable | 2.6B | 2.35B | 2.44B | 2.57B | 2.51B | 2.25B | 2.54B | 2.49B | 2.45B | 2.31B | 2.42B | 2.49B | 2.51B | 2.44B | 2.81B | 2.99B | 2.86B | 2.4B | 2.68B | 2.5B |
| Days Payables Outstanding | 77.29 | 77.07 | 71.31 | 72.36 | 78.09 | 80.9 | 73.83 | 70.17 | 76.5 | 80.65 | 70.63 | 67.59 | 73.72 | 80.51 | 77.17 | 77.8 | 80.41 | 81.05 | 79.21 | 72.35 |
| Short-Term Debt | 2.38B | 2.03B | 2.2B | 2.86B | 2.95B | 1.71B | 1.96B | 2.21B | 2.61B | 1.47B | 1.44B | 1.31B | 1.48B | 978.7M | 945.8M | 2.01B | 2B | 1.02B | 1.37B | 1.45B |
| Deferred Revenue (Current) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Current Liabilities | 271.7M | 1.7B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Current Ratio | 0.86x | 0.87x | 0.82x | 0.78x | 0.77x | 0.79x | 0.83x | 0.81x | 0.78x | 0.83x | 0.94x | 1.00x | 1.00x | 0.99x | 1.00x | 0.87x | 0.88x | 0.88x | 0.83x | 0.84x |
| Quick Ratio | 0.53x | 0.53x | 0.52x | 0.48x | 0.45x | 0.46x | 0.51x | 0.50x | 0.46x | 0.48x | 0.60x | 0.62x | 0.57x | 0.55x | 0.59x | 0.53x | 0.54x | 0.55x | 0.55x | 0.55x |
| Cash Conversion Cycle | 44.92 | 45.38 | 41.54 | 41.51 | 44.73 | 42.59 | 37.98 | 38.51 | 43.75 | 44.55 | 42.24 | 45.88 | 50.97 | 46.95 | 33.53 | 29.88 | 30.84 | 26.51 | 22.54 | 25.95 |
| Total Non-Current Liabilities | 14.41B | 14.38B | 14.31B | 12.77B | 12.63B | 12.77B | 12.59B | 12.52B | 12.44B | 12.61B | 12.6B | 13.2B | 13.66B | 13.53B | 13.55B | 12.63B | 12.54B | 12.51B | 11.57B | 11.49B |
| Long-Term Debt | 9.32B | 10.91B | 9.32B | 7.83B | 7.83B | 8.18B | 8.18B | 8.13B | 8.13B | 8.38B | 8.5B | 9.1B | 9.59B | 9.59B | 9.59B | 8.59B | 8.59B | 8.59B | 7.6B | 7.6B |
| Capital Lease Obligations | 1.6B | 1.59B | 1.58B | 1.6B | 1.57B | 1.56B | 1.5B | 1.5B | 1.5B | 1.51B | 1.5B | 1.5B | 1.49B | 1.51B | 1.49B | 1.48B | 1.48B | 1.47B | 1.43B | 1.43B |
| Deferred Tax Liabilities | 765.4M | 765.3M | 657.2M | 560.9M | 586M | 607.5M | 631.7M | 642M | 666.3M | 683.1M | 648.4M | 710.9M | 739.9M | 681.6M | 691.8M | 754M | 760.2M | 768.2M | 801.5M | 803.4M |
| Other Non-Current Liabilities | 2.72B | 1.11B | 2.75B | 2.77B | 2.64B | 2.43B | 2.29B | 2.24B | 2.15B | 2.04B | 1.95B | 1.89B | 1.83B | 1.75B | 1.78B | 1.8B | 1.71B | 1.68B | 1.73B | 1.65B |
| Total Liabilities | 21.95B | 21.3B | 21.78B | 20.96B | 20.51B | 19.58B | 19.81B | 19.98B | 19.92B | 19.24B | 19.22B | 19.54B | 19.96B | 19.49B | 19.65B | 19.83B | 19.5B | 18.23B | 18.05B | 17.68B |
| Total Debt | 13.79B | 14.53B | 13.58B | 12.77B | 12.82B | 11.91B | 12.1B | 12.3B | 12.68B | 11.81B | 11.88B | 12.34B | 13B | 12.51B | 12.45B | 12.51B | 12.49B | 11.5B | 10.81B | 10.88B |
| Net Debt | 13.57B | 14.33B | 13.34B | 12.5B | 12.62B | 11.7B | 11.86B | 12.1B | 12.5B | 11.53B | 11.38B | 12.13B | 12.85B | 12.31B | 12.31B | 12.19B | 12.09B | 11.33B | 10.5B | 10.66B |
| Debt / Equity | 3.11x | 3.16x | 3.07x | 2.90x | 3.10x | 2.94x | 2.91x | 3.28x | 3.62x | 3.18x | 3.14x | 3.40x | 4.11x | 4.03x | 4.79x | 5.62x | 5.59x | 4.72x | 4.02x | 3.83x |
| Debt / EBITDA | 13.82x | 16.57x | 10.14x | 10.12x | 14.01x | 14.26x | 9.40x | 8.88x | 14.43x | 14.25x | 9.38x | 9.74x | 15.00x | 16.42x | 11.12x | 12.63x | 17.58x | 22.43x | 12.97x | 10.44x |
| Net Debt / EBITDA | 13.60x | 16.34x | 9.96x | 9.91x | 13.79x | 14.01x | 9.22x | 8.74x | 14.23x | 13.91x | 8.99x | 9.57x | 14.82x | 16.16x | 11.01x | 12.31x | 17.02x | 22.10x | 12.59x | 10.23x |
| Interest Coverage | 6.16x | 5.86x | 10.05x | 9.77x | 7.03x | 6.94x | 10.53x | 11.15x | 6.99x | 6.01x | 10.18x | 9.72x | 6.40x | 5.41x | 9.38x | 8.68x | 6.02x | 4.50x | 8.11x | 10.50x |
| Total Equity | 4.43B | 4.6B | 4.43B | 4.4B | 4.13B | 4.05B | 4.16B | 3.75B | 3.5B | 3.72B | 3.78B | 3.63B | 3.17B | 3.1B | 2.6B | 2.22B | 2.23B | 2.44B | 2.69B | 2.84B |
| Equity Growth % | 7.29% | 13.5% | 6.48% | 17.3% | 17.88% | 9.03% | 9.95% | 3.32% | 10.64% | 19.78% | 45.51% | 63.22% | 41.74% | 27.28% | -3.44% | -21.68% | -27.43% | -32.5% | -36.06% | -26.6% |
| Book Value per Share | 17.86 | 18.48 | 17.77 | 17.47 | 16.36 | 15.94 | 16.37 | 14.76 | 13.70 | 14.46 | 14.71 | 14.03 | 12.19 | 11.91 | 9.95 | 8.50 | 8.49 | 9.21 | 10.09 | 10.61 |
| Total Shareholders' Equity | 4.43B | 4.6B | 4.43B | 4.4B | 4.13B | 4.05B | 4.16B | 3.75B | 3.5B | 3.72B | 3.78B | 3.63B | 3.17B | 3.1B | 2.6B | 2.22B | 2.23B | 2.44B | 2.69B | 2.84B |
| Common Stock | 83.2M | 83.1M | 92.9M | 92.7M | 92.6M | 92.5M | 92.4M | 92.1M | 92M | 91.8M | 91.7M | 91.4M | 91.3M | 91.2M | 91.1M | 91M | 91M | 90.8M | 90.5M | 90.6M |
| Retained Earnings | 1.37B | 1.03B | 8.74B | 8.11B | 7.55B | 7.25B | 6.95B | 6.32B | 5.61B | 5.29B | 5.09B | 4.48B | 3.84B | 3.52B | 3.29B | 2.76B | 2.34B | 2.12B | 1.96B | 1.6B |
| Treasury Stock | -707.8M | -84.3M | -8.55B | -7.88B | -7.36B | -6.99B | -6.68B | -6.23B | -5.79B | -5.23B | -4.75B | -4.34B | -4.1B | -3.78B | -3.64B | -3.6B | -3.3B | -2.87B | -2.26B | -1.76B |
| Accumulated OCI | -586.8M | -634.4M | -590.1M | -597.9M | -772.9M | -875.2M | -676.2M | -776.9M | -705M | -624.3M | -756.4M | -651.3M | -665.8M | -700.6M | -1.06B | -914.6M | -742M | -698.4M | -786.7M | -701.2M |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |