QCR HOLDINGS INC QCRH Cash Flow

Qcr holdings inc (QCRH)

CashFlow / Quarterly

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
11,228	15,891	15,095	13,504	12,918	13,316	8,809	10,445	10,550	9,902	7,853	8,766	9,184	8,529	6,107	6,676	6,373	6,784	6,488	-523	4,177	2,992	4,062	4,007	3,889	3,815	3,811	4,045	3,265	3,245	3,184	3,273	3,402	2,858	2,266	2,773	2,231
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation
1,338	1,336	1,371	1,283	1,235	1,194	1,182	1,054	1,021	1,138	963	951	896	1,001	870	786	766	781	763	775	745	719	702	697	692	699	715	695	584	609	541	607	591	576	581	690	595
Provision for loan/lease losses
8,367	979	2,012	1,941	2,134	1,612	6,205	2,301	2,540	2,255	2,086	2,022	2,105	2,599	1,607	1,197	2,072	1,176	1,635	2,348	1,710	3,647	1,063	1,001	1,094	1,985	1,366	1,520	1,057	1,045	1,496	1,048	780	1,419	2,456	1,672	1,067
Amortization of offering costs on subordinated debentures
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3	3	3
Stock-based compensation expense
641	600	428	719	722	337	319	292	495	329	300	168	388	186	190	187	382	182	203	186	367	188	176	179	347	172	163	162	293	177	169	177	326	149	149	151	246
Deferred compensation expense accrued
913	686	764	590	733	371	449	492	512	327	374	1,129	-404	2,081	-286	-305	-318	-256	0	-329	-437	-314	-311	-337	-347	-198	-203	-624	204	-	-	-	-	-	-	-	-
Losses on other real estate owned, net
-4	-156	-1,991	-990	-224	-2,536	69	0	-118	-3	158	-3	0	-113	27	-165	7	-182	1,134	98	-28	-333	30	-126	-18	21	-36	-83	-446	-8	-745	-389	-189	-284	42	-107	-25
Amortization of premiums on securities, net
-159	-222	-485	-406	-448	-413	-372	-390	-439	-508	-325	-657	-347	-334	-356	-317	-294	-283	-271	-270	-214	-339	-467	-466	-535	-711	-890	-998	-974	-995	-900	-1,066	-983	-945	-836	-2,593	888
Caplet amortization
110	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Securities losses, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-35	4,251	18	358	325	56	-4	421	51	19	0	20	-	-	-	-	-	-	-	-	0	2,501	-1,909	880
Loans originated for sale
34,459	46,868	58,898	27,892	18,034	17,775	18,024	8,960	12,939	9,155	8,292	10,714	21,416	17,169	13,634	24,624	18,901	8,779	14,762	8,558	6,647	25,484	10,428	15,860	6,354	9,458	18,297	25,343	26,928	29,866	38,682	27,810	24,070	35,548	22,079	22,920	20,240
Proceeds on sales of loans
34,790	54,717	53,947	26,234	17,735	19,399	16,882	8,308	13,764	8,936	8,898	11,259	22,547	18,011	14,677	25,519	19,640	9,208	16,621	7,963	6,569	27,897	10,367	15,491	7,678	9,859	19,457	26,533	30,382	32,066	37,431	27,673	24,972	37,645	19,451	22,692	33,816
Gains on sales of residential real estate loans
652	823	890	489	369	362	336	102	101	101	98	112	96	142	144	84	60	56	84	95	86	143	120	132	63	113	184	246	291	401	424	271	291	-924	408	755	759
Gains on sales of government guaranteed portions of loans
-	159	519	39	31	0	47	0	358	34	91	87	950	457	218	1,603	878	404	759	69	70	1,179	158	508	194	199	338	765	845	90	260	610	107	-	-	-	-
Losses on debt extinguishment
-147	-	-	-	-	-	-	-	-	-	-	-	-	-357	-4,303	0	83	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gains on sales of premises and equipment
8	-820	0	20	47	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Intangibles amortization
549	560	559	615	532	541	542	304	305	308	230	230	230	232	110	49	49	49	49	49	49	49	49	49	49	-	-	-	-	-	-	-	-	-	-	-	-
Accretion of acquisition fair value adjustments, net
625	931	1,268	1,076	1,069	2,576	1,707	545	699	877	485	1,663	1,915	3,027	629	16	44	32	602	-89	-178	1,224	-244	-143	-161	-	-	-	-	-	-	-	-	-	-	-	-
Prepayment fees on Federal Home Loan Bank advances
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	832
Increase in accrued interest receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	19	99
Increase in cash value of bank-owned life insurance
329	532	489	412	540	340	475	399	418	444	428	459	469	447	450	480	393	443	407	433	478	444	434	388	454	457	466	423	438	412	399	358	438	-	-	-	-
Goodwill impairment
500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Decrease in other assets
-5,917	17,199	2,895	179	-1,121	2,844	3,161	694	4,438	940	1,745	2,015	-5,427	-1,536	-1,850	-4,965	9,295	-1,301	444	5,254	-486	851	-1,275	5,426	-3,804	-330	-763	-5,968	-587	1,948	-9,252	6,716	-565	2,295	2,303	-1,896	-1,114
Decrease in other liabilities
-21,998	23,579	4,951	4,495	-9,110	5,285	-3,434	8,576	-2,888	364	-1,551	-1,206	-5,852	8,655	228	-3,693	5,079	-1,548	5,992	117	-1,840	-298	4,504	4,257	-8,049	-1,536	3,770	839	-2,056	1,319	2,207	596	-1,330	963	1,492	1,465	-2,002
Net cash provided by operating activities
6,592	30,374	16,796	20,722	8,602	27,399	7,507	21,462	7,903	6,550	8,246	8,081	10,833	17,544	11,067	9,649	5,122	6,904	14,310	3,818	5,064	6,738	11,545	4,154	3,161	1,363	11,012	12,423	7,236	9,897	16,162	-977	5,572	10,210	1,748	7,565	17,115
CASH FLOWS FROM INVESTING ACTIVITIES
Net decrease in federal funds sold
5,105	-500	915	-8,343	24,526	6,672	-22,204	3,639	15,692	-9,629	-1,385	-3,385	6,459	-1,235	501	-5,085	4,110	14,480	-11,775	-8,520	32,745	-17,020	-9,270	-8,920	27,865	8,757	-31,526	-4,331	26,560	-20,835	-2,100	-3,625	20,785	-14,995	2,210	61,260	-7,300
Net increase in interest-bearing deposits at financial institutions
-54,122	-12,804	4,904	18,878	-80,962	-36,607	7,135	4,250	10,714	-10,589	11,949	104,249	-93,471	11,076	-12,687	-6,118	-5,175	-4,038	15,407	-30,563	18,215	-702	2,154	7,603	-11,344	-17,182	18,710	1,232	-11,422	27,077	-20,984	-2,964	1,262	-2,085	2,627	1,081	11,370
Proceeds from sales of other real estate owned
827	0	301	337	202	1,251	552	0	736	308	341	453	34	170	1,048	370	494	921	5,050	1,392	331	421	400	674	97	682	358	287	15	1,039	3,387	604	209	843	5,758	767	1,850
Activity in securities portfolio:
Purchases
83,987	43,844	17,410	6,630	4,079	17,625	11,469	47,851	7,100	76,276	18,339	73,031	12,138	67,976	14,490	52,061	45,070	31,843	18,977	56,704	124,568	27,762	12,403	9,947	26,142	15,937	58,498	50,884	187,650	110,959	52,132	152,291	159,077	164,164	158,962	130,873	168,245
Calls, maturities and redemptions
3,872	16,119	3,116	1,448	4,510	1,016	10,296	8,079	4,540	2,574	7,356	15,693	17,385	8,454	12,717	49,131	47,573	24,913	9,662	93,571	83,794	4,419	3,071	17,192	10,563	8,603	13,997	42,549	82,114	82,000	90,608	102,931	98,751	120,724	139,310	101,244	61,590
Paydowns
9,182	14,181	9,561	16,662	10,426	8,008	9,092	18,102	9,085	8,372	8,517	13,119	8,486	11,229	8,618	6,893	6,428	3,616	3,856	3,929	4,073	4,464	6,583	6,015	6,547	7,131	11,204	14,869	12,893	14,782	10,770	8,683	5,720	4,116	2,546	2,068	361
Sales
-	-	-	-	-	-	-	-	-	-	-	-	-	46,415	26,697	5,548	55,526	15,520	10,922	-4	54,971	12,721	39,876	18,856	7,020	-	-	-	-	-	-	-	-	0	8,601	8,331	37,394
Purchases
1,874	177	1,814	758	3,110	57	1,137	-236	4,451	1,035	1,380	2,400	7	1,072	-1,831	1,371	485	945	1,468	1,192	146	258	813	-200	1,040	1,080	1,365	3,075	1,743	-	-	-	-	-	-	-	-
Redemptions
3,917	2,615	-2,356	1,467	5,895	3,048	0	-1,711	1,820	315	-1,100	-14	1,315	1,074	1,375	0	0	1,040	3	3,427	3	2	1,857	705	814	0	2,293	2,756	2,193	150	2,906	699	334	32	408	19	1,247
Purchases of bank-owned life insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,466	2,462	814	189	-	-	-	-
Decrease in prepaid FDIC insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	621
Surrender of policy
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-344
Net increase in loans/leases originated and held for investment
15,596	83,082	60,892	110,617	65,777	83,959	57,745	60,615	90,378	105,334	123,526	117,128	29,236	42,890	19,633	48,626	76,346	43,429	43,542	60,125	25,689	64,735	24,309	58,213	33,066	-10,435	14,039	44,582	7,125	45,340	29,857	3,843	12,234	8,053	16,906	32,690	-1,553
Purchase of premises and equipment
798	3,674	2,723	2,062	3,970	4,345	4,446	1,962	704	1,715	1,622	1,025	1,396	2,161	917	1,395	1,558	66	399	730	3,197	448	390	633	563	832	646	175	775	282	690	358	539	1,371	993	371	328
Proceeds from sales of premises and equipment
8	2,416	0	29	117	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) investing activities
-133,466	-73,583	-37,931	-84,928	-112,222	-124,034	-71,735	-77,833	-60,046	-139,454	-118,577	-49,916	-102,569	-36,913	-64,844	-52,714	-14,502	-19,829	-31,259	-55,518	40,533	-88,898	6,756	-28,537	-19,248	-19,171	-28,284	-32,160	-84,940	-55,484	-555	-31,763	-44,978	-64,999	-15,586	3,780	-60,506
CASH FLOWS FROM FINANCING ACTIVITIES
Net increase in deposit accounts
259,310	58,620	-68,654	128,357	217,257	188,957	50,657	18,275	13,377	159,972	24,068	64,336	136,704	74,472	134,997	-15,982	108,903	25,331	18,553	102,499	54,603	-34,197	36,501	5,476	24,915	-3,787	25,090	41,241	46,379	30,878	27,764	18,721	91,291	-2,011	-6,845	19,456	80,042
Net increase (decrease) in short-term borrowings
29,644	-5,102	492	3,305	-12,888	15,845	-5,799	725	2,867	-15,119	-2,206	-1,252	-20,501	-20,044	8,453	-12,461	-80,639	-22,901	-1,010	-14,760	-85,015	106,164	-42,135	38,752	16,276	-19,966	12,073	-14,667	770	30,194	-44,510	35,498	-63,635	69,949	21,191	-12,477	-6,282
Activity in Federal Home Loan Bank advances:
Term advances
45,000	0	20,000	0	5,000	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	5,000	-	-	-	-	-86,000	44,000	73,000	46,000	-1,000	0	10,000	4,000	-	-	-	-
Calls and maturities
-	0	0	20,000	15,000	-	-	-	-	2,000	0	2,000	4,000	5,000	10,000	2,000	7,000	2,000	2,000	17,000	5,000	4,000	3,500	0	20,350	-78,000	48,599	68,400	43,000	2,000	7,400	10,000	5,000	0	5,000	32,500	-13,500
Net change in short-term and overnight advances
109,300	36,500	-114,900	500	130,365	95,565	-48,230	-47,755	-24,345	-24,945	-60,955	51,950	-26,950	-21,800	-63,600	48,400	16,500	23,000	2,500	28,500	-7,000	7,000	-24,900	-12,800	24,700	-	-	-	-	-	-	-	-	-	-	-	-
Prepayments
-	-	-	-	-	-	-	-	-	-	-	-	-	20,484	0	0	10,524	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	31,664	-15,832
Activity in other borrowings:
Calls, maturities and scheduled principal payments
-	-	-	-	1,937	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net (decrease) increase in other borrowings
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2	-4,998	-786	-2,713	-6,440
Calls, maturities and scheduled principal payments
-	-	-	-	-	-	-	-	1,938	-	1,500	0	8,000	-	0	0	0	0	0	6,175	1,175	-	-	-	200	-	-	-	-	-	-	-	-	-	-	-	-
Prepayments
-	0	0	25,000	21,313	-	-	-	-	-	-	-	-	19,448	39,561	0	10,759	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Paydown of revolving line of credit
-	0	0	0	9,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from subordinated notes
-	0	0	0	63,393	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Retirement of junior subordinated debentures
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	3,955	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment of cash dividends on common stock
947	945	941	942	939	938	836	833	693	657	657	656	522	521	520	470	468	0	466	-0	315	0	315	708	941	1,209	1,039	810	1,002	810	999	1,063	1,214	437	1,260	3,113	-1,098
Proceeds from issuance of common stock, net
520	783	349	378	416	309	52	609	309	-	-	-	-	-	-	401	512	-	-	-	-	-	-	-	179	-	-	-	-	-	-	-	-	-	-	145	212
Repurchase and cancellation of shares
3,780	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by financing activities
220,447	16,761	35,918	75,598	94,624	108,751	68,566	63,594	38,267	152,350	89,443	62,669	77,491	28,725	65,409	47,715	12,569	-	-	-	-	78,069	-32,268	25,230	29,580	-	-	30,800	49,389	-	-	-	-	62,493	14,188	-2,004	37,099
Net increase (decrease) in cash and due from banks
93,573	-26,448	14,783	11,392	-8,996	12,116	4,338	7,223	-13,876	19,447	-20,886	20,835	-14,244	9,356	11,631	4,650	3,188	-	-	-	-	-4,091	-13,966	848	13,493	-	-	11,062	-28,314	-	-	-	-	7,704	351	9,341	-6,291
Supplemental disclosure of cash flow information, cash payments (receipts) for:
Interest
11,534	13,466	16,480	15,200	14,146	15,680	10,798	8,649	3,655	5,913	5,263	4,129	3,747	2,844	3,229	2,907	2,944	3,146	2,976	3,800	4,103	4,381	4,068	4,236	4,140	4,407	4,648	4,424	4,472	4,737	4,881	5,201	5,141	5,672	5,697	6,233	6,590
Income/franchise taxes
-2,134	-1,950	263	-442	-590	1,070	-2,110	935	75	-23,921	3,430	7,445	4	1,271	4,617	2,405	2,464	634	45	322	1,618	1,083	400	1,692	1,365	1,640	340	313	717	429	35	290	591	49	34	794	368
Supplemental schedule of noncash investing activities:
Change in accumulated other comprehensive income, unrealized gains on securities available for sale and derivative instruments, net
3,691	684	-544	-2,242	-2,344	-1,942	612	1,334	3,202	295	-274	-701	-410	3,680	361	-1,180	-2,525	2,287	-2,256	-2,062	2,220	-20,603	-812	4,476	5,230	-	-	-	-836	-1,415	1,643	1,241	-1,517	582	2,404	2,409	-1,345
Exchange of shares of common stock in connection with payroll taxes for restricted stock and in connection with stock options exercised
190	29	29	8	152	215	468	16	178	695	-3	27	290	91	25	0	451	0	0	11	57	0	0	0	177	859	0	0	-424	20	0	-7	-2	-	-	-	-
Tax benefit of nonqualified stock options exercised
-	-	-	-	-	-	-	-	-	-	-	-	-	-211	-72	-87	-22	-21	-39	-47	15	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfers of loans to other real estate owned
-	37	37	854	158	897	0	0	46	8,736	144	5	136	0	0	35	16	634	105	0	837	3,356	98	2,078	60	1,894	5,032	0	187	0	0	1,958	185	1,226	3,573	2,948	1,698
Due to broker for purchases of securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-12,534	16,690	18,604	-20,104	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Increase (decrease) in the fair value of back-to-back interest rate swap assets and liabilities
-110,545	18,277	-37,132	-29,746	-13,882	-20,239	4,216	-941	-834	-1,794	-473	512	-303	7,047	-13,165	11,439	-4,615	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends payable
942	3	1,886	-1,884	942	1	1,774	-939	103	34	1	0	656	1	0	49	470	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of equity securities from securities available for sale to other assets at fair value
-	-	-	-	-	0	0	0	2,614	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-