Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Financial Reporting Quality: Aggregate Accruals 

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Sherwin-Williams Co., balance sheet computation of aggregate accruals

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Operating Assets
Total assets 23,632,600 22,954,400 22,594,000 20,666,700 20,401,600
Less: Cash and cash equivalents 210,400 276,800 198,800 165,700 226,600
Operating assets 23,422,200 22,677,600 22,395,200 20,501,000 20,175,000
Operating Liabilities
Total liabilities 19,581,400 19,238,600 19,491,900 18,229,500 16,790,800
Less: Short-term borrowings 662,400 374,200 978,100 763,500 100
Less: Current portion of long-term debt 1,049,200 1,098,800 600 260,600 25,100
Less: Current portion of finance lease liabilities 3,700
Less: Long-term debt, excluding current portion 8,176,800 8,377,900 9,591,000 8,590,900 8,266,900
Less: Long-term finance lease liabilities, excluding current portion 185,600
Operating liabilities 9,503,700 9,387,700 8,922,200 8,614,500 8,498,700
 
Net operating assets1 13,918,500 13,289,900 13,473,000 11,886,500 11,676,300
Balance-sheet-based aggregate accruals2 628,600 (183,100) 1,586,500 210,200
Financial Ratio
Balance-sheet-based accruals ratio3 4.62% -1.37% 12.51% 1.78%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Linde plc 0.83% 3.59% -5.37% -8.63%
Balance-Sheet-Based Accruals Ratio, Sector
Chemicals 1.57% 2.62% -2.04% -6.91%
Balance-Sheet-Based Accruals Ratio, Industry
Materials 3.19% 5.47% 1.53% -5.48%

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Net operating assets = Operating assets – Operating liabilities
= 23,422,2009,503,700 = 13,918,500

2 2024 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2024 – Net operating assets2023
= 13,918,50013,289,900 = 628,600

3 2024 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 628,600 ÷ [(13,918,500 + 13,289,900) ÷ 2] = 4.62%

4 Click competitor name to see calculations.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Sherwin-Williams Co. deteriorated earnings quality from 2023 to 2024.

Cash-Flow-Statement-Based Accruals Ratio

Sherwin-Williams Co., cash flow statement computation of aggregate accruals

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Net income 2,681,400 2,388,800 2,020,100 1,864,400 2,030,400
Less: Net operating cash 3,153,200 3,521,900 1,919,900 2,244,600 3,408,600
Less: Net investing cash (1,196,300) (1,039,300) (1,607,600) (476,400) (322,400)
Cash-flow-statement-based aggregate accruals 724,500 (93,800) 1,707,800 96,200 (1,055,800)
Financial Ratio
Cash-flow-statement-based accruals ratio1 5.33% -0.70% 13.47% 0.82%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Linde plc 3.18% 2.84% -2.93% -4.85%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Chemicals 3.59% 2.15% 0.12% -3.92%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Materials 2.23% 3.08% 1.97% -4.42%

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 724,500 ÷ [(13,918,500 + 13,289,900) ÷ 2] = 5.33%

2 Click competitor name to see calculations.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Sherwin-Williams Co. deteriorated earnings quality from 2023 to 2024.