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-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquiredInProcessRnD878 M200 M685 M
AcquisitionExpense3 M
Amortization of intangibles-57 M-49 M-71 M-74 M-66 M2,540 M122 M254 M308 M
Basic EPS from continuing operations2.390.780.43
Basic weighted shares outstanding367 M394 M
Cost of sales-39,500 M-19,726 M-17,233 M-22,985 M-29,793 M29,452 M22,160 M40,343 M55,456 M47,004 M
Depreciation384 M432 M494 M517 M520 M601 M653 M774 M965 M1,048 M
Depreciation unreconciled384 M432 M494 M517 M520 M601 M653 M774 M965 M1,048 M
DepreciationAndAmortization384 M432 M494 M517 M520 M601 M653 M774 M965 M1,048 M
Diluted normalized net income/share2.380.770.43
Diluted weighted shares outstanding369 M396 M
Dividends paid per share2.552.762.651.951.2
Earnings from equity interest108 M183 M195 M290 M375 M388 M355 M274 M403 M369 M
EarningsFromEquityInterestNetOfTax108 M183 M195 M290 M375 M388 M355 M274 M403 M369 M
GainOnSaleOfBusiness-2 M
GainOnSaleOfPPE878 M200 M-28 M-719 M-592 M-269 M152 M
GainOnSaleOfSecurity685 M2,164 M325 M14 M-189 M58 M
GeneralAndAdministrativeExpense325 M278 M279 M276 M316 M297 M271 M292 M325 M350 M
Gross operating profit3,964 M3,426 M2,949 M3,238 M4,262 M4,217 M1,130 M1,735 M1,886 M1,708 M
ImpairmentOfCapitalAssets-10 M-18 M109 M-114 M2,515 M
Income before tax1,557 M1,006 M755 M902 M2,414 M2,246 M-2,599 M721 M1,417 M1,623 M
Income restructuring and M&A-3 M-4 M
Income taxes171 M100 M25 M44 M198 M66 M-19 M73 M189 M121 M
Interest income610 M
InterestExpenseNonOperating348 M432 M467 M510 M431 M425 M436 M425 M405 M386 M
InterestExpenseOperating9 M11 M
InterestIncomeOperating200 M
MinorityInterests-2 M-3 M-4 M-2 M-9 M-10 M-55 M-191 M-272 M
MiscOtherSpecialCharges-2 M-7 M33 M654 M-7 M24 M39 M19 M-219 M102 M
Net income from total operations3,140 M1,513 M1,126 M2,226 M6,389 M2,171 M-2,590 M593 M1,037 M1,230 M
NetIncomeCommonStockholders3,140 M1,513 M1,126 M2,226 M6,389 M1,900 M-2,790 M393 M831 M976 M
NetIncomeContinuousOperations3,140 M1,513 M1,126 M2,226 M6,389 M2,171 M-2,590 M593 M1,037 M1,230 M
NetNonOperatingInterestIncomeExpense-348 M178 M-467 M-510 M1,578 M-425 M-436 M-425 M-405 M-386 M
Normalized income1,802 M616 M
Operating income1,799 M1,262 M994 M1,262 M2,163 M1,988 M-2,375 M851 M1,292 M1,510 M
Operating income before depreciation (EBITDA)2,289 M1,870 M1,716 M1,929 M3,365 M3,281 M-1,510 M1,920 M2,787 M3,057 M
OperatingExpense-1,456 M-1,454 M-1,182 M-1,183 M-1,263 M1,303 M1,076 M1,065 M1,315 M1,425 M
Other income net-984 M-176 M-428 M-944 M-2,532 M-384 M325 M299 M85 M-623 M
OtherGandA325 M278 M279 M276 M316 M297 M271 M292 M325 M350 M
OtherImpairmentOfCapitalAssets-10 M
OtherOperatingExpenses-27 M-2 M1,303 M1,076 M1,065 M1,315 M1,425 M
OtherWriteDown-2 M
OtherunderPreferredStockDividend-502 M-608 M-412 M
PreferredStockDividends-502 M-608 M-412 M
RentAndLandingFees325 M278 M279 M276 M316 M
RestructringAndMnAIncome-3 M-4 M
Revenue per share-57 M-49 M-71 M-74 M-66 M2,540 M122 M254 M308 M
SalariesAndWages1,456 M1,454 M1,182 M1,183 M1,263 M
Selling Gen & administrative expense325 M278 M279 M276 M316 M297 M271 M292 M325 M350 M
Special income/charges878 M200 M576 M114 M-2,515 M
Total Income available for interest expense (EBIT)1,905 M1,438 M1,222 M1,412 M2,845 M2,680 M-2,163 M1,146 M1,822 M2,009 M
Total common shares outstanding376 M398 M675 M725 M727 M728 M722 M705 M698 M701 M
Total net income3,140 M1,513 M1,126 M2,226 M6,389 M2,171 M-2,590 M593 M1,037 M1,230 M
Total ordinary shares701 M701 M701 M701 M701 M701 M701 M701 M701 M701 M
Total revenues43,464 M23,152 M20,182 M26,223 M34,055 M33,669 M23,290 M42,078 M57,342 M48,712 M
TotalExpenses-40,956 M-21,180 M-18,415 M-24,168 M-31,056 M30,755 M21,507 M39,569 M54,491 M45,956 M
TotalRevenue43,464 M23,152 M20,182 M26,223 M34,055 M33,669 M23,290 M42,078 M57,342 M48,712 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