2023 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

SCHEDULE OF CITY CONTRIBUTIONS LAST 10 YEARS PUBLIC EMPLOYEES POLICE AND FIRE RETIREMENT FUND

the Statutorily in Relation to Contributions

Statutorily Required

Contribution Deficiency

Contributions as a percentage of Covered Payroll

For the Fiscal Year Ended

Required

City's Covered

Contribution

Contributions

(Excess)

Payroll

$

1,084,634 1,044,257 1,103,809

$

1,084,634 1,044,257 1,103,809

$

- - - - - - - - -

December 31, 2016 December 31, 2015 December 31, 2023 December 31, 2022 December 31, 2021 December 31, 2020 December 31, 2019 December 31, 2018 December 31, 2017

$

4,447,611 4,703,401 5,588,012 5,256,945 4,869,154 5,750,663 6,236,212 6,127,876 5,899,757

16.20% 16.20% 16.95% 16.20% 16.20% 16.95% 17.70% 17.70% 17.70%

720,513 761,951 851,625 788,803 947,168 974,737

720,513 761,951 851,625 788,803 947,168 974,737

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

118