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 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 PDF
RFP_21-057-DP_1_7-20-21.pdf PDF
RFP_21-057-DP_Appendix A - Part 1.docx DOCX document
RFP_21-057-DP_Attachment 3.pdf 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 DescriptionFully RevealedFully RevealedFully RevealedFully RevealedFully RevealedFully Revealed
Start Date1/1/20181/1/20191/1/20201/1/2021Total
End Date12/31/201812/31/201912/31/20206/26/2021FALSE

# 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

Reserves158,876166,891415,626215,218956,611
IBNR3743,13023,934187,465214,903
Net Incurred Claims566,572402,656553,405411,1921,933,825
Paid Loss Ratio101.2 %72.7 %96.9 %126.3 %96.2 %
Open/Pending Claims757827
Closed Claims13207141
Total Claims202514968
&"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
AgeGenderDate of DisabilityCoverage StatusBenefit
61M3/23/21PI1,000
60F3/18/21PI1,000
57M2/22/21PI1,000
47M2/18/21AC1,639
45M2/15/21PI1,000
63M2/5/21AC2,072
57F1/21/21AC2,697
66M1/10/21AC1,639
39F1/1/21CC1,000
60M12/4/20PI2,268
54M11/25/20AC1,000
50M11/24/20CC1,000
57M11/22/20CC1,000
56F11/6/20AC1,599
45M10/10/20AC1,000
36M7/22/20AC3,231
58F6/23/20AC5,000
43F6/13/20CC1,000
66M5/29/20AC4,881
27F4/7/20CC1,000
57M1/31/20CC3,106
61F1/21/20CC1,000
58F1/4/20CC1,000
61M12/27/19AC1,824
59F12/6/19CC1,000
51F12/5/19AC2,224
58M12/2/19AC2,512
59M11/19/19AC1,000
65M11/12/19CC5,000
31F11/7/19CC1,000
56M10/31/19CC4,245
25M10/24/19CC1,000
64M10/7/19CC1,912
62M10/4/19CC1,697
29M8/30/19CC1,000
58M8/15/19CC1,000
69F7/3/19CC2,605
57M6/18/19CC1,000
59F5/30/19CC1,875
61M5/27/19CC2,094
64F5/2/19CC429
64F4/9/19CC4,287
AgeGenderDate of DisabilityCoverage StatusBenefit
46M4/5/19CC3,106
41F4/4/19CC2,149
56M4/1/19AC1,000
58F3/15/19CC2,605
57F2/1/19CC1,000
52F1/11/19CC1,000
59F1/3/19CC2,605
59M12/6/18AC1,000
62M12/6/18AC1,632
46F11/5/18CC1,000
55M10/16/18CC2,740
62F7/12/18CC4,808
57M6/23/18AC1,000
62M5/31/18CC2,640
55M5/30/18AC2,766
53M5/15/18CC2,579
57M5/10/18AC1,000
60M4/28/18CC205
60M4/24/18CC2,050
64M4/21/18AC1,977
53M4/20/18AC2,579
50M4/9/18CC1,000
60M4/6/18CC1,914
55M3/30/18CC4,386
40F3/15/18CC1,000
61F2/6/18CC2,579
56M1/24/18CC1,000
63M1/20/18CC2,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 DescriptionFully RevealedFully RevealedFully RevealedFully RevealedFully Revealed
Start Date1/1/20191/1/20201/1/2021Total
End Date12/31/201912/31/20206/25/2021FALSE

# 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 .