Monday, February 17, 2014

Ranking of Stocks Under $300m Market Cap

Top Stocks Under $300m Market Cap

There has been some good discussion on why Magic Formula Investing has not been "breaking away" from the broader markets, despite now having 7+ years.  I commented that subsets have done well, specifically stocks with market caps > $1 billion and stocks that pay a 2.6% dividend or higher.  Of course, in JG's back testing, he looked at smaller market cap stocks and they certainly did not drag down the results.

The official website only shows stocks down to $50m market cap, which is actually quite small.  I am not a huge investor, but when I try to buy stocks that small, I almost feel like a market mover.  You have to be careful and use limit orders.

Here is my typical list of caveats I produce when making my lists:

I decided to use this weekend to update my list.  It is never too early to start looking forward to my next tranche (May 6th, 2014) as I approach new tranche.  We had a surprising amount of snow here this past week, a bit over a foot.. 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.

I am too lazy to re-type it, but you get the gist.  It may take a while to run my workbook.  Hotel wifi is not always blazing fast.

Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield Country
MTSL 1           1.81                 8 29% 872% 0.0%   Israel
AEZS 2           1.28              38 53% 157% 0.0%   Canada
ZA 3           1.92              53 357% 89% 0.0%   China
DVOX 4           0.10                 1 46% 113% 0.0%   USA
PRLS 5           3.66              10 135% 89% 0.0%   USA
LIWA 6           5.14            154 3209% 62% 0.0%   China
WSTG 7         14.57              66 19% 187% 4.3%   USA
NTE 8           6.12            278 632% 60% 7.8%   China
MKTY 9           1.00                 5 25% 100% 4.3%   USA
SPRT 10           2.46            134 18% 184% 0.0%   USA
STV 11           2.97            176 19% 66% 0.0%   China
UNTD 12         10.58            140 16% 97% 2.9%   USA
NATR 13         15.33            253 15% 79% 12.4%   USA
RFIL 14           6.73              58 15% 71% 4.2%   USA
GSOL 15           6.76            245 16% 62% 0.0%   Bermuda
GPRC 16           2.67              28 125% 37% 0.0%   China
ATAI 17           3.99              90 14% 60% 0.0%   China
SPU 18           1.92              51 561% 33% 0.0%   China
MTEX 19         18.51              49 11% 111% 0.0%   USA
CO 20           3.92            286 21% 42% 0.0%   Hong Kong
SMTP 21           6.46              20 10% 536% 0.0%   USA
ZAGG 22           4.06            128 23% 40% 0.0%   USA
MNDO 23           2.11              40 10% 364% 11.4%   Israel
INTX 24           6.37            115 14% 52% 0.0%   USA
SBSA 25           4.43              32 10% 118% 0.0%   USA
UBIC 26           4.99              85 12% 59% 0.0%   Japan
CBRX 27           6.90              77 14% 47% 0.0%   USA
XNY 28           1.30              74 436% 27% 0.0%   China
AE 29         67.10            283 19% 37% 1.0%   USA
SLI 30         24.20            101 17% 41% 0.0%   USA
WLDN 31           4.66              35 13% 47% 0.0%   USA
CXDC 32           4.78            229 43% 29% 0.0%   China
GRO 33           1.47              81 48% 29% 0.0%   China
JCTCF 34         10.00              31 19% 35% 0.0%   USA
ISIG 35           2.89              39 11% 67% 0.0%   USA
CEDU 36           6.85              64 32% 26% 0.0%   China
LEE 37           4.08            217 10% 62% 0.0%   USA
NVEE 38           7.97              33 12% 40% 0.0%   USA
DFZ 39         17.84            206 11% 49% 2.1%   USA
SPAN 40         19.65              58 12% 41% 2.7%   USA
SGA 41         43.41            250 11% 45% 4.1%   USA
NEWT 42           2.86            109 10% 74% 0.0%   USA
AFOP 43         11.55            222 10% 77% 1.3%   USA
MSN 44           2.16              59 59% 22% 0.0%   USA
TGD 45           1.59            231 22% 25% 0.0%   Canada
CHKE 46         14.01            118 9% 216% 2.9%   USA
CGA 47           3.00              95 53% 21% 0.0%   China
CRWS 48           8.56              85 11% 38% 4.0%   USA
CTG 49         16.79            284 10% 60% 1.2%   USA
INTT 50           3.99              42 12% 34% 0.0%   USA
KGJI 51           1.77            114 44% 22% 0.0%   USA
JOEZ 52           1.26              85 13% 31% 0.0%   USA
BTH 53           9.98            160 23% 23% 2.1%   USA
GV 54           2.08              53 18% 25% 0.0%   USA
TGC 55           0.45              27 19% 24% 0.0%   USA
CLCT 56         19.79            163 8% 473% 6.5%   USA
ESP 57         28.94              66 11% 35% 6.2%   USA
VSEC 58         44.18            236 12% 31% 0.8%   USA
WILC 59           8.08            105 21% 23% 0.0%   Israel
ASFI 60           8.42            111 13% 30% 0.0%   USA
GSB 61           2.42              47 8% 507% 1.7%   USA
NCIT 62           9.31            120 11% 34% 0.0%   USA
UFPT 63         25.65            182 11% 36% 0.0%   USA
ZX 64           2.73            141 69% 18% 0.0%   China
UWN 65           1.39              23 9% 59% 0.0%   USA
PERI 66         11.42            142 8% 772% 0.0%   Israel
PHMD 67         14.00            286 10% 41% 0.0%   USA
TPI 68           0.94              28 1135% 17% 0.0%   China
EVK 69           6.29              93 15% 23% 0.0%   USA
LFVN 70           1.33            149 8% 201% 0.0%   USA
MTR 71         22.50              42 8% 112% 0.0%   USA
TLF 72           9.51              97 12% 28% 0.0%   USA
BOLT 73         21.84            190 9% 57% 1.0%   USA
HNH 74         20.98            279 12% 25% 0.0%   USA
DQ 75         40.65            282 19% 21% 0.0%   China
GENC 76         10.78            103 30% 18% 0.0%   USA
CIMT 77           8.86              86 7% 573% 0.0%   Israel
MAG 78         24.88              83 10% 36% #VALUE!   USA
CCF 79         30.50            279 10% 34% 0.0%   USA
DOM 80           7.28              57 9% 57% 9.4%   USA
MHH 81         14.06              62 9% 62% 3.5%   USA
HCKT 82           6.08            199 9% 57% 0.0%   USA
RLGT 83           3.06            112 8% 116% 0.0%   USA
MOBI 84           4.53            135 7% 239% 0.0%   China
CPIX 85           4.76              87 10% 31% 0.0%   USA
IKGH 86           2.63            169 18% 18% 6.5%   Hong Kong
VOC 87         14.79            251 11% 24% 10.0%   USA
CFI 88         19.90            247 10% 31% 0.0%   USA
FORD 89           1.69              14 10% 28% 0.0%   USA
OME 90         11.08            230 18% 18% 0.0%   USA
CRT 91         30.77            185 7% 129% 7.9%   USA
TRNS 92           9.20              66 9% 37% 0.0%   USA
CREG 93           3.18            175 10% 33% 0.0%   China
EVOL 94           9.00            106 7% 306% 4.0%   USA
CLNT 95           5.63              20 56% 15% 0.0%   China
INS 96           2.26              20 9% 45% 0.0%   USA
UTMD 97         54.48            206 7% 102% 0.0%   USA
STRT 98         55.00            192 11% 21% 2.9%   USA
GMAN 99           6.42            124 13% 19% 57.9%   USA
SIMO 100         17.07            575 9% 43% 4.5%   Taiwan
CNET 101           0.96              21 28% 15% 0.0%   China
LBMH 102           3.83            204 7% 212% 0.0%   USA
RICK 103         11.37            112 11% 20% 0.0%   USA
NUTR 104         25.62            252 10% 23% 0.0%   USA
AFAM 105         29.00            271 8% 48% 0.0%   USA
CSS 106         27.27            255 13% 17% 1.0%   USA
SVLC 107           2.59            286 10% 25% 0.0%   Canada
GURE 108           2.44              95 2324% 11% 0.0%   China
KEQU 109         16.64              44 13% 16% 2.5%   USA
SGOC 110           3.56              61 22% 14% 0.0%   China
SUTR 111           1.88              78 37% 13% 0.0%   China
GAGA 112           3.20            141 23% 13% 0.0%   Hong Kong
BAGL 113         15.89            285 8% 48% 3.3%   USA
SPCB 114           5.70              56 6% 123% 0.0%   Israel
RMCF 115         11.57              75 8% 41% 3.9%   USA
OFLX 116         20.25            204 7% 81% 2.1%   USA
ALN 117           1.16              40 33% 12% 0.0%   China
NVEC 118         55.74            271 6% 183% 0.0%   USA
MNTG 119           5.25            149 11% 18% 0.0%   USA
JBSS 120         22.35            248 13% 15% 6.7%   USA
CLRO 121           9.23              87 8% 31% 0.0%   USA
TACT 122         11.57            101 8% 34% 1.8%   USA
CVR 123         38.00              37 11% 17% 1.7%   USA
PFIN 124           7.38              29 14% 14% 0.0%   USA
MAMS 125           5.40              69 5% 273% #VALUE!   United Kingdom
MONT 126         15.83            414 5% 326% 0.0%   China
ROIA 127           4.98            236 7% 60% 0.0%   USA
VSR 128           3.88              38 11% 16% 0.0%   USA
HOFT 129         15.40            166 11% 17% 0.0%   USA
HWCC 130         13.47            240 9% 21% 3.1%   USA
ROIAK 131           5.09            241 7% 60% 0.0%   USA
PNTR 132           9.35              52 7% 44% 0.0%   Israel
SIF 133         27.23            147 9% 22% 0.7%   USA
CRAI 134         20.90            212 12% 15% 0.0%   USA
MOC 135           2.04              20 12% 15% 0.0%   USA
ONP 136           2.44              45 27% 11% 1.3%   China
RCMT 137           6.43              80 10% 17% 0.0%   USA
ADUS 138         25.98            288 7% 56% 0.0%   USA
VDSI 139           6.76            265 7% 36% 0.0%   USA
PMD 140         18.64            100 6% 63% 1.3%   USA
SLP 141           5.97              98 5% 223% 2.5%   USA
NATH 142         50.21            232 6% 82% 0.0%   USA
NLS 143           8.32            262 6% 85% 0.0%   USA
WEYS 144         25.66            279 9% 20% 2.1%   USA
BSTC 145         22.16            153 5% 152% 0.0%   USA
VIFL 146           7.15              21 8% 23% 0.0%   USA
AIRT 147         11.57              28 12% 14% 2.6%   USA
CCUR 148           8.60              78 6% 58% 5.0%   USA
COCO 149           1.42            125 14% 12% 0.9%   USA
UG 150         28.18            130 5% 141% 3.5%   USA
ARKR 151         21.50              73 8% 25% 4.7%   USA
DATE 152           6.37            196 7% 48% 4.0%   China
SKBI 153           5.01              38 24% 10% 0.0%   China
ALSK 154           2.21            131 10% 16% 0.0%   USA
UNTK 155           1.64              31 7% 31% 0.0%   USA
CMT 156         13.98            104 10% 15% 0.0%   USA
MRGE 157           2.21            207 4% 241% 0.0%   USA
HURC 158         26.13            170 11% 14% 0.6%   USA
SPNS 159           7.23            302 4% 284% 0.0%   Israel
ZIGO 160         14.58            282 9% 19% 0.0%   USA
DCO 161         24.26            265 9% 18% 0.0%   USA
BIRT 162           5.87            301 5% 182% 3.8%   USA
XRM 163         16.10            258 10% 16% 0.0%   USA
EDGW 164           5.98              73 6% 53% 0.0%   USA
KTCC 165         10.04            110 11% 13% 0.0%   USA
TWMC 166           3.98            130 22% 9% 0.0%   USA
TCX 167         13.75            159 4% 366% 0.0%   Canada
SALM 168           8.45            214 7% 30% 0.0%   USA
SCLN 169           4.98            274 6% 41% 0.0%   USA
CEMI 170           3.30              32 8% 24% 0.0%   USA
ESYS 171         12.80              50 7% 27% #VALUE!   USA
GORO 172           5.47            292 6% 44% 7.3%   USA
BORN 173           2.37              61 19% 9% 0.0%   China
DTLK 174         13.75            277 6% 39% 0.0%   USA
ZIXI 175           4.43            279 4% 380% 0.0%   USA
DIT 176         89.00              66 11% 13% #VALUE!   USA
JOUT 177         23.04            229 10% 15% 0.0%   USA
AMOT 178         11.16              98 7% 24% 0.9%   USA
SRI 179         10.15            276 10% 16% 0.0%   USA
FHCO 180           6.88            198 4% 143% 3.8%   USA
APWC 181           3.18              44 117% 6% 0.0%   Taiwan
NCFT 182         16.76            331 5% 61% 0.0%   USA
EMMS 183           3.45            159 6% 37% 0.0%   USA
CIX 184         10.41            129 9% 16% 2.6%   USA
SKUL 185           7.72            215 8% 19% 0.0%   USA
FLXS 186         35.54            268 9% 16% 1.7%   USA
FTEK 187           6.11            138 7% 22% 0.0%   USA
ELTK 188           2.28              15 9% 15% 3.5%   Israel
MOCO 189         16.72              95 6% 33% 2.7%   USA
ESCA 190         12.09            166 7% 20% 2.8%   USA
LCUT 191         14.92            195 9% 14% 0.9%   USA
IGLD 192           8.06            155 9% 14% #VALUE!   Israel
BDL 193         14.93              28 10% 11% 0.0%   USA
ELSE 194           3.96              14 9% 15% 1.0%   USA
BTN 195           4.74              67 11% 10% 0.0%   USA
CVO 196           3.18            274 7% 22% 0.0%   USA
HIL 197           4.71            186 8% 16% 0.0%   USA
ARTX 198           2.87              48 8% 17% 0.0%   USA
NRCIB 199         37.58            926 3% 208% 0.0%   USA
AMCF 200           1.75              17 11% 8% 0.0%   China

Certainly an eclectic listing.  I would strongly suggest caution on any and all on this list, especially anything in China (ZA for instance). Some names on here I have owned in the past (MTEX was on some of the older MFI portfolios as was CHKE). Wait, I also owned PRLS and WILC at one time.

No comments: