SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF:JULY 2020
FINAL
BEGINNING BALANCE 7/1/20 3,149,170.39
DEPOSITS:
EMPLOYER CONTRIBUTIONS 421,377.00
CO-PAY EMPLOYEES 20,188.46
RETIREES 27,967.03
COBRA 918.02
INTEREST 479.47
TOTAL DEPOSITS 470,929.98
EXPENSES:
CLAIMS 350,835.78
ADMIN FEE 62,721.85
HSA EMPLOYER CONTRIBUTION 16,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 4,315.50
Actuarial Services & PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 435,688.58
ENDING BALANCE 3,184,411.79
AVERAGE MONTHLY CLAIMS
(Includes claims+admin fee)
(Based on a 13 month average)
AVERAGE MONTHLY RESERVE
9/18/2020 2:39 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF:JULY 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 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Sep-19 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Oct-19 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Nov-19 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Dec-19 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Jan-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Feb-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Mar-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Apr-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
May-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
Jun-20 0 0 0 0 0 0 0 0 0 0 0 0 3,184,412
TOTAL 421,377 49,553 470,930 350,836 62,722 0 0 4,316 16,000 1,815 435,689 35,241
MONTHLY AVERAGES:
DEPOSITS 470,930
EXPENSES 435,689
CONTRIBUTION TO
RESERVE 35,241
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
Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20
Series2 554,990 247,381 533,939 386,322 548,662 298,316 408,189 386,825 544,481 211,132 349,459 356,026 350,836
Series1 417,725 385,862 483,974 470,216 471,299 483,357 489,843 460,834 464,325 437,340 426,230 431,002 446,639
9/18/2020 2:39 PM