2021 Annual Comprehensive 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

Fiduciary Plan

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

City's

Proportionate Share of the Net Pension Liability as a Percentage of

State's

Associated with the City Net Pension Share of the Proportionate Liability

Net Position

City's

City's

as a

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

Net Pension Share of the Proportionate

Percentage of the Total

City's

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

Payroll Covered

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

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

Liability

with the City

$

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

$

164,053

$

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

5,874,218 5,586,990 $

- - - - - -

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

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

103