Unified Government of Athens Clarke County LT.xlsx
XLSX spreadsheet 16 KB Posted
- 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 Period | 06/20 To 06/21 | 06/21 To 06/22 | 06/22 To 06/23 | 06/23 To 06/24 | 06/24 To 06/25 | 06/25 To 01/26 | Total |
| 06/20 To 06/21 | 10,800 | 10,800 | |||||
| 06/21 To 06/22 | 34,915 | 19,545 | 54,460 | ||||
| 06/22 To 06/23 | 0 | 111,049 | 0 | 111,049 | |||
| 06/23 To 06/24 | 0 | 51,550 | 32,636 | 0 | 84,186 | ||
| 06/24 To 06/25 | 0 | 109,160 | 0 | 56,392 | 1,092 | 166,644 | |
| 06/25 To 01/26 | 0 | 17,010 | 0 | 8,102 | 0 | 0 | 25,112 |
| Total Paid | 45,715 | 308,314 | 32,636 | 64,494 | 1,092 | 0 | 452,251 |
| Case Reserve | 0 | 274,132 | 78,342 | 44,424 | 96,743 | 0 | 493,641 |
| IBNR | 0 | 0 | 0 | 0 | 0 | 190,218 | 190,218 |
| Incurred Claims | 45,715 | 582,446 | 110,978 | 108,918 | 97,835 | 190,218 | 1,136,110 |
| Paid Premiums | 305,689 | 306,648 | 316,649 | 357,178 | 369,540 | 223,786 | 1,879,490 |
| Open Claims | 0 | 1 | 1 | 1 | 2 | 0 | 5 |
LTD - Claims Detail
| Group Underwriting | ||||||
| LTD Experience | ||||||
| Open and Closed Claims | ||||||
| Valuation Date | 1/1/26 | |||||
| Policy number | Division | Claim Status | Close Date | Net Benefit | Total Benefit Paid | Reserve |
| 00379727 | 0001 | OP | - | 2,780 | 0 | 78,342 |
| 00379727 | 0001 | CL | 7/30/24 | 0 | 0 | - |
| 00379727 | 0001 | CL | 3/17/21 | 0 | 0 | - |
| 00379727 | 0001 | CL | 11/17/21 | 2,182 | 0 | - |
| 00379727 | 0001 | OP | - | 3,043 | 0 | 34,128 |
| 00379727 | 0001 | CL | 3/28/24 | 4,202 | 32,637 | - |
| 00379727 | 0001 | CL | 3/9/21 | 0 | 0 | - |
| 00379727 | 0001 | OP | - | 2,430 | 104,507 | 274,132 |
| 00379727 | 0001 | CL | 10/8/25 | 0 | 0 | - |
| 00379727 | 0001 | CL | 3/6/24 | 2,265 | 54,356 | - |
| 00379727 | 0001 | CL | 6/18/25 | 2,056 | 19,875 | - |
| 00379727 | 0001 | CL | 12/8/22 | 2,433 | 18,955 | - |
| 00379727 | 0001 | CL | 4/30/25 | 122 | 1,092 | - |
| 00379727 | 0001 | CL | 12/22/21 | 2,197 | 952 | - |
| 00379727 | 0001 | CL | 6/18/21 | 0 | 0 | - |
| 00379727 | 0001 | CL | 7/11/23 | 0 | 0 | - |
| 00379727 | 0001 | CL | 11/7/24 | 4,224 | 129,563 | - |
| 00379727 | 0001 | OP | - | 991 | 12,877 | 44,424 |
| 00379727 | 0001 | CL | 1/5/22 | 928 | 28,188 | - |
| 00379727 | 0001 | CL | 7/31/21 | 0 | 0 | - |
| 00379727 | 0001 | OP | - | 2,649 | 0 | 62,615 |
| 00379727 | 0001 | CL | 3/10/22 | 2,842 | 17,525 | - |
| 00379727 | 0001 | CL | 5/29/25 | 5,289 | 31,734 | - |
File details come from the government source that posted it. Updated .