2020 Comprehensive Annual 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 Component Unit's Pension Liability and

State's

Unit's

Plan

Share of the Net Pension Proportionate

Share of the Proportionate Net Pension Liability as a Percentage of

Fiduciary

Component

Component

Net Position

Unit's

Unit's

as a

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

Proportionate Share of the Net Pension

Liability

Component

Percentage of the Total

Associated with the Component

Unit's

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

Covered Payroll

119.16% 80.55% 85.28% 100.42% 132.52% 89.60% Covered Payroll

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

Liability

Unit

Unit

$

4,111,253 3,578,196 5,042,212 4,064,920 3,532,888 3,150,972

$

51,656 65,842 117,344 125,364 109,829

$

4,162,909 5,108,054 3,150,972 3,695,540 4,190,284 3,642,717

3,516,627 $

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

-

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

106