FLUXO DE CAIXA

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

Plan1
	Fluxo de Caixa
	ANO 0	ANO 1	ANO 2	ANO 3	ANO 4	 ANO 5	ANO 6	ANO 7	ANO 8	ANO 9	ANO 10
	INV.	1250000
	CAPITAL DE GIRO	100000
	RECEITA BRUTA	2160000	2160000	2160000	2160000	2160000	2160000	2160000	2160000	2160000	2160000
	ICMS	0	367200	367200	367200	367200	367200	367200	367200	367200	367200	367200
	PIS-CONFINS	0	78840	78840	78840	78840	78840	78840	78840	78840	78840	78840
	CEFEM	0	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997	34279.199999999997
	ROYALITES	0	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999	17139.599999999999
	RECEITA LÍQUIDA	0	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2	1662541.2
	CUSTO OPERACIONAL	600000	600000	600000	600000	600000	600000	600000	600000	600000	600000
	LUCRO OPERACIONAL	0	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2
	DEPRECIAÇÃO	312500	312500	312500	312500	0	0	0	0	0	0
	LUCRO TRIBUTÁVEL	0	750041.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2	1062541.2
	IMPOSTO DE RENDA	163510.29999999999	241635.3	241635.3	241635.3	241635.3	241635.3	241635.3	241635.3	241635.3	241635.3
	CONTRIBUIÇÃO SOCIAL	67503.707999999999	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984	95628.707999999984
	LUCRO APÓS IR	519027.19199999998	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004
	FLUXO DE CAIXA	-1350000	831527.19200000004	831527.19200000004	831527.19200000004	831527.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004	725277.19200000004
	FLUXO DE CAIXA ACUMULADO	-1350000	-518472.80799999996	313054.38400000008	1144581.5760000001	1976108.7680000002	2701385.96	3426663.1519999998	4151940.3439999996	4877217.5359999994	5602494.7279999992	6427771.919999999
	CAPEX	1250000	VPL	VPL - FLUXO DE CAIXA ANO 0	TIR
	CUSTO OPERACIONAL	250	VPL (15%)	R$ 3,943,339.87	R$ 2,593,339.87	59.898928%
	CAPITAL DE GIRO	100000	VPL (60%)	R$ 1,347,863.95	-R$ 2,136.05	60%
	PRODUÇÃO 	2400
	RECUPERAÇÃO 25% DA LAVRA	25
	RESERVA	300000
	PRECO	900
	VIDA ÚTIL	31.25