Monday, May 25, 2015

May 25th, 2015 Top 200 List

Top 200 List

I last created a top 200 list on 5/1. 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.  That being said, I struggled this pull with Gurufocus. It would only let me export data on 1000 stocks, instead of the 4,000 I need. I have sent them a note asking what is up.

As I have mentioned, I have moved to Gurufocus from Finwiz as Finwiz started charging for downloads. Gurufocus may charge as well, but I have a premium membership with 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
PDLI 1           6.66        1,135 37% 887017% 9.00%
DEPO 2         20.76        1,236 21% 2731% 0.00%
ENTA 3         40.10            773 24% 1586% 0.00%
PERI 4           3.40            254 42% 677% 0.00%
PSDV 5           4.01            118 13% 3938% 0.00%
CTCM 6           3.48            543 30% 301% 20.60%
KING 7         15.25        4,896 18% 371% 0.00%
AGX 8         35.65            529 13% 784% 0.00%
RPXC 9         16.04            885 12% 1813% 0.00%
CALL 10           8.10            145 14% 330% 0.00%
NLNK 11         42.06        1,343 12% 514% 0.00%
IDCC 12         57.26        2,137 13% 363% 1.40%
KZ 13           6.66            310 13% 320% 0.00%
GAME 14           6.92        1,878 11% 873% 0.00%
HRB 15         32.09        8,831 12% 342% 2.50%
XENE 16         12.59            171 11% 449% 0.00%
ANTM 17      164.19      46,039 12% 287% 1.60%
HLF 18         51.53        4,359 13% 196% 0.00%
CRT 19         18.10            109 14% 159% 8.60%
GSK 20         45.26    110,004 17% 138% 5.00%
SJT 21         11.02            514 10% 678% 3.00%
GME 22         40.80        4,468 14% 139% 3.60%
NATH 23         40.06            184 13% 159% 0.00%
CPLA 24         53.63            670 12% 176% 2.80%
IQNT 25         17.82            605 13% 149% 3.30%
NSR 26         27.08        1,539 15% 133% 0.00%
GILD 27      111.71    175,273 10% 487% 1.70%
CLCT 28         21.33            182 10% 665% 6.00%
TSRA 29         38.74        2,074 9% 1253% 2.10%
HNT 30         61.20        4,796 10% 444% 0.00%
VEC 31         25.71            277 11% 158% 0.00%
AET 32      114.52      40,391 9% 668% 0.90%
VIAB 33         66.80      26,887 10% 270% 2.00%
VIA 34         67.30      27,088 10% 270% 2.00%
HUM 35      179.00      27,270 11% 193% 0.70%
DLX 36         66.09        3,312 9% 413% 1.80%
STRA 37         46.54            500 17% 94% 0.00%
LQDT 38         10.52            315 12% 127% 0.00%
TNH 39      133.07        2,462 14% 105% 7.50%
CBI 40         56.31        6,152 12% 129% 0.30%
CSCO 41         29.26    150,630 9% 342% 2.90%
SPOK 42         16.79            370 10% 171% 2.90%
PPC 43         26.50        6,888 18% 78% 0.00%
BKE 44         44.07        2,124 13% 97% 2.10%
CA 45         31.33      13,754 9% 486% 3.20%
LCI 46         55.39        2,061 12% 114% 0.00%
PBI 47         22.99        4,660 10% 150% 3.30%
LBMH 48           2.76            148 10% 204% 4.60%
QCOM 49         69.51    115,873 9% 339% 2.80%
PETS 50         16.31            329 11% 126% 4.40%
UIS 51         21.00        1,046 13% 80% 0.00%
ONE 52           3.11            149 15% 71% 0.00%
APOL 53         16.46        1,780 20% 67% 0.00%
KFY 54         32.87        1,634 9% 201% 1.30%
SGU 55           8.20            470 20% 66% 5.20%
SMT 56           1.15            145 28% 62% 0.00%
MGIC 57           6.53            289 10% 119% 2.40%
ASPS 58         28.94            608 13% 74% 0.00%
FLR 59         57.97        8,691 14% 68% 1.40%
VNCE 60         17.85            682 9% 158% 0.00%
DHX 61           8.55            464 8% 296% 0.00%
KORS 62         61.63      12,674 11% 101% 0.00%
OUTR 63         78.12        1,429 12% 73% 1.60%
VA 64         28.49        1,271 12% 82% 0.00%
APEI 65         24.03            417 20% 61% 0.00%
GORO 66           3.11            168 20% 60% 3.60%
LEJU 67           8.67        1,163 8% 358% 8.30%
BRCD 68         12.54        5,433 10% 114% 1.20%
POZN 69           6.71            216 8% 407% 0.00%
GIB 70         43.33      13,992 8% 335% 0.00%
BAH 71         25.11        3,763 9% 167% 1.90%
PLOW 72         20.73            462 12% 69% 4.20%
SAIC 73         52.48        2,498 9% 154% 2.20%
FENG 74           7.36            548 11% 74% 0.00%
NVDA 75         20.86      11,452 10% 111% 1.60%
CRWN 76           4.00        1,439 10% 100% 0.00%
ORCL 77         43.93    197,421 8% 446% 1.40%
CSIQ 78         33.71        2,031 19% 56% 0.00%
AAPL 79      132.54    773,352 8% 317% 1.60%
TDC 80         39.57        5,844 8% 282% 0.00%
LOV 81           3.06              76 9% 151% 0.00%
UNH 82      119.59    115,883 8% 256% 1.30%
COH 83         37.53      10,411 10% 104% 3.50%
SLI 84         37.94            160 16% 57% 0.00%
MSFT 85         46.90    386,315 8% 195% 2.60%
UBNT 86         30.46        2,723 8% 196% 0.60%
BCOR 87         16.10            675 8% 251% 0.00%
LO 88         72.01      25,917 8% 720% 3.70%
UEPS 89         14.46            666 17% 55% 0.00%
EVOL 90           8.68            104 9% 110% 5.00%
BBY 91         34.33      12,276 14% 56% 2.50%
ANIK 92         33.62            515 11% 73% 0.00%
HGT 93           4.55            182 24% 50% 1.70%
SAFM 94         84.59        1,908 25% 49% 1.00%
BBX 95         16.21            271 24% 49% 0.00%
TIME 96         22.33        2,446 9% 99% 3.40%
RTN 97      106.70      32,928 9% 113% 2.50%
WMC 98         15.10            628 7% 625% 18.10%
TSQ 99         12.62            211 11% 68% 0.00%
STRZA 100         40.96        4,366 9% 123% 0.00%
STRZB 101         41.00        4,371 9% 123% 0.00%
BPI 102           9.11            414 16% 50% 0.00%
LYB 103      102.90      49,495 13% 55% 2.70%
LE 104         29.42            943 12% 59% 0.00%
GD 105      139.64      46,735 9% 122% 2.00%
AVP 106           7.02        3,053 14% 51% 3.40%
MAN 107         86.16        6,858 11% 64% 1.90%
OMC 108         76.97      19,042 8% 266% 2.60%
RMAX 109         33.73            415 7% 1453% 1.40%
NUS 110         52.44        3,160 12% 57% 2.80%
NSU 111           4.06            818 53% 44% 4.00%
TARO 112      139.17        5,961 9% 94% 0.00%
NTI 113         24.41        2,260 13% 53% 16.50%
DISCK 114         30.96      20,650 8% 170% 0.00%
SUPN 115         13.44            603 7% 334% 0.00%
IBM 116      172.22    170,894 9% 89% 3.00%
ITRN 117         24.39            511 9% 88% 5.50%
HSII 118         25.46            473 9% 100% 2.20%
CPHR 119         10.23            272 7% 415% 0.00%
NRCIA 120         14.56            358 8% 222% 1.70%
SNDK 121         67.08      15,029 9% 99% 1.80%
GRMN 122         45.95        8,838 9% 79% 4.10%
WINA 123         92.64            479 7% 304% 0.30%
KLIC 124         13.19        1,023 18% 44% 0.00%
KBSF 125           3.96            101 42% 42% 0.00%
BBBY 126         71.76      12,783 12% 53% 0.00%
ALDW 127         21.83        1,365 13% 48% 12.90%
WLKP 128         21.44            588 52% 41% 5.60%
TUP 129         67.28        3,384 9% 81% 4.10%
VGR 130         22.00        2,455 7% 247% 7.20%
NTCT 131         40.41        1,678 7% 456% 0.00%
LOGI 132         15.19        2,528 8% 136% 1.80%
IPG 133         20.92        8,600 8% 149% 2.30%
MIXT 134           6.91            222 9% 77% 0.00%
NOC 135      160.00      32,080 8% 102% 1.80%
CPSI 136         54.11            598 8% 112% 4.70%
FL 137         63.46        9,018 10% 59% 1.60%
ATVI 138         25.49      18,633 7% 822% 0.90%
USNA 139      128.59        1,683 8% 165% 0.00%
EMR 140         61.78      42,264 9% 73% 3.20%
CTG 141           7.70            123 20% 41% 3.10%
GCI 142         35.93        8,333 9% 67% 2.30%
WILN 143           2.01            242 7% 682% 7.80%
NTAP 144         33.14      10,383 9% 70% 1.90%
MDP 145         52.35        2,376 8% 117% 3.50%
FOSL 146         78.42        3,958 12% 48% 0.00%
HPQ 147         34.76      63,819 10% 63% 2.10%
HI 148         31.96        2,042 9% 71% 2.80%
SYNT 149         44.42        3,737 8% 100% 0.00%
DNB 150      128.97        4,695 7% 1589% 1.50%
ATAI 151           5.20            119 9% 69% 8.30%
EME 152         45.49        2,894 9% 69% 0.70%
DISCB 153         33.03      22,031 7% 170% 0.00%
GHM 154         23.02            234 11% 53% 1.40%
CR 155         62.45        3,678 10% 63% 2.20%
DISCA 156         33.15      22,111 7% 170% 0.00%
NOK 157           7.22      28,577 7% 211% 2.30%
IBA 158         54.60        2,728 20% 39% 2.10%
HRS 159         80.26        8,411 9% 69% 2.40%
WNR 160         45.82        4,384 19% 39% 3.10%
ACN 161         96.39      65,465 7% 583% 2.10%
LMT 162      192.86      61,754 8% 109% 3.20%
WLDN 163         15.11            121 8% 100% 0.00%
SYMC 164         24.87      17,231 8% 116% 2.40%
MLHR 165         27.64        1,661 10% 61% 2.00%
SFUN 166           8.03        3,610 8% 124% 5.00%
NCIT 167         11.14            152 10% 59% 0.00%
REX 168         63.27            500 23% 38% 0.00%
MED 169         32.67            398 8% 86% 0.00%
MIK 170         26.94        5,604 8% 105% 0.00%
ICON 171         26.55        1,378 7% 166% 0.00%
CO 172           6.16            450 16% 40% 0.00%
RECN 173         16.21            621 9% 61% 1.90%
PME 174           1.73            137 33% 37% 2.20%
CHE 175      123.93        2,165 8% 131% 0.70%
CI 176      135.86      35,493 10% 59% 0.00%
HIBB 177         46.33        1,161 11% 47% 0.00%
NOV 178         50.71      20,740 17% 39% 3.50%
FSS 179         15.25            971 10% 50% 1.60%
DOX 180         54.14        8,519 7% 160% 1.30%
PM 181         84.15    130,264 8% 133% 4.80%
CHKE 182         22.99            200 7% 214% 0.90%
MAG 183         37.32            137 10% 57% 0.00%
TPUB 184         15.61            403 11% 45% 4.10%
TJX 185         67.16      46,421 8% 93% 1.30%
MO 186         51.23    100,718 7% 395% 4.10%
IOSP 187         43.81        1,087 10% 51% 1.40%
SPLP 188         17.88            502 24% 36% 0.00%
GTN 189         15.46            908 9% 64% 0.00%
FF 190         11.68            507 23% 35% 2.30%
GNTX 191         17.40        5,196 8% 69% 1.80%
FLWS 192           9.78            634 11% 47% 0.00%
TIVO 193         10.63        1,230 7% 536% 0.00%
JEC 194         43.57        5,541 11% 45% 0.00%
THO 195         62.68        3,351 9% 64% 1.80%
SCLN 196           9.44            494 8% 93% 0.00%
WSTC 197         31.36        2,704 8% 109% 2.90%
SAVE 198         62.34        4,574 9% 58% 0.00%
HCLP 199         29.86        1,111 11% 45% 8.60%
CRESY 200         13.14            659 11% 44% 0.00%

Here is the Cross Reference List

ACHI 515 22-May #N/A #N/A #N/A #N/A
APEI 412 22-May 65       24.03 20% 61%
APOL 1,772 22-May 53       16.46 20% 67%
AGX 522 22-May 8       35.65 13% 784%
HRB 8,833 22-May 15       32.09 12% 342%
BKE 2,139 22-May 44       44.07 13% 97%
CA 13,644 22-May 45       31.33 9% 486%
CPLA 656 22-May 24       53.63 12% 176%
CSCO 148,407 22-May 41       29.26 9% 342%
CLCT 189 22-May 28       21.33 10% 665%
DLX 3,300 22-May 36       66.09 9% 413%
DEPO 1,245 22-May 2       20.76 21% 2731%
DHX 447 22-May 61          8.55 8% 296%
PLOW 461 22-May 72       20.73 12% 69%
ENTA 749 22-May 3       40.10 24% 1586%
EVOL 101 22-May 90          8.68 9% 110%
FLR 8,520 22-May 59       57.97 14% 68%
GME 4,394 22-May 22       40.80 14% 139%
GILD 164,996 22-May 27     111.71 10% 487%
GORO 169 22-May 66          3.11 20% 60%
ONE 149 22-May 52          3.11 15% 71%
IQNT 598 22-May 25       17.82 13% 149%
IDCC 2,057 22-May 12       57.26 13% 363%
KFY 1,656 22-May 54       32.87 9% 201%
LCI 2,002 22-May 46       55.39 12% 114%
LQDT 316 22-May 38       10.52 12% 127%
MSB 195 22-May #N/A #N/A #N/A #N/A
KORS 12,389 22-May 62       61.63 11% 101%
NATH 180 22-May 23       40.06 13% 159%
NSR 1,492 22-May 26       27.08 15% 133%
NSU 811 22-May 111          4.06 53% 44%
OUTR 1,445 22-May 63       78.12 12% 73%
PDLI 1,089 22-May 1          6.66 37% 887017%
PETS 330 22-May 50       16.31 11% 126%
PPC 6,864 22-May 43       26.50 18% 78%
PBI 4,621 22-May 47       22.99 10% 150%
PSDV 118 22-May 5          4.01 13% 3938%
QCOM 113,510 22-May 49       69.51 9% 339%
RPXC 907 22-May 9       16.04 12% 1813%
SAIC 2,414 22-May 73       52.48 9% 154%
SLI 157 22-May 84       37.94 16% 57%
SPOK 368 22-May 42       16.79 10% 171%
STRA 511 22-May 37       46.54 17% 94%
TDC 5,615 22-May 80       39.57 8% 282%
TIVO 1,023 22-May 193       10.63 7% 536%
UIS 1,048 22-May 51       21.00 13% 80%
VEC 271 22-May 31       25.71 11% 158%
VIAB 26,526 22-May 33       66.80 10% 270%
VNCE 656 22-May 60       17.85 9% 158%
VA 1,230 22-May 64       28.49 12% 82%

As I often see, a few differences.  ACHI just doesn't show up in the gurufocus list.  If I put it in manually, it shows up #1 or #2.  Investors should be very very cautious around ACHI anyway as their most recent finanical statements are as of 12/31/2013.  MSB also never makes the gurufocus cut. If I put them in manually, they are #14.  But they are a strange company as they are a trust and have a very unusual balance sheet. I am not really sure they belong in the traditional sense of Jake's Bubble Gum Shop.

TIVO is the strange one.  The difference here is market cap.  I have it at $1.2b, Yahoo is just over $1b.  MFI, which usually agrees with me as a smidgen over $1 billion.  I pulled up their most recent earnings release:

Weighted average common and common equivalent shares:                   Basic  96,287,902       Diluted  115,667,159   

So at $10.37 a share, you can see my $1.2 billion as the diluted count x 10.37.  Everyone else seems to be using basic share count, but my experience has been to always use diluted as that is a better measure of what it would cost to buy 100% of the company.

I am pretty sure MFI generally uses the diluted count, so who knows.

Final thought, I think VA looks very interesting. I may be a buyer on Tuesday.                            



1 comment:

Unknown said...

Hi Marsh, do you have a WRDS compustat subscription? I've been thinking about doing my own research and was wondering a few things:

1. How much do compustat subscriptions cost?

2. What type of queries do you use with the database?

3. Can I take a look at your code that you use to compute and manage the data you look at?

Thanks!