XML 38 R17.htm IDEA: XBRL DOCUMENT v2.4.0.6
Supplemental Guarantor Information
6 Months Ended
Jun. 30, 2012
Supplemental Guarantor Information [Abstract]  
Supplemental Guarantor Information
Supplemental Guarantor Information
The Senior Secured Notes, Senior Subordinated Notes and 2019 Senior Notes are guaranteed by Parent and each of CDW LLC’s direct and indirect, wholly owned, domestic subsidiaries (the “Guarantor Subsidiaries”). All guarantees by Parent and Guarantor Subsidiaries are joint and several, and full and unconditional; provided that each guarantee by the Guarantor Subsidiaries is subject to certain customary release provisions contained in the indentures governing the Senior Secured Notes, Senior Subordinated Notes and 2019 Senior Notes. CDW LLC's Canada subsidiary (the “Non-Guarantor Subsidiary”) does not guarantee the debt obligations. CDW LLC and CDW Finance Corporation, as co-issuers, are wholly owned by Parent, and each of the Guarantor Subsidiaries and the Non-Guarantor Subsidiary is wholly owned by CDW LLC.
The following tables set forth condensed consolidating balance sheets as of June 30, 2012 and December 31, 2011, consolidating statements of operations for the three and six months ended June 30, 2012 and 2011, condensed consolidating statements of comprehensive income (loss) for the three and six months ended June 30, 2012 and 2011, and condensed consolidating statements of cash flows for the six months ended June 30, 2012 and 2011, in accordance with Rule 3-10 of Regulation S-X. The consolidating financial information includes the accounts of CDW Corporation (the “Parent Guarantor”), which has no independent assets or operations, the accounts of CDW LLC (the “Subsidiary Issuer”), the combined accounts of the Guarantor Subsidiaries, the accounts of the Non-Guarantor Subsidiary, and the accounts of CDW Finance Corporation (the “Co-Issuer”) for the periods indicated. The information was prepared on the same basis as the Company’s consolidated financial statements.
 
Condensed Consolidating Balance Sheet
(in millions)
June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Assets
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Current assets:
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$

 
$
142.2

 
$
22.1

 
$
21.2

 
$

 
$
(26.8
)
 
$
158.7

Accounts receivable, net

 

 
1,188.6

 
49.7

 

 

 
1,238.3

Merchandise inventory

 

 
317.3

 
4.3

 

 

 
321.6

Miscellaneous receivables

 
49.1

 
106.6

 
5.0

 

 

 
160.7

Deferred income taxes

 
16.5

 
5.0

 

 

 

 
21.5

Prepaid expenses and other

 
12.5

 
50.7

 
0.3

 

 

 
63.5

Total current assets

 
220.3

 
1,690.3

 
80.5

 

 
(26.8
)
 
1,964.3

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Property and equipment, net

 
72.9

 
66.6

 
2.8

 

 

 
142.3

Goodwill

 
749.4

 
1,428.4

 
30.7

 

 

 
2,208.5

Other intangible assets, net

 
357.8

 
1,191.4

 
8.5

 

 

 
1,557.7

Deferred financing costs, net

 
60.7

 

 

 

 

 
60.7

Other assets
5.7

 
1.2

 
0.8

 
0.3

 

 
(6.0
)
 
2.0

Investment from and advances to subsidiaries
45.4

 
2,868.2

 

 

 

 
(2,913.6
)
 

Total assets
$
51.1

 
$
4,330.5

 
$
4,377.5

 
$
122.8

 
$

 
$
(2,946.4
)
 
$
5,935.5

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Liabilities and Shareholders’ Equity (Deficit)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Current liabilities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Accounts payable—trade
$

 
$
19.1

 
$
671.5

 
$
24.5

 
$

 
$
(26.8
)
 
$
688.3

Accounts payable—inventory financing

 

 
253.2

 

 

 

 
253.2

Deferred revenue

 

 
66.1

 

 

 

 
66.1

Accrued expenses

 
150.6

 
131.8

 
7.5

 

 

 
289.9

Total current liabilities

 
169.7

 
1,122.6

 
32.0

 

 
(26.8
)
 
1,297.5

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Long-term liabilities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Debt

 
3,871.4

 

 

 

 

 
3,871.4

Deferred income taxes

 
190.7

 
469.9

 
1.8

 

 
(5.7
)
 
656.7

Other liabilities

 
53.3

 
3.9

 
1.9

 

 
(0.3
)
 
58.8

Total long-term liabilities

 
4,115.4

 
473.8

 
3.7

 

 
(6.0
)
 
4,586.9

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Total shareholders’ equity (deficit)
51.1

 
45.4

 
2,781.1

 
87.1

 

 
(2,913.6
)
 
51.1

Total liabilities and shareholders’ equity (deficit)
$
51.1

 
$
4,330.5

 
$
4,377.5

 
$
122.8

 
$

 
$
(2,946.4
)
 
$
5,935.5




Condensed Consolidating Balance Sheet
(in millions)
December 31, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Assets
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Current assets:
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$

 
$
102.1

 
$
15.8

 
$
8.1

 
$

 
$
(26.1
)
 
$
99.9

Accounts receivable, net

 

 
1,197.9

 
57.0

 

 

 
1,254.9

Merchandise inventory

 

 
318.0

 
3.7

 

 

 
321.7

Miscellaneous receivables

 
47.3

 
93.3

 
3.0

 

 

 
143.6

Deferred income taxes

 
19.5

 
5.0

 
0.1

 

 

 
24.6

Prepaid expenses and other

 
11.0

 
23.5

 
0.2

 

 

 
34.7

Total current assets

 
179.9

 
1,653.5

 
72.1

 

 
(26.1
)
 
1,879.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Property and equipment, net

 
80.9

 
70.6

 
2.8

 

 

 
154.3

Goodwill

 
749.4

 
1,428.4

 
30.6

 

 

 
2,208.4

Other intangible assets, net

 
366.0

 
1,261.0

 
9.0

 

 

 
1,636.0

Deferred financing costs, net

 
68.5

 

 

 

 

 
68.5

Other assets
6.0

 
1.5

 
1.4

 
0.1

 

 
(6.0
)
 
3.0

Investment from and advances to subsidiaries
(13.3
)
 
3,038.7

 

 

 

 
(3,025.4
)
 

Total assets
$
(7.3
)
 
$
4,484.9

 
$
4,414.9

 
$
114.6

 
$

 
$
(3,057.5
)
 
$
5,949.6

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Liabilities and Shareholders’ (Deficit) Equity
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Current liabilities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Accounts payable-trade
$

 
$
17.6

 
$
503.7

 
$
22.6

 
$

 
$
(26.1
)
 
$
517.8

Accounts payable-inventory financing

 

 
278.7

 

 

 

 
278.7

Current maturities of long-term debt

 
201.0

 

 

 

 

 
201.0

Deferred revenue

 

 
27.8

 

 

 

 
27.8

Accrued expenses

 
162.5

 
146.2

 
7.3

 

 

 
316.0

Total current liabilities

 
381.1

 
956.4

 
29.9

 

 
(26.1
)
 
1,341.3

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Long-term liabilities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Debt

 
3,865.0

 

 

 

 

 
3,865.0

Deferred income taxes

 
199.3

 
496.9

 
1.8

 

 
(6.0
)
 
692.0

Other liabilities

 
52.8

 
4.3

 
1.5

 

 

 
58.6

Total long-term liabilities

 
4,117.1

 
501.2

 
3.3

 

 
(6.0
)
 
4,615.6

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Total shareholders’ (deficit) equity
(7.3
)
 
(13.3
)
 
2,957.3

 
81.4

 

 
(3,025.4
)
 
(7.3
)
Total liabilities and shareholders (deficit) equity
$
(7.3
)
 
$
4,484.9

 
$
4,414.9

 
$
114.6

 
$

 
$
(3,057.5
)
 
5,949.6




Consolidating Statement of Operations
(in millions)
Three Months Ended June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net sales
$

 
$

 
$
2,471.9

 
$
112.8

 
$

 
$

 
$
2,584.7

Cost of sales

 

 
2,059.2

 
98.6

 

 

 
2,157.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Gross profit

 

 
412.7

 
14.2

 

 

 
426.9

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Selling and administrative expenses

 
27.0

 
224.1

 
8.4

 

 

 
259.5

Advertising expense

 

 
29.9

 
1.1

 

 

 
31.0

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income from operations

 
(27.0
)
 
158.7

 
4.7

 

 

 
136.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Interest expense, net

 
(76.9
)
 

 

 

 

 
(76.9
)
Management fee

 
0.8

 

 
(0.8
)
 

 

 

Other income, net

 
0.2

 

 

 

 

 
0.2

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before income taxes

 
(102.9
)
 
158.7

 
3.9

 

 

 
59.7

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Income tax benefit (expense)

 
41.0

 
(62.9
)
 
(1.0
)
 

 

 
(22.9
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before equity in earnings (loss) of subsidiaries

 
(61.9
)
 
95.8

 
2.9

 

 

 
36.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Equity in earnings (loss) of subsidiaries
36.8

 
98.7

 

 

 

 
(135.5
)
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net income (loss)
$
36.8

 
$
36.8

 
$
95.8

 
$
2.9

 
$

 
$
(135.5
)
 
$
36.8








Consolidating Statement of Operations
(in millions)
Three Months Ended June 30, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net sales
$

 
$

 
$
2,319.8

 
$
92.3

 
$

 
$

 
$
2,412.1

Cost of sales

 

 
1,931.5

 
79.8

 

 

 
2,011.3

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Gross profit

 

 
388.3

 
12.5

 

 

 
400.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Selling and administrative expenses

 
24.8

 
211.5

 
7.1

 

 

 
243.4

Advertising expense

 

 
28.3

 
0.9

 

 

 
29.2

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income from operations

 
(24.8
)
 
148.5

 
4.5

 

 

 
128.2

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Interest expense, net

 
(65.7
)
 

 

 

 

 
(65.7
)
Net loss on extinguishment of long-term debt

 
(115.7
)
 

 

 

 

 
(115.7
)
Management fee

 
8.0

 

 
(8.0
)
 

 

 

Other income (expense), net

 
0.1

 
0.2

 
(0.3
)
 

 

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before income taxes

 
(198.1
)
 
148.7

 
(3.8
)
 

 

 
(53.2
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Income tax benefit (expense)

 
76.9

 
(56.7
)
 
(1.8
)
 

 

 
18.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before equity in (loss) earnings of subsidiaries

 
(121.2
)
 
92.0

 
(5.6
)
 

 

 
(34.8
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Equity in (loss) earnings of subsidiaries
(34.8
)
 
86.4

 

 

 

 
(51.6
)
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net (loss) income
$
(34.8
)
 
$
(34.8
)
 
$
92.0

 
$
(5.6
)
 
$

 
$
(51.6
)
 
$
(34.8
)





Consolidating Statement of Operations
(in millions)
Six Months Ended June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net sales
$

 
$

 
$
4,684.9

 
$
219.0

 
$

 
$

 
$
4,903.9

Cost of sales

 

 
3,901.2

 
191.2

 

 

 
4,092.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Gross profit

 

 
783.7

 
27.8

 

 

 
811.5

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Selling and administrative expenses

 
52.8

 
441.3

 
17.0

 

 

 
511.1

Advertising expense

 

 
58.5

 
1.9

 

 

 
60.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income from operations

 
(52.8
)
 
283.9

 
8.9

 

 

 
240.0

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Interest (expense) income, net

 
(156.1
)
 
0.3

 

 

 

 
(155.8
)
Net loss on extinguishments of long-term debt

 
(9.4
)
 

 

 

 

 
(9.4
)
Management fee

 
2.2

 

 
(2.2
)
 

 

 

Other (expense) income, net

 
(0.1
)
 
0.1

 

 

 

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before income taxes

 
(216.2
)
 
284.3

 
6.7

 

 

 
74.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Income tax benefit (expense)

 
89.8

 
(115.1
)
 
(1.8
)
 

 

 
(27.1
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before equity in earnings (loss) of subsidiaries

 
(126.4
)
 
169.2

 
4.9

 

 

 
47.7

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Equity in earnings (loss) of subsidiaries
47.7

 
174.1

 

 

 

 
(221.8
)
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net income (loss)
$
47.7

 
$
47.7

 
$
169.2

 
$
4.9

 
$

 
$
(221.8
)
 
$
47.7






Consolidating Statement of Operations
(in millions)
Six Months Ended June 30, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net sales
$

 
$

 
$
4,351.7

 
$
190.0

 
$

 
$

 
$
4,541.7

Cost of sales

 

 
3,625.2

 
165.3

 

 

 
3,790.5

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Gross profit

 

 
726.5

 
24.7

 

 

 
751.2

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Selling and administrative expenses

 
52.2

 
406.5

 
14.0

 

 

 
472.7

Advertising expense

 

 
56.9

 
1.7

 

 

 
58.6

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income from operations

 
(52.2
)
 
263.1

 
9.0

 

 

 
219.9

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Interest expense, net

 
(157.8
)
 

 

 

 

 
(157.8
)
Net loss on extinguishment of long-term debt

 
(118.9
)
 

 

 

 

 
(118.9
)
Management fee

 
8.0

 

 
(8.0
)
 

 

 

Other income (expense), net

 
0.7

 
0.2

 
(0.4
)
 

 

 
0.5

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before income taxes

 
(320.2
)
 
263.3

 
0.6

 

 

 
(56.3
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Income tax benefit (expense)

 
121.3

 
(100.7
)
 
(3.3
)
 

 

 
17.3

 
 
 
 
 
 
 
 
 
 
 
 
 
 
(Loss) income before equity in (loss) earnings of subsidiaries

 
(198.9
)
 
162.6

 
(2.7
)
 

 

 
(39.0
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Equity in (loss) earnings of subsidiaries
(39.0
)
 
159.9

 

 

 

 
(120.9
)
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net (loss) income
$
(39.0
)
 
$
(39.0
)
 
$
162.6

 
$
(2.7
)
 
$

 
$
(120.9
)
 
$
(39.0
)


















Condensed Consolidating Statement of Comprehensive Income (Loss)
(in millions)
Three Months Ended June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Comprehensive income (loss)
$
35.2

 
$
35.2

 
$
95.8

 
$
1.4

 
$

 
$
(132.4
)
 
$
35.2




























Condensed Consolidating Statement of Comprehensive (Loss) Income
(in millions)
Three Months Ended June 30, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Comprehensive (loss) income
$
(34.3
)
 
$
(34.3
)
 
$
92.2

 
$
(5.1
)
 
$

 
$
(52.8
)
 
$
(34.3
)



























Condensed Consolidating Statement of Comprehensive Income (Loss)
(in millions)
Six Months Ended June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Comprehensive income (loss)
$
48.0

 
$
48.0

 
$
169.2

 
$
5.2

 
$

 
$
(222.4
)
 
$
48.0




























Condensed Consolidating Statement of Comprehensive (Loss) Income
(in millions)
Six Months Ended June 30, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Comprehensive (loss) income
$
(34.1
)
 
$
(34.1
)
 
$
162.8

 
$
0.2

 
$

 
$
(128.9
)
 
$
(34.1
)











Condensed Consolidating Statement of Cash Flows
(in millions)
Six Months Ended June 30, 2012
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net cash (used in) provided by operating activities
$

 
$
(118.3
)
 
$
410.6

 
$
13.1

 
$

 
$
(0.7
)
 
$
304.7

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash flows from investing activities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Capital expenditures

 
(8.8
)
 
(6.5
)
 
(0.4
)
 

 

 
(15.7
)
Net cash used in investing activities

 
(8.8
)
 
(6.5
)
 
(0.4
)
 

 

 
(15.7
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Proceeds from borrowings under revolving credit facility

 
256.0

 

 

 

 

 
256.0

Repayments of borrowings under revolving credit facility

 
(256.0
)
 

 

 

 

 
(256.0
)
Repayments of senior secured term loan facility

 
(201.0
)
 

 

 

 

 
(201.0
)
Proceeds from issuance of Senior Notes

 
135.7

 

 

 

 

 
135.7

Payments to extinguish Senior Notes

 
(136.9
)
 

 

 

 

 
(136.9
)
Net change in accounts payable-inventory financing

 

 
(25.5
)
 

 

 

 
(25.5
)
Advances from (to) affiliates

 
371.8

 
(372.3
)
 
0.5

 

 

 

Other financing activities

 
(2.4
)
 

 

 

 

 
(2.4
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net cash provided by (used in) financing activities

 
167.2

 
(397.8
)
 
0.5

 

 

 
(230.1
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Effect of exchange rate changes on cash and cash equivalents

 

 

 
(0.1
)
 

 

 
(0.1
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net increase (decrease) in cash and cash equivalents

 
40.1

 
6.3

 
13.1

 

 
(0.7
)
 
58.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents—beginning of period

 
102.1

 
15.8

 
8.1

 

 
(26.1
)
 
99.9

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents—end of period
$

 
$
142.2

 
$
22.1

 
$
21.2

 
$

 
$
(26.8
)
 
$
158.7









Condensed Consolidating Statement of Cash Flows
(in millions)
Six Months Ended June 30, 2011
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiary
 
Co-Issuer
 
Consolidating
Adjustments
 
Consolidated
Net cash (used in) provided by operating activities
$

 
$
(63.7
)
 
$
206.5

 
$
(3.8
)
 
$

 
$
(9.2
)
 
$
129.8

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash flows from investing activities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Capital expenditures

 
(12.1
)
 
(4.6
)
 

 

 

 
(16.7
)
Cash settlements on interest rate swap agreements

 
(6.6
)
 

 

 

 

 
(6.6
)
Premium payments on interest rate cap agreements

 
(3.2
)
 

 

 

 

 
(3.2
)
Net cash used in investing activities

 
(21.9
)
 
(4.6
)
 

 

 

 
(26.5
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
 
 
 
 
Proceeds from borrowings under revolving credit facility

 
755.0

 

 

 

 

 
755.0

Repayments of borrowings under revolving credit facility

 
(783.1
)
 

 

 

 

 
(783.1
)
Repayments of senior secured term loan facility

 
(132.0
)
 

 

 

 

 
(132.0
)
Proceeds from issuance of Senior Notes

 
1,175.0

 

 

 

 

 
1,175.0

Payments to extinguish Senior Notes

 
(1,175.0
)
 

 

 

 

 
(1,175.0
)
Net change in accounts payable-inventory financing

 

 
89.9

 

 

 

 
89.9

Advances from (to) affiliates

 
292.3

 
(292.3
)
 

 

 

 

Other financing activities

 
(25.5
)
 

 

 

 

 
(25.5
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net cash provided by (used in) financing activities

 
106.7

 
(202.4
)
 

 

 

 
(95.7
)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Effect of exchange rate changes on cash and cash equivalents

 

 

 
0.4

 

 

 
0.4

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net increase (decrease) in cash and cash equivalents

 
21.1

 
(0.5
)
 
(3.4
)
 

 
(9.2
)
 
8.0

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents—beginning of period

 
32.9

 
1.1

 
10.0

 

 
(7.4
)
 
36.6

 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents—end of period
$

 
$
54.0

 
$
0.6

 
$
6.6

 
$

 
$
(16.6
)
 
$
44.6