2023 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

Plan

State's

Unit's

the Component Associated with Proportionate Share of the Net Pension Liability

Proportionate Share of the Net Pension Liability as a Percentage of

Fiduciary Net Position Percentage of the Total as a

Component

Component

Unit's

Unit's

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

Net Pension Share of the Proportionate

Component

Unit's

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

Covered Payroll

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

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

Unit

Unit

Liability

$

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

$

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

$

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

$ 5,478,816

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

-

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

116