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, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Operating Assets
Total assets 22,954,400 22,594,000 20,666,700 20,401,600 20,496,200
Less: Cash and cash equivalents 276,800 198,800 165,700 226,600 161,800
Operating assets 22,677,600 22,395,200 20,501,000 20,175,000 20,334,400
Operating Liabilities
Total liabilities 19,238,600 19,491,900 18,229,500 16,790,800 16,372,900
Less: Short-term borrowings 374,200 978,100 763,500 100 204,700
Less: Current portion of long-term debt 1,098,800 600 260,600 25,100 429,800
Less: Long-term debt, excluding current portion 8,377,900 9,591,000 8,590,900 8,266,900 8,050,700
Operating liabilities 9,387,700 8,922,200 8,614,500 8,498,700 7,687,700
 
Net operating assets1 13,289,900 13,473,000 11,886,500 11,676,300 12,646,700
Balance-sheet-based aggregate accruals2 (183,100) 1,586,500 210,200 (970,400)
Financial Ratio
Balance-sheet-based accruals ratio3 -1.37% 12.51% 1.78% -7.98%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Linde plc 3.59% -5.37% -8.63% -1.19%
Balance-Sheet-Based Accruals Ratio, Sector
Chemicals 2.62% -2.04% -6.91% -2.30%
Balance-Sheet-Based Accruals Ratio, Industry
Materials 5.47% 1.53% -5.48% -2.26%

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

1 2023 Calculation
Net operating assets = Operating assets – Operating liabilities
= 22,677,6009,387,700 = 13,289,900

2 2023 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2023 – Net operating assets2022
= 13,289,90013,473,000 = -183,100

3 2023 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × -183,100 ÷ [(13,289,900 + 13,473,000) ÷ 2] = -1.37%

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. improved earnings quality from 2022 to 2023.

Cash-Flow-Statement-Based Accruals Ratio

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

US$ in thousands

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

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

1 2023 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × -93,800 ÷ [(13,289,900 + 13,473,000) ÷ 2] = -0.70%

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. improved earnings quality from 2022 to 2023.