Magellan Midstream Partners, L.P. MMP Balance Sheet

Magellan midstream partners, l.p. (MMP)

Balance Sheet / 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	Dec'09
ASSETS
Current assets:
Cash and cash equivalents
139	58	135	3	13	218	217	2	74	160	1	5	7	14	291	34	209	28	9	29	52	17	14	0	196	25	14	119	221	328	100	233	151	209	198	12	28	7	77	35	4
Trade accounts receivable
94	125	131	139	134	104	137	106	105	138	128	113	82	105	126	93	89	83	113	84	96	84	106	91	101	116	107	86	110	91	106	82	103	82	89	70	86	92	87	64	72
Other accounts receivable
20	23	22	25	31	25	24	21	24	14	13	12	13	25	24	19	19	12	11	12	15	15	11	11	12	6	6	8	9	12	8	11	12	10	6	18	20	6	3	15	8
Energy Related Inventory
71	184	205	172	195	185	179	183	195	182	168	119	146	134	123	156	132	130	135	159	160	157	202	188	210	187	208	207	205	221	220	215	240	258	257	285	224	216	203	208	193
Commodity derivatives contracts, net
61	0	4	0	0	55	-	-	-	0	1	4	0	-	0	7	17	39	49	0	36	87	27	-	-	0	8	4	-	-	0	13	-	4	36	-	-	-	0	6	-
Energy commodity derivatives contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8	28	-	0	0	9
Good Faith and Margin Deposits with Broker-Dealers
0	27	21	27	23	0	47	35	26	36	31	4	9	49	30	28	2	0	0	5	1	6	0	29	12	14	10	11	14	18	37	8	41	26	-	43	47	22	7	0	17
Reimbursable costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1	3	-	7	5	4	5	7	7	7	13	11	10	13
Other current assets
39	40	45	38	39	58	66	75	66	63	62	66	42	39	52	46	43	43	39	40	31	34	39	36	33	46	31	24	21	28	19	21	12	13	11	19	12	11	9	9	14
Total current assets
426	459	567	407	438	646	672	425	493	596	407	325	302	370	648	385	515	338	358	332	395	402	401	358	567	396	387	464	585	700	500	591	566	612	607	458	428	384	401	350	323
Property, plant and equipment
8,166	8,431	8,248	8,024	7,808	7,628	7,570	7,443	7,346	7,235	7,121	7,048	6,905	6,783	6,657	6,470	6,302	6,166	5,998	5,832	5,642	5,533	5,174	5,089	5,017	4,986	4,764	4,581	4,495	4,408	4,287	4,173	4,105	4,080	4,027	3,996	3,948	3,881	3,868	3,517	3,398
Less: accumulated depreciation
1,919	2,027	1,983	1,935	1,883	1,830	1,835	1,783	1,732	1,682	1,638	1,592	1,545	1,507	1,471	1,428	1,388	1,347	1,317	1,278	1,243	1,204	1,182	1,146	1,104	1,070	1,039	1,005	974	943	910	883	853	830	801	771	743	716	690	663	617
Net property, plant and equipment
6,247	6,404	6,264	6,089	5,925	5,798	5,734	5,660	5,614	5,552	5,483	5,456	5,360	5,275	5,186	5,041	4,913	4,819	4,680	4,553	4,399	4,329	3,991	3,942	3,913	3,916	3,725	3,575	3,520	3,465	3,376	3,289	3,252	3,249	3,225	3,225	3,205	3,165	3,178	2,853	2,780
Investments in and Advance to Affiliates, Subsidiaries, Associates, and Joint Ventures
1,190	1,240	1,206	1,165	1,128	1,076	1,005	1,210	1,126	1,082	1,066	976	976	931	912	850	800	765	753	666	636	613	736	645	487	360	291	207	155	107	73	51	39	35	31	27	25	23	23	22	22
Operating Lease, Right-of-Use Asset
165	171	162	167	172	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Long-term receivables
21	20	20	21	20	20	23	23	24	27	27	22	23	23	22	18	20	20	22	25	27	28	29	30	30	2	3	2	4	5	3	3	2	2	3	1	1	1	1	1	0
Goodwill
52	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	39	39	53	14	14	14
Other intangibles (less accumulated amortization of $6,255 and $6,923 at December 31, 2019 and March 31, 2020, respectively)
47	47	48	49	49	51	51	52	52	52	52	52	51	51	52	52	44	1	2	3	3	4	5	5	6	7	7	8	9	13	13	14	14	15	15	16	17	16	13	13	5
Restricted cash
10	26	56	28	37	90	42	101	-	15	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	14	-	-	-
Debt placement costs (less accumulated amortization of $8,952 and $10,819 at December 31, 2014 and September 30, 2015, respectively)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20	21	22	-	18	19	19	17	13	14	14	15	13	13	14	14	12	11	11	11	12	10	10
Tank bottoms
-	-	-	-	-	-	-	-	-	-	-	-	-	-	35	35	28	-	36	47	38	42	64	67	62	61	63	59	60	58	58	55	64	59	51	63	65	57	-	-	-
Other noncurrent assets
23	13	12	24	19	10	12	11	12	13	12	43	62	65	10	11	15	42	38	28	28	26	10	1	3	4	3	2	1	1	13	3	2	2	3	4	3	3	5	9	4
Total assets
8,185	8,437	8,392	8,005	7,844	7,747	7,595	7,538	7,376	7,394	7,103	6,930	6,829	6,772	6,919	6,448	6,392	6,041	5,966	5,732	5,605	5,501	5,311	5,124	5,143	4,820	4,548	4,388	4,405	4,420	4,105	4,074	4,009	4,045	4,006	3,849	3,796	3,717	3,650	3,276	3,163
LIABILITIES AND PARTNERS’ CAPITAL
Current liabilities:
Accounts payable
147	150	205	179	192	138	137	125	129	104	120	103	91	77	101	118	102	104	123	95	91	97	84	72	73	76	83	81	111	112	98	67	48	66	68	48	46	41	56	46	37
Accrued payroll and benefits
31	75	56	47	31	70	53	45	29	56	40	40	27	45	39	36	34	51	48	33	31	48	41	30	27	42	38	28	21	32	29	21	16	30	24	25	19	32	28	22	30
Accrued interest payable
47	64	48	57	46	63	49	70	52	70	42	65	42	65	48	62	47	51	45	52	45	45	44	45	50	44	37	41	37	42	33	40	33	40	33	36	31	35	31	30	32
Accrued taxes other than income
46	66	63	48	41	53	52	41	34	51	49	43	39	50	53	45	40	51	54	46	42	47	45	34	31	38	38	30	27	33	31	24	21	27	28	23	20	26	25	19	21
Environmental liabilities
-	-	7	4	6	-	10	5	9	6	9	6	9	10	11	15	16	15	16	14	11	10	12	12	13	12	14	11	15	14	16	12	16	17	18	17	13	12	12	11	11
Deferred revenue
113	109	107	111	118	121	121	120	119	117	116	115	107	101	98	98	95	81	75	71	75	71	70	69	64	63	67	54	57	46	45	41	41	39	36	30	35	34	31	28	27
Accrued product liabilities
52	90	108	76	94	75	80	64	85	96	119	46	37	51	25	22	21	31	20	21	37	44	54	37	43	63	69	49	78	72	70	55	67	59	58	46	84	47	29	39	36
Commodity derivatives contracts, net
0	10	-	9	13	0	32	27	16	25	14	0	0	30	12	-	-	0	0	2	0	5	0	11	3	6	0	0	5	7	12	-	4	0	-	-	-	11	-	-	-
Commodity derivatives deposits
50	0	0	0	0	37	-	-	-	0	-	0	-	-	0	0	6	24	49	0	31	84	-	-	-	0	-	-	-	-	-	17	-	-	7	-	-	-	0	2	-
Operating Lease, Liability, Current
26	26	22	22	23	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Current portion of long-term debt, net
550	0	0	0	0	59	552	250	250	250	251	-	-	0	250	250	250	250	-	-	-	0	0	0	249	249	249	249	-	0	-	-	-	-	-	-	-	-	-	-	-
Contingent liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15	-	-	-	-	-
Other current liabilities
72	73	59	60	54	57	37	33	61	56	44	36	40	48	43	64	61	51	34	44	50	80	40	31	47	41	43	33	28	32	31	19	21	28	22	21	39	32	21	15	22
Total current liabilities
1,139	666	680	618	623	676	1,127	782	788	836	809	456	397	481	683	713	679	713	468	383	418	536	393	346	604	638	641	579	382	392	369	299	272	311	296	273	319	275	236	217	229
Operating Lease, Liability, Noncurrent
139	144	135	146	148	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Long-term debt, net
4,155	4,706	4,705	4,407	4,279	4,211	3,718	4,392	4,272	4,273	4,051	4,231	4,203	4,087	4,073	3,574	3,552	3,189	3,407	3,326	3,183	2,967	3,003	2,910	2,691	2,435	2,236	2,140	2,391	2,393	2,146	2,148	2,150	2,151	2,153	2,042	1,967	1,906	1,892	1,779	1,680
Long-term pension and benefits
145	145	131	133	124	122	125	127	131	111	66	68	70	71	70	81	84	77	68	79	80	75	41	54	55	51	63	71	72	68	61	69	71	67	42	31	31	28	27	24	22
Other noncurrent liabilities
61	59	55	48	40	93	64	69	34	30	29	27	27	25	29	26	23	24	24	23	23	29	29	28	19	21	20	17	15	16	21	15	23	19	12	22	23	17	12	9	12
Environmental liabilities
-	-	8	12	11	-	13	11	9	13	10	12	15	13	14	13	15	15	14	21	24	25	25	21	23	26	23	24	31	33	35	31	30	31	24	22	21	20	20	18	22
Commitments and contingencies
-	-	-	-	-	-	0	0	0	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-	0	-	-	-
Partners' Capital [Abstract]
Common unitholders (228,403 units and 225,056 units outstanding at December 31, 2019 and March 31, 2020, respectively)
2,713	2,877	2,822	2,774	2,739	2,763	2,665	2,281	2,271	2,267	2,229	2,230	2,212	2,193	2,166	2,154	2,145	2,118	2,076	1,989	1,970	1,949	1,841	1,784	1,772	1,666	1,597	1,589	1,547	1,550	1,500	1,553	1,508	1,510	1,487	1,463	1,444	1,466	1,457	1,222	1,204
Accumulated other comprehensive loss
-169	-162	-147	-136	-122	-120	-118	-127	-132	-137	-94	-96	-96	-101	-117	-115	-108	-96	-94	-92	-96	-81	-23	-21	-23	-19	-34	-34	-34	-35	-29	-42	-46	-47	-10	-6	-11	-11	-9	-6	-8
Partners' Capital
2,543	2,715	2,674	2,637	2,616	2,643	2,547	2,154	2,139	2,129	2,135	2,134	2,116	2,092	2,048	2,038	2,037	2,021	1,982	1,896	1,873	1,868	1,818	1,763	1,749	1,647	1,563	1,555	1,512	1,515	1,471	1,511	1,461	1,463	1,476	1,457	1,433	1,455	1,448	1,215	1,196
Non-controlling owners' interest in consolidated subsidiaries
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	14	13	11	-
Total owners' equity
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,476	1,457	1,433	1,469	1,461	1,226	1,196
Total liabilities and partners’ capital
8,185	8,437	8,392	8,005	7,844	7,747	7,595	7,538	7,376	7,394	7,103	6,930	6,829	6,772	6,919	6,448	6,392	6,041	5,966	5,732	5,605	5,501	5,311	5,124	5,143	4,820	4,548	4,388	4,405	4,420	4,105	4,074	4,009	4,045	4,006	3,849	3,796	3,717	3,650	3,276	3,163