CERNER CORPORATION CERN Cash Flow

Cerner corporation (CERN)

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 earnings
510,394	529,454	506,443	593,889	636,277	630,059	835,397	843,440	853,766	866,978	680,011	672,566	659,337	636,484	652,901	630,204	578,788	539,362	521,126	502,846	516,841	525,433	437,624	423,966	407,840	398,354	450,099	433,642	418,564	397,232	376,616	356,564	330,779	306,627	286,072	268,109	251,542	237,272	0	0	0
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization
693,941	687,966	678,402	666,432	656,670	642,591	629,230	614,479	598,482	580,723	558,092	539,029	519,943	504,236	494,535	482,808	470,906	452,225	414,216	374,060	332,704	302,353	291,290	283,112	274,291	263,538	249,704	238,597	229,132	222,580	218,051	216,101	215,205	212,556	209,307	204,556	198,673	193,337	0	0	0
Share-based compensation expense
118,812	103,641	94,496	89,168	90,348	95,423	98,150	92,799	90,454	83,019	76,857	75,941	74,225	74,536	73,691	73,624	72,771	70,121	69,288	65,474	60,804	59,292	55,975	53,441	49,350	46,295	43,459	40,653	38,376	36,113	33,860	31,371	29,306	27,919	27,036	26,048	25,517	23,723	0	0	0
Provision for deferred income taxes
57,576	51,125	40,809	47,846	41,473	34,428	27,154	23,296	33,148	47,409	51,072	-5,245	-8,281	-11,517	34,652	81,956	68,725	65,245	89,864	107,084	108,913	106,905	-20,508	-21,430	-21,584	-22,647	7,236	20,292	15,079	8,342	-10,680	-40,462	-33,422	-22,113	20,806	32,119	32,618	30,362	0	0	0
Investment gains
30,098	29,621	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Changes in assets and liabilities:
Receivables, net
-21,550	-58,113	-66,815	69,585	123,388	207,785	263,798	139,152	69,208	32,836	-15,479	42,147	57,765	-78,258	-59,695	-10,800	-13,238	160,124	214,344	189,810	171,205	74,786	87,442	63,802	56,699	9,599	11,322	76,002	18,740	83,705	56,252	61,979	128,918	128,979	118,284	65,763	44,497	17,370	0	0	0
Inventory
-631	-1,855	-1,576	7,822	9,824	9,307	9,069	793	-4,739	972	-4,015	-2,091	-3,520	666	-2,196	-9,982	3,177	-12,951	-9,767	-7,961	-11,890	-8,117	709	7,982	6,313	8,111	3,259	707	7,437	279	12,036	9,482	457	12,329	4,186	3,805	3,536	-188	0	0	0
Prepaid expenses and other
77,111	76,748	81,028	100,867	-17,348	-156,216	17,408	10,440	93,089	191,369	44,765	27,380	34,637	66,658	47,423	56,584	52,768	55,363	66,228	64,293	5,148	14,625	-22,114	-3,681	23,357	36,038	32,192	16,328	30,905	2,224	9,817	-7,261	-22,600	-9,974	-20,172	-9,602	-4,815	-35,378	0	0	0
Accounts payable
10,696	-8,734	40,094	46,818	46,703	65,202	41,373	16,677	36,476	6,960	-6,282	25,678	-12,045	-13,197	-11,927	-1,152	-29,353	7	-24,795	-577	38,805	2,974	43,576	-1,859	-14,218	4,130	-14,640	25,677	3,595	35,265	0	0	0	-	-	-	-	30,812	0	0	0
Accrued income taxes
-7,750	-4,599	-19,494	-37,337	-30,788	-27,849	7,224	30,123	24,785	18,358	12,664	47,071	53,640	64,073	106,066	73,092	71,111	55,269	-17,130	-21,567	-4,208	-21,764	19,060	-1,195	-12,425	14,694	7,795	17,700	12,327	-22,784	-15,592	-3,883	-6,645	26,053	-16,596	-30,057	-7,475	-42,651	0	0	0
Deferred revenue
-20,008	-39,245	-42,178	43,580	27,196	81,538	18,453	-55,582	-34,588	-3,114	16,084	26,225	58,133	1,555	10,678	-4,023	-52,997	9,450	-6,023	-12,316	12,205	4,346	19,974	48,020	37,372	18,053	12,384	12,971	26,475	33,277	41,193	27,438	32,504	33,792	9,094	9,532	-10,386	-24,618	0	0	0
Other accrued liabilities
706	39,892	20,709	12,806	10,295	-6,507	29,324	5,666	-31,910	-67,481	-66,523	-68,998	-43,053	-21,467	-21,869	12,944	24,642	50,785	42,138	-2,982	3,886	-51,218	-15,895	-6,184	3,747	27,196	25,675	56,427	72,788	84,497	90,832	90,634	83,558	75,290	51,748	20,165	5,172	-9,989	0	0	0
Net cash provided by operating activities
1,279,339	1,313,099	1,282,413	1,269,419	1,362,310	1,454,009	1,396,030	1,420,513	1,413,055	1,307,675	1,296,704	1,244,831	1,213,017	1,245,637	1,353,195	1,313,651	1,161,886	1,039,928	817,879	765,880	905,487	847,027	765,059	709,768	638,004	695,865	734,939	752,922	759,254	708,314	696,249	643,213	582,501	546,294	499,552	489,331	477,442	456,444	0	0	0
CASH FLOWS FROM INVESTING ACTIVITIES:
Capital purchases
401,505	471,518	529,565	535,808	486,478	446,928	405,662	361,705	353,729	362,083	393,938	431,204	448,141	459,427	434,618	412,593	379,219	362,132	331,587	311,721	289,187	276,584	334,843	349,887	373,087	352,877	271,869	240,252	206,517	183,429	159,159	131,282	109,786	104,795	102,572	97,977	91,575	102,311	0	0	0
Capitalized software development costs
273,175	273,871	275,855	275,644	274,642	273,693	273,237	274,133	276,658	274,148	0	0	0	-	-	-	276,929	264,656	251,747	223,998	196,323	177,800	179,459	183,408	184,859	174,649	153,634	131,249	111,443	100,189	93,621	88,734	85,556	82,942	81,023	80,786	80,929	80,979	0	0	0
Purchases of investments
312,889	364,648	464,116	569,424	562,859	623,293	772,194	644,156	730,095	632,048	431,279	423,401	377,674	482,078	415,662	411,252	558,314	487,981	604,226	1,031,023	1,045,420	1,214,036	1,344,718	1,070,394	1,050,001	1,106,819	1,119,339	1,169,015	1,234,109	1,286,997	1,212,011	1,109,898	1,100,441	1,083,274	1,046,888	1,113,462	1,041,876	803,832	0	0	0
Sales and maturities of investments
505,763	579,755	604,615	509,737	560,226	551,796	508,601	436,447	278,718	292,074	439,711	467,943	546,456	463,899	507,727	625,681	638,620	1,208,387	1,143,543	1,598,570	1,771,138	1,404,846	1,469,535	1,109,285	1,010,307	1,070,598	1,094,263	1,019,139	963,001	932,394	839,919	791,733	854,146	791,881	727,006	728,851	637,468	491,492	0	0	0
Purchase of other intangibles
36,275	35,587	38,309	37,903	37,341	36,819	31,764	31,983	31,733	29,646	27,436	25,147	21,265	18,472	16,562	21,898	21,728	21,432	21,371	13,222	13,512	13,517	27,246	28,223	36,799	56,805	55,455	53,056	43,278	22,870	19,437	21,108	20,291	20,620	11,141	13,327	11,775	10,780	0	0	0
Payments to Acquire Businesses, Net of Cash Acquired
0	-	-	-	0	-	-	-	-	-	-	-	-	-	106,115	106,115	106,115	1,478,129	1,372,014	1,372,014	1,379,490	7,476	7,476	7,551	75	67,877	108,417	108,342	108,342	40,540	0	0	0	-	-	-	-	14,486	0	0	0
Net cash used in investing activities
-593,364	-640,408	-703,230	-909,042	-801,094	-828,937	-974,256	-875,530	-1,113,497	-1,005,851	-687,868	-693,296	-590,072	-789,774	-753,981	-613,144	-703,685	-1,405,943	-1,437,402	-1,353,408	-1,152,794	-284,567	-424,207	-530,178	-634,514	-688,429	-614,451	-682,775	-740,688	-701,631	-681,581	-596,561	-527,269	-565,091	-542,687	-604,770	-588,687	-520,896	0	0	0
CASH FLOWS FROM FINANCING ACTIVITIES:
Long-term debt issuance
900,000	600,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	500,000	500,000	500,000	500,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of Long-term Debt
-	-	-	-	-	75,000	75,000	75,000	75,000	0	0	0	0	-	-	-	-	-	-	-	-	14,930	15,019	15,019	15,016	24,700	25,067	25,395	25,863	17,083	26,758	26,685	26,557	25,701	25,936	26,393	27,520	27,625	0	0	0
Proceeds from excess tax benefits from share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	71,142	70,965	60,163	39,532	36,732	38,894	45,262	39,927	41,213	39,944	41,044	48,370	38,855	39,964	37,034	36,433	42,351	39,684	34,297	26,226	0	0	0
Proceeds from exercise of stock options
360,958	258,036	197,822	195,006	96,594	91,349	97,018	59,755	76,058	76,705	64,996	77,145	64,056	63,794	69,480	43,585	42,859	51,475	54,937	50,536	42,743	31,879	26,777	28,603	31,664	31,403	31,094	30,078	35,077	38,147	33,539	33,972	33,541	38,900	47,921	50,472	43,449	34,724	0	0	0
Payments to taxing authorities in connection with shares directly withheld from associates
19,388	16,601	15,118	7,425	9,880	9,873	13,344	10,920	7,993	11,584	7,989	42,925	43,017	38,122	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Treasury stock purchases
1,950,000	1,320,542	1,298,459	956,045	556,045	623,127	495,255	461,058	261,058	173,434	523,589	500,200	550,219	700,275	345,068	545,132	495,113	345,057	200,064	0	142,056	217,082	217,082	245,333	181,827	170,042	170,042	141,791	63,241	0	0	0	0	-	-	-	-	-	-	-	-
Dividends paid
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contingent consideration payments for acquisition of businesses
-	-	-	-	-	-	-	-	-	-	2,671	2,671	3,074	2,074	0	0	0	-	-	-	-	-	-	-	-	800	-6,000	-2,600	-2,600	-3,400	0	0	0	-	-	-	-	-	-	-	-
Cash Grants
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	48,000	48,000	48,000	48,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other financing activities
-12,050	-8,450	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-791	-792	-791	-792	2,894	2,894	7,242	7,242	4,823	4,823	475	475	0	779	779	780	0	0	0	0	-	-	-	-
Proceeds from sale of future receivables
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,516	0	0	0
Net cash used in financing activities
-890,350	-601,380	-576,888	-164,359	-462,467	-609,787	-484,327	-488,914	-269,664	-110,984	-469,253	-468,651	-532,254	-676,677	-424,240	-609,633	-549,391	143,847	399,356	584,220	434,577	-120,324	-128,315	-137,613	-64,675	-119,389	-118,779	-100,889	-16,708	66,034	42,236	47,251	44,019	48,853	63,557	62,984	49,446	34,841	0	0	0
Effect of exchange rate changes on cash and cash equivalents
-13,374	-3,594	-4,479	-4,062	-8,987	-12,082	-11,887	-5,531	5,053	9,222	1,974	-36	-7,828	-10,447	-5,234	-7,271	-3,556	-10,913	-14,570	-17,973	-16,863	-9,310	-3,563	2,519	-345	-2,790	-2,290	-1,282	-1,598	1,257	3	-5,171	-2,620	-1,421	-975	10,716	6,159	2,399	0	0	0
Net increase (decrease) in cash and cash equivalents
-217,749	67,717	-2,184	191,956	89,762	3,203	-74,440	50,538	34,947	200,062	141,557	82,848	82,863	-231,261	169,740	83,603	-94,746	-233,081	-234,737	-21,281	170,407	432,826	208,974	44,496	-61,530	-114,743	-581	-32,024	260	73,974	56,907	88,732	96,631	28,635	19,447	-41,739	-55,640	-27,212	0	0	0
Cash paid during the year for:
Interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,887	0	0	0
Income taxes, net of refunds
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	121,737	0	0	0
Summary of acquisition transactions:
Fair value of tangible assets acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-993,487	-994,706	-984,818	-532,625	450,294	451,513	441,809	-184	-4,469	-7,477	-3,784	-6,165	4,863	7,871	3,994	6,375	0	0	0	-	-	-	-	-	-	-	-
Fair value of intangible assets acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,300,960	-1,300,960	-1,300,960	-637,980	630,380	630,380	634,180	-3,800	3,800	-47,178	0	-25,489	-44,048	6,930	-44,048	-18,559	0	0	0	-	-	-	-	-	-	-	-
Fair value of goodwill
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-910,923	-887,470	-888,448	-485,387	438,906	415,453	433,216	-16,785	17,726	-103,237	-3	-59,570	-95,792	25,171	-94,848	-35,281	0	0	0	-	-	-	-	-	-	-	-
Less: Fair value of liabilities assumed
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-20,614	-21,733	-323,083	-176,863	-167,989	-166,870	156,267	-1,693	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Less: Fair value of contingent liability payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-18,982	-20,898	-20,898	-20,898	-1,916	0	0	0	-	-	-	-	-	-	-	-
Cash paid for acquisitions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	68,627	114,079	114,004	114,004	45,549	0	0	0	-	-	-	-	-	-	-	-
Cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	750	5,662	5,662	5,662	5,009	0	0	0	-	-	-	-	-	-	-	-
Net cash used
0	-	-	-	0	-	-	-	-	-	-	-	-	-	106,115	106,115	106,115	1,478,129	1,372,014	1,372,014	1,379,490	7,476	7,476	7,551	75	67,877	108,417	108,342	108,342	40,540	0	0	0	-	-	-	-	14,486	0	0	0