reddit-tearsheet-alamogroup-alg-july26

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1
2		1		Ticker	ALG		Alamo Group Inc ALG			End Year	31Dec		Sector	Industrials		Industry	Farm & Heavy Construction Machinery
3									Prev	CFRA FairV		Prev					Small Core		Alamo Group Inc is engaged in the design and manufacturing of agricultural equipment and infrastructure maintenance equipment. Its products include tractor-mounted mowing and other vegetation maintenance equipment, street sweepers, excavators, vacuum trucks, snow removal equipment, leaf collection equipment, pothole patchers, zero-turn radius mowers, agricultural implements, and related aftermarket parts. The company's reportable segments are Vegetation Management and Industrial Equipment. It generates a majority of its revenue from Vegetation Management. Geographically, the company generates majority of the revenue from the United States.	<-Desc
4				Current Price	192.03		M* IV	225.61		CFRA 12m-PX			DateDone	26-Jul		Done Px	192.03		https://www.alamo-group.com/
5				MktCap	2.31	bn	M* Rating	***	Q	CFRA *	***		Sheet Ver	4-May	42				Earning Date	Earning Date
6							5* Px	$180.97			HOLD			Major	Minor				2-May	31-Jul-2024
7	1			1. Data Collection	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	TTM/2024		Avg-10	Avg-5
8			fY	Total Asset Dump		629602000	603503000	552776000	639671000	721633000	1212763000	1109329000	1205742000	1308508000	1409386000	1519420000
9				Current Liabilities Dump		89367000	85024000	78700000	101363000	100852000	162874000	157295000	192564000	190506000	213926000	213362000
10				LT Debt Dump		190024000	144006000	70017000	60000000	85179000	425141000	270320000	254522000	286943000	220269000	306525000
11				Total Equity Dump		337670000	360469000	387717000	449108000	507371000	569757000	625643000	705663000	785360000	932763000	956556000
12				Total Rev Dump		839055000	879577000	844748000	912380000	1008822000	1119138000	1163466000	1334223000	1513616000	1689651000	1703466000		<-ttm
13				EBIT Dump		62664000	66528000	67620000	88738000	101088000	94648000	93165000	116938000	148592000	197967000	195922000
14				Net Income Dump		41151000	43209000	40045000	44315000	73486000	62906000	56630000	80245000	101928000	136161000	134932000		<-ttm
15				Shares Outstanding Dump		12039000	11482000	11565000	11682000	11761000	11800000	11845000	11896000	11934000	11987000	12001500		<-TTM
16
17			fY	Long Term Debt		190	144	70	60	85	425	270	255	287	220	307		<-TTM
18			fY	Total Revenue	682	839	880	845	912	1009	1119	1163	1334	1514	1690	1703		<-TTM
19			fY	Net Income (diluted)		41	43	40	44	73	63	57	80	102	136	135		<-TTM
20			fY	Diluted EPS	2.96	3.42	3.76	3.46	3.79	6.25	5.33	4.78	6.75	8.54	11.36	11.24		<-TTM
21			fY	Shares Outstanding		12	11	12	12	12	12	12	12	12	12	12		<-TTM
22			calc	Shares Growth / Shrink	Begin	12	End	12			Change	-0.31%
23
24	2			2. Data Collection	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	Current		Avg-10	Avg-5		Pre-Pandemic	Ori-Avg10	Ori-Avg5
25			cy	P/S		0.76	0.68	1.02	1.50	0.91	1.38	1.39	1.36	1.15	1.52	1.35		1.18	1.36	<-P/S	1.04
26			cy	P/E		16.59	13.86	20.03	27.07	15.13	21.17	28.10	25.33	18.34	18.82	17.08		20.14	21.47	<-P/E	18.98
27			cy	P/Book		1.62	1.68	2.25	2.92	1.81	2.68	2.69	2.53	2.29	2.83	2.41		2.34	2.57	<-P/B	2.16
28			cy	P/E FWD		––	––	––	––	––	––	––	––	––	––	––
29			cy	PEG		0.51	1.37	2.08	2.90	1.20	1.39	5.13	2.86	1.40	1.11	1.40		1.94	2.22	<-PEG	1.58
30			cy	EV/EBITDA		10.40	7.95	10.00	13.88	8.06	12.46	13.87	13.02	11.19	11.13	10.14		11.10	11.97	<- EV/EBITDA	10.46
31			-	Current		P/B	2.40		P/S	1.35		P/E	17.08		As of Jul 25, 2024
32												Normalized	17.19
33			-	Debt Ratios		Quick Ratio	2.41		Current Ratio	4.29	Interest Coverage		7.57		Debt/Eq	0.34		Debt/NI	2.27	years
34
35			calc	LT Debt/Net Income		4.62	3.33	1.75	1.35	1.16	6.76	4.77	3.17	2.82	1.62	2.27	<<- How many years of NI is the debt
36
37			fY	Growth	8-10 yr		5 yrs		3 yrs		1 yr		CAGR	Pre 2014-2019		Post 2020-TTM			Additional	2011	2012	2013
38			fY	Revenue, Smoothing	9.58	8.58%	10.87	10.05%	13.24	10.70%	11.63		Rev, Smoothing	5.93%	5.86%	10.85%	9.41%		Revenue	604	633	682
39
40				EPS, Smoothing	14.40	13.50%	12.69	15.17%	33.45	22.69%	33.02		EPS, Smoothing	9.28%	11.37%	20.83%	19.71%		EPS	2.73	2.40	2.96
41
42				Using Actuals as the centre									Covid
43
44	3			3. Data Collection	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	TTM/2024	TTM	Avg-10	Avg-5		Pre-Pandemic	Ori-Avg10	Ori-Avg5
45			fY	Gross Margin		22.55	23.02	24.28	25.72	25.39	24.41	25.11	25.07	24.88	26.85	26.58	<- Current			Gross	24.23
46			fY	Operating Margin		7.47	7.56	8.00	9.73	10.02	8.46	8.01	8.76	9.82	11.72	11.50	<- Current			Operating	8.54
47			fY	Net Margin		4.90	4.91	4.74	4.86	7.28	5.62	4.87	6.01	6.73	8.06	7.92	<- Current			Net Margin	5.39
48
49			fY	ROA		7.71	7.01	6.93	7.43	10.80	6.50	4.88	6.93	8.11	10.02	9.15	<- Current	7.77	7.60	ROA	7.73
50			fY	ROE		11.96	12.38	10.70	10.59	15.37	11.68	9.47	12.06	13.67	15.85	15.17	<- Current	12.63	12.98	ROE	12.11
51			fY	ROIC		9.95	9.18	9.08	9.72	14.06	8.72	6.97	9.22	10.84	13.71	12.46	<- Current	10.36	10.32	ROIC	10.12
52				ROCE via Asset EBIT/(TA-CL)		11.60	12.83	14.26	16.48	16.28	9.02	9.79	11.54	13.29	16.56	15.00		13.33	12.53	ROCE 1	13.41
53
54																				10 yr	with Smooth	5 yr	with Smooth	3 yr	with Smooth	yoy
55			fY	Book Value per Share		29.96	31.20	33.81	38.57	42.61	47.22	51.25	58.25	61.59	74.20	77.76			BV, Smoothing	10.60%	9.84%	11.73%	10.71%	13.13%	10.86%	20.47%
56			fY	FCF per share		2.34	2.35	4.65	4.89	0.84	2.22	12.99	6.24	-4.12	6.51	7.79			FCF, Smoothing	12.04%	4.19%	50.61%	5.07%	-20.57%	-22.00%	-258.01%
57				FCF/SALES %		2.43	4.22	7.79	6.28	-1.37	5.13	14.31	1.83	-1.11	5.53	5.62		4.61	5.22	FCF/SALES %	4.08
58			fY	EBITDA (M)		77.29	95.69	88.90	107.67	123.14	125.05	137.81	164.51	195.36	249.19	248.21
59
60			calc	Dividend Growth	Begin	0.28	End	1.04	Period	10.00	CAGR%	14.02%			2023	Current		10yr	5 year
61				Dividend Yield		0.58	0.61	0.47	0.35	0.57	0.38	0.38	0.38	0.51	0.42	0.52		0.47	0.43
62				Buy Yield		6.16	0.00	0.00	0.00	0.00	0.49	0.04	0.11	0.04	0.04	0.08		0.63	0.13
63			calc	Total Yield		6.74	0.61	0.47	0.35	0.57	0.87	0.42	0.49	0.55	0.46	0.60		1.10	0.57
64				Payout Ratio		8.19	8.51	10.40	10.55	7.04	9.01	10.88	8.30	8.43	7.75	8.19		8.841	8.514
65
66	4			4. Level I Estimates of Growth, Multiples and EPS
67
68					EPS Y!	This Q	Next Q	This Y	Next Y		RevGrowth Y!	This	Next			EPS Growth Y!		Industry	Sector	S&P
69					No. of Analysts	5	5	5	5			3.40%	5.00%			Current Qtr.	-10.20%	--	--	7.80%
70					Avg. Estimate	2.72	2.92	11.36	12.89							Next Qtr.	0.30%	--	--	11.30%
71					Low Estimate	2.64	2.68	10.82	12.25							Current Year	0.00%	--	--	4.90%
72					High Estimate	2.79	3.18	12.30	13.83							Next Year	13.50%	--	--	12.40%
73					Year Ago EPS	3.03	2.91	11.36	11.36							Next 5 Years (per annum)	6.60%	--	--	11.68%
74																Past 5 Years (per annum)	19.49%	--	--	-
75
76					EPS Seeking Alpha											EPS Growth Seeking Alpha		Growth	Sector	% Diff. to Sector	5 yr Avg	% Diff. to 5Y Avg.
77					Period	EPS Est	FWD P/E	Low	High	# of Analysts						EPS Diluted Growth (YoY)		14.93%	7.50%	99.04%	15.85%	-5.78%
78					Dec 2024	11.46	16.76	10.82	12.3	5						EPS Diluted Growth (FWD)		14.70%	9.01%	63.20%	16.38%	-10.25%
79					Dec 2025	12.96	14.81	12.25	13.83	5						EPS GAAP Growth (YoY)		33.02%	8.12%	306.69%	-	-
80																EPS GAAP Growth (FWD)		14.70%	10.65%	38.03%	-	-
81																EPS FWD Long Term Growth (3-5Y CAGR)		14.00%	11.33%	23.52%	12.63%	10.85%
82					EPS CFRA			Analysts
83					Year	EPS		Year	Est	High	Low	# of Est.	Est P/E
84					This			2025	12.96	13.83	12.25	5	14.40			FINWIZ EPS Growth
85					Next			2024	11.46	12.30	10.82	5	16.30			This FY	Next	Next 5	Past 5 Years	Sales past5
86					Next3yG%											1.10%	12.86%	6.60%	12.70%	10.93%
87
88					Tikr											VI IO
89					Year	EPS	CAGR 2Yr	%Growth								Year		2021	2022	2023	2024	2025	2026	2&3 Yr CAGR
90					This	11.46	REV	3.70%								Revenue		1.3B	1.5B	1.7B	1.8B	1.8B
91					Next	12.96	EPS	6.80%	<-%!							Rev Growth		14.70%	13.40%	11.60%	4.10%	5.10%		4.60%
92																EPS		6.70	$8.50	11.3	11.7	13.3		8.49%
93																EPS Growth		38.80%	27.10%	33.60%	3.20%	13.90%		8.49%
94					MS	2021	2022	2023	2024	2025	2026	3 Yr CAGR												8.55%
95					Revenue	1,334	1,514	1,690	1,734	1,818		3.72%
96					Growth				2.60%	4.84%		3.72%				Rev Gwth	Past 10	Past 5	Past 3	This	Next	Long Term	Mgmt	Pre-Covid-5
97					EPS	6.75	8.54	11.36	11.36	12.89		6.52%				Smooth	8.58%	10.05%	10.70%	3.70%	4.51%	4.05%		5.86%
98					Growth				0.00%	13.47%		6.52%				Actual	9.58%	10.87%	13.24%	MGMT->				5.93%
99
100																EPS	Last Yr	TTM	This	Next	Mgmt Min	Max	Est