SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF: SEPTEMBER 2021
FINAL
BEGINNING BALANCE 7/1/21 3,574,714.03
DEPOSITS:
EMPLOYER CONTRIBUTIONS 1,272,544.50
CO-PAY EMPLOYEES 144,780.14
RETIREES 79,048.35
COBRA 2,754.06
INTEREST 1,001.72
TOTAL DEPOSITS 1,500,128.77
EXPENSES:
CLAIMS 984,686.07
ADMIN FEE 210,331.47
HSA EMPLOYER CONTRIBUTION 125,000.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 13,227.00
Actuarial Services 0.00
PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 1,335,065.72
ENDING BALANCE 3,739,777.08
11/2/2021 2:21 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF: SEPTEMBER 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 424,182 36,960 461,142 228,672 141,109 0 0 4,522 0 0 374,303 86,839 3,559,390
Sep-20 424,182 130,075 554,257 191,643 69,223 0 0 4,255 108,750 0 373,870 180,387 3,739,777
Oct-20 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Nov-20 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Dec-20 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Jan-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Feb-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Mar-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Apr-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
May-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
Jun-21 0 0 0 0 0 0 0 0 0 0 0 0 3,739,777
TOTAL 1,272,545 227,584 1,500,129 984,686 210,331 0 0 13,227 125,000 1,821 1,335,066 165,063
MONTHLY AVERAGES:
DEPOSITS 500,043
EXPENSES 445,022
CONTRIBUTION TO
RESERVE 55,021
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
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
Series2 316,381 317,697 406,481 479,710 418,813 391,240 436,515 463,890 502,513 371,928 564,371 228,672 191,643
Series1 399,632 382,998 384,549 379,245 388,514 387,210 391,032 384,833 407,247 408,975 425,002 415,605 391,527
Series 1 - Rolling 13 month average
Series 2 - Monthly claims
11/2/2021 2:21 PM