Trabalho finança de longo prazo

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

Plan1
	Disciplina : Finanças de Longo Prazo
	Nome : Dinora Ribeiro Prado 
	Questão 1
	ano 	Investimento 	receita	despesas da maquina 	Salário do funcionário	Fluxo de caixa 
	0	* 30,000.00	0.0	0.0	0.0	* 30,000.00
	1	0.0	* 25,000.00	* 5,000.00	* 5,000.00	* 15,000.00
	2	0.0	* 25,000.00	* 6,500.00	* 5,500.00	* 13,000.00
	3	0.0	* 25,000.00	* 8,000.00	* 6,050.00	* 10,950.00
	4	0.0	* 25,000.00	* 9,500.00	* 6,655.00	* 8,845.00
	5	0.0	* 35,000.00	* 11,000.00	* 7,320.50	* 16,679.50
	ano 	fluxo de Caixa 	VPL 
	0	* 30,000.00	0.0
	1	* 15,000.00	* 12,931.03
	2	* 13,000.00	* 9,661.12
	3	* 10,950.00	* 7,015.20
	4	* 8,845.00	* 4,885.01
	5	* 16,679.50	* 7,941.33
	* 42,433.70
	VPL 	* 42,433.70
	Investimento	* 30,000.00
	Lucro 	* 12,433.70
	Questão 2
	0	1	2	3	4	5
	entrada 	* 95,000.00	* 25,000.00	* 35,000.00	* 80,000.00	* 80,000.00	* 80,000.00
	saída 	* 15,000.00	* 20,000.00	* 40,000.00	* 40,000.00	* 40,000.00
	saldo 	* 10,000.00	* 15,000.00	* 40,000.00	* 40,000.00	* 40,000.00
	ano 	Investimento	VPL 
	0	* 95,000.00	0.0
	1	* 10,000.00	* 8,695.65
	2	* 15,000.00	* 11,342.16
	3	* 40,000.00	* 26,300.65
	4	* 40,000.00	* 22,870.13
	5	* 40,000.00	* 19,887.07
	* 89,095.66
	VPL 	* 89,095.66
	Investimento	* 95,000.00
	Lucro 	-5,904.34	Não pois terá um prejuízo de R$ 5.904,34
	Questão 3
	ano 	Investimento	VPL 
	0	* 750,000.00	0.0
	1	* 250,000.00	* 208,333.33
	2	* 320,000.00	* 222,222.22
	3	* 380,000.00	* 219,907.41
	4	* 280,000.00	* 135,030.86
	* 785,493.83
	VPL 	* 785,493.83
	Investimento	* 750,000.00
	Lucro 	* 35,493.83
	Questão 4
	ano 	Investimento	VPL 
	0	* 130,000.00	0.0
	1	* 45,000.00	* 40,909.09
	2	* 45,000.00	* 37,190.08
	3	* 45,000.00	* 33,809.17
	4	* 45,000.00	* 30,735.61
	* 142,643.95
	VPL 	* 142,643.95
	Investimento	* 130,000.00
	Lucro 	* 12,643.95
	Questão 5
	ano 	Investimento	VPL 
	0	* 47,000.00	0.0
	1	* 12,000.00	* 11,764.71
	2	* 15,000.00	* 14,417.53
	3	* 23,000.00	* 21,673.41
	* 47,855.65
	VPL 	* 47,855.65
	Investimento	* 47,000.00
	Lucro 	* 855.65	Sim pois terá um rendimento de R$ 855,65
	Questão 6
	ano 	MÁQUINA N	VPL 	ano 	Maquina V	VPL 
	0	* 100.00	0.0	0	* 90.00	0.0
	1	* 1,000.00	* 909.09	1	* 300.00	* 272.73
	2	* 200.00	* 165.29	2	* 1,400.00	* 1,157.02
	* 1,074.38	* 1,429.75
	VPL 	* 1,074.38	VPL 	* 1,429.75
	MAQ. N	* 100.00	MAQ, V	* 90.00
	Valor venda	* 974.38	valor de Venda	* 1,339.75
	Questão 7
	ano 	Empréstimo	VPL 
	0	* 30,000.00	0.0
	1	* 15,500.00	* 14,903.85
	2	* 15,500.00	* 14,330.62
	* 29,234.47
	Empréstimo	* 30,000.00
	VPL	* 29,234.47
	Desconto	* 765.53	Sim pois terá uma redução de R$ 765,53
	Questão 8
	ano 	Investimento 	receita	VPL	Fluxo de caixa 
	0	* 25,000.00	0.0	0.0	0.0
	6 mese 	0.0
	1	0.0	-25,000.00
	2	0.0	0.0	-25,000.00
	3	0.0	0.0	-25,000.00
	4	0.0	0.0	-25,000.00	-25,000.00
	5	0	-25,000.00	* 1,500.00
	6	0	-25,000.00	* 1,500.00
	7	* 1,500.00	* 1,178.99	-23,821.01	* 1,500.00
	8	* 1,500.00	* 1,139.12	-22,681.90	* 1,500.00
	9	* 1,500.00	* 1,100.60	-21,581.30	* 1,500.00
	10	* 1,500.00	* 1,063.38	-20,517.92	* 1,500.00
	11	* 1,500.00	* 1,027.42	-19,490.50	* 1,500.00
	12	* 1,500.00	* 992.67	-18,497.83	* 1,500.00
	13	* 1,500.00	* 959.11	-17,538.72	* 1,500.00
	14	* 1,500.00	* 926.67	-16,612.05	* 1,500.00
	15	* 1,500.00	* 895.34	-15,716.71	* 1,500.00
	16	* 1,500.00	* 865.06	-14,851.65	* 1,500.00
	17	* 1,500.00	* 835.81	-14,015.85	* 2,000.00
	18	* 1,500.00	* 807.54	-13,208.31	* 2,000.00
	19	* 2,000.00	* 1,040.31	-12,168.00	* 2,000.00
	20	* 2,000.00	* 1,005.13	-11,162.86	* 2,000.00
	21	* 2,000.00	* 971.14	-10,191.72	* 2,000.00
	22	* 2,000.00	* 938.30	-9,253.42	* 2,000.00
	23	* 2,000.00	* 906.57	-8,346.85	* 2,000.00
	24	* 2,000.00	* 875.91	-7,470.94	* 2,000.00
	25	* 2,000.00	* 846.29	-6,624.64	* 2,000.00
	26	* 2,000.00	* 817.68	-5,806.97	* 2,000.00
	27	* 2,000.00	* 790.02	-5,016.94	* 2,000.00
	28	* 2,000.00	* 763.31	-4,253.63	* 2,000.00
	29	* 2,000.00	* 737.50	-3,516.14	* 3,500.00
	30	* 2,000.00	* 712.56	-2,803.58	* 3,500.00
	31	* 3,500.00	* 1,204.81	-1,598.77	* 3,500.00
	32	* 3,500.00	* 1,164.06	-434.71	* 3,500.00
	33	* 3,500.00	* 1,124.70	* 689.99	* 3,500.00
	34	* 3,500.00	* 1,086.67	* 1,776.66	* 28,500.00
	35	* 3,500.00	* 1,049.92	* 2,826.58	7%
	36	* 28,500.00	* 8,260.23	* 11,086.81
	O projeto è viavel pois o valor o VPL é igual ou maior que zero 
	TIR é 5,13 	Deve-se aceitar a proposta da sociedade