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

EPD Income Statement

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles-177 M
Basic EPS from continuing operations0.710.731.511.21.31.912.091.712.112.5
Basic EPS total1.411.451.511.21.31.912.091.712.112.5
Basic weighted shares outstanding1,724 M1,788 M1,849 M2,081 M2,145 M2,177 M2,189 M2,186 M2,183 M2,178 M
Cost of sales-39,368 M-44,239 M-44,220 M-19,643 M-25,557 M-31,397 M-27,062 M-22,371 M-35,077 M-51,502 M
Depreciation1,779 M
DepreciationAndAmortization1,779 M
Diluted EPS total1.361.411.471.21.31.912.091.712.12.5
Diluted normalized net income/share0.680.711.471.21.31.912.091.712.12.5
Diluted weighted shares outstanding1,786 M1,843 M1,895 M2,089 M2,154 M2,187 M2,202 M2,202 M2,203 M2,199 M
Dividends paid per share0.640.681.431.591.671.721.761.781.8
Earnings from equity interest64 M167 M260 M362 M426 M480 M563 M426 M583 M464 M
EarningsFromEquityInterestNetOfTax64 M167 M260 M362 M426 M480 M563 M426 M583 M464 M
GainOnSaleOfPPE-1000000.0
GainOnSaleOfSecurity73 M-55 M-64 M-56 M-120 M-2 M-78 M
GeneralAndAdministrativeExpense-170 M-188 M-214 M-160 M-181 M-208 M-212 M-220 M-209 M-241 M
Gross operating profit3,215 M3,488 M3,731 M3,379 M3,684 M5,137 M5,727 M4,829 M5,730 M6,684 M
ImpairmentOfCapitalAssets-53 M
Income before tax2,411 M2,665 M2,857 M2,576 M2,881 M4,299 M4,733 M3,761 M4,825 M5,697 M
Income taxes-17 M58 M23 M23 M26 M60 M46 M-124 M-70 M-82 M
Interest income800000.0900000.01 M1 M4 M12 M13 M5 M11 M
InterestExpenseNonOperating772 M803 M921 M-952 M985 M1,097 M-1,215 M1,287 M-1,283 M-1,244 M
InterestExpenseOperating-1,232 M
MinorityInterests-8 M-10 M-46 M-40 M-56 M-66 M-96 M-110 M-118 M-125 M
MiscOtherSpecialCharges73 M-1 M2 M-22 M-63 M-56 M-115 M300000.0-100000.023 M
Net income from total operations2,420 M2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M
NetIncomeCommonStockholders2,420 M2,597 M2,787 M2,513 M2,799 M4,151 M4,564 M3,743 M4,634 M5,487 M
NetIncomeContinuousOperations2,420 M2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M
NetNonOperatingInterestIncomeExpense-771 M-802 M-920 M-952 M-983 M-1,093 M-1,231 M-1,274 M-1,283 M-1,244 M
Normalized income2,394 M1,732 M1,857 M1,675 M1,873 M3,357 M3,739 M3,637 M4,755 M5,563 M
Operating income3,045 M3,300 M3,516 M3,219 M3,503 M4,929 M5,516 M4,609 M5,520 M6,443 M
Operating income before depreciation (EBITDA)2,425 M2,686 M2,946 M2,611 M2,954 M4,378 M4,938 M5,958 M7,058 M8,013 M
OperatingExpense-170 M-188 M-214 M-160 M-181 M-208 M-212 M-220 M-209 M-241 M
Other income net-137 M-166 M-260 M-310 M-362 M-463 M-448 M-426 M-588 M-498 M
OtherGandA-170 M-188 M-214 M-160 M-181 M-208 M-212 M-220 M-209 M-241 M
OtherOperatingExpenses-3,454 M
OtherTaxes-50,160 M
OtherunderPreferredStockDividend-900000.0-4 M-3 M
PreferredStockDividends-900000.0-4 M-3 M
Revenue per share-236 M
SalariesAndWages-157 M
Selling Gen & administrative expense-170 M-188 M-214 M-160 M-181 M-208 M-212 M-220 M-209 M-241 M
SellingAndMarketingExpense156 M
Special income/charges39 M71 M
Total Income available for interest expense (EBIT)2,425 M2,686 M2,946 M2,611 M2,954 M4,378 M4,895 M3,848 M4,877 M5,709 M
Total common shares outstanding1,807 M1,871 M1,938 M2,120 M2,161 M2,185 M2,189 M2,182 M2,176 M2,171 M
Total net income2,420 M2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M
Total ordinary shares2,168 M2,168 M2,168 M2,168 M2,168 M2,168 M2,168 M2,168 M2,168 M2,168 M
Total revenues42,583 M47,727 M47,951 M23,022 M29,242 M36,534 M32,789 M27,200 M40,807 M58,186 M
TotalExpenses40,134 M45,177 M45,213 M20,748 M26,670 M32,803 M28,474 M23,582 M36,365 M52,844 M
TotalRevenue42,583 M47,727 M47,951 M23,022 M29,242 M36,534 M32,789 M27,200 M40,807 M58,186 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