Cap9 Matemática Financeira

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

C9.ex.pyb
	A	C	B	D	E	investimento	lucro	taxa	pbs	pbd	TIR	VPL/I
	0	-1,000 	-1,000 	-1,000 	-1,000 	-1,000 
	1	150	150	0	250	400	3,000	600	1.88%	5.0	5.3	791.6%	9.7
	2	200	200	0	-400 	400	15,000	250	0.87%	60.0	85.4	21.9%	0.9
	3	150	150	150	250	400	120,000	20,000	18.00%	6.0	ERROR:#NUM!	16.7%	-0.1 
	4	180	180	200	300	400
	5	220	220	150	450	400
	6	250	250	180	0	400
	7	200	200	220	450	400
	8	120	120	250	300	400
	9	150	150	200	150	400
	10	200	1,400	120	200	400
	TMA	9.0%	4.0%	9.0%	11.0%	7.5%
	0	-1,000 	-1,000 	-1,000 	-1,000 	-1,000 
	1	-850 	-850 	-1,000 	-750 	-600 
	2	-650 	-650 	-1,000 	-1,150 	-200 
	3	-500 	-500 	-850 	-900 	200
	4	-320 	-320 	-650 	-600 	600
	5	-100 	-100 	-500 	-150 	1,000
	6	150	150	-320 	-150 	1,400
	7	350	350	-100 	300	1,800
	8	470	470	150	600	2,200
	9	620	620	350	750	2,600
	10	820	2,020	470	950	3,000
	0	-1,000 	-1,000 	-1,000 	-1,000 	-1,000 
	1	-862 	-856 	-1,000 	-775 	-628 
	2	-694 	-671 	-1,000 	-1,099 	-282 
	3	-578 	-538 	-884 	-917 	40
	4	-451 	-384 	-742 	-719 	340
	5	-308 	-203 	-645 	-452 	618
	6	-159 	-5 	-538 	-452 	878
	7	-49 	147	-417 	-235 	1,119
	8	11	234	-292 	-105 	1,343
	9	80	340	-200 	-46 	1,552
	10	165	1,286	-149 	24	1,746
C9.ex.pyb.venez
	ano	compra	aluguel	receita	custos	imobiliz	c.giro	v.term	receita	custos	aluguel	aluguel	c.giro	v.term
	0	-350,000 	-100,000 	-350,000 	-100,000 	-350,000 	-100,000 	-300,000 	-50,000 	-50,000 	-50,000 
	1	90,000	52,500	-260,000 	-47,500 	-273,729 	-55,508 	300,000	-210,000 	300,000	-210,000 	-37,500 
	2	90,000	52,500	-170,000 	5,000	-209,092 	-17,804 	300,000	-210,000 	300,000	-210,000 	-37,500 
	3	135,000	8,750	-35,000 	13,750	-126,927 	-12,478 	450,000	-315,000 	50,000	-35,000 	-6,250 
	4	135,000	8,750	100,000	22,500	-57,296 	-7,965 	450,000	-315,000 	50,000	-35,000 	-6,250 
	5	180,000	8,750	280,000	31,250	21,384	-4,140 	600,000	-420,000 	50,000	-35,000 	-6,250 
	6	180,000	8,750	460,000	40,000	88,062	-899 	600,000	-420,000 	50,000	-35,000 	-6,250 
	7	180,000	8,750	640,000	48,750	144,568	1,848	600,000	-420,000 	50,000	-35,000 	-6,250 
	8	137,143	1,607	777,143	50,357	181,054	2,275	600,000	-420,000 	-42,857 	50,000	-35,000 	-6,250 	-7,143 
	9	137,143	1,607	914,286	51,964	211,973	2,638	600,000	-420,000 	-42,857 	50,000	-35,000 	-6,250 	-7,143 
	10	899,048	10,536	1,813,333	62,500	383,749	4,651	600,000	-420,000 	-42,857 	761,905	50,000	-35,000 	-6,250 	-7,143 	8,929
	VPL	383,749	4,651	70%	18%	70%	12.5%	18%
	VPL/I	1.10	0.05
	TIR	37%	20%
	TIR-M	27%	19%
	TIR-M	27%	19%
C9.ex.pyb.metal
	projeto	investi-mento inicial	caixa gerado por mês	vida útil esperada (meses)	traz?	VPL	VPL/I	pb	VPL/I	pb
	A	ü	30,000	6,000	18	1	67,515	2.25	6	0	0	0	5.0	3	1	30,000	67,515	2.25	3	0	0	0	5.00	2	1	30,000	67,515
	B	ü	20,000	7,500	24	1	137,484	6.87	3	1	20,000	137,484	2.7	2	1	20,000	137,484	6.87	1	1	20,000	137,484	2.67	1	1	20,000	137,484
	C	û	20,000	12,500	60	0	527,224	26.36	1	1	20,000	527,224	1.6	1	1	20,000	527,224	-1,000.00 	5	0	0	0	1,000.00	5	0	0	0
	D	û	36,000	3,200	60	0	104,089	2.89	4	1	36,000	104,089	11.3	7	0	0	0	-1,000.00 	5	0	0	0	1,000.00	5	0	0	0
	E	û	24,000	4,700	18	0	52,387	2.18	7	0	0	0	5.1	4	1	24,000	52,387	-1,000.00 	5	0	0	0	1,000.00	5	0	0	0
	F	ü	54,000	9,000	24	1	134,981	2.50	5	0	0	0	6.0	6	0	0	0	2.50	2	1	54,000	134,981	6.00	3	0	0	0
	G	û	24,000	4,500	60	0	173,001	7.21	2	1	24,000	173,001	5.3	5	0	0	0	-1,000.00 	5	0	0	0	1,000.00	5	0	0	0
	H	ü	27,000	1,800	36	1	26,289	0.97	8	0	0	0	15.0	8	0	0	0	0.97	4	0	0	0	15.00	4	0	0	0
	14.0%	4	100,000	941,798	4	94,000	784,610	2	74,000	272,465	2	50,000	204,999
C9.payback
	ano	fluxo 
de caixa	fluxo 
de caixa acumulado	interpolação	ano	fluxo 
de caixa	fluxo 
de caixa acumulado	interpolação	ano	Projeto 
A	Projeto 
B	Projeto 
C
	ano	CENÁRIO
	0	-10,000 	-10,000 	0	-10,000 	-10,000 	0	-10,000 	-10,000 	-10,000 	A	B	C	D	E	F	G	H	I	J	OK
	1	2,100	-7,900 	1	2,100	-8,108 	1	2,500	2,500	2,500
	2	2,100	-5,800 	2	2,100	-6,404 	2	2,500	2,500	2,500	prob.	30.0%	21.0%	14.7%	10.3%	7.2%	5.0%	3.5%	2.5%	1.7%	1.2%	2.8%
	3	2,100	-3,700 	3	2,100	-4,868 	3	2,500	2,500	2,500
	4	2,100	-1,600 	4	2,100	-3,485 	4	2,500	2,500	2,500	0	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 
	5	2,100	500	5	2,100	-2,239 	5	2,500	30,000	-30,000 	1	0	50	50	50	50	50	50	50	50	50	50	35
	6	2,100	2,600	6	2,100	-1,116 	6	2,500	30,000	0	2	0	0	50	50	50	50	50	50	50	50	50	25
	7	2,100	4,700	7	2,100	-104 	7	2,500	30,000	0	3	0	0	0	50	50	50	50	50	50	50	50	17
	8	2,100	6,800	8	2,100	807	8	2,500	30,000	0	4	0	0	0	0	50	50	50	50	50	50	50	12
	9	2,100	8,900	9	2,100	1,628	9	2,500	30,000	0	5	0	0	0	0	0	50	50	50	50	50	50	8
	10	21,191	30,091	10	21,191	9,091	10	27,500	330,000	0	6	0	0	0	0	0	0	50	50	50	50	50	6
	TIR	28.7%	68.6%	não há	7	0	0	0	0	0	0	0	50	50	50	50	4
	k	11.0%	k	11.0%	11.0%	8	0	0	0	0	0	0	0	0	50	50	50	3
	k	10.0%	10.0%	10.0%	9	0	0	0	0	0	0	0	0	0	50	50	2
	r	21.0%	r	21.0%	10	0	0	0	0	0	0	0	0	0	0	150	4
	4.76	7.11
	0.0%	-30,000 	30.0%	16
	0.5%	-29,385 	50.0%	5.0%
	1.0%	-28,789 
	1.5%	-28,212 
	2.0%	-27,653 	ano	CENÁRIO
	2.5%	-27,111 	A	B	C	D	E	F	G	H	I	J	OK
	3.0%	-26,586 
	3.5%	-26,076 	prob.	30.0%	21.0%	14.7%	10.3%	7.2%	5.0%	3.5%	2.5%	1.7%	1.2%	2.8%
	4.0%	-25,583 
	4.5%	-25,105 	0	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 
	5.0%	-24,641 	1	0	0	0	0	0	0	0	0	0	0	0	0
	5.5%	-24,191 	2	0	0	0	0	0	0	0	0	0	0	0	0
	6.0%	-23,755 	3	0	0	0	0	0	0	0	0	0	0	0	0
	6.5%	-23,332 	4	0	0	0	0	0	0	0	0	0	0	0	0
	7.0%	-22,922 	5	0	0	0	0	0	0	0	0	0	0	0	0
	7.5%	-22,523 	6	0	0	0	0	0	0	429	429	429	429	429	50
	8.0%	-22,137 	7	0	0	0	0	0	0	0	429	429	429	429	35
	8.5%	-21,762 	8	0	0	0	0	0	0	0	0	429	429	429	25
	9.0%	-21,399 	9	0	0	0	0	0	0	0	0	0	429	429	17
	9.5%	-21,046 	10	0	0	0	0	0	0	0	0	0	0	529	15
	10.0%	-20,703 
	10.5%	-20,370 	30.0%	43
	11.0%	-20,047 	50.0%	5.0%
	11.5%	-19,734 	0.0%
	12.0%	-19,429 
	12.5%	-19,134 	ano	CENÁRIO
	13.0%	-18,847 	A	B	C	D	E	F	G	H	I	J	OK
	13.5%	-18,568 
	14.0%	-18,297 	prob.	30.0%	21.0%	14.7%	10.3%	7.2%	5.0%	3.5%	2.5%	1.7%	1.2%	2.8%
	14.5%	-18,034 
	15.0%	-17,778 	0	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 	-100 
	15.5%	-17,529 	1	0	50	50	50	50	50	50	50	50	50	50	35
	16.0%	-17,288 	2	0	0	50	50	50	50	50	50	50	50	50	25
	16.5%	-17,053 	3	0	0	0	50	50	50	50	50	50	50	50	17
	17.0%	-16,825 	4	0	0	0	0	50	50	50	50	50	50	50	12
	17.5%	-16,604 	5	0	0	0	0	0	50	50	50	50	50	50	8
	18.0%	-16,388 	6	0	0	0	0	0	0	50	50	50	50	50	6
	18.5%	-16,179 	7	0	0	0	0	0	0	0	50	50	50	50	4
	19.0%	-15,975 	8	0	0	0	0	0	0	0	0	50	50	50	3
	19.5%	-15,777 	9	0	0	0	0	0	0	0	0	0	50	50	2
	20.0%	-15,584 	10	0	0	0	0	0	0	0	0	0	0	150	4
	20.5%	-15,397 
	21.0%	-15,215 	30.0%	16
	21.5%	-15,038 	50.0%	5.0%
	22.0%	-14,866 
	22.5%	-14,698 
	23.0%	-14,535 
	23.5%	-14,377 
	24.0%	-14,223 
	24.5%	-14,072 
	25.0%	-13,926 
	25.5%	-13,784 
	26.0%	-13,646 
	26.5%	-13,511 
	27.0%	-13,380 
	27.5%	-13,253 
	28.0%	-13,129 
	28.5%	-13,008 
	29.0%	-12,890 
	29.5%	-12,776 
	30.0%	-12,664 
	30.5%	-12,556 
	31.0%	-12,450 
	31.5%	-12,347 
	32.0%	-12,247 
	32.5%	-12,149 
	33.0%	-12,054 
	33.5%	-11,962 
	34.0%	-11,871 
	34.5%	-11,784 
	35.0%	-11,698 
	35.5%	-11,615 
	36.0%	-11,534 
	36.5%	-11,454 
	37.0%	-11,377 
	37.5%	-11,302 
	38.0%	-11,229 
	38.5%	-11,158 
	39.0%	-11,089 
	39.5%	-11,021 
	40.0%	-10,955 
	40.5%	-10,891 
	41.0%	-10,828 
	41.5%	-10,767 
	42.0%	-10,708 
	42.5%	-10,650 
	43.0%	-10,593 
	43.5%	-10,538 
	44.0%	-10,485 
	44.5%	-10,433 
	45.0%	-10,382 
	45.5%	-10,332 
	46.0%	-10,284 
	46.5%	-10,236 
	47.0%	-10,191 
	47.5%	-10,146 
	48.0%	-10,102 
	48.5%	-10,060 
	49.0%	-10,018 
	49.5%	-9,978 
	50.0%	-9,938 
	50.5%	-9,900 
	51.0%	-9,862 
	51.5%	-9,826 
	52.0%	-9,790 
	52.5%	-9,756 
	53.0%	-9,722 
	53.5%	-9,689 
	54.0%	-9,657 
	54.5%	-9,626 
	55.0%	-9,595 
	55.5%	-9,566 
	56.0%	-9,537 
	56.5%	-9,508 
	57.0%	-9,481 
	57.5%	-9,454 
	58.0%	-9,428 
	58.5%	-9,403 
	59.0%	-9,378 
	59.5%	-9,354 
	60.0%	-9,330 
	60.5%	-9,307 
	61.0%	-9,285 
	61.5%	-9,263 
	62.0%
-9,242 
	62.5%	-9,221 
	63.0%	-9,201 
	63.5%	-9,182 
	64.0%	-9,162 
	64.5%	-9,144 
	65.0%	-9,126 
	65.5%	-9,108 
	66.0%	-9,091 
	66.5%	-9,074 
	67.0%	-9,058 
	67.5%	-9,042 
	68.0%	-9,027 
	68.5%	-9,012 
	69.0%	-8,997 
	69.5%	-8,983 
	70.0%	-8,969 
	70.5%	-8,956 
	71.0%	-8,943 
	71.5%	-8,930 
	72.0%	-8,917 
	72.5%	-8,905 
	73.0%	-8,894 
	73.5%	-8,882 
	74.0%	-8,871 
	74.5%	-8,860 
	75.0%	-8,850 
	75.5%	-8,840 
	76.0%	-8,830 
	76.5%	-8,820 
	77.0%	-8,811 
	77.5%	-8,802 
	78.0%	-8,793 
	78.5%	-8,784 
	79.0%	-8,776 
	79.5%	-8,768 
	80.0%	-8,760 
	80.5%	-8,753 
	81.0%	-8,745 
	81.5%	-8,738 
	82.0%	-8,731 
	82.5%	-8,725 
	83.0%	-8,718 
	83.5%	-8,712 
	84.0%	-8,706 
	84.5%	-8,700 
	85.0%	-8,694 
	85.5%	-8,689 
	86.0%	-8,683 
	86.5%	-8,678 
	87.0%	-8,673 
	87.5%	-8,669 
	88.0%	-8,664 
	88.5%	-8,659 
	89.0%	-8,655 
	89.5%	-8,651 
	90.0%	-8,647 
	90.5%	-8,643 
	91.0%	-8,639 
	91.5%	-8,636 
	92.0%	-8,632 
	92.5%	-8,629 
	93.0%	-8,626 
	93.5%	-8,623 
	94.0%	-8,620 
	94.5%	-8,617 
	95.0%	-8,614 
	95.5%	-8,612 
	96.0%	-8,609 
	96.5%	-8,607 
	97.0%	-8,605 
	97.5%	-8,603 
	98.0%	-8,601 
	98.5%	-8,599 
	99.0%	-8,597 
	99.5%	-8,595 
	100.0%	-8,594 
	100.5%	-8,592 
	101.0%	-8,591 
	101.5%	-8,589 
	102.0%	-8,588 
	102.5%	-8,587 
	103.0%	-8,586 
	103.5%	-8,585 
	104.0%	-8,584 
	104.5%	-8,583 
	105.0%	-8,582 
	105.5%	-8,582 
	106.0%	-8,581 
	106.5%	-8,581 
	107.0%	-8,580 
	107.5%	-8,580 
	108.0%	-8,579 
	108.5%	-8,579 
	109.0%	-8,579 
	109.5%	-8,579 
	110.0%	-8,579 
	110.5%	-8,579 
	111.0%	-8,579 
	111.5%	-8,579 
	112.0%	-8,579 
	112.5%	-8,579 
	113.0%	-8,579 
	113.5%	-8,580 
	114.0%	-8,580 
	114.5%	-8,580 
	115.0%	-8,581 
	115.5%	-8,581 
	116.0%	-8,582 
	116.5%	-8,582 
	117.0%	-8,583 
	117.5%	-8,584 
	118.0%	-8,584 
	118.5%	-8,585 
	119.0%	-8,586 
	119.5%	-8,587 
	120.0%	-8,588 
	120.5%	-8,589 
	121.0%	-8,590 
	121.5%	-8,591 
	122.0%	-8,592 
	122.5%	-8,593 
	123.0%	-8,594 
	123.5%	-8,595 
	124.0%	-8,596 
	124.5%	-8,597 
	125.0%	-8,598 
	125.5%	-8,600 
	126.0%	-8,601 
	126.5%	-8,602 
	127.0%	-8,603 
	127.5%	-8,605 
	128.0%	-8,606 
	128.5%	-8,607 
	129.0%	-8,609 
	129.5%	-8,610 
	130.0%	-8,612 
	130.5%	-8,613 
	131.0%	-8,615 
	131.5%	-8,616 
	132.0%	-8,618 
	132.5%	-8,619 
	133.0%	-8,621 
	133.5%	-8,623 
	134.0%	-8,624 
	134.5%	-8,626 
	135.0%	-8,627 
	135.5%	-8,629 
	136.0%	-8,631 
	136.5%	-8,633 
	137.0%	-8,634 
	137.5%	-8,636 
	138.0%	-8,638 
	138.5%	-8,639 
	139.0%	-8,641 
	139.5%	-8,643 
	140.0%	-8,645 
	140.5%	-8,647 
	141.0%	-8,649 
	141.5%	-8,650 
	142.0%	-8,652 
	142.5%	-8,654 
	143.0%	-8,656 
	143.5%	-8,658 
	144.0%	-8,660 
	144.5%	-8,662 
	145.0%	-8,664 
	145.5%	-8,665 
	146.0%	-8,667 
	146.5%	-8,669 
	147.0%	-8,671 
	147.5%	-8,673 
	148.0%	-8,675 
	148.5%	-8,677 
	149.0%	-8,679 
	149.5%	-8,681 
	150.0%	-8,683 
	150.5%	-8,685 
	151.0%	-8,687 
	151.5%	-8,689 
	152.0%	-8,691 
	152.5%	-8,693 
	153.0%	-8,695 
	153.5%	-8,697 
	154.0%	-8,699 
	154.5%	-8,701 
	155.0%	-8,703 
	155.5%	-8,706 
	156.0%	-8,708 
	156.5%	-8,710 
	157.0%	-8,712 
	157.5%	-8,714 
	158.0%	-8,716 
	158.5%	-8,718 
	159.0%	-8,720 
	159.5%	-8,722 
	160.0%	-8,724 
	160.5%	-8,726 
	161.0%	-8,728 
	161.5%	-8,730 
	162.0%	-8,733 
	162.5%	-8,735 
	163.0%	-8,737 
	163.5%	-8,739 
	164.0%	-8,741 
	164.5%	-8,743 
	165.0%	-8,745 
	165.5%	-8,747 
	166.0%	-8,749 
	166.5%	-8,751 
	167.0%	-8,754 
	167.5%	-8,756 
	168.0%	-8,758 
	168.5%	-8,760 
	169.0%	-8,762 
	169.5%	-8,764 
	170.0%	-8,766 
	170.5%	-8,768 
	171.0%	-8,770 
	171.5%	-8,772 
	172.0%	-8,775 
	172.5%	-8,777 
	173.0%	-8,779