2022 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

Plan

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

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

Fiduciary Net Position as a Percentage of the Total Pension

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

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

City's Proportionate Share of the Net Pension

City's Covered Payroll

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

Liability

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

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

$

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

$

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

$ 8,977,932

$

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

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

- -

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

102