2024 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

SCHEDULE OF COMPONENT UNIT'S PROPORTIONATE SHARE OF NET PENSION LIABILITY LAST 10 YEARS GENERAL EMPLOYEES RETIREMENT FUND

with the Component Liability Associated of the Net Pension Proportionate Share Component Unit's Share of the Net Pension Liability and the State's

State's

Unit's

Plan

Proportionate Share of the Net Pension

Proportionate Share of the Net Pension Liability as a Percentage of

Fiduciary

Component

Component

Net Position

Unit's

Unit's

as a

0.0639% 0.0678% 0.0634% 0.0645% 0.0644% 0.0621% 0.0608% 0.0716% 0.0668% Liability Pension 0.0677% of the Net Proportion

Net Pension Share of the Proportionate

Liability

Component

Percentage of the Total

the Component Associated with

Unit's

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

Covered Payroll

89.60% 130.82% 99.17% 82.57% 78.12% 59.46% 115.59% Covered Payroll 42.68% 73.08% 105.62%

68.91% 78.19% 75.90% 80.20% 79.50% 79.00% 87.00% Pension Liability 89.10% 83.10% 76.67%

Liability

Unit

Unit

$

3,532,888 4,064,920 2,707,464 3,578,196 5,042,212 3,150,972 4,111,253 4,003,792 2,502,508 5,290,582

$

82,761 155,198 125,364 65,842 51,656 117,344 64,710 110,260 109,829

$

2,790,225 5,445,780 4,190,284 2,567,218 4,114,052 3,642,717 3,150,972 5,108,054 4,162,909 3,695,540

$ 5,863,021

3,516,627 3,854,427 4,145,653 4,333,280 4,522,507 3,516,627 4,553,229 5,009,118 5,478,816

-

110