Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
QCR Holdings Inc. logo

QCR Holdings Inc.

Sector: Financial Services   

Industry: Banks - Regional - US

57.29
 
USD
  
0.29
  
(0.51%)
Optionable: Yes  Market Cap: 923 M  90-day average vol: 55,992

Previous close: 57.0  Open: 57.94  Bid: 22.99  Ask: 91.93
52 week range    
36.56   
   62.94
Peers   
EFSC / 
WTBA / 
MOFG / 
ATLO / 
GSBC / 
HWBK / 
CBSH / 
GFED / 
UMBF / 
Last updated: Monday 6th May 2024
52
MarketXLS Rank
60
Value
46
Technical
50
Quality

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

QCRH Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""309 M183 M73 M51 M66 M51 M43 M42 M178 M50 M
Accumulated depreciation & depletion-26 M-29 M-32 M-36 M-41 M-46 M-51 M-52 M-63 M-65 M
Additional paid in capital62 M123 M157 M189 M271 M275 M276 M274 M371 M371 M
AdvanceFromFederalHomeLoanBanks204 M151 M138 M192 M266 M159 M15 M15 M415 M435 M
AllowanceForLoansAndLeaseLosses23 M26 M31 M34 M40 M36 M84 M79 M180000.0203000.0
AssetsHeldForSale553000.0565850.01 M645001.01 M4 M4 M4 M2 M3 M
AssetsOfDiscontinuedOperations12 M3 M
AvailableForSaleSecurities452 M323 M251 M273 M261 M211 M838 M810 M341 M300 M
BankOwnedLifeInsurance54 M55 M57 M59 M68 M59 M61 M62 M107 M108 M
Cash and equivalents38 M42 M71 M76 M86 M76 M61 M113 M60 M97 M
CashAndDueFromBanks23 M
CashEquivalents35 M36 M64 M56 M133 M
Common par8 M12 M13 M14 M16 M16 M16 M16 M17 M17 M
Common stock equity144 M226 M286 M353 M473 M535 M594 M677 M773 M887 M
CommonStock8 M12 M13 M14 M16 M16 M16 M16 M17 M17 M
Construction in progress4 M8 M
Cost in excess3 M3 M13 M28 M78 M75 M74 M74 M138 M139 M
CurrentDeferredTaxesLiabilities28 M29 M29 M20 M25 M28 M19 M19 M16 M17 M
DeferredTaxAssets13536.029 M14 M40 M38 M
Deposits1,680 M1,881 M2,669 M3,267 M3,977 M3,911 M4,599 M4,923 M5,984 M6,514 M
DerivativeAssets1 M856024.088 M223 M222 M178 M187 M
DerivativeProductLiabilities88 M229 M225 M201 M216 M
FederalFundsPurchased131 M71 M32 M7 M27 M11 M5 M4 M130 M2 M
FederalFundsSold47 M20 M22 M30 M26 M10 M9 M12 M57 M35 M
FederalFundsSoldAndSecuritiesPurchaseUnderAgreementsToResell47 M20 M22 M30 M26 M10 M9 M12 M57 M35 M
FederalHomeLoanBankStock63 M103 M9 M12 M16 M12 M7 M8 M26 M25 M
FinancialInstrumentsSoldUnderAgreementsToRepurchase165 M
Float term debt354 M261 M218 M258 M339 M228 M134 M129 M648 M668 M
ForeclosedAssets13 M7 M6 M14 M9 M4 M20000.0133000.01 M
GoodwillAndOtherIntangibleAssets5 M5 M20 M37 M95 M90 M85 M83 M154 M153 M
Gross fixed assets (Plant Property & Equipment)62 M66 M93 M99 M116 M120 M124 M131 M181 M188 M
GrossLoan1,629 M1,797 M2,404 M2,964 M3,731 M3,687 M4,247 M4,676 M
GrossNotesReceivable4,676 M6,137 M6,541 M
HeldToMaturitySecurities200 M254 M323 M379 M402 M401 M521 M522 M587 M684 M
Intangibles2 M1 M7 M9 M17 M15 M11 M9 M17 M14 M
InterestBearingDepositsAssets148 M87 M75 M67 M105 M
InterestBearingDepositsLiabilities1,168 M1,265 M1,872 M2,477 M3,186 M3,134 M3,454 M3,654 M4,721 M5,475 M
Invested capital648 M597 M584 M677 M884 M831 M846 M920 M1,653 M1,788 M
Land & improvements7 M7 M13 M13 M16 M14 M13 M13 M18 M18 M
LiabilitiesOfDiscontinuedOperations5 M946000.0
LoansHeldForSale553000.0565850.01 M645000.01 M
LoansReceivable1,629 M1,772 M2,375 M2,930 M3,693 M3,687 M4,247 M101 M113 M126 M
LongTermCapitalLeaseObligation2 M2 M1 M4 M
LongTermDebtAndCapitalLeaseObligation354 M261 M218 M258 M339 M228 M134 M129 M648 M668 M
Machinery furniture & equipment23 M25 M28 M32 M36 M40 M43 M48 M54 M52 M
MoneyMarketInvestments47 M20 M22 M30 M26 M10 M9 M12 M57 M35 M
MortgageLoan170000.0685000.0
Net fixed assets (net PP&E)36 M37 M61 M63 M76 M74 M73 M79 M118 M123 M
Net loans1,606 M1,771 M2,374 M2,929 M3,692 M3,651 M4,163 M-79 M-88 M
NetUnrealizedGainLossInvestments3 M9 M6 M-45 M-36 M
NonInterestBearingDeposits512 M615 M797 M790 M791 M777 M1,145 M1,269 M1,263 M1,039 M
Notes payable30 M
NotesReceivable4,676 M6,137 M6,541 M
Number of employees924.0924.0924.0924.0924.0924.0924.0924.0924.0924.0
Other equity adjustments-1 M-1 M1 M2 M-65 M-56 M
Other receivable42 M42 M62 M66 M125 M15 M24 M32 M
OtherAssets23 M27 M38 M46 M75 M60 M84 M93 M186 M225 M
OtherCurrentBorrowings309 M183 M73 M51 M66 M51 M43 M42 M178 M50 M
OtherDeposits1,680 M1,881 M3,977 M3,911 M4,599 M4,923 M5,984 M6,514 M
OtherEquityAdjustments-1 M-4 M-8 M-4 M-20 M-20 M
OtherEquityInterest-2 M-2 M-2 M-2 M-4 M
OtherLiabilities39 M42 M56 M53 M95 M90 M106 M100 M78 M117 M
OtherLoanAssets1,797 M2,404 M2,964 M3,731 M
RestrictedCashAndCashEquivalents38 M
RestrictedCashAndInvestments16 M15 M15 M20 M26 M23 M18 M19 M43 M42 M
RestrictedInvestments16 M15 M15 M20 M26 M23 M18 M19 M43 M42 M
Retained earnings78 M93 M119 M152 M192 M246 M301 M386 M450 M555 M
SecuritiesAndInvestments652 M577 M574 M652 M663 M611 M838 M810 M928 M1,006 M
Short term debt309 M183 M73 M51 M66 M51 M43 M42 M178 M50 M
TimeDepositsPlaced236 M301 M364 M593 M293 M176 M169 M372 M511 M
Total assets2,525 M2,593 M3,302 M3,983 M4,950 M4,909 M5,705 M6,096 M7,949 M8,539 M
Total equity144 M226 M286 M353 M473 M535 M594 M677 M773 M887 M
Total liabilities2,381 M2,367 M3,016 M3,629 M4,477 M4,374 M5,111 M5,419 M7,176 M7,652 M
TotalEquityGrossMinority144 M226 M286 M353 M473 M535 M594 M677 M773 M887 M
TotalEquityGrossMinorityInterest144 M226 M286 M353 M473 M535 M594 M677 M773 M887 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,525 M2,593 M3,302 M3,983 M4,950 M4,909 M5,705 M6,096 M7,949 M8,539 M
TradingSecurities22 M
Treasury stock-2 M
UnrealizedGainLoss3 M9 M6 M-45 M-36 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