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

Financials

PAA Cash Flow

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-180 M134 M-129 M-463 M605 M-75 M-5 M-304 M-18 M-10 M
(Increase) Decrease in payables-504 M126 M-1,315 M508 M847 M-367 M1,151 M-1,286 M1,970 M-830 M
(Increase) Decrease in receivables218 M-186 M1,177 M-524 M-511 M309 M-1,158 M1,432 M-2,179 M649 M
Acquisitions-2,232 M-161 M-1,098 M-282 M-1,280 M-50 M-310 M-32 M-149 M
AssetImpairmentCharge128 M7 M289 M3 M35 M8 M11 M2,748 M
CapitalExpenditureReported1,204 M1,613 M1,932 M1,334 M1,024 M1,634 M1,181 M738 M336 M455 M
Cash at beginning of period26 M24 M41 M27 M47 M37 M66 M82 M60 M453 M
Cash at end of period24 M41 M403 M47 M1,428 M66 M1,284 M913 M1,168 M1,183 M
Cash flow1,240 M1,954 M2,004 M733 M2,499 M2,608 M2,504 M1,514 M1,996 M2,408 M
CashFlowFromContinuingInvestingActivities-3,392 M-1,653 M-3,296 M-1,273 M-1,570 M-813 M-1,765 M-1,093 M386 M-526 M
ChangeInAccountPayable-504 M126 M-1,315 M508 M847 M-367 M1,151 M-1,286 M1,970 M-830 M
ChangeInPayablesAndAccruedExpense-504 M126 M-1,315 M508 M847 M-367 M1,151 M-1,286 M1,970 M-830 M
ChangeInWorkingCapital-466 M74 M-267 M-479 M941 M-133 M-12 M-158 M-227 M-191 M
ChangesInAccountReceivables218 M-186 M1,177 M-524 M-511 M309 M-1,158 M1,432 M-2,179 M649 M
CommonStockDividendPaid-732 M-840 M-934 M-1,062 M-1,386 M
CommonStockPayments-50 M-178 M-74 M
Current deferred income taxes-1000000.0100 M-60 M16 M132 M-46 M-70 M23 M105 M
Deferred income taxes-1000000.0100 M-60 M16 M132 M-46 M-70 M23 M105 M
Depreciation375 M384 M494 M517 M520 M601 M653 M774 M965 M
Depreciation unreconciled482 M375 M384 M494 M517 M520 M601 M653 M774 M965 M
DepreciationAndAmortization375 M384 M494 M517 M520 M601 M653 M774 M965 M
EarningsLossesFromEquityInvestments-10 M-3 M21 M14 M47 M13 M117 M157 M85 M
Effect of exchange rate changes-1000000.0-3 M-3 M4 M4 M-9 M-3 M-8 M-5 M-3 M
FinancingCashFlow2,151 M-281 M1,657 M556 M448 M-1,757 M482 M418 M-1,269 M-1,149 M
Free cash flow58 M541 M100 M53 M2,558 M2,308 M1,400 M1,205 M2,541 M2,013 M
GainLossOnInvestmentSecurities-30 M-13 M14 M-14 M189 M
GainLossOnSaleOfPPE109 M-114 M28 M719 M592 M269 M
IncomeTaxPaidSupplementalData71 M37 M159 M98 M50 M21 M136 M111 M76 M112 M
InterestPaidSupplementalData295 M305 M334 M450 M486 M400 M397 M428 M401 M393 M
Issuance of capital stock979 M465 M848 M796 M1,664 M
Issuance of debt1,110 M-366 M-656 M-690 M-123 M93 M456 M-545 M
IssuanceOfCapitalStock979 M465 M848 M796 M1,664 M
IssuanceOfDebt1,496 M1,559 M2,229 M-633 M-2,040 M77 M91 M587 M-745 M-750 M
Net cash from financing activities2,151 M-281 M1,657 M556 M448 M-725 M482 M418 M-1,269 M-1,149 M
Net cash from investing activities-3,392 M-1,653 M-3,296 M-1,273 M-1,570 M-813 M-1,765 M-1,093 M386 M-526 M
Net cash from operating activities1,240 M1,954 M2,004 M733 M2,499 M2,608 M2,504 M1,514 M1,996 M2,408 M
Net change in cash & cash equivalents-2 M17 M362 M20 M1,381 M20 M1,218 M831 M1,108 M733 M
Net income from continuing operations1,127 M1,391 M1,386 M730 M858 M2,216 M2,180 M-2,580 M648 M1,228 M
NetBusinessPurchaseAndSale-2,232 M-161 M-1,098 M-282 M-1,280 M-50 M-310 M-32 M-149 M
NetCommonStockIssuance979 M465 M848 M796 M1,664 M-50 M-178 M-74 M
NetForeignCurrencyExchangeGainLoss-1000000.013 M-7 M41 M
NetInvestmentPropertiesPurchaseAndSale22 M-79 M-294 M-311 M-349 M-513 M-611 M-474 M-127 M18 M
NetInvestmentPurchaseAndSale22 M-79 M-294 M-311 M-349 M-513 M-611 M-474 M-127 M18 M
NetIssuancePaymentsOfDebt1,496 M1,559 M2,229 M-633 M-2,040 M77 M91 M587 M-745 M-750 M
NetLongTermDebtIssuance1,496 M449 M2,595 M23 M-1,350 M200 M-2 M131 M-200 M-750 M
NetPPEPurchaseAndSale-1,182 M-1,413 M-1,904 M-680 M59 M-300 M-1,104 M-309 M545 M-395 M
NetPreferredStockIssuance1,569 M788 M
Operating (gains) losses-11 M-3 M-9 M110 M-67 M41 M836 M728 M584 M
Other financing charges net408 M-1,096 M-13 M451 M36 M-802 M391 M-119 M-346 M-325 M
Other investing changes net22 M-79 M-294 M-311 M-349 M-513 M-611 M-474 M-127 M18 M
Other non-cash items97 M126 M404 M57 M57 M-60 M-260 M2,833 M50 M-283 M
Payment of cash dividends732 M840 M934 M1,062 M1,386 M
PreferredStockIssuance1,569 M788 M
Purchase of property plant & equipment-1,182 M-1,413 M-1,904 M-680 M59 M-300 M-1,104 M-309 M545 M-395 M
Purchase of short term investments1,996 M699 M2,595 M748 M200 M998 M748 M
PurchaseOfPPE-1,204 M-1,613 M-1,932 M-1,334 M-1,024 M-1,634 M-1,181 M-738 M-336 M-455 M
Repayment of debt-500 M-250 M-725 M-1,350 M-1,000 M-617 M-200 M-750 M
RepaymentOfDebt-500 M-250 M-817 M-1,350 M-1,000 M-617 M-200 M-750 M
Repurchase of capital stock-50 M-178 M-74 M
SaleOfPPE22 M200 M28 M654 M1,083 M1,334 M77 M429 M881 M60 M
ShortTermDebtIssuance1,110 M-366 M-564 M-690 M-123 M93 M456 M-545 M
ShortTermDebtPayments-92 M
StockBasedCompensation101 M116 M98 M60 M41 M79 M34 M15 M23 M40 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