{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info en versiebeheer","Invoer en Uitvoer","Berekening","ITPP68","Variabelen","Legaliteit"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Info en versiebeheer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Invoer en Uitvoer","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["Invoer:","Naam Werkgever:","Test"]
[null,"Werkgeversnummer:",12345]
[null,"Ingangsdatum ANW:","2024-05-01",null,"ANW Premie berekening",2024]
[null,"Naam deelnemer:","Test"]
[null,"Pensioennr deelnemer:",23432]
[null,"Geboortedatum deelnemer:","1967-04-04"]
[null,"Geboortedatum partner:","1970-05-05"]
[null,"Geslacht partner:","M"]
[null,"Verzekerd bedrag:",17800,{"$f":"\"Minimaal \"& TEXT(Variabelen!E17,\"€ #,##0.00\")& \" en Maximaal \" &TEXT(Variabelen!E16,\"€ #,##0.00\")","v":"Minimaal € 9,600.00 en Maximaal € 19,100.00"}]
[]
[]
[]
[]
[]
[]
["Uitvoer:","Brutopremie per jaar:",{"$f":"Berekening!B25*Legaliteit","v":884.76}]
[null,"Brutopremie per maand:",{"$f":"Berekening!B26*Legaliteit","v":73.73}]
[null,"Brutopremie per 4wk:",{"$f":"Berekening!B27*Legaliteit","v":68.06}]

{"sheet":"Berekening","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Rekendatum:",{"$f":"rekdat","v":"2024-05-01"}]
[]
[]
[{"$f":"'Invoer en Uitvoer'!B5","v":"Naam deelnemer:"},{"$f":"'Invoer en Uitvoer'!C5","v":"Test"}]
[{"$f":"'Invoer en Uitvoer'!B6","v":"Pensioennr deelnemer:"},{"$f":"'Invoer en Uitvoer'!C6","v":23432}]
[{"$f":"'Invoer en Uitvoer'!B7","v":"Geboortedatum deelnemer:"},{"$f":"'Invoer en Uitvoer'!C7","v":"1967-04-04"}]
[{"$f":"'Invoer en Uitvoer'!B8","v":"Geboortedatum partner:"},{"$f":"'Invoer en Uitvoer'!C8","v":"1970-05-05"}]
[{"$f":"'Invoer en Uitvoer'!B9","v":"Geslacht partner:"},{"$f":"'Invoer en Uitvoer'!C9","v":"M"}]
[{"$f":"'Invoer en Uitvoer'!B10","v":"Verzekerd bedrag:"},{"$f":"'Invoer en Uitvoer'!C10","v":17800}]
[]
[]
[]
["Burgerlijke leeftijd deelnemer:",{"$f":"FLOOR(YEARFRAC(B6,B1)*1,1)","v":57},null,"Kleiner dan 66?",{"$f":"IF(B13<66,1,0)","v":1},"Als 1 dan PVI opslag, anders 0)"]
[]
["Burgerlijke leeftijd partner:",{"$f":"FLOOR(YEARFRAC(B7,B1)*1,1)","v":53}]
[]
["Eénjarige risicopremies per €1.000 (netto)",{"$f":"VLOOKUP(B13,risicopremies,2,FALSE)","v":3.32}]
["Eénjarige risicopremies per €1.000 (bruto)",{"$f":"B17*(1+excasso_opslag)*(1+solvabiliteit_opslag)*(1+pvi_indicator*pvi_opslag)","v":4.3048140700799999},"incl excasso / solvabiliteit / PVI (als burgelijke leeftijd <66)"]
[]
["OVL risicokapitaal:",{"$f":"B9*B18","v":76625.690447424}]
["OVL risicokapitaal / 1000:",{"$f":"B20/1000","v":76.625690447424006}]
[]
["CW factor",{"$f":"VLOOKUP(B15,ITPP68,2+IF(B8=\"M\",0,1),FALSE)","v":11.54651}]
[]
["Premie per jaar",{"$f":"ROUND(B23*B21,2)*Legaliteit","v":884.76}]
["Premie per maand",{"$f":"ROUND(B25/12,2)*Legaliteit","v":73.73}]
["Premie per 4wk",{"$f":"ROUND(B25/13,2)*Legaliteit","v":68.06}]

{"sheet":"ITPP68","index":3,"n_rows":59,"n_cols":3,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Meubel"]
[]
[null,"ITPP CW factoren van 1-1-2024 tot 31-12-2024"]
[]
["leeftijd","M","V"]
[15,26.743729999999999,26.781479999999998]
[16,26.46555,26.50441]
[17,26.18317,26.222460000000002]
[18,25.895820000000001,25.935569999999998]
[19,25.604189999999999,25.643470000000001]
[20,25.308509999999998,25.346620000000001]
[21,25.008179999999999,25.044560000000001]
[22,24.7029,24.737290000000002]
[23,24.392330000000001,24.424769999999999]
[24,24.077020000000001,24.106770000000001]
[25,23.75647,23.78312]
[26,23.430489999999999,23.45412]
[27,23.098579999999998,23.119420000000002]
[28,22.760079999999999,22.779070000000001]
[29,22.415189999999999,22.432539999999999]
[30,22.062950000000001,22.079129999999999]
[31,21.70298,21.71855]
[32,21.33586,21.350709999999999]
[33,20.961400000000001,20.975449999999999]
[34,20.579080000000001,20.59291]
[35,20.189129999999999,20.203009999999999]
[36,19.791540000000001,19.80537]
[37,19.38598,19.39996]
[38,18.972380000000001,18.986689999999999]
[39,18.550429999999999,18.56513]
[40,18.120069999999998,18.13513]
[41,17.681039999999999,17.69661]
[42,17.23321,17.249700000000001]
[43,16.776479999999999,16.79401]
[44,16.309709999999999,16.328029999999998]
[45,15.831860000000001,15.8514]
[46,15.34224,15.363049999999999]
[47,14.840999999999999,14.863849999999999]
[48,14.328060000000001,14.35276]
[49,13.801959999999999,13.82821]
[50,13.260999999999999,13.288880000000001]
[51,12.70492,12.73434]
[52,12.133570000000001,12.16466]
[53,11.54651,11.57898]
[54,10.942019999999999,10.97481]
[55,10.317449999999999,10.350160000000001]
[56,9.6726399999999995,9.7044700000000006]
[57,9.0061999999999998,9.0365099999999998]
[58,8.3174499999999991,8.3453400000000002]
[59,7.6055799999999998,7.63035]
[60,6.8693600000000004,6.8909500000000001]
[61,6.1084699999999996,6.1272200000000003]
[62,5.3222800000000001,5.3385699999999998]
[63,4.5102000000000002,4.5236499999999999]
[64,3.6714099999999998,3.6814]
[65,2.8043900000000002,2.81107]
[66,1.90726,1.91069]
[67,0.97533999999999998,0.97631000000000001]
[68,0,0]

{"sheet":"Variabelen","index":4,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
["MBL"]
["Bron: ","Rekenwaarden 2024-3 BPF_Meubel "]
[]
[]
[]
[]
[]
[]
["Opslagen","excasso","solvabiliteit","pvi"]
["2021-01-01",0.03,0.17499999999999999,3.44E-2]
["2022-01-01",0.03,0.17799999999999999,3.44E-2]
["2023-01-01",0.03,0.184,3.44E-2]
["2024-01-01",0.03,0.217,3.44E-2]
[]
[null,2021,2022,2023,2024]
["Maximale hoogte ANW ",16000,16200,17900,19100]
["Minimale hoogte ANW",8000,8100,{"$f":"ROUND(D16*50%,-2)","v":9000},{"$f":"ROUND(E16*50%,-2)","v":9600}]
[]
["X:\\Finance\\Actuariaat\\Fondsen\\BPF Meubel\\Herverzekering\\Ellips herverzekering Meubel.xlsx"]
["premie"]
["Begin","Eind"]
["2020-01-01","2024-12-31"]
["ADDENDUM NO. 1  herverzekering van overlijdensrisicokapitalen"]
["M/V","Eénjarige risicopremies per €1.000,= overlijdensrisicokapitaal"]
["leeftijd","0/00"]
[17,0.23]
[18,0.23]
[19,0.23]
[20,0.24]
[21,0.24]
[22,0.24]
[23,0.24]
[24,0.25]
[25,0.25]
[26,0.25]
[27,0.25]
[28,0.26]
[29,0.26]
[30,0.28999999999999998]
[31,0.33]
[32,0.38]
[33,0.41]
[34,0.45]
[35,0.47]
[36,0.48]
[37,0.49]
[38,0.5]
[39,0.56999999999999995]
[40,0.64]
[41,0.71]
[42,0.83]
[43,0.98]
[44,1.1100000000000001]
[45,1.26]
[46,1.34]
[47,1.5]
[48,1.63]
[49,1.72]
[50,1.81]
[51,2.02]
[52,2.2400000000000002]
[53,2.56]
[54,2.71]
[55,2.87]
[56,3.18]
[57,3.32]
[58,3.45]
[59,3.53]
[60,3.68]
[61,4]
[62,4.51]
[63,4.88]
[64,5.42]
[65,6.31]
[66,6.89]
[67,7.66]
[68,8.51]
[69,9.43]

{"sheet":"Legaliteit","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}