HORIZON BANCORP, INC. HBNC Cash Flow

Horizon bancorp, inc. (HBNC)

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
Operating Activities
Net income
67,377	66,538	61,128	53,656	51,129	53,117	47,634	42,740	37,697	33,117	31,070	29,501	26,755	23,912	24,484	22,170	20,572	20,549	19,322	19,992	20,042	18,101	17,268	17,095	17,982	19,876	20,931	20,996	20,241	19,543	17,895	16,462	14,645	12,797	0	0	0
Items not requiring (providing) cash
Provision for credit losses
10,212	1,976	2,164	2,964	2,703	2,906	3,478	3,012	2,707	2,470	1,993	1,738	1,640	1,842	1,561	1,406	3,080	3,162	0	0	0	-	-	-	-	1,920	4,632	5,569	5,049	3,524	2,647	3,170	4,293	5,282	0	0	0
Depreciation and amortization
10,749	9,688	8,832	7,893	6,548	6,813	6,678	6,416	6,349	5,936	5,788	5,632	5,493	5,275	4,922	4,732	4,379	4,152	3,993	3,857	3,891	3,779	3,640	3,475	3,351	3,356	3,409	3,263	3,078	2,875	2,640	2,591	2,562	2,520	0	0	0
Share based compensation
208	215	209	203	226	251	294	330	331	325	315	312	332	324	319	320	297	288	274	254	235	203	162	119	67	48	39	32	33	33	33	32	33	35	0	0	0
Mortgage servicing rights, net impairment
528	192	-27	-95	-80	-60	31	81	80	80	-655	-707	115	110	510	543	-354	59	366	343	368	-51	-455	-538	-607	-635	-409	97	128	168	886	717	761	53	0	0	0
Premium amortization on securities, net
-6,641	-5,929	-5,481	-5,402	-5,607	-5,798	-5,984	-6,064	-6,023	-6,024	-6,249	-6,434	-8,826	-6,162	-10,001	-7,382	-2,709	-3,420	2,758	2,456	2,226	2,299	2,373	2,453	2,602	2,861	3,178	3,474	3,452	3,344	3,086	2,695	2,489	2,311	0	0	0
Gain on sale of investment securities
249	-75	-417	-539	-439	-443	-111	17	14	38	999	993	1,763	1,836	940	940	173	189	0	0	0	-	-	-	-	374	0	0	0	-	-	-	-	1,777	0	0	0
Gain on sale of mortgage loans
11,372	9,208	7,544	6,681	6,499	6,613	7,146	7,257	7,415	7,906	8,422	10,000	11,475	11,675	11,411	10,677	9,790	10,055	10,109	9,468	9,363	8,395	7,315	6,829	7,099	8,794	11,582	14,351	14,955	14,123	12,584	10,293	8,190	6,449	0	0	0
Proceeds from sales of loans
313,900	275,809	232,302	194,588	184,986	197,492	214,492	213,246	216,566	231,410	256,213	297,562	324,506	328,377	309,623	299,151	301,511	310,700	312,430	296,531	270,639	234,776	229,007	256,698	298,240	365,654	413,664	419,698	421,211	401,068	397,976	356,721	300,161	282,306	0	0	0
Loans originated for sale
306,794	269,651	228,831	193,085	183,486	188,823	200,717	197,850	204,342	218,511	244,038	285,896	311,652	316,875	300,001	288,612	288,663	302,419	303,737	287,454	262,170	229,243	221,265	242,445	287,371	346,397	392,932	406,313	401,617	386,945	385,392	346,428	291,971	275,857	0	0	0
Change in cash value life insurance
2,231	2,190	2,156	2,103	1,990	1,912	1,831	1,802	1,768	1,797	0	0	0	-	-	-	1,311	1,224	1,130	1,037	1,032	1,007	990	974	979	998	1,016	1,040	1,017	990	958	38	15	-5	0	0	0
Gain on sale of other real estate owned
160	126	0	0	0	-	-	-	-	4	-155	-226	-622	-261	-43	-35	126	289	224	219	231	186	22	12	96	116	136	174	130	-129	-75	-146	-257	-206	0	0	0
Net change in:
Interest receivable
351	2,101	4,980	6,719	6,076	1,180	-1,465	-1,244	-1,458	2,591	1,668	773	452	544	360	788	766	1,010	1,172	543	548	398	558	184	-13	-215	-742	244	-69	225	777	-93	165	152	0	0	0
Interest payable
301	205	211	738	429	1,145	774	626	437	152	-370	-593	-303	-275	292	424	55	-11	-28	-36	-35	-50	-32	-475	-54	-54	-91	-70	-93	-126	-93	206	-231	-185	0	0	0
Other assets
-5,562	-97,629	-102,775	-102,743	-93,653	-2,460	900	1,782	-6,984	-6,173	-19,345	-9,827	-8,003	-489	8,011	1,154	-1,336	-8,569	7,257	1,548	117	4,945	-3,663	-3,506	-7,234	-9,905	-9,306	-8,595	-2,961	-1,030	-2,093	2,155	-300	-286	0	0	0
Other liabilities
-3,338	-608	2,522	1,227	6,460	658	6,108	3,229	-4,805	-5,776	-11,731	-10,491	-11,376	-8,381	-477	1,355	-717	-472	1,405	391	563	712	499	291	36	498	-634	-4,315	-3,569	-3,072	-2,557	2,043	1,951	971	0	0	0
Net cash provided by operating activities
91,563	174,952	172,926	161,472	154,020	72,440	76,426	68,292	60,023	49,064	51,426	39,984	35,160	25,548	24,670	31,365	33,461	35,230	20,565	27,646	27,028	17,665	26,070	31,620	33,149	46,965	48,842	34,962	34,586	26,346	25,005	24,884	25,437	22,412	0	0	0
Investing Activities
Purchases of securities available for sale
491,710	425,879	385,925	306,426	241,891	214,706	151,831	136,803	135,564	149,376	201,024	272,894	242,040	225,555	226,087	246,380	247,505	244,195	186,602	88,849	96,491	93,375	93,775	123,387	144,595	168,886	169,507	157,310	142,945	113,945	119,518	139,123	139,646	193,494	0	0	0
Proceeds from sales, maturities, calls and principal repayments of securities available for sale
277,102	248,422	244,256	233,292	135,677	123,377	97,359	97,087	92,700	85,587	248,673	248,287	266,226	269,587	148,269	146,888	123,127	121,724	79,513	122,064	122,466	117,533	117,221	74,217	89,742	121,309	136,230	157,273	156,671	125,071	113,494	157,012	150,279	155,343	0	0	0
Purchases of securities held to maturity
-	-	-	-	-	28,374	40,016	26,053	27,346	31,794	30,386	47,820	50,306	45,832	0	0	0	-	-	-	-	-	-	-	-	12,050	0	0	0	-	-	-	-	9,437	0	0	0
Proceeds from maturities of securities held to maturity
12,165	8,384	9,182	7,335	10,507	8,301	14,602	14,040	13,082	13,376	21,072	22,762	21,539	30,843	14,654	18,554	16,739	7,155	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	12,837	0	0	0
Net change in interest-earning time deposits
6,748	7,289	8,536	8,658	763	717	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in FHLB stock
0	803	0	0	0	-	-	-	-	-8,987	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net change in loans
91,077	59,420	132,678	200,747	252,977	182,637	543,723	277,576	227,193	251,821	-95,019	-7,922	-5,939	32,099	-59,934	-102,459	-45,471	-156,340	-159,487	-202,545	-240,094	-190,838	-144,333	-85,905	-19,208	112,140	65,812	-23,528	-1,389	-102,580	-127,508	-168,071	-191,943	-105,678	0	0	0
Proceeds on the sale of OREO and repossessed assets
4,412	4,744	2,895	3,724	3,353	3,258	5,411	3,975	4,120	4,238	3,173	2,376	2,419	2,572	2,113	2,474	2,263	3,014	2,773	2,424	3,356	2,726	2,583	2,385	1,968	2,343	4,149	3,734	3,370	4,672	3,077	4,346	3,416	2,424	0	0	0
Change in premises and equipment, net
-678	4,612	3,902	3,102	5,620	3,434	3,314	3,507	2,738	2,689	2,331	1,752	2,171	1,383	2,584	2,718	3,691	5,622	6,926	6,516	7,029	6,255	7,371	7,288	6,871	6,318	5,497	7,016	6,203	6,984	5,414	4,753	3,074	2,442	0	0	0
Death benefit on bank owned life insurance
-813	-580	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchase of outstanding stock
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of Mortgage Company
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	735	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) investing activities
-313,260	-94,725	-131,289	-117,689	-179,191	-303,916	-311,241	-244,046	-289,771	-278,924	31	94,794	160,546	222,307	-21,129	-23,587	-13,139	-124,188	-95,486	-160,700	-195,159	-149,046	-116,077	-129,764	-88,380	49,797	23,349	-5,225	40,777	-60,383	-100,972	-148,152	-178,257	-142,173	0	0	0
Financing Activities
Net change in:
Deposits
-5,629	50,282	46,059	173,262	212,880	258,373	263,051	189,054	81,651	-13,360	55,225	-99,286	5,926	46,590	-70,417	22,965	62,297	46,747	112,325	85,620	-11,495	69,780	324	80,828	40,508	-2,633	21,348	40,221	39,196	73,042	105,977	25,513	63,212	24,367	0	0	0
Borrowings
-246,956	71,040	31,540	158,918	132,839	13,589	17,219	-2,755	-163,520	-259,895	112,026	73,383	184,629	255,994	-122,331	-50,616	58,635	-49,421	24,940	-45,190	-187,537	-78,068	-90,773	-40,529	-27,299	89,313	90,479	58,079	103,042	25,415	4,039	-109,831	-86,623	-109,462	0	0	0
Redemption of preferred stock
-	-	-	-	-	-	-	-	-	-	-	-	-	12,500	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of stock
2,265	1,705	1,681	1,674	514	622	1,481	2,014	1,670	1,604	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	63	0	0	0
Tax benefit from issuance of stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Dividends paid on common stock
21,568	20,835	19,264	17,672	16,094	15,418	15,043	14,094	13,121	11,720	10,700	10,029	9,024	8,382	7,729	7,304	6,717	6,216	5,717	5,124	5,087	4,744	4,397	4,148	3,749	3,655	3,577	3,487	3,268	3,047	2,765	2,495	2,411	2,325	0	0	0
Dividends paid on preferred stock
-	-	-	-	-	-	-	-	-	-	-	-	-	42	73	104	136	125	125	133	133	133	164	191	255	370	464	460	471	481	387	586	713	792	0	0	0
Net cash provided by (used in) financing activities
222,024	-39,888	-3,064	-1,654	64,461	229,988	232,270	179,729	233,720	236,419	-66,599	-182,092	-187,121	-229,756	32,025	57,589	-11,386	94,132	85,758	126,107	170,987	143,136	86,825	117,213	63,998	-95,776	-73,253	-21,745	-67,359	44,325	99,067	126,179	140,460	124,525	0	0	0
Net Change in Cash and Cash Equivalents
327	40,339	38,573	42,129	39,290	-1,488	0	0	0	-	-	-	8,585	18,099	35,566	65,367	8,936	5,174	10,837	-6,947	2,856	11,755	-3,182	19,069	8,767	986	-1,062	7,992	8,004	10,288	23,100	2,911	-12,360	4,764	0	0	0
Additional Supplemental Information
Interest paid
46,876	46,510	44,519	40,243	35,422	30,454	26,036	21,834	18,439	15,969	19,829	20,277	20,106	20,572	15,131	14,406	14,326	13,844	13,513	13,222	13,226	13,230	13,300	13,633	13,332	13,556	13,741	13,979	14,116	14,358	14,736	14,826	15,997	16,686	0	0	0
Income taxes paid
13,219	13,219	0	0	0	-	-	-	-	10,350	9,956	8,516	6,716	6,916	0	0	0	-	-	-	-	2,800	1,600	600	2,700	3,100	7,300	7,300	7,625	8,125	0	0	0	-	-	-	-
Transfer of loans to other real estate and repossessed assets
2,550	2,700	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of premises to other real estate
-	-	-	-	-	-	-	-	1,963	-	2,361	3,124	3,014	3,679	5,777	8,922	7,718	5,567	3,652	522	2,523	3,905	3,834	3,902	3,224	3,284	4,941	6,056	6,042	5,899	4,000	2,294	4,219	4,787	0	0	0
Right-of-use assets exchanged for lease obligations
0	3,411	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Salin
Net cash received in acquisition, Salin
0	-128,745	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-