Fidelity bond in place
Yes
Filing1075 Shore RoadNaperville, IL 60563
Advanced Data Technologies Inc. 401(K) Plan
Advanced Data Technologies Inc. • EIN 36-3649862 • Naperville, IL • Plan year 2007
Filing Insights
Participants
Down22 → 16
-6 • -27.27%
Assets
Down$1,802,588 → $1,686,411
-$116,177 • -6.45%
Investment Management Fee
-
Admin expenses - • Total expenses $425,269
Filing Details
Context- Net investment result
- $-116,177
- Pension payor EIN
- 01-0233346
Status Flags
Limited-scope audit performed
Not reported
Contributions transmitted on time
Not reported
Participant loans in default
No
Leases in default
No
Reportable party-in-interest issues
Not reported
Loss discovered during year
No
Assets with undetermined value
No
Non-cash contributions
No
Assets held for investment
Not reported
5% transactions reported
Not reported
All plan assets distributed
No
Benefits paid when due
Not reported
Plan blackout period
Not reported
Plan termination resolution adopted
No
Counterparties
Company Timeline
This filing is highlighted inside the broader sponsor history.
| Year / Filing | Filings | Participants | Assets | Contributions | Contrib./Participant |
|---|---|---|---|---|---|
| 2025 | 1 | 22 | $12,202,767 | $225,926 | $10,269iApproximate average salary by contribution assumption: employee only about $256,734 at 4% or $171,156 at 6%; with 50% employer match about $171,156 at 4% or $114,104 at 6%; with 100% employer match about $128,367 at 4% or $85,578 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 22 | $12,202,767 | $225,926 | $10,269iApproximate average salary by contribution assumption: employee only about $256,734 at 4% or $171,156 at 6%; with 50% employer match about $171,156 at 4% or $114,104 at 6%; with 100% employer match about $128,367 at 4% or $85,578 at 6%. |
| 2024 | 1 | 23 | $10,376,484 | $221,599 | $9,635iApproximate average salary by contribution assumption: employee only about $240,868 at 4% or $160,579 at 6%; with 50% employer match about $160,579 at 4% or $107,053 at 6%; with 100% employer match about $120,434 at 4% or $80,289 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 23 | $10,376,484 | $221,599 | $9,635iApproximate average salary by contribution assumption: employee only about $240,868 at 4% or $160,579 at 6%; with 50% employer match about $160,579 at 4% or $107,053 at 6%; with 100% employer match about $120,434 at 4% or $80,289 at 6%. |
| 2023 | 1 | 24 | $8,714,455 | $251,870 | $10,495iApproximate average salary by contribution assumption: employee only about $262,365 at 4% or $174,910 at 6%; with 50% employer match about $174,910 at 4% or $116,606 at 6%; with 100% employer match about $131,182 at 4% or $87,455 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 24 | $8,714,455 | $251,870 | $10,495iApproximate average salary by contribution assumption: employee only about $262,365 at 4% or $174,910 at 6%; with 50% employer match about $174,910 at 4% or $116,606 at 6%; with 100% employer match about $131,182 at 4% or $87,455 at 6%. |
| 2022 | 1 | 23 | $6,905,653 | $241,759 | $10,511iApproximate average salary by contribution assumption: employee only about $262,782 at 4% or $175,188 at 6%; with 50% employer match about $175,188 at 4% or $116,792 at 6%; with 100% employer match about $131,391 at 4% or $87,594 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 23 | $6,905,653 | $241,759 | $10,511iApproximate average salary by contribution assumption: employee only about $262,782 at 4% or $175,188 at 6%; with 50% employer match about $175,188 at 4% or $116,792 at 6%; with 100% employer match about $131,391 at 4% or $87,594 at 6%. |
| 2021 | 1 | 23 | $8,564,032 | $230,480 | $10,021iApproximate average salary by contribution assumption: employee only about $250,522 at 4% or $167,014 at 6%; with 50% employer match about $167,014 at 4% or $111,343 at 6%; with 100% employer match about $125,261 at 4% or $83,507 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 23 | $8,564,032 | $230,480 | $10,021iApproximate average salary by contribution assumption: employee only about $250,522 at 4% or $167,014 at 6%; with 50% employer match about $167,014 at 4% or $111,343 at 6%; with 100% employer match about $125,261 at 4% or $83,507 at 6%. |
| 2020 | 1 | 22 | $7,268,766 | $254,949 | $11,589iApproximate average salary by contribution assumption: employee only about $289,715 at 4% or $193,143 at 6%; with 50% employer match about $193,143 at 4% or $128,762 at 6%; with 100% employer match about $144,857 at 4% or $96,572 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 22 | $7,268,766 | $254,949 | $11,589iApproximate average salary by contribution assumption: employee only about $289,715 at 4% or $193,143 at 6%; with 50% employer match about $193,143 at 4% or $128,762 at 6%; with 100% employer match about $144,857 at 4% or $96,572 at 6%. |
| 2019 | 1 | 22 | $5,704,912 | $296,051 | $13,457iApproximate average salary by contribution assumption: employee only about $336,422 at 4% or $224,281 at 6%; with 50% employer match about $224,281 at 4% or $149,521 at 6%; with 100% employer match about $168,211 at 4% or $112,141 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 22 | $5,704,912 | $296,051 | $13,457iApproximate average salary by contribution assumption: employee only about $336,422 at 4% or $224,281 at 6%; with 50% employer match about $224,281 at 4% or $149,521 at 6%; with 100% employer match about $168,211 at 4% or $112,141 at 6%. |
| 2018 | 1 | 19 | $4,313,444 | $243,169 | $12,798iApproximate average salary by contribution assumption: employee only about $319,959 at 4% or $213,306 at 6%; with 50% employer match about $213,306 at 4% or $142,204 at 6%; with 100% employer match about $159,980 at 4% or $106,653 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $4,313,444 | $243,169 | $12,798iApproximate average salary by contribution assumption: employee only about $319,959 at 4% or $213,306 at 6%; with 50% employer match about $213,306 at 4% or $142,204 at 6%; with 100% employer match about $159,980 at 4% or $106,653 at 6%. |
| 2017 | 1 | 21 | $4,475,582 | $262,071 | $12,480iApproximate average salary by contribution assumption: employee only about $311,989 at 4% or $207,993 at 6%; with 50% employer match about $207,993 at 4% or $138,662 at 6%; with 100% employer match about $155,995 at 4% or $103,996 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 21 | $4,475,582 | $262,071 | $12,480iApproximate average salary by contribution assumption: employee only about $311,989 at 4% or $207,993 at 6%; with 50% employer match about $207,993 at 4% or $138,662 at 6%; with 100% employer match about $155,995 at 4% or $103,996 at 6%. |
| 2016 | 1 | 21 | $3,537,203 | $200,231 | $9,535iApproximate average salary by contribution assumption: employee only about $238,370 at 4% or $158,913 at 6%; with 50% employer match about $158,913 at 4% or $105,942 at 6%; with 100% employer match about $119,185 at 4% or $79,457 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 21 | $3,537,203 | $200,231 | $9,535iApproximate average salary by contribution assumption: employee only about $238,370 at 4% or $158,913 at 6%; with 50% employer match about $158,913 at 4% or $105,942 at 6%; with 100% employer match about $119,185 at 4% or $79,457 at 6%. |
| 2015 | 1 | 19 | $3,137,220 | $177,514 | $9,343iApproximate average salary by contribution assumption: employee only about $233,571 at 4% or $155,714 at 6%; with 50% employer match about $155,714 at 4% or $103,809 at 6%; with 100% employer match about $116,786 at 4% or $77,857 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $3,137,220 | $177,514 | $9,343iApproximate average salary by contribution assumption: employee only about $233,571 at 4% or $155,714 at 6%; with 50% employer match about $155,714 at 4% or $103,809 at 6%; with 100% employer match about $116,786 at 4% or $77,857 at 6%. |
| 2014 | 1 | 19 | $3,088,872 | $152,658 | $8,035iApproximate average salary by contribution assumption: employee only about $200,866 at 4% or $133,911 at 6%; with 50% employer match about $133,911 at 4% or $89,274 at 6%; with 100% employer match about $100,433 at 4% or $66,955 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $3,088,872 | $152,658 | $8,035iApproximate average salary by contribution assumption: employee only about $200,866 at 4% or $133,911 at 6%; with 50% employer match about $133,911 at 4% or $89,274 at 6%; with 100% employer match about $100,433 at 4% or $66,955 at 6%. |
| 2013 | 1 | 18 | $2,844,710 | $133,506 | $7,417iApproximate average salary by contribution assumption: employee only about $185,425 at 4% or $123,617 at 6%; with 50% employer match about $123,617 at 4% or $82,411 at 6%; with 100% employer match about $92,713 at 4% or $61,808 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 18 | $2,844,710 | $133,506 | $7,417iApproximate average salary by contribution assumption: employee only about $185,425 at 4% or $123,617 at 6%; with 50% employer match about $123,617 at 4% or $82,411 at 6%; with 100% employer match about $92,713 at 4% or $61,808 at 6%. |
| 2012 | 1 | 19 | $2,337,386 | $145,529 | $7,659iApproximate average salary by contribution assumption: employee only about $191,486 at 4% or $127,657 at 6%; with 50% employer match about $127,657 at 4% or $85,105 at 6%; with 100% employer match about $95,743 at 4% or $63,829 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $2,337,386 | $145,529 | $7,659iApproximate average salary by contribution assumption: employee only about $191,486 at 4% or $127,657 at 6%; with 50% employer match about $127,657 at 4% or $85,105 at 6%; with 100% employer match about $95,743 at 4% or $63,829 at 6%. |
| 2011 | 1 | 24 | $1,969,525 | $139,037 | $5,793iApproximate average salary by contribution assumption: employee only about $144,830 at 4% or $96,553 at 6%; with 50% employer match about $96,553 at 4% or $64,369 at 6%; with 100% employer match about $72,415 at 4% or $48,277 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 24 | $1,969,525 | $139,037 | $5,793iApproximate average salary by contribution assumption: employee only about $144,830 at 4% or $96,553 at 6%; with 50% employer match about $96,553 at 4% or $64,369 at 6%; with 100% employer match about $72,415 at 4% or $48,277 at 6%. |
| 2010 | 1 | 21 | $1,948,992 | $135,905 | $6,472iApproximate average salary by contribution assumption: employee only about $161,792 at 4% or $107,861 at 6%; with 50% employer match about $107,861 at 4% or $71,907 at 6%; with 100% employer match about $80,896 at 4% or $53,931 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 21 | $1,948,992 | $135,905 | $6,472iApproximate average salary by contribution assumption: employee only about $161,792 at 4% or $107,861 at 6%; with 50% employer match about $107,861 at 4% or $71,907 at 6%; with 100% employer match about $80,896 at 4% or $53,931 at 6%. |
| 2009 | 1 | 20 | $1,622,431 | $111,393 | $5,570iApproximate average salary by contribution assumption: employee only about $139,241 at 4% or $92,828 at 6%; with 50% employer match about $92,828 at 4% or $61,885 at 6%; with 100% employer match about $69,621 at 4% or $46,414 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 20 | $1,622,431 | $111,393 | $5,570iApproximate average salary by contribution assumption: employee only about $139,241 at 4% or $92,828 at 6%; with 50% employer match about $92,828 at 4% or $61,885 at 6%; with 100% employer match about $69,621 at 4% or $46,414 at 6%. |
| 2008 | 1 | 15 | $1,212,143 | $113,455 | $7,564iApproximate average salary by contribution assumption: employee only about $189,092 at 4% or $126,061 at 6%; with 50% employer match about $126,061 at 4% or $84,041 at 6%; with 100% employer match about $94,546 at 4% or $63,031 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 15 | $1,212,143 | $113,455 | $7,564iApproximate average salary by contribution assumption: employee only about $189,092 at 4% or $126,061 at 6%; with 50% employer match about $126,061 at 4% or $84,041 at 6%; with 100% employer match about $94,546 at 4% or $63,031 at 6%. |
| 2007 | 1 | 16 | $1,686,411 | $131,886 | $8,243iApproximate average salary by contribution assumption: employee only about $206,072 at 4% or $137,381 at 6%; with 50% employer match about $137,381 at 4% or $91,588 at 6%; with 100% employer match about $103,036 at 4% or $68,691 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | Current | 16 | $1,686,411 | $131,886 | $8,243iApproximate average salary by contribution assumption: employee only about $206,072 at 4% or $137,381 at 6%; with 50% employer match about $137,381 at 4% or $91,588 at 6%; with 100% employer match about $103,036 at 4% or $68,691 at 6%. |
| 2006 | 1 | 20 | $1,802,588 | $166,662 | $8,333iApproximate average salary by contribution assumption: employee only about $208,328 at 4% or $138,885 at 6%; with 50% employer match about $138,885 at 4% or $92,590 at 6%; with 100% employer match about $104,164 at 4% or $69,443 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 20 | $1,802,588 | $166,662 | $8,333iApproximate average salary by contribution assumption: employee only about $208,328 at 4% or $138,885 at 6%; with 50% employer match about $138,885 at 4% or $92,590 at 6%; with 100% employer match about $104,164 at 4% or $69,443 at 6%. |
| 2005 | 1 | 18 | $1,458,003 | $156,524 | $8,696iApproximate average salary by contribution assumption: employee only about $217,394 at 4% or $144,930 at 6%; with 50% employer match about $144,930 at 4% or $96,620 at 6%; with 100% employer match about $108,697 at 4% or $72,465 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 18 | $1,458,003 | $156,524 | $8,696iApproximate average salary by contribution assumption: employee only about $217,394 at 4% or $144,930 at 6%; with 50% employer match about $144,930 at 4% or $96,620 at 6%; with 100% employer match about $108,697 at 4% or $72,465 at 6%. |
| 2004 | 1 | 19 | $1,383,411 | $142,585 | $7,504iApproximate average salary by contribution assumption: employee only about $187,612 at 4% or $125,075 at 6%; with 50% employer match about $125,075 at 4% or $83,383 at 6%; with 100% employer match about $93,806 at 4% or $62,537 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $1,383,411 | $142,585 | $7,504iApproximate average salary by contribution assumption: employee only about $187,612 at 4% or $125,075 at 6%; with 50% employer match about $125,075 at 4% or $83,383 at 6%; with 100% employer match about $93,806 at 4% or $62,537 at 6%. |
| 2003 | 1 | 19 | $1,141,270 | $266,062 | $14,003iApproximate average salary by contribution assumption: employee only about $350,082 at 4% or $233,388 at 6%; with 50% employer match about $233,388 at 4% or $155,592 at 6%; with 100% employer match about $175,041 at 4% or $116,694 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 19 | $1,141,270 | $266,062 | $14,003iApproximate average salary by contribution assumption: employee only about $350,082 at 4% or $233,388 at 6%; with 50% employer match about $233,388 at 4% or $155,592 at 6%; with 100% employer match about $175,041 at 4% or $116,694 at 6%. |
| 2002 | 1 | 21 | $682,816 | $196,222 | $9,344iApproximate average salary by contribution assumption: employee only about $233,598 at 4% or $155,732 at 6%; with 50% employer match about $155,732 at 4% or $103,821 at 6%; with 100% employer match about $116,799 at 4% or $77,866 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 21 | $682,816 | $196,222 | $9,344iApproximate average salary by contribution assumption: employee only about $233,598 at 4% or $155,732 at 6%; with 50% employer match about $155,732 at 4% or $103,821 at 6%; with 100% employer match about $116,799 at 4% or $77,866 at 6%. |
| 2001 | 1 | 73 | $0 | $0 | - |
| Advanced Data Technologies Inc. 401(K) Plan | - | 73 | - | - | - |
| 2000 | 1 | 74 | $635,533 | $149,065 | $2,014iApproximate average salary by contribution assumption: employee only about $50,360 at 4% or $33,573 at 6%; with 50% employer match about $33,573 at 4% or $22,382 at 6%; with 100% employer match about $25,180 at 4% or $16,787 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 74 | $635,533 | $149,065 | $2,014iApproximate average salary by contribution assumption: employee only about $50,360 at 4% or $33,573 at 6%; with 50% employer match about $33,573 at 4% or $22,382 at 6%; with 100% employer match about $25,180 at 4% or $16,787 at 6%. |
| 1999 | 1 | 10 | $571,396 | $127,584 | $12,758iApproximate average salary by contribution assumption: employee only about $318,960 at 4% or $212,640 at 6%; with 50% employer match about $212,640 at 4% or $141,760 at 6%; with 100% employer match about $159,480 at 4% or $106,320 at 6%. |
| Advanced Data Technologies Inc. 401(K) Plan | - | 10 | $571,396 | $127,584 | $12,758iApproximate average salary by contribution assumption: employee only about $318,960 at 4% or $212,640 at 6%; with 50% employer match about $212,640 at 4% or $141,760 at 6%; with 100% employer match about $159,480 at 4% or $106,320 at 6%. |
Schedule Details
Schedule A
- Row 1
- Filing Id
- 84037192305028
- Form Id
- 87657907
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 1
- Row Num
- 0
- Image Form Id
- 7010378192305020002
- Ins Broker 01 Name
- WACHOVIA INSURANCE SERVICES
- Ins Broker 01 Street Addr
- TWO MID AMERICA PLAZA
- Ins Broker 01 City
- OAKBROOK TERRACE
- Ins Broker 01 State
- IL
- Ins Broker 01 ZIP Code
- 60181
- Ins Broker Comm Pd 01 Amount
- $6,989
- Ins Broker Fees Pd 01 Amount
- $0
- Ins Broker 01 Code
- 3
- Row 2
- Filing Id
- 84037192305028
- Form Id
- 87657907
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 2
- Row Num
- 1
- Image Form Id
- 7010378192305020002
- Ins Broker 01 Name
- CROWE CHIZEK & COMPANY LLC
- Ins Broker 01 Street Addr
- ONE MID AMERICA PLAZA, SUITE 700
- Ins Broker 01 City
- OAKBROOK TERRACE
- Ins Broker 01 State
- IL
- Ins Broker 01 ZIP Code
- 60181
- Ins Broker Comm Pd 01 Amount
- $0
- Ins Broker Fees Pd 01 Amount
- $1,530
- Ins Broker Fees Pd 01 Text
- TPA FEES PAID & TPA FORUM COMP
- Ins Broker 01 Code
- 5
- Row 3
- Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY (U.S.A)
- Filing Id
- 84037192305028
- Form Id
- 87657907
- Schedule A EIN
- 36-3649862
- Schedule A Plan Num
- 001
- Schedule A Plan Year Begin Date
- 2007-01-01
- Schedule A Tax Period
- 20071231
- Ins Carrier Name
- JOHN HANCOCK LIFE INSURANCE COMPANY (U.S.A)
- Ins Carrier EIN
- 01-0233346
- Ins Carrier Naic Code
- 65838
- Ins Contract Num
- 22160
- Ins Prsn Covered End of year Count
- 18
- Ins Policy From Date
- 2007-01-01
- Ins Policy To Date
- 2007-12-31
- Ins Broker Comm Total Amount
- $6,989
- Ins Broker Fees Total Amount
- $1,530
- Pension End of year Gen Account Amount
- $6,742
- Pension End of year Sep Account Amount
- $1,592,823
- Pension Prem Paid Total Amount
- $0
- Pension Unpaid Premium Amount
- $0
- Pension Contract Cost Amount
- $0
- Pnsn Type Unalloc Cntrct I
- 3
- Pension End Prev Bal Amount
- $6,560
- Pension Contribution Dep Amount
- $0
- Pension Divnd Cr Dep Amount
- $0
- Pension Interest Cr Dur Yr Amount
- $230
- Pension Transfer From Amount
- $0
- Pension Other Amount
- $0
- Pension Total Additions Amount
- $230
- Pension Total Bal Addn Amount
- $6,790
- Pension Bnfts Dsbrsd Amount
- $0
- Pension Admin Chrg Amount
- $48
- Pension Transfer To Amount
- $0
- Pension Oth Ded Amount
- $0
- Pension Total Ded Amount
- $48
- Pension End of year Bal Amount
- $6,742
- Wlfr Premium Rcvd Amount
- $0
- Wlfr Unpaid Due Amount
- $0
- Wlfr Reserve Amount
- $0
- Wlfr Total Earned Prem Amount
- $0
- Wlfr Claims Paid Amount
- $0
- Wlfr Incr Reserve Amount
- $0
- Wlfr Incurred Claim Amount
- $0
- Wlfr Claims Chrgd Amount
- $0
- Wlfr Ret Commissions Amount
- $0
- Wlfr Ret Admin Amount
- $0
- Wlfr Ret Oth Cost Amount
- $0
- Wlfr Ret Oth Expense Amount
- $0
- Wlfr Ret Taxes Amount
- $0
- Wlfr Ret Charges Amount
- $0
- Wlfr Ret Oth Chrgs Amount
- $0
- Wlfr Ret Total Amount
- $0
- Wlfr Refund Amount
- $0
- Wlfr Held Bnfts Amount
- $0
- Wlfr Claims Reserve Amount
- $0
- Wlfr Oth Reserve Amount
- $0
- Wlfr Divnds Due Amount
- $0
- Wlfr Total Charges Paid Amount
- $0
- Wlfr Acquis Cost Amount
- $0
Schedule D
- Row 1
- Filing Id
- 84037192305028
- Page Id
- 3
- Page Seq
- 0
- Page Row Num
- 1
- Row Num
- 0
- Image Form Id
- 7010378192305020003
- Row 2
- Filing Id
- 84037192305028
- Page Id
- 1
- Page Seq
- 0
- Page Row Num
- 1
- Row Num
- 0
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LIFESTYLE CONSERVATIVE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $2,298
- Row 3
- Filing Id
- 84037192305028
- Page Id
- 1
- Page Seq
- 0
- Page Row Num
- 2
- Row Num
- 1
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LIFESTYLE MODERATE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $14,685
- Row 4
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 1
- Row Num
- 10
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH DAVIS NEW YORK VENTURE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $175,274
- Row 5
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 2
- Row Num
- 11
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH MUTUAL BEACON
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 6
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 3
- Row Num
- 12
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH WEITZ PARTNERS VALUE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 7
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 4
- Row Num
- 13
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH FRANKLIN BALANCE SHEET
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $16,278
- Row 8
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 5
- Row Num
- 14
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH MUTUAL DISCOVERY
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 9
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 1
- Page Row Num
- 6
- Row Num
- 15
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LORD ABBETT ALL VALUE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $5,277
- Row 10
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 1
- Row Num
- 16
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LORD ABBETT MID CAP VALUE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $50,564
- Row 11
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 2
- Row Num
- 17
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH DWS RREEF REAL ESTATE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $19,979
- Row 12
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 3
- Row Num
- 18
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH MFS UTILITIES
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $60,488
- Row 13
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 4
- Row Num
- 19
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH JOHN HANCOCK CLASSIC VALUE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 14
- Filing Id
- 84037192305028
- Page Id
- 1
- Page Seq
- 0
- Page Row Num
- 3
- Row Num
- 2
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LIFESTYLE BALANCED
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $117,153
- Row 15
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 5
- Row Num
- 20
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH T. ROWE PRICE BLUE CHIP
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $139,369
- Row 16
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 2
- Page Row Num
- 6
- Row Num
- 21
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH JENNISON GROWTH
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $53,341
- Row 17
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 1
- Row Num
- 22
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH OPPENHEIMER GLOBAL
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $75,866
- Row 18
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 2
- Row Num
- 23
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH TEMPLETON FOREIGN
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 19
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 3
- Row Num
- 24
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH AMERICAN FUNDS EUROPACIFIC
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $48,977
- Row 20
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 4
- Row Num
- 25
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH TEMPLETON FOREIGN SMALL CO
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $5,162
- Row 21
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 5
- Row Num
- 26
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH DAVIS FINANCIAL
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $16,241
- Row 22
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 3
- Page Row Num
- 6
- Row Num
- 27
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH AIM CONSTELLATION
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $17,836
- Row 23
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 1
- Row Num
- 28
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH ENERGY
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $48,862
- Row 24
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 2
- Row Num
- 29
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LEGG MASON GROWTH
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $51,027
- Row 25
- Filing Id
- 84037192305028
- Page Id
- 1
- Page Seq
- 0
- Page Row Num
- 4
- Row Num
- 3
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LIFESTYLE GROWTH
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $122,462
- Row 26
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 3
- Row Num
- 30
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH AMERICAN CENTURY VISTA
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $22,119
- Row 27
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 4
- Row Num
- 31
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH CALAMOS GROWTH
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 28
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 5
- Row Num
- 32
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH FRANKLIN SMALL-MID GROWTH
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $68,173
- Row 29
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 4
- Page Row Num
- 6
- Row Num
- 33
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH OPPENHEIMER DEVELOPING MKT
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $135,131
- Row 30
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 5
- Page Row Num
- 1
- Row Num
- 34
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- MONEY MARKET FUND
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $10,600
- Row 31
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 5
- Page Row Num
- 2
- Row Num
- 35
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- MID CAP INDEX FUND
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $0
- Row 32
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 5
- Page Row Num
- 3
- Row Num
- 36
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- INTERNATIONAL VALUE FUND
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $81,305
- Row 33
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 5
- Page Row Num
- 4
- Row Num
- 37
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- INTL EQUITY INDEX FUND
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $18,325
- Row 34
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 5
- Page Row Num
- 5
- Row Num
- 38
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- MID CAP STOCK FUND
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $42,343
- Row 35
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 1
- Row Num
- 4
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LIFESTYLE AGGRESSIVE
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $992
- Row 36
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 2
- Row Num
- 5
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH PIMCO TOTAL RETURN
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $55,210
- Row 37
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 3
- Row Num
- 6
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH T. ROWE PRICE SPECTRUM INC
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $27,115
- Row 38
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 4
- Row Num
- 7
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH LM PARTNERS GLB HIGH YIELD
- DFE P1 Spons 01 Name
- JOHN HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $69,981
- Row 39
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 5
- Row Num
- 8
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH AMERICAN FUNDS AM BALANCED
- DFE P1 Spons 01 Name
- JH HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $2,580
- Row 40
- Filing Id
- 84037192305028
- Page Id
- 2
- Page Seq
- 0
- Page Row Num
- 6
- Row Num
- 9
- Image Form Id
- 7010378192305020003
- DFE P1 Entity 01 Name
- JH T. ROWE PRICE EQUITY INC
- DFE P1 Spons 01 Name
- JH HANCOCK USA
- DFE P1 Plan 01 EIN Plan number
- 010233346000
- DFE P1 Entity 01 Code
- P
- DFE P1 Plan Interest End of year 01 Amount
- $17,812
- Row 41
- Filing Id
- 84037192305028
- Schedule D EIN
- 36-3649862
- Schedule D Plan number
- 001
- Schedule D Plan Year Begin Date
- 2007-01-01
- Schedule D Tax Period
- 20071231
Schedule I
Schedule I Financial Statement
Small plan result
Balance sheet and activity values reported by the filer for this small-plan annual return.
End-of-year assets$1,686,411-$116,177 change
Balance Sheet
Beginning and end of plan year.
Total assets$1,802,588$1,686,411Decrease -$116,177 (-6.45%)
Total liabilities$0$0No change $0
Net assets$1,802,588$1,686,411Decrease -$116,177 (-6.45%)
Contributions
Employer contributions$41,630
Participant contributions$90,256
Other contributions$0
Income & Expenses
Total income$309,092
Total expenses$425,269
Net income$-116,177
Source fields
- Schedule I source fields
- Filing Id
- 84037192305028
- Schedule I EIN
- 36-3649862
- Schedule I Plan Num
- 001
- Schedule I Plan Year Begin Date
- 2007-01-01
- Schedule I Tax Period
- 20071231
- Small plan total assets at beginning of year
- $1,802,588
- Small plan total liabilities at beginning of year
- $0
- Small plan net assets at beginning of year
- $1,802,588
- Small plan total assets at end of year
- $1,686,411
- Small plan total liabilities at end of year
- $0
- Small plan net assets at end of year
- $1,686,411
- Small plan employer contributions
- $41,630
- Small plan participant contributions
- $90,256
- Small Oth Contribution Rcvd Amount
- $0
- Small Non Cash Contribution Bs Amount
- $0
- Small Other Income Amount
- $177,206
- Small plan total income
- $309,092
- Small plan total benefit distributions
- $405,736
- Small Corrective Distribution Amount
- $0
- Small Dm Dstrb Ptcp Ln A
- 6308
- Small Oth Expenses Amount
- $13,225
- Small plan total expenses
- $425,269
- Small plan net income or loss
- $-116,177
- Small Total Plan Transfers Amount
- $0
- Small Joint Venture End of year Indicator
- No
- Small Joint Venture End of year Amount
- $0
- Small Employer Prop End of year Indicator
- No
- Small Employer Prop End of year Amount
- $0
- Small Investment Real Est End of year I
- 2
- Small Investment Real Est End of year A
- 0
- Small Employer Sec End of year Indicator
- No
- Small Employer Sec End of year Amount
- $0
- Small Mortg Participants End of year Indicator
- Yes
- Small Mortg Participants End of year Amount
- $86,847
- Small Oth Lns Participants End of year Indicator
- No
- Small Oth Lns Participants End of year Amount
- $0
- Small Personal Prop End of year Indicator
- No
- Small Personal Prop End of year Amount
- $0
- Small Fail Xmt Ctb I
- 2
- Small Fail Xmt Ctb A
- 0
- Small plan participant loans in default
- No
- Small Loans In Default Amount
- $0
- Small plan leases in default
- No
- Small Leases In Default Amount
- $0
- Small Pt In Interest Not Reported I
- 2
- Small Pt In Interest Not Reported A
- 0
- Small plan fidelity bond in place
- Yes
- Small plan fidelity bond amount
- $180,000
- Small plan loss discovered during year
- No
- Small Loss Discovered Dur Year Amount
- $0
- Small plan assets with undetermined value
- No
- Small Asset Undeterm Valuation Amount
- $0
- Small plan non-cash contributions reported
- No
- Small Non Cash Contribution Amount
- $0
- Small 20 Percent Sngl Investment Indicator
- No
- Small 20 Percent Sngl Investment Amount
- $0
- Small plan all plan assets distributed
- No
- Waiver Annual Iqpa Report
- 1
- Small plan resolution to terminate plan adopted
- No
- Small Res Terminate Plan Adpt Amount
- $0
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
Distributed property value$0
Schedule R source fields
- Payor 01-0233346
- Filing Id
- 84037192305028
- Schedule R EIN
- 36-3649862
- Schedule R Plan number
- 001
- Schedule R Plan Year Begin Date
- 2007-01-01
- Schedule R Tax Period
- 20071231
- Pension Value Dstrb Pd Property Amount
- $0
- Pension payor EIN
- 01-0233346
- Pension Bnft Distribution Sngl Sum Count
- 0
- Pension Employer Contribution Rqr Amount
- $0
- Pension Employer Contribution Paid Amount
- $0
- Pension Funding Deficiency Amount
- $0
- Pension Satisfy Cover Basis Code
- 1