{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["I. Calculadora - Oferta","I. Calculadora Fondeo UI","II. Calculadora Fondeo UP","III. Calculadora Fondeo USD","Títulos Elegibles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"I. Calculadora - Oferta","index":0,"n_rows":71,"n_cols":28,"rows_kept":71,"cut":false,"hidden":false,"merged":[[18,6,18,7],[18,16,18,17],[18,26,18,27]]}
[]
[null,"Serie I  (UI) - Calculadora Yield / Precio - ISIN UYFFCN179UI0",null,null,null,null,null,null,null,null,null,"Serie II  (UP) - Calculadora Yield / Precio - ISIN UYFFCN180UP3",null,null,null,null,null,null,null,null,null,"Serie III  (USD) - Calculadora Yield / Precio - ISIN UYFFCN181US5"]
[]
[null,"I. Datos del Instrumento",null,null,"II. Datos integración/adjudicación",null,null,null,null,null,null,"I. Datos del Instrumento",null,null,"II. Datos integración/adjudicación",null,null,null,null,null,null,"I. Datos del Instrumento",null,null,"II. Datos integración/adjudicación"]
[null,"Fecha Emitido","2023-12-14",null,"Fecha Cierre","2024-04-25",null,null,null,null,null,"Fecha Emitido",{"$f":"+C5","v":"2023-12-14"},null,"Fecha Cierre",{"$f":"+F5","v":"2024-04-25"},null,null,null,null,null,"Fecha Emitido",{"$f":"+C5","v":"2023-12-14"},null,"Fecha Cierre",{"$f":"+F5","v":"2024-04-25"}]
[null,"Cupon (UI)",3.7999999999999999E-2,null,null,null,null,null,null,null,null,"Cupon (UP)",2.2499999999999999E-2,null,null,null,null,null,null,null,null,"Cupon (USD)",5.7000000000000002E-2]
[null,"Dias Devengados",{"$f":"DAYS360(C5,B20,0)","v":131},null,"Precio ====>",100,null,null,null,null,null,"Dias Devengados",{"$f":"DAYS360(M5,L20)","v":131},null,"Precio ====>",100,null,null,null,null,null,"Dias Devengados",{"$f":"DAYS360(W5,V20)","v":131},null,"Precio ====>",100]
[null,"Cupon Devengado ",{"$f":"C6*C7/360","v":1.3827777777777777E-2},null,"TIR ",{"$f":"+XIRR(F20:F71,B20:B71)","v":3.7263610959053048E-2},null,null,null,null,null,"Cupon Devengado ",{"$f":"M6*M7/360","v":8.1874999999999986E-3},null,"TIR ",{"$f":"+XIRR(P20:P71,L20:L71)","v":2.2058442234992981E-2},null,null,null,null,null,"Cupon Devengado ",{"$f":"W6*W7/360","v":2.0741666666666669E-2},null,"TIR ",{"$f":"+XIRR(Z20:Z71,V20:V71)","v":5.5893847346305842E-2}]
[null,null,null,null,"YIELD",{"$f":"+(((1+F8)^(0.5))-1)*2","v":3.6922787892612163E-2},null,null,null,null,null,null,null,null,"YIELD",{"$f":"+(((1+P8)^(0.5))-1)*2","v":2.1938121936468047E-2},null,null,null,null,null,null,null,null,"YIELD",{"$f":"+(((1+Z8)^(0.5))-1)*2","v":5.5133910329256963E-2}]
[null,null,null,null,"DURATION",{"$f":"+H20/G20","v":13.293584728191625},null,null,null,null,null,null,null,null,"DURATION",{"$f":"+R20/Q20","v":15.068966751257561},null,null,null,null,null,null,null,null,"DURATION",{"$f":"+AB20/AA20","v":11.544792882056564}]
[]
[null,"III. Monto a ser Integrado",null,null,null,null,null,null,null,null,null,"III. Monto a ser Integrado",null,null,null,null,null,null,null,null,null,"III. Monto a ser Integrado"]
[null,"Valor Nominal Monto adjudicado",40000000,"UI",null,null,null,null,null,null,null,"Valor Nominal Monto adjudicado",15000000,"UP",null,null,null,null,null,null,null,"Valor Nominal Monto adjudicado",1000000,"USD"]
[null,"Nominal * Precio",{"$f":"C13*F7/100","v":40000000},null,null,null,null,null,null,null,null,"Nominal * Precio",{"$f":"M13*P7/100","v":15000000},null,null,null,null,null,null,null,null,"Nominal * Precio",{"$f":"W13*Z7/100","v":1000000}]
[null,"Cupon Devengado",{"$f":"C13*C8","v":553111.11111111112},null,null,null,null,null,null,null,null,"Cupon Devengado",{"$f":"M13*M8","v":122812.49999999999},null,null,null,null,null,null,null,null,"Cupon Devengado",{"$f":"W13*W8","v":20741.666666666668}]
[null,"Total UI a Fondear",{"$f":"C15+C14","v":40553111.111111112},null,null,null,null,null,null,null,null,"Total UP a Fondear",{"$f":"M15+M14","v":15122812.5},null,null,null,null,null,null,null,null,"Total USD a Fondear",{"$f":"W15+W14","v":1020741.6666666666}]
[]
[]
[null,"Fecha","Variación capital","Saldo","Intereses","FF","Cálculo Duration",null,null,null,null,"Fecha","Variación capital","Saldo","Intereses","FF","Cálculo Duration",null,null,null,null,"Fecha","Variación capital","Saldo","Intereses","FF","Cálculo Duration"]
[null,{"$f":"+F5","v":"2024-04-25"},0,1,null,{"$f":"-F7%-C8","v":-1.0138277777777778},{"$f":"+SUM(G21:G71)*100","v":101.41683838479376},{"$f":"+SUM(H21:H71)*100","v":1348.1933339335726},null,null,null,{"$f":"+P5","v":"2024-04-25"},0,1,null,{"$f":"-P7%-M8","v":-1.0081875},{"$f":"+SUM(Q21:Q71)*100","v":100.84162259554812},{"$f":"+SUM(R21:R71)*100","v":1519.5790580351777},null,null,null,{"$f":"+Z5","v":"2024-04-25"},0,1,null,{"$f":"-Z7%-W8","v":-1.0207416666666667},{"$f":"+SUM(AA21:AA71)*100","v":102.11851511513422},{"$f":"+SUM(AB21:AB71)*100","v":1178.9371064273871}]
[null,"2024-06-20",0,{"$f":"+D20-C21","v":1},{"$f":"+D20*((1+($C$6*(DAYS360(B20,B21)/360))-1))","v":5.8055555555556193E-3},{"$f":"(C21+E21)","v":5.8055555555556193E-3},{"$f":"+(F21/((1+$F$8)^((DAYS360($B$20,B21))/360)))","v":5.7731956735076846E-3},{"$f":"+G21*DAYS360($B$20,B21)/360","v":8.8201600567478519E-4},null,null,null,"2024-06-20",0,{"$f":"+N20-M21","v":1},{"$f":"+N20*((1+($M$6*(DAYS360(L20,L21)/360))-1))","v":3.4374999999999822E-3},{"$f":"(M21+O21)","v":3.4374999999999822E-3},{"$f":"+(P21/((1+$P$8)^((DAYS360($L$20,L21))/360)))","v":3.4260604848941984E-3},{"$f":"+Q21*DAYS360($L$20,L21)/360","v":5.2342590741439145E-4},null,null,null,"2024-06-20",0,{"$f":"+X20-W21","v":1},{"$f":"+X20*((1+($W$6*(DAYS360(V20,V21)/360))-1))","v":8.7083333333333179E-3},{"$f":"(W21+Y21)","v":8.7083333333333179E-3},{"$f":"+(Z21/((1+$Z$8)^((DAYS360($V$20,V21))/360)))","v":8.6362736239636775E-3},{"$f":"+AA21*DAYS360($V$20,V21)/360","v":1.3194306925500062E-3}]
[null,"2024-12-20",0,{"$f":"+D21-C22","v":1},1.8999999999999906E-2,1.8999999999999906E-2,{"$f":"+(F22/((1+$F$8)^((DAYS360($B$20,B22))/360)))","v":1.855160641707692E-2},{"$f":"+G22*DAYS360($B$20,B22)/360","v":1.2110076411147433E-2},null,null,null,"2024-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.109090477624302E-2,7.23989617338086E-3,null,null,null,"2024-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,{"$f":"+(Z22/((1+$Z$8)^((DAYS360($V$20,V22))/360)))","v":2.7505913927869434E-2},{"$f":"+AA22*DAYS360($V$20,V22)/360","v":1.7955249369581434E-2}]
[null,"2025-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.8215326105974095E-2,2.099822314994236E-2,null,null,null,"2025-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0970567947569969E-2,1.2646626939559827E-2,null,null,null,"2025-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.6768001627166631E-2,{"$f":"+AA23*DAYS360($V$20,V23)/360","v":3.0857557431317087E-2}]
[null,"2025-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.7885141463628636E-2,2.9560164363497326E-2,null,null,null,"2025-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0851536779041628E-2,1.7935178843138246E-2,null,null,null,"2025-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.6049885598820249E-2,4.3054672031383467E-2]
[null,"2026-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.7560941995383626E-2,3.7804805684506421E-2,null,null,null,"2026-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0733797104185167E-2,2.3107479877065289E-2,null,null,null,"2026-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.5351034760208637E-2,5.4575144275449156E-2]
[null,"2026-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.7242619209491064E-2,4.5740837069622134E-2,null,null,null,"2026-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,{"$f":"+(P26/((1+$P$8)^((DAYS360($L$20,L26))/360)))","v":1.0617334910234644E-2},2.8165430109094683E-2,null,null,null,"2026-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.4670932276278871E-2,6.5446500899573115E-2]
[null,"2027-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.6930066580805623E-2,5.3376737692262172E-2,null,null,null,"2027-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0502136336463271E-2,{"$f":"+Q27*DAYS360($L$20,L27)/360","v":3.3110902060793923E-2},null,null,null,"2027-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.4009075177321454E-2,7.5695278684055137E-2]
[null,"2027-12-20",0,1,1.8999999999999906E-2,{"$f":"(C28+E28)","v":1.8999999999999906E-2},1.6623179515136519E-2,6.0720780728901455E-2,null,null,null,"2027-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0388187672533791E-2,3.7945741081616489E-2,null,null,null,"2027-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.3364973986999136E-2,8.5347057758066294E-2]
[null,"2028-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.6321855314245622E-2,6.7781038041103345E-2,null,null,null,"2028-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0275475356866732E-2,4.2671765718099344E-2,null,null,null,"2028-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.2738152360354744E-2,9.4426493829806502E-2]
[null,"2028-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.6025993141479962E-2,7.4565384755497052E-2,null,null,null,"2028-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0163985975026393E-2,4.7290768078247801E-2,null,null,null,"2028-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.2128146731530324E-2,0.10295734937587027]
[null,"2029-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.5735493988027257E-2,8.1081503743862679E-2,null,null,null,"2029-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,1.0053706258124311E-2,5.1804514191168327E-2,null,null,null,"2029-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.1534505970937076E-2,0.11096252382246743]
[null,"2029-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.5450260639783112E-2,8.7336890005440648E-2,null,null,null,"2029-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.9446230812400786E-3,5.6214744362009891E-2,null,null,null,"2029-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.0956791051622507E-2,0.11846408275014389]
[null,"2030-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.5170197644818788E-2,9.3338854953537817E-2,null,null,null,"2030-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.8367234618592855E-3,6.0523173522273106E-2,null,null,null,"2030-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,2.0394574724588121E-2,0.12548328615267412]
[null,"2030-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.4895211281438685E-2,9.9094530608460143E-2,null,null,null,"2030-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.7299945583283979E-3,6.4731491575545877E-2,null,null,null,"2030-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.9847441202817451E-2,0.13204061577985499]
[null,"2031-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.4625209526816849E-2,0.1046108736987594,null,null,null,"2031-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.6244236683264098E-3,6.8841363738723627E-2,null,null,null,"2031-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.9314985853780841E-2,0.13815580159301574]
[null,"2031-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.4360102026201988E-2,0.10989466967274021,null,null,null,"2031-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.519998227353093E-3,7.2854430878771595E-2,null,null,null,"2031-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.8796814900189494E-2,0.14384784736117237]
[null,"2032-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.4099800062680686E-2,0.11495253662213283,null,null,null,"2032-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.4167058072336229E-3,7.6772309845085221E-2,null,null,null,"2032-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.8292545128777538E-2,0.14913505542489464]
[null,"2032-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.3844216527488754E-2,0.11979092911979852,null,null,null,"2032-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.3145341146394466E-3,8.0596593797505209E-2,null,null,null,"2032-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.7801803606896694E-2,0.15403505065411999]
[null,"2033-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.3593265890860689E-2,0.12441614197329436,null,null,null,"2033-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.2134709896251922E-3,8.4328852530041687E-2,null,null,null,"2033-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.732422740671398E-2,0.15856480362534045]
[null,"2033-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.3346864173407571E-2,0.12883431389608699,null,null,null,"2033-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.1135044041814571E-3,8.7970632790362671E-2,null,null,null,"2033-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.6859463336808482E-2,0.16274065304280411]
[null,"2034-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.3104928918013781E-2,0.13305143109816769,null,null,null,"2034-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,9.014622460803293E-3,9.1523458595100096E-2,null,null,null,"2034-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.6407167680968678E-2,0.16657832742761255]
[null,"2034-12-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.286737916224312E-2,0.13707333079778433,null,null,null,"2034-12-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,8.9168133910742329E-3,9.49888315410269E-2,null,null,null,"2034-12-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.5967005943997151E-2,0.17009296609785854]
[null,"2035-06-20",0,1,1.8999999999999906E-2,1.8999999999999906E-2,1.2634135411245147E-2,0.14090570465597019,null,null,null,"2035-06-20",0,1,1.1249999999999982E-2,1.1249999999999982E-2,8.8200655542656718E-3,9.8368231112157423E-2,null,null,null,"2035-06-20",0,1,2.849999999999997E-2,2.849999999999997E-2,1.5538652604334716E-2,0.17329913946223299]
[null,"2035-12-20",{"$f":"+(3.57142857142857)%","v":3.5714285714285698E-2},0.9642857142857143,1.8999999999999906E-2,5.4714285714285604E-2,3.5723013617078678E-2,0.41627233923234735,null,null,null,"2035-12-20",{"$f":"+(3.57142857142857)%","v":3.5714285714285698E-2},0.9642857142857143,1.1249999999999982E-2,4.6964285714285681E-2,3.6420771994527486E-2,0.42440316254734112,null,null,null,"2035-12-20",{"$f":"+(3.57142857142857)%","v":3.5714285714285698E-2},0.9642857142857143,2.849999999999997E-2,6.4214285714285668E-2,3.4071403496530255E-2,0.39702649352206787]
[null,"2036-06-20",{"$f":"+(3.57142857142857)%","v":3.5714285714285698E-2},0.9285714285714286,1.8321428571428482E-2,5.403571428571418E-2,3.4640462407970335E-2,0.42097784176352837,null,null,null,"2036-06-20",3.5714285714285698E-2,0.9285714285714286,1.0848214285714268E-2,4.6562499999999965E-2,3.5717401093027228E-2,0.43406563828331701,null,null,null,"2036-06-20",3.5714285714285698E-2,0.9285714285714286,2.748214285714283E-2,6.3196428571428528E-2,3.2631780701235832E-2,0.39656677935529655]
[null,"2036-12-20",3.5714285714285698E-2,0.8928571428571429,1.7642857142857057E-2,5.3357142857142756E-2,3.3585419633725792E-2,0.42494885119894721,null,null,null,"2036-12-20",3.5714285714285698E-2,0.8928571428571429,1.0446428571428554E-2,4.6160714285714249E-2,3.5025005824205986E-2,0.44316361535905069,null,null,null,"2036-12-20",3.5714285714285698E-2,0.8928571428571429,2.6464285714285687E-2,6.2178571428571389E-2,3.1244879075601858E-2,0.39533451163712907]
[null,"2037-06-20",3.5714285714285698E-2,0.85714285714285721,1.696428571428563E-2,5.2678571428571325E-2,3.2557243720983869E-2,0.42821819171905173,null,null,null,"2037-06-20",3.5714285714285698E-2,0.85714285714285721,1.0044642857142842E-2,4.5758928571428541E-2,3.434343081910695E-2,0.45171151369019835,null,null,null,"2037-06-20",3.5714285714285698E-2,0.85714285714285721,2.5446428571428547E-2,6.1160714285714249E-2,2.9908905985710294E-2,0.39338519400649513]
[null,"2037-12-20",3.5714285714285698E-2,0.82142857142857151,1.6285714285714206E-2,5.1999999999999907E-2,3.1555307316967103E-2,0.43081759850803691,null,null,null,"2037-12-20",3.5714285714285698E-2,0.82142857142857151,9.6428571428571284E-3,4.5357142857142825E-2,3.367252278820404E-2,0.45972347084450799,null,null,null,"2037-12-20",3.5714285714285698E-2,0.82142857142857151,2.4428571428571404E-2,6.0142857142857102E-2,2.8622127037140555E-2,0.39077153996540509]
[null,"2038-06-20",3.5714285714285698E-2,0.78571428571428581,1.5607142857142781E-2,5.1321428571428476E-2,3.0578996984743371E-2,0.43277774899240967,null,null,null,"2038-06-20",3.5714285714285698E-2,0.78571428571428581,9.2410714285714145E-3,4.4955357142857116E-2,3.3012130494568769E-2,0.46721334686063298,null,null,null,"2038-06-20",3.5714285714285698E-2,0.78571428571428581,2.3410714285714264E-2,5.9124999999999962E-2,2.7382864240316281E-2,0.38754359251225406]
[null,"2038-12-20",3.5714285714285698E-2,0.75000000000000011,1.4928571428571357E-2,5.0642857142857059E-2,2.9627712904862831E-2,0.43412829325875402,null,null,null,"2038-12-20",3.5714285714285698E-2,0.75000000000000011,8.8392857142857006E-3,4.4553571428571401E-2,3.2362104727374358E-2,0.4741947289913882,null,null,null,"2038-12-20",3.5714285714285698E-2,0.75000000000000011,2.2392857142857121E-2,5.8107142857142816E-2,2.6189494232374523E-2,0.38374883909937668]
[null,"2039-06-20",3.5714285714285698E-2,0.71428571428571441,1.4249999999999931E-2,4.9964285714285628E-2,2.870086858323902E-2,0.43489788367102455,null,null,null,"2039-06-20",3.5714285714285698E-2,0.71428571428571441,8.4374999999999884E-3,4.4151785714285685E-2,3.1722298275733363E-2,0.48068093637257081,null,null,null,"2039-06-20",3.5714285714285698E-2,0.71428571428571441,2.1374999999999981E-2,5.7089285714285676E-2,2.5040446553845155E-2,0.379432322086737]
[null,"2039-12-20",3.5714285714285698E-2,0.67857142857142871,1.3571428571428507E-2,4.9285714285714204E-2,2.779789056514596E-2,0.43511420370721526,null,null,null,"2039-12-20",3.5714285714285698E-2,0.67857142857142871,8.0357142857142745E-3,4.3749999999999969E-2,3.1092565902864366E-2,0.48668502461844643,null,null,null,"2039-12-20",3.5714285714285698E-2,0.67857142857142871,2.0357142857142838E-2,5.6071428571428536E-2,2.3934201978479272E-2,0.37463674485758525]
[null,"2040-06-20",3.5714285714285698E-2,0.64285714285714302,{"$f":"+D52*((1+($C$6*(DAYS360(B52,B53)/360))-1))","v":1.2892857142857081E-2},4.8607142857142779E-2,{"$f":"+(F53/((1+$F$8)^((DAYS360($B$20,B53))/360)))","v":2.6918218155205342E-2},{"$f":"+G53*DAYS360($B$20,B53)/360","v":0.43480399603477521},null,null,null,"2040-06-20",3.5714285714285698E-2,{"$f":"+N52-M53","v":0.64285714285714302},{"$f":"+N52*((1+($M$6*(DAYS360(L52,L53)/360))-1))","v":7.6339285714285606E-3},{"$f":"(M53+O53)","v":4.3348214285714261E-2},{"$f":"+(P53/((1+$P$8)^((DAYS360($L$20,L53))/360)))","v":3.047276432058393E-2},{"$f":"+Q53*DAYS360($L$20,L53)/360","v":0.49221979034498764},null,null,null,"2040-06-20",3.5714285714285698E-2,{"$f":"+X52-W53","v":0.64285714285714302},{"$f":"+X52*((1+($W$6*(DAYS360(V52,V53)/360))-1))","v":1.9339285714285698E-2},{"$f":"(W53+Y53)","v":5.5053571428571396E-2},{"$f":"+(Z53/((1+$Z$8)^((DAYS360($V$20,V53))/360)))","v":2.2869290894615306E-2},{"$f":"+AA53*DAYS360($V$20,V53)/360","v":0.36940257375607777}]
[null,"2040-12-20",3.5714285714285698E-2,0.60714285714285732,1.2214285714285657E-2,4.7928571428571355E-2,2.6061303143240774E-2,0.43399308984369012,null,null,null,"2040-12-20",3.5714285714285698E-2,0.60714285714285732,7.2321428571428476E-3,4.2946428571428545E-2,2.9862752164119571E-2,0.49729777562193567,null,null,null,"2040-12-20",3.5714285714285698E-2,0.60714285714285732,1.8321428571428558E-2,5.4035714285714256E-2,2.1844291736519559E-2,0.36376813600120766]
[null,"2041-06-20",3.5714285714285698E-2,0.57142857142857162,1.1535714285714233E-2,4.7249999999999931E-2,2.5226609535878242E-2,0.43270642745568932,null,null,null,"2041-06-20",3.5714285714285698E-2,0.57142857142857162,6.8303571428571337E-3,4.254464285714283E-2,2.9262389967239996E-2,0.50193127235474155,null,null,null,"2041-06-20",3.5714285714285698E-2,0.57142857142857162,1.7303571428571415E-2,5.3017857142857117E-2,2.0857829464184793E-2,0.35776971372594751]
[null,"2041-12-20",3.5714285714285698E-2,0.53571428571428592,1.0857142857142807E-2,4.6571428571428507E-2,2.441361329377471E-2,0.43096809022760629,null,null,null,"2041-12-20",3.5714285714285698E-2,0.53571428571428592,6.4285714285714207E-3,4.2142857142857121E-2,2.8671540137698511E-2,0.50613232659742791,null,null,null,"2041-12-20",3.5714285714285698E-2,0.53571428571428592,1.6285714285714275E-2,5.1999999999999977E-2,1.9908574090115781E-2,0.35144163428523828]
[null,"2042-06-20",3.5714285714285698E-2,0.50000000000000022,1.0178571428571382E-2,4.5892857142857083E-2,2.3621802074358829E-2,0.42880132376648594,null,null,null,"2042-06-20",3.5714285714285698E-2,0.50000000000000022,6.0267857142857068E-3,4.1741071428571405E-2,2.8090066932985842E-2,0.50991274279739573,null,null,null,"2042-06-20",3.5714285714285698E-2,0.50000000000000022,1.5267857142857133E-2,5.098214285714283E-2,1.8995239251674904E-2,0.34481635697137636]
[null,"2042-12-20",3.5714285714285698E-2,0.46428571428571452,9.4999999999999564E-3,4.5214285714285651E-2,2.2850674979970374E-2,0.42622856247361407,null,null,null,"2042-12-20",3.5714285714285698E-2,0.46428571428571452,5.6249999999999937E-3,4.133928571428569E-2,2.7517836436388506E-2,0.51328408797319114,null,null,null,"2042-12-20",3.5714285714285698E-2,0.46428571428571452,1.4249999999999992E-2,4.996428571428569E-2,1.811658082760358E-2,0.33792455627043899]
[null,"2043-06-20",3.5714285714285698E-2,0.42857142857142883,8.8214285714285322E-3,4.4535714285714234E-2,2.2099742311287269E-2,0.42327145343423811,null,null,null,"2043-06-20",3.5714285714285698E-2,0.42857142857142883,5.2232142857142798E-3,4.0937499999999981E-2,2.6954716533348962E-2,0.51625769582622527,null,null,null,"2043-06-20",3.5714285714285698E-2,0.42857142857142883,1.323214285714285E-2,4.894642857142855E-2,1.727139559737666E-2,0.33079520178864463]
[null,"2043-12-20",3.5714285714285698E-2,0.39285714285714313,8.142857142857108E-3,4.3857142857142803E-2,2.1368525325931035E-2,0.41995087966933908,null,null,null,"2043-12-20",3.5714285714285698E-2,0.39285714285714313,4.8214285714285668E-3,4.0535714285714265E-2,2.6400576888123788E-2,0.51884467078743279,null,null,null,"2043-12-20",3.5714285714285698E-2,0.39285714285714313,1.2214285714285709E-2,4.7928571428571404E-2,1.6458519942087461E-2,0.32345563497296886]
[null,"2044-06-20",3.5714285714285698E-2,0.35714285714285743,7.464285714285682E-3,4.3178571428571379E-2,2.0656556002144281E-2,0.41628698276543546,null,null,null,"2044-06-20",3.5714285714285698E-2,0.35714285714285743,4.4196428571428529E-3,4.013392857142855E-2,2.5855288920736259E-2,0.52105589199983771,null,null,null,"2044-06-20",3.5714285714285698E-2,0.35714285714285743,1.1196428571428567E-2,4.6910714285714264E-2,1.5676828585599885E-2,0.31593164274590879]
[null,"2044-12-20",3.5714285714285698E-2,0.32142857142857173,6.7857142857142578E-3,4.2499999999999954E-2,1.9963376807435308E-2,0.41229918489800416,null,null,null,"2044-12-20",3.5714285714285698E-2,0.32142857142857173,4.0178571428571399E-3,3.9732142857142841E-2,2.531872578421963E-2,0.52290201723798035,null,null,null,"2044-12-20",3.5714285714285698E-2,0.32142857142857173,1.0178571428571426E-2,4.5892857142857124E-2,1.4925233374742086E-2,0.3082475281700206]
[null,"2045-06-20",3.5714285714285698E-2,0.28571428571428603,6.1071428571428327E-3,4.182142857142853E-2,1.9288540472087747E-2,0.40800621026374501,null,null,null,"2045-06-20",3.5714285714285698E-2,0.28571428571428603,3.6160714285714264E-3,3.9330357142857125E-2,2.4790762342147502E-2,0.52439348676514785,null,null,null,"2045-06-20",3.5714285714285698E-2,0.28571428571428603,9.1607142857142842E-3,4.4874999999999984E-2,1.4202682097352993E-2,0.30042617825373069]
[null,"2045-12-20",3.5714285714285698E-2,0.25000000000000033,5.4285714285714076E-3,4.1142857142857106E-2,1.8631609767434575E-2,0.40342610593653472,null,null,null,"2045-12-20",3.5714285714285698E-2,0.25000000000000033,3.2142857142857129E-3,3.892857142857141E-2,2.4271275146447866E-2,0.52554052712933641,null,null,null,"2045-12-20",3.5714285714285698E-2,0.25000000000000033,8.1428571428571427E-3,4.3857142857142845E-2,1.3508157337028551E-2,0.29248912900593765]
[null,"2046-06-20",3.5714285714285698E-2,0.21428571428571463,4.7499999999999825E-3,4.0464285714285682E-2,1.7992157288798431E-2,0.39857626216157632,null,null,null,"2046-06-20",3.5714285714285698E-2,0.21428571428571463,2.8124999999999995E-3,3.8526785714285701E-2,2.3760142415497131E-2,0.52635315489886014,null,null,null,"2046-06-20",3.5714285714285698E-2,0.21428571428571463,7.125000000000002E-3,4.2839285714285698E-2,1.2840675363449237E-2,0.28445662784307685]
[null,"2046-12-20",3.5714285714285698E-2,0.17857142857142894,4.0714285714285583E-3,3.9785714285714258E-2,1.7369765243001815E-2,0.39347343210188834,null,null,null,"2046-12-20",3.5714285714285698E-2,0.17857142857142894,2.410714285714286E-3,3.8124999999999985E-2,2.3257244012490751E-2,0.5268411803385058,null,null,null,"2046-12-20",3.5714285714285698E-2,0.17857142857142894,6.1071428571428605E-3,4.1821428571428558E-2,1.2199285057204006E-2,0.27634769344860743]
[null,"2047-06-20",3.5714285714285698E-2,0.14285714285714324,3.3928571428571328E-3,3.9107142857142833E-2,1.6764025240352774E-2,0.38813375105094544,null,null,null,"2047-06-20",3.5714285714285698E-2,0.14285714285714324,2.0089285714285725E-3,3.772321428571427E-2,2.2762461424087103E-2,0.52701421102712775,null,null,null,"2047-06-20",3.5714285714285698E-2,0.14285714285714324,5.0892857142857189E-3,4.0803571428571418E-2,1.1583066868058399E-2,0.26818017318129656]
[null,"2047-12-20",3.5714285714285698E-2,0.10714285714285754,2.7142857142857081E-3,3.8428571428571409E-2,1.6174538091013754E-2,0.38257275512495031,null,null,null,"2047-12-20",3.5714285714285698E-2,0.10714285714285754,1.6071428571428588E-3,3.7321428571428554E-2,2.2275677739321098E-2,0.52688165541755316,null,null,null,"2047-12-20",3.5714285714285698E-2,0.10714285714285754,4.0714285714285783E-3,3.9785714285714278E-2,1.0991131805646195E-2,0.2599707981252149]
[null,"2048-06-20",3.5714285714285698E-2,7.1428571428571841E-2,2.0357142857142831E-3,3.7749999999999978E-2,1.5600913605662989E-2,0.37680539944788805,null,null,null,"2048-06-20",3.5714285714285698E-2,7.1428571428571841E-2,1.2053571428571454E-3,3.6919642857142845E-2,2.1796777628784271E-2,0.52645272633966456,null,null,null,"2048-06-20",3.5714285714285698E-2,7.1428571428571841E-2,3.0535714285714367E-3,3.8767857142857132E-2,{"$f":"+(Z69/((1+$Z$8)^((DAYS360($V$20,V69))/360)))","v":1.042262046159468E-2},0.25173523587101598]
[null,"2048-12-20",3.5714285714285698E-2,3.5714285714286143E-2,1.3571428571428582E-3,3.7071428571428554E-2,1.504277040035973E-2,0.37084607584220169,null,null,null,"2048-12-20",3.5714285714285698E-2,3.5714285714286143E-2,8.0357142857143192E-4,3.651785714285713E-2,2.1325647324068001E-2,0.52573644444750967,null,null,null,"2048-12-20",3.5714285714285698E-2,3.5714285714286143E-2,2.0357142857142952E-3,3.7749999999999992E-2,9.8767020621233423E-3,0.24348814111484629]
[null,"2049-06-20",3.5714285714285698E-2,4.4408920985006262E-16,6.7857142857143333E-4,{"$f":"(C71+E71)","v":3.639285714285713E-2},1.4499735705526392E-2,0.36470863003761522,null,null,null,"2049-06-20",3.5714285714285698E-2,4.4408920985006262E-16,4.0178571428571845E-4,3.6116071428571414E-2,2.0862174597466691E-2,0.52474164161128023,null,null,null,"2049-06-20",3.5714285714285698E-2,4.4408920985006262E-16,1.0178571428571539E-3,3.6732142857142852E-2,{"$f":"+(Z71/((1+$Z$8)^((DAYS360($V$20,V71))/360)))","v":9.3525735501847774E-3},0.23524320415811989]

{"sheet":"I. Calculadora Fondeo UI","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Serie I  (UI) - Calculadora Fondeo"]
[]
[null,"I. Instrumentos Elegibles y Montos"]
[]
[null,null,null,null,null,null,null,null,"Valor","Valor "]
[null,"Codigo Título","Instrumentos","Moneda del Intrumento","Nominal","Precio","Cupón","Devengado cupón corrido","(moneda base)","(UI)"]
[null,{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I US SIII",{"$f":"IFERROR(+VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},2000000,{"$f":"+IFERROR(VLOOKUP($C8,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.89489376879780669},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":3.1E-2},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":8.611111111111111E-4},{"$f":"IFERROR(E8*F8+H8*E8,0)","v":1791509.7598178356},{"$f":"+IFERROR(ROUND(IF(D8=\"USD\",I8*$C$18/$C$19,IF(D8=\"UP\",I8*$C$20/$C$19,I8)),2),\"\")","v":11646560.42}]
[null,{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I UI SI",{"$f":"IFERROR(+VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"UI"},30000000,{"$f":"+IFERROR(VLOOKUP($C9,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.98795240501658543},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":2.75E-2},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":7.6388888888888882E-4},{"$f":"IFERROR(E9*F9+H9*E9,0)","v":29661488.817164231},{"$f":"+IFERROR(ROUND(IF(D9=\"USD\",I9*$C$18/$C$19,IF(D9=\"UP\",I9*$C$20/$C$19,I9)),2),\"\")","v":29661488.82}]
[null,{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I US SIII",{"$f":"IFERROR(+VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},1000000,{"$f":"+IFERROR(VLOOKUP($C10,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.89489376879780669},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":3.1E-2},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":8.611111111111111E-4},895754.87990891782,{"$f":"+IFERROR(ROUND(IF(D10=\"USD\",I10*$C$18/$C$19,IF(D10=\"UP\",I10*$C$20/$C$19,I10)),2),\"\")","v":5823280.21}]
[null,{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C11,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C12,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C13,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C14,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,null,"Total",null,null,null,null,null,null,{"$f":"SUM(J8:J14)","v":47131329.450000003},{"$f":"+IF(J15>'I. Calculadora - Oferta'!C16,\"SobreOfertado el monto\",IF(J15<'I. Calculadora - Oferta'!C16,\"Diferecia debe cubrirse con Efectivo\",\"Caje total en Títulos\"))","v":"SobreOfertado el monto"}]
[]
[null,"Cotizaciones"]
[null,"UYP/USD",39,"valor de cierre del 15/4/2024"]
[null,"UI",5.9991000000000003,"Valor del 25/4/24"]
[null,"UP",1.6019699999999999,"Valor del 25/4/24"]
[]
[]
[]
[null,"II. Efectivo y Total Oferta",null,null,null,null,null,null,null,null,"Monto a transferir en Pesos"]
[]
[null,"Monto en efectivo (UI)",{"$f":"IF(J30-J15<0,0,J30-J15)","v":0},null,null,null,null,null,null,{"$f":"C26","v":0},{"$f":"+J26*C19","v":0}]
[null,"Total Oferta",null,null,null,null,null,null,null,{"$f":"J26+J15","v":47131329.450000003}]
[null,null,null,null,null,null,null,"% Efectivo",null,{"$f":"J26/J27","v":0},{"$f":"+IF(J28<10%,\"Cumple\",\"No cumple\")","v":"Cumple"}]
[null,null,null,null,null,null,null,"% Efectivo (ROUND)",null,{"$f":"ROUND(J28*100,0)","v":0}]
[null,null,null,null,null,null,null,"Monto a fondear     ==========>",null,{"$f":"'I. Calculadora - Oferta'!C16","v":40553111.111111112}]
[null,null,null,null,null,null,null,null,"Check",{"$f":"J30-J27","v":-6578218.338888891}]
[]
[null,null,"Ingreso de oferta texto adicional:",{"$f":"+CONCATENATE(\"T\",ROUND(J15/J27,2)*100,\",\",\"E\",J29)","v":"T100,E0"}]

{"sheet":"II. Calculadora Fondeo UP","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Serie II  (UP) - Calculadora Fondeo"]
[]
[null,"I. Instrumentos Elegibles y Montos"]
[]
[null,null,null,null,null,null,null,null,"Valor","Valor "]
[null,"Codigo Título","Instrumentos","Moneda del Intrumento","Nominal","Precio","Cupón","Devengado cupón corrido","(moneda base)","(UP)"]
[null,{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I US S6",{"$f":"IFERROR(+VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},400000,{"$f":"+IFERROR(VLOOKUP($C8,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.93602749333692759},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":4.4999999999999998E-2},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":1.2499999999999998E-3},{"$f":"IFERROR(E8*F8+H8*E8,0)","v":374910.99733477103},{"$f":"+IFERROR(ROUND(IF(D8=\"USD\",I8*$C$18/$C$20,IF(D8=\"UI\",I8*$C$19/$C$20,I8)),2),\"\")","v":9127217.6699999999}]
[null,{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I USD",{"$f":"IFERROR(+VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},1500000,{"$f":"+IFERROR(VLOOKUP($C9,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.95936009220806651},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":4.9000000000000002E-2},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":1.3611111111111111E-3},{"$f":"IFERROR(E9*F9+H9*E9,0)","v":1441081.8049787665},{"$f":"+IFERROR(ROUND(IF(D9=\"USD\",I9*$C$18/$C$20,IF(D9=\"UI\",I9*$C$19/$C$20,I9)),2),\"\")","v":35083172.840000004}]
[null,{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C10,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C11,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C12,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C13,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C14,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,null,"Total",null,null,null,null,null,null,{"$f":"SUM(J8:J14)","v":44210390.510000005},{"$f":"+IF(I14>'I. Calculadora - Oferta'!M16,\"SobreOfertado el monto\",IF(I14<'I. Calculadora - Oferta'!M16,\"Diferecia debe cubrirse con Efectivo\",\"Caje total en Títulos\"))","v":"Diferecia debe cubrirse con Efectivo"}]
[]
[null,"Cotizaciones"]
[null,"UYP/USD",{"$f":"+'I. Calculadora Fondeo UI'!C18","v":39},"valor de cierre del 15/4/2024"]
[null,"UI",{"$f":"+'I. Calculadora Fondeo UI'!C19","v":5.9991000000000003},"Valor del 25/4/24"]
[null,"UP",{"$f":"+'I. Calculadora Fondeo UI'!C20","v":1.6019699999999999},"Valor del 25/4/24"]
[]
[]
[]
[null,"II. Efectivo y Total Oferta",null,null,null,null,null,null,null,null,"Monto a transferir en Pesos"]
[]
[null,null,"Monto en efectivo (UP)",{"$f":"IF(J30-J15<0,0,J30-J15)","v":0},null,null,null,null,null,{"$f":"D26","v":0},{"$f":"+J26*C20","v":0}]
[null,null,null,null,null,null,null,"Total Oferta",null,{"$f":"J26+J15","v":44210390.510000005}]
[null,null,null,null,null,null,null,"% Efectivo",null,{"$f":"J26/J27","v":0},{"$f":"+IF(J28<10%,\"Cumple\",\"No cumple\")","v":"Cumple"}]
[null,null,null,null,null,null,null,"% Efectivo (ROUND)",null,{"$f":"ROUND(J28*100,0)","v":0}]
[null,null,null,null,null,null,null,"Monto a fondear     ==========>",null,{"$f":"+'I. Calculadora - Oferta'!M16","v":15122812.5}]
[null,null,null,null,null,null,null,null,"Check",{"$f":"J30-J27","v":-29087578.010000005}]
[]
[null,null,"Ingreso de oferta texto adicional:",{"$f":"+CONCATENATE(\"T\",ROUND(J15/J27,2)*100,\",\",\"E\",J29)","v":"T100,E0"}]

{"sheet":"III. Calculadora Fondeo USD","index":3,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Serie III  (USD) - Calculadora Fondeo"]
[]
[null,"I. Instrumentos Elegibles y Montos"]
[]
[null,null,null,null,null,null,null,null,"Valor","Valor "]
[null,"Codigo Título","Instrumentos","Moneda del Intrumento","Nominal","Precio","Cupón","Devengado cupón corrido","(moneda base)","(USD)"]
[null,{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I USD",{"$f":"IFERROR(+VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},750000,{"$f":"+IFERROR(VLOOKUP($C8,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.95936009220806651},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":4.9000000000000002E-2},{"$f":"+IFERROR(VLOOKUP(C8,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":1.3611111111111111E-3},{"$f":"IFERROR(E8*F8+H8*E8,0)","v":720540.90248938324},{"$f":"+IFERROR(ROUND(IF(D8=\"UP\",I8*$C$20/$C$18,IF(D8=\"UI\",I8*$C$19/$C$18,I8)),2),\"\")","v":720540.9}]
[null,{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I US S4",{"$f":"IFERROR(+VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},2000000,{"$f":"+IFERROR(VLOOKUP($C9,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.95935991704244206},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":4.9000000000000002E-2},{"$f":"+IFERROR(VLOOKUP(C9,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":1.3611111111111111E-3},{"$f":"IFERROR(E9*F9+H9*E9,0)","v":1921442.0563071063},{"$f":"+IFERROR(ROUND(IF(D9=\"UP\",I9*$C$20/$C$18,IF(D9=\"UI\",I9*$C$19/$C$18,I9)),2),\"\")","v":1921442.06}]
[null,{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":"T"},"FF CORPORACION VIAL DEL URUGUAY I US S6",{"$f":"IFERROR(+VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":"USD"},null,{"$f":"+IFERROR(VLOOKUP($C10,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":0.93602749333692759},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":4.4999999999999998E-2},{"$f":"+IFERROR(VLOOKUP(C10,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":1.2499999999999998E-3},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C11,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C11,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C12,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C12,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C13,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C13,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$B$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(+VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,6,FALSE),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP($C14,'Títulos Elegibles'!$A$3:$H$9,8,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$G$9,7,FALSE),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(C14,'Títulos Elegibles'!$A$3:$I$9,9,FALSE),\"\")","v":""},0,0]
[null,null,"Total",null,null,null,null,null,null,{"$f":"SUM(J8:J14)","v":2641982.96},{"$f":"+IF(I14>'I. Calculadora - Oferta'!M16,\"SobreOfertado el monto\",IF(I14<'I. Calculadora - Oferta'!M16,\"Diferecia debe cubrirse con Efectivo\",\"Caje total en Títulos\"))","v":"Diferecia debe cubrirse con Efectivo"}]
[]
[null,"Cotizaciones"]
[null,"UYP/USD",{"$f":"+'I. Calculadora Fondeo UI'!C18","v":39},"valor de cierre del 15/4/2024"]
[null,"UI",{"$f":"+'I. Calculadora Fondeo UI'!C19","v":5.9991000000000003},"Valor del 25/4/24",null,null,null,null,null,{"$f":"+J27*0.98","v":2589143.3007999999}]
[null,"UP",{"$f":"+'I. Calculadora Fondeo UI'!C20","v":1.6019699999999999},"Valor del 25/4/24",null,null,null,null,null,{"$f":"+J27*0.02","v":52839.659200000002}]
[]
[]
[]
[null,"II. Efectivo y Total Oferta",null,null,null,null,null,null,null,null,"Monto a transferir en Dólares"]
[]
[null,null,"Monto en efectivo (USD)",{"$f":"IF(J30-J15<0,0,J30-J15)","v":0},null,null,null,null,null,{"$f":"D26","v":0},{"$f":"+J26","v":0}]
[null,null,null,null,null,null,null,"Total Oferta",null,{"$f":"J26+J15","v":2641982.96}]
[null,null,null,null,null,null,null,"% Efectivo",null,{"$f":"J26/J27","v":0},{"$f":"+IF(J28<10%,\"Cumple\",\"No cumple\")","v":"Cumple"}]
[null,null,null,null,null,null,null,"% Efectivo (ROUND)",null,{"$f":"ROUND(J28*100,0)","v":0}]
[null,null,null,null,null,null,null,"Monto a fondear     ==========>",null,{"$f":"+'I. Calculadora - Oferta'!W16","v":1020741.6666666666}]
[null,null,null,null,null,null,null,null,"Check",{"$f":"J30-J27","v":-1621241.2933333335}]
[]
[null,null,"Ingreso de oferta texto adicional:",{"$f":"+CONCATENATE(\"T\",ROUND(J15/J27,2)*100,\",\",\"E\",J29)","v":"T100,E0"}]

{"sheet":"Títulos Elegibles","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["NOMBRE ISIN","Codigo Título","ISIN","Fecha de Emisión","Último Pago de Cupón","Moneda","Cupón","Precio*","Devengado"]
["FF CORPORACION VIAL DEL URUGUAY I USD","T","UYFFRA083US1","2017-04-26","2024-04-15","USD",4.9000000000000002E-2,0.95936009220806651,{"$f":"+DAYS360(E3,\"25/04/2024\")/360*G3","v":1.3611111111111111E-3}]
["FF CORPORACION VIAL DEL URUGUAY I US S4","T","UYFFCA101US8","2018-04-30","2024-04-15","USD",4.9000000000000002E-2,0.95935991704244206,{"$f":"+DAYS360(E4,\"25/04/2024\")/360*G4","v":1.3611111111111111E-3}]
["FF CORPORACION VIAL DEL URUGUAY I US S6","T","UYFFCN121US1","2019-05-03","2024-04-15","USD",4.4999999999999998E-2,0.93602749333692759,1.2499999999999998E-3]
["FF CORPORACION VIAL DEL URUGUAY I UI SI","T","UYFFCN150UI1","2021-06-24","2024-04-15","UI",2.75E-2,0.98795240501658543,7.6388888888888882E-4]
["FF CORPORACION VIAL DEL URUGUAY I UP SII","T","UYFFCN151UP4","2021-06-24","2024-04-15","UP",0.02,1.0116774337737251,5.5555555555555556E-4]
["FF CORPORACION VIAL DEL URUGUAY I US SIII","T","UYFFCN152US6","2021-06-24","2024-04-15","USD",3.1E-2,0.89489376879780669,8.611111111111111E-4]
["Fideicomiso de Oferta Privada CVU II serie I","T","-","2023-07-20","2024-04-01","UP",2.2700000000000001E-2,1.0098,1.5133333333333333E-3]
[]
[null,null,null,null,null,null,null,"* precio fijado por el emisor, comunicado al mercado el 15/4/2024"]
["EFECTIVO","E"]