july_2024_health_insurance_reserve_report — Colchester Document Library

Machine-extracted text of a publicly posted document, provided for reference and search. The original document at the link above is authoritative.

Board of Education and Town
                            Monthly Health Insurance Reserve Report
                                    Cash Flow Analysis - July 2024
                                             BOE              Town            Balance

Balance 06/30/24                          2,609,468.02       (201,876.11)    2,407,591.91

Employer Contribution*

Employee Contributions**                     32,260.34        21,600.89
Interest                                      6,675.58             0.00

Employer HSA contributions                  (25,687.50)       (26,525.00)
Third Party Admininstrator Fees              (4,290.50)          (917.00)

Administrative Costs                        (26,625.15)       (10,128.88)
Claims (thru 7/31/24)                      (391,869.19)       (60,854.40)

Balance 7/31/24                           2,199,931.60       (278,700.50)    1,921,231.10

* The employer portion is determined at the start of year and divided by 12 so each month
the contribution will be the same.
** Employees portion of the health insurance premium collected for the month