CVS Caremark 401k Plan PSDS Scan 12-31-2009

The year-over-year Balanced portfolio 5yr return is down slightly as was company stock CVS. The 3D scan has more investments than last year and is more focused as the pull of company stock is smaller. Market improvements in 2009 helped most funds in the scan return to positive 5yr Sharpe ratios which put them in the Balanced portfolio.

Goldman Sachs 401k Plan PSDS Scan 12-31-2009

The Balanced portfolio has many more investments this year compared to last year and to my eye the 3D image is healthier. Company stock GS bounced back in 2009 (+101.9%) and the 5yr APR is now 11.2% with very high volatility. The Balanced portfolio has 2.4% invested in GS and the employee portfolio has 1.6% which I think is prudent. In the scan the Barclay LifePath data were taken from the US Gov 401k plan (tsp) which posts the 5yr performance data.

Bristol-Myers Squibb 401k (SIP) PSDS Scan 12-31-2009

The Balanced portfolio improved a little year-over-year but not much. It is still a lifeboat portfolio with 56.2% of the plan invested in the GIC and 22.2% in the money market fund FRTXX. Company stock BMY impoved a little too which helped the employee portfolio that invested 23.3% of their money in the stock.

State of Nebraska 457 (DC) Plan PSDS Scan 12-31-2009

The Nebraska plan uses TIAA-CREF and Fidelity investments in the following catagories and in the design scan I used Fidelity funds,

Money Market : FRTXX
Stocks (Equities) : FLPSX, FDGRX, FBALX
Bonds (Fixed Income) : FGMNX, FGOVX, FBIDX

Guaranteed Annuity : GIC index

Lifecycle Funds: FFFAX, FFFBX, FFFCX, FFFDX

The Balanced portfolio had a 5yr APR = 4.32 and a Sharpe ratio of 2.49 which is a reflection of the GIC being the largest holding at 46.4% of the plan. Similar results could be obtained using similar TIAA-CREF funds. Many other possibilites exist but my focus is employees near or in retirement.

State of Florida 457 (DC) Plan PSDS Scan 12-31-2009

The State of Florida 457 plan has a Balanced portfolio 5yr APR = 4.89 with a very good Sharpe ratio of 1.80. The plan web site has mutual fund details and the 3 SMA funds were repesented in the scan by similar State of Utah funds UTH.agr , UTH.mod and UTH.con which have posted 5yr data. The two States use several of the same investment advisor firms. The GIC is represented in the scan by the index GIC.ekx and that is the largest holding in the plan.

Monsanto 401k (SIP) Plan PSDS Scan 12-31-2009

This plan was again helped by company stock MON but not as much as last year. The Balanced portfolio 5yr APR= 6.16% and company stock 5yr APR = 25.22% are lower than last year but they are still among the best 401k plan returns I have seen. The employee portfolio had a 5yr APR = 9.18% with 22.8% of the portfolio invested in company stock which is volatile. Refer to last years scan posting for more information on the 401k plan investments.

Aflac 401k (PSP) Plan PSDS Scan 12-31-2009

The Balanced fund has improved year over year with the very positve 2009 market. The employee portfolio still has over 50% of their money in company stock AFL which is still way too much for a retiree but the portfolio does have a positive 5yr APR = 3.83%. In the scan the stable value fund ML Retirement Preservation Trust is represented by the index SVF.hpx.

Borders Group 401k (SP) Plan PSDS Scan 12-31-2009

There is year over year improvement in the Balanced portfolio but company stock BGP is still not in the scan for obvious reasons. The Balanced portfolio has a 5yr APR = 5.12% with low volatility STD = 1.69% and a very nice Sharpe ratio of 1.49. The employee portfolio has the GIC as its largest holding too and a respectable positive 5yr APR = 3.49%.

Beckman Coulter 401k (SP) Plan PSDS Scan 12-31-2009

Year over year the plan and company stock BEC have improved. The Balanced portfolio now includes most of the plan funds. The employee portfolio and the Balanced portfolio have the stable value fund FUNDG in the scan as their largest holding. A small plan with good funds. The the employee portfolio has more money in target date funds than most.

Brunswick 401k (RSP) Plan PSDS Scan 12-31-2009

This company stock BC is still a long way from being in the Balanced portfolio. It did have a good 2009 but a 5yr return of -22.66% is not good. Year-over-year the Balanced portfolio more than doubled the number of Vanguard funds and has a 5yr APR = 4.14%. The employee portfolio still has 2.4% invested in company stock which did not help their 5yr return of APR = 2.84%. This is a good plan with a bad stock.

Franklin Templeton 401k (PSP) Plan PSDS Scan 12-31-2009

Year over year this plan Balanced portfolio has more than doubled the number of funds with positive 5yr Sharpe ratios and company stock BEN has done the same. I like one of the funds TPINX enough that I added it to my portfolio last year. The employee portfolio still under perfoms the Balanced portfolio but it is close on APR.

IBM 401k Plan PSDS Scan 12-31-2009

This plan with over 200 investment options was scanned last year with a small subset of them. This year I added several more options including company stock IBM and a stable value fund. The Balanced portfolio has a nice 5yr return APR = 5.47% with most of the money (40.8%) in the stable value fund FUNDG in the scan. My focus was on growth and income investments with positive 5yr Sharpe ratios and they are posted in the 3D scan image.

Thermo Fisher Scientific 401k (RP) Plan Scan 12-31-2009

There has been year-over-year improvement but not a lot. The Balanced portfolio is still a lifeboat protfolio with 69.3% of the plan invested in the stable value fund SVF.hpx in the scan.

Company stock has a good 5yr return but is very volatile. The Balanced portfolio has 5.4% invested in TMO and the employee portfolio has 2.4% invested in it. There are too many target retirement funds with very small 5yr Sharpe ratios and that has hurt the 5yr plan performance.

Atlas America 401k (ISP) Plan PSDS Scan 12-31-2009

This plan was helped by company stock ATLS which is in the energy business. The Balanced portfolio has 8.4% invested in the stock and the employee portfolio has 30.6% in the stock. The Merrill Lynch money market fund MBIXX does not have 5yr data and VMMXX is the proxy in the scan. About one-half the funds in the plan are not in the scan because very little money was invested in them.

Kansas City Southern 401k (GWRU) Plan PSDS Scan 12-31-2009

This plan was helped by company stock KSU and the Balanced portfolio invested 5.9% of the plan in the stock. The employee portfolio had only 1.4% in the stock which is unusal given the 5yr Sharpe ratio of the stock is slightly higher than that of the employee portfolio. All in all a good plan that is small but diversified.

American Electric Power 401k (RSP) Plan 12-31-2009

This plan gained a bit in 2009 and the year over year comparisons show an increase in Sharpe ratio which is a measure of risk adjusted performance. It is the largest Roth 401k I have seen and I enjoy working on the plan details, all 43 pages of them in the SEC 11-k report. JP Morgan Chase is the trustee and Mellon Capital Management provides the trust funds that account for most of the over 5% holdings. As last year the Registered Investment Company funds are only 33M of the 2.5B dollar plan. They are among the largest holdings in this small catagory which has over 500 mutual funds that take 11 pages to document in the 11-k report.

Aon 401k (SP) Plan PSDS Scan 12-31-2009

The year-over-year changes have been small and positive. The Balanced portfolio now has 6 funds and company stock AON. The employee portfolio has 18.7% in the stock and the Balanced portfolio 11.5%. The proxy last year for the SSgA short term investment fund SIGVX has been replaced by fund data from the SSgA factsheet for the fund.