DRE 4º semestre

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

DRE e Fluxo
	DRE
	1	2	3	4	5	6	7	8	9	10	11	12	Total
	Preço de Venda	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	R$ 5.00	60
	Quantidade	35000	35000	35000	36400	36400	36400	42600	42600	42600	42600	42600	42600	469800
	Receita Bruta	175000	175000	175000	182000	182000	182000	213000	213000	213000	213000	213000	213000	2349000
	ICMS	31500	31500	31500	32760	32760	32760	38340	38340	38340	38340	38340	384480
	PIS	2887.5	2887.5	2887.5	3003	3003	3003	3514.5	3514.5	3514.5	3514.5	3514.5	35244
	COFINS	13300	13300	13300	13832	13832	13832	16188	16188	16188	16188	16188	162336
	Comissão	3500	3500	3500	3640	3640	3640	4260	4260	4260	4260	4260	42720
	Receita Líquida	175000	123812.5	123812.5	130812.5	128765	128765	159765	150697.5	150697.5	150697.5	150697.5	150697.5	1724220
	CPV	R$ 73,500.00	R$ 73,500.00	R$ 73,500.00	R$ 76,440.00	R$ 76,440.00	R$ 76,440.00	R$ 89,460.00	R$ 89,460.00	R$ 89,460.00	R$ 89,460.00	R$ 89,460.00	R$ 89,460.00	986580
	Lucro Bruto	101500	50312.5	50312.5	54372.5	52325	52325	70305	61237.5	61237.5	61237.5	61237.5	61237.5	737640
	água - luz - telefone	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	R$ 1,100.00	12100
	prolabore	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	R$ 2,700.00	29700
	salário + encargos	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	R$ 4,350.00	47850
	transporte	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	R$ 800.00	9600
	marketing	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	R$ 1,300.00	15600
	depreciação	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	R$ 600.00	7200
	Lucro Operacional	98800	39462.5	39462.5	43522.5	41475	41475	59455	50387.5	50387.5	50387.5	50387.5	50387.5	615590
	IR	R$ 26,250.00	R$ 18,571.88	R$ 18,571.88	R$ 19,621.88	R$ 19,314.75	R$ 19,314.75	R$ 23,964.75	R$ 22,604.63	R$ 22,604.63	R$ 22,604.63	R$ 22,604.63	236028.375
	CS	R$ 15,750.00	R$ 11,143.13	R$ 11,143.13	R$ 11,773.13	R$ 11,588.85	R$ 11,588.85	R$ 14,378.85	R$ 13,562.78	R$ 13,562.78	R$ 13,562.78	R$ 13,562.78	141617.025
	Lucro Líquido	98800	-2537.5	9747.5	13807.5	10080	10571.4	28551.4	12043.9	14220.1	14220.1	14220.1	14220.1	237944.6
	Contas a Receber	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	R$ 175,000.00	R$ 58,333.33	R$ 58,333.33	R$ 58,333.33
	2	R$ 175,000.00	R$ 58,333.33	R$ 58,333.33	R$ 58,333.33
	3	R$ 175,000.00	58333.33	58333.33	58333.33
	4	R$ 182,000.00	60666.67	60666.67	60666.67
	5	R$ 182,000.00	60666.67	60666.67	60666.67
	6	R$ 182,000.00	60666.67	60666.67	60666.67
	7	R$ 213,000.00	71000.00	71000.00	71000.00
	8	R$ 213,000.00	71000.00	71000.00	71000.00
	9	R$ 213,000.00	71000.00	71000.00	71000.00
	10	R$ 213,000.00	71000.00	71000.00	71000.00
	11	R$ 213,000.00	71000.00	71000.00
	12	R$ 213,000.00	71000.00
	Total	58333.33	116666.67	175000.00	177333.33	179666.67	182000.00	192333.33	202666.67	213000.00	213000.00	213000.00	213000.00
	Fornecedores	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	73500	R$ 36,750.00	R$ 36,750.00
	2	73500	R$ 36,750.00	R$ 36,750.00
	3	73500	R$ 36,750.00	R$ 36,750.00
	4	76440	R$ 38,220.00	R$ 38,220.00
	5	76440	R$ 38,220.00	R$ 38,220.00
	6	76440	R$ 38,220.00	R$ 38,220.00
	7	89460	R$ 44,730.00	R$ 44,730.00
	8	89460	R$ 44,730.00	R$ 44,730.00
	9	89460	R$ 44,730.00	R$ 44,730.00
	10	89460	R$ 44,730.00	R$ 44,730.00
	11	89460	R$ 44,730.00	R$ 44,730.00
	12	89460	R$ 44,730.00
	Total	36750	73500	73500	74970	76440	76440	82950	89460	89460	89460	89460	89460
	FLUXO DE CAIXA
	1	2	3	4	5	6	7	8	9	10	11	12
	Saldo Inicial	0.00	269483.33	209212.50	219560.00	230770.83	239117.50	250288.90	265283.63	267594.20	282414.30	297234.40	312054.50
	Entradas com vendas	R$ 58,333.33	R$ 116,666.67	R$ 175,000.00	R$ 177,333.33	R$ 179,666.67	R$ 182,000.00	R$ 192,333.33	R$ 202,666.67	R$ 213,000.00	R$ 213,000.00	R$ 213,000.00	R$ 213,000.00
	Capital Integralizado	250000.00
	Saldo em Caixa	308333.33	386150.00	384212.50	396893.33	410437.50	421117.50	442622.23	467950.30	480594.20	495414.30	510234.40	525054.50
	Fornecedores - CMV	36750.00	73500.00	73500.00	74970.00	76440.00	76440.00	82950.00	89460.00	89460.00	89460.00	89460.00	89460.00
	água - luz - telefone	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00	1100.00
	prolabore	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00	2700.00
	salário + encargos	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00	4350.00
	transporte	800.00	800.00	800.00	800.00	800.00	800.00	800.00	800.00	800.00	800.00	800.00	800.00
	marketing	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00	1300.00
	IR	26250.00	18571.88	18571.88	19621.88	19314.75	19314.75	23964.75	22604.63	22604.63	22604.63	22604.63
	CS	15750.00	11143.13	11143.13	11773.13	11588.85	11588.85	14378.85	13562.78	13562.78	13562.78	13562.78
	Comissão	3500.00	3500.00	3500.00	3640.00	3640.00	3640.00	4260.00	4260.00	4260.00	4260.00	4260.00
	ICMS	0.00	31500.00	31500.00	31500.00	32760.00	32760.00	32760.00	38340.00	38340.00	38340.00	38340.00	38340.00
	PIS	0.00	2887.50	2887.50	2887.50	3003.00	3003.00	3003.00	3514.50	3514.50	3514.50	3514.50	3514.50
	COFINS	0.00	13300.00	13300.00	13300.00	13832.00	13832.00	13832.00	16188.00	16188.00	16188.00	16188.00	16188.00
	Total de Saídas	38850.00	176937.50	164652.50	166122.50	171320.00	170828.60	177338.60	200356.10	198179.90	198179.90	198179.90	198179.90
	Fluxo de Caixa Livre	19483.33	-60270.83	10347.50	11210.83	8346.67	11171.40	14994.73	2310.57	14820.10	14820.10	14820.10	14820.10
	Saldo Final Acumul.	269483.33	209212.50	219560.00	230770.83	239117.50	250288.90	265283.63	267594.20	282414.30	297234.40	312054.50	326874.60
	Orçamento de Vendas
	1º Trimestre	2º Trimestre	3º Trimestre	4º Trimestre
	Previsão de Vendas (unidades)	105,000	109,200	127,800	127,800
	Preço unitário – R$	5.00	5.00	5.00	5.00
	= Total de vendas – R$ (Receita Bruta)	525,000	546,000	639,000	639,000
	Tributos	167,090	238,891	271,095	282,630
	Receita Líquida	357,910	307,109	367,905	356,370
	Orçamento de Produção
	1º Trimestre	2º Trimestre	3º Trimestre	4º Trimestre
	Previsão de Vendas (unidades)	105,000	109,200	127,800	127,800
	(+) Estoque Final	10,920	12,780	12,780	12,780
	Total Prev. Necessária	115,920	121,980	140,580	140,580
	(-) Estoque Inicial	10,500	10,920	12,780	12,780
	Previsão de Produção	105,420	111,060	127,800	127,800