Civic Intelligence
Filing

The Microdata Systems Inc. Retirement Plan

Microdata Systems Inc. • EIN 25-1452773 • Plan year 1999

Filing Insights

Participants

Flat

8 → 8

0 • 0.00%

Assets

Up

$149,300 → $195,765

$46,465 • 31.12%

Investment Management Fee

-

Admin expenses - • Total expenses $1,269

Filing Details

Context
Net investment result
$50,201

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
202413$1,180,184$30,291$10,097iApproximate average salary by contribution assumption: employee only about $252,425 at 4% or $168,283 at 6%; with 50% employer match about $168,283 at 4% or $112,189 at 6%; with 100% employer match about $126,213 at 4% or $84,142 at 6%.
The Microdata Systems Inc. Retirement Plan-3$1,180,184$30,291$10,097iApproximate average salary by contribution assumption: employee only about $252,425 at 4% or $168,283 at 6%; with 50% employer match about $168,283 at 4% or $112,189 at 6%; with 100% employer match about $126,213 at 4% or $84,142 at 6%.
202314$1,098,356$31,934$7,984iApproximate average salary by contribution assumption: employee only about $199,588 at 4% or $133,058 at 6%; with 50% employer match about $133,058 at 4% or $88,706 at 6%; with 100% employer match about $99,794 at 4% or $66,529 at 6%.
The Microdata Systems Inc. Retirement Plan-4$1,098,356$31,934$7,984iApproximate average salary by contribution assumption: employee only about $199,588 at 4% or $133,058 at 6%; with 50% employer match about $133,058 at 4% or $88,706 at 6%; with 100% employer match about $99,794 at 4% or $66,529 at 6%.
202214$927,472$38,566$9,642iApproximate average salary by contribution assumption: employee only about $241,038 at 4% or $160,692 at 6%; with 50% employer match about $160,692 at 4% or $107,128 at 6%; with 100% employer match about $120,519 at 4% or $80,346 at 6%.
The Microdata Systems Inc. Retirement Plan-4$927,472$38,566$9,642iApproximate average salary by contribution assumption: employee only about $241,038 at 4% or $160,692 at 6%; with 50% employer match about $160,692 at 4% or $107,128 at 6%; with 100% employer match about $120,519 at 4% or $80,346 at 6%.
202115$1,093,028$24,438$4,888iApproximate average salary by contribution assumption: employee only about $122,190 at 4% or $81,460 at 6%; with 50% employer match about $81,460 at 4% or $54,307 at 6%; with 100% employer match about $61,095 at 4% or $40,730 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,093,028$24,438$4,888iApproximate average salary by contribution assumption: employee only about $122,190 at 4% or $81,460 at 6%; with 50% employer match about $81,460 at 4% or $54,307 at 6%; with 100% employer match about $61,095 at 4% or $40,730 at 6%.
202015$1,220,430$36,868$7,374iApproximate average salary by contribution assumption: employee only about $184,340 at 4% or $122,893 at 6%; with 50% employer match about $122,893 at 4% or $81,929 at 6%; with 100% employer match about $92,170 at 4% or $61,447 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,220,430$36,868$7,374iApproximate average salary by contribution assumption: employee only about $184,340 at 4% or $122,893 at 6%; with 50% employer match about $122,893 at 4% or $81,929 at 6%; with 100% employer match about $92,170 at 4% or $61,447 at 6%.
201915$1,039,801$45,309$9,062iApproximate average salary by contribution assumption: employee only about $226,545 at 4% or $151,030 at 6%; with 50% employer match about $151,030 at 4% or $100,687 at 6%; with 100% employer match about $113,272 at 4% or $75,515 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,039,801$45,309$9,062iApproximate average salary by contribution assumption: employee only about $226,545 at 4% or $151,030 at 6%; with 50% employer match about $151,030 at 4% or $100,687 at 6%; with 100% employer match about $113,272 at 4% or $75,515 at 6%.
201816$971,682$48,764$8,127iApproximate average salary by contribution assumption: employee only about $203,183 at 4% or $135,456 at 6%; with 50% employer match about $135,456 at 4% or $90,304 at 6%; with 100% employer match about $101,592 at 4% or $67,728 at 6%.
The Microdata Systems Inc. Retirement Plan-6$971,682$48,764$8,127iApproximate average salary by contribution assumption: employee only about $203,183 at 4% or $135,456 at 6%; with 50% employer match about $135,456 at 4% or $90,304 at 6%; with 100% employer match about $101,592 at 4% or $67,728 at 6%.
201716$977,862$50,164$8,361iApproximate average salary by contribution assumption: employee only about $209,017 at 4% or $139,344 at 6%; with 50% employer match about $139,344 at 4% or $92,896 at 6%; with 100% employer match about $104,508 at 4% or $69,672 at 6%.
The Microdata Systems Inc. Retirement Plan-6$977,862$50,164$8,361iApproximate average salary by contribution assumption: employee only about $209,017 at 4% or $139,344 at 6%; with 50% employer match about $139,344 at 4% or $92,896 at 6%; with 100% employer match about $104,508 at 4% or $69,672 at 6%.
201616$810,298$51,213$8,536iApproximate average salary by contribution assumption: employee only about $213,388 at 4% or $142,258 at 6%; with 50% employer match about $142,258 at 4% or $94,839 at 6%; with 100% employer match about $106,694 at 4% or $71,129 at 6%.
The Microdata Systems Inc. Retirement Plan-6$810,298$51,213$8,536iApproximate average salary by contribution assumption: employee only about $213,388 at 4% or $142,258 at 6%; with 50% employer match about $142,258 at 4% or $94,839 at 6%; with 100% employer match about $106,694 at 4% or $71,129 at 6%.
201516$719,021$48,362$8,060iApproximate average salary by contribution assumption: employee only about $201,508 at 4% or $134,339 at 6%; with 50% employer match about $134,339 at 4% or $89,559 at 6%; with 100% employer match about $100,754 at 4% or $67,169 at 6%.
The Microdata Systems Inc. Retirement Plan-6$719,021$48,362$8,060iApproximate average salary by contribution assumption: employee only about $201,508 at 4% or $134,339 at 6%; with 50% employer match about $134,339 at 4% or $89,559 at 6%; with 100% employer match about $100,754 at 4% or $67,169 at 6%.
201415$676,190$42,467$8,493iApproximate average salary by contribution assumption: employee only about $212,335 at 4% or $141,557 at 6%; with 50% employer match about $141,557 at 4% or $94,371 at 6%; with 100% employer match about $106,168 at 4% or $70,778 at 6%.
The Microdata Systems Inc. Retirement Plan-5$676,190$42,467$8,493iApproximate average salary by contribution assumption: employee only about $212,335 at 4% or $141,557 at 6%; with 50% employer match about $141,557 at 4% or $94,371 at 6%; with 100% employer match about $106,168 at 4% or $70,778 at 6%.
201315$676,547$34,721$6,944iApproximate average salary by contribution assumption: employee only about $173,605 at 4% or $115,737 at 6%; with 50% employer match about $115,737 at 4% or $77,158 at 6%; with 100% employer match about $86,803 at 4% or $57,868 at 6%.
The Microdata Systems Inc. Retirement Plan-5$676,547$34,721$6,944iApproximate average salary by contribution assumption: employee only about $173,605 at 4% or $115,737 at 6%; with 50% employer match about $115,737 at 4% or $77,158 at 6%; with 100% employer match about $86,803 at 4% or $57,868 at 6%.
201215$564,096$33,010$6,602iApproximate average salary by contribution assumption: employee only about $165,050 at 4% or $110,033 at 6%; with 50% employer match about $110,033 at 4% or $73,356 at 6%; with 100% employer match about $82,525 at 4% or $55,017 at 6%.
The Microdata Systems Inc. Retirement Plan-5$564,096$33,010$6,602iApproximate average salary by contribution assumption: employee only about $165,050 at 4% or $110,033 at 6%; with 50% employer match about $110,033 at 4% or $73,356 at 6%; with 100% employer match about $82,525 at 4% or $55,017 at 6%.
201116$504,957$31,900$5,317iApproximate average salary by contribution assumption: employee only about $132,917 at 4% or $88,611 at 6%; with 50% employer match about $88,611 at 4% or $59,074 at 6%; with 100% employer match about $66,458 at 4% or $44,306 at 6%.
The Microdata Systems Inc. Retirement Plan-6$504,957$31,900$5,317iApproximate average salary by contribution assumption: employee only about $132,917 at 4% or $88,611 at 6%; with 50% employer match about $88,611 at 4% or $59,074 at 6%; with 100% employer match about $66,458 at 4% or $44,306 at 6%.
201018$489,225$31,508$3,939iApproximate average salary by contribution assumption: employee only about $98,463 at 4% or $65,642 at 6%; with 50% employer match about $65,642 at 4% or $43,761 at 6%; with 100% employer match about $49,231 at 4% or $32,821 at 6%.
The Microdata Systems Inc. Retirement Plan-8$489,225$31,508$3,939iApproximate average salary by contribution assumption: employee only about $98,463 at 4% or $65,642 at 6%; with 50% employer match about $65,642 at 4% or $43,761 at 6%; with 100% employer match about $49,231 at 4% or $32,821 at 6%.
200918$414,156$30,611$3,826iApproximate average salary by contribution assumption: employee only about $95,659 at 4% or $63,773 at 6%; with 50% employer match about $63,773 at 4% or $42,515 at 6%; with 100% employer match about $47,830 at 4% or $31,886 at 6%.
The Microdata Systems Inc. Retirement Plan-8$414,156$30,611$3,826iApproximate average salary by contribution assumption: employee only about $95,659 at 4% or $63,773 at 6%; with 50% employer match about $63,773 at 4% or $42,515 at 6%; with 100% employer match about $47,830 at 4% or $31,886 at 6%.
200815$330,877$30,693$6,139iApproximate average salary by contribution assumption: employee only about $153,465 at 4% or $102,310 at 6%; with 50% employer match about $102,310 at 4% or $68,207 at 6%; with 100% employer match about $76,733 at 4% or $51,155 at 6%.
The Microdata Systems Inc. Retirement Plan-5$330,877$30,693$6,139iApproximate average salary by contribution assumption: employee only about $153,465 at 4% or $102,310 at 6%; with 50% employer match about $102,310 at 4% or $68,207 at 6%; with 100% employer match about $76,733 at 4% or $51,155 at 6%.
200716$0$0-
The Microdata Systems Inc. Retirement Plan-6---
200617$401,946$26,103$3,729iApproximate average salary by contribution assumption: employee only about $93,225 at 4% or $62,150 at 6%; with 50% employer match about $62,150 at 4% or $41,433 at 6%; with 100% employer match about $46,613 at 4% or $31,075 at 6%.
The Microdata Systems Inc. Retirement Plan-7$401,946$26,103$3,729iApproximate average salary by contribution assumption: employee only about $93,225 at 4% or $62,150 at 6%; with 50% employer match about $62,150 at 4% or $41,433 at 6%; with 100% employer match about $46,613 at 4% or $31,075 at 6%.
200517$343,670$19,098$2,728iApproximate average salary by contribution assumption: employee only about $68,207 at 4% or $45,471 at 6%; with 50% employer match about $45,471 at 4% or $30,314 at 6%; with 100% employer match about $34,104 at 4% or $22,736 at 6%.
The Microdata Systems Inc. Retirement Plan-7$343,670$19,098$2,728iApproximate average salary by contribution assumption: employee only about $68,207 at 4% or $45,471 at 6%; with 50% employer match about $45,471 at 4% or $30,314 at 6%; with 100% employer match about $34,104 at 4% or $22,736 at 6%.
200416$311,275$22,270$3,712iApproximate average salary by contribution assumption: employee only about $92,792 at 4% or $61,861 at 6%; with 50% employer match about $61,861 at 4% or $41,241 at 6%; with 100% employer match about $46,396 at 4% or $30,931 at 6%.
The Microdata Systems Inc. Retirement Plan-6$311,275$22,270$3,712iApproximate average salary by contribution assumption: employee only about $92,792 at 4% or $61,861 at 6%; with 50% employer match about $61,861 at 4% or $41,241 at 6%; with 100% employer match about $46,396 at 4% or $30,931 at 6%.
200316$270,017$40,236$6,706iApproximate average salary by contribution assumption: employee only about $167,650 at 4% or $111,767 at 6%; with 50% employer match about $111,767 at 4% or $74,511 at 6%; with 100% employer match about $83,825 at 4% or $55,883 at 6%.
The Microdata Systems Inc. Retirement Plan-6$270,017$40,236$6,706iApproximate average salary by contribution assumption: employee only about $167,650 at 4% or $111,767 at 6%; with 50% employer match about $111,767 at 4% or $74,511 at 6%; with 100% employer match about $83,825 at 4% or $55,883 at 6%.
200216$187,279$26,291$4,382iApproximate average salary by contribution assumption: employee only about $109,546 at 4% or $73,031 at 6%; with 50% employer match about $73,031 at 4% or $48,687 at 6%; with 100% employer match about $54,773 at 4% or $36,515 at 6%.
The Microdata Systems Inc. Retirement Plan-6$187,279$26,291$4,382iApproximate average salary by contribution assumption: employee only about $109,546 at 4% or $73,031 at 6%; with 50% employer match about $73,031 at 4% or $48,687 at 6%; with 100% employer match about $54,773 at 4% or $36,515 at 6%.
200116$200,537$27,650$4,608iApproximate average salary by contribution assumption: employee only about $115,208 at 4% or $76,806 at 6%; with 50% employer match about $76,806 at 4% or $51,204 at 6%; with 100% employer match about $57,604 at 4% or $38,403 at 6%.
The Microdata Systems Inc. Retirement Plan-6$200,537$27,650$4,608iApproximate average salary by contribution assumption: employee only about $115,208 at 4% or $76,806 at 6%; with 50% employer match about $76,806 at 4% or $51,204 at 6%; with 100% employer match about $57,604 at 4% or $38,403 at 6%.
200018$0$0-
The Microdata Systems Inc. Retirement Plan-8---
199918$195,765$24,094$3,012iApproximate average salary by contribution assumption: employee only about $75,294 at 4% or $50,196 at 6%; with 50% employer match about $50,196 at 4% or $33,464 at 6%; with 100% employer match about $37,647 at 4% or $25,098 at 6%.
The Microdata Systems Inc. Retirement PlanCurrent8$195,765$24,094$3,012iApproximate average salary by contribution assumption: employee only about $75,294 at 4% or $50,196 at 6%; with 50% employer match about $50,196 at 4% or $33,464 at 6%; with 100% employer match about $37,647 at 4% or $25,098 at 6%.
Schedule Details

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$195,765$46,465 change

Balance Sheet

Beginning and end of plan year.

Total assets$149,300$195,765Increase +$46,465 (31.12%)
Total liabilities$5,574$1,838Decrease -$3,736 (-67.03%)
Net assets$143,726$193,927Increase +$50,201 (34.93%)

Contributions

Employer contributions$3,900
Participant contributions$20,194
Other contributions$0

Income & Expenses

Total income$51,470
Total expenses$1,269
Net income$50,201
Source fields
Schedule I source fields
Filing Id
56037096102521
Schedule I EIN
25-1452773
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
1999-01-01
Schedule I Tax Period
19991231
Small plan total assets at beginning of year
$149,300
Small plan total liabilities at beginning of year
$5,574
Small plan net assets at beginning of year
$143,726
Small plan total assets at end of year
$195,765
Small plan total liabilities at end of year
$1,838
Small plan net assets at end of year
$193,927
Small plan employer contributions
$3,900
Small plan participant contributions
$20,194
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$27,376
Small plan total income
$51,470
Small plan total benefit distributions
$1,269
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$0
Small plan total expenses
$1,269
Small plan net income or loss
$50,201
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
$195,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
Small plan resolution to terminate plan adopted
No
Small Res Terminate Plan Adpt Amount
$0