{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Auto 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":"Auto Loan Amortization Schedule","index":0,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[35,7,36,7],[35,8,36,8],[28,7,28,9],[24,2,24,4],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[29,2,29,3],[26,7,26,8],[24,7,24,8],[87,1,87,9],[10,7,10,8],[9,7,9,8],[19,7,19,8],[20,7,20,8],[13,7,13,8],[14,7,14,8],[16,7,16,8],[12,7,12,8],[11,7,11,8],[26,2,26,3],[25,2,25,3],[25,7,25,8],[27,2,27,3],[34,1,34,9],[28,2,28,3],[2,1,2,2],[3,1,5,2],[3,3,3,4],[2,3,2,4],[3,7,3,8],[2,7,2,8],[5,3,5,4],[4,7,4,8],[5,7,5,8],[4,3,4,4],[8,3,8,4],[8,1,8,2],[6,7,6,8],[7,7,7,8],[6,1,6,2],[7,1,7,2],[7,3,7,4],[6,3,6,4],[10,3,10,4],[10,1,10,2],[11,1,11,2],[17,7,17,8],[15,2,15,3],[23,7,23,8],[18,7,18,8],[9,1,9,2],[9,3,9,4],[13,2,13,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[21,7,21,8],[22,7,22,8],[11,3,11,4]]}
[null,"AUTO LOAN AMORTIZATION SCHEDULE TEMPLATE"]
[]
[null,"LENDER NAME",null,null,null,null,null,"PURCHASE PRICE",null,"VALUE"]
[null,"LENDER ADDRESS",null,null,null,null,null,"SALE PRICE + OPTIONS",null,40000]
[null,null,null,null,null,null,null,"DESTINATION CHARGE",null,35]
[null,null,null,null,null,null,null,"TITLE TRANSFER FEE",null,35]
[null,"LENDER PHONE",null,null,null,null,null,"OTHER TAXABLE FEES",null,600]
[null,"LENDER WEB",null,"www.",null,null,null,"TOTAL PURCHASE PRICE",null,{"$f":"SUM(J4:J7)","v":40670}]
[null,"CONTACT EMAIL"]
[null,"LOAN TYPE",null,null,null,null,null,"STATE SALES TAX",null,"VALUE"]
[null,"DATE OF LOAN",null,null,null,null,null,"TRADE-IN TAX DEDUCTION (if applicable)",null,false]
[null,"NAME ON LOAN",null,null,null,null,null,"CASH REBATE TAX DEDUCTION (if applicable)",null,false]
[null,null,null,null,null,null,null,"INPUT STATE SALES TAX RATE ",null,6.3500000000000001E-2]
[null,null,"DATA",null,"VALUE",null,null,"FILL IN NET TAXABLE",null,{"$f":"4500","v":4500}]
[null,null,"INPUT",null,null,null,"FREQUENCY","STATE SALES / EXCISE TAX",null,{"$f":"J13*J14","v":285.75}]
[null,null,"PURCHASE PRICE + FEES",null,{"$f":"J8+J15+J27","v":41005.75},null,"Annually"]
[null,null,"PERCENT OF DOWN PAYMENT",null,0.05,null,"Semi-Annually","NON-TAXABLE FEES",null,"VALUE"]
[null,null,"TOTAL DOWN PAYMENT",null,{"$f":"E17*E16","v":2050.2874999999999},null,"Quarterly","REGISTRATION",null,10]
[null,null,"LOAN AMOUNT",null,{"$f":"E16-E18","v":38955.462500000001},null,"Bi-Monthly","LATE REGISTRATION FEE",null,5]
[null,null,"ANNUAL INTEREST RATE",null,4.4999999999999998E-2,null,"Monthly","SERVICE CONTRACT",null,5]
[null,null,"LENGTH OF LOAN IN YEARS",null,4,null,"Semi-Monthly","SPECIAL PLATE FEE",null,5]
[null,null,"PAYMENT FREQUENCY",null,"Monthly",null,"Bi-Weekly","ADMINISTRATION FEE",null,5]
[null,null,"FIRST PAYMENT DATE",null,"2018-05-01",null,null,"TRANSACTION FEE",null,5]
[null,null,null,null,null,null,null,"LATE TITLE TRANSFER FEE",null,5]
[null,null,"CALCULATED OUTPUT",null,null,null,null,"DUPLICATE TITLE FEE",null,5]
[null,null,"NUMBER OF PAYMENTS",null,{"$f":"H32","v":48},null,null,"OTHER NON-TAXABLE FEES",null,5]
[null,null,"MONTHLY INTEREST RATE",null,{"$f":"E20/H31","v":3.7499999999999999E-3},null,null,"TOTAL NON-TAXABLE FEES",null,{"$f":"SUM(J18:J26)","v":50}]
[null,null,"MONTHLY PAYMENT",null,{"$f":"ROUND(-PMT(E27,H32,E19),2)","v":888.32}]
[null,null,"TOTAL INTEREST",null,{"$f":"E30-E19","v":3683.9141444149864},null,null,"***Complete All WHITE fields under VALUE Headings Only***"]
[null,null,"TOTAL PAYMENTS",null,{"$f":"E26*(-PMT(E27,H32,E19))","v":42639.376644414988}]
[null,null,null,null,null,null,"PERIODS PER YEAR",{"$f":"INDEX({1;2;4;6;12;24;26},MATCH($E$22,$G$16:$G$22,0))","v":12}]
[null,null,null,null,null,null,"NUMBER OF PERIODS",{"$f":"E21*H31","v":48}]
[null,null,null,null,null,null,"Periods per month",{"$f":"12/H31","v":1}]
[]
[null,"AUTO LOAN AMORTIZATION SCHEDULE"]
[null,"PYMNT PERIOD","DATE OF PAYMENT","BEGINNING BALANCE","SCHEDULED PAYMENT","EXTRA PAYMENT","ADDITIONAL PAYMENT","INTEREST","PRINCIPAL","BALANCE"]
[null,null,null,null,null,null,null,null,null,{"$f":"E19","v":38955.462500000001}]
[null,{"$f":"IF(J37=\"\",\"\",IF(OR(B37>=$H$32,ROUND(J37,2)<=0),\"\",B37+1))","v":1},{"$f":"E23","v":"2018-05-01"},{"$f":"J37","v":38955.462500000001},{"$f":"IF(B38=\"\",\"\",IF(OR(B38=$H$32,$E$28>ROUND((1+$E$27)*J37,2)),ROUND((1+$E$27)*J37,2),$E$28))","v":888.32},null,null,{"$f":"IF(B38=\"\",\"\",ROUND($E$27*J37,2))","v":146.08000000000001},{"$f":"IF(B38=\"\",\"\",E38+F38-H38)","v":742.24},{"$f":"IF(B38=\"\",\"\",J37-I38)","v":38213.222500000003}]
[null,2,{"$f":"IF(B39=\"\",\"\",IF($H$31=26,IF(B39=1,$E$23,C38+14),IF($H$31=52,IF(B39=1,$E$23,C38+7),DATE(YEAR($E$23),MONTH($E$23)+(B39-1)*$H$33,IF($H$31=24,IF((1-MOD(B39,2))=1,DAY($E$23)+14,DAY($E$23)),DAY($E$23))))))","v":"2018-06-01"},{"$f":"IF(ISERROR(IF((ROUND(J38,1)>0),J38,\"\")),\"\",(IF((ROUND(J38,1)>0),J38,\"\")))","v":38213.222500000003},888.32,null,null,143.30000000000001,745.02,37468.202500000007]
[null,3,"2018-07-01",37468.202500000007,888.32,null,null,140.51,747.81000000000006,36720.392500000009]
[null,4,"2018-08-01",36720.392500000009,888.32,null,null,137.69999999999999,750.62000000000012,35969.772500000006]
[null,5,"2018-09-01",35969.772500000006,888.32,null,null,134.88999999999999,753.43000000000006,35216.342500000006]
[null,6,"2018-10-01",35216.342500000006,888.32,null,null,132.06,756.26,34460.082500000004]
[null,7,"2018-11-01",34460.082500000004,888.32,null,null,129.22999999999999,759.09,33700.992500000008]
[null,8,"2018-12-01",33700.992500000008,888.32,null,null,126.38,761.94,32939.052500000005]
[null,9,"2019-01-01",32939.052500000005,888.32,null,null,123.52,764.80000000000007,32174.252500000006]
[null,10,"2019-02-01",32174.252500000006,888.32,null,null,120.65,767.67000000000007,31406.582500000004]
[null,11,"2019-03-01",31406.582500000004,888.32,null,null,117.77,770.55000000000007,30636.032500000005]
[null,12,"2019-04-01",30636.032500000005,888.32,null,null,114.89,773.43000000000006,29862.602500000005]
[null,13,"2019-05-01",29862.602500000005,888.32,null,null,111.98,776.34,29086.262500000004]
[null,14,"2019-06-01",29086.262500000004,888.32,null,null,109.07,779.25,28307.012500000004]
[null,15,"2019-07-01",28307.012500000004,888.32,null,null,106.15,782.17000000000007,27524.842500000006]
[null,16,"2019-08-01",27524.842500000006,888.32,null,null,103.22,785.1,26739.742500000008]
[null,17,"2019-09-01",26739.742500000008,888.32,null,null,100.27,788.05000000000007,25951.692500000008]
[null,18,"2019-10-01",25951.692500000008,888.32,null,null,97.32,791,25160.692500000008]
[null,19,"2019-11-01",25160.692500000008,888.32,null,null,94.35,793.97,24366.722500000007]
[null,20,"2019-12-01",24366.722500000007,888.32,null,null,91.38,796.94,23569.782500000008]
[null,21,"2020-01-01",23569.782500000008,888.32,null,null,88.39,799.93000000000006,22769.852500000008]
[null,22,"2020-02-01",22769.852500000008,888.32,null,null,85.39,802.93000000000006,21966.922500000008]
[null,23,"2020-03-01",21966.922500000008,888.32,null,null,82.38,805.94,21160.982500000009]
[null,24,"2020-04-01",21160.982500000009,888.32,null,null,79.349999999999994,808.97,20352.012500000008]
[null,25,"2020-05-01",20352.012500000008,888.32,null,null,76.319999999999993,812,19540.012500000008]
[null,26,"2020-06-01",19540.012500000008,888.32,null,null,73.28,815.04000000000008,18724.972500000007]
[null,27,"2020-07-01",18724.972500000007,888.32,null,null,70.22,818.1,17906.872500000009]
[null,28,"2020-08-01",17906.872500000009,888.32,null,null,67.150000000000006,821.17000000000007,17085.702500000007]
[null,29,"2020-09-01",17085.702500000007,888.32,null,null,64.069999999999993,824.25,16261.452500000007]
[null,30,"2020-10-01",16261.452500000007,888.32,null,null,60.98,827.34,15434.112500000007]
[null,31,"2020-11-01",15434.112500000007,888.32,null,null,57.88,830.44,14603.672500000006]
[null,32,"2020-12-01",14603.672500000006,888.32,null,null,54.76,833.56000000000006,13770.112500000007]
[null,33,"2021-01-01",13770.112500000007,888.32,null,null,51.64,836.68000000000006,12933.432500000006]
[null,34,"2021-02-01",12933.432500000006,888.32,null,null,48.5,839.82,12093.612500000007]
[null,35,"2021-03-01",12093.612500000007,888.32,null,null,45.35,842.97,11250.642500000007]
[null,36,"2021-04-01",11250.642500000007,888.32,null,null,42.19,846.13000000000011,10404.512500000008]
[null,37,"2021-05-01",10404.512500000008,888.32,null,null,39.020000000000003,849.30000000000007,9555.2125000000087]
[null,38,"2021-06-01",9555.2125000000087,888.32,null,null,35.83,852.49,8702.7225000000089]
[null,39,"2021-07-01",8702.7225000000089,888.32,null,null,32.64,855.68000000000006,7847.0425000000087]
[null,40,"2021-08-01",7847.0425000000087,888.32,null,null,29.43,858.8900000000001,6988.1525000000083]
[null,41,"2021-09-01",6988.1525000000083,888.32,null,null,26.21,862.11,6126.0425000000087]
[null,42,"2021-10-01",6126.0425000000087,888.32,null,null,22.97,865.35,5260.6925000000083]
[null,43,"2021-11-01",5260.6925000000083,888.32,null,null,19.73,868.59,4392.1025000000081]
[null,44,"2021-12-01",4392.1025000000081,888.32,null,null,16.47,871.85,3520.2525000000082]
[null,45,"2022-01-01",3520.2525000000082,888.32,null,null,13.2,875.12,2645.1325000000083]
[null,46,"2022-02-01",2645.1325000000083,888.32,null,null,9.92,878.40000000000009,1766.7325000000083]
[null,47,"2022-03-01",1766.7325000000083,888.32,null,null,6.63,881.69,885.0425000000082]
[null,48,"2022-04-01",885.0425000000082,888.36,null,null,3.32,885.04,2.500000008240022E-3]
[null,"","","","",null,null,"","",""]
[]
[null,"CLICK HERE TO CREATE AUTO LOAN AMORTIZATION SCHEDULE TEMPLATES IN SMARTSHEET",null,null,null,null,null,null,null,null,null,null,null,"`"]