Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

This company has been moved to the archive! The financial data has not been updated since July 27, 2022.

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: 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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Net income 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 100,988 354,027 403,604 250,127 897,393 316,606 319,111 239,152
Loss from discontinued operations 41,540
Depreciation 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 66,655 67,381 72,542 71,591 122,783 67,249 50,370 44,595
Non-cash lease expense 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 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 79,093 80,077 73,893 85,049 87,965 83,711 28,906 6,182
Loss on divestiture of business 111,900
(Gain) loss on extinguishment of debt (1,400) 21,300 46 14,754
Amortization of credit facility and debt issuance costs 1,600 1,700 1,500 1,700 1,700 1,500 1,700 1,700 1,900 1,900 1,889 2,963 2,172 2,176 2,621 3,999 2,764 2,749 2,344 3,029 1,956 984
Amortization of inventory purchase accounting adjustments (59,101) 77,747 36,278
Stock-based compensation expense 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 29,456 16,356 22,165 14,611 31,146 23,280 18,545 17,321
Provisions for environmental-related matters 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 141,980 2,299 31,253 765 9,631 4,183 1,110 519
Defined benefit pension plans net cost 1,400 1,400 1,100 1,800 1,600 2,300 1,800 2,000 1,900 1,900 2,736 2,330 2,812 35,222 39,450 (2,211) (2,213) 1,345 2,907 4,692 5,399 5,155
Impairment of trademarks 2,300 122,100 2,022
Deferred income taxes (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) (144,862) (25,971) 24,004 3,451 (606,135) 6,968 (6,968)
Other 15,400 17,400 2,600 12,100 21,100 5,300 72,500 (1,400) (3,700) 1,100 128,771 (26,778) 9,244 (2,637) 37,433 32,124 (3,868) 4,810 79,727 20,311 37,389 (32,613)
Change in working capital accounts, net (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) 211,309 390,075 (88,833) (382,842) 181,549 75,982 (181,093) (58,402)
Change in operating lease liabilities (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 (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) (3,727) (5,518) (4,404) (4,069) (5,538) (2,195) (2,687) (3,372)
Adjustments to reconcile net income to net operating cash 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) 459,408 558,611 127,303 (202,540) (150,700) 364,957 30,745 (19,631)
Other 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 (47,911) (60,519) 7,440 (6,838) (121,557) (8,864) 4,461 12,295
Net operating cash 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) 512,485 852,119 538,347 40,749 625,136 672,699 354,317 231,816
Capital expenditures (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) (84,773) (64,358) (59,573) (42,253) (79,361) (59,771) (42,156) (41,479)
Acquisitions of businesses, net of cash acquired (211,400) (400) (185,600) (400) (24,900) (4,664) (72,636) (1) (4,032) (8,806,282)
Proceeds from divestiture of business 6,300 116,200
Proceeds from sale of assets 4,100 10,800 1,700 12,200 900 21,900 14,000 22,500 2,300 (16) 4,166 2,750 24,000 7,002 7,352 7,718 2,397 2,369 34,762
Other 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) (51,589) 32,063 (13,861) (5,650) (65,025) 14,943 11,750 (23,194)
Net investing cash (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) (136,362) (8,295) (66,432) (40,551) (136,669) (46,463) (8,834,319) (29,911)
Net increase (decrease) in short-term borrowings 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 (324,331) (596) (264,881) 288,866 470,262 114,843 (229,111) 326
Proceeds from long-term debt (260,200) 994,800 999,000 (10) 1,332,810 5,239 285,555 7,984,375
Payments of long-term debt (398,300) (24,600) (433,500) (771,200) (112) (1,514,825) (360,824) (39) (650) (700,183) (150,986) (808) (901,559) (951,077) (105) (71)
Payments for credit facility and debt issuance costs (9,800) (1,700) (10,000) (631) (12,969) (50) (5,022) (113) (354) (3,568) (45,447) (7)
Payments of cash dividends (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) (80,395) (80,898) (80,613) (81,028) (80,013) (80,082) (79,484) (79,450)
Proceeds from stock options exercised 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 16,460 40,866 11,824 21,595 49,788 14,634 37,395 41,762
Treasury stock purchased (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) (244,978) (34,179) (93,007) (241,148)
Proceeds from treasury stock issued 22,000 11,700 125,000 57,400
Proceeds from real estate financing transactions (748) (788) (752) 9,488 136,764 88,581
Other (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) 76,013 (28,761) (182) (14,813) (19,327) 5,986 (3,718) (22,702)
Net financing cash (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 (421,167) (808,773) (489,264) (27,449) (475,964) (613,709) 7,663,905 (60,142)
Effect of exchange rate changes on cash 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) 19,038 (8,513) 13,709 (18,349) (16,227) (14,639) 8,338 (13,748)
Net increase (decrease) in cash and cash equivalents (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) (26,006) 26,538 (3,640) (45,600) (3,724) (2,112) (807,759) 128,015

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-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 decreased from Q4 2021 to Q1 2022 but then increased from Q1 2022 to Q2 2022 exceeding Q4 2021 level.
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 Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.
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 increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.