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

{"sheet":"Leningscalculator","index":0,"n_rows":375,"n_cols":8,"rows_kept":375,"merged":[[0,2,0,7]]}
[null,null,"Eenvoudige leningscalculator"]
[]
[{"$nulls":4},"Voer waarden in"]
[null,null,"Geleend bedrag"]
[null,null,"Jaarlijks rentepercentage"]
[null,null,"Looptijd in jaren"]
[null,null,"Begindatum van lening"]
[]
[null,null,"Maandelijkse betaling",null,{"$f":"IF(Values_Entered,Monthly_Payment,\"\")","v":""}]
[null,null,"Aantal betalingen",null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
[null,null,"Totaal rentebedrag",null,{"$f":"IF(Values_Entered,Total_Cost-Loan_Amount,\"\")","v":""}]
[null,null,"Totale kosten van lening",null,{"$f":"IF(Values_Entered,Monthly_Payment*Number_of_Payments,\"\")","v":""}]
[]
[]
[null,"Nr.","Betaald op","Beginsaldo","Betaling","Hoofdsom","Rente","Eindsaldo"]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]