BIP Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-16	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22
Accounts payable	266 M	864 M	463 M	973 M	1,461 M	1,877 M	1,872 M	2,253 M
Accounts receivable	395 M	738 M	1,044 M	1,741 M	1,463 M	1,847 M	2,276 M	3,503 M
Accrued expenses	540 M	864 M	1,048 M	1,626 M	2,212 M	2,980 M	3,394 M	4,138 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	-7,223 M
Cash and equivalents	702 M	341 M	444 M	699 M	742 M	1,250 M	1,279 M	1,857 M
CashCashEquivalentsAndShortTermInvestments	738 M	480 M	684 M	866 M	1,316 M	1,806 M	1,279 M	1,857 M
CashEquivalents	50 M	83 M	150 M	232 M	222 M	505 M	454 M
CommercialPaper						431 M
Common par							6,317 M	6,267 M
Common stock equity							25,554 M	34,016 M
CommonStock							5,399 M	5,349 M
Cost in excess	502 M	1,301 M	3,859 M	6,553 M	6,634 M	8,979 M	8,789 M	14,488 M
CurrentAccruedExpenses	274 M	400 M	585 M	653 M	751 M	1,103 M	1,395 M	1,726 M
CurrentCapitalLeaseObligation				197 M	206 M	416 M	384 M	429 M
CurrentDeferredRevenue	108 M	159 M	154 M	307 M	256 M	338 M	460 M	490 M
CurrentProvisions	64 M	59 M	106 M	214 M	176 M	161 M	127 M
Deferred revenues	108 M	159 M	157 M	438 M	392 M	1,486 M	460 M	490 M
DerivativeProductLiabilities	131 M	93 M	185 M	220 M	525 M	182 M	26 M
ElectricUtilityPlant							8,916 M
EmployeeBenefits	98 M	100 M	81 M	148 M	315 M	172 M	8 M
FinancialAssets	667 M	469 M	712 M	571 M	343 M	226 M	721 M	607 M
Float term debt	7,752 M	9,701 M	14,121 M	19,737 M	21,711 M	26,149 M	28,879 M	42,387 M
GeneralPartnershipCapital	27 M	25 M	22 M	24 M	19 M	31 M
GoodwillAndOtherIntangibleAssets	4,967 M	11,195 M	15,494 M	20,939 M	18,401 M	23,193 M	8,789 M	30,333 M
Gross fixed assets (Plant Property & Equipment)	9,814 M	11,517 M	14,663 M	25,430 M	35,220 M	42,846 M	43,387 M	55,769 M
Intangibles	4,465 M	9,894 M	11,635 M	14,386 M	11,767 M	14,214 M	11,822 M	15,845 M
Inventories	101 M	108 M	141 M	242 M	221 M	400 M	531 M	512 M
Invested capital	7,752 M	9,701 M	14,121 M	19,737 M	21,711 M	26,149 M		76,403 M
LimitedPartnershipCapital	4,986 M	5,562 M	5,449 M	5,983 M	5,363 M	6,840 M
LoansReceivable	73 M	43 M	61 M	61 M	68 M	47 M	29 M
LongTermCapitalLeaseObligation				1,606 M	3,597 M	3,423 M	3,037 M	3,197 M
LongTermDebtAndCapitalLeaseObligation	7,752 M	9,701 M	14,121 M	21,343 M	25,308 M	29,572 M	31,916 M	45,584 M
LongTermProvisions	41 M	95 M	148 M	327 M	423 M	492 M	426 M
MaterialsAndSupplies	101 M	108 M	141 M	242 M	221 M	400 M	338 M	420 M
Minority interest	4,631 M	7,887 M	9,197 M	16,170 M	16,291 M	19,520 M
Net fixed assets (net PP&E)	8,656 M	9,937 M	12,814 M	23,013 M	31,584 M	38,655 M	37,291 M	48,546 M
NetUtilityPlant	3,938 M	4,729 M	5,421 M	10,845 M	12,223 M	9,208 M	8,916 M
Non-current deferred income taxes	1,612 M	2,849 M	3,421 M	4,620 M	4,612 M	6,011 M	5,975 M	7,903 M
NonCurrentAccountsReceivable	55 M	52 M	39 M	127 M	466 M	702 M	59 M
NonCurrentAccruedExpenses						200 M	178 M
NonCurrentDeferredAssets	74 M	66 M	75 M	112 M	124 M	160 M	111 M	107 M
NonCurrentDeferredLiabilities	1,905 M	4,065 M	4,697 M	5,981 M	6,101 M	6,383 M	6,237 M	8,401 M
NonCurrentDeferredRevenue	293 M	300 M	323 M	246 M	467 M	366 M	254 M	462 M
NonCurrentDeferredTaxesAssets	74 M	66 M	75 M	112 M	124 M	160 M	111 M	107 M
NonCurrentNoteReceivables	172 M	210 M	97 M	85 M	259 M	63 M	1,000 M
NonCurrentPensionAndOtherPostretirementBenefitPlans	98 M	100 M	81 M	148 M	315 M	172 M	8 M
Notes payable							147 M	96 M
Other current assets							856 M
Other equity adjustments							3,917 M	4,088 M
Other fixed assets	5,876 M	6,788 M	9,242 M	14,585 M	22,997 M	33,638 M	24,086 M
Other non-current assets	110 M	221 M	180 M	130 M	290 M	439 M	1,465 M	3,361 M
Other non-current liabilities	169 M	365 M	243 M	653 M	1,442 M	1,888 M	865 M	1,058 M
Other receivable					12 M	29 M	37 M	163 M
OtherCurrentBorrowings	574 M	463 M	985 M	1,381 M	1,685 M	2,701 M	3,421 M	6,303 M
OtherCurrentLiabilities	229 M	237 M	121 M	1,583 M	853 M	486 M	93 M	249 M
OtherEquityAdjustments							3,917 M	4,088 M
OtherEquityInterest							15,320 M	23,661 M
OtherInventories							193 M	92 M
OtherPayable							93 M
Payables	266 M	864 M	463 M	973 M	1,461 M	1,877 M	1,999 M	2,412 M
Preferred securities of subsidiary trust							918 M	918 M
PreferredSecuritiesOutsideStockEquity	20 M	20 M	20 M	20 M	20 M	20 M
PreferredStock							918 M	918 M
Prepaid expenses	109 M	100 M	127 M	219 M	450 M	328 M	315 M	1,010 M
Restricted cash	84 M	33 M	96 M	128 M	125 M	156 M	141 M
Short term debt	574 M	463 M	985 M	1,381 M	1,685 M	3,132 M	3,568 M	6,399 M
Total assets	21,275 M	29,477 M	36,580 M	56,308 M	61,331 M	73,961 M	61,147 M	100,784 M
Total current assets	1,632 M	1,512 M	2,276 M	5,841 M	3,711 M	4,896 M	6,686 M	7,979 M
Total current liabilities	1,515 M	1,564 M	2,417 M	5,439 M	5,524 M	8,661 M	7,899 M	11,705 M
Total equity							25,554 M	34,016 M
Total liabilities	11,631 M	16,003 M	21,912 M	34,131 M	39,658 M	47,570 M	46,937 M	66,768 M
Total non-current assets	19,643 M	27,965 M	34,304 M	50,467 M	57,620 M	69,065 M	54,461 M	92,805 M
Total non-current liabilities	10,116 M	14,439 M	19,495 M	28,692 M	34,134 M	38,909 M	39,038 M	55,063 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities	2,364 M	4,738 M	5,374 M	7,349 M	8,826 M	9,337 M	7,102 M	9,459 M
TotalEquityGrossMinority	9,644 M	13,474 M	14,668 M	22,177 M	21,673 M	26,391 M	25,554 M	34,016 M
TotalEquityGrossMinorityInterest	9,644 M	13,474 M	14,668 M	22,177 M	21,673 M	26,391 M	25,554 M	34,016 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	21,275 M	29,477 M	36,580 M	56,308 M	61,331 M	73,961 M	72,491 M	100,784 M
TotalNonCurrentLiabilitiesNetMinorityInteres	10,116 M	14,439 M	19,495 M	28,692 M	34,134 M	38,909 M	39,038 M	55,063 M
TotalPartnershipCapital	5,013 M	5,587 M	5,471 M	6,007 M	5,382 M	6,871 M
TotalTaxPayable							127 M	159 M
Working capital	117 M	-52 M	-141 M	402 M	-1,813 M	-3,765 M		-3,726 M
debtc	574 M	463 M	985 M	1,578 M	1,891 M	3,548 M	3,952 M	6,828 M
ltinv	4,788 M	5,623 M	4,703 M	5,074 M	5,635 M	4,972 M	6,025 M	9,735 M

Call: 1-877-778-8358

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