ALEXION PHARMACEUTICALS, INC. ALXN Cash Flow

Alexion pharmaceuticals, inc. (ALXN)

CashFlow / Quarterly

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	Dec'10	Sep'10	Jun'10	Mar'10
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent
557,600	889,000	467,600	459,800	587,900	-45,000	330,900	-457,400	249,100	30,000	78,000	165,200	170,100	93,400	94,000	120,000	92,000	66,619	-183,757	170,215	91,323	153,420	177,731	166,495	159,354	-18,992	93,785	95,885	82,217	80,971	92,180	36,258	45,413	48,170	65,570	34,745	26,830	26,450	27,873	21,773	20,934
Adjustments to reconcile net income to net cash flows from operating activities:
Depreciation and amortization
89,300	90,600	92,500	96,500	97,200	98,400	104,900	100,500	101,500	185,100	110,400	101,600	99,600	101,400	100,000	98,000	97,000	93,737	49,722	12,563	10,578	18,605	9,353	9,774	9,268	8,454	7,225	6,748	6,266	6,274	6,194	5,544	5,875	4,414	4,496	4,389	4,317	3,928	4,031	3,991	3,842
Impairment of intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8,536	0	0	3,464	33,521	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Change in fair value of contingent consideration
5,800	4,400	29,800	6,100	-28,700	5,600	53,500	4,700	52,700	9,200	3,700	24,600	3,500	4,700	41,000	5,000	-15,000	18,493	29,684	4,044	11,979	9,746	8,303	1,989	-38	-1,945	2,573	1,167	2,211	2,217	-542	1,967	2,908	283	236	745	136	-	-	-	0
Payments on facility lease obligation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	350	198	92	-	74	134	171
Share-based compensation expense
57,600	60,200	59,200	60,900	56,700	52,100	45,700	53,900	51,300	70,800	57,400	61,200	53,700	41,300	46,000	48,000	57,000	66,247	51,056	67,000	42,797	33,380	28,366	28,414	23,840	19,794	21,597	17,957	16,855	13,691	14,016	12,988	13,318	10,337	11,261	11,834	11,331	7,605	8,379	8,250	8,104
Premium amortization of available-for-sale securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-3,178	-	-3,951	-3,988	-4,175	-2,656	-554	-25	0	-	-	-	-	-	-	-	-	-	-	-	-
Deferred taxes (benefit)
49,000	-319,300	-95,300	40,300	-81,100	-46,200	-32,400	22,700	88,800	11,400	-78,800	22,600	-1,100	8,300	25,000	42,000	29,000	9,585	389,480	21,258	-24,823	6,456	-48,031	-54,114	-58,311	75,795	-8,949	165	25,820	13,481	54,479	-19,922	23,117	26,897	-4,007	9,112	10,064	9,221	14,268	6,567	6,333
Unrealized foreign currency loss
-7,100	-1,200	-800	6,000	-1,900	-	-	-	-	3,700	-3,900	-5,500	15,100	-	-	-	14,000	-	-	6,518	3,916	-	-	-	-	-	2,969	3,178	-2,721	-	4,490	-628	1,543	-2,101	-8,217	1,664	3,138	-1,189	9,244	-4,555	-2,977
Unrealized (gain) loss on forward contracts
15,000	1,200	26,600	-5,800	-5,500	5,900	13,000	-6,800	3,700	-3,000	-16,100	18,600	-10,600	-	-	-	-	-	-	-	-	-	-	-	-	-	1,010	-7,157	7,718	-	-3,972	5,310	-1,136	2,565	-5,790	1,518	1,228	2,664	-6,453	256	-2,672
Unrealized Gain (Loss) on Investments
-9,200	6,300	12,000	-25,200	33,800	-60,300	0	0	100,500	0	0	0	0	-	-	-	-17,000	-	-	-	434	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in excess tax benefit from stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-13,409	-87,054	-41,758	52,521	-35,325	31,778	124,140	130,407	9,882	38,515	35,985	21,332	-	-	-	-	-	-	-	-	-	-	-	-
Marketable securities premium amortization
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-91	-110	-	-161	-285	-312
Loss on disposal of property, plant and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-13	0	-63
Other
-13,700	400	0	-100	2,400	-1,000	16,200	-7,900	-5,300	-1,000	-100	-1,800	-2,500	-7,500	6,000	-4,000	-1,000	-4,737	7,931	1,283	-7,377	-38,082	1,391	288	-597	-1,863	-154	2	-25	4,851	-1	0	-17	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities, excluding the effect of acquisitions:
Accounts receivable
120,900	120,100	2,700	101,100	95,300	11,400	60,400	94,300	42,700	20,600	-11,800	43,100	3,300	-7,900	65,000	28,000	37,000	24,848	-18,032	50,066	58,918	5,269	13,552	9,242	-63	18,007	43,254	28,946	26,232	7,571	23,582	21,533	20,184	26,446	16,564	9,208	26,560	17,080	18,018	6,707	17,434
Inventories
-37,300	51,000	81,900	12,800	11,200	41,400	-30,800	8,000	-3,900	19,100	36,000	13,900	19,200	11,800	33,000	35,000	4,000	81,032	12,090	-2,096	-2,626	40,783	-8,755	14,072	20,900	-5,118	-9,399	8,922	5,469	2,798	-5,823	-456	9,746	1,316	1,363	-879	10,379	-99	442	1,021	12,755
Prepaid expenses, right of use operating assets and other assets
72,900	-11,200	-84,600	68,200	58,600	70,500	29,400	23,000	32,700	42,700	4,700	77,200	12,600	-22,500	32,000	23,000	65,000	-22,815	31,946	9,089	38,980	11,759	-11,574	51,448	-33,633	36,250	13,789	3,362	-13,522	-24	24,223	-1,786	-5,372	11	15,538	4,438	1,053	-761	10,154	2,485	-9,105
Accounts payable, accrued expenses, lease liabilities and other liabilities
-68,200	23,600	183,500	31,800	-8,200	112,200	-36,700	-56,900	-73,700	27,500	44,000	19,400	19,200	73,800	99,000	36,000	-42,000	31,208	-136,347	2,898	-13,659	98,455	88,247	138,978	-60,680	142,571	95,538	45,235	-40,989	9,006	-16,945	79,735	-2,845	25,293	17,554	31,487	5,447	22,556	18,533	10,737	-4,371
Deferred revenue
-	-	-	-	-	-	-	-	-	-	-	-	-	-	10,000	-25,000	58,000	-29,343	-41,074	-13,910	46,427	-39,443	26,694	13,862	4,887	-812	21,936	3,752	-1,400	-3,866	8,141	8,930	-33	3,836	483	2,230	8,484	-1,258	1,090	-227	1,710
Net cash provided by operating activities
549,600	517,100	599,500	538,400	429,900	83,400	387,100	-343,800	299,300	258,100	269,500	280,100	307,900	383,300	290,000	239,000	174,000	190,858	223,086	238,222	23,034	283,384	281,521	106,150	-31,055	208,881	144,275	97,696	46,497	104,957	141,324	101,527	62,805	90,787	76,252	78,684	24,361	51,009	42,943	45,462	21,492
Cash flows from investing activities:
Purchases of available-for-sale debt securities
19,400	29,000	10,100	41,100	0	11,300	158,600	270,000	342,800	68,800	451,800	428,200	700,000	11,100	161,000	287,000	208,000	147,163	185,121	21,097	166,319	212,158	173,708	132,569	145,565	627,914	235,193	185,322	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from maturity or sale of available-for-sale debt securities
141,400	11,200	71,700	46,700	92,600	117,100	301,600	899,800	155,000	157,600	374,800	276,000	281,500	232,800	191,000	25,000	269,000	66,532	62,143	854,569	176,256	221,929	122,125	176,696	99,250	32,966	25,949	2,002	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of mutual funds related to nonqualified deferred compensation plan
6,900	4,200	2,500	5,100	5,800	3,100	1,500	2,300	5,200	1,800	3,400	1,300	3,400	2,500	2,000	1,000	3,000	2,751	8,480	1,533	2,236	588	647	546	1,219	512	473	0	0	-	-	-	-	-	-	-	-	47,315	58,898	18,438	5,209
Proceeds from sale of mutual funds related to nonqualified deferred compensation plan
3,300	3,300	2,400	5,300	3,700	3,000	3,400	3,100	2,800	1,900	3,600	1,200	1,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	13,000	39,100	35,000	41,232	6,905	0	5,250
Purchases of property, plant and equipment
12,200	30,000	41,900	46,800	36,000	42,400	41,200	62,800	66,600	88,500	93,300	101,100	74,400	106,700	95,000	67,000	64,000	80,076	76,053	73,096	57,075	53,121	22,690	43,456	17,733	8,701	6,616	8,519	5,493	7,589	6,239	4,252	3,766	6,741	5,405	7,614	2,222	3,915	3,425	3,186	2,317
Payment for acquisition of business, net of cash acquired
837,700	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	306	605,429	0	0	481	105,405	-	-	-	0
Payments to Acquire Other Investments
34,500	9,600	19,900	0	43,800	10,300	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	13,000	0	0	25,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of intangible assets
0	0	8,000	0	8,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
0	100	200	0	-200	800	-1,000	-500	-2,100	0	100	-200	0	-	-	-	-	79	-4,069	-459	-951	293	733	44	-70	9,110	-2	131	76	-	-	-	-	-	-	-	-	-	-	-	-
Increase in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	1	2	-	3	10	338	-	-	-	0
Net cash (used in) provided by investing activities
-766,000	56,300	-8,500	-41,000	2,900	52,200	104,700	568,300	-254,700	400	-170,200	-253,200	-495,300	114,400	-66,000	-330,000	-6,000	-161,617	-195,194	-3,179,966	-48,423	-57,310	-75,574	81	-90,197	-613,271	-216,331	-191,970	-5,569	-7,590	-6,239	-4,559	-609,197	661	7,592	30,995	-72,965	-9,978	-55,420	-21,644	-2,276
Cash flows from financing activities:
Proceeds from term loan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	240,000	0	0	0	0	-	-	-	-
Payments on term loan
32,600	32,600	32,700	32,700	0	0	0	250,000	43,800	43,700	43,800	43,700	43,800	200,000	0	0	175,000	43,700	0	45,500	12,000	11,500	12,000	12,000	19,500	12,000	12,000	12,000	0	-	-	-	-	-	-	-	-	-	-	-	-
Debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	75	6,109	0	0	0	0	-	-	-	-
Proceeds from revolving credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	115,000	0	0	0	60,000	-	-	-	-
Payments on revolving credit facility
0	0	0	0	250,000	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in excess tax benefit from stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-13,409	-87,054	-41,758	52,521	-35,325	31,778	124,140	130,407	9,882	38,515	35,985	21,332	-354	6,031	1,551	0	1,710	774	1,233	299	1,393	-135	399	313
Repurchases of common stock
107,100	32,500	334,600	37,600	11,300	0	0	0	85,000	165,100	59,600	170,800	68,100	30,600	69,000	34,000	297,000	152,317	91,820	23,537	60,026	19,852	104,633	156,458	22,057	0	0	31,029	35,107	11,553	0	0	0	-	-	-	-	-	-	-	-
Net proceeds from issuance of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-9,685	9,685	-	-	3,209	10,594
Net proceeds from issuance of common stock under share-based compensation arrangements
2,800	6,700	2,700	10,300	10,200	5,900	16,800	15,200	9,400	9,900	15,400	13,300	47,300	9,100	8,000	16,000	4,000	31,176	19,140	6,802	24,882	36,320	25,499	21,777	30,404	26,721	20,983	14,050	9,527	11,528	24,684	14,404	15,822	-	-	-	-	-	-	-	-
Other
-1,300	-1,300	-1,300	-1,100	-1,300	-10,400	-5,800	-600	-4,100	-500	-500	-5,800	-4,100	-	-	4,000	-4,000	-7,082	-1,105	-310	-303	119	-38	-39	-42	-87	-34	-39	-60	-127	-351	-196	-91	-	-	-	-	-	-	-	-
Net cash used in financing activities
-138,200	-59,700	-365,900	-61,100	-252,400	3,100	11,000	7,000	-123,500	-225,400	-95,500	-207,000	-68,700	-284,200	-61,000	-19,000	-472,000	-181,287	-185,028	3,346,341	5,074	-30,238	-59,394	-22,580	119,212	24,516	44,464	6,967	-4,308	-12,506	-36,688	350,948	364,622	12,853	8,409	-52,104	69,892	15,850	8,807	3,474	10,736
Effect of exchange rate changes on cash and cash equivalents and restricted cash
-13,200	6,900	-6,800	2,100	-1,400	-600	-4,500	-12,400	6,300	1,200	4,500	8,800	3,200	-9,600	1,000	-2,000	4,000	-1,136	-1,706	712	-6,870	-4,143	-6,434	109	468	-680	1,539	811	-3,161	-886	919	-1,094	293	-1,590	-1,967	863	997	308	1,522	-1,250	-1,062
Net change in cash and cash equivalents and restricted cash
-367,800	520,600	218,300	438,400	179,000	138,100	498,300	219,100	-72,600	34,300	8,300	-171,300	-252,900	203,900	164,000	-112,000	-300,000	-153,182	-158,842	405,309	-27,185	191,693	140,119	83,760	-1,572	-380,554	-26,053	-86,496	33,459	83,975	99,316	446,822	-181,477	102,711	90,286	58,438	22,285	57,189	-2,148	26,042	28,890
Supplemental cash flow disclosures from investing and financing activities:
Contingent consideration issued in acquisitions
155,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Fair value of strategic investment and purchase option
0	47,400	200	300	27,100	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating ROU lease assets obtained in exchange for operating lease liabilities
3,700	-	3,200	20,700	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock issued in acquisition of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	718	-	0	3,012	0	-	-	-	-
Contingent consideration issued in acquisitions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	117,000	0	0	0	16,720	-	-	-	-
Capitalization of construction costs related to facility lease obligations
-	-	-	-	-	500	11,100	18,200	15,000	12,200	59,700	10,500	39,400	18,100	35,000	24,000	26,000	815	21,120	11,252	7,813	20,201	27,515	21,097	6,187	19,979	5,397	6,854	0	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable and accrued expenses for purchases of property, plant and equipment and intangible assets
13,000	10,200	-11,200	3,500	10,800	11,200	-5,600	-16,300	32,100	2,100	-2,800	4,900	30,500	500	-3,000	1,000	25,000	4,935	3,866	9,863	11,436	2,707	14,293	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-