projeção de fluxo de caixa

Prévia do material em texto

Planilha1
	EMPRESA	FLUXO DE CAIXA								MÊS/ANO:	Dec-18
	DIAS	1	7	8	12	13	19	20	26	27	30	NO MÊS	NO MÊS
	ITENS	Previsto	Realizado	Previsto	Realizado	Previsto	Realizado	Previsto	Realizado	Previsto	Realizado	Previsto	Realizado
	A - Existência (caixa + bancos)	12,980.00		7,780.00		11,480.00		11,835.00		3,205.00		12,980.00	0.00
	B - Entradas	7,800.00	0.00	9,000.00	0.00	7,250.00	0.00	4,400.00	0.00	3,500.00	0.00	31,950.00	0.00
	Vendas a Vista	900.00		1,500.00		2,500.00		500.00		400.00		5,800.00	0.00
	Cobranças Clientes	6,900.00		7,500.00		4,750.00		3,900.00		3,100.00		26,150.00	0.00
	Empréstimos											0.00	0.00
												0.00	0.00
												0.00	0.00
												0.00	0.00
	C - Disponível (A + B)	20,780.00	0.00	16,780.00	0.00	18,730.00	0.00	16,235.00	0.00	6,705.00	0.00	44,930.00	0.00
	D - Saídas	13,000.00	0.00	5,300.00	0.00	6,895.00	0.00	13,030.00	0.00	4,180.00	0.00	42,405.00	0.00
	Fornecedores	1,500.00		2,700.00		1,950.00		1,300.00		990.00		8,440.00	0.00
	Folha de Pagamento	6,000.00		0.00		0.00		1,000.00		0.00		7,000.00	0.00
	FGTS	650.00		0.00		0.00		0.00		0.00		650.00	0.00
	Adiantamentos Viagens	1,000.00		600.00		0.00		0.00		0.00		1,600.00	0.00
	Comissões	1,200.00		500.00		0.00		0.00		0.00		1,700.00	0.00
	Tributos			1,500.00		695.00		1,900.00		690.00		4,785.00	0.00
	Férias					4,250.00		4,980.00		2,500.00		11,730.00	0.00
	13º							3,850.00				3,850.00	0.00
	Empréstimos	2,650.00										2,650.00	0.00
												0.00	0.00
												0.00	0.00
												0.00	0.00
												0.00	0.00
												0.00	0.00
	E - Saldo (B - D)	-5,200.00	0.00	3,700.00	0.00	355.00	0.00	-8,630.00	0.00	-680.00	0.00	-10,455.00	0.00
	F - Saldo Final (C - D)	7,780.00	0.00	11,480.00	0.00	11,835.00	0.00	3,205.00	0.00	2,525.00	0.00	2,525.00	0.00