EMPRESTIMO PLANILHA PARA QUEM QUER TER UM CONTROLE DOS EMPRESTIMOS

EMPRESTIMO PLANILHA PARA QUEM QUER TER UM CONTROLE DOS EMPRESTIMOS


DisciplinaContabilidade de Custos17.382 materiais468.468 seguidores
Pré-visualização3 páginas
Tabela de Amortização
		Cálculo de Financiamento
	
					Digite os Valores
			Valor Financiado		R$ 147,000.00
			Taxa de Juros Mensal		0.25%
			Prazo, em Meses (até 360)		360
			Data Inicial (dd/mm/aaaa)		1/1/17
	
	
	
			Pagamento Mensal		R$ 619.76
			Número de Pagamentos		360
			Total de Juros		R$ 76,113.60
			Custo Total do Financiamento		R$ 223,113.60
	
	
		No.	Data do Pagto	Balanço Inicial	Pagto	Principal	Juros	Balanço Final
		1	2/1/17	R$ 147,000.00	R$ 619.76	R$ 252.26	R$ 367.50	R$ 146,747.74
		2	3/1/17	146,747.74	619.76	252.89	366.87	146,494.85
		3	4/1/17	146,494.85	619.76	253.52	366.24	146,241.33
		4	5/1/17	146,241.33	619.76	254.15	365.60	145,987.18
		5	6/1/17	145,987.18	619.76	254.79	364.97	145,732.39
		6	7/1/17	145,732.39	619.76	255.43	364.33	145,476.96
		7	8/1/17	145,476.96	619.76	256.07	363.69	145,220.90
		8	9/1/17	145,220.90	619.76	256.71	363.05	144,964.19
		9	10/1/17	144,964.19	619.76	257.35	362.41	144,706.84
		10	11/1/17	144,706.84	619.76	257.99	361.77	144,448.85
		11	12/1/17	144,448.85	619.76	258.64	361.12	144,190.22
		12	1/1/18	144,190.22	619.76	259.28	360.48	143,930.93
		13	2/1/18	143,930.93	619.76	259.93	359.83	143,671.00
		14	3/1/18	143,671.00	619.76	260.58	359.18	143,410.42
		15	4/1/18	143,410.42	619.76	261.23	358.53	143,149.19
		16	5/1/18	143,149.19	619.76	261.88	357.87	142,887.31
		17	6/1/18	142,887.31	619.76	262.54	357.22	142,624.77
		18	7/1/18	142,624.77	619.76	263.20	356.56	142,361.57
		19	8/1/18	142,361.57	619.76	263.85	355.90	142,097.72
		20	9/1/18	142,097.72	619.76	264.51	355.24	141,833.20
		21	10/1/18	141,833.20	619.76	265.17	354.58	141,568.03
		22	11/1/18	141,568.03	619.76	265.84	353.92	141,302.19
		23	12/1/18	141,302.19	619.76	266.50	353.26	141,035.69
		24	1/1/19	141,035.69	619.76	267.17	352.59	140,768.52
		25	2/1/19	140,768.52	619.76	267.84	351.92	140,500.68
		26	3/1/19	140,500.68	619.76	268.51	351.25	140,232.18
		27	4/1/19	140,232.18	619.76	269.18	350.58	139,963.00
		28	5/1/19	139,963.00	619.76	269.85	349.91	139,693.15
		29	6/1/19	139,693.15	619.76	270.53	349.23	139,422.62
		30	7/1/19	139,422.62	619.76	271.20	348.56	139,151.42
		31	8/1/19	139,151.42	619.76	271.88	347.88	138,879.54
		32	9/1/19	138,879.54	619.76	272.56	347.20	138,606.98
		33	10/1/19	138,606.98	619.76	273.24	346.52	138,333.74
		34	11/1/19	138,333.74	619.76	273.92	345.83	138,059.82
		35	12/1/19	138,059.82	619.76	274.61	345.15	137,785.21
		36	1/1/20	137,785.21	619.76	275.29	344.46	137,509.92
		37	2/1/20	137,509.92	619.76	275.98	343.77	137,233.93
		38	3/1/20	137,233.93	619.76	276.67	343.08	136,957.26
		39	4/1/20	136,957.26	619.76	277.36	342.39	136,679.89
		40	5/1/20	136,679.89	619.76	278.06	341.70	136,401.84
		41	6/1/20	136,401.84	619.76	278.75	341.00	136,123.08
		42	7/1/20	136,123.08	619.76	279.45	340.31	135,843.63
		43	8/1/20	135,843.63	619.76	280.15	339.61	135,563.48
		44	9/1/20	135,563.48	619.76	280.85	338.91	135,282.63
		45	10/1/20	135,282.63	619.76	281.55	338.21	135,001.08
		46	11/1/20	135,001.08	619.76	282.26	337.50	134,718.83
		47	12/1/20	134,718.83	619.76	282.96	336.80	134,435.87
		48	1/1/21	134,435.87	619.76	283.67	336.09	134,152.20
		49	2/1/21	134,152.20	619.76	284.38	335.38	133,867.82
		50	3/1/21	133,867.82	619.76	285.09	334.67	133,582.73
		51	4/1/21	133,582.73	619.76	285.80	333.96	133,296.93
		52	5/1/21	133,296.93	619.76	286.52	333.24	133,010.42
		53	6/1/21	133,010.42	619.76	287.23	332.53	132,723.18
		54	7/1/21	132,723.18	619.76	287.95	331.81	132,435.23
		55	8/1/21	132,435.23	619.76	288.67	331.09	132,146.56
		56	9/1/21	132,146.56	619.76	289.39	330.37	131,857.17
		57	10/1/21	131,857.17	619.76	290.11	329.64	131,567.06
		58	11/1/21	131,567.06	619.76	290.84	328.92	131,276.22
		59	12/1/21	131,276.22	619.76	291.57	328.19	130,984.65
		60	1/1/22	130,984.65	619.76	292.30	327.46	130,692.35
		61	2/1/22	130,692.35	619.76	293.03	326.73	130,399.33
		62	3/1/22	130,399.33	619.76	293.76	326.00	130,105.57
		63	4/1/22	130,105.57	619.76	294.49	325.26	129,811.07
		64	5/1/22	129,811.07	619.76	295.23	324.53	129,515.84
		65	6/1/22	129,515.84	619.76	295.97	323.79	129,219.87
		66	7/1/22	129,219.87	619.76	296.71	323.05	128,923.17
		67	8/1/22	128,923.17	619.76	297.45	322.31	128,625.72
		68	9/1/22	128,625.72	619.76	298.19	321.56	128,327.52
		69	10/1/22	128,327.52	619.76	298.94	320.82	128,028.58
		70	11/1/22	128,028.58	619.76	299.69	320.07	127,728.90
		71	12/1/22	127,728.90	619.76	300.44	319.32	127,428.46
		72	1/1/23	127,428.46	619.76	301.19	318.57	127,127.27
		73	2/1/23	127,127.27	619.76	301.94	317.82	126,825.34
		74	3/1/23	126,825.34	619.76	302.69	317.06	126,522.64
		75	4/1/23	126,522.64	619.76	303.45	316.31	126,219.19
		76	5/1/23	126,219.19	619.76	304.21	315.55	125,914.98
		77	6/1/23	125,914.98	619.76	304.97	314.79	125,610.01
		78	7/1/23	125,610.01	619.76	305.73	314.03	125,304.28
		79	8/1/23	125,304.28	619.76	306.50	313.26	124,997.78
		80	9/1/23	124,997.78	619.76	307.26	312.49	124,690.52
		81	10/1/23	124,690.52	619.76	308.03	311.73	124,382.48
		82	11/1/23	124,382.48	619.76	308.80	310.96	124,073.68
		83	12/1/23	124,073.68	619.76	309.57	310.18	123,764.11
		84	1/1/24	123,764.11	619.76	310.35	309.41	123,453.76
		85	2/1/24	123,453.76	619.76	311.12	308.63	123,142.64
		86	3/1/24	123,142.64	619.76	311.90	307.86	122,830.74
		87	4/1/24	122,830.74	619.76	312.68	307.08	122,518.05
		88	5/1/24	122,518.05	619.76	313.46	306.30	122,204.59
		89	6/1/24	122,204.59	619.76	314.25	305.51	121,890.35
		90	7/1/24	121,890.35	619.76	315.03	304.73	121,575.31
		91	8/1/24	121,575.31	619.76	315.82	303.94	121,259.49
		92	9/1/24	121,259.49	619.76	316.61	303.15	120,942.88
		93	10/1/24	120,942.88	619.76	317.40	302.36	120,625.48
		94	11/1/24	120,625.48	619.76	318.19	301.56	120,307.29
		95	12/1/24	120,307.29	619.76	318.99	300.77	119,988.30
		96	1/1/25	119,988.30	619.76	319.79	299.97	119,668.51
		97	2/1/25	119,668.51	619.76	320.59	299.17	119,347.93
		98	3/1/25	119,347.93	619.76	321.39	298.37	119,026.54
		99	4/1/25	119,026.54	619.76	322.19	297.57	118,704.35
		100	5/1/25	118,704.35	619.76	323.00	296.76	118,381.35
		101	6/1/25	118,381.35	619.76	323.80	295.95	118,057.54
		102	7/1/25	118,057.54	619.76	324.61	295.14	117,732.93
		103	8/1/25	117,732.93	619.76	325.43	294.33	117,407.50
		104	9/1/25	117,407.50	619.76	326.24	293.52	117,081.27
		105	10/1/25	117,081.27	619.76	327.05	292.70	116,754.21
		106	11/1/25	116,754.21	619.76	327.87	291.89	116,426.34
		107	12/1/25	116,426.34	619.76	328.69	291.07	116,097.65
		108	1/1/26	116,097.65	619.76	329.51	290.24	115,768.13
		109	2/1/26	115,768.13	619.76	330.34	289.42	115,437.80
		110	3/1/26	115,437.80	619.76	331.16	288.59	115,106.63
		111	4/1/26	115,106.63	619.76	331.99	287.77	114,774.64
		112	5/1/26	114,774.64	619.76	332.82	286.94	114,441.82
		113	6/1/26	114,441.82	619.76	333.65	286.10	114,108.17
		114	7/1/26	114,108.17	619.76	334.49	285.27	113,773.68
		115	8/1/26	113,773.68	619.76	335.32	284.43	113,438.35
		116	9/1/26	113,438.35	619.76	336.16	283.60	113,102.19
		117	10/1/26	113,102.19	619.76	337.00	282.76	112,765.19
		118	11/1/26	112,765.19	619.76	337.84	281.91	112,427.34
		119	12/1/26	112,427.34	619.76	338.69	281.07	112,088.66
		120	1/1/27	112,088.66	619.76	339.54	280.22	111,749.12
		121	2/1/27	111,749.12	619.76	340.39	279.37	111,408.73
		122	3/1/27	111,408.73	619.76	341.24	278.52	111,067.50
		123	4/1/27	111,067.50	619.76	342.09	277.67	110,725.41
		124	5/1/27	110,725.41	619.76	342.94	276.81	110,382.46
		125	6/1/27	110,382.46	619.76	343.80	275.96	110,038.66
		126	7/1/27	110,038.66	619.76	344.66	275.10	109,694.00
		127	8/1/27	109,694.00	619.76	345.52	274.24	109,348.48
		128	9/1/27	109,348.48	619.76	346.39	273.37	109,002.09
		129	10/1/27	109,002.09	619.76	347.25	272.51	108,654.84
		130	11/1/27	108,654.84	619.76	348.12	271.64	108,306.72
		131	12/1/27	108,306.72	619.76	348.99	270.77	107,957.73
		132	1/1/28	107,957.73	619.76	349.86	269.89	107,607.86
		133	2/1/28	107,607.86	619.76	350.74	269.02	107,257.12
		134	3/1/28	107,257.12	619.76	351.62	268.14	106,905.51
		135	4/1/28	106,905.51