2025 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

SCHEDULE OF CITY'S PROPORTIONATE SHARE OF NET PENSION LIABILITY

LAST 10 YEARS GENERAL EMPLOYEES RETIREMENT FUND

City's Proportionate

City's

Plan

Net Pension Share of the Liability Associated State's Proportionate with the City

Share of the Net

Net Pension Liability as a Percentage of Covered Proportionate Share of the

Fiduciary Net Position as a Percentage of the Total Pension

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

City's Proportion of the Net 0.1153% Liability 0.1148% 0.1133% 0.1199% 0.1142% Pension 0.1045% 0.1026% 0.1062% 0.1108% 0.0933%

City's Proportionate Share of the Net Pension

City's Covered Payroll

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

Liability

70.29% 105.77% 43.70% 36.59% Payroll 82.64% 105.74% 78.26% 84.16% 121.27% 59.31%

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

$

3,822,240 4,242,718 6,335,609 9,496,121 4,876,852 6,549,916 5,797,232 5,871,560 6,642,966 7,575,497

$

174,766 109,708 278,364 148,945 92,204 82,350 190,111 182,492 204,816

$

6,847,782 6,054,052 5,025,797 5,987,343 9,774,485 4,352,426 6,510,375 3,914,444 6,632,266 7,575,497

$ 10,446,101

9,708,017 9,013,258 8,977,932 8,222,977 7,893,394 7,502,811 6,246,667 7,014,843 6,194,557

-

106