Note 5 - DERIVATIVES AND HEDGING ACTIVITIES (Tables)

6 Months Ended

Jun. 30, 2022

Notes Tables

Summary of derivatives

	June 30, 2022		December 31, 2021
	(dollars in thousands)
Assets:
Interest rate caps - hedged	$	6,108	$	927
Interest rate caps		1,576		238
Interest rate swaps - hedged		126		—
Interest rate swaps		89,645		221,055
	$	97,455	$	222,220
Liabilities:
Interest rate swaps - hedged	$	(23,660)	$	(4,080)
Interest rate swaps		(89,645)		(221,055)
	$	(113,305)	$	(225,135)

Schedule of hedged interest rate swaps and non-hedged interest rate swaps are collateralized by investment securities with carrying values

	June 30, 2022		December 31, 2021
	(dollars in thousands)
Cash	$	1,720	$	21,100
U.S treasuries and govt. sponsored agency securities		3,497		3,555
Municipal securities		109,018		139,166
Residential mortgage-backed and related securities		55,895		65,104
	$	170,130	$	228,925

Summary of impact of AOCI

	Three Months Ended June 30, 2022				Three Months Ended June 30, 2021
	Interest and		Interest		Interest and		Interest
	Dividend Income		Expense		Dividend Income		Expense
	(dollars in thousands)
Income and expense line items presented in the consolidated statements of income	$	68,205	$	8,805	$	48,903	$	5,387
The effects of cash flow hedging:
Gain (loss) on cash flow hedges:
Interest rate caps on deposits		-		241		-		163
Interest rate swaps on variable rate loans		671		-		-		-
Interest rate swaps on junior subordinated debentures		-		196		-		276

	Six Months Ended June 30, 2022				Six Months Ended June 30, 2021
	Interest and		Interest		Interest and		Interest
	Dividend Income		Expense		Dividend Income		Expense
	(dollars in thousands)
Income and expense line items presented in the consolidated statements of income	$	119,267	$	14,134	$	96,468	$	10,977
The effects of cash flow hedging:
Gain (loss) on cash flow hedges:
Interest rate caps on deposits		-		462				314
Interest rate swaps on variable rate loans		1,142		-		-		-
Interest rate swaps on junior subordinated debentures		-		463		-		545

Interest rate cap

Notes Tables

Schedule of interest rate caps

			Balance Sheet					Fair Value as of
Hedged Item	Effective Date	Maturity Date	Location	Notional Amount		Strike Rate		June 30, 2022		December 31, 2021
(dollars in thousands)
Deposits	1/1/2020	1/1/2023	Derivatives - Assets	$	25,000	1.75	%	$	122	$	5
Deposits	1/1/2020	1/1/2023	Derivatives - Assets		50,000	1.57	%		219		11
Deposits	1/1/2020	1/1/2023	Derivatives - Assets		25,000	1.80	%		109		5
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		25,000	1.75	%		529		60
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		50,000	1.57	%		1,081		125
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		25,000	1.80	%		540		62
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		25,000	1.75	%		861		161
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		50,000	1.57	%		1,765		332
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		25,000	1.80	%		882		166
				$	300,000			$	6,108	$	927

Changes in the fair value of the underlying derivative contracts

		Balance Sheet					Fair Value as of
Effective Date	Maturity Date	Location	Notional Amount		Strike Rate		June 30, 2022		December 31, 2021
(dollars in thousands)
1/1/2020	1/1/2023	Derivatives - Assets	$	25,000	1.90	%	$	119	$	3
2/1/2020	2/1/2024	Derivatives - Assets		25,000	1.90	%		555		62
3/1/2020	3/1/2025	Derivatives - Assets		25,000	1.90	%		902		173
			$	75,000			$	1,576	$	238

Interest rate swap

Notes Tables

Schedule of interest rate caps

			Balance Sheet							Fair Value as of
Hedged Item	Effective Date	Maturity Date	Location	Notional Amount		Receive Rate		Pay Rate		June 30, 2022		December 31, 2021
(dollars in thousands)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities	$	35,000	1.40	%	1.79	%	$	(4,038)	$	(17)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities		50,000	1.40	%	1.79	%		(5,768)		(25)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities		40,000	1.40	%	1.79	%		(4,627)		(34)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities		25,000	1.40	%	1.79	%		(2,884)		(13)
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		15,000	1.91	%	1.79	%		(630)		N/A
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		50,000	1.91	%	1.79	%		(2,100)		N/A
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		35,000	1.91	%	1.79	%		(1,470)		N/A
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		50,000	1.91	%	1.79	%		(2,100)		N/A
				$	300,000					$	(23,617)	$	(89)

				Balance Sheet							Fair Value as of
Hedged Item	Effective Date		Maturity Date	Location	Notional Amount		Receive Rate		Pay Rate		June 30, 2022		December 31, 2021
		(dollars in thousands)
QCR Holdings Statutory Trust II	9/30/2018		9/30/2028	Derivatives - Liabilities	$	10,000	3.86	%	5.85	%	$	(12)	$	(1,035)
QCR Holdings Statutory Trust III	9/30/2018		9/30/2028	Derivatives - Liabilities		8,000	3.86	%	5.85	%		(9)		(828)
QCR Holdings Statutory Trust V	7/7/2018		7/7/2028	Derivatives - Liabilities		10,000	1.79	%	4.54	%		(3)		(996)
Community National Statutory Trust II	9/20/2018		9/20/2028	Derivatives - Liabilities		3,000	3.10	%	5.17	%		(4)		(309)
Community National Statutory Trust III	9/15//2018		9/15/2028	Derivatives - Liabilities		3,500	2.58	%	4.75	%		(7)		(360)
Guaranty Bankshares Statutory Trust I	9/15/2018		9/15/2028	Derivatives - Liabilities		4,500	2.58	%	4.75	%		(8)		(463)
Guaranty Statutory Trust II*	12/15/2005		2/23/2036	Derivatives - Liabilities		10,310	2.95	%	4.09	%		126		N/A
					$	49,310					$	83	$	(3,991)

Changes in the fair value of the underlying derivative contracts

		June 30, 2022			December 31, 2021
	Notional Amount		Estimated Fair Value		Notional Amount		Estimated Fair Value
	(dollars in thousands)
Non-Hedging Interest Rate Derivatives Assets:
Interest rate swap contracts	$	2,213,781	$	89,645	$	2,024,599	$	221,055
Non-Hedging Interest Rate Derivatives Liabilities:
Interest rate swap contracts	$	2,213,781	$	89,645	$	2,024,599	$	221,055