Thursday, December 27, 2018

Top 200 List 12/27/18

Top 200 List 12/27/18

Well, I felt like running a top 200 list this morning.  We've been in/near bear territory, so some stocks are probably starting to look like pretty good buys.  I am also going to compare this run with run I did 2 weeks ago, just to see what changed.

This is my version of the official magic formula screener from Joel Greenblatt's book.  I believe I come very close to matching the actual calculations.  When I first developed this, the official screen gave more earnings yield and ROIC data - so that is a large reason for confidence.

The formula details can be found in my blog post "The Calculation" if you want to see more.  I had a lot of help developing it from people on the Yahoo MFI board back in the day.  Also Randy Harmelink, of SMF fame, helped me automate workbook once the formulae were all working well.

I do give more info than official site.  I use Fidelity for data source and they use Compustat, so that matches what official website uses.  I do provide earnings yield and ROIC.  I also typically have more names as I do not throw out as many non-US firms and I keep some insurers and investment firms.


Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC
SIGA 1            7.08            587 64% 71876%
FNJN 2            2.37            135 55% 20682%
NHTC 3         19.29            218 32% 3713%
IMMR 4            8.82            271 32% 1811%
LTRPA 5         15.82         1,187 105% 792%
AKG 6            0.58            131 27% 16301%
BPT 7         19.76            423 23% 49074%
CMCM 8            6.41            923 22% 921%
ACOR 9         15.68            740 26% 335%
NKTR 10         32.78         5,661 17% 1729%
UIS 11         11.31            585 32% 233%
MSB 12         23.65            310 15% 21815%
MOH 13       114.76         7,792 15% 381%
IDCC 14         64.93         2,312 13% 2120%
CJREF 15            3.20            674 17% 207%
DLX 16         38.90         1,821 14% 336%
LEXEA 17         39.28         2,239 23% 152%
YY 18         60.45         3,919 16% 190%
MCFT 19         18.62            349 14% 247%
UTHR 20       105.85         4,657 22% 123%
EGOV 21         12.43            828 13% 411%
FTSI 22            6.77            740 37% 102%
EGY 23            1.38               84 42% 101%
BPI 24            6.78            187 28% 105%
TVTY 25         24.77         1,061 12% 893%
HRB 26         24.84         5,105 12% 313%
AGX 27         37.86            594 19% 119%
PBT 28            5.87            274 11% 15329%
AEIS 29         41.42         1,623 17% 124%
VIAB 30         26.27       10,595 14% 141%
MSGN 31         23.03         1,743 12% 272%
DHX 32            1.41               71 18% 108%
KLAC 33         86.05       13,431 13% 205%
GILD 34         63.22       82,629 12% 255%
AMAT 35         30.64       30,150 15% 115%
LRCX 36       130.84       21,631 15% 110%
VIA 37         29.15       11,756 14% 141%
SQBG 38            0.70               45 13% 145%
GME 39         12.40         1,267 27% 76%
HEAR 40         14.57            236 17% 93%
VEC 41         20.94            239 18% 91%
PETS 42         23.71            487 14% 126%
DFIN 43         13.78            471 13% 136%
EAF 44         11.62         3,441 16% 95%
HSII 45         30.55            593 12% 161%
QIWI 46         13.88            849 10% 422%
WDC 47         36.93       11,005 21% 76%
STX 48         37.91       11,070 14% 109%
ESIO 49         29.95         1,077 13% 120%
TUP 50         32.23         1,592 14% 102%
TGS 51         13.61         2,142 14% 105%
UEPS 52            4.48            251 22% 73%
WU 53         17.01         7,637 10% 416%
HPQ 54         20.33       32,487 11% 197%
DXC 55         52.13       14,898 15% 91%
CO 56            6.03            670 104% 62%
INVA 57         16.74         1,898 10% 369%
IPG 58         20.35         7,904 11% 176%
SP 59         28.52            645 10% 295%
CECO 60         11.43            821 10% 234%
ALSN 61         42.83         5,611 11% 161%
MOMO 62         24.22         5,400 10% 944%
TPR 63         33.89            143 69% 63%
MKSI 64         61.57         3,384 17% 72%
STRL 65         10.53            287 19% 65%
THO 66         50.48         2,670 22% 63%
CELG 67         62.50       44,981 10% 356%
SGH 68         28.88            672 20% 63%
LGORF 69            2.08         1,348 14% 88%
NANO 70         26.93            659 16% 72%
GPP 71         13.76            438 11% 133%
SHI 72         43.83         4,745 35% 56%
AMCX 73         53.87         3,113 13% 89%
ZAGG 74            9.10            260 20% 60%
BKE 75         19.27            937 18% 63%
SYX 76         23.60            894 11% 117%
CRTO 77         23.34         1,602 13% 86%
HCC 78         23.91         1,260 27% 56%
KLIC 79         19.37         1,330 23% 57%
VGR 80            9.66         1,348 10% 255%
PFMT 81            1.45               76 18% 61%
KORS 82         37.76         5,728 14% 76%
SJT 83            5.05            235 9% 422%
TGNA 84         10.92         2,363 11% 118%
BBY 85         51.57       14,404 13% 78%
NVMI 86         21.92            631 13% 86%
CASA 87         12.44         1,145 10% 162%
MU 88         30.89       36,265 45% 52%
WGO 89         23.14            736 17% 61%
OMC 90         71.59       16,172 9% 294%
MO 91         48.43       91,194 9% 509%
LPX 92         21.53         3,098 27% 53%
MAN 93         65.16         4,235 18% 58%
MBUU 94         33.99            705 10% 142%
KFY 95         39.63         2,229 12% 97%
CRT 96         11.88               71 11% 100%
SBR 97         33.97            495 9% 21099%
TARO 98         84.96         3,331 15% 63%
SNE 99         47.62       61,742 11% 113%
LEA 100       120.65         7,947 19% 54%
FUJHY 101         10.51       16,116 33% 49%
TUSK 102         18.16            819 45% 47%
MTOR 103         17.26         1,536 16% 56%
MD 104         32.85         3,001 9% 166%
CBS 105         43.37       16,437 11% 83%
ICHR 106         15.61            385 15% 55%
MIK 107         13.58         2,262 13% 65%
JILL 108            5.15            229 16% 53%
EME 109         60.09         3,518 11% 76%
OSB 110         25.69         2,240 28% 44%
SWKS 111         66.71       12,021 12% 67%
CVS 112         65.41       66,849 11% 75%
BIIB 113       295.17       59,595 10% 122%
OMAB 114         39.22         1,929 10% 136%
CCE 115                 -                  -   32% 42%
GENC 116         11.17            164 26% 42%
ODP 117            2.49         1,404 16% 49%
HUM 118       282.61       39,192 9% 189%
PTN 119            0.68            139 8% 4532%
GTN 120         14.63         1,296 11% 67%
SEDG 121         35.29         1,704 11% 71%
DMLP 122         15.01            485 11% 75%
WTW 123         42.35         2,979 8% 746%
NLS 124         10.48            319 12% 63%
PBH 125         31.11         1,622 9% 157%
VHI 126            1.98            677 27% 39%
JAZZ 127       122.17         7,557 8% 228%
MCK 128       110.78       22,045 9% 107%
TNET 129         41.61         3,021 8% 329%
CDK 130         46.16         6,019 8% 447%
AVP 131            1.50            663 14% 52%
PM 132         66.86    103,967 9% 138%
NATH 133         63.57            269 8% 528%
BTI 134         31.87       73,014 9% 160%
TER 135         30.49         5,808 10% 96%
KRO 136         11.27         1,306 30% 36%
AAPL 137       157.17    761,889 8% 171%
DNB 138       141.50         5,278 8% 1574%
HOLI 139         17.19         1,053 20% 38%
AMGN 140       187.86    121,921 8% 177%
CKHUY 141            9.68       37,342 14% 45%
SUPN 142         32.37         1,756 8% 2005%
HI 143         37.98         2,416 9% 128%
LCI 144            4.78            180 20% 37%
FF 145         15.66            685 14% 44%
REGI 146         25.07         1,141 23% 36%
CAG 147         21.43         8,446 10% 70%
PBI 148            5.99         1,129 10% 68%
RTN 149       149.49       42,754 9% 97%
XRX 150         19.70         5,005 13% 48%
COHU 151         15.46            460 15% 42%
CLF 152            8.02         2,488 16% 40%
SBH 153         17.24         2,076 12% 51%
APEI 154         27.40            456 14% 45%
RHI 155         55.98         6,798 9% 115%
GNTX 156         19.98         5,347 10% 64%
BLBD 157         16.45            470 9% 87%
JEC 158         57.86         8,227 9% 84%
CC 159         27.46         4,994 18% 37%
AE 160         38.15            161 25% 35%
COHR 161       102.76         2,517 15% 40%
TSQ 162            4.11            115 12% 53%
MAS 163         28.57         8,742 10% 62%
VSM 164         26.71         2,933 11% 57%
CLCT 165         10.26               92 9% 96%
ATLKY 166         22.96       27,896 9% 120%
AYI 167       110.74         4,441 10% 68%
PATK 168         28.98            702 13% 44%
EBIX 169         43.79         1,385 8% 314%
MGLN 170         56.13         1,399 10% 69%
NCMI 171            6.48            502 8% 160%
ANTM 172       259.40       68,845 8% 219%
ALV 173         71.45         6,245 13% 44%
YRD 174         10.36            647 37% 31%
GPRK 175         12.34            813 18% 35%
SIMO 176         35.01         1,266 12% 48%
CTSH 177         62.36       36,169 9% 96%
FL 178         51.58         5,932 13% 41%
CSVI 179         49.70            692 8% 129%
ABBV 180         89.04    134,896 7% 416%
CSCO 181         42.47    195,957 7% 449%
KNMCY 182         41.11         5,646 10% 65%
NCS 183            7.26            482 17% 35%
IPGP 184       114.23         6,248 11% 51%
CAH 185         44.57       13,638 9% 69%
ORCL 186         44.59    170,200 8% 232%
OSK 187         60.21         4,441 13% 40%
TLYS 188         10.75            323 16% 35%
VC 189         63.74         1,880 13% 40%
LB 190         26.16         7,194 12% 44%
ACCO 191            6.52            690 14% 38%
DLPH 192         14.34         1,276 23% 31%
ABC 193         73.04       15,886 9% 93%
UTMD 194         75.78            284 8% 123%
KBAL 195         14.45            540 11% 54%
CVGI 196            5.68            174 22% 31%
KBR 197         15.00         2,115 8% 170%
SAIC 198         62.07         2,681 8% 107%
PMD 199         14.15               79 11% 52%
EPC 200         37.60         2,038 10% 53%


Comparison of Top 100 From Two Weeks Ago




Rank Stock EY Stock2 EY3
1 SIGA 71.8% SIGA 64.3%
2 FNJN 55.0% FNJN 55.0%
3 IMMR 33.6% NHTC 32.2%
4 NHTC 23.4% IMMR 31.6%
5 AKG 22.2% LTRPA 104.8%
6 CMCM 20.3% AKG 27.2%
7 BPT 17.0% BPT 23.3%
8 ACOR 24.8% CMCM 22.2%
9 UIS 30.4% ACOR 26.0%
10 NKTR 14.6% NKTR 16.9%
11 AGX 18.8% UIS 32.4%
12 MSB 13.7% MSB 15.5%
13 CJREF 16.5% MOH 14.5%
14 LEXEA 21.9% IDCC 13.4%
15 DLX 13.4% CJREF 17.3%
16 EGOV 12.3% DLX 14.3%
17 IDCC 11.3% LEXEA 22.6%
18 UTHR 20.6% YY 16.1%
19 YY 13.8% MCFT 14.0%
20 FTSI 34.1% UTHR 22.1%
21 EGY 35.5% EGOV 12.5%
22 MCFT 12.5% FTSI 37.2%
23 MOH 11.5% EGY 41.9%
24 AEIS 16.3% BPI 28.3%
25 HRB 11.3% TVTY 11.7%
26 PBT 10.2% HRB 12.5%
27 BPI 17.9% AGX 19.1%
28 MSGN 11.3% PBT 11.3%
29 VIAB 13.5% AEIS 16.7%
30 TVTY 10.4% VIAB 14.4%
31 PETS 14.1% MSGN 11.8%
32 KLAC 11.5% DHX 17.9%
33 DHX 15.4% KLAC 12.6%
34 SQBG 12.9% GILD 11.7%
35 LRCX 14.4% AMAT 15.3%
36 AMAT 13.7% LRCX 15.3%
37 GILD 10.9% VIA 13.6%
38 VIA 12.8% SQBG 13.1%
39 ESIO 13.4% GME 27.3%
40 GME 25.9% HEAR 17.1%
41 VEC 16.6% VEC 17.6%
42 SJT 10.0% PETS 13.6%
43 SP 10.2% DFIN 13.2%
44 STX 13.3% EAF 15.9%
45 DFIN 12.1% HSII 12.0%
46 WDC 19.5% QIWI 10.4%
47 TUP 13.3% WDC 20.8%
48 ALSN 11.2% STX 13.8%
49 UEPS 20.1% ESIO 13.3%
50 QIWI 9.7% TUP 14.2%
51 INVA 9.8% TGS 14.0%
52 LEE 14.9% UEPS 22.4%
53 WU 9.7% WU 10.3%
54 CO 118.2% HPQ 11.2%
55 DXC 13.8% DXC 15.0%
56 HPQ 10.3% CO 104.3%
57 TGS 12.2% INVA 10.2%
58 HSII 10.5% IPG 11.1%
59 MOMO 9.1% SP 10.3%
60 TPR 69.3% CECO 10.5%
61 GPP 10.9% ALSN 11.2%
62 STRL 18.0% MOMO 9.7%
63 MKSI 15.1% TPR 69.3%
64 THO 19.7% MKSI 16.9%
65 SGH 19.1% STRL 19.1%
66 AMCX 12.6% THO 22.0%
67 SHI 34.0% CELG 9.9%
68 OMAB 10.5% SGH 20.4%
69 NANO 14.0% LGORF 13.8%
70 BKE 18.1% NANO 15.7%
71 KORS 13.4% GPP 11.3%
72 ZAGG 19.3% SHI 35.4%
73 CRTO 12.5% AMCX 13.3%
74 HCC 26.6% ZAGG 20.4%
75 KLIC 22.2% BKE 18.3%
76 CELG 9.0% SYX 11.5%
77 PFMT 17.8% CRTO 13.3%
78 IPG 9.7% HCC 26.9%
79 MU 35.9% KLIC 23.1%
80 LPX 27.6% VGR 9.7%
81 VGR 9.0% PFMT 18.3%
82 OMC 8.8% KORS 13.7%
83 TGNA 10.2% SJT 9.3%
84 WGO 16.9% TGNA 11.1%
85 MAN 16.8% BBY 13.4%
86 MO 8.4% NVMI 12.5%
87 BBY 11.8% CASA 10.3%
88 MTOR 16.3% MU 44.8%
89 LEA 18.8% WGO 16.6%
90 FUJHY 30.9% OMC 9.4%
91 CECO 8.8% MO 9.2%
92 TARO 13.2% LPX 27.2%
93 NVMI 11.0% MAN 18.4%
94 ESRX 8.1% MBUU 10.4%
95 TUSK 37.8% KFY 11.5%
96 ICHR 14.8% CRT 11.4%
97 SNE 9.8% SBR 8.6%
98 MIK 12.1% TARO 14.5%
99 JILL 15.9% SNE 10.7%
100 KFY 10.1% LEA 19.4%

So the average EY two weeks ago was 18.5% and it is now 20.0%.  So commiserate with recent stock market drop,  The median 5 (a more stable statistic) two weeks ago was 13.8% and now is 14.6%.  Again, definitely cheaper.

Versus Current Top 50 List

Ticker Mkt Cap Date My Ranking Price EY ROIC
ACOR 740 26-Dec 9        15.68 26% 335%
AEIS 1,604 26-Dec 29        41.42 17% 124%
ALSN 5,552 26-Dec 61        42.83 11% 161%
AMAT 29,568 26-Dec 35        30.64 15% 115%
AGX 590 26-Dec 27        37.86 19% 119%
AKG 131 26-Dec 6          0.58 27% 16301%
HRB 5,105 26-Dec 26        24.84 12% 313%
BPT 423 26-Dec 7        19.76 23% 49074%
CECO 797 26-Dec 60        11.43 10% 234%
CASA 1,056 26-Dec 87        12.44 10% 162%
CELG 43,681 26-Dec 67        62.50 10% 356%
CJREF 678 26-Dec 15          3.20 17% 207%
DLX 1,801 26-Dec 16        38.90 14% 336%
DXC 14,663 26-Dec 55        52.13 15% 91%
ESIO 1,039 26-Dec 49        29.95 13% 120%
FTSI 740 26-Dec 22          6.77 37% 102%
GME 1,267 26-Dec 39        12.40 27% 76%
GILD 81,933 26-Dec 34        63.22 12% 255%
EAF 3,376 26-Dec 44        11.62 16% 95%
HSII 579 26-Dec 45        30.55 12% 161%
HPQ 31,633 26-Dec 54        20.33 11% 197%
IDT 143 26-Dec #N/A #N/A #N/A #N/A
IMMR 272 26-Dec 4          8.82 32% 1811%
INVA 1,898 26-Dec 57        16.74 10% 369%
IDCC 2,250 26-Dec 14        64.93 13% 2120%
IPG 7,822 26-Dec 58        20.35 11% 176%
KLAC 13,172 26-Dec 33        86.05 13% 205%
LRCX 20,993 26-Dec 36      130.84 15% 110%
LGORF 1,090 26-Dec 69          2.08 14% 88%
LTRPA 1,187 26-Dec 5        15.82 105% 792%
MCFT 349 26-Dec 19        18.62 14% 247%
MSB 310 26-Dec 12        23.65 15% 21815%
MSGN 1,723 26-Dec 31        23.03 12% 272%
NHTC 219 26-Dec 3        19.29 32% 3713%
NKTR 5,673 26-Dec 10        32.78 17% 1729%
EGOV 815 26-Dec 21        12.43 13% 411%
OMC 16,093 26-Dec 90        71.59 9% 294%
PETS 490 26-Dec 42        23.71 14% 126%
STX 10,847 26-Dec 48        37.91 14% 109%
SIGA 569 26-Dec 1          7.08 64% 71876%
SP 640 26-Dec 59        28.52 10% 295%
STRL 285 26-Dec 65        10.53 19% 65%
TVTY 992 26-Dec 25        24.77 12% 893%
TUP 1,566 26-Dec 50        32.23 14% 102%
HEAR 207 26-Dec 40        14.57 17% 93%
UIS 577 26-Dec 11        11.31 32% 233%
UTHR 4,979 26-Dec 20      105.85 22% 123%
VEC 236 26-Dec 41        20.94 18% 91%
VIAB 10,589 26-Dec 30        26.27 14% 141%
WDC 10,673 26-Dec 47        36.93 21% 76%

IDT seems to be the one missing.  I have them at #320, not sure what the difference is?

No comments: