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:
Post a Comment