2024 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.1148% Liability 0.1133% 0.1142% 0.1199% 0.1108% Pension 0.1062% 0.1045% 0.1026% 0.0930% 0.0933%

City's Proportionate Share of the Net Pension

City's Covered Payroll

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

Liability

Payroll

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

$

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

$

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

$

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

$ 9,708,017

105.77% 59.31% 70.29% 43.70% 84.16% 78.26% 82.64% 105.74% 121.27% 91.35%

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

82,350

- -

108