Unified Government of Athens Clarke County LT.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
RFP 26036 ¿ ACCGOV VOLUNTARY, DISABILITY, LIFE & FML BENEFITS
Solicitation number
PE-62960-NONST-2026-000000111
Issued by
Clayton County, Georgia

About this file

This file is a Long-Term Disability (LTD) Claims Experience Exhibit prepared for the Unified Government of Athens-Clarke County, Georgia, documenting underwriting data and claims history for Policy 0379727. The exhibit presents paid and incurred claims experience spanning from June 2020 through January 2026, including detailed breakdowns of claims by policy period, payment status, and current valuation as of January 1, 2026. The data encompasses five open claims and multiple closed claims with associated benefit payments and case reserves.

The claims experience shows total incurred losses of $1,136,110 against paid premiums of $1,879,490 over the policy period. Paid claims total $452,251, with case reserves of $493,641 and Incurred But Not Reported (IBNR) reserves of $190,218. The claims detail section identifies individual claim transactions with net benefits, total benefits paid, and reserve amounts, demonstrating claim lifespans ranging from short-term closed claims to longer-duration open claims. Monthly net benefit amounts for open claims range from $991 to $3,043, while closed claims reflect various total benefit payments from under $1,000 to over $129,000, providing comprehensive visibility into the group's disability claims profile and reserve adequacy for financial planning purposes.

View the file

Other files

Show all 23

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

LTD - Paid and Incurred

Group Underwriting
LTD Experience
Paid and Incurred Exhibits
Prepared for:ATHENS-CLARKE COUNTY GOV
Policy:0379727
Actual Experience Exhibit
Incurred Period
Paid Period06/20 To 06/2106/21 To 06/2206/22 To 06/2306/23 To 06/2406/24 To 06/2506/25 To 01/26Total
06/20 To 06/2110,80010,800
06/21 To 06/2234,91519,54554,460
06/22 To 06/230111,0490111,049
06/23 To 06/24051,55032,636084,186
06/24 To 06/250109,160056,3921,092166,644
06/25 To 01/26017,01008,1020025,112
Total Paid45,715308,31432,63664,4941,0920452,251
Case Reserve0274,13278,34244,42496,7430493,641
IBNR00000190,218190,218
Incurred Claims45,715582,446110,978108,91897,835190,2181,136,110
Paid Premiums305,689306,648316,649357,178369,540223,7861,879,490
Open Claims0111205

LTD - Claims Detail

Group Underwriting
LTD Experience
Open and Closed Claims
Valuation Date1/1/26
Policy numberDivisionClaim StatusClose DateNet BenefitTotal Benefit PaidReserve
003797270001OP-2,780078,342
003797270001CL7/30/2400-
003797270001CL3/17/2100-
003797270001CL11/17/212,1820-
003797270001OP-3,043034,128
003797270001CL3/28/244,20232,637-
003797270001CL3/9/2100-
003797270001OP-2,430104,507274,132
003797270001CL10/8/2500-
003797270001CL3/6/242,26554,356-
003797270001CL6/18/252,05619,875-
003797270001CL12/8/222,43318,955-
003797270001CL4/30/251221,092-
003797270001CL12/22/212,197952-
003797270001CL6/18/2100-
003797270001CL7/11/2300-
003797270001CL11/7/244,224129,563-
003797270001OP-99112,87744,424
003797270001CL1/5/2292828,188-
003797270001CL7/31/2100-
003797270001OP-2,649062,615
003797270001CL3/10/222,84217,525-
003797270001CL5/29/255,28931,734-

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