SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF: JULY 2021
FINAL
BEGINNING BALANCE 7/1/21 3,574,714.03
DEPOSITS:
EMPLOYER CONTRIBUTIONS 424,181.50
CO-PAY EMPLOYEES 18,282.08
RETIREES 40,126.64
COBRA 1,836.04
INTEREST 304.24
TOTAL DEPOSITS 484,730.50
EXPENSES:
CLAIMS 564,371.38
ADMIN FEE 0.00
HSA EMPLOYER CONTRIBUTION 16,250.00
Federal Excise Tax 1,821.18
Wellness Program Fees 0.00
Wellness Program Incentives 0.00
Year End Settlement 0.00
State Assessment 0.00
PPI Benefits 4,450.50
Actuarial Services 0.00
PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 586,893.06
ENDING BALANCE 3,472,551.47
9/7/2021 1:56 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF: JULY 2021
REVENUES EXPENSES MONTHLY YTD
Wellness State PPI
EMPLOYER CO-PAYS TOTAL CLAIMS/FEES ADMIN HSA Other TOTAL BALANCE BALANCE
Program Assessment Benefit
BEG BALANCE 3,574,714
Jul-20 424,182 60,549 484,731 564,371 0 0 0 4,451 16,250 1,821 586,893 (102,163) 3,472,551
Aug-20 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Sep-20 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Oct-20 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Nov-20 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Dec-20 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Jan-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Feb-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Mar-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Apr-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
May-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
Jun-21 0 0 0 0 0 0 0 0 0 0 0 0 3,472,551
TOTAL 424,182 60,549 484,731 564,371 0 0 0 4,451 16,250 1,821 586,893 (102,163)
MONTHLY AVERAGES:
DEPOSITS 484,731
EXPENSES 586,893
CONTRIBUTION TO
RESERVE (102,163)
COLCHESTER BOARD OF EDUCATION
13 MONTH MEDICAL CLAIMS TREND HISTORY
(PAID CLAIMS AND NETWORK ACCESS FEE)
Excludes Administrative Costs
600,000
500,000
400,000
300,000
AMOUNT
200,000
100,000
0
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21
Series2 350,836 504,649 316,381 317,697 406,481 479,710 418,813 391,240 436,515 463,890 502,513 371,928 564,371
Series1 398,197 394,324 399,632 382,998 384,549 379,245 388,514 387,210 391,032 384,833 407,247 408,975 425,002
Series 1 - Rolling 13 month average
Series 2 - Monthly claims
9/7/2021 1:56 PM