2022 Comprehensive Annual Financial Report for Sarasota Coun

Sarasota County, Florida Notes to Financial Statements September 30, 2022 Regarding the sensitivity of the total OPEB liability to changes in the healthcare cost trend rates, the following presents the Sheriff’s plan total OPEB liability, calculated using the assumed trend rates as well as what the plan’s total OPEB liability would be if it were calculated using a trend rate that is one percent lower or one percent higher: Aggregate OPEB expense and Deferred Outflows of Resources and Deferred Inflows of Resources related to OPEB For the year ended September 30, 2022, the County will recognize OPEB expense/ (credit) of $(65,923). The Sheriff Plan will recognize OPEB expense of $948,450. Table below shows OPEB expense and sources of deferred outflows and deferred inflows of resources related to each plan. Sarasota County’s amounts reported as deferred outflows of resources and deferred inflows of resources related to OPEB will be recognized in OPEB expense as follows: 1% Decrease Current Trend Rate 1% Increase 5.00% 6.00% 7.00% Total OPEB Liability/(Asset) $ 8,927,677 $ 10,066,831 $ 11,444,009 Healthcare Cost Trend Rate Sarasota County Sheriff Total Plans Deferred Outflows of Resources: Difference between expected and actual experience 1,122,801 $ $ 2,336,672 $ 3,459,473 Changes in actuarial assumptions 505,602 - 505,602 Net difference between projected and actual earnings on OPEB plan investments 1,101,827 - 1,101,827 Changes in assumptions and other inputs - 534,088 534,088 Total $ 2,730,230 $ 2,870,760 $ 5,600,990 Deferred Inflows of Resources: Difference between actual and expected experience 2,464,453 $ - $ $ 2,464,453 Changes in actuarial assumptions 895,710 - 895,710 Changes in assumptions and other inputs - 2,279,154 2,279,154 $ 3,360,163 $ 2,279,154 $ 5,639,317 For the Year Ending September 30, 2023 $ 224,384 2024 200,507 2025 183,602 2026 26,956 2027 (455,540) Thereafter (809,842) Total $ (629,933) 152

RkJQdWJsaXNoZXIy MzM3Mjg=