Experience_Data_-_Incurred_&_Paid_Break_Down.xlsx
XLSX spreadsheet 468 KB Posted
- Solicitation number
- 2026-RFP-065-PR
- Issued by
- Dane County, Wisconsin
About this file
This file contains short-term and long-term disability insurance experience data for Dane County, Wisconsin under Contract number 163054, covering the period from May 1, 2017 through August 31, 2026. The data presents paid and incurred claims information for both Short Term Disability (STD) and Long Term Disability (LTD) programs across six policy years. For STD, the data shows earned premiums totaling $2,478,797 with paid claims of $1,199,260 and incurred claims of $1,250,545, resulting in an overall loss ratio of 50 percent. For LTD, earned premiums totaled $2,937,912 with incurred claims of $1,449,896, reflecting a 49 percent loss ratio. The covered lives ranged from approximately 2,017 to 2,224 for STD and 2,115 to 2,322 for LTD across the measurement periods, with the most recent period (May 2025 through August 31, 2026) showing 2,169 lives for STD and 2,264 lives for LTD.
The experience data demonstrates significant year-to-year variation in claims activity, particularly in the LTD program where loss ratios ranged from 2 percent to 290 percent across individual policy years, with notably high incurred claims of $590,039 in the final period largely driven by increased IBNR (Incurred But Not Reported) reserves. This historical claims experience serves as a baseline for the current RFP process in which Dane County is soliciting proposals for Short Term/Long Term Disability and Long Term Disability Only insurance services, with the incumbent carrier being The Standard and anticipated contract commencement on May 1, 2027.
View the file
Other files
Show all 36
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
ST
County of Dane
| Contract number - 163054 |
| Coverage Effective Date: 5/1/2017 |
| Short Term Disability |
| Experience: Paid Basis |
| From | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | Totals |
| Through | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 8/31/26 |
| Lives * | 2,017 | 2,053 | 2,123 | 2,207 | 2,224 | 2,169 | 12,793 |
| Earned Premium | 387,137 | 415,397 | 475,707 | 512,520 | 519,879 | 168,157 | 2,478,797 |
| Paid Claims | 222,780 | 223,896 | 250,498 | 184,359 | 214,102 | 103,625 | 1,199,260 |
| FICA | 0 | 1,478 | 962 | 903 | 2,742 | 164 | 6,249 |
| Change in Reported Reserves | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Change in IBNR Reserves | 2,642 | 23,139 | 15,502 | 7,737 | 2,861 | -6,846 | 45,035 |
| Incurred Claims | 225,422 | 248,513 | 266,962 | 193,000 | 219,705 | 96,943 | 1,250,545 |
| Loss Ratio | 58% | 60% | 56% | 38% | 42% | 58% | 50% |
* Data pulled from end of period
LT
County of Dane
| Contract number - 163054 |
| Coverage Effective Date: 5/1/2017 |
| Long Term Disability |
| Experience: Incurred Basis |
| From | 5/1/21 | 5/1/22 | 5/1/23 | 5/1/24 | 5/1/25 | 5/1/26 | Totals |
| Through | 4/30/22 | 4/30/23 | 4/30/24 | 4/30/25 | 4/30/26 | 8/31/26 |
| Lives * | 2,115 | 2,149 | 2,223 | 2,307 | 2,322 | 2,264 | 13,380 |
| Earned Premium | 386,637 | 535,950 | 582,071 | 610,089 | 619,923 | 203,242 | 2,937,912 |
| Paid Claims | 191,164 | 78,282 | 22,588 | 101,800 | 9,997 | 391 | 404,222 |
| FICA | 0 | 171 | 0 | 0 | 0 | 0 | 171 |
| Change in Reported Reserves | 107,665 | 0 | 0 | 348,190 | 0 | 0 | 455,855 |
| Change in IBNR Reserves | 0 | 0 | 0 | 0 | 0 | 589,648 | 589,648 |
| Incurred Claims | 298,829 | 78,453 | 22,588 | 449,990 | 9,997 | 590,039 | 1,449,896 |
| Loss Ratio | 77% | 15% | 4% | 74% | 2% | 290% | 49% |
* Data pulled from end of period
File details come from the government source that posted it. Updated .