{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Get Started","Simple Loan Tool"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1900"}

{"sheet":"Get Started","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Simple Loan Tool","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,3,11,4],[11,5,11,6],[5,3,5,4],[5,5,5,6],[7,5,7,6],[7,3,7,4],[9,1,9,2],[9,3,9,4],[9,5,9,6],[10,5,10,6],[10,3,10,4],[10,1,10,2],[4,1,4,5],[8,1,8,5],[0,0,1,6],[2,0,3,0],[2,1,3,1],[5,1,5,2],[7,1,7,2]]}
["Simple Loan Tool"]
[]
["Loan Amount:",100000]
[]
[null,"Loan Scenarios"]
["Loan Period in Years",10,null,10,null,10,null,null,"Monthly",12]
["Payment Frequency","Monthly",{"$f":"VLOOKUP(B7,Table2[#All],2,)","v":12},"Monthly",{"$f":"VLOOKUP(D7,Table2[#All],2,)","v":12},"Monthly",{"$f":"VLOOKUP(F7,Table2[#All],2,)","v":12},null,"Weekly",52]
["Annual Interest Rate",0.05,null,6.5000000000000002E-2,null,7.2499999999999995E-2,null,null,"Bi-weekly",26]
[]
["Scheduled Payment",{"$f":"IFERROR(PMT(B8/12,B6*C7,$B$3)*-1,\"\")","v":1060.6551523907524},null,{"$f":"IFERROR(PMT(D8/12,D6*E7,$B$3)*-1,\"\")","v":1135.4797722002602},null,{"$f":"IFERROR(PMT(F8/12,F6*G7,$B$3)*-1,\"\")","v":1174.0104115708261}]
["Total Interest",{"$f":"IFERROR(CUMIPMT(B8/12,B6*C7,$B$3,1,B6*C7,0)*-1,\"\")","v":27278.618286890283},null,{"$f":"IFERROR(CUMIPMT(D8/12,D6*E7,$B$3,1,D6*E7,0)*-1,\"\")","v":36257.572664031235},null,{"$f":"IFERROR(CUMIPMT(F8/12,F6*G7,$B$3,1,F6*G7,0)*-1,\"\")","v":40881.249388499113}]
["Total Cost of Loan",{"$f":"IFERROR($B$3+B11,\"\")","v":127278.61828689028},null,{"$f":"IFERROR($B$3+D11,\"\")","v":136257.57266403124},null,{"$f":"IFERROR($B$3+F11,\"\")","v":140881.24938849913}]