{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Balloon Loan Amortization Sched"],"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":"Balloon Loan Amortization Sched","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[11,1,11,2],[11,3,11,4],[7,3,7,4],[14,6,14,8],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[21,7,21,8],[19,1,19,8],[50,7,50,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[38,7,38,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[2,3,2,4],[3,1,5,2],[2,1,2,2],[5,6,5,7],[4,6,4,7],[2,6,2,7],[3,6,3,8],[3,3,3,4],[52,1,52,8],[9,1,9,2],[8,1,8,2],[8,3,8,4],[10,3,10,4],[10,1,10,2],[16,6,16,7],[17,6,17,7],[18,6,18,7],[15,6,15,7],[8,6,8,7],[9,6,9,7],[9,3,9,4],[20,7,20,8],[12,6,12,7],[22,7,22,8],[6,6,6,7],[11,6,11,7],[10,6,10,7],[13,6,13,8],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,6,7,7]]}
[null,"BALLOON LOAN AMORTIZATION SCHEDULE"]
[]
[null,"LENDER NAME",null,null,null,null,"DATA",null,"VALUE"]
[null,"LENDER ADDRESS",null,null,null,null,"INPUT"]
[null,null,null,null,null,null,"PURCHASE PRICE",null,100000]
[null,null,null,null,null,null,"PERCENT OF DOWN PAYMENT",null,0.2]
[null,"LENDER PHONE",null,null,null,null,"TOTAL DOWN PAYMENT",null,{"$f":"I6*I5","v":20000}]
[null,"LENDER WEB",null,"www.",null,null,"LOAN AMOUNT",null,{"$f":"I5-I7","v":80000}]
[null,"CONTACT EMAIL",null,null,null,null,"ANNUAL INTEREST RATE",null,4.4999999999999998E-2]
[null,"LOAN TYPE",null,null,null,null,"AMORTIZATION PERIOD",null,20]
[null,"DATE OF LOAN",null,null,null,null,"NUMBER OF PAYMENTS",null,10]
[null,"NAME ON LOAN",null,null,null,null,"INTEREST ONLY",null,"NO"]
[null,null,null,null,null,null,"FIRST PAYMENT DATE",null,"2018-05-01",{"$f":"($I$12=\"yes\")","v":false}]
[null,null,null,null,null,null,"*** Complete WHITE fields above only ***"]
[null,null,null,null,null,null,"CALCULATED OUTPUT"]
[null,null,null,null,null,null,"MONTHLY PAYMENT",null,{"$f":"IF(J13,ROUND(I9/12*I8,2),ROUND(PMT(I9/12,I10,-I8),2))","v":4159.37}]
[null,null,null,null,null,null,"BALLOON PAYMENT",null,{"$f":"OFFSET(E21,I11+1,0,1,1)","v":44907.85000000002}]
[null,null,null,null,null,null,"TOTAL AMOUNT PAID",null,{"$f":"SUM(OFFSET(E21,2,0,I11,1))","v":82342.180000000022}]
[null,null,null,null,null,null,"INTEREST TOTAL",null,{"$f":"I18-I8","v":2342.1800000000221}]
[null,"BALLOON LOAN AMORTIZATION SCHEDULE"]
[null,"PYMNT PERIOD","DATE OF PAYMENT","BEGINNING BALANCE","SCHEDULED PAYMENT","INTEREST","PRINCIPAL","BALANCE"]
[null,null,null,null,null,null,null,{"$f":"I8","v":80000}]
[null,1,{"$f":"$I$13","v":"2018-05-01"},{"$f":"H22","v":80000},{"$f":"IF(B23=\"\",\"\",IF(B23=$I$11,I8+F23,$I$16))","v":4159.37},{"$f":"IF(B23=\"\",\"\",ROUND($I$9/12*H22,2))","v":300},{"$f":"IF(B23=\"\",\"\",E23-F23)","v":3859.37},{"$f":"IF(B23=\"\",\"\",H22-G23)","v":76140.63}]
[null,{"$f":"IF(B23>=$I$11,\"\",B23+1)","v":2},{"$f":"IF(B24=\"\",\"\",DATE(YEAR(C23),MONTH(C23)+1,DAY(C23)))","v":"2018-06-01"},{"$f":"IF(ISERROR(IF((ROUND(H23,1)>0),H23,\"\")),\"\",(IF((ROUND(H23,1)>0),H23,\"\")))","v":76140.63},{"$f":"IF(B24=\"\",\"\",IF(B24=$I$11,H23+F24,$I$16))","v":4159.37},{"$f":"IF(B24=\"\",\"\",ROUND($I$9/12*H23,2))","v":285.52999999999997},3873.84,null,{"$f":"IF(B24=\"\",\"\",H23-G24)","v":72266.790000000008}]
[null,3,"2018-07-01",{"$f":"IF(ISERROR(IF((ROUND(I24,1)>0),I24,\"\")),\"\",(IF((ROUND(I24,1)>0),I24,\"\")))","v":72266.790000000008},{"$f":"IF(B25=\"\",\"\",IF(B25=$I$11,I24+F25,$I$16))","v":4159.37},{"$f":"IF(B25=\"\",\"\",ROUND($I$9/12*I24,2))","v":271},3888.37,null,{"$f":"IF(B25=\"\",\"\",I24-G25)","v":68378.420000000013}]
[null,4,"2018-08-01",68378.420000000013,4159.37,256.42,3902.95,null,64475.470000000016]
[null,5,"2018-09-01",64475.470000000016,4159.37,241.78,3917.5899999999997,null,60557.880000000019]
[null,6,"2018-10-01",60557.880000000019,4159.37,227.09,3932.2799999999997,null,56625.60000000002]
[null,7,"2018-11-01",56625.60000000002,4159.37,212.35,3947.02,null,52678.580000000024]
[null,8,"2018-12-01",52678.580000000024,4159.37,197.54,3961.83,null,48716.750000000022]
[null,9,"2019-01-01",48716.750000000022,4159.37,182.69,3976.68,null,44740.070000000022]
[null,10,"2019-02-01",44740.070000000022,44907.85000000002,167.78,44740.070000000022,null,0]
[null,"","","","","","",null,""]
[null,"","","","","","",null,""]
[null,"","","",{"$f":"IF(B35=\"\",\"\",IF(B35=$I$11,I34+F37,$I$16))","v":""},"","",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,"","","",{"$f":"IF(B50=\"\",\"\",IF(B50=$I$11,I49+G52,$I$16))","v":""},"","",null,""]
[null,"","","",{"$f":"IF(B51=\"\",\"\",IF(B51=$I$11,I50+G53,$I$16))","v":""},"","",null,""]
[]
[null,"CLICK HERE TO CREATE BALLOON LOAN AMORTIZATION SCHEDULE TEMPLATES IN SMARTSHEET"]