Magellan Midstream Partners, L.P.
Financial ratios & Valuation

Historical Multiples (2013 – 2022)

2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 TTM Median
Valuation Ratios
Price/Earnings ratio
24.6422.3718.8621.4718.619.7614.0811.7110.3810.1413.6113.61
Price/Sales ratio
7.568.157.067.816.454.615.273.943.733.284.004.61
Price/Book Value ratio
8.21-230.38-160.40-170.26-117.654.93-88.71-52.24-65.79-111.96-149.244.93
Price/Cash Flow ratio
18.5716.9614.4417.8814.609.6310.888.648.529.219.349.63
Price/Free Cash Flow ratio
36.8925.3534.4559.4629.4316.2738.1114.339.7310.8810.6016.27
Price/Earnings Growth ratio
0.720.51-7.73-9.662.250.18-0.59-0.620.440.94-5.580.18
Dividend Yield
3.31%3.02%4.28%4.28%4.96%6.64%6.40%9.68%8.88%8.27%1.87%6.64%
Profitability Indicator Ratios
Gross Profit Margin
62.04%67.16%71.93%69.55%66.81%65.70%68.27%68.18%63.12%55.87%56.97%65.70%
Operating Profit Margin
37.15%42.28%44.03%42.39%41.97%42.26%34.78%31.76%31.39%24.87%32.96%42.26%
Pretax Profit Margin
30.92%36.64%37.53%36.54%34.82%47.19%37.47%33.77%34.19%26.93%29.62%47.19%
Net Profit Margin
30.68%36.44%37.42%36.40%34.67%47.19%37.42%33.65%35.92%32.38%29.55%47.19%
Effective Tax Rate
0.78%0.54%0.28%0.39%0.43%0.00%0.14%0.35%0.24%0.31%0.39%0.39%
Return on Assets
12.07%15.21%13.55%11.85%11.75%17.21%12.09%9.96%12.22%13.44%13.49%11.75%
Return On Equity
33.32%-1029.57%-850.15%-792.93%-632.02%50.47%-629.85%-445.96%-633.54%-1103.72%270.71%-632.02%
Return on Capital Employed
16.85%19.55%18.08%14.86%16.05%16.89%12.21%10.09%11.67%11.40%16.52%16.05%
Liquidity Ratios
Current Ratio
0.620.750.470.760.730.950.680.72N/AN/A1.080.73
Quick Ratio
0.230.450.290.490.510.680.410.420.820.480.480.68
Cash ratio
0.030.030.040.030.210.320.080.020.000.000.180.32
Days of Sales Outstanding
23.6115.8716.1121.7522.3116.6819.9821.9822.6730.1421.4016.68
Days of Inventory outstanding
94.8776.1377.7873.0479.9769.9377.7779.10101.7992.0680.3879.97
Operating Cycle
118.4992.0093.8994.79102.2986.6197.75101.08124.47122.20101.78101.78
Days of Payables Outstanding
38.6746.8761.8741.9945.9852.2363.6847.2639.6527.9633.5352.23
Cash Conversion Cycle
79.8145.1332.0252.8056.3034.3734.0753.8184.8194.2468.2556.30
Debt Ratios
Debt Ratio
0.550.570.560.630.610.550.570.620.650.660.660.61
Debt Equity Ratio
1.53-38.99-35.69-42.57-32.881.61-30.08-28.07-33.94-54.98-54.121.61
Long-term Debt to Capitalization
0.581.021.031.021.030.611.031.031.031.011.010.61
Total Debt to Capitalization
0.601.021.021.021.030.611.031.031.031.011.010.61
Interest Coverage Ratio
6.017.906.215.134.774.975.123.95N/AN/A5.054.77
Cash Flow to Debt Ratio
0.280.340.310.220.240.310.270.210.220.220.290.24
Company Equity Multiplier
2.75-67.66-62.70-66.89-53.742.93-52.06-44.74-51.80-82.08-81.242.93
Cash Flow Ratios
Operating Cash Flow / Sales Ratio
0.400.480.480.430.440.470.480.450.430.350.430.47
Free Cash Flow / Operating Cash Flow Ratio
0.500.660.410.300.490.590.280.600.870.840.870.49
Cash Flow Coverage Ratio
0.280.340.310.220.240.310.270.210.220.220.290.24
Short Term Coverage Ratio
3.095.614.274.314.4122.7450.3840.2246.3636.8170.424.41
Dividend Payout Ratio
81.66%67.75%80.93%92.07%92.37%64.87%90.27%113.48%92.30%83.94%83.00%64.87%