Sanetran

UTRS · Estudo técnico

Balanço de Massa × Energia

Aba da planilha

Fluxo Caixa

Cenário integrado · 0 ajustes de orçamento

Investimento A

143,06 R$ mi

OPEX anual A

11,3 R$ mi

EBITDA A

-5,99 R$ mi

VPL do projeto A

-168,02 R$ mi

Cenários A × B · R$ milhões

Fluxo de caixa - 2 anos de obra + 25 anos de operação (R$ mil, preços constantes)

Fim de ano; sem valor residual nem capital de giro. Valores positivos de custos e subtração nas fórmulas. Cenário A: bloco superior; cenário B: bloco inferior.
Ano do projeto (t)-Total123456789101112131415161718192021222324252627
Ano de operação (j)0012345678910111213141516171819202122232425
Flag de operação001111111111111111111111111
Fator de operação (rampa 1º ano)000,85111111111111111111111111
Fator de créditos de carbono (rampa)000,5111111111111111111111111
CENÁRIO A - 60 bar / 450 °C
Energia exportadaMWh517.1440017.68920.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.81120.811
Receita de energiaR$ mil129.286004.4225.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.2035.203
Consumo evitado (linha de pellet) creditadoR$ mil0000000000000000000000000000
Receita de créditos de carbonoR$ mil9.43600192,6385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1385,1
Complementação de receita (contraprestação)R$ mil0000000000000000000000000000
RECEITA BRUTAR$ mil138.722004.6155.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.5885.588
(-) PIS/COFINSR$ mil6.93600230,7279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4279,4
RECEITA LÍQUIDAR$ mil131.786004.3845.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.3085.308
(-) OPEX fixoR$ mil153.972006.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.1596.159
(-) OPEX variávelR$ mil115.536003.9524.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.6494.649
(-) Comercialização da energiaR$ mil4.52500154,8182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1182,1
(-) MRV / registro dos créditosR$ mil7.66500278,9307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8307,8
EBITDAR$ mil-149.91300-6.160-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990
(-) DepreciaçãoR$ mil143.0600014.30614.30614.30614.30614.30614.30614.30614.30614.30614.306000000000000000
Lucro antes do IR (sem juros)R$ mil-292.97300-20.466-20.296-20.296-20.296-20.296-20.296-20.296-20.296-20.296-20.296-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990
(-) IR/CSLL (sem benefício de prejuízo)R$ mil0000000000000000000000000000
(-) CAPEXR$ mil143.06057.22485.8360000000000000000000000000
FLUXO DE CAIXA DO PROJETO (FCFF)R$ mil-292.973-57.224-85.836-6.160-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990
FCFF acumuladoR$ mil-57.224-143.060-149.220-155.210-161.200-167.189-173.179-179.169-185.158-191.148-197.138-203.127-209.117-215.107-221.096-227.086-233.076-239.065-245.055-251.045-257.035-263.024-269.014-275.004-280.993-286.983-292.973
Auxiliar de payback (anos de operação)anos000000000000000000000000000
Financiamento - saquesR$ mil85.83634.33451.5020000000000000000000000000
Financiamento - jurosR$ mil56.4621.2884.6036.8796.5066.1055.6735.2094.7114.1753.5982.9792.3131.597827,30000000000000
Financiamento - amortizaçãoR$ mil91.726004.9795.3525.7546.1856.6497.1487.6848.2608.8799.54510.26111.0310000000000000
Financiamento - prestação (PRICE)R$ mil142.2980011.85811.85811.85811.85811.85811.85811.85811.85811.85811.85811.85811.8580000000000000
Financiamento - saldo devedor finalR$ mil35.62291.72686.74881.39675.64269.45762.80855.66047.97739.71730.83821.29211.03100000000000000
Dívida capitalizada ao fim da obra (base da PRICE)R$ mil91.726
Lucro antes do IR (com juros)R$ mil-343.54400-27.346-26.802-26.400-25.969-25.505-25.006-24.470-23.894-23.274-22.608-7.587-6.817-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990
(-) IR/CSLL alavancadoR$ mil0000000000000000000000000000
FLUXO DE CAIXA DO ACIONISTA (FCFE)R$ mil-349.435-22.890-34.334-18.019-17.848-17.848-17.848-17.848-17.848-17.848-17.848-17.848-17.848-17.848-17.848-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990-5.990
DSCRx00-0,5195-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,50510000000000000
DSCR auxiliar (999 = sem dívida)x999999-0,5195-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051-0,5051999999999999999999999999999999999999999
Ano com serviço da dívida0/1001111111111110000000000000
Custos para LCOE (CAPEX + OPEX fixo + variável + comercialização)R$ mil417.09357.22485.83610.26610.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.99010.990
CENÁRIO B (alternativo) - 40 bar / 400 °C
Energia exportadaMWh511.3260017.49020.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.57720.577
Receita de energiaR$ mil127.832004.3735.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.1445.144
Consumo evitado (linha de pellet) creditadoR$ mil0000000000000000000000000000
Receita de créditos de carbonoR$ mil9.42800192,4384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8384,8
Complementação de receita (contraprestação)R$ mil0000000000000000000000000000
RECEITA BRUTAR$ mil137.260004.5655.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.5295.529
(-) PIS/COFINSR$ mil6.86300228,2276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4276,4
RECEITA LÍQUIDAR$ mil130.397004.3375.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.2535.253
(-) OPEX fixoR$ mil149.439005.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.9785.978
(-) OPEX variávelR$ mil116.299003.9784.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.6804.680
(-) Comercialização da energiaR$ mil4.47400153180180180180180180180180180180180180180180180180180180180180180180180180
(-) MRV / registro dos créditosR$ mil7.66400278,9307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7307,7
EBITDAR$ mil-147.48000-6.051-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893
(-) DepreciaçãoR$ mil133.3100013.33113.33113.33113.33113.33113.33113.33113.33113.33113.331000000000000000
Lucro antes do IR (sem juros)R$ mil-280.79000-19.382-19.224-19.224-19.224-19.224-19.224-19.224-19.224-19.224-19.224-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893
(-) IR/CSLL (sem benefício de prejuízo)R$ mil0000000000000000000000000000
(-) CAPEXR$ mil133.31053.32479.9860000000000000000000000000
FLUXO DE CAIXA DO PROJETO (FCFF)R$ mil-280.790-53.324-79.986-6.051-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893
FCFF acumuladoR$ mil-53.324-133.310-139.361-145.254-151.147-157.039-162.932-168.825-174.718-180.611-186.504-192.397-198.290-204.182-210.075-215.968-221.861-227.754-233.647-239.540-245.432-251.325-257.218-263.111-269.004-274.897-280.790
Auxiliar de payback (anos de operação)anos000000000000000000000000000
Financiamento - saquesR$ mil79.98631.99447.9920000000000000000000000000
Financiamento - jurosR$ mil52.6141.2004.2896.4116.0635.6895.2874.8544.3903.8903.3532.7762.1551.488770,90000000000000
Financiamento - amortizaçãoR$ mil85.475004.6394.9875.3615.7646.1966.6607.1607.6978.2748.8959.56210.2790000000000000
Financiamento - prestação (PRICE)R$ mil132.6000011.05011.05011.05011.05011.05011.05011.05011.05011.05011.05011.05011.0500000000000000
Financiamento - saldo devedor finalR$ mil33.19485.47580.83675.84870.48764.72358.52851.86744.70737.01028.73619.84110.27900000000000000
Dívida capitalizada ao fim da obra (base da PRICE)R$ mil85.475
Lucro antes do IR (com juros)R$ mil-327.91500-25.792-25.287-24.912-24.510-24.078-23.613-23.114-22.577-22.000-21.379-7.381-6.664-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893
(-) IR/CSLL alavancadoR$ mil0000000000000000000000000000
FLUXO DE CAIXA DO ACIONISTA (FCFE)R$ mil-333.404-21.330-31.994-17.101-16.943-16.943-16.943-16.943-16.943-16.943-16.943-16.943-16.943-16.943-16.943-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893-5.893
DSCRx00-0,5476-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,53330000000000000
DSCR auxiliar (999 = sem dívida)x999999-0,5476-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333-0,5333999999999999999999999999999999999999999
Ano com serviço da dívida0/1001111111111110000000000000
Custos para LCOE (CAPEX + OPEX fixo + variável + comercialização)R$ mil403.52253.32479.98610.10910.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.83810.838

Fórmulas vinculadas ao cenário atual. Notas, laudos e hipóteses fixas preservados da planilha. Ajustes mantidos durante a navegação; recarregar restaura o cenário base.