NGL Energy Partners LP NGL Cash Flow

Ngl energy partners lp (NGL)

CashFlow / Quarterly

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
OPERATING ACTIVITIES:
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest
42,991	-201,366	8,039	43,217	110,528	354,939	-169,289	110,912	56,769	-173,579	-63,707	26,486	1,293	-66,658	182,753	-206,985	50,995	-6,100	-25,007	111,251	-5,269	-15,879	-39,910	43,146	24,052	-932	-17,508	22,341	40,477	10,082	-24,710	13,943	6,089	-5,396	-6,772	6,623	6,056
Adjustments to reconcile net (loss) income to net cash provided by operating activities:
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent
-1,137	-191,663	0	-30,382	-36,901	474,558	-4,156	146,843	24,942	-9,347	-5,658	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation and amortization, including amortization of debt issuance costs
76,916	63,842	57,855	62,428	55,605	53,722	55,939	54,751	56,375	57,873	56,739	21,263	65,433	55,043	53,090	58,130	66,530	60,737	63,814	58,247	54,604	54,200	43,424	42,802	38,030	27,075	24,746	30,602	21,435	15,548	9,928	7,162	5,893	2,203	1,930	2,286	2,120
Loss on early extinguishment or revaluation of liabilities, net
-10,000	0	0	4,053	-10,083	0	-937	-15,838	-21,141	-3,657	-3,281	-12,880	0	938	29,952	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on early extinguishment of liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on early extinguishment of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5,769	-	-	-	-	-	-
Non-cash equity-based compensation expense
2,213	21,295	3,701	8,792	7,845	19,219	5,511	8,127	12,228	6,065	8,821	13,243	6,865	10,657	22,337	1,485	-1,402	15,188	36,294	19,383	1,626	3,989	7,769	3,214	4,078	-313	7,075	3,348	2,365	2,302	655	-	-	-	-	-	-
Gain (Loss) on Disposition of Assets
12,626	-3,111	967	36,781	36,246	-5,988	-101,335	3,858	112,388	-110,959	11,817	5,457	-34	-852	204,319	-317,726	-1,328	-1,291	-421	-6,545	-30,073	-4,134	-432	-1,094	-340	-1,790	-373	-221	11	30	-7	-	-	-	-	-	-
Revaluation of liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,195	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Provision for doubtful accounts
-49	487	280	-53	259	-33	196	-79	-36	400	305	-1,471	593	-134	12	1,858	724	1,986	1,060	1,707	1,051	1,096	251	333	1,331	417	364	406	553	63	293	644	296	63	46	252	17
Derivative Instruments Not Designated as Hedging Instruments, Gain (Loss), Net
-53,400	27,700	26,500	3,631	86,700	-4,000	-52,700	-17,104	-64,871	-71,156	36,527	46,660	-57,672	14,734	-59,700	6,154	52,535	85,777	-41,243	-21,571	202,496	55,981	-17,485	-16,944	-8,830	-10,672	-7,209	-16,400	7,005	791	4,228	3,795	1,714	494	-29	940	528
Income (Loss) from Equity Method Investments
534	-265	8	158	1,777	379	219	862	2,588	2,273	1,816	2,104	1,279	53	394	2,113	2,858	2,432	8,718	4,599	1,242	3,697	2,565	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Distributions of earnings from unconsolidated entities
-	-	-	-	-	-	-	-259	2,114	1,351	1,426	1,470	2,052	-135	177	1,662	4,149	5,430	6,163	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Lower of cost or market value adjustment
-688	-1,305	2,284	38,462	12,394	37	94	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Revaluation of Investments
-	-	-	-	-	-	-	-	-	-	-	0	0	0	14,365	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
-1,185	-1,506	1,061	260	849	-830	206	282	8,941	-5,325	-3,857	4,540	331	1,560	1,378	1,459	4,387	0	8	5,852	-6,112	1,029	-192	-630	326	179	-187	-388	85	-10	-62	-360	36	-86	7	-	-
Changes in operating assets and liabilities, exclusive of acquisitions:
Accounts receivable-trade and affiliates
-50,621	243,909	-251,745	85,054	-326,627	310,852	74,930	6,686	206,563	188,799	-129,058	9,059	190,996	-21,334	75,403	-50,854	-132,456	-202,555	-119,675	-616,053	216,161	355,622	2,875	-181,284	132,156	45,514	-17,501	-31,849	131,026	37,719	-139,458	-46,280	55,638	7,038	3,783	-35,193	36,006
Accounts receivable-affiliates
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,542	-	843	40,068	-6,335	1,070	740	-11,408	-8,404	21,549	-1,904	-1,361	-5,407	-	-	-	-	-	-
Inventories
-9,463	-1,338	61,459	-148,242	-10,267	56,775	48,864	-76,123	70,882	9,326	3,963	-55,630	93,434	-3,118	154,625	-45,450	5,097	-81,350	47,017	-88,685	-358,572	140,429	63,536	-91,795	-61,611	145,603	81,124	-107,064	-33,350	72,462	49,519	-94,726	-30,130	54,164	40,424	-43,560	-16,853
Other current and noncurrent assets
-46,960	28,904	6,995	-14,664	-35,729	22,099	-15,967	16,719	-9,232	43,161	-28,176	-11,147	20,533	-12,894	57,692	9,234	-38,501	-6,737	25,432	-16,005	-5,599	41,116	14,993	-26,119	-5,019	11,048	-218	-15,771	-3,021	-4,722	929	-8,857	-5,278	199	-408	-	-1,828
Product exchanges, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-7,017	-2,467	-6,389	7,039	9,290
Accounts payable-trade and affiliates
9,775	115,027	-156,664	100,952	-180,903	211,978	-30,328	-1,809	223,119	113,161	-139,132	-8,873	155,010	-18,348	108,844	-102,375	-65,012	-194,207	-78,115	-733,031	216,178	393,654	70,113	-370,994	143,209	25,494	35,231	-43,350	104,402	62,452	-140,417	-32,836	43,091	13,421	12,071	-30,511	33,346
Other current and noncurrent liabilities
3,461	14,092	-356	-13,567	-57,125	46,242	13,830	-18,975	-25,107	19,874	9,956	4,172	-26,869	14,325	11,945	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable-affiliates
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-202	-	-72,541	47,532	-39,140	58,769	-2,937	7,925	3,604	5,138	-5,253	-3,974	-2,724	-	-	-	-	-	-
Accrued expenses and other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,610	-	-1,405	25,903	-184	-39,625	-20,208	11,789	6,373	2,793	3,182	-6,813	-8,851	-148	-487	1,062	-61	-953	-256
Advance payments received from customers
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	12,005	-	-34,276	47,292	26,408	-32,080	-16,616	32,742	12,880	-36,862	-16,429	27,352	14,890	-14,344	-6,491	17,586	7,831	-16,493	-13,997
Net Cash Provided by (Used in) Operating Activities, Continuing Operations
294,281	-90,587	69,894	304,319	244,109	-167,728	-73,186	86,546	-5,262	-17,970	-9,685	17,772	-60,695	15,663	-70,540	58,361	119,039	92,266	81,829	180,551	143,475	-70,841	9,206	20,463	113,517	-74,277	25,533	134,560	50,880	2,103	-54,909	103,993	39,128	-30,449	-22,343	33,866	143
Net cash provided by operating activities-discontinued operations
43,685	16,205	0	-82,727	-40,570	120,992	32,041	47,134	-2,160	28,688	10,676	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by operating activities
337,966	-74,382	69,894	221,592	203,539	-46,736	-41,145	133,680	-7,422	10,718	991	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
INVESTING ACTIVITIES:
Capital expenditures
168,178	103,684	155,391	151,624	110,470	120,809	72,710	51,455	35,667	18,994	27,645	80,356	62,947	61,454	140,179	164,738	274,871	100,166	122,110	92,543	52,584	33,984	48,867	57,203	40,546	37,207	30,192	35,106	22,774	11,911	2,684	3,413	2,037	1,254	840	769	671
Purchases of pipeline capacity allocations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisitions, net of cash acquired
615,805	592,500	54,548	118,965	0	81,379	116,592	0	0	0	19,897	-85,585	14,216	98,839	14,458	47,296	36,810	86,648	63,898	-153,123	455,281	642,895	15,869	28,635	847,570	387,646	4,959	-2,491	186,214	11,741	295,341	104,813	190,398	2,120	70	272	17,128
Net settlements of commodity derivatives
46,558	-42,846	-6,447	-13,339	-64,185	-1,742	60,861	14,830	63,786	45,138	-23,349	-45,729	57,800	3,480	21,535	-13,446	-49,184	-64,725	21,693	-8,710	-186,128	-14,294	9,967	5,297	11,585	8,020	11,054	-26,057	3,786	-4,822	15,514	4,367	770	-890	2,217	-448	559
Proceeds from sales of assets
15,074	309	1,673	7,842	131	2,798	5,406	2,505	8,764	4,082	18,493	14,037	13,799	-42	438	3,474	1,414	1,636	1,931	11,026	6,495	7,752	989	17,358	5,078	1,136	1,088	4,380	119	220	361	929	127	143	39	-	-
Proceeds from sale of TLP common units
-	-	-	-	-	-	-	-	-	-	-	-	0	0	112,370	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from divestitures of businesses and investments, net
0	0	0	232,215	85,000	0	18,594	37,663	292,117	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in unconsolidated entities
20,257	126	889	297	0	86	6	4	7,311	8,900	5,250	2,105	0	0	0	3,058	1,447	4,777	2,149	0	7,138	22,296	4,094	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Distributions of capital from unconsolidated entities
1	0	439	1,440	0	0	0	259	7,332	2,263	2,115	2,084	2,375	2,292	2,941	1,749	5,836	5,051	3,156	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loan for natural gas liquids facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	3,913	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on loan for natural gas liquids facility
0	0	3,022	1,965	3,813	1,851	2,707	2,627	2,550	2,474	2,401	2,331	2,261	2,194	2,130	2,066	2,006	1,946	1,600	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loan to affiliate
0	0	0	0	0	465	1,050	1,050	500	460	500	500	1,000	700	1,000	0	0	0	15,621	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on loan to affiliate
-	-	-	-	-	-	-	-	-	-	-	0	0	0	655	996	517	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment to Terminate Contract
-	-	-	-	-	-	-	-	-	-	-	0	0	0	16,875	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments for (Proceeds from) Other Investing Activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-218	-215	-212	-208	-230	-112	204	-	-
Net Cash Provided by (Used in) Investing Activities, Continuing Operations
-785,848	-703,030	-199,247	-14,085	42,659	-196,348	-224,512	-50,709	227,659	-64,673	-6,934	66,805	-95,528	-160,029	-75,513	149,774	-254,171	-118,233	-222,697	-251,719	-364,214	-672,480	-77,808	-83,385	-895,134	-431,737	-45,117	-31,779	-204,865	-28,039	-281,938	-102,722	-191,308	-4,009	1,142	-1,198	-17,240
Net cash provided by investing activities-discontinued operations
12,845	269,063	0	-90,932	126,672	833,027	-23,008	216,239	-14,395	-34,339	-2,266	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Formation transaction contributions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,040
Net cash (used in) provided by investing activities
-773,003	-433,967	-199,247	-105,017	169,331	636,679	-247,520	165,530	213,264	-99,012	-9,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
FINANCING ACTIVITIES:
Proceeds from borrowings under Revolving Credit Facility
1,263,000	1,059,000	1,139,000	1,142,000	948,500	1,046,000	962,000	760,000	860,000	515,000	299,500	524,000	406,000	336,500	433,500	560,400	687,400	633,500	721,200	667,800	1,117,200	1,485,000	494,500	505,000	979,000	806,500	255,000	250,000	383,300	132,500	462,175	128,400	252,500	75,500	22,500	62,146	87,354
Payments on Revolving Credit Facility
964,000	1,121,000	1,155,000	860,000	883,500	1,548,000	605,500	930,000	692,000	313,000	344,500	1,223,000	915,000	141,000	454,500	618,900	507,500	508,400	498,200	675,300	800,700	1,123,000	681,000	391,500	816,500	681,000	212,000	335,500	206,300	89,000	333,675	124,400	92,500	36,500	76,500	77,892	34,489
Issuance of senior unsecured notes
-	-	450,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	250,000	-	-	-	-	-	-
Repayment and repurchase of senior unsecured notes
0	0	0	341,587	390,402	0	5,069	71,131	300,161	41,016	74,391	6,064	0	0	15,129	43,421	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from borrowings under other long-term debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	880	-	-	-	-	-	-	-	-	-	-
Payments on other long-term debt
163	163	163	165	162	163	163	161	164	393	159	39,604	2,126	2,321	2,102	1,438	1,305	715	1,629	1,212	1,301	1,828	2,347	2,106	2,206	1,623	2,884	3,491	1,095	-49	300	120	179	790	189	5,287	615
Debt issuance costs
2,752	2,573	7,873	468	135	9	771	203	23	378	2,096	20,950	12,288	275	45	553	8,304	1,374	6	250	1,628	7,004	2,194	534	21,843	7	2,211	1,576	774	-611	18,450	336	112	1,681	251	626	4,302
Contributions from general partner
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11	415	13	43	352	-	292	1,444	1,000	-366	125	171	580	-	-	-	-	-	-
Contributions from noncontrolling interest owners, net
0	0	0	0	0	0	169	0	0	0	23	33	174	136	329	1,510	3,424	2,666	3,947	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Distributions to general and common unit partners and preferred unitholders
62,635	55,098	62,288	59,630	59,517	63,581	53,905	58,478	59,200	53,990	53,399	49,446	48,428	43,011	40,696	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Distributions to partners
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	81,727	73,097	-	65,043	61,517	49,491	243,747	-38,034	-33,464	-27,159	118,044	-23,553	-13,708	-9,175	-7,745	-4,995	-2,474	-3,846	-	-
Distributions to noncontrolling interest owners
-	-	-	-	-	-	-	-	-	-	-	0	542	1,395	1,355	9,082	8,858	8,723	9,057	9,650	8,843	8,642	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of preferred units, net of offering costs
194,627	385,700	42,638	0	0	0	0	0	-24	-222	202,977	-14	-29	-162	235,180	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments for redemption of preferred units
0	0	265,128	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchase of warrants
0	0	0	0	0	0	14,988	0	0	0	10,549	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of common units, net of offering costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	170,752	-70	32,413	338,033	-	-	-	-	0	176	-145	-673	-46	-484	0	75,289	-	-1,533
Payments for settlement and early extinguishment of liabilities
680	730	543	1,043	895	1,444	1,195	1,000	758	905	745	491	571	1,032	26,374	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Subsidiary Investment in Stock of Parent
-1,399	-11,466	-2,361	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of convertible preferred units and warrants, net of offering costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock dividends
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	40,000
Other
-	-	-	-	-	-	-	-	-	-	8,831	-	-	33	-53	4	36	-14	-98	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Exercise of stock options of NGL Supply
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,430
Repurchase of common units
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	3,418	-	-
Net Cash Provided by (Used in) Financing Activities, Continuing Operations
425,891	502,002	138,282	-121,028	-386,219	-567,251	280,578	-301,182	-196,275	81,520	25,492	-72,306	161,723	156,915	128,755	-205,138	130,258	12,514	143,071	81,915	239,472	715,465	97,841	64,461	784,990	506,939	12,626	-115,123	151,879	30,478	350,482	-3,807	154,145	34,140	13,585	-22,055	18,885
Net cash used in financing activities-discontinued operations
0	0	0	0	0	0	-325	-191	-1,034	7,388	-9,999	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
425,891	502,002	138,282	-121,028	-386,219	-567,251	280,253	-301,373	-197,309	88,908	15,493	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Less cash flows from discontinued operations
-	-	-	-	-	-	-	-	-	-	-1,589	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net (decrease) increase in cash and cash equivalents
-9,146	-6,347	8,929	-4,453	-13,349	22,692	-8,412	-2,163	8,533	-975	8,873	-17,461	5,500	12,549	-17,298	2,997	-4,874	-13,453	2,203	10,747	18,733	-27,856	29,239	1,539	3,373	925	-6,958	-12,342	-2,106	4,542	13,635	-2,536	1,965	-318	-7,616	10,566	1,788
Supplemental cash flow information:
Cash interest paid
57,947	29,077	36,538	38,314	49,628	31,584	51,106	39,150	57,571	41,882	54,335	28,810	30,233	29,682	29,187	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Income taxes paid (net of income tax refunds)
1,035	700	2,537	530	525	460	908	229	141	226	1,247	37	230	71	1,684	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Supplemental non-cash investing and financing activities:
Distributions declared but not paid to Class B, Class C and Class D preferred unitholders
4,450	2,366	5,796	0	0	0	4,725	0	-945	5,670	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued capital expenditures
-7,559	15,467	32,926	-15,613	13,226	8,851	12,657	4,679	4,537	1,518	1,389	-996	681	-4,727	6,800	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-