{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["3. CAPEX  (2)","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":7,"macros":1,"external_links":1,"defined_names":5,"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":"3. CAPEX  (2)","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2],[13,1,13,2],[22,1,22,2],[24,1,24,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",10133178.225563912,583083.42857142864,{"$f":"D3+E3","v":10716261.654135341}]
[null,"1.2","INVERSORES",1734098.5867415732,99783.515786516858,1833882.1025280901]
[null,"1.3","SUPORTES RACK",3892397.6580000003,223976.37949999998,4116374.0375000001]
[null,"1.4","STRINGS/CABOS ECONECTORES",997600.56,57403.939999999995,1055004.5]
[null,"1.5","SKID STATION",3794812.7520000003,218361.14799999999,4013173.9000000004]
[null,"1.6","MÃO DE OBRA p/. MONTAGEM DA UFV",6050661.6699999971,348167.22583333316,6398828.8958333302]
[null,"1.7","OBRAS CIVIS",1880708.5431555619,108219.74715891226,1988928.2903144741]
[]
[null,"SUBTOTAL UFV (R$)",null,{"$f":"SUM(D3:D9)","v":28483457.995461047},1638995.3848501907,30122453.380311228]
[]
[]
[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",481120.50844221166,27684.640433026831,{"$f":"D15+E15","v":508805.14887523849}]
[null,"2.2","AQUISIÇÃO DO TERRENO",391127.10506999999,22506.239242499996,413633.34431249998]
[null,"2.3","REDE DE MÉDIA TENSÃO",1535400,88350,1623750]
[null,"2.4","CABINE DE MÉDIA TENSÃO",3039907.7520000003,174922.39799999999,3214830.1500000004]
[null,"2.5","CUSTO COM CONEXÃO",818880,47120,866000]
[null,"2.6","ESTAÇÃO SOLARIMÉTRICA",982553.64,56538.109999999993,1039091.75]
[null,"2.7","LICENÇAS E SEGUROS ",157457.62094472419,9060.4277780815282,166518.04872280572]
[]
[null,"SUBTOTAL (R$)",null,{"$f":"SUM(D15:D21)","v":7406446.6264569359},426181.81545360829,7832628.4419105444]
[]
[null,"TOTAL GERAL (R$)",null,{"$f":"D11+D23","v":35889904.621917985},2065177.200303799,37955081.822221771]

{"sheet":"CAPA","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,6,4,8],[8,1,8,12],[10,1,10,12],[15,1,18,12],[27,5,27,8]]}
[]
[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 2"]
[]
[]
[]
[]
[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":2,"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":3,"n_rows":57,"n_cols":7,"rows_kept":57,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"- É possível alterar os valores de dados de entrada - CAPEX, OPEX, ALAVANCAGEM e PARÂMETROS DE MERCADO FINANCEIRO, que automaticamente os demais resultados são calculados."]
[null,"- A aba ‘SIMULADOR’ permite avaliar o resultado financeiro do projeto, e os índices de viabilidade econômica, alterando-se os parâmetros ALAVANCAGEM. Para a situação em que haja ALAVANCAGEM nula, pode-se modificar a TMA (arbitrária)."]
[null," - As demais abas compreendem as funcionalidades descritas abaixo:"]
[null,"ÍNDICE: Exibe a relação das abas contendo as planilhas"]
[null,"SIMULADOR: Realiza simulações a partir de alteração de valores de dados de entrada"]
[null,"RESUMO:  Sintetiza os diversos indicadores, valores, parâmetros utilizados, e resultados obtidos na análise de viabilidade econômico-financeira"]
[null,"CAPEX:","Apresenta os Custos de Investimentos"]
[null,"OPEX:","Apresenta os Custos de Operação"]
[null,"CPMC (WACC):","Cálculo do valor de capital próprio e do capital médio ponderado"]
[null,"CONTRAPRESTAÇÃO: Calcula o valor da Contraprestação"]
[null,"VARIÁVEIS DE FINANCIAMENTO: Permite a entrada de dados para o cálculo das parcelas do financiamento"]
[null,"SIMULAÇÃO DE FINANCIAMENTO: Calcula as parcelas do financiamento, juros e amortização, para a linha BNDES Finame Baixo Carbono."]
[null,"FLUXO DE CAIXA: Exibe o fluxo de caixa do projeto"]
[null,"DRE: Apresenta a Demonstração do Resultado do Exercício"]

{"sheet":"2. SIMULADOR","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PREMISSAS","GRUPO II",null,null,"INDICADORES","GRUPO II"]
[null,"CAPEX total",{"$f":"C5+C6","v":37955081.822221786},null,null,"Receita Bruta total",{"$f":"SUM('9. FLUXO DE CAIXA '!D5:AA5)","v":121172740.23089135}]
[null,"1º CAPEX (R$) ",{"$f":"'3. CAPEX '!D25","v":35889904.621917985},null,null,"Contraprestação Mensal",{"$f":"G6/12","v":420738.68135726143}]
[null,"2º CAPEX (R$)",{"$f":"'3. CAPEX '!E25","v":2065177.200303799},null,null,"Contraprestação Anual",{"$f":"'9. FLUXO DE CAIXA '!D5","v":5048864.176287137}]
[null,"OPEX total",{"$f":"24*C8","v":14938508.950917009},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":20665581.362475242}]
[null,"OPEX (anual) (R$)",{"$f":"'4. OPEX'!D10","v":622437.87295487535},null,null,"TIR acionista",{"$f":"'9. FLUXO DE CAIXA '!C38","v":0.10217936669548866}]
[null,"TMA (CMPC)",{"$f":"'5. CMPC (WACC)'!G5","v":8.2289229700654831E-2},null,null,"VPL acionista",{"$f":"'9. FLUXO DE CAIXA '!C39","v":2770499.1691069826}]
[null,"TMA(arbitrária)1",7.5999999999999998E-2,null,null,"Payback acionista",{"$f":"'9. FLUXO DE CAIXA '!C40","v":14.194457602918538}]
[null,"Alavancagem ",0.7,null,null,"TIR do Projeto",{"$f":"'9. FLUXO DE CAIXA '!C28","v":8.2778122253040376E-2}]
[null,"Impostos (Lucro Presumido)",0.17330000000000001,null,null,"VPL do  Projeto",{"$f":"'9. FLUXO DE CAIXA '!C29","v":143621.72685741633}]
[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.066276746875277}]
[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 II"]
[null,null,null,null,null,"Valor captado",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26568557.275555238}]
[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.1907810381705342}]

{"sheet":"2.1. RESUMO","index":5,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"RESUMO","GRUPO II"]
[null,"Receita Bruta total",{"$f":"SUM('9. FLUXO DE CAIXA '!D5:AA5)","v":121172740.23089135}]
[null,"CAPEX total",{"$f":"'3. CAPEX '!F25","v":37955081.822221771}]
[null,"OPEX total",{"$f":"SUM('4. OPEX'!D10:AA10)","v":14938508.950917007}]
[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":20665581.362475242}]
[null,"Contraprestação Mensal",{"$f":"'9. FLUXO DE CAIXA '!D5/12","v":420738.68135726143}]
[null,"Contraprestação Anual",{"$f":"'9. FLUXO DE CAIXA '!D5","v":5048864.176287137}]
[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 II"]
[null,"TIR acionista",{"$f":"'9. FLUXO DE CAIXA '!C38","v":0.10217936669548866}]
[null,"VPL acionista",{"$f":"'9. FLUXO DE CAIXA '!C39","v":2770499.1691069826}]
[null,"Payback acionista",{"$f":"'9. FLUXO DE CAIXA '!C40","v":14.194457602918538}]
[null,"TIR do Projeto",{"$f":"'9. FLUXO DE CAIXA '!C28","v":8.2778122253040376E-2}]
[null,"VPL do  Projeto",{"$f":"'9. FLUXO DE CAIXA '!C29","v":143621.72685741633}]
[null,"Payback do projeto",{"$f":"'9. FLUXO DE CAIXA '!C31","v":10.066276746875277}]
[]
[null,"PREMISSAS DE FINANCIAMENTO","GRUPO II"]
[null,"Alavancagem ",{"$f":"'5. CMPC (WACC)'!G10","v":0.7}]
[null,"Valor captado",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26568557.275555238}]
[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.1907810381705342}]

{"sheet":"3. CAPEX ","index":6,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2],[13,1,13,2],[22,1,22,2],[24,1,24,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",10133178.225563912,583083.42857142864,{"$f":"D3+E3","v":10716261.654135341}]
[null,"1.2","INVERSORES",1734098.5867415732,99783.515786516858,1833882.1025280901]
[null,"1.3","SUPORTES RACK",3892397.6580000003,223976.37949999998,4116374.0375000001]
[null,"1.4","STRINGS/CABOS ECONECTORES",997600.56,57403.939999999995,1055004.5]
[null,"1.5","SKID STATION",3794812.7520000003,218361.14799999999,4013173.9000000004]
[null,"1.6","MÃO DE OBRA p/. MONTAGEM DA UFV",6050661.6699999971,348167.22583333316,6398828.8958333302]
[null,"1.7","OBRAS CIVIS",1880708.5431555619,108219.74715891226,1988928.2903144741]
[]
[null,"SUBTOTAL UFV (R$)",null,{"$f":"SUM(D3:D9)","v":28483457.995461047},1638995.3848501907,30122453.380311228]
[]
[]
[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",481120.50844221166,27684.640433026831,{"$f":"D15+E15","v":508805.14887523849}]
[null,"2.2","AQUISIÇÃO DO TERRENO",391127.10506999999,22506.239242499996,413633.34431249998]
[null,"2.3","REDE DE MÉDIA TENSÃO",1535400,88350,1623750]
[null,"2.4","CABINE DE MÉDIA TENSÃO",3039907.7520000003,174922.39799999999,3214830.1500000004]
[null,"2.5","CUSTO COM CONEXÃO",818880,47120,866000]
[null,"2.6","ESTAÇÃO SOLARIMÉTRICA",982553.64,56538.109999999993,1039091.75]
[null,"2.7","LICENÇAS E SEGUROS ",157457.62094472419,9060.4277780815282,166518.04872280572]
[]
[null,"SUBTOTAL (R$)",null,{"$f":"SUM(D15:D21)","v":7406446.6264569359},426181.81545360829,7832628.4419105444]
[]
[null,"TOTAL GERAL (R$)",null,{"$f":"D11+D23","v":35889904.621917985},2065177.200303799,37955081.822221771]

{"sheet":"4. OPEX","index":7,"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$)",153847.91999999998,{"$f":"D4","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,153847.91999999998,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$)",382493.5056712121,{"$f":"D5","v":382493.5056712121},382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,382493.5056712121,9179844.1361090932]
[null,3,"Despesa sócio-ambientais  (R$)",1335.8333333333333,{"$f":"D6","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,32059.999999999989]
[null,4,"Seguros e garantias  (R$)",30760.61395032988,{"$f":"D7","v":30760.61395032988},30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,30760.61395032988,738254.73480791692]
[null,5,"Segurança patrimonial  (R$)",54000,{"$f":"D8","v":54000},54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,54000,1296000]
[]
[null,"TOTAL (R$)",null,{"$f":"SUM(D4:D9)","v":622437.87295487535},{"$f":"SUM(E4:E8)","v":622437.87295487535},622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,622437.87295487535,14938508.950917009]

{"sheet":"5. CMPC (WACC)","index":8,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,2,1,6],[3,2,3,6],[4,2,4,5],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[20,2,20,5],[21,2,21,4],[22,2,22,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[9,2,9,4],[11,2,11,6],[12,2,12,5],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,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",{"$f":"'2. SIMULADOR'!C11","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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,7]

{"sheet":"6. CONTRAPRESTAÇÃO","index":9,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,1,18,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[15,1,15,2],[16,1,16,2],[1,1,1,3],[3,1,3,2],[4,1,4,2],[9,1,9,2],[13,1,13,2]]}
[]
[null,"Cálculo da Contraprestação | Grupo 2"]
[]
[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,{"$f":"'2. SIMULADOR'!C12","v":0.17330000000000001}]
[]
[null,"CUSTOS DE INVESTIMENTO"]
[null,"1º CAPEX (R$) ",null,{"$f":"'3. CAPEX '!D25","v":35889904.621917985}]
[null,"2º CAPEX (R$)",{"$f":"'3. CAPEX '!E25","v":2065177.200303799}]
[null,"2º CAPEX Descontado (R$)",null,{"$f":"C12/(1+D5)^12","v":799534.6360279175}]
[null,"CAPEX Total (R$)",null,{"$f":"SUM(D11:D13)","v":36689439.257945903}]
[]
[null,"Custo anualizado"]
[null,"CAPEX anualizado (CAE) (R$)",null,{"$f":"D14*((D5*(1+D5)^24)/((1+D5)^24-1))","v":3551458.1415817011}]
[null,"OPEX (anual) (R$)",null,{"$f":"'4. OPEX'!D10","v":622437.87295487535}]
[null,"Total (R$)",null,{"$f":"D17+D18","v":4173896.0145365763}]
[]
[null,"Contraprestação anual"]
[null,"CUSTO ANUALIZADO (R$)",null,{"$f":"D19","v":4173896.0145365763}]
[null,"Impostos (R$)",null,{"$f":"(D19/(1-D8))-D22","v":874968.16175056063}]
[null,"VALOR DA CONTRAPRESTAÇÃO (R$)",null,{"$f":"SUM(D22:D23)","v":5048864.176287137}]

{"sheet":"7. VARIÁVEIS DE FINANCIAMENTO","index":10,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,4,9,5],[10,1,10,2],[10,4,10,5],[12,1,12,2],[17,7,17,8],[9,1,9,2],[1,1,1,5],[3,1,3,2],[3,4,3,5],[5,1,5,2],[5,4,5,5],[6,1,6,2],[7,1,7,2],[6,4,6,5],[7,4,7,5],[8,1,8,2],[8,4,8,5]]}
[]
[null,"VARIÁVEIS DE FINANCIAMENTO"]
[]
[null,"LINHA DE FINANCIAMENTO ",null,null,"BNDES FINAME Baixo Carbono",null,null,null,"ITENS FINANCIÁVEIS","VALOR\n(R$)"]
[null,null,null,null,null,null,null,"1- USINA SOLAR FOTOVOLTAICA"]
[null,"Taxa de juros",null,null,"(IPCA + parcela fixa TLP) + remuneração BNDES",null,null,"1.1","PAINEIS",{"$f":"'3. CAPEX '!F3","v":10716261.654135341}]
[null,"Sistema de amortização",null,null,"SAC",null,null,"1.2","INVERSORES",{"$f":"'3. CAPEX '!F4","v":1833882.1025280901}]
[null,"Remuneração BNDES",null,null,"0,95% a.a.",null,null,"1.3","SUPORTES RACK",{"$f":"'3. CAPEX '!F5","v":4116374.0375000001}]
[null,"Mês de Referência",null,null,"2023-10-01",null,null,"1.4","STRINGS/CABOS ECONECTORES",{"$f":"'3. CAPEX '!F6","v":1055004.5}]
[null,"Participação do BNDES",null,null,"100% dos itens financiáveis",null,null,"1.5","SKID STATION",{"$f":"'3. CAPEX '!F7","v":4013173.9000000004}]
[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":508805.14887523849}]
[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":1623750}]
[null,"AGENTE FINANCEIRO",0,null,null,null,null,"2.4","CABINE DE MÉDIA TENSÃO",{"$f":"'3. CAPEX '!F18","v":3214830.1500000004}]
[null,"IPCA",2.5999999999999999E-3,null,null,null,null,"2.5","CUSTO COM CONEXÃO",{"$f":"'3. CAPEX '!F19","v":866000}]
[null,"TLP fixa",5.1400000000000001E-2,null,null,null,null,"2.6","ESTAÇÃO SOLARIMÉTRICA",{"$f":"'3. CAPEX '!F20","v":1039091.75}]
[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(J6:J16)","v":28987173.243038669}]
[]
[]
[null,"CAPEX","ALAVANCAGEM","EMPRÉSTIMO\n(R$)","ITENS FINANCIÁVEIS\n(R$)","% DOS ITENS FINANCIÁVEIS"]
[null,{"$f":"'3. CAPEX '!F25","v":37955081.822221771},{"$f":"'2. SIMULADOR'!C11","v":0.7},{"$f":"B22*C22","v":26568557.275555238},{"$f":"J18","v":28987173.243038669},{"$f":"D22/E22","v":0.91656254484682231}]

{"sheet":"8. SIMULAÇÃO DE FINANCIAMENTO","index":11,"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":26568557.275555238}]
[]
[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":26568557.275555238},{"$f":"C7","v":26568557.275555238},26568557.275555238,{"$f":"E7-E8","v":23911701.547999714},21254845.820444189,18597990.092888664,15941134.36533314,13284278.637777615,10627422.910222091,7970567.1826665672,5313711.4551110435,2656855.7275555199,-3.7252902984619141E-9]
[null,"Amortização\n(R$)",null,null,{"$f":"C7/10","v":2656855.7275555236},{"$f":"E8","v":2656855.7275555236},2656855.7275555236,2656855.7275555236,2656855.7275555236,2656855.7275555236,2656855.7275555236,2656855.7275555236,2656855.7275555236,2656855.7275555236]
[null,"Juros\n(R$)",{"$f":"$C$4*C7","v":1687103.3869977577},1687103.3869977577,1687103.3869977577,1518393.0482979817,1349682.709598206,1180972.3708984302,1012262.0321986544,843551.69349887862,674841.35479910276,506131.01609932701,337420.67739955126,168710.33869977552]
[null,"Prestação\n (R$)",{"$f":"SUM(C8:C9)","v":1687103.3869977577},1687103.3869977577,4343959.1145532811,4175248.7758535054,4006538.4371537296,3837828.0984539539,3669117.7597541781,3500407.4210544024,3331697.0823546266,3162986.7436548509,2994276.4049550751,2825566.0662552994]

{"sheet":"9. FLUXO DE CAIXA ","index":12,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fluxo de caixa LP (70/30)","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":5048864.176287137},5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137]
[null,"Contraprestação do poder concedente",null,{"$f":"'6. CONTRAPRESTAÇÃO'!D24","v":5048864.176287137},{"$f":"D5","v":5048864.176287137},5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137]
[]
[null,"Impostos"]
[null,"PIS (0,65%)",null,{"$f":"D5*0.0065*-1","v":-32817.617145866388},{"$f":"-(E5*0.0065)","v":-32817.617145866388},-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388]
[null,"COFINS (3,00%)",null,{"$f":"-(D5*0.03)","v":-151465.92528861409},-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409]
[null,"ISS (3,00%)",null,{"$f":"0.03*D5*-1","v":-151465.92528861409},{"$f":"D10","v":-151465.92528861409},-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409]
[]
[null,"Receita Operacional Líquida (ROL)",null,{"$f":"D5+D8+D9+D10","v":4713114.708564043},4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043,4713114.708564043]
[null,"(-) Custos de operação e manutenção (OPEX)",null,{"$f":"-1*'4. OPEX'!D10","v":-622437.87295487535},{"$f":"D13","v":-622437.87295487535},-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535]
[null,"(-) IRPJ",null,{"$f":"-(D4*0.32)*0.15","v":-242345.48046178254},-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254]
[null,"(-) IRPJ do excedente",null,{"$f":"-(0.32*D5-240000)*0.1","v":-137563.65364118837},-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837]
[null,"(-) CSLL",null,{"$f":"-0.32*D4*0.09","v":-145407.28827706954},{"$f":"-0.32*E5*0.09","v":-145407.28827706954},-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954]
[]
[null,"LUCRO LIQUIDO APÓS IR",null,{"$f":"SUM(D12:D16)","v":3565360.4132291269},3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269]
[null,"(-) CAPEX(Investimentos)",{"$f":"-1*'3. CAPEX '!D25","v":-35889904.621917985},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-1*'6. CONTRAPRESTAÇÃO'!C12","v":-2065177.200303799}]
[]
[null,"Fluxo de caixa do projeto",{"$f":"C19","v":-35889904.621917985},{"$f":"D18+D19","v":3565360.4132291269},3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,1500183.2129253279,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269]
[null,"Fluxo de caixa  acumulado",{"$f":"C21","v":-35889904.621917985},{"$f":"C22+D21","v":-32324544.208688859},-28759183.795459732,-25193823.382230606,-21628462.969001479,-18063102.555772353,-14497742.142543226,-10932381.7293141,-7367021.3160849735,-3801660.9028558466,-236300.48962671962,3329059.9236024073,4829243.1365277357,8394603.5497568622,11959963.962985989,15525324.376215115,19090684.789444242,22656045.202673368,26221405.615902495,29786766.029131621,33352126.442360748,36917486.855589874,40482847.268819004,44048207.682048135,47613568.095277265]
[null,"(+) Captação de empréstimo",{"$f":"'7. VARIÁVEIS DE FINANCIAMENTO'!D22","v":26568557.275555238}]
[null,"(-) Despesas financeiras(juros de empréstimo)",null,{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!C9","v":-1687103.3869977577},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!D9","v":-1687103.3869977577},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!E9","v":-1687103.3869977577},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!F9","v":-1518393.0482979817},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!G9","v":-1349682.709598206},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!H9","v":-1180972.3708984302},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!I9","v":-1012262.0321986544},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!J9","v":-843551.69349887862},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!K9","v":-674841.35479910276},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!L9","v":-506131.01609932701},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!M9","v":-337420.67739955126},{"$f":"-1*'8. SIMULAÇÃO DE FINANCIAMENTO'!N9","v":-168710.33869977552}]
[null,"(-) Amortização do empréstimo",null,null,null,{"$f":"C23/10*-1","v":-2656855.7275555236},{"$f":"F25","v":-2656855.7275555236},-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236]
[]
[null,"Indicadores do projeto"]
[null,"TIR do projeto",{"$f":"IRR(C21:AA21)","v":8.2778122253040376E-2}]
[null,"VPL do projeto",{"$f":"NPV(C43,D21:AA21)+C21","v":143621.72685741633}]
[null,"Payback simples(contagem)",null,{"$f":"IF(D22<0,1,IF(C22>0,0,-C22/D21))","v":1},1,1,1,1,1,1,1,1,1,6.6276746875276932E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Payback do projeto",{"$f":"SUM(D30:AA30)","v":10.066276746875277}]
[]
[null,"Fluxo de caixa livre do acionista",{"$f":"C19+C23","v":-9321347.3463627473},{"$f":"D21+D24+D25","v":1878257.0262313692},1878257.0262313692,-778598.70132415439,-609888.36262437841,-441178.02392460266,-272467.68522482691,-103757.34652505117,64952.992174724583,233663.3308745008,402373.66957427654,571084.00827405229,-1325382.8533299712,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269,3565360.4132291269]
[null,"Fluxo de caixa acumulado",{"$f":"C33","v":-9321347.3463627473},{"$f":"C34+D33","v":-7443090.3201313782},-5564833.2939000092,-6343431.9952241639,-6953320.3578485418,-7394498.381773144,-7666966.0669979714,-7770723.4135230221,-7705770.421348298,-7472107.0904737972,-7069733.4208995206,-6498649.4126254683,-7824032.2659554398,-4258671.8527263124,-693311.43949718541,2872048.9737319415,6437409.386961069,10002769.800190195,13568130.213419322,17133490.626648448,20698851.039877575,24264211.453106701,27829571.866335828,31394932.279564954,34960292.692794085]
[null,"Payback simples(contagem)",null,{"$f":"IF(D34<0,1,IF(C34>0,0,-C34/D33))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,0.19445760291853836,0,0,0,0,0,0,0,0,0]
[]
[null,"Indicadores do acionista"]
[null,"TIR do acionista",{"$f":"IRR(C33:AA33)","v":0.10217936669548866}]
[null,"VPL do acionista",{"$f":"NPV(C43,D33:AA33)+C33","v":2770499.1691069826}]
[null,"Payback do acionista",{"$f":"SUM(D35:AA35)","v":14.194457602918538}]
[null,"Índice de Cobertura do Serviço da Dívida (ICSD)",{"$f":"AVERAGE(D41:M41)","v":1.1907810381705342},{"$f":"-((D12+D13)+SUM(D14:D16))/SUM(D24,D25)","v":2.1133028602199504},2.1133028602199504,0.82076288455025614,0.85392765907710388,0.88988548822259195,0.92900471875366475,0.97172144550301864,1.0185558377530692,1.0701334260284439,1.1272132013772942,1.1907252140547193,1.2618216419743007]
[]
[null,"TMA(CMPC)",{"$f":"'5. CMPC (WACC)'!G5","v":8.2289229700654831E-2}]

{"sheet":"10. DRE","index":13,"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":5048864.176287137},5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137]
[null,"Receita da Contraprestação",null,{"$f":"'9. FLUXO DE CAIXA '!D5","v":5048864.176287137},{"$f":"D5","v":5048864.176287137},5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137]
[]
[null,"Tributos"]
[null,"PIS (0,65%)",null,{"$f":"D5*-1*0.0065","v":-32817.617145866388},{"$f":"D8","v":-32817.617145866388},-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388,-32817.617145866388]
[null,"COFINS (3%)",null,{"$f":"-1*D5*0.03","v":-151465.92528861409},{"$f":"D9","v":-151465.92528861409},-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409]
[null,"ISS (3%)",null,{"$f":"-1*D5*0.03","v":-151465.92528861409},{"$f":"D10","v":-151465.92528861409},-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409,-151465.92528861409]
[]
[null,"Receita Líquida",null,{"$f":"D4+D7","v":5048864.176287137},5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137,5048864.176287137]
[]
[null,"Custos Operacionais"]
[null,"Custos de operação e manutenção (OPEX)",null,{"$f":"-1*'4. OPEX'!D10","v":-622437.87295487535},{"$f":"D15","v":-622437.87295487535},-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535,-622437.87295487535]
[]
[null,"Lucro operacional",null,{"$f":"D12+D15","v":4426426.3033322617},4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617]
[]
[null,"Despesas Financeiras"]
[null,"Juros",null,{"$f":"'9. FLUXO DE CAIXA '!D24","v":-1687103.3869977577},{"$f":"'9. FLUXO DE CAIXA '!E24","v":-1687103.3869977577},{"$f":"'9. FLUXO DE CAIXA '!F24","v":-1687103.3869977577},{"$f":"'9. FLUXO DE CAIXA '!G24","v":-1518393.0482979817},{"$f":"'9. FLUXO DE CAIXA '!H24","v":-1349682.709598206},{"$f":"'9. FLUXO DE CAIXA '!I24","v":-1180972.3708984302},{"$f":"'9. FLUXO DE CAIXA '!J24","v":-1012262.0321986544},{"$f":"'9. FLUXO DE CAIXA '!K24","v":-843551.69349887862},{"$f":"'9. FLUXO DE CAIXA '!L24","v":-674841.35479910276},{"$f":"'9. FLUXO DE CAIXA '!M24","v":-506131.01609932701},{"$f":"'9. FLUXO DE CAIXA '!N24","v":-337420.67739955126},{"$f":"'9. FLUXO DE CAIXA '!O24","v":-168710.33869977552}]
[null,"Amortização",null,null,null,{"$f":"'9. FLUXO DE CAIXA '!F25","v":-2656855.7275555236},{"$f":"F21","v":-2656855.7275555236},-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236,-2656855.7275555236]
[]
[null,"Lucros antes dos impostos",null,{"$f":"D17+D20+D21","v":2739322.9163345043},2739322.9163345043,82467.188778980635,251177.52747875638,419887.86617853213,588598.20487830788,757308.54357808363,926018.88227785937,1094729.2209776351,1263439.5596774109,1432149.8983771866,1600860.2370769624,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617,4426426.3033322617]
[null,"Imposto de Renda",null,{"$f":"-(D4*0.32)*0.15","v":-242345.48046178254},-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254,-242345.48046178254]
[null,"Imposto de Renda sobre excedente",null,{"$f":"-(0.32*D4-240000)*0.1","v":-137563.65364118837},-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837,-137563.65364118837]
[null,"Contribuição Social",null,{"$f":"-(0.32*D4)*0.09","v":-145407.28827706954},-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954,-145407.28827706954]
[]
[null,"Lucro Líquido",null,{"$f":"D23+D24+D26","v":2351570.1475956519},2351570.1475956519,-305285.57995987148,-136575.2412600957,32135.097439680045,200845.43613945579,369555.77483923151,538266.11353900726,706976.45223878301,875686.79093855876,1044397.1296383345,1213107.4683381103,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094]
[]
[null,"Dividendos"]
[]
[null,"Lucros Retidos",null,{"$f":"D28+D30","v":2351570.1475956519},2351570.1475956519,-305285.57995987148,-136575.2412600957,32135.097439680045,200845.43613945579,369555.77483923151,538266.11353900726,706976.45223878301,875686.79093855876,1044397.1296383345,1213107.4683381103,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094,4038673.5345934094]