Monday, December 29, 2008

State of Texas 401k (457) Plan Scan 11/30/2008




The funds in the scan were FRTXX, FBIDX, VWENX, NYVTX, VIIIX, VIGIX, MGOYX, LRSYX, FDIVX, WOTDX, WFOBX, WFOOX and an ING stable value fund. The data for the stable value fund for Texas are on a ING web page. No data were found on employee allocations so a unifrom allocation was included in the scan for comparison.

Saturday, December 27, 2008

State of Illinois 401k (457) Plan Scan 11/30/2008





The funds in the scan were ACRNX, ARGFX, FPURX, LMVFX, LSVEX, EFA, PRCIX, TRRIX, TRRAX, TRRGX, TRRBX, VBTIX, VMRXX, NOSGX where EFA is a proxy for JIGFX which does not yet have 5yr data. The latest employee asset allocation data were for 2006 and at that time they had just over $1B in one fund, ACRNX. The plan made small "watch list" changes in the last year or so. As always the Balanced portfolio has money only in funds with positive 5yr Sharpe ratios.

Friday, December 26, 2008

H.B. Fuller 401k (TP) PSDS Scan 11/30/2008 Data




The H.B. Fuller employees have most of their money in company stock (FUL) and a Wells Fagro stable return fund DSVG1 while the Balanced fund has no money in FUL or any fund with a negative 5yr Sharpe ratio. The funds in the scan were FUL, VFINX, DSVG1, WFGBX, VISGX, PTTRX, JAVLX, SMCDX, ACSTX, MGRAX, DODFX, GSSMX where VFINX is a proxy for WFVEX and VISGX is a proxy for WFSAX neither of which have 5yr data yet.

Monday, December 22, 2008

Toro 401k (PSP) PSDS Scan 11/30/2008 Data




The Toro scan is unusual in that the Wells Fargo Stable Return Fund DSVG1 and company stock TTC dominate the Employee portfolio while the Balanced porfolio puts almost everthing in the stable return fund DSVG1. The 3D image shows the isolation of the Balanced fund which has a very low standard deviation while all the mutual funds and company stock are quite volatile. I should also point out that DSVG1 is not FDIC insured which is not good but normal for most funds.

Top30 ETF Portfolio PSDS Scan 11/30/2008




The Top 30 ETFs based on 5yr Sharpe ratio were screened from the 11/30/2008 Thomson market data file with only one "money market" fund included, there are lots of them with high SRs and about the same low APR. Happy Holidays.


Thursday, December 18, 2008

Dana 401k (EISIP) Plan PSDS Scan 11/30/2008




The funds in the Dana 401k scan were VFINX, VHCOX, VEXPX, VIPSX, VFITX, VWIGX, VTXVX, VUSTX, VMMXX, VWELX, VASVX, and VWNDX. The amount of money in company stock DAN was virtually zero. The target retirement fund VTXVX served as a proxy for all the target retirement funds.


Tuesday, December 16, 2008

Kroger 401k (RSA) PSDS Scan 10/31/2008




The Kroger 401k (Retirement Savings Account) has money in a master trust as well as collective trusts, mutual funds and company stock KR. The funds in the scan were MDY, SPY, IWN, MBILX, DODFX, AXLVX, EEM, MAFGX, MALOX, MABAX, and KR where MDY is a proxy for a Merrill Lynch Mid Cap S&P 400 fund, SPY is a proxy for a Merrill Lynch Equity Index fund, IWN is a proxy for Merrill Lynch Small Cap fund, EEM is a proxy for MSRIX and VTXVX is a proxy for Retirement Date funds. MSRIX does not yet have 5yr data.

Friday, December 12, 2008

U.S.Government 401k (TSP) Scan 11/30/2008




The funds in the scan were the same as the earlier scan; Fund G, Fund F, Fund C, Fund S, and Fund I. The Balanced portfolio by rule has money in only funds with positive 5yr Sharpe ratios and here that means only Fund G and Fund F. The uniform portfolio has equal amounts in all five funds. The 3 equity funds track the S&P500 Index (Fund C), the Wilshire 4500 Index (Fund S) and the EAFE Stock Index (Fund I). As you can see in the 3D image the Balanced portfolio is basically Fund G with a small amount of Fund F. In December of 2007 the TSP plan added several Lifecycle funds designated L Income, L 2040, L 2030, L2020, L2010 and these will be in future scans.

Thursday, December 11, 2008

ZOLL Medical 401k (ESP) PSDS Scan 10/31/2008




The funds in the ZOLL Medical scan were NBGNX, PCFAX, AMEIX, FDVAX, FDAXX, FDAFX, FMCDX, FABLX, NFJEX, FDIAX, PEOPX, FNIAX, CMUAX, BBHIX, FAFEX, and FAFFX. There were several more Fidelity Advisor target retirement funds with small amounts invested in them. As always the Balanced portfolio only has money in funds with positive 5yr Sharpe ratios.

Wednesday, December 10, 2008

Massachusetts Institute of Technoloy 401k Scan




The MIT 401k is managed by Fidelity and several of the funds are seperately managed and have only Fidelity Code numbers, no exchange symbols. The funds in the scan were FTRXX, FEQTX, FFIDX, FBGRX, FSEMX, FDIVX, FC01687, FC5024, FC01685, and FC01686. These funds are Fidelity Bond Pool FC01685, Bond Oriented Balanced Fund FC01686, Diversified Stock Fund FC01687 and FC5024 Fidelity U.S. Equity Index Commingled Pool Class 2.


Tuesday, December 9, 2008

Scientific Atlanta 401k Before 2005 CISCO Buyout

I planned to scan the Scientific Atlanta 401k only to find they had been bought by CISCO in 2005. I went ahead and looked at the Funds in the 2005 401k with more than 5% of the plan which included company stock. The stock was selling at 33 on 12/31/2004 per the 11-k filing and CISCO paid 43 in cash for the company stock. Unlike recent events with company stock in almost every company down sharply, here was a case where the Employee's 401k portfolios benefited from their company stock holdings. I liked that. The FMIP2 symbol stands for the Fidelity Managed Income Portfolio II which is not traded on a public exchange.

Saturday, December 6, 2008

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




The Moody's 401k (Profit Participation Plan) was scanned earlier without the company stock, MCO, and two trust funds. Those are included in this 10/31/2008 scan with very different market data. The funds in the scan were NMIRX, FBIDX, PTTRX, LZEMX, MLAAX, RWR, GCMAX, FFFAX, FFFFX, FEQIX, FLPSX, FMCSX, FDIVX, FSEMX, FSIIX, FC5024, and MCO where NMIRX is a proxy for a Fidelity stable value fund that has most of the employee money, FC5024 is a Fidelity SMA trust named "US Equity Index Commingled Pool" and the Balanced portfolio has money only in funds with positive 5yr Sharpe ratios.


Wednesday, December 3, 2008

SAIC 401k (RP) PSDS Scan 10/31/2008




The SAIC 401k (Retirement Plan) has money in company stock (SAI) but it has only been a public company for a couple of years and no 5yr data are available. The funds in the scan were VBMFX, VBSIX, VFINX, VMMXX, VMCIX, VDMIX, VWNDX, VWIGX, PTTRX, NAESX, VSCGX, VSMGX, VASGX, DODGX, TRMCX, LLSCX, MGEMX, RPMGX, VEXPX, VTENX, VTXVX, and VPMCX. I only included a couple of Target Retirment funds because most had very little money in them.

Stanton & Castleton IRA PSDS Scan 10/31/2008




The Stanton & Castleton IRA has been rebalanced to reflect market changes and a few new funds were added to reduce volatility. The funds in the scan were BTFTX, DODFX, FAIRX, FICDX, FLPSX, LSBDX, OAKBX, PRPFX, PRWCX, RYVFX, SGENX, TAVFX and FIDXX. The FIDXX fund is a proxy for a money market fund and OAKBX was added when it reopened and became available. The numbers have changed a lot since July and like everyone in the market that change was a reduction. The LSBDX bond fund is now yielding 11% at current market prices for the fund which is down almost 30%.

Monday, December 1, 2008

Colorado PERA 401k Plan PSDS Scan 10/31/2008




The Colorado Public Employee Retirement Association (PERA) 401k Plan funds in the scan were NSIUX, PTLAX, PTTRX, DODBX, VINIX, DODGX, TRGIX, FCNTX, AGTHX, AEPGX, NAESX, FFFAX, FFFCX, FFFFX where TRGIX was a proxy for a PERA growth & income stock fund and AGTHX was a proxy for GMGTX which does not yet have 5yr data.