{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Mortgage Amortization","Variables"],"not_rendered":{"external_links":1,"defined_names":14},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Mortgage Amortization","index":0,"n_rows":234,"n_cols":17,"rows_kept":234,"merged":[[2,1,2,4],[2,6,2,9],[3,1,3,3],[3,6,3,8],[4,1,4,3],[4,6,4,8],[5,1,5,3],[5,6,5,8],[6,1,6,3],[6,6,6,8],[7,1,7,3],[7,6,7,8],[9,1,9,9],[24,1,24,8]],"flags":["formulas_cached_only"]}
[null,"Mortgage Amortization"]
[]
[null,"Inputs",{"$nulls":4},"Key Figures"]
[null,"Loan principal amount",{"$nulls":4},"Annual loan payments",null,null,""]
[null,"Annual interest rate",{"$nulls":4},"Monthly payments",null,null,""]
[null,"Loan period in years",{"$nulls":4},"Interest in first calendar year",null,null,""]
[null,"Base year of loan",{"$nulls":4},"Interest over term of loan",null,null,""]
[null,"Base month of loan",{"$nulls":4},"Sum of all payments",null,null,""]
[]
[null,"Payments in First 12 Months"]
[null,"Year","Month","Beginning Balance","Payment ","Principal ","Interest ","Cumulative Principal","Cumulative Interest","Ending Balance"]
[null,0,"Jan","","","","","","",""]
[null,"","Feb","","","","","","",""]
[null,"","Mar","","","","","","",""]
[null,"","Apr","","","","","","",""]
[null,"","May","","","","","","",""]
[null,"","Jun","","","","","","",""]
[null,"","Jul","","","","","","",""]
[null,"","Aug","","","","","","",""]
[null,"","Sep","","","","","","",""]
[null,"","Oct","","","","","","",""]
[null,"","Nov","","","","","","",""]
[null,"","Dec","","","","","","",""]
[]
[null,"Yearly Schedule of Balances and Payments"]
[null,"Year","Beginning Balance","Payment","Principal","Interest","Cumulative Principal","Cumulative Interest","Ending Balance"]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
{"$rows_empty":133}
[{"$nulls":12},"DO NOT ERASE"]
[]
[{"$nulls":12},{"v":1,"d":"1.00"},"Jan",{"v":1,"d":"1.00"},null,"Jan"]
[{"$nulls":12},{"v":2,"d":"2.00"},"Feb",{"v":2,"d":"2.00"},null,"Feb"]
[{"$nulls":12},{"v":3,"d":"3.00"},"Mar",{"v":3,"d":"3.00"},null,"Mar"]
[{"$nulls":12},{"v":4,"d":"4.00"},"Apr",{"v":4,"d":"4.00"},null,"Apr"]
[{"$nulls":12},{"v":5,"d":"5.00"},"May",{"v":5,"d":"5.00"},null,"May"]
[{"$nulls":12},{"v":6,"d":"6.00"},"Jun",{"v":6,"d":"6.00"},null,"Jun"]
[{"$nulls":12},{"v":7,"d":"7.00"},"Jul",{"v":7,"d":"7.00"},null,"Jul"]
[{"$nulls":12},{"v":8,"d":"8.00"},"Aug",{"v":8,"d":"8.00"},null,"Aug"]
[{"$nulls":12},{"v":9,"d":"9.00"},"Sep",{"v":9,"d":"9.00"},null,"Sep"]
[{"$nulls":12},{"v":10,"d":"10.00"},"Oct",{"v":10,"d":"10.00"},null,"Oct"]
[{"$nulls":12},{"v":11,"d":"11.00"},"Nov",{"v":11,"d":"11.00"},null,"Nov"]
[{"$nulls":12},{"v":12,"d":"12.00"},"Dec",{"v":12,"d":"12.00"},null,"Dec"]
[]
[{"$nulls":12},24,{"v":-24,"d":"(24.00)"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Months",{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Base Year",0]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Years",{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Last Year",""]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Mos in Last Yr",{"v":12,"d":"12.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"Variables","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true,"flags":["formulas_cached_only"]}
["_Example",false]
["_Shading",false]
["_Series","OfficeReady 3.0"]
["_Look",{"v":1,"d":"1 "}]