2018 City of Shakopee Comprehensive Annual Financial Report

CITY OF SHAKOPEE SCHEDULE OF CITY'S PROPORTIONATE SHARE OF NET PENSION LIABILITY LAST 10 YEARS PUBLIC EMPLOYEES POLICE AND FIRE RETIREMENT FUND

City's Proportion of the Net

City's Proportionate Share of the Net Pension Liability

City's Proportionate Share of the Net Pension Liability as a Percentage of Covered Payroll

Plan Fiduciary Net Position as a Percentage of the Total Pension Liability

City's Covered Payroll

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

Pension Liability

0.4810% 5,126,965 $ 0.4810% 6,494,072 0.4680% 18,781,654 0.4720% 5,363,024

5,069,010 $

101.14% 139.88% 389.07% 128.63%

88.80% 85.40% 63.88% 86.61%

4,642,761 4,827,360 4,169,456

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

103