RFP_21-057-DP_Attachment 5.xls
XLS spreadsheet 151 KB Posted
- Attached to
- Long Term and Short Term Disability Insurance
- Solicitation number
- RFP 680 21-057/DP 2
- Issued by
- Palm Beach County, Florida
About this file
This file is an experience presentation attachment submitted by Cigna to Palm Beach County Board of Commissioners in response to RFP 21-057-DP, documenting claims experience and historical performance data for disability insurance products. The submission includes detailed Long Term Disability (LTD), Short Term Disability (STD), and Family and Medical Leave Act (FMLA) claims exhibits covering the period from January 1, 2018, through April 24, 2021. The LTD experience data spans three fully revealed years (2018-2020) with 59 total claims reported on an incurred basis, while the STD experience data covers the same three-year period with 143 total claims reported on a paid basis. Individual LTD claim details are provided for all open and closed claims, including claimant age, gender, date of disability, coverage status, and monthly benefit amounts.
The LTD experience demonstrates a net incurred claims total of $1,630,561 against paid premiums of $1,684,763 over the three-year period, resulting in a paid loss ratio of 96.8 percent. The STD experience shows paid claims of $550,721 against paid premiums of $1,217,503, resulting in a paid loss ratio of 45.2 percent. All exhibits are marked as confidential property of Cigna Corporation with restricted distribution. The data provides Palm Beach County with comprehensive historical claims performance metrics to evaluate Cigna's proposed offerings and experience with similar disability insurance coverage for public sector employees.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP_21-057-DP.pdf | ||
| RFP_21-057-DP_1_7-20-21.pdf | ||
| RFP_21-057-DP_Appendix A - Part 1.docx | DOCX document | |
| RFP_21-057-DP_Attachment 4.pdf | ||
| RFP No. 21-057-DP_Appendix B1 LTD Price Proposal Pages.docx | DOCX document | |
| RFP No. 21-057-DP_Appendix B2_STD Price Proposal Pages.docx | DOCX document | |
| RFP_21-057-DP_Appendix A - Part 2.xls | XLS spreadsheet | |
| RFP_21-057-DP_1_Attachment-6.xlsx | XLSX spreadsheet | |
| RFP_21-057-DP_Attachment 3.pdf | ||
| RFP_21-057-DP_1_Attachment-7.xlsx | XLSX spreadsheet |
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
Cover Sheet
Together, all the way
EXPERIENCE PRESENTATION FOR:
"Cigna" is a registered service mark and the "Tree of Life" logo and “Together, all the way” are service marks of Cigna Intellectual Property, Inc., licensed for use by Cigna Corporation and its operating subsidiaries. All products and services are provided by such operating subsidiaries and not by Cigna Corporation. Such operating subsidiaries include Connecticut General Life Insurance Company, Cigna Health and Life Insurance Company, and HMO or service company subsidiaries of Cigna Health Corporation and Cigna Dental Health, Inc.
© 2021 Cigna. Some content provided under license.
Palm Beach County Board of Commissioners
STD ASO_Claims
STD ASO
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation)&C&8&P of &N &10
STD ATP_Claims
STD ATP
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation)&C&8&P of &N &10
FMLA_Claims
FMLA Claims
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation)&C&8&P of &N &10
LTD Experience Exhibit
| Palm Beach County Board of Commissioners | |||||
| Long Term Disability | |||||
| FLK0960504 | |||||
| As Of 4/24/2021 | |||||
| Claims Reported on an Incurred Basis | |||||
| Period Description | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed |
| Start Date | 1/1/2018 | 1/1/2019 | 1/1/2020 | Total | |
| End Date | 12/31/2018 | 12/31/2019 | 12/31/2020 | ||
| # of Months | 12 | 12 | 12 | 36 | |
| Paid Premium | 559,684 | 554,196 | 570,882 | 1,684,763 | |
| Paid Claims | 396,346 | 221,789 | 86,345 | 704,480 | |
| Reserves | 252,057 | 175,430 | 430,287 | 857,774 | |
| IBNR | 663 | 4,315 | 63,329 | 68,307 | |
| Net Incurred Claims | 649,066 | 401,534 | 579,961 | 1,630,561 | |
| Paid Loss Ratio | 116.0 % | 72.5 % | 101.6 % | 96.8 % | |
| Open/Pending Claims | 7 | 6 | 9 | 22 | |
| Closed Claims | 13 | 19 | 5 | 37 | |
| Total Claims | 20 | 25 | 14 | 59 |
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation&C&8&P of &N &10 &R&I&7Created: 2:39 PM - 5/21/2021
LTD Claims Exhibit
| Palm Beach County Board of Commissioners | ||||
| Long Term Disability | ||||
| FLK0960504 | ||||
| As Of 4/24/2021 | ||||
| All Claims | ||||
| Age | Gender | Date of Disability | Coverage Status | Benefit |
| 47 | M | 2/3/21 | PI | 1,000 |
| 57 | F | 1/21/21 | PI | 2,697 |
| 66 | M | 1/10/21 | PI | 1,639 |
| 39 | F | 1/1/21 | CC | 1,000 |
| 54 | M | 11/25/20 | AC | 1,000 |
| 50 | M | 11/24/20 | AC | 1,000 |
| 57 | M | 11/22/20 | AC | 1,000 |
| 56 | F | 11/6/20 | AC | 1,599 |
| 45 | M | 10/10/20 | AC | 1,000 |
| 56 | F | 9/1/20 | PI | 1,000 |
| 36 | M | 7/22/20 | AC | 3,231 |
| 58 | F | 6/23/20 | AC | 5,000 |
| 43 | F | 6/13/20 | CC | 1,000 |
| 66 | M | 5/29/20 | AC | 4,881 |
| 27 | F | 4/7/20 | CC | 1,000 |
| 57 | M | 1/31/20 | CC | 3,106 |
| 61 | F | 1/21/20 | CC | 1,000 |
| 58 | F | 1/4/20 | CC | 1,000 |
| 61 | M | 12/27/19 | AC | 1,824 |
| 59 | F | 12/6/19 | CC | 1,000 |
| 51 | F | 12/5/19 | AC | 2,224 |
| 58 | M | 12/2/19 | AC | 2,512 |
| 59 | M | 11/19/19 | AC | 1,000 |
| 65 | M | 11/12/19 | CC | 5,000 |
| 31 | F | 11/7/19 | CC | 1,000 |
| 56 | M | 10/31/19 | CC | 4,245 |
| 25 | M | 10/24/19 | CC | 1,000 |
| 64 | M | 10/7/19 | CC | 1,912 |
| 62 | M | 10/4/19 | CC | 1,697 |
| 29 | M | 8/30/19 | CC | 1,000 |
| 58 | M | 8/15/19 | CC | 1,000 |
| 69 | F | 7/3/19 | CC | 2,605 |
| 57 | M | 6/18/19 | CC | 1,000 |
| 59 | F | 5/30/19 | CC | 1,875 |
| 61 | M | 5/27/19 | CC | 2,094 |
| 64 | F | 4/9/19 | AC | 4,287 |
| 46 | M | 4/5/19 | CC | 3,106 |
| 41 | F | 4/4/19 | CC | 2,149 |
| 56 | M | 4/1/19 | AC | 1,000 |
| 58 | F | 3/15/19 | CC | 2,605 |
| Age | Gender | Date of Disability | Coverage Status | Benefit |
| 57 | F | 2/1/19 | CC | 1,000 |
| 52 | F | 1/11/19 | CC | 1,000 |
| 59 | F | 1/3/19 | CC | 2,605 |
| 59 | M | 12/6/18 | AC | 1,000 |
| 62 | M | 12/6/18 | AC | 1,632 |
| 46 | F | 11/5/18 | CC | 1,000 |
| 55 | M | 10/16/18 | CC | 2,740 |
| 62 | F | 7/12/18 | CC | 4,808 |
| 57 | M | 6/23/18 | AC | 1,000 |
| 62 | M | 5/31/18 | CC | 2,640 |
| 55 | M | 5/30/18 | AC | 2,766 |
| 53 | M | 5/15/18 | CC | 2,579 |
| 57 | M | 5/10/18 | AC | 1,000 |
| 60 | M | 4/28/18 | CC | 205 |
| 60 | M | 4/24/18 | CC | 2,050 |
| 64 | M | 4/21/18 | AC | 1,977 |
| 53 | M | 4/20/18 | AC | 2,579 |
| 50 | M | 4/9/18 | CC | 1,000 |
| 60 | M | 4/6/18 | CC | 1,914 |
| 55 | M | 3/30/18 | CC | 4,386 |
| 40 | F | 3/15/18 | CC | 1,000 |
| 61 | F | 2/6/18 | CC | 2,579 |
| 56 | M | 1/24/18 | CC | 1,000 |
| 63 | M | 1/20/18 | CC | 2,463 |
| Coverage Status Key | ||||
| AC, AZ, PR Active | ||||
| PI, PK, PM, PT Pending | ||||
| CC, CS Closed | ||||
| PS Claim in Suit |
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation&C&8&P of &N &10 &R&I&7Created: 2:39 PM - 5/21/2021
STD Experience Exhibit
| Palm Beach County Board of Commissioners | |||||
| Short Term Disability | |||||
| VDT0960736 | |||||
| As Of 5/21/2021 | |||||
| Claims Reported on a Paid Basis | |||||
| Period Description | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed |
| Start Date | 1/1/2018 | 1/1/2019 | 1/1/2020 | Total | |
| End Date | 12/31/2018 | 12/31/2019 | 12/31/2020 | ||
| # of Months | 12 | 12 | 12 | 36 | |
| Paid Premium | 350,375 | 376,180 | 490,948 | 1,217,503 | |
| Paid Claims | 164,102 | 155,630 | 230,989 | 550,721 | |
| Paid Loss Ratio | 46.8 % | 41.4 % | 47.0 % | 45.2 % | |
| Total Claims | 46 | 37 | 60 | 143 |
&R&G &L&"Arial,Italic"&7Confidential, unpublished property of Cigna. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. © Copyright 2021 Cigna Corporation&C&8&P of &N &10 &R&I&7Created: 2:40 PM - 5/21/2021
File details come from the government source that posted it. Updated .