{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Avalia Projeto","Macros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Macros","index":1,"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 Projeto","index":0,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",0.01,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,null,"VPL=",{"$f":"G5-C5","v":139073.13545938209}]
[null,"Investimentos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":16130105.879709318},{"$f":"SUM(D7:D106)","v":18175807.043935314},null,null,{"$f":"SUM(G7:G106)","v":16269179.0151687},{"$f":"SUM(H7:H106)","v":18332518.133989882},"Valor Futuro Líquido"]
["Mês","Valor","Mês 0","Mês n ",null,"Valor","Mês 0","Mês n ","VFL=",{"$f":"H5-D5","v":156711.0900545679}]
[0,500000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":500000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":563412.51506598492},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,1234000,1221782.1782178218,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":1376734.7397850007},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"Razão Benefício/Custo"]
[2,1649243,1616746.3974120184,1821790.3079795516,null,null,0,0,"B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1.0086219604816313}]
[3,439500,426574.37001419975,480674.67734477669,null,4380000,4251184.8479230832,4790341.4943575021]
[4,280000,269074.49645518855,303199.87757586245,null,null,0,0,"Valor Esperado da Terra"]
[5,1987540,1891076.1127459176,2130911.8977267663,null,null,0,0,"VET=",{"$f":"IF(A7=\"\",0,IF(C2=0,0,(H5-D5)/((1+C2)^G2-1)))","v":1235647.9623265197}]
[6,2803713.1,2641224.5668748012,2976197.952153997,null,4380000,4126158.1304134252,4649458.2596323807]
[7,659250,614894.37756567914,692878.37552842498,null,null,0,0,"VPL Anualizado"]
[8,1391278,1284821.8908087462,1447769.4658247801,null,null,0,0,"VPLA=",{"$f":"IF(G2=0,0,IF(C2=0,0,((H5-D5)*C2)/((1+C2)^G2-1)))","v":12356.479623265195}]
[9,1962599.17,1794482.5801511989,2022067.8874501698,null,4380000,4004808.4301708187,4512718.38]
[10,461475,417767.29741694435,470750.64750000002,null,null,0,0]
[11,3654870,3275946.665444301,3691418.7,null,null,0,0]
[12,198000,175714.94660250042,198000,null,4380000,3887027.6066613728,4380000]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,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,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":""}]