The National Conference of Insurance Guaranty Funds
10 West Market Street
Suite 1190
Indianapolis, IN 46204
(317) 464-8199

Search Our Site:

Instructions on use of Inception-to-Date Excel Data Sheets

New Format for Reporting
(This information is complete and accurate to the best of our knowledge as of November, 2003)

NCIGF has simplified and at the same time expanded its method of representing Financial History information (payments and recoveries for each insolvency). It does require some basic Excel skills which are represented below.

Each of these reports are drawn from the one of three separate base data sources and are presented in summary format - Assessments, Financial History and Capacity. Financial History is also represented on a by-year basis.

To see the desired report, left click on the link, and it will open in a new browser window. If you wish to have the data available for your own manipulation, right click on the link and select "Save target as" and save it to your hard drive.

To see the complete detail of any report, there are two steps:

  1. Click on the 3 box at the top of the left-hand column. To see the detail for single listed item, click on the + symbol to that item's left. (when you click the "+" symbol, it expands the section. Click the "-" symbol to the left of the section total to re-collapse the section).
  2. There are hidden columns between column A and G that contain more information. To display the hidden columns, click on the A in the column labels and roll to G holding your pointer down. This will highlight those two columns. Release your mouse. With your pointer in the highlighted area, right click and select "Unhide".
For additional assistance with these reports, contact the webmistress.


© 2004 NCIGF. All Rights Reserved.