with Old Shool Value Premium Stock Spreadsheets v6.1.0
| Summary | Valuation Margin of Safety | MorningStar | Summary | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Ticker | Cap $B Yield |
Beta CAPM |
Asset | EPV | DCF | Graham | H | G | P | Industry | |
| WIN | 4.7 9.6 |
1.0 7.7 |
9% 11.3 |
-14% 8.9 |
4520% 479.0 |
-67% 3.4 |
C | C | A | Telecom Services | |
| BAX | 36 2.0 |
0.4 5.1 |
-64% 21.4 |
27% 75.6 |
349% 266.9 |
-43% 33.8 |
A | C | A | Medical Instruments & Supplies | |
| GMT | 1.3 4.0 |
1.6 10.3 |
202% 85.0 |
178% 78.2 |
-67% 9.3 |
C | C | C | Rental & Leasing Services | ||
| FUN | 0.6 9.0 |
1.1 8.3 |
202% 33.5 |
172% 30.2 |
-34% 7.3 |
C | B | D | General Entertainment | ||
| ROP | 5.3 0.7 |
0.7 6.4 |
-43% 32.0 |
-12% 49.8 |
133% 131.6 |
-78% 12.3 |
B | B | C | Industrial Equipment & Components | |
| ABT | 84 3.2 |
0.2 4.3 |
-52% 25.9 |
51% 82.3 |
122% 120.7 |
-60% 21.7 |
A | C | B | Drug Manufacturers - Major | |
| JKHY | 2.0 1.6 |
0.7 6.6 |
-69% 7.2 |
-23% 18.2 |
120% 52.2 |
-40% 14.3 |
A | C | C | Business Services | |
| PG | 185 2.8 |
0.6 6.0 |
-50% 32.0 |
14% 72.7 |
101% 127.9 |
-24% 48.6 |
A | C | C | Personal Products | |
| PFE | 141 4.1 |
0.7 6.6 |
91% 33.4 |
-58% 7.3 |
C | C | C | Drug Manufacturers - Major | |||
| JNJ | 176 3.1 |
0.6 5.9 |
90% 121.9 |
-9% 58.4 |
A | C | A | Drug Manufacturers - Major | |||
| SYK | 22 1.1 |
0.9 7.6 |
-68% 17.6 |
1% 55.6 |
87% 102.9 |
-24% 42.1 |
A | C | C | Medical Appliances & Equipment | |
| VLGEA | 0.4 3.5 |
0.2 4.5 |
27% 34.3 |
174% 74.3 |
80% 48.8 |
-24% 20.6 |
B | C | C | Grocery Stores | |
| SHW | 7.1 2.2 |
0.7 6.5 |
-41% 38.6 |
80% 117.5 |
77% 115.6 |
25% 81.4 |
A | C | A | Specialty Retail, Other | |
| GD | 28 2.3 |
1.2 8.8 |
-67% 24.1 |
-10% 66.0 |
68% 123.8 |
5% 77.5 |
A | C | C | Aerospace & Defense Products & Services | |
| XOM | 314 2.5 |
0.4 5.3 |
-67% 22.1 |
123% 147.9 |
20% 79.6 |
102% 134.5 |
A | B | A | Major Integrated Oil & Gas | |
| ITW | 24 2.6 |
1.0 8.0 |
-52% 22.8 |
-7% 43.9 |
15% 54.3 |
-3% 46.1 |
A | C | C | Diversified Machinery | |
| Summary | Avg Ratios Margin of Safety | MorningStar | Summary | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Ticker | Cap $B Yield |
Beta CAPM |
P/E Ratio 5 Yr Avg | Price to Sales 5 Yr Avg | Price to Book 5 Yr Avg | Price to Cash Flow 3 Yr Avg | H | G | P | Industry | |
| FUN | 0.6 9.0 |
1.1 8.3 |
17.8 |
109% 0.7 |
0.0 |
254% 3.6 |
C | B | D | General Entertainment | |
| GMT | 1.3 4.0 |
1.6 10.3 |
16.2 |
39% 1.1 |
42% 1.1 |
4.2 |
C | C | C | Rental & Leasing Services | |
| GD | 28 2.3 |
1.2 8.8 |
21% 11.8 |
25% 0.9 |
19% 2.3 |
-12% 9.5 |
A | C | C | Aerospace & Defense Products & Services | |
| SYK | 22 1.1 |
0.9 7.6 |
24% 19.5 |
16% 3.2 |
38% 3.3 |
1% 14.4 |
A | C | C | Medical Appliances & Equipment | |
| JNJ | 176 3.1 |
0.6 5.9 |
12% 14.5 |
13% 2.8 |
24% 3.5 |
74% 11.6 |
A | C | A | Drug Manufacturers - Major | |
| JKHY | 2.0 1.6 |
0.7 6.6 |
7% 18.2 |
12% 2.6 |
7% 2.9 |
46% 11.3 |
A | C | C | Business Services | |
| PG | 185 2.8 |
0.6 6.0 |
10% 18.0 |
12% 2.4 |
5% 2.8 |
2% 13.4 |
A | C | C | Personal Products | |
| XOM | 314 2.5 |
0.4 5.3 |
-26% 16.4 |
11% 1.0 |
29% 2.8 |
-23% 9.8 |
A | B | A | Major Integrated Oil & Gas | |
| ABT | 84 3.2 |
0.2 4.3 |
62% 14.6 |
10% 2.7 |
25% 3.7 |
68% 10.7 |
A | C | B | Drug Manufacturers - Major | |
| VLGEA | 0.4 3.5 |
0.2 4.5 |
-33% 22.0 |
3% 0.3 |
2% 1.9 |
-79% 8.7 |
B | C | C | Grocery Stores | |
| BAX | 36 2.0 |
0.4 5.1 |
24% 16.4 |
2% 2.8 |
5% 4.9 |
12.5 |
A | C | A | Medical Instruments & Supplies | |
| ITW | 24 2.6 |
1.0 8.0 |
-30% 24.1 |
1% 1.7 |
9% 2.7 |
-17% 15.2 |
A | C | C | Diversified Machinery | |
| SHW | 7.1 2.2 |
0.7 6.5 |
-16% 17.2 |
0% 1.0 |
-12% 5.6 |
-23% 11.7 |
A | C | A | Specialty Retail, Other | |
| ROP | 5.3 0.7 |
0.7 6.4 |
-4% 21.6 |
-6% 2.6 |
21% 2.2 |
6% 15.2 |
B | B | C | Industrial Equipment & Components | |
| WIN | 4.7 9.6 |
1.0 7.7 |
-1% 13.4 |
-17% 1.6 |
-31% 17.2 |
357% 5.4 |
C | C | A | Telecom Services | |
| PFE | 141 4.1 |
0.7 6.6 |
-7% 18.8 |
-23% 4.0 |
-65% 6.6 |
80% 16.2 |
C | C | C | Drug Manufacturers - Major | |
| Summary | High/Low Prices Margin of Safety | MorningStar | Summary | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Ticker | Cap $B Yield |
F-Score Z-Score |
80 Days Support | 80 Days Resistance | 52 Weeks Low | 52 Weeks High | H | G | P | Industry | |
| VLGEA | 0.4 3.5 |
6.0 6.6 |
-9% 24.7 |
15% 31.2 |
-9% 24.6 |
22% 33.1 |
B | C | C | Grocery Stores | |
| XOM | 314 2.5 |
3.0 5.0 |
-3% 64.3 |
15% 76.5 |
-7% 61.9 |
15% 76.5 |
A | B | A | Major Integrated Oil & Gas | |
| PFE | 141 4.1 |
5.0 1.5 |
-3% 16.9 |
14% 20.0 |
-30% 12.3 |
16% 20.4 |
C | C | C | Drug Manufacturers - Major | |
| FUN | 0.6 9.0 |
5.0 0.8 |
-45% 6.1 |
15% 12.8 |
-48% 5.8 |
22% 13.6 |
C | B | D | General Entertainment | |
| WIN | 4.7 9.6 |
5.0 1.1 |
-5% 9.9 |
12% 11.6 |
-39% 6.3 |
12% 11.7 |
C | C | A | Telecom Services | |
| GMT | 1.3 4.0 |
5.0 0.9 |
-8% 26.0 |
8% 30.5 |
-52% 13.6 |
11% 31.3 |
C | C | C | Rental & Leasing Services | |
| ABT | 84 3.2 |
6.0 3.5 |
-5% 51.5 |
4% 56.2 |
-24% 41.3 |
5% 56.8 |
A | C | B | Drug Manufacturers - Major | |
| ITW | 24 2.6 |
4.0 4.1 |
-11% 42.2 |
8% 51.0 |
-46% 25.6 |
8% 51.2 |
A | C | C | Diversified Machinery | |
| BAX | 36 2.0 |
7.0 4.2 |
-9% 54.3 |
4% 61.7 |
-24% 45.5 |
4% 61.9 |
A | C | A | Medical Instruments & Supplies | |
| JKHY | 2.0 1.6 |
7.0 5.5 |
-10% 21.3 |
2% 24.2 |
-40% 14.3 |
4% 24.8 |
A | C | C | Business Services | |
| JNJ | 176 3.1 |
6.0 4.9 |
-6% 60.3 |
2% 65.3 |
-28% 46.2 |
3% 66.0 |
A | C | A | Drug Manufacturers - Major | |
| SYK | 22 1.1 |
4.0 8.1 |
-14% 47.5 |
3% 57.0 |
-44% 30.8 |
4% 57.4 |
A | C | C | Medical Appliances & Equipment | |
| SHW | 7.1 2.2 |
-11% 58.0 |
1% 65.6 |
-35% 42.2 |
1% 65.7 |
A | C | A | Specialty Retail, Other | ||
| GD | 28 2.3 |
7.0 3.1 |
-11% 65.6 |
0% 74.0 |
-52% 35.3 |
1% 74.7 |
A | C | C | Aerospace & Defense Products & Services | |
| PG | 185 2.8 |
6.0 3.3 |
-6% 59.8 |
0% 63.9 |
-31% 43.9 |
1% 64.2 |
A | C | C | Personal Products | |
| ROP | 5.3 0.7 |
6.0 3.0 |
-11% 50.1 |
-1% 55.8 |
-35% 36.8 |
0% 56.3 |
B | B | C | Industrial Equipment & Components | |
Legend:
Financial Health
Growth
Profitability
Risk Free Rate: 3.41%
US Equity Market Risk Premium: 4.44%
S&P 500 Ratios
P/E: 20.2
Price/Book: 3.94
Price/Sales: 2.17
Price/Cash Flow: 14.40
Dividend Yield: 2.00%
Credits:
Stock Market Functions Add-in
Old School Value
DRiP Investing
Damodaran Online
MorningStar
L’investisseur heureux
Important:
Frequently Asked Questions
Disclaimer