Civic Intelligence
Filing

Hnt Technology Inc. Pension Plan

Hnt Technology Inc. • EIN 57-1163473 • Plan year 2012

Filing Insights

Participants

Flat

6 → 6

0 • 0.00%

Assets

Up

$999,328 → $1,253,504

$254,176 • 25.43%

Investment Management Fee

0.00%

$0

Admin expenses $0 • Total expenses $0

Filing Details

Context
Net investment result
$254,176

Status Flags

Fidelity bond in place

No

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

No

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

No

Plan blackout period

No

Plan termination resolution adopted

No

Counterparties

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
201310$0$0-
Hnt Technology Inc. Pension Plan-0---
201216$1,253,504$200,000$33,333iApproximate average salary by contribution assumption: employee only about $833,333 at 4% or $555,556 at 6%; with 50% employer match about $555,556 at 4% or $370,370 at 6%; with 100% employer match about $416,667 at 4% or $277,778 at 6%.
Hnt Technology Inc. Pension PlanCurrent6$1,253,504$200,000$33,333iApproximate average salary by contribution assumption: employee only about $833,333 at 4% or $555,556 at 6%; with 50% employer match about $555,556 at 4% or $370,370 at 6%; with 100% employer match about $416,667 at 4% or $277,778 at 6%.
201115$999,328$206,500$41,300iApproximate average salary by contribution assumption: employee only about $1,032,500 at 4% or $688,333 at 6%; with 50% employer match about $688,333 at 4% or $458,889 at 6%; with 100% employer match about $516,250 at 4% or $344,167 at 6%.
Hnt Technology Inc. Pension Plan-5$999,328$206,500$41,300iApproximate average salary by contribution assumption: employee only about $1,032,500 at 4% or $688,333 at 6%; with 50% employer match about $688,333 at 4% or $458,889 at 6%; with 100% employer match about $516,250 at 4% or $344,167 at 6%.
201015$840,791$226,930$45,386iApproximate average salary by contribution assumption: employee only about $1,134,650 at 4% or $756,433 at 6%; with 50% employer match about $756,433 at 4% or $504,289 at 6%; with 100% employer match about $567,325 at 4% or $378,217 at 6%.
Hnt Technology Inc. Pension Plan-5$840,791$226,930$45,386iApproximate average salary by contribution assumption: employee only about $1,134,650 at 4% or $756,433 at 6%; with 50% employer match about $756,433 at 4% or $504,289 at 6%; with 100% employer match about $567,325 at 4% or $378,217 at 6%.
200913$608,509$240,796$80,265iApproximate average salary by contribution assumption: employee only about $2,006,633 at 4% or $1,337,756 at 6%; with 50% employer match about $1,337,756 at 4% or $891,837 at 6%; with 100% employer match about $1,003,317 at 4% or $668,878 at 6%.
Hnt Technology Inc. Pension Plan-3$608,509$240,796$80,265iApproximate average salary by contribution assumption: employee only about $2,006,633 at 4% or $1,337,756 at 6%; with 50% employer match about $1,337,756 at 4% or $891,837 at 6%; with 100% employer match about $1,003,317 at 4% or $668,878 at 6%.
200814$365,718$0-
Hnt Technology Inc. Pension Plan-4$365,718--
200713$0$0-
Hnt Technology Inc. Pension Plan-3---
200612$240,111$50,000$25,000iApproximate average salary by contribution assumption: employee only about $625,000 at 4% or $416,667 at 6%; with 50% employer match about $416,667 at 4% or $277,778 at 6%; with 100% employer match about $312,500 at 4% or $208,333 at 6%.
Hnt Technology Inc. Pension Plan-2$240,111$50,000$25,000iApproximate average salary by contribution assumption: employee only about $625,000 at 4% or $416,667 at 6%; with 50% employer match about $416,667 at 4% or $277,778 at 6%; with 100% employer match about $312,500 at 4% or $208,333 at 6%.
200512$185,000$185,000$92,500iApproximate average salary by contribution assumption: employee only about $2,312,500 at 4% or $1,541,667 at 6%; with 50% employer match about $1,541,667 at 4% or $1,027,778 at 6%; with 100% employer match about $1,156,250 at 4% or $770,833 at 6%.
Hnt Technology Inc. Pension Plan-2$185,000$185,000$92,500iApproximate average salary by contribution assumption: employee only about $2,312,500 at 4% or $1,541,667 at 6%; with 50% employer match about $1,541,667 at 4% or $1,027,778 at 6%; with 100% employer match about $1,156,250 at 4% or $770,833 at 6%.
Schedule Details

Schedule A

Row 1
Ins Carrier Name: METROPOLITAN LIFE INSURANCE COMPANY
Form Id
1
Schedule A Plan Year Begin Date
2012-01-01
Schedule A Plan Year End Date
2012-12-31
Schedule A Plan Num
001
Schedule A EIN
57-1163473
Ins Carrier Name
METROPOLITAN LIFE INSURANCE COMPANY
Ins Carrier Naic Code
00000
Ins Contract Num
209064911PR
Ins Prsn Covered End of year Count
1
Ins Policy From Date
2012-01-01
Ins Policy To Date
2012-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$25,236
Alloc Contracts Indiv Indicator
Yes
Row 2
Ins Carrier Name: METROPOLITAN LIFE INSURANCE COMPANY
Form Id
2
Schedule A Plan Year Begin Date
2012-01-01
Schedule A Plan Year End Date
2012-12-31
Schedule A Plan Num
001
Schedule A EIN
57-1163473
Ins Carrier Name
METROPOLITAN LIFE INSURANCE COMPANY
Ins Carrier Naic Code
00000
Ins Contract Num
204044429PR
Ins Prsn Covered End of year Count
1
Ins Policy From Date
2012-01-01
Ins Policy To Date
2012-12-31
Ins Broker Comm Total Amount
$0
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$0
Alloc Contracts Indiv Indicator
Yes

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,253,504$254,176 change

Balance Sheet

Beginning and end of plan year.

Total assets$999,328$1,253,504Increase +$254,176 (25.43%)
Total liabilities$0$0No change $0
Net assets$999,328$1,253,504Increase +$254,176 (25.43%)

Contributions

Employer contributions$200,000
Participant contributions$0
Other contributions$0

Income & Expenses

Total income$254,176
Total expenses$0
Net income$254,176
Source fields
Schedule I source fields
Schedule I Plan Year Begin Date
2012-01-01
Schedule I Tax Period
2012-12-31
Schedule I Plan Num
001
Schedule I EIN
57-1163473
Small plan total assets at beginning of year
$999,328
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$999,328
Small plan total assets at end of year
$1,253,504
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$1,253,504
Small plan employer contributions
$200,000
Small plan participant contributions
$0
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$54,176
Small plan total income
$254,176
Small plan total benefit distributions
$0
Small Corrective Distribution Amount
$0
Small Deem Dstrb Participants Ln Amount
$0
Small Admin Srvc Providers Amount
$0
Small Oth Expenses Amount
$0
Small plan total expenses
$0
Small plan net income or loss
$254,176
Small Total Plan Transfers Amount
$0
Small Joint Venture End of year Indicator
No
Small Employer Prop End of year Indicator
No
Small Inv Real Estate End of year Indicator
No
Small Employer Sec End of year Indicator
No
Small Mortg Participants End of year Indicator
Yes
Small Mortg Participants End of year Amount
$89,634
Small Oth Lns Participants End of year Indicator
No
Small Personal Prop End of year Indicator
No
Small Fail Transm Contribution Indicator
No
Small plan participant loans in default
No
Small plan leases in default
No
Small plan nonexempt transactions with parties in interest
No
Small plan fidelity bond in place
No
Small plan loss discovered during year
No
Small plan assets with undetermined value
No
Small plan non-cash contributions reported
No
Small 20 Percent Sngl Investment Indicator
No
Small plan all plan assets distributed
No
Small plan waived annual IQPA report
Yes
Small plan failed to provide benefits when due
No
Small plan blackout period occurred
No
Small plan resolution to terminate plan adopted
No

Schedule R

Schedule R Pension Information

Retirement plan characteristics

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

Schedule R source fields
Row 1
Schedule R Plan Year Begin Date
2012-01-01
Schedule R Tax Period
2012-12-31
Schedule R Plan number
001
Schedule R EIN
57-1163473
Pension Bnft Distribution Sngl Sum Count
0
Pension Elec Satisfy Code 412 Indicator
No
Pension Chg Fndng Method Indicator
3
Pension Amdmt Incr Valuation Bnft Code
4

Schedule SB

Row 1
Sb Contribution Date
2012-06-18
Sb Contribution Employer Amount
$200,000
Sb Contribution Emplee Amount
$0
Row 2
Sb Plan Year Begin Date
2012-01-01
Sb Tax Period
2012-12-31
Sb Plan number
001
Sb EIN
57-1163473
Sb Plan Type Code
1
Sb Count Participants Pr Yr Code
1
Sb Value Date
2012-12-31
Sb Curr Value Asset 01 Amount
$1,046,831
Sb Actrl Value Asset Amount
$1,046,831
Sb Rtd Participants Count
0
Sb Rtd Fndng Tgt Amount
$0
Sb Terminate Participants Count
0
Sb Terminate Fndng Tgt Amount
$0
Sb Act Nonvstd Fndng Tgt Amount
$0
Sb Act Vstd Fndng Tgt Amount
$935,156
Sb Act Participants Count
6
Sb Liability Act Total Fndng Tgt Amount
$935,156
Sb Total Participants Count
6
Sb Total Fndng Tgt Amount
$935,156
Sb Eff Interest Rate Percent
6.32
Sb Tgt Nrml Cost 01 Amount
$141,847
Sb Signature Date
2013-03-06
Sb Actuary Name Line
HUNG-HSUN CHENG
Sb Actuary Firm Name
ALLIED CONSULTANTS, INC.
Sb Actuary US Address1
190 E. ARROW HWY., UNIT D
Sb Actuary US City
SAN DIMAS
Sb Actuary US State
CA
Sb Actuary US ZIP
91773
Sb Actuary Phone Num
9096700188
Sb Actry Enrlmt Num
1106724
Sb Carryover Pr Yr Amount
$0
Sb Pre Fndng Pr Yr Amount
$0
Sb Carryover Used Pr Yr Amount
$0
Sb Pre Fndng Used Pr Yr Amount
$0
Sb Carryover Pr Yr Total Amount
$0
Sb Pre Fndng Pr Yr Total Amount
$0
Sb Interest Pr Yr Carryover Amount
$0
Sb Interest Pr Yr Pre Fndng Amount
$0
Sb Excess Contribution Amount
$152,395
Sb Excess Contribution Interest Percent
5.21
Sb Excess Contribution Interest Amount
$0
Sb Excess Contribution Avail Amount
$152,395
Sb Excess Contribution Added Amount
$0
Sb Carryover Reduction Amount
$0
Sb Pre Fndng Reduction Amount
$0
Sb Carryover Beginning of year Total Amount
$0
Sb Pre Fndng Beginning of year Total Amount
$0
Sb Fndng Tgt Percent
111.94
Sb Adj Fndng Tgt Percent
113.55
Sb Pr Yr Fndng Percent
109.20
Sb Total Employer Contribution Amount
$200,000
Sb Total Emplee Contribution Amount
$0
Sb Contribution Alloc Pr Yr 01 Amount
$0
Sb Contribution Avoid Restric Amount
$0
Sb Contribution Alloc Curr Yr Amount
$206,672
Sb Fndng Short Indicator
No
Sb 1St Seg Rate Percent
5.54
Sb 2Nd Seg Rate Percent
6.85
Sb 3Rd Seg Rate Percent
7.52
Sb Applicable Month Code
0
Sb Weighted Rtm Age
62
Sb Mortality Tbl Code
1
Sb Chg Actrl Assump Curr Indicator
No
Sb Chg Method Indicator
No
Sb Schedule Active Participants Rqd Indicator
No
Sb Unpaid Pr Yr Contribution Amount
$0
Sb Contribution Alloc Pr Yr 02 Amount
$0
Sb Unpaid Min Rqd Total Amount
$0
Sb Tgt Nrml Cost 02 Amount
$141,847
Sb Short Amortz Outstd Amount
$0
Sb Short Amortz Inst
0
Sb Wvrs Amortz Outstd Amount
$0
Sb Wvrs Amortz Inst
0
Sb Waived Amount
$0
Sb Fndng Rqmt Total Amount
$30,172
Sb Offset Carryover Amount
$0
Sb Offset Pre Fndng Amount
$0
Sb Offset Bal
0
Sb Addl Cash Total Amount
$30,172
Sb Contr Alloc Curr Yr 02 Amount
$206,672
Sb Unp Min Cont Cur Yr Total Amount
$0
Sb Min Req Cont Excess Asset Amount
$111,675
Sb Port Prefndng Fndng Car Amount
$0
Sb Present Valuation Exces Cont Amount
$176,500

Filing received by DOL May 21, 2013