Well, I felt like running a top 200 list this morning, given long weekend and upcoming tranche (plus it is like 5 degrees with 25 mph winds outside).
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 | 7.34 | 609 | 62% | 71876% | 0.00% |
FNJN | 2 | 2.83 | 135 | 55% | 20682% | 0.00% |
LTRPA | 3 | 17.39 | 1,304 | 95% | 792% | 0.00% |
IMMR | 4 | 9.80 | 302 | 26% | 1811% | 0.00% |
AKG | 5 | 0.68 | 154 | 23% | 16301% | 0.00% |
BPT | 6 | 25.02 | 535 | 18% | 49074% | 13.48% |
CMCM | 7 | 6.55 | 944 | 21% | 921% | 0.00% |
ACOR | 8 | 16.26 | 767 | 25% | 335% | 0.00% |
UIS | 9 | 13.11 | 678 | 29% | 233% | 0.00% |
MSB | 10 | 28.88 | 379 | 12% | 21815% | #VALUE! |
LEXEA | 11 | 41.23 | 2,350 | 22% | 152% | 0.00% |
TVTY | 12 | 23.58 | 1,010 | 12% | 893% | 0.00% |
DLX | 13 | 44.03 | 2,061 | 13% | 336% | 2.73% |
IDCC | 14 | 72.34 | 2,576 | 12% | 2120% | 1.94% |
NKTR | 15 | 46.20 | 7,979 | 11% | 1729% | 0.00% |
HRB | 16 | 25.63 | 5,267 | 12% | 313% | 3.86% |
MOH | 17 | 136.96 | 9,300 | 12% | 381% | 0.00% |
CJREF | 18 | 4.24 | 899 | 15% | 155% | #VALUE! |
UTHR | 19 | 115.75 | 5,093 | 20% | 123% | 0.00% |
FTSI | 20 | 8.05 | 880 | 33% | 102% | 0.00% |
EGY | 21 | 1.94 | 118 | 30% | 101% | 0.00% |
MSGN | 22 | 22.50 | 1,703 | 12% | 272% | 0.00% |
AGX | 23 | 40.69 | 639 | 16% | 119% | 1.84% |
MCFT | 24 | 22.65 | 425 | 12% | 247% | 0.00% |
EGOV | 25 | 13.81 | 920 | 11% | 411% | 2.32% |
VIAB | 26 | 30.08 | 12,131 | 13% | 141% | 2.66% |
BPI | 27 | 8.08 | 223 | 17% | 105% | 0.00% |
PETS | 28 | 23.44 | 481 | 14% | 126% | 4.44% |
DFIN | 29 | 13.57 | 464 | 13% | 136% | 0.00% |
SQBG | 30 | 0.99 | 63 | 13% | 145% | 0.00% |
AEIS | 31 | 48.00 | 1,881 | 14% | 124% | 0.00% |
VIA | 32 | 33.12 | 13,357 | 13% | 141% | 2.42% |
KLAC | 33 | 95.73 | 14,942 | 11% | 205% | 2.97% |
GILD | 34 | 69.18 | 90,418 | 11% | 255% | 3.30% |
ESIO | 35 | 29.99 | 1,078 | 13% | 120% | 0.00% |
QIWI | 36 | 14.35 | 878 | 10% | 422% | 0.00% |
YY | 37 | 73.97 | 4,795 | 11% | 190% | 0.00% |
LRCX | 38 | 147.55 | 24,394 | 13% | 110% | 2.58% |
LEE | 39 | 2.51 | 142 | 15% | 97% | 0.00% |
PBT | 40 | 6.96 | 324 | 9% | 15329% | 9.49% |
CASA | 41 | 11.20 | 1,031 | 11% | 162% | 0.00% |
AMAT | 42 | 35.71 | 35,139 | 13% | 115% | 1.96% |
GME | 43 | 15.93 | 1,628 | 22% | 76% | 9.54% |
VEC | 44 | 24.10 | 275 | 16% | 91% | 0.00% |
HEAR | 45 | 16.76 | 272 | 15% | 93% | 0.00% |
STX | 46 | 40.23 | 11,747 | 13% | 109% | 0.00% |
WDC | 47 | 39.20 | 11,682 | 20% | 76% | 5.10% |
WU | 48 | 18.26 | 8,199 | 10% | 416% | 4.16% |
DHX | 49 | 2.06 | 104 | 13% | 108% | 0.00% |
SJT | 50 | 4.82 | 225 | 10% | 422% | 9.52% |
EAF | 51 | 13.79 | 4,084 | 14% | 95% | 1.70% |
HPQ | 52 | 21.75 | 34,757 | 11% | 197% | 2.66% |
UEPS | 53 | 5.22 | 292 | 20% | 73% | 0.00% |
HSII | 54 | 33.25 | 645 | 11% | 161% | 1.85% |
TUP | 55 | 38.03 | 1,879 | 13% | 102% | 7.15% |
SGH | 56 | 22.71 | 528 | 28% | 65% | 0.00% |
CO | 57 | 6.11 | 679 | 88% | 62% | 1.31% |
MO | 58 | 48.31 | 90,968 | 9% | 509% | 6.21% |
WTW | 59 | 34.30 | 2,412 | 9% | 746% | 0.00% |
IPG | 60 | 22.25 | 8,642 | 10% | 176% | 3.78% |
DXC | 61 | 62.62 | 17,896 | 13% | 91% | 1.20% |
GPP | 62 | 14.32 | 456 | 11% | 133% | 13.23% |
TPR | 63 | 37.08 | 143 | 69% | 63% | 0.00% |
TGS | 64 | 16.41 | 2,583 | 12% | 105% | 3.14% |
SYX | 65 | 24.19 | 917 | 11% | 117% | 1.82% |
BKE | 66 | 18.12 | 881 | 20% | 63% | 5.52% |
ALSN | 67 | 49.90 | 6,537 | 10% | 161% | 1.20% |
LGORF | 68 | 2.30 | 1,490 | 12% | 88% | 0.00% |
NLS | 69 | 7.02 | 214 | 19% | 63% | 0.00% |
NANO | 70 | 29.41 | 720 | 14% | 72% | 0.00% |
SHI | 71 | 46.55 | 5,039 | 32% | 56% | 10.24% |
TGNA | 72 | 11.78 | 2,549 | 11% | 118% | 2.38% |
MKSI | 73 | 74.16 | 4,075 | 14% | 72% | 1.05% |
STRL | 74 | 13.30 | 363 | 15% | 65% | 0.00% |
INVA | 75 | 19.67 | 2,230 | 9% | 369% | 0.00% |
AMCX | 76 | 63.84 | 3,689 | 12% | 89% | 0.00% |
CRTO | 77 | 24.95 | 1,712 | 12% | 86% | 0.00% |
THO | 78 | 66.61 | 3,524 | 16% | 63% | 2.28% |
VGR | 79 | 10.78 | 1,504 | 9% | 255% | 14.49% |
HCC | 80 | 26.03 | 1,372 | 25% | 56% | 0.77% |
OMC | 81 | 76.00 | 17,168 | 9% | 294% | 3.16% |
ZAGG | 82 | 11.11 | 317 | 17% | 60% | 0.00% |
CECO | 83 | 12.85 | 923 | 9% | 234% | 0.00% |
KLIC | 84 | 21.79 | 1,496 | 19% | 57% | 1.65% |
SP | 85 | 34.38 | 778 | 9% | 295% | 0.00% |
MU | 86 | 35.76 | 41,982 | 39% | 52% | 0.00% |
PFMT | 87 | 1.98 | 104 | 15% | 61% | 0.00% |
LPX | 88 | 24.07 | 3,464 | 24% | 53% | 2.16% |
ATEYY | 89 | 20.58 | 4,106 | 15% | 60% | 3.15% |
SNE | 90 | 50.18 | 65,061 | 10% | 113% | 0.54% |
MAN | 91 | 74.44 | 4,839 | 16% | 58% | 2.71% |
BBY | 92 | 58.71 | 16,398 | 12% | 78% | 3.07% |
NVMI | 93 | 23.63 | 680 | 11% | 86% | 0.00% |
PBH | 94 | 27.87 | 1,454 | 9% | 157% | 0.00% |
WGO | 95 | 30.62 | 974 | 13% | 61% | 1.34% |
CVS | 96 | 65.52 | 66,961 | 11% | 75% | 3.05% |
CRT | 97 | 13.41 | 80 | 10% | 100% | 10.64% |
TUSK | 98 | 22.77 | 1,027 | 36% | 47% | 1.10% |
MBUU | 99 | 38.91 | 807 | 9% | 142% | 0.68% |
LEA | 100 | 151.56 | 9,983 | 16% | 54% | 1.85% |
MTOR | 101 | 20.00 | 1,780 | 14% | 56% | 0.00% |
MD | 102 | 36.79 | 3,361 | 9% | 166% | 0.00% |
TARO | 103 | 93.84 | 3,679 | 12% | 63% | 0.00% |
KFY | 104 | 45.61 | 2,565 | 10% | 97% | 0.88% |
CBS | 105 | 49.24 | 18,662 | 10% | 83% | 0.00% |
MIK | 106 | 16.21 | 2,700 | 12% | 65% | 0.00% |
PTN | 107 | 0.70 | 144 | 8% | 4532% | 0.00% |
SWKS | 108 | 70.07 | 12,627 | 11% | 67% | 2.00% |
EME | 109 | 64.90 | 3,799 | 11% | 76% | 0.49% |
JILL | 110 | 6.34 | 282 | 15% | 53% | 0.00% |
OSB | 111 | 28.50 | 2,485 | 26% | 44% | 16.86% |
JOUT | 112 | 66.83 | 669 | 12% | 59% | 0.78% |
ICHR | 113 | 19.30 | 476 | 13% | 55% | 0.00% |
CCE | 114 | - | - | 32% | 42% | 0.00% |
HUM | 115 | 295.50 | 40,979 | 8% | 189% | 0.68% |
AAPL | 116 | 156.82 | 760,192 | 8% | 171% | 0.00% |
MOMO | 117 | 30.26 | 6,746 | 8% | 944% | 0.00% |
BTI | 118 | 32.90 | 75,374 | 8% | 160% | 8.08% |
CELG | 119 | 86.27 | 62,089 | 8% | 356% | 0.00% |
DNB | 120 | 144.46 | 5,388 | 7% | 1574% | 1.09% |
ODP | 121 | 2.99 | 1,686 | 14% | 49% | 3.34% |
GTN | 122 | 16.50 | 1,461 | 11% | 67% | 0.00% |
SEDG | 123 | 37.18 | 1,795 | 10% | 71% | 0.00% |
JAZZ | 124 | 129.07 | 7,984 | 8% | 228% | 0.00% |
GENC | 125 | 12.54 | 185 | 19% | 42% | 0.00% |
BIIB | 126 | 337.40 | 68,121 | 9% | 122% | 0.00% |
CDK | 127 | 50.24 | 6,551 | 7% | 447% | 1.19% |
AVP | 128 | 2.01 | 889 | 12% | 52% | 0.00% |
VHI | 129 | 3.45 | 1,180 | 21% | 39% | 2.32% |
PM | 130 | 73.79 | 114,743 | 8% | 138% | 6.08% |
CKHUY | 131 | 10.12 | 39,040 | 14% | 45% | 3.70% |
TNET | 132 | 45.41 | 3,297 | 7% | 329% | 0.00% |
OMAB | 133 | 45.76 | 2,251 | 8% | 136% | 3.57% |
MCK | 134 | 126.67 | 25,207 | 9% | 107% | 1.15% |
DMLP | 135 | 17.10 | 552 | 9% | 75% | 10.16% |
CSVI | 136 | 51.72 | 719 | 8% | 137% | 2.59% |
KRO | 137 | 13.14 | 1,523 | 25% | 36% | 5.18% |
ABBV | 138 | 89.50 | 135,593 | 7% | 416% | 4.41% |
ANTM | 139 | 266.12 | 70,628 | 8% | 219% | 1.13% |
PBI | 140 | 7.15 | 1,347 | 10% | 68% | 10.49% |
TER | 141 | 32.90 | 6,268 | 9% | 96% | 1.09% |
AMGN | 142 | 203.80 | 132,266 | 8% | 177% | 2.59% |
SBR | 143 | 41.91 | 611 | 7% | 21099% | 24.04% |
SBH | 144 | 18.08 | 2,178 | 12% | 51% | 0.00% |
HI | 145 | 41.27 | 2,625 | 8% | 128% | 2.02% |
AYI | 146 | 120.57 | 4,835 | 9% | 70% | 0.43% |
NCMI | 147 | 7.04 | 546 | 8% | 160% | 9.66% |
REGI | 148 | 27.99 | 1,274 | 21% | 36% | 0.00% |
LCI | 149 | 7.65 | 288 | 18% | 37% | 0.00% |
CLF | 150 | 9.01 | 2,795 | 14% | 40% | 0.55% |
JEC | 151 | 62.51 | 8,889 | 9% | 84% | 0.96% |
NATH | 152 | 73.22 | 310 | 7% | 528% | 1.02% |
XRX | 153 | 23.43 | 5,952 | 12% | 48% | 4.27% |
RTN | 154 | 165.41 | 47,307 | 8% | 97% | 0.00% |
TSQ | 155 | 5.83 | 163 | 11% | 53% | 5.15% |
CC | 156 | 34.95 | 6,357 | 15% | 37% | 2.40% |
AE | 157 | 40.43 | 171 | 20% | 35% | 2.18% |
HOLI | 158 | 21.16 | 1,296 | 14% | 38% | 0.85% |
FF | 159 | 17.08 | 747 | 12% | 44% | 1.41% |
RHI | 160 | 60.87 | 7,392 | 8% | 115% | 1.84% |
MAS | 161 | 32.22 | 9,859 | 10% | 62% | 1.40% |
COHR | 162 | 120.33 | 2,947 | 13% | 40% | 0.00% |
ALV | 163 | 79.51 | 6,949 | 12% | 44% | 3.09% |
SAIC | 164 | 66.01 | 2,852 | 8% | 107% | 1.88% |
VSM | 165 | 30.29 | 3,326 | 10% | 57% | 0.83% |
SVA | 166 | 6.55 | 385 | 15% | 36% | 0.00% |
PCOM | 167 | 9.87 | 141 | 7% | 404% | 0.00% |
MGLN | 168 | 62.34 | 1,554 | 9% | 69% | 0.00% |
YRD | 169 | 11.73 | 732 | 31% | 31% | 2.39% |
LB | 170 | 27.33 | 7,516 | 12% | 44% | 8.78% |
KBAL | 171 | 14.86 | 556 | 10% | 54% | 2.02% |
SIMO | 172 | 36.77 | 1,330 | 11% | 48% | 3.26% |
EPC | 173 | 39.07 | 2,118 | 10% | 53% | 0.00% |
APEI | 174 | 30.79 | 513 | 11% | 45% | 0.00% |
CSCO | 175 | 45.03 | 207,768 | 7% | 449% | 2.93% |
ATLKY | 176 | 25.60 | 31,104 | 8% | 120% | 6.67% |
FUJHY | 177 | 11.59 | 17,773 | 19% | 33% | 5.57% |
NCS | 178 | 7.86 | 521 | 17% | 34% | 0.00% |
CAH | 179 | 49.05 | 15,009 | 9% | 69% | 3.86% |
COHU | 180 | 17.76 | 529 | 12% | 42% | 1.35% |
SERV | 181 | 37.99 | 5,167 | 7% | 221% | 0.00% |
YUM | 182 | 92.36 | 30,017 | 7% | 204% | 1.56% |
PATK | 183 | 38.95 | 944 | 11% | 44% | 0.00% |
GNTX | 184 | 22.95 | 6,141 | 9% | 64% | 1.92% |
DLPH | 185 | 15.94 | 1,418 | 21% | 31% | 0.00% |
GPRK | 186 | 16.25 | 1,070 | 14% | 35% | 0.00% |
CTSH | 187 | 67.82 | 39,336 | 8% | 96% | 0.00% |
ABC | 188 | 79.86 | 17,369 | 8% | 93% | 1.93% |
BLD | 189 | 48.49 | 1,735 | 9% | 61% | 0.00% |
FL | 190 | 58.37 | 6,713 | 12% | 41% | 2.36% |
CVGI | 191 | 7.25 | 222 | 19% | 31% | 0.00% |
IMBBY | 192 | 32.38 | 31,266 | 7% | 140% | 7.46% |
LYB | 193 | 87.86 | 34,265 | 14% | 35% | 4.55% |
GPS | 194 | 26.01 | 10,066 | 14% | 35% | 0.00% |
SUPN | 195 | 38.05 | 2,064 | 6% | 2005% | 0.00% |
FFIV | 196 | 158.64 | 9,688 | 7% | 420% | 0.00% |
CVRR | 197 | 10.49 | 1,548 | 26% | 30% | 24.02% |
VSH | 198 | 18.94 | 2,897 | 18% | 31% | 1.70% |
ORCL | 199 | 49.27 | 188,064 | 7% | 232% | 1.54% |
ACCO | 200 | 8.83 | 935 | 12% | 38% | 2.72% |
Here is how my list compares/maps to official list:
Ticker | Mkt Cap | Date | My Ranking | Price | EY | ROIC |
ACOR | 767 | 18-Jan | 8 | 16.26 | 25% | 335% |
AEIS | 1,858 | 18-Jan | 31 | 48.00 | 14% | 124% |
ALSN | 6,469 | 18-Jan | 67 | 49.90 | 10% | 161% |
MO | 90,826 | 18-Jan | 58 | 48.31 | 9% | 509% |
AMAT | 34,460 | 18-Jan | 42 | 35.71 | 13% | 115% |
AGX | 634 | 18-Jan | 23 | 40.69 | 16% | 119% |
AKG | 154 | 18-Jan | 5 | 0.68 | 23% | 16301% |
HRB | 5,268 | 18-Jan | 16 | 25.63 | 12% | 313% |
BPT | 535 | 18-Jan | 6 | 25.02 | 18% | 49074% |
CASA | 950 | 18-Jan | 41 | 11.20 | 11% | 162% |
CJREF | 899 | 18-Jan | 18 | 4.24 | 15% | 155% |
DLX | 2,039 | 18-Jan | 13 | 44.03 | 13% | 336% |
DXC | 17,614 | 18-Jan | 61 | 62.62 | 13% | 91% |
ESIO | 1,041 | 18-Jan | 35 | 29.99 | 13% | 120% |
FTSI | 880 | 18-Jan | 20 | 8.05 | 33% | 102% |
GME | 1,628 | 18-Jan | 43 | 15.93 | 22% | 76% |
GILD | 89,657 | 18-Jan | 34 | 69.18 | 11% | 255% |
EAF | 4,007 | 18-Jan | 51 | 13.79 | 14% | 95% |
HSII | 630 | 18-Jan | 54 | 33.25 | 11% | 161% |
HPQ | 33,843 | 18-Jan | 52 | 21.75 | 11% | 197% |
IDT | 166 | 18-Jan | #N/A | #N/A | #N/A | #N/A |
IMMR | 302 | 18-Jan | 4 | 9.80 | 26% | 1811% |
IDCC | 2,507 | 18-Jan | 14 | 72.34 | 12% | 2120% |
IPG | 8,552 | 18-Jan | 60 | 22.25 | 10% | 176% |
KLAC | 14,654 | 18-Jan | 33 | 95.73 | 11% | 205% |
LRCX | 23,674 | 18-Jan | 38 | 147.55 | 13% | 110% |
LGORF | 1,206 | 18-Jan | 68 | 2.30 | 12% | 88% |
LTRPA | 1,305 | 18-Jan | 3 | 17.39 | 95% | 792% |
TUSK | 1,019 | 18-Jan | 98 | 22.77 | 36% | 47% |
MCFT | 424 | 18-Jan | 24 | 22.65 | 12% | 247% |
MSB | 379 | 18-Jan | 10 | 28.88 | 12% | 21815% |
MSGN | 1,684 | 18-Jan | 22 | 22.50 | 12% | 272% |
NKTR | 7,995 | 18-Jan | 15 | 46.20 | 11% | 1729% |
EGOV | 905 | 18-Jan | 25 | 13.81 | 11% | 411% |
OMC | 17,085 | 18-Jan | 81 | 76.00 | 9% | 294% |
PETS | 485 | 18-Jan | 28 | 23.44 | 14% | 126% |
STX | 11,511 | 18-Jan | 46 | 40.23 | 13% | 109% |
SIGA | 590 | 18-Jan | 1 | 7.34 | 62% | 71876% |
SGH | 513 | 18-Jan | 56 | 22.71 | 28% | 65% |
SP | 771 | 18-Jan | 85 | 34.38 | 9% | 295% |
SYX | 901 | 18-Jan | 65 | 24.19 | 11% | 117% |
TVTY | 944 | 18-Jan | 12 | 23.58 | 12% | 893% |
TUP | 1,848 | 18-Jan | 55 | 38.03 | 13% | 102% |
HEAR | 238 | 18-Jan | 45 | 16.76 | 15% | 93% |
UIS | 669 | 18-Jan | 9 | 13.11 | 29% | 233% |
UTHR | 5,445 | 18-Jan | 19 | 115.75 | 20% | 123% |
VEC | 271 | 18-Jan | 44 | 24.10 | 16% | 91% |
VIAB | 12,125 | 18-Jan | 26 | 30.08 | 13% | 141% |
WTW | 2,292 | 18-Jan | 59 | 34.30 | 9% | 746% |
WDC | 11,329 | 18-Jan | 47 | 39.20 | 20% | 76% |
So IDT is the strange one... I just don't map them into top 200. All other top 50 are in my top 100. I'll call that pretty darned good.
No comments:
Post a Comment