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
Sep 30, 2025 Jun 30, 2025 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.92 1.06 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.91 12.27 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 8.69 9.80 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 1.93 2.20 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 23.45% 25.33% 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.93 15.01 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 29.74 30.78 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 13.23 13.97 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 7.59 7.93 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 11.06 6.98 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 76.55% 74.67% 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% 100.00% 100.00%

Based on: 10-Q (reporting date: 2025-09-30), 10-Q (reporting date: 2025-06-30), 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 percentage of cash and cash equivalents relative to total assets fluctuated moderately throughout the observed periods, generally remaining under 2%. There was a spike to nearly 3% in September 2020, followed by a gradual decrease and minor oscillations. A notable increase occurred again in September 2023, reaching above 2%, but in 2024 and early 2025 the values mostly stayed below 1.1%, indicating relatively low liquidity holdings compared to total assets.
Accounts receivable, net
Accounts receivable as a percentage of total assets showed some variability but overall remained between approximately 10% and 13.5%. Peaks were observed in mid-2022 and mid-2023, with a slight decline towards the early quarters of 2024 and 2025. This pattern suggests a general stability in receivables with some seasonal or cyclical influences affecting the amount outstanding.
Inventories
Inventory levels relative to total assets exhibited a gradual increasing trend from early 2020 through late 2022, rising from about 8% to nearly 12%. After this peak, inventory levels showed some decline and fluctuation but maintained a higher percentage compared to the earlier periods. This trend indicates increased investment in inventory assets over time with some normalization in the most recent quarters.
Other current assets
This category remained relatively stable as a portion of total assets throughout the period, mostly oscillating between 2% and 3%. Minor increases and decreases were evident but without significant long-term trend changes, suggesting steady proportionality in other current asset holdings.
Current assets
The total current assets as a percentage of total assets saw a modest upward trend from around 24% in early 2020 to approximately 28% by 2021 mid-year. Following that, it slightly declined and hovered near 25% in most subsequent periods with a downturn toward the end of 2024 and into 2025. This indicates moderate variation in liquidity and short-term financial resources over the examined timeframe.
Property, plant and equipment, net
There was a clear upward trend in net property, plant, and equipment relative to total assets, rising steadily from below 9% to nearly 15% by late 2024. This increase suggests ongoing capital investment and asset base expansion focused on tangible fixed assets.
Goodwill
Goodwill's share of total assets displayed a generally declining trend from above 34% in early periods down to under 30% by late 2025. This steady decrease may reflect impairment charges, divestitures, or changes in acquisition activity affecting the intangible asset base.
Intangible assets
Intangible assets as a percentage of total assets showed a consistent decrease over time, moving from over 22% in early 2020 to near 13% in late 2025. This mirrors the trend observed in goodwill, indicating a decline in intangible asset valuation or accounting adjustments reducing their relative proportion.
Operating lease right-of-use assets
The proportion of operating lease right-of-use assets remained relatively stable, fluctuating slightly around the 8% mark. There was a minor downward drift in later periods but overall this asset class maintained a consistent share of the company's asset base.
Other assets
Other assets showed a progressive increase as a percentage of total assets, starting near 2.9% and rising continuously to exceed 11% by late 2025. This significant growth implies accumulation or reclassification of miscellaneous assets, contributing increasingly to the overall asset composition.
Long-term assets
Long-term assets consistently composed about three-quarters of total assets throughout the time frame. Although there were minor fluctuations, the share remained broadly stable, underscoring a strong emphasis on long-term investments and fixed asset holdings.