Sunday, March 08, 2015

MFI Top 200 List - March 8th, 2015

Top 200 List

I last created a top 200 list on 2/20. It does take some time,  As I mentioned a couple months ago,  I am expanding the data I bring in... it will take time to build a database, but ten years from now I might be able to tell you something new!

As my readers know, I like to replicate the official MFI site (Magic Formula Investing) every now and then.  I add a few extra elements such as (1) country, (2) yahoo yield, (3) my calculated stats, (4) ranking and (5) 200 stocks.

If anyone could think of any other stats that might be interesting, then let me know.  I have now started using price to tangible book.  The data is from GuruFocus.  I have brought in a ton of other data from Gurufocus as well.

I did have to make some changes this time.  Historically, I have always pulled in my list of all stocks from Finwiz.  However, they have now locked the ability to export under "premium" membership.  So I tried using Gurufocus this time.  In total, it is probably a better approach.  However, some stocks didn't even show up to be calculated (like ADMS, AVID, NHTC) so I had to manually add those to the list to be included. I want to stay away from manual intervention as much as possible, so I will need to figure out why Gurufocus did not have them.  One thing lost from Finwiz was country. So that is no longer in my table.

I think my approach is pretty darned accurate.  I use Compustat as well and formulas that were devised by a team on the Yahoo Groups board and detailed in my blog (MFI Diary: The Calculation).  I also cross reference my list with the official top 50 and they are almost always within my top 100 (I have more on my list as I do not exclude some stocks the official site excludes, such as some stocks in other countries).

Be aware that this is all formula driven, I have tried using Gurufocus for dividend yields - I found it was also unreliable..  The main financials (from Compustat) have seemed very reliable to me.

Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield
ACHI 1           5.99            593 40% 1463% 0.00%
ADMS 2         16.86            283 24% 8262% 0.00%
PDLI 3           6.70        1,138 35% 843% 8.45%
PERI 4           3.55            247 31% 570% 0.00%
CALL 5           7.80            139 22% 639% 0.00%
AGX 6         31.63            468 18% 990% 2.16%
MTEX 7         18.60              51 38% 311% #VALUE!
GAME 8           5.78        1,572 16% 1001% 0.00%
KING 9         14.46        4,659 20% 380% 9.43%
KZ 10           4.96            231 28% 263% 17.22%
CTCM 11           4.17            651 45% 167% 15.70%
NHTC 12         15.65            200 12% 4374% 0.50%
NHTC 13         15.65            200 12% 4374% 0.20%
HLF 14         32.69        2,795 19% 212% 0.00%
LFVN 15           0.80              81 20% 187% 0.00%
JOE 16         16.47        1,520 31% 159% 0.00%
VEC 17         31.35            335 13% 393% 0.00%
IDCC 18         52.07        1,972 11% 1370% 1.31%
RPXC 19         14.23            783 11% 1525% 0.00%
PSDV 20           4.47            131 11% 3938% 0.00%
ANTM 21      145.16      40,775 12% 260% 1.33%
HRB 22         32.12        8,839 12% 342% 2.50%
ASPS 23         18.54            438 24% 112% 0.00%
NSR 24         22.08        1,265 16% 144% 0.00%
IQNT 25         15.59            527 15% 140% 3.88%
ENTA 26         34.97            674 17% 118% 0.00%
TNH 27      144.27        2,669 14% 143% 7.07%
CRT 28         21.65            130 12% 167% 11.25%
TZOO 29           9.77            144 13% 149% 0.00%
NTIP 30           2.29              57 10% 476% 0.00%
PNLYY 31           4.54        1,998 20% 97% 0.00%
SJT 32         13.51            630 10% 1453% 8.93%
LQDT 33           9.69            290 15% 110% 0.00%
GME 34         40.16        4,534 13% 127% 3.30%
MNDO 35           3.90              74 10% 930% 6.14%
CBI 36         45.26        4,954 13% 117% 0.61%
SGU 37           7.41            425 17% 93% 4.69%
SFUN 38           6.14        2,799 12% 142% 3.25%
NEWT 39         17.48            135 11% 232% 0.00%
HUM 40      159.73      24,530 11% 166% 0.68%
IRS 41         17.27            980 10% 527% 0.70%
LUCRF 42           1.52            578 33% 74% 4.70%
WSTG 43         17.25              82 14% 98% 4.00%
AET 44      100.67      35,698 10% 629% 0.91%
PETS 45         15.22            307 11% 141% 4.50%
CJREF 46         17.32        1,489 11% 192% 5.71%
STRA 47         59.77            642 13% 99% 0.00%
WILN 48           2.56            308 9% 1168% 6.40%
ANIK 49         39.63            605 12% 106% 0.00%
TSRA 50         39.92        2,140 9% 1365% 2.07%
ONE 51           2.86            136 17% 77% 0.00%
BKE 52         47.93        2,304 12% 100% 7.56%
SPOK 53         17.36            384 10% 170% 2.72%
PPC 54         26.43        6,860 19% 69% 21.22%
CLCT 55         22.46            191 9% 707% 6.10%
HNT 56         56.09        4,458 9% 379% 0.00%
DLX 57         63.84        3,192 9% 400% 1.83%
GCA 58           7.08            473 10% 231% 0.00%
NLNK 59         48.65        1,525 9% 1157% 0.00%
GILD 60      101.81    162,591 9% 377% 0.00%
FLR 61         57.29        8,949 14% 81% 1.08%
APOL 62         27.06        2,960 14% 80% 0.00%
PBI 63         22.10        4,489 10% 147% 3.35%
UIS 64         23.77        1,187 13% 84% #VALUE!
VIAB 65         70.32      29,260 10% 219% 1.83%
VIA 66         70.35      29,273 10% 219% 1.90%
CTP 67           6.22              48 15% 71% 0.00%
BCOR 68         14.39            587 10% 211% 0.00%
GORO 69           3.16            171 17% 66% 3.31%
FUJHY 70         65.93      25,725 15% 71% 1.40%
SMT 71           1.35            171 25% 62% 0.00%
CSCO 72         28.93    149,253 9% 342% 2.59%
ATAI 73           3.90              89 15% 69% 10.10%
USNA 74         98.80        1,276 10% 163% 0.00%
CSIQ 75         33.55        2,020 18% 63% 0.00%
PFMT 76           4.23            209 11% 99% 0.00%
MSFT 77         42.36    351,461 9% 207% 2.74%
CPLA 78         64.75            810 9% 179% 2.16%
BREUF 79         11.10            105 9% 613% 9.36%
RTN 80      105.22      32,587 10% 166% 2.26%
APEI 81         30.20            524 15% 64% 0.00%
CA 82         31.71      13,984 9% 460% 3.13%
BBX 83         13.90            222 39% 54% 0.00%
BRCD 84         12.13        5,327 10% 110% 1.13%
STRZA 85         33.35        3,548 10% 123% 0.00%
COH 86         41.43      11,455 10% 116% 3.21%
UEPS 87         14.05            647 18% 55% 0.00%
FENG 88           7.20            557 13% 64% 0.00%
CRWN 89           3.50        1,259 10% 90% 0.00%
VIV 90         16.38      12,153 28% 51% 12.87%
REX 91         58.00            474 30% 50% 0.00%
ITRN 92         22.54            473 10% 92% 4.28%
TDC 93         42.89        6,609 8% 303% 0.00%
KORS 94         65.98      13,569 10% 101% 0.00%
PRISY 95           1.37            409 10% 85% 0.00%
GIB 96         41.96      13,431 8% 309% 0.00%
SAFM 97         82.30        1,856 26% 49% 1.60%
ORCL 98         42.38    190,922 8% 474% 1.10%
NCI 99         13.34            661 11% 67% 0.00%
CDPYF 100         22.16        2,481 8% 7652% 4.65%
SLI 101         40.41            170 14% 57% 0.00%
EGL 102         34.02            615 11% 79% 0.00%
MAN 103         78.58        6,271 12% 63% 1.22%
EME 104         44.29        2,874 10% 90% 0.70%
LO 105         66.99      24,096 8% 690% 3.69%
CTG 106           7.55            121 21% 49% 3.20%
NUS 107         54.31        3,283 12% 61% 3.26%
LEE 108           3.03            163 11% 67% 0.00%
QCOM 109         71.51    120,557 8% 337% 2.37%
AVID 110         15.70            615 9% 157% 0.00%
KFY 111         30.74        1,529 9% 114% 0.00%
RCII 112         27.35        1,458 8% 305% 3.50%
LOGI 113         13.60        2,262 9% 112% 3.43%
GPS 114         40.72      17,428 12% 60% 2.12%
AVP 115           8.90        3,869 13% 54% 2.65%
LYB 116         87.40      43,613 14% 52% 3.20%
KLIC 117         16.11        1,247 15% 49% 0.00%
CPSI 118         52.63            582 9% 108% 4.44%
BBY 119         39.71      14,145 12% 55% 1.82%
GD 120      134.60      45,199 9% 118% 1.82%
UNH 121      112.88    109,832 8% 233% 1.22%
COSM 122           0.75              94 9% 120% 0.00%
CCNMF 123           1.62              80 10% 66% 4.40%
LCI 124         63.20        2,343 9% 105% 0.00%
PEIX 125         11.33            279 34% 41% 0.00%
EMR 126         56.56      39,292 10% 73% 3.10%
IBM 127      158.50    157,771 10% 80% 2.70%
CSC 128         68.86        9,684 11% 60% 1.27%
HGT 129           7.67            307 14% 48% 13.68%
EMMS 130           1.83              87 9% 86% #VALUE!
DHX 131           8.92            481 8% 291% 0.00%
UBNT 132         31.38        2,816 8% 218% 0.53%
OUTR 133         65.22        1,217 11% 57% #VALUE!
NTES 134      100.76      13,244 8% 369% 1.44%
TUP 135         67.77        3,429 9% 82% 3.92%
EGY 136           4.77            276 43% 40% 0.00%
SYMC 137         24.17      16,843 8% 126% 2.44%
STV 138           3.61            225 12% 51% 13.81%
NATR 139         12.20            235 15% 45% 15.91%
NCIT 140         11.35            154 11% 53% 1.05%
CO 141           4.66            340 26% 40% 0.00%
SNDK 142         80.66      18,937 8% 113% 1.36%
FOSL 143         81.13        4,162 12% 48% 0.00%
NOC 144      160.41      32,756 9% 104% 1.71%
NOV 145         52.54      22,487 17% 41% 3.01%
NVMI 146         11.43            314 9% 89% 0.00%
CR 147         65.43        3,883 10% 69% 1.94%
GSB 148           3.22              67 7% 749% 1.55%
OMC 149         77.11      19,270 8% 258% 2.55%
MBT 150           9.30        9,249 20% 39% 3.27%
CHE 151      115.48        2,017 8% 162% 0.74%
UG 152         18.50              85 8% 160% 4.24%
EVOL 153           8.31              99 8% 116% 4.99%
HRS 154         75.20        7,888 9% 69% 2.41%
WINA 155         80.00            413 8% 197% 0.30%
LEA 156      107.89        8,728 11% 52% 0.78%
FRAN 157         14.21            602 10% 57% 0.00%
CSVI 158         41.50            586 8% 117% 1.85%
HPQ 159         33.18      61,748 10% 63% 1.84%
MGIC 160           6.92            308 9% 90% 1.37%
CI 161      120.57      31,865 10% 56% 0.03%
TRW 162      104.58      11,682 11% 51% 0.00%
PRGS 163         26.68        1,364 8% 150% 0.00%
XLNX 164         40.58      11,111 8% 129% 2.10%
BBBY 165         73.66      13,538 11% 50% 0.00%
DNB 166      129.05        4,685 7% 1620% 1.40%
EDGW 167           6.99              92 10% 63% 0.00%
TMICY 168         34.00        4,703 7% 680% 3.12%
BAH 169         29.02        4,373 8% 150% 4.95%
GRMN 170         49.64        9,549 8% 95% 3.80%
PNTR 171           8.85              70 9% 68% 0.00%
ACN 172         90.67      61,867 7% 562% 2.12%
HURN 173         62.54        1,410 8% 100% 0.00%
GCI 174         34.57        7,991 10% 64% 2.30%
GHM 175         23.47            238 11% 53% 1.40%
DISCK 176         31.77      21,159 8% 184% 0.00%
IPCM 177         42.31            747 8% 102% 0.00%
IBA 178         49.25        2,463 20% 36% 0.00%
PLOW 179         22.46            499 11% 50% 3.79%
VOC 180           5.14              87 39% 33% 26.49%
DOV 181         70.71      11,771 9% 70% 2.69%
MYGN 182         35.13        2,649 8% 157% 0.00%
ATVI 183         23.07      16,818 7% 754% 0.86%
NVDA 184         22.55      12,551 8% 101% 1.50%
MED 185         31.32            394 8% 81% 0.00%
NTAP 186         38.20      12,113 9% 78% 1.67%
MLHR 187         28.06        1,684 9% 64% 1.94%
SYNT 188         49.49        4,160 8% 128% 0.00%
TARO 189      150.82        6,460 8% 94% 0.00%
STX 190         56.90      19,118 9% 66% 2.58%
FLWS 191         12.23            820 10% 56% 0.00%
HSII 192         23.16            429 8% 88% 2.23%
DISCA 193         33.08      22,031 7% 184% 0.00%
JEC 194         43.09        5,601 11% 47% 0.00%
LMT 195      197.66      63,370 8% 113% 2.84%
CBD 196         31.69        5,252 21% 33% 1.36%
DOX 197         51.81        8,192 7% 163% 1.18%
NOK 198           7.83      31,215 7% 217% 6.34%
LBMH 199           3.59            193 7% 219% 3.39%
CALM 200         36.27        1,756 12% 40% 2.56%


Here is the Cross Reference List.  


Ticker Mkt Cap Date My Ranking Price EY ROIC
ACHI 575 6-Mar 1          5.99 40% 1463%
ADMS 286 6-Mar 2       16.86 24% 8262%
ANIK 589 6-Mar 49       39.63 12% 106%
APOL 2,932 6-Mar 62       27.06 14% 80%
AGX 460 6-Mar 6       31.63 18% 990%
AVID 616 6-Mar 110       15.70 9% 157%
HRB 8,841 6-Mar 22       32.12 12% 342%
BCOR 576 6-Mar 68       14.39 10% 211%
BRCD 5,139 6-Mar 84       12.13 10% 110%
BKE 2,319 6-Mar 52       47.93 12% 100%
CPLA 793 6-Mar 78       64.75 9% 179%
CSCO 147,720 6-Mar 72       28.93 9% 342%
CLCT 200 6-Mar 55       22.46 9% 707%
DLX 3,185 6-Mar 57       63.84 9% 400%
ENTA 650 6-Mar 26       34.97 17% 118%
FLR 8,515 6-Mar 61       57.29 14% 81%
GME 4,389 6-Mar 34       40.16 13% 127%
GILD 152,613 6-Mar 60     101.81 9% 377%
GORO 171 6-Mar 69          3.16 17% 66%
ONE 136 6-Mar 51          2.86 17% 77%
IQNT 522 6-Mar 25       15.59 15% 140%
IDCC 1,922 6-Mar 18       52.07 11% 1370%
KING 4,656 6-Mar 9       14.46 20% 380%
LFVN 79 6-Mar 15          0.80 20% 187%
LQDT 290 6-Mar 33          9.69 15% 110%
MSB 228 6-Mar #N/A #N/A #N/A #N/A
MSFT 348,115 6-Mar 77       42.36 9% 207%
MNDO 74 6-Mar 35          3.90 10% 930%
NHTC 200 6-Mar 12       15.65 12% 4374%
NSR 1,216 6-Mar 24       22.08 16% 144%
PDLI 1,080 6-Mar 3          6.70 35% 843%
PFMT 209 6-Mar 76          4.23 11% 99%
PETS 308 6-Mar 45       15.22 11% 141%
PPC 6,845 6-Mar 54       26.43 19% 69%
PBI 4,442 6-Mar 63       22.10 10% 147%
PSDV 131 6-Mar 20          4.47 11% 3938%
RTN 32,334 6-Mar 80     105.22 10% 166%
RPXC 802 6-Mar 19       14.23 11% 1525%
SMT 165 6-Mar 71          1.35 25% 62%
STRZA 3,393 6-Mar 85       33.35 10% 123%
STRA 652 6-Mar 47       59.77 13% 99%
TDC 6,343 6-Mar 93       42.89 8% 303%
TSRA 2,109 6-Mar 50       39.92 9% 1365%
TZOO 144 6-Mar 29          9.77 13% 149%
UIS 1,187 6-Mar 64       23.77 13% 84%
USNA 1,222 6-Mar 74       98.80 10% 163%
VEC 329 6-Mar 17       31.35 13% 393%
VIAB 28,641 6-Mar 65       70.32 10% 219%
WSTG 84 6-Mar 43       17.25 14% 98%
WILN 308 6-Mar 48          2.56 9% 1168%


Dividend Stocks

I thought it would be useful to see the subset of my top 200 that are market cap > 600m and dividend yield > 2.4%.


Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield
PDLI 3           6.70        1,138 35% 843% 8.45%
KING 9         14.46        4,659 20% 380% 9.43%
CTCM 11           4.17            651 45% 167% 15.70%
HRB 22         32.12        8,839 12% 342% 2.50%
TNH 27      144.27        2,669 14% 143% 7.07%
SJT 32         13.51            630 10% 1453% 8.93%
GME 34         40.16        4,534 13% 127% 3.30%
SFUN 38           6.14        2,799 12% 142% 3.25%
CJREF 46         17.32        1,489 11% 192% 5.71%
BKE 52         47.93        2,304 12% 100% 7.56%
PPC 54         26.43        6,860 19% 69% 21.22%
PBI 63         22.10        4,489 10% 147% 3.35%
CSCO 72         28.93    149,253 9% 342% 2.59%
MSFT 77         42.36    351,461 9% 207% 2.74%
CA 82         31.71      13,984 9% 460% 3.13%
COH 86         41.43      11,455 10% 116% 3.21%
VIV 90         16.38      12,153 28% 51% 12.87%
CDPYF 100         22.16        2,481 8% 7652% 4.65%
LO 105         66.99      24,096 8% 690% 3.69%
NUS 107         54.31        3,283 12% 61% 3.26%
RCII 112         27.35        1,458 8% 305% 3.50%
LOGI 113         13.60        2,262 9% 112% 3.43%
AVP 115           8.90        3,869 13% 54% 2.65%
LYB 116         87.40      43,613 14% 52% 3.20%
EMR 126         56.56      39,292 10% 73% 3.10%
IBM 127      158.50    157,771 10% 80% 2.70%
TUP 135         67.77        3,429 9% 82% 3.92%
SYMC 137         24.17      16,843 8% 126% 2.44%
NOV 145         52.54      22,487 17% 41% 3.01%
OMC 149         77.11      19,270 8% 258% 2.55%
MBT 150           9.30        9,249 20% 39% 3.27%
HRS 154         75.20        7,888 9% 69% 2.41%
TMICY 168         34.00        4,703 7% 680% 3.12%
BAH 169         29.02        4,373 8% 150% 4.95%
GRMN 170         49.64        9,549 8% 95% 3.80%
DOV 181         70.71      11,771 9% 70% 2.69%
STX 190         56.90      19,118 9% 66% 2.58%
LMT 195      197.66      63,370 8% 113% 2.84%
NOK 198           7.83      31,215 7% 217% 6.34%
CALM 200         36.27        1,756 12% 40% 2.56%



1 comment:

Erik said...

I am trying to figure out a way to analyze the worst performing MFI stocks for the last 10 years. See if there is a pattern, common reason to be in there... If you start with 30 - filter out the worst 5 (and even if you filter away 5 average ones by mistake), you should be left with 20 better ones. Any thoughts ?