| Company Name: | Magellan Midstream Partners LP | | Ticker Symbol: | MMP | | | WWW Address: | www.magellanlp.com | | CEO: | Don R. Wellendorf | | No. of Employees: | 1,204 | | Common Issue Type: | CS | | Business Description: | The Company is mainly engaged in the transportation, storage and distribution of refined petroleum products.
|
| | | Industry Information: | ENERGY - Oil & Gas Pipelines [more like this] |
|
| Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 39.5 |  -0.24 | 37.62 | 46.99 | 39.4 | 39.75 | 39.25 | 211294 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 4,210.7 | 106.6 | 0.23 | 3.27 | 2.72 | 19.4 | 7.2 | 40.20 - 24.07 |
|
| KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 39.50 | $ | | PE Ratio - LTM | 19.4 | |
| Market Capitalisation | 4,210.2 | mil |
| Latest Shares Outstanding | 106.6 | mil |
| Earnings pS (EPS) | 3.27 | $ |
| Dividend pS (DPS) | 2.72 | ¢ |
| Dividend Yield | 7.2 | % |
| Dividend Payout Ratio | 83 | % |
| Revenue per Employee | 1,007,297 | $ |
| Effective Tax Rate | 0.6 | % |
| Float | 66.4 | mil |
| Float as % of Shares Outstanding | 99.1 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 8.00 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 48.7 | % |
| EBITDA Margin | 40.7 | % |
| Pre-Tax Profit Margin | 22.6 | % |
| Assets Turnover | 0.4 | % |
| Return on Assets (ROA) | 5.8 | % |
| Return on Equity (ROE) | 15.2 | % |
| Return on Capital Invested (ROCI) | 6.4 | % |
| Current Ratio | 1.4 | |
| Leverage Ratio (Assets/Equity) | 2.6 | |
| Interest Cover | 3.7 | |
| Total Debt/Equity (Gearing Ratio) | 1.38 | |
| LT Debt/Total Capital | 58.0 | % |
| Working Capital pS | 0.74 | $ |
| Cash pS | 0.03 | $ |
| Book-Value pS | 11.08 | $ |
| Tangible Book-Value pS | 10.90 | $ |
| Cash Flow pS | 2.34 | $ |
| Free Cash Flow pS | -4.11 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 3.56 | |
| Price/Tangible Book Ratio | 3.62 | |
| Price/Cash Flow | 16.9 | |
| Price/Free Cash Flow | -9.6 | |
| P/E as % of Industry Group | 4,209.0 | % |
| P/E as % of Sector Segment | 51.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 10/22/2009 |
| Dividend Ex-Date | 11/03/2009 |
| Dividend Record Date | 11/05/2009 |
| Dividend Pay Date | 11/12/2009 |
| Dividend Amount | 710 |
| Type of Payment | Cash Payment |
| Dividend Rate | 2.84 |
| Current Dividend Yield | 7.2 |
| 5-Y Average Dividend Yield | 6.8 |
| Payout Ratio | 83.0 |
| 5-Y Average Payout Ratio | 96.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | |
| |
| PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | -0.7 | 100 | 3,662 | 13,654 |
| 4 Weeks | 40.15 | 37.81 | 39.30 | 0.5 | 99 | 3,196 | 63,925 |
| 13 Weeks | 40.20 | 35.29 | 37.15 | 6.3 | 100 | 2,821 | 180,536 |
| 26 Weeks | 40.20 | 31.81 | 33.39 | 18.3 | 96 | 2,451 | 311,293 |
| 52 Weeks | 40.20 | 24.07 | 23.90 | 65.3 | 121 | 3,049 | 765,364 |
| YTD | 40.20 | 25.36 | - | 30.8 | 108 | 3,133 | 704,814 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 39.80 | 39.46 | 38.64 | 36.42 | 34.89 | 0.23 | 0.23 |
|
| |
| GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 8.56 | 33.8 | -5.69 |
| Income | 8.82 | 47.5 | 3.11 |
| Dividend | 10.68 | 96.8 | 7.31 |
| Capital Spending | 40.53 | NA | 23.73 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 5.63 | NA | 3.06 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -27.5 | -17.9 | -8.0 |
| Earnings % | -82.8 | -75.2 | 42.8 |
| EPS % | -54.7 | -42.7 | 25.8 |
| EPS $ | -1.34 | -0.32 | 0.67 |
|
| |
| SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -1.29 |
| Current Ratio | 0.8 |
| Quick Ratio (Acid Test) | 0.4 |
| Liquidity Ratio (Cash) | 0.17 |
| Receivables Turnover | 19.8 |
| Average Collection Period | 18 |
| Working Capital/Equity | -3.1 |
| Working Capital pS | -0.44 |
| Cash-Flow pS | 6.25 |
| Free Cash-Flow pS | -2.12 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 3.32 |
| Financial Leverage Ratio (Assets/Equity) | 2.4 |
| Debt Ratio | 58.4 |
| Total Debt/Equity (Gearing Ratio) | 1.13 |
| LT Debt/Equity | 1.13 |
| LT Debt/Capital Invested | 56.2 |
| LT Debt/Total Liabilities | 80.8 |
| Interest Cover | 7.7 |
| Interest/Capital Invested | 2.47 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 772.65 |
| Tobin's Q Ratio | 1.83 |
| Current P/E Ratio - LTM | 19.40 |
| Enterprise Value (EV)/EBITDA | 12.54 |
| Enterprise Value (EV)/Free Cash Flow | -37.96 |
| Dividend Yield | 7.2 |
| Price/Tangible Book Ratio - LTM | 3.62 |
| Price/Book Ratio - LTM | 3.56 |
| Price/Cash Flow Ratio | 16.9 |
| Price/Free Cash Flow Ratio - LTM | -9.6 |
| Price/Sales Ratio | 4.38 |
| P/E Ratio (1 month ago) - LTM | 19.5 |
| P/E Ratio (26 weeks ago) - LTM | 12.3 |
| P/E Ratio (52 weeks ago) - LTM | 7.5 |
| 5-Y High P/E Ratio | 20.5 |
| 5-Y Low P/E Ratio | 5.8 |
| 5-Y Average P/E Ratio | 15.2 |
| Current P/E Ratio as % of 5-Y Average P/E | 127 |
| P/E as % of Industry Group | 4,209.0 |
| P/E as % of Sector Segment | 51.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 19.4 |
| PER SHARE FIGURES |
| LT Debt pS | 16.19 |
| Current Liabilities pS | 2.92 |
| Tangible Book Value pS - LTM | 10.90 |
| Book Value pS - LTM | 11.08 |
| Capital Invested pS | 19.13 |
| Cash pS - LTM | 0.03 |
| Cash Flow pS - LTM | 2.34 |
| Free Cash Flow pS - LTM | -4.11 |
| Earnings pS (EPS) | 3.27 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | -11.71 |
| Free Cash Flow Margin 5YEAR AVG | -3.64 |
| Net Profit Margin | 28.6 |
| Net Profit Margin - 5YEAR AVRG. | 18.8 |
| Equity Productivity | 1.27 |
| Return on Equity (ROE) | 36.3 |
| Return on Equity (ROE) - 5YEAR AVRG. | 24.9 |
| Capital Invested Productivity | 0.59 |
| Return on Capital Invested (ROCI) | 17.0 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 12.6 |
| Assets Productivity | 0.60 |
| Return on Assets (ROA) | 15.1 |
| Return on Assets (ROA) - 5YEAR AVRG. | 10.5 |
| Gross Profit Margin | 48.7 |
| Gross Profit Margin - 5YEAR AVRG. | 34.2 |
| EBITDA Margin - LTM | 40.7 |
| EBIT Margin - LTM | 29.7 |
| Pre-Tax Profit Margin | 28.7 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 18.9 |
| Effective Tax Rate | 0.6 |
| Effective Tax Rate - 5YEAR AVRG. | 0.2 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 58 |
| Revenue per Employee | 1,007,297 |
| Net Income per Employee | 287,885 |
| Average Collection Period | 15 |
| Receivables Turnover | 19.8 |
| Day's Inventory Turnover Ratio | 43 |
| Inventory Turnover | 8.4 |
| Inventory/Sales | 3.9 |
| Accounts Payble/Sales | 3.41 |
| Assets/Revenue | 1.67 |
| Net Working Capital Turnover | -40.87 |
| Fixed Assets Turnover | 0.57 |
| Total Assets Turnover | 0.6 |
| Revenue per $ Cash | 36.48 |
| Revenue per $ Plant | 0.59 |
| Revenue per $ Common Equity | 1.27 |
| Revenue per $ Capital Invested | 0.59 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 5.8 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 5.9 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
|
| |
 |  |