| All fields with an asterisk (*) are required. To validate press Validate button or Ctrl + Shift + I. To finalize, press Finalize button or Ctrl + Shift + F. | ||||
| If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select "Enable All Content") Instructions can be found in cells B1 through B5. | If you are in a community rating state, select Family-Tier Rates under Rating Method and fill in all columns. | |||
| If you are not in a community rating state, select Age-Based Rates under Rating Method 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 + H. All plans must have the same dates on a sheet. | ||||
| HIOS Issuer ID* | ||||
| Federal TIN* | ||||
| Rate Effective Date* | ||||
| Rate Expiration Date* | ||||
| Rating Method* | ||||
| Plan ID* | Rating Area ID* | Tobacco* | Age* | Individual Rate* |
| Required: Enter the 14-character Plan ID |
Required: Select the Rating Area ID |
Required: Select if Tobacco use of subscriber is used to determine if a person is eligible for a rate from a plan |
Required: Select the age of a subscriber eligible for the rate |
Required: Enter the rate of an Individual Non-Tobacco or No Preference enrollee on a plan |
| File Type | application/vnd.ms-excel |
| File Title | Rates Table Template |
| Subject | Rates Table |
| Author | CMS |
| Last Modified By | O'Brien, Tayseer |
| File Modified | 2019-01-28 |
| File Created | 2012-02-01 |