Tabela Price, SAC e Mista em Excel

Prévia do material em texto

Price
	Parcela	Juros	Amortização	Pagamento	Saldo Devedor		Financiamento	R$ 50,000.00
	0	R$ - 0	R$ - 0	R$ - 0	R$ 50,000.00		Taxa ao mês	2.30%
	1	R$ 1,150.00	R$ 3,665.52	R$ 4,815.52	R$ 46,334.48
	2	R$ 1,065.69	R$ 3,749.83	R$ 4,815.52	R$ 42,584.65
	3	R$ 979.45	R$ 3,836.07	R$ 4,815.52	R$ 38,748.58
	4	R$ 891.22	R$ 3,924.30	R$ 4,815.52	R$ 34,824.28
	5	R$ 800.96	R$ 4,014.56	R$ 4,815.52	R$ 30,809.72
	6	R$ 708.62	R$ 4,106.90	R$ 4,815.52	R$ 26,702.82
	7	R$ 614.16	R$ 4,201.35	R$ 4,815.52	R$ 22,501.47
	8	R$ 517.53	R$ 4,297.99	R$ 4,815.52	R$ 18,203.48
	9	R$ 418.68	R$ 4,396.84	R$ 4,815.52	R$ 13,806.64
	10	R$ 317.55	R$ 4,497.97	R$ 4,815.52	R$ 9,308.67
	11	R$ 214.10	R$ 4,601.42	R$ 4,815.52	R$ 4,707.25
	12	R$ 108.27	R$ 4,707.25	R$ 4,815.52	-R$ 0.00
	SOMA	R$ 7,786.24	R$ 50,000.00	R$ 57,786.24
SAC
	Parcela	Juros	Amortização	Pagamento	Saldo Devedor		Financiamento	R$ 50,000.00
	0	R$ - 0	R$ - 0	R$ - 0	R$ 50,000.00		Taxa ao mês	2.30%
	1	R$ 1,150.00	R$ 4,166.67	R$ 5,316.67	R$ 45,833.33
	2	R$ 1,054.17	R$ 4,166.67	R$ 5,220.83	R$ 41,666.67
	3	R$ 958.33	R$ 4,166.67	R$ 5,125.00	R$ 37,500.00
	4	R$ 862.50	R$ 4,166.67	R$ 5,029.17	R$ 33,333.33
	5	R$ 766.67	R$ 4,166.67	R$ 4,933.33	R$ 29,166.67
	6	R$ 670.83	R$ 4,166.67	R$ 4,837.50	R$ 25,000.00
	7	R$ 575.00	R$ 4,166.67	R$ 4,741.67	R$ 20,833.33
	8	R$ 479.17	R$ 4,166.67	R$ 4,645.83	R$ 16,666.67
	9	R$ 383.33	R$ 4,166.67	R$ 4,550.00	R$ 12,500.00
	10	R$ 287.50	R$ 4,166.67	R$ 4,454.17	R$ 8,333.33
	11	R$ 191.67	R$ 4,166.67	R$ 4,358.33	R$ 4,166.67
	12	R$ 95.83	R$ 4,166.67	R$ 4,262.50	R$ - 0
	SOMA	R$ 7,475.00	R$ 50,000.00	R$ 57,475.00
SAM
	SAC									PRICE
	Parcela	Juros	Amortização	Pagamento	Saldo Devedor		Financiamento	R$ 2,000.00		Parcela	Juros	Amortização	Pagamento	Saldo Devedor		Financiamento	R$ 2,000.00
	0	R$ - 0	R$ - 0	R$ - 0	R$ 2,000.00		Taxa ao mês	5.00%		0	R$ - 0	R$ - 0	R$ - 0	R$ 2,000.00		Taxa ao mês	5.00%
	1	R$ 100.00	R$ 333.33	R$ 433.33	R$ 1,666.67					1	R$ 100.00	R$ 294.03	R$ 394.03	R$ 1,705.97
	2	R$ 83.33	R$ 333.33	R$ 416.67	R$ 1,333.33					2	R$ 85.30	R$ 308.74	R$ 394.03	R$ 1,397.23
	3	R$ 66.67	R$ 333.33	R$ 400.00	R$ 1,000.00					3	R$ 69.86	R$ 324.17	R$ 394.03	R$ 1,073.05
	4	R$ 50.00	R$ 333.33	R$ 383.33	R$ 666.67					4	R$ 53.65	R$ 340.38	R$ 394.03	R$ 732.67
	5	R$ 33.33	R$ 333.33	R$ 366.67	R$ 333.33					5	R$ 36.63	R$ 357.40	R$ 394.03	R$ 375.27
	6	R$ 16.67	R$ 333.33	R$ 350.00	R$ - 0					6	R$ 18.76	R$ 375.27	R$ 394.03	R$ 0.00
	SOMA	R$ 350.00	R$ 2,000.00	R$ 2,350.00						SOMA	R$ 364.21	R$ 2,000.00	R$ 2,364.21
					SAM
					Parcela	Juros	Amortização	Pagamento	Saldo Devedor		Financiamento	R$ 2,000.00
					0	R$ - 0	R$ - 0	R$ - 0	R$ 2,000.00		Taxa ao mês	5.00%
					1	R$ 100.00	R$ 313.68	R$ 413.68	R$ 1,686.32
					2	R$ 84.32	R$ 321.04	R$ 405.35	R$ 1,365.28
					3	R$ 68.26	R$ 328.75	R$ 397.02	R$ 1,036.53
					4	R$ 51.83	R$ 336.86	R$ 388.68	R$ 699.67
					5	R$ 34.98	R$ 345.37	R$ 380.35	R$ 354.30
					6	R$ 17.72	R$ 354.30	R$ 372.02	R$ - 0
					SOMA	R$ 357.10	R$ 2,000.00	R$ 2,357.10