Atividade Flavia Passaglia

Prévia do material em texto

ATV 2 Depreciação
	DRE	0	1	2	3	4	5	6	7	8	9	10
	Receitas		110,000.00	110,000.00	110,000.00	110,000.00	110,000.00	110,000.00	110,000.00	110,000.00	110,000.00	110,000.00
	(-) Custo Total		32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00
	GASTOS E DESPESAS
	Manutenção e energia		32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00	32,000.00	43,500.00
	(=) Lucro Operacional Bruto		78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00
	(-) Juros														TMA 	10%
	(-) Depreciação		88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	(+) 6 ANOS FORA DO INVESTIMENTO
	(=) L.A.I.R		- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00				Payback	VP	Saldo do Invst
	(-) I.R.		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0			0	- 1,900,000.00	- 1,900,000.00	- 1,900,000.00
	(=) Lucro Líquido		- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00			1	78,000.00	R$70,909.09	-R$1,829,090.91
															2	66,500.00	R$54,958.68	-R$1,774,132.23
	Fluxo de Caixa Livre	0	1	2	3	4	5	6	7	8	9	10			3	78,000.00	R$58,602.55	-R$1,715,529.68
	Entradas de Caixa	- 0	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	366,500.00			4	66,500.00	R$45,420.39	-R$1,670,109.28
	Lucro Líquido		- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00	- 10,000.00	- 21,500.00			5	78,000.00	R$48,431.86	-R$1,621,677.42
	(+) Depreciação		88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00	88,000.00			6	66,500.00	R$37,537.52	-R$1,584,139.90
	(+) Valor Residual											300,000.00			7	78,000.00	R$40,026.33	-R$1,544,113.57
	(+) IGC - retorno														8	66,500.00	R$31,022.74	-R$1,513,090.83
	(+) Empréstimos														9	78,000.00	R$33,079.61	-R$1,480,011.21
	Saídas de Caixa	1,900,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0			10	366,500.00	R$141,301.62	-R$1,338,709.60	VPL
	(-) Investimento	1,900,000.00
	(-) Amortização																Investimento não se pagou
	(-) Variação do ICG
	Fluxo de Caixa Livre	- 1,900,000.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	66,500.00	78,000.00	366,500.00
	Projeção de depreciação	Valor do bem	Valor residual	Depreciação Anual
	Valor do bem 1	1,500,000.00	300,000.00	48,000.00
	Valor do bem 2	400,000.00	- 0	40,000.00
	Total	1,900,000.00	300,000.00	88,000.00
Atv 1 VF
	FUNÇÃO	DADOS
	TAXA	1.50%
	NPER	5
	PGTO	4,800,000.00	PRESTAÇÃO
	VP			-R$24,730,881.24	VF (Valor futuro)
	TIPO	0	POSTECIPADO
Atv 2 VF
	FUNÇÃO	DADOS
	TAXA	1.80%
	NPER	10
	PGTO	1,600,000.00	PRESTAÇÃO	Valor futuro
	VP			-R$17,360,210.52
	TIPO	0	POSTECIPADO
Atv 1 Financiamento
				12%
	Período	Prestação	Amortização	Juros	Saldo Devedor
	0				100,000.00
	1	R$13,387.88	R$1,387.88	12,000.00	98,612.12
	2	R$13,387.88	R$1,554.42	11,833.45	97,057.70
	3	R$13,387.88	R$1,740.95	11,646.92	95,316.74
	4	R$13,387.88	R$1,949.87	11,438.01	93,366.88
	5	R$13,387.88	R$2,183.85	11,204.03	91,183.02
	6	R$13,387.88	R$2,445.92	10,941.96	88,737.11
	7	R$13,387.88	R$2,739.43	10,648.45	85,997.68
	8	R$13,387.88	R$3,068.16	10,319.72	82,929.53
	9	R$13,387.88	R$3,436.33	9,951.54	79,493.19
	10	R$13,387.88	R$3,848.70	9,539.18	75,644.50
	11	R$13,387.88	R$4,310.54	9,077.34	71,333.96
	12	R$13,387.88	R$4,827.80	8,560.07	66,506.16
	13	R$13,387.88	R$5,407.14	7,980.74	61,099.02
	14	R$13,387.88	R$6,056.00	7,331.88	55,043.02
	15	R$13,387.88	R$6,782.72	6,605.16	48,260.30
	16	R$13,387.88	R$7,596.64	5,791.24	40,663.66
	17	R$13,387.88	R$8,508.24	4,879.64	32,155.42
	18	R$13,387.88	R$9,529.23	3,858.65	22,626.20
	19	R$13,387.88	R$10,672.73	2,715.14	11,953.46
	20	R$13,387.88	R$11,953.46	1,434.42	0.00
	Total da Dívida	R$267,757.56	R$100,000.00	167,757.56
Atv 2 Financiamento
				2%
	Período	Prestação	Amortização	Juros	Saldo Devedor
	0				120,000.00
	1	R$6,344.53	R$3,944.53	2,400.00	116,055.47
	2	R$6,344.53	R$4,023.42	2,321.11	112,032.05
	3	R$6,344.53	R$4,103.89	2,240.64	107,928.16
	4	R$6,344.53	R$4,185.97	2,158.56	103,742.19
	5	R$6,344.53	R$4,269.69	2,074.84	99,472.50
	6	R$6,344.53	R$4,355.08	1,989.45	95,117.42
	7	R$6,344.53	R$4,442.18	1,902.35	90,675.23
	8	R$6,344.53	R$4,531.03	1,813.50	86,144.21
	9	R$6,344.53	R$4,621.65	1,722.88	81,522.56
	10	R$6,344.53	R$4,714.08	1,630.45	76,808.48
	11	R$6,344.53	R$4,808.36	1,536.17	72,000.12
	12	R$6,344.53	R$4,904.53	1,440.00	67,095.59
	13	R$6,344.53	R$5,002.62	1,341.91	62,092.97
	14	R$6,344.53	R$5,102.67	1,241.86	56,990.30
	15	R$6,344.53	R$5,204.73	1,139.81	51,785.57
	16	R$6,344.53	R$5,308.82	1,035.71	46,476.75
	17	R$6,344.53	R$5,415.00	929.53	41,061.75
	18	R$6,344.53	R$5,523.30	821.24	35,538.46
	19	R$6,344.53	R$5,633.76	710.77	29,904.69
	20	R$6,344.53	R$5,746.44	598.09	24,158.26
	21	R$6,344.53	R$5,861.37	483.17	18,296.89
	22	R$6,344.53	R$5,978.59	365.94	12,318.29
	23	R$6,344.53	R$6,098.17	246.37	6,220.13
	24	R$6,344.53	R$6,220.13	124.40	0.00
	Total da Dívida	R$152,268.76	R$120,000.00	32,268.76
Financiamento 120.000,00
Período	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	Prestação	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	6344.5316703899871	Amortização	3944.5316703899871	4023.4223037977868	4103.8907498737426	4185.9685648712175	4269.6879361686424	4355.0816948920146	4442.1833287898553	4531.0269953656516	4621.6475352729649	4714.0804859784239	4808.362095697993	4904.5293376119525	5002.6199243641913	5102.6723228514747	5204.7257693085048	5308.8202846946751	5414.9966903885688	5523.2966241963395	5633.7625566802662	5746.4378078138716	5861.3665639701494	5978.5938952495526	6098.1657731545429	6220.1290886176339	Juros	2400	2321.1093665922003	2240.6409205162445	2158.5631055187696	2074.8437342213451	1989.4499754979724	1902.3483416001322	1813.5046750243353	1722.8841351170222	1630.451184411563	1536.1695746919943	1440.0023327780345	1341.9117460257955	1241.8593475385119	1139.8059010814823	1035.7113856953122	929.53498000141872	821.23504619364746	710.76911370972073	598.09386257611538	483.16510641983791	365.93777514043489	246.36589723544384	124.40258177235299	
Atv 3 Financiamento
				2%
	Período	Prestação	Amortização	Juros	Saldo Devedor
	0				120,000.00
	Carência 1	- 0	- 0	2,400.00
	Carência 2	- 0	- 0	2,400.00
	Carência 3	- 0	- 0	2,400.00	120,000.00
	1	R$7,338.81	R$4,938.81	2,400.00	115,061.19
	2	R$7,338.81	R$5,037.58	2,301.22	110,023.61
	3	R$7,338.81	R$5,138.33	2,200.47	104,885.28
	4	R$7,338.81	R$5,241.10	2,097.71	99,644.18
	5	R$7,338.81	R$5,345.92	1,992.88	94,298.25
	6	R$7,338.81	R$5,452.84	1,885.97	88,845.41
	7	R$7,338.81	R$5,561.90	1,776.91	83,283.52
	8	R$7,338.81	R$5,673.14	1,665.67	77,610.38
	9	R$7,338.81	R$5,786.60	1,552.21	71,823.78
	10	R$7,338.81	R$5,902.33	1,436.48	65,921.45
	11	R$7,338.81	R$6,020.38	1,318.43	59,901.07
	12	R$7,338.81	R$6,140.78	1,198.02	53,760.29
	13	R$7,338.81	R$6,263.60	1,075.21	47,496.69
	14	R$7,338.81	R$6,388.87	949.93	41,107.82
	15	R$7,338.81	R$6,516.65	822.16	34,591.17
	16	R$7,338.81	R$6,646.98	691.82	27,944.18
	17	R$7,338.81	R$6,779.92	558.88	21,164.26
	18	R$7,338.81	R$6,915.52	423.29	14,248.74
	19	R$7,338.81	R$7,053.83	284.97	7,194.91
	20	R$7,338.81	R$7,194.91	143.90	- 0.00
	Total da Dívida	R$146,776.12	R$120,000.00	33,976.12
Atv 4 Financiamento
				14%
	Período	Prestação	Amortização	Juros	Saldo Devedor		DRE	0	1	2	3	4	5
	0				2,430,000.00		Receitas		1,200,000.00	1,200,000.00	1,200,000.00	1,200,000.00	1,200,000.00
	Carência 1- 0	- 0	340,200.00			(-) Custo Total		120,000.00	174,000.00	120,000.00	174,000.00	120,000.00
	Carência 2	- 0	- 0	340,200.00			GASTOS E DESPESAS
	Carência 3	- 0	- 0	340,200.00			Manutenção e energia		120,000.00	174,000.00	120,000.00	174,000.00	120,000.00
	Carência 4	- 0	- 0	340,200.00			(=) Lucro Operacional Bruto		1,080,000.00	1,026,000.00	1,080,000.00	1,026,000.00	1,080,000.00
	Carência 5	- 0	- 0	340,200.00	2,430,000.00		(-) Juros		340,200.00	340,200.00	340,200.00	340,200.00	340,200.00		TMA 	10%
	1	R$366,895.98	R$26,695.98	340,200.00	2,403,304.02		(-) Depreciação		110,000.00	110,000.00	110,000.00	110,000.00	110,000.00
	2	R$366,895.98	R$30,433.42	336,462.56	2,372,870.59		(=) L.A.I.R		629,800.00	575,800.00	629,800.00	575,800.00	629,800.00			Payback	VP	Saldo do Invst
	3	R$366,895.98	R$34,694.10	332,201.88	2,338,176.49		(-) I.R.		- 0	- 0	- 0	- 0	- 0		0	- 2,700,000.00	- 2,700,000.00	- 2,700,000.00
	4	R$366,895.98	R$39,551.27	327,344.71	2,298,625.22		(=) Lucro Líquido		629,800.00	575,800.00	629,800.00	575,800.00	629,800.00		1	739,800.00	R$672,545.45	-R$2,027,454.55
	5	R$366,895.98	R$45,088.45	321,807.53	2,253,536.77										2	685,800.00	R$566,776.86	-R$1,460,677.69
	6	R$366,895.98	R$51,400.84	315,495.15	2,202,135.93		Fluxo de Caixa Livre	0	1	2	3	4	5		3	739,800.00	R$555,822.69	-R$904,855.00
	7	R$366,895.98	R$58,596.95	308,299.03	2,143,538.98		Entradas de Caixa	- 0	739,800.00	685,800.00	739,800.00	685,800.00	1,739,800.00		4	685,800.00	R$468,410.63	-R$436,444.37
	8	R$366,895.98	R$66,800.53	300,095.46	2,076,738.45		Lucro Líquido		629,800.00	575,800.00	629,800.00	575,800.00	629,800.00		5	1,739,800.00	R$1,080,278.92	R$643,834.55	VPL
	9	R$366,895.98	R$76,152.60	290,743.38	2,000,585.85		(+) Depreciação		110,000.00	110,000.00	110,000.00	110,000.00	110,000.00
	10	R$366,895.98	R$86,813.97	280,082.02	1,913,771.88		(+) Valor Residual						1,000,000.00				Payback	-R$0.4040108
	11	R$366,895.98	R$98,967.92	267,928.06	1,814,803.96		(+) IGC - retorno										Ano	4
	12	R$366,895.98	R$112,823.43	254,072.55	1,701,980.53		(+) Empréstimos										Mês	-R$4.8481298
	13	R$366,895.98	R$128,618.71	238,277.27	1,573,361.82		Saídas de Caixa	2,700,000.00	- 0	- 0	- 0	- 0	- 0				Dia	-25.4438942407
	14	R$366,895.98	R$146,625.33	220,270.66	1,426,736.49		(-) Investimento	2,700,000.00									Ano 4, mês 4 e dia 25
	15	R$366,895.98	R$167,152.87	199,743.11	1,259,583.62		(-) Amortização
	16	R$366,895.98	R$190,554.28	176,341.71	1,069,029.34		(-) Variação do ICG										VPL	643,834.55
	17	R$366,895.98	R$217,231.88	149,664.11	851,797.47		Fluxo de Caixa Livre	- 2,700,000.00	739,800.00	685,800.00	739,800.00	685,800.00	1,739,800.00
	18	R$366,895.98	R$247,644.34	119,251.65	604,153.13
	19	R$366,895.98	R$282,314.55	84,581.44	321,838.58		Projeção de depreciação	Valor do bem	Valor residual	Depreciação Anual
	20	R$366,895.98	R$321,838.58	45,057.40	0.00		Instalação equipamentos	2,000,000.00	1,000,000.00	40,000.00
	Total da Dívida	R$7,337,919.68	R$2,430,000.00	6,608,919.68			Maq e equipamentos	700,000.00	- 0	70,000.00
							Total	2,700,000.00	1,000,000.00	110,000.00