SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF: JUNE 2021
FINAL
BEGINNING BALANCE 7/1/20 3,149,170.39
DEPOSITS:
EMPLOYER CONTRIBUTIONS 5,137,042.25
CO-PAY EMPLOYEES 1,217,422.33
RETIREES 256,023.00
COBRA 8,920.24
INTEREST 5,934.70
TOTAL DEPOSITS 6,625,342.52
EXPENSES:
CLAIMS 4,960,653.08
ADMIN FEE 786,382.35
HSA EMPLOYER CONTRIBUTION 397,475.00
Federal Excise Tax 1,815.45
Wellness Program Fees 0.00
Wellness Program Incentives 0.00
Year End Settlement 0.00
State Assessment 0.00
PPI Benefits 52,223.00
Actuarial Services 8,250.00
PY Adj & Audit Fees (7,000.00)
Other 0.00
TOTAL EXPENSES 6,199,798.88
ENDING BALANCE 3,574,714.03
9/7/2021 1:55 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF: JUNE 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,149,170
Jul-20 421,377 49,553 470,930 350,836 62,722 0 0 4,316 16,000 1,815 435,689 35,241 3,184,412
Aug-20 421,377 37,040 458,417 504,649 67,296 0 0 4,411 9,000 0 585,356 (126,939) 3,057,473
Sep-20 421,377 138,451 559,828 316,381 74,869 0 0 4,229 102,000 0 497,478 62,350 3,119,823
Oct-20 437,480 150,984 588,464 317,697 63,606 0 0 4,469 0 0 385,771 202,693 3,322,515
Nov-20 429,428 141,985 571,414 406,481 66,108 0 0 4,489 1,500 (7,000) 471,577 99,836 3,422,352
Dec-20 429,428 137,320 566,748 479,710 65,136 0 0 4,396 83,250 0 632,492 (65,744) 3,356,608
Jan-21 429,428 146,992 576,420 418,813 0 0 0 4,201 9,475 0 432,489 143,932 3,500,540
Feb-21 429,428 133,892 563,320 391,240 127,521 0 0 4,329 0 0 523,089 40,231 3,540,771
Mar-21 429,429 138,785 568,214 436,515 63,077 0 0 4,302 86,500 8,250 598,644 (30,430) 3,510,341
Apr-21 429,429 144,399 573,828 463,890 64,552 0 0 4,301 1,500 0 534,243 39,585 3,549,926
May-21 429,429 133,994 563,423 502,513 67,331 0 0 4,411 0 0 574,255 (10,832) 3,539,094
Jun-21 429,429 134,906 564,335 371,928 64,164 0 0 4,373 88,250 0 528,715 35,620 3,574,714
TOTAL 5,137,042 1,488,300 6,625,343 4,960,653 786,382 0 0 52,223 397,475 3,065 6,199,799 425,544
MONTHLY AVERAGES:
DEPOSITS 552,112
EXPENSES 516,650
CONTRIBUTION TO
RESERVE 35,462
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
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21
Series2 356,026 350,836 504,649 316,381 317,697 406,481 479,710 418,813 391,240 436,515 463,890 502,513 371,928
Series1 420,859 398,197 394,324 399,632 382,998 384,549 379,245 388,514 387,210 391,032 384,833 407,247 408,975
Series 1 - Rolling 13 month average
Series 2 - Monthly claims
9/7/2021 1:55 PM