Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Magellan Midstream Partners L.P. Limited Partnership logo

Magellan Midstream Partners L.P. Limited Partnership

Sector: Energy   

Industry: Oil & Gas Midstream

69.00
 
USD
  
0.00
  
(0.00%)
Optionable: Yes  Market Cap: 13,939 M  90-day average vol: 0

Previous close: 69.0  Open: 69.44  Bid:   Ask:
52 week range    
53.01   
   69.90
Peers   
PAA / 
HEP / 
NS / 
PSXP / 
MPLX / 
PAGP / 
DKL / 
BKEP / 
Last updated: Friday 26th April 2024
48
MarketXLS Rank
50
Value
46
Technical
50
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

MMP Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""250 M250 M251 M59 M26 M28 M26 M31 M
Accounts payable76 M97 M104 M77 M105 M139 M151 M98 M110 M108 M
Accounts receivable116 M84 M97 M131 M153 M129 M149 M141 M135 M264 M
Accrued expenses223 M235 M238 M245 M323 M331 M372 M300 M473 M539 M
Accumulated depreciation & depletion-1,070 M-1,205 M-1,348 M-1,508 M-1,683 M-1,830 M-2,027 M-1,957 M-2,141 M-2,334 M
Building & improvements122 M
Cash and equivalents25 M17 M29 M15 M161 M218 M58 M13 M2 M2 M
CashCashEquivalentsAndShortTermInvestments40 M23 M29 M65 M198 M218 M85 M47 M48 M17 M
CashEquivalents25 M17 M29 M15 M176 M2 M
Common stock equity-20 M-82 M-96 M-101 M-138 M-120 M-162 M-183 M1,685 M
Construction in progress90 M
Cost in excess53 M53 M53 M53 M53 M53 M53 M50 M50 M50 M
CurrentAccruedExpenses108 M90 M83 M117 M167 M139 M155 M134 M287 M345 M
CurrentCapitalLeaseObligation16 M27 M27 M39 M35 M34 M26 M28 M26 M31 M
CurrentDeferredRevenue63 M71 M82 M102 M118 M121 M110 M99 M93 M104 M
CurrentProvisions12 M11 M16 M10 M6 M9 M
Deferred revenues63 M71 M82 M102 M118 M121 M110 M99 M93 M104 M
DeferredCosts18 M
DeferredFinancingCosts18 M-19 M-27 M-29 M-27 M-35 M-40 M
DefinedPensionBenefit101 M
Deposits84 M24 M37 M
EmployeeBenefits52 M75 M78 M71 M111 M123 M146 M164 M145 M87 M
Finished goods205 M
Float term debt2,435 M2,967 M3,189 M4,087 M4,274 M4,211 M4,850 M5,116 M5,089 M5,015 M
GeneralPartnershipCapital1,647 M1,868 M2,022 M2,092 M2,130 M2,643 M2,715 M2,304 M1,685 M
GoodwillAndOtherIntangibleAssets61 M58 M55 M105 M106 M104 M101 M95 M93 M91 M
Gross fixed assets (Plant Property & Equipment)4,987 M5,534 M6,167 M6,784 M7,235 M7,629 M8,603 M8,110 M8,220 M8,164 M
Intangibles7 M5 M2 M52 M53 M51 M48 M45 M43 M41 M
InterestPayable45 M46 M51 M66 M71 M63 M64 M59 M59 M59 M
Inventories187 M158 M131 M134 M182 M186 M184 M158 M281 M356 M
InventoriesAdjustmentsAllowances-39 M-5 M-18 M-5 M
Invested capital4,851 M5,852 M6,282 M8,073 M8,409 M8,302 M9,394 M9,912 M10,170 M10,053 M
Land & improvements374 M
LimitedPartnershipCapital1,667 M1,950 M2,118 M2,193 M2,267 M2,764 M2,877 M2,487 M2,055 M1,779 M
LongTermCapitalLeaseObligation144 M138 M147 M117 M
LongTermDebtAndCapitalLeaseObligation2,435 M2,967 M3,189 M4,087 M4,274 M4,211 M4,850 M5,116 M5,236 M5,132 M
LongTermProvisions26 M26 M16 M14 M13 M11 M
Minority interest1,647 M
Net fixed assets (net PP&E)3,916 M4,329 M4,819 M5,276 M5,553 M5,798 M6,576 M6,153 M6,079 M5,830 M
NetOtherUnrealizedGainLoss-17 M-30 M-35 M-34 M-26 M-49 M
NetUnrealizedGainLossInvestments-28 M
NonCurrentAccountsReceivable10 M
NonCurrentDeferredAssets18 M
NonCurrentNoteReceivables21 M23 M8 M
NonCurrentPensionAndOtherPostretirementBenefitPlans52 M75 M78 M71 M111 M123 M146 M164 M145 M87 M
Number of employees1715.01715.01715.01715.01715.01715.01715.01715.01715.01715.0
Other current assets47 M34 M43 M40 M63 M58 M40 M59 M43 M67 M
Other equity adjustments-20 M-82 M-96 M-101 M-138 M-120 M-162 M-183 M-155 M-94 M
Other fixed assets4,987 M5,534 M6,167 M6,784 M7,235 M7,629 M8,603 M8,110 M7,635 M
Other non-current assets66 M69 M42 M66 M29 M101 M40 M307 M24 M24 M
Other non-current liabilities22 M29 M24 M26 M30 M94 M60 M53 M70 M78 M
Other receivable999 M1,097 M1,034 M970 M1,059 M2,633 M2,678 M2,147 M35 M2,916 M
OtherCurrentLiabilities83 M214 M127 M94 M113 M165 M149 M111 M88 M36 M
OtherEquityInterest-30 M-35 M-34 M-26 M-49 M-55 M
OtherInventories187 M158 M131 M134 M182 M186 M184 M158 M76 M356 M
OtherPayable192 M75 M55 M
Payables115 M145 M156 M127 M156 M192 M217 M166 M186 M194 M
Retained earnings-20 M-82 M-96 M-101 M-138 M-120 M-162 M-183 M
Short term debt250 M250 M251 M59 M
Total assets4,821 M5,501 M6,042 M6,772 M7,394 M7,748 M8,438 M8,197 M8,030 M7,708 M
Total current assets390 M387 M339 M370 M597 M646 M459 M405 M843 M711 M
Total current liabilities638 M536 M713 M482 M837 M677 M667 M559 M680 M726 M
Total equity-20 M-82 M-96 M-101 M-138 M-120 M-162 M-183 M1,685 M
Total liabilities3,173 M3,633 M4,020 M4,680 M5,265 M5,104 M5,723 M5,893 M6,130 M6,023 M
Total non-current assets4,431 M5,114 M5,703 M6,402 M6,798 M7,101 M7,978 M7,792 M7,187 M6,848 M
Total non-current liabilities2,535 M3,097 M3,307 M4,198 M4,428 M4,428 M5,056 M5,335 M5,451 M5,297 M
TotalEquityGrossMinority1,647 M1,868 M2,022 M2,092 M2,130 M2,643 M2,715 M2,304 M1,685 M
TotalEquityGrossMinorityInterest1,647 M1,868 M2,022 M2,092 M2,130 M2,643 M2,715 M2,304 M1,685 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest4,821 M5,501 M6,042 M6,772 M7,394 M7,748 M8,438 M8,197 M8,030 M7,708 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,535 M3,097 M3,307 M4,198 M4,428 M4,428 M5,056 M5,335 M5,451 M5,297 M
TotalPartnershipCapital1,667 M1,950 M2,118 M2,193 M2,267 M2,764 M2,877 M2,487 M1,900 M1,779 M
TotalTaxPayable39 M48 M52 M50 M51 M53 M66 M68 M77 M86 M
UnearnedPremiums16 M7 M215000.0-3 M-9 M19 M18 M
Working capital-248 M-149 M-374 M-111 M-240 M-30 M-207 M-153 M164 M-15 M
ltinv364 M642 M786 M955 M1,110 M1,097 M1,241 M1,214 M981 M894 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University