{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MENU","DescuentoSimple","InteresSimple","ConversionTasas","InteresCompuesto","GradLineal","GradGeometrico","Borrador","Hoja2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":"MENU","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DescuentoSimple","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"DESCUENTO SIMPLE"]
[null,"Variable a calcular","Valor a Descuento"]
[null,"Valor Nominal",1000]
[null,"Valor a Descuento",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G5:L5)","v":0}]
[null,"Número de Periodos",2,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G6:L6)","v":0}]
[null,"Tasa de descuento(Interes Periodico)",0.01,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M5:M6)","v":0}]
[]
[null,"Resultado",{"$f":"IFERROR(VLOOKUP(C3,Hoja2!A51:B54,2,FALSE),\"\")","v":980},null,{"$f":"+IF(C9<1,C9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"G2-M7","v":0}]

{"sheet":"InteresSimple","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"INTERES SIMPLE"]
[null,"Variable a calcular","Valor Futuro"]
[null,"Número de Periodos",1]
[null,"Interes Periodico",2.4695076595959931E-2]
[null,"Valor Presente",200000000,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G6:L6)","v":0}]
[null,"Valor Futuro",{"$f":"+C9*(1+0.02*18)","v":278717060.83410108},null,null,null,null,null,null,null,null,null,{"$f":"SUM(F7:L7)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M7)","v":0}]
[null,"Resultado",{"$f":"IFERROR(VLOOKUP(C3,Hoja2!A45:B48,2,FALSE),\"\")","v":204939015.31919199},null,{"$f":"+IF(C9<1,C9,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-M8","v":{"$error":"#REF!"}}]

{"sheet":"ConversionTasas","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"CONVERSION DE TASAS"]
[null,"Tasa a Convertir",0.03]
[null,"Tipo de Tasa","Nominal Anticipada"]
[null,"Periodicidad","Mensual"]
[null,"Tasa a calcular","Efectiva Anual"]
[null,"Periodicidad","Trimestral"]
[]
[null,"RESULTADO",{"$f":"+VLOOKUP(C6,Hoja2!A92:B96,2,FALSE)","v":3.0493241249915926E-2}]

{"sheet":"InteresCompuesto","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"INTERES COMPUESTO",null,null,"TIPO","VENCIDA"]
[null,"Variable a calcular","Cuota(VF)"]
[null,"Pago"]
[null,"Número de Periodos",48]
[null,"Interes Periodico",5.0894420148950292E-3]
[null,"Valor Presente"]
[null,"Valor Futuro",50000000]
[]
[null,"Resultado",{"$f":"IFERROR(VLOOKUP(C3,Hoja2!A26:B37,2,FALSE),\"\")","v":922241.36379018601},null,{"$f":"+IF(C10<1,C10,\"\")","v":""}]

{"sheet":"GradLineal","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"GRADENTE LINEAL"]
[null,"Variable a calcular","Pago 1 VP"]
[null,"Pago 1"]
[null,"Número de Periodos",16]
[null,"Interes Periodico",{"$f":"+NOMINAL(25%,4)/4","v":5.7371263440564091E-2}]
[null,"Gradiente",100000]
[null,"Valor Presente",50000000]
[null,"Valor Futuro"]
[]
[null,"Resultado",{"$f":"IFERROR(VLOOKUP(C3,Hoja2!A1:B7,2,FALSE),\"\")","v":4225671.6542906035}]

{"sheet":"GradGeometrico","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"GRADENTE GEOMETRICO"]
[null,"Variable a calcular","Valor Presente i ≠ g"]
[null,"Pago 1",300000]
[null,"Número de Periodos",{"$f":"8*12","v":96}]
[null,"Interes Periodico",2.0578481698766193E-2]
[null,"Gradiente",0.01,null,"Resultado",{"$f":"IFERROR(VLOOKUP(C3,Hoja2!A13:B22,2,FALSE),\"\")","v":17929207.656238988}]
[null,"Valor Presente i ≠ g"]
[null,"Valor Presente i = g"]
[null,"Valor Futuro i ≠ g"]
[null,"Valor Futuro i = g"]

{"sheet":"Borrador","index":7,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["VP",5000000]
["N",3,"AÑOS"]
["I",4.6294672459277431E-2,"EA"]
["VF",{"$f":"FV(B3,B2,,-B1)","v":5727064.1303066127}]
[null,null,null,0.03,{"$f":"+D5/12","v":2.5000000000000001E-3}]
["VP",2000000,null,null,{"$f":"+E5/(1-E5)","v":2.5062656641604009E-3}]
["VF",2721000,null,{"$f":"NPER(E6,,-B6,B7)","v":122.98692134065921}]
["I",3.0493241249915926E-2,"EA"]
["N",{"$f":"NPER(B8,,-B6,B7)","v":10.248910111721406},"AÑOS",{"$f":"+B9*12","v":122.98692134065686}]
[]
["VP",2000000]
["VF",2300000]
["N",1.25,"AÑOS"]
["I",{"$f":"RATE(B13,,-B11,B12)","v":0.11829986451586223},"EA"]
[]
["VP",2000000]
["VF",2300000]
["N",15]
["I",{"$f":"RATE(B18,,-B16,B17)","v":9.3610055124792001E-3},"PMV"]
[null,null,{"$f":"B19*12","v":0.1123320661497504}]
[null,null,{"$f":"EFFECT(C20,12)","v":0.11829986451586083}]
[]
["IC","DC"]
["VF","VN"]
["VP","VD"]
["N","N"]
["I","I"]
[]
["VN",2000000]
["VD",{"$f":"+B29-3%*2000000","v":1940000}]
["N",5.2777777777777778E-2]
["I",{"$f":"RATE(B31,,-B30,B29)","v":0.78090529199892689},"EA"]
[]
["VN",5000000]
["VD",{"$f":"+B34-4%*B34","v":4800000}]
["N",9.7222222222222224E-2]
["I",{"$f":"RATE(B36,,B35,-B34)","v":0.52178406295389923}]
[]
["VN",1000000]
["N",3.888888888888889E-2]
["I",{"$f":"+(1+7.93%)*(1+5%)-1","v":0.13326499999999997},null,"5% Ntv",5]
["VD",{"$f":"PV(B41,B40,,-B39)","v":995146.70476478082}]
[null,null,null,"10%NTV"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+B61","v":0}]
[null,null,null,{"$f":"+B68","v":0}]
[null,null,null,{"$f":"+B70","v":0}]
[null,null,null,{"$f":"+B75","v":0}]

{"sheet":"Hoja2","index":8,"n_rows":105,"n_cols":2,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
["Pago en Periodo N",{"$f":"+GradLineal!C4+(GradLineal!C5-1)*GradLineal!C7","v":1500000}]
["Valor Presente",{"$f":"+GradLineal!C4*((1+GradLineal!C6)^GradLineal!C5-1)/((1+GradLineal!C6)^GradLineal!C5*GradLineal!C6)+GradLineal!C7/GradLineal!C6*(((1+GradLineal!C6)^GradLineal!C5-1)/((1+GradLineal!C6)^GradLineal!C5*GradLineal!C6)-(GradLineal!C5/((1+GradLineal!C6)^GradLineal!C5)))","v":6514178.0906082168}]
["Valor Futuro",{"$f":"+GradLineal!C4*(((1+GradLineal!C6)^GradLineal!C5-1)/GradLineal!C6)+GradLineal!C7/GradLineal!C6*((((1+GradLineal!C6)^GradLineal!C5-1)/GradLineal!C6)-GradLineal!C5)","v":15903755.104023946}]
["Pago 1 VP",{"$f":"+(GradLineal!C8-(GradLineal!C7/GradLineal!C6*(((1+GradLineal!C6)^GradLineal!C5-1)/((1+GradLineal!C6)^GradLineal!C5*GradLineal!C6)-(GradLineal!C5/((1+GradLineal!C6)^GradLineal!C5)))))/(((1+GradLineal!C6)^GradLineal!C5-1)/((1+GradLineal!C6)^GradLineal!C5*GradLineal!C6))","v":4225671.6542906035}]
["Pago 1 VF",{"$f":"+(GradLineal!C9-GradLineal!C7/GradLineal!C6*((((1+GradLineal!C6)^GradLineal!C5-1)/GradLineal!C6)-GradLineal!C5))/(((1+GradLineal!C6)^GradLineal!C5-1)/GradLineal!C6)","v":-633005.80510676699}]
["Anualidad Equivalente",{"$f":"+GradLineal!C4+GradLineal!C7*((1/GradLineal!C6)-(GradLineal!C5/((1+GradLineal!C6)^GradLineal!C5-1)))","v":633005.80510676687}]
["Gradiente Perpetuo",{"$f":"+(GradLineal!C4/GradLineal!C6)+(GradLineal!C7/(GradLineal!C6^2))","v":30381637.092296783}]
[]
[]
[]
[]
[]
["Pago en Periodo N",{"$f":"+GradGeometrico!C4*(1+GradGeometrico!C7)^(GradGeometrico!C5-1)","v":772061.26501763938}]
["Valor Presente i ≠ g",{"$f":"+GradGeometrico!C4*(((1+GradGeometrico!C6)^GradGeometrico!C5-(1+GradGeometrico!C7)^GradGeometrico!C5)/((GradGeometrico!C6-GradGeometrico!C7)*(1+GradGeometrico!C6)^GradGeometrico!C5))","v":17929207.656238988}]
["Valor Presente i = g",{"$f":"+GradGeometrico!C4*GradGeometrico!C5/(1+GradGeometrico!C6)","v":28219289.860062525}]
["Valor Futuro i ≠ g",{"$f":"+GradGeometrico!C4*(((1+GradGeometrico!C7)^GradGeometrico!C5-(1+GradGeometrico!C6)^GradGeometrico!C5)/(GradGeometrico!C7-GradGeometrico!C6))","v":126711546.94419801}]
["Valor Futuro i = g",{"$f":"+GradGeometrico!C4*GradGeometrico!C5*(1+GradGeometrico!C6)^(GradGeometrico!C5-1)","v":199434907.57612884}]
["Pago 1 V P i ≠ g",{"$f":"+GradGeometrico!C8/(((1+GradGeometrico!C6)^GradGeometrico!C5-(1+GradGeometrico!C7)^GradGeometrico!C5)/((GradGeometrico!C6-GradGeometrico!C7)*(1+GradGeometrico!C6)^GradGeometrico!C5))","v":0}]
["Pago 1 V P i = g",{"$f":"+GradGeometrico!C9/(GradGeometrico!C5/(1+GradGeometrico!C6))","v":0}]
["Pago 1 V F i ≠ g",{"$f":"+GradGeometrico!C10/(((1+GradGeometrico!C7)^GradGeometrico!C5-(1+GradGeometrico!C6)^GradGeometrico!C5)/(GradGeometrico!C7-GradGeometrico!C6))","v":0}]
["Pago 1 V F i = g",{"$f":"+GradGeometrico!C11/(GradGeometrico!C5*(1+GradGeometrico!C6)^(GradGeometrico!C5-1))","v":0}]
["Gradiente Perpetuo",{"$f":"+GradGeometrico!C4/(GradGeometrico!C6-GradGeometrico!C7)","v":28359457.296692219}]
[]
[]
[]
["Valor Presente(anualidad)",{"$f":"PV(InteresCompuesto!C6,InteresCompuesto!C5,-InteresCompuesto!C4,,B39)","v":0}]
["Valor Futuro(anualidad)",{"$f":"FV(InteresCompuesto!C6,InteresCompuesto!C5,-InteresCompuesto!C4,,B39)","v":0}]
["Numero de Periodos(anualidad VP)",{"$f":"NPER(InteresCompuesto!C6,InteresCompuesto!C4,-InteresCompuesto!C7,,B39)","v":{"$error":"#NUM!"}}]
["Numero de Periodos(anualidad VF)",{"$f":"NPER(InteresCompuesto!C6,-InteresCompuesto!C4,,InteresCompuesto!C8,B39)","v":{"$error":"#NUM!"}}]
["Interes Periodico(anualidad VP)",{"$f":"RATE(InteresCompuesto!C5,-InteresCompuesto!C4,InteresCompuesto!C7,,B39)","v":{"$error":"#NUM!"}}]
["Interes Periodico(anualidad VF)",{"$f":"RATE(InteresCompuesto!C5,-InteresCompuesto!C4,,InteresCompuesto!C8,B39)","v":{"$error":"#NUM!"}}]
["Valor Presente",{"$f":"+PV(InteresCompuesto!C6,InteresCompuesto!C5,,-InteresCompuesto!C8,B39)","v":39187167.971885078}]
["Valor Futuro",{"$f":"FV(InteresCompuesto!C6,InteresCompuesto!C5,,-InteresCompuesto!C7,B39)","v":0}]
["Numero de Periodos",{"$f":"NPER(InteresCompuesto!C6,,-InteresCompuesto!C7,InteresCompuesto!C8,B39)","v":{"$error":"#NUM!"}}]
["Interes Periodico",{"$f":"RATE(InteresCompuesto!C5,,InteresCompuesto!C7,-InteresCompuesto!C8,B39)","v":{"$error":"#NUM!"}}]
["Cuota(VP)",{"$f":"PMT(InteresCompuesto!C6,InteresCompuesto!C5,-InteresCompuesto!C7,,B39)","v":0}]
["Cuota(VF)",{"$f":"PMT(InteresCompuesto!C6,InteresCompuesto!C5,,-InteresCompuesto!C8,B39)","v":922241.36379018601}]
[]
["ANUALIDAD",{"$f":"+IF(InteresCompuesto!F2=\"VENCIDA\",0,1)","v":0}]
[]
["VENCIDA"]
["ANTICIPADA"]
[]
[]
["Numero de Periodos",{"$f":"+(InteresSimple!C7/InteresSimple!C6-1)/InteresSimple!C5","v":15.937804551490848}]
["Interes Periodico",{"$f":"+(InteresSimple!C7/InteresSimple!C6-1)/InteresSimple!C4","v":0.3935853041705053}]
["Valor Presente",{"$f":"+InteresSimple!C7/(1+InteresSimple!C5*InteresSimple!C4)","v":272000000}]
["Valor Futuro",{"$f":"+InteresSimple!C6*(1+InteresSimple!C4*InteresSimple!C5)","v":204939015.31919199}]
[]
[]
["Valor Nominal",{"$f":"+DescuentoSimple!C5/(1-DescuentoSimple!C6*DescuentoSimple!C7)","v":0}]
["Valor a Descuento",{"$f":"+DescuentoSimple!C4*(1-DescuentoSimple!C6*DescuentoSimple!C7)","v":980}]
["N",{"$f":"+(1-DescuentoSimple!C5/DescuentoSimple!C4)/DescuentoSimple!C7","v":100}]
["Tasa de Descuento",{"$f":"+(1-DescuentoSimple!C5/DescuentoSimple!C4)/DescuentoSimple!C6","v":0.5}]
[]
[]
["Nominal Vencida",{"$f":"+IF(ConversionTasas!C4=A57,ConversionTasas!C3,\"\")","v":""}]
["Efectiva Anual",{"$f":"IFERROR(EFFECT(B57,VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE)),0)","v":0}]
["Periodica Vencida",{"$f":"IFERROR((NOMINAL(B58,VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)))/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE),0)","v":0}]
["Nominal Anticipada",{"$f":"+B61*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Periodica Anticipada",{"$f":"+B59/(1+B59)","v":0}]
["Nominal Vencida",{"$f":"+B59*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
[]
["Efectiva Anual",{"$f":"+IF(A64=ConversionTasas!C4,ConversionTasas!C3,\"\")","v":""}]
["Nominal Vencida",{"$f":"IFERROR(NOMINAL(B64,VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)),0)","v":0}]
["Periodica Vencida",{"$f":"+B65/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Nominal Anticipada",{"$f":"+B68*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Periodica Anticipada",{"$f":"+B66/(1+B66)","v":0}]
[]
["Periodica Vencida",{"$f":"+IF(A70=ConversionTasas!C4,ConversionTasas!C3,\"\")","v":""}]
["Nominal Vencida",{"$f":"IFERROR(NOMINAL(B72,VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)),0)","v":0}]
["Efectiva Anual",{"$f":"IFERROR((1+B70)^VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE)-1,0)","v":0}]
["Nominal Anticipada",{"$f":"+B74*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Periodica Anticipada",{"$f":"+(B71/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE))/(1+B71/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE))","v":0}]
["Periodica Vencida",{"$f":"+B71/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
[]
[]
["Nominal Anticipada",{"$f":"+IF(A78=ConversionTasas!C4,ConversionTasas!C3,\"\")","v":0.03}]
["Periodica Vencida",{"$f":"IFERROR(B80/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE),0)","v":7.5376568379950104E-3}]
["Nominal Vencida",{"$f":"IFERROR(NOMINAL(B81,VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)),0)","v":3.0150627351980042E-2}]
["Efectiva Anual",{"$f":"IFERROR((1+(B78/VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE))/(1-B78/VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE)))^VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE)-1,0)","v":3.0493241249915926E-2}]
["Periodica Anticipada",{"$f":"+B79/(1+B79)","v":7.481265624999873E-3}]
["Nominal Anticipada",{"$f":"+B82*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":2.9925062499999492E-2}]
[]
["Periodica Anticipada",{"$f":"+IF(A85=ConversionTasas!C4,ConversionTasas!C3,\"\")","v":""}]
["Nominal Vencida",{"$f":"IFERROR(NOMINAL(B87,VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)),0)","v":0}]
["Efectiva Anual",{"$f":"IFERROR((1+B85/(1-B85))^VLOOKUP(ConversionTasas!C5,Hoja2!A100:B105,2,FALSE)-1,0)","v":0}]
["Periodica Vencida",{"$f":"+B86/VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Nominal Anticipada",{"$f":"+B90*VLOOKUP(ConversionTasas!C7,Hoja2!A100:B105,2,FALSE)","v":0}]
["Periodica Anticipada",{"$f":"+B88/(1+B88)","v":0}]
[]
["Nominal Vencida",{"$f":"+MAX(Hoja2!B62,Hoja2!B65,Hoja2!B71,Hoja2!B80,Hoja2!B86)","v":3.0150627351980042E-2}]
["Efectiva Anual",{"$f":"+MAX(Hoja2!B58,Hoja2!B64,Hoja2!B72,Hoja2!B81,Hoja2!B87)","v":3.0493241249915926E-2}]
["Periodica Vencida",{"$f":"+MAX(Hoja2!B59,Hoja2!B66,Hoja2!B75,Hoja2!B79,Hoja2!B88)","v":7.5376568379950104E-3}]
["Nominal Anticipada",{"$f":"+MAX(Hoja2!B60,Hoja2!B67,Hoja2!B73,Hoja2!B83,Hoja2!B89)","v":2.9925062499999492E-2}]
["Periodica Anticipada",{"$f":"+MAX(Hoja2!B61,Hoja2!B68,Hoja2!B74,Hoja2!B82,Hoja2!B90)","v":7.481265624999873E-3}]
[]
[]
[]
["Diaria",365]
["Mensual",12]
["Bimestal",6]
["Trimestral",4]
["Semestral",2]
["Anual",1]