Baixe o app para aproveitar ainda mais
Prévia do material em texto
Planilha1 Ano 0 1 2 3 4 5 6 7 8 9 10 IBA Recuperado (ton) - 133 133 133 133 133 133 133 133 133 133 Preço unitário de venda IBA - R$ 3,000.00 Preço total de venda IBA - R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 R$ 399,000.00 PIS/COFINS - -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 -R$ 36,907.50 ICMS - -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 -R$ 71,820.00 Resultado Bruto IBA - R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 R$ 290,272.50 Ano 0 1 2 3 4 5 6 7 8 9 10 DBIP Recuperado (ton) - 384 384 384 384 384 384 384 384 384 384 Preço unitário de venda DBIP - R$ 4,000.00 Preço total de venda DBIP - R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 R$ 1,152,000.00 PIS/COFINS - -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 -R$ 106,560.00 ICMS - -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 -R$ 207,360.00 Resultado Bruto DBIP - R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 R$ 838,080.00 Ano 0 1 2 3 4 5 6 7 8 9 10 Total Reduzido DBO - 505 505 505 505 505 505 505 505 505 505 Ganho Por DBO Reduzido - R$ 2,500.00 Total de Ganhos DBO - R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 R$ 1,262,500.00 Ano 0 1 2 3 4 5 6 7 8 9 10 Consumo Elétrico - 58400 58400 58400 58400 58400 58400 58400 58400 58400 58400 Custo Elétrico - R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 R$ 1.50 Total Despesa Elétrica - -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 -R$ 87,600.00 Consumo de Vapor - 4015 4015 4015 4015 4015 4015 4015 4015 4015 4015 Custo Vapor - R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 R$ 80.00 Total Despesa Vapor - -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 -R$ 321,200.00 Valor Total Investido - R$ 5,400,000.00 Ano 0 1 2 3 4 5 6 7 8 9 10 Depreciação - -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 -R$ 1,080,000.00 Ano 0 1 2 3 4 5 6 7 8 9 10 Resultado Antes do IR/CSLL - R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 R$ 902,052.50 IR/ICSLL - 34% Resultado Contábil - R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 R$ 595,354.65 Estorno Depreciação - R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 R$ 1,080,000.00 Resultado Financeiro -R$ 5,400,000.00 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 R$ 1,675,354.65 Fluxo de Caixa Acumulado -R$ 5,400,000.00 -R$ 3,724,645.35 -R$ 2,049,290.70 -R$ 373,936.05 R$ 1,301,418.60 R$ 2,976,773.25 R$ 4,652,127.90 R$ 6,327,482.55 R$ 8,002,837.20 R$ 9,678,191.85 R$ 11,353,546.50 Fluxo de Caixa Descontado -R$ 5,400,000.00 R$ 1,456,830.13 R$ 1,266,808.81 R$ 1,101,572.88 R$ 957,889.46 R$ 832,947.36 R$ 724,302.05 R$ 629,827.87 R$ 547,676.41 R$ 476,240.35 R$ 414,122.05 Fluxo de Caixa Desc. Acum. -R$ 5,400,000.00 -R$ 3,943,169.87 -R$ 2,676,361.06 -R$ 1,574,788.18 -R$ 616,898.72 R$ 216,048.63 R$ 940,350.68 R$ 1,570,178.55 R$ 2,117,854.95 R$ 2,594,095.31 R$ 3,008,217.35 Ano Mês PayBack Simples 3 3 PayBack Composto 4 9 VPL R$ 3,008,217.35 TIR 28%
Compartilhar