Attachment A -- 401k Plan Assets and Contributions.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
(NAF) Bundled 401(k) Plan
Solicitation number
HDQMWR-12-R-0005
Issued by

About this file

Attachment A

View the file

Other files

File Type Posted
SF 30 -MOD 0001 Q-A.docx DOCX document
RFP 12-R-0005 401-(k) Plan.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Assets as of 120111

ASSETS as of 12/1/2011
accountsource typeshares/unitsNAV/priceassets
Premier Money Market (Babson)Before-Tax97,649.33137.627398$13,439,223.55
Company Match37,271.84137.627398$5,129,625.68
Rollover3,722.81137.627398$512,361.15

subtotal $19,081,210.38

accountsource typeshares/unitsNAV/priceassets
Select PIMCO Total ReturnBefore-Tax49,088.10163.140013$8,008,233.89
Company Match20,746.65163.140013$3,384,608.56
Rollover2,922.35163.140013$476,752.63

subtotal $11,869,595.08

accountsource typeshares/unitsNAV/priceassets
RetireSMART In RetirementBefore-Tax12,044.40270.541878$3,258,514.91
Company Match5,370.03270.541878$1,452,818.02
Rollover312.045859270.541878$84,421.47

subtotal $4,795,754.40

accountsource typeshares/unitsNAV/priceassets
RetireSMART 2010Before-Tax7,620.22133.019789$1,013,640.43
Company Match2,418.94133.019789$321,766.96
Rollover26.023147133.019789$3,461.59

subtotal $1,338,868.98

accountsource typeshares/unitsNAV/priceassets
RetireSMART 2020Before-Tax30,072.49242.234998$7,284,609.84
Company Match12,265.33242.234998$2,971,092.97
Rollover607.679767242.234998$147,201.31

subtotal $10,402,904.12

accountsource typeshares/unitsNAV/priceassets
RetireSMART 2030Before-Tax25,468.99226.383025$5,765,748.11
Company Match10,863.94226.383025$2,459,411.45
Rollover746.242654226.383025$168,936.67

subtotal $8,394,096.23

accountsource typeshares/unitsNAV/priceassets
RetireSMART 2040Before-Tax16,574.66244.324319$4,049,593.19
Company Match6,741.37244.324319$1,647,081.19
Rollover303.551506244.324319$74,165.01

subtotal $5,770,839.39

accountsource typeshares/unitsNAV/priceassets
Sel Fundmentl Val (Wellington)Before-Tax15,523.29139.135711$2,159,844.67
Company Match6,391.44139.135711$889,276.97
Rollover705.247584139.135711$98,125.12

subtotal $3,147,246.76

accountsource typeshares/unitsNAV/priceassets
Sel Indexd Eqty (Northrn Trst)Before-Tax20,291.50127.225066$2,581,586.95
Company Match8,036.78127.225066$1,022,479.61
Rollover956.440962127.225066$121,683.26

subtotal $3,725,749.82

accountsource typeshares/unitsNAV/priceassets
Eqty Grth (Am Century)Before-Tax36,322.11148.683371$5,400,493.19
Company Match12,701.53148.683371$1,888,505.83
Rollover805.79374148.683371$119,808.13

subtotal $7,408,807.15

accountsource typeshares/unitsNAV/priceassets
Growth America (American)Before-Tax58,683.1186.328344$5,066,015.83
Company Match24,726.5486.328344$2,134,601.25
Rollover1,281.8586.328344$110,660.17

subtotal $7,311,277.25

accountsource typeshares/unitsNAV/priceassets
Mid Cap Core Equity (Invesco)Before-Tax9,408.85191.888099$1,805,446.00
Company Match3,932.53191.888099$754,605.59
Rollover440.754618191.888099$84,575.57

subtotal $2,644,627.16

accountsource typeshares/unitsNAV/priceassets
Sel SmCoVl(Fed Clov/TRP/ERNST)Before-Tax7,411.27189.222518$1,402,378.26
Company Match2,831.86189.222518$535,851.26
Rollover219.598209189.222518$41,552.93

subtotal $1,979,782.45

accountsource typeshares/unitsNAV/priceassets
Total Return (Royce)Before-Tax1,335.59126.105912$168,425.28
Company Match551.872625126.105912$69,594.40
Rollover162.437246126.105912$20,484.30

subtotal $258,503.98

accountsource typeshares/unitsNAV/priceassets
Sel SmCapGrthEq (W&R/Wllngtn)Before-Tax11,550.98192.977769$2,229,083.15
Company Match4,431.37192.977769$855,156.84
Rollover340.70457192.977769$65,748.41

subtotal $3,149,988.40

accountsource typeshares/unitsNAV/priceassets
Sel Overseas (MFS/Hrs/JPMorgn)Before-Tax8,570.58144.104315$1,235,058.17
Company Match3,536.53144.104315$509,628.61
Rollover690.415138144.104315$99,491.80

subtotal $1,844,178.58

accountsource typeshares/unitsNAV/priceassets
Premier Global (OFI)Before-Tax12,956.05263.079697$3,408,474.65
Company Match4,902.20263.079697$1,289,668.53
Rollover409.37685263.079697$107,698.74

subtotal $4,805,841.92

accountsource typeshares/unitsNAV/priceassets
Sel NASDAQ-100 (Nrthrn Trst)Before-Tax33,272.7558.345714$1,941,322.38
Company Match12,037.3758.345714$702,329.12
Rollover672.0977258.345714$39,214.02

subtotal $2,682,865.52

Total $100,612,137.57

HDQMWR-12-R-0005

Attachment A

Contributions 2010

CONTRIBUTIONS For the period 1/1/2010 to 12/31/2010
descriptionsourceamount
Contribution AllocatedBefore-Tax$9,505,541.74
Company Match$4,303,647.33

subtotal $13,809,189.07

Rollover AllocatedRollover$588,994.93
Unclassified($1,869.66)

subtotal $587,125.27

Total $14,396,314.34

Attachment A

Contributions YTD 2011

CONTRIBUTIONS For the period 1/3/2011 to 12/1/2011
descriptionsourceamount
Contribution AllocatedBefore-Tax$9,485,987.80
Company Match$4,373,604.01

subtotal $13,859,591.81

Rollover AllocatedRollover$922,125.40
Unclassified($444.31)

subtotal $921,681.09

Total $14,781,272.90

Attachment A image1.gif

File details come from the government source that posted it. Updated .