2023 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

LAST 10 YEARS PUBLIC EMPLOYEES POLICE AND FIRE RETIREMENT FUND Plan SCHEDULE OF CITY'S PROPORTIONATE SHARE OF NET PENSION LIABILITY Proportionate Share of the Net Position City's Proportionate City's State's Share of the Net Proportionate Fiduciary Pension Liability and

City's

City's

Net Pension Share of the Associated Liability with the City

the State's

Liability as a Percentage of Net Pension

as a

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

Proportionate Share of the Net Pension

Proportionate Share of the Net Pension Liability Associated

Percentage of the Total

City's

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

Covered Payroll

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

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

Liability

with the City

$

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

$

330,319 947,883 164,053

$

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

$ 6,235,796 6,057,666

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

- - - - - -

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

115