2019 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

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

City's

Fiduciary Plan

State's

Proportionate Share of the Net Pension Liability as a Percentage of

Associated with the City Net Pension Share of the Proportionate Liability

Net Position

City's

City's

as a

Percentage of the Total

0.5126% Liability 0.4810% Pension of the Net Proportion 0.4810% 0.4680% 0.4720%

Net Pension Share of the Proportionate

City's

Payroll Covered

Payroll 100.94% Covered 389.07% 128.63% 139.88% 101.14%

Liability 89.30% Pension 63.88% 86.61% 85.40% 88.80%

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

Liability

with the City

$

6,494,072 5,126,965 18,781,654 5,457,145 5,363,024

$

- - - - -

$

18,781,654 6,494,072 5,363,024 5,126,965 5,457,145

5,406,198 $

4,827,360 4,642,761 4,169,456 5,069,010

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

103