2024 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2024

NOTE 15 – POSTEMPLOYMENT BENEFITS OTHER THAN PENSIONS (CONTINUED) D. Changes in the Total OPEB Liability

Total OPEB Liability

Balances at January 01, 2024 Changes for the Year:

$

1,846,603

Service cost

90,290

Interest Differences between expected and actual experience

75,723 1,105,067 217,187 (134,389) 1,353,878 3,200,481

Changes in assumptions or other inputs Benefit payments Net Changes

Balances at December 31, 2024

$

Since the prior measurement date, the following benefit terms changed: The discount rate was changed from 4.05% as of 12/31/2022 to 3.77% as of 12/31/2023 based on updated 20-year municipal bond rates as of each measurement date.

Since the prior measurement date, the following benefit terms changed:

The discount rate was changed from 4.05% to 3.77% based on updated measurement dates and GASB 75 requirements.

E. Sensitivity of the Total OPEB Liability

The following presents the total OPEB liability of the City, as well as what the City’s total OPEB liability would be if it were calculated using a discount rate that is 1-percentage point lower (2.77 percent) or 1 percentage-point higher (4.77 percent) than the current discount rate:

1% Decrease (2.77%)

Current (3.77%)

1% Increase (4.77%)

$

3,536,733

$

3,200,481

$

2,905,647

The following presents the total OPEB liability of the City, as well as what the City’s total OPEB liability would be if it were calculated using a Healthcare Cost Trend Rates that is 1-percentage point lower (5.90 percent decreasing to 2.90 percent) or 1-percentage-point higher (7.90 percent decreasing to 4.90 percent) than the current discount rate:

1% Decrease (5.9% Decreasing to 2.9%)

Healthcare Cost Trend Rates (6.9% Decreasing to 3.9%)

1% Increase (7.9% Decreasing to 4.9%)

$

2,825,200

$

3,200,481

$

3,644,632

99