Civic Intelligence
Filing

Advanced Data Systems Corporation 401K Plan

ADVANCED DATA SYSTEMS • EIN 22-2282524 • Plan year 2002

Filing Insights

Participants

Down

109 → 94

-15 • -13.76%

Assets

Up

$1,490,632 → $1,500,120

$9,488 • 0.64%

Investment Management Fee

-

Admin expenses - • Total expenses $61,012

Filing Details

Context
Net investment result
$9,488

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
2007172$0$0-
ADVANCED DATA SYSTEMS CORPORATION CAFETERIA PLAN-72---
20061102$0$0-
ADVANCED DATA SYSTEMS CORPORATION CAFETERIA PLAN-102---
20052107$3,945,346$569,050$5,318iApproximate average salary by contribution assumption: employee only about $132,956 at 4% or $88,637 at 6%; with 50% employer match about $88,637 at 4% or $59,091 at 6%; with 100% employer match about $66,478 at 4% or $44,319 at 6%.
Advanced Data Systems Corporation 401K Plan-89$3,945,346$569,050$6,394iApproximate average salary by contribution assumption: employee only about $159,846 at 4% or $106,564 at 6%; with 50% employer match about $106,564 at 4% or $71,042 at 6%; with 100% employer match about $79,923 at 4% or $53,282 at 6%.
ADVANCED DATA SYSTEMS CORPORATION CAFETERIA PLAN-107---
20041107$3,187,523$547,353$5,115iApproximate average salary by contribution assumption: employee only about $127,886 at 4% or $85,257 at 6%; with 50% employer match about $85,257 at 4% or $56,838 at 6%; with 100% employer match about $63,943 at 4% or $42,629 at 6%.
Advanced Data Systems Corporation 401K Plan-107$3,187,523$547,353$5,115iApproximate average salary by contribution assumption: employee only about $127,886 at 4% or $85,257 at 6%; with 50% employer match about $85,257 at 4% or $56,838 at 6%; with 100% employer match about $63,943 at 4% or $42,629 at 6%.
20031101$2,455,664$493,317$4,884iApproximate average salary by contribution assumption: employee only about $122,108 at 4% or $81,405 at 6%; with 50% employer match about $81,405 at 4% or $54,270 at 6%; with 100% employer match about $61,054 at 4% or $40,703 at 6%.
Advanced Data Systems Corporation 401K Plan-101$2,455,664$493,317$4,884iApproximate average salary by contribution assumption: employee only about $122,108 at 4% or $81,405 at 6%; with 50% employer match about $81,405 at 4% or $54,270 at 6%; with 100% employer match about $61,054 at 4% or $40,703 at 6%.
20022106$1,500,120$415,655$3,921iApproximate average salary by contribution assumption: employee only about $98,032 at 4% or $65,355 at 6%; with 50% employer match about $65,355 at 4% or $43,570 at 6%; with 100% employer match about $49,016 at 4% or $32,677 at 6%.
Advanced Data Systems Corporation 401K PlanCurrent94$1,500,120$415,655$4,422iApproximate average salary by contribution assumption: employee only about $110,547 at 4% or $73,698 at 6%; with 50% employer match about $73,698 at 4% or $49,132 at 6%; with 100% employer match about $55,273 at 4% or $36,849 at 6%.
ADVANCED DATA SYSTEMS CORPORATION CAFETERIA PLAN-106---
2001185$0$0-
Advanced Data Systems Corporation 401K Plan-85---
2000178$1,422,724$345,959$4,435iApproximate average salary by contribution assumption: employee only about $110,884 at 4% or $73,923 at 6%; with 50% employer match about $73,923 at 4% or $49,282 at 6%; with 100% employer match about $55,442 at 4% or $36,961 at 6%.
Advanced Data Systems Corporation 401K Plan-78$1,422,724$345,959$4,435iApproximate average salary by contribution assumption: employee only about $110,884 at 4% or $73,923 at 6%; with 50% employer match about $73,923 at 4% or $49,282 at 6%; with 100% employer match about $55,442 at 4% or $36,961 at 6%.
1999162$1,344,039$295,414$4,765iApproximate average salary by contribution assumption: employee only about $119,119 at 4% or $79,412 at 6%; with 50% employer match about $79,412 at 4% or $52,942 at 6%; with 100% employer match about $59,559 at 4% or $39,706 at 6%.
Advanced Data Systems Corporation 401K Plan-62$1,344,039$295,414$4,765iApproximate average salary by contribution assumption: employee only about $119,119 at 4% or $79,412 at 6%; with 50% employer match about $79,412 at 4% or $52,942 at 6%; with 100% employer match about $59,559 at 4% or $39,706 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037282463773
Form Id
39595412
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
2040373282463020002
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$0
Row 2
Ins Carrier Name: NEW ENGLAND FINANCIAL
Filing Id
84037282463773
Form Id
39595412
Schedule A EIN
22-2282524
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2002-01-01
Schedule A Tax Period
20021231
Ins Carrier Name
NEW ENGLAND FINANCIAL
Ins Carrier EIN
13-5581829
Ins Carrier Naic Code
65978
Ins Contract Num
512432-01
Ins Prsn Covered End of year Count
95
Ins Policy From Date
2002-01-01
Ins Policy To Date
2002-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$5,503
Pension End of year Sep Account Amount
$1,471,937
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pnsn Type Unalloc Cntrct I
4
Pension Oth Unalloc Type Text
GROUP ANNUITY CONTRACT
Pension End Prev Bal Amount
$2,526
Pension Contribution Dep Amount
$2,841
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$141
Pension Transfer From Amount
$0
Pension Other Amount
$0
Pension Total Additions Amount
$2,982
Pension Total Bal Addn Amount
$5,508
Pension Bnfts Dsbrsd Amount
$5
Pension Admin Chrg Amount
$0
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$5
Pension End of year Bal Amount
$5,503
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
84037282463773
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
2040373282463020003
DFE P1 Entity 01 Name
THE TNE SERIES (K) ACCOUNT OF METRO
DFE P1 Spons 01 Name
METROPOLITAN LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
135581829003
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,471,937
Row 2
Filing Id
84037282463773
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
2040373282463020003
Row 3
Filing Id
84037282463773
Schedule D EIN
22-2282524
Schedule D Plan number
001
Schedule D Plan Year Begin Date
2002-01-01
Schedule D Tax Period
20021231

Schedule I

Schedule I Financial Statement

Small plan result

Balance sheet and activity values reported by the filer for this small-plan annual return.

End-of-year assets$1,500,120$9,488 change

Balance Sheet

Beginning and end of plan year.

Total assets$1,490,632$1,500,120Increase +$9,488 (0.64%)
Total liabilities$0$0No change $0
Net assets$1,490,632$1,500,120Increase +$9,488 (0.64%)

Contributions

Employer contributions$100,483
Participant contributions$313,297
Other contributions$1,875

Income & Expenses

Total income$70,500
Total expenses$61,012
Net income$9,488
Source fields
Schedule I source fields
Filing Id
84037282463773
Schedule I EIN
22-2282524
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2002-01-01
Schedule I Tax Period
20021231
Small plan total assets at beginning of year
$1,490,632
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$1,490,632
Small plan total assets at end of year
$1,500,120
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$1,500,120
Small plan employer contributions
$100,483
Small plan participant contributions
$313,297
Small Oth Contribution Rcvd Amount
$1,875
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$-345,155
Small plan total income
$70,500
Small plan total benefit distributions
$56,909
Small Corrective Distribution Amount
$1,709
Small Dm Dstrb Ptcp Ln A
2344
Small Oth Expenses Amount
$50
Small plan total expenses
$61,012
Small plan net income or loss
$9,488
Small Total Plan Transfers Amount
$0
Small Joint Venture End of year Indicator
No
Small Joint Venture End of year Amount
$0
Small Employer Prop End of year Indicator
No
Small Employer Prop End of year Amount
$0
Small Investment Real Est End of year I
2
Small Investment Real Est End of year A
0
Small Employer Sec End of year Indicator
No
Small Employer Sec End of year Amount
$0
Small Mortg Participants End of year Indicator
Yes
Small Mortg Participants End of year Amount
$22,680
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
$100,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
Advanced Data Systems Corporation 401K Plan | ADVANCED DATA SYSTEMS | Plan 001 | 2002 Form 5500 Filing