Since I have to get 5 new stocks by Monday, I thought a top 200 list was in order. Last time I ran it BPT did not get in. That was because my formula had their invested capital at 0, which caused it to error out. Then LIFZF also was missing as they were not even in my list of ticker symbols I pulled from Gurufocus.
Now everything looks quite good. Though you should always do your own diligence on these stocks as I am just a guy with a spreadsheet.
Ticker | Rank | Stock Price | Market Cap | Earnings Yield | ROIC | Dividend Yield |
PDLI | 1 | 3.21 | 526 | 73% | 1409% | 18.69% |
BPT | 2 | 23.12 | 495 | 31% | 153795% | 10.41% |
WILN | 3 | 1.02 | 123 | 28% | 1134% | 25.24% |
MNDO | 4 | 2.40 | 46 | 23% | 1270% | 12.50% |
AGX | 5 | 29.42 | 443 | 23% | 1132% | 2.38% |
CALL | 6 | 7.80 | 130 | 26% | 655% | 0.00% |
NHTC | 7 | 19.69 | 242 | 20% | 4368% | 1.02% |
RPXC | 8 | 10.69 | 595 | 20% | 1510% | 0.00% |
NLNK | 9 | 27.12 | 779 | 22% | 823% | 0.00% |
ENTA | 10 | 29.24 | 565 | 29% | 480% | 0.00% |
PERI | 11 | 2.38 | 170 | 55% | 371% | 0.00% |
LND | 12 | 2.52 | 147 | 57% | 288% | 14.48% |
LIFZF | 13 | 5.95 | 381 | 17% | 953% | 12.91% |
HNR | 14 | 0.67 | 30 | 516% | 202% | 0.00% |
TSRA | 15 | 27.50 | 1,444 | 16% | 744% | 2.91% |
IRS | 16 | 9.48 | 548 | 15% | 585% | 1.02% |
GILD | 17 | 91.83 | 138,020 | 15% | 609% | 1.87% |
KING | 18 | 17.91 | 5,678 | 15% | 478% | 0.00% |
BSQR | 19 | 5.51 | 69 | 16% | 294% | 0.00% |
IDCC | 20 | 42.94 | 1,555 | 16% | 294% | 1.86% |
TIVO | 21 | 7.70 | 733 | 14% | 555% | 0.00% |
SGU | 22 | 7.66 | 439 | 22% | 163% | 4.96% |
NSR | 23 | 21.68 | 1,195 | 20% | 187% | 0.00% |
MMI | 24 | 24.30 | 952 | 13% | 1109% | 0.00% |
GME | 25 | 25.67 | 2,724 | 23% | 138% | 5.61% |
CYOU | 26 | 18.38 | 963 | 59% | 112% | 0.00% |
CSCO | 27 | 23.37 | 119,491 | 13% | 354% | 3.59% |
CPLA | 28 | 43.33 | 530 | 16% | 185% | 3.60% |
VEC | 29 | 19.26 | 209 | 14% | 247% | 0.00% |
VIAB | 30 | 43.21 | 17,280 | 13% | 328% | 3.70% |
CBI | 31 | 34.16 | 3,602 | 17% | 164% | 0.82% |
MCFT | 32 | 12.05 | 196 | 14% | 210% | 0.00% |
VIA | 33 | 45.90 | 18,355 | 13% | 328% | 3.49% |
VDSI | 34 | 15.03 | 597 | 14% | 221% | 0.00% |
SJT | 35 | 4.60 | 214 | 12% | 438% | 7.18% |
NSH | 36 | 14.85 | 637 | 11% | 1886% | 14.68% |
HLF | 37 | 46.21 | 3,960 | 14% | 203% | 0.00% |
GSK | 38 | 40.03 | 97,613 | 18% | 126% | 5.49% |
CALM | 39 | 48.63 | 2,352 | 27% | 97% | 6.18% |
BPI | 40 | 7.18 | 329 | 23% | 96% | 0.00% |
DRYS | 41 | 0.15 | 100 | 100% | 85% | 0.00% |
GPRO | 42 | 10.83 | 2,079 | 17% | 123% | 0.00% |
DLX | 43 | 52.27 | 2,601 | 12% | 435% | 2.30% |
MSGN | 44 | 18.27 | 1,387 | 11% | 561% | 0.00% |
CTCM | 45 | 1.86 | 290 | 33% | 87% | 37.63% |
OUTR | 46 | 31.35 | 540 | 23% | 93% | 3.83% |
BRCD | 47 | 7.78 | 3,286 | 18% | 113% | 2.31% |
LCI | 48 | 36.40 | 1,362 | 20% | 98% | 0.00% |
TNH | 49 | 97.77 | 1,809 | 19% | 105% | 11.50% |
ESI | 50 | 2.88 | 69 | 42% | 81% | 0.00% |
UNTD | 51 | 10.43 | 154 | 20% | 93% | 0.00% |
AAPL | 52 | 101.42 | 576,321 | 11% | 317% | 2.05% |
MLP | 53 | 5.15 | 97 | 21% | 87% | 0.00% |
GHC | 54 | 458.00 | 2,628 | 15% | 132% | 0.00% |
WLDN | 55 | 8.37 | 68 | 16% | 109% | 0.00% |
HPQ | 56 | 9.80 | 17,846 | 29% | 76% | 5.06% |
IQNT | 57 | 15.60 | 533 | 15% | 115% | 3.85% |
CLCT | 58 | 15.29 | 130 | 11% | 555% | 9.16% |
LEJU | 59 | 4.60 | 622 | 18% | 91% | 17.39% |
BKE | 60 | 27.85 | 1,343 | 20% | 82% | 3.59% |
MIXT | 61 | 3.79 | 121 | 22% | 75% | 4.82% |
TDC | 62 | 23.37 | 3,305 | 11% | 228% | 0.00% |
UTHR | 63 | 129.44 | 6,503 | 12% | 152% | 0.00% |
FLR | 64 | 42.89 | 6,266 | 19% | 77% | 1.96% |
KORS | 65 | 38.41 | 7,356 | 17% | 79% | 0.00% |
PPC | 66 | 21.66 | 5,621 | 20% | 70% | 0.00% |
UEPS | 67 | 10.24 | 478 | 30% | 63% | 0.00% |
HF | 68 | 27.12 | 1,046 | 11% | 225% | 0.00% |
IILG | 69 | 12.59 | 731 | 12% | 149% | 3.81% |
BBSI | 70 | 38.81 | 286 | 11% | 162% | 2.27% |
QCOM | 71 | 48.07 | 75,614 | 10% | 285% | 3.99% |
PNTR | 72 | 5.54 | 44 | 16% | 75% | 0.00% |
PBI | 73 | 18.73 | 3,765 | 12% | 141% | 4.00% |
AMAG | 74 | 24.12 | 801 | 10% | 448% | 0.00% |
SCMP | 75 | 13.66 | 633 | 10% | 631% | 0.00% |
BBY | 76 | 27.27 | 9,517 | 20% | 60% | 3.37% |
STRA | 77 | 56.55 | 607 | 13% | 90% | 0.00% |
CRT | 78 | 13.19 | 79 | 12% | 95% | 15.35% |
GSB | 79 | 3.77 | 81 | 9% | 1283% | 1.59% |
DEPO | 80 | 16.66 | 1,005 | 9% | 999% | 0.00% |
PII | 81 | 81.95 | 5,521 | 12% | 91% | 2.59% |
MGIC | 82 | 5.52 | 245 | 13% | 83% | 3.44% |
VNCE | 83 | 4.57 | 168 | 14% | 72% | 0.00% |
CA | 84 | 26.73 | 11,681 | 9% | 472% | 3.74% |
APOL | 85 | 7.76 | 842 | 41% | 50% | 0.00% |
BLBD | 86 | 9.76 | 249 | 10% | 172% | 0.00% |
LYB | 87 | 78.49 | 36,341 | 17% | 58% | 3.98% |
APEI | 88 | 16.31 | 272 | 29% | 50% | 0.00% |
BCOR | 89 | 8.63 | 353 | 11% | 123% | 0.00% |
SCSS | 90 | 19.47 | 1,007 | 14% | 69% | 0.00% |
WSTG | 91 | 18.87 | 88 | 13% | 74% | 3.60% |
KFY | 92 | 30.02 | 1,512 | 11% | 110% | 1.33% |
UG | 93 | 19.95 | 92 | 10% | 210% | 5.01% |
FFIV | 94 | 93.77 | 6,552 | 9% | 552% | 0.00% |
NTI | 95 | 25.32 | 2,353 | 15% | 62% | 16.43% |
ORCL | 96 | 34.80 | 150,197 | 9% | 345% | 1.72% |
NUS | 97 | 31.78 | 1,864 | 17% | 54% | 4.41% |
WDC | 98 | 44.75 | 10,472 | 22% | 50% | 4.47% |
ICON | 99 | 5.76 | 278 | 10% | 153% | 0.00% |
SPOK | 100 | 16.78 | 358 | 10% | 167% | 2.98% |
SRDX | 101 | 18.72 | 247 | 11% | 103% | 0.00% |
WNC | 102 | 10.61 | 722 | 19% | 52% | 0.00% |
LEE | 103 | 1.51 | 82 | 13% | 69% | 0.00% |
ALDW | 104 | 19.04 | 1,190 | 16% | 56% | 20.59% |
GHM | 105 | 16.09 | 162 | 20% | 51% | 1.99% |
TARO | 106 | 148.33 | 6,354 | 11% | 110% | 0.00% |
ITRN | 107 | 17.23 | 361 | 12% | 79% | 3.48% |
STRZA | 108 | 30.72 | 3,293 | 11% | 95% | 0.00% |
VA | 109 | 31.14 | 1,388 | 14% | 64% | 0.00% |
AMBA | 110 | 38.21 | 1,295 | 9% | 310% | 0.00% |
PETS | 111 | 18.70 | 379 | 10% | 154% | 3.85% |
ZAGG | 112 | 9.14 | 264 | 15% | 55% | 0.00% |
CHKE | 113 | 14.29 | 127 | 10% | 181% | 1.40% |
RECN | 114 | 14.80 | 560 | 12% | 76% | 2.70% |
ITT | 115 | 31.00 | 2,799 | 18% | 50% | 1.53% |
GD | 116 | 126.37 | 40,683 | 10% | 125% | 2.18% |
GIB | 117 | 38.75 | 12,345 | 9% | 340% | 0.00% |
GRMN | 118 | 33.84 | 6,457 | 11% | 87% | 6.03% |
DISCK | 119 | 26.43 | 17,259 | 9% | 248% | 0.00% |
TGNA | 120 | 23.42 | 5,388 | 10% | 134% | 2.39% |
GNTX | 121 | 13.64 | 4,029 | 12% | 69% | 2.49% |
THO | 122 | 50.77 | 2,668 | 13% | 62% | 2.36% |
MDP | 123 | 37.81 | 1,715 | 10% | 114% | 4.84% |
GPS | 124 | 23.66 | 9,653 | 17% | 47% | 3.89% |
PARR | 125 | 23.94 | 895 | 13% | 59% | 0.00% |
CR | 126 | 44.80 | 2,634 | 12% | 61% | 2.95% |
BBBY | 127 | 43.69 | 7,147 | 18% | 45% | 0.00% |
USNA | 128 | 125.35 | 1,669 | 9% | 177% | 0.00% |
MED | 129 | 29.21 | 351 | 10% | 100% | 3.42% |
WSTC | 130 | 18.54 | 1,573 | 10% | 117% | 4.85% |
ROK | 131 | 91.58 | 12,299 | 10% | 97% | 3.17% |
DISCA | 132 | 26.90 | 17,566 | 9% | 248% | 0.00% |
MLHR | 133 | 25.36 | 1,532 | 11% | 70% | 2.33% |
RMAX | 134 | 32.30 | 401 | 8% | 1644% | 1.55% |
FSS | 135 | 14.21 | 899 | 13% | 58% | 1.97% |
TIME | 136 | 13.80 | 1,518 | 11% | 72% | 5.51% |
SCLN | 137 | 8.17 | 426 | 10% | 127% | 0.00% |
NCIT | 138 | 12.99 | 178 | 11% | 88% | 0.00% |
SAVE | 139 | 43.40 | 3,120 | 15% | 49% | 0.00% |
ASPS | 140 | 28.13 | 574 | 12% | 64% | 0.00% |
RHI | 141 | 43.46 | 5,758 | 10% | 92% | 1.84% |
PDFS | 142 | 9.92 | 318 | 12% | 63% | 0.00% |
EMR | 143 | 43.17 | 28,410 | 11% | 68% | 4.40% |
MSTR | 144 | 149.91 | 1,737 | 9% | 181% | 0.00% |
MENT | 145 | 17.44 | 2,095 | 12% | 64% | 1.26% |
STV | 146 | 1.54 | 93 | 51% | 38% | 0.00% |
MAN | 147 | 73.94 | 5,693 | 12% | 61% | 2.16% |
GNC | 148 | 27.23 | 2,286 | 12% | 60% | 2.64% |
BBX | 149 | 13.47 | 227 | 32% | 38% | 0.00% |
MKSI | 150 | 33.99 | 1,821 | 12% | 59% | 2.00% |
MTOR | 151 | 6.96 | 662 | 14% | 50% | 0.00% |
MBUU | 152 | 13.20 | 237 | 9% | 129% | 0.00% |
CRWN | 153 | 4.54 | 1,633 | 10% | 99% | 0.00% |
MEI | 154 | 25.63 | 1,002 | 14% | 49% | 1.40% |
IOSP | 155 | 47.27 | 1,163 | 11% | 65% | 1.31% |
ONE | 156 | 3.23 | 154 | 12% | 59% | 0.00% |
ENR | 157 | 31.82 | 1,998 | 11% | 67% | 3.14% |
ANIP | 158 | 35.46 | 410 | 10% | 92% | 0.00% |
TUP | 159 | 49.89 | 2,509 | 11% | 75% | 5.45% |
CLRO | 160 | 11.30 | 109 | 13% | 52% | 1.77% |
HIBB | 161 | 30.19 | 718 | 17% | 42% | 0.00% |
AVP | 162 | 2.59 | 1,128 | 17% | 42% | 9.27% |
WNR | 163 | 32.98 | 3,131 | 24% | 37% | 4.61% |
TEO | 164 | 14.96 | 2,900 | 20% | 39% | 6.21% |
SAFM | 165 | 77.54 | 1,710 | 22% | 37% | 1.13% |
HOLI | 166 | 17.36 | 1,053 | 15% | 44% | 0.00% |
EVOL | 167 | 5.11 | 61 | 9% | 108% | 8.61% |
DNB | 168 | 96.93 | 3,528 | 8% | 1731% | 1.91% |
GBX | 169 | 23.73 | 773 | 37% | 35% | 3.37% |
PCOM | 170 | 7.60 | 118 | 8% | 549% | 0.00% |
OMC | 171 | 70.61 | 17,257 | 8% | 261% | 2.83% |
TWX | 172 | 70.89 | 58,420 | 9% | 137% | 1.97% |
KAI | 173 | 34.96 | 388 | 13% | 48% | 1.95% |
NTAP | 174 | 21.51 | 6,367 | 12% | 52% | 3.35% |
PLOW | 175 | 18.07 | 404 | 14% | 46% | 4.93% |
UBNT | 176 | 29.99 | 2,653 | 8% | 209% | 0.57% |
GORO | 177 | 1.30 | 70 | 33% | 34% | 1.54% |
FOSL | 178 | 30.69 | 1,481 | 22% | 37% | 0.00% |
SALE | 179 | 9.00 | 484 | 12% | 56% | 0.00% |
CATO | 180 | 38.06 | 1,042 | 12% | 55% | 3.15% |
ATTO | 181 | 9.20 | 678 | 15% | 43% | 0.00% |
NVEC | 182 | 51.60 | 250 | 8% | 292% | 7.75% |
EME | 183 | 44.41 | 2,815 | 10% | 71% | 0.72% |
SYMC | 184 | 19.47 | 13,376 | 9% | 105% | 3.08% |
LEA | 185 | 101.45 | 7,854 | 13% | 48% | 0.99% |
EFOI | 186 | 10.67 | 114 | 10% | 86% | 0.00% |
LECO | 187 | 46.97 | 3,464 | 11% | 56% | 2.73% |
CTS | 188 | 15.00 | 492 | 11% | 55% | 1.07% |
LRCX | 189 | 68.72 | 11,983 | 10% | 67% | 1.75% |
CO | 190 | 6.14 | 448 | 18% | 37% | 0.00% |
HI | 191 | 26.31 | 1,679 | 10% | 67% | 3.08% |
SYNT | 192 | 47.70 | 4,013 | 9% | 125% | 0.00% |
MCO | 193 | 88.42 | 17,905 | 8% | 482% | 1.67% |
CBD | 194 | 8.36 | 1,379 | 34% | 32% | 1.88% |
TPL | 195 | 126.45 | 1,036 | 7% | 1677% | 0.23% |
SPLP | 196 | 12.86 | 350 | 46% | 32% | 0.00% |
PLCM | 197 | 10.60 | 1,439 | 9% | 94% | 0.00% |
AFOP | 198 | 13.84 | 252 | 10% | 72% | 1.08% |
EROS | 199 | 8.40 | 506 | 13% | 45% | 0.00% |
ETM | 200 | 9.68 | 377 | 10% | 80% | 0.00% |
There are some interesting stocks in here.
MMI (real estate) and NSH (pipeline MLP). HNR looks like a red herring - their income is negative, but I show their minority income is more negative. This does show that my list should only be a starting point.
Here are the official top 50 stocks > $100m and where they stand on my list.
Ticker | Mkt Cap | Date | My Ranking | Price | EY | ROIC |
AAPL | 565,797 | 22-Jan | 52 | 101.42 | 11% | 317% |
AGX | 436 | 22-Jan | 5 | 29.42 | 23% | 1132% |
BBSI | 278 | 22-Jan | 70 | 38.81 | 11% | 162% |
BBY | 9,404 | 22-Jan | 76 | 27.27 | 20% | 60% |
BLBD | 204 | 22-Jan | 86 | 9.76 | 10% | 172% |
BPT | 495 | 22-Jan | 2 | 23.12 | 31% | 153795% |
BRCD | 3,220 | 22-Jan | 47 | 7.78 | 18% | 113% |
BKE | 1,351 | 22-Jan | 60 | 27.85 | 20% | 82% |
CALM | 2,358 | 22-Jan | 39 | 48.63 | 27% | 97% |
CPLA | 519 | 22-Jan | 28 | 43.33 | 16% | 185% |
CSCO | 118,766 | 22-Jan | 27 | 23.37 | 13% | 354% |
CLCT | 136 | 22-Jan | 58 | 15.29 | 11% | 555% |
DLX | 2,573 | 22-Jan | 43 | 52.27 | 12% | 435% |
ENTA | 547 | 22-Jan | 10 | 29.24 | 29% | 480% |
FLR | 6,100 | 22-Jan | 64 | 42.89 | 19% | 77% |
GME | 2,693 | 22-Jan | 25 | 25.67 | 23% | 138% |
GILD | 133,062 | 22-Jan | 17 | 91.83 | 15% | 609% |
GPRO | 1,646 | 22-Jan | 42 | 10.83 | 17% | 123% |
GHC | 2,676 | 22-Jan | 54 | 458.00 | 15% | 132% |
ONE | 155 | 22-Jan | 156 | 3.23 | 12% | 59% |
HPQ | 17,679 | 22-Jan | 56 | 9.80 | 29% | 76% |
IQNT | 526 | 22-Jan | 57 | 15.60 | 15% | 115% |
IDCC | 1,527 | 22-Jan | 20 | 42.94 | 16% | 294% |
IILG | 724 | 22-Jan | 69 | 12.59 | 12% | 149% |
KING | 5,650 | 22-Jan | 18 | 17.91 | 15% | 478% |
LIFZF | 383 | 22-Jan | 13 | 5.95 | 17% | 953% |
LCI | 1,324 | 22-Jan | 48 | 36.40 | 20% | 98% |
MCFT | 217 | 22-Jan | 32 | 12.05 | 14% | 210% |
KORS | 7,199 | 22-Jan | 65 | 38.41 | 17% | 79% |
MSGN | 1,365 | 22-Jan | 44 | 18.27 | 11% | 561% |
NHTC | 241 | 22-Jan | 7 | 19.69 | 20% | 4368% |
NSR | 1,157 | 22-Jan | 23 | 21.68 | 20% | 187% |
NLNK | 884 | 22-Jan | 9 | 27.12 | 22% | 823% |
OUTR | 541 | 22-Jan | 46 | 31.35 | 23% | 93% |
PDLI | 525 | 22-Jan | 1 | 3.21 | 73% | 1409% |
PPC | 5,616 | 22-Jan | 66 | 21.66 | 20% | 70% |
PBI | 3,709 | 22-Jan | 73 | 18.73 | 12% | 141% |
PII | 5,373 | 22-Jan | 81 | 81.95 | 12% | 91% |
QCOM | 73,259 | 22-Jan | 71 | 48.07 | 10% | 285% |
RPXC | 603 | 22-Jan | 8 | 10.69 | 20% | 1510% |
STRA | 624 | 22-Jan | 77 | 56.55 | 13% | 90% |
SCMP | 619 | 22-Jan | 75 | 13.66 | 10% | 631% |
TDC | 3,129 | 22-Jan | 62 | 23.37 | 11% | 228% |
TIVO | 754 | 22-Jan | 21 | 7.70 | 14% | 555% |
UNTD | 154 | 22-Jan | 51 | 10.43 | 20% | 93% |
UTHR | 6,213 | 22-Jan | 63 | 129.44 | 12% | 152% |
VDSI | 598 | 22-Jan | 34 | 15.03 | 14% | 221% |
VEC | 203 | 22-Jan | 29 | 19.26 | 14% | 247% |
VIAB | 17,202 | 22-Jan | 30 | 43.21 | 13% | 328% |
VNCE | 168 | 22-Jan | 83 | 4.57 | 14% | 72% |
5 comments:
It seems to me that BPT shouldn't be on the list. It is a royalty trust that would seem more like a financial company than a operating company. I know they have made the official list a few times over the years, but it just doesn't seem quite right. I'd also be concerned about NSH (pipeline MLP) since it may be highly regulated and not operate 'freely'.
j
I had to add BPT manually as gurufocus did have in the financial bucket (and I exclude Financial and Utility stocks).
Where do you get the compustat data? I've been trying to get it for a while myself.
Where do you get the compustat data? I've been trying to get it for a while myself.
I have a Fidelity account. All of Fidelity's research data on stocks is compustat.
Post a Comment