{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Modelo TR Derivada","Taxa Flat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"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":"Modelo TR Derivada","index":0,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[13,14,13,16],[14,14,16,14],[14,15,16,15],[14,16,16,16],[4,0,4,10],[7,0,7,1],[13,0,16,0],[13,1,13,5],[13,6,16,6],[13,7,16,7],[13,8,13,10],[14,10,16,10],[13,11,16,11],[13,12,16,12],[13,13,16,13],[14,1,16,1],[14,2,16,2],[14,3,16,3],[14,4,16,4],[14,5,16,5],[14,8,16,8],[14,9,16,9]]}
[]
[]
[]
[]
["MODELO - Deve ser adaptado utilizando os valores, taxas e prazos do contrato"]
[]
["Valores em R$"]
["Liberação"]
["Data","Valor (R$)"]
["2025-08-08",20000000]
[]
[]
["Valores em R$"]
["Data de Vencimento","TR",null,null,null,null,"Índice de\nAtualização","Principal Atualizado","Juros Compensatórios (1)",null,null,"Parcelas Restantes","Amortização (2)","Prestação","Outros Eventos"]
[null,"Data ref.","% a.m. *","Data início ","Data fim","dias corridos no mês",null,null,"Spread BNDES \n% a.a.","Dias","Juros Compensatórios",null,null,null,"Taxa Flat\n(3)","Remuneração\n(4)","Total \nOutros Eventos"]
[]
[]
["2025-09-01","2025-07-01",0.17580000000000001,"2025-08-01","2025-09-01",{"$f":"E18-D18","v":31},{"$f":"ROUND((1+C18%)^((A18-A10)/F18),15)","v":1.00136076230897},{"$f":"round_to_even(B10*G18,15)","v":20027215.246179398},2.7,{"$f":"A18-A10","v":24},{"$f":"round_to_even((B10)*ROUND(G18*((1+$I18%)^(J18/365)),15)-H18,15)","v":35114.387283802003}]
["2025-09-15","2025-08-01",0.17219999999999999,{"$f":"E18","v":"2025-09-01"},"2025-10-01",{"$f":"E19-D19","v":30},{"$f":"ROUND((1+C19%)^((A19-A18)/F19),15)","v":1.00080323131131},{"$f":"round_to_even((H18-M18)*ROUND(G19,15),2)","v":20043301.73},{"$f":"I18","v":2.7},{"$f":"A19-A18","v":14},{"$f":"round_to_even((H18-M18+K18)*ROUND(G19*((1+$I19%)^(J19/365)),15)-H19,2)","v":55670.89},null,null,null,{"$f":"'Taxa Flat'!D7","v":4849.2},{"$f":"'Taxa Flat'!D8","v":69.989999999999782},{"$f":"O19+P19","v":4919.1899999999996}]
["2025-10-01","2025-08-01",{"$f":"C19","v":0.17219999999999999},"2025-09-01","2025-10-01",{"$f":"E20-D20","v":30},1.0009180312972099,{"$f":"round_to_even((H19-M19)*ROUND(G20,15),2)","v":20061702.109999999},2.7,16,{"$f":"round_to_even((H19-M19+K19)*ROUND(G20*((1+$I20%)^(J20/365)),15)-H20,2)","v":79230.17}]
["2025-10-15","2025-09-01",0.17419999999999999,{"$f":"E20","v":"2025-10-01"},"2025-11-01",{"$f":"E21-D21","v":31},{"$f":"ROUND((1+C21%)^((A21-A20)/F21),15)","v":1.0007863342468299},{"$f":"round_to_even((H20-M20)*ROUND(G21,15),2)","v":20077477.309999999},2.7,14,{"$f":"round_to_even((H20-M20+K20)*ROUND(G21*((1+$I21%)^(J21/365)),15)-H21,2)","v":99900.85}]
["2025-11-01","2025-09-01",{"$f":"C21","v":0.17419999999999999},"2025-10-01","2025-11-01",{"$f":"E22-D22","v":31},1.00095491487091,{"$f":"round_to_even((H21-M21)*ROUND(G22,15),2)","v":20096649.59},2.7,17,{"$f":"round_to_even((H21-M21+K21)*ROUND(G22*((1+$I22%)^(J22/365)),15)-H22,2)","v":125072.95}]
["2025-11-17","2025-10-01",0.17580000000000001,{"$f":"E22","v":"2025-11-01"},"2025-12-01",{"$f":"E23-D23","v":30},1.00093721572668,{"$f":"round_to_even((H22-M22)*ROUND(G23,15),2)","v":20115484.489999998},2.7,{"$f":"A23-A22","v":16},{"$f":"round_to_even((H22-M22+K22)*ROUND(G23*((1+$I23%)^(J23/365)),15)-H23,2)","v":148842.35999999999},null,null,{"$f":"K23+M23","v":148842.35999999999}]
["2025-12-01","2025-10-01",{"$f":"C23","v":0.17580000000000001},"2025-11-01","2025-12-01",{"$f":"E24-D24","v":30},1.00082001574167,{"$f":"round_to_even(H23*G24,15)","v":20131979.503933098},2.7,14,{"$f":"round_to_even((H23)*ROUND(G24*((1+$I24%)^(J24/365)),15)-H24,15)","v":20583.028098993}]
["2025-12-15","2025-11-01",0.16339999999999999,{"$f":"E24","v":"2025-12-01"},"2026-01-01",{"$f":"E25-D25","v":31},1.00073760514351,{"$f":"round_to_even((H24-M24)*ROUND(G25,15),2)","v":20146828.960000001},2.7,14,{"$f":"round_to_even((H24-M24+K24)*ROUND(G25*((1+$I25%)^(J25/365)),15)-H25,2)","v":41217.480000000003}]
["2026-01-01","2025-11-01",{"$f":"C25","v":0.16339999999999999},"2025-12-01","2026-01-01",{"$f":"E26-D26","v":31},{"$f":"ROUND((1+C26%)^((A26-A25)/F26),15)","v":1.00089573415837},{"$f":"round_to_even((H25-M25)*ROUND(G26,15),2)","v":20164875.16},2.7,17,{"$f":"round_to_even((H25-M25+K25)*ROUND(G26*((1+$I26%)^(J26/365)),15)-H26,2)","v":66342.880000000005}]
["2026-01-15","2025-12-01",0.17419999999999999,"2026-01-01","2026-02-01",{"$f":"E27-D27","v":31},1.0007863342468299,{"$f":"round_to_even((H26-M26)*ROUND(G27,15),2)","v":20180731.489999998},2.7,14,{"$f":"round_to_even((H26-M26+K26)*ROUND(G27*((1+$I27%)^(J27/366)),15)-H27,2)","v":87039.22}]
["2026-02-01","2025-12-01",{"$f":"C27","v":0.17419999999999999},"2026-01-01","2026-02-01",{"$f":"E28-D28","v":31},1.00095491487091,{"$f":"round_to_even((H27-M27)*ROUND(G28,15),2)","v":20200002.370000001},2.7,17,{"$f":"round_to_even((H27-M27+K27)*ROUND(G28*((1+$I28%)^(J28/366)),15)-H28,2)","v":112242.52}]
["2026-02-18","2026-01-01",0.17180000000000001,{"$f":"E28","v":"2026-02-01"},"2026-03-01",{"$f":"E29-D29","v":28},1.0010427197097,{"$f":"round_to_even((H28-M28)*ROUND(G29,15),2)","v":20221065.309999999},2.7,{"$f":"A29-A28","v":17},{"$f":"round_to_even((H28-M28+K28)*ROUND(G29*((1+$I29%)^(J29/366)),15)-H29,2)","v":137537.07},10,{"$f":"round_to_even(H29/L29,2)","v":2022106.53},{"$f":"K29+M29","v":2159643.6}]
["continua..."]
[]
["* Disponível em Moedas Contratuais, no site do BNDES, cód TR (Cód: 200). Se a taxa vigente para o período de cálculo ainda não tiver sido divulgada, o sistema projeta utilizando a última disponível."]
[]
["FÓRMULAS DE CÁLCULO"]
[]
["(1) Juros Compensatórios"]
[]
[null,"arredondamento em 15 casas decimais",null,"arredondamento em 15 casas decimais"]
[]
["= (Principal Anterior x Índice de Atualização x Fator de Atualização) - Principal Atualizado "]
[]
[null,null,"arredondamento bancário em 2 casas decimais"]
[]
["Índide de Atualização",null,null,"Fator de Atualização"]
["= (1 + TR a.m.)Dias/Dias no mês",null,null,"= (1 + Taxa % a.a.)Dias/(365 ou 366)"]
[]
["(2) Amortização (com arredondamento bancário em 2 casas decimais)"]
[]
["= Principal Atualizado / nº de Parcelas Restantes"]
[]
["(3) Taxa Flat (com arredondamento bancário em 2 casas decimais)"]
[]
["= Liberação x 0,024246%"]
["ou, quando aplicável,"]
["= (Liberação - Devolução de Liberação) x 0,024246%"]
[]
["(4) Remuneração "]
["arredondamento em 15 casas decimais"]
[]
["= (Base de Cálculo x Fator de Remuneração) - Base de Cálculo "]
[]
["arredondamento bancário em 2 casas decimais"]
[]
["Fator de Remuneração"]
["= Produtório dos Fatores Diários SELIC apurados desde a data inicial (inclusive)  "]
["até o dia do efetivo pagamento (exclusive)"]
["Fator Diário Selic "]
["= (1+ Selic % a.a.)1/252 "]
[]
["arredondamento em 8 casas decimais"]

{"sheet":"Taxa Flat","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["% TAXA FLAT",2.4246000000000001E-4]
[]
["A atualização da Taxa Flat é calculada pelo Fator SELIC, desde o dia da Liberação (inclusive) até o dia do efetivo pagamento (exclusive)."]
[]
["DATA DE VENCIMENTO","DATA DE PAGAMENTO","EVENTO","VALOR",null,"Data","Fator Diário SELIC *"]
[{"$f":"'Modelo TR Derivada'!A10","v":"2025-08-08"},{"$f":"A6","v":"2025-08-08"},"LIBERACAO",{"$f":"'Modelo TR Derivada'!B10","v":20000000},null,"2025-08-08",1.0005513100000001]
[{"$f":"'Modelo TR Derivada'!A19","v":"2025-09-15"},{"$f":"A7","v":"2025-09-15"},"TAXA FLAT",{"$f":"round_to_even(D6*$B$1,2)","v":4849.2},null,"2025-08-11",1.0005513100000001]
[{"$f":"A7","v":"2025-09-15"},{"$f":"A7","v":"2025-09-15"},"REMUNERAÇÃO",{"$f":"round_to_even(D7*ROUND(PRODUCT(G6:G31),15),2)-D7","v":69.989999999999782},null,"2025-08-12",1.0005513100000001]
[null,null,null,null,null,"2025-08-13",1.0005513100000001]
[null,null,null,null,null,"2025-08-14",1.0005513100000001]
[null,null,null,null,null,"2025-08-15",1.0005513100000001]
[null,null,null,null,null,"2025-08-18",1.0005513100000001]
[null,null,null,null,null,"2025-08-19",1.0005513100000001]
[null,null,null,null,null,"2025-08-20",1.0005513100000001]
[null,null,null,null,null,"2025-08-21",1.0005513100000001]
[null,null,null,null,null,"2025-08-22",1.0005513100000001]
[null,null,null,null,null,"2025-08-25",1.0005513100000001]
[null,null,null,null,null,"2025-08-26",1.0005513100000001]
[null,null,null,null,null,"2025-08-27",1.0005513100000001]
[null,null,null,null,null,"2025-08-28",1.0005513100000001]
[null,null,null,null,null,"2025-08-29",1.0005513100000001]
[null,null,null,null,null,"2025-09-01",1.0005513100000001]
[null,null,null,null,null,"2025-09-02",1.0005513100000001]
[null,null,null,null,null,"2025-09-03",1.0005513100000001]
[null,null,null,null,null,"2025-09-04",1.0005513100000001]
[null,null,null,null,null,"2025-09-05",1.0005513100000001]
[null,null,null,null,null,"2025-09-08",1.0005513100000001]
[null,null,null,null,null,"2025-09-09",1.0005513100000001]
[null,null,null,null,null,"2025-09-10",1.0005513100000001]
[null,null,null,null,null,"2025-09-11",1.0005513100000001]
[null,null,null,null,null,"2025-09-12",1.0005513100000001]
[null,null,null,null,null,"2025-09-15",1.0005513100000001]
[]
["*","https://www.bcb.gov.br/estabilidadefinanceira/selicdadosdiarios"]