A maior rede de estudos do Brasil

Grátis
46 pág.

## Pré-visualização | Página 4 de 9

```150	R\$ - 0	R\$ 1,800.00	R\$ 14.40	R\$ 1,814.40		150	R\$ 0.00	R\$ 3,072.79	R\$ 24.58	3097.3768745326
R\$ 163,080.00						R\$ 194,606.53
PRICE
R\$ 70,000	i=24% a.a	n= 5 meses				70000=pmt*[(1,02)^5-1/(1,02)^5*0,02]
R\$ 300,000	n= 6 mês	i=18 %a.a	1º parcela 3 meses depois = postecipada							R\$ 80,000.00	n=8 meses	i=12% a.a	pmt=x		80.000=pmt*[((1,01)^8-1)/((1,01^8)*0,01											1.1040808032	0.1040808032
taxa equivalente 		i=[(1+i)^n-1].100/[(1+i)^n-1].100		0.1264925866						TABELA PRICE				0.0828567056	0.0108285671					TABELA PRICE					1.1040808032	0.0220816161
i=[(1,18)^6-1].100/[(1,18)^6				PRESTAÇÃO:				saldo devedor	amortização	juros	prestação	7.6516777518						saldo devedor	amortização	juros	prestação
TABELA PRICE					PV=PMT*[(1+i)^n-1/(1+i)^n*i]			0	80,000				10455.2233634652					0	70,000						4.7134595085
saldo devedor	amortização	juros	prestação		1.0101643215	1.0101643215		1	70344.78	9655.22	800.00	R\$ 10,455.22						1	56548.91	13451.09	1400.00	R\$ 14,851.09		14851.0875873026
0	300,000					0.0101643215	0.001277783		2	60593.00	9751.78	703.45	R\$ 10,455.22						2	42828.80	13720.11	1130.98	R\$ 14,851.09
1	304500					0.1257125702			3	50743.71	9849.29	605.93	R\$ 10,455.22						3	28834.29	13994.51	856.58	R\$ 14,851.09
2	309067.50					R\$ 2,386,396.20			4	40795.92	9947.79	507.44	R\$ 10,455.22						4	14559.89	14274.40	576.69	R\$ 14,851.09
3	259454.37	49613.13	4636.01	54249.14					5	30748.66	10047.26	407.96	R\$ 10,455.22						5	0.00	14559.89	291.20	R\$ 14,851.09
4	209097.05	50357.32	3891.82	54249.14		R\$ 309,067.50			6	20600.92	10147.74	307.49	R\$ 10,455.22						total		70000.00	4255.44	R\$ 74,255.44
5	157984.36	51112.68	3136.46	54249.14		R\$ 67.00			7	10351.71	10249.21	206.01	R\$ 10,455.22
6	106104.99	51879.37	2369.77	54249.14					8	0.00	10351.71	103.52	R\$ 10,455.22
Não entendi	7	53447.42	52657.57	1591.57	54249.14					total		80000.00	3641.79	R\$ 83,641.79
8	-0.00	53447.43	801.71	54249.14
r\$5.000	n=3 meses	i= 2% a.m
U\$20000	n= 36 meses	postecipada		i=1%a.m							TABELA PRICE				1.061208	0.061208																															TABELA PRICE
saldo devedor	amortização	juros	prestação		0.02122416					R\$ 4,000	n= 5 meses 	sem entrada, antecipada		i= 18%a.a 										r\$100.000	n=10 meses	postecipada		i=120%a.a								saldo devedor	amortização	juros	prestação
TABELA PRICE				1.4307687836	0.4307687836				0	5,000					2.8838832726					TABELA PRICE			PV=PMT*(1+i)*(1+i)^n-1/i										TABELA PRICE												0	10,000					0.21899442
saldo devedor	amortização	juros	prestação	1.4307687836	0.0143076878				1	3366.23	1633.77	100.00	R\$ 1,733.77	1733.7733629591						saldo devedor	amortização	juros	prestação										saldo devedor	amortização	juros	prestação				i=120/12					1	9086.73	913.27	200.00	R\$ 1,113.27		0.0243798884
0	20,000					30.1075050373				2	1699.78	1666.45	67.32	R\$ 1,733.77						0	4,000					não consigo achar este valor							0	100,000							10	%a.m				2	8155.20	931.53	181.73	R\$ 1,113.27		8.9825850062
1	19535.71	464.29	200.00	R\$ 664.29		664.286196257				3	-0.00	1699.78	34.00	R\$ 1,733.77						1	R\$ 3,223.64	R\$ 776.36	R\$ 60.00	R\$ 836.36									1	93725.46	6274.54	10000.00	R\$ 16,274.54									3	7205.04	950.16	163.10	R\$ 1,113.27		1113.2652786532
2	19066.78	468.93	195.36	R\$ 664.29						total										2	R\$ 2,435.63	R\$ 788.01	R\$ 48.35	R\$ 836.36									2	86823.47	6901.99	9372.55	R\$ 16,274.54			1.5937424601						4	6235.88	969.16	144.10	R\$ 1,113.27
3	18593.17	473.62	190.67	R\$ 664.29	PV=PMT*[(1+i)^n-1/(1+i)^n*i]															3	R\$ 1,635.81	R\$ 799.83	R\$ 36.53	R\$ 836.36									3	79231.27	7592.19	8682.35	R\$ 16,274.54			0.259374246						5	5247.33	988.55	124.72	R\$ 1,113.27		total de juros pago até a 3ªp			544.84
4	18114.81	478.35	185.93	R\$ 664.29																4	R\$ 823.99	R\$ 811.82	R\$ 24.54	R\$ 836.36									4	70879.86	8351.41	7923.13	R\$ 16,274.54			6.1445671057						6	4239.01	1008.32	104.95	R\$ 1,113.27		total de amortização pago até a 3ªp			2794.96
5	17631.67	483.14	181.15	R\$ 664.29	20000=PMT*[(1+0,01)^36-1/(1+0,01)^36*0,01]															5	-R\$ 0.01	R\$ 824.00	R\$ 12.36	R\$ 836.36									5	61693.31	9186.55	7087.99	R\$ 16,274.54			16274.5394882512						7	3210.53	1028.49	84.78	R\$ 1,113.27		saldo devedor pago ate a 3ª parcela			7205.04
6	17143.70	487.97	176.32	R\$ 664.29	1.4307687836	1.4307687836														total													6	51588.10	10105.21	6169.33	R\$ 16,274.54									8	2161.47	1049.05	64.21	R\$ 1,113.27
7	16650.86	492.85	171.44	R\$ 664.29	0.4307687836	0.0143076878																											7	40472.37	11115.73	5158.81	R\$ 16,274.54									9	1091.44	1070.04	43.23	R\$ 1,113.27
8	16153.08	497.78	166.51	R\$ 664.29	30.1075050373																												8	28245.07	12227.30	4047.24	R\$ 16,274.54									10	-0.00	1091.44	21.83	R\$ 1,113.27
9	15650.32	502.76	161.53	R\$ 664.29	664.286196257																												9	14795.04	13450.03	2824.51	R\$ 16,274.54
10	15142.54	507.78	156.50	R\$ 664.29																													10	0.00	14795.04	1479.50	R\$ 16,274.54
11	14629.68	512.86	151.43	R\$ 664.29
12	14111.69	517.99	146.30	R\$ 664.29						r\$400.000	n= 48 meses	i= 6%a.m
13	13588.52	523.17	141.12	R\$ 664.29
14	13060.12	528.40	135.89	R\$ 664.29							TABELA PRICE
15	12526.43	533.69	130.60	R\$ 664.29							saldo devedor	amortização	juros	prestação
16	11987.41	539.02	125.26	R\$ 664.29						0	400,000																																			saldo devedor	amortização	juros	prestação	1	0.0828567056
17	11443.00	544.41	119.87	R\$ 664.29						1	R\$ 424,000.00	-R\$ 24,000.00	R\$ 24,000.00	R\$ - 0																															0	80,000					0.0108285671
18	10893.14	549.86	114.43	R\$ 664.29						2	R\$ 449,440.00	-R\$ 25,440.00	R\$ 25,440.00	R\$ - 0	Juros contidas em 12 prestações conse, a partir de 30ª																														1	R\$ 70,344.78	R\$ 9,655.22	R\$ 800.00	R\$ 10,455.22336		7.6516777518
19	10337.79	555.35	108.93	R\$ 664.29						3	R\$ 476,406.40	-R\$ 26,966.40	R\$ 26,966.40	R\$ - 0	amortização contidas em 12 prestações conse, a partir de 30ª							R\$ 100,000	n=24 meses	i= 6%a.m			3.0489346413																		2	R\$ 60,593.00	R\$ 9,751.78	R\$ 703.45	R\$ 10,455.22336		10455.2233634652
20	9776.88	560.91	103.38	R\$ 664.29						4	R\$ 504,990.78	-R\$ 28,584.38	R\$ 28,584.38	R\$ - 0								TABELA PRICE					0.2429360785																		3	R\$ 50,743.71	R\$ 9,849.29	R\$ 605.93	R\$ 10,455.22336
21	9210.36	566.52	97.77	R\$ 664.29						5	R\$ 535,290.23	-R\$ 30,299.45	R\$ 30,299.45	R\$ - 0								saldo devedor	amortização	juros	prestação		12.5503575278																		4	R\$ 40,795.92	R\$ 9,947.79	R\$ 507.44	R\$ 10,455.22336
22	8638.18	572.18	92.10	R\$ 664.29						6	R\$ 567,407.64	-R\$ 32,117.41	R\$ 32,117.41	R\$ - 0		não consegui					0	100,000					7967.9004983543																		5	R\$ 30,748.66	R\$ 10,047.26	R\$ 407.96	R\$ 10,455.22336
23	8060.28	577.90	86.38	R\$ 664.29						7	R\$ 601,452.10	-R\$ 34,044.46	R\$ 34,044.46	R\$ - 0							1	R\$ 98,032.10	R\$ 1,967.90	R\$ 6,000.00	R\$ 7,967.90050																				6	R\$ 20,600.92	R\$ 10,147.74	R\$ 307.49	R\$ 10,455.22336
24	7476.59	583.68	80.60	R\$ 664.29						8	R\$ 637,539.23	-R\$ 36,087.13	R\$ 36,087.13	R\$ - 0							2	R\$ 95,946.12	R\$ 2,085.97	R\$ 5,881.93	R\$ 7,967.90050		a)	R\$ 74,061.51	ok																7	R\$ 10,351.71	R\$ 10,249.21	R\$ 206.01	R\$ 10,455.22336
25	6887.07	589.52	74.77	R\$ 664.29						9	R\$ 675,791.58	-R\$ 38,252.35	R\$ 38,252.35	R\$ - 0							3	R\$ 93,734.99	R\$ 2,211.13	R\$ 5,756.77	R\$ 7,967.90050		b)	R\$ 4,197.39	ok				r\$20.000	n=10 meses```