GARP US Stock Screener v1.5: 03-05-2010

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%

Excel Stock Valuation Spreadsheet Last Weekly Update:
03-05-2010

Credits:
Stock Market Functions Add-in
Old School Value
DRiP Investing
Damodaran Online
MorningStar
L’investisseur heureux

Important:
Frequently Asked Questions
Disclaimer