{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Atrium","Florestal","Financeiro"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":74,"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":"Atrium","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Florestal","index":1,"n_rows":236,"n_cols":30,"rows_kept":236,"cut":false,"hidden":false,"merged":[[16,14,16,18],[65,1,66,3],[0,1,0,3],[6,1,6,3],[13,1,13,3],[28,1,28,3],[56,1,56,3],[67,1,68,3],[86,1,87,3],[107,1,108,3],[109,1,122,2],[70,1,83,1],[149,1,162,1],[164,1,177,1],[179,1,192,1],[129,1,130,3],[195,1,196,3],[131,1,132,3],[134,1,147,1],[197,1,208,1],[211,1,214,1],[222,1,223,3],[234,1,235,1],[224,1,224,3],[229,1,229,3]]}
[null,"Premissas financeiras"]
[null,"Ano Zero:",2023,"PIS:",6.4999999999999997E-3,"sobre o faturamento"]
[null,"Taxa de inflação esperada:",0,"Cofins:",0.03,"sobre o faturamento"]
[null,"Taxa nominal de retorno desejado:",0.05,"IRPJ:",0.02,"(8% sobre faturamento = Lucro presumido) * (alíquota 25%)"]
[null,"Imposto sobre lucro presumido rural",{"$f":"SUM(Florestal!E2:E5)","v":6.7299999999999999E-2},"CSLL:",1.0800000000000001E-2,"(12% sobre faturamento = base de cálculo) * (alíquota de 9%)"]
[]
[null,"Preços (R$/m3)"]
[null,"Produtos","Preço (R$/m3)"]
[null,"CEL",150]
[null,"BIO",0]
[null,"XX1",0]
[null,"XX2",0]
[]
[null,"Intervenção de colheita e produtividades (m3/ha)"]
[null,"Intervenções","Idade","Produção (m3/ha)",{"$f":"CONCATENATE(\"% Vol  \",B9)","v":"% Vol  CEL"},{"$f":"B9","v":"CEL"},{"$f":"CONCATENATE(\"% Vol  \",B10)","v":"% Vol  BIO"},{"$f":"B10","v":"BIO"},{"$f":"CONCATENATE(\"% Vol  \",B11)","v":"% Vol  XX1"},{"$f":"B11","v":"XX1"},{"$f":"CONCATENATE(\"% Vol  \",B12)","v":"% Vol  XX2"},{"$f":"B12","v":"XX2"}]
[null,"CR5",5,224.07,1,{"$f":"E16*$D16","v":224.07},0,{"$f":"G16*$D16","v":0},0,{"$f":"I16*$D16","v":0},0,{"$f":"K16*$D16","v":0}]
[null,"CR6",6,265.14949999999999,1,{"$f":"E17*$D17","v":265.14949999999999},0,{"$f":"G17*$D17","v":0},0,0,0,0]
[null,"CR7",7,296.62600000000003,1,296.62600000000003,0,0,0,0,0,0]
[null,"CR8",8,321.16700000000003,1,321.16700000000003,0,0,0,0,0,0]
[null,"CC5",5,224.07,1,224.07,0,0,0,0,0,0]
[null,"CC6",6,265.14949999999999,1,265.14949999999999,0,0,0,0,0,0]
[null,"CC7",7,296.62600000000003,1,296.62600000000003,0,{"$f":"G22*$D22","v":0},0,0,0,0]
[null,"CC8",8,321.16700000000003,1,321.16700000000003,0,0,0,0,0,0]
[null,"CF5",5,203.7,1,203.7,0,0,0,0,0,0]
[null,"CF6",6,241.04499999999999,1,241.04499999999999,0,0,0,0,0,0]
[null,"CF7",7,269.65999999999997,1,269.65999999999997,0,0,0,0,0,0]
[null,"CF8",8,291.96999999999997,1,291.96999999999997,0,0,0,0,0,0]
[]
[null,"Intervenções de manejo e custos (R$)"]
[null,"Intervenção","% da Área para custo","Despesas (R$/ha)",null,null,null,null,null,null,null,"Sigla","Descrição"]
[null,"X",0,0,null,"Gestão Florestal (R$/ha)",null,null,-100,null,null,{"$f":"B31","v":"X"},"Nada"]
[null,"CMP",1,0,null,"Investimento Máquinas Florestais",null,null,0.03,"s/ desp operacionais",null,"CMP","Compra da terra"]
[null,"IAR",1,0,null,"Colheita (R$/m3)",null,null,-50,null,null,"IAR","Início do Contrato de arrendamento"]
[null,"IMP",1,-5000,null,null,null,null,null,null,null,"IMP","Implantação"]
[null,"MN1",1,-1000,null,"Regiões","Prç Terra","Arrendam.","%Região","Frete",null,"MN1","Manutenção no ano 1"]
[null,"MN2",1,-250,null,null,"(R$/ha)","(*)",null," (R$/m3)",null,"MN2","Manutenção no ano 2"]
[null,"MN3",1,-250,null,"50KM",5000,-445.74,0.5,-20,null,"MN3","Manutenção no ano 3"]
[null,"MN4",1,-250,null,"150KM",4000,-407.1,0.5,-25,null,"MN4","Manutenção no ano 4"]
[null,"MN5",1,-250,null,"XX",0,0,0,0,null,"MN5","Manutenção no ano 5"]
[null,"MN6",1,-250,null,null,null,"(*) R$/ha.ano",null,null,null,"MN6","Manutenção no ano 6"]
[null,"MN7",1,-250,null,null,null,null,null,null,null,"MN7","Manutenção no ano 7"]
[null,{"$f":"B16","v":"CR5"},1,-4000,null,null,null,null,null,null,null,"CR5","Corte da primeira rotação seguido de reforma na idade 5 anos"]
[null,{"$f":"B17","v":"CR6"},1,-4000,null,null,null,null,null,null,null,"CR6","Corte da primeira rotação seguido de reforma na idade 6 anos"]
[null,"CR7",1,-4000,null,null,null,null,null,null,null,"CR7","Corte da primeira rotação seguido de reforma na idade 7 anos"]
[null,"CR8",1,-4000,null,null,null,null,null,null,null,"CR8","Corte da primeira rotação seguido de reforma na idade 8 anos"]
[null,"CC5",1,-2500,null,null,null,null,null,null,null,"CC5","Corte da primeira rotação seguido de condução da brotação na idade 5 anos"]
[null,"CC6",1,-2500,null,null,null,null,null,null,null,"CC6","Corte da primeira rotação seguido de condução da brotação na idade 6 anos"]
[null,"CC7",1,-2500,null,null,null,null,null,null,null,"CC7","Corte da primeira rotação seguido de condução da brotação na idade 7 anos"]
[null,"CC8",1,-2500,null,null,null,null,null,null,null,"CC8","Corte da primeira rotação seguido de condução da brotação na idade 8 anos"]
[null,"CF5",1,0,null,null,null,null,null,null,null,"CF5","Corte da segunda rotação aos 5 anos"]
[null,"CF6",1,0,null,null,null,null,null,null,null,"CF6","Corte da segunda rotação aos 6 anos"]
[null,"CF7",1,0,null,null,null,null,null,null,null,"CF7","Corte da segunda rotação aos 7 anos"]
[null,"CF8",1,0,null,null,null,null,null,null,null,"CF8","Corte da segunda rotação aos 8 anos"]
[null,"LAR",1,0,null,null,null,null,null,null,null,"LAR","Liberação do contrato de arrendamento"]
[null,"VND",1,0,null,null,null,null,null,null,null,"VND","Venda da terra"]
[]
[null,"Cálculadora de área necessária"]
[null,"Demanda mensal",40000,"m3/mês"]
[null,"Meses",12,"meses"]
[null,"Demanda Anual",{"$f":"C58*C59","v":480000},"m3/ano"]
[null,"IMA (6 anos)",{"$f":"241/6","v":40.166666666666664},"m3/ha.ano"]
[null,"Área necessária",{"$f":"C60/C61","v":11950.207468879669},"ha"]
[null,"Aproveitamento",0.6]
[null,"Área Total",{"$f":"C62/C63","v":19917.012448132784},"ha"]
[]
[null,"Agendamento das intervenções"]
[]
[null,null,null,null,{"$f":"E69-$E$69+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,{"$f":"C2+1","v":2024},{"$f":"E69+1","v":2025},{"$f":"F69+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,null,"Área","Gleba","    (use os códigos de intervenção para agendar as prescrições em cada gleba)"]
[null,"Planejamento",1000,"Tlh01","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X","X"]
[null,null,1000,"Tlh02","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X"]
[null,null,1000,"Tlh03","x","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X"]
[null,null,1000,"Tlh04","x","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X"]
[null,null,1000,"Tlh05","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X"]
[null,null,1000,"Tlh06","X","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND"]
[null,null,1000,"Tlh07","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X","X"]
[null,null,1000,"Tlh08","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X"]
[null,null,1000,"Tlh09","x","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X"]
[null,null,1000,"Tlh10","x","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X"]
[null,null,1000,"Tlh11","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X"]
[null,null,1000,"Tlh12","X","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND"]
[null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,"Área Total (ha):",{"$f":"SUM(C71:C84)","v":12000},"Ganhos Prod.>>",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,"Totalização das áreas por intervenção"]
[]
[null,null,null,null,{"$f":"E$68","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,{"$f":"E$69","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Área de Implantação (ha)","IMP",{"$f":"SUM(E91:AD91)","v":12000},{"$f":"SUMIF(E$71:E$84,$C91,$C$71:$C$84)","v":0},2000,2000,2000,2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Área comprada (ha)","CMP",{"$f":"SUM(E93:AD93)","v":12000},{"$f":"SUMIF(E$71:E$84,$C93,$C$71:$C$84)","v":2000},{"$f":"SUMIF(F$71:F$84,$C93,$C$71:$C$84)","v":2000},{"$f":"SUMIF(G$71:G$84,$C93,$C$71:$C$84)","v":2000},2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total",20000,{"$f":"E93/$C$63","v":3333.3333333333335},3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Área Arrendamento (ha)","IAR",0,{"$f":"SUMIF(E$71:E$84,$C95,$C$71:$C$84)","v":0},{"$f":"SUMIF(F$71:F$84,$C95,$C$71:$C$84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total",0,{"$f":"E95/$C$63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Área vendida (ha)","VND",12000,{"$f":"SUMIF(E$71:E$84,$C97,$C$71:$C$84)","v":0},{"$f":"SUMIF(F$71:F$84,$C97,$C$71:$C$84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000]
[null,null,"Total",20000,{"$f":"E97/$C$63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335]
[null,"Área Lib Arrend (ha)","LAR",0,{"$f":"SUMIF(E$71:E$84,$C99,$C$71:$C$84)","v":0},{"$f":"SUMIF(F$71:F$84,$C99,$C$71:$C$84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total",0,{"$f":"E99/$C$63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Área Própria(ha)",null,{"$f":"MAX(E101:AD101)","v":12000},{"$f":"E93-E97","v":2000},{"$f":"E101+F93-F97","v":4000},{"$f":"F101+G93-G97","v":6000},8000,10000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,10000,8000,6000,4000,2000,0]
[null,null,"Total",20000,{"$f":"E94-E98","v":3333.3333333333335},{"$f":"E102+F94-F98","v":6666.666666666667},10000,13333.333333333334,16666.666666666668,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,16666.666666666668,13333.333333333334,10000,6666.6666666666661,3333.3333333333326,0]
[null,"Área arrendada(ha)",null,0,{"$f":"E95-E99","v":0},{"$f":"E103+F95-F99","v":0},{"$f":"F103+G95-G99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total",0,{"$f":"E96-E100","v":0},{"$f":"E104+F96-F100","v":0},{"$f":"F104+G96-G100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Área de Gestão(ha)",null,12000,{"$f":"E101+E103","v":2000},{"$f":"F101+F103","v":4000},6000,8000,10000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,10000,8000,6000,4000,2000,0]
[null,null,"Total",20000,{"$f":"E102+E104","v":3333.3333333333335},{"$f":"F102+F104","v":6666.666666666667},10000,13333.333333333334,16666.666666666668,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,16666.666666666668,13333.333333333334,10000,6666.6666666666661,3333.3333333333326,0]
[]
[null,"Despesas operacionais (mil R$)",null,null,{"$f":"E$68","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,{"$f":"E$69","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Despesas Operacionais: Plantio, Reforma, Condução e Manutenção (mil R$)",null,{"$f":"D71","v":"Tlh01"},{"$f":"VLOOKUP(E71,$B$30:$D$55,3,0)*VLOOKUP(E71,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C71/1000","v":0},-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D72","v":"Tlh02"},{"$f":"VLOOKUP(E72,$B$30:$D$55,3,0)*VLOOKUP(E72,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C72/1000","v":0},0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0,0]
[null,null,null,"Tlh03",{"$f":"VLOOKUP(E73,$B$30:$D$55,3,0)*VLOOKUP(E73,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C73/1000","v":0},0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0]
[null,null,null,"Tlh04",{"$f":"VLOOKUP(E74,$B$30:$D$55,3,0)*VLOOKUP(E74,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C74/1000","v":0},0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0]
[null,null,null,"Tlh05",{"$f":"VLOOKUP(E75,$B$30:$D$55,3,0)*VLOOKUP(E75,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C75/1000","v":0},0,0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0]
[null,null,null,"Tlh06",{"$f":"VLOOKUP(E76,$B$30:$D$55,3,0)*VLOOKUP(E76,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C76/1000","v":0},0,0,0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0]
[null,null,null,"Tlh07",{"$f":"VLOOKUP(E77,$B$30:$D$55,3,0)*VLOOKUP(E77,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C77/1000","v":0},-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0,0,0]
[null,null,null,"Tlh08",{"$f":"VLOOKUP(E78,$B$30:$D$55,3,0)*VLOOKUP(E78,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C78/1000","v":0},0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0,0]
[null,null,null,"Tlh09",{"$f":"VLOOKUP(E79,$B$30:$D$55,3,0)*VLOOKUP(E79,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C79/1000","v":0},0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0,0]
[null,null,null,"Tlh10",{"$f":"VLOOKUP(E80,$B$30:$D$55,3,0)*VLOOKUP(E80,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C80/1000","v":0},0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0,0]
[null,null,null,"Tlh11",{"$f":"VLOOKUP(E81,$B$30:$D$55,3,0)*VLOOKUP(E81,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C81/1000","v":0},0,0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0,0]
[null,null,null,"Tlh12",{"$f":"VLOOKUP(E82,$B$30:$D$55,3,0)*VLOOKUP(E82,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C82/1000","v":0},0,0,0,0,0,-5000,-1000,-250,-250,-250,-250,-2500,-1000,-250,-250,-250,-250,-4000,-1000,-250,-250,-250,-250,0,0]
[null,null,null,"Tlh13",{"$f":"VLOOKUP(E83,$B$30:$D$55,3,0)*VLOOKUP(E83,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C83/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Tlh14",{"$f":"VLOOKUP(E84,$B$30:$D$55,3,0)*VLOOKUP(E84,$B$30:$D$55,2,0)*((1+Infla)^E$108)*$C84/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Custos",null,"Valor Presente"]
[null,"operacionais até colheita:",{"$f":"SUM(E125:AD125)","v":-210000},{"$f":"NPV(TxNom,E125:AD125)","v":-127914.0070488482},{"$f":"SUM(E110:E123)","v":0},{"$f":"SUM(F110:F123)","v":-10000},-12000,-12500,-13000,-13500,-14000,-9000,-9000,-9000,-9000,-9000,-9000,-12000,-12000,-12000,-12000,-12000,-12000,-4000,-2000,-1500,-1000,-500,0,0]
[null,"de colheita:",{"$f":"SUM(E126:AD126)","v":-462806.40000000008},{"$f":"NPV(TxNom,E126:AD126)","v":-215433.14714508332},{"$f":"SUM(E149,E164,E179,E194)*$I$33*((1+Infla)^E$108)/1000","v":0},0,0,0,0,0,0,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-26514.95,-24104.5,-24104.5,-24104.5,-24104.5,-24104.5,-24104.5,0]
[null,"de frete:",{"$f":"SUM(E127:AD127)","v":-208262.88},{"$f":"NPV(TxNom,E127:AD127)","v":-96944.916215287478},{"$f":"SUM(E$149,E$164,E179,E194)*SUMPRODUCT($I$37:$I$39,$J$37:$J$39)*((1+Infla)^E$108)/1000","v":0},0,0,0,0,0,0,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-11931.727500000001,-10847.025,-10847.025,-10847.025,-10847.025,-10847.025,-10847.025,0]
[null,"Total",{"$f":"SUM(E128:AD128)","v":-881069.28},{"$f":"NPV(TxNom,E128:AD128)","v":-440292.07040921907},{"$f":"SUM(E125:E127)","v":0},{"$f":"SUM(F125:F127)","v":-10000},-12000,-12500,-13000,-13500,-14000,-47446.677499999998,-47446.677499999998,-47446.677499999998,-47446.677499999998,-47446.677499999998,-47446.677499999998,-50446.677499999998,-50446.677499999998,-50446.677499999998,-50446.677499999998,-50446.677499999998,-50446.677499999998,-38951.525000000001,-36951.525000000001,-36451.525000000001,-35951.525000000001,-35451.525000000001,-34951.525000000001,0]
[]
[null,"Fluxo de produção (m3)"]
[]
[null,null,null,null,{"$f":"E$68","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,{"$f":"E$69","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,null,"Produto","Gleba"]
[null,"Volume colhido (m3) de",{"$f":"IF(D71=\"\",\"\",$B$9)","v":"CEL"},{"$f":"IF(D71=\"\",\"\",D71)","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(E71,$B$16:$L$27,3+MATCH($C135,$E$15:$L$15,0),0)*$C71*E$85,0)","v":0},0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0,0,0]
[null,null,"CEL","Tlh02",{"$f":"IFERROR(VLOOKUP(E72,$B$16:$L$27,3+MATCH($C136,$E$15:$L$15,0),0)*$C72*E$85,0)","v":0},0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0,0]
[null,null,"CEL","Tlh03",{"$f":"IFERROR(VLOOKUP(E73,$B$16:$L$27,3+MATCH($C137,$E$15:$L$15,0),0)*$C73*E$85,0)","v":0},0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0]
[null,null,"CEL","Tlh04",{"$f":"IFERROR(VLOOKUP(E74,$B$16:$L$27,3+MATCH($C138,$E$15:$L$15,0),0)*$C74*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0]
[null,null,"CEL","Tlh05",{"$f":"IFERROR(VLOOKUP(E75,$B$16:$L$27,3+MATCH($C139,$E$15:$L$15,0),0)*$C75*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0]
[null,null,"CEL","Tlh06",{"$f":"IFERROR(VLOOKUP(E76,$B$16:$L$27,3+MATCH($C140,$E$15:$L$15,0),0)*$C76*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0]
[null,null,"CEL","Tlh07",{"$f":"IFERROR(VLOOKUP(E77,$B$16:$L$27,3+MATCH($C141,$E$15:$L$15,0),0)*$C77*E$85,0)","v":0},0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0,0,0]
[null,null,"CEL","Tlh08",{"$f":"IFERROR(VLOOKUP(E78,$B$16:$L$27,3+MATCH($C142,$E$15:$L$15,0),0)*$C78*E$85,0)","v":0},0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0,0]
[null,null,"CEL","Tlh09",{"$f":"IFERROR(VLOOKUP(E79,$B$16:$L$27,3+MATCH($C143,$E$15:$L$15,0),0)*$C79*E$85,0)","v":0},0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0,0]
[null,null,"CEL","Tlh10",{"$f":"IFERROR(VLOOKUP(E80,$B$16:$L$27,3+MATCH($C144,$E$15:$L$15,0),0)*$C80*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0,0]
[null,null,"CEL","Tlh11",{"$f":"IFERROR(VLOOKUP(E81,$B$16:$L$27,3+MATCH($C145,$E$15:$L$15,0),0)*$C81*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0,0]
[null,null,"CEL","Tlh12",{"$f":"IFERROR(VLOOKUP(E82,$B$16:$L$27,3+MATCH($C146,$E$15:$L$15,0),0)*$C82*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,265149.5,0,0,0,0,0,265149.5,0,0,0,0,0,241045,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E83,$B$16:$L$27,3+MATCH($C147,$E$15:$L$15,0),0)*$C83*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E84,$B$16:$L$27,3+MATCH($C148,$E$15:$L$15,0),0)*$C84*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Total de \"","v":"Total de "},{"$f":"C135","v":"CEL"},{"$f":"SUM(E149:AD149)","v":9256128},{"$f":"SUM(E135:E148)","v":0},{"$f":"SUM(F135:F148)","v":0},0,0,0,0,0,530299,530299,530299,530299,{"$f":"SUM(P135:P148)","v":530299},530299,530299,530299,530299,530299,530299,530299,482090,482090,482090,482090,482090,482090,0]
[null,"Volume colhido (m3) de",{"$f":"IF(D71=\"\",\"\",$B$10)","v":"BIO"},{"$f":"IF(D71=\"\",\"\",D71)","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(E71,$B$16:$L$27,3+MATCH($C150,$E$15:$L$15,0),0)*$C71*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh02",{"$f":"IFERROR(VLOOKUP(E72,$B$16:$L$27,3+MATCH($C151,$E$15:$L$15,0),0)*$C72*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh03",{"$f":"IFERROR(VLOOKUP(E73,$B$16:$L$27,3+MATCH($C152,$E$15:$L$15,0),0)*$C73*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh04",{"$f":"IFERROR(VLOOKUP(E74,$B$16:$L$27,3+MATCH($C153,$E$15:$L$15,0),0)*$C74*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh05",{"$f":"IFERROR(VLOOKUP(E75,$B$16:$L$27,3+MATCH($C154,$E$15:$L$15,0),0)*$C75*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh06",{"$f":"IFERROR(VLOOKUP(E76,$B$16:$L$27,3+MATCH($C155,$E$15:$L$15,0),0)*$C76*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh07",{"$f":"IFERROR(VLOOKUP(E77,$B$16:$L$27,3+MATCH($C156,$E$15:$L$15,0),0)*$C77*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh08",{"$f":"IFERROR(VLOOKUP(E78,$B$16:$L$27,3+MATCH($C157,$E$15:$L$15,0),0)*$C78*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh09",{"$f":"IFERROR(VLOOKUP(E79,$B$16:$L$27,3+MATCH($C158,$E$15:$L$15,0),0)*$C79*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh10",{"$f":"IFERROR(VLOOKUP(E80,$B$16:$L$27,3+MATCH($C159,$E$15:$L$15,0),0)*$C80*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh11",{"$f":"IFERROR(VLOOKUP(E81,$B$16:$L$27,3+MATCH($C160,$E$15:$L$15,0),0)*$C81*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"BIO","Tlh12",{"$f":"IFERROR(VLOOKUP(E82,$B$16:$L$27,3+MATCH($C161,$E$15:$L$15,0),0)*$C82*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E83,$B$16:$L$27,3+MATCH($C162,$E$15:$L$15,0),0)*$C83*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E84,$B$16:$L$27,3+MATCH($C163,$E$15:$L$15,0),0)*$C84*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Total de \"","v":"Total de "},{"$f":"C150","v":"BIO"},{"$f":"SUM(E164:AD164)","v":0},{"$f":"SUM(E150:E163)","v":0},{"$f":"SUM(F150:F163)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD150:AD163)","v":0}]
[null,"Volume colhido (m3) de",{"$f":"IF(D71=\"\",\"\",$B$11)","v":"XX1"},{"$f":"IF(D71=\"\",\"\",D71)","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(E71,$B$16:$L$27,3+MATCH($C165,$E$15:$L$15,0),0)*$C71*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh02",{"$f":"IFERROR(VLOOKUP(E72,$B$16:$L$27,3+MATCH($C166,$E$15:$L$15,0),0)*$C72*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh03",{"$f":"IFERROR(VLOOKUP(E73,$B$16:$L$27,3+MATCH($C167,$E$15:$L$15,0),0)*$C73*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh04",{"$f":"IFERROR(VLOOKUP(E74,$B$16:$L$27,3+MATCH($C168,$E$15:$L$15,0),0)*$C74*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh05",{"$f":"IFERROR(VLOOKUP(E75,$B$16:$L$27,3+MATCH($C169,$E$15:$L$15,0),0)*$C75*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh06",{"$f":"IFERROR(VLOOKUP(E76,$B$16:$L$27,3+MATCH($C170,$E$15:$L$15,0),0)*$C76*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh07",{"$f":"IFERROR(VLOOKUP(E77,$B$16:$L$27,3+MATCH($C171,$E$15:$L$15,0),0)*$C77*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh08",{"$f":"IFERROR(VLOOKUP(E78,$B$16:$L$27,3+MATCH($C172,$E$15:$L$15,0),0)*$C78*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh09",{"$f":"IFERROR(VLOOKUP(E79,$B$16:$L$27,3+MATCH($C173,$E$15:$L$15,0),0)*$C79*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh10",{"$f":"IFERROR(VLOOKUP(E80,$B$16:$L$27,3+MATCH($C174,$E$15:$L$15,0),0)*$C80*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh11",{"$f":"IFERROR(VLOOKUP(E81,$B$16:$L$27,3+MATCH($C175,$E$15:$L$15,0),0)*$C81*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX1","Tlh12",{"$f":"IFERROR(VLOOKUP(E82,$B$16:$L$27,3+MATCH($C176,$E$15:$L$15,0),0)*$C82*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E83,$B$16:$L$27,3+MATCH($C177,$E$15:$L$15,0),0)*$C83*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E84,$B$16:$L$27,3+MATCH($C178,$E$15:$L$15,0),0)*$C84*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Total de \"","v":"Total de "},{"$f":"C165","v":"XX1"},{"$f":"SUM(E179:AD179)","v":0},{"$f":"SUM(E165:E178)","v":0},{"$f":"SUM(F165:F178)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Volume colhido (m3) de",{"$f":"IF(D71=\"\",\"\",$B$12)","v":"XX2"},{"$f":"IF(D71=\"\",\"\",D71)","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(E71,$B$16:$L$27,3+MATCH($C180,$E$15:$L$15,0),0)*$C71*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh02",{"$f":"IFERROR(VLOOKUP(E72,$B$16:$L$27,3+MATCH($C181,$E$15:$L$15,0),0)*$C72*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh03",{"$f":"IFERROR(VLOOKUP(E73,$B$16:$L$27,3+MATCH($C182,$E$15:$L$15,0),0)*$C73*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh04",{"$f":"IFERROR(VLOOKUP(E74,$B$16:$L$27,3+MATCH($C183,$E$15:$L$15,0),0)*$C74*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh05",{"$f":"IFERROR(VLOOKUP(E75,$B$16:$L$27,3+MATCH($C184,$E$15:$L$15,0),0)*$C75*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh06",{"$f":"IFERROR(VLOOKUP(E76,$B$16:$L$27,3+MATCH($C185,$E$15:$L$15,0),0)*$C76*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh07",{"$f":"IFERROR(VLOOKUP(E77,$B$16:$L$27,3+MATCH($C186,$E$15:$L$15,0),0)*$C77*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh08",{"$f":"IFERROR(VLOOKUP(E78,$B$16:$L$27,3+MATCH($C187,$E$15:$L$15,0),0)*$C78*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh09",{"$f":"IFERROR(VLOOKUP(E79,$B$16:$L$27,3+MATCH($C188,$E$15:$L$15,0),0)*$C79*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh10",{"$f":"IFERROR(VLOOKUP(E80,$B$16:$L$27,3+MATCH($C189,$E$15:$L$15,0),0)*$C80*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh11",{"$f":"IFERROR(VLOOKUP(E81,$B$16:$L$27,3+MATCH($C190,$E$15:$L$15,0),0)*$C81*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XX2","Tlh12",{"$f":"IFERROR(VLOOKUP(E82,$B$16:$L$27,3+MATCH($C191,$E$15:$L$15,0),0)*$C82*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E83,$B$16:$L$27,3+MATCH($C192,$E$15:$L$15,0),0)*$C83*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"","",{"$f":"IFERROR(VLOOKUP(E84,$B$16:$L$27,3+MATCH($C193,$E$15:$L$15,0),0)*$C84*E$85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Total de \"","v":"Total de "},{"$f":"C180","v":"XX2"},{"$f":"SUM(E194:AD194)","v":0},{"$f":"SUM(E180:E193)","v":0},{"$f":"SUM(F180:F193)","v":0},{"$f":"SUM(G180:G193)","v":0},{"$f":"SUM(H180:H193)","v":0},{"$f":"SUM(I180:I193)","v":0},{"$f":"SUM(J180:J193)","v":0},{"$f":"SUM(K180:K193)","v":0},{"$f":"SUM(L180:L193)","v":0},{"$f":"SUM(M180:M193)","v":0},{"$f":"SUM(N180:N193)","v":0},{"$f":"SUM(O180:O193)","v":0},{"$f":"SUM(P180:P193)","v":0},{"$f":"SUM(Q180:Q193)","v":0},{"$f":"SUM(R180:R193)","v":0},{"$f":"SUM(S180:S193)","v":0},{"$f":"SUM(T180:T193)","v":0},{"$f":"SUM(U180:U193)","v":0},{"$f":"SUM(V180:V193)","v":0},{"$f":"SUM(W180:W193)","v":0},{"$f":"SUM(X180:X193)","v":0},{"$f":"SUM(Y180:Y193)","v":0},{"$f":"SUM(Z180:Z193)","v":0},{"$f":"SUM(AA180:AA193)","v":0},{"$f":"SUM(AB180:AB193)","v":0},{"$f":"SUM(AC180:AC193)","v":0},{"$f":"SUM(AD180:AD193)","v":0}]
[]
[null,"Receitas com produção (mil R$)",null,null,{"$f":"E$68","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,{"$f":"E$69","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Área Colhida",{"$f":"B16","v":"CR5"},{"$f":"SUM(E198:AD198)","v":0},{"$f":"SUMIF(E$71:E$84,$C198,$C$71:$C$84)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF(O$71:O$84,$C198,$C$71:$C$84)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF(Y$71:Y$84,$C198,$C$71:$C$84)","v":0},0,0,0,0,0]
[null,null,"CR6",12000,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000,0,0,0,0,0,0,0]
[null,null,"CR7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CR8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CC5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CC6",12000,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CC7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CC8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CF5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CF6",12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000,0]
[null,null,"CF7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CF8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Área Colhida (ha)",{"$f":"SUM(E210:AD210)","v":36000},null,{"$f":"SUM(E198:E208)","v":0},{"$f":"SUM(F198:F208)","v":0},0,0,0,0,0,{"$f":"SUM(L198:L208)","v":2000},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,0]
[null,"Produtividade média (m3/ha)",{"$f":"SUM(D149,D164,D179,D194)/C210","v":257.11466666666666},null,{"$f":"IF(E210>0,SUM(E149,E164,E179,E194)/E210,0)","v":0},0,0,0,0,0,0,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,265.14949999999999,241.04499999999999,241.04499999999999,241.04499999999999,241.04499999999999,241.04499999999999,241.04499999999999,0]
[null,"Preços (R$/m3)",{"$f":"C149","v":"CEL"},{"$f":"VLOOKUP(C212,$B$9:$C$12,2,0)","v":150},{"$f":"$D212*((1+Infla)^E$196)","v":150},150,150,150,150,150,150,150,150,150,{"$f":"$D212*((1+Infla)^O$196)","v":150},150,150,150,150,150,150,150,150,150,{"$f":"$D212*((1+Infla)^Y$196)","v":150},150,150,150,150,150]
[null,null,{"$f":"C164","v":"BIO"},{"$f":"VLOOKUP(C213,$B$9:$C$12,2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C179","v":"XX1"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C194","v":"XX2"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Receitas",null,"Valor Presente"]
[null,{"$f":"\"com \"&C212&\":\"","v":"com CEL:"},{"$f":"SUM(E217:AD217)","v":1388419.1999999997},{"$f":"NPV(TxNom,E217:AD217)","v":646299.44143524999},{"$f":"E212*E$149/1000","v":0},{"$f":"F212*F$149/1000","v":0},0,0,0,0,0,79544.850000000006,79544.850000000006,79544.850000000006,{"$f":"O212*O$149/1000","v":79544.850000000006},79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,72313.5,72313.5,72313.5,72313.5,72313.5,72313.5,0]
[null,{"$f":"\"com \"&C213&\":\"","v":"com BIO:"},{"$f":"SUM(E218:AD218)","v":0},{"$f":"NPV(TxNom,E218:AD218)","v":0},{"$f":"E213*E$164/1000","v":0},{"$f":"F213*F$164/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"O213*O$164/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"com \"&C214&\":\"","v":"com XX1:"},0,{"$f":"NPV(TxNom,E219:AD219)","v":0},{"$f":"E214*E$179/1000","v":0},{"$f":"F214*F$179/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"O214*O$179/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"com \"&C215&\":\"","v":"com XX2:"},0,{"$f":"NPV(TxNom,E220:AD220)","v":0},{"$f":"E215*E$194/1000","v":0},{"$f":"F215*F$194/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"O215*O$194/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(E221:AD221)","v":1388419.1999999997},{"$f":"NPV(TxNom,E221:AD221)","v":646299.44143524999},{"$f":"SUM(E217:E220)","v":0},{"$f":"SUM(F217:F220)","v":0},0,0,0,0,0,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,79544.850000000006,72313.5,72313.5,72313.5,72313.5,72313.5,72313.5,0]
[]
[null,"Terra, máquinas, gestão e impostos (mil R$)"]
[]
[null,null,null,null,{"$f":"E$68","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,"Soma","Valor Presente",{"$f":"E$69","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Compra de terra",{"$f":"SUM(E227:AD227)","v":-96514.250736959992},{"$f":"NPV(TxNom,E227:AD227)","v":-81416.534452141525},{"$f":"E$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!C$6/1000","v":-15300},{"$f":"F$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!D$6/1000","v":-15606},{"$f":"G$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!E$6/1000","v":-15918.119999999999},{"$f":"H$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!F$6/1000","v":-16236.482400000001},{"$f":"I$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!G$6/1000","v":-16561.212048000001},{"$f":"J$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!H$6/1000","v":-16892.436288960002},{"$f":"K$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!I$6/1000","v":0},{"$f":"L$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!J$6/1000","v":0},{"$f":"M$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!K$6/1000","v":0},{"$f":"N$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!L$6/1000","v":0},{"$f":"O$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!M$6/1000","v":0},{"$f":"P$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!N$6/1000","v":0},{"$f":"Q$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!O$6/1000","v":0},{"$f":"R$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!P$6/1000","v":0},{"$f":"S$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Q$6/1000","v":0},{"$f":"T$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!R$6/1000","v":0},{"$f":"U$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!S$6/1000","v":0},{"$f":"V$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!T$6/1000","v":0},{"$f":"W$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!U$6/1000","v":0},{"$f":"X$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!V$6/1000","v":0},{"$f":"Y$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!W$6/1000","v":0},{"$f":"Z$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!X$6/1000","v":0},{"$f":"AA$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Y$6/1000","v":0},{"$f":"AB$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Z$6/1000","v":0},{"$f":"AC$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AA$6/1000","v":0},{"$f":"AD$94*(-SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AB$6/1000","v":0}]
[null,"Venda de terra",{"$f":"SUM(E228:AD228)","v":143415.09955738773},{"$f":"NPV(TxNom,E228:AD228)","v":45596.348696256297},{"$f":"E$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!C$6/1000","v":0},{"$f":"F$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!D$6/1000","v":0},{"$f":"G$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!E$6/1000","v":0},{"$f":"H$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!F$6/1000","v":0},{"$f":"I$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!G$6/1000","v":0},{"$f":"J$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!H$6/1000","v":0},{"$f":"K$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!I$6/1000","v":0},{"$f":"L$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!J$6/1000","v":0},{"$f":"M$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!K$6/1000","v":0},{"$f":"N$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!L$6/1000","v":0},{"$f":"O$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!M$6/1000","v":0},{"$f":"P$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!N$6/1000","v":0},{"$f":"Q$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!O$6/1000","v":0},{"$f":"R$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!P$6/1000","v":0},{"$f":"S$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Q$6/1000","v":0},{"$f":"T$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!R$6/1000","v":0},{"$f":"U$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!S$6/1000","v":0},{"$f":"V$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!T$6/1000","v":0},{"$f":"W$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!U$6/1000","v":0},{"$f":"X$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!V$6/1000","v":0},{"$f":"Y$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!W$6/1000","v":22734.995158468832},{"$f":"Z$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!X$6/1000","v":23189.695061638209},{"$f":"AA$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Y$6/1000","v":23653.488962870972},{"$f":"AB$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Z$6/1000","v":24126.558742128393},{"$f":"AC$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AA$6/1000","v":24609.089916970959},{"$f":"AD$98*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AB$6/1000","v":25101.27171531038}]
[null,"Arrendamento de terra",{"$f":"SUM(E229:AD229)","v":0},{"$f":"NPV(TxNom,E229:AD229)","v":0},{"$f":"E104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!C$6/1000","v":0},{"$f":"F104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!D$6/1000","v":0},{"$f":"G104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!E$6/1000","v":0},{"$f":"H104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!F$6/1000","v":0},{"$f":"I104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!G$6/1000","v":0},{"$f":"J104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!H$6/1000","v":0},{"$f":"K104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!I$6/1000","v":0},{"$f":"L104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!J$6/1000","v":0},{"$f":"M104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!K$6/1000","v":0},{"$f":"N104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!L$6/1000","v":0},{"$f":"O104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!M$6/1000","v":0},{"$f":"P104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!N$6/1000","v":0},{"$f":"Q104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!O$6/1000","v":0},{"$f":"R104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!P$6/1000","v":0},{"$f":"S104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!Q$6/1000","v":0},{"$f":"T104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!R$6/1000","v":0},{"$f":"U104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!S$6/1000","v":0},{"$f":"V104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!T$6/1000","v":0},{"$f":"W104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!U$6/1000","v":0},{"$f":"X104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!V$6/1000","v":0},{"$f":"Y104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!W$6/1000","v":0},{"$f":"Z104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!X$6/1000","v":0},{"$f":"AA104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!Y$6/1000","v":0},{"$f":"AB104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!Z$6/1000","v":0},{"$f":"AC104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!AA$6/1000","v":0},{"$f":"AD104*SUMPRODUCT($H$37:$H$39,$I$37:$I$39)*Financeiro!AB$6/1000","v":0}]
[null,"Valor investido em terra",null,null,{"$f":"E$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!C$6/1000","v":15300},{"$f":"F$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!D$6/1000","v":31212},{"$f":"G$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!E$6/1000","v":47754.36},{"$f":"H$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!F$6/1000","v":64945.929600000003},{"$f":"I$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!G$6/1000","v":82806.060239999992},{"$f":"J$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!H$6/1000","v":101354.61773375999},{"$f":"K$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!I$6/1000","v":103381.7100884352},{"$f":"L$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!J$6/1000","v":105449.34429020391},{"$f":"M$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!K$6/1000","v":107558.331176008},{"$f":"N$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!L$6/1000","v":109709.49779952817},{"$f":"O$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!M$6/1000","v":111903.68775551872},{"$f":"P$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!N$6/1000","v":114141.76151062909},{"$f":"Q$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!O$6/1000","v":116424.59674084168},{"$f":"R$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!P$6/1000","v":118753.08867565851},{"$f":"S$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Q$6/1000","v":121128.15044917169},{"$f":"T$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!R$6/1000","v":123550.71345815512},{"$f":"U$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!S$6/1000","v":126021.72772731824},{"$f":"V$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!T$6/1000","v":128542.1622818646},{"$f":"W$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!U$6/1000","v":131113.0055275019},{"$f":"X$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!V$6/1000","v":133735.26563805193},{"$f":"Y$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!W$6/1000","v":113674.97579234415},{"$f":"Z$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!X$6/1000","v":92758.780246552837},{"$f":"AA$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Y$6/1000","v":70960.466888612907},{"$f":"AB$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!Z$6/1000","v":48253.117484256785},{"$f":"AC$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AA$6/1000","v":24609.089916970952},{"$f":"AD$102*(SUMPRODUCT($G$37:$G$39,$I$37:$I$39))*Financeiro!AB$6/1000","v":0}]
[null,"Investimento em máquinas",null,null,{"$f":"E125*$I$32","v":0},-300,-360,-375,-390,-405,-420,-270,-270,-270,-270,-270,-270,-360,-360,-360,-360,-360,-360,-120,-60,-45,-30,-15,0,0]
[null,"Gestão florestal",{"$f":"SUM(E232:AD232)","v":-24000},{"$f":"NPV(TxNom,E232:AD232)","v":-13283.411857012186},{"$f":"E$105*$I$31/1000","v":-200},-400,-600,-800,-1000,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1200,-1000,-800,-600,-400,-200,0]
[null,"Impostos Federais",{"$f":"SUM(E233:AD233)","v":-93440.612160000004},{"$f":"NPV(TxNom,E233:AD233)","v":-43495.952408592311},{"$f":"-E221*Florestal!$C$5","v":0},{"$f":"-F221*Florestal!$C$5","v":0},{"$f":"-G221*Florestal!$C$5","v":0},{"$f":"-H221*Florestal!$C$5","v":0},{"$f":"-I221*Florestal!$C$5","v":0},{"$f":"-J221*Florestal!$C$5","v":0},{"$f":"-K221*Florestal!$C$5","v":0},{"$f":"-L221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-M221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-N221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-O221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-P221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-Q221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-R221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-S221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-T221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-U221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-V221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-W221*Florestal!$C$5","v":-5353.3684050000002},{"$f":"-X221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-Y221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-Z221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-AA221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-AB221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-AC221*Florestal!$C$5","v":-4866.6985500000001},{"$f":"-AD221*Florestal!$C$5","v":0}]
[]
[null,"Fluxo de Caixa Final (mil R$)","VPL (R$)",{"$f":"NPV(TxNom,E235:AD235)","v":109570.40079307578},{"$f":"E128+E221+E227+E228+E231+E229+E232+E233","v":-15500},-26306,-28878.12,-29911.482400000001,-30951.212048000001,-31997.436288960002,-15620,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,27175.276449999998,52170.271608468829,53339.971511638207,54518.765412870969,55706.83519212839,56904.366366970957,25101.27171531038]
[null,null,"TIR    (%)",{"$f":"IFERROR(IRR(E235:AD235),\"\")","v":9.8429224511675351E-2}]

{"sheet":"Financeiro","index":2,"n_rows":59,"n_cols":28,"rows_kept":59,"cut":false,"hidden":false,"merged":[[52,1,53,1],[30,1,30,27],[37,1,38,1],[7,1,7,8],[31,1,31,8],[0,1,0,8],[17,1,17,27],[21,1,21,27],[25,1,25,27],[44,1,45,1]]}
[null,"Premissas financeiras complementares"]
[null,"Variação real do preço de Terra",0.02,"a.a."]
[null,"Caixa",1000,"Exigência de caixa mínimo (mil R$)"]
[]
[null,null,{"$f":"Florestal!C2+1","v":2024},{"$f":"C5+1","v":2025},{"$f":"D5+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Índice Preço de Terra",{"$f":"(1+$C$2)","v":1.02},{"$f":"(1+$C$2)*C6","v":1.0404},{"$f":"(1+$C$2)*D6","v":1.0612079999999999},1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252]
[]
[null,"Fluxo Financeiro (mil R$)"]
[null,null,{"$f":"Florestal!E68","v":1},{"$f":"Florestal!F68","v":2},{"$f":"Florestal!G68","v":3},{"$f":"Florestal!H68","v":4},{"$f":"Florestal!I68","v":5},{"$f":"Florestal!J68","v":6},{"$f":"Florestal!K68","v":7},{"$f":"Florestal!L68","v":8},{"$f":"Florestal!M68","v":9},{"$f":"Florestal!N68","v":10},{"$f":"Florestal!O68","v":11},{"$f":"Florestal!P68","v":12},{"$f":"Florestal!Q68","v":13},{"$f":"Florestal!R68","v":14},{"$f":"Florestal!S68","v":15},{"$f":"Florestal!T68","v":16},{"$f":"Florestal!U68","v":17},{"$f":"Florestal!V68","v":18},{"$f":"Florestal!W68","v":19},{"$f":"Florestal!X68","v":20},{"$f":"Florestal!Y68","v":21},{"$f":"Florestal!Z68","v":22},{"$f":"Florestal!AA68","v":23},{"$f":"Florestal!AB68","v":24},{"$f":"Florestal!AC68","v":25},{"$f":"Florestal!AD68","v":26}]
[null,null,{"$f":"C5","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,"Receitas",{"$f":"Florestal!E221","v":0},{"$f":"Florestal!F221","v":0},{"$f":"Florestal!G221","v":0},{"$f":"Florestal!H221","v":0},{"$f":"Florestal!I221","v":0},{"$f":"Florestal!J221","v":0},{"$f":"Florestal!K221","v":0},{"$f":"Florestal!L221","v":79544.850000000006},{"$f":"Florestal!M221","v":79544.850000000006},{"$f":"Florestal!N221","v":79544.850000000006},{"$f":"Florestal!O221","v":79544.850000000006},{"$f":"Florestal!P221","v":79544.850000000006},{"$f":"Florestal!Q221","v":79544.850000000006},{"$f":"Florestal!R221","v":79544.850000000006},{"$f":"Florestal!S221","v":79544.850000000006},{"$f":"Florestal!T221","v":79544.850000000006},{"$f":"Florestal!U221","v":79544.850000000006},{"$f":"Florestal!V221","v":79544.850000000006},{"$f":"Florestal!W221","v":79544.850000000006},{"$f":"Florestal!X221","v":72313.5},{"$f":"Florestal!Y221","v":72313.5},{"$f":"Florestal!Z221","v":72313.5},{"$f":"Florestal!AA221","v":72313.5},{"$f":"Florestal!AB221","v":72313.5},{"$f":"Florestal!AC221","v":72313.5},{"$f":"Florestal!AD221","v":0}]
[null,"Despesas Operacionais",{"$f":"Florestal!E128","v":0},{"$f":"Florestal!F128","v":-10000},{"$f":"Florestal!G128","v":-12000},{"$f":"Florestal!H128","v":-12500},{"$f":"Florestal!I128","v":-13000},{"$f":"Florestal!J128","v":-13500},{"$f":"Florestal!K128","v":-14000},{"$f":"Florestal!L128","v":-47446.677499999998},{"$f":"Florestal!M128","v":-47446.677499999998},{"$f":"Florestal!N128","v":-47446.677499999998},{"$f":"Florestal!O128","v":-47446.677499999998},{"$f":"Florestal!P128","v":-47446.677499999998},{"$f":"Florestal!Q128","v":-47446.677499999998},{"$f":"Florestal!R128","v":-50446.677499999998},{"$f":"Florestal!S128","v":-50446.677499999998},{"$f":"Florestal!T128","v":-50446.677499999998},{"$f":"Florestal!U128","v":-50446.677499999998},{"$f":"Florestal!V128","v":-50446.677499999998},{"$f":"Florestal!W128","v":-50446.677499999998},{"$f":"Florestal!X128","v":-38951.525000000001},{"$f":"Florestal!Y128","v":-36951.525000000001},{"$f":"Florestal!Z128","v":-36451.525000000001},{"$f":"Florestal!AA128","v":-35951.525000000001},{"$f":"Florestal!AB128","v":-35451.525000000001},{"$f":"Florestal!AC128","v":-34951.525000000001},{"$f":"Florestal!AD128","v":0}]
[null,"Arrendamento",{"$f":"Florestal!E229","v":0},{"$f":"Florestal!F229","v":0},{"$f":"Florestal!G229","v":0},{"$f":"Florestal!H229","v":0},{"$f":"Florestal!I229","v":0},{"$f":"Florestal!J229","v":0},{"$f":"Florestal!K229","v":0},{"$f":"Florestal!L229","v":0},{"$f":"Florestal!M229","v":0},{"$f":"Florestal!N229","v":0},{"$f":"Florestal!O229","v":0},{"$f":"Florestal!P229","v":0},{"$f":"Florestal!Q229","v":0},{"$f":"Florestal!R229","v":0},{"$f":"Florestal!S229","v":0},{"$f":"Florestal!T229","v":0},{"$f":"Florestal!U229","v":0},{"$f":"Florestal!V229","v":0},{"$f":"Florestal!W229","v":0},{"$f":"Florestal!X229","v":0},{"$f":"Florestal!Y229","v":0},{"$f":"Florestal!Z229","v":0},{"$f":"Florestal!AA229","v":0},{"$f":"Florestal!AB229","v":0},{"$f":"Florestal!AC229","v":0},{"$f":"Florestal!AD229","v":0}]
[null,"Gestão Florestal",{"$f":"Florestal!E232","v":-200},{"$f":"Florestal!F232","v":-400},{"$f":"Florestal!G232","v":-600},{"$f":"Florestal!H232","v":-800},{"$f":"Florestal!I232","v":-1000},{"$f":"Florestal!J232","v":-1200},{"$f":"Florestal!K232","v":-1200},{"$f":"Florestal!L232","v":-1200},{"$f":"Florestal!M232","v":-1200},{"$f":"Florestal!N232","v":-1200},{"$f":"Florestal!O232","v":-1200},{"$f":"Florestal!P232","v":-1200},{"$f":"Florestal!Q232","v":-1200},{"$f":"Florestal!R232","v":-1200},{"$f":"Florestal!S232","v":-1200},{"$f":"Florestal!T232","v":-1200},{"$f":"Florestal!U232","v":-1200},{"$f":"Florestal!V232","v":-1200},{"$f":"Florestal!W232","v":-1200},{"$f":"Florestal!X232","v":-1200},{"$f":"Florestal!Y232","v":-1000},{"$f":"Florestal!Z232","v":-800},{"$f":"Florestal!AA232","v":-600},{"$f":"Florestal!AB232","v":-400},{"$f":"Florestal!AC232","v":-200},{"$f":"Florestal!AD232","v":0}]
[null,"PIS & Cofins",{"$f":"-(Florestal!$E$2+Florestal!$E$3)*C11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*D11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*E11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*F11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*G11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*H11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*I11","v":0},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*J11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*K11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*L11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*M11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*N11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*O11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*P11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*Q11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*R11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*S11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*T11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*U11","v":-2903.387025},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*V11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*W11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*X11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*Y11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*Z11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*AA11","v":-2639.4427499999997},{"$f":"-(Florestal!$E$2+Florestal!$E$3)*AB11","v":0}]
[null,"Deduções da Receita (Ex comissões)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Earnings Before Interest, Taxes, Depreciation and Amortization - EBITDA"]
[null,"EBITDA (mil R$)",{"$f":"SUM(C11:C16)","v":-200},-10400,-12600,-13300,-14000,-14700,-15200,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,29522.53225,31722.53225,32422.53225,33122.532249999997,33822.532249999997,34522.532249999997,0]
[null,"Depreciação",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Earnings Before Interest & Tax - EBIT"]
[null,"EBIT (mil R$)",{"$f":"SUM(C19:C20)","v":-200},-10400,-12600,-13300,-14000,-14700,-15200,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,29522.53225,31722.53225,32422.53225,33122.532249999997,33822.532249999997,34522.532249999997,0]
[null,"Despesas Financeiras",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Earnings Before Tax - EBT"]
[null,"EBT (mil R$)",{"$f":"SUM(C23:C24)","v":-200},-10400,-12600,-13300,-14000,-14700,-15200,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,27994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,24994.785475000008,29522.53225,31722.53225,32422.53225,33122.532249999997,33822.532249999997,34522.532249999997,0]
[null,"IRPJ, CSLL",{"$f":"-(Florestal!$E$4+Florestal!$E$5)*C11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*D11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*E11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*F11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*G11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*H11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*I11","v":0},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*J11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*K11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*L11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*M11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*N11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*O11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*P11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*Q11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*R11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*S11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*T11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*U11","v":-2449.9813800000002},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*V11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*W11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*X11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*Y11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*Z11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*AA11","v":-2227.2557999999999},{"$f":"-(Florestal!$E$4+Florestal!$E$5)*AB11","v":0}]
[]
[null,"Lucro Líquido (mil R$)",{"$f":"SUM(C27:C28)","v":-200},-10400,-12600,-13300,-14000,-14700,-15200,25544.804095000007,25544.804095000007,25544.804095000007,25544.804095000007,25544.804095000007,25544.804095000007,22544.804095000007,22544.804095000007,22544.804095000007,22544.804095000007,22544.804095000007,22544.804095000007,27295.276450000001,29495.276450000001,30195.276450000001,30895.276449999998,31595.276449999998,32295.276449999998,0]
[]
[null,"Fluxo de Caixa do Empreendimento Florestal (mil R$)"]
[null,"Investimento em Terra",{"$f":"SUM(Florestal!E227:E228)","v":-15300},{"$f":"SUM(Florestal!F227:F228)","v":-15606},{"$f":"SUM(Florestal!G227:G228)","v":-15918.119999999999},{"$f":"SUM(Florestal!H227:H228)","v":-16236.482400000001},{"$f":"SUM(Florestal!I227:I228)","v":-16561.212048000001},{"$f":"SUM(Florestal!J227:J228)","v":-16892.436288960002},{"$f":"SUM(Florestal!K227:K228)","v":0},{"$f":"SUM(Florestal!L227:L228)","v":0},{"$f":"SUM(Florestal!M227:M228)","v":0},{"$f":"SUM(Florestal!N227:N228)","v":0},{"$f":"SUM(Florestal!O227:O228)","v":0},{"$f":"SUM(Florestal!P227:P228)","v":0},{"$f":"SUM(Florestal!Q227:Q228)","v":0},{"$f":"SUM(Florestal!R227:R228)","v":0},{"$f":"SUM(Florestal!S227:S228)","v":0},{"$f":"SUM(Florestal!T227:T228)","v":0},{"$f":"SUM(Florestal!U227:U228)","v":0},{"$f":"SUM(Florestal!V227:V228)","v":0},{"$f":"SUM(Florestal!W227:W228)","v":0},{"$f":"SUM(Florestal!X227:X228)","v":0},{"$f":"SUM(Florestal!Y227:Y228)","v":22734.995158468832},{"$f":"SUM(Florestal!Z227:Z228)","v":23189.695061638209},{"$f":"SUM(Florestal!AA227:AA228)","v":23653.488962870972},{"$f":"SUM(Florestal!AB227:AB228)","v":24126.558742128393},{"$f":"SUM(Florestal!AC227:AC228)","v":24609.089916970959},{"$f":"SUM(Florestal!AD227:AD228)","v":25101.27171531038}]
[null,"Investimento em Equipamentos",{"$f":"Florestal!E231","v":0},{"$f":"Florestal!F231","v":-300},{"$f":"Florestal!G231","v":-360},{"$f":"Florestal!H231","v":-375},{"$f":"Florestal!I231","v":-390},{"$f":"Florestal!J231","v":-405},{"$f":"Florestal!K231","v":-420},{"$f":"Florestal!L231","v":-270},{"$f":"Florestal!M231","v":-270},{"$f":"Florestal!N231","v":-270},{"$f":"Florestal!O231","v":-270},{"$f":"Florestal!P231","v":-270},{"$f":"Florestal!Q231","v":-270},{"$f":"Florestal!R231","v":-360},{"$f":"Florestal!S231","v":-360},{"$f":"Florestal!T231","v":-360},{"$f":"Florestal!U231","v":-360},{"$f":"Florestal!V231","v":-360},{"$f":"Florestal!W231","v":-360},{"$f":"Florestal!X231","v":-120},{"$f":"Florestal!Y231","v":-60},{"$f":"Florestal!Z231","v":-45},{"$f":"Florestal!AA231","v":-30},{"$f":"Florestal!AB231","v":-15},{"$f":"Florestal!AC231","v":0},{"$f":"Florestal!AD231","v":0}]
[null,"Saldo Florestal",{"$f":"C30+C33+C34","v":-15500},-26306,-28878.12,-29911.482400000001,-30951.212048000001,-31997.436288960002,-15620,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,27175.276450000001,52170.271608468829,53339.971511638214,54518.765412870969,55706.83519212839,56904.366366970957,25101.27171531038]
[null,"Acumulado",{"$f":"C35","v":-15500},{"$f":"SUM($C$35:D35)","v":-41806},{"$f":"SUM($C$35:E35)","v":-70684.12},{"$f":"SUM($C$35:F35)","v":-100595.6024},{"$f":"SUM($C$35:G35)","v":-131546.81444799999},{"$f":"SUM($C$35:H35)","v":-163544.25073695998},{"$f":"SUM($C$35:I35)","v":-179164.25073695998},{"$f":"SUM($C$35:J35)","v":-153889.44664195998},{"$f":"SUM($C$35:K35)","v":-128614.64254695998},{"$f":"SUM($C$35:L35)","v":-103339.83845195998},{"$f":"SUM($C$35:M35)","v":-78065.034356959979},{"$f":"SUM($C$35:N35)","v":-52790.230261959972},{"$f":"SUM($C$35:O35)","v":-27515.426166959965},{"$f":"SUM($C$35:P35)","v":-5330.6220719599587},{"$f":"SUM($C$35:Q35)","v":16854.182023040048},{"$f":"SUM($C$35:R35)","v":39038.986118040055},{"$f":"SUM($C$35:S35)","v":61223.790213040062},{"$f":"SUM($C$35:T35)","v":83408.594308040076},{"$f":"SUM($C$35:U35)","v":105593.39840304008},{"$f":"SUM($C$35:V35)","v":132768.67485304008},{"$f":"SUM($C$35:W35)","v":184938.94646150892},{"$f":"SUM($C$35:X35)","v":238278.91797314712},{"$f":"SUM($C$35:Y35)","v":292797.68338601809},{"$f":"SUM($C$35:Z35)","v":348504.51857814647},{"$f":"SUM($C$35:AA35)","v":405408.8849451174},{"$f":"SUM($C$35:AB35)","v":430510.15666042781}]
[]
[null,"Otimização do aporte de capital",{"$f":"C9","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,{"$f":"C10","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[]
[null,{"$f":"SUM(C43:AB43)","v":0},"Total",null,null,"soma("]
[null,{"$f":"NPV(TxNom,C43:AB43)","v":0},"Valor presente"]
[null,"Aporte de capital"]
[null,"Saldo Após aporte",{"$f":"C35+C43","v":-15500},-26306,-28878.12,-29911.482400000001,-30951.212048000001,-31997.436288960002,-15620,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,27175.276450000001,52170.271608468829,53339.971511638214,54518.765412870969,55706.83519212839,56904.366366970957,25101.27171531038]
[null,"Restrição",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">="]
[null,null,{"$f":"$C$3","v":1000},{"$f":"$C$3","v":1000},{"$f":"$C$3","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"$C$3","v":1000}]
[null,"Saldo Acumulado após aporte",{"$f":"C44","v":-15500},{"$f":"D44+C47","v":-41806},-70684.12,-100595.6024,-131546.81444799999,-163544.25073695998,-179164.25073695998,-153889.44664195998,-128614.64254695998,-103339.83845195998,-78065.034356959979,-52790.230261959972,-27515.426166959965,-5330.6220719599587,16854.182023040048,39038.986118040055,61223.790213040062,83408.594308040076,105593.39840304008,132768.67485304008,184938.94646150892,238278.91797314712,292797.68338601809,348504.51857814647,405408.8849451174,430510.15666042781]
[]
[null,{"$f":"SUM(C51:AB51)","v":0},"Total"]
[null,{"$f":"NPV(TxNom,C51:AB51)","v":0},"Valor presente"]
[null,"Devolução do aporte de capital"]
[null,"Saldo Após pagamento ao Capitalista",{"$f":"C44-C51","v":-15500},{"$f":"D44-D51","v":-26306},-28878.12,-29911.482400000001,-30951.212048000001,-31997.436288960002,-15620,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,25274.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,22184.804095000007,27175.276450000001,52170.271608468829,53339.971511638214,54518.765412870969,55706.83519212839,56904.366366970957,25101.27171531038]
[null,"Restrição",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">=",">="]
[null,null,{"$f":"$C$3","v":1000},{"$f":"$C$3","v":1000},{"$f":"$C$3","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"$C$3","v":1000}]
[null,"Saldo Acumulado após pagamento",{"$f":"C52","v":-15500},{"$f":"D52+C55","v":-41806},-70684.12,-100595.6024,-131546.81444799999,-163544.25073695998,-179164.25073695998,-153889.44664195998,-128614.64254695998,-103339.83845195998,-78065.034356959979,-52790.230261959972,-27515.426166959965,-5330.6220719599587,16854.182023040048,39038.986118040055,61223.790213040062,83408.594308040076,105593.39840304008,132768.67485304008,184938.94646150892,238278.91797314712,292797.68338601809,348504.51857814647,405408.8849451174,430510.15666042781]
[]
[null,"Fluxo de caixa do capitalista (mil R$)",{"$f":"C55-C47","v":0},{"$f":"D55-D47","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(NPV(TxNom,C57:AB57),\"\")","v":0},"VPL (R$)"]
[null,{"$f":"IFERROR(IRR(C57:AB57),\"\")","v":""},"TIR    (%)"]