Sunday, June 01, 2014

May 30th 2014 Top 200 List + Dividend/New Stocks

Top 200 List + Dividend/New Stocks

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 - 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           9.37        1,542 25% 1274340% 0.4%      3.0   USA
TTWO 2         20.63        1,589 38% 986% 0.0%      3.0   USA
KING 3         16.20        5,102 18% 4351% #N/A #N/A   Ireland
AGX 4         30.65            447 20% 1468% 0.0%    20.0   USA
PTIE 5           4.95            223 16% 37295% 0.0%    12.0   USA
CALL 6         14.57            260 17% 1224% 0.0%    20.0   Israel
GAME 7           6.67        1,792 14% 868% 0.0%        -     China
LQDT 8         15.38            497 15% 437% 0.0%      2.0   USA
SPRT 9           2.30            123 19% 254% 0.0%      2.0   USA
PFMT 10           9.49            471 16% 296% 0.0%        -     USA
MYGN 11         33.16        2,533 13% 346% 0.0%      1.0   USA
WTW 12         20.83        1,177 12% 496% 0.0%      1.0   USA
TNH 13      138.90        2,570 18% 188% 0.6%      1.0   USA
USMO 14         15.42            340 17% 202% 0.5%      3.0   USA
CTCM 15         10.17        1,585 17% 175% 1.0%      1.0   Russia
NTES 16         71.16        9,300 11% 524% 1.1%        -     China
USNA 17         71.91        1,035 13% 204% 0.0%      8.0   USA
EBIX 18         15.64            604 11% 595% 0.2%    20.0   USA
AVG 19         19.36        1,030 11% 726% 0.0%        -     Netherlands
BCOR 20         18.97            845 11% 492% 0.0%        -     USA
APOL 21         26.80        3,039 20% 119% 0.0%      3.0   USA
HLF 22         64.83        6,534 11% 238% 0.5%      4.0   Cayman Islands
CSCO 23         24.62    127,532 11% 333% 0.0%        -     USA
RGR 24         60.62        1,206 15% 125% 0.5%      3.0   USA
MBUU 25         19.82            199 12% 211% #N/A #N/A   Netherlands
NSR 26         28.02        1,758 13% 142% 0.0%    10.0   USA
TEX 27         38.46        4,511 39% 101% 0.1%      5.0   USA
ESI 28         17.22            403 46% 100% 0.0%      3.0   USA
UIS 29         23.47        1,088 21% 105% 0.0%      4.0   USA
GA 30         11.76        2,929 10% 412% 0.5%        -     China
PRIS 31           1.83            463 12% 139% 0.0%        -     Spain
DEPO 32         11.93            715 10% 636% 0.0%      4.0   USA
COH 33         40.71      11,348 13% 118% 0.4%      1.0   USA
QCOR 34         90.13        5,572 10% 1624% 0.4%      4.0   USA
DLX 35         56.09        2,843 10% 345% 0.3%      2.0   USA
GME 36         37.85        4,387 14% 105% 0.4%      6.0   USA
BKE 37         44.85        2,155 13% 110% 0.2%    36.0   USA
NUS 38         73.84        4,521 13% 108% 0.3%      4.0   USA
CA 39         28.69      12,738 10% 441% 0.5%      1.0   USA
CNVR 40         23.58        1,621 11% 158% 0.0%      6.0   USA
STRA 41         54.64            578 14% 92% 0.0%      6.0   USA
TARO 42      106.54        4,563 11% 131% 0.0%        -     Israel
SWHC 43         15.88            906 16% 82% 0.0%      9.0   USA
GDOT 44         18.37            712 13% 96% 0.0%      2.0   USA
KRFT 45         59.46      35,735 11% 115% 0.3%        -     USA
IQNT 46         14.98            489 12% 100% 0.1%        -     USA
STV 47           3.38            204 20% 75% 0.0%        -     China
TDC 48         41.99        6,756 9% 362% 0.0%      1.0   USA
NOC 49      121.55      26,911 11% 115% 0.2%      1.0   USA
DNB 50      103.25        3,893 9% 1213% 0.2%      2.0   USA
MSFT 51         40.94    342,545 10% 232% 0.4%      8.0   USA
NEWT 52           2.71            104 11% 110% 0.0%    30.0   USA
AAPL 53      633.00    556,741 9% 333% 0.3%      1.0   USA
CRUS 54         22.13        1,428 14% 77% 0.0%      1.0   USA
BAH 55         22.13        3,301 10% 163% 0.0%      2.0   USA
RTN 56         97.57      30,813 10% 160% 0.3%      1.0   USA
BRCD 57           9.12        3,978 11% 90% 0.0%        -     USA
PENN 58         11.66            933 20% 69% 0.0%      2.0   USA
PETS 59         13.30            267 12% 84% 0.0%    12.0   USA
SAIC 60         38.73        1,925 11% 97% #N/A #N/A   USA
ETM 61         10.44            402 10% 112% 0.0%    11.0   USA
ONE 62           3.76            182 13% 75% 0.0%      6.0   USA
FRAN 63         15.34            655 12% 83% 0.0%      2.0   USA
CPLA 64         57.24            722 10% 152% 0.5%      6.0   USA
CYOU 65         27.00        1,427 16% 68% 0.0%        -     China
BWC 66         32.32        3,584 15% 69% 0.0%      1.0   USA
LFVN 67           1.32            141 9% 193% 0.0%    16.0   USA
SYNT 68         80.90        3,396 10% 123% 0.0%    35.0   USA
IILG 69         20.49        1,190 9% 222% 0.3%      3.0   USA
SHOO 70         31.86        2,075 11% 95% 0.0%    13.0   USA
VGR 71         20.91        1,981 9% 247% 12.9%      4.0   USA
TZOO 72         19.25            288 9% 226% 0.0%      1.0   USA
NTP 73           7.58            344 47% 58% 0.0%        -     China
APEI 74         35.34            629 12% 72% 0.0%      3.0   USA
CHE 75         88.08        1,612 9% 154% 0.2%      3.0   USA
ATAI 76           5.30            120 11% 80% 0.0%        -     China
HPQ 77         33.50      64,186 11% 74% 0.2%        -     USA
STRZA 78         30.60        3,519 9% 119% 0.0%        -     USA
NDZ 79         11.95            742 11% 75% 0.0%        -     Canada
MANT 80         29.49        1,099 12% 69% 0.8%        -     USA
WINA 81         66.29            352 8% 315% 0.1%    73.0   USA
RPXC 82         16.25            885 8% 1262% 0.0%      8.0   USA
SYMC 83         21.99      15,393 9% 133% 0.5%      1.0   USA
ITRN 84         23.47            492 10% 108% 1.0%        -     Israel
MONT 85         18.96            553 8% 332% #N/A #N/A   China
XLS 86         17.08        3,329 14% 58% 0.3%        -     USA
BBBY 87         60.85      12,663 14% 58% 0.0%      1.0   USA
NATR 88         14.73            245 15% 57% 0.2%      1.0   USA
VIAB 89         85.33      37,938 8% 236% 0.3%        -     USA
BBGI 90           6.99            160 10% 80% 0.1%      3.0   USA
ORCL 91         42.02    192,242 8% 481% 0.2%    22.0   USA
SLI 92         29.96            125 17% 53% 0.0%      4.0   USA
MED 93         31.43            416 10% 86% 0.0%    13.0   USA
LXK 94         43.59        2,764 16% 53% 0.6%      2.0   USA
CHKE 95         13.44            113 8% 215% 0.6%    10.0   USA
PME 96           3.27            259 19% 52% #N/A #N/A   China
K 97         68.98      24,971 10% 76% 0.5%        -     USA
MO 98         41.56      82,538 8% 383% 0.9%        -     USA
ATVI 99         20.78      14,962 8% 797% 0.5%      1.0   USA
LO 100         62.17      22,550 8% 633% 0.8%      1.0   USA
WSTC 101         26.80        2,284 9% 100% #N/A #N/A   USA
DHX 102           7.06            391 8% 232% 0.0%      4.0   USA
BOLT 103         18.04            157 12% 56% 0.3%      5.0   USA
GD 104      118.12      41,017 9% 92% 0.4%      1.0   USA
PBI 105         27.63        5,633 8% 150% 0.9%      1.0   USA
GPS 106         41.23      18,595 11% 61% 0.3%      9.0   USA
PETM 107         57.47        5,738 12% 57% 0.2%      1.0   USA
TWX 108         69.83      63,587 9% 117% 0.2%      2.0   USA
MGIC 109           7.92            316 8% 138% 0.0%        -     Israel
EXLS 110         28.34            947 9% 85% 0.0%      5.0   USA
FF 111         17.18            746 15% 50% 0.7%    10.0   USA
CXDC 112         10.94            528 38% 46% 0.0%      3.0   China
JCOM 113         47.36        2,215 8% 441% 0.4%      6.0   USA
HRS 114         77.25        8,297 10% 74% 0.3%      1.0   USA
GNC 115         36.92        3,459 10% 70% 0.2%      1.0   USA
CF 116      243.31      13,358 15% 49% 0.1%        -     USA
FLR 117         75.08      12,190 9% 85% 0.2%      1.0   USA
BR 118         41.02        5,119 8% 224% 0.6%      1.0   USA
EGL 119         38.65            692 10% 69% 0.0%        -     USA
SNDK 120         96.63      22,700 8% 139% 0.2%        -     USA
CRWN 121           3.57        1,284 9% 104% 0.0%        -     USA
ERIC 122         12.45      40,637 10% 60% 0.0%        -     Sweden
IGT 123         12.55        3,120 10% 61% 1.0%      2.0   USA
LMT 124      163.65      53,203 9% 106% 0.5%        -     USA
RAI 125         59.63      32,134 8% 253% 1.1%        -     USA
OMC 126         71.15      18,599 8% 241% 0.5%      1.0   USA
CLCT 127         20.68            171 8% 448% 1.4%    30.0   USA
ROST 128         68.45      14,478 10% 70% 0.2%      2.0   USA
KLAC 129         65.52      11,007 9% 82% 0.4%      1.0   USA
PRGS 130         21.72        1,133 8% 127% 0.0%      4.0   USA
WDC 131         87.85      21,260 10% 58% 0.2%      1.0   USA
YONG 132           7.06            358 72% 41% 0.0%      2.0   China
FL 133         48.18        7,111 11% 51% 0.4%      1.0   USA
QLGC 134           9.94            865 11% 53% 0.0%      1.0   USA
STX 135         53.73      18,161 10% 67% 0.4%      1.0   Ireland
OUTR 136         70.73        1,752 10% 56% 0.0%      2.0   USA
TJX 137         54.45      38,818 9% 82% 0.2%      1.0   USA
DGX 138         59.89        8,684 9% 88% 0.5%      1.0   USA
IBM 139      184.36    192,066 9% 87% 0.4%        -     USA
CTG 140         15.52            257 11% 54% 0.3%      8.0   USA
MD 141         57.63        5,803 8% 186% 0.0%      2.0   USA
CODI 142         17.55            848 12% 48% 4.2%      2.0   USA
HHS 143           7.11            448 9% 66% 2.3%    14.0   USA
SAP 144         76.50      91,494 7% 278% 0.0%        -     Germany
ACN 145         81.45      56,462 7% 494% 0.0%      1.0   Ireland
DPS 146         57.70      11,511 8% 90% 0.5%        -     USA
MDT 147         61.03      61,775 8% 90% 0.4%      1.0   USA
CACI 148         71.40        1,854 9% 78% 0.0%      1.0   USA
PM 149         88.54    140,159 8% 134% 0.7%        -     USA
WHR 150      143.55      11,398 11% 47% 0.3%      1.0   USA
TRW 151         84.87      10,167 12% 45% 0.0%      1.0   USA
MDP 152         44.96        2,040 8% 103% 1.0%      2.0   USA
EXPR 153         12.61        1,065 17% 39% 0.0%      4.0   USA
MBT 154         18.49      18,388 13% 41% 0.4%        -     Russia
CSGS 155         26.27            894 9% 65% 0.5%      5.0   USA
LNN 156         84.29        1,091 10% 52% 0.3%      5.0   USA
KLIC 157         14.09        1,085 13% 42% 0.0%      5.0   USA
PLOW 158         17.47            386 9% 59% 1.1%      3.0   USA
SAFM 159         92.51        2,076 15% 39% 0.0%      8.0   USA
OFLX 160         19.73            199 8% 86% 0.0%    29.0   USA
CSC 161         62.89        9,386 11% 44% 0.0%      1.0   USA
JOY 162         57.15        5,867 12% 42% 0.4%      1.0   USA
INFY 163         51.43      29,387 8% 82% #N/A #N/A   India
SBH 164         25.62        4,257 9% 69% 0.0%      1.0   USA
LH 165      102.58        8,883 8% 82% 0.0%      1.0   USA
PPC 166         25.44        6,600 11% 43% 0.0%      2.0   USA
NTAP 167         37.01      12,450 9% 74% 0.2%        -     USA
CO 168           4.47            326 18% 36% 0.0%      1.0   Hong Kong
UTHR 169         95.74        5,424 8% 87% 0.0%        -     USA
UEPS 170         11.25            509 13% 39% 0.0%      2.0   South Africa
HIBB 171         52.59        1,374 9% 57% 0.0%      1.0   USA
MAN 172         81.98        6,657 10% 52% 0.0%      1.0   USA
HSNI 173         55.62        3,013 9% 65% 0.3%      1.0   USA
DSW 174         25.05        2,307 13% 39% 0.2%      1.0   USA
ANIK 175         46.83            726 8% 91% 0.0%      3.0   USA
FENG 176           9.89            769 8% 94% 0.0%        -     China
RIOM 177           1.70            301 33% 34% 0.0%        -     Canada
PIR 178         17.61        1,814 10% 46% 0.2%      5.0   USA
PFE 179         29.63    191,884 8% 75% 0.7%        -     USA
TUP 180         83.72        4,278 8% 77% 0.7%      2.0   USA
OSK 181         54.05        4,622 10% 46% 0.2%      2.0   USA
RLGT 182           3.09            113 8% 116% 0.0%    36.0   USA
FOSL 183      104.76        5,694 9% 52% 0.0%    17.0   USA
EGY 184           6.50            370 20% 34% 0.0%      5.0   USA
RECN 185         12.40            486 9% 54% 1.1%      2.0   USA
CPSI 186         63.58            710 8% 106% 0.8%    11.0   USA
LMNS 187           8.85            312 7% 220% #N/A #N/A   Israel
PBH 188         34.20        1,796 7% 251% 0.3%      5.0   USA
HON 189         93.15      74,185 8% 75% 0.4%        -     USA
SPLS 190         11.25        7,303 14% 35% 0.7%      1.0   USA
LEA 191         88.05        7,287 11% 40% 0.1%        -     USA
SGU 192           6.30            362 16% 35% 0.1%      1.0   USA
DLTR 193         53.03      11,014 9% 61% 0.0%      4.0   USA
MHFI 194         81.77      22,667 7% 645% 0.4%      1.0   USA
AMSWA 195           9.61            271 7% 383% 1.1%    14.0   USA
GEOS 196         50.72            659 16% 34% #N/A #N/A   USA
HURN 197         67.88        1,567 8% 78% 0.0%      7.0   USA
STMP 198         32.32            539 8% 113% 0.0%    19.0   USA
DG 199         53.78      17,161 9% 56% 0.0%      3.0   USA
KFY 200         30.37        1,494 7% 154% 0.0%      2.0   USA

I find it interesting that some recent IPOs (2 of which I owned are in the top 200: LMNS (gasp), MBUU and KING.  Recall, I am apprehensive whether MBUU should be on the list, as I did not think (in my quick look) that minorty income was treated correctly.  Just be cautious.

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 #75 (CHE) is the highest, and a "50" would be perfect. TIME.WI is a head scratcher.  I do not even show they are trading yet, so I have no idea how they can be appearing on official screen. I will watch them closely as they could be a great potential add to my dividend portfolio.  I find it interesting that AGX is still #4 overall and it has been a two-bagger for me.

Ticker Mkt Cap Date My Ranking Price EY ROIC
APOL 3,005.16 30-May 21         26.80 20% 119%
AAPL 545,484.60 30-May 53      633.00 9% 333%
AGX 437.87 30-May 4         30.65 20% 1468%
BCOR 800.59 30-May 20         18.97 11% 492%
BAH 3,205.97 30-May 55         22.13 10% 163%
BRCD 3,971.32 30-May 57           9.12 11% 90%
BKE 2,169.62 30-May 37         44.85 13% 110%
CA 12,587.45 30-May 39         28.69 10% 441%
CPLA 704.91 30-May 64         57.24 10% 152%
CHE 1,536.20 30-May 75         88.08 9% 154%
CRUS 1,371.09 30-May 54         22.13 14% 77%
CSCO 125,955.90 30-May 23         24.62 11% 333%
COH 11,299.14 30-May 33         40.71 13% 118%
CNVR 1,578.87 30-May 40         23.58 11% 158%
DLX 2,806.91 30-May 35         56.09 10% 345%
DEPO 689.49 30-May 32         11.93 10% 636%
DNB 3,820.25 30-May 50      103.25 9% 1213%
EBIX 600.33 30-May 18         15.64 11% 595%
HLF 6,567.28 30-May 22         64.83 11% 238%
ONE 177.51 30-May 62           3.76 13% 75%
IQNT 485.10 30-May 46         14.98 12% 100%
IILG 1,182.81 30-May 69         20.49 9% 222%
ESI 402.43 30-May 28         17.22 46% 100%
KING 5,147.13 30-May 3         16.20 18% 4351%
LFVN 137.31 30-May 67           1.32 9% 193%
LQDT 496.37 30-May 8         15.38 15% 437%
MBUU 219.11 30-May 25         19.82 12% 211%
MSFT 338,164.40 30-May 51         40.94 10% 232%
MYGN 2,776.52 30-May 11         33.16 13% 346%
NSR 1,720.54 30-May 26         28.02 13% 142%
NOC 26,134.10 30-May 49      121.55 11% 115%
NUS 4,356.56 30-May 38         73.84 13% 108%
PTIE 225.75 30-May 5           4.95 16% 37295%
PDLI 1,625.77 30-May 1           9.37 25% ########
PFMT 459.86 30-May 10           9.49 16% 296%
PETS 268.53 30-May 59         13.30 12% 84%
QCOR 5,497.66 30-May 34         90.13 10% 1624%
RTN 30,480.87 30-May 56         97.57 10% 160%
SAIC 1,897.77 30-May 60         38.73 11% 97%
SWHC 872.11 30-May 43         15.88 16% 82%
STRA 592.46 30-May 41         54.64 14% 92%
RGR 1,175.97 30-May 24         60.62 15% 125%
SPRT 122.96 30-May 9           2.30 19% 254%
SYNT 3,378.38 30-May 68         80.90 10% 123%
TTWO 2,093.92 30-May 2         20.63 38% 986%
TIME.WI 2,381.13 30-May #N/A #N/A #N/A #N/A
UIS 1,199.53 30-May 29         23.47 21% 105%
USMO 334.06 30-May 14         15.42 17% 202%
USNA 1,005.37 30-May 17         71.91 13% 204%
WTW 1,175.96 30-May 12         20.83 12% 496%


New Stocks & Dividend Stocks

Finally, since I just started a new monthly tracking portfolio, I list below stocks that I have identified as "new" (not in previous 11 tracking portfolios) and "dividend" (yield per Yahoo Finance 2.6% or greater).

Stock  Initial Price   End Price  52 week low Mkt Cap Yield
MSFT              40.94           40.94                30.84     338,164 2.6%
CSCO              24.62           24.62                20.22     125,956 2.8%
COH              40.71           40.71                40.41       11,299 3.3%
CA              28.69           28.69                27.09       12,587 3.5%
BKE              44.85           44.85                41.45         2,170 4.5%
IQNT              14.98           14.98                 4.61           485 10.1%
BAH              22.13           22.13                16.50         3,206 10.8%

Stock Initial Price 52 week low  Mkt Cap  New
MBUU              19.82                16.67           219 1
IILG              20.49                18.96         1,183 1
ONE                3.76                 3.56           178 1
DEPO              11.93                 5.50           689 1
BRCD                9.12                 5.25         3,971 1




7 comments:

Brian Block said...

Marsh,

Shouldn't

USMO
RGR
PETS
PDLI

be included in your dividend portfolio?

John Carney said...

Thanks for the top 200. Your work is very, very good. I think yahoo might be a better source for dividends. Of course you need to check for recent dividends to make sure they are not a WTW.

Try looking at MSN Charts with EMA @ 35 days and 105 days. Why fight the market. It sure keeps you out of value traps. Also you can always pick up CA, COH & GME when they point up you won't lose much to wait for a turn. In some cases you get in cheaper. In other cases it might cost 5%. On balance it provide a good entry.

Of course, a year and four earning reports can hurt the head start.

John Carney said...

I love the easy to read numbers to post.

It great for a old man.

John Carney said...

Most of the dividends on the top 200 are not correct. I forget to put that in the first post.

Got another easy number to pos

Marsh_Gerda said...

Thanks for the comments everyone. It does appear I may have hit "publish" slightly too soon. I will check on the dividends and see if I made an error or whether yahoo finance is messed up.

John Carney said...

The top 200 list has 128 with a market Cap of plus 1 billion.

Has 38 with dividends equal to 2.6% or greater.

Has 17 with a chart Break Out when using a EMA of 35 days and 105 days.

I failed to mention that the chart should have a upward slop and should not look flat. It best when it looks like it is trending.

Thanks again for all of your good work.





John Carney said...

The top 200 had 72 stocks under 1 Billion.

The 72 had 14 with dividends equal or greater 2.6%.

This is about 19% vs caps over 1 billion with 30% that had dividends over 2.6%

The caps under 1 Billion only had one stock with a break out.

Maybe Marsh's Canary is singing.

Got a another easy number to post!