CDW Reports Record Third Quarter Net Sales


Reinforces Power of Business Model and Strategy

(Dollars in millions, except per share amounts)Three
Months
Ended
September
30, 2018
Three
Months
Ended
September
30, 20171
% Chg.Nine
Months
Ended
September
30, 2018
Nine
Months
Ended
September
30, 20171
% Chg.
Net Sales$4,373.2 $3,933.2 11.2 $12,165.7 $11,080.8 9.8 
Average Daily Sales269.4 62.4 11.2 63.7 58.0 9.8 
Gross Profit713.6 642.2 11.1 2,013.1 1,836.5 9.6 
Net Income183.7 129.3 42.1 483.7 328.3 47.3 
Adjusted EBITDA3354.7 324.6 9.3 979.2 889.2 10.1 
Net Income per Diluted Share$1.20 $0.83 44.4 $3.14 $2.06 52.4 
Non-GAAP Net Income per Diluted Share3$1.42 $1.08 31.4 $3.85 $2.85 35.3 
1  Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).
There were 63 selling days for both the three months ended September 30, 2018 and 2017. There were 191 selling days for both the nine months ended September 30, 2018 and 2017.
Non-GAAP measures used in this release that are not based on accounting principles generally accepted in the United States of America are each defined and reconciled to the most directly comparable GAAP measure in the attached schedules.


LINCOLNSHIRE, Ill., Oct. 31, 2018 (GLOBE NEWSWIRE) -- CDW Corporation (Nasdaq:CDW), a leading multi-brand technology solutions provider to business, government, education and healthcare in the United States, the United Kingdom and Canada, today announced third quarter results. The company also announced the approval by its Board of Directors of a 40 percent increase to its quarterly cash dividend. The dividend is to be paid in December 2018.

"We had another strong quarter of profitable topline growth while continuing to invest in the future and deliver shareholder value," said Thomas E. Richards, chairman and chief executive officer of CDW. "These results reinforce the strength of our strategy and power of our business model - underpinned by our balance across customer end markets, the breadth of our products and solution portfolio and the ongoing execution of our strategy for growth."

"Strong operating results were amplified by a lower tax rate and share repurchases, delivering a 31.4 percent increase in non-GAAP net income per diluted share," said Collin B. Kebo, CDW's chief financial officer. "Given this quarter's results and our expectations for the balance of the year, we are now targeting 2018 constant currency non-GAAP net income per diluted share growth just above thirty percent."

"We continue to expect to exceed our annual target to outpace US IT market growth by 200 to 300 basis points in 2018. To accomplish this, we will continue our laser-focus on meeting the needs of our more than 250,000 customers in the United States, the United Kingdom and Canada and remaining the partner of choice for more than 1,000 leading and emerging technology brands as the technology market continues to evolve," concluded Richards.

A quarterly cash dividend of $0.295 per share, which is 40 percent higher than the prior year period, will be paid on December 10, 2018 to all stockholders of record as of the close of business on November 26, 2018.

Third Quarter of 2018 Highlights:

Total net sales in the third quarter of 2018 were $4,373 million, compared to $3,933 million in the third quarter of 2017, an increase of 11.2 percent. Net sales on a constant currency basis increased 11.4 percent versus the third quarter of 2017. Currency impact to net sales growth was primarily driven by unfavorable translation of the Canadian to US dollar. There were 63 selling days for both the three months ended September 30, 2018 and 2017. Third quarter performance included:

  • Total Corporate segment net sales in the third quarter of 2018 were $1,707 million, 9.9 percent higher than the third quarter of 2017.

  • Total Small Business segment net sales in the third quarter of 2018 were $340 million, 11.3 percent higher than the third quarter of 2017.

  • Total Public segment net sales in the third quarter of 2018 were $1,875 million, 10.7 percent higher than the third quarter of 2017. Public results were led by sales to Education customers, which increased 14.7 percent. Sales to Government and Healthcare customers increased 8.0 percent and 7.8 percent, respectively.

  • Net sales for CDW's UK and Canadian operations, combined as “Other” for financial reporting purposes, were $452 million, 18.5 percent higher than the third quarter of 2017. UK results were up double digits in local currency. Canada results were up high single digits in local currency.

Gross profit for the third quarter of 2018 was $714 million, compared to $642 million for the same period in 2017, representing an increase of 11.1 percent. Gross profit margin was 16.3 percent for both the third quarter of 2018 and 2017. Gross profit margin was positively impacted by product margin improvement. This was offset by year-over-year Net sales growth out-pacing the year-over-year growth rate in partner funding.

Total selling and administrative expenses, including advertising expense, were $439 million in the third quarter of 2018, compared to $398 million in the third quarter of 2017, representing an increase of 10.2 percent. This was primarily driven by increased sales payroll costs consistent with higher gross profit, performance-based compensation consistent with higher attainment against goals and strategic investments funded by tax reform.

Interest expense was $37 million in the third quarter of 2018 compared to $38 million in the comparable period of 2017.

The effective tax rate for the third quarter of 2018 was 22.9 percent, which resulted in tax expense of $55 million, compared to a 37.5 percent tax rate and tax expense of $78 million in the third quarter of 2017. The reduction in effective tax rate primarily reflects the year-over-year impact of a lower Federal tax rate and higher excess tax benefits related to equity-based compensation.

Net income was $184 million in the third quarter of 2018, compared to $129 million in the third quarter of 2017, representing an increase of 42.1 percent. Non-GAAP net income, which excludes, among other things, acquisition-related intangible asset amortization, equity-based compensation and the associated tax benefits, integration expenses, and certain other items, was $218 million in the third quarter of 2018, compared to $168 million in the third quarter of 2017, representing an increase of 29.3 percent.

Adjusted EBITDA, which excludes expenses related to equity-based compensation, income from equity investment, integration expenses, and certain other items, was $355 million in the third quarter of 2018, compared to $325 million in the third quarter of 2017, representing an increase of 9.3 percent. For the third quarter of 2018, the Adjusted EBITDA margin was 8.1 percent compared to 8.3 percent in the third quarter of 2017.

Weighted average diluted shares outstanding were 154 million for the third quarter of 2018, compared to 156 million for the third quarter of 2017. Net income per diluted share for the third quarter of 2018 was $1.20, compared to $0.83 for the third quarter of 2017, representing an increase of 44.4 percent. Non-GAAP net income per diluted share for the third quarter of 2018 was $1.42, compared to $1.08 for the third quarter of 2017, representing an increase of 31.4 percent.

First Nine Months of 2018 Highlights:

Total net sales in the first nine months of 2018 were $12,166 million, compared to $11,081 million in the first nine months of 2017, an increase of 9.8 percent. Net sales on a constant currency basis increased 9.3 percent versus the first nine months of 2017. Currency impact to net sales growth was driven by favorable translation of the British pound to US dollar and favorable translation of the Canadian to US dollar. There were 191 selling days for both the nine months ended September 30, 2018 and 2017. The first nine months' performance included:

  • Total Corporate segment net sales in the first nine months of 2018 were $5,006 million, 9.5 percent higher than the first nine months of 2017.

  • Total Small Business segment net sales in the first nine months of 2018 were $997 million, 9.3 percent higher than the first nine months of 2017.

  • Total Public segment net sales in the first nine months of 2018 were $4,741 million, 5.8 percent higher than the first nine months of 2017. Public results were led by sales to Education customers, which increased 6.3 percent. Sales to Healthcare and Government customers increased 7.1 percent and 4.1 percent, respectively.

  • Net sales for CDW's UK and Canadian operations, combined as “Other” for financial reporting purposes, were $1,422 million, 27.6 percent higher than the first nine months of 2017. Both UK and Canada results were up double digits in local currency.

Gross profit for the first nine months of 2018 was $2,013 million, compared to $1,837 million for the same period in 2017, representing an increase of 9.6 percent. Gross profit margin was 16.5 percent for the first nine months of 2018 versus 16.6 percent for the first nine months of 2017.

Total selling and administrative expenses, including advertising expense, were $1,269 million in the first nine months of 2018, compared to $1,191 million in the first nine months of 2017, representing an increase of 6.5 percent. This increase was primarily driven by increased sales payroll costs, consistent with higher gross profit, and performance-based compensation, consistent with higher attainment against goals.

Interest expense was $112 million in the first nine months of 2018 compared to $113 million in the comparable period of 2017.

The effective tax rate for the first nine months of 2018 was 23.7 percent, which resulted in tax expense of $150 million, compared to a 31.1 percent tax rate and tax expense of $148 million in the first nine months of 2017. The decrease in effective tax rate primarily reflects the year-over-year impact of a lower Federal tax rate, which was partially offset by lower excess tax benefits from equity-based compensation.

Net income was $484 million in the first nine months of 2018, compared to $328 million in the first nine months of 2017, representing an increase of 47.3 percent. Non-GAAP net income, which excludes, among other things, acquisition-related intangible asset amortization, equity-based compensation and the associated tax benefits, integration expenses, and certain other items, was $594 million in the first nine months of 2018, compared to $453 million in the first nine months of 2017, representing an increase of 31.0 percent.

Adjusted EBITDA, which excludes expenses related to equity-based compensation, income from equity investment, integration expenses, and certain other items, was $979 million in the first nine months of 2018, compared to $889 million in the first nine months of 2017, representing an increase of 10.1 percent. The Adjusted EBITDA margin was 8.0 percent for both the first nine months of 2018 and 2017.

Weighted average diluted shares outstanding were 154 million for the first nine months of 2018, compared to 159 million for the first nine months of 2017. Net income per diluted share for the first nine months of 2018 was $3.14 compared to $2.06 for the first nine months of 2017, representing an increase of 52.4 percent. Non-GAAP net income per diluted share for the first nine months of 2018 was $3.85, compared to $2.85 for the first nine months of 2017, representing an increase of 35.3 percent.

Forward-Looking Statements

Statements in this release 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 and political conditions; decreases in spending on technology products and services; CDW's relationships with vendor partners and availability of their products; continued innovations in hardware, software and services offerings by CDW's vendor partners; substantial competition that could reduce CDW's market share; CDW's substantial indebtedness and ability to generate sufficient cash to service such indebtedness; restrictions imposed by agreements relating to CDW's indebtedness on its operations and liquidity; changes in, or the discontinuation of, CDW's share repurchase program or dividend payments; the continuing development, maintenance and operation of CDW's information technology systems; potential breaches of data security and failure to protect our information technology systems from cybersecurity threats; potential failures to comply with Public segment contracts or applicable laws and regulations; potential failures to provide high-quality services to CDW's customers; potential losses of any key personnel; potential interruptions of the flow of products from suppliers; potential adverse occurrences at one of CDW's primary facilities or customer data centers; increases in the cost of commercial delivery services or disruptions of those services; CDW's exposure to accounts receivable and inventory risks; fluctuations in foreign currency; future acquisitions or alliances; fluctuations in CDW's operating results; current and future legal proceedings and audits; changes in laws, including the recent U.S. tax legislation, regulations or interpretations thereof; 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, 2017 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 that accompany this press release. Adjusted EBITDA margin is defined as Adjusted EBITDA as a percentage of Net sales. Non-GAAP income before income taxes and Non-GAAP net income exclude, among other things, charges related to the amortization of acquisition-related intangible assets, equity-based compensation and the associated tax benefits, 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, Adjusted EBITDA margin, Non-GAAP income before income taxes, Non-GAAP net income, Non-GAAP net income per diluted share 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 excluded or included in the most directly comparable measure calculated and presented in accordance with GAAP.

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 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 refinancing activities or acquisition and integration expenses.

The financial statement tables that accompany this press release 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.

About CDW

CDW is a leading multi-brand technology solutions provider to business, government, education and healthcare organizations in the United States, the United Kingdom and Canada. A Fortune 500 company with multi-national capabilities, CDW was founded in 1984 and employs more than 8,900 coworkers. For the trailing twelve months ended September 30, 2018, the company generated net sales of approximately $16 billion. For more information about CDW, please visit www.CDW.com.  

Webcast

CDW will hold a conference call today, October 31, 2018 at 7:30 a.m. CT/8:30 a.m. ET to discuss its third quarter financial results. The conference call, which will be broadcast live via the Internet, and a copy of this press release along with supplemental slides used during the call, can be accessed on CDW’s website at investor.cdw.com. For those unable to participate in the live call, a replay of the webcast will be available at investor.cdw.com approximately 90 minutes after the completion of the call and will be accessible on the site for approximately one year.

Investor Inquiries        
Sari Macrie, CFA            
Vice President, Investor Relations                          
(847) 968-0238 

Media Inquiries
Sara Granack
Vice President, Corporate Communications
(847) 419-7411    

CDWPR-FI


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(dollars in millions, except per share amounts)
(unaudited)

  Three Months Ended September 30, Nine Months Ended September 30,
  2018 2017(i) %
Change(ii)
 2018 2017(i) %
Change(ii)
             
Net sales $4,373.2  $3,933.2  11.2% $12,165.7  $11,080.8  9.8%
Cost of sales 3,659.6  3,291.0  11.2  10,152.6  9,244.3  9.8 
             
Gross profit 713.6  642.2  11.1  2,013.1  1,836.5  9.6 
             
Selling and administrative expenses 390.7  351.9  11.0  1,134.8  1,062.8  6.8 
Advertising expense 48.1  46.3  3.8  133.9  128.1  4.5 
Income from operations 274.8  244.0  12.6  744.4  645.6  15.3 
             
Interest expense, net (36.6) (37.8) (3.0) (111.5) (113.4) (1.7)
Net loss on extinguishments of long-term debt         (57.4) (100.0)
Other income, net 0.2  0.7  (76.7) 1.0  1.9  (49.6)
             
Income before income taxes 238.4  206.9  15.2  633.9  476.7  33.0 
             
Income tax expense (54.7) (77.6) (29.6) (150.2) (148.4) 1.2 
             
Net income $183.7  $129.3  42.1% $483.7  $328.3  47.3%
             
Net income per common share:            
Basic $1.22  $0.84  44.9% $3.19  $2.10  52.2%
Diluted $1.20  $0.83  44.4% $3.14  $2.06  52.4%
             
Weighted-average shares outstanding:            
Basic 150.9  153.8    151.6  156.3   
Diluted 153.7  156.2    154.1  159.2   

* Not meaningful

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) There were 63 selling days for both the three months ended September 30, 2018 and 2017. There were 191 selling days for both the nine months ended September 30, 2018 and 2017.

 


CDW CORPORATION AND SUBSIDIARIES

NON-GAAP FINANCIAL MEASURE RECONCILIATIONS

The Company has included reconciliations of Non-GAAP income before income taxes, Non-GAAP net income, Non-GAAP net income per diluted share, EBITDA, Adjusted EBITDA, Adjusted EBITDA margin, and consolidated Net sales growth on a constant currency basis for the three and nine months ended September 30, 2018 and 2017 below.

NON-GAAP INCOME BEFORE INCOME TAXES, NON-GAAP NET INCOME
AND NON-GAAP NET INCOME PER DILUTED SHARE
(dollars in millions, except per share amounts)
(unaudited)

 Three Months Ended September 30,  
 2018 2017(i)  
 Income
before
Income
Taxes
 Income
Tax
Expense(ii)
 Net
Income
 Effective
Tax Rate
 Income
before
Income
Taxes
 Income
Tax
Expense)
Benefit(ii)
 Net
Income
 Effective
Tax Rate
 Net
Income
%
Change
                  
GAAP, as reported$238.4  $(54.7) $183.7  22.9% $206.9  $(77.6) $129.3  37.5% 42.1%
Amortization of intangibles(iii)45.3  (12.0) 33.3    46.5  (15.8) 30.7     
Equity-based compensation10.8  (10.5) 0.3    10.0  (4.1) 5.9     
Reinstatement of prior year unclaimed property balances(iv)        4.1  (1.6) 2.5     
Tax Cuts and Jobs Act(v)  (2.0) (2.0)            
Other adjustments(vi)3.0  (0.7) 2.3    (0.2) 0.1  (0.1)    
Non-GAAP$297.5  $(79.9) $217.6  26.9% $267.3  $(99.0) $168.3  37.0% 29.3%
                  
GAAP net income per diluted share    $1.20        $0.83     
Non-GAAP net income per diluted share    $1.42        $1.08     
Shares used in computing GAAP and Non-GAAP net income per diluted share    153.7        156.2     

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) Income tax on non-GAAP adjustments includes excess tax benefits associated with equity-based compensation. Additionally, 2018 includes the impact of global intangible low tax income (“GILTI”) on equity-based compensation and amortization of intangibles.

(iii) Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.

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

(v) Comprised of an adjustment to the provisional amounts recorded to finalize the US federal impact of revaluing deferred tax assets and liabilities and mandatory repatriation tax due to the completion of the 2017 US federal tax return.

(vi) Includes other expenses such as payroll taxes on equity-based compensation.


CDW CORPORATION AND SUBSIDIARIES
NON-GAAP INCOME BEFORE INCOME TAXES, NON-GAAP NET INCOME
AND NON-GAAP NET INCOME PER DILUTED SHARE
(dollars in millions, except per share amounts)
(unaudited)

 Nine Months Ended September 30,  
 2018 2017(i)  
 Income
before
Income
Taxes
 Income
Tax
Expense(ii)
 Net
Income
 Effective
Tax Rate
 Income
before
Income
Taxes
 Income
Tax
Expense(ii)
 Net
Income
 Effective
Tax Rate
 Net
Income
%
Change
                  
GAAP, as reported$633.9  $(150.2) $483.7  23.7% $476.7  $(148.4) $328.3  31.1% 47.3%
Amortization of intangibles(iii)138.6  (36.0) 102.6    138.9  (49.1) 89.8     
Equity-based compensation29.9  (23.8) 6.1    33.6  (42.6) (9.0)    
Net loss on extinguishments of long-term debt        57.4  (20.7) 36.7     
Integration expenses(iv)        2.5  (0.9) 1.6     
Reinstatement of prior year unclaimed property balances(v)        4.1  (1.5) 2.6     
Tax Cuts and Jobs Act(vi)  (2.0) (2.0)            
Other adjustments(vii)4.2  (1.0) 3.2    4.8  (1.6) 3.2     
Non-GAAP$806.6  $(213.0) $593.6  26.4% $718.0  $(264.8) $453.2  36.9% 31.0%
                  
GAAP net income per diluted share    $3.14        $2.06     
Non-GAAP net income per diluted share    $3.85        $2.85     
Shares used in computing GAAP and Non-GAAP net income per diluted share    154.1        159.2     

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) Income tax on non-GAAP adjustments includes excess tax benefits associated with equity-based compensation. Additionally, 2018 includes the impact of GILTI on equity-based compensation and amortization of intangibles.

(iii) Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.

(iv) Comprised of expenses related to CDW UK.

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

(vi) Comprised of an adjustment to the provisional amounts recorded to finalize the US federal impact of revaluing deferred tax assets and liabilities and mandatory repatriation tax due to the completion of the 2017 US federal tax return.

(vii) Includes other expenses such as payroll taxes on equity-based compensation.


CDW CORPORATION AND SUBSIDIARIES
ADJUSTED EBITDA AND ADJUSTED EBITDA MARGIN
(dollars in millions)
(unaudited)

 Three Months Ended September 30, Nine Months Ended September 30,
 2018 % of
Net s
ales
 2017(i) % of
Net
sales
 2018 % of
Net
sales
 2017(i) % of
Net
sales
Net income$183.7    $129.3    $483.7    $328.3   
Depreciation and amortization65.8    65.7    198.7    195.2   
Income tax expense54.7    77.6    150.2    148.4   
Interest expense, net36.6    37.8    111.5    113.4   
EBITDA340.8  7.8% 310.4  7.9% 944.1  7.8% 785.3  7.1%
Adjustments:               
Equity-based compensation10.8    10.0    29.9    33.6   
Net loss on extinguishments of long-term debt            57.4   
Integration expenses(ii)            2.5   
Reinstatement of prior year unclaimed property balances(iii)    4.1        4.1   
Other adjustments(iv)3.1    0.1    5.2    6.3   
Total adjustments13.9    14.2    35.1    103.9   
Adjusted EBITDA$354.7  8.1% $324.6  8.3% $979.2  8.0% $889.2  8.0%

(i) Amounts for 2017 have been recast to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) Comprised of expenses related to CDW UK.

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

(iv) Includes other expenses such as payroll taxes on equity-based compensation and our share of net income from our equity investment during the three and nine months ended September 30, 2018 and 2017. Also includes historical retention costs during the three and nine months ended September 30, 2017.


CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED NET SALES GROWTH ON A CONSTANT CURRENCY BASIS
(dollars in millions)
(unaudited)

  Three Months Ended September 30,
 Nine Months Ended September 30,
  2018  2017(i)
 %
Change(ii)
 2018  2017(i)  %
Change(ii)
Consolidated Net sales, as reported $4,373.2  $3,933.2  11.2% $12,165.7  $11,080.8  9.8%
Foreign currency translation(iii)   (7.0)     47.3   
Consolidated Net Sales on a Constant Currency Basis $4,373.2  $3,926.2  11.4% $12,165.7  $11,128.1  9.3%

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) There were 63 selling days for both the three months ended September 30, 2018 and 2017. There were 191 selling days for both the nine months ended September 30, 2018 and 2017.

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


CDW CORPORATION AND SUBSIDIARIES
CONDENSED CONSOLIDATED BALANCE SHEETS
(in millions)

 September 30, 2018 December 31, 2017(i) September 30, 2017(i)
Assets(unaudited)
   (unaudited)
      
Current assets:     
Cash and cash equivalents$255.1  $144.2  $97.9 
Accounts receivable, net of allowance for doubtful
accounts of $8.0, $6.2, and $6.2, respectively.
2,650.5  2,329.3  2,311.9 
Merchandise inventory481.1  411.5  512.4 
Miscellaneous receivables370.4  343.0  383.1 
Prepaid expenses and other192.4  168.3  191.6 
Total current assets3,949.5  3,396.3  3,496.9 
      
Property and equipment, net147.8  161.1  162.5 
Goodwill2,469.5  2,479.6  2,477.6 
Other intangible assets, net758.2  897.0  937.1 
Other assets50.4  32.7  32.1 
Total assets$7,375.4  $6,966.7  $7,106.2 
      
Liabilities and Stockholders’ Equity     
      
Current liabilities:     
Accounts payable - trade$1,609.9  $1,317.7  $1,224.6 
Accounts payable - inventory financing407.6  498.0  541.3 
Current maturities of long-term debt32.0  25.5  41.5 
Contract liabilities188.5  158.8  189.5 
Accrued expenses and other liabilities565.9  522.1  563.1 
Total current liabilities2,803.9  2,522.1  2,560.0 
      
Long-term liabilities:     
Debt3,187.4  3,210.0  3,388.4 
Deferred income taxes158.4  196.3  315.9 
Other liabilities65.0  52.7  32.3 
Total long-term liabilities3,410.8  3,459.0  3,736.6 
      
Total stockholders’ equity1,160.7  985.6  809.6 
Total liabilities and stockholders’ equity$7,375.4  $6,966.7  $7,106.2 

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).


CDW CORPORATION AND SUBSIDIARIES
NET SALES DETAIL
(dollars in millions)
(unaudited)

  Three Months Ended September 30,
  2018 2017(i) % Change(ii)
       
Corporate $1,706.5  $1,552.8  9.9%
       
Small Business 340.0  305.4  11.3 
       
Public      
Government 639.3  591.9  8.0 
Education 793.1  691.3  14.7 
Healthcare 442.7  410.7  7.8 
Total Public 1,875.1  1,693.9  10.7 
       
Other 451.6  381.1  18.5 
       
Total Net Sales $4,373.2  $3,933.2  11.2%

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) There were 63 selling days for both the three months ended September 30, 2018 and 2017.

  Nine Months Ended September 30,
  2018 2017(i) % Change(ii)
       
Corporate $5,006.1  $4,573.5  9.5%
       
Small Business 997.1  912.4  9.3 
       
Public      
Government 1,551.3  1,490.0  4.1 
Education 1,902.4  1,789.3  6.3 
Healthcare 1,286.8  1,201.1  7.1 
Total Public 4,740.5  4,480.4  5.8 
       
Other 1,422.0  1,114.5  27.6 
       
Total Net Sales $12,165.7  $11,080.8  9.8%

(i) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(ii) There were 191 selling days for both the nine months ended September 30, 2018 and 2017.


CDW CORPORATION AND SUBSIDIARIES
DEBT AND WORKING CAPITAL INFORMATION
(dollars in millions)
(unaudited)

 September 30, 2018 December 31, 2017 September 30, 2017
Debt and Revolver Availability     
Cash and cash equivalents$255.1  $144.2  $97.9 
Total debt3,219.4  3,235.5  3,429.9 
Senior secured debt1,526.1  1,540.3  1,735.4 
Outstanding borrowings under Revolver(i)6.5    192.1 
Borrowing base under ABL Revolver(ii)2,039.1  1,608.2  1,871.9 
Revolver availability(i)1,129.7  1,063.2  844.5 
Cash plus Revolver availability(i)1,384.8  1,207.4  942.4 
Total net leverage ratio(iii)2.3  2.6  2.9 
      
      
Working Capital(iv)     
Days of sales outstanding (DSO)(v)55  53  54 
Days of supply in inventory (DIO)(v)12  13  13 
Days of purchases outstanding (DPO)(v)(49) (47) (48)
Cash conversion cycle(v)18  19  19 

(i) Amount in effect at period-end, including CDW UK's Revolving Credit Facility, which is a multi-currency revolving credit facility with an aggregate amount of £45 million ($59 million at September 30, 2018) in availability.

(ii) Amount in effect at period-end, applicable to the Company's ABL Revolving Credit Facility.

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

(iv) Amounts for 2017 have been adjusted to reflect the full retrospective adoption of ASU No. 2014-09, Revenue from Contracts with Customers (Topic 606).

(v) Based on a rolling three-month average.


CDW CORPORATION AND SUBSIDIARIES
CASH FLOW INFORMATION
(in millions)
(unaudited)

 Nine Months Ended September 30,
 2018 2017
    
Cash flows provided by operating activities$602.3  $439.1 
    
Capital expenditures(53.4) (58.6)
Cash flows used in investing activities(53.4) (58.6)
    
Net change in accounts payable - inventory financing(90.1) (41.4)
Other cash flows used in financing activities(345.2) (506.2)
Cash flows used in financing activities(435.3) (547.6)
    
Effect of exchange rate changes on cash and cash equivalents(2.7) 1.3 
Net increase (decrease) in cash and cash equivalents110.9  (165.8)
Cash and cash equivalents - beginning of period144.2  263.7 
Cash and cash equivalents - end of period$255.1  $97.9 
    
Supplementary disclosure of cash flow information:   
Interest paid$(117.4) $(118.6)
Taxes paid, net$(200.5) $(169.6)

Tags