Crestwood Equity Partners LP CEQP Balance Sheet

Crestwood equity partners lp (CEQP)

Balance Sheet / 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	Sep'09
Assets
Cash
5	25	1	2	0	0	2	6	7	1	1	2	1	1	1	0	1	0	9	1	67	8	2	18	7	5	8	2	2	0	0	4	14	18	11	158	18	19	144	5	11
Restricted cash
-	-	0	0	1	16	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	588	-	-
Accounts receivable, less allowance for doubtful accounts of $0.6 million and $0.3 million at March 31, 2020 and December 31, 2019
202	242	258	195	255	251	352	326	386	442	345	290	267	289	224	247	209	236	302	302	289	379	430	379	364	412	238	182	161	45	133	88	184	242	112	140	195	225	108	105	94
Inventory
20	53	43	33	42	64	91	73	32	68	92	63	58	66	61	43	26	44	49	38	23	46	104	58	39	73	95	53	28	0	87	46	93	156	155	145	66	135	137	-	-
Inventories (Note 5)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	89	96
Assets from price risk management activities
52	43	57	25	16	34	7	6	5	7	7	12	6	6	10	9	14	32	34	31	29	79	19	11	10	14	23	15	9	0	37	40	14	19	17	13	10	15	22	22	23
Disposal Group, Including Discontinued Operation, Assets, Current
-	-	-	-	-	-	69	54	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Assets Held-for-sale, Not Part of Disposal Group, Current
-	-	-	-	-	-	-	-	-	-	-	-	-	-	55	55	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid expenses and other current assets
8	11	8	11	10	11	6	8	11	10	5	7	5	9	5	10	20	21	19	26	27	23	28	25	29	16	20	22	23	4	20	23	27	22	16	23	27	22	15	16	20
Current assets held for sale (Note 5)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,174	-	-	115	-	-	-	-	-	-
Total current assets
288	376	369	267	326	379	529	474	442	530	452	375	340	373	357	367	272	335	415	401	438	538	585	493	451	522	387	282	225	50	278	1,378	334	460	427	481	319	417	1,015	239	246
Property, plant and equipment
3,676	3,612	3,505	3,354	2,661	2,598	2,505	2,409	2,436	2,285	2,599	2,556	2,572	2,555	2,548	2,538	3,765	3,747	4,324	4,314	4,291	4,273	4,370	4,303	4,183	4,108	3,727	3,854	2,324	1,197	2,160	2,042	2,731	2,671	1,857	2,504	2,444	2,146	1,695	1,720	1,555
Less: accumulated depreciation
743	703	666	630	596	568	543	518	508	464	547	516	491	457	424	390	462	436	507	461	414	380	328	290	245	203	167	126	523	95	450	411	664	625	322	552	516	480	445	418	327
Property, plant and equipment, net
2,932	2,909	2,839	2,724	2,065	2,029	1,961	1,891	1,927	1,820	2,052	2,040	2,080	2,097	2,124	2,148	3,303	3,310	3,817	3,853	3,877	3,893	4,041	4,012	3,938	3,905	3,560	3,728	1,801	1,102	1,710	1,631	2,067	2,046	1,535	1,952	1,928	1,665	1,250	1,302	1,227
Operating lease, right-of-use assets, net
49	53	58	59	61	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Customer accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	194	-	41	42	417	413	39	413	413	409	408	330	277
Other intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	36	-	21	51	161	160	56	160	155	161	160	153	133
Intangible assets
1,076	1,076	1,076	1,080	770	770	770	770	788	788	898	898	898	898	946	946	975	975	1,443	1,441	1,448	1,441	1,477	1,475	1,471	1,466	1,098	1,119	230	845	62	94	578	573	96	573	569	571	568	483	410
Less: accumulated amortization
285	271	256	241	226	216	206	195	203	191	281	268	254	241	240	225	225	206	289	260	235	210	189	161	132	106	84	70	33	49	21	27	212	202	29	184	170	172	162	148	133
Intangible assets, net
790	805	819	838	543	553	564	574	585	597	617	630	643	657	706	721	750	769	1,154	1,180	1,213	1,231	1,288	1,314	1,338	1,360	1,014	1,048	197	795	41	67	365	371	67	389	399	398	406	334	277
Assets held for sale (Note 5)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,146	-	-	-	-	-	-
Goodwill
138	218	218	220	138	138	138	138	147	147	199	199	199	199	249	249	975	1,085	1,600	2,210	2,491	2,491	2,540	2,540	2,548	2,552	2,921	2,452	328	352	165	162	498	501	162	496	496	772	444	463	374
Investments in unconsolidated affiliates
972	980	979	971	1,206	1,188	1,166	1,156	1,162	1,183	1,198	1,181	1,105	1,115	1,099	1,099	260	254	332	324	316	295	231	198	171	151	152	-	-	0	-	-	-	-	-	-	-	-	-	-	-
Other non-current assets
4	5	5	5	5	4	5	5	5	5	6	5	5	6	7	7	8	7	8	9	9	11	29	31	32	31	15	53	13	1	11	1	2	2	1	6	1	1	1	5	7
Total assets
5,177	5,349	5,290	5,087	4,346	4,294	4,366	4,241	4,271	4,284	4,525	4,432	4,374	4,448	4,544	4,593	5,570	5,762	7,328	7,979	8,348	8,461	8,716	8,591	8,480	8,523	8,050	7,565	2,566	2,301	2,207	3,240	3,268	3,381	3,340	3,325	3,145	3,256	3,117	2,345	2,133
Liabilities and capital
Current liabilities:
Accounts payable
118	189	198	161	224	213	321	310	355	349	312	237	193	217	149	164	119	144	165	178	218	241	336	304	317	379	212	151	131	5	120	102	123	144	145	110	97	136	88	63	71
Accrued expenses and other liabilities
158	161	169	127	123	112	114	85	103	105	112	84	78	90	113	101	96	105	118	108	77	154	197	197	183	177	148	115	53	43	93	84	84	79	72	72	72	76	62	69	60
Customer deposits
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	26	44	-	19	18	42	56	29	60
Liabilities from price risk management activities
5	6	4	7	5	5	43	23	10	48	52	8	9	28	14	10	7	7	8	5	8	25	13	8	6	34	31	8	9	0	20	13	5	14	19	16	11	27	24	10	29
Current portion of long-term debt
0	0	0	0	0	0	0	0	0	0	0	1	14	1	0	0	0	1	17	12	36	3	10	29	14	5	4	2	2	0	3	1,188	9	6	3	4	9	16	29	8	22
Liabilities held for sale (Note 5)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	62	-	-	82	-	-	-	-	-	-
Total current liabilities
282	357	372	297	353	332	480	419	470	505	478	331	296	337	278	277	224	258	310	305	341	424	558	538	520	596	396	277	197	48	239	1,450	249	289	322	223	208	299	261	180	243
Long-term debt, less current portion
2,358	2,328	2,267	2,131	1,768	1,752	1,675	1,561	1,467	1,491	1,615	1,613	1,550	1,522	1,576	1,581	2,530	2,501	2,518	2,507	2,442	2,392	2,357	2,260	2,377	2,260	1,827	1,873	1,000	685	739	519	1,671	1,703	1,833	1,781	1,813	1,790	1,661	1,266	1,071
Long-term operating lease liabilities
36	41	45	47	48	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
280	301	225	205	177	173	172	166	165	104	48	47	46	44	38	45	48	47	46	46	48	47	141	142	140	140	204	39	22	17	23	21	20	19	19	16	16	14	14	0	14
Deferred income taxes
2	2	2	2	2	2	3	3	3	3	4	4	4	5	7	7	8	8	9	10	11	12	12	13	13	17	17	20	20	0	20	19	20	20	20	20	20	20	20	-	-
Total liabilities
2,923	2,990	2,913	2,684	-	2,260	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Commitments and contingencies (Note 10)
-	-	-	-	-	-	-	-	-	-	0	0	0	0	0	0	0	0	0	0	0	0	0	-	-	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-
Interest of non-controlling partner in subsidiary
426	426	425	424	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Partners’ capital:
Crestwood Equity Partners LP partners’ capital (73,703,476 and 72,282,942 common and subordinated units issued and outstanding at March 31, 2020 and December 31, 2019)
1,214	1,320	1,340	1,366	1,202	1,240	1,243	1,300	1,373	1,393	1,566	1,643	1,700	1,782	1,900	1,948	2,035	2,227	3,733	692	758	776	762	784	815	831	1,367	1,401	1,076	31	1,046	1,088	1,142	1,189	1,146	1,283	1,086	1,130	53	898	800
Preferred units (71,257,445 units issued and outstanding at both March 31, 2020 and December 31, 2019)
612	612	612	612	612	612	612	612	611	612	612	595	582	564	552	545	537	535	529	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-managing general partner and affiliate
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1	0
Total Crestwood Equity Partners LP partners capital
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,367	1,401	1,076	-	1,046	1,088	1,142	1,189	1,146	1,283	1,086	1,130	53	896	799
Partners' capital
-	-	1,952	1,978	1,814	1,852	1,855	1,912	1,985	2,005	2,178	2,239	2,282	2,346	2,453	2,493	2,573	2,763	4,263	-	-	776	762	784	815	-	5,603	5,356	1,327	31	1,184	1,229	1,307	1,348	1,146	1,283	1,086	1,130	1,160	898	803
Interest of non-controlling partner in subsidiary (Note 9)
-	-	0	0	182	181	180	179	179	175	199	197	194	192	190	187	185	183	181	4,417	4,746	4,808	4,884	4,852	4,613	4,677	4,236	3,954	250	1,519	138	141	164	159	0	-	-	0	1,106	1	4
Total partners’ capital
1,826	1,932	1,952	1,978	1,996	2,033	2,035	2,092	2,164	2,180	2,378	2,436	2,477	2,539	2,643	2,681	2,758	2,946	4,444	5,110	5,504	5,584	5,646	5,637	5,428	5,508	-	-	-	1,550	-	-	-	-	-	-	-	-	-	-	-
Total liabilities and capital
5,177	5,349	5,290	5,087	4,346	4,294	4,366	4,241	4,271	4,284	4,525	4,432	4,374	4,448	4,544	4,593	5,570	5,762	7,328	7,979	8,348	8,461	8,716	8,591	8,480	8,523	8,050	7,565	2,566	2,301	2,207	3,240	3,268	3,381	3,340	3,325	3,145	3,256	3,117	2,345	2,133
Crestwood Midstream Partners LP
Cash
4	25	0	1	0	0	2	5	7	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accounts receivable, less allowance for doubtful accounts of $0.6 million and $0.3 million at March 31, 2020 and December 31, 2019
202	241	258	195	254	249	350	324	384	442	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Inventory
20	53	43	33	42	64	91	73	32	68	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Assets from price risk management activities
52	43	57	25	16	34	7	6	5	7	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid expenses and other current assets
8	11	8	11	10	11	6	8	11	10	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Disposal Group, Including Discontinued Operation, Assets, Current
-	-	-	-	-	-	69	54	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total current assets
288	375	368	265	325	377	526	471	440	530	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Property, plant and equipment
4,006	3,942	3,835	3,684	2,991	2,928	2,835	2,739	2,766	2,615	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Less: accumulated depreciation
918	875	834	794	757	725	697	668	655	607	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Property, plant and equipment, net
3,087	3,067	3,000	2,889	2,234	2,202	2,137	2,071	2,110	2,007	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease, right-of-use assets, net
49	53	58	59	61	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Intangible assets
1,076	1,076	1,076	1,080	770	770	770	770	773	773	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Less: accumulated amortization
285	271	256	241	226	216	206	195	188	177	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Intangible assets, net
790	805	819	838	543	553	564	574	585	595	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Goodwill
138	218	218	220	138	138	138	138	147	147	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in unconsolidated affiliates
972	980	979	971	1,206	1,188	1,166	1,156	1,162	1,183	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other non-current assets
2	2	2	2	2	2	2	2	2	2	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total assets
5,329	5,504	5,448	5,248	4,511	4,462	4,536	4,415	4,448	4,466	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable
115	186	195	159	222	210	319	307	352	346	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued expenses and other liabilities
156	160	168	126	122	111	113	84	102	104	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Liabilities from price risk management activities
5	6	4	7	5	5	43	23	10	48	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Current portion of long-term debt
0	0	0	0	0	0	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total current liabilities
278	353	368	293	349	328	476	415	466	501	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Long-term debt, less current portion
2,358	2,328	2,267	2,131	1,768	1,752	1,675	1,561	1,467	1,491	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Long-term operating lease liabilities
-	-	45	47	48	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
278	295	267	250	222	171	169	163	163	102	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income taxes
0	0	0	0	0	0	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total liabilities
2,916	2,978	2,904	2,675	-	2,252	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest of non-controlling partner in subsidiary
426	-	425	424	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Partners' capital
1,986	2,099	2,118	2,148	1,988	2,028	2,034	2,094	2,171	2,195	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest of non-controlling partner in subsidiary (Note 9)
-	426	-	-	182	181	180	179	179	175	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total liabilities and capital
5,329	5,504	5,448	5,248	4,511	4,462	4,536	4,415	4,448	4,466	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
CMLP
Restricted cash
-	-	0	0	1	16	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Partners' Capital, Including Portion Attributable to Noncontrolling Interest
-	-	2,118	2,148	2,170	2,209	2,214	2,274	2,350	2,370	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-