Pentair plc (PNR)
CashFlow / Quarterly
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'10
Operating activities
Net income

72,700

97,800

92,300

114,300

51,300

92,900

110,100

41,500

102,900

189,600

125,400

263,700

87,800

131,000

141,000

142,800

107,400

-453,300

115,200

147,800

113,900

120,800

-186,000

161,500

118,600

159,700

174,200

155,400

53,300

-274,700

32,600

74,500

63,000

-175,425

52,054

68,137

52,034

-

-

-

-

Loss from discontinued operations, net of tax

0

-5,100

1,000

-800

-1,100

-1,300

18,900

-36,400

44,500

151,500

78,200

134,500

7,100

294,800

22,900

10,100

15,600

-555,400

94,200

-1,300

-4,300

241,400

1,600

2,300

-1,300

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Discontinued Operation, Provision for Loss (Gain) on Disposal, Net of Tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

380,100

0

5,600

-

-

-

-

-

-

-

-

-

-

-

-

1,040

-549

-593

-524

Loss on sale of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

147

Net income from continuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

91,800

-

21,000

153,900

118,200

-

192,500

159,200

125,500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

36,553

Adjustments to reconcile net income from continuing operations to net cash provided by (used for) operating activities of continuing operations
Equity loss (income) of unconsolidated subsidiaries

-500

500

500

1,900

600

1,300

1,300

5,200

600

400

300

400

200

1,600

1,200

1,100

400

200

200

600

500

300

300

300

300

300

600

900

200

0

600

-300

2,000

419

574

672

235

302

347

1,375

84

Depreciation

11,600

11,900

12,000

12,400

12,000

12,800

12,000

12,300

12,600

12,400

13,100

3,900

21,400

-11,300

20,800

22,600

20,900

21,400

-7,000

34,400

32,400

-24,200

34,600

34,500

34,800

32,400

35,200

35,600

38,100

36,600

15,900

16,700

16,000

17,121

16,394

17,461

15,224

14,854

14,265

14,312

14,564

Amortization

7,600

7,600

7,600

8,300

8,200

7,900

8,600

9,100

9,300

9,200

9,200

-6,000

24,000

-37,200

24,100

24,300

24,200

24,300

-11,800

28,000

27,600

-25,300

28,400

29,000

28,500

27,400

26,000

38,900

41,800

45,500

9,700

9,700

10,000

12,093

12,627

10,779

6,401

6,442

6,385

6,611

6,746

Deferred income taxes

14,000

-700

-8,100

-7,900

-1,700

0

-14,200

20,000

-9,900

-15,000

5,100

-3,400

-4,700

5,000

22,500

-12,700

-13,600

-1,400

-5,800

-800

5,700

-29,700

-3,000

11,100

-1,400

31,200

5,500

15,300

2,000

-

-

-

-

-10,045

1,433

-833

3,845

24,587

2,470

779

1,617

Gain (Loss) on Disposition of Business

0

-1,100

-100

-100

3,500

-900

-200

-900

-5,300

-400

-3,800

0

0

-

-

-

-

-

-

-

-

-

-

-

-

4,000

100

0

16,700

-

-

-

-

-

-

-

-

-

-

-

-

Share-based Payment Arrangement, Noncash Expense

6,200

6,100

4,600

5,300

5,400

4,500

5,100

5,300

6,000

7,400

6,200

9,600

16,400

5,500

6,400

6,200

16,100

5,500

8,100

9,700

9,700

8,800

8,300

9,100

7,400

5,800

7,200

7,700

10,400

7,300

18,400

5,100

5,000

4,805

4,168

4,802

5,725

4,870

4,233

5,563

6,802

Asset impairment

0

3,000

0

2,900

15,300

6,000

0

6,000

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-800

5,600

2,700

500

0

1,400

1,800

2,800

2,600

2,200

1,700

6,100

9,400

1,200

6,200

0

2,900

400

700

1,000

163

1,672

908

557

493

3,515

-342

-980

Pension and other post-retirement expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

107,936

-22,783

-2,472

1,619

49,295

-2,254

-12,517

-426

Gain on sale of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,600

2,300

-

-600

7,100

1,200

-

-1,000

100

-300

-

-2,700

-1,200

0

-900

200

2,100

1,000

-198

-473

-222

-7

-

-

-

-

Changes in assets and liabilities, net of effects of business acquisitions
Accounts receivable

167,100

100,300

-50,600

-186,200

154,000

88,800

-20,800

-198,900

146,200

80,300

-17,100

-180,400

130,600

75,200

-13,700

-175,600

97,500

53,300

-44,400

-88,500

85,800

56,200

-31,200

-117,200

76,900

66,200

-14,900

-74,400

129,400

-3,900

-32,800

-94,500

100,000

21,357

-23,768

-100,394

101,505

26,128

2,778

-65,616

99,054

Inventories

20,100

-9,600

-900

-25,300

22,200

3,800

20,900

7,000

8,400

4,500

12,500

-5,100

8,600

-19,900

-5,100

-18,300

9,400

-87,400

-64,900

9,400

88,200

-69,300

12,000

-8,000

34,500

-48,100

12,400

6,700

-29,100

-108,900

-11,700

-7,700

20,000

-2,667

-13,208

-3,133

708

-5,327

11,171

33,126

5,525

Other current assets

13,400

7,900

-8,300

-3,700

22,500

-42,200

200

16,400

-5,600

100

13,300

-18,400

18,000

-64,600

-5,500

25,400

42,600

-9,000

700

-35,400

71,000

-11,000

-12,100

16,700

32,200

-4,500

8,900

-20,400

21,700

-4,300

3,500

4,000

-3,000

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

23,684

-6,250

8,946

-

3,353

949

-2,826

Accounts payable

-49,900

65,200

-5,700

-4,900

-118,200

118,400

-14,200

13,800

-59,700

76,600

-20,800

15,700

-55,900

79,700

-25,400

-30,200

-1,300

56,200

-2,200

16,800

-60,200

39,700

-25,100

26,400

-35,700

24,400

-18,400

14,200

20,900

-23,100

-26,400

-300

-4,000

21,459

-22,881

-10,886

-11,992

-4,841

13,224

24,459

22,479

Employee compensation and benefits

-800

0

3,400

-3,600

-18,900

24,800

6,800

-2,100

-30,100

15,900

8,300

-1,700

-23,900

31,900

6,900

4,700

-16,800

-9,200

34,800

-7,500

-33,700

10,200

22,800

14,600

-49,300

27,800

31,900

32,300

-25,700

-77,000

3,800

5,300

-24,000

-8,166

10,341

6,084

-28,759

5,652

10,325

9,581

1,694

Accrued product claims and warranties

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,786

2,018

883

-

-2,640

5,549

3,647

Income taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,265

-1,726

14,506

-

-859

15,426

3,446

Other current liabilities

-22,300

-21,700

-7,200

36,800

-8,300

-31,000

24,200

43,100

-39,600

-300

-13,400

-56,700

15,800

76,700

-37,100

29,400

21,300

-42,400

-4,500

-8,500

38,800

-35,000

2,700

59,300

33,400

29,400

9,000

-6,100

8,900

30,500

7,100

16,600

15,000

-54,924

21,443

17,233

8,248

-16,288

14,450

2,627

-1,584

Other non-current assets and liabilities

1,400

1,100

-9,600

-1,400

500

30,000

-1,100

1,900

-3,300

-21,600

-11,300

21,300

5,100

78,700

15,100

4,700

7,600

-34,300

-8,400

9,700

15,200

-98,800

19,800

19,900

6,200

-62,600

9,900

9,300

-9,100

-9,900

20,600

-7,800

28,000

-5,441

-1,154

18,225

3,970

5,496

4,202

-2,811

2,363

Net cash used for operating activities of continuing operations

-162,400

79,100

166,900

356,300

-257,100

158,900

121,400

371,800

-194,000

131,000

62,700

173,600

-88,700

-79,800

138,800

338,600

-17,700

243,200

159,400

321,300

-126,200

-12,200

271,000

429,900

-12,700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities of discontinued operations

0

9,200

1,100

-3,300

800

-4,400

-8,700

-32,300

26,400

127,400

143,800

87,700

-17,300

384,400

48,500

45,900

2,700

100,200

51,000

-2,600

-7,000

337,200

-2,100

-17,900

15,200

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used for operating activities

-162,400

88,300

168,000

353,000

-256,300

154,500

112,700

339,500

-167,600

258,400

206,500

261,300

-106,000

304,600

187,300

384,500

-15,000

343,400

210,400

318,700

-133,200

325,000

268,900

412,000

2,500

293,900

247,900

366,200

19,900

-203,700

80,600

234,800

-68,000

79,641

87,948

200,791

-48,180

21,133

92,829

166,727

-10,313

Investing activities
Capital expenditures

18,700

13,900

14,800

13,000

16,800

14,400

13,500

8,800

11,500

13,700

6,700

-4,900

23,600

-51,200

30,500

31,200

32,800

25,000

-500

32,000

34,800

-8,800

32,900

32,400

27,200

43,700

38,300

38,300

49,700

44,600

18,600

15,300

16,000

20,237

17,842

21,953

13,268

16,542

14,044

16,878

12,059

Payments for (Proceeds from) Productive Assets

-

-

-

-

-

-

-100

500

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of property and equipment

100

-

-

-

300

-

-

-

-

-

-

-

0

-5,300

16,500

2,200

5,400

1,000

-19,500

20,800

2,300

-2,200

1,400

2,300

400

2,300

100

2,700

900

400

200

2,900

2,000

1,161

50

47

42

18

97

116

127

Proceeds from the sale of businesses, net

0

-

-

-

700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

900

0

30,000

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from (payments due to) sale of businesses

-

-

-

-

-

0

0

-1,000

13,800

4,600

1,600

-2,765,600

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments to Acquire Businesses, Net of Cash Acquired

7,200

3,300

0

-2,700

287,200

0

0

0

900

0

0

-10,800

56,700

25,000

0

-100

100

900

1,814,000

96,000

3,000

12,300

0

0

0

-

-

-

-

-

-

-

-

-5

0

718,249

14,856

-

-

-

0

Other

0

-

0

0

1,500

-

0

0

0

-

-

-

-

-

100

3,500

200

-

-

-

-

700

-600

-800

500

-2,500

200

900

-300

2,800

0

100

3,000

2,559

560

-61

-58

-84

-54

1,578

-292

Net cash (used for) provided by investing activities of continuing operations

-

-

-

-

-

-13,800

-13,400

-8,300

-26,200

-17,800

-5,100

2,781,300

-80,300

19,600

-14,100

-32,400

-27,700

-27,900

-1,832,500

-107,700

-35,500

-6,400

-30,900

-29,300

-27,300

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used for investing activities of discontinued operations

-

-

-

-

-

0

0

-2,100

-5,000

-6,400

-6,100

-31,500

-3,700

-62,900

3,700

-3,700

-4,300

-7,000

-13,900

4,100

54,900

-34,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used for investing activities

-25,800

-2,400

-14,800

-10,200

-304,500

-13,800

-13,400

-10,400

-31,200

-24,200

-11,200

2,749,800

-84,000

-43,300

-10,400

-36,100

-32,000

-34,900

-1,846,400

-103,600

19,400

-40,800

-30,900

-29,300

-27,300

-34,300

-37,500

-120,900

-18,500

-248,300

673,300

-32,400

-17,000

-21,630

-18,352

-740,094

-28,024

-16,440

-13,893

-18,340

-11,640

Financing activities
Net repayments of short-term borrowings

-

-

-

-

-

-

-

-

-

-

-300

-400

-100

-

0

-700

700

-300

-1,700

-300

0

200

-3,600

3,600

300

0

0

-2,900

2,900

0

-200

-18,500

15,000

-25,972

8,254

15,358

1,160

-

-

-

-

Net receipts of commercial paper and revolving long-term debt

420,900

-39,700

58,300

-551,200

584,100

-6,300

15,800

-387,300

417,500

-70,800

133,200

-1,204,600

229,100

-94,200

-151,300

-278,200

138,400

87,000

13,100

-142,600

406,000

42,400

227,400

-183,100

381,900

-18,300

-167,100

150,000

139,600

-

-

-

-

-

-

-

-

-

-

-

-

Net short-term borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,411

1,526

Proceeds from long-term debt

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

504,200

55,300

-67,200

102,000

-855,123

49,466

1,071,591

249,366

209,820

158,800

135,021

200,000

Repayment of long-term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

700

352,000

300

3,900

400

3,600

300

12,000

900

1,200

400

4,100

1,700

426,400

46,100

131,700

13,000

-771,493

110,371

511,422

150,000

180,706

220,265

262,717

141,025

Debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

0

0

100

1,300

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,600

2,700

500

0

1,400

1,800

2,800

2,600

2,200

1,700

6,100

9,400

1,200

6,200

0

2,900

400

700

1,000

163

1,672

908

557

493

871

342

980

Shares issued to employees, net of shares withheld

5,200

5,700

-400

1,300

5,900

-2,700

9,700

5,400

900

2,900

4,800

26,700

2,800

600

11,800

9,900

-1,600

-2,500

4,600

8,600

8,700

6,700

-1,200

7,500

24,000

9,200

30,700

28,300

11,800

46,200

5,700

9,300

7,000

1,512

2,237

9,588

-37

2,080

7,044

-1,121

1,938

Payments for Repurchase of Common Stock

115,200

0

0

150,000

0

100,000

100,000

150,000

150,000

100,000

0

100,000

0

-

-

-

-

0

0

0

200,000

300,000

399,300

198,500

252,200

175,500

56,700

343,300

140,300

-

-

-

-

15

12,498

0

287

-

-

-

-

Dividends paid

32,100

30,300

30,400

31,000

31,000

30,500

30,800

62,600

63,300

62,800

62,800

63,300

62,800

62,000

61,900

59,600

60,100

58,400

57,700

58,100

57,500

55,200

57,100

49,900

49,200

50,300

49,900

46,800

47,200

46,300

21,800

22,300

22,000

19,831

19,930

19,895

19,844

18,881

18,884

18,863

18,837

Purchase of noncontrolling interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

134,700

0

0

0

2,000

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by (Used in) Financing Activities, Continuing Operations

-

-

-

-

-

-

-

-

205,100

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by financing activities

278,800

-114,900

-124,600

-336,600

559,000

-139,500

-107,300

-1,158,900

997,800

-230,700

-275,100

-3,095,800

169,000

-155,600

-195,800

-325,900

77,200

-326,200

1,647,400

-194,500

159,600

-307,800

-231,900

-430,700

-24,700

-226,000

-242,200

-212,700

-38,200

39,100

-173,300

-188,100

90,000

-53,300

-81,422

557,407

80,915

-13,014

-71,726

-146,557

40,706

Cash Provided by (Used in) Financing Activities, Discontinued Operations

-

-

-

-

-

-

-

-

792,700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in cash held for sale

-

-

-

-

-

0

0

-836,700

809,700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash and cash equivalents

-3,800

-1,700

4,100

-4,600

6,400

8,400

-6,000

1,000

-4,800

1,300

10,500

24,400

20,600

-38,100

16,500

-7,300

1,600

-900

-13,800

-4,400

-25,100

-22,600

-14,000

8,600

-2,600

3,200

21,800

6,000

-10,000

-

-

-

-

-7,320

-4,481

-6,266

6,367

-2,618

11,205

-10,033

-5,366

Change in cash and cash equivalents

86,800

-30,700

32,700

1,600

4,600

9,600

-14,000

7,900

-15,500

5,000

-60,400

-74,800

-400

68,700

-2,400

15,200

31,800

-18,600

-2,400

16,200

20,700

-46,200

-7,900

-39,400

-52,100

36,800

-10,000

38,600

-46,800

-405,200

582,000

5,500

5,000

-2,609

-16,307

11,838

11,078

-10,939

18,415

-8,203

13,387