2023 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 Pension Liability and the State's Proportionate Share of the Net Pension Share of the Net Liability Associated with the City

Plan

City's

Fiduciary Net Position as a Percentage of the Total Pension

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

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

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

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, 2021 June 30, 2022 For the Fiscal Year Ended June 30, 2023

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

Liability

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

$

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

$

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

$

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

$ 9,013,258

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

- -

* Schedule is to be provided prospectively beginning with the City's fiscal year ended June 30, 2015, or after.

114