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 Balance Sheet

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""1,086 M1,113 M1,287 M1,715 M737 M66 M504 M831 M822 M1,159 M
Accounts payable3,323 M2,704 M3,686 M2,437 M4,810 M4,044 M
Accounts receivable3,709 M2,732 M3,576 M2,818 M5,126 M7,216 M
Accrued expenses3,822 M3,983 M2,986 M2,588 M3,323 M2,704 M3,686 M2,437 M4,810 M4,044 M
Accumulated depreciation & depletion-1,499 M-1,654 M-1,906 M-2,348 M-2,773 M-3,079 M-3,593 M-3,974 M-4,354 M-4,770 M
Cash and equivalents24 M41 M403 M47 M37 M66 M82 M60 M449 M401 M
CashCashEquivalentsAndShortTermInvestments24 M41 M403 M47 M37 M66 M82 M60 M449 M401 M
CashEquivalents47 M37 M66 M82 M38 M4 M
Common stock equity6,637 M7,644 M8,133 M8,759 M10,958 M12,002 M13,062 M9,593 M9,972 M
Cost in excess2,535 M2,503 M2,465 M2,344 M2,566 M2,521 M2,540 M2,542 M
CurrentCapitalLeaseObligation113 M152 M162 M195 M188 M167 M94 M81 M77 M110 M
CurrentDeferredTaxesAssets28 M56 M31 M77 M99 M23 M73 M102 M106 M61 M
CurrentDeferredTaxesLiabilities369 M342 M411 M358 M406 M499 M479 M414 M475 M-606 M
CurrentProvisions13 M11 M13 M94 M
Float term debt310 M6,715 M8,704 M10,124 M9,183 M9,143 M9,187 M9,382 M8,398 M7,595 M
GeneralPartnershipCapital249 M295 M340 M12,002 M13,062 M9,593 M9,972 M-10,057 M
GoodwillAndOtherIntangibleAssets2,535 M2,503 M2,465 M2,344 M2,566 M2,521 M2,540 M805 M1,960 M2,145 M
Gross fixed assets (Plant Property & Equipment)11,142 M12,473 M14,178 M16,220 M16,862 M17,866 M18,948 M378 M393 M20,369 M
Intangibles642 M674 M644 M603 M1,265 M1,209 M1,199 M805 M1,960 M2,145 M
InterestPayable288 M303 M348 M467 M510 M431 M425 M436 M425 M-405 M
Inventories274 M251 M186 M193 M164 M136 M182 M130 M253 M729 M
InventoriesAdjustmentsAllowances-128 M-7 M-289 M-3 M-35 M-8 M-11 M-233 M
Invested capital12,957 M14,609 M16,837 M19,058 M21,491 M21,145 M23,249 M9,999 M8,398 M14,882 M
Leases83 M
LimitedPartnershipCapital6,388 M7,349 M7,793 M
LineOfCredit24 M73 M166 M184 M157 M129 M98 M-102 M
LongTermCapitalLeaseObligation7,406 M7,828 M9,991 M11,839 M9,920 M9,209 M387 M317 M339 M308 M
LongTermDebtAndCapitalLeaseObligation6,320 M6,715 M8,704 M10,124 M9,183 M9,143 M9,574 M9,699 M8,737 M7,595 M
LongTermProvisions83 M82 M69 M
Minority interest509 M59 M58 M57 M10,958 M12,002 M133 M145 M2,838 M3,268 M
Net fixed assets (net PP&E)9,643 M10,819 M12,272 M13,872 M14,089 M14,787 M15,355 M-3,596 M-3,961 M15,599 M
NetUnrealizedGainLossInvestments200 M
Non-current deferred income taxes397 M332 M322 M394 M455 M449 M472 M475 M531 M-515 M
NonCurrentDeferredTaxesAssets2 M4 M3 M21 M16 M16 M17 M16 M
Number of employees4100.04100.04100.04100.04100.04100.04100.04100.04100.04100.0
Other current assets351 M220 M270 M603 M221 M373 M312 M405 M200 M318 M
Other equity adjustments80 M-97 M-467 M
Other fixed assets378 M393 M20,369 M
Other non-current assets586 M540 M431 M290 M904 M916 M858 M162 M251 M748 M
Other non-current liabilities136 M182 M328 M1,214 M90 M338 M891 M807 M830 M1,081 M
Other receivable3,563 M3,638 M2,615 M2,279 M3,029 M2,454 M3,614 M2,553 M4,705 M3,907 M
OtherCurrentBorrowings1,086 M1,113 M1,287 M1,715 M737 M66 M504 M831 M822 M1,159 M
OtherCurrentLiabilities861 M846 M1,030 M967 M1,150 M1,596 M827 M985 M600 M688 M
OtherEquityInterest120 M-77 M-159 M-228 M-223 M-177 M
OtherInventories274 M251 M186 M193 M164 M136 M182 M130 M253 M729 M
OtherPayable3,822 M3,983 M2,986 M2,588 M3,457 M79 M
Payables3,822 M3,983 M2,986 M2,588 M3,323 M2,704 M3,686 M2,437 M4,810 M4,044 M
Preferred securities of subsidiary trust122 M
PreferredStock122 M
RecievablesAdjustmentsAllowances-4 M-5 M-4 M-3 M-3 M-3 M-3 M
Short term debt1,086 M1,113 M1,287 M1,715 M737 M66 M504 M831 M822 M1,159 M
Total assets19,235 M20,360 M22,198 M24,210 M25,351 M25,511 M28,677 M5,265 M8,569 M27,892 M
Total current assets5,147 M4,964 M4,179 M4,272 M4,000 M3,533 M4,612 M3,148 M5,607 M5,355 M
Total current liabilities5,183 M5,411 M4,755 M4,664 M4,531 M3,456 M5,017 M4,253 M6,232 M5,891 M
Total equity6,637 M7,644 M8,133 M8,759 M10,958 M12,002 M13,062 M9,593 M9,972 M
Total liabilities12,089 M12,657 M14,007 M15,394 M14,393 M13,509 M15,482 M14,759 M15,799 M14,567 M
Total non-current assets13,814 M15,145 M17,833 M19,745 M21,187 M21,842 M23,417 M2,117 M2,962 M22,537 M
Total non-current liabilities6,906 M7,246 M9,252 M10,730 M9,862 M10,053 M10,465 M10,506 M9,567 M8,676 M
TotalEquityGrossMinority7,146 M7,703 M8,191 M8,816 M10,958 M12,002 M13,195 M145 M2,838 M3,268 M
TotalEquityGrossMinorityInterest7,146 M7,703 M8,191 M8,816 M10,958 M12,002 M13,195 M145 M2,838 M3,268 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest19,235 M20,360 M22,198 M24,210 M25,351 M25,511 M28,677 M14,904 M18,637 M27,892 M
TotalNonCurrentLiabilitiesNetMinorityInteres6,906 M7,246 M9,252 M10,730 M9,862 M10,053 M10,465 M10,506 M9,567 M8,676 M
TotalPartnershipCapital6,637 M7,644 M8,133 M12,002 M13,062 M
UnearnedIncome707 M798 M930 M896 M872 M916 M981 M982 M907 M961 M
UnearnedPremiums15 M15 M18 M
Working capital-36 M-447 M-576 M-392 M-531 M77 M-405 M-1,105 M-625 M-536 M
ltinv343 M485 M1,735 M2,343 M2,756 M2,702 M3,683 M3,764 M3,805 M3,084 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