XML 58 R36.htm IDEA: XBRL DOCUMENT v2.4.0.6
Supplemental Guarantor Information Supplemental (Tables)
9 Months Ended
Sep. 29, 2012
Statement of Operations [Member]
 
Schedule of Supplemental Guarantor Information
MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF OPERATIONS
FOR THE THIRTEEN WEEKS ENDED SEPTEMBER 29, 2012
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Sales
$
7.4

 
$
1,311.1

 
$
428.4

 
$
(61.1
)
 
$
1,685.8

Excise taxes

 
(401.4
)
 
(88.9
)
 

 
(490.3
)
Net sales
7.4

 
909.7

 
339.5

 
(61.1
)
 
1,195.5

Cost of goods sold

 
(516.3
)
 
(222.2
)
 
51.5

 
(687.0
)
Gross profit
7.4

 
393.4

 
117.3

 
(9.6
)
 
508.5

Marketing, general and administrative expenses
(28.3
)
 
(208.2
)
 
(73.7
)
 
9.6

 
(300.6
)
Special items, net
(0.3
)
 
(7.0
)
 
(28.6
)
 

 
(35.9
)
Equity income (loss) in subsidiaries
215.7

 
(79.5
)
 
126.4

 
(262.6
)
 

Equity income in MillerCoors

 
132.0

 

 

 
132.0

Operating income (loss)
194.5

 
230.7

 
141.4

 
(262.6
)
 
304.0

Interest income (expense), net
(27.2
)
 
70.8

 
(98.0
)
 

 
(54.4
)
Other income (expense), net
8.8

 
(17.9
)
 
2.7

 

 
(6.4
)
Income (loss) from continuing operations before income taxes
176.1

 
283.6

 
46.1

 
(262.6
)
 
243.2

Income tax benefit (expense)
22.3

 
(66.8
)
 
2.0

 

 
(42.5
)
Net income (loss) from continuing operations
198.4

 
216.8

 
48.1

 
(262.6
)
 
200.7

Income (loss) from discontinued operations, net of tax

 

 
0.7

 

 
0.7

Net income (loss) including noncontrolling interests
198.4

 
216.8

 
48.8

 
(262.6
)
 
201.4

Add back (less): Loss (net income) attributable to noncontrolling interests

 

 
(3.0
)
 

 
(3.0
)
Net income (loss) attributable to MCBC
$
198.4

 
$
216.8

 
$
45.8

 
$
(262.6
)
 
$
198.4

Comprehensive income attributable to MCBC
$
461.7

 
$
449.2

 
$
140.3

 
$
(589.5
)
 
$
461.7

MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF OPERATIONS
FOR THE THIRTY-NINE WEEKS ENDED SEPTEMBER 29, 2012
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Sales
$
20.6

 
$
3,622.7

 
$
651.0

 
$
(159.5
)
 
$
4,134.8

Excise taxes

 
(1,116.1
)
 
(132.4
)
 

 
(1,248.5
)
Net sales
20.6

 
2,506.6

 
518.6

 
(159.5
)
 
2,886.3

Cost of goods sold

 
(1,441.1
)
 
(397.4
)
 
132.6

 
(1,705.9
)
Gross profit
20.6

 
1,065.5

 
121.2

 
(26.9
)
 
1,180.4

Marketing, general and administrative expenses
(113.7
)
 
(629.9
)
 
(136.9
)
 
26.9

 
(853.6
)
Special items, net
(1.4
)
 
(18.2
)
 
(39.0
)
 

 
(58.6
)
Equity income (loss) in subsidiaries
505.9

 
(378.6
)
 
276.1

 
(403.4
)
 

Equity income in MillerCoors

 
436.5

 

 

 
436.5

Operating income (loss)
411.4

 
475.3

 
221.4

 
(403.4
)
 
704.7

Interest income (expense), net
(82.6
)
 
209.0

 
(289.2
)
 

 
(162.8
)
Other income (expense), net
1.7

 
(26.8
)
 
(53.2
)
 

 
(78.3
)
Income (loss) from continuing operations before income taxes
330.5

 
657.5

 
(121.0
)
 
(403.4
)
 
463.6

Income tax benefit (expense)
52.5

 
(157.3
)
 
19.1

 

 
(85.7
)
Net income (loss) from continuing operations
383.0

 
500.2

 
(101.9
)
 
(403.4
)
 
377.9

Income (loss) from discontinued operations, net of tax

 

 
1.6

 

 
1.6

Net income (loss) including noncontrolling interests
383.0

 
500.2

 
(100.3
)
 
(403.4
)
 
379.5

Add back (less): Loss (net income) attributable to noncontrolling interests

 

 
3.5

 

 
3.5

Net income (loss) attributable to MCBC
$
383.0

 
$
500.2

 
$
(96.8
)
 
$
(403.4
)
 
$
383.0

Comprehensive income attributable to MCBC
$
708.0

 
$
794.2

 
$
35.2

 
$
(829.4
)
 
$
708.0

MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF OPERATIONS
FOR THE THIRTY-NINE WEEKS ENDED SEPTEMBER 24, 2011
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Sales
$
20.5

 
$
3,708.6

 
$
189.9

 
$
(144.7
)
 
$
3,774.3

Excise taxes

 
(1,160.9
)
 
(35.0
)
 

 
(1,195.9
)
Net sales
20.5

 
2,547.7

 
154.9

 
(144.7
)
 
2,578.4

Cost of goods sold

 
(1,433.5
)
 
(190.3
)
 
122.2

 
(1,501.6
)
Gross profit
20.5

 
1,114.2

 
(35.4
)
 
(22.5
)
 
1,076.8

Marketing, general and administrative expenses
(89.0
)
 
(638.1
)
 
(54.5
)
 
22.5

 
(759.1
)
Special items, net
(0.6
)
 
(10.3
)
 
(0.1
)
 
(0.1
)
 
(11.1
)
Equity income (loss) in subsidiaries
639.9

 
(344.6
)
 
329.5

 
(624.8
)
 

Equity income in MillerCoors

 
372.4

 

 

 
372.4

Operating income (loss)
570.8

 
493.6

 
239.5

 
(624.9
)
 
679.0

Interest income (expense), net
(25.2
)
 
205.5

 
(262.1
)
 

 
(81.8
)
Other income (expense), net
0.9

 
(7.5
)
 
1.8

 

 
(4.8
)
Income (loss) from continuing operations before income taxes
546.5

 
691.6

 
(20.8
)
 
(624.9
)
 
592.4

Income tax benefit (expense)
(43.4
)
 
(50.7
)
 
3.7

 

 
(90.4
)
Net income (loss) from continuing operations
503.1

 
640.9

 
(17.1
)
 
(624.9
)
 
502.0

Income (loss) from discontinued operations, net of tax

 

 
1.5

 

 
1.5

Net income (loss) including noncontrolling interests
503.1

 
640.9

 
(15.6
)
 
(624.9
)
 
503.5

Add back (less): Loss (net income) attributable to noncontrolling interests

 

 
(0.4
)
 

 
(0.4
)
Net income (loss) attributable to MCBC
$
503.1

 
$
640.9

 
$
(16.0
)
 
$
(624.9
)
 
$
503.1

Comprehensive income attributable to MCBC
$
521.5

 
$
585.0

 
$
9.6

 
$
(594.6
)
 
$
521.5

MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF OPERATIONS
FOR THE THIRTEEN WEEKS ENDED SEPTEMBER 24, 2011
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Sales
$
6.7

 
$
1,367.9

 
$
78.7

 
$
(59.4
)
 
$
1,393.9

Excise taxes

 
(424.0
)
 
(15.5
)
 

 
(439.5
)
Net sales
6.7

 
943.9

 
63.2

 
(59.4
)
 
954.4

Cost of goods sold

 
(528.4
)
 
(73.4
)
 
51.3

 
(550.5
)
Gross profit
6.7

 
415.5

 
(10.2
)
 
(8.1
)
 
403.9

Marketing, general and administrative expenses
(24.5
)
 
(212.2
)
 
(19.6
)
 
8.1

 
(248.2
)
Special items, net
(0.1
)
 
0.2

 
(0.1
)
 
(0.1
)
 
(0.1
)
Equity income (loss) in subsidiaries
230.8

 
(117.1
)
 
152.6

 
(266.3
)
 

Equity income in MillerCoors

 
99.4

 

 

 
99.4

Operating income (loss)
212.9

 
185.8

 
122.7

 
(266.4
)
 
255.0

Interest income (expense), net
(8.4
)
 
70.2

 
(89.1
)
 

 
(27.3
)
Other income (expense), net
(0.4
)
 
(2.8
)
 
0.9

 

 
(2.3
)
Income (loss) from continuing operations before income taxes
204.1

 
253.2

 
34.5

 
(266.4
)
 
225.4

Income tax benefit (expense)
(6.7
)
 
(20.8
)
 
(3.6
)
 

 
(31.1
)
Net income (loss) from continuing operations
197.4

 
232.4

 
30.9

 
(266.4
)
 
194.3

Income (loss) from discontinued operations, net of tax

 

 
2.7

 

 
2.7

Net income (loss) including noncontrolling interests
197.4

 
232.4

 
33.6

 
(266.4
)
 
197.0

Add back (less): Loss (net income) attributable to noncontrolling interests

 

 
0.4

 

 
0.4

Net income (loss) attributable to MCBC
$
197.4

 
$
232.4

 
$
34.0

 
$
(266.4
)
 
$
197.4

Comprehensive income attributable to MCBC
$
78.0

 
$
64.6

 
$
(16.9
)
 
$
(47.7
)
 
$
78.0

Balance Sheet [Member]
 
Schedule of Supplemental Guarantor Information
MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING BALANCE SHEETS
AS OF SEPTEMBER 29, 2012
(IN MILLIONS)
(UNAUDITED)
 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Assets
 
 
 
 
 
 
 
 
 
Current assets:
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$
98.1

 
$
291.3

 
$
196.3

 
$

 
$
585.7

Accounts receivable, net
1.9

 
455.4

 
185.3

 

 
642.6

Other receivables, net
35.3

 
82.5

 
9.3

 

 
127.1

Total inventories, net

 
214.6

 
51.2

 

 
265.8

Other assets, net
9.7

 
78.0

 
42.5

 

 
130.2

Deferred tax assets

 

 
29.9

 
(0.5
)
 
29.4

Intercompany accounts receivable

 
1,863.9

 
887.3

 
(2,751.2
)
 

Total current assets
145.0

 
2,985.7

 
1,401.8

 
(2,751.7
)
 
1,780.8

Properties, net
26.9

 
1,337.1

 
637.0

 

 
2,001.0

Goodwill

 
1,073.4

 
1,342.2

 

 
2,415.6

Other intangibles, net

 
4,672.8

 
2,554.1

 

 
7,226.9

Investment in MillerCoors

 
2,626.6

 

 

 
2,626.6

Net investment in and advances to subsidiaries
11,513.7

 
2,063.7

 
5,899.3

 
(19,476.7
)
 

Deferred tax assets
34.4

 
155.1

 
6.5

 
(34.5
)
 
161.5

Other assets, net
39.5

 
152.9

 
61.7

 

 
254.1

Total assets
$
11,759.5

 
$
15,067.3

 
$
11,902.6

 
$
(22,262.9
)
 
$
16,466.5

Liabilities and equity
 
 
 
 
 
 
 
 
 
Current liabilities:
 
 
 
 
 
 
 
 
 
Accounts payable
$
10.6

 
$
282.2

 
$
196.1

 
$

 
$
488.9

Accrued expenses and other liabilities
63.5

 
558.1

 
166.6

 

 
788.2

Derivative hedging instruments

 
9.7

 
0.1

 

 
9.8

Deferred tax liability
6.6

 
165.4

 
0.3

 
(0.5
)
 
171.8

Current portion of long-term debt and short-term borrowings
559.6

 
671.2

 
27.8

 

 
1,258.6

Discontinued operations

 

 
7.9

 

 
7.9

Intercompany accounts payable
984.1

 
896.8

 
870.3

 
(2,751.2
)
 

Total current liabilities
1,624.4

 
2,583.4

 
1,269.1

 
(2,751.7
)
 
2,725.2

Long-term debt
1,895.6

 
1,421.3

 
121.2

 

 
3,438.1

Pension and post-retirement benefits

 
690.3

 
6.3

 

 
696.6

Derivative hedging instruments

 
226.5

 

 

 
226.5

Deferred tax liability

 

 
938.1

 
(34.5
)
 
903.6

Other liabilities, net
14.3

 
47.7

 
115.1

 

 
177.1

Discontinued operations

 

 
20.2

 

 
20.2

Intercompany notes payable

 
1,136.0

 
6,904.2

 
(8,040.2
)
 

Total liabilities
3,534.3

 
6,105.2

 
9,374.2

 
(10,826.4
)
 
8,187.3

MCBC stockholders' equity
9,084.6

 
15,221.3

 
3,396.0

 
(19,476.7
)
 
8,225.2

Intercompany notes receivable
(859.4
)
 
(6,259.2
)
 
(921.6
)
 
8,040.2

 

Total stockholders' equity
8,225.2

 
8,962.1

 
2,474.4

 
(11,436.5
)
 
8,225.2

Noncontrolling interests

 

 
54.0

 

 
54.0

Total equity
8,225.2

 
8,962.1

 
2,528.4

 
(11,436.5
)
 
8,279.2

Total liabilities and equity
$
11,759.5

 
$
15,067.3

 
$
11,902.6

 
$
(22,262.9
)
 
$
16,466.5

MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING BALANCE SHEETS
AS OF DECEMBER 31, 2011
(IN MILLIONS)
(UNAUDITED)
 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Assets
 
 
 
 
 
 
 
 
 
Current assets:
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$
601.1

 
$
422.5

 
$
55.3

 
$

 
$
1,078.9

Accounts receivable, net
0.9

 
550.8

 
37.1

 

 
588.8

Other receivables, net
46.9

 
84.0

 
6.3

 

 
137.2

Total inventories, net

 
193.0

 
14.2

 

 
207.2

Other assets, net
9.7

 
74.2

 
10.1

 

 
94.0

Deferred tax assets

 

 
12.1

 
(0.5
)
 
11.6

Discontinued operations

 

 
0.3

 

 
0.3

Intercompany accounts receivable

 
1,522.0

 
1,612.9

 
(3,134.9
)
 

Total current assets
658.6

 
2,846.5

 
1,748.3

 
(3,135.4
)
 
2,118.0

Properties, net
27.6

 
1,314.0

 
88.5

 

 
1,430.1

Goodwill

 
1,033.0

 
420.3

 

 
1,453.3

Other intangibles, net

 
4,525.3

 
60.7

 

 
4,586.0

Investment in MillerCoors

 
2,487.9

 

 

 
2,487.9

Net investment in and advances to subsidiaries
7,925.2

 
1,056.3

 
5,363.3

 
(14,344.8
)
 

Deferred tax assets
33.1

 
149.2

 
2.3

 
(34.7
)
 
149.9

Other assets
19.8

 
155.6

 
23.2

 

 
198.6

Total assets
$
8,664.3

 
$
13,567.8

 
$
7,706.6

 
$
(17,514.9
)
 
$
12,423.8

Liabilities and equity
 
 
 
 
 
 
 
 
 
Current liabilities:
 
 
 
 
 
 
 
 
 
Accounts payable
$
7.3

 
$
256.1

 
$
37.8

 
$

 
$
301.2

Accrued expenses and other liabilities
34.6

 
579.9

 
32.3

 

 
646.8

Derivative hedging instruments

 
107.6

 

 

 
107.6

Deferred tax liability
6.2

 
155.6

 

 
(0.5
)
 
161.3

Current portion of long-term debt and short-term borrowings

 
44.7

 
2.2

 

 
46.9

Discontinued operations

 

 
13.4

 

 
13.4

Intercompany accounts payable
413.8

 
1,646.6

 
1,074.5

 
(3,134.9
)
 

Total current liabilities
461.9

 
2,790.5

 
1,160.2

 
(3,135.4
)
 
1,277.2

Long-term debt
546.2

 
1,368.7

 

 

 
1,914.9

Pension and post-retirement benefits

 
693.6

 
3.9

 

 
697.5

Derivative hedging instruments

 
212.5

 

 

 
212.5

Deferred tax liability

 

 
490.3

 
(34.7
)
 
455.6

Other liabilities, net
8.3

 
53.0

 
92.6

 

 
153.9

Discontinued operations

 

 
22.0

 

 
22.0

Intercompany notes payable

 
1,504.0

 
4,971.6

 
(6,475.6
)
 

Total liabilities
1,016.4

 
6,622.3

 
6,740.6

 
(9,645.7
)
 
4,733.6

MCBC stockholders' equity
8,267.8

 
11,917.0

 
1,807.9

 
(14,344.8
)
 
7,647.9

Intercompany notes receivable
(619.9
)
 
(4,971.5
)
 
(884.2
)
 
6,475.6

 

Total stockholders' equity
7,647.9

 
6,945.5

 
923.7

 
(7,869.2
)
 
7,647.9

Noncontrolling interests

 

 
42.3

 

 
42.3

Total equity
7,647.9

 
6,945.5

 
966.0

 
(7,869.2
)
 
7,690.2

Total liabilities and equity
$
8,664.3

 
$
13,567.8

 
$
7,706.6

 
$
(17,514.9
)
 
$
12,423.8

Statement of Cash Flows [Member]
 
Schedule of Supplemental Guarantor Information
MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF CASH FLOWS
FOR THE THIRTY-NINE WEEKS ENDED SEPTEMBER 24, 2011
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Net cash (used in) provided by operating activities
$
173.9

 
$
(484.7
)
 
$
1,042.7

 
$
(128.5
)
 
$
603.4

CASH FLOWS FROM INVESTING ACTIVITIES:
 
 
 
 
 
 
 
 
 
Additions to properties
(2.3
)
 
(98.0
)
 
(26.0
)
 

 
(126.3
)
Proceeds from sales of properties and intangible assets

 
0.3

 
1.2

 

 
1.5

Acquisition of businesses, net of cash acquired

 

 
(41.3
)
 

 
(41.3
)
Change in restricted cash balance

 

 
2.7

 

 
2.7

Investment in MillerCoors

 
(657.3
)
 

 

 
(657.3
)
Return of capital from MillerCoors

 
627.2

 

 

 
627.2

Proceeds from settlements of derivative instruments
15.4

 

 

 

 
15.4

Investment in and advances to an unconsolidated affiliate

 
(93.6
)
 
(5.8
)
 

 
(99.4
)
Trade loan repayments from customers

 
14.2

 

 

 
14.2

Trade loans advanced to customers

 
(7.6
)
 

 

 
(7.6
)
Net intercompany investing activity
(0.9
)
 
2,109.4

 
1,312.5

 
(3,421.0
)
 

Net cash provided by (used in) investing activities
12.2

 
1,894.6

 
1,243.3

 
(3,421.0
)
 
(270.9
)
CASH FLOWS FROM FINANCING ACTIVITIES:
 

 
 

 
 

 
 

 
 

Exercise of stock options under equity compensation plans
8.5

 

 

 

 
8.5

Excess tax benefits from share-based compensation
1.1

 

 

 

 
1.1

Payments for purchase of treasury stock
(271.1
)
 

 

 

 
(271.1
)
Dividends paid
(150.5
)
 

 
(148.1
)
 
128.5

 
(170.1
)
Dividends paid to noncontrolling interest holders

 

 
(2.3
)
 

 
(2.3
)
Debt issuance costs
(2.2
)
 

 

 

 
(2.2
)
Payments on long-term debt and capital lease obligations

 
(0.2
)
 

 

 
(0.2
)
Proceeds from short-term borrowings

 

 
6.8

 

 
6.8

Payments on short-term borrowings

 

 
(18.3
)
 

 
(18.3
)
Payments on settlement of derivative instruments

 
(99.2
)
 

 

 
(99.2
)
Net (payments) proceeds from revolving credit facilities

 

 
1.5

 

 
1.5

Change in overdraft balances and other

 

 
(10.8
)
 

 
(10.8
)
Net intercompany financing activity

 
(1,311.6
)
 
(2,109.4
)
 
3,421.0

 

Net cash provided by (used in) financing activities
(414.2
)
 
(1,411.0
)
 
(2,280.6
)
 
3,549.5

 
(556.3
)
CASH AND CASH EQUIVALENTS:
 
 
 
 
 
 
 
 
 
Net increase (decrease) in cash and cash equivalents
(228.1
)
 
(1.1
)
 
5.4

 

 
(223.8
)
Effect of foreign exchange rate changes on cash and cash equivalents

 
(13.4
)
 
6.8

 

 
(6.6
)
Balance at beginning of year
832.0

 
349.5

 
36.1

 

 
1,217.6

Balance at end of period
$
603.9

 
$
335.0

 
$
48.3

 
$

 
$
987.2

MOLSON COORS BREWING COMPANY AND SUBSIDIARIES
CONDENSED CONSOLIDATING STATEMENT OF CASH FLOWS
FOR THE THIRTY-NINE WEEKS ENDED SEPTEMBER 29, 2012
(IN MILLIONS)
(UNAUDITED)

 
Parent
Guarantor, 2007 and
2012 Issuer
 
Subsidiary
Guarantors
 
Subsidiary
Non
Guarantors
 
Eliminations
 
Consolidated
Net cash provided by (used in) operating activities
$
595.4

 
$
895.6

 
$
(470.0
)
 
$
(181.0
)
 
$
840.0

CASH FLOWS FROM INVESTING ACTIVITIES:
 
 
 
 
 
 
 
 
 
Additions to properties
(6.3
)
 
(103.8
)
 
(33.3
)
 

 
(143.4
)
Proceeds from sales of properties and intangible assets

 
1.6

 
1.4

 

 
3.0

Acquisition of businesses, net of cash acquired

 

 
(2,257.4
)
 

 
(2,257.4
)
Payment on discontinued operations

 

 
(6.8
)
 

 
(6.8
)
Investment in MillerCoors

 
(826.1
)
 

 

 
(826.1
)
Return of capital from MillerCoors

 
723.3

 

 

 
723.3

Payments on settlement of derivative instruments

 
(110.6
)
 

 

 
(110.6
)
Investment in and advances to an unconsolidated affiliate

 
(0.1
)
 
(3.3
)
 

 
(3.4
)
Trade loan repayments from customers

 
14.3

 

 

 
14.3

Trade loans advanced to customers

 
(7.4
)
 

 

 
(7.4
)
Net intercompany investing activity
(2,827.4
)
 
(2,695.0
)
 

 
5,522.4

 

Net cash provided by (used in) investing activities
(2,833.7
)
 
(3,003.8
)
 
(2,299.4
)
 
5,522.4

 
(2,614.5
)
CASH FLOWS FROM FINANCING ACTIVITIES:
 
 
 
 
 
 
 
 
 
Exercise of stock options under equity compensation plans
27.4

 

 

 

 
27.4

Excess tax benefits from share-based compensation
4.2

 

 

 

 
4.2

Dividends paid
(152.5
)
 
(174.2
)
 
(28.3
)
 
181.0

 
(174.0
)
Dividends paid to noncontrolling interests holders

 

 
(5.0
)
 

 
(5.0
)
Debt issuance costs
(39.2
)
 

 
(1.1
)
 

 
(40.3
)
Proceeds from issuances of long-term debt
2,045.4

 

 
150.0

 

 
2,195.4

Payments on long-term debt and capital lease obligations
(150.0
)
 
(44.8
)
 
(31.9
)
 

 
(226.7
)
Payments on debt assumed in acquisition

 

 
(424.3
)
 

 
(424.3
)
Proceeds from short-term borrowings

 

 
14.0

 

 
14.0

Payments on short-term borrowings

 

 
(14.0
)
 

 
(14.0
)
Payments on settlement of derivative instruments

 
(4.0
)
 

 

 
(4.0
)
Net (payments) proceeds from revolving credit facilities

 

 
9.6

 

 
9.6

Change in overdraft balances and other

 

 
(105.0
)
 

 
(105.0
)
Net intercompany financing activity

 
2,184.3

 
3,338.1

 
(5,522.4
)
 

Net cash provided by (used in) financing activities
1,735.3

 
1,961.3

 
2,902.1

 
(5,341.4
)
 
1,257.3

CASH AND CASH EQUIVALENTS:
 
 
 
 
 
 
 
 
 
Net increase (decrease) in cash and cash equivalents
(503.0
)
 
(146.9
)
 
132.7

 

 
(517.2
)
Effect of foreign exchange rate changes on cash and cash equivalents

 
15.7

 
8.3

 

 
24.0

Balance at beginning of year
601.1

 
422.5

 
55.3

 

 
1,078.9

Balance at end of period
$
98.1

 
$
291.3

 
$
196.3

 
$

 
$
585.7