Civic Intelligence
Filing

Source Code Inc. 401K Plan

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

Filing Insights

Participants

Down

102 → 88

-14 • -13.73%

Assets

Up

$2,798,498 → $3,263,717

$465,219 • 16.62%

Investment Management Fee

0.20%

$6,106

Admin expenses $6,106 • Total expenses $71,715

Filing Details

Context
Net investment result
$449,896
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$1340.00%
ProviderServicesLocationDirect CompensationRelated
JOHN HANCOCK LIFE INSURANCE COMPANYEIN 01-0233346Contract administration-$1340.00%
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 PlanCurrent88$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 Plan-92$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
$7,499
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
$4,952
Ins Broker Code
3
Row 3
Form Id
1
Ins Broker Name
NFP SECURITIES
Ins Broker US Address1
1250 S. CAPITAL OF TX
Ins Broker US City
WEST LAKE HILLS
Ins Broker US State
TX
Ins Broker US ZIP
78746
Ins Broker Comm Pd Amount
$4,188
Ins Broker Code
3
Row 4
Form Id
1
Ins Broker Name
GRADIENT SECURITIES, LLC
Ins Broker US Address1
4570 CHURCHILL ST.
Ins Broker US City
SHOREVIEW
Ins Broker US State
MN
Ins Broker US ZIP
55126
Ins Broker Comm Pd Amount
$2,977
Ins Broker Code
3
Row 5
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY USA
Form Id
1
Schedule A Plan Year Begin Date
2012-01-01
Schedule A Plan Year End Date
2012-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
94
Ins Policy From Date
2012-01-01
Ins Policy To Date
2012-12-31
Ins Broker Comm Total Amount
$12,117
Ins Broker Fees Total Amount
$7,499
Pension End of year Sep Account Amount
$3,042,998
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$134
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
$134
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 THROUGH 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
$15,106
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
$274,978
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
$10,815
Row 4
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
$12,317
Row 5
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
$21,932
Row 6
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
$2,167
Row 7
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
$15,484
Row 8
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
$2,205
Row 9
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
$17,900
Row 10
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
$181,332
Row 11
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
$94,483
Row 12
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$102,573
Row 13
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
$109
Row 14
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
$15,224
Row 15
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
$8,597
Row 16
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
$9,184
Row 17
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
$6,501
Row 18
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
$272
Row 19
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
$16,474
Row 20
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
$9,679
Row 21
DFE P1 Entity Name
INTERNATIONAL 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
$14,992
Row 22
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
$38,722
Row 23
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$136,779
Row 24
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
$3,806
Row 25
DFE P1 Entity Name
T. ROWE PRICE SML CAP VAL
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,854
Row 26
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
$18,984
Row 27
DFE P1 Entity Name
FUNDAMENTAL INVESTORS
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,808
Row 28
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
$0
Row 29
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
$39,628
Row 30
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
$29,991
Row 31
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
$14,131
Row 32
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
$8,488
Row 33
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
$0
Row 34
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$68,890
Row 35
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
$15,466
Row 36
DFE P1 Entity Name
CAPITAL INCOME BUILDER
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,691
Row 37
DFE P1 Entity Name
INCOME 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
$510
Row 38
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
$7,264
Row 39
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
$0
Row 40
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
$6,859
Row 41
DFE P1 Entity Name
HIGH YIELD 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
$2,012
Row 42
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
$224,401
Row 43
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
$236,619
Row 44
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
$421,179
Row 45
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$160,596
Row 46
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
$55,395
Row 47
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
$14,693
Row 48
DFE P1 Entity Name
JOHN HANCOCK STABLE VAL
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
$182,597
Row 49
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$74,813
Row 50
DFE P1 Entity Name
RETIREMENT LIVING THROUGH 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
$21,578
Row 51
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
$144,474
Row 52
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
$446,042
Row 53
Schedule D Plan Year Begin Date
2012-01-01
Schedule D Tax Period
2012-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$3,263,717$465,219 change

Balance Sheet

Beginning and end of plan year.

Total assets$2,798,498$3,263,717Increase +$465,219 (16.62%)
Total liabilities$0$15,323Increase +$15,323
Net assets$2,798,498$3,248,394Increase +$449,896 (16.08%)

Contributions

Participant contributions$209,864
Total contributions$209,864

Income & Investment Result

Total income$521,611
Interest$1,300
Dividends$0
Net income$449,896

Expenses & Fees

Benefits paid$64,296
Administrative expenses$6,106
Total expenses$71,715

Accountant

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

Compliance

Fidelity bondYes
Fidelity bond amount$500,000
Participant loans$36,375
Late contributionsNo
Schedule H source fields
Financial summary
Total assets at beginning of year: $2,798,498Total assets at end of year: $3,263,717Total liabilities at end of year: $15,323Net income or loss: $449,896
Schedule H Plan Year Begin Date
2012-01-01
Schedule H Tax Period
2012-12-31
Schedule H Plan number
001
Schedule H EIN
04-3150778
Non Interest Bear Cash Beginning of year Amount
$1,747
Participants Contribution Beginning of year Amount
$2,644
Participant loans at beginning of year
$49,300
Interest Pool Sep Account Beginning of year Amount
$2,515,882
Oth Investment Beginning of year Amount
$228,925
Total assets at beginning of year
$2,798,498
Acquis Indbt Beginning of year Amount
$0
Total liabilities at beginning of year
$0
Net assets at beginning of year
$2,798,498
Non Interest Bear Cash End of year Amount
$1,747
Participants Contribution End of year Amount
$0
Participant loans at end of year
$36,375
Interest Pool Sep Account End of year Amount
$3,042,998
Oth Investment End of year Amount
$182,597
Total assets at end of year
$3,263,717
Acquis Indbt End of year Amount
$15,323
Total liabilities at end of year
$15,323
Net assets at end of year
$3,248,394
Participant contributions
$209,864
Total contributions
$209,864
Interest on participant loans
$1,300
Total interest income
$1,300
Total dividend income
$0
Net gain or loss on sale of assets
$0
Unrealized Apprctn Oth Amount
$2,092
Net unrealized appreciation or depreciation
$2,092
Gain Loss Pool Sep Amount
$308,355
Total income
$521,611
Participant distributions
$64,296
Total benefit distributions
$64,296
Total Corrective Distribution Amount
$1,313
Contract Admin Fees Amount
$134
Other Admin Fees Amount
$5,972
Total administrative expenses
$6,106
Total expenses
$71,715
Net income or loss
$449,896
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
2012-01-01
Schedule R Tax Period
2012-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 15, 2013