HORIZON BANCORP, INC. HBNC Cash Flow

Horizon bancorp, inc. (HBNC)

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
Operating Activities
Net income
11,655	18,543	20,537	16,642	10,816	13,133	13,065	14,115	12,804	7,650	8,171	9,072	8,224	5,603	6,602	6,326	5,381	6,175	4,288	4,728	5,358	4,948	4,958	4,778	3,417	4,115	4,785	5,665	5,311	5,170	4,850	4,910	4,613	3,522	3,417	3,093	2,765
Items not requiring (providing) cash
Provision for credit losses
8,600	340	376	896	364	528	1,176	635	567	1,100	710	330	330	623	455	232	532	342	300	1,906	614	-	-	-	-	-997	104	729	2,084	1,715	1,041	209	559	838	1,564	1,332	1,548
Depreciation and amortization
2,610	2,624	2,684	2,831	1,549	1,768	1,745	1,486	1,814	1,633	1,483	1,419	1,401	1,485	1,327	1,280	1,183	1,132	1,137	927	956	973	1,001	961	844	834	836	837	849	887	690	652	646	652	641	623	604
Share based compensation
50	50	50	58	57	44	44	81	82	87	80	82	76	77	77	102	68	72	78	79	59	58	58	60	27	17	15	8	8	8	8	9	8	8	7	10	10
Mortgage servicing rights, net impairment
322	133	70	3	-14	-86	2	18	6	5	52	17	6	-730	0	839	1	-330	33	-58	414	-23	10	-33	-5	-427	-73	-102	-33	-201	433	-71	7	517	264	-27	-701
Premium amortization on securities, net
-1,997	-1,810	-1,530	-1,304	-1,285	-1,362	-1,451	-1,509	-1,476	-1,548	-1,531	-1,468	-1,477	-1,773	-1,716	-3,860	1,187	-5,612	903	813	476	566	601	583	549	640	681	732	808	957	977	710	700	699	586	504	522
Gain on sale of investment securities
339	10	0	-100	15	-332	-122	0	11	0	6	-3	35	961	0	767	108	65	0	0	124	-	-	-	-	0	6	0	368	-	-	-	-	23	1,115	365	274
Gain on sale of mortgage loans
3,473	3,119	2,702	2,078	1,309	1,455	1,839	1,896	1,423	1,988	1,950	2,054	1,914	2,504	3,528	3,529	2,114	2,240	2,794	2,642	2,379	2,294	2,153	2,537	1,411	1,214	1,667	2,807	3,106	4,002	4,436	3,411	2,274	2,463	2,145	1,308	533
Proceeds from sales of loans
68,892	83,646	99,849	61,513	30,801	40,139	62,135	51,911	43,307	57,139	60,889	55,231	58,151	81,942	102,238	82,175	62,022	63,188	91,766	84,535	71,211	64,918	75,867	58,643	35,348	59,149	103,558	100,185	102,762	107,159	109,592	101,698	82,619	104,067	68,337	45,138	64,764
Loans originated for sale
67,576	83,555	95,022	60,641	30,433	42,735	59,276	51,042	35,770	54,629	56,409	57,534	49,939	80,156	98,267	83,290	55,162	63,282	86,878	83,341	68,918	64,600	70,595	58,057	35,991	56,622	91,775	102,983	95,017	103,157	105,156	98,287	80,345	101,604	66,192	43,830	64,231
Change in cash value life insurance
554	566	556	555	513	532	503	442	435	451	474	408	464	-	-	-	345	356	353	257	258	262	260	252	233	245	244	257	252	263	268	234	225	231	-652	211	205
Gain on sale of other real estate owned
8	11	104	37	-26	-	-	-	-	16	71	178	-261	-143	0	-218	100	75	8	-57	263	10	3	-45	218	-154	-7	39	238	-134	31	-5	-21	-80	-40	-116	30
Net change in:
Interest receivable
-1,054	546	-733	1,592	696	3,425	1,006	949	-4,200	780	1,227	735	-151	-143	332	414	-59	-327	760	392	185	-165	131	397	35	-5	-243	200	-167	-532	743	-113	127	20	-127	145	114
Interest payable
-290	337	-280	534	-386	343	247	225	330	-28	99	36	45	-550	-124	326	73	17	8	-43	7	0	0	-42	-8	18	-443	379	-8	-19	-422	356	-41	14	-123	-81	5
Other assets
-5,721	-2,172	585	1,746	-97,788	-7,318	617	10,836	-6,595	-3,958	1,499	2,070	-5,784	-17,130	11,017	3,894	1,730	-8,630	4,160	1,404	-5,503	7,196	-1,549	-27	-675	-1,412	-1,392	-3,755	-3,346	-813	-681	1,879	-1,415	-1,876	3,567	-576	-1,401
Other liabilities
-484	-12,021	3,633	5,534	2,246	-8,891	2,338	10,767	-3,556	-3,441	-541	2,733	-4,527	-9,396	699	1,848	-1,532	-1,492	2,531	-224	-1,287	385	1,517	-52	-1,138	172	1,309	-307	-676	-960	-2,372	439	-179	-445	2,228	347	-1,159
Net cash provided by operating activities
28,177	9,827	30,426	23,133	111,566	7,801	18,972	15,681	29,986	11,787	10,838	7,412	19,027	14,149	-604	2,588	9,415	13,271	6,091	4,684	11,184	-1,394	13,172	4,066	1,821	7,011	18,722	5,595	15,637	8,888	4,842	5,219	7,397	7,547	4,721	5,772	4,372
Investing Activities
Purchases of securities available for sale
129,405	124,453	124,797	113,055	63,574	84,499	45,298	48,520	36,389	21,624	30,270	47,281	50,201	73,272	102,140	16,427	33,716	73,804	122,433	17,552	30,406	16,211	24,680	25,194	27,290	16,611	54,292	46,402	51,581	17,232	42,095	32,037	22,581	22,805	61,700	32,560	76,429
Proceeds from sales, maturities, calls and principal repayments of securities available for sale
71,395	48,355	34,429	122,923	42,715	44,189	23,465	25,308	30,415	18,171	23,193	20,921	23,302	181,257	22,807	38,860	26,663	59,939	21,426	15,099	25,260	17,728	63,977	15,501	20,327	17,416	20,973	31,026	51,894	32,337	42,016	30,424	20,294	20,760	85,534	23,691	25,358
Purchases of securities held to maturity
-	-	-	-	-	0	14,167	5,504	8,703	11,642	204	6,797	13,151	10,234	17,638	9,283	8,677	-	-	-	-	-	-	-	-	2,140	0	7,800	2,110	-	-	-	-	7,000	0	0	2,437
Proceeds from maturities of securities held to maturity
6,708	1,394	2,439	1,624	2,927	2,192	592	4,796	721	8,493	30	3,838	1,015	16,189	1,720	2,615	10,319	0	5,620	800	735	-	-	-	-	-	-	-	-	-	-	-	-	11,437	0	0	1,400
Net change in interest-earning time deposits
-784	0	-365	7,897	-243	1,247	-243	2	-289	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in FHLB stock
0	0	0	0	803	-	-	-	-	0	0	-9,145	158	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net change in loans
68,685	-28,485	172,311	-121,434	37,028	44,773	240,380	-69,204	-33,312	405,859	-25,767	-119,587	-8,684	59,019	61,330	-117,604	29,354	-33,014	18,805	-60,616	-81,515	-36,161	-24,253	-98,165	-32,259	10,344	34,175	-31,468	99,089	-35,984	-55,165	-9,329	-2,102	-60,912	-95,728	-33,201	84,163
Proceeds on the sale of OREO and repossessed assets
155	1,809	1,675	773	487	-40	2,504	402	392	2,113	1,068	547	510	1,048	271	590	663	589	632	379	1,414	348	283	1,311	784	205	85	894	1,159	2,011	-330	530	2,461	416	939	-400	1,469
Change in premises and equipment, net
-2,030	852	2,222	-1,722	3,260	142	1,422	796	1,074	22	1,615	27	1,025	-336	1,036	446	237	865	1,170	1,419	2,168	2,169	760	1,932	1,394	3,285	677	1,515	841	2,464	2,196	702	1,622	894	1,535	-977	990
Death benefit on bank owned life insurance
-233	0	-213	-367	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchase of outstanding stock
19,636	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of Mortgage Company
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-1	1	735	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) investing activities
-142,049	-45,262	-93,935	-32,014	76,486	-81,826	-80,335	-93,516	-48,239	-89,151	-13,140	-139,241	-37,392	189,804	81,623	-73,489	24,369	-53,632	79,165	-63,041	-86,680	-24,930	13,951	-97,500	-40,567	8,039	264	-56,116	97,610	-18,409	-28,310	-10,114	-3,550	-58,998	-75,490	-40,219	32,534
Financing Activities
Net change in:
Deposits
-48,731	15,045	-14,812	42,869	7,180	10,822	112,391	82,487	52,673	15,500	38,394	-24,916	-42,338	84,085	-116,117	80,296	-1,674	-32,922	-22,735	119,628	-17,224	32,656	-49,440	22,513	64,051	-36,800	31,064	-17,807	20,910	-12,819	49,937	-18,832	54,756	20,116	-30,527	18,867	15,911
Borrowings
-154,935	-33,211	-80,297	21,487	163,061	-72,711	47,081	-4,592	43,811	-69,081	27,107	-165,357	-52,564	302,840	-11,536	-54,111	18,801	-75,485	60,179	55,140	-89,255	-1,124	-9,951	-87,207	20,214	-13,829	40,293	-73,977	136,826	-12,663	7,893	-29,014	59,199	-34,039	-105,977	-5,806	36,360
Redemption of preferred stock
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	12,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of stock
552	153	56	1,504	-8	129	49	344	100	988	582	0	34	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-52	60	-1	56
Tax benefit from issuance of stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	8
Dividends paid on common stock
5,257	5,422	5,439	5,450	4,524	3,851	3,847	3,872	3,848	3,476	2,898	2,899	2,447	2,456	2,227	1,894	1,805	1,803	1,802	1,307	1,304	1,304	1,209	1,270	961	957	960	871	867	879	870	652	646	597	600	568	560
Dividends paid on preferred stock
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	42	31	31	32	31	31	39	32	31	62	66	96	146	156	62	107	156	62	261	234	235
Net cash provided by (used in) financing activities
101,499	42,987	60,102	17,436	-160,413	79,811	61,512	83,551	5,114	82,093	8,971	137,542	7,813	-220,925	-106,522	132,513	-34,822	40,856	-80,958	63,538	70,696	32,482	-40,609	108,418	42,845	-23,829	-10,221	55,203	-116,929	-1,306	41,287	9,589	-5,245	53,436	68,399	23,870	-21,180
Net Change in Cash and Cash Equivalents
-12,373	7,552	-3,407	8,555	27,639	5,786	149	5,716	-13,139	-	-	-	-10,552	-16,972	-25,503	61,612	-1,038	495	4,298	5,181	-4,800	6,158	-13,486	14,984	4,099	-8,779	8,765	4,682	-3,682	-10,827	17,819	4,694	-1,398	1,985	-2,370	-10,577	15,726
Additional Supplemental Information
Interest paid
11,019	11,542	12,528	11,787	10,653	9,551	8,252	6,966	5,685	5,133	4,050	3,571	3,215	8,993	4,498	3,400	3,681	3,552	3,773	3,320	3,199	3,221	3,482	3,324	3,203	3,291	3,815	3,023	3,427	3,476	4,053	3,160	3,669	3,854	4,143	4,331	4,358
Income taxes paid
0	11,900	19	1,300	0	-	-	-	-	0	4,000	5,300	1,050	-394	2,560	3,500	1,250	-	-	-	-	1,200	1,000	600	0	0	0	2,700	400	4,200	0	3,025	900	-	-	-	-
Transfer of loans to other real estate and repossessed assets
609	670	817	454	759	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of premises to other real estate
-	-	-	-	-	-	-	-	266	-	301	702	714	644	1,064	592	1,379	2,742	4,209	-612	-772	827	1,079	1,389	610	756	1,147	711	670	2,413	2,262	697	527	514	556	2,622	1,095
Right-of-use assets exchanged for lease obligations
0	0	0	0	3,411	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Salin
Net cash received in acquisition, Salin
0	0	0	0	-128,745	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-