Magellan Midstream Partners, L.P.
Magellan Midstream Partners, L.P. engages in the transportation, storage, and distribution of refined petroleum products and crude oil in the United States. It operates through Refined Products and Crude Oil segments. The company operates refined product…
Oil & Gas Midstream
US, Tulsa [HQ]
Ratios
14 Sheets · Starting from 2022Margins, Growth Rates In %
| Ratio | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Profitability | |||||||||||||||
| Gross Margin | 46.96 | 38.95 | 42.09 | 55.69 | 62.04 | 67.17 | 71.94 | 69.55 | 66.81 | 65.70 | 68.28 | 68.19 | 63.12 | 55.87 | |
| Profit Margin | 12.50 | 20.03 | 23.65 | 24.59 | 30.68 | 36.44 | 37.43 | 36.40 | 34.67 | 47.19 | 37.42 | 33.65 | 35.93 | 32.38 | |
| Operating Margin | 29.09 | 26.22 | 29.90 | 31.15 | 37.16 | 42.29 | 44.03 | 42.40 | 41.98 | 42.26 | 34.79 | 31.77 | 31.40 | 24.88 | |
|
EPS Growth
|
58.57 | 27.93 | 28.87 | 4.92 | 33.85 | 43.58 | -2.44 | -2.22 | 8.24 | 53.28 | -23.63 | -18.83 | 23.48 | 10.74 | |
| EPS USD | 111.00 | 142.00 | 183.00 | 192.00 | 257.00 | 369.00 | 360.00 | 352.00 | 381.00 | 584.00 | 446.00 | 362.00 | 447.00 | 495.00 | |
| Return on Assets (ROA) | 4.01 | 8.39 | 10.23 | 9.86 | 12.08 | 15.22 | 13.56 | 11.85 | 11.76 | 17.22 | 12.10 | 9.97 | 12.23 | 13.45 | |
| Return on Equity (ROE) | -1,584.13 | -2,811.62 | -876.31 | -1,242.71 | -2,985.22 | -1,029.58 | -850.15 | -792.93 | -632.03 | 50.47 | -629.85 | -445.97 | -633.55 | -1,103.73 | |
| Return on Invested Capital (ROIC) | 16.33 | 19.84 | 22.83 | 21.50 | 26.24 | 31.27 | 28.74 | 22.13 | 23.89 | 17.28 | 19.40 | 14.99 | 16.21 | 15.21 | |
| Solvency | |||||||||||||||
| Equity Ratio | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | |
| Debt/Assets | 56.95 | 55.43 | 57.55 | 58.54 | 55.70 | 57.64 | 56.93 | 63.65 | 61.19 | 55.13 | 57.79 | 62.75 | 65.53 | 66.98 | |
| Debt/Equity | -22,512.67 | -18,572.63 | -4,931.52 | -7,380.57 | -13,767.88 | -3,899.89 | -3,569.92 | -4,257.70 | -3,288.67 | 161.59 | -3,008.64 | -2,807.85 | -3,394.77 | -5,498.30 | |
| Debt/EBITDA | 422.88 | 309.42 | 300.66 | 375.43 | 378.40 | 307.38 | 353.13 | 418.64 | 414.14 | 342.36 | 403.15 | 498.18 | 484.34 | 473.91 | |
|
Debt/Capitalization
|
100.45 | 100.54 | 102.07 | 101.37 | 100.73 | 102.63 | 102.88 | 102.41 | 103.14 | 61.77 | 103.44 | 103.69 | 103.04 | 101.85 | |
| Long-Term Debt/Capitalization | 100.48 | 100.59 | 102.24 | 101.49 | 100.81 | 102.81 | 103.12 | 102.54 | 103.33 | 61.44 | 103.46 | 103.71 | 103.05 | 101.86 | |
| Interest Debt per Share USD | 16.39 | 10.29 | 10.78 | 11.92 | 12.35 | 14.52 | 15.75 | 19.64 | 20.68 | 19.58 | 22.19 | 23.80 | 24.97 | 25.72 | |
| Debt Growth | 55.06 | 13.46 | 12.89 | 11.23 | 12.20 | 11.08 | 15.31 | 18.83 | 10.70 | -5.61 | 14.18 | 5.48 | 2.30 | -1.88 | |
| Liquidity | |||||||||||||||
| Current Ratio | 141.23 | 139.82 | 196.81 | 178.36 | 62.16 | 75.10 | 47.52 | 76.90 | 73.14 | 95.53 | 68.89 | 72.54 | 124.07 | 97.93 | |
| Quick Ratio | 37.21 | 38.48 | 97.15 | 109.96 | 23.19 | 21.87 | 17.58 | 30.34 | 39.38 | 51.36 | 31.09 | 28.51 | 25.28 | 36.71 | |
| Cash Ratio | 1.82 | 2.72 | 67.39 | 83.61 | 3.95 | 3.18 | 4.03 | 3.05 | 21.05 | 32.26 | 8.70 | 2.33 | 0.29 | 0.28 | |
| Operating Cash Flow Ratio | 100 | 100 | 100 | 100 | 100 | 200 | 100 | 200 | 100 | 100 | 100 | 100 | 100 | 100 | |
| Turnover | |||||||||||||||
| Inventory Turnover | 278.72 | 439.35 | 391.21 | 353.84 | 384.70 | 479.41 | 469.24 | 499.70 | 456.41 | 521.92 | 469.32 | 461.44 | 358.56 | 396.46 | |
| Receivables Turnover | 1,249.07 | 1,583.30 | 1,888.90 | 1,713.09 | 1,545.82 | 2,299.68 | 2,265.62 | 1,677.76 | 1,635.36 | 2,188.24 | 1,826.80 | 1,660.48 | 1,609.60 | 1,210.90 | |
| Payables Turnover | 1,451.38 | 2,295.23 | 1,525.50 | 700.99 | 943.66 | 778.67 | 589.93 | 869.25 | 793.74 | 698.74 | 573.15 | 772.22 | 920.46 | 1,305.18 | |
|
Asset Turnover
|
32.06 | 41.89 | 43.23 | 40.09 | 39.36 | 41.75 | 36.22 | 32.57 | 33.91 | 36.48 | 32.33 | 29.62 | 34.04 | 41.52 | |
| Fixed Turnover | 36.47 | 49.00 | 53.81 | 51.14 | 48.45 | 53.21 | 45.41 | 41.80 | 45.16 | 48.75 | 41.48 | 37.77 | 44.96 | 53.52 | |
| Coverage | |||||||||||||||
| Interest Coverage | 415.70 | 211.87 | 494.72 | 493.85 | 607.16 | 806.98 | 667.08 | 560.54 | 539.48 | 586.95 | 470.19 | 346.04 | 379.02 | 349.21 | |
| Asset Coverage | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | |
| Cash Flow Coverage (CFGR) | 14.96 | 20.61 | 24.80 | 24.93 | 28.78 | 34.82 | 31.10 | 22.36 | 24.50 | 31.68 | 27.09 | 21.53 | 22.73 | 22.11 | |
| EBITDA Coverage | 500 | 300 | 600 | 400 | 600 | 700 | 600 | 500 | 500 | 500 | 500 | 400 | 400 | 400 | |
| Dividend Coverage | - - | - - | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | - - | -100 | -100 | |
| Time Interest Earned (TIE) | 200 | 200 | 300 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Market Prospects | |||||||||||||||
| Dividend Yield | 11.55 | 5.15 | 4.51 | 4.13 | 3.31 | 3.03 | 4.29 | 4.29 | 4.96 | 6.64 | 6.41 | 9.69 | 8.88 | 8.27 | |
| Earnings Yield | 5.12 | 5.04 | 5.32 | 4.46 | 4.06 | 4.47 | 5.30 | 4.66 | 5.37 | 10.23 | 7.10 | 8.54 | 9.62 | 9.85 | |
|
Price/Earnings (P/E)
|
1,952.56 | 1,982.81 | 1,879.03 | 2,244.10 | 2,464.88 | 2,237.63 | 1,886.80 | 2,147.32 | 1,861.56 | 977.74 | 1,409.09 | 1,171.44 | 1,039.46 | 1,015.44 | |
| Price/Earnings Growth (PEG) | 33.34 | 71.00 | 65.08 | 456.30 | 72.81 | 51.35 | -773.59 | -966.29 | 225.95 | 18.35 | -59.63 | -62.20 | 44.27 | 94.56 | |
|
Price/Book (P/B)
|
-30,931.05 | -55,748.94 | -16,466.20 | -27,887.72 | -73,582.19 | -23,038.16 | -16,040.68 | -17,026.74 | -11,765.55 | 493.47 | -8,875.20 | -5,224.20 | -6,585.49 | -11,207.68 | |
| Price/Tangible Book (P/TB) | -30,931.05 | -55,748.94 | -16,466.20 | -27,887.72 | -73,582.19 | -23,038.16 | -16,040.68 | -17,026.74 | -11,765.55 | 493.47 | -8,875.20 | -5,224.20 | -6,585.49 | -11,207.68 | |
| Price/Sales (P/S) | 244.02 | 397.18 | 444.46 | 551.72 | 756.29 | 815.43 | 706.22 | 781.63 | 645.49 | 461.42 | 527.31 | 394.19 | 373.48 | 328.83 | |
|
Price/Cash Flow (P/CF)
|
918.51 | 1,456.69 | 1,346.25 | 1,515.58 | 1,857.31 | 1,696.50 | 1,444.83 | 1,788.10 | 1,460.01 | 964.00 | 1,088.77 | 864.22 | 853.33 | 922.11 | |
| Price/Free CF (P/FCF) | 4,692.53 | 3,043.69 | 2,159.84 | 3,360.64 | 3,689.86 | 2,535.62 | 3,445.66 | 5,946.59 | 2,943.01 | 1,628.89 | 3,813.65 | 1,433.09 | 974.37 | 1,089.44 | |
| Price/Operating CF (P/OCF) | 918.51 | 1,456.69 | 1,346.25 | 1,515.58 | 1,857.31 | 1,696.50 | 1,444.83 | 1,788.10 | 1,460.01 | 964.00 | 1,088.77 | 864.22 | 853.33 | 922.11 |