Sunday, December 17, 2017

Liked This Quote From Barron's

Liked This Quote

Barron's had an article about DIS/FOX merger (https://www.barrons.com/articles/new-day-for-media-stocks-with-disney-fox-deal-1513395923).

In Who Gets Acquired Next Section:

"The Fox RSN business looks similar to MSG Networks (MSGN), a pure-play New York–based RSN that has exclusive local TV rights for the New York Rangers, Knicks, and others. MSG Networks was spun off in 2015 from the company that owns the Rangers and Knicks. With Fox’s RSNs now changing hands, spurring a new wave of RSN interest, 2018 could be the year that MSG gets sold. With the Disney deal, analysts at MoffettNathanson value the Fox RSNs at 10 times Ebitda. At a similar multiple, MSG carries an enterprise value of $3.3 billion, equating to $29 a share, 45% above its recent close."


That would make me very happy as I own a pretty decent sized chunk of MSGN.

Me Versus New Dividend Benchmark

Me Versus New Dividend Benchmark

As I mentioned yesterday, I have created a new dividend benchmark to use against my dividend portfolio.  The file I published yesterday had a couple typos, the key one being I added TCO twice (one of them should have been T - damn you excel auto fill).  I also had DUK twice.  So that should be fixed.

I rolled up my sleeves and figured out all the dividend index constituents for the 4th quarter to compare against my dividend portfolio.  Sadly I am under performing, I am down 72 basis points while the Index is up 1.3%.  But on the year I am up 13%,which is way better than Index, which is up a mere 7.7%.

Here is the new and improved Index


 Ticker   Start   Current   Dividend   Change   Yield 
 AMLP          11.22          10.76               0.21 -2.2%         7.99%
 NML            9.50             8.89               0.17 -4.6% 7.42%
 EPD          26.07          26.09               0.44 1.8% 6.39%
 ETP          18.29          17.50               0.59 -1.1% 13.45%
 FDD          13.64          13.59                    -   -0.4% 3.07%
 VGK          58.33          58.27                    -   -0.1% 2.74%
 DDAIF          79.68          83.40                    -   4.7% 4.16%
 NVS          85.85          84.86                    -   -1.2% 3.20%
 NOBL          59.45          63.73                    -   7.2% 1.83%
 VYM          81.07          86.10                    -   6.2% 2.82%
 MRK          64.03          56.24               0.54 -11.3% 3.36%
 PEP       111.43        119.22               0.77 7.7% 2.66%
 VNQ          83.09          85.12                    -   2.4% 4.64%
 RQI          12.56          12.55               0.16 1.2% 7.65%
 TCO          49.70          63.38               0.49 28.5% 3.94%
 SLG       101.32        103.23                    -   1.9% 3.00%
 T          39.17          38.24               0.49 -1.1% 5.13%
 VZ          49.49          52.67               0.59 7.6% 4.41%
 CHL          50.57          49.18                    -   -2.7% 3.74%
 DTEGY          18.66          17.72                    -   -5.1% 3.85%
 DSU          11.67          11.57               0.21 0.9% 1.78%
 HIO            5.13             5.02               0.06 -1.0% 6.99%
 MUB       110.87        110.75               0.63 0.5% 2.22%
 PRHYX            6.80             6.75               0.06 0.1% 5.40%
 NEA          13.85          13.72               0.18 0.4% 5.31%
 JNK          37.32          36.70               0.49 -0.3% 5.63%
 VWITX          14.19          14.14               0.06 0.1% 0.00%
 PHMIX            9.03             9.08               0.06 1.3% 2.80%
 UTG          31.70          31.30               0.48 0.3% 4.20%
 XLU          53.05          55.02                    -   3.7% 3.19%
 DUK          83.92          87.84               0.82 5.7% 3.97%
 EIX          77.17          69.71                    -   -9.7% 3.11%
 PFF          38.81          38.38               0.56 0.3% 5.77%
 JPC          10.57          10.38               0.20 0.0% 7.47%
 WFC-PL    1,315.00    1,330.40             18.75 2.6% 5.80%
 TIP       113.58        113.89               0.76 0.9% 2.59%
 SHY          84.45          83.95               0.23 -0.3% 0.95%
 TLT       124.76        128.35               0.77 3.5% 2.40%
 Totals                 -                    -                      -   1.3% 4.34%


Then here is my portfolio for the quarter:


 Dividend Stocks   Current   Divvy   Quaterly Gain   9/30/17 Price   Yield 
 OIBAX          5.92      0.04 0.2%           5.95 4.1%
 KCLI        45.60      0.27 -7.8%        49.75 2.4%
 KNOP        20.25      0.52 -3.1%        21.44 10.3%
 TK          9.14      0.06 3.0%           8.93 2.4%
 CPLP          3.36      0.08 -1.6%           3.50 9.5%
 JQC          8.16      0.15 -2.2%           8.49 7.0%
 ISBC        14.13      0.09 4.3%        13.64 2.5%
 EVG        14.00      0.16 -0.6%        14.24 6.6%
 LADR        13.72      0.31 1.8%        13.78 9.2%
 FDEU        18.76      0.57 -0.5%        19.42 7.7%
 NS        30.54      1.34 -21.5%        40.59 14.3%
 TGP        19.30      0.14 8.9%        17.85 2.9%
 RLJ-PA        27.40      0.49 0.2%        27.82 7.2%
 PSXP        49.87      0.66 -3.9%        52.56 5.2%
 NRZ        18.29           -   9.3%        16.73 10.9%
 SBRA        19.90      0.60 -6.6%        21.94 9.0%
 RILY        19.20      0.11 13.3%        17.05 0.8%
 DSL        20.12      0.50 -2.9%        21.25 8.9%
 OCSI          8.51      0.19 -1.1%           8.80 8.9%
 TGONF        13.18      0.17 4.3%        12.80 5.3%
 GLDI          8.76      0.14 -1.9%           9.07 3.6%
 DHF          3.31      0.07 -4.2%           3.53 8.5%
 MAC        65.48      0.69 1.8%        65.01 4.5%
 O        57.40      0.44 1.1%        57.19 4.4%
 Totals  -0.7% 6.4%

Saturday, December 16, 2017

Top 200 LIst 12/16/17

MFI Top 200 List

As my readers may know, I regularly create my own top 200 list.  I worked with some smart people on the Yahoo Groups MFI board and created a spreadsheet that does a very good job matching the metrics of the book and the official website (which in the early days posted calculated earnings yield and ROIC).

My list is ranked and shows dividend yield (per the unreliable Yahoo Finance).  It also has more stocks as I do not necessarily throw out other countries and I have some financial-type stocks (such as Humana) that the official list excludes.

This list took a lot more work as Yahoo Finance (boo) has pulled back some of their services ("It has come to our attention that this service is being used in violation of the Yahoo Terms of Service.  As such, the service is being discontinued.  For all future markets and equities data research, please refer to finance.yahoo.com.").

But keep in mind that I am just a single person with a spreadsheet - so please do your own analysis before making investment decisions.

Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield
OPHT 1            2.89            104 2416% 5362% 0.00%
NHTC 2         16.41            185 63% 4440% 2.57%
VVUS 3            0.53               56 127% 1990% 0.00%
AVDL 4            8.68            359 29% 2696% 0.00%
CNCE 5         26.62            623 22% 4417% 0.00%
BPT 6         20.00            428 18% 38570% 13.48%
ICON 7            1.48               85 20% 2220% 0.00%
AGX 8         43.25            683 33% 838% 2.31%
IDCC 9         74.95         2,652 19% 585% 1.65%
EVC 10            7.50            691 42% 334% 2.17%
GILD 11         75.57       99,677 16% 520% 2.75%
NTIP 12            2.40               63 48% 284% 4.19%
UTHR 13       137.41         6,060 21% 206% 0.00%
MPAA 14         24.94            483 13% 282% 0.00%
BPI 15            8.83            262 17% 189% 0.00%
MSGN 16         19.80         1,500 12% 276% 0.00%
SQBG 17            1.49               94 13% 210% 0.00%
QIWI 18         14.26            873 10% 728% 5.89%
MEET 19            2.30            175 12% 215% 0.00%
EGRX 20         57.40            905 12% 179% 0.00%
DHX 21            2.00               97 15% 143% 0.00%
VIAB 22         30.24       12,169 13% 166% 2.64%
ESRX 23         71.55       41,120 10% 426% 0.00%
VIA 24         34.40       13,843 12% 166% 2.33%
YRD 25         41.39         2,556 11% 185% 0.00%
SRNE 26            2.95            227 12% 161% 0.00%
GME 27         18.34         1,862 23% 109% 8.29%
vec 28         32.65            368 11% 174% 0.00%
HRB 29         27.20         5,687 10% 270% 3.46%
WU 30         19.48         9,066 9% 525% 3.49%
DISCK 31         19.75       11,277 11% 165% 0.00%
TRNC 32         17.30            578 15% 113% 0.00%
TGNA 33         13.62         2,970 12% 141% 2.57%
DISCA 34         21.04       12,014 11% 165% 0.00%
DLX 35         76.04         3,679 9% 473% 1.58%
QTRH 36            1.75            208 30% 93% 2.21%
HUM 37       253.60       36,863 10% 198% 0.58%
HPQ 38         20.92       35,292 10% 214% 2.56%
AMAG 39         14.45            510 9% 381% 0.00%
ANTM 40       226.21       60,398 9% 274% 1.19%
CJREF 41            8.96         1,816 10% 163% #VALUE!
MSTR 42       132.65         1,525 10% 172% 0.00%
NLS 43         13.90            432 12% 106% 0.00%
OMC 44         74.41       17,315 9% 281% 2.97%
PTN 45            0.85            171 8% 6550% 0.00%
AMCX 46         55.33         3,566 12% 100% 0.00%
SJT 47            7.67            357 8% 13785% 10.81%
LFVN 48            5.20               73 10% 122% 0.00%
HLF 49         67.03         5,563 9% 157% 0.00%
KLAC 50       105.63       16,673 9% 233% 2.14%
JMEI 51            3.03            455 80% 71% 0.00%
IPG 52         20.46         8,127 9% 145% 3.53%
INVA 53         13.43         1,609 8% 371% 0.00%
DIN 54         49.13            872 10% 111% 0.00%
TOSYY 55         17.24       12,174 18% 74% 0.00%
DFIN 56         20.21            683 10% 109% 0.00%
TARO 57       106.59         4,297 14% 77% 0.00%
HSII 58         24.75            471 11% 100% 1.85%
AET 59       179.70       59,660 8% 925% 0.97%
SYNT 60         25.57         2,136 10% 126% 0.00%
PBI 61         10.91         2,048 11% 96% 6.87%
NVMI 62         26.64            762 9% 139% 0.00%
MOMO 63         25.08         5,230 8% 1056% 0.00%
BLBD 64         18.25            465 9% 157% 0.00%
MCFT 65         22.33            417 8% 248% 0.00%
CSCO 66         38.19    190,721 8% 390% 2.96%
GPP 67         17.55            558 9% 118% 10.12%
SP 68         39.60            892 8% 312% 0.00%
AMGN 69       177.04    129,770 9% 149% 2.61%
MIK 70         21.84         3,975 11% 83% 0.00%
TWX 71         90.25       71,451 9% 132% 1.79%
CSVI 72         47.50            664 9% 131% 2.48%
CPLA 73         79.40            948 8% 178% 2.05%
CVS 74         73.08       74,542 10% 88% 2.72%
UIS 75            8.30            419 14% 65% 0.00%
EGOV 76         18.35         1,216 7% 833% 1.75%
FFIV 77       131.06         8,315 7% 471% 0.00%
TVTY 78         35.70         1,554 7% 1208% 0.00%
GHC 79       565.80         3,142 9% 101% 0.90%
FUJHY 80         16.36       25,087 20% 58% 0.00%
MSB 81         26.05            342 7% 573% #VALUE!
JNPR 82         28.40       10,869 9% 96% 1.41%
BKE 83         22.70         1,097 15% 60% 4.39%
FOX 84         34.22       63,410 8% 142% 0.00%
CSRA 85         30.13         4,979 9% 98% 1.33%
BBY 86         65.32       19,949 10% 79% 2.10%
PDLI 87            3.03            462 14% 60% 0.00%
CRTO 88         22.68         1,547 9% 86% 0.00%
USNA 89         73.30         1,802 8% 133% 0.00%
PBT 90            8.96            418 7% 14593% 7.11%
ODP 91            3.44         1,827 21% 54% 2.91%
FOXA 92         34.99       64,836 8% 142% 1.02%
CRUS 93         50.68         3,363 11% 73% 0.00%
GNTX 94         20.33         5,835 10% 75% 1.86%
TUP 95         64.55         3,311 9% 103% 4.21%
VVV 96         24.48         4,969 9% 91% 0.90%
ENDP 97            8.00         1,786 8% 137% 0.00%
PNLYY 98            4.65         2,069 13% 55% 0.00%
LEA 99       172.40       11,867 13% 57% 1.16%
ABC 100         93.17       20,358 8% 112% 1.58%
WCG 101       201.65         9,068 7% 205% 0.00%
WDC 102         81.62       24,976 9% 79% 2.45%
MD 103         51.10         4,746 8% 162% 0.00%
TIME 104         18.50         1,852 9% 88% 1.68%
TPB 105         18.09            354 9% 81% 0.23%
BOJA 106         12.75            491 9% 100% 0.00%
KLIC 107         24.65         1,777 12% 59% 0.00%
NCMI 108            6.93            445 8% 155% 12.69%
RGR 109         52.50            935 11% 64% 2.59%
BGSF 110         16.10            146 9% 79% 6.21%
OCLR 111            7.24         1,237 14% 50% 0.00%
SBH 112         16.92         2,219 12% 53% 0.00%
ENR 113         47.95         2,973 9% 87% 2.33%
SGU 114         10.50            587 9% 78% 4.12%
AEIS 115         71.40         2,868 7% 189% 0.00%
YUME 116            3.59            124 15% 48% 1.65%
CA 117         33.71       14,023 7% 470% 3.03%
HMTV 118         11.60            475 8% 104% 0.00%
BIIB 119       327.90       69,449 8% 129% 0.00%
CKHUY 120         12.24       47,218 13% 49% 0.00%
TZOO 121            6.05               76 8% 103% 0.00%
FL 122         45.65         5,770 17% 45% 2.66%
DNB 123       120.33         4,476 7% 996% 1.67%
RHI 124         55.26         6,863 8% 106% 1.74%
ALSN 125         41.28         6,068 8% 127% 1.45%
LRCX 126       186.32       34,261 8% 129% 0.99%
NSH 127         15.05            646 6% 22335% 14.49%
KBAL 128         18.15            685 9% 68% 1.37%
ABCD 129            5.63            268 8% 112% 0.00%
GIB 130         53.97       16,061 7% 219% 0.00%
ROCK 131         30.80            992 10% 61% 0.00%
UEPS 132         11.17            632 13% 45% 0.00%
UCTT 133         21.86            751 11% 51% 0.00%
SNI 134         83.21       10,922 8% 82% #VALUE!
CLF 135            6.65         2,002 14% 43% 0.00%
MCK 136       162.60       34,146 7% 113% 0.76%
AMN 137         48.95         2,420 8% 92% 0.00%
EME 138         81.09         4,818 8% 106% 0.39%
EBF 139         19.90            505 11% 51% 3.77%
PMD 140         20.60            115 9% 66% 2.91%
ETM 141         11.60            461 9% 68% 2.72%
TJX 142         74.17       47,682 8% 77% 1.61%
SWKS 143         94.63       17,573 8% 83% 1.28%
THO 144       149.99         7,922 8% 81% 0.91%
ORCL 145         48.30    206,869 7% 230% 1.49%
TPIC 146         18.99            665 10% 52% 0.00%
TNH 147         82.00         1,517 10% 52% 6.28%
FRAN 148            7.08            255 18% 39% 0.00%
JAZZ 149       135.53         8,326 7% 199% 0.00%
MAN 150       124.82         8,438 9% 61% 1.50%
AVP 151            2.18            959 12% 44% 0.00%
BAH 152         38.21         5,689 7% 139% 1.78%
CBS 153         58.90       23,913 8% 71% 0.00%
MDP 154         69.50         3,171 7% 104% 2.99%
SHI 155         57.05         6,168 15% 39% 6.36%
OMAB 156         42.57         2,095 7% 113% 3.95%
SAFM 157       143.31         3,210 15% 38% 0.73%
SBGI 158         37.35         3,849 8% 77% 1.93%
CNC 159         94.86       16,782 7% 148% 0.00%
INFY 160         16.06       36,738 8% 72% 2.69%
CPB 161         49.59       14,976 9% 57% 2.82%
HCKT 162         15.49            495 7% 106% 1.81%
CRHM 163            2.35            177 7% 223% 0.00%
MO 164         71.67    137,248 6% 499% 3.47%
MANH 165         46.30         3,201 6% 1246% 0.00%
TNET 166         43.40         3,103 6% 309% 0.00%
AYI 167       165.83         6,965 8% 86% 0.31%
TER 168         41.88         8,408 7% 133% 0.67%
EVTC 169         13.15            961 7% 166% 0.00%
RPXC 170         13.50            679 6% 619% 0.37%
HI 171         44.60         2,850 7% 113% 1.84%
APEI 172         25.85            423 12% 38% 0.00%
STX 173         42.02       12,270 8% 65% 0.00%
MLHR 174         35.40         2,136 9% 56% 1.98%
BSTC 175         45.07            330 6% 345% 0.00%
JEC 176         66.19         7,900 7% 84% 0.91%
PBH 177         45.57         2,440 7% 153% 0.00%
MMS 178         71.32         4,719 7% 117% 0.25%
BBBY 179         22.62         3,172 23% 33% 2.54%
GTN 180         16.25         1,177 9% 54% 0.00%
SIMO 181         52.96         1,897 7% 80% 1.70%
BC 182         55.00         4,939 10% 44% 0.00%
EGL 183         28.44         1,062 7% 110% 0.00%
GTS 184         26.66            645 8% 71% 0.00%
LPX 185         26.67         3,907 12% 36% 0.00%
XCRA 186            9.91            551 13% 36% 0.00%
TVPT 187         13.31         1,680 8% 73% 2.25%
FTD 188            7.16            197 7% 78% 0.00%
QCOM 189         64.76       96,363 6% 166% 3.47%
MBT 190            9.46         9,253 12% 36% 9.36%
CSGS 191         44.55         1,466 7% 86% 1.77%
AAPL 192       173.97    901,788 6% 182% 0.00%
CR 193         85.75         5,179 8% 67% 0.00%
GPS 194         33.56       13,189 10% 40% 0.00%
MBUU 195         28.64            553 7% 96% 0.68%
BAYRY 196         31.35       27,352 20% 31% 2.36%
NPK 197       100.00            699 12% 35% 1.00%
CELG 198       109.41       89,191 6% 384% 0.00%
MSI 199         93.15       15,742 7% 112% 2.07%
NCR 200         32.94         5,043 8% 64% 0.00%


Then here is official list and where each stock stands.


Ticker Mkt Cap Date My Ranking Price EY ROIC
AMAG 511 15-Dec 39        14.45 9% 381%
AMCX 3,470 15-Dec 46        55.33 12% 100%
ABC 20,311 15-Dec 100        93.17 8% 112%
AMGN 128,637 15-Dec 69      177.04 9% 149%
AGX 672 15-Dec 8        43.25 33% 838%
BIVV 5,756 15-Dec #N/A #N/A #N/A #N/A
HRB 5,687 15-Dec 29        27.20 10% 270%
BPT 428 15-Dec 6        20.00 18% 38570%
ABCD 263 15-Dec 129          5.63 8% 112%
CSCO 189,079 15-Dec 66        38.19 8% 390%
CNCE 654 15-Dec 5        26.62 22% 4417%
CJREF 1,848 15-Dec 41          8.96 10% 163%
DLX 3,659 15-Dec 35        76.04 9% 473%
DHX 101 15-Dec 21          2.00 15% 143%
DIN 884 15-Dec 54        49.13 10% 111%
DISCA 12,014 15-Dec 34        21.04 11% 165%
EGRX 916 15-Dec 20        57.40 12% 179%
EVC 678 15-Dec 10          7.50 42% 334%
ESRX 40,526 15-Dec 23        71.55 10% 426%
GME 1,858 15-Dec 27        18.34 23% 109%
GILD 98,770 15-Dec 11        75.57 16% 520%
HSII 465 15-Dec 58        24.75 11% 100%
HPQ 34,434 15-Dec 38        20.92 10% 214%
INVA 1,450 15-Dec 53        13.43 8% 371%
IDCC 2,601 15-Dec 9        74.95 19% 585%
IPG 7,950 15-Dec 52        20.46 9% 145%
KLAC 16,553 15-Dec 50      105.63 9% 233%
MCFT 417 15-Dec 65        22.33 8% 248%
MIK 3,959 15-Dec 70        21.84 11% 83%
MPAA 494 15-Dec 14        24.94 13% 282%
MSGN 1,490 15-Dec 16        19.80 12% 276%
NHTC 186 15-Dec 2        16.41 63% 4440%
NLS 427 15-Dec 43        13.90 12% 106%
OMC 17,154 15-Dec 44        74.41 9% 281%
OPHT 104 15-Dec 1          2.89 2416% 5362%
PTN 158 15-Dec 45          0.85 8% 6550%
PDLI 468 15-Dec 87          3.03 14% 60%
PCO 156 15-Dec #N/A #N/A #N/A #N/A
PBI 2,035 15-Dec 61        10.91 11% 96%
SRNE 232 15-Dec 26          2.95 12% 161%
SP 879 15-Dec 68        39.60 8% 312%
SYNT 2,119 15-Dec 60        25.57 10% 126%
TGNA 2,931 15-Dec 33        13.62 12% 141%
MEET 165 15-Dec 19          2.30 12% 215%
TWX 70,305 15-Dec 71        90.25 9% 132%
TVTY 1,412 15-Dec 78        35.70 7% 1208%
TRNC 580 15-Dec 32        17.30 15% 113%
UTHR 6,288 15-Dec 13      137.41 21% 206%
VEC 362 15-Dec 28        32.65 11% 174%
VIAB 12,169 15-Dec 22        30.24 13% 166%