Monday, November 24, 2008

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.


Thursday, November 20, 2008

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.

Tuesday, November 18, 2008

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.


Monday, November 17, 2008

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.

Friday, November 14, 2008

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.

Wednesday, November 12, 2008

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.

Sunday, November 9, 2008

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.