RFP_31786-00193_Appendix_7.25.xlsx

XLSX spreadsheet 15 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 to RFP 31786-00193 from the State of Tennessee Department of Finance and Administration details the guaranteed monthly reserve and administrative fees, conversion charges, and voluntary term life ported premium rates for group life and accidental death and dismemberment insurance services. The RFP seeks proposals for fully-insured life and AD&D insurance covering eligible employees of State Government and State Higher Education agencies, with contract performance running from January 1, 2028 through December 31, 2032. A pre-response conference is scheduled for August 31, 2026, with proposals due November 13, 2026 at 2:00 p.m. Central Time. The Notice of Intent to Award is expected January 28, 2027.

The pricing structure establishes a flat monthly charge of $0.434 per employee for contract administration, reserve, and conversion fees. Guaranteed monthly reserve percentages are fixed at 4.70% of annualized premium for all basic term life coverage lines and 4.20% for all basic AD&D coverage lines across all contract years (2023-2027). The administrative charge for basic term and basic AD&D is guaranteed at $0.102 per employee per month through the contract period, while basic term life conversion charges are fixed at $227.00 per $1,000 of conversion life insurance issued. Voluntary term life ported premium rates per $1,000 of coverage are guaranteed throughout the contract period with age-based brackets ranging from $0.06 monthly for employees under 35 to $1.32 monthly for employees age 65 and over. The incumbent carrier is Minnesota Life Insurance Company (Securian Financial). As of June 2026, the state covers approximately 68,000-72,000 basic term life and AD&D employees with total coverage volumes of $10.2-$11.2 billion monthly, along with voluntary term life enrollment of 12,132 employee lives covering $2.03 billion and spouse/child rider coverage of approximately $184.5 million combined.

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

C.3.c.ii Reserves

RFP 31786-00193 Appendix 7.25 Current Contract Admin, Reserve and Conversion Fees
$.434 per employee per month to establish the below reserves:
GUARANTEED MONTHLY RESERVE PERCENTAGES - PERCENT OF ANNUALIZED PREMIUM PER LINE OF COVERAGE1/1/2023-12/31/20231/1/2024-12/31/20241/1/2025-12/31/20251/1/2026-12/31/20261/1/2027-12/31/2027
B. Employee Basic Term Life4.70%4.70%4.70%4.70%4.70%
C. Dependent Basic Term Life - Spouse4.70%4.70%4.70%4.70%4.70%
D. Dependent Basic Term Life - Spouse & Child(ren)4.70%4.70%4.70%4.70%4.70%
E. Dependent Basic Term Life - Child(ren)4.70%4.70%4.70%4.70%4.70%
F. Employee Basic AD&D4.20%4.20%4.20%4.20%4.20%
G. Dependent Basic AD&D - Spouse4.20%4.20%4.20%4.20%4.20%
H. Dependent Basic AD&D - Spouse & Child(ren)4.20%4.20%4.20%4.20%4.20%
I. Dependent Basic AD&D - Child(ren)4.20%4.20%4.20%4.20%4.20%

C.3.c.v Administrative Charge

GUARANTEED PER EMPLOYEE PER MONTH RATES FOR ADMINISTRATIVE CHARGE
Basic Term & Basic AD&D1/1/2023-12/31/20231/1/2024-12/31/20241/1/2025-12/31/20251/1/2026-12/31/20261/1/2027-12/31/2027
A. Basic Term Life and Basic AD&D Per Employee per Month Administrative Charge$0.102$0.102$0.102$0.102$0.102
Charge against the plan for program administration

C.3.c.v Conversion Charge

Basic Term & Basic AD&D 1/1/2023-12/31/2023 1/1/2024-12/31/2024 1/1/2025-12/31/2025 1/1/2026-12/31/2026 1/1/2027-12/31/2027

A. Basic Term Life Conversion Charge$227.00$227.00$227.00$227.00$227.00
Charge against the plan for each $1,000 of Conversion Life Insurance issued

C.3.c.xi. VTL Ported Prem Rates

GUARANTEED MONTHLY VOLUNTARY TERM PORTED EMPLOYEE AND SPOUSE PREMIUM RATES PER $1,000 OF COVERAGE
Attained Age Brackets1/1/2023-1/1/2024-1/1/2025-1/1/2026-1/1/2027-
12/31/2312/31/2412/31/2512/31/2612/31/27
Under 20$0.06$0.06$0.06$0.06$0.06
20-24$0.06$0.06$0.06$0.06$0.06
25-29$0.06$0.06$0.06$0.06$0.06
30-34$0.06$0.06$0.06$0.06$0.06
35-39$0.08$0.08$0.08$0.08$0.08
40-44$0.12$0.12$0.12$0.12$0.12
45-49$0.19$0.19$0.19$0.19$0.19
50-54$0.33$0.33$0.33$0.33$0.33
55-59$0.51$0.51$0.51$0.51$0.51
60-64$0.80$0.80$0.80$0.80$0.80
65-69$1.32$1.32$1.32$1.32$1.32
70-74$1.32$1.32$1.32$1.32$1.32
75-79$1.32$1.32$1.32$1.32$1.32
80 and over$1.32$1.32$1.32$1.32$1.32

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