{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Blad2","Blad3"],"not_rendered":{"charts":0,"images":0,"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":"Blad1","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Uitgangspunten:"]
["Vermogen",{"$f":"Blad2!C3","v":250000},"blijft continu gelijk"]
[]
[null,"Dienstverlening","Tarief in %","Tarief in €","Wijze van betalen","Aan wie?"]
["Doorlopende kosten","Doorlopende controle op halen en haalbaarheid doelen, onderhoud en updaten advies, klantcontact, relatiebeheer",5.4999999999999997E-3,"€ 550,- per jaar","Per factuur. Verrekening na elk kwartaal, via automatische incasso op beleggersrekening BinckBank","VanEck"]
["Doorlopende kosten","Beleggersrekening, administratie, transacties, bewaarloon",1.5E-3,"€ 150,- per jaar","Per factuur. Verrekening op beleggers­rekening BinckBank","BinckBank"]
["Doorlopende kosten","Beheerkosten","Profiel: Defensief            -0,16% Profiel: Gematigd            -0,17% Profiel: Neutraal              -0,18% Profiel: Offensief            -0,19% Profiel: Zeer offensief   -0,20%","Profiel: Defensief          -€ 170 Profiel: Gematigd          -€ 190 Profiel: Neutraal            -€ 220 Profiel: Offensief           -€ 250 Profiel: Zeer offensief - €280","In de koersen","VanEck"]
["Totale doorlopende kosten per jaar",null,"Profiel: Defensief           -0,86% Profiel: Gematigd            -0,87% Profiel: Neutraal              -0,88% Profiel: Offensief            -0,89% Profiel: Zeer offensief   -0,90%","Profiel: Defensief          -€ 860 Profiel: Gematigd          -€ 870 Profiel: Neutraal            -€ 880 Profiel: Offensief           -€ 890 Profiel: Zeer offensief -€ 900"]
[]
[]
["Profiel","Doorlopende kostenVanEck (uitbesteed aan Fonja)","Doorlopende kosten VanEck","Doorlopende kosten SaxoBank","totaal"]
["Defensief",{"$f":"IF(0.0055*$B$2<2420,0.0055*$B$2,2420)","v":1375},{"$f":"0.0016*$B$2","v":400},{"$f":"0.0015*$B$2","v":375},{"$f":"SUM(B12:D12)","v":2150}]
["Gematigd defensief",{"$f":"IF(0.005*$B$2<2420,0.0055*$B$2,2420)","v":1375},{"$f":"0.0017*$B$2","v":425},{"$f":"0.0015*$B$2","v":375},{"$f":"SUM(B13:D13)","v":2175}]
["Neutraal",{"$f":"IF(0.0055*$B$2<2420,0.0055*$B$2,2420)","v":1375},{"$f":"0.0018*$B$2","v":450},375,2200]
["Offensief",{"$f":"IF(0.0055*$B$2<2420,0.0055*$B$2,2420)","v":1375},{"$f":"0.0019*$B$2","v":475},375,2225]
["Zeer offensief",{"$f":"IF(0.0055*$B$2<2420,0.0055*$B$2,2420)","v":1375},{"$f":"0.002*$B$2","v":500},375,2250]
["Alle profielen"]
["-"]
[]
["Profiel","Doorlopende kosten VanEck (uitbesteed aan Fonja)","Doorlopende kosten VanEck","Doorlopende kosten SaxoBank","totaal"]
["Defensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":1375},{"$f":"0.0016*$B$2","v":400},{"$f":"0.0015*$B$2","v":375},{"$f":"SUM(B21:D21)","v":2150}]
["Gematigd defensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":1375},{"$f":"0.0017*$B$2","v":425},{"$f":"0.0015*$B$2","v":375},{"$f":"SUM(B22:D22)","v":2175}]
["Neutraal",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":1375},{"$f":"0.0018*$B$2","v":450},375,2200]
["Offensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":1375},{"$f":"0.0019*$B$2","v":475},375,2225]
["Zeer offensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":1375},{"$f":"0.002*$B$2","v":500},375,2250]
[]
[]
[]
[]
[]
["Particulier"]
["BV"]

{"sheet":"Blad2","index":1,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,15,10,16],[11,15,11,16],[12,15,12,16],[7,17,7,18],[9,15,9,16],[14,0,14,3],[11,2,11,3],[12,2,12,3],[7,4,7,5],[7,6,7,7],[4,2,4,3],[7,10,7,11],[7,12,7,13],[9,2,9,3],[10,2,10,3],[7,8,7,9]]}
["Rekenvoorbeeld kosten VanEck Beheerd Indexbeleggen"]
[]
["Met welk bedrag wilt u gaan beleggen?",null,250000]
[]
["Van welk beleggingsprofiel wilt u de kosten zien?",null,"Neutraal"]
[]
[]
[null,null,"Particulier",null,"Defensief",null,{"$f":"C5","v":"Neutraal"},null,"Neutraal",null,"Offensief",null,"Zeer offensief",null,null,"Besloten Vennootschap",null,{"$f":"C5","v":"Neutraal"}]
[null,null,null,null,"kosten in €","Kosten in %","kosten in €","Kosten in %","kosten in €","Kosten in %","kosten in €","Kosten in %","kosten in €","Kosten in %",null,null,null,"kosten in €","Kosten in %"]
[null,null,"Kosten relatiebeheer-activiteiten",null,{"$f":"VLOOKUP($E$8,Blad1!$A$12:$E$16,2,FALSE)","v":1375},{"$f":"E10/$C$3","v":5.4999999999999997E-3},{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,2,FALSE)","v":1375},{"$f":"G10/$C$3","v":5.4999999999999997E-3},{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,2,FALSE)","v":1375},{"$f":"I10/$C$3","v":5.4999999999999997E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,2,FALSE)","v":1375},{"$f":"K10/$C$3","v":5.4999999999999997E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,2,FALSE)","v":1375},{"$f":"M10/$C$3","v":5.4999999999999997E-3},null,"Kosten relatiebeheer-activiteiten",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,2,FALSE)","v":1375},{"$f":"R10/$C$3","v":5.4999999999999997E-3}]
[null,null,"Kosten SaxoBank",null,{"$f":"VLOOKUP($E$8,Blad1!$A$12:$E$16,4,FALSE)","v":375},{"$f":"E11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,4,FALSE)","v":375},1.5E-3,{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,4,FALSE)","v":375},{"$f":"I11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,4,FALSE)","v":375},{"$f":"K11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,4,FALSE)","v":375},{"$f":"M11/$C$3","v":1.5E-3},null,"Kosten SaxoBank",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,4,FALSE)","v":375},{"$f":"R11/$C$3","v":1.5E-3}]
[null,null,"Samengestelde productkosten",null,{"$f":"VLOOKUP($E$8,Blad1!$A$12:$E$16,3,FALSE)","v":400},1.6000000000000001E-3,{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,3,FALSE)","v":450},1.8E-3,{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,3,FALSE)","v":450},{"$f":"I12/$C$3","v":1.8E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,3,FALSE)","v":475},{"$f":"K12/$C$3","v":1.9E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,3,FALSE)","v":500},{"$f":"M12/$C$3","v":2E-3},null,"Samengestelde productkosten",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,3,FALSE)","v":450},1.8E-3]
[null,null,"Totaalkosten",null,{"$f":"SUM(E10:E12)","v":2150},8.6E-3,{"$f":"SUM(G10:G12)","v":2200},8.8000000000000005E-3,{"$f":"SUM(I10:I12)","v":2200},{"$f":"I13/$C$3","v":8.8000000000000005E-3},{"$f":"SUM(K10:K12)","v":2225},{"$f":"K13/$C$3","v":8.8999999999999999E-3},{"$f":"SUM(M10:M12)","v":2250},{"$f":"M13/$C$3","v":8.9999999999999993E-3},null,"Totaalkosten",null,{"$f":"SUM(R10:R12)","v":2200},8.8000000000000005E-3]
[]
["Disclaimer: Dit rekenvoorbeeld geeft u een indicatie van de kosten. Aan deze indicatie kunnen geen rechten worden ontleend.\n"]

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