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

-13,000

-108,000

-468,000

126,000

47,000

-949,000

98,000

76,000

75,000

84,000

150,000

133,000

73,000

160,000

132,000

114,000

101,000

254,000

142,000

116,000

63,000

158,000

92,000

76,000

55,000

145,000

131,000

426,000

34,000

36,000

106,000

105,000

25,000

96,000

103,000

69,000

-181,000

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

16,000

11,000

13,000

11,000

15,000

14,000

1,000

7,000

13,000

10,000

8,000

12,000

15,000

14,000

11,000

13,000

13,000

9,000

12,000

13,000

14,000

11,000

12,000

12,000

12,000

15,000

11,000

11,000

10,000

10,000

10,000

6,000

8,000

9,000

8,000

6,000

4,000

Gain on sale of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-13,000

0

302,000

1,000

-

-

-

-

-

-

-

-

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

-7,000

-171,000

-8,000

-1,000

2,000

-

-

-

-

-

-

-

-

36,000

2,000

-5,000

-1,000

196,000

5,000

-8,000

-26,000

-40,000

-53,000

-51,000

-30,000

-11,000

5,000

-4,000

-30,000

-134,000

0

8,000

-15,000

15,000

-4,000

-1,000

-223,000

Loss on derivative instruments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,000

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-7,000

0

1,000

1,000

-1,000

-2,000

3,000

-2,000

3,000

-3,000

2,000

-5,000

3,000

-5,000

1,000

-6,000

Depreciation and amortization

214,000

206,000

186,000

185,000

179,000

171,000

175,000

162,000

167,000

163,000

160,000

162,000

155,000

153,000

151,000

152,000

147,000

142,000

144,000

146,000

142,000

148,000

139,000

145,000

141,000

146,000

117,000

130,000

128,000

132,000

130,000

127,000

131,000

133,000

125,000

135,000

136,000

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

107,000

-61,000

-61,000

3,000

115,000

-143,000

-61,000

-1,000

110,000

-25,000

-104,000

66,000

53,000

-45,000

-71,000

66,000

-3,000

67,000

-28,000

43,000

-47,000

84,000

-38,000

68,000

-21,000

61,000

-42,000

92,000

-27,000

26,000

-26,000

64,000

-51,000

33,000

-33,000

128,000

-57,000

Prepaid expenses and other assets

13,000

-55,000

-13,000

-46,000

50,000

6,000

-38,000

-15,000

123,000

20,000

-33,000

-24,000

65,000

-26,000

-22,000

-1,000

45,000

-2,000

6,000

3,000

56,000

-5,000

33,000

0

48,000

-58,000

5,000

1,000

31,000

-12,000

3,000

2,000

25,000

8,000

-7,000

11,000

25,000

Accounts payable and other current liabilities and deferred revenues

92,000

-137,000

4,000

23,000

130,000

-169,000

61,000

-50,000

179,000

-164,000

-6,000

-2,000

131,000

-169,000

19,000

9,000

191,000

-176,000

-47,000

-13,000

200,000

-155,000

-8,000

0

167,000

-73,000

8,000

-45,000

165,000

-80,000

18,000

25,000

227,000

-116,000

60,000

-67,000

155,000

Other non-current liabilities

-20,000

-47,000

0

-27,000

-21,000

0

-7,000

3,000

-2,000

11,000

-4,000

-4,000

-1,000

3,000

-4,000

0

-7,000

2,000

0

-3,000

-1,000

4,000

-2,000

-7,000

3,000

-2,000

0

-1,000

-3,000

-8,000

0

-1,000

-1,000

0

-3,000

-1,000

2,000

Interest payable

44,000

-38,000

43,000

-38,000

44,000

-

-

-

45,000

-41,000

45,000

-38,000

56,000

-42,000

51,000

-45,000

50,000

-46,000

49,000

-45,000

57,000

-40,000

38,000

-35,000

43,000

-23,000

31,000

-22,000

27,000

-17,000

34,000

-19,000

31,000

-25,000

32,000

-23,000

47,000

Income taxes

-41,000

17,000

-443,000

-53,000

-10,000

140,000

24,000

-35,000

-3,000

-57,000

39,000

21,000

-9,000

-37,000

43,000

43,000

15,000

-90,000

42,000

50,000

9,000

-108,000

47,000

37,000

1,000

51,000

5,000

11,000

-4,000

-57,000

43,000

-1,000

-16,000

158,000

15,000

8,000

-167,000

Net cash (used in)/provided by operating activities

-5,000

470,000

413,000

226,000

-43,000

546,000

387,000

242,000

-117,000

506,000

538,000

226,000

40,000

543,000

456,000

210,000

87,000

401,000

454,000

253,000

101,000

401,000

392,000

210,000

90,000

320,000

321,000

206,000

54,000

340,000

331,000

116,000

-3,000

302,000

269,000

122,000

-52,000

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

27,000

-1,000

2,000

1,000

59,000

4,000

9,000

28,000

2,000

183,000

14,000

9,000

572,000

22,000

11,000

205,000

47,000

48,000

1,000

6,000

191,000

111,000

11,000

8,000

184,000

47,000

1,183,000

8,000

11,000

24,000

62,000

58,000

16,000

9,000

18,000

36,000

60,000

Additions to property, plant and equipment and other assets

4,000

58,000

14,000

14,000

30,000

40,000

22,000

18,000

26,000

64,000

24,000

14,000

17,000

26,000

28,000

27,000

28,000

34,000

31,000

36,000

33,000

67,000

42,000

40,000

14,000

51,000

24,000

46,000

9,000

60,000

22,000

8,000

42,000

93,000

18,000

46,000

20,000

Additions to intangible assets

108,000

119,000

98,000

94,000

92,000

109,000

103,000

100,000

102,000

106,000

89,000

78,000

97,000

83,000

75,000

85,000

81,000

68,000

76,000

61,000

69,000

71,000

61,000

54,000

63,000

68,000

61,000

54,000

61,000

73,000

51,000

62,000

40,000

61,000

53,000

44,000

32,000

Other investing activities

3,000

-

-

-

-1,000

-

-

-

2,000

-

-

-

-

-

-

-

-

-

-

-1,000

-2,000

-

-

-

-

-

-

-

1,000

-

-

-

-

-1,000

3,000

-2,000

1,000

Net cash used in investing activities

-142,000

-160,000

-132,000

-110,000

-180,000

-103,000

-127,000

-144,000

-132,000

-348,000

-128,000

-74,000

-686,000

-51,000

-119,000

-316,000

-156,000

-77,000

-111,000

-102,000

-291,000

-255,000

-114,000

-102,000

-261,000

-164,000

-1,268,000

827,000

-82,000

-160,000

-136,000

-128,000

-98,000

-160,000

-92,000

-121,000

-113,000

Financing Activities
Net borrowings under revolving credit facility

135,000

-

-106,000

33,000

263,000

-

-42,000

51,000

195,000

-

-

-

-

-357,000

-28,000

385,000

-164,000

-46,000

2,000

133,000

-205,000

-

-

-5,000

30,000

-

-

-

55,000

-

-150,000

95,000

120,000

-

-

-

0

Proceeds from issuances of debt, net of issuance costs

-

-

-

-

-

-

-

-

-

0

0

2,250,000

495,000

2,006,000

0

0

496,000

0

0

0

746,000

-

-

-

-

0

616,000

3,000

1,866,000

789,000

0

0

1,209,000

0

0

0

277,000

Repayment of debt

14,000

14,000

14,000

15,000

14,000

14,000

6,000

791,000

8,000

7,000

7,000

2,276,000

6,000

1,664,000

45,000

31,000

25,000

24,000

25,000

24,000

25,000

25,000

825,000

3,724,000

24,000

238,000

22,000

22,000

1,889,000

849,000

22,000

88,000

1,271,000

220,000

112,000

27,000

1,751,000

Decrease in other short-term borrowings

-

-

-

-

-

-

-

-

-

-

-

0

5,000

-

-

-

-

-

-

-

-

-

-

-

-

-17,000

10,000

1,000

1,000

-7,000

2,000

2,000

6,000

-4,000

-14,000

0

12,000

Cash dividends paid to shareholders

21,000

22,000

124,000

125,000

124,000

124,000

124,000

125,000

121,000

121,000

121,000

121,000

111,000

111,000

111,000

111,000

101,000

101,000

115,000

102,000

90,000

95,000

94,000

93,000

74,000

76,000

74,000

59,000

56,000

-

-

-

-

-

-

-

-

Repurchase of common stock

-

-

-

-

-

0

10,000

40,000

20,000

23,000

33,000

42,000

42,000

24,000

90,000

221,000

83,000

174,000

173,000

179,000

141,000

391,000

27,000

32,000

16,000

-

-

-

-

-

-

-

-

-

-

-

-

Activity from share-based compensation plans

-4,000

-3,000

-1,000

-1,000

-3,000

-2,000

-1,000

4,000

14,000

0

5,000

5,000

11,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

1,801,000

Proceeds from exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

43,000

11,000

18,000

-

14,000

20,000

6,000

23,000

23,000

46,000

11,000

26,000

8,000

35,000

16,000

-

-

-

-

-

-

-

-

Proceeds from employee stock purchase plan

1,000

1,000

1,000

1,000

1,000

1,000

1,000

2,000

1,000

1,000

2,000

1,000

2,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Finance leases

11,000

16,000

15,000

13,000

16,000

16,000

20,000

21,000

19,000

13,000

11,000

19,000

12,000

14,000

8,000

10,000

8,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Activity under stock plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-15,000

-3,000

-10,000

-

-

-

2,000

Other financing activities

-4,000

-11,000

-9,000

-5,000

-3,000

-3,000

-4,000

-9,000

-2,000

-9,000

-5,000

-5,000

-3,000

-4,000

-2,000

-2,000

-3,000

17,000

-4,000

-9,000

-3,000

13,000

-50,000

-39,000

-2,000

-11,000

-14,000

-5,000

-5,000

-87,000

-2,000

-13,000

4,000

-436,000

1,000

3,000

212,000

Net cash provided by financing activities

82,000

-254,000

-268,000

-126,000

104,000

-363,000

-205,000

-148,000

40,000

-167,000

-271,000

-106,000

329,000

-158,000

-241,000

21,000

130,000

-318,000

-301,000

-161,000

288,000

-209,000

-202,000

-99,000

-75,000

-327,000

524,000

-102,000

-12,000

-218,000

-157,000

7,000

70,000

-223,000

-124,000

-28,000

125,000

Effect of exchange-rate changes on cash and cash equivalents

-30,000

9,000

-17,000

1,000

-3,000

-2,000

-3,000

-18,000

15,000

3,000

13,000

13,000

14,000

-26,000

4,000

-1,000

14,000

-7,000

-15,000

-2,000

-28,000

-33,000

-17,000

0

-17,000

-2,000

3,000

-7,000

-15,000

-

-

-

7,000

-4,000

-23,000

5,000

15,000

Net increase/(decrease) in cash and cash equivalents

-95,000

65,000

-4,000

-9,000

-122,000

78,000

52,000

-68,000

-194,000

-6,000

152,000

59,000

-303,000

308,000

100,000

-86,000

75,000

-1,000

27,000

-12,000

70,000

-96,000

59,000

9,000

-263,000

-173,000

-420,000

924,000

-55,000

-37,000

42,000

-12,000

-24,000

-85,000

30,000

-22,000

-25,000

Supplemental Cash Flow Information
Cash paid for income taxes

52,000

43,000

63,000

76,000

42,000

50,000

35,000

79,000

42,000

57,000

53,000

70,000

52,000

50,000

39,000

39,000

29,000

54,000

40,000

36,000

29,000

37,000

48,000

37,000

32,000

46,000

35,000

95,000

-29,000

212,000

-26,000

-39,000

-23,000

-40,000

-155,000

32,000

31,000

Cash paid for interest, net of amounts capitalized

50,000

136,000

57,000

138,000

55,000

138,000

46,000

145,000

51,000

138,000

50,000

130,000

34,000

128,000

34,000

128,000

29,000

126,000

30,000

124,000

16,000

111,000

36,000

113,000

34,000

103,000

355,000

-98,000

-56,000

657,000

-72,000

-126,000

-75,000

-134,000

-541,000

136,000

93,000