{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Loan Amortization Schedule"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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 Amortization Schedule","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[22,7,23,7],[3,6,3,8],[16,6,16,7],[17,6,17,7],[21,1,21,8],[4,3,4,4],[12,6,12,7],[9,6,9,7],[8,6,8,7],[7,6,7,7],[6,6,6,7],[5,6,5,7],[4,6,4,7],[11,3,11,4],[8,3,8,4],[7,3,7,4],[50,1,50,8],[10,6,10,7],[11,6,11,7],[20,1,20,2],[19,1,19,2],[17,1,17,2],[18,1,18,2],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[14,6,14,7],[15,6,15,7],[13,6,13,7],[6,3,6,4],[5,3,5,4],[2,6,2,7],[11,1,11,2],[7,1,7,2],[6,1,6,2],[9,1,9,2],[10,1,10,2],[3,1,5,2],[2,1,2,2],[8,1,8,2],[10,3,10,4],[9,3,9,4],[2,3,2,4],[3,3,3,4]]}
[null,"LOAN AMORTIZATION SCHEDULE TEMPLATE"]
[]
[null,"LENDER NAME",null,null,null,null,"DATA",null,"VALUE"]
[null,"LENDER ADDRESS",null,null,null,null,"***Complete SHADED Fields Only***"]
[null,null,null,null,null,null,"PURCHASE PRICE",null,10000]
[null,null,null,null,null,null,"PERCENT DOWN PAYMENT",null,7.0000000000000007E-2]
[null,"LENDER PHONE",null,null,null,null,"TOTAL DOWN PAYMENT",null,{"$f":"I6*I5","v":700.00000000000011}]
[null,"LENDER WEB",null,null,null,null,"LOAN AMOUNT",null,{"$f":"I5-I7","v":9300}]
[null,"CONTACT EMAIL",null,null,null,null,"ANNUAL INTEREST RATE",null,4.4999999999999998E-2]
[null,"LOAN TYPE",null,null,null,null,"LENGTH OF LOAN IN YEARS",null,2]
[null,"DATE OF LOAN",null,null,null,null,"PAYMENT FREQUENCY",null,"Monthly"]
[null,"NAME ON LOAN",null,null,null,null,"FIRST PAYMENT DATE",null,"2018-05-01"]
[null,null,null,null,null,"Frequency"]
[null,null,null,null,null,"Annual","MONTHLY INTEREST RATE",null,{"$f":"I9/12","v":3.7499999999999999E-3}]
[null,null,null,null,null,"Semi-Annual","MONTHLY PAYMENT",null,{"$f":"ROUND(-PMT(I14,D20,I8),2)","v":405.92}]
[null,null,null,null,null,"Quarterly","NUMBER OF PAYMENTS",null,{"$f":"D20","v":24}]
[null,null,null,null,null,"Bi-Monthly","INTEREST TOTAL",null,{"$f":"SUM(G25:G49)","v":442.20999999999987}]
[null,"Periods per year",null,{"$f":"INDEX({1;2;4;6;12;24;26;52},MATCH($I$11,$F$14:$F$21,0))","v":12},null,"Monthly","ROUNDING",null,"On"]
[null,"months per period",null,{"$f":"12/$D$18","v":1},null,"Semi-Monthly"]
[null,"number of periods",null,{"$f":"$I$10*$D$18","v":24},null,"Bi-Weekly"]
[null,"Rounding Option",null,{"$f":"(I18=\"On\")","v":true},null,"Weekly"]
[null,"LOAN AMORTIZATION SCHEDULE"]
[null,"PYMT #","DATE OF PAYMENT","BEGINNING BALANCE","SCHEDULED PAYMENT","ADDITIONAL PAYMENT","INTEREST","PRINCIPAL","BALANCE"]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":9300}]
[null,1,{"$f":"I12","v":"2018-05-01"},{"$f":"I8","v":9300},{"$f":"IF(B25=\"\",\"\",IF($D$21,IF(OR(B25=$D$20,$I$15>ROUND((1+$I$14)*I24,2)),ROUND((1+$I$14)*I24,2),$I$15),IF(OR(B25=$D$20,$I$15>(1+$I$14)*I24),(I+$I$14)*I24,$I$15)))","v":405.92},null,{"$f":"IF(B25=\"\",\"\",(IF($D$21,ROUND($I$14*I24,2),$I$14*I24)))","v":34.880000000000003},{"$f":"IF(B25=\"\",\"\",E25-G25+F25)","v":371.04},{"$f":"IF(B25=\"\",\"\",I24-H25)","v":8928.9599999999991}]
[null,{"$f":"IF(I25=\"\",\"\",IF($D$21,IF(OR(B25>=$D$20,ROUND(I25,2)<=0),\"\",B25+1),IF(OR(B25>=$D$20,I25<=0),\"\",B25+1)))","v":2},{"$f":"IF(B26=\"\",\"\",IF($D$18=26,IF(B26=1,$I$12,C25+14),IF($D$18=52,IF(B26=1,$I$12,C25+7),IF($D$18=24,IF(B26=1,$I$12,IF($I$12=EOMONTH($I$12,0),IF(ISODD(B26),EOMONTH(EDATE($I$12,(B26-1)/2),0),EDATE(DATE(YEAR($I$12),MONTH($I$12)+1,15),(B26-1)/2)),IF(DAY($I$12)=15,IF(ISODD(B26),EDATE($I$12,(B26-1)/2),EOMONTH(EDATE($I$12,(B26-1)/2),0)),IF(DAY($I$12)<=14,IF(ISODD(B26),EDATE($I$12,(B26-1)/2),EDATE(MIN($I$12+15,EOMONTH($I$12,0)),(B26-1)/2)),EDATE(IF(ISODD(B26),$I$12,$I$12-15),B26/2))))),IF(B26=1,$I$12,EDATE($I$12,$D$19*(B26-1)))))))","v":"2018-06-01"},{"$f":"IF(ISERROR(IF((ROUND(I25,1)>0),I25,\"\")),\"\",(IF((ROUND(I25,1)>0),I25,\"\")))","v":8928.9599999999991},405.92,null,33.479999999999997,372.44,8556.5199999999986]
[null,3,"2018-07-01",8556.5199999999986,405.92,null,32.090000000000003,373.83000000000004,8182.6899999999987]
[null,4,"2018-08-01",8182.6899999999987,405.92,null,30.69,375.23,7807.4599999999991]
[null,5,"2018-09-01",7807.4599999999991,405.92,null,29.28,376.64,7430.8199999999988]
[null,6,"2018-10-01",7430.8199999999988,405.92,null,27.87,378.05,7052.7699999999986]
[null,7,"2018-11-01",7052.7699999999986,405.92,null,26.45,379.47,6673.2999999999984]
[null,8,"2018-12-01",6673.2999999999984,405.92,null,25.02,380.90000000000003,6292.3999999999987]
[null,9,"2019-01-01",6292.3999999999987,405.92,null,23.6,382.32,5910.079999999999]
[null,10,"2019-02-01",5910.079999999999,405.92,null,22.16,383.76,5526.3199999999988]
[null,11,"2019-03-01",5526.3199999999988,405.92,null,20.72,385.20000000000005,5141.119999999999]
[null,12,"2019-04-01",5141.119999999999,405.92,null,19.28,386.64,4754.4799999999987]
[null,13,"2019-05-01",4754.4799999999987,405.92,null,17.829999999999998,388.09000000000003,4366.3899999999985]
[null,14,"2019-06-01",4366.3899999999985,405.92,null,16.37,389.55,3976.8399999999983]
[null,15,"2019-07-01",3976.8399999999983,405.92,null,14.91,391.01,3585.8299999999981]
[null,16,"2019-08-01",3585.8299999999981,405.92,null,13.45,392.47,3193.3599999999979]
[null,17,"2019-09-01",3193.3599999999979,405.92,null,11.98,393.94,2799.4199999999978]
[null,18,"2019-10-01",2799.4199999999978,405.92,null,10.5,395.42,2403.9999999999977]
[null,19,"2019-11-01",2403.9999999999977,405.92,null,9.01,396.91,2007.0899999999976]
[null,20,"2019-12-01",2007.0899999999976,405.92,null,7.53,398.39000000000004,1608.6999999999975]
[null,21,"2020-01-01",1608.6999999999975,405.92,null,6.03,399.89000000000004,1208.8099999999974]
[null,22,"2020-02-01",1208.8099999999974,405.92,null,4.53,401.39000000000004,807.41999999999734]
[null,23,"2020-03-01",807.41999999999734,405.92,null,3.03,402.89000000000004,404.5299999999973]
[null,24,"2020-04-01",404.5299999999973,406.05,null,1.52,404.53000000000003,-2.7284841053187847E-12]
[null,"","","","",null,"","",""]
[]
[null,"CLICK HERE TO CREATE LOAN AMORTIZATION SCHEDULE TEMPLATES IN SMARTSHEET"]