2019 City of Shakopee 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

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

Plan

State's

Unit's

the Component Associated with Proportionate Share of the Net Pension Liability

Net Pension Liability as a Percentage of Share of the Proportionate

Fiduciary

Component

Component

Net Position

as a

Unit's

Unit's

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

Net Pension Share of the Proportionate

Component

Percentage of the Total

Unit's

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

Covered Payroll

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

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

Liability

Unit

Unit

$

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

$

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

$

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

4,522,507 $

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

-

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

104