{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Taxa Composta_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":"Taxa Composta_SAC","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[12,9,12,11],[13,9,16,9],[13,10,16,10],[13,11,16,11],[13,6,16,6],[13,7,16,7],[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]]}
[]
[]
[]
[]
["MODELO - Deve ser adaptado utilizando os valores, taxas e prazos do contrato"]
[]
[]
["Liberação"]
["Data","Valor (R$)"]
["2023-10-02",1234567.8899999999]
[]
["Valores em R$"]
["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-10-10",null,{"$f":"round_to_even((B10),2)","v":1234567.8899999999},4.5499999999999999E-2,{"$f":"A18-A10","v":8},{"$f":"round_to_even(C18*ROUND((1+D18)^(E18/365),15),2)-C18","v":1204.5800000000745},null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(O18,20)","v":0}]
["2023-11-10",{"$f":"A19","v":"2023-11-10"},{"$f":"round_to_even((C18-H18),2)","v":1234567.8899999999},{"$f":"D18","v":4.5499999999999999E-2},{"$f":"A19-A18","v":31},{"$f":"round_to_even((C19+F18)*ROUND((1+D19)^(E19/365),15),2)-C19","v":5883.4600000001956},10,{"$f":"round_to_even(C19/G19,2)","v":123456.79},{"$f":"H19+F19","v":129340.25000000019},null,null,null,null,null,null,null,{"$f":"MOD(O19,20)","v":0}]
["2023-11-16",{"$f":"A20","v":"2023-11-16"},null,null,null,null,null,null,null,{"$f":"'Taxa Flat'!D7","v":299.33},{"$f":"'Taxa Flat'!D8","v":4.2300000000000182},{"$f":"J20+K20","v":303.56}]
["2023-12-11",{"$f":"A21","v":"2023-12-11"},{"$f":"round_to_even((C19-H19),2)","v":1111111.1000000001},{"$f":"D19","v":4.5499999999999999E-2},{"$f":"A21-A19","v":31},{"$f":"round_to_even(C21*ROUND((1+D21)^(E21/365),15),2)-C21","v":4206.8899999998976},{"$f":"G19-1","v":9},{"$f":"round_to_even(C21/G21,2)","v":123456.79},{"$f":"H21+F21","v":127663.67999999989},null,null,null,null,null,null,null,{"$f":"MOD(O21,20)","v":0}]
["2024-01-01","ano 366 dias",{"$f":"round_to_even((C21-H21),2)","v":987654.31},4.5499999999999999E-2,{"$f":"A22-A21","v":21},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(O22,20)","v":0}]
["2024-01-10",{"$f":"A23","v":"2024-01-10"},{"$f":"round_to_even((C22-H22),2)","v":987654.31},4.5499999999999999E-2,{"$f":"A23-A22","v":9},{"$f":"round_to_even(C23*ROUND((1+D23)^(E22/365)*(1+D23)^(E23/366),15),2)-C23","v":3615.6299999998882},{"$f":"G21-1","v":8},{"$f":"round_to_even(C23/G23,2)","v":123456.79},{"$f":"H23+F23","v":127072.41999999988}]
["2024-02-14","2024-02-14",{"$f":"round_to_even((C23-H23),2)","v":864197.52},4.5499999999999999E-2,35,{"$f":"round_to_even(C24*ROUND((1+D24)^(E24/366),15),2)-C24","v":3685},{"$f":"G23-1","v":7},{"$f":"round_to_even(C24/G24,2)","v":123456.79},127141.79]
["2024-03-11","2024-03-11",{"$f":"round_to_even((C24-H24),2)","v":740740.73},4.5499999999999999E-2,26,{"$f":"round_to_even(C25*ROUND((1+D25)^(E25/366),15),2)-C25","v":2345.0899999999674},6,{"$f":"round_to_even(C25/G25,2)","v":123456.79},125801.87999999996]
["2024-04-10","2024-04-10",{"$f":"round_to_even((C25-H25),2)","v":617283.93999999994},4.5499999999999999E-2,30,{"$f":"round_to_even(C26*ROUND((1+D26)^(E26/366),15),2)-C26","v":2255.4400000000605},5,{"$f":"round_to_even(C26/G26,2)","v":123456.79},125712.23000000005]
["2024-05-10","2024-05-10",{"$f":"round_to_even((C26-H26),2)","v":493827.15},4.5499999999999999E-2,30,{"$f":"round_to_even(C27*ROUND((1+D27)^(E27/366),15),2)-C27","v":1804.3499999999767},4,{"$f":"round_to_even(C27/G27,2)","v":123456.79},125261.13999999997]
["2024-06-10","2024-06-10",{"$f":"round_to_even((C27-H27),2)","v":370370.36},4.5499999999999999E-2,31,{"$f":"round_to_even(C28*ROUND((1+D28)^(E28/366),15),2)-C28","v":1398.460000000021},3,{"$f":"round_to_even(C28/G28,2)","v":123456.79},124855.25000000001]
["2024-07-10","2024-07-10",{"$f":"round_to_even((C28-H28),2)","v":246913.57},4.5499999999999999E-2,30,{"$f":"round_to_even(C29*ROUND((1+D29)^(E29/366),15),2)-C29","v":902.17999999999302},2,{"$f":"round_to_even(C29/G29,2)","v":123456.78},124358.95999999999]
["2024-08-12","2024-08-12",{"$f":"round_to_even((C29-H29),2)","v":123456.79},4.5499999999999999E-2,33,{"$f":"round_to_even(C30*ROUND((1+D30)^(E30/366),15),2)-C30","v":496.29000000000815},1,{"$f":"round_to_even(C30/G30,2)","v":123456.79},123953.08]
[]
["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 Atualização) - Principal ",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 Atualização"]
["= (1 + Taxa % a.a.)Dias/(365 ou 366)",null,null,null,null,null,"= (Base de Cálculo x Fator de Remuneração) - Base de Cálculo "]
[]
["(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,"= Produtório dos Fatores Diários SELIC apurados desde a data inicial (inclusive)  "]
[null,null,null,null,null,null,"até o dia do efetivo pagamento (exclusive)"]
[null,null,null,null,null,null,"Fator Diário Selic "]
[null,null,null,null,null,null,"= (1+ Selic % a.a.)1/252 "]
[]
[null,null,null,null,null,null,"arredondamento em 8 casas decimais"]

{"sheet":"Taxa Flat","index":1,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
["% 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":"'Taxa Composta_SAC'!A10","v":"2023-10-02"},{"$f":"A6","v":"2023-10-02"},"LIBERACAO",{"$f":"'Taxa Composta_SAC'!B10","v":1234567.8899999999},null,"2023-10-02",1.0004727899999999]
[{"$f":"'Taxa Composta_SAC'!A20","v":"2023-11-16"},{"$f":"'Taxa Composta_SAC'!B20","v":"2023-11-16"},"TAXA FLAT",{"$f":"round_to_even(D6*$B$1,2)","v":299.33},null,"2023-10-03",1.0004727899999999]
[{"$f":"A7","v":"2023-11-16"},{"$f":"B7","v":"2023-11-16"},"REMUNERAÇÃO",{"$f":"round_to_even(D7*ROUND(PRODUCT(G6:G35),15),2)-D7","v":4.2300000000000182},null,"2023-10-04",1.0004727899999999]
[null,null,null,null,null,"2023-10-05",1.0004727899999999]
[null,null,null,null,null,"2023-10-06",1.0004727899999999]
[null,null,null,null,null,"2023-10-09",1.0004727899999999]
[null,null,null,null,null,"2023-10-10",1.0004727899999999]
[null,null,null,null,null,"2023-10-11",1.0004727899999999]
[null,null,null,null,null,"2023-10-13",1.0004727899999999]
[null,null,null,null,null,"2023-10-16",1.0004727899999999]
[null,null,null,null,null,"2023-10-17",1.0004727899999999]
[null,null,null,null,null,"2023-10-18",1.0004727899999999]
[null,null,null,null,null,"2023-10-19",1.0004727899999999]
[null,null,null,null,null,"2023-10-20",1.0004727899999999]
[null,null,null,null,null,"2023-10-23",1.0004727899999999]
[null,null,null,null,null,"2023-10-24",1.0004727899999999]
[null,null,null,null,null,"2023-10-25",1.0004727899999999]
[null,null,null,null,null,"2023-10-26",1.0004727899999999]
[null,null,null,null,null,"2023-10-27",1.0004727899999999]
[null,null,null,null,null,"2023-10-30",1.0004727899999999]
[null,null,null,null,null,"2023-10-31",1.0004727899999999]
[null,null,null,null,null,"2023-11-01",1.0004727899999999]
[null,null,null,null,null,"2023-11-03",1.00045513]
[null,null,null,null,null,"2023-11-06",1.00045513]
[null,null,null,null,null,"2023-11-07",1.00045513]
[null,null,null,null,null,"2023-11-08",1.00045513]
[null,null,null,null,null,"2023-11-09",1.00045513]
[null,null,null,null,null,"2023-11-10",1.00045513]
[null,null,null,null,null,"2023-11-13",1.00045513]
[null,null,null,null,null,"2023-11-14",1.00045513]
[]
["*","https://www.bcb.gov.br/estabilidadefinanceira/selicdadosdiarios"]