Saturday, March 29, 2014

Top 200 List - March 28th 2014 > 100m Market Cap

Top 200 List

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           7.99        1,262 26% 993973% 7.5%        -     USA
TTWO 2         21.48        2,402 26% 1283% 0.0%      3.2   USA
AGX 3         29.22            420 19% 1367% 0.0%      3.3   USA
CALL 4         20.29            367 14% 2432% 0.0%        -     Israel
GAME 5           6.50        1,745 15% 868% 0.0%        -     China
QCOR 6         62.12        3,869 12% 1424% 1.8%    27.5   USA
TNH 7      153.00        2,831 18% 230% 8.4%      9.2   USA
WTW 8         20.65        1,169 13% 536% 2.5%        -     USA
MYGN 9         32.87        2,525 13% 447% 0.0%      4.0   USA
NTES 10         68.13        8,891 12% 499% 2.1%        -     China
PFMT 11           9.21            457 14% 278% 0.0%        -     USA
SPRT 12           2.49            136 18% 184% 0.0%      1.7   USA
USMO 13         17.80            391 15% 220% 2.8%      3.7   USA
HLF 14         55.65        5,968 13% 251% 2.2%    41.5   Cayman Islands
CSCO 15         22.33    118,952 12% 350% 3.1%      4.1   USA
EBIX 16         16.67            642 11% 865% 0.9%        -     USA
USNA 17         74.02        1,067 13% 205% 0.0%      5.1   USA
CTCM 18           8.87        1,381 20% 131% 7.4%      3.6   Russia
RGR 19         59.89        1,208 15% 151% 3.8%      6.5   USA
CYOU 20         28.98        1,536 26% 117% 0.0%        -     China
APOL 21         32.85        3,744 18% 119% 0.0%      3.8   USA
IQNT 22         13.96            454 14% 147% 1.9%      3.9   USA
AVG 23         20.79        1,125 10% 776% 0.0%        -     Netherlands
DLX 24         50.81        2,591 11% 331% 2.0%        -     USA
UIS 25         28.73        1,474 15% 119% 0.0%        -     USA
ESI 26         27.36            641 28% 100% 0.0%      3.2   USA
NSR 27         33.23        2,126 12% 168% 0.0%        -     USA
AAPL 28      536.86    483,954 10% 318% 2.3%      3.9   USA
GME 29         40.62        4,748 13% 123% 2.8%      7.5   USA
BKE 30         45.60        2,190 13% 123% 1.8%      5.9   USA
RPXC 31         16.16            877 10% 1376% 0.0%      4.5   USA
BAH 32         21.77        3,240 11% 194% 1.8%        -     USA
BCOR 33         19.11            794 10% 467% 0.0%        -     USA
PETS 34         13.10            263 13% 115% 5.0%      3.9   USA
STRA 35         45.83            484 17% 93% 1.8%    15.4   USA
BWC 36         32.53        3,630 16% 92% 1.1%      4.5   USA
NUS 37         83.06        5,140 11% 140% 1.5%      7.5   USA
COH 38         49.67      13,984 11% 143% 2.7%      6.8   USA
MSFT 39         40.30    338,319 10% 248% 2.5%      5.0   USA
CA 40         30.84      13,816 10% 472% 3.2%        -     USA
PRIS 41           2.28            576 11% 129% 0.0%        -     Spain
KRFT 42         55.70      33,420 12% 119% 3.7%        -     USA
SWHC 43         14.33            817 18% 82% 0.0%      5.8   USA
PENN 44         11.95            931 22% 79% 0.0%        -     USA
LO 45         53.35      19,590 9% 651% 4.3%        -     USA
DNB 46         99.37        3,816 9% 1233% 1.7%        -     USA
LQDT 47         26.09            852 9% 604% 0.0%      9.2   USA
GA 48         11.58        2,875 9% 390% 5.5%      5.4   China
RAI 49         53.02      28,721 10% 295% 4.8%        -     USA
NATR 50         13.92            230 17% 74% 2.9%      2.2   USA
XLS 51         18.32        3,571 15% 77% 2.3%        -     USA
STV 52           2.91            173 25% 71% 0.0%      1.8   China
MO 53         37.12      73,943 9% 399% 5.1%        -     USA
SAIC 54         36.58        1,756 12% 84% #N/A #N/A   USA
EGL 55         44.39            792 12% 86% 0.0%        -     USA
NDZ 56         10.41            646 14% 75% 1.1%      1.4   Canada
SUSP 57         35.08            770 15% 74% 5.3%    22.6   USA
NOC 58      121.81      27,432 11% 111% 2.0%        -     USA
CHE 59         88.81        1,590 9% 176% 0.9%        -     USA
CRUS 60         19.52        1,276 17% 68% 0.0%      2.1   USA
NTE 61           5.88            267 491% 60% 5.8%      0.8   China
DHX 62           7.18            387 9% 243% 0.0%        -     USA
LIWA 63           5.00            150 552% 58% 0.0%      0.4   China
APEI 64         34.92            622 12% 74% 0.0%      3.7   USA
ETM 65           9.74            373 10% 95% 0.0%        -     USA
TARO 66      109.86        4,911 10% 128% 0.0%      5.2   Israel
CHKE 67         13.65            115 9% 216% 2.9%        -     USA
SYMC 68         19.79      13,893 9% 127% 3.0%        -     USA
CLCT 69         18.94            156 9% 473% 6.9%    10.3   USA
ORCL 70         39.57    181,033 9% 481% 0.9%    20.1   USA
HPQ 71         32.04      61,997 12% 74% 1.8%        -     USA
ATVI 72         20.45      15,481 8% 994% 1.0%        -     USA
MANT 73         29.09        1,081 14% 66% 2.9%      4.7   USA
GDOT 74         19.46            745 11% 90% 0.0%      2.0   USA
RTN 75         98.65      31,529 9% 153% 2.2%        -     USA
CPLA 76         60.42            767 9% 150% 1.2%      4.6   USA
GD 77      107.70      38,190 10% 98% 2.1%    29.0   USA
CTG 78         16.51            276 11% 82% 1.3%      4.0   USA
SNDK 79         80.61      18,767 9% 134% 0.8%      2.8   USA
BR 80         36.32        4,507 9% 208% 2.2%        -     USA
BPI 81         14.50            770 11% 73% 0.0%      2.5   USA
EXPR 82         15.99        1,353 17% 57% 0.0%      6.0   USA
DGX 83         57.80        8,439 10% 103% 2.1%        -     USA
MED 84         28.26            385 10% 83% 0.0%      3.8   USA
WSTC 85         23.62        2,010 10% 103% #N/A #N/A   USA
IGT 86         13.72        3,503 11% 72% 3.0%        -     USA
K 87         62.13      22,615 11% 77% 2.9%        -     USA
PBI 88         25.47        5,188 9% 147% 2.9%        -     USA
GPS 89         40.17      18,237 12% 65% 1.7%      7.0   USA
CNVR 90         27.61        1,885 9% 187% 0.0%    27.3   USA
PRSC 91         27.88            394 9% 120% 0.0%        -     USA
SHOO 92         35.37        2,340 9% 102% 0.0%      5.3   USA
PBH 93         26.55        1,392 8% 261% 1.2%        -     USA
CF 94      257.79      14,720 14% 55% 1.1%      5.0   USA
PM 95         81.02    129,470 9% 147% 4.5%        -     USA
NCI 96         18.26            924 10% 83% 0.0%        -     USA
GSOL 97           8.42            305 12% 58% 0.0%      1.7   Bermuda
LXK 98         45.14        2,875 16% 53% 2.7%      4.3   USA
INTX 99           5.90            107 16% 52% 13.6%      2.1   USA
CRWN 100           3.62        1,302 9% 119% 0.0%    15.1   USA
STRZA 101         32.07        3,735 9% 118% 0.0%        -     USA
FRAN 102         18.23            778 10% 83% 0.0%    10.8   USA
REGI 103         11.52            420 61% 48% 0.0%      0.8   USA
HRS 104         71.88        7,713 10% 74% 2.3%        -     USA
VIAB 105         84.69      38,449 8% 220% 1.4%        -     USA
FCN 106         32.76        1,281 11% 64% 0.0%        -     USA
BBBY 107         68.43      14,529 12% 55% 0.0%      4.0   USA
FLR 108         76.41      12,562 9% 89% 0.9%      3.4   USA
NEWT 109           2.83            108 10% 74% 0.0%      1.7   USA
VGR 110         21.10        2,150 8% 255% 7.5%        -     USA
SYNT 111         87.91        3,688 8% 144% 0.1%      5.1   USA
LFVN 112           1.32            148 8% 201% 0.0%        -     USA
SYNA 113         58.20        2,099 9% 116% 0.0%      4.0   USA
TWX 114         64.65      59,756 9% 103% 1.8%        -     USA
PRGS 115         21.09        1,100 8% 127% 0.0%      3.9   USA
LH 116         98.04        8,657 9% 89% 0.0%        -     USA
SCSS 117         17.77            983 10% 70% 0.0%      4.7   USA
FL 118         46.13        6,846 11% 57% 1.7%      3.1   USA
MDP 119         45.52        2,077 9% 113% 3.6%        -     USA
CSGS 120         25.69            869 9% 78% 2.3%    25.7   USA
BBGI 121           8.95            205 9% 85% 1.0%        -     USA
LEE 122           4.47            238 10% 62% 0.0%        -     USA
NSP 123         29.83            741 10% 69% 2.3%      3.3   USA
ACN 124         78.81      54,632 8% 494% 2.2%    17.4   Ireland
WINA 125         74.63            395 8% 293% 0.3%    10.1   USA
TZOO 126         22.85            344 8% 294% 0.0%    11.4   USA
OUTR 127         71.82        1,982 11% 54% 0.0%        -     USA
SGU 128           5.89            339 15% 44% 5.6%    49.1   USA
TRW 129         79.71        9,701 12% 47% 0.0%      4.3   USA
BOLT 130         19.75            171 10% 57% 1.7%      3.7   USA
XOXO 131         10.04            248 9% 90% 0.0%      2.4   USA
ONE 132           6.55            317 9% 75% 0.0%        -     USA
WDC 133         89.41      21,727 10% 57% 1.2%      3.9   USA
CODI 134         18.76            906 11% 51% 7.7%        -     USA
OMC 135         72.31      18,844 8% 237% 2.2%        -     USA
PIR 136         18.86        1,975 11% 49% 1.1%      3.9   USA
ITRN 137         25.11            527 9% 93% 2.9%      7.2   Israel
STX 138         54.92      19,002 9% 71% 3.0%    10.7   Ireland
FF 139         19.75            857 11% 47% 2.3%      2.6   USA
EXLS 140         30.08        1,016 8% 120% 0.0%      4.3   USA
VMI 141      146.25        3,935 13% 43% 0.7%      3.9   USA
SLI 142         24.81            104 16% 41% 0.0%      2.6   USA
MHFI 143         75.01      20,853 7% 617% 1.5%        -     USA
IILG 144         25.97        1,509 8% 224% 1.7%        -     USA
DPS 145         53.95      10,871 8% 93% 2.9%        -     USA
OSK 146         58.07        5,036 10% 56% 0.5%    17.0   USA
KFY 147         28.68        1,411 8% 154% 0.0%      3.4   USA
MD 148         61.45        6,211 7% 371% 0.0%        -     USA
JCOM 149         49.17        2,281 7% 522% 2.0%    89.4   USA
BRCD 150         10.15        4,604 9% 80% 0.0%      6.5   USA
MSI 151         64.30      16,795 8% 91% 1.9%      7.7   USA
LEA 152         82.69        6,855 12% 44% 0.9%      3.1   USA
CACI 153         73.91        1,870 9% 73% 0.0%        -     USA
LLY 154         57.61      62,160 9% 69% 3.4%      4.8   USA
WHR 155      146.75      11,725 11% 47% 1.7%      7.5   USA
CSC 156         60.29        9,005 11% 45% 1.3%      9.4   USA
DFZ 157         18.33            212 11% 49% 2.0%      3.5   USA
LNN 158         84.41        1,092 10% 52% 0.8%      3.4   USA
DOX 159         45.78        7,409 8% 122% 1.2%      5.4   Channel Islands
LB 160         56.55      16,796 9% 76% 2.2%        -     USA
ROST 161         72.10      15,370 9% 69% 1.0%      8.1   USA
HSNI 162         59.03        3,192 9% 73% 1.5%    12.2   USA
LMT 163      160.54      52,384 8% 97% 3.1%        -     USA
ERIC 164         13.09      42,686 10% 54% 2.3%      3.0   Sweden
HHS 165           8.46            531 9% 69% 4.0%        -     USA
PETM 166         68.49        7,054 10% 55% 1.1%      6.1   USA
TUP 167         82.25        4,236 8% 88% 3.1%        -     USA
LHCG 168         21.94            378 11% 47% 0.0%    10.5   USA
CO 169           3.99            291 22% 36% 0.0%      1.4   Hong Kong
MCO 170         77.57      16,988 7% 442% #N/A #N/A   USA
NCR 171         35.70        6,098 9% 60% 0.0%        -     USA
JOY 172         57.96        5,951 12% 42% 1.2%      6.4   USA
GNC 173         44.13        4,213 9% 67% 1.4%        -     USA
MAN 174         76.82        6,207 10% 50% 1.2%      4.0   USA
PERI 175         10.91            136 7% 732% 0.0%        -     Israel
CHRW 176         50.89        7,691 8% 88% 2.8%        -     USA
RIOM 177           2.04            363 26% 35% 0.0%      1.4   Canada
MDT 178         60.41      61,014 8% 78% 1.8%      9.5   USA
TDC 179         48.10        7,908 7% 197% 0.0%    13.9   USA
CBD 180         43.74        7,207 17% 36% 1.1%      6.2   Brazil
PLT 181         43.12        1,864 9% 55% 0.9%      2.8   USA
RLGT 182           3.02            110 8% 116% 0.0%        -     USA
GTIV 183           9.05            317 8% 108% 0.0%        -     USA
DSW 184         35.44        3,267 9% 54% 1.1%      3.0   USA
GEOS 185         66.04            859 13% 38% #N/A #N/A   USA
MBT 186         17.14      17,046 14% 37% 1.6%    10.4   Russia
IGTE 187         30.35        1,836 9% 66% 0.0%        -     USA
TJX 188         60.10      43,241 8% 91% 1.0%    11.3   USA
IBM 189      190.45    205,686 8% 76% 2.0%        -     USA
DOV 190         80.99      13,952 9% 62% 1.8%        -     USA
UFPT 191         24.70            176 12% 38% 0.0%      2.2   USA
SAFM 192         76.66        1,719 15% 35% 1.0%      2.5   USA
BTI 193      110.79    104,143 8% 121% 4.3%        -     United Kingdom
SAP 194         80.45      96,218 7% 280% 1.0%        -     Germany
ZUMZ 195         24.19            729 12% 39% 0.0%      2.8   USA
SPLS 196         11.37        7,416 15% 35% 4.2%      3.0   USA
AVP 197         14.36        6,226 10% 46% 1.7%      7.9   USA
FUL 198         47.50        2,435 7% 382% 0.8%      5.3   USA
ABBV 199         50.98      81,976 7% 166% 3.1%        -     USA
HON 200         90.89      72,439 8% 76% 1.9%    37.4   USA


The price to tangiblebook (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 14,316.96 27-Mar 72         20.45 8% 994%
MO 73,699.12 27-Mar 53         37.12 9% 399%
APOL 3,690.50 27-Mar 21         32.85 18% 119%
AAPL 477,387.80 27-Mar 28      536.86 10% 318%
AGX 416.82 27-Mar 3         29.22 19% 1367%
BWC 3,584.69 27-Mar 36         32.53 16% 92%
BCOR 796.63 27-Mar 33         19.11 10% 467%
BAH 3,151.26 27-Mar 32         21.77 11% 194%
BKE 2,201.71 27-Mar 30         45.60 13% 123%
CA 13,667.39 27-Mar 40         30.84 10% 472%
CHE 1,558.03 27-Mar 59         88.81 9% 176%
CSCO 115,499.80 27-Mar 15         22.33 12% 350%
COH 13,786.01 27-Mar 38         49.67 11% 143%
CTSH 15,073.89 27-Mar #N/A #N/A #N/A #N/A
DLX 2,554.96 27-Mar 24         50.81 11% 331%
DHX 391.18 27-Mar 62           7.18 9% 243%
DNB 3,750.52 27-Mar 46         99.37 9% 1233%
EBIX 636.16 27-Mar 16         16.67 11% 865%
EGL 765.02 27-Mar 55         44.39 12% 86%
GME 4,589.57 27-Mar 29         40.62 13% 123%
HLF 5,623.18 27-Mar 14         55.65 13% 251%
IQNT 444.57 27-Mar 22         13.96 14% 147%
ESI 638.00 27-Mar 26         27.36 28% 100%
KING 5,534.64 27-Mar #N/A #N/A #N/A #N/A
KRFT 33,172.54 27-Mar 42         55.70 12% 119%
LQDT 836.88 27-Mar 47         26.09 9% 604%
LO 19,428.95 27-Mar 45         53.35 9% 651%
MSFT 333,494.00 27-Mar 39         40.30 10% 248%
MYGN 2,717.05 27-Mar 9         32.87 13% 447%
NATR 224.56 27-Mar 50         13.92 17% 74%
NSR 2,150.51 27-Mar 27         33.23 12% 168%
NDZ 644.38 27-Mar 56         10.41 14% 75%
NOC 26,507.91 27-Mar 58      121.81 11% 111%
NUS 4,829.23 27-Mar 37         83.06 11% 140%
PTIE 253.72 27-Mar #N/A #N/A #N/A #N/A
PDLI 1,353.89 27-Mar 1           7.99 26% 993973%
PENN 1,042.80 27-Mar 44         11.95 22% 79%
PFMT 439.43 27-Mar 11           9.21 14% 278%
PETS 262.47 27-Mar 34         13.10 13% 115%
QCOR 3,747.14 27-Mar 6         62.12 12% 1424%
RAI 28,479.14 27-Mar 49         53.02 10% 295%
RPXC 873.55 27-Mar 31         16.16 10% 1376%
SWHC 782.60 27-Mar 43         14.33 18% 82%
STRA 491.70 27-Mar 35         45.83 17% 93%
RGR 1,160.24 27-Mar 19         59.89 15% 151%
SPRT 142.12 27-Mar 12           2.49 18% 184%
TTWO 2,167.51 27-Mar 2         21.48 26% 1283%
UIS 1,268.67 27-Mar 25         28.73 15% 119%
USNA 1,025.34 27-Mar 17         74.02 13% 205%
WTW 1,161.81 27-Mar 8         20.65 13% 536%

No comments: