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