RFP_21-057-DP_1_Attachment-6.xlsx
XLSX spreadsheet 95 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 for disability insurance claims submitted by New York Life Insurance Company to the Palm Beach County Board of Education. The document provides comprehensive claims experience data for Long Term Disability (LTD), Short Term Disability (STD), and related benefit programs (ASO Claims, ATP Claims, and FMLA Claims) administered under policy numbers FLK0960504 for LTD and VDT0960736 for STD as of June 2021.
For LTD coverage, the experience period spans January 1, 2018 through June 26, 2021, with paid premiums totaling $2,010,205 and net incurred claims of $1,933,825, resulting in a paid loss ratio of 96.2 percent. The LTD claims experience shows 68 total claims (27 open/pending and 41 closed) with individual benefit amounts ranging from $205 to $5,000 monthly. For STD coverage, the experience period covers January 1, 2019 through June 25, 2021, with paid premiums of $1,137,356 and paid claims of $528,087, reflecting a paid loss ratio of 46.4 percent across 137 total claims. The presentation includes detailed claims exhibits listing individual claimant demographics, disability dates, coverage status, and benefit amounts to demonstrate the vendor's claims management experience with the County Board.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP_21-057-DP_Attachment 5.xls | XLS spreadsheet | |
| 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.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 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
© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved
Experience Presentation For:
PALM BEACH COUNTY BOARD
STD ASO_Claims
STD ASO
&G
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &"Tahoma,Italic"&7Created : &T - &D |
STD ATP_Claims
STD ATP
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &"Tahoma,Italic"&7Created : &T - &D |
FMLA_Claims
FMLA Claims
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &"Tahoma,Italic"&7Created : &T - &D |
LTD Experience Exhibit
| PALM BEACH COUNTY BOARD |
| Long Term Disability |
| FLK0960504 |
| As Of 6/26/2021 |
| Claims Reported on an Incurred Basis | ||||||
| Period Description | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed |
| Start Date | 1/1/2018 | 1/1/2019 | 1/1/2020 | 1/1/2021 | Total | |
| End Date | 12/31/2018 | 12/31/2019 | 12/31/2020 | 6/26/2021 | FALSE |
# of Months 12 12 12 6 42
Paid Premium 559,684 554,196 570,882 325,443 2,010,205
Paid Claims 407,322 232,635 113,845 8,509 762,311
| Reserves | 158,876 | 166,891 | 415,626 | 215,218 | 956,611 |
| IBNR | 374 | 3,130 | 23,934 | 187,465 | 214,903 |
| Net Incurred Claims | 566,572 | 402,656 | 553,405 | 411,192 | 1,933,825 |
| Paid Loss Ratio | 101.2 % | 72.7 % | 96.9 % | 126.3 % | 96.2 % |
| Open/Pending Claims | 7 | 5 | 7 | 8 | 27 |
| Closed Claims | 13 | 20 | 7 | 1 | 41 |
| Total Claims | 20 | 25 | 14 | 9 | 68 |
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &I&7&"Tahoma" Created: 8:53 AM - 6/30/2021 |
LTD Claims Exhibit
| PALM BEACH COUNTY BOARD |
| Long Term Disability |
| FLK0960504 |
| As Of 6/26/2021 |
| All Claims | ||||
| Age | Gender | Date of Disability | Coverage Status | Benefit |
| 61 | M | 3/23/21 | PI | 1,000 |
| 60 | F | 3/18/21 | PI | 1,000 |
| 57 | M | 2/22/21 | PI | 1,000 |
| 47 | M | 2/18/21 | AC | 1,639 |
| 45 | M | 2/15/21 | PI | 1,000 |
| 63 | M | 2/5/21 | AC | 2,072 |
| 57 | F | 1/21/21 | AC | 2,697 |
| 66 | M | 1/10/21 | AC | 1,639 |
| 39 | F | 1/1/21 | CC | 1,000 |
| 60 | M | 12/4/20 | PI | 2,268 |
| 54 | M | 11/25/20 | AC | 1,000 |
| 50 | M | 11/24/20 | CC | 1,000 |
| 57 | M | 11/22/20 | CC | 1,000 |
| 56 | F | 11/6/20 | AC | 1,599 |
| 45 | M | 10/10/20 | AC | 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 | 5/2/19 | CC | 429 |
| 64 | F | 4/9/19 | CC | 4,287 |
| Age | Gender | Date of Disability | Coverage Status | Benefit |
| 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 |
| 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 |
&G
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &I&7&"Tahoma"Created: 8:53 AM - 6/30/2021 |
STD Experience Exhibit
| PALM BEACH COUNTY BOARD |
| Short Term Disability |
| VDT0960736 |
| As Of 6/25/2021 |
| Claims Reported on a Paid Basis | |||||
| Period Description | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed | Fully Revealed |
| Start Date | 1/1/2019 | 1/1/2020 | 1/1/2021 | Total | |
| End Date | 12/31/2019 | 12/31/2020 | 6/25/2021 | FALSE |
# of Months 12 12 6 30
Paid Premium 376,180 490,916 270,260 1,137,356
Paid Claims 155,630 230,989 141,468 528,087
Paid Loss Ratio 41.4 % 47.1 % 52.3 % 46.4 %
Total Claims 37 61 39 137
| &"Tahoma,Italic"&7© 2021 New York Life Insurance Company, New York, NY. All Rights Reserved | &"Tahoma,Regular"&7&P of &N |
| &I&7&"Tahoma" Created: 8:53 AM - 6/30/2021 |
image1.png image2.png image3.png
File details come from the government source that posted it. Updated .