{"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":1000000},"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",4.4999999999999997E-3,"€ 450,- 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,76% Profiel: Gematigd            -0,77% Profiel: Neutraal              -0,78% Profiel: Offensief            -0,79% Profiel: Zeer offensief   -0,80%","Profiel: Defensief          -€ 770 Profiel: Gematigd          -€ 790 Profiel: Neutraal            -€ 820 Profiel: Offensief           -€ 850 Profiel: Zeer offensief -€ 880"]
[]
[]
["Profiel","Doorlopende kostenVanEck (uitbesteed aan Fonja)","Doorlopende kosten VanEck","Doorlopende kosten SaxoBank","totaal"]
["Defensief",{"$f":"IF(0.0045*$B$2<2420,0.0045*$B$2,2420)","v":2420},{"$f":"0.0016*$B$2","v":1600},{"$f":"0.0015*$B$2","v":1500},{"$f":"SUM(B12:D12)","v":5520}]
["Gematigd defensief",{"$f":"IF(0.0045*$B$2<2420,0.0045*$B$2,2420)","v":2420},{"$f":"0.0017*$B$2","v":1700},{"$f":"0.0015*$B$2","v":1500},{"$f":"SUM(B13:D13)","v":5620}]
["Neutraal",2420,{"$f":"0.0018*$B$2","v":1800},1500,5720]
["Offensief",2420,{"$f":"0.0019*$B$2","v":1900},1500,5820]
["Zeer offensief",2420,{"$f":"0.002*$B$2","v":2000},1500,5920]
["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":2958},{"$f":"0.0016*$B$2","v":1600},{"$f":"0.0015*$B$2","v":1500},{"$f":"SUM(B21:D21)","v":6058}]
["Gematigd defensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":2958},{"$f":"0.0017*$B$2","v":1700},{"$f":"0.0015*$B$2","v":1500},{"$f":"SUM(B22:D22)","v":6158}]
["Neutraal",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":2958},{"$f":"0.0018*$B$2","v":1800},1500,6258]
["Offensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":2958},{"$f":"0.0019*$B$2","v":1900},1500,6358]
["Zeer offensief",{"$f":"IF(0.0055*$B$2<2958,0.0055*$B$2,2958)","v":2958},{"$f":"0.002*$B$2","v":2000},1500,6458]
[]
[]
[]
[]
[]
["Particulier"]
["BV"]

{"sheet":"Blad2","index":1,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,2,4,3],[7,10,7,11],[7,12,7,13],[9,2,9,3],[10,2,10,3],[7,8,7,9],[14,0,14,3],[11,2,11,3],[12,2,12,3],[7,4,7,5],[7,6,7,7],[10,15,10,16],[11,15,11,16],[12,15,12,16],[7,17,7,18],[9,15,9,16]]}
["Rekenvoorbeeld kosten VanEck Beheerd Indexbeleggen"]
[]
["Met welk bedrag wilt u gaan beleggen?",null,1000000]
[]
["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":2420},{"$f":"E10/$C$3","v":2.4199999999999998E-3},{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,2,FALSE)","v":2420},{"$f":"G10/$C$3","v":2.4199999999999998E-3},{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,2,FALSE)","v":2420},{"$f":"I10/$C$3","v":2.4199999999999998E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,2,FALSE)","v":2420},{"$f":"K10/$C$3","v":2.4199999999999998E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,2,FALSE)","v":2420},{"$f":"M10/$C$3","v":2.4199999999999998E-3},null,"Kosten relatiebeheer-activiteiten",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,2,FALSE)","v":2958},{"$f":"R10/$C$3","v":2.9580000000000001E-3}]
[null,null,"Kosten SaxoBank",null,{"$f":"VLOOKUP($E$8,Blad1!$A$12:$E$16,4,FALSE)","v":1500},{"$f":"E11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,4,FALSE)","v":1500},1.5E-3,{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,4,FALSE)","v":1500},{"$f":"I11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,4,FALSE)","v":1500},{"$f":"K11/$C$3","v":1.5E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,4,FALSE)","v":1500},{"$f":"M11/$C$3","v":1.5E-3},null,"Kosten SaxoBank",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,4,FALSE)","v":1500},{"$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":1600},1.6000000000000001E-3,{"$f":"VLOOKUP($G$8,Blad1!$A$12:$E$16,3,FALSE)","v":1800},1.8E-3,{"$f":"VLOOKUP($I$8,Blad1!$A$12:$E$16,3,FALSE)","v":1800},{"$f":"I12/$C$3","v":1.8E-3},{"$f":"VLOOKUP($K$8,Blad1!$A$12:$E$16,3,FALSE)","v":1900},{"$f":"K12/$C$3","v":1.9E-3},{"$f":"VLOOKUP($M$8,Blad1!$A$12:$E$16,3,FALSE)","v":2000},{"$f":"M12/$C$3","v":2E-3},null,"Samengestelde productkosten",null,{"$f":"VLOOKUP($G$8,Blad1!$A$21:$E$25,3,FALSE)","v":1800},1.8E-3]
[null,null,"Totaalkosten",null,{"$f":"SUM(E10:E12)","v":5520},5.5199999999999997E-3,{"$f":"SUM(G10:G12)","v":5720},5.7200000000000003E-3,{"$f":"SUM(I10:I12)","v":5720},{"$f":"I13/$C$3","v":5.7200000000000003E-3},{"$f":"SUM(K10:K12)","v":5820},{"$f":"K13/$C$3","v":5.8199999999999997E-3},{"$f":"SUM(M10:M12)","v":5920},{"$f":"M13/$C$3","v":5.9199999999999999E-3},null,"Totaalkosten",null,{"$f":"SUM(R10:R12)","v":6258},6.2579999999999997E-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":[]}