BANK OF SUN PRAIRIE has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan BANK OF SUN PRAIRIE PENSION PLAN
Measure | Date | Value |
---|
2023: BANK OF SUN PRAIRIE PENSION PLAN 2023 401k membership |
---|
Market value of plan assets | 2023-05-14 | 4,261,575 |
Acturial value of plan assets | 2023-05-14 | 4,261,575 |
Funding target for retired participants and beneficiaries receiving payment | 2023-05-14 | 0 |
Number of terminated vested participants | 2023-05-14 | 23 |
Fundng target for terminated vested participants | 2023-05-14 | 432,373 |
Active participant vested funding target | 2023-05-14 | 2,351,733 |
Number of active participants | 2023-05-14 | 60 |
Total funding liabilities for active participants | 2023-05-14 | 2,528,750 |
Total participant count | 2023-05-14 | 83 |
Total funding target for all participants | 2023-05-14 | 2,961,123 |
Balance at beginning of prior year after applicable adjustments | 2023-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2023-05-14 | 847,202 |
Amount remaining of carryover balance | 2023-05-14 | 0 |
Amount remaining of prefunding balance | 2023-05-14 | 847,202 |
Present value of excess contributions | 2023-05-14 | 993,701 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2023-05-14 | 1,050,044 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2023-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2023-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2023-05-14 | 0 |
Balance of carryovers at beginning of current year | 2023-05-14 | 0 |
Balance of prefunding at beginning of current year | 2023-05-14 | 773,241 |
Total employer contributions | 2023-05-14 | 125,000 |
Total employee contributions | 2023-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2023-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2023-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2023-05-14 | 114,670 |
Unpaid minimum required contributions for all prior years | 2023-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2023-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2023-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2023-05-14 | 303,642 |
Net shortfall amortization installment of oustanding balance | 2023-05-14 | 0 |
Waiver amortization installment | 2023-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2023-05-14 | 0 |
Additional cash requirement | 2023-05-14 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2023-05-14 | 114,670 |
Unpaid minimum required contributions for current year | 2023-05-14 | 0 |
Unpaid minimum required contributions for all years | 2023-05-14 | 0 |
2022: BANK OF SUN PRAIRIE PENSION PLAN 2022 401k membership |
---|
Market value of plan assets | 2022-05-14 | 5,894,693 |
Acturial value of plan assets | 2022-05-14 | 5,894,693 |
Funding target for retired participants and beneficiaries receiving payment | 2022-05-14 | 0 |
Number of terminated vested participants | 2022-05-14 | 23 |
Fundng target for terminated vested participants | 2022-05-14 | 884,945 |
Active participant vested funding target | 2022-05-14 | 2,911,363 |
Number of active participants | 2022-05-14 | 64 |
Total funding liabilities for active participants | 2022-05-14 | 3,128,996 |
Total participant count | 2022-05-14 | 87 |
Total funding target for all participants | 2022-05-14 | 4,013,941 |
Balance at beginning of prior year after applicable adjustments | 2022-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2022-05-14 | 738,624 |
Amount remaining of carryover balance | 2022-05-14 | 0 |
Amount remaining of prefunding balance | 2022-05-14 | 738,624 |
Present value of excess contributions | 2022-05-14 | 869,056 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-05-14 | 917,376 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2022-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2022-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2022-05-14 | 0 |
Balance of carryovers at beginning of current year | 2022-05-14 | 0 |
Balance of prefunding at beginning of current year | 2022-05-14 | 847,202 |
Total employer contributions | 2022-05-14 | 1,065,000 |
Total employee contributions | 2022-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2022-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2022-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2022-05-14 | 993,701 |
Unpaid minimum required contributions for all prior years | 2022-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2022-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2022-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2022-05-14 | 287,436 |
Net shortfall amortization installment of oustanding balance | 2022-05-14 | 0 |
Waiver amortization installment | 2022-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2022-05-14 | 0 |
Additional cash requirement | 2022-05-14 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2022-05-14 | 993,701 |
Unpaid minimum required contributions for current year | 2022-05-14 | 0 |
Unpaid minimum required contributions for all years | 2022-05-14 | 0 |
2021: BANK OF SUN PRAIRIE PENSION PLAN 2021 401k membership |
---|
Market value of plan assets | 2021-05-14 | 5,798,377 |
Acturial value of plan assets | 2021-05-14 | 5,798,377 |
Funding target for retired participants and beneficiaries receiving payment | 2021-05-14 | 0 |
Number of terminated vested participants | 2021-05-14 | 17 |
Fundng target for terminated vested participants | 2021-05-14 | 545,235 |
Active participant vested funding target | 2021-05-14 | 3,900,816 |
Number of active participants | 2021-05-14 | 63 |
Total funding liabilities for active participants | 2021-05-14 | 4,153,759 |
Total participant count | 2021-05-14 | 80 |
Total funding target for all participants | 2021-05-14 | 4,698,994 |
Balance at beginning of prior year after applicable adjustments | 2021-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2021-05-14 | 696,290 |
Amount remaining of carryover balance | 2021-05-14 | 0 |
Amount remaining of prefunding balance | 2021-05-14 | 696,290 |
Present value of excess contributions | 2021-05-14 | 1,187,418 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2021-05-14 | 1,254,151 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2021-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2021-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2021-05-14 | 0 |
Balance of carryovers at beginning of current year | 2021-05-14 | 0 |
Balance of prefunding at beginning of current year | 2021-05-14 | 738,624 |
Total employer contributions | 2021-05-14 | 930,000 |
Total employee contributions | 2021-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2021-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2021-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2021-05-14 | 869,056 |
Unpaid minimum required contributions for all prior years | 2021-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2021-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2021-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2021-05-14 | 339,024 |
Net shortfall amortization installment of oustanding balance | 2021-05-14 | 0 |
Waiver amortization installment | 2021-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2021-05-14 | 0 |
Additional cash requirement | 2021-05-14 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2021-05-14 | 869,056 |
Unpaid minimum required contributions for current year | 2021-05-14 | 0 |
Unpaid minimum required contributions for all years | 2021-05-14 | 0 |
2020: BANK OF SUN PRAIRIE PENSION PLAN 2020 401k membership |
---|
Market value of plan assets | 2020-05-14 | 4,275,197 |
Acturial value of plan assets | 2020-05-14 | 4,275,197 |
Funding target for retired participants and beneficiaries receiving payment | 2020-05-14 | 0 |
Number of terminated vested participants | 2020-05-14 | 16 |
Fundng target for terminated vested participants | 2020-05-14 | 464,767 |
Active participant vested funding target | 2020-05-14 | 3,778,192 |
Number of active participants | 2020-05-14 | 66 |
Total funding liabilities for active participants | 2020-05-14 | 4,008,918 |
Total participant count | 2020-05-14 | 82 |
Total funding target for all participants | 2020-05-14 | 4,473,685 |
Balance at beginning of prior year after applicable adjustments | 2020-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2020-05-14 | 690,725 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2020-05-14 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2020-05-14 | 0 |
Amount remaining of carryover balance | 2020-05-14 | 0 |
Amount remaining of prefunding balance | 2020-05-14 | 690,725 |
Present value of excess contributions | 2020-05-14 | 135,300 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-05-14 | 143,107 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2020-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2020-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2020-05-14 | 513 |
Balance of carryovers at beginning of current year | 2020-05-14 | 0 |
Balance of prefunding at beginning of current year | 2020-05-14 | 696,290 |
Total employer contributions | 2020-05-14 | 1,720,430 |
Total employee contributions | 2020-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2020-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2020-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2020-05-14 | 1,639,878 |
Unpaid minimum required contributions for all prior years | 2020-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2020-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2020-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2020-05-14 | 301,096 |
Net shortfall amortization installment of oustanding balance | 2020-05-14 | 894,778 |
Waiver amortization installment | 2020-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2020-05-14 | 452,460 |
Additional cash requirement | 2020-05-14 | 452,460 |
Contributions allocatedtoward minimum required contributions for current year | 2020-05-14 | 1,639,878 |
Unpaid minimum required contributions for current year | 2020-05-14 | 0 |
Unpaid minimum required contributions for all years | 2020-05-14 | 0 |
2019: BANK OF SUN PRAIRIE PENSION PLAN 2019 401k membership |
---|
Market value of plan assets | 2019-05-14 | 6,106,443 |
Acturial value of plan assets | 2019-05-14 | 6,106,443 |
Funding target for retired participants and beneficiaries receiving payment | 2019-05-14 | 0 |
Number of terminated vested participants | 2019-05-14 | 17 |
Fundng target for terminated vested participants | 2019-05-14 | 982,404 |
Active participant vested funding target | 2019-05-14 | 4,526,200 |
Number of active participants | 2019-05-14 | 64 |
Total funding liabilities for active participants | 2019-05-14 | 4,732,540 |
Total participant count | 2019-05-14 | 81 |
Total funding target for all participants | 2019-05-14 | 5,714,944 |
Balance at beginning of prior year after applicable adjustments | 2019-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2019-05-14 | 633,809 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2019-05-14 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2019-05-14 | 0 |
Amount remaining of carryover balance | 2019-05-14 | 0 |
Amount remaining of prefunding balance | 2019-05-14 | 633,809 |
Present value of excess contributions | 2019-05-14 | 23,252 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-05-14 | 24,570 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2019-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2019-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2019-05-14 | 0 |
Balance of carryovers at beginning of current year | 2019-05-14 | 0 |
Balance of prefunding at beginning of current year | 2019-05-14 | 690,725 |
Total employer contributions | 2019-05-14 | 450,000 |
Total employee contributions | 2019-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2019-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2019-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2019-05-14 | 430,560 |
Unpaid minimum required contributions for all prior years | 2019-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2019-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2019-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2019-05-14 | 279,720 |
Net shortfall amortization installment of oustanding balance | 2019-05-14 | 72,060 |
Waiver amortization installment | 2019-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2019-05-14 | 295,261 |
Carryover balance elected to use to offset funding requirement | 2019-05-14 | 0 |
Prefunding balance elected to use to offset funding requirement | 2019-05-14 | 0 |
Additional cash requirement | 2019-05-14 | 295,261 |
Contributions allocatedtoward minimum required contributions for current year | 2019-05-14 | 430,560 |
Unpaid minimum required contributions for current year | 2019-05-14 | 0 |
Unpaid minimum required contributions for all years | 2019-05-14 | 0 |
2018: BANK OF SUN PRAIRIE PENSION PLAN 2018 401k membership |
---|
Market value of plan assets | 2018-05-14 | 5,517,694 |
Acturial value of plan assets | 2018-05-14 | 5,517,694 |
Funding target for retired participants and beneficiaries receiving payment | 2018-05-14 | 0 |
Number of terminated vested participants | 2018-05-14 | 17 |
Fundng target for terminated vested participants | 2018-05-14 | 691,241 |
Active participant vested funding target | 2018-05-14 | 4,265,751 |
Number of active participants | 2018-05-14 | 70 |
Total funding liabilities for active participants | 2018-05-14 | 4,406,980 |
Total participant count | 2018-05-14 | 87 |
Total funding target for all participants | 2018-05-14 | 5,098,221 |
Balance at beginning of prior year after applicable adjustments | 2018-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2018-05-14 | 889,164 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2018-05-14 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2018-05-14 | 309,496 |
Amount remaining of carryover balance | 2018-05-14 | 0 |
Amount remaining of prefunding balance | 2018-05-14 | 579,668 |
Present value of excess contributions | 2018-05-14 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-05-14 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2018-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2018-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2018-05-14 | 0 |
Balance of carryovers at beginning of current year | 2018-05-14 | 0 |
Balance of prefunding at beginning of current year | 2018-05-14 | 633,809 |
Total employer contributions | 2018-05-14 | 583,333 |
Total employee contributions | 2018-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2018-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2018-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2018-05-14 | 563,199 |
Unpaid minimum required contributions for all prior years | 2018-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2018-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2018-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2018-05-14 | 524,406 |
Net shortfall amortization installment of oustanding balance | 2018-05-14 | 83,509 |
Waiver amortization installment | 2018-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2018-05-14 | 539,947 |
Carryover balance elected to use to offset funding requirement | 2018-05-14 | 0 |
Prefunding balance elected to use to offset funding requirement | 2018-05-14 | 0 |
Additional cash requirement | 2018-05-14 | 539,947 |
Contributions allocatedtoward minimum required contributions for current year | 2018-05-14 | 563,199 |
Unpaid minimum required contributions for current year | 2018-05-14 | 0 |
Unpaid minimum required contributions for all years | 2018-05-14 | 0 |
2017: BANK OF SUN PRAIRIE PENSION PLAN 2017 401k membership |
---|
Market value of plan assets | 2017-05-14 | 5,734,979 |
Acturial value of plan assets | 2017-05-14 | 5,734,979 |
Funding target for retired participants and beneficiaries receiving payment | 2017-05-14 | 0 |
Number of terminated vested participants | 2017-05-14 | 12 |
Fundng target for terminated vested participants | 2017-05-14 | 711,577 |
Active participant vested funding target | 2017-05-14 | 4,139,417 |
Number of active participants | 2017-05-14 | 69 |
Total funding liabilities for active participants | 2017-05-14 | 4,228,300 |
Total participant count | 2017-05-14 | 81 |
Total funding target for all participants | 2017-05-14 | 4,939,877 |
Balance at beginning of prior year after applicable adjustments | 2017-05-14 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2017-05-14 | 897,239 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2017-05-14 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2017-05-14 | 0 |
Amount remaining of carryover balance | 2017-05-14 | 0 |
Amount remaining of prefunding balance | 2017-05-14 | 897,239 |
Present value of excess contributions | 2017-05-14 | 294,820 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2017-05-14 | 312,775 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2017-05-14 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2017-05-14 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2017-05-14 | 0 |
Balance of carryovers at beginning of current year | 2017-05-14 | 0 |
Balance of prefunding at beginning of current year | 2017-05-14 | 889,164 |
Total employer contributions | 2017-05-14 | 184,667 |
Total employee contributions | 2017-05-14 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2017-05-14 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2017-05-14 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2017-05-14 | 175,355 |
Unpaid minimum required contributions for all prior years | 2017-05-14 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2017-05-14 | 0 |
Remaining amount of unpaid minimum required contributions | 2017-05-14 | 0 |
Minimum required contributions for current year target normal cost | 2017-05-14 | 469,310 |
Net shortfall amortization installment of oustanding balance | 2017-05-14 | 94,062 |
Waiver amortization installment | 2017-05-14 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2017-05-14 | 484,851 |
Carryover balance elected to use to offset funding requirement | 2017-05-14 | 0 |
Prefunding balance elected to use to offset funding requirement | 2017-05-14 | 309,496 |
Additional cash requirement | 2017-05-14 | 175,355 |
Contributions allocatedtoward minimum required contributions for current year | 2017-05-14 | 175,355 |
Unpaid minimum required contributions for current year | 2017-05-14 | 0 |
Unpaid minimum required contributions for all years | 2017-05-14 | 0 |