Question 18 - Financial Experience July 2019 through March 2020.xlsx
XLSX spreadsheet 13 KB Posted
- Solicitation number
- 20-416CMS-BENF4-B-12595
- Issued by
- St. Clair County, Illinois
About this file
The document contains financial information related to a group life and accidental death & dismemberment (AD&D) insurance program provided by the Department of Central Management Services for its employees and annuitants in the state of Illinois. The document provides details on the premiums collected, claims paid, and other financial metrics for the basic and supplemental life insurance policies from July 1, 2019 through March 31, 2020.
The state is seeking a vendor to provide this group life and AD&D insurance program. The technical proposal is due as part of Bid Number B-14561, but pricing information should not be submitted with this technical proposal. The contract term and any renewal options are not specified in the provided information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Question 18 - Act vs. Ret.pdf | ||
| Forms B Section V.20.1~17.docx | DOCX document | |
| Addendum 1_3.doc | DOC document | |
| Group Life Insurance RFP Revisions 5-19-20.docx | DOCX document | |
| Attachment - Notice of Electronic Submission Only v.20.2.pdf | ||
| Vendor Instruction to submit Technical Proposals B-12595.docx | DOCX document | |
| CMS Benefits B12595 Notice of Award Form Life Insurance Services_1.pdf | ||
| Appendix 9 Census Data Life Summary Report Basic and Optional Age Count 1000 Units.xlsm | XLSM spreadsheet | |
| Appendices 1 thru 7.xlsx | XLSX spreadsheet | |
| Met. Life Protest.zip | ZIP file | |
| Question 18 - Optional Life Split.docx | DOCX document | |
| Appendix 8 Census Data.xlsx | XLSX spreadsheet | |
| CountyCodes.xlsx | XLSX spreadsheet | |
| Appendix 10 Certificate of Insurance.pdf | ||
| MetLife Protest CPO Determination.pdf | ||
| Utilization Plan Version 20.0.pdf | ||
| Group Life Insurance RFP.docx | DOCX document | |
| Forms A~24.doc | DOC document |
Show all 18
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Life Experience by Coverage |
| Policy Number: 32491-G |
| For the Period July 1, 2019 through March 31, 2020 |
| Basic | Supplemental | ||
| 1. | Premium | ||
| a. Paid | $20,291,382 | $32,469,610 | |
| b. Estimated | 5,896,256 | 9,437,920 | |
| c. Earned Premium (a+b) | $26,187,638 | $41,907,530 |
| 2. | Claims | ||
| a. Paid Claims, 7/1/2019 - 3/31/2020 | $21,988,858 | $34,239,506 | |
| b. Runout claims charged to FY 2019 | (3,638,621) | (5,379,183) | |
| c. Pending claims as of 03/31/2020 | 3,336,660 | 5,181,128 | |
| d. Pending claims charged to FY 2019 | (1,938,707) | (2,681,608) | |
| e. IBNR as of 03/31/2020 | 1,258,566 | 1,920,935 | |
| f IBNR charged to FY 2019 | (503,729) | (815,212) | |
| g. Incurred Claims (a+b+c+d+e+f | $20,503,027 | $32,465,566 |
| 3. | Expenses |
| a. Total Expenses | |
| b. % of Earned Premium |
| 4. | Conversion Charges | ||
| a. Volume of Conversions (units of 1000) | $598.1 | $97.6 | |
| b. Total Conversion Charges | $172,915 | $17,492 |
5. Balance (1c-2i-3a-4b)
6. Deficit Carry Forward from Prior Fiscal Year $0 $0
7. Interest Credits/(Charges)
8. Experience Credit/(Deficit) (5+6+7)
File details come from the government source that posted it. Updated .