Table of Contents


 

UNITED STATES
SECURITIES AND EXCHANGE COMMISSION
Washington, D.C. 20549
 FORM 10-Q
(Mark One)
ýQUARTERLY REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934
For the quarterly period ended SeptemberJune 30, 20172018
or
¨TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934
For the transition period from                     to                    

Commission File Number 001-35985
CDW CORPORATION
(Exact name of registrant as specified in its charter) 
Delaware 26-0273989
(State or other jurisdiction of
incorporation or organization)
 
(I.R.S. Employer
Identification No.)
  
75 Tri-State International
Lincolnshire, Illinois
 60069
(Address of principal executive offices) (Zip Code)
(847) 465-6000
(Registrant’sRegistrant's telephone number, including area code)
None
(Former name, former address and former fiscal year, if changed since last report)
Indicate by check mark whether the registrant (1) has filed all reports required to be filed by Section 13 or 15(d) of the Securities Exchange Act of 1934 during the preceding 12 months (or for such shorter period that the registrant was required to file such reports), and (2) has been subject to such filing requirements for the past 90 days.    ý  Yes    ¨  No

Indicate by check mark whether the registrant has submitted electronically and posted on its corporate Web site, if any, every Interactive Data File required to be submitted and posted pursuant to Rule 405 of Regulation S-T (§232.405 of this chapter) during the preceding 12 months (or for such shorter period that the registrant was required to submit and post such files).    ý  Yes    ¨  No

Indicate by check mark whether the registrant is a large accelerated filer, an accelerated filer, a non-accelerated filer, a smaller reporting company, or an emerging growth company. See the definitions of “large"large accelerated filer,” “accelerated" "accelerated filer,” “smaller" "smaller reporting company," and “emerging"emerging growth company”company" in Rule 12b-2 of the Exchange Act (Check one):
 
Large accelerated filer xý  Accelerated filer ¨
       
Non-accelerated filer 
¨  (Do not check if a smaller reporting company)
  Smaller reporting company ¨
    
Emerging growth company ¨
If an emerging growth company, indicate by check mark if the registrant has elected not to use the extended transition period for complying with any new or revised financial accounting standards provided pursuant to Section 13(a) of the Exchange Act. ¨

Indicate by check mark whether the registrant is a shell company (as defined in Rule 12b-2 of the Exchange Act).     ¨  Yes    ý  No
As of October 27, 2017,July 30, 2018, there were 153,062,826151,364,496 shares of common stock, $0.01 par value, outstanding.
 


1

Table of Contents


CDW CORPORATION AND SUBSIDIARIES
FORM 10-Q

TABLE OF CONTENTS
 
  Page
PART IFINANCIAL INFORMATION 
Item 1. 
 
 
 
 
 
 
Item 2.
Item 3.
Item 4.
PART IIOTHER INFORMATION 
Item 1.
Item 1A.  
Item 2.
Item 3.
Item 4.
Item 5.
Item 6.
SIGNATURES


2

Table of Contents


PART I—FINANCIAL INFORMATION
Item 1. Financial Statements
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED BALANCE SHEETS
(in millions, except per-share amounts)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED BALANCE SHEETS
(in millions, except per share amounts)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED BALANCE SHEETS
(in millions, except per share amounts)
September 30, 2017 December 31, 2016June 30, 2018 December 31, 2017
Assets(unaudited)  (unaudited) (as adjusted)
Current assets:      
Cash and cash equivalents$97.9
 $263.7
$100.7
 $144.2
Accounts receivable, net of allowance for doubtful accounts of $6.2 and $5.9, respectively2,311.3
 2,168.6
Accounts receivable, net of allowance for doubtful accounts of $7.1 and $6.2, respectively2,612.2
 2,329.3
Merchandise inventory549.0
 452.0
576.9
 411.5
Miscellaneous receivables380.8
 234.9
373.8
 343.0
Prepaid expenses and other153.5
 118.9
181.1
 168.3
Total current assets3,492.5
 3,238.1
3,844.7
 3,396.3
Property and equipment, net162.5
 163.7
150.3
 161.1
Goodwill2,477.6
 2,455.0
2,472.5
 2,479.6
Other intangible assets, net937.1
 1,055.6
802.3
 897.0
Other assets32.1
 36.0
60.3
 32.7
Total assets$7,101.8
 $6,948.4
Liabilities and Stockholders’ Equity   
Total Assets$7,330.1
 $6,966.7
Liabilities and Stockholders' Equity   
Current liabilities:      
Accounts payable-trade$1,224.6
 $1,072.9
$1,693.6
 $1,317.7
Accounts payable-inventory financing541.3
 580.4
387.6
 498.0
Current maturities of long-term debt41.5
 18.5
38.6
 25.5
Deferred revenue228.4
 172.6
Accrued expenses:  
Contract liabilities169.9
 158.8
Accrued expenses and other current liabilities:  
Compensation138.3
 167.6
138.4
 129.5
Interest15.4
 25.1
21.9
 21.6
Sales taxes30.2
 38.0
38.3
 43.8
Advertising122.6
 55.8
96.8
 89.2
Income taxes31.6
 2.6
22.1
 16.2
Other184.8
 147.2
212.8
 221.8
Total current liabilities2,558.7
 2,280.7
2,820.0
 2,522.1
Long-term liabilities:      
Debt3,388.4
 3,215.9
3,201.7
 3,210.0
Deferred income taxes315.9
 369.2
172.9
 196.3
Other liabilities32.3
 37.1
66.6
 52.7
Total long-term liabilities3,736.6
 3,622.2
3,441.2
 3,459.0
Commitments and contingencies (Note 12)
 

Stockholders’ equity:   
Stockholders' equity:   
Preferred stock, $0.01 par value, 100.0 shares authorized, no shares issued or outstanding for both periods
 

 
Common stock, $0.01 par value, 1,000.0 shares authorized, 152.9 and 160.3 shares issued and outstanding, respectively1.5
 1.6
Common stock, $0.01 par value, 1,000.0 shares authorized; 151.5 and 153.1 shares issued, respectively1.5
 1.5
Less: treasury stock, $0.01 par value, 0.0 and 0.1 shares held, respectively
 
Outstanding common stock, $0.01 par value, 151.5 and 153.0 shares outstanding, respectively1.5
 1.5
Paid-in capital2,903.9
 2,857.3
2,953.3
 2,911.6
Accumulated deficit(1,997.2) (1,673.8)(1,780.8) (1,831.6)
Accumulated other comprehensive loss(101.7) (139.6)(105.1) (95.9)
Total stockholders’ equity806.5
 1,045.5
Total liabilities and stockholders’ equity$7,101.8
 $6,948.4
Total stockholders' equity1,068.9
 985.6
Total Liabilities and Stockholders' Equity$7,330.1
 $6,966.7

The accompanying notes are an integral part of the Consolidated Financial Statements.

3

Table of Contents


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(in millions, except per-share amounts)
(unaudited)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(in millions, except per share amounts)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(in millions, except per share amounts)
 Three Months Ended June 30, Six Months Ended June 30,
 Three Months Ended September 30, Nine Months Ended September 30, 2018 2017 2018 2017
 2017 2016 2017 2016 (unaudited) (as adjusted) (unaudited) (as adjusted)
Net sales $4,033.9
 $3,708.2
 $11,353.0
 $10,489.5
 $4,186.1
 $3,891.7
 $7,792.5
 $7,147.6
Cost of sales 3,391.9
 3,093.9
 9,517.4
 8,740.2
 3,490.5
 3,250.9
 6,493.0
 5,953.3
Gross profit 642.0
 614.3
 1,835.6
 1,749.3
 695.6
 640.8
 1,299.5
 1,194.3
Selling and administrative expenses 352.0
 334.9
 1,062.9
 1,009.0
 381.4
 363.5
 744.1
 710.9
Advertising expense 46.3
 41.9
 128.1
 118.3
 48.7
 46.5
 85.8
 81.9
Income from operations 243.7
 237.5
 644.6
 622.0
 265.5
 230.8
 469.6
 401.5
Interest expense, net (37.8) (37.6) (113.4) (112.6) (37.2) (35.9) (74.9) (75.6)
Net loss on extinguishments of long-term debt 
 (2.1) (57.4) (2.1) 
 
 
 (57.4)
Other income 0.7
 0.4
 1.9
 2.3
Other income, net 1.5
 0.4
 0.8
 1.3
Income before income taxes 206.6
 198.2
 475.7
 509.6
 229.8
 195.3
 395.5
 269.8
Income tax expense (77.4) (72.3) (147.9) (188.4) (56.8) (54.4) (95.5) (70.8)
Net income $129.2
 $125.9
 $327.8
 $321.2
 $173.0
 $140.9
 $300.0
 $199.0
                
Net income per common share:                
Basic $0.84
 $0.78
 $2.10
 $1.95
 $1.14
 $0.90
 $1.98
 $1.26
Diluted $0.83
 $0.76
 $2.06
 $1.93
 $1.12
 $0.89
 $1.94
 $1.24
                
Weighted-average common shares outstanding:                
Basic 153.8
 162.1
 156.3
 164.8
 151.6
 156.0
 151.9
 157.7
Diluted 156.2
 164.9
 159.2
 166.9
 153.9
 159.0
 154.4
 160.9
                
Cash dividends declared per common share $0.1600
 $0.1075
 $0.4800
 $0.3225
 $0.2100
 $0.1600
 $0.4200
 $0.3200

The accompanying notes are an integral part of the Consolidated Financial Statements.


4

Table of Contents


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
(in millions)
(unaudited)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
(in millions)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
(in millions)
 Three Months Ended June 30, Six Months Ended June 30,
 Three Months Ended September 30, Nine Months Ended September 30, 2018 2017 2018 2017
 2017 2016 2017 2016 (unaudited) (as adjusted) (unaudited) (as adjusted)
Net income $129.2
 $125.9
 $327.8
 $321.2
 $173.0
 $140.9
 $300.0
 $199.0
Foreign currency translation, net(1)
 13.9
 (11.9) 39.3
 (54.7) (28.9) 19.0
 (14.7) 25.5
Unrealized gain (loss) from hedge accounting, net(2)
 0.3
 
 (1.4) 
 2.3
 (1.2) 5.5
 (1.6)
Other comprehensive income (loss), net 14.2
 (11.9) 37.9
 (54.7)
Other comprehensive (loss) income, net (26.6) 17.8
 (9.2) 23.9
Comprehensive income $143.4
 $114.0
 $365.7
 $266.5
 $146.4
 $158.7
 $290.8
 $222.9
(1)
Net of tax expense of $0.3 million and $0.1 million for the three months ended September 30, 2017 and 2016, respectively, and net of tax expense of $0.3 million and tax benefit of $0.3 million for the nine months ended September 30, 2017 and 2016, respectively.
(2)
Net of tax expense of $0.2 million for the three months ended September 30, 2017, and tax benefit of $0.9 million for the nine months ended September 30, 2017.
The accompanying notes are an integral part of the Consolidated Financial Statements.
(1)Net of tax benefit of $0.1 million for both the three months ended June 30, 2018 and 2017, and net of tax benefit of $0.2 million and $0.1 million for the six months ended June 30, 2018 and 2017, respectively.
(2)Net of tax expense of $0.7 million and a tax benefit of $0.8 million for the three months ended June 30, 2018 and 2017, respectively, and net of tax expense of $1.8 million and a tax benefit of $1.1 million for the six months ended June 30, 2018 and 2017, respectively.


5

Table of Contents


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENT OF STOCKHOLDERS' EQUITY
(in millions)
(unaudited)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENT OF STOCKHOLDERS' EQUITY
(in millions)
(unaudited)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENT OF STOCKHOLDERS' EQUITY
(in millions)
(unaudited)
 Preferred Stock Common Stock         Preferred Stock Common Stock Treasury Stock        
 Shares Amount Shares Amount 
Paid-in
Capital
 
Accumulated
Deficit
 
Accumulated
Other
Comprehensive Loss
 Total
Stockholders’ Equity
 Shares Amount Shares Amount Shares Amount 
Paid-in
Capital
 
Accumulated
Deficit
 
Accumulated
Other
Comprehensive Loss
 Total
Stockholders' Equity
Balance as of December 31, 2016 
 $
 160.3
 $1.6
 $2,857.3
 $(1,673.8) $(139.6) $1,045.5
Balance as of
December 31, 2017 (as reported)
 
 $
 153.1
 $1.5
 0.1
 $
 $2,911.6
 $(1,834.3) $(95.9) $982.9
Cumulative adjustment
upon adoption of ASC 606
 
 
 
 
 
 
 
 2.7
 
 2.7
Balance as of
December 31, 2017 (as adjusted)
 
 
 153.1
 1.5
 0.1
 
 2,911.6
 (1,831.6) (95.9) 985.6
Net income 
 
 
 
 
 327.8
 
 327.8
 
 
 
 
 
 
 
 300.0
 
 300.0
Equity-based compensation expense 
 
 
 
 29.3
 
 
 29.3
 
 
 
 
 
 
 16.1
 
 
 16.1
Stock option exercises 
 
 1.4
 
 9.1
 
 
 9.1
 
 
 0.7
 
 
 
 19.9
 
 
 19.9
Coworker Stock Purchase Plan 
 
 0.1
 
 7.6
 
 
 7.6
 
 
 0.1
 
 
 
 5.4
 
 
 5.4
Repurchases of common stock 
 
 (8.9) (0.1) 
 (533.9) 

 (534.0) 
 
 (2.4) 
 
 
 
 (176.4) 
 (176.4)
Dividends 
 
 
 
 0.6
 (75.3) 
 (74.7)
Incentive compensation plan shares withheld for taxes 
 
 
 
 
 (42.0) 
 (42.0)
Dividends paid 
 
 
 
 
 
 0.3
 (64.1) 
 (63.8)
Incentive compensation plan stock withheld for taxes 
 
 
 
 (0.1) 
 
 (8.7) 
 (8.7)
Foreign currency translation 
 
 
 
 
 
 39.3
 39.3
 
 
 
 
 
 
 
 
 (14.7) (14.7)
Unrealized loss from hedge accounting 
 
 
 
 
 
 (1.4) (1.4)
Balance as of September 30, 2017 
 $
 152.9
 $1.5
 $2,903.9
 $(1,997.2) $(101.7) $806.5
Unrealized gain from hedge accounting 
 
 
 
 
 
 
 
 5.5
 5.5
Balance as of
June 30, 2018
 
 $
 151.5
 $1.5
 
 $
 $2,953.3
 $(1,780.8) $(105.1) $1,068.9
The accompanying notes are an integral part of the Consolidated Financial Statements.


6

Table of Contents


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF CASH FLOWS
(in millions)
(unaudited)

CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF CASH FLOWS
(in millions)
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF CASH FLOWS
(in millions)
 Nine Months Ended September 30, Six Months Ended June 30,
 2017 2016 2018 2017
Cash flows from operating activities:     (unaudited) (as adjusted)
Net income $327.8
 $321.2
 $300.0
 $199.0
Adjustments to reconcile net income to net cash provided by operating activities:        
Depreciation and amortization 195.2
 190.7
 132.9
 129.5
Equity-based compensation expense 33.6
 28.1
 19.1
 23.6
Deferred income taxes (55.2) (74.8) (28.1) (40.3)
Allowance for doubtful accounts 0.3
 
Amortization of deferred financing costs, debt premium and debt discount, net 4.0
 4.4
Net loss on extinguishments of long-term debt 57.4
 2.1
 
 57.4
Gain on interest rate cap agreements (0.5) 
Other 0.1
 0.5
 5.1
 3.2
Changes in assets and liabilities:        
Accounts receivable (120.4) (17.9) (295.2) (156.0)
Merchandise inventory (90.5) (64.6) (167.7) (52.5)
Other assets (179.3) (101.2) (62.2) (125.6)
Accounts payable-trade 140.2
 141.5
 386.8
 311.8
Other current liabilities 130.9
 97.4
Long-term liabilities (4.5) (28.1)
Other liabilities 41.6
 26.1
Net cash provided by operating activities 439.1
 499.3
 332.3
 376.2
Cash flows used in investing activities:        
Capital expenditures (58.6) (41.4) (33.6) (36.8)
Premium payments on interest rate cap agreements 
 (2.1)
Net cash used in investing activities (58.6) (43.5) (33.6) (36.8)
Cash flows used in financing activities:        
Proceeds from borrowings under revolving credit facilities 1,279.1
 332.1
 488.1
 67.7
Repayments of borrowings under revolving credit facilities (1,087.5) (332.1) (474.4) (13.7)
Repayments of long-term debt (11.2) (17.0) (7.5) (7.5)
Proceeds from issuance of long-term debt 2,083.0
 1,483.0
 
 2,083.0
Payments to extinguish long-term debt (2,121.3) (1,490.4) 
 (2,121.3)
Net change in other long-term obligation (3.8) 15.7
Payments of debt financing costs (9.6) (5.9)
Payments of debt financing fees (1.0) (9.6)
Net change in accounts payable-inventory financing (41.4) 39.2
 (110.4) (85.1)
Effective portion of interest rate cap agreements 0.2
 
Premium payments on interest rate cap agreements (12.6) 
Proceeds from stock option exercises 9.1
 6.0
 19.9
 7.4
Proceeds from Coworker Stock Purchase Plan 7.6
 6.9
 5.4
 4.7
Repurchases of common stock (534.0) (355.0) (176.4) (359.4)
Payment of incentive compensation plan withholding taxes (42.0) 
 (8.7) (42.0)
Dividends (74.7) (53.1) (63.8) (50.3)
Principal payments under capital lease obligations (1.1) (0.3)
Other 3.2
 (0.6)
Net cash used in financing activities (547.6) (370.9) (338.2) (526.7)
Effect of exchange rate changes on cash and cash equivalents 1.3
 (4.2) (4.0) 2.6
Net (decrease) increase in cash and cash equivalents (165.8) 80.7
Net decrease in cash and cash equivalents (43.5) (184.7)
Cash and cash equivalents—beginning of period 263.7
 37.6
 144.2
 263.7
Cash and cash equivalents—end of period $97.9
 $118.3
 $100.7
 $79.0
Supplementary disclosure of cash flow information:        
Cash paid for Interest, net $(118.6) $(117.4)
Cash paid for Income taxes, net $(169.6) $(234.5)
Interest paid $(74.5) $(76.8)
Taxes paid, net $(118.4) $(96.5)
The accompanying notes are an integral part of the Consolidated Financial Statements.

7

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS


1.Description of Business and Summary of Significant Accounting Policies
Description of Business
CDW Corporation (“Parent”("Parent") is a Fortune 500 company with multi-national capabilities and a leading provider of integrated information technology (“IT”("IT") solutions to small, medium and large business, government, education and healthcare customers in the United States Canada and("US"), the United Kingdom.Kingdom ("UK") and Canada. The Company's offerings range from discrete hardware and software products to integrated IT solutions such as mobility, security, data center optimization, cloud computing, virtualization and collaboration.
Throughout this report, the terms the “Company”"Company" and “CDW”"CDW" refer to Parent and its 100% owned subsidiaries.
Parent has two 100% owned subsidiaries, CDW LLC and CDW Finance Corporation. CDW LLC is an Illinois limited liability company that, together with its 100% owned subsidiaries, holds all material assets and conducts all business activities and operations of the Company. CDW Finance Corporation is a Delaware corporation formed for the sole purpose of acting as co-issuer of certain debt obligations as described in Note 13 (Supplemental Guarantor Information) and does not hold any material assets or engage in any business activities or operations.
Basis of Presentation
The accompanying unaudited interim Consolidated Financial Statements as of SeptemberJune 30, 20172018 and for the three and ninesix months ended SeptemberJune 30, 2018 and 2017 and 2016 (the “Consolidated"Consolidated Financial Statements”Statements") have been prepared in conformity with accounting principles generally accepted in the United States of America (“GAAP”("GAAP") and the rules and regulations of the US Securities and Exchange Commission (the “SEC”"SEC") for interim financial statements. Accordingly, certain information and footnote disclosures normally included in financial statements prepared in accordance with GAAP have been condensed or omitted pursuant to the rules and regulations of the SEC. These Consolidated Financial Statements should be read in conjunction with the audited Consolidated Financial Statements and the notes thereto included in the Company's Annual Report on Form 10-K for the year ended December 31, 2016 included in the Company's Current Report on Form 8-K dated August 25, 2017 (the “December"December 31, 20162017 Consolidated Financial Statements”Statements"). The significant accounting policies used in preparing these Consolidated Financial Statements were applied on a basis consistent with those reflected in the December 31, 20162017 Consolidated Financial Statements.Statements except for changes from the adoption of Accounting Standards Update ("ASU") 2014-09, Revenue from Contracts with Customers, as amended ("Topic 606"), as discussed below. In the opinion of management, the Consolidated Financial Statements contain all adjustments (consisting of a normal, recurring nature) necessary to present fairly the Company's financial position, results of operations, comprehensive income, cash flows and changes in stockholders' equity as of the dates and for the periods indicated. The unaudited results of operations for such interim periods reported are not necessarily indicative of results for the full year.
Effective January 1, 2018, the Company adopted the requirements of Topic 606 utilizing the full retrospective method as discussed in Note 2 (Recent Accounting Pronouncements). Prior period amounts have been adjusted accordingly.
Principles of Consolidation
The accompanying Consolidated Financial Statements include the accounts of Parent and its 100% owned subsidiaries. All intercompany transactions and accounts are eliminated in consolidation.
Use of Estimates
The preparation of the Consolidated Financial Statements in accordance with GAAP requires management to make use of certain estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities as of the date of the Consolidated Financial Statements and the reported amounts of revenue and expenses during the reported periods. The Company bases its estimates on historical experience and on various other assumptions that management believes are reasonable under the circumstances, the results of which form the basis for making judgments about carrying values of assets and liabilities that are not readily apparent from other sources. Actual results could differ from those estimates.

8

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

The notes to the Consolidated Financial Statements contained in the December 31, 20162017 Consolidated Financial Statements include a discussion of the significant accounting policies and estimates used in the preparation of the Company's Consolidated Financial Statements. ThereExcept as noted above for the adoption of Topic 606, there have been no material changes to the Company's significant accounting policies and estimates during the ninesix months ended SeptemberJune 30, 2017.     2018.
Revenue Recognition

The Company is a primary distribution channel for a large group of vendors and suppliers, including original equipment manufacturers ("OEMs"), software publishers and wholesale distributors.

The Company accounts for a contract when it has approval and commitment from both parties, the rights of the parties are identified, payment terms are established, the contract has commercial substance and collectability of consideration is probable. The Company evaluates the following indicators amongst others when determining whether it is acting as a principal in the transaction and recording revenue on a gross basis: (i) the Company is primarily responsible for fulfilling the promise to provide the specified goods or service, (ii) the Company has inventory risk before the specified good or service has been transferred to a customer or after transfer of control to the customer and (iii) the Company has discretion in establishing the price for the specified good or service. If the terms of a transaction do not indicate the Company is acting as a principal in the transaction, then the Company is acting as an agent in the transaction and the associated revenues are recognized on a net basis.

The Company recognizes revenue once control has passed to the customer. The following indicators are evaluated in determining when control has passed to the customer: (i) the Company has a right to payment for the product or service, (ii) the customer has legal title to the product, (iii) the Company has transferred physical possession of the product to the customer, (iv) the customer has the significant risk and rewards of ownership of the product and (v) the customer has accepted the product. The Company's products can be delivered to customers in a variety of ways, including (i) as physical product shipped from the Company's warehouse, (ii) via drop-shipment by the vendor or supplier or (iii) via electronic delivery of keys for software licenses. The Company’s shipping terms typically specify F.O.B. destination.

The Company leverages drop-shipment arrangements with many of its vendors and suppliers to deliver products to its customers without having to physically hold the inventory at its warehouses. The Company is the principal in the transaction and recognizes revenue for drop-shipment arrangements on a gross basis.

Revenue Recognition for Hardware
Revenues from sales of hardware products are recognized on a gross basis as the Company is acting as a principal in these transactions, with the selling price to the customer recorded as Net sales and the acquisition cost of the product recorded as Cost of sales. The Company recognizes revenue from these transactions when control has passed to the customer, which is usually upon delivery of the product to the customer.
In some instances, the customer agrees to buy the product from the Company but requests delivery at a later date, commonly known as bill-and-hold arrangements. For these transactions, the Company deems that control passes to the customer when the product is ready for delivery. The Company views products ready for delivery when the customer has a signed agreement, significant risk and rewards for the products, the ability to direct the assets, the products have been set aside specifically for the customer, cannot be redirected to another customer and for customer orders that include configuration services, when such services have been completed.

The Company's vendor partners warrant most of the products the Company sells. These manufacturer warranties are assurance-type warranties and are not considered separate performance obligations. The warranties are not sold separately and only provide assurance that products will conform with the manufacturer's specifications. In some transactions, a third-party will provide the customer with an extended warranty. These extended warranties are sold separately and provide the customer with a service in addition to assurance that the product will function as expected. The Company considers these service-type warranties to be separate performance obligations from the underlying product. For service-type warranties, the Company is arranging for those services to be provided by the third-party and therefore is acting as an agent in the transaction and records revenue on a net basis at the point of sale.


89

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

AccountingRevenue Recognition for Derivative InstrumentsSoftware
Revenues from most software license sales are recognized as a single performance obligation on a gross basis as the Company is acting as a principal in these transactions at the point the software license is delivered to the customer. Generally, software licenses are sold with accompanying third-party delivered software assurance, which is a product that allows customers to upgrade, at no additional cost, to the latest technology if new capabilities are introduced during the period that the software assurance is in effect. The Company evaluates whether the software assurance is a separate performance obligation by assessing if the third-party delivered software assurance is critical or essential to the core functionality of the software itself. This involves considering if the software provides its original intended functionality to the customer without the updates, if the customer would ascribe a higher value to the upgrades versus the up-front deliverable, if the customer would expect frequent intelligence updates to the software (such as updates that maintain the original functionality), and if the customer chooses to not delay or always install upgrades. If the Company determines that the accompanying third-party delivered software assurance is critical or essential to the core functionality of the software license, the software license and the accompanying third-party delivered software assurance are recognized as a single performance obligation. The value of the product is primarily the accompanying support delivered by a third-party and therefore the Company is acting as an agent in these transactions and recognizes them on a net basis at the point the associated software license is delivered to the customer. For software licenses where the accompanying third-party delivered software assurance is not critical or essential to the core functionality, the software assurance is recognized as a separate performance obligation, with the associated revenue recognized on a net basis at the point the related software license is delivered to the customer. For additional details regarding the accounting for bundled arrangements, see "Revenue Recognition for Bundled Arrangements" below.
Revenue Recognition for Services
The Company provides professional services, which include project managers and consultants recommending, designing and implementing IT solutions. Revenue from professional services is recognized either on a time and materials basis or recognized proportionally as costs are incurred for fixed fee project work. For time and materials projects, revenue is recognized on a gross basis each month as work is performed and the Company transfers those services.
The Company sells cloud computing solutions, which include Software as a Service ("SaaS") and Infrastructure as a Service ("IaaS"). SaaS solutions utilize third-party partners to offer the Company's customers access to software in the cloud that enhances office productivity, provides security or assists in collaboration. IaaS solutions utilize third-party partners to enable customers to access data center functionality in a cloud-based solution, including storage, computing and networking. The Company recognizes revenue for cloud computing solutions for arrangements with one-time invoicing to the customer at the time of invoice on a net basis as the Company is acting as an agent in the transaction. For monthly subscription-based arrangements, the Company is acting as an agent in the transaction and recognizes revenue as it invoices the customer for its monthly usage on a net basis.

Revenues from the sale of data center services, such as managed and remote managed services, server co-location, internet connectivity and data backup and storage provided by the Company, are recognized over the period the service is provided. Most hosting and managed service obligations are based on the quantity and pricing parameters established in the agreement. As the customer receives the benefit of the service each month, the Company recognizes the respective revenue on a gross basis as the Company is acting as a principal in the transaction. Additionally, the Company's managed services team provides project support to customers that are billed on a fixed fee basis. The Company is acting as the principal in the transaction and recognizes revenue on a gross basis based on the total number of hours incurred for the period over the total expected hours for the project. Total expected hours to complete the project is updated for each period and best represents the transfer of control of the service to the customer.

The Company's customers are offered the opportunity by certain of its vendors to purchase software licenses and software assurance under enterprise agreements ("EAs"), referred to as services in this paragraph. For most EA transactions, the Company's obligation to the customer is that of a distributor or sales agent of the services, where all obligations for providing the services to customers are passed to the Company's vendors. The Company's performance obligations are satisfied at the time of the sale. In other EA transactions, the Company is responsible for fulfilling the promised services to the customer and providing remedy or refund for work if the customer is not satisfied with the delivered services, has inventory risk in the arrangement and has full control to set the price for the customer. This results in the Company acting as a principal in the agreement. With most EAs, the Company's vendors will transfer the license and invoice the customer

10

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

directly, paying resellers an agency fee or commission on these sales. The Company records these fees as a component of Net sales as earned and there is no corresponding Cost of sales amount.

Revenue Recognition for Bundled Arrangements
The Company also sells some of its products and services as part of bundled contract arrangements containing multiple deliverables, which may include a combination of products and services. For each deliverable that represents a distinct performance obligation, total arrangement consideration is allocated based upon the standalone selling prices of each performance obligation. The Company excludes amounts collected on behalf of third-parties, such as sales taxes, when determining the transaction price. For certain performance obligations, the Company will use a combination of methods to estimate the standalone selling price. When evidence from recent transactions is not available to confirm that the prices are representative of the standalone selling price, an expected cost plus a margin approach is used.
Sales In-Transit
The Company performs an analysis of the estimated number of days of sales in-transit to customers at the end of each reporting period based on a weighted-average analysis of commercial delivery terms that include drop-shipment arrangements. This analysis is the basis upon which the Company estimates the amount of Net sales in-transit at the end of the period and adjusts revenue and the related costs to reflect only what has been delivered to the customer. Changes in delivery patterns may result in a different number of business days estimated to make this adjustment.
Freight Costs
The Company records freight billed to its customers as Net sales and the related freight costs as a Cost of sales when the underlying product revenue is recognized. For freight not billed to its customers, the Company records the freight costs as a Cost of sales. The Company's typical shipping terms are F.O.B. destination, which results in shipping being performed before the customer obtains control of the product. The Company considers shipping to be a fulfillment activity and not a separate performance obligation.
Other
The nature of the Company's contracts give rise to variable consideration in the form of sales returns and allowances. The Company estimates variable consideration at the most likely amount to which it is expected to be entitled. This estimated amount is included in the transaction price to the extent it is probable that a significant reversal of cumulative revenue recognized will not occur when the uncertainty associated with the variable consideration is resolved. The estimates of variable consideration and determination of whether to include estimated amounts in the transaction price are based on an assessment of the Company's anticipated performance and all information that is reasonably available. At the time of sale, the Company records an estimate for sales returns and allowances and an associated right of return asset based on historical experience.
When a contract results in revenue being recognized in excess of the amount the Company has entered into interest rate cap agreementsthe right to invoice to the customer, a contract asset is recorded on the balance sheet. Contract assets are comprised primarily of professional services with fixed fee arrangements.
Contract liabilities consist of payments received from customers, or such consideration that is contractually due, in advance of providing the product or performing services. Contract liabilities are comprised primarily of professional services with fixed fee arrangements, bill-and-hold transactions where control has not passed to the customer and certain governmental contracts.

Trade accounts receivable are recorded at the point of sale (or in accordance with the Statement of Work for services) for the purposetotal amount payable by the customer to the Company for sale of hedging its exposuregoods. Taxes to fluctuationsbe collected from the customer as part of the sale are included in interest rates. The interest rate cap agreementsAccounts receivable.

Any incremental direct costs of obtaining a contract, primarily sales commissions, are designated as cash flow hedges of interest rate risk and recorded at fair value in Other assetsdeferred on the Consolidated Balance Sheets. Sheets and amortized over the period of contract performance.
The gainCompany typically does not enter into long-term contracts. The Company has elected to use the practical expedient for its performance obligations table to show only those contracts that are longer than 12 months at the time of contract inception and those contracts that are non-cancelable. Additionally, for certain governmental contracts where there are

11

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

annual renewals, the Company has excluded these contracts since there is only a one-year legal obligation. Typically, the only contracts that are longer than 12 months in duration are related to the Company's professional and managed services business.
The Company requests payments for its products and services at the point of sale. The Company generally does not enter into any long-term financing arrangements or loss on the derivative instruments is reported as a component of Accumulated Other Comprehensive Loss (“AOCL”) until reclassified to Interest expense in the same period the hedge transaction affects earnings.payment plans with customers or contracts with customers that have non-cash consideration.
2.
Recent Accounting Pronouncements
Accounting for Hedging Activities
In August 2017, the Financial Accounting Standards Board (the "FASB") issued Accounting Standards Update ("ASU")ASU 2017-12, Derivatives and Hedging (Topic 815), intending to improve the transparency of information included in the financial statements by aligning cash flow and fair value hedge accounting with its risk management activities. The ASU eliminates the requirement to separately measure and report hedge ineffectiveness for cash flow hedges and net investment hedges, and generally requires the entire change in the fair value of a hedging instrument to be presented in the same income statement line as the hedged item. The ASU also simplifies certain documentation and assessment requirements, and will incorporate new disclosure requirements and amendments to existing disclosures. This ASU is effective for the Company beginning the first quarter of 2019 and allows for early adoption. The Company is currently evaluating the impact the ASU will have on its Consolidated Financial Statements.
Accounting for Goodwill Impairment
In January 2017, the FASB issued ASU 2017-04, Simplifying the Test for Goodwill Impairment (Topic 350). The amendments in this update eliminate step two of the current two-step process, which requires a hypothetical purchase price allocation when an impairment is determined to have occurred. This ASU 2017-04 is effective for the Company beginning in the first quarter of 2020 and allows for early adoption. The Company elected to early adopt this standard during the third quarter of 2017. The Company will continue to perform the quantitative goodwill impairment evaluation by comparing the fair value of each reporting unit to its carrying amount. Under the new standard, if the Company is required to recognize an impairment charge, the amount of the charge will be measured as the excess of a reporting unit's carrying amount over its fair value, not to exceed the carrying amount of goodwill. The adoption of this ASU did not have an impact on the Company's Consolidated Financial Statements.
Classification of Certain Cash Receipts and Cash Payments
In August 2016, the FASB issued ASU 2016-15, Classification of Certain Cash Receipts and Cash Payments (Topic 230), providing guidance for eight specific cash flow issues with the objective of reducing the existing diversity in practice. Among the updates, this standard requires cash payments for debt extinguishment costs to be classified as cash outflows from financing activities, which is consistent with the Company's current practice. This ASU is effective for the Company beginning in the first quarter of 2018 and allows for early adoption. The Company elected to early adopt this standard during the third quarter of 2017. The adoption of this ASU did not have an impact on the Company's Consolidated Financial Statements.
Measurement of Credit Losses on Financial Instruments
In June 2016, the FASB issued ASU 2016-13, Financial Instruments - Credit Losses (Topic 326): Measurement of Credit Losses on Financial Instruments. This ASU introduces a new forward-looking approach, based on expected losses, to estimate credit losses on certain types of financial instruments, including trade receivables. The estimate of expected credit losses will require considerations of historical information, current information and reasonable and supportable forecasts. This ASU also expands the disclosure requirements to enable users of financial statements to understand the assumptions, models and methods for estimating expected credit losses. This ASU is effective for the Company beginning in the first quarter of 2020 and allows for early adoption beginning in the first quarter of 2019. The Company is currently evaluating the impact the ASU will have on its Consolidated Financial Statements.

9

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Accounting for Leases
In February 2016, the FASB issued ASU 2016-02, Leases (Topic 842), requiring lessees to recognize assets and liabilities on the balance sheet for the rights and obligations created by long-term leases and to disclose additional quantitative and qualitative information about leasing arrangements. This ASU is effective for the Company beginning in the first quarter of 2019 and allows for early adoption. A modified retrospective transition approach is required for leases existing at, or entered into after, the beginning of the earliest comparative period presented in the financial statements.
The Company has established a cross-functional implementation team to analyze the effect of the ASU. The Company is utilizing a combination of a bottom-up and top-down approach to identify and analyze its lease portfolio. The Company is in the process of evaluating its identified leases. In addition, the Company is evaluating business processes and internal controls to meet the ASU’s accounting, reporting and disclosure requirements. Although the Company is currently evaluating the provisions of the ASU to determine how it will be affected, the primary impact to the Company of the new ASU will be to record assets and liabilities for current operating leases, which are principally related to the Company’sCompany's real estate portfolio.
Revenue Recognition
In May 2014, the FASB issued ASU 2014-09, Revenue from Contracts with Customers (Topic 606), which, along with amendments issued in 2015 and 2016, will replace most existing revenue recognition guidance under GAAP and eliminate industry-specific guidance. The core principle of the new guidance is that an entity should recognize revenue for the transfer of goods and services equal to an amount it expects to be entitled to receive for those goods and services. The ASU, as amended, will be effective for the Company beginning in the first quarter of 2018, and allows for early adoption in the first quarter of 2017. The new guidance permits two methods of adoption: retrospectively to each prior reporting period presented (full retrospective method), or retrospectively with the cumulative effect of initially applying the guidance recognized at the date of initial application (the cumulative catch-up transition method).
The Company has established a cross-functional implementation team to analyze the effect of the ASU. The Company utilized a bottom-up approach to analyze the impact of the standard on its contract portfolio by reviewing the current accounting policies and practices to identify potential differences that would result from applying the requirements of the new standard to its revenue contracts. In addition, the Company identified, and is in the process of implementing, appropriate changes to its business processes, systems and controls to support recognition and disclosure under the new standard. The implementation team reports its findings and progress of the project to management and the Audit Committee on a frequent basis.
The Company will adopt the guidance onOn January 1, 2018, the Company adopted Topic 606 and will utilizeutilized the full retrospective method.
The Company has finalized its accounting policies under the new standard and it has determined:
The accounting for bill and hold transactions will result in revenue for certain For additional details, see Note 1 (Description of those arrangements being recognized earlier than under current GAAP. This change will not materially impact Net sales or Net income;
In certain security software transactions when accompanying third-party delivered software assurance is deemed to be critical or essential to the core functionality of the software license, the Company has determined that the software license and the accompanying third-party delivered software assurance are a single performance obligation. The value of the product is primarily the accompanying support delivered by a third-party and therefore the Company is acting as an agent in these transactions and will recognize them on a net basis. The Company currently recognizes revenue from the software license on a gross basis (i.e., acting as a principal) and accompanying third-party delivered software assurance on a net basis. While this change will not impact reported Gross profit, the Company estimates the impact of this on the 2016 full-year results would have been to reduce both Net sales and Cost of sales by $250 - $350 million; and
The accounting for revenue related to hardware, software (excluding the above) and professional services will remain substantially unchanged.
3.Goodwill
The Company performs an evaluation of goodwill, utilizing either a quantitative or qualitative impairment test, on an annual basis, or more frequently if circumstances or events require an evaluation. In connection with the segment change described in Note 13 (Segment Information), the Company performed a quantitative analysis of the legacy Corporate reporting unit's fair value prior to the allocation of goodwill to the Small Business reporting unit. Based on the results of the quantitative analysis performed as of January 1, 2017, the Company determined that the fair values of the Corporate and Small Business reporting units exceeded their carrying values and no impairment existed. Using this valuation, the Company allocated the carrying value of goodwill between Small Business and Corporate based on the relative fair values determined by the quantitative test. The Public, CDW UK and CDW Canada operating segments were not impacted by the segment change and therefore no impairment analysis was required.Summary of Significant Accounting Policies).    

1012

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

The adoption of Topic 606 impacted the Company's results as follows:
  
Three Months Ended June 30, 2017(1)
 
Six Months Ended June 30, 2017(1)
(in millions)
(except per share amounts)
 As Reported New Revenue Standard Adjustment As Adjusted As Reported New Revenue Standard Adjustment As Adjusted
Net sales $3,994.4
 $(102.7) $3,891.7
 $7,319.1
 $(171.5) $7,147.6
Gross profit 641.1
 (0.3) 640.8
 1,193.6
 0.7
 1,194.3
Gross profit margin 16.1% 40 bps
 16.5% 16.3% 40 bps
 16.7%
             
Income from operations 231.1
 (0.3) 230.8
 400.9
 0.6
 401.5
Income tax expense (54.5) 0.1
 (54.4) (70.5) (0.3) (70.8)
Net income $141.0
 $(0.1) $140.9
 $198.7
 $0.3
 $199.0
             
Net income per common share            
Basic $0.90
 $
 $0.90
 $1.26
 $
 $1.26
Diluted $0.89
 $
 $0.89
 $1.23
 $0.01
 $1.24
4.(1)Inventory Financing AgreementsAmounts may not foot or cross-foot due to rounding.
The adoption of Topic 606 impacted the Company's Consolidated Balance Sheet as follows:
  
December 31, 2017(1)
(in millions) As Reported New Revenue Standard Adjustment As Adjusted
Accounts receivable $2,320.5
 $8.8
 $2,329.3
Merchandise inventory 449.5
 (38.0) 411.5
Miscellaneous receivables 336.5
 6.5
 343.0
Prepaid expenses and other 127.4
 40.9
 168.3
Total current assets 3,378.1
 18.2
 3,396.3
       
Other assets 40.8
 (8.1) 32.7
Total assets 6,956.6
 10.1
 6,966.7
       
Contract liabilities 194.0
 (35.2) 158.8
Income tax payable 15.1
 1.1
 16.2
Other accrued expenses 180.2
 41.6
 221.8
Total current liabilities 2,514.6
 7.5
 2,522.1
       
Total liabilities 5,973.7
 7.5
 5,981.1
Total stockholders’ equity $982.9
 $2.7
 $985.6
(1)Amounts may not foot or cross-foot due to rounding.
3.    Inventory Financing Agreements
The Company has entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers under certain terms and conditions.conditions, as described below. These amounts are classified separately as Accounts payable-inventory financing on the Consolidated Balance Sheets. The Company does not incur any interest expense associated with these agreements as balances are paid when they are due.

13

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Amounts included in Accounts payable-inventory financing are as follows:
(in millions) September 30, 2017 December 31, 2016 June 30, 2018 December 31, 2017
Revolving Loan inventory financing agreement(1)
 $503.8
 $558.3
 $380.0
 $480.9
Other inventory financing agreements(2)
 37.5
 22.1
 7.6
 17.1
Accounts payable-inventory financing $541.3
 $580.4
 $387.6
 $498.0
(1)The Senior Secured Asset-Based Revolving Credit Facility (“Revolving Loan”) includes an inventory floorplan sub-facility that enables the Company to maintain an inventory financing agreement with a financial intermediary to facilitate the purchase of inventory from certain vendors on more favorable terms than offered directly by the vendors.
(2)As of September 30, 2017 and December 31, 2016, amounts less than $3 million each, were collateralized by the inventory purchased under these financing agreements and a second lien on the related accounts receivable.
4.     Contract Liabilities and Remaining Performance Obligations
The Company's contract liabilities consist of payments received from customers, or such consideration that is contractually due, in advance of providing the product or performing services. The Company's contract liabilities are reported in a net position on a contract-by-contract basis at the end of each reporting period. As of June 30, 2018 and December 31, 2017, the contract liability balance was $170 million and $159 million, respectively. During the six months ended June 30, 2018 and 2017, the Company recognized revenue of $116 million and $99 million, respectively, related to its contract liabilities.
A contract's transaction price is allocated to each distinct performance obligation and recognized as revenue when, or as, the performance obligation is satisfied. For more information regarding the Company's performance obligations, see Note 1 (Description of Business and Summary of Significant Accounting Policies). The following table represents the total transaction price for the remaining performance obligations as of June 30, 2018 related to non-cancelable contracts longer than 12 months in duration that is expected to be recognized over future periods.
(in millions) Within 1 Year Years 1-2 Years 2-3 Thereafter
Remaining performance obligations $33.6
 $20.8
 $6.2
 $0.9
5.Financial Instruments

The Company’sCompany's indebtedness creates interest rate risk on its variable-rate debt. The Company uses derivative financial instruments to manage its exposure to interest rate risk. The Company does not hold or issue derivative financial instruments for trading or speculative purposes.

The Company has interest rate cap agreements that entitle it to payments from the counterparty of the amount, if any, by which three-month LIBOR exceeds the strike rates of the caps during the agreement period in exchange for an upfront premium. During the first quarter of 2018, the Company entered into interest rate cap agreements with a combined notional value of $1.4 billion resulting in premiums paid to the counterparties of $13 million. As of June 30, 2018 and December 31, 2017, the Company had the following interest rate cap agreements for which the fair values are classified within Other assets on the Consolidated Balance Sheets:
      June 30, 2018 December 31, 2017
Notional Value (in millions) Effective Date Maturity Date Fair Value (in millions) Fair Value (in millions)
$1,400.0
 January 17, 2017 December 31, 2018 $6.4
 $5.4
1,400.0
 December 31, 2018 December 31, 2020 17.1
 
      $23.5
 $5.4
The fair value of the Company’sCompany's interest rate cap agreements is classified as Level 2 in the fair value hierarchy. The valuation of the interest rate cap agreements is derived by using a discounted cash flow analysis on the expected cash receipts that would occur if variable interest rates rise above the strike rates of the caps. This analysis reflects the contractual terms of the interest rate cap agreements, including the period to maturity, and uses observable market-based inputs, including LIBOR curves and implied volatilities. The Company also incorporates insignificant credit valuation adjustments to appropriately reflect the respective counterparty’scounterparty's nonperformance risk in the fair value measurements.

14

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

The counterparty credit spreads are based on publicly available credit information obtained from a third partythird-party credit data provider.

For additional details, see Note 6 (Long-Term Debt).
The interest rate cap agreements entitle the Company to payments from the counterparty of the amount, if any, by which three-month LIBOR exceeds 1.5% during the agreement period. The interest rate cap agreements are in effect from January 17, 2017 through December 31, 2018 with a combined notional amount of $1,400 million. As of September 30, 2017 and December 31, 2016, the interest rate cap agreements had a fair value of $3 million and $5 million, respectively, and are classified within Other Assets on the Consolidated Balance Sheets.

During the first quarter of 2017, the Company designated the interest rate cap agreements as cash flow hedges. The effective portion of changes in the fair value of derivatives that qualify as cash flow hedges is recorded in AOCLAccumulated other comprehensive loss and is subsequently reclassified into Interest expense in the period when the hedged forecasted transaction affects earnings. If a derivative is deemed to be ineffective, the ineffective portion of the change in fair value of the derivative is recognized directly ininto earnings. The Company's interest rate cap agreements were deemed effective during both the ninesix months ended SeptemberJune 30, 2018 and 2017, and the Company expects theythe derivatives will continue to be effective for the next twelve months. TheDuring the three and six months ended June 30, 2018, the Company recorded an insignificanta gain of $2 million and $5 million, respectively, net of a tax expense for the effective portion of the interest rate cap agreements in AOCL forinto Accumulated other comprehensive loss. During the three and six months ended SeptemberJune 30, 2017. The2017, the Company recorded a loss of $1 million loss,and $2 million respectively, net of a tax benefit, of less than $1 million, for the effective portion of the interest rate cap agreements in AOCL for the nine months ended September 30, 2017.into Accumulated other comprehensive loss. During the three and ninesix months ended SeptemberJune 30, 2017,2018, the Company reclassified an insignificant amount$1 million and $2 million, respectively, from AOCL intoAccumulated other comprehensive loss to earnings within Interest expense.expense, net on the Consolidated Statement of Operations. The Company expects to reclassify $4$5 million from AOCLAccumulated other comprehensive loss into Interest expense, net during the next twelve months.


Prior to the election of hedge accounting treatment during the first quarter of 2017, the Company recognized less than $1 million of Interest income during the six months ended June 30, 2017 in the Company's Consolidated Statement of Operations related to the changes in the fair value of the interest rate cap agreements.
6.Long-Term Debt
Long-term debt as of June 30, 2018 is as follows:
(dollars in millions) 
Interest
Rate
 Principal Unamortized Discount and Deferred Financing Fees Total
Senior secured asset-based revolving credit facility
% $
 $

$
CDW UK revolving credit facility 1.9% 13.2
 
 13.2
Senior secured term loan facility (1)

3.9% 1,460.6
 (2.8)
1,457.8
CDW UK term loan 1.9% 73.9
 (1.2) 72.7
Senior notes due 2023
5.0% 525.0
 (4.0)
521.0
Senior notes due 2024
5.5% 575.0
 (4.8)
570.2
Senior notes due 2025
5.0% 600.0
 (6.8)
593.2
Other long-term obligations   12.2
 
 12.2
Total debt   3,259.9
 (19.6) 3,240.3
Less current maturities   (38.6) 
 (38.6)
Long-term debt, excluding current maturities   $3,221.3
 $(19.6) $3,201.7
(1)The Senior secured term loan facility has a variable interest rate, which has effectively been capped through the use of an interest rate cap (see Note 5 (Financial Instruments)). The interest rate disclosed represents the variable interest rate in effect as of June 30, 2018.

1115

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS


Prior to the election of hedge accounting treatment, the Company recognized less than $1 million of Interest income in the Company's Consolidated Statement of Operations for both the three and nine months ended September 30, 2017 and less than $1 million of Interest expense for both the three and nine months ended September 30, 2016 related to the changes in the fair value of the interest rate cap agreements.

For additional details, see Note 6 (Long-Term Debt).
6.Long-Term Debt
Long-term debt as of September 30,December 31, 2017 is as follows:
(dollars in millions) 
Interest
Rate
 Principal Unamortized Discount and Deferred Financing Costs Total Interest
Rate
 Principal Unamortized Discount and Deferred Financing Fees Total
Senior secured asset-based revolving credit facility(1)

2.9% $176.0
 $

$176.0
 % $
 $
 $
CDW UK revolving credit facility(1)
 1.7% 16.1
 
 16.1
 % 
 
 
Senior secured term loan facility(1)
3.3% 1,471.8
 (2.2)
1,469.6
 3.7% 1,468.0
 (2.0) 1,466.0
CDW UK term loan 1.7% 75.0
 (1.3) 73.7
 1.9% 75.7
 (1.4) 74.3
Senior notes due 2023
5.0% 525.0
 (4.7)
520.3
 5.0% 525.0
 (4.5) 520.5
Senior notes due 2024
5.5% 575.0
 (5.4)
569.6
 5.5% 575.0
 (5.2) 569.8
Senior notes due 2025
5.0% 600.0
 (7.6)
592.4
 5.0% 600.0
 (7.3) 592.7
Other long-term obligations   12.2
 
 12.2
   12.2
 
 12.2
Total debt   3,451.1
 (21.2) 3,429.9
   3,255.9
 (20.4) 3,235.5
Less current maturities   (41.5) 
 (41.5)   (25.5) 
 (25.5)
Long-term debt, excluding current maturities   $3,409.6
 $(21.2) $3,388.4
   $3,230.4
 $(20.4) $3,210.0
(1)The Senior secured term loan facility has a variable interest rate, which has effectively been capped through the use of an interest rate cap (see Note 5 (Financial Instruments)). The interest rate disclosed represents the variable interest rate in effect as of December 31, 2017.
(1)Represents a weighted-average interest rate.

Long-term debt as of December 31, 2016 is as follows:
(dollars in millions) Interest
Rate
 Principal Unamortized Discount and Deferred Financing Costs Total
Senior secured asset-based revolving credit facility % $
 $
 $
CDW UK revolving credit facility % 
 
 
Senior secured term loan facility 3.3% 1,483.0
 (14.9) 1,468.1
CDW UK Term Loan 1.8% 69.1
 (1.6) 67.5
Senior notes due 2022 6.0% 600.0
 (5.6) 594.4
Senior notes due 2023 5.0% 525.0
 (5.3) 519.7
Senior notes due 2024 5.5% 575.0
 (6.0) 569.0
Other long-term obligations   15.7
 
 15.7
Total debt   3,267.8
 (33.4) 3,234.4
Less current maturities   (18.5) 
 (18.5)
Long-term debt, excluding current maturities   $3,249.3
 $(33.4) $3,215.9

12

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Senior Secured Asset-BasedAsset-based Revolving Credit Facility (“("Revolving Loan”Loan")

As of SeptemberJune 30, 2017,2018, the Company had $176 million ofno outstanding borrowings under the Revolving Loan, less than $1 million of undrawn letters of credit, $480$357 million reserved for the floorplan sub-facility and a borrowing base of $1,872 million,$1.8 billion, which is based on the amount of eligible inventory and accounts receivable balances as of AugustMay 31, 2017.2018. Borrowings under the Revolving Loan are limited by the borrowing base. As of SeptemberJune 30, 2017,2018, the Company could have borrowed up to an additional $794 million$1.1 billion under the Revolving Loan. Borrowings are also limited by a minimum liquidity condition, which provides that, if excess cash availability is less than the lower of (i) $125 million and (ii) the greater of (a) 10.0% of the borrowing base, and (b) $100 million, the lenders are not required to lend additional amounts under the Revolving Loan unless the consolidated fixed charge coverage ratio, as defined, is at least 1.00 to 1.00.

Borrowings under the Revolving Loan bear interest at a variable interest rate plus an applicable margin. The interest rate margin is based on one of two indices, either (i) LIBOR or (ii) the Alternate Base Rate (“ABR”("ABR"), with the ABR being the greater of (a) the prime rate, (b) the federal funds effective rate plus 50 basis points or (c) the one-month LIBOR plus 1.00%. The applicable margin varies (1.25% to 1.75% for LIBOR borrowings and 0.25% to 0.75% for ABR borrowings) depending upon average daily excess cash availability under the agreement evidencing the Revolving Loan.

On March 31,During the six months ended June 30, 2017, the Company amended, extended and increased its Revolving Loan to a five-year, $1,450 million senior secured asset-based revolving credit facility, with the facility being available to the Company for borrowings, issuance of letters of credit and floorplan financing. The Revolving Loan matures on March 31, 2022. The Revolving Loan replaces the Company’s previousprior revolving loan credit facility that was to mature on June 6, 2019. The("Prior Revolving Loan (i) increases the overall revolving credit facility capacity available to the Company from $1,250 million to $1,450 million, (ii) maintains the maximum aggregate amount of increases that may be made to the revolving credit facility of  $300 million, (iii) maintains the fees on the unused portion of the revolving credit facility at 25 basis points, (iv) makes permanent the 25 basis point reduction in the applicable interest rate margin that was previously conditioned on meeting certain credit ratings levels,Loan") and (v) maintains the existing inventory floorplan sub-facility. In connection with the amendment of the previous facility, the Company recorded a loss on extinguishment of long-term debt of $1 million in the Consolidated Statement of Operations, for the nine months ended September 30, 2017, representing a write-off of a portion of unamortized deferred financing costs.fees. Fees of $4 million related to the Prior Revolving Loan were capitalized as deferred financing costsfees and are being amortized over the five-year term of the facility on a straight-line basis. These deferred financing costsfees are recorded in the Other assets line on the Consolidated Balance Sheets.
Senior Secured Term Loan Facility (“("Term Loan”Loan")

On September 30, 2017, the outstanding principal amount of the Term Loan was $1,472 million, excluding $2 million of deferred financing costs. On February 28, 2017,April 3, 2018, the Company amended the Term Loan, to reprice the facility, reducing interest rate margins by 25 basis points. Borrowings under the Term Loan continue to bear interest at either (a) the ABR(i) LIBOR plus a margin or (ii) the Alternative Base Rate ("ABR"), with the ABR being the greater of (a) the prime rate, (b) the federal funds effective rate plus 50 basis points or (c) the one-month LIBOR plus a margin. The amended margin is 1.75% for LIBOR borrowings and 0.75% for ABR borrowings effective April 3, 2018. Additionally, the Company amended its covenant on restricted payments, such that the Company is permitted to make restricted payments so long as the total net leverage ratio is less than 3.75:1.00 on a pro forma basis.

16

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

As of June 30, 2018, the outstanding principal amount of the Term Loan was $1.5 billion, excluding $3 million of deferred financing fees. Borrowings under the Term Loan are payable quarterly on the last day of each March, June, September and December. The margin is based upon a net leverage ratio as defined in the agreement governing the Term Loan, which is 1.00% for ABR borrowings and 2.00% for LIBOR borrowings as of September 30, 2017.
The Term Loan was issued at par. The Term Loan replaced the prior senior secured term loan facility (the “Prior Term Loan Facility”) that had an outstanding aggregate principal amount of $1,483 million. The Company is required to pay quarterly principal installments equal to 0.25% of the original principal amount of the Prior Term Loan Facility,$4 million with the remaining principal amount payable on the maturity date of August 17, 2023, which was retained from2023.
During the six months ended June 30, 2017, the Company amended its prior $1.5 billion senior secured term loan facility ("Prior Term Loan Facility. In connection with this refinancing, the CompanyFacility") and recorded a loss on extinguishment of long-term debt of $14 million in the Consolidated Statement of Operations for the nine months ended September 30, 2017.Operations. This loss represented the write-off of a portion of the unamortized deferred financing costsfees of $5 million and unamortized discount related to the Prior Term Loan Facility of $9 million. In connection with the issuance of the Term Loan, the Company incurred and recorded $2 million in deferred financing fees, which is recorded as a reduction to the debt and presented in the above table as of September 30, 2017.fees.
CDW UK Term Loan
On August 1, 2016,As of June 30, 2018, the Company entered into a new five-year £56 million ($75 million at September 30, 2017) aggregateoutstanding principal amount term loan facility (“CDW UK Term Loan”), which replacedof the prior senior secured term loan facility (the “Prior CDW UK Term Loan Facility”facility ("CDW UK Term Loan") that had an outstanding principal amountwas £56 million ($74 million at June 30, 2018), excluding £1 million ($1 million at June 30, 2018) of £56 million. Fees of $1 million were capitalized as deferred financing costs and are being amortized over the loan on a straight-line basis.

13

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

fees.
Commencing during the quarter ending September 30, 2018, the Company is required to make annual principal installments of £5 million ($7 million at SeptemberJune 30, 2017)2018), with the remaining principal amount payable on the maturity date of August 1, 2021. Borrowings under the CDW UK Term Loan bear interest at LIBOR plus a margin, payable quarterly on the last day of each March, June, September and December. As of SeptemberJune 30, 2017,2018, an interest rate of 1.69%1.94% was in effect, which represents LIBOR plus a 1.40% margin.
In connection with this refinancing, the PriorThe CDW UK Term Loan Facility was amended to include both the CDW UK Term Loan andalso includes a separate £50 million ($6766 million at SeptemberJune 30, 2017)2018) revolving credit facility (the “CDW"CDW UK Revolving Credit Facility”Facility"). As of SeptemberJune 30, 2017,2018, the Company has borrowed £12had £10 million ($1613 million at SeptemberJune 30, 2017) from2018) of outstanding borrowings under the CDW UK Revolving Credit Facility.
6.0% Senior Notes due 2022 (“2022 Senior Notes”)
On March 2, 2017, the proceeds from the issuance of the 2025 Senior Notes, discussed below, along with cash on hand and proceeds from Revolving Loan borrowings, were deposited with the trustee to redeem all of the remaining $600 million aggregate principal amount of the 2022 Senior Notes at a redemption price of 106.182% of the principal amount redeemed, plus accrued and unpaid interest through the date of redemption. The redemption date was April 2, 2017. On the same date, the indenture governing the 2022 Senior Notes was satisfied and discharged. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $43 million in the Consolidated Statement of Operations for the nine months ended September 30, 2017. This loss represents $37 million in redemption premium and $6 million for the write-off of the remaining deferred financing costs related to the 2022 Senior Notes.
5.0% Senior Notes due 2023 (“("2023 Senior Notes”Notes")
At SeptemberAs of June 30, 2017,2018, the outstanding principal amount of the 2023 Senior Notes was $525 million. The 2023 Notes will mature on September 1, 2023 and bear interest at a rate of 5.0% per annum, payable semi-annually on March 1 and September 1 of each year.

5.5% Senior Notes due 2024 (“("2024 Senior Notes”Notes")

At SeptemberAs of June 30, 2017,2018, the outstanding principal amount of the 2024 Senior Notes was $575 million. The 2024 Senior Notes will mature on December 1, 2024 and bear interest at a rate of 5.5% per annum, payable semi-annually on June 1 and December 1 of each year.
5.0% Senior Notes due 2025 (“("2025 Senior Notes”Notes")

On March 2, 2017, the Company completed the issuanceAs of $600 million aggregate principal amount of 2025 Senior Notes at par. In connection with the issuance of the 2025 Senior Notes, the Company incurred and recorded $8 million in deferred financing fees, which is recorded as a reduction to the debt and presented in the above table as of SeptemberJune 30, 2017.

At September 30, 2017,2018, the outstanding principal amount of the 2025 Senior Notes was $600 million. The 2025 Senior Notes will mature on September 1, 2025 and bear interest at a rate of 5.0% per annum, payable semi-annually on March 1 and September 1 of each year.
During the six months ended June 30, 2017, the Company completed the issuance of the 2025 Senior Notes at par. The proceeds from the issuance of the 2025 Senior Notes along with cash on hand and proceeds from Revolving Loan borrowings were deposited to redeem all of the then remaining $600 million aggregate principal amount of the 2022 Senior Notes ("2022 Senior Notes"). In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $43 million in the Consolidated Statement of Operations for the six months ended June 30, 2017. This loss represents $37 million in redemption premium and $6 million for the write-off of the remaining deferred financing fees related to the 2022 Senior Notes.
Debt Guarantors, Covenants

and Restrictions
CDW LLC is the borrower under the Term Loan and Revolving Loan. CDW LLC and CDW Finance Corporation are the co-issuers of the 2023, 2024 and 2025 Senior Notes (“("Senior Notes”Notes"). The obligations under the Term Loan, the Revolving Loan and the Senior Notes are guaranteed by Parent and each of CDW LLC's direct and indirect, wholly owned, US subsidiaries (the “Guarantors”"Guarantors").

17

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

The Revolving Loan is collateralized by a first priority interest in inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 3 (Inventory Financing Agreements)), deposits and accounts receivable and by a second priority interest in substantially all US assets.
The Term Loan is collateralized by a second priority interest in substantially all inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 3 (Inventory Financing Agreements)), deposits and accounts receivable and by a first priority interest in substantially all other US assets.
As of SeptemberJune 30, 2017,2018, the Company remained in compliance with the covenants under its various credit agreements. The Term Loan contains negative covenants that, among other things, place restrictions and limitations on the ability of the Guarantors to dispose of assets, incur additional indebtedness, incur guarantee obligations, prepay other indebtedness, make distributions or other restricted payments, create liens, make equity or debt investments, make acquisitions, engage in mergers or consolidations or engage in certain transactions with affiliates. As of SeptemberJune 30, 2017,2018, the amount of CDW’sCDW's restricted payment capacity under the Term Loan was $1,056 million. However, the Company is separately

14

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

permitted to make restricted payments, so long as the total net leverage ratio is less than 3.25:1.00 on a pro forma basis.$1.3 billion. The total net leverage ratio was 2.88:2.53:1.00 as of SeptemberJune 30, 2017.2018.

Each of the Senior Notes indentures contain negative covenants that, among other things, place restrictions and limitations on the ability of the Guarantors to enter into sale and lease-back transactions, incur additional secured indebtedness and create liens. The indenture governing each of the Senior Notes do not contain any financial covenants.
The CDW UK Term Loan Agreement imposes restrictions on CDW UK's ability to transfer funds to the Company through the payment of dividends, repayment of intercompany loans, advances or subordinated debt that require, among other things, the maintenance of a minimum net leverage ratio. As of SeptemberJune 30, 2017,2018, the amount of restricted payment capacity under the CDW UK Term Loan was £56£101 million ($75133 million at SeptemberJune 30, 2017)2018).
Fair Value

The fair values of the Senior Notes were estimated using quoted market prices for identical liabilities that are traded in over-the-counter secondary markets that are not considered active. The fair value of the Term Loan was estimated using dealer quotes for identical liabilities in markets that are not considered active. The Senior Notes, Term Loan Revolving Loan and the CDW UK Term Loan are classified as Level 2 within the fair value hierarchy. The carrying value of the Revolving Loan and the CDW UK Revolving Credit Facility approximate fair value if there are outstanding borrowings. As of June 30, 2018, the carrying value of the CDW UK Term Loan approximated fair value. The approximate fair values and related carrying values of the Company's long-term debt, including current maturities and excluding unamortized discount and unamortized deferred financing costs,fees, were as follows:
(in millions) September 30, 2017 December 31, 2016 June 30, 2018 December 31, 2017
Fair value $3,583.8
 $3,334.8
 $3,263.9
 $3,366.5
Carrying value 3,451.1
 3,267.8
 3,259.9
 3,255.9
7.Income Taxes
7.    Income Taxes
On December 22, 2017, the Tax Cuts and Jobs Act was enacted into law. The Tax Cuts and Jobs Act changes several aspects of US federal tax law including: reducing the US corporate income tax rate from 35.0% to 21.0% beginning on January 1, 2018; a one-time tax on the deemed mandatory repatriation of the Company's unremitted foreign earnings which have not been subject to US tax; imposing a minimum US tax on foreign earnings; providing for the immediate expensing of certain qualified property; and changing the tax treatment of performance-based executive compensation and certain employee fringe benefits.
The SEC issued Staff Accounting Bulletin 118 allowing for provisional amounts to be recorded during a measurement period not to exceed one year. The Company recorded during the year ended December 31, 2017 provisional amounts for the impact of revaluing deferred tax assets and liabilities, the deemed mandatory repatriation tax on the Company's unremitted foreign earnings and the state income tax effects from the change in federal tax law during the year ended December 31, 2017. The Company did not adjust any of the provisional amounts during the three or six months ended June 30, 2018. The Company continues to analyze the income tax effects of the Tax Cuts and Jobs Act, as well as monitor guidance from the Internal Revenue Service, US Treasury Department and state taxing authorities and will adjust the provisional amounts within the one-year measurement period.

18

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Income tax expense was $77$57 million for the three months ended SeptemberJune 30, 2017,2018, compared to $72$54 million for the same period of the prior year. The effective income tax rate, expressed by calculating the income tax expense as a percentage of Income before income taxes, was 37.5%24.7% for the three months ended SeptemberJune 30, 20172018 and differed from the US federal statutory rate of 21.0% primarily due to state income taxes a $1 million deferred tax expense as a result of a change in state tax rates enacted during the quarter, a $1 million tax benefit related to equity-based compensation and a state tax refund. The effective tax rate for the same period of the prior year was 36.5% and differed from the US federal statutory rate primarily due to state and local income taxes and a $1 million tax benefit as a result of equity-based compensation.

Income tax expense was $148 million for the nine months ended September 30, 2017, compared to $188 million for the same period of the prior year. The effective income tax rate, expressedpartially offset by calculating the income tax expense as a percentage of Income before income taxes, was 31.1% for the nine months ended September 30, 2017 and differed from the US federal statutory rate primarily due to $31 million of excess tax benefits related toon equity-based compensation. The effective tax rate for the same period of the prior year was 37.0%27.9% and differed from the US federal statutory rate of 35.0% primarily due to excess tax benefits on equity-based compensation.
Income tax expense was $96 million for the six months ended June 30, 2018, compared to $71 million for the same period of the prior year. The effective income tax rate was 24.1% for the six months ended June 30, 2018 and differed from the US federal statutory rate of 21.0% primarily due to state income taxes partially offset by excess tax benefits on equity-based compensation. The effective tax rate for the same period of the prior year was 26.2% and differed from the US federal statutory rate primarily due to state and local income taxes and $1 millionexcess tax benefit as a result ofbenefits on equity-based compensation.

8.Earnings per ShareStockholders' Equity
The numerator for both basic and diluted earnings per share is Net income. The denominator for basic earnings per share isOn February 14, 2018, the weighted-averageCompany retired 109,207 shares outstanding duringof its treasury stock. On December 31, 2017 the period. A reconciliationshares were acquired in satisfaction of basic weighted-average shares outstanding to diluted weighted-average shares outstanding is as follows:
 Three Months Ended September 30, Nine Months Ended September 30,
(in millions)2017 2016 2017 2016
Basic weighted-average shares outstanding153.8
 162.1
 156.3
 164.8
Effect of dilutive securities(1)
2.4
 2.8
 2.9
 2.1
Diluted weighted-average shares outstanding(2)
156.2
 164.9
 159.2
 166.9
(1)The dilutive effect of outstanding stock options, restricted stock units, restricted stock, performance share units and Coworker Stock Purchase Plan units is reflected in the diluted weighted-average shares outstanding using the treasury stock method.

15

Tablewithholding taxes which were paid by the Company on behalf of Contentscoworkers under the Performance Share Awards program.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS


(2)There were less than 1 million potential common shares excluded from diluted weighted-average shares outstanding for both the three and nine months ended September 30, 2017 and 2016 as their inclusion would have had an anti-dilutive effect.
9.Stockholders' Equity
On August 3, 2017, the Company announced that its Board of Directors authorized a $750 million increase to the share repurchase program under which the Company may repurchase shares of its common stock in the open market through privately negotiated or other transactions, depending on share price, market conditions and other factors.
10.Equity-Based Compensation
On December 31, 2016, 748,8552017, 321,880 Performance Share Units (“PSUs”("PSUs") under the 2013 Long-Term Incentive Plan vested, representing a vesting rate for the 2015-2017 performance period of 192.0% of target. The PSUs had a weighted-average grant-date fair value of $37.84 per unit. In connection with the PSUs that vested, the Company distributed shares of common stock to each participant during the six months ended June 30, 2018 and withheld the number of shares of common stock equal to the respective tax withholding for each participant. The Company was required to pay withholding taxes of $9 million to federal, state and foreign taxing authorities for the vesting of these PSUs. This amount is reported as a financing activity in the Consolidated Statement of Cash Flows and as an increase to Accumulated Deficit in the Consolidated Statement of Shareholders' Equity for the six months ended June 30, 2018.

On December 31, 2016, 748,855 PSUs under the 2013 Long-Term Incentive Plan vested, representing a vesting rate for the 2014-2016 performance period of 193.5% of target. The PSUs had a weighted-average grant-date fair value of $24.40 per unit. In connection with the PSUs that vested, the Company distributed shares of common stock to each participant during the ninesix months ended SeptemberJune 30, 2017 and withheld the number of shares of common stock equal to the respective tax withholding for each participant. The Company was required to pay withholding taxes of $18 million to federal, state and foreign taxing authorities for the vesting of these PSUs. This amount is reported as a financing activity in the Consolidated Statement of Cash Flows and as an increase to Accumulated Deficit in the Consolidated Statement of Shareholders' Equity for the ninesix months ended SeptemberJune 30, 2017.

On June 26, 2017, an aggregate of 997,450 Restricted Stock Units (“RSUs”("RSUs") under the 2013 Long-Term Incentive Plan vested. The RSUs had a weighted-average grant-date fair value of $17.04 per unit. In connection with the RSUs that vested, the Company distributed shares of common stock to each participant during the ninesix months ended SeptemberJune 30, 2017 and withheld the number of shares of common stock equal to the respective tax withholding for each participant. The Company was required to pay withholding taxes of $24 million to federal, state and foreign taxing authorities for the vesting of these RSUs. This amount is reported as a financing activity in the Consolidated Statement of Cash Flows and as an increase to Accumulated Deficit in the Consolidated Statement of Shareholders'Stockholders' Equity for the ninesix months ended SeptemberJune 30, 2017.
11.10.Other Compensation BenefitsEarnings per Share
The numerator for both basic and diluted earnings per share is Net income. The denominator for basic earnings per share is the weighted-average shares outstanding during the period.

On September 15, 2017, the Company settled its Restricted Debt Unit Plan (the “RDU Plan”), which was an unfunded nonqualified deferred compensation plan established on March 10, 2010. The total payment made on September 15, 2017 was $31 million, which settled the obligation in full. Compensation expense related
19

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

A reconciliation of basic weighted-average shares outstanding to the RDU Plan was less than $1 million for the three months ended September 30, 2017 and 2016, and $2 million and $1 million for the nine months ended September 30, 2017 and 2016, respectively.diluted weighted-average shares outstanding is as follows:
 Three Months Ended June 30, Six Months Ended June 30,
(in millions)2018 2017 2018 2017
Basic weighted-average shares outstanding151.6
 156.0
 151.9
 157.7
Effect of dilutive securities(1)
2.3
 3.0
 2.5
 3.2
Diluted weighted-average shares outstanding(2)
153.9
 159.0
 154.4
 160.9
12.(1)CommitmentsThe dilutive effect of outstanding stock options, restricted stock units, restricted stock, performance share units and ContingenciesCoworker Stock Purchase Plan units is reflected in the diluted weighted-average shares outstanding using the treasury stock method.

(2)There were fewer than 0.2 million potential common shares excluded from diluted weighted-average shares outstanding for both the three and six months ended June 30, 2018 and 2017 as their inclusion would have had an anti-dilutive effect.
11.    Commitments and Contingencies
The Company is party to various legal proceedings that arise in the ordinary course of its business, which include commercial, intellectual property, employment, tort and other litigation matters. The Company is also subject to audit by federal, state, international, national, provincial and local authorities, and by various partners, group purchasing organizations and customers, including government agencies, relating to purchases and sales under various contracts. In addition, the Company is subject to indemnification claims under various contracts. From time to time, certain customers of the Company file voluntary petitions for reorganization or liquidation under the US bankruptcy laws or similar laws of the jurisdictions for the Company's business activities outside of the US. In such cases, certain pre-petition payments received by the Company could be considered preference items and subject to return to the bankruptcy administrator.
As of SeptemberJune 30, 2017,2018, the Company does not believe that there is a reasonable possibility that any material loss exceeding the amounts already recognized for these proceedings and matters, if any, has been incurred. However, the ultimate resolutions of these proceedings and matters are inherently unpredictable. As such, the Company's financial condition and results of operations could be adversely affected in any particular period by the unfavorable resolution of one or more of these proceedings or matters.
On October 29, 2015, the Company learned of an investigation by the SEC of the Company’s vendor partner program incentives. On May 19, 2017, the SEC Staff informed the Company that the SEC has concluded its investigation and does

1620

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

not intend to recommend an enforcement action. The investigation did not have any impact on the Company’s financial condition or results of operations other than customary costs related to the Company’s cooperation with the investigation.
13.12.Segment Information
Effective January 1, 2017, the Company established Small Business as its own operating and reportable segment to align the Company's financial reporting with the manner in which the Chief Operating Decision Maker assesses performance and makes resource allocation decisions.
Small Business results were previously presented within the Corporate segment as a sales channel. Segment information reported below in prior periods have been recast to conform to the current period presentation. The Company now has three reportable segments: Corporate, which is comprised primarily of US private sector business customers with more than 250 employees, in the US, Small Business, primarily servicing US private sector business customers with up to 250 employees, and Public, which is comprised of government agencies and education and healthcare institutions in the U.S.US. The Company has two other operating segments: CDW CanadaUK and CDW UK,Canada, both of which do not meet the reportable segment quantitative thresholds and, accordingly, are included in an all other category (“Other”("Other").
Information about the Company’sCompany's segments is as follows:
(in millions)
Corporate Small Business
Public
Other
Headquarters
Total
Corporate Small Business
Public
Other
Headquarters
Total
Three Months Ended September 30, 2017:

  







Three Months Ended June 30, 2018

  







Net sales
$1,598.5
 $311.5

$1,732.9

$391.0

$

$4,033.9

$1,733.8
 $329.5

$1,635.4

$487.4

$

$4,186.1
Income (loss) from operations
121.0
 17.7

122.3

14.5

(31.8)
243.7

141.3
 24.6

113.0

21.7

(35.1)
265.5
Depreciation and amortization expense
(20.8) (5.2)
(11.2)
(8.0)
(20.5)
(65.7)
(20.4) (5.2)
(11.3)
(9.0)
(20.4)
(66.3)



  









  







Three Months Ended September 30, 2016:

  







Three Months Ended June 30, 2017(1)


  







Net sales
$1,466.4
 $282.5

$1,640.6

$318.7

$

$3,708.2

$1,580.1
 $315.0
 $1,632.8
 $363.8
 $

$3,891.7
Income (loss) from operations
120.0
 18.0

120.0

10.0

(30.5)
237.5

126.9
 19.4
 104.6
 12.5
 (32.6)
230.8
Depreciation and amortization expense
(20.7) (5.1)
(11.2)
(7.6)
(18.5)
(63.1)
(20.8) (5.1) (11.2) (7.6) (20.7)
(65.4)

(in millions) Corporate Small Business Public Other Headquarters Total Corporate Small Business Public Other Headquarters Total
Nine Months Ended September 30, 2017:            
Six Months Ended June 30, 2018            
Net sales $4,705.5
 $931.7
 $4,583.5
 $1,132.3
 $
 $11,353.0
 $3,299.6
 $657.1
 $2,865.4
 $970.4
 $
 $7,792.5
Income (loss) from operations 359.5
 53.7
 287.4
 39.8
 (95.8) $644.6
 266.1
 46.9
 184.7
 41.5
 (69.6) 469.6
Depreciation and amortization expense (62.5) (15.4) (33.6) (22.7) (61.0) $(195.2) (41.5) (10.4) (22.5) (17.8) (40.7) (132.9)
                        
Nine Months Ended September 30, 2016:            
Six Months Ended June 30, 2017(1)
            
Net sales $4,372.1
 $848.2
 $4,257.1
 $1,012.1
 $
 $10,489.5
 $3,020.7
 $607.0
 $2,786.5
 $733.4
 $
 $7,147.6
Income (loss) from operations 339.1
 52.3
 287.0
 27.4
 (83.8) $622.0
 239.0
 36.0
 165.3
 25.1
 (63.9) 401.5
Depreciation and amortization expense (62.1) (15.5) (33.5) (24.6) (55.0) $(190.7) (41.7) (10.3) (22.4) (14.6) (40.5) (129.5)

14.(1)Supplemental Guarantor InformationAmounts for 2017 have been adjusted to reflect the adoption of Topic 606.

21

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Geographic Areas and Revenue Mix
 Three Months Ended June 30, 2018
 Corporate Small Business Public Other Total
Geography(1)

 
 
 
 
United States$1,731.4
 $329.5
 $1,635.4
 $8.0
 $3,704.3
Rest of World2.4
 
 
 479.4
 481.8
Total Net sales1,733.8
 329.5
 1,635.4
 487.4
 4,186.1
          
Major Product and Services         
Hardware1,380.8
 273.9
 1,337.8
 389.7
 3,382.2
Software254.2
 42.6
 255.8
 53.1
 605.7
Services81.3
 7.7
 37.6
 42.2
 168.8
Other(2)
17.5
 5.3
 4.2
 2.4
 29.4
Total Net sales1,733.8
 329.5
 1,635.4
 487.4
 4,186.1
          
Sales by Channel         
Corporate1,733.8
 
 
 
 1,733.8
Small Business
 329.5
 
 
 329.5
Government
 
 493.5
 
 493.5
Education
 
 712.1
 
 712.1
Healthcare
 
 429.8
 
 429.8
Other
 
 
 487.4
 487.4
Total Net sales1,733.8
 329.5
 1,635.4
 487.4
 4,186.1
          
Timing of Revenue Recognition         
Transferred at a point in time where CDW is principal1,583.4
 309.6
 1,537.3
 441.6
 3,871.9
Transferred at a point in time where CDW is agent101.5
 17.1
 55.3
 9.7
 183.6
Transferred over time where CDW is principal48.9
 2.8
 42.8
 36.1
 130.6
Total Net sales$1,733.8
 $329.5
 $1,635.4
 $487.4
 $4,186.1
(1)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(2)Includes items such as delivery charges to customers.



22

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

 
Three Months Ended June 30, 2017(1)
 Corporate Small Business Public Other Total
Geography(2)
         
United States$1,578.5
 $315.0
 $1,632.8
 $7.1
 $3,533.4
Rest of World1.6
 
 
 356.7
 358.3
Total Net sales1,580.1
 315.0
 1,632.8
 363.8
 3,891.7
          
Major Product and Services         
Hardware1,238.5
 261.0
 1,329.7
 291.4
 3,120.6
Software243.5
 42.5
 263.9
 39.8
 589.7
Services81.3
 6.2
 34.7
 30.6
 152.8
Other(3)
16.8
 5.3
 4.5
 2.0
 28.6
Total Net sales1,580.1
 315.0
 1,632.8
 363.8
 3,891.7
          
Sales by Channel         
Corporate1,580.1
 
 
 
 1,580.1
Small Business
 315.0
 
 
 315.0
Government
 
 523.4
 
 523.4
Education
 
 704.9
 
 704.9
Healthcare
 
 404.5
 
 404.5
Other
 
 
 363.8
 363.8
Total Net sales1,580.1
 315.0
 1,632.8
 363.8
 3,891.7
          
Timing of Revenue Recognition         
Transferred at a point in time where CDW is principal1,437.9
 296.7
 1,539.3
 325.6
 3,599.5
Transferred at a point in time where CDW is agent92.6
 16.0
 52.1
 6.9
 167.6
Transferred over time where CDW is principal49.6
 2.3
 41.4
 31.3
 124.6
Total Net sales$1,580.1
 $315.0
 $1,632.8
 $363.8
 $3,891.7
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(3)Includes items such as delivery charges to customers.


23

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

 Six Months Ended June 30, 2018
 Corporate Small Business Public Other Total
Geography(1)
         
United States$3,295.8
 $657.1
 $2,865.4
 $17.2
 $6,835.5
Rest of World3.8
 
 
 953.2
 957.0
Total Net sales3,299.6
 657.1
 2,865.4
 970.4
 7,792.5
         
Major Product and Services        
Hardware2,632.4
 546.7
 2,346.0
 769.2
 6,294.3
Software473.8
 85.7
 438.9
 112.4
 1,110.8
Services159.4
 14.0
 72.2
 84.4
 330.0
Other(2)
34.0
 10.7
 8.3
 4.4
 57.4
Total Net sales3,299.6
 657.1
 2,865.4
 970.4
 7,792.5
         
Sales by Channel        
Corporate3,299.6
 
 
 
 3,299.6
Small Business
 657.1
 
 
 657.1
Government
 
 912.0
 
 912.0
Education
 
 1,109.3
 
 1,109.3
Healthcare
 
 844.1
 
 844.1
Other
 
 
 970.4
 970.4
Total Net sales3,299.6
 657.1
 2,865.4
 970.4
 7,792.5
         
Timing of Revenue Recognition        
Transferred at a point in time where CDW is principal3,009.7
 619.0
 2,681.2
 874.6
 7,184.5
Transferred at a point in time where CDW is agent194.2
 33.6
 96.4
 24.8
 349.0
Transferred over time where CDW is principal95.7
 4.5
 87.8
 71.0
 259.0
Total Net sales$3,299.6
 $657.1
 $2,865.4
 $970.4
 $7,792.5
(1)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(2)Includes items such as delivery charges to customers.



24

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

 
Six Months Ended June 30, 2017 (1)
 Corporate Small Business Public Other Total
Geography(2)
         
United States3,018.1
 $607.0
 $2,786.5
 $13.2
 $6,424.8
Rest of World2.6
 
 
 720.2
 $722.8
Total Net sales3,020.7
 607.0
 2,786.5
 733.4
 7,147.6
          
Major Product and Services         
Hardware2,385.9
 501.7
 2,288.3
 584.8
 5,760.7
Software444.5
 82.5
 426.7
 82.9
 1,036.6
Services157.1
 12.5
 62.7
 61.9
 294.2
Other(3)
33.2
 10.3
 8.8
 3.8
 56.1
Total Net sales3,020.7
 607.0
 2,786.5
 733.4
 7,147.6
          
Sales by Channel         
Corporate3,020.7
 
 
 
 3,020.7
Small Business
 607.0
 
 
 607.0
Government
 
 898.1
 
 898.1
Education
 
 1,098.1
 
 1,098.1
Healthcare
 
 790.3
 
 790.3
Other
 
 
 733.4
 733.4
Total Net sales3,020.7
 607.0
 2,786.5
 733.4
 7,147.6
          
Timing of Revenue Recognition         
Transferred at a point in time where CDW is principal2,752.2
 572.4
 2,619.7
 656.9
 6,601.2
Transferred at a point in time where CDW is agent173.8
 29.9
 89.6
 15.1
 308.4
Transferred over time where CDW is principal94.7
 4.7
 77.2
 61.4
 238.0
Total Net sales$3,020.7
 $607.0
 $2,786.5
 $733.4
 $7,147.6
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(3)Includes items such as delivery charges to customers.





25

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

The following table presents Net sales by major category for the three and six months ended June 30, 2018 and 2017. Categories are based upon internal classifications.

 Three Months Ended June 30,
 2018 
2017(1)
 Dollars in
Millions
 Percentage
of Total Net
Sales
 Dollars in
Millions
 Percentage
of Total Net
Sales
Notebooks/Mobile Devices$1,068.3
 25.5% $912.8
 23.5%
Netcomm Products498.6
 11.9
 540.3
 13.9
Desktops345.3
 8.2
 308.6
 7.9
Video325.8
 7.8
 289.5
 7.4
Enterprise and Data Storage (Including Drives)264.5
 6.3
 291.3
 7.5
Other Hardware879.7
 21.1
 778.1
 20.0
Total Hardware3,382.2
 80.8
 3,120.6
 80.2
        
Software(2)
605.7
 14.5
 589.7
 15.2
Services(2)
168.8
 4.0
 152.8
 3.9
Other(3)
29.4
 0.7
 28.6
 0.7
Total Net sales$4,186.1
 100.0% $3,891.7
 100.0%

 Six Months Ended June 30,
 2018 
2017(1)
 Dollars in
Millions
 Percentage
of Total Net
Sales
 Dollars in
Millions
 Percentage
of Total Net
Sales
Notebooks/Mobile Devices$1,927.0
 24.7% $1,647.1
 23.0%
Netcomm Products981.5
 12.6
 999.2
 14.0
Desktops648.8
 8.3
 571.5
 8.0
Video585.0
 7.5
 525.0
 7.3
Enterprise and Data Storage (Including Drives)520.5
 6.7
 525.7
 7.4
Other Hardware1,631.5
 21.0
 1,492.2
 20.9
Total Hardware6,294.3
 80.8
 5,760.7
 80.6
        
Software(2)
1,110.8
 14.3
 1,036.6
 14.5
Services(2)
330.0
 4.2
 294.2
 4.1
Other(3)
57.4
 0.7
 56.1
 0.8
Total Net sales$7,792.5

100.0%
$7,147.6

100.0%

(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Certain software and services revenues are recorded on a net basis for accounting purposes. As a result, the category percentage of net revenues is not representative of the category percentage of gross profits.
(3)Includes items such as delivery charges to customers.



26

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

13.    Supplemental Guarantor Information
The 2023 Senior Notes, the 2024 Senior Notes and the 2025 Senior Notes are and, prior to being redeemed in full, the 2022 Senior Notes were, guaranteed by the Parent and each of CDW LLC’s direct and indirect, 100% owned, domestic subsidiaries (the “Guarantor Subsidiaries”"Guarantor Subsidiaries"). All guarantees by the Parent and the Guarantor Subsidiaries are and were joint and several, and full and unconditional; provided that guarantees by the Guarantor Subsidiaries (i) are subject to certain customary release provisions contained in the indentures governing the 2023 Senior Notes, the 2024 Senior Notes and the 2025 Senior Notes and (ii) were subject to certain customary release provisions contained in the indenture governing the 2022 Senior Notes until such indenture was satisfied and discharged in the first quarter of 2017.Notes. CDW LLC's 100% owned foreign subsidiaries, CDW International Holdings Limited, which is comprised of CDW UK and CDW Canada

17

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

(together (together the “Non-Guarantor Subsidiaries”"Non-Guarantor Subsidiaries"), do not guarantee the debt obligations. CDW LLC and CDW Finance Corporation, as co-issuers, are 100% owned by Parent and each of the Guarantor Subsidiaries and the Non-Guarantor Subsidiaries are, directly or indirectly, 100% owned by CDW LLC.
The following tables set forth condensedCondensed Consolidating Balance Sheets as of SeptemberJune 30, 20172018 and December 31, 2016,2017, Consolidating Statements of Operations for the three and ninesix months ended SeptemberJune 30, 2018 and 2017, and 2016, condensedCondensed Consolidating Statements of Comprehensive Income for the three and ninesix months ended SeptemberJune 30, 2018 and 2017 and 2016 and condensedCondensed Consolidating Statements of Cash Flows for the ninesix months ended SeptemberJune 30, 20172018 and 2016,2017, in accordance with Rule 3-10 of Regulation S-X. The consolidating financial information includes the accounts of CDW Corporation (the “Parent Guarantor”"Parent Guarantor"), which has no independent assets or operations, the accounts of CDW LLC (the “Subsidiary Issuer”"Subsidiary Issuer"), the combined accounts of the Guarantor Subsidiaries, the accounts of the Non-Guarantor Subsidiaries, and the accounts of CDW Finance Corporation (the “Co-Issuer”"Co-Issuer") for the periods indicated. The information was prepared on the same basis as the Consolidated Financial Statements.

1827

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Balance Sheet
June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Assets             
Current assets:             
Cash and cash equivalents$
 $70.9
 $
 $52.4
 $
 $(22.6) $100.7
Accounts receivable, net
 
 2,263.8
 348.4
 
 
 2,612.2
Merchandise inventory
 
 502.2
 74.7
 
 
 576.9
Miscellaneous receivables
 114.5
 244.1
 15.2
 
 
 373.8
Prepaid expenses and other
 20.4
 120.6
 40.1
 
 
 181.1
Total current assets
 205.8
 3,130.7
 530.8
 
 (22.6) 3,844.7
Property and equipment, net
 85.9
 40.7
 23.7
 
 
 150.3
Goodwill
 751.8
 1,439.0
 281.7
 
 
 2,472.5
Other intangible assets, net
 273.6
 353.1
 175.6
 
 
 802.3
Other assets1.5
 69.6
 159.2
 1.2
 
 (171.2) 60.3
Investment in and advances to subsidiaries1,067.4
 3,158.6
 
 
 
 (4,226.0) 
Total Assets$1,068.9
 $4,545.3
 $5,122.7
 $1,013.0
 $
 $(4,419.8) $7,330.1
Liabilities and Stockholders’ Equity             
Current liabilities:             
Accounts payable-trade$
 $31.9
 $1,460.9
 $223.4
 $
 $(22.6) $1,693.6
Accounts payable-inventory financing
 0.1
 380.1
 7.4
 
 
 387.6
Current maturities of
long-term debt

 14.9
 3.8
 19.9
 
 
 38.6
Contract liabilities
 
 87.4
 82.5
 
 
 169.9
Accrued expenses and other current liabilities
 186.6
 276.6
 67.1
 
 
 530.3
Total current liabilities
 233.5
 2,208.8
 400.3
 
 (22.6) 2,820.0
Long-term liabilities:             
Debt
 3,127.2
 8.3
 66.2
 
 
 3,201.7
Deferred income taxes
 67.6
 78.3
 28.5
 
 (1.5) 172.9
Other liabilities
 49.6
 4.3
 182.4
 
 (169.7) 66.6
Total long-term liabilities
 3,244.4
 90.9
 277.1
 
 (171.2) 3,441.2
Total stockholders' equity1,068.9
 1,067.4
 2,823.0
 335.6
 
 (4,226.0) 1,068.9
Total Liabilities and Stockholders' Equity$1,068.9
 $4,545.3
 $5,122.7
 $1,013.0
 $
 $(4,419.8) $7,330.1



28

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Balance Sheet
September 30, 2017
December 31, 2017December 31, 2017
(as adjusted) (as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Assets                          
Current assets:                          
Cash and cash equivalents$
 $79.3
 $
 $30.3
 $
 $(11.7) $97.9
$
 $113.7
 $
 $32.4
 $
 $(1.9) $144.2
Accounts receivable, net
 
 2,013.0
 298.3
 
 
 2,311.3

 
 2,015.7
 313.6
 
 
 2,329.3
Merchandise inventory
 
 456.2
 92.8
 
 
 549.0

 
 354.6
 56.9
 
 
 411.5
Miscellaneous receivables
 122.8
 232.5
 25.5
 
 
 380.8

 103.9
 211.1
 28.0
 
 
 343.0
Prepaid expenses and other
 16.5
 88.9
 48.1
 
 
 153.5

 18.0
 100.4
 49.9
 
 
 168.3
Total current assets
 218.6
 2,790.6
 495.0
 
 (11.7) 3,492.5

 235.6
 2,681.8
 480.8
 
 (1.9) 3,396.3
Property and equipment, net
 97.9
 45.2
 19.4
 
 
 162.5

 95.0
 43.5
 22.6
 
 
 161.1
Goodwill
 751.8
 1,439.0
 286.8
 
 
 2,477.6

 751.8
 1,439.0
 288.8
 
 
 2,479.6
Other intangible assets, net
 280.6
 459.3
 197.2
 
 
 937.1

 280.1
 424.5
 192.4
 
 
 897.0
Other assets2.8
 34.9
 234.1
 4.4
 
 (244.1) 32.1
1.7
 30.7
 209.3
 2.6
 
 (211.6) 32.7
Investment in and advances to subsidiaries845.8
 3,155.5
 
 
 
 (4,001.3) 
983.9
 3,066.1
 
 
 
 (4,050.0) 
Total assets$848.6
 $4,539.3
 $4,968.2
 $1,002.8
 $
 $(4,257.1) $7,101.8
Liabilities and Stockholders’ Equity             
Total Assets$985.6
 $4,459.3
 $4,798.1
 $987.2
 $
 $(4,263.5) $6,966.7
Liabilities and Stockholders' Equity             
Current liabilities:                          
Accounts payable—trade$
 $22.7
 $1,065.8
 $147.8
 $
 $(11.7) $1,224.6
Accounts payable—inventory financing
 
 506.6
 34.7
 
 
 541.3
Accounts payable-trade$
 $42.5
 $1,112.1
 $165.0
 $
 $(1.9) $1,317.7
Accounts payable-inventory financing
 1.0
 480.9
 16.1
 
 
 498.0
Current maturities of
long-term debt

 14.9
 3.8
 22.8
 
 
 41.5

 14.9
 3.8
 6.8
 
 
 25.5
Deferred revenue
 
 136.4
 92.0
 
 
 228.4
Accrued expenses
 227.4
 224.1
 71.0
 
 0.4
 522.9
Contract liabilities
 
 87.5
 71.3
 
 
 158.8
Accrued expenses and other current liabilities
 173.3
 262.0
 86.8
 
 
 522.1
Total current liabilities
 265.0
 1,936.7
 368.3
 
 (11.3) 2,558.7

 231.7
 1,946.3
 346.0
 
 (1.9) 2,522.1
Long-term liabilities:                          
Debt
 3,313.2
 8.3
 66.9
 
 
 3,388.4

 3,134.2
 8.3
 67.5
 
 
 3,210.0
Deferred income taxes
 91.8
 160.5
 66.4
 
 (2.8) 315.9

 66.5
 100.1
 31.4
 
 (1.7) 196.3
Other liabilities42.1
 23.5
 4.5
 203.9
 
 (241.7) 32.3

 43.0
 4.7
 214.9
 
 (209.9) 52.7
Total long-term liabilities42.1
 3,428.5
 173.3
 337.2
 
 (244.5) 3,736.6

 3,243.7
 113.1
 313.8
 
 (211.6) 3,459.0
Total stockholders’ equity806.5
 845.8
 2,858.2
 297.3
 
 (4,001.3) 806.5
Total liabilities and stockholders’ equity$848.6
 $4,539.3
 $4,968.2
 $1,002.8
 $
 $(4,257.1) $7,101.8
Total stockholders' equity985.6
 983.9
 2,738.7
 327.4
 
 (4,050.0) 985.6
Total Liabilities and Stockholders' Equity$985.6
 $4,459.3
 $4,798.1
 $987.2
 $
 $(4,263.5) $6,966.7





1929

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Balance Sheet
December 31, 2016
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Assets             
Current assets:             
Cash and cash equivalents$
 $222.7
 $3.1
 $37.9
 $
 $
 $263.7
Accounts receivable, net
 
 1,904.9
 263.7
 
 
 2,168.6
Merchandise inventory
 
 390.6
 61.4
 
 
 452.0
Miscellaneous receivables
 92.6
 130.1
 12.2
 
 
 234.9
Prepaid expenses and other
 14.3
 69.0
 35.6
 
 
 118.9
Total current assets
 329.6
 2,497.7
 410.8
 
 
 3,238.1
Property and equipment, net
 105.6
 49.3
 8.8
 
 
 163.7
Goodwill
 751.8
 1,439.0
 264.2
 
 
 2,455.0
Other intangible assets, net
 291.5
 565.1
 199.0
 
 
 1,055.6
Other assets3.2
 19.4
 248.2
 1.5
 
 (236.3) 36.0
Investment in and advances to subsidiaries1,042.3
 3,026.5
 
 
 
 (4,068.8) 
Total assets$1,045.5
 $4,524.4
 $4,799.3
 $884.3
 $
 $(4,305.1) $6,948.4
Liabilities and Stockholders’ Equity             
Current liabilities:             
Accounts payable-trade$
 $25.9
 $895.3
 $151.7
 $
 $
 $1,072.9
Accounts payable-inventory financing
 1.2
 559.5
 19.7
 
 
 580.4
Current maturities of long-term debt
 14.9
 3.6
 
 
 
 18.5
Deferred revenue
 
 100.8
 71.8
 
 
 172.6
Accrued expenses
 173.9
 214.8
 47.7
 
 (0.1) 436.3
Total current liabilities
 215.9
 1,774.0
 290.9
 
 (0.1) 2,280.7
Long-term liabilities:             
Debt
 3,136.3
 12.1
 67.5
 
 
 3,215.9
Deferred income taxes
 99.1
 205.4
 67.9
 
 (3.2) 369.2
Other liabilities
 30.8
 3.6
 235.7
 
 (233.0) 37.1
Total long-term liabilities
 3,266.2
 221.1
 371.1
 
 (236.2) 3,622.2
Total stockholders’ equity1,045.5
 1,042.3
 2,804.2
 222.3
 
 (4,068.8) 1,045.5
Total liabilities and stockholders’ equity$1,045.5
 $4,524.4
 $4,799.3
 $884.3
 $
 $(4,305.1) $6,948.4







20

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Consolidating Statement of Operations
Three Months Ended September 30, 2017
Three Months Ended June 30, 2018Three Months Ended June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Net sales$
 $
 $3,642.9
 $391.0
 $
 $
 $4,033.9
$
 $
 $3,698.7
 $487.4
 $
 $
 $4,186.1
Cost of sales
 
 3,066.2
 325.7
 
 
 3,391.9

 
 3,083.0
 407.5
 
 
 3,490.5
Gross profit
 
 576.7
 65.3
 
 
 642.0

 
 615.7
 79.9
 
 
 695.6
Selling and administrative expenses
 31.8
 271.9
 48.3
 
 
 352.0

 35.1
 289.6
 56.7
 
 
 381.4
Advertising expense
 
 43.8
 2.5
 
 
 46.3

 
 47.2
 1.5
 
 
 48.7
Income (loss) from operations
 (31.8) 261.0
 14.5
 
 
 243.7

 (35.1) 278.9
 21.7
 
 
 265.5
Interest (expense) income, net
 (37.3) 1.0
 (1.5) 
 
 (37.8)
 (36.7) 0.9
 (1.4) 
 
 (37.2)
Other income (expense)
 (0.2) 0.3
 0.6
 
 
 0.7
Other income
 
 0.1
 1.4
 
 
 1.5
Income (loss) before income taxes
 (69.3) 262.3
 13.6
 
 
 206.6

 (71.8) 279.9
 21.7
 
 
 229.8
Income tax benefit (expense)
 26.2
 (100.2) (3.4) 
 
 (77.4)
Income tax (expense) benefit(0.1) 20.2
 (72.0) (4.9) 
 
 (56.8)
Income (loss) before equity in earnings of subsidiaries
 (43.1) 162.1
 10.2
 
 
 129.2
(0.1) (51.6) 207.9
 16.8
 
 
 173.0
Equity in earnings of subsidiaries129.2
 172.3
 
 
 
 (301.5) 
173.1
 224.7
 
 
 
 (397.8) 
Net income$129.2
 $129.2
 $162.1
 $10.2
 $
 $(301.5) $129.2
$173.0
 $173.1
 $207.9
 $16.8
 $
 $(397.8) $173.0

























2130

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Consolidating Statement of Operations
Three Months Ended September 30, 2016
Three Months Ended June 30, 2017Three Months Ended June 30, 2017
(as adjusted)(as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 ConsolidatedParent
Guarantor
 Subsidiary
Issuer
 Guarantor
Subsidiaries
 Non-Guarantor
Subsidiaries
 Co-Issuer Consolidating
Adjustments
 Consolidated
Net sales$
 $
 $3,389.6
 $318.6
 $
 $
 $3,708.2
$
 $
 $3,528.0
 $363.7
 $
 $
 $3,891.7
Cost of sales
 
 2,828.7
 265.2
 
 
 3,093.9

 
 2,947.6
 303.3
 
 
 3,250.9
Gross profit
 
 560.9
 53.4
 
 
 614.3

 
 580.4
 60.4
 
 
 640.8
Selling and administrative expenses
 30.0
 262.1
 42.8
 
 
 334.9

 32.6
 284.6
 46.3
 
 
 363.5
Advertising expense
 
 40.9
 1.0
 
 
 41.9

 
 44.9
 1.6
 
 
 46.5
Income (loss) from operations
 (30.0) 257.9
 9.6
 
 
 237.5

 (32.6) 250.9
 12.5
 
 
 230.8
Interest (expense) income, net
 (37.6) 1.8
 (1.8) 
 
 (37.6)
 (35.4) 1.1
 (1.6) 
 
 (35.9)
Net loss on extinguishments of long-term debt
 (2.1) 
 
 
 
 (2.1)
Other income
 0.7
 0.3
 (0.6) 
 
 0.4

 
 0.1
 0.3
 
 
 0.4
Income (loss) before income taxes
 (69.0) 260.0
 7.2
 
 
 198.2

 (68.0) 252.1
 11.2
 
 
 195.3
Income tax benefit (expense)
 27.6
 (99.4) (0.5) 
 
 (72.3)
Income tax (expense) benefit
 29.4
 (80.7) (3.1) 
 
 (54.4)
Income (loss) before equity in earnings of subsidiaries
 (41.4) 160.6
 6.7
 
 
 125.9

 (38.6) 171.4
 8.1
 
 
 140.9
Equity in earnings of subsidiaries125.9
 167.3
 
 
 
 (293.2) 
140.9
 179.5
 
 
 
 (320.4) 
Net income$125.9
 $125.9
 $160.6
 $6.7
 $
 $(293.2) $125.9
$140.9
 $140.9
 $171.4
 $8.1
 $
 $(320.4) $140.9




















2231

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Consolidating Statement of Operations
Nine Months Ended September 30, 2017
Six Months Ended June 30, 2018Six Months Ended June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 ConsolidatedParent
Guarantor
 Subsidiary
Issuer
 Guarantor
Subsidiaries
 Non-Guarantor
Subsidiaries
 Co-Issuer Consolidating
Adjustments
 Consolidated
Net sales$
 $
 $10,220.7
 $1,132.3
 $
 $
 $11,353.0
$
 $
 $6,822.1
 $970.4
 $
 $
 $7,792.5
Cost of sales
 
 8,571.2
 946.2
 
 
 9,517.4

 
 5,680.0
 813.0
 
 
 6,493.0
Gross profit
 
 1,649.5
 186.1
 
 
 1,835.6

 
 1,142.1
 157.4
 
 
 1,299.5
Selling and administrative expenses
 95.8
 826.3
 140.8
 
 
 1,062.9

 69.6
 562.0
 112.5
 
 
 744.1
Advertising expense
 
 122.6
 5.5
 
 
 128.1

 
 82.4
 3.4
 
 
 85.8
Income (loss) from operations
 (95.8) 700.6
 39.8
 
 
 644.6

 (69.6) 497.7
 41.5
 
 
 469.6
Interest (expense) income, net
 (111.8) 3.1
 (4.7) 
 
 (113.4)
 (73.8) 1.9
 (3.0) 
 
 (74.9)
Net loss on extinguishments of long-term debt
 (57.4) 
 
 
 
 (57.4)
Other income
 
 0.4
 1.5
 
 
 1.9

 
 0.5
 0.3
 
 
 0.8
Income (loss) before income taxes
 (265.0) 704.1
 36.6
 
 
 475.7

 (143.4) 500.1
 38.8
 
 
 395.5
Income tax benefit (expense)
 112.8
 (251.2) (9.5) 
 
 (147.9)
Income tax (expense) benefit(0.2) 41.0
 (127.3) (9.0) 
 
 (95.5)
Income (loss) before equity in earnings of subsidiaries
 (152.2) 452.9
 27.1
 
 
 327.8
(0.2) (102.4) 372.8
 29.8
 
 
 300.0
Equity in earnings of subsidiaries327.8
 480.0
 
 
 
 (807.8) 
300.2
 402.6
 
 
 
 (702.8) 
Net income$327.8
 $327.8
 $452.9
 $27.1
 $
 $(807.8) $327.8
$300.0
 $300.2
 $372.8
 $29.8
 $
 $(702.8) $300.0

















2332

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Consolidating Statement of Operations
Nine Months Ended September 30, 2016
Six Months Ended June 30, 2017Six Months Ended June 30, 2017
(as adjusted)(as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 ConsolidatedParent
Guarantor
 Subsidiary
Issuer
 Guarantor
Subsidiaries
 Non-Guarantor
Subsidiaries
 Co-Issuer Consolidating
Adjustments
 Consolidated
Net sales$
 $
 $9,477.4
 $1,012.1
 $
 $
 $10,489.5
$
 $
 $6,414.2
 $733.4
 $
 $
 $7,147.6
Cost of sales
 
 7,891.6
 848.6
 
 
 8,740.2

 
 5,340.5
 612.8
 
 
 5,953.3
Gross profit
 
 1,585.8
 163.5
 
 
 1,749.3

 
 1,073.7
 120.6
 
 
 1,194.3
Selling and administrative expenses
 83.1
 793.2
 132.7
 
 
 1,009.0

 63.9
 554.5
 92.5
 
 
 710.9
Advertising expense
 
 114.5
 3.8
 
 
 118.3

 
 78.9
 3.0
 
 
 81.9
Income (loss) from operations
 (83.1) 678.1
 27.0
 
 
 622.0

 (63.9) 440.3
 25.1
 
 
 401.5
Interest (expense) income, net
 (112.4) 5.6
 (5.8) 
 
 (112.6)
 (74.5) 2.1
 (3.2) 
 
 (75.6)
Net loss on extinguishments of long-term debt
 (2.1) 
 
 
 
 (2.1)
 (57.4) 
 
 
 
 (57.4)
Other income
 0.7
 1.0
 0.6
 
 
 2.3

 
 0.3
 1.0
 
 
 1.3
Income (loss) before income taxes
 (196.9) 684.7
 21.8
 
 
 509.6

 (195.8) 442.7
 22.9
 
 
 269.8
Income tax benefit (expense)
 76.2
 (259.9) (4.7) 
 
 (188.4)
Income tax (expense) benefit
 86.6
 (151.3) (6.1) 
 
 (70.8)
Income (loss) before equity in earnings of subsidiaries
 (120.7) 424.8
 17.1
 
 
 321.2

 (109.2) 291.4
 16.8
 
 
 199.0
Equity in earnings of subsidiaries321.2
 441.9
 
 
 
 (763.1) 
199.0
 308.2
 
 
 
 (507.2) 
Net income$321.2
 $321.2
 $424.8
 $17.1
 $
 $(763.1) $321.2
$199.0
 $199.0
 $291.4
 $16.8
 $
 $(507.2) $199.0

















2433

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Statement of Comprehensive Income
Three Months Ended September 30, 2017
Three Months Ended June 30, 2018Three Months Ended June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Comprehensive income$143.4
 $143.4
 $162.1
 $24.1
 $
 $(329.6) $143.4
$146.4
 $146.5
 $207.9
 $(12.1) $
 $(342.3) $146.4
Condensed Consolidating Statement of Comprehensive Income
Three Months Ended September 30, 2016
Three Months Ended June 30, 2017Three Months Ended June 30, 2017
(as adjusted) (as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Comprehensive income (loss)$114.0
 $114.0
 $160.6
 $(5.2) $
 $(269.4) $114.0
Comprehensive income$158.7
 $158.7
 $171.4
 $26.9
 $
 $(357.0) $158.7
Condensed Consolidating Statement of Comprehensive Income
Nine Months Ended September 30, 2017
Six Months Ended June 30, 2018Six Months Ended June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Comprehensive income$365.7
 $365.7
 $452.9
 $66.4
 $
 $(885.0) $365.7
$290.8
 $291.0
 $372.8
 $15.1
 $
 $(678.9) $290.8
Condensed Consolidating Statement of Comprehensive Income
Nine Months Ended September 30, 2016
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Comprehensive income (loss)$266.5
 $266.5
 $424.8
 $(37.6) $
 $(653.7) $266.5




Condensed Consolidating Statement of Comprehensive Income
Six Months Ended June 30, 2017
 (as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Comprehensive income$222.9
 $222.9
 $291.4
 $42.3
 $
 $(556.6) $222.9







2534

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Statement of Cash Flows
Nine Months Ended September 30, 2017
Six Months Ended June 30, 2018Six Months Ended June 30, 2018
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Net cash provided by (used in) operating activities$42.4
 $(17.7) $422.4
 $14.0
 $
 $(22.0) $439.1
$
 $(71.8) $343.9
 $74.2
 $
 $(14.0) $332.3
Cash flows used in investing activities:                          
Capital expenditures
 (40.0) (4.8) (13.8) 
 
 (58.6)
 (24.2) (1.9) (7.5) 
 
 (33.6)
Net cash used in investing activities
 (40.0) (4.8) (13.8) 
 
 (58.6)
 (24.2) (1.9) (7.5) 
 
 (33.6)
Cash flows from (used in) financing activities:             
Proceeds from borrowings under revolving credit facility
 1,233.3
 
 45.8
 
 
 1,279.1
Repayments of borrowings under revolving credit facility
 (1,057.0) 
 (30.5) 
 
 (1,087.5)
Cash flows (used in) provided by financing activities:             
Proceeds from borrowings under revolving credit facilities
 467.5
 
 20.6
 
 
 488.1
Repayments of borrowings under revolving credit facilities
 (467.5) 
 (6.9) 
 
 (474.4)
Repayments of long-term debt
 (11.2) 
 
 
 
 (11.2)
 (7.5) 
 
 
 
 (7.5)
Proceeds from the 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 other long-term obligation
 
 (3.8) 
 
 
 (3.8)
Payments of debt financing costs
 (9.6) 
 
 
 
 (9.6)
 (1.0) 
 
 
 
 (1.0)
Net change in accounts payable-inventory financing
 (1.2) (52.9) 12.7
 
 
 (41.4)
 (0.9) (100.8) (8.7) 
 
 (110.4)
Effective portion of interest rate cap agreements

0.2









0.2
Premium payments on interest rate cap agreements
 (12.6) 
 
 
 
 (12.6)
Proceeds from stock option exercises
 9.1
 
 
 
 
 9.1

 19.9
 
 
 
 
 19.9
Proceeds from Coworker Stock Purchase Plan
 7.6
 
 
 
 
 7.6

 5.4
 
 
 
 
 5.4
Repurchases of common stock(534.0) 
 
 
 
 
 (534.0)(176.4) 
 
 
 
 
 (176.4)
Payment of incentive compensation plan withholding taxes
 (16.0) (24.0) (2.0) 
 
 (42.0)(8.7) 
 
 
 
 
 (8.7)
Dividends(74.7) 
 
 
 
 
 (74.7)(63.8) 
 
 
 
 
 (63.8)
Principal payments under capital lease obligations
 
 (0.3) (0.8) 
 
 (1.1)
Repayment of intercompany loan
 
 34.3
 (34.3) 
 
 

 
 47.5
 (47.5) 
 
 
Other
 3.6
 (0.2) (0.2) 
 
 3.2
Distributions and advances from (to) affiliates566.3
 (202.6) (374.0) 
 
 10.3
 
248.9
 46.3
 (288.5) 
 
 (6.7) 
Net cash used in financing activities(42.4)
(85.7)
(420.7)
(9.1)


10.3

(547.6)
Net cash (used in) provided by financing activities
 53.2
 (342.0) (42.7) 
 (6.7) (338.2)
Effect of exchange rate changes on cash and cash equivalents
 
 
 1.3
 
 
 1.3

 
 
 (4.0) 
 
 (4.0)
Net decrease in cash and cash equivalents
 (143.4) (3.1) (7.6) 
 (11.7) (165.8)
Net (decrease) increase in cash and cash equivalents
 (42.8) 
 20.0
 
 (20.7) (43.5)
Cash and cash equivalents—beginning of period
 222.7
 3.1
 37.9
 
 
 263.7

 113.7
 
 32.4
 
 (1.9) 144.2
Cash and cash equivalents—end of period$
 $79.3
 $
 $30.3
 $
 $(11.7) $97.9
$
 $70.9
 $
 $52.4
 $
 $(22.6) $100.7

2635

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

Condensed Consolidating Statement of Cash Flows
Nine Months Ended September 30, 2016
Six Months Ended June 30, 2017Six Months Ended June 30, 2017
(as adjusted)(as adjusted)
(in millions)
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Parent
Guarantor
 
Subsidiary
Issuer
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 Co-Issuer 
Consolidating
Adjustments
 Consolidated
Net cash provided by (used in) operating activities$
 $(91.9) $495.7
 $62.8
 $
 $32.7
 $499.3
$
 $(22.1) $391.5
 $40.7
 $
 $(33.9) $376.2
Cash flows used in investing activities:                          
Capital expenditures
 (35.4) (3.2) (2.8) 
 
 (41.4)
 (26.6) (4.3) (5.9) 
 
 (36.8)
Premium payments on interest rate cap agreements
 (2.1) 
 
 
 
 (2.1)
Net cash used in investing activities
 (37.5) (3.2) (2.8) 
 
 (43.5)
 (26.6) (4.3) (5.9) 
 
 (36.8)
Cash flows from (used in) financing activities:             
Proceeds from borrowings under revolving credit facility
 329.7
 
 2.4
 
 
 332.1
Repayments of borrowings under revolving credit facility
 (329.7) 
 (2.4) 
 
 (332.1)
Cash flows (used in) provided by financing activities:             
Proceeds from borrowings under revolving credit facilities
 54.0
 
 13.7
 
 
 67.7
Repayments of borrowings under revolving credit facilities
 
 
 (13.7) 
 
 (13.7)
Repayments of long-term debt
 (11.4) 
 (5.6) 
 
 (17.0)
 (7.5) 
 
 
 
 (7.5)
Proceeds from issuance of long-term debt
 1,483.0
 
 
 
 
 1,483.0

 2,083.0
 
 
 
 
 2,083.0
Payments to extinguish long-term debt
 (1,490.4) 
 
 
 
 (1,490.4)
 (2,121.3) 
 
 
 
 (2,121.3)
Net change in other long-term obligation
 
 15.7
 
 
 
 15.7
Payment of debt financing costs
 (4.5) 
 (1.4) 
 
 (5.9)
 (9.6) 
 
 
 
 (9.6)
Net change in accounts payable - inventory financing
 1.4
 41.0
 (3.2) 
 
 39.2
Net change in accounts payable-inventory financing
 (1.2) (83.9) 
 
 
 (85.1)
Proceeds from stock option exercises
 6.0
 
 
 
 
 6.0

 7.4
 
 
 
 
 7.4
Proceeds from Coworker Stock Purchase Plan
 6.9
 
 
 
 
 6.9

 4.7
 
 
 
 
 4.7
Repurchases of common stock(355.0) 
 
 
 
 
 (355.0)(359.4) 
 
 
 
 
 (359.4)
Payment of incentive compensation plan withholding taxes
 (16.0) (24.0) (2.0) 
 
 (42.0)
Dividends(53.1) 
 
 
 
 
 (53.1)(50.3) 
 
 
 
 
 (50.3)
Principal payments under capital lease obligations
 
 0.8
 (1.1) 
 
 (0.3)
Repayment of intercompany loan
 
 40.4
 (40.4) 
 
 

 
 34.3
 (34.3) 
 
 
Other
 
 (0.1) (0.5) 
 
 (0.6)
Distributions and advances from (to) affiliates408.1
 195.6
 (590.4) 
 
 (13.3) 
409.7
 (100.5) (316.6) 
 
 7.4
 
Net cash provided by (used in) financing activities
 186.6
 (492.5) (51.7) 
 (13.3) (370.9)
Net cash used in financing activities
 (107.0) (390.3) (36.8) 
 7.4
 (526.7)
Effect of exchange rate changes on cash and cash equivalents
 
 
 (4.2) 
 
 (4.2)
 
 
 2.6
 
 
 2.6
Net increase in cash and cash equivalents
 57.2
 
 4.1
 
 19.4
 80.7
Net (decrease) increase in cash and cash equivalents
 (155.7) (3.1) 0.6
 
 (26.5) (184.7)
Cash and cash equivalents—beginning of period
 45.1
 
 31.9
 
 (39.4) 37.6

 222.7
 3.1
 37.9
 
 
 263.7
Cash and cash equivalents—end of period$
 $102.3
 $
 $36.0
 $
 $(20.0) $118.3
$
 $67.0
 $
 $38.5
 $
 $(26.5) $79.0
 

27

Table of Contents
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS

15.Subsequent Events

On November 1, 2017, the Company announced that its Board of Directors declared a quarterly cash dividend of $0.21 per common share to be paid on December 11, 2017 to all stockholders of record as of the close of business on November 24, 2017. Future dividends will be subject to Board of Directors approval.




2836

Table of Contents


Item 2. Management’sManagement's Discussion and Analysis of Financial Condition and Results of Operations
Unless otherwise indicated or the context otherwise requires, as used in this “Management’s"Management's Discussion and Analysis of Financial Condition and Results of Operations," the terms “we,” “us,” “the"we," "us," "the Company,” “our,” “CDW”" "our," "CDW" and similar terms refer to CDW Corporation and its subsidiaries. “Management’s"Management's Discussion and Analysis of Financial Condition and Results of Operations”Operations" should be read in conjunction with the unaudited interim Consolidated Financial Statements and the related notes included elsewhere in this report and with the audited Consolidated Financial Statements and the related notes included in the Company’s CurrentCompany's Annual Report on Form 8-K dated August 25,10-K for the year ended December 31, 2017. This discussion contains forward-looking statements that are subject to numerous risks and uncertainties. Actual results may differ materially from those contained in any forward-looking statements. See “Forward-Looking Statements”"Forward-Looking Statements" at the end of this discussion.
Overview

CDW Corporation (“Parent”("Parent") is a Fortune 500 company with multi-national capabilities and a leading provider of integrated information technology (“IT”("IT") solutions to small, medium and large business, and government, education and healthcare customers in the United States Canada and("US"), the United Kingdom.Kingdom ("UK") and Canada. Our broad array of offerings rangeranges from discrete hardware and software products to integrated IT solutions such as mobility, security, data center optimization, cloud computing, virtualization and collaboration.

We are technology “agnostic,”"agnostic," with a product portfolio including more than 100,000 products and services from more than 1,000 leading and emerging brands. Our solutions are delivered in physical, virtual and cloud-based environments. We provide our products and solutionsenvironments through over 5,5006,000 customer-facing coworkers, including sellers, highly-skilled technology specialists and advanced service delivery engineers. We are a leading sales channel partner for many original equipment manufacturers (“OEMs”("OEMs"), software publishers and cloud providers (collectively, our “vendor partners”"vendor partners"), whose products we sell or include in the solutions we offer. We provide our vendor partners with a cost-effective way to reach customers and deliver a consistent brand experience through our established end-market coverage, technical expertise and extensive customer access.
We have three reportable segments, Corporate, Small Business and Public. Our Corporate segment primarily serves US private sector business customers with more than 250 employees. Our Small Business segment primarily serves US private sector business customers with up to 250 employees. Our Public segment is comprised of government agencies and education and healthcare institutions in the US. We also have two other operating segments: CDW CanadaUK and CDW UK,Canada, each of which do not meet the reportable segment quantitative thresholds and, accordingly, are included in an all other category (“Other”("Other"). Effective January 1, 2017, we established Small Business as a separate operating and reportable segment to align our financial reporting with the manner in which the Chief Operating Decision Maker assesses performance and makes resource allocation decisions. By separating Small Business from our Corporate segment, we will drive increased focus and accountability for both segments. To achieve our vision to be small business customers' “first choice for technology,” we are aligning coworkers and digital resources that point directly at this growing market. The Small Business results were previously presented within the Corporate segment as a sales channel and the channel was primarily serving private sector business customers with up to 100 employees.
We may sell all or only select products that our vendor partners offer. Each vendor partner agreement provides for specific terms and conditions, which may include one or more of the following: product return privileges, price protection policies, purchase discounts and vendor incentive programs, such as purchase or sales rebates and cooperative advertising reimbursements. We also resell software for major software publishers. Our agreements with software publishers allow the end-user customer to acquire software or licensed products and services. In addition to helping our customers determine the best software solutions for their needs, we help them manage their software agreements, including warranties and renewals. A significant portion of our advertising and marketing expenses are reimbursed through cooperative advertising programs with our vendor partners. These programs are at the discretion of our vendor partners and are typically tied to sales or other commitments to be met by us within a specified period of time.

Effective January 1, 2018, we adopted the requirements of ASU 2014-09, Revenue from Contracts with Customers, as amended ("Topic 606"), utilizing the full retrospective method as discussed in Note 2 (Recent Accounting Pronouncements) to the accompanying Consolidated Financial Statements. Prior period amounts have been adjusted accordingly.
Trends and keyKey factors affecting our financial performance
We believe the following trendskey factors may have an importanta meaningful impact on our business performance, influencing our ability to generate sales and achieve our targeted financial performance:and operating results:
General economic conditions are a key factor affecting our ability to generate sales and achieve our targeted operating results as they impact our customers’ willingness to spend on information technology. This is particularly the case for business customers, as their purchases tend to reflect confidence in their business prospects, which are driven by their perceptions of business conditions. Purchasing behavior may be different between our Corporate customers and Small Business customers due to their perceptionsperception of business conditions. Additionally, changes in trade policy could have an adverse impact on our business.
Changes in spending policies, budget priorities and funding levels are a key factor influencing the purchasing levels of government, healthcare and education customers.

2937

Table of Contents


Changes in spending policies, budget priorities and revenue levels are a key factor influencing government purchasing levels. Our Government results also reflect increased interest in meeting public safety needs through technology solutions by state and local customers, as well as our ability to address strategic changes made by the Federal government toward a more programmatic technology strategy.
Customer focus on security has been, and we expect will continue to be, an ongoing trend. Customers are seeking solutions to protect their internal systems against threats and are implementing solutions that provide enterprise-wide visibility, detection expertise and investigation workflows. They are also implementing endpoint security, firewall segmentation and user authentication tools. 
The Healthcare industry continues to experience uncertainty given recent proposed legislative action and concerns related to funding, which is impacting healthcare spending as customers seek more clarity.
Our Education sales channel performance continues to benefit from the creation of new learning environments for students. It has also been affected by the implementation of networking projects related to the US Federal Communications Commission E-Rate program. Within the higher education market, networking projects continue to be a key priority across campuses. While technology is an opportunity to create cost savings and improve productivity, funding is a key determinant of technology spending in education.
There continues to be substantial uncertainty regarding the impact of Brexit. Potential adverse consequences of Brexit such as global market uncertainty, volatility in currency exchange rates, greater restrictions on imports and exports between UK and EU countries and increased regulatory complexities could have a negative impact on our business, financial condition and results of operations. To date, CDW UK is not seeing significant changes in the buying behavior of its customers even with the uncertainty related to timing and terms of Brexit.
Technology trends drive customer purchasepurchasing behaviors and we are seeing continuing evolution in the market. Innovation influences customer purchases across all of our customer end-markets. KeyCurrent technology trends in technology include increasing adoption of cloud-based solutions for certain key workloads, including backupare focused on delivering greater flexibility and recovery, collaboration and security,efficiency, as well as designing IT securely. These trends are driving customer adoption of hyper-converged appliances to deliver greater flexibilitysolutions such as those delivered via cloud, software defined architectures and efficiency. In addition, hybrid IT solutions are being adopted, along with software being embedded into solutions.

on-premise and off-premise combinations.
Key business metrics
We monitor a number of financial and non-financial measures and ratios on a regular basis in order to track the progress of our business and make adjustments as necessary. We believe that the most important of these measures and ratios include average daily sales, gross margin, operating margin, Net income, Non-GAAP income before income taxes, Non-GAAP net income, Net income per common share, Non-GAAP net income per diluted share, EBITDA, and Adjusted EBITDA, Adjusted EBITDA margin, free cash flow, return on investedworking capital, Cash and cash equivalents, net working capital, cash conversion cycle (defined to be days of sales outstanding in Accounts receivable plus days of supply in Inventory minus days of purchases outstanding in Accounts payable, including both trade and inventory-financing, based on a rolling three-month average), debt levels including available credit and leverage ratios, sales per coworker and coworker turnover. These measures and ratios are compared to standards or objectives set by management, so that actions can be taken, as necessary, in order to achieve the standards and objectives.
In this Form 10-Q, we discuss Non-GAAP income before income taxes, Non-GAAP net income, Non-GAAP net income per diluted share, EBITDA, Adjusted EBITDA and Adjusted EBITDA and consolidated Net sales growth on a constant currency basis,margin, which are non-GAAP financial measures.
We believe these measures provide analysts, investors and management with helpful information regarding the underlying operating performance of our business, as they remove the impact of items that management believes are not reflective of underlying operating performance. Management uses these measures to evaluate period-over-period performance as management believes they provide a more comparable measure of the underlying business. Additionally, Adjusted EBITDA is a measure in the credit agreement governing our Senior Secured Term Loan Facility (“("Term Loan”Loan"), which is used to evaluate our ability to make certain investments, incur additional debt, and make restricted payments, such as dividends and share repurchases, as well as whether we are required to make additional principal prepayments on the Term Loan beyond the quarterly amortization payments. For further details regarding the Term Loan, see Long-Term Debt and Financing Arrangements within Management’sManagement's Discussion and Analysis of Financial Condition and Results of Operations and Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements. For the definitions of Non-GAAP income before income taxes, Non-GAAP net income and Adjusted EBITDA and consolidated Net sales growth on a constant currency basis and reconciliations to Net income, see “Results"Results of Operations”.


30

Table of Contents

Operations."

The results of certain of our key business metrics are as follows:
Three Months Ended September 30,Three Months Ended June 30,
(dollars in millions)2017 20162018 
2017(1)
Net sales$4,033.9
 $3,708.2
$4,186.1
 $3,891.7
Gross profit642.0
 614.3
695.6
 640.8
Income from operations243.7
 237.5
265.5
 230.8
Net income129.2
 125.9
173.0
 140.9
Non-GAAP net income168.2
 160.3
213.2
 163.0
Adjusted EBITDA324.3
 310.4
344.7
 314.5
Average daily sales (1)(2)
64.0
 57.9
65.4
 60.8
Net debt (2)(3)
3,332.0
 3,123.1
3,139.6
 3,217.3
Cash conversion cycle (in days) (3)(4)
19
 18
17
 16
(1)There were 63 and 64 selling daysAmounts for 2017 have been adjusted to reflect the three months ended September 30, 2017 and 2016, respectively.adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).
(2)Defined as total debt minus cashThere were 64 selling days for both the three months ended June 30, 2018 and cash equivalents; $3,430 million minus $98 million as of September 30, 2017 and $3,241 million minus $118 million as of September 30, 2016.2017.
(3)Defined as Total debt minus Cash and cash equivalents.
(4)Cash conversion cycle is defined as days of sales outstanding in Accounts receivable and certain receivables due from vendors plus days of supply in Merchandise inventory minus days of purchases outstanding in Accounts payable and Accounts payable-inventory financing, based on a rolling three-month average.

38

Table of Contents


Results of Operations
Three Months Ended SeptemberJune 30, 20172018 Compared to Three Months Ended SeptemberJune 30, 20162017
Results of operations, in dollars and as a percentage of Net sales are as follows:
 Three Months Ended September 30, Three Months Ended June 30,
 2017 2016 2018 
2017(1)
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
Net sales $4,033.9
 100.0 % $3,708.2
 100.0 % $4,186.1
 100.0 % $3,891.7
 100.0 %
Cost of sales 3,391.9
 84.1
 3,093.9
 83.4
 3,490.5
 83.4
 3,250.9
 83.5
Gross profit 642.0
 15.9
 614.3
 16.6
 695.6
 16.6
 640.8
 16.5
Selling and administrative expenses 352.0
 8.7
 334.9
 9.0
 381.4
 9.1
 363.5
 9.3
Advertising expense 46.3
 1.1
 41.9
 1.1
 48.7
 1.2
 46.5
 1.2
Income from operations 243.7
 6.0
 237.5
 6.4
 265.5
 6.3
 230.8
 5.9
Interest expense, net (37.8) (0.9) (37.6) (1.0) (37.2) (0.9) (35.9) (0.9)
Net loss on extinguishments of long-term debt 
 
 (2.1) (0.1)
Other income 0.7
 
 0.4
 
Other income, net 1.5
 
 0.4
 
Income before income taxes 206.6
 5.1
 198.2
 5.3
 229.8
 5.5
 195.3
 5.0
Income tax expense (77.4) (1.9) (72.3) (1.9) (56.8) (1.4) (54.4) (1.4)
Net income $129.2
 3.2 % $125.9
 3.4 % $173.0
 4.1 % $140.9
 3.6 %
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.

3139

Table of Contents



Net sales
Net sales by segment, in dollars and as a percentage of total Net sales, and the year-over-year dollar and percentage change in Net sales are as follows:
 Three Months Ended September 30,     Three Months Ended June 30,    
 2017 2016     2018 
2017(1)
    
(dollars in millions) Net Sales 
Percentage
of Total Net Sales
 
Net Sales(1)
 
Percentage
of Total Net Sales
 
Dollar
Change
 
Percent
Change(2)
 Net Sales 
Percentage
of Total Net Sales
 Net Sales 
Percentage
of Total Net Sales
 
Dollar
Change
 
Percent
Change(2)
Corporate $1,598.5
 39.6% $1,466.4
 39.6% $132.1
 9.0 % $1,733.8
 41.4% $1,580.1
 40.6% $153.7
 9.7 %
                        
Small Business 311.5
 7.7
 282.5
 7.6
 29.0
 10.3
 329.5
 7.9
 315.0
 8.1
 14.5
 4.6
                        
Public:                        
Government 606.7
 15.0
 537.5
 14.5
 69.2
 12.9
 493.5
 11.8
 523.4
 13.5
 (29.9) (5.7)
Education 700.7
 17.4
 671.4
 18.1
 29.3
 4.4
 712.1
 17.0
 704.9
 18.1
 7.2
 1.0
Healthcare 425.5
 10.6
 431.7
 11.6
 (6.2) (1.4) 429.8
 10.3
 404.5
 10.4
 25.3
 6.3
Total Public 1,732.9
 43.0
 1,640.6
 44.2
 92.3
 5.6
 1,635.4
 39.1
 1,632.8
 42.0
 2.6
 0.2
                        
Other 391.0
 9.7
 318.7
 8.6
 72.3
 22.6
 487.4
 11.6
 363.8
 9.3
 123.6
 34.0
                        
Total net sales $4,033.9
 100.0% $3,708.2
 100.0% $325.7
 8.8 % $4,186.1
 100.0% $3,891.7
 100.0% $294.4
 7.6 %
(1)Effective January 1,Amounts for 2017 Small Business is now an operating and reportable segment. Its results were previously presented as a sales channel within the Corporate segment. Prior periods have been recastadjusted to conform toreflect the current period presentation.adoption of Topic 606.
(2)
There were 63 and 64 selling days for both the three months ended SeptemberJune 30, 20172018 and 2016, respectively.2017.
Total Net sales for the three months ended SeptemberJune 30, 20172018 increased $326$294 million, or 8.8%7.6%, to $4,034$4,186 million, compared to $3,708$3,892 million for the three months ended SeptemberJune 30, 2016. Net sales on a constant currency basis, which excludes2017. Excluding the impact of foreign currency translation, for the three months ended September 30, 2017 increased $321 million, or 8.7%, to $4,034 million, compared to $3,713 million for the three months ended September 30, 2016. Therefluctuations, constant currency Net sales growth was one fewer selling day in the third quarter of 2017 compared to the third quarter of 2016 and net sales on an average daily sales basis increased 10.5%7.0%. See “Non-GAAP"Non-GAAP Financial Measure Reconciliations”Reconciliations" below for additional information.information regarding constant currency Net sales growth.
For the three months ended SeptemberJune 30, 2017, sales growth was driven by all of our customer-facing end markets except healthcare. Market trends during the quarter remained similar to those experienced in the first half of 2017, with accelerated hardware sales and2018, ongoing focus on optimization and efficiency, security and integration of software into solutions. These trendsclient device refresh across all customer-end markets, except Federal, coupled with strong results from our international operations, drove significant growth in both transactions and solutions, driven by growth in client devices, netcomm equipment, enterprise storage and video.Net sales growth.
Corporate segment Net sales for the three months ended SeptemberJune 30, 20172018 increased $132$154 million, or 9.0%9.7%, compared to the three months ended SeptemberJune 30, 2016. Momentum experienced in the first half of 2017 continued to build during the current quarter2017. Growth was primarily driven by client device refresh, as well as ongoing success helping customers with more projects moving from the back-burner to the front. Corporate saw increases in transactional items, such as notebookssolutions, including data center and mobile devices, and solutions, such as netcomm equipment and enterprise storage.software.
Small Business segment Net sales for the three months ended SeptemberJune 30, 20172018 increased by $29$15 million, or 10.3%4.6%, between periods, as customer confidence remained strong.periods. Sales growth was primarily in transactional products, leddriven by notebooks and mobile devices.client device refresh.
Public segment Net sales for the three months ended SeptemberJune 30, 20172018 increased $92$3 million, or 5.6%0.2%, compared to the three months ended SeptemberJune 30, 2016, with strong growth in transactional sales.2017. The growth was fueledprimarily driven by a 12.9% increaseHealthcare, which offset declines in sales to Government customers. Strong Net sales to our State and Local government customers wasin Healthcare increased 6.3%, primarily driven by a continued focusperformance in desktops and video products as customers move forward on public safety and new contracts. Netrefresh projects. The decline in sales to Federal government customers continued to reflect focus on spending existing budgets on planned projects and ongoing successful alignment with strategic programs. Federal sales also benefited from the partial shipment of a 2016primarily reflected lower client device order delayed into 2017. Education results reflected growth from both Higher Education and K-12 customers. Salessales. This was partially offset by sales to our Higher EducationState & Local government customers, grew double-digits,which were primarily driven by client devicesdevice refresh. Education Net sales increased 1.0%.
Net sales in Other, which is comprised of results from our UK and collaborationCanadian operations, for the three months ended June 30, 2018 increased $124 million, or 34.0%, compared to the three months ended June 30, 2017. Both operations had strong growth in local currency as institutions continuewe continued to enhance their technology offerings to meettake share in the needs of students. K-12local markets. In addition, UK growth was leddriven in part by solutions basedincreased sales from referrals for US-based customers. The impact of foreign currency exchange increased Other sales growth by approximately 700 basis points, due to the favorable impact resulting from the British pound and Canadian dollar to US dollar translations.

3240

Table of Contents


products, particularly software and networking, as well as success helping schools implement collaborative learning environments. Net sales to Healthcare customers decreased 1.4% between periods, primarily due to one fewer selling day during the quarter. Additionally, many customers put purchase decisions on hold awaiting more definitive legislative direction on funding and reimbursements.
Net sales in Other for the three months ended September 30, 2017 increased $72 million, or 22.6%, compared to the three months ended September 30, 2016. Other is comprised of results from our Canadian and UK operations. Both operations had strong growth, each up over 20% compared to the prior year. The impact of currency translation increased Other sales growth by approximately 160 basis points.
Gross profit
Gross profit increased $28$55 million, or 4.5%8.6%, to $642$696 million for the three months ended SeptemberJune 30, 2017,2018, compared to $614$641 million for the three months ended SeptemberJune 30, 2016.2017. As a percentage of Net sales, Gross profit decreased 70margin increased 10 basis points to 15.9% for the three months ended September 30, 2017, down from 16.6% for the three months ended SeptemberJune 30, 2016. Although there was an increase in2018. Gross profit due to higher sales volumes, we experienced a decline in our gross profit margin. This decline wasmargin improvement primarily driven by a 60 basis point decline inreflected the positive impact on product margin due to increased hardware sales, particularly in client devices, which generally have lower profit margins, and an ongoing competitive marketplace.
Gross profit margin may fluctuate based on various factors, including vendor incentive and inventory price protection programs, cooperative advertising funds classified as a reduction of cost of sales, product mix, net service contract revenue, commission revenue, pricing strategies, market conditions and other factors.customer mix.
Selling and administrative expenses
Selling and administrative expenses increased $17 million, or 5.1%4.9%, to $352$381 million for the three months ended SeptemberJune 30, 2017,2018, compared to $335$364 million for the three months ended SeptemberJune 30, 2016. 2017. This was driven by higher sales payroll costs, including sales commissions primarily due to higher Gross profit dollars, partially offset by lower equity-based compensation expense and the associated payroll taxes due to the vesting in the prior year of an equity grant made at the time of our initial public offering. Total coworker count was 8,917, up 130 from 8,787 at June 30, 2017. Total coworker count was 8,726 at December 31, 2017.
As a percentage of total Net sales, Selling and administrative expenses decreased by 3020 basis points to 8.7% in the third quarter of 2017, down from 9.0% in the third quarter of 2016. Sales payroll costs increased $8 million, or 5.1%, between periods due to higher sales volumes and was consistent with Gross profit growth. Total coworker count was 8,722 at September 30, 2017, up 157 from 8,565 at September 30, 2016. Total coworker count was 8,516 at December 31, 2016. During9.1% during the three months ended SeptemberJune 30, 2017, a retroactive Illinois state law change was enacted which required2018, down from 9.3% in the reinstatement of prior year unclaimed property balances, resulting in an additional $4 million of expenses.three months ended June 30, 2017.

33

Table of Contents


Income from operations
Income from operations by segment, in dollars and as a percentage of Net sales, and the year-over-year percentage change are as follows:
 Three Months Ended September 30,   Three Months Ended June 30,  
 2017 2016   2018 
2017(1)
  
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Percent Change
in Income
from Operations
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Percent Change
in Income
from Operations
Segments:(1)(2)
                    
Corporate $121.0
 7.6% $120.0
 8.2% 0.9 % $141.3
 8.1% $126.9
 8.0% 11.4%
Small Business(2)
 17.7
 5.7
 18.0
 6.4
 (1.4) 24.6
 7.5
 19.4
 6.2
 26.8
Public 122.3
 7.1
 120.0
 7.3
 1.9
 113.0
 6.9
 104.6
 6.4
 8.0
Other(3)
 14.5
 3.7
 10.0
 3.1
 45.9
 21.7
 4.5
 12.5
 3.4
 73.7
Headquarters(4)
 (31.8) nm*
 (30.5) nm*
 4.4
 (35.1) nm*
 (32.6) nm*
 7.7
Total income from operations $243.7
 6.0% $237.5
 6.4% 2.6 % $265.5
 6.3% $230.8
 5.9% 15.1%
* Not meaningful
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Segment income from operations includes the segment’s direct operating income, allocations for Headquarters’ costs, allocations for income and expenses from logistics services, certain inventory adjustments and volume rebates and cooperative advertising from vendors.
(2)Effective January 1, 2017, Small Business is its own operating and reportable segment. The prior period has been recast to conform to the current period presentation.
(3)Includes the financial results for our other operating segments, CDW CanadaUK and CDW UK,Canada, which do not meet the reportable segment quantitative thresholds.
(4)Includes certain Headquarters’Headquarters' function costs that are not allocated to the segments.
Income from operations was $244$266 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $6$35 million, or 2.6%15.1%, compared to $238$231 million for the three months ended SeptemberJune 30, 2016.2017. Income from operations increased primarily due to higher gross profit dollars, partially offset by higher Selling and administrativesales payroll expenses. Total operating margin percentage decreasedincreased 40 basis points to 6.0%6.3% for the three months ended SeptemberJune 30, 2017,2018, from 6.4%5.9% for the three months ended SeptemberJune 30, 2016.2017. Operating margin percentage was positively impacted by a declinethe increase in Gross profit margin, driven by improved product margin. Also contributing to the increased operating margin due to increased hardware sales, particularly in client devices, which generally havepercentage were lower profit margins, an ongoing competitive marketplaceequity-based compensation expenses and the impactassociated payroll taxes, the non-recurrence of integration expenses in the reinstatement of priorcurrent year unclaimed property balances, partially offset by a decrease in sales payroll costsand intangible asset amortization expenses as a percentage of Net sales.sales, which do not trend in line with sales movement.
Corporate segment income from operations was $121$141 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $1$14 million, or 0.9%11.4%, compared to $120$127 million for the three months ended SeptemberJune 30, 2016.2017. Corporate segment income from operations increased primarily due to higher gross profit dollars driven by higher sales. Corporate segment operating margin

41

Table of Contents


percentage decreased 60increased 10 basis points to 7.6%8.1% for the three months ended SeptemberJune 30, 2017,2018, from 8.2%8.0% for the three months ended SeptemberJune 30, 2016.2017. This decreaseincrease in operating margin percentage was primarily due to a decline in product margin due to increased hardware sales, particularly in client devices, which generally havedriven by the benefit of lower profit margins, an ongoing competitive marketplaceSelling and the impact of the reinstatement of prior year unclaimed property balances, partially offset by a decrease in sales payroll costsadministrative expenses as a percentage of Net sales. This was partially offset by product margin compression due to increased hardware sales.
Small Business segment income from operations was $18$25 million for both the three months ended SeptemberJune 30, 20172018, an increase of $6 million, or 26.8%, compared to $19 million for the three months ended June 30, 2017. Small business segment income from operations increased primarily due to higher gross profit dollars driven by higher sales and 2016, a decrease of 1.4%.product margin. Small Business segment operating margin percentage decreased 70increased 130 basis points to 5.7%7.5% for the three months ended SeptemberJune 30, 2017,2018, from 6.4%6.2% for the three months ended SeptemberJune 30, 2016.2017. This decreaseincrease in operating margin percentage was primarily due to a decline indriven by higher product margin due to increased hardware sales, particularly in client devices, which generally haveand the benefit of lower profit margins, and an ongoing competitive marketplace, partially offset by a decrease in sales payroll costsexpenses as a percentage of Net sales.
Public segment income from operations was $122$113 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $2$8 million, or 1.9%8.0%, compared to $120$105 million for the three months ended SeptemberJune 30, 2016.2017. Public segment income from operations increased primarily due to higher Gross profit dollars driven by improved product margin. Public segment operating margin percentage decreased 20increased 50 basis points to 7.1%6.9% for the three months ended SeptemberJune 30, 2017,2018, from 7.3%6.4% for the three months ended SeptemberJune 30, 2016. The decrease2017. This increase in operating margin percentage was primarily driven by increased hardware sales, an

34

Table of Contents


ongoing competitive marketplacehigher product margin and the impactbenefit of the reinstatement of prior year unclaimed property balances, partially offset by a decrease inlower sales payroll costsexpenses as a percentage of Net sales.
Other income from operations was $15$22 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $5$9 million, or 45.9%73.7%, compared to $10$13 million for the three months ended SeptemberJune 30, 2016.2017. Other income from operations increased primarily due to higher sales volumes and Gross profit as we continue to take share in the local markets, and favorable foreign exchange. Other operating margin percentage increased 60110 basis points to 3.7%4.5% for the three months ended SeptemberJune 30, 2017,2018, from 3.1%3.4% for the three months ended SeptemberJune 30, 2016. Operating margin improvement2017. This increase was primarily driven bydue to lower sales payroll expenses and intangible asset amortization expense as a percentage of Net sales.
Net loss on extinguishments of long-term debt
During the three months ended September 30, 2017, there were no extinguishments of long-term debt compared Also contributing to the same periodincreased operating margin percentage is the non-recurrence of integration expenses in 2016 when we incurred a net loss on extinguishment of long-term debt of $2 million.the current year.
Income tax expense
Income tax expense was $77$57 million for the three months ended SeptemberJune 30, 2017,2018, compared to $72$54 million for the same period of the prior year. The effective income tax rate, expressed by calculating the income tax expense as a percentage of Income before income taxes, was 37.5%24.7% for the three months ended SeptemberJune 30, 2017 compared2018 and differed from the US federal statutory rate of 21.0% primarily due to 36.5%state income taxes partially offset by excess tax benefits on equity-based compensation. The effective tax rate for the same period of the prior year. year was 27.9% and differed from the US federal statutory rate of 35.0% primarily due to excess tax benefits on equity-based compensation.

The higherlower effective tax rate for the three months ended SeptemberJune 30, 20172018 as compared to the same period of the prior year was primarily attributable to differences in discrete items recordedthe reduction in the respective periods. For the three months ended September 30, 2017, we recognized a $1 million deferred tax expense as a result of a change in state tax rates, which was largelyUS federal statutory rate, partially offset by thelower excess tax benefit of $1 million related tobenefits on equity-based compensation and a higher effective net state income tax refund, while we recognized $1 million of tax benefits forrate primarily due to the same period of the prior year as a result of tax benefits related to equity-based compensation.reduced US federal benefit.
Non-GAAP Financial Measure Reconciliations
We have included reconciliations of Non-GAAP income before income taxes, Non-GAAP net income, EBITDA, Adjusted EBITDA, Adjusted EBITDA margin and consolidated Net sales growth on a constant currency basis for the three months ended SeptemberJune 30, 20172018 and 20162017 below.
Non-GAAP income before income taxes and Non-GAAP net income excludes,exclude, among other things, charges related to the amortization of acquisition-related intangible assets, equity-based compensation and associated taxes, integration expenses, and gains and losses from the extinguishment of long-term debt.debt and integration expenses. EBITDA is defined as consolidated net income before interest expense, net, income tax expense, depreciation and amortization. Adjusted EBITDA, which is a measure defined in our credit agreements, means EBITDA adjusted for certain items which are described in the table below. Adjusted EBITDA margin is defined as Adjusted EBITDA as a percentage of Net sales. Consolidated Net sales growth on a constant currency basis is defined as consolidated Net sales growth excluding the impact of foreign currency translation on net sales compared to the prior period.
Non-GAAP income before income taxes, Non-GAAP net income, EBITDA, Adjusted EBITDA, Adjusted EBITDA margin and consolidated Net sales growth on a constant currency basis are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a company’scompany's performance or financial position that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by management may differ from similar measures used by other companies, even when similar terms are used to identify such measures.

42

Table of Contents


We believe these measures provide analysts, investors and management with helpful information regarding the underlying operating performance of our business, as they remove the impact of items that management believes are not reflective of underlying operating performance. Management uses these measures to evaluate period-over-period performance as management believes they provide a more comparable measure of the underlying business. Additionally, Adjusted EBITDA is a measure in the credit agreement governing our Senior Secured Term Loan Facility (“Term Loan”) that is used to evaluate our ability to make certain investments, incur additional debt, and make restricted payments, such as dividends and share repurchases, as well as whether we are required to make additional principal prepayments on the Term Loan beyond the quarterly amortization payments. For further details regarding the Term Loan, see Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements.    


35

Table of Contents


Non-GAAP net income
Non-GAAP net income was $168$213 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $8$50 million, or 4.9%30.8%, compared to $160$163 million for the three months ended SeptemberJune 30, 2016.2017.
  Three Months Ended September 30,
(in millions) 2017 2016
Net income $129.2
 $125.9
Amortization of intangibles(1)
 46.5
 46.5
Equity-based compensation 10.0
 10.0
Net loss on extinguishments of long-term debt 
 2.1
Integration expenses(2)
 
 2.4
Reinstatement of prior year unclaimed property balances(3)
 4.1
 
Other adjustments(4)
 (0.2) (3.3)
Aggregate adjustment for income taxes(5)
 (21.4) (23.3)
Non-GAAP net income $168.2
 $160.3
  Three Months Ended June 30,
  2018 
2017(1)
(dollars in millions) Income before income taxes 
Income tax expense(2)
 Net income Income before income taxes 
Income tax expense(2)
 Net income
GAAP (as reported) $229.8
 $(56.8) $173.0
 $195.3
 $(54.4) $140.9
Amortization of intangibles(3)
 46.6
 (11.7) 34.9
 46.3
 (16.7) 29.6
Equity-based compensation 11.0
 (6.3) 4.7
 11.5
 (22.6) (11.1)
Integration expenses(4)
 
 
 
 2.0
 (0.7) 1.3
Other adjustments(5)
 0.7
 (0.1) 0.6
 3.7
 (1.4) 2.3
Non-GAAP $288.1
 $(74.9) $213.2
 $258.8
 $(95.8) $163.0
(1)
Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Income tax on non-GAAP adjustments includes excess tax benefits associated with equity compensation. Additionally, 2018 includes the impact of global intangible low tax income ("GILTI") on equity-based compensation and amortization of intangibles.
(3)Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.
(2)
Comprised of expenses related to CDW UK.
(3)Comprised of the reinstatement of prior year unclaimed property balances as a result of a retroactive Illinois state law change enacted in the third quarter of 2017.
(4)The three months ended September 30, 2016 primarily includes our shareComprised of the settlement payments received from the Dynamic Random Access Memory class action lawsuits and the favorable resolution of a local sales tax matter, partially offset by expenses related to the consolidation of office locations north of Chicago.CDW UK.
(5)Aggregate adjustment for incomeIncludes other expenses such as payroll taxes consists ofon equity-based compensation during the following:three months ended June 30, 2018 and 2017.
  Three Months Ended September 30,
  2017 2016
Total Non-GAAP adjustments $60.4
 $57.7
Weighted-average statutory effective rate 36.0% 36.0%
Income tax (21.7) (20.8)
Excess tax benefits from equity-based compensation (0.6) (1.2)
Non-deductible adjustments and other 0.9
 (1.3)
Total aggregate adjustment for income taxes $(21.4) $(23.3)

3643

Table of Contents


Adjusted EBITDA
Adjusted EBITDA was $324$345 million for the three months ended SeptemberJune 30, 2017,2018, an increase of $14$31 million, or 4.5%9.6%, compared to $310$314 million for the three months ended SeptemberJune 30, 2016.2017. As a percentage of Net sales, Adjusted EBITDA was 8.0%8.2% for the three months ended SeptemberJune 30, 20172018 and 8.4%8.1% for the three months ended SeptemberJune 30, 2016.2017.
 Three Months Ended September 30, Three Months Ended June 30,
(in millions) 2017 Percentage of Net Sales 2016 Percentage of Net Sales 2018 Percentage of Net Sales 
2017(1)
 Percentage of Net Sales
Net income $129.2
 3.2% $125.9
 3.4% $173.0
   $140.9
  
Depreciation and amortization 65.7
   63.1
   66.3
   65.4
  
Income tax expense 77.4
   72.3
   56.8
   54.4
  
Interest expense, net 37.8
   37.6
   37.2
   35.9
  
EBITDA 310.1
 7.7% 298.9
 8.1% 333.3
 8.0% 296.6
 7.6%
                
Adjustments:                
Equity-based compensation 10.0
   10.0
   11.0
   11.5
  
Net loss on extinguishments of long-term debt 
   2.1
  
Income from equity investment(1)
 (0.2)   (0.2)  
Integration expenses(2)
 
   2.4
   
   2.0
  
Reinstatement of prior year unclaimed property balances(3)
 4.1
   
  
Other adjustments(4)
 0.3
   (2.8)  
Other adjustments(3)
 0.4
   4.4
  
Total adjustments 14.2
   11.5
   11.4
   17.9
  
Adjusted EBITDA $324.3
 8.0% $310.4
 8.4% $344.7
 8.2% $314.5
 8.1%
(1)RepresentsAmounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Comprised of expenses related to CDW UK.
(3)Includes other expenses such as payroll taxes on equity-based compensation and our share of net income from our equity investment.
(2)
Comprised of expenses related to CDW UK.
(3)Comprised ofinvestment during the reinstatement of prior year unclaimed property balances as a result of a retroactive Illinois state law change enacted in the third quarter of 2017.
(4)The three months ended SeptemberJune 30, 2016 primarily2018 and 2017. Also includes our share ofhistorical retention costs during the settlement payments received from the Dynamic Random Access Memory class action lawsuits and the favorable resolution of a local sales tax matter, partially offset by expenses related to the consolidation of office locations north of Chicago.three months ended June 30, 2017.
Consolidated net sales growth on a constant currency basis
Consolidated Net sales increased $326$294 million, or 8.8%7.6%, to $4,034$4,186 million for the three months ended SeptemberJune 30, 2017,2018, compared to $3,708$3,892 million for the three months ended SeptemberJune 30, 2016.2017. Consolidated Net sales on a constant currency basis, which excludes the impact of foreign currency translation, increased $321$275 million, or 8.7%, to $4,034 million for the three months ended September 30, 2017, compared to $3,713 million for the three months ended September 30, 2016.7.0%.
 Three Months Ended September 30, Three Months Ended June 30,
(in millions) 2017 2016 % Change 
Average Daily % Change(1)
 2018 
2017(1)
 % Change 
Average Daily % Change(2)
Consolidated Net sales, as reported $4,033.9
 $3,708.2
 8.8% 10.5% $4,186.1
 $3,891.7
 7.6% 7.6%
Foreign currency translation(2)(3)
 
 4.3
     
 19.5
    
Consolidated Net sales, on a constant currency basis $4,033.9
 $3,712.5
 8.7% 10.4% $4,186.1
 $3,911.2
 7.0% 7.0%
(1)There were 63 and 64 selling daysAmounts for 2017 have been adjusted to reflect the three months ended September 30, 2017 and 2016, respectively.adoption of Topic 606.
(2)There were 64 selling days for both the three months ended June 30, 2018 and 2017.
(3)Represents the effect of translating the prior year results of CDW CanadaUK and CDW UK's resultsCanada at the average exchange rates applicable in the current year.

3744

Table of Contents


NineSix Months Overview

The results of certain of our key business metrics are as follows:
Nine Months Ended September 30,Six Months Ended June 30,
(dollars in millions)2017 20162018 
2017(1)
Net sales$11,353.0
 $10,489.5
$7,792.5
 $7,147.6
Gross profit1,835.6
 1,749.3
1,299.5
 1,194.3
Income from operations644.6
 622.0
469.6
 401.5
Net income327.8
 321.2
300.0
 199.0
Non-GAAP net income452.7
 428.6
376.0
 284.9
Adjusted EBITDA888.2
 843.6
624.5
 564.5
Average daily sales (1)(2)
59.4
 54.6
60.9
 55.8
Net debt (2)(3)
3,332.0
 3,123.1
3,139.6
 3,217.3
Cash conversion cycle (in days) (3)(4)
19
 18
17
 16
(1)There were 191 and 192 selling daysAmounts for 2017 have been adjusted to reflect the nine months ended September 30, 2017 and 2016, respectively.adoption of Topic 606.
(2)Defined as total debt minus cashThere were 128 selling days for both the six months ended June 30, 2018 and cash equivalents; $3,430 million minus $98 million as of September 30, 2017 and $3,241 million minus $118 million as of September 30, 2016.2017.
(3)Defined as Total debt minus Cash and cash equivalents.
(4)Cash conversion cycle is defined as days of sales outstanding in Accounts receivable and certain receivables due from vendors plus days of supply in Merchandise inventory minus days of purchases outstanding in Accounts payable and Accounts payable-inventory financing, based on a rolling three-month average.

Results of Operations
NineSix Months Ended SeptemberJune 30, 20172018 Compared to NineSix Months Ended SeptemberJune 30, 20162017
Results of operations, in dollars and as a percentage of Net sales are as follows:
 Nine Months Ended September 30, Six Months Ended June 30,
 2017 2016 2018 
2017(1)
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
 
Dollars in
Millions
 
Percentage of
Net Sales
Net sales $11,353.0
 100.0 % $10,489.5
 100.0 % $7,792.5
 100.0 % $7,147.6
 100.0 %
Cost of sales 9,517.4
 83.8
 8,740.2
 83.3
 6,493.0
 83.3
 5,953.3
 83.3
Gross profit 1,835.6
 16.2
 1,749.3
 16.7
 1,299.5
 16.7
 1,194.3
 16.7
Selling and administrative expenses 1,062.9
 9.4
 1,009.0
 9.6
 744.1
 9.5
 710.9
 9.9
Advertising expense 128.1
 1.1
 118.3
 1.1
 85.8
 1.1
 81.9
 1.1
Income from operations 644.6
 5.7
 622.0
 5.9
 469.6
 6.0
 401.5
 5.6
Interest expense, net (113.4) (1.0) (112.6) (1.1) (74.9) (1.0) (75.6) (1.1)
Net loss on extinguishments of long-term debt (57.4) (0.5) (2.1) 
 
 
 (57.4) (0.8)
Other income 1.9
 
 2.3
 
Other income, net 0.8
 
 1.3
 
Income before income taxes 475.7
 4.2
 509.6
 4.9
 395.5
 5.1
 269.8
 3.8
Income tax expense (147.9) (1.3) (188.4) (1.8) (95.5) (1.2) (70.8) (1.0)
Net income $327.8
 2.9 % $321.2
 3.1 % $300.0
 3.8 % $199.0
 2.8 %

(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.

3845

Table of Contents


Net sales
Net sales by segment, in dollars and as a percentage of total Net sales, and the year-over-year dollar and percentage change in Net sales are as follows:
 Nine Months Ended September 30,     Six Months Ended June 30,    
 2017 2016     2018 
2017(1)
    
(dollars in millions) Net Sales 
Percentage
of Total Net Sales
 
Net Sales(1)
 
Percentage
of Total Net Sales
 
Dollar
Change
 
Percent
Change(2)
 Net Sales 
Percentage
of Total Net Sales
 Net Sales 
Percentage
of Total Net Sales
 
Dollar
Change
 
Percent
Change(2)
Corporate $4,705.5
 41.4% $4,372.1
 41.7% $333.4
 7.6 % $3,299.6
 42.3% $3,020.7
 42.2% $278.9
 9.2%
                        
Small Business 931.7
 8.2
 848.2
 8.1
 83.5
 9.9
 657.1
 8.4
 607.0
 8.5
 50.1
 8.3
                        
Public:                        
Government 1,537.4
 13.5
 1,334.1
 12.7
 203.3
 15.3
 912.0
 11.7
 898.1
 12.6
 13.9
 1.5
Education 1,810.7
 15.9
 1,652.4
 15.8
 158.3
 9.6
 1,109.3
 14.2
 1,098.1
 15.4
 11.2
 1.0
Healthcare 1,235.4
 10.9
 1,270.6
 12.1
 (35.2) (2.8) 844.1
 10.8
 790.3
 11.0
 53.7
 6.8
Total Public 4,583.5
 40.4
 4,257.1
 40.6
 326.4
 7.7
 2,865.4
 36.8
 2,786.5
 39.0
 78.8
 2.8
                        
Other 1,132.3
 10.0
 1,012.1
 9.6
 120.2
 11.9
 970.4
 12.5
 733.4
 10.3
 237.0
 32.3
                        
Total net sales $11,353.0
 100.0% $10,489.5
 100.0% $863.5
 8.2 % $7,792.5
 100.0% $7,147.6
 100.0% $644.8
 9.0%
(1)Effective January 1,Amounts for 2017 Small Business is now an operating and reportable segment. Its results were previously presented as a sales channel within the Corporate segment. Prior periods have been recastadjusted to conform toreflect the current period presentation.adoption of Topic 606.
(2)
There were 191 and 192128 selling days for both the ninesix months ended SeptemberJune 30, 20172018 and 2016, respectively.2017.
Total Net sales for the ninesix months ended SeptemberJune 30, 20172018 increased $864$645 million, or 8.2%9.0%, to $11,353$7,793 million, compared to $10,489$7,148 million for the ninesix months ended SeptemberJune 30, 2016. Net sales on a constant currency basis, which excludes2017. Excluding the impact of foreign currency translation, for the nine months ended September 30, 2017 increased $913 million, or 8.7%, to $11,353 million, compared to $10,440 million for the nine months ended September 30, 2016. Therefluctuations, constant currency Net sales growth was one fewer selling day in the first nine months of 2017 compared to the first nine months of 2016 and net sales on an average daily sales basis increased 8.8%8.2%. See “Non-GAAP"Non-GAAP Financial Measure Reconciliations”Reconciliations" below for additional information.information regarding constant currency Net sales growth.
For the ninesix months ended SeptemberJune 30, 2017, we saw accelerated hardware sales, including increased2018, growth was driven by ongoing focus on client device refresh within hardware and strong growth from our international operations. In addition, increased sales growth,of solutions-based hardware reflected both underlying demand as well as ongoing focus on optimization and efficiency, security and integrationthe impact of software into solutions.the reversal associated with supply chain issues experienced at the end of 2017.
Corporate segment Net sales for the ninesix months ended SeptemberJune 30, 20172018 increased $333$279 million, or 7.6%,9.2% compared to the ninesix months ended SeptemberJune 30, 2016.2017. Growth was primarily driven by customerclient device refresh, of client devices. Additionally, we saw building momentum in solution sales as we moved through the year.well as ongoing success helping customers with solutions, including data center and software.
Small Business segment Net sales for the ninesix months ended SeptemberJune 30, 20172018 increased by $84$50 million, or 9.9%8.3%, between periods. Sales growth was primarily driven by transactional products such as notebooks and mobile devices.client device refresh.
Public segment Net sales for the ninesix months ended SeptemberJune 30, 20172018 increased $326$79 million, or 7.7%2.8%, compared to the ninesix months ended SeptemberJune 30, 2016. The growth was2017. Net sales in Healthcare increased 6.8%, primarily driven by double-digit growthperformance in Government customers.desktops and video products as customers move forward on refresh projects. Net sales to Federal governmentGovernment customers reflected a focus on spending existing budgets on planned projectsgrew at 1.5% and ongoing successful alignment with strategic programs, as well as the impact of client device shipments from a 2016 order that was delayed into 2017. Strong Net salesincreased $14 million. Sales to our State and Local government customers waswere driven by the success of executing against recently added contracts. This growth was partially offset by a continued focus on public safetydecline in Federal sales primarily due to lower client device and the addition of new contracts.networking sales. Education results reflected growth from bothNet sales increased 1.0% as ongoing success addressing networking and client device needs in Higher Education was partially offset by K-12 networking performance.
Net sales in Other, which is comprised of results from our UK and K-12 customers. SalesCanadian operations, for the six months ended June 30, 2018 increased $237 million, or 32.3%, compared to our Higher Education customersthe six months ended June 30, 2017. Both operations had strong growth driven by networking and softwarein local currency as we continued to seetake share in the benefit from programs directed at select institutions by optimizing opportunities with available budgets. K-12local markets. In addition, UK growth was leddriven in part by transactional products inincreased sales from referrals for US-based customers. The impact of foreign currency exchange increased Other sales growth by approximately 900 basis points, due to the first half offavorable impact resulting from the year, with solutions products accelerating in the third quarter as schools continuedBritish pound and Canadian dollar to develop digital curriculum programs and implement collaborative learning environments. Net sales to Healthcare customers decreased 2.8% between periods reflecting customer uncertainty related to reimbursements and funding.US dollar translations.

3946

Table of Contents


Net sales in Other for the nine months ended September 30, 2017 increased $120 million, or 11.9%, compared to the nine months ended September 30, 2016. Other is comprised of results from our Canadian and UK operations. Both operations had strong double-digit growth in local currency. The impact of currency decreased Other sales growth by approximately 600 basis points, due to the impact resulting from the British pound to US dollar translation, partially offset by favorable translation of the Canadian to US dollar.
Gross profit
Gross profit increased $86$105 million, or 4.9%8.8%, to $1,836$1,300 million for the ninesix months ended SeptemberJune 30, 2017,2018, compared to $1,749$1,194 million for the ninesix months ended SeptemberJune 30, 2016.2017. As a percentage of Net sales, Gross profit decreased 50 basis pointsmargin remained flat compared to 16.2% for the nine months ended September 30, 2017, down fromprior year at 16.7% for the nine months ended September 30, 2016. Although there was an increase in. Gross profit due to higher sales volumes, we experienced a decline in our Gross profit margin. This declinemargin was primarily drivenpositively impacted by a decrease inimproved product margin due to increased hardware sales, particularlythe mix of customers. This was offset by lower partner funding margin due to year-over-year revenue growth out-pacing year-over-year increases in client devices, which generally have lower profit margins, and an ongoing competitive marketplace.
Gross profit margin may fluctuate based on various factors, including vendor incentive and inventory price protection programs, cooperative advertising funds classified as a reduction of cost of sales, product mix, net service contract revenue, commission revenue, pricing strategies, market conditions and other factors.partner funding.
Selling and administrative expenses
Selling and administrative expenses increased $54$33 million, or 5.3%4.7%, to $1,063$744 million for the ninesix months ended SeptemberJune 30, 2017,2018, compared to $1,009$711 million for the ninesix months ended SeptemberJune 30, 2016. 2017. This was driven by higher sales payroll costs, including sales commissions primarily due to higher Gross profit dollars. This was partially offset by lower equity-based compensation expense and the associated payroll taxes due to the vesting in the prior year of an equity grant made at the time of our initial public offering.
As a percentage of total Net sales, Selling and administrative expenses decreased by 2040 basis points to 9.4%9.5% during the six months ended June 30, 2018, down from 9.9% in the third quarter of 2017, down from 9.6% in the third quarter of 2016. Sales payroll costs increased $20 million, or 4.1%, between periods due to higher sales volume and consistent with Gross profit growth. Equity-based compensation expense and the associated taxes increased $9 million, or 33%, during the ninesix months ended SeptemberJune 30, 2017, compared to the prior year period, primarily due to the impact of annual equity awards granted under our Long-Term Incentive Plan and due to the vesting of an equity grant made at the time of our initial public offering and the related payroll taxes. During the nine months ended September 30, 2017, a retroactive Illinois state law change was enacted which required the reinstatement of unclaimed property balances, resulting in an additional $4 million of expenses.2017.


40

Table of Contents


Income from operations
Income from operations by segment, in dollars and as a percentage of Net sales, and the year-over-year percentage changeschange are as follows:
 Nine Months Ended September 30,   Six Months Ended June 30,  
 2017 2016   2018 
2017(1)
  
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Percent Change
in Income
from Operations
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Dollars in
Millions
 
Operating
Margin
Percentage
 
Percent Change
in Income
from Operations
Segments:(1)(2)
                    
Corporate $359.5
 7.6% $339.1
 7.8% 6.0% $266.1
 8.1% $239.0
 7.9% 11.3%
Small Business(2)
 53.7
 5.8
 52.3
 6.2
 2.7
 46.9
 7.1
 36.0
 5.9
 30.3
Public 287.4
 6.3
 287.0
 6.7
 0.2
 184.7
 6.4
 165.3
 5.9
 11.7
Other(3)
 39.8
 3.5
 27.4
 2.7
 44.8
 41.5
 4.3
 25.1
 3.4
 65.1
Headquarters(4)
 (95.8) nm*
 (83.8) nm*
 14.3
 (69.6) nm*
 (63.9) nm*
 8.9
Total income from operations $644.6
 5.7% $622.0
 5.9% 3.6% $469.6
 6.0% $401.5
 5.6% 16.9%
* Not meaningful
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Segment income from operations includes the segment’s direct operating income, allocations for Headquarters’ costs, allocations for income and expenses from logistics services, certain inventory adjustments and volume rebates and cooperative advertising from vendors.
(2)Effective January 1, 2017, Small Business is its own operating and reportable segment. The prior period has been recast to conform to the current period presentation.
(3)Includes the financial results for our other operating segments, CDW CanadaUK and CDW UK,Canada, which do not meet the reportable segment quantitative thresholds.
(4)Includes certain Headquarters’Headquarters' function costs that are not allocated to the segments.
Income from operations was $645$470 million for the ninesix months ended SeptemberJune 30, 2017,2018, an increase of $23$68 million, or 3.6%16.9%, compared to $622$402 million for the ninesix months ended SeptemberJune 30, 2016. Although2017. Income from operations increased primarily due to an increase inhigher gross profit dollars, partially offset by higher sales volume, totalpayroll expenses. Total operating margin percentage decreased 20increased 40 basis points to 5.7%6.0% for the ninesix months ended SeptemberJune 30, 2017,2018, from 5.9%5.6% for the ninesix months ended SeptemberJune 30, 2016. Operating margin percentage decreased2017. The increase was primarily due to increased hardware sales, an ongoing competitive marketplacelower equity-based compensation expense and the impactassociated payroll taxes and intangible asset amortization as a percentage of Net sales, which do not trend in line with sales movement. Also contributing to the reinstatement of prior year unclaimed property balances, partially offset by a decrease inincreased operating margin percentage were lower sales payroll costsexpenses as a percentage of Net sales.
Corporate segment Incomeincome from operations was $360$266 million for the ninesix months ended SeptemberJune 30, 2017,2018, an increase of $21$27 million, or 6.0%11.3%, compared to $339$239 million for the ninesix months ended SeptemberJune 30, 2016. Although Income2017. Corporate segment income from operations increased primarily due to an increase in sales volume,higher gross profit dollars driven by higher sales. Corporate segment operating margin percentage decreased 20 basis points to 7.6% for the nine months ended September 30, 2017, from 7.8% for the nine months ended September 30, 2016. This decrease was primarily due to increased hardware sales and an ongoing competitive marketplace and the impact of the reinstatement of prior year unclaimed property balances, partially offset by a decrease in sales payroll costs as a percentage of Net sales.
Small Business segment Income from operations was $54 million for the nine months ended September 30, 2017, an increase of $2 million, or 2.7%, compared to $52 million for the nine months ended September 30, 2016. Income from operations increased due to an increase in sales volume. Small Business segment operating margin percentage decreased 40 basis points to 5.8% for the nine months ended September 30, 2017, from 6.2% for the nine months ended September 30, 2016. This decrease was primarily due to increased hardware sales and an ongoing competitive marketplace, partially offset by a decrease in sales payroll costs as a percentage of Net sales.
Public segment Income from operations was $287 million for the nine months ended September 30, 2017 and 2016, an increase of 0.2%. Public segment operating margin percentage was 6.3% and 6.7% for the nine months ended September 30, 2017 and 2016, respectively. The 40 basis point decrease in operating margin percentage was primarily driven by increased hardware sales and an ongoing competitive marketplace, which was partially offset by a decrease in sales payroll costs as a percentage of Net sales.
Other Income from operations was $40 million for the nine months ended September 30, 2017, an increase of $13 million, or 44.8%, compared to $27 million for the nine months ended September 30, 2016. Other Income from operations increased due

4147

Table of Contents


increased 20 basis points to 8.1% for the six months ended June 30, 2018, from 7.9% for the six months ended June 30, 2017. This increase in operating margin percentage was primarily driven by the benefit of lower Selling and administrative expenses as a percentage of Net sales. This was partially offset by product margin compression due to increased hardware sales.
Small Business segment income from operations was $47 million for the six months ended June 30, 2018, an increase of $11 million, or 30.3%, compared to $36 million for the six months ended June 30, 2017. Small business segment income from operations increased primarily due to higher gross profit dollars. Small Business segment operating margin percentage increased 120 basis points to 7.1% for the six months ended June 30, 2018, from 5.9% for the six months ended June 30, 2017. This increase in operating margin percentage was primarily driven by higher product margin and the benefit of lower sales payroll expenses and intangible asset amortization expenses as a percentage of Net sales.
Public segment income from operations was $185 million for the six months ended June 30, 2018, an increase of $20 million, or 11.7%, compared to $165 million for the six months ended June 30, 2017. Public segment income from operations increased primarily due to higher Gross profit dollars driven by improved product margin. Public segment operating margin percentage increased 50 basis points to 6.4% for the six months ended June 30, 2018, from 5.9% for the six months ended June 30, 2017. This increase in operating margin percentage was primarily driven by a higher product margin and the benefit of lower sales payroll expenses as a percentage of Net sales.
Other income from operations was $42 million for the six months ended June 30, 2018, an increase of $17 million, or 65.1%, compared to $25 million for the six months ended June 30, 2017. Other income from operations increased primarily due to higher sales volumes and higher Gross profit.profit as we continue to take share in the local markets, and favorable foreign exchange. Other operating margin percentage increased 8090 basis points to 3.5%4.3% for the ninesix months ended SeptemberJune 30, 2017,2018, from 2.7%3.4% for the ninesix months ended SeptemberJune 30, 2016.2017. This increase was primarily due to higher Gross profit, amplified bylower sales payroll expenses and lower intangible asset amortization expense as a percentage of Net sales. Also contributing to the increased operating margin percentage was the non-recurrence of integration expenses in the current year.
Net loss on extinguishments of long-term debt
During the six months ended June 30, 2017, we incurred a net loss on extinguishment of long-term debt of $57 million. For information regarding our debt, see Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements. During the nine months ended September 30, 2017, we incurred a $57 million net loss on extinguishment of long-term debt, compared to the $2 million recorded in the same period of 2016, which represented the write-off of unamortized deferred financing costs and unamortized discounts related to the three loans in the below table. The loss recognized on the Senior Notes due 2022 also included the redemption premium of $37 million.
Net loss on extinguishments of long-term debt for the ninesix months ended SeptemberJune 30, 2017 and 2016 are as follows:
Month of Extinguishment Debt Instrument (in millions)Debt Instrument (in millions) 
Loss Recognized Amount Extinguished Loss Recognized 
February 2017 Senior Secured Term Loan Facility $(13.7)Senior Secured Term Loan Facility $1,483.0
 $(13.7) 
March 2017 Senior Notes due 2022 (42.5)Senior Notes due 2022 600.0
 (42.5)
(1) 
March 2017 Senior secured asset-based revolving credit facility (1.2)Senior secured asset-based revolving credit facility 
 (1.2) 
 Total Loss Recognized $(57.4)Total Loss Recognized   $(57.4) 
  
August 2016 Senior Secured Term Loan Facility $(2.1)
 Total Loss Recognized $(2.1)

(1)We repaid all of the remaining aggregate principal amount outstanding. The loss recognized represents the difference between the aggregate principal amount and the net carrying amount of the purchased debt, adjusted for the remaining unamortized deferred financing fees and premium.
Income tax expense
Income tax expense was $148$96 million for the ninesix months ended SeptemberJune 30, 2017,2018, compared to $188$71 million for the same period of the prior year. The effective income tax rate, expressed by calculating the income tax expense as a percentage of Income before income taxes, was 31.1%24.1% for the ninesix months ended SeptemberJune 30, 2017 compared2018 and differed from the US federal statutory rate of 21.0% primarily due to 37.0%state income taxes partially offset by excess tax benefits on equity-based compensation. The effective tax rate for the same period of the prior year. year was 26.2% and differed from the US federal statutory rate primarily due to excess tax benefits on equity-based compensation.

The lower effective tax rate for the ninesix months ended SeptemberJune 30, 20172018 as compared to the same period of the prior year was primarily attributable to $31 million ofthe reduction in the US federal statutory rate, partially offset by lower excess tax benefits related toon equity-based compensation recognized in 2017, which exceededand a higher effective net state income tax rate primarily due to the $1 millionreduced US federal benefit.

48

Table of tax benefits related to equity-based compensation recognized in 2016.Contents


Non-GAAP Financial Measure Reconciliations
We have included reconciliations of Non-GAAP income before income taxes, Non-GAAP net income, EBITDA, Adjusted EBITDA, Adjusted EBITDA margin and consolidated Net sales growth on a constant currency basis for the ninesix months ended SeptemberJune 30, 20172018 and 20162017 below. See the “Non-GAAP"Non-GAAP Financial Measure Reconciliations”Reconciliations" section included above for the three months ended SeptemberJune 30, 20172018 and 20162017 for all Non-GAAP measure definitions.
Non-GAAP net income
Non-GAAP net income was $453$376 million for the ninesix months ended SeptemberJune 30, 2017,2018, an increase of $24$91 million or 5.6%,32.0% compared to $429$285 million for the ninesix months ended SeptemberJune 30, 2016.2017.
  Nine Months Ended September 30,
(in millions) 2017 2016
Net income $327.8
 $321.2
Amortization of intangibles(1)
 138.9
 141.0
Equity-based compensation 33.6
 28.1
Net loss on extinguishments of long-term debt 57.4
 2.1
Integration expenses(2)
 2.5
 6.2
Reinstatement of prior year unclaimed property balances(3)
 4.1
 
Other adjustments(4)
 4.8
 (6.0)
Aggregate adjustment for income taxes(5)
 (116.4) (64.0)
Non-GAAP net income $452.7
 $428.6
  Six Months Ended June 30,
  2018 
2017(1)
(dollars in millions) Income before income taxes 
Income tax expense(2)
 Net income Income before income taxes 
Income tax expense(2)
 Net income
GAAP (as reported) $395.5
 $(95.5) $300.0
 $269.8
 $(70.8) $199.0
Amortization of intangibles(3)
 93.3
 (24.0) 69.3
 92.4
 (33.2) 59.2
Equity-based compensation 19.1
 (13.3) 5.8
 23.6
 (38.4) (14.8)
Net loss on extinguishments of long-term debt 
 
 
 57.4
 (20.6) 36.8
Integration expenses(4)
 
 
 
 2.5
 (0.9) 1.6
Other adjustments(5)
 1.2
 (0.3) 0.9
 4.9
 (1.8) 3.1
Non-GAAP $509.1
 $(133.1) $376.0
 $450.6
 $(165.7) $284.9
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Income tax on non-GAAP adjustments includes excess tax benefits associated with equity compensation. Additionally, 2018 includes the impact of GILTI on equity-based compensation and amortization of intangibles.
(3)Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.
(4)Comprised of expenses related to CDW UK.
(5)Includes other expenses such as payroll taxes on equity-based compensation during the six months ended June 30, 2018 and 2017.

4249

Table of Contents


contracts and trade names.
(2)
Comprised of expenses related to CDW UK.
(3)Comprised of the reinstatement of prior year unclaimed property balances as a result of a retroactive Illinois state law change enacted in the third quarter of 2017.
(4)Primarily includes expenses related to payroll taxes on equity-based compensation during the nine months ended September 30, 2017. The nine months ended September 30, 2016 primarily includes our share of the settlement payments received from the Dynamic Random Access Memory class action lawsuits and the favorable resolution of a local sales tax matter, partially offset by expenses related to the consolidation of office locations north of Chicago.
(5)Aggregate adjustment for income taxes consists of the following:
  Nine Months Ended September 30,
  2017 2016
Total Non-GAAP adjustments $241.3
 $171.4
Weighted-average statutory effective rate 36.0% 36.0%
Income tax (86.9) (61.7)
Excess tax benefits from equity-based compensation (30.7) (1.2)
Non-deductible adjustments and other 1.2
 (1.1)
Total aggregate adjustment for income taxes $(116.4) $(64.0)

Adjusted EBITDA
Adjusted EBITDA was $888$625 million for the ninesix months ended SeptemberJune 30, 2017,2018, an increase of $44$60 million, or 5.3%10.6%, compared to $844$565 million for the ninesix months ended SeptemberJune 30, 2016.2017. As a percentage of Net sales, Adjusted EBITDA was 7.8% for the nine months ended September 30, 2017 and 8.0% for the ninesix months ended SeptemberJune 30, 2016.2018 and 7.9% for the six months ended June 30, 2017.
 Nine Months Ended September 30, Six Months Ended June 30,
(in millions) 2017 Percentage of Net Sales 2016 Percentage of Net Sales 2018 Percentage of Net Sales 
2017(1)
 Percentage of Net Sales
Net income $327.8
 2.9% $321.2
 3.1% $300.0
   $199.0
  
Depreciation and amortization 195.2
   190.7
   132.9
   129.5
  
Income tax expense 147.9
   188.4
   95.5
   70.8
  
Interest expense, net 113.4
   112.6
   74.9
   75.6
  
EBITDA 784.3
 6.9% 812.9
 7.8% 603.3
 7.7% 474.9
 6.6%
                
Adjustments:                
Equity-based compensation 33.6
   28.1
   19.1
   23.6
  
Net loss on extinguishments of long-term debt 57.4
   2.1
   
   57.4
  
Income from equity investments(1)
 (0.4)   (0.9)  
Integration expenses(2)
 2.5
   6.2
   
   2.5
  
Reinstatement of prior year unclaimed property balances(3)
 4.1
   
  
Other adjustments(4)
 6.7
   (4.8)  
Other adjustments(3)
 2.1
   6.1
  
Total adjustments 103.9
   30.7
   21.2
   89.6
  
Adjusted EBITDA $888.2
 7.8% $843.6
 8.0% $624.5
 8.0% $564.5
 7.9%
(1)RepresentsAmounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Comprised of expenses related to CDW UK.
(3)Includes other expenses such as payroll taxes on equity-based compensation and our share of net income from our equity investments.
(2)
Comprised of expenses related to CDW UK.
(3)Comprised of the reinstatement of prior year unclaimed property balances as a result of a retroactive Illinois state law change enacted in the third quarter of 2017.

43

Table of Contents


(4)Primarily includes expenses related to payroll taxes on equity-based compensationinvestment during the ninesix months ended SeptemberJune 30, 2018 and 2017. The nineAlso includes historical retention costs during the six months ended SeptemberJune 30, 2016 primarily includes our share of the settlement payments received from the Dynamic Random Access Memory class action lawsuits and the favorable resolution of a local sales tax matter, partially offset by expenses related to the consolidation of office locations north of Chicago.2017.
Consolidated net sales growth on a constant currency basis
Consolidated Net sales increased $864$645 million, or 8.2%9.0%, to $11,353$7,793 million for the ninesix months ended SeptemberJune 30, 2017,2018, compared to $10,489$7,148 million for the ninesix months ended SeptemberJune 30, 2016.2017. Consolidated Net sales on a constant currency basis, which excludes the impact of foreign currency translation, increased $913$591 million, or 8.7%, to $11,353 million for the nine months ended September 30, 2017, compared to $10,440 million for the nine months ended September 30, 2016.8.2%.
 Nine Months Ended September 30, Six Months Ended June 30,
(in millions) 2017 2016 % Change 
Average Daily % Change(1)
 2018 
2017(1)
 % Change 
Average Daily % Change(2)
Consolidated Net sales, as reported $11,353.0
 $10,489.5
 8.2% 8.8% $7,792.5
 $7,147.6
 9.0% 9.0%
Foreign currency translation(2)(3)
 
 (49.6)     
 54.3
    
Consolidated Net sales, on a constant currency basis $11,353.0
 $10,439.9
 8.7% 9.3% $7,792.5
 $7,201.9
 8.2% 8.2%
(1)There were 191 and 192 selling daysAmounts for 2017 have been adjusted to reflect the nine months ended September 30, 2017 and 2016, respectively.adoption of Topic 606.
(2)
There were 128 selling days for both the six months ended June 30, 2018 and 2017.
(3)Represents the effect of translating the prior year results of CDW CanadaUK and CDW UK's resultsCanada at the average exchange rates applicable in the current year.

Seasonality
While we have not historically experienced significant seasonality throughout the year, sales in our Corporate segment, which primarily serves US private sector business customers with more than 250 employees, are typically higher in the fourth quarter than in other quarters due to customers spending their remaining technology budget dollars at the end of the year. Additionally, sales in our Public segment have historically been higher in the third quarter than in other quarters primarily due to the buying patterns of the federal government and education customers.

50

Table of Contents


Liquidity and Capital Resources
Overview

We finance our operations and capital expenditures with internally generated cash from operations. As of SeptemberJune 30, 2017,2018, we also have $794 million$1.1 billion of availableavailability for borrowings under our senior secured asset-based revolving credit facility and an additional £38£40 million ($5153 million at SeptemberJune 30, 2017) of available borrowings2018) under the CDW UK revolving credit facility. Our liquidity and borrowing plans are established to align with our financial and strategic planning processes and ensure we have the necessary funding to meet our operating commitments, which primarily include the purchase of inventory, payroll and general expenses. We also take into consideration our overall capital allocation strategy, which includes investment for future growth, dividend payments, acquisitions and share repurchases. We believe we have adequate sources of liquidity and funding available for at least for the next year; however, there are a number of factors that may negatively impact our available sources of funds. The amount of cash generated from operations will be dependent upon factors such as the successful execution of our business plan and general economic conditions.

Debt Refinancing Activity
For details regarding our debt and refinancing activities, refer to Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements included in Part I, Item 1 of this Form 10-Q.

Share Repurchase Program

On August 3, 2017, we announced that our Board of Directors authorized a $750 million increase to our share repurchase program under which we may repurchase shares of our common stock in the open market through privately negotiated or other transactions, depending on share price, market conditions and other factors. During the ninesix months ended SeptemberJune 30, 2017,2018, we repurchased 8.92.4 million shares of our common stock for $534$176 million under the previously announced share repurchase program. For more information on our share repurchase program, Seesee Part II, Item 2, Unregistered Sales of Equity Securities and Use of Proceeds.

44

Table of Contents



Dividends

A summary of 20172018 dividend activity for our common stock is as follows:
Dividend Amount Declaration Date Record Date Payment Date
$0.16000.21 February 7, 20172018 February 24, 201726, 2018 March 10, 201712, 2018
$0.16000.21 May 3, 20172, 2018 May 25, 20172018 June 12, 2017
$0.1600August 3, 2017August 25, 2017September 11, 20172018
    
On November 1, 2017,August 2, 2018, we announced that our Board of Directors declared a quarterly cash dividend of $0.21 per common share. The dividend will be paid on December 11, 2017September 10, 2018 to all stockholders of record as of the close of business on NovemberAugust 24, 2017.2018.
The payment of any future dividends will be at the discretion of our Board of Directors and will depend upon our results of operations, financial condition, business prospects, capital requirements, contractual restrictions, any potential indebtedness we may incur, restrictions imposed by applicable law, tax considerations and other factors that our Board of Directors deems relevant. In addition, our ability to pay dividends on our common stock will be limited by restrictions on our ability to pay dividends or make distributions to our stockholders and on the ability of our subsidiaries to pay dividends or make distributions to us, in each case, under the terms of our current and any future agreements governing our indebtedness.
Cash Flows
Cash flows from operating, investing and financing activities were as follows:
Nine Months Ended September 30,Six Months Ended June 30,
(in millions)2017 20162018 2017
Net cash provided by (used in):      
Operating activities$439.1
 $499.3
$332.3
 $376.2
Investing activities(58.6) (43.5)(33.6) (36.8)
Net change in accounts payable-inventory financing(41.4) 39.2
(110.4) (85.1)
Other financing activities(506.2) (410.1)(227.8) (441.6)
Financing activities(547.6) (370.9)(338.2) (526.7)
Effect of exchange rate changes on cash and cash equivalents1.3
 (4.2)(4.0) 2.6
Net (decrease) increase in cash and cash equivalents$(165.8) $80.7
Net decrease in cash and cash equivalents$(43.5) $(184.7)

51

Table of Contents


Operating Activities     
Nine Months Ended September 30,Six Months Ended June 30,
(in millions)2017 2016 Dollar Change2018 
2017(1)
 Dollar Change
Net income$327.8
 $321.2
 $6.6
$300.0
 $199.0
 $101.0
Adjustments for the impact of non-cash items(1)(2)
234.9
 151.0
 83.9
129.0
 173.4
 (44.4)
Net income adjusted for the impact of non-cash items(2)(3)
562.7
 472.2
 90.5
429.0
 372.4
 56.6
Changes in assets and liabilities:    
    
Accounts receivable(3)(4)
(120.4) (17.9) (102.5)(295.2) (156.0) (139.2)
Merchandise inventory(4)(5)
(90.5) (64.6) (25.9)(167.7) (52.5) (115.2)
Accounts payable-trade(6)140.2
 141.5
 (1.3)386.8
 311.8
 75.0
Other(5)(7)
(52.9) (31.9) (21.0)(20.6) (99.5) 78.9
Net cash provided by operating activities$439.1
 $499.3
 $(60.2)$332.3
 $376.2
 $(43.9)

(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Includes items such as Deferreddeferred income taxes, Depreciationdepreciation and amortization, Equity-basedequity-based compensation expense and Net loss on extinguishments of long-term debt.

(2)(3)The change is primarily due to the adjustment to Net income for the non-cash item related to the Net loss on extinguishments of long-term debt, coupled with stronger operating results driven by Net sales and Gross profit growth, and lower Income tax expense as a result of excess tax benefits related to equity compensation recognized.partially offset by higher sales payroll.

(3)The change in Accounts receivable primarily reflects the impact of increased Net sales volume to our government customers compared to the same period in 2016.


45

Table of Contents


(4)The change in Merchandise inventory wasAccounts receivable is primarily due to the increased sales volume during 2018 compared to 2017, partially offset by higher inventory balance as of September 30, 2017 as a result of the timing of inventory shipments to customers, strategic stocking positions and higher bill-and-hold orders.cash collections during 2018.

(5)The change in Merchandise inventory is primarily due to higher stocking positions and timing of shipments in 2018 compared to 2017 and lower inventory levels at the end of 2017.
(6)The change in Accounts payable-trade is primarily due to the timing of inventory purchases.
(7)The change in Other is driven by an increase inprimarily due to the timing of collections of the receivables from vendors due to the growth in business and the settlement of our Restricted Debt Unit Plan liability, partially offset by an increase in marketing accruals and an increase in deferred revenue due to higher bill-and-hold inventory orders.vendors.

In order to manage our working capital and operating cash needs, we monitor our cash conversion cycle, defined as days of sales outstanding in accounts receivable plus days of supply in inventory minus days of purchases outstanding in accounts payable, based on a rolling three-month average. Components of our cash conversion cycle are as follows:
 September 30,
(in days)2017 2016
Days of sales outstanding (“DSO”)(1)
53
 49
Days of supply in inventory (“DIO”)(2)
13
 13
Days of purchases outstanding (“DPO”)(3)
(47) (44)
Cash conversion cycle19
 18
 June 30,
(in days)2018 
2017(1)
Days of sales outstanding ("DSO")(2)
50
 49
Days of supply in inventory ("DIO")(3)
13
 12
Days of purchases outstanding ("DPO")(4)
(46) (45)
Cash conversion cycle17
 16
(1)Amounts for 2017 have been adjusted to reflect the adoption of Topic 606.
(2)Represents the rolling three-month average of the balance of Accounts receivable, net at the end of the period, divided by average daily Net sales for the same three-month period. Also incorporates components of other miscellaneous receivables.
(2)(3)Represents the rolling three-month average of the balance of Merchandise inventory at the end of the period divided by average daily costCost of sales for the same three-month period.
(3)(4)Represents the rolling three-month average of the combined balance of Accounts payable-trade, excluding cash overdrafts, and Accounts payable-inventory financing at the end of the period divided by average daily costCost of sales for the same three-month period.

The cash conversion cycle increased to 1917 days at SeptemberJune 30, 2018 compared to 16 days at June 30, 2017 as DSO, DIO and DPO each increased 1 day compared to 18 days at SeptemberJune 30, 2016.2017. The increase in DSO was primarily due to the impact of our higher sequential sales increase, change in customer mix with longer payment cycles, as well asdriven by higher Net sales and related Accounts receivable for third-party services such as software as a service software assurance and warranties. These servicessales have an unfavorable impact

52

Table of Contents


on DSO as the receivable is recognized on the Consolidated Balance Sheet on a gross basis while the corresponding sales amount in the Consolidated Statement of Operations is recorded on a net basis. These services haveThis also results in a favorable impact on DPO as the payable is recognized on the Consolidated Balance Sheet without a corresponding Cost of sales in the Statement of Operations because the cost paid to the vendor or third-party service provider is recorded as a reduction to Net sales. In addition, DPO alsoAdditionally, average inventory balances increased due to stocking positions and the mixtiming of payables with certain vendors that have longer payment terms.shipments to customers in 2018 which led to an unfavorable impact on DIO.
Investing Activities
Net cash used in investing activities increaseddecreased by $15$3 million in the ninesix months ended SeptemberJune 30, 20172018 compared to the same period of the prior year. Capital expenditures were $59$34 million and $41$37 million for the ninesix months ended SeptemberJune 30, 2018 and 2017, and 2016, respectively, andrespectively. The decrease in capital expenditures is primarily relateddue to the timing of investments for improvements to our information technology systems during both periods.systems.
Financing Activities
Net cash used in financing activities increaseddecreased by $177$189 million in the ninesix months ended SeptemberJune 30, 20172018 compared to the same period of the prior year. The increasedecrease was primarily driven by fewer share repurchases during the ninesix months ended SeptemberJune 30, 2017,2018, which resulted in an increasea $183 million decrease in cash used byin financing activities of $179 million and by changes in accounts payable-inventory financing, which resulted in an increase in cash used for financing activities of $81 million.activities. For more information on our share repurchase program, see Part II, Item 2, Unregistered Sales of Equity Securities and Use of Proceeds. The increase in cash used by Accounts payable-inventory financing was primarily driven by the termination of one of our inventory financing agreements in the fourth quarter of 2016, with amounts owed subsequently reported as Accounts payable - trade on the Consolidated Balance Sheet, which reduced cash flows reported as financing activities during the nine months ended September 30, 2017. In addition, an increase in dividends paid of $22 million, coupled with an increase in incentive compensation plan tax withholdings paid of $42 million, contributed to the increase in cash used in financing activities. These increases in cash used in financing activities were partially offset by debt transactions, which resulted in a net increase in cash inflows of $163 million. For more information regarding our debt and refinancing activities, see Note 6 (Long-Term Debt).

46

Table of Contents


Long-Term Debt and Financing Arrangements
As of SeptemberJune 30, 2017,2018, we had total indebtedness of $3,430 million,$3.2 billion, of which $1,739 million$1.5 billion was secured indebtedness. At SeptemberJune 30, 2017,2018, we were in compliance with the covenants under our various credit agreements and indentures. The amount of CDW’s restricted payment capacity under the Senior Secured Term Loan Facility was $1,056 million$1.3 billion at SeptemberJune 30, 2017. However, we are separately permitted to make restricted payments, so long as the total net leverage ratio is less than 3.25:1.00 on a pro forma basis. The total net leverage ratio was 2.88:1.00 as of September 30, 2017.2018. The amount of restricted payment capacity for the CDW UK Term Loan was $75$133 million at SeptemberJune 30, 2017.2018.
For additional details regarding our debt and refinancing activities, refer to Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements included in Part I, Item 1 of this Form 10-Q.Statements.
Inventory Financing Agreements
We have entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers under certain terms and conditions. These amounts are classified separately as Accounts payable-inventory financing on the Consolidated Balance Sheets. We do not incur any interest expense associated with these agreements as balances are paid when they are due. For further details, see Note 43 (Inventory Financing Agreements) to the accompanying Consolidated Financial Statements included in Part I, Item 1 of this Form 10-Q.Statements.
Contractual Obligations
Except as disclosed under Note 6 (Long-Term Debt) to the accompanying Consolidated Financial Statements, included in Part I, Item 1 of this Form 10-Q, there have been no material changes to our contractual obligations from those reported in Item 7 "Management's Discussion and Analysis of Financial Condition and Results of Operations"our Annual Report on Form 10-K for the year ended December 31, 2016 included in our Current Report on Form 8-K dated August 25, 2017.
Off-Balance Sheet Arrangements
We have no off-balance sheet arrangements that have or are reasonably likely to have a material current or future effect on our financial condition, changes in financial condition, revenues or expenses, results of operations, liquidity, capital expenditures or capital resources.
Commitments and Contingencies
The information set forth in Note 1211 (Commitments and Contingencies) to the accompanying Consolidated Financial Statements included in Part I, Item 1 of this Form 10-Q is incorporated herein by reference.Statements.
Critical Accounting Policies and Estimates
OurDuring the six months ended June 30, 2018, we adopted the requirements of Topic 606. See Note 1 (Description of Business and Summary of Significant Accounting Policies) to the accompanying Consolidated Financial Statements for information regarding our new revenue recognition critical accounting policies have not changed from those reported in Item 7 “Management’s Discussion and Analysispolicy.

53

Table of Financial Condition and Results of Operations” for the year ended December 31, 2016 included in our Current Report on Form 8-K dated August 25, 2017.Contents


Recent Accounting Pronouncements

The information set forth in Note 2 (Recent Accounting Pronouncements) to the accompanying Consolidated Financial Statements included in Part I, Item 1 “Financial Statements”, of this Form 10-Q is incorporated herein by reference.
Forward-Looking Statements
This report contains forward-looking statements within the meaning of the federal securities laws. All statements other than statements of historical fact included in this report are forward-looking statements. These statements relate to analysis and other information, which are based on forecasts of future results and estimates of amounts not yet determinable. These statements also relate to our future prospects, developments and business strategies. We claim the protection of The Private Securities Litigation Reform Act of 1995 for all forward-looking statements in this report.
These forward-looking statements are identified by the use of terms and phrases such as “anticipate,” “believe,” “could,” “estimate,” “expect,” “intend,” “may,” “plan,” “predict,” “project,” “will”"anticipate," "believe," "could," "estimate," "expect," "intend," "may," "plan," "predict," "project," "should," "will" and similar terms and phrases, including references to assumptions. However, these words are not the exclusive means of identifying such statements. Although we believe that our plans, intentions and expectations reflected in or suggested by such forward-looking statements are reasonable, we cannot assure you that we will achieve those plans, intentions or expectations. All forward-looking statements are subject to risks and uncertainties that may cause actual results to differ materially from those that we expected.

47

Table of Contents


Important factors that could cause actual results to differ materially from our expectations, or cautionary statements, are disclosed under the section entitled “Risk Factors”"Risk Factors" included in our Annual Report on Form 10-K for the year ended December 31, 20162017 and from time to time in our subsequent Quarterly Reports on Form 10-Q and our other SEC filings. These factors include, among others, global and regional economic and political conditions; decreases in spending on technology products;products and services; CDW's relationships with vendor partners and availability of their products; continued innovations in hardware, software and services offerings by CDW's vendor partners; substantial competition that could reduce CDW's market share; CDW's substantial indebtedness and ability to generate sufficient cash to service such indebtedness; restrictions imposed by agreements relating to CDW's indebtedness on its operations and liquidity; changes in, or the discontinuation of, CDW's share repurchase program or dividend payments; the continuing development, maintenance and operation of CDW's information technology systems; potential breaches of data security;security and failure to protect our information technology systems from cybersecurity threats; potential failures to comply with Public segment contracts or applicable laws and regulations; potential failures to provide high-quality services to CDW's customers; potential losses of any key personnel; potential interruptions of the flow of products from suppliers; potential adverse occurrences at one of CDW's primary facilities or customer data centers; CDW's dependence onincreases in the cost of commercial delivery services or disruptions of those services; CDW's exposure to accounts receivable and inventory risks; fluctuations in foreign currency; future acquisitions or alliances; fluctuations in CDW's operating results; current and future legal proceedings and audits; potential acceleration of CDW's deferred cancellation of debt income;changes in laws, including the recent US tax legislation, regulations or interpretations thereof; and other risk factors or uncertainties identified from time to time in CDW's filings with the SEC. All written and oral forward-looking statements attributable to us, or persons acting on our behalf, are expressly qualified in their entirety by the cautionary statements contained in the section entitled “Risk Factors”"Risk Factors" included in our Annual Report on Form 10-K for the year ended December 31, 20162017 and elsewhere in this report as well as other cautionary statements that are made from time to time in our other SEC filings and public communications. You should evaluate all forward-looking statements made in this report in the context of these risks and uncertainties.
We caution you that the important factors referenced above may not contain all of the factors that are important to you. In addition, we cannot assure you that we will realize the results or developments we expect or anticipate or, even if substantially realized, that they will result in the consequences or affect us or our operations in the way we expect. The forward-looking statements included in this report are made only as of the date hereof. We undertake no obligation to publicly update or revise any forward-looking statement as a result of new information, future events or otherwise, except as otherwise required by law.

54

Table of Contents


Item 3. Quantitative and Qualitative Disclosures About Market Risk
See “Management’s"Management's Discussion and Analysis of Financial Condition and Results of Operations”Operations" and “Quantitative"Quantitative and Qualitative Disclosures about Market Risk”Risk" in the Company’sCompany's Annual Report inon Form 10-K for the year ended December 31, 2016. During the nine months ended September2017. As of June 30, 2017, the Company designated the interest rate cap agreements as cash flow hedges. Refer to Note 5 (Financial Instruments) for further information on the Company's derivative-related activity during the nine months ended September 30, 2017.2018, there have been no material changes in this information.
Item 4. Controls and Procedures
Evaluation of Disclosure Controls and Procedures
The Company's management, with the participation of the Company's Chief Executive Officer and Chief Financial Officer, has evaluated the effectiveness of the Company's disclosure controls and procedures (as such term is defined in Rule 13a-15(e) or Rule 15d-15(e) under the Securities Exchange Act of 1934, as amended (the “Exchange Act”"Exchange Act")) as of the end of the period covered by this report. Based on such evaluation, the Company's management, including the Company's Chief Executive Officer and Chief Financial Officer, has concluded that, as of the end of such period, the Company's disclosure controls and procedures were effective in recording, processing, summarizing and reporting, on a timely basis, information required to be disclosed by the Company in the reports that it files or submits under the Exchange Act, and that information is accumulated and communicated to the Company's management, including the Company's Chief Executive Officer and Chief Financial Officer, as appropriate to allow timely discussions regarding required disclosure.
Changes in Internal Control over Financial Reporting
There have been no changes in the Company’sCompany's internal control over financial reporting during the three months ended SeptemberJune 30, 20172018 that have materially affected, or are reasonably likely to materially affect, the Company’sCompany's internal control over financial reporting.

4855

Table of Contents


PART II—OTHER INFORMATION
Item 1. Legal Proceedings

The information set forth in Note 1211 (Commitments and Contingencies) to the accompanying Consolidated Financial Statements included in Part I, Item 1 “Financial Statements”"Financial Statements", of this Form 10-Q is incorporated herein by reference.
Item 1A. Risk Factors
See “Risk Factors”"Risk Factors" in the Company's Annual Report on Form 10-K for the year ended December 31, 2016.2017.
Item 2. Unregistered Sales of Equity Securities and Use of Proceeds
Unregistered Sales of Equity Securities
None.
Issuer Purchases of Equity Securities
Information relating to the Company’sCompany's purchases of its common stock during the three months ended SeptemberJune 30, 20172018 is as follows:
Period Total Number of Shares Purchased (in millions) Average Price Paid per Share Total Number of Shares Purchased as Part of a Publicly Announced Program (in millions) 
Maximum Dollar Value of Shares that May Yet be Purchased Under the Program (1) (in millions)
July 1 through July 31, 2017 1.0
 $63.25
 1.0
 $223.3
August 1 through August 31, 2017 0.9
 $62.19
 0.9
 $914.8
September 1 through September 30, 2017 0.9
 $60.93
 0.9
 $858.2
Total 2.8
 

 2.8
  
Period Total Number of Shares Purchased (in millions) Average Price Paid per Share Total Number of Shares Purchased as Part of a Publicly Announced Program (in millions) 
Maximum Dollar Value of Shares that May Yet be Purchased Under the Program(1)
 (in millions)
April 1 through April 30, 2018 0.3
 $70.35
 0.3
 $730.7
May 1 through May 31, 2018 0.2
 $78.04
 0.2
 $711.4
June 1 through June 30, 2018 0.4
 $83.43
 0.4
 $681.6
Total 0.9
 

 0.9
  
(1)The amounts presented in this column are the remaining total authorized value to be spent after each month's repurchases. On August 3, 2017, the Company announced that its Board of Directors authorized a $750 million increase to the share repurchase program under which the Company may repurchase shares of its common stock in the open market through privately negotiated or other transactions, depending on share price, market conditions and other factors.
Item 3. Defaults Upon Senior Securities
None.
Item 4. Mine Safety Disclosures
Not applicable.
Item 5. Other Information
None.

4956

Table of Contents


Item 6. Exhibits 
Exhibit  Description
   
10.1*§3.1 

   
10.2*§3.1.1 

3.1.2
   
31.1*  
   
31.2*  
   
32.1**  
   
32.2**  
   
101.INS*  XBRL Instance Document.
   
101.SCH*  XBRL Taxonomy Extension Schema Document.
   
101.CAL*  XBRL Taxonomy Extension Calculation Linkbase Document.
   
101.DEF*  XBRL Taxonomy Extension Definition Linkbase Document.
   
101.LAB*  XBRL Taxonomy Extension Label Linkbase Document.
   
101.PRE*  XBRL Taxonomy Extension Presentation Linkbase Document.
________________
*Filed herewith
**These items are furnished and not filed.
§A management contract or compensatory arrangement required to be filed as an exhibit pursuant to Item 601 of Regulation S-K


5057

Table of Contents


SIGNATURES
Pursuant to the requirements of the Securities Exchange Act of 1934, the registrant has duly caused this report to be signed on its behalf by the undersigned thereunto duly authorized. 
      
   CDW CORPORATION
      
Date:November 1, 2017August 2, 2018 By: /s/ Ann E. ZieglerCollin B. Kebo
     Ann E. ZieglerCollin B. Kebo
     Senior Vice President and Chief Financial Officer
     (Duly authorized officer and principal financial officer)


5158