Monday, February 11, 2019

Top 200 List - 2/8/2019

Top 200 List - 2/8/2019

Well, I felt like running a top 200 list this weekend, as earnings reports pile in.

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 Dividend Yield
SIGA 1            6.75            560 68% 71876% 0.00%
FNJN 2            3.11            135 55% 20682% 0.00%
LTRPA 3         17.38         1,304 95% 792% 0.00%
IMMR 4            9.86            303 26% 1811% 0.00%
AKG 5            0.71            160 22% 16301% 0.00%
BPT 6         23.36            500 20% 49074% 13.48%
CMCM 7            6.65            958 20% 921% 0.00%
ACOR 8         15.09            712 27% 335% 0.00%
UIS 9         12.67            655 30% 233% 0.00%
TVTY 10         21.42            917 13% 893% 0.00%
MSB 11         28.97            380 12% 21815% #VALUE!
LEXEA 12         46.82         2,669 21% 152% 0.00%
HRB 13         23.91         4,914 13% 313% 4.14%
NKTR 14         44.89         7,752 12% 1729% 0.00%
IDCC 15         72.70         2,589 11% 2120% 1.94%
MOH 16       136.90         9,296 12% 381% 0.00%
MCFT 17         21.10            396 13% 247% 0.00%
FTSI 18            7.95            869 33% 102% 0.00%
YY 19         65.73         4,261 14% 190% 0.00%
CJREF 20            4.48            950 15% 155% #VALUE!
EGY 21            1.74            106 33% 101% 0.00%
UTHR 22       116.48         5,125 20% 123% 0.00%
MSGN 23         22.88         1,732 12% 272% 0.00%
SJT 24            4.27            199 11% 422% 9.43%
VIAB 25         29.19       11,778 14% 148% 2.71%
PETS 26         22.48            461 14% 131% 4.75%
SQBG 27            1.02               65 13% 145% 0.00%
VIA 28         34.51       13,925 12% 148% 2.31%
WTW 29         28.64         2,014 10% 746% 0.00%
GME 30         11.35         1,160 29% 76% 13.25%
WU 31         18.01         8,022 10% 415% 4.15%
HEAR 32         15.98            259 16% 93% 0.00%
DFIN 33         15.49            530 12% 136% 0.00%
AGX 34         46.37            728 13% 119% 2.15%
PBT 35            6.90            322 10% 15329% 9.28%
BPI 36            8.86            244 14% 105% 0.00%
EAF 37         13.15         3,894 15% 95% 1.79%
VEC 38         25.14            287 15% 91% 0.00%
CASA 39         11.33         1,043 11% 162% 0.00%
HSII 40         31.89            619 11% 161% 1.85%
KLAC 41       105.60       16,120 11% 188% 2.69%
ATEYY 42         22.47         4,483 18% 76% 2.78%
LGORF 43            1.93         1,251 15% 88% 0.00%
SGH 44         28.04            652 24% 65% 0.00%
AEIS 45         49.58         1,914 12% 131% 0.00%
CO 46            6.45            717 52% 62% 1.24%
AMAT 47         39.78       39,144 12% 115% 1.74%
IPG 48         22.11         8,588 10% 176% 3.86%
TGS 49         15.91         2,504 12% 105% 3.28%
DHX 50            2.28            113 12% 100% 0.00%
HPQ 51         22.92       36,626 10% 197% 2.53%
SYX 52         23.54            892 12% 117% 1.86%
STX 53         45.02       12,921 12% 103% 0.00%
ALSN 54         47.42         6,212 10% 161% 1.25%
GPP 55         14.49            461 11% 133% 12.99%
BKE 56         17.55            853 21% 63% 5.69%
CTRA 57         61.27            636 25% 59% 0.00%
LRCX 58       175.30       28,428 11% 105% 2.18%
AMCX 59         62.15         3,591 12% 89% 0.00%
TGNA 60         11.67         2,525 11% 118% 2.39%
STRL 61         13.09            357 15% 65% 0.00%
SHI 62         47.78         5,173 31% 56% 9.91%
TPR 63         33.86            143 69% 63% 0.00%
CRT 64         11.85               71 11% 100% 11.66%
NLS 65            7.42            226 17% 63% 0.00%
THO 66         63.72         3,371 17% 63% 2.38%
QIWI 67         15.94            975 9% 422% 0.00%
OMC 68         74.70       16,875 9% 294% 3.22%
HCC 69         27.08         1,427 24% 56% 0.74%
ZAGG 70         11.11            317 17% 60% 0.00%
SP 71         34.49            780 9% 295% 0.00%
MU 72         38.58       45,293 36% 52% 0.00%
LPX 73         23.91         3,441 24% 53% 2.17%
MKSI 74         81.52         4,439 12% 72% 0.97%
CRTO 75         26.41         1,812 11% 86% 0.00%
VGR 76         11.38         1,588 9% 255% 13.72%
BBY 77         58.95       16,465 12% 78% 3.07%
BIIB 78       315.12       63,119 10% 142% 0.00%
MIK 79         12.83         2,137 13% 65% 0.00%
CECO 80         13.31            956 9% 234% 0.00%
MO 81         48.84       91,673 8% 498% 6.17%
WGO 82         28.63            911 14% 61% 1.44%
DXC 83         69.21       19,309 11% 86% 1.08%
MAN 84         79.69         4,965 15% 58% 2.54%
NVMI 85         24.27            698 11% 86% 0.00%
SNE 86         44.29       57,437 10% 102% 0.62%
CVS 87         65.01       66,440 11% 75% 3.06%
WDC 88         46.71       13,546 14% 60% 4.36%
PFMT 89            2.13            111 14% 61% 0.00%
KLIC 90         21.60         1,466 17% 54% 1.67%
LEA 91       148.00         9,561 16% 55% 1.90%
PBH 92         27.51         1,436 9% 153% 0.00%
TUSK 93         21.15            953 39% 47% 1.77%
EGOV 94         17.13         1,142 8% 482% 1.88%
AMGN 95       186.00    119,040 8% 213% 2.88%
MOMO 96         29.21         6,512 8% 944% 0.00%
NANO 97         29.06            711 12% 63% 0.00%
JILL 98            6.06            270 15% 53% 0.00%
CBS 99         49.56       18,783 10% 83% 0.00%
EME 100         64.79         3,793 11% 76% 0.48%
MTOR 101         20.23         1,770 14% 55% 0.00%
OSB 102         27.83         2,427 26% 44% 17.04%
KFY 103         46.23         2,600 10% 97% 0.88%
JAZZ 104       125.08         7,737 8% 228% 0.00%
CCE 105                 -                  -   32% 42% 0.00%
RTN 106       175.92       50,084 9% 135% 0.00%
GTN 107         16.17         1,432 11% 67% 0.00%
TARO 108         98.96         3,880 11% 63% 0.00%
ODP 109            3.09         1,743 14% 49% 3.20%
OMAB 110         44.21         2,174 8% 136% 3.69%
NTDOY 111         32.88       31,598 8% 166% 2.20%
BTI 112         35.15       80,529 8% 160% 7.56%
GNTX 113         19.77         5,184 11% 64% 2.20%
HUM 114       298.80       41,094 8% 179% 0.66%
USNA 115       108.51         2,654 8% 206% 0.00%
NCR 116         26.42         3,133 10% 79% 0.00%
VHI 117            3.06         1,047 22% 39% 2.61%
NATH 118         69.70            294 7% 452% 1.08%
ICHR 119         21.76            501 11% 56% 0.00%
CKHUY 120            9.97       38,461 14% 45% 3.76%
DMLP 121         17.04            550 10% 75% 10.95%
KRO 122         13.30         1,541 25% 36% 5.11%
MBUU 123         44.45            922 8% 142% 0.68%
PTN 124            0.75            154 7% 4532% 0.00%
TNET 125         45.97         3,337 7% 329% 0.00%
AAPL 126       170.41    813,410 8% 171% 0.00%
PBI 127            6.89         1,301 10% 65% 10.89%
BLBD 128         17.79            508 9% 87% 0.00%
REGI 129         26.35         1,199 22% 36% 0.00%
XRX 130         29.09         7,160 11% 55% 3.43%
SBH 131         17.57         2,126 12% 48% 0.00%
GENC 132         13.64            200 15% 39% 0.00%
AVP 133            2.50         1,106 12% 52% 0.00%
SBR 134         42.51            620 7% 21099% 24.04%
NCMI 135            7.14            553 8% 160% 9.53%
CDK 136         55.37         7,060 7% 297% 1.12%
LCI 137            8.52            333 17% 37% 0.00%
MAS 138         35.90       10,734 9% 69% 1.25%
KNMCY 139         41.74         5,732 10% 65% 2.12%
HOLI 140         20.42         1,251 15% 38% 0.88%
TSQ 141            6.03            168 11% 53% 4.98%
AE 142         40.13            169 21% 35% 2.19%
TER 143         37.54         6,814 8% 108% 0.98%
CC 144         36.36         6,613 15% 37% 2.30%
STLD 145         35.76         8,241 18% 35% 2.10%
AYI 146       125.56         5,035 9% 70% 0.41%
APEI 147         30.06            501 12% 45% 0.00%
SWKS 148         81.71       14,520 9% 64% 1.70%
FF 149         17.42            762 12% 44% 1.36%
CLCT 150         14.70            132 8% 124% 4.76%
HI 151         42.67         2,710 8% 131% 1.94%
MGLN 152         62.23         1,551 9% 69% 0.00%
JOUT 153         60.12            602 12% 41% 0.87%
YRD 154         10.39            649 37% 31% 2.69%
SVA 155            6.62            389 14% 36% 0.00%
CETV 156            3.23            856 10% 58% 0.00%
VSH 157         21.74         3,226 16% 35% 1.48%
SEDG 158         43.48         2,099 9% 71% 0.00%
FFIV 159       160.92         9,759 7% 349% 0.00%
FL 160         56.49         6,496 12% 41% 2.45%
NCS 161            8.14            540 17% 34% 0.00%
COHU 162         17.73            528 12% 42% 1.35%
SUPN 163         37.45         2,031 7% 2005% 0.00%
KBAL 164         15.23            569 10% 54% 1.95%
FUJHY 165         12.01       18,417 18% 33% 5.34%
JEC 166         65.73         9,437 8% 79% 0.92%
PATK 167         39.83            965 11% 44% 0.00%
GPS 168         24.90         9,636 14% 35% 0.00%
MCK 169       128.49       25,056 8% 74% 1.11%
DLPH 170         16.89         1,503 21% 31% 0.00%
CLF 171         11.83         3,670 12% 40% 0.47%
ATLKY 172         26.18       31,809 8% 120% 6.52%
CVGI 173            6.87            210 19% 31% 0.00%
OSK 174         75.63         5,453 12% 40% 1.31%
SGU 175            9.37            496 10% 50% 4.96%
GPRK 176         17.46         1,150 14% 35% 0.00%
NUE 177         59.82       18,571 15% 33% 2.57%
SERV 178         39.38         5,356 7% 221% 0.00%
WTI 179            4.57            635 14% 35% 0.00%
NVR 180   2,579.00       10,223 10% 52% 0.00%
ALV 181         73.72         6,443 11% 42% 3.32%
CSVI 182         57.25            796 7% 137% 2.34%
ACCO 183            8.69            920 12% 38% 2.76%
WNC 184         13.44            757 12% 38% 2.27%
FCN 185         68.40         2,651 8% 66% 0.00%
ATTO 186            4.00            300 14% 35% #VALUE!
ANTM 187       304.20       80,370 7% 213% 0.98%
PLCE 188         86.63         1,429 11% 41% 2.31%
IMBBY 189         33.30       32,154 7% 140% 7.26%
SNA 190       153.08         8,664 10% 52% 2.23%
VC 191         73.48         2,168 11% 40% 0.00%
CSCO 192         47.19    217,735 6% 449% 2.80%
CIX 193         14.37            179 13% 35% 1.39%
EPC 194         42.34         2,291 10% 50% 0.00%
ORCL 195         51.03    194,782 7% 232% 1.51%
SIMO 196         40.60         1,464 9% 54% 2.96%
SAIC 197         71.38         3,084 7% 107% 1.77%
ABC 198         84.31       18,040 8% 92% 1.82%
CCRC 199         10.94            201 9% 52% 0.00%
DECK 200       141.06         4,147 9% 61% 0.00%


Here is how that compares to official top 50:


Ticker Mkt Cap Date My Ranking Price EY ROIC
ACOR 712 8-Feb 8        15.09 27% 335%
AEIS 1,903 8-Feb 45        49.58 12% 131%
ALSN 6,147 8-Feb 54        47.42 10% 161%
MO 91,673 8-Feb 81        48.84 8% 498%
AMCX 3,512 8-Feb 59        62.15 12% 89%
AMAT 38,467 8-Feb 47        39.78 12% 115%
AGX 722 8-Feb 34        46.37 13% 119%
AKG 161 8-Feb 5          0.71 22% 16301%
HRB 4,914 8-Feb 13        23.91 13% 313%
BPT 500 8-Feb 6        23.36 20% 49074%
BKE 860 8-Feb 56        17.55 21% 63%
CASA 961 8-Feb 39        11.33 11% 162%
CTRA 607 8-Feb 57        61.27 25% 59%
CJREF 950 8-Feb 20          4.48 15% 155%
FTSI 869 8-Feb 18          7.95 33% 102%
GME 1,160 8-Feb 30        11.35 29% 76%
EAF 3,821 8-Feb 37        13.15 15% 95%
HSII 604 8-Feb 40        31.89 11% 161%
HPQ 35,761 8-Feb 51        22.92 10% 197%
IDT 155 8-Feb #N/A #N/A #N/A #N/A
IMMR 304 8-Feb 4          9.86 26% 1811%
IDCC 2,519 8-Feb 15        72.70 11% 2120%
IPG 8,498 8-Feb 48        22.11 10% 176%
KLAC 15,984 8-Feb 41      105.60 11% 188%
LRCX 28,198 8-Feb 58      175.30 11% 105%
LGORF 1,011 8-Feb 43          1.93 15% 88%
LTRPA 1,305 8-Feb 3        17.38 95% 792%
TUSK 947 8-Feb 93        21.15 39% 47%
MCFT 395 8-Feb 17        21.10 13% 247%
MSB 380 8-Feb 11        28.97 12% 21815%
MSGN 1,713 8-Feb 23        22.88 12% 272%
NLS 224 8-Feb 65          7.42 17% 63%
NKTR 7,769 8-Feb 14        44.89 12% 1729%
OMC 16,793 8-Feb 68        74.70 9% 294%
PETS 465 8-Feb 26        22.48 14% 131%
STX 12,831 8-Feb 53        45.02 12% 103%
SIGA 542 8-Feb 1          6.75 68% 71876%
SGH 639 8-Feb 44        28.04 24% 65%
SP 773 8-Feb 71        34.49 9% 295%
STRL 354 8-Feb 61        13.09 15% 65%
SYX 877 8-Feb 52        23.54 12% 117%
TGNA 2,509 8-Feb 60        11.67 11% 118%
TVTY 858 8-Feb 10        21.42 13% 893%
HEAR 227 8-Feb 32        15.98 16% 93%
UIS 646 8-Feb 9        12.67 30% 233%
UTHR 5,479 8-Feb 22      116.48 20% 123%
VEC 283 8-Feb 38        25.14 15% 91%
VIAB 11,766 8-Feb 25        29.19 14% 148%
HCC 1,429 8-Feb 69        27.08 24% 56%
WTW 1,914 8-Feb 29        28.64 10% 746%

IDT continues to be the one I don't agree with.  I went to sec.gov and looked at their latest 10-Q and 10-K and I saw nothing their to suggest they are a top 50 company.  They do have a lot of cash for a company their size (71m) and they did have one oddball quarter where they earned $11m (normal quarters are 1 or 2 million).  So that one weird quarter seems to be driving their inclusion.  But even though they have a lot of cash, I don't show it as "excess" as I show them with a lot of current liabilities to offset the cash.  I suspect the difference is they have a category called "liabilities held for sale", that Fidelity puts in "other current liability" bucket, but SEC has split out.  I don't think MFI (for whatever reason (it is not a liability I recognize) is counting that against their liabilities.  If you remove that in my worksheet,  that would move them up a few slots (but not into top 50).  Hmmm. Don't know.

No comments: