| 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 | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Col G) | Ticker | 5-Yr Beta (Barron's) | 10-Yr Required Rate of Return | Actual 10-Yr Rate of Return | Risk Aversion = 2022 Px change (worst year for S&P 500 in past 10) | Finance Value (Col E + Col F) | Actual 5-Yr Rate of Return | Market Cap ($B) | Div. Yield | Free Cash Flow Yield | 5-Yr Div. Growth | P/E (TTM) | EV: EBITDA | 1-Yr PEG (Seeking Alpha) | 5-Yr PEG (Morningstar) | BMW Method: 20-Yr CAGR (Px) | BMW Method: current Px Trend | BMW Method: Px loss after regression to mean from +2SD | Return on Tangible Capital Employed (lfy) | Return on Assets (TTM) | Return on Equity (TTM) | WACC (TTM) | ROIC (TTM) | Debt: EBITDA (mrq) | Debt: Equity (mrq) | Tangible Book Value (mrq): Px | S&P Bond Rating | S&P Stock Rating (Stars) | Px (50d MA)/Sh | Shares BOT | Cost | Net Present Value (10 years of returns discounted @ RRR) | Graham Number | Px (50d MA): Graham Number | Px: Book | 7-yr P/E | Px: Sales | Value Stock | Overpriced Stock | SCORE: Basic Quality Screen | Morningstar Rating | A-rated Company | VYM (High Yield) | VIG (Div. Appreciation) | |
2 | Large-cap DJCA Dividend Achievers | |||||||||||||||||||||||||||||||||||||||||||||
3 | Merck | MRK | 0.51 | 6.8% | 12.2% | 44.2% | 56.4% | 13.7% | $324 | 2.4% | 4.1% | 9.3% | 913 | 27 | 0.03 | 0.98 | 11.7% | up 1SD | 30% | 27.30% | 5.40% | 10.77% | 5.59% | 6.64% | 1.25 | 0.85 | 0.3% | A+ | B+/M (4) | $116.25 | 43 | $4,998.75 | $3,728.27 | $7.16 | 1624% | 7.9 | 41 | 5.5 | yes | 3.5 | Fairly-valued (2) | yes | yes | yes | ||
4 | Caterpillar | CAT | 0.95 | 11.7% | 15.8% | 16.1% | 31.9% | 21.1% | $161 | 1.6% | 5.5% | 8.7% | 16 | 13 | neg YoY growth | 1.84 | 13.3% | up 2SD | 39% | 19.01% | 10.18% | 50.45% | 10.71% | 15.28% | 2.23 | 1.81 | 8.3% | A | B/H (4) | $294.34 | 17 | $5,003.78 | $1,130.15 | $132.28 | 223% | 8.3 | 38 | 2.4 | 4.0 | Over-valued (2) | yes | yes | yes | |||
5 | Travelers | TRV | 0.86 | 10.7% | 12.5% | 19.0% | 31.5% | 12.7% | $50 | 1.8% | 15.7% | 5.3% | 17 | NA | 0.83 | 0.66 | 11.8% | on trendline | 24% | 3.08% | 1.43% | 10.95% | 6.97% | 2.86% | NA | 0.32 | 42.5% | A | B+/M (4) | $199.16 | 25 | $4,979.00 | $920.76 | $177.28 | 112% | 2.0 | 18 | 1.2 | yes | 4.0 | Fairly-valued (3) | yes | yes | yes | ||
6 | UnitedHealth Group | UNH | 0.86 | 10.7% | 22.7% | 5.0% | 27.7% | 18.0% | $482 | 1.4% | 5.4% | 16.1% | 22 | 14 | 1.27 | 1.41 | 20.4% | on trendline | 56% | 21.09% | 7.79% | 24.99% | 6.60% | 10.74% | 1.81 | 0.66 | 20.0% | A+ | A+/M (3) | $523.90 | 9.5 | $4,977.05 | $6,839.39 | $232.70 | 225% | 5.1 | 32 | 1.3 | 4.0 | Over-valued (3) | yes | |||||
7 | Coca-Cola | KO | 0.65 | 8.3% | 7.8% | 8.1% | 15.9% | 8.7% | $256 | 3.3% | 3.8% | 3.4% | 24 | 18 | 2.84 | 2.79 | 8.6% | down 1SD | 17% | 20.07% | 8.67% | 40.16% | 6.57% | 14.02% | 3.32 | 1.62 | -2.8% | A+ | B+/L (4) | $59.45 | 84 | $4,993.80 | $1,013.58 | $18.29 | 325% | 9.9 | 33 | 5.8 | yes | 3.0 | Fairly-valued (3) | yes | yes | |||
8 | Visa | V | 1.04 | 12.8% | 18.0% | -3.8% | 14.2% | 14.0% | $572 | 0.8% | 3.3% | 16.1% | 32 | 24 | 1.94 | 1.69 | NA | NA | NA | 45.26% | 15.88% | 46.92% | 9.32% | 26.44% | 0.80 | 0.52 | -0.9% | AA- | A+/M (4) | $266.48 | 19 | $4,966.03 | NA | $60.93 | 437% | 14.2 | 48 | 17.2 | yes | NA | Over-valued (3) | yes | ||||
9 | Honeywell International | HON | 0.97 | 12.0% | 10.2% | 3.5% | 13.7% | 7.0% | $130 | 2.2% | 3.3% | 5.7% | 23 | 15 | 1.94 | 1.98 | 12.2% | down 1SD | 32% | 21.79% | 7.63% | 33.60% | 8.99% | 13.10% | 2.68 | 1.36 | 12.2% | A | B+/M (3) | $201.05 | 25 | $5,026.25 | $527.59 | $68.13 | 295% | 7.8 | 28 | 3.6 | 4.0 | Under-valued (4) | yes | yes | ||||
10 | McDonald's | MCD | 0.75 | 9.5% | 14.6% | -2.2% | 12.4% | 11.9% | $211 | 2.3% | 3.4% | 8.3% | 25 | 21 | 2.39 | 2.41 | 14.6% | down 1SD | 19% | 19.99% | neg equity | 13.77% | 7.24% | 19.71% | 4.23 | neg equity | -2.2% | BBB+ | A/L (4) | $292.21 | 17 | $4,967.57 | $3,431.61 | NA | NA | NA | 39 | 8.3 | NA | Under-valued (4) | yes | yes | ||||
11 | Johnson & Johnson | JNJ | 0.51 | 6.8% | 8.3% | 3.5% | 11.8% | 5.5% | $377 | 3.0% | 3.8% | 5.8% | 30 | 18 | 3.86 | 5.85 | 8.8% | down 1SD | 23% | 23.36% | 19.18% | 18.00% | 5.61% | 14.80% | 1.03 | 0.42 | 0.0% | AAA | B+/M (3) | $158.05 | 32 | $5,057.60 | $1,982.62 | $58.84 | 268% | 5.3 | 30 | 4.8 | 4.0 | Fairly-valued (3) | yes | yes | yes | |||
12 | Walmart | WMT | 0.48 | 6.4% | 10.8% | -1.0% | 9.8% | 13.1% | $459 | 1.3% | 2.8% | 1.9% | 28 | 13 | 2.42 | 2.89 | 10.1% | up 1SD | 25% | 9.80% | 6.44% | 19.74% | 6.80% | 10.00% | 3.80 | 0.88 | 11.2% | AA | B/L (4) | $160.95 | 31 | $4,989.45 | $2,232.63 | $63.16 | 255% | 5.8 | 38 | 0.7 | 4.0 | Over-valued (3) | yes | yes | yes | |||
13 | Procter & Gamble | PG | 0.57 | 7.4% | 10.2% | -6.6% | 3.6% | 12.4% | $371 | 2.4% | 4.1% | 5.6% | 26 | 18 | 2.84 | 3.63 | 8.8% | up 1SD | 22% | 39.29% | 10.96% | 31.78% | 5.99% | 14.23% | 1.54 | 0.70 | -4.1% | AA- | A/L (4) | $150.88 | 33 | $4,979.04 | $1,389.46 | $52.19 | 289% | 7.8 | 34 | 4.7 | yes | 3.5 | Over-valued (2) | yes | yes | yes | ||
14 | NextEra Energy | NEE | 0.80 | 10.0% | 12.2% | -9.7% | 2.5% | 6.1% | $117 | 3.6% | -1.4% | 11.0% | 16 | 11 | 2.04 | 2.39 | 14.2% | down 2SD | 32% | 6.37% | 3.74% | 11.58% | 6.89% | 4.96% | 6.06 | 1.54 | 36.7% | A- | A-/L 4) | $59.35 | 84 | $4,985.40 | $3,422.99 | $48.09 | 123% | 2.5 | 24 | 4.3 | yes | 4.0 | Under-valued (4) | yes | yes | yes | ||
15 | Microsoft | MSFT | 1.18 | 14.3% | 28.4% | -27.5% | 0.9% | 30.0% | $3,002 | 0.7% | 2.1% | 10.2% | 37 | 24 | 1.97 | 2.40 | 21.8% | up 1SD | 52% | 26.87% | 15.19% | 39.17% | 9.98% | 25.34% | 0.66 | 0.37 | 3.0% | AAA | A+/L (5) | $388.61 | 13 | $5,051.93 | $4,382.26 | $89.36 | 435% | 12.6 | 61 | 13.3 | yes | 3.5 | Over-valued (3) | yes | ||||
16 | Apple | AAPL | 1.20 | 14.6% | 26.9% | -26.7% | 0.2% | 33.7% | $2,815 | 0.5% | 3.4% | 5.6% | 28 | 22 | 3.03 | 2.25 | 27.8% | on trendline | 46% | 33.94% | 21.18% | 154.27% | 11.01% | 34.58% | 0.91 | 1.79 | 2.5% | AA+ | A+/L (4) | $189.86 | 26 | $4,936.36 | $9,396.26 | $26.35 | 721% | 38.0 | 45 | 7.7 | yes | 3.5 | Over-valued (2) | yes | ||||
17 | JPMorgan Chase | JPM | 1.10 | 13.4% | 15.2% | -15.4% | -0.2% | 14.5% | $515 | 2.4% | 10.6% | 8.6% | 11 | NA | neg YoY growth | 3.03 | 12.3% | up 1SD | 35% | 1.64% | 1.31% | 15.98% | 12.65% | NA | NA | 1.29 | 44.5% | A- | A-/L (4) | $169.91 | 29 | $4,927.39 | $119.67 | $195.36 | 87% | 1.7 | 15 | 3.2 | yes | 4.0 | Over-valued (2) | yes | yes | |||
18 | CSX | CSX | 1.03 | 12.6% | 16.5% | -17.0% | -0.5% | 9.8% | $72 | 1.3% | 4.4% | 8.5% | 20 | 12 | 1.50 | 3.19 | 17.0% | down 1SD | 33% | 13.45% | 8.24% | 30.01% | 9.99% | 10.81% | 2.69 | 1.57 | 16.1% | BBB+ | A-/M (3) | $35.05 | 143 | $5,012.15 | $2,501.15 | $16.05 | 218% | 5.9 | 22 | 5.0 | 3.0 | Over-valued (3) | yes | |||||
19 | Union Pacific | UNP | 0.92 | 11.4% | 12.9% | -18.1% | -5.2% | 10.1% | $150 | 2.1% | 3.1% | 11.2% | 24 | 15 | 1.55 | 4.18 | 16.9% | down 1SD | 29% | 13.82% | 8.56% | 47.34% | 9.06% | 10.67% | 2.72 | 2.29 | 9.7% | A- | B+/M (2) | $242.11 | 21 | $5,084.31 | $3,685.47 | $75.55 | 320% | 10.2 | 24 | 6.3 | 4.0 | Over-valued (2) | yes | yes | yes | |||
20 | Home Depot | HD | 1.03 | 12.6% | 18.6% | -23.8% | -5.2% | 16.9% | $361 | 2.3% | 4.9% | 15.2% | 23 | 16 | 5.50 | 2.22 | 17.8% | on trendline | 46% | 35.97% | 18.28% | 1151.32% | 9.31% | 30.79% | 1.96 | 34.44 | -1.8% | A | A+/M (3) | $350.91 | 14 | $4,912.74 | $3,508.71 | $22.50 | 1560% | 252.2 | 31 | 2.4 | yes | 3.0 | Over-valued (2) | yes | yes | |||
21 | United Parcel Service | UPS | 0.84 | 10.5% | 7.7% | -18.8% | -11.1% | 9.5% | $126 | 4.4% | 4.0% | 12.0% | 19 | 12 | 0.86 | 3.32 | 7.9% | on trendline | 33% | 21.42% | 8.35% | 36.15% | 10.09% | 12.76% | 2.13 | 1.54 | 7.2% | A | B/M (3) | $154.44 | 32 | $4,942.08 | $519.95 | $59.61 | 259% | 7.3 | 20 | 1.4 | 3.0 | Under-valued (3) | yes | yes | ||||
22 | Cisco Systems | CSCO | 0.93 | 11.5% | 11.6% | -23.9% | -12.3% | 1.7% | $197 | 3.3% | 6.8% | 3.4% | 15 | 10 | 4.09 | 3.49 | 7.5% | on trendline | 38% | 15.29% | 10.16% | 30.65% | 9.47% | 16.28% | 0.78 | 0.25 | 23.5% | AA- | B+/M (3) | $50.20 | 100 | $5,020.00 | -$780.91 | $29.06 | 173% | 4.3 | 23 | 3.5 | 2.0 | Under-valued (3) | yes | yes | yes | |||
23 | Average | n = 20 | 0.86 | 10.7% | 14.7% | -4.8% | 9.9% | 13.5% | $537 | 2.2% | 4.7% | 8.6% | 67 | 17 | 2.27 | 2.63 | 13.9% | on trendline | 33% | 20.94% | 9.92% | 90.88% | 8.44% | 15.47% | 2.26 | 2.85 | 11.3% | A | A-/H (4) | $203.16 | $4,990.53 | $2,629.03 | $75.42 | 418% | 21.5 | 32 | 5.1 | 3/20 | 7/20 | 3.6 | Fairly-valued (3) | 9/20 | 15/20 | 20/20 | ||
24 | ||||||||||||||||||||||||||||||||||||||||||||||
25 | Market Rate | |||||||||||||||||||||||||||||||||||||||||||||
26 | SPDR S&P 500 Index ETF | SPY | 1.00 | 12.3% | 12.3% | -19.3% | -7.0% | 14.0% | $484 | 1.4% | 4.1% | 5.4% | 25 | 15 | 1.15 | NA | 9.2% | up 1SD | 30% | NA | 5.97% | 18.53% | NA | NA | NA | $479.89 | 10 | $4,798.90 | -$973.27 | $209.84 | 229% | 4.2 | 27 | 2.7 | ||||||||||||
27 | ||||||||||||||||||||||||||||||||||||||||||||||
28 | Benchmarks | |||||||||||||||||||||||||||||||||||||||||||||
29 | Berkshire Hathaway | BRK-B | 0.83 | 10.4% | 13.3% | 3.3% | 16.6% | 14.8% | $880 | no div | 3.2% | no div | 12 | NA | 5.17 | NA | 11.2% | up 2SD | 24% | 10.83% | 6.36% | 15.54% | 8.38% | 9.06% | -2.50 | 0.24 | 47.9% | AA | B/L (4) | $372.01 | 13 | $4,836.13 | $107.87 | $437.36 | 85% | 1.7 | 23 | 2.1 | yes | 4.0 | Under-valued (3) | |||||
30 | SPDR Dow Jones Indust. Avg. ETF | DIA | 0.88 | 10.9% | 11.2% | -8.8% | 2.4% | 10.2% | $33 | 1.8% | NA | 4.9% | 23 | NA | NA | NA | 8.0% | up 1SD | 26% | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | $377.37 | 13 | $4,905.81 | -$794.32 | NA | NA | 1.9 | NA | 0.8 | NA | NA | ||||||
31 | Average | n = 2 | 0.86 | 10.7% | 12.3% | -2.8% | 9.5% | 12.5% | $457 | 1.8% | 4.9% | 18 | 5.17 | 9.6% | up 1SD | 25% | 6.36% | 15.54% | 8.38% | 9.06% | -2.50 | 0.24 | 47.9% | AA- | B+/M (4) | $374.69 | $4,870.97 | -$343.23 | 1.8 | 23 | 1.5 | Under-valued (4) | ||||||||||||||
32 | ||||||||||||||||||||||||||||||||||||||||||||||
33 | Risk-free Rate | |||||||||||||||||||||||||||||||||||||||||||||
34 | Vanguard Intermed. Term Treasury | VFITX | 0.20 | 3.3% | 1.0% | -11.2% | -10.2% | 0.5% | $6 | 3.5% | 8.8% | 0.3% | down 2SD | 54% | NA | AAA | $9.90 | 506 | $5,009.40 | $414.11 | ||||||||||||||||||||||||||
35 | ||||||||||||||||||||||||||||||||||||||||||||||
36 | Consumer Price Index | cpi | 2.6% | 6.0% | 8.6% | 3.7% | ||||||||||||||||||||||||||||||||||||||||
37 | ||||||||||||||||||||||||||||||||||||||||||||||
38 | Updated 2/21/2024 |