Civic Intelligence
Filing

Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan

Midwest Data Processing, Inc. • EIN 43-1299283 • Plan year 2002

Company ProfileSource Archive
Filing Insights

Participants

Flat

4 → 4

0 • 0.00%

Assets

Up

$268,495 → $321,970

$53,475 • 19.92%

Investment Management Fee

-

Admin expenses - • Total expenses $15

Filing Details

Context
Net investment result
$53,475

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
201510$0$44,843-
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-0-$44,843-
201416$1,344,220$39,800$6,633iApproximate average salary by contribution assumption: employee only about $165,833 at 4% or $110,556 at 6%; with 50% employer match about $110,556 at 4% or $73,704 at 6%; with 100% employer match about $82,917 at 4% or $55,278 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-6$1,344,220$39,800$6,633iApproximate average salary by contribution assumption: employee only about $165,833 at 4% or $110,556 at 6%; with 50% employer match about $110,556 at 4% or $73,704 at 6%; with 100% employer match about $82,917 at 4% or $55,278 at 6%.
201317$1,260,205$38,094$5,442iApproximate average salary by contribution assumption: employee only about $136,050 at 4% or $90,700 at 6%; with 50% employer match about $90,700 at 4% or $60,467 at 6%; with 100% employer match about $68,025 at 4% or $45,350 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-7$1,260,205$38,094$5,442iApproximate average salary by contribution assumption: employee only about $136,050 at 4% or $90,700 at 6%; with 50% employer match about $90,700 at 4% or $60,467 at 6%; with 100% employer match about $68,025 at 4% or $45,350 at 6%.
201217$1,099,427$35,589$5,084iApproximate average salary by contribution assumption: employee only about $127,104 at 4% or $84,736 at 6%; with 50% employer match about $84,736 at 4% or $56,490 at 6%; with 100% employer match about $63,552 at 4% or $42,368 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-7$1,099,427$35,589$5,084iApproximate average salary by contribution assumption: employee only about $127,104 at 4% or $84,736 at 6%; with 50% employer match about $84,736 at 4% or $56,490 at 6%; with 100% employer match about $63,552 at 4% or $42,368 at 6%.
201116$892,299$30,713$5,119iApproximate average salary by contribution assumption: employee only about $127,971 at 4% or $85,314 at 6%; with 50% employer match about $85,314 at 4% or $56,876 at 6%; with 100% employer match about $63,985 at 4% or $42,657 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-6$892,299$30,713$5,119iApproximate average salary by contribution assumption: employee only about $127,971 at 4% or $85,314 at 6%; with 50% employer match about $85,314 at 4% or $56,876 at 6%; with 100% employer match about $63,985 at 4% or $42,657 at 6%.
201015$836,096$28,894$5,779iApproximate average salary by contribution assumption: employee only about $144,470 at 4% or $96,313 at 6%; with 50% employer match about $96,313 at 4% or $64,209 at 6%; with 100% employer match about $72,235 at 4% or $48,157 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-5$836,096$28,894$5,779iApproximate average salary by contribution assumption: employee only about $144,470 at 4% or $96,313 at 6%; with 50% employer match about $96,313 at 4% or $64,209 at 6%; with 100% employer match about $72,235 at 4% or $48,157 at 6%.
200916$743,195$28,448$4,741iApproximate average salary by contribution assumption: employee only about $118,533 at 4% or $79,022 at 6%; with 50% employer match about $79,022 at 4% or $52,681 at 6%; with 100% employer match about $59,267 at 4% or $39,511 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-6$743,195$28,448$4,741iApproximate average salary by contribution assumption: employee only about $118,533 at 4% or $79,022 at 6%; with 50% employer match about $79,022 at 4% or $52,681 at 6%; with 100% employer match about $59,267 at 4% or $39,511 at 6%.
200816$648,660$26,231$4,372iApproximate average salary by contribution assumption: employee only about $109,296 at 4% or $72,864 at 6%; with 50% employer match about $72,864 at 4% or $48,576 at 6%; with 100% employer match about $54,648 at 4% or $36,432 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-6$648,660$26,231$4,372iApproximate average salary by contribution assumption: employee only about $109,296 at 4% or $72,864 at 6%; with 50% employer match about $72,864 at 4% or $48,576 at 6%; with 100% employer match about $54,648 at 4% or $36,432 at 6%.
200715$632,881$24,377$4,875iApproximate average salary by contribution assumption: employee only about $121,885 at 4% or $81,257 at 6%; with 50% employer match about $81,257 at 4% or $54,171 at 6%; with 100% employer match about $60,942 at 4% or $40,628 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-5$632,881$24,377$4,875iApproximate average salary by contribution assumption: employee only about $121,885 at 4% or $81,257 at 6%; with 50% employer match about $81,257 at 4% or $54,171 at 6%; with 100% employer match about $60,942 at 4% or $40,628 at 6%.
200614$558,439$20,856$5,214iApproximate average salary by contribution assumption: employee only about $130,350 at 4% or $86,900 at 6%; with 50% employer match about $86,900 at 4% or $57,933 at 6%; with 100% employer match about $65,175 at 4% or $43,450 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-4$558,439$20,856$5,214iApproximate average salary by contribution assumption: employee only about $130,350 at 4% or $86,900 at 6%; with 50% employer match about $86,900 at 4% or $57,933 at 6%; with 100% employer match about $65,175 at 4% or $43,450 at 6%.
200514$555,569$30,079$7,520iApproximate average salary by contribution assumption: employee only about $187,994 at 4% or $125,329 at 6%; with 50% employer match about $125,329 at 4% or $83,553 at 6%; with 100% employer match about $93,997 at 4% or $62,665 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-4$555,569$30,079$7,520iApproximate average salary by contribution assumption: employee only about $187,994 at 4% or $125,329 at 6%; with 50% employer match about $125,329 at 4% or $83,553 at 6%; with 100% employer match about $93,997 at 4% or $62,665 at 6%.
200415$478,524$29,636$5,927iApproximate average salary by contribution assumption: employee only about $148,180 at 4% or $98,787 at 6%; with 50% employer match about $98,787 at 4% or $65,858 at 6%; with 100% employer match about $74,090 at 4% or $49,393 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-5$478,524$29,636$5,927iApproximate average salary by contribution assumption: employee only about $148,180 at 4% or $98,787 at 6%; with 50% employer match about $98,787 at 4% or $65,858 at 6%; with 100% employer match about $74,090 at 4% or $49,393 at 6%.
200315$387,130$29,776$5,955iApproximate average salary by contribution assumption: employee only about $148,880 at 4% or $99,253 at 6%; with 50% employer match about $99,253 at 4% or $66,169 at 6%; with 100% employer match about $74,440 at 4% or $49,627 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-5$387,130$29,776$5,955iApproximate average salary by contribution assumption: employee only about $148,880 at 4% or $99,253 at 6%; with 50% employer match about $99,253 at 4% or $66,169 at 6%; with 100% employer match about $74,440 at 4% or $49,627 at 6%.
200214$321,970$24,387$6,097iApproximate average salary by contribution assumption: employee only about $152,419 at 4% or $101,613 at 6%; with 50% employer match about $101,613 at 4% or $67,742 at 6%; with 100% employer match about $76,209 at 4% or $50,806 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership PlanCurrent4$321,970$24,387$6,097iApproximate average salary by contribution assumption: employee only about $152,419 at 4% or $101,613 at 6%; with 50% employer match about $101,613 at 4% or $67,742 at 6%; with 100% employer match about $76,209 at 4% or $50,806 at 6%.
200114$268,495$22,656$5,664iApproximate average salary by contribution assumption: employee only about $141,600 at 4% or $94,400 at 6%; with 50% employer match about $94,400 at 4% or $62,933 at 6%; with 100% employer match about $70,800 at 4% or $47,200 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-4$268,495$22,656$5,664iApproximate average salary by contribution assumption: employee only about $141,600 at 4% or $94,400 at 6%; with 50% employer match about $94,400 at 4% or $62,933 at 6%; with 100% employer match about $70,800 at 4% or $47,200 at 6%.
200013$223,781$18,241$6,080iApproximate average salary by contribution assumption: employee only about $152,008 at 4% or $101,339 at 6%; with 50% employer match about $101,339 at 4% or $67,559 at 6%; with 100% employer match about $76,004 at 4% or $50,669 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-3$223,781$18,241$6,080iApproximate average salary by contribution assumption: employee only about $152,008 at 4% or $101,339 at 6%; with 50% employer match about $101,339 at 4% or $67,559 at 6%; with 100% employer match about $76,004 at 4% or $50,669 at 6%.
199913$201,766$18,370$6,123iApproximate average salary by contribution assumption: employee only about $153,083 at 4% or $102,056 at 6%; with 50% employer match about $102,056 at 4% or $68,037 at 6%; with 100% employer match about $76,542 at 4% or $51,028 at 6%.
Midwest Bancshares Inc. and Affiliates Employee Stock Ownership Plan-3$201,766$18,370$6,123iApproximate average salary by contribution assumption: employee only about $153,083 at 4% or $102,056 at 6%; with 50% employer match about $102,056 at 4% or $68,037 at 6%; with 100% employer match about $76,542 at 4% or $51,028 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$321,970$53,475 change

Balance Sheet

Beginning and end of plan year.

Total assets$268,495$321,970Increase +$53,475 (19.92%)
Total liabilities$0$0No change $0
Net assets$268,495$321,970Increase +$53,475 (19.92%)

Contributions

Employer contributions$24,387
Participant contributions$0
Other contributions$0

Income & Expenses

Total income$53,490
Total expenses$15
Net income$53,475
Source fields
Schedule I source fields
Filing Id
84037281529783
Schedule I EIN
43-1299283
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
$268,495
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$268,495
Small plan total assets at end of year
$321,970
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$321,970
Small plan employer contributions
$24,387
Small plan participant contributions
$0
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$29,103
Small plan total income
$53,490
Small plan total benefit distributions
$0
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$15
Small plan total expenses
$15
Small plan net income or loss
$53,475
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
Yes
Small Employer Sec End of year Amount
$291,855
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
$35,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
Yes
Small 20 Percent Sngl Investment Amount
$291,855
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

Schedule R

Schedule R Pension Information

Retirement plan characteristics

Testing, payor, opinion-letter, and transfer information reported with the filing.

Transfers

Distributed property value$0
Schedule R source fields
Row 1
Filing Id
84037281529783
Schedule R EIN
43-1299283
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2002-01-01
Schedule R Tax Period
20021231
Pension Value Dstrb Pd Property Amount
$0
Pension Bnft Distribution Sngl Sum Count
0
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0
Pension Chg Fndng Method Indicator
3