| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies Ranked by Finance Value (Column E) | Ticker | Reward = 10-Yr Total Return/Yr | Risk Aversion = 2018 Price Return (worst year for S&P 500 of past 10) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Market Cap ($B) | Dividend Yield | Free Cash Flow Yield (TTM) | 5-Yr Div Growth/yr | 5-Yr Beta | P/E (TTM) | Forward 1-yr PEG (Seeking Alpha) | Forward 5-yr PEG (Refinitiv) | BMW Method 20-Yr Px CAGR | Recent Px Trend | BMW Method Est. Loss @ -2SD | Return on Tangible Capital Employed (lfy) | Return on Average Assets (lfy) | ROI (TTM) | Return on Equity (TTM) | Debt: EBITDA (lfy) | Debt:Equity (mrq) | TBV:Px (lfy) | Div:FCF (lfy) | S&P Bond Rating | S&P Stock Rating (Stars) | Px (50d avg) | Shares BOT | Amount | Net Present Value @ 10-Yr Holding Period & 10% Discount Rate | Graham Number | Px (50d avg): Graham Number | Px: Book | 7-Yr P/E | Px: Sales | Value Stock | Overpriced Stock | SCORE: Basic Quality Screen | Morningstar Rating | S&P Insider Activity | S&P Fair Value Rank | VIG (Dividend Achiever) | |
2 | Top 200 A-rated Non-financial Stocks | |||||||||||||||||||||||||||||||||||||||||||
3 | Eli Lilly | LLY | 24.1% | 47.2% | 71.3% | 28.6% | $253 | 1.5% | 2.22% | 13.5% | 0.41 | 43 | 3.49 | 1.80 | 13.2% | up 2SD | 52% | 21.15% | 11.70% | 17.25% | 72.32% | 1.78 | 1.90 | -1.03% | 52% | A+ | B+/M (3) | $250.48 | 20 | $5,009.60 | $2,097.86 | $37.00 | 677% | 26.6 | 68 | 8.1 | yes | 2.5 | Over Valued (2) | favorable | 1 | |||
4 | Merck | MRK | 11.4% | 25.6% | 37.0% | 8.4% | $197 | 3.6% | 4.87% | 8.0% | 0.45 | 15 | 0.88 | 1.09 | 9.3% | on trendline | 37% | 23.25% | 12.52% | 18.83% | 38.83% | 1.67 | 0.90 | -3.04% | 68% | A+ | B/M (5) | $78.45 | 64 | $5,020.80 | $787.57 | $41.80 | 188% | 5.4 | 37 | 4.0 | 3.0 | Under Valued (4) | favorable | 4 | ||||
5 | NextEra Energy | NEE | 21.2% | 13.0% | 34.2% | 22.6% | $157 | 1.9% | -0.18% | 11.6% | 0.38 | 44 | 4.31 | 3.17 | 16.8% | up 1SD | 29% | 5.41% | 2.66% | 2.45% | 6.25% | 4.78 | 1.50 | 19.77% | neg FCF | A- | A-/L (4) | $79.84 | 63 | $5,029.92 | $4,639.05 | $27.78 | 288% | 4.1 | 38 | 8.9 | 4.0 | Over Valued (3) | favorable | 1 | yes | |||
6 | Automatic Data Processing | ADP | 18.3% | 13.1% | 31.4% | 17.6% | $87 | 2.0% | 2.94% | 12.8% | 0.83 | 32 | 4.23 | 2.76 | 14.1% | up 1SD | 33% | 7.37% | 5.91% | 27.45% | 50.47% | 0.79 | 0.66 | 2.42% | 54% | AA- | A/M (3) | $214.58 | 23 | $4,935.34 | $2,776.17 | $41.78 | 516% | 17.0 | 48 | 5.7 | yes | 3.5 | Under Valued (4) | unfavorable | 2 | yes | ||
7 | Pfizer | PFE | 12.9% | 14.6% | 27.5% | 13.3% | $275 | 3.3% | 10.42% | 4.6% | 0.71 | 13 | 0.14 | 1.00 | 8.6% | up 1SD | 41% | 19.91% | 13.35% | 16.35% | 30.11% | 1.60 | 0.50 | 1.01% | 29% | A+ | B+/M (5) | $51.86 | 96 | $4,978.56 | $200.57 | $34.50 | 151% | 3.6 | 27 | 3.4 | 3.0 | Fairly Valued (3) | unfavorable | 3 | ||||
8 | Cisco Systems | CSCO | 13.3% | 13.8% | 27.1% | 13.5% | $227 | 2.7% | 5.92% | 5.6% | 0.95 | 20 | 1.62 | 2.78 | 8.8% | on trendline | 39% | 25.74% | 11.01% | 19.51% | 28.90% | 0.68 | 0.30 | -0.22% | 42% | AA- | B+/M (4) | $57.17 | 87 | $4,973.79 | $168.42 | $24.49 | 234% | 5.9 | 30 | 4.6 | 3.0 | Fairly Valued (3) | neutral | 2 | ||||
9 | Waste Management | WM | 18.8% | 8.2% | 27.0% | 17.9% | $63 | 1.8% | 3.80% | 8.9% | 0.86 | 35 | 1.70 | 2.48 | 13.3% | up 1SD | 34% | 15.90% | 6.13% | 7.74% | 24.99% | 2.71 | 1.88 | -4.44% | 40% | A- | B+/M (4) | $150.93 | 33 | $4,980.69 | $2,092.48 | $40.65 | 372% | 8.5 | 43 | 3.4 | yes | 3.0 | Over Valued (2) | neutral | 2 | yes | ||
10 | Procter & Gamble | PG | 11.2% | 11.7% | 22.9% | 12.9% | $347 | 2.3% | 4.05% | 5.4% | 0.45 | 26 | 2.91 | 4.98 | 8.9% | up 2SD | 22% | 40.74% | 11.92% | 18.76% | 34.35% | 1.48 | 0.80 | -5.47% | 53% | AA- | A-/L (4) | $158.14 | 32 | $5,060.48 | $44.59 | $20.27 | 783% | 8.7 | 43 | 5.2 | yes | 3.5 | Over Valued (2) | unfavorable | 2 | yes | ||
11 | Target | TGT | 16.7% | -3.0% | 13.7% | 33.8% | $101 | 1.7% | 5.02% | 8.4% | 1.06 | 15 | 0.67 | 1.43 | 11.4% | up 2SD | 44% | 16.68% | 13.22% | 24.80% | 49.22% | 1.46 | 1.26 | 12.48% | 30% | A | A-/M (4) | $216.32 | 23 | $4,975.36 | $1,041.39 | $92.93 | 234% | 8.3 | 31 | 1.1 | 3.0 | Over Valued (2) | neutral | 4 | yes | |||
12 | Texas Instruments | TXN | 20.7% | -8.2% | 12.5% | 19.2% | $158 | 2.8% | 3.96% | 18.1% | 0.93 | 21 | 1.22 | 2.24 | 14.7% | up 1SD | 48% | 45.88% | 35.14% | 39.36% | 66.40% | 0.75 | 0.61 | 5.65% | 62% | A+ | A+/M (3) | $175.53 | 28 | $4,914.84 | $3,664.55 | $51.79 | 340% | 11.8 | 35 | 8.7 | yes | 2.5 | Over Valued (3) | favorable | 1 | yes | ||
13 | Air Products & Chemicals | APD | 11.8% | -2.4% | 9.4% | 12.6% | $50 | 2.9% | 1.82% | 11.3% | 0.89 | 23 | 1.91 | 1.29 | 11.9% | on trendline | 29% | 8.87% | 7.80% | 9.40% | 15.81% | 1.80 | 0.50 | 25.13% | 144% | A | A/M (5) | $264.31 | 19 | $5,021.89 | $1,716.60 | $117.19 | 227% | 3.9 | 40 | 4.9 | 3.5 | Under Valued (5) | neutral | 3 | yes | |||
14 | Johnson & Johnson | JNJ | 13.0% | -3.7% | 9.3% | 9.2% | $445 | 2.5% | 4.36% | 5.8% | 0.71 | 22 | 2.92 | 1.58 | 9.8% | on trendline | 24% | 25.34% | 11.70% | 15.66% | 29.86% | 1.25 | 0.50 | -1.71% | 56% | AAA | A-/M (4) | $168.59 | 30 | $5,057.70 | $550.06 | $70.34 | 240% | 5.9 | 32 | 4.7 | 4.0 | Fairly Valued (3) | neutral | 2 | yes | |||
15 | Coca-Cola | KO | 7.8% | 1.1% | 8.9% | 9.8% | $250 | 3.0% | 4.47% | 3.5% | 0.66 | 26 | 4.13 | 2.78 | 9.8% | on trendline | 21% | 19.53% | 10.76% | 13.30% | 41.03% | 3.08 | 1.90 | -4.64% | 64% | A+ | B/L (4) | $60.76 | 82 | $4,982.32 | $596.95 | $16.41 | 371% | 11.9 | 38 | 7.1 | yes | 3.0 | Fairly Valued (3) | unfavorable | 3 | yes | ||
16 | Intel | INTC | 8.1% | -2.1% | 6.0% | 7.6% | $189 | 3.1% | 5.17% | 7.0% | 0.55 | 10 | negative YoY growth | 2.78 | 8.4% | on trendline | 38% | 16.90% | 12.36% | 15.20% | 22.67% | 1.13 | 0.40 | 32.80% | 58% | A+ | A-/M (3) | $49.87 | 100 | $4,987.00 | $156.95 | $50.63 | 99% | 2.0 | 14 | 2.5 | yes | 3.0 | Under Valued (4) | favorable | 5 | |||
17 | PepsiCo | PEP | 12.0% | -6.3% | 5.7% | 9.7% | $214 | 2.7% | 3.27% | 7.4% | 0.65 | 28 | 4.05 | 3.20 | 9.6% | on trendline | 19% | 22.63% | 8.22% | 11.68% | 49.87% | 2.50 | 2.54 | -9.88% | 83% | A+ | B+/L (4) | $169.36 | 30 | $5,080.80 | $526.46 | $37.85 | 449% | 14.5 | 33 | 2.9 | yes | 3.5 | Fairly Valued (3) | NA | NA | yes | ||
18 | Eaton PLC | ETN | 14.8% | -9.2% | 5.6% | 17.9% | $60 | 2.1% | 2.69% | 6.2% | 1.21 | 28 | 1.19 | 1.53 | 17.0% | up 2SD | 44% | 24.84% | 6.51% | 7.76% | 13.64% | 2.49 | 0.54 | 7.15% | 77% | A- | A-/M (3) | $157.99 | 32 | $5,055.68 | $4,655.64 | $70.32 | 228% | 3.7 | 33 | 3.2 | 4.0 | Over Valued (3) | neutral | 2 | yes | |||
19 | Lockheed Martin | LMT | 20.8% | -18.4% | 2.4% | 13.4% | $123 | 2.5% | 6.34% | 9.0% | 0.79 | 20 | negative YoY growth | 3.84 | 15.7% | on trendline | 40% | 25.65% | 12.43% | 17.15% | 75.51% | 0.97 | 1.07 | -2.80% | 38% | A- | A/M (5) | $393.49 | 13 | $5,115.37 | $4,168.20 | $143.91 | 266% | 10.2 | 24 | 1.7 | 4.0 | Under Valued (3) | unfavorable | 2 | yes | |||
20 | Walmart | WMT | 11.0% | -10.1% | 0.9% | 16.7% | $394 | 1.6% | 2.78% | 1.9% | 0.53 | 29 | 2.48 | 2.76 | 9.2% | up 1SD | 29% | 12.32% | 5.50% | 7.33% | 13.81% | 1.81 | 0.70 | 13.76% | 56% | AA | B/L (4) | $139.72 | 36 | $5,029.92 | -$104.50 | $57.40 | 242% | 4.5 | 33 | 0.7 | 3.0 | Under Valued (3) | unfavorable | 2 | yes | |||
21 | Comcast | CMCSA | 13.7% | -14.0% | -0.3% | 5.7% | $205 | 2.3% | 8.15% | 11.4% | 0.94 | 15 | 1.90 | 0.97 | 11.0% | down 1SD | 44% | 18.95% | 5.15% | 5.56% | 14.36% | 2.76 | 0.99 | -32.85% | 23% | A- | A/M (4) | $48.66 | 103 | $5,011.98 | $1,167.09 | $38.08 | 129% | 2.2 | 18 | 1.9 | yes | 2.5 | Under Valued (4) | favorable | 4 | yes | ||
22 | Raytheon Technologies | RTX | 11.6% | -14.5% | -2.9% | 14.4% | $146 | 2.1% | 3.25% | 4.2% | 0.90 | 38 | negative YoY growth | 1.67 | 9.3% | on trendline | 27% | 6.88% | 2.41% | 3.34% | 5.60% | 3.60 | 0.50 | -13.74% | 60% | A | B+/M (5) | $93.06 | 54 | $5,025.24 | $175.43 | $53.22 | 174% | 2.0 | 29 | 2.3 | 3.5 | Over Valued (3) | unfavorable | 3 | ||||
23 | United Parcel Service | UPS | 13.0% | -17.2% | -4.2% | 17.2% | $179 | 3.0% | 6.04% | 12.9% | 1.12 | 14 | 1.25 | 1.46 | 9.3% | up 2SD | 33% | 21.66% | 19.56% | 28.52% | 116.37% | 1.31 | 1.79 | 4.55% | 32% | A- | B+/M (5) | $211.39 | 24 | $5,073.36 | $764.99 | $73.55 | 289% | 12.8 | 46 | 1.9 | yes | 2.5 | Over Valued (2) | neutral | 5 | yes | ||
24 | Illinois Tool Works | ITW | 16.2% | -20.9% | -4.7% | 11.5% | $65 | 2.4% | 3.51% | 13.4% | 1.13 | 24 | 1.09 | 1.57 | 12.8% | on trendline | 34% | 37.38% | 17.00% | 22.36% | 77.44% | 2.09 | 2.17 | -3.63% | 65% | A+ | A-/M (3) | $228.28 | 22 | $5,022.16 | $2,140.25 | $47.11 | 492% | 18.9 | 35 | 4.8 | yes | 3.5 | Over Valued (3) | neutral | 2 | yes | ||
25 | Caterpillar | CAT | 10.3% | -18.2% | -7.9% | 21.3% | $113 | 2.3% | 4.00% | 7.6% | 0.92 | 18 | 0.92 | 1.50 | 12.3% | up 1SD | 41% | 10.97% | 8.06% | 12.01% | 38.93% | 2.90 | 2.29 | 7.92% | 49% | A | B/M (3) | $206.44 | 24 | $4,954.56 | $1,959.15 | $90.49 | 228% | 6.1 | 33 | 2.0 | 3.0 | Over Valued (3) | unfavorable | 3 | yes | |||
26 | General Dynamics | GD | 14.9% | -23.1% | -8.2% | 6.8% | $65 | 2.1% | 5.18% | 8.4% | 0.99 | 20 | 9.17 | 2.27 | 11.6% | on trendline | 35% | 15.66% | 6.43% | 9.06% | 20.35% | 2.10 | 0.75 | -6.87% | 39% | A- | A+/M (5) | $217.16 | 23 | $4,994.68 | $1,398.69 | $128.63 | 166% | 3.6 | 21 | 1.7 | yes | 4.0 | Over Valued (2) | favorable | 3 | yes | ||
27 | 3M | MMM | 7.7% | -20.0% | -12.3% | -3.0% | $82 | 4.2% | 7.09% | 4.9% | 0.97 | 14 | 1.26 | 2.06 | 7.1% | down 2SD | 32% | 28.17% | 12.54% | 15.58% | 40.90% | 2.09 | 1.22 | -4.63% | 58% | A+ | A/M (3) | $162.77 | 31 | $5,045.87 | -$149.35 | $77.40 | 210% | 5.7 | 19 | 2.5 | 2.0 | Under Valued (4) | favorable | 3 | yes | |||
28 | QUALCOMM | QCOM | 11.5% | -31.8% | -20.3% | 25.3% | $173 | 1.8% | 4.25% | 5.1% | 1.26 | 18 | 0.68 | 0.94 | 11.2% | up 2SD | 40% | 32.24% | 23.54% | 34.66% | 108.31% | 0.89 | 1.40 | 0.73% | 35% | A | B/M (3) | $172.29 | 29 | $4,996.41 | $846.83 | $44.47 | 389% | 17.0 | 57 | 5.4 | yes | 2.5 | Over Valued (3) | neutral | 5 | yes | ||
29 | Average | n = 26 | 14.1% | -2.9% | 11.2% | 14.8% | $178 | 2.5% | 4.44% | 8.3% | 0.82 | 24 | 2.35 | 2.15 | 11.4% | up 1SD | 35% | 21.15% | 11.29% | 16.20% | 41.78% | 1.94 | 0.94 | 1.48% | 55% | A | B+/L (4) | $155.52 | $5,012.86 | $1,464.70 | $58.85 | 307% | 8.6 | 35 | 4.0 | 3/26 | 10/26 | 3.2 | Fairly Valued (3) | neutral | 3 | 20/26 | ||
30 | ||||||||||||||||||||||||||||||||||||||||||||
31 | Benchmarks | |||||||||||||||||||||||||||||||||||||||||||
32 | Berkshire Hathaway | BRK-B | 14.9% | -4.1% | 10.8% | 14.4% | $720 | 0.0% | 3.53% | 0.0% | 0.91 | 8 | 1.03 | 9.94 | 10.7% | up 2SD | 24% | 4.14% | 9.80% | 11.70% | 17.72% | 3.03 | 0.26 | 0.04% | no dividend | AA | B/L (3) | $315.67 | 16 | $5,050.72 | $66.74 | $421.91 | 67% | 1.4 | 20 | 1.9 | yes | 4.0 | Over Valued (3) | neutral | NA | |||
33 | SPDR S&P 500 ETF | SPY | 13.7% | -4.2% | 9.5% | 14.2% | $455 | 1.3% | -0.01% | 4.7% | 1.00 | 24 | 1.00 | 1.10 | 8.0% | up 1SD | 31% | NA | 3.65% | 8.36% | 21.78% | NA | NA | $446.42 | 11 | $4,910.62 | -$619.11 | $186.12 | 241% | 4.7 | 37 | 3.2 | ||||||||||||
34 | SPDR Dow Jones Industrial Avg. ETF | DIA | 12.0% | -4.3% | 7.7% | 12.0% | $29 | 1.7% | NA | 5.2% | 0.99 | 20 | NA | NA | 7.0% | up 1SD | 28% | NA | NA | NA | NA | NA | NA | $348.01 | 14 | $4,997.07 | -$933.67 | NA | NA | 5.0 | NA | NA | ||||||||||||
35 | Average | n = 3 | 13.5% | -4.2% | 9.3% | 13.5% | $242 | 1.0% | 1.76% | 3.3% | 0.97 | 22 | 1.02 | 5.52 | 8.6% | up 1SD | 28% | 4.14% | 6.73% | 10.03% | 19.75% | 3.03 | 0.26 | 0.04% | no dividend | AA | B/L (3) | $397.22 | $4,986.14 | -$776.39 | $304.02 | 154% | 3.7 | 29 | 2.6 | 4.0 | Over Valued (3) | neutral | NA | |||||
36 | ||||||||||||||||||||||||||||||||||||||||||||
37 | Consumer Price Index | cpi | 2.3% | 1.5% | 3.8% | 3.4% | ||||||||||||||||||||||||||||||||||||||
38 | ||||||||||||||||||||||||||||||||||||||||||||
39 | Updated 3/14/2022 |