DIPLOMAT PHARMACY, INC. DPLO Cash Flow

Diplomat pharmacy, inc. (DPLO)

CashFlow / TTM

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
Cash flows from operating activities:
Net loss
-649,068	-471,618	-316,120	-302,269	2,269	3,060	10,513	15,188	7,391	9,258	14,062	25,020	29,608	42,463	37,283	24,772	18,113	6,971	5,533	4,551	0	0	0
Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization
83,083	90,401	94,556	97,112	90,300	82,801	75,120	66,566	62,773	59,591	55,323	50,045	46,103	42,355	38,154	30,841	23,631	16,469	9,633	8,139	0	0	0
Share-based compensation expense
15,033	15,905	18,583	18,172	17,565	13,605	9,470	7,281	6,391	6,058	4,881	5,412	5,942	5,856	4,877	3,936	3,545	2,968	3,171	2,871	0	0	0
Net provision for doubtful accounts
11,888	10,308	8,785	8,660	7,763	7,942	8,962	9,424	10,679	10,925	10,072	9,534	9,061	4,641	8,006	5,990	4,095	8,407	4,370	4,045	0	0	0
Amortization of debt issuance costs
4,131	3,912	4,562	4,733	5,466	4,802	3,490	2,655	1,190	1,190	1,188	1,176	1,176	1,173	1,173	963	755	555	357	366	0	0	0
Changes in fair value of contingent consideration
0	0	0	-	-	-	-	-	-	-	-	-8,922	-538	-7,367	-2,675	6,724	0	0	0	-	-	-	-
Contingent consideration payments
-	-	-	-4,239	0	0	0	-	-	-	-	-4,174	-4,174	-3,820	-3,838	-3,738	0	0	0	-	-	-	-
Deferred income tax benefit
-11,135	-10,443	-10,848	-11,847	-12,192	-12,406	-13,088	-10,795	-682	-1,420	2,892	8,779	3,024	5,113	859	-4,615	-3,396	-1,950	-1,628	-1,295	0	0	0
Equity loss and impairment of non-consolidated entities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-6,208	0	0	0
Excess tax benefits related to share-based awards (Note 10)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20,805	0	0	0	-	-	-	-
Loss on sale or disposal of property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Other
-	-	0	-	-	-	0	-	-	-	-	2	26	-124	-124	85	0	0	0	-	-	-	-
Changes in operating assets and liabilities, net of business acquisition
Accounts receivable
-14,886	-11,839	8,080	2,333	27,472	11,973	13,650	-7,735	-12,628	-31,094	-22,261	15,128	30,897	51,787	57,256	50,771	68,080	64,206	34,438	43,130	0	0	0
Inventories
10,981	8,849	-20,944	3,932	-28,151	-13,041	-10,897	-13,813	-4,231	-4,195	14,611	44,342	39,472	18,470	57,500	41,657	71,800	75,662	55,544	50,334	0	0	0
Accounts payable
50,574	-57,426	-113,068	-80,412	-47,084	32,915	52,193	23,088	-14,351	-73,137	-21,665	-5,906	29,948	83,859	42,441	43,202	48,957	20,468	48,118	56,505	0	0	0
Rebates payable
-6,493	-4,292	-10,458	-5,479	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets and liabilities
-2,213	-5,546	-12,925	-5,612	-6,368	190	12,105	4,615	3,309	802	-958	-367	-10,166	-27,731	-35,421	-34,370	-31,537	-10,460	-5,112	-4,173	0	0	0
Net cash provided by operating activities
109,835	35,140	10,122	35,042	74,815	134,653	139,531	135,254	93,567	52,630	81,200	31,326	58,320	115,951	27,965	29,447	-26,340	-70,950	-12,740	-9,568	0	0	0
Cash flows from investing activities:
Expenditures for property and equipment
-2,780	-1,503	7,412	1,139	627,533	626,265	597,102	623,067	65,558	65,740	92,372	67,156	7,262	7,320	5,465	4,624	0	0	0	-	-	-	-
Expenditures for capitalized software for internal use
15,788	15,303	9,069	10,474	12,136	10,071	7,669	6,652	-328	1,327	3,070	6,217	12,673	13,252	13,009	12,021	12,857	11,695	11,564	9,470	0	0	0
Payments to acquire businesses, net of cash acquired
-	-	-	-	-	-	-	3,505	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Capital investments in and loans to non-consolidated entities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,000	0	0	0
Net proceeds from sales of property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Other
0	0	0	-	0	0	0	-	0	0	43	-	-20	-20	-20	-27	0	0	0	-	-	-	-
Net cash used in investing activities
-18,563	-12,158	-16,092	-11,235	-567,678	-587,565	-607,756	-633,319	-85,337	-64,204	-108,649	-85,967	-84,508	-84,602	-313,409	-311,573	-318,609	-317,226	-68,166	-66,084	0	0	0
Cash flows from financing activities:
Net repayment of related parties' notes receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Net payments on revolving line of credit
-73,250	-10,100	16,500	-11,950	156,658	132,579	134,282	148,995	0	0	0	-	-	-	-	-	-	-	-	-62,622	0	0	0
Proceeds from long-term debt
-	-	-	-	-	-	-	575,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments on long term debt
11,500	11,501	11,500	85,500	212,594	212,437	211,375	136,000	7,531	6,313	6,000	6,000	0	0	0	-	-	-	-	25,542	0	0	0
Payments of debt issuance costs
-	-	-	891	0	0	0	-	-	-	-	-	-	-	-	5,055	0	0	0	-	-	-	-
Proceeds from issuance of stock upon stock option exercises
-	-	-	4,098	4,277	5,219	6,985	7,875	8,287	9,252	6,737	4,448	0	0	0	-	-	-	-	-	-	-	-
Contingent consideration payments
-	-	-	4,330	0	0	0	-	-	-	-	2,681	2,681	3,034	2,912	3,012	0	0	0	-	-	-	-
Proceeds from public offering, net of transaction costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	187,988	0	0	0	-	-	-	-
Payments made to repurchase stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	36,298	36,298	36,298	42,598	9,400	0	0	0
Excess tax benefits related to share-based awards (Note 10)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20,805	0	0	0	-	-	-	-
Net cash used in financing activities
-91,111	-24,571	2,669	-98,573	473,925	452,468	457,684	574,363	1,830	11,472	29,346	34,994	27,615	-40,748	138,110	291,769	344,827	379,931	242,924	84,500	0	0	0
Net decrease in cash and equivalents
-	-	-3,301	-	-	-	-10,541	76,298	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of preferred stock, net of transaction costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	101,815	0	0	0
Payments made to repurchase common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	53,400	0	0	0
Net increase (decrease) in cash and equivalents
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-147,334	-	-122	-8,245	162,018	8,848	0	0	0
Supplemental disclosures of cash flow information:
Cash paid for interest
38,356	37,726	36,945	37,851	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid for interest
-	-	-	-	-	-	-	-	0	0	6,108	-	5,012	5,050	4,612	3,949	3,567	2,752	2,915	2,248	0	0	0
Cash paid for income taxes
-	-	3,501	3,520	3,302	3,159	5,945	5,876	4,153	4,785	168	728	1,296	536	748	351	0	0	0	-	-	-	-