CDW CORP CDW Cash Flow

Cdw corp (CDW)

CashFlow / Yearly

Dec'19	Dec'18	Dec'17	Dec'16	Dec'15	Dec'14	Dec'13	Dec'12	Dec'11	Dec'10	Dec'09
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent
736,800	643,000	523,100	425,100	403,100	244,900	132,800	119,000	17,100	-29,200	-373,400
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
267,100	265,600	260,900	254,500	227,400	207,900	208,200	210,200	204,900	209,400	218,200
Equity-based compensation expense
48,500	40,700	43,700	39,200	31,200	16,400	46,600	22,100	19,500	11,500	15,900
Deferred income taxes
87,900	56,100	172,700	97,200	54,500	89,100	-48,700	-56,300	-10,200	-4,300	-94,400
Goodwill impairment
-	-	-	-	-	-	-	-	-	-	241,800
Provision for credit losses
-	-	-	-	-	-	-	0	400	-1,300	-200
Amortization of deferred financing fees, debt premium and debt discount, net
-	-	-	-	6,400	6,400	8,800	13,600	15,700	18,000	16,200
Gain (Loss) on Extinguishment of Debt
-	-	-	-2,100	-24,300	-90,700	-64,000	-17,200	-118,900	2,000	0
Loss from equity investments
-	-	-	-	-11,200	1,200	0	0	-	-	-
Gain on remeasurement of equity investment
-	-	-	-	98,100	0	0	-	-	-	-
Mark-to-market gain on interest rate cap agreements
-	-	-	-	-2,100	-400	-	-	-	-	-
Other
29,000	10,900	62,400	4,300	300	400	1,700	1,000	600	600	0
Realized loss on interest rate swap agreements
-	-	-	-	-	-	-	-	-2,800	-51,500	-103,200
Mark to market loss on interest rate derivatives
-	-	-	-	-	-	-	-	-4,200	-4,700	0
Net loss (gain) on sale and disposals of assets
-	-	-	-	-	-	-	-	-300	-700	1,700
Changes in assets and liabilities:
Accounts receivable
244,800	365,100	136,800	178,900	342,600	117,600	170,800	10,400	183,400	81,500	131,300
Merchandise inventory
153,000	46,800	-16,900	68,000	31,500	-44,200	67,500	-7,100	29,000	34,900	15,000
Other assets
10,900	-25,200	117,800	51,800	71,200	18,700	10,100	3,800	-50,300	61,900	-3,200
Accounts payable-trade
194,100	271,200	231,500	225,100	100,500	43,700	146,100	800	-19,800	269,300	76,500
Other liabilities
248,300	117,300	66,500	49,600	47,500	1,700	64,100	-2,100	39,600	77,800	3,900
Long-term liabilities
-	-	-	-	21,400	4,900	-8,900	-1,000	-16,000	-3,500	44,700
Net cash provided by operating activities
1,027,200	905,900	777,700	604,000	277,500	435,000	366,300	317,400	214,700	423,700	107,600
Cash flows used in investing activities:
Capital expenditures
236,300	86,100	81,100	63,500	90,100	55,000	47,100	41,400	45,700	41,500	15,600
Payment for equity investment
-	-	-	-	-	86,800	0	0	-	-	-
Payment of accrued charitable contribution related to the MPK Coworker Incentive Plan II
-	-	-	-	-	20,900	0	0	-	-	-
Cash settlements on interest rate swap agreements
-	-	-	-	-	-	-	-	6,600	78,200	72,200
Premium payments on interest rate cap agreements
-	-	-	2,400	500	2,100	0	300	3,700	5,900	0
Acquisition of business, net of cash acquired
95,100	0	-	-	263,800	0	0	-	-	-	-
Purchases of marketable securities
-	-	-	-	-	-	-	-	-	-	20,000
Redemptions of marketable securities
-	-	-	-	-	-	-	-	-	-	20,000
Proceeds from sale of assets and other
-	-	-	-	-	-	-	-	-	200	5,200
Net cash used in investing activities
-331,400	-86,100	-81,100	-65,900	-354,400	-164,800	-47,100	-41,700	-56,000	-125,400	-82,600
Cash flows used in financing activities:
Proceeds from borrowings under revolving credit facility
2,445,500	686,700	1,560,700	338,800	314,500	0	63,000	289,000	1,295,000	770,800	0
Repayments of borrowings under revolving credit facility
2,394,500	686,700	1,560,700	338,800	314,500	0	63,000	289,000	1,483,200	1,074,100	0
Repayments of Secured Debt
23,500	21,600	14,900	20,600	32,800	15,400	51,100	201,000	132,000	16,500	-
Proceeds from issuance of long-term debt
600,000	0	2,083,000	1,483,000	525,000	1,175,000	1,535,200	135,700	1,175,000	500,000	0
Payments to extinguish long-term debt
539,000	0	2,121,300	1,490,400	525,300	1,299,000	2,047,400	243,200	1,175,000	518,600	11,000
Net change in other long-term obligation
-	-	-	-	0	0	-	-	-	-	-
Payments of debt financing fees
-	-	-	-	6,800	21,900	6,100	2,100	26,300	14,300	11,300
Investment from CDW Holdings LLC
-	-	-	-	-	-	-	2,800	1,000	0	100
Net change in accounts payable-inventory financing
-1,300	-67,400	-84,000	143,600	95,900	75,500	7,400	-29,500	250,500	3,200	-9,100
Effective portion of interest rate cap agreements
-	-	-	-	0	-	-	-	-	-	-
Net proceeds from issuance of common shares
-	-	-	-	-	-	424,700	0	0	-	-
Proceeds from stock option exercises
-	-	-	-	2,400	1,300	0	0	-	-	-
Proceeds from Coworker Stock Purchase Plan
-	-	-	-	8,700	5,800	0	0	-	-	-
Repurchases of common stock
657,200	522,300	534,000	367,400	241,300	0	200	700	400	0	0
Payment of incentive compensation plan withholding taxes
21,400	33,900	49,600	0	600	-	24,100	0	0	-	-
Dividend payments
183,400	139,400	106,900	78,700	52,900	33,600	7,300	0	0	-	-
Excess tax benefits from equity-based compensation
-	-	-	-	-	300	600	0	0	-	-
Other
25,000	29,800	9,000	25,900	0	0	-	-	-	-	-
Principal payments under capital lease obligations
-	-	-	-	-	-	-	-	-	600	600
Net cash used in financing activities
-749,800	-754,800	-818,700	-304,600	-226,500	-112,000	-168,300	-338,000	-95,400	-350,100	-31,900
Effect of exchange rate changes on cash, cash equivalents and restricted cash
2,200	-3,400	2,600	-7,400	-3,500	-1,800	-700	300	0	400	500
Net increase in cash, cash equivalents and restricted cash
-51,800	61,600	-119,500	226,100	-306,900	156,400	150,200	-62,000	63,300	-51,400	-6,400
Supplementary disclosure of cash flow information:
Interest paid
154,200	148,800	148,500	144,300	154,600	195,800	267,600	302,700	332,900	377,000	368,800
Taxes paid, net
272,200	261,200	275,700	329,200	300,200	241,200	82,500	123,200	-20,900	48,000	11,700
Investment in equity method investee
-	-	-	-	-	-	-	-	-	-	1,900
Capital expenditures accrued in accounts payable-trade
-	-	-	-	-	-	-	500	1,100	0	0