Nielsen holdings plc (NLSN)
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'11
Operating Activities
Net income/(loss)

-463,000

-403,000

-1,244,000

-678,000

-728,000

-700,000

333,000

385,000

442,000

440,000

516,000

498,000

479,000

507,000

601,000

611,000

613,000

575,000

479,000

429,000

389,000

381,000

368,000

407,000

757,000

736,000

627,000

602,000

281,000

272,000

332,000

329,000

293,000

87,000

0

0

0

Adjustments to reconcile net income/(loss) to net cash provided by operating activities:
Share-based compensation expense

51,000

50,000

53,000

41,000

37,000

35,000

31,000

38,000

43,000

45,000

49,000

52,000

53,000

51,000

46,000

47,000

47,000

48,000

50,000

50,000

49,000

47,000

51,000

50,000

49,000

47,000

42,000

41,000

36,000

34,000

33,000

31,000

31,000

27,000

0

0

0

Gain on sale of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

290,000

0

0

0

-

-

-

-

-

-

-

-

Currency exchange rate differences on financial transactions and other (gains)/losses

-187,000

-178,000

0

0

0

-

-

-

-

-

-

-

-

32,000

192,000

195,000

192,000

167,000

-69,000

-127,000

-170,000

-174,000

-145,000

-87,000

-40,000

-40,000

-163,000

-168,000

-156,000

-141,000

8,000

4,000

-5,000

-213,000

0

0

0

Loss on derivative instruments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Equity in net income/(loss) of affiliates, net of dividends received

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,000

1,000

-1,000

1,000

-2,000

2,000

1,000

0

-3,000

-3,000

-5,000

-6,000

-7,000

0

0

0

Depreciation and amortization

791,000

756,000

721,000

710,000

687,000

675,000

667,000

652,000

652,000

640,000

630,000

621,000

611,000

603,000

592,000

585,000

579,000

574,000

580,000

575,000

574,000

573,000

571,000

549,000

534,000

521,000

507,000

520,000

517,000

520,000

521,000

516,000

524,000

529,000

0

0

0

Changes in operating assets and liabilities, net of effect of businesses acquired and divested:
Trade and other receivables, net

-12,000

-4,000

-86,000

-86,000

-90,000

-95,000

23,000

-20,000

47,000

-10,000

-30,000

3,000

3,000

-53,000

59,000

102,000

79,000

35,000

52,000

42,000

67,000

93,000

70,000

66,000

90,000

84,000

49,000

65,000

37,000

13,000

20,000

13,000

77,000

71,000

0

0

0

Prepaid expenses and other assets

-101,000

-64,000

-3,000

-28,000

3,000

76,000

90,000

95,000

86,000

28,000

-18,000

-7,000

16,000

-4,000

20,000

48,000

52,000

63,000

60,000

87,000

84,000

76,000

23,000

-5,000

-4,000

-21,000

25,000

23,000

24,000

18,000

38,000

28,000

37,000

37,000

0

0

0

Accounts payable and other current liabilities and deferred revenues

-18,000

20,000

-12,000

45,000

-28,000

21,000

26,000

-41,000

7,000

-41,000

-46,000

-21,000

-10,000

50,000

43,000

-23,000

-45,000

-36,000

-15,000

24,000

37,000

4,000

86,000

102,000

57,000

55,000

48,000

58,000

128,000

190,000

154,000

196,000

104,000

32,000

0

0

0

Other non-current liabilities

-94,000

-95,000

-48,000

-55,000

-25,000

-6,000

5,000

8,000

1,000

2,000

-6,000

-6,000

-2,000

-8,000

-9,000

-5,000

-8,000

-2,000

0

-2,000

-6,000

-2,000

-8,000

-6,000

0

-6,000

-12,000

-12,000

-12,000

-10,000

-2,000

-5,000

-5,000

-2,000

0

0

0

Interest payable

11,000

11,000

0

0

0

-

-

-

11,000

22,000

21,000

27,000

20,000

14,000

10,000

8,000

8,000

15,000

21,000

10,000

20,000

6,000

23,000

16,000

29,000

13,000

19,000

22,000

25,000

29,000

21,000

19,000

15,000

31,000

0

0

0

Income taxes

-520,000

-489,000

-366,000

101,000

119,000

126,000

-71,000

-56,000

0

-6,000

14,000

18,000

40,000

64,000

11,000

10,000

17,000

11,000

-7,000

-2,000

-15,000

-23,000

136,000

94,000

68,000

63,000

-45,000

-7,000

-19,000

-31,000

184,000

156,000

165,000

14,000

0

0

0

Net cash (used in)/provided by operating activities

1,104,000

1,066,000

1,142,000

1,116,000

1,132,000

1,058,000

1,018,000

1,169,000

1,153,000

1,310,000

1,347,000

1,265,000

1,249,000

1,296,000

1,154,000

1,152,000

1,195,000

1,209,000

1,209,000

1,147,000

1,104,000

1,093,000

1,012,000

941,000

937,000

901,000

921,000

931,000

841,000

784,000

746,000

684,000

690,000

641,000

0

0

0

Investing Activities
Acquisition of subsidiaries and affiliates, net of cash acquired

29,000

61,000

66,000

73,000

100,000

43,000

222,000

227,000

208,000

778,000

617,000

614,000

810,000

285,000

311,000

301,000

102,000

246,000

309,000

319,000

321,000

314,000

250,000

1,422,000

1,422,000

1,249,000

1,226,000

105,000

155,000

160,000

145,000

101,000

79,000

123,000

0

0

0

Additions to property, plant and equipment and other assets

90,000

116,000

98,000

106,000

110,000

106,000

130,000

132,000

128,000

119,000

81,000

85,000

98,000

109,000

117,000

120,000

129,000

134,000

167,000

178,000

182,000

163,000

147,000

129,000

135,000

130,000

139,000

137,000

99,000

132,000

165,000

161,000

199,000

177,000

0

0

0

Additions to intangible assets

419,000

403,000

393,000

398,000

404,000

414,000

411,000

397,000

375,000

370,000

347,000

333,000

340,000

324,000

309,000

310,000

286,000

274,000

277,000

262,000

255,000

249,000

246,000

246,000

246,000

244,000

249,000

239,000

247,000

226,000

214,000

216,000

198,000

190,000

0

0

0

Other investing activities

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

0

-

-

-

-

1,000

0

0

0

Net cash used in investing activities

-544,000

-582,000

-525,000

-520,000

-554,000

-506,000

-751,000

-752,000

-682,000

-1,236,000

-939,000

-930,000

-1,172,000

-642,000

-668,000

-660,000

-446,000

-581,000

-759,000

-762,000

-762,000

-732,000

-641,000

-1,795,000

-866,000

-687,000

-683,000

449,000

-506,000

-522,000

-522,000

-478,000

-471,000

-486,000

0

0

0

Financing Activities
Net borrowings under revolving credit facility

0

-

0

0

0

-

0

0

0

-

-

-

-

-164,000

147,000

177,000

-75,000

-116,000

0

0

0

-

-

0

0

-

-

-

0

-

0

0

0

-

-

-

0

Proceeds from issuances of debt, net of issuance costs

-

-

-

-

-

-

-

-

-

2,745,000

4,751,000

4,751,000

2,501,000

2,502,000

496,000

496,000

496,000

746,000

0

0

0

-

-

-

-

2,485,000

3,274,000

2,658,000

2,655,000

1,998,000

1,209,000

1,209,000

1,209,000

277,000

0

0

0

Repayment of debt

57,000

57,000

57,000

49,000

825,000

819,000

812,000

813,000

2,298,000

2,296,000

3,953,000

3,991,000

1,746,000

1,765,000

125,000

105,000

98,000

98,000

99,000

899,000

4,599,000

4,598,000

4,811,000

4,008,000

306,000

2,171,000

2,782,000

2,782,000

2,848,000

2,230,000

1,601,000

1,691,000

1,630,000

2,110,000

0

0

0

Decrease in other short-term borrowings

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-5,000

5,000

-3,000

-2,000

3,000

6,000

-10,000

-12,000

-6,000

0

0

0

Cash dividends paid to shareholders

292,000

395,000

497,000

497,000

497,000

494,000

491,000

488,000

484,000

474,000

464,000

454,000

444,000

434,000

424,000

428,000

419,000

408,000

402,000

381,000

372,000

356,000

337,000

317,000

283,000

265,000

0

0

0

-

-

-

-

-

-

-

-

Repurchase of common stock

-

-

-

-

-

70,000

93,000

116,000

118,000

140,000

141,000

198,000

377,000

418,000

568,000

651,000

609,000

667,000

884,000

738,000

591,000

466,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Activity from share-based compensation plans

-9,000

-8,000

-7,000

-7,000

-2,000

15,000

17,000

23,000

24,000

21,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,801,000

0

0

0

Proceeds from exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

84,000

-

63,000

72,000

98,000

103,000

106,000

91,000

80,000

85,000

0

0

0

-

-

-

-

-

-

-

-

Proceeds from employee stock purchase plan

4,000

4,000

4,000

4,000

5,000

5,000

5,000

6,000

5,000

6,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Finance leases

55,000

60,000

60,000

65,000

73,000

76,000

73,000

64,000

62,000

55,000

56,000

53,000

44,000

40,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Activity under stock plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

0

Other financing activities

-29,000

-28,000

-20,000

-15,000

-19,000

-18,000

-24,000

-25,000

-21,000

-22,000

-17,000

-14,000

-11,000

-11,000

10,000

8,000

1,000

1,000

-3,000

-49,000

-79,000

-78,000

-102,000

-66,000

-32,000

-35,000

-111,000

-99,000

-107,000

-98,000

-447,000

-444,000

-428,000

-220,000

0

0

0

Net cash provided by financing activities

-566,000

-544,000

-653,000

-590,000

-612,000

-676,000

-480,000

-546,000

-504,000

-215,000

-206,000

-176,000

-49,000

-248,000

-408,000

-468,000

-650,000

-492,000

-383,000

-284,000

-222,000

-585,000

-703,000

23,000

20,000

83,000

192,000

-489,000

-380,000

-298,000

-303,000

-270,000

-305,000

-250,000

0

0

0

Effect of exchange-rate changes on cash and cash equivalents

-37,000

-10,000

-21,000

-7,000

-26,000

-8,000

-3,000

13,000

44,000

43,000

14,000

5,000

-9,000

-9,000

10,000

-9,000

-10,000

-52,000

-78,000

-80,000

-78,000

-67,000

-36,000

-16,000

-23,000

-21,000

0

0

0

-

-

-

-15,000

-7,000

0

0

0

Net increase/(decrease) in cash and cash equivalents

-43,000

-70,000

-57,000

-1,000

-60,000

-132,000

-216,000

-116,000

11,000

-98,000

216,000

164,000

19,000

397,000

88,000

15,000

89,000

84,000

-11,000

21,000

42,000

-291,000

-368,000

-847,000

68,000

276,000

412,000

874,000

-62,000

-31,000

-79,000

-91,000

-101,000

-102,000

0

0

0

Supplemental Cash Flow Information
Cash paid for income taxes

234,000

224,000

231,000

203,000

206,000

206,000

213,000

231,000

222,000

232,000

225,000

211,000

180,000

157,000

161,000

162,000

159,000

159,000

142,000

150,000

151,000

154,000

163,000

150,000

208,000

147,000

313,000

252,000

118,000

124,000

-128,000

-257,000

-186,000

-132,000

0

0

0

Cash paid for interest, net of amounts capitalized

381,000

386,000

388,000

377,000

384,000

380,000

380,000

384,000

369,000

352,000

342,000

326,000

324,000

319,000

317,000

313,000

309,000

296,000

281,000

287,000

276,000

294,000

286,000

605,000

394,000

304,000

858,000

431,000

403,000

384,000

-407,000

-876,000

-614,000

-446,000

0

0

0