{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Valoración Bono"],"not_rendered":{"charts":0,"images":1,"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":"Valoración Bono","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,7,15,8],[14,7,14,8],[13,7,13,8],[16,7,16,8],[17,7,17,8],[0,1,0,6],[4,6,4,7],[10,1,10,6],[10,7,10,8],[12,7,12,8],[3,3,3,4],[2,1,2,4],[2,5,2,8]]}
[null,"Valoración de un bono de renta fija",null,null,null,null,null,null,null,"www.economipedia.com"]
[]
[null,"ESPECIFICACIONES DEL BONO",null,null,null,"ANÁLISIS DE SENSIBILIDAD DE UN BONO"]
[null,"Fecha valor",{"$f":"+TODAY()","v":"2015-06-25"}]
[null,"Fecha vencimiento",{"$f":"+EDATE(C4,120)","v":"2025-06-25"},{"$f":"+(C5-C4)/365","v":10.008219178082191},"años",null,"Valoración"]
[null,"Nominal",100000,null,null,null,"Duración",{"$f":"SUM(G16:G25)","v":8.3112210931290225}]
[null,"Cupón anual",0.05,null,null,null,"Duración modificada",{"$f":"(H6/(1+H9))/100","v":8.101613247000948E-2}]
[null,"Precio ",1.21,null,null,null,"RISK-Sensibilidad",{"$f":"(+H7*F26)","v":9.8029683470123752E-2}]
[null,null,null,null,null,null,"TIR",2.5872358965748774E-2]
[]
[null,"Cálculos a realizar",null,null,null,null,null,"Teoría"]
[]
[null,null,null,null,null,null,null,"¿Qué significa renta fija?"]
[null,"Fechas","Dias","Años","Flujos","VP Flujos","VP (F) X Años","¿Qué es un bono?"]
[null,{"$f":"+C4","v":"2015-06-25"},null,null,null,null,null,"Duración de un bono"]
[null,{"$f":"+EDATE(B15,12)","v":"2016-06-25"},{"$f":"B16-$B$15","v":366},{"$f":"C16/365","v":1.0027397260273974},{"$f":"+C7","v":0.05},{"$f":"E16/(1+$H$9)^D16","v":4.8735596196575859E-2},{"$f":"(F16*D16)/$F$26","v":4.0387633908928175E-2},"Diferencia entre bono y acción"]
[null,{"$f":"+EDATE(B16,12)","v":"2017-06-25"},731,{"$f":"C17/365","v":2.0027397260273974},{"$f":"+E16","v":0.05},4.7506491202969445E-2,{"$f":"(F17*D17)/$F$26","v":7.8630560991674411E-2},"Bono basura"]
[null,"2018-06-25",1096,3.0027397260273974,0.05,4.6308384067257596E-2,0.11491883720593785,"Tipos de deuda"]
[null,"2019-06-25",{"$f":"B19-$B$15","v":1461},4.0027397260273974,0.05,4.5140493027752693E-2,0.1493267305149672]
[null,"2020-06-25",1827,5.0054794520547947,0.05,4.3998976806298058E-2,0.18201289893211486]
[null,"2021-06-25",2192,6.0054794520547947,0.05,4.2889328698412742E-2,0.21286822599580885]
[null,"2022-06-25",2557,7.0054794520547947,0.05,4.1807665762290711E-2,{"$f":"(F22*D22)/$F$26","v":0.24205145115694121}]
[null,"2023-06-25",2922,8.0054794520547947,0.05,4.0753282215771791E-2,0.26962728950671933]
[null,"2024-06-25",3288,9.0082191780821912,0.05,3.9722710115059005E-2,0.295727506953891]
[null,"2025-06-25",3653,10.008219178082191,{"$f":"+E16+100%","v":1.05},0.81313908609179131,6.7256699579620394]
[null,null,null,null,null,{"$f":"SUM(F16:F25)","v":1.2100020141841792},{"$f":"SUM(G16:G25)","v":8.3112210931290225}]