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

CIB Cash Flow

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in other current assets-23,083 M-282,703 M-986,022 M83,393 M-278,776 M-724,769 M
(Increase) Decrease in other current liabilities173,047 M176,949 M37,856 M-114,711 M251,037 M481,469 M
(Increase) Decrease in other working capital-2,810,108 M-6,763,952 M2,177,296 M13,566,536 M-4,767,249 M-14,379,557 M
(Increase) Decrease in payables-629,990 M-273,855 M-977,266 M-10,507 M1,271,347 M2,719,586 M
(Increase) Decrease in receivables338,211 M-423,960 M-185,220 M-408,015 M-489,266 M515,052 M
Acquisitions-1,117,680 M-9,178 M-816,081 M
AssetImpairmentCharge3,879,559 M3,851,625 M3,385,181 M7,335,755 M2,521,178 M3,721,353 M
Cash at beginning of period20,460,245 M18,165,644 M18,730,810 M23,738,042 M23,701,149 M25,329,846 M
Cash at end of period18,176,494 M16,871,420 M23,635,610 M22,642,229 M22,380,911 M28,348,135 M
Cash flow4,255,525 M-391,846 M11,313,416 M12,133,465 M4,638,102 M5,984,738 M
CashFlowFromContinuingInvestingActivities-1,604,925 M-1,092,507 M-2,150,120 M-7,410,718 M-605,571 M-4,399,373 M
ChangeInAccountPayable-629,990 M-273,855 M-977,266 M-10,507 M1,271,347 M2,719,586 M
ChangeInPayablesAndAccruedExpense-629,990 M-273,855 M-977,266 M-10,507 M1,271,347 M2,719,586 M
ChangeInWorkingCapital-2,951,923 M-7,567,521 M66,644 M13,116,696 M-4,012,907 M-11,388,219 M
ChangesInAccountReceivables338,211 M-423,960 M-185,220 M-408,015 M-489,266 M515,052 M
CommonStockDividendPaid-1,126,209 M-735,798 M-1,032,492 M-1,555,821 M-467,217 M-2,310,666 M
Current deferred income taxes1,238,598 M829,435 M1,262,964 M-6,586 M1,776,225 M2,748,421 M
Deferred income taxes1,238,598 M829,435 M1,262,964 M-6,586 M1,776,225 M2,748,421 M
Depreciation433,033 M467,777 M677,253 M736,367 M855,167 M949,448 M
Depreciation unreconciled433,033 M467,777 M677,253 M736,367 M855,167 M949,448 M
DepreciationAndAmortization433,033 M467,777 M677,253 M736,367 M855,167 M949,448 M
EarningsLossesFromEquityInvestments83,146 M124,754 M195,046 M90,737 M90,822 M81,899 M
FinancingCashFlow-4,934,351 M190,129 M-4,258,496 M-5,818,560 M-5,352,769 M1,432,924 M
Free cash flow3,600,077 M-1,221,745 M9,876,180 M10,765,941 M2,861,606 M2,622,408 M
GainLossOnInvestmentSecurities-253,602 M-187,814 M-249,231 M-136,596 M-199,652 M-219,105 M
GainLossOnSaleOfBusiness2,700 M510 M-77,916 M41,434 M
GainLossOnSaleOfPPE-40,600 M-75,976 M-93,548 M-65,932 M-227,445 M-171,482 M
Issuance of debt-17,042,665 M-14,472,128 M-14,365,716 M-14,919,903 M-8,447,238 M-5,874,833 M
IssuanceOfDebt-3,808,142 M565,758 M-3,226,004 M-4,221,545 M-4,885,552 M3,780,781 M
Net cash from financing activities-4,934,351 M190,129 M-4,258,496 M-5,818,560 M-5,352,769 M1,432,924 M
Net cash from investing activities-1,604,925 M-1,092,507 M-2,150,120 M-7,410,718 M-605,571 M-4,399,373 M
Net cash from operating activities4,255,525 M-391,846 M11,313,416 M12,133,465 M4,638,102 M5,984,738 M
Net change in cash & cash equivalents-2,283,751 M-1,294,224 M4,904,800 M-1,095,813 M-1,320,238 M3,018,289 M
Net income from continuing operations1,614,918 M3,929,991 M7,215,279 M-6,661,699 M6,764,573 M13,444,341 M
NetBusinessPurchaseAndSale5,945 M29,752 M131,173 M-1,062,506 M69,448 M-617,274 M
NetForeignCurrencyExchangeGainLoss1,313,442 M-922,840 M-1,002,196 M903,120 M-1,457,203 M-579,488 M
NetInvestmentPropertiesPurchaseAndSale2,167,450 M2,214,457 M2,405,509 M2,728,509 M2,984,260 M4,260,063 M
NetInvestmentPurchaseAndSale2,167,450 M2,214,457 M2,405,509 M2,728,509 M2,984,260 M4,260,063 M
NetIssuancePaymentsOfDebt-3,808,142 M565,758 M-3,226,004 M-4,221,545 M-4,885,552 M3,780,781 M
NetLongTermDebtIssuance13,234,523 M15,037,886 M11,139,712 M10,698,358 M3,561,686 M9,655,614 M
NetPPEPurchaseAndSale-655,448 M-829,899 M-1,437,236 M-1,367,524 M-1,776,496 M-3,362,330 M
Operating (gains) losses1,105,086 M-1,061,366 M-1,227,845 M791,329 M-1,793,478 M-846,742 M
Other financing charges net360,169 M-41,194 M-37,191 M
Other non-cash items3,386,063 M3,066,359 M2,627,842 M6,691,071 M1,996,737 M3,380,241 M
Payment of cash dividends1,126,209 M735,798 M1,032,492 M1,555,821 M467,217 M2,310,666 M
Purchase of property plant & equipment-655,448 M-829,899 M-1,437,236 M-1,367,524 M-1,776,496 M-3,362,330 M
Purchase of short term investments15,203,922 M16,924,736 M13,826,054 M16,220,165 M5,570,059 M16,512,235 M
PurchaseOfPPE-1,224,192 M-1,141,329 M-1,669,674 M-1,636,422 M-2,330,148 M-3,784,059 M
Repayment of debt-1,969,399 M-1,886,850 M-2,686,342 M-5,521,807 M-2,008,373 M-6,856,621 M
RepaymentOfDebt-19,012,064 M-16,358,978 M-17,052,058 M-20,441,710 M-10,455,611 M-12,731,454 M
SaleOfBusiness5,945 M29,752 M131,173 M55,174 M69,448 M198,807 M
SaleOfInvestment2,167,450 M2,214,457 M2,405,509 M2,728,509 M2,984,260 M4,260,063 M
SaleOfPPE568,744 M311,430 M232,438 M268,898 M553,652 M421,729 M
ShortTermDebtPayments-17,042,665 M-14,472,128 M-14,365,716 M-14,919,903 M-8,447,238 M-5,874,833 M
UnrealizedGainLossOnInvestmentSecurities39,750 M-244,613 M285,220 M-629,258 M-319,524 M-68,055 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