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

BIP Balance Sheet

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""574 M463 M985 M1,578 M1,891 M3,548 M3,562 M
Accounts payable266 M864 M463 M973 M1,461 M1,877 M1,872 M
Accounts receivable395 M738 M1,044 M1,741 M1,463 M1,847 M2,276 M
Accrued expenses540 M864 M1,048 M1,626 M2,212 M2,980 M3,360 M
Accumulated depreciation & depletion-1,158 M-1,580 M-1,849 M-2,417 M-3,636 M-4,191 M-5,396 M
Cash and equivalents702 M341 M444 M699 M742 M1,250 M1,138 M
CashCashEquivalentsAndShortTermInvestments738 M480 M684 M866 M1,316 M1,806 M1,976 M
CashEquivalents50 M83 M150 M232 M222 M505 M454 M
CommercialPaper431 M
Common par6,317 M
Common stock equity25,554 M
CommonStock5,399 M
Cost in excess502 M1,301 M3,859 M6,553 M6,634 M8,979 M8,789 M
CurrentAccruedExpenses274 M400 M585 M653 M751 M1,103 M1,395 M
CurrentCapitalLeaseObligation197 M206 M416 M384 M
CurrentDeferredRevenue108 M159 M154 M307 M256 M338 M460 M
CurrentProvisions64 M59 M106 M214 M176 M161 M127 M
Deferred revenues108 M159 M157 M438 M392 M1,486 M544 M
DerivativeProductLiabilities131 M93 M185 M220 M525 M182 M26 M
ElectricUtilityPlant8,916 M
EmployeeBenefits98 M100 M81 M148 M315 M172 M8 M
FinancialAssets667 M469 M712 M571 M343 M226 M387 M
Float term debt7,752 M9,701 M14,121 M19,737 M21,711 M26,149 M27,229 M
GeneralPartnershipCapital27 M25 M22 M24 M19 M31 M
GoodwillAndOtherIntangibleAssets4,967 M11,195 M15,494 M20,939 M18,401 M23,193 M20,611 M
Gross fixed assets (Plant Property & Equipment)9,814 M11,517 M14,663 M25,430 M35,220 M42,846 M43,387 M
Intangibles4,465 M9,894 M11,635 M14,386 M11,767 M14,214 M11,822 M
Inventories101 M108 M141 M242 M221 M400 M531 M
Invested capital7,752 M9,701 M14,121 M19,737 M21,711 M26,149 M
LimitedPartnershipCapital4,986 M5,562 M5,449 M5,983 M5,363 M6,840 M
LoansReceivable73 M43 M61 M61 M68 M47 M29 M
LongTermCapitalLeaseObligation1,606 M3,597 M3,423 M3,037 M
LongTermDebtAndCapitalLeaseObligation7,752 M9,701 M14,121 M21,343 M25,308 M29,572 M30,266 M
LongTermProvisions41 M95 M148 M327 M423 M492 M426 M
MaterialsAndSupplies101 M108 M141 M242 M221 M400 M338 M
Minority interest4,631 M7,887 M9,197 M16,170 M16,291 M19,520 M
Net fixed assets (net PP&E)8,656 M9,937 M12,814 M23,013 M31,584 M38,655 M37,991 M
NetUtilityPlant3,938 M4,729 M5,421 M10,845 M12,223 M9,208 M8,916 M
Non-current deferred income taxes1,612 M2,849 M3,421 M4,620 M4,612 M6,011 M5,975 M
NonCurrentAccountsReceivable55 M52 M39 M127 M466 M702 M59 M
NonCurrentAccruedExpenses200 M178 M
NonCurrentDeferredAssets74 M66 M75 M112 M124 M160 M111 M
NonCurrentDeferredLiabilities1,905 M4,065 M4,697 M5,981 M6,101 M6,383 M6,229 M
NonCurrentDeferredRevenue293 M300 M323 M246 M467 M366 M254 M
NonCurrentDeferredTaxesAssets74 M66 M75 M112 M124 M160 M111 M
NonCurrentNoteReceivables172 M210 M97 M85 M259 M63 M1,000 M
NonCurrentPensionAndOtherPostretirementBenefitPlans98 M100 M81 M148 M315 M172 M8 M
Notes payable147 M
Number of employees225000.0225000.0225000.0225000.0225000.0225000.0225000.0
Other current assets856 M
Other equity adjustments3,917 M
Other fixed assets5,876 M6,788 M9,242 M14,585 M22,997 M33,638 M24,086 M
Other non-current assets110 M221 M180 M130 M290 M439 M769 M
Other non-current liabilities169 M365 M243 M653 M1,442 M1,888 M1,885 M
Other receivable12 M29 M327 M
OtherCurrentBorrowings574 M463 M985 M1,381 M1,685 M2,701 M3,031 M
OtherCurrentLiabilities229 M237 M121 M1,583 M853 M486 M681 M
OtherEquityAdjustments3,917 M
OtherEquityInterest15,320 M
OtherInventories193 M
OtherPayable93 M
Payables266 M864 M463 M973 M1,461 M1,877 M1,965 M
Preferred securities of subsidiary trust918 M
PreferredSecuritiesOutsideStockEquity20 M20 M20 M20 M20 M20 M
PreferredStock918 M
Prepaid expenses109 M100 M127 M219 M450 M328 M315 M
Restricted cash84 M33 M96 M128 M125 M156 M141 M
Short term debt574 M463 M985 M1,381 M1,685 M3,132 M3,178 M
Total assets21,275 M29,477 M36,580 M56,308 M61,331 M73,961 M72,969 M
Total current assets1,632 M1,512 M2,276 M5,841 M3,711 M4,896 M6,686 M
Total current liabilities1,515 M1,564 M2,417 M5,439 M5,524 M8,661 M8,377 M
Total equity25,554 M
Total liabilities11,631 M16,003 M21,912 M34,131 M39,658 M47,570 M47,415 M
Total non-current assets19,643 M27,965 M34,304 M50,467 M57,620 M69,065 M66,283 M
Total non-current liabilities10,116 M14,439 M19,495 M28,692 M34,134 M38,909 M39,038 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities2,364 M4,738 M5,374 M7,349 M8,826 M9,337 M8,752 M
TotalEquityGrossMinority9,644 M13,474 M14,668 M22,177 M21,673 M26,391 M25,554 M
TotalEquityGrossMinorityInterest9,644 M13,474 M14,668 M22,177 M21,673 M26,391 M25,554 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest21,275 M29,477 M36,580 M56,308 M61,331 M73,961 M72,969 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,116 M14,439 M19,495 M28,692 M34,134 M38,909 M39,038 M
TotalPartnershipCapital5,013 M5,587 M5,471 M6,007 M5,382 M6,871 M
Working capital117 M-52 M-141 M402 M-1,813 M-3,765 M
ltinv4,788 M5,623 M4,703 M5,074 M5,635 M4,972 M5,325 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