XML 36 R42.htm IDEA: XBRL DOCUMENT
v3.19.3.a.u2

Supplemental Guarantor Information (Tables) | 12 Months Ended
--- | ---
Dec. 31, 2019
Supplemental Guarantor Information [Abstract] |
Schedule of Condensed Balance Sheet |
Condensed Consolidating Balance Sheet
December 31, 2019
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Assets |  |  |  |  |  |  |  |  |  |  |  |  |
Current assets: |  |  |  |  |  |  |  |  |  |  |  |  |
Cash and cash equivalents | $ | — |  |  | $ | 73.9 |  |  | $ | — |  |  | $ | 98.9 |  |  | $ | — |  |  | $ | (18.8 | ) |  | $ | 154.0 |
Accounts receivable, net | — |  |  | — |  |  | 2,517.0 |  |  | 485.2 |  |  | — |  |  | — |  |  | 3,002.2 |
Merchandise inventory | — |  |  | — |  |  | 524.9 |  |  | 86.3 |  |  | — |  |  | — |  |  | 611.2 |
Miscellaneous receivables | — |  |  | 97.9 |  |  | 265.9 |  |  | 31.3 |  |  | — |  |  | — |  |  | 395.1 |
Prepaid expenses and other | — |  |  | 22.1 |  |  | 99.9 |  |  | 49.6 |  |  | — |  |  | — |  |  | 171.6 |
Total current assets | — |  |  | 193.9 |  |  | 3,407.7 |  |  | 751.3 |  |  | — |  |  | (18.8 | ) |  | 4,334.1 |
Operating lease right-of-use assets | — |  |  | 75.4 |  |  | 29.1 |  |  | 27.3 |  |  | — |  |  | — |  |  | 131.8 |
Property and equipment, net | — |  |  | 73.3 |  |  | 259.0 |  |  | 30.8 |  |  | — |  |  | — |  |  | 363.1 |
Goodwill | — |  |  | 751.8 |  |  | 1,454.3 |  |  | 346.9 |  |  | — |  |  | — |  |  | 2,553.0 |
Other intangible assets, net | — |  |  | 242.9 |  |  | 177.6 |  |  | 173.6 |  |  | — |  |  | — |  |  | 594.1 |
Other assets | 1.4 |  |  | 25.7 |  |  | 20.1 |  |  | 171.9 |  |  | — |  |  | (195.8 | ) |  | 23.3 |
Investment in and advances to subsidiaries | 958.9 |  |  | 3,342.9 |  |  | — |  |  | — |  |  | — |  |  | (4,301.8 | ) |  | — |
Total Assets | $ | 960.3 |  |  | $ | 4,705.9 |  |  | $ | 5,347.8 |  |  | $ | 1,501.8 |  |  | $ | — |  |  | $ | (4,516.4 | ) |  | $ | 7,999.4 |
Liabilities and Stockholders' Equity |  |  |  |  |  |  |  |  |  |  |  |  |
Current liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Accounts payable-trade | $ | — |  |  | $ | 46.5 |  |  | $ | 1,525.7 |  |  | $ | 281.6 |  |  | $ | — |  |  | $ | (18.8 | ) |  | $ | 1,835.0 |
Accounts payable-inventory financing | — |  |  | 0.1 |  |  | 378.9 |  |  | 50.9 |  |  | — |  |  | — |  |  | 429.9 |
Current maturities of long-term debt | — |  |  | 14.9 |  |  | 12.4 |  |  | 6.8 |  |  | — |  |  | — |  |  | 34.1 |
Contract liabilities | — |  |  | — |  |  | 146.4 |  |  | 105.8 |  |  | — |  |  | — |  |  | 252.2 |
Accrued expenses and other current liabilities | — |  |  | 291.3 |  |  | 559.1 |  |  | 89.8 |  |  | — |  |  | — |  |  | 940.2 |
Total current liabilities | — |  |  | 352.8 |  |  | 2,622.5 |  |  | 534.9 |  |  | — |  |  | (18.8 | ) |  | 3,491.4 |
Long-term liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Debt | — |  |  | 3,229.5 |  |  | — |  |  | 53.7 |  |  | — |  |  | — |  |  | 3,283.2 |
Deferred income taxes | — |  |  | 49.7 |  |  | — |  |  | 29.9 |  |  | — |  |  | (17.2 | ) |  | 62.4 |
Operating lease liabilities | — |  |  | 84.9 |  |  | 22.9 |  |  | 23.3 |  |  | — |  |  | — |  |  | 131.1 |
Other liabilities | — |  |  | 30.1 |  |  | 0.7 |  |  | 218.8 |  |  | — |  |  | (178.6 | ) |  | 71.0 |
Total long-term liabilities | — |  |  | 3,394.2 |  |  | 23.6 |  |  | 325.7 |  |  | — |  |  | (195.8 | ) |  | 3,547.7 |
Total stockholders' equity | 960.3 |  |  | 958.9 |  |  | 2,701.7 |  |  | 641.2 |  |  | — |  |  | (4,301.8 | ) |  | 960.3 |
Total Liabilities and Stockholders' Equity | $ | 960.3 |  |  | $ | 4,705.9 |  |  | $ | 5,347.8 |  |  | $ | 1,501.8 |  |  | $ | — |  |  | $ | (4,516.4 | ) |  | $ | 7,999.4 |
Condensed Consolidating Balance Sheet
December 31, 2018
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Assets |  |  |  |  |  |  |  |  |  |  |  |  |
Current assets: |  |  |  |  |  |  |  |  |  |  |  |  |
Cash and cash equivalents | $ | — |  |  | $ | 176.0 |  |  | $ | — |  |  | $ | 46.7 |  |  | $ | — |  |  | $ | (16.9 | ) |  | $ | 205.8 |
Accounts receivable, net | — |  |  | — |  |  | 2,331.2 |  |  | 340.0 |  |  | — |  |  | — |  |  | 2,671.2 |
Merchandise inventory | — |  |  | — |  |  | 387.4 |  |  | 66.9 |  |  | — |  |  | — |  |  | 454.3 |
Miscellaneous receivables | — |  |  | 110.6 |  |  | 187.7 |  |  | 18.1 |  |  | — |  |  | — |  |  | 316.4 |
Prepaid expenses and other | — |  |  | 17.1 |  |  | 93.8 |  |  | 38.2 |  |  | — |  |  | — |  |  | 149.1 |
Total current assets | — |  |  | 303.7 |  |  | 3,000.1 |  |  | 509.9 |  |  | — |  |  | (16.9 | ) |  | 3,796.8 |
Property and equipment, net | — |  |  | 82.3 |  |  | 52.0 |  |  | 21.8 |  |  | — |  |  | — |  |  | 156.1 |
Goodwill | — |  |  | 751.8 |  |  | 1,437.8 |  |  | 273.2 |  |  | — |  |  | — |  |  | 2,462.8 |
Other intangible assets, net | — |  |  | 252.5 |  |  | 300.0 |  |  | 159.7 |  |  | — |  |  | — |  |  | 712.2 |
Other assets | 1.4 |  |  | 49.8 |  |  | 9.6 |  |  | 140.2 |  |  | — |  |  | (161.2 | ) |  | 39.8 |
Investment in and advances to subsidiaries | 973.8 |  |  | 3,028.9 |  |  | — |  |  | — |  |  | — |  |  | (4,002.7 | ) |  | — |
Total Assets | $ | 975.2 |  |  | $ | 4,469.0 |  |  | $ | 4,799.5 |  |  | $ | 1,104.8 |  |  | $ | — |  |  | $ | (4,180.8 | ) |  | $ | 7,167.7 |
Liabilities and Stockholders' Equity |  |  |  |  |  |  |  |  |  |  |  |  |
Current liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Accounts payable-trade | $ | — |  |  | $ | 39.2 |  |  | $ | 1,387.9 |  |  | $ | 166.9 |  |  | $ | — |  |  | $ | (16.9 | ) |  | $ | 1,577.1 |
Accounts payable-inventory financing | — |  |  | 0.2 |  |  | 406.1 |  |  | 23.0 |  |  | — |  |  | — |  |  | 429.3 |
Current maturities of long-term debt | — |  |  | 14.9 |  |  | 4.0 |  |  | 6.4 |  |  | — |  |  | — |  |  | 25.3 |
Contract liabilities | — |  |  | — |  |  | 95.6 |  |  | 82.7 |  |  | — |  |  | — |  |  | 178.3 |
Accrued expenses and other current liabilities | — |  |  | 217.6 |  |  | 306.7 |  |  | 68.8 |  |  | — |  |  | — |  |  | 593.1 |
Total current liabilities | — |  |  | 271.9 |  |  | 2,200.3 |  |  | 347.8 |  |  | — |  |  | (16.9 | ) |  | 2,803.1 |
Long-term liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Debt | — |  |  | 3,121.3 |  |  | 4.3 |  |  | 57.7 |  |  | — |  |  | — |  |  | 3,183.3 |
Deferred income taxes | — |  |  | 55.9 |  |  | 60.5 |  |  | 26.9 |  |  | — |  |  | (1.4 | ) |  | 141.9 |
Other liabilities | — |  |  | 46.1 |  |  | 5.7 |  |  | 172.2 |  |  | — |  |  | (159.8 | ) |  | 64.2 |
Total long-term liabilities | — |  |  | 3,223.3 |  |  | 70.5 |  |  | 256.8 |  |  | — |  |  | (161.2 | ) |  | 3,389.4 |
Total stockholders' equity | 975.2 |  |  | 973.8 |  |  | 2,528.7 |  |  | 500.2 |  |  | — |  |  | (4,002.7 | ) |  | 975.2 |
Total Liabilities and Stockholders' Equity | $ | 975.2 |  |  | $ | 4,469.0 |  |  | $ | 4,799.5 |  |  | $ | 1,104.8 |  |  | $ | — |  |  | $ | (4,180.8 | ) |  | $ | 7,167.7 |
Schedule of Condensed Income Statement |
Consolidating Statement of Operations
Year Ended December 31, 2019
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 15,874.1 |  |  | $ | 2,158.3 |  |  | $ | — |  |  | $ | — |  |  | $ | 18,032.4 |
Cost of sales | — |  |  | — |  |  | 13,207.3 |  |  | 1,785.2 |  |  | — |  |  | — |  |  | 14,992.5 |
Gross profit | — |  |  | — |  |  | 2,666.8 |  |  | 373.1 |  |  | — |  |  | — |  |  | 3,039.9 |
Selling and administrative expenses | — |  |  | 136.4 |  |  | 1,317.5 |  |  | 259.2 |  |  | — |  |  | — |  |  | 1,713.1 |
Advertising expense | — |  |  | — |  |  | 180.8 |  |  | 12.4 |  |  | — |  |  | — |  |  | 193.2 |
Operating income (loss) | — |  |  | (136.4 | ) |  | 1,168.5 |  |  | 101.5 |  |  | — |  |  | — |  |  | 1,133.6 |
Interest (expense) income, net | — |  |  | (158.1 | ) |  | 0.3 |  |  | (1.6 | ) |  | — |  |  | — |  |  | (159.4 | )
Other (expense) income, net | — |  |  | (21.9 | ) |  | 2.1 |  |  | (4.7 | ) |  | — |  |  | — |  |  | (24.5 | )
Income (loss) before income taxes | — |  |  | (316.4 | ) |  | 1,170.9 |  |  | 95.2 |  |  | — |  |  | — |  |  | 949.7 |
Income tax (expense) benefit | — |  |  | 87.4 |  |  | (285.2 | ) |  | (15.1 | ) |  | — |  |  | — |  |  | (212.9 | )
Income (loss) before equity in earnings of subsidiaries | — |  |  | (229.0 | ) |  | 885.7 |  |  | 80.1 |  |  | — |  |  | — |  |  | 736.8 |
Equity in earnings of subsidiaries | 736.8 |  |  | 965.8 |  |  | — |  |  | — |  |  | — |  |  | (1,702.6 | ) |  | — |
Net income | $ | 736.8 |  |  | $ | 736.8 |  |  | $ | 885.7 |  |  | $ | 80.1 |  |  | $ | — |  |  | $ | (1,702.6 | ) |  | $ | 736.8 |
Consolidating Statement of Operations
Year Ended December 31, 2018
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 14,356.8 |  |  | $ | 1,883.7 |  |  | $ | — |  |  | $ | — |  |  | $ | 16,240.5 |
Cost of sales | — |  |  | — |  |  | 11,962.7 |  |  | 1,570.9 |  |  | — |  |  | — |  |  | 13,533.6 |
Gross profit | — |  |  | — |  |  | 2,394.1 |  |  | 312.8 |  |  | — |  |  | — |  |  | 2,706.9 |
Selling and administrative expenses | — |  |  | 138.3 |  |  | 1,176.8 |  |  | 222.0 |  |  | — |  |  | — |  |  | 1,537.1 |
Advertising expense | — |  |  | — |  |  | 173.9 |  |  | 8.6 |  |  | — |  |  | — |  |  | 182.5 |
Operating income (loss) | — |  |  | (138.3 | ) |  | 1,043.4 |  |  | 82.2 |  |  | — |  |  | — |  |  | 987.3 |
Interest (expense) income, net | — |  |  | (146.7 | ) |  | 3.5 |  |  | (5.4 | ) |  | — |  |  | — |  |  | (148.6 | )
Other income (expense), net | — |  |  | (0.2 | ) |  | 0.7 |  |  | 1.3 |  |  | — |  |  | — |  |  | 1.8 |
Income (loss) before income taxes | — |  |  | (285.2 | ) |  | 1,047.6 |  |  | 78.1 |  |  | — |  |  | — |  |  | 840.5 |
Income tax (expense) benefit | (0.4 | ) |  | 67.0 |  |  | (249.8 | ) |  | (14.3 | ) |  | — |  |  | — |  |  | (197.5 | )
Income (loss) before equity in earnings of subsidiaries | (0.4 | ) |  | (218.2 | ) |  | 797.8 |  |  | 63.8 |  |  | — |  |  | — |  |  | 643.0 |
Equity in earnings of subsidiaries | 643.4 |  |  | 861.6 |  |  | — |  |  | — |  |  | — |  |  | (1,505.0 | ) |  | — |
Net income | $ | 643.0 |  |  | $ | 643.4 |  |  | $ | 797.8 |  |  | $ | 63.8 |  |  | $ | — |  |  | $ | (1,505.0 | ) |  | $ | 643.0 |
Consolidating Statement of Operations
Year Ended December 31, 2017
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 13,299.8 |  |  | $ | 1,533.1 |  |  | $ | — |  |  | $ | — |  |  | $ | 14,832.9 |
Cost of sales | — |  |  | — |  |  | 11,103.5 |  |  | 1,279.2 |  |  | — |  |  | — |  |  | 12,382.7 |
Gross profit | — |  |  | — |  |  | 2,196.3 |  |  | 253.9 |  |  | — |  |  | — |  |  | 2,450.2 |
Selling and administrative expenses | — |  |  | 127.2 |  |  | 1,093.3 |  |  | 189.5 |  |  | — |  |  | — |  |  | 1,410.0 |
Advertising expense | — |  |  | — |  |  | 166.4 |  |  | 7.3 |  |  | — |  |  | — |  |  | 173.7 |
Operating income (loss) | — |  |  | (127.2 | ) |  | 936.6 |  |  | 57.1 |  |  | — |  |  | — |  |  | 866.5 |
Interest (expense) income, net | — |  |  | (148.3 | ) |  | 4.1 |  |  | (6.3 | ) |  | — |  |  | — |  |  | (150.5 | )
Other (expense) income, net | — |  |  | (57.5 | ) |  | 0.7 |  |  | 1.5 |  |  | — |  |  | — |  |  | (55.3 | )
Income (loss) before income taxes | — |  |  | (333.0 | ) |  | 941.4 |  |  | 52.3 |  |  | — |  |  | — |  |  | 660.7 |
Income tax (expense) benefit | (0.9 | ) |  | 149.9 |  |  | (270.2 | ) |  | (16.4 | ) |  | — |  |  | — |  |  | (137.6 | )
Income (loss) before equity in earnings of subsidiaries | (0.9 | ) |  | (183.1 | ) |  | 671.2 |  |  | 35.9 |  |  | — |  |  | — |  |  | 523.1 |
Equity in earnings of subsidiaries | 524.0 |  |  | 707.1 |  |  | — |  |  | — |  |  | — |  |  | (1,231.1 | ) |  | — |
Net income | $ | 523.1 |  |  | $ | 524.0 |  |  | $ | 671.2 |  |  | $ | 35.9 |  |  | $ | — |  |  | $ | (1,231.1 | ) |  | $ | 523.1 |
Schedule of Condensed Comprehensive Income (Loss) |
Condensed Consolidating Statement of Comprehensive Income
Year Ended December 31, 2019
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 749.6 |  |  | $ | 749.6 |  |  | $ | 885.7 |  |  | $ | 102.5 |  |  | $ | — |  |  | $ | (1,737.8 | ) |  | $ | 749.6 |
Condensed Consolidating Statement of Comprehensive Income
Year Ended December 31, 2018
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 608.3 |  |  | $ | 608.7 |  |  | $ | 797.8 |  |  | $ | 31.1 |  |  | $ | — |  |  | $ | (1,437.6 | ) |  | $ | 608.3 |
Condensed Consolidating Statement of Comprehensive Income
Year Ended December 31, 2017
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 567.0 |  |  | $ | 567.9 |  |  | $ | 671.2 |  |  | $ | 79.6 |  |  | $ | — |  |  | $ | (1,318.7 | ) |  | $ | 567.0 |
Schedule of Condensed Cash Flow Statement |
Condensed Consolidating Statement of Cash Flows
Year Ended December 31, 2019
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net cash provided by (used in) operating activities | $ | — |  |  | $ | 14.8 |  |  | $ | 927.8 |  |  | $ | 97.1 |  |  | $ | — |  |  | $ | (12.5 | ) |  | $ | 1,027.2 |
Cash flows used in investing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Capital expenditures | — |  |  | (61.5 | ) |  | (160.4 | ) |  | (14.4 | ) |  | — |  |  | — |  |  | (236.3 | )
Acquisition of businesses, net of cash acquired | — |  |  | — |  |  | (20.1 | ) |  | (75.0 | ) |  | — |  |  | — |  |  | (95.1 | )
Net cash used in investing activities | — |  |  | (61.5 | ) |  | (180.5 | ) |  | (89.4 | ) |  | — |  |  | — |  |  | (331.4 | )
Cash flows (used in) provided by: financing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Proceeds from borrowings under revolving credit facility | — |  |  | 2,445.5 |  |  | — |  |  | — |  |  | — |  |  | — |  |  | 2,445.5 |
Repayments of borrowings under revolving credit facility | — |  |  | (2,394.5 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (2,394.5 | )
Repayments of long-term debt | — |  |  | (14.9 | ) |  | — |  |  | (8.6 | ) |  | — |  |  | — |  |  | (23.5 | )
Proceeds from issuance of long-term debt | — |  |  | 600.0 |  |  | — |  |  | — |  |  | — |  |  | — |  |  | 600.0 |
Payments to extinguish long-term debt | — |  |  | (539.0 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (539.0 | )
Net change in accounts payable-inventory financing | — |  |  | — |  |  | (27.3 | ) |  | 26.0 |  |  | — |  |  | — |  |  | (1.3 | )
Repurchases of common stock | (657.2 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (657.2 | )
Payment of incentive compensation plan withholding taxes | (21.4 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (21.4 | )
Dividend payments | (183.4 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (183.4 | )
Capital contributions | — |  |  | (76.0 | ) |  | — |  |  | 76.0 |  |  | — |  |  | — |  |  | — |
Other | — |  |  | 35.5 |  |  | (10.2 | ) |  | (0.3 | ) |  | — |  |  | — |  |  | 25.0 |
Distributions and advances from (to) affiliates | 862.0 |  |  | (112.0 | ) |  | (709.8 | ) |  | (50.8 | ) |  | — |  |  | 10.6 |  |  | — |
Net cash (used in) provided by financing activities | — |  |  | (55.4 | ) |  | (747.3 | ) |  | 42.3 |  |  | — |  |  | 10.6 |  |  | (749.8 | )
Effect of exchange rate changes on cash and cash equivalents | — |  |  | — |  |  | — |  |  | 2.2 |  |  | — |  |  | — |  |  | 2.2 |
Net (decrease) increase in cash and cash equivalents | — |  |  | (102.1 | ) |  | — |  |  | 52.2 |  |  | — |  |  | (1.9 | ) |  | (51.8 | )
Cash and cash equivalents – beginning of period | — |  |  | 176.0 |  |  | — |  |  | 46.7 |  |  | — |  |  | (16.9 | ) |  | 205.8 |
Cash and cash equivalents – end of period | $ | — |  |  | $ | 73.9 |  |  | $ | — |  |  | $ | 98.9 |  |  | $ | — |  |  | $ | (18.8 | ) |  | $ | 154.0 |
Condensed Consolidating Statement of Cash Flows
Year Ended December 31, 2018
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net cash provided by (used in) operating activities | $ | — |  |  | $ | (85.7 | ) |  | $ | 1,073.6 |  |  | $ | 75.0 |  |  | $ | — |  |  | $ | (157.0 | ) |  | $ | 905.9 |
Cash flows used in investing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Capital expenditures | — |  |  | (40.8 | ) |  | (34.5 | ) |  | (10.8 | ) |  | — |  |  | — |  |  | (86.1 | )
Net cash used in investing activities | — |  |  | (40.8 | ) |  | (34.5 | ) |  | (10.8 | ) |  | — |  |  | — |  |  | (86.1 | )
Cash flows (used in) provided by financing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Proceeds from borrowings under revolving credit facility | — |  |  | 640.0 |  |  | — |  |  | 46.7 |  |  | — |  |  | — |  |  | 686.7 |
Repayments of borrowings under revolving credit facility | — |  |  | (640.0 | ) |  | — |  |  | (46.7 | ) |  | — |  |  | — |  |  | (686.7 | )
Repayments of long-term debt | — |  |  | (14.9 | ) |  | — |  |  | (6.7 | ) |  | — |  |  | — |  |  | (21.6 | )
Net change in accounts payable-inventory financing | — |  |  | (0.8 | ) |  | (74.7 | ) |  | 8.1 |  |  | — |  |  | — |  |  | (67.4 | )
Repurchases of common stock | (522.3 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (522.3 | )
Payment of incentive compensation plan withholding taxes | (33.9 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (33.9 | )
Dividend payments | (139.4 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (139.4 | )
Repayment of intercompany loan | — |  |  | — |  |  | 47.5 |  |  | (47.5 | ) |  | — |  |  | — |  |  | — |
Other | — |  |  | 34.6 |  |  | (4.4 | ) |  | (0.4 | ) |  | — |  |  | — |  |  | 29.8 |
Distributions and advances from (to) affiliates | 695.6 |  |  | 169.9 |  |  | (1,007.5 | ) |  | — |  |  | — |  |  | 142.0 |  |  | — |
Net cash (used in) provided by financing activities | — |  |  | 188.8 |  |  | (1,039.1 | ) |  | (46.5 | ) |  | — |  |  | 142.0 |  |  | (754.8 | )
Effect of exchange rate changes on cash and cash equivalents | — |  |  | — |  |  | — |  |  | (3.4 | ) |  | — |  |  | — |  |  | (3.4 | )
Net increase in cash and cash equivalents | — |  |  | 62.3 |  |  | — |  |  | 14.3 |  |  | — |  |  | (15.0 | ) |  | 61.6 |
Cash and cash equivalents—beginning of period | — |  |  | 113.7 |  |  | — |  |  | 32.4 |  |  | — |  |  | (1.9 | ) |  | 144.2 |
Cash and cash equivalents—end of period | $ | — |  |  | $ | 176.0 |  |  | $ | — |  |  | $ | 46.7 |  |  | $ | — |  |  | $ | (16.9 | ) |  | $ | 205.8 |
Condensed Consolidating Statement of Cash Flows
Year Ended December 31, 2017
| Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net cash provided by (used in) operating activities | $ | 0.6 |  |  | $ | (71.1 | ) |  | $ | 788.5 |  |  | $ | 52.3 |  |  | $ | — |  |  | $ | 7.4 |  |  | $ | 777.7 |
Cash flows used in investing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Capital expenditures | — |  |  | (55.2 | ) |  | (6.3 | ) |  | (19.6 | ) |  | — |  |  | — |  |  | (81.1 | )
Net cash used in investing activities | — |  |  | (55.2 | ) |  | (6.3 | ) |  | (19.6 | ) |  | — |  |  | — |  |  | (81.1 | )
Cash flows (used in) provided by financing activities: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Proceeds from borrowings under revolving credit facility | — |  |  | 1,501.5 |  |  | — |  |  | 59.2 |  |  | — |  |  | — |  |  | 1,560.7 |
Repayments of borrowings under revolving credit facility | — |  |  | (1,501.5 | ) |  | — |  |  | (59.2 | ) |  | — |  |  | — |  |  | (1,560.7 | )
Repayments of long-term debt | — |  |  | (14.9 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (14.9 | )
Proceeds from issuance of long-term debt | — |  |  | 2,083.0 |  |  | — |  |  | — |  |  | — |  |  | — |  |  | 2,083.0 |
Payments to extinguish long-term debt | — |  |  | (2,121.3 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (2,121.3 | )
Net change in accounts payable-inventory financing | — |  |  | (0.2 | ) |  | (78.4 | ) |  | (5.4 | ) |  | — |  |  | — |  |  | (84.0 | )
Repurchases of common stock | (534.0 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (534.0 | )
Payment of incentive compensation plan withholding taxes | (49.6 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (49.6 | )
Dividend payments | (106.9 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (106.9 | )
Repayment of intercompany loan | — |  |  | — |  |  | 34.3 |  |  | (34.3 | ) |  | — |  |  | — |  |  | — |
Other | — |  |  | 14.1 |  |  | (4.0 | ) |  | (1.1 | ) |  | — |  |  | — |  |  | 9.0 |
Distributions and advances from (to) affiliates | 689.9 |  |  | 56.6 |  |  | (737.2 | ) |  | — |  |  | — |  |  | (9.3 | ) |  | — |
Net cash (used in) provided by financing activities | (0.6 | ) |  | 17.3 |  |  | (785.3 | ) |  | (40.8 | ) |  | — |  |  | (9.3 | ) |  | (818.7 | )
Effect of exchange rate changes on cash and cash equivalents | — |  |  | — |  |  | — |  |  | 2.6 |  |  | — |  |  | — |  |  | 2.6 |
Net decrease in cash and cash equivalents | — |  |  | (109.0 | ) |  | (3.1 | ) |  | (5.5 | ) |  | — |  |  | (1.9 | ) |  | (119.5 | )
Cash and cash equivalents – beginning of period | — |  |  | 222.7 |  |  | 3.1 |  |  | 37.9 |  |  | — |  |  | — |  |  | 263.7 |
Cash and cash equivalents – end of period | $ | — |  |  | $ | 113.7 |  |  | $ | — |  |  | $ | 32.4 |  |  | $ | — |  |  | $ | (1.9 | ) |  | $ | 144.2 |

X
- Definition Supplemental Guarantor Information [Abstract] + References No definition available. + Details
Name: | cdw_SupplementalGuarantorInformationAbstract
Namespace Prefix: | cdw_
Data Type: | xbrli:stringItemType
Balance Type: | na
Period Type: | duration

X
- Definition Tabular disclosure of condensed statement of comprehensive income (loss) including, but not limited to, statements of comprehensive income (loss) of consolidated entities and consolidation eliminations. + References Reference 1: http://www.xbrl.org/2003/role/disclosureRef -Publisher SEC -Name Regulation S-X (SX) -Number 210 -Section 3 -Paragraph i -Subsection 10 + Details
Name: | srt_CondensedStatementOfComprehensiveIncomeTableTextBlock
Namespace Prefix: | srt_
Data Type: | nonnum:textBlockItemType
Balance Type: | na
Period Type: | duration

X
- Definition Tabular disclosure of condensed balance sheet, including, but not limited to, balance sheets of consolidated entities and consolidation eliminations. + References Reference 1: http://www.xbrl.org/2003/role/disclosureRef -Publisher SEC -Name Regulation S-X (SX) -Number 210 -Section 3 -Paragraph i -Subsection 10 + Details
Name: | srt_ScheduleOfCondensedBalanceSheetTableTextBlock
Namespace Prefix: | srt_
Data Type: | nonnum:textBlockItemType
Balance Type: | na
Period Type: | duration

X
- Definition Tabular disclosure of condensed cash flow statement, including, but not limited to, cash flow statements of consolidated entities and consolidation eliminations. + References Reference 1: http://www.xbrl.org/2003/role/disclosureRef -Publisher SEC -Name Regulation S-X (SX) -Number 210 -Section 3 -Paragraph i -Subsection 10 + Details
Name: | srt_ScheduleOfCondensedCashFlowStatementTableTextBlock
Namespace Prefix: | srt_
Data Type: | nonnum:textBlockItemType
Balance Type: | na
Period Type: | duration

X
- Definition Tabular disclosure of condensed income statement, including, but not limited to, income statements of consolidated entities and consolidation eliminations. + References Reference 1: http://www.xbrl.org/2003/role/disclosureRef -Publisher SEC -Name Regulation S-X (SX) -Number 210 -Section 3 -Paragraph i -Subsection 10 + Details
Name: | srt_ScheduleOfCondensedIncomeStatementTableTextBlock
Namespace Prefix: | srt_
Data Type: | nonnum:textBlockItemType
Balance Type: | na
Period Type: | duration