Civic Intelligence
Filing

Scott B. Barrett, DMD 401(K) Plan

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

1500 Shermer Rd #202WNorthbrook, IL 60062
Filing Insights

Participants

Down

4 → 3

-1 • -25.00%

Assets

Up

$16,484 → $28,702

$12,218 • 74.12%

Investment Management Fee

-

Admin expenses - • Total expenses $490

Filing Details

Context
Net investment result
$12,218

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) PlanCurrent3$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) Plan-4$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
84037280247039
Form Id
98841887
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
8010379280247030002
Ins Broker 01 Name
SIGNATOR INSURANCE AGENCY INC.
Ins Broker 01 Street Addr
6250 N. RIVER ROAD, SUITE 2005
Ins Broker 01 City
ROSEMONT
Ins Broker 01 State
IL
Ins Broker 01 ZIP Code
60018
Ins Broker Comm Pd 01 Amount
$390
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Filing Id
84037280247039
Form Id
98841887
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
8010379280247030002
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
$253
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
84037280247039
Form Id
98841887
Schedule A EIN
93-0791108
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2008-09-01
Schedule A Tax Period
20081231
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
2008-09-01
Ins Policy To Date
2008-12-31
Ins Broker Comm Total Amount
$390
Ins Broker Fees Total Amount
$253
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$25,464
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
84037280247039
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
8010379280247030003
Row 2
Filing Id
84037280247039
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
8010379280247030003
DFE P1 Entity 01 Name
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
$4,309
Row 3
Filing Id
84037280247039
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
8010379280247030003
DFE P1 Entity 01 Name
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
$5,711
Row 4
Filing Id
84037280247039
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
8010379280247030003
DFE P1 Entity 01 Name
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
$6,100
Row 5
Filing Id
84037280247039
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
8010379280247030003
DFE P1 Entity 01 Name
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
$5,620
Row 6
Filing Id
84037280247039
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
8010379280247030003
DFE P1 Entity 01 Name
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
$3,520

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$28,702$12,218 change

Balance Sheet

Beginning and end of plan year.

Total assets$16,484$28,702Increase +$12,218 (74.12%)
Total liabilities$0$0No change $0
Net assets$16,484$28,702Increase +$12,218 (74.12%)

Contributions

Employer contributions$5,281
Participant contributions$17,474
Other contributions$0

Income & Expenses

Total income$12,709
Total expenses$490
Net income$12,218
Source fields
Schedule I source fields
Filing Id
84037280247039
Schedule I EIN
93-0791108
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2008-09-01
Schedule I Tax Period
20081231
Small plan total assets at beginning of year
$16,484
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$16,484
Small plan total assets at end of year
$28,702
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$28,702
Small plan employer contributions
$5,281
Small plan participant contributions
$17,474
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$-10,047
Small plan total income
$12,709
Small plan total benefit distributions
$0
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$490
Small plan total expenses
$490
Small plan net income or loss
$12,218
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