{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Sheet","Calculator","Growth Estimate"],"not_rendered":{"charts":0,"images":7,"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":25,"n_cols":9,"rows_kept":25,"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,500,null,null,null,"Percentage of VB Commission to Broker",1]
["Total Number of Eligible Employees",null,null,450,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",200,1000000,0.05,null,"Accident",130,15000,0.15]
["Dental",180,90000,0.1,null,"Critical Illness",0,0]
["Vision",150,15000,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":1105000},null,null,"Total Premium",null,{"$f":"SUM(H14:H22)","v":15000}]
[]
["Please contact Darin Reeser at (281) 460-5855 or email info@workforcejunction.com, to find out more, or help with this tool."]

{"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-05-03"}]
[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":450}]
[null,null,null,null,null,null,null,null,"Total Engagement",null,{"$f":"K6*K8","v":337.5}]
[null,null,null,null,null,null,null,null,null,"OE Engagement",0.75]
[]
["Core Plans from Broker","2019 Enrolled","2019 Annual\nPremium","2020 Enrollment projection","Percent Change","Participation","2020 Annual Premium","2019 Broker Commision - Actual","2020 Broker Commission Estimated","Product Commission\nPercentage","1st yr VB Commission Percentage"]
["Medical",{"$f":"'Input Sheet'!B14","v":200},{"$f":"'Input Sheet'!C14","v":1000000},220,{"$f":"D11/B11-1","v":0.10000000000000009},{"$f":"D11/$K$6","v":0.48888888888888887},{"$f":"C11*(1+E11)","v":1100000},{"$f":"(C11*J11)","v":50000},{"$f":"(G11*J11)","v":55000},{"$f":"'Input Sheet'!D14","v":0.05},"NA"]
["Dental",{"$f":"'Input Sheet'!B15","v":180},{"$f":"'Input Sheet'!C15","v":90000},200,{"$f":"D12/B12-1","v":0.11111111111111116},{"$f":"D12/$K$6","v":0.44444444444444442},{"$f":"C12*(1+E12)","v":100000},{"$f":"(C12*J12)","v":9000},10000,{"$f":"'Input Sheet'!D15","v":0.1},"NA"]
["Vision",{"$f":"'Input Sheet'!B16","v":150},{"$f":"'Input Sheet'!C16","v":15000},160,6.6666666666666652E-2,{"$f":"D13/$K$6","v":0.35555555555555557},16000,{"$f":"(C13*J13)","v":1500},1600,{"$f":"'Input Sheet'!D16","v":0.1},"NA"]
["Group Life",{"$f":"'Input Sheet'!B18","v":0},{"$f":"'Input Sheet'!C18","v":0},null,null,null,null,null,null,{"$f":"'Input Sheet'!D17","v":0.15},0]
["Supplemental Life",{"$f":"'Input Sheet'!B19","v":0},{"$f":"'Input Sheet'!C19","v":0},null,null,null,null,null,null,{"$f":"'Input Sheet'!D18","v":0.15},0]
["STD",{"$f":"'Input Sheet'!B19","v":0},{"$f":"'Input Sheet'!C19","v":0},null,null,null,null,null,null,{"$f":"'Input Sheet'!D19","v":0.15},0]
["LTD",{"$f":"'Input Sheet'!B20","v":0},{"$f":"'Input Sheet'!C20","v":0},null,null,null,null,null,null,{"$f":"'Input Sheet'!D20","v":0.15},0]
["Total Premium",null,{"$f":"SUM(C11:C17)","v":1105000},null,null,null,{"$f":"SUM(G11:G17)","v":1216000}]
[null,null,null,null,null,null,"Total Core Plans Revenue",{"$f":"SUM(H11:H17)","v":60500},{"$f":"SUM(I11:I17)","v":66600}]
[null,null,null,null,null,null,"Total VB Plans Revenue",{"$f":"'Input Sheet'!H23*'Input Sheet'!I14*'Input Sheet'!I9","v":2250},{"$f":"I33","v":20940},"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":62750},{"$f":"SUM(I19:I21)","v":87540},null,{"$f":"I22/H22-1","v":0.39505976095617523},null,"Revenue Increase",null,{"$f":"I22-H22","v":24790}]
[]
["VB Products from Reeser Group","2019 Enrolled","2019 Annual\nPremium","2020 Enrolled W/Reeser Group","Percent Change","Participation","Annual Premium","2019 VB Commision - Actual","2020 Broker Commission Estimated","1st yr VB Commission Percentage","Reeser Group Revenue"]
["Accident",{"$f":"'Input Sheet'!G14","v":130},{"$f":"'Input Sheet'!H14","v":15000},150,{"$f":"D25/B25-1","v":0.15384615384615374},{"$f":"D25/$K$6","v":0.33333333333333331},30000,null,{"$f":"G25*J25*$J$33","v":5400},0.6,{"$f":"G25*J25*(1-$J$33)","v":12600}]
["Critical Illness",{"$f":"'Input Sheet'!G15","v":0},{"$f":"'Input Sheet'!H15","v":0},90,{"$f":"D26/B26-1","v":{"$error":"#DIV/0!"}},{"$f":"D26/$K$6","v":0.2},30000,null,5400,0.6,{"$f":"G26*J26*(1-$J$33)","v":12600}]
["Hospital Indemnity",{"$f":"'Input Sheet'!G16","v":0},{"$f":"'Input Sheet'!H16","v":0},120,{"$error":"#DIV/0!"},{"$f":"D27/$K$6","v":0.26666666666666666},27000,null,4860,0.6,11340]
["Permanent Life",{"$f":"'Input Sheet'!G18","v":0},{"$f":"'Input Sheet'!H18","v":0},80,{"$error":"#DIV/0!"},{"$f":"D28/$K$6","v":0.17777777777777778},32000,null,4800,0.5,11200]
["Pet Insurance",{"$f":"'Input Sheet'!G19","v":0},{"$f":"'Input Sheet'!H19","v":0},40,{"$error":"#DIV/0!"},{"$f":"D29/$K$6","v":8.8888888888888892E-2},16000,null,480,0.1,1120]
["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":15000},null,null,null,{"$f":"SUM(G25:G29)","v":135000},null,null,"Split"]
[null,null,null,null,null,null,"Total VB Plans Revenue",4000,{"$f":"SUM(I25:I31)","v":20940},0.3,{"$f":"SUM(K25:K31)","v":48860}]
[]
[null,"Additional Sources of revenue","2019 Actual","2020 Projected",null,null,null,null,null,"Reeser Group Expenses"]
[null,"Bonus Payments",null,null,null,null,null,null,null,"Implementation Fees",4000]
[null,"Other",null,null,null,null,null,null,null,"OE Call Center Fees",750]
[null,null,null,null,null,null,null,null,null,"Development Costs",5000]
[null,"Total",{"$f":"SUM(C36:C38)","v":0},{"$f":"SUM(D36:D38)","v":0},null,null,null,null,null,"Reeser Group Estimated NET Annual Commissions",{"$f":"(K33-K36-K37-K38)","v":39110}]

{"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-05-03"}]
[]
[]
[]
[]
[]
[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":24790}]
[]
[]
[]
[null,null,{"$f":"spellnumberEDP(P13)","v":"Twenty Four Thousand Seven Hundred Ninety  Dollars and No Cents"}]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Increase in Revenue from \",Calculator!J3)","v":"Increase in Revenue from Client Name"}]