Civic Intelligence
Filing

Futureware Distributing Inc., 401K Plan

Futureware Distributing Inc. • EIN 47-0665232 • Plan year 2007

Filing Insights

Participants

Down

28 → 15

-13 • -46.43%

Assets

Down

$955,173 → $906,154

-$49,019 • -5.13%

Investment Management Fee

-

Admin expenses - • Total expenses $149,876

Filing Details

Context
Net investment result
$-49,019
Pension payor EIN
31-4156830

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
2011112$615,802$29,184$2,432iApproximate average salary by contribution assumption: employee only about $60,800 at 4% or $40,533 at 6%; with 50% employer match about $40,533 at 4% or $27,022 at 6%; with 100% employer match about $30,400 at 4% or $20,267 at 6%.
Futureware Distributing Inc., 401K Plan-12$615,802$29,184$2,432iApproximate average salary by contribution assumption: employee only about $60,800 at 4% or $40,533 at 6%; with 50% employer match about $40,533 at 4% or $27,022 at 6%; with 100% employer match about $30,400 at 4% or $20,267 at 6%.
2010114$742,783$27,330$1,952iApproximate average salary by contribution assumption: employee only about $48,804 at 4% or $32,536 at 6%; with 50% employer match about $32,536 at 4% or $21,690 at 6%; with 100% employer match about $24,402 at 4% or $16,268 at 6%.
Futureware Distributing Inc., 401K Plan-14$742,783$27,330$1,952iApproximate average salary by contribution assumption: employee only about $48,804 at 4% or $32,536 at 6%; with 50% employer match about $32,536 at 4% or $21,690 at 6%; with 100% employer match about $24,402 at 4% or $16,268 at 6%.
2009112$709,611$25,709$2,142iApproximate average salary by contribution assumption: employee only about $53,560 at 4% or $35,707 at 6%; with 50% employer match about $35,707 at 4% or $23,805 at 6%; with 100% employer match about $26,780 at 4% or $17,853 at 6%.
Futureware Distributing Inc., 401K Plan-12$709,611$25,709$2,142iApproximate average salary by contribution assumption: employee only about $53,560 at 4% or $35,707 at 6%; with 50% employer match about $35,707 at 4% or $23,805 at 6%; with 100% employer match about $26,780 at 4% or $17,853 at 6%.
2008112$589,752$40,434$3,370iApproximate average salary by contribution assumption: employee only about $84,238 at 4% or $56,158 at 6%; with 50% employer match about $56,158 at 4% or $37,439 at 6%; with 100% employer match about $42,119 at 4% or $28,079 at 6%.
Futureware Distributing Inc., 401K Plan-12$589,752$40,434$3,370iApproximate average salary by contribution assumption: employee only about $84,238 at 4% or $56,158 at 6%; with 50% employer match about $56,158 at 4% or $37,439 at 6%; with 100% employer match about $42,119 at 4% or $28,079 at 6%.
2007115$906,154$47,891$3,193iApproximate average salary by contribution assumption: employee only about $79,818 at 4% or $53,212 at 6%; with 50% employer match about $53,212 at 4% or $35,475 at 6%; with 100% employer match about $39,909 at 4% or $26,606 at 6%.
Futureware Distributing Inc., 401K PlanCurrent15$906,154$47,891$3,193iApproximate average salary by contribution assumption: employee only about $79,818 at 4% or $53,212 at 6%; with 50% employer match about $53,212 at 4% or $35,475 at 6%; with 100% employer match about $39,909 at 4% or $26,606 at 6%.
2006122$955,173$69,488$3,159iApproximate average salary by contribution assumption: employee only about $78,964 at 4% or $52,642 at 6%; with 50% employer match about $52,642 at 4% or $35,095 at 6%; with 100% employer match about $39,482 at 4% or $26,321 at 6%.
Futureware Distributing Inc., 401K Plan-22$955,173$69,488$3,159iApproximate average salary by contribution assumption: employee only about $78,964 at 4% or $52,642 at 6%; with 50% employer match about $52,642 at 4% or $35,095 at 6%; with 100% employer match about $39,482 at 4% or $26,321 at 6%.
2005125$912,014$69,835$2,793iApproximate average salary by contribution assumption: employee only about $69,835 at 4% or $46,557 at 6%; with 50% employer match about $46,557 at 4% or $31,038 at 6%; with 100% employer match about $34,918 at 4% or $23,278 at 6%.
Futureware Distributing Inc., 401K Plan-25$912,014$69,835$2,793iApproximate average salary by contribution assumption: employee only about $69,835 at 4% or $46,557 at 6%; with 50% employer match about $46,557 at 4% or $31,038 at 6%; with 100% employer match about $34,918 at 4% or $23,278 at 6%.
2004123$802,310$65,631$2,854iApproximate average salary by contribution assumption: employee only about $71,338 at 4% or $47,559 at 6%; with 50% employer match about $47,559 at 4% or $31,706 at 6%; with 100% employer match about $35,669 at 4% or $23,779 at 6%.
Futureware Distributing Inc., 401K Plan-23$802,310$65,631$2,854iApproximate average salary by contribution assumption: employee only about $71,338 at 4% or $47,559 at 6%; with 50% employer match about $47,559 at 4% or $31,706 at 6%; with 100% employer match about $35,669 at 4% or $23,779 at 6%.
2003126$669,866$70,944$2,729iApproximate average salary by contribution assumption: employee only about $68,215 at 4% or $45,477 at 6%; with 50% employer match about $45,477 at 4% or $30,318 at 6%; with 100% employer match about $34,108 at 4% or $22,738 at 6%.
Futureware Distributing Inc., 401K Plan-26$669,866$70,944$2,729iApproximate average salary by contribution assumption: employee only about $68,215 at 4% or $45,477 at 6%; with 50% employer match about $45,477 at 4% or $30,318 at 6%; with 100% employer match about $34,108 at 4% or $22,738 at 6%.
2002126$473,763$74,783$2,876iApproximate average salary by contribution assumption: employee only about $71,907 at 4% or $47,938 at 6%; with 50% employer match about $47,938 at 4% or $31,959 at 6%; with 100% employer match about $35,953 at 4% or $23,969 at 6%.
Futureware Distributing Inc., 401K Plan-26$473,763$74,783$2,876iApproximate average salary by contribution assumption: employee only about $71,907 at 4% or $47,938 at 6%; with 50% employer match about $47,938 at 4% or $31,959 at 6%; with 100% employer match about $35,953 at 4% or $23,969 at 6%.
2001122$507,821$73,207$3,328iApproximate average salary by contribution assumption: employee only about $83,190 at 4% or $55,460 at 6%; with 50% employer match about $55,460 at 4% or $36,973 at 6%; with 100% employer match about $41,595 at 4% or $27,730 at 6%.
Futureware Distributing Inc., 401K Plan-22$507,821$73,207$3,328iApproximate average salary by contribution assumption: employee only about $83,190 at 4% or $55,460 at 6%; with 50% employer match about $55,460 at 4% or $36,973 at 6%; with 100% employer match about $41,595 at 4% or $27,730 at 6%.
2000124$510,678$88,897$3,704iApproximate average salary by contribution assumption: employee only about $92,601 at 4% or $61,734 at 6%; with 50% employer match about $61,734 at 4% or $41,156 at 6%; with 100% employer match about $46,301 at 4% or $30,867 at 6%.
Futureware Distributing Inc., 401K Plan-24$510,678$88,897$3,704iApproximate average salary by contribution assumption: employee only about $92,601 at 4% or $61,734 at 6%; with 50% employer match about $61,734 at 4% or $41,156 at 6%; with 100% employer match about $46,301 at 4% or $30,867 at 6%.
1999125$565,581$76,492$3,060iApproximate average salary by contribution assumption: employee only about $76,492 at 4% or $50,995 at 6%; with 50% employer match about $50,995 at 4% or $33,996 at 6%; with 100% employer match about $38,246 at 4% or $25,497 at 6%.
Futureware Distributing Inc., 401K Plan-25$565,581$76,492$3,060iApproximate average salary by contribution assumption: employee only about $76,492 at 4% or $50,995 at 6%; with 50% employer match about $50,995 at 4% or $33,996 at 6%; with 100% employer match about $38,246 at 4% or $25,497 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$906,154-$49,019 change

Balance Sheet

Beginning and end of plan year.

Total assets$955,173$906,154Decrease -$49,019 (-5.13%)
Total liabilities$0$0No change $0
Net assets$955,173$906,154Decrease -$49,019 (-5.13%)

Contributions

Employer contributions$7,503
Participant contributions$40,388
Other contributions$0

Income & Expenses

Total income$100,857
Total expenses$149,876
Net income$-49,019
Source fields
Schedule I source fields
Filing Id
86037122000308
Schedule I EIN
47-0665232
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2007-01-01
Schedule I Tax Period
20071231
Small plan total assets at beginning of year
$955,173
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$955,173
Small plan total assets at end of year
$906,154
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$906,154
Small plan employer contributions
$7,503
Small plan participant contributions
$40,388
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$52,966
Small plan total income
$100,857
Small plan total benefit distributions
$137,940
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
11936
Small Oth Expenses Amount
$0
Small plan total expenses
$149,876
Small plan net income or loss
$-49,019
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
$20,438
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
$200,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

Schedule R

Schedule R Pension Information

Retirement plan characteristics

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

Pension & Payor

Payor EIN31-4156830

Transfers

Distributed property value$0
Schedule R source fields
Payor 31-4156830
Filing Id
86037122000308
Schedule R EIN
47-0665232
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2007-01-01
Schedule R Tax Period
20071231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
31-4156830
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 Satisfy Cover Basis Code
1