MutualFirst | Universal | Pro Forma | ||||||||||||||||
Combined | ||||||||||||||||||
December 31, | December 31, | |||||||||||||||||
2017 | 2017 | Pro Forma | December 31, | |||||||||||||||
(Audited) | (Unaudited) | Adjustments | 2017 | |||||||||||||||
Assets
|
||||||||||||||||||
Cash and due from banks
|
$
|
8,763
|
$
|
10,173
|
$
|
(8,999
|
)
|
A
|
$
|
9,937
|
||||||||
Interest-bearing demand deposits
|
18,578
|
4,001
|
-
|
22,579
|
||||||||||||||
Cash and cash equivalents
|
27,341
|
14,174
|
(8,999
|
)
|
32,516
|
|||||||||||||
Interest-bearing time deposits
|
1,853
|
2,584
|
(23
|
)
|
B
|
4,414
|
||||||||||||
Investment securities available for sale (carried at fair value)
|
277,378
|
89,134
|
(170
|
)
|
C
|
366,342
|
||||||||||||
Loans held for sale
|
4,577
|
-
|
-
|
4,577
|
||||||||||||||
Loans, net of allowance for loan losses
|
1,167,758
|
258,737
|
(1,404
|
)
|
D
|
1,425,091
|
||||||||||||
Premises and equipment, net
|
21,539
|
6,270
|
(1,316
|
)
|
E
|
26,493
|
||||||||||||
Federal Home Loan Bank stock
|
11,183
|
1,637
|
-
|
12,820
|
||||||||||||||
Deferred tax asset, net
|
7,530
|
2,173
|
(1,167
|
)
|
F
|
8,536
|
||||||||||||
Cash value of life insurance
|
52,707
|
7,530
|
-
|
60,237
|
||||||||||||||
Goodwill
|
1,800
|
1,895
|
16,128
|
G
|
19,823
|
|||||||||||||
Other real estate owned and repossessed assets
|
733
|
1,878
|
(719
|
)
|
H
|
1,892
|
||||||||||||
Other assets
|
14,533
|
3,387
|
5,003
|
I
|
22,923
|
|||||||||||||
Total assets
|
$
|
1,588,932
|
$
|
389,399
|
$
|
7,333
|
$
|
1,985,664
|
||||||||||
Liabilities and Stockholders' Equity
|
||||||||||||||||||
Liabilities
|
||||||||||||||||||
Deposits
|
||||||||||||||||||
Noninterest-bearing
|
$
|
194,134
|
$
|
92,286
|
$
|
-
|
$
|
286,420
|
||||||||||
Interest-bearing
|
1,007,900
|
222,525
|
(357
|
)
|
J
|
1,230,068
|
||||||||||||
Total deposits
|
1,202,034
|
314,811
|
(357
|
)
|
1,516,488
|
|||||||||||||
Federal Home Loan Bank advances
|
217,163
|
25,876
|
(413
|
)
|
K
|
242,626
|
||||||||||||
Other borrowings
|
4,232
|
5,000
|
9,000
|
L
|
18,232
|
|||||||||||||
Other liabilities
|
15,221
|
491
|
-
|
15,712
|
||||||||||||||
Total liabilities
|
1,438,650
|
346,178
|
8,230
|
1,793,058
|
||||||||||||||
Commitments and Contingencies
|
||||||||||||||||||
Stockholders' Equity
|
||||||||||||||||||
Common stock
|
74
|
100
|
(88
|
)
|
M
|
86
|
||||||||||||
Additional paid-in capital
|
75,319
|
1,306
|
41,006
|
N
|
117,631
|
|||||||||||||
Retained earnings
|
74,508
|
42,051
|
(42,051
|
)
|
O
|
74,508
|
||||||||||||
Accumulated other comprehensive income (loss)
|
381
|
(236
|
)
|
236
|
P
|
381
|
||||||||||||
Total stockholders' equity
|
150,282
|
43,221
|
(897
|
)
|
192,606
|
|||||||||||||
Total liabilities and stockholders' equity
|
$
|
1,588,932
|
$
|
389,399
|
$
|
7,333
|
$
|
1,985,664
|
Pro Forma | ||||||||||||||||||
Twelve Months Ended | Combined | |||||||||||||||||
December 31, | ||||||||||||||||||
MFSF | Universal | Pro Forma | December 31, | |||||||||||||||
2017 | 2017 | Adjustments | 2017 | |||||||||||||||
Interest and Dividend Income
|
||||||||||||||||||
Loans receivable
|
$
|
51,231
|
$
|
14,231
|
$
|
2,339
|
A
|
$
|
67,801
|
|||||||||
Investment securities
|
7,037
|
2,262
|
10
|
B
|
9,309
|
|||||||||||||
Federal Home Loan Bank stock
|
470
|
70
|
-
|
540
|
||||||||||||||
Deposits with financial institutions
|
130
|
110
|
-
|
240
|
||||||||||||||
Total interest and dividend income
|
58,868
|
16,673
|
2,349
|
77,890
|
||||||||||||||
Interest Expense
|
||||||||||||||||||
Deposits
|
6,815
|
940
|
167
|
C
|
7,922
|
|||||||||||||
Federal Home Loan Bank advances
|
3,604
|
405
|
207
|
D
|
4,216
|
|||||||||||||
Other
|
192
|
256
|
512
|
E
|
960
|
|||||||||||||
Total interest expense
|
10,611
|
1,601
|
886
|
13,098
|
||||||||||||||
Net Interest Income
|
48,257
|
15,072
|
1,463
|
64,792
|
||||||||||||||
Provision for loan losses
|
1,220
|
-
|
-
|
1,220
|
||||||||||||||
Net Interest Income After Provision for Loan Losses
|
47,037
|
15,072
|
1,463
|
63,572
|
||||||||||||||
Non-interest Income
|
||||||||||||||||||
Service fee income
|
6,584
|
639
|
-
|
7,223
|
||||||||||||||
Net realized gain on sales of available for sale securities
|
708
|
82
|
-
|
790
|
||||||||||||||
Commissions
|
5,027
|
15
|
-
|
5,042
|
||||||||||||||
Net gains on sales of loans
|
3,887
|
723
|
-
|
4,610
|
||||||||||||||
Net servicing fees
|
391
|
417
|
-
|
808
|
||||||||||||||
Increase in cash value of life insurance
|
1,113
|
173
|
-
|
1,286
|
||||||||||||||
Gain (loss) on sale of other real estate and repossessed assets
|
(122
|
)
|
233
|
-
|
111
|
|||||||||||||
Other income
|
488
|
84
|
-
|
572
|
||||||||||||||
Total non-interest income
|
18,076
|
2,366
|
-
|
20,442
|
||||||||||||||
Non-interest Expenses
|
||||||||||||||||||
Salaries and employee benefits
|
27,229
|
8,066
|
-
|
35,295
|
||||||||||||||
Net occupancy expenses
|
3,133
|
985
|
-
|
4,118
|
||||||||||||||
Equipment expenses
|
1,773
|
513
|
-
|
2,286
|
||||||||||||||
Data processing fees
|
2,321
|
1,043
|
-
|
3,364
|
||||||||||||||
ATM and debit card expenses
|
1,676
|
480
|
-
|
2,156
|
||||||||||||||
Deposit insurance
|
724
|
156
|
-
|
880
|
||||||||||||||
Professional fees
|
1,855
|
558
|
-
|
2,413
|
||||||||||||||
Advertising and promotion
|
1,223
|
227
|
-
|
1,450
|
||||||||||||||
Software subscriptions and maintenance
|
2,202
|
-
|
-
|
2,202
|
||||||||||||||
Other real estate and repossessed assets
|
165
|
285
|
-
|
450
|
||||||||||||||
Other expenses
|
3,704
|
1,386
|
1,130
|
F
|
6,220
|
|||||||||||||
Total non-interest expenses
|
46,005
|
13,699
|
1,130
|
60,834
|
||||||||||||||
Income Before Income Tax
|
19,108
|
3,739
|
333
|
23,180
|
||||||||||||||
Income tax expense
|
6,793
|
1,520
|
83
|
G
|
8,396
|
|||||||||||||
Net Income
|
$
|
12,315
|
$
|
2,219
|
$
|
250
|
$
|
14,784
|
||||||||||
Earnings Per Common Share
|
||||||||||||||||||
Basic
|
$
|
1.67
|
$
|
29.20
|
$
|
1.73
|
||||||||||||
Diluted
|
$
|
1.64
|
$
|
29.20
|
$
|
1.70
|
||||||||||||
Dividends Per Common Share
|
$
|
0.66
|
$
|
-
|
$
|
0.58
|
Pro Forma Purchase Price ($ in thousands)
|
||||
Estimated numbers of shares of Universal common stock exchanged
|
75,996
|
|||
Per share exchange ratio (stock)
|
15.6
|
|||
Number of shares of MutualFirst common stock - as exchanged
|
1,185,538
|
|||
Multiplied by MutualFirst common stock price on February 28, 2018
|
$
|
35.70
|
||
Estimated fair value of MutualFirst common stock issued
|
42,324
|
|||
Cash consideration paid
|
18,999
|
|||
Total Pro Forma Purchase Price
|
$
|
61,323
|
Universal Net Assets at Fair Value (condensed)
|
|||||||
Assets
|
|||||||
Cash and cash equivalents
|
$
|
14,174
|
|||||
Securities
|
91,525
|
||||||
Loans held for investment, net of unearned income
|
257,333
|
||||||
Premises and equipment, net
|
4,954
|
||||||
Other assets
|
19,722
|
||||||
Total Assets
|
$
|
387,708
|
|||||
Liabilities
|
|||||||
Deposits
|
$
|
314,454
|
|||||
Borrowings
|
29.463
|
||||||
Other liabilities
|
491
|
||||||
Total Liabilities
|
$
|
344,408
|
|||||
Net Assets
|
43,300
|
||||||
Preliminary Pro Forma Goodwill
|
$ |
18,023
|
Balance Sheet
|
||||
A
|
Adjustments to cash and cash equivalents:
|
|||
Estimated cash portion of the $18,999 consideration paid to Universal Shareholders. The balance of the consideration is shown below in item G.
|
$ (8,999)
|
|||
B
|
Fair value adjustment on CD investments
|
$ (23)
|
||
C
|
Fair value adjustments on investment portfolio
|
$ (170)
|
||
D
|
Adjustments to loans, net of allowance for loan losses:
|
|||
Elimination of Universal's allowance for loans loss
|
$ 3,247
|
|||
Loans adjusted for credit deterioration of the acquired portfolio
|
(4,651)
|
|||
Total adjustments for loans, net of allowance for loan losses
|
$ (1,404)
|
|||
E
|
Fair Value adjustment on premises and equipment
|
$ (1,316)
|
||
F
|
Deferred tax asset (liability)
|
|||
Deferred tax asset generated by purchase accouting adjustments (rate = 25%)
|
$ (1,167)
|
|||
G
|
Adjustment to goodwill to reflect the elimination of Universal's goodwill of ($1,895), goodwill generated as a result of consideration paid being greater than the net assets acquired of $18,023.
|
$ 16,128
|
||
H
|
Other real estate adjustment for deterioration in the acquired assets
|
$ (719)
|
||
I
|
Adjustment to other assets:
|
|||
To record the core deposit intangible of $4,545 and an increase to mortgage servicing rights of $458.
|
$ 5,003
|
|||
J
|
Fair value adjustment on time deposits
|
$ (357)
|
||
K
|
Fair value adjustment on FHLB advances
|
$ (413)
|
||
L
|
Adjustments to borrowings:
|
|||
Estimated amount of borrowings to reflect a portion of the consideration paid to Universal Shareholders. The balance of the consideration is included in item A above.
|
$ 10,000
|
|||
To reflect a fair value adjustment on subordinate debenture
|
(1,000)
|
|||
Total adjustments to borrowings
|
$ 9,000
|
|||
M
|
Adjustments to common stock:
|
|||
To reflect the elimination of Universal's December 31, 2017 common stock
|
$ (100)
|
|||
To reflect the par value of the MutualFirst common stock issued to Universal shareholders
|
12
|
|||
Total adjustments to common stock
|
$ (88)
|
|||
N
|
Adjustments to additional paid-in capital:
|
|||
Elimination of Universal's additional paid-in capital
|
$ (1,306)
|
|||
To reflect the value of MutualFirst common stock issued to Universal shareholders
|
42,312
|
|||
Total adjustments to additional paid-in capital
|
$ 41,006
|
|||
O
|
Elimination of Universal's retained earnings
|
$ (42,051)
|
||
P
|
Elimination of Universal's accumulated other comprehensive income
|
236
|
Income Statement
|
||||
Twelve Months Ended
|
||||
December 31, 2017
|
||||
A
|
Estimated purchase accounting adjustment on acquired nonimpaired loans based on the difference between fair value and the outstanding principal balance of those loans, recognized over the estimated remaining term of the loans.
|
$ 2,339
|
||
B
|
Estimated interest accretion on investment in time deposits
|
10
|
||
C
|
Estimated amortization on time deposits
|
167
|
||
D
|
Estimated amortization on FHLB advances
|
207
|
||
E
|
Adjustments to borrowings:
|
|||
Estimated purchase accounting adjustment on subordinate debenture
|
$ 57
|
|||
Interest expense on borrowings related to the cash consideration paid to Universal shareholders
|
455
|
|||
Total adjustments to borrowings
|
$ 512
|
|||
F
|
Adjustment to reflect amortization of core deposit intangible
|
$ 1,130
|
||
G
|
Adjustment to reflect income tax effect related to purchase accounting adjustments and interest expense (benefit) at a 25% combined tax rate
|
$ 83
|
Basic
|
Diluted
|
|||||||
Pro forma net income available to common shareholders
|
$
|
14,764
|
$
|
14,764
|
||||
Weighted average common shares outstanding:
|
||||||||
MutualFirst
|
7,350
|
7,494
|
||||||
Common shares issued to Universal shareholders
|
1,186
|
1,186
|
||||||
Pro forma
|
8,536
|
8,680
|
||||||
Pro forma net income per common share
|
$
|
1.73
|
$
|
1.70
|