MID PENN BANCORP INC MPB Cash Flow

Mid penn bancorp inc (MPB)

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
3,818	4,408	4,813	4,403	4,077	4,649	2,164	2,779	1,004	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net Income
-	-	-	-	-	-	-	-	-	-	2,249	2,345	1,994	-	1,901	2,022	1,805	1,627	1,894	2,044	963	888	1,595	1,707	1,511	1,400	1,488	1,366	685	1,191	1,266	1,360	1,134	1,352	1,132	1,059	1,000
Adjustments to reconcile net income to net cash provided by operating activities:
Provision for loan and lease losses
550	235	565	465	125	275	100	0	125	100	0	100	125	550	585	395	340	200	265	300	300	400	395	275	547	200	575	415	495	361	150	225	300	50	405	550	200
Depreciation
775	714	703	698	700	724	671	577	423	389	360	352	363	420	418	401	419	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	394	314	-	310	311	313	314	318	371	247	300	307	278	268	297	303	306	324
Amortization of intangibles
323	352	355	360	363	387	341	248	248	27	25	24	29	23	32	34	37	34	36	17	13	16	27	15	4	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of intangibles
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	10	-	10	-5	10	26	8	25	18
Net amortization of security discounts/premiums
-149	-208	-351	-3	-193	-209	143	-252	-199	-2,050	28	-812	1,554	-3,280	2,901	-10,665	-665	-2,384	38	-1,521	-384	-325	-1,366	484	-43	-475	-364	-674	-1,044	-836	-798	-2,808	2,633	2,662	-363	-392	-1,140
Amortization of operating lease right of use assets
443	434	418	415	411	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of finance lease right of use asset
45	45	45	45	15	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sales of investment securities
132	1,808	46	17	7	5	30	4	98	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Earnings on cash surrender value of life insurance
76	78	79	96	78	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sales of investment securities
-	-	-	-	-	-	-	-	-	-	22	12	8	-	-	-	-	10	138	0	177	18	0	0	150	-	-	-	-	0	241	10	16	-	-	-	-
Earnings on cash surrender value of life insurance
-	-	-	-	-	-	-	-	64	-	65	66	65	64	65	65	70	71	71	71	56	49	50	51	51	57	58	58	58	61	62	62	62	64	64	65	65
Mortgage loans originated for sale
37,120	46,915	50,324	55,132	10,857	10,827	12,841	12,444	10,152	10,510	10,266	12,158	11,076	-15,878	51,035	0	7,731	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of mortgage loans originated for sale
31,190	46,774	52,439	52,120	8,946	12,499	11,042	12,812	10,000	11,474	11,087	12,049	11,191	-15,654	51,301	246	7,917	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of mortgage loans
1,182	1,166	1,091	1,077	437	193	197	205	156	226	230	225	191	224	266	246	186	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
SBA loans originated for sale
1,337	-	-	-	3,360	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of SBA loans originated for sale
1,421	-	-	-	3,562	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of SBA loans
84	-	-	-	202	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
SBA loans originated for sale
-	-	-	-	-	-	-	1,942	3,114	-	3,297	1,810	3,795	1,436	1,118	818	2,500	-	-	-	-	225	210	265	468	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of SBA loans originated for sale
-	-	-	-	-	-	-	2,094	3,371	-	3,558	1,967	4,079	1,552	1,207	893	2,690	-	-	-	-	247	229	292	519	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of SBA loans
-	-	-	-	-	-	-	152	257	-	262	157	284	116	89	75	190	-	-	-	-	22	19	27	51	-	-	-	-	-	-	-	-	-	-	-	-
Loss on write-down or disposal of property, plant, and equipment
-	-5	0	-58	-105	-	-	-	-	-24	36	0	-26	-	-	-	-	-	-	-	-	-	-	-	-	0	0	5	3	-	-	-	-	-	-	-	-
Gain on sale or write-down of foreclosed assets
-	7	-36	18	-4	-44	45	1	2	0	0	6	82	59	26	28	104	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock compensation expense
96	-	91	80	80	-	74	55	58	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on sale or write-down of foreclosed assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	47	-15	32	-	52	-30	87	-	-	-	-	-	-	-	-	-	-	-	-
Restricted stock compensation expense
-	-	-	-	-	-	-	-	-	-	-	18	19	-	-	9	8	8	11	0	8	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Gain) loss on sale/write-down of foreclosed assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-54	-303	-19	-	44	50	8	-	-	-	-
Loss (gain) on sale / write-down of foreclosed assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	27	-31	-28
Deferred income tax expense
470	1,347	-294	-578	190	-2,209	1,545	2,807	-826	812	1,081	-22	-43	-299	-53	-37	53	1,297	-369	145	-76	-183	-87	186	-28	1,415	-256	-267	-700	-238	517	-295	466	-498	264	-202	-90
Increase in accrued interest receivable
822	-450	-469	356	283	753	-174	293	-474	405	168	90	-27	-104	89	24	106	398	-50	71	-52	58	113	-17	200	20	-159	-3	-47	-103	16	-31	-56	208	190	98	-61
Increase in other assets
31	1,786	2,111	2,878	1,418	-2,621	3,158	1,190	52	-931	1,118	449	-256	582	-322	-451	290	549	-2,030	1,101	47	453	-315	257	152	1,003	-471	-623	-409	371	-279	-543	27	-646	-432	-452	-1,476
Increase in accrued interest payable
270	-615	127	-225	659	0	3	264	261	-295	152	167	106	-233	50	112	196	-215	64	43	117	-297	46	114	93	-410	26	41	116	-559	77	100	-62	-728	23	429	229
Net change in operating lease liability
-474	-	-	-	-438	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Increase in other liabilities
806	-1,617	1,125	-515	434	-2,640	1,651	-3,623	1,437	-2,460	1,907	-1,533	1,914	-2,762	919	-2,179	4,026	-2,093	1,826	-464	-40	630	-1,554	1,215	-282	-1,630	1,779	-6,654	6,824	-8,398	9,151	595	-1,070	-3,221	3,574	-2,656	2,695
Net Cash (Used In) Provided By Operating Activities
-902	638	7,071	-2,654	2,776	4,693	1,372	2,035	2,883	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-3,880	9,097	-	12,278	5,619	-1,628	-4,952	6,277	161	6,960
Investing Activities:
Net Cash Provided By Operating Activities
-	-	-	-	-	-	-	-	-	-	4,959	1,318	3,195	-	962	11,599	7,187	2,664	5,981	2,742	1,787	1,607	2,307	3,021	1,735	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the sale of available-for-sale securities
35,964	84,930	28,922	27,956	12,499	2,645	52,810	5,598	97,218	618	14,647	19,736	17,931	-	-	-	-	3,180	17,871	0	16,091	6,530	0	0	7,199	-	-	-	-	0	10,178	-887	8,604	-	-	-	-
Net decrease in interest-bearing time deposits with other financial institutions
-	-	-	-	-	-	-	-	-	-	-	-	-	0	987	1,345	1,985	996	356	0	103	0	100	-549	2,190	348	5,572	3,375	6,755	498	787	1,044	1,585	11,894	16,742	5,113	-6,185
Proceeds from the maturity or call of available-for-sale securities
5,378	4,799	5,424	1,844	1,592	1,752	9,829	-152	5,806	-1,086	3,467	2,472	1,107	-33,525	43,371	3,219	3,045	3,860	3,116	2,370	2,594	3,088	3,853	3,269	3,375	5,324	7,087	9,564	15,126	12,577	10,289	9,845	6,742	12,140	5,265	4,164	4,844
Purchases of available-for-sale securities
32,865	5,495	3,355	10,075	1,481	3,688	-391	825	20,708	845	1,369	10,289	3,538	34,430	24,079	55,007	29,345	11,412	16,134	247	8,065	3,122	10,400	22,649	7,462	9,505	4,661	5,720	7,995	949	39,664	4,127	8,813	17,115	44,353	19,017	30,672
Proceeds from the maturity or call of held-to-maturity securities
30,347	4,268	7,924	5,499	5,469	5,532	-2,664	9,279	2,346	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of held-to-maturity securities
61,945	-	-	-	-	2,498	15,027	25,454	32,396	22,605	13,408	23,758	48,926	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash received from acquisitions
-	-	-	-	-	0	7,591	0	65,025	-	-	-	-	-	-	-	-	0	0	-23	8,118	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Redemptions of restricted investment in bank stock
-347	-1,203	-375	547	-713	3,273	-1,629	6	-1,722	649	-250	1,510	32	-266	66	-228	-1,395	347	95	307	-173	-214	666	-417	177	1,074	-1,358	1,056	-306	-46	-268	-148	-155	-164	-172	-182	-190
Net increase in loans and leases
36,966	52,430	22,384	41,930	22,686	56,986	19,379	28,918	26,814	33,170	15,322	28,094	19,984	25,278	22,463	22,695	7,359	21,372	14,469	10,623	13,579	3,557	19,773	-142	3,982	-	-	-	-	-	-	-	-	-	-	-	-
Net Cash Provided by (Used In) Investing Activities
-	-	-	-	-	-	-	-	-	-	-15,129	-41,716	-51,996	-	-25,889	-34,275	-30,118	-25,288	-9,447	-9,237	5,069	3,199	-26,694	-19,105	708	-	-	-	-	-	-	-	-	-	-	-	-
Net increase in loans and leases
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,401	-	-2,475	-752	6,594	-1,318	5,940	7,639	5,513
Purchases of bank premises and equipment
2,085	2,293	477	458	657	561	1,092	4,531	2,774	2,321	3,394	394	770	205	251	165	154	200	226	642	393	233	103	174	499	24	53	233	278	218	325	35	417	401	280	419	315
Proceeds from sale of bank premises and equipment
-	-	-	-	-	-	-	-	-	0	0	0	2,201	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the sale of foreclosed assets
-	0	399	189	718	226	25	15	154	0	0	121	15	248	130	299	315	7	134	235	27	279	295	439	64	1,137	423	1,016	381	474	904	1,021	180	153	353	247	230
Net Cash Used In Investing Activities
-61,825	-1,270	-1,503	-20,379	-3,833	-56,851	34,113	-44,994	89,579	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-14,219	2,894	-	-15,114	7,803	1,442	8,153	-28,041	-17,369	-37,421
Financing Activities:
Net increase in deposits
60,887	22,301	111,692	-5,779	58,154	-36,439	21,001	24,095	-21,126	-3,107	39,207	15,581	36,514	-2,844	44,777	60,859	55,538	1,893	21,225	-5,121	-2,114	-8,075	13,992	25,330	-1,455	-	-	-	-	-	-	-	-	-	-	-	-
Net increase in demand deposits and savings accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	19,151	-24,334	21,658	3,998	26,198	-16,928	16,377	5,941	31,500	8,469	45,045
Net increase (decrease) in time deposits
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,751	-8,270	-5,878	-6,934	-8,561	-6,588	-9,229	-13,861	-7,666	-1,766	-2,320	-130
Net decrease in short-term borrowings
-	-12,000	-1,000	-22,000	-8,100	41,329	-32,554	0	-34,611	-	-	-	-	0	0	0	-31,596	25,884	-9,269	14,360	43	-21,276	14,234	-20,924	4,711	-	-	-	-	-	-	-	-	-636	-1,286	1,224	-863
Preferred stock dividends paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	87	-	-	-	-	-	-	-	-	-	125	125	125
Common stock dividends paid
1,950	1,526	1,525	1,524	2,113	1,267	1,268	918	1,060	551	552	550	551	507	508	507	930	507	506	422	350	701	350	350	174	-	-	-	-	350	174	174	174	174	174	174	174
Proceeds from Stock Purchase Plan stock issuance
-	-	-	-	-	-	-	-	-	-	-	25	27	-	-	16	19	-	19	15	16	15	13	11	14	12	15	13	15	-	-	-	-	-	-	-	-
Net change in finance lease liability
21	20	20	-9	15	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the issuance of subordinated debt
15,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Employee Stock Purchase Plan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15	14	14	-	9	10	8
Warrant repurchase
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	58	-	-	-	-	-	-	-	-
Long-term debt repayment
9,529	30,045	2,047	50	42	46	45	49	58	1,054	57	54	55	54	16,554	10,054	62	11,058	58	5,059	51	47	46	46	45	45	3,544	10,043	733	48	48	48	47	46	46	45	5,045
Net Cash (Used In) Provided By Financing Activities
-	-	-	-	-	-	-	-	-	-	37,175	36,470	35,935	-	27,736	50,314	22,969	16,674	11,319	3,681	-2,543	-10,171	27,755	13,933	2,964	-	-	-	-	-	-	-	-	-	-	-	-
Net Cash Provided By Financing Activities
64,455	-21,217	107,166	-15,790	47,960	30,138	-12,807	23,191	-56,801	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-12,991	14,021	-	15,833	-23,045	2,184	-2,695	28,112	7,039	38,716
Net increase in cash and cash equivalents
1,728	-21,849	112,734	-38,823	46,903	-22,020	22,678	-19,768	35,661	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net increase (decrease) in cash and cash equivalents
-	-	-	-	-	-	-	-	-	-	27,005	-3,928	-12,866	-	2,809	27,638	38	-5,950	7,853	-2,814	4,313	-5,365	3,368	-2,151	5,407	-4,594	2,822	-31,090	26,012	-7,740	12,997	-9,623	1,998	506	6,348	-10,169	8,255
Supplemental Disclosures of Cash Flow Information:
Cash paid for interest
5,764	7,245	6,619	6,453	4,901	4,640	2,596	2,042	1,825	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest paid
-	-	-	-	-	-	-	-	-	-	1,482	1,302	1,278	-	1,307	1,214	1,086	1,393	1,087	1,115	971	1,408	1,043	1,005	1,015	1,526	1,166	1,265	1,327	2,101	1,611	1,762	2,095	2,920	2,352	2,056	2,241
Cash paid for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	710	425	365	200	200	300	530	100	-	-	-	-	-	-	-	-	450	165	485	600	375	0	565	0
Supplemental Noncash Disclosures:
Recognition of operating lease right of use assets
-	-	-	-	11,661	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recognition of operating lease liabilities
-	-	-	-	12,866	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recognition of finance lease right of use asset
-	-	-	-	3,597	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recognition of finance lease liability
-	-	-	-	3,597	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Asset transferred to bank premises and equipment held for sale
-	-	0	0	1,274	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loans transferred to foreclosed assets held for sale
1,522	73	103	247	47	98	134	183	701	-	-	-	-	30	117	73	28	250	404	265	216	90	113	414	264	129	1,386	971	291	-	-	-	-	-	-	-	-
Assets Acquired:
Liabilities Assumed:
Equity Acquired:
Loan transfers to foreclosed assets held for sale
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	146	-	648	157	249
Employee [Member]
Proceeds from Stock Purchase Plan stock issuance
33	39	32	35	28	35	28	32	24	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Director [Member]
Proceeds from Stock Purchase Plan stock issuance
35	34	34	34	33	32	31	31	30	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Scottdale [Member]
Common stock issued to shareholders
-	-	-	-	-	-	0	0	1,879	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Securities
-	-	-	-	-	-	-	0	114,039	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loans
-	-	-	-	-	-	-	83	70,686	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Restricted stock
-	-	-	-	-	-	-	0	97	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Property and equipment
-	-	-	-	-	-	-	0	1,496	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Foreclosed assets
-	-	-	-	-	-	-	0	11	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income taxes
-	-	-	-	-	-	-	429	621	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued interest receivable
-	-	-	-	-	-	-	0	989	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Core deposit intangible
-	-	-	-	-	-	-	0	4,940	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets
-	-	-	-	-	-	-	0	266	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Assets acquired
-	-	-	-	-	-	-	512	193,145	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deposits
-	-	-	-	-	-	-	0	209,981	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued interest payable
-	-	-	-	-	-	-	0	16	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other liabilities
-	-	-	-	-	-	-	1,091	2,602	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Liabilities assumed
-	-	-	-	-	-	-	1,091	212,599	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-