RFP_31786-00193_Appendix_7.26.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
Life and Accidental Death and Dismemberment Insurance - UPDATED
Solicitation number
RFP 31786-00193
Issued by
Davidson County, Tennessee

About this file

This appendix contains enrollment data for the State of Tennessee Department of Finance and Administration's voluntary Accidental Death and Dismemberment (AD&D) and Voluntary Term Life (VTL) insurance programs covering state government and higher education employees from 2018 through the second quarter of 2026. The voluntary AD&D program shows significant growth, with total annual lives increasing from 26,055 in 2018 to 55,909 in 2023, reaching 65,719 by Q2 2026. Beginning in 2023, the enrollment structure shifted from Single and Family classifications to more granular Spouse & Child, Spouse, and Child categories. The voluntary term life program demonstrates declining enrollment trends across most categories through 2022, with total life coverages declining from 32,469 lives in 2018 to 24,654 in 2023 before increasing to 25,369 by Q2 2026. Employee voluntary term life coverage decreased from 15,453 lives in 2018 to 12,132 in Q2 2026, while ported coverage consistently declined across all categories throughout the period, with total ported coverages falling from 4,256 lives in 2018 to 2,554 in Q2 2026.

The enrollment data demonstrates substantial variation in dependent coverage utilization, with spouse voluntary insurance ranging from 5,566 to 7,581 lives and voluntary child riders spanning 8,275 to 11,236 lives throughout the nine-year period. The AD&D program's expansion reflects program restructuring rather than enrollment decline, as the combined total for Spouse & Child, Spouse, and Child categories in 2023 (24,858 lives) represents growth compared to the previous Family category enrollment of 17,031 lives in 2022. Total combined insurance across all lines of coverage for both programs ranged from approximately 36,725 lives in 2018 to 29,535 lives in 2022, with recovery to 27,923 lives by Q2 2026, indicating stabilization following the previous decline trajectory.

View the file

Other files

File Type Posted
RFP_31786-00193_Appendix_7.28.pdf PDF
RFP_31786-00193_Appendix_7.30.xlsx XLSX spreadsheet
RFP_31786-00193_Life_and_ADD_RFP_Release_2.docx DOCX document
RFP_31786-00193_Appendix_7.27.pdf PDF
RFP_31786-00193_Appendix_7.15.xlsx XLSX spreadsheet
RFP_31786-00193_Appendix_7.29.pdf PDF
RFP_31786-00193_Amendment_Two.docx DOCX document
RFP_31786-00193_Appendix_7.4.xlsx XLSX spreadsheet
RFP_31786-00193_Appendix_7.25.xlsx XLSX spreadsheet
RFP_31786-00193_Appendix_7.5.xlsx XLSX spreadsheet
RFP_31786-00193_Amendment_One_Schedule_Update.docx DOCX document
RFP%2031786-00193%20Appendix%207.6%20Issue%20and%20Attained%20Age%20with%20Coverage%20Values%20in%20Voluntary%20Term%20Life%20(as%20of%20June%202026).xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.22%20SOTN%20Voluntary%20ADD%20Certificate%20(Eff%2012-1-2025).pdf PDF
RFP%2031786-00193%20Appendix%207.7%20BA067%20Weekly%20Enrollment%20File%20Layout.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.3%20Claims,%20Conversion%20and%20Premium%20Experience%202018%20_June%202026%20Voluntary%20Term%20Life.xlsb XLSB spreadsheet
RFP%2031786-00193%20Appendix%207.1%20Claims_Conversion%20and%20Premium%20Experience%202018%20_June%202026%20Basic%20Term%20Life%20and%20Basic%20ADD.xlsb XLSB spreadsheet
RFP%2031786-00193%20Appendix%207.24%20Written%20Questions_Comments%20Template.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.16%20Basic%20Term%20Life%20Waiver%20of%20Premium%20Claims%20History%202018%20%E2%80%93%20June%202026.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.14%20Voluntary%20Term%20Life%20Enrollment%20History%202018%20-%20June%202026.pdf PDF
RFP%2031786-00193%20Appendix%207.2%20Claims%20Conversion%20and%20Premium%20Experience%202018_June%202026%20Voluntary%20ADandD.xlsb XLSB spreadsheet
DRAFT_RFP_31786-00193_Attachment_6.3_Cost_Proposal_Life_Insurance.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.21%20SOTN%20Basic%20Term%20Cert%20(Eff%2012-1-2025).pdf PDF
RFP%2031786-00193%20Appendix%207.23%20SOTN%20Voluntary%20Term%20Cert%20(Eff.%2012-1-2025).pdf PDF
31786-00193_Digital_Submission_Instructions.docx DOCX document
RFP%2031786-00193%20Appendix%207.4%20Enrollment%20and%20Coverage%20in%20Basic%20Term%20Life%20and%20Basic%20ADD%202018%20-%20June%202026.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.17%20Voluntary%20Term%20Life%20Waiver%20of%20Premium%20Claims%20History%202018%20%E2%80%93%20June%202026.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.12%20Basic%20Term%20Life%20and%20ADD%20Invoice%20Template.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.11%20BA246%20Annual%20Head%20of%20Contract%20Life%20Insurance%20Reduction%20File%20Layout.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.10%20Monthly%20Premiums%20Collected%20File%20Layout.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.8%20BA066%20Weekly%20Termination%20File%20Layout.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.15%20Voluntary%20Term%20Life%20Census%20-%20zac%20rvw.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.20%20Detail%20Claims%20Listing%20%E2%80%93%20Voluntary%20Term%20Life.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.13%20Life%20Insurance%20Rates%20and%20Program%20Changes.docx DOCX document
RFP%2031786-00193%20Appendix%207.5%20Basic%20Term%20Life%20Voluntary%20ADD%20Enrollment%20Census.xlsx XLSX spreadsheet
RFP_31786-00193_Life_and_ADandD_RFP.docx DOCX document
RFP%2031786-00193%20Appendix%207.18%20Detail%20Claims%20Listing%20_Basic%20Term%20Life%20Basic%20ADandD.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.19%20Detail%20Claims%20Listing%20_Voluntary_ADandD.xlsx XLSX spreadsheet
RFP%2031786-00193%20Appendix%207.9%20Monthly%20Premiums%20Due%20Deduction%20File%20Layout.xlsx XLSX spreadsheet
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

Text version

VADD

RFP 31786-00193 Appendix 7.26 Enrollment in Voluntary AD&D and Voluntary Term Life by Year
Annual Lives in Voluntary AD&D Program
Year201820192020202120222023202420252026 Q2
Single10,42211,20711,36411,45712,51230,85334,17735,18836,402
Family15,63316,06616,85617,09217,031N/AN/AN/AN/A
Spouse & ChildN/AN/AN/AN/AN/A7,7968,3558,3658,632
SpouseN/AN/AN/AN/AN/A5,4906,3626,6867,072
ChildN/AN/AN/AN/AN/A11,77012,88613,18013,613
Total26,05527,27328,22028,54929,54355,90961,78063,41965,719

VTL

Annual Lives in Voluntary Term Life Program

Year201820192020202120222023202420252026 Q2
Employee Voluntary Term Life15,45315,02014,39613,48812,59712,05812,81712,37312,132
Spouse Voluntary Term Life6,5016,2735,9765,5375,1014,8005,4525,2245,094
Voluntary Child Term Life Rider10,51510,1009,6138,9448,2697,7968,7128,3068,143
Total Life Coverages32,46931,39329,98527,96925,96724,65426,98125,90325,369
Employee Voluntary Ported2,4552,4642,4072,3382,1511,9121,7321,5771,554
Spouse Voluntary Ported1,0801,0701,021963872766680618599
Voluntary Child Rider Ported721673623573545479455413401
Total Ported Coverages4,2564,2074,0513,8743,5683,1572,8672,6082,554
Total Employee Voluntary Insurance17,90817,48416,80315,82614,74813,97014,54913,95013,686
Total Spouse Voluntary Insurance7,5817,3436,9976,5005,9735,5666,1325,8425,693
Total Voluntary Child Rider11,23610,77310,2369,5178,8148,2759,1678,7198,544
Total for All Lines of Coverage36,72535,60034,03631,84329,53527,81129,84828,51127,923

File details come from the government source that posted it. Updated .