{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Loan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"1900"}

{"sheet":"Loan","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["LOAN AMORTIZATION SCHEDULE"]
["Principal Amount",1000]
["Interest Rate (Annual %)",15]
["Loan Term (in years)",1]
["Loan Term (in months)",{"$f":"IF(B4>0,B4*12,\"\")","v":12}]
["Monthly Payment",{"$f":"IF(B4>0,-PMT(B3/1200,B4*12,B2,0),\"\")","v":90.258312345156952},"Interest","Principal"]
["Month / Period","Payment","Expense"," Remaining"]
[{"$f":"IF(B4>0,0,\"\")","v":0},{"$f":"IF(B4>0,0,\"\")","v":0},{"$f":"IF(B4>0,0,\"\")","v":0},{"$f":"IF(B4>0,B2,\"\")","v":1000}]
[{"$f":"1+A8","v":1},{"$f":"$B$6","v":90.258312345156952},{"$f":"$B$3/1200*D8","v":12.5},{"$f":"D8-B9+C9","v":922.24168765484308}]
[2,90.258312345156952,11.528021095685538,843.51139640537167]
[3,90.258312345156952,10.543892455067146,763.79697651528193]
[4,90.258312345156952,9.5474622064410237,683.08612637656597]
[5,90.258312345156952,8.5385765797070743,601.36639061111612]
[6,90.258312345156952,7.517079882638952,518.62515814859819]
[7,90.258312345156952,6.4828144768574774,434.84966028029874]
[8,90.258312345156952,5.4356207535037342,350.02696868864552]
[9,90.258312345156952,4.3753371086080692,264.14399345209665]
[10,90.258312345156952,3.3017999181512083,177.1874810250909]
[11,90.258312345156952,2.2148435128136366,89.144012192747581]
[12,90.258312345156952,1.1143001524093448,-2.5757174171303632E-14]