Dunn & Bradstreet 401k Plan PSDS Scan 12-31-2010

The Balanced portfolio improved over last year but company stock DNB did not have a good 2010 and the employee portfolio APR is almost 2 points lower than the Balanced portfolio. The plan has very good fixed income options and about average equity options. It is a conservative and pretty well diversified plan.

Blog Note: The additon of a pie chart for Balanced portfolio asset allocation recenty was to reduce the cost of providing that data as a note in the 3D scan image. The Pie Chart is fully automated.

Kraft Foods Global 401k (TP) Plan PSDS Scan 12-31-2010

This plan is in litigation. The latest SEC 11-k report describes a complicated stock transaction in the plan that
resulted in a very large block of PMI stock which has a 5yr APR = -39.18% and a Sharpe ratio of -0.732 being substituted for MO stock. I looked at the Morningstar data for a hour thinking I must be missing something and I may still be. The plan investment options are as described by HR documents on line.  The trustee is State Street Bank and their funds were used if they had 5yr data and proxies were used when necessary.

Euro Equity    -  EFA
International Equity - SSAIX
US Mid/Small Cap Equity - SESPX
Balanced - VBINX
US Large Cap Equity Index - SVSPX
US Government Obligations - SSINX
Interest Income - SVF.hpx
Kraft Foods Stock - KFT
Altria Stock *frozen - MO
Phillip Morris International PMI Stock - PMI
Retirement Target Today Fund - VTINX
Retirement Target 2015 Fund - VTXVX
Retirement Target 2025 Fund - VTTVX
Retirement Target 2035 Fund - VTTHX
Retirement Target 2045 Fund = VTIVX

The Balanced portfolio is fine but the employee portfolio was hurt by PMI stock. I only posted the 2D scan chart for this plan. The others were badly distorted by PMI stock.

AZZ Inc. 401k (EBPT) Plan PSDS Scan 12-31-2010

This plan continues to be helped by company stock AZZ which has double digit 1, 3, 5, 10, and 15 year returns. As you can see in the 2D scan chart the Balanced portfolio added AZZ stock up until the portfolio risks started to increase faster than the returns. The employee portfolio is more conservative. The plan changed several investment options adding PTTRX, AGTHX and AEPGX in particular that are in the Employee assets > 5% of plan. These are very good funds and a good plan got better.

Procter & Gamble Commercial Co. 401k (PSRP) PSDS Scan 12-31-2010

Procter & Gamble has several component companies that all have PG stock in their 401k investment options. This is a small plan for retail employees I think but has about the same investment options as the others. The plan is conservative and the Balanced portfolio invested some money in all the options save one. The employee portfolio has over 50% of that portfolio in company stock PG too much for a retiree in my opinion. All in all a good but conservative plan and a good stock.

Zimmer Holdings 401k (SIP) Plan PSDS Scan 12-31-2010

This company is a spin off from BMY and the plan has company stock ZMH in the Master Trust but as of 2009 it is not open to new money and is not participant directed. Fidelity is the plan trustee and I used Fidelity funds for the Mutual fund catagories except for PTTRX

US large cap funds - FDGRX, FSLVX

US mid cap funds - FMCSX, FSMVX
US small cap funds - FSLCX, FCPVX

US diversified common stock funds - FDESX

International small cap funds - FISMX

International diversified common stock funds - FDIVX

2000 - 2010 - FFFAX 2011 - 2020 - FFFBX

2021 - 2030 - FFFCX2031 - 2040 - FFFDX

2041 - 2050 - FFFEX

Intermediate bond funds - PTTRX

Multi-strategy funds - FASMX

Stable value fund - FMIP

The plan was not helped by company stock ZMH but does have a Balanced portfolio with a 5yr APR = 5.31% and with a Sharpe ratio 0f 1.40. All in all a good plan and a volatile stock.

Covance 401k (SP) Plan PSDS Scan 12-31-2010

This company stock CVD does not have a positive 5yr Sharpe ratio and is not in the Balanced portfolio. The 401k plan has good investment options and the Balanced portfolio has a 5yr APR = 5.26% with a Sharpe ratio of 1.05. The employee portfolio has 22.7% of that portfolio in company stock which did not help. The bond investment options are the strength of this plan.

Chevron 401k (ESIP) Plan PSDS Scan 12-31-2010

The Chevron 401k plan changed in 2009 to make company stock CVX Non Particpant directed as part of a leveraged ESOP program described in the SEC11-k report. It is still by far the largest holding of the employee portfolio at 54.7% of plan and continues to help the plan's performance. The Balanced portfolio has an above an average return but is outperformed by the employee portfolio with the huge investment in company stock. All in all a good plan with a very good company stock.