Thought it was time for another top 200 list. This is my version of the official magic formula screener fro 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.
Here is my list:
| Ticker | Rank | Stock Price | Market Cap | Earnings Yield | ROIC | Dividend Yield |
| OPHT | 1 | 2.86 | 103 | 2441% | 5362% | 0.00% |
| VVUS | 2 | 0.46 | 49 | 147% | 1990% | 0.00% |
| NHTC | 3 | 17.25 | 194 | 51% | 3748% | 2.43% |
| CNCE | 4 | 21.48 | 503 | 31% | 4417% | 0.00% |
| AVDL | 5 | 7.74 | 320 | 33% | 2696% | 0.00% |
| AGX | 6 | 40.40 | 638 | 37% | 838% | 2.48% |
| BPT | 7 | 21.10 | 452 | 17% | 38570% | 13.48% |
| EVC | 8 | 6.80 | 627 | 46% | 334% | 2.39% |
| IDCC | 9 | 79.35 | 2,808 | 17% | 585% | 1.64% |
| ICON | 10 | 1.65 | 94 | 22% | 427% | 0.00% |
| NTIP | 11 | 2.55 | 67 | 34% | 284% | 3.92% |
| BPI | 12 | 7.05 | 209 | 29% | 189% | 0.00% |
| UTHR | 13 | 134.93 | 5,950 | 21% | 206% | 0.00% |
| MSB | 14 | 26.55 | 348 | 10% | 16407% | #VALUE! |
| EGOV | 15 | 14.00 | 929 | 10% | 760% | 2.29% |
| SQBG | 16 | 1.73 | 109 | 12% | 210% | 0.00% |
| VEC | 17 | 28.13 | 317 | 13% | 174% | 0.00% |
| MSGN | 18 | 25.05 | 1,898 | 10% | 265% | 0.00% |
| DHX | 19 | 1.80 | 87 | 16% | 128% | 0.00% |
| YRD | 20 | 39.60 | 2,445 | 12% | 185% | 0.00% |
| MPAA | 21 | 22.96 | 438 | 10% | 244% | 0.00% |
| GME | 22 | 16.40 | 1,665 | 26% | 109% | 9.27% |
| CJREF | 23 | 6.50 | 1,344 | 12% | 165% | #VALUE! |
| EGRX | 24 | 64.78 | 1,021 | 11% | 179% | 0.00% |
| LFVN | 25 | 4.14 | 58 | 13% | 122% | 0.00% |
| HRB | 26 | 28.04 | 5,862 | 10% | 270% | 3.35% |
| ESRX | 27 | 75.23 | 43,235 | 9% | 426% | 0.00% |
| TGNA | 28 | 13.78 | 3,005 | 12% | 141% | 2.54% |
| WU | 29 | 20.26 | 9,311 | 9% | 513% | 3.46% |
| QTRH | 30 | 1.68 | 199 | 31% | 93% | 2.33% |
| TRNC | 31 | 20.24 | 676 | 14% | 113% | 0.00% |
| NLS | 32 | 11.90 | 370 | 14% | 106% | 0.00% |
| ACOR | 33 | 25.80 | 1,193 | 9% | 308% | 0.00% |
| MEET | 34 | 2.70 | 205 | 10% | 215% | 0.00% |
| VIAB | 35 | 33.50 | 13,487 | 12% | 128% | 2.39% |
| DISCK | 36 | 22.65 | 12,933 | 10% | 165% | 0.00% |
| HPQ | 37 | 21.40 | 36,102 | 9% | 214% | 2.51% |
| DISCA | 38 | 23.86 | 13,624 | 10% | 165% | 0.00% |
| AMCX | 39 | 52.58 | 3,389 | 13% | 100% | 0.00% |
| VIA | 40 | 39.90 | 16,064 | 11% | 128% | 2.01% |
| AEIS | 41 | 65.56 | 2,626 | 9% | 208% | 0.00% |
| QIWI | 42 | 17.00 | 1,041 | 8% | 728% | 3.65% |
| LEE | 43 | 2.45 | 137 | 14% | 81% | 0.00% |
| TARO | 44 | 101.60 | 4,096 | 15% | 77% | 0.00% |
| OMC | 45 | 78.72 | 18,287 | 8% | 283% | 2.86% |
| CSVI | 46 | 45.00 | 628 | 9% | 142% | 2.62% |
| DFIN | 47 | 20.37 | 689 | 10% | 109% | 0.00% |
| HSII | 48 | 25.25 | 480 | 11% | 100% | 1.85% |
| SP | 49 | 37.25 | 839 | 8% | 312% | 0.00% |
| SYNT | 50 | 26.87 | 2,237 | 10% | 127% | 0.00% |
| KLAC | 51 | 107.52 | 16,836 | 9% | 195% | 2.15% |
| KLIC | 52 | 22.02 | 1,554 | 17% | 70% | 0.00% |
| DIN | 53 | 54.67 | 970 | 10% | 111% | 0.00% |
| NVMI | 54 | 27.10 | 780 | 9% | 129% | 0.00% |
| WDC | 55 | 84.91 | 25,133 | 11% | 88% | 2.36% |
| USNA | 56 | 77.15 | 1,852 | 9% | 142% | 0.00% |
| AMAG | 57 | 18.50 | 653 | 8% | 381% | 0.00% |
| ANTM | 58 | 235.00 | 61,876 | 8% | 246% | 1.15% |
| AMGN | 59 | 183.55 | 132,890 | 8% | 210% | 0.00% |
| ALSN | 60 | 39.32 | 5,583 | 9% | 146% | 1.53% |
| GPP | 61 | 18.00 | 573 | 9% | 120% | 10.11% |
| COH | 62 | 0.41 | 143 | 69% | 63% | 0.00% |
| BIIB | 63 | 291.87 | 61,876 | 9% | 137% | 0.00% |
| PDLI | 64 | 2.47 | 376 | 26% | 60% | 0.00% |
| MIK | 65 | 24.58 | 4,473 | 10% | 83% | 0.00% |
| LRCX | 66 | 187.91 | 30,279 | 9% | 101% | 0.98% |
| NCR | 67 | 32.63 | 3,978 | 10% | 89% | 0.00% |
| FUJHY | 68 | 17.47 | 26,789 | 18% | 58% | 3.67% |
| BKE | 69 | 21.95 | 1,061 | 16% | 60% | 4.56% |
| CELG | 70 | 95.26 | 73,684 | 7% | 525% | 0.00% |
| YUM | 71 | 78.25 | 26,996 | 8% | 167% | 1.61% |
| TWX | 72 | 95.37 | 75,495 | 9% | 124% | 1.69% |
| CPLA | 73 | 80.85 | 965 | 8% | 178% | 2.05% |
| UIS | 74 | 11.15 | 809 | 10% | 75% | 0.00% |
| ENDP | 75 | 6.88 | 1,536 | 8% | 137% | 0.00% |
| PBH | 76 | 35.21 | 1,885 | 8% | 149% | 0.00% |
| CRUS | 77 | 41.77 | 2,738 | 12% | 65% | 0.00% |
| ODP | 78 | 3.18 | 1,689 | 23% | 54% | 3.14% |
| BOJA | 79 | 12.10 | 466 | 9% | 100% | 0.00% |
| THO | 80 | 124.83 | 6,593 | 10% | 81% | 1.12% |
| BSTC | 81 | 39.95 | 292 | 7% | 345% | 0.00% |
| PTN | 82 | 0.97 | 195 | 7% | 6550% | 0.00% |
| NATH | 83 | 68.00 | 285 | 7% | 329% | 0.00% |
| GHC | 84 | 599.80 | 3,331 | 9% | 101% | 0.86% |
| CVS | 85 | 71.90 | 73,194 | 10% | 72% | 2.78% |
| RGR | 86 | 50.30 | 896 | 11% | 64% | 2.70% |
| LEA | 87 | 189.57 | 12,986 | 12% | 61% | 1.06% |
| SIMO | 88 | 44.77 | 1,604 | 9% | 80% | 2.23% |
| AMAT | 89 | 55.03 | 58,937 | 8% | 180% | 0.73% |
| ESIO | 90 | 17.24 | 621 | 11% | 63% | 0.00% |
| MCFT | 91 | 25.16 | 471 | 7% | 211% | 0.00% |
| HLF | 92 | 83.72 | 6,949 | 8% | 157% | 0.00% |
| VVV | 93 | 23.37 | 4,721 | 9% | 80% | 0.95% |
| HMTV | 94 | 11.25 | 460 | 8% | 104% | 0.00% |
| TER | 95 | 43.31 | 8,489 | 8% | 148% | 0.65% |
| NCMI | 96 | 7.05 | 453 | 8% | 155% | 12.48% |
| SBH | 97 | 17.20 | 2,213 | 12% | 54% | 0.00% |
| SNE | 98 | 49.55 | 64,049 | 9% | 88% | 0.41% |
| BBY | 99 | 73.18 | 22,349 | 9% | 79% | 1.86% |
| PBT | 100 | 9.43 | 440 | 7% | 14593% | 6.80% |
| TVTY | 101 | 38.80 | 1,689 | 7% | 1208% | 0.00% |
| EME | 102 | 76.64 | 4,554 | 8% | 106% | 0.42% |
| PBI | 103 | 12.34 | 2,320 | 9% | 81% | 6.08% |
| CLCT | 104 | 15.56 | 139 | 8% | 121% | 7.87% |
| BGSF | 105 | 16.94 | 154 | 9% | 79% | 5.90% |
| MANH | 106 | 42.97 | 2,956 | 7% | 1217% | 0.00% |
| FFIV | 107 | 145.03 | 9,072 | 7% | 496% | 0.00% |
| KBAL | 108 | 16.71 | 631 | 10% | 65% | 1.56% |
| UCTT | 109 | 19.19 | 659 | 12% | 51% | 0.00% |
| MAN | 110 | 121.92 | 8,205 | 10% | 63% | 1.53% |
| EBF | 111 | 20.20 | 513 | 11% | 55% | 3.84% |
| FL | 112 | 49.17 | 6,215 | 15% | 45% | 2.52% |
| AYI | 113 | 151.14 | 6,363 | 8% | 89% | 0.34% |
| ETM | 114 | 10.40 | 413 | 9% | 68% | 3.03% |
| LPX | 115 | 29.25 | 4,288 | 14% | 46% | 1.78% |
| SJT | 116 | 9.24 | 431 | 7% | 13785% | 9.37% |
| AVP | 117 | 2.73 | 1,202 | 12% | 50% | 0.00% |
| CA | 118 | 35.34 | 14,595 | 7% | 475% | 2.89% |
| WGO | 119 | 42.70 | 1,357 | 9% | 72% | 0.94% |
| ABC | 120 | 99.40 | 21,950 | 8% | 112% | 1.50% |
| CKHUY | 121 | 12.73 | 49,108 | 12% | 49% | 0.00% |
| MDP | 122 | 55.65 | 2,538 | 8% | 87% | 3.74% |
| OMAB | 123 | 40.08 | 1,972 | 8% | 113% | 4.21% |
| CSCO | 124 | 44.33 | 218,281 | 7% | 406% | 2.62% |
| CRTO | 125 | 31.00 | 2,101 | 8% | 86% | 0.00% |
| OCLR | 126 | 6.87 | 1,173 | 13% | 43% | 0.00% |
| TPB | 127 | 21.41 | 419 | 8% | 81% | 0.19% |
| TNET | 128 | 41.66 | 2,979 | 7% | 309% | 0.00% |
| RPXC | 129 | 13.07 | 658 | 6% | 619% | 0.38% |
| ROCK | 130 | 31.80 | 1,024 | 9% | 61% | 0.00% |
| FRAN | 131 | 5.53 | 199 | 24% | 39% | 0.00% |
| BAH | 132 | 38.30 | 5,614 | 7% | 126% | 1.83% |
| GIB | 133 | 58.86 | 17,162 | 7% | 236% | 0.00% |
| WCG | 134 | 193.21 | 8,721 | 7% | 182% | 0.00% |
| NTRI | 135 | 42.60 | 1,291 | 7% | 255% | 1.64% |
| PLUS | 136 | 76.00 | 1,063 | 10% | 55% | 0.00% |
| SBGI | 137 | 36.30 | 3,741 | 8% | 77% | 1.98% |
| ENR | 138 | 53.85 | 3,312 | 8% | 87% | 2.10% |
| SAFM | 139 | 133.41 | 2,988 | 17% | 38% | 0.84% |
| PMD | 140 | 21.29 | 118 | 9% | 66% | 2.82% |
| FTD | 141 | 6.07 | 167 | 8% | 78% | 0.00% |
| SNI | 142 | 87.81 | 11,526 | 8% | 82% | #VALUE! |
| SHI | 143 | 58.50 | 6,325 | 15% | 39% | 6.20% |
| BLBD | 144 | 22.45 | 537 | 7% | 136% | 0.00% |
| HI | 145 | 45.75 | 2,933 | 7% | 121% | 1.80% |
| TPIC | 146 | 19.48 | 682 | 10% | 52% | 0.00% |
| EGL | 147 | 26.44 | 987 | 7% | 110% | 0.00% |
| AAPL | 148 | 172.43 | 889,357 | 7% | 191% | 0.00% |
| NLSN | 149 | 33.68 | 12,037 | 7% | 215% | 3.95% |
| TJX | 150 | 77.88 | 50,068 | 8% | 77% | 1.61% |
| MMS | 151 | 67.26 | 4,451 | 7% | 92% | 0.27% |
| MU | 152 | 44.21 | 54,157 | 15% | 36% | 0.00% |
| PPC | 153 | 27.00 | 6,723 | 13% | 39% | 0.00% |
| OSB | 154 | 36.87 | 3,189 | 16% | 36% | 3.18% |
| GTS | 155 | 25.48 | 617 | 8% | 71% | 0.00% |
| SWKS | 156 | 104.11 | 19,312 | 7% | 85% | 1.15% |
| JMEI | 157 | 2.88 | 433 | 70% | 34% | 0.00% |
| RECN | 158 | 15.60 | 477 | 8% | 62% | 3.01% |
| CR | 159 | 94.59 | 5,619 | 7% | 83% | 0.00% |
| GTN | 160 | 15.00 | 1,087 | 9% | 54% | 0.00% |
| BC | 161 | 59.04 | 5,219 | 10% | 49% | 0.00% |
| APEI | 162 | 25.90 | 424 | 12% | 38% | 0.00% |
| UEPS | 163 | 10.35 | 579 | 12% | 39% | 0.00% |
| JCOM | 164 | 77.38 | 3,748 | 6% | 325% | 1.96% |
| ORCL | 165 | 50.71 | 217,191 | 6% | 230% | 1.50% |
| HCKT | 166 | 16.29 | 521 | 7% | 106% | 1.84% |
| ATTO | 167 | 9.65 | 712 | 11% | 40% | #VALUE! |
| MLHR | 168 | 37.25 | 2,245 | 9% | 59% | 1.88% |
| AAOI | 169 | 31.99 | 653 | 15% | 34% | 0.00% |
| TNH | 170 | 83.90 | 1,552 | 9% | 48% | 7.10% |
| LCI | 171 | 17.05 | 653 | 13% | 36% | 0.00% |
| ACCO | 172 | 13.65 | 1,491 | 10% | 43% | 1.76% |
| MCK | 173 | 150.50 | 31,304 | 7% | 77% | 0.82% |
| IMBBY | 174 | 37.94 | 36,305 | 7% | 140% | 5.69% |
| TVPT | 175 | 13.22 | 1,668 | 8% | 73% | 2.27% |
| AVID | 176 | 4.84 | 200 | 7% | 115% | 0.00% |
| SNA | 177 | 160.88 | 9,315 | 9% | 52% | 1.83% |
| VGR | 178 | 20.29 | 2,694 | 6% | 254% | 7.60% |
| WINA | 179 | 127.10 | 548 | 6% | 254% | 0.35% |
| STX | 180 | 51.42 | 14,963 | 7% | 74% | 0.00% |
| JAZZ | 181 | 145.76 | 8,955 | 6% | 199% | 0.00% |
| MOMO | 182 | 31.05 | 6,475 | 6% | 1056% | 0.00% |
| GPS | 183 | 33.27 | 13,075 | 10% | 40% | 0.00% |
| RL | 184 | 105.59 | 8,627 | 9% | 47% | 1.89% |
| TSQ | 185 | 7.01 | 196 | 10% | 41% | 0.00% |
| KNMCY | 186 | 50.20 | 6,900 | 8% | 66% | 1.24% |
| MAS | 187 | 43.21 | 13,568 | 7% | 74% | 0.95% |
| FOX | 188 | 37.04 | 68,709 | 7% | 95% | 0.00% |
| BAYRY | 189 | 30.73 | 26,811 | 20% | 31% | 2.41% |
| ITRN | 190 | 33.80 | 709 | 8% | 65% | 3.31% |
| GNC | 191 | 4.36 | 306 | 13% | 33% | 0.00% |
| FOXA | 192 | 37.46 | 69,488 | 7% | 95% | 0.96% |
| LYB | 193 | 108.61 | 42,901 | 11% | 36% | 3.27% |
| CSGS | 194 | 47.68 | 1,573 | 7% | 83% | 1.66% |
| ORIG | 195 | 25.08 | 223 | 1221% | 29% | 0.00% |
| AOBC | 196 | 10.74 | 587 | 13% | 32% | 0.00% |
| SPOK | 197 | 14.60 | 292 | 7% | 97% | 3.42% |
| CLF | 198 | 7.92 | 2,383 | 11% | 35% | 0.00% |
| MGLN | 199 | 97.60 | 2,397 | 7% | 79% | 0.00% |
| DGX | 200 | 104.53 | 14,530 | 7% | 95% | 1.72% |
People should always do their own due diligence as always possible I make mistakes. The yields should also always be checked as sometimes they are backwards looking, exclude special dividends etc.
Here is the official top 200 list. I do not match as well as "normal". I believe this is because we are in the thick of earnings season and it is possible there could be timing differences on balance sheets or income statements. Like I do not have DLX as my pull from Fidelity shows some balance sheet items as "N/A". I am sure if I run a week from now, Fidelity will have populated those fields.
| Ticker | Mkt Cap | Date | My Ranking | Price | EY | ROIC |
| ACOR | 1,193 | 16-Feb | 33 | 25.80 | 9% | 308% |
| AEIS | 2,599 | 16-Feb | 41 | 65.56 | 9% | 208% |
| ALSN | 5,504 | 16-Feb | 60 | 39.32 | 9% | 146% |
| AMAG | 654 | 16-Feb | 57 | 18.50 | 8% | 381% |
| AMCX | 3,297 | 16-Feb | 39 | 52.58 | 13% | 100% |
| ABC | 21,719 | 16-Feb | 120 | 99.40 | 8% | 112% |
| AGX | 628 | 16-Feb | 6 | 40.40 | 37% | 838% |
| HRB | 5,862 | 16-Feb | 26 | 28.04 | 10% | 270% |
| BPT | 452 | 16-Feb | 7 | 21.10 | 17% | 38570% |
| CASA | 649 | 16-Feb | #N/A | #N/A | #N/A | #N/A |
| CERC | 105 | 16-Feb | #N/A | #N/A | #N/A | #N/A |
| CNCE | 527 | 16-Feb | 4 | 21.48 | 31% | 4417% |
| CJREF | 1,346 | 16-Feb | 23 | 6.50 | 12% | 165% |
| DLX | 3,469 | 16-Feb | #N/A | #N/A | #N/A | #N/A |
| DIN | 984 | 16-Feb | 53 | 54.67 | 10% | 111% |
| DISCA | 13,624 | 16-Feb | 38 | 23.86 | 10% | 165% |
| EGRX | 1,034 | 16-Feb | 24 | 64.78 | 11% | 179% |
| EVC | 615 | 16-Feb | 8 | 6.80 | 46% | 334% |
| ESRX | 42,610 | 16-Feb | 27 | 75.23 | 9% | 426% |
| GME | 1,661 | 16-Feb | 22 | 16.40 | 26% | 109% |
| HSII | 474 | 16-Feb | 48 | 25.25 | 11% | 100% |
| HPQ | 35,224 | 16-Feb | 37 | 21.40 | 9% | 214% |
| IDCC | 2,754 | 16-Feb | 9 | 79.35 | 17% | 585% |
| KLAC | 16,840 | 16-Feb | 51 | 107.52 | 9% | 195% |
| LEE | 140 | 16-Feb | 43 | 2.45 | 14% | 81% |
| MSB | 348 | 16-Feb | 14 | 26.55 | 10% | 16407% |
| MPAA | 438 | 16-Feb | 21 | 22.96 | 10% | 244% |
| MSGN | 1,886 | 16-Feb | 18 | 25.05 | 10% | 265% |
| NHTC | 196 | 16-Feb | 3 | 17.25 | 51% | 3748% |
| NLS | 365 | 16-Feb | 32 | 11.90 | 14% | 106% |
| EGOV | 928 | 16-Feb | 15 | 14.00 | 10% | 760% |
| OMC | 18,113 | 16-Feb | 45 | 78.72 | 8% | 283% |
| OPHT | 103 | 16-Feb | 1 | 2.86 | 2441% | 5362% |
| PTN | 180 | 16-Feb | 82 | 0.97 | 7% | 6550% |
| PDLI | 381 | 16-Feb | 64 | 2.47 | 26% | 60% |
| PCOA | 136 | 16-Feb | #N/A | #N/A | #N/A | #N/A |
| QTRH | 199 | 16-Feb | 30 | 1.68 | 31% | 93% |
| SQBG | 109 | 16-Feb | 16 | 1.73 | 12% | 210% |
| SP | 827 | 16-Feb | 49 | 37.25 | 8% | 312% |
| SYNT | 2,226 | 16-Feb | 50 | 26.87 | 10% | 127% |
| TGNA | 2,965 | 16-Feb | 28 | 13.78 | 12% | 141% |
| MEET | 194 | 16-Feb | 34 | 2.70 | 10% | 215% |
| TRNC | 679 | 16-Feb | 31 | 20.24 | 14% | 113% |
| TUP | 2,598 | 16-Feb | #N/A | #N/A | #N/A | #N/A |
| UIS | 563 | 16-Feb | 74 | 11.15 | 10% | 75% |
| UTHR | 6,175 | 16-Feb | 13 | 134.93 | 21% | 206% |
| USNA | 1,847 | 16-Feb | 56 | 77.15 | 9% | 142% |
| VEC | 312 | 16-Feb | 17 | 28.13 | 13% | 174% |
| VIAB | 13,484 | 16-Feb | 35 | 33.50 | 12% | 128% |
| WDC | 25,218 | 16-Feb | 55 | 84.91 | 11% | 88% |
CASA just doesn't show data in Fidelity, they are a recent IPO. CERC is right on the cusp of my 100m market cap pull. So if they were under $100m when I created my stock list they could be excluded. DLX is timing. PCOA, as far as I can tell, has been delisted and no longer trades. TUP is like DLX... but not sure why Fidelity has N/As as they reported 18 days ago.
Posts
No comments:
Post a Comment