ALLSCRIPTS HEALTHCARE SOLUTIONS, INC. MDRX Cash Flow

Allscripts healthcare solutions, inc. (MDRX)

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 loss
-20,354	-18,970	-5,725	-149,930	-7,977	385,896	-23,846	74,272	-28,515	14,863	-17,462	-143,011	-8,565	2,882	157	-2,136	2,127	16,377	-5,133	-3,216	-10,084	-2,178	-25,763	-17,770	-20,742	-20,618	-48,940	-22,876	-11,592	-24,322	9,375	7,981	5,813	25,983	19,137	15,876	12,613	-24,142	-	-	18,577
Less: Loss from discontinued operations
-	-	-	-	-	420,491	-11,705	-10,294	-3,354	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Loss) income from continuing operations
-	-	-	-	-	-34,595	-12,141	84,566	-25,161	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization
52,092	54,856	51,647	50,477	50,126	49,330	47,824	47,244	47,948	2,220	53,811	51,603	49,694	15,855	43,897	42,124	34,452	36,525	40,998	41,827	41,661	42,717	42,819	43,600	45,127	47,018	46,832	42,968	41,997	39,652	37,697	37,669	35,216	35,164	33,524	32,846	30,866	40,973	-	-	9,116
Operating right-of-use asset amortization
5,631	5,812	5,715	5,687	5,320	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation expense
9,954	9,419	7,773	10,132	11,658	8,771	8,713	7,197	9,957	8,400	9,679	10,515	7,946	7,376	9,660	10,138	9,919	7,438	8,908	9,197	9,120	7,051	10,055	12,078	10,070	8,416	10,484	10,106	8,004	12,663	8,807	9,929	7,727	11,597	9,934	10,474	8,747	14,979	-	-	3,937
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	10	765	197	298	13	331	2	-2,246	28	1,086	1,132	591	803	839	1,654	2,907	508	0	101	4,130	-2,363	2,875	4,176	811	-	-	-1,268
Provision for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,001	-	1,789	1,861	2,722
Deferred taxes
2,160	34,904	1,560	1,512	-6	1,947	3,578	-8,946	-723	4,904	665	3,089	1,570	322	2,638	1,198	362	4,529	-3,382	110	949	6,052	839	-2,437	-4,398	12,343	2,898	14,559	14,080	13,731	6,101	-3,714	-3,338	-8,183	-10,425	-11,892	-2,895	-5,969	-	-	9,794
Asset impairment charges
0	6,800	248	3,691	98	28,091	0	30,075	0	-	-	-	-	0	0	0	4,650	1,203	22	293	26	256	188	1,751	195	950	7,371	2,814	319	-	-	-	-	-	-	-	-	-	-	-	-
Recovery of long-term investments
0	1,696	0	-45	-1,000	-13	0	10,000	5,500	0	20,700	144,590	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Equity in net (loss) income of unconsolidated investments
-	-	-	-	-	-	-177	767	-61	-	449	-28	285	0	0	-4,898	-2,603	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of businesses, net
-	-	-	-	-	0	0	173,129	-871	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in fair value of 1.25% call option and cash conversion option
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Other loss (income), net
-287	-6,581	-804	-1,756	-236	8,519	-79	-43	941	806	-1,417	-1,054	-1,240	-1,469	-1,094	-507	-456	2,902	-1,238	-85	-965	-339	-858	-893	-1,463	-4,058	-497	-5,418	8,575	-1,612	335	-1,044	-86	-828	-454	-4,262	2,031	-622	-	-	146
Changes in operating assets and liabilities (net of businesses acquired):
Accounts receivable and contract assets, net
-5,660	67,159	-11,630	-9,949	-32,307	110,662	12,462	19,085	-33,075	63,933	18,209	21,057	-8,010	-3,805	316	157	12,250	3,845	4,127	-5,943	-5,244	-7,643	-1,090	-4,801	28,178	18,671	-16,871	-5,000	10,905	-54,072	7,948	-6,847	6,993	-23,575	14,677	34,440	5,189	-25,370	-	-	24,467
Inventories
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,173	619	-1,242	-	-340	-604	397
Prepaid expenses and other assets
-19,669	15,989	-17,306	20,349	-3,658	43,393	2,464	3,460	6,501	-20,158	-2,292	4,767	4,464	-1,073	-458	-4,738	1,815	-5,884	-5,687	-8,003	1,960	-9,142	5,085	13,458	-2,363	-1,849	3,624	8,874	12,832	11,332	-5,478	-886	9,462	-2,319	2,468	8,590	8,812	8,157	-	-	3,365
Accounts payable
-23,967	228	11,286	8,903	7,382	-37,405	-937	14,476	4,707	-22,693	5,738	-5,699	2,869	19,183	10,590	-1,246	16,997	-9,903	-1,569	-12,298	11,817	-15,595	9,822	4,718	-889	15,087	-12,396	-632	21,735	-4,327	-8,230	585	15,412	900	-7,208	50	-2,288	-21,313	-	-	10,900
Accrued expenses
10,022	-4,043	-1,391	151,688	-4,847	27,848	7,454	-8,488	13,670	16,327	-1,009	380	-5,567	6,069	-134	-3,544	-5,165	-5,185	-2,861	437	-15,365	-647	-9,619	1,754	-14,255	4,429	3,349	-4,714	-7,616	21,313	-14,259	-1,054	-2,603	-913	-1,815	8,602	2,707	10,051	-	-	326
Accrued compensation and benefits
-736	10,955	3,858	-7,759	-39,525	13,266	-4,200	22,984	-18,610	12,787	8,032	3,399	-5,501	2,419	-1,529	13,525	-24,929	14,929	7,058	-594	-11,136	-4,648	2,312	-181	-27,027	21,169	11,384	80	849	14,729	2,041	-331	-3,338	2,178	-6,916	-4,271	-5,757	-1,713	-	-	2,161
Deferred revenue
724	44,286	-61,297	-60,235	-17,107	105,275	-23,983	-9,388	-13,894	94,023	-6,262	-23,764	48,687	-42,005	-7,036	-11,770	49,393	23,132	-12,828	-19,172	29,240	12,377	-12,009	-21,507	54,248	-24,742	-13,436	1,143	35,462	-30,970	-6,102	-8,089	28,570	4,737	-2,687	26,147	29,409	851	-	-	24,437
Other liabilities
2,933	-7,045	1,969	-4,050	1,380	13,850	-699	-3,970	2,910	5,075	6,211	7,680	-997	2,193	-1,134	1,052	54	907	-1,258	215	-47	-1,556	-72	-1,044	-4,353	-7,396	-3,115	-3,605	-1,746	1,670	92	-335	929	-1,196	939	-1,038	605	-77	-	-	229
Operating leases
-6,174	-6,453	-6,023	-6,020	-5,854	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued DOJ settlement
-57,289	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) provided by operating activities - discontinued operations
0	0	0	0	-30,000	-37,568	11,231	1,001	3,993	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) provided by operating activities
-3,708	12,310	35,854	-7,726	35,816	-13,663	15,014	8,232	54,315	106,232	63,824	33,882	75,477	83,846	53,059	56,166	75,933	83,266	39,504	30,279	58,530	51,493	13,729	16,986	21,288	17,676	12,515	11,430	39,366	58,122	31,108	58,846	74,594	107,429	42,178	52,253	66,894	20,397	-	-	55,384
Cash flows from investing activities:
Capital expenditures
2,845	3,125	4,046	4,582	4,847	9,385	7,902	6,514	7,508	-1,457	15,181	10,511	14,524	7,061	8,414	8,880	7,752	4,111	4,596	3,500	6,115	5,782	3,385	5,326	11,945	17,142	11,338	29,215	16,435	24,685	16,749	19,309	19,423	11,005	12,123	32,962	-11,784	30,188	-	-	-5,636
Capitalized software
28,556	27,646	30,968	26,622	28,600	30,215	25,754	31,171	26,168	11,162	35,497	37,571	34,011	22,185	32,888	21,972	15,134	16,568	11,012	12,369	9,315	12,343	10,269	8,905	9,144	11,564	10,946	11,645	7,871	3,625	12,404	13,668	13,268	107,277	-16,206	-14,002	-16,321	42,192	-	-	-5,256
Sales and maturities of marketable securities and other investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,458	0	1,305	11	10	10	19	-	-	328	12,516	-	-	-	-	12	11	12	20	1,549	-	-	49
Cash paid for business acquisitions, net of cash acquired
-	-	-	-	-	0	0	70,021	107,212	115,515	50,333	0	3,975	-835,443	29,740	905,540	0	0	0	9,372	0	-	-	-	-	0	0	73	148,802	0	0	0	0	-	-	-	-	-	-	-	-
Purchases of equity securities, other investments and related intangible assets, net
3,028	0	6,032	1,191	-32	14,211	0	2,723	0	-	-	-	-	500	0	20,185	500	3,132	2,567	209,337	750	0	7,470	8,106	5,968	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other proceeds from investing activities
0	0	-5	-4	-5	0	-8	-9	-37	0	-215	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of marketable securities and other investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	8,700	4,200	5	-	-	4
Proceeds received from sale of fixed assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	26	11	-	0	8	7	-1	24	7	55	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-2,225	-2,216	-	-	0
Sales and maturities of other investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	43	26	15	-	-	-	-	-	-	-	-
Net cash used in investing activities - discontinued operations
-	-	-	-	-	-31,466	-173,507	-7,087	-8,961	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-34,429	-30,771	-52,766	-44,109	-33,410	702,355	-228,851	145,342	-140,851	-206,161	-104,896	-49,405	-52,510	-103,038	-71,042	-956,551	-23,375	-23,811	-15,717	-234,570	-14,868	-18,115	-41,270	-22,320	-26,983	-28,670	-22,273	-40,605	-160,592	-28,300	-29,110	-32,951	-32,676	-25,212	-28,318	-12,084	-30,060	123,266	-	-	-10,847
Cash flows from financing activities:
Proceeds from sale or issuance of common stock
-	-	-	-	-	0	1,071	0	212	1,568	0	0	0	0	79	0	5	1,540	659	101,392	40	-183	-13	10	1,673	191	1,992	1,333	7,931	1,477	180	1,847	2,015	7,638	7,504	3,080	16,897	-	-	-	-
Net proceeds from stock-based compensation activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	449	1,721	-679
Proceeds from employee stock purchase plan, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	589	447	386
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	42	10	765	197	298	13	331	2	-2,246	28	1,086	1,132	591	803	839	1,654	2,907	508	0	101	4,130	-2,363	2,875	4,176	811	-	-	-1,268
Taxes paid related to net share settlement of equity awards
3,174	524	67	1,368	5,327	703	153	114	8,496	492	223	690	5,864	825	16	3,217	4,146	1,348	181	3,326	2,207	1,509	329	5,378	3,184	1,848	1,224	5,012	1,648	5,940	731	1,323	2,298	9,277	2,179	0	0	-	-	-	-
Payments for issuance costs on 0.875% Convertible Senior Notes
758	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of lease obligations
-	-	-	-	-	-	135	-1	255	-	3,047	2,951	3,015	-3,488	2,220	1,399	239	287	174	69	68	118	114	113	110	42	116	118	182	187	204	199	232	353	356	352	366	533	-	-	297
Credit facility payments
80,000	205,000	5,000	5,000	5,000	463,750	35,000	215,001	0	22,858	4,342	24,213	86,726	74,663	29,145	23,198	28,164	48,599	148,629	20,658	20,625	23,125	10,625	32,813	30,313	35,312	2,814	543,853	27,614	17,615	29,214	179,523	24,522	9,928	45,491	25,490	89,515	56,880	-	-	23,995
Credit facility borrowings, net of issuance costs
210,000	30,000	69,241	60,000	120,000	105,000	50,000	130,000	145,843	135,303	69,698	40,000	80,000	-404,135	55,000	599,135	0	14,442	140,208	114,511	15,000	10,000	36,964	40,000	15,000	50,000	0	281,940	129,043	-25	-150	324,185	0	0	-169	0	47,362	547,744	-	-	0
Repurchase of common stock
9,714	9,300	37,090	0	65,070	37,023	0	44,306	57,599	0	0	12,077	0	50,159	19,007	14,558	37,517	0	0	0	0	-	-	-	-	-	-	-	-	0	0	225,414	547	1,411	0	50,051	0	-	-	-	-
Payment of acquisition and other financing obligations
2,911	3,212	10,000	1,418	55	1,972	0	0	3,226	-1,115	2,398	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of subsidiary shares owned by non-controlling interest
0	-264	0	0	54,064	253	0	6,945	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by financing activities - discontinued operations
-	-	-	-	-	-4,059	161,058	-3,801	-3,766	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided (used in) by financing activities
113,443	16,970	7,743	52,146	-9,516	-402,371	176,841	-140,166	76,479	152,939	61,182	69	-15,605	-859,858	4,702	891,133	-69,864	-33,954	-8,104	192,181	-7,858	-17,181	25,911	2,792	-15,802	13,280	-1,659	11,128	109,184	-19,383	-29,611	-80,427	-25,483	-9,201	-43,054	-69,938	-21,446	-177,139	-	-	-25,853
Effect of exchange rate changes on cash and cash equivalents
-713	306	-246	-20	163	-296	-37	-356	65	64	200	177	419	-749	-123	-209	549	-26	-822	167	-497	-369	-275	212	123	-122	223	-2,197	314	-155	912	-775	1,492	-41	-1,699	-6	655	785	-	-	0
Net increase (decrease) in cash and cash equivalents
74,593	-1,185	-9,415	291	-36,947	65,004	-20,985	-2,996	-18,726	53,074	20,310	-15,277	7,781	19,359	-13,404	-9,461	-16,757	25,475	14,861	-11,943	35,307	15,828	-1,905	-2,330	-21,374	2,164	-11,194	-20,244	-11,728	10,284	-26,701	-55,307	17,927	72,975	-30,893	-29,775	16,043	-32,691	-	-	18,684
Supplemental non-cash information:
Accretion of redemption preference on redeemable convertible non-controlling interest in Netsmart
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Obligations to enter into capital leases
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-