{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["HOME","CP Y CAV SIN AVAL","Hoja2","Hoja3","CP Y CAV CON AVAL","LARGO PLAZO","Hoja1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":8,"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":"HOME","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CP Y CAV SIN AVAL","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,1,9,5],[18,1,18,5],[16,2,16,4],[29,2,29,4]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Seleccione perfil de Cliente:",null,"Condiciones del perfil"]
[null,null,{"$f":"+IF(C13=\"Semestral\",\"6\",IF(C13=\"Anual\",\"12\",0))","v":0},null,null,null,null,"Documentación requerida:",{"$f":"+IF(I7=\"Transportador\",Hoja2!B5,IF(I7=\"Jubilado\",Hoja2!B2,IF(I7=\"Empleado\",Hoja2!B3,IF(I7=\"Independiente/ Profesional Independiente\",Hoja2!B4,0))))","v":0},{"$f":"+IF(I7=\"Empleado\",\"*Si tiene contrato a termino fijo, la duración del contrato debe ser minimo de 6 meses.  * Si tiene contrato a termino indefinido, la duración del contrato debe se de minimo 2 meses\",IF(I7=\"Independiente/ Profesional Independiente\",\"El tiempo en la actividad economica que desarrolla debe ser minimo de 12 meses\",IF(I7=\"Transportador\",\"El tiempo en la actividad economica que desarrolla debe ser minimo de 12 meses\",\"N/A\")))","v":"N/A"}]
[]
[null,"CORTO PLAZO"]
[]
[null,"Diligenciar los siguientes campos:"]
[null,"Duración de un periodo de estudio:",null,null,"Tasa:",2.2800000000000001E-2]
[null,"Valor de periodo académico a financiar :",null,null,"Cuota Fija de capital e intereses:",{"$f":"+PMT(F13,C13,-(C14))","v":{"$error":"#NUM!"}}]
[null,null,null,null,"Seguro de vida",{"$f":"+IF(AND(C14<=20000000,C14>0),13087,IF(AND(C14>20000000,C14<=60000000),23155,IF(C14>60000000,29195,\"No Aplica\")))","v":"No Aplica"}]
[]
[null,"Total Valor a Pagar Mensual",{"$f":"+F14+F15","v":{"$error":"#NUM!"}},{"$f":"+#REF!+F15+F14","v":{"$error":"#REF!"}}]
[]
[null,"CE ÚNICO DESEMBOLSO"]
[]
[]
[null,"Diligenciar los siguientes campos:"]
[]
[null,"Plazo",null,null,"Tasa:",2.2800000000000001E-2]
[null,"Valor de periodo académico a financiar (Desde 1 Millón):",null,null,"Cuota Fija de capital e intereses:",{"$f":"+PMT(F24,C24,-(C25))","v":{"$error":"#NUM!"}}]
[null,null,null,null,"Seguro de vida",{"$f":"+IF(AND(C25<=20000000,C25>0),13087,IF(AND(C25>20000000,C25<=60000000),23155,IF(C25>60000000,29195,\"No Aplica\")))","v":"No Aplica"}]
[]
[]
[]
[null,"Total Valor a Pagar",{"$f":"+F26+F25","v":{"$error":"#VALUE!"}}]

{"sheet":"Hoja2","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Perfil ","Documentos Solicitado"]
["Jubilado","*Solicitud de crédito Sufi (Crédito para estudiar).  *Fotocopia de la cédula de ciudadanía al 150%.  *Recibo de matrícula.  *Extractos bancarios de los últimos tres meses ó las últimas 3 colillas de pago de la pensión.  *Seguro de vida"]
["Empleado","*Solicitud de crédito Sufi (Crédito para estudiar).  *Fotocopia de la cédula de ciudadanía al 150%.  *Carta laboral indicando: salario, cargo y antigüedad. *Recibo de matrícula. *Seguro de vida","*Si es empleado y tiene contrato a termino fijola duración del contrato debe ser 12 meses. *Si tiene contrato a terminoindefinido, la duración del contrato debe ser minimo de 6 meses."]
["Independiente/ Profesional Independiente","*Solicitud de crédito Sufi (Crédito para estudiar).  *Fotocopia de la cédula de ciudadanía al 150%.  *Copia de la declaración de renta ó Extractos bancarios de los últimos tres meses.  *Recibo de matrícula.  *Certificado de cámara de comercio vigente, registro mercantil ó referencias comerciales.  *Seguro de vida","El tiempo en la actividad economica que desarrolla debe ser minimo de 12 meses"]
["Transportador","*Solicitud de crédito Sufi (Crédito para estudiar). *Fotocopia de la cédula de ciudadanía al 150%.  *Certificado de cámara de comercio vigente, registro mercantil o referencias comerciales .  *Copia de las tarjetas de propiedad de los vehículos de transporte que posee el cliente.  *Carta de afiliación de vehículos a las empresas de transporte.  *Recibo de matrícula.  *Copia de la declaración de renta ó Extractos bancarios de los últimos tres meses. *Seguro de vida","El tiempo en la actividad economica que desarrolla debe ser minimo de 24 meses"]

{"sheet":"Hoja3","index":3,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,1,0],[1,5,2,5]]}
["Duración de un periodo de estudio","Semestral",6,null,null,null,null,null,null,"Periodos a financiar",null,"% a financiar durante el periodo academico"]
[null,"Anual",12,null,null,null,null,null,null,1,null,0.4]
[null,null,null,null,null,null,null,null,null,2,null,0.41]
[null,null,null,null,null,null,null,null,null,3,null,0.42]
[null,null,null,null,null,null,null,null,null,4,null,0.43]
["Rango Monto",null,null,null,null,null,null,null,null,5,null,0.44]
["$ 500,000- $ 5,000,000",null,null,null,null,null,null,null,null,6,null,0.45]
["$5,000,000-$ 9,999,999",null,null,null,null,null,null,null,null,7,null,0.46]
["Más de $ 10,000,000",null,null,null,null,null,null,null,null,8,null,0.47]
[null,null,null,null,null,null,null,null,null,9,null,0.48]
[null,null,null,null,null,null,null,null,null,10,null,0.49]
["Requiere avalista","Si",null,null,null,null,null,null,null,11,null,0.5]
[null,"No",null,null,null,null,null,null,null,12,null,0.50999999999999901]
[null,null,null,null,null,null,null,null,null,13,null,0.51999999999999902]
[null,"Plazos",null,null,null,null,null,null,null,14,null,0.52999999999999903]
["plazo",24,null,null,null,null,null,null,null,15,null,0.53999999999999904]
[null,36,null,null,null,null,null,null,null,16,null,0.54999999999999905]
[null,48,null,null,null,null,null,null,null,17,null,0.55999999999999905]
[null,60,null,null,null,null,null,null,null,18,null,0.56999999999999895]
[null,null,null,null,null,null,null,null,null,19,null,0.57999999999999896]
[null,null,null,null,null,null,null,null,null,20,null,0.58999999999999897]
[null,null,null,null,null,null,null,null,null,null,null,0.59999999999999898]
[null,null,null,null,null,null,null,null,null,null,null,0.60999999999999899]
[null,null,null,null,null,null,null,null,null,null,null,0.619999999999999]
[null,null,null,null,null,null,null,null,null,null,null,0.62999999999999901]
[null,null,null,null,null,null,null,null,null,null,null,0.63999999999999901]
[null,null,null,null,null,null,null,null,null,null,null,0.64999999999999902]
[null,null,null,null,null,null,null,null,null,null,null,0.65999999999999903]
[null,null,null,null,null,null,null,null,null,null,null,0.66999999999999904]
[null,null,null,null,null,null,null,null,null,null,null,0.67999999999999905]
[null,null,null,null,null,null,null,null,null,null,null,0.68999999999999895]
[null,null,null,null,null,null,null,null,null,null,null,0.69999999999999896]
[null,null,null,null,null,null,null,null,null,null,null,0.70999999999999897]
[null,null,null,null,null,null,null,null,null,null,null,0.71999999999999897]
[null,null,null,null,null,null,null,null,null,null,null,0.72999999999999798]
[null,null,null,null,null,null,null,null,null,null,null,0.73999999999999799]
[null,null,null,null,null,null,null,null,null,null,null,0.749999999999998]
[null,null,null,null,null,null,null,null,null,null,null,0.75999999999999801]
[null,null,null,null,null,null,null,null,null,null,null,0.76999999999999802]
[null,null,null,null,null,null,null,null,null,null,null,0.77999999999999803]
[null,null,null,null,null,null,null,null,null,null,null,0.78999999999999804]
[null,null,null,null,null,null,null,null,null,null,null,0.79999999999999805]
[null,null,null,null,null,null,null,null,null,null,null,0.80999999999999805]
[null,null,null,null,null,null,null,null,null,null,null,0.81999999999999795]
[null,null,null,null,null,null,null,null,null,null,null,0.82999999999999796]
[null,null,null,null,null,null,null,null,null,null,null,0.83999999999999797]
[null,null,null,null,null,null,null,null,null,null,null,0.84999999999999798]
[null,null,null,null,null,null,null,null,null,null,null,0.85999999999999799]
[null,null,null,null,null,null,null,null,null,null,null,0.869999999999998]
[null,null,null,null,null,null,null,null,null,null,null,0.87999999999999801]
[null,null,null,null,null,null,null,null,null,null,null,0.88999999999999801]
[null,null,null,null,null,null,null,null,null,null,null,0.89999999999999802]
[null,null,null,null,null,null,null,null,null,null,null,0.90999999999999803]
[null,null,null,null,null,null,null,null,null,null,null,0.91999999999999804]
[null,null,null,null,null,null,null,null,null,null,null,0.92999999999999805]
[null,null,null,null,null,null,null,null,null,null,null,0.93999999999999795]
[null,null,null,null,null,null,null,null,null,null,null,0.94999999999999796]
[null,null,null,null,null,null,null,null,null,null,null,0.95999999999999797]
[null,null,null,null,null,null,null,null,null,null,null,0.96999999999999797]
[null,null,null,null,null,null,null,null,null,null,null,0.97999999999999798]
[null,null,null,null,null,null,null,null,null,null,null,0.98999999999999799]

{"sheet":"CP Y CAV CON AVAL","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,1,8,5],[19,1,19,5],[17,2,17,4],[31,2,31,4]]}
[]
[]
[]
[]
[]
[]
[null,"APLICA PARA:"]
[]
[null,"CORTO PLAZO"]
[]
[null,"Diligenciar los siguientes campos:"]
[null,"Duración de un periodo de estudio (meses):",null,null,"Tasa:",2.2700000000000001E-2]
[null,"Valor de periodo académico a financiar :",null,null,"Cuota Fija de capital e intereses:",{"$f":"+PMT(F12,C12,-C16)","v":{"$error":"#NUM!"}}]
[null,null,null,null,"Seguro de vida",{"$f":"+IF(AND(C13<=20000000,C13>0),13087,IF(AND(C13>20000000,C13<=60000000),23155,IF(C13>60000000,29195,\"No Aplica\")))","v":"No Aplica"}]
[]
[null,"Capital Total a Financiar",{"$f":"+F16+C13","v":0},null,"Comisión aprobación inmediata",{"$f":"+((C13/(1-(7%*1.19)))*7%*1.19)","v":0}]
[]
[null,"Total Valor a Pagar Mensual",{"$f":"+F14+F13","v":{"$error":"#VALUE!"}},{"$f":"+F15+F14+F13","v":{"$error":"#VALUE!"}}]
[]
[null,"CE ÚNICO DESEMBOLSO"]
[]
[]
[null,"Diligenciar los siguientes campos:"]
[]
[null,"Plazo",null,null,"Tasa:",2.2800000000000001E-2]
[null,"Valor de periodo académico a financiar (Desde 1 Millón):",null,null,"Cuota Fija de capital e intereses:",{"$f":"+PMT(F25,C25,-(C30))","v":{"$error":"#NUM!"}}]
[null,null,null,null,"Seguro de vida",{"$f":"+IF(AND(C26>0,C26<=20000000),13087,IF(AND(C26>20000000,C26<=60000000),23155,IF(C26>60000000,29195,\"No Aplica\")))","v":"No Aplica"}]
[]
[null,null,null,null,"Comisión aprobación inmediata",{"$f":"+((C26/(1-(7%*1.19)))*7%*1.19)","v":0}]
[null,"Capital Total a Financiar",{"$f":"+F29+C26","v":0}]
[]
[null,"Total Valor a Pagar",{"$f":"F27+F26","v":{"$error":"#VALUE!"}}]

{"sheet":"LARGO PLAZO","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,2,17,4],[19,2,19,4]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Seleccione perfil de Cliente:",null,"Condiciones del perfil"]
[null,null,null,null,null,null,null,"Documentación requerida:",{"$f":"+IF(I7=\"Transportador\",Hoja2!B5,IF(I7=\"Jubilado\",Hoja2!B2,IF(I7=\"Empleado\",Hoja2!B3,IF(I7=\"Independiente/ Profesional Independiente\",Hoja2!B4,0))))","v":0},{"$f":"+IF(I7=\"Empleado\",Hoja2!C3,IF(I7=\"Independiente/ Profesional Independiente\",Hoja2!C4,IF('LARGO PLAZO'!I7=\"Transportador\",Hoja2!C5,\"No Aplica\")))","v":"No Aplica"}]
[null,"Diligenciar los siguientes campos:"]
[null,"Duración de un periodo de estudio (meses):",null,null,"Tasa:",1.95E-2]
[null,"Valor de periodo académico a financiar :",null,null,"Seguro de vida",{"$f":"+IF(AND(C11<=20000000,C11>0,C14=\"No\"),13087,IF(AND(C11<=20000000,C11>0,C14=\"Si\"),26174,IF(AND(C11>20000000,C11<=60000000,C14=\"No\"),23155,IF(AND(C11>20000000,C11<=60000000,C14=\"Si\"),46310,IF(AND(C11>60000000,C14=\"No\"),29195,IF(AND(C11>60000000,C14=\"Si\"),58390,\"No Aplica\"))))))","v":"No Aplica"}]
[null,"Número de periodos a financiar",null,null,"Cuota Fija de capital e intereses durante la carrera:",{"$f":"+Hoja1!B9","v":{"$error":"#NUM!"}}]
[null,"Porcentaje a pagar durante el periodo academico",null,null,"Cuota Fija de capital e intereses despues de la carrera:",{"$f":"+Hoja1!B10","v":0}]
[null,"Requiere avalista?",null,null,"Plazo para Pagar crédito despúes de saldado",60]
[]
[]
[]
[null,"Total Valor a Pagar Mensual durante el periodo académico",{"$f":"+F12+F11","v":{"$error":"#NUM!"}}]
[]
[null,"Total Valor a Pagar Mensual despúes del periodo académico",{"$f":"+F11+F13","v":{"$error":"#VALUE!"}}]

{"sheet":"Hoja1","index":6,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DESEMBOLSO",{"$f":"+'LARGO PLAZO'!C11","v":0}]
["TASA",{"$f":"+'LARGO PLAZO'!F10","v":1.95E-2},null,null,null,1,{"$f":"+B3","v":0},{"$f":"IF(F2<=B7,(B6*B1),0)","v":0},{"$f":"(H2*$B$2)*$G$2","v":0}]
["MESES CP",{"$f":"+'LARGO PLAZO'!C10","v":0},null,null,null,2,{"$f":"+G2+$B$3","v":0},{"$f":"IF(F3<=$B$7,(($B$6*$B$1)+H2),0)","v":0},{"$f":"+(H3*$B$2)*$G$2","v":0}]
["MESES LP",{"$f":"+'LARGO PLAZO'!F14","v":60},null,null,null,3,{"$f":"+G3+$B$3","v":0},{"$f":"IF(F4<=$B$7,(($B$6*$B$1)+H3),0)","v":0},0]
["% CP",{"$f":"+'LARGO PLAZO'!C13","v":0},null,null,null,4,{"$f":"+G4+$B$3","v":0},0,0]
["% LP",{"$f":"100%-B5","v":1},null,null,null,5,0,0,0]
["NUMERO DE SEMESTRES A FINANCIAR",{"$f":"+'LARGO PLAZO'!C12","v":0},null,null,null,6,0,0,0]
[null,null,null,null,null,7,0,0,0]
["TOTAL CUOTA DURANTE LA CARRERA",{"$f":"+PMT(B2,B3,-(B1*B5))","v":{"$error":"#NUM!"}},null,null,null,8,0,0,0]
["TOTAL CUOTA DESPUES DE LA CARRERA",{"$f":"+PMT(B2,B4,-I23)","v":0},null,null,null,9,0,0,0]
[null,null,null,null,null,10,0,0,0]
[null,null,null,null,null,11,0,0,0]
[null,null,null,null,null,12,0,0,0]
[null,null,null,null,null,13,0,0,0]
[null,null,null,null,null,14,0,0,0]
[null,null,null,null,null,15,0,0,0]
[null,null,null,null,null,16,0,0,0]
[null,null,null,null,null,17,0,0,0]
[null,null,null,null,null,18,0,0,0]
[null,null,null,null,null,19,0,0,0]
[null,null,null,null,null,20,0,0,0]
[null,null,null,null,null,null,null,{"$f":"+MAX(H2:H21)","v":0},{"$f":"+SUM(I2:I21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+I22+H22","v":0}]