XML 66 R32.htm IDEA: XBRL DOCUMENT
v3.19.3

Supplemental Guarantor Information (Tables) | 9 Months Ended
--- | ---
Sep. 30, 2019
Supplemental Guarantor Information [Abstract] |
Condensed Consolidating Balance Sheets | The following tables set forth Condensed Consolidating Balance Sheets as of September 30, 2019 and December 31, 2018, Consolidating Statements of Operations for the three and nine months ended September 30, 2019 and 2018, Condensed Consolidating Statements of Comprehensive Income for the three and nine months ended September 30, 2019 and 2018, and Condensed Consolidating Statements of Cash Flows for the nine months ended September 30, 2019 and 2018, 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 combined accounts of the Non-Guarantor Subsidiaries, and the accounts of CDW Finance Corporation (the "Co-Issuer") for the periods indicated. The information is prepared on the same basis as the Company's Consolidated Financial Statements.
Condensed Consolidating Balance Sheet
September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Assets |  |  |  |  |  |  |  |  |  |  |  |  |
Current assets: |  |  |  |  |  |  |  |  |  |  |  |  |
Cash and cash equivalents | $ | — |  |  | $ | 124.1 |  |  | $ | — |  |  | $ | 78.5 |  |  | $ | — |  |  | $ | (35.7 | ) |  | $ | 166.9 |
Accounts receivable, net | — |  |  | — |  |  | 2,539.1 |  |  | 360.4 |  |  | — |  |  | — |  |  | 2,899.5 |
Merchandise inventory | — |  |  | — |  |  | 525.2 |  |  | 78.4 |  |  | — |  |  | — |  |  | 603.6 |
Miscellaneous receivables | — |  |  | 103.1 |  |  | 300.6 |  |  | 28.5 |  |  | — |  |  | — |  |  | 432.2 |
Prepaid expenses and other | — |  |  | 22.2 |  |  | 122.6 |  |  | 48.3 |  |  | — |  |  | — |  |  | 193.1 |
Total current assets | — |  |  | 249.4 |  |  | 3,487.5 |  |  | 594.1 |  |  | — |  |  | (35.7 | ) |  | 4,295.3 |
Operating lease right-of-use assets | — |  |  | 23.2 |  |  | 33.1 |  |  | 27.9 |  |  | — |  |  | — |  |  | 84.2 |
Property and equipment, net | — |  |  | 75.8 |  |  | 68.4 |  |  | 26.9 |  |  | — |  |  | — |  |  | 171.1 |
Goodwill | — |  |  | 751.8 |  |  | 1,437.9 |  |  | 326.2 |  |  | — |  |  | — |  |  | 2,515.9 |
Other intangible assets, net | — |  |  | 243.1 |  |  | 206.2 |  |  | 166.8 |  |  | — |  |  | — |  |  | 616.1 |
Other assets | 1.0 |  |  | 27.0 |  |  | 2.4 |  |  | 172.1 |  |  | — |  |  | (182.0 | ) |  | 20.5 |
Investment in and advances to subsidiaries | 934.1 |  |  | 3,189.6 |  |  | — |  |  | — |  |  | — |  |  | (4,123.7 | ) |  | — |
Total Assets | $ | 935.1 |  |  | $ | 4,559.9 |  |  | $ | 5,235.5 |  |  | $ | 1,314.0 |  |  | $ | — |  |  | $ | (4,341.4 | ) |  | $ | 7,703.1 |
Liabilities and Stockholders' Equity |  |  |  |  |  |  |  |  |  |  |  |  |
Current liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Accounts payable-trade | $ | — |  |  | $ | 26.2 |  |  | $ | 1,701.9 |  |  | $ | 207.6 |  |  | $ | — |  |  | $ | (35.7 | ) |  | $ | 1,900.0 |
Accounts payable-inventory financing | — |  |  | 0.1 |  |  | 382.0 |  |  | 29.6 |  |  | — |  |  | — |  |  | 411.7 |
Current maturities of long-term debt | — |  |  | 14.9 |  |  | 4.2 |  |  | 6.3 |  |  | — |  |  | — |  |  | 25.4 |
Contract liabilities | — |  |  | — |  |  | 127.1 |  |  | 85.0 |  |  | — |  |  | — |  |  | 212.1 |
Accrued expenses and other current liabilities | — |  |  | 256.0 |  |  | 352.0 |  |  | 83.8 |  |  | — |  |  | — |  |  | 691.8 |
Total current liabilities | — |  |  | 297.2 |  |  | 2,567.2 |  |  | 412.3 |  |  | — |  |  | (35.7 | ) |  | 3,241.0 |
Long-term liabilities: |  |  |  |  |  |  |  |  |  |  |  |  |
Debt | — |  |  | 3,209.1 |  |  | — |  |  | 49.9 |  |  | — |  |  | — |  |  | 3,259.0 |
Deferred income taxes | — |  |  | 51.7 |  |  | 32.0 |  |  | 28.7 |  |  | — |  |  | (1.1 | ) |  | 111.3 |
Operating lease liabilities | — |  |  | 33.0 |  |  | 25.2 |  |  | 23.5 |  |  | — |  |  | — |  |  | 81.7 |
Other liabilities | — |  |  | 34.8 |  |  | 0.9 |  |  | 220.2 |  |  | — |  |  | (180.9 | ) |  | 75.0 |
Total long-term liabilities | — |  |  | 3,328.6 |  |  | 58.1 |  |  | 322.3 |  |  | — |  |  | (182.0 | ) |  | 3,527.0 |
Total stockholders' equity | 935.1 |  |  | 934.1 |  |  | 2,610.2 |  |  | 579.4 |  |  | — |  |  | (4,123.7 | ) |  | 935.1 |
Total Liabilities and Stockholders' Equity | $ | 935.1 |  |  | $ | 4,559.9 |  |  | $ | 5,235.5 |  |  | $ | 1,314.0 |  |  | $ | — |  |  | $ | (4,341.4 | ) |  | $ | 7,703.1 |
Condensed Consolidating Balance Sheet
December 31, 2018
(in millions) | 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 |
Consolidating Statements of Operations |
Consolidating Statement of Operations
Three Months Ended September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 4,400.6 |  |  | $ | 507.1 |  |  | $ | — |  |  | $ | — |  |  | $ | 4,907.7 |
Cost of sales | — |  |  | — |  |  | 3,671.5 |  |  | 419.7 |  |  | — |  |  | — |  |  | 4,091.2 |
Gross profit | — |  |  | — |  |  | 729.1 |  |  | 87.4 |  |  | — |  |  | — |  |  | 816.5 |
Selling and administrative expenses | — |  |  | 35.8 |  |  | 347.4 |  |  | 61.7 |  |  | — |  |  | — |  |  | 444.9 |
Advertising expense | — |  |  | — |  |  | 47.2 |  |  | 3.8 |  |  | — |  |  | — |  |  | 51.0 |
Operating income (loss) | — |  |  | (35.8 | ) |  | 334.5 |  |  | 21.9 |  |  | — |  |  | — |  |  | 320.6 |
Interest (expense) income, net | — |  |  | (42.0 | ) |  | 0.1 |  |  | (0.4 | ) |  | — |  |  | — |  |  | (42.3 | )
Other income, net | — |  |  | (16.1 | ) |  | — |  |  | (1.3 | ) |  | — |  |  | — |  |  | (17.4 | )
Income (loss) before income taxes | — |  |  | (93.9 | ) |  | 334.6 |  |  | 20.2 |  |  | — |  |  | — |  |  | 260.9 |
Income tax (expense) benefit | (0.1 | ) |  | 30.3 |  |  | (87.9 | ) |  | (1.5 | ) |  | — |  |  | — |  |  | (59.2 | )
Income (loss) before equity in earnings of subsidiaries | (0.1 | ) |  | (63.6 | ) |  | 246.7 |  |  | 18.7 |  |  | — |  |  | — |  |  | 201.7 |
Equity in earnings of subsidiaries | 201.8 |  |  | 265.4 |  |  | — |  |  | — |  |  | — |  |  | (467.2 | ) |  | — |
Net income | $ | 201.7 |  |  | $ | 201.8 |  |  | $ | 246.7 |  |  | $ | 18.7 |  |  | $ | — |  |  | $ | (467.2 | ) |  | $ | 201.7 |
Consolidating Statement of Operations
Three Months Ended September 30, 2018
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 3,921.6 |  |  | $ | 451.6 |  |  | $ | — |  |  | $ | — |  |  | $ | 4,373.2 |
Cost of sales | — |  |  | — |  |  | 3,286.6 |  |  | 373.0 |  |  | — |  |  | — |  |  | 3,659.6 |
Gross profit | — |  |  | — |  |  | 635.0 |  |  | 78.6 |  |  | — |  |  | — |  |  | 713.6 |
Selling and administrative expenses | — |  |  | 33.7 |  |  | 299.8 |  |  | 57.2 |  |  | — |  |  | — |  |  | 390.7 |
Advertising expense | — |  |  | — |  |  | 45.9 |  |  | 2.2 |  |  | — |  |  | — |  |  | 48.1 |
Operating income (loss) | — |  |  | (33.7 | ) |  | 289.3 |  |  | 19.2 |  |  | — |  |  | — |  |  | 274.8 |
Interest (expense) income, net | — |  |  | (36.1 | ) |  | 0.9 |  |  | (1.4 | ) |  | — |  |  | — |  |  | (36.6 | )
Other income, net | — |  |  | — |  |  | 0.1 |  |  | 0.1 |  |  | — |  |  | — |  |  | 0.2 |
Income (loss) before income taxes | — |  |  | (69.8 | ) |  | 290.3 |  |  | 17.9 |  |  | — |  |  | — |  |  | 238.4 |
Income tax (expense) benefit | (0.1 | ) |  | 20.5 |  |  | (75.3 | ) |  | 0.2 |  |  | — |  |  | — |  |  | (54.7 | )
Income (loss) before equity in earnings of subsidiaries | (0.1 | ) |  | (49.3 | ) |  | 215.0 |  |  | 18.1 |  |  | — |  |  | — |  |  | 183.7 |
Equity in earnings of subsidiaries | 183.8 |  |  | 233.1 |  |  | — |  |  | — |  |  | — |  |  | (416.9 | ) |  | — |
Net income | $ | 183.7 |  |  | $ | 183.8 |  |  | $ | 215.0 |  |  | $ | 18.1 |  |  | $ | — |  |  | $ | (416.9 | ) |  | $ | 183.7 |
Consolidating Statement of Operations
Nine Months Ended September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 11,924.5 |  |  | $ | 1,571.0 |  |  | $ | — |  |  | $ | — |  |  | $ | 13,495.5 |
Cost of sales | — |  |  | — |  |  | 9,926.3 |  |  | 1,306.8 |  |  | — |  |  | — |  |  | 11,233.1 |
Gross profit | — |  |  | — |  |  | 1,998.2 |  |  | 264.2 |  |  | — |  |  | — |  |  | 2,262.4 |
Selling and administrative expenses | — |  |  | 99.7 |  |  | 980.6 |  |  | 189.0 |  |  | — |  |  | — |  |  | 1,269.3 |
Advertising expense | — |  |  | — |  |  | 134.7 |  |  | 8.6 |  |  | — |  |  | — |  |  | 143.3 |
Operating income (loss) | — |  |  | (99.7 | ) |  | 882.9 |  |  | 66.6 |  |  | — |  |  | — |  |  | 849.8 |
Interest (expense) income, net | — |  |  | (120.2 | ) |  | 0.3 |  |  | (1.2 | ) |  | — |  |  | — |  |  | (121.1 | )
Other (expense) income, net | — |  |  | (16.1 | ) |  | 2.1 |  |  | (1.0 | ) |  | — |  |  | — |  |  | (15.0 | )
Income (loss) before income taxes | — |  |  | (236.0 | ) |  | 885.3 |  |  | 64.4 |  |  | — |  |  | — |  |  | 713.7 |
Income tax (expense) benefit | (0.3 | ) |  | 75.2 |  |  | (229.2 | ) |  | (8.2 | ) |  | — |  |  | — |  |  | (162.5 | )
Income (loss) before equity in earnings of subsidiaries | (0.3 | ) |  | (160.8 | ) |  | 656.1 |  |  | 56.2 |  |  | — |  |  | — |  |  | 551.2 |
Equity in earnings of subsidiaries | 551.5 |  |  | 712.3 |  |  | — |  |  | — |  |  | — |  |  | (1,263.8 | ) |  | — |
Net income | $ | 551.2 |  |  | $ | 551.5 |  |  | $ | 656.1 |  |  | $ | 56.2 |  |  | $ | — |  |  | $ | (1,263.8 | ) |  | $ | 551.2 |
Consolidating Statement of Operations
Nine Months Ended September 30, 2018
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net sales | $ | — |  |  | $ | — |  |  | $ | 10,743.7 |  |  | $ | 1,422.0 |  |  | $ | — |  |  | $ | — |  |  | $ | 12,165.7 |
Cost of sales | — |  |  | — |  |  | 8,966.6 |  |  | 1,186.0 |  |  | — |  |  | — |  |  | 10,152.6 |
Gross profit | — |  |  | — |  |  | 1,777.1 |  |  | 236.0 |  |  | — |  |  | — |  |  | 2,013.1 |
Selling and administrative expenses | — |  |  | 103.3 |  |  | 861.8 |  |  | 169.7 |  |  | — |  |  | — |  |  | 1,134.8 |
Advertising expense | — |  |  | — |  |  | 128.3 |  |  | 5.6 |  |  | — |  |  | — |  |  | 133.9 |
Operating income (loss) | — |  |  | (103.3 | ) |  | 787.0 |  |  | 60.7 |  |  | — |  |  | — |  |  | 744.4 |
Interest (expense) income, net | — |  |  | (109.9 | ) |  | 2.8 |  |  | (4.4 | ) |  | — |  |  | — |  |  | (111.5 | )
Other income, net | — |  |  | — |  |  | 0.6 |  |  | 0.4 |  |  | — |  |  | — |  |  | 1.0 |
Income (loss) before income taxes | — |  |  | (213.2 | ) |  | 790.4 |  |  | 56.7 |  |  | — |  |  | — |  |  | 633.9 |
Income tax (expense) benefit | (0.3 | ) |  | 61.5 |  |  | (202.6 | ) |  | (8.8 | ) |  | — |  |  | — |  |  | (150.2 | )
Income (loss) before equity in earnings of subsidiaries | (0.3 | ) |  | (151.7 | ) |  | 587.8 |  |  | 47.9 |  |  | — |  |  | — |  |  | 483.7 |
Equity in earnings of subsidiaries | 484.0 |  |  | 635.7 |  |  | — |  |  | — |  |  | — |  |  | (1,119.7 | ) |  | — |
Net income | $ | 483.7 |  |  | $ | 484.0 |  |  | $ | 587.8 |  |  | $ | 47.9 |  |  | $ | — |  |  | $ | (1,119.7 | ) |  | $ | 483.7 |
Condensed Statement of Comprehensive Income |
Condensed Consolidating Statement of Comprehensive Income
Three Months Ended September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 187.0 |  |  | $ | 187.1 |  |  | $ | 246.7 |  |  | $ | 4.1 |  |  | $ | — |  |  | $ | (437.9 | ) |  | $ | 187.0 |
Condensed Consolidating Statement of Comprehensive Income
Three Months Ended September 30, 2018
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 180.6 |  |  | $ | 180.7 |  |  | $ | 215.0 |  |  | $ | 14.9 |  |  | $ | — |  |  | $ | (410.6 | ) |  | $ | 180.6 |
Condensed Consolidating Statement of Comprehensive Income
Nine Months Ended September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 527.7 |  |  | $ | 528.0 |  |  | $ | 656.1 |  |  | $ | 43.5 |  |  | $ | — |  |  | $ | (1,227.6 | ) |  | $ | 527.7 |
Condensed Consolidating Statement of Comprehensive Income
Nine Months Ended September 30, 2018
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Comprehensive income | $ | 471.4 |  |  | $ | 471.7 |  |  | $ | 587.8 |  |  | $ | 30.0 |  |  | $ | — |  |  | $ | (1,089.5 | ) |  | $ | 471.4 |
Condensed Consolidating Statements Cash Flows |
Condensed Consolidating Statement of Cash Flows
Nine Months Ended September 30, 2019
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net cash provided by (used in) operating activities | $ | — |  |  | $ | (6.3 | ) |  | $ | 620.6 |  |  | $ | 95.4 |  |  | $ | — |  |  | $ | (27.4 | ) |  | $ | 682.3 |
Cash flows used in investing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Capital expenditures | — |  |  | (46.4 | ) |  | (19.5 | ) |  | (9.1 | ) |  | — |  |  | — |  |  | (75.0 | )
Acquisition of business, net of cash acquired | — |  |  | — |  |  | — |  |  | (75.0 | ) |  | — |  |  | — |  |  | (75.0 | )
Net cash used in investing activities | — |  |  | (46.4 | ) |  | (19.5 | ) |  | (84.1 | ) |  | — |  |  | — |  |  | (150.0 | )
Cash flows (used in) provided by financing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Proceeds from borrowings under revolving credit facility | — |  |  | 1,860.5 |  |  | — |  |  | — |  |  | — |  |  | — |  |  | 1,860.5 |
Repayments of borrowings under revolving credit facility | — |  |  | (1,834.5 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (1,834.5 | )
Repayments of long-term debt | — |  |  | (11.0 | ) |  | — |  |  | (8.7 | ) |  | — |  |  | — |  |  | (19.7 | )
Proceeds from issuance of long-term debt | — |  |  | 600.0 |  |  | — |  |  | — |  |  | — |  |  | — |  |  | 600.0 |
Payments to extinguish long-term debt | — |  |  | (538.1 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | (538.1 | )
Net change in accounts payable-inventory financing | — |  |  | — |  |  | (24.2 | ) |  | 6.8 |  |  | — |  |  | — |  |  | (17.4 | )
Repurchases of common stock | (493.3 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (493.3 | )
Payment of incentive compensation plan withholding taxes | (21.3 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (21.3 | )
Dividend payments | (128.9 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (128.9 | )
Capital contributions | — |  |  | (76.0 | ) |  | — |  |  | 76.0 |  |  | — |  |  | — |  |  | — |
Other | — |  |  | 28.8 |  |  | (4.4 | ) |  | (0.2 | ) |  | — |  |  | — |  |  | 24.2 |
Distributions and advances from (to) affiliates | 643.5 |  |  | (28.9 | ) |  | (572.5 | ) |  | (50.7 | ) |  | — |  |  | 8.6 |  |  | — |
Net cash (used in) provided by financing activities | — |  |  | 0.8 |  |  | (601.1 | ) |  | 23.2 |  |  | — |  |  | 8.6 |  |  | (568.5 | )
Effect of exchange rate changes on cash and cash equivalents | — |  |  | — |  |  | — |  |  | (2.7 | ) |  | — |  |  | — |  |  | (2.7 | )
Net (decrease) increase in cash and cash equivalents | — |  |  | (51.9 | ) |  | — |  |  | 31.8 |  |  | — |  |  | (18.8 | ) |  | (38.9 | )
Cash and cash equivalents—beginning of period | — |  |  | 176.0 |  |  | — |  |  | 46.7 |  |  | — |  |  | (16.9 | ) |  | 205.8 |
Cash and cash equivalents—end of period | $ | — |  |  | $ | 124.1 |  |  | $ | — |  |  | $ | 78.5 |  |  | $ | — |  |  | $ | (35.7 | ) |  | $ | 166.9 |
Condensed Consolidating Statement of Cash Flows
Nine Months Ended September 30, 2018
(in millions) | Parent Guarantor |  | Subsidiary Issuer |  | Guarantor Subsidiaries |  | Non-Guarantor Subsidiaries |  | Co-Issuer |  | Consolidating Adjustments |  | Consolidated
Net cash provided by (used in) operating activities | $ | — |  |  | $ | (78.9 | ) |  | $ | 608.4 |  |  | $ | 80.2 |  |  | $ | — |  |  | $ | (7.4 | ) |  | $ | 602.3 |
Cash flows used in investing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Capital expenditures | — |  |  | (40.9 | ) |  | (3.5 | ) |  | (9.0 | ) |  | — |  |  | — |  |  | (53.4 | )
Net cash used in investing activities | — |  |  | (40.9 | ) |  | (3.5 | ) |  | (9.0 | ) |  | — |  |  | — |  |  | (53.4 | )
Cash flows (used in) provided by financing activities: |  |  |  |  |  |  |  |  |  |  |  |  |
Proceeds from borrowings under revolving credit facility | — |  |  | 640.0 |  |  | — |  |  | 48.9 |  |  | — |  |  | — |  |  | 688.9 |
Repayments of borrowings under revolving credit facility | — |  |  | (640.0 | ) |  | — |  |  | (41.9 | ) |  | — |  |  | — |  |  | (681.9 | )
Repayments of long-term debt | — |  |  | (11.2 | ) |  | — |  |  | (7.0 | ) |  | — |  |  | — |  |  | (18.2 | )
Net change in accounts payable-inventory financing | — |  |  | (0.8 | ) |  | (85.8 | ) |  | (3.5 | ) |  | — |  |  | — |  |  | (90.1 | )
Repurchases of common stock | (232.5 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (232.5 | )
Payment of incentive compensation plan withholding taxes | (27.1 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (27.1 | )
Dividend payments | (95.5 | ) |  | — |  |  | — |  |  | — |  |  | — |  |  | — |  |  | (95.5 | )
Repayment of intercompany loan | — |  |  | — |  |  | 47.5 |  |  | (47.5 | ) |  | — |  |  | — |  |  | — |
Other | — |  |  | 25.8 |  |  | (4.3 | ) |  | (0.4 | ) |  | — |  |  | — |  |  | 21.1 |
Distributions and advances from (to) affiliates | 355.1 |  |  | 213.2 |  |  | (562.3 | ) |  | — |  |  | — |  |  | (6.0 | ) |  | — |
Net cash (used in) provided by financing activities | — |  |  | 227.0 |  |  | (604.9 | ) |  | (51.4 | ) |  | — |  |  | (6.0 | ) |  | (435.3 | )
Effect of exchange rate changes on cash and cash equivalents | — |  |  | — |  |  | — |  |  | (2.7 | ) |  | — |  |  | — |  |  | (2.7 | )
Net increase (decrease) in cash and cash equivalents | — |  |  | 107.2 |  |  | — |  |  | 17.1 |  |  | — |  |  | (13.4 | ) |  | 110.9 |
Cash and cash equivalents—beginning of period | — |  |  | 113.7 |  |  | — |  |  | 32.4 |  |  | — |  |  | (1.9 | ) |  | 144.2 |
Cash and cash equivalents—end of period | $ | — |  |  | $ | 220.9 |  |  | $ | — |  |  | $ | 49.5 |  |  | $ | — |  |  | $ | (15.3 | ) |  | $ | 255.1 |

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