{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introducción","TASA-PRECIO","PRECIO-TASA","Datos DC24","Datos DC24 (2)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":13,"comments":0,"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":"Introducción","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,5,5],[23,0,24,5]]}
["CALCULADORA DC24"]
[]
["Esta calculadora contiene dos pestañas que pueden ser utilizadas como referencia para convertir la Tasa Yield observada en el bono DC24 a Precio y viceversa."]
[]
[]
[]
["Pestaña TASA-PRECIO,"]
["     Introducir los siguientes insumos:"]
["           -   Tasa de fondeo para el plazo del futuro buscado"]
["           -   Tasa Yield de mercado"]
["     Resultados arrojados:"]
["           -   Precio futuro para el vencimiento deseado"]
["           -   Tasa Futura implícita"]
[]
[]
["Pestaña PRECIO-TASA, "]
["     Introducir los siguientes insumos:"]
["           -   Tasa de fondeo para el plazo del futuro buscado"]
["           -   Precio futuro para el vencimiento buscado"]
["     Resultados arrojados:"]
["           -   Tasa Yield de mercado para el vencimiento deseado"]
["           -   Tasa Futura implícita"]
[]
["Por default en ambas pestañas aparece la fecha de consulta al SPOT, en caso de un día inhabil se tendrá que modificar para que la fecha de consulta sea la correcta."]

{"sheet":"TASA-PRECIO","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,3,2,4]]}
["Fecha de Consulta",{"$f":"diafondeoDC24(TODAY())","v":"2014-03-03"}]
["Fondeo",3.6,null,null,null,null,null,3.6]
["Tasa Yield",0.1,null,"DC 24"]
[null,null,null,"Precio","Tasa Futura Implícita"]
[null,null,"MR14",{"$f":"'Datos DC24'!C26","v":102.30000000000001},{"$f":"'Datos DC24'!H12","v":0.10077242375476923},null,null,0.1]
[null,null,"JN14",{"$f":"'Datos DC24'!C68","v":98.2},{"$f":"'Datos DC24'!H54","v":0.1033062994099197}]
[null,null,"SP14",{"$f":"'Datos DC24'!C110","v":99.100000000000009},{"$f":"'Datos DC24'!H96","v":0.10602693962316702}]
[null,null,"DC14",{"$f":"'Datos DC24'!C152","v":94.9},{"$f":"'Datos DC24'!H138","v":0.10905304403903958}]

{"sheet":"PRECIO-TASA","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
["Fecha de Consulta",{"$f":"diafondeoDC24(TODAY())","v":"2014-03-03"}]
["Fondeo",3.6,null,null,null,null,null,3.6]
[null,null,"DC 24"]
[null,"Precio","Tasa Yield","Tasa Futura Implícita"]
["MR14",100,{"$f":"'Datos DC24 (2)'!C12","v":0.10357288916070168},{"$f":"'Datos DC24 (2)'!H12","v":0.10437736486862781},null,null,null,100]
["JN14",100,{"$f":"'Datos DC24 (2)'!C54","v":9.7287987801851508E-2},{"$f":"'Datos DC24 (2)'!H54","v":0.10046316633038636},null,null,null,100]
["SP14",100,{"$f":"'Datos DC24 (2)'!C96","v":9.8621324346863867E-2},{"$f":"'Datos DC24 (2)'!H96","v":0.10454386626686013},null,null,null,100]
["DC14",100,{"$f":"'Datos DC24 (2)'!C138","v":9.2699849046373697E-2},{"$f":"'Datos DC24 (2)'!H138","v":0.10056466913804159},null,null,null,100]

{"sheet":"Datos DC24","index":3,"n_rows":167,"n_cols":8,"rows_kept":167,"cut":false,"hidden":false,"merged":[[0,7,0,8],[2,6,2,7],[44,6,44,7],[86,6,86,7],[128,6,128,7],[0,2,0,3],[44,1,44,2],[2,1,2,2],[86,1,86,2],[128,1,128,2]]}
[null,"FUTURO M10",null,null,null,null,"FUTURO M10"]
["MARZO",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"'TASA-PRECIO'!B2","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"C4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"'TASA-PRECIO'!B1","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H7","v":"2014-03-31"}]
[null,"Futuro Analizado","2014-03-31",null,null,null,"Futuro Analizado",{"$f":"C7","v":"2014-03-31"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C7-C6","v":28},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H7-H6","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B3","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G3","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C9-C6","v":3930},null,null,null,"Dias por Vencer",{"$f":"H9-H6","v":3902}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C11","v":0.1}]
[null,"Rendimiento a Vencimiento",{"$f":"'TASA-PRECIO'!B3","v":0.1},null,null,null,"Rendimiento a Vencimiento",0.10077242375476923]
[null,"Dias Trans. Cupón Vigente",{"$f":"C6-C17","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H6-H17","v":102}]
[null,"Precio Limpio",{"$f":"100*((((C11*182/360*(1+(1/(C12*182/360))))+(((1+(C12*182/360))^(1-(INT(C10/182)+1)))*(1-((C11*182/360)/(C12*182/360)))))/((1+(C12*182/360))^((((C10/182)-INT(C10/182))*182)/182)))-((C11*182/360)*(182-((((C10/182)-INT(C10/182))*182)))/182))","v":99.969968410314848},null,null,null,"Precio Limpio",{"$f":"100*((((H11*182/360*(1+(1/(H12*182/360))))+(((1+(H12*182/360))^(1-(INT(H10/182)+1)))*(1-((H11*182/360)/(H12*182/360)))))/((1+(H12*182/360))^((((H10/182)-INT(H10/182))*182)/182)))-((H11*182/360)*(182-((((H10/182)-INT(H10/182))*182)))/182))","v":99.466667503037357}]
[null,"Intereses Corridos",{"$f":"100*((C11)*(C13/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H11)*(H13/360))","v":2.8333333333333335}]
[null,"Precio Sucio",{"$f":"C14+C15","v":102.02552396587041},null,null,null,"Precio Sucio",{"$f":"H14+H15","v":102.30000083637069}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono",{"$f":"C17","v":"2013-12-19"}]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2013-12-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C18","v":"2013-12-19"}]
[null,"Siguiente Cupón del bono","2011-06-23",null,null,null,"Siguiente Cupón del bono","2011-06-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C18-C17)/182)","v":0},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H18-H17)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C20>0,IF(C20>1,IF(C20>2,IF(C20>3,IF(C20>4,IF(C20>5,IF(C20>6,IF(C20>7,C39,C38),C37),C36),C35),C34),C33),C32),0)","v":0},null,null,null,"Valor Presente Cupones",{"$f":"IF(H20>0,IF(H20>1,IF(H20>2,IF(H20>3,IF(H20>4,IF(H20>5,IF(H20>6,IF(H20>7,H39,H38),H37),H36),H35),H34),H33),H32),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C16-C21)*(1+(C4/100*C8/360))","v":102.31119543297483},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H16-H21)*(1+(H4/100*H8/360))","v":102.30000083637069}]
[]
[]
[]
[null,"Valor Teórico del Futuro",{"$f":"MROUND(C22,0.1)","v":102.30000000000001},null,null,{"$f":"'TASA-PRECIO'!D5","v":102.30000000000001},"Valor Teórico del Futuro",{"$f":"H22","v":102.30000083637069}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))","v":5.0154320987654319}]
[null,2,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))","v":9.9419138328870034}]
[null,3,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))","v":14.782545349121737}]
[null,4,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))","v":19.540267498148232}]
[null,5,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))","v":24.217872564354334}]
[null,6,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))","v":28.818014107171035}]
[null,7,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))","v":33.34321600079398}]
[null,8,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))","v":37.795880749389681}]
[null,9,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1638-C6)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1638-H6)/36000))","v":42.178297146369182}]
[null,10,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1638-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1820-C6)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1638-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1820-H6)/36000))","v":46.492647338855576}]
[]
[]
["JUNIO",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"H4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C6","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H49","v":"2014-06-30"}]
[null,"Futuro Analizado","2014-06-30",null,null,null,"Futuro Analizado",{"$f":"C49","v":"2014-06-30"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C49-C48","v":119},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H49-H48","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B45","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G45","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C51-C48","v":3930},null,null,null,"Dias por Vencer",{"$f":"H51-H48","v":3811}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C53","v":0.1}]
[null,"Rendimiento a Vencimiento",{"$f":"C12","v":0.1},null,null,null,"Rendimiento a Vencimiento",0.1033062994099197]
[null,"Dias Trans. Cupón Vigente",{"$f":"C48-C59","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H48-H59","v":11}]
[null,"Precio Limpio",{"$f":"100*((((C53*182/360*(1+(1/(C54*182/360))))+(((1+(C54*182/360))^(1-(INT(C52/182)+1)))*(1-((C53*182/360)/(C54*182/360)))))/((1+(C54*182/360))^((((C52/182)-INT(C52/182))*182)/182)))-((C53*182/360)*(182-((((C52/182)-INT(C52/182))*182)))/182))","v":99.969968410314848},null,null,null,"Precio Limpio",{"$f":"100*((((H53*182/360*(1+(1/(H54*182/360))))+(((1+(H54*182/360))^(1-(INT(H52/182)+1)))*(1-((H53*182/360)/(H54*182/360)))))/((1+(H54*182/360))^((((H52/182)-INT(H52/182))*182)/182)))-((H53*182/360)*(182-((((H52/182)-INT(H52/182))*182)))/182))","v":97.894445601370776}]
[null,"Intereses Corridos",{"$f":"100*((C53)*(C55/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H53)*(H55/360))","v":0.30555555555555558}]
[null,"Precio Sucio",{"$f":"C56+C57","v":102.02552396587041},null,null,null,"Precio Sucio",{"$f":"H56+H57","v":98.200001156926334}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-06-19"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-06-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C60","v":"2014-06-19"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C60-C59)/182)","v":1},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H60-H59)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C62>0,IF(C62>1,IF(C62>2,IF(C62>3,IF(C62>4,IF(C62>5,IF(C62>6,IF(C62>7,C81,C80),C79),C78),C77),C76),C75),C74),0)","v":5.0015389350569404},null,null,null,"Valor Presente Cupones",{"$f":"IF(H62>0,IF(H62>1,IF(H62>2,IF(H62>3,IF(H62>4,IF(H62>5,IF(H62>6,IF(H62>7,H81,H80),H79),H78),H77),H76),H75),H74),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C58-C63)*(1+(C46/100*C50/360))","v":98.178570452680148},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H58-H63)*(1+(H46/100*H50/360))","v":98.200001156926334}]
[]
[]
[]
[null,"Valor Teórico del Futuro",{"$f":"MROUND(C64,0.1)","v":98.2},null,null,{"$f":"'TASA-PRECIO'!D6","v":98.2},"Valor Teórico del Futuro",{"$f":"H64","v":98.200001156926334}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))","v":4.9705589967117847}]
[null,2,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))","v":9.8537383220817798}]
[null,3,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))","v":14.652557074388904}]
[null,4,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))","v":19.369880537630067}]
[null,5,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))","v":24.008430455563413}]
[null,6,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))","v":28.570794462020913}]
[null,7,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))","v":33.059434749293892}]
[null,8,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))","v":37.476696047289138}]
[null,9,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1638-C48)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1638-H48)/36000))","v":41.824812978187524}]
[null,10,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1638-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1820-C48)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1638-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1820-H48)/36000))","v":46.105916844353629}]
[]
[]
["SEPTIEMBRE",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"H4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C48","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H91","v":"2014-09-30"}]
[null,"Futuro Analizado","2014-09-30",null,null,null,"Futuro Analizado",{"$f":"C91","v":"2014-09-30"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C91-C90","v":211},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H91-H90","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B87","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G87","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C93-C90","v":3930},null,null,null,"Dias por Vencer",{"$f":"H93-H90","v":3719}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C95","v":0.1}]
[null,"Rendimiento a Vencimiento",{"$f":"C12","v":0.1},null,null,null,"Rendimiento a Vencimiento",0.10602693962316702]
[null,"Dias Trans. Cupón Vigente",{"$f":"C90-C101","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H90-H101","v":103}]
[null,"Precio Limpio",{"$f":"100*((((C95*182/360*(1+(1/(C96*182/360))))+(((1+(C96*182/360))^(1-(INT(C94/182)+1)))*(1-((C95*182/360)/(C96*182/360)))))/((1+(C96*182/360))^((((C94/182)-INT(C94/182))*182)/182)))-((C95*182/360)*(182-((((C94/182)-INT(C94/182))*182)))/182))","v":99.969968410314848},null,null,null,"Precio Limpio",{"$f":"100*((((H95*182/360*(1+(1/(H96*182/360))))+(((1+(H96*182/360))^(1-(INT(H94/182)+1)))*(1-((H95*182/360)/(H96*182/360)))))/((1+(H96*182/360))^((((H94/182)-INT(H94/182))*182)/182)))-((H95*182/360)*(182-((((H94/182)-INT(H94/182))*182)))/182))","v":96.238890385189833}]
[null,"Intereses Corridos",{"$f":"100*((C95)*(C97/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H95)*(H97/360))","v":2.8611111111111112}]
[null,"Precio Sucio",{"$f":"C98+C99","v":102.02552396587041},null,null,null,"Precio Sucio",{"$f":"H98+H99","v":99.100001496300948}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-06-19"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-06-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C102","v":"2014-06-19"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C102-C101)/182)","v":1},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H102-H101)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C104>0,IF(C104>1,IF(C104>2,IF(C104>3,IF(C104>4,IF(C104>5,IF(C104>6,IF(C104>7,C123,C122),C121),C120),C119),C118),C117),C116),0)","v":5.0015389350569404},null,null,null,"Valor Presente Cupones",{"$f":"IF(H104>0,IF(H104>1,IF(H104>2,IF(H104>3,IF(H104>4,IF(H104>5,IF(H104>6,IF(H104>7,H123,H122),H121),H120),H119),H118),H117),H116),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C100-C105)*(1+(C88/100*C92/360))","v":99.071191114963611},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H100-H105)*(1+(H88/100*H92/360))","v":99.100001496300948}]
[]
[]
[]
[null,"Valor Teórico del Futuro",{"$f":"MROUND(C106,0.1)","v":99.100000000000009},null,null,{"$f":"'TASA-PRECIO'!D7","v":99.100000000000009},"Valor Teórico del Futuro",{"$f":"H106","v":99.100001496300948}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))","v":5.0159297108399201}]
[null,2,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))","v":9.9428915620781577}]
[null,3,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))","v":14.783986607137582}]
[null,4,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))","v":19.542156541778105}]
[null,5,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))","v":24.220194439025775}]
[null,6,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))","v":28.820754595141487}]
[null,7,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))","v":33.346361573527986}]
[null,8,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))","v":37.79941852372226}]
[null,9,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1638-C90)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1638-H90)/36000))","v":42.182214844099853}]
[null,10,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1638-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1820-C90)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1638-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1820-H90)/36000))","v":46.496933249455793}]
[]
[]
["DICIEMBRE",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"C130","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C90","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H133","v":"2014-12-31"}]
[null,"Futuro Analizado","2014-12-31",null,null,null,"Futuro Analizado",{"$f":"C133","v":"2014-12-31"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C133-C132","v":303},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H133-H132","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B129","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G129","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C135-C132","v":3930},null,null,null,"Dias por Vencer",{"$f":"H135-H132","v":3627}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C137","v":0.1}]
[null,"Rendimiento a Vencimiento",{"$f":"C12","v":0.1},null,null,null,"Rendimiento a Vencimiento",0.10905304403903958]
[null,"Dias Trans. Cupón Vigente",{"$f":"C132-C143","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H132-H143","v":13}]
[null,"Precio Limpio",{"$f":"100*((((C137*182/360*(1+(1/(C138*182/360))))+(((1+(C138*182/360))^(1-(INT(C136/182)+1)))*(1-((C137*182/360)/(C138*182/360)))))/((1+(C138*182/360))^((((C136/182)-INT(C136/182))*182)/182)))-((C137*182/360)*(182-((((C136/182)-INT(C136/182))*182)))/182))","v":99.969968410314848},null,null,null,"Precio Limpio",{"$f":"100*((((H137*182/360*(1+(1/(H138*182/360))))+(((1+(H138*182/360))^(1-(INT(H136/182)+1)))*(1-((H137*182/360)/(H138*182/360)))))/((1+(H138*182/360))^((((H136/182)-INT(H136/182))*182)/182)))-((H137*182/360)*(182-((((H136/182)-INT(H136/182))*182)))/182))","v":94.538502217755493}]
[null,"Intereses Corridos",{"$f":"100*((C137)*(C139/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H137)*(H139/360))","v":0.3611111111111111}]
[null,"Precio Sucio",{"$f":"C140+C141","v":102.02552396587041},null,null,null,"Precio Sucio",{"$f":"H140+H141","v":94.899613328866607}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-12-18"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-12-18",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C144","v":"2014-12-18"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C144-C143)/182)","v":2},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H144-H143)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C146>0,IF(C146>1,IF(C146>2,IF(C146>3,IF(C146>4,IF(C146>5,IF(C146>6,IF(C146>7,C165,C164),C163),C162),C161),C160),C159),C158),0)","v":9.914615276704712},null,null,null,"Valor Presente Cupones",{"$f":"IF(H146>0,IF(H146>1,IF(H146>2,IF(H146>3,IF(H146>4,IF(H146>5,IF(H146>6,IF(H146>7,H165,H164),H163),H162),H161),H160),H159),H158),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C142-C147)*(1+(C130/100*C134/360))","v":94.901869222447417},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H142-H147)*(1+(H130/100*H134/360))","v":94.899613328866607}]
[]
[]
[]
[null,"Valor Teórico del Futuro",{"$f":"MROUND(C148,0.1)","v":94.9},null,null,{"$f":"'TASA-PRECIO'!D8","v":94.9},"Valor Teórico del Futuro",{"$f":"H148","v":94.899613328866607}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))","v":4.9715365872313457}]
[null,2,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))","v":9.8556594309716168}]
[null,3,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))","v":14.655389380231615}]
[null,4,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))","v":19.373593351818695}]
[null,5,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))","v":24.012994614143697}]
[null,6,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))","v":28.576182226342951}]
[null,7,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))","v":33.06561971462601}]
[null,8,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))","v":37.4836530586403}]
[null,9,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1638-C132)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1638-H132)/36000))","v":41.832518052666586}]
[null,10,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1638-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1820-C132)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1638-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1820-H132)/36000))","v":46.114347099465562}]

{"sheet":"Datos DC24 (2)","index":4,"n_rows":167,"n_cols":8,"rows_kept":167,"cut":false,"hidden":false,"merged":[[128,1,128,2],[86,1,86,2],[44,1,44,2],[0,2,0,3],[2,1,2,2],[0,7,0,8],[2,6,2,7],[44,6,44,7],[86,6,86,7],[128,6,128,7]]}
[null,"FUTURO M10",null,null,null,null,"FUTURO M10"]
["MARZO",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"'PRECIO-TASA'!B2","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"C4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"'PRECIO-TASA'!B1","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H7","v":"2014-03-31"}]
[null,"Futuro Analizado","2014-03-31",null,null,null,"Futuro Analizado",{"$f":"C7","v":"2014-03-31"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C7-C6","v":28},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H7-H6","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B3","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G3","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C9-C6","v":3930},null,null,null,"Dias por Vencer",{"$f":"H9-H6","v":3902}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C11","v":0.1}]
[null,"Rendimiento a Vencimiento",0.10357288916070168,null,null,null,"Rendimiento a Vencimiento",0.10437736486862781]
[null,"Dias Trans. Cupón Vigente",{"$f":"C6-C17","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H6-H17","v":102}]
[null,"Precio Limpio",{"$f":"100*((((C11*182/360*(1+(1/(C12*182/360))))+(((1+(C12*182/360))^(1-(INT(C10/182)+1)))*(1-((C11*182/360)/(C12*182/360)))))/((1+(C12*182/360))^((((C10/182)-INT(C10/182))*182)/182)))-((C11*182/360)*(182-((((C10/182)-INT(C10/182))*182)))/182))","v":97.665204653518416},null,null,null,"Precio Limpio",{"$f":"100*((((H11*182/360*(1+(1/(H12*182/360))))+(((1+(H12*182/360))^(1-(INT(H10/182)+1)))*(1-((H11*182/360)/(H12*182/360)))))/((1+(H12*182/360))^((((H10/182)-INT(H10/182))*182)/182)))-((H11*182/360)*(182-((((H10/182)-INT(H10/182))*182)))/182))","v":97.166670532374212}]
[null,"Intereses Corridos",{"$f":"100*((C11)*(C13/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H11)*(H13/360))","v":2.8333333333333335}]
[null,"Precio Sucio",{"$f":"C14+C15","v":99.720760209073973},null,null,null,"Precio Sucio",{"$f":"H14+H15","v":100.00000386570754}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono",{"$f":"C17","v":"2013-12-19"}]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2013-12-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C18","v":"2013-12-19"}]
[null,"Siguiente Cupón del bono","2011-06-23",null,null,null,"Siguiente Cupón del bono","2011-06-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C18-C17)/182)","v":0},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H18-H17)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C20>0,IF(C20>1,IF(C20>2,IF(C20>3,IF(C20>4,IF(C20>5,IF(C20>6,IF(C20>7,C39,C38),C37),C36),C35),C34),C33),C32),0)","v":0},null,null,null,"Valor Presente Cupones",{"$f":"IF(H20>0,IF(H20>1,IF(H20>2,IF(H20>3,IF(H20>4,IF(H20>5,IF(H20>6,IF(H20>7,H39,H38),H37),H36),H35),H34),H33),H32),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C16-C21)*(1+(C4/100*C8/360))","v":99.999978337659371},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H16-H21)*(1+(H4/100*H8/360))","v":100.00000386570754}]
[]
[]
[]
[{"$f":"'PRECIO-TASA'!B5","v":100},"Valor Teórico del Futuro",{"$f":"C22","v":99.999978337659371},null,null,{"$f":"A26","v":100},"Valor Teórico del Futuro",{"$f":"H22","v":100.00000386570754}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))","v":5.0154320987654319}]
[null,2,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))","v":9.9419138328870034}]
[null,3,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))","v":14.782545349121737}]
[null,4,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))","v":19.540267498148232}]
[null,5,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))","v":24.217872564354334}]
[null,6,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))","v":28.818014107171035}]
[null,7,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))","v":33.34321600079398}]
[null,8,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))","v":37.795880749389681}]
[null,9,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1638-C6)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1638-H6)/36000))","v":42.178297146369182}]
[null,10,{"$f":"(100*C11*(182)/360)/(1+(C4*(C17+182-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+364-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+546-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+728-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+910-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1092-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1274-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1456-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1638-C6)/36000))+(100*C11*(182)/360)/(1+(C4*(C17+1820-C6)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H11*(182)/360)/(1+(H4*(H17+182-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+364-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+546-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+728-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+910-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1092-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1274-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1456-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1638-H6)/36000))+(100*H11*(182)/360)/(1+(H4*(H17+1820-H6)/36000))","v":46.492647338855576}]
[]
[]
["JUNIO",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"H4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C6","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H49","v":"2014-06-30"}]
[null,"Futuro Analizado","2014-06-30",null,null,null,"Futuro Analizado",{"$f":"C49","v":"2014-06-30"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C49-C48","v":119},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H49-H48","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B45","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G45","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C51-C48","v":3930},null,null,null,"Dias por Vencer",{"$f":"H51-H48","v":3811}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C53","v":0.1}]
[null,"Rendimiento a Vencimiento",9.7287987801851508E-2,null,null,null,"Rendimiento a Vencimiento",0.10046316633038636]
[null,"Dias Trans. Cupón Vigente",{"$f":"C48-C59","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H48-H59","v":11}]
[null,"Precio Limpio",{"$f":"100*((((C53*182/360*(1+(1/(C54*182/360))))+(((1+(C54*182/360))^(1-(INT(C52/182)+1)))*(1-((C53*182/360)/(C54*182/360)))))/((1+(C54*182/360))^((((C52/182)-INT(C52/182))*182)/182)))-((C53*182/360)*(182-((((C52/182)-INT(C52/182))*182)))/182))","v":101.76989071254192},null,null,null,"Precio Limpio",{"$f":"100*((((H53*182/360*(1+(1/(H54*182/360))))+(((1+(H54*182/360))^(1-(INT(H52/182)+1)))*(1-((H53*182/360)/(H54*182/360)))))/((1+(H54*182/360))^((((H52/182)-INT(H52/182))*182)/182)))-((H53*182/360)*(182-((((H52/182)-INT(H52/182))*182)))/182))","v":99.695289100923887}]
[null,"Intereses Corridos",{"$f":"100*((C53)*(C55/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H53)*(H55/360))","v":0.30555555555555558}]
[null,"Precio Sucio",{"$f":"C56+C57","v":103.82544626809748},null,null,null,"Precio Sucio",{"$f":"H56+H57","v":100.00084465647944}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-06-19"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-06-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C60","v":"2014-06-19"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C60-C59)/182)","v":1},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H60-H59)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C62>0,IF(C62>1,IF(C62>2,IF(C62>3,IF(C62>4,IF(C62>5,IF(C62>6,IF(C62>7,C81,C80),C79),C78),C77),C76),C75),C74),0)","v":5.0015389350569404},null,null,null,"Valor Presente Cupones",{"$f":"IF(H62>0,IF(H62>1,IF(H62>2,IF(H62>3,IF(H62>4,IF(H62>5,IF(H62>6,IF(H62>7,H81,H80),H79),H78),H77),H76),H75),H74),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C58-C63)*(1+(C46/100*C50/360))","v":99.999911830303716},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H58-H63)*(1+(H46/100*H50/360))","v":100.00084465647944}]
[]
[]
[]
[{"$f":"'PRECIO-TASA'!B6","v":100},"Valor Teórico del Futuro",{"$f":"C64","v":99.999911830303716},null,null,{"$f":"A68","v":100},"Valor Teórico del Futuro",{"$f":"H64","v":100.00084465647944}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))","v":4.9705589967117847}]
[null,2,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))","v":9.8537383220817798}]
[null,3,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))","v":14.652557074388904}]
[null,4,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))","v":19.369880537630067}]
[null,5,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))","v":24.008430455563413}]
[null,6,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))","v":28.570794462020913}]
[null,7,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))","v":33.059434749293892}]
[null,8,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))","v":37.476696047289138}]
[null,9,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1638-C48)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1638-H48)/36000))","v":41.824812978187524}]
[null,10,{"$f":"(100*C53*(182)/360)/(1+(C46*(C59+182-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+364-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+546-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+728-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+910-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1092-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1274-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1456-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1638-C48)/36000))+(100*C53*(182)/360)/(1+(C46*(C59+1820-C48)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H53*(182)/360)/(1+(H46*(H59+182-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+364-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+546-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+728-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+910-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1092-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1274-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1456-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1638-H48)/36000))+(100*H53*(182)/360)/(1+(H46*(H59+1820-H48)/36000))","v":46.105916844353629}]
[]
[]
["SEPTIEMBRE",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"H4","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C48","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H91","v":"2014-09-30"}]
[null,"Futuro Analizado","2014-09-30",null,null,null,"Futuro Analizado",{"$f":"C91","v":"2014-09-30"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C91-C90","v":211},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H91-H90","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B87","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G87","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C93-C90","v":3930},null,null,null,"Dias por Vencer",{"$f":"H93-H90","v":3719}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C95","v":0.1}]
[null,"Rendimiento a Vencimiento",9.8621324346863867E-2,null,null,null,"Rendimiento a Vencimiento",0.10454386626686013]
[null,"Dias Trans. Cupón Vigente",{"$f":"C90-C101","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H90-H101","v":103}]
[null,"Precio Limpio",{"$f":"100*((((C95*182/360*(1+(1/(C96*182/360))))+(((1+(C96*182/360))^(1-(INT(C94/182)+1)))*(1-((C95*182/360)/(C96*182/360)))))/((1+(C96*182/360))^((((C94/182)-INT(C94/182))*182)/182)))-((C95*182/360)*(182-((((C94/182)-INT(C94/182))*182)))/182))","v":100.87943711581156},null,null,null,"Precio Limpio",{"$f":"100*((((H95*182/360*(1+(1/(H96*182/360))))+(((1+(H96*182/360))^(1-(INT(H94/182)+1)))*(1-((H95*182/360)/(H96*182/360)))))/((1+(H96*182/360))^((((H94/182)-INT(H94/182))*182)/182)))-((H95*182/360)*(182-((((H94/182)-INT(H94/182))*182)))/182))","v":97.138890136967319}]
[null,"Intereses Corridos",{"$f":"100*((C95)*(C97/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H95)*(H97/360))","v":2.8611111111111112}]
[null,"Precio Sucio",{"$f":"C98+C99","v":102.93499267136711},null,null,null,"Precio Sucio",{"$f":"H98+H99","v":100.00000124807843}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-06-19"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-06-19",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C102","v":"2014-06-19"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C102-C101)/182)","v":1},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H102-H101)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C104>0,IF(C104>1,IF(C104>2,IF(C104>3,IF(C104>4,IF(C104>5,IF(C104>6,IF(C104>7,C123,C122),C121),C120),C119),C118),C117),C116),0)","v":5.0015389350569404},null,null,null,"Valor Presente Cupones",{"$f":"IF(H104>0,IF(H104>1,IF(H104>2,IF(H104>3,IF(H104>4,IF(H104>5,IF(H104>6,IF(H104>7,H123,H122),H121),H120),H119),H118),H117),H116),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C100-C105)*(1+(C88/100*C92/360))","v":99.999849610146299},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H100-H105)*(1+(H88/100*H92/360))","v":100.00000124807843}]
[]
[]
[]
[{"$f":"'PRECIO-TASA'!B7","v":100},"Valor Teórico del Futuro",{"$f":"C106","v":99.999849610146299},null,null,{"$f":"A110","v":100},"Valor Teórico del Futuro",{"$f":"H106","v":100.00000124807843}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))","v":5.0159297108399201}]
[null,2,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))","v":9.9428915620781577}]
[null,3,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))","v":14.783986607137582}]
[null,4,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))","v":19.542156541778105}]
[null,5,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))","v":24.220194439025775}]
[null,6,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))","v":28.820754595141487}]
[null,7,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))","v":33.346361573527986}]
[null,8,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))","v":37.79941852372226}]
[null,9,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1638-C90)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1638-H90)/36000))","v":42.182214844099853}]
[null,10,{"$f":"(100*C95*(182)/360)/(1+(C88*(C101+182-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+364-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+546-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+728-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+910-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1092-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1274-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1456-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1638-C90)/36000))+(100*C95*(182)/360)/(1+(C88*(C101+1820-C90)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H95*(182)/360)/(1+(H88*(H101+182-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+364-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+546-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+728-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+910-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1092-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1274-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1456-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1638-H90)/36000))+(100*H95*(182)/360)/(1+(H88*(H101+1820-H90)/36000))","v":46.496933249455793}]
[]
[]
["DICIEMBRE",1,null,null,null,null,1]
[null,"2024-12-05",null,null,null,null,"2024-12-05"]
[null,"Tasa Fondeo",{"$f":"C4","v":3.6},null,null,null,"Tasa Fondeo",{"$f":"C130","v":3.6}]
[]
[null,"Fecha Consulta",{"$f":"C90","v":"2014-03-03"},null,null,null,"Fecha Consulta",{"$f":"H133","v":"2014-12-31"}]
[null,"Futuro Analizado","2014-12-31",null,null,null,"Futuro Analizado",{"$f":"C133","v":"2014-12-31"}]
[null,"Dias al Vencimiento del Fut.",{"$f":"C133-C132","v":303},null,null,null,"Dias al Vencimiento del Fut.",{"$f":"H133-H132","v":0}]
[null,"Fecha Vencimiento Bono",{"$f":"+B129","v":"2024-12-05"},null,null,null,"Fecha Vencimiento Bono",{"$f":"+G129","v":"2024-12-05"}]
[null,"Dias por Vencer",{"$f":"C135-C132","v":3930},null,null,null,"Dias por Vencer",{"$f":"H135-H132","v":3627}]
[null,"Tasa de Cupón",0.1,null,null,null,"Tasa de Cupón",{"$f":"C137","v":0.1}]
[null,"Rendimiento a Vencimiento",9.2699849046373697E-2,null,null,null,"Rendimiento a Vencimiento",0.10056466913804159]
[null,"Dias Trans. Cupón Vigente",{"$f":"C132-C143","v":74},null,null,null,"Dias Trans. Cupón Vigente",{"$f":"H132-H143","v":13}]
[null,"Precio Limpio",{"$f":"100*((((C137*182/360*(1+(1/(C138*182/360))))+(((1+(C138*182/360))^(1-(INT(C136/182)+1)))*(1-((C137*182/360)/(C138*182/360)))))/((1+(C138*182/360))^((((C136/182)-INT(C136/182))*182)/182)))-((C137*182/360)*(182-((((C136/182)-INT(C136/182))*182)))/182))","v":104.91796964576436},null,null,null,"Precio Limpio",{"$f":"100*((((H137*182/360*(1+(1/(H138*182/360))))+(((1+(H138*182/360))^(1-(INT(H136/182)+1)))*(1-((H137*182/360)/(H138*182/360)))))/((1+(H138*182/360))^((((H136/182)-INT(H136/182))*182)/182)))-((H137*182/360)*(182-((((H136/182)-INT(H136/182))*182)))/182))","v":99.639246288440191}]
[null,"Intereses Corridos",{"$f":"100*((C137)*(C139/360))","v":2.0555555555555558},null,null,null,"Intereses Corridos",{"$f":"100*((H137)*(H139/360))","v":0.3611111111111111}]
[null,"Precio Sucio",{"$f":"C140+C141","v":106.97352520131992},null,null,null,"Precio Sucio",{"$f":"H140+H141","v":100.00035739955131}]
[null,"Ultimo Cupón del bono","2013-12-19",null,null,null,"Ultimo Cupón del bono","2014-12-18"]
[null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO","2014-12-18",null,null,null,"Ultimo Cupón que paga AL VENCIMIENTO DEL FUTURO",{"$f":"C144","v":"2014-12-18"}]
[null,"Siguiente Cupón del bono","2010-12-23",null,null,null,"Siguiente Cupón del bono","2010-12-23"]
[null,"¿Paga Cupon(es)?",{"$f":"INT((C144-C143)/182)","v":2},null,null,null,"¿Paga Cupon(es)?",{"$f":"INT((H144-H143)/182)","v":0}]
[null,"Valor Presente Cupones",{"$f":"IF(C146>0,IF(C146>1,IF(C146>2,IF(C146>3,IF(C146>4,IF(C146>5,IF(C146>6,IF(C146>7,C165,C164),C163),C162),C161),C160),C159),C158),0)","v":9.914615276704712},null,null,null,"Valor Presente Cupones",{"$f":"IF(H146>0,IF(H146>1,IF(H146>2,IF(H146>3,IF(H146>4,IF(H146>5,IF(H146>6,IF(H146>7,H165,H164),H163),H162),H161),H160),H159),H158),0)","v":0}]
[null,"Precio Bruto Con Acarreo",{"$f":"(C142-C147)*(1+(C130/100*C134/360))","v":99.99979489533105},null,null,null,"Precio Bruto Con Acarreo",{"$f":"(H142-H147)*(1+(H130/100*H134/360))","v":100.00035739955131}]
[]
[]
[]
[{"$f":"'PRECIO-TASA'!B8","v":100},"Valor Teórico del Futuro",{"$f":"C148","v":99.99979489533105},null,null,{"$f":"A152","v":100},"Valor Teórico del Futuro",{"$f":"H148","v":100.00035739955131}]
[]
[]
[]
[]
[null,"Cupones",null,null,null,null,"Cupones"]
[null,1,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))","v":5.0015389350569404},null,null,null,1,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))","v":4.9715365872313457}]
[null,2,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))","v":9.914615276704712},null,null,null,2,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))","v":9.8556594309716168}]
[null,3,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))","v":14.742303927922775},null,null,null,3,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))","v":14.655389380231615}]
[null,4,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))","v":19.487522207963657},null,null,null,4,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))","v":19.373593351818695}]
[null,5,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))","v":24.153040439373363},null,null,null,5,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))","v":24.012994614143697}]
[null,6,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))","v":28.741491660607302},null,null,null,6,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))","v":28.576182226342951}]
[null,7,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))","v":33.255380549496188},null,null,null,7,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))","v":33.06561971462601}]
[null,8,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))","v":37.697091633273693},null,null,null,8,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))","v":37.4836530586403}]
[null,9,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1638-C132)/36000))","v":42.06889685253654},null,null,null,9,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1638-H132)/36000))","v":41.832518052666586}]
[null,10,{"$f":"(100*C137*(182)/360)/(1+(C130*(C143+182-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+364-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+546-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+728-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+910-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1092-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1274-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1456-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1638-C132)/36000))+(100*C137*(182)/360)/(1+(C130*(C143+1820-C132)/36000))","v":46.372962539200557},null,null,null,10,{"$f":"(100*H137*(182)/360)/(1+(H130*(H143+182-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+364-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+546-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+728-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+910-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1092-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1274-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1456-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1638-H132)/36000))+(100*H137*(182)/360)/(1+(H130*(H143+1820-H132)/36000))","v":46.114347099465562}]