Cap2 Matemática Financeira

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

C2.juros
	valor presente	1,000
	modalidade	juros simples @ 5,00%	juros compostos @ 5,00%	juros contínuos @ 5,00%	juros simples @ 30,00%	juros compostos @ 30,00%	juros contínuos @ 30,00%	juros simples @ 50,00%	juros compostos @ 50,00%	juros contínuos @ 50,00%	juros contínuos @ 40,55%
	taxa	5.00%	5.00%	5.00%	30.00%	30.00%	30.00%	50.00%	50.00%	50.00%	40.55%
	0.0	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000
	0.1	1,005	1,005	1,005	1,030	1,027	1,030	1,050	1,041	1,051	1,041
	0.2	1,010	1,010	1,010	1,060	1,054	1,062	1,100	1,084	1,105	1,084
	0.3	1,015	1,015	1,015	1,090	1,082	1,094	1,150	1,129	1,162	1,129
	0.4	1,020	1,020	1,020	1,120	1,111	1,127	1,200	1,176	1,221	1,176
	0.5	1,025	1,025	1,025	1,150	1,140	1,162	1,250	1,225	1,284	1,225
	0.6	1,030	1,030	1,030	1,180	1,170	1,197	1,300	1,275	1,350	1,275
	0.7	1,035	1,035	1,036	1,210	1,202	1,234	1,350	1,328	1,419	1,328
	0.8	1,040	1,040	1,041	1,240	1,234	1,271	1,400	1,383	1,492	1,383
	0.9	1,045	1,045	1,046	1,270	1,266	1,310	1,450	1,440	1,568	1,440
	1.0	1,050	1,050	1,051	1,300	1,300	1,350	1,500	1,500	1,649	1,500
	1.1	1,055	1,055	1,057	1,330	1,335	1,391	1,550	1,562	1,733	1,562
	1.2	1,060	1,060	1,062	1,360	1,370	1,433	1,600	1,627	1,822	1,627
	1.3	1,065	1,065	1,067	1,390	1,406	1,477	1,650	1,694	1,916	1,694
	1.4	1,070	1,071	1,073	1,420	1,444	1,522	1,700	1,764	2,014	1,764
	1.5	1,075	1,076	1,078	1,450	1,482	1,568	1,750	1,837	2,117	1,837
	1.6	1,080	1,081	1,083	1,480	1,522	1,616	1,800	1,913	2,226	1,913
	1.7	1,085	1,086	1,089	1,510	1,562	1,665	1,850	1,992	2,340	1,992
	1.8	1,090	1,092	1,094	1,540	1,604	1,716	1,900	2,075	2,460	2,075
	1.9	1,095	1,097	1,100	1,570	1,646	1,768	1,950	2,161	2,586	2,161
	2.0	1,100	1,103	1,105	1,600	1,690	1,822	2,000	2,250	2,718	2,250
	2.1	1,105	1,108	1,111	1,630	1,735	1,878	2,050	2,343	2,858	2,343
	2.2	1,110	1,113	1,116	1,660	1,781	1,935	2,100	2,440	3,004	2,440
	2.3	1,115	1,119	1,122	1,690	1,828	1,994	2,150	2,541	3,158	2,541
	2.4	1,120	1,124	1,127	1,720	1,877	2,054	2,200	2,646	3,320	2,646
	2.5	1,125	1,130	1,133	1,750	1,927	2,117	2,250	2,756	3,490	2,756
	2.6	1,130	1,135	1,139	1,780	1,978	2,181	2,300	2,870	3,669	2,870
	2.7	1,135	1,141	1,145	1,810	2,031	2,248	2,350	2,988	3,857	2,988
	2.8	1,140	1,146	1,150	1,840	2,085	2,316	2,400	3,112	4,055	3,112
	2.9	1,145	1,152	1,156	1,870	2,140	2,387	2,450	3,241	4,263	3,241
	3.0	1,150	1,158	1,162	1,900	2,197	2,460	2,500	3,375	4,482	3,375
	3.1	1,155	1,163	1,168	1,930	2,255	2,535	2,550	3,515	4,711	3,515
	3.2	1,160	1,169	1,174	1,960	2,315	2,612	2,600	3,660	4,953	3,660
	3.3	1,165	1,175	1,179	1,990	2,377	2,691	2,650	3,812	5,207	3,812
	3.4	1,170	1,180	1,185	2,020	2,440	2,773	2,700	3,969	5,474	3,969
	3.5	1,175	1,186	1,191	2,050	2,505	2,858	2,750	4,134	5,755	4,134
	3.6	1,180	1,192	1,197	2,080	2,572	2,945	2,800	4,305	6,050	4,305
	3.7	1,185	1,198	1,203	2,110	2,640	3,034	2,850	4,483	6,360	4,483
	3.8	1,190	1,204	1,209	2,140	2,710	3,127	2,900	4,668	6,686	4,668
	3.9	1,195	1,210	1,215	2,170	2,782	3,222	2,950	4,861	7,029	4,861
	4.0	1,200	1,216	1,221	2,200	2,856	3,320	3,000	5,063	7,389	5,063
	4.1	1,205	1,221	1,228	2,230	2,932	3,421	3,050	5,272	7,768	5,272
	4.2	1,210	1,227	1,234	2,260	3,010	3,525	3,100	5,490	8,166	5,490
	4.3	1,215	1,233	1,240	2,290	3,090	3,633	3,150	5,717	8,585	5,717
	4.4	1,220	1,239	1,246	2,320	3,172	3,743	3,200	5,954	9,025	5,954
	4.5	1,225	1,246	1,252	2,350	3,256	3,857	3,250	6,200	9,488	6,200
	4.6	1,230	1,252	1,259	2,380	3,343	3,975	3,300	6,457	9,974	6,457
	4.7	1,235	1,258	1,265	2,410	3,432	4,096	3,350	6,724	10,486	6,724
	4.8	1,240	1,264	1,271	2,440	3,523	4,221	3,400	7,002	11,023	7,002
	4.9	1,245	1,270	1,278	2,470	3,617	4,349	3,450	7,292	11,588	7,292
	5.0	1,250	1,276	1,284	2,500	3,713	4,482	3,500	7,594	12,182	7,594
C2.ex.juros
	VP	VF	i	n	resposta	Data/Hora	Cotação	Mínima	Máxima	Variação	Variação (%)	Volume
	2/21/14	14.15	14.07	14.32	-0.01	-0.07	18,578,600	262,887,190
	Exercício	100.00	calcule	10.0%	4	VF	146.41	2/20/14	14.16	13.98	14.34	-0.04	-0.28	23,904,700	338,490,552
	Exercício	100.00	calcule	10.0%	8	VF	214.36	2/19/14	14.2	13.88	14.2	0.09	0.64	28,137,400	399,551,080
	Exercício	2,590.15	calcule	1.79%	12	VF	3,204.69	2/18/14	14.11	14.11	14.58	-0.32	-2.22	30,703,200	433,222,152
	Exercício	1,000	calcule	0.50%	12	VF	1,061.68	2/17/14	14.43	14.33	14.7	-0.15	-1.03	12,592,700	181,712,661
	Exercício	calcule	100,000	1.71%	18	VP	73,698	2/14/14	14.58	14.47	14.71	-0.03	-0.21	26,187,900	381,819,582
	Exercício	calcule	3.5415	0.0418%	10	VP	3.5267	2/13/14	14.61	14.44	14.83	-0.35	-2.34	27,734,600	405,202,506
	Exercício	calcule	8,500	15.80%	10	VP	1,960	2/12/14	14.96	14.85	15.1	0	0	23,122,000	345,905,120
	Exercício	120.00	150.00	calcule	6	taxa	3.79%	2/11/14	14.96	14.64	15.07	0.35	2.4	28,798,500	430,825,560
	Exercício	7,000	12,000	calcule	21	taxa	2.60%	2/10/14	14.61	14.33	14.7	0.16	1.11	28,697,400	419,269,014
	Exercício	1,800	1,810	calcule	15	taxa	0.0369%	9.8%	2/7/14	14.45	14.16	14.55	0.24	1.69	33,879,300	489,555,885
	Exercício	35,000	38,500	2.0%	calcule	nper	4.8	2/6/14	14.21	13.92	14.36	0.38	2.75	31,670,700	450,040,647
	Exercício	15.91	22.00	2.5%	calcule	nper	13.1	2/5/14	13.83	13.56	14.28	-0.26	-1.85	38,798,000	536,576,340
	Exercício	100,000	105,000	1.0%	calcule	nper	4.9	2/4/14	14.09	13.77	14.22	0.24	1.73	35,916,200	506,059,258
	Exercício	100,000	105,200	1.0%	calcule	nper	5.1	2/3/14	13.85	13.84	14.63	-0.85	-5.78	50,958,800	705,779,380
	14.30
	Sabrina	500	calcule	1.00%	3	VF	515.15	http://cotacoes.economia.uol.com.br/acao/cotacoes-historicas.html?codigo=PETR4.SA&beginDay=1&beginMonth=2&beginYear=2014&endDay=29&endMonth=2&endYear=2014&size=50&page=1&period=
	Paulo	12,000	18,000	calcule	6	taxa	6.99%	http://economia.uol.com.br/ultimas-noticias/efe/2010/09/24/lula-oficializa-lancamento-de-acoes-da-petrobras-que-teve-emissao-recorde.jhtm
	Beth	1,000	calcule	12.00%	3	VF	1,404.93	http://www.investidorpetrobras.com.br/pt/comunicados-e-fatos-relevantes/fato-relevante-aprovacao-do-preco-por-acao.htm
	Paulo	12,000	18,000	calcule	6	taxa	6.99%
	Cristiane	1,000	1,850	5.00%	calcule	nper	12.6
	Jonatan	calcule	400,000	10.00%	1	VP	363,636
	Jonatan	375,000	calcule	10.00%	1	VF	412,500
	Jonatan	375,000	400,000	calcule	1	taxa	6.67%
	Petrobrás	26.30	14.30	calcule	41	taxa	-1.48%
	Petrobrás	14.30	26.30	calcule	12	taxa	5.21%
	Petrobrás	14.30	26.30	3.00%	calcule	nper	20.6