QCR HOLDINGS INC QCRH Cash Flow

Qcr holdings inc (QCRH)

CashFlow / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Net income
55,718	57,408	54,833	48,547	45,488	43,120	39,706	38,751	37,072	35,707	34,334	32,587	30,498	27,686	25,942	26,323	19,123	16,927	13,135	10,709	15,241	14,952	15,775	15,524	15,562	14,938	14,367	13,740	12,968	13,106	12,719	11,801	11,301	10,129	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation
5,328	5,225	5,083	4,894	4,665	4,451	4,395	4,176	4,073	3,949	3,812	3,719	3,555	3,424	3,203	3,096	3,085	3,065	3,003	2,942	2,865	2,812	2,792	2,805	2,803	2,695	2,605	2,432	2,343	2,350	2,317	2,356	2,439	2,442	0	0	0
Provision for loan/lease losses
13,299	7,066	7,699	11,892	12,252	12,658	13,301	9,182	8,904	8,470	8,813	8,335	7,510	7,478	6,055	6,082	7,233	6,870	9,342	8,770	7,423	6,807	5,144	5,448	5,966	5,930	4,990	5,119	4,648	4,370	4,744	5,705	6,328	6,616	0	0	0
Amortization of offering costs on subordinated debentures
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Stock-based compensation expense
2,388	2,469	2,206	2,097	1,670	1,443	1,435	1,416	1,293	1,187	1,044	933	953	947	943	957	956	941	946	919	911	891	876	863	846	792	796	802	817	849	822	801	776	696	0	0	0
Deferred compensation expense accrued
2,953	2,773	2,458	2,143	2,045	1,824	1,780	1,705	2,342	1,426	3,180	2,519	1,085	1,171	-1,166	-880	-905	-1,023	-1,081	-1,393	-1,401	-1,311	-1,195	-1,087	-1,374	-822	0	0	0	-	-	-	-	-	-	-	-
Losses on other real estate owned, net
-3,141	-3,361	-5,741	-3,681	-2,691	-2,585	-52	36	33	151	41	-89	-251	-243	-313	793	1,057	1,021	870	-232	-458	-447	-92	-160	-116	-545	-575	-1,284	-1,590	-1,332	-1,608	-820	-539	-374	0	0	0
Amortization of premiums on securities, net
-1,272	-1,561	-1,752	-1,639	-1,623	-1,614	-1,709	-1,662	-1,930	-1,839	-1,665	-1,696	-1,355	-1,302	-1,251	-1,167	-1,120	-1,040	-1,096	-1,291	-1,488	-1,809	-2,182	-2,604	-3,136	-3,574	-3,858	-3,868	-3,936	-3,946	-3,896	-3,833	-5,359	-3,487	0	0	0
Caplet amortization
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Securities losses, net
-	-	-	-	-	-	-	-	-	-	-	-	-	4,592	4,953	758	736	798	525	488	492	92	0	0	0	-	-	-	-	-	-	-	-	1,472	0	0	0
Loans originated for sale
168,117	151,692	122,599	81,725	62,793	57,698	49,078	39,347	41,101	49,579	57,592	62,934	76,844	74,329	65,940	67,068	51,001	38,748	55,453	51,119	58,421	58,128	42,101	49,970	59,453	80,027	100,436	120,821	123,288	120,430	126,112	109,509	104,618	100,789	0	0	0
Proceeds on sales of loans
169,688	152,633	117,315	80,250	62,324	58,353	47,890	39,906	42,858	51,642	60,717	66,496	80,757	77,850	69,047	70,990	53,434	40,362	59,051	52,797	60,325	61,435	43,396	52,486	63,528	86,231	108,438	126,413	127,553	122,143	127,722	109,742	104,761	113,606	0	0	0
Gains on sales of residential real estate loans
2,854	2,571	2,110	1,556	1,169	901	640	403	413	409	449	495	467	431	345	285	297	322	409	445	483	460	430	494	608	836	1,123	1,363	1,387	1,388	62	47	530	999	0	0	0
Gains on sales of government guaranteed portions of loans
-	748	589	117	78	405	439	484	571	1,164	1,587	1,714	3,231	3,159	3,105	3,646	2,112	1,304	2,079	1,478	1,917	2,040	1,060	1,240	1,497	2,148	2,039	1,961	1,807	1,069	0	0	0	-	-	-	-
Losses on debt extinguishment
0	-	-	-	-	-	-	-	-	-	-	-	-	-4,577	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gains on sales of premises and equipment
-792	-753	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Intangibles amortization
2,283	2,266	2,247	2,230	1,919	1,692	1,459	1,148	1,075	1,001	924	804	623	442	260	199	199	199	199	199	199	199	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Accretion of acquisition fair value adjustments, net
3,900	4,344	5,989	6,428	5,897	5,527	3,828	2,606	3,724	4,941	7,091	7,235	5,588	3,718	722	695	589	367	1,559	712	657	674	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Prepayment fees on Federal Home Loan Bank advances
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	832	0	0	0
Increase in accrued interest receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Increase in cash value of bank-owned life insurance
1,762	1,973	1,781	1,767	1,754	1,632	1,736	1,689	1,750	1,802	1,804	1,826	1,847	1,771	1,767	1,724	1,676	1,762	1,763	1,790	1,746	1,721	1,734	1,766	1,801	1,786	1,740	1,674	1,609	1,609	0	0	0	-	-	-	-
Goodwill impairment
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Decrease in other assets
14,356	19,152	4,797	5,063	5,578	11,137	9,233	7,818	9,139	-726	-3,203	-6,798	-13,779	943	1,179	3,473	13,693	3,910	6,062	4,342	4,515	1,198	16	528	-10,866	-7,650	-5,371	-13,860	-1,176	-1,153	-805	10,749	2,137	1,588	0	0	0
Decrease in other liabilities
11,027	23,915	5,621	-2,764	1,317	7,539	2,618	4,501	-5,281	-8,246	44	1,823	-662	10,269	66	5,830	9,641	2,721	3,971	2,483	6,623	414	-823	-1,557	-4,976	1,017	3,873	2,310	2,067	2,793	2,437	1,721	2,591	1,918	0	0	0
Net cash provided by operating activities
74,484	76,494	73,519	64,230	64,970	64,271	43,422	44,162	30,782	33,713	44,706	47,527	49,094	43,382	32,743	35,986	30,156	30,098	29,932	27,167	27,503	25,599	20,224	19,691	27,960	32,036	40,569	45,720	32,318	30,654	30,968	16,554	25,098	36,640	0	0	0
CASH FLOWS FROM INVESTING ACTIVITIES
Net decrease in federal funds sold
-2,823	16,598	23,770	651	12,633	3,799	-12,502	8,317	1,293	-7,940	454	2,340	640	-1,709	14,006	1,730	-1,705	26,930	-4,570	-2,065	-2,465	-7,345	18,432	-3,824	765	-540	-30,132	-706	0	-5,775	65	4,375	69,260	41,175	0	0	0
Net increase in interest-bearing deposits at financial institutions
-43,144	-69,984	-93,787	-91,556	-106,184	-14,508	11,509	16,324	116,323	12,138	33,804	9,166	-101,201	-12,904	-28,019	75	-24,370	-979	2,356	-10,896	27,270	-2,289	-18,768	-2,212	-8,583	-8,660	35,598	-4,096	-8,293	4,391	-24,771	-1,159	2,886	12,995	0	0	0
Proceeds from sales of other real estate owned
1,465	840	2,091	2,342	2,005	2,539	1,596	1,386	1,839	1,138	1,000	1,707	1,624	2,084	2,835	6,837	7,858	7,696	7,195	2,545	1,827	1,593	1,855	1,813	1,426	1,345	1,702	4,730	5,047	5,241	5,045	7,416	7,579	9,220	0	0	0
Activity in securities portfolio:
Purchases
151,871	71,963	45,744	39,803	81,024	84,045	142,696	149,567	174,747	179,786	171,485	167,636	146,665	179,598	143,465	147,952	152,595	232,092	228,012	221,438	174,681	76,256	64,430	110,525	151,462	312,970	407,992	401,626	503,034	474,461	527,666	634,496	613,077	622,245	0	0	0
Calls, maturities and redemptions
24,555	25,193	10,090	17,270	23,901	23,931	25,489	22,549	30,164	43,010	48,890	54,251	87,689	117,876	134,335	131,280	175,720	211,942	191,448	184,857	108,478	35,247	39,430	50,357	75,714	147,264	220,662	297,272	357,654	374,292	413,016	461,718	460,031	422,870	0	0	0
Paydowns
49,586	50,830	44,657	44,188	45,628	44,287	44,651	44,076	39,094	38,496	41,353	41,454	35,227	33,169	25,556	20,794	17,831	15,476	16,323	19,051	21,137	23,611	26,279	30,899	39,752	46,098	53,749	53,315	47,129	39,956	29,291	21,067	14,452	9,094	0	0	0
Sales
-	-	-	-	-	-	-	-	-	-	-	-	-	134,188	103,293	87,518	81,966	81,410	78,611	107,565	126,426	78,476	0	0	0	-	-	-	-	-	-	-	-	54,326	0	0	0
Purchases
4,623	5,859	5,739	5,062	4,068	5,409	6,387	6,631	9,267	4,824	4,860	1,648	620	1,098	971	4,271	4,091	3,752	3,065	2,411	1,018	1,912	2,733	3,285	6,560	7,264	0	0	0	-	-	-	-	-	-	-	-
Redemptions
5,643	7,621	8,054	10,410	7,232	3,157	424	-676	1,019	515	1,274	3,750	3,765	2,450	2,416	1,044	4,472	4,476	3,437	5,291	2,569	3,380	3,378	3,814	5,865	7,244	7,393	8,006	5,949	4,090	3,971	1,474	794	1,707	0	0	0
Purchases of bank-owned life insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,000	0	0	0	-	-	-	-
Decrease in prepaid FDIC insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Surrender of policy
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Net increase in loans/leases originated and held for investment
270,187	320,368	321,245	318,098	268,096	292,697	314,072	379,853	436,367	375,226	312,782	208,889	140,386	187,496	188,034	211,943	223,442	172,786	194,092	174,859	172,948	180,325	105,153	94,883	81,252	55,311	111,087	126,906	86,166	91,275	53,988	41,037	69,884	56,096	0	0	0
Purchase of premises and equipment
9,257	12,429	13,100	14,823	14,723	11,457	8,827	6,004	5,068	5,761	6,206	5,501	5,871	6,032	3,937	3,419	2,754	4,394	4,775	4,766	4,670	2,035	2,420	2,676	2,217	2,430	1,880	1,924	2,107	1,871	2,960	3,263	3,276	3,064	0	0	0
Proceeds from sales of premises and equipment
2,453	2,562	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) investing activities
-329,908	-308,664	-359,115	-392,919	-385,824	-333,648	-349,068	-395,910	-367,993	-410,517	-307,975	-254,243	-257,041	-168,975	-151,890	-118,306	-121,109	-66,073	-135,143	-97,126	-70,145	-129,927	-60,199	-95,241	-98,865	-164,557	-200,869	-173,139	-172,743	-132,781	-142,296	-157,327	-121,783	-137,311	0	0	0
CASH FLOWS FROM FINANCING ACTIVITIES
Net increase in deposit accounts
377,633	335,580	465,917	585,228	475,146	271,266	242,281	215,692	261,754	385,082	299,582	410,511	330,191	302,390	253,249	136,806	255,288	200,988	141,459	159,406	62,383	32,695	63,105	51,694	87,459	108,923	143,589	146,264	123,744	168,656	135,766	101,156	101,891	90,641	0	0	0
Net increase (decrease) in short-term borrowings
28,339	-14,193	6,754	463	-2,117	13,638	-17,326	-13,734	-15,711	-39,080	-44,004	-33,344	-44,552	-104,691	-107,548	-117,013	-119,312	-123,688	5,377	-35,747	17,766	119,058	-7,072	47,135	-6,284	-21,789	28,370	-28,212	21,952	-42,453	-2,697	63,004	15,028	72,381	0	0	0
Activity in Federal Home Loan Bank advances:
Term advances
65,000	25,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	5,000	0	0	0	-	-	-	-	77,000	162,000	118,000	55,000	13,000	0	0	0	-	-	-	-
Calls and maturities
-	35,000	0	0	0	-	-	-	-	8,000	11,000	21,000	21,000	24,000	21,000	13,000	28,000	26,000	28,000	29,500	12,500	27,850	-54,150	-9,050	59,350	82,000	162,000	120,800	62,400	24,400	22,400	20,000	42,500	24,000	0	0	0
Net change in short-term and overnight advances
31,400	52,465	111,530	178,200	129,945	-24,765	-145,275	-158,000	-58,295	-60,900	-57,755	-60,400	-63,950	-20,500	24,300	90,400	70,500	47,000	31,000	3,600	-37,700	-6,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Prepayments
-	-	-	-	-	-	-	-	-	-	-	-	-	31,008	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,832	0	0	0
Activity in other borrowings:
Calls, maturities and scheduled principal payments
-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net (decrease) increase in other borrowings
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-8,496	-14,939	0	0	0
Calls, maturities and scheduled principal payments
-	-	-	-	-	-	-	-	14,938	-	0	0	8,000	-	0	0	6,175	7,350	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Prepayments
-	46,313	0	0	0	-	-	-	-	-	-	-	-	69,769	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Paydown of revolving line of credit
-	9,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from subordinated notes
-	63,393	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Retirement of junior subordinated debentures
-	-	-	-	-	-	-	-	-	-	-	-	-	3,955	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment of cash dividends on common stock
3,775	3,767	3,760	3,655	3,546	3,300	3,019	2,840	2,664	2,494	2,357	2,221	2,035	1,981	1,460	1,405	934	782	782	631	1,339	1,964	3,173	3,898	4,001	4,062	3,664	3,624	3,877	4,088	3,715	3,976	6,025	3,712	0	0	0
Proceeds from issuance of common stock, net
2,030	1,926	1,452	1,155	1,386	1,279	0	0	0	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	0	0
Repurchase and cancellation of shares
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by financing activities
348,724	222,901	314,891	347,539	335,535	279,178	322,777	343,655	342,731	381,956	258,330	234,296	219,342	154,420	0	0	0	-	-	-	-	100,611	0	0	0	-	-	0	0	-	-	-	-	111,777	0	0	0
Net increase (decrease) in cash and due from banks
93,300	-9,269	29,295	18,850	14,681	9,801	17,132	-8,092	5,520	5,152	-4,938	27,580	11,395	28,827	0	0	0	-	-	-	-	-3,715	0	0	0	-	-	0	0	-	-	-	-	11,105	0	0	0
Supplemental disclosure of cash flow information, cash payments (receipts) for:
Interest
56,680	59,292	61,506	55,824	49,273	38,782	29,015	23,481	18,961	19,054	15,984	13,949	12,728	11,926	12,228	11,976	12,868	14,027	15,262	16,354	16,789	16,826	16,852	17,432	17,620	17,953	18,283	18,516	19,294	19,962	20,898	21,713	22,745	24,194	0	0	0
Income/franchise taxes
-4,263	-2,719	301	-2,072	-695	-30	-25,021	-19,480	-12,969	-13,040	12,153	13,340	8,299	10,758	10,121	5,548	3,465	2,619	3,068	3,423	4,794	4,541	5,097	5,037	3,658	3,011	1,800	1,495	1,471	1,345	965	964	1,469	1,246	0	0	0
Supplemental schedule of noncash investing activities:
Change in accumulated other comprehensive income, unrealized gains on securities available for sale and derivative instruments, net
1,589	-4,446	-7,072	-5,916	-2,340	3,206	5,443	4,556	2,520	-1,092	2,293	2,929	2,450	335	-1,057	-3,675	-4,557	188	-22,701	-21,257	-14,718	-11,708	0	0	0	-	-	-	632	-48	1,949	2,710	3,878	4,050	0	0	0
Exchange of shares of common stock in connection with payroll taxes for restricted stock and in connection with stock options exercised
256	218	404	843	851	877	1,357	886	897	1,010	406	435	407	568	477	451	462	68	68	68	57	177	1,037	1,037	1,037	434	-403	-403	-411	10	0	0	0	-	-	-	-
Tax benefit of nonqualified stock options exercised
-	-	-	-	-	-	-	-	-	-	-	-	-	-394	-205	-171	-131	-93	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfers of loans to other real estate owned
-	1,086	1,946	1,909	1,055	943	8,782	8,927	8,932	9,023	286	141	171	51	685	790	755	1,577	4,299	4,293	6,371	5,594	4,132	9,066	6,988	7,115	5,220	187	2,145	2,143	3,369	6,943	7,933	9,446	0	0	0
Due to broker for purchases of securities
-	-	-	-	-	-	-	-	-	-	-	-	-	2,655	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Increase (decrease) in the fair value of back-to-back interest rate swap assets and liabilities
-159,146	-62,483	-100,999	-59,651	-30,846	-17,798	646	-4,043	-2,589	-2,059	6,783	-5,907	5,018	706	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends payable
947	947	945	833	1,778	939	972	-800	139	693	659	658	708	522	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of equity securities from securities available for sale to other assets at fair value
-	-	-	-	-	2,614	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-