Desafio Análise de Investimentos

Prévia do material em texto

DRE
	DRE
	Ano	0	1	2	3	4	5	6	7	8	TOTAL
	Quantidade		35,000	50,000	65,000	80,000	95,000	110,000	125,000	140,000		Capacidade máxima produtiva= 150.000
	(=) Receita		R$ 350,000.00	R$ 500,000.00	R$ 650,000.00	R$ 800,000.00	R$ 950,000.00	R$ 1,100,000.00	R$ 1,250,000.00	R$ 1,400,000.00	R$ 7,000,000.00
	(-) CPV		R$ 175,000.00	R$ 250,000.00	R$ 325,000.00	R$ 400,000.00	R$ 475,000.00	R$ 550,000.00	R$ 625,000.00	R$ 700,000.00	R$ 3,500,000.00
	(-) Custo Fixo		R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 120,000.00	R$ 960,000.00
	(=)Lucro Bruto		R$ 55,000.00	R$ 130,000.00	R$ 205,000.00	R$ 280,000.00	R$ 355,000.00	R$ 430,000.00	R$ 505,000.00	R$ 580,000.00	R$ 2,540,000.00
	(-) Depreciação		R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 250,000.00	R$ 2,000,000.00
	(-) Despesa ADM		R$ 43,750.00	R$ 62,500.00	R$ 81,250.00	R$ 100,000.00	R$ 118,750.00	R$ 137,500.00	R$ 156,250.00	R$ 175,000.00	R$ 875,000.00
	(=) Lucro Antes do IR		-R$ 238,750.00	-R$ 182,500.00	-R$ 126,250.00	-R$ 70,000.00	-R$ 13,750.00	R$ 42,500.00	R$ 98,750.00	R$ 155,000.00	-R$ 335,000.00
	IR		R$ - 0	R$ - 0	R$ - 0	R$ - 0	R$ - 0	R$ 14,450.00	R$ 33,575.00	R$ 52,700.00	R$ 100,725.00
	(=) Lucro/Prejuizo Líquido 		-R$ 238,750.00	-R$ 182,500.00	-R$ 126,250.00	-R$ 70,000.00	-R$ 13,750.00	R$ 28,050.00	R$ 65,175.00	R$ 102,300.00	-R$ 435,725.00
	Investimento	R$ 1,200,000.00	R$ 800,000.00
	Fluxo de Caixa 1 (DRE)		R$ 11,250.00	R$ 67,500.00	R$ 123,750.00	R$ 180,000.00	R$ 236,250.00	R$ 278,050.00	R$ 315,175.00	R$ 352,300.00	R$ 1,564,275.00
	Fluxo de Caixa do Projeto	-R$ 1,200,000.00	-R$ 788,750.00	R$ 67,500.00	R$ 123,750.00	R$ 180,000.00	R$ 236,250.00	R$ 278,050.00	R$ 315,175.00	R$ 352,300.00	-R$ 435,725.00
VPL-PB-TIR
	VPL - Valor Presente Liquido
	Taxa	Projetos	0	1	2	3	4	5
	11.75%	BOTA	-R$ 20,000.00	R$ 10,000.00	R$ 2,000.00	R$ 5,000.00	R$ 6,000.00	R$ 7,000.00
		VPL BOTA		R$ 8,948.55	R$ 1,601.53	R$ 3,582.84	R$ 3,847.34	R$ 4,016.62	R$ 21,996.88
		VPL	R$ 1,997
		Payback	3 ANOS E 6 MESES
		TIR	15.90%
		FOGO	-R$ 40,000.00	R$ 5,000.00	R$ 3,000.00	R$ 10,000.00	R$ 15,000.00	R$ 12,000.00
		VPL FOGO		R$ 4,474.27	R$ 2,402.29	R$ 7,165.68	R$ 9,618.36	R$ 6,885.63
		VPL	-R$ 9,453.76
		Payback	4 ANOS E 7 MESES
		TIR	3.37%
APS1 DRE
	PROJETO APS
	Ano		0	1	2	3	4	5	6	7	8	9	10
	Quantidade			46,000	82,000	118,000	154,000	190,000	226,000	262,000	298,000	334,000	370,000
		8.50
	DRE
	(=) Receita			R$ 690,000.00	R$ 1,230,000.00	R$ 1,770,000.00	R$ 2,310,000.00	R$ 2,850,000.00	R$ 3,390,000.00	R$ 3,930,000.00	R$ 4,470,000.00	R$ 5,010,000.00	R$ 5,550,000.00
	CPV			R$ 391,000.00	R$ 697,000.00	R$ 1,003,000.00	R$ 1,309,000.00	R$ 1,615,000.00	R$ 1,921,000.00	R$ 2,227,000.00	R$ 2,533,000.00	R$ 2,839,000.00	R$ 3,145,000.00
	(-) Custo Fixo			R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00	R$ 100,000.00
	(=)Lucro Bruto			R$ 199,000.00	R$ 433,000.00	R$ 667,000.00	R$ 901,000.00	R$ 1,135,000.00	R$ 1,369,000.00	R$ 1,603,000.00	R$ 1,837,000.00	R$ 2,071,000.00	R$ 2,305,000.00
	(-) Depreciação	600,000		R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00	R$ 60,000.00
	(-) Despesa ADM	4		R$ 184,000.00	R$ 328,000.00	R$ 472,000.00	R$ 616,000.00	R$ 760,000.00	R$ 904,000.00	R$ 1,048,000.00	R$ 1,192,000.00	R$ 1,336,000.00	R$ 1,480,000.00
	(=) Lucro Antes do IR			-R$ 45,000.00	R$ 45,000.00	R$ 135,000.00	R$ 225,000.00	R$ 315,000.00	R$ 405,000.00	R$ 495,000.00	R$ 585,000.00	R$ 675,000.00	R$ 765,000.00
	IR	34%			R$ 15,300.00	R$ 45,900.00	R$ 76,500.00	R$ 107,100.00	R$ 137,700.00	R$ 168,300.00	R$ 198,900.00	R$ 229,500.00	R$ 260,100.00
	(=) Lucro/Prejuizo Líquido 			-R$ 45,000.00	R$ 29,700.00	R$ 89,100.00	R$ 148,500.00	R$ 207,900.00	R$ 267,300.00	R$ 326,700.00	R$ 386,100.00	R$ 445,500.00	R$ 504,900.00
	Investimento		R$ 480,000.00	R$ 120,000.00
	Fluxo de Caixa 1 (DRE)			-R$ 105,000.00	-R$ 30,300.00	R$ 29,100.00	R$ 88,500.00	R$ 147,900.00	R$ 207,300.00	R$ 266,700.00	R$ 326,100.00	R$ 385,500.00	R$ 444,900.00
	Fluxo de Caixa do Projeto		-R$ 480,000.00	-R$ 225,000.00	-R$ 30,300.00	R$ 29,100.00	R$ 88,500.00	R$ 147,900.00	R$ 207,300.00	R$ 266,700.00	R$ 326,100.00	R$ 385,500.00	R$ 444,900.00
APS FLUXO DE CAIXA
		0	1	2	3	4	5	6	7	8	9	10
	(=) Lucro/Prejuizo Líquido 		-R$ 45,000.00	R$ 29,700.00	R$ 89,100.00	R$ 148,500.00	R$ 207,900.00	R$ 267,300.00	R$ 326,700.00	R$ 386,100.00	R$ 445,500.00	R$ 504,900.00
	Investimento	R$ 480,000.00	R$ 120,000.00
	Fluxo de Caixa 1 (DRE)		-R$ 105,000.00	-R$ 30,300.00	R$ 29,100.00	R$ 88,500.00	R$ 147,900.00	R$ 207,300.00	R$ 266,700.00	R$ 326,100.00	R$ 385,500.00	R$ 444,900.00
	Fluxo de Caixa do Projeto	-R$ 480,000.00	-R$ 225,000.00	-R$ 30,300.00	R$ 29,100.00	R$ 88,500.00	R$ 147,900.00	R$ 207,300.00	R$ 266,700.00	R$ 326,100.00	R$ 385,500.00	R$ 444,900.00
APS VPL
	Valor Presente Líquido
	Taxa
	10%	Projeto APS	0	1	2	3	4	5	6	7	8	9	10
			-R$ 480,000.00	-R$ 225,000.00	-R$ 30,300.00	R$ 29,100.00	R$ 88,500.00	R$ 147,900.00	R$ 207,300.00	R$ 266,700.00	R$ 326,100.00	R$ 385,500.00	R$ 444,900.00
		VPL	-R$ 480,000.00	-R$ 204,545.45	-R$ 25,041.32	R$ 21,863.26	R$ 60,446.69	R$ 91,834.26	R$ 117,015.45	R$ 136,859.27	R$ 152,128.06	R$ 163,489.63	R$ 171,528.21
		VPL	-R$ 480,000.00
		TIR	14.05%