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

City's

Plan

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

Fiduciary Net Position as a Percentage of the Total Pension

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

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

City's Proportionate Share of the Net Pension

City's Covered Payroll 7,893,394 $ 7,502,811

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

Liability

85.35% 107.07% 80.69% 86.75% 122.86% 91.35% Payroll

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

$

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

$

82,350 190,111 182,492 204,816 98,919

$

5,987,343 6,632,266 6,054,052 7,674,416 4,819,743 6,847,782

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.

104