{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Agent Commissions Calculator","2024 Rates"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Agent Commissions Calculator","index":0,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,0,22,0],[3,0,3,6],[10,0,10,4],[18,0,19,0],[12,0,13,0],[15,0,16,0],[5,1,5,2]]}
["2024 Agent Commission Calculator"]
[]
[]
["Writing Agent Calculator"]
[]
["Step 1: Select the state for the Beneficiary","Alabama",null,{"$f":"VLOOKUP(B6,'2024 Rates'!$A$4:$B$42,2,FALSE)","v":"AL"}]
[]
["Step 2: Select the effective month of the Beneficiary",null,"January",{"$f":"IF(C8=\"December\",1,IF(C8=\"November\",2,IF(C8=\"October\",3,IF(C8=\"September\",4,IF(C8=\"August\",5,IF(C8=\"July\",6,IF(C8=\"June\",7,IF(C8=\"May\",8,IF(C8=\"April\",9,IF(C8=\"March\",10,IF(C8=\"February\",11,12)))))))))))","v":12}]
[]
[]
["Writing Agent Commissions",null,null,null,null,null,"Broker Level"]
[null,"Segment","Initial Payment","True-Up Payment","Total Initial Payout",null,"Monthly Renewal Payment"]
["New to Medicare/New to Wellcare\nPrior Plan Type = NONE + Cycle Year 1 per CMS \nBeneficiary is in the initial year from an \"unlike\" plan","CCP",{"$f":"IF(D6=\"PDP\",0,((VLOOKUP($D$6,'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8))","v":306},{"$f":"IF(D6=\"PDP\",0,((VLOOKUP($D$6,'2024 Rates'!$B$4:$J$42,2,FALSE)-C13)))","v":305},{"$f":"SUM(C13:D13)","v":611},null,{"$f":"IF(D6=\"PDP\",0,((VLOOKUP($D$6,'2024 Rates'!$B$4:$J$42,3,FALSE)/12)))","v":25.5}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8","v":50},{"$f":"(VLOOKUP(\"PDP\",'2024 Rates'!$B$4:$J$42,2,FALSE)-C14)","v":50},{"$f":"SUM(C14:D14)","v":100},null,{"$f":"(VLOOKUP(\"PDP\",'2024 Rates'!$B$4:$J$42,3,FALSE)/12)","v":4.166666666666667}]
[]
["Already in Medicare/New to Wellcare\nPrior Plan Type = MA/MAPD or PDP + Cycle Year 1 per CMS\nBeneficiary is in the initial year from a \"Like plan type\"","CCP",{"$f":"IF($D$6=\"PDP\",0,((VLOOKUP($D$6,'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8))","v":306},{"$f":"E16-C16","v":305},{"$f":"(E13/12)*D8","v":611},null,{"$f":"G13","v":25.5}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8","v":50},{"$f":"C17-0","v":50},{"$f":"(E14/12)*D8","v":100},null,{"$f":"G14","v":4.166666666666667}]
[]
["Already in Medicare/New to Wellcare\nPrior Plan Type = MA/MAPD or PDP + Cycle Year >1 per CMS\nBeneficiary is in the initial year from a \"Like plan type\" ","CCP",{"$f":"IF($D$6=\"PDP\",0,((VLOOKUP($D$6,'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8))","v":306},{"$f":"IF(C19=0,0,0)","v":0},{"$f":"SUM(C19:D19)","v":306},null,{"$f":"G13","v":25.5}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2024 Rates'!$B$4:$J$42,3,FALSE)/12)*$D$8","v":50},0,{"$f":"SUM(C20:D20)","v":50},null,{"$f":"G14","v":4.166666666666667}]
[]
["Already in Medicare/Already in Wellcare \nPrior Plan Type = plan transfer\nBeneficiary is changing  from one MA plan to another plan where Original Effective Date is prior to 2023.","CCP",0,{"$f":"IF(C22=0,0,0)","v":0},{"$f":"SUM(C22:D22)","v":0},null,{"$f":"G13","v":25.5}]
[null,"PDP",0,0,0,null,{"$f":"G14","v":4.166666666666667}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"2024 Rates","index":1,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,2,1,3]]}
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"Agent",null,"GA","MGA","SGA","FMO","NMO","GA","MGA","SGA","FMO","NMO","GA","MGA","SGA","FMO","NMO"]
["State","Abrev","New to MA","Renewal Payment","First Payment","First Payment","First Payment","First Payment","First Payment","1st Renewal Pymt","1st Renewal Pymt","1st Renewal Pymt","1st Renewal Pymt","1st Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt",null,"1st Renewal Total","Lifetime Renewal Total"]
["PDP","PDP",100,50,3,3,3,6,1,1.4,1.4,1.4,2.8,1,1.4,1.4,1.4,2.8,0.5,null,{"$f":"SUM(J4:N4)","v":7.9999999999999991},{"$f":"SUM(O4:S4)","v":7.4999999999999991}]
["Alabama","AL",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,{"$f":"SUM(J5:N5)","v":250},{"$f":"SUM(O5:S5)","v":125}]
["Arizona","AZ",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Arkansas","AR",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["California","CA",762,381,50,50,60,70,70,50,50,60,70,70,25,25,30,35,35,null,300,150]
["Connecticut","CT",689,345,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["District of Columbia","DC",689,345,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Delaware","DE",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Florida","FL",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Georgia","GA",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Hawaii","HI",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Illinois","IL",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Indiana","IN",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Kansas","KS",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Kentucky","KY",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Louisiana","LA",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Massachusetts","MA",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Maine","ME",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Michigan","MI",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Mississippi","MS",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Missouri","MO",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Nebraska","NE",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Nevada","NV",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["New Hampshire","NH",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["New Jersey","NJ",762,381,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["New Mexico","NM",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["New York","NY",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["North Carolina","NC",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Ohio","OH",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Oklahoma","OK",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Oregon","OR",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Pennsylvania","PA",689,345,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Rhode Island","RI",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["South Carolina","SC",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Tennessee","TN",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Texas","TX",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Vermont","VT",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Washington","WA",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]
["Wisconsin","WI",611,306,50,50,50,50,50,50,50,50,50,50,25,25,25,25,25,null,250,125]