2019 City of Shakopee 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.0933% 0.1026% 0.0930% of the Net Pension Liability 0.1062% 0.1045% City's Proportion

City's Proportionate Share of the Net Pension

City's Covered Payroll 7,502,811 $ 7,014,843

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

Liability

107.07% 122.86% 85.35% 80.69% 91.35% Payroll

Liability 80.20% 79.50% 75.90% 68.91% 78.19%

$

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

$

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

$

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

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