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-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends-4 M-3 M-3 M
Amortization of intangibles5,449 M5,608 M5,608 M
Basic EPS from continuing operations0.731.511.21.31.912.091.712.112.52.52
Basic EPS total1.451.511.21.31.912.091.712.112.52.52
Basic weighted shares outstanding1,788 M1,849 M2,081 M2,145 M2,177 M2,189 M2,186 M2,183 M2,178 M2,172 M
Cost of sales-44,239 M-44,220 M-19,643 M-25,557 M-31,397 M-27,062 M-22,371 M1,287 M1,342 M1,385 M
Depreciation1,705 M1,779 M1,860 M
DepreciationAndAmortization1,705 M1,779 M1,860 M
Diluted EPS total1.411.471.21.31.912.091.712.12.52.52
Diluted normalized net income/share0.711.471.21.31.912.091.712.12.52.52
Diluted weighted shares outstanding1,843 M1,895 M2,089 M2,154 M2,187 M2,202 M2,202 M2,203 M2,199 M2,194 M
Dividends paid per share0.681.431.591.671.721.761.78
Earnings from equity interest167 M260 M362 M426 M480 M563 M426 M583 M464 M462 M
EarningsFromEquityInterestNetOfTax167 M260 M362 M426 M480 M563 M426 M583 M464 M462 M
GainOnSaleOfPPE-5 M-1000000.010 M
GainOnSaleOfSecurity-55 M-64 M-56 M-120 M-2 M
GeneralAndAdministrativeExpense-188 M-214 M-160 M-181 M-208 M-212 M-220 M-75 M-241 M-231 M
Gross operating profit3,488 M3,731 M3,379 M3,684 M5,137 M5,727 M4,829 M39,520 M56,844 M48,330 M
ImpairmentOfCapitalAssets53 M32 M
Income before tax2,665 M2,857 M2,576 M2,881 M4,299 M4,733 M3,761 M4,825 M5,697 M5,701 M
Income taxes58 M23 M23 M26 M60 M46 M-124 M70 M82 M44 M
Interest income900000.01 M1 M4 M12 M13 M5 M11 M27 M
InterestExpenseNonOperating803 M921 M-952 M985 M1,097 M-1,215 M1,287 M1,283 M1,244 M1,269 M
InterestExpenseOperating-1,231 M-1,232 M-1,228 M
MinorityInterests-10 M-46 M-40 M-56 M-66 M-96 M-110 M-121 M-128 M-128 M
MiscOtherSpecialCharges-1 M2 M-22 M-63 M-56 M-115 M300000.0-100000.023 M14 M
Net income from total operations2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M5,529 M
NetIncomeCommonStockholders2,597 M2,787 M2,513 M2,799 M4,151 M4,564 M3,743 M4,638 M5,490 M5,532 M
NetIncomeContinuousOperations2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M5,529 M
NetNonOperatingInterestIncomeExpense-802 M-920 M-952 M-983 M-1,093 M-1,231 M-1,274 M-1,278 M-1,233 M-1,242 M
Normalized income1,732 M1,857 M1,675 M1,873 M3,357 M3,739 M3,637 M
Operating income3,300 M3,516 M3,219 M3,503 M4,929 M5,516 M4,609 M6,103 M6,907 M6,929 M
Operating income before depreciation (EBITDA)2,686 M2,946 M2,611 M2,954 M4,378 M4,938 M5,958 M7,058 M8,013 M8,157 M
OperatingExpense-188 M-214 M-160 M-181 M-208 M-212 M-220 M35,078 M51,502 M43,017 M
Other income net-166 M-260 M-310 M-362 M-463 M-448 M-426 M-583 M-487 M-476 M
OtherGandA-188 M-214 M-160 M-181 M-208 M-212 M-220 M-75 M-241 M-231 M
OtherOperatingExpenses-33,791 M-50,160 M-41,632 M
OtherunderPreferredStockDividend-900000.0-4 M-3 M-3 M
PreferredStockDividends-900000.0-4 M-3 M-3 M
Revenue per share5,490 M5,667 M5,680 M
Selling Gen & administrative expense-188 M-214 M-160 M-181 M-208 M-212 M-220 M59 M-241 M-231 M
SellingAndMarketingExpense134 M156 M
Special income/charges39 M-53 M-32 M
Total Income available for interest expense (EBIT)2,686 M2,946 M2,611 M2,954 M4,378 M4,895 M3,848 M4,877 M5,709 M5,742 M
Total common shares outstanding1,871 M1,938 M2,120 M2,161 M2,185 M2,189 M2,182 M2,176 M2,171 M2,168 M
Total net income2,597 M2,787 M2,513 M2,799 M4,172 M4,591 M3,775 M4,634 M5,487 M5,529 M
Total ordinary shares2,172 M2,172 M2,172 M2,172 M2,172 M2,172 M2,172 M2,172 M2,172 M2,172 M
Total revenues47,727 M47,951 M23,022 M29,242 M36,534 M32,789 M27,200 M40,807 M58,186 M49,715 M
TotalExpenses45,177 M45,213 M20,748 M26,670 M32,803 M28,474 M23,582 M36,365 M52,844 M44,402 M
TotalRevenue47,727 M47,951 M23,022 M29,242 M36,534 M32,789 M27,200 M40,807 M58,186 M49,715 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