Civic Intelligence
Filing

Scott B. Barrett, DMD 401(K) Plan

Scott B. Barrett, DMD • EIN 93-0791108 • Northbrook, IL • Plan year 2007

1500 Shermer Rd #202WNorthbrook, IL 60062
Filing Insights

Participants

Flat

4 → 4

0 • 0.00%

Assets

Up

$0 → $16,484

$16,484

Investment Management Fee

-

Admin expenses - • Total expenses $63

Filing Details

Context
Net investment result
$16,484

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
202414$411,084$20,810$5,203iApproximate average salary by contribution assumption: employee only about $130,063 at 4% or $86,708 at 6%; with 50% employer match about $86,708 at 4% or $57,806 at 6%; with 100% employer match about $65,031 at 4% or $43,354 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$411,084$20,810$5,203iApproximate average salary by contribution assumption: employee only about $130,063 at 4% or $86,708 at 6%; with 50% employer match about $86,708 at 4% or $57,806 at 6%; with 100% employer match about $65,031 at 4% or $43,354 at 6%.
202314$340,604$17,992$4,498iApproximate average salary by contribution assumption: employee only about $112,450 at 4% or $74,967 at 6%; with 50% employer match about $74,967 at 4% or $49,978 at 6%; with 100% employer match about $56,225 at 4% or $37,483 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$340,604$17,992$4,498iApproximate average salary by contribution assumption: employee only about $112,450 at 4% or $74,967 at 6%; with 50% employer match about $74,967 at 4% or $49,978 at 6%; with 100% employer match about $56,225 at 4% or $37,483 at 6%.
202214$274,524$7,221$1,805iApproximate average salary by contribution assumption: employee only about $45,131 at 4% or $30,088 at 6%; with 50% employer match about $30,088 at 4% or $20,058 at 6%; with 100% employer match about $22,566 at 4% or $15,044 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$274,524$7,221$1,805iApproximate average salary by contribution assumption: employee only about $45,131 at 4% or $30,088 at 6%; with 50% employer match about $30,088 at 4% or $20,058 at 6%; with 100% employer match about $22,566 at 4% or $15,044 at 6%.
202114$324,994$11,928$2,982iApproximate average salary by contribution assumption: employee only about $74,550 at 4% or $49,700 at 6%; with 50% employer match about $49,700 at 4% or $33,133 at 6%; with 100% employer match about $37,275 at 4% or $24,850 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$324,994$11,928$2,982iApproximate average salary by contribution assumption: employee only about $74,550 at 4% or $49,700 at 6%; with 50% employer match about $49,700 at 4% or $33,133 at 6%; with 100% employer match about $37,275 at 4% or $24,850 at 6%.
202014$273,344$10,118$2,530iApproximate average salary by contribution assumption: employee only about $63,238 at 4% or $42,158 at 6%; with 50% employer match about $42,158 at 4% or $28,106 at 6%; with 100% employer match about $31,619 at 4% or $21,079 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$273,344$10,118$2,530iApproximate average salary by contribution assumption: employee only about $63,238 at 4% or $42,158 at 6%; with 50% employer match about $42,158 at 4% or $28,106 at 6%; with 100% employer match about $31,619 at 4% or $21,079 at 6%.
201914$224,578$12,909$3,227iApproximate average salary by contribution assumption: employee only about $80,681 at 4% or $53,788 at 6%; with 50% employer match about $53,788 at 4% or $35,858 at 6%; with 100% employer match about $40,341 at 4% or $26,894 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$224,578$12,909$3,227iApproximate average salary by contribution assumption: employee only about $80,681 at 4% or $53,788 at 6%; with 50% employer match about $53,788 at 4% or $35,858 at 6%; with 100% employer match about $40,341 at 4% or $26,894 at 6%.
201814$172,716$13,414$3,354iApproximate average salary by contribution assumption: employee only about $83,838 at 4% or $55,892 at 6%; with 50% employer match about $55,892 at 4% or $37,261 at 6%; with 100% employer match about $41,919 at 4% or $27,946 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$172,716$13,414$3,354iApproximate average salary by contribution assumption: employee only about $83,838 at 4% or $55,892 at 6%; with 50% employer match about $55,892 at 4% or $37,261 at 6%; with 100% employer match about $41,919 at 4% or $27,946 at 6%.
201714$172,072$17,345$4,336iApproximate average salary by contribution assumption: employee only about $108,406 at 4% or $72,271 at 6%; with 50% employer match about $72,271 at 4% or $48,181 at 6%; with 100% employer match about $54,203 at 4% or $36,135 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$172,072$17,345$4,336iApproximate average salary by contribution assumption: employee only about $108,406 at 4% or $72,271 at 6%; with 50% employer match about $72,271 at 4% or $48,181 at 6%; with 100% employer match about $54,203 at 4% or $36,135 at 6%.
201614$128,115$8,450$2,113iApproximate average salary by contribution assumption: employee only about $52,813 at 4% or $35,208 at 6%; with 50% employer match about $35,208 at 4% or $23,472 at 6%; with 100% employer match about $26,406 at 4% or $17,604 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$128,115$8,450$2,113iApproximate average salary by contribution assumption: employee only about $52,813 at 4% or $35,208 at 6%; with 50% employer match about $35,208 at 4% or $23,472 at 6%; with 100% employer match about $26,406 at 4% or $17,604 at 6%.
201514$111,352$9,747$2,437iApproximate average salary by contribution assumption: employee only about $60,919 at 4% or $40,613 at 6%; with 50% employer match about $40,613 at 4% or $27,075 at 6%; with 100% employer match about $30,459 at 4% or $20,306 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$111,352$9,747$2,437iApproximate average salary by contribution assumption: employee only about $60,919 at 4% or $40,613 at 6%; with 50% employer match about $40,613 at 4% or $27,075 at 6%; with 100% employer match about $30,459 at 4% or $20,306 at 6%.
201414$105,772$10,877$2,719iApproximate average salary by contribution assumption: employee only about $67,981 at 4% or $45,321 at 6%; with 50% employer match about $45,321 at 4% or $30,214 at 6%; with 100% employer match about $33,991 at 4% or $22,660 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$105,772$10,877$2,719iApproximate average salary by contribution assumption: employee only about $67,981 at 4% or $45,321 at 6%; with 50% employer match about $45,321 at 4% or $30,214 at 6%; with 100% employer match about $33,991 at 4% or $22,660 at 6%.
201314$90,808$12,745$3,186iApproximate average salary by contribution assumption: employee only about $79,656 at 4% or $53,104 at 6%; with 50% employer match about $53,104 at 4% or $35,403 at 6%; with 100% employer match about $39,828 at 4% or $26,552 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$90,808$12,745$3,186iApproximate average salary by contribution assumption: employee only about $79,656 at 4% or $53,104 at 6%; with 50% employer match about $53,104 at 4% or $35,403 at 6%; with 100% employer match about $39,828 at 4% or $26,552 at 6%.
201212$65,327$8,245$4,123iApproximate average salary by contribution assumption: employee only about $103,063 at 4% or $68,708 at 6%; with 50% employer match about $68,708 at 4% or $45,806 at 6%; with 100% employer match about $51,531 at 4% or $34,354 at 6%.
Scott B. Barrett, DMD 401(K) Plan-2$65,327$8,245$4,123iApproximate average salary by contribution assumption: employee only about $103,063 at 4% or $68,708 at 6%; with 50% employer match about $68,708 at 4% or $45,806 at 6%; with 100% employer match about $51,531 at 4% or $34,354 at 6%.
201113$54,857$13,143$4,381iApproximate average salary by contribution assumption: employee only about $109,525 at 4% or $73,017 at 6%; with 50% employer match about $73,017 at 4% or $48,678 at 6%; with 100% employer match about $54,763 at 4% or $36,508 at 6%.
Scott B. Barrett, DMD 401(K) Plan-3$54,857$13,143$4,381iApproximate average salary by contribution assumption: employee only about $109,525 at 4% or $73,017 at 6%; with 50% employer match about $73,017 at 4% or $48,678 at 6%; with 100% employer match about $54,763 at 4% or $36,508 at 6%.
201013$43,736$9,329$3,110iApproximate average salary by contribution assumption: employee only about $77,742 at 4% or $51,828 at 6%; with 50% employer match about $51,828 at 4% or $34,552 at 6%; with 100% employer match about $38,871 at 4% or $25,914 at 6%.
Scott B. Barrett, DMD 401(K) Plan-3$43,736$9,329$3,110iApproximate average salary by contribution assumption: employee only about $77,742 at 4% or $51,828 at 6%; with 50% employer match about $51,828 at 4% or $34,552 at 6%; with 100% employer match about $38,871 at 4% or $25,914 at 6%.
200914$39,233$10,180$2,545iApproximate average salary by contribution assumption: employee only about $63,625 at 4% or $42,417 at 6%; with 50% employer match about $42,417 at 4% or $28,278 at 6%; with 100% employer match about $31,813 at 4% or $21,208 at 6%.
Scott B. Barrett, DMD 401(K) Plan-4$39,233$10,180$2,545iApproximate average salary by contribution assumption: employee only about $63,625 at 4% or $42,417 at 6%; with 50% employer match about $42,417 at 4% or $28,278 at 6%; with 100% employer match about $31,813 at 4% or $21,208 at 6%.
200813$28,702$22,755$7,585iApproximate average salary by contribution assumption: employee only about $189,625 at 4% or $126,417 at 6%; with 50% employer match about $126,417 at 4% or $84,278 at 6%; with 100% employer match about $94,813 at 4% or $63,208 at 6%.
Scott B. Barrett, DMD 401(K) Plan-3$28,702$22,755$7,585iApproximate average salary by contribution assumption: employee only about $189,625 at 4% or $126,417 at 6%; with 50% employer match about $126,417 at 4% or $84,278 at 6%; with 100% employer match about $94,813 at 4% or $63,208 at 6%.
200714$16,484$16,677$4,169iApproximate average salary by contribution assumption: employee only about $104,231 at 4% or $69,488 at 6%; with 50% employer match about $69,488 at 4% or $46,325 at 6%; with 100% employer match about $52,116 at 4% or $34,744 at 6%.
Scott B. Barrett, DMD 401(K) PlanCurrent4$16,484$16,677$4,169iApproximate average salary by contribution assumption: employee only about $104,231 at 4% or $69,488 at 6%; with 50% employer match about $69,488 at 4% or $46,325 at 6%; with 100% employer match about $52,116 at 4% or $34,744 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037226156068
Form Id
89153720
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378226156060002
Ins Broker 01 Name
SIGNATOR INSURANCE AGENCY INC.
Ins Broker 01 Street Addr
NONE PROVIDED
Ins Broker Comm Pd 01 Amount
$156
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Filing Id
84037226156068
Form Id
89153720
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7010378226156060002
Ins Broker 01 Name
BENEFIT ADMINISTRATION, INC.
Ins Broker 01 Street Addr
400 AHNAIP ST., STE. 200
Ins Broker 01 City
MENASHA
Ins Broker 01 State
WI
Ins Broker 01 ZIP Code
54952
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$22
Ins Broker Fees Pd 01 Text
TPA FEES & COMPENSATION
Ins Broker 01 Code
5
Row 3
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY
Filing Id
84037226156068
Form Id
89153720
Schedule A EIN
93-0791108
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-09-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
68769
Ins Prsn Covered End of year Count
4
Ins Policy From Date
2007-09-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$156
Ins Broker Fees Total Amount
$22
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
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
84037226156068
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378226156060003
Row 2
Filing Id
84037226156068
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378226156060003
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
$2,818
Row 3
Filing Id
84037226156068
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7010378226156060003
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
$3,583
Row 4
Filing Id
84037226156068
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
7010378226156060003
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
$3,588
Row 5
Filing Id
84037226156068
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
7010378226156060003
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
$2,924
Row 6
Filing Id
84037226156068
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
7010378226156060003
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,294
Row 7
Filing Id
84037226156068
Schedule D EIN
93-0791108
Schedule D Plan number
001
Schedule D Plan Year Begin Date
2007-09-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$16,484$16,484 change

Balance Sheet

Beginning and end of plan year.

Total assets$0$16,484Increase +$16,484
Total liabilities$0$0No change $0
Net assets$0$16,484Increase +$16,484

Contributions

Employer contributions$2,582
Participant contributions$12,820
Other contributions$1,275

Income & Expenses

Total income$16,547
Total expenses$63
Net income$16,484
Source fields
Schedule I source fields
Filing Id
84037226156068
Schedule I EIN
93-0791108
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2007-09-01
Schedule I Tax Period
20071231
Small plan total assets at beginning of year
$0
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$0
Small plan total assets at end of year
$16,484
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$16,484
Small plan employer contributions
$2,582
Small plan participant contributions
$12,820
Small Oth Contribution Rcvd Amount
$1,275
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$-130
Small plan total income
$16,547
Small plan total benefit distributions
$0
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$63
Small plan total expenses
$63
Small plan net income or loss
$16,484
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
$50,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