Note 4 - DERIVATIVES AND HEDGING ACTIVITIES (Tables)

6 Months Ended

Jun. 30, 2023

Notes Tables

Summary of derivatives

	June 30, 2023		December 31, 2022
	(dollars in thousands)
Assets:
Interest rate caps - hedged	$	6,673	$	8,327
Interest rate caps		1,869		2,213
Interest rate swaps - hedged		2,580		477
Interest rate swaps		159,172		166,614
	$	170,294	$	177,631
Liabilities:
Interest rate collars - hedged	$	(688)	$	(263)
Interest rate swaps - hedged		(35,981)		(33,824)
Interest rate swaps		(159,172)		(166,614)
	$	(195,841)	$	(200,701)

Summary of impact of AOCI

	Three Months Ended June 30, 2023				Three Months Ended June 30, 2022
	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	$	98,377	$	45,172	$	68,205	$	8,805
The effects of cash flow hedging:
Gain (loss) on cash flow hedges:
Interest rate caps on deposits		-		(1,875)		-		241
Interest rate swaps and collars on variable rate loans		(2,207)		-		671		-
Interest rate swaps on junior subordinated debentures		-		(275)		-		240

	Six Months Ended June 30, 2023				Six Months Ended June 30, 2022
	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	$	192,594	$	82,579	$	119,267	$	14,134
The effects of cash flow hedging:
Gain (loss) on cash flow hedges:
Interest rate caps on deposits		-		(3,456)		-		462
Interest rate swaps on variable rate loans		(4,262)		-		1,142		-
Interest rate swaps on junior subordinated debentures		-		(502)		-		463

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

	June 30, 2023		December 31, 2022
	(dollars in thousands)
Cash	$	1,261	$	1,272
Municipal securities		3,954		8,227
Residential mortgage-backed and related securities		5,987		29,257
	$	11,202	$	38,756

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, 2023		December 31, 2022
(dollars in thousands)
Deposits	1/1/2020	1/1/2023	Derivatives - Assets	$	25,000	1.75	%	$	-	$	(50)
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		25,000	1.75	%		382		714
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		50,000	1.57	%		929		1,566
Deposits	1/1/2020	1/1/2024	Derivatives - Assets		25,000	1.80	%		465		783
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		25,000	1.75	%		1,159		1,264
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		50,000	1.57	%		2,492		2,700
Deposits	1/1/2020	1/1/2025	Derivatives - Assets		25,000	1.80	%		1,246		1,350
				$	225,000			$	6,673	$	8,327

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, 2023		December 31, 2022
(dollars in thousands)
1/1/2020	1/3/2023	Derivatives - Assets	$	25,000	1.90	%	$	-	$	3
2/1/2020	2/1/2024	Derivatives - Assets		25,000	1.90	%		534		822
3/1/2020	3/3/2025	Derivatives - Assets		25,000	1.90	%		1,335		1,388
			$	75,000			$	1,869	$	2,213

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, 2023		December 31, 2022
(dollars in thousands)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities	$	35,000	1.40	%	5.22	%	$	(5,585)	$	(5,646)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities		50,000	1.40	%	5.22	%		(7,979)		(8,066)
Loans	7/1/2021	7/1/2031	Derivatives - Liabilities		40,000	1.40	%	5.22	%		(6,394)		(6,464)
Loans	10/1/2022	7/1/2031	Derivatives - Liabilities		25,000	1.30	%	5.09	%		(4,039)		(4,018)
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		15,000	1.91	%	5.22	%		(1,198)		(1,144)
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		50,000	1.91	%	5.22	%		(3,995)		(3,812)
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		35,000	1.91	%	5.22	%		(2,796)		(2,669)
Loans	4/1/2022	4/1/2027	Derivatives - Liabilities		50,000	1.91	%	5.22	%		(3,995)		(3,812)
				$	300,000					$	(35,981)	$	(35,631)

				Balance Sheet							Fair Value as of
Hedged Item	Effective Date		Maturity Date	Location	Notional Amount		Receive Rate		Pay Rate		June 30, 2023		December 31, 2022
		(dollars in thousands)
QCR Holdings Statutory Trust II	9/30/2018		9/30/2028	Derivatives - Assets	$	10,000	8.39	%	5.85	%	$	519	$	464
QCR Holdings Statutory Trust III	9/30/2018		9/30/2028	Derivatives - Assets		8,000	8.39	%	5.85	%		415		372
QCR Holdings Statutory Trust V	7/7/2018		7/7/2028	Derivatives - Assets		10,000	7.13	%	4.54	%		513		459
Community National Statutory Trust II	9/20/2018		9/20/2028	Derivatives - Assets		3,000	7.68	%	5.17	%		156		140
Community National Statutory Trust III	9/15//2018		9/15/2028	Derivatives - Assets		3,500	7.30	%	4.75	%		182		163
Guaranty Bankshares Statutory Trust I	9/15/2018		9/15/2028	Derivatives - Assets		4,500	7.30	%	4.75	%		234		209
Guaranty Statutory Trust II*	5/23/2019		2/23/2026	Derivatives - Assets		10,310	6.84	%	4.09	%		561		477
					$	49,310					$	2,580	$	2,284

*Acquired on 4/1/2022 with GFED acquisition.

Changes in the fair value of the underlying derivative contracts

		June 30, 2023			December 31, 2022
	Notional Amount		Estimated Fair Value		Notional Amount		Estimated Fair Value
	(dollars in thousands)
Non-Hedging Interest Rate Derivatives Assets:
Interest rate swap contracts	$	2,926,858	$	159,172	$	2,528,949	$	166,614
Non-Hedging Interest Rate Derivatives Liabilities:
Interest rate swap contracts	$	2,926,858	$	159,172	$	2,528,949	$	166,614

Interest rate collar

Notes Tables

Schedule of interest rate caps

										Fair Value as of
Hedged Item	Effective Date	Maturity Date	Location	Notional Amount		Cap Strike Rate		Floor Strike Rate		June 30, 2023		December 31, 2022
Loans	10/1/2022	10/1/2026	Derivatives - Liabilities	$	50,000	4.40	%	2.44	%	$	(688)	$	(263)