RFP%2031786-00193%20Appendix%207.2%20Claims%20Conversion%20and%20Premium%20Experience%202018_June%202026%20Voluntary%20ADandD.xlsb
XLSB spreadsheet 12 KB Posted
- Solicitation number
- RFP 31786-00193
- Issued by
- Davidson County, Tennessee
About this file
This is a claims experience and actuarial data exhibit for RFP 31786-00193 related to Voluntary Accidental Death and Dismemberment (AD&D) insurance coverage provided to the State of Tennessee. The document presents detailed nonparticipating experience data spanning from January 1, 2018 through June 30, 2026 for policy number 34295, tracking earned premiums, incurred claims, loss ratios, and the number of paid claims across multiple coverage types including employee, dependent, spouse, child, family, and single coverage options.
The data reveals significant volatility in claims experience over the period analyzed. From 2018 through 2022, the plan experienced generally elevated loss ratios ranging from 12.9% to 141.3%, with employee coverage showing particularly high claims ratios in 2021 (197.7%) and 2022 (255.5%). Beginning in 2023, the coverage structure was reorganized to reflect single, spouse and child, spouse-only, and child-only options. The loss experience improved substantially in 2024 and 2025, with overall loss ratios of 37.4% and negative 9.0% respectively, before spiking again to 117.7% in the first half of 2026. Total earned premiums increased progressively from $894,220 in 2018 to $1,964,103 in 2025, indicating growing enrollment or rate adjustments over the contract period.
Text of this file
7.2 Voluntary AD&D
| RFP 31786-00193 Appendix 7.2 Claims, Conversion and Premium Experience 2018 - June 2026 Voluntary AD&D | |||||
| Nonparticipating Experience by Coverage (Incurred Basis) | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2018 through December 31, 2018 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Employee | $658,172 | $90,434 | 13.7% | 3 | |
| Voluntary AD&D - Dependent | $236,048 | $25,029 | 10.6% | 1 | |
| Total Voluntary AD&D Coverages | $894,220 | $115,463 | 12.9% | 4 | |
| Nonparticipating Experience by Coverage (Incurred Basis) | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2019 through December 31, 2019 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Employee | $142,384 | $183,526 | 128.9% | 3 | |
| Voluntary AD&D - Dependent | $244,320 | $96,101 | 39.3% | 4 | |
| Total Voluntary AD&D Coverages | $386,704 | $279,627 | 72.3% | 7 | |
| Nonparticipating Experience by Coverage (Incurred Basis) | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2020 through December 31, 2020 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Employee | $148,889 | $130,833 | 87.9% | 2 | |
| Voluntary AD&D - Family | $259,237 | $15,383 | 5.9% | 4 | |
| Total Voluntary AD&D Coverages | $408,126 | $146,216 | 72.3% | 6 | |
| Nonparticipating Experience by Coverage (Incurred Basis) | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2021 through December 31, 2021 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Employee | $148,188 | $292,996 | 197.7% | 6 | |
| Voluntary AD&D - Dependent | $264,833 | $148,823 | 56.2% | 8 | |
| Total Voluntary AD&D Coverages | $413,021 | $441,819 | 107.0% | 14 | |
| Nonparticipating Experience by Coverage | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2022 through December 31, 2022 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Employee | $156,092 | $398,747 | 255.5% | 6 | |
| Voluntary AD&D - Family | $264,223 | $195,208 | 73.9% | 3 | |
| Total Voluntary AD&D Coverages | $420,315 | $593,955 | 141.3% | 9 | |
| Nonparticipating Experience by Coverage | |||||
| Policy Number: 34295 | |||||
| For the Period January 1, 2023 through December 31, 2023 | |||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims | |
| Voluntary AD&D - Single | $770,285 | $651,115 | 84.5% | 6 | |
| Voluntary AD&D - Spouse & Child | $88,621 | $0 | 0.0% | 0 | |
| Voluntary AD&D - Spouse | $85,175 | $36,000 | 42.3% | 0 | |
| Voluntary AD&D - Child | $60,996 | $40,042 | 65.60% | 3 | |
| Voluntary AD&D - Family | $0 | -$54,365 | 0.00% | 4 | |
| Total Voluntary AD&D Coverages | $1,005,077 | $672,792 | 66.9% | 13 |
| Nonparticipating Experience by Coverage | ||||
| Policy Number: 34295 | ||||
| For the Period January 1, 2024 through December 31, 2024 | ||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims |
| Voluntary AD&D - Single | $1,233,984 | $180,489 | 14.6% | 3 |
| Voluntary AD&D - Spouse & Child | $146,868 | $0 | 0.0% | 0 |
| Voluntary AD&D - Spouse | $139,897 | $436,288 | 311.9% | 4 |
| Voluntary AD&D - Child | $102,838 | -$9,990 | -9.70% | 1 |
| Total Voluntary AD&D Coverages | $1,623,587 | $606,787 | 37.4% | 8 |
| Nonparticipating Experience by Coverage | ||||
| Policy Number: 34295 | ||||
| For the Period January 1, 2025 through December 31, 2025 | ||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims |
| Voluntary AD&D - Single | $1,490,863 | $60,274 | 4.0% | 2 |
| Voluntary AD&D - Spouse & Child | $175,321 | $0 | 0.0% | 0 |
| Voluntary AD&D - Spouse | $172,499 | -$300,000 | -173.9% | 0 |
| Voluntary AD&D - Child | $125,420 | $62,092 | 49.50% | 4 |
| Total Voluntary AD&D Coverages | $1,964,103 | -$177,634 | 6 | |
| Nonparticipating Experience by Coverage | ||||
| Policy Number: 34295 | ||||
| For the Period January 1, 2026 through June 30, 2026 | ||||
| Coverage | Earned Premium | Incurred Claims | Incurred Loss Ratio | Number of Paid Claims |
| Voluntary AD&D - Single | $847,053 | $1,215,917 | 143.50% | 7 |
| Voluntary AD&D - Spouse & Child | $98,546 | $29,754 | 30.20% | 0 |
| Voluntary AD&D - Spouse | $100,460 | $48,332 | 48.10% | 1 |
| Voluntary AD&D - Child | $71,663 | $21,637 | 30.20% | 0 |
| Total Voluntary AD&D Coverages | $1,117,722 | $1,315,640 | 117.70% | 8 |
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 .