Friday, May 29, 2009

American Tower 401k (RSP) Plan PSDS Scan 12/31/2008


















This was the most unusal scan I have seen in a long time. The Balanced portfolio loaded up on company stock, AMT, and put nothing in the money market fund. The stock has out performed everything, 5yr APR = 22.08%, and has a positive 5yr Sharpe ratio. In this case it was not by reducing volatility (the denominator) but by increasing the return (the numerator). It is a volatile stock and the employee portfolio put most of its money elsewhere. That is prudent for a retiree and even for young employees the Balanced portfolio has too much company stock in may opinion.

Wednesday, May 27, 2009

Wellpoint 401k (RSP) Plan PSDS Scan 12/31/2008


















The Wellpoint 401k is virtually all Vanguard funds plus PTSGX, DFVEX, a GIC and company stock, WLP. The DFVEX fund does not yet have 5yr data and was represented by IWM in the scan. The Balanced portfolio has most of the money in the GIC represented in the scan by the EnnisKnupp GIC index. The employee portfolio top three investments as of 12/31/2007 were in VINIX, VMMXX, and WLP. They had very little money in the GIC.

Tuesday, May 26, 2009

Unit Corp. 401k (TP) Plan PSDS Scan


















The Unit Corp. plan has money in several target retirement funds that do not have 5yr data and these are repesented in the scan by the corresponding Fidelity funds. Company stock, UNT, like many companies had a very bad 2008 which hurt the employee portfolio. As of the latest SEC 11-k filing, 12/31/2007 data, UNT was the largest holding of the plan. The Balanced portfolio largest investment was in a GIC represented in the scan by GIC.ekx the EnnisKnupp index.

Sunday, May 24, 2009

State of Wisconsin 401k (457) Plan PSDS Scan 12/31/2008


















The Wisconsin 401k (457) plan uses many BIG funds that track the same BIG indices as the US Government 401k (TSP) plan. I used the TSP plan funds for those options and IWR for the BIG MidCap Index Fund and IWM for the BIG Small Cap Index Fund. The plan participants had the most money invested in FCNTX and FUNDG. The Balanced portfolio had a large Sharpe ratio because of the 55.4% invested in the stable value fund, FUNDG in the scan.

Friday, May 22, 2009

AptarGroup 401k (PSSP) Plan PSDS Scan 12/31/2008


















This plan was also lifted by the performance of company stock, ATR, and the Balanced portfolio had 28.3% invested in the stock. Thats more than I think prudent in retirement but in this market there are few save harbors. The goverment money market portfolio fund FGMXX was represented in the scan by VUSXX a very similar fund. Like Church & Dwight this company is one of the top holdings of NBGNX.

Thursday, May 21, 2009

Alliant Techsystems 401k Plan PSDS Scan 12/31/2008


















This plan's Balanced portfolio has 80.9% invested in the Fidelity Management Income Portfolio, FMIP, a stable value fund. The employee portfolio has FMIP as their largest investment closely followed by company stock, ATK, which has a 5yr APR of 8.25%. I have owned several of the funds in this plan over the years.

Wednesday, May 20, 2009

Church & Dwight 401k (PSP) PSDS Scan 12/31/2008

















This plan got a lift from company stock, CHD, which has done very well with a 5yr APR = 17%. As the correlation chart shows it was a bigger factor than the stable value fund in increasing portfolio APR which has not happened often lately. CHD is the largest employee investment in the 12/31/2007 SEC 11-k report and their portfolio did very well. The stable value fund was represented by the Hueler stable value index in the scan. The only target retirement fund with 5yr data, PRRAX, had all the target retirment investment money in the employee portfoilio.

Tuesday, May 19, 2009

Eaton 401k (ESP) Plan PSDS Scan 12/31/2008


















The plan has few options and the employees as of 12/31/2007 had most of their money in company stock, ETN, which was down -46.7% in 2008. The Balanced portfolio by rule is invested only in options with a positive 5yr Sharpe ratio. That was just the money market fund and 100% of the Balanced portfolio is there. The scan covered investments that were more than 5% of the Master Trust.

Monday, May 18, 2009

Dun & Bradstreet 401k Plan PSDS Scan 12/31/2008


















This plan was helped by company stock, DNB, and the Balanced portfolio had 9.5% invested in the stock. The largest investment in the Balanced portfolio and the employee asset allocation from the latest SEC11-k report was in the GICs at 59.3%. The GICs were represented by the EnnisKnupp GIC index in the scan. The employee portfolio returns were positive with the APR = 1.56%, STD = 4.29% and PSR =-0.31. Dun & Bradstreet 401k 5yr returns were among the best from a financial services compay through 2008.

Saturday, May 16, 2009

Corning 401k (IP) Plan PSDS Scan 12/31/2008

















This is the first scan posted using solar power from my "Walden" backyard design studio. The Balanced portfolio was invested in the income funds, SVF.vgd, VBMFX and VIPSX. The employee portfolio had $675M in company stock, GLW, $966M in mutual funds and $513 in income funds. The SEC11-k did not brake down the investments by individual funds and in the scan the funds were uniformly distibuted by catagory for the employee portfolio..

Friday, May 15, 2009

Boston Scientific 401k (RSP) Plan PSDS Scan 12/31/2008



















This plan like so many in 2008 had a Balanced portfolio over 90% invested in the stable value fund. The only fund with a positive 5yr Sharpe ratio was VBMFX and it had the rest of the money. The employee portfolio had a negative -1.85% 5yr APR and company stock, BSX, was negative for all 5 years of the scan.

Thursday, May 14, 2009

Applied Materials 401k (ESRP) PSDS Scan 12/31/2008

















This plan had only two investment options with positive 5yr Sharpe ratios, a Mellon stable value fund and LRSYX. The Balanced portfolio has 98.3% invested in the stable value fund represented in the scan by the SVF index. The employees had most of their money invested in company stock, AMAT, as of 12/31/2007 from the latest SEC 11-k report. The emplyee portfolio 5yr APR was negative at -3.69% with a STD 0f 7.14%.

Wednesday, May 13, 2009

Hewitt 401k Index PSDS Scan 12/31/2008


















Hewitt Associates have tracked 401k plan money flow for over 10 years in their 401k index for their HR clients. As of 1/31/2009 the largest holding is in GIC/Stable investment options with just over 34% of the index portfolio. Other catagories are Large US Equity, Company Stock, Lifestyle, Bond, International, Balanced, Small US Equity, Money Market, Mid US Equity, Specialty/Sector and Self Directed. I created a portfolio for these catagories from the funds in these catagories I see most often in the 401k plans I have scanned. I did not include a company stock or self directed option in the scan.

Tuesday, May 12, 2009

Piper Jaffray 401k (RP) Plan PSDS Scan 12/31/2008

















This is a good plan with the Balanced portfolio in 6 different funds for a change; a SVF fund, RGVEX, PTTRX, PCVAX, REREX, and ODMAX. The employee portfolio did not have a lot invested in company stock, PJC, and had a modest positive return. The First American Stable Asset Select Fund was represented in the scan by SVF.mfs which matches it well.

Monday, May 11, 2009

Disney 401k Plan PSDS Scan 12/31/2008

















Like most 401k plans the Disney plan inverted in 2008 and the Balanced portfolio retreated to bonds and in this plan a money market fund. This scan includes company stock, DIS, which had a 5yr return of o.56% and a slightly negative Sharpe ratio. The employee portfolio asset allocation is as of 12/31/2007 from the latest SEC 11-k report.

Friday, May 8, 2009

American Express 401k Plan PSDS Scan 12/31/2008

















There is not much to say about this plan. The Balanced portfolio has invested everthing in the stable value fund, FUNDG in the scan. The SEC 11-k data for 12/31/2007 have company stock, AXP, a State Street S&P 500 Fund, SVSPX, and four fund catagories; U.S. Large Cap Equity, International Equity, U.S. Small/Mid-Cap Equity and a Diversified Bond fund. The ones without 5yr data were represented in the scan by an ETF fund for the catagory.

Thursday, May 7, 2009

Hewlett-Packard 401k Plan PSDS Scan 12/31/2008



















A lot has changed since the first Hewlett-Packard scan last July. The Balanced portfolio 5yr return is less than half what is was in July 2008. The current scan includes company stock, HPQ, which has a good 5yr return and a Fidelity money market fund as a proxy for all the short term invetments in the plan. The Balanced portfolio is diversified with investments in 11 of the plans options including HPQ which have positive 5yr Sharpe ratios.