CDW CORP CDW Cash Flow

Cdw corp (CDW)

CashFlow / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent
751,800	736,800	710,500	692,500	668,900	643,000	678,500	624,100	591,900	523,100	432,200	428,800	405,500	425,100	410,500	435,500	426,200	403,100	365,600	270,300	248,700	244,900	253,100	195,300	155,400	132,800	106,100	146,300	136,400	119,000	104,700	103,800	32,200	17,100	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
294,200	267,100	264,400	262,000	263,300	265,600	264,400	264,300	263,300	260,900	259,000	256,300	254,700	254,500	253,100	250,000	238,900	227,400	217,000	209,000	208,400	207,900	207,800	207,900	208,200	208,200	207,400	208,800	209,700	210,200	210,400	208,200	205,800	204,900	0	0	0
Equity-based compensation expense
44,600	48,500	48,500	46,500	45,300	40,700	40,000	39,200	39,700	43,700	44,700	44,700	42,700	39,200	39,300	37,100	35,100	31,200	24,900	21,000	17,800	16,400	13,800	50,200	48,000	46,600	48,400	14,600	18,300	22,100	25,200	22,900	21,200	19,500	0	0	0
Deferred income taxes
71,600	87,900	50,400	50,500	56,400	56,100	156,700	160,500	167,000	172,700	77,600	87,600	91,300	97,200	97,300	149,600	102,100	54,500	188,300	88,300	88,600	89,100	-94,600	-69,600	-56,700	-48,700	-29,500	-47,800	-53,800	-56,300	-49,700	-24,700	-18,700	-10,200	0	0	0
Provision for credit losses
0	-	-	-	0	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	800	400	0	0	0
Amortization of deferred financing fees, debt premium and debt discount, net
-	-	-	-	-	-	-	-	-	-	-	-	8,100	-	6,100	6,600	6,500	6,400	6,300	6,300	6,300	6,400	6,500	6,700	7,400	8,800	9,900	10,900	11,400	13,600	14,000	16,000	16,900	15,700	0	0	0
Gain (Loss) on Extinguishment of Debt
-	-	-	-	-	-	-	-	-	-	-57,400	-59,500	-59,500	-2,100	-2,100	0	0	-24,300	-61,200	-107,000	-109,600	-90,700	-62,300	-57,800	-65,500	-64,000	-63,300	-22,000	-11,700	-17,200	-9,400	-9,400	-125,100	-118,900	0	0	0
Gain (Loss) on Disposition of Property Plant Equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss from equity investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-11,200	-10,000	9,100	5,200	1,200	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Mark-to-market gain on interest rate cap agreements
-	-	-	-	-	-	-	-	-	-	-	-	3,100	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
28,100	29,000	27,400	12,200	12,100	10,900	67,200	64,300	61,400	62,400	0	0	0	-	-	-	-	300	0	0	0	-	-	-	0	-	-	-	-	1,000	5,900	3,900	2,300	600	0	0	0
Changes in assets and liabilities:
Accounts receivable
465,700	244,800	202,600	300,000	413,700	365,100	350,400	276,000	261,000	136,800	281,700	260,000	231,800	178,900	182,100	259,800	210,400	342,600	269,800	199,600	125,400	117,600	169,100	137,600	76,400	170,800	18,000	139,100	152,500	10,400	35,100	77,500	36,700	183,400	0	0	0
Merchandise inventory
85,200	153,000	125,800	76,400	108,600	46,800	-28,400	98,300	19,500	-16,900	87,000	21,500	35,800	68,000	41,300	31,600	80,000	31,500	-31,100	-12,900	-31,000	-44,200	70,000	71,100	30,100	67,500	7,000	57,000	11,800	-7,100	31,600	-27,100	38,200	29,000	0	0	0
Other assets
42,700	10,900	-9,100	22,200	22,100	-25,200	2,300	54,400	82,400	117,800	132,200	133,000	81,200	51,800	70,700	95,500	38,700	71,200	50,700	19,300	16,100	18,700	7,600	-37,600	16,200	10,100	32,800	25,700	1,100	3,800	-13,400	-20,600	-19,000	-50,300	0	0	0
Accounts payable-trade
235,500	194,100	234,600	299,300	417,000	271,200	391,900	306,500	212,100	231,500	223,800	317,600	123,700	225,100	16,000	167,900	198,500	100,500	154,600	49,200	15,200	43,700	106,400	38,700	43,400	146,100	-17,100	84,100	122,000	800	125,800	33,700	-34,800	-19,800	0	0	0
Other liabilities
280,100	248,300	70,200	124,700	129,800	117,300	37,300	82,000	46,900	66,500	73,800	52,200	90,300	49,600	162,000	105,700	76,800	47,500	-32,800	-7,300	-41,600	1,700	34,500	20,600	58,500	64,100	-2,200	6,500	15,800	-2,100	23,000	53,100	17,900	39,600	0	0	0
Long-term liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-27,800	-	-15,600	13,800	13,300	21,400	10,500	4,800	5,300	4,900	900	-3,400	-4,100	-8,900	-7,600	-3,900	-3,600	-1,000	-100	-5,900	-19,400	-16,000	0	0	0
Net cash provided by operating activities
997,800	1,027,200	985,900	988,100	936,100	905,900	940,900	733,800	630,000	777,700	543,800	667,100	546,100	604,000	481,900	491,500	527,500	277,500	379,400	358,200	366,500	435,000	346,000	335,100	404,600	366,300	321,100	219,800	302,400	317,400	410,300	389,600	296,100	214,700	0	0	0
Cash flows used in investing activities:
Capital expenditures
242,300	236,300	107,700	96,400	89,600	86,100	75,900	77,900	77,400	81,100	80,700	74,600	72,100	63,500	87,600	92,900	91,100	90,100	64,500	56,900	55,700	55,000	51,000	48,100	47,600	47,100	46,500	45,700	41,900	41,400	45,200	44,700	45,600	45,700	0	0	0
Payment of accrued charitable contribution related to the MPK Coworker Incentive Plan II
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20,900	20,900	20,900	20,900	0	0	0	0	-	-	-	-	-	-	-	-
Cash settlements on interest rate swap agreements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,600	0	0	0
Premium payments on interest rate cap agreements
-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	500	1,900	2,600	2,600	2,100	0	0	0	-	-	-	-	-	-	-	-	3,700	0	0	0
Acquisition of business, net of cash acquired
26,400	95,100	75,000	75,000	68,700	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-268,700	-331,400	-182,700	-171,400	-158,300	-86,100	-75,900	-77,900	-77,400	-81,100	-81,000	-77,000	-74,500	-65,900	-89,700	-356,700	-354,900	-354,400	-417,000	-146,300	-145,100	-164,800	-72,600	-69,000	-68,500	-47,100	-46,800	-46,000	-42,200	-41,700	-45,200	-45,200	-48,100	-56,000	0	0	0
Cash flows used in financing activities:
Proceeds from borrowings under revolving credit facility
3,138,000	2,445,500	1,858,300	1,089,600	605,200	686,700	970,500	1,981,100	1,686,600	1,560,700	1,285,800	301,100	319,500	338,800	541,600	419,900	377,900	314,500	0	0	0	-	-	-	-	-	-	-	-	289,000	561,000	796,000	1,136,000	1,295,000	0	0	0
Repayments of borrowings under revolving credit facility
3,001,500	2,394,500	1,839,300	1,027,300	529,200	686,700	1,155,100	2,021,400	1,724,600	1,560,700	1,094,200	247,100	281,500	338,800	541,600	419,900	377,900	314,500	0	0	0	-	-	-	-	-	-	-	-	289,000	566,100	956,100	1,312,800	1,483,200	0	0	0
Repayments of Secured Debt
-	-	-	-	-	21,600	21,900	14,900	14,900	14,900	14,800	14,700	17,600	20,600	23,700	38,500	35,600	32,800	29,900	15,400	15,400	15,400	15,500	15,400	15,000	51,100	47,200	43,400	40,000	201,000	201,000	201,000	201,000	132,000	0	0	0
Proceeds from issuance of long-term debt
-	-	-	-	-	-	-	-	-	2,083,000	2,083,000	3,566,000	3,566,000	1,483,000	1,483,000	0	0	525,000	1,100,000	1,700,000	1,700,000	1,175,000	0	0	0	-	-	-	-	135,700	135,700	135,700	1,310,700	1,175,000	0	0	0
Payments to extinguish long-term debt
-	-	-	-	-	-	-	-	-	2,121,300	2,121,300	3,611,700	3,611,700	1,490,400	1,490,400	0	0	525,300	1,100,400	1,700,500	1,744,800	1,299,000	885,400	818,600	2,073,800	2,047,400	1,992,200	1,458,900	159,400	243,200	136,900	136,900	1,311,900	1,175,000	0	0	0
Payments of debt financing fees
-	-	-	-	-	-	-	-	-	-	0	0	15,500	-	5,900	0	0	6,800	14,300	22,300	28,700	21,900	0	0	0	-	-	-	-	2,100	2,100	2,100	28,100	26,300	0	0	0
Net change in accounts payable-inventory financing
-152,900	-1,300	5,300	79,300	-22,100	-67,400	-132,700	-109,300	76,600	-84,000	63,000	-12,800	74,400	143,600	112,500	126,000	71,700	95,900	55,000	61,700	39,600	75,500	74,500	29,100	-2,700	7,400	-8,900	29,300	48,200	-29,500	10,200	135,100	121,800	250,500	0	0	0
Proceeds from stock option exercises
-	-	-	-	-	-	-	-	-	-	0	0	10,600	-	6,700	5,200	3,100	2,400	1,900	1,500	1,700	1,300	1,100	800	100	0	0	0	0	-	-	-	-	-	-	-	-
Proceeds from Coworker Stock Purchase Plan
-	-	-	-	-	-	-	-	-	-	0	0	9,500	-	9,100	9,000	8,900	8,700	8,600	8,000	7,500	5,800	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repurchases of common stock
620,900	657,200	783,100	678,100	590,200	522,300	232,500	351,000	467,800	534,000	546,400	503,700	424,800	367,400	403,000	372,700	359,300	241,300	0	0	0	-	-	-	-	200	0	0	0	-	-	-	-	-	-	-	0
Payment of incentive compensation plan withholding taxes
31,700	21,400	28,100	36,800	36,800	33,900	34,700	16,300	40,000	49,600	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividend payments
194,200	183,400	172,800	161,900	150,800	139,400	127,700	120,400	113,400	106,900	100,300	93,300	86,200	78,700	71,400	65,400	59,200	52,900	46,300	42,200	38,000	33,600	29,200	21,900	14,600	7,300	0	0	0	-	-	-	-	-	-	-	-
Excess tax benefits from equity-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	500	500	400	300	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other
26,100	25,000	32,900	37,100	38,000	29,800	34,800	24,500	6,700	9,000	21,500	26,100	26,200	25,900	-300	-800	-500	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in financing activities
-799,600	-749,800	-888,000	-721,800	-703,800	-754,800	-706,400	-630,200	-587,700	-818,700	-481,300	-638,600	-460,200	-304,600	-367,500	-336,100	-370,400	-226,500	-218,200	-100,400	-77,700	-112,000	-264,600	-218,700	-175,800	-168,300	-116,100	-152,200	-149,100	-338,000	-199,800	-229,800	-285,000	-95,400	0	0	0
Effect of exchange rate changes on cash, cash equivalents and restricted cash
-5,800	2,200	-3,400	-1,100	-4,300	-3,400	-1,400	-4,000	4,400	2,600	-1,900	-1,900	-7,900	-7,400	-3,900	-5,000	-1,400	-3,500	-4,500	-3,400	-3,000	-1,800	-1,200	900	-700	-700	-1,000	-1,000	-500	300	1,800	-500	-200	0	0	0	0
Net increase in cash, cash equivalents and restricted cash
-76,300	-51,800	-88,200	93,800	69,700	61,600	157,200	21,700	-30,700	-119,500	-20,400	-50,400	3,500	226,100	20,800	-206,300	-199,200	-306,900	-260,300	108,100	140,700	156,400	7,600	48,300	159,600	150,200	157,200	20,600	110,600	-62,000	167,100	114,100	-37,200	63,300	0	0	0
Supplementary disclosure of cash flow information:
Interest paid
138,700	154,200	156,200	150,300	150,200	148,800	147,300	146,200	142,800	148,500	145,500	148,100	148,600	144,300	146,600	146,300	145,600	154,600	194,000	177,300	232,800	195,800	225,300	224,700	267,500	267,600	306,600	294,000	302,600	302,700	301,900	306,100	321,500	332,900	0	0	0
Taxes paid, net
270,700	272,200	263,700	258,000	262,000	261,200	306,600	297,600	280,000	275,700	264,300	293,000	328,700	329,200	316,700	309,500	302,700	300,200	269,300	252,700	236,000	241,200	208,100	143,500	90,300	82,500	105,600	135,700	124,600	123,200	102,800	52,500	15,800	-20,900	0	0	0