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
Dec 31, 2025 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
Cash and cash equivalents 0.80 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
Accounts receivable, net 10.78 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
Inventories 8.95 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
Other current assets 2.67 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
Current assets 23.19% 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%
Property, plant and equipment, net 15.97 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
Goodwill 31.03 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
Intangible assets 15.31 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
Operating lease right-of-use assets 7.70 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
Other assets 6.79 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
Long-term assets 76.81% 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%
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%

Based on: 10-K (reporting date: 2025-12-31), 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).


The composition of assets at the company exhibits several notable trends over the observed period from March 2021 to December 2025. Current assets, while consistently representing approximately 25% of total assets for much of the period, demonstrate some fluctuation. Long-term assets consistently comprise the majority of the asset base, generally around 75% of total assets, with a noticeable increase towards the end of the period.

Cash and Cash Equivalents
The proportion of cash and cash equivalents to total assets is variable. It decreased from 1.54% in March 2021 to a low of 0.59% in September 2022, before increasing to 2.19% in September 2023. It then decreased again to 0.80% in December 2025, suggesting a dynamic approach to cash management. The fluctuations may be linked to operational needs, investment activities, or financing decisions.
Accounts Receivable
Accounts receivable, net, consistently represents a significant portion of current assets, ranging between approximately 10.75% and 13.52% of total assets. A slight downward trend is observed from 2021 to 2023, followed by a recovery towards 12.27% in June 2025 and 10.78% in December 2025. This suggests potential changes in credit policies or collection efficiency.
Inventories
The percentage of inventories to total assets generally remains between 8.69% and 11.71% throughout the period. There is a general increase from 2021 to 2022, followed by a slight decrease in 2023 and a stabilization around 9-10% in 2024 and 2025. This indicates relatively stable inventory management practices.
Property, Plant, and Equipment
The proportion of property, plant, and equipment, net, to total assets demonstrates a clear upward trend, increasing from 8.71% in March 2021 to 15.97% in December 2025. This suggests significant investment in fixed assets, potentially indicating expansion or modernization efforts.
Goodwill and Intangible Assets
Goodwill and intangible assets together constitute a substantial portion of the asset base. Goodwill shows a slight decreasing trend from 34.31% to 29.74% over the period, while intangible assets also decrease from 20.60% to 13.23%. This suggests potential impairment or amortization of these assets, or a shift in the company’s acquisition strategy.
Operating Lease Right-of-Use Assets
Operating lease right-of-use assets remain relatively stable, fluctuating between approximately 7.70% and 8.60% of total assets. A slight decrease is observed towards the end of the period, potentially reflecting changes in leasing arrangements.
Other Assets
The proportion of other assets to total assets exhibits a notable increase, rising from 2.91% in March 2021 to 11.06% in September 2025, before decreasing to 6.79% in December 2025. This significant fluctuation warrants further investigation to understand the composition of these “other” assets and the reasons for the change.

Overall, the asset composition indicates a shift towards a greater proportion of long-term assets, particularly property, plant, and equipment, alongside a decrease in goodwill and intangible assets. The fluctuations in current asset components suggest active management of working capital. The increase in “other assets” in 2025 requires further scrutiny.

AI Ask an analyst for more