Civic Intelligence
Filing

Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust

Steve Carstensen, D.D.S. • EIN 75-1904587 • Plan year 2004

Company ProfileSource Archive
Filing Insights

Participants

Up

6 → 7

1 • 16.67%

Assets

Up

$288,930 → $373,767

$84,837 • 29.36%

Investment Management Fee

-

Admin expenses - • Total expenses $8,925

Filing Details

Context
Net investment result
$84,837
Pension payor EIN
26-2178860

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
2014112$1,440,887$109,946$9,162iApproximate average salary by contribution assumption: employee only about $229,054 at 4% or $152,703 at 6%; with 50% employer match about $152,703 at 4% or $101,802 at 6%; with 100% employer match about $114,527 at 4% or $76,351 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-12$1,440,887$109,946$9,162iApproximate average salary by contribution assumption: employee only about $229,054 at 4% or $152,703 at 6%; with 50% employer match about $152,703 at 4% or $101,802 at 6%; with 100% employer match about $114,527 at 4% or $76,351 at 6%.
201319$1,291,777$106,889$11,877iApproximate average salary by contribution assumption: employee only about $296,914 at 4% or $197,943 at 6%; with 50% employer match about $197,943 at 4% or $131,962 at 6%; with 100% employer match about $148,457 at 4% or $98,971 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-9$1,291,777$106,889$11,877iApproximate average salary by contribution assumption: employee only about $296,914 at 4% or $197,943 at 6%; with 50% employer match about $197,943 at 4% or $131,962 at 6%; with 100% employer match about $148,457 at 4% or $98,971 at 6%.
201217$1,061,278$188,402$26,915iApproximate average salary by contribution assumption: employee only about $672,864 at 4% or $448,576 at 6%; with 50% employer match about $448,576 at 4% or $299,051 at 6%; with 100% employer match about $336,432 at 4% or $224,288 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-7$1,061,278$188,402$26,915iApproximate average salary by contribution assumption: employee only about $672,864 at 4% or $448,576 at 6%; with 50% employer match about $448,576 at 4% or $299,051 at 6%; with 100% employer match about $336,432 at 4% or $224,288 at 6%.
2011110$794,099$88,740$8,874iApproximate average salary by contribution assumption: employee only about $221,850 at 4% or $147,900 at 6%; with 50% employer match about $147,900 at 4% or $98,600 at 6%; with 100% employer match about $110,925 at 4% or $73,950 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-10$794,099$88,740$8,874iApproximate average salary by contribution assumption: employee only about $221,850 at 4% or $147,900 at 6%; with 50% employer match about $147,900 at 4% or $98,600 at 6%; with 100% employer match about $110,925 at 4% or $73,950 at 6%.
201016$708,880$64,702$10,784iApproximate average salary by contribution assumption: employee only about $269,592 at 4% or $179,728 at 6%; with 50% employer match about $179,728 at 4% or $119,819 at 6%; with 100% employer match about $134,796 at 4% or $89,864 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-6$708,880$64,702$10,784iApproximate average salary by contribution assumption: employee only about $269,592 at 4% or $179,728 at 6%; with 50% employer match about $179,728 at 4% or $119,819 at 6%; with 100% employer match about $134,796 at 4% or $89,864 at 6%.
200917$602,360$59,934$8,562iApproximate average salary by contribution assumption: employee only about $214,050 at 4% or $142,700 at 6%; with 50% employer match about $142,700 at 4% or $95,133 at 6%; with 100% employer match about $107,025 at 4% or $71,350 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-7$602,360$59,934$8,562iApproximate average salary by contribution assumption: employee only about $214,050 at 4% or $142,700 at 6%; with 50% employer match about $142,700 at 4% or $95,133 at 6%; with 100% employer match about $107,025 at 4% or $71,350 at 6%.
200816$0$0-
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-6---
200715$0$0-
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-5---
200616$565,680$58,960$9,827iApproximate average salary by contribution assumption: employee only about $245,667 at 4% or $163,778 at 6%; with 50% employer match about $163,778 at 4% or $109,185 at 6%; with 100% employer match about $122,833 at 4% or $81,889 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-6$565,680$58,960$9,827iApproximate average salary by contribution assumption: employee only about $245,667 at 4% or $163,778 at 6%; with 50% employer match about $163,778 at 4% or $109,185 at 6%; with 100% employer match about $122,833 at 4% or $81,889 at 6%.
200514$464,022$60,436$15,109iApproximate average salary by contribution assumption: employee only about $377,725 at 4% or $251,817 at 6%; with 50% employer match about $251,817 at 4% or $167,878 at 6%; with 100% employer match about $188,863 at 4% or $125,908 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-4$464,022$60,436$15,109iApproximate average salary by contribution assumption: employee only about $377,725 at 4% or $251,817 at 6%; with 50% employer match about $251,817 at 4% or $167,878 at 6%; with 100% employer match about $188,863 at 4% or $125,908 at 6%.
200417$373,767$49,243$7,035iApproximate average salary by contribution assumption: employee only about $175,868 at 4% or $117,245 at 6%; with 50% employer match about $117,245 at 4% or $78,163 at 6%; with 100% employer match about $87,934 at 4% or $58,623 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & TrustCurrent7$373,767$49,243$7,035iApproximate average salary by contribution assumption: employee only about $175,868 at 4% or $117,245 at 6%; with 50% employer match about $117,245 at 4% or $78,163 at 6%; with 100% employer match about $87,934 at 4% or $58,623 at 6%.
200313$288,930$114,044$38,015iApproximate average salary by contribution assumption: employee only about $950,367 at 4% or $633,578 at 6%; with 50% employer match about $633,578 at 4% or $422,385 at 6%; with 100% employer match about $475,183 at 4% or $316,789 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-3$288,930$114,044$38,015iApproximate average salary by contribution assumption: employee only about $950,367 at 4% or $633,578 at 6%; with 50% employer match about $633,578 at 4% or $422,385 at 6%; with 100% employer match about $475,183 at 4% or $316,789 at 6%.
200216$132,959$41,504$6,917iApproximate average salary by contribution assumption: employee only about $172,933 at 4% or $115,289 at 6%; with 50% employer match about $115,289 at 4% or $76,859 at 6%; with 100% employer match about $86,467 at 4% or $57,644 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-6$132,959$41,504$6,917iApproximate average salary by contribution assumption: employee only about $172,933 at 4% or $115,289 at 6%; with 50% employer match about $115,289 at 4% or $76,859 at 6%; with 100% employer match about $86,467 at 4% or $57,644 at 6%.
200115$120,808$31,390$6,278iApproximate average salary by contribution assumption: employee only about $156,950 at 4% or $104,633 at 6%; with 50% employer match about $104,633 at 4% or $69,756 at 6%; with 100% employer match about $78,475 at 4% or $52,317 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-5$120,808$31,390$6,278iApproximate average salary by contribution assumption: employee only about $156,950 at 4% or $104,633 at 6%; with 50% employer match about $104,633 at 4% or $69,756 at 6%; with 100% employer match about $78,475 at 4% or $52,317 at 6%.
200014$82,574$32,169$8,042iApproximate average salary by contribution assumption: employee only about $201,056 at 4% or $134,038 at 6%; with 50% employer match about $134,038 at 4% or $89,358 at 6%; with 100% employer match about $100,528 at 4% or $67,019 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-4$82,574$32,169$8,042iApproximate average salary by contribution assumption: employee only about $201,056 at 4% or $134,038 at 6%; with 50% employer match about $134,038 at 4% or $89,358 at 6%; with 100% employer match about $100,528 at 4% or $67,019 at 6%.
199914$45,823$8,868$2,217iApproximate average salary by contribution assumption: employee only about $55,425 at 4% or $36,950 at 6%; with 50% employer match about $36,950 at 4% or $24,633 at 6%; with 100% employer match about $27,713 at 4% or $18,475 at 6%.
Steve Carstensen, D.D.S. Money Purchase Pension Plan & Trust-4$45,823$8,868$2,217iApproximate average salary by contribution assumption: employee only about $55,425 at 4% or $36,950 at 6%; with 50% employer match about $36,950 at 4% or $24,633 at 6%; with 100% employer match about $27,713 at 4% or $18,475 at 6%.
Schedule Details

Schedule D

Row 1
Filing Id
84037273473275
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC EQUITY FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655002
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$25,788
Row 2
Filing Id
84037273473275
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
4020375273473020002
Row 3
Filing Id
84037273473275
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC LARGE CAP FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655007
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$16,819
Row 4
Filing Id
84037273473275
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC MID CAP FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655006
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$77,949
Row 5
Filing Id
84037273473275
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC SCIENCE AND TECHNOLOGY FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655005
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$61,775
Row 6
Filing Id
84037273473275
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC SMALL CAP FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655003
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$62,946
Row 7
Filing Id
84037273473275
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC USA GLOBAL FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655004
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$56,237
Row 8
Filing Id
84037273473275
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
4020375273473020002
DFE P1 Entity 01 Name
GPTC FIXED INCOME FUND
DFE P1 Spons 01 Name
GREAT PLAINS TRUST COMPANY
DFE P1 Plan 01 EIN Plan number
486149655001
DFE P1 Entity 01 Code
C
DFE P1 Plan Interest End of year 01 Amount
$48,619

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$373,767$84,837 change

Balance Sheet

Beginning and end of plan year.

Total assets$288,930$373,767Increase +$84,837 (29.36%)
Total liabilities$0$0No change $0
Net assets$288,930$373,767Increase +$84,837 (29.36%)

Contributions

Employer contributions$16,000
Participant contributions$33,243
Other contributions$0

Income & Expenses

Total income$93,762
Total expenses$8,925
Net income$84,837
Source fields
Schedule I source fields
Filing Id
84037273473275
Schedule I EIN
75-1904587
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2004-01-01
Schedule I Tax Period
20041231
Small plan total assets at beginning of year
$288,930
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$288,930
Small plan total assets at end of year
$373,767
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$373,767
Small plan employer contributions
$16,000
Small plan participant contributions
$33,243
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$44,519
Small plan total income
$93,762
Small plan total benefit distributions
$5,936
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$2,989
Small plan total expenses
$8,925
Small plan net income or loss
$84,837
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
$45,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
$202,671
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 EIN26-2178860

Transfers

Distributed property value$0
Schedule R source fields
Payor 26-2178860
Filing Id
84037273473275
Schedule R EIN
75-1904587
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2004-01-01
Schedule R Tax Period
20041231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
26-2178860
Pension Bnft Distribution Sngl Sum Count
0
Pension Elec Satisfy Code 412 Indicator
3
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0