Civic Intelligence
Filing

Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust

Sid Simmonds, CPA Ltd. • EIN 54-1396098 • Arlington, VA • Plan year 2007

Company ProfileSource Archive
5531 Langston BlvdArlington, VA 22207
Filing Insights

Participants

Up

6 → 7

1 • 16.67%

Assets

Up

$754,038 → $923,791

$169,753 • 22.51%

Investment Management Fee

-

Admin expenses - • Total expenses $0

Filing Details

Context
Net investment result
$169,753

Status Flags

Fidelity bond in place

Yes

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 / FilingFilingsParticipantsAssetsContributionsContrib./Participant
202510$0$0-
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-0$0--
202413$3,286,571$41,198$13,733iApproximate average salary by contribution assumption: employee only about $343,317 at 4% or $228,878 at 6%; with 50% employer match about $228,878 at 4% or $152,585 at 6%; with 100% employer match about $171,658 at 4% or $114,439 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-3$3,286,571$41,198$13,733iApproximate average salary by contribution assumption: employee only about $343,317 at 4% or $228,878 at 6%; with 50% employer match about $228,878 at 4% or $152,585 at 6%; with 100% employer match about $171,658 at 4% or $114,439 at 6%.
202314$3,151,012$93,528$23,382iApproximate average salary by contribution assumption: employee only about $584,550 at 4% or $389,700 at 6%; with 50% employer match about $389,700 at 4% or $259,800 at 6%; with 100% employer match about $292,275 at 4% or $194,850 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-4$3,151,012$93,528$23,382iApproximate average salary by contribution assumption: employee only about $584,550 at 4% or $389,700 at 6%; with 50% employer match about $389,700 at 4% or $259,800 at 6%; with 100% employer match about $292,275 at 4% or $194,850 at 6%.
202216$3,941,462$117,713$19,619iApproximate average salary by contribution assumption: employee only about $490,471 at 4% or $326,981 at 6%; with 50% employer match about $326,981 at 4% or $217,987 at 6%; with 100% employer match about $245,235 at 4% or $163,490 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$3,941,462$117,713$19,619iApproximate average salary by contribution assumption: employee only about $490,471 at 4% or $326,981 at 6%; with 50% employer match about $326,981 at 4% or $217,987 at 6%; with 100% employer match about $245,235 at 4% or $163,490 at 6%.
202117$6,715,126$148,911$21,273iApproximate average salary by contribution assumption: employee only about $531,825 at 4% or $354,550 at 6%; with 50% employer match about $354,550 at 4% or $236,367 at 6%; with 100% employer match about $265,913 at 4% or $177,275 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-7$6,715,126$148,911$21,273iApproximate average salary by contribution assumption: employee only about $531,825 at 4% or $354,550 at 6%; with 50% employer match about $354,550 at 4% or $236,367 at 6%; with 100% employer match about $265,913 at 4% or $177,275 at 6%.
202017$5,666,761$148,904$21,272iApproximate average salary by contribution assumption: employee only about $531,800 at 4% or $354,533 at 6%; with 50% employer match about $354,533 at 4% or $236,356 at 6%; with 100% employer match about $265,900 at 4% or $177,267 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-7$5,666,761$148,904$21,272iApproximate average salary by contribution assumption: employee only about $531,800 at 4% or $354,533 at 6%; with 50% employer match about $354,533 at 4% or $236,356 at 6%; with 100% employer match about $265,900 at 4% or $177,267 at 6%.
201918$4,407,129$149,421$18,678iApproximate average salary by contribution assumption: employee only about $466,941 at 4% or $311,294 at 6%; with 50% employer match about $311,294 at 4% or $207,529 at 6%; with 100% employer match about $233,470 at 4% or $155,647 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-8$4,407,129$149,421$18,678iApproximate average salary by contribution assumption: employee only about $466,941 at 4% or $311,294 at 6%; with 50% employer match about $311,294 at 4% or $207,529 at 6%; with 100% employer match about $233,470 at 4% or $155,647 at 6%.
201819$3,289,209$125,731$13,970iApproximate average salary by contribution assumption: employee only about $349,253 at 4% or $232,835 at 6%; with 50% employer match about $232,835 at 4% or $155,223 at 6%; with 100% employer match about $174,626 at 4% or $116,418 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-9$3,289,209$125,731$13,970iApproximate average salary by contribution assumption: employee only about $349,253 at 4% or $232,835 at 6%; with 50% employer match about $232,835 at 4% or $155,223 at 6%; with 100% employer match about $174,626 at 4% or $116,418 at 6%.
201719$3,366,821$202,353$22,484iApproximate average salary by contribution assumption: employee only about $562,092 at 4% or $374,728 at 6%; with 50% employer match about $374,728 at 4% or $249,819 at 6%; with 100% employer match about $281,046 at 4% or $187,364 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-9$3,366,821$202,353$22,484iApproximate average salary by contribution assumption: employee only about $562,092 at 4% or $374,728 at 6%; with 50% employer match about $374,728 at 4% or $249,819 at 6%; with 100% employer match about $281,046 at 4% or $187,364 at 6%.
201619$2,571,457$107,146$11,905iApproximate average salary by contribution assumption: employee only about $297,628 at 4% or $198,419 at 6%; with 50% employer match about $198,419 at 4% or $132,279 at 6%; with 100% employer match about $148,814 at 4% or $99,209 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-9$2,571,457$107,146$11,905iApproximate average salary by contribution assumption: employee only about $297,628 at 4% or $198,419 at 6%; with 50% employer match about $198,419 at 4% or $132,279 at 6%; with 100% employer match about $148,814 at 4% or $99,209 at 6%.
201519$2,293,443$105,152$11,684iApproximate average salary by contribution assumption: employee only about $292,089 at 4% or $194,726 at 6%; with 50% employer match about $194,726 at 4% or $129,817 at 6%; with 100% employer match about $146,044 at 4% or $97,363 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-9$2,293,443$105,152$11,684iApproximate average salary by contribution assumption: employee only about $292,089 at 4% or $194,726 at 6%; with 50% employer match about $194,726 at 4% or $129,817 at 6%; with 100% employer match about $146,044 at 4% or $97,363 at 6%.
201416$2,171,871$129,331$21,555iApproximate average salary by contribution assumption: employee only about $538,879 at 4% or $359,253 at 6%; with 50% employer match about $359,253 at 4% or $239,502 at 6%; with 100% employer match about $269,440 at 4% or $179,626 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$2,171,871$129,331$21,555iApproximate average salary by contribution assumption: employee only about $538,879 at 4% or $359,253 at 6%; with 50% employer match about $359,253 at 4% or $239,502 at 6%; with 100% employer match about $269,440 at 4% or $179,626 at 6%.
201316$1,862,149$117,352$19,559iApproximate average salary by contribution assumption: employee only about $488,967 at 4% or $325,978 at 6%; with 50% employer match about $325,978 at 4% or $217,319 at 6%; with 100% employer match about $244,483 at 4% or $162,989 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$1,862,149$117,352$19,559iApproximate average salary by contribution assumption: employee only about $488,967 at 4% or $325,978 at 6%; with 50% employer match about $325,978 at 4% or $217,319 at 6%; with 100% employer match about $244,483 at 4% or $162,989 at 6%.
201216$1,559,075$102,026$17,004iApproximate average salary by contribution assumption: employee only about $425,108 at 4% or $283,406 at 6%; with 50% employer match about $283,406 at 4% or $188,937 at 6%; with 100% employer match about $212,554 at 4% or $141,703 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$1,559,075$102,026$17,004iApproximate average salary by contribution assumption: employee only about $425,108 at 4% or $283,406 at 6%; with 50% employer match about $283,406 at 4% or $188,937 at 6%; with 100% employer match about $212,554 at 4% or $141,703 at 6%.
201116$1,275,162$90,056$15,009iApproximate average salary by contribution assumption: employee only about $375,233 at 4% or $250,156 at 6%; with 50% employer match about $250,156 at 4% or $166,770 at 6%; with 100% employer match about $187,617 at 4% or $125,078 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$1,275,162$90,056$15,009iApproximate average salary by contribution assumption: employee only about $375,233 at 4% or $250,156 at 6%; with 50% employer match about $250,156 at 4% or $166,770 at 6%; with 100% employer match about $187,617 at 4% or $125,078 at 6%.
201016$1,212,805$90,910$15,152iApproximate average salary by contribution assumption: employee only about $378,792 at 4% or $252,528 at 6%; with 50% employer match about $252,528 at 4% or $168,352 at 6%; with 100% employer match about $189,396 at 4% or $126,264 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$1,212,805$90,910$15,152iApproximate average salary by contribution assumption: employee only about $378,792 at 4% or $252,528 at 6%; with 50% employer match about $252,528 at 4% or $168,352 at 6%; with 100% employer match about $189,396 at 4% or $126,264 at 6%.
200916$950,174$90,767$15,128iApproximate average salary by contribution assumption: employee only about $378,196 at 4% or $252,131 at 6%; with 50% employer match about $252,131 at 4% or $168,087 at 6%; with 100% employer match about $189,098 at 4% or $126,065 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$950,174$90,767$15,128iApproximate average salary by contribution assumption: employee only about $378,196 at 4% or $252,131 at 6%; with 50% employer match about $252,131 at 4% or $168,087 at 6%; with 100% employer match about $189,098 at 4% or $126,065 at 6%.
200816$633,578$89,291$14,882iApproximate average salary by contribution assumption: employee only about $372,046 at 4% or $248,031 at 6%; with 50% employer match about $248,031 at 4% or $165,354 at 6%; with 100% employer match about $186,023 at 4% or $124,015 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$633,578$89,291$14,882iApproximate average salary by contribution assumption: employee only about $372,046 at 4% or $248,031 at 6%; with 50% employer match about $248,031 at 4% or $165,354 at 6%; with 100% employer match about $186,023 at 4% or $124,015 at 6%.
200717$923,791$104,918$14,988iApproximate average salary by contribution assumption: employee only about $374,707 at 4% or $249,805 at 6%; with 50% employer match about $249,805 at 4% or $166,537 at 6%; with 100% employer match about $187,354 at 4% or $124,902 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and TrustCurrent7$923,791$104,918$14,988iApproximate average salary by contribution assumption: employee only about $374,707 at 4% or $249,805 at 6%; with 50% employer match about $249,805 at 4% or $166,537 at 6%; with 100% employer match about $187,354 at 4% or $124,902 at 6%.
200616$754,038$102,540$17,090iApproximate average salary by contribution assumption: employee only about $427,250 at 4% or $284,833 at 6%; with 50% employer match about $284,833 at 4% or $189,889 at 6%; with 100% employer match about $213,625 at 4% or $142,417 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$754,038$102,540$17,090iApproximate average salary by contribution assumption: employee only about $427,250 at 4% or $284,833 at 6%; with 50% employer match about $284,833 at 4% or $189,889 at 6%; with 100% employer match about $213,625 at 4% or $142,417 at 6%.
200516$588,753$89,519$14,920iApproximate average salary by contribution assumption: employee only about $372,996 at 4% or $248,664 at 6%; with 50% employer match about $248,664 at 4% or $165,776 at 6%; with 100% employer match about $186,498 at 4% or $124,332 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$588,753$89,519$14,920iApproximate average salary by contribution assumption: employee only about $372,996 at 4% or $248,664 at 6%; with 50% employer match about $248,664 at 4% or $165,776 at 6%; with 100% employer match about $186,498 at 4% or $124,332 at 6%.
200416$461,836$68,302$11,384iApproximate average salary by contribution assumption: employee only about $284,592 at 4% or $189,728 at 6%; with 50% employer match about $189,728 at 4% or $126,485 at 6%; with 100% employer match about $142,296 at 4% or $94,864 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$461,836$68,302$11,384iApproximate average salary by contribution assumption: employee only about $284,592 at 4% or $189,728 at 6%; with 50% employer match about $189,728 at 4% or $126,485 at 6%; with 100% employer match about $142,296 at 4% or $94,864 at 6%.
200316$353,019$56,384$9,397iApproximate average salary by contribution assumption: employee only about $234,933 at 4% or $156,622 at 6%; with 50% employer match about $156,622 at 4% or $104,415 at 6%; with 100% employer match about $117,467 at 4% or $78,311 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6$353,019$56,384$9,397iApproximate average salary by contribution assumption: employee only about $234,933 at 4% or $156,622 at 6%; with 50% employer match about $156,622 at 4% or $104,415 at 6%; with 100% employer match about $117,467 at 4% or $78,311 at 6%.
200216$0$0-
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-6---
200115$0$0-
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-5---
200015$371,539$174,004$34,801iApproximate average salary by contribution assumption: employee only about $870,020 at 4% or $580,013 at 6%; with 50% employer match about $580,013 at 4% or $386,676 at 6%; with 100% employer match about $435,010 at 4% or $290,007 at 6%.
Sid Simmonds, CPA Ltd. Employee Savings & Retirement Plan and Trust-5$371,539$174,004$34,801iApproximate average salary by contribution assumption: employee only about $870,020 at 4% or $580,013 at 6%; with 50% employer match about $580,013 at 4% or $386,676 at 6%; with 100% employer match about $435,010 at 4% or $290,007 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037203483308
Form Id
88190218
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378203483050002
Ins Broker 01 Name
MARTIN RETIREMENT SERVICES
Ins Broker 01 Street Addr
12 S. SUMMIT AVE., SUITE 320
Ins Broker 01 City
GAITHERSBURG
Ins Broker 01 State
MD
Ins Broker 01 ZIP Code
20877
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$449
Ins Broker Fees Pd 01 Text
TPA COMPENSATION
Ins Broker 01 Code
5
Row 2
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY (U.S.A.)
Filing Id
84037203483308
Form Id
88190218
Schedule A EIN
54-1396098
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
10367
Ins Prsn Covered End of year Count
7
Ins Policy From Date
2007-01-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$449
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$889,913
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pension End Prev Bal Amount
$0
Pension Contribution Dep Amount
$0
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$0
Pension Transfer From Amount
$0
Pension Other Amount
$0
Pension Total Additions Amount
$0
Pension Total Bal Addn Amount
$0
Pension Bnfts Dsbrsd Amount
$0
Pension Admin Chrg Amount
$0
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$0
Pension End of year Bal Amount
$0
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
84037203483308
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378203483050003
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
$63,824
Row 2
Filing Id
84037203483308
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378203483050003
Row 3
Filing Id
84037203483308
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH SALOMON BROS 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
$0
Row 4
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH DWS MID CAP 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
$17,350
Row 5
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
7020378203483050003
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
$78,212
Row 6
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
3
Row Num
12
Image Form Id
7020378203483050003
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
$50,281
Row 7
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
4
Row Num
13
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH T. ROWE PRICE SCI & TECH
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,010
Row 8
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
5
Row Num
14
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
500 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
$68,312
Row 9
Filing Id
84037203483308
Page Id
2
Page Seq
1
Page Row Num
6
Row Num
15
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
QUANTITATIVE ALL CAP 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
$2,599
Row 10
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
1
Row Num
16
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
EMERGING GROWTH 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
$11,240
Row 11
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
2
Row Num
17
Image Form Id
7020378203483050003
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
$11
Row 12
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
3
Row Num
18
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH MONEY MARKET
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
$833
Row 13
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
4
Row Num
19
Image Form Id
7020378203483050003
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
$858
Row 14
Filing Id
84037203483308
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH T. ROWE PRICE EQUITY 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
$114,033
Row 15
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
5
Row Num
20
Image Form Id
7020378203483050003
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
$452
Row 16
Filing Id
84037203483308
Page Id
2
Page Seq
2
Page Row Num
6
Row Num
21
Image Form Id
7020378203483050003
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
$470
Row 17
Filing Id
84037203483308
Page Id
2
Page Seq
3
Page Row Num
1
Row Num
22
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH TEMPLETON WORLD
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
$476
Row 18
Filing Id
84037203483308
Page Id
2
Page Seq
3
Page Row Num
2
Row Num
23
Image Form Id
7020378203483050003
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
$90,246
Row 19
Filing Id
84037203483308
Page Id
2
Page Seq
3
Page Row Num
3
Row Num
24
Image Form Id
7020378203483050003
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
$12,931
Row 20
Filing Id
84037203483308
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
7020378203483050003
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
$16,570
Row 21
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
7020378203483050003
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
$30,831
Row 22
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
7020378203483050003
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
$60,543
Row 23
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH EXCELSIOR VALUE & RESTRUCT
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
$98,269
Row 24
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
7020378203483050003
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
$624
Row 25
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
7020378203483050003
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
$2,525
Row 26
Filing Id
84037203483308
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
7020378203483050003
DFE P1 Entity 01 Name
JH LEGG PARTNERS AGG 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
$105,568
Row 27
Filing Id
84037203483308
Schedule D EIN
54-1396098
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$923,791$169,753 change

Balance Sheet

Beginning and end of plan year.

Total assets$754,038$923,791Increase +$169,753 (22.51%)
Total liabilities$0$0No change $0
Net assets$754,038$923,791Increase +$169,753 (22.51%)

Contributions

Employer contributions$33,877
Participant contributions$71,041
Other contributions$0

Income & Expenses

Total income$169,753
Total expenses$0
Net income$169,753
Source fields
Schedule I source fields
Filing Id
84037203483308
Schedule I EIN
54-1396098
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
$754,038
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$754,038
Small plan total assets at end of year
$923,791
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$923,791
Small plan employer contributions
$33,877
Small plan participant contributions
$71,041
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$64,835
Small plan total income
$169,753
Small plan total benefit distributions
$0
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$0
Small plan total expenses
$0
Small plan net income or loss
$169,753
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
No
Small Mortg Participants End of year Amount
$0
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
$500,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