Illumina, Inc. ILMN Cash Flow

Illumina, inc. (ILMN)

CashFlow / Quarterly

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Apr'18	Dec'17	Sep'17	Jun'17	Mar'17	Jan'17	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	Dec'10	Sep'10	Jun'10	Mar'10
Cash flows from operating activities:
Consolidated net income
173,000	239,000	234,000	293,000	224,000	197,000	188,000	200,000	197,000	57,000	153,000	120,000	348,000	107,000	117,000	116,000	88,000	103,474	115,621	102,247	136,658	153,280	93,489	46,605	59,977	80,661	31,357	35,877	-22,587	71,903	29,748	23,401	26,202	11,720	20,151	30,620	24,137	38,440	35,447	29,796	21,208
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense
37,000	38,000	37,000	39,000	37,000	40,000	35,000	35,000	30,000	29,000	29,000	26,000	26,000	25,000	23,000	21,000	21,000	20,226	18,570	17,450	16,754	17,122	14,798	15,392	14,593	13,729	13,363	11,959	11,759	12,685	12,087	11,518	11,959	15,272	14,314	13,160	12,829	9,593	8,807	8,413	7,391
Amortization of intangible assets
7,000	7,000	10,000	10,000	10,000	10,000	10,000	10,000	9,000	10,000	12,000	12,000	12,000	13,000	13,000	13,000	12,000	13,116	14,286	13,250	13,348	12,830	11,891	12,134	13,814	13,438	13,515	11,390	8,772	5,934	4,202	3,466	3,468	4,116	3,188	3,328	2,985	2,295	2,295	1,595	1,620
Share-based compensation expense
39,000	49,000	46,000	48,000	51,000	47,000	48,000	50,000	48,000	41,000	34,000	39,000	50,000	27,000	35,000	32,000	35,000	35,896	32,229	32,957	31,918	38,462	44,669	35,996	33,424	29,746	27,409	24,452	24,219	24,176	23,072	24,047	23,029	21,816	24,571	23,666	22,039	19,841	17,960	16,845	16,999
Accretion of debt discount
10,000	10,000	9,000	13,000	14,000	15,000	10,000	8,000	8,000	7,000	8,000	8,000	7,000	8,000	7,000	7,000	8,000	9,172	9,452	10,207	10,169	10,080	9,992	9,005	8,992	9,142	9,063	9,023	9,009	8,904	8,802	8,699	8,599	8,500	8,488	8,671	6,514	5,503	5,400	5,301	5,203
Loss on extinguishment of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-755	-9,679	-27,177	-	-	-	-
Contingent compensation expense
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,417	-	1,358	1,358	1,393	2,257	1,084	44	2,921	560	324	1,369	1,204	-	-	-	-
Incremental tax benefit related to share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,541	29,717	76,445	23,840	25,306	26,805	50,528	29,453	12,381	9,566	5,278	8,320	1,258	1,711	9,494	5,967	7,067	23,320	10,000	27,894	6,551	3,500	4,500
Deferred income taxes
29,000	-24,000	19,000	-17,000	11,000	-14,000	10,000	11,000	11,000	-28,000	13,000	20,000	-86,000	-36,000	-30,000	-34,000	6,000	2,679	-3,098	-27,129	-53,452	-130,274	-1,084	-2,431	33,943	95,306	-29,810	7,871	-36,704	14,741	-8,687	-22,429	-5,323	13,018	2,088	-2,515	6,636	29,852	10,804	3,388	4,652
Marketable Securities, Unrealized Gain (Loss)
3,000	-4,000	-47,000	102,000	2,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deconsolidation, Gain (Loss), Amount
-	0	0	39,000	15,000	-	-	-	-	0	0	0	453,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on derivative assets related to terminated acquisition
-95,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Impairment of intangible assets
-	-	-	-	-	-	-	-	-	0	0	0	23,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in fair value of contingent consideration
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,109	2,329	-9,887	-2,398	333	-1,531	-1,760	-7,753	-5,769	-5,726	464	262	4,530	-1,080	-1,737	-7,476	2,598	648	-270	-	-	-	-
Cost-method investment gain, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	518	2,900	0	12,582	-	-	-	-	55,244	0	0	6,113	-	-	-	-	-	-	-	-	-	-	-	-
Other
2,000	-9,000	5,000	2,000	3,000	-4,000	-6,000	0	6,000	-3,000	-3,000	3,000	2,000	3,000	-2,000	-4,000	1,000	2,178	-2,574	-2,349	-1,255	-9,249	-4,189	-2,816	636	-10,280	-389	1,965	-4,107	2,631	466	-7	-3,341	-1,879	-3,233	-2,412	-2,425	-4,244	-3,131	-2,863	1,427
Changes in operating assets and liabilities:
Accounts receivable
-99,000	29,000	75,000	10,000	-56,000	81,000	36,000	-1,000	-11,000	27,000	13,000	2,000	-16,000	2,000	8,000	-26,000	13,000	-25,309	46,120	15,715	59,474	12,648	20,544	-34,967	52,156	3,424	24,458	-5,825	-6,129	-2,604	23,832	-15,945	29,158	4,467	-18,207	9,639	11,112	-4,908	18,914	-6,950	788
Inventory
24,000	-58,000	-3,000	10,000	26,000	13,000	12,000	11,000	17,000	6,000	18,000	10,000	-1,000	-12,000	1,000	24,000	17,000	37,402	11,072	18,482	14,044	-8,151	21,506	13,196	9,991	-6,615	-7,961	93	8,266	10,247	8,650	4,969	-159	-12,837	-4,791	-8,474	3,950	12,120	8,697	19,585	8,181
Prepaid expenses and other current assets
14,000	0	3,000	17,000	-6,000	2,000	-6,000	-3,000	2,000	6,000	-9,000	-3,000	-2,000	4,000	2,000	-8,000	3,000	6,018	3,600	225	1,157	-26,771	18,690	1,587	-125	-3,173	740	2,186	-1,536	1,660	3,253	-620	-1,231	-13,458	8,935	1,094	5,445	17	-479	-545	-1,547
Operating lease right-of-use assets and liabilities, net
1,000	-	-	-	1,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets
11,000	1,000	18,000	3,000	8,000	0	4,000	4,000	1,000	2,000	0	2,000	1,000	1,000	1,000	3,000	2,000	1,572	-2,918	816	2,530	30,994	-11,285	7,575	8,972	12,930	165	1,174	2,088	186	730	-139	2,126	894	-522	539	3,093	1,099	1,007	274	1,186
Accounts payable
-16,000	11,000	-3,000	4,000	-47,000	32,000	12,000	-1,000	2,000	-	-	-	-3,000	5,000	-15,000	5,000	3,000	-3,532	18,814	1,851	28,867	-16,854	864	3,824	10,060	13,265	-8,878	-10,457	8,459	-3,322	5,400	2,775	10,259	-6,200	-4,928	-9,339	-630	5,651	1,116	9,089	7,294
Accrued liabilities
-103,000	37,000	6,000	-17,000	-70,000	58,000	28,000	35,000	-18,000	25,000	15,000	-11,000	52,000	33,000	-26,000	-1,000	-30,000	75,116	48,321	26,607	-51,044	19,734	31,739	32,006	-23,147	26,618	31,306	-4,107	-15,267	-2,943	1,036	12,072	14,223	-2,449	7,885	15,826	17,683	740	8,890	17,337	5,061
Other long-term liabilities
24,000	-19,000	-2,000	5,000	-17,000	0	11,000	-20,000	5,000	137,000	4,000	15,000	4,000	6,000	2,000	4,000	4,000	10,220	-6,765	24	1,521	-1,947	1,560	1,163	1,085	1,773	335	334	1,374	7,747	-5,707	187	4,413	4,876	1,934	2,199	-951	451	235	688	-1,487
Accrued legal contingencies
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,817	5,847	-	4,299	15,791	106,922	-	-	-	0	-	-	-	-	-	-	-	-
Unrealized (gain) loss on foreign exchange
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-3,119	1,090	140	-	4,054	-1,678	-2,805
Net cash provided by operating activities
281,000	443,000	267,000	143,000	198,000	300,000	292,000	295,000	255,000	294,000	235,000	178,000	168,000	262,000	176,000	242,000	99,000	366,782	180,994	171,445	66,779	140,549	145,605	178,030	37,087	126,839	83,136	88,606	87,840	78,876	51,228	96,329	65,440	108,300	90,042	71,220	88,578	81,481	54,828	77,199	59,065
Cash flows from investing activities:
Maturities of available-for-sale securities
107,000	125,000	58,000	173,000	1,031,000	150,000	154,000	141,000	415,000	140,000	85,000	48,000	48,000	-8,000	35,000	37,000	76,000	104,071	94,317	53,048	42,564	32,000	25,586	48,568	44,075	55,784	19,089	102,991	111,333	272,033	28,200	78,546	21,600	367,714	41,595	21,296	61,839	-	-	-	-
Purchases of available-for-sale securities
256,000	250,000	367,000	276,000	117,000	507,000	1,215,000	539,000	598,000	383,000	273,000	25,000	61,000	216,000	376,000	218,000	85,000	83,138	135,437	253,042	325,383	362,552	69,826	105,619	253,255	185,489	21,013	60,019	97,480	123,125	240,112	230,589	331,652	233,595	269,689	446,328	360,657	182,778	350,413	198,978	114,039
Sales of available-for-sale securities
186,000	101,000	142,000	268,000	118,000	77,000	188,000	44,000	288,000	8,000	175,000	99,000	40,000	137,000	71,000	296,000	39,000	246,649	71,904	111,291	152,156	67,101	33,290	202,234	89,030	11,118	11,479	222,857	278,181	-168,208	306,942	170,871	188,766	-146,930	322,052	176,192	217,133	-	-	-	-
Deconsolidation of Helix cash
-	-	-	-	-	-	-	-	-	-	0	0	52,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the deconsolidation of GRAIL
-	0	0	0	15,000	-	-	-	-	0	0	0	278,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid for derivative assets related to terminated acquisition
132,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of strategic investment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-
Purchases of property and equipment
40,000	57,000	49,000	47,000	56,000	65,000	64,000	77,000	90,000	76,000	82,000	69,000	83,000	82,000	57,000	68,000	53,000	35,639	29,459	41,351	36,551	34,832	28,828	23,324	19,012	27,310	18,930	11,534	21,441	17,101	17,650	20,946	13,084	27,114	22,183	16,203	12,300	12,384	13,112	13,142	11,180
Net purchases of strategic investments
-	5,000	2,000	10,000	3,000	3,000	3,000	6,000	3,000	4,000	0	18,000	7,000	5,000	3,000	3,000	3,000	1,900	5,026	12,141	-13,067	5,000	-4,927	7,082	4,600	-89,609	-399	4,426	-9,998	-55,911	0	7,530	7,500	2,385	4,676	6,233	475	5,227	4,800	1,499	16,151
Sales and maturities of available-for-sale securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	302,094	129,328	126,706
Net cash paid for acquisitions
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	18,000	-	-	-	-	-	-	-	-	86,023	92,317	50	345,111	-	-	-	0	0	0	0	58,302	1	23,141	65,069	10,000
Cash paid for intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	29,500	6,095	0	625	8,499	2	2,342	501	-	-	-	0	650	-2	988	114	-	-	-	-
Net cash (used in) provided by investing activities
-135,000	-104,000	-218,000	79,000	988,000	-348,000	-940,000	-537,000	12,000	-315,000	-97,000	35,000	163,000	-174,000	-341,000	44,000	-44,000	228,544	-38,927	-142,470	-154,147	-332,783	-44,231	114,777	-144,387	-150,810	-101,295	247,477	-65,021	18,611	-17,105	-9,648	-141,870	-42,960	67,101	-272,264	-152,876	-70,057	-93,872	-96,460	-24,664
Cash flows from financing activities:
Payments on financing obligations
-	0	0	549,000	1,000	1,000	1,000	0	2,000	2,000	1,000	5,000	1,000	-5,000	-1,000	-4,000	76,000	28,793	207,543	8,550	114	111	133	93	29,654	131	1,581	9,082	58	-	-	-	0	-	-	-	-	-	-	-	-
Proceeds from issuance of convertible notes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	117,492	786,000	-	-	-	-
Repurchase of convertible notes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8,965	87,774	253,135	-	-	-	-
Incremental tax benefit related to share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,541	29,717	76,445	23,840	25,306	26,805	50,528	29,453	12,381	9,566	5,278	8,320	1,258	1,711	9,494	5,967	7,067	23,320	10,000	27,894	6,551	3,500	4,500
Payments for Repurchase of Common Stock
188,000	63,000	198,000	0	63,000	-	-	-	-	75,000	75,000	0	101,000	-	-	-	-	201,744	37,503	0	34,753	34,752	0	72,414	130,017	0	0	25,009	25,011	30,013	20,010	32,499	0	0	204,080	28,006	338,320	-	-	-	-
Taxes paid related to net share settlement of equity awards
35,000	52,000	4,000	3,000	23,000	56,000	3,000	2,000	13,000	40,000	4,000	2,000	22,000	24,000	3,000	4,000	69,000	31,843	5,175	6,143	83,839	370	259	583	8,826	-	-	-	2,468	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the exercise of warrants
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	5,512	6,442	0	5,941	3,646
Proceeds from issuance of common stock
32,000	0	29,000	3,000	27,000	1,000	23,000	1,000	21,000	8,000	32,000	9,000	22,000	0	20,000	4,000	23,000	6,332	23,155	12,786	29,727	11,595	30,581	22,107	32,045	14,234	39,147	27,841	13,238	15,651	10,687	3,898	24,122	-3,631	23,660	26,485	15,424	20,218	21,863	33,775	26,160
Contributions from noncontrolling interest owners
-	-	-	-	-	0	0	31,000	61,000	0	43,000	20,000	16,000	9,000	0	0	80,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on acquisition related contingent consideration liability
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	29,000	-	-	-	-	-	-	-	-	0	0	0	3,985	0	0	3,374	0	-	-	-	-	-	-	-	-
Net cash used in financing activities
-191,000	-115,000	-173,000	-549,000	-60,000	-154,000	651,000	30,000	67,000	-109,000	-5,000	24,000	-86,000	-145,000	9,000	-89,000	-71,000	-379,379	-180,897	27,810	-12,534	202	55,495	-136,521	-85,924	43,556	-75,053	5,784	-13,006	-6,042	-8,065	-30,264	33,616	7,848	-187,830	51,517	225,481	26,544	12,408	43,216	34,306
Effect of exchange rate changes on cash and cash equivalents
-6,000	-	-	-	-	0	-1,000	-4,000	1,000	1,000	2,000	1,000	1,000	-3,000	-1,000	0	2,000	1,678	-698	735	-2,715	-1,709	-2,195	422	100	216	1,437	-1,338	-712	-553	619	-199	30	-56	-551	270	211	428	0	7	-115
Net (decrease) increase in cash and cash equivalents
-51,000	227,000	-128,000	-327,000	1,126,000	-202,000	2,000	-216,000	335,000	-129,000	135,000	238,000	246,000	-60,000	-157,000	197,000	-14,000	217,625	-39,528	57,520	-102,617	-193,741	154,674	156,708	-193,124	19,801	-91,775	340,529	9,101	90,892	26,677	56,218	-42,784	73,132	-31,238	-149,257	161,394	38,180	-26,420	23,962	68,592