Sunday, February 22, 2009

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




This plan had over $1.3B in company stock (PFE) according to the 12/31/2007 SEC11-K data which resulted in a negative 5yr APR of -2.41% for the employee portfolio. The scan used SPY and IWM as proxies for two NTGI - OM Collective funds, a Daily S&P 500 Equity Index and a Daily Russell 2000 Equity Index. The Capital Guardian All Country (ex-US) Equity collective trust is labled ACWEQ in the correlation chart. It has no ticker symbol but the fund performance data were available on the web. The plan also had a $348M in a stable value fund and FUND G from the US Government 401k (TSP) plan was used as a proxy for the stable value fund. I used AGG as a proxy for Barclays Global Investors US Debt Index Fund but a slightly better proxy would have been FUND F from the US Government 401k (TSP) plan which tracks the same index. I did rerun the scan with FUND F and there was stochastically no difference.

No comments: