RFP%2031786-00193%20Appendix%207.1%20Claims_Conversion%20and%20Premium%20Experience%202018%20_June%202026%20Basic%20Term%20Life%20and%20Basic%20ADD.xlsb
XLSB spreadsheet 13 KB Posted
- Solicitation number
- RFP 31786-00193
- Issued by
- Davidson County, Tennessee
About this file
This file is a claims, conversion, and premium experience appendix for RFP 31786-00193 related to Basic Term Life and Basic Accidental Death and Dismemberment (AD&D) insurance coverage for Tennessee. The document presents participating experience data for Policy Number 34294 spanning from January 1, 2018 through June 30, 2026, detailing claims history, premium information, and conversion activity across multiple coverage types including Basic Life, Spouse and Child Life, Spouse Life, Child Life, and various AD&D employee and dependent options. The data is presented on a cash basis for each calendar year or partial year period, providing historical performance metrics that serve as the foundation for evaluating the incumbent carrier's experience and informing pricing and risk assessment for the contract period.
The experience data reveals premium remitted amounts ranging from $6.2 million to $9.3 million annually, with corresponding billed claims and loss ratios generally ranging between 93% and 113%. Key metrics include approved waiver claims and paid claims counts for each coverage type, number of policy conversions annually ranging from 3 to 58, and conversion amounts ranging from $15,000 to $1.2 million. Notable trends show relatively stable loss ratios of approximately 98-99% from 2018 through 2020, elevated loss ratios of 106-113% in 2021-2022, and a return to normalized ratios of 98-99% in 2023-2025. The data includes a transition period in 2023 where old and new participating experience are separated, indicating a potential plan design change or carrier transition during that year.
Text of this file
7.1 Basic Term Life & Basic ADD
| RFP 31786-00193 Appendix 7.1 Claims, Conversion and Premium Experience 2018 - June 2026 Basic Term Life and Basic ADD | ||||||
| Participating Experience by Coverage (Cash Basis) | ||||||
| Policy Number: 34294 | ||||||
| For the Period January 1, 2018 through December 31, 2018 | ||||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims | |
| Basic Life | $6,415,134 | $6,334,163 | 98.7% | 54 | 137 | |
| Spouse and Child Life | $342,444 | $338,472 | 98.8% | 0 | 112 | |
| Child Life | $33,550 | $33,097 | 98.6% | 0 | 11 | |
| Basic AD&D - Employee | $632,049 | $610,356 | 96.6% | 0 | 8 | |
| Basic AD&D - Dependent | $230,910 | $226,949 | 98.3% | 0 | 7 | |
| Total Participating Coverages | $7,654,087 | $7,543,037 | 98.5% | 54 | 275 | |
| Number of Conversions | 58 | |||||
| Amount Converted | $1,248,000 | |||||
| Participating Experience by Coverage (Cash Basis) | ||||||
| Policy Number: 34294 | ||||||
| For the Period January 1, 2019 through December 31, 2019 | ||||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims | |
| Basic Life | $5,020,178 | $4,934,383 | 98.30% | 0 | 106 | |
| Spouse and Child Life | 106,568 | 104,086 | 97.70% | 0 | 32 | |
| Spouse Life | 148,940 | 147,803 | 99.20% | 0 | 48 | |
| Child Life | 32,068 | 31,594 | 98.50% | 0 | 10 | |
| Basic AD&D - Employee | 665,957 | 645,579 | 96.90% | 0 | 6 | |
| Basic AD&D - Dependent | 212,513 | 208,649 | 98.20% | 0 | 6 | |
| Total Participating Coverages | $6,186,224 | $6,072,094 | 98.2% | 0 | 208 | |
| Number of Conversions | 28 | |||||
| Amount Converted | $699,800 | |||||
| ` | ||||||
| Participating Experience by Coverage (Cash Basis) | ||||||
| Policy Number: 34294 | ||||||
| For the Period January 1, 2020 through December 31, 2020 |
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $6,767,075.00 | $6,680,252.00 | 98.7% | 12 | 153 |
| Spouse and Child Life | $176,931.00 | $174,407.00 | 98.6% | 0 | 58 |
| Spouse Life | $127,343.00 | $126,200.00 | 99.1% | 0 | 42 |
| Child Life | $27,529.00 | $27,060.00 | 98.3% | 0 | 9 |
| Basic AD&D - Employee | $309,879.00 | $289,259.00 | 93.3% | 0 | 3 |
| Basic AD&D - Dependent | $67,295.00 | $64,067.00 | 95.2% | 0 | 5 |
| Total Participating Coverages | $7,476,052.00 | $7,361,245.00 | 98.5% | 12 | 270 |
| Number of Conversions | 22 | ||||
| Amount Converted | $425,000.00 | ||||
| Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2021 through December 31, 2021 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $7,775,869 | $8,344,994 | 107.3% | 23 | 195 |
| Spouse and Child Life | 260,527 | 282,449 | 108.4% | 0 | 94 |
| Spouse Life | 129,479 | 120,098 | 92.8% | 0 | 40 |
| Child Life | 38,436 | 51,045 | 132.8% | 0 | 17 |
| Basic AD&D - Employee | 910,825 | 904,812 | 99.3% | 0 | 12 |
| Basic AD&D - Dependent | 153,674 | 162,278 | 105.6% | 0 | 9 |
| Total Participating Coverages | $9,268,810 | $9,865,676 | 106.4% | 23 | 367 |
| Number of Conversions | 19 | ||||
| Amount Converted | $329,000 | ||||
| Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2022 through December 31, 2022 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $6,633,297 | $7,465,016 | 112.5% | 36 | 173 |
| Spouse and Child Life | 263,933 | 315,550 | 119.6% | 0 | 105 |
| Spouse Life | 17,692 | 32,976 | 186.4% | 0 | 11 |
| Child Life | 24,930 | 24,094 | 96.6% | 0 | 8 |
| Basic AD&D - Employee | 632,114 | 754,303 | 119.3% | 0 | 10 |
| Basic AD&D - Dependent | 153,488 | 165,725 | 108.0% | 0 | 6 |
| Total Participating Coverages | $7,725,454 | $8,757,664 | 113.4% | 36 | 313 |
| Number of Conversions | 19 | ||||
| Amount Converted | $470,000 | ||||
| Old Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2023 through December 31, 2023 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $0 | $1,717,453 | 0% | 51 | 32 |
| Spouse and Child Life | $0 | $45,198 | 0% | 0 | 15 |
| Spouse Life | $0 | $18,079 | 0% | 0 | 6 |
| Child Life | $0 | $6,018 | 0% | 0 | 2 |
| Basic AD&D - Employee | $0 | $647,858 | 0% | 0 | 7 |
| Basic AD&D - Dependent | $0 | $160,573 | 0% | 0 | 2 |
| Total Participating Coverages | $0 | $2,595,179 | 0% | 0 | 65 |
| Number of Conversions | 3 | ||||
| Amount Converted | $15,000 | ||||
| New Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2023 through December 31, 2023 |
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $6,876,126 | $6,818,340 | 99.2% | 2 | 143 |
| Spouse and Child Life | 172,225 | 163,650 | 95.0% | 0 | 52 |
| Spouse Life | 193,418 | 192,628 | 99.6% | 0 | 63 |
| Child Life | 25,786 | 25,452 | 98.7% | 0 | 8 |
| Basic AD&D - Employee | 601,037 | 584,888 | 97.3% | 0 | 5 |
| Basic AD&D - Spouse & Child | 25,381 | 24,362 | 96.0% | 0 | 2 |
| Basic AD&D - Spouse | 5,090 | 4,121 | 81.0% | 0 | 0 |
| Basic AD&D - Child | 18,829 | 18,107 | 96.2% | 0 | 2 |
| Total Participating Coverages | $7,917,892 | $7,831,548 | 98.9% | 2 | 275 |
| Number of Conversions | 12 | ||||
| Amount Converted | $244,000 | ||||
| New Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2024 through December 31, 2024 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $8,002,888 | $7,929,959 | 99.1% | 9 | 128 |
| Spouse and Child Life | $22,473 | $9,518 | 42.4% | 0 | 0 |
| Spouse Life | $24,033 | $29,691 | 123.5% | 0 | 11 |
| Child Life | $4,367 | $4,594 | 105.2% | 0 | 2 |
| Basic AD&D - Employee | $694,401 | $696,827 | 100.3% | 0 | 10 |
| Basic AD&D - Spouse & Child | $10,044 | $16,958 | 168.8% | 0 | 2 |
| Basic AD&D - Spouse | $132,271 | $128,150 | 96.9% | 0 | 3 |
| Basic AD&D - Child | $17,762 | $3,446 | 19.4% | 0 | 0 |
| Total Participating Coverages | $8,908,239 | $8,819,143 | 99.0% | 9 | 156 |
| Number of Conversions | $72 | ||||
| Amount Converted | $949,000 | ||||
| New Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2025 through December 31, 2025 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | $8,691,009 | $8,610,008 | 99.1% | 16 | 135 |
| Basic AD&D - Employee | $463,378 | $453,876 | 97.9% | 0 | 7 |
| Total Participating Coverages | $9,154,387 | $9,063,884 | 99.0% | 16 | 142 |
| Number of Conversions | 15 | ||||
| Amount Converted | $579,500 | ||||
| New Participating Experience by Coverage (Cash Basis) | |||||
| Policy Number: 34294 | |||||
| For the Period January 1, 2026 through June 30, 2026 | |||||
| Coverage | Remitted Premium | Billed Claims | Loss Ratio | Number of Approved Waiver Claims | Number of Paid Claims |
| Basic Life | 4459890 | 4205572 | 94.30% | 23 | 63 |
| Basic AD&D - Employee | 133326 | 117166 | 87.90% | 0 | 10 |
| Total Participating Coverages | |||||
| Number of Conversions | 9 | ||||
| Amount Converted | $211,750 |
Other files
Show all 38
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
File details come from the government source that posted it. Updated .