Magellan Midstream Financial Statements Trends

Magellan Midstream Partners L P -- USA Stock  

USD 68.52  0.61  0.88%

This module enables investors to look at Magellan Midstream various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 944.4 M, Cost of Revenue of 1.2 B or Earning Before Interest and Taxes EBIT of 1.2 B, but also many exotic indicators such as Asset Turnover of 0.3906, Book Value per Share of 10.7965 or Current Ratio of 0.71. This module is a perfect complement to use when analyzing Magellan Midstream Valuation or Volatility. It can also complement various Magellan Midstream Technical models. Please see also Stocks Correlation.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(119.1 M)(101.2 M)(94.4 M)
Decreasing
Slightly volatile
Total Assets6 B6.8 B6.2 B
Increasing
Slightly volatile
Current Assets338.9 M370.4 M352.3 M
Increasing
Slightly volatile
Assets Non Current7.5 B6.4 B6 B
Increasing
Slightly volatile
Cash and Equivalents18.1 M14.7 M23.7 M
Decreasing
Slightly volatile
Cash and Equivalents USD17.3 M14.7 M23.7 M
Decreasing
Slightly volatile
Total Debt4.2 B4.1 B3.8 B
Increasing
Slightly volatile
Debt Current2.3 M2 M2.5 M
Decreasing
Slightly volatile
Debt Non Current4.8 B4.1 B3.9 B
Increasing
Slightly volatile
Total Debt USD4.8 B4.1 B3.9 B
Increasing
Slightly volatile
Deferred Revenue119.9 M101.9 M95.8 M
Increasing
Slightly volatile
Shareholders Equity2.5 B2.1 B2 B
Increasing
Slightly volatile
Shareholders Equity USD2.5 B2.1 B2 B
Increasing
Slightly volatile
Goodwill and Intangible Assets123.8 M105.2 M100.8 M
Increasing
Slightly volatile
Inventory158.1 M134.4 M126.6 M
Increasing
Slightly volatile
Investments893.1 M931.3 M326.2 M
Increasing
Slightly volatile
Investments Current103.3 M87.8 M89.1 M
Increasing
Slightly volatile
Investments Non Current893.1 M931.3 M318.8 M
Increasing
Slightly volatile
Total Liabilities5.5 B4.7 B4.4 B
Increasing
Slightly volatile
Current Liabilities713.1 M481.7 M469.7 M
Increasing
Slightly volatile
Liabilities Non Current4.9 B4.2 B4 B
Increasing
Slightly volatile
Trade and Non Trade Payables168.1 M142.9 M135.7 M
Increasing
Slightly volatile
Property Plant and Equipment Net6.2 B5.3 B5 B
Increasing
Slightly volatile
Trade and Non Trade Receivables182.7 M155.3 M150.2 M
Increasing
Slightly volatile
Tax Liabilities59 M50.2 M47.9 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income944.4 M802.8 M755 M
Increasing
Slightly volatile
Cost of Revenue1.2 B1 B974.9 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT1.2 B1 B941.9 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD1.2 B1 B941.9 M
Increasing
Slightly volatile
Gross Profit1.2 B1.2 B1.1 B
Increasing
Slightly volatile
Interest Expense228.5 M194.2 M183.9 M
Increasing
Slightly volatile
Net Income841 M802.8 M746.4 M
Increasing
Slightly volatile
Net Income Common Stock944.4 M802.8 M755.2 M
Increasing
Slightly volatile
Net Income Common Stock USD944.4 M802.8 M755.2 M
Increasing
Slightly volatile
Net Income to Non Controlling Interests16.5 M14 M21.4 M
Decreasing
Slightly volatile
Operating Expenses383.5 M326 M311.5 M
Increasing
Slightly volatile
Operating Income1 B856.4 M808 M
Increasing
Slightly volatile
Preferred Dividends Income Statement Impact5.2 M4.4 M3.9 M
Increasing
Slightly volatile
Revenues2.4 B2.2 B2.1 B
Increasing
Slightly volatile
Revenues USD2.6 B2.2 B2.1 B
Increasing
Slightly volatile
Selling General and Administrative Expense173.9 M147.8 M142.4 M
Increasing
Slightly volatile
Weighted Average Shares228 M227.9 M218 M
Increasing
Slightly volatile
Weighted Average Shares Diluted268.3 M228.1 M221.5 M
Increasing
Slightly volatile
Income Tax Expense3.8 M3.2 M3.1 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(793.1 M)(674.2 M)(630.8 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion209.6 M178.1 M168.9 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(16.5 M)(14 M)(10 M)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(224.4 M)(190.8 M)(178.9 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares328.6 M279.3 M260.9 M
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 780 M663 M635.7 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (869.6 M)(739.2 M)(696 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(142 M)(120.7 M)(117.6 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(1 B)(857.4 M)(802.4 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals103.3 M87.8 M72.4 M
Increasing
Slightly volatile
Net Cash Flow from Operations1.1 B964 M909.5 M
Increasing
Slightly volatile
Share Based Compensation22.9 M19.4 M17.6 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.39060.3320.344
Decreasing
Stable
Book Value per Share10.79659.1778.9286
Increasing
Slightly volatile
Current Ratio0.710.7690.8438
Decreasing
Slightly volatile
Debt to Equity Ratio1982.23718.4973
Increasing
Slightly volatile
Share Dilution Ratio1.05351.00011.0056
Increasing
Slightly volatile
Dividend Yield0.05060.0430.0452
Decreasing
Stable
Dividends per Basic Common Share3.82353.253.0911
Increasing
Slightly volatile
EBITDA Margin0.62820.5340.525
Increasing
Slightly volatile
Earnings per Basic Share4.14123.523.3476
Increasing
Slightly volatile
Earnings per Diluted Share3.693.523.31
Increasing
Slightly volatile
EPS Diluted Growth0.00930.04480.1184
Increasing
Very volatile
EPS Growth0.01380.05060.1194
Increasing
Very volatile
Earnings per Basic Share USD4.14123.523.3476
Increasing
Slightly volatile
Enterprise Value over EBIT24.705921.020.5588
Increasing
Slightly volatile
Enterprise Value over EBITDA21.225918.04217.607
Increasing
Slightly volatile
Free Cash Flow per Share0.081.2721.1504
Decreasing
Slightly volatile
Gross Margin0.63060.5360.5371
Increasing
Slightly volatile
Financial Leverage0.8780.83030.8061
Increasing
Slightly volatile
Leverage Ratio3.19913.07542.7492
Increasing
Slightly volatile
NCFO Growth(0.0092)0.01640.1413
Increasing
Very volatile
Net Income Growth0.0140.05090.229
Decreasing
Very volatile
Profit Margin0.34630.3640.3477
Increasing
Slightly volatile
Payout Ratio1.08590.9230.937
Increasing
Slightly volatile
Price to Book Value7.458.2347.6624
Increasing
Slightly volatile
Price to Earnings Ratio18.9121.48620.7358
Increasing
Stable
Price to Sales Ratio6.557.8167.2928
Increasing
Slightly volatile
Revenue Growth(0.0217)0.00870.0703
Decreasing
Very volatile
Return on Average Assets0.08710.1210.1145
Increasing
Very volatile
Return on Average Equity0.40310.3910.3749
Increasing
Slightly volatile
Return on Invested Capital0.120.1020.102
Increasing
Slightly volatile
Return on Sales0.53410.4540.4443
Increasing
Slightly volatile
Weighted Average Share Growth0.00140.00140.0885
Decreasing
Stable
Sales per Share11.38359.6769.3836
Increasing
Slightly volatile
Tax Efficiency1.04930.99660.9336
Increasing
Slightly volatile
Tangible Assets Book Value per Share34.405929.24528.127
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets7.8 B6.6 B6.3 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.1 B1.2 B1.1 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1.4 B1.2 B1.1 B
Increasing
Slightly volatile
Earnings before Tax948.2 M806 M758 M
Increasing
Slightly volatile
Average Equity2.4 B2.1 B2 B
Increasing
Slightly volatile
Enterprise Value20.4 B21.3 B19.5 B
Increasing
Slightly volatile
Free Cash Flow341 M289.9 M279.1 M
Increasing
Slightly volatile
Invested Capital9.5 B9.4 B5.9 B
Increasing
Slightly volatile
Invested Capital Average11.5 B9.8 B9.2 B
Increasing
Slightly volatile
Market Capitalization15.9 B17.2 B15.8 B
Increasing
Slightly volatile
Tangible Asset Value7.8 B6.7 B6.3 B
Increasing
Slightly volatile
Working Capital(374.2 M)(111.3 M)(117.5 M)
Decreasing
Slightly volatile