Saturday, October 31, 2009

Great Plains Energy 401k (SP) PSDS Scan 12/31/2008


















Another lifeboat portfolio. The Balanced portfolio has 83.5% of the plan in the stable value fund FMIP in the scan. The employee portfolio has 31.4% of their money in company stock GXP which has a negative 5yr APR which resulted in the employee portfoilo having a 5yr APR = -1.17%. The plan has many good funds that have very little money invested in them. They may want to read the Employee Benefit Research Institute 2008 report, there is a link to it on this website.

Friday, October 30, 2009

AGL Resources 401k (RSPP) Plan PSDS Scan 12/31/2008


















This plan was helped by company stock and the so called Balanced portfolio has 2.9% invested in the stock and 93% in the stable value fund SVF.hpx in the scan. The employee portfolio has 50.4% invested in the stock which is too much in my opinion. Funds like JETIX without 5yr data as of 12/31/2008 were repesented by a proxy, HAINX in this case.

Thursday, October 29, 2009

Borders Group 401k (SP) Plan PSDS Scan 12/31/2008


















This plan Balanced portfolio is invested mostly in the GIC repesented by GIC.ekx in the scan and the bond fund PTTRX. The employee portfolio has the GIC as their largest holding too and less than one percent in company stock BGP. The stock was not included in the scan, it was that bad.

Wednesday, October 28, 2009

Federal-Mogul 401k Plan PSDS Scan 12/31/2008


















This plan was complicated by a class action lawsuit settlement involving company stock FDML. The master trust as of 12/31/2008 holds FDML warrants that I did not include in the scan. The Balanced portfolio has 86.6% of the plan in the stable value fund FMIP in the scan and it is the largest holding in the employee portfolio too at 37.2% of their portfolio.

Tuesday, October 27, 2009

Compass Minerals Intl. 401k (SP) PSDS Scan 12/31/2008


















This plan company stock CMP has the highest Sharpe ratio I have seen for this 5yr period. The Balanced portfolio invested 17.6% of the plan in the stock and 61.2% in the stable value fund FMIP. The employee portfolio invested only 3.0% in the stock and their largest holding was the stable value fund. Interesting.

Monday, October 26, 2009

SEI Investments 401k (CAP) PSDS Scan 12/31/2008


















This plan was hurt by company stock and 2008. It has a stable value fund FUNDG in the scan and a GNMA bond fund SEGMX which is where the Balanced portfolio put almost all the money. The employee portfolio had a 5yr APR = -0.20% with 14.4% invested in company stock which is very volatile.

Friday, October 23, 2009

YUM! Brands 401k Plan PSDS Scan 12/31/2008

















This is a very good small plan helped by company stock YUM and the Balanced portfolio has 10% invested in the stock. The plan has 6 common trusts, a government STIF, and YUM. In the scan these are representd by ETFs,
Stable Value Fund - FUNDG (US Gov 401k stable value fund)
Large Company Index Fund - SPY
Bond Market Index Fund - AGG
Mid-Sized Company Index Fund - IJH
Small Company Index Fund - IWM
Government STIF - SHY (BILL does not have 5yr data)

The employee portfolio has 45.9% invested in company stock, way too much for a retiree.

Thursday, October 22, 2009

Alliant Energy 401k (SP) Plan PSDS Scan 12/31/2008


















This plan was helped by company stock LNT and the Balanced portfolio has 8.7% on the plan invested in the stock. The employee portfolio has 19.4% invested in the stock as of 12/31/2008. The government and agency holdings were represented by FGOVX in the scan. The plan has no stable value fund which avoided a Sharpe ratio distortion of the 3D scan.

Wednesday, October 21, 2009

Moody's 401k (PPP) Plan PSDS Scan 12/31/2008


















This plan was last scanned 10/31/2008 and a lot has happened since. The Balanced portfolio 5yr APR has dropped to 4.60% with 81.1% of the plan now invested in the stable value fund FMIP. The employee portfolio as of 12/31/2008 had 6.8% invested in company stock MCO which hurt their 5yr return that is now APR = 1.26%.

Tuesday, October 20, 2009

McKesson 401k (PSIP) PSDS Scan 12/31/2008





















This is a large plan with many options. The scan included the 44 options with the most money invested in them. The Balanced portfolio had money in 18 funds. The 3 largest investments were the Mellon stable value fund SVF.mfs with 31.6% of the money, the money market fund FRTXX with 14.5% and the global bond fund TPINX with 10.2%. The employee portfolio had most of the money in company stock MCK with 31.6% invested in it and that hurt perfomance by greatly increasing volatility. Keep in mind that volatility kills compounding.

Monday, October 19, 2009

Liz Claiborne 401k (SPSP) Plan PSDS Scan 12/31/2008


















This plan was hurt by company stock and helped by a stable value fund FMIP in the scan. The Balanced portfolio had 93.9% invested in the stable value fund and the employee portfolio had 24.9% in that fund as of 12/31/2008. All in all a good plan but a very volatile company stock.

Friday, October 16, 2009

Anadarko Petroleum 401k (ESP) PSDS Scan 12/31/2008


















This plan was helped by company stock APC and has a good stable value fund FMIP in the scan. The Balanced portfolio has 85.8% of the plan in the stable value fund and 3.0% in company stock. The employee portfolio had 28.2% in company stock which is too volatile for a retiree in my opinion. The plan has 34 investment options that are almost all equity invetments.

Thursday, October 15, 2009

Constellation Energy 401k (SP) PSDS Scan 12/31/2008


















This energy company plan was not helped by company stock CEG. The Balanced portfolio invested everything in PTTRX and the stable value fund repesented by Hueler index SVF.hpx in the scan. Target retirement funds without 5yr data were represented by their Fidelity equivalent. The employee portfolio invested 8.1% of the plan in company stock as of 12/31/2008.

Wednesday, October 14, 2009

J.C. Penney 401k Plan PSDS Scan 12/31/2008


















Another "lifeboat" portfolio with the Balanced portfolio invested in the GIC and bonds. Company stock had terrible 2008 and 2007 returns with off the chart volatility and a 5yr APR = -3.95%. The employee portfolio as of 12/31/2008 had 12.1% of their investments in company stock. In the scan common collective trust funds were represented by the index ETF they track.
********************
Thanks for the comment and kind words. The White Papers are the best place to get technical details about the methods I use, they are free and can be down loaded from this site. I use robust design methods from engineering i.e. Baysesian Monte Carlo simulations. The market data is from Thomson Reuters each month. At my age the great grandchildren take up my days.

Tuesday, October 13, 2009

Williams-Sonoma 401k Plan PSDS Scan 12/31/2008

















This plan was hurt by company stock and 2008 more than most. The Balanced portfolio has 93.1% of the plan in the Schwab stable value fund, SVF.hpx in the scan, and the rest in PTTRX. The employee portfolio has over 20% invested in company stock producing a negative 5yr APR of -4.86%. For comparison the national average for 401k plan employee stock is 9.7%.

Monday, October 12, 2009

JP Morgan Chase 401k (SP) PSDS Scan 12/31/2008


















This plan has 25 investment options; 6 fixed income funds, 4 international equity funds, 11 domestic equity funds, 3 lifestyle funds and company stock. The individual funds are not identified in the SEC 11-k report. I used JP Morgan funds for each catagory as available and proxies when there were no JPM funds with 5 yr data. The Balanced portfolio has no money in company stock which is the largest employee holding at 34.4% of the plan. The Balanced portfolio has 51.3% of the plan invested in the GICs represented by the GIC.ekx index in the scan.

Friday, October 9, 2009

Monsanto 401k (SIP) Plan PSDS Scan 12/31/2008

















This plan is a converted defined benefit plan that has no mutual funds only SMA funds. The plan is dominated by company stock MON and a large GIC. It has seven SMA catagories plus four premixed asset allocation funds that I take to be like target retirement date funds. Company stock has better 5yr returns than most oil companies. The Balanced portfolio has 90% invested in the stock and GIC. The plan trustee is Northern and I used their funds for catagories where they had one. The Capital Gaurdian International Equity fund was represented by AEPGX.