OPEN TEXT CORP OTEX Cash Flow

Open text corp (OTEX)

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	Dec'09	Sep'09	Jun'09	Mar'09	Dec'08	Sep'08
Cash flows from operating activities:
Net income for the period
26,000	107,518	74,427	72,015	72,793	104,461	36,368	61,893	58,800	84,917	36,690	46,258	21,712	45,034	912,911	86,333	69,108	87,742	41,312	68,769	26,491	74,494	64,652	88,148	45,796	53,500	30,630	42,172	25,811	61,108	19,429	7,971	34,774	47,443	34,986	28,592	35,830	37,110	21,671	53,167	13,114	21,201	1,730	19,481	22,035	761	14,661
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization of intangible assets
148,164	114,471	109,733	117,146	118,456	118,119	117,207	117,677	117,158	115,467	106,627	103,071	96,667	73,964	72,013	62,562	59,350	59,854	60,602	64,585	63,195	56,035	56,332	56,194	52,353	32,365	45,265	46,994	46,271	46,443	47,143	39,911	40,153	40,332	39,089	35,397	33,696	30,934	29,103	29,955	28,391	28,285	27,206	20,457	26,030	24,857	21,660
Share-based compensation expense
6,856	7,783	6,891	6,618	6,712	6,885	6,555	7,121	5,080	7,158	8,235	8,134	6,661	7,572	8,140	6,898	5,966	6,581	6,533	6,107	6,562	4,929	4,449	4,199	4,418	6,677	4,612	5,422	3,877	3,174	3,102	4,691	5,165	3,397	4,844	2,877	3,094	2,737	2,600	2,611	1,334	2,130	3,690	1,075	1,424	1,110	1,423
Employee long-term incentive plan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,746	1,059
Excess tax (benefits) expense on share-based compensation expense
-	-	-	-	-	-	-	-	-	-	-	-52	1,044	537	5	-27	217	256	-216	64	-16	1,232	395	169	594	1,008	73	303	1	259	352	13	2,215	163	332	311	1,015	130	432	239	207	6	691	249	1,729	13,282	-6,629
Undistributed earnings related to minority interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	119
Pension Cost (Reversal of Cost)
1,428	1,459	1,436	1,212	1,158	1,109	1,145	904	965	834	1,035	940	892	871	1,190	1,118	1,134	1,158	1,167	1,194	1,180	1,202	1,220	1,268	1,174	437	353	756	222	228	242	648	171	169	137	165	156	108	123	-351	152	218	192	253	218	906	0
Amortization of debt issuance costs
1,227	1,149	1,127	1,096	1,077	1,079	1,078	811	1,303	1,234	1,298	1,233	1,127	1,331	1,323	1,208	1,158	1,156	1,156	1,146	1,135	1,132	1,143	1,131	1,016	519	525	532	519	535	537	537	588	248	330	347	345	334	333	326	330	468	266	268	281	326	224
Amortization of deferred charges and credits
-	-	-	-	-	-	-	1,067	941	1,117	1,117	-140	2,146	2,146	2,146	2,653	2,652	1,981	2,617	2,632	2,630	2,632	2,631	2,667	2,706	2,967	2,967	3,195	2,762	2,929	2,929	3,122	3,078	2,707	2,672	-	-	-	-	-	-	-	-	-	-	-	-
Unrealized gain on financial instruments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-2,994	1,482	2,390	1,548	941	-85	-722
Loss on sale and write down of property and equipment
0	0	0	0	-10	-1,639	-7,789	-1,745	-326	0	-163	-784	0	0	0	-	-	-	-	-	-	-	-	0	0	6	-21	0	0	-22	-2	0	0	-34	-169	-	-	-	-	-	-	-	-	-	-	-	-
Release of unrealized gain on marketable securities to income
-	-	-	-	-	-	-	0	0	0	841	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	4,353	-	-	0	0
Deferred taxes
2,543	27,924	6,244	36,118	2,398	1,140	7,769	27,096	18,266	38,427	5,947	19,049	-22,011	7,591	-875,824	-38,769	-7,823	-3,685	-4,184	-10,541	-5,256	2,764	-1,545	-8,131	-1,005	-1,329	-1,869	1,566	-6,210	-2,013	861	-57,700	-14,134	7,891	-14,849	-6,990	-6,958	-3,650	-181	-20,505	-2,414	1,657	-2,957	-6,337	-7,492	4,171	-256
Income (Loss) from Equity Method Investments
4,575	1,200	700	3,048	2,752	5,500	2,400	6,500	-300	300	-500	-200	200	471	5,529	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other non-cash charges
-	-	-	-	-	-	-	-	-	-	-	0	0	0	1,033	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Impairment and other non cash charges
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	44	0	2,700	-1,355	-	-	-	-	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities:
Accounts receivable
-83,590	55,833	-58,431	-22,731	-19,229	40,327	-73,875	-33,132	6,240	54,620	-5,162	89,689	37,551	15,713	-16,169	13,167	-11,272	41,226	-52,106	33,371	-36,311	15,294	-55,543	36,315	-9,953	19,602	-28,778	-2,578	5,019	-964	-19,442	-14,583	9,237	21,681	-21,654	4,338	5,132	18,208	-27,878	-568	-22,566	6,541	-7,928	4,136	-15,107	-60,736	27,946
Contract assets
9,006	10,458	7,201	8,751	15,472	8,054	5,346	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid expenses and other current assets
6,854	-1,111	1,612	324	13,027	-2,800	-9,732	-3,261	5,152	2,575	2,808	1,532	18,119	-13,074	1,189	-2,905	3,202	5,221	-5,834	-467	3,304	548	149	-29,771	14,464	729	3,432	-6,303	3,445	1,640	-3,024	-1,028	11,148	-2,199	-5,842	-1,709	-813	-1,839	2,528	-492	-2,017	105	3,218	-665	2,275	3,396	-1,926
Income taxes
-33,717	-7,944	7,053	6,285	3,682	4,763	12,561	-9,255	-23,651	-7,565	9,148	-3,253	11,190	-12,841	3,221	3,004	2,996	-3,503	3,797	1,579	-10,245	-6,207	17,806	5,730	3,169	-5,093	7,502	-2,146	-1,019	-18,261	4,373	69,551	-3,833	-12,141	15,024	-12,376	-15,039	3,997	32,862	23,304	-10,234	-3,217	-4,787	13,618	3,187	1,738	4,731
Deferred charges and credits
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-1,382	-5,788	-2,700	12,854	-4,016	0	436	-2,043	9,425	5,607	9,046	-101	-95	1,542	27,725	-	-	-	-	-	-	-	-
Accounts payable and accrued liabilities
-9,028	29,744	-62,979	8,912	-896	10,253	-40,001	628	-19,779	-8,023	-64,476	36,969	40,516	6,604	-30,599	21,763	-12,615	33,503	-48,322	31,033	-16,421	-3,187	-34,139	-3,600	-22,032	7,247	-18,093	-14,771	-6,556	-365	-20,255	2,958	-4,553	4,608	-21,407	825	-710	4,679	-25,991	126	-4,932	318	-6,852	2,731	-2,684	2,323	-18,369
Deferred revenue
102,373	-2,924	-61,169	-25,961	93,285	-11,748	-57,403	-39,075	123,550	-10,366	-38,480	-3,433	54,659	-21,633	-26,109	-17,345	61,237	-16,280	-32,393	70	39,450	-5,990	-26,755	-3,421	60,156	-21,574	-18,560	-12,774	54,930	-18,668	-18,070	-13,078	66,303	-24,808	-32,998	-2,075	37,585	-17,538	-7,234	4,106	23,000	-11,592	-12,437	-5,557	24,309	-6,183	-19,430
Other assets
-5,079	3,327	-5,684	4,304	619	-2,475	-2,444	-3,368	1,285	-497	2,083	15,064	1,215	-20	5,440	70	1,290	-1,242	-2,281	3,039	-1,428	1,158	2,262	2,558	2,614	-716	1,402	1,453	-670	-497	208	-3,550	-911	2,630	-588	3	445	667	1,545	26,429	-1,376	-682	-1,175	2,094	1,862	-1,656	322
Operating lease assets and liabilities, net
2,381	2,169	-64	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by operating activities
329,601	207,238	137,447	229,777	285,997	189,103	171,401	204,060	270,589	166,186	67,246	103,580	156,303	107,019	73,451	119,120	189,944	123,936	92,722	131,817	143,111	109,572	138,531	134,914	141,414	60,875	79,924	65,217	116,828	74,694	61,763	79,846	96,598	44,698	45,348	51,957	82,327	40,003	48,934	65,220	78,001	32,468	4,502	38,627	72,887	39,843	24,813
Cash flows from investing activities:
Additions of property and equipment
16,793	19,598	18,614	13,405	16,968	8,969	24,495	22,280	27,101	25,488	30,449	29,521	17,797	11,609	20,665	21,112	18,998	12,702	17,197	16,460	12,325	18,026	30,235	13,825	8,215	11,913	8,315	7,315	5,875	4,879	5,038	4,447	4,694	8,785	7,902	10,126	11,954	7,639	6,943	4,045	3,505	4,099	7,665	5,842	4,214	5,981	-3,887
Proceeds from maturity of short-term investments
-	-	-	-	-	-	-	-	-	-	-	0	0	0	9,212	2,058	3,915	3,069	2,255	9,925	7,092	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of business, net of cash acquired
-	-	0	-	-	-	2,279	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	30,588	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	90,600	-	-	-	-
Other investing activities
5,803	3,505	2,036	8,762	1,831	5,369	1,004	6,855	3,118	3,855	4,206	2,924	2,450	440	123	3,269	2,444	2,754	926	1,659	482	1,059	7,374	0	1,573	-526	1,500	3,750	0	0	0	-	-	-	-	-1,186	0	0	668	-	-	-	-	0	5,322	7,216	-3,608
Purchase of Vignette Corporation, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Purchase of eMotion LLC, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-3,635
Purchase of a division of Spicer Corporation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-10,836
Purchase consideration for prior period acquisitions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	147	221	222	222	222	221	222	222	222	214	217	187	317	335	274	371	1,392	1,408	1,406	1,436	3,167	3,439	4,801	5,604	4,824	15,659	-3,293
Maturity of short-term investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	7,000	11,354	27,171	-	-	0	0
Net cash used in investing activities
-184,389	-1,243,891	-20,650	-22,167	-88,958	-325,623	-27,778	-29,204	-50,685	-37,853	-326,699	-32,445	-1,642,641	-14,708	-501,170	-279,604	-21,312	-34,576	-25,684	-8,226	-332,810	-19,528	-37,831	-13,262	-1,087,681	-11,800	-40,625	-22,736	-25,463	-5,609	-320,586	-5,257	-5,356	-8,779	-262,147	-9,782	-202,201	-66,268	-9,017	-37,514	328	3,260	-75,895	-12,296	-14,961	-108,313	-25,259
Cash flows from financing activities:
Proceeds from Revolver
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of Common Shares from exercise of stock options and ESPP
29,990	12,000	11,117	15,792	17,811	6,159	18,127	9,871	36,442	7,797	21,825	8,925	15,967	5,391	5,310	8,269	3,840	2,736	5,252	2,413	3,689	2,039	7,099	5,090	14,289	3,606	1,823	8,817	1,128	2,409	3,993	2,934	7,075	3,424	7,837	2,128	4,831	1,307	3,246	1,034	2,795	1,665	4,477	1,919	11,635	497	5,542
Excess tax benefits (expense) on share-based compensation expense
-	-	-	-	-	-	-	-	-	-	-	-52	1,044	537	5	-27	217	256	-216	64	-16	1,232	395	169	594	1,008	73	303	1	259	352	13	2,215	163	332	311	1,015	130	432	239	207	6	691	249	1,729	24	6,629
Proceeds from long-term debt and Revolver
-	-	-	-	-	-	-	1,000,000	0	0	200,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	648,500	0	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of long-term debt and Revolver
1,706,131	2,500	2,500	2,500	2,500	2,500	2,500	1,043,800	101,940	1,940	1,940	51,940	1,940	2,000	2,000	2,000	2,000	2,000	2,000	9,799	493,655	13,413	13,417	13,412	13,412	11,419	7,668	7,669	7,670	7,671	7,667	7,667	7,664	382,356	-48,500	914	901	882	878	878	873	870	864	856	849	2,588	-867
Debt issuance costs
17,191	979	0	0	0	0	322	4,375	0	0	0	1,040	2,045	2,825	1,330	6,765	0	0	0	195	16,673	1,220	183	653	15,759	273	0	-	-	-	-	0	525	8,393	916	-	-	-	-	0	0	0	1,024	-	-	0	0
Payments for Repurchase of Common Stock
0	0	12,400	0	2,000	12,800	11,700	0	0	0	0	-	-	-	-	-	-	-	50,026	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of non-controlling interests
0	0	0	0	0	0	583	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of Dividends
47,300	47,100	47,000	47,000	40,700	40,700	40,500	40,600	35,200	34,800	35,000	34,647	30,303	27,859	27,791	27,635	24,099	24,216	23,312	24,455	21,074	21,055	21,045	21,001	18,224	17,747	17,721	17,703	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
648,141	711,429	-50,813	-33,666	-27,389	-49,856	-37,463	-78,921	-100,666	-28,954	184,868	-82,998	202,133	816,215	-25,806	571,842	-22,042	-49,334	-70,302	-40,847	271,019	-32,416	-27,151	-29,807	766,069	-24,825	-23,493	-16,252	-6,541	-5,003	-3,322	-15,608	1,101	261,338	55,753	1,525	4,945	-11,973	2,800	-13,605	2,129	801	3,280	1,312	12,515	-333	11,304
Foreign exchange gain (loss) on cash held in foreign currencies
-15,989	3,640	-7,711	83	1,992	-6,329	428	-19,889	10,157	-216	7,762	7,320	10,714	-20,979	4,712	-5,006	4,852	-4,848	-5,950	4,078	-10,953	-7,304	-8,953	-26	915	-43	4,896	-2,695	-5,171	941	4,633	-8,140	2,652	-2,640	-3,800	2,693	11,893	-5,671	15,783	-9,237	-6,760	-1,089	4,484	11,128	-6,263	-8,460	-15,641
Increase (decrease) in cash, cash equivalents and restricted cash during the period
777,364	-321,584	58,273	174,027	171,642	-192,705	106,588	76,046	129,395	99,163	-66,823	-4,543	-1,273,491	887,547	-448,813	406,352	151,442	35,178	-9,214	86,822	70,367	50,324	64,596	91,819	-179,283	24,207	20,702	23,534	79,653	65,023	-257,512	50,841	94,995	294,617	-164,846	46,393	-103,036	-43,909	58,500	4,864	73,698	35,440	-63,629	38,771	64,178	-77,263	-4,783
Guidance Software Inc.
Purchase of business, net of cash acquired
-	-	-	-	-	-	-	0	0	8,510	220,765	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Covisint Corporation
Purchase of business, net of cash acquired
-	-	-	-	-	-	-	0	0	0	71,279	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
HP Inc. CCM Business
Purchase of business, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	0	0	2,802	312,198	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recommind, Inc.
Purchase of business, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	0	0	0	170,107	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
HP Inc. CEM Business
Purchase of business, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,289	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-