TRW Automotive 401k PSDS Scan 10/31/2008

The TRW Automotive 401k has company stock, TRW, as its fourth largest holding and that has significantly reduced Employee portfolio performance. The Balanced portfolio by rule has no money invested in any holding with a negative 5yr Sharpe ratio. The funds in the scan were; AEPGX, ARTMX, DODBX, DODFX, RRRAX, FDCAX, FFFAX, FRTXX, FSLCX, FFFCX, LAVLX, LRSCX, MSIQX, PTRAX, FUSEX, and TRW.

State of Ohio 401k Plan PSDS Scan 10/31/2008

The funds in the scan were; FCNTX, FDGRX, FMAGX, JAVLX, FPPTX, VSCIX, TEMFX, VWILX, VGTSX, VINIX, VHCAX, DODGX, PTRAX, VBMFX, NMIRX where NMIRX is a proxy for a stable value fund.

State of Michigan 401k Plan Scan 10/31/2008

Most of the funds in the 401k plan are SSga funds and several do not have 5yr data and proxies were used for them. The proxies were VTINX for a target retirement income fund, VMMXX for a Yield enhanced STIF, NMIRX for a stable value fund, and three ETF funds for a MidCap, a Russell 2000 and a LargeCapGrowth index fund. The funds in the scan were; VTINX, FFFCX, VMMXX, NMIRX,SSBMX, SVSPX, MDY, IWM, WAPIX, IMTAX, DODGX, IVW, LAVLX, ARTMX, ACRNX, SASVX, ABIAX, AEPGX and SSEMX.

Smithfield Foods 401k PSDS Scan 10/31/2008

The funds in the scan were CVGRX, MEIAX, AEPGX, SMVAX, SPY, NMIRX, WFCDX, SFD where SPY is a proxy for WFVEX which does not yet have 5yr data and NMIRX is a proxy for a Smithfield stable value fund. The employees make company stock, SFD, their third largest holding. As always the Balanced portfolio has money in only funds with positive 5yr Sharpe ratios, here they are MEIAX, AEPGX, and SMVAX.

GoodrichRohr 401k (PSSP) Plan 10/31/2008

There were 17 funds and Goodyear stock in the scan; FGRIX, FMAGX, FASIX, FSHBX, FDEQX, FRTXX, FOSFX, FPURX, FCNTX, FDFFX, FBGRX, FEQTX, FUSEX, JAOSX, JAWWX, NBGTX, and GR. Only 3 of the funds and GR had positive 5yr Sharpe ratios which means by rule the Balanced portfolio has money in only these 4 investments, FRTXX, FCNTX, JAOSX and GR.

Burlington Northern Santa Fe 401k Scan 10/31/2008

The Burlington Northern Sante Fe employees are most invested in a T.Rowe Price Stable Value Common Trust and have a smaller amount in company stock, BNI, which still has a positive 5yr total return. The scan used NMIRX as a proxy for the stable value trust and SPY for an equity trust. The funds in the scan were NMIRX, SPY, RPBAX, BNI, TRBCX, PRFDX, BJBIX, PTTRX, TRRAX, LAUAX, and TRRBX.

Textron 401k (TSP) PSDS Scan 10/31/2008

The Textron 401k (Textron Savings Plan) was heavily invested in Textron stock, TXT, which up until 2008 had been a good investment. Today it has a negative 5yr return. The funds in the scan were, VINIX, FDIVX, FEQIX, FBGRX, FSLCX, PTTRX, VSEQX, VIDMX, FFFDX, FFFCX, VWEHX, TXT. The Balanced portfolio by rule is only invested in funds with a positive 5yr Sharpe ratio, they were FDIVX, PTTRX and VIDMX.

BorgWarner 401k Plan Scan 10/31/2008

This BorgWarner scan is the first using 10/31/2008 market data. The 10/31/08 market results are so bad that only one fund and BorgWarner stock had a positive 5yr Sharpe ratio. The Balanced Portfolio by rule has money in only those two, BWA and HAINX, while the Employees have money invested in all 6 funds in the scan.

The six funds were VFINX, NMIRX, HAINX, VIMAX and BUFXS. Note that VFINX ia a proxy for INDXQ (Fund C in Federal Employee's 401k) and NMIRX is a proxy for plan GICs. The plan also has a collective trust fund.

Agilent 401k Plan PSDS Scan 9/30/2008

The funds in the scan were, AGG, EFA, VIPSX, HRIGX, TEMFX, PTTRX, DIEQX, GCSAX, VGSIX, FMAGX, FCNTX, FLPSX, FUSEX, FFFAX, FFFDX, VITSX, and A where AGG, EAF and VIPSX were proxies for BGI funds with no 5yr data yet. Also, VITSX was a proxy for the many individual Common stocks in a 401k plan trust. As is sometimes the case employee company stock holdings (A is the stock symbol for Agilent) reduced both APR and PSR.

Coca Cola 401K Plan PSDS Scan 9/30/2008

The Coca Cola 401k plan has over 970M in KO stock which does not change the Employee Portfolio APR compared to the Balanced Portfolio but it nearly tripled the STD (risk) and dropped the PSR to less than one. Even before retirement I think an employee should evaluate how much KO he can hold and still be able to meet his retirement income needs. Recent market events remind us all that even the best of stocks are volatile.

Microsoft 401k Plan PSDS Scan 9/30/2008

In this scan of the Microsoft 401k includes employee investments in Microsoft stock, MSFT, which is the largest holding in the plan; 900M out of 5.427B dollars. This data is from their SEC 11-k filing. Actual employee holdings compare well with the Balanced portfolio with a lower PSR because of the large MSFT holding which increased STD but had little effect on APR. The Balanced portfolio had 12.6% in MSFT while the employees have 17.8% in MSFT. Note the scan has only 5.067B because 316M are in a Trust account and 44M are in employee loans.

Medicis Pharmaceutical 401k PSDS Scan 9/30/2008

The 42 funds in the scan were; AIVSX, EGLRX, GCMAX, MEIAX, PTTRX, TGVIX, BISCX, BIGIX, ABVYX, BLUEX, PPRDX, BWFAX, CGMFX, DFGBX, DFREX, DFGFX, DFLVX, DFLCX, DFSCX, DODIX, DODFX, FKACX, HCAIX, AMECX, JAVLX, JAWWX, LSBDX, MFOCX, NBFAX, OAKMX, TAHYX, PRMSX, SPY, PRASX, TEPLX, VFIRX, VQNPX, VIPSX, TRRCX, NMIRX
where EGLRX & SPY were proxies for funds without 5yr data and NMIRX was a proxy for a Schwab stable value fund.

Amgen 401k Plan PSDS Scan 9/30/2008

The 10 funds in the scan were FUSEX, FCNTX, NBGNX, VGSIX, PHIYX, FSHBX, FFFAX, FFFCX, VGTSX, EFA where VGTSX and EFA were proxies for the many individual stocks held in a 401k plan trust.