Delaware County, Indiana
Schedule of the Changes in the County's Net Pension Liability and Related Ratios -
Sheriff's Retirement Plan
Last 10 Fiscal Years
| 2025 | 2024 | 2023 | 2022 | 2021 | 2020 | 2019 | 2018 | 2017 | 2016 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Pension Liability | ||||||||||
| Service cost | $ 642,855 | $ 585,041 | $ 599,322 | $ 460,826 | $ 474,248 | $ 452,429 | $ 499,047 | $ 767,330 | $ 607,840 | $ 465,107 |
| Interest | 1,972,270 | 1,881,267 | 1,812,598 | 1,730,231 | 1,691,696 | 1,682,533 | 1,651,312 | 1,476,188 | 1,451,120 | 1,471,123 |
| Changes in plan provisions | - | - | - | - | - | - | (225,637) | - | - | - |
| Difference between expected and actual experience | (189,260) | 385,849 | 102,410 | 336,892 | (108,051) | (672,698) | (690,926) | 62,473 | (593,553) | (457,368) |
| Changes in assumptions | 248,951 | - | - | - | 814,620 | (128,253) | 436,135 | (6,737,566) | 4,100,544 | 2,638,686 |
| Benefit payments | (1,542,609) | (1,471,280) | (1,410,890) | (1,385,509) | (1,204,009) | (1,239,069) | (1,068,256) | (837,595) | (834,200) | (798,466) |
| Net change in total pension liability | 1,132,207 | 1,380,877 | 1,103,440 | 1,142,440 | 1,668,504 | 94,942 | 601,675 | (5,269,170) | 4,731,751 | 3,319,082 |
| Total Pension Liability, Beginning | 30,535,351 | 29,154,474 | 28,051,034 | 26,908,594 | 25,240,090 | 25,145,148 | 24,543,473 | 29,812,643 | 25,080,892 | 21,761,810 |
| Total Pension Liability, Ending (1) | $ 31,667,558 | $ 30,535,351 | $ 29,154,474 | $ 28,051,034 | $ 26,908,594 | $ 25,240,090 | $ 25,145,148 | $ 24,543,473 | $ 29,812,643 | $ 25,080,892 |
| Plan Fiduciary Net Position | ||||||||||
| County contributions | $ 1,504,573 | $ 1,475,127 | $ 1,628,960 | $ 1,263,220 | $ 1,230,226 | $ 1,251,515 | $ 1,224,465 | $ 1,276,579 | $ 969,112 | $ 1,181,537 |
| Employee contributions | 96,511 | 86,374 | 84,691 | 116,926 | 58,849 | 75,107 | 61,177 | 67,441 | 64,740 | 64,702 |
| Net transfers into (out of) trust | - | - | - | - | - | - | - | - | - | (78,463) |
| Net investment income | 2,524,559 | 2,078,418 | 2,411,957 | (3,644,034) | 2,615,002 | 2,310,302 | 2,773,772 | (1,250,761) | 1,577,468 | (538,918) |
| Benefit payments | (1,542,609) | (1,471,280) | (1,410,890) | (1,385,509) | (1,204,009) | (1,239,069) | (1,068,256) | (837,595) | (834,200) | (798,466) |
| Administrative expenses | (33,902) | (16,671) | (33,969) | (34,291) | (33,573) | (28,086) | (26,463) | (22,837) | (22,367) | (19,735) |
| Other | - | - | - | - | - | - | - | - | - | 78,463 |
| Net change in plan fiduciary net position (2) | 2,549,132 | 2,151,968 | 2,680,749 | (3,683,688) | 2,666,495 | 2,369,769 | 2,964,695 | (767,173) | 1,754,753 | (110,880) |
| Plan Fiduciary Net Position, Beginning | 23,081,199 | 20,929,231 | 18,248,482 | 21,932,170 | 19,265,675 | 16,895,906 | 13,931,211 | 14,698,384 | 12,943,631 | 13,054,511 |
| Plan Fiduciary Net Position, Ending | $ 25,630,331 | $ 23,081,199 | $ 20,929,231 | $ 18,248,482 | $ 21,932,170 | $ 19,265,675 | $ 16,895,906 | $ 13,931,211 | $ 14,698,384 | $ 12,943,631 |
| Net Pension Liability (Asset), Ending (1) - (2) | $ 6,037,227 | $ 7,454,152 | $ 8,225,243 | $ 9,802,552 | $ 4,976,424 | $ 5,974,415 | $ 8,249,242 | $ 10,612,262 | $ 15,114,259 | $ 12,137,261 |
| Plan Fiduciary Net Position as a Percentage of the Total Pension Liability |
80.94% | 75.59% | 71.79% | 65.05% | 81.51% | 76.33% | 67.19% | 56.76% | 49.30% | 51.61% |
| Covered Payroll | $ 2,945,261 | $ 2,887,161 | $ 2,558,168 | $ 2,626,684 | $ 1,994,927 | $ 2,100,928 | $ 2,063,384 | $ 2,155,223 | $ 2,032,474 | $ 2,075,934 |
| County's Net Pension Liability as a Percentage of Covered Payroll | 204.98% | 258.18% | 321.53% | 373.19% | 249.45% | 284.37% | 399.79% | 492.40% | 743.64% | 584.67% |
64