HCPS_COBRA_as_of_08.01.2025_updated.xlsx

This is a COBRA enrollment data file for the School Board of Hillsborough County Public Schools (HCPS) located in Tampa, Florida, as of August 1, 2025. The file provides enrollment information supporting HCPS's request for Stop Loss insurance quotes effective January 1, 2026. HCPS is transitioning from a fully insured plan through Aetna to a self-funded arrangement under Aetna beginning January 1, 2026. The organization has requested illustrative Individual Stop Loss (ISL)-only proposals initially using data through July 2025, with the intention to firm up quotes using data through August and September 2025 as additional information becomes available. HCPS anticipates posting addendums with updated enrollment data to support final quote development.

The COBRA enrollment data indicates 44 COBRA participants as part of HCPS's total eligible population of approximately 24,328 employees, with 78.5% currently enrolled in Medical/Rx coverage. Total current enrollment includes 18,601 active employees, 44 COBRA participants, and 476 pre-65 and post-65 retirees and surviving spouses, totaling 19,121 covered lives. The transition to self-funded status under Aetna represents a significant change in risk structure, with Stop Loss insurance serving as a critical protective mechanism against catastrophic claims. The file serves as supporting documentation for the stop loss procurement process, providing vendors with current enrollment snapshot data necessary for developing accurate and competitive insurance proposals.