{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["CAPA","ÍNDICE","1. MANUAL","2. SIMULADOR","2.1 RESUMO","3. CAPEX ","4. OPEX","5. CMPC (WACC)","6. CONTRAPRESTAÇÃO","7. VARIÁVEIS DE FINANCIAMENTO","8. SIMULAÇÃO DE FINANCIAMENTO","9. FLUXO DE CAIXA ","10. DRE"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":6,"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":"CAPA","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,6,4,8],[8,1,8,12],[15,1,18,12],[27,5,27,8],[10,1,10,12]]}
[]
[null,null,null,null,null,null,"SECRETARIA DE ESTADO\nDA INFRAESTRUTURA E\nDOS RECURSOS HÍDRICOS"]
[]
[]
[]
[]
[]
[]
[null,"MODELO DE VIABILIDADE ECONÔMICO-FINANCEIRA"]
[]
[null,"GRUPO 1"]
[]
[]
[]
[]
[null,"PARCERIA PÚBLICA-PRIVADA (PPP) NA MODALIDADE DE CONCESSÃO ADMINISTRATIVA PARA CONSTRUÇÃO, OPERAÇÃO E MANUTENÇÃO DE MINIUSINAS FOTOVOLTAICAS (MINIUFVS) PARA O GOVERNO DO ESTADO DA PARAÍBA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"João Pessoa, dezembro/2023"]

{"sheet":"ÍNDICE","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ORDEM","DESIGNAÇÃO"]
[null,1,"MANUAL"]
[null,2,"SIMULADOR"]
[null,"2.1","RESUMO"]
[null,3,"CAPEX "]
[null,4,"OPEX"]
[null,5,"CPMC (WACC)"]
[null,6,"Contraprestação"]
[null,7,"Variáveis de Financiamento"]
[null,8,"Simulação de Financiamento"]
[null,9,"FLUXO DE CAIXA"]
[null,10,"DRE"]
[]
[]
[null,"SIGLA","SIGNIFICADO"]
[null,"CAPEX","Capital Expenditure"]
[null,"OPEX","Operational Expenditure"]
[null,"CMPC","Custo Médio Ponderado de Capital (WACC)"]
[null,"DRE","Demonstração de Resultado de Exercício"]

{"sheet":"1. MANUAL","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,6,4,8]]}
[]
[null,null,null,null,null,null,"SECRETARIA DE ESTADO\nDA INFRAESTRUTURA E\nDOS RECURSOS HÍDRICOS"]

{"sheet":"2. SIMULADOR","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PREMISSAS","GRUPO I",null,null,"INDICADORES","GRUPO I"]
[null,"CAPEX total",{"$f":"C5+C6","v":38526599.451507896},null,null,"Receita Bruta total",{"$f":"SUM('9. FLUXO DE CAIXA '!D5:AA5)","v":123275129.59391844}]
[null,"1º CAPEX (R$) ",{"$f":"'3. CAPEX '!D25","v":36734909.214911558},null,null,"Contraprestação Mensal",{"$f":"'9. FLUXO DE CAIXA '!D5/12","v":428038.6444233277}]
[null,"2º CAPEX (R$)",{"$f":"'3. CAPEX '!E25","v":1791690.2365963352},null,null,"Contraprestação Anual",{"$f":"'9. FLUXO DE CAIXA '!D5","v":5136463.7330799326}]
[null,"OPEX total",{"$f":"24*C8","v":14959459.963524822},null,null,"Tributos totais",{"$f":"-1*(SUM('9. FLUXO DE CAIXA '!D8:AA8)+SUM('9. FLUXO DE CAIXA '!D9:AA9)+SUM('9. FLUXO DE CAIXA '!D10:AA10)+SUM('9. FLUXO DE CAIXA '!D14:AA14)+SUM('9. FLUXO DE CAIXA '!D15:AA15)+SUM('9. FLUXO DE CAIXA '!D16:AA16))","v":21034130.217813898}]
[null,"OPEX (anual) (R$)",{"$f":"'4. OPEX'!D10","v":623310.83181353426},null,null,"TIR acionista",{"$f":"'9. FLUXO DE CAIXA '!C38","v":0.10173717083692213}]
[null,"TMA (CMPC)",{"$f":"'5. CMPC (WACC)'!G5","v":8.2289229700654831E-2},null,null,"VPL acionista",{"$f":"'9. FLUXO DE CAIXA '!C39","v":2808244.0492761899}]
[null,"TMA(arbitrária)1",7.5999999999999998E-2,null,null,"Payback acionista",{"$f":"'9. FLUXO DE CAIXA '!C40","v":14.125434969929172}]
[null,"Alavancagem ",0.7,null,null,"TIR do Projeto",{"$f":"'9. FLUXO DE CAIXA '!C28","v":8.276031296676134E-2}]
[null,"Impostos (Lucro Presumido)",0.17330000000000001,null,null,"VPL do  Projeto",{"$f":"'9. FLUXO DE CAIXA '!C29","v":141811.7781040594}]
[null,"Regime Contábil",{"$f":"'2.1 RESUMO'!C11","v":"Lucro Presumido"},null,null,"Payback do projeto",{"$f":"'9. FLUXO DE CAIXA '!C31","v":10.101080103438337}]
[null,"Prazo da Concessão (em anos)",{"$f":"'2.1 RESUMO'!C12","v":25}]
[null,"1- Para o caso de alavancagem nula"]
[null,null,null,null,null,"DADOS DE FINANCIAMENTO","GRUPO I"]
[null,null,null,null,null,"Valor captado",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26968619.616055526}]
[null,null,null,null,null,"Custo financeiro da Dívida",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!C18","v":6.3500000000000001E-2}]
[null,null,null,null,null,"ICSD médio",{"$f":"'9. FLUXO DE CAIXA '!C41","v":1.1965996797021619}]
[]
[null,null," "]

{"sheet":"2.1 RESUMO","index":4,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"RESUMO","GRUPO I"]
[null,"Receita Bruta total",{"$f":"SUM('9. FLUXO DE CAIXA '!D5:AA5)","v":123275129.59391844}]
[null,"CAPEX total",{"$f":"'3. CAPEX '!F25","v":38526599.451507896}]
[null,"OPEX total",{"$f":"SUM('4. OPEX'!D10:AA10)","v":14959459.96352483}]
[null,"Tributos totais",{"$f":"-1*(SUM('9. FLUXO DE CAIXA '!D8:AA8)+SUM('9. FLUXO DE CAIXA '!D9:AA9)+SUM('9. FLUXO DE CAIXA '!D10:AA10)+SUM('9. FLUXO DE CAIXA '!D14:AA14)+SUM('9. FLUXO DE CAIXA '!D15:AA15)+SUM('9. FLUXO DE CAIXA '!D16:AA16))","v":21034130.217813898}]
[null,"Contraprestação Mensal",{"$f":"'9. FLUXO DE CAIXA '!D5/12","v":428038.6444233277}]
[null,"Contraprestação Anual",{"$f":"'9. FLUXO DE CAIXA '!D5","v":5136463.7330799326}]
[null,"TMA (CMPC)",{"$f":"'5. CMPC (WACC)'!G5","v":8.2289229700654831E-2}]
[null,"Regime Contábil","Lucro Presumido"]
[null,"Prazo da Concessão",25]
[]
[null,"INDICADORES","GRUPO I"]
[null,"TIR acionista",{"$f":"'9. FLUXO DE CAIXA '!C38","v":0.10173717083692213}]
[null,"VPL acionista",{"$f":"'9. FLUXO DE CAIXA '!C39","v":2808244.0492761899}]
[null,"Payback acionista",{"$f":"'9. FLUXO DE CAIXA '!C40","v":14.125434969929172}]
[null,"TIR do Projeto",{"$f":"'9. FLUXO DE CAIXA '!C28","v":8.276031296676134E-2}]
[null,"VPL do  Projeto",{"$f":"'9. FLUXO DE CAIXA '!C29","v":141811.7781040594}]
[null,"Payback do projeto",{"$f":"'9. FLUXO DE CAIXA '!C31","v":10.101080103438337}]
[]
[null,"PREMISSAS DE FINANCIAMENTO","GRUPO I"]
[null,"Alavancagem ",{"$f":"'5. CMPC (WACC)'!G10","v":0.7}]
[null,"Valor captado",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26968619.616055526}]
[null,"Custo financeiro da Dívida",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!C18","v":6.3500000000000001E-2}]
[null,"ICSD médio",{"$f":"'9. FLUXO DE CAIXA '!C41","v":1.1965996797021619}]

{"sheet":"3. CAPEX ","index":5,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,2],[13,1,13,2],[1,1,1,2],[10,1,10,2],[22,1,22,2]]}
[]
[null,"1- USINA SOLAR FOTOVOLTAICA",null,"1º ANO\n(R$)","2º CAPEX - ANO 13\n(R$)","CAPEX TOTAL \n(R$)"]
[null,"1.1","PAINEIS",10371757.353383461,505866.94736842113,{"$f":"D3+E3","v":10877624.300751882}]
[null,"1.2","INVERSORES",1774926.8164606744,86569.39994382023,1861496.2164044946]
[null,"1.3","SUPORTES RACK",3984041.6435000002,194315.67050000001,4178357.3140000002]
[null,"1.4","STRINGS/CABOS ECONECTORES",1021088.42,49802.06,1070890.48]
[null,"1.5","SKID STATION",3884159.1640000003,189444.052,4073603.2160000005]
[null,"1.6","MÃO DE OBRA p/. MONTAGEM DA UFV",6193120.5858333306,302060.19083333318,6495180.7766666636]
[null,"1.7","OBRAS CIVIS",1924988.6094803461,93888.439385745616,2018877.0488660918]
[]
[null,"SUBTOTAL UFV (R$)",null,{"$f":"SUM(D3:D9)","v":29154082.592657816},{"$f":"SUM(E3:E9)","v":1421946.7600313202},{"$f":"SUM(F3:F9)","v":30576029.352689136}]
[]
[]
[null,"2 - DEMAIS COMPONENTES",null,"1º CAPEX\n(R$)","2º CAPEX - ANO 13\n(R$)","CAPEX TOTAL \n(R$)"]
[null,"2.1","ELABORAÇÃO DE PROJETO EXECUTIVO",492448.17965504603,24018.423194018185,{"$f":"D15+E15","v":516466.60284906422}]
[null,"2.2","AQUISIÇÃO DO TERRENO",400335.93980249995,19525.786507499997,419861.72630999994]
[null,"2.3","REDE DE MÉDIA TENSÃO",1571550,76650,1648200]
[null,"2.4","CABINE DE MÉDIA TENSÃO",3111480.4139999999,151757.802,3263238.216]
[null,"2.5","CUSTO COM CONEXÃO",838160,40880,879040]
[null,"2.6","ESTAÇÃO SOLARIMÉTRICA",1005687.23,49050.89,1054738.1199999999]
[null,"2.7","LICENÇAS E SEGUROS ",161164.85879619725,7860.5748634968786,169025.43365969413]
[]
[null,"SUBTOTAL (R$)",null,{"$f":"SUM(D15:D21)","v":7580826.622253743},{"$f":"SUM(E15:E21)","v":369743.47656501509},{"$f":"SUM(F15:F21)","v":7950570.0988187585}]
[]
[null,"TOTAL GERAL (R$)",null,{"$f":"D11+D23","v":36734909.214911558},{"$f":"E11+E23","v":1791690.2365963352},{"$f":"F11+F23","v":38526599.451507896}]

{"sheet":"4. OPEX","index":6,"n_rows":10,"n_cols":28,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2]]}
[]
[null,"OPEX  GRUPO 1",null,"ANO 2","ANO 3","ANO 4","ANO 5","ANO 6","ANO 7","ANO 8","ANO 9","ANO 10","ANO 11","ANO 12","ANO 13","ANO 14","ANO 15","ANO 16","ANO 17","ANO 18","ANO 19","ANO 20","ANO 21","ANO 22","ANO 23","ANO 24","ANO 25","OPEX TOTAL"]
[]
[null,1,"Gerência e diretoria (R$)",{"$f":"'[2]PAINEL DE CONTROLE'!E51*12","v":153847.91999999998},{"$f":"D4","v":153847.91999999998},{"$f":"E4","v":153847.91999999998},153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,{"$f":"U4","v":153847.91999999998},153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,153847.91999999998,{"$f":"SUM(D4:AA4)","v":3692350.0799999987}]
[null,2,"Operação e manutenção  (R$)",{"$f":"382730.21","v":382730.21},{"$f":"D5","v":382730.21},382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,382730.21,{"$f":"SUM(D5:AA5)","v":9185525.0400000028}]
[null,3,"Despesa sócio-ambientais  (R$)",{"$f":"'[2]PAINEL DE CONTROLE'!E53*12","v":1335.8333333333333},1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,1335.8333333333333,{"$f":"SUM(D6:AA6)","v":32059.999999999989}]
[null,4,"Seguros e garantias  (R$)",{"$f":"'[2]PAINEL DE CONTROLE'!E54*12","v":31396.868480200923},31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,31396.868480200923,{"$f":"SUM(D7:AA7)","v":753524.84352482203}]
[null,5,"Segurança patrimonial  (R$)",{"$f":"'[2]PAINEL DE CONTROLE'!E55*12","v":54000},54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,{"$f":"SUM(D8:AA8)","v":1296000}]
[]
[null,"TOTAL (R$)",null,{"$f":"SUM(D4:D9)","v":623310.83181353426},{"$f":"SUM(E4:E8)","v":623310.83181353426},623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,623310.83181353426,{"$f":"SUM(AB4:AB8)","v":14959459.963524822}]

{"sheet":"5. CMPC (WACC)","index":7,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,2,28,4],[29,2,29,4],[30,2,30,4],[13,2,13,4],[14,2,14,4],[20,2,20,5],[1,2,1,6],[21,2,21,4],[22,2,22,4],[4,2,4,5],[27,2,27,4],[15,2,15,4],[16,2,16,4],[8,2,8,4],[9,2,9,4],[3,2,3,6],[12,2,12,5],[11,2,11,6],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
[]
[null,null,"Custo Médio Ponderado de Capital  - CMPC (WACC)"]
[]
[null,null,"Cálculo de CMPC (WACC)"]
[null,null,"CMPC= Ke x E/V + Kd x (1 – T) x D/V",null,null,null,{"$f":"G6*G7+G8*(1-G9)*G10","v":8.2289229700654831E-2}]
[null,null,"Ke = Custo do Capital Próprio Real alavancado",null,null,"Kerl",{"$f":"G17","v":0.14891459900218273}]
[null,null,"E/V = % Participação do Capital Próprio",null,null,"E/V",{"$f":"1-G27","v":0.30000000000000004},null,"Referência","Fonte"]
[null,null,"Kd = Custo do Capital de Terceiros Real",null,null,"Kd",6.5000000000000002E-2,null,"Boletim Informativo de Debêntures Incentivadas","https://www.gov.br/economia/pt-br/centrais-de-conteudo/publicacoes/boletins/boletim-de-debentures-incentivadas/2022/boletim-de-debentures-incentivadas-dezembro-2022"]
[null,null,"T = Taxa de Imposto  sobre Sociedades",null,null,"T",0.17330000000000001,null,"Alíquota lucro real","http://www.cebrasse.org.br/downloads/html/lucro_presumido_real.html"]
[null,null,"D/V = % Participação do Capital de Terceiros",null,null,"D/V",0.7]
[]
[null,null,"Cálculo de Custo de Capital Próprio (Capital Asset Price Model - CAPM)"]
[null,null,"CAPM:  Ke = Rf + beta*PRM + Rp"]
[null,null,"Custo de Capital Próprio Nominal (Rf+βd*PRM+Rp)",null,null,"Ke",{"$f":"(G22+(G26*(G24-G23)))+G31","v":0.10761}]
[null,null,"Custo de Capital Próprio Real {[(1+Ke)/(1+IPCA)]-1}",null,null,"Ker",{"$f":"((1+G14)/(1+G30))-1","v":3.6117867165575301E-2}]
[null,null,"Custo de Capital Próprio Nominal Alavancado [Rf+βl(Rm-R'f)+Rp]",null,null,"Kel",{"$f":"(G22+(G28*(G24-G23)))+G31","v":0.2281897063333333}]
[null,null,"Custo de Capital Próprio Real Alavancado  {[(1+Kerl)/(1+IPCA)]-1}",null,null,"Kerl",{"$f":"((1+G16)/(1+G30))-1","v":0.14891459900218273}]
[]
[]
[null,null,null,null,null,null,null,null,"Referência","Fonte"]
[null,null,"Parâmetros"]
[null,null,"Taxa nominal livre de risco (US T-Bond)",null,null,"Rf",2.4199999999999999E-2,null,"Taxa de retorno do Treasury Bond 10Y Média anual do período 2008-2022","macrotrends.net"]
[null,null,"Taxa nominal livre de risco (US T-Bond)",null,null,"R’f",3.73E-2,null,"Taxa de retorno do Treasury Bond 10Y Média móvel de 12 meses do final do período 1960-2022","macrotends.net"]
[null,null,"Retorno da carteira de mercado – S&P500",null,null,"Rm",0.12659999999999999,null,"Mediana do período 1970-2023 – S&P Dow Jones ","macrotrends.net"]
[null,null,"Prêmio de risco do mercado ",null,null,"PRM",{"$f":"G24-G23","v":8.929999999999999E-2},null,"Rm-R’f"]
[null,null,"Beta médio desalavancado ",null,null,"βd",0.7,null,"Green & Renewable Energy  - unlevered beta (05/01/2023)","https://pages.stern.nyu.edu/~adamodar/"]
[null,null,"Alavancagem",null,null,"D/V",{"$f":"G10","v":0.7}]
[null,null,"Beta alavancado",null,null,"βl",{"$f":"G26*(1+(1-G29)*(G10/G7))","v":2.0502766666666665}]
[null,null,"Impostos ",null,null,"T",0.17330000000000001,null,"Alíquota lucro real","http://www.cebrasse.org.br/downloads/html/lucro_presumido_real.html"]
[null,null,"Inflação Brasil IPCA",null,null,"IPCA",6.9000000000000006E-2,null,"IPCA média aritmética da variação percentual acumulada no ano – 2000-2022","https://www.ibge.gov.br/estatisticas/economicas/precos-e-custos/9256-indice-nacional-de-precos-ao-consumidor-amplo.html?=&t=downloads"]
[null,null,"Prêmio de risco-país",null,null,"Rp",2.0899999999999998E-2,null,"EMBI+_Risco Brasil do dia 8/9/2023","http://www.ipeadata.gov.br/ExibeSerie.aspx?serid=40940&module=M"]

{"sheet":"6. CONTRAPRESTAÇÃO","index":8,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,1,22,2],[23,1,23,2],[1,1,1,3],[15,1,15,2],[3,1,3,2],[21,1,21,2],[20,1,20,2],[16,1,16,2],[4,1,4,2],[9,1,9,2],[13,1,13,2],[18,1,18,2]]}
[]
[null,"Cálculo da Contraprestação | Grupo 1"]
[]
[null,"Premissas Econômicas"]
[null,"TMA (CMPC)",null,{"$f":"IF('2. SIMULADOR'!C11=0,'2. SIMULADOR'!C10,'2. SIMULADOR'!C9)","v":8.2289229700654831E-2}]
[null,"Prazo de Concessão (anos)",null,{"$f":"'2. SIMULADOR'!C14","v":25}]
[null,"Regime Contábil",null,"Lucro Presumido"]
[null,"Impostos (Lucro Presumido)",null,0.17330000000000001]
[]
[null,"CUSTOS DE INVESTIMENTO"]
[null,"1º CAPEX (R$) ",null,{"$f":"'2. SIMULADOR'!C5","v":36734909.214911558}]
[null,"2º CAPEX (R$)",{"$f":"'2. SIMULADOR'!C6","v":1791690.2365963352}]
[null,"2º CAPEX Descontado (R$)",null,{"$f":"C12/(1+D5)^12","v":693653.98813287925}]
[null,"CAPEX Total (R$)",null,{"$f":"SUM(D11:D13)","v":37428563.203044437}]
[]
[null,"Custo anualizado"]
[null,"CAPEX anualizado (CAE) (R$)",null,{"$f":"D14*((D5*(1+D5)^24)/((1+D5)^24-1))","v":3623003.7363236453}]
[null,"OPEX (anual) (R$)",null,{"$f":"'4. OPEX'!D10","v":623310.83181353426}]
[null,"Total (R$)",null,{"$f":"D17+D18","v":4246314.5681371801}]
[]
[null,"Contraprestação anual"]
[null,"CUSTO ANUALIZADO (R$)",null,{"$f":"D19","v":4246314.5681371801}]
[null,"Impostos (R$)",null,{"$f":"(D19/(1-D8))-D22","v":890149.16494275257}]
[null,"VALOR DA CONTRAPRESTAÇÃO (R$)",null,{"$f":"SUM(D22:D23)","v":5136463.7330799326}]

{"sheet":"7. VARIÁVEIS DE FINANCIAMENTO","index":9,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,1,12,2],[3,4,3,5],[3,1,3,2],[5,1,5,2],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[1,1,1,5],[10,1,10,2],[10,4,10,5],[8,1,8,2],[8,4,8,5],[9,1,9,2],[9,4,9,5],[5,3,5,5]]}
[]
[null,"VARIÁVEIS DE FINANCIAMENTO",null,null,null,null,null,null,"ITENS FINANCIÁVEIS","VALOR\n(R$)"]
[]
[null,"LINHA DE FINANCIAMENTO ",null,null,"BNDES FINAME Baixo Carbono",null,null,"1- USINA SOLAR FOTOVOLTAICA"]
[null,null,null,null,null,null,null,"1.1","PAINEIS",{"$f":"'3. CAPEX '!F3","v":10877624.300751882}]
[null,"Taxa de juros",null,null,"(IPCA + parcela fixa TLP) + remuneração BNDES",null,null,"1.2","INVERSORES",{"$f":"'3. CAPEX '!F4","v":1861496.2164044946}]
[null,"Sistema de amortização",null,null,"SAC",null,null,"1.3","SUPORTES RACK",{"$f":"'3. CAPEX '!F5","v":4178357.3140000002}]
[null,"Remuneração BNDES",null,null,"0,95% a.a.",null,null,"1.4","STRINGS/CABOS ECONECTORES",{"$f":"'3. CAPEX '!F6","v":1070890.48}]
[null,"Mês de Referência",null,null,"2023-10-01",null,null,"1.5","SKID STATION",{"$f":"'3. CAPEX '!F7","v":4073603.2160000005}]
[null,"Participação do BNDES",null,null,"100% dos itens financiáveis"]
[null,"PRAZO",null,null,"Até 10 anos, com carência de até 2 anos.",null,null,"2 - DEMAIS COMPONENTES"]
[null,null,null,null,null,null,null,"2.1","ELABORAÇÃO DE PROJETO EXECUTIVO",{"$f":"'3. CAPEX '!F15","v":516466.60284906422}]
[null,"CÁLCULO DA TAXA DE JUROS",null,null,null,null,null,"2.3","REDE DE MÉDIA TENSÃO",{"$f":"'3. CAPEX '!F17","v":1648200}]
[null,"AGENTE FINANCEIRO",0,null,null,null,null,"2.4","CABINE DE MÉDIA TENSÃO",{"$f":"'3. CAPEX '!F18","v":3263238.216}]
[null,"IPCA",2.5999999999999999E-3,null,null,null,null,"2.5","CUSTO COM CONEXÃO",{"$f":"'3. CAPEX '!F19","v":879040}]
[null,"TLP fixa",5.1400000000000001E-2,null,null,null,null,"2.6","ESTAÇÃO SOLARIMÉTRICA",{"$f":"'3. CAPEX '!F20","v":1054738.1199999999}]
[null,"BNDES",9.4999999999999998E-3]
[null,"Taxa final de juros",{"$f":"SUM(C14:C17)","v":6.3500000000000001E-2},null,null,null,null,"3 - TOTAL",null,{"$f":"SUM(J5:J16)","v":29423654.466005441}]
[]
[]
[null,"CAPEX","ALAVANCAGEM","EMPRÉSTIMO\n(R$)","ITENS FINANCIÁVEIS\n(R$)","% DOS ITENS FINANCIÁVEIS"]
[null,{"$f":"'2. SIMULADOR'!C4","v":38526599.451507896},{"$f":"'2. SIMULADOR'!C11","v":0.7},{"$f":"B22*C22","v":26968619.616055526},{"$f":"J18","v":29423654.466005441},{"$f":"D22/E22","v":0.91656254484682265}]

{"sheet":"8. SIMULAÇÃO DE FINANCIAMENTO","index":10,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,14]]}
[]
[null,"SIMULAÇÃO DE FINANCIAMENTO"]
[]
[null,"TAXA",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!C18","v":6.3500000000000001E-2},"EMPRÉSTIMO ",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26968619.616055526}]
[]
[null,"ANO",1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"Saldo Devedor\n(R$)",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26968619.616055526},{"$f":"C7","v":26968619.616055526},{"$f":"D7","v":26968619.616055526},{"$f":"E7-E8","v":24271757.654449973},{"$f":"F7-F8","v":21574895.692844421},18878033.731238868,16181171.769633316,13484309.808027763,10787447.84642221,8090585.8848166578,5393723.9232111052,2696861.9616055526,0]
[null,"Amortização\n(R$)",null,null,{"$f":"C7/10","v":2696861.9616055526},{"$f":"E8","v":2696861.9616055526},{"$f":"F8","v":2696861.9616055526},2696861.9616055526,2696861.9616055526,2696861.9616055526,2696861.9616055526,2696861.9616055526,2696861.9616055526,2696861.9616055526]
[null,"Juros\n(R$)",{"$f":"$C$4*C7","v":1712507.345619526},{"$f":"$C$4*D7","v":1712507.345619526},{"$f":"$C$4*E7","v":1712507.345619526},{"$f":"$C$4*F7","v":1541256.6110575732},{"$f":"$C$4*G7","v":1370005.8764956207},1198755.1419336682,1027504.4073717155,856253.672809763,685002.93824781035,513752.20368585776,342501.46912390518,171250.73456195259]
[null,"Prestação\n (R$)",{"$f":"SUM(C8:C9)","v":1712507.345619526},{"$f":"SUM(D8:D9)","v":1712507.345619526},4409369.3072250783,4238118.5726631256,4066867.8381011733,3895617.103539221,3724366.3689772682,3553115.6344153155,3381864.8998533627,3210614.1652914104,3039363.4307294576,2868112.6961675053]

{"sheet":"9. FLUXO DE CAIXA ","index":11,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fluxo de caixa (Lucro Presumido) ","ANO 1","ANO 2","ANO 3","ANO 4","ANO 5","ANO 6","ANO 7","ANO 8","ANO 9","ANO 10","ANO 11","ANO 12","ANO 13","ANO 14","ANO 15","ANO 16","ANO 17","ANO 18","ANO 19","ANO 20","ANO 21","ANO 22","ANO 23","ANO 24","ANO 25"]
[]
[null,"Receita Operacional Bruta (ROB)",null,{"$f":"D5","v":5136463.7330799326},{"$f":"E5","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326]
[null,"Contraprestação do poder concedente",null,{"$f":"'6. CONTRAPRESTAÇÃO'!D24","v":5136463.7330799326},{"$f":"D5","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,{"$f":"H5","v":5136463.7330799326},{"$f":"I5","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326]
[]
[null,"Impostos"]
[null,"PIS (0,65%)",null,{"$f":"D5*0.0065*-1","v":-33387.014265019563},{"$f":"-(E5*0.0065)","v":-33387.014265019563},-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563]
[null,"COFINS (3,00%)",null,{"$f":"-(D5*0.03)","v":-154093.91199239797},{"$f":"-(E5*0.03)","v":-154093.91199239797},-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797]
[null,"ISS (3,00%)",null,{"$f":"0.03*D5*-1","v":-154093.91199239797},{"$f":"D10","v":-154093.91199239797},{"$f":"E10","v":-154093.91199239797},-154093.91199239797,-154093.91199239797,{"$f":"H10","v":-154093.91199239797},{"$f":"I10","v":-154093.91199239797},-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797]
[]
[null,"Receita Operacional Líquida (ROL)",null,{"$f":"D5+D8+D9+D10","v":4794888.894830117},{"$f":"E5+E8+E9+E10","v":4794888.894830117},4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117,4794888.894830117]
[null,"(-) Custos de operação e manutenção (OPEX)",null,{"$f":"-1*'4. OPEX'!D10","v":-623310.83181353426},{"$f":"D13","v":-623310.83181353426},-623310.83181353426,-623310.83181353426,-623310.83181353426,{"$f":"H13","v":-623310.83181353426},{"$f":"I13","v":-623310.83181353426},-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426]
[null,"(-) IRPJ",null,{"$f":"-(D4*0.32)*0.15","v":-246550.25918783675},-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675]
[null,"(-) IRPJ do excedente",null,{"$f":"-(0.32*D5-240000)*0.1","v":-140366.83945855786},-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786]
[null,"(-) CSLL",null,{"$f":"-0.32*D4*0.09","v":-147930.15551270207},{"$f":"-0.32*E5*0.09","v":-147930.15551270207},-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207]
[]
[null,"LUCRO LIQUIDO APÓS IR",null,{"$f":"SUM(D12:D16)","v":3636730.8088574861},{"$f":"SUM(E12:E16)","v":3636730.8088574861},3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861]
[null,"(-) CAPEX(Investimentos)",{"$f":"-1*'3. CAPEX '!D25","v":-36734909.214911558},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-1*'6. CONTRAPRESTAÇÃO'!C12","v":-1791690.2365963352}]
[]
[null,"Fluxo de caixa do projeto",{"$f":"C19","v":-36734909.214911558},{"$f":"D18+D19","v":3636730.8088574861},{"$f":"E18+E19","v":3636730.8088574861},3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,1845040.5722611509,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861]
[null,"Fluxo de caixa  acumulado",{"$f":"C21","v":-36734909.214911558},{"$f":"C22+D21","v":-33098178.406054072},{"$f":"D22+E21","v":-29461447.597196586},-25824716.788339101,-22187985.979481615,-18551255.170624129,{"$f":"H22+I21","v":-14914524.361766644},{"$f":"I22+J21","v":-11277793.552909158},-7641062.7440516725,-4004331.9351941864,-367601.12633670028,3269129.6825207858,5114170.2547819372,8750901.0636394229,12387631.872496909,16024362.681354394,19661093.490211882,23297824.299069367,26934555.107926853,30571285.916784339,34208016.725641824,37844747.53449931,41481478.343356796,45118209.152214281,48754939.961071767]
[null,"(+) Captação de empréstimo",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26968619.616055526}]
[null,"(-) Despesas financeiras(juros de empréstimo)",null,{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!C9","v":-1712507.345619526},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!D9","v":-1712507.345619526},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!E9","v":-1712507.345619526},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!F9","v":-1541256.6110575732},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!G9","v":-1370005.8764956207},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!H9","v":-1198755.1419336682},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!I9","v":-1027504.4073717155},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!J9","v":-856253.672809763},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!K9","v":-685002.93824781035},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!L9","v":-513752.20368585776},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!M9","v":-342501.46912390518},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!N9","v":-171250.73456195259}]
[null,"(-) Amortização do empréstimo",null,null,null,{"$f":"C23/10*-1","v":-2696861.9616055526},{"$f":"F25","v":-2696861.9616055526},{"$f":"G25","v":-2696861.9616055526},{"$f":"H25","v":-2696861.9616055526},{"$f":"I25","v":-2696861.9616055526},-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526]
[]
[null,"Indicadores do projeto"]
[null,"TIR do projeto",{"$f":"IRR(C21:AA21)","v":8.276031296676134E-2}]
[null,"VPL do projeto",{"$f":"NPV(C43,D21:AA21)+C21","v":141811.7781040594}]
[null,"Payback simples(contagem)",null,{"$f":"IF(D22<0,1,IF(C22>0,0,-C22/D21))","v":1},1,1,1,1,{"$f":"IF(I22<0,1,IF(H22>0,0,-H22/I21))","v":1},{"$f":"IF(J22<0,1,IF(I22>0,0,-I22/J21))","v":1},1,1,1,0.10108010343833662,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Payback do projeto",{"$f":"SUM(D30:AA30)","v":10.101080103438337}]
[]
[null,"Fluxo de caixa livre do acionista",{"$f":"C19+C23","v":-9766289.5988560319},{"$f":"D21+D24+D25","v":1924223.4632379601},1924223.4632379601,-772638.49836759246,-601387.7638056397,-430137.02924368717,-258886.29468173441,-87635.560119782109,83615.174442170653,254865.90900412295,426116.64356607571,597367.37812802847,-1023072.1239063542,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861,3636730.8088574861]
[null,"Fluxo de caixa acumulado",{"$f":"C33","v":-9766289.5988560319},{"$f":"C34+D33","v":-7842066.135618072},-5917842.6723801121,-6690481.1707477048,-7291868.9345533447,-7722005.9637970319,{"$f":"H34+I33","v":-7980892.2584787663},{"$f":"I34+J33","v":-8068527.818598548},-7984912.6441563778,-7730046.7351522548,-7303930.0915861791,-6706562.7134581506,-7729634.837364505,-4092904.0285070189,-456173.21964953281,3180557.5892079533,6817288.3980654394,10454019.206922926,14090750.015780412,17727480.824637897,21364211.633495383,25000942.442352869,28637673.251210354,32274404.06006784,35911134.868925326]
[null,"Payback simples(contagem)",null,{"$f":"IF(D34<0,1,IF(C34>0,0,-C34/D33))","v":1},{"$f":"IF(E34<0,1,IF(D34>0,0,-D34/E33))","v":1},1,1,1,{"$f":"IF(I34<0,1,IF(H34>0,0,-H34/I33))","v":1},{"$f":"IF(J34<0,1,IF(I34>0,0,-I34/J33))","v":1},1,1,1,1,1,1,1,0.12543496992917219,0,0,0,0,0,0,0,0,0]
[]
[null,"Indicadores do acionista"]
[null,"TIR do acionista",{"$f":"IRR(C33:AA33)","v":0.10173717083692213}]
[null,"VPL do acionista",{"$f":"NPV(C43,D33:AA33)+C33","v":2808244.0492761899}]
[null,"Payback do acionista",{"$f":"SUM(D35:AA35)","v":14.125434969929172}]
[null,"Índice de Cobertura do Serviço da Dívida (ICSD)",{"$f":"AVERAGE(D41:M41)","v":1.1965996797021619},{"$f":"IF(D24<0,-((D12+D13)+SUM(D14:D16))/SUM(D24,D25),0)","v":2.1236293194070024},{"$f":"IF(E24<0,-((E12+E13)+SUM(E14:E16))/SUM(E24,E25),0)","v":2.1236293194070024},0.82477346655868289,0.85810029769229823,0.89423383144790891,0.93354421448490588,0.97646967257309669,1.0235329167540392,1.075362534149479,1.1327212245472043,1.1965435828069624,1.2679874168532641,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TMA(CMPC)",{"$f":"'5. CMPC (WACC)'!G5","v":8.2289229700654831E-2}]

{"sheet":"10. DRE","index":12,"n_rows":32,"n_cols":27,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DRE","ANO 1","ANO 2","ANO 3","ANO 4","ANO 5","ANO 6","ANO 7","ANO 8","ANO 9","ANO 10","ANO 11","ANO 12","ANO 13","ANO 14","ANO 15","ANO 16","ANO 17","ANO 18","ANO 19","ANO 20","ANO 21","ANO 22","ANO 23","ANO 24","ANO 25"]
[]
[null,"Receita Bruta",null,{"$f":"D5","v":5136463.7330799326},{"$f":"E5","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326]
[null,"Receita da Contraprestação",null,{"$f":"'9. FLUXO DE CAIXA '!D5","v":5136463.7330799326},{"$f":"D5","v":5136463.7330799326},{"$f":"E5","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326]
[]
[null,"Tributos"]
[null,"PIS (0,65%)",null,{"$f":"D5*-1*0.0065","v":-33387.014265019563},{"$f":"D8","v":-33387.014265019563},{"$f":"E8","v":-33387.014265019563},-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563,-33387.014265019563]
[null,"COFINS (3%)",null,{"$f":"-1*D5*0.03","v":-154093.91199239797},{"$f":"D9","v":-154093.91199239797},{"$f":"E9","v":-154093.91199239797},-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797]
[null,"ISS (3%)",null,{"$f":"-1*D5*0.03","v":-154093.91199239797},{"$f":"D10","v":-154093.91199239797},{"$f":"E10","v":-154093.91199239797},-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797,-154093.91199239797]
[]
[null,"Receita Líquida",null,{"$f":"D4+D7","v":5136463.7330799326},5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326,5136463.7330799326]
[]
[null,"Custos Operacionais"]
[null,"Custos de operação e manutenção (OPEX)",null,{"$f":"-1*'4. OPEX'!D10","v":-623310.83181353426},{"$f":"D15","v":-623310.83181353426},{"$f":"E15","v":-623310.83181353426},-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426,-623310.83181353426]
[]
[null,"Lucro operacional",null,{"$f":"D12+D15","v":4513152.9012663979},{"$f":"E12+E15","v":4513152.9012663979},4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979]
[]
[null,"Despesas Financeiras"]
[null,"Juros",null,{"$f":"'9. FLUXO DE CAIXA '!D24","v":-1712507.345619526},{"$f":"'9. FLUXO DE CAIXA '!E24","v":-1712507.345619526},{"$f":"'9. FLUXO DE CAIXA '!F24","v":-1712507.345619526},{"$f":"'9. FLUXO DE CAIXA '!G24","v":-1541256.6110575732},{"$f":"'9. FLUXO DE CAIXA '!H24","v":-1370005.8764956207},{"$f":"'9. FLUXO DE CAIXA '!I24","v":-1198755.1419336682},{"$f":"'9. FLUXO DE CAIXA '!J24","v":-1027504.4073717155},{"$f":"'9. FLUXO DE CAIXA '!K24","v":-856253.672809763},{"$f":"'9. FLUXO DE CAIXA '!L24","v":-685002.93824781035},{"$f":"'9. FLUXO DE CAIXA '!M24","v":-513752.20368585776},{"$f":"'9. FLUXO DE CAIXA '!N24","v":-342501.46912390518},{"$f":"'9. FLUXO DE CAIXA '!O24","v":-171250.73456195259}]
[null,"Amortização",null,null,null,{"$f":"'9. FLUXO DE CAIXA '!F25","v":-2696861.9616055526},{"$f":"F21","v":-2696861.9616055526},{"$f":"G21","v":-2696861.9616055526},-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526,-2696861.9616055526]
[]
[null,"Lucros antes dos impostos",null,{"$f":"D17+D20+D21","v":2800645.5556468721},{"$f":"E17+E20+E21","v":2800645.5556468721},103783.59404131956,275034.32860327233,446285.06316522462,617535.79772717692,788786.53228912968,960037.26685108244,1131288.0014130352,1302538.7359749875,1473789.4705369403,1645040.2050988926,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979,4513152.9012663979]
[null,"Imposto de Renda",null,{"$f":"-(D4*0.32)*0.15","v":-246550.25918783675},{"$f":"-(E4*0.32)*0.15","v":-246550.25918783675},-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675,-246550.25918783675]
[null,"Imposto de Renda sobre excedente",null,{"$f":"-(0.32*D4-240000)*0.1","v":-140366.83945855786},{"$f":"-(0.32*E4-240000)*0.1","v":-140366.83945855786},-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786,-140366.83945855786]
[null,"Contribuição Social",null,{"$f":"-(0.32*D4)*0.09","v":-147930.15551270207},{"$f":"-(0.32*E4)*0.09","v":-147930.15551270207},-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207,-147930.15551270207]
[]
[null,"Lucro Líquido",null,{"$f":"D23+D24+D26","v":2406165.1409463333},2406165.1409463333,-290696.82065921929,-119446.0860972665,51804.648464685801,223055.38302663807,394306.11758859083,565556.85215054359,736807.58671249636,908058.32127444877,1079309.0558364014,1250559.7903983537,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586]
[]
[null,"Dividendos"]
[]
[null,"Lucros Retidos",null,{"$f":"D28+D30","v":2406165.1409463333},{"$f":"E28+E30","v":2406165.1409463333},-290696.82065921929,-119446.0860972665,51804.648464685801,223055.38302663807,394306.11758859083,565556.85215054359,736807.58671249636,908058.32127444877,1079309.0558364014,1250559.7903983537,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586,4118672.4865658586]