VPL - TRI - PRI - FDC

Prévia do material em texto

Plan1
	Ano	0	1	2	3	4	5
	Lucro (em milhares de dólares)	0.00	1236.00	1545.00	1823.10	2023.60	2205.80
	Custos e despesas (em milhares de dólares)	-509.00	-998.00	-1207.60	-1364.60	-1432.80	-1447.10
	FC	-509.00	238.00	337.40	458.50	590.80	758.70
	Taxa de desconto	9%	9%	9%	9%	9%	9%
	FCD	509.00	915.60	1016.41	1053.72	1015.03	940.52	5450.28
		-509.00	1133.94	2408.29	3808.25	5060.41	6121.82
	FCL	-509.00	238.00	337.40	458.50	590.80	758.70
	Fluxo de Caixa Acumulado 	-509.00	-271.00	66.40	524.90	1115.70	1874.40
	FCD	-509.00	218.35	283.98	354.05	418.54	493.10	1259.02
	VPL	-509.00	-290.65	-6.67	347.38	765.92	1259.02
	PRI
Plan2
		Investimento Inicial 	$ 509,000.00
		Taxa de Desconto 	9%
		Período (Ano)	Faturamento	Custo	Fluxo de Caixa	Valor Presente	VP Acumulado 
		0	$ - 0	$ 509,000.00	$ -509,000.00	$ -509,000.00	$ -509,000.00
		1	$ 1,236,000.00	$ 998,000.00	$ 238,000.00	$ 218,348.62	$ -290,651.38
		2	$ 1,545,000.00	$ 1,207,600.00	$ 337,400.00	$ 283,982.83	$ -6,668.55
		3	$ 1,823,100.00	$ 1,364,600.00	$ 458,500.00	$ 354,046.13	$ 347,377.58
		4	$ 2,023,600.00	$ 1,432,800.00	$ 590,800.00	$ 418,537.61	$ 765,915.19
		5	$ 2,205,800.00	$ 1,447,100.00	$ 758,700.00	$ 493,102.94	$ 1,259,018.14
		Soma VPs (Ano 1 ao 5) 		$ 1,768,018.14
		VPL do Projeto 		$ 1,259,018.14
		Taxa Interna de Retorno (TIR) 		65%
		Taxa de Lucratividade 		3.47
		Tempo de Payback		2.02