2018 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 Proportionate

Plan Fiduciary Net Position as a Percentage of the Total

State's Proportionate

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

Component Unit's Proportion of the Net

Component Unit's Proportionate Share of the Net Pension Liability

Share of the Net Pension Liability Associated with the Component Unit

Share of the Net Pension Liability as a Percentage of Covered Payroll

4,333,280 $ Component Unit's Covered Payroll

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

Pension Liability

Pension Liability

0.0645% 3,578,196 $ 0.0644% 4,111,253 0.0621% 5,042,212 0.0608% 3,150,972

$

117,344 51,656 65,842

$

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

82.57% 79.50% 99.17% 75.90% 130.82% 68.91% 89.60% 78.19%

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