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

PAA Income Statement

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD878 M200 M685 M
AcquiredInProcessRnDIncome1,967 M-2,790 M
Amortization of intangibles-90 M-85 M-57 M-71 M-74 M-66 M-76 M-90 M-122 M254 M
Basic EPS from continuing operations2.412.822.390.43
Basic EPS total2.57
Basic weighted shares outstanding325 M341 M367 M
Cost of sales34,850 M-38,465 M-39,500 M-17,233 M-22,985 M-29,793 M29,452 M20,431 M38,504 M53,176 M
Depreciation-222 M375 M384 M494 M517 M520 M601 M653 M774 M965 M
Depreciation unreconciled375 M384 M494 M517 M520 M601 M653 M774 M965 M
DepreciationAndAmortization-222 M375 M384 M494 M517 M520 M601 M653 M774 M965 M
Diluted EPS total2.55
Diluted normalized net income/share2.42.82.380.43
Diluted weighted shares outstanding328 M343 M369 M
Dividends paid per share2.112.332.552.651.951.2
Earnings from equity interest38 M64 M108 M195 M290 M375 M388 M-2,435 M274 M403 M
EarningsFromEquityInterestNetOfTax38 M64 M108 M195 M290 M375 M388 M-2,435 M274 M403 M
GainOnSaleOfBusiness305 M2,119 M-2,790 M
GainOnSaleOfPPE6 M878 M200 M-269 M
GainOnSaleOfSecurity124 M394 M685 M2,164 M-2,790 M393 M-189 M
GeneralAndAdministrativeExpense342 M359 M325 M279 M276 M316 M297 M271 M292 M325 M
Gross operating profit2,947 M3,784 M3,964 M2,949 M3,238 M4,262 M4,217 M2,677 M3,574 M4,166 M
ImpairmentOfCapitalAssets-10 M-18 M109 M-114 M28 M3,234 M592 M
Income before tax1,181 M1,490 M1,557 M755 M902 M2,414 M6,332 M-8,179 M1,507 M1,417 M
Income restructuring and M&A-1,149 M-3 M-4 M-5 M-5 M-4 M
Income taxes54 M99 M171 M25 M44 M198 M66 M-19 M73 M189 M
InterestExpenseNonOperating288 M303 M348 M467 M510 M431 M425 M436 M425 M405 M
InterestExpenseOperating9 M11 M
InterestIncomeOperating394 M200 M271 M393 M
MinorityInterests-33 M-30 M-2 M-4 M-2 M-9 M-10 M-55 M-191 M
MiscOtherSpecialCharges6 M1000000.0-2 M33 M654 M-7 M2,143 M39 M21 M-219 M
Net income from total operations1,399 M1,755 M3,140 M1,126 M2,226 M6,389 M6,257 M-8,170 M1,379 M1,037 M
NetIncomeCommonStockholders1,399 M1,755 M3,140 M1,126 M2,226 M6,389 M6,257 M-8,170 M1,379 M691 M
NetIncomeContinuousOperations1,399 M1,755 M3,140 M1,126 M2,226 M6,389 M6,257 M-8,170 M1,379 M1,037 M
NetNonOperatingInterestIncomeExpense-288 M-303 M-348 M-467 M-510 M1,578 M-425 M-436 M-425 M-405 M
Normalized income1,388 M
Operating income1,425 M1,728 M1,799 M994 M1,262 M2,163 M2,016 M677 M1,443 M1,292 M
Operating income before depreciation (EBITDA)1,951 M2,168 M2,289 M1,716 M1,929 M3,365 M7,367 M-1,499 M2,706 M2,787 M
OperatingExpense-1,180 M-1,322 M-1,456 M-1,182 M-1,183 M-1,263 M2,201 M2,000 M2,131 M1,315 M
Other income net-349 M-65 M-984 M-428 M-944 M-2,532 M-4,498 M5,186 M-688 M85 M
OtherGandA342 M359 M325 M279 M276 M316 M297 M271 M292 M325 M
OtherImpairmentOfCapitalAssets-168 M-20 M-10 M
OtherOperatingExpenses-27 M-2 M-125 M-111 M-96 M1,315 M
OtherWriteDown-5 M-8 M-2 M
OtherunderPreferredStockDividend-14 M-16 M-502 M-412 M
PreferredStockDividends-14 M-16 M-502 M-412 M
RealizedCapitalGain393 M
RentAndLandingFees342 M359 M325 M279 M276 M316 M
RestructringAndMnAIncome-1,149 M-3 M-4 M-5 M-5 M-4 M
Revenue per share-90 M-181 M-57 M-71 M-74 M-66 M-76 M-90 M-122 M254 M
SalariesAndWages1,180 M1,322 M1,456 M1,182 M1,183 M1,263 M1,303 M1,076 M1,065 M
Selling Gen & administrative expense342 M359 M325 M279 M276 M316 M297 M271 M292 M325 M
Special income/charges1,149 M878 M200 M576 M114 M-28 M-3,234 M-592 M
Total Income available for interest expense (EBIT)1,469 M1,793 M1,905 M1,222 M1,412 M2,845 M6,766 M-2,152 M1,932 M1,822 M
Total common shares outstanding336 M360 M376 M675 M725 M727 M728 M722 M705 M698 M
Total net income1,399 M1,755 M3,140 M1,126 M2,226 M6,389 M6,257 M-8,170 M1,379 M1,037 M
Total ordinary shares701 M701 M701 M701 M701 M701 M701 M701 M701 M701 M
Total revenues37,797 M42,249 M43,464 M20,182 M26,223 M34,055 M33,669 M23,108 M42,078 M57,342 M
TotalExpenses33,670 M-39,787 M-40,956 M-18,415 M-24,168 M-31,056 M31,653 M22,431 M40,635 M54,491 M
TotalRevenue37,797 M42,249 M43,464 M20,182 M26,223 M34,055 M33,669 M23,108 M42,078 M57,342 M
WriteDown-13 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