2022 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

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

State's

Unit's

Plan

Share of the Net Pension Proportionate Associated with the Component Liability

Share of the Proportionate Net Pension Liability as a Percentage of

Net Position Fiduciary Percentage of the Total as a

Component

Component

Unit's

Unit's

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

Proportionate Share of the Net Pension

Component

Unit's

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

Covered Payroll

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

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

Liability

Unit

Unit

$

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

$

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

$

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

$ 5,009,118

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

-

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

104