Civic Intelligence
Filing

Capstone Corporation 401(K) Plan

CLIENT SOLUTION ARCHITECTS LLC • EIN 54-1393220 • Plan year 2007

Filing Insights

Participants

Up

219 → 234

15 • 6.85%

Assets

Up

$2,991,959 → $3,616,337

$624,378 • 20.87%

Investment Management Fee

0.00%

$0

Admin expenses $11,114 • Total expenses $585,894

Filing Details

Context
Net investment result
$657,982
Pension payor EIN
42-0127290

Status Flags

Fidelity bond in place

Yes

Limited-scope audit performed

Not reported

Contributions transmitted on time

Yes

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

Not reported

Plan blackout period

Not reported

Plan termination resolution adopted

No

Counterparties
ProviderServicesLocationDirect CompensationRelated
RUBINO & MCGEEHIN, CHARTEREDEIN 52-1186096Accountant--

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
20243734$43,146,626$6,658,223$9,071iApproximate average salary by contribution assumption: employee only about $226,779 at 4% or $151,186 at 6%; with 50% employer match about $151,186 at 4% or $100,791 at 6%; with 100% employer match about $113,389 at 4% or $75,593 at 6%.
Capstone Corporation 401(K) Plan-734$43,146,626$6,658,223$9,071iApproximate average salary by contribution assumption: employee only about $226,779 at 4% or $151,186 at 6%; with 50% employer match about $151,186 at 4% or $100,791 at 6%; with 100% employer match about $113,389 at 4% or $75,593 at 6%.
Csa Health and Welfare Plan-527---
Csa Health and Welfare Plan-527---
20231780$37,971,320$7,511,184$9,630iApproximate average salary by contribution assumption: employee only about $240,743 at 4% or $160,495 at 6%; with 50% employer match about $160,495 at 4% or $106,997 at 6%; with 100% employer match about $120,372 at 4% or $80,248 at 6%.
Capstone Corporation 401(K) Plan-780$37,971,320$7,511,184$9,630iApproximate average salary by contribution assumption: employee only about $240,743 at 4% or $160,495 at 6%; with 50% employer match about $160,495 at 4% or $106,997 at 6%; with 100% employer match about $120,372 at 4% or $80,248 at 6%.
20221768$31,706,226$7,169,008$9,335iApproximate average salary by contribution assumption: employee only about $233,366 at 4% or $155,577 at 6%; with 50% employer match about $155,577 at 4% or $103,718 at 6%; with 100% employer match about $116,683 at 4% or $77,789 at 6%.
Capstone Corporation 401(K) Plan-768$31,706,226$7,169,008$9,335iApproximate average salary by contribution assumption: employee only about $233,366 at 4% or $155,577 at 6%; with 50% employer match about $155,577 at 4% or $103,718 at 6%; with 100% employer match about $116,683 at 4% or $77,789 at 6%.
20213652$21,794,911$4,135,630$6,343iApproximate average salary by contribution assumption: employee only about $158,575 at 4% or $105,717 at 6%; with 50% employer match about $105,717 at 4% or $70,478 at 6%; with 100% employer match about $79,287 at 4% or $52,858 at 6%.
Capstone Corporation 401(K) Plan-652$21,794,911$4,135,630$6,343iApproximate average salary by contribution assumption: employee only about $158,575 at 4% or $105,717 at 6%; with 50% employer match about $105,717 at 4% or $70,478 at 6%; with 100% employer match about $79,287 at 4% or $52,858 at 6%.
Csa Health and Welfare Plan-0---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-0---
20203425$19,746,658$3,117,465$7,335iApproximate average salary by contribution assumption: employee only about $183,380 at 4% or $122,254 at 6%; with 50% employer match about $122,254 at 4% or $81,502 at 6%; with 100% employer match about $91,690 at 4% or $61,127 at 6%.
Capstone Corporation 401(K) Plan-425$19,746,658$3,117,465$7,335iApproximate average salary by contribution assumption: employee only about $183,380 at 4% or $122,254 at 6%; with 50% employer match about $122,254 at 4% or $81,502 at 6%; with 100% employer match about $91,690 at 4% or $61,127 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-343---
Csa Health and Welfare Plan-159---
20192385$15,899,024$3,505,927$9,106iApproximate average salary by contribution assumption: employee only about $227,658 at 4% or $151,772 at 6%; with 50% employer match about $151,772 at 4% or $101,181 at 6%; with 100% employer match about $113,829 at 4% or $75,886 at 6%.
Capstone Corporation 401(K) Plan-385$15,899,024$3,505,927$9,106iApproximate average salary by contribution assumption: employee only about $227,658 at 4% or $151,772 at 6%; with 50% employer match about $151,772 at 4% or $101,181 at 6%; with 100% employer match about $113,829 at 4% or $75,886 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-318---
20182251$11,547,167$1,388,285$5,531iApproximate average salary by contribution assumption: employee only about $138,275 at 4% or $92,184 at 6%; with 50% employer match about $92,184 at 4% or $61,456 at 6%; with 100% employer match about $69,138 at 4% or $46,092 at 6%.
Capstone Corporation 401(K) Plan-251$11,547,167$1,388,285$5,531iApproximate average salary by contribution assumption: employee only about $138,275 at 4% or $92,184 at 6%; with 50% employer match about $92,184 at 4% or $61,456 at 6%; with 100% employer match about $69,138 at 4% or $46,092 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-205---
20172222$12,025,457$1,210,843$5,454iApproximate average salary by contribution assumption: employee only about $136,356 at 4% or $90,904 at 6%; with 50% employer match about $90,904 at 4% or $60,603 at 6%; with 100% employer match about $68,178 at 4% or $45,452 at 6%.
Capstone Corporation 401(K) Plan-222$12,025,457$1,210,843$5,454iApproximate average salary by contribution assumption: employee only about $136,356 at 4% or $90,904 at 6%; with 50% employer match about $90,904 at 4% or $60,603 at 6%; with 100% employer match about $68,178 at 4% or $45,452 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-167---
20162221$10,401,880$995,654$4,505iApproximate average salary by contribution assumption: employee only about $112,631 at 4% or $75,087 at 6%; with 50% employer match about $75,087 at 4% or $50,058 at 6%; with 100% employer match about $56,315 at 4% or $37,544 at 6%.
Capstone Corporation 401(K) Plan-221$10,401,880$995,654$4,505iApproximate average salary by contribution assumption: employee only about $112,631 at 4% or $75,087 at 6%; with 50% employer match about $75,087 at 4% or $50,058 at 6%; with 100% employer match about $56,315 at 4% or $37,544 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-187---
20152251$10,930,749$1,086,090$4,327iApproximate average salary by contribution assumption: employee only about $108,176 at 4% or $72,118 at 6%; with 50% employer match about $72,118 at 4% or $48,078 at 6%; with 100% employer match about $54,088 at 4% or $36,059 at 6%.
Capstone Corporation 401(K) Plan-251$10,930,749$1,086,090$4,327iApproximate average salary by contribution assumption: employee only about $108,176 at 4% or $72,118 at 6%; with 50% employer match about $72,118 at 4% or $48,078 at 6%; with 100% employer match about $54,088 at 4% or $36,059 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-187---
20143243$11,709,263$1,478,835$6,086iApproximate average salary by contribution assumption: employee only about $152,144 at 4% or $101,429 at 6%; with 50% employer match about $101,429 at 4% or $67,619 at 6%; with 100% employer match about $76,072 at 4% or $50,715 at 6%.
Capstone Corporation 401(K) Plan-243$11,709,263$1,478,835$6,086iApproximate average salary by contribution assumption: employee only about $152,144 at 4% or $101,429 at 6%; with 50% employer match about $101,429 at 4% or $67,619 at 6%; with 100% employer match about $76,072 at 4% or $50,715 at 6%.
Csa Health and Welfare Plan-97---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-228---
20133320$13,366,287$2,181,880$6,818iApproximate average salary by contribution assumption: employee only about $170,459 at 4% or $113,640 at 6%; with 50% employer match about $113,640 at 4% or $75,760 at 6%; with 100% employer match about $85,230 at 4% or $56,820 at 6%.
Capstone Corporation 401(K) Plan-320$13,366,287$2,181,880$6,818iApproximate average salary by contribution assumption: employee only about $170,459 at 4% or $113,640 at 6%; with 50% employer match about $113,640 at 4% or $75,760 at 6%; with 100% employer match about $85,230 at 4% or $56,820 at 6%.
Csa Health and Welfare Plan-120---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-233---
20123448$12,317,402$2,541,189$5,672iApproximate average salary by contribution assumption: employee only about $141,807 at 4% or $94,538 at 6%; with 50% employer match about $94,538 at 4% or $63,026 at 6%; with 100% employer match about $70,904 at 4% or $47,269 at 6%.
Capstone Corporation 401(K) Plan-448$12,317,402$2,541,189$5,672iApproximate average salary by contribution assumption: employee only about $141,807 at 4% or $94,538 at 6%; with 50% employer match about $94,538 at 4% or $63,026 at 6%; with 100% employer match about $70,904 at 4% or $47,269 at 6%.
Csa Health and Welfare Plan-181---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-245---
20113511$10,690,461$2,733,725$5,350iApproximate average salary by contribution assumption: employee only about $133,744 at 4% or $89,163 at 6%; with 50% employer match about $89,163 at 4% or $59,442 at 6%; with 100% employer match about $66,872 at 4% or $44,581 at 6%.
Capstone Corporation 401(K) Plan-511$10,690,461$2,733,725$5,350iApproximate average salary by contribution assumption: employee only about $133,744 at 4% or $89,163 at 6%; with 50% employer match about $89,163 at 4% or $59,442 at 6%; with 100% employer match about $66,872 at 4% or $44,581 at 6%.
Csa Health and Welfare Plan-190---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-372---
20103541$10,588,143$3,152,973$5,828iApproximate average salary by contribution assumption: employee only about $145,701 at 4% or $97,134 at 6%; with 50% employer match about $97,134 at 4% or $64,756 at 6%; with 100% employer match about $72,851 at 4% or $48,567 at 6%.
Capstone Corporation 401(K) Plan-541$10,588,143$3,152,973$5,828iApproximate average salary by contribution assumption: employee only about $145,701 at 4% or $97,134 at 6%; with 50% employer match about $97,134 at 4% or $64,756 at 6%; with 100% employer match about $72,851 at 4% or $48,567 at 6%.
Csa Health and Welfare Plan-293---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-444---
20093503$0$0-
Capstone Corporation 401(K) Plan-----
Csa Health and Welfare Plan-379---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-503---
20083407$3,566,330$1,915,859$4,707iApproximate average salary by contribution assumption: employee only about $117,682 at 4% or $78,455 at 6%; with 50% employer match about $78,455 at 4% or $52,303 at 6%; with 100% employer match about $58,841 at 4% or $39,227 at 6%.
Capstone Corporation 401(K) Plan-404$3,566,330$1,915,859$4,742iApproximate average salary by contribution assumption: employee only about $118,556 at 4% or $79,037 at 6%; with 50% employer match about $79,037 at 4% or $52,691 at 6%; with 100% employer match about $59,278 at 4% or $39,519 at 6%.
Csa Health and Welfare Plan-192---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-407---
20073342$3,616,337$981,386$2,870iApproximate average salary by contribution assumption: employee only about $71,739 at 4% or $47,826 at 6%; with 50% employer match about $47,826 at 4% or $31,884 at 6%; with 100% employer match about $35,869 at 4% or $23,913 at 6%.
Capstone Corporation 401(K) PlanCurrent234$3,616,337$981,386$4,194iApproximate average salary by contribution assumption: employee only about $104,849 at 4% or $69,899 at 6%; with 50% employer match about $69,899 at 4% or $46,600 at 6%; with 100% employer match about $52,424 at 4% or $34,950 at 6%.
Csa Health and Welfare Plan-180---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-342---
20063235$2,991,959$692,810$2,948iApproximate average salary by contribution assumption: employee only about $73,703 at 4% or $49,135 at 6%; with 50% employer match about $49,135 at 4% or $32,757 at 6%; with 100% employer match about $36,852 at 4% or $24,568 at 6%.
Capstone Corporation 401(K) Plan-227$2,991,959$692,810$3,052iApproximate average salary by contribution assumption: employee only about $76,301 at 4% or $50,867 at 6%; with 50% employer match about $50,867 at 4% or $33,911 at 6%; with 100% employer match about $38,150 at 4% or $25,434 at 6%.
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-235---
Csa Health and Welfare Plan-146---
20053230$2,375,969$554,215$2,410iApproximate average salary by contribution assumption: employee only about $60,241 at 4% or $40,161 at 6%; with 50% employer match about $40,161 at 4% or $26,774 at 6%; with 100% employer match about $30,120 at 4% or $20,080 at 6%.
Capstone Corporation 401(K) Plan-217$2,375,969$554,215$2,554iApproximate average salary by contribution assumption: employee only about $63,850 at 4% or $42,566 at 6%; with 50% employer match about $42,566 at 4% or $28,378 at 6%; with 100% employer match about $31,925 at 4% or $21,283 at 6%.
Csa Health and Welfare Plan-119---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-230---
20042179$1,819,701$424,824$2,373iApproximate average salary by contribution assumption: employee only about $59,333 at 4% or $39,555 at 6%; with 50% employer match about $39,555 at 4% or $26,370 at 6%; with 100% employer match about $29,666 at 4% or $19,778 at 6%.
Capstone Corporation 401(K) Plan-167$1,819,701$424,824$2,544iApproximate average salary by contribution assumption: employee only about $63,596 at 4% or $42,398 at 6%; with 50% employer match about $42,398 at 4% or $28,265 at 6%; with 100% employer match about $31,798 at 4% or $21,199 at 6%.
Csa Health and Welfare Plan-179---
20034163$1,511,929$354,447$2,175iApproximate average salary by contribution assumption: employee only about $54,363 at 4% or $36,242 at 6%; with 50% employer match about $36,242 at 4% or $24,161 at 6%; with 100% employer match about $27,182 at 4% or $18,121 at 6%.
Capstone Corporation 401(K) Plan-87$1,511,929$354,447$4,074iApproximate average salary by contribution assumption: employee only about $101,853 at 4% or $67,902 at 6%; with 50% employer match about $67,902 at 4% or $45,268 at 6%; with 100% employer match about $50,926 at 4% or $33,951 at 6%.
Csa Health and Welfare Plan-163---
Csa Health and Welfare Plan-0---
Capstone Corporation Dental Vision Life Ad&D Ltd and Std Plan-0---
20021157$974,096$323,631$2,061iApproximate average salary by contribution assumption: employee only about $51,534 at 4% or $34,356 at 6%; with 50% employer match about $34,356 at 4% or $22,904 at 6%; with 100% employer match about $25,767 at 4% or $17,178 at 6%.
Capstone Corporation 401(K) Plan-157$974,096$323,631$2,061iApproximate average salary by contribution assumption: employee only about $51,534 at 4% or $34,356 at 6%; with 50% employer match about $34,356 at 4% or $22,904 at 6%; with 100% employer match about $25,767 at 4% or $17,178 at 6%.
20011195$862,915$269,130$1,380iApproximate average salary by contribution assumption: employee only about $34,504 at 4% or $23,003 at 6%; with 50% employer match about $23,003 at 4% or $15,335 at 6%; with 100% employer match about $17,252 at 4% or $11,501 at 6%.
Capstone Corporation 401(K) Plan-195$862,915$269,130$1,380iApproximate average salary by contribution assumption: employee only about $34,504 at 4% or $23,003 at 6%; with 50% employer match about $23,003 at 4% or $15,335 at 6%; with 100% employer match about $17,252 at 4% or $11,501 at 6%.
2000173$0$0-
Capstone Corporation 401(K) Plan-73---
Schedule Details

Schedule A

Row 1
Filing Id
91037022241289
Form Id
94357493
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030002
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$0
Row 2
Filing Id
91037022241289
Form Id
94357494
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030003
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$0
Row 3
Ins Carrier Name: PRINCIPAL LIFE INSURANCE COMPANY
Filing Id
91037022241289
Form Id
94357493
Schedule A EIN
54-1393220
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-01-01
Schedule A Tax Period
20071231
Ins Carrier Name
PRINCIPAL LIFE INSURANCE COMPANY
Ins Carrier EIN
42-0127290
Ins Carrier Naic Code
61271
Ins Contract Num
5-19422
Ins Prsn Covered End of year Count
256
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
$0
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$2,760,535
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
Row 4
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY
Filing Id
91037022241289
Form Id
94357494
Schedule A EIN
54-1393220
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
Ins Carrier EIN
01-0233346
Ins Carrier Naic Code
65838
Ins Contract Num
72209
Ins Prsn Covered End of year Count
0
Ins Policy From Date
2007-01-01
Ins Policy To Date
2007-05-22
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$0
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
$19,350
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
$19,350
Pension Bnfts Dsbrsd Amount
$0
Pension Admin Chrg Amount
$0
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$19,350
Pension Oth Ded Text
INVESTMENT TRANSFER
Pension Total Ded Amount
$19,350
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 C

Schedule C Provider

Provider 1

Provider details

Source fields
Row 1
Filing Id
91037022241289
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030004
Row 2
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030004
Provider 01 Name
JOHN HANCOCK USA
Provider 01 EIN
01-0233346
Provider 01 Position
CONTRACT ADMINISTRATOR
Provider 01 Relation
PRIOR RECORDKEEPER
Provider 01 Salary Amount
$0
Provider 01 Fees Amount
$10,749
Provider 01 Srvc Code
12

Schedule C Provider

Provider 2

Provider details

Source fields
Row 3
Filing Id
91037022241289
Schedule C EIN
54-1393220
Schedule C Plan number
001
Schedule C Plan Year Begin Date
2007-01-01
Schedule C Tax Period
20071231
Provider Total Comp Paid Amount
$365

Schedule D

Row 1
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL INTL EM MKT SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290013
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$60,808
Row 2
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7020378357280030005
Row 3
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN LARGECAP GROWTH SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290018
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$197,141
Row 4
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2010 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290075
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$32,109
Row 5
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2020 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290076
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$145,358
Row 6
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
3
Row Num
12
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2030 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290077
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$292,129
Row 7
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
4
Row Num
13
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2040 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290078
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$439,720
Row 8
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
5
Row Num
14
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL LIFETM 2050 SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290079
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$441,895
Row 9
Filing Id
91037022241289
Page Id
2
Page Seq
1
Page Row Num
6
Row Num
15
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN LIFETM STR INC SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290080
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$69
Row 10
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
1
Row Num
16
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN DISC LGCAP BLEND SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290092
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$85,154
Row 11
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
2
Row Num
17
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN SMALLCAP VALUE I SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290094
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$7,960
Row 12
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
3
Row Num
18
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN SMCAP GROWTH III SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290097
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$9,215
Row 13
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
4
Row Num
19
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL REAL EST SEC SEPACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290095
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$152,810
Row 14
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL BOND AND MTG SEP ACC
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290005
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$174,083
Row 15
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
5
Row Num
20
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL MONEY MKT SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290024
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$0
Row 16
Filing Id
91037022241289
Page Id
2
Page Seq
2
Page Row Num
6
Row Num
21
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL STABLE VALUE FUND
DFE P1 Spons 01 Name
UNION BOND & TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
936274328001
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$294,254
Row 17
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
1
Row Num
22
Image Form Id
7020378357280030005
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
$0
Row 18
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
2
Row Num
23
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
ACTIVE BOND 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 19
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
3
Row Num
24
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
ALL CAP CORE 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 20
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
4
Row Num
25
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
ALL CAP GROWTHS 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 21
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
5
Row Num
26
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
ALL CAP 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
$0
Row 22
Filing Id
91037022241289
Page Id
2
Page Seq
3
Page Row Num
6
Row Num
27
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
BLUE CHIP 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
$0
Row 23
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
1
Row Num
28
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
CAPITAL APPRECIATION 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 24
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
2
Row Num
29
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
CLASSIC 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
$0
Row 25
Filing Id
91037022241289
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRINCIPAL DIVERS INTL SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290015
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$201,643
Row 26
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
3
Row Num
30
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
CORE EQUITY 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 27
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
4
Row Num
31
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
DYNAMIC 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
$0
Row 28
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
5
Row Num
32
Image Form Id
7020378357280030005
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
$0
Row 29
Filing Id
91037022241289
Page Id
2
Page Seq
4
Page Row Num
6
Row Num
33
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
EMERGING SMALL CO 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 30
Filing Id
91037022241289
Page Id
2
Page Seq
5
Page Row Num
1
Row Num
34
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
EQUITY INCOME 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 31
Filing Id
91037022241289
Page Id
2
Page Seq
5
Page Row Num
2
Row Num
35
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
FINANCIAL SERVICES 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
91037022241289
Page Id
2
Page Seq
5
Page Row Num
3
Row Num
36
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
FUNDAMENTAL 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
$0
Row 33
Filing Id
91037022241289
Page Id
2
Page Seq
5
Page Row Num
4
Row Num
37
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
GLOBAL ALLOCATION 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 34
Filing Id
91037022241289
Page Id
2
Page Seq
5
Page Row Num
5
Row Num
38
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
GLOBAL BOND 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 35
Filing Id
91037022241289
Page Id
2
Page Seq
5
Page Row Num
6
Row Num
39
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
GLOBAL 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 36
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN LGCP S&P 500 IDX SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290016
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$108,072
Row 37
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
1
Row Num
40
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
HEALTH SCIENCES 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 38
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
2
Row Num
41
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
HIGH YIELD FUND
DFE P1 Spons 01 Name
JOHN HANCOCK USA
DFE P1 Plan 01 EIN Plan number
010133346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$0
Row 39
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
3
Row Num
42
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
INCOME & 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
$0
Row 40
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
4
Row Num
43
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
INTERNATIONAL CORE 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 41
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
5
Row Num
44
Image Form Id
7020378357280030005
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
$0
Row 42
Filing Id
91037022241289
Page Id
2
Page Seq
6
Page Row Num
6
Row Num
45
Image Form Id
7020378357280030005
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
$0
Row 43
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
1
Row Num
46
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
INTL SMALL 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
$0
Row 44
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
2
Row Num
47
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
INVESTMENT QUAL BOND 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 45
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
3
Row Num
48
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR AMERICAN FUNDS AM BALA
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 46
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
4
Row Num
49
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR AMERICAN FUNDS EUROPAC
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 47
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN MIDCAP VALUE I SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290043
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$122,162
Row 48
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
5
Row Num
50
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR AMERICAN FUNDS 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 49
Filing Id
91037022241289
Page Id
2
Page Seq
7
Page Row Num
6
Row Num
51
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR AMERICAN FUNDS INV 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
$0
Row 50
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
1
Row Num
52
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR AMERICAN FUNDS WASH MU
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 51
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
2
Row Num
53
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR 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
$0
Row 52
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
3
Row Num
54
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR 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
$0
Row 53
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
4
Row Num
55
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR 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
$0
Row 54
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
5
Row Num
56
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR 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
$0
Row 55
Filing Id
91037022241289
Page Id
2
Page Seq
8
Page Row Num
6
Row Num
57
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
JR 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
$0
Row 56
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
1
Row Num
58
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
LARGE CAP 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
$0
Row 57
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
2
Row Num
59
Image Form Id
7020378357280030005
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 58
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN MIDCAP GROWTH II SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290047
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$31,744
Row 59
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
3
Row Num
60
Image Form Id
7020378357280030005
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
$0
Row 60
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
4
Row Num
61
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
MID CAP 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
$0
Row 61
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
5
Row Num
62
Image Form Id
7020378357280030005
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
$0
Row 62
Filing Id
91037022241289
Page Id
2
Page Seq
9
Page Row Num
6
Row Num
63
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
NATURAL RESOURCES 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 63
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
1
Row Num
64
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PACIFIC RIM 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 64
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
2
Row Num
65
Image Form Id
7020378357280030005
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
$0
Row 65
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
3
Row Num
66
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
QUANTITATIVE MID 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
$0
Row 66
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
4
Row Num
67
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
QUANTITATIVE 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
$0
Row 67
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
5
Row Num
68
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
REAL ESTATE SECURITIES 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 68
Filing Id
91037022241289
Page Id
2
Page Seq
10
Page Row Num
6
Row Num
69
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SCIENCE & TECHNOLOGY 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 69
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN SMALLCAP S&P 600 INDEX SA
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290028
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$61,533
Row 70
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
1
Row Num
70
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SMALL CAL 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 71
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
2
Row Num
71
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SMALL CAP OPPORTUNITIES F
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 72
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
3
Row Num
72
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SMALL COMPANY 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 73
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
4
Row Num
73
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SMALL COMPANY 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
$0
Row 74
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
5
Row Num
74
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
SPECIAL 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
$0
Row 75
Filing Id
91037022241289
Page Id
2
Page Seq
11
Page Row Num
6
Row Num
75
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
STRATEGIC BOND 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 76
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
1
Row Num
76
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
STRATEGIC INCOME 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 77
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
2
Row Num
77
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
STRATEGIC OPPS FUND (VS)
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 78
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
3
Row Num
78
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
TOTAL RETURN 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 79
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
4
Row Num
79
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
TOTAL STOCK 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
$0
Row 80
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN MIDCAP S&P 400 INDEX SA
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290023
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$21,859
Row 81
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
5
Row Num
80
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
U.S. GLOBAL LEADERS 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 82
Filing Id
91037022241289
Page Id
2
Page Seq
12
Page Row Num
6
Row Num
81
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
U.S. GOVERNMENT SECS 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 83
Filing Id
91037022241289
Page Id
2
Page Seq
13
Page Row Num
1
Row Num
82
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
U.S. LARGE 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
$0
Row 84
Filing Id
91037022241289
Page Id
2
Page Seq
13
Page Row Num
2
Row Num
83
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
US CORE 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 85
Filing Id
91037022241289
Page Id
2
Page Seq
13
Page Row Num
3
Row Num
84
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
UTILITIES 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 86
Filing Id
91037022241289
Page Id
2
Page Seq
13
Page Row Num
4
Row Num
85
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
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
$0
Row 87
Filing Id
91037022241289
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
7020378357280030005
DFE P1 Entity 01 Name
PRIN LGCAP VALUE III SEP ACCT
DFE P1 Spons 01 Name
PRINCIPAL LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
420127290068
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$175,071

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,616,337$624,378 change

Balance Sheet

Beginning and end of plan year.

Total assets$2,991,959$3,616,337Increase +$624,378 (20.87%)
Total liabilities$33,604$0Decrease -$33,604 (-100.00%)
Net assets$2,958,355$3,616,337Increase +$657,982 (22.24%)

Contributions

Employer contributions$184,536
Participant contributions$635,781
Other contributions$161,069
Total contributions$981,386

Income & Investment Result

Total income$1,243,876
Interest$4,348
Dividends$0
Net income$657,982

Expenses & Fees

Benefits paid$573,180
Investment management$0
Administrative expenses$11,114
Total expenses$585,894

Accountant

FirmRUBINO & MCGEEHIN, CHARTERED
Firm EIN52-1186096

Compliance

Fidelity bondYes
Fidelity bond amount$75,000
Participant loans$45,284
Late contributionsYes
Schedule H source fields
Financial summary
Total assets at beginning of year: $2,991,959Total assets at end of year: $3,616,337Total liabilities at end of year: $0Net income or loss: $657,982
Filing Id
91037022241289
Schedule H EIN
54-1393220
Schedule H Plan number
001
Schedule H Plan Year Begin Date
2007-01-01
Schedule H Tax Period
20071231
Non Interest Bear Cash Beginning of year Amount
$33,599
Employer Contribution Beginning of year Amount
$11,881
Participants Contribution Beginning of year Amount
$48,769
Other Receivables Beginning of year Amount
$0
Interest Bear Cash Beginning of year Amount
$0
Govt Sec Beginning of year Amount
$0
Corp Debt Preferred Beginning of year Amount
$0
Corp Debt Other Beginning of year Amount
$0
Pref Stock Beginning of year Amount
$0
Common Stock Beginning of year Amount
$0
Joint Venture Beginning of year Amount
$0
Real Estate Beginning of year Amount
$0
Other Loans Beginning of year Amount
$0
Participant loans at beginning of year
$33,372
Interest Common Tr Beginning of year Amount
$0
Interest Pool Sep Account Beginning of year Amount
$2,845,366
Interest Master Tr Beginning of year Amount
$0
Interest 103 12 Investment Beginning of year Amount
$0
Interest in registered investment companies at beginning of year
$0
Ins Co Gen Account Beginning of year Amount
$18,972
Oth Investment Beginning of year Amount
$0
Employer Sec Beginning of year Amount
$0
Employer Prop Beginning of year Amount
$0
Bldgs Used Beginning of year Amount
$0
Total assets at beginning of year
$2,991,959
Bnfts Payable Beginning of year Amount
$0
Oprtng Payable Beginning of year Amount
$0
Acquis Indbt Beginning of year Amount
$0
Other Liability Beginning of year Amount
$33,604
Total liabilities at beginning of year
$33,604
Net assets at beginning of year
$2,958,355
Non Interest Bear Cash End of year Amount
$0
Employer Contribution End of year Amount
$13,359
Participants Contribution End of year Amount
$46,974
Other Receivables End of year Amount
$0
Interest Bear Cash End of year Amount
$0
Govt Sec End of year Amount
$0
Corp Debt Preferred End of year Amount
$0
Corp Debt Other End of year Amount
$0
Pref Stock End of year Amount
$0
Common Stock End of year Amount
$0
Joint Venture End of year Amount
$0
Real Estate End of year Amount
$0
Other Loans End of year Amount
$0
Participant loans at end of year
$45,284
Interest Common Tr End of year Amount
$294,254
Interest Pool Sep Account End of year Amount
$2,760,535
Interest Master Tr End of year Amount
$0
Interest 103 12 Investment End of year Amount
$0
Interest in registered investment companies at end of year
$436,406
Ins Co Gen Account End of year Amount
$19,525
Oth Investment End of year Amount
$0
Employer Sec End of year Amount
$0
Employer Prop End of year Amount
$0
Bldgs Used End of year Amount
$0
Total assets at end of year
$3,616,337
Bnfts Payable End of year Amount
$0
Oprtng Payable End of year Amount
$0
Acquis Indbt End of year Amount
$0
Other Liability End of year Amount
$0
Total liabilities at end of year
$0
Net assets at end of year
$3,616,337
Employer contributions
$184,536
Participant contributions
$635,781
Oth Contribution Rcvd Amount
$161,069
Non Cash Contribution Bs Amount
$0
Total contributions
$981,386
Interest Bear Cash Amount
$0
Interest On Govt Sec Amount
$0
Interest On Corp Debt Amount
$0
Interest On Oth Loans Amount
$0
Interest on participant loans
$3,112
Interest On Oth Investment Amount
$1,236
Total interest income
$4,348
Divnd Pref Stock Amount
$0
Divnd Common Stock Amount
$0
Total dividend income
$0
Total Rents Amount
$0
Aggregate Proceeds Amount
$0
Aggregate Costs Amount
$0
Net gain or loss on sale of assets
$0
Unrealized Apprctn Re Amount
$0
Unrealized Apprctn Oth Amount
$0
Net unrealized appreciation or depreciation
$0
Gain Loss Com Trust Amount
$5,840
Gain Loss Pool Sep Amount
$177,998
Gain Loss Master Tr Amount
$0
Gain Loss 103 12 Investment Amount
$0
Gain or loss on registered investments
$73,368
Other Income Amount
$936
Total income
$1,243,876
Participant distributions
$571,276
Ins Carrier Bnfts Amount
$0
Oth Bnft Payment Amount
$1,904
Total benefit distributions
$573,180
Total Corrective Distribution Amount
$644
Total Dm Distribution Ptcp Lns A
956
Total Interest Expense Amount
$0
Professional Fees Amount
$0
Contract Admin Fees Amount
$11,114
Investment management fees
$0
Other Admin Fees Amount
$0
Total administrative expenses
$11,114
Total expenses
$585,894
Net income or loss
$657,982
Total Transfers To Amount
$0
Transfers from other plans
$0
Accountant Opinion Type Indicator
3
Account Performed Limited Audit Indicator
Yes
Accountant firm name
RUBINO & MCGEEHIN, CHARTERED
Accountant firm EIN
52-1186096
Failed to transmit participant contributions on time
Yes
Fail Transmit Contribution Amount
$25,548
Participant loans in default
No
Loans In Default Amount
$0
Leases in default
No
Leases In Default Amount
$0
Nonexempt transactions with parties in interest
No
Party In Interest Not Reported Amount
$0
Fidelity bond in place
Yes
Fidelity bond amount
$75,000
Loss discovered during year
No
Loss Discovered Dur Year Amount
$0
Assets with undetermined value
No
Asset Undeterm Valuation Amount
$0
Non-cash contributions reported
No
Non Cash Contribution Amount
$0
Assets held for investment
Yes
Reportable 5% transactions
No
All plan assets distributed
No
Resolution to terminate plan adopted
No
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 EIN42-0127290

Transfers

Distributed property value$0
Schedule R source fields
Payor 42-0127290
Filing Id
91037022241289
Schedule R EIN
54-1393220
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
42-0127290
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