ALEXION PHARMACEUTICALS, INC. ALXN Cash Flow

Alexion pharmaceuticals, inc. (ALXN)

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	Dec'10	Sep'10	Jun'10	Mar'10
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent
2,374,000	2,404,300	1,470,300	1,333,600	416,400	77,600	152,600	-100,300	522,300	443,300	506,700	522,700	477,500	399,400	372,619	94,862	145,077	144,400	231,201	592,689	588,969	657,000	484,588	400,642	330,032	252,895	352,858	351,253	291,626	254,822	222,021	195,411	193,898	175,315	153,595	115,898	102,926	97,030	0	0	0
Adjustments to reconcile net income to net cash flows from operating activities:
Depreciation and amortization
368,900	376,800	384,600	397,000	401,000	405,300	492,000	497,500	498,600	496,700	413,000	402,600	399,000	396,400	388,737	338,459	253,022	166,600	91,468	51,099	48,310	47,000	36,849	34,721	31,695	28,693	26,513	25,482	24,278	23,887	22,027	20,329	19,174	17,616	17,130	16,665	16,267	15,792	0	0	0
Impairment of intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	12,000	36,985	36,985	36,985	33,521	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Change in fair value of contingent consideration
46,100	11,600	12,800	36,500	35,100	116,500	120,100	70,300	90,200	41,000	36,500	73,800	54,200	35,700	49,493	38,177	37,221	64,200	55,453	34,072	32,017	20,000	8,309	2,579	1,757	4,006	8,168	5,053	5,853	6,550	4,616	5,394	4,172	1,400	0	0	0	-	-	-	0
Payments on facility lease obligation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0
Share-based compensation expense
237,900	237,000	228,900	215,400	208,400	203,000	221,700	233,400	240,700	243,100	213,600	202,200	189,000	192,300	217,247	222,303	241,303	227,100	194,233	171,543	132,957	114,000	100,414	93,645	83,188	76,203	70,100	62,519	57,550	54,013	50,659	47,904	46,750	44,763	42,031	39,149	35,565	32,338	0	0	0
Premium amortization of available-for-sale securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-14,770	-11,373	-7,410	-3,235	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Deferred taxes (benefit)
-325,300	-455,400	-182,300	-119,400	-137,000	32,900	90,500	44,100	44,000	-45,900	-49,000	54,800	74,200	104,300	105,585	470,065	449,323	395,500	392,371	-45,140	-120,512	-154,000	-84,661	-45,579	8,700	92,831	30,517	93,945	73,858	71,155	84,571	26,085	55,119	42,066	24,390	42,665	40,120	36,389	0	0	0
Unrealized foreign currency loss
-3,100	2,100	0	0	0	-	-	-	-	9,400	0	0	0	-	-	-	0	-	-	0	0	-	-	-	-	-	0	0	0	-	3,304	-9,403	-7,111	-5,516	-4,604	12,857	6,638	523	0	0	0
Unrealized (gain) loss on forward contracts
37,000	16,500	21,200	7,600	6,600	15,800	6,900	-22,200	3,200	-11,100	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	2,767	949	-2,843	-479	-380	-1,043	-2,305	-6,205	0	0	0
Unrealized Gain (Loss) on Investments
-16,100	26,900	-39,700	-51,700	-26,500	40,200	100,500	100,500	100,500	0	0	0	0	-	-	-	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in excess tax benefit from stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-89,700	-111,616	7,216	173,114	251,000	296,207	302,944	214,789	105,714	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Marketable securities premium amortization
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Loss on disposal of property, plant and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Other
-13,400	2,700	1,300	17,500	9,700	2,000	2,000	-14,300	-8,200	-5,400	-11,900	-5,800	-8,000	-6,500	-3,737	-1,806	3,477	-2,900	-36,245	-42,785	-43,780	-37,000	-781	-2,326	-2,612	-2,040	4,674	4,827	4,825	4,833	0	0	0	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities, excluding the effect of acquisitions:
Accounts receivable
344,800	319,200	210,500	268,200	261,400	208,800	218,000	145,800	94,600	55,200	26,700	103,500	88,400	122,100	154,848	71,816	93,882	115,800	96,221	127,805	86,981	28,000	40,738	70,440	90,144	116,439	106,003	86,331	78,918	72,870	91,745	84,727	72,402	78,778	69,412	70,866	68,365	59,239	0	0	0
Inventories
108,400	156,900	147,300	34,600	29,800	14,700	-7,600	59,200	65,100	88,200	80,900	77,900	99,000	83,800	153,032	132,122	95,026	88,400	48,151	27,306	43,474	67,000	21,099	20,455	15,305	-126	7,790	11,366	1,988	6,265	4,783	11,969	11,546	12,179	10,764	9,843	11,743	14,119	0	0	0
Prepaid expenses, right of use operating assets and other assets
45,300	31,000	112,700	226,700	181,500	155,600	127,800	103,100	157,300	137,200	72,000	99,300	45,100	97,500	97,185	97,131	83,220	57,200	91,774	48,254	90,613	18,000	42,491	67,854	19,768	39,879	3,605	14,039	8,891	17,041	17,076	8,391	14,615	21,040	20,268	14,884	12,931	2,773	0	0	0
Accounts payable, accrued expenses, lease liabilities and other liabilities
170,700	230,700	319,300	99,100	10,400	-55,100	-139,800	-59,100	17,200	110,100	156,400	211,400	228,000	166,800	124,208	-111,139	-144,241	-115,900	-48,653	175,941	312,021	265,000	309,116	316,407	222,664	242,355	108,790	-3,693	30,807	68,951	85,238	119,737	71,489	79,781	77,044	78,023	57,273	47,455	0	0	0
Deferred revenue
-	-	-	-	-	-	-	-	-	-	-	-	-	-	13,657	-37,417	-26,327	-37,900	-48,000	19,768	47,540	6,000	44,631	39,873	29,763	23,476	20,422	6,627	11,805	13,172	20,874	13,216	6,516	15,033	9,939	10,546	8,089	1,315	0	0	0
Net cash provided by operating activities
2,204,600	2,084,900	1,651,200	1,438,800	556,600	426,000	600,700	483,100	1,107,000	1,115,600	1,240,800	1,261,300	1,220,200	1,086,300	893,858	826,944	826,166	675,200	767,726	826,161	694,089	640,000	565,497	428,251	419,797	497,349	393,425	390,474	394,305	410,613	396,443	331,371	308,528	270,084	230,306	196,997	163,775	160,906	0	0	0
Cash flows from investing activities:
Purchases of available-for-sale debt securities
99,600	80,200	62,500	211,000	439,900	782,700	840,200	1,133,400	1,291,600	1,648,800	1,591,100	1,300,300	1,159,100	667,100	803,163	827,284	561,381	519,700	584,695	573,282	684,754	664,000	1,079,756	1,141,241	1,193,994	1,048,429	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from maturity or sale of available-for-sale debt securities
271,000	222,200	328,100	558,000	1,411,100	1,473,500	1,514,000	1,587,200	963,400	1,089,900	1,165,100	981,300	730,300	717,800	551,532	422,675	1,252,244	1,159,500	1,314,897	1,374,879	697,006	620,000	431,037	334,861	160,167	60,917	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of mutual funds related to nonqualified deferred compensation plan
18,700	17,600	16,500	15,500	12,700	12,100	10,800	12,700	11,700	9,900	10,600	9,200	8,900	8,500	8,751	15,231	15,764	15,000	12,837	5,004	4,017	3,000	2,924	2,750	2,204	985	0	0	0	-	-	-	-	-	-	-	-	129,860	0	0	0
Proceeds from sale of mutual funds related to nonqualified deferred compensation plan
14,300	14,700	14,400	15,400	13,200	12,300	11,200	11,400	9,500	7,700	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	128,332	122,237	83,137	53,387	0	0	0
Purchases of property, plant and equipment
130,900	154,700	167,100	166,400	182,400	213,000	259,100	311,200	349,500	357,300	375,500	377,200	343,100	332,700	306,076	287,129	293,225	286,300	259,345	205,982	176,342	137,000	92,580	76,506	41,569	29,329	28,217	27,840	23,573	21,846	20,998	20,164	23,526	21,982	19,156	17,176	12,748	12,843	0	0	0
Payment for acquisition of business, net of cash acquired
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	605,735	605,735	605,735	605,910	105,886	0	0	0	-	-	-	0
Payments to Acquire Other Investments
64,000	73,300	74,000	54,100	54,100	10,300	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	38,000	25,000	25,000	25,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of intangible assets
8,000	16,000	16,000	8,000	8,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
300	100	800	-400	-900	-2,800	-3,600	-2,500	-2,200	-100	0	0	0	-	-	-	-	-5,400	-5,186	-384	119	1,000	9,817	9,082	9,169	9,315	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Increase in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0	-	-	-	0
Net cash (used in) provided by investing activities
-759,200	9,700	5,600	118,800	728,100	470,500	418,700	143,800	-677,700	-918,300	-804,300	-700,100	-776,900	-287,600	-563,617	-692,811	-3,542,777	-3,585,200	-3,480,893	-3,361,273	-181,226	-223,000	-778,961	-919,718	-1,111,769	-1,027,141	-421,460	-211,368	-23,957	-627,585	-619,334	-605,503	-569,949	-33,717	-44,356	-107,368	-160,007	-89,318	0	0	0
Cash flows from financing activities:
Proceeds from term loan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	240,000	240,000	240,000	240,000	0	0	0	0	-	-	-	-
Payments on term loan
130,600	98,000	65,400	32,700	250,000	293,800	337,500	381,300	175,000	175,000	331,300	287,500	243,800	375,000	218,700	218,700	264,200	101,200	69,000	81,000	47,500	55,000	55,500	55,500	55,500	36,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,184	6,184	6,184	6,109	0	0	0	0	-	-	-	-
Proceeds from revolving credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	115,000	115,000	115,000	115,000	60,000	0	0	0	-	-	-	-
Payments on revolving credit facility
0	250,000	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in excess tax benefit from stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-89,700	-111,616	7,216	173,114	251,000	296,207	302,944	214,789	105,714	95,478	62,994	28,560	7,228	9,292	4,035	3,717	4,016	3,699	2,790	1,956	1,970	0	0	0
Repurchases of common stock
511,800	416,000	383,500	48,900	11,300	85,000	250,100	309,700	480,500	463,600	329,100	338,500	201,700	430,600	552,317	575,137	564,674	327,700	195,235	208,048	340,969	303,000	283,148	178,515	53,086	66,136	77,689	77,689	46,660	11,553	0	0	0	-	-	-	-	-	-	-	-
Net proceeds from issuance of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0	-	-	0	0
Net proceeds from issuance of common stock under share-based compensation arrangements
22,500	29,900	29,100	43,200	48,100	47,300	51,300	49,900	48,000	85,900	85,100	77,700	80,400	37,100	59,176	70,316	61,118	82,000	87,144	93,503	108,478	114,000	104,401	99,885	92,158	71,281	56,088	59,789	60,143	66,438	0	0	0	-	-	-	-	-	-	-	-
Other
-5,000	-5,000	-14,100	-18,600	-18,100	-20,900	-11,000	-5,700	-10,900	-10,900	0	0	0	-	-	-8,187	-12,497	-8,800	-1,599	-532	-261	0	-206	-202	-202	-220	-260	-577	-734	-765	0	0	0	-	-	-	-	-	-	-	-
Net cash used in financing activities
-624,900	-739,100	-676,300	-299,400	-231,300	-102,400	-330,900	-437,400	-651,400	-596,600	-655,400	-620,900	-432,900	-836,200	-733,287	-857,315	2,508,026	2,985,100	3,136,149	3,261,783	-107,138	7,000	61,754	165,612	195,159	71,639	34,617	-46,535	297,446	666,376	691,735	736,832	333,780	39,050	42,047	42,445	98,023	38,867	0	0	0
Effect of exchange rate changes on cash and cash equivalents and restricted cash
-11,000	800	-6,700	-4,400	-18,900	-11,200	-9,400	-400	20,800	17,700	6,900	3,400	-7,400	-6,600	1,864	-842	1,870	-9,000	-12,007	-16,735	-17,338	-10,000	-6,537	1,436	2,138	-1,491	-1,697	-2,317	-4,222	-768	-1,472	-4,358	-2,401	-1,697	201	3,690	1,577	-482	0	0	0
Net change in cash and cash equivalents and restricted cash
809,500	1,356,300	973,800	1,253,800	1,034,500	782,900	679,100	189,100	-201,300	-381,600	-212,000	-56,300	3,000	-44,100	-401,182	-724,024	-206,715	66,100	410,975	709,936	388,387	414,000	-158,247	-324,419	-494,675	-459,644	4,885	130,254	663,572	448,636	467,372	458,342	69,958	273,720	228,198	135,764	103,368	109,973	0	0	0
Supplemental cash flow disclosures from investing and financing activities:
Contingent consideration issued in acquisitions
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Fair value of strategic investment and purchase option
47,900	75,000	27,600	27,400	27,100	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating ROU lease assets obtained in exchange for operating lease liabilities
0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock issued in acquisition of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0	-	-	-	-
Contingent consideration issued in acquisitions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	117,000	117,000	117,000	117,000	16,720	0	0	0	-	-	-	-
Capitalization of construction costs related to facility lease obligations
-	-	-	-	-	44,800	56,500	105,100	97,400	121,800	127,700	103,000	116,500	103,100	85,815	71,935	59,187	41,000	60,386	66,781	76,626	75,000	74,778	52,660	38,417	32,230	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable and accrued expenses for purchases of property, plant and equipment and intangible assets
15,500	13,300	14,300	19,900	100	21,400	12,300	15,100	36,300	34,700	33,100	32,900	29,000	23,500	27,935	34,801	43,664	30,100	27,872	38,299	28,436	17,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-