15 / 63
USE│
2017 Medical Financial History Comparison
2016
2017 YTD
2017 Linear
Projection
Linear Projection
vs. 2016
Enrollment
Average Monthly Employees
183
184
184
0.6%
Claims
Medical Claims Paid
910,489
$
272,744
$
1,090,974
$
19.8%
Rx Claims Paid
135,621
$
34,016
$
136,065
$
0.3%
Reimbursements and Rebates - All Plans
-
$
-
$
$0
#DIV/0!
Net Paid Claims
1,046,110
$
306,760
$
1,227,039
$
17.3%
Net Claims PEPY
5,709
$
1,664
$
6,657
$
16.6%
Fixed and Administrative Costs
Administrative Fees
152,976
$
39,135
$
156,540
$
2.3%
Admin Fees PEPY
835
$
214
$
854
$
2.3%
Stop Loss Premium
203,912
$
60,224
$
240,897
$
18.1%
Stop Loss Premium PEPY
1,113
$
329
$
1,315
$
18.1%
ACA Fees and Taxes
23,795
$
3,249
$
12,996
$
-45.4%
ACA Fees PEPY
130
$
18
$
71
$
-45.4%
Network Access Fees
75,705
$
19,250
$
77,000
$
1.7%
Network Access Fees PEPY
413
$
105
$
420
$
1.7%
Total Fixed Costs
456,388
$
121,858
$
487,432
$
6.8%
Total Fixed Cost PEPY
2,491
$
661
$
2,660
$
6.8%
HSA Funding
Employer Funding
99,750
$
33,900
$
135,600
$
35.9%
Funding PEPY
544
$
184
$
740
$
35.9%
Total Plan Cost
Claims
1,046,110
$
306,760
$
1,227,039
$
17.3%
Fixed
456,388
$
121,858
$
487,432
$
6.8%
HSA Funding
99,750
$
33,900
$
135,600
$
35.9%
Total Expenses
1,602,248
$
462,518
$
1,850,071
$
15.5%
Total Expenses PEPY
8,744
$
2,509
$
10,037
$
14.8%
Funding
Premium
2,233,100
$
500,955
$
2,003,818
$
-10.3%
Premium PEPY
12,186
$
2,718
$
10,935
$
-10.3%
Loss Ratio
72%
92%
92%
28.7%
15