XML 44 R33.htm IDEA: XBRL DOCUMENT v3.7.0.1
Financial Statements of Parent Company Guarantor (Tables)
6 Months Ended
Jun. 30, 2017
Schedule of Condensed Consolidating Statement of Operations and Comprehensive Income (Loss)
Condensed Consolidating Statement of Operations and Comprehensive Income (Loss)
Three months ended June 30, 2017
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Net sales
$
—

$
—

$
—

$
1,265.3

$
—

$
1,265.3

Cost of goods sold
—

—

—

782.1

—

782.1

Gross profit
—

—

—

483.2

—

483.2

Selling, general and administrative
4.3

0.1

0.1

237.2

—

241.7

Research and development
—

—

—

28.7

—

28.7

Operating income (loss)
(4.3
)
(0.1
)
(0.1
)
217.3

—

212.8

Loss (earnings) from continuing operations of investment in subsidiaries

(72.6
)
(72.7
)
(210.9
)
—

356.2

—

Other (income) expense:
 
 
 
 
 
 
Equity income of unconsolidated subsidiaries
—

—

—

(0.4
)
—

(0.4
)
Loss on early extinguishment of debt
—

—

91.0

10.4

—

101.4

Net interest expense
—

—

21.9

3.4

—

25.3

Income (loss) from continuing operations before income taxes
68.3

72.6

97.9

203.9

(356.2
)
86.5

Provision for income taxes
—

—

—

18.2

—

18.2

Net income (loss) from continuing operations
68.3

72.6

97.9

185.7

(356.2
)
68.3

Loss from discontinued operations, net of tax
—

—

—

(5.2
)
—

(5.2
)
Gain from sale of discontinued operations, net of tax
—

—

—

200.6

—

200.6

Earnings (loss) from discontinued operations of investment in subsidiaries
195.4

195.4

195.4

—

(586.2
)
—

Net income (loss)
$
263.7

$
268.0

$
293.3

$
381.1

$
(942.4
)
$
263.7

Comprehensive income (loss), net of tax
 
 
 
 
 
 
Net income (loss)
$
263.7

$
268.0

$
293.3

$
381.1

$
(942.4
)
$
263.7

Changes in cumulative translation adjustment
392.6

392.6

392.6

392.6

(1,177.8
)
392.6

Changes in market value of derivative financial instruments, net of tax

(0.9
)
(0.9
)
(0.9
)
(0.9
)
2.7

(0.9
)
Comprehensive income (loss)
$
655.4

$
659.7

$
685.0

$
772.8

$
(2,117.5
)
$
655.4

ondensed Consolidating Statement of Operations and Comprehensive Income (Loss)
Six months ended June 30, 2017
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Net sales
$
—

$
—

$
—

$
2,448.8

$
—

$
2,448.8

Cost of goods sold
—

—

—

1,543.3

—

1,543.3

Gross profit
—

—

—

905.5

—

905.5

Selling, general and administrative
(3.8
)
0.2

0.4

498.8

—

495.6

Research and development
—

—

—

58.7

—

58.7

Operating income (loss)
3.8

(0.2
)
(0.4
)
348.0

—

351.2

Loss (earnings) from continuing operations of investment in subsidiaries
(145.2
)
(145.4
)
(312.3
)
—

602.9

—

Other (income) expense:
 
 
 
 
 
 
Equity income of unconsolidated subsidiaries
—

—

—

(0.6
)
—

(0.6
)
Loss on early extinguishment of debt
—

—

91.0

10.4

—

101.4

Net interest expense
—

—

50.3

10.0

—

60.3

Income (loss) from continuing operations before income taxes
149.0

145.2

170.6

328.2

(602.9
)
190.1

Provision for income taxes
—

—

—

41.1

—

41.1

Net income (loss) from continuing operations
149.0

145.2

170.6

287.1

(602.9
)
149.0

Loss from discontinued operations, net of tax
—

—

—

1.9

—

1.9

Gain from sale of discontinued operations, net of tax
—

—

—

200.6

—

200.6

Earnings (loss) from discontinued operations of investment in subsidiaries
202.5

202.5

202.5

—

(607.5
)
—

Net income (loss)
$
351.5

$
347.7

$
373.1

$
489.6

$
(1,210.4
)
$
351.5

Comprehensive income (loss), net of tax
 
 
 
 
 
 
Net income (loss)
$
351.5

$
347.7

$
373.1

$
489.6

$
(1,210.4
)
$
351.5

Changes in cumulative translation adjustment
468.3

468.3

468.3

468.3

(1,404.9
)
468.3

Changes in market value of derivative financial instruments, net of tax
0.7

0.7

0.7

0.7

(2.1
)
0.7

Comprehensive income (loss)
$
820.5

$
816.7

$
842.1

$
958.6

$
(2,617.4
)
$
820.5

Condensed Consolidating Statement of Operations and Comprehensive Income (Loss)
Three months ended June 30, 2016
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Net sales
$
—

$
—

$
—

$
1,301.2

$
—

$
1,301.2

Cost of goods sold
—

—

—

819.4

—

819.4

Gross profit
—

—

—

481.8

—

481.8

Selling, general and administrative
—

—

—

249.7

—

249.7

Research and development
—

—

—

28.7

—

28.7

Operating income




203.4

—

203.4

Loss (earnings) from continuing operations of investment in subsidiaries
(132.6
)
(132.6
)
(161.4
)
—

426.6

—

Other (income) expense:
 
 
 
 
 
 
Equity income of unconsolidated subsidiaries
—

—

—

(1.1
)
—

(1.1
)
Net interest expense
—

—

28.8

6.6

—

35.4

Income (loss) from continuing operations before income taxes
132.6

132.6

132.6

197.9

(426.6
)
169.1

Provision (benefit) for income taxes
(0.1
)
—

—

36.5

—

36.4

Net income (loss) from continuing operations
132.7

132.6

132.6

161.4

(426.6
)
132.7

Income from discontinued operations, net of tax
—

—

—

10.1

—

10.1

Earnings (loss) from discontinued operations of investment in subsidiaries
10.1

10.1

10.1

—

(30.3
)
—

Net income (loss)
$
142.8

$
142.7

$
142.7

$
171.5

$
(456.9
)
$
142.8

Comprehensive income (loss), net of tax
 
 
 
 
 
 
Net income (loss)
$
142.8

$
142.7

$
142.7

$
171.5

$
(456.9
)
$
142.8

Changes in cumulative translation adjustment
(25.8
)
(25.8
)
(25.8
)
(25.8
)
77.4

(25.8
)
Changes in market value of derivative financial instruments, net of tax
10.9

10.9

10.9

10.9

(32.7
)
10.9

Comprehensive income (loss)
$
127.9

$
127.8

$
127.8

$
156.6

$
(412.2
)
$
127.9

Condensed Consolidating Statement of Operations and Comprehensive Income (Loss)
Six months ended June 30, 2016
 
 
 
 
 
 
 
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Net sales
$
—

$
—

$
—

$
2,491.2

$
—

$
2,491.2

Cost of goods sold
—

—

—

1,578.1

—

1,578.1

Gross profit
—

—

—

913.1

—

913.1

Selling, general and administrative
7.1

—

0.9

491.8

—

499.8

Research and development
—

—

—

57.2

—

57.2

Operating income (loss)
(7.1
)
—

(0.9
)
364.1

—

356.1

Loss (earnings) from continuing operations of investment in subsidiaries
(231.5
)
(231.5
)
(288.6
)
—

751.6

—

Other (income) expense:
 
 
 
 
 
 
Equity income of unconsolidated subsidiaries
—

—

—

(1.5
)
—

(1.5
)
Net interest expense
—

—

56.2

15.4

—

71.6

Income (loss) from continuing operations before income taxes
224.4

231.5

231.5

350.2

(751.6
)
286.0

Provision (benefit) for income taxes
(0.1
)
—

—

61.6

—

61.5

Net income (loss) from continuing operations
224.5

231.5

231.5

288.6

(751.6
)
224.5

Income from discontinued operations, net of tax
—

—

—

25.7

—

25.7

Earnings (loss) from discontinued operations of investment in subsidiaries
25.7

25.7

25.7

—

(77.1
)
—

Net income (loss)
$
250.2

$
257.2

$
257.2

$
314.3

$
(828.7
)
$
250.2

Comprehensive income (loss), net of tax
 
 
 
 
 
 
Net income (loss)
$
250.2

$
257.2

$
257.2

$
314.3

$
(828.7
)
$
250.2

Changes in cumulative translation adjustment
2.2

2.2

2.2

2.2

(6.6
)
2.2

Changes in market value of derivative financial instruments, net of tax
(3.8
)
(3.8
)
(3.8
)
(3.8
)
11.4

(3.8
)
Comprehensive income (loss)
$
248.6

$
255.6

$
255.6

$
312.7

$
(823.9
)
$
248.6

Schedule of Condensed Consolidating Balance Sheet
Condensed Consolidating Balance Sheet
June 30, 2017
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Assets
Current assets
 
 
 
 
 
 
Cash and cash equivalents
$
0.1

$
—

$
51.0

$
126.7

$
—

$
177.8

Accounts and notes receivable, net
3.4

—

—

761.1

—

764.5

Inventories
—

—

—

565.4

—

565.4

Other current assets
2.3

1.9

—

239.9

3.0

247.1

Total current assets
5.8

1.9

51.0

1,693.1

3.0

1,754.8

Property, plant and equipment, net
—

—

—

550.9

—

550.9

Other assets
 
 
 
 
 
 
Investments in subsidiaries
4,821.0

4,819.2

7,078.4

—

(16,718.6
)
—

Goodwill
—

—

—

4,314.2

—

4,314.2

Intangibles, net
—

—

—

1,624.3

—

1,624.3

Other non-current assets
195.4

1.2

570.6

985.8

(1,328.1
)
424.9

Total other assets
5,016.4

4,820.4

7,649.0

6,924.3

(18,046.7
)
6,363.4

Total assets
$
5,022.2

$
4,822.3

$
7,700.0

$
9,168.3

$
(18,043.7
)
$
8,669.1

Liabilities and Equity
Current liabilities
 
 
 
 
 
 
Current maturities of long-term debt and short-term borrowings
$
—

$
—

$
—

$
0.3

$
—

$
0.3

Accounts payable
0.3

—

—

407.5

—

407.8

Employee compensation and benefits
0.1

—

—

143.7

—

143.8

Other current liabilities
83.4

1.3

21.4

387.4

3.0

496.5

Total current liabilities
83.8

1.3

21.4

938.9

3.0

1,048.4

Other liabilities
 
 
 
 
 
 
Long-term debt
—

—

2,834.0

193.0

(1,328.1
)
1,698.9

Pension and other post-retirement compensation and benefits
—

—

—

268.4

—

268.4

Deferred tax liabilities
—

—

—

546.5

—

546.5

Other non-current liabilities
34.9

—

—

168.5

—

203.4

Total liabilities
118.7

1.3

2,855.4

2,115.3

(1,325.1
)
3,765.6

Equity
4,903.5

4,821.0

4,844.6

7,053.0

(16,718.6
)
4,903.5

Total liabilities and equity
$
5,022.2

$
4,822.3

$
7,700.0

$
9,168.3

$
(18,043.7
)
$
8,669.1

Condensed Consolidating Balance Sheet
December 31, 2016
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Assets
Current assets
 
 
 
 
 
 
Cash and cash equivalents
$
—

$
—

$
—

$
238.5

$
—

$
238.5

Accounts and notes receivable, net
0.1

—

—

763.9

—

764.0

Inventories
—

—

—

524.2

—

524.2

Other current assets
1.2

4.1

1.1

237.8

9.2

253.4

Current assets held for sale
—

—

—

891.9

—

891.9

Total current assets
1.3

4.1

1.1

2,656.3

9.2

2,672.0

Property, plant and equipment, net
—

—

—

538.6

—

538.6

Other assets
 
 
 
 
 
 
Investments in subsidiaries
4,509.5

4,471.4

9,295.5

—

(18,276.4
)
—

Goodwill
—

—

—

4,217.4

—

4,217.4

Intangibles, net
—

—

—

1,631.8

—

1,631.8

Other non-current assets
2.2

35.2

717.8

1,568.9

(2,142.0
)
182.1

Non-current assets held for sale
—

—

—

2,292.9

—

2,292.9

Total other assets
4,511.7

4,506.6

10,013.3

9,711.0

(20,418.4
)
8,324.2

Total assets
$
4,513.0

$
4,510.7

$
10,014.4

$
12,905.9

$
(20,409.2
)
$
11,534.8

Liabilities and Equity
Current liabilities
 
 
 
 
 
 
Current maturities of long-term debt and short-term borrowings
$
—

$
—

$
—

$
0.8

$
—

$
0.8

Accounts payable
0.7

—

0.1

435.8

—

436.6

Employee compensation and benefits
0.8

—

—

165.3

—

166.1

Other current liabilities
95.2

1.2

26.7

379.2

9.2

511.5

Current liabilities held for sale
—

—

—

356.2

—

356.2

Total current liabilities
96.7

1.2

26.8

1,337.3

9.2

1,471.2

Other liabilities
 
 
 
 
 
 
Long-term debt
148.1

—

5,515.9

756.4

(2,142.0
)
4,278.4

Pension and other post-retirement compensation and benefits
—

—

—

253.4

—

253.4

Deferred tax liabilities
—

—

—

609.5

—

609.5

Other non-current liabilities
13.8

—

—

148.2

—

162.0

Non-current liabilities held for sale
—

—

—

505.9

—

505.9

Total liabilities
258.6

1.2

5,542.7

3,610.7

(2,132.8
)
7,280.4

Equity
4,254.4

4,509.5

4,471.7

9,295.2

(18,276.4
)
4,254.4

Total liabilities and equity
$
4,513.0

$
4,510.7

$
10,014.4

$
12,905.9

$
(20,409.2
)
$
11,534.8

Schedule of Condensed Consolidating Statement of Cash Flows
Condensed Consolidating Statement of Cash Flows
Six months ended June 30, 2017
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Operating activities
 
 
 
 
 
 
Net cash provided by (used for) operating activities
$
165.8

$
347.1

$
378.1

$
474.7

$
(1,210.4
)
$
155.3

Investing activities
 
 
 
 
 
 
Capital expenditures
—

—

—

(37.6
)
—

(37.6
)
Proceeds from sale of property and equipment
—

—

—

3.8

—

3.8

Proceeds from sale of businesses, net
—

—

2,765.6

—

—

2,765.6

Acquisitions, net of cash acquired
—

—

—

(59.5
)
—

(59.5
)
Net intercompany loan activity
—

—

170.1

256.2

(426.3
)
—

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

—

2,935.7

162.9

(426.3
)
2,672.3

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

—

—

(6.5
)
—

(6.5
)
Net cash provided by (used for) investing activities
—

—

2,935.7

156.4

(426.3
)
2,665.8

Financing activities
 
 
 
 
 
 
Net repayments of short-term borrowings
—

—

—

(0.5
)
—

(0.5
)
Net repayments of commercial paper and revolving long-term debt
—

—

(298.7
)
(676.8
)
—

(975.5
)
Repayments of long-term debt
—

—

(1,567.8
)
(91.5
)
—

(1,659.3
)
Premium paid on early extinguishment of debt
—

—

(86.0
)
(8.9
)
—

(94.9
)
Net change in advances to subsidiaries
(5.7
)
(347.1
)
(1,356.7
)
72.8

1,636.7

—

Shares issued to employees, net of shares withheld
2.8

—

—

26.7

—

29.5

Repurchases of ordinary shares
(100.0
)
—

—

—

—

(100.0
)
Dividends paid
(62.8
)
—

—

(63.3
)
—

(126.1
)
Net cash provided by (used for) financing activities
(165.7
)
(347.1
)
(3,309.2
)
(741.5
)
1,636.7

(2,926.8
)
Effect of exchange rate changes on cash and cash equivalents
—

—

46.4

(1.4
)
—

45.0

Change in cash and cash equivalents
0.1

—

51.0

(111.8
)
—

(60.7
)
Cash and cash equivalents, beginning of period
—

—

—

238.5

—

238.5

Cash and cash equivalents, end of period
$
0.1

$
—

$
51.0

$
126.7

$
—

$
177.8

Condensed Consolidating Statement of Cash Flows
Six months ended June 30, 2016
In millions
Parent
Company
Guarantor
Subsidiary
Guarantor
Subsidiary
Issuer
Non-guarantor
Subsidiaries
Eliminations
Consolidated
Total
Operating activities
 
 
 
 
 
 
Net cash provided by (used for) operating activities
$
269.2

$
241.3

$
268.6

$
419.2

$
(828.8
)
$
369.5

Investing activities
 
 
 
 
 
 
Capital expenditures
—

—

—

(64.0
)
—

(64.0
)
Proceeds from sale of property and equipment
—

—

—

7.6

—

7.6

Net intercompany loan activity
—

—

431.2

(65.4
)
(365.8
)
—

Other
—

—

—

(3.7
)
—

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

—

431.2

(125.5
)
(365.8
)
(60.1
)
Net cash provided by (used for) investing activities of discontinued operations
—

—

—

(8.0
)
—

(8.0
)
Net cash provided by (used for) investing activities
—

—

431.2

(133.5
)
(365.8
)
(68.1
)
Financing activities
 
 
 
 
 
 
Net repayments of commercial paper and revolving long-term debt
—

—

(123.1
)
(16.7
)
—

(139.8
)
Repayments of long-term debt
—

—

—

(0.7
)
—

(0.7
)
Net change in advances to subsidiaries
(157.8
)
(241.3
)
(579.5
)
(215.9
)
1,194.5

—

Excess tax benefits from share-based compensation
—

—

—

3.2

—

3.2

Shares issued to employees, net of shares withheld
8.3

—

—

—

—

8.3

Dividends paid
(119.7
)
—

—

—

—

(119.7
)
Net cash provided by (used for) financing activities
(269.2
)
(241.3
)
(702.6
)
(230.1
)
1,194.5

(248.7
)
Effect of exchange rate changes on cash and cash equivalents
—

—

2.8

(8.5
)
—

(5.7
)
Change in cash and cash equivalents
—

—

—

47.1

(0.1
)
47.0

Cash and cash equivalents, beginning of period
—

—

0.1

126.2

—

126.3

Cash and cash equivalents, end of period
$
—

$
—

$
0.1

$
173.3

$
(0.1
)
$
173.3