The Sherwin-Williams Company (SHW) quarterly balance sheet — complete assets, liabilities & equity history
| 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 |
| 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 |
| 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 |
| Short-Term Investments | 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Goodwill | 8B | 8.04B | 7.79B | 7.81B | 7.71B | 7.58B | 7.66B | 7.61B | 7.62B | 7.63B | 7.41B | 7.45B |
| 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 |
| Long-Term Investments | 0 | 0 | 1.08B | 1.11B | 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 |
| 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 |
| 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 |
| 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% |
| 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 |
| 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 |
| 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 |
| 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 |
| Deferred Revenue (Current) | 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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% |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |