XML 82 R37.htm IDEA: XBRL DOCUMENT v3.19.3
Guarantor Financial Information (Tables)
9 Months Ended
Sep. 30, 2019
Guarantees [Abstract]  
Consolidating Statement of Comprehensive Income

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the three months ended September 30, 2019

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

 

 

 

Revenues

 

$

 

 

$

 

 

$

902

 

 

$

714

 

 

$

 

 

$

1,616

 

 

 

 

Cost of revenues, exclusive of depreciation and

   amortization shown separately below

 

 

 

 

 

 

 

 

374

 

 

 

320

 

 

 

 

 

 

694

 

 

 

 

Selling, general and administrative expenses, exclusive

   of depreciation and amortization shown

   separately below

 

 

1

 

 

 

 

 

 

224

 

 

 

242

 

 

 

 

 

 

467

 

 

 

 

Depreciation and amortization

 

 

 

 

 

 

 

 

152

 

 

 

34

 

 

 

 

 

 

186

 

 

 

 

Impairment of goodwill and other long-lived assets

 

 

 

 

 

 

 

 

 

 

419

 

 

 

585

 

 

 

 

 

 

 

1,004

 

 

 

 

Restructuring charges

 

 

 

 

 

 

 

 

 

 

 

5

 

 

 

 

 

 

5

 

 

 

 

Operating income/(loss)

 

 

(1

)

 

 

 

 

 

(267

)

 

 

(472

)

 

 

 

 

 

(740

)

 

 

 

Interest income

 

 

 

 

 

180

 

 

 

28

 

 

 

1

 

 

 

(208

)

 

 

1

 

 

 

 

Interest expense

 

 

 

 

 

(93

)

 

 

(188

)

 

 

(27

)

 

 

208

 

 

 

(100

)

 

 

 

Foreign currency exchange transaction

   gains/(losses), net

 

 

 

 

 

 

 

 

 

 

 

(6

)

 

 

 

 

 

(6

)

 

 

 

Other income/(expense), net

 

 

 

 

 

 

 

 

(14

)

 

 

11

 

 

 

 

 

 

(3

)

 

 

 

Income/(loss) from continuing operations before

   income taxes and equity in net income/(loss)

   of subsidiaries

 

 

(1

)

 

 

87

 

 

 

(441

)

 

 

(493

)

 

 

 

 

 

(848

)

 

 

 

Benefit/(provision) for income taxes

 

 

 

 

 

(23

)

 

 

497

 

 

 

(94

)

 

 

 

 

 

380

 

 

 

 

Equity in net income/(loss) of subsidiaries

 

 

(471

)

 

 

57

 

 

 

(527

)

 

 

 

 

 

941

 

 

 

 

 

 

 

Net income/(loss)

 

 

(472

)

 

 

121

 

 

 

(471

)

 

 

(587

)

 

 

941

 

 

 

(468

)

 

 

 

Less net income/(loss) attributable to noncontrolling

   interests

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

 

 

 

4

 

 

 

 

Net income/(loss) attributable to controlling interest

 

 

(472

)

 

 

121

 

 

 

(471

)

 

 

(591

)

 

 

941

 

 

 

(472

)

 

 

 

Total other comprehensive income/(loss)

 

 

(51

)

 

 

12

 

 

 

(51

)

 

 

(14

)

 

 

52

 

 

 

(52

)

 

 

 

Total other comprehensive income/(loss) attributable

   to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

(1

)

 

 

 

 

 

(1

)

 

 

 

Total other comprehensive income/(loss) attributable

   to controlling interests

 

 

(51

)

 

 

12

 

 

 

(51

)

 

 

(13

)

 

 

52

 

 

 

(51

)

 

 

 

Total comprehensive income/(loss)

 

 

(523

)

 

 

133

 

 

 

(522

)

 

 

(601

)

 

 

993

 

 

 

(520

)

 

 

 

Comprehensive income/(loss) attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

 

 

 

3

 

 

 

 

Total comprehensive income/(loss) attributable to

   controlling interest

 

$

(523

)

 

$

133

 

 

$

(522

)

 

$

(604

)

 

$

993

 

 

$

(523

)

 

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the three months ended September 30, 2018

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

Revenues

 

$

 

 

$

 

 

$

885

 

 

$

715

 

 

$

 

 

$

1,600

 

Cost of revenues, exclusive of depreciation and

   amortization shown separately below

 

 

 

 

 

 

 

 

355

 

 

 

326

 

 

 

 

 

 

681

 

Selling, general and administrative expenses, exclusive

   of depreciation and amortization shown separately

   below

 

 

1

 

 

 

 

 

 

221

 

 

 

242

 

 

 

 

 

 

464

 

Depreciation and amortization

 

 

 

 

 

 

 

 

142

 

 

 

33

 

 

 

 

 

 

175

 

Restructuring charges

 

 

 

 

 

 

 

 

4

 

 

 

15

 

 

 

 

 

 

19

 

Operating income/(loss)

 

 

(1

)

 

 

 

 

 

163

 

 

 

99

 

 

 

 

 

 

261

 

Interest income

 

 

 

 

 

170

 

 

 

10

 

 

 

1

 

 

 

(179

)

 

 

2

 

Interest expense

 

 

 

 

 

(93

)

 

 

(176

)

 

 

(9

)

 

 

179

 

 

 

(99

)

Foreign currency exchange transaction gains/(losses),

   net

 

 

 

 

 

 

 

 

1

 

 

 

(9

)

 

 

 

 

 

(8

)

Other income/(expense), net

 

 

 

 

 

 

 

 

(17

)

 

 

18

 

 

 

 

 

 

1

 

Income/(loss) from continuing operations before

   income taxes and equity in net income/(loss) of subsidiaries

 

 

(1

)

 

 

77

 

 

 

(19

)

 

 

100

 

 

 

 

 

 

157

 

Benefit/(provision) for income taxes

 

 

 

 

 

(17

)

 

 

(9

)

 

 

(33

)

 

 

 

 

 

(59

)

Equity in net income/(loss) of subsidiaries

 

 

97

 

 

 

47

 

 

 

125

 

 

 

 

 

 

(269

)

 

 

 

Net income/(loss)

 

 

96

 

 

 

107

 

 

 

97

 

 

 

67

 

 

 

(269

)

 

 

98

 

Less net income/(loss) attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

2

 

Net income/(loss) attributable to controlling interest

 

 

96

 

 

 

107

 

 

 

97

 

 

 

65

 

 

 

(269

)

 

 

96

 

Total other comprehensive income/(loss)

 

 

5

 

 

 

4

 

 

 

5

 

 

 

(6

)

 

 

 

 

 

8

 

Total other comprehensive income/(loss) attributable to

   noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

 

 

 

3

 

Total other comprehensive income/(loss) attributable

   to controlling interests

 

 

5

 

 

 

4

 

 

 

5

 

 

 

(9

)

 

 

 

 

 

5

 

Total comprehensive income/(loss)

 

 

101

 

 

 

111

 

 

 

102

 

 

 

61

 

 

 

(269

)

 

 

106

 

Comprehensive income/(loss) attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

5

 

 

 

 

 

 

5

 

Total comprehensive income/(loss) attributable to controlling interest

 

$

101

 

 

$

111

 

 

$

102

 

 

$

56

 

 

$

(269

)

 

$

101

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the nine months ended September 30, 2019

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

Guarantor

 

Guarantor

 

Elimination

 

 

Consolidated

 

 

 

 

Revenues

 

$

 

 

$

 

$

2,659

 

$

2,148

 

$

 

 

$

4,807

 

 

 

 

Cost of revenues, exclusive of depreciation and

   amortization shown separately below

 

 

 

 

 

 

 

1,119

 

 

969

 

 

 

 

 

2,088

 

 

 

 

Selling, general and administrative expenses, exclusive

   of depreciation and amortization shown

   separately below

 

 

3

 

 

 

 

 

698

 

 

729

 

 

 

 

 

1,430

 

 

 

 

Depreciation and amortization

 

 

 

 

 

 

 

446

 

 

104

 

 

 

 

 

550

 

 

 

 

Impairment of goodwill and other long-lived assets

 

 

 

 

 

 

 

419

 

 

585

 

 

 

 

 

1,004

 

 

 

 

Restructuring charges

 

 

 

 

 

 

 

23

 

 

29

 

 

 

 

 

52

 

 

 

 

Operating income/(loss)

 

 

(3

)

 

 

 

 

(46

)

 

(268

)

 

 

 

 

(317

)

 

 

 

Interest income

 

 

1

 

 

 

565

 

 

30

 

 

4

 

 

(596

)

 

 

4

 

 

 

 

Interest expense

 

 

 

 

 

(279

)

 

(586

)

 

(30

)

 

596

 

 

 

(299

)

 

 

 

Foreign currency exchange transaction gains/(losses),

   net

 

 

 

 

 

 

 

 

 

(10

)

 

 

 

 

(10

)

 

 

 

Other income/(expense), net

 

 

 

 

 

 

 

26

 

 

(24

)

 

 

 

 

2

 

 

 

 

Income/(loss) from continuing operations before

   income taxes and equity in net income/(loss) of

   subsidiaries

 

 

(2

)

 

 

286

 

 

(576

)

 

(328

)

 

 

 

 

(620

)

 

 

 

Benefit/(provision) for income taxes

 

 

 

 

 

(77

)

 

607

 

 

(205

)

 

 

 

 

325

 

 

 

 

Equity in net income/(loss) of subsidiaries

 

 

(304

)

 

 

146

 

 

(335

)

 

 

 

493

 

 

 

 

 

 

 

Net income/(loss)

 

 

(306

)

 

 

355

 

 

(304

)

 

(533

)

 

493

 

 

 

(295

)

 

 

 

Less net income/(loss) attributable to noncontrolling

   interests

 

 

 

 

 

 

 

 

 

11

 

 

 

 

 

11

 

 

 

 

Net income/(loss) attributable to controlling interest

 

 

(306

)

 

 

355

 

 

(304

)

 

(544

)

 

493

 

 

 

(306

)

 

 

 

Total other comprehensive income/(loss)

 

 

(56

)

 

 

(13

)

 

(56

)

 

16

 

 

54

 

 

 

(55

)

 

 

 

Total other comprehensive income/(loss) attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

1

 

 

 

 

 

1

 

 

 

 

Total other comprehensive income/(loss) attributable to controlling interests

 

 

(56

)

 

 

(13

)

 

(56

)

 

15

 

 

54

 

 

 

(56

)

 

 

 

Total comprehensive income/(loss)

 

 

(362

)

 

 

342

 

 

(360

)

 

(517

)

 

547

 

 

 

(350

)

 

 

 

Comprehensive income/(loss) attributable to noncontrolling interests

 

 

 

 

 

 

 

 

 

12

 

 

 

 

 

12

 

 

 

 

Total comprehensive income/(loss) attributable to

   controlling interest

 

$

(362

)

 

$

342

 

$

(360

)

$

(529

)

$

547

 

 

$

(362

)

 

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Comprehensive Income (Unaudited)

For the nine months ended September 30, 2018

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

Revenues

 

$

 

 

$

 

 

$

2,654

 

 

$

2,203

 

 

$

 

 

$

4,857

 

Cost of revenues, exclusive of depreciation and

   amortization shown separately below

 

 

 

 

 

 

 

 

1,089

 

 

 

1,009

 

 

 

 

 

 

2,098

 

Selling, general and administrative expenses, exclusive

   of depreciation and amortization shown

   separately below

 

 

3

 

 

 

 

 

 

690

 

 

 

758

 

 

 

 

 

 

1,451

 

Depreciation and amortization

 

 

 

 

 

 

 

 

403

 

 

 

101

 

 

 

 

 

 

504

 

Restructuring charges

 

 

 

 

 

 

 

 

36

 

 

 

72

 

 

 

 

 

 

108

 

Operating income/(loss)

 

 

(3

)

 

 

 

 

 

436

 

 

 

263

 

 

 

 

 

 

696

 

Interest income

 

 

1

 

 

 

486

 

 

 

28

 

 

 

5

 

 

 

(514

)

 

 

6

 

Interest expense

 

 

 

 

 

(276

)

 

 

(504

)

 

 

(29

)

 

 

514

 

 

 

(295

)

Foreign currency exchange transaction gains/(losses),

   net

 

 

 

 

 

 

 

 

 

 

 

(12

)

 

 

 

 

 

(12

)

Other income/(expense), net

 

 

 

 

 

(7

)

 

 

103

 

 

 

(99

)

 

 

 

 

 

(3

)

Income/(loss) from continuing operations before

   income taxes and equity in net income/(loss) of

   subsidiaries and affiliates

 

 

(2

)

 

 

203

 

 

 

63

 

 

 

128

 

 

 

 

 

 

392

 

Benefit/(provision) for income taxes

 

 

 

 

 

(43

)

 

 

(29

)

 

 

(70

)

 

 

 

 

 

(142

)

Equity in net income/(loss) of subsidiaries

 

 

242

 

 

 

132

 

 

 

208

 

 

 

 

 

 

(582

)

 

 

 

Equity in net income/(loss) of affiliates

 

 

 

 

 

 

 

 

 

 

 

(1

)

 

 

 

 

 

(1

)

Net income/(loss)

 

 

240

 

 

 

292

 

 

 

242

 

 

 

57

 

 

 

(582

)

 

 

249

 

Less net income/(loss) attributable to noncontrolling

   interests

 

 

 

 

 

 

 

 

 

 

 

9

 

 

 

 

 

 

9

 

Net income/(loss) attributable to controlling interest

 

 

240

 

 

 

292

 

 

 

242

 

 

 

48

 

 

 

(582

)

 

 

240

 

Total other comprehensive income/(loss)

 

 

(70

)

 

 

25

 

 

 

(70

)

 

 

(98

)

 

 

144

 

 

 

(69

)

Total other comprehensive income/(loss) attributable to

   noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

 

 

 

1

 

Total other comprehensive income/(loss) attributable

   to controlling interests

 

 

(70

)

 

 

25

 

 

 

(70

)

 

 

(99

)

 

 

144

 

 

 

(70

)

Total comprehensive income/(loss)

 

 

170

 

 

 

317

 

 

 

172

 

 

 

(41

)

 

 

(438

)

 

 

180

 

Comprehensive income/(loss) attributable to

   noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

10

 

 

 

 

 

 

10

 

Total comprehensive income/(loss) attributable to

   controlling interest

 

$

170

 

 

$

317

 

 

$

172

 

 

$

(51

)

 

$

(438

)

 

$

170

 

 

 

Consolidating Balance Sheet

Nielsen Holdings plc

Condensed Consolidated Balance Sheet (Unaudited)

September 30, 2019

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

Assets:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cash and cash equivalents

 

$

2

 

 

$

 

 

$

19

 

 

$

368

 

 

$

 

 

$

389

 

Trade and other receivables, net

 

 

 

 

 

 

 

 

440

 

 

 

706

 

 

 

 

 

 

1,146

 

Prepaid expenses and other current assets

 

 

3

 

 

 

 

 

 

279

 

 

 

130

 

 

 

 

 

 

412

 

Intercompany receivables

 

 

4

 

 

 

1,632

 

 

 

283

 

 

 

57

 

 

 

(1,976

)

 

 

 

Total current assets

 

 

9

 

 

 

1,632

 

 

 

1,021

 

 

 

1,261

 

 

 

(1,976

)

 

 

1,947

 

Non-current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Property, plant and equipment, net

 

 

 

 

 

 

 

 

266

 

 

 

157

 

 

 

 

 

 

423

 

Operating lease right-of-use asset

 

 

 

 

 

 

 

 

210

 

 

 

215

 

 

 

 

 

 

425

 

Goodwill

 

 

 

 

 

 

 

 

5,102

 

 

 

871

 

 

 

 

 

 

5,973

 

Other intangible assets, net

 

 

 

 

 

 

 

 

4,410

 

 

 

501

 

 

 

 

 

 

4,911

 

Deferred tax assets

 

 

1

 

 

 

 

 

 

 

 

 

321

 

 

 

 

 

 

322

 

Other non-current assets

 

 

 

 

 

 

 

 

272

 

 

 

70

 

 

 

 

 

 

342

 

Equity investment in subsidiaries

 

 

2,120

 

 

 

1,285

 

 

 

3,077

 

 

 

 

 

 

(6,482

)

 

 

 

Intercompany loans

 

 

25

 

 

 

8,838

 

 

 

873

 

 

 

102

 

 

 

(9,838

)

 

 

 

Total assets

 

$

2,155

 

 

$

11,755

 

 

$

15,231

 

 

$

3,498

 

 

$

(18,296

)

 

$

14,343

 

Liabilities and equity:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Accounts payable and other current liabilities

 

$

 

 

$

102

 

 

$

455

 

 

$

530

 

 

$

 

 

$

1,087

 

Deferred revenues

 

 

 

 

 

 

 

 

190

 

 

$

126

 

 

 

 

 

 

316

 

Income tax liabilities

 

 

 

 

 

 

 

 

28

 

 

$

46

 

 

 

 

 

 

74

 

Current portion of long-term debt, finance lease

   obligations and short-term borrowings

 

 

 

 

 

55

 

 

 

236

 

 

$

7

 

 

 

 

 

 

298

 

Intercompany payables

 

 

 

 

 

5

 

 

 

1,693

 

 

 

278

 

 

 

(1,976

)

 

 

 

Total current liabilities

 

 

 

 

 

162

 

 

 

2,602

 

 

 

987

 

 

 

(1,976

)

 

 

1,775

 

Non-current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-term debt and finance lease obligations

 

 

 

 

 

8,104

 

 

 

74

 

 

 

11

 

 

 

 

 

 

8,189

 

Operating lease liabilities

 

 

 

 

 

 

 

 

228

 

 

 

165

 

 

 

 

 

 

393

 

Deferred tax liabilities

 

 

 

 

 

71

 

 

 

927

 

 

 

70

 

 

 

 

 

 

1,068

 

Intercompany loans

 

 

 

 

 

 

 

 

8,965

 

 

 

873

 

 

 

(9,838

)

 

 

 

Other non-current liabilities

 

 

 

 

 

30

 

 

 

315

 

 

 

220

 

 

 

 

 

 

565

 

Total liabilities

 

 

 

 

 

8,367

 

 

 

13,111

 

 

 

2,326

 

 

 

(11,814

)

 

 

11,990

 

Total stockholders’ equity

 

 

2,155

 

 

 

3,388

 

 

 

2,120

 

 

 

974

 

 

 

(6,482

)

 

 

2,155

 

Noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

198

 

 

 

 

 

 

198

 

Total equity

 

 

2,155

 

 

 

3,388

 

 

 

    2,120

 

 

 

1,172

 

 

 

(6,482

)

 

 

2,353

 

Total liabilities and equity

 

$

2,155

 

 

$

11,755

 

 

$

15,231

 

 

$

3,498

 

 

$

(18,296

)

 

$

14,343

 

Nielsen Holdings plc

Condensed Consolidated Balance Sheet

December 31, 2018

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Elimination

 

 

Consolidated

 

Assets:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cash and cash equivalents

 

$

3

 

 

$

 

 

$

79

 

 

$

442

 

 

$

 

 

$

524

 

Trade and other receivables, net

 

 

 

 

 

1

 

 

 

377

 

 

 

740

 

 

 

 

 

 

1,118

 

Prepaid expenses and other current assets

 

 

 

 

 

3

 

 

 

234

 

 

 

124

 

 

 

 

 

 

361

 

Intercompany receivables

 

 

3

 

 

 

1,310

 

 

 

399

 

 

 

94

 

 

 

(1,806

)

 

 

 

Total current assets

 

 

6

 

 

 

1,314

 

 

 

1,089

 

 

 

1,400

 

 

 

(1,806

)

 

 

2,003

 

Non-current assets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Property, plant and equipment, net

 

 

 

 

 

 

 

 

303

 

 

 

165

 

 

 

 

 

 

468

 

Goodwill

 

 

 

 

 

 

 

 

5,531

 

 

 

1,456

 

 

 

 

 

 

6,987

 

Other intangible assets, net

 

 

 

 

 

 

 

 

4,545

 

 

 

479

 

 

 

 

 

 

5,024

 

Deferred tax assets

 

 

1

 

 

 

 

 

 

 

 

 

332

 

 

 

 

 

 

333

 

Other non-current assets

 

 

 

 

 

19

 

 

 

273

 

 

 

72

 

 

 

 

 

 

364

 

Equity investment in subsidiaries

 

 

2,815

 

 

 

1,232

 

 

 

1,936

 

 

 

 

 

 

(5,983

)

 

 

 

Intercompany loans

 

 

25

 

 

 

8,822

 

 

 

2,220

 

 

 

105

 

 

 

(11,172

)

 

 

 

Total assets

 

$

2,847

 

 

$

11,387

 

 

$

15,897

 

 

$

4,009

 

 

$

(18,961

)

 

$

15,179

 

Liabilities and equity:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Accounts payable and other current liabilities

 

$

 

 

$

62

 

 

$

541

 

 

$

516

 

 

$

 

 

$

1,119

 

Deferred revenues

 

 

 

 

 

 

 

 

225

 

 

 

130

 

 

 

 

 

 

355

 

Income tax liabilities

 

 

 

 

 

 

 

 

20

 

 

 

56

 

 

 

 

 

 

76

 

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

 

 

 

 

 

54

 

 

 

46

 

 

 

7

 

 

 

 

 

 

107

 

Intercompany payables

 

 

 

 

 

 

 

 

1,408

 

 

 

398

 

 

 

(1,806

)

 

 

 

Total current liabilities

 

 

 

 

 

116

 

 

 

2,240

 

 

 

1,107

 

 

 

(1,806

)

 

 

1,657

 

Non-current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-term debt and finance lease obligations

 

 

 

 

 

8,170

 

 

 

95

 

 

 

15

 

 

 

 

 

 

8,280

 

Deferred tax liabilities

 

 

 

 

 

71

 

 

 

956

 

 

 

81

 

 

 

 

 

 

1,108

 

Intercompany loans

 

 

 

 

 

 

 

 

8,952

 

 

 

2,220

 

 

 

(11,172

)

 

 

 

Other non-current liabilities

 

 

 

 

 

3

 

 

 

839

 

 

 

249

 

 

 

 

 

 

1,091

 

Total liabilities

 

 

 

 

 

8,360

 

 

 

13,082

 

 

 

3,672

 

 

 

(12,978

)

 

 

12,136

 

Total shareholders’ equity

 

 

2,847

 

 

 

3,027

 

 

 

2,815

 

 

 

141

 

 

 

(5,983

)

 

 

2,847

 

Noncontrolling interests

 

 

 

 

 

 

 

 

 

 

 

196

 

 

 

 

 

 

196

 

Total equity

 

 

2,847

 

 

 

3,027

 

 

 

2,815

 

 

 

337

 

 

 

(5,983

)

 

 

3,043

 

Total liabilities and equity

 

$

2,847

 

 

$

11,387

 

 

$

15,897

 

 

$

4,009

 

 

$

(18,961

)

 

$

15,179

 

 

 

Consolidating Statement of Cash Flows

Nielsen Holdings plc

Condensed Consolidated Statement of Cash Flows (Unaudited)

For the nine months ended September 30, 2019

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Consolidated

 

Net cash provided by/(used in) operating activities

 

$

(8

)

 

$

63

 

 

$

257

 

 

$

284

 

 

$

596

 

Investing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Acquisition of subsidiaries and affiliates, net of cash acquired

 

 

 

 

 

 

 

 

(11

)

 

 

(51

)

 

 

(62

)

Additions to property, plant and equipment and other assets

 

 

 

 

 

 

 

 

(26

)

 

 

(32

)

 

 

(58

)

Additions to intangible assets

 

 

 

 

 

 

 

 

(229

)

 

 

(55

)

 

 

(284

)

Other investing activities

 

 

 

 

 

 

 

 

(18

)

 

 

 

 

 

(18

)

Net cash used in investing activities

 

 

 

 

 

 

 

 

(284

)

 

 

(138

)

 

 

(422

)

Financing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net borrowings under revolving credit facility

 

 

 

 

 

 

 

 

190

 

 

 

 

 

 

190

 

Repayments of debt

 

 

 

 

 

(43

)

 

 

 

 

 

 

 

 

(43

)

Increase/(decrease) in other short-term borrowings

 

 

 

 

 

 

 

 

 

 

 

(1

)

 

 

(1

)

Cash dividends paid to shareholders

 

 

(373

)

 

 

 

 

 

 

 

 

 

 

 

(373

)

Activity from share-based compensation plans

 

 

 

 

 

 

 

 

(5

)

 

 

 

 

 

(5

)

Proceeds from employee stock purchase plan

 

 

3

 

 

 

 

 

 

 

 

 

 

 

 

3

 

Finance leases

 

 

 

 

 

 

 

 

(40

)

 

 

(4

)

 

 

(44

)

Settlement of intercompany and other financing activities

 

 

377

 

 

 

(20

)

 

 

(178

)

 

 

(196

)

 

 

(17

)

Net cash provided by/(used in) financing activities

 

 

7

 

 

 

(63

)

 

 

(33

)

 

 

(201

)

 

 

(290

)

Effect of exchange-rate changes on cash and cash equivalents

 

 

 

 

 

 

 

 

 

 

 

(19

)

 

 

(19

)

Net increase/(decrease) in cash and cash equivalents

 

 

(1

)

 

 

 

 

 

(60

)

 

 

(74

)

 

 

(135

)

Cash and cash equivalents at beginning of period

 

 

3

 

 

 

 

 

 

79

 

 

 

442

 

 

 

524

 

Cash and cash equivalents at end of period

 

$

2

 

 

$

 

 

$

19

 

 

$

368

 

 

$

389

 

 

Nielsen Holdings plc

Condensed Consolidated Statement of Cash Flows (Unaudited)

For the nine months ended September 30, 2018

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Non-

 

 

 

 

 

(IN MILLIONS)

 

Parent

 

 

Issuers

 

 

Guarantor

 

 

Guarantor

 

 

Consolidated

 

Net cash provided by/(used in) operating activities

 

$

(2

)

 

$

15

 

 

$

257

 

 

$

242

 

 

$

512

 

Investing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Acquisition of subsidiaries and affiliates, net of cash acquired

 

 

 

 

 

 

 

 

(11

)

 

 

(28

)

 

 

(39

)

Additions to property, plant and equipment and other assets

 

 

 

 

 

 

 

 

(34

)

 

 

(32

)

 

 

(66

)

Additions to intangible assets

 

 

 

 

 

 

 

 

(262

)

 

 

(43

)

 

 

(305

)

Proceeds from the sale of property, plant and equipment and

   other assets

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

4

 

Other investing activities

 

 

 

 

 

 

 

 

8

 

 

 

(5

)

 

 

3

 

Net cash used in investing activities

 

 

 

 

 

 

 

 

(299

)

 

 

(104

)

 

 

(403

)

Financing activities:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net borrowings under revolving credit facility

 

 

 

 

 

 

 

 

204

 

 

 

 

 

 

204

 

Repayments of debt

 

 

 

 

 

(804

)

 

 

 

 

 

(1

)

 

 

(805

)

Proceeds from the issuance of debt, net of issuance costs

 

 

 

 

 

781

 

 

 

 

 

 

 

 

 

781

 

Increase in other short-term borrowings

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

1

 

Cash dividends paid to stockholders

 

 

(370

)

 

 

 

 

 

 

 

 

 

 

 

(370

)

Repurchase of common stock

 

 

(70

)

 

 

 

 

 

 

 

 

 

 

 

(70

)

Activity under stock plans

 

 

23

 

 

 

 

 

 

(6

)

 

 

 

 

 

17

 

Proceeds from employee stock purchase plan

 

 

4

 

 

 

 

 

 

 

 

 

 

 

 

4

 

Finance leases

 

 

 

 

 

 

 

 

(55

)

 

 

(5

)

 

 

(60

)

Settlement of intercompany and other financing activities

 

 

416

 

 

 

8

 

 

 

(173

)

 

 

(266

)

 

 

(15

)

Net cash provided by/(used in) financing activities

 

 

3

 

 

 

(15

)

 

 

(30

)

 

 

(271

)

 

 

(313

)

Effect of exchange-rate changes on cash and cash equivalents

 

 

 

 

 

 

 

 

1

 

 

 

(7

)

 

 

(6

)

Net increase/(decrease) in cash and cash equivalents

 

 

1

 

 

 

 

 

 

(71

)

 

 

(140

)

 

 

(210

)

Cash and cash equivalents at beginning of period

 

 

2

 

 

 

1

 

 

 

69

 

 

 

584

 

 

 

656

 

Cash and cash equivalents at end of period

 

$

3

 

 

$

1

 

 

$

(2

)

 

$

444

 

 

$

446