TRABALHO RAPHA 1 ETAPA

Prévia do material em texto

Planilha1
	MENSAL	R$ 5,000.00	ANUAL	R$ 60,000.00	 TOTAL	R$ 688,195.27
	Rendimento / mês	0.06	6%	a.a
	Prazo (anos)	20	anos
	ANOS	CAPITAL	JUROS 	SAQUE 	SALDO
	1	R$ 688,195.27	R$ 41,291.72	R$ 60,000.00	R$ 669,486.99
	2	R$ 669,486.99	R$ 40,169.22	R$ 60,000.00	R$ 649,656.21
	3	R$ 649,656.21	R$ 38,979.37	R$ 60,000.00	R$ 628,635.58
	4	R$ 628,635.58	R$ 37,718.13	R$ 60,000.00	R$ 606,353.72
	5	R$ 606,353.72	R$ 36,381.22	R$ 60,000.00	R$ 582,734.94
	6	R$ 582,734.94	R$ 34,964.10	R$ 60,000.00	R$ 557,699.04
	7	R$ 557,699.04	R$ 33,461.94	R$ 60,000.00	R$ 531,160.98
	8	R$ 531,160.98	R$ 31,869.66	R$ 60,000.00	R$ 503,030.64
	9	R$ 503,030.64	R$ 30,181.84	R$ 60,000.00	R$ 473,212.47
	10	R$ 473,212.47	R$ 28,392.75	R$ 60,000.00	R$ 441,605.22
	11	R$ 441,605.22	R$ 26,496.31	R$ 60,000.00	R$ 408,101.54
	12	R$ 408,101.54	R$ 24,486.09	R$ 60,000.00	R$ 372,587.63
	13	R$ 372,587.63	R$ 22,355.26	R$ 60,000.00	R$ 334,942.89
	14	R$ 334,942.89	R$ 20,096.57	R$ 60,000.00	R$ 295,039.46
	15	R$ 295,039.46	R$ 17,702.37	R$ 60,000.00	R$ 252,741.83
	16	R$ 252,741.83	R$ 15,164.51	R$ 60,000.00	R$ 207,906.34
	17	R$ 207,906.34	R$ 12,474.38	R$ 60,000.00	R$ 160,380.72
	18	R$ 160,380.72	R$ 9,622.84	R$ 60,000.00	R$ 110,003.56
	19	R$ 110,003.56	R$ 6,600.21	R$ 60,000.00	R$ 56,603.77
	20	R$ 56,603.77	R$ 3,396.23	R$ 60,000.00	R$ 0.00