XML 40 R30.htm IDEA: XBRL DOCUMENT v3.7.0.1
Guarantor Financial Information (Tables)
6 Months Ended
Jun. 30, 2016
Guarantees [Abstract]  
Consolidated Statement of Comprehensive Income

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the three months ended June 30, 2017

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

 

 

 

Revenues

 

$

 

 

$

 

 

$

898

 

 

$

746

 

 

$

 

 

$

1,644

 

 

 

 

Cost of revenues, exclusive of depreciation and amortization shown separately below

 

 

 

 

 

 

 

 

357

 

 

 

321

 

 

 

 

 

 

678

 

 

 

 

Selling, general and administrative expenses, exclusive of depreciation and amortization shown separately below

 

 

1

 

 

 

 

 

 

235

 

 

 

235

 

 

 

 

 

 

471

 

 

 

 

Depreciation and amortization

 

 

 

 

 

 

 

 

133

 

 

 

29

 

 

 

 

 

 

162

 

 

 

 

Restructuring charges

 

 

 

 

 

 

 

 

3

 

 

 

6

 

 

 

 

 

 

9

 

 

 

 

Operating (loss)/income

 

 

(1

)

 

 

 

 

 

170

 

 

 

155

 

 

 

 

 

 

324

 

 

 

 

Interest income

 

 

1

 

 

 

227

 

 

 

8

 

 

 

2

 

 

 

(237

)

 

 

1

 

 

 

 

Interest expense

 

 

 

 

 

(88

)

 

 

(231

)

 

 

(10

)

 

 

237

 

 

 

(92

)

 

 

 

Foreign currency exchange transaction losses, net

 

 

 

 

 

 

 

 

(2

)

 

 

(5

)

 

 

 

 

 

(7

)

 

 

 

Other (expense)/income, net

 

 

 

 

 

(2

)

 

 

(4

)

 

 

4

 

 

 

 

 

 

(2

)

 

 

 

Income/(loss) from continuing operations before income taxes and equity in net income of subsidiaries and affiliates

 

 

 

 

 

137

 

 

 

(59

)

 

 

146

 

 

 

 

 

 

224

 

 

 

 

(Provision)/benefit for income taxes

 

 

 

 

 

(48

)

 

 

13

 

 

 

(56

)

 

 

 

 

 

(91

)

 

 

 

Equity in net income of subsidiaries

 

 

131

 

 

 

35

 

 

 

178

 

 

 

 

 

 

(344

)

 

 

 

 

 

 

Equity in net (loss)/income of affiliates

 

 

 

 

 

 

 

 

(1

)

 

 

1

 

 

 

 

 

 

 

 

 

 

Net income

 

 

131

 

 

 

124

 

 

 

131

 

 

 

91

 

 

 

(344

)

 

 

133

 

 

 

 

Less net income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

2

 

 

 

 

Net income attributable to controlling interest

 

 

131

 

 

 

124

 

 

 

131

 

 

 

89

 

 

 

(344

)

 

 

131

 

 

 

 

Total other comprehensive income

 

 

83

 

 

 

88

 

 

 

83

 

 

 

98

 

 

 

(267

)

 

 

85

 

 

 

 

Total other comprehensive income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

2

 

 

 

 

Total other comprehensive income attributable to controlling interests

 

 

83

 

 

 

88

 

 

 

83

 

 

 

96

 

 

 

(267

)

 

 

83

 

 

 

 

Total comprehensive income

 

 

214

 

 

 

212

 

 

 

214

 

 

 

189

 

 

 

(611

)

 

 

218

 

 

 

 

Comprehensive income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

 

 

 

4

 

 

 

 

Total comprehensive income attributable to controlling interest

 

$

214

 

 

$

212

 

 

$

214

 

 

$

185

 

 

$

(611

)

 

$

214

 

 

 

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the three months ended June 30, 2016

 

(IN MILLIONS)

  

Parent

 

 

Issuers

 

 

Guarantor

 

 

Non-
Guarantor

 

 

Elimination

 

 

Consolidated

 

Revenues

  

$

 

 

$

 

 

$

913

 

 

$

683

 

 

$

 

 

$

1,596

 

Cost of revenues, exclusive of depreciation
and amortization shown separately
below

  

 

 

 

 

 

 

 

332

 

 

 

322

 

 

 

 

 

 

654

 

Selling, general and administrative expenses, exclusive of depreciation and amortization shown separately below

  

 

2

 

 

 

 

 

 

248

 

 

 

224

 

 

 

 

 

 

474

 

Depreciation and amortization

  

 

 

 

 

 

 

 

122

 

 

 

30

 

 

 

 

 

 

152

 

Restructuring charges

  

 

 

 

 

 

 

 

13

 

 

 

21

 

 

 

 

 

 

34

 

Operating (loss)/income

  

 

(2

)

 

 

 

 

 

198

 

 

 

86

 

 

 

 

 

 

282

 

Interest income

  

 

 

 

 

222

 

 

 

10

 

 

 

1

 

 

 

(232

)

 

 

1

 

Interest expense

  

 

(1

)

 

 

(77

)

 

 

(227

)

 

 

(10

)

 

 

232

 

 

 

(83

)

Foreign currency exchange transaction losses, net

  

 

 

 

 

 

 

 

 

 

 

(4

)

 

 

 

 

 

(4

)

Other income/(expense), net

  

 

 

 

 

 

 

 

14

 

 

 

(14

)

 

 

 

 

 

 

(Loss)/income from continuing operations before income taxes and equity in net income/(loss) of subsidiaries and affiliates

  

 

(3

)

 

 

145

 

 

 

(5

)

 

 

59

 

 

 

 

 

 

196

 

Provision for income taxes

  

 

 

 

 

(51

)

 

 

(2

)

 

 

(29

)

 

 

 

 

 

(82

)

Equity in net income of subsidiaries

  

 

116

 

 

 

25

 

 

 

124

 

 

 

 

 

 

(265

)

 

 

 

Equity in net (loss)/income of affiliates

 

 

 

 

 

 

 

 

(1

)

 

 

1

 

 

 

 

 

 

 

Net income

  

 

113

 

 

 

119

 

 

 

116

 

 

 

31

 

 

 

(265

)

 

 

114

 

Less net income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

 

 

 

1

 

Net income attributable to controlling interest

 

 

113

 

 

 

119

 

 

 

116

 

 

 

30

 

 

 

(265

)

 

 

113

 

Total other comprehensive loss

  

 

(42

)

 

 

(48

)

 

 

(42

)

 

 

(49

)

 

 

137

 

 

 

(44

)

Total other comprehensive loss attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

(2

)

 

 

 

 

 

(2

)

Total other comprehensive loss attributable to controlling interests

 

 

(42

)

 

 

(48

)

 

 

(42

)

 

 

(47

)

 

 

137

 

 

 

(42

)

Total comprehensive income/(loss)

  

 

71

 

 

 

71

 

 

 

74

 

 

 

(18

)

 

 

(128

)

 

 

70

 

Comprehensive loss attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

(1

)

 

 

 

 

 

(1

)

Total comprehensive income/(loss) attributable to controlling interest

  

$

71

 

 

$

71

 

 

$

74

 

 

$

(17

)

 

$

(128

)

 

$

71

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the six months ended June 30, 2017

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

 

 

 

Revenues

 

$

 

 

$

 

 

$

1,759

 

 

$

1,411

 

 

$

 

 

$

3,170

 

 

 

 

Cost of revenues, exclusive of depreciation and amortization shown separately below

 

 

 

 

 

 

 

 

696

 

 

 

643

 

 

 

 

 

 

1,339

 

 

 

 

Selling, general and administrative expenses, exclusive of depreciation and amortization shown separately below

 

 

2

 

 

 

 

 

 

489

 

 

 

451

 

 

 

 

 

 

942

 

 

 

 

Depreciation and amortization

 

 

 

 

 

 

 

 

258

 

 

 

59

 

 

 

 

 

 

317

 

 

 

 

Restructuring charges

 

 

 

 

 

 

 

 

18

 

 

 

23

 

 

 

 

 

 

41

 

 

 

 

Operating (loss)/income

 

 

(2

)

 

 

 

 

 

298

 

 

 

235

 

 

 

 

 

 

531

 

 

 

 

Interest income

 

 

1

 

 

 

444

 

 

 

17

 

 

 

3

 

 

 

(463

)

 

 

2

 

 

 

 

Interest expense

 

 

 

 

 

(173

)

 

 

(453

)

 

 

(19

)

 

 

463

 

 

 

(182

)

 

 

 

Foreign currency exchange transaction losses, net

 

 

 

 

 

 

 

 

(3

)

 

 

(6

)

 

 

 

 

 

(9

)

 

 

 

Other (expense)/income, net

 

 

 

 

 

(2

)

 

 

(22

)

 

 

22

 

 

 

 

 

 

(2

)

 

 

 

(Loss)/income from continuing operations before income taxes and equity in net income of subsidiaries and affiliates

 

 

(1

)

 

 

269

 

 

 

(163

)

 

 

235

 

 

 

 

 

 

340

 

 

 

 

(Provision)/benefit for income taxes

 

 

 

 

 

(94

)

 

 

57

 

 

 

(97

)

 

 

 

 

 

(134

)

 

 

 

Equity in net income of subsidiaries

 

 

203

 

 

 

278

 

 

 

310

 

 

 

 

 

 

(791

)

 

 

 

 

 

 

Equity in net (loss)/income of affiliates

 

 

 

 

 

 

 

 

(1

)

 

 

1

 

 

 

 

 

 

 

 

 

 

Net income

 

 

202

 

 

 

453

 

 

 

203

 

 

 

139

 

 

 

(791

)

 

 

206

 

 

 

 

Less net income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

 

 

 

4

 

 

 

 

Net income attributable to controlling interest

 

 

202

 

 

 

453

 

 

 

203

 

 

 

135

 

 

 

(791

)

 

 

202

 

 

 

 

Total other comprehensive income

 

 

160

 

 

 

171

 

 

 

160

 

 

 

176

 

 

 

(502

)

 

 

165

 

 

 

 

Total other comprehensive income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

5

 

 

 

 

 

 

5

 

 

 

 

Total other comprehensive income attributable to controlling interests

 

 

160

 

 

 

171

 

 

 

160

 

 

 

171

 

 

 

(502

)

 

 

160

 

 

 

 

Total comprehensive income

 

 

362

 

 

 

624

 

 

 

363

 

 

 

315

 

 

 

(1,293

)

 

 

371

 

 

 

 

Comprehensive income attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

9

 

 

 

 

 

 

9

 

 

 

 

Total comprehensive income attributable to controlling interest

 

$

362

 

 

$

624

 

 

$

363

 

 

$

306

 

 

$

(1,293

)

 

$

362

 

 

 

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the six months ended June 30, 2016

 

(IN MILLIONS)

  

Parent

 

 

Issuer

 

 

Guarantor

 

 

Non-
Guarantor

 

 

Elimination

 

 

Consolidated

 

Revenues

  

$

 

 

$

 

 

$

1,784

 

 

$

1,299

 

 

$

 

 

$

3,083

 

Cost of revenues, exclusive of depreciation and amortization shown separately below

  

 

 

 

 

 

 

 

663

 

 

 

632

 

 

 

 

 

 

1,295

 

Selling, general and administrative expenses, exclusive of depreciation and amortization shown
separately below

  

 

2

 

 

 

 

 

 

507

 

 

 

430

 

 

 

 

 

 

939

 

Depreciation and amortization

  

 

 

 

 

 

 

 

241

 

 

 

58

 

 

 

 

 

 

299

 

Restructuring charges

  

 

 

 

 

 

 

 

18

 

 

 

26

 

 

 

 

 

 

44

 

Operating (loss)/income

  

 

(2

)

 

 

 

 

 

355

 

 

 

153

 

 

 

 

 

 

506

 

Interest income

  

 

 

 

 

432

 

 

 

19

 

 

 

2

 

 

 

(451

)

 

 

2

 

Interest expense

  

 

(2

)

 

 

(151

)

 

 

(441

)

 

 

(19

)

 

 

451

 

 

 

(162

)

Foreign currency exchange transaction losses, net

  

 

 

 

 

 

 

 

(1

)

 

 

(4

)

 

 

 

 

 

(5

)

Other (expense)/income, net

  

 

 

 

 

(1

)

 

 

22

 

 

 

(21

)

 

 

 

 

 

 

(Loss)/income from continuing operations before income taxes and equity in net income/(loss) of subsidiaries and affiliates

  

 

(4

)

 

 

280

 

 

 

(46

)

 

 

111

 

 

 

 

 

 

341

 

(Provision)/benefit for income taxes

  

 

 

 

 

(98

)

 

 

26

 

 

 

(54

)

 

 

 

 

 

(126

)

Equity in net income of subsidiaries

  

 

217

 

 

 

15

 

 

 

238

 

 

 

 

 

 

(470

)

 

 

 

Equity in net (loss)/income of affiliates

 

 

 

 

 

 

 

 

(1

)

 

 

1

 

 

 

 

 

 

 

Net income

  

 

213

 

 

 

197

 

 

 

217

 

 

 

58

 

 

 

(470

)

 

 

215

 

Less net income attributable to noncontrolling
interests

  

 

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

2

 

Net income attributable to controlling interest

  

 

213

 

 

 

197

 

 

 

217

 

 

 

56

 

 

 

(470

)

 

 

213

 

Total other comprehensive income

 

 

48

 

 

 

66

 

 

 

48

 

 

 

43

 

 

 

(158

)

 

 

47

 

Total other comprehensive loss attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

(1

)

 

 

 

 

 

(1

)

Total other comprehensive income attributable to controlling interests

 

 

48

 

 

 

66

 

 

 

48

 

 

 

44

 

 

 

(158

)

 

 

48

 

Total comprehensive income

  

 

261

 

 

 

263

 

 

 

265

 

 

 

101

 

 

 

(628

)

 

 

262

 

Comprehensive income attributable to noncontrolling interests

  

 

 

 

 

 

 

 

 

 

 

1

 

 

 

 

 

 

1

 

Total comprehensive income attributable to controlling interests

  

$

261

 

 

$

263

 

 

$

265

 

 

$

100

 

 

$

(628

)

 

$

261

 

 

Consolidated Balance Sheet

Nielsen Holdings plc

Condensed Consolidated Balance Sheet (Unaudited)

June 30, 2017

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

Assets:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cash and cash equivalents

 

$

3

 

 

$

1

 

 

$

(5

)

 

$

511

 

 

$

 

 

$

510

 

Trade and other receivables, net

 

 

 

 

 

 

 

 

587

 

 

 

780

 

 

 

 

 

 

1,367

 

Prepaid expenses and other current assets

 

 

 

 

 

 

 

 

212

 

 

 

128

 

 

 

 

 

 

340

 

Intercompany receivables

 

 

1

 

 

 

1,031

 

 

 

301

 

 

 

97

 

 

 

(1,430

)

 

 

 

Total current assets

 

 

4

 

 

 

1,032

 

 

 

1,095

 

 

 

1,516

 

 

 

(1,430

)

 

 

2,217

 

Non-current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Property, plant and equipment, net

 

 

 

 

 

 

 

 

292

 

 

 

162

 

 

 

 

 

 

454

 

Goodwill

 

 

 

 

 

 

 

 

6,029

 

 

 

2,262

 

 

 

 

 

 

8,291

 

Other intangible assets, net

 

 

 

 

 

 

 

 

4,546

 

 

 

512

 

 

 

 

 

 

5,058

 

Deferred tax assets

 

 

2

 

 

 

15

 

 

 

 

 

 

116

 

 

 

 

 

 

133

 

Other non-current assets

 

 

 

 

 

4

 

 

 

252

 

 

 

85

 

 

 

 

 

 

341

 

Equity investment in subsidiaries

 

 

4,162

 

 

 

9

 

 

 

4,031

 

 

 

 

 

 

(8,202

)

 

 

 

Intercompany loans

 

 

25

 

 

 

11,533

 

 

 

3,338

 

 

 

139

 

 

 

(15,035

)

 

 

 

Total assets

 

$

4,193

 

 

$

12,593

 

 

$

19,583

 

 

$

4,792

 

 

$

(24,667

)

 

$

16,494

 

Liabilities and equity:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Accounts payable and other current liabilities

 

$

 

 

$

61

 

 

$

387

 

 

$

477

 

 

$

 

 

$

925

 

Deferred revenues

 

 

 

 

 

 

 

 

215

 

 

 

137

 

 

 

 

 

 

352

 

Income tax liabilities

 

 

 

 

 

2

 

 

 

11

 

 

 

122

 

 

 

 

 

 

135

 

Current portion of long-term debt, capital lease obligations and short-term borrowings

 

 

 

 

 

23

 

 

 

135

 

 

 

5

 

 

 

 

 

 

163

 

Intercompany payables

 

 

 

 

 

2

 

 

 

1,181

 

 

 

247

 

 

 

(1,430

)

 

 

 

Total current liabilities

 

 

 

 

 

88

 

 

 

1,929

 

 

 

988

 

 

 

(1,430

)

 

 

1,575

 

Non-current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-term debt and capital lease obligations

 

 

 

 

 

8,237

 

 

 

107

 

 

 

16

 

 

 

 

 

 

8,360

 

Deferred tax liabilities

 

 

 

 

 

71

 

 

 

1,084

 

 

 

90

 

 

 

 

 

 

1,245

 

Intercompany loans

 

 

 

 

 

2,985

 

 

 

11,698

 

 

 

352

 

 

 

(15,035

)

 

 

 

Other non-current liabilities

 

 

2

 

 

 

3

 

 

 

603

 

 

 

315

 

 

 

 

 

 

923

 

Total liabilities

 

 

2

 

 

 

11,384

 

 

 

15,421

 

 

 

1,761

 

 

 

(16,465

)

 

 

12,103

 

Total stockholders’ equity

 

 

4,191

 

 

 

1,209

 

 

 

4,162

 

 

 

2,831

 

 

 

(8,202

)

 

 

4,191

 

Noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

200

 

 

 

 

 

 

200

 

Total equity

 

 

4,191

 

 

 

1,209

 

 

 

4,162

 

 

 

3,031

 

 

 

(8,202

)

 

 

4,391

 

Total liabilities and equity

 

$

4,193

 

 

$

12,593

 

 

$

19,583

 

 

$

4,792

 

 

$

(24,667

)

 

$

16,494

 

 

Nielsen Holdings plc

Condensed Consolidated Balance Sheet

December 31, 2016

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

Assets:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cash and cash equivalents

 

$

5

 

 

$

1

 

 

$

219

 

 

$

529

 

 

$

 

 

$

754

Trade and other receivables, net

 

 

2

 

 

 

 

 

 

478

 

 

 

691

 

 

 

 

 

 

1,171

Prepaid expenses and other current assets

 

 

 

 

 

 

 

 

185

 

 

 

112

 

 

 

 

 

 

297

Intercompany receivables

 

 

 

 

 

862

 

 

 

312

 

 

 

167

 

 

 

(1,341

)

 

 

Total current assets

 

 

7

 

 

 

863

 

 

 

1,194

 

 

 

1,499

 

 

 

(1,341

)

 

 

2,222

Non-current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Property, plant and equipment, net

 

 

 

 

 

 

 

 

307

 

 

 

164

 

 

 

 

 

 

471

Goodwill

 

 

 

 

 

 

 

 

5,728

 

 

 

2,117

 

 

 

 

 

 

7,845

Other intangible assets, net

 

 

 

 

 

 

 

 

4,248

 

 

 

488

 

 

 

 

 

 

4,736

Deferred tax assets

 

 

2

 

 

 

 

 

 

(1

)

 

 

126

 

 

 

 

 

 

127

Other non-current assets

 

 

 

 

 

3

 

 

 

245

 

 

 

81

 

 

 

 

 

 

329

Equity investment in subsidiaries

 

 

4,117

 

 

 

 

 

 

4,222

 

 

 

 

 

 

(8,339

)

 

 

Intercompany loans

 

 

25

 

 

 

11,533

 

 

 

3,332

 

 

 

150

 

 

 

(15,040

)

 

 

Total assets

 

$

4,151

 

 

$

12,399

 

 

$

19,275

 

 

$

4,625

 

 

$

(24,720

)

 

$

15,730

Liabilities and equity:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Accounts payable and other current liabilities

 

$

 

 

$

52

 

 

$

479

 

 

$

481

 

 

$

 

 

$

1,012

Deferred revenues

 

 

 

 

 

 

 

 

172

 

 

 

125

 

 

 

 

 

 

297

Income tax liabilities

 

 

 

 

 

2

 

 

 

36

 

 

 

59

 

 

 

 

 

 

97

Current portion of long-term debt, capital lease obligations and short-term borrowings

 

 

 

 

 

145

 

 

 

35

 

 

 

8

 

 

 

 

 

 

188

Intercompany payables

 

 

47

 

 

 

2

 

 

 

988

 

 

 

304

 

 

 

(1,341

)

 

 

Total current liabilities

 

 

47

 

 

 

201

 

 

 

1,710

 

 

 

977

 

 

 

(1,341

)

 

 

1,594

Non-current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-term debt and capital lease obligations

 

 

 

 

 

7,611

 

 

 

106

 

 

 

21

 

 

 

 

 

 

7,738

Deferred tax liabilities

 

 

 

 

 

71

 

 

 

1,027

 

 

 

77

 

 

 

 

 

 

1,175

Intercompany loans

 

 

 

 

 

2,985

 

 

 

11,708

 

 

 

347

 

 

 

(15,040

)

 

 

Other non-current liabilities

 

 

2

 

 

 

4

 

 

 

609

 

 

 

315

 

 

 

 

 

 

930

Total liabilities

 

 

49

 

 

 

10,872

 

 

 

15,160

 

 

 

1,737

 

 

 

(16,381

)

 

 

11,437

Total stockholders’ equity

 

 

4,102

 

 

 

1,527

 

 

 

4,117

 

 

 

2,695

 

 

 

(8,339

)

 

 

4,102

Noncontrolling interests

 

 

 

 

 

 

 

 

(2

)

 

 

193

 

 

 

 

 

 

191

Total equity

 

 

4,102

 

 

 

1,527

 

 

 

4,115

 

 

 

2,888

 

 

 

(8,339

)

 

 

4,293

Total liabilities and equity

 

$

4,151

 

 

$

12,399

 

 

$

19,275

 

 

$

4,625

 

 

$

(24,720

)

 

$

15,730

 

Consolidated Statement of Cash Flows

Nielsen Holdings plc

Condensed Consolidated Statement of Cash Flows (Unaudited)

For the six months ended June 30, 2017

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Consolidated

 

Net cash (used in)/provided by operating activities

 

$

(45

)

 

$

110

 

 

$

93

 

 

$

108

 

 

$

266

 

Investing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Acquisition of subsidiaries and affiliates, net of cash acquired

 

 

 

 

 

 

 

 

(563

)

 

 

(18

)

 

 

(581

)

Additions to property, plant and equipment and other assets

 

 

 

 

 

 

 

 

(17

)

 

 

(14

)

 

 

(31

)

Additions to intangible assets

 

 

 

 

 

 

 

 

(146

)

 

 

(29

)

 

 

(175

)

Proceeds from the sale of property, plant and equipment and      other assets

 

 

 

 

 

 

 

 

28

 

 

 

 

 

 

28

 

Other investing activities

 

 

 

 

 

 

 

 

(1

)

 

 

 

 

 

(1

)

Net cash used in investing activities

 

 

 

 

 

 

 

 

(699

)

 

 

(61

)

 

 

(760

)

Financing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net borrowings under revolving credit facility

 

 

 

 

 

 

 

 

101

 

 

 

 

 

 

101

 

Repayments of debt

 

 

 

 

 

(2,281

)

 

 

 

 

 

(1

)

 

 

(2,282

)

Proceeds from the issuance of debt, net of issuance costs

 

 

 

 

 

2,745

 

 

 

 

 

 

 

 

 

2,745

 

Decrease in other short-term borrowings

 

 

 

 

 

 

 

 

 

 

 

(5

)

 

 

(5

)

Cash dividends paid to stockholders

 

 

(232

)

 

 

 

 

 

 

 

 

 

 

 

(232

)

Repurchase of common stock

 

 

(84

)

 

 

 

 

 

 

 

 

 

 

 

(84

)

Activity under stock plans

 

 

21

 

 

 

 

 

 

(5

)

 

 

 

 

 

16

 

Proceeds from employee stock purchase plan

 

 

3

 

 

 

 

 

 

 

 

 

 

 

 

3

 

Capital leases

 

 

 

 

 

 

 

 

(30

)

 

 

(1

)

 

 

(31

)

Settlement of intercompany and other financing activities

 

 

335

 

 

 

(574

)

 

 

319

 

 

 

(88

)

 

 

(8

)

Net cash provided by/(used in) financing activities

 

 

43

 

 

 

(110

)

 

 

385

 

 

 

(95

)

 

 

223

 

Effect of exchange-rate changes on cash and cash equivalents

 

 

 

 

 

 

 

 

(3

)

 

 

30

 

 

 

27

 

Net decrease in cash and cash equivalents

 

 

(2

)

 

 

 

 

 

(224

)

 

 

(18

)

 

 

(244

)

Cash and cash equivalents at beginning of period

 

 

5

 

 

 

1

 

 

 

219

 

 

 

529

 

 

 

754

 

Cash and cash equivalents at end of period

 

$

3

 

 

$

1

 

 

$

(5

)

 

$

511

 

 

$

510

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Cash Flows (Unaudited)

For the six months ended June 30, 2016

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Non-
Guarantor

 

 

Consolidated

 

Net cash (used in)/provided by operating activities

 

$

(3

)

 

$

116

 

 

$

140

 

 

$

44

 

 

$

297

 

Investing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Acquisition of subsidiaries and affiliates,
net of cash acquired

 

 

 

 

 

 

 

 

(239

)

 

 

(13

)

 

 

(252

)

Additions to property, plant and equipment and
other assets

 

 

 

 

 

 

 

 

(30

)

 

 

(25

)

 

 

(55

)

Additions to intangible assets

 

 

 

 

 

 

 

 

(145

)

 

 

(21

)

 

 

(166

)

Other investing activities

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

1

 

Net cash used in investing activities

 

 

 

 

 

 

 

 

(414

)

 

 

(58

)

 

 

(472

)

Financing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net borrowings under revolving credit
facility

 

 

 

 

 

 

 

 

221

 

 

 

 

 

 

221

 

Repayments of debt

 

 

 

 

 

(56

)

 

 

 

 

 

 

 

 

(56

)

Proceeds from the issuance of debt, net of issuance costs

 

 

 

 

 

 

496

 

 

 

 

 

 

 

 

 

 

 

496

 

Cash dividends paid to stockholders

 

 

(212

)

 

 

 

 

 

 

 

 

 

 

 

(212

)

Repurchase of common stock

 

 

(304

)

 

 

 

 

 

 

 

 

 

 

 

(304

)

Activity under stock plans

 

 

43

 

 

 

 

 

 

(14

)

 

 

 

 

 

29

 

Settlement of intercompany and other financing activities

 

 

396

 

 

 

(514

)

 

 

84

 

 

 

11

 

 

 

(23

)

Net cash (used in)/provided by financing activities

 

 

(77

)

 

 

(74

)

 

 

291

 

 

 

11

 

 

 

151

 

Effect of exchange-rate changes on cash
and cash equivalents

 

 

 

 

 

 

 

 

2

 

 

 

11

 

 

 

13

 

Net (decrease)/increase in cash and cash equivalents

 

 

(80

)

 

 

42

 

 

 

19

 

 

 

8

 

 

 

(11

)

Cash and cash equivalents at beginning of period

 

 

1

 

 

 

 

 

 

7

 

 

 

349

 

 

 

357

 

Cash and cash equivalents at end of
period

 

$

(79

)

 

$

42

 

 

$

26

 

 

$

357

 

 

$

346