{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Avaliação de Projetos","Gráfico","Macros"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico","index":1,"reason":"not_a_worksheet"},{"sheet":"Macros","index":2,"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":"Avaliação de Projetos","index":0,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Taxa","VP Custos","VP Receitas","R-C"]
[null,"Taxa =",0,null,null,"n =",{"$f":"MAX(A7:A106)","v":0},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":0},{"$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":0},{"$f":"SUM(D7:D106)","v":0},null,null,{"$f":"SUM(G7:G106)","v":0},{"$f":"SUM(H7:H106)","v":0},"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":0},"",null,null,null,""]
[null,null,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":""},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":""},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":""},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":""},null,null,"",null,null,null,""]
[null,null,"",{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":""},null,null,"",{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":""},"Razão Benefício/Custo",null,"",null,null,null,""]
[null,null,"","",null,null,"","","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":0},"",null,null,null,""]
[null,null,"","",null,null,"","",null,null,"",null,null,null,""]
[null,null,"","",null,null,"","","Valor Esperado da Terra",null,"",null,null,null,""]
[null,null,"","",null,null,"","","VET=",{"$f":"IF(A7=\"\",0,IF(C2=0,0,(H5-D5)/((1+C2)^G2-1)))","v":0},"",null,null,null,""]
[null,null,"","",null,null,"","",null,null,"",null,null,null,""]
[null,null,"","",null,null,"","","VPL Anualizado",null,"",null,null,null,""]
[null,null,"","",null,null,"","","VPLA=",{"$f":"IF(G2=0,0,IF(C2=0,0,((H5-D5)*C2)/((1+C2)^G2-1)))","v":0},"",null,null,null,""]
[null,null,"","",null,null,"","",null,null,"",null,null,null,""]
[null,null,"","",null,null,"","","TIR (tentativo)",null,"",null,null,null,""]
[null,null,"","",null,null,"","",null,"Intervalo tentativo de taxas","",null,null,null,""]
[null,null,"","",null,null,"","","Máxima",0.25,"",null,null,null,{"$f":"IF(L19=\"\",\"\",N19-M19)","v":""}]
[null,null,"","",null,null,"","","Mínima",0,"",null,null,null,""]
[null,null,"","",null,null,"","",null,null,"",null,null,null,""]
[null,null,"","",null,null,"","","TIR (sup)=",{"$f":"IF($L$2=\"\",\"Use macro\",$J$23+($L$27-$L$2)/25)","v":"Use macro"},"",null,null,null,""]
[null,null,"","",null,null,"","","TIR  (inf)=",{"$f":"IF($L$2=\"\",\"Use macro\",VLOOKUP(\"=>\",$K$2:$L$27,2,FALSE))","v":"Use macro"},"",null,null,null,""]
[null,null,"",{"$f":"IF(A24=\"\",\"\",B24*(1+$C$2)^($G$2-A24))","v":""},null,null,"",{"$f":"IF(A24=\"\",\"\",F24*(1+$C$2)^($G$2-A24))","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,2]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",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(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":""}]