First Merchants Corporation Financial Ratios — FRME Stock

Profitability (USD)

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Return on Common Equity (%)	12.65	21.23	18.43	22.1	20.3	21.52	21.9	30	25.44	19.83	24.66	23.33	20.34	16.34	16.6
Return on Assets (%)	0.61	1.06	0.91	1.07	1.04	1.16	1.16	1.65	1.47	1.12	1.39	1.33	1.23	1.1	1.21
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
EBITDA Margin (%)	2.68	2.06	2.22	2.41	2.44	2.46	2.29	2.13	2.12	2.24	2.06	1.88	1.8	4.28	4.44
Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Pretax Margin (%)	17.62	28.15	28.73	33.07	35.46	37.25	38.36	45.3	43.71	34.54	46.31	40.7	39.82	36.98	39.09
Profit Margin (%)	13.12	20.83	21.18	24.18	25.47	27.79	27.58	38.32	37.1	30.2	39.52	35.36	34.38	32.14	34.09
Net Income to Common Margin (%)	11.05	18.73	20.04	24.18	25.47	27.79	27.58	38.32	37.1	30.2	39.52	35.13	34.09	31.84	33.81
Effective Tax Rate (%)	25.53	26.02	26.29	26.89	28.19	25.41	28.09	15.41	15.13	12.58	14.64	13.14	13.67	13.09	12.78
Dvd Payout Ratio (%)	3.52	7.15	13.31	17.78	23.94	27.39	33.12	26.18	31.18	38.05	29.79	32.96	36.08	40.91	36.99
Sustainable Growth Rate (%)	12.2	19.71	15.98	18.17	15.44	15.62	14.64	22.15	17.51	12.28	17.31	15.64	13	9.66	10.46

Credit (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Total Debt	333	206	249	272	363	427	554	453	490	508	453	975	871	916	856
ST Debt	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
LT Debt	333	206	249	272	363	427	554	453	490	508	453	975	871	916	856
Total Debt/EBITDA	64.57	46.15	53.31	45.29	58.05	59.68	69.5	51.28	52.2	46.13	42.3	82.52	74.42	34.12	29.1
Net Debt/EBITDA	40.11	14.87	18.08	17.64	36.57	38.4	45.66	31.35	20.71	-7.03	-17.63	61.47	27.56	19.72	19.57
Total Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Net Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBIT to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	4.13	4.88	4.55	5.1	5.14	5.63	5.03	5.96	5.65	5.65	5.64	5.67	6.31	6.99	7.47
Long-Term Debt/Equity (%)	64.74	37.38	39.21	37.43	42.74	47.4	42.48	32.2	27.42	27.07	23.67	47.92	38.77	39.74	34.71
Long-Term Debt/Capital (%)	55.86	40.69	50.14	47.79	51.14	51.27	54.01	43.47	41.04	38.96	34.18	48.26	42.33	41.25	37.19
Long-Term Debt/Total Assets (%)	7.98	4.79	4.58	4.67	5.38	5.93	5.91	4.59	3.93	3.61	2.93	5.42	4.73	5	4.5
Total Debt/Equity (%)	64.74	37.38	39.21	37.43	42.74	47.4	42.48	32.2	27.42	27.07	23.67	47.92	38.77	39.74	34.71
Total Debt/Capital (%)	55.86	40.69	50.14	47.79	51.14	51.27	54.01	43.47	41.04	38.96	34.18	48.26	42.33	41.25	37.19
Total Debt/Total Assets (%)	7.98	4.79	4.58	4.67	5.38	5.93	5.91	4.59	3.93	3.61	2.93	5.42	4.73	5	4.5
Net Debt to Equity	40.22	12.04	13.3	14.58	26.93	30.5	27.91	19.69	10.88	-4.13	-9.86	35.7	14.36	22.98	23.34
Net Debt/Capital (%)	44.01	18.1	25.44	26.28	39.73	40.37	43.55	31.98	21.64	-10.78	-27.62	41	21.38	28.87	28.48
EBITDA	5	4	5	6	6	7	8	9	9	11	11	12	12	27	29
EBITDA-CapEx	5	4	5	6	6	7	8	9	9	11	11	12	12	27	29
Operating Income (Loss)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Liquidity (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Cash Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Current Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Quick Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
CFO/Avg Current Liab	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	4.13	4.88	4.55	5.1	5.14	5.63	5.03	5.96	5.65	5.65	5.64	5.67	6.31	6.99	7.47
Long-Term Debt/Equity (%)	64.74	37.38	39.21	37.43	42.74	47.4	42.48	32.2	27.42	27.07	23.67	47.92	38.77	39.74	34.71
Long-Term Debt/Capital (%)	55.86	40.69	50.14	47.79	51.14	51.27	54.01	43.47	41.04	38.96	34.18	48.26	42.33	41.25	37.19
Long-Term Debt/Total Assets (%)	7.98	4.79	4.58	4.67	5.38	5.93	5.91	4.59	3.93	3.61	2.93	5.42	4.73	5	4.5
Total Debt/Equity (%)	64.74	37.38	39.21	37.43	42.74	47.4	42.48	32.2	27.42	27.07	23.67	47.92	38.77	39.74	34.71
Total Debt/Capital (%)	55.86	40.69	50.14	47.79	51.14	51.27	54.01	43.47	41.04	38.96	34.18	48.26	42.33	41.25	37.19
Total Debt/Total Assets (%)	7.98	4.79	4.58	4.67	5.38	5.93	5.91	4.59	3.93	3.61	2.93	5.42	4.73	5	4.5
CFO/Total Liabilities	2.34	1.87	3.81	1.49	0.96	1.64	1.57	2.13	1.66	1.67	1.59	1.78	1.6	1.66	1.71
CFO/CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	0.14	0.19	0.19	0.21	0.21	0.27	0.25	0.25	0.24	0.22	0.22	0.21	0.21	0.22	0.22

Working Capital (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Accounts Receivable Turnover	10.58	12.71	12	12.88	11.57	11.53	11	10.65	9.88	9.57	9.36	8.83	7.13	6.61	7.16
Days Sales Outstanding	34.51	28.72	30.41	28.35	31.56	31.67	33.18	34.28	36.96	38.15	39	41.33	51.23	55.18	50.98
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover Days	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Conversion Cycle	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Inventory to Cash Days	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Market Capitalization	225	424	674	825	961	1,533	1,897	1,688	2,137	2,022	2,254	2,369	2,200	2,327	2,153
- Cash & Cash Equivalents	126	140	165	166	134	152	190	176	295	585	641	249	549	387	280
+ Preferred Equity and Hybrid Capital	91	91	- -	- -	- -	- -	- -	- -	- -	- -	- -	25	25	25	25
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	333	206	249	272	363	427	554	453	490	508	453	975	871	916	856
Enterprise Value	4	68	223	381	531	1,112	1,261	824	542	25	-279	1,144	921	2,443	2,328
Total Capital	596	507	496	569	711	834	1,025	1,043	1,193	1,303	1,324	2,020	2,059	2,221	2,302
Total Debt/Capital (%)	55.86	40.69	50.14	47.79	51.14	51.27	54.01	43.47	41.04	38.96	34.18	48.26	42.33	41.25	37.19
Total Debt / EV	86.45	3.03	1.12	0.71	0.68	0.38	0.44	0.55	0.9	20.22	-1.62	0.85	0.95	0.37	0.37
EV/Sales	0.02	0.31	1.06	1.53	2.07	3.81	3.62	1.98	1.22	0.05	- -	1.82	1.41	3.9	3.51
EV/EBITDA	0.75	15.25	47.7	63.43	84.87	155.24	158.28	93.15	57.75	2.28	- -	96.79	78.64	91	79.12
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	0.05	0.97	1.22	5.02	9.38	10.72	9.97	4.57	3.07	0.12	- -	4.02	3.56	9.18	8.21
EV/Free Cash Flow to Firm	0.05	0.97	1.22	5.02	9.38	10.72	9.97	4.57	3.07	0.12	- -	4.02	3.56	9.18	8.21
Diluted Market Cap	226	428	682	832	968	1,544	1,910	1,695	2,144	2,028	2,261	2,382	2,206	2,335	2,164
Diluted Enterprise Value	524	585	766	938	1,197	1,819	2,274	1,973	2,339	1,951	2,073	3,134	2,554	2,890	2,764
EV per Share	0.15	2.39	7.5	10.51	14.06	27.29	27.96	16.72	10.54	0.46	- -	19.85	15.52	41.88	40.51
TTM Sales	192	217	210	249	257	292	348	415	443	492	520	628	651	627	663
TTM EBITDA	5	4	5	6	6	7	8	9	9	11	11	12	12	27	29
TTM Operating Income	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Cash Flow to Firm	85	70	183	76	57	104	127	180	177	204	215	284	259	266	284
TTM Free Cash Flow to Firm	85	70	183	76	57	104	127	180	177	204	215	284	259	266	284

Multiples (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Price/Free Cash Flow	2.64	6.09	3.72	10.97	17.09	14.89	15.1	9.41	12.13	9.95	10.5	8.38	8.52	8.77	7.63
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	4	68	223	381	531	1,112	1,261	824	542	25	-279	1,144	921	2,443	2,328
Low Price	6.63	8.48	14.08	19.38	21.37	21.1	35.26	32.49	33	21.18	33.98	34.07	24.52	30.55	33.13
EV/Sales	0.02	0.31	1.06	1.53	2.07	3.81	3.62	1.98	1.22	0.05	- -	1.82	1.41	3.9	3.51
EV/EBITDA	0.75	15.25	47.7	63.43	84.87	155.24	158.28	93.15	57.75	2.28	- -	96.79	78.64	91	79.12
Price/Earnings	10.56	10.45	16	13.7	14.69	18.92	19.75	10.61	13	13.6	10.97	10.73	9.91	11.66	9.61
Price/Earnings Average	10.42	8.94	12.22	12.67	14.26	13.31	19	13.61	11.89	10.82	11.21	10.75	8.61	10.63	9.96
Price/Earnings High	12.09	11.11	16.44	14.09	15.95	19.11	21.32	15.62	13.27	15.34	13.26	12.04	11.76	13.49	11.7
Price/Earnings Low	8.26	5.97	9.92	11.67	12.35	10.6	16.55	10.06	10.31	7.7	8.9	8.9	6.56	8.93	8.49
Price/Book Value	1.3	2.02	2.73	2.78	2.77	3.78	4.02	2.86	3.04	2.54	2.59	2.32	1.89	1.82	1.52
Price/Book Value Average	1.29	1.73	2.08	2.56	2.68	2.66	3.87	3.67	2.78	2.02	2.64	2.33	1.64	1.66	1.57
Price/Book Value High	1.49	2.15	2.8	2.85	3	3.81	4.35	4.22	3.1	2.87	3.13	2.6	2.25	2.1	1.84
Price/Book Value Low	1.02	1.15	1.69	2.36	2.33	2.12	3.37	2.72	2.41	1.44	2.1	1.92	1.25	1.39	1.34
Price/Tangible Book Value	0.82	1.36	1.56	1.62	1.63	2.39	2.29	1.8	1.77	1.55	1.68	1.88	1.48	1.5	1.26
Price/Tangible Book Value Average	0.81	1.16	1.19	1.5	1.58	1.68	2.21	2.31	1.62	1.23	1.72	1.88	1.29	1.37	1.3
Price/Tangible Book Value High	0.94	1.45	1.6	1.67	1.77	2.41	2.48	2.65	1.81	1.75	2.03	2.11	1.76	1.74	1.53
Price/Tangible Book Value Low	0.64	0.78	0.97	1.38	1.37	1.34	1.92	1.71	1.4	0.88	1.36	1.56	0.98	1.15	1.11
Price/Sales	1.17	1.96	3.21	3.31	3.74	5.26	5.45	4.07	4.82	4.11	4.33	3.77	3.38	3.71	3.25
Price/Sales Average	1.15	1.67	2.45	3.06	3.63	3.7	5.24	5.22	4.41	3.27	4.43	3.78	2.94	3.38	3.37
Price/Sales High	1.34	2.08	3.3	3.41	4.06	5.31	5.88	5.98	4.92	4.63	5.24	4.23	4.01	4.29	3.95
Price/Sales Low	0.91	1.12	1.99	2.82	3.15	2.95	4.57	3.85	3.83	2.33	3.52	3.13	2.23	2.84	2.87
Price/Cash Flow	2.63	6.04	3.68	10.87	16.96	14.78	15	9.37	12.09	9.92	10.47	8.33	8.5	8.74	7.59
Price/Cash Flow Average	2.59	5.16	2.81	10.05	16.45	10.4	14.43	12.02	11.07	7.89	10.7	8.34	7.38	7.97	7.87
Price/Cash Flow High	3.01	6.42	3.78	11.18	18.41	14.93	16.19	13.79	12.35	11.18	12.66	9.35	10.08	10.11	9.24
Price/Cash Flow Low	2.06	3.45	2.28	9.26	14.25	8.29	12.57	8.88	9.6	5.61	8.49	6.91	5.62	6.7	6.71
Price/Free Cash Flow Average	2.61	5.21	2.84	10.13	16.58	10.48	14.52	12.07	11.1	7.92	10.73	8.39	7.4	7.99	7.91
Price/Free Cash Flow High	3.03	6.48	3.83	11.27	18.55	15.03	16.3	13.84	12.39	11.22	12.7	9.4	10.11	10.14	9.28
Price/Free Cash Flow Low	2.07	3.48	2.31	9.34	14.37	8.34	12.66	8.92	9.63	5.63	8.52	6.94	5.64	6.72	6.74
EV/Sales Average	2.7	2.4	2.85	3.49	4.52	4.64	6.29	5.88	4.85	3.11	4.07	4.97	3.47	4.27	4.28
EV/Sales High	2.88	2.81	3.7	3.83	4.96	6.25	6.93	6.65	5.36	4.48	4.88	5.43	4.54	5.18	4.86
EV/Sales Low	2.46	1.85	2.39	3.25	4.04	3.89	5.61	4.52	4.26	2.17	3.15	4.32	2.77	3.73	3.78
EV/EBITDA Average	100.71	116.3	128.38	144.5	185.44	189.12	274.78	276.35	229.15	139.07	197.61	264.38	192.92	99.63	96.33
EV/EBITDA High	107.59	136.04	166.52	158.78	203.17	254.66	302.81	312.43	253.4	200.07	237.05	288.52	252.48	120.9	109.51
EV/EBITDA Low	91.81	89.39	107.6	134.58	165.57	158.43	245.29	212.41	201.47	96.94	153.23	229.75	153.94	87.04	85.12
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Last Price	8.47	14.84	22.72	22.75	25.42	37.65	42.06	34.27	41.59	37.41	41.89	41.11	37.08	39.89	37.48
High Price	9.7	15.78	23.35	23.39	27.6	38.02	45.42	50.44	42.48	42.19	50.65	46.12	43.97	46.13	45.62
Enterprise Value Average	519	520	600	868	1,161	1,354	2,189	2,444	2,150	1,531	2,115	3,124	2,259	2,675	2,834
Enterprise Value High	555	608	778	954	1,272	1,824	2,413	2,762	2,378	2,203	2,537	3,409	2,957	3,246	3,222
Enterprise Value Low	474	400	503	808	1,037	1,134	1,954	1,878	1,890	1,067	1,640	2,715	1,803	2,337	2,504

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Shares Outstanding	29	29	36	38	41	41	49	49	55	54	53	59	59	58	57
Diluted Weighted Avg Shares	27	29	30	37	38	41	45	49	52	54	54	58	59	59	58
Basic Weighted Avg Shares	27	29	30	36	38	41	45	49	51	54	54	58	59	58	57
Revenue per Share	7.26	7.58	7.08	6.87	6.79	7.16	7.72	8.43	8.63	9.11	9.66	10.9	10.97	10.74	11.54
EBITDA per Share	0.19	0.16	0.16	0.17	0.17	0.18	0.18	0.18	0.18	0.2	0.2	0.21	0.2	0.46	0.51
Operating Income per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic EPS, GAAP	0.8	1.42	1.42	1.66	1.73	1.99	2.13	3.23	3.2	2.75	3.82	3.83	3.74	3.42	3.9
Basic EPS from Cont Ops	0.95	1.58	1.5	1.66	1.73	1.99	2.13	3.23	3.2	2.75	3.82	3.85	3.77	3.45	3.93
Diluted EPS, GAAP	0.8	1.41	1.4	1.65	1.72	1.98	2.12	3.22	3.19	2.74	3.81	3.81	3.73	3.41	3.88
Diluted EPS from Cont Ops	0.95	1.56	1.48	1.65	1.72	1.98	2.12	3.22	3.19	2.74	3.81	3.83	3.76	3.44	3.92
Dividend per Share	0.18	0.26	0.27	0.3	0.41	0.55	0.71	0.85	1	1.05	1.14	1.29	1.38	1.43	1.48
Cash Flow per Share	3.22	2.46	6.17	2.09	1.5	2.55	2.8	3.66	3.44	3.77	4	4.93	4.36	4.56	4.94
Free Cash Flow per Basic Share	3.22	2.46	6.17	2.09	1.5	2.55	2.8	3.66	3.44	3.77	4	4.93	4.36	4.56	4.94
Cash & Equivalents per Share	24.32	22.86	23.61	19.75	20.98	20.85	26.38	26.76	40.58	46.35	55.5	38.62	36.67	14.14	12.3
Book Value per Share	6.5	7.35	8.34	8.2	9.19	9.97	10.45	11.97	13.69	14.72	16.2	17.71	19.58	21.94	24.73
Tangible Book Value per Share	10.3	10.91	14.55	14.02	15.63	15.78	18.33	19.05	23.49	24.11	24.93	21.9	25	26.53	29.86

First Merchants Corporation

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)