PORTFOLIO 6 SEMESTRE PLANILHA

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

TXT
	1o Passo - Elaborar a DRE e o Fluxo de Caixa
	1	2	3	4	5	6	7	8	9	10	11	12	Total
	Preço de Venda	0
	Quantidade	0
	Receita Bruta	0	0	0	0	0	0	0	0	0	0	0	0	0
	ICMS	0	0	0	0	0	0	0	0	0	0	0	0	0
	PIS	0	0	0	0	0	0	0	0	0	0	0	0	0
	COFINS	0	0	0	0	0	0	0	0	0	0	0	0	0
	Comissão	0	0	0	0	0	0	0	0	0	0	0	0	0
	Receita Líquida	0	0	0	0	0	0	0	0	0	0	0	0	0
	CPV	0	0	0	0	0	0	0	0	0	0	0	0	0
	Lucro Bruto	0	0	0	0	0	0	0	0	0	0	0	0	0
	água - luz - telefone	0
	prolabore	0
	salário + encargos	0
	transporte	0
	marketing	0
	depreciação	0
	Lucro Operacional	0	0	0	0	0	0	0	0	0	0	0	0	0
	IR	0	0	0	0	0	0	0	0	0	0	0	0	0
	CS	0	0	0	0	0	0	0	0	0	0	0	0	0
	Lucro Líquido	0	0	0	0	0	0	0	0	0	0	0	0	0
	Contas a Receber	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	0	0.00	0.00	0.00
	2	0	0.00	0.00	0.00
	3	0	0.00	0.00	0.00
	4	0	0.00	0.00	0.00
	5	0	0.00	0.00	0.00
	6	0	0.00	0.00	0.00
	7	0	0.00	0.00	0.00
	8	0	0.00	0.00	0.00
	9	0	0.00	0.00	0.00
	10	0	0.00	0.00	0.00
	11	0	0.00	0.00
	12	0	0.00
	Total	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Fornecedores	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	0	0	0
	2	0	0	0
	3	0	0	0
	4	0	0	0
	5	0	0	0
	6	0	0	0
	7	0	0	0
	8	0	0	0
	9	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0
	Total	0	0	0	0	0	0	0	0	0	0	0	0
	1	2	3	4	5	6	7	8	9	10	11	12
	Saldo Inicial	0.00
	Entradas com vendas	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Capital Integralizado	0.00
	Saldo em Caixa	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Fornecedores - CPV	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	água - luz - telefone	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	prolabore	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	salário + encargos	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	transporte	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	marketing	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	IRPJ	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	CSLL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Comissão	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	ICMS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	PIS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	COFINS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total de Saídas	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Fluxo de Caixa Livre	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Saldo Final Acumul.	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Primeniro Passo - Realizar Orçamento de Vendas e de Produção, cf instruções.
	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)
	Preço unitário – R$
	= Total de vendas – R$ (Receita Bruta)
	Impostos (27,25%)
	Receita Líquida
	Orçamento de Produção
	1º Trimestre	2º Trimestre	3º Trimestre	4º Trimestre
	Previsão de Vendas (unidades)
	(+) Estoque Final
	Total Prev. Necessária
	(-) Estoque Inicial
	Previsão de Produção
	MERCADO DE CAPITAIS
	LPA	0
	Payout	ERROR:#DIV/0!
	Dividendos	0
	Dividendos por ação	0
	Dividendo yield	0
	P/L	ERROR:#DIV/0!
PORTFOLIO
	ORCAMENTO	1	2	3	4	5	6	7	8	9	10	11	12	TOTAL
	PRECO DE VENDA	0.0
	QUANTIDADE	0.0
	RECEITA BRUTA	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	ICMS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	PIS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	COFINS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	COMISSAO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	RECEITA LIQUIDA	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	CPV	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	LUCRO BRUTO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	AGUA - LUZ - TELEFONE	0.0
	PROLABORE	0.0
	SALARIO + ENCARGOS	0.0
	TRANSPORTE	0.0
	MARKETING	0.0
	DEPRECIAÇÃO	0.0
	LUCRO OPERACIONAL	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	IR	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	CS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	LUCRO LIQUIDO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	CONTAS A RECEBER	VALOR	1	2	3	4	5	6	7	8	9	10	11	12
	1	0.0	0.0	0.0	0.0
	2	0.0	0.0	0.0	0.0
	3	0.0	0.0	0.0	0.0
	4	0.0	0.0	0.0	0.0
	5	0.0	0.0	0.0	0.0
	6	0.0	0.0	0.0	0.0
	7	0.0	0.0	0.0	0.0
	8	0.0	0.0	0.0	0.0
	9	0.0	0.0	0.0	0.0
	10	0.0	0.0	0.0	0.0
	11	0.0	0.0	0.0
	12	0.0	0.0
	TOTAL	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	FORNECEDORES	VALOR	1	2	3	4	5	6	7	8	9	10	11	12
	1	0.0	0.0	0.0
	2	0.0	0.0	0.0
	3	0.0	0.0	0.0
	4	0.0	0.0	0.0
	5	0.0	0.0	0.0
	6	0.0	0.0	0.0
	7	0.0	0.0	0.0
	8	0.0	0.0	0.0
	9	0.0	0.0	0.0
	10	0.0	0.0	0.0
	11	0.0	0.0	0.0
	12	0.0	0.0
	TOTAL	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	SALDO INICIAL	1	2	3	4	5	6	7	8	9	10	11	12
	0.0
	ENTRADAS COM VENDAS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	CAPITAL INTEGRALIZADO	0.0
	SALDO EM CAIXA	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	FORNECEDORES - CPV	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	AGUA - LUZ - TELEFONE	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	PROLABORE	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	SALARIO + ENCARGOS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	TRANSPORTE	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	MARKETING	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	IRPJ	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	CSLL	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	COMISSAO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	ICMS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	PIS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	COFINS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	TOTAL DE SAIDAS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	FLUXO DE CAIXA LIVRE	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	SALDO FINAL ACUMULADO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	Administração Financeira e Orçamentária - Realizar o Orçamento de Vendas e o Orçamento de Produção conforme solicitado.
	ORCAMENTO DE VENDAS	ORCAMENTO DE PRODUCAO
	TRIMESTRE	1º Tri	2º Tri	3º Tri	4º Tri	TRIMESTRE	1º Tri	2º Tri	3º Tri	4º Tri
	PREVISAO DE VENDAS (UNIDADES)	PREVISAO DE VENDAS (UNIDADES)
	PRECO UNITARIO - R$	(+) ESTOQUE FINAL
	TOTAL DE VENDA - R$ (RECEITA BRUTA)	TOTAL PREVISAO NECESSARIA
	IMPOSTOS (27,25%)	(-) ESTOQUE INICIAL
	RECEITA LIQUIDA	PREVISAO DE PRODUCAO
	MERCADO DE CAPITAIS
	LPA	0.0
	PAYOUTt	ERROR:#DIV/0!
	DIVIDENDOS	0.0
	DIVIDENDOS POR AÇÃO	0.0
	DIVIDENDO YIELD	0.0
	P/L	ERROR:#DIV/0!
&P