Civic Intelligence
Filing

Source Code Inc. 401K Plan

Source Code Inc. • EIN 04-3150778 • Plan year 2011

Filing Insights

Participants

Down

106 → 92

-14 • -13.21%

Assets

Up

$2,589,143 → $2,798,498

$209,355 • 8.09%

Investment Management Fee

0.13%

$3,624

Admin expenses $3,624 • Total expenses $4,618

Filing Details

Context
Net investment result
$209,355
Accountant opinion
Disclaimer of opinion
Pension payor EIN
01-0233346

Status Flags

Fidelity bond in place

Yes

Limited-scope audit performed

Not reported

Contributions transmitted on time

No

Participant loans in default

No

Leases in default

No

Reportable party-in-interest issues

No

Loss discovered during year

No

Assets with undetermined value

No

Non-cash contributions

No

Assets held for investment

Yes

5% transactions reported

No

All plan assets distributed

No

Benefits paid when due

No

Plan blackout period

No

Plan termination resolution adopted

No

Counterparties
Known direct compensation$1440.01%
ProviderServicesLocationDirect CompensationRelated
JOHN HANCOCK LIFE INSURANCE COMPANYEIN 01-0233346Contract administration-$1440.01%
FEELEY & DRISCOLL, P.C.EIN 04-2684828Accountant, Disclaimer of opinion--

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
20172156$8,576,345$2,148,138$13,770iApproximate average salary by contribution assumption: employee only about $344,253 at 4% or $229,502 at 6%; with 50% employer match about $229,502 at 4% or $153,001 at 6%; with 100% employer match about $172,126 at 4% or $114,751 at 6%.
Source Code Inc. 401K Plan-156$8,576,345$2,148,138$13,770iApproximate average salary by contribution assumption: employee only about $344,253 at 4% or $229,502 at 6%; with 50% employer match about $229,502 at 4% or $153,001 at 6%; with 100% employer match about $172,126 at 4% or $114,751 at 6%.
Source Code Corporation Employee Medical Only Benefit Plan-0---
20161130$5,678,539$515,083$3,962iApproximate average salary by contribution assumption: employee only about $99,054 at 4% or $66,036 at 6%; with 50% employer match about $66,036 at 4% or $44,024 at 6%; with 100% employer match about $49,527 at 4% or $33,018 at 6%.
Source Code Inc. 401K Plan-130$5,678,539$515,083$3,962iApproximate average salary by contribution assumption: employee only about $99,054 at 4% or $66,036 at 6%; with 50% employer match about $66,036 at 4% or $44,024 at 6%; with 100% employer match about $49,527 at 4% or $33,018 at 6%.
2015164$4,860,775$529,378$8,272iApproximate average salary by contribution assumption: employee only about $206,788 at 4% or $137,859 at 6%; with 50% employer match about $137,859 at 4% or $91,906 at 6%; with 100% employer match about $103,394 at 4% or $68,929 at 6%.
Source Code Inc. 401K Plan-64$4,860,775$529,378$8,272iApproximate average salary by contribution assumption: employee only about $206,788 at 4% or $137,859 at 6%; with 50% employer match about $137,859 at 4% or $91,906 at 6%; with 100% employer match about $103,394 at 4% or $68,929 at 6%.
2014255$4,344,261$262,259$4,768iApproximate average salary by contribution assumption: employee only about $119,209 at 4% or $79,472 at 6%; with 50% employer match about $79,472 at 4% or $52,982 at 6%; with 100% employer match about $59,604 at 4% or $39,736 at 6%.
Source Code Inc. 401K Plan-55$4,344,261$262,259$4,768iApproximate average salary by contribution assumption: employee only about $119,209 at 4% or $79,472 at 6%; with 50% employer match about $79,472 at 4% or $52,982 at 6%; with 100% employer match about $59,604 at 4% or $39,736 at 6%.
Source Code Corporation Employee Medical Only Benefit Plan-52---
2013154$4,005,948$363,049$6,723iApproximate average salary by contribution assumption: employee only about $168,078 at 4% or $112,052 at 6%; with 50% employer match about $112,052 at 4% or $74,701 at 6%; with 100% employer match about $84,039 at 4% or $56,026 at 6%.
Source Code Inc. 401K Plan-54$4,005,948$363,049$6,723iApproximate average salary by contribution assumption: employee only about $168,078 at 4% or $112,052 at 6%; with 50% employer match about $112,052 at 4% or $74,701 at 6%; with 100% employer match about $84,039 at 4% or $56,026 at 6%.
2012188$3,263,717$209,864$2,385iApproximate average salary by contribution assumption: employee only about $59,620 at 4% or $39,747 at 6%; with 50% employer match about $39,747 at 4% or $26,498 at 6%; with 100% employer match about $29,810 at 4% or $19,873 at 6%.
Source Code Inc. 401K Plan-88$3,263,717$209,864$2,385iApproximate average salary by contribution assumption: employee only about $59,620 at 4% or $39,747 at 6%; with 50% employer match about $39,747 at 4% or $26,498 at 6%; with 100% employer match about $29,810 at 4% or $19,873 at 6%.
2011192$2,798,498$235,400$2,559iApproximate average salary by contribution assumption: employee only about $63,967 at 4% or $42,645 at 6%; with 50% employer match about $42,645 at 4% or $28,430 at 6%; with 100% employer match about $31,984 at 4% or $21,322 at 6%.
Source Code Inc. 401K PlanCurrent92$2,798,498$235,400$2,559iApproximate average salary by contribution assumption: employee only about $63,967 at 4% or $42,645 at 6%; with 50% employer match about $42,645 at 4% or $28,430 at 6%; with 100% employer match about $31,984 at 4% or $21,322 at 6%.
2010293$2,598,006$462,654$4,975iApproximate average salary by contribution assumption: employee only about $124,369 at 4% or $82,913 at 6%; with 50% employer match about $82,913 at 4% or $55,275 at 6%; with 100% employer match about $62,185 at 4% or $41,456 at 6%.
Source Code Inc. 401K Plan-93$2,589,143$238,193$2,561iApproximate average salary by contribution assumption: employee only about $64,030 at 4% or $42,687 at 6%; with 50% employer match about $42,687 at 4% or $28,458 at 6%; with 100% employer match about $32,015 at 4% or $21,343 at 6%.
Source Code Corporation Employee Medical Only Benefit Plan-52$8,863$224,461$4,317iApproximate average salary by contribution assumption: employee only about $107,914 at 4% or $71,943 at 6%; with 50% employer match about $71,943 at 4% or $47,962 at 6%; with 100% employer match about $53,957 at 4% or $35,971 at 6%.
2009287$2,198,048$449,619$5,168iApproximate average salary by contribution assumption: employee only about $129,201 at 4% or $86,134 at 6%; with 50% employer match about $86,134 at 4% or $57,423 at 6%; with 100% employer match about $64,600 at 4% or $43,067 at 6%.
Source Code Inc. 401K Plan-87$2,198,048$247,423$2,844iApproximate average salary by contribution assumption: employee only about $71,099 at 4% or $47,399 at 6%; with 50% employer match about $47,399 at 4% or $31,599 at 6%; with 100% employer match about $35,549 at 4% or $23,700 at 6%.
Source Code Corporation Employee Medical Only Benefit Plan-36-$202,196$5,617iApproximate average salary by contribution assumption: employee only about $140,414 at 4% or $93,609 at 6%; with 50% employer match about $93,609 at 4% or $62,406 at 6%; with 100% employer match about $70,207 at 4% or $46,805 at 6%.
2008292$1,506,874$495,783$5,389iApproximate average salary by contribution assumption: employee only about $134,724 at 4% or $89,816 at 6%; with 50% employer match about $89,816 at 4% or $59,877 at 6%; with 100% employer match about $67,362 at 4% or $44,908 at 6%.
Source Code Inc. 401K Plan-92$1,506,874$266,237$2,894iApproximate average salary by contribution assumption: employee only about $72,347 at 4% or $48,231 at 6%; with 50% employer match about $48,231 at 4% or $32,154 at 6%; with 100% employer match about $36,174 at 4% or $24,116 at 6%.
Source Code Corporation Employee Medical Only Benefit Plan-45-$229,546$5,101iApproximate average salary by contribution assumption: employee only about $127,526 at 4% or $85,017 at 6%; with 50% employer match about $85,017 at 4% or $56,678 at 6%; with 100% employer match about $63,763 at 4% or $42,509 at 6%.
2007583$2,067,158$203,254$2,449iApproximate average salary by contribution assumption: employee only about $61,221 at 4% or $40,814 at 6%; with 50% employer match about $40,814 at 4% or $27,209 at 6%; with 100% employer match about $30,611 at 4% or $20,407 at 6%.
Source Code Inc. 401K Plan-83$2,067,158$203,254$2,449iApproximate average salary by contribution assumption: employee only about $61,221 at 4% or $40,814 at 6%; with 50% employer match about $40,814 at 4% or $27,209 at 6%; with 100% employer match about $30,611 at 4% or $20,407 at 6%.
SOURCE CODE CORPORATION SELF FUNDED MEDICAL REIMBURSEMENT PLAN-0---
Source Code Corporation Employee Medical Only Benefit Plan-37---
SOURCE CODE MID-WEST EMPLOYEE MEDICAL ONLY BENEFIT PLAN-0---
INTEGRATED IT SOLUTIONS EMPLOYEE MEDICAL ONLY BENEFIT PLAN-0---
2006271$1,784,917$340,618$4,797iApproximate average salary by contribution assumption: employee only about $119,936 at 4% or $79,957 at 6%; with 50% employer match about $79,957 at 4% or $53,305 at 6%; with 100% employer match about $59,968 at 4% or $39,979 at 6%.
Source Code Inc. 401K Plan-71$1,775,906$187,844$2,646iApproximate average salary by contribution assumption: employee only about $66,142 at 4% or $44,095 at 6%; with 50% employer match about $44,095 at 4% or $29,397 at 6%; with 100% employer match about $33,071 at 4% or $22,047 at 6%.
SOURCE CODE CORPORATION SELF FUNDED MEDICAL REIMBURSEMENT PLAN-0$9,011$152,774-
2005180$1,424,141$167,827$2,098iApproximate average salary by contribution assumption: employee only about $52,446 at 4% or $34,964 at 6%; with 50% employer match about $34,964 at 4% or $23,309 at 6%; with 100% employer match about $26,223 at 4% or $17,482 at 6%.
Source Code Inc. 401K Plan-80$1,424,141$167,827$2,098iApproximate average salary by contribution assumption: employee only about $52,446 at 4% or $34,964 at 6%; with 50% employer match about $34,964 at 4% or $23,309 at 6%; with 100% employer match about $26,223 at 4% or $17,482 at 6%.
2004185$1,171,186$228,085$2,683iApproximate average salary by contribution assumption: employee only about $67,084 at 4% or $44,723 at 6%; with 50% employer match about $44,723 at 4% or $29,815 at 6%; with 100% employer match about $33,542 at 4% or $22,361 at 6%.
Source Code Inc. 401K Plan-85$1,171,186$228,085$2,683iApproximate average salary by contribution assumption: employee only about $67,084 at 4% or $44,723 at 6%; with 50% employer match about $44,723 at 4% or $29,815 at 6%; with 100% employer match about $33,542 at 4% or $22,361 at 6%.
20031100$1,031,150$285,829$2,858iApproximate average salary by contribution assumption: employee only about $71,457 at 4% or $47,638 at 6%; with 50% employer match about $47,638 at 4% or $31,759 at 6%; with 100% employer match about $35,729 at 4% or $23,819 at 6%.
Source Code Inc. 401K Plan-100$1,031,150$285,829$2,858iApproximate average salary by contribution assumption: employee only about $71,457 at 4% or $47,638 at 6%; with 50% employer match about $47,638 at 4% or $31,759 at 6%; with 100% employer match about $35,729 at 4% or $23,819 at 6%.
20021124$666,498$68,904$556iApproximate average salary by contribution assumption: employee only about $13,892 at 4% or $9,261 at 6%; with 50% employer match about $9,261 at 4% or $6,174 at 6%; with 100% employer match about $6,946 at 4% or $4,631 at 6%.
Source Code Inc. 401K Plan-124$666,498$68,904$556iApproximate average salary by contribution assumption: employee only about $13,892 at 4% or $9,261 at 6%; with 50% employer match about $9,261 at 4% or $6,174 at 6%; with 100% employer match about $6,946 at 4% or $4,631 at 6%.
2001144$0$0-
Source Code Inc. 401K Plan-44---
2000130$0$0-
Source Code Inc. 401K Plan-30---
1999251$317,186$226,848$4,448iApproximate average salary by contribution assumption: employee only about $111,200 at 4% or $74,133 at 6%; with 50% employer match about $74,133 at 4% or $49,422 at 6%; with 100% employer match about $55,600 at 4% or $37,067 at 6%.
Source Code Inc. 401K Plan-51$171,078$168,114$3,296iApproximate average salary by contribution assumption: employee only about $82,409 at 4% or $54,939 at 6%; with 50% employer match about $54,939 at 4% or $36,626 at 6%; with 100% employer match about $41,204 at 4% or $27,470 at 6%.
Source Code Inc. 401K Plan-28$146,108$58,734$2,098iApproximate average salary by contribution assumption: employee only about $52,441 at 4% or $34,961 at 6%; with 50% employer match about $34,961 at 4% or $23,307 at 6%; with 100% employer match about $26,221 at 4% or $17,480 at 6%.
Schedule Details

Schedule A

Row 1
Form Id
1
Ins Broker Name
THE ANGELL PENSION GROUP
Ins Broker US Address1
10 HEMINGWAY DRIVE
Ins Broker US City
EAST PROVIDENCE
Ins Broker US State
RI
Ins Broker US ZIP
02915
Ins Broker Fees Pd Amount
$4,904
Ins Broker Fees Pd Text
TPA FEES AND TPA COMPENSATION
Ins Broker Code
5
Row 2
Form Id
1
Ins Broker Name
MML INSURANCE AGENCY, LLC
Ins Broker US Address1
P.O. BOX 219062
Ins Broker US City
KANSAS CITY
Ins Broker US State
MO
Ins Broker US ZIP
64121
Ins Broker Comm Pd Amount
$10,965
Ins Broker Code
3
Row 3
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY USA
Form Id
1
Schedule A Plan Year Begin Date
2011-01-01
Schedule A Plan Year End Date
2011-12-31
Schedule A Plan Num
001
Schedule A EIN
04-3150778
Ins Carrier Name
JOHN HANCOCK LIFE INSURANCE COMPANY USA
Ins Carrier EIN
01-0233346
Ins Carrier Naic Code
65838
Ins Contract Num
77207
Ins Prsn Covered End of year Count
57
Ins Policy From Date
2011-01-01
Ins Policy To Date
2011-12-31
Ins Broker Comm Total Amount
$10,965
Ins Broker Fees Total Amount
$4,904
Pension End of year Sep Account Amount
$2,515,882
Alloc Contracts Indiv Indicator
No
Alloc Contracts Group Indicator
No
Alloc Contracts Other Indicator
No
Pens Distr Bnft Terminate Pln Indicator
No
Unalloc Contracts Dep Adm Indicator
No
Unal Contrac Imm Part Guar Indicator
No
Unal Contracts Guar Invest Indicator
No
Unalloc Contracts Other Indicator
No
Pension End Prev Bal Amount
$0
Pension Divnd Cr Dep Amount
$0
Pension Total Additions Amount
$0
Pension Total Bal Addn Amount
$0
Pension Total Ded Amount
$0
Pension End of year Bal Amount
$0
Wlfr Bnft Health Indicator
No
Wlfr Bnft Dental Indicator
No
Wlfr Bnft Vision Indicator
No
Wlfr Bnft Life Insur Indicator
No
Wlfr Bnft Temp Disab Indicator
No
Wlfr Bnft Long Terminate Disab Indicator
No
Wlfr Bnft Unemp Indicator
No
Wlfr Bnft Drug Indicator
No
Wlfr Bnft Stop Loss Indicator
No
Wlfr Bnft Hmo Indicator
No
Wlfr Bnft Ppo Indicator
No
Wlfr Bnft Indemnity Indicator
No
Wlfr Bnft Other Indicator
No
Wlfr Total Earned Prem Amount
$0
Wlfr Incurred Claim Amount
$0
Wlfr Ret Total Amount
$0
Wlfr Refund Cash Indicator
No
Wlfr Refund Credit Indicator
No
Ins Fail Provide Info Indicator
No

Schedule C

Schedule C Provider

JOHN HANCOCK LIFE INSURANCE COMPANY

RECORDKEEPER • EIN 01-0233346

Direct compensation$144
Contract administration
Indirect compensationNo
Source fields
Row 1
Service code: Contract administration
Service code
Contract administration
JOHN HANCOCK LIFE INSURANCE COMPANY
Other provider name
JOHN HANCOCK LIFE INSURANCE COMPANY
Other provider EIN
01-0233346
Relationship to employer or plan
RECORDKEEPER
Direct compensation
$144
Indirect compensation reported
No

Schedule C Provider

Provider 2

Provider details

Source fields
Row 3
Excluded provider reported
No

Schedule D

Row 1
DFE P1 Entity Name
RETIREMENT LIVING AT 2045
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$33,951
Row 2
DFE P1 Entity Name
LIFESTYLE BALANCED
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$233,166
Row 3
DFE P1 Entity Name
LIFESTYLE MODERATE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$8,424
Row 4
DFE P1 Entity Name
LIFESTYLE CONSERVATIVE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 5
DFE P1 Entity Name
REAL EST. SECURITIES FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 6
DFE P1 Entity Name
NATURAL RESOURCES FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$9,744
Row 7
DFE P1 Entity Name
DFA EMERGING MARKETS VALUE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$17,608
Row 8
DFE P1 Entity Name
ROYCE OPPORTUNITY
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$1,473
Row 9
DFE P1 Entity Name
INTL SMALL CAP FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$10,485
Row 10
DFE P1 Entity Name
FIDELITY ADV LEVERAGED CO STK
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$1,417
Row 11
DFE P1 Entity Name
INTERNATIONAL OPPS FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$12,192
Row 12
DFE P1 Entity Name
RETIREMENT LIVING AT 2040
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$86,541
Row 13
DFE P1 Entity Name
OPPENHEIMER DEVELOPING MKT
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$12,245
Row 14
DFE P1 Entity Name
ENERGY
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$170,331
Row 15
DFE P1 Entity Name
DFA US TARGETED VALUE FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 16
DFE P1 Entity Name
COLUMBIA VALUE & RESTRUCTURING
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 17
DFE P1 Entity Name
T. ROWE PRICE SCI & TECH
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$91,466
Row 18
DFE P1 Entity Name
DFA U.S. SMALL CAP FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 19
DFE P1 Entity Name
SMALL CAP GROWTH INDEX
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$79
Row 20
DFE P1 Entity Name
INTL EQUITY INDEX FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$12,088
Row 21
DFE P1 Entity Name
SCIENCE & TECHNOLOGY FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,013
Row 22
DFE P1 Entity Name
JOHN HANCOCK INTL GROWTH
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 23
DFE P1 Entity Name
RETIREMENT LIVING AT 2035
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$116,982
Row 24
DFE P1 Entity Name
EXPLORER
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,255
Row 25
DFE P1 Entity Name
SMALL CAP GROWTH FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 26
DFE P1 Entity Name
OPPENHEIMER INTL GROWTH FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,376
Row 27
DFE P1 Entity Name
EUROPACIFIC GROWTH FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$186
Row 28
DFE P1 Entity Name
FRANKLIN SMALL-MID GROWTH
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$10,912
Row 29
DFE P1 Entity Name
LEGG MASON CLEARBR AGG GROWTH
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$6,923
Row 30
DFE P1 Entity Name
T. ROWE PRICE HEALTH SCI
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$31,213
Row 31
DFE P1 Entity Name
COLUMBIA MID CAP VALUE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 32
DFE P1 Entity Name
BLUE CHIP GROWTH FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 33
DFE P1 Entity Name
MID CAP INDEX FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 34
DFE P1 Entity Name
RETIREMENT LIVING AT 2030
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$55,845
Row 35
DFE P1 Entity Name
OPPENHEIMER GLOBAL
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$14,351
Row 36
DFE P1 Entity Name
MID VALUE FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 37
DFE P1 Entity Name
UTILITIES FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,194
Row 38
DFE P1 Entity Name
MFS UTILITIES
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$33,612
Row 39
DFE P1 Entity Name
THE GROWTH FUND OF AMERICA
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$23,145
Row 40
DFE P1 Entity Name
FIDELITY CONTRAFUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$6,172
Row 41
DFE P1 Entity Name
FIDELITY ADV NEW INSIGHTS
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$3,006
Row 42
DFE P1 Entity Name
LARGE CAP FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 43
DFE P1 Entity Name
DAVIS NEW YORK VENTURE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 44
DFE P1 Entity Name
T. ROWE PRICE EQUITY INC
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,146
Row 45
DFE P1 Entity Name
RETIREMENT LIVING AT 2025
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$159,972
Row 46
DFE P1 Entity Name
500 INDEX FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 47
DFE P1 Entity Name
MUTUAL BEACON
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 48
DFE P1 Entity Name
INVESTMENT COMPANY OF AMERICA
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$6,080
Row 49
DFE P1 Entity Name
CORE GLOBAL DIVERSIFICATION
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$2,957
Row 50
DFE P1 Entity Name
PIMCO ALL ASSET
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,108
Row 51
DFE P1 Entity Name
MUTUAL GLOBAL DISCOVERY
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$5,554
Row 52
DFE P1 Entity Name
PIMCO GLOBAL BOND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$185,066
Row 53
DFE P1 Entity Name
PIMCO REAL RETURN
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$202,714
Row 54
DFE P1 Entity Name
T. ROWE PRICE SPECTRUM INC
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$351,815
Row 55
DFE P1 Entity Name
PIMCO TOTAL RETURN
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 56
DFE P1 Entity Name
RETIREMENT LIVING AT 2020
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$55,760
Row 57
DFE P1 Entity Name
TOTAL BOND MARKET FUND
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$0
Row 58
DFE P1 Entity Name
RETIREMENT LIVING AT 2015
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$26,113
Row 59
DFE P1 Entity Name
LIFESTYLE AGGRESSIVE
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$107,130
Row 60
DFE P1 Entity Name
LIFESTYLE GROWTH
DFE P1 Spons Name
JOHN HANCOCK USA
DFE P1 Plan EIN
01-0233346
DFE P1 Plan Plan number
000
DFE P1 Entity Code
P
DFE P1 Plan Interest End of year Amount
$378,069
Row 61
Schedule D Plan Year Begin Date
2011-01-01
Schedule D Tax Period
2011-12-31
Schedule D Plan number
001
Schedule D EIN
04-3150778

Schedule H

Schedule H Financial Statement

Large plan result

Assets, contributions, fees, audit, and compliance fields reported for this large-plan filing.

End-of-year assets$2,798,498$209,355 change

Balance Sheet

Beginning and end of plan year.

Total assets$2,589,143$2,798,498Increase +$209,355 (8.09%)
Total liabilities$0$0No change $0
Net assets$2,589,143$2,798,498Increase +$209,355 (8.09%)

Contributions

Participant contributions$235,400
Total contributions$235,400

Income & Investment Result

Total income$213,973
Interest$1,470
Dividends$0
Net income$209,355

Expenses & Fees

Benefits paid$994
Administrative expenses$3,624
Total expenses$4,618

Accountant

FirmFEELEY & DRISCOLL, P.C.
Firm EIN04-2684828
OpinionDisclaimer of opinion

Compliance

Fidelity bondYes
Fidelity bond amount$500,000
Participant loans$49,300
Late contributionsNo
Schedule H source fields
Financial summary
Total assets at beginning of year: $2,589,143Total assets at end of year: $2,798,498Total liabilities at end of year: $0Net income or loss: $209,355
Schedule H Plan Year Begin Date
2011-01-01
Schedule H Tax Period
2011-12-31
Schedule H Plan number
001
Schedule H EIN
04-3150778
Non Interest Bear Cash Beginning of year Amount
$63
Participants Contribution Beginning of year Amount
$2,680
Participant loans at beginning of year
$46,972
Interest Pool Sep Account Beginning of year Amount
$2,539,428
Total assets at beginning of year
$2,589,143
Total liabilities at beginning of year
$0
Net assets at beginning of year
$2,589,143
Non Interest Bear Cash End of year Amount
$1,747
Participants Contribution End of year Amount
$2,644
Participant loans at end of year
$49,300
Interest Pool Sep Account End of year Amount
$2,515,882
Oth Investment End of year Amount
$228,925
Total assets at end of year
$2,798,498
Total liabilities at end of year
$0
Net assets at end of year
$2,798,498
Participant contributions
$235,400
Total contributions
$235,400
Interest on participant loans
$1,470
Total interest income
$1,470
Total dividend income
$0
Net gain or loss on sale of assets
$0
Net unrealized appreciation or depreciation
$0
Gain Loss Pool Sep Amount
$-22,897
Total income
$213,973
Participant distributions
$994
Total benefit distributions
$994
Contract Admin Fees Amount
$144
Other Admin Fees Amount
$3,480
Total administrative expenses
$3,624
Total expenses
$4,618
Net income or loss
$209,355
Accountant opinion type
Disclaimer of opinion
Account Performed Limited Audit Indicator
Yes
Accountant firm name
FEELEY & DRISCOLL, P.C.
Accountant firm EIN
04-2684828
Failed to transmit participant contributions on time
No
Participant loans in default
No
Leases in default
No
Nonexempt transactions with parties in interest
No
Fidelity bond in place
Yes
Fidelity bond amount
$500,000
Loss discovered during year
No
Assets with undetermined value
No
Non-cash contributions reported
No
Assets held for investment
Yes
Reportable 5% transactions
No
All plan assets distributed
No
Failed to provide benefits when due
No
Blackout period occurred
No
Resolution to terminate plan adopted
No

Schedule R

Schedule R Pension Information

Retirement plan characteristics

Testing, payor, opinion-letter, and transfer information reported with the filing.

Pension & Payor

Payor EIN01-0233346

Transfers

Asset/liability transferNo
Liabilities in multiple plansNo
Distributed property value$0
Schedule R source fields
Payor 01-0233346
Schedule R Plan Year Begin Date
2011-01-01
Schedule R Tax Period
2011-12-31
Schedule R Plan number
001
Schedule R EIN
04-3150778
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
01-0233346
Asset or liability transfer
No
Liability shared by multiple plans
No

Filing received by DOL Jul 10, 2012