PRICE VPL TIR planilha de calculo

Prévia do material em texto

Estudo Dirigido
	SIMULAÇÃO TABELA PRICE.						SIMULAÇÃO TABELA SAC.						VPL - VALOR PRESENTE LIQUIDO ( 2,0% a.a)
	VALOR FINANCIAMENTO		1,550.00				VALOR FINANCIAMENTO		100,000.00
	TAXA DE JUROS (%)		0.04	am.			TAXA DE JUROS (%)		0.02	am.			PERÍODO	RECEITA	INVESTIMENTO
	QUANTIDADE DE PARCELAS		9.00				QUANTIDADE DE PARCELAS		10.00				0		5,000.00
	PERÍODO	JUROS	PRESTAÇÃO	AMORTIZAÇÃO	SALDO		PERÍODO 	PRESTAÇÃO	AMORTIZAÇÃO	JUROS	SALDO DEVEDOR		1	5,000.00
	0				5,000.00		0				100,000.00		2	0.00
	1	2.00	616.45	614.45	4,385.55		1	12,000.00	10,000.00	2,000.00	90,000.00		3	0.00
	2	1.75	616.45	614.70	3,770.84		2	11,800.00	10,000.00	1,800.00	80,000.00		4	0.00
	3	1.51	616.45	614.95	3,155.90		3	11,600.00	10,000.00	1,600.00	70,000.00		5	0.00
	4	1.26	616.45	615.19	2,540.71		4	11,400.00	10,000.00	1,400.00	60,000.00		VP	R$4,940.71
	5	1.02	616.45	615.44	1,925.27		5	11,200.00	10,000.00	1,200.00	50,000.00		VPL	-R$59.29
	6	0.77	616.45	615.68	1,309.58		6	11,000.00	10,000.00	1,000.00	40,000.00
	7	0.52	616.45	615.93	693.65		7	10,800.00	10,000.00	800.00	30,000.00		TIR - TAXA DE RETORNO
	8	0.28	616.45	616.18	77.47		8	10,600.00	10,000.00	600.00	20,000.00
	9	0.03	616.45	616.42	-538.95		9	10,400.00	10,000.00	400.00	10,000.00		PERÍODO	RECEITA
	10	-0.22	616.45	616.67	-1,155.62		10	10,200.00	10,000.00	200.00	0.00		0	-5,000.00
	11	-23.11	264.36	287.47	-1,443.09		11	4,166.67	4,166.67	0.00	-4,166.67		1	5,000.00
	12	-28.86	264.36	293.22	-1,736.30		12	4,083.33	4,166.67	-83.33	-8,333.33		2	0.00
	13	-34.73	264.36	299.08	-2,035.39		13	4,000.00	4,166.67	-166.67	-12,500.00		3	0.00
	14	-40.71	264.36	305.06	-2,340.45		14	3,916.67	4,166.67	-250.00	-16,666.67		4	0.00
	15	-46.81	264.36	311.16	-2,651.61		15	3,833.33	4,166.67	-333.33	-20,833.33		5	0.00
	16	-53.03	264.36	317.39	-2,969.00		16	3,750.00	4,166.67	-416.67	-25,000.00		TIR	0.0%
	17	-59.38	264.36	323.74	-3,292.74		17	3,666.67	4,166.67	-500.00	-29,166.67
	18	-65.85	264.36	330.21	-3,622.95		18	3,583.33	4,166.67	-583.33	-33,333.33		OBS: Qualquer taxa abaixo de 34,9% torna o investimento economicamente viável.
	19	-72.46	264.36	336.81	-3,959.76		19	3,500.00	4,166.67	-666.67	-37,500.00
	20	-79.20	264.36	343.55	-4,303.31		20	3,416.67	4,166.67	-750.00	-41,666.67		Nota: 
	21	-86.07	264.36	350.42	-4,653.73		21	3,333.33	4,166.67	-833.33	-45,833.33		Com base nas premissas refernete planejamento estrategico da empresa e visando um financiamento com valor inicial com parcela menor a melhor opção de financiamento atraves da tabela PRICE.
	22	-93.07	264.36	357.43	-5,011.16		22	3,250.00	4,166.67	-916.67	-50,000.00
	23	-100.22	264.36	364.58	-5,375.74		23	3,166.67	4,166.67	-1,000.00	-54,166.67
	24	-107.51	264.36	371.87	-5,747.61		24	3,083.33	4,166.67	-1,083.33	-58,333.33
	TOTAIS	-882.09	9,865.52	10,747.61	9,865.52		TOTAIS	161,750.00	158,333.33	3,416.67	161,750.00
Forúm
	SIMULAÇÃO TABELA PRICE.						SIMULAÇÃO TABELA SAC.						VPL - VALOR PRESENTE LIQUIDO ( 2,0% a.a)
	VALOR FINANCIAMENTO		200,000.00				VALOR FINANCIAMENTO		200,000.00
	TAXA DE JUROS (%)		0.02	a.a			TAXA DE JUROS (%)		0.02	a.a			PERÍODO	RECEITA	INVESTIMENTO
	QUANTIDADE DE PARCELAS		60.00				QUANTIDADE DE PARCELAS		60.00				0		200,000.00
	PERÍODO	JUROS	PRESTAÇÃO	AMORTIZAÇÃO	SALDO		PERÍODO 	PRESTAÇÃO	AMORTIZAÇÃO	JUROS	SALDO DEVEDOR		1	90,000.00
	0				200,000.00		0				200,000.00		2	102,000.00
	1	4,000.00	5,753.59	1,753.59	198,246.41		1	7,333.33	3,333.33	4,000.00	196,666.67		3	92,000.00
	2	3,964.93	5,753.59	1,788.67	196,457.74		2	7,266.67	3,333.33	3,933.33	193,333.33		4	80,000.00
	3	3,929.15	5,753.59	1,824.44	194,633.30		3	7,200.00	3,333.33	3,866.67	190,000.00		5	70,000.00
	4	3,892.67	5,753.59	1,860.93	192,772.38		4	7,133.33	3,333.33	3,800.00	186,666.67		VP	R$410,276.96
	5	3,855.45	5,753.59	1,898.15	190,874.23		5	7,066.67	3,333.33	3,733.33	183,333.33		VPL	R$210,276.96
	6	3,817.48	5,753.59	1,936.11	188,938.12		6	7,000.00	3,333.33	3,666.67	180,000.00
	7	3,778.76	5,753.59	1,974.83	186,963.29		7	6,933.33	3,333.33	3,600.00	176,666.67		TIR - TAXA DE RETORNO
	8	3,739.27	5,753.59	2,014.33	184,948.96		8	6,866.67	3,333.33	3,533.33	173,333.33
	9	3,698.98	5,753.59	2,054.61	182,894.35		9	6,800.00	3,333.33	3,466.67	170,000.00		PERÍODO	RECEITA
	10	3,657.89	5,753.59	2,095.71	180,798.64		10	6,733.33	3,333.33	3,400.00	166,666.67		0	-200,000.00
	11	3,615.97	5,753.59	2,137.62	178,661.02		11	6,666.67	3,333.33	3,333.33	163,333.33		1	90,000.00
	12	3,573.22	5,753.59	2,180.37	176,480.65		12	6,600.00	3,333.33	3,266.67	160,000.00		2	102,000.00
	13	3,529.61	5,753.59	2,223.98	174,256.67		13	6,533.33	3,333.33	3,200.00	156,666.67		3	92,000.00
	14	3,485.13	5,753.59	2,268.46	171,988.21		14	6,466.67	3,333.33	3,133.33	153,333.33		4	80,000.00
	15	3,439.76	5,753.59	2,313.83	169,674.38		15	6,400.00	3,333.33	3,066.67	150,000.00		5	70,000.00
	16	3,393.49	5,753.59	2,360.11	167,314.28		16	6,333.33	3,333.33	3,000.00	146,666.67		TIR	34.9%
	17	3,346.29	5,753.59	2,407.31	164,906.97		17	6,266.67	3,333.33	2,933.33	143,333.33
	18	3,298.14	5,753.59	2,455.45	162,451.52		18	6,200.00	3,333.33	2,866.67	140,000.00		OBS: Qualquer taxa abaixo de 34,9% torna o investimento economicamente viável.
	19	3,249.03	5,753.59	2,504.56	159,946.95		19	6,133.33	3,333.33	2,800.00	136,666.67
	20	3,198.94	5,753.59	2,554.65	157,392.30		20	6,066.67	3,333.33	2,733.33	133,333.33		Nota: 
	21	3,147.85	5,753.59	2,605.75	154,786.55		21	6,000.00	3,333.33	2,666.67	130,000.00		Com base nas premissas refernete planejamento estrategico da empresa e visando um financiamento com valor inicial com parcela menor a melhor opção de financiamento atraves da tabela PRICE.
	22	3,095.73	5,753.59	2,657.86	152,128.69		22	5,933.33	3,333.33	2,600.00	126,666.67
	23	3,042.57	5,753.59	2,711.02	149,417.67		23	5,866.67	3,333.33	2,533.33	123,333.33
	24	2,988.35	5,753.59	2,765.24	146,652.43		24	5,800.00	3,333.33	2,466.67	120,000.00
	25	2,933.05	5,753.59	2,820.54	143,831.89		25	5,733.33	3,333.33	2,400.00	116,666.67
	26	2,876.64	5,753.59	2,876.96	140,954.93		26	5,666.67	3,333.33	2,333.33	113,333.33
	27	2,819.10	5,753.59	2,934.49	138,020.44		27	5,600.00	3,333.33	2,266.67	110,000.00
	28	2,760.41	5,753.59	2,993.18	135,027.25		28	5,533.33	3,333.33	2,200.00	106,666.67
	29	2,700.55	5,753.59	3,053.05	131,974.20		29	5,466.67	3,333.33	2,133.33	103,333.33
	30	2,639.48	5,753.59	3,114.11	128,860.09		30	5,400.00	3,333.33	2,066.67	100,000.00
	31	2,577.20	5,753.59	3,176.39	125,683.70		31	5,333.33	3,333.33	2,000.00	96,666.67
	32	2,513.67	5,753.59	3,239.92	122,443.78		32	5,266.67	3,333.33	1,933.33	93,333.33
	33	2,448.88	5,753.59	3,304.72	119,139.07		33	5,200.00	3,333.33	1,866.67	90,000.00
	34	2,382.78	5,753.59	3,370.81	115,768.25		34	5,133.33	3,333.33	1,800.00	86,666.67
	35	2,315.37	5,753.59	3,438.23	112,330.03		35	5,066.67	3,333.33	1,733.33	83,333.33
	36	2,246.60	5,753.59	3,506.99	108,823.03		36	5,000.00	3,333.33	1,666.67	80,000.00
	37	2,176.46	5,753.59	3,577.13	105,245.90		37	4,933.33	3,333.33	1,600.00	76,666.67
	38	2,104.92	5,753.59	3,648.68	101,597.23		38	4,866.67	3,333.33	1,533.33	73,333.33
	39	2,031.94	5,753.59	3,721.65	97,875.58		39	4,800.00	3,333.33	1,466.67	70,000.00
	40	1,957.51	5,753.59	3,796.08	94,079.50		40	4,733.33	3,333.33	1,400.00	66,666.67
	41	1,881.59	5,753.59	3,872.00	90,207.49		41	4,666.67	3,333.33	1,333.33	63,333.33
	42	1,804.15	5,753.59	3,949.44	86,258.05		42	4,600.00	3,333.33	1,266.67	60,000.00
	43	1,725.16	5,753.59	4,028.43	82,229.62		43	4,533.33	3,333.33	1,200.00	56,666.67
	44	1,644.59	5,753.59	4,109.00	78,120.62		44	4,466.67	3,333.33	1,133.33	53,333.33
	45	1,562.41	5,753.59	4,191.18	73,929.43		45	4,400.00	3,333.33	1,066.67	50,000.00
	46	1,478.59	5,753.59	4,275.00	69,654.43		46	4,333.33	3,333.33	1,000.00	46,666.67
	47	1,393.09	5,753.59	4,360.50	65,293.93		47	4,266.67	3,333.33	933.33	43,333.33
	48	1,305.88	5,753.59	4,447.71	60,846.21		48	4,200.00	3,333.33	866.67	40,000.00
	49	1,216.92	5,753.59	4,536.67	56,309.54		49	4,133.33	3,333.33	800.00	36,666.67
	50	1,126.19	5,753.59	4,627.40	51,682.14		50	4,066.67	3,333.33	733.33	33,333.33
	51	1,033.64	5,753.59	4,719.95	46,962.19		51	4,000.00	3,333.33	666.67	30,000.00
	52	939.24	5,753.59	4,814.35	42,147.8452	3,933.33	3,333.33	600.00	26,666.67
	53	842.96	5,753.59	4,910.64	37,237.20		53	3,866.67	3,333.33	533.33	23,333.33
	54	744.74	5,753.59	5,008.85	32,228.35		54	3,800.00	3,333.33	466.67	20,000.00
	55	644.57	5,753.59	5,109.03	27,119.33		55	3,733.33	3,333.33	400.00	16,666.67
	56	542.39	5,753.59	5,211.21	21,908.12		56	3,666.67	3,333.33	333.33	13,333.33
	57	438.16	5,753.59	5,315.43	16,592.69		57	3,600.00	3,333.33	266.67	10,000.00
	58	331.85	5,753.59	5,421.74	11,170.95		58	3,533.33	3,333.33	200.00	6,666.67
	59	223.42	5,753.59	5,530.17	5,640.78		59	3,466.67	3,333.33	133.33	3,333.33
	60	112.82	5,753.59	5,640.78	-0.00		60	3,400.00	3,333.33	66.67	-0.00
	TOTAIS	145,215.59	345,215.59	200,000.00	345,215.59		TOTAIS	322,000.00	200,000.00	122,000.00	322,000.00