Cálculo do VPL, TIR, IL e Paybac

Prévia do material em texto

Planilha1
	Taxa Mínima de Atratividade: 2% a.m. = 				0.0200	=	26.82	a.a.	=	0.2682	=	12.62	a.s. =	0.1262
		Payback Simples		Payback Descontado		Indice de Lucratividade		VPL		TIR
	P1	8 meses e 12 dias		9 meses e 6 dias		1.27		13,514.19		6% a.m.			VP=VF/(1+i)^n
	P2	4 anos, 5 meses e 4 dias		> cinco anos		0.58		- 31,514.97		7,07% a.a.
	P3	7 semestres		11 semestres, 5 meses e 14 dias		1.02		1,074.20		12,9% a.s.		IL = VP / I0		VPL = VP - I0
	Mensais	Projeto 01	1	2	3	4	5	6	7	8	9	10	11	12
		Investimento	FC1	FC2	FC3	FC4	FC5	FC6	FC7	FC8	FC9	FC10	FC11	FC12
		- 50,000.00	5,000	5,500	5,500	6,000	6,200	6,200	6,400	6,500	7,000	6,500	6,500	5,000
	VP	63,514	4,902	5,286	5,183	5,543	5,616	5,505	5,572	5,548	5,857	5,332	5,228	3,942
	Anuais	Projeto 02	1	2	3	4	5
		Investimento	FC1	FC2	FC3	FC4	FC5
		- 75,000.00	10,000	15,000	20,000	15,000	35,000
	VP	43,485	7,885	9,326	9,805	5,799	10,669
	Semestrais	Projeto 03	1	2	3	4	5	6	7	8	9	10	11	12
		Investimento	FC1	FC2	FC3	FC4	FC5	FC6	FC7	FC8	FC9	FC10	FC11	FC12
		- 67,000.00	8,000	8,000	9,000	9,000	10,000	11,000	12,000	13,000	12,000	10,000	9,000	50,000
	VP	68,074	7,104	6,308	6,301	5,595	5,520	5,391	5,222	5,024	4,118	3,047	2,435	12,011