{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Aankoop verkoop Eigen Woning","Specificatie verbouwingskosten"],"not_rendered":{"images":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Aankoop verkoop Eigen Woning","index":0,"n_rows":54,"n_cols":45,"rows_kept":54,"merged":[[1,7,1,11],[2,7,2,11],[2,16,2,17],[3,16,3,17],[4,16,4,17],[5,16,5,17],[7,16,7,17],[8,16,8,17],[9,16,9,17],[37,3,37,5],[37,19,37,21],[38,3,38,5],[38,19,38,21],[39,3,39,5],[39,19,39,21],[40,3,40,5],[40,19,40,21],[41,3,41,5],[41,19,41,21],[42,3,42,5],[42,19,42,21],[43,3,43,5],[43,19,43,21],[46,3,46,5]]}
[]
[{"$nulls":3},"Naam onderneming",{"$nulls":9},"Nieuwe woning",null,null,"WOZ",{"$nulls":4},{"$f":"\"Stand Eigen Woningreserve op 01-01-\"&H3&\"\"","v":"Stand Eigen Woningreserve op 01-01-"},{"$nulls":9},0,{"$nulls":11},"Ja","Nieuwbouw"]
[{"$nulls":3},"Jaar",{"$nulls":9},"Adres",{"$nulls":7},"Extra aflossing ",{"$nulls":9},0,{"$nulls":11},"Nee","Verbouw"]
[{"$nulls":13},"Eigendom woning",null,null,{"v":1,"d":"100%"}]
[{"$nulls":3},"Kdb-Eigen Woning-sheet",{"$nulls":9},"Eigendom hypotheek",null,null,{"v":1,"d":"100%"}]
[{"$nulls":3},"versie 3.5 oktober 2025"]
[{"$nulls":13},"Oude woning",null,null,"WOZ"]
[{"$nulls":13},"Adres"]
[{"$nulls":13},"Eigendom woning",null,null,{"v":1,"d":"100%"}]
[{"$nulls":13},"Eigendom hypotheek",null,null,{"v":1,"d":"100%"}]
[]
[null,"Nieuwe woning",{"$nulls":15},"Oude woning",{"$nulls":15},"Uitkomsten"]
[null,{"$f":"Q3","v":0},null,"Neem onderstaande over van de Nota van Afrekening",{"$nulls":13},{"$f":"Q8","v":0},null,"Neem onderstaande over van de Nota van Afrekening",{"$nulls":13},"Eigenwoningreserve begin jaar",{"$f":"AF2","v":0}]
[{"$nulls":33},"Overwaarde",{"$f":"(AF16*Q9)-((SUM(T16:T32))*Q10)-(AF19*Q10)+((SUMIF(X38:X44,\"Ja\",Z38:Z44))*Q10)","v":0}]
[null,"1. Aankoopkosten",{"$nulls":3},"Aftrekbaar",{"$nulls":11},"1. Verkoopkosten",{"$nulls":3},"Aftrekbaar",{"$nulls":11},"Eigenwoningreserve na verkoop",null,{"$f":"AI13+AI14","v":0}]
[null,"Overdrachtsbelasting",null,0,null,"Nee",{"$nulls":5},"Aankoopbedrag",{"$nulls":3},0,null,"Makelaar",null,0,null,"Nee",{"$nulls":5},"Verkoopbedrag",{"$nulls":3},0]
[null,"Kosten notaris ivm levering",null,0,null,"Nee",{"$nulls":5},"Aankoopdatum",{"$nulls":5},"Notariskosten ivm hypotheek",null,0,null,"Ja",{"$nulls":5},"Verkoopdatum",{"$nulls":5},"Kosten nieuwe woning",{"$f":"(P16+(SUM(D16:D32))+D53)*Q4","v":0}]
[null,"Kosten notaris ivm hypotheek",null,0,null,"Ja",{"$nulls":5},"Verhuisdatum",{"$nulls":5},"Overige notariskosten",null,0,null,"Nee",{"$nulls":11},"Maximale hypotheek",null,{"$f":"IF((AI17-AJ15)<0,0,AI17-AJ15)","v":0}]
[null,"Overige notariskosten ivm levering",null,0,null,"Nee",{"$nulls":11},"Financieel advies",null,0,null,"Ja",{"$nulls":5},"Hypotheek",{"$nulls":3},0]
[null,"Overige notariskosten ivm hypotheek",null,0,null,"Ja",{"$nulls":5},"Hypotheeklening totaal",{"$nulls":3},0,null,"Taxatie",null,0,null,"Ja",{"$nulls":5},"op datum verkoop",{"$nulls":5},"Werkelijke hypotheek nieuwe woning",{"$f":"(P20-(SUMIF(H38:H43,\"Ja\",L38:L43))-P23)*Q5","v":0}]
[null,"Kadasterkosten ivm levering",null,0,null,"Nee",{"$nulls":5},"op datum aankoop incl overbrugging en bouwdepot",{"$nulls":5},"Bouwkundige keuring",null,0,null,"Nee",{"$nulls":11},"Extra aflossing",{"$f":"AF3","v":0}]
[null,"Kadasterkosten ivm hypotheek",null,0,null,"Ja",{"$nulls":11},"Doorhaling/royement hypotheek",null,0,null,"Ja"]
[null,"Makelaar",null,0,null,"Nee",{"$nulls":5},"Overbruggings-",{"$nulls":3},0,null,"Reserve fonds VvE",null,0,null,"Nee",{"$nulls":11},"Is er sprake van Bijleenregeling?",null,{"$f":"IF((AJ18-AI20+AI21)<0,\"Ja\",\"Nee\")","v":"Nee"}]
[null,"Financieel advies",null,0,null,"Ja",{"$nulls":5},"hypotheek op datum aankoop",{"$nulls":5},"Overdrachtsbelasting",null,0,null,"Nee",{"$nulls":11},"Percentage aftrekbeperking",null,{"$f":"IF(AI20-AI21=0,0,IF((1-(AJ18/(AI20-AI21)))<0,0,1-(AJ18/(AI20-AI21))))","v":{"v":0,"d":"0.00%"}}]
[null,"Taxatie",null,0,null,"Ja",{"$nulls":11},"-",null,0]
[null,"Bouwkundige keuring",null,0,null,"Ja",{"$nulls":5},"Bouwdepot op",{"$nulls":3},0,null,"-",null,0,{"$nulls":13},"Gevolgen nieuwe woning"]
[null,"NHG",null,0,null,"Ja",{"$nulls":5},"datum aankoop",{"$nulls":5},"-",null,0,{"$nulls":13},{"$f":"\"Hypotheek totaal op 31-12-\"&H3 &\"\"","v":"Hypotheek totaal op 31-12-"},null,{"$f":"L45*Q5","v":0}]
[null,"Bankgarantie",null,0,null,"Nee",{"$nulls":11},"-",null,0,{"$nulls":13},"Rente totaal",null,{"$f":"(N45)*Q5","v":0}]
[null,"BTW",null,0,null,"Nee",{"$nulls":11},"-",null,0,{"$nulls":13},"Financieringskosten totaal",null,{"$f":"(SUMIF(F16:F32,\"Ja\",D16:D32))*Q5","v":0}]
[null,"BTW",null,0,null,"Ja",{"$nulls":11},"-",null,0]
[null,"Kosten Geldverkeer",null,0,null,"Nee",{"$nulls":11},"-",null,0,{"$nulls":13},"Rente niet aftrekbaar ivm nieuwbouwdepot",null,{"$f":"(IF(H47=\"Nieuwbouw\",P47,0))","v":0}]
[{"$nulls":17},"-",null,0]
[{"$nulls":33},{"$f":"\"Hypotheek naar box 3 ivm Aflossingsvrij  op 31-12-\"&H3&\"\"","v":"Hypotheek naar box 3 ivm Aflossingsvrij  op 31-12-"},null,{"$f":"(L45-(SUMIF(H38:H44,\"Nee\",L38:L44)))*Q5","v":0}]
[null,"2. Hypotheek",null,"Neem onderstaande over van het jaaroverzicht van de hypotheekverstrekker",{"$nulls":13},"2. Hypotheek",null,"Neem onderstaande over van het jaaroverzicht van de hypotheekverstrekker",{"$nulls":13},"Rente niet aftrekbaar ivm Aflossingsvrij",null,{"$f":"AJ28-((SUMIF(H38:H44,\"Nee\",N38:N44))*Q5)","v":0}]
[{"$nulls":7},"Aflossingsvrij",{"$nulls":15},"Aflossingsvrij",{"$nulls":9},"Financieringskosten niet aftrekbaar ivm Aflossingsvrij",null,{"$f":"IF(AJ27=0,0,((AJ33/AJ27)*AJ29))","v":0}]
[{"$nulls":7},"zonder",null,"Lening op",null,"Lening op",null,"Betaalde ",null,"Ontvangen",{"$nulls":7},"zonder",null,"Lening op",null,"Lening op",null,"Betaalde"]
[null,"Omschrijving",null,"Nummer",{"$nulls":3},"overgangsrecht",null,{"$f":"\"01-01-\" &H3 &\"\"","v":"01-01-"},null,{"$f":"\"31-12-\" &H3 &\"\"","v":"31-12-"},null,"rente",null,"rente",null,"Omschrijving",null,"Nummer",{"$nulls":3},"overgangsrecht",null,{"$f":"\"01-01-\" &H3 &\"\"","v":"01-01-"},null,{"$f":"\"31-12-\" &H3 &\"\"","v":"31-12-"},null,"rente",{"$nulls":3},{"$f":"\"Hypotheek naar box 3 ivm Bijleenregeling op 31-12-\"&H3&\"\"","v":"Hypotheek naar box 3 ivm Bijleenregeling op 31-12-"},null,{"$f":"(AJ27-AJ33)*AJ24","v":0}]
[{"$nulls":3},"-",{"$nulls":3},"Nee",null,0,null,0,null,0,{"$nulls":11},0,null,0,null,0,{"$nulls":3},"Rente niet aftrekbaar ivm Bijleenregeling",null,{"$f":"(AJ28-AJ31-AJ34-N44)*AJ24","v":0}]
[{"$nulls":3},"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"Financieringskosten niet aftrekbaar ivm Bijleenregeling",null,{"$f":"(AJ29-AJ35)*AJ24","v":0}]
[{"$nulls":3},"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0]
[{"$nulls":3},"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"Gevolgen oude woning"]
[{"$nulls":3},"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},{"$f":"\"Hypotheek totaal op 01-01-\"&H3 &\"\"","v":"Hypotheek totaal op 01-01-"},null,{"$f":"Z45*Q10","v":0}]
[{"$nulls":3},"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"Rente totaal",null,{"$f":"AD45*Q10","v":0}]
[null,"Overbruggingshypotheek",null,"-",{"$nulls":3},"Nee",null,0,null,0,null,0,{"$nulls":3},"-",null,"-",{"$nulls":5},0,null,0,null,0,{"$nulls":3},"Financieringskosten totaal",null,{"$f":"(SUMIF(V16:V32,\"Ja\",T16:T32))*Q10","v":0}]
[{"$nulls":3},"Totaal",{"$nulls":5},{"$f":"SUM(J38:J44)","v":0},null,{"$f":"SUM(L38:L44)","v":0},null,{"$f":"SUM(N38:N44)","v":0},{"$nulls":5},"Totaal",{"$nulls":5},{"$f":"SUM(Z38:Z44)","v":0},null,{"$f":"SUM(AB38:AB44)","v":0},null,{"$f":"SUM(AD38:AD44)","v":0}]
[{"$nulls":33},{"$f":"\"Hypotheek naar box 3 ivm Aflossingsvrij  op 01-01-\"&H3&\"\"","v":"Hypotheek naar box 3 ivm Aflossingsvrij  op 01-01-"},null,{"$f":"(SUMIF(X38:X44,\"Ja\",Z38:Z44))*Q10","v":0}]
[null,"Bouwdepot",{"$nulls":7},0,null,0,{"$nulls":21},"Rente niet aftrekbaar ivm Aflossingsvrij",null,{"$f":"(SUMIF(X38:X44,\"Ja\",AD38:AD44))*Q10","v":0}]
[{"$nulls":17},"opmerkingen",{"$nulls":15},"Financieringskosten niet aftrekbaar ivm Aflossingsvrij",null,{"$f":"IF(AJ42=0,0,AJ44*(AJ46/AJ42))","v":0}]
[]
[null,"3. Verbouwing",null,"Vraag deze info op bij de klant. Specificeer in tabblad 'Specificatie verbouwingskosten'"]
[]
[null,"Zie 'specificatie verbouwingskosten'",null,{"$f":"'Specificatie verbouwingskosten'!D43","v":0}]
[null,"Totaal verbouwing incl bouwdepot",null,{"$f":"D52+IF('Specificatie verbouwingskosten'!D11=\"Extra verbouwingskosten bovenop bouwdepot\",P26,0)","v":0}]
[{"$nulls":5},{"$f":"IF(F53=Q19,\"\",\"Beginwaarde hypotheek sluit niet aan\")","v":""}]

{"sheet":"Specificatie verbouwingskosten","index":1,"n_rows":43,"n_cols":44,"rows_kept":43,"merged":[[1,7,1,10],[2,7,2,10],[2,15,2,16],[3,15,3,16],[4,15,4,16],[5,15,5,16],[7,15,7,16],[8,15,8,16],[9,3,9,10],[9,15,9,16],[10,3,10,10]]}
[]
[{"$nulls":3},"Naam onderneming",{"$nulls":3},{"$f":"'Aankoop verkoop Eigen Woning'!H2:L2","v":0},{"$nulls":14},"Extra verbouwingskosten bovenop bouwdepot",{"$nulls":19},"Ja","Nieuwbouw"]
[{"$nulls":3},"Jaar",{"$nulls":3},{"$f":"'Aankoop verkoop Eigen Woning'!H3","v":0},{"$nulls":14},"Totale kosten verbouwing",{"$nulls":19},"Nee","Verbouw"]
[]
[{"$nulls":3},"Kdb-Eigen Woning-sheet"]
[{"$nulls":3},"versie 2.3 juni 2022"]
[]
[]
[]
[null,"Adres Nieuwe Woning",null,{"$f":"'Aankoop verkoop Eigen Woning'!Q3","v":0}]
[null,"Maak een keuze >",null,"Extra verbouwingskosten bovenop bouwdepot"]
[]
[]
[null,"Specificatie verbouwingskosten"]
[null,"Omschrijving",null,"Bedrag"]
{"$rows_empty":27}
[null,"Totaal",null,{"$f":"SUM(D17:D42)","v":0}]