AstroNova, Inc. Financial Ratios — ALOT Stock

Profitability (USD)

	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	2026 Y
Return on Common Equity (%)	11.26	33.17	8.66	11.97	10.92	9.66	7.22	11.91	3.52	2.56	11.94	4.56	7.56	-25.34	-4.87
Return on Assets (%)	4.74	14.65	4.07	6.12	5.94	5.23	3.19	4.75	1.49	1.11	5.58	2.09	3.45	-10.39	-1.68
Return on Capital (%)	- -	33.17	8.63	11.93	10.92	9.66	6.2	9.24	- -	2.64	10.35	5.03	7.64	- -	- -
Return on Invested Capital (%)	- -	3.36	1.99	7.45	5.96	5.79	4.34	7.75	- -	1.55	4.23	4.11	5.96	- -	- -
Gross Margin (%)	36.35	38.76	39.34	41.85	40.31	40.11	38.8	39.51	36.54	35.65	37.23	33.79	33.43	33.49	31.65
EBITDA Margin (%)	4.26	6.95	4.1	10.52	8.45	8.85	8.29	10.88	6.53	7.25	7.02	6.57	8.82	6.31	4.19
Operating Margin (%)	1.66	4.78	2.23	8.18	6.27	6.38	4.77	6.38	1.82	2.1	3.62	3.82	5.94	3.15	1
Incremental Operating Margin (%)	16	383.4	-18.91	28.84	-20.55	9.16	-5.81	14.22	195.8	- -	125.98	4.74	60.32	-126.15	424.48
Pretax Margin (%)	1.06	4.71	2.06	7.85	7.3	6.71	4.55	5.35	1.03	1.88	5.99	2.39	4.1	-8.12	-1.68
Profit Margin (%)	5.16	17.59	4.68	5.28	4.78	4.29	2.9	4.19	1.32	1.11	5.47	1.87	3.17	-9.58	-1.58
Net Income to Common Margin (%)	5.16	17.59	4.68	5.28	4.78	4.29	2.9	4.19	1.32	1.11	5.47	1.87	3.17	-9.58	-1.58
Effective Tax Rate (%)	- -	29.36	12.39	32.75	34.51	35.99	36.28	21.59	- -	41.07	8.6	21.96	22.71	- -	- -
Dvd Payout Ratio (%)	277.33	127.33	170.01	45.65	45.26	49.24	59.16	33.73	112.11	38.71	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	-19.96	-9.07	-6.06	6.51	5.98	4.9	2.95	7.89	-0.43	1.57	11.94	4.56	7.56	-25.34	-4.87

Credit (USD)

API Chat

	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	2026 Y
Total Debt	- -	- -	- -	- -	- -	- -	23	20	21	18	10	31	22	49	40
ST Debt	- -	- -	- -	- -	- -	- -	5	7	12	6	1	18	12	28	20
LT Debt	- -	- -	- -	- -	- -	- -	18	13	9	13	9	13	10	21	20
Total Debt/EBITDA	- -	- -	0.09	- -	- -	- -	2.46	1.32	2.42	2.17	1.25	3.3	1.72	5.08	6.36
Net Debt/EBITDA	-4.53	-7.28	-2.88	-0.86	-1.26	-2.08	1.38	0.81	1.74	0.64	0.47	2.79	1.32	4.36	5.32
Total Debt/EBIT	- -	- -	0.16	- -	- -	- -	4.28	2.25	8.68	7.52	2.42	5.67	2.55	10.19	26.71
Net Debt/EBIT	-11.6	-10.59	-5.28	-1.1	-1.69	-2.88	2.4	1.38	6.24	2.23	0.91	4.79	1.96	8.74	22.31
EBITDA to Interest Expense	- -	- -	- -	- -	- -	- -	23.4	16.98	12.78	8.81	12.19	5.58	4.84	2.97	1.8
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	- -	17.92	13.96	8.52	6.1	9.53	5.44	4.52	2.61	1.71
EBIT to Interest Expense	- -	- -	- -	- -	- -	- -	13.46	9.95	3.57	2.55	6.29	3.24	3.26	1.48	0.43
Interest Expense	- -	- -	- -	- -	- -	- -	- -	1	1	1	1	2	3	3	4
Common Equity/Total Assets	42.3	45.73	48.31	54.1	54.76	53.61	37.77	42.04	42.7	43.82	49.62	42.89	48.34	34.29	34.57
Long-Term Debt/Equity (%)	- -	- -	0.38	- -	- -	- -	27.73	18.45	12.6	16.87	11.06	14.93	11.59	27.17	26.34
Long-Term Debt/Capital (%)	- -	- -	0.66	- -	- -	- -	25.45	18.49	12.68	18.28	13.31	13.9	12.05	20.9	23.09
Long-Term Debt/Total Assets (%)	- -	- -	0.32	- -	- -	- -	14.43	10.82	7.71	10.91	7.8	9.05	7.85	14.13	14.72
Total Debt/Equity (%)	- -	- -	0.38	- -	- -	- -	36.37	28.06	29.59	24.5	12.7	36.59	24.86	64.05	52.22
Total Debt/Capital (%)	- -	- -	0.66	- -	- -	- -	33.38	28.13	29.77	26.55	15.28	34.08	25.84	49.28	45.77
Total Debt/Total Assets (%)	- -	- -	0.32	- -	- -	- -	18.92	16.45	18.1	15.84	8.95	22.18	16.84	33.32	29.18
Net Debt to Equity	-21.03	-48.56	-12.15	-12.53	-14.91	-25.66	20.38	17.26	21.26	7.25	4.79	30.93	19.12	54.94	43.62
Net Debt/Capital (%)	-70.24	-559.04	-27.36	-24.67	-30.76	-67.65	21.92	19.41	22.76	9.43	6.25	30.12	20.97	44.56	40.09
EBITDA	3	4	3	9	8	9	9	15	9	8	8	9	13	10	6
EBITDA-CapEx	1	3	2	7	5	7	7	12	6	6	6	9	12	8	6
Operating Income (Loss)	1	3	2	7	6	6	5	9	2	2	4	5	9	5	2

Liquidity (USD)

API Chat

	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	2026 Y
Cash Ratio	2.79	2.92	2.74	2.42	2.14	2.07	0.45	0.31	0.16	0.55	0.26	0.11	0.15	0.11	0.11
Current Ratio	6.34	5.18	6.57	6.2	5.71	5.12	2.43	2.54	2.25	2.9	3.18	2.13	2.58	1.68	1.84
Quick Ratio	3.91	3.66	3.94	3.94	3.74	3.38	1.32	1.26	0.9	1.38	1.27	0.68	0.93	0.57	0.6
CFO/Avg Current Liab	0.69	0.35	-0.38	0.15	0.81	0.65	0.2	0.2	0.13	0.65	0.07	-0.1	0.37	0.13	0.28
Common Equity/Total Assets	42.3	45.73	48.31	54.1	54.76	53.61	37.77	42.04	42.7	43.82	49.62	42.89	48.34	34.29	34.57
Long-Term Debt/Equity (%)	- -	- -	0.38	- -	- -	- -	27.73	18.45	12.6	16.87	11.06	14.93	11.59	27.17	26.34
Long-Term Debt/Capital (%)	- -	- -	0.66	- -	- -	- -	25.45	18.49	12.68	18.28	13.31	13.9	12.05	20.9	23.09
Long-Term Debt/Total Assets (%)	- -	- -	0.32	- -	- -	- -	14.43	10.82	7.71	10.91	7.8	9.05	7.85	14.13	14.72
Total Debt/Equity (%)	- -	- -	0.38	- -	- -	- -	36.37	28.06	29.59	24.5	12.7	36.59	24.86	64.05	52.22
Total Debt/Capital (%)	- -	- -	0.66	- -	- -	- -	33.38	28.13	29.77	26.55	15.28	34.08	25.84	49.28	45.77
Total Debt/Total Assets (%)	- -	- -	0.32	- -	- -	- -	18.92	16.45	18.1	15.84	8.95	22.18	16.84	33.32	29.18
CFO/Total Liabilities	48	24.03	-39.31	13.78	72.97	52.96	6.35	10.17	7.12	38.11	4.11	-5.35	28.75	6.94	19.34
CFO/CapEx	4.74	4.55	-3.96	0.66	2.52	5.62	1.69	1.89	1.11	6.01	0.78	-12.82	14.12	4.16	35.36
Altman's Z-Score	5.46	5.15	8	9.53	9.85	7.96	4.12	5.32	4.32	4.1	4.9	3.91	5.06	3.34	2.64

Working Capital (USD)

API Chat

	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	2026 Y
Accounts Receivable Turnover	5.94	6.54	6.61	6.94	6.43	6.35	5.95	5.96	6.17	6.24	6.8	7.36	6.63	6.83	7.49
Days Sales Outstanding	61.46	55.79	55.19	52.62	56.74	57.52	61.32	61.28	59.18	58.51	53.65	49.58	55.03	53.41	48.75
Inventory Turnover	3.09	3.44	3.16	3.34	3.71	3.43	2.95	2.86	2.64	2.33	2.28	2.2	2.02	2.13	2.26
Days Inventory Outstanding	118.24	106.19	115.6	109.28	98.43	106.47	123.9	127.55	138.1	156.38	160.05	166.18	180.86	170.97	161.68
Accounts Payable Turnover	13.87	18.03	21.15	18.73	17.59	15.6	9.25	9.59	17.07	13.96	10.93	13.02	11.32	12.77	13.34
Accounts Payable Turnover Days	26.31	20.25	17.25	19.49	20.76	23.39	39.48	38.05	21.39	26.14	33.39	28.04	32.25	28.58	27.37
Cash Conversion Cycle	153.39	141.73	153.54	142.41	134.42	140.59	145.74	150.78	175.89	188.74	180.31	187.72	203.64	195.8	183.06
Inventory to Cash Days	-56.78	-50.41	-60.42	-56.66	-41.68	-48.95	-62.58	-66.27	-78.93	-97.87	-106.39	-116.6	-125.83	-117.56	-112.94
Inventories	11	11	15	16	15	20	28	30	34	30	35	51	46	48	43
Raw Materials	7	7	11	11	10	12	14	18	20	20	23	38	39	35	30
Work In Process	1	1	1	1	1	1	1	2	1	2	1	1	1	3	3
Finished Goods	2	6	7	7	7	10	17	16	18	16	20	23	16	20	19
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API Chat

	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	2026 Y
Market Capitalization	59	74	102	114	114	103	93	137	87	76	99	97	131	87	- -
- Cash & Cash Equivalents	12	31	8	8	10	18	10	8	4	11	5	4	5	5	4
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	- -	- -	- -	23	20	21	18	10	31	22	49	40
Enterprise Value	36	34	75	91	94	78	105	150	104	83	104	124	149	131	36
Total Capital	28	37	38	40	43	45	69	70	71	69	67	91	87	98	88
Total Debt/Capital (%)	- -	- -	0.66	- -	- -	- -	33.38	28.13	29.77	26.55	15.28	34.08	25.84	49.28	45.77
Total Debt / EV	- -	- -	- -	- -	- -	- -	0.22	0.13	0.2	0.22	0.1	0.25	0.15	0.37	1.11
EV/Sales	0.59	0.56	1.1	1.03	0.99	0.79	0.92	1.09	0.78	0.72	0.89	0.87	1	0.86	0.24
EV/EBITDA	13.9	8.09	26.74	9.76	11.74	8.96	11.14	10.05	11.96	9.89	12.61	13.22	11.38	13.68	5.72
EV/EBIT	35.61	11.77	49.04	12.54	15.83	12.43	19.36	17.15	42.85	34.21	24.44	22.73	16.9	27.41	24
EV/Cash Flow to Firm	6.57	8.92	- -	60.81	12.16	11.23	26.32	26.27	25.43	5.17	51.69	- -	10.29	15.12	2.4
EV/Free Cash Flow to Firm	5.42	7.31	- -	24.26	8.71	9.53	16.94	17.94	14.88	4.45	27.32	- -	9.71	13.33	2.35
Diluted Market Cap	60	75	105	117	117	105	95	142	90	77	101	98	132	87	- -
Diluted Enterprise Value	48	44	97	109	107	87	108	154	107	84	106	125	150	131	36
EV per Share	4.9	4.66	10.06	11.91	12.89	10.52	15.16	21.73	14.84	11.71	14.44	16.93	20.05	17.39	- -
TTM Sales	61	61	69	88	95	98	113	137	133	116	117	143	148	151	151
TTM EBITDA	3	4	3	9	8	9	9	15	9	8	8	9	13	10	6
TTM Operating Income	1	3	2	7	6	6	5	9	2	2	4	5	9	5	2
TTM Cash Flow to Firm	5	4	-4	1	8	7	4	6	4	16	2	-2	14	9	15
TTM Free Cash Flow to Firm	7	5	-3	4	11	8	6	8	7	19	4	-1	15	10	15

Multiples (USD)

API Chat

	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	2026 Y
Price/Free Cash Flow	9.03	15.88	-31.54	31.33	10.87	12.82	15.98	18.5	14.69	4.25	31.61	-36.09	9.99	14.49	- -
EV/EBIT	35.61	11.77	49.04	12.54	15.83	12.43	19.36	17.15	42.85	34.21	24.44	22.73	16.9	27.41	24
Enterprise Value	36	34	75	91	94	78	105	150	104	83	104	124	149	131	36
Low Price	6.44	7.5	8.74	11.25	12	11.18	11	12.55	12.4	5.29	10.56	10.97	11.63	11	6.96
EV/Sales	0.59	0.56	1.1	1.03	0.99	0.79	0.92	1.09	0.78	0.72	0.89	0.87	1	0.86	0.24
EV/EBITDA	13.9	8.09	26.74	9.76	11.74	8.96	11.14	10.05	11.96	9.89	12.61	13.22	11.38	13.68	5.72
Price/Earnings	18.83	6.87	31.77	24.41	25.27	24.34	28.39	23.99	49.68	59.48	15.4	36.38	27.85	- -	- -
Price/Earnings Average	18.05	5.86	26.76	22.17	22.44	25.59	28.83	22.1	78.77	46.53	16.52	35.07	22.56	-7.93	- -
Price/Earnings High	21.33	7.18	34.49	26.94	25.67	28.8	32.91	28.76	111.64	73.59	20.76	43.88	29.75	-9.46	- -
Price/Earnings Low	15.06	5.15	20.33	18.37	19.33	19.62	23.13	15.07	49.52	29.27	11.83	30.12	18.38	-5.7	- -
Price/Book Value	2.08	2.02	2.71	2.83	2.68	2.29	2.02	2.75	1.75	1.51	1.74	1.62	2.03	1.74	- -
Price/Book Value Average	1.99	1.73	2.28	2.57	2.38	2.41	2.05	2.53	2.78	1.18	1.86	1.56	1.64	2.3	- -
Price/Book Value High	2.35	2.11	2.94	3.12	2.72	2.72	2.34	3.29	3.94	1.87	2.34	1.96	2.17	2.74	- -
Price/Book Value Low	1.66	1.52	1.73	2.13	2.05	1.85	1.65	1.73	1.75	0.74	1.33	1.34	1.34	1.65	- -
Price/Tangible Book Value	1.07	1.17	1.64	1.9	2.01	1.69	5.48	4.95	2.57	1.89	1.99	2	2.3	2.43	- -
Price/Tangible Book Value Average	1.03	1	1.38	1.73	1.79	1.78	5.57	4.56	4.08	1.48	2.14	1.92	1.86	3.2	- -
Price/Tangible Book Value High	1.22	1.23	1.78	2.1	2.04	2	6.36	5.93	5.78	2.34	2.69	2.41	2.46	3.82	- -
Price/Tangible Book Value Low	0.86	0.88	1.05	1.43	1.54	1.37	4.47	3.11	2.56	0.93	1.53	1.65	1.52	2.3	- -
Price/Sales	0.97	1.21	1.49	1.29	1.21	1.05	0.82	1.01	0.65	0.66	0.84	0.68	0.88	0.58	- -
Price/Sales Average	0.93	1.03	1.25	1.17	1.07	1.1	0.84	0.93	1.04	0.51	0.9	0.65	0.72	0.76	- -
Price/Sales High	1.1	1.26	1.62	1.42	1.23	1.24	0.95	1.21	1.47	0.81	1.14	0.82	0.94	0.91	- -
Price/Sales Low	0.78	0.91	0.95	0.97	0.92	0.84	0.67	0.63	0.65	0.32	0.65	0.56	0.58	0.55	- -
Price/Cash Flow	10.78	19.15	-22.87	76.32	14.8	14.8	25.05	27.47	27.1	4.91	71.04	-32.98	10.58	17.97	- -
Price/Cash Flow Average	10.33	16.33	-19.27	69.34	13.14	15.56	25.44	25.3	42.98	3.84	76.17	-31.78	8.57	23.7	- -
Price/Cash Flow High	12.21	20.01	-24.83	84.24	15.03	17.51	29.04	32.93	60.91	6.08	95.73	-39.77	11.3	28.27	- -
Price/Cash Flow Low	8.62	14.36	-14.63	57.43	11.32	11.93	20.41	17.25	27.02	2.42	54.57	-27.3	6.98	17.04	- -
Price/Free Cash Flow Average	8.65	13.54	-26.57	28.46	9.65	13.48	16.22	17.04	23.29	3.32	33.89	-34.79	8.09	19.11	- -
Price/Free Cash Flow High	10.23	16.6	-34.24	34.58	11.04	15.17	18.52	22.18	33.01	5.26	42.6	-43.53	10.67	22.79	- -
Price/Free Cash Flow Low	7.22	11.91	-20.18	23.58	8.31	10.34	13.02	11.62	14.64	2.09	24.28	-29.88	6.59	13.74	- -
EV/Sales Average	0.74	0.52	1.14	1.08	0.97	0.92	0.95	1.01	1.16	0.57	0.95	0.84	0.84	1.05	0.24
EV/Sales High	0.91	0.76	1.5	1.33	1.12	1.05	1.07	1.29	1.6	0.87	1.18	1.01	1.06	1.19	0.24
EV/Sales Low	0.58	0.4	0.83	0.88	0.82	0.66	0.78	0.72	0.78	0.38	0.69	0.75	0.7	0.83	0.24
EV/EBITDA Average	17.34	7.53	27.69	10.27	11.44	10.34	11.45	9.32	17.83	7.91	13.48	12.85	9.48	16.59	5.72
EV/EBITDA High	21.32	10.87	36.52	12.66	13.27	11.9	12.88	11.89	24.46	12.04	16.78	15.35	12.06	18.92	5.72
EV/EBITDA Low	13.72	5.75	20.34	8.36	9.68	7.45	9.46	6.62	11.93	5.28	9.83	11.44	7.98	13.21	5.72
EV/EBIT Average	44.44	10.96	50.8	13.2	15.42	14.34	19.9	15.9	63.88	27.38	26.13	22.09	14.07	33.25	24
EV/EBIT High	54.61	15.82	66.99	16.27	17.88	16.51	22.38	20.28	87.65	41.65	32.53	26.4	17.91	37.9	24
EV/EBIT Low	35.15	8.36	37.31	10.74	13.05	10.33	16.44	11.28	42.73	18.26	19.05	19.67	11.84	26.47	24
Last Price	8.05	10	13.66	14.95	15.69	13.86	13.5	19.98	12.44	10.75	13.74	13.25	17.63	11.6	9.09
High Price	9.12	10.45	14.83	16.5	15.94	16.41	15.65	23.95	27.96	13.3	18.52	15.98	18.83	18.25	12.68
Enterprise Value Average	45	32	78	95	91	90	108	139	155	67	111	120	124	158	36
Enterprise Value High	55	46	103	118	106	104	121	177	213	101	138	144	158	181	36
Enterprise Value Low	35	24	57	78	77	65	89	98	104	44	81	107	104	126	36

	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	2026 Y
Shares Outstanding	7	7	8	7	7	7	7	7	7	7	7	7	7	8	8
Diluted Weighted Avg Shares	7	7	8	8	7	8	7	7	7	7	7	7	7	8	- -
Basic Weighted Avg Shares	7	7	7	8	7	7	7	7	7	7	7	7	7	8	- -
Revenue per Share	8.29	8.28	9.18	11.61	12.99	13.27	16.41	19.86	19	16.33	16.3	19.51	19.97	20.15	- -
EBITDA per Share	0.35	0.58	0.38	1.22	1.1	1.17	1.36	2.16	1.24	1.18	1.14	1.28	1.76	1.27	- -
Operating Income per Share	0.14	0.4	0.21	0.95	0.81	0.85	0.78	1.27	0.35	0.34	0.59	0.74	1.19	0.63	- -
Basic EPS, GAAP	0.43	1.46	0.43	0.61	0.62	0.57	0.48	0.83	0.25	0.18	0.89	0.36	0.63	-1.93	- -
Basic EPS from Cont Ops	0.1	0.28	0.17	0.61	0.62	0.57	0.48	0.83	0.25	0.18	0.89	0.36	0.63	-1.93	- -
Diluted EPS, GAAP	0.42	1.44	0.42	0.6	0.61	0.56	0.47	0.81	0.24	0.18	0.88	0.36	0.63	-1.93	- -
Diluted EPS from Cont Ops	0.1	0.27	0.16	0.6	0.61	0.56	0.47	0.81	0.24	0.18	0.88	0.36	0.63	-1.93	- -
Dividend per Share	0.28	0.35	0.28	0.28	0.28	0.28	0.28	0.28	0.28	0.07	- -	- -	- -	- -	- -
Cash Flow per Share	0.75	0.52	-0.6	0.2	1.06	0.94	0.54	0.73	0.46	2.19	0.19	-0.4	1.67	0.65	- -
Free Cash Flow per Basic Share	0.59	0.41	-0.75	-0.1	0.64	0.77	0.22	0.34	0.05	1.82	-0.06	-0.43	1.55	0.49	- -
Cash & Equivalents per Share	3.15	5.34	3.63	3.04	2.8	3.34	1.69	1.09	0.6	1.61	0.73	0.54	0.61	0.67	- -
Book Value per Share	3.87	4.94	5.04	5.28	5.86	6.04	6.68	7.27	7.09	7.12	7.91	8.17	8.69	6.65	- -
Tangible Book Value per Share	7.49	8.52	8.33	7.86	7.8	8.19	2.46	4.04	4.83	5.68	6.89	6.63	7.66	4.78	- -

AstroNova, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)