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 | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Companies ranked by Finance Value (Column E) | Ticker | Reward = 10-Yr Total Return/Yr | Risk Aversion = 2018 Price Return (S&P 500's worst year in last 10) | Finance Value = Col C + Col D | 5-Yr Total Return/Yr | Dividend Yield | Free Cash Flow Yield | 5-Yr Div Growth/Yr | 5-Yr Beta | P/E | BMW Method: Px 20-Yr CAGR | Current Px Trend | BMW Method: Px loss after regression to mean from +2SD | Return on Tangible Capital Employed | WACC | LT Debt: Total Assets | Total Debt: Total Assets | Total Debt: EBITDA | TBV:Px | Div:FCF | S&P Bond Rating | S&P Stock Rating | 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 | Morningstar (Stars) | SCORE: Basic Quality Screen | Market Cap ($B) | Dividend Achiever | S&P 100 Company | DJIA Company | 2008 Px Return | Annual DRIP fees @ $100/mo | DRIP Vendor | |||||||||||||||||||||||||||||||||||
2 | Merck | MRK | 11.6% | 35.8% | 47.4% | 8.7% | 3.3% | 1.8% | 5.9% | 0.5 | 19 | 7.2% | up 1SD | 44% | 28.4% | 2.4% | 28% | 32% | 155% | -4% | 57% | AA- | B+/M (5) | $79.48 | 63 | $5,007.24 | -$285.98 | $30.33 | 262% | 7.4 | 36 | 4.1 | yes | undervalued (4) | 1.5 | $208 | yes | yes | yes | -47.7% | $12.48 | https://www.shareowneronline.com/ | ||||||||||||||||||||||||||||||||||||
3 | Pfizer | PFE | 13.0% | 20.5% | 33.5% | 3.6% | 4.5% | 1.1% | 6.5% | 0.69 | 12 | 5.5% | on trendline | 47% | 24.7% | 4.0% | 22% | 32% | 259% | -17% | 80% | AA- | A-/M (4) | $36.59 | 137 | $5,012.83 | -$420.38 | $27.16 | 135% | 2.9 | 19 | 3.8 | yes | undervalued (4) | 1 | $218 | yes | yes | -22.1% | $32.36 | https://www.computershare.com/us | |||||||||||||||||||||||||||||||||||||
4 | NextEra Energy | NEE | 21.4% | 11.3% | 32.7% | 23.7% | 2.3% | -4.5% | 12.1% | 0.21 | 36 | 16.4% | up 2SD | 27% | 3.3% | 2.9% | 32% | 37% | 529% | 26% | neg FCF | A- | A/L (3) | $240.11 | 21 | $5,042.31 | $4,521.88 | $109.77 | 219% | 3.3 | 31 | 6.1 | overvalued (2) | 4 | $122 | yes | yes | -25.8% | $0.48 | https://www.computershare.com/us | ||||||||||||||||||||||||||||||||||||||
5 | Amgen | AMGN | 17.9% | 11.9% | 29.8% | 10.4% | 2.9% | 3.4% | 16.9% | 0.95 | 17 | 10.0% | on trendline | 46% | 26.5% | 5.6% | 46% | 51% | 254% | -18% | 41% | A | A-/M (4) | $228.87 | 22 | $5,035.14 | $1,232.61 | $68.08 | 336% | 13.6 | 26 | 5.5 | fairly valued (3) | 2 | $141 | yes | 0.5% | |||||||||||||||||||||||||||||||||||||||||
6 | Waste Management | WM | 16.2% | 3.1% | 19.3% | 20.3% | 2.1% | 2.4% | 6.8% | 0.75 | 26 | 11.6% | up 1SD | 33% | 13.2% | 4.9% | 48% | 50% | 305% | 0% | 43% | A- | B+/M (4) | $101.43 | 49 | $4,970.07 | $1,279.95 | $37.69 | 269% | 6.5 | 35 | 2.9 | yes | overvalued (2) | 3.5 | $53 | yes | 1.4% | ||||||||||||||||||||||||||||||||||||||||
7 | Intel | INTC | 15.4% | 1.7% | 17.1% | 17.7% | 2.2% | 4.2% | 6.8% | 0.8 | 12 | 9.1% | up 1SD | 48% | 23.4% | 5.2% | 19% | 22% | 88% | 16% | 33% | A+ | B+/M (3) | $60.31 | 83 | $5,005.73 | $160.40 | $45.75 | 132% | 3.3 | 21 | 3.5 | yes | undervalued (4) | 3 | $258 | yes | yes | -45.0% | $35.53 | https://www.computershare.com/us | |||||||||||||||||||||||||||||||||||||
8 | American Electric Power | AEP | 14.1% | 1.6% | 15.7% | 12.9% | 3.4% | -6.6% | 5.8% | 0.38 | 22 | 10.3% | on trendline | 33% | 3.7% | 2.9% | 33% | 39% | 561% | 50% | neg FCF | A- | B+/L (3) | $82.44 | 61 | $5,028.84 | $1,082.67 | $57.75 | 143% | 2.1 | 25 | 2.7 | yes | fairly valued (3) | 3 | $50 | yes | -28.5% | ||||||||||||||||||||||||||||||||||||||||
9 | Air Products & Chemicals | APD | 16.7% | -2.5% | 14.2% | 14.3% | 2.3% | 0.0% | 9.1% | 0.88 | 27 | 13.1% | up 1SD | 26% | 12.0% | 5.8% | 17% | 18% | 104% | 19% | 101% | A | A-/M (5) | $230.35 | 22 | $5,067.70 | $2,260.22 | $100.68 | 229% | 4.6 | 42 | 5.8 | overvalued (3) | 4 | $52 | yes | -49.0% | |||||||||||||||||||||||||||||||||||||||||
10 | Target | TGT | 12.3% | 1.3% | 13.6% | 11.3% | 2.3% | 4.8% | 4.9% | 0.8 | 22 | 8.3% | up 2SD | 30% | 11.3% | 5.9% | 32% | 33% | 158% | 18% | 33% | A | B+/M (3) | $115.06 | 43 | $4,947.58 | -$148.96 | $52.10 | 221% | 5.3 | 23 | 0.8 | overvalued (2) | 2 | $59 | yes | yes | -30.9% | ||||||||||||||||||||||||||||||||||||||||
11 | Duke Energy | DUK | 11.0% | 2.6% | 13.6% | 8.9% | 4.4% | -8.4% | 3.5% | 0.33 | 17 | 9.2% | on trendline | 34% | 4.1% | 2.9% | 34% | 38% | 597% | 42% | neg FCF | A- | A-/L (4) | $85.66 | 58 | $4,968.28 | $830.78 | $83.45 | 103% | 1.4 | 21 | 2.6 | yes | undervalued (4) | 3 | $70 | yes | yes | -25.6% | $0.00 | https://www.duk-energy.com/us | |||||||||||||||||||||||||||||||||||||
12 | Coca-Cola | KO | 9.7% | 3.2% | 12.9% | 6.8% | 3.6% | 0.7% | 5.0% | 0.55 | 20 | 8.7% | down 1SD | 25% | 23.8% | 3.3% | 33% | 51% | 360% | -4% | 81% | A+ | B+/L (5) | $46.38 | 108 | $5,009.04 | $410.57 | $14.86 | 312% | 11.0 | 31 | 5.4 | yes | undervalued (4) | 2.5 | $239 | yes | yes | yes | -26.2% | $45.40 | https://www.computershare.com/us | ||||||||||||||||||||||||||||||||||||
13 | Aflac | AFL | 8.3% | 3.8% | 12.1% | 6.1% | 3.1% | 11.9% | -6.5% | 0.89 | 9 | 7.0% | down 1SD | 31% | 3.2% | 4.6% | 4% | 4% | NA | 109% | 14% | A- | A-/M (3) | $36.45 | 137 | $4,993.65 | -$714.66 | $57.37 | 64% | 1.0 | 10 | 1.3 | yes | NA | 2 | $38 | yes | -26.8% | ||||||||||||||||||||||||||||||||||||||||
14 | Procter & Gamble | PG | 10.3% | 0.0% | 10.3% | 11.8% | 2.7% | 1.6% | 3.0% | 0.4 | 63 | 8.3% | up 1SD | 20% | 35.5% | 3.7% | 18% | 26% | 174% | -6% | 63% | AA- | A-/L (4) | $116.72 | 43 | $5,018.96 | -$92.89 | $27.47 | 425% | 6.6 | 36 | 4.3 | yes | overvalued (2) | 2.5 | $311 | yes | yes | yes | -15.8% | $21.92 | https://www.shareowneronline.com/ | ||||||||||||||||||||||||||||||||||||
15 | Walmart | WMT | 12.1% | -5.7% | 6.4% | 13.5% | 1.8% | 2.6% | 2.0% | 0.31 | 22 | 7.2% | up 2SD | 28% | 11.2% | 5.3% | 27% | 31% | 168% | 11% | 42% | AA | B+/L (4) | $124.28 | 40 | $4,971.20 | -$820.68 | $53.41 | 233% | 5.0 | 30 | 0.6 | overvalued (3) | 2 | $330 | yes | yes | yes | 18.0% | $12.60 | https://www.computershare.com/us | |||||||||||||||||||||||||||||||||||||
16 | JPMorgan Chase | JPM | 13.6% | -8.7% | 4.9% | 11.3% | 3.6% | -3.1% | 16.9% | 1.18 | 11 | 9.2% | up 1SD | 39% | 4.3% | 7.0% | 10% | 20% | NA | 62% | neg FCF | A- | A-/L (4) | $95.53 | 52 | $4,967.56 | $1,385.38 | $123.28 | 77% | 1.3 | 14 | 2.8 | yes | fairly valued (3) | 3 | $435 | yes | yes | -27.8% | $32.55 | https://www.computershare.com/us | |||||||||||||||||||||||||||||||||||||
17 | Johnson & Johnson | JNJ | 12.4% | -7.6% | 4.8% | 10.7% | 2.8% | 2.6% | 6.3% | 0.7 | 22 | 9.0% | on trendline | 25% | 28.7% | 5.7% | 17% | 18% | 97% | -6% | 49% | AAA | A-/M (4) | $147.61 | 34 | $5,018.74 | $302.73 | $57.94 | 255% | 6.2 | 31 | 4.7 | yes | overvalued (2) | 3.5 | $386 | yes | yes | yes | -10.3% | $12.00 | https://www.computershare.com/us | ||||||||||||||||||||||||||||||||||||
18 | Comcast | CMCSA | 18.6% | -15.0% | 3.6% | 7.7% | 2.3% | 5.8% | 13.2% | 0.98 | 16 | 10.7% | on trendline | 50% | 22.4% | 6.8% | 40% | 42% | 315% | -46% | 28% | A- | A/M (5) | $38.30 | 131 | $5,017.30 | $1,175.41 | $31.82 | 120% | 2.2 | 16 | 1.7 | yes | undervalued (4) | 2 | $204 | yes | yes | -7.6% | |||||||||||||||||||||||||||||||||||||||
19 | PepsiCo | PEP | 11.1% | -7.9% | 3.2% | 10.1% | 3.2% | 0.1% | 7.8% | 0.59 | 25 | 8.8% | on trendline | 20% | 24.4% | 4.6% | 39% | 43% | 245% | -9% | 98% | A+ | B+/L (5) | $132.59 | 38 | $5,038.42 | $409.05 | $33.54 | 395% | 13.5 | 27 | 2.7 | overvalued (4) | 4 | $191 | yes | yes | -27.8% | ||||||||||||||||||||||||||||||||||||||||
20 | Southern | SO | 10.4% | -8.7% | 1.7% | 11.2% | 4.6% | -7.1% | 3.4% | 0.44 | 17 | 9.0% | on trendline | 20% | 4.8% | 3.5% | 37% | 41% | 553% | 37% | neg FCF | A- | B+/L (3) | $56.39 | 89 | $5,018.71 | $792.74 | $44.36 | 127% | 2.1 | 24 | 2.8 | yes | fairly valued (3) | 4 | $72 | yes | yes | -4.5% | $30.00 | https://www.shareowneronline.com/ | |||||||||||||||||||||||||||||||||||||
21 | Eaton plc | ETN | 13.7% | -13.1% | 0.6% | 8.7% | 3.4% | 4.2% | 6.7% | 1.14 | 17 | 15.4% | up 1SD | 39% | 21.7% | 7.7% | 25% | 27% | 211% | -5% | 42% | A- | A/M (3) | $82.62 | 61 | $5,039.82 | $4,060.11 | $69.63 | 133% | 2.5 | 18 | 1.8 | yes | undervalued (3) | 4 | $42 | -48.7% | |||||||||||||||||||||||||||||||||||||||||
22 | Travelers | TRV | 11.5% | -11.7% | -0.2% | 6.0% | 3.1% | 12.1% | 7.9% | 0.89 | 12 | 9.9% | down 1SD | 32% | 3.3% | 5.9% | 6% | 6% | NA | 73% | 16% | A | B+/M (3) | $105.00 | 48 | $5,040.00 | $938.03 | $140.95 | 96% | 1.4 | 11 | 1.1 | yes | fairly valued (4) | 4 | $35 | yes | yes | -16.0% | |||||||||||||||||||||||||||||||||||||||
23 | BlackRock | BLK | 17.4% | -23.5% | -6.1% | 12.3% | 2.8% | 0.9% | 11.0% | 1.28 | 20 | 16.4% | down 1SD | 37% | 4.3% | 9.6% | 3% | 3% | 79% | 1% | 75% | AA- | A/M (5) | $508.15 | 10 | $5,081.50 | $4,741.99 | $348.86 | 142% | 2.5 | 22 | 5.9 | yes | undervalued (3) | 4 | $86 | yes | -38.1% | ||||||||||||||||||||||||||||||||||||||||
24 | U.S. Bancorp | USB | 8.2% | -14.7% | -6.5% | 0.3% | 4.5% | 5.8% | 10.5% | 1.17 | 10 | 5.9% | down 2SD | 31% | 4.8% | 7.8% | 8% | 13% | NA | 60% | 34% | A+ | A/L (4) | $35.68 | 140 | $4,995.20 | $167.71 | $54.41 | 109% | 1.8 | 10 | 4.0 | yes | undervalued (4) | 3 | $85 | yes | -21.2% | ||||||||||||||||||||||||||||||||||||||||
25 | Emerson Electric | EMR | 6.8% | -14.3% | -7.5% | 5.7% | 3.3% | 2.9% | 1.6% | 1.51 | 18 | 7.3% | down 1SD | 27% | 31.6% | 9.9% | 21% | 28% | 145% | -2% | 50% | A | A/M (3) | $57.22 | 87 | $4,978.14 | -$261.98 | $33.54 | 224% | 5.7 | 18 | 2.6 | undervalued (4) | 2 | $45 | yes | yes | -35.4% | ||||||||||||||||||||||||||||||||||||||||
26 | Caterpillar | CAT | 10.5% | -19.4% | -8.9% | 11.2% | 3.4% | 2.5% | 8.0% | 1.08 | 13 | 10.8% | down 1SD | 43% | 14.4% | 7.8% | 34% | 49% | 340% | 10% | 50% | A | B+/M (2) | $117.67 | 42 | $4,942.14 | $1,428.88 | $80.03 | 182% | 5.4 | 23 | 1.5 | yes | fairly valued (3) | 3 | $74 | yes | yes | yes | -38.4% | $12.48 | https://www.computershare.com/us | ||||||||||||||||||||||||||||||||||||
27 | 3M | MMM | 10.0% | -19.1% | -9.1% | 3.3% | 3.8% | 2.0% | 9.1% | 0.99 | 19 | 8.3% | down 1SD | 32% | 32.0% | 8.5% | 41% | 48% | 239% | -11% | 62% | AA- | A/M (4) | $151.21 | 33 | $5,023.00 | $548.28 | $58.15 | 260% | 8.9 | 19 | 2.8 | fairly valued (3) | 3 | $104 | yes | yes | yes | -31.8% | $0.00 | https://www.shareowneronline.com/ | |||||||||||||||||||||||||||||||||||||
28 | PNC Financial Services | PNC | 9.8% | -19.0% | -9.2% | 6.2% | 4.2% | 6.7% | 18.7% | 1.28 | 11 | 7.2% | on trendline | 36% | 4.8% | 7.6% | 8% | 15% | NA | 77% | 31% | A- | A/M (4) | $107.00 | 47 | $5,029.00 | $1,075.93 | $161.19 | 96% | 1.5 | 12 | 4.0 | yes | undervalued (3) | 3 | $66 | -25.4% | |||||||||||||||||||||||||||||||||||||||||
29 | MetLife | MET | 5.5% | -18.8% | -13.3% | 0.4% | 4.9% | 24.9% | 4.6% | 1.35 | 4 | 3.9% | down 1SD | 36% | 1.0% | 6.7% | 3% | 261% | NA | 164% | 13% | A- | B+/M (4) | $35.21 | 142 | $4,999.82 | -$609.94 | $111.86 | 45% | 0.7 | 8 | 0.7 | yes | undervalued (4) | 2 | $47 | yes | -43.4% | ||||||||||||||||||||||||||||||||||||||||
30 | Wells Fargo | WFC | 3.9% | -24.1% | -20.2% | -9.9% | 7.3% | 8.5% | 7.4% | 1.16 | 10 | 3.9% | down 2SD | 33% | 5.2% | 6.8% | 10% | 18% | NA | 122% | 33% | A- | A-/M (3) | $27.43 | 182 | $4,992.26 | $396.51 | $60.62 | 88% | 1.2 | 7 | 2.4 | yes | undervalued (5) | 3 | $198 | yes | -2.4% | ||||||||||||||||||||||||||||||||||||||||
31 | International Business Machines | IBM | 3.0% | -25.9% | -22.9% | -1.6% | 5.4% | 5.7% | 7.1% | 1.23 | 12 | 4.5% | down 1SD | 33% | 15.5% | 8.3% | 38% | 45% | 377% | -48% | 46% | A | A-/M (4) | $122.93 | 41 | $5,040.13 | -$256.89 | $71.54 | 172% | 5.4 | 10 | 1.4 | yes | undervalued (3) | 1 | $120 | yes | yes | yes | -22.2% | $14.88 | https://www.computershare.com/us | ||||||||||||||||||||||||||||||||||||
32 | Average | n = 30 | 11.9% | -5.4% | 6.5% | 8.8% | 3.5% | 3.0% | 7.4% | 0.847 | 18.7 | 9.1% | on trendline | 34% | 14.9% | 5.8% | 24% | 38% | 274% | 24% | 49% | A | A-/M (4) | $117.45 | $5,010.11 | $852.98 | $74.92 | 187% | 4.5 | 21 | 3.1 | 17/30 | 5/30 | fairly valued (3) | 2.8 | $142 | 20/30 | 23/30 | 12/30 | -24.2% | $14.34 | |||||||||||||||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
34 | BENCHMARKS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
35 | Berkshire Hathaway | BRK-B | 8.6% | 3.0% | 11.6% | 5.9% | 0.0% | no dividend | 0.77 | 44 | 7.9% | down 1SD | 24% | 24.0% | 4.6% | 5.1% | 12% | 14% | 254% | 71% | no dividend | AA | B+/L (3) | $183.37 | $24.00 | $5,086.08 | -$346.57 | $118.67 | 155% | 1.2 | 14.0 | 1.8 | yes | undervalued (4) | 2 | $441 | yes | -31.8% | ||||||||||||||||||||||||||||||||||||||||
36 | Vanguard Utilities Index ETF | VPU | 11.8% | -1.9% | 9.9% | 9.8% | 3.0% | 4.5% | 0.46 | 19 | $5 | -29.6% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
37 | SPDR S&P 500 ETF | SPY | 13.0% | -6.4% | 6.6% | 9.8% | 1.9% | 4.5% | 8.0% | 1 | 22 | 6.2% | up 1SD | 32% | 32.0% | $322.22 | $16.00 | $5,155.52 | -$754.28 | 3.3 | $271 | -38.3% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
38 | SPDR Dow Jones Indust Avg ETF | DIA | 12.2% | -5.7% | 6.5% | 9.6% | 2.3% | 9.9% | 0.99 | 19 | 5.8% | up 1SD | 28% | 28.0% | $285.40 | $18.00 | $5,137.20 | -$608.30 | 4.1 | $20 | -34.0% | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
39 | Vanguard High Dividend Yield ETF | VYM | 11.4% | -5.9% | 5.5% | 6.1% | 3.4% | 6.9% | 0.93 | 16 | $93.02 | 2.5 | $34 | -34.3% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
40 | Vanguard Total Bond Market ETF | BND | 3.9% | 0.0% | 3.9% | 4.0% | 2.5% | -1.9% | 1.01 | NA | 4.3% | on trendline | 8% | 8.0% | $84.31 | NA | $269 | 2.1% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
41 | iShares Russell Top 200 Value ETF | IWX | 9.8% | -6.4% | 3.4% | 5.0% | 3.1% | 8.8% | 0.96 | 14 | $58.21 | 2 | $27 | NA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
42 | Average | n = 7 | 10.1% | -3.3% | 6.8% | 7.2% | 2.3% | 0.8742857143 | 22 | 6.1% | on trendline | 23% | #DIV/0! | $19.33 | $5,146.36 | 1.6 | $152 | -27.7% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
44 | Consumer Price Index | cpi | 1.6% | 1.5% | 3.1% | 1.6% | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
46 | Updated 6/19/2020 |