RealPage, Inc RP Cash Flow

Realpage, inc (RP)

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
Cash flows from operating activities:
Net income
52,541	58,208	44,311	41,680	35,096	34,725	7,588	5,349	3,083	377	28,603	25,979	21,849	16,650	13,189	787	-4,614	-9,218	-13,008	-8,073	-11,046	-10,274	-8,206	7,937	18,838	20,692	37,745	26,972	19,990	20,692	1,702	-1,517	1,137	-1,231	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
120,690	114,952	112,274	108,637	104,750	100,186	95,350	86,002	75,966	67,146	59,774	57,545	56,667	54,834	52,978	50,839	47,887	45,891	44,560	43,609	42,413	41,306	39,455	36,098	33,451	31,745	30,886	31,226	31,665	31,745	31,371	30,868	30,252	29,147	0	0	0
Amortization of debt discount and issuance costs
13,940	13,700	13,381	12,856	12,686	12,464	12,228	11,993	10,219	7,296	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of right-of-use assets
12,031	11,433	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred taxes
-3,266	2,276	8,572	5,030	1,525	-2,179	21,882	13,906	12,394	13,791	-7,849	2,978	7,090	8,386	9,032	-1,245	-1,572	-5,219	-10,707	-5,695	-9,008	-7,891	-3,641	-9,399	-4,179	-2,503	-7,302	1,399	-2,396	-2,503	1,880	435	1,880	524	0	0	0
Stock-based expense
63,851	62,563	60,425	57,406	55,236	50,641	47,595	45,880	46,061	45,835	45,201	41,692	38,553	36,852	34,839	35,253	35,766	38,122	38,922	39,789	38,572	37,050	37,449	35,649	31,677	29,697	36,422	34,699	32,954	29,697	20,705	21,100	21,753	22,618	0	0	0
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	384	357	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Impairment of identified intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20,801	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on disposal and impairment of other long-lived assets
-2,262	-2,536	-3,553	-5,904	-6,077	-6,733	-3,491	-1,535	-1,442	-524	-1,470	-1,249	-1,271	-1,247	-351	-879	-2,478	-3,070	-3,318	-2,642	-958	-386	-40	-61	-331	-314	-237	-208	-139	-314	-387	-382	-179	-398	0	0	0
Change in fair value of equity investment
0	2,600	2,600	2,600	2,600	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisition-related consideration
1,090	1,006	571	-141	287	284	1,108	784	965	684	4	398	-630	-877	-749	-4,012	-3,771	-3,268	-3,409	732	383	173	548	-227	-1,187	1,284	3,006	2,547	4,352	1,284	-730	-123	-778	-410	0	0	0
Changes in assets and liabilities, net of assets acquired and liabilities assumed in business combinations:
Accounts receivable
1,047	14,704	12,737	10,869	17,348	717	12,661	18,436	9,160	18,821	9,459	7,060	11,204	12,239	7,663	7,641	7,781	8,701	4,159	4,675	-1,846	-1,929	4,619	368	7,319	13,669	18,653	20,336	17,206	13,669	8,224	6,906	9,826	11,101	0	0	0
Prepaid expenses and other current assets
19,182	13,786	862	2,782	4,959	11,894	12,883	7,081	1,948	-945	-911	-17,015	-20,212	-21,040	-22,021	-4,218	-2,550	-1,391	2,369	1,347	2,330	2,363	1,620	298	421	341	4,722	1,601	757	341	-6,335	-1,580	1,348	-342	0	0	0
Other assets
3,739	5,107	1,615	2,479	3,343	4,543	3,368	2,501	1,077	717	219	408	959	187	771	1,238	776	814	9	-477	22	592	644	944	683	330	23	-171	-780	330	1,036	1,212	1,524	930	0	0	0
Accounts payable
4,430	9,318	5,058	1,406	-1,676	1,266	610	2,101	6,127	268	3,998	4,656	630	652	276	-1,830	130	-806	-2,004	-4,551	-2,012	1,821	962	6,231	2,948	1,765	7,922	5,144	5,475	1,765	496	1,896	2,269	4,224	0	0	0
Accrued compensation, taxes, and benefits
5,163	-1,150	-906	-4,166	76	3,288	4,839	2,818	1,603	3,438	3,785	2,633	1,996	5,220	824	842	184	3,888	7,893	6,922	5,210	1,964	606	34	-2,433	-1,259	-5,047	-4,097	-1,366	-1,259	1,641	1,611	-149	-1,186	0	0	0
Deferred revenue
9,683	7,696	10,188	8,556	6,599	3,478	7,138	11,473	12,273	17,114	12,240	9,288	7,859	4,452	3,850	8,237	10,421	10,791	9,239	8,180	9,215	8,443	6,607	1,747	240	969	-1,726	1,308	1,097	969	6,101	6,006	6,055	7,810	0	0	0
Customer deposits
127,876	82,631	62,557	5,542	-9,299	57,230	-2,596	-7,192	6,609	3,055	0	0	0	-	-	-	-	-	-	-	-	-	-4	-1	-199	0	0	0	0	-	-70	39	-3	12	0	0	0
Other current and long-term liabilities
-11,760	-11,999	-14,864	-13,941	-8,084	-6,155	-979	200	-506	-672	1,583	4,316	3,679	5,808	4,424	2,974	1,420	170	641	-909	-3,615	268	721	854	4,566	845	872	-6,010	1,449	845	167	8,101	73	-1,152	0	0	0
Net cash provided by operating activities
374,563	316,973	295,990	215,964	178,028	244,807	169,342	146,831	164,051	140,263	130,208	164,500	147,463	129,449	132,622	107,819	102,483	96,012	88,432	76,018	68,844	69,972	67,654	77,374	75,630	69,209	79,663	71,586	75,512	69,209	60,682	62,211	50,867	49,226	0	0	0
Cash flows from investing activities:
Purchases of property, equipment, and software
53,881	51,500	52,157	51,906	49,146	50,933	48,463	45,116	52,487	49,752	52,812	63,884	74,949	75,241	75,605	60,622	37,419	33,384	26,721	29,175	35,982	37,062	39,887	38,694	32,490	32,952	36,541	36,440	37,116	32,952	23,966	20,410	17,753	16,147	0	0	0
Payments to Acquire Businesses, Net of Cash Acquired
725,306	665,844	0	0	0	-	-	-	-	649,910	342,590	118,376	73,391	66,440	71,232	71,137	104,434	45,282	45,455	45,344	34,768	41,947	59,829	60,086	25,358	28,229	28,848	33,946	33,976	28,229	11,655	74,197	93,868	89,749	0	0	0
Intangible asset additions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	927	1,302	1,302	1,452	927	0	0	0	-	-	-	-
Purchase of other investments
-	-	-	-	-	1,800	2,000	2,000	2,000	200	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-780,937	-719,094	-152,055	-212,272	-327,709	-331,296	-583,297	-711,260	-638,294	-699,862	-390,902	-180,760	-146,840	-140,181	-149,837	-131,759	-141,548	-78,361	-72,131	-74,474	-71,010	-79,269	-100,043	-99,107	-58,175	-62,108	-66,691	-71,688	-72,544	-62,108	-37,696	-96,682	-113,546	-107,746	0	0	0
Cash flows from financing activities:
Proceeds from term loans
-	-	-	-	-	-	-	-	-	-	-	-	-	124,688	124,688	124,688	124,688	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on term loans
308,461	308,744	309,029	16,134	16,133	14,116	12,101	8,833	5,567	3,551	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	58,086	0	0	0
Payments on revolving credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	40,000	44,000	57,500	66,500	31,500	46,072	62,572	53,572	48,572	0	0	0	-	-	-	14,688	10,000	0	0	0	-	-	-	-
Payments of deferred financing costs
-	-	-	-	-	1,136	843	1,118	10,533	10,734	11,026	10,755	1,288	392	392	392	392	8	204	1,196	1,196	1,188	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments on finance lease obligations
3,693	3,651	2,887	2,143	882	227	322	410	348	335	231	258	497	548	694	714	583	574	571	568	566	562	557	555	551	548	894	756	623	548	152	239	320	525	0	0	0
Stock issuance costs from public offerings
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Payments of acquisition-related consideration
0	-	-	-	0	-	-	-	-	8,491	8,881	10,133	9,784	5,684	6,452	5,187	4,907	3,685	4,521	6,905	6,838	6,419	4,011	1,811	1,962	1,549	0	0	0	-	-	-	-	-	-	-	-
Payment for Contingent Consideration Liability, Financing Activities
-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from public offering, net of underwriters’ discount and offering costs
-	-	-	-	-	-	-	-	-	0	-16,139	-8,008	5,445	0	25,354	18,654	13,842	12,115	7,646	6,367	9,394	9,914	8,922	12,631	10,359	10,608	7,588	10,598	10,371	10,608	14,049	8,240	11,391	12,674	0	0	0
Proceeds from exercise of stock options
8,862	5,833	7,664	8,493	10,002	13,163	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	384	357	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of treasury stock related to stock-based compensation
19,344	20,867	23,679	25,378	25,596	29,030	31,837	34,656	35,778	30,904	23,430	14,849	8,334	6,020	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other financing activities, net
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of treasury stock under share repurchase program
-	-	-	-	-	-	-	-	-	-	-	-	-	21,244	25,872	41,181	41,455	35,083	24,854	24,843	23,294	15,521	22,819	8,619	5,920	4,860	5,635	5,301	4,747	4,860	3,785	3,331	3,040	2,180	0	0	0
Net cash used in financing activities
476,145	460,011	-85,834	-104,403	292,137	304,085	582,916	609,107	532,443	536,349	308,030	315,255	12,552	82,943	67,773	41,378	68,854	-13,339	-28,109	-11,165	-11,946	1,778	19,115	26,646	1,926	-6,349	13,045	6,848	-11,543	-6,349	-34,252	-31,651	-11,956	-8,176	0	0	0
Net decrease in cash, cash equivalents and restricted cash
69,771	57,890	58,101	-100,711	142,456	217,596	168,961	44,678	58,200	-23,250	47,336	298,995	13,175	72,211	50,558	17,438	29,789	4,312	-11,808	-9,621	-14,112	-7,519	0	0	0	-	-	-	-8,575	752	-11,266	-66,122	-74,635	-66,696	0	0	0
Effect of exchange rate on cash
-577	-171	127	-51	-155	-183	-64	-56	-22	55	7	-74	-189	-43	-34	-72	-77	-337	-296	-274	-197	-47	-36	-15	-46	-54	-90	-97	-72	-54	-5	-26	-33	-41	0	0	0
Supplemental cash flow information:
Cash paid for interest
21,847	16,073	21,670	19,860	16,696	18,204	16,271	13,978	8,851	6,754	3,644	3,062	3,110	2,833	2,359	2,483	1,418	1,086	809	882	836	814	840	887	937	974	469	390	643	974	1,858	2,061	2,337	2,498	0	0	0
Cash paid for income taxes, net
2,588	2,074	2,447	3,869	3,330	3,121	2,696	1,420	1,459	1,855	878	650	827	693	1,604	1,411	808	693	763	707	321	512	430	447	722	525	714	633	578	525	491	616	628	1,024	0	0	0
Right-of-use assets obtained in exchange for operating lease obligations
25,005	23,613	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash investing and financing activities:
Accrued property, equipment, and software
3,949	2,608	1,869	2,785	2,577	1,447	4,372	5,927	-3,489	5,777	5,535	-3,983	5,294	3,993	3,558	10,944	11,417	3,424	230	578	967	607	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Fixed assets acquired under capital lease
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-