GabaritoExercicios

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

Exercicio
	TR = 	21.87%
	PROJETO A
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-429,000.00	-R$429,000.00	-R$429,000.00	-R$429,000.00
	1	93,200	-R$335,800.00	R$76,474.93	-R$352,525.07	21.72%
	2	110,000	-R$225,800.00	R$74,062.62	-R$278,462.45	12.09%
	3	132,900	-R$92,900.00	R$73,423.41	-R$205,039.04	9.41%
	4	142,800	R$49,900.00	R$64,735.27	-R$140,303.77	7.45%
	5	163,200	R$213,100.00	R$60,706.63	-R$79,597.14	6.66%
	6	172,800	R$385,900.00	R$52,742.76	-R$26,854.38	5.80%
	7	190,000	R$575,900.00	R$47,585.64	R$20,731.26	5.38%
	VP	R$449,731.26
	VPL	R$20,731.26
	IL	* 1.05
	TIR	23.45%
	Retorno	9.79%
	Risco	5.75%
	cv (risco)	58.73%
	PROJETO B
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-368,000.00	-R$368,000.00	-R$368,000.00	-R$368,000.00
	1	92,100	-R$275,900.00	R$75,572.33	-R$292,427.67	25.03%
	2	129,600	-R$146,300.00	R$87,259.23	-R$205,168.44	16.28%
	3	119,000	-R$27,300.00	R$65,744.06	-R$139,424.38	9.79%
	4	142,900	R$115,600.00	R$64,780.60	-R$74,643.78	8.55%
	5	159,800	R$275,400.00	R$59,441.91	-R$15,201.87	7.48%
	6	34,900	R$310,300.00	R$10,652.33	-R$4,549.54	1.52%
	7	99,700	R$410,000.00	R$24,969.94	R$20,420.40	3.48%
	VP	R$388,420.40
	VPL	R$20,420.40
	IL	* 1.06
	TIR	23.96%
	Retorno	10.30%
	Risco	8.04%
	cv (risco)	78.06%
	PROJETO C
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-500,900.00	-R$500,900.00	-R$500,900.00	-R$500,900.00
	1	62,190.00	-R$438,710.00	R$51,029.79	-R$449,870.21	12.42%
	2	83,700.00	-R$355,010.00	R$56,354.92	-R$393,515.29	8.03%
	3	92,300.00	-R$262,710.00	R$50,993.08	-R$342,522.21	5.80%
	4	280,000.00	R$17,290.00	R$126,931.90	-R$215,590.31	11.74%
	5	190,300.00	R$207,590.00	R$70,787.20	-R$144,803.11	6.65%
	6	279,000.00	R$486,590.00	R$85,157.58	-R$59,645.53	7.66%
	7	379,000.00	R$865,590.00	R$94,920.83	R$35,275.30	8.38%
	VP	R$536,175.30
	VPL	R$35,275.30
	IL	* 1.07
	TIR	23.79%
	Retorno	8.67%
	Risco	2.49%
	cv (risco)	28.72%
	TR = 	21.87%
	PROJETO D
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-459,000.00	-R$459,000.00	-R$459,000.00	-R$459,000.00
	1	45,200	-R$413,800.00	R$37,088.70	-R$421,911.30	9.85%
	2	83,400	-R$330,400.00	R$56,152.93	-R$365,758.37	8.71%
	3	170,000	-R$160,400.00	R$93,920.09	-R$271,838.28	11.07%
	4	80,000	-R$80,400.00	R$36,266.26	-R$235,572.02	4.10%
	5	429,000	R$348,600.00	R$159,578.08	-R$75,993.94	14.11%
	6	389,000	R$737,600.00	R$118,732.26	R$42,738.32	10.77%
	7	100,900	R$838,500.00	R$25,270.48	R$68,008.80	2.88%
	VP	R$527,008.80
	VPL	R$68,008.80
	IL	* 1.15
	TIR	25.90%
	Retorno	8.78%
	Risco	3.99%
	cv (risco)	45.44%
	ANO	ALFA/BETA	ALFA/GAMA	ALFA/DELTA	BETA/GAMA	BETA/DELTA	GAMA/DELTA
	0
	1	23.38%	17.07%	15.78%	18.73%	17.44%	11.13%
	2	14.19%	10.06%	10.40%	12.15%	12.50%	8.37%
	3	9.60%	7.61%	10.24%	7.80%	10.43%	8.44%
	4	8.00%	9.60%	5.77%	10.15%	6.33%	7.92%
	5	7.07%	6.65%	10.38%	7.07%	10.79%	10.38%
	6	3.66%	6.73%	8.29%	4.59%	6.15%	9.22%
	7	4.43%	6.88%	4.13%	5.93%	3.18%	5.63%
Exercico03
	Taxa TR	15.17%
	PROJETO A
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-245,000.00	-245,000.00	-R$245,000.00	-R$245,000.00
	1	80,000	-165,000.00	R$69,462.53	-R$175,537.47	32.65%
	2	56,000	-109,000.00	R$42,219.13	-R$133,318.34	10.84%
	3	38,000	-71,000.00	R$24,875.14	-R$108,443.20	4.92%
	4	190,000	* 119,000.00	R$107,993.13	-R$450.07	15.43%
	VP	R$244,549.93
	VPL	-R$450.07
	IL	R$1.00
	TIR	15.09%
	Retorno	15.96%
	Risco	11.93%
	PROJETO B
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-245,000.00	-245,000.00	-R$245,000.00	-R$245,000.00
	1	67,000	-178,000.00	R$58,174.87	-R$186,825.13	27.35%
	2	95,400	-82,600.00	R$71,923.31	-R$114,901.82	17.87%
	3	99,760	* 17,160.00	R$65,303.78	-R$49,598.04	12.06%
	4	99,700	* 116,860.00	R$56,667.97	R$7,069.93	8.91%
	VP	R$252,069.93
	VPL	R$7,069.93
	IL	R$1.03
	TIR	16.50%
	Retorno	16.55%
	Risco	8.10%
	PROJETO C
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-245,000.00	-245,000.00	-R$245,000.00	-R$245,000.00
	1	68,700.00	-176,300.00	R$59,650.95	-R$185,349.05	28.04%
	2	87,500.00	-88,800.00	R$65,967.39	-R$119,381.66	16.50%
	3	99,460.00	* 10,660.00	R$65,107.40	-R$54,274.26	12.03%
	4	99,900.00	* 110,560.00	R$56,781.65	R$2,507.39	8.93%
	VP	R$247,507.39
	VPL	R$2,507.39
	IL	R$1.01
	TIR	15.64%
	Retorno	16.38%
	Risco	8.37%
	ANO	AB	AC	BC
	0
	1	30.00%	30.34%	27.70%
	2	14.36%	13.67%	17.18%
	3	8.49%	8.48%	12.04%
	4	12.17%	12.18%	8.92%
	Retorno	16.25%	16.17%	16.46%
	Risco	9.48%	9.70%	8.23%
Exercicio04
	TR = 	8.53%
	EQUIPAMENTO ALFA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,978,510.00	-R$1,978,510.00	-R$1,978,510.00	-R$1,978,510.00
	1	547,890	-R$1,430,620.00	R$504,828.16	-R$1,473,681.84	27.69%
	2	589,000	-R$841,620.00	R$500,052.60	-R$973,629.24	13.92%
	3	589,350	-R$252,270.00	R$461,024.37	-R$512,604.87	9.08%
	4	532,100	R$279,830.00	R$383,525.33	-R$129,079.54	6.14%
	5	430,890	R$710,720.00	R$286,165.58	R$157,086.04	4.02%
	6	745,900	R$1,456,620.00	R$456,438.00	R$613,524.04	5.48%
	7	650,490	R$2,107,110.00	R$366,768.48	R$980,292.52	4.14%
	VP	R$2,958,802.52
	VPL	R$980,292.52
	IL	* 1.50
	TIR	21.60%
	Retorno	10.07%
	Risco	8.51%
	cv (risco)	84.51%
	EQUIPAMENTO BETA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,978,510.00	-R$1,978,510.00	-R$1,978,510.00	-R$1,978,510.00
	1	459,000	-R$1,519,510.00	R$422,924.54	-R$1,555,585.46	23.20%
	2	724,890	-R$794,620.00	R$615,421.27	-R$940,164.19	16.89%
	3	459,200	-R$335,420.00	R$359,213.35	-R$580,950.84	7.20%
	4	659,800	R$324,380.00	R$475,568.52	-R$105,382.32	7.46%
	5	550,000	R$874,380.00	R$365,269.72	R$259,887.40	5.03%
	6	378,900	R$1,253,280.00	R$231,859.98	R$491,747.38	2.96%
	7	845,900	R$2,099,180.00	R$476,947.31	R$968,694.69	5.22%
	VP	R$2,947,204.69
	VPL	R$968,694.69
	IL	* 1.49
	TIR	21.34%
	Retorno	9.71%
	Risco	7.44%
	cv (risco)	76.62%
	EQUIPAMENTO GAMA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,978,510.00	-R$1,978,510.00	-R$1,978,510.00	-R$1,978,510.00
	1	678,100.00	-R$1,300,410.00	R$624,804.20	-R$1,353,705.80	34.27%
	2	500,000.00	-R$800,410.00	R$424,492.87	-R$929,212.93	11.92%
	3	459,000.00	-R$341,410.00	R$359,056.90	-R$570,156.03	7.20%
	4	720,980.00	R$379,570.00	R$519,665.64	-R$50,490.39	8.08%
	5	549,000.00	R$928,570.00	R$364,605.60	R$314,115.21	5.02%
	6	890,000.00	R$1,818,570.00	R$544,616.99	R$858,732.20	6.39%
	7	960,000.00	R$2,778,570.00	R$541,280.79	R$1,400,012.99	5.81%
	VP	R$3,378,522.99
	VPL	R$1,400,012.99
	IL	* 1.71
	TIR	25.54%
	Retorno	11.24%
	Risco	10.40%
	cv (risco)	92.53%
	TR = 	8.53%
	EQUIOPAMENTO DELTA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,047,900.00	-R$1,047,900.00	-R$1,047,900.00	-R$1,047,900.00
	1	790,600	-R$257,300.00	R$728,462.18	-R$319,437.82	75.45%
	2	690,000	R$432,700.00	R$585,800.16	R$266,362.34	28.78%
	3	462,000	R$894,700.00	R$361,403.68	R$627,766.02	12.95%
	4	540,300	R$1,435,000.00	R$389,435.69	R$1,017,201.71	10.95%
	5	456,980	R$1,891,980.00	R$303,492.65	R$1,320,694.36	7.51%
	6	530,000	R$2,421,980.00	R$324,322.48	R$1,645,016.84	7.06%
	7	679,000	R$3,100,980.00	R$382,843.39	R$2,027,860.23	7.40%
	VP	R$3,075,760.23
	VPL	R$2,027,860.23
	IL	* 2.94
	TIR	60.81%
	Retorno	21.44%
	Risco	25.00%
	cv (risco)	116.60%
	ANO	ALFA/BETA	ALFA/GAMA	ALFA/DELTA	BETA/GAMA	BETA/DELTA	GAMA/DELTA
	0
	1	25.45%	30.98%	51.57%	28.73%	49.32%	54.86%
	2	15.40%	12.92%	21.35%	14.41%	22.84%	20.35%
	3	8.14%	8.14%	11.02%	7.20%	10.08%	10.08%
	4	6.80%	7.11%	8.54%	7.77%	9.21%	9.52%
	5	4.52%	4.52%	5.76%	5.03%	6.27%	6.26%
	6	4.22%	5.93%	6.27%	4.67%	5.01%	6.73%
	7	4.68%	4.98%	5.77%	5.52%	6.31%	6.60%
Exercicio05
	TR = 	10.06%
	EQUIPAMENTO ALFA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,861,110.00	-R$1,861,110.00	-R$1,861,110.00	-R$1,861,110.00
	1	547,890	-R$1,313,220.00	R$497,810.29	-R$1,363,299.71	29.44%
	2	589,000	-R$724,220.00	R$486,246.26	-R$877,053.45	14.74%
	3	589,350	-R$134,870.00	R$442,063.61	-R$434,989.84	9.60%
	4	532,100	R$397,230.00	R$362,639.60	-R$72,350.24	6.49%
	5	430,890	R$828,120.00	R$266,820.30	R$194,470.06	4.25%
	6	745,900	R$1,574,020.00	R$419,665.78	R$614,135.84	5.78%
	7	650,490	R$2,224,510.00	R$332,532.48	R$946,668.32	4.38%
	VP	R$2,807,778.32
	VPL	R$946,668.32
IL	* 1.51
	TIR	23.89%
	Retorno	10.67%
	Risco	9.06%
	cv (risco)	84.91%
	EQUIPAMENTO BETA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,861,110.00	-R$1,861,110.00	-R$1,861,110.00	-R$1,861,110.00
	1	459,000	-R$1,402,110.00	R$417,045.25	-R$1,444,064.75	24.66%
	2	724,890	-R$677,220.00	R$598,429.63	-R$845,635.12	17.88%
	3	459,200	-R$218,020.00	R$344,439.82	-R$501,195.30	7.63%
	4	659,800	R$441,780.00	R$449,670.38	-R$51,524.92	7.88%
	5	550,000	R$991,780.00	R$340,576.87	R$289,051.95	5.31%
	6	378,900	R$1,370,680.00	R$213,180.54	R$502,232.49	3.14%
	7	845,900	R$2,216,580.00	R$432,426.66	R$934,659.15	5.50%
	VP	R$2,795,769.15
	VPL	R$934,659.15
	IL	* 1.50
	TIR	23.59%
	Retorno	10.29%
	Risco	7.91%
	cv (risco)	76.87%
	EQUIPAMENTO GAMA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,861,110.00	-R$1,861,110.00	-R$1,861,110.00	-R$1,861,110.00
	1	678,100.00	-R$1,183,010.00	R$616,118.48	-R$1,244,991.52	36.44%
	2	500,000.00	-R$683,010.00	R$412,772.72	-R$832,218.80	12.63%
	3	459,000.00	-R$224,010.00	R$344,289.80	-R$487,929.00	7.62%
	4	720,980.00	R$496,970.00	R$491,366.09	R$3,437.09	8.53%
	5	549,000.00	R$1,045,970.00	R$339,957.64	R$343,394.73	5.31%
	6	890,000.00	R$1,935,970.00	R$500,740.77	R$844,135.50	6.73%
	7	960,000.00	R$2,895,970.00	R$490,754.93	R$1,334,890.43	6.12%
	VP	R$3,196,000.43
	VPL	R$1,334,890.43
	IL	* 1.72
	TIR	27.87%
	Retorno	11.91%
	Risco	11.08%
	cv (risco)	93.03%
	TR = 	10.06%
	EQUIOPAMENTO DELTA
	ANO	Capital	PBS	VP	PBD	Taxa anual
	0	-1,861,110.00	-R$1,861,110.00	-R$1,861,110.00	-R$1,861,110.00
	1	790,600	-R$1,070,510.00	R$718,335.45	-R$1,142,774.55	42.48%
	2	690,000	-R$380,510.00	R$569,626.35	-R$573,148.20	17.08%
	3	462,000	R$81,490.00	R$346,540.06	-R$226,608.14	7.67%
	4	540,300	R$621,790.00	R$368,228.11	R$141,619.97	6.58%
	5	456,980	R$1,078,770.00	R$282,976.03	R$424,596.00	4.49%
	6	530,000	R$1,608,770.00	R$298,193.94	R$722,789.94	4.26%
	7	679,000	R$2,287,770.00	R$347,106.87	R$1,069,896.81	4.54%
	VP	R$2,931,006.81
	VPL	R$1,069,896.81
	IL	* 1.57
	TIR	27.35%
	Retorno	12.44%
	Risco	13.99%
	cv (risco)	112.46%
	ANO	ALFA/BETA	ALFA/GAMA	ALFA/DELTA	BETA/GAMA	BETA/DELTA	GAMA/DELTA
	0
	1	27.05%	32.94%	35.96%	30.55%	33.57%	39.46%
	2	16.31%	13.69%	15.91%	15.25%	17.48%	14.86%
	3	8.62%	8.61%	8.64%	7.63%	7.65%	7.65%
	4	7.18%	7.51%	6.53%	8.21%	7.23%	7.56%
	5	4.78%	4.78%	4.37%	5.31%	4.90%	4.90%
	6	4.46%	6.25%	5.02%	4.93%	3.70%	5.50%
	7	4.94%	5.25%	4.46%	5.81%	5.02%	5.33%