{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cálculo","Fórmulas","D"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cálculo","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[40,4,41,5],[38,4,39,5],[37,5,37,13],[2,5,5,8],[4,9,5,13],[2,9,3,13],[8,4,9,4],[8,6,9,6],[8,11,9,11],[11,11,12,11],[22,5,23,6],[22,8,23,8],[22,10,23,11],[22,13,23,13],[6,5,6,13],[17,5,17,13],[11,14,12,14],[19,5,20,6],[19,8,20,8],[19,10,20,11],[19,13,20,13],[14,13,15,13],[11,5,11,6],[14,10,15,11],[8,8,9,8],[12,5,12,6],[14,5,15,6],[14,8,15,8],[11,13,12,13],[8,13,9,13],[38,2,62,3],[29,2,29,15],[50,4,51,5],[50,6,51,9],[40,6,41,9],[30,3,36,14],[44,4,45,5],[44,6,45,9],[48,4,49,5],[38,6,39,9],[42,6,43,9],[46,6,47,9],[48,6,49,9],[42,4,43,5],[52,4,62,14],[46,4,47,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Al Vencimiento",null,null,null,null,360]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"D!C14","v":0},null,null,null,null,{"$f":"I20*4%","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"I20-N20","v":0},null,null,null,null,{"$f":"I9+I23","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Fecha Valor",null,{"$f":"TODAY()","v":"2024-07-30"}]
[]
[null,null,null,null,"Fecha de Vencmiento",null,{"$f":"G39+N9","v":"2024-07-30"}]
[]
[null,null,null,null,"Plazo",null,{"$f":"N9","v":0}]
[]
[null,null,null,null,"Tasa",null,{"$f":"N12","v":0}]
[]
[null,null,null,null,{"$f":"IF(D!A1=1, \"CAPITAL (V.A.)\", \"MONTO (V.F.)\")","v":"MONTO (V.F.)"},null,{"$f":"I9","v":0}]
[]
[null,null,null,null,"INTERES",null,{"$f":"D!C20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Este es el retorno de su inversión"]
[null,null,null,null,{"$f":"IF(D!A1=2, \"CAPITAL (V.A.)\", \"MONTO (V.F.)\")","v":"MONTO (V.F.)"},null,{"$f":"G47+G49","v":0}]

{"sheet":"Fórmulas","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"D","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,3,15,5],[16,3,16,5],[8,3,8,5],[13,3,13,5]]}
[0,"Plazo Cal.",{"$f":"Cálculo!G41-Cálculo!G39","v":0}]
[0,"Plazo Com.",{"$f":"C1","v":0}]
[1,"Plazo Def.",{"$f":"IF(A4=1,C1,C2)","v":0},"Tipo Año",{"$f":"IF(A2=1,365,360)","v":360}]
[8,"i",{"$f":"Cálculo!G45","v":0}]
[null,"n",{"$f":"ROUND(C3/E3, 9)","v":0}]
[null,"Importe",{"$f":"Cálculo!G47","v":0}]
[null,"( 1 + i ) n  ",{"$f":"POWER(1+C4, C5)","v":1}]
[]
[null,"Interés Nominal Vencimiento",{"$f":"ROUND(C6*C4*C5, 2)","v":0}]
[]
[null,"Interés Nominal Descuento",{"$f":"(1 - 1/(1+(C4*C5)))*C6","v":0}]
[]
[]
[null,"Interés Efectivo Vencimiento",{"$f":"ROUND( (POWER(1+C4, C5) - 1) * C6, 2)","v":0}]
[]
[null,"Interés Efectivo Descuento",{"$f":"ROUND( ((C7-1)*C6) / C7, 2)","v":0}]
[]
[null,"IE ",{"$f":"IF(A1=1,C14,C16)","v":0}]
[null,"IN ",{"$f":"IF(A1=1,C9,C11)","v":0}]
[null,"I. Def",{"$f":"IF(A3=1, C18, C19)","v":0}]
[null,"Capital",{"$f":"IF(A1=1, C6,C6-C20)","v":0}]
[null,"Monto",{"$f":"IF(A1=1, C6+C20, C21)","v":0}]
[null,"muestro",{"$f":"IF(A1=1, C22,C21)","v":0}]