UA 11 Plan Mat fin Prince

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

Plan1
	Planilha financeira modelo Prince
	Valor do financiamento (PV)	-50,000.00
	Numero de prestações (n)	12
	Taxa de juros (i)	1.00%
	n	Saldo devedor	Amortização 	Juros	Prestação
	0	-50,000.00
	1	-R$ 46,057.56	R$ 3,942.44	-R$ 500.00	R$ 4,442.44
	2	-R$ 42,075.70	R$ 3,981.86	-R$ 460.58	R$ 4,442.44
	3	-R$ 38,054.01	R$ 4,021.68	-R$ 420.76	R$ 4,442.44
	4	-R$ 33,992.11	R$ 4,061.90	-R$ 380.54	R$ 4,442.44
	5	-R$ 29,889.60	R$ 4,102.52	-R$ 339.92	R$ 4,442.44
	6	-R$ 25,746.05	R$ 4,143.54	-R$ 298.90	R$ 4,442.44
	7	-R$ 21,561.07	R$ 4,184.98	-R$ 257.46	R$ 4,442.44	50000
	8	-R$ 17,334.25	R$ 4,226.83	-R$ 215.61	R$ 4,442.44	R$ 32,665.75
	9	-R$ 13,065.15	R$ 4,269.10	-R$ 173.34	R$ 4,442.44
	10	-R$ 8,753.36	R$ 4,311.79	-R$ 130.65	R$ 4,442.44
	11	-R$ 4,398.45	R$ 4,354.91	-R$ 87.53	R$ 4,442.44
	12	-R$ 0.00	R$ 4,398.45	-R$ 43.98	R$ 4,442.44
Plan2
	Planilha financeira modelo Prince
	Valor do financiamento (PV)	-50,000.00
	Numero de prestações (n)	12
	Taxa de juros (i)	1.00%
	n	Saldo devedor	Amortização 	Juros	Prestação
	0	-50,000.00
	1	-R$ 46,057.56	R$ 3,942.44	-R$ 500.00	R$ 4,442.44
	2	-R$ 42,075.70	R$ 3,981.86	-R$ 460.58	R$ 4,442.44
	3	-R$ 38,054.01	R$ 4,021.68	-R$ 420.76	R$ 4,442.44
	4	-R$ 33,992.11	R$ 4,061.90	-R$ 380.54	R$ 4,442.44
	5	-R$ 29,889.60	R$ 4,102.52	-R$ 339.92	R$ 4,442.44
	6	-R$ 25,746.05	R$ 4,143.54	-R$ 298.90	R$ 4,442.44
	7	-R$ 21,561.07	R$ 4,184.98	-R$ 257.46	R$ 4,442.44
	8	-R$ 17,334.25	R$ 4,226.83	-R$ 215.61	R$ 4,442.44
	9	-R$ 13,065.15	R$ 4,269.10	-R$ 173.34	R$ 4,442.44
	10	-R$ 8,753.36	R$ 4,311.79	-R$ 130.65	R$ 4,442.44
	11	-R$ 4,398.45	R$ 4,354.91	-R$ 87.53	R$ 4,442.44
	12	-R$ 0.00	R$ 4,398.45	-R$ 43.98	R$ 4,442.44
Plan3
	Planilha financeira modelo Prince
	Valor do financiamento (PV)	-60,000.00
	Numero de prestações (n)	6
	Taxa de juros (i)	24.00%
	n	Saldo devedor	Amortização 	Juros	Prestação
	0	-60,000.00
	1	-R$ 54,535.55	R$ 5,464.45	-R$ 14,400.00	R$ 19,864.45
	2	-R$ 47,759.63	R$ 6,775.92	-R$ 13,088.53	R$ 19,864.45
	3	-R$ 39,357.50	R$ 8,402.14	-R$ 11,462.31	R$ 19,864.45
	4	-R$ 28,938.84	R$ 10,418.65	-R$ 9,445.80	R$ 19,864.45
	5	-R$ 16,019.72	R$ 12,919.13	-R$ 6,945.32	R$ 19,864.45
	6	R$ 0.00	R$ 16,019.72	-R$ 3,844.73	R$ 19,864.45
Plan4
	Planilha financeira modelo Prince
	Valor do financiamento (PV)	-100,000.00
	Numero de prestações (n)	24
	Taxa de juros (i)	1.00%
	n	Saldo devedor	Amortização 	Juros	Prestação
	0	-100,000.00
	1	-R$ 96,292.65	R$ 3,707.35	-R$ 1,000.00	R$ 4,707.35
	2	-R$ 92,548.23	R$ 3,744.42	-R$ 962.93	R$ 4,707.35
	3	-R$ 88,766.37	R$ 3,781.86	-R$ 925.48	R$ 4,707.35
	4	-R$ 84,946.68	R$ 3,819.68	-R$ 887.66	R$ 4,707.35
	5	-R$ 81,088.80	R$ 3,857.88	-R$ 849.47	R$ 4,707.35
	6	-R$ 77,192.34	R$ 3,896.46	-R$ 810.89	R$ 4,707.35
	7	-R$ 73,256.92	R$ 3,935.42	-R$ 771.92	R$ 4,707.35
	8	-R$ 69,282.14	R$ 3,974.78	-R$ 732.57	R$ 4,707.35
	9	-R$ 65,267.62	R$ 4,014.53	-R$ 692.82	R$ 4,707.35
	10	-R$ 61,212.95	R$ 4,054.67	-R$ 652.68	R$ 4,707.35
	11	-R$ 57,117.73	R$ 4,095.22	-R$ 612.13	R$ 4,707.35
	12	-R$ 52,981.56	R$ 4,136.17	-R$ 571.18	R$ 4,707.35
	13	-R$ 48,804.03	R$ 4,177.53	-R$ 529.82	R$ 4,707.35
	14	-R$ 44,584.72	R$ 4,219.31	-R$ 488.04	R$ 4,707.35
	15	-R$ 40,323.22	R$ 4,261.50	-R$ 445.85	R$ 4,707.35
	16	-R$ 36,019.10	R$ 4,304.12	-R$ 403.23	R$ 4,707.35
	17	-R$ 31,671.95	R$ 4,347.16	-R$ 360.19	R$ 4,707.35
	18	-R$ 27,281.32	R$ 4,390.63	-R$ 316.72	R$ 4,707.35
	19	-R$ 22,846.79	R$ 4,434.53	-R$ 272.81	R$ 4,707.35
	20	-R$ 18,367.91	R$ 4,478.88	-R$ 228.47	R$ 4,707.35
	21	-R$ 13,844.24	R$ 4,523.67	-R$ 183.68	R$ 4,707.35
	22	-R$ 9,275.33	R$ 4,568.90	-R$ 138.44	R$ 4,707.35
	23	-R$ 4,660.74	R$ 4,614.59	-R$ 92.75	R$ 4,707.35
	24	-R$ 0.00	R$ 4,660.74	-R$ 46.61	R$ 4,707.35