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

BIP Income Statement

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Basic EPS from continuing operations0.75-0.030.390.050.150.770.14
Basic EPS total0.75-0.030.390.050.150.770.14
Basic weighted shares outstanding367 M397 M415 M428 M663 M668 M461 M
Cost of sales1,063 M1,509 M2,208 M3,395 M6,548 M8,247 M8,352 M
Depreciation1,705 M2,158 M
Depreciation unreconciled447 M671 M801 M1,214 M1,705 M2,158 M
DepreciationAndAmortization447 M671 M801 M1,214 M1,705 M2,158 M
Diluted EPS total0.75-0.030.390.050.150.770.14
Diluted normalized net income/share0.75-0.030.390.050.150.770.14
Diluted weighted shares outstanding367 M397 M415 M428 M663 M668 M2 M
Dividends paid per share1.031.161.251.340.890.912.88
Earnings from equity interest248 M118 M-13 M224 M131 M88 M12 M
EarningsFromEquityInterestNetOfTax248 M118 M-13 M224 M131 M88 M12 M
FuelAndPurchasePower1,291 M1,514 M
GainOnSaleOfBusiness338 M
GainOnSaleOfSecurity74 M-66 M137 M57 M-16 M80 M
GeneralAndAdministrativeExpense166 M239 M223 M279 M312 M406 M433 M
Gross operating profit1,052 M2,026 M2,444 M3,202 M2,337 M3,290 M6,075 M
Income before tax543 M747 M1,170 M928 M1,195 M3,333 M80 M
Income taxes15 M173 M364 M278 M291 M614 M560 M
Interest income131 M
InterestExpenseNonOperating389 M424 M543 M821 M1,039 M1,237 M1,855 M
InterestExpenseOperating1,855 M
MinorityInterests159 M450 M477 M439 M580 M1,953 M-1,034 M
MiscOtherSpecialCharges218 M294 M
Net income from total operations369 M124 M329 M211 M324 M766 M565 M
NetIncomeCommonStockholders285 M11 M192 M52 M141 M556 M565 M
NetIncomeContinuousOperations528 M574 M806 M650 M904 M2,719 M-480 M
NetNonOperatingInterestIncomeExpense392 M428 M555 M904 M1,179 M1,468 M-1,855 M
NetOperatingInterestIncomeExpense-1,855 M
Normalized income399 M549 M522 M682 M878 M2,450 M59 M
Operating income439 M1,116 M1,420 M1,709 M2,025 M2,884 M3,484 M
Operating income before depreciation (EBITDA)1,379 M1,842 M2,514 M2,963 M3,939 M6,606 M5,948 M
OperatingExpense613 M910 M1,024 M1,493 M312 M406 M2,591 M
Other income net496 M59 M305 M123 M349 M1,917 M-306 M
OtherCostofRevenue1,063 M1,509 M2,208 M3,395 M5,257 M6,733 M8,352 M
OtherGandA166 M239 M223 M279 M312 M406 M433 M
OtherunderPreferredStockDividend84 M113 M137 M159 M183 M210 M
PreferredStockDividends84 M113 M137 M159 M183 M210 M
Selling Gen & administrative expense166 M239 M223 M279 M312 M406 M433 M
Special income/charges338 M
Total Income available for interest expense (EBIT)932 M1,171 M1,713 M1,749 M2,234 M4,570 M3,790 M
Total common shares outstanding401 M415 M416 M440 M443 M458 M296 M
Total net income369 M124 M329 M211 M324 M766 M565 M
Total ordinary shares462 M462 M462 M462 M462 M462 M462 M
Total revenues2,115 M3,535 M4,652 M6,597 M8,885 M11,537 M14,427 M
TotalExpenses-1,676 M-2,419 M-3,232 M-4,888 M-6,860 M-8,653 M
TotalRevenue2,115 M3,535 M4,652 M6,597 M8,885 M11,537 M14,427 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.

We respect your privacy and will never share your email.
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