2018 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 as a Percentage of Covered Payroll

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

Plan Fiduciary Net Position as a Percentage of the Total

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

City's Proportionate Share of the Net Pension Liability

City's Proportion of the Net

City's Covered Payroll

Pension Liability

Pension Liability

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

0.1045% 5,797,232 $ 0.1026% 6,549,916 0.0933% 7,575,497 0.0930% 4,819,743

$

190,111 82,350 98,919

$

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

7,014,843 $

85.35% 107.07% 122.86% 91.35%

79.50% 75.90% 68.91% 78.19%

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