ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
(STLD) Steel Dynamics Inc
2
NOTES:

Any Text in BLACK should be a formula.

Any Text in BLUE is not part of a formula.
3
Valuation SummaryCurrent Price
4
Relative Valuation$87.35$85.46
5
Normalized Valuation$106.26
6
DCF Valuation$76.57
pays quarterly dividend $0.34 cents
7
Average Intrinsic Value$90.06
ex dividend date march 30th, 2022
Note: all financials are up to 2019 here and don't count towards 2020 financials
8
9
Relative Valuation
10
11
Peer GroupPE Ratio
12
(NUE) Nucor Corporation6.13
13
(STLD) Steel Dynamics Inc5.41
14
(CLF) Cleveland Cliffs5.25
15
(RS) Reliance Steel & Aluminum8.88
16
(X) United States Steel 2.4
17
Industry PE (avg. of Peer Group)5.6
18
19
Current EPS15.56
20
21
Intrinsic Value87.35384
22
23
Normalized Valuation
24
($000)NORMALAVG. (ratios)2021202020192018
25
Total Revenue 22,826,997.2718,408,8509,601,48210,464,99111,821,839
26
growth rate24.00%24.00%91.73%-8.25%-11.48%
27
Net Income2,510,969.703,214,066550,822671,1031,258,379
28
29
Profit Margin11.00%10.06%17.46%5.74%6.41%10.64%
30
31
Shares Outstanding207,000.00207,000.00212,345.00220,748.00235,193.00
32
33
EPS12.1315.532.593.045.35
34
35
Share Price62.5136.8733.231.54
36
P/E Ratio8.768.764.0314.2110.925.89
37
38
Intrinsic Value$106.26
39
40
41
DCF Valuation
42
($000)Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
43
Total Revenue 20,617,912.0023,092,061.4425,863,108.8128,966,681.8732,442,683.6936,335,805.7440,696,102.4345,579,634.7251,049,190.8857,175,093.7964,036,105.04
44
growth rate12.00%12.00%12.00%12.00%12.00%12.00%12.00%12.00%12.00%12.00%12.00%
45
Net Income2,267,970.322,540,126.762,844,941.973,186,335.013,568,695.213,996,938.634,476,571.275,013,759.825,615,411.006,289,260.327,043,971.55
46
47
Profit Margin11.00%11.00%11.00%11.00%11.00%11.00%11.00%11.00%11.00%11.00%11.00%
48
49
Shares Outstanding207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00207,000.00
50
51
EPS10.9612.2713.7415.3917.2419.3121.6324.2227.1330.3834.03
52
53
Dividend Payout Ratioresearch link20.00%20.00%20.00%20.00%20.00%20.00%20.00%20.00%20.00%20.00%20.00%
54
55
DPS2.192.452.753.083.453.864.334.845.436.086.81
56
Terminal Value113.43
57
Total Cash Flows2.192.452.753.083.453.864.334.845.43119.51
58
59
Required Return8%
60
Beta1.0
61
Expected Market Return8.00%
average stock market return over 10-20 years
62
Risk-free Return2%
10 year treasury bond rate
63
growth rate (terminal)2.00%
estimate of world gdp growth (2-4%)
64
65
Intrinsic Value$76.57
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100