1º passo Elabora a DRE e o fluxo de caixa (sexto semestre 2015 de Administração)

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

Plan1
	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	6.00	6.00	6.00	6.00	6.00	6.00	6.00	6.00	6.00	6.00	6.00	6.00	72.00
	Quantidade	20000	20000	20000	23200	23200	23200	30600	30600	30600	30600	30600	30600	313200
	Receita Bruta	120,000.00	120,000.00	120,000.00	139,200.00	139,200.00	139,200.00	183,600.00	183,600.00	183,600.00	183,600.00	183,600.00	183,600.00	1,879,200.00
	ICMS	21,600.00	21,600.00	21,600.00	25,056.00	25,056.00	25,056.00	33,048.00	33,048.00	33,048.00	33,048.00	33,048.00	33,048.00	338,256.00
	PIS	1,980.00	1,980.00	1,980.00	2,296.80	2,296.80	2,296.80	3,029.40	3,029.40	3,029.40	3,029.40	3,029.40	3,029.40	31,006.80
	COFINS	9,120.00	9,120.00	9,120.00	10,579.20	10,579.20	10,579.20	13,953.60	13,953.60	13,953.60	13,953.60	13,953.60	13,953.60	142,819.20
	Comissão	2,400.00	2,400.00	2,400.00	2,784.00	2,784.00	2,784.00	3,672.00	3,672.00	3,672.00	3,672.00	3,672.00	3,672.00	37,584.00
	Receita Líquida	84,900.00	84,900.00	84,900.00	98,484.00	98,484.00	98,484.00	129,897.00	129,897.00	129,897.00	129,897.00	129,897.00	129,897.00	1,329,534.00
	CPV	63,000.00	63,000.00	63,000.00	73,080.00	73,080.00	73,080.00	96,390.00	96,390.00	96,390.00	96,390.00	96,390.00	96,390.00	986,580.00
	Lucro Bruto	21,900.00	21,900.00	21,900.00	25,404.00	25,404.00	25,404.00	33,507.00	33,507.00	33,507.00	33,507.00	33,507.00	33,507.00	342,954.00
	água - luz - telefone	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	25,200.00
	prolabore	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	66,000.00
	salário + encargos	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	100,200.00
	transporte	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	21,600.00
	marketing	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	12,000.00
	depreciação	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	2,200.00	26,400.00
	Lucro Operacional	950.00	950.00	950.00	4,454.00	4,454.00	4,454.00	12,557.00	12,557.00	12,557.00	12,557.00	12,557.00	12,557.00	91,554.00
	IR	142.50	142.50	142.50	668.10	668.10	668.10	1,883.55	1,883.55	1,883.55	1,883.55	1,883.55	1,883.55	13,733.10
	CS	85.50	85.50	85.50	400.86	400.86	400.86	1,130.13	1,130.13	1,130.13	1,130.13	1,130.13	1,130.13	8,239.86
	Lucro Líquido	722.00	722.00	722.00	3,385.04	3,385.04	3,385.04	9,543.32	9,543.32	9,543.32	9,543.32	9,543.32	9,543.32	69,581.04
	Contas a Receber	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	120000	40000.00	40000.00	40000.00
	2	120000	40000.00	40000.00	40000.00
	3	120000	40000.00	40000.00	40000.00
	4	139200	46400.00	46400.00	46400.00
	5	139200	46400.00	46400.00	46400.00
	6	139200	46400.00	46400.00	46400.00
	7	183600	61200.00	61200.00	61200.00
	8	183600	61200.00	61200.00	61200.00
	9	183600	61200.00	61200.00	61200.00
	10	183600	61200.00	61200.00	61200.00
	11	183600	61200.00	61200.00
	12	183600	61200.00
	Total	40000.00	80000.00	120000.00	126400.00	132800.00	139200.00	154000.00	168800.00	183600.00	183600.00	183600.00	183600.00
	Fornecedores	Valor	1	2	3	4	5	6	7	8	9	10	11	12
	1	63000	31500	31500
	2	63000	31500	31500
	3	63000	31500	31500
	4	73080	36540	36540
	5	73080	36540	36540
	6	73080	36540	36540
	7	96390	48195	48195
	8	96390	48195	48195
	9	96390	48195	48195
	10	96390	48195	48195
	11	96390	48195	48195
	12	96390	48195
	Total	31500	63000	63000	68040	73080	73080	84735	96390	96390	96390	96390	96390
	1	2	3	4	5	6	7	8	9	10	11	12
	Saldo Inicial	0.0	* 205,700.00	* 168,622.00	* 171,544.00	* 175,826.00	* 175,011.04	* 180,596.08	* 189,596.08	* 186,269.44	* 198,012.76	* 209,756.08	* 221,499.40
	Entradas com vendas	* 40,000.00	* 80,000.00	* 120,000.00	* 126,400.00	* 132,800.00	* 139,200.00	* 154,000.00	* 168,800.00	* 183,600.00	* 183,600.00	* 183,600.00	* 183,600.00
	Capital Integralizado	* 200,000.00
	Saldo em Caixa	* 240,000.00	* 285,700.00	* 288,622.00	* 297,944.00	* 308,626.00	* 314,211.04	* 334,596.08	* 358,396.08	* 369,869.44	* 381,612.76	* 393,356.08	* 405,099.40
	Fornecedores - CPV	31,500.00	63,000.00	63,000.00	68,040.00	73,080.00	73,080.00	84,735.00	96,390.00	96,390.00	96,390.00	96,390.00	96,390.00
	água - luz - telefone	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00	2,100.00
	prolabore	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00	5,500.00
	salário + encargos	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00	8,350.00
	transporte	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00	1,800.00
	marketing	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00	1,000.00
	IRPJ	142.50	142.50	142.50	668.10	668.10	668.10	1,883.55	1,883.55	1,883.55	1,883.55	1,883.55
	CSLL	85.50	85.50	85.50	400.86	400.86	400.86	1,130.13	1,130.13	1,130.13	1,130.13	1,130.13
	Comissão	2,400.00	2,400.00	2,400.00	2,784.00	2,784.00	2,784.00	3,672.00	3,672.00	3,672.00	3,672.00	3,672.00
	ICMS	21,600.00	21,600.00	21,600.00	25,056.00	25,056.00	25,056.00	33,048.00	33,048.00	33,048.00	33,048.00	33,048.00
	PIS	1,980.00	1,980.00	1,980.00	2,296.80	2,296.80	2,296.80	3,029.40	3,029.40	3,029.40	3,029.40	3,029.40
	COFINS	9,120.00	9,120.00	9,120.00	10,579.20	10,579.20	10,579.20	13,953.60	13,953.60	13,953.60	13,953.60	13,953.60
	Total de Saídas	34,300.00	117,078.00	117,078.00	122,118.00	133,614.96	133,614.96	145,269.96	171,856.68	171,856.68	171,856.68	171,856.68	171,856.68
	Fluxo de Caixa Livre	5,700.00	-37,078.00	2,922.00	4,282.00	-814.96	5,585.04	8,730.04	-3,056.68	11,743.32	11,743.32	11,743.32	11,743.32
	Saldo Final Acumul.	205,700.00	168,622.00	171,544.00	175,826.00	175,011.04	180,596.08	189,326.12	186,539.40	198,012.76	209,756.08	221,499.40	233,242.72
Plan2
Plan3