Baixe o app para aproveitar ainda mais
Leia os materiais offline, sem usar a internet. Além de vários outros recursos!
PLANILHA PORTFÓLIO INDIVIDUAL
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Plan1 DRE e Fluxo de Caixa 1 2 3 4 5 6 7 8 9 10 11 12 Total Preço de Venda R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 R$ 72.00 Quantidade 20,000 20,000 20,000 23,200 23,200 23,200 30,600 30,600 30,600 30,600 30,600 30,600 313,200 Receita Bruta R$ 120,000.00 R$ 120,000.00 R$ 120,000.00 R$ 139,200.00 R$ 139,200.00 R$ 139,200.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 1,879,200.00 ICMS R$ 21,600.00 R$ 21,600.00 R$ 21,600.00 R$ 25,056.00 R$ 25,056.00 R$ 25,056.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 338,256.00 PIS R$ 1,980.00 R$ 1,980.00 R$ 1,980.00 R$ 2,296.80 R$ 2,296.80 R$ 2,296.80 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 31,006.80 COFINS R$ 9,120.00 R$ 9,120.00 R$ 9,120.00 R$ 10,579.20 R$ 10,579.20 R$ 10,579.20 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 142,819.20 Comissão R$ 2,400.00 R$ 2,400.00 R$ 2,400.00 R$ 2,784.00 R$ 2,784.00 R$ 2,784.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 37,584.00 Receita Líquida R$ 84,900.00 R$ 84,900.00 R$ 84,900.00 R$ 98,484.00 R$ 98,484.00 R$ 98,484.00 R$ 129,897.00 R$ 129,897.00 R$ 129,897.00 R$ 129,897.00 R$ 129,897.00 R$ 129,897.00 R$ 1,329,534.00 CPV R$ 63,000.00 R$ 63,000.00 R$ 63,000.00 R$ 73,080.00 R$ 73,080.00 R$ 73,080.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 986,580.00 Lucro Bruto R$ 21,900.00 R$ 21,900.00 R$ 21,900.00 R$ 25,404.00 R$ 25,404.00 R$ 25,404.00 R$ 33,507.00 R$ 33,507.00 R$ 33,507.00 R$ 33,507.00 R$ 33,507.00 R$ 33,507.00 R$ 342,954.00 água - luz - telefone R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 25,200.00 prolabore R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 66,000.00 salário + encargos R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 100,200.00 transporte R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 21,600.00 marketing R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 12,000.00 depreciação R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 2,200.00 R$ 26,400.00 Lucro Operacional R$ 950.00 R$ 950.00 R$ 950.00 R$ 4,454.00 R$ 4,454.00 R$ 4,454.00 R$ 12,557.00 R$ 12,557.00 R$ 12,557.00 R$ 12,557.00 R$ 12,557.00 R$ 12,557.00 R$ 91,554.00 IR R$ 142.50 R$ 142.50 R$ 142.50 R$ 668.10 R$ 668.10 R$ 668.10 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 13,733.10 CS R$ 85.50 R$ 85.50 R$ 85.50 R$ 400.86 R$ 400.86 R$ 400.86 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 8,239.86 Lucro Líquido R$ 722.00 R$ 722.00 R$ 722.00 R$ 3,385.04 R$ 3,385.04 R$ 3,385.04 R$ 9,543.32 R$ 9,543.32 R$ 9,543.32 R$ 9,543.32 R$ 9,543.32 R$ 9,543.32 R$ 69,581.04 Contas a Receber Valor 1 2 3 4 5 6 7 8 9 10 11 12 1 R$ 120,000.00 R$ 40,000.00 R$ 40,000.00 R$ 40,000.00 2 R$ 120,000.00 R$ 40,000.00 R$ 40,000.00 R$ 40,000.00 3 R$ 120,000.00 R$ 40,000.00 R$ 40,000.00 R$ 40,000.00 4 R$ 139,200.00 R$ 46,400.00 R$ 46,400.00 R$ 46,400.00 5 R$ 139,200.00 R$ 46,400.00 R$ 46,400.00 R$ 46,400.00 6 R$ 139,200.00 R$ 46,400.00 R$ 46,400.00 R$ 46,400.00 7 R$ 183,600.00 R$ 61,200.00 R$ 61,200.00 R$ 61,200.00 8 R$ 183,600.00 R$ 61,200.00 R$ 61,200.00 R$ 61,200.00 9 R$ 183,600.00 R$ 61,200.00 R$ 61,200.00 R$ 61,200.00 10 R$ 183,600.00 R$ 61,200.00 R$ 61,200.00 R$ 61,200.00 11 R$ 183,600.00 R$ 61,200.00 R$ 61,200.00 12 R$ 183,600.00 R$ 61,200.00 Total R$ 40,000.00 R$ 80,000.00 R$ 120,000.00 R$ 126,400.00 R$ 132,800.00 R$ 139,200.00 R$ 154,000.00 R$ 168,800.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 Fornecedores Valor 1 2 3 4 5 6 7 8 9 10 11 12 1 R$ 63,000.00 R$ 31,500.00 R$ 31,500.00 2 R$ 63,000.00 R$ 31,500.00 R$ 31,500.00 3 R$ 63,000.00 R$ 31,500.00 R$ 31,500.00 4 R$ 73,080.00 R$ 36,540.00 R$ 36,540.00 5 R$ 73,080.00 R$ 36,540.00 R$ 36,540.00 6 R$ 73,080.00 R$ 36,540.00 R$ 36,540.00 7 R$ 96,390.00 R$ 48,195.00 R$ 48,195.00 8 R$ 96,390.00 R$ 48,195.00 R$ 48,195.00 9 R$ 96,390.00 R$ 48,195.00 R$ 48,195.00 10 R$ 96,390.00 R$ 48,195.00 R$ 48,195.00 11 R$ 96,390.00 R$ 48,195.00 R$ 48,195.00 12 R$ 96,390.00 R$ 48,195.00 Total R$ 31,500.00 R$ 63,000.00 R$ 63,000.00 R$ 68,040.00 R$ 73,080.00 R$ 73,080.00 R$ 84,735.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 1 2 3 4 5 6 7 8 9 10 11 12 Saldo Inicial 0.0 R$ 205,700.00 R$ 168,622.00 R$ 171,544.00 R$ 175,826.00 R$ 175,011.04 R$ 180,596.08 R$ 189,326.12 R$ 186,269.44 R$ 198,012.76 R$ 209,756.08 R$ 221,499.40 Entradas com vendas R$ 40,000.00 R$ 80,000.00 R$ 120,000.00 R$ 126,400.00 R$ 132,800.00 R$ 139,200.00 R$ 154,000.00 R$ 168,800.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 R$ 183,600.00 Capital Integralizado R$ 200,000.00 Saldo em Caixa R$ 240,000.00 R$ 285,700.00 R$ 288,622.00 R$ 297,944.00 R$ 308,626.00 R$ 314,211.04 R$ 334,596.08 R$ 358,126.12 R$ 369,869.44 R$ 381,612.76 R$ 393,356.08 R$ 405,099.40 Fornecedores - CPV R$ 31,500.00 R$ 63,000.00 R$ 63,000.00 R$ 68,040.00 R$ 73,080.00 R$ 73,080.00 R$ 84,735.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 R$ 96,390.00 água - luz - telefone R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 R$ 2,100.00 prolabore R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 R$ 5,500.00 salário + encargos R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 R$ 8,350.00 transporte R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 R$ 1,800.00 marketing R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 R$ 1,000.00 IRPJ R$ 142.50 R$ 142.50 R$ 142.50 R$ 668.10 R$ 668.10 R$ 668.10 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 R$ 1,883.55 CSLL R$ 85.50 R$ 85.50 R$ 85.50 R$ 400.86 R$ 400.86 R$ 400.86 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 R$ 1,130.13 Comissão R$ 2,400.00 R$ 2,400.00 R$ 2,400.00 R$ 2,784.00 R$ 2,784.00 R$ 2,784.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 R$ 3,672.00 ICMS R$ 21,600.00 R$ 21,600.00 R$ 21,600.00 R$ 25,056.00 R$ 25,056.00 R$ 25,056.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 R$ 33,048.00 PIS R$ 1,980.00 R$ 1,980.00 R$ 1,980.00 R$ 2,296.80 R$ 2,296.80 R$ 2,296.80 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 R$ 3,029.40 COFINS R$ 9,120.00 R$ 9,120.00 R$ 9,120.00 R$ 10,579.20 R$ 10,579.20 R$ 10,579.20 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 R$ 13,953.60 Total de Saídas R$ 34,300.00 R$ 117,078.00 R$ 117,078.00 R$ 122,118.00 R$ 133,614.96 R$ 133,614.96 R$ 145,269.96 R$ 171,856.68 R$ 171,856.68 R$ 171,856.68 R$ 171,856.68 R$ 171,856.68 Fluxo de Caixa Livre R$ 5,700.00 -R$ 37,078.00 R$ 2,922.00 R$ 4,282.00 -R$ 814.96 R$ 5,585.04 R$ 8,730.04 -R$ 3,056.68 R$ 11,743.32 R$ 11,743.32 R$ 11,743.32 R$ 11,743.32 Saldo Final Acumul. R$ 205,700.00 R$ 168,622.00 R$ 171,544.00 R$ 175,826.00 R$ 175,011.04 R$ 180,596.08 R$ 189,326.12 R$ 186,269.44 R$ 198,012.76 R$ 209,756.08 R$ 221,499.40 R$ 233,242.72 Orçamento de Vendas e de Produção Administração Financeira e Orçamentária - Realizar o Orçamento de Vendas e o Orçamento de Produção conforme solicitado. Orçamento de Vendas 1º Trimestre 2º Trimestre 3º Trimestre 4 Trimestre Previsão de Vendas (unidades) 60,000 69,600 91,800 91,800 Preço unitário – R$ R$ 6.00 R$ 6.00 R$ 6.00 R$ 6.00 = Total de vendas – R$ (Receita Bruta) R$ 360,000.00 R$ 417,600.00 R$ 550,800.00 R$ 550,800.00 Impostos (27,25%) R$ 98,100.00 R$ 113,796.00 R$ 150,093.00 R$ 150,093.00 Receita Líquida R$ 261,900.00 R$ 303,804.00 R$ 400,707.00 R$ 400,707.00 Orçamento de Produção 1º Trimestre 2º Trimestre 3º Trimestre 4º Trimestre Previsão de Vendas (unidades) 60,000 69,600 91,800 91,800 (+) Estoque Final 10,000 11,600 15,300 15,300 Total Prev. Necessária 70,000 81,200 107,100 107,100 (-) Estoque Inicial 6,960 10,000 11,600 15,300 Previsão de Produção 71,200 71,200 95,500 91,800 MERCADO DE CAPITAIS LPA R$ 34.79 Payout 0.35 Dividendos R$ 24,353.36 Dividendos por ação R$ 12.18 Dividendo yield 0.5983627518 P/L 0.5849294578 Plan3
Compartilhar
Materiais relacionados
7 pág.
1 pág.
Perguntas relacionadas
Compartilhar