{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Standard Calculator"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Standard Calculator","index":0,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Finance Scheme","12 Months ","18 Months ","24 Months ","36 Months ","48 Months "]
["Key in the total value including GST",100000.0,{"$f":"B2","v":100000},100000,100000,100000]
["Down Payment %",0.2,0.2,0.2,0.2,0.2]
["Down Payment to Caple",{"$f":"B2*B3","v":20000},20000,20000,20000,20000]
["Loan Amount ",{"$f":"B2-B4","v":80000},80000,80000,80000,80000]
["SD, Insurance & Processing Fees % on the loan amount",0.02,0.02,0.02,0.02,0.02]
["Interest to the customer",0.0999,0.1099,0.0999,0.1099,0.1199]
["Factor of EMI on the loan amount",{"$f":"(7033*B2)/100000","v":7033},{"$f":"(4841*C2)/100000","v":4841},{"$f":"(3691*D2)/100000","v":3691},{"$f":"(2618*E2)/100000","v":2618},{"$f":"(2106*F2)/100000","v":2106}]
["Timeline for approval","2 Weeks","2 Weeks","2 Weeks","2 Weeks","2 Weeks"]
[]
["Cashflow"]
["Down Payment",{"$f":"B2*B3","v":20000},20000,20000,20000,20000]
["Processing Fees including Insurance on the loan amount ",{"$f":"B5*B6","v":1600},1600,1600,1600,1600]
[1.0,{"$f":"B8","v":7033},4841,3691,2618,2106]
[2.0,{"$f":"B14","v":7033},4841,3691,2618,2106]
[3.0,{"$f":"B15","v":7033},4841,3691,2618,2106]
[4.0,{"$f":"B16","v":7033},4841,3691,2618,2106]
[5.0,{"$f":"B17","v":7033},4841,3691,2618,2106]
[6.0,{"$f":"B18","v":7033},4841,3691,2618,2106]
[7.0,{"$f":"B19","v":7033},4841,3691,2618,2106]
[8.0,{"$f":"B20","v":7033},4841,3691,2618,2106]
[9.0,{"$f":"B21","v":7033},4841,3691,2618,2106]
[10.0,{"$f":"B22","v":7033},4841,3691,2618,2106]
[11.0,{"$f":"B23","v":7033},4841,3691,2618,2106]
[12.0,{"$f":"B24","v":7033},4841,3691,2618,2106]
[13.0,null,{"$f":"C25","v":4841},3691,2618,2106]
[14.0,null,{"$f":"C26","v":4841},3691,2618,2106]
[15.0,null,{"$f":"C27","v":4841},3691,2618,2106]
[16.0,null,{"$f":"C28","v":4841},3691,2618,2106]
[17.0,null,{"$f":"C29","v":4841},3691,2618,2106]
[18.0,null,{"$f":"C30","v":4841},3691,2618,2106]
[19.0,null,null,{"$f":"D31","v":3691},2618,2106]
[20.0,null,null,{"$f":"D32","v":3691},2618,2106]
[21.0,null,null,{"$f":"D33","v":3691},2618,2106]
[22.0,null,null,{"$f":"D34","v":3691},2618,2106]
[23.0,null,null,{"$f":"D35","v":3691},2618,2106]
[24.0,null,null,{"$f":"D36","v":3691},2618,2106]
[25.0,null,null,null,{"$f":"E37","v":2618},2106]
[26.0,null,null,null,{"$f":"E38","v":2618},2106]
[27.0,null,null,null,{"$f":"E39","v":2618},2106]
[28.0,null,null,null,{"$f":"E40","v":2618},2106]
[29.0,null,null,null,{"$f":"E41","v":2618},2106]
[30.0,null,null,null,{"$f":"E42","v":2618},2106]
[31.0,null,null,null,{"$f":"E43","v":2618},2106]
[32.0,null,null,null,{"$f":"E44","v":2618},2106]
[33.0,null,null,null,{"$f":"E45","v":2618},2106]
[34.0,null,null,null,{"$f":"E46","v":2618},2106]
[35.0,null,null,null,{"$f":"E47","v":2618},2106]
[36.0,null,null,null,{"$f":"E48","v":2618},2106]
[37.0,{"$nulls":4},{"$f":"F49","v":2106}]
[38.0,{"$nulls":4},2106]
[39.0,{"$nulls":4},2106]
[40.0,{"$nulls":4},2106]
[41.0,{"$nulls":4},2106]
[42.0,{"$nulls":4},2106]
[43.0,{"$nulls":4},2106]
[44.0,{"$nulls":4},2106]
[45.0,{"$nulls":4},2106]
[46.0,{"$nulls":4},2106]
[47.0,{"$nulls":4},2106]
[48.0,{"$nulls":4},2106]
["Total",{"$f":"sum(B12:B61)","v":105996},108738,110184,115848,122688]