{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["6x7 ArredondadoSim","6x7 ArredondadoNao","Gráfico","Macros"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico","index":2,"reason":"not_a_worksheet"},{"sheet":"Macros","index":3,"reason":"part_missing"}],"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":"6x7 ArredondadoSim","index":0,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Estratos 1:  Está em segunda rotação, com 6 anos de idade",null,null,null,null,null,null,null,null,null,null,"Taxa","VP Custos","VP Receitas","R-C"]
[null,"Taxa =",7.0000000000000007E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":28},null,"Valor Presente Líquido",null,{"$f":"IF(AND((N2-M2)>0,(N3-M3)<0),\"=>\",\"\")","v":""},null,null,null,{"$f":"IF(L2=\"\",\"\",N2-M2)","v":""},"Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":9229.0944404221464},{"$f":"IF(AND((N3-M3)>0,(N4-M4)<0),\"=>\",\"\")","v":""},null,null,null,{"$f":"IF(L3=\"\",\"\",N3-M3)","v":""}]
[null,"Custos",null,null,null,"Receitas",null,null,null,null,"",null,null,null,""]
[null,null,{"$f":"SUM(C7:C106)","v":1483.0616974986856},{"$f":"SUM(D7:D106)","v":9860.6375101434896},null,null,{"$f":"SUM(G7:G106)","v":10712.156137920832},{"$f":"SUM(H7:H106)","v":71223.394688331624},"Valor Futuro Líquido",null,"",null,null,null,""]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","VFL=",{"$f":"H5-D5","v":61362.757178188134},"",null,null,null,""]
[0,null,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":0},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0},null,null,"",null,null,null,""]
[1,null,0,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":0},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"Razão Benefício/Custo",null,"",null,null,null,""]
[2,1200,1048.126473927854,6968.8235099177919,null,{"$f":"378*12","v":4536},3961.9180714472877,26342.152867489251,"B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":7.2230010093226928},"",null,null,null,""]
[3,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[4,null,0,0,null,null,0,0,"Valor Esperado da Terra",null,"",null,null,null,""]
[5,null,0,0,null,null,0,0,"VET=",{"$f":"IF(A7=\"\",0,IF(C2=0,0,(H5-D5)/((1+C2)^G2-1)))","v":10862.89839198162},"",null,null,null,""]
[6,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[7,null,0,0,null,null,0,0,"VPL Anualizado",null,"",null,null,null,""]
[8,null,0,0,null,{"$f":"355*12","v":4260},2479.3587854470638,16484.855810191126,"VPLA=",{"$f":"IF(G2=0,0,IF(C2=0,0,((H5-D5)*C2)/((1+C2)^G2-1)))","v":760.40288743871349},"",null,null,null,""]
[9,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[10,null,0,0,null,null,0,0,"TIR (tentativo)",null,"",null,null,null,""]
[11,null,0,0,null,null,0,0,null,"Intervalo tentativo de taxas","",null,null,null,""]
[12,null,0,0,null,null,0,0,"Máxima",0.25,"",null,null,null,""]
[13,null,0,0,null,null,0,0,"Mínima",0,"",null,null,null,""]
[14,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[15,1200,434.93522357083162,2891.8140002256978,null,{"$f":"378*12","v":4536},1644.0551450977434,10931.056920853138,"TIR (sup)=",{"$f":"IF($L$2=\"\",\"Use macro\",$J$23+($L$27-$L$2)/25)","v":"Use macro"},"",null,null,null,""]
[16,null,0,0,null,null,0,0,"TIR  (inf)=",{"$f":"IF($L$2=\"\",\"Use macro\",VLOOKUP(\"=>\",$K$2:$L$27,2,FALSE))","v":"Use macro"},"",null,null,null,""]
[17,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[18,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[19,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[20,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[21,null,0,0,null,{"$f":"355*12","v":4260},1028.845749520636,6840.6290897981125,{"$f":"((10.4*(1-EXP(-0.25*6)))^2.81)","v":354.60291200607651}]
[22,null,0,0,null,null,0,0,null,null,null,null,null,2]
[23,null,0,0,null,null,0,0]
[24,null,0,0,null,null,0,0]
[25,null,0,0,null,null,0,0]
[26,null,0,0,null,null,0,0]
[27,null,0,0,null,null,0,0]
[28,null,0,0,null,{"$f":"378*12+6088.7","v":10624.7},1597.978386408101,10624.7,{"$f":"((14*(1-EXP(-0.24*7)))^2.44)","v":378.43299510449208}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"6x7 ArredondadoNao","index":1,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Estratos 1:  Está em segunda rotação, com 6 anos de idade",null,null,null,null,null,null,null,null,null,null,"Taxa","VP Custos","VP Receitas","R-C"]
[null,"Taxa =",7.0000000000000007E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":28},null,"Valor Presente Líquido",null,{"$f":"IF(AND((N2-M2)>0,(N3-M3)<0),\"=>\",\"\")","v":""},null,null,null,{"$f":"IF(L2=\"\",\"\",N2-M2)","v":""},"Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":9232.3733767303875},{"$f":"IF(AND((N3-M3)>0,(N4-M4)<0),\"=>\",\"\")","v":""},null,null,null,{"$f":"IF(L3=\"\",\"\",N3-M3)","v":""}]
[null,"Custos",null,null,null,"Receitas",null,null,null,null,"",null,null,null,""]
[null,null,{"$f":"SUM(C7:C106)","v":1483.0616974986856},{"$f":"SUM(D7:D106)","v":9860.6375101434896},null,null,{"$f":"SUM(G7:G106)","v":10715.435074229074},{"$f":"SUM(H7:H106)","v":71245.195805850177},"Valor Futuro Líquido",null,"",null,null,null,""]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","VFL=",{"$f":"H5-D5","v":61384.558295706687},"",null,null,null,""]
[0,null,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":0},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0},null,null,"",null,null,null,""]
[1,null,0,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":0},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"Razão Benefício/Custo",null,"",null,null,null,""]
[2,1200,1048.126473927854,6968.8235099177919,null,{"$f":"((14*(1-EXP(-0.24*7)))^2.44)*12","v":4541.1959412539054},3966.4564077682812,26372.327532127892,"B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":7.2252119330582136},"",null,null,null,""]
[3,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[4,null,0,0,null,null,0,0,"Valor Esperado da Terra",null,"",null,null,null,""]
[5,null,0,0,null,null,0,0,"VET=",{"$f":"IF(A7=\"\",0,IF(C2=0,0,(H5-D5)/((1+C2)^G2-1)))","v":10866.757790341899},"",null,null,null,""]
[6,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[7,null,0,0,null,null,0,0,"VPL Anualizado",null,"",null,null,null,""]
[8,null,0,0,null,{"$f":"((10.4*(1-EXP(-0.25*6)))^2.81)*12","v":4255.2349440729176},2476.5854795137402,16466.416547307217,"VPLA=",{"$f":"IF(G2=0,0,IF(C2=0,0,((H5-D5)*C2)/((1+C2)^G2-1)))","v":760.67304532393302},"",null,null,null,""]
[9,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[10,null,0,0,null,null,0,0,"TIR (tentativo)",null,"",null,null,null,""]
[11,null,0,0,null,null,0,0,null,"Intervalo tentativo de taxas","",null,null,null,""]
[12,null,0,0,null,null,0,0,"Máxima",0.25,"",null,null,null,{"$f":"IF(L19=\"\",\"\",N19-M19)","v":""}]
[13,null,0,0,null,null,0,0,"Mínima",0,"",null,null,null,""]
[14,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[15,1200,434.93522357083162,2891.8140002256978,null,{"$f":"((14*(1-EXP(-0.24*7)))^2.44)*12","v":4541.1959412539054},1645.9383933235169,10943.578333905132,"TIR (sup)=",{"$f":"IF($L$2=\"\",\"Use macro\",$J$23+($L$27-$L$2)/25)","v":"Use macro"},"",null,null,null,""]
[16,null,0,0,null,null,0,0,"TIR  (inf)=",{"$f":"IF($L$2=\"\",\"Use macro\",VLOOKUP(\"=>\",$K$2:$L$27,2,FALSE))","v":"Use macro"},"",null,null,null,""]
[17,null,0,{"$f":"IF(A24=\"\",\"\",B24*(1+$C$2)^($G$2-A24))","v":0},null,null,0,{"$f":"IF(A24=\"\",\"\",F24*(1+$C$2)^($G$2-A24))","v":0},null,null,"",null,null,null,""]
[18,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[19,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[20,null,0,0,null,null,0,0,null,null,"",null,null,null,""]
[21,null,0,0,null,{"$f":"((10.4*(1-EXP(-0.25*6)))^2.81)*12","v":4255.2349440729176},1027.6949261551886,6832.9774512560198]
[22,null,0,0,null,null,0,0,null,null,null,null,null,2]
[23,null,0,0,null,null,0,0]
[24,null,0,0,null,null,0,0]
[25,null,0,0,null,null,0,0]
[26,null,0,0,null,null,0,0]
[27,null,0,0,null,null,0,0]
[28,null,0,0,null,{"$f":"((14*(1-EXP(-0.24*7)))^2.44)*12+6088.7","v":10629.895941253904},1598.7598674683459,10629.895941253904]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,{"$f":"IF(A39=\"\",\"\",B39/(1+$C$2)^A39)","v":""},"",null,null,{"$f":"IF(A39=\"\",\"\",F39/(1+$C$2)^A39)","v":""},""]
[null,null,"",{"$f":"IF(A40=\"\",\"\",B40*(1+$C$2)^($G$2-A40))","v":""},null,null,"",{"$f":"IF(A40=\"\",\"\",F40*(1+$C$2)^($G$2-A40))","v":""}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A56=\"\",\"\",B56*(1+$C$2)^($G$2-A56))","v":""},null,null,"",{"$f":"IF(A56=\"\",\"\",F56*(1+$C$2)^($G$2-A56))","v":""}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A88=\"\",\"\",B88*(1+$C$2)^($G$2-A88))","v":""},null,null,"",{"$f":"IF(A88=\"\",\"\",F88*(1+$C$2)^($G$2-A88))","v":""}]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]