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 |
|---|---|---|
| Addendum 1_3.doc | DOC document | |
| Appendix 8 Census Data.xlsx | XLSX spreadsheet | |
| Appendix 9 Census Data Life Summary Report Basic and Optional Age Count 1000 Units.xlsm | XLSM spreadsheet | |
| Attachment - Notice of Electronic Submission Only v.20.2.pdf | ||
| CMS Benefits B12595 Notice of Award Form Life Insurance Services_1.pdf | ||
| Met. Life Protest.zip | ZIP file | |
| Appendices 1 thru 7.xlsx | XLSX spreadsheet | |
| Vendor Instruction to submit Technical Proposals B-12595.docx | DOCX document | |
| Appendix 10 Certificate of Insurance.pdf | ||
| Forms A~24.doc | DOC document | |
| Group Life Insurance RFP.docx | DOCX document | |
| MetLife Protest CPO Determination.pdf | ||
| Utilization Plan Version 20.0.pdf | ||
| Question 18 - Act vs. Ret.pdf | ||
| CountyCodes.xlsx | XLSX spreadsheet | |
| Forms B Section V.20.1~17.docx | DOCX document | |
| Group Life Insurance RFP Revisions 5-19-20.docx | DOCX document | |
| Question 18 - Optional Life Split.docx | DOCX 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 .