{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Investimentos","Demanda","Custos Variáveis","Custos Fixos","Custos Administrativos","Custo Mão de Obra","Depreciação ","Manutenção","Resumo","Resultado do PROJETO","Receita ICMBio","Análise de Sensibilidade"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Investimentos","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,1,2,5],[32,1,32,3]],"flags":["formulas_cached_only"]}
["INVESTIMENTOS"]
["Descrição","Quantidade","Unid","Custo Unitário","Custo total","Referência"]
["OBRAS CIVIS e BENS"]
["Reforma das lanchonetes ",0,"m²",1000,0]
["FoodTruck/ quiosque",1,"Unid",48000,48000,"EVE Chapada dos Veadeiros"]
["SUB-TOTAL OBRAS",null,null,null,48000]
["EQUIPAMENTOS"]
["mesas",12,"und.",150,1800,"EVE Chapada dos Veadeiros"]
["cadeiras",40,"und.",65,2600,"EVE Chapada dos Veadeiros"]
["balcão de atendimento",0,"und.",600,0,"EVE Chapada dos Veadeiros"]
["expositor em aço",1,"und.",600,600,"EVE Chapada dos Veadeiros"]
["freezer horizontal",0,"und.",2500,0,"EVE Chapada dos Veadeiros"]
["geladeira de bebidas",1,"und.",2500,2500,"EVE Chapada dos Veadeiros"]
["microondas",1,"und.",400,400,"EVE Chapada dos Veadeiros"]
["Liquidificador ",2,"und.",150,300,"EVE Chapada dos Veadeiros"]
["Torradeira",1,"und.",70,70,"EVE Chapada dos Veadeiros"]
["Forno",1,"und.",400,400,"EVE Chapada dos Veadeiros"]
["Louças/ utensílios",1,"und.",750,750,"EVE Chapada dos Veadeiros"]
["armários e outros",1,"unid",700,700,"EVE Chapada dos Veadeiros"]
["chapa/ sanduicheria",1,"unid",200,200]
["cozinha industrial",0,"und.",3000,0,"EVE Chapada dos Veadeiros"]
["márquina de expresso",1,"und.",400,400,"EVE Chapada dos Veadeiros"]
["cafeteira convencional",1,"unid",100,100,"EVE Chapada dos Veadeiros"]
["aparelho de TV",0,"und.",1200,0,"EVE Chapada dos Veadeiros"]
["Aparelho de som",0,"und.",650,0,"EVE Chapada dos Veadeiros"]
["automação das lojas",1,"und.",3050,3050,"EVE Chapada dos Veadeiros"]
["sistema de segurança",0,"und.",5000,0,"EVE Chapada dos Veadeiros"]
["impressora fiscal",2,"und.",600,1200,"EVE Chapada dos Veadeiros"]
["lixeiras",2,"Unid",100,200]
["sistema de comunicação",0,"und.",4200,0,"EVE Chapada dos Veadeiros"]
["gerador",1,"und.",2500,2500]
["SUB-TOTAL EQUIPAMENTOS",null,null,null,17770]
["outros (alvarás, cardápio,...)",0.1,null,null,6577]
["TOTAL",null,null,null,72347]

{"sheet":"Demanda","index":1,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[44,0,44,5],[1,0,1,5],[43,0,43,5],[5,12,5,15]],"flags":["formulas_cached_only"]}
[]
["Evolução da Demanda serviços de alimentação"]
["Ano","Taxa de Crescimento","Número Total de Visitantes finais de semana e feriados","Número de Visitantes consumidores da lanchonete e quiosque","Projeção de Receita Total (com taxa ICMBIo)","Projeção de Receita Privada sem quiosque (sem taxa ICMBio)","Projeção de Receita Privada com quiosque (sem taxa ICMBio)","Porcentagem de Pagantes","Preço do ticket médio de gasto","Valor para ICMBio","Percentual da tx ICMBio sobre o preço de cobrança (%)"]
[1,0.1,25424.999999999996,8568.224999999999,124767.49545956818,86445,128243.7,0.337,14.967359050445106,0.4057088300589459,2.710624023193195]
[2,0.1,27967.5,9425.0475,137244.24500552504,95089.5,141068.07,{"$nulls":4},"Serviços","Porcentagem de Pagantes do serviço","Preço do ticket médio de cobrança","total de visitantes","receita total"]
[3,0.1,30764.250000000004,10367.552250000002,150968.66950607757,104598.45,155174.877,{"$nulls":4},"quiosque","Camping já está sendo contabilizado diretamente na Receita Bruta (sem taxas ICMBio), pois o percentual de consumidores é menor do que o da lanchonete."]
[4,0.1,33840.67500000001,11404.307475000005,166065.53645668534,115058.295,170692.36470000003,{"$nulls":4},"lanchonete",0.2,17,25424.999999999996,86445]
[5,0.1,37224.742500000015,12544.738222500006,182672.0901023539,126564.1245,187761.60117000004,{"$nulls":4},"GERAL sem quiosque",0.2,17,25424.999999999996,86445]
[6,0.02,37969.23735000002,12795.632986950006,186325.53190440097,129095.40699,191516.83319340003,{"$nulls":4},"GERAL com quiosque",0.337,14.967359050445106,25424.999999999996,128243.7]
[7,0.02,38728.62209700002,13051.545646689008,190052.042542489,131677.3151298,195347.16985726805]
[8,0.02,39503.19453894002,13312.576559622788,193853.0833933388,134310.861432396,199254.1132544134]
[9,0.02,40293.25842971882,13578.828090815245,197730.14506120558,136997.07866104392,203239.1955195017]
[10,0.02,41099.1235983132,13850.404652631549,201684.74796242968,139737.0202342648,207303.9794298917]
[11,0.02,41921.106070279464,14127.41274568418,205718.44292167827,142531.7606389501,211450.05901848956]
[12,0.02,42759.52819168505,14409.961000597863,209832.81178011184,145382.39585172912,215679.06019885934]
[13,0.02,43614.718755518756,14698.160220609821,214029.46801571408,148290.0437687637,219992.64140283654]
[14,0.02,44487.01313062913,14992.123425022017,218310.05737602836,151255.84464413897,224392.49423089327]
[15,0.02,45376.753393241714,15291.965893522458,222676.25852354892,154280.96153702174,228880.3441155111]
[16,0.02,46284.288461106546,15597.805211392906,227129.7836940199,157366.58076776218,233457.95099782135]
[17,0.02,47209.97423032868,15909.761315620764,231672.37936790028,160513.91238311742,238127.11001777777]
[18,0.02,48154.17371493525,16227.95654193318,236305.8269552583,163724.19063077978,242889.65221813333]
[19,0.02,49117.257189233955,16552.515672771842,241031.94349436346,166998.67444339537,247747.445262496]
[20,0.02,50099.602333018636,16883.56598622728,245852.58236425073,170338.64793226327,252702.3941677459]
[21,0.02,51101.59437967901,17221.23730595183,250769.6340115358,173745.42089090854,257756.44205110084]
[22,0.02,52123.62626727259,17565.662052070864,255785.02669176648,177220.3293087267,262911.57089212287]
[23,0.02,53166.098792618046,17916.975293112282,260900.72722560185,180764.73589490124,268169.8023099653]
[24,0.02,54229.42076847041,18275.31479897453,266118.74177011393,184380.03061279928,273533.1983561646]
[25,0.02,55314.009183839815,18640.82109495402,271441.1166055162,188067.63122505526,279003.86232328793]
{"$rows_empty":15}
["QUIOSQUE/FOODTRUCK"]
["Evolução da Demanda"]
["Ano","Taxa de Crescimento","Número Total de Visitantes","Número de Visitantes consumidores","Projeção de Receita do Quiosque","Projeção de Receita Privada",null,null,"Porcentagem de visitantes pagantes","Ticket médio"]
[1,0.1,25424.999999999996,3483.225,41798.7,41798.7,null,null,0.137,12]
[2,0.1,27967.5,3831.5475,45978.57,45978.57]
[3,0.1,30764.250000000004,4214.702250000001,50576.42700000001,50576.42700000001]
[4,0.1,33840.67500000001,4636.172475000002,55634.06970000002,55634.06970000002]
[5,0.1,37224.742500000015,5099.789722500002,61197.47667000003,61197.47667000003]
[6,0.02,37969.23735000002,5201.785516950003,62421.42620340003,62421.42620340003]
[7,0.02,38728.62209700002,5305.821227289003,63669.85472746804,63669.85472746804]
[8,0.02,39503.19453894002,5411.9376518347835,64943.2518220174,64943.2518220174]
[9,0.02,40293.25842971882,5520.1764048714795,66242.11685845775,66242.11685845775]
[10,0.02,41099.1235983132,5630.579932968909,67566.9591956269,67566.9591956269]
[11,0.02,41921.106070279464,5743.191531628287,68918.29837953944,68918.29837953944]
[12,0.02,42759.52819168505,5858.055362260852,70296.66434713022,70296.66434713022]
[13,0.02,43614.718755518756,5975.21646950607,71702.59763407284,71702.59763407284]
[14,0.02,44487.01313062913,6094.720798896191,73136.6495867543,73136.6495867543]
[15,0.02,45376.753393241714,6216.615214874115,74599.38257848937,74599.38257848937]
[16,0.02,46284.288461106546,6340.947519171597,76091.37023005917,76091.37023005917]
[17,0.02,47209.97423032868,6467.766469555029,77613.19763466035,77613.19763466035]
[18,0.02,48154.17371493525,6597.121798946129,79165.46158735355,79165.46158735355]
[19,0.02,49117.257189233955,6729.064234925052,80748.77081910062,80748.77081910062]
[20,0.02,50099.602333018636,6863.645519623554,82363.74623548264,82363.74623548264]
[21,0.02,51101.59437967901,7000.918430016025,84011.0211601923,84011.0211601923]
[22,0.02,52123.62626727259,7140.936798616346,85691.24158339616,85691.24158339616]
[23,0.02,53166.098792618046,7283.755534588673,87405.06641506408,87405.06641506408]
[24,0.02,54229.42076847041,7429.430645280447,89153.16774336537,89153.16774336537]
[25,0.02,55314.009183839815,7578.019258186056,90936.23109823267,90936.23109823267]

{"sheet":"Custos Variáveis","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,3,3,3],[2,0,4,0],[0,0,0,5],[2,1,3,1],[2,2,3,2],[1,0,1,5],[2,4,3,4],[2,5,3,5]],"flags":["formulas_cached_only"]}
[]
["CUSTOS VARIÁVEIS"]
["ANOS","Movimentação Total","Manutenção","custo dos produtos","Combustível","Custos Variáveis Total"]
[]
[null,null,"R$","R$","R$","R$"]
[1,8568.224999999999,0,41037.984,4000,45037.984]
[2,9425.0475,6701.6,45141.782400000004,4000,55843.3824]
[3,10367.552250000002,6701.6,49655.960640000005,4000,60357.56064]
[4,11404.307475000005,6701.6,54621.55670400001,4000,65323.15670400001]
[5,12544.738222500006,6701.6,60083.71237440001,4000,70785.31237440002]
[6,12795.632986950006,6701.6,61285.386621888014,4000,71986.98662188802]
[7,13051.545646689008,6701.6,62511.094354325774,4000,73212.69435432578]
[8,13312.576559622788,6701.6,63761.316241412285,4000,74462.91624141228]
[9,13578.828090815245,6701.6,65036.54256624054,4000,75738.14256624054]
[10,13850.404652631549,6701.6,66337.27341756535,4000,77038.87341756535]
[11,14127.41274568418,6701.6,67664.01888591665,4000,78365.61888591666]
[12,14409.961000597863,6701.6,69017.299263635,4000,79718.899263635]
[13,14698.160220609821,6701.6,70397.64524890769,4000,81099.2452489077]
[14,14992.123425022017,6701.6,71805.59815388585,4000,82507.19815388585]
[15,15291.965893522458,6701.6,73241.71011696356,4000,83943.31011696356]
[16,15597.805211392906,6701.6,74706.54431930283,4000,85408.14431930284]
[17,15909.761315620764,6701.6,76200.6752056889,4000,86902.2752056889]
[18,16227.95654193318,6701.6,77724.68870980266,4000,88426.28870980267]
[19,16552.515672771842,6701.6,79279.18248399872,4000,89980.78248399873]
[20,16883.56598622728,6701.6,80864.76613367868,4000,91566.36613367869]
[21,17221.23730595183,6701.6,82482.06145635227,4000,93183.66145635227]
[22,17565.662052070864,6701.6,84131.70268547932,4000,94833.30268547933]
[23,17916.975293112282,6701.6,85814.3367391889,4000,96515.93673918891]
[24,18275.31479897453,6701.6,87530.62347397268,4000,98232.22347397268]
[25,18640.82109495402,6701.6,89281.23594345213,4000,99982.83594345214]

{"sheet":"Custos Fixos","index":3,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,4],[2,0,3,0]],"flags":["formulas_cached_only"]}
[" CUSTOS FIXOS"]
[]
["ANOS","Mão-de-obra Administrativa","Mão-de-obra de finais de semana","Custos Administrativos Fixos","Custos Fixos Total"]
[null,"R$","R$","R$","R$"]
[1,35940,6000,16680,58620]
[2,35940,6000,16680,58620]
[3,35940,6000,16680,58620]
[4,35940,6000,16680,58620]
[5,35940,6000,16680,58620]
[6,35940,6000,16680,58620]
[7,35940,6000,16680,58620]
[8,35940,6000,16680,58620]
[9,35940,6000,16680,58620]
[10,35940,6000,16680,58620]
[11,35940,6000,16680,58620]
[12,35940,6000,16680,58620]
[13,35940,6000,16680,58620]
[14,35940,6000,16680,58620]
[15,35940,6000,16680,58620]
[16,35940,6000,16680,58620]
[17,35940,6000,16680,58620]
[18,35940,6000,16680,58620]
[19,35940,6000,16680,58620]
[20,35940,6000,16680,58620]
[21,35940,6000,16680,58620]
[22,35940,6000,16680,58620]
[23,35940,6000,16680,58620]
[24,35940,6000,16680,58620]
[25,35940,6000,16680,58620]
[]
[]
[]
[null,720000]
[null,1177920]
[null,900000]
[null,294480]

{"sheet":"Custos Administrativos","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["Custos Administrativos"]
["Discriminação","Custo Mensal (R$)","Custo Anual (R$)"]
["Contador",500,6000]
["despesas bancárias",50,600]
["produção de NF",50,600]
["telefone",100,1200]
["aluguel",0,0]
["gás de cozinha",125,1500]
["água",70,840]
["luz",75,900]
["material de limpeza",150,1800]
["comunicação (internet e propaganda)",0,0]
["detetização",80,960]
["Licenciamento ",100,1200]
["Lavagem",200,2400]
["sacos de gelo",900,10800]
["seguro",200,2400]
["materiais de consumo",100,1200]
["subtotal",2700,32400]
["outros (10%)",270,3240]
["TOTAL",1390,16680]

{"sheet":"Custo Mão de Obra","index":5,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,5],[2,5,2,6],[3,5,3,6],[4,5,4,6],[6,5,6,6],[17,5,17,6],[15,5,15,6],[16,5,16,6],[5,5,5,6],[0,0,0,6],[1,0,1,6],[7,0,7,5],[8,0,8,6],[14,0,14,6]],"flags":["formulas_cached_only"]}
[]
["MÃO DE OBRA"]
["Profissionais","Qtde de meses","Qtde de func.","Salários","encargos","Custo total"]
["Gerente ",5,1,1800,0,9000]
["atendente",5,1,1500,null,7500]
["atendente contratado",4,1,1200,960,8640]
["cozinheiro contrado",4,1,1500,1200,10800]
["TOTAL PESSOAL ADMINISTRATIVO",{"$nulls":5},35940]
[]
[{"$nulls":6},"Encargos"]
[{"$nulls":6},0.8]
[]
[]
[]
["MÃO DE OBRA de FINAL DE SEMANA E FERIADOS"]
["Profissionais","Qtde de meses","Qtde. de func.","Salários","encargos","Custo total"]
["coziheiro",0,0,80,null,0]
["atendente fds",4,1,1500,0,6000]
["TOTAL PESSOAL ADMINISTRATIVO",{"$nulls":5},6000]
[{"$nulls":6},"Encargos"]
[{"$nulls":6},0.8]

{"sheet":"Depreciação ","index":6,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,0,5,0],[0,0,0,6],[3,1,4,2],[3,3,4,4],[3,5,4,6]],"flags":["formulas_cached_only"]}
["DEPRECIAÇÃO DOS INVESTIMENTOS/ ESTRUTURA EXISTENTE "]
[]
[]
["ANO","Equipamentos",null,"Obras e bens",null,"TOTAL INVESTIMENTOS"]
[]
[null,"Investimento (R$)","Depreciação (R$)","Investimento (R$)","Depreciação (R$)","Investimento (R$)","Depreciação (R$)"]
[1,17770,null,48000,null,65770,0]
[2,null,1777,null,1920,0,3697]
[3,null,1777,null,1920,0,3697]
[4,null,1777,null,1920,null,3697]
[5,null,1777,null,1920,0,3697]
[6,null,1777,null,1920,0,3697]
[7,null,1777,null,1920,0,3697]
[8,null,1777,null,1920,0,3697]
[9,null,1777,null,1920,0,3697]
[10,null,1777,null,1920,0,3697]
[11,null,1777,null,1920,0,3697]
[12,null,1777,null,1920,0,3697]
[13,null,1777,null,1920,0,3697]
[14,null,1777,null,1920,0,3697]
[15,null,1777,null,1920,0,3697]
[16,null,1777,null,1920,0,3697]
[17,null,1777,null,1920,0,3697]
[18,null,1777,null,1920,0,3697]
[19,null,1777,null,1920,0,3697]
[20,null,1777,null,1920,0,3697]
[21,null,1777,null,1920,0,3697]
[22,null,1777,null,1920,0,3697]
[23,null,1777,null,1920,0,3697]
[24,null,1777,null,1920,0,3697]
[25,null,1777,null,1920,0,3697]
[null,17770,8885,48000,9600,65770,18485]

{"sheet":"Manutenção","index":7,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,8,5,8],[0,0,3,8],[4,0,5,0],[4,5,4,7],[4,1,4,4]],"flags":["formulas_cached_only"]}
["MANUTENÇÃO DOS INVESTIMENTOS "]
[]
[]
[]
["ANO","Equipamentos",null,null,null,"Obras e Bens novos (R$)",null,null,"Total Manutenção (R$)"]
[null,"Equipamentos Existentes (R$)","Equipamentos Novos          (R$)","% Custo de Manutenção","Custo Manutenção Equipamentos (R$)","Obras e Bens novos (R$)","% Custo de Manutenção","Custo Manutenção Obras (R$)"]
[1,null,17770,null,0,48000,null,0,0]
[2,null,null,8,1421.6,null,11,5280,6701.6]
[3,null,null,8,1421.6,null,11,5280,6701.6]
[4,null,null,8,1421.6,null,11,5280,6701.6]
[5,null,null,8,1421.6,null,11,5280,6701.6]
[6,null,null,8,1421.6,null,11,5280,6701.6]
[7,null,null,8,1421.6,null,11,5280,6701.6]
[8,null,null,8,1421.6,null,11,5280,6701.6]
[9,null,null,8,1421.6,null,11,5280,6701.6]
[10,null,null,8,1421.6,null,11,5280,6701.6]
[11,null,null,8,1421.6,null,11,5280,6701.6]
[12,null,null,8,1421.6,null,11,5280,6701.6]
[13,null,null,8,1421.6,null,11,5280,6701.6]
[14,null,null,8,1421.6,null,11,5280,6701.6]
[15,null,null,8,1421.6,null,11,5280,6701.6]
[16,null,null,8,1421.6,null,11,5280,6701.6]
[17,null,null,8,1421.6,null,11,5280,6701.6]
[18,null,null,8,1421.6,null,11,5280,6701.6]
[19,null,null,8,1421.6,null,11,5280,6701.6]
[20,null,null,8,1421.6,null,11,5280,6701.6]
[21,null,null,8,1421.6,null,11,5280,6701.6]
[22,null,null,8,1421.6,null,11,5280,6701.6]
[23,null,null,8,1421.6,null,11,5280,6701.6]
[24,null,null,8,1421.6,null,11,5280,6701.6]
[25,null,null,8,1421.6,null,11,5280,6701.6]
["TOTAL",null,17770,null,7108,48000,null,26400,33508]

{"sheet":"Resumo","index":8,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Anos","Investimentos Novos (R$)","Projeção de Público Pagante","Projeção de Receita","Custos Variáveis","Custos Fixos","Custo Total"]
[1,72347,8568.224999999999,124767.49545956818,45037.984,58620,103657.984]
[2,null,9425.0475,137244.24500552504,55843.3824,58620,114463.3824]
[3,null,10367.552250000002,150968.66950607757,60357.56064,58620,118977.56064000001]
[4,null,11404.307475000005,166065.53645668534,65323.15670400001,58620,123943.15670400001]
[5,null,12544.738222500006,182672.0901023539,70785.31237440002,58620,129405.31237440002]
[6,null,12795.632986950006,186325.53190440097,71986.98662188802,58620,130606.98662188802]
[7,null,13051.545646689008,190052.042542489,73212.69435432578,58620,131832.69435432577]
[8,null,13312.576559622788,193853.0833933388,74462.91624141228,58620,133082.91624141228]
[9,null,13578.828090815245,197730.14506120558,75738.14256624054,58620,134358.14256624054]
[10,null,13850.404652631549,201684.74796242968,77038.87341756535,58620,135658.87341756537]
[11,null,14127.41274568418,205718.44292167827,78365.61888591666,58620,136985.61888591666]
[12,null,14409.961000597863,209832.81178011184,79718.899263635,58620,138338.899263635]
[13,null,14698.160220609821,214029.46801571408,81099.2452489077,58620,139719.2452489077]
[14,null,14992.123425022017,218310.05737602836,82507.19815388585,58620,141127.19815388584]
[15,null,15291.965893522458,222676.25852354892,83943.31011696356,58620,142563.31011696358]
[16,null,15597.805211392906,227129.7836940199,85408.14431930284,58620,144028.14431930284]
[17,null,15909.761315620764,231672.37936790028,86902.2752056889,58620,145522.2752056889]
[18,null,16227.95654193318,236305.8269552583,88426.28870980267,58620,147046.28870980267]
[19,null,16552.515672771842,241031.94349436346,89980.78248399873,58620,148600.78248399874]
[20,null,16883.56598622728,245852.58236425073,91566.36613367869,58620,150186.3661336787]
[21,null,17221.23730595183,250769.6340115358,93183.66145635227,58620,151803.66145635227]
[22,null,17565.662052070864,255785.02669176648,94833.30268547933,58620,153453.30268547934]
[23,null,17916.975293112282,260900.72722560185,96515.93673918891,58620,155135.9367391889]
[24,null,18275.31479897453,266118.74177011393,98232.22347397268,58620,156852.2234739727]
[25,null,18640.82109495402,271441.1166055162,99982.83594345214,58620,158602.83594345214]

{"sheet":"Resultado do PROJETO","index":9,"n_rows":62,"n_cols":28,"rows_kept":62,"cut":false,"hidden":false,"merged":[[49,0,49,1],[29,1,29,2],[26,1,26,2],[42,0,42,1],[40,0,41,1],[40,2,40,27]],"flags":["formulas_cached_only"]}
["ANO","Alíquotas",0,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]
["NÚMERO DE PAGANTES",null,null,8568.224999999999,9425.0475,10367.552250000002,11404.307475000005,12544.738222500006,12795.632986950006,13051.545646689008,13312.576559622788,13578.828090815245,13850.404652631549,14127.41274568418,14409.961000597863,14698.160220609821,14992.123425022017,15291.965893522458,15597.805211392906,15909.761315620764,16227.95654193318,16552.515672771842,16883.56598622728,17221.23730595183,17565.662052070864,17916.975293112282,18275.31479897453,18640.82109495402]
["RECEITA OPERACIONAL BRUTA",null,0,124767.49545956818,137244.24500552504,150968.66950607757,166065.53645668534,182672.0901023539,186325.53190440097,190052.042542489,193853.0833933388,197730.14506120558,201684.74796242968,205718.44292167827,209832.81178011184,214029.46801571408,218310.05737602836,222676.25852354892,227129.7836940199,231672.37936790028,236305.8269552583,241031.94349436346,245852.58236425073,250769.6340115358,255785.02669176648,260900.72722560185,266118.74177011393,271441.1166055162]
["ICMS",0.0186,0,2320.675415547968,2552.7429571027656,2808.0172528130424,3088.818978094347,3397.700875903782,3465.6548934218577,3534.9679912902952,3605.6673511161016,3677.7806981384233,3751.3363121011917,3826.3630383432155,3902.89029911008,3980.948105092282,4060.567067194127,4141.77840853801,4224.61397670877,4309.106256242945,4395.288381367804,4483.19414899516,4572.858031975064,4664.315192614566,4757.601496466857,4852.753526396194,4949.808596924119,5048.8047688626]
["Alíquota",0.0547,0,6824.782001638379,7507.260201802219,8257.986221982443,9083.784844180687,9992.163328598757,10192.006595170733,10395.84672707415,10603.763661615632,10815.838934847945,11032.155713544904,11252.7988278158,11477.854804372117,11707.41190045956,11941.56013846875,12180.391341238126,12423.999168062888,12672.479151424146,12925.92873445263,13184.44730914168,13448.136255324514,13717.098980431007,13991.440960039627,14271.269779240421,14556.695174825232,14847.829078321734]
["CPP",0.0275,0,3431.1061251381248,3774.2167376519387,4151.638411417133,4566.802252558847,5023.482477814732,5123.952127371027,5226.431169918448,5330.959793316817,5437.578989183154,5546.330568966816,5657.257180346152,5770.402323953075,5885.8103704321375,6003.52657784078,6123.597109397596,6246.069051585547,6370.990432617258,6498.410241269603,6628.378446094995,6760.946015016895,6896.164935317234,7034.0882340235785,7174.7699987040505,7318.265398678133,7464.630706651695]
["COFINS",0.0086,0,1073.0004609522864,1180.3005070475153,1298.3305577522672,1428.163613527494,1570.9799748802434,1602.3995743778482,1634.4475658654055,1667.1365171827138,1700.479247526368,1734.4888324768954,1769.1786091264332,1804.5621813089617,1840.6534249351412,1877.4664934338439,1915.0158233025209,1953.316139768571,1992.3824625639425,2032.2301118152213,2072.8747140515256,2114.332208332556,2156.6188524992076,2199.751229549192,2243.746254140176,2288.6211792229797,2334.393602807439]
["RECEITA OPERACIONAL LÍQUIDA",null,0,111117.93145629142,122229.72460192059,134452.69706211268,147897.96676832397,162687.76344515636,165941.5187140595,169260.3490883407,172645.55607010756,176098.4671915097,179620.4365353399,183212.84526604667,186877.10217136762,190614.64421479497,194426.93709909086,198315.47584107268,202281.7853578941,206327.42106505198,210453.96948635305,214663.04887608008,218956.3098536017,223335.43605067377,227802.14477168722,232358.187667121,237005.35142046347,241745.4584488727]
["CUSTO OPERACIONAL (variável)",null,0,45037.984,55843.3824,60357.56064,65323.15670400001,70785.31237440002,71986.98662188802,73212.69435432578,74462.91624141228,75738.14256624054,77038.87341756535,78365.61888591666,79718.899263635,81099.2452489077,82507.19815388585,83943.31011696356,85408.14431930284,86902.2752056889,88426.28870980267,89980.78248399873,91566.36613367869,93183.66145635227,94833.30268547933,96515.93673918891,98232.22347397268,99982.83594345214]
["OUTORGA (VARIÁVEL + FIXA)",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OUTORGA VARIÁVEL"]
["OUTORGA FIXA ",0,null,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]
["LUCRO OPERACIONAL BRUTO",null,0,66079.94745629143,66386.34220192059,74095.13642211267,82574.81006432396,91902.45107075635,93954.53209217147,96047.65473401493,98182.63982869528,100360.32462526916,102581.56311777454,104847.22638013001,107158.20290773262,109515.39896588727,111919.73894520501,114372.16572410912,116873.64103859127,119425.14585936308,122027.68077655038,124682.26639208135,127389.94371992302,130151.7745943215,132968.84208620788,135842.2509279321,138773.12794649077,141762.62250542056]
["DESPESAS OPERACIONAIS (fixo)",null,0,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620]
["Despesa Administrativa",null,0,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620,58620]
["Depreciação ",null,0,0,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697]
["LUCRO OPERACIONAL",null,0,7459.947456291426,7766.34220192059,15475.136422112671,23954.81006432396,33282.451070756346,35334.532092171474,37427.654734014926,39562.639828695275,41740.32462526916,43961.56311777454,46227.226380130014,48538.202907732615,50895.398965887274,53299.73894520501,55752.165724109116,58253.641038591275,60805.14585936308,63407.680776550376,66062.26639208135,68769.94371992302,71531.7745943215,74348.84208620788,77222.2509279321,80153.12794649077,83142.62250542056]
["LACSIR",null,0,7459.947456291426,7766.34220192059,15475.136422112671,23954.81006432396,33282.451070756346,35334.532092171474,37427.654734014926,39562.639828695275,41740.32462526916,43961.56311777454,46227.226380130014,48538.202907732615,50895.398965887274,53299.73894520501,55752.165724109116,58253.641038591275,60805.14585936308,63407.680776550376,66062.26639208135,68769.94371992302,71531.7745943215,74348.84208620788,77222.2509279321,80153.12794649077,83142.62250542056]
["CSLL",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]
["LAIR",null,0,7459.947456291426,7766.34220192059,15475.136422112671,23954.81006432396,33282.451070756346,35334.532092171474,37427.654734014926,39562.639828695275,41740.32462526916,43961.56311777454,46227.226380130014,48538.202907732615,50895.398965887274,53299.73894520501,55752.165724109116,58253.641038591275,60805.14585936308,63407.680776550376,66062.26639208135,68769.94371992302,71531.7745943215,74348.84208620788,77222.2509279321,80153.12794649077,83142.62250542056]
["IMPOSTO DE RENDA",0,null,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]
["RESULTADO LÍQUIDO",null,0,7459.947456291426,7766.34220192059,15475.136422112671,23954.81006432396,33282.451070756346,35334.532092171474,37427.654734014926,39562.639828695275,41740.32462526916,43961.56311777454,46227.226380130014,48538.202907732615,50895.398965887274,53299.73894520501,55752.165724109116,58253.641038591275,60805.14585936308,63407.680776550376,66062.26639208135,68769.94371992302,71531.7745943215,74348.84208620788,77222.2509279321,80153.12794649077,83142.62250542056]
["Depreciação ",null,null,0,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697,3697]
["INVESTIMENTO",null,null,72347]
[]
["FLUXO DE CAIXA",null,null,-64887.052543708574,7766.34220192059,15475.136422112671,23954.81006432396,33282.451070756346,35334.532092171474,37427.654734014926,39562.639828695275,41740.32462526916,43961.56311777454,46227.226380130014,48538.202907732615,50895.398965887274,53299.73894520501,55752.165724109116,58253.641038591275,60805.14585936308,63407.680776550376,66062.26639208135,68769.94371992302,71531.7745943215,74348.84208620788,77222.2509279321,80153.12794649077,83142.62250542056]
["FLUXO DE CAIXA DESCONTADO",88343.22367955736,null,-58988.22958518961,6418.464629686438,11626.699039904333,16361.457594647874,20665.78355350562,19945.42219667935,19206.30487309569,18456.26346066588,17701.972263671025,16949.085652890764,16202.360836180851,15465.767282682049,14742.584172904999,14035.487110627442,13346.62520946371,12677.68955585815,12029.973949970105,11404.428735420059,10801.708447218056,10222.21393354552,9666.129540641092,9133.455890155426,8624.038724356576,8137.594245918825,7673.73133519662]
["FLUXO ACUMULADO",null,null,-58988.22958518961,-52569.764955503175,-40943.06591559884,-24581.608320950967,-3915.8247674453487,16029.597429234,35235.90230232969,53692.16576299557,71394.1380266666,88343.22367955736,104545.58451573821,120011.35179842026,134753.93597132526,148789.4230819527,162136.0482914164,198248.1405326647,210278.1144826348,221682.54321805484,232484.2516652729,242706.4655988184,252372.5951394595,261506.05102961493,270130.0897539715,278267.68399989035,285941.415335087]
[{"$nulls":12},278505.45415703894]
["TIR",0.17999999999977256,{"$nulls":10},147331.453264747]
["VPL",16029.597429233994]
["TAXA DE DESCONTO",0.1,null,0.9090909090909091,0.8264462809917354,0.7513148009015775,0.6830134553650705,0.6209213230591549,0.5644739300537772,0.5131581182307065,0.46650738020973315,0.42409761837248466,0.3855432894295315,0.3504938994813922,0.31863081771035656,0.2896643797366878,0.26333125430607973,0.2393920493691634,0.21762913579014853,0.19784466890013502,0.17985878990921364,0.16350799082655781,0.1486436280241435,0.13513057093103953,0.12284597357367227,0.11167815779424752,0.10152559799477048,0.09229599817706405]
["Taxa ICMBio",0.4057088300589459]
[]
[]
[]
[]
[]
["Payback"]
[6,null,null,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PONTO DE NIVELAMENTO",null,"ANOS"]
[null,null,1,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]
["Custos Fixos / (Receitas - Custos Variáveis)",null,{"$error":"#DIV/0!"},0.735235911105851,0.7201397887400423,0.6469405433128499,0.5818802389213708,0.5239224972814133,0.5126879990921609,0.5017145414539267,0.4909952083860039,0.48052330317652925,0.4702923399113434,0.4602960353948576,0.45052830144183637,0.4409832375202927,0.43165512372689485,0.42253841407739756,0.4136277300956605,0.4049178546857832,0.39640372627280235,0.38808043319824376,0.37994320835761325,0.37198742406766205,0.36420858715194726,0.35660233423386684,0.34916442722695584,0.34189074901280025]
[]
[]
[]
[]
[]
[]
["REL. BENEFÍCIO / CUSTO"]
["TAXAS","VALOR"]
[0,1.0641872076548256]
[0.05,1.0455786821011521]
[0.1,1.027508158686727]
[0.15,1.010095661915483]
[0.2,0.9934243609980387]
[0.25,0.9775456802226161]
[0.30000000000000004,0.9624848637178555]
[]
[]
[]
[null,null,null,176004.984,114463.3824,118977.56064000001,123943.15670400001,129405.31237440002,130606.98662188802,131832.69435432577,133082.91624141228,134358.14256624054,135658.87341756537,136985.61888591666,138338.899263635,139719.2452489077,141127.19815388584,142563.31011696358,144028.14431930284,145522.2752056889,147046.28870980267,148600.78248399874,150186.3661336787,151803.66145635227,153453.30268547934,155135.9367391889,156852.2234739727,158602.83594345214]

{"sheet":"Receita ICMBio","index":10,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2]],"flags":["formulas_cached_only"]}
["Ano","Visitação (pagante)","Receita ICMBio"]
[]
[1,8568.224999999999,3476.2045404318114]
[2,9425.0475,3823.824994474993]
[3,10367.552250000002,4206.207493922493]
[4,11404.307475000005,4626.828243314743]
[5,12544.738222500006,5089.511067646218]
[6,12795.632986950006,5191.301288999142]
[7,13051.545646689008,5295.127314779126]
[8,13312.576559622788,5401.029861074709]
[9,13578.828090815245,5509.050458296203]
[10,13850.404652631549,5619.231467462127]
[11,14127.41274568418,5731.616096811369]
[12,14409.961000597863,5846.248418747597]
[13,14698.160220609821,5963.173387122549]
[14,14992.123425022017,6082.436854865]
[15,15291.965893522458,6204.0855919623]
[16,15597.805211392906,6328.167303801546]
[17,15909.761315620764,6454.730649877577]
[18,16227.95654193318,6583.825262875128]
[19,16552.515672771842,6715.50176813263]
[20,16883.56598622728,6849.811803495283]
[21,17221.23730595183,6986.8080395651905]
[22,17565.662052070864,7126.544200356493]
[23,17916.975293112282,7269.075084363623]
[24,18275.31479897453,7414.456586050897]
[25,18640.82109495402,7562.745717771914]
["Total",0,26413.8776287894]
[]
["VPL",18731.28396993009]

{"sheet":"Análise de Sensibilidade","index":11,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,5],[6,0,6,5]],"flags":["formulas_cached_only"]}
[null,"Cenário 1","Cenário 2","Cenário 3","Cenário 4","Cenário 5"]
["Parâmetros"]
["Demanda no último ano"]
["Preço da entrada"]
["Investimento "]
["Taxa de desconto"]
["Resultados"]
["TIR"]
["VPL"]
["Taxa do ICMBio"]