New Hampshire Rate Models

You must be a licensed producer with CIGNA HealthCare of New Hampshire in order to access our small group rate model. If you have not received a password, please contact us at 800.456.6575 or email us at nesmallgroup@cigna.com.

Use the links below to access the CIGNA HealthCare Small Group Rate Model for New Hampshire. You will be prompted to save the excel file to your hard drive. If you receive a prompt about Macros, please choose "Enable Macros."

CIGNA New Hampshire Small Group Rating Model-Version 10.02 effective 4/1/2010 to 6/30/2010 for NEW groups only (XLS)

CIGNA New Hampshire Small Group Rating Model-Version 10.01 effective 1/1/2010 to 3/31/2010 for NEW groups only (XLS)

CIGNA New Hampshire Small Group Rating Model-Version 9.11 effective 10/1/2009 to 12/31/2009 for NEW groups only (XLS)

CIGNA New Hampshire Small Group Rating Model-Version 9.06 effective 07/01/2009 to 09/30/2009 for NEW groups only (XLS)

CIGNA New Hampshire Small Group Rating Model-Version 9.05 effective 06/01/2009 to 06/30/2009 for NEW groups only (XLS)

CIGNA New Hampshire Small Group Rating Model-Version 9.03 effective 04/01/2009 to 05/31/2009 for NEW groups only (XLS)

2-50- 1Q09 New Hampshire External Rating Model (XLS)

Opening the files
Please be patient as these files may take a little longer to download than they do to open. Please right-click on the links above and choose "Save Target As" (Microsoft Internet Explorer) or "Save Link As" (Netscape Navigator) to save the rate model to your hard drive.

Your security setting in excel must be set to "Medium" or "Low". If they are set to "High" the macros will not work, which means that none of the features that allow rates to be run will be active.

Security Settings in Excel
To set your security in Excel to "medium".

Close the rate model, if already open. Do not save. Open a blank Excel spreadsheet by opening Excel from your Start menu, and selecting "File" then "New". Go to the "Tools" menu and choose "Options".

Depending on the version of Excel you have, the security settings may be in different areas.

In Excel ‘97, you’ll go to the "General" tab and uncheck "Macro Virus Protection".
In later versions, there should be a "Security" tab.
On the security tab, look for either a choice between "Low", "Medium" and "High" security, or a button that mentions security or macro settings. If it is a button, click on it and choose "Medium".
Once you’ve changed that setting, click "OK" or until the window goes away.
Close Excel then reopen it to activate the change.

Once the settings have been changed, you can open up the rate model and you will be asked if you want to "Enable" macros. Click "Yes".

If you have any questions, feel free to call us at 800.456.6575 or email us at nesmallgroup@cigna.