ANALISE DE VIABILIDADE

Prévia do material em texto

Planilha1
							FORMULA CALCULO
		Ano	FLUXO DE CAIXA	TAXA MIN ATRATIV		1	R$ 892.86
		0	-R$ 2,600.00	12%		2	R$ 996.49
		1	R$ 1,000.00			3	R$ 533.84
		2	R$ 1,250.00			VP:	R$ 2,423.18
		3	R$ 750.00
		VPL:	-R$ 176.82			VPL NEGATIVO = INVIAVEL
		Ano	FLUXO DE CAIXA	TAXA MIN ATRATIV		1	R$ 9,000.00
		0	-R$ 58,000.00	24%		2	R$ 12,000.00
		1	R$ 9,000.00			3	R$ 72,000.00
		2	R$ 12,000.00			VP:	R$ 93,000.00
		3	R$ 60,000.00
		VPL:	R$ 35,000.00		VPL NEGATIVO = INVIAVEL
				PAYBACK SIMPLES
	tempo de retorno do projeto
			ANO	CAPITAIS (RS)	SALDO A SER PAGO		ANO	CAPITAIS (RS)	SALDO A SER PAGO
			0	-R$ 30,000.00	-R$ 30,000.00		0	-R$ 400,000.00	-R$ 400,000.00
			1	R$ 9,000.00	-R$ 21,000.00		1	R$ 80,000.00	R$ 320,000.00
			2	R$ 5,000.00	-R$ 16,000.00		2	R$ 90,000.00	R$ 230,000.00
			3	R$ 6,000.00	-R$ 10,000.00		3	R$ 120,000.00
			4	R$ 8,000.00	-R$ 2,000.00		4	R$ 130,000.00
			5	R$ 8,000.00	R$ 6,000.00		5	R$ 100,000.00
							6	R$ 70,000.00
								R$ 0.00
			-R$ 2,000.00					R$ 130,000.00
			R$ 8,000.00
								0%
			-25%
TOTAL PLAN
		Investimento Inicial	R$ 250,000.00
		Taxa de Desconto	12%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 250,000.00	-R$ 250,000.00	-R$ 250,000.00
		1	R$ 60,000.00	R$ 53,571.43	-R$ 196,428.57
		2	R$ 90,000.00	R$ 71,747.45	-R$ 124,681.12
		3	R$ 100,000.00	R$ 71,178.02	-R$ 53,503.10
		4	R$ 110,000.00	R$ 69,906.99	R$ 16,403.89
		5	R$ 120,000.00	R$ 68,091.22	R$ 84,495.11
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 334,495.11
		VPL do Projetos	R$ 84,495.11	FORMULA VPL
		Taxa interna de Retorno (TIR)	23.45%	FORMULA TIR
		Taxa de Lucratividade	1.34
		Tempo do Payback	3.77	FORMULA
NO GOOD
		Investimento Inicial	R$ 58,000.00
		Taxa de Desconto	24%
							R$ 13,920.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 58,000.00	-R$ 58,000.00	-R$ 58,000.00
		1	R$ 12,000.00	R$ 9,677.42	-R$ 48,322.58
		2	R$ 12,000.00	R$ 7,804.37	-R$ 40,518.21
		3	R$ 60,000.00	R$ 31,469.24	-R$ 9,048.97		R$ 9,140.93
		4
		5
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 48,951.03
		VPL do Projetos	-R$ 9,048.97	FORMULA VPL
		Taxa interna de Retorno (TIR)	15.76%	FORMULA TIR
		Taxa de Lucratividade	0.84
		Tempo do Payback	Projeto Inviável	FORMULA
GOOD
		Investimento Inicial	R$ 150,000.00
		Taxa de Desconto	10%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 150,000.00	-R$ 150,000.00	-R$ 150,000.00
		1	R$ 25,000.00	R$ 22,727.27	-R$ 127,272.73
		2	R$ 25,000.00	R$ 20,661.16	-R$ 106,611.57
		3	R$ 25,000.00	R$ 18,782.87	-R$ 87,828.70
		4	R$ 25,000.00	R$ 17,075.34	-R$ 70,753.36
		5	R$ 25,000.00	R$ 15,523.03	-R$ 55,230.33
		6	R$ 25,000.00	R$ 14,111.85	-R$ 41,118.48
		7	R$ 25,000.00	R$ 12,828.95	-R$ 28,289.53
		8	R$ 25,000.00	R$ 11,662.68	-R$ 16,626.85
		9	R$ 25,000.00	R$ 10,602.44	-R$ 6,024.40
		10	R$ 45,000.00	R$ 17,349.45	R$ 11,325.04
		Soma Vps (Ano 1 a 5)	R$ 161,325.04
		VPL do Projetos	R$ 11,325.04	FORMULA VPL
		Taxa interna de Retorno (TIR)	11.64%	FORMULA TIR
		Taxa de Lucratividade	1.08
		Tempo do Payback	9.35	FORMULA
GOOD (1)
		Investimento Inicial	R$ 150,000.00
		Taxa de Desconto	0%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 150,000.00	-R$ 150,000.00	-R$ 150,000.00
		1	R$ 20,000.00	R$ 20,000.00	-R$ 130,000.00
		2	R$ 20,000.00	R$ 20,000.00	-R$ 110,000.00
		3	R$ 20,000.00	R$ 20,000.00	-R$ 90,000.00
		4	R$ 20,000.00	R$ 20,000.00	-R$ 70,000.00
		5	R$ 20,000.00	R$ 20,000.00	-R$ 50,000.00
		6	R$ 30,000.00	R$ 30,000.00	-R$ 20,000.00
		7	R$ 30,000.00	R$ 30,000.00	R$ 10,000.00
		8	R$ 30,000.00	R$ 30,000.00	R$ 40,000.00
		9	R$ 30,000.00	R$ 30,000.00	R$ 70,000.00
		10	R$ 30,000.00	R$ 30,000.00	R$ 100,000.00
		Soma Vps (Ano 1 a 5)	R$ 250,000.00
		VPL do Projetos	R$ 100,000.00	FORMULA VPL
		Taxa interna de Retorno (TIR)	9.50%	FORMULA TIR
		Taxa de Lucratividade	1.67
		Tempo do Payback	6.67	FORMULA
GOOD (2)
		Investimento Inicial	R$ 30,000,000.00
		Taxa de Desconto	12%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 30,000,000.00	-R$ 30,000,000.00	-R$ 30,000,000.00
		1	R$ 5,500,000.00	R$ 4,910,714.29	-R$ 25,089,285.71
		2	R$ 5,500,000.00	R$ 4,384,566.33	-R$ 20,704,719.39
		3	R$ 5,500,000.00	R$ 3,914,791.36	-R$ 16,789,928.02
		4	R$ 5,500,000.00	R$ 3,495,349.43	-R$ 13,294,578.59
		5	R$ 5,500,000.00	R$ 3,120,847.71	-R$ 10,173,730.89
		6	R$ 5,500,000.00	R$ 2,786,471.17	-R$ 7,387,259.72
		7	R$ 5,500,000.00	R$ 2,487,920.68	-R$ 4,899,339.04
		8	R$ 5,500,000.00	R$ 2,221,357.75	-R$ 2,677,981.28
		9	R$ 5,500,000.00	R$ 1,983,355.14	-R$ 694,626.14
		10	R$ 6,400,000.00	R$ 2,060,628.71	R$ 1,366,002.57
		Soma Vps (Ano 1 a 5)	R$ 31,366,002.57
		VPL do Projetos	R$ 1,366,002.57	FORMULA VPL
		Taxa interna de Retorno (TIR)	13.09%	FORMULA TIR
		Taxa de Lucratividade	1.05
		Tempo do Payback	9.34	FORMULA
GOOD (3)
		Investimento Inicial	R$ 800.00
		Taxa de Desconto	15%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 800.00	-R$ 800.00	-R$ 800.00
		1	R$ 350.00	R$ 304.35	-R$ 495.65
		2	R$ 350.00	R$ 264.65	-R$ 231.00
		3	R$ 350.00	R$ 230.13	-R$ 0.87
		4	R$ 350.00	R$ 200.11	R$ 199.24
		5	R$ 450.00	R$ 223.73	R$ 422.97
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 1,222.97
		VPL do Projetos	R$ 422.97	FORMULA VPL
		Taxa interna de Retorno (TIR)	34.95%	FORMULA TIR
		Taxa de Lucratividade	1.53
		Tempo do Payback	3.00	FORMULA
								397
								423
GOOD (4)
		Investimento Inicial	R$ 2,000,000.00
		Taxa de Desconto	3%				R$ 60,000.00
							R$ 2,000,000.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 2,000,000.00	-R$ 2,000,000.00	-R$ 2,000,000.00
		1	R$ 1,600,000.00	R$ 1,553,398.06	-R$ 446,601.94
		2	R$ 1,000,000.00	R$ 942,595.91	R$ 495,993.97
		3
		4
		5
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 2,495,993.97
		VPL do Projetos	R$ 495,993.97	FORMULA VPL
		Taxa interna de Retorno (TIR)	21.24%	FORMULA TIR
		Taxa de Lucratividade	1.25
		Tempo do Payback	1.47	FORMULA
								397
								423
GOOD (5)
		Investimento Inicial	R$ 2,600.00
		Taxa de Desconto	12%				R$ 312.00
							R$ 2,000,000.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 2,600.00	-R$ 2,600.00	-R$ 2,600.00
		1	R$ 1,000.00	R$ 892.86	-R$ 1,707.14
		2	R$ 1,250.00	R$ 996.49	-R$ 710.65
		3	R$ 750.00	R$ 533.84	-R$ 176.82
		4
		5
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 2,423.18
		VPL do Projetos	-R$ 176.82	FORMULA VPL
		Taxa interna de Retorno (TIR)	7.84%	FORMULA TIR
		Taxa de Lucratividade	0.93
		Tempo do Payback	Projeto Inviável	FORMULA
GOOD (6)
		Investimento Inicial	R$ 30,000.00
		Taxa de Desconto	0%				R$ 0.00
							R$ 2,000,000.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 30,000.00	-R$ 30,000.00	-R$ 30,000.00
		1	R$ 9,000.00	R$ 9,000.00	-R$ 21,000.00
		2	R$ 5,000.00	R$ 5,000.00	-R$ 16,000.00
		3	R$ 6,000.00	R$ 6,000.00	-R$ 10,000.00
		4	R$ 8,000.00	R$ 8,000.00	-R$ 2,000.00
		5	R$ 8,000.00	R$ 8,000.00	R$ 6,000.00
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 36,000.00
		VPL do Projetos	R$ 6,000.00	FORMULA VPL
		Taxa interna de Retorno (TIR)	6.36%	FORMULA TIR
		Taxa de Lucratividade	1.20
		Tempo do Payback	4.25	FORMULA
		4 anos e 3 meses o payback SIMPLES
GOOD (7)
		Investimento Inicial	R$ 90,000.00
		Taxa de Desconto	15%				R$ 13,500.00
							R$ 2,000,000.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 90,000.00	-R$ 90,000.00	-R$ 90,000.00
		1	R$ 35,000.00	R$ 30,434.78	-R$ 59,565.22
		2	R$ 35,000.00	R$ 26,465.03	-R$ 33,100.19
		3	R$ 35,000.00	R$ 23,013.07	-R$ 10,087.12
		4	R$ 35,000.00	R$ 20,011.36	R$ 9,924.24
		5	R$ 35,000.00	R$ 17,401.19	R$ 27,325.43
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 117,325.43
		VPL do Projetos	R$ 27,325.43	FORMULA VPL
		Taxa interna de Retorno (TIR)	27.22%	FORMULA TIR
		Taxa de Lucratividade	1.30
		Tempo do Payback	3.50	FORMULA
		3 anos e 6 meses o payback DESCONTADOS
GOOD (8)
		Investimento Inicial	R$ 30,000.00
		Taxa de Desconto	10%				R$ 3,000.00
							R$ 2,000,000.00
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 30,000.00	-R$ 30,000.00	-R$ 30,000.00
		1	R$ 5,000.00	R$ 4,545.45	-R$ 25,454.552	R$ 8,000.00	R$ 6,611.57	-R$ 18,842.98
		3	R$ 8,000.00	R$ 6,010.52	-R$ 12,832.46
		4	R$ 10,000.00	R$ 6,830.13	-R$ 6,002.32
		5	R$ 7,000.00	R$ 4,346.45	-R$ 1,655.87
		6	R$ 6,000.00	R$ 3,386.84	R$ 1,730.97
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 31,730.97
		VPL do Projetos	R$ 1,730.97	FORMULA VPL
		Taxa interna de Retorno (TIR)	11.89%	FORMULA TIR
		Taxa de Lucratividade	1.06
		Tempo do Payback	5.49	FORMULA
		5 anos e 6 meses o payback DESCONTADOS
GOOD (9)
		Investimento Inicial	R$ 50,000.00
		Taxa de Desconto	8%
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 50,000.00	-R$ 50,000.00	-R$ 50,000.00
		1	R$ 4,000.00	R$ 3,703.70	-R$ 46,296.30
		2	R$ 9,000.00	R$ 7,716.05	-R$ 38,580.25
		3	R$ 12,000.00	R$ 9,525.99	-R$ 29,054.26
		4	R$ 15,000.00	R$ 11,025.45	-R$ 18,028.81
		5	R$ 20,000.00	R$ 13,611.66	-R$ 4,417.15
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 45,582.85
		VPL do Projetos	-R$ 4,417.15	FORMULA VPL
		Taxa interna de Retorno (TIR)	5.21%	FORMULA TIR
		Taxa de Lucratividade	0.91
		Tempo do Payback	Projeto Inviável	FORMULA
		>>>>>>>>>>>>TIR<<<<<<<<<<
GOOD (10)
		Investimento Inicial	R$ 1,500.00
		Taxa de Desconto	6%	TMA
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 1,500.00	-R$ 1,500.00	-R$ 1,500.00
		1	R$ 180.00	R$ 169.81	-R$ 1,330.19
		2	R$ 380.00	R$ 338.20	-R$ 991.99
		3	R$ 500.00	R$ 419.81	-R$ 572.18
		4	R$ 710.00	R$ 562.39	-R$ 9.79
		5
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 1,490.21
		VPL do Projetos	-R$ 9.79	FORMULA VPL
		Taxa interna de Retorno (TIR)	5.76%	FORMULA TIR
		Taxa de Lucratividade	0.99
		Tempo do Payback	Projeto Inviável	FORMULA
		>>>>>>>>>>>>TIR<<<<<<<<<<
GOOD (11)
		Investimento Inicial	R$ 40,000.00
		Taxa de Desconto	6%	TMA
		Período (ano)	Fluxo de Caixa	Valor Presente	VP acumulado
		0	-R$ 40,000.00	-R$ 40,000.00	-R$ 40,000.00
		1	R$ 6,000.00	R$ 5,660.38	-R$ 34,339.62
		2	R$ 6,000.00	R$ 5,339.98	-R$ 28,999.64
		3	R$ 7,000.00	R$ 5,877.33	-R$ 23,122.31
		4	R$ 18,000.00	R$ 14,257.69	-R$ 8,864.62
		5	R$ 19,000.00	R$ 14,197.91	R$ 5,333.28
		6
		7
		8
		9
		10
		Soma Vps (Ano 1 a 5)	R$ 45,333.28
		VPL do Projetos	R$ 5,333.28	FORMULA VPL
		Taxa interna de Retorno (TIR)	9.81%	FORMULA TIR
		Taxa de Lucratividade	1.13
		Tempo do Payback	4.62	FORMULA
		>>>>>>>>>>>>TIR<<<<<<<<<<