Appendix 7.8: Claims History and P&L Analysis for State of Tennessee Disability Insurance

This Excel workbook contains historical claims data and financial performance information for the State of Tennessee's short-term disability (STD) and long-term disability (LTD) insurance programs administered under RFP #31786-00186. The file includes comprehensive claims history for both STD and LTD coverage from January 2021 through May 2025, segmented by plan type, enrollment status, and demographic characteristics of claimants.

The STD claims data encompasses monthly premium volumes, employee counts, claim counts, and paid benefits from January 2022 through May 2025, with total STD claims paid of $2,692,277.17 during this period. The LTD claims data provides detailed individual claim records including claimant demographics (birth year, age, gender), disability dates, benefit amounts, paid claims to date, and case reserves for claims initiated from January 2021 through May 2025. Summary statistics indicate total incurred claims of $8,499,036 across the experience period from January 2021 through June 2025, with 77 open claims out of 133 total open and closed claims, average cost per claim of $58,617, and average reserve per claim of $73,638. The file serves as critical baseline experience data for prospective bidders evaluating the claims profile, member demographics, and financial obligations associated with assuming the State of Tennessee's disability insurance administration contract effective January 1, 2027.