Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Cash Flow Statement
Quarterly Data

The cash flow statement provides information about a company cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on the company balance sheet.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Sherwin-Williams Co., consolidated cash flow statement (quarterly data)

US$ in thousands

Microsoft Excel
3 months ended: 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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net income 806,200 889,900 505,200 356,200 761,500 793,700 477,400 386,300 685,100 577,900 370,800 304,000 502,200 648,600 409,600 407,000 705,800 595,900 321,700 248,622 576,438 471,003 245,237
Depreciation 74,400 71,800 71,100 74,300 71,900 75,700 70,400 69,200 64,500 64,800 65,500 63,300 63,400 71,000 65,400 68,000 67,400 66,100 66,500 67,143 65,209 65,032 64,716
Non-cash lease expense 121,500 113,200 116,600 119,300 108,400 116,000 109,000 106,400 102,100 98,500 109,900 105,700 100,500 97,000 97,500 105,200 94,300 88,000 93,800 95,100 92,100 92,900 90,700
Amortization of intangible assets 81,200 81,500 82,100 80,000 83,500 83,000 83,700 79,300 81,300 78,500 78,000 76,300 76,200 77,800 79,200 79,200 78,700 77,400 78,100 78,400 77,548 78,081 78,771
(Gain) loss on divestiture of business (20,100) 111,900
Impairment 23,900 34,000 15,500 2,300 122,100
(Gain) loss on extinguishment of debt 12,800 (1,400) 21,300 46 14,754
Stock-based compensation expense 27,900 30,100 24,600 43,100 26,800 23,500 22,500 19,700 26,300 26,900 26,800 32,800 25,900 25,500 13,500 23,000 26,500 26,300 20,100 30,805 23,235 24,592 23,068
Amortization of non-traded investments 13,600 22,300 20,100 5,100 20,600 20,300 19,400 6,800 10,300 10,800 10,600
(Gain) loss on sale or disposition of assets (2,000) (19,800) (3,400) 9,000 12,700 (16,200) (4,600) 800 (13,700) 300 1,900
Provisions for environmental-related matters, net 2,800 (14,100) 3,600 28,000 39,400 600 12,700 (18,200) 6,400 4,100 600 (9,500) 500 2,500 2,500 16,300 10,100 8,500 2,200 5,126 10,602 6,680 592
Provisions for restructuring 14,400 900 47,300
Other postretirement benefit plan net cost (6,100) (6,000) (6,100) (2,300) (4,500) (4,500) (4,500) (1,600)
Deferred income taxes (10,600) (22,200) (16,400) 200 (62,000) (24,400) (2,700) (36,000) (84,600) (12,600) (11,600) (56,000) (5,100) 6,800 (26,000) (147,400) (3,800) (3,600) 9,500 (87,701) (13,184) (27,610) (2,605)
Other 3,700 9,100 1,700 (5,100) 800 3,800 7,500 6,500 22,100 7,300 8,000 5,200 15,600 24,400 9,100 76,000 2,300 100 4,900 133,396 (21,485) 14,228 34,761
Change in working capital accounts, net 123,200 166,400 (682,100) 372,600 433,700 295,100 (534,200) 105,700 (150,100) (169,900) (498,200) (132,700) 172,100 156,900 (495,000) 285,200 566,000 176,300 (430,100) 100,736 171,191 77,634 (495,961)
Change in operating lease liabilities (122,200) (113,400) (117,800) (118,200) (108,800) (116,800) (109,600) (92,500) (103,400) (99,000) (110,400) (104,200) (100,500) (98,700) (98,000) (100,800) (95,600) (85,900) (89,100) (96,100) (90,800) (100,900) (80,600)
Costs incurred for environmental-related matters (11,700) (4,700) (6,700) (11,200) (11,700) (8,000) (4,400) (4,500) (7,300) (7,000) (5,000) (7,300) (12,700) (11,900) (9,400) (14,800) (10,200) (6,100) (7,900) (6,077) (8,923) (6,525) (4,575)
Adjustments to reconcile net income to net operating cash 295,700 314,200 (512,700) 631,500 610,800 476,400 (333,900) 304,400 (46,100) 2,700 (323,900) (27,800) 335,900 351,300 (249,300) 392,200 735,700 347,100 (230,700) 442,974 320,247 224,112 (291,133)
Other (27,200) (1,200) (51,400) (69,100) (63,600) (63,700) (55,300) (49,700) 200 32,800 (20,600) (82,300) 11,300 5,700 35,400 45,600 47,700 76,700 (36,100) (31,703) 6,721 98,836 9,946
Net operating cash 1,074,700 1,202,900 (58,900) 918,600 1,308,700 1,206,400 88,200 641,000 639,200 613,400 26,300 193,900 849,400 1,005,600 195,700 844,800 1,489,200 1,019,700 54,900 659,893 903,406 793,951 (35,950)
Capital expenditures (235,300) (250,900) (283,800) (319,500) (152,900) (206,100) (209,900) (233,800) (174,900) (129,500) (106,300) (123,900) (96,700) (87,100) (64,300) (110,000) (51,500) (35,700) (106,600) (104,075) (96,946) (76,519) (51,360)
Acquisition of business, net of cash acquired (241,500) (22,900) (300) (376,300) (415,000) (211,400) (400) (185,600) (400) (24,900) (4,664) (72,636)
Proceeds from divestiture of businesses 70,700 33,000 6,300 116,200
Proceeds from sale of assets 9,300 21,100 1,800 47,200 18,300 4,100 10,800 1,700 12,200 900 21,900 14,000 22,500 2,300 (16) 4,166 2,750
Other (93,400) (19,200) (37,500) 9,600 (10,700) (35,700) (23,200) 53,000 (5,000) 58,500 (99,700) 59,800 (65,500) 9,200 (34,300) (57,700) 7,700 (35,700) 6,400 (65,324) 54,139 (28,520) (23,595)
Net investing cash (328,700) (260,800) (321,300) (530,300) (91,100) (184,500) (233,400) (557,100) (576,600) (278,300) (195,600) (249,700) (154,200) (66,100) (6,400) (145,800) (29,800) (48,900) (97,900) (174,079) (111,277) (105,039) (72,205)
Net increase (decrease) in short-term borrowings (443,300) 102,200 882,500 35,300 (467,600) (674,600) 503,000 29,900 (1,064,000) 276,300 972,200 56,000 (54,000) (56,100) 818,000 (100) (559,500) (494,700) 849,700 (231,822) (371,670) (15,528) 496,220
Proceeds from long-term debt 848,700 999,700 994,800 999,000 (10) 1,332,810
Payments of long-term debt (600,000) (500,000) (135,800) (600) (100) (260,200) (398,300) (24,600) (433,500) (771,200) (112) (1,514,825) (360,824) (39)
Payments for credit facility and debt issuance costs (8,600) (7,300) (9,800) (1,700) (10,000) (631) (12,969)
Payments of cash dividends (182,500) (178,600) (182,500) (155,300) (155,600) (156,300) (156,500) (155,600) (155,800) (156,200) (150,900) (144,200) (145,200) (145,900) (151,800) (120,200) (122,200) (122,700) (122,900) (105,941) (105,102) (104,995) (104,762)
Proceeds from stock options exercised 102,300 14,300 78,200 45,400 30,900 23,900 11,400 28,400 12,600 14,700 11,600 71,500 53,100 29,800 38,400 47,000 58,100 47,600 30,000 43,445 45,628 40,663 24,864
Treasury stock purchased (448,700) (434,400) (545,500) (486,000) (410,100) (234,200) (301,700) (132,100) (47,600) (296,400) (407,100) (675,800) (431,000) (870,100) (775,400) (1,151,600) (404,400) (890,300) (201,023) (127,270) (145,361) (305,146)
Proceeds from treasury stock issued 22,000 11,700 125,000 57,400
Proceeds from real estate financing transactions 50,400 84,500 77,000 78,900 87,400 73,700 66,500 207,300 (748) (788) (752) 9,488
Other (36,800) (5,400) (20,100) (22,000) 100 (200) (24,600) 3,300 6,900 (1,900) (32,100) 9,500 (10,700) 1,800 (24,000) (4,000) (2,100) 1,500 (26,000) (7,885) (2,889) (49,172) (69,254)
Net financing cash (718,500) (917,400) 289,600 (639,500) (915,500) (967,700) 98,100 (18,800) (255,600) (423,700) 415,700 (96,300) (612,400) (1,030,500) (94,800) (1,103,900) (1,030,100) (1,001,800) 115,700 (504,727) (757,075) (635,969) 51,371
Effect of exchange rate changes on cash 10,700 (4,600) (6,300) 24,600 (8,100) 3,800 (300) 3,200 10,900 100 (11,000) 4,500 10,900 (4,100) (6,400) 11,600 2,500 (19,400) 4,000 (8,927) 9,014 (1,759) (4,328)
Net increase (decrease) in cash and cash equivalents 38,200 20,100 (96,900) (226,600) 294,000 58,000 (47,400) 68,300 (182,100) (88,500) 235,400 (147,600) 93,700 (95,100) 88,100 (393,300) 431,800 (50,400) 76,700 (27,840) 44,068 51,184 (61,112)

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

Cash flow statement item Description The company
Net operating cash Amount of cash inflow (outflow) from operating activities, excluding discontinued operations. Operating activity cash flows include transactions, adjustments, and changes in value not defined as investing or financing activities. Sherwin-Williams Co. net operating cash increased from Q1 2024 to Q2 2024 but then slightly decreased from Q2 2024 to Q3 2024.
Net investing cash Amount of cash inflow (outflow) of investing activities, excluding discontinued operations. Investing activity cash flows include making and collecting loans and acquiring and disposing of debt or equity instruments and property, plant, and equipment and other productive assets. Sherwin-Williams Co. net investing cash increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.
Net financing cash Amount of cash inflow (outflow) of financing activities, excluding discontinued operations. Financing activity cash flows include obtaining resources from owners and providing them with a return on, and a return of, their investment; borrowing money and repaying amounts borrowed, or settling the obligation; and obtaining and paying for other resources obtained from creditors on long-term credit. Sherwin-Williams Co. net financing cash decreased from Q1 2024 to Q2 2024 but then slightly increased from Q2 2024 to Q3 2024.