Connect for Health Premiums 20131219

Still loading...

	A	B	C	D	E	F
1	Connect for Health
2	Medium Projection
3
4	COHBE's estimated portion of CoverColorado reserve is 8.5 million
5	Annual operation budget of 26 million
6
7		Second half of 2013	2014	2015	2016	2017
8	Enrollment and Premium Assumptions
9	Average Estimated Sales Projections	0	75,001	124,283	174,203	223,557
10	Average Estimated Premium per member per month	0	$337	$354	$372	$392
11	Adminstrative Fee	0.00%	1.40%	1.40%	1.40%	2.50%
12
13	Revenue Assumptions
14	Exchange Revenue from Admin Fee	0	$4,246,204	$7,388,145	$10,873,497	$26,309,653
15	Estimated Portion of Federal Grant Funding (2013-2016)	$66,069,622	$60,984,119	$15,386,639	$0	$0
16
17	Revenue from CoverColorado/Unclaimed Property Fund	$15,000,000	$0	$0	$0	$0
18
19	Revenue from CoverColorado/Reserve Balance			$8,500,000
20	Revenue from General Market Health Insurance Assessment			$15,750,000	$15,750,000
21	Revenue from Premium Tax Credit Donations	$5,000,000	$5,000,000	$5,000,000	$5,000,000	$5,000,000
22	Potential Foundation Grants	$2,010,000	$2,000,000
23	Total Income	$88,079,622	$72,230,323	$52,024,784	$31,623,497	$31,309,653
24
25	Expected Operating/Technology Budget	$75,239,971	$26,000,000	$26,000,000	$26,000,000	$26,000,000
26	Remaining Implementation/Enhancement Costs		$37,057,020	$15,725,785
27	Additional Implementation Expense (Not Federally Funded)	$2,010,000	$2,000,000
28	Total Expenditures	$77,249,971	$65,057,020	$41,725,785	$26,000,000	$26,000,000
29
30	Net Income/Expense by Year	$10,829,651	$7,173,303	$10,298,999	$5,623,497	$5,309,653
31
32	Technology Obsolence Solution begins after Operational Reserve reaches 50% of annual budget	$0	$5,002,954	$15,301,953	$20,925,451	$26,235,103
33	Annual Technology Obsolence		$5,002,954	$10,298,999	$5,623,497	$5,309,653
34	Cumulative Operational Reserve at approximately 50% of annual budget	$10,829,651	$13,000,000	$13,000,000	$13,000,000	$13,000,000
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100