2025 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

SCHEDULE OF COMPONENT UNIT'S PROPORTIONATE SHARE OF NET PENSION LIABILITY LAST 10 YEARS GENERAL EMPLOYEES RETIREMENT FUND

Proportionate Share of the Net Pension Liability Associated with the Component Pension Liability and Share of the Net Component Unit's the State's

State's

Unit's

Plan

Net Pension Share of the Proportionate

Net Pension Share of the Liability as a Proportionate Percentage of

Fiduciary

Component

Component

Net Position

Unit's

Unit's

as a

0.0639% 0.0645% 0.0678% 0.0644% 0.0621% 0.0668% 0.0634% 0.0716% 0.0677% 0.0658% Liability Pension of the Net Proportion

Share of the Proportionate Net Pension

Liability

Component

of the Total Percentage

Associated with the Component

Unit's

June 30, 2019 June 30, 2018 June 30, 2020 June 30, 2017 June 30, 2016 June 30, 2022 June 30, 2021 June 30, 2023 June 30, 2024 June 30, 2025 Year Ended For the Fiscal

Payroll Covered

59.46% 115.59% 105.62% 78.12% 42.68% 73.08% 35.51% 99.17% 82.57% 130.82% Payroll Covered

79.50% 80.20% 79.00% 75.90% 87.00% 76.67% 89.10% 83.10% 90.80% 68.91% Liability Pension

Liability

Unit

Unit

$

3,532,888 3,578,196 4,064,920 4,111,253 5,042,212 5,290,582 4,003,792 2,502,508 2,180,765 2,707,464

$

82,761 125,364 155,198 109,829 117,344 51,656 65,842 110,260 64,710 52,607

$

2,790,225 4,190,284 5,445,780 3,642,717 3,695,540 4,162,909 5,108,054 4,114,052 2,567,218 2,233,372

$

4,553,229 3,516,627 5,009,118 4,522,507 4,333,280 5,863,021 5,478,816 6,141,055 4,145,653 3,854,427

108