AXS Update

One of my dividend companies is Axis Holdings (AXS), an insurance company. Last week they increased their dividend by a penny (AXIS Capital Increases Quarterly Common Share Dividend by 4% to $0.24 from $0.23 Per Share). Last night they announced their CEO is retiring (Axis Capital CEO to retire, CFO getting the job). I saw the stock was down on the news a bit, but I think the new guy (came from Partner Re) is highly thought of.

I have decided to make my Top 200 Spreadsheet available to anyone who wants it. Hopefully it is pretty self-explanatory. I will post it on the Yahoo Groups Magic Formula board.

I saw Steve Alexander of MagicDiligence is hanging it up as well. It has been tough sledding for MFI stocks. I always thought Steve did a nice job with his write-ups and analysis, but that didn't stop him from having his share of dogs. It really shows how difficult it is to separate good stocks from bad stocks as an outsider.

My dividend portfolio continues to plow along. It is trailing the Russell 3000 for open positions, but net-net I have so far been wise to move from MFI to dividend investing. And more importantly it is suiting my risk appetite better, I am now not micro-managing.

Current Portfolio
Stock	Shares	Avg Cost	Current Price	Dividends Received	Pct Change	R3K Change	Diff
AXS	1,133	33.03	30.41	484	-6.6%	-6.6%	0.0%
AZN	424	47.15	46.07	1,092	3.2%	-2.8%	6.0%
BHK	2,894	12.54	13.18	1,089	8.1%	-7.1%	15.2%
CEL	1,497	26.04	16.75	5,112	-22.6%	13.4%	-36.0%
CPL	1,000	22.67	26.50	-	16.9%	8.0%	8.9%
CSCO	1,801	16.74	18.75	196	12.7%	-5.3%	18.0%
CSQ	5,034	8.16	8.25	941	3.4%	7.8%	-4.4%
DD	500	43.78	44.13	-	0.8%	-0.8%	1.6%
FCX	500	36.00	38.86	-	7.9%	4.5%	3.5%
HPQ	803	25.80	27.35	96	6.5%	4.5%	2.0%
INTC	1,271	19.58	23.74	997	25.3%	9.0%	16.2%
JQC	4,485	8.84	7.89	1,598	-6.8%	-4.6%	-2.2%
KMF	1,731	21.63	23.39	607	9.8%	4.4%	5.4%
KSW	13,048	3.76	3.29	4,023	-4.4%	7.0%	-11.4%
LNC	2,415	24.33	19.34	400	-19.9%	2.0%	-21.9%
MNDO	13,678	2.48	1.90	2,400	-16.2%	-2.6%	-13.6%
MSFT	947	26.75	25.99	576	-0.6%	1.5%	-2.1%
PM	432	45.31	76.18	1,614	76.4%	16.5%	59.9%
PRE	505	56.34	63.50	300	13.8%	3.4%	10.4%
PVD	397	63.26	61.75	698	0.4%	4.3%	-3.9%
RTN	454	46.81	45.39	216	-2.0%	-5.9%	3.9%
SBS	1,035	39.34	53.95	2,390	43.0%	8.8%	34.2%
SLF	2,729	27.29	18.91	1,805	-28.3%	-3.5%	-24.7%
STD	6,090	9.62	7.34	3,460	-17.8%	0.8%	-18.6%
STO	1,000	23.86	25.37	-	6.3%	5.7%	0.6%
UNTD	3,397	5.86	5.22	1,897	-1.5%	14.3%	-15.8%
USB	2,099	21.96	26.14	739	20.7%	6.7%	14.0%
VR	1,926	29.43	29.74	1,742	4.1%	-4.7%	8.9%
WBK	489	105.84	105.22	3,636	6.4%	2.1%	4.3%
Total Open				38,108	1.3%	2.1%	-0.9%
Closed					12.5%	7.9%	4.6%
Combined					6.6%	4.9%	1.7%
IRR Since 12/31/10					5.5%
Estimated Dividends for Next year
Stock	Shares	Ann Dividend / Share	Yield	Projected Dividend	Sector
AXS	1,133	$ 0.96	3.2%	1,088	Insurance
AZN	424	$ 2.40	5.2%	1,018	Pharma
BHK	2,894	$ 0.80	6.1%	2,327	Bond
CEL	1,497	$ 2.05	12.2%	3,068	Utility
CPL	1,000	$ 1.27	4.8%	1,270	Utility
CSCO	1,801	$ 0.24	1.3%	432	Tech
CSQ	5,034	$ 0.63	7.6%	3,171	Hybrid
DD	500	$ 1.64	3.7%	820	Chemicals
FCX	500	$ 1.00	2.6%	500	Basic Resources
HPQ	803	$ 0.48	1.8%	386	Tech
INTC	1,271	$ 0.84	3.5%	1,067	Tech
JQC	4,485	$ 0.80	10.1%	3,588	Hybrid
KMF	1,731	$ 1.60	6.8%	2,770	Pipelines
KSW	13,048	$ 0.15	4.6%	1,957	Construction
LNC	2,415	$ 0.32	1.7%	773	Insurance
MNDO	13,678	$ 0.20	10.5%	2,736	Tech
MSFT	947	$ 0.80	3.1%	757	Tech
PM	432	$ 3.08	4.0%	1,330	Consumer
PRE	505	$ 2.40	3.8%	1,211	Insurance
PVD	397	$ 3.70	6.0%	1,470	Finance
RTN	454	$ 1.72	3.8%	782	Defense
SBS	1,035	$ 2.39	4.4%	2,473	Utility
SLF	2,729	$ 1.46	7.7%	3,984	Insurance
STD	6,090	$ 0.78	10.6%	4,750	Finance
STO	1,000	$ 0.94	3.7%	940	Basic Resources
UNTD	3,397	$ 0.40	7.7%	1,359	Consumer
USB	2,099	$ 0.50	1.9%	1,050	Finance
VR	1,926	$ 1.00	3.4%	1,926	Insurance
Total			5.2%	49,001
Upcoming Dividends
Stock	Shares	x Date	Div/Share	Est New Shares	Amount
VR	1,926	12/13/11	$ 0.25	16.0	481
JQC	4,485	12/13/11	$ 0.20	113.0	897
PM	432	12/27/11	$ 0.77	4.0	333
SBS	1,035	12/28/11	$ 1.71	32.0	1,770
AXS	1,133	12/28/11	$ 0.24	8.0	272
USB	2,099	12/29/11	$ 0.13	10.0	262
CEL	1,497	1/3/12	$ 0.51	45.0	763
RTN	454	1/3/12	$ 0.43	4.0	195
CSCO	1,801	1/5/12	$ 0.06	5.0	108
CSQ	5,034	1/8/12	$ 0.05	32.0	264
BHK	2,894	1/12/12	$ 0.07	14.0	194
Closed Dividend Stocks
Stock	Gain	R3k Gain	Difference
ace	0.4%	-3.7%	4.1%
AXS	2.3%	-1.7%	4.0%
BKE	34.1%	8.8%	25.3%
BR	15.3%	8.8%	6.5%
CHKE	-21.1%	12.4%	-33.5%
CMTL	8.2%	1.3%	6.9%
CSQ	10.5%	14.1%	-3.7%
ENH	4.7%	-3.7%	8.4%
ENH-A	120.1%	78.1%	42.0%
IGI	4.8%	-7.9%	12.7%
INTC	13.3%	14.9%	-1.7%
KSW	27.6%	22.9%	4.7%
MAIL	14.9%	6.4%	8.5%
PDLI	-4.9%	0.7%	-5.6%
PETS	-3.9%	10.0%	-13.9%
PFE	8.9%	14.4%	-5.5%
PM	59.1%	21.9%	37.3%
RAI	47.8%	19.6%	28.2%
RGR	42.1%	1.2%	40.9%
RNR	6.9%	5.2%	1.7%
RNR-C	103.6%	78.7%	24.9%
RTN	12.9%	11.6%	1.3%
SLRC	25.2%	19.0%	6.3%
STD	-9.4%	-0.8%	-8.6%
STRA	17.8%	9.6%	8.2%
SYT	0.3%	-9.3%	9.6%
valu	21.6%	10.6%	11.0%
VR	6.1%	5.5%	0.7%
WTW	1.9%	1.6%	0.3%
Total	12.5%	7.9%	4.6%