ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Companies Ranked by Finance Value (Column G)Ticker5-Yr BetaRequired Rate of Return (10-yr)Actual Rate of Return (10-yr)Risk Aversion = 2022 Price Return (worst year in past 10 for S&P 500)Finance Value = Col E + Col FActual Rate of Return (5-yr)Market Cap ($B)Dividend YieldFree Cash Flow Yield (TTM)5-Yr Div Growth/yrP/E (TTM)EV/EBITDA (TTM)Forward 1-yr PEG (Seeking Alpha)Forward 3-5 year PEG (Morningstar)BMW Method 16-yr Px CAGRRecent Px TrendBMW Method estimate of loss @ -2SDReturn on Tangible Capital Employed (lfy)Return on Assets (TTM)Return on Equity (TTM)ROICWACCTotal Debt: EBITDA (mrq)LT Debt: Equity (mrq)TBV:Px (mrq)Div:FCF (lfy)S&P Bond RatingS&P Stock Rating (Stars)Px (50-d MA)Shares BOTAmountNet Present Value @ 10% Discount Rate (10-yr Holding Period + dividends)Graham NumberPx (50-day MA): Graham NumberPx: Book7-Yr P/EPx: SalesValue StockOverpriced StockSCORE: Basic Quality ScreenMorningstar RatingS&P Insider ActivityS&P VolatilityS&P Fair Value RankA-rated CompanyVYM (High Dividend Yield)VIG (Dividend Appreciation)
2
Dow Jones Utility Average
3
SempraSRE0.8210.0%8.4%16.5%27.1%11.1%$493.0%-2.23%7.1%41153.693.1210.0%down 1SD26%4.59%2.42%4.48%-0.35%5.43%5.701.0349.7%neg FCFBBB+B+/M (4)$162.6231$5,057.64$920.30$80.22204%1.7353.23.0Over Valued (3)NRlow2yes
4
Consolidated EdisonED0.516.8%9.0%11.8%20.8%8.2%$323.6%-2.06%2.8%20132.773.138.6%down 2SD20%4.74%2.72%6.65%3.67%3.34%6.261.2456.8%neg FCFA-B+/L (2)$94.9153$5,030.23$216.98$76.87124%1.4232.0yes4.0Fairly Valued (3)favorablelow3yesyes
5
Atmos EnergyATO0.648.1%12.5%7.0%19.5%10.2%$152.7%-10.04%8.7%21172.552.1113.6%down 2SD25%5.13%2.70%8.63%4.09%4.10%14.860.8953.5%neg FCFA-A/L (3)$111.9945$4,968.04$2,566.96$90.30125%1.5273.44.0Over Valued (2)NAlow3yesyesyes
6
American Electric PowerAEP0.587.5%9.4%7.1%16.5%10.5%$463.7%-0.80%5.7%20122.972.6711.2%down 1SD27%3.81%2.70%11.61%4.05%4.11%5.111.5949.0%neg FCFA-A-/L (3)$97.6951$4,982.19$1,420.22$73.09135%1.8262.44.0Under Valued (3)neutrallowNRyesyes
7
ExelonEXC0.8910.7%10.0%6.2%16.2%12.6%$393.5%-7.00%6.8%1972.483.566.4%up 1SD40%5.50%2.53%6.18%2.87%4.44%5.691.6839.0%neg FCFBBB+B/L (4)$42.76117$5,002.92-$482.12$31.52137%1.6191.0yes1.0Under Valued (4)favorableaverage4yes
8
Xcel EnergyXEL0.658.2%11.6%3.2%14.8%12.9%$372.9%-2.00%6.2%23132.762.7412.2%down 2SD18%3.67%2.36%10.61%4.32%4.02%5.691.5738.8%neg FCFA-A/L (2)$71.6270$5,013.40$1,791.00$44.48162%2.1292.34.0Over Valued (1)favorable lowNRyesyesyes
9
Southern SO0.718.9%10.2%4.3%14.5%14.1%$714.2%-0.34%3.3%22133.452.858.9%on trendline17%4.47%1.90%6.57%2.83%4.38%4.891.9629.6%neg FCFBBB+B+/L (3)$74.9967$5,024.33$452.20$41.49182%2.4292.63.0Over Valued (3)unfavorablelow3yes
10
Duke EnergyDUK0.668.3%7.8%-1.6%6.2%10.3%$734.2%-2.64%2.8%18122.992.828.3%down 2SD18%3.87%2.20%6.84%3.32%3.93%5.921.4234.2%neg FCFBBB+B+/L (3)$104.1048$4,996.80$267.11$83.03126%1.4272.63.0Under Valued (3)unfavorablelow3yes
11
FirstEnergyFE0.779.5%5.3%0.9%6.2%8.7%$224.1%1.91%-4.1%16113.253.812.6%on trendline32%4.84%3.28%14.79%4.25%3.92%6.312.6514.7%232%BBB-B/L (2)$39.56126$4,984.56-$1,701.74$31.90124%1.9301.81.0Under Valued (4)neutrallow4yes
12
NextEra EnergyNEE0.799.7%13.8%-9.7%4.1%17.3%$1662.0%0.00%11.6%44303.461.9518.7%down 1SD33%5.41%0.81%1.41%1.16%3.19%7.311.6619.7%neg FCFA-A-/L (3)$85.0459$5,017.36$5,595.38$23.29368%4.1388.64.0Over Valued (3)unfavorablelow1yesyesyes
13
Public Service Enterprise GroupPEG0.718.9%10.5%-8.1%2.4%8.3%$293.7%-6.56%4.6%neg EPS205.553.268.6%down 1SD29%2.04%1.77%-8.69%1.38%4.72%6.701.443.7%neg FCFBBB+B+/L (4)$63.6979$5,031.51$306.47neg EPSneg EPS2.1263.03.0Under Valued (4)unfavorablelowNRyes
14
Edison InternationalEIX0.819.9%8.3%-6.3%2.0%6.5%$234.7%-13.44%5.2%43141.672.535.6%down 1SD32%3.99%2.97%3.35%2.70%5.72%6.631.9158.9%neg FCFBBBB/L (3)$65.8276$5,002.32-$421.83$32.90202%1.6301.32.0Under Valued (4)NRlow3yes
15
American Water WorksAWK0.739.1%14.2%-18.6%-4.4%16.4%$271.8%-4.38%9.7%18143.433.51NANANA4.74%3.21%18.34%3.67%3.41%5.431.4523.7%neg FCFAA/L (3)$146.3234$4,999.02NA$81.85180%3.1416.1NAOver Valued (2)NRlow3yes
16
Vistra
17
Dominion EnergyD0.688.5%0.9%-22.0%-21.1%0.4%$514.3%-6.56%-2.4%34142.522.137.0%down 2SD24%3.80%2.74%8.74%2.71%4.20%6.631.524.4%neg FCFBBB+B+/L (3)$78.3664$5,015.04-$526.69$37.20213%2.0283.53.0Under Valued (5)neutrallow3yes
18
Averagen = 150.718.9%9.4%-0.7%8.9%10.9%$503.5%-3.77%5.1%26153.132.889.6%down 1SD26%4.34%2.36%6.04%2.86%4.28%6.761.5937.3%neg FCFBBB+B+/L (3)$84.57$5,009.28$910.91$55.37172%2.0282.92/151/153.0Fairly Valued (3)neutrallow35/1514/154/15
19
20
Benchmarks
21
Berkshire HathawayBRK-B0.8310.1%11.6%3.3%14.9%8.6%$6830.0%3.50%0.0%51693.969.6810.6%down 1SD25%4.14%7.21%17.38%2.02%6.78%neg EBITDA0.2466.9%no dividendAAB/L (3)$282.1718$5,079.06$19.63$155.21182%1.3152.3yes4.0Under Valued (5)neutrallowNRNAno dividendno dividend
22
Air Products and ChemicalsAPD0.9211.1%11.9%1.8%13.7%14.8%$642.3%0.56%11.3%23162.061.2012.5%down 1SD30%8.87%5.47%15.75%9.29%6.32%1.740.5325.6%144%AA/M (4)$250.5620$5,011.20$2,089.32$117.82213%3.8374.34.0Under Valued (4)NAlow2yesyesyes
23
Waste ManagementWM0.648.1%17.2%-5.4%11.8%13.9%$651.6%3.52%8.9%31152.352.1616.3%on trendline30%15.90%7.32%29.97%9.94%7.74%2.602.59-4.1%40%A-A-/M (4)$168.1230$5,046.00$4,020.44$44.73376%9.0453.43.0Over Valued (2)favorablelow1
24
SPDR Dow Jones Industrial Average ETF DIA0.8810.6%10.8%-8.8%2.0%8.5%$291.9%NA5.6%16NANANA8.5%down 1SD26%NANANANANANANANANANANA$313.9516$5,023.20-$124.50NANA4.3NANANANANANANANANANA
25
SPDR S&P 500 ETFSPY1.0011.9%11.9%-19.3%-7.4%10.7%$3671.6%1.05%5.3%18171.20NA9.6%down 1SD30%NA6.29%22.63%NANA9.650.86NANANANA$392.5013$5,102.50$173.97$214.35183%3.9282.2NANANANANANANANA
26
Averagen = 50.869.6%14.6%-1.8%12.8%14.4%$652.0%2.04%10.1%27162.211.6814.4%down 1SD30%15.90%7.32%29.97%9.94%7.74%2.171.56-4.1%92%AA-/M (3)$168.12$5,028.60$3,054.88$44.73295%6.4413.91/30/33.5Fairly Valued (4)neutrallow21/21/21/2
27
28
Risk-free Rate
29
Vanguard Intermediate-Term TreasuryVFITX0.193.4%1.4%-11.2%-9.8%1.0%$54.1%NA-17.3%0.2%down 2SD49%AAANA$10.16492$4,998.72-$2,576.77
30
31
Consumer Price Indexcpi--2.6%1.5%4.1%
32
33
Updated 12/28/2023
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
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