{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ingresar datos","Cotización (imprimir)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Ingresar datos","index":0,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,4,6,7],[11,7,11,24],[21,10,21,11]]}
[]
[]
[]
[]
[null,null,"SIMULADOR LEASING"]
[]
[null,null,null,"Fecha:",{"$f":"TODAY()","v":"2016-12-07"}]
[]
[]
[null,null,null,"DATOS DEL CLIENTE:"]
[]
[null,null,"Razon Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si tiene sólo el Valor de Venta complételo acá"]
[]
[null,null,null,"DATOS DEL LEASING:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si el Valor de Venta es"]
[]
[null,null,"Bien a financiar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El precio de venta incluido IGV es",null,{"$f":"+AD14*1.18","v":0}]
[]
[null,null,"Tasa Efectiva Anual",null,null,{"$f":"IF(M20=\"US$ Dólares Americanos\",\"(ME):\",\"(MN):\")","v":"(ME):"},null,null,null,null,null,null,null,null,null,"referencial"]
[]
[null,null,"Moneda de la Operación:",null,null,null,null,null,null,null,null,null,"US$ Dólares Americanos"]
[]
[null,null,"Precio de Venta del bien (incuido el IGV): "]
[]
[null,null,"Cuota Inicial: ",null,null,null,null,null,null,null,null,null,null,null,null,"mínimo 20%"]
[]
[null,null,"Plazo en meses:",null,null,null,null,null,null,null,null,null,null,null,null,"Ingresar valores entre 24 y 60"]
[]
[null,null,"Comisión por estructuración:",null,null,null,null,null,null,null,null,null,null,null,null,"mínimo US$500 o S/1,500"]
[]
[null,null,"Opción de Compra (OC):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Column1","Column2"]
[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,1,"US$ Dólares Americanos"]
[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,2,"S/ Soles"]

{"sheet":"Cotización (imprimir)","index":1,"n_rows":88,"n_cols":28,"rows_kept":88,"cut":false,"hidden":false,"merged":[[4,2,4,9],[11,4,11,9],[5,2,5,9],[86,2,86,9],[23,2,23,3],[22,2,22,3]]}
[]
[]
[]
[]
[null,null,"CRONOGRAMA DE PAGOS"]
[null,null,"REFERENCIAL"]
[null,null,null,null,null,null,null,null,"Fecha:",{"$f":"TODAY()","v":"2016-12-07"}]
[]
[]
[null,null,"DATOS DEL CLIENTE:"]
[]
[null,null,"Razon Social:",null,{"$f":"+'Ingresar datos'!H12","v":0}]
[]
[null,null,"DATOS DEL LEASING:"]
[]
[null,null,"Bien a financiar:",null,{"$f":"+'Ingresar datos'!M16","v":0},null,null,null,"Tasa Efectiva Anual:",{"$f":"+'Ingresar datos'!M18","v":0}]
[null,null,"Moneda:",null,{"$f":"'Ingresar datos'!M20","v":"US$ Dólares Americanos"},null,"Cuota inicial"]
[null,null,"Valor de Venta:",null,{"$f":"ROUND(E20/1.18,2)","v":0},"Valor de Venta:",{"$f":"+ROUND(E18*'Ingresar datos'!M24,2)","v":0},null,"Comisión de Estructuración (*):",{"$f":"IF(E17='Ingresar datos'!AE46,IF('Ingresar datos'!M28*'Ingresar datos'!M22<500,500,'Ingresar datos'!M28*'Ingresar datos'!M22),IF('Ingresar datos'!M28*'Ingresar datos'!M22<1500,1500,'Ingresar datos'!M28*'Ingresar datos'!M22))","v":500}]
[null,null,"IGV:",null,{"$f":"+E20-E18","v":0},"IGV:",{"$f":"ROUND(G18*0.18,2)","v":0},null,"Opción de Compra (*):",{"$f":"+'Ingresar datos'!M30*'Ingresar datos'!M22","v":0}]
[null,null,"Precio de Venta:",null,{"$f":"+'Ingresar datos'!M22","v":0},"Precio de Venta:",{"$f":"+G18+G19","v":0}]
[null,null,"Plazo:",null,{"$f":"'Ingresar datos'!M26","v":0},"meses",null,null,"Tasa costo efectivo Anual:",{"$f":"+(1+AB21)^12-1","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IRR(AB24:AB84,0.01)","v":{"$error":"#NUM!"}}]
[]
[null,null,"Nro.",null,"Amortización","Interés","Cuota","IGV","Total Cuota","Saldo Final"]
[null,null,"CI",null,{"$f":"+G18","v":0},0,{"$f":"+E24+F24","v":0},{"$f":"+G24*0.18","v":0},{"$f":"IF(G24+H24=0,\"\",G24+H24)","v":""},{"$f":"+E18-E24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-E18+G24+J18","v":500}]
[null,null,{"$f":"IF(AA25>$E$21,0,AA25)","v":0},null,{"$f":"+ROUND(IF(AA25>$E$21,0,G25-F25),2)","v":0},{"$f":"+ROUND(IF(AA25>$E$21,0,J24*((1+$J$16)^(0.0833333333333333)-1)),2)","v":0},{"$f":"ROUND(IF(AA25>$E$21,0,PMT((1+$J$16)^(1/12)-1,$E$21,-$J$24)),2)","v":0},{"$f":"+ROUND(IF(AA25>$E$21,0,G25*0.18),2)","v":0},{"$f":"+G25+H25","v":0},{"$f":"+ROUND(IF(AA25>$E$21,0,J24-E25),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(C25>$E$21,0,IF(C25=$E$21,G25+$J$19,G25))","v":0}]
[null,null,{"$f":"IF(AA26>$E$21,0,AA26)","v":0},null,{"$f":"+ROUND(IF(AA26>$E$21,0,G26-F26),2)","v":0},{"$f":"+ROUND(IF(AA26>$E$21,0,J25*((1+$J$16)^(0.0833333333333333)-1)),2)","v":0},{"$f":"ROUND(IF(AA26>$E$21,0,PMT((1+$J$16)^(1/12)-1,$E$21,-$J$24)),2)","v":0},{"$f":"+ROUND(IF(AA26>$E$21,0,G26*0.18),2)","v":0},{"$f":"+G26+H26","v":0},{"$f":"+ROUND(IF(AA26>$E$21,0,J25-E26),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(C26>$E$21,0,IF(C26=$E$21,G26+$J$19,G26))","v":0}]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0]
[null,null,0,null,0,0,0,0,{"$f":"+G33+H33","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0]
[null,null,0,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0]
[]
[null,null,"CONDICIONES:"]
[null,null,"Cronograma preliminar, sujeto a aprobación. No representa compromiso, obligación o contrato por parte de Banco GNB Perú  La cuota total no incluye ITF. Consulte nuestro tarifario Web al momento de realizar la simulación. El cronograma definitivo será entregado en un plazo no mayor a 30 días posteriores a la fecha de desembolso del crédito y formará parte integrante del contrato respectivo."]
[null,null,"(*) Los valores señalados no incluyen IGV"]