| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | Div Yield | Free Cash Flow Yield | 5-Yr Div Growth/Yr | 5-Yr Beta | P/E (TTM) | BMW Method: 20-Yr Px CAGR | Current Px Trend | Px loss post regression to 20-yr mean CAGR from +2SD | Return on Tangible Capital Employed | WACC | L-T Debt: Total Assets | Total Debt: Total Assets | Total Debt: EBITDA (mrq) | L-T Debt:Equity Ratio (mrq) | TBV:Px (mrq) | Div: FCF | S&P Bond Rating | S&P Stock Rating | Px (50d MA) | 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 | 5-yr PEG ratio (Yahoo Finance) | Value Stock | Overpriced Stock | Morningstar (Stars) | SCORE: Basic Quality Screen | Market Cap ($B) | Dividend Achiever | 2008 Price Return | |
2 | Merck | MRK | 12.2% | 35.8% | 48.0% | 14.3% | 2.9% | 1.8% | 5.9% | 0.47 | 21 | 8.1% | up 1SD | 44% | 28.4% | 2.6% | 28% | 32% | 155% | 0.95 | -3.5% | 57% | AA- | B+/M (5) | $82.43 | 61 | $5,028.23 | $12.49 | $31.75 | 258% | 7.7 | 37 | 4.5 | 1.35 | yes | undervalued (4) | 3 | $215 | -47.7% | |||
3 | Pfizer | PFE | 11.7% | 20.5% | 32.2% | 6.7% | 4.1% | 1.1% | 6.4% | 0.66 | 15 | 6.2% | on trendline | 46% | 24.8% | 4.2% | 22% | 32% | 259% | 0.79 | -15.2% | 80% | AA- | A-/M (4) | $37.43 | 134 | $5,015.62 | -$239.18 | $25.67 | 145% | 3.1 | 19 | 4.1 | 2.46 | yes | undervalued (4) | 2 | $205 | -22.1% | |||
4 | Amgen | AMGN | 18.6% | 11.9% | 30.5% | 15.2% | 2.6% | 3.4% | 16.0% | 0.85 | 20 | 10.8% | up 1SD | 46% | 42.6% | 4.3% | 46% | 51% | 254% | 3.20 | -16.7% | 41% | A- | A-/M (4) | $247.25 | 20 | $4,945.00 | $1,419.29 | $70.76 | 350% | 13.5 | 28 | 6.0 | 1.61 | overvalued (2) | 2 | $144 | 0.5% | ||||
5 | Target | TGT | 14.4% | 1.3% | 15.7% | 18.2% | 1.8% | 4.8% | 4.6% | 0.87 | 22 | 9.6% | up 2SD | 31% | 11.2% | 6.0% | 32% | 33% | 158% | 1.31 | 14.9% | 33% | A | B+/M (3) | $136.77 | 37 | $5,060.49 | $246.24 | $62.56 | 216% | 5.9 | 27 | 0.9 | 2.47 | overvalued (1) | 3 | $74 | yes | -30.9% | |||
6 | Intel | INTC | 13.4% | 1.7% | 15.1% | 13.7% | 2.7% | 4.2% | 6.7% | 0.71 | 9 | 8.5% | up 1SD | 45% | 23.5% | 4.0% | 19% | 22% | 88% | 0.44 | 18.9% | 33% | A+ | B+/M (3) | $51.45 | 97 | $4,990.65 | $53.41 | $48.58 | 107% | 2.6 | 19 | 2.7 | 1.71 | yes | undervalued (4) | 3 | $211 | -45.0% | |||
7 | Texas Instruments | TXN | 20.6% | -9.5% | 11.1% | 26.1% | 2.6% | 2.3% | 21.5% | 1.13 | 26 | 13.1% | up 1SD | 51% | 44.9% | 7.2% | 31% | 34% | 86% | 0.82 | 3.2% | 52% | A+ | A/M (3) | $136.37 | 37 | $5,045.69 | $2,996.72 | $31.64 | 397% | 16.4 | 37 | 9.5 | 2.25 | yes | fairly valued (3) | 2.5 | $133 | yes | -53.5% | ||
8 | Comcast | CMCSA | 19.9% | -15.0% | 4.9% | 12.3% | 2.0% | 5.8% | 13.1% | 0.96 | 19 | 11.5% | on trendline | 50% | 22.5% | 5.2% | 40% | 42% | 315% | 1.27 | -39.5% | 28% | A- | A/M (5) | $43.54 | 115 | $5,007.10 | $1,424.36 | $32.02 | 135% | 2.4 | 18 | 2.0 | 1.27 | yes | undervalued (3) | 3 | $207 | yes | -7.6% | ||
9 | Lockheed Martin | LMT | 22.4% | -18.4% | 4.2% | 16.3% | 2.4% | 3.0% | 9.9% | 0.93 | 17 | 16.0% | on trendline | 41% | 25.7% | 6.5% | 26% | 29% | 136% | 3.25 | -10.1% | 44% | A- | A/M (5) | $384.33 | 13 | $4,996.29 | $4,178.26 | $83.23 | 458% | 28.3 | 31 | 1.7 | 1.79 | yes | fairly valued (4) | 3 | $108 | yes | -20.1% | ||
10 | United Parcel Service | UPS | 12.9% | -18.2% | -5.3% | 14.6% | 2.5% | -0.9% | 6.9% | 1 | 32 | 8.2% | up 2SD | 27% | 16.4% | 6.3% | 42% | 49% | 247% | 5.88 | -2.0% | 141% | A- | B+/M (4) | $146.31 | 34 | $4,974.54 | $15.53 | $23.93 | 600% | 31.6 | 30 | 1.8 | 2.39 | overvalued (2) | 2 | $145 | -22.0% | ||||
11 | Average | n = 9 | 16.2% | 1.1% | 17.4% | 15.3% | 2.6% | 2.8% | 10.1% | 0.84 | 20 | 10.2% | up 1SD | 42% | 26.7% | 5.1% | 31% | 35% | 189% | 1.99 | -6% | 57% | A | A-/M (4) | $140.65 | $5,013.25 | $1,123.01 | $45.57 | 296% | 12.4 | 27 | 3.7 | 1.92 | 3/9 | 3/9 | fairly valued (3) | 2.6 | $160 | 4/9 | -27.6% | ||
12 | ||||||||||||||||||||||||||||||||||||||||||
13 | BENCHMARKS | |||||||||||||||||||||||||||||||||||||||||
14 | Berkshire Hathaway | BRK-B | 9.7% | 3.0% | 12.7% | 9.9% | 0.0% | 4.1% | 0.0% | 0.81 | 21 | 8.8% | on trendline | 24% | 4.7% | 5.4% | 12% | 14% | 254% | no L-T Debt | 58.5% | no dividend | AA | B+/L (3) | $206.36 | 24 | $4,952.64 | -$752.45 | $183.43 | 113% | 1.3 | 16 | 2.0 | 3.00 | yes | undervalued (3) | 3 | $525 | -31.8% | |||
15 | SPDR S&P 500 ETF Trust | SPY | 13.4% | -6.4% | 7.0% | 13.6% | 1.8% | 4.5% | 7.3% | 1 | 28 | 6.7% | up 1SD | 32% | 0.07 | $333.85 | 15 | $5,007.75 | -$866.54 | $152.54 | 219% | 3.8 | 29 | 2.4 | $274 | -38.3% | ||||||||||||||||
16 | SPDR DJIA ETF Trust | DIA | 12.2% | -5.7% | 6.5% | 13.3% | 2.3% | 5.1% | 8.3% | 0.99 | 20 | 6.2% | up 1SD | 28% | NA | $274.96 | 18 | $4,949.28 | -$797.57 | NA | NA | NA | NA | NA | $22 | -34.0% | ||||||||||||||||
17 | Average | n = 3 | 11.8% | -3.0% | 8.7% | 12.3% | 1.4% | 4.6% | 5.2% | 0.93 | 22 | 7.2% | up 1SD | 28% | 0.07 | $271.72 | $4,969.89 | -$832.06 | $274 | -34.7% | ||||||||||||||||||||||
18 | ||||||||||||||||||||||||||||||||||||||||||
19 | Consumer Price Index | cpi | 1.9% | 1.5% | 3.4% | 2.2% | ||||||||||||||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||||||||||||||||||
21 | Updated 9/26/2020 | |||||||||||||||||||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||||||||||||||||||
24 | ||||||||||||||||||||||||||||||||||||||||||
25 | ||||||||||||||||||||||||||||||||||||||||||
26 | ||||||||||||||||||||||||||||||||||||||||||
27 |