{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Simulador ","Configuracion "],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":1,"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":"Simulador ","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[25,6,26,8],[9,3,9,4],[9,6,9,10],[10,3,10,4],[11,3,11,4],[20,2,21,8],[7,2,7,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"SIMULADOR CRÉDITO INSTITUCIONAL "]
[]
[]
[null,null,"Por favor diligenciar los campos en Verde:"]
[]
[null,null,"CONCEPTOS","VALOR",null,null,"AMORTIZACIÓN"]
[null,null,"VALOR TOTAL MATRÍCULA:",10000000,null,null,"# CUOTAS","VALOR CUOTA FIJA MENSUAL","ABONO A CAPITAL","INTERÉS CORRIENTE","SALDO CAPITAL"]
[null,null,"% CUOTA INICIAL:",0.5,null,null,"CUOTA INICIAL",{"$f":"+D14","v":5000000},{"$f":"+H12","v":5000000},0,{"$f":"+D16","v":5000000}]
[null,null,"NÚMERO DE CUOTAS:",5,null,null,1,{"$f":"IF($G13<=$D$13,ABS(PMT($D$15,$D$13,$D$16)),0)","v":1022915.0803769253},{"$f":"IFERROR(H13-J13,0)","v":984915.0803769253},{"$f":"IFERROR(ABS(IPMT($D$15,$G13,$D$13,$D$16)),0)","v":38000},{"$f":"IFERROR(+K12-I13,0)","v":4015084.9196230746}]
[null,null,"VALOR CUOTA INICIAL",{"$f":"D12*D11","v":5000000},null,null,2,{"$f":"IF($G14<=$D$13,ABS(PMT($D$15,$D$13,$D$16)),0)","v":1022915.0803769253},{"$f":"IFERROR(H14-J14,0)","v":992400.43498778995},{"$f":"IFERROR(ABS(IPMT($D$15,$G14,$D$13,$D$16)),0)","v":30514.64538913537},{"$f":"IFERROR(+K13-I14,0)","v":3022684.4846352846}]
[null,null,"INTERÉS CORRIENTE N.M.V",7.6E-3,null,null,3,1022915.0803769253,{"$f":"IFERROR(H15-J15,0)","v":999942.67829369707},{"$f":"IFERROR(ABS(IPMT($D$15,$G15,$D$13,$D$16)),0)","v":22972.402083228175},2022741.8063415876]
[null,null,"VALOR A FINANCIAR",{"$f":"D11-D14","v":5000000},null,null,4,1022915.0803769253,{"$f":"IFERROR(H16-J16,0)","v":1007542.2426487292},{"$f":"IFERROR(ABS(IPMT($D$15,$G16,$D$13,$D$16)),0)","v":15372.837728196073},{"$f":"IFERROR(+K15-I16,0)","v":1015199.5636928583}]
[null,null,"CUOTAS FIJA MENSUAL",{"$f":"ABS(PMT(D15,D13,D16))","v":1022915.0803769253},null,null,5,1022915.0803769253,1015199.5636928596,7715.5166840657321,-1.280568540096283E-9]
[null,null,null,null,null,null,"VALOR DE LA CUOTA CON INTERÉS:",{"$f":"SUM(H12:H17)","v":10114575.401884625},{"$f":"SUM(I12:I17)","v":10000000.000000002},{"$f":"SUM(J12:J17)","v":114575.40188462535}]
[]
[null,null,"Tener en cuenta"]
[null,null,"El cálculo presentado es resultado de una simulación, es aproximado e informativo y puede presentar variaciones. Este resultado no compromete a la universidad, ni constituye una asesoría.\n\n"]

{"sheet":"Configuracion ","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"% Cuota Inicial ",null,"# de cuotas"]
[null,0.2,null,1]
[null,0.25,null,2]
[null,0.3,null,3]
[null,0.35,null,4]
[null,0.4,null,5]
[null,0.45]
[null,0.5]
[null,0.55000000000000004]
[null,0.6]
[null,0.65]
[null,0.7]
[null,0.75]
[null,0.8]