The sherwin-williams company (SHW)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10Mar'10Dec'09Sep'09Jun'09Mar'09
OPERATING ACTIVITIES
Net income

1,617,800

1,541,300

1,393,620

1,171,209

1,103,773

1,108,700

1,860,789

1,823,368

1,738,875

1,727,900

1,077,896

1,148,023

1,206,976

1,132,700

1,127,690

1,115,448

1,087,321

1,053,849

988,575

940,324

881,834

865,887

849,267

785,993

751,833

752,561

704,490

676,477

647,003

631,034

577,534

522,458

473,760

441,860

500,226

495,607

498,198

462,485

454,905

454,855

431,172

435,848

0

0

0

Adjustments to reconcile net income to net operating cash:
Depreciation

263,900

262,100

261,643

263,815

271,309

278,200

334,300

334,168

311,996

285,000

205,901

180,241

173,700

172,000

171,664

172,466

170,718

170,323

170,298

170,155

170,179

169,087

166,831

163,975

161,279

158,763

156,574

155,011

153,225

152,217

151,741

151,912

151,764

151,212

152,481

148,948

144,576

140,347

136,248

138,192

142,406

145,186

0

0

0

Non-cash lease expense

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of intangible assets

312,100

312,800

313,481

316,010

311,851

318,100

327,020

330,654

285,679

206,800

124,654

49,126

25,792

25,404

27,817

25,883

27,114

28,237

27,216

28,432

29,211

29,858

30,169

30,050

28,919

29,031

28,359

28,149

28,050

26,985

26,528

29,528

29,897

29,692

36,453

34,885

34,611

34,964

28,673

26,728

26,237

25,718

0

0

0

Gain (Loss) on Extinguishment of Debt

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of credit facility and debt issuance costs

8,900

9,200

9,899

10,935

11,551

12,100

11,843

10,873

10,065

8,300

24,905

41,008

58,087

63,759

45,308

26,621

8,669

3,096

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation expense

98,700

101,700

100,363

93,484

91,089

82,600

84,286

91,210

87,590

90,300

83,140

76,027

73,665

72,109

72,619

71,712

70,028

72,342

68,760

67,750

66,956

64,735

65,869

63,590

61,956

58,004

57,252

56,380

55,486

54,348

49,445

48,688

47,851

48,176

45,553

44,220

42,857

42,276

31,618

31,513

31,431

23,271

0

0

0

Environmental Remediation Expense

24,600

23,000

159,857

151,554

176,135

176,300

43,905

45,789

15,646

15,400

27,525

24,025

25,422

42,932

33,602

40,047

48,050

31,071

43,700

47,781

37,530

36,046

5,930

-4,695

-3,508

-2,751

-532

-588

1,954

6,736

11,377

13,543

8,853

9,100

7,737

7,017

10,504

7,089

12,867

20,276

20,441

24,705

0

0

0

Defined benefit pension plans net cost

9,800

43,100

79,843

75,302

70,255

36,400

-125

6,778

14,390

18,200

17,547

15,457

13,014

14,851

13,676

12,863

11,696

6,491

915

940

964

990

11,118

14,292

17,467

20,641

20,490

20,429

20,368

20,309

15,260

14,253

13,309

12,326

16,544

17,106

17,653

18,104

19,999

23,811

26,759

31,367

0

0

0

Provisions for qualified exit costs

-

-

-

-

-

14,900

31,187

47,613

51,443

50,500

33,913

14,444

4,768

3,038

3,814

9,701

10,126

9,761

10,837

5,621

11,442

13,578

14,063

13,754

7,424

4,682

-3,066

1,519

2,836

2,734

5,844

1,180

212

534

0

0

0

-

-

-

15,612

21,832

0

0

0

Deferred income taxes

-119,000

-131,100

-188,283

-201,070

-149,451

-143,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net decrease in postretirement liability

-

-

-

-

-

-15,900

-9,482

-9,482

-18,814

-17,900

-20,756

-20,756

-11,424

-12,373

-5,573

-5,573

-5,573

-6,645

-5,284

-3,799

-2,314

-718

6,988

6,403

5,818

5,233

3,666

3,666

3,666

3,666

7,446

6,793

6,793

6,793

5,036

5,227

4,927

4,627

841

1,003

1,003

1,103

0

0

0

Other

-9,500

-15,800

56,267

-619

6,415

13,800

-19,974

8,265

-38,482

-1,100

3,021

-2,871

31,886

-5,334

-10,781

-9,989

-7,255

-3,617

2,951

10,660

9,553

3,021

30,302

25,531

29,632

27,214

11,072

17,426

9,866

18,349

1,580

-8,490

-1,200

-3,137

5,554

16,527

-8,119

-3,330

-17,674

-18,737

2,604

436

0

0

0

Change in working capital accounts - net

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

Change in working capital accounts:
Change in operating lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Costs incurred for environmental-related matters

29,400

26,100

23,732

20,327

18,231

17,700

19,537

16,214

14,497

13,800

14,607

14,521

13,514

15,178

12,669

13,138

14,156

11,995

10,809

10,294

9,167

9,676

9,821

10,602

11,131

12,539

16,811

18,416

26,192

31,689

37,145

42,436

35,827

30,451

23,819

19,676

23,793

30,880

35,261

41,573

42,352

36,986

0

0

0

Costs incurred for qualified exit costs

-

-

-

-

-

21,200

38,070

50,821

52,488

45,400

28,118

11,016

4,395

6,267

10,452

10,310

12,102

11,200

7,978

12,050

12,319

10,882

9,694

5,341

3,762

7,419

8,654

8,625

7,666

4,577

3,465

4,159

5,856

6,181

6,478

23,122

17,158

11,275

28,623

8,445

10,206

12,322

0

0

0

Other

56,200

96,600

76,656

10,657

-83,546

-86,600

-143,439

-79,033

-80,345

-68,300

33,551

32,197

37,634

5,594

25,427

-16,095

-66,129

-43,059

-66,497

-22,953

8,617

-6,652

-27,863

-33,154

-28,346

-16,509

16,233

9,033

-6,084

-12,200

-9,533

-12,714

-1,176

1,641

0

0

0

-

-

-

-

-

-

-

-

Net operating cash

2,412,200

2,321,300

2,173,892

2,122,605

1,866,951

1,943,700

2,056,383

1,876,963

1,692,933

1,884,000

1,600,870

1,384,722

1,602,447

1,308,572

1,511,493

1,608,426

1,440,472

1,447,463

1,102,722

1,098,968

1,109,579

1,081,528

1,187,165

1,113,271

1,091,778

1,083,766

1,096,532

987,849

951,594

887,886

859,114

829,758

734,139

735,812

674,943

578,300

669,242

706,590

721,155

829,218

855,636

859,186

0

0

0

INVESTING ACTIVITIES
Capital expenditures

384,100

328,900

309,641

277,053

260,147

251,000

245,578

240,991

223,574

222,800

209,305

208,554

228,480

239,000

249,451

260,879

243,436

234,340

222,632

221,217

214,084

200,545

194,083

161,424

164,812

166,680

162,623

159,266

155,561

157,112

159,907

154,844

159,633

153,801

145,929

146,638

126,690

125,162

103,888

97,885

94,315

91,328

0

0

0

Acquisitions of businesses, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15,440

0

0

0

Proceeds from sale of assets

6,400

6,900

6,962

26,796

33,848

38,400

46,026

24,423

19,790

47,200

72,417

73,526

72,208

38,434

5,686

5,318

5,611

11,300

11,638

9,910

8,193

1,516

1,290

-832

-2,054

-3,045

-24,040

-21,242

-14,248

-9,677

11,709

15,208

10,197

12,842

15,699

13,839

14,040

8,335

8,682

5,204

5,845

5,599

0

0

0

Decrease (increase) in other investments

33,300

63,300

49,528

71,604

56,950

39,000

52,447

69,567

43,956

61,500

30,540

77,676

115,850

103,182

119,790

101,057

76,063

65,593

95,290

95,019

95,372

111,021

69,544

59,373

92,676

94,739

115,428

163,480

116,708

95,778

62,188

57,063

80,938

92,374

69,943

36,379

65,600

74,961

70,359

49,857

31,443

29,230

0

0

0

Net investing cash

-488,300

-462,600

-424,843

-321,861

-283,249

-251,600

-251,985

-290,153

-9,058,040

-9,047,400

-8,977,768

-9,019,012

-272,148

-303,774

-363,555

-356,618

-313,888

-288,633

-306,284

-307,072

-301,263

-310,050

-250,003

-294,905

-335,374

-338,314

-421,270

-379,711

-364,423

-342,455

-271,868

-282,516

-274,810

-277,769

-263,841

-420,890

-476,411

-489,949

-431,252

-192,981

-122,335

-130,399

0

0

0

FINANCING ACTIVITIES
Net (decrease) increase in short-term borrowings

476,300

122,800

386,533

757,607

508,234

300,900

493,631

609,070

644,840

356,300

-121,388

-245,002

-86,343

-899

10,636

-1,099,544

-1,276,189

-630,226

-6,945

1,107,984

1,332,088

591,423

-232,554

17,116

22,034

31,634

-41,368

-562,439

-612,998

-284,839

-186,902

48,382

5,026

-43,346

161,500

345,575

415,396

357,835

-63,551

-296,584

-521,682

-494,989

0

0

0

Proceeds from long-term debt

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

999,697

13,977

11,998

36,983

40,777

41,320

44,094

20,073

14,798

487,844

488,585

499,800

491,736

0

0

0

Payments of long-term debt

0

-

-

-

-

852,600

1,753,524

2,004,418

1,853,537

1,852,800

951,214

1,203

1,182

1,111

1,150

84

-96

0

500,371

499,909

500,077

500,661

10,082

10,735

11,342

10,932

2,197

2,785

9,017

14,000

29,159

28,615

50,832

49,881

99,921

103,617

163,166

159,422

0

0

0

-

-

-

-

Payments for credit facility and debt issuance costs

0

-

-

-

-

5,200

5,513

4,059

49,506

49,400

52,708

49,140

23,276

65,119

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of cash dividends

438,900

420,800

395,220

371,016

346,672

322,900

322,523

321,707

320,578

319,000

317,235

315,295

313,798

312,082

296,268

280,117

264,772

249,647

240,327

231,678

222,782

215,263

212,804

210,514

208,323

204,978

194,697

183,801

172,321

160,939

158,455

156,101

154,871

153,512

154,389

155,490

156,060

156,424

155,613

158,154

160,286

162,561

0

0

0

Proceeds from stock options exercised

159,700

154,600

127,570

122,808

94,005

90,700

124,094

97,862

123,433

143,600

114,285

122,280

108,876

86,831

82,307

76,278

72,213

89,990

100,897

98,047

88,906

100,069

93,980

88,581

97,684

69,761

107,683

173,566

174,975

221,126

190,449

119,535

112,975

69,536

71,330

77,917

105,909

102,209

81,649

86,734

49,435

36,596

0

0

0

Income tax effect of stock-based compensation exercises and vesting

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

89,691

99,261

95,933

81,393

68,657

62,505

57,126

63,788

47,527

84,031

103,900

108,227

104,858

65,466

41,540

28,293

12,958

14,168

15,602

21,484

19,676

15,823

16,902

9,361

7,645

0

0

0

Treasury stock purchased

1,364,000

778,800

822,743

729,652

677,252

613,300

0

0

0

-

0

0

0

-

-

-

-

1,035,291

1,160,680

1,502,620

1,847,183

1,488,663

1,371,319

1,202,241

944,224

769,271

616,735

427,665

458,410

557,766

471,683

597,261

457,349

367,372

450,861

332,919

440,723

375,677

507,699

656,488

533,824

530,363

0

0

0

Proceeds from treasury stock issued

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-95,400

-129,200

-45,359

-71,231

-12,787

32,200

-63,122

-28,375

-31,911

-39,800

-23,263

-29,248

-28,592

-15,473

-13,001

-20,948

-18,859

-42,384

-42,741

-34,838

-35,453

-24,111

-22,476

-22,021

-20,299

-17,522

-25,626

-12,868

-23,854

-21,559

967

-12,042

-983

15,631

732

722

1,509

-4,371

-11,375

-11,507

-12,485

-10,800

0

0

0

Net financing cash

-1,782,100

-1,846,400

-1,762,887

-1,814,585

-1,667,851

-1,746,700

-1,801,440

-1,606,376

6,546,793

6,514,100

6,918,407

7,467,267

-343,815

-307,353

-544,669

-927,014

-1,115,168

-980,353

-951,972

-965,607

-1,101,634

-1,467,075

-1,692,277

-1,282,215

-1,000,209

-853,308

308,680

85,759

3,378

286,578

-575,340

-572,564

-480,758

-475,209

-416,121

-108,116

-217,770

-223,568

-259,848

-637,972

-690,333

-682,830

0

0

0

Effect of exchange rate changes on cash

2,300

-6,000

21,980

4,453

19,949

5,900

-29,404

-35,530

-40,901

-36,300

-36,141

-25,584

-39,224

-13,396

8,271

2,794

-4,881

-13,465

-14,783

-18,419

-9,134

-8,560

-19,252

-10,037

-3,660

-9,845

-3,410

571

-2,112

-2,115

-2,751

375

-7,025

-8,723

-13,903

-26,132

-12,287

-3,817

2,123

877

5,960

-2,840

0

0

0

Net increase (decrease) in cash and cash equivalents

144,100

6,300

8,142

-9,388

-64,200

-48,700

-26,446

-55,096

-859,215

-685,600

-494,632

-192,607

947,260

684,049

611,540

327,588

6,535

165,012

-170,317

-192,130

-302,452

-704,157

-774,367

-473,886

-247,465

-117,701

980,532

694,468

588,437

829,894

9,155

-24,947

-28,454

-25,889

-18,922

23,162

-37,226

-10,744

32,178

-858

48,928

43,117

0

0

0

Income taxes paid

409,700

407,500

365,720

320,851

280,390

292,200

252,791

393,766

438,935

419,700

566,618

525,265

463,306

477,786

413,944

363,436

342,230

335,119

372,447

321,364

313,055

310,039

212,762

200,076

200,769

200,748

220,588

160,286

157,777

223,329

257,489

250,904

253,282

196,147

144,624

156,447

150,783

137,872

173,184

143,886

142,237

146,385

0

0

0

Interest paid

360,900

336,100

369,115

363,396

368,143

368,000

377,558

373,849

247,516

220,600

127,256

119,083

154,139

153,850

130,022

89,993

69,815

48,644

57,243

58,647

66,328

67,306

65,461

63,996

62,814

61,045

51,340

51,594

41,163

41,551

41,067

51,852

42,474

42,897

55,684

49,873

75,410

78,747

57,928

57,727

35,451

41,106

0

0

0