Civic Intelligence
Filing

Advanced Data Systems Corporation 401K Plan

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

Filing Insights

Participants

Down

126 → 101

-25 • -19.84%

Assets

Up

$1,500,120 → $2,455,664

$955,544 • 63.70%

Investment Management Fee

0.00%

$0

Admin expenses $1,062 • Total expenses $13,078

Filing Details

Context
Net investment result
$955,544
Pension payor EIN
04-2708937

Status Flags

Fidelity bond in place

Yes

Limited-scope audit performed

Not reported

Contributions transmitted on time

No

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
LIPPERT ZVERIN & FISCHER LLPEIN 13-4182811Accountant--

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 PlanCurrent101$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 Plan-94$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
84037323099034
Form Id
54090869
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
3010374323099030002
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$0
Row 2
Ins Carrier Name: NEW ENGLAND FINANCIAL
Filing Id
84037323099034
Form Id
54090869
Schedule A EIN
22-2282524
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2003-01-01
Schedule A Tax Period
20031231
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
101
Ins Policy From Date
2003-01-01
Ins Policy To Date
2003-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$6,568
Pension End of year Sep Account Amount
$2,422,940
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
$5,503
Pension Contribution Dep Amount
$3,721
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$163
Pension Transfer From Amount
$0
Pension Other Amount
$0
Pension Total Additions Amount
$3,884
Pension Total Bal Addn Amount
$9,387
Pension Bnfts Dsbrsd Amount
$1,297
Pension Admin Chrg Amount
$14
Pension Transfer To Amount
$1,508
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$2,819
Pension End of year Bal Amount
$6,568
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
84037323099034
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
3010374323099030003
DFE P1 Entity 01 Name
TNE SERIES(K) ACCT OF METROPOLITAN
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
$2,422,940
Row 2
Filing Id
84037323099034
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
3010374323099030003

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$2,455,664$955,544 change

Balance Sheet

Beginning and end of plan year.

Total assets$1,500,120$2,455,664Increase +$955,544 (63.70%)
Total liabilities$0$0No change $0
Net assets$1,500,120$2,455,664Increase +$955,544 (63.70%)

Contributions

Employer contributions$102,727
Participant contributions$390,590
Other contributions$0
Total contributions$493,317

Income & Investment Result

Total income$968,622
Interest$1,833
Dividends$0
Net income$955,544

Expenses & Fees

Benefits paid$12,016
Investment management$0
Administrative expenses$1,062
Total expenses$13,078

Accountant

FirmLIPPERT ZVERIN & FISCHER LLP
Firm EIN13-4182811

Compliance

Fidelity bondYes
Fidelity bond amount$250,000
Participant loans$26,156
Late contributionsNo
Schedule H source fields
Financial summary
Total assets at beginning of year: $1,500,120Total assets at end of year: $2,455,664Total liabilities at end of year: $0Net income or loss: $955,544
Filing Id
84037323099034
Schedule H EIN
22-2282524
Schedule H Plan number
001
Schedule H Plan Year Begin Date
2003-01-01
Schedule H Tax Period
20031231
Non Interest Bear Cash Beginning of year Amount
$0
Employer Contribution Beginning of year Amount
$0
Participants Contribution Beginning of year Amount
$0
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
$22,680
Interest Common Tr Beginning of year Amount
$0
Interest Pool Sep Account Beginning of year Amount
$1,471,937
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
$5,503
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
$1,500,120
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
$0
Total liabilities at beginning of year
$0
Net assets at beginning of year
$1,500,120
Non Interest Bear Cash End of year Amount
$0
Employer Contribution End of year Amount
$0
Participants Contribution End of year Amount
$0
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
$26,156
Interest Common Tr End of year Amount
$0
Interest Pool Sep Account End of year Amount
$2,422,940
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
$0
Ins Co Gen Account End of year Amount
$6,568
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
$2,455,664
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
$2,455,664
Employer contributions
$102,727
Participant contributions
$390,590
Oth Contribution Rcvd Amount
$0
Non Cash Contribution Bs Amount
$0
Total contributions
$493,317
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
$1,670
Interest On Oth Investment Amount
$163
Total interest income
$1,833
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
$0
Gain Loss Pool Sep Amount
$473,472
Gain Loss Master Tr Amount
$0
Gain Loss 103 12 Investment Amount
$0
Gain or loss on registered investments
$0
Other Income Amount
$0
Total income
$968,622
Participant distributions
$12,016
Ins Carrier Bnfts Amount
$0
Oth Bnft Payment Amount
$0
Total benefit distributions
$12,016
Total Corrective Distribution Amount
$0
Total Dm Distribution Ptcp Lns A
0
Total Interest Expense Amount
$0
Professional Fees Amount
$0
Contract Admin Fees Amount
$1,062
Investment management fees
$0
Other Admin Fees Amount
$0
Total administrative expenses
$1,062
Total expenses
$13,078
Net income or loss
$955,544
Total Transfers To Amount
$0
Transfers from other plans
$0
Accountant Opinion Type Indicator
3
Account Performed Limited Audit Indicator
Yes
Accountant firm name
LIPPERT ZVERIN & FISCHER LLP
Accountant firm EIN
13-4182811
Failed to transmit participant contributions on time
No
Fail Transmit Contribution Amount
$0
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
$250,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 EIN04-2708937

Transfers

Distributed property value$0
Schedule R source fields
Payor 04-2708937
Filing Id
84037323099034
Schedule R EIN
22-2282524
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2003-01-01
Schedule R Tax Period
20031231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
04-2708937
Pension Bnft Distribution Sngl Sum Count
0
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0
Advanced Data Systems Corporation 401K Plan | ADVANCED DATA SYSTEMS | Plan 001 | 2003 Form 5500 Filing