Saturday, April 26, 2014

April 25th 2014 Top 200 List

Top 200 List

As I mentioned last month, I am going to try and start creating a top 200 list when I do a monthly tracking portfolio so I can keep them in sync and pull data from the detailed listing.  I am also 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 - we can see how they look..  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           8.39        1,326 25% 993973% 7.2%        -     USA
TTWO 2         20.36        2,276 28% 1283% 0.0%      3.1   USA
AGX 3         27.17            396 23% 1468% 0.0%      2.9   USA
CALL 4         18.37            332 15% 2432% 0.0%        -     Israel
LQDT 5         17.16            560 15% 604% 0.0%      6.0   USA
GAME 6           6.62        1,778 14% 868% 0.0%        -     China
KING 7         18.52        5,833 13% 2109% #N/A #N/A   Ireland
WTW 8         20.51        1,161 13% 536% 2.6%        -     USA
TNH 9      148.81        2,753 19% 230% 8.6%      8.9   USA
PFMT 10           8.55            424 15% 278% 0.0%        -     USA
USMO 11         16.89            371 16% 220% 3.0%      3.3   USA
AVG 12         18.50        1,001 12% 779% 0.0%        -     Netherlands
SPRT 13           2.42            132 19% 184% 0.0%      1.7   USA
NTES 14         71.12        9,281 12% 499% 2.0%        -     China
HLF 15         57.83        6,201 13% 251% 2.1%    43.2   Cayman Islands
CSCO 16         23.00    122,521 12% 350% 3.0%      4.2   USA
CTCM 17           8.60        1,339 20% 131% 7.6%      3.5   Russia
RGR 18         61.48        1,240 15% 151% 3.7%      6.6   USA
MYGN 19         38.82        2,982 11% 447% 0.0%      4.7   USA
USNA 20         78.88        1,138 12% 205% 0.0%      5.5   USA
CYOU 21         26.65        1,413 29% 117% 0.0%      2.2   China
APOL 22         27.84        3,156 19% 119% 0.0%      4.1   USA
EBIX 23         16.11            621 11% 758% 0.5%        -     USA
IQNT 24         13.33            433 14% 140% 2.0%      3.7   USA
NSR 25         27.58        1,731 13% 142% 0.0%        -     USA
UIS 26         25.03        1,160 20% 105% 0.0%        -     USA
ESI 27         27.06            634 28% 100% 0.0%      3.2   USA
DLX 28         52.59        2,666 11% 345% 1.9%        -     USA
BKE 29         45.02        2,162 13% 123% 1.9%      6.0   USA
BCOR 30         18.52            770 10% 467% 0.0%        -     USA
AAPL 31      571.94    503,037 10% 333% 2.1%      4.1   USA
GME 32         39.37        4,602 13% 118% 2.9%      7.1   USA
PETS 33         12.90            259 13% 115% 5.1%      3.8   USA
STRA 34         43.08            455 18% 93% 1.9%    14.5   USA
CA 35         29.95      13,418 10% 472% 3.3%        -     USA
RCII 36         28.32        1,502 10% 394% 3.1%        -     USA
BWC 37         33.82        3,774 15% 92% 1.1%      4.7   USA
COH 38         49.82      14,026 11% 143% 2.7%      6.8   USA
BAH 39         22.82        3,396 10% 194% 1.8%        -     USA
QCOR 40         81.50        5,076 9% 1424% 1.4%    31.1   USA
PRIS 41           2.23            563 11% 129% 0.0%        -     Spain
KRFT 42         56.66      33,996 11% 119% 3.7%        -     USA
SWHC 43         14.03            800 18% 82% 0.0%      5.7   USA
RPXC 44         16.62            902 9% 1376% 0.0%      4.7   USA
TZOO 45         17.55            263 10% 226% 0.0%      8.7   USA
MSFT 46         39.91    333,927 10% 232% 2.6%      4.8   USA
NEWT 47           2.71            103 11% 130% 0.0%      1.6   USA
NUS 48         87.74        5,429 11% 140% 1.4%      7.9   USA
GA 49         11.74        2,914 9% 390% 5.5%      5.4   China
NOC 50      118.99      26,344 11% 115% 2.1%        -     USA
GDOT 51         17.35            664 12% 90% 0.0%      1.7   USA
XLS 52         18.48        3,602 15% 77% 2.2%        -     USA
NATR 53         13.62            225 18% 74% 2.9%      2.1   USA
CPLA 54         55.72            707 10% 150% 1.3%      4.3   USA
RTN 55         94.90      29,969 10% 160% 2.4%        -     USA
STV 56           2.90            172 25% 71% 0.0%      1.8   China
CRUS 57         21.63        1,396 14% 77% 0.0%      2.3   USA
CNVR 58         24.47        1,671 10% 187% 0.0%    24.2   USA
DNB 59      103.99        3,993 9% 1233% 1.6%        -     USA
CHE 60         85.97        1,539 10% 176% 0.9%        -     USA
LO 61         54.12      19,630 9% 633% 4.2%        -     USA
EGL 62         43.46            775 12% 85% 0.0%        -     USA
ATVI 63         19.46      14,731 9% 994% 1.0%        -     USA
SYNT 64         78.72        3,304 10% 123% 0.1%      4.6   USA
DHX 65           6.96            376 9% 243% 0.0%        -     USA
SAIC 66         39.42        1,959 11% 97% #N/A #N/A   USA
APEI 67         33.86            603 12% 74% 0.0%      3.6   USA
NDZ 68         11.48            712 12% 75% 1.0%      1.5   Canada
LIWA 69           4.76            143 68% 58% 0.0%      0.4   China
HPQ 70         31.58      61,107 12% 74% 1.8%        -     USA
SNDK 71         84.35      19,815 9% 140% 0.8%      3.0   USA
ORCL 72         39.45    180,484 9% 481% 1.2%    20.0   USA
TARO 73      110.25        4,929 10% 128% 0.0%      5.2   Israel
FRAN 74         16.04            685 11% 83% 0.0%      9.1   USA
MANT 75         29.27        1,088 14% 66% 2.9%      4.8   USA
ETM 76         10.53            404 10% 95% 0.0%        -     USA
EXPR 77         14.28        1,208 19% 57% 0.0%      4.4   USA
SYMC 78         20.28      14,237 9% 127% 3.0%        -     USA
PBI 79         24.83        5,057 9% 147% 3.0%        -     USA
EGY 80           8.76            499 20% 56% 0.0%      2.0   USA
MO 81         39.11      77,672 8% 383% 4.8%        -     USA
GD 82      109.01      37,854 10% 92% 2.1%    29.4   USA
GPS 83         38.78      17,606 12% 65% 2.0%      6.6   USA
BR 84         37.17        4,613 9% 208% 2.2%        -     USA
SHOO 85         34.97        2,314 10% 102% 0.0%      5.2   USA
BBBY 86         62.48      13,002 13% 58% 0.0%      3.7   USA
CF 87      240.69      13,743 15% 55% 1.2%      4.7   USA
GSOL 88           8.11            294 13% 58% 0.0%      1.7   Bermuda
LXK 89         41.61        2,638 17% 53% 2.9%      4.0   USA
RAI 90         55.10      29,692 8% 253% 4.7%        -     USA
VIAB 91         83.44      37,882 8% 220% 1.4%        -     USA
EXLS 92         27.39            926 9% 120% 0.0%      3.9   USA
NCI 93         17.85            903 10% 83% 0.0%        -     USA
STRZA 94         31.66        3,687 9% 118% 0.0%        -     USA
BPI 95         15.28            811 11% 73% 0.0%      2.6   USA
TOPS 96           6.99              17 50% 48% #N/A #N/A   Greece
REGI 97         11.74            428 60% 48% 0.0%      0.9   USA
BBGI 98           7.97            182 10% 85% 1.1%        -     USA
HRS 99         71.62        7,685 10% 74% 2.3%        -     USA
CRWN 100           3.64        1,309 9% 119% 0.0%    15.2   USA
K 101         66.71      24,282 10% 77% 2.7%        -     USA
VGR 102         20.74        2,114 8% 255% 7.6%        -     USA
FLR 103         75.73      12,450 9% 89% 0.9%      3.4   USA
CHKE 104         13.70            115 8% 215% 2.6%        -     USA
KLAC 105         62.91      10,568 10% 82% 2.8%      3.3   USA
OMC 106         67.91      17,752 8% 241% 2.4%        -     USA
ONE 107           5.83            282 10% 75% 0.0%        -     USA
FCN 108         33.46        1,309 11% 64% 0.0%        -     USA
FF 109         20.30            881 13% 51% 2.2%      2.7   USA
ERIC 110         12.04      39,299 11% 60% 3.8%      2.8   Sweden
SLI 111         27.00            112 17% 46% 0.0%      2.9   USA
BRCD 112           9.25        4,195 9% 80% 0.0%      6.2   USA
CODI 113         18.18            878 12% 53% 7.9%        -     USA
TWX 114         65.20      60,264 9% 103% 1.8%        -     USA
LMT 115      161.09      52,370 9% 106% 3.1%        -     USA
ITRN 116         24.14            506 9% 93% 3.0%      6.7   Israel
LEE 117           4.01            214 10% 62% 0.0%        -     USA
DGX 118         55.88        8,103 9% 88% 2.2%        -     USA
OUTR 119         67.29        1,857 11% 54% 0.0%        -     USA
MED 120         31.69            432 9% 83% 0.0%      4.2   USA
DPS 121         53.58      10,689 9% 90% 2.9%        -     USA
IGT 122         12.46        3,098 10% 61% 3.3%        -     USA
CSGS 123         26.06            882 9% 78% 2.3%    26.1   USA
ACN 124         78.43      54,368 8% 494% 2.4%    17.6   Ireland
LH 125         99.49        8,785 9% 89% 0.0%        -     USA
JCOM 126         47.05        2,182 8% 522% 2.1%    85.6   USA
TDC 127         44.84        7,372 8% 197% 0.0%    12.9   USA
CATO 128         28.19            811 14% 45% 1.6%      2.1   USA
MD 129         58.93        5,957 8% 371% 0.0%        -     USA
STX 130         52.72      18,241 9% 71% 3.1%    10.3   Ireland
PERI 131         10.30            129 7% 732% 0.0%        -     Israel
ROST 132         67.77      14,447 9% 70% 1.1%      7.3   USA
TRW 133         82.32      10,018 12% 47% 0.0%      4.4   USA
WDC 134         87.77      21,328 10% 57% 1.3%      3.8   USA
SGU 135           6.49            373 14% 44% 5.1%        -     USA
PRGS 136         21.91        1,143 8% 127% 0.0%      3.9   USA
CACI 137         69.18        1,750 9% 73% 0.0%        -     USA
MSI 138         62.50      16,325 9% 91% 1.9%      7.5   USA
CXDC 139           7.29            349 50% 40% 0.0%      0.9   China
OSK 140         56.07        4,863 10% 56% 0.5%    16.4   USA
CTG 141         16.21            269 10% 57% 1.3%      3.9   USA
LB 142         53.84      15,991 9% 76% 2.3%        -     USA
TUP 143         84.61        4,324 8% 140% 3.0%        -     USA
HSNI 144         56.89        3,076 9% 73% 1.5%    11.8   USA
HHS 145           8.12            510 9% 69% 4.2%        -     USA
CSC 146         58.25        8,700 12% 45% 1.4%      9.1   USA
LFVN 147           1.41            158 8% 201% 0.0%        -     USA
NCR 148         33.75        5,765 10% 60% 0.0%        -     USA
WINA 149         75.47            401 7% 315% 0.3%    24.0   USA
MHFI 150         75.05      20,864 7% 617% 1.5%        -     USA
BBY 151         24.38        8,596 15% 41% 2.8%      2.5   USA
DOX 152         45.42        7,351 8% 122% 1.2%      5.3   Channel Islands
KFY 153         28.74        1,413 8% 154% 0.0%      3.4   USA
MDT 154         58.21      58,792 9% 78% 1.9%      9.1   USA
PBH 155         32.26        1,692 7% 261% 1.0%        -     USA
NSP 156         31.51            783 9% 69% 2.2%      3.4   USA
MDP 157         44.53        2,021 8% 103% 3.7%        -     USA
LHCG 158         21.12            364 11% 47% 0.0%    10.1   USA
IILG 159         26.09        1,516 8% 224% 1.7%        -     USA
GTIV 160           7.89            277 8% 108% 0.0%        -     USA
FL 161         45.84        6,803 11% 46% 1.8%      3.0   USA
LECO 162         64.87        5,294 8% 89% 1.3%      4.4   USA
DFZ 163         18.34            212 11% 49% 2.0%      3.5   USA
SAP 164         77.88      93,144 7% 278% 1.0% #####   Germany
DSW 165         33.41        3,080 10% 53% 1.7%      3.2   USA
MAN 166         79.89        6,487 10% 52% 1.2%      4.2   USA
PETM 167         67.54        6,956 10% 55% 1.1%      6.7   USA
PLT 168         42.29        1,828 10% 55% 1.0%      2.7   USA
TJX 169         58.14      41,831 8% 89% 1.0%    10.8   USA
CO 170           4.25            310 20% 36% 0.0%      1.5   Hong Kong
WHR 171      155.42      12,340 10% 47% 1.6%      8.0   USA
AMSWA 172           9.38            264 7% 383% 2.1%      4.0   USA
IPG 173         17.20        7,272 8% 125% 1.9%        -     USA
GEOS 174         61.40            798 14% 38% #N/A #N/A   USA
XOXO 175         10.50            259 8% 90% 0.0%      2.5   USA
PFE 176         30.75    200,890 8% 86% 3.2%        -     USA
JOY 177         60.39        6,200 12% 42% 1.2%      6.6   USA
IPCM 178         41.66            732 8% 103% 0.0%        -     USA
GNC 179         44.41        4,240 9% 67% 1.4%        -     USA
MBT 180         16.17      16,081 14% 37% 1.7%      9.8   Russia
PME 181           3.24            256 13% 39% #N/A #N/A   China
RLGT 182           3.03            110 8% 116% 0.0%        -     USA
PIR 183         17.68        1,821 10% 46% 1.2%      3.7   USA
OCIP 184         21.70        1,747 10% 52% #N/A #N/A   USA
WSTC 185         24.64        2,100 10% 53% #N/A #N/A   USA
CBD 186         46.81        7,713 16% 36% 0.9%      6.6   Brazil
FENG 187           9.94            771 8% 117% 0.0%      3.2   China
MCRS 188         50.78        3,899 7% 407% 0.0%      6.2   USA
LNN 189         89.41        1,157 10% 52% 0.7%      3.6   USA
CLCT 190         22.87            188 7% 473% 5.7%    12.4   USA
HPY 191         38.39        1,458 8% 86% 0.8%    72.4   USA
ALDW 192         17.98        1,124 12% 38% 13.2%      7.7   USA
USPH 193         31.02            376 8% 106% 1.4%        -     USA
CPSI 194         60.18            672 8% 103% 3.5%      9.7   USA
CBS 195         58.05      35,701 8% 92% 0.8%        -     USA
INFY 196         52.50      29,999 8% 82% #N/A #N/A   India
QSII 197         14.58            877 8% 99% 4.8%      5.8   USA
CRT 198         31.50            189 7% 130% 8.2%    16.0   USA
HCKT 199           5.98            191 8% 76% 1.7%    10.9   USA
DOV 200         84.90      14,604 8% 73% 1.7%        -     USA

The price to tangible book (in my opinion) is interesting.  Note that some pretty highly rated stocks such as PDLI and CALL actually have a "-", meaning they have a book value below 0.    Always double check these figures before you make decisions.

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!  In my view, CTSH should not be on the list. their stock recently split and I believe the official list cut their market cap in half (whoops - though people can double check, I see two sources at 15b and two at 30b).I think #72 (ATVI) is the highest, and a "50" would be perfect.  KING is a weird one.  PTIE for some reason has a zero in denominator, I will look into that.

Ticker Mkt Cap Date My Ranking Price EY ROIC
ATVI 13,771.58 24-Apr 63         19.46 9% 994%
APOL 3,116.18 24-Apr 22         27.84 19% 119%
AAPL 489,273.00 24-Apr 31      571.94 10% 333%
AGX 388.44 24-Apr 3         27.17 23% 1468%
BWC 3,763.65 24-Apr 37         33.82 15% 92%
BCOR 802.94 24-Apr 30         18.52 10% 467%
BAH 3,258.18 24-Apr 39         22.82 10% 194%
BKE 2,168.84 24-Apr 29         45.02 13% 123%
CA 13,547.74 24-Apr 35         29.95 10% 472%
CPLA 709.77 24-Apr 54         55.72 10% 150%
CHE 1,541.50 24-Apr 60         85.97 10% 176%
CRUS 1,283.50 24-Apr 57         21.63 14% 77%
CSCO 121,106.00 24-Apr 16         23.00 12% 350%
COH 13,877.60 24-Apr 38         49.82 11% 143%
CTSH 14,931.54 24-Apr #N/A #N/A #N/A #N/A
DLX 2,649.61 24-Apr 28         52.59 11% 345%
DHX 388.45 24-Apr 65           6.96 9% 243%
DNB 3,991.30 24-Apr 59      103.99 9% 1233%
EBIX 634.64 24-Apr 23         16.11 11% 758%
EGL 752.09 24-Apr 62         43.46 12% 85%
XLS 3,558.83 24-Apr 52         18.48 15% 77%
GME 4,636.21 24-Apr 32         39.37 13% 118%
HLF 5,822.35 24-Apr 15         57.83 13% 251%
IQNT 455.52 24-Apr 24         13.33 14% 140%
ESI 644.78 24-Apr 27         27.06 28% 100%
KING 5,860.58 24-Apr 7         18.52 13% 2109%
KRFT 33,918.59 24-Apr 42         56.66 11% 119%
LQDT 559.96 24-Apr 5         17.16 15% 604%
MSFT 329,243.60 24-Apr 46         39.91 10% 232%
MYGN 3,334.34 24-Apr 19         38.82 11% 447%
NATR 225.70 24-Apr 53         13.62 18% 74%
NSR 1,708.60 24-Apr 25         27.58 13% 142%
NOC 25,624.54 24-Apr 50      118.99 11% 115%
NUS 5,222.68 24-Apr 48         87.74 11% 140%
PTIE 262.14 24-Apr #N/A #N/A #N/A #N/A
PDLI 1,428.54 24-Apr 1           8.39 25% 993973%
PFMT 417.45 24-Apr 10           8.55 15% 278%
PETS 264.49 24-Apr 33         12.90 13% 115%
QCOR 4,949.28 24-Apr 40         81.50 9% 1424%
RTN 29,965.41 24-Apr 55         94.90 10% 160%
RPXC 931.46 24-Apr 44         16.62 9% 1376%
SWHC 783.69 24-Apr 43         14.03 18% 82%
STRA 471.40 24-Apr 34         43.08 18% 93%
RGR 1,198.55 24-Apr 18         61.48 15% 151%
SPRT 142.99 24-Apr 13           2.42 19% 184%
TTWO 2,119.30 24-Apr 2         20.36 28% 1283%
TZOO 263.82 24-Apr 45         17.55 10% 226%
USMO 375.01 24-Apr 11         16.89 16% 220%
USNA 1,103.52 24-Apr 20         78.88 12% 205%
WTW 1,186.64 24-Apr 8         20.51 13% 536%

Finally, a couple of comments about the newest tracking portfolio.  Even with all the stock market vol of late, there has been little change on the MFI lists.  TZOO is the only "new" name in my tracking portfolio.  Here are the dividend stocks:

Stock  Initial Price   52 week low   Mkt Cap  Yield
USMO              16.89                12.58           375 3.0%
RGR              61.48                44.76         1,199 3.7%
PETS              12.90                12.13           264 5.1%
PDLI                8.39                 7.38         1,429 7.2%
NATR              13.62                12.91           226 14.7%
MSFT              39.91                30.84     329,244 2.8%
KRFT              56.66                50.04       33,919 3.7%
IQNT              13.33                 2.88           456 11.4%
GME              39.37                30.94         4,636 2.9%
COH              49.82                44.31       13,878 2.7%
CSCO              23.00                20.22     121,106 3.0%
CA              29.95                25.77       13,548 3.3%
BKE              45.02                41.45         2,169 4.5%
BAH              22.82                14.57         3,258 10.5%
AGX              27.17                14.94           388 2.8%


5 comments:

Unknown said...

Marsh,

?'s concerning your dividend stocks,

NATR has a yield of 14.7%? Where do you pull your data? I don't see that on Fidelity, Yahoo! Finance etc.

It looks like the data for the MSFT yield is an "annualized most recent data dividend" but all the other stocks appear to be "1-Year Holding Period (TTM, including all Non-Regular Payments) at least on the Fidelity site.

On Fidelity, AGX doesn't have a yield. Where did you get a yield of 2.8%?

Thanks for helping with all my questions and for posting such good content!

-Brian Block

Marsh_Gerda said...

Brian, I am now using gurufocus for dividend yields and Price to TBV. As always, people should double check my automated approach.

Unknown said...

Thanks for the new Dividend stocks. They appear to not change a lot each month. Looking back to February there are a few new names. So your data base with a count of 672 making over 24% must include a lot of the same stocks each month.

I am just guessing but if you only buy the new dividend stocks each month you might end the year fully invested and have less than 50 stocks.

Does this sound about right?

Marsh_Gerda said...

John - you are right, the turnover in dividend stocks is maybe two or three per month. So if you only wanted to buy a single name once per year, your portfolio might have 40 to 50 positions b

Unknown said...

Marsh,

Wow! Thanks for the fast reply. You must work 18 hours a day. I am still somewhat afraid of the magic caps below 960M.

If you have a little slack time I would appreciate you looking at the >2.6% dividends under 960M to see if there is any advantage to include them. I know your data base is small but four years is more than I have.

Appreciate the MFI diary and your reboot.

I believe in MFI but after five years I could not make it work.