Sistema SAC e Price

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

SAC
	SISTEMA DE AMORTIZAÇÃO CONSTANTE - SAC
							VARIÁVEIS
	Parc	Amortização	Juros	Prestação	Saldo		Valor a financiar		R$ 50,000.00
	0	-	-	-	R$ 50,000.00		Nr de prest (em meses)		60
	1	R$ 833.33	R$ 500.00	R$ 1,333.33	R$ 49,166.67		Taxa ao mês		1.00000
	2	R$ 833.33	R$ 491.67	R$ 1,325.00	R$ 48,333.33
	3	R$ 833.33	R$ 483.33	R$ 1,316.67	R$ 47,500.00
	4	R$ 833.33	R$ 475.00	R$ 1,308.33	R$ 46,666.67
	5	R$ 833.33	R$ 466.67	R$ 1,300.00	R$ 45,833.33
	6	R$ 833.33	R$ 458.33	R$ 1,291.67	R$ 45,000.00
	7	R$ 833.33	R$ 450.00	R$ 1,283.33	R$ 44,166.67
	8	R$ 833.33	R$ 441.67	R$ 1,275.00	R$ 43,333.33		Detalhes:
	9	R$ 833.33	R$ 433.33	R$ 1,266.67	R$ 42,500.00		Começa pagando =		R$ 1,333.33
	10	R$ 833.33	R$ 425.00	R$ 1,258.33	R$ 41,666.67		Termina pagando =		R$ 841.67
	11	R$ 833.33	R$ 416.67	R$ 1,250.00	R$ 40,833.33		Juros Pagos Período =		R$ 15,250.00
	12	R$ 833.33	R$ 408.33	R$ 1,241.67	R$ 40,000.00
	13	R$ 833.33	R$ 400.00	R$ 1,233.33	R$ 39,166.67
	14	R$ 833.33	R$ 391.67	R$ 1,225.00	R$ 38,333.33
	15	R$ 833.33	R$ 383.33	R$ 1,216.67	R$ 37,500.00
	16	R$ 833.33	R$ 375.00	R$ 1,208.33	R$ 36,666.67
	17	R$ 833.33	R$ 366.67	R$ 1,200.00	R$ 35,833.33
	18	R$ 833.33	R$ 358.33	R$ 1,191.67	R$ 35,000.00
	19	R$ 833.33	R$ 350.00	R$ 1,183.33	R$ 34,166.67
	20	R$ 833.33	R$ 341.67	R$ 1,175.00	R$ 33,333.33
	21	R$ 833.33	R$ 333.33	R$ 1,166.67	R$ 32,500.00
	22	R$ 833.33	R$ 325.00	R$ 1,158.33	R$ 31,666.67
	23	R$ 833.33	R$ 316.67	R$ 1,150.00	R$ 30,833.33
	24	R$ 833.33	R$ 308.33	R$ 1,141.67	R$ 30,000.00
	25	R$ 833.33	R$ 300.00	R$ 1,133.33	R$ 29,166.67
	26	R$ 833.33	R$ 291.67	R$ 1,125.00	R$ 28,333.33
	27	R$ 833.33	R$ 283.33	R$ 1,116.67	R$ 27,500.00
	28	R$ 833.33	R$ 275.00	R$ 1,108.33	R$ 26,666.67
	29	R$ 833.33	R$ 266.67	R$ 1,100.00	R$ 25,833.33
	30	R$ 833.33	R$ 258.33	R$ 1,091.67	R$ 25,000.00
	31	R$ 833.33	R$ 250.00	R$ 1,083.33	R$ 24,166.67
	32	R$ 833.33	R$ 241.67	R$ 1,075.00	R$ 23,333.33
	33	R$ 833.33	R$ 233.33	R$ 1,066.67	R$ 22,500.00
	34	R$ 833.33	R$ 225.00	R$ 1,058.33	R$ 21,666.67
	35	R$ 833.33	R$ 216.67	R$ 1,050.00	R$ 20,833.33
	36	R$ 833.33	R$ 208.33	R$ 1,041.67	R$ 20,000.00
	37	R$ 833.33	R$ 200.00	R$ 1,033.33	R$ 19,166.67
	38	R$ 833.33	R$ 191.67	R$ 1,025.00	R$ 18,333.33
	39	R$ 833.33	R$ 183.33	R$ 1,016.67	R$ 17,500.00
	40	R$ 833.33	R$ 175.00	R$ 1,008.33	R$ 16,666.67
	41	R$ 833.33	R$ 166.67	R$ 1,000.00	R$ 15,833.33
	42	R$ 833.33	R$ 158.33	R$ 991.67	R$ 15,000.00
	43	R$ 833.33	R$ 150.00	R$ 983.33	R$ 14,166.67
	44	R$ 833.33	R$ 141.67	R$ 975.00	R$ 13,333.33
	45	R$ 833.33	R$ 133.33	R$ 966.67	R$ 12,500.00
	46	R$ 833.33	R$ 125.00	R$ 958.33	R$ 11,666.67
	47	R$ 833.33	R$ 116.67	R$ 950.00	R$ 10,833.33
	48	R$ 833.33	R$ 108.33	R$ 941.67	R$ 10,000.00
	49	R$ 833.33	R$ 100.00	R$ 933.33	R$ 9,166.67
	50	R$ 833.33	R$ 91.67	R$ 925.00	R$ 8,333.33
	51	R$ 833.33	R$ 83.33	R$ 916.67	R$ 7,500.00
	52	R$ 833.33	R$ 75.00	R$ 908.33	R$ 6,666.67
	53	R$ 833.33	R$ 66.67	R$ 900.00	R$ 5,833.33
	54	R$ 833.33	R$ 58.33	R$ 891.67	R$ 5,000.00
	55	R$ 833.33	R$ 50.00	R$ 883.33	R$ 4,166.67
	56	R$ 833.33	R$ 41.67	R$ 875.00	R$ 3,333.33
	57	R$ 833.33	R$ 33.33	R$ 866.67	R$ 2,500.00
	58	R$ 833.33	R$ 25.00	R$ 858.33	R$ 1,666.67
	59	R$ 833.33	R$ 16.67	R$ 850.00	R$ 833.33
	60	R$ 833.33	R$ 8.33	R$ 841.67	-R$ 0.00
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
PRICE
	SISTEMA DE AMORTIZAÇÃO FRANCÊS - PRICE
							VARIÁVEIS
	Parc	Amortização	Juros	Prestação	Saldo		Valor a financiar		R$ 50,000.00
	0	-	-	-	R$ 50,000.00		Nr de prest (em meses)		60
	1	R$ 612.22	R$ 500.00	R$ 1,112.22	R$ 49,387.78		Taxa ao mês		1.00000
	2	R$ 618.34	R$ 493.88	R$ 1,112.22	R$ 48,769.43		Calculo '1		0
	3	R$ 624.53	R$ 487.69	R$ 1,112.22	R$ 48,144.90		Calculo '2		1.01
	4	R$ 630.77	R$ 481.45	R$ 1,112.22	R$ 47,514.13		Calculo '3		1.8166966986
	5	R$ 637.08	R$ 475.14	R$ 1,112.22	R$ 46,877.05		Calculo '4		0.8166966986
	6	R$ 643.45	R$ 468.77	R$ 1,112.22	R$ 46,233.60		Calculo '5
	7	R$ 649.89	R$ 462.34	R$ 1,112.22	R$ 45,583.71		Calculo '6		0.018166967
	8	R$ 656.39	R$ 455.84	R$ 1,112.22	R$ 44,927.33		Fator 		44.9550384062
	9	R$ 662.95	R$ 449.27	R$ 1,112.22	R$ 44,264.38
	10	R$ 669.58	R$ 442.64	R$ 1,112.22	R$ 43,594.80		Detalhes:
	11	R$ 676.27	R$ 435.95	R$ 1,112.22	R$ 42,918.52		Começa e termina pag:		R$ 1,112.22
	12	R$ 683.04	R$ 429.19	R$ 1,112.22	R$ 42,235.49		Juros Pagos Período =		R$ 16,733.34
	13	R$ 689.87	R$ 422.35	R$ 1,112.22	R$ 41,545.62		Juros Equivalente =		33.466686%
	14	R$ 696.77	R$ 415.46	R$ 1,112.22	R$ 40,848.85
	15	R$ 703.73	R$ 408.49	R$ 1,112.22	R$ 40,145.12
	16	R$ 710.77	R$ 401.45	R$ 1,112.22	R$ 39,434.35
	17	R$ 717.88	R$ 394.34	R$ 1,112.22	R$ 38,716.47
	18	R$ 725.06	R$ 387.16	R$ 1,112.22	R$ 37,991.41
	19	R$ 732.31	R$ 379.91	R$ 1,112.22	R$ 37,259.10
	20	R$ 739.63	R$ 372.59	R$ 1,112.22	R$ 36,519.47
	21	R$ 747.03	R$ 365.19	R$ 1,112.22	R$ 35,772.45
	22	R$ 754.50	R$ 357.72	R$ 1,112.22	R$ 35,017.95
	23	R$ 762.04	R$ 350.18	R$ 1,112.22	R$ 34,255.90
	24	R$ 769.66	R$ 342.56	R$ 1,112.22	R$ 33,486.24
	25	R$ 777.36	R$ 334.86	R$ 1,112.22	R$ 32,708.88
	26	R$ 785.13	R$ 327.09	R$ 1,112.22	R$ 31,923.75
	27	R$ 792.98	R$ 319.24	R$ 1,112.22	R$ 31,130.76
	28	R$ 800.91	R$ 311.31	R$ 1,112.22	R$ 30,329.85
	29	R$ 808.92	R$ 303.30	R$ 1,112.22	R$ 29,520.92
	30	R$ 817.01	R$ 295.21	R$ 1,112.22	R$ 28,703.91
	31	R$ 825.18	R$ 287.04	R$ 1,112.22	R$ 27,878.73
	32	R$ 833.44	R$ 278.79	R$ 1,112.22	R$ 27,045.29
	33	R$ 841.77	R$ 270.45	R$ 1,112.22	R$ 26,203.52
	34	R$ 850.19	R$ 262.04	R$ 1,112.22	R$ 25,353.34
	35	R$ 858.69	R$ 253.53	R$ 1,112.22	R$ 24,494.65
	36	R$ 867.28	R$ 244.95	R$ 1,112.22	R$ 23,627.37
	37	R$ 875.95	R$ 236.27	R$ 1,112.22	R$ 22,751.42
	38	R$ 884.71	R$ 227.51	R$ 1,112.22
R$ 21,866.71
	39	R$ 893.56	R$ 218.67	R$ 1,112.22	R$ 20,973.16
	40	R$ 902.49	R$ 209.73	R$ 1,112.22	R$ 20,070.67
	41	R$ 911.52	R$ 200.71	R$ 1,112.22	R$ 19,159.15
	42	R$ 920.63	R$ 191.59	R$ 1,112.22	R$ 18,238.52
	43	R$ 929.84	R$ 182.39	R$ 1,112.22	R$ 17,308.68
	44	R$ 939.14	R$ 173.09	R$ 1,112.22	R$ 16,369.55
	45	R$ 948.53	R$ 163.70	R$ 1,112.22	R$ 15,421.02
	46	R$ 958.01	R$ 154.21	R$ 1,112.22	R$ 14,463.01
	47	R$ 967.59	R$ 144.63	R$ 1,112.22	R$ 13,495.42
	48	R$ 977.27	R$ 134.95	R$ 1,112.22	R$ 12,518.15
	49	R$ 987.04	R$ 125.18	R$ 1,112.22	R$ 11,531.11
	50	R$ 996.91	R$ 115.31	R$ 1,112.22	R$ 10,534.20
	51	R$ 1,006.88	R$ 105.34	R$ 1,112.22	R$ 9,527.32
	52	R$ 1,016.95	R$ 95.27	R$ 1,112.22	R$ 8,510.37
	53	R$ 1,027.12	R$ 85.10	R$ 1,112.22	R$ 7,483.25
	54	R$ 1,037.39	R$ 74.83	R$ 1,112.22	R$ 6,445.86
	55	R$ 1,047.76	R$ 64.46	R$ 1,112.22	R$ 5,398.09
	56	R$ 1,058.24	R$ 53.98	R$ 1,112.22	R$ 4,339.85
	57	R$ 1,068.82	R$ 43.40	R$ 1,112.22	R$ 3,271.03
	58	R$ 1,079.51	R$ 32.71	R$ 1,112.22	R$ 2,191.52
	59	R$ 1,090.31	R$ 21.92	R$ 1,112.22	R$ 1,101.21
	60	R$ 1,101.21	R$ 11.01	R$ 1,112.22	R$ 0.00
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
1
2
3
4
5
6
7
8
9
10
11
A
B
C
D
Parc
Amortização
Juros
Prestação
0
-
-
-
1
R$ 612,22
R$ 500,00
R$ 1.112,22
2
R$ 618,34
R$ 493,88
R$ 1.112,22
3
R$ 624,53
R$ 487,69
R$ 1.112,22
4
R$ 630,77
R$ 481,45
R$ 1.112,22
5
R$ 637,08
R$ 475,14
R$ 1.112,22
6
R$ 643,45
R$ 468,77
R$ 1.112,22
SISTEMA DE AMORTIZAÇÃO FRANCÊS - PRICE