CoverageForm 410-K10-Q8-K13D13G13F

MMP · Magellan Midstream Partners, L.P. - Financials

Annual line items from SEC XBRL filings, sourced from EDGAR's Company Facts API with fallback to the quarterly Financial Statement Data Sets. See issuer overview for Form 4 activity and 10-K signals.

Income Statement

Line itemQ2 '23Q1 '23Q4 '22Q3 '22Q2 '22Q1 '22Q4 '21Q3 '21Q2 '21Q1 '21
Revenue$877.20M$869.70M-$876.10M$847.10M$761.10M-$639.05M$666.41M$687.57M
Cost of Revenue----------
Gross Profit----------
R&D----------
SG&A$74.50M$60.40M-$58.00M$56.90M$62.80M-$46.63M$56.09M$46.58M
Total Operating Expenses$597.60M$570.20M-$522.70M$578.10M$488.10M-$400.44M$429.26M$420.18M
D&A$56.60M$55.80M-$57.90M$58.80M$57.70M-$61.40M$52.26M$58.13M
Operating Income$295.00M$331.50M-$396.40M$240.00M$220.00M-$277.67M$266.88M$279.48M
Interest Expense$57.20M$57.70M-$57.30M$57.80M$57.30M-$57.02M$56.98M$56.98M
Income Tax$1.60M$900.0K-$900.0K$300.0K$800.0K-$821.0K$434.0K$789.0K
Net Income$238.70M$273.90M-$330.00M$353.90M$165.50M-$236.60M$280.42M$221.32M
EPS - Basic----------
EPS - Diluted----------

Balance Sheet

Line itemQ2 '23Q1 '23Q4 '22Q3 '22Q2 '22Q1 '22Q4 '21Q3 '21Q2 '21Q1 '21
Cash & Equivalents$128.40M$7.40M$2.00M$8.10M$4.60M$4.60M$2.00M$12.59M$257.97M$4.07M
Accounts Receivable$169.50M$160.20M$219.90M$179.10M$140.30M$129.80M$135.20M$134.28M$134.12M$142.95M
Inventory----------
Accounts Payable$137.70M$126.90M$108.20M$134.40M$138.80M$98.00M$109.50M$129.09M$122.71M$102.20M
Current Assets$737.30M$598.80M$710.50M$717.60M$669.50M$951.20M$843.20M$799.30M$1.02B$478.14M
Total Assets$7.63B$7.57B$7.71B$7.81B$7.79B$8.11B$8.03B$8.05B$8.29B$8.25B
Current Liabilities$681.10M$618.10M$725.50M$716.80M$688.80M$635.80M$679.60M$657.29M$642.02M$560.76M
Long-term Debt$4.98B$4.98B$5.01B$5.01B$5.00B$5.32B$5.09B$5.10B$4.98B$5.00B
Total Liabilities----------
Stockholders' Equity----------
Retained Earnings----------

Cash Flow

Line itemQ2 '23Q1 '23Q4 '22Q3 '22Q2 '22Q1 '22Q4 '21Q3 '21Q2 '21Q1 '21
Operating Cash Flow-$351.50M---$100.40M---$240.24M
Investing Cash Flow-($44.00M)---($46.60M)---($31.16M)
Financing Cash Flow-($302.40M)---($51.50M)---($218.57M)
CapEx-$44.00M---$44.90M---$29.95M
Free Cash Flow-$307.50M---$55.50M---$210.29M

Ratios

MetricQ2 '23Q1 '23Q4 '22Q3 '22Q2 '22Q1 '22Q4 '21Q3 '21Q2 '21Q1 '21
Profitability
Gross margin----------
Operating margin33.6%38.1%-45.2%28.3%28.9%-43.4%40.0%40.6%
EBITDA margin40.1%44.5%-51.9%35.3%36.5%-53.1%47.9%49.1%
Net margin27.2%31.5%-37.7%41.8%21.7%-37.0%42.1%32.2%
Free cash flow margin-35.4%---7.3%---30.6%
FCF / Net income-1.12---0.34---0.95
R&D / Revenue----------
SG&A / Revenue8.5%6.9%-6.6%6.7%8.3%-7.3%8.4%6.8%
Effective tax rate0.7%0.3%-0.3%0.1%0.5%-0.3%0.2%0.4%
Return on assets3.1%3.6%-4.2%4.5%2.0%-2.9%3.4%2.7%
Return on equity----------
Return on invested capital----------
Liquidity
Current ratio1.080.970.981.000.971.501.241.221.590.85
Quick ratio1.080.970.981.000.971.501.241.221.590.85
Cash ratio0.190.010.000.010.010.010.000.020.400.01
Leverage
Debt / Equity----------
Debt / Assets0.650.660.650.640.640.660.630.630.600.61
Debt / EBITDA14.1812.87-11.0316.7419.15-15.0515.6014.80
Interest coverage5.2x5.7x-6.9x4.2x3.8x-4.9x4.7x4.9x
Equity multiplier----------
Liabilities / Assets----------
Efficiency
Asset turnover0.110.11-0.110.110.09-0.080.080.08
Inventory turnover----------
Days sales outstanding71d67d-75d60d62d-77d73d76d
Days inventory outstanding----------
Days payable outstanding----------
Cash conversion cycle----------
Valuation
P / E----------
P / B----------
P / S----------
EV / EBITDA----------
Growth
Revenue growth (YoY)3.6%14.3%-37.1%27.1%10.7%-6.8%44.7%-12.2%
Revenue CAGR (3y)24.0%3.6%-10.1%6.5%5.2%-0.1%0.6%0.4%
Revenue CAGR (5y)6.0%5.1%-8.9%6.5%3.5%-3.0%5.1%5.8%
Gross profit growth (YoY)----------
Operating income growth (YoY)22.9%50.7%-42.8%-10.1%-21.3%-4.2%33.0%-14.5%
Net income growth (YoY)-32.6%65.5%-39.5%26.2%-25.2%-11.8%109.5%-23.0%
EPS growth (YoY)----------
EPS CAGR (3y)----------
EPS CAGR (5y)----------
FCF growth (YoY)-454.1%----73.6%----0.8%
FCF CAGR (5y)-11.5%----14.8%---24.6%
Book value growth (YoY)----------

Sales by segment

From XBRL dimensional facts in the 10-K period ending 2021-12-31.

Business segments

$2.74B total
Refined Products Segment$2.11B · 77.0%
Crude Oil Pipelineand Terminals Segment$630.10M · 23.0%

Product / service

$4.07B total
Service$1.80B · 44.2%
Transportation$915.70M · 22.5%
Product$913.00M · 22.4%
Storage$177.10M · 4.3%
Ancillary Services$125.20M · 3.1%
Terminalling$100.10M · 2.5%
Product And Service Other$21.20M · 0.5%
Lease Revenue$20.40M · 0.5%

Peer comparison

Same SIC group: Pipe Lines (No Natural Gas)

CompanyRevenue (last FY)Net marginROE
MPLX$13.00B37.8%-
DKL$1.01B17.4%-
DINO$26.87B2.2%6.3%
GEL$1.63B-27.0%-
NS---

Comparing Magellan Midstream Partners against the 5 most active filers in the same SIC group.