{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Inicio EI","Cobb-Douglas EI","Cobb-Douglas Ampliado EI","Regulares EI","Regulares Ampliado EI","Incertidumbre UE","ValorPyF","MercadoActivo","Oculto EI"],"not_rendered":{"charts":7,"images":11,"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Inicio EI","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[23,0,23,2],[31,10,31,11]]}
{"$rows_empty":23}
["    Descargue la versión Kindle"]
{"$rows_empty":7}
[{"$nulls":10},"Miguel Cervantes Jiménez"]

{"sheet":"Cobb-Douglas EI","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"hidden":true,"merged":[[0,0,0,6],[2,0,2,5],[13,1,13,2],[14,1,14,2],[15,1,15,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
["ELECCIÓN INTERTEMPORAL"]
[]
["PREFERENCIAS COBB-DOUGLAS"]
[]
[null,"RECTA PRESUPUESTAL"]
[null,"r","mt","mt+1","Ct","Ct+1"]
[null,0.5,{"v":100,"d":"100.0"},{"v":500,"d":"500.0"},{"$f":"'Oculto EI'!AC27","v":{"v":260,"d":"260.0"}},{"$f":"'Oculto EI'!AD27","v":{"v":260,"d":"260.0"}}]
[null,"Inserte los datos correspondientes"]
[]
[null,"PARÁMETROS DE  LA RECTA  PRESUPUESTAL INTERTEMPORAL"]
[null,"Ct+1","b0","b1","Ct"]
[null,{"$f":"D7+((1+B7)*(C7-E7))","v":{"v":260,"d":"260.0"}},{"$f":"((1+B7)*C7)+D7","v":{"v":650,"d":"650.0"}},{"$f":"-(1+B7)","v":{"v":-1.5,"d":"(1.5)"}},{"$f":"(((1+'Cobb-Douglas EI'!B7)*'Cobb-Douglas EI'!C7)+'Cobb-Douglas EI'!D7)/(1+'Cobb-Douglas EI'!B7)*('Cobb-Douglas EI'!C20/('Cobb-Douglas EI'!C20+'Cobb-Douglas EI'!E20))","v":{"v":260,"d":"260.0"}}]
[]
[null,"Máxima cantidad de ct",null,{"$f":"C7+(D7/(1+B7))","v":{"v":433.3333333333333,"d":"433.3"}}]
[null,"Máxima cantidad de ct+1",null,{"$f":"((1+B7)*C7)+D7","v":{"v":650,"d":"650.0"}}]
[null,"Precio relativo (<0)",null,{"$f":"(C7/D7)*(-1)","v":{"v":-0.2,"d":"(0.2)"}}]
[]
[null,"PARÁMETROS DE  FUNCIÓN COBB-DOUGLAS INTERTEMPORAL"]
[null,"k","a","Ct*","b","Ct+1*"]
[null,{"$f":"'Oculto EI'!AD28","v":{"v":259.99999999999994,"d":"260.0"}},0.6,{"$f":"'Oculto EI'!AC27","v":{"v":260,"d":"260.0"}},0.4,{"$f":"'Oculto EI'!AD27","v":{"v":260,"d":"260.0"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]

{"sheet":"Cobb-Douglas Ampliado EI","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[27,1,27,2],[28,1,28,2],[30,1,30,2]]}
["ELECCIÓN INTERTEMPORAL"]
["SISTEMA AMPLIADO"]
[]
["PREFERENCIAS COBB-DOUGLAS"]
[]
[null,null,"RECTA PRESUPUESTAL"]
[null,null,"r","mt","mt+1","Ct","Ct+1"]
[null,"INICIAL",0.2,{"v":500,"d":"500.0"},{"v":1000,"d":"1,000.0"},{"$f":"'Oculto EI'!AO27","v":{"v":266.6666666666667,"d":"266.7"}},{"$f":"'Oculto EI'!AP27","v":{"v":1280,"d":"1,280.0"}}]
[null,"FINAL",{"$f":"C8","v":0.2},{"$f":"D8","v":{"v":500,"d":"500.0"}},{"$f":"E8","v":{"v":1000,"d":"1,000.0"}},{"$f":"'Oculto EI'!BA27","v":{"v":266.6666666666667,"d":"266.7"}},{"$f":"'Oculto EI'!BB27","v":{"v":1280,"d":"1,280.0"}}]
[null,null,"Inserte los datos correspondientes"]
[]
[null,null,"PARÁMETROS DE  LA RECTA  PRESUPUESTAL INTERTEMPORAL"]
[null,null,"Ct+1","b0","b1","Ct"]
[null,"INICIAL",{"$f":"E8+((1+C8)*(D8-F8))","v":{"v":1280,"d":"1,280.0"}},{"$f":"((1+C8)*D8)+E8","v":{"v":1600,"d":"1,600.0"}},{"$f":"-(1+C8)","v":{"v":-1.2,"d":"(1.2)"}},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C8)*'Cobb-Douglas Ampliado EI'!D8)+'Cobb-Douglas Ampliado EI'!E8)/(1+'Cobb-Douglas Ampliado EI'!C8)*('Cobb-Douglas Ampliado EI'!D24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":266.6666666666667,"d":"266.7"}}]
[null,"FINAL",{"$f":"E9+((1+C9)*(D9-F9))","v":{"v":1280,"d":"1,280.0"}},{"$f":"((1+C9)*D9)+E9","v":{"v":1600,"d":"1,600.0"}},{"$f":"-(1+C9)","v":{"v":-1.2,"d":"(1.2)"}},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C9)*'Cobb-Douglas Ampliado EI'!D9)+'Cobb-Douglas Ampliado EI'!E9)/(1+'Cobb-Douglas Ampliado EI'!C9)*('Cobb-Douglas Ampliado EI'!D24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":266.6666666666667,"d":"266.7"}}]
[]
[{"$nulls":3},"INICIAL","FINAL"]
[null,"Máxima cantidad de ct",null,{"$f":"D8+(E8/(1+C8))","v":{"v":1333.3333333333335,"d":"1,333.3"}},{"$f":"D9+(E9/(1+C9))","v":{"v":1333.3333333333335,"d":"1,333.3"}}]
[null,"Máxima cantidad de ct+1",null,{"$f":"((1+C8)*D8)+E8","v":{"v":1600,"d":"1,600.0"}},{"$f":"((1+C9)*D9)+E9","v":{"v":1600,"d":"1,600.0"}}]
[null,"Precio relativo (<0)",null,{"$f":"(D8/E8)*(-1)","v":{"v":-0.5,"d":"(0.5)"}},{"$f":"(D9/E9)*(-1)","v":{"v":-0.5,"d":"(0.5)"}}]
[]
[null,null,"PARÁMETROS DE  FUNCIÓN COBB-DOUGLAS INTERTEMPORAL"]
[null,null,"k","a","Ct*","b","Ct+1*"]
[null,"INICIAL",{"$f":"'Oculto EI'!AP28","v":{"v":935.3232330380323,"d":"935.3"}},0.2,{"$f":"'Oculto EI'!AO27","v":{"v":266.6666666666667,"d":"266.7"}},0.8,{"$f":"'Oculto EI'!AP27","v":{"v":1280,"d":"1,280.0"}}]
[null,"FINAL",{"$f":"'Oculto EI'!BB28","v":{"v":935.3232330380323,"d":"935.3"}},{"$f":"D24","v":0.2},{"$f":"'Oculto EI'!BA27","v":{"v":266.6666666666667,"d":"266.7"}},{"$f":"F24","v":0.8},{"$f":"'Oculto EI'!BB27","v":{"v":1280,"d":"1,280.0"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Cantidad de equilibrio"]

{"sheet":"Regulares EI","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"hidden":true,"merged":[[0,0,0,5],[2,0,2,5],[13,1,13,2],[14,1,14,2],[15,1,15,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
["ELECCIÓN INTERTEMPORAL"]
[]
["PREFERENCIAS REGULARES"]
[]
[null,"RECTA PRESUPUESTAL"]
[null,"r","m1","m2","C1","C2"]
[null,0.1,{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"$f":"'Oculto EI'!BL28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!BL29","v":160.5}]
[null,"Inserte los datos correspondientes"]
[]
[null,"PARÁMETROS DE  LA RECTA  PRESUPUESTAL INTERTEMPORAL"]
[null,"C2","b0","b1","C1"]
[null,{"$f":"D7+((1+B7)*(C7-E7))","v":160.5},{"$f":"((1+B7)*C7)+D7","v":{"v":210,"d":"210.0"}},{"$f":"-(1+B7)","v":{"v":-1.1,"d":"(1.1)"}},{"$f":"'Regulares EI'!E20+(-'Regulares EI'!F20+'Regulares EI'!D7+('Regulares EI'!C7*(1+'Regulares EI'!B7))-('Regulares EI'!E20*(1+'Regulares EI'!B7)))/(2*(1+'Regulares EI'!B7))","v":{"v":45,"d":"45.0"}}]
[]
[null,"Máxima cantidad de x1",null,{"$f":"C7+(D7/(1+B7))","v":{"v":190.9090909090909,"d":"190.9"}}]
[null,"Máxima cantidad de x2",null,{"$f":"((1+B7)*C7)+D7","v":{"v":210,"d":"210.0"}}]
[null,"Precio relativo (<0)",null,{"$f":"-(1+B7)","v":{"v":-1.1,"d":"(1.1)"}}]
[]
[null,"PARÁMETROS DE  FUNCIÓN REGULAR INTERTEMPORAL"]
[null,"k","C1*","C2*","a","b"]
[null,{"$f":"'Oculto EI'!BM26","v":{"v":3327.5,"d":"3,327.5"}},{"$f":"'Oculto EI'!BL28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!BS13","v":160.5},{"v":-10,"d":"(10.0)"},{"v":100,"d":"100.0"},2]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Cantidad de equilibrio"]

{"sheet":"Regulares Ampliado EI","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2]]}
["ELECCIÓN INTERTEMPORAL"]
["SISTEMA AMPLIADO"]
[]
["PREFERENCIAS POLINOMIALES"]
[]
[null,null,"RECTA PRESUPUESTAL"]
[null,null,"r","m1","m2","C1","C2"]
[null,"INICIAL",0.1,{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"$f":"'Oculto EI'!BX28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!BX29","v":160.5}]
[null,"FINAL",{"$f":"C8","v":0.1},{"$f":"D8","v":{"v":100,"d":"100.0"}},{"v":100,"d":"100.0"},{"$f":"'Oculto EI'!CK28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!CK29","v":160.5}]
[null,null,"Inserte los datos correspondientes"]
[]
[null,null,"PARÁMETROS DE  LA RECTA  PRESUPUESTAL"]
[null,null,"C2","b0","b1","C1"]
[null,"INICIAL",{"$f":"E8+((1+C8)*(D8-F8))","v":160.5},{"$f":"((1+C8)*D8)+E8","v":{"v":210,"d":"210.0"}},{"$f":"-(1+C8)","v":{"v":-1.1,"d":"(1.1)"}},{"$f":"'Regulares Ampliado EI'!F24+(-'Regulares Ampliado EI'!G24+'Regulares Ampliado EI'!E8+('Regulares Ampliado EI'!D8*(1+'Regulares Ampliado EI'!C8))-('Regulares Ampliado EI'!F24*(1+'Regulares Ampliado EI'!C8)))/(2*(1+'Regulares Ampliado EI'!C8))","v":{"v":45,"d":"45.0"}}]
[null,"FINAL",{"$f":"E9+((1+C9)*(D9-F9))","v":160.5},{"$f":"((1+C9)*D9)+E9","v":{"v":210,"d":"210.0"}},{"$f":"-(1+C9)","v":{"v":-1.1,"d":"(1.1)"}},{"$f":"'Regulares Ampliado EI'!F25+(-'Regulares Ampliado EI'!G25+'Regulares Ampliado EI'!E9+('Regulares Ampliado EI'!D9*(1+'Regulares Ampliado EI'!C9))-('Regulares Ampliado EI'!F25*(1+'Regulares Ampliado EI'!C9)))/(2*(1+'Regulares Ampliado EI'!C9))","v":{"v":45,"d":"45.0"}}]
[]
[{"$nulls":3},"INICIAL","FINAL"]
[null,"Máxima cantidad de x1",null,{"$f":"D8+(E8/(1+C8))","v":{"v":190.9090909090909,"d":"190.9"}},{"$f":"D9+(E9/(1+C9))","v":{"v":190.9090909090909,"d":"190.9"}}]
[null,"Máxima cantidad de x2",null,{"$f":"((1+C8)*D8)+E8","v":{"v":210,"d":"210.0"}},{"$f":"((1+C9)*D9)+E9","v":{"v":210,"d":"210.0"}}]
[null,"Precio relativo (<0)",null,{"$f":"-(1+C8)","v":{"v":-1.1,"d":"(1.1)"}},{"$f":"-(1+C9)","v":{"v":-1.1,"d":"(1.1)"}}]
[]
[null,null,"PARÁMETROS DE  FUNCIÓN REGULAR"]
[null,null,"k","C1*","C2*","a","b"]
[null,"INICIAL",{"$f":"'Oculto EI'!BY26","v":{"v":3327.5,"d":"3,327.5"}},{"$f":"'Oculto EI'!BX28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!BX29","v":160.5},{"v":-10,"d":"(10.0)"},{"v":100,"d":"100.0"},2]
[null,"FINAL",{"$f":"'Oculto EI'!CL26","v":{"v":3327.5,"d":"3,327.5"}},{"$f":"'Oculto EI'!CK28","v":{"v":45,"d":"45.0"}},{"$f":"'Oculto EI'!CK29","v":160.5},{"$f":"F24","v":{"v":-10,"d":"(10.0)"}},{"$f":"G24","v":{"v":100,"d":"100.0"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Cantidad de equilibrio"]

{"sheet":"Incertidumbre UE","index":5,"n_rows":24,"n_cols":7,"rows_kept":24,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,6,23,10]]}
["ELECCIÓN INTERTEMPORAL"]
["Elección bajo incertidumbre"]
[]
[null,"Datos contingentes","Caso 1","Caso 2"]
[null,"a",0.7,{"$f":"C5","v":0.7}]
[null,"Ingreso",{"v":100,"d":"100.0"},{"$f":"C6","v":{"v":100,"d":"100.0"}}]
[null,"Ganancia",{"v":70,"d":"70.0"},{"$f":"C7","v":{"v":70,"d":"70.0"}}]
[null,"Pérdida",{"v":-70,"d":"-70.0"},{"$f":"C8","v":{"v":-70,"d":"-70.0"}}]
[null,"p ganancia",{"v":0.5,"d":"0.50"},{"$f":"C9","v":{"v":0.5,"d":"0.50"}}]
[null,"p  pérdida",{"$f":"'Oculto EI'!C33","v":{"v":0.5,"d":"0.50"}},{"$f":"'Oculto EI'!F33","v":{"v":0.5,"d":"0.50"}}]
[null,null,"Inserte los datos correspondientes"]
[null,"U Ingreso",{"$f":"'Oculto EI'!C35","v":{"v":25.1188643150958,"d":"25.12"}},{"$f":"'Oculto EI'!F35","v":{"v":25.1188643150958,"d":"25.12"}}]
[null,"U Ganancia",{"$f":"'Oculto EI'!C38","v":{"v":36.41784515192302,"d":"36.4"}},{"$f":"'Oculto EI'!F38","v":{"v":36.41784515192302,"d":"36.4"}}]
[null,"U Pérdida",{"$f":"'Oculto EI'!C41","v":{"v":5.406981487565073,"d":"5.4"}},{"$f":"'Oculto EI'!F41","v":{"v":5.406981487565073,"d":"5.4"}}]
[null,"U Esperada",{"$f":"'Oculto EI'!C42","v":{"v":23.615904063526582,"d":"23.62"}},{"$f":"'Oculto EI'!F42","v":{"v":23.615904063526582,"d":"23.62"}}]
[null,"Toma de decisión",{"$f":"'Oculto EI'!C44","v":"Rechaza el juego"},{"$f":"'Oculto EI'!F44","v":"Rechaza el juego"}]
[null,"Desviación media",{"$f":"'Oculto EI'!C45","v":{"v":70,"d":"70.0"}},{"$f":"'Oculto EI'!F45","v":{"v":70,"d":"70.0"}}]
[null,"Varianza",{"$f":"'Oculto EI'!C46","v":{"v":4900,"d":"4,900"}},{"$f":"'Oculto EI'!F46","v":{"v":4900,"d":"4,900"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[{"$nulls":6},"Gráfica caso 1"]

{"sheet":"ValorPyF","index":6,"n_rows":46,"n_cols":191,"rows_kept":46,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6],[2,103,2,104],[2,105,2,106],[2,107,2,108],[2,109,2,110],[3,103,3,106],[3,107,3,110],[4,1,4,2],[4,5,4,6],[4,103,4,104],[4,105,4,106],[4,107,4,108],[4,109,4,110],[11,103,11,104],[11,105,11,106],[14,1,14,2],[14,5,14,6],[18,103,18,104],[25,1,25,2],[26,1,26,2],[27,1,27,2]]}
["ELECCIÓN INTERTEMPORAL"]
["Valor presente y valor futuro",{"$nulls":102},"Nominal",{"$nulls":3},"Real"]
[{"$nulls":8},0,{"$nulls":94},"Valor presente",{"$nulls":3},"Valor presente",null,"Capitalizado",null,"Ponderador","anualizada nominal",null,"anualizada real"]
[{"$nulls":103},"Anualizado",{"$nulls":3},"Capitalizado",{"$nulls":3},0,{"$f":"$DI$29*DH4","v":0},{"$f":"DI30","v":{"v":100,"d":"100.00"}},{"$f":"$DJ$29*DH4","v":0},{"$f":"DJ30","v":{"v":100,"d":"100.00"}}]
[null,"Anualizado nominal",{"$nulls":3},"Anualizado real",{"$nulls":97},"nominal",null,"real",null,"nominal",null,"real",null,0.05,{"$f":"$DI$29*DH5","v":{"v":0.1,"d":"0.10 "}},{"$f":"DJ4+$DI$32","v":101.05},{"$f":"$DJ$29*DH5","v":{"v":0.1,"d":"0.10 "}},{"$f":"DL4+$DJ$32","v":{"v":100.99773242630386,"d":"101.00"}}]
[null,{"$f":"ValorPyF!CZ6","v":"Capital final"},{"$f":"DA6","v":{"v":121.00000000000001,"d":"121.0"}},null,null,{"$f":"ValorPyF!DB6","v":"Capital final"},{"$f":"ValorPyF!DC6","v":{"v":119.95464852607711,"d":"120.0"}},{"$nulls":96},"Capital final",{"$f":"DA7*((1+(DA9-DA34)/(1+DA34))^DA8)","v":{"v":121.00000000000001,"d":"121.0"}},"Capital final",{"$f":"DC7*((1+(DC9-DC10)/(1+DC10))^DC8)","v":{"v":119.95464852607711,"d":"120.0"}},"Capital final",{"$f":"DE7*((1+(DE11-DE46)/(1+DE46))^(DE8*DE9))","v":{"v":183.05864420633387,"d":"183.1"}},"Capital final",{"$f":"DG7*(1+(DG14))^(DG8*DG9)","v":{"v":164.95701474819018,"d":"165.0"}},{"v":0.1,"d":"0.10"},{"v":0.2,"d":"0.20 "},{"$f":"DJ5+$DI$32","v":{"v":102.1,"d":"102.10"}},{"v":0.2,"d":"0.20 "},{"$f":"DL5+$DJ$32","v":{"v":101.99546485260771,"d":"102.00"}}]
[null,{"$f":"ValorPyF!CZ7","v":"Capital inicial"},{"v":100,"d":"100.0"},null,null,{"$f":"ValorPyF!DB7","v":"Capital inicial"},{"v":100,"d":"100.0"},{"$nulls":96},"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},0.15,{"v":0.3,"d":"0.30 "},{"v":103.14999999999999,"d":"103.15"},{"v":0.3,"d":"0.30 "},{"v":102.99319727891157,"d":"102.99"}]
[null,{"$f":"ValorPyF!CZ8","v":"Años"},{"v":2,"d":"2.0"},null,null,{"$f":"ValorPyF!DB8","v":"Años"},{"v":2,"d":"2.0"},{"$nulls":96},"Años",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},{"v":0.2,"d":"0.20"},{"v":0.4,"d":"0.40 "},{"v":104.19999999999999,"d":"104.20"},{"v":0.4,"d":"0.40 "},{"v":103.99092970521542,"d":"103.99"}]
[null,{"$f":"ValorPyF!CZ9","v":"Tasa de interés"},{"v":0.1,"d":"10.0%"},null,null,{"$f":"ValorPyF!DB9","v":"Tasa de interés"},{"v":0.15,"d":"15.0%"},{"$nulls":96},"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"15.0%"}},"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},0.25,{"v":0.5,"d":"0.50 "},{"v":105.24999999999999,"d":"105.25"},{"v":0.5,"d":"0.50 "},{"v":104.98866213151928,"d":"104.99"}]
[null,"Inserte los datos correspondientes",{"$nulls":3},{"$f":"ValorPyF!DB10","v":"Tasa de inflación"},{"v":0.05,"d":"5.0%"},{"$nulls":97},{"$f":"DA8","v":{"v":2,"d":"2.0"}},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"5.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":{"v":0.1,"d":"10.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10.0%"}},{"v":0.3,"d":"0.30"},{"v":0.6,"d":"0.60 "},{"v":106.29999999999998,"d":"106.30"},{"v":0.6,"d":"0.60 "},{"v":105.98639455782313,"d":"105.99"}]
[{"$nulls":5},{"$f":"ValorPyF!DB11","v":"Tasa de interés real"},{"$f":"ValorPyF!DC11","v":{"v":0.09523809523809523,"d":"9.5%"}},{"$nulls":98},"Tasa de interés real",{"$f":"(DC9-DC10)/(1+DC10)","v":{"v":0.09523809523809523,"d":"9.5%"}},"Tasa de interés por periodo",{"$f":"DE10/DE9","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG10/DG9","v":{"v":0.008333333333333333,"d":"0.8%"}},0.35,{"v":0.7,"d":"0.70 "},{"v":107.34999999999998,"d":"107.35"},{"v":0.7,"d":"0.70 "},{"v":106.98412698412699,"d":"106.98"}]
[{"$nulls":5},"Inserte los datos correspondientes",{"$nulls":97},"CI",null,"CI",{"$nulls":3},"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},{"v":0.4,"d":"0.40"},{"v":0.8,"d":"0.80 "},{"v":108.39999999999998,"d":"108.40"},{"v":0.8,"d":"0.80 "},{"v":107.98185941043084,"d":"107.98"}]
[{"$nulls":103},"Capital inicial",{"$f":"DA14/((1+((DA16-DA34)/(1+DA34)))^DA15)","v":{"v":82.64462809917354,"d":"82.6"}},"Capital inicial",{"$f":"DC14/((1+((DC16-DC17)/(1+DC17)))^DC15)","v":{"v":83.36483931947069,"d":"83.4"}},null,null,"Tasa de interés real anual",{"$f":"(DG10-DG12)/(1+DG12)","v":{"v":0.047619047619047616,"d":"4.8%"}},0.45,{"v":0.9,"d":"0.90 "},{"v":109.44999999999997,"d":"109.45"},{"v":0.9,"d":"0.90 "},{"v":108.9795918367347,"d":"108.98"}]
[{"$nulls":103},"Capital final",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital final",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},null,null,"Tasa de interés real por periodo",{"$f":"DG13/DG9","v":{"v":3.968253968253968E-3,"d":"0.40%"}},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00 "},{"v":110.49999999999997,"d":"110.50"},{"v":1,"d":"1.00 "},{"v":109.97732426303855,"d":"109.98"}]
[null,"Capitalizado nominal",{"$nulls":3},"Capitalizado real",{"$nulls":97},"Años",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"CI",null,"CI",null,0.55,{"v":1.1,"d":"1.10 "},{"v":111.54999999999997,"d":"111.55"},{"v":1.1,"d":"1.10 "},{"v":110.97505668934241,"d":"110.98"}]
[null,{"$f":"ValorPyF!DD6","v":"Capital final"},{"$f":"ValorPyF!DE6","v":{"v":183.05864420633387,"d":"183.1"}},null,null,{"$f":"ValorPyF!DF6","v":"Capital final"},{"$f":"ValorPyF!DG6","v":{"v":164.95701474819018,"d":"165.0"}},{"$nulls":96},"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"15.0%"}},"Capital inicial",{"$f":"DE17/((1+((DE21-DE46)/(1+DE46)))^(DE18*DE19))","v":{"v":122.91143145711933,"d":"122.9"}},"Capital inicial",{"$f":"DG17/((1+(DG24))^(DG18*DG19))","v":{"v":136.39917062239914,"d":"136.4"}},{"v":0.6,"d":"0.60"},{"v":1.2,"d":"1.20 "},{"v":112.59999999999997,"d":"112.60"},{"v":1.2,"d":"1.20 "},{"v":111.97278911564626,"d":"111.97"}]
[null,{"$f":"ValorPyF!DD7","v":"Capital inicial"},{"v":150,"d":"150.0"},null,null,{"$f":"ValorPyF!DF7","v":"Capital inicial"},{"v":150,"d":"150.0"},{"$nulls":98},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"5.0%"}},"Capital final",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital final",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},0.65,{"v":1.3,"d":"1.30 "},{"v":113.64999999999996,"d":"113.65"},{"v":1.3,"d":"1.30 "},{"v":112.97052154195012,"d":"112.97"}]
[null,{"$f":"ValorPyF!DD8","v":"Años"},{"v":2,"d":"2.0"},null,null,{"$f":"ValorPyF!DF8","v":"Años"},{"v":2,"d":"2.0"},{"$nulls":98},"Tasa de interés real",{"$f":"(DC16-DC17)/(1+DC17)","v":{"v":0.09523809523809523,"d":"9.5%"}},"Años",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},{"v":0.7,"d":"0.70"},{"v":1.4,"d":"1.40 "},{"v":114.69999999999996,"d":"114.70"},{"v":1.4,"d":"1.40 "},{"v":113.96825396825398,"d":"113.97"}]
[null,{"$f":"ValorPyF!DD9","v":"Periodos de capitalización"},{"v":12,"d":"12.0"},null,null,{"$f":"ValorPyF!DF9","v":"Periodos de capitalización"},{"v":12,"d":"12.0"},{"$nulls":96},{"$f":"ValorPyF!B5","v":"Anualizado nominal"},null,"n",null,"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},0.75,{"v":1.5,"d":"1.50 "},{"v":115.74999999999996,"d":"115.75"},{"v":1.5,"d":"1.50 "},{"v":114.96598639455783,"d":"114.97"}]
[null,{"$f":"ValorPyF!DD10","v":"Tasa de interés anualizada"},{"v":0.1,"d":"10.0%"},null,null,{"$f":"ValorPyF!DF10","v":"Tasa de interés anualizada"},{"v":0.1,"d":"10.0%"},{"$nulls":96},"Años",{"$f":"(LN(DA22/DA21))/(LN(1+(DA23-DA34)/(1+DA34)))","v":{"v":-41.04517495885186,"d":"-41.0"}},"Años",{"$f":"(LN(DC22/DC21))/(LN(1+(DC23-DC24)/(1+DC24)))","v":{"v":-43.00260017542319,"d":"-43.0"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":0.1},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10%"}},{"v":0.8,"d":"0.80"},{"v":1.6,"d":"1.60 "},{"v":116.79999999999995,"d":"116.80"},{"v":1.6,"d":"1.60 "},{"v":115.96371882086169,"d":"115.96"}]
[null,{"$f":"ValorPyF!DD11","v":"Tasa de interés por periodo"},{"$f":"ValorPyF!DE11","v":{"v":0.008333333333333333,"d":"0.8%"}},null,null,{"$f":"ValorPyF!DF11","v":"Tasa de interés por periodo"},{"$f":"ValorPyF!DG11","v":{"v":0.008333333333333333,"d":"0.8%"}},{"$nulls":96},"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Tasa de interés por periodo",{"$f":"DE20/DE19","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG20/DG19","v":{"v":0.008333333333333333,"d":"0.8%"}},0.85,{"v":1.7,"d":"1.70 "},{"v":117.84999999999995,"d":"117.85"},{"v":1.7,"d":"1.70 "},{"v":116.96145124716554,"d":"116.96"}]
[null,"Inserte los datos correspondientes",{"$nulls":3},{"$f":"ValorPyF!DF12","v":"Tasa de inflación anual"},{"v":0.05,"d":"5.0%"},{"$nulls":96},"Capital final",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},null,null,"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},{"v":0.9,"d":"0.90"},{"v":1.8,"d":"1.80 "},{"v":118.89999999999995,"d":"118.90"},{"v":1.8,"d":"1.80 "},{"v":117.9591836734694,"d":"117.96"}]
[{"$nulls":5},{"$f":"ValorPyF!DF13","v":"Tasa de interés real anual"},{"$f":"ValorPyF!DG13","v":{"v":0.047619047619047616,"d":"4.8%"}},{"$nulls":96},"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"0.2"}},null,null,"Tasa de interés real anual",{"$f":"(DG20-DG22)/(1+DG22)","v":{"v":0.047619047619047616,"d":"4.8%"}},0.95,{"v":1.9,"d":"1.90 "},{"v":119.94999999999995,"d":"119.95"},{"v":1.9,"d":"1.90 "},{"v":118.95691609977325,"d":"118.96"}]
[{"$nulls":5},{"$f":"ValorPyF!DF14","v":"Tasa de interés real por periodo"},{"$f":"ValorPyF!DG14","v":{"v":3.968253968253968E-3,"d":"0.4%"}},{"$nulls":98},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"0.1"}},null,null,"Tasa de interés real por periodo",{"$f":"DG23/DG19","v":{"v":3.968253968253968E-3,"d":"0.40%"}},{"v":1,"d":"1.00"},{"v":2,"d":"2.00 "},{"v":120.99999999999994,"d":"121.00"},{"v":2,"d":"2.00 "},{"v":119.95464852607711,"d":"119.95"}]
[{"$nulls":104},{"$f":"ValorPyF!C4","v":0},"Tasa de interés real",{"$f":"(DC23-DC24)/(1+DC24)","v":{"v":0.09523809523809523,"d":"0.1"}},"n",null,"n",null,1.05,{"v":2.1,"d":"2.10 "},{"v":122.04999999999994,"d":"122.05"},{"v":2.1,"d":"2.10 "},{"v":120.95238095238096,"d":"120.95"}]
[null,"Títulos",{"$nulls":101},"r",{"$f":"ValorPyF!C5","v":0},"r",{"$f":"ValorPyF!G24","v":{"v":3.968253968253968E-3,"d":"0.40%"}},"Años",{"$f":"((LN(DE28/DE27))/(LN(1+(DE31))))/DE29","v":{"v":-43.3545276543899,"d":"-43.4"}},"Años",{"$f":"(LN(DG28/DG27))/((LN(1+(DG34)))*DG29)","v":{"v":-90.84702697940527,"d":"-90.85"}},{"v":1.1,"d":"1.10"},{"v":2.2,"d":"2.20 "},{"v":123.09999999999994,"d":"123.10"},{"v":2.2,"d":"2.20 "},{"v":121.95011337868482,"d":"121.95"}]
[null,"Resultados",{"$nulls":101},"Tasa de interés",{"$f":"DA34+((1+DA34)*(((DA29/DA28)^(1/DA30))-1))","v":{"v":-1,"d":"-1.0"}},"Tasa de interés",{"$f":"DC31+((1+DC31)*(((DC29/DC28)^(1/DC30))-1))","v":{"v":-0.9999999999950486,"d":"-1.0"}},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},null,"anualizada nominal","anualizada real","capitalizada nominal","capitalizada real"]
[null,"Insertar datos",{"$nulls":101},"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Capital final",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},null,"Anualizado nominal","Anualizado real"]
[{"$nulls":103},"Capital final",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},"años",{"$f":"DA8","v":{"v":2,"d":"2.0"}},{"$f":"DC8","v":{"v":2,"d":"2.0"}}]
[{"$nulls":103},"Años",{"$f":"ValorPyF!C9","v":0.1},"Años",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"0.2"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":{"v":0.1,"d":"10.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10.0%"}},"capital inicial",{"$f":"DA7","v":{"v":100,"d":"100.0"}},{"$f":"DC7","v":{"v":100,"d":"100.0"}}]
[{"$nulls":105},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"0.1"}},"Tasa de interés por periodo",{"$f":"DE30/DE29","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG30/DG29","v":{"v":0.008333333333333333,"d":"0.8%"}},"capital final",{"$f":"DA6","v":{"v":121.00000000000001,"d":"121.0"}},{"$f":"DC6","v":{"v":119.95464852607711,"d":"120.0"}}]
[{"$nulls":105},"Tasa de interés real",{"$f":"(DC27-DC31)/(1+DC31)","v":{"v":-0.9999999999952844,"d":"-1.0"}},null,null,"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},null,{"$f":"(DI31-DI30)/20","v":1.0500000000000007},{"$f":"(DJ31-DJ30)/20","v":0.9977324263038554},{"$nulls":76},{"$f":"GK65418","v":0}]
[{"$nulls":109},"Tasa de interés real anual",{"$f":"(DG30-DG32)/(1+DG32)","v":{"v":0.047619047619047616,"d":"4.8%"}},null,"Anualizada nominal","Anualizada real","Capitalizada nominal","Capitalizada real"]
[{"$nulls":103},"Inflación",{"v":0,"d":"0.00"},"Inflación",{"$f":"ValorPyF!G11","v":{"v":0.09523809523809523,"d":"0.10"}},null,null,"Tasa de interés real por periodo",{"$f":"DG33/DG29","v":{"v":3.968253968253968E-3,"d":"0.40%"}}]
[{"$nulls":107},"r",null,"r"]
[{"$nulls":107},"Tasa de interés anualizada",{"$f":"DE46+((1+DE42)*(((((DE38/DE37)^(1/(DE39*DE40)))-1))*DE40))","v":{"v":-0.09726190225756519,"d":"-9.7%"}},"Tasa de interés anualizada",{"$f":"DG42+((1+DG42)*(((((DG38/DG37)^(1/(DG39*DG40)))-1))*DG40))","v":{"v":-0.052124997370443446,"d":"-5.2%"}}]
[{"$nulls":107},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}}]
[{"$nulls":107},"Capital final",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}}]
[{"$nulls":107},"Años",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Años",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}}]
[{"$nulls":107},"Periodos de capitalización",{"$f":"ValorPyF!C20","v":0.1},"Periodos de capitalización",{"$f":"ValorPyF!G20","v":0.1}]
[{"$nulls":107},"Tasa de interés por periodo",{"$f":"DE36/DE40","v":{"v":-0.9726190225756518,"d":"-97.3%"}},"Tasa de interés por periodo",{"$f":"DG36/DG40","v":{"v":-0.5212499737044344,"d":"-52.1%"}}]
[{"$nulls":109},"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}}]
[{"$nulls":109},"Tasa de interés real anual",{"$f":"(DG36-DG42)/(1+DG42)","v":{"v":-0.09726190225756519,"d":"-9.7%"}}]
[{"$nulls":109},"Tasa de interés real por periodo",{"$f":"DG43/DG40","v":{"v":-0.9726190225756518,"d":"-97.26%"}}]
[]
[{"$nulls":107},"Inflación",{"v":0,"d":"0.00"},"Inflación",{"v":0,"d":"0.00"}]

{"sheet":"MercadoActivo","index":7,"n_rows":30,"n_cols":4,"rows_kept":30,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3],[4,1,4,2]]}
[null,"ELECCIÓN INTERTEMPORAL"]
[null,"Tasa de interés real"]
[]
[]
[null,"Tasa de interés real"]
[null,"Tasa de interés nominal",{"v":0.05,"d":"5%"}]
[null,"Tasa de inflación",{"v":0.06,"d":"6%"}]
[null,"Tasa de interés real",{"$f":"'Oculto EI'!DP7","v":{"v":-0.009433962264150938,"d":"-0.94%"}}]
[null,"Tasa de interés real simple",{"$f":"'Oculto EI'!DP8","v":{"v":-9.999999999999995E-3,"d":"-1.00%"}}]
[]
[null,"Prestatario","Caso 1","Caso 2"]
[null,"Ct",{"$f":"'Oculto EI'!DP10","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto EI'!DQ10","v":{"v":100,"d":"100.0"}}]
[null,"Ct+1",{"$f":"'Oculto EI'!DP11","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto EI'!DQ11","v":{"v":100,"d":"100.0"}}]
[null,"mt",{"v":100,"d":"100.0"},{"$f":"'Oculto EI'!DQ12","v":{"v":100,"d":"100.0"}}]
[null,"mt+1",{"v":100,"d":"100.0"},{"$f":"'Oculto EI'!DQ13","v":{"v":100,"d":"100.0"}}]
[null,"r",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[]
[null,"Función de utilidad","Caso 1","Caso 2"]
[null,"a",0.5,{"$f":"'Oculto EI'!DQ17","v":0.5}]
[null,"1-a",{"$f":"'Oculto EI'!DP18","v":0.5},{"$f":"'Oculto EI'!DQ18","v":0.5}]
[null,"U",{"$f":"'Oculto EI'!DP19","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto EI'!DQ19","v":{"v":100,"d":"100.0"}}]
[null,"Inserte los datos correspondientes"]
[]
[]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Cantidad de equilibrio"]

{"sheet":"Oculto EI","index":8,"n_rows":96,"n_cols":143,"rows_kept":96,"hidden":true,"merged":[[0,0,0,18],[1,3,1,6],[1,7,1,10],[1,11,1,14],[1,15,1,18],[1,19,1,20],[1,21,1,22],[1,129,1,132],[2,103,2,104],[2,105,2,106],[2,107,2,108],[2,109,2,110],[3,103,3,106],[3,107,3,110],[3,118,3,119],[4,103,4,104],[4,105,4,106],[4,107,4,108],[4,109,4,110],[11,103,11,104],[11,105,11,106],[18,103,18,104],[55,107,55,108],[64,103,64,104],[64,105,64,106],[64,107,64,108],[65,103,65,104],[65,107,65,108],[65,109,65,110],[66,103,66,104],[66,105,66,106],[66,107,66,108],[66,109,66,110],[73,103,73,104],[73,105,73,106],[73,107,73,108],[74,109,74,110],[80,103,80,104],[80,107,80,108],[87,107,87,108]]}
["INCERTIDUMBRE",{"$nulls":23},"COBB-DOUGLAS",null,"Recta Presupuestaria",{"$nulls":6},"Curva de Indiferencia",null,null,"AMPLIADO",null,"Recta Presupuestaria inicial",{"$nulls":6},"Curva de Indiferencia inicial",null,null,"AMPLIADO DOS",null,"Recta Presupuestaria Final",{"$nulls":6},"Curva de Indiferencia final",null,null,"REGULARES",null,"Recta Presupuestaria",{"$nulls":6},"Curva de Indiferencia",null,null,"AMPLIADO",null,"Recta Presupuestaria Inicial",{"$nulls":6},"Curva de Indiferencia Inicial",{"$nulls":3},"AMPLIADO",null,"Recta Presupuestaria Final",{"$nulls":6},"Curva de Indiferencia Final"]
[{"$nulls":3},"X1lin  perdida",{"$nulls":3},"X2lin ganancia",{"$nulls":3},"X3lin utilidad segura",{"$nulls":3},"X4lin utilidad del juego",{"$nulls":3},"utilidad esperada de la riqueza",null,"x5line uejuego",null,null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",null,null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"Cota","x1","x2",{"$nulls":4},"ANUAL",null,null,"Nominal",{"$nulls":3},"Real",{"$nulls":16},"RP",null,"Curva de indiferencia",null,null,"Punto de polonio",{"$nulls":3},"Punto de equilibrio",{"$nulls":3},"Prestamista",null,null,"Curva de indiferencia"]
["PONDERADOR","INGRESO","Utilidad del ingreso","X","Y","X","Y","X","Y","X","Y","X","Y","X","Y","X","Y","X","Y","X","Y",{"$nulls":3},1,0,{"$f":"('Cobb-Douglas EI'!$D$14)*Z3","v":0},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7))-((1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA3))","v":{"v":650,"d":"650.00"}},{"$f":"$AC$27","v":260},{"$f":"$AD$27*Z3","v":0},{"$f":"$AC$27*'Oculto EI'!Z3","v":0},{"$f":"$AD$27","v":260},{"$nulls":4},1,0,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL3","v":0},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM3))","v":{"v":1600,"d":"1,600.00"}},{"$f":"$AO$27","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"$AP$27*AL3","v":0},{"$f":"$AO$27*'Oculto EI'!AL3","v":0},{"$f":"$AP$27","v":{"v":1280,"d":"1,280.00"}},{"$nulls":4},1,0,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX3","v":0},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY3))","v":{"v":1600,"d":"1,600.00"}},{"$f":"$BA$27","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"$BB$27*AX3","v":0},{"$f":"$BA$27*'Oculto EI'!AX3","v":0},{"$f":"$BB$27","v":{"v":1280,"d":"1,280.00"}},{"$nulls":4},1,0,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ3","v":0},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK3))","v":{"v":210,"d":"210.00"}},{"$f":"$BR$13","v":{"v":45,"d":"45.00"}},{"$f":"BP3*BJ3","v":0},{"$f":"BM3*BJ3","v":0},{"$f":"$BS$13","v":{"v":160.5,"d":"160.50"}},{"$nulls":4},1,0,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV3","v":0},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW3))","v":{"v":210,"d":"210.00"}},{"$f":"$CD$13","v":{"v":45,"d":"45.00"}},{"$f":"CB3*BV3","v":0},{"$f":"BY3*BV3","v":0},{"$f":"$CE$13","v":{"v":160.5,"d":"160.50"}},{"$nulls":5},1,0,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI3","v":0},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ3))","v":{"v":210,"d":"210.00"}},{"$f":"$CK$28","v":{"v":45,"d":"45.00"}},{"$f":"CO3*CI3","v":0},{"$f":"CL3*CI3","v":0},{"$f":"$CK$29","v":{"v":160.5,"d":"160.50"}},{"$nulls":7},"Capital Inicial",{"v":1000,"d":"1,000.00"},null,"Valor presente",{"$nulls":3},"Valor presente",null,"Capitalizado",null,"Ponderador","anualizada nominal",null,"anualizada real",{"$nulls":8},"Ponderador","C1","C2","C2","C1rest","C2 rest","x","y","x","y","x","y","x","y","Ponderador","C1","C2","C2","C1rest","C2 rest"]
[0,{"$f":"(($C$29+$C$30)*1.2)*A4","v":0},{"$f":"B4^$C$28","v":0},{"$f":"$C$37","v":{"v":30,"d":"30.00"}},{"$f":"$C$39*$A4","v":0},{"$f":"$C$37*$A4","v":0},{"$f":"$C$39","v":{"v":10.813962975130146,"d":"10.81"}},{"$f":"$C$36","v":{"v":170,"d":"170.00"}},{"$f":"$C$38*$A4","v":0},{"$f":"$C$36*$A4","v":0},{"$f":"$C$38","v":{"v":36.41784515192302,"d":"36.42"}},{"$f":"$C$29","v":{"v":100,"d":"100.00"}},{"$f":"$C$35*$A4","v":0},{"$f":"$C$29*$A4","v":0},{"$f":"$C$35","v":{"v":25.1188643150958,"d":"25.12"}},{"$f":"$G$29*A4","v":0},{"$f":"$C$42","v":{"v":23.615904063526582,"d":"23.62"}},{"$f":"$G$29","v":{"v":100,"d":"100.00"}},{"$f":"(MAX($P$43,$P$44))*A4","v":0},{"$f":"C37","v":{"v":30,"d":"30.00"}},{"$f":"(T4)^$C$28","v":{"v":10.813962975130146,"d":"10.81"}},{"$f":"$O$43*A4","v":0},{"$f":"$P$43","v":{"v":25.1188643150958,"d":"25.12"}},null,2,0.05,{"$f":"('Cobb-Douglas EI'!$D$14)*Z4","v":{"v":21.666666666666668,"d":"21.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA4))","v":{"v":617.5,"d":"617.50"}},{"$f":"$AC$27","v":260},{"v":13,"d":"13.00"},{"$f":"$AC$27*'Oculto EI'!Z4","v":{"v":13,"d":"13.00"}},{"$f":"$AD$27","v":260},0.279999999999999,{"$f":"$AC$27*AG4","v":{"v":72.79999999999974,"d":"72.80"}},{"$f":"($AD$28/(AH4^($AC$26)))^(1/$AD$26)","v":{"v":1754.8350532571358,"d":"1,754.84"}},null,2,0.05,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL4","v":{"v":66.66666666666667,"d":"66.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM4))","v":{"v":1520,"d":"1,520.00"}},{"$f":"$AO$27","v":266.6666666666667},{"v":64,"d":"64.00"},{"$f":"$AO$27*'Oculto EI'!AL4","v":{"v":13.333333333333336,"d":"13.33"}},{"$f":"$AP$27","v":1280},0.279999999999999,{"$f":"$AO$27*AS4","v":{"v":74.66666666666642,"d":"74.67"}},{"$f":"($AP$28/(AT4^($AO$26)))^(1/$AP$26)","v":{"v":1759.6263702535248,"d":"1,759.63"}},null,2,0.05,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX4","v":{"v":66.66666666666667,"d":"66.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY4))","v":{"v":1520,"d":"1,520.00"}},{"$f":"$BA$27","v":266.6666666666667},{"$f":"$BB$27*AX4","v":{"v":64,"d":"64.00"}},{"$f":"$BA$27*'Oculto EI'!AX4","v":{"v":13.333333333333336,"d":"13.33"}},{"$f":"$BB$27","v":1280},0.279999999999999,{"$f":"$BA$27*BE4","v":{"v":74.66666666666642,"d":"74.67"}},{"$f":"($BB$28/(BF4^($BA$26)))^(1/$BB$26)","v":{"v":1759.6263702535248,"d":"1,759.63"}},null,2,0.05,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ4","v":{"v":9.545454545454545,"d":"9.55"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK4))","v":{"v":199.5,"d":"199.50"}},{"$f":"$BR$13","v":{"v":45,"d":"45.00"}},{"$f":"BP4*BJ4","v":{"v":8.025,"d":"8.03"}},{"$f":"BM4*BJ4","v":2.25},{"$f":"$BS$13","v":{"v":160.5,"d":"160.50"}},{"$f":"$BQ$25","v":0.1},{"$f":"$BR$13*BQ4","v":{"v":4.5,"d":"4.50"}},{"$f":"($BM$26+($BM$30*BR4)-($BM$28*$BM$30))/(BR4-$BM$28)","v":{"v":329.48275862068965,"d":"329.48"}},null,2,0.05,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV4","v":{"v":9.545454545454545,"d":"9.55"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW4))","v":{"v":199.5,"d":"199.50"}},{"$f":"$CD$13","v":{"v":45,"d":"45.00"}},{"$f":"CB4*BV4","v":{"v":8.025,"d":"8.03"}},{"$f":"BY4*BV4","v":2.25},{"$f":"$CE$13","v":{"v":160.5,"d":"160.50"}},{"$f":"$BQ$25","v":0.1},{"$f":"$BX$28*CC4","v":{"v":4.5,"d":"4.50"}},{"$f":"($BY$26+($BY$30*CD4)-($BY$28*$BY$30))/(CD4-$BY$28)","v":{"v":329.48275862068965,"d":"329.48"}},null,null,2,0.05,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI4","v":{"v":9.545454545454545,"d":"9.55"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ4))","v":{"v":199.5,"d":"199.50"}},{"$f":"$CK$28","v":{"v":45,"d":"45.00"}},{"$f":"CO4*CI4","v":{"v":8.025,"d":"8.03"}},{"$f":"CL4*CI4","v":2.25},{"$f":"$CK$29","v":{"v":160.5,"d":"160.50"}},{"$f":"$BQ$25","v":0.1},{"$f":"$CK$28*CP4","v":{"v":4.5,"d":"4.50"}},{"$f":"($CL$26+($CL$30*CQ4)-($CL$28*$CL$30))/(CQ4-$CL$28)","v":{"v":329.48275862068965,"d":"329.48"}},{"$nulls":4},"Tasa de Interés Anual",{"v":0.1,"d":"10%"},null,"Anualizado",{"$nulls":3},"Capitalizado",{"$nulls":3},0,{"$f":"$DI$29*DH4","v":0},{"$f":"DI30","v":{"v":100,"d":"100.00"}},{"$f":"$DJ$29*DH4","v":0},{"$f":"DJ30","v":{"v":100,"d":"100.00"}},null,null,"Tasa de interés real",{"$nulls":4},0,{"$f":"($DP$12+($DP$13/(1+$DP$14)))*DT4","v":0},{"$f":"($DP$12*(1+$DP$14))+$DP$13-(DU4*(1+$DP$14))","v":{"v":200,"d":"200.00"}},{"$f":"($DP$19/(DU4^$DP$17))^(1/$DP$18)","v":{"$error":"#DIV/0!"}},{"$f":"($DP$19/(DY4^$DP$18))^(1/($DP$17))","v":{"$error":"#DIV/0!"}},{"$f":"IF(DW4>$DV$4,DY5,DW4)","v":{"$error":"#DIV/0!"}},{"$f":"$DP$12*DT4","v":0},{"$f":"$DP$13","v":{"v":100,"d":"100.0"}},{"$f":"$DP$12","v":{"v":100,"d":"100.00 "}},{"$f":"$DP$13*DT4","v":{"v":0,"d":"0.0"}},{"$f":"$DP$10*DT4","v":{"v":0,"d":"0.0"}},{"$f":"$DP$11","v":{"v":100,"d":"100.0"}},{"$f":"$DP$10","v":{"v":100,"d":"100.00 "}},{"$f":"$DP$11*DT4","v":{"v":0,"d":"0.0"}},0,{"$f":"($DQ$12+($DQ$13/(1+$DQ$14)))*EH4","v":0},{"$f":"($DQ$12*(1+$DQ$14))+$DQ$13-(EI4*(1+$DQ$14))","v":{"v":200,"d":"200.00"}},{"$f":"($DQ$19/(EI4^$DQ$17))^(1/$DQ$18)","v":{"$error":"#DIV/0!"}},{"$f":"($DQ$19/(EM4^$DQ$18))^(1/($DQ$17))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EK4>$EJ$4,EM5,EK4)","v":{"$error":"#DIV/0!"}}]
[0.05,{"v":10.200000000000001,"d":"10.20"},{"$f":"B5^$C$28","v":{"v":5.081829853957273,"d":"5.08"}},{"$f":"$C$37","v":{"v":30,"d":"30.00"}},{"$f":"$C$39*$A5","v":{"v":0.5406981487565073,"d":"0.54"}},{"$f":"$C$37*$A5","v":{"v":1.5,"d":"1.50"}},{"$f":"$C$39","v":{"v":10.813962975130146,"d":"10.81"}},{"$f":"$C$36","v":{"v":170,"d":"170.00"}},{"$f":"$C$38*$A5","v":{"v":1.820892257596151,"d":"1.82"}},{"$f":"$C$36*$A5","v":{"v":8.5,"d":"8.50"}},{"$f":"$C$38","v":{"v":36.41784515192302,"d":"36.42"}},{"$f":"$C$29","v":{"v":100,"d":"100.00"}},{"$f":"$C$35*$A5","v":{"v":1.25594321575479,"d":"1.26"}},{"$f":"$C$29*$A5","v":{"v":5,"d":"5.00"}},{"$f":"$C$35","v":{"v":25.1188643150958,"d":"25.12"}},{"$f":"$G$29*A5","v":{"v":5,"d":"5.00"}},{"$f":"$C$42","v":{"v":23.615904063526582,"d":"23.62"}},{"v":100,"d":"100.00"},{"$f":"(MAX($P$43,$P$44))*A5","v":{"v":1.25594321575479,"d":"1.26"}},{"$f":"T4+(($C$36-$C$37)/20)","v":{"v":37,"d":"37.00"}},{"$f":"U4+(($C$38-$C$39)/20)","v":{"v":12.094157083969789,"d":"12.09"}},{"$f":"$O$43*A5","v":{"v":5,"d":"5.00"}},{"$f":"$P$43","v":{"v":25.1188643150958,"d":"25.12"}},null,3,{"v":0.1,"d":"0.10"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z5","v":{"v":43.333333333333336,"d":"43.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA5))","v":{"v":585,"d":"585.00"}},260,{"v":26,"d":"26.00"},{"$f":"$AC$27*'Oculto EI'!Z5","v":{"v":26,"d":"26.00"}},260,0.359999999999999,{"$f":"$AC$27*AG5","v":{"v":93.59999999999974,"d":"93.60"}},{"$f":"($AD$28/(AH5^($AC$26)))^(1/$AD$26)","v":{"v":1203.7037037037082,"d":"1,203.70"}},null,3,{"v":0.1,"d":"0.10"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL5","v":{"v":133.33333333333334,"d":"133.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM5))","v":{"v":1440,"d":"1,440.00"}},266.6666666666667,{"v":128,"d":"128.00"},{"$f":"$AO$27*'Oculto EI'!AL5","v":{"v":26.66666666666667,"d":"26.67"}},1280,0.359999999999999,{"v":95.99999999999973,"d":"96.00"},{"v":1652.4728943818325,"d":"1,652.47"},null,3,{"v":0.1,"d":"0.10"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX5","v":{"v":133.33333333333334,"d":"133.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY5))","v":{"v":1440,"d":"1,440.00"}},266.6666666666667,{"v":128,"d":"128.00"},{"$f":"$BA$27*'Oculto EI'!AX5","v":{"v":26.66666666666667,"d":"26.67"}},1280,0.359999999999999,{"v":95.99999999999973,"d":"96.00"},{"v":1652.4728943818325,"d":"1,652.47"},null,3,{"v":0.1,"d":"0.10"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ5","v":{"v":19.09090909090909,"d":"19.09"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK5))","v":{"v":189,"d":"189.00"}},{"v":45,"d":"45.00"},16.05,{"v":4.5,"d":"4.50"},{"v":160.5,"d":"160.50"},{"$f":"BQ4+$BQ$25","v":0.2},{"v":9,"d":"9.00"},{"v":275.13157894736844,"d":"275.13"},null,3,{"v":0.1,"d":"0.10"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV5","v":{"v":19.09090909090909,"d":"19.09"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW5))","v":{"v":189,"d":"189.00"}},{"v":45,"d":"45.00"},16.05,{"v":4.5,"d":"4.50"},{"v":160.5,"d":"160.50"},{"$f":"CC4+$BQ$25","v":0.2},{"$f":"$BX$28*CC5","v":{"v":9,"d":"9.00"}},{"v":275.13157894736844,"d":"275.13"},null,null,3,{"v":0.1,"d":"0.10"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI5","v":{"v":19.09090909090909,"d":"19.09"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ5))","v":{"v":189,"d":"189.00"}},{"v":45,"d":"45.00"},16.05,{"v":4.5,"d":"4.50"},{"v":160.5,"d":"160.50"},{"$f":"CP4+$BQ$25","v":0.2},{"$f":"$CK$28*CP5","v":{"v":9,"d":"9.00"}},{"v":275.13157894736844,"d":"275.13"},{"$nulls":4},"Años",20,null,"nominal",null,"real",null,"nominal",null,"real",null,0.05,{"$f":"$DI$29*DH5","v":{"v":0.1,"d":"0.10 "}},{"$f":"DJ4+$DI$32","v":101.05},{"$f":"$DJ$29*DH5","v":{"v":0.1,"d":"0.10 "}},{"$f":"DL4+$DJ$32","v":{"v":100.99773242630386,"d":"101.00"}},null,null,"Tasa de interés nominal",{"$f":"MercadoActivo!C6","v":{"v":0.05,"d":"0.050"}},{"$nulls":3},0.05,{"$f":"($DP$12+($DP$13/(1+$DP$14)))*DT5","v":{"v":10,"d":"10.00 "}},{"$f":"($DP$12*(1+$DP$14))+$DP$13-(DU5*(1+$DP$14))","v":{"v":190,"d":"190.00"}},{"v":1000,"d":"1,000.00"},{"$f":"($DP$19/(DY5^$DP$18))^(1/($DP$17))","v":{"v":50.00000000000001,"d":"50.00"}},{"$f":"IF(DW5>$DV$4,DY6,DW5)","v":199.99999999999997},{"$f":"$DP$12*DT5","v":{"v":5,"d":"5.00 "}},{"v":100,"d":"100.0"},{"$f":"$DP$12","v":{"v":100,"d":"100.00 "}},{"$f":"$DP$13*DT5","v":{"v":5,"d":"5.0"}},{"$f":"$DP$10*DT5","v":{"v":5,"d":"5.0"}},{"$f":"$DP$11","v":{"v":100,"d":"100.0"}},{"$f":"$DP$10","v":{"v":100,"d":"100.00 "}},{"$f":"$DP$11*DT5","v":{"v":5,"d":"5.0"}},0.05,{"$f":"($DQ$12+($DQ$13/(1+$DQ$14)))*EH5","v":{"v":10,"d":"10.00 "}},{"$f":"($DQ$12*(1+$DQ$14))+$DQ$13-(EI5*(1+$DQ$14))","v":{"v":190,"d":"190.00"}},{"$f":"($DQ$19/(EI5^$DQ$17))^(1/$DQ$18)","v":{"v":1000,"d":"1,000.00"}},{"$f":"($DQ$19/(EM5^$DQ$18))^(1/($DQ$17))","v":{"v":50.00000000000001,"d":"50.00"}},{"$f":"IF(EK5>$EJ$4,EM6,EK5)","v":199.99999999999997}]
[{"v":0.1,"d":"0.10"},{"v":20.400000000000002,"d":"20.40"},{"v":8.255456953502906,"d":"8.26"},{"v":30,"d":"30.00"},{"v":1.0813962975130147,"d":"1.08"},{"v":3,"d":"3.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":3.641784515192302,"d":"3.64"},{"v":17,"d":"17.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":2.51188643150958,"d":"2.51"},{"v":10,"d":"10.00"},{"v":25.1188643150958,"d":"25.12"},{"v":10,"d":"10.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":2.51188643150958,"d":"2.51"},{"$f":"T5+(($C$36-$C$37)/20)","v":{"v":44,"d":"44.00"}},{"$f":"U5+(($C$38-$C$39)/20)","v":{"v":13.374351192809431,"d":"13.37"}},{"v":10,"d":"10.00"},{"v":25.1188643150958,"d":"25.12"},null,4,0.15,{"$f":"('Cobb-Douglas EI'!$D$14)*Z6","v":{"v":65,"d":"65.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA6))","v":{"v":552.5,"d":"552.50"}},260,{"v":39,"d":"39.00"},{"$f":"$AC$27*'Oculto EI'!Z6","v":{"v":39,"d":"39.00"}},260,0.44,{"v":114.4,"d":"114.40"},{"v":890.8289726161198,"d":"890.83"},null,4,0.15,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL6","v":{"v":200.00000000000003,"d":"200.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM6))","v":{"v":1360,"d":"1,360.00"}},266.6666666666667,{"v":192,"d":"192.00"},{"$f":"$AO$27*'Oculto EI'!AL6","v":{"v":40,"d":"40.00"}},1280,0.44,{"v":117.33333333333334,"d":"117.33"},{"v":1571.6172990843015,"d":"1,571.62"},null,4,0.15,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX6","v":{"v":200.00000000000003,"d":"200.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY6))","v":{"v":1360,"d":"1,360.00"}},266.6666666666667,{"v":192,"d":"192.00"},{"$f":"$BA$27*'Oculto EI'!AX6","v":{"v":40,"d":"40.00"}},1280,0.44,{"v":117.33333333333334,"d":"117.33"},{"v":1571.6172990843015,"d":"1,571.62"},null,4,0.15,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ6","v":{"v":28.636363636363637,"d":"28.64"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK6))","v":{"v":178.5,"d":"178.50"}},{"v":45,"d":"45.00"},{"v":24.075,"d":"24.08"},6.75,{"v":160.5,"d":"160.50"},{"$f":"BQ5+$BQ$25","v":0.30000000000000004},{"v":13.500000000000002,"d":"13.50"},{"v":241.59574468085106,"d":"241.60"},null,4,0.15,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV6","v":{"v":28.636363636363637,"d":"28.64"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW6))","v":{"v":178.5,"d":"178.50"}},{"v":45,"d":"45.00"},{"v":24.075,"d":"24.08"},6.75,{"v":160.5,"d":"160.50"},{"$f":"CC5+$BQ$25","v":0.30000000000000004},{"v":13.500000000000002,"d":"13.50"},{"v":241.59574468085106,"d":"241.60"},null,null,4,0.15,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI6","v":{"v":28.636363636363637,"d":"28.64"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ6))","v":{"v":178.5,"d":"178.50"}},{"v":45,"d":"45.00"},{"v":24.075,"d":"24.08"},6.75,{"v":160.5,"d":"160.50"},{"$f":"CP5+$BQ$25","v":0.30000000000000004},{"v":13.500000000000002,"d":"13.50"},{"v":241.59574468085106,"d":"241.60"},{"$nulls":4},"Valor Futuro",{"$f":"CX3*((1+CX4)^(CX5))","v":{"v":6727.499949325609,"d":"6,727.50"}},null,"Capital final",{"$f":"DA7*((1+(DA9-DA34)/(1+DA34))^DA8)","v":{"v":121.00000000000001,"d":"121.0"}},"Capital final",{"$f":"DC7*((1+(DC9-DC10)/(1+DC10))^DC8)","v":{"v":119.95464852607711,"d":"120.0"}},"Capital final",{"$f":"DE7*((1+(DE11-DE46)/(1+DE46))^(DE8*DE9))","v":{"v":183.05864420633387,"d":"183.1"}},"Capital final",{"$f":"DG7*(1+(DG14))^(DG8*DG9)","v":{"v":164.95701474819018,"d":"165.0"}},{"v":0.1,"d":"0.10"},{"v":0.2,"d":"0.20 "},{"$f":"DJ5+$DI$32","v":{"v":102.1,"d":"102.10"}},{"v":0.2,"d":"0.20 "},{"$f":"DL5+$DJ$32","v":{"v":101.99546485260771,"d":"102.00"}},null,null,"Tasa de inflación",{"$f":"MercadoActivo!C7","v":{"v":0.06,"d":"0.060"}},{"$nulls":3},{"v":0.1,"d":"0.10"},{"v":20,"d":"20.00 "},{"v":180,"d":"180.00"},{"v":499.9999999999999,"d":"500.00"},{"$f":"($DP$19/(DY6^$DP$18))^(1/($DP$17))","v":{"v":50.00000000000001,"d":"50.00"}},199.99999999999997,{"v":10,"d":"10.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":10,"d":"10.0"},{"v":0.1,"d":"0.10"},{"v":20,"d":"20.00 "},{"v":180,"d":"180.00"},{"v":499.9999999999999,"d":"500.00"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997]
[0.15,{"v":30.599999999999998,"d":"30.60"},{"v":10.964908161941377,"d":"10.96"},{"v":30,"d":"30.00"},{"v":1.6220944462695217,"d":"1.62"},{"v":4.5,"d":"4.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":5.462676772788453,"d":"5.46"},{"v":25.5,"d":"25.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":3.7678296472643695,"d":"3.77"},{"v":15,"d":"15.00"},{"v":25.1188643150958,"d":"25.12"},{"v":15,"d":"15.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":3.7678296472643695,"d":"3.77"},{"v":51,"d":"51.00"},{"v":14.654545301649074,"d":"14.65"},{"v":15,"d":"15.00"},{"v":25.1188643150958,"d":"25.12"},null,5,{"v":0.2,"d":"0.20"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z7","v":{"v":86.66666666666667,"d":"86.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA7))","v":{"v":520,"d":"520.00"}},260,{"v":52,"d":"52.00"},{"$f":"$AC$27*'Oculto EI'!Z7","v":{"v":52,"d":"52.00"}},260,0.52,{"v":135.20000000000002,"d":"135.20"},{"v":693.3752452815359,"d":"693.38"},null,5,{"v":0.2,"d":"0.20"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL7","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM7))","v":{"v":1280,"d":"1,280.00"}},266.6666666666667,{"v":256,"d":"256.00"},{"$f":"$AO$27*'Oculto EI'!AL7","v":{"v":53.33333333333334,"d":"53.33"}},1280,0.52,{"v":138.66666666666669,"d":"138.67"},{"v":1507.3327448637667,"d":"1,507.33"},null,5,{"v":0.2,"d":"0.20"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX7","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY7))","v":{"v":1280,"d":"1,280.00"}},266.6666666666667,{"v":256,"d":"256.00"},{"$f":"$BA$27*'Oculto EI'!AX7","v":{"v":53.33333333333334,"d":"53.33"}},1280,0.52,{"v":138.66666666666669,"d":"138.67"},{"v":1507.3327448637667,"d":"1,507.33"},null,5,{"v":0.2,"d":"0.20"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ7","v":{"v":38.18181818181818,"d":"38.18"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK7))","v":{"v":168,"d":"168.00"}},{"v":45,"d":"45.00"},{"v":32.1,"d":"32.10"},{"v":9,"d":"9.00"},{"v":160.5,"d":"160.50"},0.4,{"v":18,"d":"18.00"},{"v":218.83928571428572,"d":"218.84"},null,5,{"v":0.2,"d":"0.20"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV7","v":{"v":38.18181818181818,"d":"38.18"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW7))","v":{"v":168,"d":"168.00"}},{"v":45,"d":"45.00"},{"v":32.1,"d":"32.10"},{"v":9,"d":"9.00"},{"v":160.5,"d":"160.50"},0.4,{"v":18,"d":"18.00"},{"v":218.83928571428572,"d":"218.84"},null,null,5,{"v":0.2,"d":"0.20"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI7","v":{"v":38.18181818181818,"d":"38.18"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ7))","v":{"v":168,"d":"168.00"}},{"v":45,"d":"45.00"},{"v":32.1,"d":"32.10"},{"v":9,"d":"9.00"},{"v":160.5,"d":"160.50"},0.4,{"v":18,"d":"18.00"},{"v":218.83928571428572,"d":"218.84"},{"$nulls":7},"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},0.15,{"v":0.3,"d":"0.30 "},{"v":103.14999999999999,"d":"103.15"},{"v":0.3,"d":"0.30 "},{"v":102.99319727891157,"d":"102.99"},null,null,"Tasa de interés real",{"$f":"(DP5-DP6)/(1+DP6)","v":{"v":-0.009433962264150938,"d":"-0.009"}},{"$nulls":3},0.15,{"v":30,"d":"30.00 "},{"v":170,"d":"170.00"},{"v":333.3333333333333,"d":"333.33"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997,{"v":15,"d":"15.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":15,"d":"15.0"},0.15,{"v":30,"d":"30.00 "},{"v":170,"d":"170.00"},{"v":333.3333333333333,"d":"333.33"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997]
[{"v":0.2,"d":"0.20"},{"v":40.800000000000004,"d":"40.80"},{"v":13.411029386996965,"d":"13.41"},{"v":30,"d":"30.00"},{"v":2.1627925950260294,"d":"2.16"},{"v":6,"d":"6.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":7.283569030384604,"d":"7.28"},{"v":34,"d":"34.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":5.02377286301916,"d":"5.02"},{"v":20,"d":"20.00"},{"v":25.1188643150958,"d":"25.12"},{"v":20,"d":"20.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":5.02377286301916,"d":"5.02"},{"v":58,"d":"58.00"},{"v":15.934739410488717,"d":"15.93"},{"v":20,"d":"20.00"},{"v":25.1188643150958,"d":"25.12"},null,6,0.25,{"$f":"('Cobb-Douglas EI'!$D$14)*Z8","v":{"v":108.33333333333333,"d":"108.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA8))","v":{"v":487.5,"d":"487.50"}},260,{"v":65,"d":"65.00"},{"$f":"$AC$27*'Oculto EI'!Z8","v":{"v":65,"d":"65.00"}},260,0.6,{"v":156,"d":"156.00"},{"v":559.4309277855156,"d":"559.43"},null,6,0.25,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL8","v":{"v":333.33333333333337,"d":"333.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM8))","v":{"v":1200,"d":"1,200.00"}},266.6666666666667,{"v":320,"d":"320.00"},{"$f":"$AO$27*'Oculto EI'!AL8","v":{"v":66.66666666666667,"d":"66.67"}},1280,0.6,{"v":160,"d":"160.00"},{"v":1454.3607890783996,"d":"1,454.36"},null,6,0.25,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX8","v":{"v":333.33333333333337,"d":"333.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY8))","v":{"v":1200,"d":"1,200.00"}},266.6666666666667,{"v":320,"d":"320.00"},{"$f":"$BA$27*'Oculto EI'!AX8","v":{"v":66.66666666666667,"d":"66.67"}},1280,0.6,{"v":160,"d":"160.00"},{"v":1454.3607890783996,"d":"1,454.36"},null,6,0.25,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ8","v":{"v":47.72727272727273,"d":"47.73"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK8))","v":{"v":157.5,"d":"157.50"}},{"v":45,"d":"45.00"},{"v":40.125,"d":"40.13"},11.25,{"v":160.5,"d":"160.50"},0.5,{"v":22.5,"d":"22.50"},{"v":202.3846153846154,"d":"202.38"},null,6,0.25,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV8","v":{"v":47.72727272727273,"d":"47.73"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW8))","v":{"v":157.5,"d":"157.50"}},{"v":45,"d":"45.00"},{"v":40.125,"d":"40.13"},11.25,{"v":160.5,"d":"160.50"},0.5,{"v":22.5,"d":"22.50"},{"v":202.3846153846154,"d":"202.38"},null,null,6,0.25,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI8","v":{"v":47.72727272727273,"d":"47.73"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ8))","v":{"v":157.5,"d":"157.50"}},{"v":45,"d":"45.00"},{"v":40.125,"d":"40.13"},11.25,{"v":160.5,"d":"160.50"},0.5,{"v":22.5,"d":"22.50"},{"v":202.3846153846154,"d":"202.38"},{"$nulls":4},"Capital final",{"v":1500000,"d":"1,500,000.00"},null,"Años",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},{"v":0.2,"d":"0.20"},{"v":0.4,"d":"0.40 "},{"v":104.19999999999999,"d":"104.20"},{"v":0.4,"d":"0.40 "},{"v":103.99092970521542,"d":"103.99"},null,null,"Tasa de interés real simplificada",{"$f":"DP5-DP6","v":{"v":-9.999999999999995E-3,"d":"-0.010"}},{"$nulls":3},{"v":0.2,"d":"0.20"},{"v":40,"d":"40.00 "},{"v":160,"d":"160.00"},{"v":250,"d":"250.00"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997,{"v":20,"d":"20.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":20,"d":"20.0"},{"v":20,"d":"20.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":20,"d":"20.0"},{"v":0.2,"d":"0.20"},{"v":40,"d":"40.00 "},{"v":160,"d":"160.00"},{"v":250,"d":"250.00"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997]
[0.25,{"v":51,"d":"51.00"},{"v":15.678305522365587,"d":"15.68"},{"v":30,"d":"30.00"},{"v":2.7034907437825364,"d":"2.70"},{"v":7.5,"d":"7.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":9.104461287980754,"d":"9.10"},{"v":42.5,"d":"42.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":6.27971607877395,"d":"6.28"},{"v":25,"d":"25.00"},{"v":25.1188643150958,"d":"25.12"},{"v":25,"d":"25.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":6.27971607877395,"d":"6.28"},{"v":65,"d":"65.00"},{"v":17.214933519328362,"d":"17.21"},{"v":25,"d":"25.00"},{"v":25.1188643150958,"d":"25.12"},null,7,{"v":0.3,"d":"0.30"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z9","v":{"v":130,"d":"130.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA9))","v":{"v":455,"d":"455.00"}},260,{"v":78,"d":"78.00"},{"$f":"$AC$27*'Oculto EI'!Z9","v":{"v":78,"d":"78.00"}},260,0.68,{"v":176.8,"d":"176.80"},{"v":463.6710478635776,"d":"463.67"},null,7,{"v":0.3,"d":"0.30"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL9","v":{"v":400.00000000000006,"d":"400.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM9))","v":{"v":1120,"d":"1,120.00"}},266.6666666666667,{"v":384,"d":"384.00"},{"$f":"$AO$27*'Oculto EI'!AL9","v":{"v":80,"d":"80.00"}},1280,0.68,{"v":181.33333333333337,"d":"181.33"},{"v":1409.5573206853428,"d":"1,409.56"},null,7,{"v":0.3,"d":"0.30"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX9","v":{"v":400.00000000000006,"d":"400.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY9))","v":{"v":1120,"d":"1,120.00"}},266.6666666666667,{"v":384,"d":"384.00"},{"$f":"$BA$27*'Oculto EI'!AX9","v":{"v":80,"d":"80.00"}},1280,0.68,{"v":181.33333333333337,"d":"181.33"},{"v":1409.5573206853428,"d":"1,409.56"},null,7,{"v":0.3,"d":"0.30"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ9","v":{"v":57.27272727272727,"d":"57.27"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK9))","v":{"v":147,"d":"147.00"}},{"v":45,"d":"45.00"},48.15,{"v":13.5,"d":"13.50"},{"v":160.5,"d":"160.50"},0.6,{"v":27,"d":"27.00"},{"v":189.93243243243242,"d":"189.93"},null,7,{"v":0.3,"d":"0.30"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV9","v":{"v":57.27272727272727,"d":"57.27"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW9))","v":{"v":147,"d":"147.00"}},{"v":45,"d":"45.00"},48.15,{"v":13.5,"d":"13.50"},{"v":160.5,"d":"160.50"},0.6,{"v":27,"d":"27.00"},{"v":189.93243243243242,"d":"189.93"},null,null,7,{"v":0.3,"d":"0.30"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI9","v":{"v":57.27272727272727,"d":"57.27"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ9))","v":{"v":147,"d":"147.00"}},{"v":45,"d":"45.00"},48.15,{"v":13.5,"d":"13.50"},{"v":160.5,"d":"160.50"},0.6,{"v":27,"d":"27.00"},{"v":189.93243243243242,"d":"189.93"},{"$nulls":4},"Tasa de Interés Anual",{"v":0.15,"d":"15%"},null,"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"15.0%"}},"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},0.25,{"v":0.5,"d":"0.50 "},{"v":105.24999999999999,"d":"105.25"},{"v":0.5,"d":"0.50 "},{"v":104.98866213151928,"d":"104.99"},null,null,"Prestatario","Caso 1","Caso 2",null,null,0.25,{"v":50,"d":"50.00 "},{"v":150,"d":"150.00"},{"v":199.99999999999997,"d":"200.00"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997,{"v":25,"d":"25.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":25,"d":"25.0"},{"v":25,"d":"25.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":25,"d":"25.0"},0.25,{"v":50,"d":"50.00 "},{"v":150,"d":"150.00"},{"v":199.99999999999997,"d":"200.00"},{"v":50.00000000000001,"d":"50.00"},199.99999999999997]
[{"v":0.3,"d":"0.30"},{"v":61.199999999999996,"d":"61.20"},{"v":17.81254586072586,"d":"17.81"},{"v":30,"d":"30.00"},{"v":3.2441888925390434,"d":"3.24"},{"v":9,"d":"9.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":10.925353545576906,"d":"10.93"},{"v":51,"d":"51.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":7.535659294528739,"d":"7.54"},{"v":30,"d":"30.00"},{"v":25.1188643150958,"d":"25.12"},{"v":30,"d":"30.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":7.535659294528739,"d":"7.54"},{"v":72,"d":"72.00"},{"v":18.495127628168007,"d":"18.50"},{"v":30,"d":"30.00"},{"v":25.1188643150958,"d":"25.12"},null,8,0.35,{"$f":"('Cobb-Douglas EI'!$D$14)*Z10","v":{"v":151.66666666666666,"d":"151.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA10))","v":{"v":422.5,"d":"422.50"}},260,{"v":91,"d":"91.00"},{"$f":"$AC$27*'Oculto EI'!Z10","v":{"v":91,"d":"91.00"}},260,0.76,{"v":197.6,"d":"197.60"},{"v":392.42165004175024,"d":"392.42"},null,8,0.35,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL10","v":{"v":466.6666666666667,"d":"466.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM10))","v":{"v":1040,"d":"1,040.00"}},266.6666666666667,{"v":448,"d":"448.00"},{"$f":"$AO$27*'Oculto EI'!AL10","v":{"v":93.33333333333333,"d":"93.33"}},1280,0.76,{"v":202.66666666666669,"d":"202.67"},{"v":1370.9025099793355,"d":"1,370.90"},null,8,0.35,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX10","v":{"v":466.6666666666667,"d":"466.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY10))","v":{"v":1040,"d":"1,040.00"}},266.6666666666667,{"v":448,"d":"448.00"},{"$f":"$BA$27*'Oculto EI'!AX10","v":{"v":93.33333333333333,"d":"93.33"}},1280,0.76,{"v":202.66666666666669,"d":"202.67"},{"v":1370.9025099793355,"d":"1,370.90"},null,8,0.35,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ10","v":{"v":66.81818181818181,"d":"66.82"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK10))","v":{"v":136.5,"d":"136.50"}},{"v":45,"d":"45.00"},{"v":56.175,"d":"56.18"},{"v":15.749999999999998,"d":"15.75"},{"v":160.5,"d":"160.50"},0.7,{"v":31.499999999999996,"d":"31.50"},{"v":180.18072289156626,"d":"180.18"},null,8,0.35,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV10","v":{"v":66.81818181818181,"d":"66.82"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW10))","v":{"v":136.5,"d":"136.50"}},{"v":45,"d":"45.00"},{"v":56.175,"d":"56.18"},{"v":15.749999999999998,"d":"15.75"},{"v":160.5,"d":"160.50"},0.7,{"v":31.499999999999996,"d":"31.50"},{"v":180.18072289156626,"d":"180.18"},null,null,8,0.35,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI10","v":{"v":66.81818181818181,"d":"66.82"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ10))","v":{"v":136.5,"d":"136.50"}},{"v":45,"d":"45.00"},{"v":56.175,"d":"56.18"},{"v":15.749999999999998,"d":"15.75"},{"v":160.5,"d":"160.50"},0.7,{"v":31.499999999999996,"d":"31.50"},{"v":180.18072289156626,"d":"180.18"},{"$nulls":4},"Años",5,null,null,{"$f":"DA8","v":{"v":2,"d":"2.0"}},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"5.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":{"v":0.1,"d":"10.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10.0%"}},{"v":0.3,"d":"0.30"},{"v":0.6,"d":"0.60 "},{"v":106.29999999999998,"d":"106.30"},{"v":0.6,"d":"0.60 "},{"v":105.98639455782313,"d":"105.99"},null,null,"C1",{"$f":"(DP17*((DP12*(1+DP14))+DP13))/(1+DP14)","v":{"v":100,"d":"100.0"}},{"$f":"(DQ17*((DQ12*(1+DQ14))+DQ13))/(1+DQ14)","v":{"v":100,"d":"100.0"}},null,null,{"v":0.3,"d":"0.30"},{"v":60,"d":"60.00 "},{"v":140,"d":"140.00"},{"v":166.66666666666666,"d":"166.67"},{"v":60.00000000000001,"d":"60.00"},166.66666666666666,{"v":30,"d":"30.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":30,"d":"30.0"},{"v":30,"d":"30.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":30,"d":"30.0"},{"v":0.3,"d":"0.30"},{"v":60,"d":"60.00 "},{"v":140,"d":"140.00"},{"v":166.66666666666666,"d":"166.67"},{"v":60.00000000000001,"d":"60.00"},166.66666666666666]
[0.35,{"v":71.39999999999999,"d":"71.40"},{"v":19.842150905217515,"d":"19.84"},{"v":30,"d":"30.00"},{"v":3.784887041295551,"d":"3.78"},{"v":10.5,"d":"10.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":12.746245803173055,"d":"12.75"},{"v":59.49999999999999,"d":"59.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":8.791602510283528,"d":"8.79"},{"v":35,"d":"35.00"},{"v":25.1188643150958,"d":"25.12"},{"v":35,"d":"35.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":8.791602510283528,"d":"8.79"},{"v":79,"d":"79.00"},{"v":19.77532173700765,"d":"19.78"},{"v":35,"d":"35.00"},{"v":25.1188643150958,"d":"25.12"},null,9,{"v":0.4,"d":"0.40"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z11","v":{"v":173.33333333333334,"d":"173.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA11))","v":{"v":390,"d":"390.00"}},260,{"v":104,"d":"104.00"},{"$f":"$AC$27*'Oculto EI'!Z11","v":{"v":104,"d":"104.00"}},260,0.84,{"v":218.4,"d":"218.40"},{"v":337.7181634604644,"d":"337.72"},null,9,{"v":0.4,"d":"0.40"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL11","v":{"v":533.3333333333334,"d":"533.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM11))","v":{"v":960,"d":"960.00"}},266.6666666666667,{"v":512,"d":"512.00"},{"$f":"$AO$27*'Oculto EI'!AL11","v":{"v":106.66666666666669,"d":"106.67"}},1280,0.84,{"v":224,"d":"224.00"},{"v":1337.0269095322085,"d":"1,337.03"},null,9,{"v":0.4,"d":"0.40"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX11","v":{"v":533.3333333333334,"d":"533.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY11))","v":{"v":960,"d":"960.00"}},266.6666666666667,{"v":512,"d":"512.00"},{"$f":"$BA$27*'Oculto EI'!AX11","v":{"v":106.66666666666669,"d":"106.67"}},1280,0.84,{"v":224,"d":"224.00"},{"v":1337.0269095322085,"d":"1,337.03"},null,9,{"v":0.4,"d":"0.40"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ11","v":{"v":76.36363636363636,"d":"76.36"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK11))","v":{"v":126,"d":"126.00"}},{"v":45,"d":"45.00"},{"v":64.2,"d":"64.20"},{"v":18,"d":"18.00"},{"v":160.5,"d":"160.50"},0.7999999999999999,{"v":36,"d":"36.00"},{"v":172.33695652173913,"d":"172.34"},null,9,{"v":0.4,"d":"0.40"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV11","v":{"v":76.36363636363636,"d":"76.36"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW11))","v":{"v":126,"d":"126.00"}},{"v":45,"d":"45.00"},{"v":64.2,"d":"64.20"},{"v":18,"d":"18.00"},{"v":160.5,"d":"160.50"},0.7999999999999999,{"v":36,"d":"36.00"},{"v":172.33695652173913,"d":"172.34"},null,null,9,{"v":0.4,"d":"0.40"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI11","v":{"v":76.36363636363636,"d":"76.36"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ11))","v":{"v":126,"d":"126.00"}},{"v":45,"d":"45.00"},{"v":64.2,"d":"64.20"},{"v":18,"d":"18.00"},{"v":160.5,"d":"160.50"},0.7999999999999999,{"v":36,"d":"36.00"},{"v":172.33695652173913,"d":"172.34"},{"$nulls":4},"Valor Presente",{"$f":"CX8/((1+CX9)^(CX10))","v":{"v":745765.1029474349,"d":"745,765.10"}},{"$nulls":3},"Tasa de interés real",{"$f":"(DC9-DC10)/(1+DC10)","v":{"v":0.09523809523809523,"d":"9.5%"}},"Tasa de interés por periodo",{"$f":"DE10/DE9","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG10/DG9","v":{"v":0.008333333333333333,"d":"0.8%"}},0.35,{"v":0.7,"d":"0.70 "},{"v":107.34999999999998,"d":"107.35"},{"v":0.7,"d":"0.70 "},{"v":106.98412698412699,"d":"106.98"},null,null,"C2",{"$f":"DP18*((DP12*(1+DP14))+DP13)","v":{"v":100,"d":"100.0"}},{"$f":"DQ18*((DQ12*(1+DQ14))+DQ13)","v":{"v":100,"d":"100.0"}},null,null,0.35,{"v":70,"d":"70.00 "},{"v":130,"d":"130.00"},{"v":142.85714285714286,"d":"142.86"},{"v":70,"d":"70.00"},142.85714285714286,{"v":35,"d":"35.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":35,"d":"35.0"},{"v":35,"d":"35.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":35,"d":"35.0"},0.35,{"v":70,"d":"70.00 "},{"v":130,"d":"130.00"},{"v":142.85714285714286,"d":"142.86"},{"v":70,"d":"70.00"},142.85714285714286]
[{"v":0.4,"d":"0.40"},{"v":81.60000000000001,"d":"81.60"},{"v":21.786281514384363,"d":"21.79"},{"v":30,"d":"30.00"},{"v":4.325585190052059,"d":"4.33"},{"v":12,"d":"12.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":14.567138060769208,"d":"14.57"},{"v":68,"d":"68.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":10.04754572603832,"d":"10.05"},{"v":40,"d":"40.00"},{"v":25.1188643150958,"d":"25.12"},{"v":40,"d":"40.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":10.04754572603832,"d":"10.05"},{"v":86,"d":"86.00"},{"v":21.055515845847296,"d":"21.06"},{"v":40,"d":"40.00"},{"v":25.1188643150958,"d":"25.12"},null,10,0.45,{"$f":"('Cobb-Douglas EI'!$D$14)*Z12","v":{"v":195,"d":"195.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA12))","v":{"v":357.5,"d":"357.50"}},260,{"v":117,"d":"117.00"},{"$f":"$AC$27*'Oculto EI'!Z12","v":{"v":117,"d":"117.00"}},260,0.92,{"v":239.20000000000002,"d":"239.20"},{"v":294.6399329067359,"d":"294.64"},null,10,0.45,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL12","v":{"v":600.0000000000001,"d":"600.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM12))","v":{"v":879.9999999999999,"d":"880.00"}},266.6666666666667,{"v":576,"d":"576.00"},{"$f":"$AO$27*'Oculto EI'!AL12","v":{"v":120.00000000000001,"d":"120.00"}},1280,0.92,{"v":245.33333333333337,"d":"245.33"},{"v":1306.9621570479976,"d":"1,306.96"},null,10,0.45,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX12","v":{"v":600.0000000000001,"d":"600.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY12))","v":{"v":879.9999999999999,"d":"880.00"}},266.6666666666667,{"v":576,"d":"576.00"},{"$f":"$BA$27*'Oculto EI'!AX12","v":{"v":120.00000000000001,"d":"120.00"}},1280,0.92,{"v":245.33333333333337,"d":"245.33"},{"v":1306.9621570479976,"d":"1,306.96"},null,10,0.45,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ12","v":{"v":85.9090909090909,"d":"85.91"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK12))","v":{"v":115.5,"d":"115.50"}},{"v":45,"d":"45.00"},{"v":72.22500000000001,"d":"72.23"},20.25,{"v":160.5,"d":"160.50"},0.8999999999999999,{"v":40.49999999999999,"d":"40.50"},{"v":165.8910891089109,"d":"165.89"},null,10,0.45,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV12","v":{"v":85.9090909090909,"d":"85.91"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW12))","v":{"v":115.5,"d":"115.50"}},{"v":45,"d":"45.00"},{"v":72.22500000000001,"d":"72.23"},20.25,{"v":160.5,"d":"160.50"},0.8999999999999999,{"v":40.49999999999999,"d":"40.50"},{"v":165.8910891089109,"d":"165.89"},null,null,10,0.45,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI12","v":{"v":85.9090909090909,"d":"85.91"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ12))","v":{"v":115.5,"d":"115.50"}},{"v":45,"d":"45.00"},{"v":72.22500000000001,"d":"72.23"},20.25,{"v":160.5,"d":"160.50"},0.8999999999999999,{"v":40.49999999999999,"d":"40.50"},{"v":165.8910891089109,"d":"165.89"},{"$nulls":7},"CI",null,"CI",{"$nulls":3},"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},{"v":0.4,"d":"0.40"},{"v":0.8,"d":"0.80 "},{"v":108.39999999999998,"d":"108.40"},{"v":0.8,"d":"0.80 "},{"v":107.98185941043084,"d":"107.98"},null,null,"m1",{"$f":"MercadoActivo!$C$14","v":{"v":100,"d":"100.0"}},{"$f":"DP12","v":{"v":100,"d":"100.0"}},null,null,{"v":0.4,"d":"0.40"},{"v":80,"d":"80.00 "},{"v":120,"d":"120.00"},{"v":124.99999999999997,"d":"125.00"},{"v":80.00000000000001,"d":"80.00"},124.99999999999997,{"v":40,"d":"40.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":40,"d":"40.0"},{"v":40,"d":"40.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":40,"d":"40.0"},{"v":0.4,"d":"0.40"},{"v":80,"d":"80.00 "},{"v":120,"d":"120.00"},{"v":124.99999999999997,"d":"125.00"},{"v":80.00000000000001,"d":"80.00"},124.99999999999997]
[0.45,{"v":91.8,"d":"91.80"},{"v":23.658645498763587,"d":"23.66"},{"v":30,"d":"30.00"},{"v":4.866283338808565,"d":"4.87"},{"v":13.5,"d":"13.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":16.38803031836536,"d":"16.39"},{"v":76.5,"d":"76.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":11.303488941793109,"d":"11.30"},{"v":45,"d":"45.00"},{"v":25.1188643150958,"d":"25.12"},{"v":45,"d":"45.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":11.303488941793109,"d":"11.30"},{"v":93,"d":"93.00"},{"v":22.33570995468694,"d":"22.34"},{"v":45,"d":"45.00"},{"v":25.1188643150958,"d":"25.12"},null,11,{"v":0.5,"d":"0.50"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z13","v":{"v":216.66666666666666,"d":"216.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA13))","v":{"v":325,"d":"325.00"}},260,{"v":130,"d":"130.00"},{"$f":"$AC$27*'Oculto EI'!Z13","v":{"v":130,"d":"130.00"}},260,1,{"$f":"$AC$27*AG13","v":{"v":260,"d":"260.00"}},{"v":260.00000000000017,"d":"260.00"},null,11,{"v":0.5,"d":"0.50"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL13","v":{"v":666.6666666666667,"d":"666.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM13))","v":{"v":799.9999999999999,"d":"800.00"}},266.6666666666667,{"v":640,"d":"640.00"},{"$f":"$AO$27*'Oculto EI'!AL13","v":{"v":133.33333333333334,"d":"133.33"}},1280,1,{"v":266.6666666666667,"d":"266.67"},{"v":1280,"d":"1,280.00"},null,11,{"v":0.5,"d":"0.50"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX13","v":{"v":666.6666666666667,"d":"666.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY13))","v":{"v":799.9999999999999,"d":"800.00"}},266.6666666666667,{"v":640,"d":"640.00"},{"$f":"$BA$27*'Oculto EI'!AX13","v":{"v":133.33333333333334,"d":"133.33"}},1280,1,{"v":266.6666666666667,"d":"266.67"},{"v":1280,"d":"1,280.00"},null,11,{"v":0.5,"d":"0.50"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ13","v":{"v":95.45454545454545,"d":"95.45"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK13))","v":{"v":105,"d":"105.00"}},{"v":45,"d":"45.00"},80.25,{"v":22.5,"d":"22.50"},{"v":160.5,"d":"160.50"},1,{"$f":"BL28","v":{"v":45,"d":"45.00"}},{"v":160.5,"d":"160.50"},null,11,{"v":0.5,"d":"0.50"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV13","v":{"v":95.45454545454545,"d":"95.45"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW13))","v":{"v":105,"d":"105.00"}},{"v":45,"d":"45.00"},80.25,{"v":22.5,"d":"22.50"},{"v":160.5,"d":"160.50"},1,{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},null,null,11,{"v":0.5,"d":"0.50"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI13","v":{"v":95.45454545454545,"d":"95.45"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ13))","v":{"v":105,"d":"105.00"}},{"v":45,"d":"45.00"},80.25,{"v":22.5,"d":"22.50"},{"v":160.5,"d":"160.50"},1,{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},{"$nulls":4},"CAPITALIZACIONES",null,null,"Capital inicial",{"$f":"DA14/((1+((DA16-DA34)/(1+DA34)))^DA15)","v":{"v":82.64462809917354,"d":"82.6"}},"Capital inicial",{"$f":"DC14/((1+((DC16-DC17)/(1+DC17)))^DC15)","v":{"v":83.36483931947069,"d":"83.4"}},null,null,"Tasa de interés real anual",{"$f":"(DG10-DG12)/(1+DG12)","v":{"v":0.047619047619047616,"d":"4.8%"}},0.45,{"v":0.9,"d":"0.90 "},{"v":109.44999999999997,"d":"109.45"},{"v":0.9,"d":"0.90 "},{"v":108.9795918367347,"d":"108.98"},null,null,"m2",{"$f":"MercadoActivo!$C$15","v":{"v":100,"d":"100.0"}},{"$f":"DP13","v":{"v":100,"d":"100.0"}},null,null,0.45,{"v":90,"d":"90.00 "},{"v":110,"d":"110.00"},{"v":111.1111111111111,"d":"111.11"},{"v":90,"d":"90.00"},111.1111111111111,{"v":45,"d":"45.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":45,"d":"45.0"},{"v":45,"d":"45.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":45,"d":"45.0"},0.45,{"v":90,"d":"90.00 "},{"v":110,"d":"110.00"},{"v":111.1111111111111,"d":"111.11"},{"v":90,"d":"90.00"},111.1111111111111]
[{"v":0.5,"d":"0.50"},{"v":102,"d":"102.00"},{"v":25.46948246269329,"d":"25.47"},{"v":30,"d":"30.00"},{"v":5.406981487565073,"d":"5.41"},{"v":15,"d":"15.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":18.20892257596151,"d":"18.21"},{"v":85,"d":"85.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":12.5594321575479,"d":"12.56"},{"v":50,"d":"50.00"},{"v":25.1188643150958,"d":"25.12"},{"v":50,"d":"50.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":12.5594321575479,"d":"12.56"},{"v":100,"d":"100.00"},{"v":23.615904063526585,"d":"23.62"},{"v":50,"d":"50.00"},{"v":25.1188643150958,"d":"25.12"},null,12,0.55,{"$f":"('Cobb-Douglas EI'!$D$14)*Z14","v":{"v":238.33333333333334,"d":"238.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA14))","v":{"v":292.5,"d":"292.50"}},260,{"v":143,"d":"143.00"},{"$f":"$AC$27*'Oculto EI'!Z14","v":{"v":143,"d":"143.00"}},260,1.08,{"$f":"$AC$27*AG14","v":{"v":280.8,"d":"280.80"}},{"v":231.652885785961,"d":"231.65"},null,12,0.55,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL14","v":{"v":733.3333333333335,"d":"733.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM14))","v":{"v":719.9999999999999,"d":"720.00"}},266.6666666666667,{"v":704,"d":"704.00"},{"$f":"$AO$27*'Oculto EI'!AL14","v":{"v":146.66666666666669,"d":"146.67"}},1280,1.08,{"$f":"$AO$27*AS14","v":{"v":288.00000000000006,"d":"288.00"}},{"$f":"($AP$28/(AT14^($AO$26)))^(1/$AP$26)","v":{"v":1255.6078747232898,"d":"1,255.61"}},null,12,0.55,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX14","v":{"v":733.3333333333335,"d":"733.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY14))","v":{"v":719.9999999999999,"d":"720.00"}},266.6666666666667,{"v":704,"d":"704.00"},{"$f":"$BA$27*'Oculto EI'!AX14","v":{"v":146.66666666666669,"d":"146.67"}},1280,1.08,{"$f":"$BA$27*BE14","v":{"v":288.00000000000006,"d":"288.00"}},{"$f":"($BB$28/(BF14^($BA$26)))^(1/$BB$26)","v":{"v":1255.6078747232898,"d":"1,255.61"}},null,12,0.55,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ14","v":{"v":105,"d":"105.00"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK14))","v":{"v":94.49999999999999,"d":"94.50"}},{"v":45,"d":"45.00"},{"v":88.275,"d":"88.28"},{"v":24.750000000000004,"d":"24.75"},{"v":160.5,"d":"160.50"},{"$f":"BQ13+$BQ$25","v":1.1},{"$f":"$BR$13*BQ14","v":{"v":49.50000000000001,"d":"49.50"}},{"$f":"($BM$26+($BM$30*BR14)-($BM$28*$BM$30))/(BR14-$BM$28)","v":{"v":155.92436974789914,"d":"155.92"}},null,12,0.55,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV14","v":{"v":105,"d":"105.00"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW14))","v":{"v":94.49999999999999,"d":"94.50"}},{"v":45,"d":"45.00"},{"v":88.275,"d":"88.28"},{"v":24.750000000000004,"d":"24.75"},{"v":160.5,"d":"160.50"},{"$f":"CC13+$BQ$25","v":1.1},{"v":49.50000000000001,"d":"49.50"},{"$f":"($BY$26+($BY$30*CD14)-($BY$28*$BY$30))/(CD14-$BY$28)","v":{"v":155.92436974789914,"d":"155.92"}},null,null,12,0.55,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI14","v":{"v":105,"d":"105.00"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ14))","v":{"v":94.49999999999999,"d":"94.50"}},{"v":45,"d":"45.00"},{"v":88.275,"d":"88.28"},{"v":24.750000000000004,"d":"24.75"},{"v":160.5,"d":"160.50"},{"$f":"CP13+$BQ$25","v":1.1},{"v":49.50000000000001,"d":"49.50"},{"$f":"($CL$26+($CL$30*CQ14)-($CL$28*$CL$30))/(CQ14-$CL$28)","v":{"v":155.92436974789914,"d":"155.92"}},{"$nulls":4},"Capital Inicial",{"v":1000,"d":"1,000.00"},null,"Capital final",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital final",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},null,null,"Tasa de interés real por periodo",{"$f":"DG13/DG9","v":{"v":3.968253968253968E-3,"d":"0.40%"}},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00 "},{"v":110.49999999999997,"d":"110.50"},{"v":1,"d":"1.00 "},{"v":109.97732426303855,"d":"109.98"},null,null,"r",{"$f":"MercadoActivo!$C$16","v":{"v":0,"d":"0.0"}},{"$f":"MercadoActivo!D16","v":{"v":0,"d":"0.0"}},null,null,{"v":0.5,"d":"0.50"},{"v":100,"d":"100.00 "},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},100,{"v":50,"d":"50.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":50,"d":"50.0"},{"v":50,"d":"50.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":50,"d":"50.0"},{"v":0.5,"d":"0.50"},{"v":100,"d":"100.00 "},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},100]
[0.55,{"v":112.2,"d":"112.20"},{"v":27.226699610237663,"d":"27.23"},{"v":30,"d":"30.00"},{"v":5.94767963632158,"d":"5.95"},{"v":16.5,"d":"16.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":20.029814833557662,"d":"20.03"},{"v":93.50000000000001,"d":"93.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":13.81537537330269,"d":"13.82"},{"v":55.00000000000001,"d":"55.00"},{"v":25.1188643150958,"d":"25.12"},{"v":55.00000000000001,"d":"55.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":13.81537537330269,"d":"13.82"},{"v":107,"d":"107.00"},{"v":24.89609817236623,"d":"24.90"},{"v":55.00000000000001,"d":"55.00"},{"v":25.1188643150958,"d":"25.12"},null,13,{"v":0.6,"d":"0.60"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z15","v":{"v":260,"d":"260.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA15))","v":{"v":260,"d":"260.00"}},260,{"v":156,"d":"156.00"},{"$f":"$AC$27*'Oculto EI'!Z15","v":{"v":156,"d":"156.00"}},260,1.16,{"v":301.59999999999997,"d":"301.60"},{"v":208.1068445087649,"d":"208.11"},null,13,{"v":0.6,"d":"0.60"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL15","v":{"v":800.0000000000001,"d":"800.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM15))","v":{"v":639.9999999999999,"d":"640.00"}},266.6666666666667,{"v":768,"d":"768.00"},{"$f":"$AO$27*'Oculto EI'!AL15","v":{"v":160,"d":"160.00"}},1280,1.16,{"v":309.3333333333333,"d":"309.33"},{"v":1233.37594039547,"d":"1,233.38"},null,13,{"v":0.6,"d":"0.60"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX15","v":{"v":800.0000000000001,"d":"800.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY15))","v":{"v":639.9999999999999,"d":"640.00"}},266.6666666666667,{"v":768,"d":"768.00"},{"$f":"$BA$27*'Oculto EI'!AX15","v":{"v":160,"d":"160.00"}},1280,1.16,{"v":309.3333333333333,"d":"309.33"},{"v":1233.37594039547,"d":"1,233.38"},null,13,{"v":0.6,"d":"0.60"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ15","v":{"v":114.54545454545455,"d":"114.55"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK15))","v":{"v":83.99999999999999,"d":"84.00"}},{"v":45,"d":"45.00"},{"v":96.3,"d":"96.30"},{"v":27,"d":"27.00"},{"v":160.5,"d":"160.50"},{"$f":"BQ14+$BQ$25","v":1.2000000000000002},{"$f":"$BR$13*BQ15","v":{"v":54.00000000000001,"d":"54.00"}},{"v":151.9921875,"d":"151.99"},null,13,{"v":0.6,"d":"0.60"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV15","v":{"v":114.54545454545455,"d":"114.55"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW15))","v":{"v":83.99999999999999,"d":"84.00"}},{"v":45,"d":"45.00"},{"v":96.3,"d":"96.30"},{"v":27,"d":"27.00"},{"v":160.5,"d":"160.50"},{"$f":"CC14+$BQ$25","v":1.2000000000000002},{"v":54.00000000000001,"d":"54.00"},{"v":151.9921875,"d":"151.99"},null,null,13,{"v":0.6,"d":"0.60"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI15","v":{"v":114.54545454545455,"d":"114.55"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ15))","v":{"v":83.99999999999999,"d":"84.00"}},{"v":45,"d":"45.00"},{"v":96.3,"d":"96.30"},{"v":27,"d":"27.00"},{"v":160.5,"d":"160.50"},{"$f":"CP14+$BQ$25","v":1.2000000000000002},{"v":54.00000000000001,"d":"54.00"},{"v":151.9921875,"d":"151.99"},{"$nulls":4},"Tasa de Interés Anual",{"v":0.1,"d":"10%"},null,"Años",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"CI",null,"CI",null,0.55,{"v":1.1,"d":"1.10 "},{"v":111.54999999999997,"d":"111.55"},{"v":1.1,"d":"1.10 "},{"v":110.97505668934241,"d":"110.98"},{"$nulls":7},0.55,{"v":110.00000000000001,"d":"110.00 "},{"v":89.99999999999999,"d":"90.00"},{"v":90.90909090909089,"d":"90.91"},{"v":110,"d":"110.00"},90.90909090909089,{"v":55.00000000000001,"d":"55.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":55.00000000000001,"d":"55.0"},{"v":55.00000000000001,"d":"55.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":55.00000000000001,"d":"55.0"},0.55,{"v":110.00000000000001,"d":"110.00 "},{"v":89.99999999999999,"d":"90.00"},{"v":90.90909090909089,"d":"90.91"},{"v":110,"d":"110.00"},90.90909090909089]
[{"v":0.6,"d":"0.60"},{"v":122.39999999999999,"d":"122.40"},{"v":28.93656612115985,"d":"28.94"},{"v":30,"d":"30.00"},{"v":6.488377785078087,"d":"6.49"},{"v":18,"d":"18.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":21.85070709115381,"d":"21.85"},{"v":102,"d":"102.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":15.071318589057478,"d":"15.07"},{"v":60,"d":"60.00"},{"v":25.1188643150958,"d":"25.12"},{"v":60,"d":"60.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":15.071318589057478,"d":"15.07"},{"v":114,"d":"114.00"},{"v":26.176292281205875,"d":"26.18"},{"v":60,"d":"60.00"},{"v":25.1188643150958,"d":"25.12"},null,14,0.65,{"$f":"('Cobb-Douglas EI'!$D$14)*Z16","v":{"v":281.6666666666667,"d":"281.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA16))","v":{"v":227.5,"d":"227.50"}},260,{"v":169,"d":"169.00"},{"$f":"$AC$27*'Oculto EI'!Z16","v":{"v":169,"d":"169.00"}},260,1.24,{"v":322.4,"d":"322.40"},{"v":188.29588115710268,"d":"188.30"},null,14,0.65,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL16","v":{"v":866.6666666666667,"d":"866.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM16))","v":{"v":560,"d":"560.00"}},266.6666666666667,{"v":832,"d":"832.00"},{"$f":"$AO$27*'Oculto EI'!AL16","v":{"v":173.33333333333334,"d":"173.33"}},1280,1.24,{"v":330.6666666666667,"d":"330.67"},{"v":1212.982536644012,"d":"1,212.98"},null,14,0.65,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX16","v":{"v":866.6666666666667,"d":"866.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY16))","v":{"v":560,"d":"560.00"}},266.6666666666667,{"v":832,"d":"832.00"},{"$f":"$BA$27*'Oculto EI'!AX16","v":{"v":173.33333333333334,"d":"173.33"}},1280,1.24,{"v":330.6666666666667,"d":"330.67"},{"v":1212.982536644012,"d":"1,212.98"},null,14,0.65,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ16","v":{"v":124.0909090909091,"d":"124.09"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK16))","v":{"v":73.5,"d":"73.50"}},{"v":45,"d":"45.00"},{"v":104.325,"d":"104.33"},29.25,{"v":160.5,"d":"160.50"},1.3000000000000003,{"v":58.500000000000014,"d":"58.50"},{"v":148.57664233576642,"d":"148.58"},null,14,0.65,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV16","v":{"v":124.0909090909091,"d":"124.09"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW16))","v":{"v":73.5,"d":"73.50"}},{"v":45,"d":"45.00"},{"v":104.325,"d":"104.33"},29.25,{"v":160.5,"d":"160.50"},1.3000000000000003,{"v":58.500000000000014,"d":"58.50"},{"v":148.57664233576642,"d":"148.58"},null,null,14,0.65,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI16","v":{"v":124.0909090909091,"d":"124.09"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ16))","v":{"v":73.5,"d":"73.50"}},{"v":45,"d":"45.00"},{"v":104.325,"d":"104.33"},29.25,{"v":160.5,"d":"160.50"},1.3000000000000003,{"v":58.500000000000014,"d":"58.50"},{"v":148.57664233576642,"d":"148.58"},{"$nulls":4},"Capitalizaciones al año",6,null,"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"15.0%"}},"Capital inicial",{"$f":"DE17/((1+((DE21-DE46)/(1+DE46)))^(DE18*DE19))","v":{"v":122.91143145711933,"d":"122.9"}},"Capital inicial",{"$f":"DG17/((1+(DG24))^(DG18*DG19))","v":{"v":136.39917062239914,"d":"136.4"}},{"v":0.6,"d":"0.60"},{"v":1.2,"d":"1.20 "},{"v":112.59999999999997,"d":"112.60"},{"v":1.2,"d":"1.20 "},{"v":111.97278911564626,"d":"111.97"},null,null,"Función de utilidad","Caso 1","Caso 2",null,null,{"v":0.6,"d":"0.60"},{"v":120,"d":"120.00 "},{"v":80,"d":"80.00"},{"v":83.33333333333333,"d":"83.33"},{"v":120,"d":"120.00"},83.33333333333333,{"v":60,"d":"60.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":60,"d":"60.0"},{"v":60,"d":"60.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":60,"d":"60.0"},{"v":0.6,"d":"0.60"},{"v":120,"d":"120.00 "},{"v":80,"d":"80.00"},{"v":83.33333333333333,"d":"83.33"},{"v":120,"d":"120.00"},83.33333333333333]
[0.65,{"v":132.6,"d":"132.60"},{"v":30.6041602140924,"d":"30.60"},{"v":30,"d":"30.00"},{"v":7.029075933834595,"d":"7.03"},{"v":19.5,"d":"19.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":23.67159934874996,"d":"23.67"},{"v":110.5,"d":"110.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":16.32726180481227,"d":"16.33"},{"v":65,"d":"65.00"},{"v":25.1188643150958,"d":"25.12"},{"v":65,"d":"65.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":16.32726180481227,"d":"16.33"},{"v":121,"d":"121.00"},{"v":27.45648639004552,"d":"27.46"},{"v":65,"d":"65.00"},{"v":25.1188643150958,"d":"25.12"},null,15,{"v":0.7,"d":"0.70"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z17","v":{"v":303.3333333333333,"d":"303.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA17))","v":{"v":195,"d":"195.00"}},260,{"v":182,"d":"182.00"},{"$f":"$AC$27*'Oculto EI'!Z17","v":{"v":182,"d":"182.00"}},260,1.32,{"v":343.2,"d":"343.20"},{"v":171.44011571394483,"d":"171.44"},null,15,{"v":0.7,"d":"0.70"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL17","v":{"v":933.3333333333334,"d":"933.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM17))","v":{"v":480,"d":"480.00"}},266.6666666666667,{"v":896,"d":"896.00"},{"$f":"$AO$27*'Oculto EI'!AL17","v":{"v":186.66666666666666,"d":"186.67"}},1280,1.32,{"v":352.00000000000006,"d":"352.00"},{"v":1194.170908031625,"d":"1,194.17"},null,15,{"v":0.7,"d":"0.70"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX17","v":{"v":933.3333333333334,"d":"933.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY17))","v":{"v":480,"d":"480.00"}},266.6666666666667,{"v":896,"d":"896.00"},{"$f":"$BA$27*'Oculto EI'!AX17","v":{"v":186.66666666666666,"d":"186.67"}},1280,1.32,{"v":352.00000000000006,"d":"352.00"},{"v":1194.170908031625,"d":"1,194.17"},null,15,{"v":0.7,"d":"0.70"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ17","v":{"v":133.63636363636363,"d":"133.64"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK17))","v":{"v":63,"d":"63.00"}},{"v":45,"d":"45.00"},112.35,{"v":31.499999999999996,"d":"31.50"},{"v":160.5,"d":"160.50"},1.4000000000000004,{"v":63.000000000000014,"d":"63.00"},{"v":145.58219178082192,"d":"145.58"},null,15,{"v":0.7,"d":"0.70"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV17","v":{"v":133.63636363636363,"d":"133.64"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW17))","v":{"v":63,"d":"63.00"}},{"v":45,"d":"45.00"},112.35,{"v":31.499999999999996,"d":"31.50"},{"v":160.5,"d":"160.50"},1.4000000000000004,{"v":63.000000000000014,"d":"63.00"},{"v":145.58219178082192,"d":"145.58"},null,null,15,{"v":0.7,"d":"0.70"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI17","v":{"v":133.63636363636363,"d":"133.64"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ17))","v":{"v":63,"d":"63.00"}},{"v":45,"d":"45.00"},112.35,{"v":31.499999999999996,"d":"31.50"},{"v":160.5,"d":"160.50"},1.4000000000000004,{"v":63.000000000000014,"d":"63.00"},{"v":145.58219178082192,"d":"145.58"},{"$nulls":4},"Años",20,{"$nulls":3},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"5.0%"}},"Capital final",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital final",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},0.65,{"v":1.3,"d":"1.30 "},{"v":113.64999999999996,"d":"113.65"},{"v":1.3,"d":"1.30 "},{"v":112.97052154195012,"d":"112.97"},null,null,"a",{"$f":"MercadoActivo!C19","v":0.5},{"$f":"DP17","v":0.5},null,null,0.65,{"v":130,"d":"130.00 "},{"v":70,"d":"70.00"},{"v":76.92307692307693,"d":"76.92"},{"v":130,"d":"130.00"},76.92307692307693,{"v":65,"d":"65.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":65,"d":"65.0"},{"v":65,"d":"65.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":65,"d":"65.0"},0.65,{"v":130,"d":"130.00 "},{"v":70,"d":"70.00"},{"v":76.92307692307693,"d":"76.92"},{"v":130,"d":"130.00"},76.92307692307693]
[{"v":0.7,"d":"0.70"},{"v":142.79999999999998,"d":"142.80"},{"v":32.23366924324995,"d":"32.23"},{"v":30,"d":"30.00"},{"v":7.569774082591102,"d":"7.57"},{"v":21,"d":"21.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":25.49249160634611,"d":"25.49"},{"v":118.99999999999999,"d":"119.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":17.583205020567057,"d":"17.58"},{"v":70,"d":"70.00"},{"v":25.1188643150958,"d":"25.12"},{"v":70,"d":"70.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":17.583205020567057,"d":"17.58"},{"v":128,"d":"128.00"},{"v":28.736680498885164,"d":"28.74"},{"v":70,"d":"70.00"},{"v":25.1188643150958,"d":"25.12"},null,16,0.75,{"$f":"('Cobb-Douglas EI'!$D$14)*Z18","v":{"v":325,"d":"325.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA18))","v":{"v":162.5,"d":"162.50"}},260,{"v":195,"d":"195.00"},{"$f":"$AC$27*'Oculto EI'!Z18","v":{"v":195,"d":"195.00"}},260,1.4,{"v":364,"d":"364.00"},{"v":156.95721873529598,"d":"156.96"},null,16,0.75,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL18","v":{"v":1000.0000000000001,"d":"1,000.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM18))","v":{"v":400,"d":"400.00"}},266.6666666666667,{"v":960,"d":"960.00"},{"$f":"$AO$27*'Oculto EI'!AL18","v":{"v":200,"d":"200.00"}},1280,1.4,{"v":373.3333333333333,"d":"373.33"},{"v":1176.733075487895,"d":"1,176.73"},null,16,0.75,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX18","v":{"v":1000.0000000000001,"d":"1,000.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY18))","v":{"v":400,"d":"400.00"}},266.6666666666667,{"v":960,"d":"960.00"},{"$f":"$BA$27*'Oculto EI'!AX18","v":{"v":200,"d":"200.00"}},1280,1.4,{"v":373.3333333333333,"d":"373.33"},{"v":1176.733075487895,"d":"1,176.73"},null,16,0.75,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ18","v":{"v":143.1818181818182,"d":"143.18"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK18))","v":{"v":52.49999999999997,"d":"52.50"}},{"v":45,"d":"45.00"},{"v":120.375,"d":"120.38"},33.75,{"v":160.5,"d":"160.50"},1.5000000000000004,{"v":67.50000000000001,"d":"67.50"},{"v":142.93548387096774,"d":"142.94"},null,16,0.75,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV18","v":{"v":143.1818181818182,"d":"143.18"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW18))","v":{"v":52.49999999999997,"d":"52.50"}},{"v":45,"d":"45.00"},{"v":120.375,"d":"120.38"},33.75,{"v":160.5,"d":"160.50"},1.5000000000000004,{"v":67.50000000000001,"d":"67.50"},{"v":142.93548387096774,"d":"142.94"},null,null,16,0.75,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI18","v":{"v":143.1818181818182,"d":"143.18"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ18))","v":{"v":52.49999999999997,"d":"52.50"}},{"v":45,"d":"45.00"},{"v":120.375,"d":"120.38"},33.75,{"v":160.5,"d":"160.50"},1.5000000000000004,{"v":67.50000000000001,"d":"67.50"},{"v":142.93548387096774,"d":"142.94"},{"$nulls":4},"Valor Futuro",{"$f":"CX14*((1+(CX15/CX16))^(CX17*CX16))","v":{"v":7268.254992160201,"d":"7,268.25"}},{"$nulls":3},"Tasa de interés real",{"$f":"(DC16-DC17)/(1+DC17)","v":{"v":0.09523809523809523,"d":"9.5%"}},"Años",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Años",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},{"v":0.7,"d":"0.70"},{"v":1.4,"d":"1.40 "},{"v":114.69999999999996,"d":"114.70"},{"v":1.4,"d":"1.40 "},{"v":113.96825396825398,"d":"113.97"},null,null,"1-a",{"$f":"1-DP17","v":0.5},{"$f":"1-DQ17","v":0.5},null,null,{"v":0.7,"d":"0.70"},{"v":140,"d":"140.00 "},{"v":60,"d":"60.00"},{"v":71.42857142857144,"d":"71.43"},{"v":139.99999999999997,"d":"140.00"},71.42857142857144,{"v":70,"d":"70.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":70,"d":"70.0"},{"v":70,"d":"70.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":70,"d":"70.0"},{"v":0.7,"d":"0.70"},{"v":140,"d":"140.00 "},{"v":60,"d":"60.00"},{"v":71.42857142857144,"d":"71.43"},{"v":139.99999999999997,"d":"140.00"},71.42857142857144]
[0.75,{"v":153,"d":"153.00"},{"v":33.82859818766424,"d":"33.83"},{"v":30,"d":"30.00"},{"v":8.11047223134761,"d":"8.11"},{"v":22.5,"d":"22.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":27.313383863942263,"d":"27.31"},{"v":127.5,"d":"127.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":18.839148236321847,"d":"18.84"},{"v":75,"d":"75.00"},{"v":25.1188643150958,"d":"25.12"},{"v":75,"d":"75.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":18.839148236321847,"d":"18.84"},{"v":135,"d":"135.00"},{"v":30.01687460772481,"d":"30.02"},{"v":75,"d":"75.00"},{"v":25.1188643150958,"d":"25.12"},null,17,{"v":0.8,"d":"0.80"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z19","v":{"v":346.6666666666667,"d":"346.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA19))","v":{"v":130,"d":"130.00"}},260,{"v":208,"d":"208.00"},{"$f":"$AC$27*'Oculto EI'!Z19","v":{"v":208,"d":"208.00"}},260,1.48,{"v":384.8,"d":"384.80"},{"v":144.40451587632737,"d":"144.40"},null,17,{"v":0.8,"d":"0.80"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL19","v":{"v":1066.6666666666667,"d":"1,066.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM19))","v":{"v":320,"d":"320.00"}},266.6666666666667,{"v":1024,"d":"1,024.00"},{"$f":"$AO$27*'Oculto EI'!AL19","v":{"v":213.33333333333337,"d":"213.33"}},1280,1.48,{"v":394.6666666666667,"d":"394.67"},{"v":1160.4983860417406,"d":"1,160.50"},null,17,{"v":0.8,"d":"0.80"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX19","v":{"v":1066.6666666666667,"d":"1,066.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY19))","v":{"v":320,"d":"320.00"}},266.6666666666667,{"v":1024,"d":"1,024.00"},{"$f":"$BA$27*'Oculto EI'!AX19","v":{"v":213.33333333333337,"d":"213.33"}},1280,1.48,{"v":394.6666666666667,"d":"394.67"},{"v":1160.4983860417406,"d":"1,160.50"},null,17,{"v":0.8,"d":"0.80"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ19","v":{"v":152.72727272727272,"d":"152.73"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK19))","v":{"v":42,"d":"42.00"}},{"v":45,"d":"45.00"},{"v":128.4,"d":"128.40"},{"v":36,"d":"36.00"},{"v":160.5,"d":"160.50"},1.6000000000000005,{"v":72.00000000000003,"d":"72.00"},{"v":140.5792682926829,"d":"140.58"},null,17,{"v":0.8,"d":"0.80"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV19","v":{"v":152.72727272727272,"d":"152.73"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW19))","v":{"v":42,"d":"42.00"}},{"v":45,"d":"45.00"},{"v":128.4,"d":"128.40"},{"v":36,"d":"36.00"},{"v":160.5,"d":"160.50"},1.6000000000000005,{"v":72.00000000000003,"d":"72.00"},{"v":140.5792682926829,"d":"140.58"},null,null,17,{"v":0.8,"d":"0.80"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI19","v":{"v":152.72727272727272,"d":"152.73"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ19))","v":{"v":42,"d":"42.00"}},{"v":45,"d":"45.00"},{"v":128.4,"d":"128.40"},{"v":36,"d":"36.00"},{"v":160.5,"d":"160.50"},1.6000000000000005,{"v":72.00000000000003,"d":"72.00"},{"v":140.5792682926829,"d":"140.58"},{"$nulls":7},{"$f":"ValorPyF!B5","v":"Anualizado nominal"},null,"n",null,"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},0.75,{"v":1.5,"d":"1.50 "},{"v":115.74999999999996,"d":"115.75"},{"v":1.5,"d":"1.50 "},{"v":114.96598639455783,"d":"114.97"},null,null,"U",{"$f":"(DP10^DP17)*(DP11^DP18)","v":{"v":100,"d":"100.0"}},{"$f":"(DQ10^DQ17)*(DQ11^DQ18)","v":{"v":100,"d":"100.0"}},null,null,0.75,{"v":150,"d":"150.00 "},{"v":50,"d":"50.00"},{"v":66.66666666666667,"d":"66.67"},{"v":150,"d":"150.00"},66.66666666666667,{"v":75,"d":"75.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":75,"d":"75.0"},{"v":75,"d":"75.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":75,"d":"75.0"},0.75,{"v":150,"d":"150.00 "},{"v":50,"d":"50.00"},{"v":66.66666666666667,"d":"66.67"},{"v":150,"d":"150.00"},66.66666666666667]
[{"v":0.8,"d":"0.80"},{"v":163.20000000000002,"d":"163.20"},{"v":35.3919187355005,"d":"35.39"},{"v":30,"d":"30.00"},{"v":8.651170380104118,"d":"8.65"},{"v":24,"d":"24.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":29.134276121538417,"d":"29.13"},{"v":136,"d":"136.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":20.09509145207664,"d":"20.10"},{"v":80,"d":"80.00"},{"v":25.1188643150958,"d":"25.12"},{"v":80,"d":"80.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":20.09509145207664,"d":"20.10"},{"v":142,"d":"142.00"},{"v":31.297068716564453,"d":"31.30"},{"v":80,"d":"80.00"},{"v":25.1188643150958,"d":"25.12"},null,18,0.85,{"$f":"('Cobb-Douglas EI'!$D$14)*Z20","v":{"v":368.3333333333333,"d":"368.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA20))","v":{"v":97.5,"d":"97.50"}},260,{"v":221,"d":"221.00"},{"$f":"$AC$27*'Oculto EI'!Z20","v":{"v":221,"d":"221.00"}},260,1.56,{"v":405.6,"d":"405.60"},{"v":133.44012817090584,"d":"133.44"},null,18,0.85,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL20","v":{"v":1133.3333333333335,"d":"1,133.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM20))","v":{"v":239.99999999999977,"d":"240.00"}},266.6666666666667,{"v":1088,"d":"1,088.00"},{"$f":"$AO$27*'Oculto EI'!AL20","v":{"v":226.66666666666669,"d":"226.67"}},1280,1.56,{"v":416.00000000000006,"d":"416.00"},{"v":1145.3252096986569,"d":"1,145.33"},null,18,0.85,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX20","v":{"v":1133.3333333333335,"d":"1,133.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY20))","v":{"v":239.99999999999977,"d":"240.00"}},266.6666666666667,{"v":1088,"d":"1,088.00"},{"$f":"$BA$27*'Oculto EI'!AX20","v":{"v":226.66666666666669,"d":"226.67"}},1280,1.56,{"v":416.00000000000006,"d":"416.00"},{"v":1145.3252096986569,"d":"1,145.33"},null,18,0.85,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ20","v":{"v":162.27272727272728,"d":"162.27"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK20))","v":{"v":31.49999999999997,"d":"31.50"}},{"v":45,"d":"45.00"},{"v":136.42499999999998,"d":"136.43"},38.25,{"v":160.5,"d":"160.50"},1.7000000000000006,{"v":76.50000000000003,"d":"76.50"},{"v":138.46820809248555,"d":"138.47"},null,18,0.85,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV20","v":{"v":162.27272727272728,"d":"162.27"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW20))","v":{"v":31.49999999999997,"d":"31.50"}},{"v":45,"d":"45.00"},{"v":136.42499999999998,"d":"136.43"},38.25,{"v":160.5,"d":"160.50"},1.7000000000000006,{"v":76.50000000000003,"d":"76.50"},{"v":138.46820809248555,"d":"138.47"},null,null,18,0.85,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI20","v":{"v":162.27272727272728,"d":"162.27"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ20))","v":{"v":31.49999999999997,"d":"31.50"}},{"v":45,"d":"45.00"},{"v":136.42499999999998,"d":"136.43"},38.25,{"v":160.5,"d":"160.50"},1.7000000000000006,{"v":76.50000000000003,"d":"76.50"},{"v":138.46820809248555,"d":"138.47"},{"$nulls":4},"Capital final",{"v":1500000,"d":"1,500,000.00"},null,"Años",{"$f":"(LN(DA22/DA21))/(LN(1+(DA23-DA34)/(1+DA34)))","v":{"v":-41.04517495885186,"d":"-41.0"}},"Años",{"$f":"(LN(DC22/DC21))/(LN(1+(DC23-DC24)/(1+DC24)))","v":{"v":-43.00260017542319,"d":"-43.0"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":0.1},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10%"}},{"v":0.8,"d":"0.80"},{"v":1.6,"d":"1.60 "},{"v":116.79999999999995,"d":"116.80"},{"v":1.6,"d":"1.60 "},{"v":115.96371882086169,"d":"115.96"},{"$nulls":7},{"v":0.8,"d":"0.80"},{"v":160,"d":"160.00 "},{"v":40,"d":"40.00"},{"v":62.5,"d":"62.50"},{"v":160.00000000000003,"d":"160.00"},62.5,{"v":80,"d":"80.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":80,"d":"80.0"},{"v":80,"d":"80.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":80,"d":"80.0"},{"v":0.8,"d":"0.80"},{"v":160,"d":"160.00 "},{"v":40,"d":"40.00"},{"v":62.5,"d":"62.50"},{"v":160.00000000000003,"d":"160.00"},62.5]
[0.85,{"v":173.4,"d":"173.40"},{"v":36.926178540187955,"d":"36.93"},{"v":30,"d":"30.00"},{"v":9.191868528860624,"d":"9.19"},{"v":25.5,"d":"25.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":30.955168379134566,"d":"30.96"},{"v":144.5,"d":"144.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":21.351034667831428,"d":"21.35"},{"v":85,"d":"85.00"},{"v":25.1188643150958,"d":"25.12"},{"v":85,"d":"85.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":21.351034667831428,"d":"21.35"},{"v":149,"d":"149.00"},{"v":32.5772628254041,"d":"32.58"},{"v":85,"d":"85.00"},{"v":25.1188643150958,"d":"25.12"},null,19,{"v":0.9,"d":"0.90"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z21","v":{"v":390,"d":"390.00"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA21))","v":{"v":65,"d":"65.00"}},260,{"v":234,"d":"234.00"},{"$f":"$AC$27*'Oculto EI'!Z21","v":{"v":234,"d":"234.00"}},260,1.64,{"v":426.4,"d":"426.40"},{"v":123.79627466779755,"d":"123.80"},null,19,{"v":0.9,"d":"0.90"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL21","v":{"v":1200.0000000000002,"d":"1,200.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM21))","v":{"v":159.99999999999977,"d":"160.00"}},266.6666666666667,{"v":1152,"d":"1,152.00"},{"$f":"$AO$27*'Oculto EI'!AL21","v":{"v":240.00000000000003,"d":"240.00"}},1280,1.64,{"v":437.3333333333333,"d":"437.33"},{"v":1131.0948047760892,"d":"1,131.09"},null,19,{"v":0.9,"d":"0.90"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX21","v":{"v":1200.0000000000002,"d":"1,200.00"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY21))","v":{"v":159.99999999999977,"d":"160.00"}},266.6666666666667,{"v":1152,"d":"1,152.00"},{"$f":"$BA$27*'Oculto EI'!AX21","v":{"v":240.00000000000003,"d":"240.00"}},1280,1.64,{"v":437.3333333333333,"d":"437.33"},{"v":1131.0948047760892,"d":"1,131.09"},null,19,{"v":0.9,"d":"0.90"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ21","v":{"v":171.8181818181818,"d":"171.82"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK21))","v":{"v":21,"d":"21.00"}},{"v":45,"d":"45.00"},{"v":144.45000000000002,"d":"144.45"},{"v":40.5,"d":"40.50"},{"v":160.5,"d":"160.50"},1.8000000000000007,{"v":81.00000000000003,"d":"81.00"},{"v":136.56593406593407,"d":"136.57"},null,19,{"v":0.9,"d":"0.90"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV21","v":{"v":171.8181818181818,"d":"171.82"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW21))","v":{"v":21,"d":"21.00"}},{"v":45,"d":"45.00"},{"v":144.45000000000002,"d":"144.45"},{"v":40.5,"d":"40.50"},{"v":160.5,"d":"160.50"},1.8000000000000007,{"v":81.00000000000003,"d":"81.00"},{"v":136.56593406593407,"d":"136.57"},null,null,19,{"v":0.9,"d":"0.90"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI21","v":{"v":171.8181818181818,"d":"171.82"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ21))","v":{"v":21,"d":"21.00"}},{"v":45,"d":"45.00"},{"v":144.45000000000002,"d":"144.45"},{"v":40.5,"d":"40.50"},{"v":160.5,"d":"160.50"},1.8000000000000007,{"v":81.00000000000003,"d":"81.00"},{"v":136.56593406593407,"d":"136.57"},{"$nulls":4},"Tasa de Interés Anual",{"v":0.15,"d":"15%"},null,"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Tasa de interés por periodo",{"$f":"DE20/DE19","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG20/DG19","v":{"v":0.008333333333333333,"d":"0.8%"}},0.85,{"v":1.7,"d":"1.70 "},{"v":117.84999999999995,"d":"117.85"},{"v":1.7,"d":"1.70 "},{"v":116.96145124716554,"d":"116.96"},{"$nulls":7},0.85,{"v":170,"d":"170.00 "},{"v":30,"d":"30.00"},{"v":58.8235294117647,"d":"58.82"},{"v":170.00000000000003,"d":"170.00"},58.8235294117647,{"v":85,"d":"85.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":85,"d":"85.0"},{"v":85,"d":"85.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":85,"d":"85.0"},0.85,{"v":170,"d":"170.00 "},{"v":30,"d":"30.00"},{"v":58.8235294117647,"d":"58.82"},{"v":170.00000000000003,"d":"170.00"},58.8235294117647]
[{"v":0.9,"d":"0.90"},{"v":183.6,"d":"183.60"},{"v":38.433583001826776,"d":"38.43"},{"v":30,"d":"30.00"},{"v":9.73256667761713,"d":"9.73"},{"v":27,"d":"27.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":32.77606063673072,"d":"32.78"},{"v":153,"d":"153.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":22.606977883586218,"d":"22.61"},{"v":90,"d":"90.00"},{"v":25.1188643150958,"d":"25.12"},{"v":90,"d":"90.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":22.606977883586218,"d":"22.61"},{"v":156,"d":"156.00"},{"v":33.85745693424374,"d":"33.86"},{"v":90,"d":"90.00"},{"v":25.1188643150958,"d":"25.12"},null,20,0.95,{"$f":"('Cobb-Douglas EI'!$D$14)*Z22","v":{"v":411.66666666666663,"d":"411.67"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA22))","v":{"v":32.5,"d":"32.50"}},260,{"v":247,"d":"247.00"},{"$f":"$AC$27*'Oculto EI'!Z22","v":{"v":247,"d":"247.00"}},260,1.72,{"v":447.2,"d":"447.20"},{"v":115.26054734441041,"d":"115.26"},null,20,0.95,{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL22","v":{"v":1266.6666666666667,"d":"1,266.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM22))","v":{"v":80,"d":"80.00"}},266.6666666666667,{"v":1216,"d":"1,216.00"},{"$f":"$AO$27*'Oculto EI'!AL22","v":{"v":253.33333333333334,"d":"253.33"}},1280,1.72,{"v":458.6666666666667,"d":"458.67"},{"v":1117.7067093673093,"d":"1,117.71"},null,20,0.95,{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX22","v":{"v":1266.6666666666667,"d":"1,266.67"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY22))","v":{"v":80,"d":"80.00"}},266.6666666666667,{"v":1216,"d":"1,216.00"},{"$f":"$BA$27*'Oculto EI'!AX22","v":{"v":253.33333333333334,"d":"253.33"}},1280,1.72,{"v":458.6666666666667,"d":"458.67"},{"v":1117.7067093673093,"d":"1,117.71"},null,20,0.95,{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ22","v":{"v":181.36363636363635,"d":"181.36"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK22))","v":{"v":10.5,"d":"10.50"}},{"v":45,"d":"45.00"},{"v":152.475,"d":"152.48"},42.75,{"v":160.5,"d":"160.50"},1.9000000000000008,{"v":85.50000000000004,"d":"85.50"},{"v":134.84293193717275,"d":"134.84"},null,20,0.95,{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV22","v":{"v":181.36363636363635,"d":"181.36"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW22))","v":{"v":10.5,"d":"10.50"}},{"v":45,"d":"45.00"},{"v":152.475,"d":"152.48"},42.75,{"v":160.5,"d":"160.50"},1.9000000000000008,{"v":85.50000000000004,"d":"85.50"},{"v":134.84293193717275,"d":"134.84"},null,null,20,0.95,{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI22","v":{"v":181.36363636363635,"d":"181.36"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ22))","v":{"v":10.5,"d":"10.50"}},{"v":45,"d":"45.00"},{"v":152.475,"d":"152.48"},42.75,{"v":160.5,"d":"160.50"},1.9000000000000008,{"v":85.50000000000004,"d":"85.50"},{"v":134.84293193717275,"d":"134.84"},{"$nulls":4},"Capitalizaciones al año",4,null,"Capital final",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},null,null,"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},{"v":0.9,"d":"0.90"},{"v":1.8,"d":"1.80 "},{"v":118.89999999999995,"d":"118.90"},{"v":1.8,"d":"1.80 "},{"v":117.9591836734694,"d":"117.96"},{"$nulls":7},{"v":0.9,"d":"0.90"},{"v":180,"d":"180.00 "},{"v":20,"d":"20.00"},{"v":55.55555555555555,"d":"55.56"},{"v":180.00000000000003,"d":"180.00"},55.55555555555555,{"v":90,"d":"90.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":90,"d":"90.0"},{"v":90,"d":"90.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":90,"d":"90.0"},{"v":0.9,"d":"0.90"},{"v":180,"d":"180.00 "},{"v":20,"d":"20.00"},{"v":55.55555555555555,"d":"55.56"},{"v":180.00000000000003,"d":"180.00"},55.55555555555555]
[0.95,{"v":193.79999999999998,"d":"193.80"},{"v":39.916057622683375,"d":"39.92"},{"v":30,"d":"30.00"},{"v":10.273264826373637,"d":"10.27"},{"v":28.5,"d":"28.50"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":34.59695289432687,"d":"34.60"},{"v":161.5,"d":"161.50"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":23.86292109934101,"d":"23.86"},{"v":95,"d":"95.00"},{"v":25.1188643150958,"d":"25.12"},{"v":95,"d":"95.00"},{"v":23.615904063526582,"d":"23.62"},{"v":100,"d":"100.00"},{"v":23.86292109934101,"d":"23.86"},{"v":163,"d":"163.00"},{"v":35.13765104308339,"d":"35.14"},{"v":95,"d":"95.00"},{"v":25.1188643150958,"d":"25.12"},null,21,{"v":1,"d":"1.00"},{"$f":"('Cobb-Douglas EI'!$D$14)*Z23","v":{"v":433.3333333333333,"d":"433.33"}},{"$f":"'Cobb-Douglas EI'!$D$7+('Cobb-Douglas EI'!$C$7*(1+'Cobb-Douglas EI'!$B$7)-(1+'Cobb-Douglas EI'!$B$7)*('Oculto EI'!AA23))","v":0},260,{"$f":"$AD$27*Z23","v":{"v":260,"d":"260.00"}},{"$f":"$AC$27*'Oculto EI'!Z23","v":{"v":260,"d":"260.00"}},260,1.8,{"v":468,"d":"468.00"},{"v":107.66253224998982,"d":"107.66"},null,21,{"v":1,"d":"1.00"},{"$f":"('Cobb-Douglas Ampliado EI'!$D$18)*AL23","v":{"v":1333.3333333333335,"d":"1,333.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$8+('Cobb-Douglas Ampliado EI'!$D$8*(1+'Cobb-Douglas Ampliado EI'!$C$8))-((1+'Cobb-Douglas Ampliado EI'!$C$8)*('Oculto EI'!AM23))","v":0},266.6666666666667,{"$f":"$AP$27*AL23","v":{"v":1280,"d":"1,280.00"}},{"$f":"$AO$27*'Oculto EI'!AL23","v":{"v":266.6666666666667,"d":"266.67"}},1280,1.8,{"v":480.00000000000006,"d":"480.00"},{"v":1105.0752273541766,"d":"1,105.08"},null,21,{"v":1,"d":"1.00"},{"$f":"('Cobb-Douglas Ampliado EI'!$E$18)*AX23","v":{"v":1333.3333333333335,"d":"1,333.33"}},{"$f":"'Cobb-Douglas Ampliado EI'!$E$9+('Cobb-Douglas Ampliado EI'!$D$9*(1+'Cobb-Douglas Ampliado EI'!$C$9))-((1+'Cobb-Douglas Ampliado EI'!$C$9)*('Oculto EI'!AY23))","v":0},266.6666666666667,{"v":1280,"d":"1,280.00"},{"$f":"$BA$27*'Oculto EI'!AX23","v":{"v":266.6666666666667,"d":"266.67"}},1280,1.8,{"v":480.00000000000006,"d":"480.00"},{"v":1105.0752273541766,"d":"1,105.08"},null,21,{"v":1,"d":"1.00"},{"$f":"'Regulares EI'!$D$14*'Oculto EI'!BJ23","v":{"v":190.9090909090909,"d":"190.91"}},{"$f":"'Regulares EI'!$D$7+('Regulares EI'!$C$7*(1+'Regulares EI'!$B$7))-((1+'Regulares EI'!$B$7)*('Oculto EI'!BK23))","v":0},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},2.000000000000001,{"v":90.00000000000004,"d":"90.00"},{"v":133.27499999999998,"d":"133.28"},null,21,{"v":1,"d":"1.00"},{"$f":"'Regulares Ampliado EI'!$D$18*'Oculto EI'!BV23","v":{"v":190.9090909090909,"d":"190.91"}},{"$f":"'Regulares Ampliado EI'!$E$8+('Regulares Ampliado EI'!$D$8*(1+'Regulares Ampliado EI'!$C$8))-((1+'Regulares Ampliado EI'!$C$8)*('Oculto EI'!BW23))","v":0},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},2.000000000000001,{"v":90.00000000000004,"d":"90.00"},{"v":133.27499999999998,"d":"133.28"},null,null,21,{"v":1,"d":"1.00"},{"$f":"'Regulares Ampliado EI'!$E$18*'Oculto EI'!CI23","v":{"v":190.9090909090909,"d":"190.91"}},{"$f":"'Regulares Ampliado EI'!$E$9+('Regulares Ampliado EI'!$D$9*(1+'Regulares Ampliado EI'!$C$9))-((1+'Regulares Ampliado EI'!$C$9)*('Oculto EI'!CJ23))","v":0},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},{"v":45,"d":"45.00"},{"v":160.5,"d":"160.50"},2.000000000000001,{"v":90.00000000000004,"d":"90.00"},{"v":133.27499999999998,"d":"133.28"},{"$nulls":4},"Años",5,null,"Tasa de interés",{"$f":"ValorPyF!C9","v":0.1},"Tasa de interés",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"0.2"}},null,null,"Tasa de interés real anual",{"$f":"(DG20-DG22)/(1+DG22)","v":{"v":0.047619047619047616,"d":"4.8%"}},0.95,{"v":1.9,"d":"1.90 "},{"v":119.94999999999995,"d":"119.95"},{"v":1.9,"d":"1.90 "},{"v":118.95691609977325,"d":"118.96"},{"$nulls":7},0.95,{"v":190,"d":"190.00 "},{"v":10,"d":"10.00"},{"v":52.63157894736842,"d":"52.63"},{"v":190,"d":"190.00"},52.63157894736842,{"v":95,"d":"95.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":95,"d":"95.0"},{"v":95,"d":"95.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":95,"d":"95.0"},0.95,{"v":190,"d":"190.00 "},{"v":10,"d":"10.00"},{"v":52.63157894736842,"d":"52.63"},{"v":190,"d":"190.00"},52.63157894736842]
[{"v":1,"d":"1.00"},{"$f":"(($C$29+$C$30)*1.2)*A24","v":{"v":204,"d":"204.00"}},{"v":41.37529632855148,"d":"41.38"},{"v":30,"d":"30.00"},{"v":10.813962975130146,"d":"10.81"},{"v":30,"d":"30.00"},{"v":10.813962975130146,"d":"10.81"},{"v":170,"d":"170.00"},{"v":36.41784515192302,"d":"36.42"},{"v":170,"d":"170.00"},{"v":36.41784515192302,"d":"36.42"},{"v":100,"d":"100.00"},{"v":25.1188643150958,"d":"25.12"},{"v":100,"d":"100.00"},{"v":25.1188643150958,"d":"25.12"},{"v":100,"d":"100.00"},{"v":23.615904063526582,"d":"23.62"},{"$f":"$G$29","v":{"v":100,"d":"100.00"}},{"v":25.1188643150958,"d":"25.12"},{"v":170,"d":"170.00"},{"v":36.41784515192303,"d":"36.42"},{"v":100,"d":"100.00"},{"v":25.1188643150958,"d":"25.12"},{"$nulls":77},"Valor Presente",{"$f":"CX20/((1+(CX21/CX22))^(CX23*CX22))","v":{"v":718338.5130857534,"d":"718,338.51"}},{"$nulls":3},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"0.1"}},null,null,"Tasa de interés real por periodo",{"$f":"DG23/DG19","v":{"v":3.968253968253968E-3,"d":"0.40%"}},{"v":1,"d":"1.00"},{"v":2,"d":"2.00 "},{"v":120.99999999999994,"d":"121.00"},{"v":2,"d":"2.00 "},{"v":119.95464852607711,"d":"119.95"},{"$nulls":7},{"v":1,"d":"1.00"},{"v":200,"d":"200.00 "},0,{"v":49.99999999999999,"d":"50.00"},null,null,{"$f":"$DP$12*DT24","v":{"v":100,"d":"100.00 "}},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.00 "},{"v":100,"d":"100.0"},{"v":1,"d":"1.00"},{"v":200,"d":"200.00 "},0,{"v":49.99999999999999,"d":"50.00"},{"v":200.00000000000003,"d":"200.00"},49.99999999999999]
[{"$nulls":28},"x1","x2",{"$nulls":10},"x1","x2",{"$nulls":10},"x1","x2",{"$nulls":8},"m",{"$f":"'Regulares EI'!$B$7","v":{"v":0.1,"d":"0.10"}},"k",{"$nulls":3},{"$f":"1/10","v":0.1},{"$nulls":5},"r",{"$f":"'Regulares Ampliado EI'!C8","v":{"v":0.1,"d":"0.10"}},"k",{"$nulls":3},{"$f":"1/10","v":0.1},{"$nulls":6},"m",{"$f":"'Regulares Ampliado EI'!C9","v":{"v":0.1,"d":"0.10"}},"k",{"$nulls":3},{"$f":"1/10","v":0.1},{"$nulls":10},{"$f":"ValorPyF!C4","v":0},"Tasa de interés real",{"$f":"(DC23-DC24)/(1+DC24)","v":{"v":0.09523809523809523,"d":"0.1"}},"n",null,"n",null,1.05,{"v":2.1,"d":"2.10 "},{"v":122.04999999999994,"d":"122.05"},{"v":2.1,"d":"2.10 "},{"v":120.95238095238096,"d":"120.95"}]
[{"$nulls":7},"^",{"$nulls":10},{"$f":"G35^(1/2)","v":0},{"$nulls":9},{"$f":"'Cobb-Douglas EI'!C20","v":0.6},{"$f":"'Cobb-Douglas EI'!E20","v":0.4},{"$nulls":10},{"$f":"'Cobb-Douglas Ampliado EI'!D24","v":0.2},{"$f":"'Cobb-Douglas Ampliado EI'!F24","v":0.8},{"$nulls":10},{"$f":"'Cobb-Douglas Ampliado EI'!D24","v":0.2},{"$f":"'Cobb-Douglas Ampliado EI'!F24","v":0.8},{"$nulls":8},"p1",{"$f":"'Regulares EI'!C7","v":100},{"$f":"(BL28*BL29)-(BM30*BL28)-(BM28*BL29)+(BM28*BM30)","v":{"v":3327.5,"d":"3,327.50"}},"x1x2","bx1","ax2","ab",{"$nulls":5},"p1",{"$f":"'Regulares Ampliado EI'!D8","v":100},{"$f":"(BX28*BX29)-(BY30*BX28)-(BY28*BX29)+(BY28*BY30)","v":{"v":3327.5,"d":"3,327.50"}},"x1x2","bx1","ax2","ab",{"$nulls":6},"p1",{"$f":"'Regulares Ampliado EI'!D9","v":100},{"$f":"(CK28*CK29)-(CL30*CK28)-(CL28*CK29)+(CL28*CL30)","v":{"v":3327.5,"d":"3,327.50"}},"x1x2","bx1","ax2","ab",{"$nulls":9},"r",{"$f":"ValorPyF!C5","v":0},"r",{"$f":"ValorPyF!G24","v":{"v":3.968253968253968E-3,"d":"0.40%"}},"Años",{"$f":"((LN(DE28/DE27))/(LN(1+(DE31))))/DE29","v":{"v":-43.3545276543899,"d":"-43.4"}},"Años",{"$f":"(LN(DG28/DG27))/((LN(1+(DG34)))*DG29)","v":{"v":-90.84702697940527,"d":"-90.85"}},{"v":1.1,"d":"1.10"},{"v":2.2,"d":"2.20 "},{"v":123.09999999999994,"d":"123.10"},{"v":2.2,"d":"2.20 "},{"v":121.95011337868482,"d":"121.95"}]
[{"$nulls":28},{"$f":"(((1+'Cobb-Douglas EI'!B7)*'Cobb-Douglas EI'!C7)+'Cobb-Douglas EI'!D7)/(1+'Cobb-Douglas EI'!B7)*('Cobb-Douglas EI'!C20/('Cobb-Douglas EI'!C20+'Cobb-Douglas EI'!E20))","v":{"v":260,"d":"260.00"}},{"$f":"(((1+'Cobb-Douglas EI'!B7)*'Cobb-Douglas EI'!C7)+'Cobb-Douglas EI'!D7)*('Cobb-Douglas EI'!E20/('Cobb-Douglas EI'!C20+'Cobb-Douglas EI'!E20))","v":{"v":260,"d":"260.00"}},{"$nulls":10},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C8)*'Cobb-Douglas Ampliado EI'!D8)+'Cobb-Douglas Ampliado EI'!E8)/(1+'Cobb-Douglas Ampliado EI'!C8)*('Cobb-Douglas Ampliado EI'!D24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C8)*'Cobb-Douglas Ampliado EI'!D8)+'Cobb-Douglas Ampliado EI'!E8)*('Cobb-Douglas Ampliado EI'!F24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":1280,"d":"1,280.00"}},{"$nulls":10},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C9)*'Cobb-Douglas Ampliado EI'!D9)+'Cobb-Douglas Ampliado EI'!E9)/(1+'Cobb-Douglas Ampliado EI'!C9)*('Cobb-Douglas Ampliado EI'!D24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":266.6666666666667,"d":"266.67"}},{"$f":"(((1+'Cobb-Douglas Ampliado EI'!C9)*'Cobb-Douglas Ampliado EI'!D9)+'Cobb-Douglas Ampliado EI'!E9)*('Cobb-Douglas Ampliado EI'!F24/('Cobb-Douglas Ampliado EI'!D24+'Cobb-Douglas Ampliado EI'!F24))","v":{"v":1280,"d":"1,280.00"}},{"$nulls":8},"p2",{"$f":"'Regulares EI'!D7","v":100},"a",{"$nulls":9},"p2",{"$f":"'Regulares Ampliado EI'!E8","v":100},"a",{"$nulls":10},"p2",{"$f":"'Regulares Ampliado EI'!E9","v":100},"a",{"$nulls":10},"TASA NO ANUAL",null,null,"Tasa de interés",{"$f":"DA34+((1+DA34)*(((DA29/DA28)^(1/DA30))-1))","v":{"v":-1,"d":"-1.0"}},"Tasa de interés",{"$f":"DC31+((1+DC31)*(((DC29/DC28)^(1/DC30))-1))","v":{"v":-0.9999999999950486,"d":"-1.0"}},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}},null,"anualizada nominal","anualizada real","capitalizada nominal","capitalizada real"]
[null,"Utilidad",{"$f":"'Incertidumbre UE'!$C$5","v":0.7},null,"a",{"$f":"'Incertidumbre UE'!D5","v":0.7},{"$nulls":23},{"$f":"(AC27^(AC26))*(AD27^(AD26))","v":259.99999999999994},{"$nulls":11},{"$f":"(AO27^(AO26))*(AP27^(AP26))","v":935.3232330380323},{"$nulls":11},{"$f":"(BA27^(BA26))*(BB27^(BB26))","v":935.3232330380323},{"$nulls":8},"C1*",{"$f":"'Regulares EI'!E20+(-'Regulares EI'!F20+'Regulares EI'!D7+('Regulares EI'!C7*(1+'Regulares EI'!B7))-('Regulares EI'!E20*(1+'Regulares EI'!B7)))/(2*(1+'Regulares EI'!B7))","v":{"v":45,"d":"45.00"}},{"$f":"'Regulares EI'!E20","v":-10},{"$nulls":9},"C1*",{"$f":"'Regulares Ampliado EI'!F24+(-'Regulares Ampliado EI'!G24+'Regulares Ampliado EI'!E8+('Regulares Ampliado EI'!D8*(1+'Regulares Ampliado EI'!C8))-('Regulares Ampliado EI'!F24*(1+'Regulares Ampliado EI'!C8)))/(2*(1+'Regulares Ampliado EI'!C8))","v":{"v":45,"d":"45.00"}},{"$f":"'Regulares Ampliado EI'!F24","v":-10},{"$nulls":10},"C1*",{"$f":"'Regulares Ampliado EI'!F25+(-'Regulares Ampliado EI'!G25+'Regulares Ampliado EI'!E9+('Regulares Ampliado EI'!D9*(1+'Regulares Ampliado EI'!C9))-('Regulares Ampliado EI'!F25*(1+'Regulares Ampliado EI'!C9)))/(2*(1+'Regulares Ampliado EI'!C9))","v":{"v":45,"d":"45.00"}},{"$f":"'Regulares Ampliado EI'!F25","v":-10},{"$nulls":10},"Capital inicial",{"v":1000,"d":"1,000.00"},null,"Capital inicial",{"$f":"ValorPyF!C7","v":{"v":100,"d":"100.0"}},"Capital inicial",{"$f":"ValorPyF!G7","v":{"v":100,"d":"100.0"}},"Capital final",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}},null,{"$f":"ValorPyF!DI28","v":"Anualizado nominal"},{"$f":"ValorPyF!DJ28","v":"Anualizado real"}]
[null,"Ingreso",{"$f":"'Incertidumbre UE'!C6","v":{"v":100,"d":"100.0"}},null,"Ingreso",{"$f":"'Incertidumbre UE'!D6","v":{"v":100,"d":"100.0"}},{"$f":"(C32*((C29+C30)))+(C33*((C29+C31)))","v":{"v":100,"d":"100.0"}},{"$nulls":55},"C2*",{"$f":"'Regulares EI'!F20+((-'Regulares EI'!F20+'Regulares EI'!D7+('Regulares EI'!C7*(1+'Regulares EI'!B7))-('Regulares EI'!E20*(1+'Regulares EI'!B7)))/2)","v":{"v":160.5,"d":"160.50"}},"b",{"$nulls":9},"C2*",{"$f":"'Regulares Ampliado EI'!G24+((-'Regulares Ampliado EI'!G24+'Regulares Ampliado EI'!E8+('Regulares Ampliado EI'!D8*(1+'Regulares Ampliado EI'!C8))-('Regulares Ampliado EI'!F24*(1+'Regulares Ampliado EI'!C8)))/2)","v":{"v":160.5,"d":"160.50"}},"b",{"$nulls":10},"C2*",{"$f":"'Regulares Ampliado EI'!G25+((-'Regulares Ampliado EI'!G25+'Regulares Ampliado EI'!E9+('Regulares Ampliado EI'!D9*(1+'Regulares Ampliado EI'!C9))-('Regulares Ampliado EI'!F25*(1+'Regulares Ampliado EI'!C9)))/2)","v":{"v":160.5,"d":"160.50"}},"b",{"$nulls":10},"Tasa de Interés por Periodo",{"v":0.02,"d":"2%"},null,"Capital final",{"$f":"ValorPyF!C8","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G8","v":{"v":2,"d":"2.0"}},"Periodos de capitalización",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Periodos de capitalización",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}},"años",{"$f":"ValorPyF!DI29","v":2},{"$f":"ValorPyF!DJ29","v":2}]
[null,"Ganancia",{"$f":"'Incertidumbre UE'!C7","v":{"v":70,"d":"70.0"}},null,"Ganancia",{"$f":"'Incertidumbre UE'!D7","v":{"v":70,"d":"70.0"}},{"$nulls":56},"lamda",null,{"$f":"'Regulares EI'!F20","v":100},{"$nulls":9},"lamda",null,{"$f":"'Regulares Ampliado EI'!G24","v":100},{"$nulls":10},"lamda",null,{"$f":"'Regulares Ampliado EI'!G25","v":100},{"$nulls":10},"Capitalizaciones al año",12,null,"Años",{"$f":"ValorPyF!C9","v":0.1},"Años",{"$f":"ValorPyF!G9","v":{"v":0.15,"d":"0.2"}},"Tasa de interés anualizada",{"$f":"ValorPyF!C20","v":{"v":0.1,"d":"10.0%"}},"Tasa de interés anualizada",{"$f":"ValorPyF!G20","v":{"v":0.1,"d":"10.0%"}},"capital inicial",{"$f":"ValorPyF!DI30","v":100},{"$f":"ValorPyF!DJ30","v":100}]
[null,"Pérdida",{"$f":"'Incertidumbre UE'!C8","v":{"v":-70,"d":"-70.0"}},null,"Pérdida",{"$f":"'Incertidumbre UE'!D8","v":{"v":-70,"d":"-70.0"}},{"$nulls":94},"Años",2,{"$nulls":3},"Tasa de inflación",{"$f":"ValorPyF!G10","v":{"v":0.05,"d":"0.1"}},"Tasa de interés por periodo",{"$f":"DE30/DE29","v":{"v":0.008333333333333333,"d":"0.8%"}},"Tasa de interés por periodo",{"$f":"DG30/DG29","v":{"v":0.008333333333333333,"d":"0.8%"}},"capital final",{"$f":"ValorPyF!DI31","v":121.00000000000001},{"$f":"ValorPyF!DJ31","v":119.95464852607711}]
[null,"p Ganancia",{"$f":"'Incertidumbre UE'!C9","v":0.5},null,"p Ganancia",{"$f":"'Incertidumbre UE'!D9","v":0.5},{"$nulls":94},"Valor Futuro",{"$f":"CX28*((1+(CX29))^(CX31*CX30))","v":{"v":1608.4372494752251,"d":"1,608.44"}},{"$nulls":3},"Tasa de interés real",{"$f":"(DC27-DC31)/(1+DC31)","v":{"v":-0.9999999999952844,"d":"-1.0"}},null,null,"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}},null,{"$f":"ValorPyF!DI32","v":1.0500000000000007},{"$f":"ValorPyF!DJ32","v":0.9977324263038554}]
[null,"p  Pérdida",{"$f":"1-C32","v":{"v":0.5,"d":"0.50"}},null,"p  Pérdida",{"$f":"1-F32","v":{"v":0.5,"d":"0.50"}},{"$nulls":103},"Tasa de interés real anual",{"$f":"(DG30-DG32)/(1+DG32)","v":{"v":0.047619047619047616,"d":"4.8%"}},null,"Anualizada nominal","Anualizada real","Capitalizada nominal","Capitalizada real"]
[null,null,{"$f":"C36*C32+C37*C33","v":100},null,null,{"$f":"F36*F32+F37*F33","v":100},{"$nulls":94},"Capital final",{"v":1500000,"d":"1,500,000.00"},null,"Inflación",{"v":0,"d":"0.00"},"Inflación",{"$f":"ValorPyF!G11","v":{"v":0.09523809523809523,"d":"0.10"}},null,null,"Tasa de interés real por periodo",{"$f":"DG33/DG29","v":{"v":3.968253968253968E-3,"d":"0.40%"}}]
[null,"Utilidad ingreso",{"$f":"C29^C28","v":{"v":25.1188643150958,"d":"25.12"}},null,"U Ingreso",{"$f":"F29^F28","v":{"v":25.1188643150958,"d":"25.12"}},{"$nulls":94},"Tasa de Interés por Periodo",{"v":0.05,"d":"5%"},{"$nulls":5},"r",null,"r"]
[null,"Ganancia",{"$f":"C29+C30","v":{"v":170,"d":"170.00"}},null,null,{"$f":"F29+F30","v":{"v":170,"d":"170.00"}},{"$nulls":56},59221065,{"$nulls":37},"Capitalizaciones al año",4,{"$nulls":5},"Tasa de interés anualizada",{"$f":"DE46+((1+DE42)*(((((DE38/DE37)^(1/(DE39*DE40)))-1))*DE40))","v":{"v":-0.09726190225756519,"d":"-9.7%"}},"Tasa de interés anualizada",{"$f":"DG42+((1+DG42)*(((((DG38/DG37)^(1/(DG39*DG40)))-1))*DG40))","v":{"v":-0.052124997370443446,"d":"-5.2%"}}]
[null,"Pérdida",{"$f":"C29+C31","v":{"v":30,"d":"30.00"}},null,null,{"$f":"F29+F31","v":{"v":30,"d":"30.00"}},{"$nulls":94},"Años",5,{"$nulls":5},"Capital inicial",{"$f":"ValorPyF!C17","v":{"v":150,"d":"150.0"}},"Capital inicial",{"$f":"ValorPyF!G17","v":{"v":150,"d":"150.0"}}]
[null,"U Ganancia",{"$f":"(C29+C30)^$C$28","v":{"v":36.41784515192302,"d":"36.42"}},null,"U Ganancia",{"$f":"(F29+F30)^$F$28","v":{"v":36.41784515192302,"d":"36.42"}},{"$nulls":94},"Valor Presente",{"$f":"CX34/((1+(CX35))^(CX37*CX36))","v":{"v":565334.2243095009,"d":"565,334.22"}},{"$nulls":5},"Capital final",{"$f":"ValorPyF!C18","v":{"v":2,"d":"2.0"}},"Capital final",{"$f":"ValorPyF!G18","v":{"v":2,"d":"2.0"}}]
[null,"U Pérdida",{"$f":"(C29+C31)^$C$28","v":{"v":10.813962975130146,"d":"10.81"}},null,null,{"$f":"(F29+F31)^$F$28","v":{"v":10.813962975130146,"d":"10.81"}},{"$nulls":8},"ingreso","utilidad",{"$nulls":91},"Años",{"$f":"ValorPyF!C19","v":{"v":12,"d":"12.0"}},"Años",{"$f":"ValorPyF!G19","v":{"v":12,"d":"12.0"}}]
[null,"UE Ganancia",{"$f":"$C$32*(($C$29+$C$30)^$C$28)","v":{"v":18.20892257596151,"d":"18.21"}},null,null,{"$f":"$F$32*(($F$29+$F$30)^$F$28)","v":{"v":18.20892257596151,"d":"18.21"}},{"$nulls":8},{"$f":"C29","v":{"v":100,"d":"100.0"}},{"$f":"O40^$C$28","v":{"v":25.1188643150958,"d":"25.1"}},"Utilidad de la riquza segura",{"$nulls":90},"Periodos de capitalización",{"$f":"ValorPyF!C20","v":0.1},"Periodos de capitalización",{"$f":"ValorPyF!G20","v":0.1}]
[null,"UE Pérdida",{"$f":"$C$33*(($C$29+$C$31)^$C$28)","v":{"v":5.406981487565073,"d":"5.41"}},null,"U Pérdida",{"$f":"$F$33*(($F$29+$F$31)^$F$28)","v":{"v":5.406981487565073,"d":"5.41"}},{"$nulls":8},{"$f":"(C29+C31)","v":{"v":30,"d":"30.0"}},{"$f":"O41^$C$28","v":{"v":10.813962975130146,"d":"10.8"}},"utilidad perdida",{"$nulls":90},"Tasa de interés por periodo",{"$f":"DE36/DE40","v":{"v":-0.9726190225756518,"d":"-97.3%"}},"Tasa de interés por periodo",{"$f":"DG36/DG40","v":{"v":-0.5212499737044344,"d":"-52.1%"}}]
[null,"G+P",{"$f":"C40+C41","v":{"v":23.615904063526582,"d":"23.62"}},null,"U Esperada",{"$f":"F40+F41","v":{"v":23.615904063526582,"d":"23.62"}},{"$nulls":8},{"$f":"C29+C30","v":{"v":170,"d":"170.0"}},{"$f":"O42^$C$28","v":{"v":36.41784515192302,"d":"36.4"}},"utilidad ganar",{"$nulls":92},"Tasa de inflación anual",{"$f":"ValorPyF!G22","v":{"v":0.05,"d":"5.0%"}}]
[null,"Pendiente",{"$f":"(C42-C39)/(C29-C37)","v":{"v":0.18288487269137765,"d":"0.18"}},null,null,{"$f":"(F42-F39)/(F29-F37)","v":{"v":0.18288487269137765,"d":"0.18"}},{"$nulls":8},{"$f":"(O41*C33)+(O42*C32)","v":100},{"$f":"O43^$C$28","v":{"v":25.1188643150958,"d":"25.1"}},"Utilidad del valor esperado",{"$nulls":92},"Tasa de interés real anual",{"$f":"(DG36-DG42)/(1+DG42)","v":{"v":-0.09726190225756519,"d":"-9.7%"}}]
[null,"Toma de decisión",{"$f":"IF(C42>C35,\"Acepta el juego\",\"Rechaza el juego\")","v":"Rechaza el juego"},null,"Toma de decisión",{"$f":"IF(F42>F35,\"Acepta el juego\",\"Rechaza el juego\")","v":"Rechaza el juego"},{"$nulls":9},{"$f":"(P41*C33)+(P42*C32)","v":{"v":23.615904063526582,"d":"23.6"}},"Utilidad esperada del juego",{"$nulls":92},"Tasa de interés real por periodo",{"$f":"DG43/DG40","v":{"v":-0.9726190225756518,"d":"-97.26%"}}]
[null,"Desviación media",{"$f":"C46^(1/2)","v":70},null,"Desviación media",{"$f":"F46^(1/2)","v":70}]
[null,"Varianza",{"$f":"(((C37-C34)^2)*C33)+(((C36-C34)^2)*C32)","v":4900},null,"Varianza",{"$f":"(((F37-F34)^2)*F33)+(((F36-F34)^2)*F32)","v":4900},{"$nulls":101},"Inflación",{"v":0,"d":"0.00"},"Inflación",{"v":0,"d":"0.00"}]
[]
[{"$nulls":107},"Rr Cap Inicial",{"$f":"(DE20-$DE$46)/(1+$DE$46)","v":0.1}]
[{"$nulls":107},"Rr Cap Final",{"$f":"(DE10-$DE$46)/(1+$DE$46)","v":0.1}]
[{"$nulls":107},"Rr n",{"$f":"(DE30-$DE$46)/(1+$DE$46)","v":0.1}]
[]
[]
[]
[]
[]
[{"$nulls":103},"Draw",null,"Draw",null,"Draw",null,"Draw"]
[{"$nulls":103},"CI",{"$f":"DA6","v":{"v":121.00000000000001,"d":"121.0"}},"CI",{"$f":"DC7","v":{"v":100,"d":"100.0"}},"CI",{"$f":"DE7","v":{"v":150,"d":"150.0"}},"CI",{"$f":"DG7","v":{"v":150,"d":"150.0"}}]
[{"$nulls":103},"CF",{"$f":"DA7","v":{"v":100,"d":"100.0"}},"CF",{"$f":"DC6","v":{"v":119.95464852607711,"d":"120.0"}},"CF",{"$f":"DE16","v":{"v":122.91143145711933,"d":"122.9"}},"CF",{"$f":"DG17","v":{"v":150,"d":"150.0"}}]
[{"$nulls":103},"n",{"$f":"DA8","v":{"v":2,"d":"2.0"}},"n",{"$f":"DC8","v":{"v":2,"d":"2.0"}},"n",{"$f":"DE8","v":{"v":2,"d":"2.0"}},"n",{"$f":"DG8","v":{"v":2,"d":"2.0"}}]
[{"$nulls":103},"r",{"$f":"DA9","v":0.1},"r",{"$f":"DC9","v":{"v":0.15,"d":"0.2"}},"r",{"$f":"DE10","v":0.1},"r",{"$f":"DG10","v":0.1}]
[{"$nulls":103},"m",{"$f":"DA10","v":{"v":2,"d":"2.0"}},"m",{"$f":"DC10","v":{"v":0.05,"d":"0.1"}},"m",{"$f":"DE25","v":{"v":0,"d":"0.0"}},"m",{"$f":"DG9","v":{"v":12,"d":"12.0"}}]
[{"$nulls":107},"inflaciòn",{"$f":"#REF!","v":{"$error":"#REF!"}},"inflaciòn",{"$f":"DI31","v":{"v":121.00000000000001,"d":"121.0"}}]
[]
[]
[{"$nulls":103},"Valor presente",null,"Capitalizado",null,"Valor presente"]
[{"$nulls":103},"Anualizado",{"$nulls":3},"Anualizado",null,"Capitalizado"]
[{"$nulls":103},"CF",null,"CF",null,"CF"]
[{"$nulls":103},"Capital final",{"$f":"DA69*((1+(DA71-DA96)/(1+DA96))^DA70)","v":{"v":0,"d":"0.0"}},"Capital final",{"$f":"DC69*((1+(((DC71-DA96)/(1+DA96))/DC72))^(DC70*DC72))","v":{"$error":"#DIV/0!"}},"CI",{"$f":"ValorPyF!G121","v":{"v":0,"d":"0.0"}},"CF"]
[{"$nulls":103},"Capital inicial",{"$f":"ValorPyF!C56","v":{"v":0,"d":"0.0"}},"Capital inicial",{"$f":"ValorPyF!G56","v":{"v":0,"d":"0.0"}},"CF",{"$f":"DE68*((1+(DE71-DE96)/(1+DE96))^DE70)","v":{"v":0,"d":"0.0"}},"CI",{"$f":"ValorPyF!I122","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Años",{"$f":"ValorPyF!C57","v":{"v":0,"d":"0.0"}},"Años",{"$f":"ValorPyF!G57","v":{"v":0,"d":"0.0"}},"n",{"$f":"ValorPyF!G123","v":{"v":0,"d":"0.0"}},"CF",{"$f":"DG69*((1+(((DG72-DI78)/(1+DI78))/DG73))^(DG71*DG73))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":103},"Tasa de interés",{"$f":"ValorPyF!C58","v":{"v":0,"d":"0.0"}},"Tasa de interés",{"$f":"ValorPyF!G58","v":{"v":0,"d":"0.0"}},"r",{"$f":"ValorPyF!G124","v":{"v":0,"d":"0.0"}},"n",{"$f":"ValorPyF!I124","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de inflación",{"$f":"ValorPyF!G59","v":{"v":0,"d":"0.0"}},null,null,"r",{"$f":"ValorPyF!I125","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de interés real",{"$nulls":3},"m",{"$f":"ValorPyF!I126","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"CI",null,"CI",null,"CI"]
[{"$nulls":103},"Capital inicial",{"$f":"DA76/((1+((DA78-DA96)/(1+DA96)))^DA77)","v":{"v":0,"d":"0.0"}},"Capital inicial",{"$f":"DC76/((1+(((DC78-DA96)/(1+DA96))/DC79))^(DC77*DC79))","v":{"$error":"#DIV/0!"}},"CI",{"$f":"DE76/((1+((DE78-DE96)/(1+DE96)))^DE77)","v":{"v":0,"d":"0.0"}},"CI"]
[{"$nulls":103},"Capital final",{"$f":"ValorPyF!C56","v":{"v":0,"d":"0.0"}},"Capital final",{"$f":"ValorPyF!A56","v":{"v":0,"d":"0.0"}},"CF",{"$f":"ValorPyF!G117","v":{"v":0,"d":"0.0"}},"CI",{"$f":"DG77/((1+(((DG79-DI78)/(1+DI78))/DG80))^(DG78*DG80))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":103},"Años",{"$f":"ValorPyF!C57","v":{"v":0,"d":"0.0"}},"Años",{"$f":"ValorPyF!A57","v":{"v":0,"d":"0.0"}},"n",{"$f":"ValorPyF!G118","v":{"v":0,"d":"0.0"}},"CF",{"$f":"ValorPyF!I117","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Tasa de interés",{"$f":"ValorPyF!C58","v":{"v":0,"d":"0.0"}},"Tasa de interés",{"$f":"ValorPyF!A58","v":{"v":0,"d":"0.0"}},"r",{"$f":"ValorPyF!G58","v":{"v":0,"d":"0.0"}},"n",{"$f":"ValorPyF!I118","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de inflación",{"$f":"ValorPyF!A59","v":{"v":0,"d":"0.0"}},null,null,"r",{"$f":"ValorPyF!I119","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de interés real",{"$nulls":3},"m",{"$f":"ValorPyF!I120","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},{"$f":"ValorPyF!B54","v":0},null,"n",null,"n"]
[{"$nulls":103},"Años",{"$f":"(LN(DA84/DA83))/(LN(1+(DA85-DA96)/(1+DA96)))","v":{"$error":"#DIV/0!"}},"Años",{"$f":"(LN(DC84/DC83))/((LN(1+(((DC85-DA96)/(1+DA96))/DC86)))*DC86)","v":{"$error":"#DIV/0!"}},"CI",{"$f":"ValorPyF!G126","v":{"v":0,"d":"0.0"}},"n"]
[{"$nulls":103},"Capital inicial",{"$f":"ValorPyF!C56","v":{"v":0,"d":"0.0"}},"Capital inicial",{"$f":"ValorPyF!G56","v":{"v":0,"d":"0.0"}},"CF",{"$f":"ValorPyF!G127","v":{"v":0,"d":"0.0"}},"CI",{"$f":"ValorPyF!I128","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Capital final",{"$f":"ValorPyF!C57","v":{"v":0,"d":"0.0"}},"Capital final",{"$f":"ValorPyF!G57","v":{"v":0,"d":"0.0"}},"n",{"$f":"(LN(DE83/DE82))/(LN(1+(DE85-DE96)/(1+DE96)))","v":{"$error":"#DIV/0!"}},"CF",{"$f":"ValorPyF!I129","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Tasa de interés",{"$f":"ValorPyF!C58","v":{"v":0,"d":"0.0"}},"Tasa de interés",{"$f":"ValorPyF!G58","v":{"v":0,"d":"0.0"}},"r",{"$f":"ValorPyF!G129","v":{"v":0,"d":"0.0"}},"n",{"$f":"(LN(DG84/DG83))/((LN(1+(((DG86-DI78)/(1+DI78))/DG87)))*DG87)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":105},"Tasa de inflación",{"$f":"ValorPyF!G59","v":{"v":0,"d":"0.0"}},null,null,"r",{"$f":"ValorPyF!I131","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de interés real",{"$nulls":3},"m",{"$f":"ValorPyF!I132","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"r",null,"r",null,"r"]
[{"$nulls":103},"Tasa de interés",{"$f":"DA96+((1+DA96)*(((DA91/DA90)^(1/DA92))-1))","v":{"$error":"#DIV/0!"}},"Tasa de interés",{"$f":"DA96+(((DC91/DC90)^(1/(DC92*DC93))-1)*((1+DA96)*(DC93)))","v":{"$error":"#DIV/0!"}},"CI",{"$f":"ValorPyF!G131","v":{"v":0,"d":"0.0"}},"r"]
[{"$nulls":103},"Capital inicial",{"$f":"ValorPyF!C56","v":{"v":0,"d":"0.0"}},"Capital inicial",{"$f":"ValorPyF!G56","v":{"v":0,"d":"0.0"}},"CF",{"$f":"ValorPyF!G132","v":{"v":0,"d":"0.0"}},"CI",{"$f":"ValorPyF!I134","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Capital final",{"$f":"ValorPyF!C57","v":{"v":0,"d":"0.0"}},"Capital final",{"$f":"ValorPyF!G57","v":{"v":0,"d":"0.0"}},"n",{"$f":"ValorPyF!G133","v":{"v":0,"d":"0.0"}},"CF",{"$f":"ValorPyF!I135","v":{"v":0,"d":"0.0"}}]
[{"$nulls":103},"Años",{"$f":"ValorPyF!C58","v":{"v":0,"d":"0.0"}},"Años",{"$f":"ValorPyF!G58","v":{"v":0,"d":"0.0"}},"r",{"$f":"DE96+((1+DE96)*(((DE90/DE89)^(1/DE91))-1))","v":{"$error":"#DIV/0!"}},"n",{"$f":"ValorPyF!I136","v":{"v":0,"d":"0.0"}}]
[{"$nulls":105},"Tasa de inflación",{"$f":"ValorPyF!G59","v":{"v":0,"d":"0.0"}},null,null,"r",{"$f":"DI78+(((DG91/DG90)^(1/(DG92*DG94))-1)*((1+DI78)*(DG94)))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":105},"Tasa de interés real",{"$nulls":3},"m",{"$f":"ValorPyF!I138","v":{"v":0,"d":"0.0"}}]
[]
[{"$nulls":103},"Inflación",{"v":0,"d":"0.00"},"Inflación",{"$f":"ValorPyF!G60","v":{"v":0,"d":"0.00"}},"Inflación",{"$f":"ValorPyF!G141","v":{"v":0,"d":"0.00"}}]