Top 200 List - February 1st 2013

Well, with my adding a tranche on Friday, I thought it might be fun to have a concurrent top 200 list.  As many of my readers know, I have an excel spreadsheet which allows me to calculate the Earnings Yield and Return on Capital as described in "The Little Book the Beats the Stock Market".  One can never knows for sure, but my spreadsheet comes pretty darned close to replicating the real deal.  I know this because (1) it was created back when the MFI website (Magic Formula Investing) gave more details (such as earnings yield and a range of ROIC and (2) I still try to match it back to the top 50 from the website each time I create my list.  I did not create the spreadsheet by myself, nor did I figure out the formulae myself.  I had great help from Randy Harmelink, Tony Brake and Kevin from the Yahoo groups website (Magic Formula Investing Yahoo Group). 

My list is superior (I believe) to the official list as:

1. I provide the key statistics
2. I provide country (the official list does exclude some based on country, but oddly not all)
3. I provide dividend yield, albeit the greatly flawed yield from Yahoo Finance.
4. I list 200 in a straight list.

Without any more rambling, bring on le list!

Ticker	Rank	Date	Stock Price	Market Cap	Earnings Yield	ROIC	Yahoo Yield	Country
IDCC	1	2/2	43.60	1,847	33%	6155%	4.4%	USA
PDLI	2	2/2	6.88	1,029	29%	1129093%	8.7%	USA
CYOU	3	2/2	31.30	1,672	21%	500%	12.3%	China
QCOR	4	2/2	26.40	1,621	16%	7060%	1.6%	USA
BPI	5	2/2	10.46	583	65%	228%	0.0%	USA
ESI	6	2/2	16.28	380	74%	171%	0.0%	USA
NTES	7	2/2	47.13	6,207	15%	459%	2.2%	China
GA	8	2/2	6.12	1,490	16%	346%	4.9%	China
UIS	9	2/2	23.17	1,189	32%	169%	0.0%	USA
GTAT	10	2/2	3.10	372	80%	151%	0.0%	USA
HLF	11	2/2	35.07	3,986	15%	315%	3.3%	Cayman Islands
LPS	12	2/2	24.16	2,052	14%	391%	1.7%	USA
TNAV	13	2/2	8.03	343	17%	199%	0.0%	USA
RPXC	14	2/2	10.41	543	13%	1552%	0.0%	USA
NTI	15	2/2	25.84	2,357	25%	155%	5.9%	USA
GDOT	16	2/2	13.60	565	19%	162%	0.0%	USA
CPLA	17	2/2	27.44	358	26%	138%	0.0%	USA
AAPL	18	2/2	453.62	429,677	14%	357%	1.2%	USA
USNA	19	2/2	34.68	516	20%	145%	0.0%	USA
WU	20	2/2	14.38	8,688	13%	742%	3.0%	USA
APOL	21	2/2	20.00	2,257	37%	127%	0.0%	USA
KLIC	22	2/2	11.65	888	45%	126%	0.0%	USA
RDA	23	2/2	11.71	561	13%	689%	10.2%	China
SPRD	24	2/2	16.19	849	15%	218%	2.6%	China
STX	25	2/2	33.67	12,761	25%	131%	4.5%	Ireland
MSFT	26	2/2	27.93	235,841	14%	297%	3.0%	USA
JCOM	27	2/2	31.87	1,445	12%	1134%	3.4%	USA
MANT	28	2/2	25.18	931	21%	121%	3.4%	USA
AZN	29	2/2	48.42	60,428	16%	150%	5.9%	United Kingdom
GME	30	2/2	24.69	3,032	21%	117%	3.5%	USA
DELL	31	2/2	13.63	23,743	14%	169%	1.2%	USA
SAVE	32	2/2	19.21	1,396	15%	142%	0.0%	USA
TNH	33	2/2	245.15	4,535	12%	516%	6.9%	USA
SPPI	34	2/2	12.50	814	12%	2912%	1.2%	USA
WCRX	35	2/2	14.05	3,521	12%	427%	30.0%	Ireland
VG	36	2/2	2.61	610	14%	166%	0.0%	USA
EGY	37	2/2	8.55	504	32%	97%	0.0%	USA
STRZA	38	2/2	16.16	1,988	45%	91%	0.0%	USA
CSCO	39	2/2	20.83	111,107	12%	314%	2.1%	USA
NOC	40	2/2	65.13	16,211	18%	108%	3.3%	USA
NSU	41	2/2	4.17	834	77%	88%	2.4%	Canada
RCII	42	2/2	36.22	2,129	12%	654%	1.9%	USA
NUS	43	2/2	41.80	2,594	13%	168%	1.9%	USA
STRA	44	2/2	57.27	658	18%	102%	7.0%	USA
RTN	45	2/2	52.67	17,423	13%	151%	3.8%	USA
CA	46	2/2	25.03	11,339	12%	407%	4.0%	USA
GTIV	47	2/2	10.03	305	14%	129%	0.0%	USA
LO	48	2/2	39.52	15,454	11%	668%	5.3%	USA
NVDA	49	2/2	12.37	7,779	15%	110%	0.6%	USA
PBI	50	2/2	13.82	2,786	14%	127%	10.4%	USA
BAH	51	2/2	13.84	2,008	13%	138%	60.3%	USA
SAI	52	2/2	12.18	4,068	17%	89%	4.0%	USA
CSGS	53	2/2	18.73	607	15%	105%	0.0%	USA
VCI	54	2/2	28.75	1,174	14%	112%	1.1%	USA
CRWN	55	2/2	1.90	683	12%	196%	0.0%	USA
VLO	56	2/2	44.85	24,937	17%	85%	1.5%	USA
CF	57	2/2	229.96	14,602	20%	77%	0.7%	USA
HPQ	58	2/2	16.46	32,327	19%	78%	3.1%	USA
GAME	59	2/2	3.04	843	35%	71%	0.0%	China
HFC	60	2/2	52.77	10,788	26%	74%	5.0%	USA
XLS	61	2/2	10.79	2,036	24%	74%	3.8%	USA
BLC	62	2/2	8.67	897	13%	112%	3.4%	USA
CACI	63	2/2	54.77	1,289	14%	93%	0.0%	USA
EBIX	64	2/2	16.33	639	10%	688%	0.9%	USA
CTCM	65	2/2	10.65	1,684	14%	101%	4.9%	Russia
COH	66	2/2	49.87	14,274	12%	166%	2.2%	USA
LLL	67	2/2	75.22	7,093	14%	96%	2.6%	USA
ATVI	68	2/2	11.65	12,978	10%	679%	1.6%	USA
SIMO	69	2/2	15.32	515	15%	80%	0.0%	Taiwan
EXPR	70	2/2	18.50	1,595	15%	79%	0.0%	USA
ALDW	71	2/2	23.54	1,471	17%	68%	0.0%	USA
DNB	72	2/2	82.71	3,738	10%	1240%	1.9%	USA
HRB	73	2/2	22.86	6,198	10%	265%	3.5%	USA
WDC	74	2/2	46.77	11,505	27%	61%	1.1%	USA
PWRD	75	2/2	11.93	580	37%	59%	17.0%	China
SOHU	76	2/2	49.22	1,887	13%	99%	0.0%	China
UTHR	77	2/2	53.79	2,883	14%	83%	0.0%	USA
BKE	78	2/2	47.03	2,243	12%	104%	11.3%	USA
TZOO	79	2/2	21.36	334	10%	660%	0.0%	USA
SWHC	80	2/2	8.76	589	16%	64%	0.0%	USA
WNR	81	2/2	35.00	3,155	25%	57%	5.4%	USA
CJES	82	2/2	22.89	1,240	22%	57%	0.0%	USA
LMT	83	2/2	87.22	28,608	13%	89%	4.8%	USA
AVG	84	2/2	13.14	719	9%	670%	0.0%	Netherlands
ABC	85	2/2	46.53	10,981	10%	162%	1.3%	USA
ICON	86	2/2	24.19	1,706	10%	298%	0.0%	USA
MYGN	87	2/2	27.16	2,279	10%	351%	0.0%	USA
KLAC	88	2/2	55.76	9,428	12%	88%	2.7%	USA
SCSS	89	2/2	22.66	1,286	10%	158%	0.0%	USA
HRS	90	2/2	46.28	5,225	14%	66%	3.0%	USA
CATO	91	2/2	27.40	790	18%	56%	10.8%	USA
WTW	92	2/2	53.25	2,988	9%	808%	1.3%	USA
CHE	93	2/2	75.76	1,470	10%	178%	0.9%	USA
MDP	94	2/2	36.34	1,633	11%	115%	4.2%	USA
DGX	95	2/2	58.11	9,303	11%	133%	1.4%	USA
VGR	96	2/2	15.37	1,314	10%	270%	10.2%	USA
JOY	97	2/2	64.15	6,861	15%	60%	1.1%	USA
TARO	98	2/2	48.76	2,180	13%	70%	0.0%	Israel
DLB	99	2/2	32.39	3,353	11%	107%	12.4%	USA
OFIX	100	2/2	38.42	750	16%	57%	0.0%	Netherlands Antilles
DHX	101	2/2	9.57	589	9%	528%	0.0%	USA
VDSI	102	2/2	8.15	316	12%	84%	0.0%	USA
ENDP	103	2/2	31.33	3,746	11%	126%	0.0%	USA
VIAB	104	2/2	60.54	30,821	9%	282%	0.4%	USA
RGR	105	2/2	51.41	1,016	11%	124%	2.6%	USA
CVI	106	2/2	53.58	4,652	21%	51%	10.3%	USA
TRLG	107	2/2	23.73	601	18%	53%	4.2%	USA
BR	108	2/2	23.58	2,997	10%	168%	2.9%	USA
KFY	109	2/2	17.26	826	11%	83%	0.0%	USA
CROX	110	2/2	15.00	1,363	15%	55%	0.0%	USA
BCOR	111	2/2	15.01	608	9%	747%	0.0%	USA
EGL	112	2/2	19.14	312	15%	53%	0.0%	USA
UBNT	113	2/2	13.95	1,296	9%	279%	1.4%	USA
GCI	114	2/2	19.84	4,673	14%	56%	4.1%	USA
TW	115	2/2	61.65	4,334	11%	88%	1.3%	USA
EXPO	116	2/2	48.14	684	10%	101%	0.0%	USA
STAN	117	2/2	21.32	340	9%	229%	0.0%	USA
RAI	118	2/2	44.47	25,099	9%	255%	5.3%	USA
APEI	119	2/2	38.23	686	11%	85%	0.0%	USA
FMCN	120	2/2	25.50	3,405	10%	114%	1.6%	Hong Kong
MHP	121	2/2	58.34	16,604	9%	325%	1.8%	USA
SYNT	122	2/2	58.41	2,442	10%	105%	4.3%	USA
GRMN	123	2/2	38.50	7,552	10%	95%	4.6%	Cayman Islands
CSTR	124	2/2	49.57	1,598	15%	52%	0.0%	USA
LXK	125	2/2	23.69	1,549	27%	44%	4.8%	USA
TEO	126	2/2	15.92	3,134	27%	44%	5.9%	Argentina
DV	127	2/2	25.62	1,668	17%	48%	1.3%	USA
MD	128	2/2	86.14	4,316	9%	516%	0.0%	USA
FIZZ	129	2/2	13.81	642	12%	67%	18.5%	USA
REV	130	2/2	15.74	824	10%	106%	0.0%	USA
CUB	131	2/2	47.84	1,279	13%	57%	0.5%	USA
CBPO	132	2/2	19.40	524	13%	58%	0.0%	China
STO	133	2/2	27.00	85,894	37%	42%	4.2%	Norway
QLGC	134	2/2	11.37	1,053	14%	53%	0.0%	USA
LH	135	2/2	90.47	8,757	10%	111%	0.0%	USA
INTC	136	2/2	21.36	108,804	14%	51%	3.1%	USA
TVL	137	2/2	11.23	610	11%	70%	0.0%	USA
CAH	138	2/2	43.88	15,095	12%	64%	2.2%	USA
IRBT	139	2/2	23.13	655	11%	75%	0.0%	USA
IOSP	140	2/2	40.64	972	11%	68%	5.0%	United Kingdom
KRO	141	2/2	19.28	2,235	20%	43%	3.1%	USA
ETM	142	2/2	8.12	305	10%	90%	0.0%	USA
QSII	143	2/2	18.44	1,095	10%	108%	3.8%	USA
SPLS	144	2/2	13.51	9,011	16%	46%	3.3%	USA
TRW	145	2/2	58.65	7,583	14%	49%	0.0%	USA
FLR	146	2/2	65.83	11,057	10%	90%	1.0%	USA
SJT	147	2/2	16.41	765	9%	565%	3.8%	USA
NTE	148	2/2	13.11	599	18%	44%	2.8%	China
GMED	149	2/2	12.90	1,166	11%	67%	0.0%	USA
GD	150	2/2	65.88	23,117	12%	65%	3.1%	USA
ICFI	151	2/2	23.07	456	12%	62%	0.0%	USA
EDMC	152	2/2	3.98	497	16%	45%	0.0%	USA
BBBY	153	2/2	59.22	13,423	13%	55%	0.0%	USA
NCMI	154	2/2	15.46	853	9%	277%	5.8%	USA
NTGR	155	2/2	36.00	1,397	13%	54%	0.0%	USA
NSP	156	2/2	34.07	851	10%	78%	2.0%	USA
ORCL	157	2/2	36.21	176,246	9%	457%	1.0%	USA
TER	158	2/2	16.64	3,124	11%	63%	0.0%	USA
MTSC	159	2/2	56.15	908	11%	70%	1.9%	USA
CR	160	2/2	50.90	2,941	11%	62%	2.2%	USA
UNTD	161	2/2	6.59	598	9%	134%	6.0%	USA
CBST	162	2/2	44.02	3,611	9%	151%	0.0%	USA
KAI	163	2/2	27.41	315	14%	46%	0.0%	USA
NDZ	164	2/2	7.08	439	13%	49%	2.8%	Canada
BA	165	2/2	74.87	57,523	11%	62%	2.4%	USA
IPG	166	2/2	12.25	5,587	9%	137%	2.0%	USA
RECN	167	2/2	12.19	504	11%	62%	1.8%	USA
MO	168	2/2	34.20	68,845	9%	133%	5.1%	USA
EME	169	2/2	36.63	2,473	11%	66%	1.3%	USA
LEA	170	2/2	49.60	4,856	17%	41%	1.1%	USA
SEM	171	2/2	9.69	1,336	12%	54%	15.4%	USA
GNTX	172	2/2	19.39	2,765	10%	68%	2.7%	USA
VCLK	173	2/2	20.32	1,555	9%	202%	0.0%	USA
PWER	174	2/2	3.88	467	46%	36%	0.0%	USA
FWLT	175	2/2	26.49	2,843	10%	72%	0.0%	Switzerland
OMC	176	2/2	54.53	14,641	9%	232%	2.2%	USA
CMTL	177	2/2	26.43	620	11%	58%	4.2%	USA
SBR	178	2/2	46.45	677	8%	119676%	7.7%	USA
DLPH	179	2/2	39.22	12,601	13%	49%	0.0%	United Kingdom
ACAT	180	2/2	36.21	495	15%	41%	0.0%	USA
ALV	181	2/2	66.46	6,367	13%	45%	2.9%	Sweden
GPS	182	2/2	32.97	16,089	11%	57%	1.5%	USA
CHKP	183	2/2	50.98	10,413	8%	2019%	0.0%	Israel
ROST	184	2/2	59.43	13,204	9%	87%	0.9%	USA
DOX	185	2/2	35.72	5,843	9%	109%	0.7%	Channel Islands
GPN	186	2/2	49.25	3,898	9%	113%	0.2%	USA
AMED	187	2/2	11.35	345	15%	39%	0.0%	USA
SWK	188	2/2	77.37	12,731	10%	83%	2.3%	USA
LUK	189	2/2	25.30	6,297	11%	56%	1.0%	USA
VIV	190	2/2	25.41	18,852	16%	38%	6.9%	Brazil
JOSB	191	2/2	40.93	1,147	18%	37%	0.0%	USA
GDI	192	2/2	70.43	3,467	11%	53%	0.3%	USA
EZPW	193	2/2	21.91	1,142	14%	40%	0.0%	USA
VECO	194	2/2	32.91	1,289	11%	52%	0.0%	USA
TWX	195	2/2	50.88	49,552	9%	109%	2.1%	USA
SBGI	196	2/2	13.97	1,136	10%	75%	10.1%	USA
IPXL	197	2/2	20.53	1,404	12%	51%	0.0%	USA
FCN	198	2/2	32.20	1,323	10%	58%	0.0%	USA
FICO	199	2/2	45.27	1,637	8%	253%	0.2%	USA
HHS	200	2/2	7.93	501	11%	53%	5.2%	USA

As a reminder, I get my tickers from FINVIZ, and I use tickers with market cap greater than $300m.  Users of the official site know you can go as low as $50m.  I use this list for my own purposes and find (at times) that the micro cap stocks are too lightly traded for even a small investor like me to buy without moving the price, so I generally am staying with over 300m.

Here is the matching to the top 50 over 300m from the official list. I suppose if I had a perfect match, they would all be in my top 50.  But since I add more countries (like AZN from the UK); that isn't going to happen. And then inexplicably, some stocks (such as BPI) do not show up on official list.  I frankly think they are at error as any superficial analysis will show that BPI is a very cheap stock.

Ticker	Mkt Cap	Date	My Ranking
ATVI	12,956.63	1-Feb	68
APOL	2,250.78	1-Feb	21
AAPL	425,936.90	1-Feb	18
BLC	894.17	1-Feb	62
BAH	1,913.67	1-Feb	51
CA	11,282.65	1-Feb	46
CACI	1,251.71	1-Feb	63
CPLA	351.20	1-Feb	17
CF	14,457.13	1-Feb	57
CSCO	110,628.10	1-Feb	39
COH	14,097.90	1-Feb	66
CRWN	683.38	1-Feb	55
CSGS	631.41	1-Feb	53
DELL	23,634.42	1-Feb	31
EBIX	607.05	1-Feb	64
XLS	2,024.20	1-Feb	61
EXPR	1,581.92	1-Feb	70
GME	2,985.02	1-Feb	30
GTIV	306.58	1-Feb	47
GTAT	368.71	1-Feb	10
HLF	3,784.05	1-Feb	11
HPQ	32,237.91	1-Feb	58
HFC	10,741.12	1-Feb	60
IDCC	1,784.98	1-Feb	1
ESI	379.71	1-Feb	6
JCOM	1,435.84	1-Feb	27
LPS	2,046.35	1-Feb	12
LO	15,412.80	1-Feb	48
MANT	931.76	1-Feb	28
MSFT	233,885.80	1-Feb	26
NSU	828.95	1-Feb	41
NTI	475.02	1-Feb	15
NUS	2,457.84	1-Feb	43
PDLI	1,303.98	1-Feb	2
PBI	2,772.47	1-Feb	50
QCOR	1,543.11	1-Feb	4
RTN	17,275.76	1-Feb	45
RPXC	546.77	1-Feb	14
SAI	4,165.56	1-Feb	52
STX	12,037.19	1-Feb	25
SAVE	1,393.26	1-Feb	32
STRZA	2,055.55	1-Feb	38
STRA	679.97	1-Feb	44
TNAV	329.53	1-Feb	13
USNA	502.72	1-Feb	19
EGY	494.57	1-Feb	37
VCI	1,125.74	1-Feb	54
VG	581.87	1-Feb	36
WCRX	3,519.33	1-Feb	35
WDC	11,318.34	1-Feb	74

But we are very close, I think WDC at #74(on my list)  is the highest one. The keys to a good match are:

1. Getting Excess cash right.
2. using the same data (they use Compustat, which I can get from Fidelity)
3. Getting Market Cap right (I actually calc myself based on Share counts and price)
4. Adjusting for Minority stakes.

It is complex!  So you can see my tranche buys of AAPL, NUS, GA, CA and STRZA.

Hope everyone has a terrific Super Bowl Sunday.  I will just be rooting for an exciting game and that the scores match the ones I have in my Super Bowl Square.  Also want to give a shout out to my Hoosiers, who beat their third #1 team last night in past 2 years in what had to be the NCAA game of the year thus far.