2022 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

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

Fiduciary Plan

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

City's

Share of the Net Pension Liability as a Proportionate Percentage of

State's

Share of the Proportionate Net Pension with the City Associated Liability

Net Position

City's

City's

as a

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

Share of the Net Pension Proportionate

Percentage of the Total

City's

Covered Payroll

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

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

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

Liability

with the City

$

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

$

164,053 947,883

$

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

$ 6,057,666

4,827,360 4,642,761 5,069,010 5,406,198 4,169,456 5,874,218 5,586,990

- - - - - -

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

103