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

{"sheet":"Loan Calculator","index":0,"n_rows":375,"n_cols":8,"rows_kept":375,"merged":[[0,2,0,7]]}
[null,null,"Simple Loan Calculator"]
[]
[{"$nulls":4},"Enter values"]
[null,null,"Loan amount"]
[null,null,"Annual interest rate"]
[null,null,"Loan period in years"]
[null,null,"Start date of loan"]
[]
[null,null,"Monthly payment",null,{"$f":"IF(Values_Entered,Monthly_Payment,\"\")","v":""}]
[null,null,"Number of payments",null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
[null,null,"Total interest",null,{"$f":"IF(Values_Entered,Total_Cost-Loan_Amount,\"\")","v":""}]
[null,null,"Total cost of loan",null,{"$f":"IF(Values_Entered,Monthly_Payment*Number_of_Payments,\"\")","v":""}]
[]
[]
[null,"No.","Payment \nDate","Beginning \nBalance","Payment","Principal","Interest","Ending \nBalance"]
[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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"","","","","","",""]