{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BALLONLENING"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"BALLONLENING","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","BALLONLENING","DATUM"]
[null,"AANNAMEN"]
[null,"HOOFDSOM LENING",{"v":10000,"d":"€ 10,000.00"}]
[null,"JAARLIJKS RENTEPERCENTAGE",{"v":0.0585,"d":"5.85%"}]
[null,"AFLOSSINGSPERIODE (IN JAREN)",15]
[null,"JAREN TOT BALLONBETALING",5]
[null,"BELANGRIJKE FINANCIËLE GEGEVENS"]
[null,"MAANDELIJKSE BETALING",{"$f":"IFERROR(IF(SUM(Aannamen)>0,ROUND(PMT(Rente/12,Periode*12,-Hoofdsom),2),\"\"),\"\")","v":{"v":83.58,"d":"€ 83.58"}}]
[null,"TOTAAL MAANDELIJKSE BETALINGEN",{"$f":"IFERROR(IF(AND(MaandelijkseBetaling>0,JarenTotAfbetaling>0),JarenTotAfbetaling*12*MaandelijkseBetaling,\"\"),\"\")","v":{"v":5014.8,"d":"€ 5,014.80"}}]
[null,"TOTAAL BETAALD BEDRAG",{"$f":"IFERROR(IF(AND(MaandelijkseBetaling>0,JarenTotAfbetaling>0),TotaalMaandelijkseBetalingen+Ballonbetaling,\"\"),\"\")","v":{"v":12594.464455242689,"d":"€ 12,594.46"}}]
[null,"TOTALE RENTE",{"$f":"IFERROR(IF(OR(TotaalBetaaldBedrag>0,JarenTotAfbetaling>0),TotaalBetaaldBedrag-Hoofdsom,\"\"),\"\")","v":{"v":2594.464455242689,"d":"€ 2,594.46"}}]
[null,"BALLONBETALING",{"$f":"IFERROR(IF(AND(SUM(Aannamen2)>0,SUM(MaandelijkseBetaling)>0),PV(Rente/12,(Periode-JarenTotAfbetaling)*12,-MaandelijkseBetaling),\"\"),\"\")","v":{"v":7579.664455242689,"d":"€ 7,579.66"}}]