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 Income Statement

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles-141,104 M0.0-198,169 M-175,991 M
Basic EPS from continuing operations5560.05650.03301.0347.04309.07113.0
Basic EPS total5560.05650.03301.0347.04309.07113.0
Basic weighted shares outstanding510 M510 M510 M16,328 M510 M510 M
BasicDiscontinuousOperations0.0
CommissionExpenses1,075,115 M1,213,056 M1,553,239 M1,561,585 M1,860,683 M2,590,166 M
CreditCard2,658,864 M
Depletion267,507 M
Depreciation479,111 M493,902 M824,590 M837,790 M920,558 M980,575 M
Depreciation unreconciled479,111 M761,409 M824,590 M837,790 M920,558 M980,575 M
DepreciationAndAmortization479,111 M493,902 M824,590 M837,790 M920,558 M980,575 M
Diluted EPS total5560.05650.03301.0347.04309.07113.0
Diluted normalized net income/share347.04309.07113.0
Diluted weighted shares outstanding510 M510 M510 M16,328 M510 M510 M
DividendIncome1,918,655 M108,079 M59,072 M
Equipment173,339 M
FeesAndCommissions3,621,114 M8,566,319 M4,578,972 M4,874,407 M6,734,297 M8,831,982 M
GeneralAndAdministrativeExpense3,151,223 M3,024,769 M3,304,583 M3,140,789 M3,740,506 M4,559,900 M
ImpairmentOfCapitalAssets-46,078 M-3,851,625 M-3,385,181 M0.0-1,733 M-9,633 M
Income before tax7,539,696 M8,058,582 M8,405,517 M5,620,008 M9,358,810 M16,079,192 M
Income taxes1,238,598 M829,435 M1,262,964 M-6,586 M1,776,225 M2,748,421 M
InsuranceAndClaims-303,501 M-331,430 M-423,785 M0.0-495,146 M-640,753 M
Interest expense6,232,986 M5,670,216 M6,179,794 M5,863,008 M4,351,556 M8,442,470 M
InterestExpenseForCapitalizedLeaseObligations-121,946 M0.0-111,556 M-111,349 M
InterestExpenseForDeposit-4,279,316 M-3,852,061 M-4,164,798 M0.0-2,814,505 M-6,141,680 M
InterestExpenseForLongTermDebt-672,472 M-583,321 M-627,058 M0.0-293,949 M-763,717 M
InterestExpenseForLongTermDebtAndCapitalSecurities-672,472 M-583,321 M-749,004 M-646,425 M-405,505 M-875,066 M
InterestIncome18,626,080 M13,689,677 M14,777,389 M16,165,339 M18,000,005 M29,167,489 M
InterestIncomeAfterProvisionForLoanLoss12,393,094 M8,019,461 M8,597,595 M10,302,331 M13,648,449 M20,725,019 M
InterestIncomeFromInvestmentSecurities3,117,351 M
InterestIncomeFromLeases1,829,971 M
InterestIncomeFromLoans13,915,319 M11,542,485 M12,592,419 M12,287,452 M11,435,912 M18,772,221 M
InterestIncomeFromLoansAndLease13,915,319 M11,542,485 M12,592,419 M14,117,423 M11,435,912 M18,772,221 M
InterestIncomeFromOtherMoneyMarketInvestments6,783,490 M
InterestIncomeFromSecurities2,615,000 M3,117,351 M6,783,490 M
MinorityInterests139,173 M127,571 M97,216 M39,365 M120,992 M212,875 M
Net income from total operations6,440,271 M7,356,718 M7,239,769 M5,665,959 M7,703,577 M13,543,646 M
NetIncomeCommonStockholders6,440,271 M7,356,718 M7,239,769 M5,665,959 M7,703,577 M13,543,646 M
NetIncomeContinuousOperations6,440,271 M7,356,718 M7,239,769 M5,665,959 M7,703,577 M13,543,646 M
NetIncomeDiscontinuousOperations0.0
NetInterestIncome12,393,094 M8,019,461 M8,597,595 M10,302,331 M13,648,449 M20,725,019 M
NetOccupancyExpense249,023 M
NonInterestExpense8,474,512 M8,527,198 M9,807,056 M9,556,730 M11,023,936 M13,477,809 M
NonInterestIncome3,621,114 M8,566,319 M9,614,978 M4,874,407 M6,734,297 M8,831,982 M
OccupancyAndEquipment249,023 M
OtherCustomerServices275,051 M361,025 M499,026 M182,132 M108,034 M2,461,456 M
OtherGandA3,151,223 M3,024,769 M3,304,583 M3,140,789 M3,740,506 M4,559,900 M
OtherInterestExpense6,232,986 M5,670,216 M6,179,794 M5,863,008 M4,351,556 M8,442,470 M
OtherInterestIncome2,095,761 M2,147,192 M2,184,970 M2,047,916 M6,564,093 M3,611,778 M
OtherNonInterestExpense-67,201 M-73,072 M-77,375 M0.0-71,861 M-72,501 M
ProfessionalExpenseAndContractServicesExpense-25,855 M-31,072 M-38,972 M0.0-6,834 M-10,573 M
PromotionAndAdvertising267,507 M206,070 M
PropertyCasualtyPremiums2,658,864 M3,117,351 M
RentAndLandingFees235,525 M
Research & development expense-105,145 M-168,756 M-85,532 M
ResearchExpense-105,145 M-168,756 M0.0
Revenue per share-116,752 M-123,551 M0.0206,070 M-198,169 M-175,991 M
SalariesAndWages2,792,379 M3,004,054 M3,366,824 M3,044,730 M3,782,596 M4,417,656 M
SecuritiesActivities1,440,493 M
Selling Gen & administrative expense7,018,717 M7,241,879 M8,224,646 M7,953,174 M9,383,785 M11,567,722 M
SellingAndMarketingExpense1,075,115 M1,213,056 M1,553,239 M1,767,655 M1,860,683 M2,590,166 M
ServiceChargeOnDepositorAccounts3,621,114 M3,994,259 M4,578,972 M4,874,407 M5,293,804 M6,370,526 M
Special income/charges113,279 M3,924,697 M3,462,556 M7,411,602 M73,594 M82,134 M
Total common shares outstanding510 M510 M510 M510 M510 M510 M
Total net income6,440,271 M7,356,718 M7,239,769 M5,665,959 M7,703,577 M13,543,646 M
Total ordinary shares240 M240 M240 M240 M240 M240 M
Total revenues16,014,208 M16,585,780 M18,212,573 M15,176,738 M20,382,746 M29,557,001 M
TotalPremiumsEarned2,658,864 M5,036,006 M
TotalRevenue16,014,208 M16,585,780 M18,212,573 M15,176,738 M20,382,746 M29,557,001 M
TrustFeesbyCommissions1,913,196 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