2020 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.4977% Liability 0.5126% Pension of the Net Proportion 0.4810% 0.4810% 0.4720% 0.4680%

Net Pension Share of the Proportionate

City's

Payroll Covered

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

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

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

Liability

with the City

$

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

$

- - - - - -

$

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

5,874,218 $

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

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

105