{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Uitleg","Bereken uw aflossing","ZONDER AFLOSSING","MET AFLOSSING","hulptab"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":61,"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":"Uitleg","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Vul een bedrag in."]
[]
[]
[]
[null,null,"Op welke datum wilt u deze extra aflossing betalen?"]
[null,null,"Vul een datum in (dd-mm-jjjj). De datum is nodig voor het berekenen van de invorderingsrente."]

{"sheet":"Bereken uw aflossing","index":1,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,2,33,6],[33,9,33,13],[34,2,35,6]]}
[]
[]
[]
[]
[null,null,"Rekenhulp Betalingsregeling bijzonder uitstel van betaling vanwege de coronacrisis"]
[]
[null,null,"Wat is het totale bedrag van de belastingschuld die u hebt opgebouwd voor alle belastingen waarvoor u bijzonder uitstel had, zonder de invorderingsrente?"]
[null,null,"Vul het bedrag in van de opgebouwde belastingschuld, zonder invorderingsrente."]
[]
[null,null,100000]
[]
[null,null,"Wilt u de opgebouwde belastingschuld tussentijds extra aflossen?"]
[null,null,"Kies in het invulveld 'Nee' als u dit niet wilt."]
[null,null,"Kies in het invulveld 'Ja' als u dit wel wilt."]
[]
[null,null,"Ja"]
[]
[null,null,"Wat is het bedrag dat u extra wilt aflossen?"]
[null,null,"Vul een bedrag in."]
[]
[null,null,15000]
[]
[null,null,"Op welke datum wilt u deze extra aflossing betalen?"]
[null,null,"Vul een datum in (dd-mm-jjjj). De datum is nodig voor het berekenen van de invorderingsrente."]
[]
[null,null,"2023-01-01"]
[]
[null,null,"Klik op 'Berekenen' voor de berekening van het aflossingsschema. "]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Annuïtair met extra aflossing van \"&IF(OR(C16=\"Nee\",C16=\"\"),\"€0\",TEXT(C21,\"€#.##0 ;\"))","v":"Annuïtair met extra aflossing van €15.000 "},null,null,null,null,null,null,"Annuïtair zonder extra aflossing"]
[null,null,{"$f":"IF(OR(C26=\"\",C16=\"Nee\"),\"\",IFERROR(\"U hebt een hoger bedrag ingevuld voor extra aflossing dan u aan verwachte schuld hebt op de ingevulde datum van de extra aflossing. Er wordt gerekend met de hoogst mogelijke aflossing op dat moment: \"&TEXT(ROUND(SUM('MET AFLOSSING'!$O$4:$O$64),2),\"€#.##0 ;\"),\"\"))&\".\"","v":"U hebt een hoger bedrag ingevuld voor extra aflossing dan u aan verwachte schuld hebt op de ingevulde datum van de extra aflossing. Er wordt gerekend met de hoogst mogelijke aflossing op dat moment: €15.000 ."}]
[]
[]
[null,null,"Aflossingsschema",null,null,null,null,null,null,"Aflossingsschema"]
[]
[null,null,"Begindatum:",null,null,null,"2022-10-01",null,null,"Begindatum:",null,null,null,{"$f":"G40","v":"2022-10-01"}]
[]
[null,null,"Einddatum:",null,null,null,{"$f":"IFERROR(_xlfn.IFNA(EOMONTH(VLOOKUP('MET AFLOSSING'!$K$65,'MET AFLOSSING'!$Q$5:$R$64,2,FALSE), -1)+1,N42),\"\")","v":"2027-01-01"},null,null,"Einddatum:",null,null,null,"2027-10-01"]
[]
[null,null,"Looptijd:",null,null,null,{"$f":"IFERROR((YEAR(G42) - YEAR(G40))*12 + MONTH(G42)-MONTH(G40)&\" maanden\",\"\")","v":"51 maanden"},null,null,"Looptijd:",null,null,null,{"$f":"(YEAR(N42) - YEAR(N40))*12 + MONTH(N42)-MONTH(N40)&\" maanden\"","v":"60 maanden"}]
[]
[null,null,"Maandbedrag:",null,null,null,{"$f":"'ZONDER AFLOSSING'!E20","v":1804.667624704663},null,null,"Maandbedrag:",null,null,null,{"$f":"'ZONDER AFLOSSING'!E20","v":1804.667624704663}]
[]
[null,null,"Totaalbedrag, inclusief invorderingsrente:",null,null,null,{"$f":"IFERROR('MET AFLOSSING'!E27,\"\")","v":105704.81453566262},null,null,"Totaalbedrag, inclusief invorderingsrente:",null,null,null,{"$f":"'ZONDER AFLOSSING'!E19","v":108280.05748227963}]
[]
[null,null,"Totaalbedrag invorderingsrente:",null,null,null,{"$f":"IFERROR(G48-C10,\"\")","v":5704.8145356626192},null,null,"Totaalbedrag invorderingsrente:",null,null,null,{"$f":"N48-C10","v":8280.0574822796334}]
[]
[null,null,"Rentebesparing door extra aflossing:",null,null,null,{"$f":"IFERROR(N50-G50,\"\")","v":2575.2429466170142}]

{"sheet":"ZONDER AFLOSSING","index":2,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[[23,2,23,4],[2,2,2,4],[3,2,3,3],[4,2,4,3],[5,2,5,3],[8,2,8,4],[17,2,17,4]]}
[]
[]
[null,null,"Input vanuit VIEW ONDERNEMER",null,null,null,null,"Maand","Invorderingsrente","Resterend (maanden)","Openstaand","Maandelijkse betaling","Waarvan rente","Waarvan aflossing","Extra aflossing"]
[null,null,"Belastingsschuld",null,{"$f":"'Bereken uw aflossing'!C10","v":100000},null,null,"2022-10-31",{"$f":"_xlfn.IFS(H4>=$C$15,$E$15, H4>=$C$14,$E$14, H4>=$C$13,$E$13,H4>=$C$12,$E$12,H4<=$D$11,$E$11)","v":0.01},60,{"$f":"E4","v":100000},1804.667624704663,{"$f":"K4*I4/12","v":83.333333333333329},{"$f":"L4-M4","v":1721.3342913713298},0]
[null,null,"Extra aflossing",null,0,null,null,"2022-11-30",{"$f":"_xlfn.IFS(H5>=$C$15,$E$15, H5>=$C$14,$E$14, H5>=$C$13,$E$13,H5>=$C$12,$E$12,H5<=$D$11,$E$11)","v":0.01},{"$f":"J4-1","v":59},{"$f":"K4-N4-O4","v":98278.665708628672},{"$f":"$L$4","v":1804.667624704663},{"$f":"K5*I5/12","v":81.898888090523897},{"$f":"L5-M5","v":1722.768736614139},0]
[null,null,"Op datum",null,"n.v.t.",null,null,"2022-12-31",{"$f":"_xlfn.IFS(H6>=$C$15,$E$15, H6>=$C$14,$E$14, H6>=$C$13,$E$13,H6>=$C$12,$E$12,H6<=$D$11,$E$11)","v":0.01},{"$f":"J5-1","v":58},{"$f":"K5-N5-O5","v":96555.89697201454},{"$f":"$L$4","v":1804.667624704663},80.463247476678788,1724.2043772279842,0]
[null,null,null,null,null,null,null,"2023-01-31",{"$f":"_xlfn.IFS(H7>=$C$15,$E$15, H7>=$C$14,$E$14, H7>=$C$13,$E$13,H7>=$C$12,$E$12,H7<=$D$11,$E$11)","v":0.02},57,94831.692594786553,1804.667624704663,158.05282099131094,1646.6148037133521,0]
[null,null,null,null,null,null,null,"2023-02-28",{"$f":"_xlfn.IFS(H8>=$C$15,$E$15, H8>=$C$14,$E$14, H8>=$C$13,$E$13,H8>=$C$12,$E$12,H8<=$D$11,$E$11)","v":0.02},56,93185.077791073199,1804.667624704663,155.30846298512202,1649.3591617195409,0]
[null,null,"INVORDERINGSRENTE",null,null,null,null,"2023-03-31",{"$f":"_xlfn.IFS(H9>=$C$15,$E$15, H9>=$C$14,$E$14, H9>=$C$13,$E$13,H9>=$C$12,$E$12,H9<=$D$11,$E$11)","v":0.02},55,91535.718629353665,1804.667624704663,152.55953104892276,1652.1080936557403,0]
[null,null,"Van","T/m","%",null,null,"2023-04-30",{"$f":"_xlfn.IFS(H10>=$C$15,$E$15, H10>=$C$14,$E$14, H10>=$C$13,$E$13,H10>=$C$12,$E$12,H10<=$D$11,$E$11)","v":0.02},54,89883.610535697924,1804.667624704663,149.80601755949655,1654.8616071451665,0]
[null,null,"-","2022-06-30",1E-4,null,null,"2023-05-31",{"$f":"_xlfn.IFS(H11>=$C$15,$E$15, H11>=$C$14,$E$14, H11>=$C$13,$E$13,H11>=$C$12,$E$12,H11<=$D$11,$E$11)","v":0.02},53,88228.748928552755,1804.667624704663,147.04791488092127,1657.6197098237417,0]
[null,null,"2022-07-01","2022-12-31",0.01,null,null,"2023-06-30",{"$f":"_xlfn.IFS(H12>=$C$15,$E$15, H12>=$C$14,$E$14, H12>=$C$13,$E$13,H12>=$C$12,$E$12,H12<=$D$11,$E$11)","v":0.02},52,86571.129218729009,1804.667624704663,144.28521536454835,1660.3824093401147,0]
[null,null,"2023-01-01","2023-06-30",0.02,null,null,"2023-07-31",{"$f":"_xlfn.IFS(H13>=$C$15,$E$15, H13>=$C$14,$E$14, H13>=$C$13,$E$13,H13>=$C$12,$E$12,H13<=$D$11,$E$11)","v":0.03},51,84910.746809388889,1804.667624704663,212.27686702347219,1592.3907576811907,0]
[null,null,"2023-07-01","2023-12-31",0.03,null,null,"2023-08-31",{"$f":"_xlfn.IFS(H14>=$C$15,$E$15, H14>=$C$14,$E$14, H14>=$C$13,$E$13,H14>=$C$12,$E$12,H14<=$D$11,$E$11)","v":0.03},50,83318.356051707698,1804.667624704663,208.29589012926922,1596.3717345753937,0]
[null,null,"2024-01-01","-",0.04,null,null,"2023-09-30",{"$f":"_xlfn.IFS(H15>=$C$15,$E$15, H15>=$C$14,$E$14, H15>=$C$13,$E$13,H15>=$C$12,$E$12,H15<=$D$11,$E$11)","v":0.03},49,81721.984317132301,1804.667624704663,204.30496079283077,1600.3626639118322,0]
[null,null,null,null,null,null,null,"2023-10-31",{"$f":"_xlfn.IFS(H16>=$C$15,$E$15, H16>=$C$14,$E$14, H16>=$C$13,$E$13,H16>=$C$12,$E$12,H16<=$D$11,$E$11)","v":0.03},48,80121.621653220471,1804.667624704663,200.30405413305118,1604.3635705716119,0]
[null,null,null,null,null,null,null,"2023-11-30",{"$f":"_xlfn.IFS(H17>=$C$15,$E$15, H17>=$C$14,$E$14, H17>=$C$13,$E$13,H17>=$C$12,$E$12,H17<=$D$11,$E$11)","v":0.03},47,78517.258082648856,1804.667624704663,196.29314520662214,1608.374479498041,0]
[null,null,"Output obv VIEW ONDERNEMER",null,null,null,null,"2023-12-31",{"$f":"_xlfn.IFS(H18>=$C$15,$E$15, H18>=$C$14,$E$14, H18>=$C$13,$E$13,H18>=$C$12,$E$12,H18<=$D$11,$E$11)","v":0.03},46,76908.883603150811,1804.667624704663,192.27220900787702,1612.3954156967859,0]
[null,null,"Totaal betaald",null,{"$f":"SUM($L$4:$L$63)+SUM($O$4:$O$63)","v":108280.05748227963},null,null,"2024-01-31",{"$f":"_xlfn.IFS(H19>=$C$15,$E$15, H19>=$C$14,$E$14, H19>=$C$13,$E$13,H19>=$C$12,$E$12,H19<=$D$11,$E$11)","v":0.04},45,75296.48818745403,1804.667624704663,250.98829395818009,1553.6793307464829,0]
[null,null,"Maandlast",null,{"$f":"$E$30","v":1804.667624704663},null,null,"2024-02-29",{"$f":"_xlfn.IFS(H20>=$C$15,$E$15, H20>=$C$14,$E$14, H20>=$C$13,$E$13,H20>=$C$12,$E$12,H20<=$D$11,$E$11)","v":0.04},44,73742.808856707547,1804.667624704663,245.80936285569183,1558.8582618489711,0]
[null,null,"Totaal betaalde rente",null,{"$f":"E19-E4","v":8280.0574822796334},null,null,"2024-03-31",{"$f":"_xlfn.IFS(H21>=$C$15,$E$15, H21>=$C$14,$E$14, H21>=$C$13,$E$13,H21>=$C$12,$E$12,H21<=$D$11,$E$11)","v":0.04},43,72183.950594858572,1804.667624704663,240.61316864952857,1564.0544560551343,0]
[null,null,null,null,null,null,null,"2024-04-30",{"$f":"_xlfn.IFS(H22>=$C$15,$E$15, H22>=$C$14,$E$14, H22>=$C$13,$E$13,H22>=$C$12,$E$12,H22<=$D$11,$E$11)","v":0.04},42,70619.896138803437,1804.667624704663,235.39965379601145,1569.2679709086515,0]
[null,null,null,null,null,null,null,"2024-05-31",{"$f":"_xlfn.IFS(H23>=$C$15,$E$15, H23>=$C$14,$E$14, H23>=$C$13,$E$13,H23>=$C$12,$E$12,H23<=$D$11,$E$11)","v":0.04},41,69050.628167894785,1804.667624704663,230.16876055964929,1574.4988641450136,0]
[null,null,"Rekenmethode",10,null,null,null,"2024-06-30",{"$f":"_xlfn.IFS(H24>=$C$15,$E$15, H24>=$C$14,$E$14, H24>=$C$13,$E$13,H24>=$C$12,$E$12,H24<=$D$11,$E$11)","v":0.04},40,67476.129303749767,1804.667624704663,224.92043101249922,1579.7471936921638,0]
[null,null,"x_guess",null,1666.6666666666667,null,null,"2024-07-31",{"$f":"_xlfn.IFS(H25>=$C$15,$E$15, H25>=$C$14,$E$14, H25>=$C$13,$E$13,H25>=$C$12,$E$12,H25<=$D$11,$E$11)","v":0.04},39,65896.382110057602,1804.667624704663,219.65460703352537,1585.0130176711377,0]
[null,null,"y1",null,8468.0365000000002,null,null,"2024-08-31",{"$f":"_xlfn.IFS(H26>=$C$15,$E$15, H26>=$C$14,$E$14, H26>=$C$13,$E$13,H26>=$C$12,$E$12,H26<=$D$11,$E$11)","v":0.04},38,64311.369092386463,1804.667624704663,214.37123030795487,1590.2963943967081,0]
[null,null,"y2",null,9791.1573000000008,null,null,"2024-09-30",{"$f":"_xlfn.IFS(H27>=$C$15,$E$15, H27>=$C$14,$E$14, H27>=$C$13,$E$13,H27>=$C$12,$E$12,H27<=$D$11,$E$11)","v":0.04},37,62721.072697989752,1804.667624704663,209.07024232663252,1595.5973823780305,0]
[null,null,"ym",null,9129.5969000000005,null,null,"2024-10-31",{"$f":"_xlfn.IFS(H28>=$C$15,$E$15, H28>=$C$14,$E$14, H28>=$C$13,$E$13,H28>=$C$12,$E$12,H28<=$D$11,$E$11)","v":0.04},36,61125.475315611722,1804.667624704663,203.75158438537241,1600.9160403192907,0]
[null,null,"rc",null,66.156040000000033,null,null,"2024-11-30",{"$f":"_xlfn.IFS(H29>=$C$15,$E$15, H29>=$C$14,$E$14, H29>=$C$13,$E$13,H29>=$C$12,$E$12,H29<=$D$11,$E$11)","v":0.04},35,59524.559275292435,1804.667624704663,198.41519758430812,1606.2524271203549,0]
[null,null,"x_solution",null,1804.667624704663,null,null,"2024-12-31",{"$f":"_xlfn.IFS(H30>=$C$15,$E$15, H30>=$C$14,$E$14, H30>=$C$13,$E$13,H30>=$C$12,$E$12,H30<=$D$11,$E$11)","v":0.04},34,57918.306848172077,1804.667624704663,193.06102282724024,1611.6066018774227,0]
[null,null,null,null,null,null,null,"2025-01-31",{"$f":"_xlfn.IFS(H31>=$C$15,$E$15, H31>=$C$14,$E$14, H31>=$C$13,$E$13,H31>=$C$12,$E$12,H31<=$D$11,$E$11)","v":0.04},33,56306.700246294655,1804.667624704663,187.68900082098219,1616.9786238836809,0]
[null,null,null,null,null,null,null,"2025-02-28",{"$f":"_xlfn.IFS(H32>=$C$15,$E$15, H32>=$C$14,$E$14, H32>=$C$13,$E$13,H32>=$C$12,$E$12,H32<=$D$11,$E$11)","v":0.04},32,54689.721622410972,1804.667624704663,182.29907207470322,1622.3685526299598,0]
[null,null,null,null,null,null,null,"2025-03-31",{"$f":"_xlfn.IFS(H33>=$C$15,$E$15, H33>=$C$14,$E$14, H33>=$C$13,$E$13,H33>=$C$12,$E$12,H33<=$D$11,$E$11)","v":0.04},31,53067.353069781013,1804.667624704663,176.89117689927005,1627.776447805393,0]
[null,null,null,null,null,null,null,"2025-04-30",{"$f":"_xlfn.IFS(H34>=$C$15,$E$15, H34>=$C$14,$E$14, H34>=$C$13,$E$13,H34>=$C$12,$E$12,H34<=$D$11,$E$11)","v":0.04},30,51439.576621975619,1804.667624704663,171.46525540658538,1633.2023692980777,0]
[null,null,null,null,null,null,null,"2025-05-31",{"$f":"_xlfn.IFS(H35>=$C$15,$E$15, H35>=$C$14,$E$14, H35>=$C$13,$E$13,H35>=$C$12,$E$12,H35<=$D$11,$E$11)","v":0.04},29,49806.374252677539,1804.667624704663,166.02124750892514,1638.6463771957378,0]
[null,null,null,null,null,null,null,"2025-06-30",{"$f":"_xlfn.IFS(H36>=$C$15,$E$15, H36>=$C$14,$E$14, H36>=$C$13,$E$13,H36>=$C$12,$E$12,H36<=$D$11,$E$11)","v":0.04},28,48167.727875481803,1804.667624704663,160.55909291827268,1644.1085317863904,0]
[null,null,null,null,null,null,null,"2025-07-31",{"$f":"_xlfn.IFS(H37>=$C$15,$E$15, H37>=$C$14,$E$14, H37>=$C$13,$E$13,H37>=$C$12,$E$12,H37<=$D$11,$E$11)","v":0.04},27,46523.619343695413,1804.667624704663,155.07873114565137,1649.5888935590117,0]
[null,null,null,null,null,null,null,"2025-08-31",{"$f":"_xlfn.IFS(H38>=$C$15,$E$15, H38>=$C$14,$E$14, H38>=$C$13,$E$13,H38>=$C$12,$E$12,H38<=$D$11,$E$11)","v":0.04},26,44874.030450136401,1804.667624704663,149.58010150045467,1655.0875232042083,0]
[null,null,null,null,null,null,null,"2025-09-30",{"$f":"_xlfn.IFS(H39>=$C$15,$E$15, H39>=$C$14,$E$14, H39>=$C$13,$E$13,H39>=$C$12,$E$12,H39<=$D$11,$E$11)","v":0.04},25,43218.942926932192,1804.667624704663,144.06314308977397,1660.604481614889,0]
[null,null,null,null,null,null,null,"2025-10-31",{"$f":"_xlfn.IFS(H40>=$C$15,$E$15, H40>=$C$14,$E$14, H40>=$C$13,$E$13,H40>=$C$12,$E$12,H40<=$D$11,$E$11)","v":0.04},24,41558.338445317306,1804.667624704663,138.52779481772436,1666.1398298869387,0]
[null,null,null,null,null,null,null,"2025-11-30",{"$f":"_xlfn.IFS(H41>=$C$15,$E$15, H41>=$C$14,$E$14, H41>=$C$13,$E$13,H41>=$C$12,$E$12,H41<=$D$11,$E$11)","v":0.04},23,39892.198615430367,1804.667624704663,132.9739953847679,1671.6936293198951,0]
[null,null,null,null,null,null,null,"2025-12-31",{"$f":"_xlfn.IFS(H42>=$C$15,$E$15, H42>=$C$14,$E$14, H42>=$C$13,$E$13,H42>=$C$12,$E$12,H42<=$D$11,$E$11)","v":0.04},22,38220.504986110471,1804.667624704663,127.40168328703491,1677.265941417628,0]
[null,null,null,null,null,null,null,"2026-01-31",{"$f":"_xlfn.IFS(H43>=$C$15,$E$15, H43>=$C$14,$E$14, H43>=$C$13,$E$13,H43>=$C$12,$E$12,H43<=$D$11,$E$11)","v":0.04},21,36543.23904469284,1804.667624704663,121.8107968156428,1682.8568278890202,0]
[null,null,null,null,null,null,null,"2026-02-28",{"$f":"_xlfn.IFS(H44>=$C$15,$E$15, H44>=$C$14,$E$14, H44>=$C$13,$E$13,H44>=$C$12,$E$12,H44<=$D$11,$E$11)","v":0.04},20,34860.382216803817,1804.667624704663,116.20127405601272,1688.4663506486504,0]
[null,null,null,null,null,null,null,"2026-03-31",{"$f":"_xlfn.IFS(H45>=$C$15,$E$15, H45>=$C$14,$E$14, H45>=$C$13,$E$13,H45>=$C$12,$E$12,H45<=$D$11,$E$11)","v":0.04},19,33171.915866155163,1804.667624704663,110.57305288718389,1694.0945718174792,0]
[null,null,null,null,null,null,null,"2026-04-30",{"$f":"_xlfn.IFS(H46>=$C$15,$E$15, H46>=$C$14,$E$14, H46>=$C$13,$E$13,H46>=$C$12,$E$12,H46<=$D$11,$E$11)","v":0.04},18,31477.821294337682,1804.667624704663,104.92607098112562,1699.7415537235374,0]
[null,null,null,null,null,null,null,"2026-05-31",{"$f":"_xlfn.IFS(H47>=$C$15,$E$15, H47>=$C$14,$E$14, H47>=$C$13,$E$13,H47>=$C$12,$E$12,H47<=$D$11,$E$11)","v":0.04},17,29778.079740614143,1804.667624704663,99.260265802047158,1705.4073589026159,0]
[null,null,null,null,null,null,null,"2026-06-30",{"$f":"_xlfn.IFS(H48>=$C$15,$E$15, H48>=$C$14,$E$14, H48>=$C$13,$E$13,H48>=$C$12,$E$12,H48<=$D$11,$E$11)","v":0.04},16,28072.672381711527,1804.667624704663,93.575574605705086,1711.092050098958,0]
[null,null,null,null,null,null,null,"2026-07-31",{"$f":"_xlfn.IFS(H49>=$C$15,$E$15, H49>=$C$14,$E$14, H49>=$C$13,$E$13,H49>=$C$12,$E$12,H49<=$D$11,$E$11)","v":0.04},15,26361.580331612568,1804.667624704663,87.87193443870855,1716.7956902659544,0]
[null,null,null,null,null,null,null,"2026-08-31",{"$f":"_xlfn.IFS(H50>=$C$15,$E$15, H50>=$C$14,$E$14, H50>=$C$13,$E$13,H50>=$C$12,$E$12,H50<=$D$11,$E$11)","v":0.04},14,24644.784641346614,1804.667624704663,82.149282137822055,1722.5183425668411,0]
[null,null,null,null,null,null,null,"2026-09-30",{"$f":"_xlfn.IFS(H51>=$C$15,$E$15, H51>=$C$14,$E$14, H51>=$C$13,$E$13,H51>=$C$12,$E$12,H51<=$D$11,$E$11)","v":0.04},13,22922.266298779774,1804.667624704663,76.407554329265921,1728.2600703753972,0]
[null,null,null,null,null,null,null,"2026-10-31",{"$f":"_xlfn.IFS(H52>=$C$15,$E$15, H52>=$C$14,$E$14, H52>=$C$13,$E$13,H52>=$C$12,$E$12,H52<=$D$11,$E$11)","v":0.04},12,21194.006228404378,1804.667624704663,70.646687428014602,1734.0209372766485,0]
[null,null,null,null,null,null,null,"2026-11-30",{"$f":"_xlfn.IFS(H53>=$C$15,$E$15, H53>=$C$14,$E$14, H53>=$C$13,$E$13,H53>=$C$12,$E$12,H53<=$D$11,$E$11)","v":0.04},11,19459.98529112773,1804.667624704663,64.866617637092432,1739.8010070675705,0]
[null,null,null,null,null,null,null,"2026-12-31",{"$f":"_xlfn.IFS(H54>=$C$15,$E$15, H54>=$C$14,$E$14, H54>=$C$13,$E$13,H54>=$C$12,$E$12,H54<=$D$11,$E$11)","v":0.04},10,17720.18428406016,1804.667624704663,59.067280946867207,1745.6003437577958,0]
[null,null,null,null,null,null,null,"2027-01-31",{"$f":"_xlfn.IFS(H55>=$C$15,$E$15, H55>=$C$14,$E$14, H55>=$C$13,$E$13,H55>=$C$12,$E$12,H55<=$D$11,$E$11)","v":0.04},9,15974.583940302364,1804.667624704663,53.248613134341213,1751.4190115703218,0]
[null,null,null,null,null,null,null,"2027-02-28",{"$f":"_xlfn.IFS(H56>=$C$15,$E$15, H56>=$C$14,$E$14, H56>=$C$13,$E$13,H56>=$C$12,$E$12,H56<=$D$11,$E$11)","v":0.04},8,14223.164928732042,1804.667624704663,47.410549762440134,1757.257074942223,0]
[null,null,null,null,null,null,null,"2027-03-31",{"$f":"_xlfn.IFS(H57>=$C$15,$E$15, H57>=$C$14,$E$14, H57>=$C$13,$E$13,H57>=$C$12,$E$12,H57<=$D$11,$E$11)","v":0.04},7,12465.907853789819,1804.667624704663,41.553026179299394,1763.1145985253636,0]
[null,null,null,null,null,null,null,"2027-04-30",{"$f":"_xlfn.IFS(H58>=$C$15,$E$15, H58>=$C$14,$E$14, H58>=$C$13,$E$13,H58>=$C$12,$E$12,H58<=$D$11,$E$11)","v":0.04},6,10702.793255264454,1804.667624704663,35.675977517548183,1768.9916471871147,0]
[null,null,null,null,null,null,null,"2027-05-31",{"$f":"_xlfn.IFS(H59>=$C$15,$E$15, H59>=$C$14,$E$14, H59>=$C$13,$E$13,H59>=$C$12,$E$12,H59<=$D$11,$E$11)","v":0.04},5,8933.8016080773396,1804.667624704663,29.779338693591132,1774.8882860110718,0]
[null,null,null,null,null,null,null,"2027-06-30",{"$f":"_xlfn.IFS(H60>=$C$15,$E$15, H60>=$C$14,$E$14, H60>=$C$13,$E$13,H60>=$C$12,$E$12,H60<=$D$11,$E$11)","v":0.04},4,7158.9133220662679,1804.667624704663,23.863044406887557,1780.8045802977754,0]
[null,null,null,null,null,null,null,"2027-07-31",{"$f":"_xlfn.IFS(H61>=$C$15,$E$15, H61>=$C$14,$E$14, H61>=$C$13,$E$13,H61>=$C$12,$E$12,H61<=$D$11,$E$11)","v":0.04},3,5378.1087417684921,1804.667624704663,17.927029139228306,1786.7405955654347,0]
[null,null,null,null,null,null,null,"2027-08-31",{"$f":"_xlfn.IFS(H62>=$C$15,$E$15, H62>=$C$14,$E$14, H62>=$C$13,$E$13,H62>=$C$12,$E$12,H62<=$D$11,$E$11)","v":0.04},2,3591.3681462030572,1804.667624704663,11.971227154010192,1792.6963975506528,0]
[null,null,null,null,null,null,null,"2027-09-30",{"$f":"_xlfn.IFS(H63>=$C$15,$E$15, H63>=$C$14,$E$14, H63>=$C$13,$E$13,H63>=$C$12,$E$12,H63<=$D$11,$E$11)","v":0.04},1,1798.6717486524044,1804.667624704663,5.9955724955080143,{"$f":"L63-M63","v":1798.672052209155},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K63-N63-O63","v":-3.0355675062310183E-4}]

{"sheet":"MET AFLOSSING","index":3,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":true,"merged":[[11,2,13,4],[16,2,16,4],[25,2,25,4],[2,2,2,4],[5,2,5,3],[9,2,9,4],[10,2,10,4]]}
[]
[]
[null,null,"Input vanuit VIEW ONDERNEMER",null,null,null,null,"Maand","Invorderingsrente","Resterend (maanden)","Openstaand","Maandelijkse betaling","Waarvan rente","Waarvan aflossing","Extra aflossing",null,"Hulpkolom","Hulpdatum"]
[null,null,"Belastingsschuld",null,{"$f":"'Bereken uw aflossing'!C10","v":100000},null,null,"2022-09-30",null,null,null,null,null,null,{"$f":"IF(H4=$C$11,$E$5,0)","v":0}]
[null,null,"Extra aflossing",null,{"$f":"IF('Bereken uw aflossing'!C16=\"Ja\",'Bereken uw aflossing'!C21,0)","v":15000},null,null,"2022-10-31",{"$f":"_xlfn.IFS(H5>=$C$23,$E$23, H5>=$C$22,$E$22, H5>=$C$21,$E$21,H5>=$C$20,$E$20,H5<=$D$19,$E$19)","v":0.01},60,{"$f":"E4-O4","v":100000},{"$f":"MIN($E$28, K5 + K5*I5/12)","v":1804.667624704663},{"$f":"K5*I5/12","v":83.333333333333329},{"$f":"L5-M5","v":1721.3342913713298},{"$f":"IF(H5=$C$11,MIN($E$5, K5-N5),0)","v":0},null,{"$f":"IF(K5<=0.004, 0, \"niet 0\")","v":"niet 0"},{"$f":"H5","v":"2022-10-31"}]
[null,null,"Op datum",null,{"$f":"IF('Bereken uw aflossing'!C16=\"Ja\",'Bereken uw aflossing'!C26,\"\")","v":"2023-01-01"},null,null,"2022-11-30",{"$f":"_xlfn.IFS(H6>=$C$23,$E$23, H6>=$C$22,$E$22, H6>=$C$21,$E$21,H6>=$C$20,$E$20,H6<=$D$19,$E$19)","v":0.01},{"$f":"J5-1","v":59},{"$f":"MAX(0, K5-N5-O5)","v":98278.665708628672},{"$f":"MIN($E$28, K6 + K6*I6/12)","v":1804.667624704663},{"$f":"K6*I6/12","v":81.898888090523897},{"$f":"L6-M6","v":1722.768736614139},{"$f":"IF(H6=$C$11,MIN($E$5, K6-N6),0)","v":0},null,{"$f":"IF(K6<=0.004, 0, \"niet 0\")","v":"niet 0"},{"$f":"H6","v":"2022-11-30"}]
[null,null,null,null,null,null,null,"2022-12-31",{"$f":"_xlfn.IFS(H7>=$C$23,$E$23, H7>=$C$22,$E$22, H7>=$C$21,$E$21,H7>=$C$20,$E$20,H7<=$D$19,$E$19)","v":0.01},{"$f":"J6-1","v":58},{"$f":"MAX(0, K6-N6-O6)","v":96555.89697201454},1804.667624704663,80.463247476678788,1724.2043772279842,0,null,"niet 0","2022-12-31"]
[null,null,null,null,null,null,null,"2023-01-31",{"$f":"_xlfn.IFS(H8>=$C$23,$E$23, H8>=$C$22,$E$22, H8>=$C$21,$E$21,H8>=$C$20,$E$20,H8<=$D$19,$E$19)","v":0.02},57,94831.692594786553,1804.667624704663,158.05282099131094,1646.6148037133521,15000,null,"niet 0","2023-01-31"]
[null,null,null,null,null,null,null,"2023-02-28",{"$f":"_xlfn.IFS(H9>=$C$23,$E$23, H9>=$C$22,$E$22, H9>=$C$21,$E$21,H9>=$C$20,$E$20,H9<=$D$19,$E$19)","v":0.02},56,78185.077791073199,1804.667624704663,130.30846298512202,1674.3591617195409,0,null,"niet 0","2023-02-28"]
[null,null,"Extra aflossing verrekend op:",null,null,null,null,"2023-03-31",{"$f":"_xlfn.IFS(H10>=$C$23,$E$23, H10>=$C$22,$E$22, H10>=$C$21,$E$21,H10>=$C$20,$E$20,H10<=$D$19,$E$19)","v":0.02},55,76510.718629353665,1804.667624704663,127.51786438225611,1677.149760322407,0,null,"niet 0","2023-03-31"]
[null,null,{"$f":"IFERROR(EOMONTH(E6,0), \"\")","v":"2023-01-31"},null,null,null,null,"2023-04-30",{"$f":"_xlfn.IFS(H11>=$C$23,$E$23, H11>=$C$22,$E$22, H11>=$C$21,$E$21,H11>=$C$20,$E$20,H11<=$D$19,$E$19)","v":0.02},54,74833.568869031253,1804.667624704663,124.72261478171875,1679.9450099229443,0,null,"niet 0","2023-04-30"]
[null,null,"De extra aflossing wordt meegenomen op de laatste dag van de maand",null,null,null,null,"2023-05-31",{"$f":"_xlfn.IFS(H12>=$C$23,$E$23, H12>=$C$22,$E$22, H12>=$C$21,$E$21,H12>=$C$20,$E$20,H12<=$D$19,$E$19)","v":0.02},53,73153.623859108309,1804.667624704663,121.92270643184719,1682.7449182728158,0,null,"niet 0","2023-05-31"]
[null,null,null,null,null,null,null,"2023-06-30",{"$f":"_xlfn.IFS(H13>=$C$23,$E$23, H13>=$C$22,$E$22, H13>=$C$21,$E$21,H13>=$C$20,$E$20,H13<=$D$19,$E$19)","v":0.02},52,71470.878940835493,1804.667624704663,119.11813156805916,1685.5494931366038,0,null,"niet 0","2023-06-30"]
[null,null,null,null,null,null,null,"2023-07-31",{"$f":"_xlfn.IFS(H14>=$C$23,$E$23, H14>=$C$22,$E$22, H14>=$C$21,$E$21,H14>=$C$20,$E$20,H14<=$D$19,$E$19)","v":0.03},51,69785.329447698896,1804.667624704663,174.46332361924723,1630.2043010854159,0,null,"niet 0","2023-07-31"]
[null,null,null,null,null,null,null,"2023-08-31",{"$f":"_xlfn.IFS(H15>=$C$23,$E$23, H15>=$C$22,$E$22, H15>=$C$21,$E$21,H15>=$C$20,$E$20,H15<=$D$19,$E$19)","v":0.03},50,68155.125146613485,1804.667624704663,170.38781286653372,1634.2798118381293,0,null,"niet 0","2023-08-31"]
[null,null,null,null,null,null,null,"2023-09-30",{"$f":"_xlfn.IFS(H16>=$C$23,$E$23, H16>=$C$22,$E$22, H16>=$C$21,$E$21,H16>=$C$20,$E$20,H16<=$D$19,$E$19)","v":0.03},49,66520.845334775353,1804.667624704663,166.30211333693839,1638.3655113677246,0,null,"niet 0","2023-09-30"]
[null,null,"INVORDERINGSRENTE",null,null,null,null,"2023-10-31",{"$f":"_xlfn.IFS(H17>=$C$23,$E$23, H17>=$C$22,$E$22, H17>=$C$21,$E$21,H17>=$C$20,$E$20,H17<=$D$19,$E$19)","v":0.03},48,64882.47982340763,1804.667624704663,162.20619955851907,1642.4614251461439,0,null,"niet 0","2023-10-31"]
[null,null,"Van","T/m","%",null,null,"2023-11-30",{"$f":"_xlfn.IFS(H18>=$C$23,$E$23, H18>=$C$22,$E$22, H18>=$C$21,$E$21,H18>=$C$20,$E$20,H18<=$D$19,$E$19)","v":0.03},47,63240.018398261484,1804.667624704663,158.10004599565369,1646.5675787090092,0,null,"niet 0","2023-11-30"]
[null,null,"-","2022-06-30",{"$f":"'ZONDER AFLOSSING'!E11","v":1E-4},null,null,"2023-12-31",{"$f":"_xlfn.IFS(H19>=$C$23,$E$23, H19>=$C$22,$E$22, H19>=$C$21,$E$21,H19>=$C$20,$E$20,H19<=$D$19,$E$19)","v":0.03},46,61593.450819552476,1804.667624704663,153.98362704888117,1650.6839976557819,0,null,"niet 0","2023-12-31"]
[null,null,"2022-07-01","2022-12-31",{"$f":"'ZONDER AFLOSSING'!E12","v":0.01},null,null,"2024-01-31",{"$f":"_xlfn.IFS(H20>=$C$23,$E$23, H20>=$C$22,$E$22, H20>=$C$21,$E$21,H20>=$C$20,$E$20,H20<=$D$19,$E$19)","v":0.04},45,59942.766821896694,1804.667624704663,199.80922273965564,1604.8584019650075,0,null,"niet 0","2024-01-31"]
[null,null,"2023-01-01","2023-06-30",{"$f":"'ZONDER AFLOSSING'!E13","v":0.02},null,null,"2024-02-29",{"$f":"_xlfn.IFS(H21>=$C$23,$E$23, H21>=$C$22,$E$22, H21>=$C$21,$E$21,H21>=$C$20,$E$20,H21<=$D$19,$E$19)","v":0.04},44,58337.908419931686,1804.667624704663,194.45969473310561,1610.2079299715574,0,null,"niet 0","2024-02-29"]
[null,null,"2023-07-01","2023-12-31",{"$f":"'ZONDER AFLOSSING'!E14","v":0.03},null,null,"2024-03-31",{"$f":"_xlfn.IFS(H22>=$C$23,$E$23, H22>=$C$22,$E$22, H22>=$C$21,$E$21,H22>=$C$20,$E$20,H22<=$D$19,$E$19)","v":0.04},43,56727.700489960131,1804.667624704663,189.0923349665338,1615.5752897381292,0,null,"niet 0","2024-03-31"]
[null,null,"2024-01-01","-",{"$f":"'ZONDER AFLOSSING'!E15","v":0.04},null,null,"2024-04-30",{"$f":"_xlfn.IFS(H23>=$C$23,$E$23, H23>=$C$22,$E$22, H23>=$C$21,$E$21,H23>=$C$20,$E$20,H23<=$D$19,$E$19)","v":0.04},42,55112.125200221999,1804.667624704663,183.70708400074,1620.960540703923,0,null,"niet 0","2024-04-30"]
[null,null,null,null,null,null,null,"2024-05-31",{"$f":"_xlfn.IFS(H24>=$C$23,$E$23, H24>=$C$22,$E$22, H24>=$C$21,$E$21,H24>=$C$20,$E$20,H24<=$D$19,$E$19)","v":0.04},41,53491.164659518079,1804.667624704663,178.30388219839361,1626.3637425062693,0,null,"niet 0","2024-05-31"]
[null,null,null,null,null,null,null,"2024-06-30",{"$f":"_xlfn.IFS(H25>=$C$23,$E$23, H25>=$C$22,$E$22, H25>=$C$21,$E$21,H25>=$C$20,$E$20,H25<=$D$19,$E$19)","v":0.04},40,51864.800917011809,1804.667624704663,172.88266972337271,1631.7849549812904,0,null,"niet 0","2024-06-30"]
[null,null,"Output obv VIEW ONDERNEMER",null,null,null,null,"2024-07-31",{"$f":"_xlfn.IFS(H26>=$C$23,$E$23, H26>=$C$22,$E$22, H26>=$C$21,$E$21,H26>=$C$20,$E$20,H26<=$D$19,$E$19)","v":0.04},39,50233.01596203052,1804.667624704663,167.44338654010173,1637.2242381645613,0,null,"niet 0","2024-07-31"]
[null,null,"Totaal betaald",null,{"$f":"SUM($L$4:$L$64)+SUM($O$4:$O$64)","v":105704.81453566262},null,null,"2024-08-31",{"$f":"_xlfn.IFS(H27>=$C$23,$E$23, H27>=$C$22,$E$22, H27>=$C$21,$E$21,H27>=$C$20,$E$20,H27<=$D$19,$E$19)","v":0.04},38,48595.791723865957,1804.667624704663,161.98597241288653,1642.6816522917766,0,null,"niet 0","2024-08-31"]
[null,null,"Maandlast ",null,{"$f":"'ZONDER AFLOSSING'!E20","v":1804.667624704663},null,null,"2024-09-30",{"$f":"_xlfn.IFS(H28>=$C$23,$E$23, H28>=$C$22,$E$22, H28>=$C$21,$E$21,H28>=$C$20,$E$20,H28<=$D$19,$E$19)","v":0.04},37,46953.110071574178,1804.667624704663,156.51036690524725,1648.1572577994157,0,null,"niet 0","2024-09-30"]
[null,null,"Totaal betaalde rente",null,{"$f":"E27-E4","v":5704.8145356626192},null,null,"2024-10-31",{"$f":"_xlfn.IFS(H29>=$C$23,$E$23, H29>=$C$22,$E$22, H29>=$C$21,$E$21,H29>=$C$20,$E$20,H29<=$D$19,$E$19)","v":0.04},36,45304.952813774762,1804.667624704663,151.01650937924921,1653.6511153254137,0,null,"niet 0","2024-10-31"]
[null,null,null,null,null,null,null,"2024-11-30",{"$f":"_xlfn.IFS(H30>=$C$23,$E$23, H30>=$C$22,$E$22, H30>=$C$21,$E$21,H30>=$C$20,$E$20,H30<=$D$19,$E$19)","v":0.04},35,43651.301698449352,1804.667624704663,145.50433899483116,1659.1632857098318,0,null,"niet 0","2024-11-30"]
[null,null,null,null,null,null,null,"2024-12-31",{"$f":"_xlfn.IFS(H31>=$C$23,$E$23, H31>=$C$22,$E$22, H31>=$C$21,$E$21,H31>=$C$20,$E$20,H31<=$D$19,$E$19)","v":0.04},34,41992.138412739521,1804.667624704663,139.97379470913174,1664.6938299955314,0,null,"niet 0","2024-12-31"]
[null,null,null,null,null,null,null,"2025-01-31",{"$f":"_xlfn.IFS(H32>=$C$23,$E$23, H32>=$C$22,$E$22, H32>=$C$21,$E$21,H32>=$C$20,$E$20,H32<=$D$19,$E$19)","v":0.04},33,40327.444582743992,1804.667624704663,134.4248152758133,1670.2428094288498,0,null,"niet 0","2025-01-31"]
[null,null,null,null,null,null,null,"2025-02-28",{"$f":"_xlfn.IFS(H33>=$C$23,$E$23, H33>=$C$22,$E$22, H33>=$C$21,$E$21,H33>=$C$20,$E$20,H33<=$D$19,$E$19)","v":0.04},32,38657.201773315144,1804.667624704663,128.85733924438381,1675.8102854602791,0,null,"niet 0","2025-02-28"]
[null,null,null,null,null,null,null,"2025-03-31",{"$f":"_xlfn.IFS(H34>=$C$23,$E$23, H34>=$C$22,$E$22, H34>=$C$21,$E$21,H34>=$C$20,$E$20,H34<=$D$19,$E$19)","v":0.04},31,36981.391487854868,1804.667624704663,123.27130495951623,1681.3963197451467,0,null,"niet 0","2025-03-31"]
[null,null,null,null,null,null,null,"2025-04-30",{"$f":"_xlfn.IFS(H35>=$C$23,$E$23, H35>=$C$22,$E$22, H35>=$C$21,$E$21,H35>=$C$20,$E$20,H35<=$D$19,$E$19)","v":0.04},30,35299.995168109723,1804.667624704663,117.66665056036574,1687.0009741442973,0,null,"niet 0","2025-04-30"]
[null,null,null,null,null,null,null,"2025-05-31",{"$f":"_xlfn.IFS(H36>=$C$23,$E$23, H36>=$C$22,$E$22, H36>=$C$21,$E$21,H36>=$C$20,$E$20,H36<=$D$19,$E$19)","v":0.04},29,33612.994193965424,1804.667624704663,112.04331397988476,1692.6243107247783,0,null,"niet 0","2025-05-31"]
[null,null,null,null,null,null,null,"2025-06-30",{"$f":"_xlfn.IFS(H37>=$C$23,$E$23, H37>=$C$22,$E$22, H37>=$C$21,$E$21,H37>=$C$20,$E$20,H37<=$D$19,$E$19)","v":0.04},28,31920.369883240644,{"$f":"MIN($E$28, K37 + K37*I37/12)","v":1804.667624704663},106.40123294413549,1698.2663917605275,0,null,"niet 0","2025-06-30"]
[null,null,null,null,null,null,null,"2025-07-31",{"$f":"_xlfn.IFS(H38>=$C$23,$E$23, H38>=$C$22,$E$22, H38>=$C$21,$E$21,H38>=$C$20,$E$20,H38<=$D$19,$E$19)","v":0.04},27,30222.103491480117,1804.667624704663,100.74034497160039,1703.9272797330627,0,null,"niet 0","2025-07-31"]
[null,null,null,null,null,null,null,"2025-08-31",{"$f":"_xlfn.IFS(H39>=$C$23,$E$23, H39>=$C$22,$E$22, H39>=$C$21,$E$21,H39>=$C$20,$E$20,H39<=$D$19,$E$19)","v":0.04},26,28518.176211747053,1804.667624704663,95.06058737249019,1709.6070373321729,0,null,"niet 0","2025-08-31"]
[null,null,null,null,null,null,null,"2025-09-30",{"$f":"_xlfn.IFS(H40>=$C$23,$E$23, H40>=$C$22,$E$22, H40>=$C$21,$E$21,H40>=$C$20,$E$20,H40<=$D$19,$E$19)","v":0.04},25,26808.569174414879,1804.667624704663,89.361897248049601,1715.3057274566133,0,null,"niet 0","2025-09-30"]
[null,null,null,null,null,null,null,"2025-10-31",{"$f":"_xlfn.IFS(H41>=$C$23,$E$23, H41>=$C$22,$E$22, H41>=$C$21,$E$21,H41>=$C$20,$E$20,H41<=$D$19,$E$19)","v":0.04},24,25093.263446958266,1804.667624704663,83.644211489860893,1721.0234132148021,0,null,"niet 0","2025-10-31"]
[null,null,null,null,null,null,null,"2025-11-30",{"$f":"_xlfn.IFS(H42>=$C$23,$E$23, H42>=$C$22,$E$22, H42>=$C$21,$E$21,H42>=$C$20,$E$20,H42<=$D$19,$E$19)","v":0.04},23,23372.240033743463,1804.667624704663,77.907466779144883,1726.7601579255181,0,null,"niet 0","2025-11-30"]
[null,null,null,null,null,null,null,"2025-12-31",{"$f":"_xlfn.IFS(H43>=$C$23,$E$23, H43>=$C$22,$E$22, H43>=$C$21,$E$21,H43>=$C$20,$E$20,H43<=$D$19,$E$19)","v":0.04},22,21645.479875817946,1804.667624704663,72.151599586059817,1732.5160251186032,0,null,"niet 0","2025-12-31"]
[null,null,null,null,null,null,null,"2026-01-31",{"$f":"_xlfn.IFS(H44>=$C$23,$E$23, H44>=$C$22,$E$22, H44>=$C$21,$E$21,H44>=$C$20,$E$20,H44<=$D$19,$E$19)","v":0.04},21,19912.963850699343,1804.667624704663,66.37654616899782,1738.2910785356653,0,null,"niet 0","2026-01-31"]
[null,null,null,null,null,null,null,"2026-02-28",{"$f":"_xlfn.IFS(H45>=$C$23,$E$23, H45>=$C$22,$E$22, H45>=$C$21,$E$21,H45>=$C$20,$E$20,H45<=$D$19,$E$19)","v":0.04},20,18174.672772163678,1804.667624704663,60.582242573878922,1744.0853821307842,0,null,"niet 0","2026-02-28"]
[null,null,null,null,null,null,null,"2026-03-31",{"$f":"_xlfn.IFS(H46>=$C$23,$E$23, H46>=$C$22,$E$22, H46>=$C$21,$E$21,H46>=$C$20,$E$20,H46<=$D$19,$E$19)","v":0.04},19,16430.587390032895,1804.667624704663,54.768624633442982,1749.8990000712201,0,null,"niet 0","2026-03-31"]
[null,null,null,null,null,null,null,"2026-04-30",{"$f":"_xlfn.IFS(H47>=$C$23,$E$23, H47>=$C$22,$E$22, H47>=$C$21,$E$21,H47>=$C$20,$E$20,H47<=$D$19,$E$19)","v":0.04},18,14680.688389961675,1804.667624704663,48.935627966538924,1755.7319967381241,0,null,"niet 0","2026-04-30"]
[null,null,null,null,null,null,null,"2026-05-31",{"$f":"_xlfn.IFS(H48>=$C$23,$E$23, H48>=$C$22,$E$22, H48>=$C$21,$E$21,H48>=$C$20,$E$20,H48<=$D$19,$E$19)","v":0.04},17,12924.956393223551,1804.667624704663,43.083187977411832,1761.5844367272512,0,null,"niet 0","2026-05-31"]
[null,null,null,null,null,null,null,"2026-06-30",{"$f":"_xlfn.IFS(H49>=$C$23,$E$23, H49>=$C$22,$E$22, H49>=$C$21,$E$21,H49>=$C$20,$E$20,H49<=$D$19,$E$19)","v":0.04},16,11163.371956496299,1804.667624704663,37.211239854987667,1767.4563848496753,0,null,"niet 0","2026-06-30"]
[null,null,null,null,null,null,null,"2026-07-31",{"$f":"_xlfn.IFS(H50>=$C$23,$E$23, H50>=$C$22,$E$22, H50>=$C$21,$E$21,H50>=$C$20,$E$20,H50<=$D$19,$E$19)","v":0.04},15,9395.9155716466248,1804.667624704663,31.31971857215542,1773.3479061325077,0,null,"niet 0","2026-07-31"]
[null,null,null,null,null,null,null,"2026-08-31",{"$f":"_xlfn.IFS(H51>=$C$23,$E$23, H51>=$C$22,$E$22, H51>=$C$21,$E$21,H51>=$C$20,$E$20,H51<=$D$19,$E$19)","v":0.04},14,7622.5676655141169,1804.667624704663,25.408558885047057,1779.2590658196159,0,null,"niet 0","2026-08-31"]
[null,null,null,null,null,null,null,"2026-09-30",{"$f":"_xlfn.IFS(H52>=$C$23,$E$23, H52>=$C$22,$E$22, H52>=$C$21,$E$21,H52>=$C$20,$E$20,H52<=$D$19,$E$19)","v":0.04},13,5843.308599694501,1804.667624704663,19.477695332315005,1785.1899293723479,0,null,"niet 0","2026-09-30"]
[null,null,null,null,null,null,null,"2026-10-31",{"$f":"_xlfn.IFS(H53>=$C$23,$E$23, H53>=$C$22,$E$22, H53>=$C$21,$E$21,H53>=$C$20,$E$20,H53<=$D$19,$E$19)","v":0.04},12,4058.1186703221529,1804.667624704663,13.527062234407175,1791.1405624702559,0,null,"niet 0","2026-10-31"]
[null,null,null,null,null,null,null,"2026-11-30",{"$f":"_xlfn.IFS(H54>=$C$23,$E$23, H54>=$C$22,$E$22, H54>=$C$21,$E$21,H54>=$C$20,$E$20,H54<=$D$19,$E$19)","v":0.04},11,2266.9781078518972,1804.667624704663,7.556593692839658,1797.1110310118233,0,null,"niet 0","2026-11-30"]
[null,null,null,null,null,null,null,"2026-12-31",{"$f":"_xlfn.IFS(H55>=$C$23,$E$23, H55>=$C$22,$E$22, H55>=$C$21,$E$21,H55>=$C$20,$E$20,H55<=$D$19,$E$19)","v":0.04},10,469.86707684007388,471.43330042954079,1.5662235894669128,469.86707684007388,0,null,"niet 0","2026-12-31"]
[null,null,null,null,null,null,null,"2027-01-31",{"$f":"_xlfn.IFS(H56>=$C$23,$E$23, H56>=$C$22,$E$22, H56>=$C$21,$E$21,H56>=$C$20,$E$20,H56<=$D$19,$E$19)","v":0.04},9,0,0,0,0,0,null,0,"2027-01-31"]
[null,null,null,null,null,null,null,"2027-02-28",{"$f":"_xlfn.IFS(H57>=$C$23,$E$23, H57>=$C$22,$E$22, H57>=$C$21,$E$21,H57>=$C$20,$E$20,H57<=$D$19,$E$19)","v":0.04},8,0,0,0,0,0,null,0,"2027-02-28"]
[null,null,null,null,null,null,null,"2027-03-31",{"$f":"_xlfn.IFS(H58>=$C$23,$E$23, H58>=$C$22,$E$22, H58>=$C$21,$E$21,H58>=$C$20,$E$20,H58<=$D$19,$E$19)","v":0.04},7,0,0,0,0,0,null,0,"2027-03-31"]
[null,null,null,null,null,null,null,"2027-04-30",{"$f":"_xlfn.IFS(H59>=$C$23,$E$23, H59>=$C$22,$E$22, H59>=$C$21,$E$21,H59>=$C$20,$E$20,H59<=$D$19,$E$19)","v":0.04},6,0,0,0,0,0,null,0,"2027-04-30"]
[null,null,null,null,null,null,null,"2027-05-31",{"$f":"_xlfn.IFS(H60>=$C$23,$E$23, H60>=$C$22,$E$22, H60>=$C$21,$E$21,H60>=$C$20,$E$20,H60<=$D$19,$E$19)","v":0.04},5,0,0,0,0,0,null,0,"2027-05-31"]
[null,null,null,null,null,null,null,"2027-06-30",{"$f":"_xlfn.IFS(H61>=$C$23,$E$23, H61>=$C$22,$E$22, H61>=$C$21,$E$21,H61>=$C$20,$E$20,H61<=$D$19,$E$19)","v":0.04},4,0,0,0,0,0,null,0,"2027-06-30"]
[null,null,null,null,null,null,null,"2027-07-31",{"$f":"_xlfn.IFS(H62>=$C$23,$E$23, H62>=$C$22,$E$22, H62>=$C$21,$E$21,H62>=$C$20,$E$20,H62<=$D$19,$E$19)","v":0.04},3,0,0,0,0,0,null,0,"2027-07-31"]
[null,null,null,null,null,null,null,"2027-08-31",{"$f":"_xlfn.IFS(H63>=$C$23,$E$23, H63>=$C$22,$E$22, H63>=$C$21,$E$21,H63>=$C$20,$E$20,H63<=$D$19,$E$19)","v":0.04},2,0,0,0,0,0,null,0,"2027-08-31"]
[null,null,null,null,null,null,null,"2027-09-30",{"$f":"_xlfn.IFS(H64>=$C$23,$E$23, H64>=$C$22,$E$22, H64>=$C$21,$E$21,H64>=$C$20,$E$20,H64<=$D$19,$E$19)","v":0.04},1,0,0,0,{"$f":"L64-M64","v":0},0,null,0,"2027-09-30"]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"hulptab","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ja"]
["Nee"]