Dearborn_Life_and_Supplmental_Life_Census.xls
XLS spreadsheet 27 KB Posted
- Attached to
- Employee Voluntary Benefit Products 2025-2026
- Solicitation number
- 2025-08
- Issued by
- Hidalgo County, Texas
About this file
The file "Dearborn_Life_and_Supplmental_Life_Census.xls" appears to be a census and premium breakdown for life insurance plans for the 2024-25 period. The document details Employer Paid Basic Life insurance and Voluntary Life insurance for employees and spouses across various age groups. The census provides a comprehensive breakdown of coverage amounts, rates, and monthly premiums for employee life insurance, with age-based categories ranging from 20-74 years old, and including a separate category for children.
The census reveals a total of 1,041 lives covered under the basic life plan, with monthly premiums of $5,163.25. Voluntary life insurance shows varying coverage levels and rates by age group, with the highest number of participants in the 30-44 age ranges. The voluntary life insurance includes options for employees, spouses, and children, with monthly premiums calculated based on age-specific rates and coverage amounts. The most significant voluntary life coverage is in the 40-44 age group, with 68 participants and $9,050,000 in total coverage, and monthly premiums of $1,592.80.
View the file
Other files
Show all 21
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
Output
| Dearborn Life and Supplmenral Life | |||||
| Plan Name | Grouping | Rate | Lives | Amount | Monthly Premium |
| Employer Paid Basic Life 2024-25 | 0.5 | 1041 | $ 10,326,500.00 | $ 5,163.25 | |
| Voluntary Life 2024-25 | 20-24 | 0.064 | 19 | $ 1,570,000.00 | $ 100.48 |
| Voluntary Life 2024-25 | 25-29 | 0.064 | 50 | $ 5,310,000.00 | $ 339.84 |
| Voluntary Life 2024-25 | 30-34 | 0.076 | 65 | $ 7,310,000.00 | $ 555.56 |
| Voluntary Life 2024-25 | 35-39 | 0.112 | 65 | $ 8,530,000.00 | $ 955.36 |
| Voluntary Life 2024-25 | 40-44 | 0.176 | 68 | $ 9,050,000.00 | $ 1,592.80 |
| Voluntary Life 2024-25 | 45-49 | 0.28 | 60 | $ 6,460,000.00 | $ 1,808.80 |
| Voluntary Life 2024-25 | 50-54 | 0.392 | 55 | $ 5,490,000.00 | $ 2,152.08 |
| Voluntary Life 2024-25 | 55-59 | 0.656 | 26 | $ 1,960,000.00 | $ 1,285.76 |
| Voluntary Life 2024-25 | 60-64 | 0.752 | 17 | $ 980,000.00 | $ 736.96 |
| Voluntary Life 2024-25 | 65-69 | 1.472 | 4 | $ 143,000.00 | $ 210.50 |
| Voluntary Life 2024-25 | 70-74 | 2.552 | 2 | $ 50,000.00 | $ 127.60 |
| Voluntary Life 2024-25 - Child | 0.128 | 146 | $ 1,460,000.00 | $ 186.88 | |
| Voluntary Life 2024-25 - Spouse | 20-24 | 0.064 | 1 | $ 25,000.00 | $ 1.60 |
| Voluntary Life 2024-25 - Spouse | 25-29 | 0.064 | 10 | $ 275,000.00 | $ 17.60 |
| Voluntary Life 2024-25 - Spouse | 30-34 | 0.076 | 13 | $ 640,000.00 | $ 48.64 |
| Voluntary Life 2024-25 - Spouse | 35-39 | 0.112 | 17 | $ 1,320,000.00 | $ 147.84 |
| Voluntary Life 2024-25 - Spouse | 40-44 | 0.176 | 12 | $ 580,000.00 | $ 102.08 |
| Voluntary Life 2024-25 - Spouse | 45-49 | 0.28 | 12 | $ 545,000.00 | $ 152.60 |
| Voluntary Life 2024-25 - Spouse | 50-54 | 0.392 | 20 | $ 1,260,000.00 | $ 493.92 |
| Voluntary Life 2024-25 - Spouse | 55-59 | 0.656 | 11 | $ 570,000.00 | $ 373.92 |
| Voluntary Life 2024-25 - Spouse | 60-64 | 0.752 | 8 | $ 262,250.00 | $ 197.22 |
| Voluntary Life 2024-25 - Spouse | 65-69 | 1.472 | 1 | $ 19,500.00 | $ 28.70 |
File details come from the government source that posted it. Updated .