As my readers know, I have created a spreadsheet that ranks stocks based on Joel Greenblatt's Magic Formula Investing book. While I generally rely on the official website, I sometimes get some new names running my own approach. Also, my spreadsheet gives me some information detail that may be useful.
I need as sharp a pencil as possible as I'll be picking five new stocks on Tuesday. I have tested my workbook very thoroughly and actually created it back when the official MFI website printed a little more detail (ROIC and Earnings Yield).
Ticker | Rank | Stock Price | Market Cap | Earnings Yield | ROIC | Dividend Yield |
NHTC | 1 | 26.67 | 300 | 25% | 4473% | 1.20% |
FLML | 2 | 10.81 | 446 | 18% | 1830% | 0.00% |
CALL | 3 | 6.35 | 101 | 24% | 638% | 0.00% |
WILN | 4 | 1.31 | 156 | 18% | 1068% | 2.70% |
PDLI | 5 | 3.58 | 588 | 38% | 487% | 5.59% |
GILD | 6 | 76.42 | 102,326 | 17% | 731% | 2.46% |
IDCC | 7 | 77.15 | 2,697 | 13% | 2543% | 1.56% |
HPQ | 8 | 15.82 | 27,290 | 15% | 322% | 3.36% |
MMI | 9 | 26.47 | 1,036 | 12% | 722% | 0.00% |
AVID | 10 | 4.47 | 178 | 20% | 207% | 0.00% |
AGX | 11 | 58.35 | 891 | 12% | 621% | 0.00% |
UTHR | 12 | 127.00 | 5,867 | 22% | 198% | 0.00% |
VEC | 13 | 21.92 | 242 | 16% | 230% | 0.00% |
AGTC | 14 | 9.85 | 182 | 11% | 419% | 0.00% |
IRMD | 15 | 9.90 | 117 | 14% | 187% | 0.00% |
TDC | 16 | 28.61 | 3,765 | 11% | 292% | 0.00% |
HLF | 17 | 53.42 | 4,615 | 12% | 175% | 0.00% |
NSR | 18 | 23.05 | 1,278 | 14% | 146% | 0.00% |
CBI | 19 | 30.57 | 3,114 | 14% | 138% | 0.92% |
MSGN | 20 | 20.30 | 1,531 | 11% | 249% | 0.00% |
DLX | 21 | 66.38 | 3,249 | 10% | 448% | 1.81% |
SYNT | 22 | 19.14 | 1,613 | 14% | 142% | 0.00% |
CSCO | 23 | 31.36 | 158,901 | 10% | 364% | 3.32% |
ENTA | 24 | 28.14 | 534 | 12% | 155% | 0.00% |
TARO | 25 | 105.34 | 4,463 | 18% | 99% | 0.00% |
MBUU | 26 | 17.45 | 310 | 10% | 205% | 0.00% |
MCFT | 27 | 13.37 | 249 | 10% | 222% | 0.00% |
PCO | 28 | 6.54 | 181 | 182% | 87% | 0.00% |
AWRE | 29 | 5.40 | 124 | 11% | 165% | 0.00% |
BBX | 30 | 21.23 | 367 | 35% | 85% | 0.00% |
VIAB | 31 | 38.42 | 15,303 | 10% | 207% | 2.11% |
SWHC | 32 | 21.24 | 1,208 | 16% | 97% | 0.00% |
TGNA | 33 | 21.24 | 4,632 | 11% | 158% | 2.91% |
GHC | 34 | 476.60 | 2,657 | 12% | 118% | 0.00% |
BKE | 35 | 23.50 | 1,133 | 22% | 82% | 4.26% |
RGR | 36 | 47.50 | 912 | 16% | 88% | 3.45% |
HRB | 37 | 22.83 | 5,034 | 10% | 219% | 3.85% |
PBI | 38 | 15.18 | 2,834 | 11% | 122% | 4.94% |
GME | 39 | 22.32 | 2,328 | 23% | 78% | 6.63% |
ASPS | 40 | 25.59 | 501 | 14% | 94% | 0.00% |
AAPL | 41 | 108.43 | 584,799 | 9% | 220% | 2.10% |
MPAA | 42 | 26.54 | 516 | 10% | 157% | 0.00% |
VIA | 43 | 42.85 | 17,067 | 9% | 207% | 1.89% |
BGSF | 44 | 13.05 | 105 | 12% | 98% | 7.66% |
SSNI | 45 | 14.52 | 751 | 9% | 226% | 0.00% |
BLBD | 46 | 14.90 | 314 | 10% | 163% | 0.00% |
CA | 47 | 31.89 | 13,234 | 8% | 550% | 3.18% |
SPOK | 48 | 18.20 | 374 | 9% | 183% | 2.75% |
TSRA | 49 | 39.45 | 1,945 | 8% | 1279% | 2.06% |
SGU | 50 | 9.64 | 551 | 12% | 94% | 4.25% |
CCS | 51 | 21.00 | 437 | 8% | 630% | 0.00% |
UEPS | 52 | 10.69 | 535 | 30% | 66% | 0.00% |
WNC | 53 | 12.64 | 835 | 24% | 67% | 0.00% |
RPXC | 54 | 10.72 | 539 | 8% | 580% | 0.00% |
TNH | 55 | 106.25 | 1,966 | 13% | 81% | 6.60% |
NATH | 56 | 53.25 | 224 | 9% | 254% | 0.00% |
MLP | 57 | 6.60 | 125 | 15% | 73% | 0.00% |
MCK | 58 | 143.03 | 32,611 | 10% | 111% | 0.78% |
LFVN | 59 | 7.63 | 108 | 10% | 122% | 0.00% |
NCIT | 60 | 12.45 | 173 | 13% | 79% | 0.00% |
BBSI | 61 | 52.58 | 389 | 10% | 145% | 1.67% |
USNA | 62 | 126.85 | 1,589 | 10% | 137% | 0.00% |
VLRS | 63 | 15.41 | 1,559 | 10% | 132% | 0.00% |
MYGN | 64 | 17.29 | 1,190 | 11% | 90% | 0.00% |
MPW | 65 | 12.00 | 2,970 | 8% | 4094% | 7.67% |
HSII | 66 | 21.70 | 409 | 11% | 98% | 2.40% |
UIS | 67 | 12.80 | 641 | 14% | 73% | 0.00% |
LEA | 68 | 119.05 | 8,578 | 16% | 66% | 1.01% |
AKRX | 69 | 22.18 | 2,802 | 12% | 77% | 0.00% |
NLS | 70 | 16.90 | 530 | 10% | 102% | 0.00% |
RHI | 71 | 43.35 | 5,557 | 11% | 89% | 2.03% |
BBY | 72 | 38.36 | 12,386 | 14% | 67% | 2.92% |
GNE | 73 | 6.47 | 148 | 13% | 73% | 3.71% |
CXRX | 74 | 2.83 | 144 | 8% | 3893% | 0.00% |
LEE | 75 | 2.70 | 147 | 13% | 73% | 0.00% |
KFY | 76 | 22.76 | 1,288 | 11% | 78% | 1.76% |
CSGS | 77 | 41.79 | 1,364 | 9% | 118% | 1.77% |
SCMP | 78 | 15.20 | 660 | 10% | 112% | 0.00% |
DHX | 79 | 6.50 | 310 | 8% | 214% | 0.00% |
ORCL | 80 | 39.45 | 166,518 | 8% | 315% | 1.52% |
KORS | 81 | 49.70 | 8,391 | 12% | 70% | 0.00% |
SEDG | 82 | 13.35 | 594 | 16% | 62% | 0.00% |
TIME | 83 | 13.10 | 1,305 | 10% | 88% | 5.91% |
MDCA | 84 | 4.65 | 243 | 9% | 144% | 0.00% |
RLGY | 85 | 22.63 | 3,284 | 8% | 220% | 1.59% |
MED | 86 | 38.78 | 463 | 9% | 164% | 2.58% |
DISCK | 87 | 25.78 | 15,520 | 9% | 147% | 0.00% |
CPLA | 88 | 83.05 | 979 | 8% | 215% | 1.88% |
FOX | 89 | 27.00 | 50,301 | 9% | 121% | 1.33% |
TEVA | 90 | 40.65 | 37,398 | 11% | 75% | 3.40% |
FOXA | 91 | 27.14 | 50,562 | 9% | 121% | 1.33% |
MDP | 92 | 50.40 | 2,292 | 9% | 109% | 3.93% |
BPI | 93 | 9.02 | 418 | 9% | 105% | 0.00% |
NVO | 94 | 33.45 | 84,659 | 8% | 164% | 4.22% |
KLAC | 95 | 75.46 | 11,849 | 9% | 142% | 2.86% |
DISCA | 96 | 26.44 | 15,917 | 9% | 147% | 0.00% |
RECN | 97 | 15.70 | 578 | 11% | 76% | 2.80% |
ATHM | 98 | 22.90 | 2,653 | 9% | 141% | 0.00% |
NRCIA | 99 | 16.00 | 394 | 8% | 258% | 2.50% |
ZPIN | 100 | 14.20 | 814 | 8% | 604% | 0.00% |
MAN | 101 | 83.53 | 5,764 | 12% | 64% | 2.06% |
CAH | 102 | 71.37 | 22,981 | 9% | 95% | 2.52% |
FIT | 103 | 9.22 | 2,247 | 13% | 59% | 0.00% |
CATO | 104 | 35.34 | 961 | 14% | 57% | 3.74% |
AMGN | 105 | 149.04 | 112,227 | 9% | 133% | 2.68% |
AMFW | 106 | 5.37 | 2,057 | 8% | 161% | 3.62% |
OMC | 107 | 81.33 | 19,413 | 8% | 277% | 2.71% |
CYOU | 108 | 26.86 | 1,429 | 23% | 50% | 0.00% |
MD | 109 | 61.56 | 5,734 | 8% | 235% | 0.00% |
MIK | 110 | 22.86 | 4,745 | 10% | 82% | 0.00% |
EBF | 111 | 16.30 | 422 | 14% | 54% | 4.29% |
ABBV | 112 | 63.10 | 103,484 | 8% | 380% | 4.06% |
IPG | 113 | 22.07 | 9,002 | 8% | 152% | 2.72% |
SIMO | 114 | 43.47 | 1,545 | 9% | 93% | 1.84% |
WSTC | 115 | 23.99 | 2,030 | 9% | 112% | 3.96% |
AMWD | 116 | 77.55 | 1,270 | 9% | 83% | 0.00% |
PETS | 117 | 21.29 | 434 | 9% | 99% | 3.57% |
SCLN | 118 | 9.85 | 518 | 10% | 75% | 0.00% |
ODP | 119 | 4.15 | 2,262 | 16% | 48% | 2.41% |
TUP | 120 | 58.61 | 2,977 | 9% | 98% | 4.53% |
MLHR | 121 | 31.90 | 1,931 | 10% | 68% | 2.13% |
MEET | 122 | 4.78 | 282 | 8% | 171% | 0.00% |
GNTX | 123 | 17.19 | 4,993 | 11% | 58% | 2.09% |
GNC | 124 | 14.41 | 984 | 14% | 50% | 5.55% |
STRA | 125 | 68.45 | 741 | 9% | 83% | 0.00% |
LIFZF | 126 | 12.14 | 777 | 7% | 1045% | 6.17% |
WINA | 127 | 106.80 | 462 | 7% | 250% | 0.38% |
CBS | 128 | 57.74 | 25,752 | 9% | 86% | 1.25% |
DNB | 129 | 117.24 | 4,291 | 7% | 1209% | 1.65% |
TWX | 130 | 86.80 | 68,355 | 8% | 121% | 1.86% |
TCX | 131 | 30.95 | 329 | 7% | 254% | 0.00% |
ANIK | 132 | 45.56 | 687 | 10% | 66% | 0.00% |
CLCT | 133 | 20.30 | 174 | 7% | 396% | 6.90% |
JNPR | 134 | 25.41 | 9,770 | 9% | 83% | 1.57% |
FL | 135 | 71.53 | 9,692 | 11% | 57% | 1.54% |
DIN | 136 | 82.48 | 1,488 | 8% | 112% | 4.70% |
GIB | 137 | 48.50 | 14,986 | 7% | 262% | 0.00% |
VC | 138 | 69.64 | 2,396 | 11% | 56% | 0.00% |
AHS | 139 | 33.02 | 1,632 | 9% | 76% | 0.00% |
BIIB | 140 | 319.18 | 70,028 | 8% | 145% | 0.00% |
TZOO | 141 | 9.75 | 135 | 8% | 135% | 0.00% |
SNI | 142 | 68.47 | 8,910 | 9% | 81% | 1.46% |
DPS | 143 | 82.38 | 15,298 | 8% | 127% | 2.57% |
EXPR | 144 | 13.35 | 1,054 | 19% | 41% | 0.00% |
JAZZ | 145 | 113.11 | 6,973 | 7% | 276% | 0.00% |
BBBY | 146 | 43.90 | 6,608 | 17% | 41% | 1.14% |
WYN | 147 | 69.47 | 7,642 | 9% | 83% | 2.94% |
MHFI | 148 | 107.92 | 28,631 | 7% | 835% | 1.40% |
INFY | 149 | 14.51 | 33,169 | 9% | 75% | 2.59% |
LCI | 150 | 23.40 | 859 | 13% | 44% | 0.00% |
MCO | 151 | 100.44 | 19,515 | 7% | 440% | 1.47% |
IQNT | 152 | 22.95 | 794 | 9% | 80% | 2.79% |
FRAN | 153 | 17.14 | 664 | 10% | 59% | 0.00% |
Q | 154 | 77.13 | 9,345 | 7% | 401% | 0.00% |
CLRO | 155 | 11.00 | 103 | 11% | 52% | 1.82% |
SWKS | 156 | 74.51 | 14,067 | 9% | 75% | 1.44% |
THO | 157 | 82.57 | 4,348 | 9% | 75% | 1.69% |
HSNI | 158 | 37.90 | 2,003 | 10% | 52% | 3.69% |
TBI | 159 | 20.05 | 843 | 11% | 46% | 0.00% |
YY | 160 | 44.24 | 2,688 | 7% | 153% | 0.00% |
BOJA | 161 | 17.55 | 661 | 8% | 125% | 0.00% |
BC | 162 | 47.34 | 4,351 | 10% | 49% | 1.39% |
APOL | 163 | 9.42 | 1,039 | 17% | 37% | 0.00% |
EXPD | 164 | 50.66 | 9,255 | 8% | 82% | 1.58% |
CHE | 165 | 147.13 | 2,436 | 7% | 154% | 0.71% |
SHI | 166 | 51.11 | 5,523 | 17% | 37% | 2.98% |
CTSH | 167 | 53.95 | 32,829 | 8% | 93% | 0.00% |
GMED | 168 | 21.45 | 2,070 | 9% | 59% | 0.00% |
MTOR | 169 | 11.76 | 1,082 | 11% | 45% | 0.00% |
CO | 170 | 5.03 | 367 | 33% | 35% | 0.00% |
MAS | 171 | 31.27 | 10,288 | 9% | 72% | 1.28% |
BAH | 172 | 34.32 | 5,155 | 7% | 172% | 1.75% |
AEO | 173 | 18.29 | 3,355 | 11% | 43% | 2.73% |
GD | 174 | 168.55 | 52,205 | 8% | 93% | 1.80% |
KNL | 175 | 24.26 | 1,185 | 10% | 51% | 2.47% |
MO | 176 | 61.76 | 120,556 | 7% | 450% | 3.95% |
KBAL | 177 | 13.95 | 530 | 10% | 53% | 1.72% |
DGX | 178 | 81.46 | 11,567 | 8% | 100% | 2.21% |
BLD | 179 | 35.05 | 1,330 | 9% | 64% | 0.00% |
GPP | 180 | 18.60 | 591 | 8% | 102% | 9.03% |
STS | 181 | 13.45 | 232 | 15% | 36% | 1.15% |
CIGI | 182 | 35.40 | 1,379 | 7% | 181% | 0.28% |
QCOM | 183 | 66.88 | 99,718 | 7% | 272% | 3.17% |
HIBB | 184 | 43.75 | 982 | 12% | 39% | 0.00% |
SQBG | 185 | 5.31 | 335 | 7% | 187% | 0.00% |
STRZA | 186 | 33.56 | 3,356 | 8% | 70% | 0.00% |
UTMD | 187 | 65.00 | 246 | 8% | 93% | 1.70% |
ALGT | 188 | 156.65 | 2,570 | 12% | 37% | 1.79% |
PLUS | 189 | 104.00 | 722 | 11% | 40% | 0.00% |
SERV | 190 | 36.20 | 4,963 | 7% | 253% | 0.00% |
DAL | 191 | 46.38 | 34,507 | 19% | 32% | 1.75% |
DV | 192 | 27.85 | 1,780 | 11% | 40% | 1.29% |
DST | 193 | 99.97 | 3,299 | 8% | 90% | 1.32% |
MSI | 194 | 80.38 | 13,632 | 7% | 152% | 2.34% |
UTX | 195 | 108.86 | 90,463 | 8% | 80% | 2.52% |
SBH | 196 | 28.46 | 4,207 | 9% | 57% | 0.00% |
MMS | 197 | 52.02 | 3,449 | 8% | 79% | 0.35% |
JCOM | 198 | 72.55 | 3,446 | 6% | 395% | 1.96% |
CHRW | 199 | 73.58 | 10,513 | 7% | 95% | 2.34% |
COH | 200 | 36.99 | 10,427 | 8% | 72% | 3.65% |
No comments:
Post a Comment