{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TFBD_US$_SAC","Taxa Flat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":18,"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":"TFBD_US$_SAC","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[13,5,16,5],[4,0,4,8],[12,0,16,0],[12,2,16,2],[12,3,12,5],[12,6,12,7],[12,8,16,8],[13,3,16,3],[13,4,16,4],[7,0,7,1],[12,1,16,1],[12,9,12,11],[13,9,16,9],[13,10,16,10],[13,11,16,11],[13,6,16,6],[13,7,16,7]]}
[]
[]
[]
[]
["MODELO - Deve ser adaptado utilizando os valores, taxas e prazos do contrato"]
[]
[]
["Liberação"]
["Data","Valor (US$)"]
["2023-08-25",100000]
[]
["Valores em US$ (604)"]
["Data de Vencimento","Data de Pagamento","Principal","Juros Compensatórios (1)",null,null,"Amortização (2)",null,"Prestação","Outros Eventos"]
[null,null,null,"Taxa \n% a.a.","Dias ","Valor","nº de parcelas\nrestantes","Valor",null,"Taxa Flat\n(3)","Remuneração\n(4)","Total \nOutros Eventos"]
[]
[]
[]
["2023-09-15",{"$f":"A18","v":"2023-09-15"},{"$f":"round_to_even((B10),2)","v":100000},4.8399999999999999E-2,{"$f":"A18-A10","v":21},{"$f":"round_to_even(C18*ROUND(D18*E18/360,15),2)","v":282.33},16,{"$f":"round_to_even(C18/G18,2)","v":6250},{"$f":"H18+F18","v":6532.33},{"$f":"round_to_even(B10*0.024246%,2)","v":24.25},{"$f":"round_to_even(J18*ROUND(D18*(A18-A10)/360,15),2)","v":7.0000000000000007E-2},{"$f":"SUM(J18:K18)","v":24.32},null,null,null,null,{"$f":"MOD(O18,20)","v":0}]
["2023-10-16",{"$f":"A19","v":"2023-10-16"},{"$f":"round_to_even((C18-H18),2)","v":93750},{"$f":"D18","v":4.8399999999999999E-2},{"$f":"A19-A18","v":31},{"$f":"round_to_even(C19*ROUND(D19*E19/360,15),2)","v":390.73},{"$f":"G18-1","v":15},{"$f":"round_to_even(C19/G19,2)","v":6250},{"$f":"H19+F19","v":6640.73},null,null,null,null,null,null,null,{"$f":"MOD(O19,20)","v":0}]
["2023-11-16",{"$f":"A20","v":"2023-11-16"},{"$f":"round_to_even((C19-H19),2)","v":87500},{"$f":"D19","v":4.8399999999999999E-2},{"$f":"A20-A19","v":31},{"$f":"round_to_even(C20*ROUND(D20*E20/360,15),2)","v":364.68},{"$f":"G19-1","v":14},{"$f":"round_to_even(C20/G20,2)","v":6250},{"$f":"H20+F20","v":6614.68}]
["2023-12-15","2023-12-15",{"$f":"round_to_even((C20-H20),2)","v":81250},4.8399999999999999E-2,29,{"$f":"round_to_even(C21*ROUND(D21*E21/360,15),2)","v":316.77999999999997},13,{"$f":"round_to_even(C21/G21,2)","v":6250},6566.78]
["2024-01-15","2024-01-15",{"$f":"round_to_even((C21-H21),2)","v":75000},4.8399999999999999E-2,31,{"$f":"round_to_even(C22*ROUND(D22*E22/360,15),2)","v":312.58},12,{"$f":"round_to_even(C22/G22,2)","v":6250},6562.58]
["2024-02-15","2024-02-15",{"$f":"round_to_even((C22-H22),2)","v":68750},4.8399999999999999E-2,31,{"$f":"round_to_even(C23*ROUND(D23*E23/360,15),2)","v":286.52999999999997},11,{"$f":"round_to_even(C23/G23,2)","v":6250},6536.53]
["2024-03-15","2024-03-15",{"$f":"round_to_even((C23-H23),2)","v":62500},4.8399999999999999E-2,29,{"$f":"round_to_even(C24*ROUND(D24*E24/360,15),2)","v":243.68},10,{"$f":"round_to_even(C24/G24,2)","v":6250},6493.68]
["2024-04-15","2024-04-15",{"$f":"round_to_even((C24-H24),2)","v":56250},4.8399999999999999E-2,31,{"$f":"round_to_even(C25*ROUND(D25*E25/360,15),2)","v":234.44},9,{"$f":"round_to_even(C25/G25,2)","v":6250},6484.44]
["2024-05-15","2024-05-15",{"$f":"round_to_even((C25-H25),2)","v":50000},4.8399999999999999E-2,30,{"$f":"round_to_even(C26*ROUND(D26*E26/360,15),2)","v":201.67},8,{"$f":"round_to_even(C26/G26,2)","v":6250},6451.67]
["2024-06-17","2024-06-17",{"$f":"round_to_even((C26-H26),2)","v":43750},4.8399999999999999E-2,33,{"$f":"round_to_even(C27*ROUND(D27*E27/360,15),2)","v":194.1},7,{"$f":"round_to_even(C27/G27,2)","v":6250},6444.1]
["2024-07-15","2024-07-15",{"$f":"round_to_even((C27-H27),2)","v":37500},4.8399999999999999E-2,28,{"$f":"round_to_even(C28*ROUND(D28*E28/360,15),2)","v":141.16999999999999},6,{"$f":"round_to_even(C28/G28,2)","v":6250},6391.17]
["2024-08-15","2024-08-15",{"$f":"round_to_even((C28-H28),2)","v":31250},4.8399999999999999E-2,31,{"$f":"round_to_even(C29*ROUND(D29*E29/360,15),2)","v":130.24},5,{"$f":"round_to_even(C29/G29,2)","v":6250},6380.24]
["2024-09-16","2024-09-16",{"$f":"round_to_even((C29-H29),2)","v":25000},4.8399999999999999E-2,32,{"$f":"round_to_even(C30*ROUND(D30*E30/360,15),2)","v":107.56},4,{"$f":"round_to_even(C30/G30,2)","v":6250},6357.56]
["2024-10-15","2024-10-15",{"$f":"round_to_even((C30-H30),2)","v":18750},4.8399999999999999E-2,29,{"$f":"round_to_even(C31*ROUND(D31*E31/360,15),2)","v":73.099999999999994},3,{"$f":"round_to_even(C31/G31,2)","v":6250},6323.1]
["2024-11-18","2024-11-18",{"$f":"round_to_even((C31-H31),2)","v":12500},4.8399999999999999E-2,34,{"$f":"round_to_even(C32*ROUND(D32*E32/360,15),2)","v":57.14},2,{"$f":"round_to_even(C32/G32,2)","v":6250},6307.14]
["2024-12-16","2024-12-16",{"$f":"round_to_even((C32-H32),2)","v":6250},4.8399999999999999E-2,28,{"$f":"round_to_even(C33*ROUND(D33*E33/360,15),2)","v":23.53},1,{"$f":"round_to_even(C33/G33,2)","v":6250},6273.53]
[]
["Obs.: A cotação do US$ (604) está disponível em Moedas Contratuais, no site do BNDES."]
[]
["FÓRMULAS DE CÁLCULO"]
[]
["(1) Juros Compensatórios",null,null,null,null,null,"(3) Taxa Flat (com arredondamento bancário em 2 casas decimais)"]
[]
["arredondamento em 15 casas decimais",null,null,null,null,null,"= Liberação x 0,024246%"]
[null,null,null,null,null,null,"ou, quando aplicável,"]
["= (Principal x Fator de Juros) ",null,null,null,null,null,"= (Liberação - Devolução de Liberação) x 0,024246%"]
[]
["arredondamento bancário em 2 casas decimais",null,null,null,null,null,"(4) Remuneração "]
[null,null,null,null,null,null,"arredondamento em 15 casas decimais"]
["Fator de Juros"]
["= Taxa % a.a. x Dias / 360",null,null,null,null,null,"= (Base de Cálculo x Fator de Remuneração) "]
[]
["(2) Amortização (com arredondamento bancário em 2 casas decimais)",null,null,null,null,null,"arredondamento bancário em 2 casas decimais"]
[]
["= Principal / nº de Parcelas Restantes",null,null,null,null,null,"Fator de Remuneração"]
[null,null,null,null,null,null,"= Taxa % a.a. x Dias / 360 "]

{"sheet":"Taxa Flat","index":1,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["% TAXA FLAT",2.4246000000000001E-4]
[]
["A atualização da Taxa Flat é calculada pela taxa contratual e variação cambial, desde o dia da Liberação (inclusive) até o dia do efetivo pagamento (exclusive)."]
[]
["Valores em US$ (604)"]
["DATA DE VENCIMENTO","DATA DE PAGAMENTO","EVENTO","VALOR"]
[{"$f":"'TFBD_US$_SAC'!A10","v":"2023-08-25"},{"$f":"A7","v":"2023-08-25"},"LIBERACAO",{"$f":"'TFBD_US$_SAC'!B10","v":100000}]
[{"$f":"'TFBD_US$_SAC'!A18","v":"2023-09-15"},{"$f":"'TFBD_US$_SAC'!B18","v":"2023-09-15"},"TAXA FLAT",{"$f":"round_to_even(D7*$B$1,2)","v":24.25}]
[{"$f":"A8","v":"2023-09-15"},{"$f":"B8","v":"2023-09-15"},"REMUNERAÇÃO",{"$f":"round_to_even(D8*ROUND('TFBD_US$_SAC'!D18*(A8-A7)/360,15),2)","v":7.0000000000000007E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*","https://www.bcb.gov.br/estabilidadefinanceira/selicdadosdiarios"]