{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover Page","Pt 1 Summary of Data","Pt 2 Premium and Claims","Pt 3 Expense Allocation","Pt 4 MLR Calculation","Pt 5 Additional Responses","Attestation","Dec 2024","March 2024","March 2025"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":38,"defined_names":1312,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form "]
[null,"Dental Coverage"]
[]
[]
["1.","MLR Reporting Year","2024"]
["2.","Enter DMHC Health Plan ID. Insurers may leave this field blank"]
["3.","Legal Name","Dearborn Life Insurance Company"]
["4.","DBA"]
["5.","Federal Tax Exempt Status? Please enter Yes or No","No"]
[]
[]
[]
[null,"Cell Key:"]
[null,"Blank cells require input from Health plan or Health insurer"]
[]
[]
[null,"Version 4.22.15"]
[null,"Revised Version 5.26.15"]
[null,"Revised Version 4.15.16 corrected dates for Cycle Year (CY)2015-2016 on TABs Parts 1, 2 and 4."]
[null,"Revised Version 5.10.17 12/31 and 3/31 Columns years to be auto populated on TABs Parts 1 and 2."]
[null,"Revised Version 5.20.19 Document Accessible"]

{"sheet":"Pt 1 Summary of Data","index":1,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage"]
[null,"Part 1 - Summary of Data"]
[]
[null,"Health Plan ID",null,null,null,null,null,"Federal Tax Exempt "]
[null,null,null,{"$f":"'Cover Page'!C7","v":0},null,null,null,{"$f":"'Cover Page'!C10","v":"No"}]
[null,"Legal Name"]
[null,null,null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"}]
[null,"dBA",null,null,"Part 1"]
[null,null,null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,null,null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[null,null,null,null,null,null,"Health Insurance Coverage",null,null,null,null,null,"Health Insurance Coverage"]
[null,null,null,null,null,null,"DHMO Products",null,null,null,null,null,"DPPO & Indemnity Products"]
[null,null,null,null,"Individual",null,"Small Group",null,"Large Group",null,"Individual",null,"Small Group",null,"Large Group"]
[null,null,null,null,"Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of "]
[null,null,null,"Part 1\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT ",{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(E18)+0,MONTH(E18)+3,DAY(E18)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(G18)+0,MONTH(G18)+3,DAY(G18)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(I18)+0,MONTH(I18)+3,DAY(I18)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(K18)+0,MONTH(K18)+3,DAY(K18)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(M18)+0,MONTH(M18)+3,DAY(M18)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(O18)+0,MONTH(O18)+3,DAY(O18)+0)","v":"2025-03-31"}]
[null,null,null,"INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"1.","Premium"]
[null,null,1.1000000000000001,"Total direct premium earned",{"$f":"'Pt 2 Premium and Claims'!E22+'Pt 2 Premium and Claims'!E23-'Pt 2 Premium and Claims'!E24-'Pt 2 Premium and Claims'!E25","v":0},{"$f":"'Pt 2 Premium and Claims'!F22+'Pt 2 Premium and Claims'!F23-'Pt 2 Premium and Claims'!F24-'Pt 2 Premium and Claims'!F25","v":0},{"$f":"'Pt 2 Premium and Claims'!G22+'Pt 2 Premium and Claims'!G23-'Pt 2 Premium and Claims'!G24-'Pt 2 Premium and Claims'!G25","v":0},{"$f":"'Pt 2 Premium and Claims'!H22+'Pt 2 Premium and Claims'!H23-'Pt 2 Premium and Claims'!H24-'Pt 2 Premium and Claims'!H25","v":0},{"$f":"'Pt 2 Premium and Claims'!I22+'Pt 2 Premium and Claims'!I23-'Pt 2 Premium and Claims'!I24-'Pt 2 Premium and Claims'!I25","v":0},{"$f":"'Pt 2 Premium and Claims'!J22+'Pt 2 Premium and Claims'!J23-'Pt 2 Premium and Claims'!J24-'Pt 2 Premium and Claims'!J25","v":0},{"$f":"'Pt 2 Premium and Claims'!K22+'Pt 2 Premium and Claims'!K23-'Pt 2 Premium and Claims'!K24-'Pt 2 Premium and Claims'!K25","v":0},{"$f":"'Pt 2 Premium and Claims'!L22+'Pt 2 Premium and Claims'!L23-'Pt 2 Premium and Claims'!L24-'Pt 2 Premium and Claims'!L25","v":0},{"$f":"'Pt 2 Premium and Claims'!M22+'Pt 2 Premium and Claims'!M23-'Pt 2 Premium and Claims'!M24-'Pt 2 Premium and Claims'!M25","v":69331},{"$f":"'Pt 2 Premium and Claims'!N22+'Pt 2 Premium and Claims'!N23-'Pt 2 Premium and Claims'!N24-'Pt 2 Premium and Claims'!N25","v":69292},{"$f":"'Pt 2 Premium and Claims'!O22+'Pt 2 Premium and Claims'!O23-'Pt 2 Premium and Claims'!O24-'Pt 2 Premium and Claims'!O25","v":0},{"$f":"'Pt 2 Premium and Claims'!P22+'Pt 2 Premium and Claims'!P23-'Pt 2 Premium and Claims'!P24-'Pt 2 Premium and Claims'!P25","v":0}]
[]
[null,"2.","Claims"]
[null,null,2.1,"Total incurred claims (MLR Form Part 2, Line 2.11)",{"$f":"'Pt 2 Premium and Claims'!E51","v":0},{"$f":"'Pt 2 Premium and Claims'!F51","v":0},{"$f":"'Pt 2 Premium and Claims'!G51","v":0},{"$f":"'Pt 2 Premium and Claims'!H51","v":0},{"$f":"'Pt 2 Premium and Claims'!I51","v":0},{"$f":"'Pt 2 Premium and Claims'!J51","v":0},{"$f":"'Pt 2 Premium and Claims'!K51","v":0},{"$f":"'Pt 2 Premium and Claims'!L51","v":0},{"$f":"'Pt 2 Premium and Claims'!M51","v":49143},{"$f":"'Pt 2 Premium and Claims'!N51","v":43739},{"$f":"'Pt 2 Premium and Claims'!O51","v":0},{"$f":"'Pt 2 Premium and Claims'!P51","v":0}]
[]
[null,"3.","Federal and State Taxes and Licensing or Regulatory Fees"]
[null,null,3.1,"Federal taxes and assessments incurred by the reporting health plan or health insurer during the MLR reporting year "]
[null,null,null,"  3.1 a  Federal income taxes deductible from premium in MLR calculations "]
[null,null,null,"  3.1 b  Other Federal Taxes (other than income tax) and assessments deductible from premium"]
[null,null,3.2,"State insurance, premium and other taxes incurred by the reporting health plan or heath insurer during the MLR reporting year (deductible from premium in MLR calculation)"]
[null,null,null,"  3.2 a   State income, excise, business, and other taxes"]
[null,null,null,"  3.2 b   State premium taxes ",null,null,null,null,null,null,null,null,{"$f":"'Dec 2024'!AU44","v":1616.7059999999999},{"$f":"'Dec 2024'!AX44","v":1604.7915}]
[null,null,null,"  3.2 c   Community benefit expenditures "]
[null,null,3.3,"Regulatory authority licenses and fees"]
[null,null,3.4,"Total Federal and State Taxes and fees to be excluded from premium",{"$f":"SUM(E$28:E$29,E$31,E$34+IF($H$6=\"No\",IF(MAX(E$32:E$33)=0,MIN(E$32:E$33),MAX(E$32:E$33)),SUM(E$32:E$33)))","v":0},0,0,0,0,0,0,0,1616.7059999999999,1604.7915,0,0]
[]
[null,"4.","Non-Claims Costs "]
[null,null,4.0999999999999996,"Direct sales salaries and benefits"]
[null,null,4.2,"Agents and brokers fees and commissions",null,null,null,null,null,null,null,null,{"$f":"'Dec 2024'!AU42","v":7781.234314899717},{"$f":"'Dec 2024'!AX42","v":7650.0570855193064}]
[null,null,4.3,"Other taxes"]
[null,null,null,"4.3a   Taxes and assessments (exclude amounts reported in Section 3 or Line 10) \n"]
[null,null,null,"4.3b   Fines and penalties of regulatory authorities (exclude amounts reported in Line 3.3)"]
[null,null,4.4000000000000004,"Other general and administrative expenses",null,null,null,null,null,null,null,null,{"$f":"'Dec 2024'!AU43","v":28139.090443719022},{"$f":"'Dec 2024'!AX43","v":30195.205691209074}]
[null,null,4.5,"Total non-claims costs",{"$f":"SUM(SUM(E38:E39)+SUM(E41:E43))","v":0},{"$f":"SUM(SUM(F38:F39)+SUM(F41:F43))","v":0},0,0,0,0,0,0,35920.324758618735,37845.262776728378,0,0]
[]
[null,"5.","Other Indicators or information "]
[null,null,5.0999999999999996,"Number of covered lives",null,null,null,null,null,null,null,null,115,115]
[null,null,5.2,"Member months",null,null,null,null,null,null,null,null,1377,1376]
[null,null,5.3,"Number of life-years",{"$f":"E48/12","v":0},{"$f":"F48/12","v":0},0,{"$f":"H48/12","v":0},0,0,0,0,{"$f":"M48/12","v":114.75},{"$f":"N48/12","v":114.66666666666667},0,0]
[null,null,null,null,{"$f":"\"Grand Total as of \"&\"\"&TEXT(E$18,\"MM/DD/YYYY\")&\" for ALL markets in col. 1-12.\"","v":"Grand Total as of 12/31/2024 for ALL markets in col. 1-12."}]
[null,"6.","Net investment income and other gain / (loss) "]
[null,"7.","Other Federal income taxes (exclude taxes on Line 3.1a and 3.1b) "]
[]
[null,"Cell Keys:"]
[null,null,"Blank cells require input from Health plan or Health insurer"]
[null,null,"Grey cells require no data input "]
[null,null,"Pink cells require no data input - locked down"]
[null,null,"Blue cells: computed cell (formula cell)"]

{"sheet":"Pt 2 Premium and Claims","index":2,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage"]
[null,"Part 2 - Premium and Claims"]
[]
[null,"Health Plan ID"]
[null,null,null,{"$f":"'Cover Page'!C7","v":0}]
[null,"Legal Name"]
[null,null,null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"}]
[null,"dBA",null,null,"Part 2"]
[null,null,null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,null,null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[]
[null,null,null,null,null,null,"Health Insurance Coverage",null,null,null,null,null,"Health Insurance Coverage"]
[null,null,null,null,null,null,"DHMO Products",null,null,null,null,null,"DPPO & Indemnity Products"]
[null,null,null,null,"Individual",null,null,"Small Group","Large Group",null,"Individual",null,"Small Group",null,"Large Group"]
[null,null,null,null,"Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of ","Total as of "]
[null,null,null,"Part 2\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT ",{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(E19)+0,MONTH(E19)+3,DAY(E19)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(G19)+0,MONTH(G19)+3,DAY(G19)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(I19)+0,MONTH(I19)+3,DAY(I19)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(K19)+0,MONTH(K19)+3,DAY(K19)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(M19)+0,MONTH(M19)+3,DAY(M19)+0)","v":"2025-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2024"},{"$f":"DATE(YEAR(O19)+0,MONTH(O19)+3,DAY(O19)+0)","v":"2025-03-31"}]
[null,null,null,"INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"1.","Premium:"]
[null,null,1.1000000000000001,"Direct premium written",null,null,null,null,null,null,null,null,69331,69292]
[null,null,1.2,"Unearned premium prior year"]
[null,null,1.3,"Unearned premium MLR Reporting year"]
[null,null,1.4,"Premium balances written off"]
[]
[null,"2.","Claims:"]
[null,null,2.1,"Claims Paid"]
[null,null,null,"2.1a  Claims paid during the MLR reporting year regardless of incurred date",null,null,null,null,null,null,null,null,46234]
[null,null,null,"2.1b  Claims incurred only during the MLR reporting year, paid through 3/31 of the following year",null,null,null,null,null,null,null,null,null,43225]
[null,null,2.2000000000000002,"Direct claim liability"]
[null,null,null,"2.2a Liability as of 12/31 of MLR reporting year for all claims regardless of incurred date"]
[null,null,null,"2.2b Liability for claims incurred only during the MLR reporting year, calculated as of 3/31 of the following year"]
[null,null,2.2999999999999998,"Direct claim liability prior year"]
[null,null,2.4,"Direct claim reserves"]
[null,null,null,"2.4a Reserves as of 12/31 of MLR reporting year for all claims regardless of incurred date",null,null,null,null,null,null,null,null,2909]
[null,null,null,"2.4b Reserves for claims incurred only during the MLR reporting year, calculated as of 3/31 of the following year",null,null,null,null,null,null,null,null,null,514]
[null,null,2.5,"Direct claim reserves prior year"]
[null,null,2.6,"Experience rating refunds (rate credits) paid"]
[null,null,null,"2.6a Experience rating refunds, with all incurred dates, paid in the MLR reporting year"]
[null,null,null,"2.6b Experience rating refunds associated with premium earned only in the reporting year and paid through 3/31 of the following year"]
[null,null,2.7,"Reserve for experience rating refunds (rate credits)"]
[null,null,null,"2.7a Reserved in MLR reporting year regardless of incurred date"]
[null,null,null,"2.7b Reserves specific to the MLR reporting year through 3/31 of the following year"]
[null,null,"2.8","Reserve for experience rating refunds (rate credits) prior year"]
[null,null,2.9,"Incurred dental incentive pool and bonuses"]
[null,null,null,"2.9a  Paid dental incentive pools and bonuses MLR Reporting year"]
[null,null,null,"2.9b  Accrued dental incentive pools and bonuses MLR Reporting year"]
[null,null,null,"2.9c  Accrued dental incentive pools and bonuses prior year"]
[null,null,"2.10","Contingent benefit and lawsuit reserves"]
[null,null,"2.11","Total incurred claims ",{"$f":"E29+E32-E34+E36-E38+E40+E43-E45+E47+E48-E49+E50","v":0},{"$f":"F30+F33+F37+F41+F44+F47+F48+F50","v":0},{"$f":"G29+G32-G34+G36-G38+G40+G43-G45+G47+G48-G49+G50","v":0},{"$f":"H30+H33+H37+H41+H44+H47+H48+H50","v":0},{"$f":"I29+I32-I34+I36-I38+I40+I43-I45+I47+I48-I49+I50","v":0},{"$f":"J30+J33+J37+J41+J44+J47+J48+J50","v":0},{"$f":"K29+K32-K34+K36-K38+K40+K43-K45+K47+K48-K49+K50","v":0},{"$f":"L30+L33+L37+L41+L44+L47+L48+L50","v":0},{"$f":"M29+M32-M34+M36-M38+M40+M43-M45+M47+M48-M49+M50","v":49143},{"$f":"N30+N33+N37+N41+N44+N47+N48+N50","v":43739},{"$f":"O29+O32-O34+O36-O38+O40+O43-O45+O47+O48-O49+O50","v":0},{"$f":"P30+P33+P37+P41+P44+P47+P48+P50","v":0}]
[]
[]
[null,null,"Cell Keys:"]
[null,null,null,"Blank cells require input from Health plan or Health insurer"]
[null,null,null,"Grey cells require no data input"]
[null,null,null,"Pink cells require no data input - locked down"]
[null,null,null,"Blue cells: computed cell (formula cell)"]

{"sheet":"Pt 3 Expense Allocation","index":3,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage "]
[null,"Part 3 - Expense Allocation"]
[]
[null,"Health Plan ID"]
[null,{"$f":"'Cover Page'!C7","v":0},null,"Part 3"]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[]
[null,"Description of Expense Element (by Type)","NEW","Detailed Description of Expense Allocation Methods"]
[null,1,2,3]
[null,"1.  Incurred Claims"]
[null,null,null,"Actual - no allocation"]
[]
[]
[]
[]
[]
[null,"2.  Federal and State Taxes and Licensing or Regulatory Fees"]
[null,"2.a Federal taxes and assessments"]
[null,null,null,"Corporate tax rate 21%"]
[]
[]
[]
[]
[]
[null,"2.b State insurance, premium and other taxes"]
[null,null,null,"Actual premium tax allocated based on direct dental premium collected"]
[]
[]
[]
[]
[]
[null,"2.c Community benefit expenditures "]
[null,null,null,"None"]
[]
[]
[]
[]
[]
[null,"2.d Regulatory authority licenses and fees"]
[null,null,null,"None"]
[]
[]
[]
[]
[]
[null,"3.  Non-Claims costs"]
[null,"3.a Direct sales salaries and benefits"]
[null,null,null,"None"]
[]
[]
[]
[]
[]
[null,"3.b Agents and brokers fees and commissions"]
[null,null,null,"Actual expense allocated based on direct dental premium collected"]
[]
[]
[]
[]
[]
[null,"3.c Other taxes"]
[null,null,null,"No allocation"]
[]
[]
[]
[]
[]
[null,"3.d Other general and administrative expenses"]
[null,null,null,"Actual expense allocated based on direct dental premium collected"]
[]
[]
[]
[]
[]
[]
[null,"Cell Keys:"]
[null,"Blank cells require input from Health plan or Health insurer"]
[null,"Grey cells require no data input "]
[null,"Pink cells require no data input - locked down"]
[null,"Blue cells: computed cell (formula cell)"]

{"sheet":"Pt 4 MLR Calculation","index":4,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage ",null,null,null,"",null,null,"",null,"",null,null,null,null,null,null,"",null,null,"",null,""]
[null,"Part 4 - MLR Calculation"]
[]
[null,"Health Plan ID"]
[null,null,null,{"$f":"'Cover Page'!C7","v":0},null,"Part 4"]
[null,"Legal Name"]
[null,null,null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"}]
[null,"dBA"]
[null,null,null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,null,null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Health Insurance Coverage",null,null,null,null,null,null,null,null,null,null,null,"Health Insurance Coverage"]
[null,null,null,null,null,null,null,null,null,"DHMO Products",null,null,null,null,null,null,null,null,null,null,null,"DPPO & Indemnity Products"]
[null,null,null,null,null,"Individual",null,null,null,"Small Group",null,null,null,"Large Group",null,null,null,"Individual",null,null,null,"Small Group",null,null,null,"Large Group"]
[null,null,null,"Part 4\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT ","PY2","PY1","CY","Total ","PY2","PY1","CY","Total","PY2","PY1","CY","Total","PY2","PY1","CY","Total ","PY2","PY1","CY","Total","PY2","PY1","CY","Total"]
[null,null,null,"INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"1.","Medical Loss Ratio Numerator"]
[null,null,1.1000000000000001,"Adjusted incurred claims as reported on MLR Form for prior year(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123125.43999999997,47055.353299999988]
[null,null,1.2,"Adjusted incurred claims as of 3/31 of the year following the MLR reporting year (Part 1 Line 2.1)",null,null,{"$f":"'Pt 1 Summary of Data'!F24","v":0},{"$f":"SUM(E22:G22)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!H24","v":0},{"$f":"SUM(I22:K22)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!J24","v":0},{"$f":"SUM(M22:O22)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!L24","v":0},{"$f":"SUM(Q22:S22)","v":0},123125.43999999997,47055.353299999988,{"$f":"'Pt 1 Summary of Data'!N24","v":43739},{"$f":"SUM(U22:W22)","v":213919.79329999996},null,null,{"$f":"'Pt 1 Summary of Data'!P24","v":0},{"$f":"SUM(Y22:AA22)","v":0}]
[null,null,1.3,"MLR numerator (Line 1.2)",{"$f":"SUM(E$22)","v":0},{"$f":"SUM(F$22)","v":0},{"$f":"SUM(G$22:G$22)","v":0},{"$f":"SUM(E23:G23)","v":0},{"$f":"SUM(I$22:I$22)","v":0},{"$f":"SUM(J$22:J$22)","v":0},{"$f":"SUM(K$22:K$22)","v":0},{"$f":"SUM(I23:K23)","v":0},{"$f":"SUM(M$22:M$22)","v":0},{"$f":"SUM(N$22:N$22)","v":0},{"$f":"SUM(O$22:O$22)","v":0},{"$f":"SUM(M23:O23)","v":0},{"$f":"SUM(Q$22:Q$22)","v":0},{"$f":"SUM(R$22:R$22)","v":0},{"$f":"SUM(S$22:S$22)","v":0},{"$f":"SUM(Q23:S23)","v":0},{"$f":"SUM(U$22:U$22)","v":123125.43999999997},{"$f":"SUM(V$22:V$22)","v":47055.353299999988},{"$f":"SUM(W$22:W$22)","v":43739},{"$f":"SUM(U23:W23)","v":213919.79329999996},{"$f":"SUM(Y$22:Y$22)","v":0},{"$f":"SUM(Z$22:Z$22)","v":0},{"$f":"SUM(AA$22:AA$22)","v":0},{"$f":"SUM(Y23:AA23)","v":0}]
[null,null,null,"  "]
[null,"2.","Medical Loss Ratio Denominator"]
[null,null,2.1,"Premium earned (Part 1 Line 1.1)",null,null,{"$f":"'Pt 1 Summary of Data'!F21","v":0},{"$f":"SUM(E26:G26)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!H21","v":0},{"$f":"SUM(I26:K26)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!J21","v":0},{"$f":"SUM(M26:O26)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!L21","v":0},{"$f":"SUM(Q26:S26)","v":0},201390.462,70906.989999999991,{"$f":"'Pt 1 Summary of Data'!N21","v":69292},{"$f":"SUM(U26:W26)","v":341589.45199999999},null,null,{"$f":"'Pt 1 Summary of Data'!P21","v":0},{"$f":"SUM(Y26:AA26)","v":0}]
[null,null,2.2000000000000002,"Federal and State taxes and licensing or regulatory fees ( Part 1 Line 3.4)",null,null,{"$f":"'Pt 1 Summary of Data'!F35","v":0},{"$f":"SUM(E27:G27)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!H35","v":0},{"$f":"SUM(I27:K27)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!J35","v":0},{"$f":"SUM(M27:O27)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!L35","v":0},{"$f":"SUM(Q27:S27)","v":0},10502,1659,{"$f":"'Pt 1 Summary of Data'!N35","v":1604.7915},{"$f":"SUM(U27:W27)","v":13765.791499999999},null,null,{"$f":"'Pt 1 Summary of Data'!P35","v":0},{"$f":"SUM(Y27:AA27)","v":0}]
[null,null,2.2999999999999998,"MLR Denominator (Line 2.1 - Line 2.2) ",{"$f":"E$26-E$27","v":0},0,0,{"$f":"H$26-H$27","v":0},{"$f":"I$26-I$27","v":0},{"$f":"J$26-J$27","v":0},0,{"$f":"L$26-L$27","v":0},0,0,0,{"$f":"P$26-P$27","v":0},0,0,0,{"$f":"T$26-T$27","v":0},190888.462,69247.989999999991,67687.208499999993,{"$f":"X$26-X$27","v":327823.6605},0,0,0,{"$f":"AB$26-AB$27","v":0}]
[]
[null,"3.",3.1,"Life-years (Part 1 Line 5.3)",null,null,{"$f":"'Pt 1 Summary of Data'!F49","v":0},{"$f":"SUM(E30:G30)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!H49","v":0},{"$f":"SUM(I30:K30)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!J49","v":0},{"$f":"SUM(M30:O30)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!L49","v":0},{"$f":"SUM(Q30:S30)","v":0},325,118.66666666666667,{"$f":"'Pt 1 Summary of Data'!N49","v":114.66666666666667},{"$f":"SUM(U30:W30)","v":558.33333333333337},null,null,{"$f":"'Pt 1 Summary of Data'!P49","v":0},{"$f":"SUM(Y30:AA30)","v":0}]
[]
[null,"4.",null,"MLR Calculation (for Health plans or health insurers with at least 1,000 life years in the Total column of Line 3.1)"]
[null,null,4.0999999999999996,"MLR",null,null,null,{"$f":"IF(H30<1000,\"Not Required to Calculate\",H23/H28)","v":"Not Required to Calculate"},null,null,null,{"$f":"IF(L30<1000,\"Not Required to Calculate\",L23/L28)","v":"Not Required to Calculate"},null,null,null,{"$f":"IF(P30<1000,\"Not Required to Calculate\",P23/P28)","v":"Not Required to Calculate"},null,null,null,{"$f":"IF(T30<1000,\"Not Required to Calculate\",T23/T28)","v":"Not Required to Calculate"},null,null,null,{"$f":"IF(X30<1000,\"Not Required to Calculate\",X23/X28)","v":"Not Required to Calculate"},null,null,null,{"$f":"IF(AB30<1000,\"Not Required to Calculate\",AB23/AB28)","v":"Not Required to Calculate"}]
[]
[]
[]
[null,null,"Cell Keys:"]
[null,null,null,"Blank cells require input from Health plan or Health insurer"]
[null,null,null,"Grey cells require no data input "]
[null,null,null,"Pink cells require no data input - locked down"]
[null,null,null,"Blue cells: computed cell (formula cell)"]

{"sheet":"Pt 5 Additional Responses","index":5,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage "]
[null,"Part 5 - Additional Responses"]
[]
[null,"Health Plan ID"]
[null,{"$f":"'Cover Page'!C7","v":0}]
[null,"Legal Name","Part 5"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[]
[]
[null,null,"Tax Rate "]
[null,"1. If a health plan or health insurer uses the hightest premium tax rate in the State, the health plan or health insurer must report applicabe highest State health premium tax rate."]
[null,"2. If the health plan or health insurer included deferred experience for prior year and excluded deferred experience for current year, provide the total direct written premium and total incurred claims for the deferred experience by market."]
[null,"Deferred experience for prior year"]
[null,"Deferred experience for current year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. If the health plan or health insurer novated any business in the MLR reporting year effective during the reporting year provide the name of the entity to whom the business was sold or transferred and the date of the sale or transfer."]
[null,"Name of Entity to whom business was sold or transferred","Effective date of sale or transfer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cell Keys:"]
[null,"Blank cells require input from Health plan or Health insurer"]
[null,"Grey cells require no data input "]
[null,"Pink cells require no data input - locked down"]
[null,"Blue cells: computed cell (formula cell)"]

{"sheet":"Attestation","index":6,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Department of Managed Health Care"]
[null,"Medical Loss Ratio Reporting Form: Dental Coverage "]
[null,"Attestation"]
[]
[null,"Health Plan ID"]
[null,{"$f":"'Cover Page'!C7","v":0}]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn Life Insurance Company"},null,"Attestation"]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":0}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2024"}]
[]
[]
[]
[]
[null,"Attestation Statement"]
[null,"The officers of this reporting Health plan being duly sworn, each attest that he/she is the described officer of the reporting Health plan, and that this MLR Reporting Form, the Company/Health plan Associations, and any supplemental submission that the Health plan includes are full and true statements of all the elements included therein for the MLR reporting year stated above, and that the MLR Reporting Form has been completed in accordance with the Department of Managed Health Care’s guidance and reporting instructions, according to the best of his/her information, knowledge and belief.  Furthermore, the scope of this attestation by the described officer includes any related electronic filings and postings for the MLR reporting year stated above and which are required by Department of Managed Health Care."]
[]
[]
[]
[]
[null,"Chief Executive Officer/President"]
[]
[null,"David R. Warden"]
[]
[null,"Chief Financial Officer"]
[]
[null,"Claire C. Burke"]

{"sheet":"Dec 2024","index":7,"n_rows":60,"n_cols":51,"rows_kept":60,"cut":false,"hidden":false,"merged":[[57,0,57,1],[59,0,59,1],[31,46,31,48],[5,29,5,30],[5,31,5,32],[5,33,5,34],[5,39,5,40],[44,0,44,1],[55,0,55,1],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26],[5,27,5,28],[1,0,1,1],[4,3,4,34],[4,36,4,37],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16]]}
["DEARBORN LIFE INSURANCE COMPANY"]
["DECEMBER 2024"]
["INCOME STATEMENT BY LINE OF BUSINESS"]
["$'(000)'s"]
[null,null,null,"Insured",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annuities",null,null,"C&S","C&S",null,"Total All Lines","Total All Lines"]
[null,null,null,"Life",null,"ADD",null,"STD",null,"LTD",null,"Dental",null,"Critical Illness",null,"Accident",null,"Hospital Indemnity",null,"Vision",null,"Individual Life",null,"ASO STD",null,"ASO LIFE",null,"ASO VIS",null,"LTD ASO",null,"DENTAL ASO",null,"TOTAL INSURED",null,null,"Annuities","Annuities",null,null,null,null,"of Business","of Business"]
[null,null,null,"Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan",null,"Actual","Plan",null,"Actual","Plan",null,"Actual","Plan"]
[]
["Revenues"]
["Premiums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"Insurance premiums",null,{"$f":"(-[36]Prem_Loss_Comm!E33/1000)","v":342783.06660999998},{"$f":"[36]Plan!P91+[36]Plan!P104","v":333242.26268082659},{"$f":"-[36]Prem_Loss_Comm!V33/1000","v":31682.287840000001},{"$f":"[36]Plan!P92+[36]Plan!P105","v":28138.787444236972},{"$f":"-[36]Prem_Loss_Comm!F33/1000","v":121256.56878},{"$f":"[36]Plan!P93+[36]Plan!P106","v":117787.76687787252},{"$f":"-[36]Prem_Loss_Comm!G33/1000","v":120335.23062000002},{"$f":"[36]Plan!P94+[36]Plan!P107","v":116624.1667371224},{"$f":"-[36]Prem_Loss_Comm!H33/1000","v":750.72119999999995},{"$f":"[36]Plan!P95+[36]Plan!P109","v":829.63792644750015},{"$f":"-[36]Prem_Loss_Comm!R33/1000","v":11349.274039999997},{"$f":"[36]Plan!P96+[36]Plan!P110","v":11214.958161460558},{"$f":"-[36]Prem_Loss_Comm!T33/1000","v":9293.7545900000005},{"$f":"[36]Plan!P97+[36]Plan!P114","v":9899.3536553085196},{"$f":"-[36]Prem_Loss_Comm!U33/1000","v":1721.42912},{"$f":"+[36]Plan!P98","v":1667.0074217306051},{"$f":"-[36]Prem_Loss_Comm!S33/1000","v":70104.847949999996},{"$f":"[36]Plan!P99+[36]Plan!P108","v":66626.997638660148},{"$f":"-[36]Prem_Loss_Comm!Q33/1000","v":5780.89959},{"$f":"[36]Plan!P117","v":6629.4230000000034},0,0,0,0,{"$f":"-[36]Prem_Loss_Comm!N33/1000","v":0},0,0,0,{"$f":"+[36]Prem_Loss_Comm!K33","v":0},0,{"$f":"+D11+H11+J11+L11+X11+Z11+AB11+AF11+AD11+N11+P11+T11+V11+F11+R11","v":715058.0803400001},{"$f":"+E11+I11+K11+M11+Y11+AA11+AC11+AG11+AE11+O11+Q11+U11+W11+G11+S11","v":692660.36154366576},null,0,0,null,0,0,null,{"$f":"AH11+AN11+AK11","v":715058.0803400001},{"$f":"AI11+AO11+AL11","v":692660.36154366576}]
[null,"ASO claims and fees",null,{"$f":"(-[36]Prem_Loss_Comm!E38/1000)","v":0},null,{"$f":"-[36]Prem_Loss_Comm!G38/1000","v":0},0,{"$f":"+[36]Prem_Loss_Comm!F38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!G38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!H38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!R38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!T38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!U38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!S38","v":0},0,{"$f":"+[36]Prem_Loss_Comm!Q38","v":0},0,{"$f":"-(([36]Prem_Loss_Comm!L33+[36]Prem_Loss_Comm!L38)/1000+[36]Prem_Loss_Comm!F38/1000+[36]Prem_Loss_Comm!J38/1000)","v":8568.2089099999994},{"$f":"[36]Plan!P100+[36]Plan!P111","v":8967.4687798944797},{"$f":"-(([36]Prem_Loss_Comm!M33+[36]Prem_Loss_Comm!M38)/1000+([36]Prem_Loss_Comm!E38/1000))","v":539.54174},{"$f":"[36]Plan!R100+[36]Plan!R111","v":0},{"$f":"-(+[36]Prem_Loss_Comm!N38)/1000","v":0},{"$f":"[36]Plan!T100+[36]Plan!T111","v":0},0,{"$f":"[36]Plan!P113","v":0},{"$f":"+[36]Prem_Loss_Comm!K38","v":0},{"$f":"[36]Plan!P101+[36]Plan!P112","v":0},{"$f":"+D12+H12+J12+L12+X12+Z12+AB12+AF12+AD12+N12+P12+T12+V12+F12+R12","v":9107.75065},8967.4687798944797,null,0,0,null,0,0,null,{"$f":"AH12+AN12+AK12","v":9107.75065},8967.4687798944797]
[null,"Annuity premiums",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"-[36]Prem_Loss_Comm!J33/1000","v":0},0,null,0,0,null,0,0]
[null,"   Total premiums",null,{"$f":"SUM(D11:D13)","v":342783.06660999998},333242.26268082659,31682.287840000001,28138.787444236972,121256.56878,117787.76687787252,120335.23062000002,116624.1667371224,750.72119999999995,829.63792644750015,11349.274039999997,{"$f":"SUM(O11:O13)","v":11214.958161460558},{"$f":"SUM(P11:P13)","v":9293.7545900000005},9899.3536553085196,1721.42912,1667.0074217306051,70104.847949999996,66626.997638660148,{"$f":"SUM(V11:V13)","v":5780.89959},{"$f":"SUM(W11:W13)","v":6629.4230000000034},8568.2089099999994,{"$f":"SUM(Y11:Y13)","v":8967.4687798944797},{"$f":"SUM(Z11:Z13)","v":539.54174},{"$f":"SUM(AA11:AA13)","v":0},{"$f":"SUM(AB11:AB13)","v":0},{"$f":"SUM(AC11:AC13)","v":0},0,0,0,0,{"$f":"SUM(AH11:AH13)","v":724165.83099000005},{"$f":"SUM(AI11:AI13)","v":701627.83032356028},null,{"$f":"SUM(AK11:AK13)","v":0},0,null,{"$f":"SUM(AN11:AN13)","v":0},0,null,{"$f":"SUM(AQ11:AQ13)","v":724165.83099000005},{"$f":"SUM(AR11:AR13)","v":701627.83032356028}]
[]
["Net investment income",null,null,{"$f":"'[36]DNLStat Insured Allocation'!E10+'[36]DNLStat Insured Allocation'!E16","v":6731},{"$f":"'[36]DL Insured LOB'!H75+'[36]DL Insured LOB'!S75-1","v":6495.4108114697065},0,{"$f":"'[36]DL Insured LOB'!J75+'[36]DL Insured LOB'!U75","v":382.28811946053304},{"$f":"'[36]DNLStat Insured Allocation'!E11+'[36]DNLStat Insured Allocation'!E17","v":837},{"$f":"'[36]DL Insured LOB'!M75+'[36]DL Insured LOB'!X75","v":1019.2258736339496},{"$f":"'[36]DNLStat Insured Allocation'!E12+'[36]DNLStat Insured Allocation'!E18","v":17469},{"$f":"'[36]DL Insured LOB'!K75+'[36]DL Insured LOB'!V75","v":15945.981215371339},{"$f":"'[36]DNLStat Insured Allocation'!E13+'[36]DNLStat Insured Allocation'!E19","v":2},{"$f":"'[36]DL Insured LOB'!G75","v":1.69776564972221},0,{"$f":"'[36]DL Insured LOB'!N75+'[36]DL Insured LOB'!Y75","v":55.99080638128418},0,{"$f":"'[36]DL Insured LOB'!O75+'[36]DL Insured LOB'!Z75","v":19.919868666750808},0,0,0,{"$f":"'[36]DL Insured LOB'!P75+'[36]DL Insured LOB'!AA75","v":80.414580918553341},{"$f":"'[36]DNLStat Insured Allocation'!E21","v":5360},{"$f":"'[36]DL Insured LOB'!AD75","v":3208.2116472100697},0,0,0,0,0,0,0,0,0,0,{"$f":"+D16+H16+J16+L16+X16+Z16+AB16+AF16+AD16+N16+P16+R16+T16+V16+F16","v":30399},{"$f":"+E16+G16+I16+K16+M16+O16+Q16+S16+U16+W16+Y16+AA16+AC16+AE16+AG16","v":27209.140688761909},null,{"$f":"+'[36]DNLStat Insured Allocation'!E22","v":391},{"$f":"'[36]DL Insured LOB'!AE75","v":288.12742574490289},null,{"$f":"'[36]DNL Stat LOB Actual'!F38","v":17890},{"$f":"'[36]DL Investments Detail'!C95-10","v":15464.77},null,{"$f":"AH16+AN16+AK16","v":48680},{"$f":"AI16+AO16+AL16","v":42962.038114506817}]
["Realized capital gains (losses) on bond disposals",null,null,{"$f":"+'[36]DNLStat Insured Allocation'!F10+'[36]DNLStat Insured Allocation'!F16","v":-34},0,{"$f":"'[36]DNLStat Insured Allocation'!H10+'[36]DNLStat Insured Allocation'!H16","v":0},0,{"$f":"+'[36]DNLStat Insured Allocation'!F11+'[36]DNLStat Insured Allocation'!F17","v":-5},null,{"$f":"+'[36]DNLStat Insured Allocation'!F12+'[36]DNLStat Insured Allocation'!F18","v":-89},0,{"$f":"'[36]DNLStat Insured Allocation'!F13+'[36]DNLStat Insured Allocation'!F19","v":0},0,{"$f":"'[36]DNLStat Insured Allocation'!H13+'[36]DNLStat Insured Allocation'!H19","v":0},0,0,0,0,0,0,0,{"$f":"+'[36]DNLStat Insured Allocation'!F21","v":-27},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+D17+H17+J17+L17+X17+Z17+AB17+AF17+AD17+N17+P17+R17+T17+V17+F17","v":-155},{"$f":"+E17+G17+I17+K17+M17+O17+Q17+S17+U17+W17+Y17+AA17+AC17+AE17+AG17","v":0},null,{"$f":"+'[36]DNLStat Insured Allocation'!F22","v":-2},0,null,{"$f":"'[36]DNL Stat LOB Actual'!F51","v":0},0,null,{"$f":"AH17+AN17+AK17","v":-157},0]
["Realized capital gains (losses) on derivatives",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,0,null,null,0,0]
["Realized capital losses - impairments",null,null,{"$f":"'[36]DNLStat Insured Allocation'!G10+'[36]DNLStat Insured Allocation'!G16-1","v":-54},{"$f":"'[36]DL Insured LOB'!H72+'[36]DL Insured LOB'!S72","v":-143.97788317457352},{"$f":"'[36]DNLStat Insured Allocation'!I10+'[36]DNLStat Insured Allocation'!I16","v":0},{"$f":"'[36]DL Insured LOB'!J72+'[36]DL Insured LOB'!U72","v":-8.2238629014443809},{"$f":"'[36]DNLStat Insured Allocation'!G17+'[36]DNLStat Insured Allocation'!G11","v":-6},{"$f":"'[36]DL Insured LOB'!M72+'[36]DL Insured LOB'!X72","v":-21.925802617666289},{"$f":"'[36]DNLStat Insured Allocation'!G12+'[36]DNLStat Insured Allocation'!G18","v":-137},{"$f":"'[36]DL Insured LOB'!K72+'[36]DL Insured LOB'!V72","v":-347.25904082314747},0,{"$f":"'[36]DL Insured LOB'!G72","v":-3.6522693830506395E-2},0,{"$f":"'[36]DL Insured LOB'!N72+'[36]DL Insured LOB'!Y72","v":-1.2044860721038853},0,{"$f":"'[36]DL Insured LOB'!O72+'[36]DL Insured LOB'!Z72","v":-0.42852042894063513},0,0,0,{"$f":"'[36]DL Insured LOB'!P72+'[36]DL Insured LOB'!AA72","v":-1.7298954769625321},{"$f":"'[36]DNLStat Insured Allocation'!G21","v":-42},{"$f":"'[36]DL Insured LOB'!AD72","v":-69.01572767342175},0,0,0,0,0,0,0,0,0,0,{"$f":"+D19+H19+J19+L19+X19+Z19+AB19+AF19+AD19+N19+P19+R19+T19+V19+F19","v":-239},-593.80174186209103,null,{"$f":"+'[36]DNLStat Insured Allocation'!G22","v":-3},{"$f":"'[36]DL Insured LOB'!AE72","v":-6.1982581379090034},null,{"$f":"+'[36]DNL Stat LOB Actual'!F64","v":0},{"$f":"'[36]DL Investments Detail'!C92","v":-400},null,-242,-1000]
[]
["Other income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Dental TPA fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Dental network leasing fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Other revenues",null,{"$f":"-'[36]Other Income'!C22/1000","v":-1.1398900000000001},{"$f":"[36]Plan!D165","v":220},0,0,{"$f":"-'[36]Other Income'!D22/1000","v":1284.0509599999998},{"$f":"[36]Plan!D166","v":1200},{"$f":"-'[36]Other Income'!E22/1000","v":1.8882300000000001},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1284.7992999999999,1420,null,{"$f":"-'[36]Other Income'!H22/1000","v":3008.4532599999998},{"$f":"[36]Plan!P161+[36]Plan!P162","v":2639.5302797335271},null,0,0,null,{"$f":"AH24+AN24+AK24","v":4293.2525599999999},{"$f":"AI24+AO24+AL24","v":4059.5302797335271}]
[null,"   Total other income",null,{"$f":"SUM(D24:D24)","v":-1.1398900000000001},220,0,0,1284.0509599999998,1200,1.8882300000000001,0,0,0,0,0,0,0,{"$f":"SUM(R24:R24)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Z24:Z24)","v":0},0,0,0,0,0,0,0,1284.7992999999999,1420,null,{"$f":"SUM(AK24:AK24)","v":3008.4532599999998},{"$f":"SUM(AL24:AL24)","v":2639.5302797335271},null,{"$f":"SUM(AN24:AN24)","v":0},{"$f":"SUM(AO24:AO24)","v":0},null,{"$f":"SUM(AQ24:AQ24)","v":4293.2525599999999},{"$f":"SUM(AR24:AR24)","v":4059.5302797335271}]
[]
["   Gross Revenues",null,null,{"$f":"+D25+D19+D18+D16+D14+D17","v":349424.92671999999},339813.6956091217,31682.287840000001,28512.851700796062,123366.61973999999,119985.06694888881,137580.11885000003,132222.8889116706,752.72119999999995,831.29916940339183,11349.274039999997,11269.744481769738,9293.7545900000005,9918.8450035463302,1721.42912,1667.0074217306051,70104.847949999996,66705.682324101741,11071.899590000001,9768.6189195366514,8568.2089099999994,8967.4687798944797,539.54174,0,0,0,0,0,0,0,755455.63029,{"$f":"+AI25+AI19+AI18+AI16+AI14+AI17","v":729663.16927046014},null,{"$f":"+AK25+AK19+AK18+AK16+AK14+AK17","v":3394.4532599999998},{"$f":"+AL25+AL19+AL18+AL16+AL14+AL17","v":2921.4594473405214},null,{"$f":"+AN25+AN19+AN18+AN16+AN14+AN17","v":17890},{"$f":"+AO25+AO19+AO18+AO16+AO14+AO17","v":15064.77},null,{"$f":"+AQ25+AQ19+AQ18+AQ16+AQ14+AQ17","v":776740.0835500001},{"$f":"+AR25+AR19+AR18+AR16+AR14+AR17","v":747649.39871780062}]
[]
["Less: ASO claims",null,null,{"$f":"-[36]Prem_Loss_Comm!E42/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(-[36]Prem_Loss_Comm!L67/1000)","v":-5829.5452400000004},{"$f":"-[36]Plan!P130-[36]Plan!P144","v":-6286.1332210140281},{"$f":"(-[36]Prem_Loss_Comm!M67/1000)","v":-50},{"$f":"-[36]Plan!R130-[36]Plan!R144","v":0},{"$f":"(-[36]Prem_Loss_Comm!N67/1000)","v":0},{"$f":"-[36]Plan!T130-[36]Plan!T144","v":0},{"$f":"-[36]Prem_Loss_Comm!O71/1000*0.666","v":0},0,{"$f":"-[36]Prem_Loss_Comm!K67/1000","v":0},0,{"$f":"+D29+H29+J29+L29+X29+Z29+AB29+AF29+AD29+N29+P29+R29+T29+V29+F29","v":-5879.5452400000004},{"$f":"+E29+G29+I29+K29+M29+O29+Q29+S29+U29+W29+Y29+AA29+AC29+AE29+AG29","v":-6286.1332210140281},null,0,0,null,0,0,null,{"$f":"AH29+AN29+AK29","v":-5879.5452400000004},{"$f":"AI29+AO29+AL29","v":-6286.1332210140281}]
[]
["Net Revenues",null,null,{"$f":"SUM(D27:D30)","v":349424.92671999999},{"$f":"SUM(E27:E30)","v":339813.6956091217},{"$f":"SUM(F27:F30)","v":31682.287840000001},{"$f":"SUM(G27:G30)","v":28512.851700796062},123366.61973999999,119985.06694888881,137580.11885000003,132222.8889116706,752.72119999999995,831.29916940339183,11349.274039999997,11269.744481769738,9293.7545900000005,9918.8450035463302,1721.42912,1667.0074217306051,70104.847949999996,66705.682324101741,11071.899590000001,9768.6189195366514,2738.663669999999,2681.3355588804516,489.54174,0,0,0,{"$f":"SUM(AD27:AD30)","v":0},0,0,0,749576.08504999999,{"$f":"SUM(AI27:AI30)","v":723377.03604944609},null,{"$f":"SUM(AK27:AK30)","v":3394.4532599999998},2921.4594473405214,null,{"$f":"SUM(AN27:AN30)","v":17890},{"$f":"SUM(AO27:AO30)","v":15064.77},null,{"$f":"SUM(AQ27:AQ30)","v":770860.53831000009},{"$f":"SUM(AR27:AR30)","v":741363.26549678657}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California Dental"]
["Incurred Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY 2024","3/31/24 YTD","3/31/25 YTD","3/31/24-3/31/25"]
[null,"Insurance claims and reserves",null,{"$f":"(+[36]Prem_Loss_Comm!E67/1000)-([36]Prem_Loss_Comm!E42/1000)+1","v":245254.44211999999},{"$f":"[36]Plan!P122+[36]Plan!P136","v":252806.77794781519},{"$f":"[36]Prem_Loss_Comm!V67/1000","v":7932.23542},{"$f":"[36]Plan!P123+[36]Plan!P137","v":12663.383999999998},{"$f":"[36]Prem_Loss_Comm!F67/1000","v":68992.768789999987},{"$f":"[36]Plan!P124+[36]Plan!P138","v":71164.994999999995},{"$f":"[36]Prem_Loss_Comm!G67/1000","v":88280.104219999994},{"$f":"[36]Plan!P125+[36]Plan!P139","v":86065.506708552028},{"$f":"[36]Prem_Loss_Comm!H67/1000","v":441.64711},{"$f":"[36]Plan!P126+[36]Plan!P140","v":541.59452428824591},{"$f":"[36]Prem_Loss_Comm!R67/1000","v":2479.2587100000001},{"$f":"[36]Plan!P127+[36]Plan!P141","v":3364.7840799186301},{"$f":"[36]Prem_Loss_Comm!T67/1000","v":1154.89966},{"$f":"[36]Plan!P128+[36]Plan!P142","v":2970.052446329988},{"$f":"+[36]Prem_Loss_Comm!U67/1000","v":909.85146999999995},{"$f":"+[36]Plan!P129+[36]Plan!P143","v":834.0223249433285},{"$f":"[36]Prem_Loss_Comm!S67/1000","v":40685.321349999991},{"$f":"[36]Plan!P133+[36]Plan!P148","v":38722.892999999996},{"$f":"[36]Prem_Loss_Comm!Q67/1000","v":7741.6699700000008},{"$f":"[36]Plan!P152","v":6370.8760000000002},0,0,0,0,0,0,0,0,0,0,{"$f":"+D34+H34+J34+L34+X34+Z34+AB34+AF34+AD34+N34+P34+R34+T34+V34+F34","v":463872.19881999993},{"$f":"+E34+G34+I34+K34+M34+O34+Q34+S34+U34+W34+Y34+AA34+AC34+AE34+AG34","v":475504.88603184739},null,0,0,null,0,0,null,{"$f":"AH34+AN34+AK344","v":463872.19881999993},{"$f":"AI34+AO34+AL34","v":475504.88603184739},null,"Comm Exp",{"$f":"L39*1000","v":83952.75},{"$f":"'March 2024'!L39*1000","v":23792.2},{"$f":"'March 2025'!L39*1000","v":17649.59},{"$f":"AU34-AV34+AW34","v":77810.14},"linked"]
[null,"Annuity claims and reserves",null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"[36]Prem_Loss_Comm!J67/1000","v":358.32587000001223},{"$f":"+[36]Plan!P158","v":256.58570061445465},null,0,0,null,{"$f":"AH35+AN35+AK35","v":358.32587000001223},{"$f":"AI35+AO35+AL35","v":256.58570061445465},null,"G&A Exp",{"$f":"L40*1000","v":303596.31},{"$f":"'March 2024'!L40*1000","v":69263.309999999983},{"$f":"'March 2025'!L40*1000","v":72788},{"$f":"AU35-AV35+AW35","v":307121},"linked"]
["Total Incurred Benefits",null,null,{"$f":"SUM(D34:D35)","v":245254.44211999999},252806.77794781519,{"$f":"SUM(F34:F35)","v":7932.23542},12663.383999999998,68992.768789999987,71164.994999999995,88280.104219999994,86065.506708552028,441.64711,541.59452428824591,{"$f":"SUM(N34:N35)","v":2479.2587100000001},3364.7840799186301,1154.89966,2970.052446329988,909.85146999999995,834.0223249433285,40685.321349999991,38722.892999999996,7741.6699700000008,6370.8760000000002,0,0,{"$f":"SUM(Z34:Z35)","v":0},0,0,0,0,0,0,0,463872.19881999993,{"$f":"SUM(AI34:AI35)","v":475504.88603184739},null,{"$f":"SUM(AK34:AK35)","v":358.32587000001223},{"$f":"SUM(AL34:AL35)","v":256.58570061445465},null,{"$f":"SUM(AN34:AN35)","v":0},{"$f":"SUM(AO34:AO35)","v":0},null,{"$f":"SUM(AQ34:AQ35)-1","v":464229.52468999993},{"$f":"SUM(AR34:AR35)","v":475761.47173246183}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dental Premium - CA only",68796,20842,20335,{"$f":"AU37-AV37+AW37","v":68289},"source: Premiums By LOB Crystal report - CA only"]
["Operating Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA Prem Taxes (2.35% prem tax rate)",{"$f":"AU37*0.0235","v":1616.7059999999999},null,null,{"$f":"AX37*0.0235","v":1604.7915},"calc"]
[null,"Commission expense",null,{"$f":"[36]Prem_Loss_Comm!E79/1000-[36]Prem_Loss_Comm!Q82/1000+1","v":28927.834460000002},{"$f":"[36]Plan!P34+[36]Plan!P47+[36]Plan!P65+[36]Plan!P88","v":28131.357496961667},{"$f":"[36]Prem_Loss_Comm!V79/1000+1","v":2902.5156200000001},{"$f":"[36]Plan!P35+[36]Plan!P48+[36]Plan!P66","v":2607.6167605931923},{"$f":"[36]Prem_Loss_Comm!F79/1000","v":15139.566130000001},{"$f":"[36]Plan!P36+[36]Plan!P49+[36]Plan!P67","v":15305.716799640337},{"$f":"[36]Prem_Loss_Comm!G79/1000","v":13366.956689999999},{"$f":"[36]Plan!P37+[36]Plan!P50+[36]Plan!P68","v":13476.919988770418},{"$f":"[36]Prem_Loss_Comm!H79/1000","v":83.952749999999995},{"$f":"[36]Plan!P38+[36]Plan!P51+[36]Plan!P69","v":87.111982276987519},{"$f":"[36]Prem_Loss_Comm!R79/1000","v":1540.22074},{"$f":"[36]Plan!P39+[36]Plan!P52+[36]Plan!P70","v":1606.917774032956},{"$f":"[36]Prem_Loss_Comm!T79/1000","v":1501.34474},{"$f":"[36]Plan!P42+[36]Plan!P55","v":1406.2706924567258},{"$f":"[36]Prem_Loss_Comm!U79/1000","v":285.00920000000002},{"$f":"+[36]Plan!P43+[36]Plan!P56","v":270.88870603122331},{"$f":"[36]Prem_Loss_Comm!S79/1000","v":6931.9486000000006},{"$f":"[36]Plan!P44+[36]Plan!P57+[36]Plan!P74","v":6719.3751140785653},{"$f":"[36]Prem_Loss_Comm!Q79/1000","v":14.15681},{"$f":"[36]Plan!P60","v":99.441348135000013},{"$f":"[36]Prem_Loss_Comm!L79/1000","v":36.278289999999998},{"$f":"[36]Plan!P40+[36]Plan!P53","v":20.661106503188524},{"$f":"-[36]Prem_Loss_Comm!M79/1000","v":-0.91100999999999999},{"$f":"[36]Plan!R40+[36]Plan!R53","v":0},{"$f":"-[36]Prem_Loss_Comm!N79/1000","v":0},{"$f":"[36]Plan!T40+[36]Plan!T53","v":0},0,{"$f":"+[36]Plan!P73","v":172.51951401411063},0,{"$f":"[36]Plan!P41+[36]Plan!P54","v":0},{"$f":"+D39+H39+J39+L39+X39+Z39+AB39+AF39+AD39+N39+P39+R39+T39+V39+F39","v":70728.873019999999},{"$f":"+E39+G39+I39+K39+M39+O39+Q39+S39+U39+W39+Y39+AA39+AC39+AE39+AG39","v":69904.797283494379},null,0,0,null,0,0,null,{"$f":"AH39+AN39+AK39","v":70728.873019999999},{"$f":"AI39+AO39+AL39","v":69904.797283494379},null,"Dental premium - all states",742249,211594,163925,{"$f":"AU39-AV39+AW39","v":694580},"source: Premiums By LOB Crystal report - all states"]
[null,"General and administrative expense",null,{"$f":"'[36]G&A'!F30+1","v":46854.129669999995},{"$f":"'[36]G&A'!F7+'[36]G&A'!F8+'[36]G&A'!F9+'[36]G&A'!F10+'[36]G&A'!F11+'[36]G&A'!F12+'[36]G&A'!F13+'[36]G&A'!F14+'[36]G&A'!F15+'[36]G&A'!F16+'[36]G&A'!F17+'[36]G&A'!F18","v":43321.718000000008},{"$f":"'[36]G&A'!G30","v":5192.7590799999998},{"$f":"+'[36]G&A'!G7+'[36]G&A'!G8+'[36]G&A'!G9+'[36]G&A'!G10+'[36]G&A'!G11+'[36]G&A'!G12+'[36]G&A'!G13+'[36]G&A'!G14+'[36]G&A'!G15+'[36]G&A'!G16+'[36]G&A'!G17+'[36]G&A'!G18","v":4552.4409999999998},{"$f":"'[36]G&A'!I30-'Dec 2024'!X40","v":28340.147074499993},{"$f":"'[36]G&A'!I7+'[36]G&A'!I8+'[36]G&A'!I9+'[36]G&A'!I10+'[36]G&A'!I11+'[36]G&A'!I12+'[36]G&A'!I13+'[36]G&A'!I14+'[36]G&A'!I15+'[36]G&A'!I16+'[36]G&A'!I17+'[36]G&A'!I18","v":25607.37},{"$f":"'[36]G&A'!H30","v":22200.703950000003},{"$f":"'[36]G&A'!H7+'[36]G&A'!H8+'[36]G&A'!H9+'[36]G&A'!H10+'[36]G&A'!H11+'[36]G&A'!H12+'[36]G&A'!H13+'[36]G&A'!H14+'[36]G&A'!H15+'[36]G&A'!H16+'[36]G&A'!H17+'[36]G&A'!H18","v":20257.366000000002},{"$f":"'[36]G&A'!J30-'Dec 2024'!AF40","v":303.59631000000002},{"$f":"'[36]G&A'!J7+'[36]G&A'!J8+'[36]G&A'!J9+'[36]G&A'!J10+'[36]G&A'!J11+'[36]G&A'!J12+'[36]G&A'!J13+'[36]G&A'!J14+'[36]G&A'!J15+'[36]G&A'!J16+'[36]G&A'!J17+'[36]G&A'!J18","v":318.96500000000003},{"$f":"'[36]G&A'!K30","v":2762.3979400000003},{"$f":"'[36]G&A'!K7+'[36]G&A'!K8+'[36]G&A'!K9+'[36]G&A'!K10+'[36]G&A'!K11+'[36]G&A'!K12+'[36]G&A'!K13+'[36]G&A'!K14+'[36]G&A'!K15+'[36]G&A'!K16+'[36]G&A'!K17+'[36]G&A'!K18","v":2535.0110000000004},{"$f":"'[36]G&A'!M30","v":2561.3609500000002},{"$f":"'[36]G&A'!M7+'[36]G&A'!M8+'[36]G&A'!M9+'[36]G&A'!M10+'[36]G&A'!M11+'[36]G&A'!M12+'[36]G&A'!M13+'[36]G&A'!M14+'[36]G&A'!M15+'[36]G&A'!M16+'[36]G&A'!M17+'[36]G&A'!M18","v":2315.5430000000001},{"$f":"+'[36]G&A'!N30","v":584.53819999999996},{"$f":"+'[36]G&A'!N7+'[36]G&A'!N8+'[36]G&A'!N9+'[36]G&A'!N10+'[36]G&A'!N11+'[36]G&A'!N12+'[36]G&A'!N13+'[36]G&A'!N14+'[36]G&A'!N15+'[36]G&A'!N16+'[36]G&A'!N17+'[36]G&A'!N18","v":507.93499999999995},{"$f":"'[36]G&A'!L30","v":10353.72747},{"$f":"'[36]G&A'!L7+'[36]G&A'!L8+'[36]G&A'!L9+'[36]G&A'!L10+'[36]G&A'!L11+'[36]G&A'!L12+'[36]G&A'!L13+'[36]G&A'!L14+'[36]G&A'!L15+'[36]G&A'!L16+'[36]G&A'!L17+'[36]G&A'!L18","v":8775.0249999999996},{"$f":"'[36]G&A'!E30","v":1884.4657999999997},{"$f":"+'[36]G&A'!E7+'[36]G&A'!E8+'[36]G&A'!E9+'[36]G&A'!E10+'[36]G&A'!E11+'[36]G&A'!E12+'[36]G&A'!E13+'[36]G&A'!E14+'[36]G&A'!E15+'[36]G&A'!E16+'[36]G&A'!E17+'[36]G&A'!E18","v":2057.3530000000001},{"$f":"X12*0.05","v":428.41044549999998},{"$f":"+'[36]G&A'!R7+'[36]G&A'!R8+'[36]G&A'!R9+'[36]G&A'!R10+'[36]G&A'!R11+'[36]G&A'!R12+'[36]G&A'!R13+'[36]G&A'!R14+'[36]G&A'!R15+'[36]G&A'!R16+'[36]G&A'!R17+'[36]G&A'!R18","v":1500},null,0,null,0,0,0,{"$f":"AF12*0.05","v":0},{"$f":"AG12*0.05","v":0},{"$f":"+D40+H40+J40+L40+X40+Z40+AB40+AF40+AD40+N40+P40+R40+T40+V40+F40","v":121466.23689},111748.72700000001,null,{"$f":"'[36]G&A'!D30","v":674.41706999999997},{"$f":"'[36]G&A'!D7+'[36]G&A'!D8+'[36]G&A'!D9+'[36]G&A'!D10+'[36]G&A'!D11+'[36]G&A'!D12+'[36]G&A'!D13+'[36]G&A'!D14+'[36]G&A'!D15+'[36]G&A'!D16+'[36]G&A'!D17+'[36]G&A'!D18","v":523.30899999999997},null,{"$f":"'[36]G&A'!O30","v":4516.3191900000002},{"$f":"'[36]G&A'!O7+'[36]G&A'!O8+'[36]G&A'!O9+'[36]G&A'!O10+'[36]G&A'!O11+'[36]G&A'!O12+'[36]G&A'!O13+'[36]G&A'!O14+'[36]G&A'!O15+'[36]G&A'!O16+'[36]G&A'!O17+'[36]G&A'!O18-AO52","v":4020.7200000000112},null,{"$f":"AH40+AN40+AK40","v":126656.97314999999},{"$f":"AI40+AO40+AL40","v":116292.75600000002},null,null,{"$f":"AU37/AU39","v":9.2685877650222501E-2},null,null,{"$f":"AX37/AX39","v":9.8316968527743381E-2},"calc"]
[null,"ACA Tax",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,0]
[null,"Premium tax",null,{"$f":"'[36]Prem Taxes'!F7","v":4213.2166190952976},{"$f":"[36]Plan!P3+[36]Plan!P16","v":4198.8525097784141},{"$f":"'[36]Prem Taxes'!F8","v":395.8441954574667},{"$f":"[36]Plan!P4+[36]Plan!P17","v":360.17647928623336},{"$f":"'[36]Prem Taxes'!F9","v":1442.3285159260022},{"$f":"[36]Plan!P5+[36]Plan!P18","v":1507.683416036768},{"$f":"'[36]Prem Taxes'!F10","v":1327.1403664487343},{"$f":"[36]Plan!P6+[36]Plan!P19","v":1667.7255843408509},{"$f":"'[36]Prem Taxes'!F11","v":9.003352131000284},{"$f":"[36]Plan!P7+[36]Plan!P20","v":10.868256836462255},{"$f":"'[36]Prem Taxes'!F12","v":137.99169809833828},{"$f":"[36]Plan!P8+[36]Plan!P21","v":143.55146446669517},{"$f":"'[36]Prem Taxes'!F14","v":112.05652876403541},{"$f":"[36]Plan!P11+[36]Plan!P24","v":116.81237313264053},{"$f":"'[36]Prem Taxes'!F15","v":20.011282594499068},{"$f":"+[36]Plan!P12+[36]Plan!P25","v":20.837592771632565},{"$f":"'[36]Prem Taxes'!F13","v":848.66147676446451},{"$f":"[36]Plan!P13+[36]Plan!P26","v":839.50017024711758},{"$f":"'[36]Prem Taxes'!F16","v":72.405823636519301},{"$f":"[36]Plan!P29","v":86.845444037900009},0,{"$f":"[36]Plan!P9+[36]Plan!P22","v":0},0,{"$f":"[36]Plan!R9+[36]Plan!R22","v":0},0,{"$f":"[36]Plan!T9+[36]Plan!T22","v":0},0,0,0,{"$f":"[36]Plan!P10+[36]Plan!P23","v":0},8578.6598589163568,8952.8532909347141,null,0,0,null,0,0,null,{"$f":"AH42+AN42+AK42","v":8578.6598589163568},{"$f":"AI42+AO42+AL42","v":8952.8532909347141},null,"CA Commissions exp",{"$f":"AU40*AU34","v":7781.234314899717},null,null,{"$f":"AX40*AX34","v":7650.0570855193064}]
["Total Operating Expenses",null,null,{"$f":"SUM(D39:D42)","v":79995.180749095292},75651.928006740098,8491.1188954574664,{"$f":"SUM(G39:G42)","v":7520.2342398794253},44922.041720426001,42420.770215677105,36894.801006448739,{"$f":"SUM(K39:K42)","v":35402.011573111267},396.55241213100027,416.94523911344982,4440.6103780983385,4285.4802384996519,4174.7622187640354,3838.6260655893666,{"$f":"SUM(R39:R42)","v":889.55868259449903},799.66129880285587,18134.337546764466,16333.900284325684,1971.0284336365189,2243.6397921729003,464.68873550000001,1520.6611065031884,{"$f":"SUM(Z39:Z42)","v":-0.91100999999999999},0,0,0,0,172.51951401411063,0,0,200773.76976891636,{"$f":"SUM(AI39:AI42)","v":190606.37757442912},null,{"$f":"SUM(AK39:AK42)","v":674.41706999999997},{"$f":"SUM(AL39:AL42)","v":523.30899999999997},null,{"$f":"SUM(AN39:AN42)","v":4516.3191900000002},{"$f":"SUM(AO39:AO42)","v":4020.7200000000112},null,{"$f":"SUM(AQ39:AQ42)-1","v":205963.50602891634},{"$f":"SUM(AR39:AR42)","v":195150.40657442913},null,"CA G&A exp",{"$f":"AU40*AU35","v":28139.090443719022},null,null,{"$f":"AX40*AX35","v":30195.205691209074}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA Premium tax",{"$f":"AU38","v":1616.7059999999999},null,null,{"$f":"AX38","v":1604.7915}]
["Total Incurred Benefits and Operating Expenses",null,null,{"$f":"+D36+D43","v":325249.6228690953},328458.70595455531,16423.354315457465,{"$f":"+G36+G43","v":20183.618239879423},113914.81051042599,113585.76521567709,125174.90522644873,121467.5182816633,838.19952213100032,{"$f":"+M36+M43","v":958.53976340169572},6919.8690880983386,7650.2643184182816,{"$f":"+P36+P43","v":5329.6618787640355},{"$f":"+Q36+Q43","v":6808.6785119193546},{"$f":"+R36+R43","v":1799.4101525944989},{"$f":"+S36+S43","v":1633.6836237461844},58819.658896764457,55056.793284325679,9712.6984036365193,8614.5157921729005,464.68873550000001,1520.6611065031884,-0.91100999999999999,0,0,0,0,172.51951401411063,0,0,664645.96858891635,{"$f":"+AI36+AI43","v":666111.26360627648},null,{"$f":"+AK36+AK43","v":1032.7429400000121},{"$f":"+AL36+AL43","v":779.89470061445468},null,{"$f":"+AN36+AN43","v":4516.3191900000002},{"$f":"+AO36+AO43","v":4020.7200000000112},null,{"$f":"+AQ36+AQ43","v":670193.03071891633},{"$f":"+AR36+AR43","v":670911.87830689095}]
[]
["Pre-tax Income (Loss) Before GIAS, TB & C&S Allocation",null,null,{"$f":"D31-D45","v":24175.303850904689},{"$f":"E31-E45","v":11354.989654566394},{"$f":"F31-F45","v":15258.933524542535},8329.2334609166392,9451.8092295740062,6399.3017332117161,12405.213623551303,{"$f":"K31-K45","v":10755.370630007295},-85.478322131000368,{"$f":"M31-M45","v":-127.24059399830389},4429.404951901658,3619.4801633514562,{"$f":"P31-P45","v":3964.092711235965},3110.1664916269756,{"$f":"R31-R45","v":-77.981032594498856},{"$f":"S31-S45","v":33.323797984420708},11285.189053235539,11648.889039776062,1359.2011863634816,1154.1031273637509,2273.9749344999991,1160.6744523772632,{"$f":"Z31-Z45","v":490.45274999999998},{"$f":"AA31-AA45","v":0},{"$f":"AB31-AB45","v":0},{"$f":"AC31-AC45","v":0},0,-172.51951401411063,0,0,84930.116461083642,{"$f":"AI31-AI45","v":57265.772443169612},null,{"$f":"AK31-AK45","v":2361.7103199999874},{"$f":"AL31-AL45","v":2141.5647467260669},null,{"$f":"AN31-AN45","v":13373.68081},{"$f":"AO31-AO45","v":11044.049999999988},null,{"$f":"AQ31-AQ45-1","v":100666.50759108376},{"$f":"AR31-AR45","v":70451.387189895613},null,"Earned Premium (Pt 1 Summary of Data 1.1)",{"$f":"'Pt 1 Summary of Data'!M21","v":69331},null,null,{"$f":"'Pt 1 Summary of Data'!N21","v":69292}]
["C&S Earnings Allocation",null,null,{"$f":"'[36]C&S Allocation'!C25","v":8165.7306812508959},{"$f":"'[36]C&S Allocation'!G25","v":6743.2997101916671},{"$f":"'[36]C&S Allocation'!C26","v":108.62286636684321},{"$f":"'[36]C&S Allocation'!G26","v":89.701286006595936},{"$f":"'[36]C&S Allocation'!C27","v":270.83129325293072},{"$f":"'[36]C&S Allocation'!G27","v":223.65378587572454},{"$f":"'[36]C&S Allocation'!C28","v":1970.6118185829166},{"$f":"'[36]C&S Allocation'!G28","v":1627.3407272250158},{"$f":"'[36]C&S Allocation'!C29","v":7.1434307046660743},{"$f":"'[36]C&S Allocation'!G29","v":5.8990794677017027},{"$f":"'[36]C&S Allocation'!C30","v":57.450498240318609},{"$f":"'[36]C&S Allocation'!G30","v":47.442898040198564},{"$f":"'[36]C&S Allocation'!C31","v":61.56961268899483},{"$f":"'[36]C&S Allocation'!G31","v":50.844482583242737},0,{"$f":"'[36]C&S Allocation'!E32","v":0},{"$f":"'[36]C&S Allocation'!C32","v":379.912245097658},{"$f":"'[36]C&S Allocation'!G32","v":313.73336107539308},{"$f":"'[36]C&S Allocation'!C33","v":263.3923097170221},{"$f":"'[36]C&S Allocation'!G33","v":217.51063745705434},0,0,0,0,0,0,0,0,0,0,{"$f":"+D48+H48+J48+L48+X48+Z48+AB48+AF48+AD48+N48+P48+R48+T48+V48+F48","v":11285.264755902244},{"$f":"+E48+G48+I48+K48+M48+O48+Q48+S48+U48+W48+Y48+AA48+AC48+AE48+AG48","v":9319.4259679225961},null,{"$f":"'[36]C&S Allocation'!C34","v":190.75718883751907},{"$f":"'[36]C&S Allocation'!G34","v":157.52820493560145},null,{"$f":"-AK48-AH48","v":-11476.021944739763},{"$f":"-AI48-AL48","v":-9476.9541728581971},null,{"$f":"AQ32-AQ46","v":0},0,null,"Claims Incurred (Pt 1 Summary of Data 2.1)",{"$f":"'Pt 1 Summary of Data'!M24","v":49143},null,null,{"$f":"'Pt 1 Summary of Data'!N24","v":43739}]
["Pre-tax Income (Loss) Before GIAS and Total Blue Costs",null,null,{"$f":"D47+D48","v":32341.034532155587},{"$f":"E47+E48","v":18098.28936475806},{"$f":"F47+F48","v":15367.556390909378},8418.9347469232343,9722.6405228269377,6622.9555190874407,14375.825442134219,12382.711357232311,-78.334891426334295,-121.3415145306022,4486.8554501419767,3666.9230613916548,4025.6623239249598,3161.0109742102181,-77.981032594498856,33.323797984420708,11665.101298333197,11962.622400851455,1622.5934960805037,1371.6137648208053,2273.9749344999991,1160.6744523772632,490.45274999999998,0,0,0,0,-172.51951401411063,0,0,96215.381216985887,{"$f":"AI47+AI48","v":66585.198411092206},null,{"$f":"AK47+AK48","v":2552.4675088375066},2299.0929516616684,null,{"$f":"AN47+AN48","v":1897.6588652602368},{"$f":"AO47+AO48","v":1567.0958271417912},null,{"$f":"AQ47+AQ48","v":100666.50759108376},{"$f":"AR47+AR48","v":70451.387189895613},null,"Net Income",{"$f":"AU47-AU48-AU42-AU43-AU44","v":-17349.030758618737},null,null,{"$f":"AX47-AX48-AX42-AX43-AX44","v":-13897.054276728381}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIT at 21%",{"$f":"AU49*0.21","v":-3643.2964593099346},null,null,{"$f":"AX49*0.21","v":-2918.3813981129597},"Note: since FIT taxes are a benefit, do not enter anything on tab Pt 1 line 3.1a"]
["GIAS Write-off",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2893,0,null,{"$f":"AN51","v":2893},0]
["Total Blue Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'[36]G&A'!P31","v":5495.4578299999994},{"$f":"+'[36]G&A'!Q7+'[36]G&A'!Q8+'[36]G&A'!Q9+'[36]G&A'!Q10+'[36]G&A'!Q11+'[36]G&A'!Q12+'[36]G&A'!Q13+'[36]G&A'!Q14+'[36]G&A'!Q15+'[36]G&A'!Q16+'[36]G&A'!Q17+'[36]G&A'!Q18-2","v":5057.8669999999902},null,{"$f":"AN52","v":5495.4578299999994},{"$f":"SUM(AO52)","v":5057.8669999999902}]
[]
["Pre-tax Income (Loss) ",null,null,{"$f":"D49-D52","v":32341.034532155587},{"$f":"E49-E52","v":18098.28936475806},{"$f":"F49-F52","v":15367.556390909378},8418.9347469232343,9722.6405228269377,6622.9555190874407,14375.825442134219,12382.711357232311,-78.334891426334295,-121.3415145306022,4486.8554501419767,3666.9230613916548,4025.6623239249598,3161.0109742102181,-77.981032594498856,33.323797984420708,11665.101298333197,11962.622400851455,{"$f":"V49-V52","v":1622.5934960805037},1371.6137648208053,2273.9749344999991,1160.6744523772632,490.45274999999998,0,0,0,0,-172.51951401411063,0,0,{"$f":"AH49-AH52","v":96215.381216985887},{"$f":"AI49-AI52","v":66585.198411092206},{"$f":"AJ31-AJ45","v":0},{"$f":"AK49-AK52","v":2552.4675088375066},2299.0929516616684,{"$f":"AM31-AM45","v":0},{"$f":"AN49-AN51-AN52","v":-6490.7989647397626},{"$f":"AO49-AO51-AO52","v":-3490.771172858199},{"$f":"AP31-AP45","v":0},{"$f":"AQ49-AQ51-AQ52","v":92278.049761083763},{"$f":"AR49-AR51-AR52-1","v":65392.520189895622}]
[]
["Insurance loss ratio (insurance benefit expenses / insurance premiums)",null,null,{"$f":"+D34/D11","v":0.71548003973906105},{"$f":"+E34/E11","v":0.75862759997506368},0.25036813818682863,0.45003303802963091,0.56898170123200464,0.60417984724837304,0.73361810805660777,0.73797317585598399,0.58829710683540049,0.65280829988974498,0.2184508631355597,0.30002644962880753,0.12426621004633177,{"$f":"+Q34/Q11","v":0.30002488543656586},{"$f":"+R34/R11","v":0.52854425397427918},0.50031110484048569,0.58034961261191909,0.58118922317356736,1.3391808401916907,0.96100007496881656,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+AH34/AH11","v":0.64871960974056153},0.68649068494714383,null,null,null,null,null,null,null,{"$f":"+AQ34/AQ11","v":0.64871960974056153},{"$f":"+(AR34)/AR11","v":0.68649068494714383}]
[]
["G&A Expense ratio (G&A expenses / insurance premiums incl. ASO)",null,null,{"$f":"+D40/(D11+D12)","v":0.1366874103011281},{"$f":"+E40/(E11+E12)","v":0.1300006717380045},0.1639010132798541,0.16178525848072295,0.23372050982176895,0.21740262744390795,0.18449047577850564,0.17369784125155871,0.40440620299519986,0.38446289620076124,0.24339864649175402,0.22603838226623027,0.27560023510369019,0.23390850358783699,0.33956565112596676,0.30469870342429961,0.14768917946137561,0.13170374339227786,0.32598141010091469,0.31033666127504594,0.05,0.16727128209947897,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+AH40/(AH11+AH12)","v":0.16773262655039203},0.15927065913059116,{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"+AQ40/(AQ11+AQ12)","v":0.1749005099796665},{"$f":"+AR40/(AR11+AR12)","v":0.16574706842282874}]
[]
["Pre-tax Margin (Pre-tax income (loss) / total premiums)",null,null,{"$f":"D49/(D11+D12+D29)","v":9.4348401897435222E-2},{"$f":"E49/(E11+E12+E29)","v":5.430970615540525E-2},0.48505197820680418,0.29919323153519511,8.0182382040407743E-2,5.6227872338851702E-2,0.11946480983221651,0.10617620432944791,-0.10434618261257882,-0.14625839858862907,0.39534294742802578,0.32696716372895501,0.43315780344109123,0.31931488501929911,-4.530017047376244E-2,1.9990191735214699E-2,0.16639507308614307,0.17954617234485998,0.2806818334792256,0.20689791024359203,0.83032281744183645,0.43287176367507096,1.0018609444824869,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AH49/(AH11+AH12+AH29)","v":0.13395129926018623},9.5758960937549653E-2,{"$f":"+AJ47/AJ14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"AQ49/(AQ11+AQ12+AQ29)","v":0.140148168756936},{"$f":"AR49/(AR11+AR12+AR29)","v":0.10131908885007614}]

{"sheet":"March 2024","index":8,"n_rows":59,"n_cols":40,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,35,5,36],[44,0,44,1],[54,0,54,1],[56,0,56,1],[5,25,5,26],[5,27,5,28],[58,0,58,1],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[1,0,1,1],[4,3,4,30],[4,32,4,33],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,29,5,30]]}
["DEARBORN LIFE INSURANCE COMPANY"]
["MARCH 2024"]
["INCOME STATEMENT BY LINE OF BUSINESS"]
["$'(000)'s"]
[null,null,null,"Insured",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annuities",null,null,"C&S","C&S",null,"Total All Lines","Total All Lines"]
[null,null,null,"Life",null,"ADD",null,"STD",null,"LTD",null,"Dental",null,"Critical Illness",null,"Accident",null,"Hospital Indemnity",null,"Vision",null,"Individual Life",null,"STD ASO",null,"LTD ASO",null,"DENTAL ASO",null,"TOTAL INSURED",null,null,"Annuities","Annuities",null,null,null,null,"of Business","of Business"]
[null,null,null,"Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan",null,"Actual","Plan",null,"Actual","Plan",null,"Actual","Plan"]
[]
["Revenues"]
["Premiums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"Insurance premiums",null,{"$f":"(-[37]Prem_Loss_Comm!E33/1000)+[37]Prem_Loss_Comm!E14/1000","v":85011.973030000008},{"$f":"[37]Plan!P91+[37]Plan!P104","v":82725.404290993305},{"$f":"-[37]Prem_Loss_Comm!T33/1000","v":7847.310590000001},{"$f":"[37]Plan!P92+[37]Plan!P105","v":7109.0893781249833},{"$f":"-[37]Prem_Loss_Comm!F33/1000","v":29232.890380000001},{"$f":"[37]Plan!P93+[37]Plan!P106","v":29255.60900158163},{"$f":"-[37]Prem_Loss_Comm!G33/1000","v":30565.273550000005},{"$f":"[37]Plan!P94+[37]Plan!P107","v":28989.238339033422},{"$f":"-[37]Prem_Loss_Comm!H33/1000","v":211.69790000000003},{"$f":"[37]Plan!P95+[37]Plan!P109","v":215.29948587040587},{"$f":"-[37]Prem_Loss_Comm!P33/1000","v":2719.2287100000003},{"$f":"[37]Plan!P96+[37]Plan!P110","v":2732.2336815599101},{"$f":"-[37]Prem_Loss_Comm!R33/1000","v":2296.4683599999998},{"$f":"[37]Plan!P97+[37]Plan!P114","v":2414.3654326466908},{"$f":"-[37]Prem_Loss_Comm!S33/1000","v":244.18995999999999},{"$f":"+[37]Plan!P98","v":327.82627612683768},{"$f":"-[37]Prem_Loss_Comm!Q33/1000","v":16839.562280000002},{"$f":"[37]Plan!P99+[37]Plan!P108","v":16197.033166993921},{"$f":"-[37]Prem_Loss_Comm!O33/1000","v":1434.4746299999999},{"$f":"[37]Plan!P117","v":1657.3557500000011},0,0,0,0,0,0,{"$f":"+D11+H11+J11+L11+X11+AB11+Z11+N11+P11+T11+V11+F11+R11","v":176403.06939000002},{"$f":"+E11+I11+K11+M11+Y11+AC11+AA11+O11+Q11+U11+W11+G11+S11","v":171623.45480293108},null,0,0,null,0,0,null,{"$f":"AD11+AJ11+AG11","v":176403.06939000002},{"$f":"AE11+AK11+AH11","v":171623.45480293108}]
[null,"ASO claims and fees",null,{"$f":"(-[37]Prem_Loss_Comm!E38/1000)-[37]Prem_Loss_Comm!E14/1000","v":138.24196000000001},null,{"$f":"-[37]Prem_Loss_Comm!G38/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"-(([37]Prem_Loss_Comm!L33+[37]Prem_Loss_Comm!L38)/1000+[37]Prem_Loss_Comm!F38/1000+[37]Prem_Loss_Comm!J38/1000)","v":2040.4918300000002},{"$f":"[37]Plan!P100+[37]Plan!P111","v":2533.4278901708212},{"$f":"-[37]Prem_Loss_Comm!M33","v":0},{"$f":"[37]Plan!P113","v":0},{"$f":"-([37]Prem_Loss_Comm!K33+[37]Prem_Loss_Comm!K38+[37]Prem_Loss_Comm!H38)/1000","v":0},{"$f":"[37]Plan!P101+[37]Plan!P112","v":0},{"$f":"+D12+H12+J12+L12+X12+AB12+Z12+R12","v":2178.7337900000002},{"$f":"+E12+I12+K12+M12+Y12+AC12+AA12+O12+Q12+U12+W12","v":2533.4278901708212},null,0,0,null,0,0,null,{"$f":"AD12+AJ12+AG12","v":2178.7337900000002},2533.4278901708212]
[null,"Annuity premiums",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,{"$f":"+D13+H13+J13+L13+X13+AB13+Z13","v":0},{"$f":"+E13+I13+K13+M13+Y13+AC13+AA13+O13+Q13+U13+W13","v":0},null,{"$f":"-[37]Prem_Loss_Comm!J33/1000","v":0},0,null,0,0,null,0,0]
[null,"   Total premiums",null,{"$f":"SUM(D11:D13)","v":85150.214990000008},82725.404290993305,{"$f":"SUM(F11:F13)","v":7847.310590000001},7109.0893781249833,29232.890380000001,29255.60900158163,30565.273550000005,28989.238339033422,211.69790000000003,215.29948587040587,{"$f":"SUM(N11:N13)","v":2719.2287100000003},{"$f":"SUM(O11:O13)","v":2732.2336815599101},{"$f":"SUM(P11:P13)","v":2296.4683599999998},2414.3654326466908,244.18995999999999,327.82627612683768,16839.562280000002,16197.033166993921,{"$f":"SUM(V11:V13)","v":1434.4746299999999},{"$f":"SUM(W11:W13)","v":1657.3557500000011},2040.4918300000002,{"$f":"SUM(Y11:Y13)","v":2533.4278901708212},0,0,0,0,{"$f":"SUM(AD11:AD13)","v":178581.80318000002},{"$f":"SUM(AE11:AE13)","v":174156.88269310191},null,{"$f":"SUM(AG11:AG13)","v":0},0,null,{"$f":"SUM(AJ11:AJ13)","v":0},0,null,{"$f":"SUM(AM11:AM13)","v":178581.80318000002},{"$f":"SUM(AN11:AN13)","v":174156.88269310191}]
[]
["Net investment income",null,null,{"$f":"'[37]DNLStat Insured Allocation'!E10+'[37]DNLStat Insured Allocation'!E16+1","v":1742},{"$f":"'[37]DL Insured LOB'!H75+'[37]DL Insured LOB'!S75","v":1604.095181307333},0,{"$f":"'[37]DL Insured LOB'!J75+'[37]DL Insured LOB'!U75","v":94.429221604031113},{"$f":"'[37]DNLStat Insured Allocation'!E11+'[37]DNLStat Insured Allocation'!E17","v":207},{"$f":"'[37]DL Insured LOB'!M75+'[37]DL Insured LOB'!X75","v":251.75960482831232},{"$f":"'[37]DNLStat Insured Allocation'!E12+'[37]DNLStat Insured Allocation'!E18","v":4226},{"$f":"'[37]DL Insured LOB'!K75+'[37]DL Insured LOB'!V75","v":3938.2393315155978},{"$f":"'[37]DNLStat Insured Allocation'!E13+'[37]DNLStat Insured Allocation'!E19","v":1},{"$f":"'[37]DL Insured LOB'!G75","v":0.41936612886522506},0,{"$f":"'[37]DL Insured LOB'!N75+'[37]DL Insured LOB'!Y75","v":13.830323241610767},0,{"$f":"'[37]DL Insured LOB'!O75+'[37]DL Insured LOB'!Z75","v":4.9204189115534422},0,0,0,{"$f":"'[37]DL Insured LOB'!P75+'[37]DL Insured LOB'!AA75","v":19.863254689863069},{"$f":"'[37]DNLStat Insured Allocation'!E21","v":1329},{"$f":"'[37]DL Insured LOB'!AD75","v":792.4623161570928},0,0,0,0,0,0,{"$f":"+D16+H16+J16+L16+X16+AB16+Z16+N16+P16+R16+T16+V16+F16","v":7505},{"$f":"+E16+G16+I16+K16+M16+O16+Q16+S16+U16+W16+Y16+AA16+AC16","v":6720.0190183842606},null,{"$f":"+'[37]DNLStat Insured Allocation'!E22","v":100},{"$f":"'[37]DL Insured LOB'!AE75","v":71.170531206302215},null,{"$f":"'[37]DNL Stat LOB Actual'!F38","v":4298},{"$f":"'[37]DL Investments Detail'!C95-2","v":3869.2092499999999},null,{"$f":"AD16+AJ16+AG16-1","v":11902},{"$f":"AE16+AK16+AH16","v":10660.398799590563}]
["Realized capital gains (losses) on bond disposals",null,null,null,0,{"$f":"'[37]DNLStat Insured Allocation'!H10+'[37]DNLStat Insured Allocation'!H16","v":0},0,null,null,null,0,{"$f":"'[37]DNLStat Insured Allocation'!F13+'[37]DNLStat Insured Allocation'!F19","v":0},0,{"$f":"'[37]DNLStat Insured Allocation'!H13+'[37]DNLStat Insured Allocation'!H19","v":0},0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"+E17+I17+K17+M17+Y17+AC17+AA17+O17+Q17+U17+W17","v":0},null,{"$f":"'[37]DNL Stat LOB Actual'!D51-AG18","v":0},0,null,{"$f":"'[37]DNL Stat LOB Actual'!F51","v":0},0,null,{"$f":"AD17+AJ17+AG17","v":0},0]
["Realized capital gains (losses) on derivatives",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,{"$f":"+D18+H18+J18+L18+X18+AB18+Z18","v":0},0,null,0,null,null,0,null,null,0,0]
["Realized capital losses - impairments",null,null,{"$f":"'[37]DNLStat Insured Allocation'!G10+'[37]DNLStat Insured Allocation'!G16","v":0},{"$f":"'[37]DL Insured LOB'!H72+'[37]DL Insured LOB'!S72","v":-35.99447079364338},{"$f":"'[37]DNLStat Insured Allocation'!I10+'[37]DNLStat Insured Allocation'!I16","v":0},{"$f":"'[37]DL Insured LOB'!J72+'[37]DL Insured LOB'!U72","v":-2.0559657253610952},{"$f":"'[37]DNLStat Insured Allocation'!G17+'[37]DNLStat Insured Allocation'!G11","v":0},{"$f":"'[37]DL Insured LOB'!M72+'[37]DL Insured LOB'!X72","v":-5.4814506544165722},{"$f":"'[37]DNLStat Insured Allocation'!G12+'[37]DNLStat Insured Allocation'!G18","v":0},{"$f":"'[37]DL Insured LOB'!K72+'[37]DL Insured LOB'!V72","v":-86.814760205786868},0,{"$f":"'[37]DL Insured LOB'!G72","v":-9.1306734576265987E-3},0,{"$f":"'[37]DL Insured LOB'!N72+'[37]DL Insured LOB'!Y72","v":-0.30112151802597131},0,{"$f":"'[37]DL Insured LOB'!O72+'[37]DL Insured LOB'!Z72","v":-0.10713010723515878},0,0,0,{"$f":"'[37]DL Insured LOB'!P72+'[37]DL Insured LOB'!AA72","v":-0.43247386924063302},{"$f":"'[37]DNLStat Insured Allocation'!G22","v":0},{"$f":"'[37]DL Insured LOB'!AD72","v":-17.253931918355438},0,0,0,0,0,0,{"$f":"+D19+H19+J19+L19+X19+AB19+Z19+V19","v":0},{"$f":"+E19+I19+K19+M19+Y19+AC19+AA19+O19+Q19+U19+W19+G19","v":-148.45043546552276},null,{"$f":"'[37]DNL Stat LOB Actual'!D64","v":0},{"$f":"'[37]DL Insured LOB'!AE72","v":-1.5495645344772508},null,{"$f":"+'[37]DNL Stat LOB Actual'!F64","v":0},{"$f":"'[37]DL Investments Detail'!C92","v":-100},null,0,-250]
[]
["Other income"]
[null,"Dental TPA fees"]
[null,"Dental network leasing fees"]
[null,"Other revenues",null,{"$f":"-'[37]Other Income'!C22/1000","v":0.85438000000000003},{"$f":"[37]Plan!D165","v":55},0,0,{"$f":"-'[37]Other Income'!D22/1000","v":311.36484000000002},{"$f":"[37]Plan!D166","v":300},{"$f":"-'[37]Other Income'!E22/1000","v":0.57591999999999999},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+D24+H24+J24+L24+X24+AB24+Z24","v":312.79514},{"$f":"+E24+I24+K24+M24+Y24+AC24+AA24+O24+Q24+U24+W24","v":355},null,{"$f":"-'[37]Other Income'!H22/1000","v":761.15299000000005},{"$f":"[37]Plan!P161+[37]Plan!P162","v":674.2040593974283},null,0,0,null,{"$f":"AD24+AJ24+AG24","v":1073.94813},{"$f":"AE24+AK24+AH24","v":1029.2040593974284}]
[null,"   Total other income",null,{"$f":"SUM(D24:D24)","v":0.85438000000000003},55,0,0,311.36484000000002,300,0.57591999999999999,0,0,0,0,0,0,0,{"$f":"SUM(R24:R24)","v":0},0,0,0,0,0,0,0,0,0,0,0,312.79514,355,null,{"$f":"SUM(AG24:AG24)","v":761.15299000000005},{"$f":"SUM(AH24:AH24)","v":674.2040593974283},null,{"$f":"SUM(AJ24:AJ24)","v":0},{"$f":"SUM(AK24:AK24)","v":0},null,{"$f":"SUM(AM24:AM24)","v":1073.94813},{"$f":"SUM(AN24:AN24)","v":1029.2040593974284}]
[]
["   Gross Revenues",null,null,{"$f":"+D25+D19+D18+D16+D14+D17","v":86893.069370000012},84348.505001507001,7847.310590000001,7201.462634003653,29751.255219999999,29801.887155755525,34791.849470000008,32840.662910343235,212.69790000000003,215.70972132581346,2719.2287100000003,2745.7628832834948,2296.4683599999998,2419.1787214510091,244.18995999999999,327.82627612683768,16839.562280000002,16216.463947814544,2763.4746299999997,2432.5641342387385,2040.4918300000002,2533.4278901708212,0,0,0,0,186399.59832000002,{"$f":"+AE25+AE19+AE18+AE16+AE14+AE17","v":181083.45127602064},null,{"$f":"+AG25+AG19+AG18+AG16+AG14+AG17","v":861.15299000000005},{"$f":"+AH25+AH19+AH18+AH16+AH14+AH17","v":743.82502606925334},null,{"$f":"+AJ25+AJ19+AJ18+AJ16+AJ14+AJ17","v":4298},{"$f":"+AK25+AK19+AK18+AK16+AK14+AK17","v":3769.2092499999999},null,{"$f":"+AM25+AM19+AM18+AM16+AM14+AM17","v":191557.75131000002},{"$f":"+AN25+AN19+AN18+AN16+AN14+AN17","v":185596.4855520899}]
[]
["Less: ASO claims",null,null,{"$f":"-[37]Prem_Loss_Comm!E42/1000","v":-11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(-[37]Prem_Loss_Comm!L67/1000)","v":-1375.5074999999999},{"$f":"-[37]Plan!P130-[37]Plan!P144","v":-1835.941418399314},{"$f":"-[37]Prem_Loss_Comm!M71/1000*0.666","v":0},0,{"$f":"-[37]Prem_Loss_Comm!K67/1000","v":0},0,{"$f":"+D29+H29+J29+L29+X29+AB29+Z29","v":-1386.5074999999999},{"$f":"+E29+I29+K29+M29+Y29+AC29+AA29+O29+Q29+U29+W29+G29","v":-1835.941418399314},null,0,0,null,0,0,null,{"$f":"AD29+AJ29+AG29","v":-1386.5074999999999},{"$f":"AE29+AK29+AH29","v":-1835.941418399314}]
[]
["Net Revenues",null,null,{"$f":"SUM(D27:D30)","v":86882.069370000012},{"$f":"SUM(E27:E30)","v":84348.505001507001},{"$f":"SUM(F27:F30)","v":7847.310590000001},{"$f":"SUM(G27:G30)","v":7201.462634003653},29751.255219999999,29801.887155755525,34791.849470000008,32840.662910343235,212.69790000000003,215.70972132581346,2719.2287100000003,2745.7628832834948,2296.4683599999998,2419.1787214510091,244.18995999999999,327.82627612683768,16839.562280000002,16216.463947814544,2763.4746299999997,2432.5641342387385,664.98433000000023,697.48647177150724,{"$f":"SUM(Z27:Z30)","v":0},0,0,0,185013.09082000001,{"$f":"SUM(AE27:AE30)","v":179247.50985762133},null,{"$f":"SUM(AG27:AG30)","v":861.15299000000005},743.82502606925334,null,{"$f":"SUM(AJ27:AJ30)","v":4298},{"$f":"SUM(AK27:AK30)","v":3769.2092499999999},null,{"$f":"SUM(AM27:AM30)+1","v":190172.24381000001},{"$f":"SUM(AN27:AN30)-1","v":183759.54413369059}]
[]
["Incurred Benefits"]
[null,"Insurance claims and reserves",null,{"$f":"(+[37]Prem_Loss_Comm!E67/1000)-([37]Prem_Loss_Comm!E42/1000)-1","v":58787.812900000012},{"$f":"[37]Plan!P122+[37]Plan!P136","v":65367.688332817008},{"$f":"[37]Prem_Loss_Comm!T67/1000","v":1160.6698000000001},{"$f":"[37]Plan!P123+[37]Plan!P137","v":3279.2809999999999},{"$f":"[37]Prem_Loss_Comm!F67/1000","v":16623.03786},{"$f":"[37]Plan!P124+[37]Plan!P138","v":17615.735000000001},{"$f":"[37]Prem_Loss_Comm!G67/1000","v":21782.178050000006},{"$f":"[37]Plan!P125+[37]Plan!P139","v":21326.498872777927},{"$f":"[37]Prem_Loss_Comm!H67/1000","v":116.13592},{"$f":"[37]Plan!P126+[37]Plan!P140","v":144.36500102361151},{"$f":"[37]Prem_Loss_Comm!P67/1000","v":356.88495},{"$f":"[37]Plan!P127+[37]Plan!P141","v":815.23200368797177},{"$f":"[37]Prem_Loss_Comm!R67/1000","v":265.38028000000003},{"$f":"[37]Plan!P128+[37]Plan!P142","v":720.3922075816406},{"$f":"+[37]Prem_Loss_Comm!S67/1000","v":142.08799999999999},{"$f":"+[37]Plan!P129+[37]Plan!P143","v":163.02951562700576},{"$f":"[37]Prem_Loss_Comm!Q67/1000","v":10564.67481},{"$f":"[37]Plan!P133+[37]Plan!P148","v":9360.869999999999},{"$f":"[37]Prem_Loss_Comm!O67/1000","v":1894.7033099999996},{"$f":"[37]Plan!P152","v":1592.7190000000001},0,0,0,0,0,0,{"$f":"+D34+H34+J34+L34+R34+X34+AB34+Z34+N34+P34+T34+V34+F34","v":111693.56588000002},{"$f":"+E34+I34+K34+M34+Y34+AC34+AA34+O34+Q34+W34+U34+G34+S34","v":120385.81093351515},null,0,0,null,0,0,null,{"$f":"AD34+AJ34+AG343","v":111693.56588000002},{"$f":"AE34+AK34+AH34","v":120385.81093351515}]
[null,"Annuity claims and reserves",null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,{"$f":"+D35+H35+J35+L35+X35+AB35+Z35","v":0},{"$f":"+E35+I35+K35+M35+Y35+AC35+AA35","v":0},null,{"$f":"[37]Prem_Loss_Comm!J67/1000","v":17.545660000003874},{"$f":"+[37]Plan!P158","v":64.966843479296401},null,0,0,null,{"$f":"AD35+AJ35+AG35","v":17.545660000003874},{"$f":"AE35+AK35+AH35","v":64.966843479296401}]
["Total Incurred Benefits",null,null,{"$f":"SUM(D34:D35)","v":58787.812900000012},65367.688332817008,{"$f":"SUM(F34:F35)","v":1160.6698000000001},3279.2809999999999,16623.03786,17615.735000000001,21782.178050000006,21326.498872777927,116.13592,144.36500102361151,{"$f":"SUM(N34:N35)","v":356.88495},815.23200368797177,265.38028000000003,720.3922075816406,142.08799999999999,163.02951562700576,10564.67481,9360.869999999999,1894.7033099999996,1592.7190000000001,0,0,0,0,0,0,111693.56588000002,{"$f":"SUM(AE34:AE35)","v":120385.81093351515},null,{"$f":"SUM(AG34:AG35)","v":17.545660000003874},{"$f":"SUM(AH34:AH35)","v":64.966843479296401},null,{"$f":"SUM(AJ34:AJ35)","v":0},{"$f":"SUM(AK34:AK35)","v":0},null,{"$f":"SUM(AM34:AM35)+1","v":111712.11154000003},{"$f":"SUM(AN34:AN35)","v":120450.77777699445}]
[]
["Operating Expenses"]
[null,"Commission expense",null,{"$f":"[37]Prem_Loss_Comm!E79/1000-[37]Prem_Loss_Comm!O82/1000","v":7210.8175299999994},{"$f":"[37]Plan!P34+[37]Plan!P47+[37]Plan!P65+[37]Plan!P88","v":7013.5036071649301},{"$f":"[37]Prem_Loss_Comm!T79/1000","v":731.00266999999997},{"$f":"[37]Plan!P35+[37]Plan!P48+[37]Plan!P66","v":663.63041527001565},{"$f":"[37]Prem_Loss_Comm!F79/1000","v":3825.3030800000001},{"$f":"[37]Plan!P36+[37]Plan!P49+[37]Plan!P67","v":3808.7476794140448},{"$f":"[37]Prem_Loss_Comm!G79/1000","v":3460.21},{"$f":"[37]Plan!P37+[37]Plan!P50+[37]Plan!P68","v":3362.7779421951259},{"$f":"[37]Prem_Loss_Comm!H79/1000","v":23.792200000000001},{"$f":"[37]Plan!P38+[37]Plan!P51+[37]Plan!P69","v":22.606446016392631},{"$f":"[37]Prem_Loss_Comm!P79/1000","v":360.32103999999998},{"$f":"[37]Plan!P39+[37]Plan!P52+[37]Plan!P70","v":391.6780172414866},{"$f":"[37]Prem_Loss_Comm!R79/1000","v":359.47009000000003},{"$f":"[37]Plan!P42+[37]Plan!P55","v":342.20146869068355},{"$f":"[37]Prem_Loss_Comm!S79/1000","v":39.639470000000003},{"$f":"+[37]Plan!P43+[37]Plan!P56","v":53.271769870611209},{"$f":"[37]Prem_Loss_Comm!Q79/1000","v":1656.94472},{"$f":"[37]Plan!P44+[37]Plan!P57+[37]Plan!P74","v":1640.9006454228445},{"$f":"[37]Prem_Loss_Comm!O79/1000","v":3.7881199999999997},{"$f":"[37]Plan!P60","v":24.86033703375},{"$f":"[37]Prem_Loss_Comm!L79/1000","v":10.266540000000001},{"$f":"[37]Plan!P40+[37]Plan!P53","v":5.7580449576923982},0,{"$f":"+[37]Plan!P73","v":43.129878503527664},0,{"$f":"[37]Plan!P41+[37]Plan!P54","v":0},{"$f":"+D39+H39+J39+L39+R39+X39+AB39+Z39+N39+P39+T39+V39+F39","v":17681.555460000007},{"$f":"+E39+I39+K39+M39+Y39+AC39+AA39+O39+Q39+U39+W39+G39+S39","v":17373.066251781107},null,0,0,null,0,0,null,{"$f":"AD39+AJ39+AG39","v":17681.555460000007},{"$f":"AE39+AK39+AH39","v":17373.066251781107}]
[null,"General and administrative expense",null,{"$f":"'[37]G&A'!F30","v":12958.97767},{"$f":"'[37]G&A'!F7+'[37]G&A'!F8+'[37]G&A'!F9","v":12206.49},{"$f":"'[37]G&A'!G30","v":1479.8980799999999},{"$f":"+'[37]G&A'!G7+'[37]G&A'!G8+'[37]G&A'!G9","v":1299.098},{"$f":"'[37]G&A'!I30-'March 2024'!X40","v":7181.7909285000005},{"$f":"'[37]G&A'!I7+'[37]G&A'!I8+'[37]G&A'!I9","v":6781.7019999999993},{"$f":"'[37]G&A'!H30","v":5375.7999499999996},{"$f":"'[37]G&A'!H7+'[37]G&A'!H8+'[37]G&A'!H9","v":5028.6230000000005},{"$f":"'[37]G&A'!J30-'March 2024'!AB40","v":69.26330999999999},{"$f":"'[37]G&A'!J7+'[37]G&A'!J8+'[37]G&A'!J9","v":76.244},{"$f":"'[37]G&A'!K30","v":746.15994000000001},{"$f":"'[37]G&A'!K7+'[37]G&A'!K8+'[37]G&A'!K9","v":707.11699999999996},{"$f":"'[37]G&A'!M30","v":723.68394999999998},{"$f":"'[37]G&A'!M7+'[37]G&A'!M8+'[37]G&A'!M9","v":668.30400000000009},{"$f":"+'[37]G&A'!N30","v":201.9152},{"$f":"+'[37]G&A'!N7+'[37]G&A'!N8+'[37]G&A'!N9","v":151.952},{"$f":"'[37]G&A'!L30","v":2368.5194700000002},{"$f":"'[37]G&A'!L7+'[37]G&A'!L8+'[37]G&A'!L9","v":2309.1190000000001},{"$f":"'[37]G&A'!E30","v":454.2208},{"$f":"+'[37]G&A'!E7+'[37]G&A'!E8+'[37]G&A'!E9","v":506.97700000000003},{"$f":"X12*0.05","v":102.02459150000001},{"$f":"+'[37]G&A'!R7+'[37]G&A'!R8+'[37]G&A'!R9","v":375},0,0,{"$f":"AB12*0.05","v":0},{"$f":"AC12*0.05","v":0},{"$f":"D40+H40+J40+L40+N40+P40+R40+T40+X40+AB40+Z40+V40+F40","v":31662.253889999996},{"$f":"+E40+I40+K40+M40+Y40+AC40+AA40+O40+Q40+U40+W40+G40+S40","v":30110.625999999993},null,{"$f":"'[37]G&A'!D30","v":128.59507000000002},{"$f":"'[37]G&A'!D7+'[37]G&A'!D8+'[37]G&A'!D9","v":129.32400000000001},null,{"$f":"'[37]G&A'!O30","v":1043.5461900000003},{"$f":"'[37]G&A'!O7+'[37]G&A'!O8+'[37]G&A'!O9-AK51","v":971.78030000000263},null,{"$f":"AD40+AJ40+AG40","v":32834.395149999997},{"$f":"AE40+AK40+AH40","v":31211.730299999996}]
[null,"ACA Tax",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,0]
[null,"Premium tax",null,{"$f":"'[37]Prem Taxes'!F7","v":1033.9566813755446},{"$f":"[37]Plan!P3+[37]Plan!P16","v":1042.3400940665156},{"$f":"'[37]Prem Taxes'!F8","v":98.176832641287945},{"$f":"[37]Plan!P4+[37]Plan!P17","v":90.996344039999812},{"$f":"'[37]Prem Taxes'!F9","v":321.73915879796556},{"$f":"[37]Plan!P5+[37]Plan!P18","v":374.47179522024481},{"$f":"'[37]Prem Taxes'!F10","v":117.85781199464944},{"$f":"[37]Plan!P6+[37]Plan!P19","v":414.54610824817792},{"$f":"'[37]Prem Taxes'!F11","v":2.6219055611642652},{"$f":"[37]Plan!P7+[37]Plan!P20","v":2.8204232649023191},{"$f":"'[37]Prem Taxes'!F12","v":32.147397885570079},{"$f":"[37]Plan!P8+[37]Plan!P21","v":34.972591123966858},{"$f":"'[37]Prem Taxes'!F14","v":25.94028191816416},{"$f":"[37]Plan!P11+[37]Plan!P24","v":28.489512105230958},{"$f":"'[37]Prem Taxes'!F15","v":2.5105291155517588},{"$f":"+[37]Plan!P12+[37]Plan!P25","v":4.0978284515854781},{"$f":"'[37]Prem Taxes'!F13","v":196.38643377542911},{"$f":"[37]Plan!P13+[37]Plan!P26","v":204.08261790412337},{"$f":"'[37]Prem Taxes'!F16","v":19.167476934673186},{"$f":"[37]Plan!P29","v":21.711361009474999},0,{"$f":"[37]Plan!P9+[37]Plan!P22","v":0},0,0,0,{"$f":"[37]Plan!P10+[37]Plan!P23","v":0},{"$f":"+D42+H42+J42+L42+X42+AB42+Z42+N42+P42+R42+T42+V42+F42","v":1850.5045100000002},{"$f":"+E42+I42+K42+M42+Y42+AC42+AA42+O42+Q42+U42+W42+G42+S42","v":2218.5286754342214},null,0,0,null,0,0,null,{"$f":"AD42+AJ42+AG42","v":1850.5045100000002},{"$f":"AE42+AK42+AH42","v":2218.5286754342214}]
["Total Operating Expenses",null,null,{"$f":"SUM(D39:D42)","v":21203.751881375545},20262.333701231444,2309.0775826412878,{"$f":"SUM(G39:G42)","v":2053.7247593100155},11328.833167297966,10964.921474634288,8953.8677619946484,{"$f":"SUM(K39:K42)","v":8805.9470504433048},95.677415561164267,101.67086928129494,1138.6283778855702,1133.7676083654535,1109.094321918164,1038.9949807959147,{"$f":"SUM(R39:R42)","v":244.06519911555174},209.32159832219668,4221.8506237754291,4154.1022633269677,477.17639693467316,553.54869804322504,112.29113150000002,380.75804495769239,0,43.129878503527664,0,0,51194.313860000002,{"$f":"SUM(AE39:AE42)","v":49702.220927215327},null,{"$f":"SUM(AG39:AG42)","v":128.59507000000002},{"$f":"SUM(AH39:AH42)","v":129.32400000000001},null,{"$f":"SUM(AJ39:AJ42)","v":1043.5461900000003},{"$f":"SUM(AK39:AK42)","v":971.78030000000263},null,{"$f":"SUM(AM39:AM42)","v":52366.455119999999},{"$f":"SUM(AN39:AN42)+1","v":50804.325227215326}]
[]
["Total Incurred Benefits and Operating Expenses",null,null,{"$f":"+D36+D43","v":79991.56478137555},85630.022034048452,3469.7473826412879,{"$f":"+G36+G43","v":5333.0057593100155},27951.871027297966,28580.656474634288,30736.045811994656,30132.445923221232,211.81333556116425,{"$f":"+M36+M43","v":246.03587030490644},1495.5133278855701,1948.9996120534252,{"$f":"+P36+P43","v":1374.4746019181641},{"$f":"+Q36+Q43","v":1759.3871883775553},{"$f":"+R36+R43","v":386.15319911555173},{"$f":"+S36+S43","v":372.35111394920244},14786.52543377543,13514.972263326967,2371.8797069346729,2146.2676980432252,112.29113150000002,380.75804495769239,0,43.129878503527664,0,0,162887.87974000003,{"$f":"+AE36+AE43","v":170088.03186073049},null,{"$f":"+AG36+AG43","v":146.14073000000388},{"$f":"+AH36+AH43","v":194.29084347929643},null,{"$f":"+AJ36+AJ43","v":1043.5461900000003},{"$f":"+AK36+AK43","v":971.78030000000263},null,{"$f":"+AM36+AM43","v":164078.56666000001},{"$f":"+AN36+AN43-1","v":171254.10300420978}]
[]
["Pre-tax Income (Loss) Before TB & C&S Allocation",null,null,{"$f":"D31-D45","v":6890.5045886244625},{"$f":"E31-E45","v":-1281.517032541451},{"$f":"F31-F45","v":4377.563207358713},1868.4568746936375,1799.384192702033,1221.2306811212366,4055.8036580053522,{"$f":"K31-K45","v":2708.216987122003},0.88456443883578117,{"$f":"M31-M45","v":-30.326148979092977},1223.7153821144302,796.76327123006968,{"$f":"P31-P45","v":921.99375808183572},659.79153307345382,{"$f":"R31-R45","v":-141.96323911555174},{"$f":"S31-S45","v":-44.524837822364759},2053.0368462245715,2701.491684487577,391.59492306532684,286.29643619551325,552.69319850000022,316.72842681381485,0,-43.129878503527664,0,0,22125.211079999979,{"$f":"AE31-AE45","v":9159.4779968908406},null,{"$f":"AG31-AG45","v":715.0122599999961},{"$f":"AH31-AH45","v":549.53418258995691},null,{"$f":"AJ31-AJ45","v":3254.45381},{"$f":"AK31-AK45","v":2797.4289499999973},null,{"$f":"AM31-AM45-1","v":26092.677150000003},{"$f":"AN31-AN45","v":12505.441129480809}]
["C&S Earnings Allocation",null,null,{"$f":"'[37]C&S Allocation'!C25","v":1987.1113797750997},{"$f":"'[37]C&S Allocation'!G25","v":1708.0601616089009},{"$f":"'[37]C&S Allocation'!C26","v":26.433119372518789},{"$f":"'[37]C&S Allocation'!G26","v":22.721100893882351},{"$f":"'[37]C&S Allocation'!C27","v":65.906159023562608},{"$f":"'[37]C&S Allocation'!G27","v":56.650918402746548},{"$f":"'[37]C&S Allocation'!C28","v":479.54375703529308},{"$f":"'[37]C&S Allocation'!G28","v":412.20114558095196},{"$f":"'[37]C&S Allocation'!C29","v":1.7383370818816104},{"$f":"'[37]C&S Allocation'!G29","v":1.4942213844829872},{"$f":"'[37]C&S Allocation'!C30","v":13.980443794112295},{"$f":"'[37]C&S Allocation'!G30","v":12.017161860870761},{"$f":"'[37]C&S Allocation'!C31","v":14.982820619293932},{"$f":"'[37]C&S Allocation'!G31","v":12.878774319758968},0,{"$f":"'[37]C&S Allocation'!E32","v":0},{"$f":"'[37]C&S Allocation'!C32","v":92.450752421070149},{"$f":"'[37]C&S Allocation'!G32","v":79.467838958815634},{"$f":"'[37]C&S Allocation'!C33","v":64.095899854459191},{"$f":"'[37]C&S Allocation'!G33","v":55.094874991992818},0,0,0,0,0,0,{"$f":"+D48+H48+J48+L48+X48+AB48+Z48+N48+P48+T48+V48+F48","v":2746.2426689772915},{"$f":"+E48+I48+K48+M48+Y48+AC48+AA48+O48+Q48+U48+W48+G48+S48","v":2360.5861980024033},null,{"$f":"'[37]C&S Allocation'!C34","v":46.420313810162888},{"$f":"'[37]C&S Allocation'!G34","v":39.901481877425802},null,{"$f":"-AG48-AD48","v":-2792.6629827874544},{"$f":"-AE48-AH48","v":-2400.4876798798291},null,{"$f":"AM32-AM46","v":0},0]
["Pre-tax Income (Loss) Before Total Blue Costs",null,null,{"$f":"D47+D48","v":8877.6159683995629},{"$f":"E47+E48","v":426.54312906744985},{"$f":"F47+F48","v":4403.9963267312314},1891.1779755875198,1865.2903517255957,1277.8815995239831,4535.3474150406455,3120.4181327029551,2.6229015207173916,-28.83192759460999,1237.6958259085425,808.78043309094039,936.97657870112971,672.67030739321274,-141.96323911555174,-44.524837822364759,2145.4875986456418,2780.9595234463927,455.690822919786,341.39131118750606,552.69319850000022,316.72842681381485,0,-43.129878503527664,0,0,24871.45374897727,{"$f":"AE47+AE48","v":11520.064194893244},null,{"$f":"AG47+AG48","v":761.43257381015894},589.43566446738271,null,{"$f":"AJ47+AJ48","v":461.79082721254554},{"$f":"AK47+AK48","v":396.94127012016816},null,{"$f":"AM47+AM48","v":26092.677150000003},{"$f":"AN47+AN48","v":12505.441129480809}]
[]
["Total Blue Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'[37]G&A'!P31","v":1580.92895},{"$f":"+'[37]G&A'!Q7+'[37]G&A'!Q8+'[37]G&A'!Q9","v":1353.3396999999973},null,{"$f":"AJ51","v":1580.92895},{"$f":"SUM(AK51)","v":1353.3396999999973}]
[]
["Pre-tax Income (Loss) ",null,null,{"$f":"D49-D51","v":8877.6159683995629},{"$f":"E49-E51","v":426.54312906744985},{"$f":"F49-F51","v":4403.9963267312314},1891.1779755875198,1865.2903517255957,1277.8815995239831,4535.3474150406455,3120.4181327029551,2.6229015207173916,-28.83192759460999,1237.6958259085425,808.78043309094039,936.97657870112971,672.67030739321274,-141.96323911555174,-44.524837822364759,2145.4875986456418,2780.9595234463927,{"$f":"V49-V51","v":455.690822919786},341.39131118750606,552.69319850000022,316.72842681381485,0,-43.129878503527664,0,0,{"$f":"AD49-AD51","v":24871.45374897727},{"$f":"AE49-AE51","v":11520.064194893244},{"$f":"AF31-AF45","v":0},{"$f":"AG49-AG51","v":761.43257381015894},589.43566446738271,{"$f":"AI31-AI45","v":0},{"$f":"AJ49-AJ51","v":-1119.1381227874544},{"$f":"AK49-AK51","v":-956.39842987982911},{"$f":"AL31-AL45","v":0},{"$f":"AM49-AM51","v":24511.748200000002},{"$f":"AN49-AN51","v":11152.101429480812}]
[]
["Insurance loss ratio (insurance benefit expenses / insurance premiums)",null,null,{"$f":"+D34/D11","v":0.69152392074530833},{"$f":"+E34/E11","v":0.79017671648821286},0.14790669831254888,0.46128003539954193,0.56864161032029981,0.6021318851727766,0.71264462967647813,0.73566951374718348,0.548592687976593,0.67053109969109914,0.13124491834303997,0.29837565109823716,0.1155601725773396,{"$f":"+Q34/Q11","v":0.29837745265923882},{"$f":"+R34/R11","v":0.58187486496168805},0.49730460155039191,0.62737229355108859,0.57793732367452599,1.3208343113046201,0.96100007496881645,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.63317246273681749,0.70145313804427123,null,null,null,null,null,null,null,{"$f":"+AM34/AM11","v":0.63317246273681749},{"$f":"+(AN34)/AN11","v":0.70145313804427123}]
[]
["G&A Expense ratio (G&A expenses / insurance premiums incl. ASO)",null,null,{"$f":"+D40/(D11+D12)","v":0.15218960599831599},{"$f":"+E40/(E11+E12)","v":0.14755431060889934},0.18858665819674147,0.18273760968562136,0.24567501999095856,0.23180860803934603,0.17587933381999779,0.17346516459623781,0.32717995785503767,0.35412996780630107,0.27440131727647138,0.25880546190920489,0.31512907497667419,0.27680316780686665,0.82687756695647929,0.4635137908872472,0.14065208053614561,0.14256431879793205,0.31664610199484672,0.30589509826119088,0.05,0.14802079090347225,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.17729832114017963,0.17289368949638778,{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"+AM40/(AM11+AM12)","v":0.18386193086484207},{"$f":"+AN40/(AN11+AN12)","v":0.17921617461998959}]
[]
["Pre-tax Margin (Pre-tax income (loss) / total premiums)",null,null,{"$f":"D49/(D11+D12+D29)","v":0.10427176207159392},{"$f":"E49/(E11+E12+E29)","v":5.1561322996627476E-3},0.56121091120610667,0.26602253467325465,6.3807934401237124E-2,4.3679883726053956E-2,0.14838235972668548,0.10764056979383882,1.2389832495822543E-2,-0.13391545027638685,0.4551642976395841,0.29601437042134132,0.40800761509343408,0.27861163778169812,-0.58136394762320187,-0.13581839243763935,0.12740756338980336,0.17169561207748785,0.31767088339497929,0.20598553520419852,0.83113717657076225,0.45409974190520697,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AD49/(AD11+AD12+AD29)","v":0.14036181747111984},6.6852375049000712E-2,{"$f":"+AF47/AF14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"AM49/(AM11+AM12+AM29)","v":0.14725378035498873},{"$f":"AN49/(AN11+AN12+AN29)","v":7.2570640787909022E-2}]

{"sheet":"March 2025","index":9,"n_rows":60,"n_cols":44,"rows_kept":60,"cut":false,"hidden":false,"merged":[[57,0,57,1],[59,0,59,1],[5,29,5,30],[5,31,5,32],[5,33,5,34],[5,39,5,40],[44,0,44,1],[55,0,55,1],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26],[5,27,5,28],[1,0,1,1],[4,3,4,34],[4,36,4,37],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16]]}
["DEARBORN LIFE INSURANCE COMPANY"]
["MARCH 2025"]
["INCOME STATEMENT BY LINE OF BUSINESS"]
["$'(000)'s"]
[null,null,null,"Insured",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annuities",null,null,"C&S","C&S",null,"Total All Lines","Total All Lines"]
[null,null,null,"Life",null,"ADD",null,"STD",null,"LTD",null,"Dental",null,"Critical Illness",null,"Accident",null,"Hospital Indemnity",null,"Vision",null,"Individual Life",null,"ASO STD",null,"ASO LIFE",null,"ASO VIS",null,"LTD ASO",null,"DENTAL ASO",null,"TOTAL INSURED",null,null,"Annuities","Annuities",null,null,null,null,"of Business","of Business"]
[null,null,null,"Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan","Actual","Plan",null,"Actual","Plan",null,"Actual","Plan",null,"Actual","Plan"]
[]
["Revenues"]
["Premiums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"Insurance premiums",null,{"$f":"(-[38]Prem_Loss_Comm!E33/1000)","v":86360.184129999994},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D10","v":86870.9261906006},{"$f":"-[38]Prem_Loss_Comm!V33/1000","v":7892.2664700000005},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E10","v":8005.2382807946306},{"$f":"-[38]Prem_Loss_Comm!F33/1000","v":31501.51},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F10","v":32123.156994957666},{"$f":"-[38]Prem_Loss_Comm!G33/1000","v":30667.174319999998},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H10","v":31007.229346310109},{"$f":"-[38]Prem_Loss_Comm!H33/1000","v":163.05223999999998},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I10","v":153.66740523372349},{"$f":"-[38]Prem_Loss_Comm!R33/1000","v":3441.3439899999998},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K10","v":3406.174011872472},{"$f":"-[38]Prem_Loss_Comm!T33/1000","v":2739.5572099999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L10","v":2928.5344301958016},{"$f":"-[38]Prem_Loss_Comm!U33/1000","v":1151.5413800000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M10","v":1201.0749959051122},{"$f":"-[38]Prem_Loss_Comm!S33/1000","v":19082.20534},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N10","v":20148.636276783647},{"$f":"-[38]Prem_Loss_Comm!Q33/1000","v":1394.0316700000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P10","v":1228.4625000000001},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G10","v":0},0,0,null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O10","v":0},0,0,{"$f":"+[38]Prem_Loss_Comm!K33","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J10","v":0},{"$f":"+D11+H11+J11+L11+X11+Z11+AB11+AF11+AD11+N11+P11+T11+V11+F11+R11","v":184392.86674999996},{"$f":"+E11+I11+K11+M11+Y11+AA11+AC11+AG11+AE11+O11+Q11+U11+W11+G11+S11","v":187073.10043265377},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S10","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U10","v":0},null,{"$f":"AH11+AN11+AK11","v":184392.86674999996},{"$f":"AI11+AO11+AL11","v":187073.10043265377}]
[null,"ASO claims and fees",null,{"$f":"(-[38]Prem_Loss_Comm!E38/1000)","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D11","v":0},{"$f":"-[38]Prem_Loss_Comm!G38/1000","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E11","v":0},{"$f":"+[38]Prem_Loss_Comm!F38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F11","v":0},{"$f":"+[38]Prem_Loss_Comm!G38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H11","v":0},{"$f":"+[38]Prem_Loss_Comm!H38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I11","v":0},{"$f":"+[38]Prem_Loss_Comm!R38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K11","v":0},{"$f":"+[38]Prem_Loss_Comm!T38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L11","v":0},{"$f":"+[38]Prem_Loss_Comm!U38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M11","v":0},{"$f":"+[38]Prem_Loss_Comm!S38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N11","v":0},{"$f":"+[38]Prem_Loss_Comm!Q38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P11","v":0},{"$f":"-(([38]Prem_Loss_Comm!L33+[38]Prem_Loss_Comm!L38)/1000+[38]Prem_Loss_Comm!F38/1000+[38]Prem_Loss_Comm!J38/1000)","v":1920.3146899999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G11","v":2731.4126777506463},{"$f":"-(([38]Prem_Loss_Comm!M33+[38]Prem_Loss_Comm!M38)/1000+([38]Prem_Loss_Comm!E38/1000))","v":118.75048000000001},0,{"$f":"-[38]Prem_Loss_Comm!N33/1000","v":71.418520000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O11","v":0},0,0,{"$f":"+[38]Prem_Loss_Comm!K38","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J11","v":0},{"$f":"+D12+H12+J12+L12+X12+Z12+AB12+AF12+AD12+N12+P12+T12+V12+F12+R12","v":2110.48369},2731.4126777506463,null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S11","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U11","v":0},null,{"$f":"AH12+AN12+AK12","v":2110.48369},2731.4126777506463]
[null,"Annuity premiums",null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H12","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I12","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N12","v":0},null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P12","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G12","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O12","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J12","v":0},0,0,null,{"$f":"-[38]Prem_Loss_Comm!J33/1000","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S12","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U12","v":0},null,0,0]
[null,"   Total premiums",null,{"$f":"SUM(D11:D13)","v":86360.184129999994},86870.9261906006,7892.2664700000005,8005.2382807946306,31501.51,32123.156994957666,30667.174319999998,31007.229346310109,163.05223999999998,153.66740523372349,3441.3439899999998,{"$f":"SUM(O11:O13)","v":3406.174011872472},{"$f":"SUM(P11:P13)","v":2739.5572099999999},2928.5344301958016,1151.5413800000001,1201.0749959051122,19082.20534,20148.636276783647,{"$f":"SUM(V11:V13)","v":1394.0316700000001},{"$f":"SUM(W11:W13)","v":1228.4625000000001},1920.3146899999999,{"$f":"SUM(Y11:Y13)","v":2731.4126777506463},{"$f":"SUM(Z11:Z13)","v":118.75048000000001},{"$f":"SUM(AA11:AA13)","v":0},{"$f":"SUM(AB11:AB13)","v":71.418520000000001},{"$f":"SUM(AC11:AC13)","v":0},0,0,0,0,{"$f":"SUM(AH11:AH13)","v":186503.35043999995},{"$f":"SUM(AI11:AI13)","v":189804.51311040443},null,{"$f":"SUM(AK11:AK13)","v":0},0,null,{"$f":"SUM(AN11:AN13)","v":0},0,null,{"$f":"SUM(AQ11:AQ13)","v":186503.35043999995},{"$f":"SUM(AR11:AR13)","v":189804.51311040443}]
[]
["Net investment income",null,null,{"$f":"'[38]DNLStat Insured Allocation'!E10+'[38]DNLStat Insured Allocation'!E16","v":1648},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D15","v":1702.633832130407},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E15","v":82.305502686303143},{"$f":"'[38]DNLStat Insured Allocation'!E11+'[38]DNLStat Insured Allocation'!E17","v":216},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F15","v":236.86875640244438},{"$f":"'[38]DNLStat Insured Allocation'!E12+'[38]DNLStat Insured Allocation'!E18","v":4627},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H15","v":4686.4546998153683},{"$f":"'[38]DNLStat Insured Allocation'!E13+'[38]DNLStat Insured Allocation'!E19","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I15","v":0.41422517464083303},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K15","v":15.227219152409813},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L15","v":8.6332820718937668},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M15","v":17.53481350238868},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N15","v":41.973377248344889},{"$f":"'[38]DNLStat Insured Allocation'!E21","v":1378},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P15","v":784.14764209006785},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G15","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O15","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J15","v":0},{"$f":"+D16+H16+J16+L16+X16+Z16+AB16+AF16+AD16+N16+P16+R16+T16+V16+F16","v":7869},{"$f":"+E16+G16+I16+K16+M16+O16+Q16+S16+U16+W16+Y16+AA16+AC16+AE16+AG16","v":7576.1933502742686},null,{"$f":"+'[38]DNLStat Insured Allocation'!E22","v":94},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S15","v":72.818151253913356},null,{"$f":"'[38]DNL Stat LOB Actual'!F38","v":3944},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U15","v":4063.5529205518615},null,{"$f":"AH16+AN16+AK16","v":11907},{"$f":"AI16+AO16+AL16","v":11712.564422080044}]
["Realized capital gains (losses) ",null,null,{"$f":"+'[38]DNLStat Insured Allocation'!F10+'[38]DNLStat Insured Allocation'!F16","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D16","v":0},{"$f":"'[38]DNLStat Insured Allocation'!H10+'[38]DNLStat Insured Allocation'!H16","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E16","v":0},{"$f":"+'[38]DNLStat Insured Allocation'!F11+'[38]DNLStat Insured Allocation'!F17","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F16","v":0},{"$f":"+'[38]DNLStat Insured Allocation'!F12+'[38]DNLStat Insured Allocation'!F18","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H16","v":0},{"$f":"'[38]DNLStat Insured Allocation'!F13+'[38]DNLStat Insured Allocation'!F19","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I16","v":0},{"$f":"'[38]DNLStat Insured Allocation'!H13+'[38]DNLStat Insured Allocation'!H19","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K16","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L16","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M16","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N16","v":0},{"$f":"+'[38]DNLStat Insured Allocation'!F21","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P16","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G16","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O16","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K16","v":0},{"$f":"+D17+H17+J17+L17+X17+Z17+AB17+AF17+AD17+N17+P17+R17+T17+V17+F17","v":0},{"$f":"+E17+G17+I17+K17+M17+O17+Q17+S17+U17+W17+Y17+AA17+AC17+AE17+AG17","v":0},null,{"$f":"+'[38]DNLStat Insured Allocation'!F22","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S16","v":0},null,{"$f":"'[38]DNL Stat LOB Actual'!F51","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U16","v":0},null,{"$f":"AH17+AN17+AK17","v":0},0]
["Realized capital gains (losses) on derivatives",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,0,0,0,null,0,0,0,null,0,0,null,0,null,null,0,null,null,0,0]
["Realized capital losses - impairments",null,null,{"$f":"'[38]DNLStat Insured Allocation'!G10+'[38]DNLStat Insured Allocation'!G16-1","v":-1},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D18","v":-27.942457904045028},{"$f":"'[38]DNLStat Insured Allocation'!I10+'[38]DNLStat Insured Allocation'!I16","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E18","v":-1.3404559666552081},{"$f":"'[38]DNLStat Insured Allocation'!G17+'[38]DNLStat Insured Allocation'!G11","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F18","v":-3.8577267311520145},{"$f":"'[38]DNLStat Insured Allocation'!G12+'[38]DNLStat Insured Allocation'!G18","v":1},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H18","v":-76.537999574726442},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I18","v":-6.7462148794882716E-3},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K18","v":-0.24799577309198498},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L18","v":-0.14060462651196803},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M18","v":-0.285578055127713},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N18","v":-0.68359298147603587},{"$f":"'[38]DNLStat Insured Allocation'!G21","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P18","v":-12.770900502053127},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G18","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O18","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K18","v":-0.24799577309198498},{"$f":"+D19+H19+J19+L19+X19+Z19+AB19+AF19+AD19+N19+P19+R19+T19+V19+F19","v":0},-124.062054102811,null,{"$f":"+'[38]DNLStat Insured Allocation'!G22","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S18","v":-1.1859416702809744},null,{"$f":"+'[38]DNL Stat LOB Actual'!F64","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U18","v":-75},null,0,-200.24799577309199]
[]
["Other income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Dental TPA fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Dental network leasing fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Other revenues",null,{"$f":"-'[38]Other Income'!C22/1000","v":0.19116},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D23","v":25},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E23","v":0},{"$f":"-'[38]Other Income'!D22/1000","v":324.72019},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F23","v":325},{"$f":"-'[38]Other Income'!E22/1000","v":0.37401999999999996},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P23","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G23","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O23","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J23","v":0},325.28537,350,null,{"$f":"-'[38]Other Income'!H22/1000","v":678.45998999999995},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S23","v":759.25495436962808},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U23","v":0},null,{"$f":"AH24+AN24+AK24","v":1003.7453599999999},{"$f":"AI24+AO24+AL24","v":1109.2549543696282}]
[null,"   Total other income",null,{"$f":"SUM(D24:D24)","v":0.19116},25,0,0,324.72019,325,0.37401999999999996,0,0,0,0,0,0,0,{"$f":"SUM(R24:R24)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Z24:Z24)","v":0},0,0,0,0,0,0,0,325.28537,350,null,{"$f":"SUM(AK24:AK24)","v":678.45998999999995},{"$f":"SUM(AL24:AL24)","v":759.25495436962808},null,{"$f":"SUM(AN24:AN24)","v":0},{"$f":"SUM(AO24:AO24)","v":0},null,{"$f":"SUM(AQ24:AQ24)","v":1003.7453599999999},{"$f":"SUM(AR24:AR24)","v":1109.2549543696282}]
[]
["   Gross Revenues",null,null,{"$f":"+D25+D19+D18+D16+D14+D17","v":88007.375289999996},88570.617564826956,7892.2664700000005,8086.2033275142785,32042.230189999998,32681.168024628958,35295.548340000001,35617.146046550748,163.05223999999998,154.07488419348482,3441.3439899999998,3421.1532352517897,2739.5572099999999,2937.0271076411836,1151.5413800000001,1218.3242313523733,19082.20534,20189.926061050515,2772.0316700000003,1999.8392415880148,1920.3146899999999,2731.4126777506463,118.75048000000001,0,71.418520000000001,0,0,0,0,-0.24799577309198498,194697.63580999995,197606.64440657588,null,{"$f":"+AK25+AK19+AK18+AK16+AK14+AK17","v":772.45998999999995},{"$f":"+AL25+AL19+AL18+AL16+AL14+AL17","v":830.88716395326048},null,{"$f":"+AN25+AN19+AN18+AN16+AN14+AN17","v":3944},{"$f":"+AO25+AO19+AO18+AO16+AO14+AO17","v":3988.5529205518615},null,{"$f":"+AQ25+AQ19+AQ18+AQ16+AQ14+AQ17","v":199414.09579999995},{"$f":"+AR25+AR19+AR18+AR16+AR14+AR17","v":202426.08449108101}]
[]
["Less: ASO claims",null,null,{"$f":"-[38]Prem_Loss_Comm!E42/1000","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N28","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P28","v":0},{"$f":"(-[38]Prem_Loss_Comm!L67/1000)","v":-1222.4064499999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G28","v":-1855.6122134463481},{"$f":"(-[38]Prem_Loss_Comm!M67/1000)","v":-15},0,{"$f":"(-[38]Prem_Loss_Comm!N67/1000)","v":-71.418520000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O28","v":0},{"$f":"-[38]Prem_Loss_Comm!O71/1000*0.666","v":0},0,{"$f":"-[38]Prem_Loss_Comm!K67/1000","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J28","v":0},{"$f":"+D29+H29+J29+L29+X29+Z29+AB29+AF29+AD29+N29+P29+R29+T29+V29+F29","v":-1308.8249699999999},{"$f":"+E29+G29+I29+K29+M29+O29+Q29+S29+U29+W29+Y29+AA29+AC29+AE29+AG29","v":-1855.6122134463481},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S28","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U28","v":0},null,{"$f":"AH29+AN29+AK29","v":-1308.8249699999999},{"$f":"AI29+AO29+AL29","v":-1855.6122134463481}]
[]
["Net Revenues",null,null,{"$f":"SUM(D27:D30)","v":88007.375289999996},{"$f":"SUM(E27:E30)","v":88570.617564826956},{"$f":"SUM(F27:F30)","v":7892.2664700000005},{"$f":"SUM(G27:G30)","v":8086.2033275142785},32042.230189999998,32681.168024628958,35295.548340000001,35617.146046550748,163.05223999999998,154.07488419348482,3441.3439899999998,3421.1532352517897,2739.5572099999999,2937.0271076411836,1151.5413800000001,1218.3242313523733,19082.20534,20189.926061050515,2772.0316700000003,1999.8392415880148,697.90823999999998,875.8004643042982,103.75048000000001,0,0,0,{"$f":"SUM(AD27:AD30)","v":0},0,0,-0.24799577309198498,193388.81083999996,{"$f":"SUM(AI27:AI30)","v":195751.03219312953},null,{"$f":"SUM(AK27:AK30)","v":772.45998999999995},830.88716395326048,null,{"$f":"SUM(AN27:AN30)","v":3944},{"$f":"SUM(AO27:AO30)","v":3988.5529205518615},null,{"$f":"SUM(AQ27:AQ30)","v":198105.27082999996},{"$f":"SUM(AR27:AR30)+1","v":200571.47227763466}]
[]
["Incurred Benefits"]
[null,"Insurance claims and reserves",null,{"$f":"(+[38]Prem_Loss_Comm!E67/1000)-([38]Prem_Loss_Comm!E42/1000)","v":66497.238359999988},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D33-1","v":64935.078420140715},{"$f":"[38]Prem_Loss_Comm!V67/1000","v":2315.8304800000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E33","v":2662.7121328355634},{"$f":"[38]Prem_Loss_Comm!F67/1000","v":17231.968510000002},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F33","v":18077.545385773443},{"$f":"[38]Prem_Loss_Comm!G67/1000","v":21348.134440000002},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H33","v":22848.51912163732},{"$f":"[38]Prem_Loss_Comm!H67/1000","v":91.783860000000004},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I33","v":112.04711399758467},{"$f":"[38]Prem_Loss_Comm!R67/1000","v":925.51897999999994},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K33","v":1187.3540595210452},{"$f":"[38]Prem_Loss_Comm!T67/1000","v":309.01569000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L33","v":961.80187402803972},{"$f":"+[38]Prem_Loss_Comm!U67/1000","v":295.79849000000002},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M33","v":608.62348314426561},{"$f":"[38]Prem_Loss_Comm!S67/1000","v":11567.666590000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N33","v":11712.240587962679},{"$f":"[38]Prem_Loss_Comm!Q67/1000","v":2110.9768000000004},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P33","v":1535.57825},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G33","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O33","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J33","v":0},{"$f":"+D34+H34+J34+L34+X34+Z34+AB34+AF34+AD34+N34+P34+R34+T34+V34+F34","v":122693.93219999998},{"$f":"+E34+G34+I34+K34+M34+O34+Q34+S34+U34+W34+Y34+AA34+AC34+AE34+AG34","v":124641.50042904067},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S33","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U33","v":0},null,{"$f":"AH34+AN34+AK344","v":122693.93219999998},{"$f":"AI34+AO34+AL34","v":124641.50042904067}]
[null,"Annuity claims and reserves",null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K34","v":0},null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L34","v":0},null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M34","v":0},null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N34","v":0},null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P34","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G34","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O34","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J34","v":0},0,0,null,{"$f":"[38]Prem_Loss_Comm!J67/1000","v":104.92515000000409},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S34","v":62.203381789999995},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U34","v":0},null,{"$f":"AH35+AN35+AK35","v":104.92515000000409},{"$f":"AI35+AO35+AL35","v":62.203381789999995}]
["Total Incurred Benefits",null,null,{"$f":"SUM(D34:D35)","v":66497.238359999988},64935.078420140715,{"$f":"SUM(F34:F35)","v":2315.8304800000001},2662.7121328355634,17231.968510000002,18077.545385773443,21348.134440000002,22848.51912163732,91.783860000000004,112.04711399758467,{"$f":"SUM(N34:N35)","v":925.51897999999994},1187.3540595210452,309.01569000000001,961.80187402803972,295.79849000000002,608.62348314426561,11567.666590000001,11712.240587962679,2110.9768000000004,1535.57825,0,0,{"$f":"SUM(Z34:Z35)","v":0},0,0,0,0,0,0,0,122693.93219999998,{"$f":"SUM(AI34:AI35)","v":124641.50042904067},null,{"$f":"SUM(AK34:AK35)","v":104.92515000000409},{"$f":"SUM(AL34:AL35)","v":62.203381789999995},null,{"$f":"SUM(AN34:AN35)","v":0},{"$f":"SUM(AO34:AO35)","v":0},null,{"$f":"SUM(AQ34:AQ35)","v":122798.85734999999},{"$f":"SUM(AR34:AR35)+1","v":124704.70381083066}]
[]
["Operating Expenses"]
[null,"Commission expense",null,{"$f":"[38]Prem_Loss_Comm!E79/1000-[38]Prem_Loss_Comm!Q82/1000","v":7311.0670900000005},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D38","v":7428.3532741306408},{"$f":"[38]Prem_Loss_Comm!V79/1000","v":742.28900999999996},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E38","v":741.98556925865967},{"$f":"[38]Prem_Loss_Comm!F79/1000","v":3906.7786699999992},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F38","v":4072.9929321912714},{"$f":"[38]Prem_Loss_Comm!G79/1000","v":3470.35761},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H38","v":3750.2220337322924},{"$f":"[38]Prem_Loss_Comm!H79/1000","v":17.64959},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I38","v":17.057081980943309},{"$f":"[38]Prem_Loss_Comm!R79/1000","v":499.71451000000002},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K38","v":475.95656704294902},{"$f":"[38]Prem_Loss_Comm!T79/1000","v":468.06684000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L38","v":447.8362489232826},{"$f":"[38]Prem_Loss_Comm!U79/1000","v":207.33617999999998},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M38","v":224.76406063190282},{"$f":"[38]Prem_Loss_Comm!S79/1000","v":1914.4876000000002},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N38","v":1966.5668902043244},{"$f":"[38]Prem_Loss_Comm!Q79/1000","v":3.0526900000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P38","v":2.456925},{"$f":"[38]Prem_Loss_Comm!L79/1000","v":18.143979999999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G38","v":14.346712175002263},{"$f":"-[38]Prem_Loss_Comm!M79/1000","v":-1.805E-2},0,{"$f":"-[38]Prem_Loss_Comm!N79/1000","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O38","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J38","v":0},{"$f":"+D39+H39+J39+L39+X39+Z39+AB39+AF39+AD39+N39+P39+R39+T39+V39+F39","v":18558.925719999999},{"$f":"+E39+G39+I39+K39+M39+O39+Q39+S39+U39+W39+Y39+AA39+AC39+AE39+AG39","v":19142.538295271272},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S38","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U38","v":0},null,{"$f":"AH39+AN39+AK39","v":18558.925719999999},{"$f":"AI39+AO39+AL39","v":19142.538295271272}]
[null,"General and administrative expense",null,{"$f":"'[38]G&A'!F30","v":14322.739000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D39","v":14503.012999999999},{"$f":"'[38]G&A'!G30","v":1750.7809999999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E39","v":1732.922},{"$f":"'[38]G&A'!I30-'March 2025'!X40","v":7887.6702654999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F39","v":7967.2566999999999},{"$f":"'[38]G&A'!H30","v":6022.8620000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H39","v":6145.2469999999994},{"$f":"'[38]G&A'!J30-'March 2025'!AF40","v":72.787999999999997},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I39","v":58.332000000000001},{"$f":"'[38]G&A'!K30","v":959.28},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K39","v":1004.9780000000001},{"$f":"'[38]G&A'!M30","v":787.50399999999991},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L39","v":815.90899999999999},{"$f":"+'[38]G&A'!N30","v":493.94100000000003},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M39","v":520.06500000000005},{"$f":"'[38]G&A'!L30","v":3159.009},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N39","v":3517.6939999999995},{"$f":"'[38]G&A'!E30","v":507.32400000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P39","v":432.34700000000004},{"$f":"X12*0.05","v":96.015734500000008},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G39","v":419.32929999999999},null,0,null,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O39","v":0},0,0,{"$f":"AF12*0.05","v":0},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J39","v":0},{"$f":"+D40+H40+J40+L40+X40+Z40+AB40+AF40+AD40+N40+P40+R40+T40+V40+F40","v":36059.914000000004},37117.092999999993,null,{"$f":"'[38]G&A'!D30","v":171.51499999999999},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S39","v":137.61500000000001},null,{"$f":"'[38]G&A'!O30","v":1175.037},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U39","v":1144.9453100000001},null,{"$f":"AH40+AN40+AK40","v":37406.466},{"$f":"AI40+AO40+AL40","v":38399.653309999994}]
[null,"ACA Tax",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J40","v":0},0,0,null,0,0,null,0,0,null,0,0]
[null,"Premium tax",null,{"$f":"'[38]Prem Taxes'!F7","v":1047.1779106164154},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D40","v":1051.1382069062672},{"$f":"'[38]Prem Taxes'!F8","v":97.842327765695586},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E40","v":98.464430853773948},{"$f":"'[38]Prem Taxes'!F9","v":379.94285132343947},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F40","v":370.48835569064636},{"$f":"'[38]Prem Taxes'!F10","v":398.60847781955931},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H40","v":431.00048791371057},{"$f":"'[38]Prem Taxes'!F11","v":2.0229735792892174},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I40","v":1.8132753817579368},{"$f":"'[38]Prem Taxes'!F12","v":39.350029331713728},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K40","v":40.64526272867041},{"$f":"'[38]Prem Taxes'!F14","v":32.109934914718195},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L40","v":34.749799137198465},{"$f":"'[38]Prem Taxes'!F15","v":12.263501857512853},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M40","v":13.211824954956235},{"$f":"'[38]Prem Taxes'!F13","v":222.13084594870796},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N40","v":238.42102735942703},{"$f":"'[38]Prem Taxes'!F16","v":18.396396842948217},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P40","v":16.010961250000001},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!G40","v":0},0,{"$f":"[38]Plan!R9+[38]Plan!R22","v":0},0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O40","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J40","v":0},2249.8452500000008,2295.9436321764083,null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S40","v":0},null,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U40","v":0},null,{"$f":"AH42+AN42+AK42","v":2249.8452500000008},{"$f":"AI42+AO42+AL42","v":2295.9436321764083}]
["Total Operating Expenses",null,null,{"$f":"SUM(D39:D42)","v":22680.984000616416},22982.504481036907,2590.9123377656956,{"$f":"SUM(G39:G42)","v":2573.3720001124339},12174.391786823438,12410.737987881917,9891.8280878195601,{"$f":"SUM(K39:K42)","v":10326.469521646002},92.460563579289214,77.202357362701235,1498.3445393317138,1521.5798297716194,1287.6807749147181,1298.4950480604812,{"$f":"SUM(R39:R42)","v":713.54068185751294},758.04088558685908,5295.6274459487086,5722.6819175637511,528.77308684294826,{"$f":"SUM(W39:W42)","v":450.81488625000003},114.15971450000001,433.67601217500226,{"$f":"SUM(Z39:Z42)","v":-1.805E-2},0,0,0,0,0,0,0,56868.684970000002,{"$f":"SUM(AI39:AI42)","v":58555.574927447669},null,{"$f":"SUM(AK39:AK42)","v":171.51499999999999},{"$f":"SUM(AL39:AL42)","v":137.61500000000001},null,{"$f":"SUM(AN39:AN42)","v":1175.037},{"$f":"SUM(AO39:AO42)","v":1144.9453100000001},null,{"$f":"SUM(AQ39:AQ42)","v":58215.236969999998},{"$f":"SUM(AR39:AR42)","v":59838.13523744767}]
[]
["Total Incurred Benefits and Operating Expenses",null,null,{"$f":"+D36+D43","v":89178.222360616404},{"$f":"+E36+E43+1","v":87918.582901177622},4906.7428177656957,{"$f":"+G36+G43","v":5236.0841329479972},29406.360296823441,30488.283373655358,31239.96252781956,33174.988643283323,184.24442357928922,{"$f":"+M36+M43","v":189.2494713602859},2423.8635193317136,2708.9338892926644,{"$f":"+P36+P43","v":1596.696464914718},{"$f":"+Q36+Q43","v":2260.2969220885207},{"$f":"+R36+R43","v":1009.339171857513},{"$f":"+S36+S43","v":1366.6643687311248},16863.294035948711,17434.922505526429,2639.7498868429484,{"$f":"+W36+W43","v":1986.39313625},114.15971450000001,433.67601217500226,-1.805E-2,0,0,0,0,0,0,0,179562.61716999998,{"$f":"+AI36+AI43","v":183197.07535648835},null,{"$f":"+AK36+AK43","v":276.44015000000411},{"$f":"+AL36+AL43","v":199.81838178999999},null,{"$f":"+AN36+AN43","v":1175.037},{"$f":"+AO36+AO43","v":1144.9453100000001},null,{"$f":"+AQ36+AQ43","v":181014.09431999997},{"$f":"+AR36+AR43","v":184542.83904827834}]
[]
["Pre-tax Income (Loss) Before TB & C&S Allocation",null,null,{"$f":"D31-D45","v":-1170.847070616408},{"$f":"E31-E45","v":652.03466364933411},{"$f":"F31-F45","v":2985.5236522343048},2850.1191945662813,2635.8698931765575,2192.8846509735995,4055.5858121804413,{"$f":"K31-K45","v":2442.1574032674253},-21.192183579289235,{"$f":"M31-M45","v":-35.174587166801075},1017.4804706682862,712.21934595912535,{"$f":"P31-P45","v":1142.8607450852819},676.73018555266299,{"$f":"R31-R45","v":142.20220814248717},{"$f":"S31-S45","v":-148.34013737875148},2218.9113040512893,2755.0035555240866,132.2817831570519,13.446105338014831,583.74852549999991,442.12445212929595,{"$f":"Z31-Z45","v":103.76853000000001},{"$f":"AA31-AA45","v":0},{"$f":"AB31-AB45","v":0},{"$f":"AC31-AC45","v":0},0,0,0,-0.24799577309198498,13826.193669999979,{"$f":"AI31-AI45","v":12553.956836641184},null,{"$f":"AK31-AK45","v":496.01983999999584},{"$f":"AL31-AL45","v":631.06878216326049},null,{"$f":"AN31-AN45","v":2768.9629999999997},{"$f":"AO31-AO45","v":2843.6076105518614},null,{"$f":"AQ31-AQ45","v":17091.17650999999},{"$f":"AR31-AR45-1","v":16027.633229356317}]
["C&S Earnings Allocation",null,null,{"$f":"'[38]Excess C&S Inv Income v2'!C30","v":2039.739510505882},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!D50","v":2067.261},{"$f":"'[38]Excess C&S Inv Income v2'!C31","v":25.480200797841839},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!E50","v":25.474},{"$f":"'[38]Excess C&S Inv Income v2'!C32","v":115.76090725716126},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!F50","v":118.289},{"$f":"'[38]Excess C&S Inv Income v2'!C33","v":745.53926900174747},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!H50","v":757.21},{"$f":"'[38]Excess C&S Inv Income v2'!C34","v":1.0449504733576878},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!I50","v":1.101},{"$f":"'[38]Excess C&S Inv Income v2'!C35","v":18.288669650829277},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!K50","v":17.52},{"$f":"'[38]Excess C&S Inv Income v2'!C36","v":10.102573016647819},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!L50","v":9.82},{"$f":"'[38]Excess C&S Inv Income v2'!C37","v":2.9379842666974589},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!M50","v":2.484},{"$f":"'[38]Excess C&S Inv Income v2'!C38","v":105.8796994564957},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!N50","v":104.96300000000001},{"$f":"'[38]Excess C&S Inv Income v2'!C39","v":40.887437888023022},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!P50","v":41.531999999999996},0,0,0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!O50","v":0},0,0,0,{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!J49","v":0},{"$f":"+D48+H48+J48+L48+X48+Z48+AB48+AF48+AD48+N48+P48+R48+T48+V48+F48","v":3105.6612023146845},{"$f":"+E48+G48+I48+K48+M48+O48+Q48+S48+U48+W48+Y48+AA48+AC48+AE48+AG48","v":3145.6540000000009},null,{"$f":"'[38]Excess C&S Inv Income v2'!C40","v":27.609179020579987},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!S50","v":27.488},null,{"$f":"-'[38]Excess C&S Inv Income v2'!C41","v":-3133.2703813352641},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U50","v":-3173.1419999999998},null,{"$f":"AQ32-AQ46","v":0},0]
["Pre-tax Income (Loss) Before Total Blue Costs",null,null,{"$f":"D47+D48","v":868.89243988947396},{"$f":"E47+E48","v":2719.2956636493341},{"$f":"F47+F48","v":3011.0038530321467},2875.5931945662815,2751.6308004337188,2311.1736509735997,4801.1250811821883,3199.3674032674253,-20.147233105931548,-34.073587166801076,1035.7691403191154,729.73934595912533,1152.9633181019296,686.55018555266304,145.14019240918464,-145.85613737875147,2324.7910035077848,2859.9665555240867,173.16922104507492,54.978105338014828,583.74852549999991,442.12445212929595,103.76853000000001,0,0,0,0,0,0,-0.24799577309198498,16931.854872314663,{"$f":"AI47+AI48","v":15699.610836641185},null,{"$f":"AK47+AK48","v":523.62901902057581},658.55678216326055,null,{"$f":"AN47+AN48","v":-364.30738133526438},{"$f":"AO47+AO48","v":-329.53438944813843},null,{"$f":"AQ47+AQ48","v":17091.17650999999},{"$f":"AR47+AR48","v":16027.633229356317}]
[]
["GIAS Write-off",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"AN51","v":0},0]
["Total Blue Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'[38]G&A'!P31","v":852.46100000000001},{"$f":"+'[38]DLIC 2025.03 Plan Cumulative'!U52","v":856.35968999999989},null,{"$f":"AN52","v":852.46100000000001},{"$f":"SUM(AO52)","v":856.35968999999989}]
[]
["Pre-tax Income (Loss) ",null,null,{"$f":"D49-D52","v":868.89243988947396},{"$f":"E49-E52","v":2719.2956636493341},{"$f":"F49-F52","v":3011.0038530321467},2875.5931945662815,2751.6308004337188,2311.1736509735997,4801.1250811821883,3199.3674032674253,-20.147233105931548,-34.073587166801076,1035.7691403191154,729.73934595912533,1152.9633181019296,686.55018555266304,145.14019240918464,-145.85613737875147,2324.7910035077848,2859.9665555240867,{"$f":"V49-V52","v":173.16922104507492},54.978105338014828,583.74852549999991,442.12445212929595,103.76853000000001,0,0,0,0,0,0,-0.24799577309198498,{"$f":"AH49-AH52","v":16931.854872314663},{"$f":"AI49-AI52","v":15699.610836641185},{"$f":"AJ31-AJ45","v":0},{"$f":"AK49-AK52","v":523.62901902057581},658.55678216326055,{"$f":"AM31-AM45","v":0},{"$f":"AN49-AN51-AN52","v":-1216.7683813352644},{"$f":"AO49-AO51-AO52","v":-1185.8940794481382},{"$f":"AP31-AP45","v":0},{"$f":"AQ49-AQ51-AQ52","v":16238.715509999991},{"$f":"AR49-AR51-AR52+1","v":15172.273539356318}]
[]
["Insurance loss ratio (insurance benefit expenses / insurance premiums)",null,null,{"$f":"+D34/D11","v":0.76999880245623553},0.74748919192675378,0.29343034587122852,0.33262122118509285,0.54702039711747164,0.56275743348049678,0.69612329513115712,0.73687716069208609,0.56291075792641676,0.72915341953724278,0.26894114121965468,0.34858878477213279,0.11279767725675639,0.32842430128565492,0.25687178518934334,0.50673229000626729,0.60620176671885662,0.58129197564890078,1.5142961565571895,1.2500001017532076,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.66539413569803951,0.66627163467529926,null,null,null,null,null,null,null,{"$f":"+AQ34/AQ11","v":0.66539413569803951},{"$f":"+(AR34)/AR11","v":0.66627163467529926}]
[]
["G&A Expense ratio (G&A expenses / insurance premiums incl. ASO)",null,null,{"$f":"+D40/(D11+D12)","v":0.16584887056794193},0.16694898553492366,0.22183500856883762,0.21647350637362708,0.25039022781765063,0.2480222196482933,0.19639442281684596,0.19818755592012577,0.446409077238068,0.37959904321465432,0.278751558341019,0.29504599486023753,0.28745667260586244,0.27860659297266599,0.42893899305641969,0.43299960599719822,0.16554737482978998,0.17458720042771717,0.36392573491533375,0.35194155295745699,0.05,0.15352103452390911,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.19334727185826536,0.19555432266465619,{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"+AQ40/(AQ11+AQ12)","v":0.20056726011490097},{"$f":"+AR40/(AR11+AR12)","v":0.20231159249445191}]
[]
["Pre-tax Margin (Pre-tax income (loss) / total premiums)",null,null,{"$f":"D49/(D11+D12+D29)","v":1.0061262011455534E-2},3.1302712920120344E-2,0.38151320212990053,0.35921394138449542,8.7349171529673308E-2,7.1947276269775789E-2,0.15655583494861056,0.10318133773045908,-0.12356305626915368,-0.22173594403430044,0.30097808976054019,0.21424018368279624,0.42085754365462941,0.23443473242920362,0.12603992781326245,-0.12143799336096948,0.12183031060013658,0.14194343062411105,0.12422187011366458,4.4753588602024746E-2,0.83642589676258861,0.50482326756985951,1.0001739750987177,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},9.1427404937288431E-2,8.3531272392214778E-2,{"$f":"+AJ47/AJ14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"AQ49/(AQ11+AQ12+AQ29)","v":9.2287698389705505E-2},{"$f":"AR49/(AR11+AR12+AR29)","v":8.5276546725555888E-2}]