Sunday, June 22, 2014

Top 200 List - June 20th, 2014

Top 200 List - June 20th, 2014

It has been 3 weeks since I last created a top 200 list. As I mentioned last month, 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 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 P/B Country
PDLI 1           9.82        1,616 24% 1274340% 6.15%      3.0   USA
TTWO 2         21.45        1,652 36% 986% 0.00%      3.0   USA
KING 3         17.16        5,404 17% 4351% 0.00% #N/A   Ireland
CALL 4         15.07            269 16% 1224% 0.00%    20.0   Israel
AGX 5         34.33            504 16% 1405% 2.23%    20.0   USA
GAME 6           6.71        1,818 15% 1050% 0.00%        -     China
PTIE 7           5.63            254 14% 37295% 0.00%    12.0   USA
LQDT 8         15.06            487 15% 437% 0.00%      2.0   USA
SPRT 9           2.36            126 17% 254% 0.00%      2.0   USA
PFMT 10           9.93            493 15% 296% 0.00%        -     USA
USMO 11         14.73            325 18% 202% 3.41%      3.0   USA
EBIX 12         14.28            551 12% 595% 1.03%    20.0   USA
TNH 13      141.01        2,609 18% 188% 7.88%      1.0   USA
WTW 14         21.49        1,214 12% 496% 1.59%      1.0   USA
CTCM 15         10.65        1,659 16% 175% 6.27%      1.0   Russia
BCOR 16         18.49            823 11% 492% 0.00%        -     USA
MYGN 17         37.28        2,847 11% 346% 0.00%      1.0   USA
USNA 18         77.50        1,116 12% 204% 0.00%      8.0   USA
AVG 19         19.75        1,050 10% 726% 0.00%        -     Netherlands
NSR 20         24.82        1,558 14% 142% 0.00%    10.0   USA
APOL 21         29.39        3,332 18% 119% 0.00%      3.0   USA
HLF 22         64.90        6,541 11% 238% 1.37%      4.0   Cayman Islands
RGR 23         60.31        1,200 15% 125% 3.69%      3.0   USA
CSCO 24         24.83    128,619 11% 333% 2.83%        -     USA
NTES 25         77.19      10,088 10% 524% 2.27%        -     China
GA 26         11.78        2,934 10% 412% 1.95%        -     China
COH 27         34.73        9,681 15% 118% 3.79%      1.0   USA
ESI 28         16.97            397 47% 100% 0.00%      3.0   USA
TEX 29         40.19        4,714 38% 101% 0.38%      5.0   USA
UIS 30         25.07        1,162 20% 105% 0.00%      4.0   USA
PRIS 31           1.90            481 12% 139% 0.00%        -     Spain
CA 32         28.73      12,756 10% 441% 3.46%      1.0   USA
DLX 33         57.94        2,937 10% 345% 1.84%      2.0   USA
QCOR 34         93.18        5,761 9% 1624% 1.24%      4.0   USA
BKE 35         45.73        2,197 13% 110% 4.40%    36.0   USA
NUS 36         76.72        4,697 12% 108% 1.68%      4.0   USA
STRA 37         52.88            560 15% 92% 0.00%      6.0   USA
NDZ 38         12.72            794 15% 90% 0.00%        -     Canada
GME 39         40.11        4,649 13% 102% 3.03%      6.0   USA
ATAI 40           4.60            104 16% 86% 0.00%        -     China
BAH 41         21.70        3,236 10% 163% 11.35%      2.0   USA
IQNT 42         14.98            489 12% 100% 1.83%        -     USA
CNVR 43         24.73        1,700 10% 158% 0.00%      6.0   USA
AAPL 44         90.91    559,705 9% 333% 1.93%      1.0   USA
SWHC 45         15.52            877 17% 76% 0.00%      9.0   USA
KRFT 46         60.50      36,361 11% 115% 3.46%        -     USA
NOC 47      123.45      27,332 11% 115% 2.07%      1.0   USA
RTN 48         96.77      30,560 10% 160% 2.35%      1.0   USA
NEWT 49           2.70            104 11% 110% 0.00%    30.0   USA
CPLA 50         55.53            700 10% 152% 1.91%      6.0   USA
MSFT 51         41.68    348,737 9% 232% 2.58%      8.0   USA
DNB 52      107.57        4,055 9% 1213% 1.58%      2.0   USA
TARO 53      113.88        4,878 10% 131% 0.00%        -     Israel
TDC 54         43.57        7,010 9% 362% 0.00%      1.0   USA
DEPO 55         13.25            794 9% 636% 0.00%      4.0   USA
PETS 56         13.25            266 12% 84% 5.09%    12.0   USA
PENN 57         11.95            957 20% 69% 0.00%      2.0   USA
TZOO 58         18.99            284 9% 226% 0.00%      1.0   USA
ETM 59         10.45            402 10% 112% 0.00%    11.0   USA
CRUS 60         23.13        1,493 13% 77% 0.00%      1.0   USA
BRCD 61           9.21        4,017 11% 90% 0.38%        -     USA
STV 62           4.40            266 13% 75% 11.01%        -     China
ONE 63           3.78            183 13% 75% 0.00%      6.0   USA
CYOU 64         25.31        1,338 18% 68% 0.00%        -     China
BBGI 65           5.42            124 12% 80% 1.58%      3.0   USA
LFVN 66           1.35            144 9% 193% 0.00%    16.0   USA
BWC 67         32.32        3,584 15% 69% 1.17%      1.0   USA
VGR 68         21.32        2,019 9% 247% 7.40%      4.0   USA
STRZA 69         29.50        3,393 10% 119% 0.00%        -     USA
MGIC 70           7.37            294 9% 138% 2.85%        -     Israel
AMWD 71         31.47            498 9% 234% 0.00%    23.0   USA
SYNT 72         83.56        3,507 10% 123% 0.00%    35.0   USA
APEI 73         34.07            607 12% 72% 0.00%      3.0   USA
SHOO 74         32.77        2,135 10% 95% 0.00%    13.0   USA
NTP 75           7.50            340 49% 58% 4.37%        -     China
SFUN 76           9.01        4,172 9% 166% 2.13%        -     China
WINA 77         66.21            351 8% 315% 7.92%    73.0   USA
IILG 78         21.88        1,271 9% 222% 2.01%      3.0   USA
SYMC 79         22.23      15,561 9% 133% 2.71%      1.0   USA
MANT 80         29.32        1,092 12% 69% 2.82%        -     USA
CHE 81         91.36        1,672 9% 154% 0.88%      3.0   USA
HPQ 82         34.22      65,566 11% 74% 1.73%        -     USA
VIAB 83         85.76      38,129 8% 236% 1.41%        -     USA
FRAN 84         14.85            629 11% 70% 0.00%      2.0   USA
XLS 85         17.06        3,325 14% 58% 2.42%        -     USA
BBBY 86         60.07      12,501 14% 58% 0.00%      1.0   USA
K 87         67.24      24,341 10% 76% 2.75%        -     USA
MED 88         31.58            418 10% 86% 0.00%    13.0   USA
ITRN 89         24.68            517 9% 108% 4.28%        -     Israel
KFY 90         28.66        1,417 8% 158% 0.00%      2.0   USA
TWX 91         68.30      62,194 9% 117% 1.67%      2.0   USA
SLI 92         30.20            126 17% 53% 0.00%      4.0   USA
PME 93           2.61            206 22% 52% 0.00% #N/A   China
SAIC 94         43.73        2,160 10% 87% 1.98% #N/A   USA
CLCT 95         20.02            166 8% 448% 6.38%    30.0   USA
WSTC 96         27.19        2,317 9% 100% 3.33% #N/A   USA
BOLT 97         16.82            146 13% 56% 5.05%      5.0   USA
DHX 98           7.14            395 8% 232% 0.00%      4.0   USA
NATR 99         16.27            270 13% 57% 12.55%      1.0   USA
PBI 100         27.58        5,623 8% 150% 2.71%      1.0   USA
ACAT 101         38.90            509 14% 55% 1.11%      3.0   USA
LEE 102           4.30            231 11% 68% 0.00%    11.0   USA
LXK 103         45.70        2,897 16% 53% 2.78%      2.0   USA
GNC 104         35.38        3,315 10% 70% 1.72%      1.0   USA
HRS 105         75.78        8,139 10% 74% 2.23%      1.0   USA
CHKE 106         15.20            128 8% 139% 1.66%    10.0   USA
GD 107      119.55      41,513 9% 92% 1.92%      1.0   USA
CRWN 108           3.52        1,266 9% 104% 0.00%        -     USA
BR 109         40.86        5,099 8% 224% 2.06%      1.0   USA
FF 110         16.84            731 15% 50% 4.27%    10.0   USA
GPS 111         41.68      18,798 11% 61% 1.85%      9.0   USA
PETM 112         56.96        5,687 12% 57% 1.29%      1.0   USA
CXDC 113           8.54            412 49% 46% 0.00%      3.0   China
MO 114         43.12      85,636 8% 383% 4.46%        -     USA
RPXC 115         17.29            941 7% 1262% 0.00%      8.0   USA
EGL 116         39.37            704 10% 69% 0.00%        -     USA
EXLS 117         29.35            981 9% 85% 0.00%      5.0   USA
CF 118      245.99      13,505 15% 49% 1.38%        -     USA
LO 119         65.18      23,641 8% 633% 3.63%      1.0   USA
ERIC 120         12.31      40,180 11% 60% 3.74%        -     Sweden
OUTR 121         61.73        1,529 11% 56% 0.00%      2.0   USA
ROST 122         67.94      14,370 10% 71% 1.09%      2.0   USA
UTHR 123         87.46        4,955 9% 87% 0.00%        -     USA
OMC 124         71.60      18,716 8% 241% 2.39%      1.0   USA
LMT 125      165.40      53,772 8% 106% 3.13%        -     USA
ATVI 126         22.01      15,847 7% 797% 0.91%      1.0   USA
DGX 127         59.08        8,567 9% 88% 2.10%      1.0   USA
IBM 128      181.55    189,139 9% 87% 2.16%        -     USA
FLR 129         78.52      12,749 9% 85% 0.96%      1.0   USA
TEO 130         22.01        4,266 16% 45% 7.62%        -     Argentina
TJX 131         54.95      39,174 9% 82% 1.11%      1.0   USA
JCOM 132         50.08        2,342 7% 441% 2.07%      6.0   USA
MONT 133         20.74            605 7% 332% 0.00% #N/A   China
HHS 134           7.06            445 9% 66% 4.90%    14.0   USA
YONG 135           7.08            359 72% 41% 0.00%      2.0   China
CACI 136         70.62        1,834 9% 78% 0.00%      1.0   USA
CTG 137         15.62            259 11% 54% 1.45%      8.0   USA
QLGC 138           9.99            869 11% 53% 0.00%      1.0   USA
RAI 139         62.55      33,707 7% 253% 4.18%        -     USA
PRGS 140         22.48        1,173 8% 127% 0.00%      4.0   USA
MDP 141         44.80        2,033 8% 103% 3.82%      2.0   USA
SBH 142         24.26        4,031 9% 69% 0.00%      1.0   USA
IPCM 143         40.22            707 8% 103% 0.00%      2.0   USA
NTAP 144         35.79      12,040 9% 74% 1.66%        -     USA
SNDK 145      101.98      23,957 8% 139% 0.88%        -     USA
CSGS 146         25.51            868 9% 65% 2.99%      5.0   USA
WDC 147         91.46      22,133 10% 58% 1.21%      1.0   USA
MD 148         58.71        5,912 8% 186% 0.00%      2.0   USA
CODI 149         17.28            835 12% 48% 8.13%      2.0   USA
FL 150         49.63        7,325 11% 51% 1.65%      1.0   USA
STX 151         56.27      19,019 9% 67% 2.19%      1.0   Ireland
CATO 152         30.27            858 13% 44% 2.29%      8.0   USA
SAP 153         77.72      92,953 7% 278% 1.76%        -     Germany
ACN 154         83.13      57,627 7% 494% 2.24%      1.0   Ireland
BBY 155         28.31        9,920 13% 43% 2.35%      1.0   USA
WHR 156      138.87      11,026 12% 47% 1.88%      1.0   USA
DSW 157         27.64        2,546 12% 46% 2.25%      1.0   USA
DPS 158         60.03      11,976 8% 90% 2.63%        -     USA
KLAC 159         70.00      11,759 8% 82% 2.61%      1.0   USA
PM 160         91.14    144,275 8% 134% 4.02%        -     USA
CPSI 161         61.99            692 8% 106% 3.42%    11.0   USA
ANIK 162         46.40            719 8% 91% 0.00%      3.0   USA
PLOW 163         17.62            390 9% 59% 4.93%      3.0   USA
LH 164      102.22        8,852 8% 82% 0.00%      1.0   USA
MDT 165         63.86      64,639 8% 90% 1.73%      1.0   USA
TRW 166         87.32      10,461 11% 45% 0.00%      1.0   USA
PIR 167         15.18        1,456 12% 44% 1.39%      5.0   USA
MMS 168         42.70        2,959 8% 98% 0.43%    10.0   USA
MBT 169         19.43      19,323 13% 41% 0.00%        -     Russia
TUP 170         83.42        4,263 8% 77% 3.12%      2.0   USA
KLIC 171         14.23        1,096 12% 42% 0.00%      5.0   USA
LNN 172         87.66        1,134 10% 52% 0.89%      5.0   USA
SAFM 173         96.66        2,169 14% 39% 0.81%      8.0   USA
PLUS 174         58.29            461 14% 40% 0.00%      9.0   USA
UTMD 175         51.57            195 8% 94% 1.92%      3.0   USA
OFLX 176         20.29            205 8% 86% 2.14%    29.0   USA
PFE 177         29.78    192,855 8% 75% 3.38%        -     USA
CO 178           5.00            365 17% 37% 0.00%      1.0   Hong Kong
CSC 179         64.02        9,555 11% 44% 1.30%      1.0   USA
UEPS 180         11.07            501 14% 39% 0.00%      2.0   South Africa
LULU 181         40.23        5,868 8% 100% 0.00%        -     Canada
SGA 182         38.59            222 11% 42% 4.63%      3.0   USA
HSNI 183         57.10        3,093 9% 65% 1.63%      1.0   USA
MAN 184         84.54        6,865 10% 52% 1.14%      1.0   USA
PPC 185         25.94        6,730 11% 43% 0.00%      2.0   USA
RLGT 186           3.04            107 8% 84% 0.00%    36.0   USA
IGT 187         16.01        3,980 9% 61% 1.99%      2.0   USA
LB 188         57.70      17,154 8% 70% 3.95%      1.0   USA
XUE 189           4.40            301 9% 55% 3.57%        -     China
PBH 190         34.64        1,819 7% 251% 0.00%      5.0   USA
FOSL 191      105.60        5,739 9% 52% 0.00%    17.0   USA
EXPR 192         16.54        1,396 13% 39% 0.00%      4.0   USA
MHFI 193         82.71      22,927 7% 645% 1.40%      1.0   USA
OSK 194         54.81        4,687 10% 46% 0.83%      2.0   USA
RIOM 195           2.30            409 24% 34% 0.00%        -     Canada
CAH 196         69.13      23,988 8% 82% 1.76%      1.0   USA
RECN 197         12.59            493 9% 54% 2.24%      2.0   USA
HON 198         94.82      75,515 8% 75% 1.86%        -     USA
NVDA 199         18.93      10,798 8% 99% 1.72%        -     USA
DOX 200         47.58        7,720 7% 113% 1.14%        -     Channel Islands

Readers will recall that last month 3 IPOs (LMNS, MBUU and KING) made this list. MBUU has completely disappeared, I think I was correct about minority income being misstated. LMNS is just off the top 200, like #230. KING is still very high.  If they can create new games that make money and create a bit of a franchise, they could be very cheap.

Here is the Cross Reference List.  After a couple of runs where I had a few mis-matches, this one looks actually better than the official list! I think #77 (WINA) is the highest, and a "50" would be perfect. TIME is the one strange one.  I know they just started trading.  I have not dug in really deeply yet, but I would advise caution on whether they actually belong on the official list.  I will let you know if I can confirm they are ok.  I find it interesting that AGX is still #5 overall and it has been a two-bagger for me.

Ticker Mkt Cap Date My Ranking Price EY ROIC
APOL 3,295.59 20-Jun 21         29.39 18% 119%
AAPL 548,388.70 20-Jun 44         90.91 9% 333%
AGX 493.29 20-Jun 5         34.33 16% 1405%
BCOR 780.33 20-Jun 16         18.49 11% 492%
BAH 3,318.84 20-Jun 41         21.70 10% 163%
BRCD 4,010.51 20-Jun 61           9.21 11% 90%
BKE 2,212.19 20-Jun 35         45.73 13% 110%
CA 12,605.00 20-Jun 32         28.73 10% 441%
CPLA 683.85 20-Jun 50         55.53 10% 152%
CRUS 1,433.04 20-Jun 60         23.13 13% 77%
CSCO 127,030.30 20-Jun 24         24.83 11% 333%
COH 9,639.38 20-Jun 27         34.73 15% 118%
CNVR 1,655.87 20-Jun 43         24.73 10% 158%
DLX 2,899.49 20-Jun 33         57.94 10% 345%
DEPO 765.78 20-Jun 55         13.25 9% 636%
DNB 3,980.09 20-Jun 52      107.57 9% 1213%
EBIX 548.12 20-Jun 12         14.28 12% 595%
ETM 408.41 20-Jun 59         10.45 10% 112%
GME 4,592.60 20-Jun 39         40.11 13% 102%
HLF 6,574.37 20-Jun 22         64.90 11% 238%
ONE 178.45 20-Jun 63           3.78 13% 75%
IQNT 485.10 20-Jun 42         14.98 12% 100%
ESI 396.59 20-Jun 28         16.97 47% 100%
KING 5,452.14 20-Jun 3         17.16 17% 4351%
LFVN 140.43 20-Jun 66           1.35 9% 193%
LQDT 486.05 20-Jun 8         15.06 15% 437%
MSFT 344,276.80 20-Jun 51         41.68 9% 232%
MYGN 3,121.49 20-Jun 17         37.28 11% 346%
NSR 1,524.05 20-Jun 20         24.82 14% 142%
NDZ 793.58 20-Jun 38         12.72 15% 90%
NOC 26,542.61 20-Jun 47      123.45 11% 115%
NUS 4,526.48 20-Jun 36         76.72 12% 108%
PTIE 256.76 20-Jun 7           5.63 14% 37295%
PDLI 1,703.85 20-Jun 1           9.82 24% ########
PFMT 481.18 20-Jun 10           9.93 15% 296%
PETS 267.52 20-Jun 56         13.25 12% 84%
QCOR 5,683.70 20-Jun 34         93.18 9% 1624%
RTN 30,230.95 20-Jun 48         96.77 10% 160%
STRZA 3,218.51 20-Jun 69         29.50 10% 119%
STRA 573.38 20-Jun 37         52.88 15% 92%
RGR 1,169.95 20-Jun 23         60.31 15% 125%
SPRT 126.16 20-Jun 9           2.36 17% 254%
TTWO 2,177.15 20-Jun 2         21.45 36% 986%
TIME 2,553.90 20-Jun #N/A #N/A #N/A #N/A
TZOO 280.05 20-Jun 58         18.99 9% 226%
UIS 1,281.30 20-Jun 30         25.07 20% 105%
USMO 319.11 20-Jun 11         14.73 18% 202%
USNA 1,083.53 20-Jun 18         77.50 12% 204%
WTW 1,213.22 20-Jun 14         21.49 12% 496%
WINA 340.58 20-Jun 77         66.21 8% 315%

Late addendum. TIME was not showing up for me as it was not in the FINWIZ data I use. I forced it in and it scored very well (see below). That being said, I know I read that they were going public with $1.5b in debt and that does not appear to be showing up on balance sheet yet. So everyone needs to be aware that stuff is not always 100% accurate.

Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield P/B Country
PDLI 1           9.82        1,616 24% 1274340% 6.15%      3.0   USA
TTWO 2         21.45        1,652 36% 986% 0.00%      3.0   USA
KING 3         17.16        5,404 17% 4351% 0.00% #N/A   Ireland
CALL 4         15.07            269 16% 1224% 0.00%    20.0   Israel
AGX 5         34.33            504 16% 1405% 2.23%    20.0   USA
GAME 6           6.71        1,818 15% 1050% 0.00%        -     China
PTIE 7           5.63            254 14% 37295% 0.00%    12.0   USA
LQDT 8         15.06            487 15% 437% 0.00%      2.0   USA
SPRT 9           2.36            126 17% 254% 0.00%      2.0   USA
PFMT 10           9.93            493 15% 296% 0.00%        -     USA
USMO 11         14.73            325 18% 202% 3.41%      3.0   USA
EBIX 12         14.28            551 12% 595% 1.03%    20.0   USA
TNH 13      141.01        2,609 18% 188% 7.88%      1.0   USA
WTW 14         21.49        1,214 12% 496% 1.59%      1.0   USA
CTCM 15         10.65        1,659 16% 175% 6.27%      1.0   Russia
BCOR 16         18.49            823 11% 492% 0.00%        -     USA
MYGN 17         37.28        2,847 11% 346% 0.00%      1.0   USA
USNA 18         77.50        1,116 12% 204% 0.00%      8.0   USA
AVG 19         19.75        1,050 10% 726% 0.00%        -     Netherlands
NSR 20         24.82        1,558 14% 142% 0.00%    10.0   USA
APOL 21         29.39        3,332 18% 119% 0.00%      3.0   USA
HLF 22         64.90        6,541 11% 238% 1.37%      4.0   Cayman Islands
RGR 23         60.31        1,200 15% 125% 3.69%      3.0   USA
CSCO 24         24.83    128,619 11% 333% 2.83%        -     USA
NTES 25         77.19      10,088 10% 524% 2.27%        -     China
GA 26         11.78        2,934 10% 412% 1.95%        -     China
COH 27         34.73        9,681 15% 118% 3.79%      1.0   USA
ESI 28         16.97            397 47% 100% 0.00%      3.0   USA
TEX 29         40.19        4,714 38% 101% 0.38%      5.0   USA
UIS 30         25.07        1,162 20% 105% 0.00%      4.0   USA
PRIS 31           1.90            481 12% 139% 0.00%        -     Spain
CA 32         28.73      12,756 10% 441% 3.46%      1.0   USA
DLX 33         57.94        2,937 10% 345% 1.84%      2.0   USA
QCOR 34         93.18        5,761 9% 1624% 1.24%      4.0   USA
BKE 35         45.73        2,197 13% 110% 4.40%    36.0   USA
TIME 36         23.06        2,544 17% 88% 0.00% #N/A USA









2 comments:

John Carney said...

I wonder if "return on assets average for 5 years" would help the top 200 list?

If it comes in the teens or greater it would show how consisstent the earnings had been. Also would eliminate some strange one time events.

I spent some time looking at the completed gray tranches and the open ones and am amazed you have been able to avoid a big stinker or two. If one of the tranches has a COH and loses 30% it really can hurt overall results and makes it hard to beat IWV.

Do you have a screen or check list that keeps you out of the value traps and falling knives?

Looking back on the charts it look safe to buy stocks that are trending up or have formed a base for 3 months or so.

Any help or insight would be appreciated.

Marsh_Gerda said...

John - not sure if an ROA would help. I am now capturing a 10 year median ROA with every month of data. But I have only be doing that for 3 months or so ==> it will take a while.

I'd suggest I have just been lucky so far to avoid a real stinker. COH and LQDT have certainly been on my idea lists. I think in MFI, you will certainly get those from time to time.