Experience_Data_-_Incurred_&_Paid_Break_Down.xlsx

XLSX spreadsheet 468 KB Posted

Attached to
Short Term/Long Term Disability & Long Term Disability Only Services
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

File Type Posted
Short_Term_Long_Term_Disability_&_Long_Term_Disability_Only_Services_(Addendum_#4_Revision).pdf PDF
Incurred_&_Paid_(STD_Adjusted).xlsx XLSX spreadsheet
Short_Term_Long_Term_Disability_&_Long_Term_Disability_Only_Services_(Addendum_#3_Revision).pdf PDF
September_2026_Premium_Summary.xlsx XLSX spreadsheet
FICA_Service_Agreement.pdf PDF
2022_Renewal_Acceptance.pdf PDF
Short_Term_Long_Term_Disability_&_Long_Term_Disability_Only_Services.pdf PDF
Policy_Document_-_STD_B_Policy.pdf PDF
Policy_Document_-_STD_B_Performance_Guarantee.pdf PDF
Policy_Document_-_STD_B_Certificate.pdf PDF
Policy_Document_-_STD_B_Amendment_6_OE.pdf PDF
Policy_Document_-_STD_B_Amendment_5_member_def.pdf PDF
Policy_Document_-_STD_B_Amendment_4_Salary_Continuation.pdf PDF
Policy_Document_-_STD_B_Amendment_3_When_Ins_Becomes_Eff.pdf PDF
Policy_Document_-_STD_B_Amendment_2_DID_NOT_GO_INTO_EFFECT.pdf PDF
Policy_Document_-_STD_B_Amendment_1_Def_of_Dis.pdf PDF
Policy_Document_-_LTD_A_Policy.pdf PDF
Policy_Document_-_LTD_A_Performance_Guarantee.pdf PDF
Policy_Document_-_LTD_A_Notice_3_CARPC_grandfather.pdf PDF
Policy_Document_-_LTD_A_Certificate_Cl_4_Dane_Co_no_STD.pdf PDF
Policy_Document_-_LTD_A_Certificate_Cl_3_CARPC_no_STD.pdf PDF
Policy_Document_-_LTD_A_Certificate_Cl_2_Dane_Co_w_STD.pdf PDF
Policy_Document_-_LTD_A_Certificate_Cl_1_CARPC_w_STD.pdf PDF
Policy_Document_-_LTD_A_Certificate.pdf PDF
Policy_Document_-_LTD_A_Amendment_5_OE.pdf PDF
Policy_Document_-_LTD_A_Amendment_4_member_def.pdf PDF
Policy_Document_-_LTD_A_Amendment_3_CARPC_grandfather.pdf PDF
Policy_Document_-_LTD_A_Amendment_2.pdf PDF
Policy_Document_-_LTD_A_Amendment_1.pdf PDF
Incurred_&_Paid_-_Dane_County_-_STD.xlsx XLSX spreadsheet
Claims_-_Dane_County_-_Thru_8.2026_-_LTD.xlsx XLSX spreadsheet
Census_-_CARPC_-_Disability.xlsx XLSX spreadsheet
Census_-_Dane_County_9.16.26.xlsx XLSX spreadsheet
Highlight_Sheet_-_STD_Combo.pdf PDF
Highlight_Sheet_-_LTD_Combo.pdf PDF
Highlight_Sheet_-_LTD_Only.pdf PDF
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
From5/1/215/1/225/1/235/1/245/1/255/1/26Totals
Through4/30/224/30/234/30/244/30/254/30/268/31/26
Lives *2,0172,0532,1232,2072,2242,16912,793
Earned Premium387,137415,397475,707512,520519,879168,1572,478,797
Paid Claims222,780223,896250,498184,359214,102103,6251,199,260
FICA01,4789629032,7421646,249
Change in Reported Reserves0000000
Change in IBNR Reserves2,64223,13915,5027,7372,861-6,84645,035
Incurred Claims225,422248,513266,962193,000219,70596,9431,250,545
Loss Ratio58%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
From5/1/215/1/225/1/235/1/245/1/255/1/26Totals
Through4/30/224/30/234/30/244/30/254/30/268/31/26
Lives *2,1152,1492,2232,3072,3222,26413,380
Earned Premium386,637535,950582,071610,089619,923203,2422,937,912
Paid Claims191,16478,28222,588101,8009,997391404,222
FICA01710000171
Change in Reported Reserves107,66500348,19000455,855
Change in IBNR Reserves00000589,648589,648
Incurred Claims298,82978,45322,588449,9909,997590,0391,449,896
Loss Ratio77%15%4%74%2%290%49%

* Data pulled from end of period

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