{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Loan Calculator"],"not_rendered":{"external_links":1,"defined_names":30},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Loan Calculator","index":0,"n_rows":377,"n_cols":9,"rows_kept":377,"merged":[[0,0,0,8],[3,0,3,2],[3,5,3,8],[4,0,4,2],[4,5,4,8],[5,0,5,2],[6,0,6,2],[7,0,7,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2]],"flags":["formulas_cached_only"]}
["Loan Calculator with Extra Payments"]
[]
[{"$nulls":3},"Enter values",null,"Instructions"]
["Loan amount",{"$nulls":4},"Must be between 1 and 30 years."]
["Annual interest rate",{"$nulls":4},"If your extra payments vary, enter them in the table below."]
["Loan period in years"]
["Start date of loan"]
["Optional extra payments"]
[]
[]
["Scheduled monthly payment",null,null,""]
["Scheduled number of payments",null,null,""]
["Actual number of payments",null,null,""]
["Total of early payments",null,null,""]
["Total interest",null,null,""]
[]
["No.","Payment Date","Beginning Balance","Scheduled Payment","Extra Payment","Total Payment","Principal","Interest","Ending Balance"]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]