2021 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

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

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

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

Fiduciary Net Position as a Percentage of the Total Pension

City's Proportionate Share of the Net Pension

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

City's Covered Payroll 8,222,977 $ 7,893,394

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

Liability

80.69% 85.35% 86.75% Payroll 61.12% 107.07% 121.27% 91.35%

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

$

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

$

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

$

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

7,502,811 7,014,843 6,194,557 6,246,667 5,275,939

- -

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

102