| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Large S&P 500 Companies | Ticker | ann div rate | P/E | Price/ Book | Debt/ Equity | 5 yr Beta | EV/ EBITDA | EV/ Revenue | |
2 | 1 | 3M | MMM | 2.90% | 13.3 | 3.2 | 32% | 0.9 | 7.6 | 1.9 |
3 | 2 | Abbott Laboratories | ABT | 3.60% | 16.0 | 3.1 | 69% | 0.3 | 8.8 | 2.4 |
4 | 3 | Chevron | CVX | 3.20% | 8.5 | 1.7 | 10% | 0.8 | 4.1 | 0.9 |
5 | 4 | Coca-Cola | KO | 2.80% | 12.6 | 4.4 | 74% | 0.6 | 14.5 | 4.0 |
6 | 5 | Colgate-Palmolive | CL | 2.50% | 18.7 | 14.9 | 159% | 0.5 | 11.6 | 3.0 |
7 | 6 | Emerson | EMR | 3.00% | 14.3 | 3.2 | 47% | 1.2 | 7.8 | 1.6 |
8 | 7 | ExxonMobil | XOM | 2.50% | 10.2 | 2.4 | 10% | 0.5 | 5.8 | 1.0 |
9 | 8 | General Dynamics | GD | 3.10% | 8.9 | 1.6 | 23% | 1.3 | 5.3 | 0.7 |
10 | 9 | Johnson & Johnson | JNJ | 3.60% | 15.4 | 2.8 | 30% | 0.6 | 8.5 | 2.6 |
11 | 10 | Lowe's | LOW | 2.70% | 14.1 | 1.6 | 39% | 1.1 | 6.0 | 0.7 |
12 | 11 | McDonald's | MCD | 3.10% | 17.9 | 6.1 | 82% | 0.4 | 11.1 | 4.0 |
13 | 12 | Medtronic | MDT | 2.90% | 11.5 | 2.1 | 62% | 1.0 | 7.8 | 2.6 |
14 | 13 | Norfolk Southern | NSC | 2.60% | 14.2 | 2.2 | 67% | 1.1 | 8.0 | 2.9 |
15 | 14 | Occidentental Petroleum | OXY | 2.30% | 11.4 | 1.9 | 12% | 1.1 | 5.5 | 3.1 |
16 | 15 | Pepsico | PEP | 3.40% | 16.0 | 4.1 | 112% | 0.6 | 9.8 | 2.0 |
17 | 16 | Procter & Gamble | PG | 3.30% | 16.5 | 2.7 | 47% | 0.5 | 11.2 | 2.5 |
18 | 17 | Target | TGT | 2.30% | 12.5 | 2.4 | 117% | 0.9 | 7.1 | 0.8 |
19 | 18 | United Technologies | UTX | 2.60% | 14.4 | 3.0 | 47% | 1.1 | 7.7 | 1.3 |
20 | 19 | Walgreen | WAG | 2.70% | 11.3 | 2.0 | 16% | 1.1 | 6.1 | 0.4 |
21 | 20 | Wal*Mart | WMT | 2.70% | 11.8 | 2.8 | 78% | 0.4 | 7.1 | 0.6 |
22 | ||||||||||
23 | Smaller S&P 500 Companies: | |||||||||
24 | 21 | Aflac | AFL | 3.10% | 10.7 | 1.6 | 28% | 2.1 | 7.0 | 1.0 |
25 | 22 | Air Products | APD | 2.80% | 15.4 | 2.8 | 70% | 1.2 | 8.8 | 2.2 |
26 | 23 | Automatic Data Proc | ADP | 2.90% | 20.3 | 4.2 | 0.6% | 0.7 | 11.1 | 2.4 |
27 | 24 | Becton Dickinson | BDX | 2.20% | 12.0 | 3.1 | 51% | 0.6 | 7.6 | 2.2 |
28 | 25 | Dover | DOV | 2.30% | 11.6 | 2.0 | 45% | 1.3 | 7.3 | 1.4 |
29 | 26 | Harris | HRS | 3.10% | 12.5 | 1.8 | 82% | 0.6 | 4.9 | 1.0 |
30 | 27 | Kimberly-Clark | KMB | 3.90% | 17.0 | 5.1 | 128% | 0.4 | 9.8 | 1.7 |
31 | 28 | Linear Technology | LLTC | 3.20% | 12.1 | 14.0 | 155% | 1.0 | 8.3 | 4.6 |
32 | 29 | McCormick | MKC | 2.40% | 16.9 | 3.7 | 60% | 0.4 | 11.5 | 2.0 |
33 | 30 | NextEra Energy | NEE | 4.00% | 12.4 | 1.6 | 145% | 0.5 | 8.9 | 2.9 |
34 | 31 | Sysco Corp | SYY | 4.00% | 13.5 | 3.3 | 57% | 0.7 | 7.6 | 0.5 |
35 | 32 | T Rowe Price | TROW | 2.40% | 18.8 | 4.0 | 0% | 1.8 | 10.0 | 4.8 |
36 | ||||||||||
37 | EV: Enterprise Value (market value of common & preferred stock and debt minus cash equivalents) | |||||||||