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 17 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 file is an appendix to RFP 31786-00193 for the State of Tennessee's Optional Term Life Insurance program, containing summarized enrollment information for voluntary term life coverage as of July 6, 2026. The document presents detailed enrollment data organized by both issue age and attained age, broken down by payment method (Pay Direct and Payroll Deduct), insured type (Employee and Spouse), coverage volume, and participant count. The total program encompasses 19,445 participants with aggregate coverage of approximately $2.29 billion across all age groups and categories.

The enrollment data reveals significant variation in participation and coverage amounts across age demographics. The Payroll Deduct category represents the majority of enrollment with 17,275 participants and $2.14 billion in total coverage, while the Pay Direct category accounts for 2,170 participants and $147.5 million in coverage. Employee coverage substantially exceeds spouse coverage across all age groups in both payment methods. The highest concentration of Payroll Deduct participants occurs in the 45-54 attained age range, with approximately 5,870 participants and over $789 million in coverage. Peak coverage volumes in the Pay Direct category appear in the 55-69 attained age range, with employees aged 60-69 representing substantial portions of that volume.

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.26.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.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

Issue Age

RFP 31786-00193 Appendix 7.6 Issue and Attained Age with Coverage Values in Voluntary Term Life (as of June 2026)
State of Tennessee Optional Term Life
Summarized Enrollment Information by Issue Age
Data as of: 07/06/2026
Bill TypeIssue Age (Range)Insured TypeVolumeCount
Pay Direct20-24Employee200,0002
Pay Direct20-24Subtotal200,0002
Pay Direct25-29Employee1,687,50015
Pay Direct25-29Spouse175,0006
Pay Direct25-29Subtotal1,862,50021
Pay Direct30-34Employee10,492,50073
Pay Direct30-34Spouse495,00018
Pay Direct30-34Subtotal10,987,50091
Pay Direct35-39Employee12,600,000101
Pay Direct35-39Spouse1,105,00042
Pay Direct35-39Subtotal13,705,000143
Pay Direct40-44Employee16,017,500133
Pay Direct40-44Spouse1,055,00049
Pay Direct40-44Subtotal17,072,500182
Pay Direct45-49Employee17,939,500164
Pay Direct45-49Spouse2,020,00087
Pay Direct45-49Subtotal19,959,500251
Pay Direct50-54Employee28,049,500316
Pay Direct50-54Spouse3,385,000163
Pay Direct50-54Subtotal31,434,500479
Pay Direct55-59Employee27,776,500382
Pay Direct55-59Spouse2,892,500162
Pay Direct55-59Subtotal30,669,000544
Pay Direct60-64Employee16,525,750304
Pay Direct60-64Spouse822,50065
Pay Direct60-64Subtotal17,348,250369
Pay Direct65-69Employee4,168,95077
Pay Direct65-69Spouse140,00011
Pay Direct65-69Subtotal4,308,95088
Pay DirectSubtotalSubtotal147,547,7002,170
Payroll DeductUnder 20Employee15,0001
Payroll DeductUnder 20Subtotal15,0001
Payroll Deduct20-24Employee14,715,000126
Payroll Deduct20-24Spouse1,065,00042
Payroll Deduct20-24Subtotal15,780,000168
Payroll Deduct25-29Employee88,983,000529
Payroll Deduct25-29Spouse5,395,000220
Payroll Deduct25-29Subtotal94,378,000749
Payroll Deduct30-34Employee214,381,0001,168
Payroll Deduct30-34Spouse13,585,000553
Payroll Deduct30-34Subtotal227,966,0001,721
Payroll Deduct35-39Employee358,360,0001,811
Payroll Deduct35-39Spouse18,370,000751
Payroll Deduct35-39Subtotal376,730,0002,562
Payroll Deduct40-44Employee419,385,0002,244
Payroll Deduct40-44Spouse13,665,000600
Payroll Deduct40-44Subtotal433,050,0002,844
Payroll Deduct45-49Employee372,423,0002,243
Payroll Deduct45-49Spouse5,985,000350
Payroll Deduct45-49Subtotal378,408,0002,593
Payroll Deduct50-54Employee288,900,0001,920
Payroll Deduct50-54Spouse2,190,000178
Payroll Deduct50-54Subtotal291,090,0002,098
Payroll Deduct55-59Employee170,515,0001,243
Payroll Deduct55-59Spouse45,415,0001,993
Payroll Deduct55-59Subtotal215,930,0003,236
Payroll Deduct60-64Employee75,605,000609
Payroll Deduct60-64Spouse3,105,000276
Payroll Deduct60-64Subtotal78,710,000885
Payroll Deduct65-69Employee21,740,000200
Payroll Deduct65-69Spouse1,140,000112
Payroll Deduct65-69Subtotal22,880,000312
Payroll Deduct70-74Employee5,265,00057
Payroll Deduct70-74Spouse195,00025
Payroll Deduct70-74Subtotal5,460,00082
Payroll Deduct75-79Employee795,0009
Payroll Deduct75-79Spouse50,0007
Payroll Deduct75-79Subtotal845,00016
Payroll Deduct80 & AboveEmployee415,0004
Payroll Deduct80 & AboveSpouse20,0004
Payroll Deduct80 & AboveSubtotal435,0008
Payroll DeductSubtotalSubtotal2,141,677,00017,275
TotalTotalTotal2,289,224,70019,445

&12State of Tennessee Optional Term Life Summarized Enrollment Information by Attained Age Data as of: 07/06/2026 &"Calibri,Regular"&11Bill Type Pay &"Calibri,Regular"&11Attained Age (Range) Insured Type Volume &"Calibri,Regular"&11Count

Attained Age

State of Tennessee Optional Term Life
Summarized Enrollment Information by Attained Age
Data as of: 07/06/2026
Bill TypeAttained Age (Range)Insured TypeVolumeCount
Pay Direct25-29Employee102,5001
Pay Direct25-29Subtotal102,5001
Pay Direct30-34Employee707,5006
Pay Direct30-34Subtotal707,5006
Pay Direct35-39Employee1,725,00014
Pay Direct35-39Spouse60,0002
Pay Direct35-39Subtotal1,785,00016
Pay Direct40-44Employee8,895,00059
Pay Direct40-44Spouse520,00021
Pay Direct40-44Subtotal9,415,00080
Pay Direct45-49Employee12,692,50093
Pay Direct45-49Spouse865,00038
Pay Direct45-49Subtotal13,557,500131
Pay Direct50-54Employee17,367,500145
Pay Direct50-54Spouse1,205,00054
Pay Direct50-54Subtotal18,572,500199
Pay Direct55-59Employee22,502,000227
Pay Direct55-59Spouse2,047,50098
Pay Direct55-59Subtotal24,549,500325
Pay Direct60-64Employee33,385,500427
Pay Direct60-64Spouse3,602,500184
Pay Direct60-64Subtotal36,988,000611
Pay Direct65-69Employee38,080,200595
Pay Direct65-69Spouse3,790,000206
Pay Direct65-69Subtotal41,870,200801
Pay DirectSubtotalSubtotal147,547,7002,170
Payroll Deduct20-24Employee3,745,00028
Payroll Deduct20-24Spouse75,0004
Payroll Deduct20-24Subtotal3,820,00032
Payroll Deduct25-29Employee24,290,000146
Payroll Deduct25-29Spouse670,00040
Payroll Deduct25-29Subtotal24,960,000186
Payroll Deduct30-34Employee71,965,000355
Payroll Deduct30-34Spouse2,190,000135
Payroll Deduct30-34Subtotal74,155,000490
Payroll Deduct35-39Employee172,565,000816
Payroll Deduct35-39Spouse5,660,000274
Payroll Deduct35-39Subtotal178,225,0001,090
Payroll Deduct40-44Employee281,293,0001,327
Payroll Deduct40-44Spouse12,420,000561
Payroll Deduct40-44Subtotal293,713,0001,888
Payroll Deduct45-49Employee364,786,0001,914
Payroll Deduct45-49Spouse18,345,000790
Payroll Deduct45-49Subtotal383,131,0002,704
Payroll Deduct50-54Employee385,318,0002,276
Payroll Deduct50-54Spouse20,895,000890
Payroll Deduct50-54Subtotal406,213,0003,166
Payroll Deduct55-59Employee349,395,0002,308
Payroll Deduct55-59Spouse21,050,000930
Payroll Deduct55-59Subtotal370,445,0003,238
Payroll Deduct60-64Employee240,635,0001,802
Payroll Deduct60-64Spouse16,690,000780
Payroll Deduct60-64Subtotal257,325,0002,582
Payroll Deduct65-69Employee95,365,000823
Payroll Deduct65-69Spouse8,275,000449
Payroll Deduct65-69Subtotal103,640,0001,272
Payroll Deduct70-74Employee32,570,000272
Payroll Deduct70-74Spouse2,680,000170
Payroll Deduct70-74Subtotal35,250,000442
Payroll Deduct75-79Employee7,965,00078
Payroll Deduct75-79Spouse935,00067
Payroll Deduct75-79Subtotal8,900,000145
Payroll Deduct80 & AboveEmployee1,605,00019
Payroll Deduct80 & AboveSpouse295,00021
Payroll Deduct80 & AboveSubtotal1,900,00040
Payroll DeductSubtotalSubtotal2,141,677,00017,275
TotalTotalTotal2,289,224,70019,445

&12State of Tennessee Optional Term Life Summarized Enrollment Information by Attained Age Data as of: 07/06/2026 &"Calibri,Regular"&11Bill Type Pay &"Calibri,Regular"&11Attained Age (Range) Insured Type Volume &"Calibri,Regular"&11Count

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