LSI Industries Inc. Financial Ratios — LYTS 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 (%)	22.91	3.23	-0.08	0.66	3.66	6.35	1.9	-13.07	-12.61	7.81	4.57	10.78	15.86	13.1	11.24
Return on Assets (%)	6.19	1.84	-0.07	0.55	2.94	5.04	1.33	-8.04	-7.59	5.14	2.56	5.03	8.49	7.75	6.54
Return on Capital (%)	23.15	3.32	-0.09	0.68	3.68	6.37	1.97	- -	- -	6.95	3.47	7.34	12.4	10.65	9.32
Return on Invested Capital (%)	7.42	2.29	-0.42	0.92	3.79	6.34	2.46	- -	- -	2.64	3.41	7.4	12.43	10.76	9.22
Gross Margin (%)	24.65	22.47	21.51	21.81	24.18	25.97	24.71	26.09	22.42	24.06	25.02	24	27.56	28.36	24.73
EBITDA Margin (%)	8.24	5.36	3.65	3.12	4.58	6.4	3.88	5.76	3.49	4.39	5.12	6.88	9.4	9.7	8.44
Operating Margin (%)	5.56	2.45	1.08	1.04	2.52	4.33	1.39	2.77	0.38	1.55	2.55	4.66	7.46	7.57	6.25
Incremental Operating Margin (%)	36.43	38.71	-28.62	0.43	55.18	43.25	-101.69	45.89	62.57	-15.04	32.91	9.43	37.87	5.54	0.28
Pretax Margin (%)	5.51	2.31	0.22	0.76	2.44	4.35	0.93	-6.82	-6.77	3.83	2.51	4.19	6.71	7.05	5.76
Profit Margin (%)	3.69	1.2	-0.04	0.31	1.67	2.94	0.91	-5.71	-4.97	3.14	1.86	3.3	5.18	5.32	4.25
Net Income to Common Margin (%)	3.69	1.2	-0.04	0.31	1.67	2.94	0.91	-5.71	-4.97	3.14	1.86	3.3	5.18	5.32	4.25
Effective Tax Rate (%)	33.02	47.92	120	58.98	31.45	32.29	2.6	- -	- -	17.97	25.87	21.24	22.7	24.54	26.2
Dvd Payout Ratio (%)	44.41	171.5	-7,030.89	621.51	56.3	44.44	168.27	-26.38	-31.73	55	90.12	35.4	21.11	22.97	24.48
Sustainable Growth Rate (%)	12.73	-2.31	-6.03	-3.46	1.6	3.53	-1.3	-16.51	-16.61	3.51	0.45	6.96	12.51	10.09	8.48

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	- -	- -	- -	- -	- -	- -	50	45	40	11	82	91	46	72	67
ST Debt	- -	- -	- -	- -	- -	- -	- -	- -	- -	1	2	8	7	9	10
LT Debt	- -	- -	- -	- -	- -	- -	50	45	40	11	81	83	39	63	57
Total Debt/EBITDA	- -	- -	- -	- -	- -	- -	3.86	2.3	3.45	0.85	5.09	2.89	0.98	1.58	1.38
Net Debt/EBITDA	-0.17	-1.06	-0.78	-0.96	-1.87	-1.64	3.63	2.14	3.36	-0.26	4.08	2.46	0.71	1.1	0.93
Total Debt/EBIT	- -	- -	- -	- -	- -	- -	10.79	4.78	31.81	2.4	10.21	4.27	1.24	2.03	1.86
Net Debt/EBIT	-0.25	-2.32	-2.61	-2.89	-3.41	-2.42	10.13	4.45	31.03	-0.74	8.18	3.64	0.9	1.41	1.26
EBITDA to Interest Expense	134.34	87.24	165.16	137.49	313.02	573.14	20.75	11.46	5.03	15.35	56.34	15.92	12.67	21.13	15.47
EBITDA-CapEx/Interest Expense	108.06	66.41	43.05	60.35	207.38	289.5	10.05	9.48	3.88	12.21	48.56	14.84	11.8	18.63	14.37
EBIT to Interest Expense	90.58	39.93	49.08	45.93	172.33	387.67	7.43	5.52	0.55	5.44	28.07	10.78	10.05	16.49	11.46
Interest Expense	- -	- -	- -	- -	- -	- -	1	2	2	1	- -	2	4	2	3
Common Equity/Total Assets	28.56	85.24	83.75	81.47	79.11	79.53	62.29	60.66	59.63	73.02	45.72	47.49	59.85	58.53	58
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	31.05	32.57	32.97	8.57	61.44	56.2	21.7	30.61	24.72
Long-Term Debt/Capital (%)	- -	- -	- -	- -	- -	- -	23.71	24.57	24.8	7.86	37.76	34.84	17.27	22.65	19.23
Long-Term Debt/Total Assets (%)	- -	- -	- -	- -	- -	- -	19.36	19.76	19.66	6.26	28.1	26.7	13.01	17.94	14.39
Total Debt/Equity (%)	0.02	- -	- -	- -	- -	- -	31.05	32.57	32.97	9.06	62.72	61.33	25.88	35.24	28.88
Total Debt/Capital (%)	0.07	- -	- -	- -	- -	- -	23.71	24.57	24.8	8.3	38.56	38.02	20.59	26.08	22.47
Total Debt/Total Assets (%)	0.02	- -	- -	- -	- -	- -	19.36	19.76	19.66	6.61	28.69	29.13	15.52	20.65	16.81
Net Debt to Equity	-2.66	-10.21	-5.61	-6.51	-18.47	-21.76	29.15	30.29	32.16	-2.8	50.24	52.2	18.79	24.53	19.55
Net Debt/Capital (%)	-8.69	-11.37	-5.94	-6.97	-22.66	-27.81	22.59	23.25	24.34	-2.63	31.21	32.7	15.07	18.42	15.39
EBITDA	24	14	10	9	14	21	13	20	11	13	16	31	47	46	48
EBITDA-CapEx	19	11	3	4	9	10	6	16	9	11	14	29	44	40	45
Operating Income (Loss)	16	7	3	3	8	14	5	9	1	5	8	21	37	36	36

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	0.19	0.67	0.3	0.31	0.72	0.86	0.07	0.08	0.02	0.1	0.03	0.03	0.02	0.05	0.04
Current Ratio	4.92	4.65	3.93	3.62	3.19	3.26	2.36	2.61	2.78	2.48	1.76	2.06	1.96	2.05	1.99
Quick Ratio	2.36	2.61	2.11	1.83	1.9	2.06	1.16	1.32	1.42	1.27	0.86	1.05	1.08	1.08	1.11
CFO/Avg Current Liab	-0.16	1.09	0.36	0.42	0.63	0.48	0.5	0.26	0.28	0.8	0.53	-0.05	0.65	0.56	0.43
Common Equity/Total Assets	28.56	85.24	83.75	81.47	79.11	79.53	62.29	60.66	59.63	73.02	45.72	47.49	59.85	58.53	58
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	31.05	32.57	32.97	8.57	61.44	56.2	21.7	30.61	24.72
Long-Term Debt/Capital (%)	- -	- -	- -	- -	- -	- -	23.71	24.57	24.8	7.86	37.76	34.84	17.27	22.65	19.23
Long-Term Debt/Total Assets (%)	- -	- -	- -	- -	- -	- -	19.36	19.76	19.66	6.26	28.1	26.7	13.01	17.94	14.39
Total Debt/Equity (%)	0.02	- -	- -	- -	- -	- -	31.05	32.57	32.97	9.06	62.72	61.33	25.88	35.24	28.88
Total Debt/Capital (%)	0.07	- -	- -	- -	- -	- -	23.71	24.57	24.8	8.3	38.56	38.02	20.59	26.08	22.47
Total Debt/Total Assets (%)	0.02	- -	- -	- -	- -	- -	19.36	19.76	19.66	6.61	28.69	29.13	15.52	20.65	16.81
CFO/Total Liabilities	-15.34	94.21	32.19	36.72	55.46	45.27	22	12.74	14.16	63.81	17.99	-2.37	41.82	30.04	23.01
CFO/CapEx	-0.8	7.09	1.17	2.2	4.4	1.78	3.2	3.38	4.39	10.85	12.54	-1.82	15.46	8.05	11
Altman's Z-Score	8.06	7.04	7.21	6.67	6.57	7.12	4.38	3.83	3.3	5.07	3.2	3.82	5.76	5.21	5.39

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	7.32	6.01	6.21	6.75	7.13	7.11	6.91	6.88	6.24	6.6	6.61	6.72	6.39	6.01	6.27
Days Sales Outstanding	49.89	60.78	58.76	54.08	51.23	51.34	52.79	53.09	58.46	55.29	55.23	54.31	57.08	60.74	58.24
Inventory Turnover	4.89	4.54	5.29	5.35	5.28	5.47	5.3	5.01	5.4	5.64	4.84	5.19	5.21	5	5.73
Days Inventory Outstanding	74.58	80.31	69.04	68.2	69.19	66.74	68.86	72.92	67.6	64.7	75.34	70.36	70.02	73.02	63.74
Accounts Payable Turnover	20.92	18.89	18.48	18.21	16.29	16.75	15.36	13.61	13.54	13.82	10.88	10.67	10.92	11.19	10.91
Accounts Payable Turnover Days	17.45	19.33	19.75	20.05	22.41	21.8	23.76	26.81	26.96	26.4	33.54	34.22	33.43	32.6	33.44
Cash Conversion Cycle	107.02	121.77	108.04	102.23	98	96.28	97.89	99.19	99.09	93.59	97.04	90.45	93.67	101.16	88.53
Inventory to Cash Days	-24.7	-19.53	-10.28	-14.11	-17.96	-15.4	-16.07	-19.83	-9.14	-9.42	-20.11	-16.05	-12.95	-12.28	-5.5
Inventories	50	41	42	45	43	44	50	51	44	39	59	74	64	71	80
Raw Materials	32	26	28	30	28	29	32	32	28	27	41	52	48	53	61
Work In Process	6	7	5	5	5	4	4	4	2	2	5	3	3	6	8
Finished Goods	12	9	9	10	11	11	14	15	13	10	14	20	13	12	11
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	193	173	197	195	229	277	226	138	95	170	214	168	353	420	509
- Cash & Cash Equivalents	4	15	8	9	26	34	3	3	1	4	2	2	2	4	3
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	- -	- -	- -	50	45	40	11	82	91	46	72	67
Enterprise Value	189	158	189	186	202	243	273	180	134	178	294	257	397	488	572
Total Capital	50	149	142	138	143	156	210	185	159	137	213	238	223	276	297
Total Debt/Capital (%)	0.07	- -	- -	- -	- -	- -	23.71	24.57	24.8	8.3	38.56	38.02	20.59	26.08	22.47
Total Debt / EV	- -	- -	- -	- -	- -	- -	0.18	0.25	0.3	0.06	0.28	0.35	0.12	0.15	0.12
EV/Sales	0.64	0.59	0.67	0.62	0.66	0.75	0.82	0.53	0.41	0.58	0.93	0.56	0.8	1.04	1
EV/EBITDA	7.81	10.96	18.43	19.85	14.37	11.77	21.21	9.15	11.68	13.27	18.17	8.19	8.5	10.72	11.81
EV/EBIT	11.58	23.94	62.03	59.43	26.1	17.4	59.26	19.01	107.7	37.47	36.47	12.09	10.72	13.73	15.95
EV/Cash Flow to Firm	- -	6.45	21.36	16.02	9.66	13.38	12.49	13.93	10.17	5.85	10.41	- -	7.58	10.85	14.14
EV/Free Cash Flow to Firm	180.59	5.66	11.5	11.03	7.87	8.56	9.58	11.03	8.48	5.36	9.65	- -	7.14	9.69	13.03
Diluted Market Cap	193	173	197	196	230	283	226	138	95	171	220	173	368	435	524
Diluted Enterprise Value	189	158	189	187	204	249	273	180	134	179	300	261	412	503	588
EV per Share	7.77	6.49	7.76	7.61	8.26	9.72	10.92	6.97	5.13	6.77	11.01	9.4	14.13	16.81	19.12
TTM Sales	294	268	281	299	308	322	331	342	329	306	316	455	497	470	573
TTM EBITDA	24	14	10	9	14	21	13	20	11	13	16	31	47	46	48
TTM Operating Income	16	7	3	3	8	14	5	9	1	5	8	21	37	36	36
TTM Cash Flow to Firm	-4	24	9	12	21	18	22	13	13	30	28	-2	52	45	40
TTM Free Cash Flow to Firm	1	28	16	17	26	28	28	16	16	33	30	- -	56	50	44

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	208.92	6.24	12.01	11.66	8.96	10	8.11	9.27	6.75	5.28	7.27	-99.21	6.97	8.92	12.61
EV/EBIT	11.58	23.94	62.03	59.43	26.1	17.4	59.26	19.01	107.7	37.47	36.47	12.09	10.72	13.73	15.95
Enterprise Value	189	158	189	186	202	243	273	180	134	178	294	257	397	488	572
Low Price	4.69	5.45	6.1	6.65	5.61	7.89	8.12	4.91	2.48	2.5	5.33	5.41	5.5	11.44	13.63
EV/Sales	0.64	0.59	0.67	0.62	0.66	0.75	0.82	0.53	0.41	0.58	0.93	0.56	0.8	1.04	1
EV/EBITDA	7.81	10.96	18.43	19.85	14.37	11.77	21.21	9.15	11.68	13.27	18.17	8.19	8.5	10.72	11.81
Price/Earnings	17.81	53.66	- -	209.26	44.42	29.17	75.42	- -	- -	17.72	36.44	11.2	13.71	16.83	20.86
Price/Earnings Average	16.35	51.47	-1,396.3	215.8	35.84	28.33	81.85	-9.13	-6.33	14.54	36.16	12.83	11.79	16.68	21.16
Price/Earnings High	21.56	67.15	-1,672.26	253.58	48.7	35.44	97	-12.27	-9.09	20	51.04	15.56	17.47	19.74	31.27
Price/Earnings Low	10.52	41.07	-1,205.77	174.39	26.68	20.79	67.67	-6.5	-3.96	6.85	24.24	9.82	6	13.31	16.72
Price/Book Value	3.84	1.16	1.39	1.41	1.6	1.78	1.42	0.99	0.79	1.35	1.63	1.14	1.99	2.06	2.21
Price/Book Value Average	3.52	1.11	1.21	1.45	1.29	1.73	1.54	1.28	0.86	1.11	1.62	1.31	1.71	2.04	2.24
Price/Book Value High	4.64	1.45	1.45	1.7	1.75	2.16	1.82	1.72	1.24	1.52	2.28	1.58	2.54	2.41	3.32
Price/Book Value Low	2.27	0.89	1.05	1.17	0.96	1.27	1.27	0.91	0.54	0.52	1.09	1	0.87	1.63	1.77
Price/Tangible Book Value	1.51	1.38	1.6	1.61	1.81	1.98	3.57	1.88	1.24	1.99	14.64	4.84	5.09	5.75	5.79
Price/Tangible Book Value Average	1.38	1.32	1.4	1.66	1.46	1.93	3.87	2.43	1.34	1.63	14.52	5.54	4.38	5.7	5.87
Price/Tangible Book Value High	1.82	1.73	1.68	1.95	1.99	2.41	4.59	3.27	1.93	2.25	20.5	6.72	6.49	6.75	8.67
Price/Tangible Book Value Low	0.89	1.06	1.21	1.34	1.09	1.41	3.2	1.73	0.84	0.77	9.74	4.24	2.23	4.55	4.64
Price/Sales	0.66	0.64	0.7	0.65	0.74	0.86	0.68	0.4	0.29	0.56	0.68	0.37	0.71	0.9	0.89
Price/Sales Average	0.6	0.62	0.61	0.67	0.6	0.83	0.74	0.52	0.31	0.46	0.67	0.42	0.61	0.89	0.9
Price/Sales High	0.8	0.81	0.73	0.79	0.81	1.04	0.88	0.7	0.45	0.63	0.95	0.51	0.91	1.05	1.33
Price/Sales Low	0.39	0.49	0.53	0.54	0.45	0.61	0.61	0.37	0.2	0.21	0.45	0.32	0.31	0.71	0.71
Price/Cash Flow	-50.67	7.1	22.23	16.84	10.93	15.26	10.65	12.01	8.29	5.72	7.63	-43.58	7.12	9.69	13.34
Price/Cash Flow Average	-46.52	6.81	19.41	17.36	8.82	14.82	11.56	15.51	9	4.69	7.58	-49.91	6.12	9.6	13.54
Price/Cash Flow High	-61.32	8.89	23.24	20.4	11.98	18.54	13.69	20.85	12.93	6.46	10.69	-60.53	9.08	11.36	20
Price/Cash Flow Low	-29.93	5.44	16.76	14.03	6.57	10.88	9.55	11.04	5.63	2.21	5.08	-38.21	3.12	7.66	10.69
Price/Free Cash Flow Average	191.81	5.98	10.49	12.02	7.23	9.71	8.81	11.96	7.33	4.33	7.21	-113.62	5.99	8.84	12.79
Price/Free Cash Flow High	252.86	7.81	12.56	14.13	9.82	12.15	10.44	16.09	10.53	5.96	10.18	-137.79	8.88	10.46	18.91
Price/Free Cash Flow Low	123.41	4.77	9.06	9.71	5.38	7.13	7.28	8.52	4.59	2.04	4.84	-86.99	3.05	7.05	10.11
EV/Sales Average	0.59	0.56	0.58	0.64	0.51	0.73	0.88	0.64	0.43	0.48	0.93	0.62	0.7	1.03	1.01
EV/Sales High	0.78	0.75	0.7	0.76	0.73	0.94	1.02	0.82	0.57	0.65	1.2	0.71	0.99	1.19	1.44
EV/Sales Low	0.37	0.44	0.5	0.51	0.36	0.51	0.75	0.49	0.31	0.24	0.7	0.52	0.4	0.85	0.82
EV/EBITDA Average	7.16	10.47	16	20.5	11.23	11.38	22.71	11.19	12.39	11	18.07	8.97	7.44	10.64	11.96
EV/EBITDA High	9.49	13.98	19.31	24.26	15.93	14.65	26.24	14.31	16.32	14.9	23.47	10.28	10.58	12.31	17.05
EV/EBITDA Low	4.54	8.14	13.71	16.38	7.88	7.92	19.4	8.59	9.01	5.49	13.75	7.53	4.26	8.79	9.72
EV/EBIT Average	10.61	22.87	53.83	61.38	20.4	16.82	63.45	23.25	114.23	31.04	36.27	13.25	9.38	13.63	16.16
EV/EBIT High	14.07	30.54	64.98	72.63	28.94	21.66	73.32	29.73	150.55	42.06	47.11	15.18	13.33	15.78	23.04
EV/EBIT Low	6.74	17.78	46.13	49.04	14.32	11.7	54.21	17.84	83.13	15.5	27.59	11.12	5.36	11.26	13.13
Last Price	7.94	7.12	8.09	7.98	9.34	11.07	9.05	5.34	3.65	6.47	8.01	6.17	12.56	14.47	17.01
High Price	9.61	8.91	8.46	9.67	10.24	13.45	11.64	9.27	5.69	7.3	11.22	8.57	16	16.97	25.5
Enterprise Value Average	173	151	164	192	158	235	292	220	142	147	292	281	348	484	579
Enterprise Value High	229	201	198	227	224	302	338	282	187	200	379	322	494	561	826
Enterprise Value Low	110	117	140	153	111	163	250	169	103	74	222	236	199	400	471

	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	24	24	24	24	24	25	25	26	26	26	27	27	28	29	30
Diluted Weighted Avg Shares	24	24	24	25	25	26	25	26	26	26	27	28	29	30	31
Basic Weighted Avg Shares	24	24	24	24	24	25	25	26	26	26	27	27	28	29	30
Revenue per Share	12.08	11.05	11.55	12.28	12.57	12.89	13.26	13.22	12.6	11.63	11.82	16.68	17.67	16.17	19.17
EBITDA per Share	1	0.59	0.42	0.38	0.58	0.83	0.51	0.76	0.44	0.51	0.61	1.15	1.66	1.57	1.62
Operating Income per Share	0.67	0.27	0.13	0.13	0.32	0.56	0.18	0.37	0.05	0.18	0.3	0.78	1.32	1.22	1.2
Basic EPS, GAAP	0.45	0.13	-0.01	0.04	0.21	0.38	0.12	-0.76	-0.63	0.37	0.22	0.55	0.92	0.86	0.82
Basic EPS from Cont Ops	0.45	0.13	-0.01	0.04	0.21	0.38	0.12	-0.76	-0.63	0.37	0.22	0.55	0.92	0.86	0.82
Diluted EPS, GAAP	0.44	0.13	-0.01	0.04	0.21	0.37	0.12	-0.76	-0.63	0.36	0.21	0.54	0.88	0.83	0.79
Diluted EPS from Cont Ops	0.44	0.13	-0.01	0.04	0.21	0.37	0.12	-0.76	-0.63	0.36	0.21	0.54	0.88	0.83	0.79
Dividend per Share	0.2	0.23	0.36	0.24	0.12	0.17	0.2	0.2	0.2	0.2	0.2	0.2	0.19	0.2	0.2
Cash Flow per Share	-0.16	1	0.36	0.47	0.85	0.73	0.85	0.44	0.44	1.13	1.05	-0.14	1.76	1.49	1.27
Free Cash Flow per Basic Share	-0.35	0.86	0.05	0.26	0.66	0.32	0.58	0.31	0.34	1.03	0.97	-0.22	1.65	1.31	1.16
Cash & Equivalents per Share	0.17	0.63	0.33	0.37	1.08	1.35	0.12	0.12	0.04	0.13	0.09	0.09	0.06	0.14	0.12
Book Value per Share	2.07	6.15	5.83	5.68	5.84	6.22	6.4	5.38	4.59	4.79	4.91	5.41	6.3	7.03	7.69
Tangible Book Value per Share	5.27	5.16	5.04	4.95	5.16	5.58	2.53	2.83	2.95	3.25	0.55	1.27	2.47	2.51	2.94

LSI Industries Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)