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 1
- Issued by
- Denver County, Denver City, Colorado
About this file
This file is a payment details exhibit for Colorado's Short-Term and Long-Term Disability Benefits contract, documenting monthly premium payments and paid claims from July 1, 2023 through June 30, 2026. The exhibit tracks financial performance across two disability benefit categories: Short-Term Disability (STD) and Long-Term Disability (LTD). The contract term spans three years, with monthly data entries recording both premium revenues and claims paid for each benefit type. STD premiums range from $0 to $402,369 monthly, while LTD premiums range from $0 to $583,931 monthly. Notable payment gaps appear in June 2024, June 2025, and June 2026, where both STD and LTD premiums are recorded as $0, suggesting potential contract renewal or transition periods.
Claims experience shows considerable monthly variation across both benefit categories. STD paid claims fluctuate between $6,428 and $377,290 monthly, while LTD paid claims range from $99,996 to $700,312 monthly, with the highest LTD claims payment occurring in June 2025 at $700,312. The cumulative financial data reflects the cost and utilization patterns of the disability benefits program over the three-year contract period, providing essential baseline metrics for evaluating plan performance and predicting future liability and premium requirements for Colorado's state or local government entity.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit D - Information Technology Contract.docx | DOCX document | |
| Exhibit C - Cost Exhibit.xlsm | XLSM spreadsheet | |
| Exhibit B - Offeror Questionnaire.xlsx | XLSX spreadsheet | |
| Exhibit H - SOC STD Certificate.pdf | ||
| Exhibit E - W-9 - Fillable.pdf | ||
| Exhibit A - Specifications and Requirements for RFP AABA 2027-0042.pdf | ||
| Administrative Information for RFP AABA 2027-0042.pdf | ||
| Exhibit G - SOC LTD Certificate.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
Text version
Monthly Experience
| Date | STD Paid Premium | STD Paid Claims | LTD Paid Premium | LTD 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 .