{"text_format":"2","workbook":"xls","n_sheets":11,"sheets":["Intro","Balance Sheet","P & L Stmt","Premium Ratios","Multipliers","Cash Flow","Analysis of Op. By Line","Nationwide Premium by LOB","ST","Assumptions","Warning"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":68,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Intro","index":0,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":12},false]
[{"$nulls":12},false,"AK","Alaska","Z","NC"]
[{"$nulls":12},false,"AL","Alabama","Z","PR","Current"]
[null,null,null,"AK","Alaska",null,null,"MT","Montana",null,null,null,false,"AR","Arkansas","Z","TN",null,"Alaska","Go to AK"]
[null,null,null,"AL","Alabama",null,null,"NC","North Carolina",null,null,null,false,"AS","American Samoa","Z","WI",null,"Alabama","Go to AL"]
[null,null,null,"AR","Arkansas",null,null,"ND","North Dakota",null,null,null,false,"AZ","Arizona","Z","Z",null,"Arkansas","Go to AR"]
[null,null,null,"AS","American Samoa",null,null,"NE","Nebraska",null,null,null,false,"CA","California","Z","Z",null,"American Samoa","Go to AS"]
[null,null,null,"AZ","Arizona",null,null,"NH","New Hampshire",null,null,null,false,"CO","Colorado","Z","Z",null,"Arizona","Go to AZ"]
[null,null,null,"CA","California",null,null,"NJ","New Jersey",null,null,null,false,"CT","Connecticut","Z","Z",null,"California","Go to CA"]
[null,null,null,"CO","Colorado",null,null,"NM","New Mexico",null,null,null,false,"DC","District Of Columbia","Z","Z",null,"Colorado","Go to CO"]
[null,null,null,"CT","Connecticut",null,null,"NV","Nevada",null,null,null,false,"DE","Delaware","Z","Z",null,"Connecticut","Go to CT"]
[null,null,null,"DC","District Of Columbia",null,null,"NY","New York",null,null,null,false,"FL","Florida","Z","Z",null,"District Of Columbia","Go to DC"]
[null,null,null,"DE","Delaware",null,null,"OH","Ohio",null,null,null,false,"GA","Georgia","Z","Z",null,"Delaware","Go to DE"]
[null,null,null,"FL","Florida",null,null,"OK","Oklahoma",null,null,null,false,"GU","Guam","Z","Z",null,"Florida","Go to FL"]
[null,null,null,"GA","Georgia",null,null,"OR","Oregon",null,null,null,false,"HI","Hawaii","Z","Z",null,"Georgia","Go to GA"]
[null,null,null,"GU","Guam",null,null,"PA","Pennsylvania",null,null,null,false,"IA","Iowa","Z","Z",null,"Guam","Go to GU"]
[null,null,null,"HI","Hawaii",null,null,"PR","Puerto Rico",null,null,null,false,"ID","Idaho","Z","Z",null,"Hawaii","Go to HI"]
[null,null,null,"IA","Iowa",null,null,"RI","Rhode Island",null,null,null,false,"IL","Illinois","Z","Z",null,"Iowa","Go to IA"]
[null,null,null,"ID","Idaho",null,null,"SC","South Carolina",null,null,null,false,"IN","Indiana","Z","Z",null,"Idaho","Go to ID"]
[null,null,null,"IL","Illinois",null,null,"SD","South Dakota",null,null,null,false,"KS","Kansas","Z","Z",null,"Illinois","Go to IL"]
[null,"Enter  the Applicant Company Name:",null,"IN","Indiana",null,null,"TN","Tennessee",null,null,null,false,"KY","Kentucky","Z","Z",null,"Indiana","Go to IN"]
[null,null,null,"KS","Kansas",null,null,"TX","Texas",null,null,null,false,"LA","Louisiana","Z","Z",null,"Kansas","Go to KS"]
[null,"Applicant Company Name",null,"KY","Kentucky",null,null,"UT","Utah",null,null,null,false,"MA","Massachusetts","Z","Z",null,"Kentucky","Go to KY"]
[null,null,null,"LA","Louisiana",null,null,"VA","Virginia",null,null,null,false,"MD","Maryland","Z","Z",null,"Louisiana","Go to LA"]
["Year 1:",null,null,"MA","Massachusetts",null,null,"VI","U.S. Virgin Islands",null,null,null,false,"ME","Maine","Z","Z",null,"Massachusetts","Go to MA"]
[null,null,null,"MD","Maryland",null,null,"VT","Vermont",null,null,null,false,"MI","Michigan","Z","Z",null,"Maryland","Go to MD"]
["Year 2:",1,null,"ME","Maine",null,null,"WA","Washington",null,null,null,false,"MN","Minnesota","Z","Z",null,"Maine","Go to ME"]
[null,null,null,"MI","Michigan",null,null,"WI","Wisconsin",null,null,null,false,"MO","Missouri","Z","Z",null,"Michigan","Go to MI"]
["Year 3:",2,null,"MN","Minnesota",null,null,"WV","West Virginia",null,null,null,false,"MS","Mississippi","Z","Z",null,"Minnesota","Go to MN"]
[null,null,null,"MO","Missouri",null,null,"WY","Wyoming",null,null,null,false,"MT","Montana","Z","Z",null,"Missouri","Go to MO"]
[null,null,null,"MS","Mississippi",{"$nulls":7},false,"NC","North Carolina","Z","Z",null,"Mississippi","Go to MS"]
[{"$nulls":12},false,"ND","North Dakota","Z","Z",null,"Montana","Go to MT"]
[{"$nulls":12},false,"NE","Nebraska","Z","Z",null,"North Carolina","Go to NC"]
[{"$nulls":12},false,"NH","New Hampshire","Z","Z",null,"North Dakota","Go to ND"]
[{"$nulls":12},false,"NJ","New Jersey","Z","Z",null,"Nebraska","Go to NE"]
[{"$nulls":12},false,"NM","New Mexico","Z","Z",null,"New Hampshire","Go to NH"]
[{"$nulls":12},false,"NV","Nevada","Z","Z",null,"New Jersey","Go to NJ"]
[{"$nulls":12},false,"NY","New York","Z","Z",null,"New Mexico","Go to NM"]
[{"$nulls":12},false,"OH","Ohio","Z","Z",null,"Nevada","Go to NV"]
[{"$nulls":12},false,"OK","Oklahoma","Z","Z",null,"New York","Go to NY"]
["Updated: 08/18/2014",{"$nulls":11},false,"OR","Oregon","Z","Z",null,"Ohio","Go to OH"]
[{"$nulls":12},false,"PA","Pennsylvania","Z","Z",null,"Oklahoma","Go to OK"]
["OIR-D0-904",{"$nulls":11},false,"PR","Puerto Rico","Z","Z",null,"Oregon","Go to OR"]
[" Rev 8/14",{"$nulls":11},false,"RI","Rhode Island","Z","Z",null,"Pennsylvania","Go to PA"]
["Rule 69O-143.056",{"$nulls":11},false,"SC","South Carolina","Z","Z",null,"Puerto Rico","Go to PR"]
[{"$nulls":12},false,"SD","South Dakota","Z","Z",null,"Rhode Island","Go to RI"]
[{"$nulls":12},false,"TN","Tennessee","Z","Z",null,"South Carolina","Go to SC"]
[{"$nulls":12},false,"TX","Texas","Z","Z",null,"South Dakota","Go to SD"]
[{"$nulls":12},false,"UT","Utah","Z","Z",null,"Tennessee","Go to TN"]
[{"$nulls":12},false,"VA","Virginia","Z","Z",null,"Texas","Go to TX"]
[{"$nulls":12},false,"VI","U.S. Virgin Islands","Z","Z",null,"Utah","Go to UT"]
[{"$nulls":12},false,"VT","Vermont","Z","Z",null,"Virginia","Go to VA"]
[{"$nulls":12},false,"WA","Washington","Z","Z",null,"U.S. Virgin Islands","Go to VI"]
[{"$nulls":12},false,"WI","Wisconsin","Z","Z",null,"Vermont","Go to VT"]
[{"$nulls":12},false,"WV","West Virginia","Z","Z",null,"Washington","Go to WA"]
[{"$nulls":12},false,"WY","Wyoming","Z","Z",null,"Wisconsin","Go to WI"]
[{"$nulls":18},"West Virginia","Go to WV"]
[{"$nulls":18},"Wyoming","Go to WY"]

{"sheet":"Balance Sheet","index":1,"n_rows":49,"n_cols":20,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,7,0,11],[0,4,0,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"Applicant Company Name:",null,null,"Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Pro Forma Statutory Balance Sheet (Nationwide)"]
[{"$nulls":5},"(In Thousands)"]
[]
[]
[]
[null,null,null,0,{"$nulls":7},1,{"$nulls":7},2]
["Admitted Assets"]
["-------------------"]
["1.    Bonds",{"$nulls":17},"_____________"]
["2.   Stock"]
["3.   Real Estate/Mortgage Investments"]
["4.   Affiliated Investments",{"$nulls":17},"_____________"]
["5.   Affiliated Receivables"]
["6.   Cash/Cash Equivalents"]
["7.   Separate Account Assets"]
["8.   All Other Assets"]
["9.   Total Assets",null,null,0,{"$nulls":7},0,{"$nulls":6},0,0]
[]
[]
[]
["Liabilities"]
["-------------------"]
["10.   Losses (Unpaid Claims for Life & Health Policies)",{"$nulls":17},"____________"]
["11.  Reserve for Life Policies",{"$nulls":17},"____________"]
["12.   Reserve for Accident and Health Policies",{"$nulls":17},"____________"]
["13.  Ceded Reinsurance Payable",{"$nulls":17},"____________"]
["14.  Payable to Parents, Subsidiaries & Affiliates"]
["15.  All Other Liabilities"]
["16.  Asset Valuation Reserve(AVR)"]
["17.  Separate Account Liabilites"]
["18.  Total Liabilities(10+11+12+13+14+15+16+17)",null,null,0,{"$nulls":7},0,{"$nulls":6},0,0]
[]
["Capital and Surplus"]
["-------------------"]
["19.  Capital Stock"]
["20.   Gross Paid In and Contributed Surplus",{"$nulls":17},"___________"]
["21.  Surplus Notes",{"$nulls":17},"___________"]
["22.   Unassigned Surplus",{"$nulls":17},"___________"]
["23.  Other Items(elaborate)"]
["24.  Total Capital and Surplus(19+20+21+22+23)",null,null,0,{"$nulls":7},0,{"$nulls":6},0,0]
[]
[]
[{"$nulls":7},"Risk-Based Capital Analysis"]
[]
["25. Authorized Control Level Risk-Based Capital",{"$nulls":17},"___________"]
["26. Calculated Risk-Based Capital (24/25)",null,null,0,{"$nulls":7},0,{"$nulls":7},0]
["    "]

{"sheet":"P & L Stmt","index":2,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,10]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"Applicant Company Name:","Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Pro Forma Statutory Profit & Loss Statement (Nationwide)"]
[{"$nulls":5},"(In Thousands)"]
[]
[{"$nulls":4},0,null,null,null,1,null,null,null,2]
[" 1.   Net Premiums (All Business)"]
[" 2.  Net Investment Income"]
[" 3.  Reinsurance Ceding Commissions"]
[" 4.  Miscellaneous Income"]
[" 5.  Total (1+2+3+4)",null,null,null,0,null,null,null,0,null,null,null,0]
[]
[" 6.  Death Benefits"]
[" 7.  Matured Endowments"]
[" 8.  Annuity Benefits"]
[" 9.  Accident and Health Policy Benefits"]
["10.  Surrender Benefits and Other Fund"]
["       Withdrawals"]
["11.   Group Conversions"]
["12.  Interest on Policy and Contract Funds"]
["13.  Commissions on Premiums and Annuity"]
["       Considerations - Direct Business"]
["14.  Commissions and Expense Allowances"]
["       on Reinsurance Assumed"]
["15.  Increase in Aggregate Reseves"]
["16. Net Transer (to) or from Separate "]
["     Accounts Net of Reinsurance"]
["17.  Other Expenses *"]
[]
["18.  Total Expenses (sum6…17)",null,null,null,0,null,null,null,0,null,null,null,0]
[]
["19.   Net Gain (Loss) from Operations Before"]
["        Dividends and Federal Income Taxes(5-17)",null,null,null,0,null,null,null,0,null,null,null,0]
[]
["20.  Federal Income Taxes",null,null,null,0]
[]
["21.   Net Realized Capital Gains (Losses)"]
["22.  Less Capital Gains Tax"]
[]
["23.  Net Income((19-20)+(21-22))",null,null,null,0,null,null,null,0,null,null,null,0]
[]
["24.  Prior YE Surplus"]
["25.  Net Income",null,null,null,0,null,null,null,0,null,null,null,0]
["26.  Capital Increases"]
["27.  Other Increases (Decreases)"]
["28.  Dividends to Stockholders"]
["29.  YE Surplus",null,null,null,0,null,null,null,0,null,null,null,0]
[]
["*Itemize in Assumptions"]

{"sheet":"Premium Ratios","index":3,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,7,1,10]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Company Name:",null,null,"Applicant Company Name"]
[null,"Nationwide",null,null,"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":4},"Premiums Written to Surplus Ratios"]
[]
["Year","Direct",null,"Assumed ",null,"Gross ",null,"Ceded",null,"Net",null,"Adjusted ",null,"Adjusted",null,"Adjusted Gross",null,"Adjusted Net"]
[null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Gross",null,"Net ",null,"Written Premiums",null,"Written Premiums"]
[null,"Written",null,"Written",null,"Written",null,"Written",null,"Written",null,"Premiums",null,"Premiums",null,"to Surplus",null,"to Surplus"]
[null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[]
[]
[0,0,null,0,null,0,null,0,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
[1,0,null,0,null,0,null,0,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
[2,0,null,0,null,0,null,0,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]

{"sheet":"Multipliers","index":4,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,null,null,"Ordinary Life","Ordinary Individual Annuities"," Credit Life (Group and Individual)","Group Life Insurance","Group Annuities","Credit Accident and Health (Group and Individual)","Other Accident and Health","Aggregate of All Other Lines of Business"]
[]
[1,"AK","Alaska",1,1,1,1,1,1,1,1]
[2,"AL","Alabama",1,1,1,1,1,1,1,1]
[3,"AR","Arkansas",1,1,1,1,1,1,1,1]
[4,"AS","American Samoa",1,1,1,1,1,1,1,1]
[5,"AZ","Arizona",1,1,1,1,1,1,1,1]
[6,"CA","California",1,1,1,1,1,1,1,1]
[7,"CO","Colorado",1,1,1,1,1,1,1,1]
[8,"CT","Connecticut",1,1,1,1,1,1,1,1]
[9,"DC","District Of Columbia",1,1,1,1,1,1,1,1]
[10,"DE","Delaware",1,1,1,1,1,1,1,1]
[11,"FL","Florida",1,1,1,1,1,0.8,0.8,1]
[12,"GA","Georgia",1,1,1,1,1,1,1,1]
[13,"GU","Guam",1,1,1,1,1,1,1,1]
[14,"HI","Hawaii",1,1,1,1,1,1,1,1]
[15,"IA","Iowa",1,1,1,1,1,1,1,1]
[16,"ID","Idaho",1,1,1,1,1,1,1,1]
[17,"IL","Illinois",1,1,1,1,1,1,1,1]
[18,"IN","Indiana",1,1,1,1,1,1,1,1]
[19,"KS","Kansas",1,1,1,1,1,1,1,1]
[20,"KY","Kentucky",1,1,1,1,1,1,1,1]
[21,"LA","Louisiana",1,1,1,1,1,1,1,1]
[22,"MA","Massachusetts",1,1,1,1,1,1,1,1]
[23,"MD","Maryland",1,1,1,1,1,1,1,1]
[24,"ME","Maine",1,1,1,1,1,1,1,1]
[25,"MI","Michigan",1,1,1,1,1,1,1,1]
[26,"MN","Minnesota",1,1,1,1,1,1,1,1]
[27,"MO","Missouri",1,1,1,1,1,1,1,1]
[28,"MS","Mississippi",1,1,1,1,1,1,1,1]
[29,"MT","Montana",1,1,1,1,1,1,1,1]
[30,"NC","North Carolina",1,1,1,1,1,1,1,1]
[31,"ND","North Dakota",1,1,1,1,1,1,1,1]
[32,"NE","Nebraska",1,1,1,1,1,1,1,1]
[33,"NH","New Hampshire",1,1,1,1,1,1,1,1]
[34,"NJ","New Jersey",1,1,1,1,1,1,1,1]
[35,"NM","New Mexico",1,1,1,1,1,1,1,1]
[36,"NV","Nevada",1,1,1,1,1,1,1,1]
[37,"NY","New York",1,1,1,1,1,1,1,1]
[38,"OH","Ohio",1,1,1,1,1,1,1,1]
[39,"OK","Oklahoma",1,1,1,1,1,1,1,1]
[40,"OR","Oregon",1,1,1,1,1,1,1,1]
[41,"PA","Pennsylvania",1,1,1,1,1,1,1,1]
[42,"PR","Puerto Rico",1,1,1,1,1,1,1,1]
[43,"RI","Rhode Island",1,1,1,1,1,1,1,1]
[44,"SC","South Carolina",1,1,1,1,1,1,1,1]
[45,"SD","South Dakota",1,1,1,1,1,1,1,1]
[46,"TN","Tennessee",1,1,1,1,1,1,1,1]
[47,"TX","Texas",1,1,1,1,1,1,1,1]
[48,"UT","Utah",1,1,1,1,1,1,1,1]
[49,"VA","Virginia",1,1,1,1,1,1,1,1]
[50,"VI","U.S. Virgin Islands",1,1,1,1,1,1,1,1]
[51,"VT","Vermont",1,1,1,1,1,1,1,1]
[52,"WA","Washington",1,1,1,1,1,1,1,1]
[53,"WI","Wisconsin",1,1,1,1,1,1,1,1]
[54,"WV","West Virginia",1,1,1,1,1,1,1,1]
[55,"WY","Wyoming",1,1,1,1,1,1,1,1]
[56]
[null,null,"Counter",1,2,3,4,5,6,7,8]
[null,null,"Multiplier Used"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Cash Flow","index":5,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,7,0,10]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Applicant Company Name:",null,"Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Pro Forma Statutory Cash Flow Statement"]
[{"$nulls":5},"(In Thousands)"]
[]
[{"$nulls":4},0,null,null,null,1,null,null,null,2]
[null,"Cash From Operations"]
[null,"1.  Premiums Collected Net of Reinsurance"]
[null,"2.  Benefits Paid "]
[null,"3.  Underwriting Expenses Paid"]
[null,"4.  Total Cash From Underwriting(1-2-3)",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"5.  Net Investment Income"]
[null,"6.  Other Income"]
[null,"7.  Dividends to Policyholders"]
[null,"8.  Federal and Foreign Income Taxes (Paid) Recovered"]
[null,"9.  Net Cash From Operations(4+5+6-7+8)",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Cash From Investments"]
[null,"10. Net Cash from Investments"]
[]
[]
[null,"Cash From Financing and Misc Sources"]
[null,"11.  Capital and paid in Surplus"]
[null,"12.  Surplus Notes"]
[null,"13.  Borrowed Funds"]
[null,"14.  Dividends"]
[null,"15.  Other Cash Provided (Applied)"]
[null,"16.  Net Cash from Financing and Misc Sources"]
[null,"      (11+12+13-14+15)",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"17. Net Change in Cash, Cash Equivalents and Short -Term ",null,null,0,null,null,null,0,null,null,null,0]
[null,"     Investments(9+10+16)"]

{"sheet":"Analysis of Op. By Line","index":6,"n_rows":130,"n_cols":21,"rows_kept":130,"cut":false,"hidden":false,"merged":[[49,15,49,19],[45,6,45,9],[89,6,89,9],[93,5,93,7],[93,11,93,13],[93,15,93,19],[1,6,1,9],[6,11,6,13],[6,5,6,7],[6,15,6,19],[49,5,49,7],[49,11,49,13]],"flags":["formulas_cached_only"]}
["Nationwide"]
["Year 1",{"$nulls":4},"Applicant Company Name:","Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Analysis of Operations by Line of Business"]
[{"$nulls":5},"(In Thousands)"]
[]
[{"$nulls":5},"Ordinary",{"$nulls":5},"Group",null,null,null,"Accident and Health"]
[{"$nulls":4},"Total","Life \nInsurance","Individual \nAnnuities","Supplementary \nContracts",null,"Credit Life\n (Group & Individual)",null,"Life Insurance (a)",null,"Annuities",null,"Group",null,"Credit \n(Group and Individual)",null,"Other ","Aggregate of All \nOther Lines Business"]
[" 1.  Net Premiums (All Business)",null,null,null,0]
[" 2.  Net Investment Income",null,null,null,0]
[" 3.  Reinsurance Ceding Commissions",null,null,null,0]
[" 4.  Miscellaneous Income",null,null,null,0]
[" 5.  Total Revenue (1+2+3+4)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
[" 6.  Death Benefits",null,null,null,0]
[" 7.  Matured Endowments",null,null,null,0]
[" 8.  Annuity Benefits",null,null,null,0]
[" 9.  Accident and Health Policy Benefits",null,null,null,0]
["10. Surrender Benefits and Other Fund"]
["      Withdrawals",null,null,null,0]
["11. Group Conversions",null,null,null,0]
["12. Interest on Policy and Contract Funds",null,null,null,0]
["13. Commissions on Premiums and Annuity"]
["      Considerations - Direct Business",null,null,null,0]
["14. Commissions and Expense Allowances"]
["      on Reinsurance Assumed",null,null,null,0]
["15. Other Expenses ",null,null,null,0]
[{"$nulls":4},0]
["16. Total Expenses (sum6…15)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["17.  Net Transfer (to) or from Separate "]
["      Accounts Net of Reinsurance",null,null,null,0]
["18. Net Gain (Loss) from Operations Before"]
["      Dividends and Federal Income Taxes(5-16-17)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["19. Federal Income Taxes",null,null,null,0]
[]
["20. Net Realized Capital Gains (Losses)",null,null,null,0]
["21. Less Capital Gains Tax",null,null,null,0]
[]
["22. Net Income((18-19)+(20-21))",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["23.Stockholder Dividends"]
[]
["Nationwide"]
["Year 2",{"$nulls":4},"Applicant Company Name:","Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Analysis of Operations by Line of Business"]
[{"$nulls":5},"(In Thousands)"]
[{"$nulls":5},"Ordinary",{"$nulls":5},"Group",null,null,null,"Accident and Health"]
[{"$nulls":4},"Total","Life \nInsurance","Individual \nAnnuities","Supplementary \nContracts",null,"Group Life\n (Group & Individual)",null,"Life Insurance (a)",null,"Annuities",null,"Group",null,"Credit \n(Group and Individual)",null,"Other ","Aggregate of All \nOther Lines Business"]
[" 1.  Net Premiums (All Business)",null,null,null,0]
[" 2.  Net Investment Income",null,null,null,0]
[" 3.  Reinsurance Ceding Commissions",null,null,null,0]
[" 4.  Miscellaneous Income",null,null,null,0]
[" 5.  Total (1+2+3+4)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
[" 6.  Death Benefits",null,null,null,0]
[" 7.  Matured Endowments",null,null,null,0]
[" 8.  Annuity Benefits",null,null,null,0]
[" 9.  Accident and Health Policy Benefits",null,null,null,0]
["10. Surrender Benefits and Other Fund"]
["      Withdrawals",null,null,null,0]
["11. Group Conversions",null,null,null,0]
["12. Interest on Policy and Contract Funds",null,null,null,0]
["13. Commissions on Premiums and Annuity"]
["      Considerations - Direct Business",null,null,null,0]
["14. Commissions and Expense Allowances"]
["      on Reinsurance Assumed",null,null,null,0]
["15. Other Expenses ",null,null,null,0]
[]
["16. Total Expenses (sum6…15)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["17. Net Transfer (to) or from Separate"]
["     Accounts Net of Reinsurance.",null,null,null,0]
["18. Net Gain (Loss) from Operations Before"]
["     Dividends and Federal Income Taxes",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["19. Federal Income Taxes",null,null,null,0]
[]
["20. Net Realized Capital Gains (Losses)",null,null,null,0]
["21. Less Capital Gains Tax",null,null,null,0]
[]
["22. Net Income((18-19)+(20-21))",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["23.Stockholder Dividends"]
[]
[]
["Nationwide"]
["Year 3",{"$nulls":4},"Applicant Company Name:","Applicant Company Name"]
[{"$nulls":5},"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Analysis of Operations by Line of Business"]
[{"$nulls":5},"(In Thousands)"]
[{"$nulls":5},"Ordinary",{"$nulls":5},"Group",null,null,null,"Accident and Health"]
[{"$nulls":4},"Total","Life \nInsurance","Individual \nAnnuities","Supplementary \nContracts",null,"Group Life\n (Group & Individual)",null,"Life Insurance (a)",null,"Annuities",null,"Group",null,"Credit \n(Group and Individual)",null,"Other ","Aggregate of All \nOther Lines Business"]
[" 1.  Net Premiums (All Business)",null,null,null,0]
[" 2.  Net Investment Income",null,null,null,0]
[" 3.  Reinsurance Ceding Commissions",null,null,null,0]
[" 4.  Miscellaneous Income",null,null,null,0]
[" 5.  Total (1+2+3+4)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
[" 6.  Death Benefits",null,null,null,0]
[" 7.  Matured Endowments",null,null,null,0]
[" 8.  Annuity Benefits",null,null,null,0]
[" 9.  Accident and Health Policy Benefits",null,null,null,0]
["10. Surrender Benefits and Other Fund"]
["      Withdrawals",null,null,null,0]
["11. Group Conversions",null,null,null,0]
["12. Interest on Policy and Contract Funds",null,null,null,0]
["13. Commissions on Premiums and Annuity"]
["      Considerations - Direct Business",null,null,null,0]
["14. Commissions and Expense Allowances"]
["      on Reinsurance Assumed",null,null,null,0]
["15. Other Expenses ",null,null,null,0]
[]
["16. Total Expenses (sum6…15)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["17.  Net Transfer (to) or from Separate"]
["      Accounts Net of Reinsurance.",null,null,null,0]
["18. Net Gain (Loss) from Operations Before"]
["      Dividends and Federal Income Taxes(5-16-17)",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["19. Federal Income Taxes",null,null,null,0]
[]
["20. Net Realized Capital Gains (Losses)",null,null,null,0]
["21. Less Capital Gains Tax",null,null,null,0]
[]
["22. Net Income((18-19)+(20-21))",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[]
["23.Stockholder Dividends"]

{"sheet":"Nationwide Premium by LOB","index":7,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,0,8],[25,5,25,8],[50,5,50,8]],"flags":["formulas_cached_only"]}
["Nationwide",null,null,"Applicant Company Name:",null,"Applicant Company Name"]
["Year 1",0,null,"(Life, Accident, and Health Insurance Company)"]
[null,null,null,"Planned Premium Volume by Line of Business"]
[null,null,null,"(Amounts in Whole Dollars)"]
[]
[null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"MULTI PLIER","ADJUSTED ","ADJUSTED "]
[null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,"GROSS","NET"]
["Description"]
["----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
["1.  Ordinary Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2.  Ordinary Individual Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["3.  Credit Life",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["4.  Group Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["5.  Group Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["6.  Credit Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["7.  Other Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["8.  Aggregate of All Other ",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     Lines of Business",{"$nulls":7},""]
["9. Deposit Type Contracts"]
[{"$nulls":8},""]
["10.  Total ",null,0,null,0,null,0,null,0,null,null,{"$error":"#N/A"},{"$error":"#N/A"}," "]
[]
[]
["Nationwide",null,null,"Applicant Company Name:",null,"Applicant Company Name"]
["Year 2",1,null,"(Life, Accident, and Health Insurance Company)",{"$nulls":9}," "]
[null,null,null,"Planned Premium Volume by Line of Business (Nationwide)"]
[]
[]
[null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums "]
["Description",{"$nulls":12}," "]
["----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
["1.  Ordinary Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2.  Ordinary Individual Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["3.  Credit Life",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["4.  Group Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["5.  Group Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["6.  Credit Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["7.  Other Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["8.  Aggregate of All Other ",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     Lines of Business",{"$nulls":7},""]
["9.  Deposit Type Contracts"]
[{"$nulls":8},""]
["10.  Total",null,0,null,0,null,0,null,0,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
["Nationwide",null,null,"Applicant Company Name:",null,"Applicant Company Name"]
["Year 3",2,null,"(Life, Accident, and Health Insurance Company)"]
[null,null,null,"Planned Premium Volume by Line of Business (Nationwide)"]
[]
[]
[null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums "]
["Description"]
["----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
["1.  Ordinary Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2.  Ordinary Individual Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["3.  Credit Life",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["4.  Group Life Insurance",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["5.  Group Annuities",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["6.  Credit Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     (Group and Individual)",{"$nulls":7},""]
["7.  Other Accident and Health",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["8.  Aggregate of All Other ",{"$nulls":7},"",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["     Lines of Business",{"$nulls":7},""]
["9. Deposit Type Contracts"]
[{"$nulls":8},""]
["10.  Total",null,0,null,0,null,0,null,0,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"ST","index":8,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,7,2,9],[26,7,26,9],[50,7,50,9]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"Applicant Company Name:",null,"Applicant Company Name"]
[null,null,"Year 1",0,null,"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Planned Premium Volume by Line of Business"]
[{"$nulls":5},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":4},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":4},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums "]
[null,null,"Description"]
[null,null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,"1.  Ordinary Life Insurance",{"$nulls":7},0]
[null,null,"2.  Ordinary Individual Annuities",{"$nulls":7},0]
[null,null,"3.  Credit Life",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"4.  Group Life Insurance",{"$nulls":7},0]
[null,null,"5.  Group Annuities",{"$nulls":7},0]
[null,null,"6.  Credit Accident and Health",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"7.  Other Accident and Health",{"$nulls":7},0]
[null,null,"8.  Aggregate of All Other ",{"$nulls":7},0]
[null,null,"     Lines of Business",{"$nulls":7},0]
[{"$nulls":10},0]
[null,null,"9.  Total ",null,0,null,0,null,0,null,0,null," "]
[]
[]
[null,null,0,null,null,"Applicant Company Name:",null,"Applicant Company Name"]
[null,null,"Year 2",1,null,"(Life, Accident, and Health Insurance Company)",{"$nulls":6}," "]
[{"$nulls":5},"Planned Premium Volume by Line of Business "]
[{"$nulls":5},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":4},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":4},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums "]
[null,null,"Description",{"$nulls":9}," "]
[null,null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,"1.  Ordinary Life Insurance",{"$nulls":7},0]
[null,null,"2.  Ordinary Individual Annuities",{"$nulls":7},0]
[null,null,"3.  Credit Life",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"4.  Group Life Insurance",{"$nulls":7},0]
[null,null,"5.  Group Annuities",{"$nulls":7},0]
[null,null,"6.  Credit Accident and Health",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"7.  Other Accident and Health",{"$nulls":7},0]
[null,null,"8.  Aggregate of All Other ",{"$nulls":7},0]
[null,null,"     Lines of Business",{"$nulls":7},0]
[{"$nulls":10},0]
[null,null,"9.  Total",null,0,null,0,null,0,null,0]
[]
[]
[null,null,0,null,null,"Applicant Company Name:",null,"Applicant Company Name"]
[null,null,"Year 3",2,null,"(Life, Accident, and Health Insurance Company)"]
[{"$nulls":5},"Planned Premium Volume by Line of Business"]
[{"$nulls":5},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":4},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":4},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums "]
[null,null,"Description"]
[null,null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,"1.  Ordinary Life Insurance",{"$nulls":7},0]
[null,null,"2.  Ordinary Individual Annuities",{"$nulls":7},0]
[null,null,"3.  Credit Life",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"4.  Group Life Insurance",{"$nulls":7},0]
[null,null,"5.  Group Annuities",{"$nulls":7},0]
[null,null,"6.  Credit Accident and Health",{"$nulls":7},0]
[null,null,"     (Group and Individual)",{"$nulls":7},0]
[null,null,"7.  Other Accident and Health",{"$nulls":7},0]
[null,null,"8.  Aggregate of All Other ",{"$nulls":7},0]
[null,null,"     Lines of Business",{"$nulls":7},0]
[{"$nulls":10},0]
[null,null,"9.  Total",null,0,null,0,null,0,null,0]

{"sheet":"Assumptions","index":9,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["List all of the relevant assumptions used to create the proformas.  "]
["Note, assumptions enclosed within the Plan of Operation need not be disclosed again here."]

{"sheet":"Warning","index":10,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,10]],"flags":["formulas_cached_only"]}
["Are you sure you want to delete the selected states?"]
[]
[]
[]
["","AK","Alaska",null,"","KS","Kansas",null,"","OH","Ohio"]
["","AL","Alabama",null,"","KY","Kentucky",null,"","OK","Oklahoma"]
["","AR","Arkansas",null,"","LA","Louisiana",null,"","OR","Oregon"]
["","AS","American Samoa",null,"","MA","Massachusetts",null,"","PA","Pennsylvania"]
["","AZ","Arizona",null,"","MD","Maryland",null,"","PR","Puerto Rico"]
["","CA","California",null,"","ME","Maine",null,"","RI","Rhode Island"]
["","CO","Colorado",null,"","MI","Michigan",null,"","SC","South Carolina"]
["","CT","Connecticut",null,"","MN","Minnesota",null,"","SD","South Dakota"]
["","DC","District Of Columbia",null,"","MO","Missouri",null,"","TN","Tennessee"]
["","DE","Delaware",null,"","MT","Montana",null,"","TX","Texas"]
["","FL","Florida",null,"","NC","North Carolina",null,"","UT","Utah"]
["","GA","Georgia",null,"","ND","North Dakota",null,"","VA","Virginia"]
["","GU","Guam",null,"","NE","Nebraska",null,"","VI","U.S. Virgin Islands"]
["","HI","Hawaii",null,"","NH","New Hampshire",null,"","VT","Vermont"]
["","IA","Iowa",null,"","NJ","New Jersey",null,"","WA","Washington"]
["","ID","Idaho",null,"","NM","New Mexico",null,"","WI","Wisconsin"]
["","IL","Illinois",null,"","NV","Nevada",null,"","WV","West Virginia"]
["","IN","Indiana",null,"","NY","New York",null,"","WY","Wyoming"]
[]
["X - Indicates the state is selected to be deleted."]