{"text_format":"1","workbook":"xlsx","n_sheets":7,"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"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"comments":0,"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":[[0,1,0,2],[1,1,1,2],[2,1,2,2]]}
[null,"Department of Managed Health Care/Department of Insurance"]
[null,"Medical Loss Ratio Reporting Form "]
[null,"Dental Coverage"]
[]
[]
["1.","MLR Reporting Year","2017"]
["2.","Enter DMHC Health Plan ID. Insurers may leave this field blank"]
["3.","Legal Name","Dearborn National Life Insurance Company"]
["4.","DBA","Health Insurer "]
["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."]

{"sheet":"Pt 1 Summary of Data","index":1,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[49,4,50,4],[5,4,10,5],[58,2,58,3],[55,2,55,3],[5,1,5,3],[7,1,7,3],[9,1,9,3],[11,1,11,3],[17,1,18,3],[7,10,7,11],[9,10,9,11],[13,10,13,15],[14,10,14,15],[15,14,15,15],[15,6,15,7],[14,4,14,9],[15,10,15,11],[15,12,15,13],[13,4,13,9],[15,8,15,9],[15,4,15,5]]}
[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,{"$f":"'Cover Page'!C7","v":0},null,null,"Part 1",null,null,{"$f":"'Cover Page'!C10","v":"No"}]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[null,null,null,null,"Health Insurance Coverage",null,null,null,null,null,"Health Insurance Coverage"]
[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,"Part 1\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",null,null,{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(E18)+0,MONTH(E18)+3,DAY(E18)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(G18)+0,MONTH(G18)+3,DAY(G18)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(I18)+0,MONTH(I18)+3,DAY(I18)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(K18)+0,MONTH(K18)+3,DAY(K18)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(M18)+0,MONTH(M18)+3,DAY(M18)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(O18)+0,MONTH(O18)+3,DAY(O18)+0)","v":"2018-03-31"}]
[null,null,null,null,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":747877.52679999999},{"$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":750974.52320000005},{"$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":492942.30000000005},{"$f":"'Pt 2 Premium and Claims'!N51","v":497486.42000000004},{"$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,null,null,null,null,null,3696,3191]
[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,17575,17648]
[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,21271,20839,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,67384,67663]
[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,151595,152223]
[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,218979,219886,0,0]
[]
[null,"5.","Other Indicators or information "]
[null,null,5.0999999999999996,"Number of covered lives",null,null,null,null,null,null,null,null,621,626]
[null,null,5.2,"Member months",null,null,null,null,null,null,null,null,7608,7622]
[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":634},{"$f":"N48/12","v":635.16666666666663},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/2017 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":[[5,1,5,3],[7,1,7,3],[9,1,9,3],[5,4,10,5],[11,1,11,3],[18,1,19,3],[11,4,11,5],[14,4,14,9],[16,6,16,7],[16,8,16,9],[16,4,16,5],[15,4,15,9],[5,10,5,11],[7,10,7,11],[9,10,9,11],[11,10,11,11],[16,10,16,11],[14,10,14,15],[15,10,15,15],[16,12,16,13],[16,14,16,15]]}
[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,{"$f":"'Cover Page'!C7","v":0},null,null,"Part 2"]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[]
[null,null,null,null,"Health Insurance Coverage",null,null,null,null,null,"Health Insurance Coverage"]
[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,"Part 2\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",null,null,{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(E19)+0,MONTH(E19)+3,DAY(E19)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(G19)+0,MONTH(G19)+3,DAY(G19)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(I19)+0,MONTH(I19)+3,DAY(I19)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(K19)+0,MONTH(K19)+3,DAY(K19)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(M19)+0,MONTH(M19)+3,DAY(M19)+0)","v":"2018-03-31"},{"$f":"\"12/31/\"&\"\"&'Cover Page'!C$6","v":"12/31/2017"},{"$f":"DATE(YEAR(O19)+0,MONTH(O19)+3,DAY(O19)+0)","v":"2018-03-31"}]
[null,null,null,null,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,747877.52679999999,750974.52320000005]
[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,456669.95000000007]
[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,491774.52]
[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,36272.35]
[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,5711.9000000000005]
[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":492942.30000000005},{"$f":"N30+N33+N37+N41+N44+N47+N48+N50","v":497486.42000000004},{"$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":[[1,3,1,4],[83,1,83,2],[86,1,86,2],[73,3,73,11],[70,3,70,11],[71,3,71,11],[72,3,72,11],[65,3,65,11],[66,3,66,11],[68,3,68,11],[69,3,69,11],[63,3,63,11],[64,3,64,11],[57,3,57,11],[58,3,58,11],[59,3,59,11],[60,3,60,11],[61,3,61,11],[62,3,62,11],[67,3,67,11],[52,3,52,11],[55,3,55,11],[56,3,56,11],[53,3,53,11],[54,3,54,11],[48,3,48,11],[49,3,49,11],[50,3,50,11],[51,3,51,11],[42,3,42,11],[43,3,43,11],[44,3,44,11],[45,3,45,11],[46,3,46,11],[47,3,47,11],[29,3,29,11],[22,3,22,11],[23,3,23,11],[41,3,41,11],[30,3,30,11],[31,3,31,11],[32,3,32,11],[33,3,33,11],[34,3,34,11],[35,3,35,11],[36,3,36,11],[37,3,37,11],[38,3,38,11],[39,3,39,11],[40,3,40,11],[25,3,25,11],[26,3,26,11],[21,3,21,11],[27,3,27,11],[28,3,28,11],[5,3,9,5],[14,3,14,11],[15,3,15,11],[16,3,16,11],[17,3,17,11],[19,3,19,11],[20,3,20,11],[18,3,18,11],[24,3,24,11],[79,3,79,11],[80,3,80,11],[74,3,74,11],[75,3,75,11],[76,3,76,11],[77,3,77,11],[78,3,78,11]]}
[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 National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[]
[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,"Federal Income Tax rate is (20.00%) of Net income"]
[]
[]
[]
[]
[]
[null,"2.b State insurance, premium and other taxes"]
[null,null,null,"Actual premium tax expense is calculated at 2.35% of premium"]
[]
[]
[]
[]
[]
[null,"2.c Community benefit expenditures "]
[null,"none"]
[]
[]
[]
[]
[]
[null,"2.d Regulatory authority licenses and fees"]
[null,"none"]
[]
[]
[]
[]
[]
[null,"3.  Non-Claims costs"]
[null,"3.a Direct sales salaries and benefits"]
[null,"none",null," "]
[]
[]
[]
[]
[]
[null,"3.b Agents and brokers fees and commissions"]
[null,"Direct Commission State Report - ",null,"Actual Expense allocated based on Premium "]
[]
[]
[]
[]
[]
[null,"3.c Other taxes"]
[null,"none"]
[]
[]
[]
[]
[]
[null,"3.d Other general and administrative expenses"]
[null,null,null,"Actual Expense allocated based on Premium "]
[]
[]
[]
[]
[]
[]
[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":[[11,1,11,3],[1,10,1,11],[5,5,9,6],[1,12,1,13],[1,5,1,6],[1,8,1,9],[5,1,5,3],[7,1,7,3],[9,1,9,3],[40,3,40,4],[37,3,37,4],[17,1,18,3],[14,4,14,15],[16,4,16,7],[16,8,16,11],[16,12,16,15],[15,4,15,15],[31,2,31,3],[1,24,1,25],[14,16,14,27],[15,16,15,27],[16,24,16,27],[1,17,1,18],[1,20,1,21],[1,22,1,23],[16,16,16,19],[16,20,16,23]]}
[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,{"$f":"'Cover Page'!C7","v":0},null,null,null,"Part 4"]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[]
[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,"DHMO Products",null,null,null,null,null,null,null,null,null,null,null,"DPPO & Indemnity Products"]
[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,"Part 4\nNOTE: REFER TO MLR INSTRUCTIONS FOR IMPORTANT INFORMATION ABOUT COMPLETING EACH COLUMN AND ROW.",null,null,"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,null,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,756784.78251887613,507429.64307782939,null,null,376965.72271246102,81327.52692217099]
[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},756784.78251887613,507429.64307782939,{"$f":"'Pt 1 Summary of Data'!N24","v":497486.42000000004},{"$f":"SUM(U22:W22)","v":1761700.8455967056},376965.72271246102,81327.52692217099,{"$f":"'Pt 1 Summary of Data'!P24","v":0},{"$f":"SUM(Y22:AA22)","v":458293.24963463203}]
[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":756784.78251887613},{"$f":"SUM(V$22:V$22)","v":507429.64307782939},{"$f":"SUM(W$22:W$22)","v":497486.42000000004},{"$f":"SUM(U23:W23)","v":1761700.8455967056},{"$f":"SUM(Y$22:Y$22)","v":376965.72271246102},{"$f":"SUM(Z$22:Z$22)","v":81327.52692217099},{"$f":"SUM(AA$22:AA$22)","v":0},{"$f":"SUM(Y23:AA23)","v":458293.24963463203}]
[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},1036466.3481108638,813303.21840000106,{"$f":"'Pt 1 Summary of Data'!N21","v":750974.52320000005},{"$f":"SUM(U26:W26)","v":2600744.0897108652},377330.70909118652,114465.51000000001,{"$f":"'Pt 1 Summary of Data'!P21","v":0},{"$f":"SUM(Y26:AA26)","v":491796.21909118653}]
[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},24357,74930,{"$f":"'Pt 1 Summary of Data'!N35","v":20839},{"$f":"SUM(U27:W27)","v":120126},8447,7077,{"$f":"'Pt 1 Summary of Data'!P35","v":0},{"$f":"SUM(Y27:AA27)","v":15524}]
[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},1012109.3481108638,738373.21840000106,730135.52320000005,{"$f":"X$26-X$27","v":2480618.0897108652},368883.70909118652,107388.51000000001,0,{"$f":"AB$26-AB$27","v":476272.21909118653}]
[]
[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},946.33333333333337,748,{"$f":"'Pt 1 Summary of Data'!N49","v":635.16666666666663},{"$f":"SUM(U30:W30)","v":2329.5},452.75,102,{"$f":"'Pt 1 Summary of Data'!P49","v":0},{"$f":"SUM(Y30:AA30)","v":554.75}]
[]
[null,"4.","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":0.7101862446718048},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":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[16,1,16,3],[21,1,21,4],[20,1,20,4],[19,1,19,4],[18,1,18,4],[26,1,26,4],[25,1,25,4],[24,1,24,4],[32,1,32,2],[31,1,31,4],[30,1,30,4],[28,1,28,4],[27,1,27,4],[41,3,41,4],[42,1,42,2],[42,3,42,4],[43,1,43,4],[38,1,38,2],[38,3,38,4],[39,1,39,2],[39,3,39,4],[40,1,40,2],[40,3,40,4],[41,1,41,2],[6,3,9,4],[23,1,23,4],[22,1,22,4],[37,1,37,2],[37,3,37,4],[34,1,34,2],[34,3,34,4],[35,3,35,4],[36,1,36,2],[36,3,36,4],[35,1,35,2],[29,1,29,4],[17,1,17,4],[32,3,32,4],[33,1,33,2],[33,3,33,4]]}
[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",null,"Part 5"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[]
[]
[null,null,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",null,"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,1,22,10],[5,6,9,8]]}
[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,null,null,null,"Attestation"]
[null,"Legal Name"]
[null,{"$f":"'Cover Page'!C8","v":"Dearborn National Life Insurance Company"}]
[null,"dBA"]
[null,{"$f":"'Cover Page'!C9","v":"Health Insurer "}]
[null,"MLR Reporting Year"]
[null,{"$f":"'Cover Page'!C6","v":"2017"}]
[]
[]
[]
[]
[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,"Chief Financial Officer"]