{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Loan Calculator"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"1904","formulas":"cached_only"}

{"sheet":"Loan Calculator","index":0,"n_rows":375,"n_cols":9,"rows_kept":375,"cut":false,"hidden":false,"merged":[[5,5,5,6],[1,1,1,8],[9,5,9,6],[3,2,12,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[3,5,3,6],[4,5,4,6]],"flags":["formulas_cached_only"]}
[null,null,null,null,null,null,null,null,""]
[null,"Loan Calculator"]
[]
[null,null,"This worksheet can help you calculate loan costs. Enter values into the yellow boxes, replacing the sample data. Results will be shown in the green boxes.\n\nThis worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password.\u0000\u0000",null,null,"Loan  Amount:",null,0]
[null,null,null,null,null,"Annual Interest Rate:",null,0]
[]
[null,null,null,null,null,"Length of Loan (in Years):",null,0]
[null,null,null,null,null,"Number of Payments Per Year:",null,0]
[null,null,null,null,null,"Total Number of Periods:",null,0]
[]
[null,null,null,null,null,"Payment Per Period:",null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total Interest Paid:",null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total Payments:",null,{"$error":"#DIV/0!"}]
[]
[null,null,"Period","Payment","Principal","Interest","Total Interest Paid","New Payoff Amount"]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]