Exhibit F - Payment Details Monthly Disability Claims 7.1.2023-6.30.2026.xlsx

XLSX spreadsheet 12 KB Posted

Attached to
Short-Term and Long-Term Disability Benefits
Solicitation number
RFP AABA 2027000042 2
Issued by
Denver County, Denver City, Colorado

About this file

This document is a payment details exhibit for Short-Term and Long-Term Disability Benefits in Colorado, covering the contract period from July 1, 2023 through June 30, 2026. The exhibit presents monthly claims and premium data for both short-term disability (STD) and long-term disability (LTD) coverage throughout the three-year contract term. The data tracks parallel metrics for each disability category, providing a comprehensive record of the financial activity associated with the state's disability benefits program.

The monthly data reveals significant variation in both premiums and paid claims across the contract period. Short-term disability premiums range from $0 to $402,369 monthly, with paid claims fluctuating between $6,428 and $377,290. Long-term disability premiums range from $0 to $583,931 monthly, with paid claims varying between $99,996 and $700,312. Notable gaps in premium payments appear in June 2024, June 2025, and June 2026, suggesting potential billing or enrollment cycles. The cumulative financial exposure represented in this exhibit demonstrates the substantial ongoing costs associated with maintaining comprehensive disability coverage for the state's workforce throughout the contract performance period.

View the file

Other files

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

Monthly Experience

DateSTD Paid PremiumSTD Paid ClaimsLTD Paid PremiumLTD Paid Claims
7/1/23$310,155$349,943$395,346$264,093
8/1/23$312,393$369,931$399,083$243,808
9/1/23$313,430$287,833$399,476$236,289
10/1/23$313,192$336,177$400,634$267,361
11/1/23$315,981$377,290$402,326$207,693
12/1/23$351,494$310,325$453,363$309,623
1/1/24$320,228$117,070$432,980$269,039
2/1/24$322,901$6,428$437,236$308,244
3/1/24$323,029$17,623$435,483$230,511
4/1/24$323,954$137,569$435,135$255,348
5/1/24$360,380$137,872$489,218$325,140
6/1/24$0$162,286$0$255,271
7/1/24$344,738$142,507$456,808$267,804
8/1/24$345,934$137,043$456,447$248,804
9/1/24$347,126$99,667$456,381$288,949
10/1/24$348,218$111,284$457,098$245,059
11/1/24$351,013$80,520$459,573$99,996
12/1/24$353,498$82,195$461,955$189,053
1/1/25$353,374$127,483$484,900$216,318
2/1/25$355,289$159,225$489,150$271,248
3/1/25$355,644$154,420$487,707$202,443
4/1/25$356,798$134,819$487,735$267,595
5/1/25$402,369$128,102$552,794$298,947
6/1/25$0$137,498$0$700,312
7/1/25$170,699$111,148$486,918$189,237
8/1/25$170,364$162,528$480,985$269,721
9/1/25$170,333$110,333$482,225$295,571
10/1/25$194,737$152,671$553,536$167,940
11/1/25$171,924$135,808$484,570$137,739
12/1/25$172,649$141,383$485,890$240,913
1/1/26$171,718$199,097$501,318$276,928
2/1/26$172,362$110,960$506,875$193,084
3/1/26$197,843$236,160$583,931$239,889
4/1/26$172,139$204,435$504,495$207,618
5/1/26$197,605$157,021$583,660$262,396
6/1/26$0$193,858$0$241,334
7/1/26

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