Exhibit_5_-_Short-_and_Long-Term_Disability_Experience_Report_(2020-May_2024)_(1).pdf

231 KB Posted

Attached to
Short- and Long-Term Disability
Solicitation number
2024-335
Issued by
Collin County, Texas

About this file

Written by GovTribe AI ·

This document is an Experience Reports Package from Blue Cross Blue Shield of Texas for Collin County Government, detailing the disability insurance experience from January 1, 2020, through April 30, 2024, for group number F024952. The report comprehensively tracks Short-Term Disability (STD) and Long-Term Disability (LTD) metrics, including premiums, average lives covered, paid claims, disabled claim reserves, and incurred but not reported (IBNR) reserves across five distinct annual periods.

The financial analysis reveals significant variations in loss ratios and claim experiences over the tracked period. The Long-Term Disability loss ratio ranged from 0% in 2021 to 307% in 2022, with total paid claims of $267,343 and disabled claim reserves of $923,085. Short-Term Disability claims totaled $1,026,898 over the same period, with fees accumulating to $169,042. The average number of lives covered remained relatively stable, ranging between 1,536 and 1,665 throughout the evaluation period, indicating a consistent workforce size for Collin County Government during this timeframe.

View the file

Other files

File Type Posted
Short-_and_Long-Term_Disability_(Addendum_#3_Revision).pdf PDF
Copy_of_I_Exhibit_6_-_Short-_and_Long-Term_Disability_Census_-_May_2024_v2.xlsx XLSX spreadsheet
Exhibit_6_-_Short-_and_Long-Term_Disability_Census_-_May_2024.pdf PDF
Exceptions.docx DOCX document
Exhibit_7_-_Short_Term_Disability_Count_by_Month.pdf PDF
LEGAL_NOTICE_TEMPLATE-RFP-2024-335_.pdf PDF
W-9_rev_2018-3-22-24.pdf PDF
CIQ_-3-22-24.pdf PDF
Attachment_C_Disability_Pricing_Information_Updated_v2.pdf PDF
Exhibit_4_-_Short-_and_Long-Term_Disability_Rates_(1).xlsx XLSX spreadsheet
Attachment_A_Disability_RFP_Questionnairev3.xlsx XLSX spreadsheet
Attachment_B_-_Disability_Questionnaire.pdf PDF
Exhibit_2_-_Long-Term_Disability_Plan_Document_Class_1_(1).pdf PDF
Exhibit_3_-_Long-Term_Disability_Plan_Document_Class_2_(1).pdf PDF
Exhibit_1_-_Short-Term_Disability_Plan_Document_(1)_(1).pdf PDF
Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Insurance products issued by Dearborn Life Insurance Company, 701 E. 22nd St. Suite 300, Lombard, IL 60148. Blue Cross and Blue Shield of Texas is the trade name of Dearborn Life

Insurance Company, an independent Blue Cross and Blue Shield licensee. BLUE CROSS®, BLUE SHIELD® and the Cross and Shield Symbols are registered service marks of the Blue Cross and Blue Shield Association, an association of independent Blue Cross and Blue Shield Plans. All plans are subject to a rate term as stated within.

Exhibit 5 Experience Reports Package

Group Name

COLLIN COUNTY GOVERNMENT

Group Number

F024952

Experience Start Date:

Experience End Date:

Report Date: May 28, 2024

January 1, 2020

April 30, 2024

Disability Experience Summary

COLLIN COUNTY GOVERNMENT

Group Number: F024952

Report Date: May 28, 2024 Valuation Date: April 30, 2024

Period Premium Average Volume Average Lives Paid Claims Disabled Claim

Reserves

IBNR

Loss

Ratio

1/1/2020 - 12/31/2020 236,802 8,222,287 1,579 90,419 0 0 38% 1/1/2021 - 12/31/2021 239,171 8,305,565 1,561 178 0 0 0% 1/1/2022 - 12/31/2022 246,526 8,559,918 1,559 150,161 606,856 0 307% 1/1/2023 - 12/31/2023 266,698 9,260,343 1,598 26,586 316,229 0 129% 1/1/2024 - 4/30/2024 76,424 10,614,406 1,647 0 0 153,834 201%

Total 1,065,620 8,992,504 1,589 267,343 923,085 153,834 126%

Period Disabled Claim

Reserves

IBNR

Loss

Ratio

1/1/2020 - 12/31/2020 0 0 105% 1/1/2021 - 12/31/2021 0 0 90% 1/1/2022 - 12/31/2022 606,856 0 353% 1/1/2023 - 12/31/2023 316,229 0 191% 1/1/2024 - 4/30/2024 0 153,834 269%

Total 923,085 153,834 192%

Long Term Disability Summary

Totals

86,802

Premium

1,234,662

Paid Claims

290,698 250,392 403,040 270,347 79,765

1,294,242

276,580 278,504 285,800 306,976

ASO Experience Summary

COLLIN COUNTY GOVERNMENT

Group Number: F024952

Report Date: May 28, 2024 Valuation Date: April 30, 2024

Period

1/1/2020 - 12/31/2020 1/1/2021 - 12/31/2021 1/1/2022 - 12/31/2022 1/1/2023 - 12/31/2023 1/1/2024 - 4/30/2024

Total

ASO STD Summary

Fees

39,778 39,333

1,026,898 1,589

Paid Claims

200,279 250,214 252,880

169,042 79,765

Lives

1,579 1,561 1,559 1,598243,761 1,647

39,274 40,278 10,378

Long Term Disability Experience Detail

COLLIN COUNTY GOVERNMENT

Group Number: F024952

Report Date: May 28, 2024 Valuation Date: April 30, 2024

Month/Year Premium Average Volume Average

Lives Paid Claims

Disabled Claim

Reserves

IBNR

Loss

Ratio

01/2020 18,939 7,891,204 1,548 0 0 02/2020 19,563 8,151,322 1,558 3,828 0 03/2020 19,693 8,205,247 1,577 0 0 04/2020 19,688 8,203,363 1,573 0 0 05/2020 19,707 8,211,267 1,577 0 0 06/2020 19,736 8,223,265 1,581 0 0 07/2020 19,708 8,211,805 1,580 0 0 08/2020 19,710 8,212,618 1,580 0 0 09/2020 19,761 8,233,925 1,585 12,923 0 10/2020 20,092 8,371,841 1,589 50,424 0 11/2020 20,184 8,409,942 1,595 23,244 0 12/2020 20,020 8,341,645 1,599 0 0

Period Totals 236,802 8,222,287 1,579 90,419 0 0 38%

01/2021 20,235 8,431,401 1,591 0 0 02/2021 20,215 8,422,881 1,592 0 0 03/2021 20,224 8,426,706 1,598 0 0 04/2021 20,103 8,376,456 1,584 0 0 05/2021 19,875 8,281,403 1,564 0 0 06/2021 19,788 8,245,202 1,558 0 0 07/2021 19,621 8,175,599 1,546 0 0 08/2021 19,596 8,164,864 1,543 178 0 09/2021 19,569 8,165,864 1,543 0 0 10/2021 20,010 8,337,450 1,540 0 0 11/2021 19,941 8,308,937 1,534 0 0 12/2021 19,992 8,330,014 1,537 0 0

Period Totals 239,171 8,305,565 1,561 178 0 0 0%

01/2022 20,587 8,577,918 1,536 99,687 370,257 02/2022 20,561 8,566,917 1,536 0 0 03/2022 20,534 8,555,812 1,537 0 0 04/2022 20,456 8,523,128 1,532 50,148 236,599 05/2022 20,521 8,550,433 1,544 0 0 06/2022 20,671 8,612,994 1,563 0 0 07/2022 20,579 8,574,600 1,556 0 0 08/2022 20,658 8,607,606 1,569 0 0 09/2022 20,597 8,581,881 1,567 0 0 10/2022 20,198 8,415,887 1,599 0 0 11/2022 20,198 8,415,887 1,599 0 0 12/2022 20,966 8,735,951 1,564 326 0

Period Totals 246,526 8,559,918 1,559 150,161 606,856 0 307%

01/2023 21,875 9,114,375 1,578 0 0 02/2023 21,884 9,118,477 1,581 0 0 03/2023 21,946 9,144,159 1,586 9,721 9,794 04/2023 22,023 9,176,247 1,590 0 0 05/2023 22,032 9,179,973 1,594 16,865 306,435 06/2023 21,977 9,157,215 1,594 0 0 07/2023 22,041 9,183,884 1,604 0 0 08/2023 22,049 9,186,910 1,608 0 0 09/2023 21,984 9,159,944 1,599 0 0 10/2023 22,887 9,536,203 1,606 0 0 11/2023 23,006 9,585,717 1,620 0 0 12/2023 22,994 9,581,015 1,620 0 0

Period Totals 266,698 9,260,343 1,598 26,586 316,229 0 129%

01/2024 25,293 10,538,590 1,628 0 0 02/2024 25,492 10,621,680 1,649 0 0 03/2024 25,639 10,682,949 1,665 0 0 04/2024 0 0 0 0 0

Period Totals 76,424 10,614,406 1,647 0 0 153,834 201%

Grand Totals 1,065,620 8,992,504 1,589 267,343 923,085 153,834 126%

ASO Short Term Disability Detail

Group Number: F024952

Report Date: May 28, 2024 Valuation Date: April 30, 2024

Month/Year Lives

01/2020 1,548 02/2020 1,558 03/2020 1,577 04/2020 1,573 05/2020 1,577 06/2020 1,581 07/2020 1,580 08/2020 1,580 09/2020 1,585 10/2020 1,589 11/2020 1,595 12/2020 1,599

Period Totals 1,579

01/2021 1,591 02/2021 1,592 03/2021 1,598 04/2021 1,584 05/2021 1,564 06/2021 1,558 07/2021 1,546 08/2021 1,543 09/2021 1,543 10/2021 1,540 11/2021 1,534 12/2021 1,537

Period Totals 1,561

01/2022 1,536 02/2022 1,536 03/2022 1,537 04/2022 1,532 05/2022 1,544 06/2022 1,563 07/2022 1,556 08/2022 1,569 09/2022 1,567 10/2022 1,599 11/2022 1,599 12/2022 1,564

Period Totals 1,559

01/2023 1,578 02/2023 1,581 03/2023 1,586 04/2023 1,590 05/2023 1,594 06/2023 1,594 07/2023 1,604 08/2023 1,608 09/2023 1,599 10/2023 1,606 11/2023 1,620 12/2023 1,620

Period Totals 1,598

01/2024 1,628 02/2024 1,649 03/2024 1,665 04/2024 0

Period Totals 1,647

Grand Totals 1,589

Fees Paid Claims

3,251 1,716

3,312 21,237 3,320 22,343 3,318 18,464

3,272 12,045 3,312 22,870 3,303 14,281

3,350 14,378 3,358 29,276

39,778 200,279

3,318 8,959 3,329 21,536 3,337 13,174

3,326 9,355 3,284 26,792 3,272 20,596

3,341 32,273 3,343 23,552 3,356 14,663

3,234 26,226 3,221 28,633 3,228 17,261

3,247 19,391 3,240 23,616 3,240 7,855

3,228 20,863 3,217 18,150 3,242 25,363

39,333 250,214

3,226 17,127 3,226 5,382

3,291 22,314 3,358 17,207 3,358 23,201

3,282 20,210 3,268 50,557 3,295 22,795

3,320 14,486 3,331 8,694 3,339 17,570

3,284 9,710 39,274 252,880

3,314 17,190

3,377 57,368 3,358 18,833 3,373 19,166

3,347 7,913 3,347 32,103 3,368 5,677

3,419 16,383 3,463 20,205 3,497 14,600

3,402 18,280 3,402 26,480

40,278 243,761

0 28,576 10,378 79,765

169,042 1,026,898

Glossary

Group Number: F024952

Report Date: May 28, 2024 Valuation Date: April 30, 2024

Paid Claims (LTD)

Paid Claims (STD)

Elimination Period

Claim Lag (LTD)

Disabled Claim Reserves

Incurred But Not

Reported (IBNR) Reserves

Loss Ratio (LTD)

Loss Ratio (STD)

Glossary of Terms

Comprised of the Elimination Period plus 1 month. The Claim Lag period is contained within the most recent experience period(s) and is representative of immature claim activity.

The amount of money held to pay open or pending claims as of the most recent valuation date in the experience period.

These reserves are used to cover outstanding incurred, but unpaid claims.

Total payments and disabled claim reserves on claims incurred during the experience period based on date of incurral plus IBNR reserves divided by premium. This does not include premium rate adjustments or investment credits.

Total claim payments made during the experience period based on date paid plus changes in IBNR reserves divided by premium. This does not include premium rate adjustments.

Total payments made on claims during the experience period based on incurral date.

Total payments made on claims during the experience period based on payment date.

The number of calendar days at the beginning of a continuous period of Disability for which no benefits are payable.

File details come from the government source that posted it. Updated .