Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Common-Size Balance Sheet: Assets 
Quarterly Data

Sherwin-Williams Co., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Mar 31, 2025 Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020
Cash and cash equivalents 0.81 0.89 0.99 0.84 0.77 1.21 2.19 0.90 0.65 0.88 0.59 1.42 1.85 0.80 1.51 1.07 1.54 1.11 2.98 0.92 1.16
Accounts receivable, net 11.42 10.11 12.41 12.84 11.99 10.75 12.78 13.46 12.58 11.35 13.03 13.52 12.81 11.38 12.53 12.63 11.81 10.19 11.79 12.06 11.14
Inventories 10.21 9.68 9.46 9.64 10.15 10.15 9.76 10.53 11.71 11.62 11.45 10.94 10.72 9.33 8.76 8.79 9.04 8.84 8.04 8.73 9.50
Other current assets 2.08 2.17 2.07 2.16 2.03 1.91 2.22 2.52 2.27 2.30 2.43 2.51 2.64 2.94 3.14 2.78 2.61 2.37 2.06 2.12 2.15
Current assets 24.52% 22.85% 24.93% 25.49% 24.94% 24.02% 26.95% 27.41% 27.21% 26.15% 27.50% 28.38% 28.01% 24.45% 25.94% 25.27% 25.00% 22.51% 24.87% 23.83% 23.96%
Property, plant and equipment, net 14.87 14.95 13.95 13.22 12.84 12.36 11.22 10.54 10.21 9.77 9.18 8.90 8.78 9.04 8.81 8.80 8.71 8.99 8.55 8.78 8.89
Goodwill 31.29 32.07 31.95 32.05 32.53 33.22 32.22 32.14 32.19 33.56 32.90 32.22 32.48 34.52 33.74 34.20 34.31 34.55 33.67 34.04 33.83
Intangible assets 14.18 14.95 15.26 15.56 16.12 16.91 16.62 16.98 17.74 17.71 17.79 17.93 18.43 19.36 19.62 20.30 20.60 21.92 21.62 22.12 22.29
Operating lease right-of-use assets 8.01 8.27 7.89 7.97 8.02 8.22 8.15 8.07 8.02 8.26 8.33 8.35 8.46 8.81 8.56 8.60 8.46 8.63 8.35 8.28 8.18
Other assets 7.14 6.90 6.03 5.71 5.55 5.27 4.84 4.85 4.63 4.55 4.31 4.21 3.85 3.82 3.33 2.83 2.91 3.40 2.94 2.95 2.85
Long-term assets 75.48% 77.15% 75.07% 74.51% 75.06% 75.98% 73.05% 72.59% 72.79% 73.85% 72.50% 71.62% 71.99% 75.55% 74.06% 74.73% 75.00% 77.49% 75.13% 76.17% 76.04%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).


Cash and cash equivalents
The proportion of cash and cash equivalents relative to total assets exhibits fluctuations without a clear long-term upward or downward trend. It ranged from a low near 0.59% to a high reaching 2.98% in early periods, with recent values mostly below 1%, signaling relatively stable but low liquidity reserves as a percentage of total assets.
Accounts receivable, net
This item shows moderate volatility, generally fluctuating between approximately 10% and 13% of total assets. There are intermittent peaks around mid-2022 and mid-2023, but no sustained directional trend. This indicates a relatively consistent level of receivables relative to the asset base over time with some seasonal or operational variation.
Inventories
Inventories as a percentage of total assets have increased from under 9.5% in early 2020 to a peak exceeding 11.7% by late 2022, followed by a slight decline and stabilization near 10% in later periods. This suggests an incremental buildup of inventory levels relative to total assets, possibly reflecting changes in supply chain management or demand conditions.
Other current assets
Other current assets have remained fairly stable, typically between 2.0% and 3.1% of total assets, without substantial upward or downward shifts. This stability indicates that other current asset categories are a consistent, though smaller, component of total assets.
Current assets
The aggregate share of current assets shows some variability, generally oscillating between 22% and 28% of total assets. Notably, the percentage rose to above 28% in 2021-2022, then retreated to the mid-20% range thereafter. This pattern suggests moderate fluctuations in liquidity and working capital over the analyzed periods.
Property, plant and equipment, net
An expanding trend is evident in property, plant and equipment, rising steadily from below 9% of total assets in 2020 to nearly 15% by 2025. This growth implies increased investment in tangible fixed assets, reflecting possible capacity expansion or capital improvements.
Goodwill
The proportion of goodwill remains significant, generally around one-third of total assets, but it shows a slight declining tendency from over 34% in early periods to approximately 31% by 2025. This gradual decrease could indicate amortization effects, impairments, or disposal of intangible assets acquired through acquisitions.
Intangible assets
Intangible assets as a share of total assets demonstrate a clear downward trend, decreasing from above 22% in early 2020 to near 14% by 2025. The steady reduction suggests systematic amortization or impairment expenses impacting this asset category over time.
Operating lease right-of-use assets
This asset category remains relatively stable, fluctuating modestly between approximately 7.9% and 8.8%. Stability in right-of-use assets indicates consistent leasing commitments with little change in lease-related capitalized assets.
Other assets
Other assets have shown a progressive increase from under 3% in early 2020 to over 7% by 2025. This upward movement points to growing asset components not otherwise classified, which may reflect investments, deferred charges, or other long-term asset accumulation.
Long-term assets
Complementing the prior observations, long-term assets as a percentage of total assets were generally dominant, fluctuating but mostly holding between approximately 70% and 77%. After decreasing slightly in the 2021-2022 timeframe, long-term assets increased again toward the latter periods, reinforcing a substantial focus on non-current asset investment.