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

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 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
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$6,415,134$6,334,16398.7%54137
Spouse and Child Life$342,444$338,47298.8%0112
Child Life$33,550$33,09798.6%011
Basic AD&D - Employee$632,049$610,35696.6%08
Basic AD&D - Dependent$230,910$226,94998.3%07
Total Participating Coverages$7,654,087$7,543,03798.5%54275
Number of Conversions58
Amount Converted$1,248,000
Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2019 through December 31, 2019
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$5,020,178$4,934,38398.30%0106
Spouse and Child Life106,568104,08697.70%032
Spouse Life148,940147,80399.20%048
Child Life32,06831,59498.50%010
Basic AD&D - Employee665,957645,57996.90%06
Basic AD&D - Dependent212,513208,64998.20%06
Total Participating Coverages$6,186,224$6,072,09498.2%0208
Number of Conversions28
Amount Converted$699,800
`
Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2020 through December 31, 2020
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$6,767,075.00$6,680,252.0098.7%12153
Spouse and Child Life$176,931.00$174,407.0098.6%058
Spouse Life$127,343.00$126,200.0099.1%042
Child Life$27,529.00$27,060.0098.3%09
Basic AD&D - Employee$309,879.00$289,259.0093.3%03
Basic AD&D - Dependent$67,295.00$64,067.0095.2%05
Total Participating Coverages$7,476,052.00$7,361,245.0098.5%12270
Number of Conversions22
Amount Converted$425,000.00
Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2021 through December 31, 2021
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$7,775,869$8,344,994107.3%23195
Spouse and Child Life260,527282,449108.4%094
Spouse Life129,479120,09892.8%040
Child Life38,43651,045132.8%017
Basic AD&D - Employee910,825904,81299.3%012
Basic AD&D - Dependent153,674162,278105.6%09
Total Participating Coverages$9,268,810$9,865,676106.4%23367
Number of Conversions19
Amount Converted$329,000
Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2022 through December 31, 2022
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$6,633,297$7,465,016112.5%36173
Spouse and Child Life263,933315,550119.6%0105
Spouse Life17,69232,976186.4%011
Child Life24,93024,09496.6%08
Basic AD&D - Employee632,114754,303119.3%010
Basic AD&D - Dependent153,488165,725108.0%06
Total Participating Coverages$7,725,454$8,757,664113.4%36313
Number of Conversions19
Amount Converted$470,000
Old Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2023 through December 31, 2023
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$0$1,717,4530%5132
Spouse and Child Life$0$45,1980%015
Spouse Life$0$18,0790%06
Child Life$0$6,0180%02
Basic AD&D - Employee$0$647,8580%07
Basic AD&D - Dependent$0$160,5730%02
Total Participating Coverages$0$2,595,1790%065
Number of Conversions3
Amount Converted$15,000
New Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2023 through December 31, 2023
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$6,876,126$6,818,34099.2%2143
Spouse and Child Life172,225163,65095.0%052
Spouse Life193,418192,62899.6%063
Child Life25,78625,45298.7%08
Basic AD&D - Employee601,037584,88897.3%05
Basic AD&D - Spouse & Child25,38124,36296.0%02
Basic AD&D - Spouse5,0904,12181.0%00
Basic AD&D - Child18,82918,10796.2%02
Total Participating Coverages$7,917,892$7,831,54898.9%2275
Number of Conversions12
Amount Converted$244,000
New Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2024 through December 31, 2024
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$8,002,888$7,929,95999.1%9128
Spouse and Child Life$22,473$9,51842.4%00
Spouse Life$24,033$29,691123.5%011
Child Life$4,367$4,594105.2%02
Basic AD&D - Employee$694,401$696,827100.3%010
Basic AD&D - Spouse & Child$10,044$16,958168.8%02
Basic AD&D - Spouse$132,271$128,15096.9%03
Basic AD&D - Child$17,762$3,44619.4%00
Total Participating Coverages$8,908,239$8,819,14399.0%9156
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
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life$8,691,009$8,610,00899.1%16135
Basic AD&D - Employee$463,378$453,87697.9%07
Total Participating Coverages$9,154,387$9,063,88499.0%16142
Number of Conversions15
Amount Converted$579,500
New Participating Experience by Coverage (Cash Basis)
Policy Number: 34294
For the Period January 1, 2026 through June 30, 2026
CoverageRemitted PremiumBilled ClaimsLoss RatioNumber of Approved Waiver ClaimsNumber of Paid Claims
Basic Life4459890420557294.30%2363
Basic AD&D - Employee13332611716687.90%010
Total Participating Coverages
Number of Conversions9
Amount Converted$211,750

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

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