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.