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

{"sheet":"Loan Amortization Schedule","index":0,"n_rows":11,"n_cols":11,"rows_kept":11,"merged":[[1,1,1,10],[3,1,3,3],[3,5,3,7],[4,1,4,3],[4,5,4,7],[5,1,5,3],[5,5,5,7],[6,1,6,3],[6,5,6,7],[7,1,7,3],[7,5,7,7],[8,1,8,3]]}
[]
[null,"Loan Amortization Schedule"]
[]
[null,"Loan amount:",null,null,{"v":19900,"d":"$ 19,900.00"},"First scheduled payment:",null,null,{"$f":"PMT(Interest_Rate_Per_Month,Scheduled_Number_Payments,-Loan_Amount)","v":{"v":877.5035575469184,"d":"$ 877.50"}}]
[null,"Annual interest rate:",null,null,{"v":0.055,"d":"5.50%"},"Scheduled number of payments:",null,null,{"$f":"Loan_Years*Number_of_Payments_Per_Year","v":24}]
[null,"Loan period in years:",null,null,2,"Actual number of payments:",null,null,{"$f":"ROUNDUP(Actual_Number_Payments,0)","v":20}]
[null,"Number of payments per year:",null,null,12,"Total early payments:",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"Start date of loan:",null,null,"2017-12-25T18:17:23.413","Total interest:",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"Optional extra payments:",null,null,{"v":200,"d":"$ 200.00"}]
[]
[null,"No.","Payment Date","Beginning Balance","Scheduled Payment","Extra Payment","Total Payment","Principal","Interest","Ending Balance","Cumulative Interest"]