Rates Table Template v2.3

66-0555677. Rate Effective Date*. 1/1/2017. Rate Expiration Date*. 12/31/2017. Plan ID*. Rating Area ID*. Tobacco*. Age*. Individual Rate*. Individual Tobacco ...
146KB Größe 4 Downloads 5 vistas
Rates Table Template v2.3

To validate press Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. If you are a community rating state, select Family Option under Age and fill in all columns. If you are not community rating state, select 0-20 under Age and provide an Individual Rate for every age band. If Tobacco is Tobacco User/Non-Tobacco User, you must give a rate for Tobacco Use and Non-Tobacco Use. To add a new sheet, press the Add Sheet button, or Ctrl + Shift + S. All plans must have the same dates on a sheet.

32901 66-0555677 1/1/2017 12/31/2017

HIOS Issuer ID* Federal TIN* Rate Effective Date* Rate Expiration Date*

Plan ID*

Rating Area ID*

Required: Enter the 14-character Plan ID

Required: Select the Rating Area ID

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

TS Directo Plata 1 (1/2017)

Rating Area 1

Tobacco*

Age*

Require: Required: Select if Tobacco use of subscriber is Select the age of a subscriber eligible used to determine if a person is eligible for the rate for a rate from a plan

Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User

0-20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 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 and Older

Individual Rate*

Individual Tobacco Rate*

Required: Enter the rate of an Individual NonTobacco or No Preference enrollee on a plan

Required: Enter the rate of an Individual tobacco enrollee on a plan

84.68

84.68

133.35

133.35

133.35

133.35

133.35

133.35

133.35

133.35

133.89

133.89

136.55

136.55

139.76

139.76

144.96

144.96

149.22

149.22

151.36

151.36

154.56

154.56

157.76

157.76

159.76

159.76

161.89

161.89

162.96

162.96

164.03

164.03

165.09

165.09

166.16

166.16

168.29

168.29

170.43

170.43

173.63

173.63

176.69

176.69

180.96

180.96

186.30

186.30

192.56

192.56

200.03

200.03

208.43

208.43

218.03

218.03

227.50

227.50

238.17

238.17

248.71

248.71

260.31

260.31

272.04

272.04

284.71

284.71

297.38

297.38

311.11

311.11

324.98

324.98

339.79

339.79

347.12

347.12

361.92

361.92

374.72

374.72

383.13

383.13

393.66

393.66

400.06

400.06

Rates Table Template v2.3

To validate press Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. If you are a community rating state, select Family Option under Age and fill in all columns. If you are not community rating state, select 0-20 under Age and provide an Individual Rate for every age band. If Tobacco is Tobacco User/Non-Tobacco User, you must give a rate for Tobacco Use and Non-Tobacco Use. To add a new sheet, press the Add Sheet button, or Ctrl + Shift + S. All plans must have the same dates on a sheet.

32901 66-0555677 1/1/2017 12/31/2017

HIOS Issuer ID* Federal TIN* Rate Effective Date* Rate Expiration Date*

Plan ID*

Rating Area ID*

Required: Enter the 14-character Plan ID

Required: Select the Rating Area ID

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

TS Directo Plata 2 (1/2017)

Rating Area 1

Tobacco*

Age*

Require: Required: Select if Tobacco use of subscriber is Select the age of a subscriber eligible used to determine if a person is eligible for the rate for a rate from a plan

Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User

0-20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 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 and Older

Individual Rate*

Individual Tobacco Rate*

Required: Enter the rate of an Individual NonTobacco or No Preference enrollee on a plan

Required: Enter the rate of an Individual tobacco enrollee on a plan

88.93

88.93

140.05

140.05

140.05

140.05

140.05

140.05

140.05

140.05

140.62

140.62

143.42

143.42

146.78

146.78

152.24

152.24

156.72

156.72

158.96

158.96

162.32

162.32

165.68

165.68

167.79

167.79

170.03

170.03

171.15

171.15

172.27

172.27

173.39

173.39

174.51

174.51

176.75

176.75

178.99

178.99

182.35

182.35

185.57

185.57

190.05

190.05

195.66

195.66

202.24

202.24

210.08

210.08

218.91

218.91

228.99

228.99

238.93

238.93

250.14

250.14

261.20

261.20

273.39

273.39

285.71

285.71

299.02

299.02

312.32

312.32

326.75

326.75

341.31

341.31

356.86

356.86

364.56

364.56

380.11

380.11

393.55

393.55

402.38

402.38

413.44

413.44

420.16

420.16