SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF:AUGUST 2020
FINAL
BEGINNING BALANCE 7/1/20 3,149,170.39
DEPOSITS:
EMPLOYER CONTRIBUTIONS 842,754.00
CO-PAY EMPLOYEES 40,453.36
RETIREES 44,204.66
COBRA 918.02
INTEREST 1,017.12
TOTAL DEPOSITS 929,347.16
EXPENSES:
CLAIMS 855,485.12
ADMIN FEE 130,018.31
HSA EMPLOYER CONTRIBUTION 25,000.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 8,726.00
Actuarial Services & PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 1,021,044.88
ENDING BALANCE 3,057,472.67
AVERAGE MONTHLY CLAIMS
(Includes claims+admin fee)
(Based on a 13 month average)
AVERAGE MONTHLY RESERVE
9/18/2020 2:40 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF:AUGUST 2020
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-19 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-19 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-19 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Oct-19 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Nov-19 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Dec-19 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Jan-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Feb-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Mar-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Apr-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
May-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
Jun-20 0 0 0 0 0 0 0 0 0 0 0 0 3,057,473
TOTAL 842,754 86,593 929,347 855,485 130,018 0 0 8,726 25,000 1,815 1,021,045 (91,698)
MONTHLY AVERAGES:
DEPOSITS 464,674
EXPENSES 510,522
CONTRIBUTION TO
RESERVE (45,849)
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
AMOUNT
300,000
200,000
100,000
0
Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20
Series2 247,381 533,939 386,322 548,662 298,316 408,189 386,825 544,481 211,132 349,459 356,026 350,836 504,649
Series1 385,862 483,974 470,216 471,299 483,357 489,843 460,834 464,325 437,340 426,230 431,002 446,639 465,668
9/18/2020 2:40 PM