Atividade Mat. Financeira Sac

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

Plan1
	Período	Saldo Devedor	Amortização	Juros	Prestação	Saldo Atual	2.5%
	0	-	-	-	-	* 40,000.00
	1	* 41,000.00	* 1,666.67	* 1,000.00	* 2,666.67	* 38,333.33
	2	* 39,291.67	* 1,666.67	* 958.33	* 2,625.00	* 36,666.67
	3	* 37,583.33	* 1,666.67	* 916.67	* 2,583.33	* 35,000.00
	4	* 35,875.00	* 1,666.67	* 875.00	* 2,541.67	* 33,333.33
	5	* 34,166.67	* 1,666.67	* 833.33	* 2,500.00	* 31,666.67
	6	* 32,458.33	* 1,666.67	* 791.67	* 2,458.33	* 30,000.00
	7	* 30,750.00	* 1,666.67	* 750.00	* 2,416.67	* 28,333.33
	8	* 29,041.67	* 1,666.67	* 708.33	* 2,375.00	* 26,666.67
	9	* 27,333.33	* 1,666.67	* 666.67	* 2,333.33	* 25,000.00
	10	* 25,625.00	* 1,666.67	* 625.00	* 2,291.67	* 23,333.33
	11	* 23,916.67	* 1,666.67	* 583.33	* 2,250.00	* 21,666.67
	12	* 22,208.33	* 1,666.67	* 541.67	* 2,208.33	* 20,000.00
	13	* 20,500.00	* 1,666.67	* 500.00	* 2,166.67	* 18,333.33
	14	* 18,791.67	* 1,666.67	* 458.33	* 2,125.00	* 16,666.67
	15	* 17,083.33	* 1,666.67	* 416.67	* 2,083.33	* 15,000.00
	16	* 15,375.00	* 1,666.67	* 375.00	* 2,041.67	* 13,333.33
	17	* 13,666.67	* 1,666.67	* 333.33	* 2,000.00	* 11,666.67
	18	* 11,958.33	* 1,666.67	* 291.67	* 1,958.33	* 10,000.00
	19	* 10,250.00	* 1,666.67	* 250.00	* 1,916.67	* 8,333.33
	20	* 8,541.67	* 1,666.67	* 208.33	* 1,875.00	* 6,666.67
	21	* 6,833.33	* 1,666.67	* 166.67	* 1,833.33	* 5,000.00
	22	* 5,125.00	* 1,666.67	* 125.00	* 1,791.67	* 3,333.33
	23	* 3,416.67	* 1,666.67	* 83.33	* 1,750.00	* 1,666.67
	24	* 1,708.33	* 1,666.67	* 41.67	* 1,708.33	-
	Total das Aplicações ->	* 40,000.00	* 12,500.00	* 52,500.00	-
	Financiamento Imobiliário - Tabela Price 	1.125%
	Período (n)	Saldo Devedor	Amortização	Juros (%)	Prestação	Saldo Atual
	0	-	-	-	-	* 40,000.00
	1	* 40,450.00	* 1,461.08	* 450.00	* 1,911.08	* 38,538.92
	2	* 38,972.48	* 1,477.52	* 433.56	* 1,911.08	* 37,061.40
	3	* 37,478.34	* 1,494.14	* 416.94	* 1,911.08	* 35,567.26
	4	* 35,967.40	* 1,510.95	* 400.13	* 1,911.08	* 34,056.32
	5	* 34,439.45	* 1,527.95	* 383.13	* 1,911.08	* 32,528.37
	6	* 32,894.31	* 1,545.14	* 365.94	* 1,911.08	* 30,983.23
	7	* 31,331.79	* 1,562.52	* 348.56	* 1,911.08	* 29,420.71
	8	* 29,751.70	* 1,580.10	* 330.98	* 1,911.08	* 27,840.62
	9	* 28,153.82	* 1,597.87	* 313.21	* 1,911.08	* 26,242.74
	10	* 26,537.98	* 1,615.85	* 295.23	* 1,911.08	* 24,626.90
	11	* 24,903.95	* 1,634.03	* 277.05	* 1,911.08	* 22,992.87
	12	* 23,251.54	* 1,652.41	* 258.67	* 1,911.08	* 21,340.46
	13	* 21,580.54	* 1,671.00	* 240.08	* 1,911.08	* 19,669.46
	14	* 19,890.74	* 1,689.80	* 221.28	* 1,911.08	* 17,979.66
	15	* 18,181.93	* 1,708.81	* 202.27	* 1,911.08	* 16,270.85
	16	* 16,453.90	* 1,728.03	* 183.05	* 1,911.08	* 14,542.82
	17	* 14,706.42	* 1,747.47	* 163.61	* 1,911.08	* 12,795.34
	18	* 12,939.29	* 1,767.13	* 143.95	* 1,911.08	* 11,028.21
	19	* 11,152.28	* 1,787.01	* 124.07	* 1,911.08	* 9,241.20
	20	* 9,345.16	* 1,807.12	* 103.96	* 1,911.08	* 7,434.08
	21	* 7,517.72	* 1,827.45	* 83.63	* 1,911.08	* 5,606.64
	22	* 5,669.71	* 1,848.01	* 63.07	* 1,911.08	* 3,758.63
	23	* 3,800.92	* 1,868.80	* 42.28	* 1,911.08	* 1,889.84
	24	* 1,911.10	* 1,889.82	* 21.26	* 1,911.08	* 0.0
Plan2
Plan3