Exhibit F - Payment Details for 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 2027000070 1
Issued by
Denver County, Denver City, Colorado

About this file

Written by GovTribe AI ·

This is a payment details exhibit for Short-Term and Long-Term Disability Benefits provided to Colorado, covering the period from July 1, 2023 through June 30, 2026. The document presents monthly records of premiums paid and claims paid for both Short-Term Disability (STD) and Long-Term Disability (LTD) coverage across the contract term. The data spans 36 months of experience, with each monthly entry recording the corresponding premium and claim payment amounts for both disability categories.

The STD paid premiums range from $0 in June 2024 and June 2025 to a high of $402,369 in May 2025, while STD paid claims fluctuate between $6,428 in February 2024 and $377,290 in November 2023. LTD paid premiums range from $0 in June 2024 and June 2025 to $583,931 in March 2026, with LTD paid claims varying from $99,996 in November 2024 to $700,312 in June 2025. Notable variations in both premiums and claims occur throughout the contract period, with zero premium entries appearing in June of 2024, 2025, and presumably 2026, suggesting possible administrative or enrollment changes during those months. The data indicates the state's disability benefits experience and associated financial obligations across the full contract duration.

View the file

Other files

File Type Posted
Exhibit C - Cost Exhibit.xlsm XLSM spreadsheet
Exhibit I - Inquiries and Answers for RFP AABA 2027-0042.pdf PDF
Exhibit A - Specifications and Requirements for RFP AABA 2027-0070.pdf PDF
Exhibit H - SOC STD Certificate.pdf PDF
Administrative Information for RFP AABA 2027-XXXX.pdf PDF
Exhibit E - W-9 - Fillable.pdf PDF
Exhibit B - Offeror Questionnaire.xlsx XLSX spreadsheet
Exhibit D - Information Technology Contract.docx DOCX document
Exhibit G - SOC LTD Certificate.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 .