{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Sheet","Calculator","Growth Estimate"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Input Sheet","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,7,2,8],[4,7,4,8]]}
[]
[]
[null,null,null,null,null,"Name of Broker Firm",null,"Broker Name"]
[]
[null,null,null,null,null,"Name of Client",null,"Client name"]
[]
[]
[]
["Total Number of Employees",null,null,200,null,null,null,"Percentage of VB Commission to Broker",0.3]
["Total Number of Eligible Employees",null,null,200,null,null,null,"Total Revenue to Broker from  VB Plans",0]
[]
[]
["Core Plans from Broker","2019 Enrolled","2019 Annual\nPremium","Product Commission Percentage",null,"VB Products","2019 Enrolled","2019 Annual\nPremium","VB Product Commission Percentage"]
["Medical",90,600000,0.05,null,"Accident",25,20000,0.15]
["Dental",90,180000,0.1,null,"Critical Illness",0,0]
["Vision",90,30000,0.1,null,"Hospital Indemnity",0,0]
["Group Life",null,null,0.15]
["Supplemental Life",null,null,0.15,null,"Permanent Life",0,0]
["STD",null,null,0.15,null,"Pet Insurance",0]
["LTD",null,null,0.15,null,"Cancer"]
[null,null,null,0.15]
[null,null,null,0.15]
["Total Premium",null,{"$f":"SUM(C14:C22)","v":810000},null,null,"Total Premium",null,{"$f":"SUM(H14:H22)","v":20000}]

{"sheet":"Calculator","index":1,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[[19,9,21,9],[1,9,1,10],[2,9,2,10],[1,3,1,6],[3,9,3,10]]}
[]
[null,null,null,"Revenue Growth Calculator",null,null,null,null,"Name of Broker Firm:",{"$f":"'Input Sheet'!H3","v":"Broker Name"}]
[null,null,null,"Revenue Growth Estimates from Improved Engagement in Enrollment",null,null,null,null,"Client:",{"$f":"'Input Sheet'!H5","v":"Client name"}]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2020-08-22"}]
[null,null,null,null,null,null,null,null,"Engagement Summary",null,"Total"]
[null,null,null,null,null,null,null,null,"Total Eligible",null,{"$f":"'Input Sheet'!D10","v":200}]
[null,null,null,null,null,null,null,null,"Total Engagement",null,{"$f":"K6*K8","v":180}]
[null,null,null,null,null,null,null,null,null,"OE Engagement",0.9]
[]
["Core Plans from Broker","2020 Enrolled","2020 Annual\nPremium","2021 Enrollment projection","Percent Change","Participation","2021 Annual Premium","2020 Broker Commision - Actual","2021 Broker Commission Estimated","Product Commission\nPercentage","1st yr VB Commission Percentage"]
["Medical",{"$f":"'Input Sheet'!B14","v":90},{"$f":"'Input Sheet'!C14","v":600000},{"$f":"B11*(1+E11)","v":99.000000000000014},0.1,{"$f":"D11/$K$6","v":0.49500000000000005},{"$f":"C11*(1+E11)","v":660000},{"$f":"(C11*J11)","v":30000},{"$f":"(G11*J11)","v":33000},{"$f":"'Input Sheet'!D14","v":0.05},"NA"]
["Dental",{"$f":"'Input Sheet'!B15","v":90},{"$f":"'Input Sheet'!C15","v":180000},{"$f":"B12*(1+E12)","v":99.000000000000014},0.1,{"$f":"D12/$K$6","v":0.49500000000000005},{"$f":"C12*(1+E12)","v":198000.00000000003},{"$f":"(C12*J12)","v":18000},19800.000000000004,{"$f":"'Input Sheet'!D15","v":0.1},"NA"]
["Vision",{"$f":"'Input Sheet'!B16","v":90},{"$f":"'Input Sheet'!C16","v":30000},99.000000000000014,0.1,{"$f":"D13/$K$6","v":0.49500000000000005},33000,{"$f":"(C13*J13)","v":3000},3300,{"$f":"'Input Sheet'!D16","v":0.1},"NA"]
["Group Life",{"$f":"'Input Sheet'!B18","v":0},{"$f":"'Input Sheet'!C18","v":0},0,0.1,{"$f":"D14/$K$6","v":0},0,{"$f":"(C14*J14)","v":0},0,{"$f":"'Input Sheet'!D17","v":0.15},0]
["Supplemental Life",{"$f":"'Input Sheet'!B19","v":0},{"$f":"'Input Sheet'!C19","v":0},0,0.1,0,0,0,0,{"$f":"'Input Sheet'!D18","v":0.15},0]
["STD",{"$f":"'Input Sheet'!B19","v":0},{"$f":"'Input Sheet'!C19","v":0},0,0.1,0,0,0,0,{"$f":"'Input Sheet'!D19","v":0.15},0]
["LTD",{"$f":"'Input Sheet'!B20","v":0},{"$f":"'Input Sheet'!C20","v":0},0,0.1,0,0,0,0,{"$f":"'Input Sheet'!D20","v":0.15},0]
["Total Premium",null,{"$f":"SUM(C11:C17)","v":810000},null,null,null,{"$f":"SUM(G11:G17)","v":891000}]
[null,null,null,null,null,null,"Total Core Plans Revenue",{"$f":"SUM(H11:H17)","v":51000},{"$f":"SUM(I11:I17)","v":56100}]
[null,null,null,null,null,null,"Total VB Plans Revenue",{"$f":"'Input Sheet'!H23*'Input Sheet'!I14*'Input Sheet'!I9","v":900},{"$f":"I33","v":16560},"Estimated Revenue Growth"]
[null,null,null,null,null,null,"Other Revenue",{"$f":"C39","v":0},{"$f":"D39","v":0}]
[null,null,null,null,null,null,"Total Revenue",{"$f":"SUM(H19:H21)","v":51900},{"$f":"SUM(I19:I21)","v":72660},null,{"$f":"I22/H22-1","v":0.39999999999999991},null,"Revenue Increase",null,{"$f":"I22-H22","v":20760}]
[]
["VB Products from Reeser Group","2020 Enrolled","2020 Annual\nPremium","2021 Enrolled W/Assistance","Percent Change","Participation","Annual Premium","2020 VB Commision - Actual","2021 Broker Commission Estimated","1st yr VB Commission Percentage","Enroller Revenue"]
["Accident",{"$f":"'Input Sheet'!G14","v":25},{"$f":"'Input Sheet'!H14","v":20000},{"$f":"B25*(1+E25)","v":28.749999999999996},0.15,{"$f":"D25/$K$6","v":0.14374999999999999},{"$f":"$C$25*(1+E25)","v":23000},null,{"$f":"G25*J25*$J$33","v":4140},0.6,{"$f":"G25*J25*(1-$J$33)","v":9660}]
["Critical Illness",{"$f":"'Input Sheet'!G15","v":0},{"$f":"'Input Sheet'!H15","v":0},{"$f":"$B$25*(1+E26)","v":28.749999999999996},0.15,{"$f":"D26/$K$6","v":0.14374999999999999},{"$f":"$C$25*(1+E26)","v":23000},null,4140,0.6,{"$f":"G26*J26*(1-$J$33)","v":9660}]
["Hospital Indemnity",{"$f":"'Input Sheet'!G16","v":0},{"$f":"'Input Sheet'!H16","v":0},{"$f":"$B$25*(1+E27)","v":28.749999999999996},0.15,{"$f":"D27/$K$6","v":0.14374999999999999},23000,null,4140,0.6,9660]
["Permanent Life",{"$f":"'Input Sheet'!G18","v":0},{"$f":"'Input Sheet'!H18","v":0},28.749999999999996,0.15,{"$f":"D28/$K$6","v":0.14374999999999999},23000,null,3450,0.5,8049.9999999999991]
["Pet Insurance",{"$f":"'Input Sheet'!G19","v":0},{"$f":"'Input Sheet'!H19","v":0},28.749999999999996,0.15,{"$f":"D29/$K$6","v":0.14374999999999999},23000,null,690,0.1,1610]
["Cancer",{"$f":"'Input Sheet'!G20","v":0},{"$f":"'Input Sheet'!H20","v":0},null,null,null,null,null,0,0.6,0]
[null,{"$f":"'Input Sheet'!G21","v":0},{"$f":"'Input Sheet'!H21","v":0},null,null,null,null,null,0,0.6,0]
["Total Premium",null,{"$f":"SUM(C25:C31)","v":20000},null,null,null,{"$f":"SUM(G25:G29)","v":115000},null,null,"Split"]
[null,null,null,null,null,null,"Total VB Plans Revenue",4000,{"$f":"SUM(I25:I31)","v":16560},{"$f":"'Input Sheet'!I9","v":0.3},{"$f":"SUM(K25:K31)","v":38640}]
[]
[null,"Additional Sources of revenue","2020 Actual","2021 Projected",null,null,null,null,null,"Enroller Expenses"]
[null,"Technology Payments",null,null,null,null,null,null,null,"Implementation Fees",3000]
[null,"Other",null,null,null,null,null,null,null,"OE Call Center Fees",0]
[null,null,null,null,null,null,null,null,null,"Development Costs",0]
[null,"Total",{"$f":"SUM(C36:C38)","v":0},{"$f":"SUM(D36:D38)","v":0},null,null,null,null,null,"Enroller Estimated NET Annual Comp",{"$f":"(K33-K36-K37-K38)","v":35640}]

{"sheet":"Growth Estimate","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,4,12,13],[16,2,16,15],[21,3,21,8],[12,15,12,18],[6,15,6,18]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculator!J4","v":"2020-08-22"}]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"'Input Sheet'!H3","v":"Broker Name"},null,null,null,null,null,null,null,null,null,null,{"$f":"Calculator!O22","v":20760}]
[]
[]
[]
[null,null,{"$f":"spellnumberEDP(P13)","v":"Twenty  Thousand Seven Hundred Sixty  Dollars and No Cents"}]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Increase in Revenue from\",Calculator!J3)","v":"Increase in Revenue fromClient name"}]