INSIGHT ENTERPRISES, INC. NSIT Cash Flow

Insight enterprises, inc. (NSIT)

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 earnings
159,407	163,677	90,683	84,690	75,851	75,684	71,021	92,763	100,235	75,485	33,574
Net earnings from continuing operations
-	-	-	-	-	-	-	-	-	-	30,773
Plus: net earnings from a discontinued operation
-	-	-	-	-	-	-	-	-	-	2,801
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization of property and equipment
46,209	37,458	42,599	27,493	26,649	29,243	41,544	41,177	39,139	38,013	41,163
Amortization of intangible assets
-	-	-	10,637	11,308	11,327	-	-	-	-	-
Non-cash real estate impairment
-	-	-	-	800	4,558	-	-	-	-	-
Provision for losses on accounts receivable
5,079	4,776	5,245	2,452	6,761	4,409	4,696	4,195	4,267	1,626	7,377
Write-downs of inventories
-	-	-	2,934	3,997	2,630	3,719	3,089	6,830	6,825	7,444
Write-off of property and equipment
-	-	-	0	535	741	606	596	1,390	-	-
Non-cash stock-based compensation
16,011	15,355	12,826	11,058	8,922	7,750	6,430	8,548	7,919	6,957	7,764
Gain on bargain purchase
-	-	-	-	-	-	-	2,022	-	-	-
Non-cash gain from arbitrated claim, net of tax
-	-	-	-	-	-	-	-	-	-	2,801
Excess tax benefit from employee gains on stock-based compensation
-	-	-	-	-	568	909	1,966	1,809	1,073	-
Deferred income taxes
7,418	9,126	19,139	10,517	5,174	3,794	3,445	8,978	4,552	18,057	8,214
Other adjustments
11,546	3,929	6,840	-	-	-	-	-	-	-	-
Gain on related party sale of property and equipment
-	-	-	-	-	895	-	-	-	-	-
Gain on sale of real estate
-	-	-	338	-	-	-	-	-	-	-
Changes in assets and liabilities:
Decrease in accounts receivable
118,971	46,883	208,065	168,966	47,206	107,969	-111,545	141,182	78,883	153,905	-10,981
Increase in inventories
-11,944	-46,534	14,046	50,712	9,214	35,714	7,391	-27,477	8,247	39,232	-1,813
Decrease (increase) in other assets
129,745	-12,424	-3,342	50,181	26,714	3,578	29,915	5,816	-25,895	16,884	-1,461
(Increase) decrease in other assets
-	-	-	-	-	-	-	-9,207	12,107	-3,794	-2,743
Increase (decrease) in accounts payable
-612	29,844	-237,457	193,582	113,594	121,506	-130,657	56,442	45,205	157,556	-15,207
(Decrease) increase in deferred revenue
-	-	-	10,633	2,927	8,303	1,197	-11,196	-17,926	15,284	16,806
(Decrease) increase in accrued expenses and other liabilities
119,590	16,407	-28,172	12,278	7,718	-10,902	735	-22,848	-735	-14,322	1,342
Net cash provided by operating activities
127,876	292,647	-307,066	96,077	181,102	110,319	76,066	67,442	115,725	98,181	122,674
Cash flows from investing activities:
Proceeds from sale of foreign entity
-	479	1,517	-	-	-	-	-	-	-	-
Proceeds from sale of assets held for sale
-	-	-	-	-	2,472	-	-	-	-	-
Payment of additional purchase price consideration for Calence
-	-	-	-	-	-	-	-	-	5,123	-
Purchases of property and equipment
69,086	17,251	19,230	12,266	13,416	9,983	19,024	30,152	27,093	17,972	14,707
Acquisitions, net of cash and cash equivalents acquired
664,287	74,938	186,932	10,297	44,221	-	-	3,831	13,769	-	21,713
Proceeds from sale of real estate
-	-	-	1,378	-	-	-	-	-	-	-
Net cash provided by (used in) investing activities
-733,373	-91,710	-204,645	-21,185	-57,637	-7,511	-19,024	-33,983	-40,862	-23,095	-36,420
Cash flows from financing activities:
Borrowings on senior revolving credit facility
242,936	569,232	1,151,216	772,218	686,410	484,992	835,328	803,953	1,314,500	1,150,136	1,043,373
Repayments on senior revolving credit facility
242,936	686,732	1,033,716	772,218	686,410	501,492	851,828	885,953	1,289,500	1,207,136	1,124,373
Borrowings on accounts receivable securitization financing facility
2,364,500	3,357,000	3,961,389	2,802,000	1,897,100	1,050,070	875,000	581,000	90,000	65,000	165,000
Repayments on accounts receivable securitization financing facility
2,558,500	3,188,000	3,975,889	2,851,500	1,869,100	1,039,070	872,000	534,000	90,000	65,000	165,000
Borrowings under Term Loan A
-	-	175,000	-	-	-	-	-	-	-	-
Repayments under Term Loan A
-	166,250	8,750	-	-	-	-	-	-	-	-
Borrowings under other financing agreements
-	-	-	-	-	2,002	-	-	-	-	-
Repayments under other financing agreements
-	-	-	1,309	543	150	-	-	-	-	-
Payments on finance lease obligations
-	-	-	445	223	217	671	1,017	997	927	324
Net repayments under inventory financing facilities
-50,454	-15,338	141,037	48,603	-16,454	7,529	-1,581	22,900	-41,179	40,830	13,378
Proceeds from issuance of convertible senior notes
341,250	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of warrants
34,440	-	-	-	-	-	-	-	-	-	-
Purchase of note hedge related to convertible senior notes
66,325	-	-	-	-	-	-	-	-	-	-
Payment of debt issuance costs
-	-	-	3,360	-	351	-	2,777	-	490	1,632
Proceeds from sales of common stock under employee stock plans
-	-	-	-	-	-	-	2,641	37	49	-
Excess tax benefit from employee gains on stock-based compensation
-	-	-	-	-	568	909	1,966	1,809	1,073	-
Payment of payroll taxes on stock-based compensation through shares withheld
-	-	-	2,219	2,265	2,028	3,094	3,288	2,697	1,429	691
Repurchases of common stock
27,899	22,069	-	50,000	91,843	50,383	57,774	-	50,000	-	-
Other payments
-9,396	-6,871	-13,166	-	-	-	-	-	-	-	-
Net cash used in financing activities
577,587	-159,028	397,121	-58,230	-83,328	-48,530	-75,711	-14,575	-68,027	-17,894	-70,269
Foreign currency exchange effect on cash, cash equivalents and restricted cash balances
-86	-5,061	16,089	-1,937	-16,683	-16,571	-6,633	4,899	-2,263	-1,495	2,906
Decrease in cash, cash equivalents and restricted cash
-27,996	36,848	-98,501	14,725	23,454	37,707	-25,302	23,783	4,573	55,697	18,891
Supplemental disclosures of cash flow information:
Cash paid during the year for interest
-	-	-	-	-	-	-	-	3,706	4,516	5,207
Cash paid during the year for income taxes, net of refunds
-	-	-	-	-	-	-	-	28,960	11,584	4,101
ABL Facility [Member]
Borrowings on senior revolving credit facility
1,680,515	-	-	-	-	-	-	-	-	-	-
Repayments on senior revolving credit facility
1,130,544	-	-	-	-	-	-	-	-	-	-