Middlefield Banc Corp. MBCN Cash Flow

Middlefield banc corp. (MBCN)

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
10,741	12,711	12,995	13,030	12,837	12,431	11,392	10,550	9,960	9,455	8,729	7,610	7,029	6,416	6,506	7,145	6,724	6,865	7,003	6,939	7,045	7,180	7,113	7,060	7,134	7,028	6,476	6,460	6,415	6,281	6,341	5,571	4,651	4,130	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Provision for loan losses
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Provision for loan losses
-	-	-	-	-	840	1,060	1,130	1,090	1,045	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investment securities gains on sale, net
-	-	-	-	-	-	-	-	-	886	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss (gain) on equity securities
-124	94	-43	4	31	-9	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Provision for loan losses
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	315	-	210	175	295	370	-200	-117	63	196	1,741	1,731	1,881	2,168	1,793	2,570	2,820	3,085	0	0	0
Investment securities gains, net
-	-	-	-	-	-	-	-	-	-	-	-	-	303	369	580	350	323	257	236	278	248	84	-106	-180	11	0	0	0	-	-	-	-	-173	0	0	0
Depreciation and amortization of premises and equipment, net
1,086	1,039	1,035	1,018	979	951	1,324	1,213	1,214	1,291	943	1,118	1,103	1,026	954	916	1,024	973	1,193	1,176	1,027	1,049	724	815	871	891	1,052	936	930	929	755	748	741	731	0	0	0
Software amortization expense
634	638	624	597	600	605	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Financing lease amortization expense
390	360	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of premium and discount on investment securities, net
-249	-259	-342	-387	-409	-419	-425	-439	-431	-451	-110	-122	-136	-119	-468	-521	-587	-669	-723	-732	-744	-737	-946	-1,013	-1,099	-1,100	-977	-910	-889	-930	-878	-777	-559	-451	0	0	0
Accretion of deferred loan fees, net
749	753	735	733	786	868	895	720	607	451	341	421	359	245	285	376	433	603	497	442	402	237	250	267	288	245	252	214	166	188	189	183	185	170	0	0	0
Amortization of core deposit intangibles
339	341	343	344	346	352	363	377	393	374	286	195	72	40	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation (income) expense, net
156	644	473	373	557	467	360	313	129	33	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Restricted stock cash portion
-	44	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Origination of loans held for sale
20,521	19,845	16,453	13,283	13,969	13,196	6,263	6,679	9,482	10,020	17,584	21,544	18,701	19,736	18,646	18,090	18,581	17,889	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of loans
21,748	19,655	16,939	14,251	13,940	13,293	11,961	12,762	9,874	10,482	12,393	15,463	18,175	20,628	18,751	18,341	19,458	17,549	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of loans
510	433	352	267	264	231	216	264	195	291	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Origination of student loans held for sale
-	-	-	-	-	-	-	-	-	365,674	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of student loans
-	-	-	-	-	-	-	-	-	372,162	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of student loans
-	-	-	-	-	-	-	-	-	535	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Origination of loans held for sale
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-
Proceeds from sale of loans held for sale
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-
Gain on sale of loans
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	363	-	0	0	0	-	-	-	-	-	-	-	-	85	0	0	0	-	-	-	-
Earnings on bank-owned life insurance
433	431	433	432	421	428	433	434	434	431	422	414	413	403	659	659	654	624	332	302	278	276	277	272	279	280	280	285	279	279	277	276	273	278	0	0	0
Deferred income tax
-276	327	-308	-190	-77	-241	1,009	670	1,540	293	-849	-603	-991	-93	385	477	645	558	566	454	-303	-154	-61	58	209	423	-57	163	88	2	296	174	259	-97	0	0	0
Net gain on other real estate owned
-	123	0	0	0	-	-	-	-	-30	577	209	187	119	0	0	0	-	-	-	-	-183	-177	-93	-5	-18	20	-203	-248	-258	-237	-244	-535	-497	0	0	0
Gain on sale of other real estate owned
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other real estate owned writedowns
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	220	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Increase in accrued interest receivable
-167	-162	-49	272	564	345	556	531	204	422	211	-4	-25	39	-50	76	101	292	144	23	23	-40	-133	-22	-166	-28	-33	128	16	-71	-45	-18	-70	-25	0	0	0
Increase in accrued interest payable
44	173	316	375	363	166	138	163	145	136	128	57	-8	0	0	0	0	-	-	-	-	-49	-126	-118	-123	-128	-93	-88	-73	-153	-160	-207	-218	-145	0	0	0
Decrease in prepaid federal deposit insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-486	-698	-706	-1,143	-707	0	0	0
Other, net
591	1,867	-224	1,611	1,704	-112	2,919	596	4,820	3,536	2,261	4,087	-1,080	-330	-23	-298	184	388	1,054	511	757	831	145	518	90	-263	-891	-897	-750	-355	-705	1,251	163	-22	0	0	0
Net cash provided by operating activities
15,758	13,459	15,629	14,170	13,012	14,281	17,067	21,554	17,596	13,920	0	0	0	-	-	-	8,781	7,182	7,342	7,809	6,748	7,459	8,373	8,489	9,561	9,897	10,016	10,192	10,179	10,282	10,787	10,132	9,692	9,146	0	0	0
INVESTING ACTIVITIES
Proceeds from repayments and maturities
16,667	17,687	11,511	11,827	9,699	7,280	9,679	9,839	12,735	14,899	14,865	18,376	21,923	23,201	23,863	19,868	16,095	13,497	10,444	12,483	12,392	13,474	15,868	19,228	21,944	25,411	30,795	29,180	39,159	50,919	52,551	82,735	77,662	69,264	0	0	0
Proceeds from sale of securities
-	-	-	-	-	-	-	-	-	-	-	-	-	9,063	9,517	21,489	15,418	15,686	15,285	10,201	9,459	8,383	25,334	18,447	18,164	25,088	0	0	0	-	-	-	-	24,127	0	0	0
Purchases
37,534	34,961	0	0	0	-	-	-	-	-	-	-	-	1,744	0	0	0	-	-	-	-	-	-	-	-	25,815	58,418	63,924	87,320	83,431	53,477	94,746	75,442	80,078	0	0	0
Increase in loans, net
-5,496	-6,932	26,858	54,997	72,743	68,796	94,026	75,481	94,002	119,866	98,076	94,106	113,947	76,199	76,813	87,214	55,225	63,937	44,004	44,938	33,580	36,222	49,760	38,854	38,566	29,829	12,450	4,572	5,194	8,435	23,565	28,204	31,112	32,956	0	0	0
Proceeds from the sale of other real estate owned
-	360	0	0	0	-	-	-	-	2,196	2,819	2,513	1,934	1,607	1,223	1,489	1,469	1,762	1,451	1,406	1,084	832	497	673	792	882	1,272	943	881	954	631	928	906	866	0	0	0
Purchase of bank-owned life insurance
-	-	-	-	-	-	-	-	-	-	5	4	4	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of premises and equipment
1,786	1,897	1,678	1,200	1,793	2,101	2,007	2,265	1,625	1,201	2,524	2,378	2,327	2,166	732	419	417	507	694	852	854	902	2,020	2,028	1,799	1,834	590	616	935	997	1,145	1,148	810	583	0	0	0
Purchase of restricted stock
0	-	-	-	-	90	90	90	90	899	1,216	1,216	1,216	317	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Redemption of restricted stock
-	-	-	-	-	-	-	-	-	795	795	795	795	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisition, net of cash paid
-	-	-	-	-	-	-	-	-	5,431	5,431	5,431	5,431	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-6,467	276	-29,217	-52,460	-80,127	-76,543	-101,812	-76,380	-77,721	-95,251	0	0	0	-	-	-	-50,350	-59,445	-36,394	-40,576	-23,786	-26,722	-22,368	-25,486	-12,780	-6,097	-25,696	-19,673	-12,986	-8,005	2,243	-4,576	-19,547	-19,360	0	0	0
FINANCING ACTIVITIES
Net (decrease) increase in deposits
-36,521	4,776	20,652	119,261	95,658	137,873	116,106	85,463	96,722	50,216	60,269	20,699	18,401	5,487	12,794	4,516	14,263	38,335	26,528	34,731	22,377	17,276	20,798	3,374	3,269	-24,499	-5,516	13,690	7,555	12,373	-2,500	1,984	15,338	15,711	0	0	0
Increase in short-term borrowings, net
-31,000	-85,323	36,696	-2,833	72,329	15,691	35,030	24,445	-57,542	6,348	-12,529	21,133	50,089	32,534	28,756	37,738	21,211	21,017	-1,084	-2,422	-407	3,999	-7,083	1,532	80	4,271	5,696	-1,552	-2,125	-854	-390	172	64	-240	0	0	0
Net repayment of other borrowings
458	426	398	10,348	10,281	20,262	30,317	20,350	20,360	10,372	440	479	487	502	587	640	658	685	805	897	935	985	1,156	1,273	1,311	1,361	3,575	3,728	3,782	3,861	2,119	2,331	2,395	2,490	0	0	0
Proceeds from other borrowings
-	-	-	-	-	-	-	-	-	30,000	30,000	30,000	30,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from common stock issued
-	-	-	-	-	-	-	-	-	15,164	15,135	15,358	11,234	11,210	0	0	0	-	-	-	-	-	-	-	-	74	0	0	0	-	-	-	-	2,210	0	0	0
Stock options exercised
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	7	0	0	0	-	-	-	-	77	0	0	0	-	-	-	-	-	-	-	-
Proceeds from dividend reinvestment and purchase plan
-	372	549	662	653	618	574	569	569	540	544	536	526	519	529	587	601	651	625	622	629	590	615	583	572	736	803	791	814	694	609	604	574	542	0	0	0
Repurchase of treasury shares
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash dividends
3,740	3,685	3,629	3,634	3,625	3,779	3,739	3,701	3,665	3,358	3,098	2,837	2,567	2,318	2,218	2,170	2,126	2,153	2,178	2,149	2,126	2,121	2,116	2,109	2,106	2,097	2,089	2,079	2,065	2,002	1,940	1,884	1,797	1,764	0	0	0
Net cash provided by financing activities
-75,003	-86,555	51,662	102,426	154,902	130,309	117,765	86,501	31,019	88,722	0	0	0	-	-	-	26,527	50,374	23,045	29,841	19,490	18,709	11,104	2,145	399	-22,953	-4,733	7,049	2,828	8,679	-4,011	2,400	13,328	13,969	0	0	0
Increase in cash and cash equivalents
-65,712	-72,820	38,074	64,136	87,787	68,047	33,020	31,675	-29,106	7,391	25,655	17,444	32,144	8,745	-19	-524	-15,042	-1,889	-6,007	-2,926	2,452	-554	-2,891	-14,852	-2,820	-19,153	-20,413	-2,432	21	10,956	9,019	7,956	3,473	3,755	0	0	0
Cash paid during the year for:
Interest on deposits and borrowings
12,818	12,967	12,694	11,918	10,762	9,743	8,535	7,738	7,098	6,511	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest on deposits and borrowings
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	3,877	-	3,802	3,830	3,961	4,119	4,327	4,648	4,977	5,378	5,720	5,989	6,263	6,600	6,967	7,545	8,215	8,797	0	0	0
Income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	1,335	0	0	0	-	-	-	-	2,260	2,365	2,115	1,675	1,620	1,400	1,500	1,905	1,550	1,350	1,050	-35	615	0	0	0
Noncash operating transactions:
Operating lease assets added to other, net
-	1,071	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease liabilities added to other, net
-	1,071	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Noncash investing transactions:
Transfers from loans to other real estate owned
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,639	1,521	1,159	862	1,027	1,013	1,318	1,257	0	0	0
Transfers from loans to other real estate owned
385	122	0	0	0	-	-	-	-	1,179	1,304	1,740	1,620	720	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock issued in business acquisition
-	-	-	-	-	-	-	-	-	20,995	20,995	20,995	20,995	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of equity securities from investment securities available for sale, at fair value
-	-	-	-	-	625	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Finance lease assets added to premises and equipment
-	4,373	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Noncash financing transactions:
Finance lease liabilities added to borrowed funds
-	4,373	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash and cash equivalents acquired, net
-	-	-	-	-	-	-	-	-	5,431	5,431	5,431	5,431	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-