Drive file 17dx-etiRN0csrbJlh8cPfJjCoPJ5wuOB — 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 - June 2026
                                             BOE              Town            Balance

Balance 5/31/26                             843,920.47       279,775.46      1,123,695.93

Employer Contribution*
Sewer & Water
Café

Employee Contributions**                    201,006.02        24,362.76
Interest                                        859.22           462.65

Employer HSA contributions                 (108,343.75)
Third Party Admininstrator Fees

Aegle Capital Stop Loss
HM Billing Stop Loss                        (69,085.50)       (17,082.96)      (86,168.46)
Aegle Stop Loss Reimb                        65,246.71

Administrative Costs                         (6,763.28)        (1,743.19)
Rx                                           65,867.50         14,921.76
Claims (thru 6/30/26)                      (594,927.38)       (87,087.67)

Balance 6/30/26***                          397,780.00       213,608.82        611,388.82

* 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