SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF:SEPTEMBER 2020
FINAL
BEGINNING BALANCE 7/1/20 3,149,170.39
DEPOSITS:
EMPLOYER CONTRIBUTIONS 1,264,131.00
CO-PAY EMPLOYEES 155,353.48
RETIREES 67,281.51
COBRA 918.02
INTEREST 1,491.05
TOTAL DEPOSITS 1,489,175.06
EXPENSES:
CLAIMS 1,171,865.95
ADMIN FEE 204,886.90
HSA EMPLOYER CONTRIBUTION 127,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 12,954.50
Actuarial Services & PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 1,518,522.80
ENDING BALANCE 3,119,822.65
AVERAGE MONTHLY CLAIMS
(Includes claims+admin fee)
(Based on a 13 month average)
AVERAGE MONTHLY RESERVE
10/23/2020 11:34 AM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF:SEPTEMBER 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 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-19 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Nov-19 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Dec-19 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Jan-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Feb-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Mar-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Apr-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
May-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
Jun-20 0 0 0 0 0 0 0 0 0 0 0 0 3,119,823
TOTAL 1,264,131 225,044 1,489,175 1,171,866 204,887 0 0 12,955 127,000 1,815 1,518,523 (29,348)
MONTHLY AVERAGES:
DEPOSITS 496,392
EXPENSES 506,174
CONTRIBUTION TO
RESERVE (9,783)
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
Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20
Series2 533,939 386,322 548,662 298,316 408,189 386,825 544,481 211,132 349,459 356,026 350,836 504,649 316,381
Series1 506,740 426,242 448,628 447,100 431,205 422,549 439,391 420,803 425,369 420,859 398,197 394,324 399,632
10/23/2020 11:34 AM