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
| File | Type | Posted |
|---|---|---|
| Exhibit H - SOC STD Certificate.pdf | ||
| Inquiries and Answers for RFP AABA 2027-0042.pdf | ||
| Exhibit A - Specifications and Requirements for RFP AABA 2027-0042.pdf | ||
| STD-LTD PGs.pdf | ||
| Exhibit B - Offeror Questionnaire.xlsx | XLSX spreadsheet | |
| Exhibit D - Information Technology Contract.docx | DOCX document | |
| Exhibit C - Cost Exhibit.xlsm | XLSM spreadsheet | |
| Exhibit G - SOC LTD Certificate.pdf | ||
| Exhibit E - W-9 - Fillable.pdf | ||
| Administrative Information for RFP AABA 2027-0042.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 .