# CDW Corp: Form 10-Q for the period ended Sep 30, 2017

- Company: [CDW Corp](/companies/cdw.md) (CIK 1402057)
- Form: 10-Q
- Filed: 2017-11-02
- Accepted by EDGAR: Nov 1, 2017, 21:44 ET
- Period: 2017-09-30
- Accession: 0001402057-17-000166
- Inline XBRL: yes
- Main document: https://www.sec.gov/Archives/edgar/data/1402057/000140205717000166/cdw-2017930x10q.htm
- All documents and exhibits: https://www.sec.gov/Archives/edgar/data/1402057/000140205717000166/

## Figures reported in this filing

Standardized XBRL line items for the period ended 2017-09-30.

| Line item | Period | Value | XBRL concept |
| --- | --- | ---: | --- |
| Cost of revenue | 3 months, 2017-07-01 to 2017-09-30 | $3.39bn | us-gaap:CostOfGoodsAndServicesSold |
| Cost of revenue | 9 months, 2017-01-01 to 2017-09-30 | $9.52bn | us-gaap:CostOfGoodsAndServicesSold |
| Gross profit | 3 months, 2017-07-01 to 2017-09-30 | $642.0m | us-gaap:GrossProfit |
| Gross profit | 9 months, 2017-01-01 to 2017-09-30 | $1.84bn | us-gaap:GrossProfit |
| Selling, general and administrative | 3 months, 2017-07-01 to 2017-09-30 | $352.0m | us-gaap:SellingGeneralAndAdministrativeExpense |
| Selling, general and administrative | 9 months, 2017-01-01 to 2017-09-30 | $1.06bn | us-gaap:SellingGeneralAndAdministrativeExpense |
| Operating income | 3 months, 2017-07-01 to 2017-09-30 | $243.7m | us-gaap:OperatingIncomeLoss |
| Operating income | 9 months, 2017-01-01 to 2017-09-30 | $644.6m | us-gaap:OperatingIncomeLoss |
| Income tax | 3 months, 2017-07-01 to 2017-09-30 | $77.4m | us-gaap:IncomeTaxExpenseBenefit |
| Income tax | 9 months, 2017-01-01 to 2017-09-30 | $147.9m | us-gaap:IncomeTaxExpenseBenefit |
| Net income | 3 months, 2017-07-01 to 2017-09-30 | $129.2m | us-gaap:NetIncomeLoss |
| Net income | 9 months, 2017-01-01 to 2017-09-30 | $327.8m | us-gaap:NetIncomeLoss |
| Diluted EPS | 3 months, 2017-07-01 to 2017-09-30 | $0.83 | us-gaap:EarningsPerShareDiluted |
| Diluted EPS | 9 months, 2017-01-01 to 2017-09-30 | $2.06 | us-gaap:EarningsPerShareDiluted |
| Basic EPS | 3 months, 2017-07-01 to 2017-09-30 | $0.84 | us-gaap:EarningsPerShareBasic |
| Basic EPS | 9 months, 2017-01-01 to 2017-09-30 | $2.10 | us-gaap:EarningsPerShareBasic |
| Diluted shares (weighted) | 3 months, 2017-07-01 to 2017-09-30 | 156,200,000 shares | us-gaap:WeightedAverageNumberOfDilutedSharesOutstanding |
| Diluted shares (weighted) | 9 months, 2017-01-01 to 2017-09-30 | 159,200,000 shares | us-gaap:WeightedAverageNumberOfDilutedSharesOutstanding |
| Operating cash flow | 9 months, 2017-01-01 to 2017-09-30 | $439.1m | us-gaap:NetCashProvidedByUsedInOperatingActivities |
| Capital expenditure | 9 months, 2017-01-01 to 2017-09-30 | $58.6m | us-gaap:PaymentsToAcquirePropertyPlantAndEquipment |
| Dividends paid | 9 months, 2017-01-01 to 2017-09-30 | $74.7m | us-gaap:PaymentsOfDividendsCommonStock |
| Share repurchases | 9 months, 2017-01-01 to 2017-09-30 | $534.0m | us-gaap:PaymentsForRepurchaseOfCommonStock |
| Cash and equivalents | at 2017-09-30 | $97.9m | us-gaap:CashAndCashEquivalentsAtCarryingValue |
| Current assets | at 2017-09-30 | $3.49bn | us-gaap:AssetsCurrent |
| Total assets | at 2017-09-30 | $7.10bn | us-gaap:Assets |
| Current liabilities | at 2017-09-30 | $2.56bn | us-gaap:LiabilitiesCurrent |
| Long-term debt | at 2017-09-30 | $3.39bn | us-gaap:LongTermDebtNoncurrent |
| Current portion of debt | at 2017-09-30 | $41.5m | us-gaap:LongTermDebtCurrent |
| Shareholders' equity | at 2017-09-30 | $806.5m | us-gaap:StockholdersEquity |

## Management's discussion and analysis

As filed, 72,657 characters.

*Unless otherwise indicated or the context otherwise requires, as used in this “Management’s Discussion and Analysis of Financial Condition and Results of Operations,” the terms “we,” “us,” “the Company,” “our,” “CDW” and similar terms refer to CDW Corporation and its subsidiaries. “Management’s Discussion and Analysis of Financial Condition and Results of 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 Current Report on Form 8-K dated August 25, 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” at the end of this discussion.*

### Overview

CDW Corporation (“Parent”) is a Fortune 500 company with multi-national capabilities and a leading provider of integrated information technology (“IT”) solutions to small, medium and large business, government, education and healthcare customers in the United States, Canada and the United Kingdom. Our offerings range 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,” with a product portfolio including more than 100,000 products 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 solutions through over 5,500 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”), software publishers and cloud providers (collectively, our “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 private sector business customers with more than 250 employees. Our Small Business segment primarily serves 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 Canada and CDW UK, each of which do not meet the reportable segment quantitative thresholds and, accordingly, are included in an all other category (“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.

### Trends and key factors affecting our financial performance

We believe the following trends may have an important impact on our financial performance:

- 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 perceptions of business conditions.
- 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 purchase behaviors and we are seeing continuing evolution in the market. Innovation influences customer purchases across all of our customer end-markets. Key trends in technology include increasing adoption of cloud-based solutions for certain key workloads, including backup and recovery, collaboration and security, as well as adoption of hyper-converged appliances to deliver greater flexibility and efficiency. In addition, hybrid IT solutions are being adopted, along with software being embedded into solutions.

### 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 net income, Net income per common share, Non-GAAP net income per diluted share, EBITDA and Adjusted EBITDA, free cash flow, return on invested 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 net income, EBITDA and Adjusted EBITDA, and consolidated Net sales growth on a constant currency basis, 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”) 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’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 net income, Adjusted EBITDA, and consolidated Net sales growth on a constant currency basis and reconciliations to Net income, see “Results of Operations”.

The results of certain of our key business metrics are as follows:

*(dollars in millions)*

|  | Three Months Ended September 30, 2017 | 2016 |
| --- | ---: | ---: |
| Net sales | $4,033.9 | $3,708.2 |
| Gross profit | 642.0 | 614.3 |
| Income from operations | 243.7 | 237.5 |
| Net income | 129.2 | 125.9 |
| Non-GAAP net income | 168.2 | 160.3 |
| Adjusted EBITDA | 324.3 | 310.4 |
| Average daily sales (1) | 64.0 | 57.9 |
| Net debt (2) | 3,332.0 | 3,123.1 |
| Cash conversion cycle (in days) (3) | 19 | 18 |

(1) There were 63 and 64 selling days for the three months ended September 30, 2017 and 2016, respectively.

(2) Defined as total debt minus cash 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.

(3) Cash conversion cycle is defined as days of sales outstanding in Accounts receivable and certain receivables due from vendors plus days of supply in inventory minus days of purchases outstanding in Accounts payable and Accounts payable-inventory financing, based on a rolling three-month average.

### Results of Operations

### Three Months Ended September 30, 2017 Compared to Three Months Ended September 30, 2016

Results of operations, in dollars and as a percentage of Net sales are as follows:

*Dollars in Millions*

*Dollars in Millions*

|  | Three Months Ended September 30, 2017 | Percentage of Net Sales | 2016 | Percentage of Net Sales |
| --- | ---: | ---: | ---: | ---: |
| Net sales | $4,033.9 | 100.0% | $3,708.2 | 100.0% |
| Cost of sales | 3,391.9 | 84.1 | 3,093.9 | 83.4 |
| Gross profit | 642.0 | 15.9 | 614.3 | 16.6 |
| Selling and administrative expenses | 352.0 | 8.7 | 334.9 | 9.0 |
| Advertising expense | 46.3 | 1.1 | 41.9 | 1.1 |
| Income from operations | 243.7 | 6.0 | 237.5 | 6.4 |
| Interest expense, net | (37.8) | (0.9) | (37.6) | (1.0) |
| Net loss on extinguishments of long-term debt | — | — | (2.1) | (0.1) |
| Other income | 0.7 | — | 0.4 | — |
| Income before income taxes | 206.6 | 5.1 | 198.2 | 5.3 |
| Income tax expense | (77.4) | (1.9) | (72.3) | (1.9) |
| Net income | $129.2 | 3.2% | $125.9 | 3.4% |

31

#### 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:

*(dollars in millions)*

|  | Three Months Ended September 30, 2017 Net Sales | Percentage of Total Net Sales | 2016 Net Sales(1) | 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% |
| Small Business | 311.5 | 7.7 | 282.5 | 7.6 | 29.0 | 10.3 |
| Public: |  |  |  |  |  |  |
| Government | 606.7 | 15.0 | 537.5 | 14.5 | 69.2 | 12.9 |
| Education | 700.7 | 17.4 | 671.4 | 18.1 | 29.3 | 4.4 |
| Healthcare | 425.5 | 10.6 | 431.7 | 11.6 | (6.2) | (1.4) |
| Total Public | 1,732.9 | 43.0 | 1,640.6 | 44.2 | 92.3 | 5.6 |
| Other | 391.0 | 9.7 | 318.7 | 8.6 | 72.3 | 22.6 |
| Total net sales | $4,033.9 | 100.0% | $3,708.2 | 100.0% | $325.7 | 8.8% |

(1) Effective January 1, 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 recast to conform to the current period presentation.

(2) There were 63 and 64 selling days for the three months ended September 30, 2017 and 2016, respectively.

Total Net sales for the three months ended September 30, 2017 increased $326 million, or 8.8%, to $4,034 million, compared to $3,708 million for the three months ended September 30, 2016. Net sales on a constant currency basis, which excludes the impact of 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. There 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%. See “Non-GAAP Financial Measure Reconciliations” below for additional information.

For the three months ended September 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 and ongoing focus on optimization and efficiency, security and integration of software into solutions. These trends drove significant growth in both transactions and solutions, driven by growth in client devices, netcomm equipment, enterprise storage and video.

Corporate segment Net sales for the three months ended September 30, 2017 increased $132 million, or 9.0%, compared to the three months ended September 30, 2016. Momentum experienced in the first half of 2017 continued to build during the current quarter with more projects moving from the back-burner to the front. Corporate saw increases in transactional items, such as notebooks and mobile devices, and solutions, such as netcomm equipment and enterprise storage.

Small Business segment Net sales for the three months ended September 30, 2017 increased by $29 million, or 10.3%, between periods, as customer confidence remained strong. Sales growth was primarily in transactional products, led by notebooks and mobile devices.

Public segment Net sales for the three months ended September 30, 2017 increased $92 million, or 5.6%, compared to the three months ended September 30, 2016, with strong growth in transactional sales. The growth was fueled by a 12.9% increase in Government customers. Strong Net sales to our State and Local government customers was driven by a continued focus on public safety and new contracts. Net 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 2016 client device order delayed into 2017. Education results reflected growth from both Higher Education and K-12 customers. Sales to our Higher Education customers grew double-digits, driven by client devices and collaboration as institutions continue to enhance their technology offerings to meet the needs of students. K-12 growth was led by solutions based 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 million, or 4.5%, to $642 million for the three months ended September 30, 2017, compared to $614 million for the three months ended September 30, 2016. As a percentage of Net sales, Gross profit decreased 70 basis points to 15.9% for the three months ended September 30, 2017, down from 16.6% for the three 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 decline was primarily driven by a 60 basis point decline in 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.

#### Selling and administrative expenses

Selling and administrative expenses increased $17 million, or 5.1%, to $352 million for the three months ended September 30, 2017, compared to $335 million for the three months ended September 30, 2016. As a percentage of total Net sales, Selling and administrative expenses decreased by 30 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. During the three months ended September 30, 2017, a retroactive Illinois state law change was enacted which required the reinstatement of prior year unclaimed property balances, resulting in an additional $4 million of expenses.

#### 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:

*Dollars in Millions*

*Dollars in Millions*

| Segments:(1) | Three Months Ended September 30, 2017 | Operating Margin Percentage | 2016 | Operating Margin Percentage | Percent Change in Income from Operations |
| --- | ---: | ---: | ---: | ---: | ---: |
| Corporate | $121.0 | 7.6% | $120.0 | 8.2% | 0.9% |
| Small Business(2) | 17.7 | 5.7 | 18.0 | 6.4 | (1.4) |
| Public | 122.3 | 7.1 | 120.0 | 7.3 | 1.9 |
| Other(3) | 14.5 | 3.7 | 10.0 | 3.1 | 45.9 |
| Headquarters(4) | (31.8) | nm\* | (30.5) | nm\* | 4.4 |
| Total income from operations | $243.7 | 6.0% | $237.5 | 6.4% | 2.6% |

\* Not meaningful

(1) 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 Canada and CDW UK, which do not meet the reportable segment quantitative thresholds.

(4) Includes certain Headquarters’ function costs that are not allocated to the segments.

Income from operations was $244 million for the three months ended September 30, 2017, an increase of $6 million, or 2.6%, compared to $238 million for the three months ended September 30, 2016. Income from operations increased primarily due to higher gross profit dollars, partially offset by higher Selling and administrative expenses. Total operating margin percentage decreased 40 basis points to 6.0% for the three months ended September 30, 2017, from 6.4% for the three months ended September 30, 2016. Operating margin percentage was impacted by a decline in product margin due to increased hardware sales, particularly in client devices, which generally have lower profit margins, 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.

Corporate segment income from operations was $121 million for the three months ended September 30, 2017, an increase of $1 million, or 0.9%, compared to $120 million for the three months ended September 30, 2016. Corporate segment operating margin percentage decreased 60 basis points to 7.6% for the three months ended September 30, 2017, from 8.2% for the three months ended September 30, 2016. This decrease was primarily due to a decline in product margin due to increased hardware sales, particularly in client devices, which generally have lower profit margins, 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 $18 million for both the three months ended September 30, 2017 and 2016, a decrease of 1.4%. Small Business segment operating margin percentage decreased 70 basis points to 5.7% for the three months ended September 30, 2017, from 6.4% for the three months ended September 30, 2016. This decrease was primarily due to a decline in product margin due to increased hardware sales, particularly in client devices, which generally have lower profit margins, 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 $122 million for the three months ended September 30, 2017, an increase of $2 million, or 1.9%, compared to $120 million for the three months ended September 30, 2016. Public segment operating margin percentage decreased 20 basis points to 7.1% for the three months ended September 30, 2017, from 7.3% for the three months ended September 30, 2016. The decrease in operating margin percentage was primarily driven by increased hardware sales, 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.

Other income from operations was $15 million for the three months ended September 30, 2017, an increase of $5 million, or 45.9%, compared to $10 million for the three months ended September 30, 2016. Other operating margin percentage increased 60 basis points to 3.7% for the three months ended September 30, 2017, from 3.1% for the three months ended September 30, 2016. Operating margin improvement was primarily driven by lower intangible 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 to the same period in 2016 when we incurred a net loss on extinguishment of long-term debt of $2 million.

#### Income tax expense

Income tax expense was $77 million for the three months ended September 30, 2017, compared to $72 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% for the three months ended September 30, 2017 compared to 36.5% for the same period of the prior year. The higher effective tax rate for the three months ended September 30, 2017 as compared to the same period of the prior year was primarily attributable to differences in discrete items recorded 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 largely offset by the tax benefit of $1 million related to equity-based compensation and a state tax refund, while we recognized $1 million of tax benefits for the same period of the prior year as a result of tax benefits related to equity-based compensation.

#### Non-GAAP Financial Measure Reconciliations

We have included reconciliations of Non-GAAP net income, EBITDA, Adjusted EBITDA and consolidated Net sales growth on a constant currency basis for the three months ended September 30, 2017 and 2016 below.

Non-GAAP net income excludes, 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. EBITDA is defined as consolidated net income before interest expense, 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. 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 net income, EBITDA, Adjusted EBITDA 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’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.

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.

#### Non-GAAP net income

Non-GAAP net income was $168 million for the three months ended September 30, 2017, an increase of $8 million, or 4.9%, compared to $160 million for the three months ended September 30, 2016.

*(in millions)*

|  | Three Months Ended September 30, 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 |

(1) 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 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:

|  | 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) |

36

#### Adjusted EBITDA

Adjusted EBITDA was $324 million for the three months ended September 30, 2017, an increase of $14 million, or 4.5%, compared to $310 million for the three months ended September 30, 2016. As a percentage of Net sales, Adjusted EBITDA was 8.0% for the three months ended September 30, 2017 and 8.4% for the three months ended September 30, 2016.

*(in millions)*

|  | Three Months Ended September 30, 2017 | Percentage of Net Sales | 2016 | Percentage of Net Sales |
| --- | ---: | ---: | ---: | ---: |
| Net income | $129.2 | 3.2% | $125.9 | 3.4% |
| Depreciation and amortization | 65.7 |  | 63.1 |  |
| Income tax expense | 77.4 |  | 72.3 |  |
| Interest expense, net | 37.8 |  | 37.6 |  |
| EBITDA | 310.1 | 7.7% | 298.9 | 8.1% |
| Adjustments: |  |  |  |  |
| Equity-based compensation | 10.0 |  | 10.0 |  |
| Net loss on extinguishments of long-term debt | — |  | 2.1 |  |
| Income from equity investment(1) | (0.2) |  | (0.2) |  |
| Integration expenses(2) | — |  | 2.4 |  |
| Reinstatement of prior year unclaimed property balances(3) | 4.1 |  | — |  |
| Other adjustments(4) | 0.3 |  | (2.8) |  |
| Total adjustments | 14.2 |  | 11.5 |  |
| Adjusted EBITDA | $324.3 | 8.0% | $310.4 | 8.4% |

(1) Represents our share of net income from our equity investment.

(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 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.

#### Consolidated net sales growth on a constant currency basis

Consolidated Net sales increased $326 million, or 8.8%, to $4,034 million for the three months ended September 30, 2017, compared to $3,708 million for the three months ended September 30, 2016. Consolidated Net sales on a constant currency basis, which excludes the impact of foreign currency translation, increased $321 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.

*(in millions)*

|  | Three Months Ended September 30, 2017 | 2016 | % Change | Average Daily % Change(1) |
| --- | ---: | ---: | ---: | ---: |
| Consolidated Net sales, as reported | $4,033.9 | $3,708.2 | 8.8% | 10.5% |
| Foreign currency translation(2) | — | 4.3 |  |  |
| Consolidated Net sales, on a constant currency basis | $4,033.9 | $3,712.5 | 8.7% | 10.4% |

(1) There were 63 and 64 selling days for the three months ended September 30, 2017 and 2016, respectively.

(2) Represents the effect of translating the prior year results of CDW Canada and CDW UK's results at the average exchange rates applicable in the current year.

### Nine Months Overview

The results of certain of our key business metrics are as follows:

*(dollars in millions)*

|  | Nine Months Ended September 30, 2017 | 2016 |
| --- | ---: | ---: |
| Net sales | $11,353.0 | $10,489.5 |
| Gross profit | 1,835.6 | 1,749.3 |
| Income from operations | 644.6 | 622.0 |
| Net income | 327.8 | 321.2 |
| Non-GAAP net income | 452.7 | 428.6 |
| Adjusted EBITDA | 888.2 | 843.6 |
| Average daily sales (1) | 59.4 | 54.6 |
| Net debt (2) | 3,332.0 | 3,123.1 |
| Cash conversion cycle (in days) (3) | 19 | 18 |

(1) There were 191 and 192 selling days for the nine months ended September 30, 2017 and 2016, respectively.

(2) Defined as total debt minus cash 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.

(3) Cash conversion cycle is defined as days of sales outstanding in Accounts receivable and certain receivables due from vendors plus days of supply in inventory minus days of purchases outstanding in Accounts payable and Accounts payable-inventory financing, based on a rolling three-month average.

### Results of Operations

### Nine Months Ended September 30, 2017 Compared to Nine Months Ended September 30, 2016

Results of operations, in dollars and as a percentage of Net sales are as follows:

*Dollars in Millions*

*Dollars in Millions*

|  | Nine Months Ended September 30, 2017 | Percentage of Net Sales | 2016 | Percentage of Net Sales |
| --- | ---: | ---: | ---: | ---: |
| Net sales | $11,353.0 | 100.0% | $10,489.5 | 100.0% |
| Cost of sales | 9,517.4 | 83.8 | 8,740.2 | 83.3 |
| Gross profit | 1,835.6 | 16.2 | 1,749.3 | 16.7 |
| Selling and administrative expenses | 1,062.9 | 9.4 | 1,009.0 | 9.6 |
| Advertising expense | 128.1 | 1.1 | 118.3 | 1.1 |
| Income from operations | 644.6 | 5.7 | 622.0 | 5.9 |
| Interest expense, net | (113.4) | (1.0) | (112.6) | (1.1) |
| Net loss on extinguishments of long-term debt | (57.4) | (0.5) | (2.1) | — |
| Other income | 1.9 | — | 2.3 | — |
| Income before income taxes | 475.7 | 4.2 | 509.6 | 4.9 |
| Income tax expense | (147.9) | (1.3) | (188.4) | (1.8) |
| Net income | $327.8 | 2.9% | $321.2 | 3.1% |

38

#### 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:

*(dollars in millions)*

|  | Nine Months Ended September 30, 2017 Net Sales | Percentage of Total Net Sales | 2016 Net Sales(1) | 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% |
| Small Business | 931.7 | 8.2 | 848.2 | 8.1 | 83.5 | 9.9 |
| Public: |  |  |  |  |  |  |
| Government | 1,537.4 | 13.5 | 1,334.1 | 12.7 | 203.3 | 15.3 |
| Education | 1,810.7 | 15.9 | 1,652.4 | 15.8 | 158.3 | 9.6 |
| Healthcare | 1,235.4 | 10.9 | 1,270.6 | 12.1 | (35.2) | (2.8) |
| Total Public | 4,583.5 | 40.4 | 4,257.1 | 40.6 | 326.4 | 7.7 |
| Other | 1,132.3 | 10.0 | 1,012.1 | 9.6 | 120.2 | 11.9 |
| Total net sales | $11,353.0 | 100.0% | $10,489.5 | 100.0% | $863.5 | 8.2% |

(1) Effective January 1, 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 recast to conform to the current period presentation.

(2) There were 191 and 192 selling days for the nine months ended September 30, 2017 and 2016, respectively.

Total Net sales for the nine months ended September 30, 2017 increased $864 million, or 8.2%, to $11,353 million, compared to $10,489 million for the nine months ended September 30, 2016. Net sales on a constant currency basis, which excludes the impact of 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. There 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%. See “Non-GAAP Financial Measure Reconciliations” below for additional information.

For the nine months ended September 30, 2017, we saw accelerated hardware sales, including increased client device sales growth, as well as ongoing focus on optimization and efficiency, security and integration of software into solutions.

Corporate segment Net sales for the nine months ended September 30, 2017 increased $333 million, or 7.6%, compared to the nine months ended September 30, 2016. Growth was primarily driven by customer refresh of client devices. Additionally, we saw building momentum in solution sales as we moved through the year.

Small Business segment Net sales for the nine months ended September 30, 2017 increased by $84 million, or 9.9%, between periods. Sales growth was primarily driven by transactional products such as notebooks and mobile devices.

Public segment Net sales for the nine months ended September 30, 2017 increased $326 million, or 7.7%, compared to the nine months ended September 30, 2016. The growth was driven by double-digit growth in Government customers. Net sales to Federal government customers reflected a focus on spending existing budgets on planned projects 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 sales to our State and Local government customers was driven by a continued focus on public safety and the addition of new contracts. Education results reflected growth from both Higher Education and K-12 customers. Sales to our Higher Education customers had strong growth driven by networking and software as we continued to see the benefit from programs directed at select institutions by optimizing opportunities with available budgets. K-12 growth was led by transactional products in the first half of the year, with solutions products accelerating in the third quarter as schools continued 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.

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 million, or 4.9%, to $1,836 million for the nine months ended September 30, 2017, compared to $1,749 million for the nine months ended September 30, 2016. As a percentage of Net sales, Gross profit decreased 50 basis points to 16.2% for the nine months ended September 30, 2017, down from 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 decline was primarily driven by a decrease in 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.

#### Selling and administrative expenses

Selling and administrative expenses increased $54 million, or 5.3%, to $1,063 million for the nine months ended September 30, 2017, compared to $1,009 million for the nine months ended September 30, 2016. As a percentage of total Net sales, Selling and administrative expenses decreased by 20 basis points to 9.4% 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 nine months ended September 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.

#### Income from operations

Income from operations by segment, in dollars and as a percentage of Net sales, and the year-over-year percentage changes are as follows:

*Dollars in Millions*

*Dollars in Millions*

| Segments:(1) | Nine Months Ended September 30, 2017 | Operating Margin Percentage | 2016 | Operating Margin Percentage | Percent Change in Income from Operations |
| --- | ---: | ---: | ---: | ---: | ---: |
| Corporate | $359.5 | 7.6% | $339.1 | 7.8% | 6.0% |
| Small Business(2) | 53.7 | 5.8 | 52.3 | 6.2 | 2.7 |
| Public | 287.4 | 6.3 | 287.0 | 6.7 | 0.2 |
| Other(3) | 39.8 | 3.5 | 27.4 | 2.7 | 44.8 |
| Headquarters(4) | (95.8) | nm\* | (83.8) | nm\* | 14.3 |
| Total income from operations | $644.6 | 5.7% | $622.0 | 5.9% | 3.6% |

\* Not meaningful

(1) 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 Canada and CDW UK, which do not meet the reportable segment quantitative thresholds.

(4) Includes certain Headquarters’ function costs that are not allocated to the segments.

Income from operations was $645 million for the nine months ended September 30, 2017, an increase of $23 million, or 3.6%, compared to $622 million for the nine months ended September 30, 2016. Although Income from operations increased, primarily due to an increase in sales volume, total operating margin percentage decreased 20 basis points to 5.7% for the nine months ended September 30, 2017, from 5.9% for the nine months ended September 30, 2016. Operating margin percentage decreased primarily due to increased hardware sales, 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.

Corporate segment Income from operations was $360 million for the nine months ended September 30, 2017, an increase of $21 million, or 6.0%, compared to $339 million for the nine months ended September 30, 2016. Although Income from operations increased, primarily due to an increase in sales volume, 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 to higher sales volumes and higher Gross profit. Other operating margin percentage increased 80 basis points to 3.5% for the nine months ended September 30, 2017, from 2.7% for the nine months ended September 30, 2016. This increase was primarily due to higher Gross profit, amplified by lower intangible amortization expense as a percentage of Net sales.

#### Net loss on extinguishments of long-term debt

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 nine months ended September 30, 2017 and 2016 are as follows:

*(in millions)*

| Month of Extinguishment | Debt Instrument Loss Recognized |  |
| --- | --- | ---: |
| February 2017 | Senior Secured Term Loan Facility | $(13.7) |
| March 2017 | Senior Notes due 2022 | (42.5) |
| March 2017 | Senior secured asset-based revolving credit facility | (1.2) |
|  | Total Loss Recognized | $(57.4) |
| August 2016 | Senior Secured Term Loan Facility | $(2.1) |
|  | Total Loss Recognized | $(2.1) |

#### Income tax expense

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, expressed 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 compared to 37.0% for the same period of the prior year. The lower effective tax rate for the nine months ended September 30, 2017 as compared to the same period of the prior year was primarily attributable to $31 million of excess tax benefits related to equity-based compensation recognized in 2017, which exceeded the $1 million of tax benefits related to equity-based compensation recognized in 2016.

#### Non-GAAP Financial Measure Reconciliations

We have included reconciliations of Non-GAAP net income, EBITDA, Adjusted EBITDA and consolidated Net sales growth on a constant currency basis for the nine months ended September 30, 2017 and 2016 below. See the “Non-GAAP Financial Measure Reconciliations” section included above for the three months ended September 30, 2017 and 2016 for all Non-GAAP measure definitions.

#### Non-GAAP net income

Non-GAAP net income was $453 million for the nine months ended September 30, 2017, an increase of $24 million, or 5.6%, compared to $429 million for the nine months ended September 30, 2016.

*(in millions)*

|  | Nine Months Ended September 30, 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 |

(1) 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) 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 million for the nine months ended September 30, 2017, an increase of $44 million, or 5.3%, compared to $844 million for the nine months ended September 30, 2016. As a percentage of Net sales, Adjusted EBITDA was 7.8% for the nine months ended September 30, 2017 and 8.0% for the nine months ended September 30, 2016.

*(in millions)*

|  | Nine Months Ended September 30, 2017 | Percentage of Net Sales | 2016 | Percentage of Net Sales |
| --- | ---: | ---: | ---: | ---: |
| Net income | $327.8 | 2.9% | $321.2 | 3.1% |
| Depreciation and amortization | 195.2 |  | 190.7 |  |
| Income tax expense | 147.9 |  | 188.4 |  |
| Interest expense, net | 113.4 |  | 112.6 |  |
| EBITDA | 784.3 | 6.9% | 812.9 | 7.8% |
| Adjustments: |  |  |  |  |
| Equity-based compensation | 33.6 |  | 28.1 |  |
| Net loss on extinguishments of long-term debt | 57.4 |  | 2.1 |  |
| Income from equity investments(1) | (0.4) |  | (0.9) |  |
| Integration expenses(2) | 2.5 |  | 6.2 |  |
| Reinstatement of prior year unclaimed property balances(3) | 4.1 |  | — |  |
| Other adjustments(4) | 6.7 |  | (4.8) |  |
| Total adjustments | 103.9 |  | 30.7 |  |
| Adjusted EBITDA | $888.2 | 7.8% | $843.6 | 8.0% |

(1) Represents 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.

(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.

#### Consolidated net sales growth on a constant currency basis

Consolidated Net sales increased $864 million, or 8.2%, to $11,353 million for the nine months ended September 30, 2017, compared to $10,489 million for the nine months ended September 30, 2016. Consolidated Net sales on a constant currency basis, which excludes the impact of foreign currency translation, increased $913 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.

*(in millions)*

|  | Nine Months Ended September 30, 2017 | 2016 | % Change | Average Daily % Change(1) |
| --- | ---: | ---: | ---: | ---: |
| Consolidated Net sales, as reported | $11,353.0 | $10,489.5 | 8.2% | 8.8% |
| Foreign currency translation(2) | — | (49.6) |  |  |
| Consolidated Net sales, on a constant currency basis | $11,353.0 | $10,439.9 | 8.7% | 9.3% |

(1) There were 191 and 192 selling days for the nine months ended September 30, 2017 and 2016, respectively.

(2) Represents the effect of translating the prior year results of CDW Canada and CDW UK's results 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 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.

### Liquidity and Capital Resources

### Overview

We finance our operations and capital expenditures with internally generated cash from operations. As of September 30, 2017, we also have $794 million of available borrowings under our senior secured asset-based revolving credit facility and an additional £38 million ($51 million at September 30, 2017) of available borrowings 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 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 nine months ended September 30, 2017, we repurchased 8.9 million shares of our common stock for $534 million under the share repurchase program. For more information on our share repurchase program, See Part II, Item 2, Unregistered Sales of Equity Securities and Use of Proceeds.

#### Dividends

A summary of 2017 dividend activity for our common stock is as follows:

|  |  |  |  |
| ---: | --- | --- | --- |
| Dividend Amount | Declaration Date | Record Date | Payment Date |
| $0.1600 | February 7, 2017 | February 24, 2017 | March 10, 2017 |
| $0.1600 | May 3, 2017 | May 25, 2017 | June 12, 2017 |
| $0.1600 | August 3, 2017 | August 25, 2017 | September 11, 2017 |

On November 1, 2017, 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, 2017 to all stockholders of record as of the close of business on November 24, 2017.

### Cash Flows

Cash flows from operating, investing and financing activities were as follows:

*(in millions)*

| Net cash provided by (used in): | Nine Months Ended September 30, 2017 | 2016 |
| --- | ---: | ---: |
| Operating activities | $439.1 | $499.3 |
| Investing activities | (58.6) | (43.5) |
| Net change in accounts payable-inventory financing | (41.4) | 39.2 |
| Other financing activities | (506.2) | (410.1) |
| Financing activities | (547.6) | (370.9) |
| Effect of exchange rate changes on cash and cash equivalents | 1.3 | (4.2) |
| Net (decrease) increase in cash and cash equivalents | $(165.8) | $80.7 |

#### Operating Activities

*(in millions)*

|  | Nine Months Ended September 30, 2017 | 2016 | Dollar Change |
| --- | ---: | ---: | ---: |
| Net income | $327.8 | $321.2 | $6.6 |
| Adjustments for the impact of non-cash items(1) | 234.9 | 151.0 | 83.9 |
| Net income adjusted for the impact of non-cash items(2) | 562.7 | 472.2 | 90.5 |
| Changes in assets and liabilities: |  |  |  |
| Accounts receivable(3) | (120.4) | (17.9) | (102.5) |
| Merchandise inventory(4) | (90.5) | (64.6) | (25.9) |
| Accounts payable-trade | 140.2 | 141.5 | (1.3) |
| Other(5) | (52.9) | (31.9) | (21.0) |
| Net cash provided by operating activities | $439.1 | $499.3 | $(60.2) |

(1) Includes items such as Deferred income taxes, Depreciation and amortization, Equity-based compensation expense and Net loss on extinguishments of long-term debt.

(2) 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.

(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.

(4) The change in Merchandise inventory was primarily due to the 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.

(5) The change in Other is driven by an increase in 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.

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:

| (in days) | September 30, 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 cycle | 19 | 18 |

(1) 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) Represents the rolling three-month average of the balance of Merchandise inventory at the end of the period divided by average daily cost of sales for the same three-month period.

(3) 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 cost of sales for the same three-month period.

The cash conversion cycle increased to 19 days at September 30, 2017 compared to 18 days at September 30, 2016. 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 as higher Net sales and related Accounts receivable for third-party services such as software as a service, software assurance and warranties. These services have an unfavorable impact 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 have 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 also increased due to the mix of payables with certain vendors that have longer payment terms.

#### Investing Activities

Net cash used in investing activities increased by $15 million in the nine months ended September 30, 2017 compared to the same period of the prior year. Capital expenditures were $59 million and $41 million for the nine months ended September 30, 2017 and 2016, respectively, and primarily related to improvements to our information technology systems during both periods.

#### Financing Activities

Net cash used in financing activities increased by $177 million in the nine months ended September 30, 2017 compared to the same period of the prior year. The increase was primarily driven by share repurchases during the nine months ended September 30, 2017, which resulted in an increase in cash used by 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. 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).

### Long-Term Debt and Financing Arrangements

As of September 30, 2017, we had total indebtedness of $3,430 million, of which $1,739 million was secured indebtedness. At September 30, 2017, 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 at September 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. The amount of restricted payment capacity for the CDW UK Term Loan was $75 million at September 30, 2017.

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.

### 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 4 (Inventory Financing Agreements) to the accompanying Consolidated Financial Statements included in Part I, Item 1 of this Form 10-Q.

### 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" 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 12 (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.

### Critical Accounting Policies and Estimates

Our critical accounting policies have not changed from those reported in Item 7 “Management’s Discussion and Analysis 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.

### 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” 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.

Important factors that could cause actual results to differ materially from our expectations, or cautionary statements, are disclosed under the section entitled “Risk Factors” included in our Annual Report on Form 10-K for the year ended December 31, 2016 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 conditions; decreases in spending on technology products; 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; 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 on commercial delivery 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; 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” included in our Annual Report on Form 10-K for the year ended December 31, 2016 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.

## Market risk

As filed, 522 characters.

See “Management’s Discussion and Analysis of Financial Condition and Results of Operations” and “Quantitative and Qualitative Disclosures about Market Risk” in the Company’s Annual Report in Form 10-K for the year ended December 31, 2016. During the nine months ended September 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.

## Controls and procedures

As filed, 1,434 characters.

### 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”)) 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’s internal control over financial reporting during the three months ended September 30, 2017 that have materially affected, or are reasonably likely to materially affect, the Company’s internal control over financial reporting.

Filed Nov 2, 2017.
Source: SEC EDGAR, the filing index for accession 0001402057-17-000166. Last ingested by Listed: Nov 4, 2026, 16:25 ET. No prices; not investment advice.
