Thursday, March 20, 2014

Top 200 List - March 19th 2014

Top 200 List - March 19th 2014

I decided to update my list as I watch some March Madness.  It is never too early to start looking forward to my next tranche (May 6th, 2014) as I approach new tranche.

 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 did add this time price to book value.  The data is from FINVIZ.  I would actually prefer price to tangible book, if anyone knows where to get that (I am too lazy to calculate it) then please let me know.

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, the dividend yields should definitely be verified as they come from Yahoo Finance which is not always reliable.  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.61        1,360 25% 993973% 7.0%    10.6   USA
TTWO 2         21.79        2,436 25% 1283% 0.0%      2.7   USA
AGX 3         29.00            417 19% 1367% 2.7%      2.8   USA
GAME 4           6.59        1,768 14% 757% 0.0%    47.1   China
NTES 5         63.97        8,348 14% 499% 2.1%      2.6   China
CALL 6         23.65            439 12% 2545% 0.0%        -     Israel
QCOR 7         63.39        3,948 12% 1424% 1.7%    10.0   USA
WTW 8         20.41        1,155 13% 536% 2.6%        -     USA
PFMT 9           8.26            409 16% 278% 0.0%      6.0   USA
TNH 10      156.27        2,891 18% 230% 8.3%    12.3   USA
CSCO 11         21.63    115,223 13% 350% 3.2%      2.0   USA
USMO 12         16.85            370 16% 220% 0.0%      1.4   USA
HLF 13         52.72        5,653 14% 251% 2.3%      9.7   Cayman Islands
MYGN 14         35.97        2,763 12% 447% 0.0%      4.0   USA
USNA 15         67.14            968 14% 197% 0.0%      4.0   USA
CTCM 16           9.41        1,465 18% 131% 7.2%      2.1   Russia
EBIX 17         17.77            685 11% 865% 0.4%      1.7   USA
RGR 18         62.98        1,270 14% 151% 3.6%      6.8   USA
CYOU 19         28.87        1,530 26% 117% 0.0%      0.8   China
APOL 20         32.75        3,732 18% 119% 0.0%      3.1   USA
GME 21         37.61        4,442 15% 133% 3.0%      2.1   USA
IQNT 22         14.00            455 14% 147% 10.7%      3.9   USA
AVG 23         20.86        1,129 10% 776% 0.0%    45.4   Netherlands
NUS 24         72.22        4,469 13% 140% 1.6%      5.3   USA
AAPL 25      531.40    479,032 11% 318% 0.0%      3.7   USA
ESI 26         29.73            696 26% 100% 0.0%      3.4   USA
RPXC 27         15.99            868 10% 1376% 0.0%      2.0   USA
UIS 28         31.22        1,602 14% 119% 0.0%        -     USA
BKE 29         45.84        2,202 13% 123% 0.0%      5.9   USA
DLX 30         53.65        2,736 10% 331% 1.9%      5.0   USA
MSFT 31         39.27    329,672 10% 248% 2.6%      3.9   USA
NSR 32         34.75        2,223 11% 168% 0.0%      3.7   USA
LO 33         51.44      18,888 10% 651% 4.3%        -     USA
BAH 34         21.80        3,245 11% 194% 11.2%    11.2   USA
STRA 35         46.40            490 17% 93% 0.0%    12.7   USA
COH 36         50.23      14,141 11% 143% 2.7%      5.8   USA
BWC 37         33.52        3,741 16% 92% 1.1%      3.6   USA
BCOR 38         19.84            825 9% 467% 0.0%      1.7   USA
PRIS 39           2.22            561 11% 129% 0.0%      0.3   Spain
KRFT 40         55.77      33,462 12% 119% 3.7%      6.5   USA
GA 41         11.56        2,870 9% 390% 5.6%      5.1   China
MO 42         36.02      71,752 9% 399% 5.1%    17.7   USA
RAI 43         53.22      28,829 9% 295% 4.8%      5.8   USA
SWHC 44         13.88            791 18% 82% 0.0%      5.6   USA
DNB 45      101.53        3,899 9% 1233% 1.7%        -     USA
LQDT 46         26.53            866 9% 604% 0.0%      2.6   USA
CA 47         32.39      14,508 9% 472% 3.1%      2.5   USA
CNVR 48         24.54        1,676 10% 187% 0.0%      3.3   USA
CHE 49         88.18        1,578 10% 176% 0.9%      3.4   USA
SAIC 50         36.51        1,752 12% 84% 1.5%      5.4   USA
XLS 51         19.93        3,884 14% 77% 1.5%      2.3   USA
ORCL 52         38.55    176,366 9% 481% 0.9%      4.0   USA
EGL 53         44.65            796 12% 86% 0.0%      1.8   USA
NDZ 54         10.27            637 15% 75% 0.0%      1.4   Canada
SUSP 55         32.96            724 15% 74% 0.0%      9.4   USA
NOC 56      122.88      27,673 10% 111% 2.0%      2.6   USA
REGI 57         11.98            437 47% 66% 0.0%      0.7   USA
DHX 58           7.24            391 9% 243% 0.0%      2.3   USA
CRUS 59         19.77        1,292 17% 68% 0.0%      2.0   USA
SNDK 60         78.79      18,343 9% 134% 0.9%      2.5   USA
APEI 61         34.88            621 12% 74% 0.0%      3.1   USA
HPQ 62         31.62      61,185 12% 74% 1.9%      2.1   USA
DGX 63         55.15        8,052 10% 103% 2.2%      2.0   USA
RTN 64         99.39      31,765 9% 153% 1.6%      2.9   USA
GD 65      108.02      38,304 10% 98% 2.1%      2.6   USA
ATVI 66         21.10      15,973 8% 994% 0.9%      2.4   USA
ETM 67         10.59            406 10% 95% 0.0%      1.4   USA
PBI 68         25.46        5,186 9% 147% 2.9%    27.4   USA
MANT 69         29.83        1,108 14% 66% 2.8%      0.9   USA
SYMC 70         20.58      14,447 9% 127% 2.9%      2.5   USA
CPLA 71         62.49            793 9% 150% 0.6%      4.3   USA
WSTC 72         24.04        2,046 10% 103% 3.8%        -     USA
PM 73         79.66    127,297 9% 147% 0.0%        -     USA
BPI 74         14.62            776 11% 73% 0.0%      2.2   USA
BR 75         37.70        4,679 9% 208% 2.2%      5.2   USA
EXPR 76         15.91        1,346 17% 57% 0.0%      2.8   USA
K 77         61.73      22,470 11% 77% 2.9%      6.3   USA
PRSC 78         27.85            393 9% 120% 0.0%      2.8   USA
MED 79         28.87            393 10% 83% 0.0%      3.7   USA
VGR 80         20.70        2,109 8% 255% 7.2%        -     USA
STRZA 81         32.22        3,752 9% 118% 0.0%    39.1   USA
SHOO 82         36.28        2,401 9% 102% 3.7%      3.4   USA
CF 83      254.66      14,541 15% 55% 1.1%      2.9   USA
GPS 84         41.61      18,891 11% 65% 0.0%      6.2   USA
FLR 85         75.39      12,394 10% 89% 0.9%      3.3   USA
NCI 86         18.41            932 10% 83% 0.0%      1.5   USA
GDOT 87         20.37            779 10% 87% 0.0%      1.9   USA
BRLI 88         27.25            759 9% 107% 0.0%      2.7   USA
LXK 89         43.90        2,796 16% 53% 2.7%      2.0   USA
PBH 90         28.72        1,506 8% 261% 0.0%      2.8   USA
IGT 91         15.14        3,865 10% 72% 0.0%      3.5   USA
FRAN 92         20.21            889 9% 92% 0.0%    11.8   USA
TARO 93      121.32        5,423 9% 128% 0.0%      5.0   Israel
VIAB 94         87.85      39,884 8% 220% 0.0%      8.2   USA
HRS 95         74.06        7,947 10% 74% 2.2%      4.6   USA
CRWN 96           3.80        1,367 9% 119% 0.0%      3.4   USA
FCN 97         32.38        1,267 11% 64% 0.0%      1.2   USA
SCSS 98         17.08            945 10% 70% 0.0%      4.1   USA
BBBY 99         68.31      14,503 12% 55% 0.0%      3.5   USA
MDP 100         45.45        2,073 9% 113% 3.6%      2.3   USA
TZOO 101         22.92            345 8% 294% 0.0%    11.0   USA
LH 102         98.25        8,675 9% 89% 0.0%      3.5   USA
NSP 103         29.11            723 10% 69% 2.3%      2.9   USA
STX 104         51.67      17,878 10% 71% 3.1%      7.0   Ireland
ITRN 105         24.47            513 9% 93% 2.0%      5.6   Israel
TWX 106         67.08      62,002 9% 103% 1.8%      2.0   USA
CATO 107         30.37            873 14% 48% 1.5%      2.3   USA
OUTR 108         66.56        1,837 12% 54% 0.0%      3.5   USA
FL 109         46.32        6,874 11% 57% 1.7%      2.8   USA
OMC 110         71.73      18,693 8% 237% 2.2%      5.3   USA
SYNT 111         92.05        3,861 8% 144% 0.0%      6.1   USA
LNN 112         80.08        1,037 12% 53% 0.8%      2.7   USA
DPS 113         52.77      10,633 9% 93% 2.9%      4.6   USA
TDC 114         46.09        7,577 8% 197% 0.0%      4.0   USA
WDC 115         85.87      20,866 11% 57% 0.0%      2.4   USA
SYNA 116         61.02        2,200 8% 116% 2.4%      3.4   USA
SGU 117           5.64            324 16% 44% 5.8%      1.2   USA
WINA 118         77.95            413 7% 293% 6.7%    10.5   USA
CODI 119         17.79            859 11% 51% 8.1%      1.7   USA
JCOM 120         49.09        2,277 7% 522% 0.0%      3.4   USA
IILG 121         26.23        1,524 7% 224% 1.7%      4.4   USA
SAP 122         77.32      92,475 7% 280% 1.4%      4.5   Germany
TRW 123         81.45        9,912 12% 47% #VALUE!      2.2   USA
BRCD 124         10.04        4,554 9% 80% 0.0%      1.9   USA
PRGS 125         22.55        1,187 8% 138% 0.0%      2.3   USA
CO 126           4.22            308 19% 42% 0.0%      1.4   Hong Kong
PETM 127         66.66        6,865 10% 58% 1.1%      5.8   USA
CSGS 128         27.72            938 9% 78% 2.2%      2.4   USA
DOX 129         46.15        7,469 8% 122% 1.1%      2.2   Channel Islands
OSK 130         57.21        4,962 10% 56% 0.0%      2.4   USA
TUP 131         81.84        4,215 8% 88% 3.1%    16.5   USA
MD 132         62.92        6,360 7% 371% 0.0%      2.7   USA
LMT 133      160.90      52,502 8% 97% 0.0%    10.7   USA
VMI 134      147.10        3,958 12% 43% 0.8%      2.6   USA
PIR 135         19.45        2,037 11% 49% 1.1%      4.1   USA
KFY 136         29.48        1,450 8% 154% 0.0%      2.0   USA
MSI 137         65.70      17,161 8% 91% 1.8%      4.6   USA
EXLS 138         30.09        1,017 8% 117% 0.0%      2.7   USA
MDT 139         59.85      60,449 8% 78% 1.8%      3.1   USA
BTI 140      107.98    101,501 8% 121% 4.3%      9.2   United Kingdom
IBM 141      184.71    199,487 9% 76% 2.0%      8.8   USA
ROST 142         72.66      15,490 9% 69% 1.0%      8.0   USA
ACN 143         83.79      58,483 7% 491% 2.1%    10.8   Ireland
CHRW 144         50.96        7,702 8% 88% 2.7%      8.2   USA
MHFI 145         78.83      21,915 7% 617% 1.4%    16.0   USA
NCR 146         35.55        6,072 9% 60% 0.0%      3.3   USA
LEA 147         82.99        6,880 12% 44% 0.9%      2.2   USA
WHR 148      146.35      11,693 11% 47% 1.7%      2.3   USA
CACI 149         77.49        1,960 9% 73% 0.0%      1.4   USA
ERIC 150         13.03      42,491 10% 54% 3.4%      2.0   Sweden
LLY 151         59.05      63,714 9% 69% 3.3%      3.6   USA
GNC 152         44.50        4,249 9% 67% 1.4%      5.0   USA
JOY 153         55.15        5,662 13% 42% 1.2%      2.1   USA
HSNI 154         60.75        3,285 8% 73% 1.4%      6.2   USA
CSC 155         63.22        9,443 11% 45% 1.0%      2.5   USA
FF 156         21.00            911 10% 47% 3.4%      2.8   USA
MAN 157         77.50        6,262 10% 50% 1.2%      2.1   USA
TJX 158         60.51      43,536 8% 91% 1.0%    10.3   USA
PFE 159         31.71    207,161 8% 86% 3.1%      2.9   USA
ASR 160      113.17        3,395 7% 201% 5.8%      3.6   Mexico
MLHR 161         28.71        1,692 8% 73% 1.8%      4.9   USA
LHCG 162         22.38            386 10% 46% 0.0%      1.3   USA
MCO 163         81.68      17,888 7% 442% 1.2%    62.6   USA
RIOM 164           1.93            343 27% 35% 0.0%      1.5   Canada
CBD 165         41.48        6,835 18% 36% 1.3%      3.0   Brazil
DOV 166         81.91      14,110 9% 62% 1.6%      2.6   USA
NCMI 167         14.83            877 7% 238% 9.0%        -     USA
MBT 168         16.78      16,688 14% 37% 5.7%      4.7   Russia
IPG 169         17.11        7,446 7% 118% 0.0%      3.5   USA
GSK 170         54.71    133,520 8% 81% 4.5%    11.3   United Kingdom
MAT 171         38.20      13,112 9% 60% 3.8%      4.0   USA
EMR 172         63.87      45,226 8% 68% 2.6%      4.2   USA
KLAC 173         68.60      11,539 8% 77% 0.0%      3.2   USA
HON 174         92.89      74,033 8% 76% 1.8%      4.2   USA
IGTE 175         32.02        1,937 8% 66% #VALUE!    27.4   USA
DTV 176         76.17      40,218 9% 57% 0.0%        -     USA
IPAR 177         35.26        1,087 9% 61% 2.8%      2.5   USA
AVP 178         14.71        6,378 10% 46% 1.6%      5.8   USA
ABBV 179         53.10      85,385 7% 166% 3.1%    18.8   USA
SAFM 180         77.24        1,732 15% 35% 0.9%      2.5   USA
GEOS 181         72.36            941 12% 38% 0.0%      3.0   USA
SEM 182         11.76        1,612 10% 47% 3.3%      2.0   USA
SWK 183         79.54      12,663 8% 62% 2.5%      1.8   USA
PPC 184         19.38        5,028 12% 37% 0.0%      3.4   USA
SPLS 185         11.40        7,435 15% 35% 4.2%      1.2   USA
EMC 186         27.84      58,854 7% 120% 0.0%      2.5   USA
PLT 187         45.43        1,964 9% 55% 0.9%      2.8   USA
MCRS 188         53.40        4,100 7% 407% 0.0%      3.5   USA
CVRR 189         23.50        3,469 16% 33% 0.0%      2.1   USA
KLIC 190         12.40            941 15% 34% 0.0%      1.3   USA
AGCO 191         52.53        5,237 17% 33% 0.8%      1.3   USA
ENR 192         95.38        6,018 10% 43% 2.0%      2.4   USA
EXPD 193         38.80        7,974 8% 64% 1.5%      3.8   USA
ZUMZ 194         25.47            768 11% 39% 0.0% #N/A   USA
QCOM 195         76.81    132,258 7% 302% 3.3%      3.5   USA
FICO 196         54.54        1,954 7% 216% 0.2%      3.5   USA
DLTR 197         53.66      11,231 8% 61% 0.0%    12.1   USA
ACM 198         32.29        3,151 9% 45% 0.0%      1.5   USA
XIN 199           4.92            362 202% 31% 4.1%      0.4   China
NOK 200           7.54      27,992 7% 221% 0.0%      3.1   Finland


The price to book (in my opinion) is interesting.  Note that some pretty highly rated stocks such as UIS and WTW actually have a "-", meaning they have a book value below 0.  I do not know about other people here, but I have trouble owning a company with a negative book value.  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 #75 (BR) is the highest, and a "50" would be perfect.

Ticker Mkt Cap Date My Ranking Price EY ROIC
ATVI 14,806.04 19-Mar 66         21.10 8% 994%
MO 71,805.12 19-Mar 42         36.02 9% 399%
APOL 3,706.28 19-Mar 20         32.75 18% 119%
AAPL 474,121.40 19-Mar 25      531.40 11% 318%
AGX 411.43 19-Mar 3         29.00 19% 1367%
BWC 3,689.63 19-Mar 37         33.52 16% 92%
BCOR 826.09 19-Mar 38         19.84 9% 467%
BAH 3,167.16 19-Mar 34         21.80 11% 194%
BR 4,428.28 19-Mar 75         37.70 9% 208%
BKE 2,217.17 19-Mar 29         45.84 13% 123%
CA 14,247.95 19-Mar 47         32.39 9% 472%
CHE 1,549.06 19-Mar 49         88.18 10% 176%
CRUS 1,214.34 19-Mar 59         19.77 17% 68%
CSCO 112,281.30 19-Mar 11         21.63 13% 350%
COH 13,946.99 19-Mar 36         50.23 11% 143%
CTSH 15,025.43 19-Mar #N/A #N/A #N/A #N/A
DLX 2,662.19 19-Mar 30         53.65 10% 331%
DHX 393.36 19-Mar 58           7.24 9% 243%
DNB 3,848.80 19-Mar 45      101.53 9% 1233%
EBIX 670.79 19-Mar 17         17.77 11% 865%
EGL 770.37 19-Mar 53         44.65 12% 86%
XLS 3,795.58 19-Mar 51         19.93 14% 77%
GME 4,370.28 19-Mar 21         37.61 15% 133%
HLF 5,329.99 19-Mar 13         52.72 14% 251%
IQNT 451.01 19-Mar 22         14.00 14% 147%
ESI 705.77 19-Mar 26         29.73 26% 100%
KRFT 33,285.93 19-Mar 40         55.77 12% 119%
LQDT 854.27 19-Mar 46         26.53 9% 604%
LO 18,775.60 19-Mar 33         51.44 10% 651%
MSFT 325,941.00 19-Mar 31         39.27 10% 248%
MYGN 2,992.42 19-Mar 14         35.97 12% 447%
NSR 2,240.78 19-Mar 32         34.75 11% 168%
NDZ 635.71 19-Mar 54         10.27 15% 75%
NOC 26,738.56 19-Mar 56      122.88 10% 111%
NUS 4,224.87 19-Mar 24         72.22 13% 140%
PDLI 1,460.77 19-Mar 1           8.61 25% 993973%
PFMT 398.85 19-Mar 9           8.26 16% 278%
QCOR 3,812.08 19-Mar 7         63.39 12% 1424%
RTN 31,307.85 19-Mar 64         99.39 9% 153%
RAI 28,635.18 19-Mar 43         53.22 9% 295%
RPXC 873.55 19-Mar 27         15.99 10% 1376%
SNDK 17,747.61 19-Mar 60         78.79 9% 134%
SAIC 1,788.99 19-Mar 50         36.51 12% 84%
SWHC 762.28 19-Mar 44         13.88 18% 82%
STRA 500.98 19-Mar 35         46.40 17% 93%
RGR 1,218.47 19-Mar 18         62.98 14% 151%
TTWO 2,211.66 19-Mar 2         21.79 25% 1283%
UIS 1,379.58 19-Mar 28         31.22 14% 119%
USNA 930.56 19-Mar 15         67.14 14% 197%
WTW 1,146.58 19-Mar 8         20.41 13% 536%

2 comments:

Alex Garcia said...

Hey MG,
First of all,
thanks for making this list available to us. I really appreciate it and use it all the time.

P/Tangible Book can be found on Gurufocus website.Simply enter a ticker and it will take you to the "Summary" page. Look under "Valuation and return" and you shall see it along with earnings yield. It's the only place I found it

Again, thanks!!

Marsh_Gerda said...

Alex - thanks for the kind words and the heads up. The GuruFocus screen looks much more complete than fin biz. I will look to incorporate on my next data pull.