I NVESTOR PRESENTATI ON
Fall 2 0 1 7
I NVESTOR PRESENTATI ON Fall 2 0 1 7 DI SCLAI MERS - - PowerPoint PPT Presentation
I NVESTOR PRESENTATI ON Fall 2 0 1 7 DI SCLAI MERS Forward-Looking Statements Statements in this document that are not statements of historical fact are forward-looking statements within the meaning of the safe harbor provisions of the Private
Fall 2 0 1 7
Forward-Looking Statements Statements in this document that are not statements of historical fact are forward-looking statements within the meaning of the safe harbor provisions of the Private Securities Litigation Reform Act of 1995, including without limitation statements regarding the future financial performance of CDW. These statements involve risks and uncertainties that could cause actual results to differ materially from those described in such statements. These risks and uncertainties 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
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. Although CDW believes that the expectations reflected in such forward- looking statements are reasonable, it can give no assurance that such expectations will prove to have been correct. Reference is made to a more complete discussion of forward- looking statements and applicable risks contained under the captions "Forward-Looking Statements" and "Risk Factors" in CDW's Annual Report on Form 10-K for the year ended December 31, 2016 and subsequent filings with the SEC. CDW undertakes no obligation to update or revise any of its forward-looking statements, whether as a result of new information, future events or otherwise unless required by law. Non-GAAP Financial Information EBITDA is defined as consolidated net income before interest expense, income tax expense, depreciation and amortization. Adjusted EBITDA, which is a measure defined in the Company’s credit agreements, means EBITDA adjusted for certain items which are described in the financial statement tables on investor.cdw.com (“Non-GAAP Reconciliations”). Adjusted EBITDA margin is defined as Adjusted EBITDA as a percentage of Net sales. Non-GAAP net income excludes, among other things, charges related to the amortization of acquisition-related intangible assets, equity-based compensation, acquisition and integration expenses, and gains and losses from the extinguishment of long-term debt. 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. EBITDA, Adjusted EBITDA, Non-GAAP net income, Non-GAAP net income per diluted share, Non-GAAP net income per diluted share, on a constant currency basis, organic net sales, consolidated and organic 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 excluded or included in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP net income per diluted share on a constant currency basis is defined as Non-GAAP net income per diluted share excluding the impact of foreign currency translation on Non-GAAP net income per share compared to the prior period. Organic net sales growth is defined as net sales growth excluding the impact of acquisitions within the last twelve
compared to the prior period. The Company believes these measures provide analysts, investors and management with helpful information regarding the underlying operating performance of the Company’s business, as they remove the impact of items that management believes are not reflective of underlying operating performance. The Company 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”) used to evaluate the Company’s ability to make certain investments, incur additional debt and make restricted payments, such as dividends and share repurchases, as well as whether the Company is required to make additional principal prepayments on the Term Loan beyond the quarterly amortization payments. Our medium term annual targets are provided on a non-GAAP basis because certain reconciling items are dependent on future events that either cannot be controlled, such as currency impacts or interest rates, or reliably predicted because they are not part of the Company's routine activities, such as acquisition and integration expenses. The financial statement tables available on investor.cdw.com (“Non-GAAP Reconciliations”) include a reconciliation of non-GAAP financial measures to the applicable most comparable GAAP financial measures. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures.
2
3
technology solutions to business, government, education and healthcare customers for 30+ years
North America and ~ 1,000 in the UK; ~ 2/ 3 are customer-facing
services technology solutions
from 1,000+ brands to more than 250,000 customers in the US, UK and Canada
employees
demonstrated track record of profitable growth
¹ Please see Adj. EBITDA reconciliation to net income (loss) on page 27
2 Please see ROWC calculation on page 29
$7.2 $8.8 $9.6 $10.1 $10.8 $12.1 $13.0 $14.0
2009 2010 2011 2012 2013 2014 2015 2016
($29) $17 $119 $133 $245 $403 $424 $465 $602 $717 $767 $809 $907 $1,019 $1,117
2009 2010 2011 2012 2013 2014 2015 2016 GAAP Net Income (Loss) Adj EBITDA $
($373)
4
Average Daily Sales Growth1 %
Adjusted EBITDA3 Margin % Non-GAAP EPS Growth% U.S. IT growth + 200-300bps in constant currency High 7% to 8% Low double-digits in constant currency Q2 2017 Medium-Term Targets 2016-2018 9.0%2 7.9% 10.0%4
1 Consolidated constant currency growth = 9.8%. Please see reconciliation on page 32 2 There were 64 selling days for the three months ended June 30, 2017 and 2016. 3 Defined as Adj. EBITDA/Net Sales. Please see reconciliation on page 30 4 Please see Non-GAAP Net Income per diluted share, on a constant currency basis reconciliation on page 31. Consolidated
constant currency growth = 10.8%
Indirect 60% Direct 40%
5
Large Market Size and Attractive Growth Profile
Total US, UK and Canada IT Market2: ~$890B CDW Current Addressable Market1: ~$290B
Partners Increasingly Reliant on the Indirect Channel
2015-2019 CAGR IT Spending: 3.0%²
CDW $14.0B
1 IDC, Company 10-Ks, Wall Street research, VAR500 database, CDW internal estimates as of 11/2016 2 IDC Worldwide Black Book, 11/16/2016, includes Consumer and B2B for US, UK and Canada markets 3IDC Routes to Market, 11/1/2016
Increased ~300bps since 20073
3.4% 4.2% 4.7% 8.3% 6.9% 9.0%
2001-2016 2005-2016 2009-2016
1
6
490 bps
2
1 IDC Worldwide Black Book, 11/16/16 2 2016 Organic Net Sales only, excluding CDW UK. Please see reconciliation on page 33 3 Estimated market share for top 5 publicly traded companies: CDW, Insight North America, PC Connection, PC Mall, and e-Plus as of 12/31/2016.
270 bps 430 bps
VALUE TO VENDOR PARTNERS:
capabilities
technology roadmaps
VALUE TO CUSTOMERS:
solutions
7
11% 5% 5% 10% 15% 14%
8
Net Sales Growth % 2016 Net Sales ($14B) 10%
Corporate (>250 coworkers) Small Businesses (<250 coworkers) Government (Federal, State & Local) Education (K-12, Higher Ed) Healthcare Other (Canada, UK) 19% 14% 3% 7% 30% 29% 0% 5% 10% 11% 3% 63%
11% 3% 0%
(11%) 16% 8%
'08-'09 Growth
(Other includes ATS & Canada)
'09-'11 CAGR
(Other includes ATS & Canada)
‘09-'15 CAGR
(Other includes ATS & Canada)
’15 – ’16 Growth
Other Includes Canada & CDW UK (Aug 2015-Dec 16)
Total Growth
Diverse Customer Channels and Geography Create Multiple Drivers of Growth and Diversification Against Macro and Exogenous Headwinds
9
1 0
Printers Storage Networking Electronics Monitors Software Cables Servers Computers Accessories Office Services
Products Complexity / Productivity and Growth Benefits Early 2000s Current Integrated Solutions
2006 2016
+30%
Specialists Field Sellers Account Managers Advanced Services Delivery Engineers
+93%
1 1
* North American operations
SERVI CES
CLOUD
Managed
SECURI TY
DI GI TAL W ORKSPACE
DATA CENTER
1 2
1 3
1 IDC as of June 2016 CDW U.S. Addressable Market 2 CDW CAGR based on the 2014-2016 customer spend
1 4
3% 7% 7% 7% 29% 3% 8% 15% 24% 23% 70% 14% Data Center Unified Communications Security Mobility Cloud Services
Projected 2013-2016 Market CAGR1 CDW Customer Spend Growth 2013-20162
1 5
1 6
Highly Engaged And Performance Driven Culture
Deep and Experienced Management
1 Please see Non-GAAP Net Income reconciliation to net income (loss) on page 28 2 Defined in our credit agreement, on a consolidated basis, as the ratio of total debt at period-end excluding any unamortized discount and/or premium and unamortized
deferred financing costs, less cash and cash equivalents, to trailing twelve months (TTM) Adjusted EBITDA, a non-GAAP measure defined in our credit agreement. The Senior Secured Term Loan Facility calculates Adjusted EBITDA on a trailing twelve month basis.
3 Please see Adj. EBITDA reconciliation to net income (loss) on page 27 4 Defined as Adj. EBITDA/Net Sales. Please see reconciliation on page 30
1 7
$602 $717 $767 $809 $907 $1,019 $1,117 $1,073 $1,148
6.8% 7.5%
7.6% 7.5% 7.5% 7.8% 8.0% 7.8% 7.9%
2010 2011 2012 2013 2014 2015 2016 Q2'16 LTM Q2'17 LTM
$8.8 $9.6 $10.1 $10.8 $12.1 $13.0 $14.0 $13.7 $14.5 2010 2011 2012 2013 2014 2015 2016 Q2'16 LTM Q2'17 LTM
7.9x 6.4x 5.0x 4.5x 3.4x 3.0x 2.9x 2.7x 2.8x
Q2'10 Q2'11 Q2'12 Q2'13 Q2'14 Q2 '15 Q2 16 Q1 17 Q2 17 $199 $247 $314 $410 $504 $569 $535 $585 2011 2012 2013 2014 2015 2016 Q2'16 LTM Q2'17 LTM
NGNI
Net Sales ($bn)
GAAP and Non-GAAP Net Income1($mm) Net Leverage Ratio2
GAAP NI
84.2% 83.5% 83.5% 83.7% 84.1% 83.7% 83.4% 9.0% 9.1% 9.0% 8.9% 8.4% 8.5% 8.7% 6.8% 7.5% 7.6% 7.5% 7.5% 7.8% 8.0% 2010 2011 2012 2013 2014 2015 2016 COGS as a % of sales Adjusted SG&A + Adv % of Sales Adjusted EBITDA Margin
1 8
15.8% 16.5% 16.5% 16.3% 15.9% 16.3% 16.6% Net Sales Gross Margin %
2009 2010 2011 2012 2013 2014 2015 2016 CDW UK Acquisition
1 9
$1.83 $2.37 $2.93 $3.43
$0 $50 $100 $150 $200 $250 $300 $- $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00
2013 2014 2015 2016 EPS Interest Expense Non-GAAP Earnings per Share (in $) Interest Expense (in $M)
2 0
Actions
2 1
Increase Dividends Annually Maintain Net Leverage Ratio(2) Supplement Organic Growth with M&A Priorities Objectives Return Excess FCF after Dividends & M&A Through Share Repurchase 49% increase to $0.64/share Currently at 2.8x(3) CDW UK acquisition Repurchase program Target 30% payout
~2.5 to 3.0 times Net Leverage Tuck-in, accretive deals Offset incentive plan dilution and supplement EPS growth
1 Target established November 2014 2 Defined in the Company's credit agreement, on a consolidated basis, as the ratio of total debt at period-end excluding any unamortized discount
and/or premium and unamortized deferred financing costs, less cash and cash equivalents, to trailing twelve months (TTM) Adjusted EBITDA, a non- GAAP measure defined in the Company's credit agreement.
3 As of June 30, 2017
2 2
*Includes Q1 and Q2 2017
2 3
2013 2014 2015 2016
2015 2016
2 4
2 7
(Unaudited) ($ in millions)
2009 2010 2011 2012 2013 2014 2015 (vii) 2016 (vii) LTM Q2 2017 Net income (loss) $ (373.4) $ (29.2) $ 17.1 $ 119.0 $ 132.8 $ 244.9 $ 403.1 $ 424.4 $ 427.7 Depreciation and amortization 218.2 209.4 204.9 210.2 208.2 207.9 227.4 254.5 256.5 Income tax expense (benefit) (87.8) (7.8) 11.2 67.1 62.7 142.8 243.9 248.0 202.4 Interest expense, net 431.7 391.9 324.2 307.4 250.1 197.3 159.5 146.5 147.1 EBITDA $ 188.7 $ 564.3 $ 557.4 $ 703.7 $ 653.8 $ 792.9 $ 1,033.9 $ 1,073.4 $ 1,033.7 Adjustments: Equity-based compensation 15.9 11.5 19.5 22.1 8.6 16.4 31.2 39.2 44.8 Net loss (gain) on extinguishments of long-term debt — (2.0) 118.9 17.2 64.0 90.7 24.3 2.1 59.5 (Income) loss from equity investments (i) — (0.1) (0.1) (0.3) (0.6) (2.2) 10.1 (1.1) 0.3 IPO and secondary-offering related expenses (ii) — — — — 75.0 1.4 0.8 — — Acquisition and integration expenses (iii) — — — — — — 10.2 7.3 5.9 Gain on remeasurement of equity investment (iv) — — — — — — (98.1) — — Goodwill impairment 241.8 — — — — — — — — Other adjustments (v) 19.0 28.1 21.6 23.9 7.7 7.8 6.1 (3.6) 3.7 Adjusted EBITDA $ 465.4 $ 601.8 $ 717.3 $ 766.6 $ 808.5 $ 907.0 $ 1,018.5 $ 1,117.3 $ 1,147.9 Net Sales $ 7,162.6 $ 8,801.2 $ 9,602.4 $ 10,128.2 $ 10,768.6 $ 12,074.5 $ 12,988.7 $ 13,981.9 $ 14,519.7 Adjusted EBITDA Margin (vi) 6.5% 6.8% 7.5% 7.6% 7.5% 7.5% 7.8% 8.0% 7.9%
(i)
Represents the Company's share of net (income) loss from the Company's equity investments. 2015 includes the Company's 35% share of CDW UK's (previously known as Kelway) net loss which includes the Company's 35% share of an expense related to certain equity awards granted by one of the sellers to CDW UK coworkers in July 2015 prior to the acquisition.
(ii)
2013 includes IPO related expenses of $74.3 million, consisting of (1) acceleration charge for certain equity awards and related employer payroll taxes ($40.7 million); (2) RDU Plan cash retention pool accrual ($7.5 million); (3) management services agreement termination fee ($24.4 million); and (4) other expenses ($1.7 million). 2013 also includes $0.7 million of secondary-offering related expenses. 2014 and 2015 include various secondary
(iii)
Comprised of expenses related to CDW UK.
(iv)
Represents the gain resulting from the remeasurement of the Company's previously held 35% equity investment to fair value upon the completion of the acquisition of CDW UK.
(v)
Other adjustments primarily include items such as sponsor fees, historical retention costs, expenses related to the consolidated of office space, settlement payments received from the Dynamic Random Access Memory class action lawsuits and certain consulting and debt related professional fees.
(vi)
Defined as Adjusted EBITDA divided by Net sales.
(vii) 2015 and 2016 reflects the impact of consolidating CDW UK's financial results for five months and twelve months, respectively.
2 8
(Unaudited) ($ in millions) 2012 2013 2014 2015(ix) 2016(ix) LTM Q2' 17 Net income (loss) $ 119.0 $ 132.8 $ 244.9 $ 403.1 $ 424.4 $ 427.7 Amortization of intangibles (i) 163.7 161.2 161.2 173.9 187.2 185.1 Equity-based compensation 22.1 8.6 16.4 31.2 39.2 44.8 Equity-based compensation related to equity investment (ii) — — — 20.0 — — Net loss on extinguishments of long-term debt 17.2 64.0 90.7 24.3 2.1 59.5 Interest expense adjustment related to extinguishments of long-term debt (iii) (3.3) (7.5) (1.1) — — — IPO and secondary-offering related expenses (iv) — 75.0 1.4 0.8 — — Acquisition and integration expenses (v) — — — 10.2 7.3 5.9 Gain on remeasurement of equity investment (vi) — — — (98.1) — — Other adjustments (vii) — (6.3) (0.6) 2.9 (5.4) 2.4 Aggregate adjustment for income taxes (viii) (71.6) (113.5) (103.0) (64.8) (85.8) (140.2) Non-GAAP net income $ 247.1 $ 314.3 $ 409.9 $ 503.5 $ 569.0 $ 585.2 (i) Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names. (ii) Represents the Company's 35% share of an expense related to certain equity awards granted by one of the sellers to CDW UK coworkers in July 2015 prior to the Company's acquisition. (iii) Reflects adjustments to interest expense resulting from debt extinguishments. Represents the difference between interest expense previously recognized under the effective interest method and actual interest paid. (iv) 2013 includes IPO related expenses of $74.3 million, consisting of (1) acceleration charge for certain equity awards and related employer payroll taxes ($40.7 million); (2) RDU Plan cash retention pool accrual ($7.5 million); (3) management services agreement termination fee ($24.4 million); and (4) other expenses ($1.7 million). 2013 also includes $0.7 million of secondary-offering related
(v) Comprised of expenses related to CDW UK. (vi) Represents the gain resulting from the remeasurement of the Company's previously held 35% equity investment to fair value upon the completion of the acquisition of CDW UK. (vii) Other adjustments primarily include items such as expenses related to the consolidation of office space, settlement payments received from the Dynamic Random Access Memory class action lawsuits and the favorable resolution of a local sales tax matter. (viii) Aggregate adjustment for income taxes consists of the following: 2012 2013 2014 2015 2016 LTM Q2' 17 Total Non-GAAP adjustments $ 199.7 $ 295.0 $ 268.0 $ 165.2 $ 230.4 $ 297.7 Weighted-average statutory effective rate 39.0% 39.0% 39.0% 38.0% 36.0% 36.0% Income tax (77.9) (115.1) (104.5) (62.8) (82.9) (107.2) Deferred tax adjustment due to law changes — — — (4.0) (1.5) (1.5) Excess tax benefits from equity-based compensation — — — — (1.8) (32.0) Withholding tax expense on the unremitted earnings of our Canadian subsidiary — — — 3.3 — — Non-deductible adjustments and other 6.3 1.6 1.5 (1.3) 0.4 0.5 Total aggregate adjustment for income taxes $ (71.6) $ (113.5) $ (103.0) $ (64.8) $ (85.8) $ (140.2) (ix) 2015 and 2016 reflects the impact of consolidating CDW UK's financial results for five months and twelve months, respectively.
2 9
(Unaudited) ($ in millions)
2009 2010 2011 2012 2013 2014 2015 2016 LTM Q2' 2017 Numerator Income from operations $ (31.9) $ 352.7 $ 470.7 $ 510.6 $ 508.6 $ 673.0 $ 742.0 $ 819.2 $ 835.6 Amortization of intangibles (i) 168.9 166.8 165.7 163.7 161.2 161.2 173.9 187.2 185.1 Debt-related refinancing costs (ii) — 5.6 3.8 — — — — — — Non-cash equity-based compensation 15.9 11.5 19.5 22.1 8.6 16.4 31.2 39.2 44.8 Goodwill impairment 241.8 — — — — — — — — Other one-time items as incurred (iii) 1.4 — — — 68.7 0.8 12.0 4.5 6.4 Adjusted NOPBT 396.1 536.6 659.7 696.4 747.1 851.4 959.1 1,050.1 1,071.9 Taxes (iv) (154.5) (209.3) (257.3) (271.6) (291.4) (332.0) (374.1) (388.6) (396.6) Adjusted NOPAT $ 241.6 $ 327.3 $ 402.4 $ 424.8 $ 455.7 $ 519.4 $ 585.1 $ 661.6 $ 675.2 Denominator Trailing 5-point avg. AR (incl. misc. rec.) $ 1,008.9 $ 1,210.7 $ 1,352.5 $ 1,400.1 $ 1,502.0 $ 1,629.6 $ 1,909.4 $ 2,248.8 $ 2,268.1 Trailing 5-point avg. Inventory 252.8 286.9 317.4 330.3 357.5 396.2 387.1 448.9 459.5 Trailing 5-point avg. AP (354.9) (500.4) (712.0) (831.2) (906.7) (1,017.8) (1,184.4) (1,470.8) (1,504.7) Working Capital $ 906.8 $ 997.2 $ 957.9 $ 899.2 $ 952.8 $ 1,008.0 $ 1,112.1 $ 1,226.9 $ 1,222.9 Return on Working Capital (ROWC) 26.6% 32.8% 42.0% 47.2% 47.8% 51.5% 52.6% 53.9% 55.2% (i) Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names. (ii) Represents fees and costs expensed related to the December 2010 and March 2011 amendments to the Company's prior term loan facility. (iii) Includes IPO and secondary-offering related expenses, litigation items, acquisition and integration expenses and expenses related to the consolidation of office locations north of Chicago. (iv) Based on a normalized statutory tax rate of 37% for 2017 and 2016. Prior to 2016, the normalized statutory tax rate was 39.0%.
3 0
Unaudited ($mm)
2009 2010 2011 2012 2013 2014 2015 2016 LTM Q2 2017 Net Sales $7,162.6 $8,801.2 $9,602.4 $10,128.2 $10,768.2 $12,074.5 $12,988.7 $13,981.9 $14,519.7 Adjusted EBITDA $465.4 $601.8 $717.3 $766.6 $808.5 $907 $1,018.5 $1,117.3 $1,147.9 Adjusted EBITDA Margin 6.5% 6.8% 7.5% 7.6% 7.5% 7.5% 7.8% 8.0% 7.9%
3 1
(Unaudited) ($ and shares in millions, except per share amounts)
Three Months Ended June 30, Six Months Ended June 30, 2017 2016 % Change (1) 2017 2016 % Change (1) Net income $ 141.0 $ 117.5 $ 198.7 $ 195.3 Amortization of intangibles 46.3 47.1 92.4 94.6 Equity-based compensation 11.5 9.7 23.6 18.1 Net Loss on extinguishments of long-term debt — — 57.4 — Integration expenses 2.0 2.2 2.5 3.8 Other adjustments 3.7 0.3 4.9 (2.8) Aggregate adjustment for income taxes (41.3) (21.2) (95.0) (40.7) Non-GAAP Net Income(2)* $ 163.2 $ 155.6 4.9% $ 284.5 $ 268.3 6.0% Foreign currency translation(3) — (1.2) — (1.9) Non-GAAP Net Income, on a constant currency basis* $ 163.2 $ 154.4 5.7% $ 284.5 $ 266.4 6.8% Shares used in computing Non-GAAP net income per diluted share and Non-GAAP net income per diluted share, on a constant currency basis 159.0 166.7 160.9 167.8 Non-GAAP net income per diluted share* $ 1.03 $ 0.93 10.0% $ 1.77 $ 1.60 10.6% Non-GAAP net income per diluted share, on a constant currency basis* $ 1.03 $ 0.93 10.0% $ 1.77 $ 1.59 11.4% (1) There were 64 selling days for the three months ended June 30, 2017 and 2016. There were 128 selling days for the six months ended June 30, 2017 and 2016. (2) See Slide 10 and 13 in the Webcast Slides for details on the adjustments to Non-GAAP Net Income. (3) Represents the effect of translating the prior year results of CDW Canada and CDW UK at the average exchange rates applicable in the current year. *
Non-GAAP Net income, Non-GAAP Net Income per diluted share, Non-GAAP Net income on a constant currency basis and Non-GAAP Net Income per diluted share on a constant currency basis are non-GAAP financial measures. For a discussion of non-GAAP financial measures, see Exhibit 99.1 to the Company's Current Report on Form 8-K filed with the Securities and Exchange Commission on August 3, 2017.
3 2
(Unaudited) ($ in millions)
Three Months Ended June 30, Six Months Ended June 30, 2017 2016 % Change (1) 2017 2016 % Change (1)
Consolidated Net sales, as reported
$ 3,994.4 $ 3,664.6 9.0% $ 7,319.1 $ 6,781.3 7.9%
Foreign currency translation (ii)
— (27.6) — (54.4)
Consolidated Net sales, on a constant currency basis*
$ 3,994.4 $ 3,637.0 9.8% $ 7,319.1 $ 6,726.9 8.8%
(i) There were 64 and 128 selling days during the three and six months ended June 30, 2017 and 2016, respectively. (ii) Represents the effect of translating the prior year results of CDW Canada and CDW UK at the average exchange rates applicable in the current
year. * Consolidated Net sales growth on a constant currency basis is a non-GAAP financial measure. For a discussion of non-GAAP financial measures, see Exhibit 99.1 to the Company's Current Report on Form 8-K filed with the Securities and Exchange Commission on August 3, 2017.
(Unaudited) ($ in millions) Year Ended December 31, 2016 2015 % Change Average Daily % Change (1)
Consolidated Net sales, as reported
$ 13,981.9 $ 12,988.7 7.6% 7.6%
Impact of acquisition(2)
(503.9) —
Consolidated Organic Net sales
13,478.0 12,988.7
Foreign currency translation(3)
— (76.3)
Consolidated Organic Net sales, on a constant currency basis*
$ 13,478.0 $ 12,912.4 4.4% 4.4% (1) There were 254 selling days for both years ended December 31, 2016 and 2015, respectively. (2) Excludes CDW UK's year-to-date results through July 2016 for the year ended December 31, 2016 as the acquisition was completed on August 1, 2015. (3) Represents the effect of translating the prior year results of CDW Canada and CDW UK at the average exchange rates applicable in the current year. Includes the impact of consolidating five months of CDW UK's financial results for the twelve months ended December 31, 2015. * Organic net sales growth and organic net sales growth on a constant currency basis are non-GAAP financial measures. For a discussion
Commission on February 7, 2017.
3 3
3 4
For a copy of this presentation, please access CDW’s investor relations website at: http:/ / investor.cdw .com /