{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Configuracion","Datos","Cronograma"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":26,"comments":1,"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":"Configuracion","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,4,2,7]]}
[]
[]
[null,"Moneda",null,null,"Importe Seguro de Desempleo",null,null,null,null,null,"Período de gracia"]
[1,"Soles",null,null,"Moneda","Meses(desde)","Meses(hasta)","Importe",null,0,0]
[2,"Dólares",null,null,1,1,6,73,null,1,1]
[null,null,null,null,1,7,9,110,null,2,2]
[null,"Cuotas",null,null,1,10,12,145]
[1,"Ordinarias",null,null,1,13,18,185]
[2,"Extraordinarias",null,null,1,19,24,252,null,null,"Plazo"]
[null,null,null,null,1,25,36,369,null,0,6]
[null,"Mes siguiente",null,null,1,37,48,454,null,1,12]
[1,"SI",null,null,1,49,999,577,null,2,18]
[2,"NO",null,null,2,1,6,34,null,3,24]
[null,null,null,null,2,7,9,51,null,4,36]
[null,"Día Vencimiento",null,null,2,10,12,68,null,5,48]
[1,2,null,null,2,13,18,88,null,6,60]
[2,17,null,null,2,19,24,120]
[null,null,null,null,2,25,36,176]
[null,"Seguro de Protección de Créditos",null,null,2,37,48,186]
[1,"SI",null,null,2,49,999,236]
[2,"NO"]
[null,null,null,null,"Comisión Informe"]
[null,"Comisión de informe",null,null,"Soles",10]
[1,"SI",null,null,"Dólares",3.5]
[2,"NO"]
[]
[null,"Seguro Desgravamen"]
[1,"INDIVIDUAL",7.5000000000000002E-4]
[2,"ENDOSADO",0]
[]
[]
[]
[]
[]
[]
[1,"Enero"]
[{"$f":"+A36+1","v":2},"Febrero"]
[{"$f":"+A37+1","v":3},"Marzo"]
[4,"Abril"]
[5,"Mayo"]
[6,"Junio"]
[7,"Julio"]
[8,"Agosto"]
[9,"Septiembre"]
[10,"Octubre"]
[11,"Noviembre"]
[12,"Diciembre"]
[13,"Enero"]
[{"$f":"+A48+1","v":14},"Febrero"]
[15,"Marzo"]
[16,"Abril"]
[17,"Mayo"]
[18,"Junio"]
[19,"Julio"]
[20,"Agosto"]
[21,"Septiembre"]
[22,"Octubre"]
[23,"Noviembre"]
[24,"Diciembre"]

{"sheet":"Datos","index":1,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,1,4,3],[8,2,8,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-31"]
[]
["Simulador de Préstamo Personal"]
[]
[]
[null,"Moneda del Préstamo",null,1,null,null,null,null,null,{"$f":"IF(FEC_DES<J18,1,0)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Monto Desembolso",{"$f":"C12+C23","v":5577}]
[null,null,null,null,null,{"$f":"IF(C12>20000, \"Si el cliente tiene correo\", \"\")","v":""}]
[null,"¿Qué importe desea solicitar?",5000,null,null,{"$f":"IF(C12>20000, \"OFRECE PAPERLESS\", \"\")","v":""},null,null,null,null,"TED","TEM"]
[null,"¿En cuantos meses desea pagar?",60,null,null,null,null,null,null,"TEA",{"$f":"(1+C15)^(1/360)-1","v":5.0634542733418719E-4},{"$f":"(1+C15)^(1/12)-1","v":1.5302419470205164E-2}]
[null,"¿Necesita Periodo de Gracia adicional?",0,null,null,null,null,null,null,"Seg. Desgrav.",{"$f":"(1+E16)^(1/30)-1","v":2.4990941953184631E-5},{"$f":"E16","v":7.5000000000000002E-4}]
[null,"Tasa Interés Efectiva Anual",0.19989999999999999,null,null,null,null,null,null,null,{"$f":"(1+TEM)^(1/30)-1","v":5.3097230898724312E-4},{"$f":"L13+L14","v":1.6052419470205165E-2}]
[null,"Seguro de Desgravamen",null,1,{"$f":"IF(D16=1,Configuracion!C28,Configuracion!C29)","v":7.5000000000000002E-4}]
[null,"Tipo de Cuota",null,1,null,null,null,null,null,"Fec. Cercana","1era Fecha","Dias 1era Fec"]
[null,"Fecha de Desembolso",{"$f":"+TODAY()","v":"2022-01-26"},2,null,null,{"$f":"E20","v":17},{"$f":"MONTH(FEC_DES)","v":1},{"$f":"YEAR(FEC_DES)","v":2022},{"$f":"IF(DATE(I18,H18,E20)<FEC_DES,DATE(I18,H18+1,G18),DATE(I18,H18,E20))","v":"2022-02-17"},{"$f":"IF(D19=2,IF(OR(DAY(FEC_DES)=E20, J18-FEC_DES<30),EDATE(J18,1), J18),FEC_DES+E19)","v":"2022-03-17"},{"$f":"K18-FEC_DES","v":50}]
[null,"Vencimiento Mes siguiente",null,2,30,null,null,null,null,{"$f":"J18-FEC_DES","v":22}]
[null,"Fecha de pago",null,2,{"$f":"IF(D20=1,Configuracion!B16,Configuracion!B17)","v":17},null,null,null,null,"Fec. Des. Ini. Gr.",{"$f":"FEC_DES","v":"2022-01-26"}]
[null,"Fecha 1er Pago",{"$f":"EDATE(K18,MESES_GRACIA)","v":"2022-03-17"},2,null,null,null,null,null,"Fec. Des. Ini. Nr.",{"$f":"IF(FEC_PRIMER_PAGO-K18=0,FEC_DES,K18)","v":"2022-01-26"}]
[null,"Seguro de Protección de créditos",null,1]
[null,"Costo de Seguro de Protección de Créditos",{"$f":"IF(D22=1,$K$28,0)","v":577},1,null,null,null,null,null,"Prestamo",{"$f":"K10","v":5577}]
[null,"Comisión envío de informe de pago físico",null,2,{"$f":"IF(D24=1,(IF(D7=1,Configuracion!F23,Configuracion!F24)),0)","v":0},null,null,null,null,"Saldo Capit.",{"$f":"VLOOKUP(\"PP\",Cronograma!B32:I127,8,FALSE)","v":5642.5240052307472}]
[null,null,{"$f":"IFERROR(C23/PLAZO,\"\")","v":9.6166666666666671},null,null,null,null,null,null,"FVP",{"$f":"SUM(Cronograma!H32:H127)","v":38.136546228821089}]
[null,"Cuota mensual",{"$f":"+Cronograma!$S$1","v":147.95582094338945},null,null,null,null,null,null,"Cuota",{"$f":"K24/K25","v":147.95582094338945}]
[]
[null,null,null,null,null,null,null,null,null,null,577,null,null,577]
[null,"Si deseas revisar el detalle de las cuotas puedes revisar"]
[null,"el cronograma dando click aquí"]
[null,null,null,null,null,null,null,null,null,"Monto Seguro",143]
[]
[null,null,null,null,null,null,null,null,null,"TCEA",{"$f":"+(K34+1)^12-1","v":0.22016186438093377},{"$f":"+(L34+1)^12-1","v":0.22016186438093377},{"$f":"+K33-L33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IRR(Cronograma!AA31:'Cronograma'!AA127,0.01)","v":1.6720204239281555E-2},{"$f":"IRR(Cronograma!AB31:'Cronograma'!AB127,0.01)","v":1.6720204239281555E-2}]

{"sheet":"Cronograma","index":2,"n_rows":144,"n_cols":28,"rows_kept":144,"cut":false,"hidden":false,"merged":[[1,3,1,19],[13,3,13,8],[12,3,12,8],[16,3,16,8],[26,3,26,20],[135,11,136,18],[138,11,138,18],[140,11,140,18],[143,11,143,18],[145,11,145,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL(S32:S37,3)","v":147.95582094338945},{"$f":"LARGE(S32:S37,1)","v":147.95582094338945}]
[null,null,null,"SIMULACIÓN PRÉSTAMO PERSONAL"]
[]
[]
[null,null,null,"CLIENTE",null,null,null,null,null,":",null,{"$f":"Datos!C9","v":0}]
[]
[null,null,null,"TASA DE INTERES COMPENSATORIA"]
[null,null,null," - EFECTIVA ANUAL FIJA",null,null,null,null,null,":",null,{"$f":"Datos!C15","v":0.19989999999999999}]
[null,null,null," - TASA DE COSTO EFECTIVO ANUAL",null,null,null,null,null,":",null,{"$f":"Datos!K33","v":0.22016186438093377}]
[]
[null,null,null,"NRO CUOTAS MENSUALES",null,null,null,null,null,":",null,{"$f":"CONCATENATE(PLAZO, \" MESES\")","v":"60 MESES"}]
[null,null,null,"MONTO DE CREDITO",null,null,null,null,null,":",null,{"$f":"CONCATENATE(IF(Datos!D7=1,\"S/\",\"$\"),TEXT(Datos!K23,\"#,##0.00\"))","v":"S/5,577.00"},null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K23","v":5577}]
[null,null,null,{"$f":"CONCATENATE(\"PERIODO DE GRACIA (\",W17,\" DIAS)\")","v":"PERIODO DE GRACIA (22 DIAS)"},null,null,null,null,null,":",null,{"$f":"CONCATENATE(IF(Datos!D7=1,\"S/\",\"$\"),TEXT(W13,\"#,##0.00\"))","v":"S/65.52"},null,null,null,null,null,null,null,null,null,null,{"$f":"W18","v":65.524005230746795}]
[null,null,null,"SEGURO PROTECCION FINANCIERA",null,null,null,null,null,":",null,{"$f":"CONCATENATE(IF(Datos!D7=1,\"S/\",\"$\"),TEXT(Datos!C23,\"#,##0.00\"))","v":"S/577.00"}]
[null,null,null,"TOTAL FINANCIADO",null,null,null,null,null,":",null,{"$f":"CONCATENATE(IF(Datos!D7=1,\"S/\",\"$\"),TEXT(W12+W13,\"#,##0.00\"))","v":"S/5,642.52"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar Dias Gracia",{"$f":"IF(F31=0,\"SI\",\"NO\")","v":"NO"}]
[null,null,null,"IMPUESTO A LAS TRANS.FINANCIER-ITF",null,null,null,null,null,":",null,5.0000000000000002E-5,null,null,null,null,null,null,null,null,null,"Dias de gracia",{"$f":"SUMIF(B31:B127,\"PG\",G31:G127)","v":22}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monto gracia",{"$f":"ABS(SUMIF(B31:B127,\"PG\",J31:J127))","v":65.524005230746795}]
[null,null,null,"NRO DE CREDITO",null,null,null,null,null,":",null,{"$f":"Datos!C10","v":0}]
[null,null,null,"MONEDA",null,null,null,null,null,":",null,{"$f":"IF(Datos!D7=1,\"SOLES\",\"DOLARES\")","v":"SOLES"}]
[null,null,null,"FECHA DE DESEMBOLSO",null,null,null,null,null,":",null,{"$f":"FEC_DES","v":"2022-01-26"}]
[null,null,null,"PRIMER VENCIMIENTO",null,null,null,null,null,":",null,{"$f":"FEC_PRIMER_PAGO","v":"2022-03-17"}]
[null,null,null,"VENCIMIENTO CREDITO",null,null,null,null,null,":",null,{"$f":"EDATE(FEC_PRIMER_PAGO,PLAZO-1)","v":"2027-02-17"}]
[]
[]
[]
[null,null,null,"CRONOGRAMA DE PAGOS"]
[]
[]
[null,null,null,"NRO",null,"FEC.VCTO",null,"FACTOR","SALDO  INICIAL","AMORTIZACION","TASA TEA","INTERES","TASA SEG. DESG.","SEGURO DESGR.","TOTAL INTERES","SEGURO BIEN","COMISION","PORTES","CUOTA TOTAL","SALDO CAPIT.","SALDO CAPIT."]
[null,"PG",null,0,{"$f":"IF(TIPO_CUOTA=2,IF(OR(MONTH(F31)=8,MONTH(F31)=1),2,IF(OR(B31=\"\",B31=\"PG\"),0,1)),IF(OR(B31=\"\",B31=\"PG\"),0,1))","v":0},{"$f":"IF(Datos!D19=1,0,IF(AND(Datos!J19>0,Datos!J19<30),Datos!J18,0))","v":"2022-02-17"},{"$f":"IF(F31=0,0,F31-FEC_DES_GR)","v":22},0,{"$f":"IF(F31=0,0,Datos!K23)","v":5577},{"$f":"S31-O31","v":-65.524005230746795},{"$f":"(1+TED_0)^G31-1","v":1.1199024900245824E-2},{"$f":"I31*K31","v":62.456961868670959},{"$f":"(1+TED_1)^G31-1","v":5.4994501740646129E-4},{"$f":"I31*M31","v":3.0670433620758346},{"$f":"L31+N31","v":65.524005230746795},0,0,0,0,{"$f":"I31","v":5577},{"$f":"I31-J31","v":5642.5240052307472},null,null,null,null,null,{"$f":"IF(F31=0,-T32,-T31)","v":-5577},{"$f":"+AA31","v":-5577}]
[null,{"$f":"IF(C32<=MESES_GRACIA,\"PG\",IF(C32-MESES_GRACIA<=PLAZO,\"PP\",\"\"))","v":"PP"},1,{"$f":"IF(B32=\"PG\",0,IF(B32=\"PP\",D31+1,0))","v":1},{"$f":"IF(TIPO_CUOTA=2,IF(IF(DAY(F32)<=15,IF(OR(MONTH(F32)=8,MONTH(F32)=1),1,0),IF(OR(MONTH(F32)=7,MONTH(F32)=12),1,0)),2,IF(OR(B32=\"\",B32=\"PG\"),0,1)),IF(OR(B32=\"\",B32=\"PG\"),0,1))","v":1},{"$f":"Datos!K18","v":"2022-03-17"},{"$f":"IF(F31=0,F32-FEC_DES,F32-F31)","v":28},{"$f":"IF(OR(B32=\"PG\",B32=\"\"),0, E32*(1/(1+TED)^SUMIF(B$32:B32,\"PP\",G$32:G32)))","v":0.98524663429426573},{"$f":"IF(F31=0,Datos!K23,U31)","v":5642.5240052307472},{"$f":"S32-O32-Q32","v":63.459052741385278},{"$f":"IF(B32=\"\",0,(1+TED_0)^G32-1)","v":1.4275012395435382E-2},{"$f":"I32*K32","v":80.547100116210615},{"$f":"IF(B32=\"\",0,(1+TED_1)^G32-1)","v":6.9998250466141165E-4},3.9496680857935584,{"$f":"L32+N32","v":84.496768202004176},0,{"$f":"IF(B32=\"PP\",COMISION,0)","v":0},0,{"$f":"IF(OR(B32=\"PG\",B32=\"\"),0,(E32*CUOTA)+Q32)","v":147.95582094338945},{"$f":"I32","v":5642.5240052307472},5579.0649524893615,null,null,null,null,null,{"$f":"+S32","v":147.95582094338945},{"$f":"+IF(AA32=0,0,AA32-IF(AND(TIPO_CUOTA=2,OR(MONTH(F32)=8,MONTH(F32)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",2,2,1,{"$f":"EDATE(F32,1)","v":"2022-04-17"},{"$f":"IF(F32=0,F33-FEC_DES,F33-F32)","v":31},{"$f":"IF(OR(B33=\"PG\",B33=\"\"),0, E33*(1/(1+TED)^SUMIF(B$32:B33,\"PP\",G$32:G33)))","v":0.96916630910847279},{"$f":"U32","v":5579.0649524893615},{"$f":"S33-O33-Q33","v":55.390637063611678},1.5816513207667748E-2,{"$f":"I33*K33","v":88.241354507484232},7.7500968515598068E-4,4.3238293722935461,92.565183879777777,0,0,0,147.95582094338945,{"$f":"I33","v":5579.0649524893615},5523.6743154257501,null,null,null,null,null,{"$f":"+S33","v":147.95582094338945},{"$f":"+IF(AA33=0,0,AA33-IF(AND(TIPO_CUOTA=2,OR(MONTH(F33)=8,MONTH(F33)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",3,3,1,{"$f":"EDATE(F33,1)","v":"2022-05-17"},30,{"$f":"IF(OR(B34=\"PG\",B34=\"\"),0, E34*(1/(1+TED)^SUMIF(B$32:B34,\"PP\",G$32:G34)))","v":0.95385463440342799},{"$f":"U33","v":5523.6743154257501},59.287483815384164,1.5302419470207607E-2,{"$f":"I34*K34","v":84.525581391456669},7.4999999999625366E-4,4.1427557365486187,88.668337128005291,0,0,0,147.95582094338945,5523.6743154257501,5464.3868316103662,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA34=0,0,AA34-IF(AND(TIPO_CUOTA=2,OR(MONTH(F34)=8,MONTH(F34)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",4,4,1,"2022-06-17",31,{"$f":"IF(OR(B35=\"PG\",B35=\"\"),0, E35*(1/(1+TED)^SUMIF(B$32:B35,\"PP\",G$32:G35)))","v":0.93828666170776898},5464.3868316103662,57.293321731481541,1.5816513207667748E-2,{"$f":"I35*K35","v":86.427546493971079},7.7500968515598068E-4,4.2349527179368369,90.662499211907914,0,0,0,147.95582094338945,5464.3868316103662,5407.093509878885,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA35=0,0,AA35-IF(AND(TIPO_CUOTA=2,OR(MONTH(F35)=8,MONTH(F35)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",5,5,1,"2022-07-17",30,{"$f":"IF(OR(B36=\"PG\",B36=\"\"),0, E36*(1/(1+TED)^SUMIF(B$32:B36,\"PP\",G$32:G36)))","v":0.92346284869535855},5407.093509878885,61.15888780819671,1.5302419470207607E-2,{"$f":"I36*K36","v":82.741613002803831},7.4999999999625366E-4,4.055320132388907,86.796933135192745,0,0,0,147.95582094338945,5407.093509878885,5345.9346220706884,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA36=0,0,AA36-IF(AND(TIPO_CUOTA=2,OR(MONTH(F36)=8,MONTH(F36)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",6,6,1,"2022-08-17",31,{"$f":"IF(OR(B37=\"PG\",B37=\"\"),0, E37*(1/(1+TED)^SUMIF(B$32:B37,\"PP\",G$32:G37)))","v":0.90839090387754462},5345.9346220706884,59.258624277764653,1.5816513207667748E-2,84.554045557309337,7.7500968515598068E-4,4.1431511083154611,88.697196665624801,0,0,0,147.95582094338945,5345.9346220706884,5286.6759977929241,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA37=0,0,AA37-IF(AND(TIPO_CUOTA=2,OR(MONTH(F37)=8,MONTH(F37)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",7,7,1,"2022-09-17",31,{"$f":"IF(OR(B38=\"PG\",B38=\"\"),0, E38*(1/(1+TED)^SUMIF(B$32:B38,\"PP\",G$32:G38)))","v":0.89356495002830327},5286.6759977929241,60.241815099066415,1.5816513207667748E-2,83.61678074375186,7.7500968515598068E-4,4.0972251005711744,87.71400584432304,0,0,0,147.95582094338945,5286.6759977929241,5226.434182693858,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA38=0,0,AA38-IF(AND(TIPO_CUOTA=2,OR(MONTH(F38)=8,MONTH(F38)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",8,8,1,"2022-10-17",30,{"$f":"IF(OR(B39=\"PG\",B39=\"\"),0, E39*(1/(1+TED)^SUMIF(B$32:B39,\"PP\",G$32:G39)))","v":0.87944768685677466},5226.434182693858,64.058907109375568,1.5302419470207607E-2,79.977088197013074,7.4999999999625366E-4,3.9198256370008133,83.896913834013887,0,0,0,147.95582094338945,5226.434182693858,5162.3752755844826,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA39=0,0,AA39-IF(AND(TIPO_CUOTA=2,OR(MONTH(F39)=8,MONTH(F39)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",9,9,1,"2022-11-17",31,{"$f":"IF(OR(B40=\"PG\",B40=\"\"),0, E40*(1/(1+TED)^SUMIF(B$32:B40,\"PP\",G$32:G40)))","v":0.86509411862694763},5162.3752755844826,62.304153377182303,1.5816513207667748E-2,81.650776729219402,7.7500968515598068E-4,4.0008908369877485,85.651667566207152,0,0,0,147.95582094338945,5162.3752755844826,5100.0711222073005,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA40=0,0,AA40-IF(AND(TIPO_CUOTA=2,OR(MONTH(F40)=8,MONTH(F40)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",10,10,1,"2022-12-17",30,{"$f":"IF(OR(B41=\"PG\",B41=\"\"),0, E41*(1/(1+TED)^SUMIF(B$32:B41,\"PP\",G$32:G41)))","v":0.8514266607209372},5100.0711222073005,66.087339961844535,1.5302419470207607E-2,78.043427639908558,7.4999999999625366E-4,3.825053341636369,81.86848098154492,0,0,0,147.95582094338945,5100.0711222073005,5033.9837822454556,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA41=0,0,AA41-IF(AND(TIPO_CUOTA=2,OR(MONTH(F41)=8,MONTH(F41)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",11,11,1,"2023-01-17",31,{"$f":"IF(OR(B42=\"PG\",B42=\"\"),0, E42*(1/(1+TED)^SUMIF(B$32:B42,\"PP\",G$32:G42)))","v":0.83753042692557533},5033.9837822454556,64.434363778160602,1.5816513207667748E-2,79.620070979070491,7.7500968515598068E-4,3.9013861861583634,83.521457165228853,0,0,0,147.95582094338945,5033.9837822454556,4969.5494184672953,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA42=0,0,AA42-IF(AND(TIPO_CUOTA=2,OR(MONTH(F42)=8,MONTH(F42)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",12,12,1,"2023-02-17",31,{"$f":"IF(OR(B43=\"PG\",B43=\"\"),0, E43*(1/(1+TED)^SUMIF(B$32:B43,\"PP\",G$32:G43)))","v":0.82386099518211497},4969.5494184672953,65.503427999870482,1.5816513207667748E-2,78.600944013345554,7.7500968515598068E-4,3.8514489301734254,82.452392943518973,0,0,0,147.95582094338945,4969.5494184672953,4904.0459904674244,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA43=0,0,AA43-IF(AND(TIPO_CUOTA=2,OR(MONTH(F43)=8,MONTH(F43)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",13,13,1,"2023-03-17",28,{"$f":"IF(OR(B44=\"PG\",B44=\"\"),0, E44*(1/(1+TED)^SUMIF(B$32:B44,\"PP\",G$32:G44)))","v":0.81170627262950346},{"$f":"U43","v":4904.0459904674244},74.517757246299638,1.4275012395435382E-2,{"$f":"I44*K44","v":70.005317301707677},6.9998250466141165E-4,3.4327463953821411,73.438063697089817,0,0,0,147.95582094338945,4904.0459904674244,{"$f":"I44-J44","v":4829.5282332211245},null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA44=0,0,AA44-IF(AND(TIPO_CUOTA=2,OR(MONTH(F44)=8,MONTH(F44)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",14,14,1,"2023-04-17",31,{"$f":"IF(OR(B45=\"PG\",B45=\"\"),0, E45*(1/(1+TED)^SUMIF(B$32:B45,\"PP\",G$32:G45)))","v":0.798458319919084},4829.5282332211245,67.826592700362639,1.5816513207667748E-2,76.386297087546197,7.7500968515598068E-4,3.7429311554806235,80.129228243026816,0,0,0,147.95582094338945,4829.5282332211245,4761.7016405207623,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA45=0,0,AA45-IF(AND(TIPO_CUOTA=2,OR(MONTH(F45)=8,MONTH(F45)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",15,15,1,"2023-05-17",30,{"$f":"IF(OR(B46=\"PG\",B46=\"\"),0, E46*(1/(1+TED)^SUMIF(B$32:B46,\"PP\",G$32:G46)))","v":0.78584362835868093},4761.7016405207623,71.518988817792305,1.5302419470207607E-2,72.865555895224418,7.4999999999625366E-4,3.571276230372733,76.436832125597149,0,0,0,147.95582094338945,4761.7016405207623,4690.1826517029704,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA46=0,0,AA46-IF(AND(TIPO_CUOTA=2,OR(MONTH(F46)=8,MONTH(F46)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",16,16,1,"2023-06-17",31,{"$f":"IF(OR(B47=\"PG\",B47=\"\"),0, E47*(1/(1+TED)^SUMIF(B$32:B47,\"PP\",G$32:G47)))","v":0.77301778288066747},4690.1826517029704,70.13854810613492,1.5816513207667748E-2,74.182335857034175,7.7500968515598068E-4,3.6349369802203615,77.817272837254535,0,0,0,147.95582094338945,4690.1826517029704,4620.0441035968352,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA47=0,0,AA47-IF(AND(TIPO_CUOTA=2,OR(MONTH(F47)=8,MONTH(F47)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",17,17,1,"2023-07-17",30,{"$f":"IF(OR(B48=\"PG\",B48=\"\"),0, E48*(1/(1+TED)^SUMIF(B$32:B48,\"PP\",G$32:G48)))","v":0.76080502153986918},4620.0441035968352,73.792935021611072,1.5302419470207607E-2,70.697852844098065,7.4999999999625366E-4,3.4650330776803182,74.162885921778383,0,0,0,147.95582094338945,4620.0441035968352,4546.2511685752243,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA48=0,0,AA48-IF(AND(TIPO_CUOTA=2,OR(MONTH(F48)=8,MONTH(F48)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",18,18,1,"2023-08-17",31,{"$f":"IF(OR(B49=\"PG\",B49=\"\"),0, E49*(1/(1+TED)^SUMIF(B$32:B49,\"PP\",G$32:G49)))","v":0.74838783408293508},4546.2511685752243,72.526590603446991,1.5816513207667748E-2,71.905841653144975,7.7500968515598068E-4,3.5233886867974937,75.429230339942464,0,0,0,147.95582094338945,4546.2511685752243,4473.7245779717769,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA49=0,0,AA49-IF(AND(TIPO_CUOTA=2,OR(MONTH(F49)=8,MONTH(F49)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",19,19,1,"2023-09-17",31,{"$f":"IF(OR(B50=\"PG\",B50=\"\"),0, E50*(1/(1+TED)^SUMIF(B$32:B50,\"PP\",G$32:G50)))","v":0.73617330899017497},4473.7245779717769,73.729917191782548,1.5816513207667748E-2,70.758723874958434,7.7500968515598068E-4,3.4671798766484794,74.225903751606907,0,0,0,147.95582094338945,4473.7245779717769,4399.9946607799939,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA50=0,0,AA50-IF(AND(TIPO_CUOTA=2,OR(MONTH(F50)=8,MONTH(F50)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",20,20,1,"2023-10-17",30,{"$f":"IF(OR(B51=\"PG\",B51=\"\"),0, E51*(1/(1+TED)^SUMIF(B$32:B51,\"PP\",G$32:G51)))","v":0.72454264650443156},4399.9946607799939,77.32526098189166,1.5302419470207607E-2,67.330563965929286,7.4999999999625366E-4,3.2999959955685116,70.630559961497795,0,0,0,147.95582094338945,4399.9946607799939,4322.6693997981019,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA51=0,0,AA51-IF(AND(TIPO_CUOTA=2,OR(MONTH(F51)=8,MONTH(F51)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",21,21,1,"2023-11-17",31,{"$f":"IF(OR(B52=\"PG\",B52=\"\"),0, E52*(1/(1+TED)^SUMIF(B$32:B52,\"PP\",G$32:G52)))","v":0.71271730149819168},4322.6693997981019,76.236152638530626,1.5816513207667748E-2,68.369557654287902,7.7500968515598068E-4,3.3501106505709188,71.719668304858828,0,0,0,147.95582094338945,4322.6693997981019,4246.4332471595717,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA52=0,0,AA52-IF(AND(TIPO_CUOTA=2,OR(MONTH(F52)=8,MONTH(F52)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",22,22,1,"2023-12-17",30,{"$f":"IF(OR(B53=\"PG\",B53=\"\"),0, E53*(1/(1+TED)^SUMIF(B$32:B53,\"PP\",G$32:G53)))","v":0.70145721602613642},4246.4332471595717,79.790293207764137,1.5302419470207607E-2,64.980702800271544,7.4999999999625366E-4,3.1848249353537703,68.165527735625318,0,0,0,147.95582094338945,4246.4332471595717,4166.6429539518076,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA53=0,0,AA53-IF(AND(TIPO_CUOTA=2,OR(MONTH(F53)=8,MONTH(F53)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",23,23,1,"2024-01-17",31,{"$f":"IF(OR(B54=\"PG\",B54=\"\"),0, E54*(1/(1+TED)^SUMIF(B$32:B54,\"PP\",G$32:G54)))","v":0.69000865102220632},4166.6429539518076,78.824868986675355,1.5816513207667748E-2,65.901763312814523,7.7500968515598068E-4,3.2291886438995756,69.1309519567141,0,0,0,147.95582094338945,4166.6429539518076,4087.8180849651321,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA54=0,0,AA54-IF(AND(TIPO_CUOTA=2,OR(MONTH(F54)=8,MONTH(F54)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",24,24,1,"2024-02-17",31,{"$f":"IF(OR(B55=\"PG\",B55=\"\"),0, E55*(1/(1+TED)^SUMIF(B$32:B55,\"PP\",G$32:G55)))","v":0.67874693938246511},4087.8180849651321,80.132693604991601,1.5816513207667748E-2,64.655028731394097,7.7500968515598068E-4,3.1680986070037509,67.823127338397853,0,0,0,147.95582094338945,4087.8180849651321,4007.6853913601403,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA55=0,0,AA55-IF(AND(TIPO_CUOTA=2,OR(MONTH(F55)=8,MONTH(F55)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",25,25,1,"2024-03-17",29,{"$f":"IF(OR(B56=\"PG\",B56=\"\"),0, E56*(1/(1+TED)^SUMIF(B$32:B56,\"PP\",G$32:G56)))","v":0.66837824722290329},4007.6853913601403,85.782285634469829,1.4788585910021412E-2,59.267999710467222,7.2499093983680041E-4,2.9055355984524036,62.173535308919625,0,0,0,147.95582094338945,4007.6853913601403,3921.9031057256707,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA56=0,0,AA56-IF(AND(TIPO_CUOTA=2,OR(MONTH(F56)=8,MONTH(F56)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",26,26,1,"2024-04-17",31,{"$f":"IF(OR(B57=\"PG\",B57=\"\"),0, E57*(1/(1+TED)^SUMIF(B$32:B57,\"PP\",G$32:G57)))","v":0.6574695679254059},3921.9031057256707,82.885475781305502,1.5816513207667748E-2,62.030832270903232,7.7500968515598068E-4,3.0395128911807148,65.070345162083953,0,0,0,147.95582094338945,3921.9031057256707,3839.0176299443651,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA57=0,0,AA57-IF(AND(TIPO_CUOTA=2,OR(MONTH(F57)=8,MONTH(F57)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",27,27,1,"2024-05-17",30,{"$f":"IF(OR(B58=\"PG\",B58=\"\"),0, E58*(1/(1+TED)^SUMIF(B$32:B58,\"PP\",G$32:G58)))","v":0.64708233091775469},3839.0176299443651,86.330299594014662,1.5302419470207607E-2,58.746258126930911,7.4999999999625366E-4,2.8792632224438917,61.6255213493748,0,0,0,147.95582094338945,3839.0176299443651,3752.6873303503503,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA58=0,0,AA58-IF(AND(TIPO_CUOTA=2,OR(MONTH(F58)=8,MONTH(F58)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",28,28,1,"2024-06-17",31,{"$f":"IF(OR(B59=\"PG\",B59=\"\"),0, E59*(1/(1+TED)^SUMIF(B$32:B59,\"PP\",G$32:G59)))","v":0.63652122475311224},3752.6873303503503,85.693023192272051,1.5816513207667748E-2,59.354428724733737,7.7500968515598068E-4,2.9083690263836628,62.262797751117397,0,0,0,147.95582094338945,3752.6873303503503,3666.9943071580783,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA59=0,0,AA59-IF(AND(TIPO_CUOTA=2,OR(MONTH(F59)=8,MONTH(F59)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",29,29,1,"2024-07-17",30,{"$f":"IF(OR(B60=\"PG\",B60=\"\"),0, E60*(1/(1+TED)^SUMIF(B$32:B60,\"PP\",G$32:G60)))","v":0.62646494664616703},3666.9943071580783,89.091690130038415,1.5302419470207607E-2,56.113885082996227,7.4999999999625366E-4,2.7502457303548211,58.864130813351046,0,0,0,147.95582094338945,3666.9943071580783,3577.9026170280399,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA60=0,0,AA60-IF(AND(TIPO_CUOTA=2,OR(MONTH(F60)=8,MONTH(F60)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",30,30,1,"2024-08-17",31,{"$f":"IF(OR(B61=\"PG\",B61=\"\"),0, E61*(1/(1+TED)^SUMIF(B$32:B61,\"PP\",G$32:G61)))","v":0.61624033921395116},3577.9026170280399,88.592967764674796,1.5816513207667748E-2,56.589943997972995,7.7500968515598068E-4,2.7729091807416606,59.362853178714658,0,0,0,147.95582094338945,3577.9026170280399,3489.3096492633649,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA61=0,0,AA61-IF(AND(TIPO_CUOTA=2,OR(MONTH(F61)=8,MONTH(F61)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",31,31,1,"2024-09-17",31,{"$f":"IF(OR(B62=\"PG\",B62=\"\"),0, E62*(1/(1+TED)^SUMIF(B$32:B62,\"PP\",G$32:G62)))","v":0.60618260879169839},3489.3096492633649,90.062860017485605,1.5816513207667748E-2,55.188712153216528,7.7500968515598068E-4,2.7042487726873259,57.892960925903857,0,0,0,147.95582094338945,3489.3096492633649,3399.2467892458794,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA62=0,0,AA62-IF(AND(TIPO_CUOTA=2,OR(MONTH(F62)=8,MONTH(F62)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",32,32,1,"2024-10-17",30,{"$f":"IF(OR(B63=\"PG\",B63=\"\"),0, E63*(1/(1+TED)^SUMIF(B$32:B63,\"PP\",G$32:G63)))","v":0.59660564472429045},3399.2467892458794,93.389685599670941,1.5302419470207607E-2,52.016700251796841,7.4999999999625366E-4,{"$f":"I63*M63","v":2.5494350919216751},54.566135343718514,0,0,0,147.95582094338945,3399.2467892458794,3305.8571036462085,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA63=0,0,AA63-IF(AND(TIPO_CUOTA=2,OR(MONTH(F63)=8,MONTH(F63)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,{"$f":"IF(C64<=MESES_GRACIA,\"PG\",IF(C64-MESES_GRACIA<=PLAZO,\"PP\",\"\"))","v":"PP"},33,{"$f":"IF(B64=\"PG\",0,IF(B64=\"PP\",D63+1,0))","v":33},{"$f":"IF(TIPO_CUOTA=2,IF(IF(DAY(F64)<=15,IF(OR(MONTH(F64)=8,MONTH(F64)=1),1,0),IF(OR(MONTH(F64)=7,MONTH(F64)=12),1,0)),2,IF(OR(B64=\"\",B64=\"PG\"),0,1)),IF(OR(B64=\"\",B64=\"PG\"),0,1))","v":1},"2024-11-17",{"$f":"IF(F63=0,F64-FEC_DES,F64-F63)","v":31},{"$f":"IF(OR(B64=\"PG\",B64=\"\"),0, E64*(1/(1+TED)^SUMIF(B$32:B64,\"PP\",G$32:G64)))","v":0.58686837443996387},3305.8571036462085,93.106617127839442,{"$f":"IF(B64=\"\",0,(1+TED_0)^G64-1)","v":1.5816513207667748E-2},52.287132542482503,{"$f":"IF(B64=\"\",0,(1+TED_1)^G64-1)","v":7.7500968515598068E-4},2.5620712730675104,54.849203815550013,0,{"$f":"IF(B64=\"PP\",COMISION,0)","v":0},0,{"$f":"IF(OR(B64=\"PG\",B64=\"\"),0,(E64*CUOTA)+Q64)","v":147.95582094338945},3305.8571036462085,3212.7504865183691,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA64=0,0,AA64-IF(AND(TIPO_CUOTA=2,OR(MONTH(F64)=8,MONTH(F64)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",34,34,1,"2024-12-17",30,{"$f":"IF(OR(B65=\"PG\",B65=\"\"),0, E65*(1/(1+TED)^SUMIF(B$32:B65,\"PP\",G$32:G65)))","v":0.57759655229793194},3212.7504865183691,96.383402480695054,1.5302419470207607E-2,49.162855597817654,7.4999999999625366E-4,2.4095628648767407,51.572418462694394,0,0,0,147.95582094338945,3212.7504865183691,3116.367084037674,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA65=0,0,AA65-IF(AND(TIPO_CUOTA=2,OR(MONTH(F65)=8,MONTH(F65)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",35,35,1,"2025-01-17",31,{"$f":"IF(OR(B66=\"PG\",B66=\"\"),0, E66*(1/(1+TED)^SUMIF(B$32:B66,\"PP\",G$32:G66)))","v":0.56816953162731942},3116.367084037674,96.250545126136061,1.5816513207667748E-2,49.290061144622896,7.7500968515598068E-4,2.4152146726304995,51.705275817253394,0,0,0,147.95582094338945,3116.367084037674,3020.1165389115381,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA66=0,0,AA66-IF(AND(TIPO_CUOTA=2,OR(MONTH(F66)=8,MONTH(F66)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",36,36,1,"2025-02-17",31,{"$f":"IF(OR(B67=\"PG\",B67=\"\"),0, E67*(1/(1+TED)^SUMIF(B$32:B67,\"PP\",G$32:G67)))","v":0.55889637046014473},3020.1165389115381,97.847488249043096,1.5816513207667748E-2,47.767713126390149,7.7500968515598068E-4,2.3406195679562014,50.108332694346352,0,0,0,147.95582094338945,3020.1165389115381,2922.2690506624949,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA67=0,0,AA67-IF(AND(TIPO_CUOTA=2,OR(MONTH(F67)=8,MONTH(F67)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",37,37,1,"2025-03-17",28,{"$f":"IF(OR(B68=\"PG\",B68=\"\"),0, E68*(1/(1+TED)^SUMIF(B$32:B68,\"PP\",G$32:G68)))","v":0.55065076791513878},2922.2690506624949,104.1948568130079,1.4275012395435382E-2,41.715426921004301,6.9998250466141165E-4,2.045537209377259,43.760964130381559,0,0,0,147.95582094338945,2922.2690506624949,2818.0741938494871,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA68=0,0,AA68-IF(AND(TIPO_CUOTA=2,OR(MONTH(F68)=8,MONTH(F68)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",38,38,1,"2025-04-17",31,{"$f":"IF(OR(B69=\"PG\",B69=\"\"),0, E69*(1/(1+TED)^SUMIF(B$32:B69,\"PP\",G$32:G69)))","v":0.54166353253298027},2818.0741938494871,101.19967844245991,1.5816513207667748E-2,44.572107707208055,7.7500968515598068E-4,2.184034793721485,46.756142500929542,0,0,0,147.95582094338945,2818.0741938494871,2716.874515407027,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA69=0,0,AA69-IF(AND(TIPO_CUOTA=2,OR(MONTH(F69)=8,MONTH(F69)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",39,39,1,"2025-05-17",30,{"$f":"IF(OR(B70=\"PG\",B70=\"\"),0, E70*(1/(1+TED)^SUMIF(B$32:B70,\"PP\",G$32:G70)))","v":0.53310589311466428},2716.874515407027,104.34341157416901,1.5302419470207607E-2,41.574753482675348,7.4999999999625366E-4,2.037655886545092,43.612409369220437,0,0,0,147.95582094338945,2716.874515407027,2612.5311038328582,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA70=0,0,AA70-IF(AND(TIPO_CUOTA=2,OR(MONTH(F70)=8,MONTH(F70)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",40,40,1,"2025-06-17",31,{"$f":"IF(OR(B71=\"PG\",B71=\"\"),0, E71*(1/(1+TED)^SUMIF(B$32:B71,\"PP\",G$32:G71)))","v":0.52440500967963799},2612.5311038328582,104.60995132593254,1.5816513207667748E-2,41.321132709215206,7.7500968515598068E-4,2.0247369082417102,43.345869617456913,0,0,0,147.95582094338945,2612.5311038328582,2507.9211525069259,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA71=0,0,AA71-IF(AND(TIPO_CUOTA=2,OR(MONTH(F71)=8,MONTH(F71)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",41,41,1,"2025-07-17",30,{"$f":"IF(OR(B72=\"PG\",B72=\"\"),0, E72*(1/(1+TED)^SUMIF(B$32:B72,\"PP\",G$32:G72)))","v":0.51612003439062171},2507.9211525069259,107.69761860515118,1.5302419470207607E-2,38.377261473867485,7.4999999999625366E-4,1.8809408643707988,40.258202338238284,0,0,0,147.95582094338945,2507.9211525069259,2400.2235339017748,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA72=0,0,AA72-IF(AND(TIPO_CUOTA=2,OR(MONTH(F72)=8,MONTH(F72)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",42,42,1,"2025-08-17",31,{"$f":"IF(OR(B73=\"PG\",B73=\"\"),0, E73*(1/(1+TED)^SUMIF(B$32:B73,\"PP\",G$32:G73)))","v":0.50769637913616994},2400.2235339017748,108.1324572327639,1.5816513207667748E-2,37.963167225312375,7.7500968515598068E-4,1.8601964853131898,39.823363710625564,0,0,0,147.95582094338945,2400.2235339017748,2292.0910766690108,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA73=0,0,AA73-IF(AND(TIPO_CUOTA=2,OR(MONTH(F73)=8,MONTH(F73)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",43,43,1,"2025-09-17",31,{"$f":"IF(OR(B74=\"PG\",B74=\"\"),0, E74*(1/(1+TED)^SUMIF(B$32:B74,\"PP\",G$32:G74)))","v":0.49941020734121927},2292.0910766690108,109.92653937239857,1.5816513207667748E-2,36.252888787312799,7.7500968515598068E-4,1.7763927836780828,38.029281570990882,0,0,0,147.95582094338945,2292.0910766690108,2182.1645372966123,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA74=0,0,AA74-IF(AND(TIPO_CUOTA=2,OR(MONTH(F74)=8,MONTH(F74)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",44,44,1,"2025-10-17",30,{"$f":"IF(OR(B75=\"PG\",B75=\"\"),0, E75*(1/(1+TED)^SUMIF(B$32:B75,\"PP\",G$32:G75)))","v":0.49152012019382124},2182.1645372966123,112.92680043770092,1.5302419470207607E-2,33.392397102724253,7.4999999999625366E-4,1.6366234029642841,35.029020505688536,0,0,0,147.95582094338945,2182.1645372966123,2069.2377368589114,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA75=0,0,AA75-IF(AND(TIPO_CUOTA=2,OR(MONTH(F75)=8,MONTH(F75)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",45,45,1,"2025-11-17",31,{"$f":"IF(OR(B76=\"PG\",B76=\"\"),0, E76*(1/(1+TED)^SUMIF(B$32:B76,\"PP\",G$32:G76)))","v":0.48349796300701897},2069.2377368589114,113.62401566160005,1.5816513207667748E-2,32.728125994833491,7.7500968515598068E-4,1.6036792869558989,34.331805281789393,0,0,0,147.95582094338945,2069.2377368589114,1955.6137211973114,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA76=0,0,AA76-IF(AND(TIPO_CUOTA=2,OR(MONTH(F76)=8,MONTH(F76)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",46,46,1,"2025-12-17",30,{"$f":"IF(OR(B77=\"PG\",B77=\"\"),0, E77*(1/(1+TED)^SUMIF(B$32:B77,\"PP\",G$32:G77)))","v":0.47585927038993298},1955.6137211973114,116.56348916904392,1.5302419470207607E-2,29.925621483454886,7.4999999999625366E-4,1.4667102908906571,31.392331774345543,0,0,0,147.95582094338945,1955.6137211973114,1839.0502320282676,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA77=0,0,AA77-IF(AND(TIPO_CUOTA=2,OR(MONTH(F77)=8,MONTH(F77)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",47,47,1,"2026-01-17",31,{"$f":"IF(OR(B78=\"PG\",B78=\"\"),0, E78*(1/(1+TED)^SUMIF(B$32:B78,\"PP\",G$32:G78)))","v":0.46809271575863953},1839.0502320282676,117.44317691763966,1.5816513207667748E-2,29.087362284439532,7.7500968515598068E-4,1.425281741310261,30.512644025749793,0,0,0,147.95582094338945,1839.0502320282676,1721.6070551106279,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA78=0,0,AA78-IF(AND(TIPO_CUOTA=2,OR(MONTH(F78)=8,MONTH(F78)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",48,48,1,"2026-02-17",31,{"$f":"IF(OR(B79=\"PG\",B79=\"\"),0, E79*(1/(1+TED)^SUMIF(B$32:B79,\"PP\",G$32:G79)))","v":0.46045291997096705},1721.6070551106279,119.39173807607463,1.5816513207667748E-2,27.229820725571223,7.7500968515598068E-4,1.3342621417436029,28.564082867314827,0,0,0,147.95582094338945,1721.6070551106279,1602.2153170345532,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA79=0,0,AA79-IF(AND(TIPO_CUOTA=2,OR(MONTH(F79)=8,MONTH(F79)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",49,49,1,"2026-03-17",28,{"$f":"IF(OR(B80=\"PG\",B80=\"\"),0, E80*(1/(1+TED)^SUMIF(B$32:B80,\"PP\",G$32:G80)))","v":0.45365968965236225},1602.2153170345532,123.96265474194004,1.4275012395435382E-2,22.871643510824679,6.9998250466141165E-4,1.1215226906247242,23.993166201449405,0,0,0,147.95582094338945,1602.2153170345532,1478.2526622926132,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA80=0,0,AA80-IF(AND(TIPO_CUOTA=2,OR(MONTH(F80)=8,MONTH(F80)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",50,50,1,"2026-04-17",31,{"$f":"IF(OR(B81=\"PG\",B81=\"\"),0, E81*(1/(1+TED)^SUMIF(B$32:B81,\"PP\",G$32:G81)))","v":0.44625545696648117},1478.2526622926132,123.42935805558393,1.5816513207667748E-2,23.380802757421129,7.7500968515598068E-4,1.1456601303843883,24.526462887805518,0,0,0,147.95582094338945,1478.2526622926132,1354.8233042370293,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA81=0,0,AA81-IF(AND(TIPO_CUOTA=2,OR(MONTH(F81)=8,MONTH(F81)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",51,51,1,"2026-05-17",30,{"$f":"IF(OR(B82=\"PG\",B82=\"\"),0, E82*(1/(1+TED)^SUMIF(B$32:B82,\"PP\",G$32:G82)))","v":0.43920515163889751},1354.8233042370293,126.20762895576904,1.5302419470207607E-2,20.73207450944772,7.4999999999625366E-4,1.0161174781726965,21.748191987620416,0,0,0,147.95582094338945,1354.8233042370293,1228.6156752812603,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA82=0,0,AA82-IF(AND(TIPO_CUOTA=2,OR(MONTH(F82)=8,MONTH(F82)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",52,52,1,"2026-06-17",31,{"$f":"IF(OR(B83=\"PG\",B83=\"\"),0, E83*(1/(1+TED)^SUMIF(B$32:B83,\"PP\",G$32:G83)))","v":0.43203683315315317},1228.6156752812603,127.57121584047835,1.5816513207667748E-2,19.432416055233684,7.7500968515598068E-4,0.95218904767743218,20.384605102911117,0,0,0,147.95582094338945,1228.6156752812603,1101.044459440782,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA83=0,0,AA83-IF(AND(TIPO_CUOTA=2,OR(MONTH(F83)=8,MONTH(F83)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",53,53,1,"2026-07-17",30,{"$f":"IF(OR(B84=\"PG\",B84=\"\"),0, E84*(1/(1+TED)^SUMIF(B$32:B84,\"PP\",G$32:G84)))","v":0.42521116516648511},1101.044459440782,130.28139342510215,1.5302419470207607E-2,16.848644173710831,7.4999999999625366E-4,0.82578334457646163,17.674427518287292,0,0,0,147.95582094338945,1101.044459440782,970.7630660156799,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA84=0,0,AA84-IF(AND(TIPO_CUOTA=2,OR(MONTH(F84)=8,MONTH(F84)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",54,54,1,"2026-08-17",31,{"$f":"IF(OR(B85=\"PG\",B85=\"\"),0, E85*(1/(1+TED)^SUMIF(B$32:B85,\"PP\",G$32:G85)))","v":0.4182712441654815},970.7630660156799,131.84938331008254,1.5816513207667748E-2,15.354086855153039,7.7500968515598068E-4,0.75235077815386653,16.106437633306903,0,0,0,147.95582094338945,970.7630660156799,838.91368270559735,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA85=0,0,AA85-IF(AND(TIPO_CUOTA=2,OR(MONTH(F85)=8,MONTH(F85)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",55,55,1,"2026-09-17",31,{"$f":"IF(OR(B86=\"PG\",B86=\"\"),0, E86*(1/(1+TED)^SUMIF(B$32:B86,\"PP\",G$32:G86)))","v":0.41144459042424342},838.91368270559735,134.03696537167647,1.5816513207667748E-2,13.268689342606271,7.7500968515598068E-4,0.65016622910670929,13.91885557171298,0,0,0,147.95582094338945,838.91368270559735,704.87671733392085,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA86=0,0,AA86-IF(AND(TIPO_CUOTA=2,OR(MONTH(F86)=8,MONTH(F86)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",56,56,1,"2026-10-17",30,{"$f":"IF(OR(B87=\"PG\",B87=\"\"),0, E87*(1/(1+TED)^SUMIF(B$32:B87,\"PP\",G$32:G87)))","v":0.40494425537491457},704.87671733392085,136.64084420196505,1.5302419470207607E-2,10.786319203426615,7.4999999999625366E-4,0.52865753799779991,11.314976741424415,0,0,0,147.95582094338945,704.87671733392085,568.23587313195583,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA87=0,0,AA87-IF(AND(TIPO_CUOTA=2,OR(MONTH(F87)=8,MONTH(F87)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",57,57,1,"2026-11-17",31,{"$f":"IF(OR(B88=\"PG\",B88=\"\"),0, E88*(1/(1+TED)^SUMIF(B$32:B88,\"PP\",G$32:G88)))","v":0.39833511297148827},568.23587313195583,138.52792244579692,1.5816513207667748E-2,8.9875101924621941,7.7500968515598068E-4,0.44038830513033089,9.4278984975925244,0,0,0,147.95582094338945,568.23587313195583,429.70795068615894,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA88=0,0,AA88-IF(AND(TIPO_CUOTA=2,OR(MONTH(F88)=8,MONTH(F88)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",58,58,1,"2026-12-17",30,{"$f":"IF(OR(B89=\"PG\",B89=\"\"),0, E89*(1/(1+TED)^SUMIF(B$32:B89,\"PP\",G$32:G89)))","v":0.39204189207008533},429.70795068615894,141.05796866929356,1.5302419470207607E-2,6.5755713110828884,7.4999999999625366E-4,0.32228096301300935,6.8978522740958974,0,0,0,147.95582094338945,429.70795068615894,288.64998201686535,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA89=0,0,AA89-IF(AND(TIPO_CUOTA=2,OR(MONTH(F89)=8,MONTH(F89)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",59,59,1,"2027-01-17",31,{"$f":"IF(OR(B90=\"PG\",B90=\"\"),0, E90*(1/(1+TED)^SUMIF(B$32:B90,\"PP\",G$32:G90)))","v":0.3856433306424118},288.64998201686535,143.16667815874348,1.5816513207667748E-2,4.565436252962809,7.7500968515598068E-4,0.22370653168317031,4.7891427846459793,0,0,0,147.95582094338945,288.64998201686535,145.48330385812187,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA90=0,0,AA90-IF(AND(TIPO_CUOTA=2,OR(MONTH(F90)=8,MONTH(F90)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"PP",60,60,1,"2027-02-17",31,{"$f":"IF(OR(B91=\"PG\",B91=\"\"),0, E91*(1/(1+TED)^SUMIF(B$32:B91,\"PP\",G$32:G91)))","v":0.37934920088179175},145.48330385812187,145.54203137690379,1.5816513207667748E-2,2.3010385969671248,7.7500968515598068E-4,0.1127509695185349,2.4137895664856597,0,0,0,147.95582094338945,145.48330385812187,-5.8727518781921617E-2,null,null,null,null,null,147.95582094338945,{"$f":"+IF(AA91=0,0,AA91-IF(AND(TIPO_CUOTA=2,OR(MONTH(F91)=8,MONTH(F91)=12)),2*Datos!$C$31,Datos!$C$31))","v":147.95582094338945}]
[null,"",61,0,0,"2027-03-17",28,{"$f":"IF(OR(B92=\"PG\",B92=\"\"),0, E92*(1/(1+TED)^SUMIF(B$32:B92,\"PP\",G$32:G92)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA92=0,0,AA92-IF(AND(TIPO_CUOTA=2,OR(MONTH(F92)=8,MONTH(F92)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",62,0,0,"2027-04-17",31,{"$f":"IF(OR(B93=\"PG\",B93=\"\"),0, E93*(1/(1+TED)^SUMIF(B$32:B93,\"PP\",G$32:G93)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA93=0,0,AA93-IF(AND(TIPO_CUOTA=2,OR(MONTH(F93)=8,MONTH(F93)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",63,0,0,"2027-05-17",30,{"$f":"IF(OR(B94=\"PG\",B94=\"\"),0, E94*(1/(1+TED)^SUMIF(B$32:B94,\"PP\",G$32:G94)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA94=0,0,AA94-IF(AND(TIPO_CUOTA=2,OR(MONTH(F94)=8,MONTH(F94)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",64,0,0,"2027-06-17",31,{"$f":"IF(OR(B95=\"PG\",B95=\"\"),0, E95*(1/(1+TED)^SUMIF(B$32:B95,\"PP\",G$32:G95)))","v":0},-5.8727518781921617E-2,0,0,0,0,{"$f":"I95*M95","v":0},0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA95=0,0,AA95-IF(AND(TIPO_CUOTA=2,OR(MONTH(F95)=8,MONTH(F95)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,{"$f":"IF(C96<=MESES_GRACIA,\"PG\",IF(C96-MESES_GRACIA<=PLAZO,\"PP\",\"\"))","v":""},65,{"$f":"IF(B96=\"PG\",0,IF(B96=\"PP\",D95+1,0))","v":0},{"$f":"IF(TIPO_CUOTA=2,IF(IF(DAY(F96)<=15,IF(OR(MONTH(F96)=8,MONTH(F96)=1),1,0),IF(OR(MONTH(F96)=7,MONTH(F96)=12),1,0)),2,IF(OR(B96=\"\",B96=\"PG\"),0,1)),IF(OR(B96=\"\",B96=\"PG\"),0,1))","v":0},"2027-07-17",{"$f":"IF(F95=0,F96-FEC_DES,F96-F95)","v":30},{"$f":"IF(OR(B96=\"PG\",B96=\"\"),0, E96*(1/(1+TED)^SUMIF(B$32:B96,\"PP\",G$32:G96)))","v":0},-5.8727518781921617E-2,0,{"$f":"IF(B96=\"\",0,(1+TED_0)^G96-1)","v":0},0,{"$f":"IF(B96=\"\",0,(1+TED_1)^G96-1)","v":0},0,{"$f":"L96+N96","v":0},0,{"$f":"IF(B96=\"PP\",COMISION,0)","v":0},0,{"$f":"IF(OR(B96=\"PG\",B96=\"\"),0,(E96*CUOTA)+Q96)","v":0},-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA96=0,0,AA96-IF(AND(TIPO_CUOTA=2,OR(MONTH(F96)=8,MONTH(F96)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",66,0,0,"2027-08-17",31,{"$f":"IF(OR(B97=\"PG\",B97=\"\"),0, E97*(1/(1+TED)^SUMIF(B$32:B97,\"PP\",G$32:G97)))","v":0},-5.8727518781921617E-2,{"$f":"S97-O97-Q97","v":0},0,0,0,0,0,0,0,0,0,{"$f":"I97","v":-5.8727518781921617E-2},-5.8727518781921617E-2,null,null,null,null,null,{"$f":"+S97","v":0},{"$f":"+IF(AA97=0,0,AA97-IF(AND(TIPO_CUOTA=2,OR(MONTH(F97)=8,MONTH(F97)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",67,0,0,{"$f":"EDATE(F97,1)","v":"2027-09-17"},31,{"$f":"IF(OR(B98=\"PG\",B98=\"\"),0, E98*(1/(1+TED)^SUMIF(B$32:B98,\"PP\",G$32:G98)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA98=0,0,AA98-IF(AND(TIPO_CUOTA=2,OR(MONTH(F98)=8,MONTH(F98)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",68,0,0,"2027-10-17",30,{"$f":"IF(OR(B99=\"PG\",B99=\"\"),0, E99*(1/(1+TED)^SUMIF(B$32:B99,\"PP\",G$32:G99)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA99=0,0,AA99-IF(AND(TIPO_CUOTA=2,OR(MONTH(F99)=8,MONTH(F99)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",69,0,0,"2027-11-17",31,{"$f":"IF(OR(B100=\"PG\",B100=\"\"),0, E100*(1/(1+TED)^SUMIF(B$32:B100,\"PP\",G$32:G100)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA100=0,0,AA100-IF(AND(TIPO_CUOTA=2,OR(MONTH(F100)=8,MONTH(F100)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",70,0,0,"2027-12-17",30,{"$f":"IF(OR(B101=\"PG\",B101=\"\"),0, E101*(1/(1+TED)^SUMIF(B$32:B101,\"PP\",G$32:G101)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA101=0,0,AA101-IF(AND(TIPO_CUOTA=2,OR(MONTH(F101)=8,MONTH(F101)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",71,0,0,"2028-01-17",31,{"$f":"IF(OR(B102=\"PG\",B102=\"\"),0, E102*(1/(1+TED)^SUMIF(B$32:B102,\"PP\",G$32:G102)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA102=0,0,AA102-IF(AND(TIPO_CUOTA=2,OR(MONTH(F102)=8,MONTH(F102)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",72,0,0,"2028-02-17",31,{"$f":"IF(OR(B103=\"PG\",B103=\"\"),0, E103*(1/(1+TED)^SUMIF(B$32:B103,\"PP\",G$32:G103)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA103=0,0,AA103-IF(AND(TIPO_CUOTA=2,OR(MONTH(F103)=8,MONTH(F103)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",73,0,0,"2028-03-17",29,{"$f":"IF(OR(B104=\"PG\",B104=\"\"),0, E104*(1/(1+TED)^SUMIF(B$32:B104,\"PP\",G$32:G104)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA104=0,0,AA104-IF(AND(TIPO_CUOTA=2,OR(MONTH(F104)=8,MONTH(F104)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",74,0,0,"2028-04-17",31,{"$f":"IF(OR(B105=\"PG\",B105=\"\"),0, E105*(1/(1+TED)^SUMIF(B$32:B105,\"PP\",G$32:G105)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA105=0,0,AA105-IF(AND(TIPO_CUOTA=2,OR(MONTH(F105)=8,MONTH(F105)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",75,0,0,"2028-05-17",30,{"$f":"IF(OR(B106=\"PG\",B106=\"\"),0, E106*(1/(1+TED)^SUMIF(B$32:B106,\"PP\",G$32:G106)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA106=0,0,AA106-IF(AND(TIPO_CUOTA=2,OR(MONTH(F106)=8,MONTH(F106)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",76,0,0,"2028-06-17",31,{"$f":"IF(OR(B107=\"PG\",B107=\"\"),0, E107*(1/(1+TED)^SUMIF(B$32:B107,\"PP\",G$32:G107)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA107=0,0,AA107-IF(AND(TIPO_CUOTA=2,OR(MONTH(F107)=8,MONTH(F107)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",77,0,0,"2028-07-17",30,{"$f":"IF(OR(B108=\"PG\",B108=\"\"),0, E108*(1/(1+TED)^SUMIF(B$32:B108,\"PP\",G$32:G108)))","v":0},{"$f":"U107","v":-5.8727518781921617E-2},0,0,{"$f":"I108*K108","v":0},0,0,0,0,0,0,0,-5.8727518781921617E-2,{"$f":"I108-J108","v":-5.8727518781921617E-2},null,null,null,null,null,0,{"$f":"+IF(AA108=0,0,AA108-IF(AND(TIPO_CUOTA=2,OR(MONTH(F108)=8,MONTH(F108)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",78,0,0,"2028-08-17",31,{"$f":"IF(OR(B109=\"PG\",B109=\"\"),0, E109*(1/(1+TED)^SUMIF(B$32:B109,\"PP\",G$32:G109)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA109=0,0,AA109-IF(AND(TIPO_CUOTA=2,OR(MONTH(F109)=8,MONTH(F109)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",79,0,0,"2028-09-17",31,{"$f":"IF(OR(B110=\"PG\",B110=\"\"),0, E110*(1/(1+TED)^SUMIF(B$32:B110,\"PP\",G$32:G110)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA110=0,0,AA110-IF(AND(TIPO_CUOTA=2,OR(MONTH(F110)=8,MONTH(F110)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",80,0,0,"2028-10-17",30,{"$f":"IF(OR(B111=\"PG\",B111=\"\"),0, E111*(1/(1+TED)^SUMIF(B$32:B111,\"PP\",G$32:G111)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA111=0,0,AA111-IF(AND(TIPO_CUOTA=2,OR(MONTH(F111)=8,MONTH(F111)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",81,0,0,"2028-11-17",31,{"$f":"IF(OR(B112=\"PG\",B112=\"\"),0, E112*(1/(1+TED)^SUMIF(B$32:B112,\"PP\",G$32:G112)))","v":0},{"$f":"U111","v":-5.8727518781921617E-2},0,0,{"$f":"I112*K112","v":0},0,{"$f":"I112*M112","v":0},{"$f":"L112+N112","v":0},0,0,0,0,-5.8727518781921617E-2,{"$f":"I112-J112","v":-5.8727518781921617E-2},null,null,null,null,null,0,{"$f":"+IF(AA112=0,0,AA112-IF(AND(TIPO_CUOTA=2,OR(MONTH(F112)=8,MONTH(F112)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",82,0,0,"2028-12-17",30,{"$f":"IF(OR(B113=\"PG\",B113=\"\"),0, E113*(1/(1+TED)^SUMIF(B$32:B113,\"PP\",G$32:G113)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA113=0,0,AA113-IF(AND(TIPO_CUOTA=2,OR(MONTH(F113)=8,MONTH(F113)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",83,0,0,"2029-01-17",31,{"$f":"IF(OR(B114=\"PG\",B114=\"\"),0, E114*(1/(1+TED)^SUMIF(B$32:B114,\"PP\",G$32:G114)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA114=0,0,AA114-IF(AND(TIPO_CUOTA=2,OR(MONTH(F114)=8,MONTH(F114)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",84,0,0,"2029-02-17",31,{"$f":"IF(OR(B115=\"PG\",B115=\"\"),0, E115*(1/(1+TED)^SUMIF(B$32:B115,\"PP\",G$32:G115)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA115=0,0,AA115-IF(AND(TIPO_CUOTA=2,OR(MONTH(F115)=8,MONTH(F115)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",85,0,0,"2029-03-17",28,{"$f":"IF(OR(B116=\"PG\",B116=\"\"),0, E116*(1/(1+TED)^SUMIF(B$32:B116,\"PP\",G$32:G116)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA116=0,0,AA116-IF(AND(TIPO_CUOTA=2,OR(MONTH(F116)=8,MONTH(F116)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",86,0,0,"2029-04-17",31,{"$f":"IF(OR(B117=\"PG\",B117=\"\"),0, E117*(1/(1+TED)^SUMIF(B$32:B117,\"PP\",G$32:G117)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA117=0,0,AA117-IF(AND(TIPO_CUOTA=2,OR(MONTH(F117)=8,MONTH(F117)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",87,0,0,"2029-05-17",30,{"$f":"IF(OR(B118=\"PG\",B118=\"\"),0, E118*(1/(1+TED)^SUMIF(B$32:B118,\"PP\",G$32:G118)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA118=0,0,AA118-IF(AND(TIPO_CUOTA=2,OR(MONTH(F118)=8,MONTH(F118)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",88,0,0,"2029-06-17",31,{"$f":"IF(OR(B119=\"PG\",B119=\"\"),0, E119*(1/(1+TED)^SUMIF(B$32:B119,\"PP\",G$32:G119)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA119=0,0,AA119-IF(AND(TIPO_CUOTA=2,OR(MONTH(F119)=8,MONTH(F119)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",89,0,0,"2029-07-17",30,{"$f":"IF(OR(B120=\"PG\",B120=\"\"),0, E120*(1/(1+TED)^SUMIF(B$32:B120,\"PP\",G$32:G120)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA120=0,0,AA120-IF(AND(TIPO_CUOTA=2,OR(MONTH(F120)=8,MONTH(F120)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",90,0,0,"2029-08-17",31,{"$f":"IF(OR(B121=\"PG\",B121=\"\"),0, E121*(1/(1+TED)^SUMIF(B$32:B121,\"PP\",G$32:G121)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA121=0,0,AA121-IF(AND(TIPO_CUOTA=2,OR(MONTH(F121)=8,MONTH(F121)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",91,0,0,"2029-09-17",31,{"$f":"IF(OR(B122=\"PG\",B122=\"\"),0, E122*(1/(1+TED)^SUMIF(B$32:B122,\"PP\",G$32:G122)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA122=0,0,AA122-IF(AND(TIPO_CUOTA=2,OR(MONTH(F122)=8,MONTH(F122)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",92,0,0,"2029-10-17",30,{"$f":"IF(OR(B123=\"PG\",B123=\"\"),0, E123*(1/(1+TED)^SUMIF(B$32:B123,\"PP\",G$32:G123)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA123=0,0,AA123-IF(AND(TIPO_CUOTA=2,OR(MONTH(F123)=8,MONTH(F123)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",93,0,0,"2029-11-17",31,{"$f":"IF(OR(B124=\"PG\",B124=\"\"),0, E124*(1/(1+TED)^SUMIF(B$32:B124,\"PP\",G$32:G124)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA124=0,0,AA124-IF(AND(TIPO_CUOTA=2,OR(MONTH(F124)=8,MONTH(F124)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",94,0,0,"2029-12-17",30,{"$f":"IF(OR(B125=\"PG\",B125=\"\"),0, E125*(1/(1+TED)^SUMIF(B$32:B125,\"PP\",G$32:G125)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA125=0,0,AA125-IF(AND(TIPO_CUOTA=2,OR(MONTH(F125)=8,MONTH(F125)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",95,0,0,"2030-01-17",31,{"$f":"IF(OR(B126=\"PG\",B126=\"\"),0, E126*(1/(1+TED)^SUMIF(B$32:B126,\"PP\",G$32:G126)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA126=0,0,AA126-IF(AND(TIPO_CUOTA=2,OR(MONTH(F126)=8,MONTH(F126)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[null,"",96,0,0,"2030-02-17",31,{"$f":"IF(OR(B127=\"PG\",B127=\"\"),0, E127*(1/(1+TED)^SUMIF(B$32:B127,\"PP\",G$32:G127)))","v":0},-5.8727518781921617E-2,0,0,0,0,0,0,0,0,0,0,-5.8727518781921617E-2,-5.8727518781921617E-2,null,null,null,null,null,0,{"$f":"+IF(AA127=0,0,AA127-IF(AND(TIPO_CUOTA=2,OR(MONTH(F127)=8,MONTH(F127)=12)),2*Datos!$C$31,Datos!$C$31))","v":0}]
[]
[null,null,null,null,null,"TOTALES A PAGAR:",null,null,null,{"$f":"SUMIF(B32:B127,\"PP\",J32:J127)","v":5642.5827327495299},{"$f":"SUM(K32:K127)","v":0.93151498716428627},{"$f":"SUMIF(B32:B127,\"PP\",L32:L127)","v":3083.6466917392036},4.5650259938866844E-2,{"$f":"SUMIF(B32:B127,\"PP\",N32:N127)","v":151.11983211463206},{"$f":"SUM(O32:O127)","v":3234.766523853837},0,0,0,8877.3492566033765]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"La solicitud de crédito está sujeta a evaluación, el desembolso y vencimiento del crédito dependerán de dicha evaluación. Los datos emitidos por este simulador son referenciales."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Fecha de Desembolso: para efectos de esta simulación, la fecha de desembolso es el día de realizada la misma."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"El monto de la cuota incluye: (i) seguro de desgravamen individual; (ii) el envío físico de informe de pago (el cliente tiene la opción de elegir: (1) envío físico (con costo), (2) virtual (sin costo), (3) ambos o (4) ninguno). Para (i) n caso de contar con un seguro de vida personal, ud tiene la opción de endosarlo en cualquier momento y sin costo adicional, siempre y cuando este brinde coberturas, condiciones y plazos iguales o superiores al seguro ofrecido por Interbank. Para mayor información con respecto a condiciones, coberturas y procedimientos ingresar a www.interbank.pe.\nEl seguro de desgravamen tiene una prima de 0.075% y es otorgado por Interseguro. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"La simulación no incluye el ITF."]