RFP_31786-00193_Appendix_7.30.xlsx
XLSX spreadsheet 533 KB Posted
- Solicitation number
- RFP 31786-00193
- Issued by
- Davidson County, Tennessee
About this file
This is an Appendix pricing file for RFP 31786-00193 issued by the State of Tennessee Department of Finance and Administration, Division of Benefits Administration for life and accidental death and dismemberment (AD&D) insurance services. The RFP requests proposals for three integrated, fully-insured products: voluntary term life insurance (employee-paid), voluntary AD&D insurance (employee-paid), and basic term life with basic AD&D insurance (employer-paid through minimum premium arrangement) to serve eligible employees of State Government and State Higher Education agencies and their dependents. The contract encompasses a five-year period from January 1, 2028 through December 31, 2032, with a claims run-out period extending through June 30, 2034. Proposals were due November 13, 2026 at 2:00 p.m. Central Time, with a pre-response conference scheduled for August 31, 2026 and a Notice of Intent to Award expected January 28, 2027.
The appendix contains pricing parameters and historical enrollment data. As of June 2026, basic term life and basic AD&D enrollment encompassed approximately 68,000 to 72,000 employees with total coverage volumes ranging from $10.2 billion to $11.2 billion monthly; voluntary term life covered 12,132 employee lives ($2.03 billion), 5,094 spouse lives ($110.1 million), and 8,143 child rider lives ($74.4 million). Respondents must submit guaranteed monthly premium rates for each coverage type and contract year, with ported coverage premiums constrained not to exceed active employee rates by more than 20 percent for any age bracket. Voluntary term life active employee rates must comply with IRS Section 79 straddle rule requirements. The incumbent carrier is Minnesota Life Insurance Company (Securian Financial) under policies 34175 (Voluntary Term Life), 34294 (Basic Term Life & AD & D), and 34295 (Voluntary AD & D). All current state employees will be automatically transitioned to the new contractor on the effective date with guaranteed issue and credit toward limitations based on prior enrollment length.
View the file
Other files
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
Jan 2019 - December 2023
| RFP 31786-00193 Appendix 7.30 Basic Term Life Basic AD&D Monthly Invoice 2019 through June 2026 | ||||||||||
| State Of Tennessee Contract Number: 56027 | 12/1/23 | |||||||||
| Current | Contract | Annualized | IBNR Reserve | |||||||
| Contract Premium | Volume (000) or lives | Adjustment | Premium | Contract Premium | Premium Factor | IBNR Reserve | ||||
| Employee Basic Term Life | $ 0.160 | per $1000 | 0 | 0 | 0.00 | 0.00 | 4.9% | 0.00 | ||
| Dep Life | Spouse | $ 0.584 | per unit | 0 | 0 | 0.00 | 0.00 | 4.7% | 0.00 | |
| Spouse & Child | $ 0.887 | per unit | 0 | 0 | 0.00 | 0.00 | 4.7% | 0.00 | ||
| Child | $ 0.303 | per unit | 0 | 0 | 0.00 | 0.00 | 4.7% | 0.00 | ||
| Employee Basic AD&D | $ 0.019 | per $1000 | 0 | 0 | 0.00 | 0.00 | 4.2% | 0.00 | ||
| Dep Basic AD&D | $ 0.013 | per $1000 | 0 | 0 | 0.00 | 0.00 | 4.2% | 0.00 | ||
| 0.00 | 0.00 | 0.00 | ||||||||
| Minimum Premium | 2019 | 2020 | 2021 | 2022 | ||||||
| Retention | per employee | $0.135 | $0.135 | $0.135 | $0.135 | |||||
| IBNR | per employee | $0.434 | ||||||||
| $0.569 |
| (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J) | (K) | (L) | (M) | (N) | (O) | (P) | |
| B+C | E+F+G+H+I+J | MIN(K,D) | D-K | J-K | ||||||||||||
| Prior | Tax & | Prior | Minimum | |||||||||||||
| Number of | Contract | Surplus | Group Max | Change In | Conversion | Interest | Deficit | Premium | Monthly | Payment | Payment | Current | Current | IBNR | ||
| Month | Employees | Premium | Balance | Liability | Claims | Waiver Reserve | Charge | Reconciliation | Balance | Charge | Cost | Due | Received | Surplus | Deficit | Balance |
| Jan-19 | 70,352 | $ 648,625.46 | $ - 0 | $ 648,625.46 | $ 68,037.52 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 40,030.29 | $ 108,067.81 | $ 108,067.81 | $ 108,067.81 | $ 540,557.65 | $ - 0 | $ 30,532.77 | |
| Feb-19 | 70,259 | $ 647,714.84 | $ 540,557.65 | $ 1,188,272.49 | $ 551,450.61 | $ - 0 | $ 9,091.35 | $ - 0 | $ - 0 | $ 39,977.37 | $ 600,519.33 | $ 600,519.33 | $ 600,519.33 | $ 587,753.16 | $ - 0 | $ 61,025.17 | |
| Mar-19 | 70,473 | $ 649,282.82 | $ 587,753.16 | $ 1,237,035.98 | $ 417,835.81 | $ - 0 | $ 4,540.00 | $ - 0 | $ - 0 | $ 40,099.14 | $ 462,474.95 | $ 462,474.95 | $ 462,474.95 | $ 774,561.03 | $ - 0 | $ 91,610.46 | |
| Apr-19 | 70,459 | $ 648,931.60 | $ 774,561.03 | $ 1,423,492.63 | $ 545,670.56 | $ - 0 | $ 21,394.75 | $ - 0 | $ - 0 | $ 40,091.17 | $ 607,156.48 | $ 607,156.48 | $ 607,156.48 | $ 816,336.15 | $ - 0 | $ 122,189.66 | |
| May-19 | 70,426 | $ 648,413.08 | $ 816,336.15 | $ 1,464,749.23 | $ 462,599.52 | $ - 0 | $ 18,727.50 | $ - 0 | $ - 0 | $ 40,072.39 | $ 521,399.41 | $ 521,399.41 | $ 521,399.41 | $ 943,349.82 | $ - 0 | $ 152,754.55 | |
| Jun-19 | 70,358 | $ 647,851.15 | $ 943,349.82 | $ 1,591,200.97 | $ 328,873.12 | $ - 0 | $ 4,540.00 | $ - 0 | $ - 0 | $ 40,033.70 | $ 373,446.82 | $ 373,446.82 | $ 373,446.82 | $ 1,217,754.15 | $ - 0 | $ 183,289.92 | |
| Jul-19 | 70,018 | $ 644,944.03 | $ 1,217,754.15 | $ 1,862,698.18 | $ 796,497.58 | $ - 0 | $ 11,350.00 | $ - 0 | $ - 0 | $ 39,840.24 | $ 847,687.82 | $ 847,687.82 | $ 847,687.82 | $ 1,015,010.36 | $ - 0 | $ 213,677.73 | |
| Aug-19 | 70,139 | $ 645,483.57 | $ 1,015,010.36 | $ 1,660,493.93 | $ 520,558.53 | $ - 0 | $ 5,675.00 | $ - 0 | $ - 0 | $ 39,909.09 | $ 566,142.62 | $ 566,142.62 | $ 566,142.62 | $ 1,094,351.31 | $ - 0 | $ 244,118.06 | |
| Sep-19 | 70,366 | $ 647,333.59 | $ 1,094,351.31 | $ 1,741,684.90 | $ 474,964.09 | $ - 0 | $ 21,565.00 | $ - 0 | $ - 0 | $ 40,038.25 | $ 536,567.34 | $ 536,567.34 | $ 536,567.34 | $ 1,205,117.56 | $ - 0 | $ 274,656.90 | |
| Oct-19 | 70,658 | $ 654,461.36 | $ 1,205,117.56 | $ 1,859,578.92 | $ 661,163.70 | $ - 0 | $ 11,350.00 | $ - 0 | $ - 0 | $ 40,204.40 | $ 712,718.10 | $ 712,718.10 | $ 712,718.10 | $ 1,146,860.82 | $ - 0 | $ 305,322.47 | |
| Nov-19 | 70,922 | $ 656,427.23 | $ 1,146,860.82 | $ 1,803,288.05 | $ 307,925.98 | $ - 0 | $ 31,326.00 | $ - 0 | $ - 0 | $ 40,354.62 | $ 379,606.60 | $ 379,606.60 | $ 379,606.60 | $ 1,423,681.45 | $ - 0 | $ 336,102.62 | |
| Dec-19 | 70,980 | $ 656,586.77 | $ 1,423,681.45 | $ 2,080,268.22 | $ 410,753.95 | $ - 0 | $ 19,295.00 | $ - 0 | $ - 0 | $ 40,387.62 | $ 470,436.57 | $ 470,436.57 | $ 470,436.57 | $ 1,609,831.65 | $ - 0 | $ 366,907.94 | |
| Jan-20 | 71,052 | $ 660,373.40 | $ 1,609,831.65 | $ 2,270,205.05 | $ 620,114.94 | $ - 0 | $ (6,810.00) | $ - 0 | $ - 0 | $ 18,627.10 | $ 631,932.04 | $ 631,932.04 | $ 631,932.04 | $ 1,638,273.01 | $ - 0 | $ 375,943.02 | |
| Feb-20 | 70,970 | $ 303,549.10 | * | $ 1,638,273.01 | $ 1,941,822.11 | $ 428,538.95 | $ - 0 | $ 2,270.00 | $ 84,341.00 | $ - 0 | $ 9,047.49 | $ 524,197.44 | $ 524,197.44 | $ 524,197.44 | $ 1,417,624.67 | $ - 0 | $ 375,409.56 |
| Mar-20 | 71,065 | $ 660,103.35 | $ 1,417,624.67 | $ 2,077,728.02 | $ 771,225.60 | $ - 0 | $ 2,270.00 | $ - 0 | $ - 0 | $ 9,977.14 | $ 783,472.74 | $ 783,472.75 | $ 783,472.75 | $ 1,294,255.27 | $ - 0 | $ 375,792.93 | |
| Apr-20 | 71,049 | $ 659,825.85 | $ 1,294,255.27 | $ 1,954,081.12 | $ 468,739.20 | $ - 0 | $ 13,052.50 | $ - 0 | $ - 0 | $ 9,434.53 | $ 491,226.24 | $ 491,226.24 | $ 491,226.24 | $ 1,462,854.88 | $ - 0 | $ 375,635.85 | |
| May-20 | 71,271 | $ 661,653.37 | $ 1,462,854.88 | $ 2,124,508.25 | $ 443,335.76 | $ - 0 | $ 6,810.00 | $ - 0 | $ - 0 | $ 10,663.63 | $ 460,809.39 | $ 460,809.39 | $ 460,809.39 | $ 1,663,698.86 | $ - 0 | $ 376,677.89 | |
| Jun-20 | 71,177 | $ 660,660.15 | $ 1,663,698.86 | $ 2,324,359.01 | $ 369,373.76 | $ 16,200.00 | $ 13,620.00 | $ - 0 | $ - 0 | $ 9,043.52 | $ 408,237.28 | $ 408,237.28 | $ 408,237.28 | $ 1,916,121.73 | $ - 0 | $ 376,112.51 | |
| Jul-20 | 71,219 | $ 653,111.93 | $ 1,916,121.73 | $ 2,569,233.66 | $ 489,931.88 | $ 20,000.00 | $ 13,620.00 | $ - 0 | $ - 0 | $ 5,834.83 | $ 529,386.71 | $ 529,386.71 | $ 529,386.71 | $ 2,039,846.95 | $ - 0 | $ 372,332.77 | |
| Aug-20 | 70,943 | $ 651,136.70 | $ 2,039,846.95 | $ 2,690,983.65 | $ 481,804.90 | $ 19,000.00 | $ - 0 | $ - 0 | $ - 0 | $ 8,446.68 | $ 509,251.59 | $ 509,251.59 | $ 509,251.59 | $ 2,181,732.06 | $ - 0 | $ 371,202.15 | |
| Sep-20 | 70,740 | $ 649,835.79 | $ 2,181,732.06 | $ 2,831,567.85 | $ 679,371.53 | $ 40,000.00 | $ 3,405.00 | $ - 0 | $ - 0 | $ 8,808.24 | $ 731,584.77 | $ 731,584.77 | $ 731,584.77 | $ 2,099,983.08 | $ - 0 | $ 370,460.49 | |
| Oct-20 | 70,443 | $ 648,357.87 | $ 2,099,983.08 | $ 2,748,340.95 | $ 824,598.00 | $ 60,000.00 | $ 10,215.00 | $ - 0 | $ - 0 | $ 8,665.38 | $ 903,478.38 | $ 903,478.38 | $ 903,478.38 | $ 1,844,862.57 | $ - 0 | $ 369,616.06 | |
| Nov-20 | 70,261 | $ 646,977.35 | $ 1,844,862.57 | $ 2,491,839.92 | $ 522,014.00 | $ 34,800.00 | $ 3,405.00 | $ - 0 | $ - 0 | $ 8,695.86 | $ 568,914.87 | $ 568,914.87 | $ 568,914.87 | $ 1,922,925.05 | $ - 0 | $ 368,826.69 | |
| Dec-20 | 70,240 | $ 648,511.55 | $ 1,922,925.05 | $ 2,571,436.60 | $ 940,929.36 | $ 32,000.00 | $ 34,617.50 | $ - 0 | $ - 0 | $ 10,355.61 | $ 1,017,902.47 | $ 1,017,902.47 | $ 1,017,902.47 | $ 1,553,534.13 | $ - 0 | $ 369,699.90 | |
| Jan-21 | 69,783 | $ 644,611.46 | $ 1,553,534.13 | $ 2,198,145.59 | $ 914,212.08 | $ 32,400.00 | $ 9,080.00 | $ - 0 | $ - 0 | $ 7,193.10 | $ 962,885.18 | $ 962,885.18 | $ 962,885.18 | $ 1,235,260.41 | $ - 0 | $ 367,472.29 | |
| Feb-21 | 69,833 | $ 644,880.65 | $ 1,235,260.41 | $ 1,880,141.06 | $ 645,391.79 | $ 20,000.00 | $ 18,727.50 | $ 118,069.00 | $ - 0 | $ 9,583.26 | $ 811,771.55 | $ 811,771.56 | $ 811,771.56 | $ 1,068,369.50 | $ - 0 | $ 367,628.10 | |
| Mar-21 | 69,654 | $ 643,095.29 | $ 1,068,369.50 | $ 1,711,464.79 | $ 1,046,369.51 | $ 19,000.00 | $ 1,702.50 | $ - 0 | $ - 0 | $ 8,385.45 | $ 1,075,457.46 | $ 1,075,457.46 | $ 1,075,457.46 | $ 636,007.33 | $ - 0 | $ 366,610.26 | |
| Apr-21 | 69,597 | $ 650,143.40 | $ 636,007.33 | $ 1,286,150.73 | $ 879,408.35 | $ - 0 | $ 3,405.00 | $ - 0 | $ - 0 | $ 12,898.45 | $ 895,711.80 | $ 895,711.80 | $ 895,711.80 | $ 390,438.93 | $ - 0 | $ 370,113.11 | |
| May-21 | 70,658 | $ 728,536.02 | ** | $ 390,438.93 | $ 1,118,974.95 | $ 533,289.65 | $ 8,000.00 | $ 7,945.00 | $ - 0 | $ - 0 | $ 12,875.24 | $ 562,109.89 | $ 562,109.89 | $ 562,109.89 | $ 556,865.06 | $ - 0 | $ 370,113.11 |
| Jun-21 | 69,396 | $ 648,286.37 | $ 556,865.06 | $ 1,205,151.43 | $ 850,214.42 | $ 19,000.00 | $ 4,540.00 | $ - 0 | $ - 0 | $ 8,308.82 | $ 882,063.24 | $ 882,063.24 | $ 882,063.24 | $ 323,088.19 | $ - 0 | $ 369,053.47 | |
| Jul-21 | 69,171 | $ 646,778.77 | *** | $ 323,088.19 | $ 969,866.96 | $ 687,221.33 | $ 37,600.00 | $ (10,782.50) | $ - 0 | $ - 0 | $ 8,687.08 | $ 722,725.91 | $ 722,725.91 | $ 722,725.91 | $ 247,141.05 | $ - 0 | $ 368,402.46 |
| Aug-21 | 69,038 | $ 645,479.89 | $ 247,141.05 | $ 892,620.94 | $ 767,873.79 | $ 20,000.00 | $ 10,215.00 | $ - 0 | $ - 0 | $ 8,370.23 | $ 806,459.02 | $ 806,459.02 | $ 806,459.02 | $ 86,161.92 | $ - 0 | $ 367,452.56 | |
| Sep-21 | 68,849 | $ 643,684.72 | $ 86,161.92 | $ 729,846.64 | $ 694,566.56 | $ - 0 | $ 10,555.50 | $ - 0 | $ - 0 | $ 8,273.87 | $ 713,395.94 | $ 713,395.94 | $ 713,395.94 | $ 16,450.70 | $ - 0 | $ 366,431.82 | |
| Oct-21 | 69,108 | $ 647,486.28 | $ 16,450.70 | $ 663,936.98 | $ 972,462.78 | $ 14,800.00 | $ 14,187.50 | $ - 0 | $ - 0 | $ 11,501.87 | $ 1,012,952.15 | $ 663,936.98 | $ 663,936.98 | $ - 0 | $ (349,015.17) | $ 368,604.11 | |
| Nov-21 | 68,894 | $ 645,629.37 | $ - 0 | $ 645,629.37 | $ 1,009,676.39 | $ - 0 | $ 4,540.00 | $ - 0 | $ 349,015.17 | $ 8,241.65 | $ 1,371,473.21 | $ 645,629.37 | $ 645,629.37 | $ - 0 | $ (725,843.84) | $ 367,545.07 | |
| Dec-21 | 68,849 | $ 644,732.76 | $ - 0 | $ 644,732.76 | $ 602,170.52 | $ 20,000.00 | $ 567.50 | $ - 0 | $ 725,843.84 | $ 8,785.60 | $ 1,357,367.45 | $ 644,732.76 | $ 644,732.76 | $ - 0 | $ (712,634.69) | $ 367,036.05 | |
| Jan-22 | 68,756 | $ 646,120.18 | $ - 0 | $ 646,120.18 | $ 613,410.11 | $ (17,600.00) | $ 26,105.00 | $ - 0 | $ 712,634.69 | $ 10,064.61 | $ 1,344,614.41 | $ 646,120.18 | $ 646,120.18 | $ - 0 | $ (698,494.23) | $ 367,818.60 | |
| Feb-22 | 68,490 | $ 643,756.89 | $ - 0 | $ 643,756.89 | $ 888,522.89 | $ 20,000.00 | $ - 0 | $ 180,499.00 | $ 698,494.23 | $ 7,902.44 | $ 1,795,418.56 | $ 643,756.89 | $ 643,756.89 | $ - 0 | $ (1,151,661.67) | $ 366,474.89 | |
| Mar-22 | 68,712 | $ 645,199.81 | $ - 0 | $ 645,199.81 | $ 1,384,505.13 | $ (20,000.00) | $ 6,810.00 | $ - 0 | $ 1,151,661.67 | $ 10,104.80 | $ 2,533,081.60 | $ 645,199.81 | $ 645,199.81 | $ - 0 | $ (1,887,881.79) | $ 367,303.57 | |
| Apr-22 | 68,531 | $ 643,442.51 | $ - 0 | $ 643,442.51 | $ 915,257.38 | $ 40,000.00 | $ 9,080.00 | $ - 0 | $ 1,887,881.79 | $ 8,251.90 | $ 2,860,471.07 | $ 643,442.51 | $ 643,442.51 | $ - 0 | $ (2,217,028.56) | $ 366,303.78 | |
| May-22 | 68,417 | $ 642,297.32 | $ - 0 | $ 642,297.32 | $ 455,300.91 | $ 40,000.00 | $ 2,270.00 | $ - 0 | $ 2,217,028.56 | $ 8,583.64 | $ 2,723,183.11 | $ 642,297.32 | $ 642,297.32 | $ - 0 | $ (2,080,885.79) | $ 365,651.13 | |
| Jun-22 | 68,329 | $ 641,402.71 | $ - 0 | $ 641,402.71 | $ 684,304.08 | $ 76,000.00 | $ 15,322.50 | $ - 0 | $ 2,080,885.79 | $ 8,715.44 | $ 2,865,227.82 | $ 641,402.71 | $ 641,402.71 | $ - 0 | $ (2,223,825.11) | $ 365,142.16 | |
| Jul-22 | 68,217 | $ 640,294.93 | $ - 0 | $ 640,294.93 | $ 524,925.38 | $ 20,200.00 | $ 4,540.00 | $ - 0 | $ 2,223,825.11 | $ 8,580.17 | $ 2,782,070.65 | $ 640,294.93 | $ 640,294.93 | $ - 0 | $ (2,141,775.72) | $ 364,513.03 | |
| Aug-22 | 67,896 | $ 637,279.75 | $ - 0 | $ 637,279.75 | $ 713,965.40 | $ 39,000.00 | $ (4,540.00) | $ - 0 | $ 2,141,775.72 | $ 7,451.72 | $ 2,897,652.84 | $ 637,279.75 | $ 637,279.75 | $ - 0 | $ (2,260,373.09) | $ 362,798.79 | |
| Sep-22 | 68,141 | $ 639,304.57 | $ - 0 | $ 639,304.57 | $ 378,328.20 | $ 8,000.00 | $ 13,620.00 | $ - 0 | $ 2,260,373.09 | $ 10,356.46 | $ 2,670,677.76 | $ 639,304.57 | $ 639,304.57 | $ - 0 | $ (2,031,373.19) | $ 363,956.22 | |
| Oct-22 | 68,530 | $ 647,446.17 | $ - 0 | $ 647,446.17 | $ 930,853.21 | $ 32,400.00 | $ 18,160.00 | $ - 0 | $ 2,031,373.19 | $ 13,899.76 | $ 3,026,686.16 | $ 647,446.17 | $ 647,446.17 | $ - 0 | $ (2,379,239.99) | $ 368,604.43 | |
| Nov-22 | 68,692 | $ 648,239.26 | $ - 0 | $ 648,239.26 | $ 453,817.87 | $ 8,000.00 | $ 3,405.00 | $ - 0 | $ 2,379,239.99 | $ 9,728.19 | $ 2,854,191.05 | $ 648,239.26 | $ 648,239.26 | $ - 0 | $ (2,205,951.79) | $ 369,059.20 | |
| Dec-22 | 69,058 | $ 650,669.83 | $ - 0 | $ 650,669.83 | $ 473,174.66 | $ (14,800.00) | $ 11,917.50 | $ - 0 | $ 2,205,951.79 | $ 10,708.83 | $ 2,686,952.78 | $ 650,669.83 | $ 650,669.83 | $ - 0 | $ (2,036,282.95) | $ 370,445.20 | |
| Jan-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 421,134.58 | $ 60,000.00 | $ 18,160.00 | $ - 0 | $ 2,036,282.95 | $ - 0 | $ 2,535,577.53 | $ - 0 | $ - 0 | $ - 0 | $ (2,535,577.53) | $ 370,445.20 | |
| Feb-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 769,263.78 | $ 56,600.00 | $ (18,727.50) | $ 136,261.00 | $ 2,535,577.53 | $ - 0 | $ 3,478,974.81 | $ - 0 | $ - 0 | $ - 0 | $ (3,478,974.81) | $ 370,445.20 | |
| Mar-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 273,547.88 | $ - 0 | $ 3,972.50 | $ - 0 | $ 3,478,974.81 | $ - 0 | $ 3,756,495.19 | $ - 0 | $ - 0 | $ - 0 | $ (3,756,495.19) | $ 370,445.20 | |
| Apr-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 215,426.41 | $ 40,000.00 | $ - 0 | $ - 0 | $ 3,756,495.19 | $ - 0 | $ 4,011,921.60 | $ - 0 | $ - 0 | $ - 0 | $ (4,011,921.60) | $ 370,445.20 | |
| May-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 169,908.81 | $ 20,000.00 | $ - 0 | $ - 0 | $ 4,011,921.60 | $ - 0 | $ 4,201,830.41 | $ - 0 | $ - 0 | $ - 0 | $ (4,201,830.41) | $ 370,445.20 | |
| Jun-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 252,558.21 | $ 20,000.00 | $ - 0 | $ - 0 | $ 4,201,830.41 | $ - 0 | $ 4,474,388.62 | $ - 0 | $ - 0 | $ - 0 | $ (4,474,388.62) | $ 370,445.20 | |
| Jul-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 67,386.30 | $ 60,000.00 | $ - 0 | $ - 0 | $ 4,474,388.62 | $ - 0 | $ 4,601,774.92 | $ - 0 | $ - 0 | $ - 0 | $ (4,601,774.92) | $ 370,445.20 | |
| Aug-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 50,342.46 | $ 36,200.00 | $ - 0 | $ - 0 | $ 4,601,774.92 | $ - 0 | $ 4,688,317.38 | $ - 0 | $ - 0 | $ - 0 | $ (4,688,317.38) | $ 370,445.20 | |
| Sep-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 50,852.05 | $ 20,000.00 | $ - 0 | $ - 0 | $ 4,688,317.38 | $ - 0 | $ 4,759,169.43 | $ - 0 | $ - 0 | $ - 0 | $ (4,759,169.43) | $ 370,445.20 | |
| Oct-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ 15,153.29 | $ (8,000.00) | $ - 0 | $ - 0 | $ 4,759,169.43 | $ - 0 | $ 4,766,322.72 | $ - 0 | $ - 0 | $ - 0 | $ (4,766,322.72) | $ 370,445.20 | |
| Nov-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 39,000.00 | $ - 0 | $ - 0 | $ 4,766,322.72 | $ - 0 | $ 4,805,322.72 | $ - 0 | $ - 0 | $ - 0 | $ (4,805,322.72) | $ 370,445.20 | |
| Dec-23 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ (37,600.00) | $ - 0 | $ - 0 | $ 4,805,322.72 | $ - 0 | $ 4,767,722.72 | $ - 0 | $ - 0 | $ - 0 | $ (4,767,722.72) | $ 370,445.20 | |
| $ 30,858,950.82 | $ 30,858,950.82 |
December 2023 Invoice $ - 0
| * Includes surplus premium carry-forward provision adjustment of ($355,885) included in the 2019 policy year report |
| ** May 2021 bill includes adjustments due to reported lives/volumes changes between Oct 2020 - April 2021 |
| *** July 2021 bill includes adjustments due to reported lives/volumes changes for June 2021 bill |
Jan 2023 - June 2026
| State Of Tennessee Contract Number: 73546 | 6/1/26 | |||||||||
| Current | Contract | Annualized | IBNR Reserve | |||||||
| Contract Premium | Volume (000) or lives | Adjustment | Premium | Contract Premium | Premium Factor | IBNR Reserve | ||||
| Employee Basic Term Life | $ 0.162 | per $1000 | 5,608,467 | 0 | 908,571.65 | 10,902,859.80 | 4.7% | 512,434.41 | ||
| Employee Basic AD&D | $ 0.019 | per $1000 | 5,608,367 | 0 | 106,558.97 | 1,278,707.64 | 4.2% | 53,705.72 | ||
| 1,015,130.62 | 12,181,567.44 | 566,140.13 | ||||||||
| Minimum Premium | 2023 | 2024 | 2025 | 2026 | 2027 | |||||
| Retention | per employee | $0.102 | $0.102 | $0.102 | $0.102 | $0.102 | ||||
| IBNR | per employee | $0.434 | n | |||||||
| $0.536 |
| (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J) | (K) | (L) | (M) | (N) | (O) | (P) | |||||
| B+C | E+F+G+H+I+J | MIN(K,D) | D-K | J-K | ||||||||||||||||
| Prior | Tax & | Prior | Minimum | |||||||||||||||||
| Number of | Contract | Surplus | Group Max | Change In | Conversion | Interest | Deficit | Premium | Monthly | Payment | Payment | Current | Current | IBNR | ||||||
| Month | Employees | Premium | Balance | Liability | Claims | Waiver Reserve | Charge | Reconciliation | Balance | Charge | Cost | Due | Received | Surplus | Deficit | Balance | ||||
| Diff in IBNR | Min Premium | |||||||||||||||||||
| Jan-23 | 69,323 | $ 668,182.92 | $ - 0 | $ 668,182.92 | $ 100,053.43 | $ - 0 | $ 5,675.00 | $ - 0 | $ - 0 | $ 37,157.13 | $ 142,885.56 | $ 142,885.56 | $ 142,885.56 | $ 525,297.36 | $ - 0 | $ 30,086.18 | $ 30,086.18 | $ 7,070.95 | ||
| Feb-23 | 69,343 | $ 667,617.72 | $ 525,297.36 | $ 1,192,915.08 | $ 292,269.03 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 37,167.85 | $ 329,436.88 | $ 329,436.88 | $ 329,436.88 | $ 863,478.20 | $ - 0 | $ 60,181.04 | $ 30,094.86 | $ 7,072.99 | ||
| Mar-23 | 70,030 | $ 672,089.53 | $ 863,478.20 | $ 1,535,567.73 | $ 930,264.26 | $ - 0 | $ 5,675.00 | $ - 0 | $ - 0 | $ 37,536.08 | $ 973,475.34 | $ 973,475.34 | $ 973,475.34 | $ 562,092.39 | $ - 0 | $ 90,574.06 | $ 30,393.02 | $ 7,143.06 | ||
| Apr-23 | 70,085 | $ 671,827.08 | $ 562,092.39 | $ 1,233,919.47 | $ 440,520.11 | $ - 0 | $ 3,972.50 | $ - 0 | $ - 0 | $ 37,565.56 | $ 482,058.17 | $ 482,058.17 | $ 482,058.17 | $ 751,861.30 | $ - 0 | $ 120,990.95 | $ 30,416.89 | $ 7,148.67 | ||
| May-23 | 70,052 | $ 670,252.92 | $ 751,861.30 | $ 1,422,114.22 | $ 657,258.00 | $ - 0 | $ 3,972.50 | $ - 0 | $ - 0 | $ 37,547.87 | $ 698,778.37 | $ 698,778.37 | $ 698,778.37 | $ 723,335.85 | $ - 0 | $ 151,393.52 | $ 30,402.57 | $ 7,145.30 | ||
| Jun-23 | 70,521 | $ 673,457.07 | $ 723,335.85 | $ 1,396,792.92 | $ 1,144,749.57 | $ - 0 | $ 2,270.00 | $ - 0 | $ - 0 | $ 37,799.26 | $ 1,184,818.83 | $ 1,184,818.83 | $ 1,184,818.83 | $ 211,974.09 | $ - 0 | $ 181,999.64 | $ 30,606.11 | $ 7,193.14 | ||
| Jul-23 | 70,609 | $ 673,080.14 | $ 211,974.09 | $ 885,054.23 | $ 750,227.62 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 37,846.42 | $ 788,074.04 | $ 788,074.04 | $ 788,074.04 | $ 96,980.19 | $ - 0 | $ 212,643.94 | $ 30,644.31 | $ 7,202.12 | ||
| Aug-23 | 70,540 | $ 670,745.89 | $ 96,980.19 | $ 767,726.08 | $ 646,355.57 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 37,809.44 | $ 684,165.01 | $ 684,165.01 | $ 684,165.01 | $ 83,561.07 | $ - 0 | $ 243,258.30 | $ 30,614.36 | $ 7,195.08 | ||
| Sep-23 | 70,958 | $ 672,647.07 | $ 83,561.07 | $ 756,208.14 | $ 475,959.59 | $ - 0 | $ 6,810.00 | $ - 0 | $ - 0 | $ 38,033.49 | $ 520,803.08 | $ 520,803.08 | $ 520,803.08 | $ 235,405.06 | $ - 0 | $ 274,054.07 | $ 30,795.77 | $ 7,237.72 | ||
| Oct-23 | 71,454 | $ 674,200.27 | $ 235,405.06 | $ 909,605.33 | $ 748,204.07 | $ - 0 | $ 11,350.00 | $ - 0 | $ - 0 | $ 38,299.34 | $ 797,853.41 | $ 797,853.41 | $ 797,851.07 | $ 111,751.92 | $ - 0 | $ 305,065.11 | $ 31,011.04 | $ 7,288.31 | ||
| Nov-23 | 71,796 | $ 675,678.50 | $ 111,751.92 | $ 787,430.42 | $ 611,550.87 | $ 20,000.00 | $ 4,540.00 | $ - 0 | $ - 0 | $ 38,482.66 | $ 674,573.53 | $ 674,573.53 | $ 674,573.53 | $ 112,856.89 | $ - 0 | $ 336,224.57 | $ 31,159.46 | $ 7,323.19 | ||
| Dec-23 | 71,796 | * | $ 672,224.12 | $ 112,856.89 | $ 785,081.01 | $ 571,363.67 | $ 20,000.00 | $ 11,123.00 | $ - 0 | $ - 0 | $ 38,482.66 | $ 640,969.33 | $ 640,969.33 | $ 640,969.33 | $ 144,111.68 | $ - 0 | $ 367,384.04 | $ 31,159.46 | $ 7,323.19 | |
| Jan-24 | 71,898 | $ 919,635.51 | $ 144,111.68 | $ 1,063,747.19 | $ 520,813.04 | $ 20,000.00 | $ - 0 | $ - 0 | $ - 0 | $ 151,329.77 | $ 692,142.81 | $ 692,142.81 | $ 692,142.81 | $ 371,604.38 | $ - 0 | $ 511,380.21 | $ 143,996.17 | $ 7,333.60 | ||
| Feb-24 | 72,055 | $ 920,311.11 | $ 371,604.38 | $ 1,291,915.49 | $ 899,749.59 | $ 20,000.00 | $ 36,320.00 | $ 173,299.00 | $ - 0 | $ 8,072.16 | $ 1,137,440.75 | $ 1,137,440.75 | $ 1,137,440.75 | $ 154,474.74 | $ - 0 | $ 512,102.76 | $ 722.55 | $ 7,349.61 | ||
| Mar-24 | 72,256 | $ 921,380.10 | $ 154,474.74 | $ 1,075,854.84 | $ 814,972.78 | $ - 0 | $ 12,258.00 | $ - 0 | $ - 0 | $ 8,197.61 | $ 835,428.39 | $ 835,428.39 | $ 835,428.39 | $ 240,426.45 | $ - 0 | $ 512,930.26 | $ 827.50 | $ 7,370.11 | ||
| Apr-24 | 72,277 | $ 920,140.24 | $ 240,426.45 | $ 1,160,566.69 | $ 479,843.78 | $ - 0 | $ 33,142.00 | $ - 0 | $ - 0 | $ 7,097.42 | $ 520,083.20 | $ 520,083.20 | $ 520,083.20 | $ 640,483.49 | $ - 0 | $ 512,655.43 | $ (274.83) | $ 7,372.25 | ||
| May-24 | 72,507 | $ 921,669.79 | $ 640,483.49 | $ 1,562,153.28 | $ 456,400.73 | $ 20,000.00 | $ 12,031.00 | $ - 0 | $ - 0 | $ 8,418.55 | $ 496,850.28 | $ 496,850.28 | $ 496,850.28 | $ 1,065,303.00 | $ - 0 | $ 513,678.27 | $ 1,022.84 | $ 7,395.71 | ||
| Jun-24 | 72,675 | $ 922,181.97 | $ 1,065,303.00 | $ 1,987,484.97 | $ 718,100.16 | $ 64,800.00 | $ 17,252.00 | $ - 0 | $ - 0 | $ 7,921.21 | $ 808,073.37 | $ 808,073.37 | $ 808,073.37 | $ 1,179,411.60 | $ - 0 | $ 514,186.63 | $ 508.36 | $ 7,412.85 | ||
| Jul-24 | 72,636 | $ 921,402.51 | $ 1,179,411.60 | $ 2,100,814.11 | $ 803,186.99 | $ (4,800.00) | $ 24,402.50 | $ - 0 | $ - 0 | $ 6,732.95 | $ 829,522.44 | $ 829,522.44 | $ 829,522.44 | $ 1,271,291.67 | $ - 0 | $ 513,510.71 | $ (675.92) | $ 7,408.87 | ||
| Aug-24 | 72,827 | $ 922,547.19 | $ 1,271,291.67 | $ 2,193,838.86 | $ 365,155.95 | $ - 0 | $ 23,381.00 | $ - 0 | $ - 0 | $ 8,280.54 | $ 396,817.49 | $ 396,817.49 | $ 396,817.49 | $ 1,797,021.37 | $ - 0 | $ 514,362.90 | $ 852.19 | $ 7,428.35 | ||
| Sep-24 | 73,123 | $ 925,824.41 | $ 1,797,021.37 | $ 2,722,845.78 | $ 665,726.21 | $ (20,000.00) | $ (17,138.50) | $ - 0 | $ - 0 | $ 9,355.77 | $ 637,943.48 | $ 637,943.48 | $ 637,943.48 | $ 2,084,902.30 | $ - 0 | $ 516,260.12 | $ 1,897.22 | $ 7,458.55 | ||
| Oct-24 | 73,556 | $ 930,063.26 | $ 2,084,902.30 | $ 3,014,965.56 | $ 810,639.56 | $ 20,000.00 | $ 34,050.00 | $ - 0 | $ - 0 | $ 9,912.85 | $ 874,602.41 | $ 874,602.41 | $ 874,602.41 | $ 2,140,363.15 | $ - 0 | $ 518,670.26 | $ 2,410.14 | $ 7,502.71 | ||
| Nov-24 | 73,762 | $ 932,084.41 | $ 2,140,363.15 | $ 3,072,447.56 | $ 1,121,482.15 | $ - 0 | $ 34,050.00 | $ - 0 | $ - 0 | $ 8,565.36 | $ 1,164,097.51 | $ 1,164,097.51 | $ 1,164,097.51 | $ 1,908,350.05 | $ - 0 | $ 519,711.90 | $ 1,041.64 | $ 7,523.72 | ||
| Dec-24 | 73,915 | $ 932,949.84 | $ 1,908,350.05 | $ 2,841,299.89 | $ 654,765.50 | $ 20,000.00 | $ 5,675.00 | $ - 0 | $ - 0 | $ 8,095.63 | $ 688,536.13 | $ 688,536.13 | $ 688,536.13 | $ 2,152,763.76 | $ - 0 | $ 520,268.20 | $ 556.30 | $ 7,539.33 | ||
| Jan-25 | 74,043 | $ 979,764.27 | $ 2,152,763.76 | $ 3,132,528.03 | $ 761,422.58 | $ 26,400.00 | $ 3,405.00 | $ - 0 | $ - 0 | $ 33,690.86 | $ 824,918.44 | $ 824,918.44 | $ 824,918.44 | $ 2,307,609.59 | $ - 0 | $ 546,406.67 | $ 26,138.47 | $ 7,552.39 | ||
| Feb-25 | 73,880 | $ 977,247.06 | $ 2,307,609.59 | $ 3,284,856.65 | $ 897,560.56 | $ 58,000.00 | $ - 0 | $ 236,600.00 | $ - 0 | $ 6,136.15 | $ 1,198,296.71 | $ 1,198,296.71 | $ 1,198,296.71 | $ 2,086,559.94 | $ - 0 | $ 545,007.06 | $ (1,399.61) | $ 7,535.76 | ||
| Mar-25 | 73,754 | $ 974,910.39 | $ 2,086,559.94 | $ 3,061,470.33 | $ 1,033,223.65 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 6,220.22 | $ 1,039,443.87 | $ 1,039,443.87 | $ 1,039,443.87 | $ 2,022,026.46 | $ - 0 | $ 543,704.37 | $ (1,302.69) | $ 7,522.91 | ||
| Apr-25 | 73,798 | $ 974,384.13 | $ 2,022,026.46 | $ 2,996,410.59 | $ 789,292.48 | $ 20,000.00 | $ - 0 | $ - 0 | $ - 0 | $ 7,228.00 | $ 816,520.48 | $ 816,520.48 | $ 816,520.48 | $ 2,179,890.11 | $ - 0 | $ 543,404.97 | $ (299.40) | $ 7,527.40 | ||
| May-25 | 73,885 | $ 974,417.12 | $ 2,179,890.11 | $ 3,154,307.23 | $ 547,613.93 | $ - 0 | $ 5,675.00 | $ - 0 | $ - 0 | $ 7,565.35 | $ 560,854.28 | $ 560,854.28 | $ 560,854.28 | $ 2,593,452.95 | $ - 0 | $ 543,434.05 | $ 29.08 | $ 7,536.27 | ||
| Jun-25 | 73,920 | $ 973,895.78 | $ 2,593,452.95 | $ 3,567,348.73 | $ 803,958.53 | $ - 0 | $ 29,283.00 | $ - 0 | $ - 0 | $ 7,241.74 | $ 840,483.27 | $ 840,483.27 | $ 840,483.27 | $ 2,726,865.46 | $ - 0 | $ 543,135.95 | $ (298.10) | $ 7,539.84 | ||
| Jul-25 | 73,713 | $ 971,062.37 | $ 2,726,865.46 | $ 3,697,927.83 | $ 355,409.59 | $ 42,000.00 | $ 27,240.00 | $ - 0 | $ - 0 | $ 5,945.97 | $ 430,595.56 | $ 430,595.56 | $ 430,595.56 | $ 3,267,332.27 | $ - 0 | $ 541,563.19 | $ (1,572.76) | $ 7,518.73 | ||
| Aug-25 | 73,662 | $ 969,643.70 | $ 3,267,332.27 | $ 4,236,975.97 | $ 464,978.33 | $ (19,200.00) | $ 9,761.00 | $ - 0 | $ - 0 | $ 6,714.33 | $ 462,253.66 | $ 462,253.66 | $ 462,253.66 | $ 3,774,722.31 | $ - 0 | $ 540,764.00 | $ (799.19) | $ 7,513.52 | ||
| Sep-25 | 73,930 | $ 972,230.80 | $ 3,774,722.31 | $ 4,746,953.11 | $ 738,223.24 | $ - 0 | $ 26,105.00 | $ - 0 | $ - 0 | $ 8,987.57 | $ 773,315.81 | $ 773,315.81 | $ 773,315.81 | $ 3,973,637.30 | $ - 0 | $ 542,210.71 | $ 1,446.71 | $ 7,540.86 | ||
| Oct-25 | 74,141 | $ 974,233.97 | $ 3,973,637.30 | $ 4,947,871.27 | $ 685,865.20 | $ - 0 | $ 18,160.00 | $ - 0 | $ - 0 | $ 8,664.59 | $ 712,689.79 | $ 712,689.79 | $ 712,689.79 | $ 4,235,181.48 | $ - 0 | $ 543,312.92 | $ 1,102.21 | $ 7,562.38 | ||
| Nov-25 | 74,192 | $ 974,018.15 | $ 4,235,181.48 | $ 5,209,199.63 | $ 869,403.03 | $ 44,400.00 | $ 11,917.50 | $ - 0 | $ - 0 | $ 7,466.35 | $ 933,186.88 | $ 933,186.88 | $ 933,186.88 | $ 4,276,012.75 | $ - 0 | $ 543,211.69 | $ (101.23) | $ 7,567.58 | ||
| Dec-25 | 74,375 | $ 975,118.44 | $ 4,276,012.75 | $ 5,251,131.19 | $ 790,229.56 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 8,200.01 | $ 798,429.57 | $ 798,429.57 | $ 798,429.57 | $ 4,452,701.62 | $ - 0 | $ 543,825.45 | $ 613.76 | $ 7,586.25 | ||
| Jan-26 | 74,282 | $ 1,018,169.66 | $ 4,452,701.62 | $ 5,470,871.28 | $ 530,576.22 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 31,586.27 | $ 562,162.49 | $ 562,162.49 | $ 562,162.49 | $ 4,908,708.79 | $ - 0 | $ 567,834.96 | $ 24,009.51 | $ 7,576.76 | ||
| Feb-26 | 74,034 | $ (1,127,759.99) | ** | $ 4,908,708.79 | $ 3,780,948.80 | $ 531,266.53 | $ 58,000.00 | $ 13,620.00 | $ 225,007.00 | $ - 0 | $ 5,629.78 | $ 833,523.31 | $ 833,523.31 | $ 833,523.31 | $ 2,947,425.49 | $ - 0 | $ 565,913.27 | $ (1,921.69) | $ 7,551.47 | |
| Mar-26 | 74,299 | $ 1,016,722.07 | $ 2,947,425.49 | $ 3,964,147.56 | $ 772,297.66 | $ 70,800.00 | $ 2,270.00 | $ - 0 | $ - 0 | $ 8,692.82 | $ 854,060.48 | $ 854,060.48 | $ 854,060.48 | $ 3,110,087.08 | $ - 0 | $ 567,027.59 | $ 1,114.32 | $ 7,578.50 | ||
| Apr-26 | 74,332 | $ 1,016,211.43 | $ 3,110,087.08 | $ 4,126,298.51 | $ 787,945.47 | $ 48,800.00 | $ 17,025.00 | $ - 0 | $ - 0 | $ 7,297.12 | $ 861,067.59 | $ 861,067.59 | $ 861,067.59 | $ 3,265,230.92 | $ - 0 | $ 566,742.85 | $ (284.74) | $ 7,581.86 | ||
| May-26 | 74,476 | $ 1,017,023.33 | $ 3,265,230.92 | $ 4,282,254.25 | $ 738,491.82 | $ - 0 | $ 15,152.25 | $ - 0 | $ - 0 | $ 8,049.72 | $ 761,693.79 | $ 761,693.79 | $ 761,693.79 | $ 3,520,560.46 | $ - 0 | $ 567,196.02 | $ 453.17 | $ 7,596.55 | ||
| Jun-26 | 74,380 | $ 1,015,130.62 | $ 3,520,560.46 | $ 4,535,691.08 | $ 714,178.07 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 6,530.87 | $ 720,708.94 | $ 720,708.94 | $ - 0 | $ 3,814,982.14 | $ - 0 | $ 566,140.13 | $ (1,055.89) | $ 7,586.76 |
| $ 30,983,634.73 | $ 30,262,923.45 | ||
| June 2026 Invoice | $ 720,708.94 |
| * December 2023 bill includes adjustments due to reported lives/volumes changes for October 2023 bill |
| ** Includes surplus premium carry-forward provision adjustment of ($2,142,484) included in the 2025 policy year report |
File details come from the government source that posted it. Updated .