Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

MPLX Income Statement

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccretionOnPreferredStock13 M-88 M-112 M-938 M-1,288 M-2,060 M-2,758 M-2,994 M-3,573 M3,109 M
AccruedPreferredStockDividends41 M65 M75 M98 M122 M141 M129 M
AcquiredInProcessRnD-87 M
AcquiredInProcessRnDIncome2,159 M
AcquisitionExpense1000000.0-11 M-4 M-14 M
Amortization of intangibles130 M-38 M-38 M1,197 M2,165 M
Basic EPS from continuing operations0.353.074.551.072.291.0-0.82.863.75
Basic EPS total0.353.074.551.072.291.0-0.82.863.75
Basic weighted shares outstanding74 M112 M113 M338 M393 M761 M906 M1,051 M1,027 M1,010 M
Cost of sales218 M231 M243 M-448 M-651 M-824 M-686 M-539 M-1,585 M1,369 M
Depletion199 M5 M
Depreciation39 M49 M50 M591 M683 M1,039 M1,254 M1,377 M1,287 M
Depreciation unreconciled39 M49 M50 M920 M685 M1,039 M2,451 M1,377 M1,287 M
DevelopmentExpense8 M
Diluted EPS total0.182.063.051.062.291.0-0.82.863.75
Diluted normalized net income/share0.182.063.051.062.291.0-0.82.863.75
Diluted weighted shares outstanding75 M75 M76 M345 M396 M761 M907 M1,051 M1,027 M1,010 M
Dividends paid per share0.181.171.412.052.33.362.96
Earnings from equity interest6 M-74 M357 M1,093 M290 M-936 M321 M476 M
EarningsFromEquityInterestNetOfTax6 M-74 M357 M1,093 M290 M-936 M321 M476 M
ExciseTaxes401 M
ExplorationDevelopmentAndMineralPropertyLeaseExpenses23 M
GainOnSaleOfBusiness-6 M191 M2,404 M
GainOnSaleOfPPE-300000.01000000.0318 M49 M142 M13 M-34 M
GainOnSaleOfSecurity1 M-2 M54 M8 M881 M-5 M-9 M
GeneralAndAdministrativeExpense50 M54 M65 M228 M241 M316 M399 M383 M353 M335 M
Gross operating profit599 M237 M282 M1,668 M1,885 M5,691 M8,121 M5,983 M7,177 M10,244 M
ImpairmentOfCapitalAssets-130 M-1,197 M2,165 M42 M
Income before tax524 M146 M178 M422 M837 M2,014 M1,462 M-685 M3,113 M3,986 M
Income restructuring and M&A-1000000.062 M-1000000.037 M
Income taxes300000.0-200000.0-100000.0-12 M1000000.039 M-1000000.02 M1000000.08 M
InsuranceAndClaims1000000.011 M
Interest income300000.0
InterestExpenseNonOperating200000.01 M5 M-37 M-1000000.0-1000000.094 M82 M
InterestExpenseOperating-1 M4 M210 M296 M590 M851 M829 M785 M843 M
LossAndLossAdjustmentExpectedIncurred36 M5 M1,230 M
MarketingExpense135 M
MinorityInterests-13 M-68 M-57 M-2 M-6 M-16 M-28 M-33 M-35 M-34 M
MiscOtherSpecialCharges25 M19 M22 M36 M1,118 M-20 M61 M-1,071 M131 M596 M
Net income from total operations510 M76 M127 M1000000.02,303 M7,032 M4,630 M-1,270 M4,912 M3,944 M
NetIncomeCommonStockholders510 M76 M127 M383 M2,238 M6,957 M4,532 M-1,392 M4,771 M3,815 M
NetIncomeContinuousOperations510 M76 M127 M1000000.02,303 M7,032 M4,630 M-1,270 M4,912 M3,944 M
NetNonOperatingInterestIncomeExpense-200000.0-1 M-5 M37 M1000000.01000000.0-94 M-82 M
NetOperatingInterestIncomeExpense1 M-4 M-210 M-296 M-590 M-851 M-829 M-785 M-843 M
Normalized income2,856 M
Operating income498 M128 M160 M470 M903 M4,253 M5,158 M3,803 M5,417 M4,911 M
Operating income before depreciation (EBITDA)603 M195 M229 M1,269 M1,869 M3,489 M3,608 M1,581 M5,349 M6,214 M
OperatingExpense101 M109 M122 M1,198 M982 M1,438 M2,963 M2,180 M1,760 M450 M
Other income net-26 M-17 M-28 M-154 M-1,765 M-3,342 M-351 M2,007 M-452 M-1,072 M
Other special charges-327 M
OtherGandA50 M54 M65 M228 M241 M316 M399 M383 M353 M335 M
OtherImpairmentOfCapitalAssets-14 M-174 M-42 M
OtherOperatingExpenses-18 M1000000.0401 M
OtherTaxes11 M6 M7 M50 M54 M83 M113 M125 M120 M115 M
OtherWriteOff36 M5 M
OtherunderPreferredStockDividend13 M-88 M-112 M41 M65 M75 M98 M122 M141 M129 M
PreferredStockDividends13 M-88 M-112 M41 M65 M75 M98 M122 M141 M129 M
RentAndLandingFees-10 M-10 M-57 M-64 M-89 M-89 M5 M
Research & development expense8 M
RestructringAndMnAIncome-1000000.062 M-1000000.037 M
SalariesAndWages2 M23 M-22 M295 M245 M
SecuritiesAmortization141 M
Selling Gen & administrative expense50 M54 M65 M228 M241 M316 M399 M383 M353 M335 M
SellingAndMarketingExpense-31 M135 M
Special income/charges-131 M62 M-87 M-1,197 M2,202 M42 M-327 M
Total Income available for interest expense (EBIT)524 M146 M178 M632 M1,133 M2,567 M2,312 M143 M3,992 M4,911 M
Total common shares outstanding74 M75 M82 M369 M794 M794 M1,058 M1,037 M1,015 M1,001 M
Total net income510 M76 M127 M1000000.02,303 M7,032 M4,630 M-1,270 M4,912 M3,944 M
Total ordinary shares1,011 M1,011 M1,011 M1,011 M1,011 M1,011 M1,011 M1,011 M1,011 M1,011 M
Total revenues817 M468 M525 M3,016 M6,195 M12,813 M12,234 M7,848 M11,165 M12,433 M
TotalExpenses319 M339 M365 M750 M331 M614 M2,277 M1,641 M175 M1,819 M
TotalRevenue817 M468 M548 M572 M1,156 M5,449 M806 M636 M1,590 M11,613 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