MilCo Amortizacion_prestamos

	A	C	D	E	F	G	H
1
2
3			CUADRO DE AMORTIZACIÓN DE PRÉSTAMOS
4
5			importe	100,000		PAGOS TOTALES
6
7			años	20		PRINCIPAL	100,000.00
8
9			comisión de apertura	0.75%		INTERESES	48,616.27
12
13			interés nominal	4.25%		COMISIÓN	750.00
14
15			periodo de pago	12		TOTAL	149,366.27
16
17			tipo amortización	1
18			francés
19
21
22			coste efectivo	4.42%		www.economia-excel.com
23
24		meses	cuota	intereses	amortización	amortizado	pendiente
25	0	0					100,000.00
26	1	1	619.23	354.17	265.07	265.07	99,734.93
27	2	2	619.23	353.23	266.01	531.07	99,468.93
28	3	3	619.23	352.29	266.95	798.02	99,201.98
29	4	4	619.23	351.34	267.89	1,065.92	98,934.08
30	5	5	619.23	350.39	268.84	1,334.76	98,665.24
31	6	6	619.23	349.44	269.80	1,604.56	98,395.44
32	7	7	619.23	348.48	270.75	1,875.31	98,124.69
33	8	8	619.23	347.52	271.71	2,147.02	97,852.98
34	9	9	619.23	346.56	272.67	2,419.69	97,580.31
35	10	10	619.23	345.60	273.64	2,693.32	97,306.68
36	11	11	619.23	344.63	274.61	2,967.93	97,032.07
37	12	12	619.23	343.66	275.58	3,243.51	96,756.49
38	13	13	619.23	342.68	276.56	3,520.07	96,479.93
39	14	14	619.23	341.70	277.53	3,797.60	96,202.40
40	15	15	619.23	340.72	278.52	4,076.12	95,923.88
41	16	16	619.23	339.73	279.50	4,355.62	95,644.38
42	17	17	619.23	338.74	280.49	4,636.12	95,363.88
43	18	18	619.23	337.75	281.49	4,917.60	95,082.40
44	19	19	619.23	336.75	282.48	5,200.09	94,799.91
45	20	20	619.23	335.75	283.48	5,483.57	94,516.43
46	21	21	619.23	334.75	284.49	5,768.06	94,231.94
47	22	22	619.23	333.74	285.50	6,053.56	93,946.44
48	23	23	619.23	332.73	286.51	6,340.07	93,659.93
49	24	24	619.23	331.71	287.52	6,627.59	93,372.41
50	25	25	619.23	330.69	288.54	6,916.13	93,083.87
51	26	26	619.23	329.67	289.56	7,205.69	92,794.31
52	27	27	619.23	328.65	290.59	7,496.28	92,503.72
53	28	28	619.23	327.62	291.62	7,787.90	92,212.10
54	29	29	619.23	326.58	292.65	8,080.55	91,919.45
55	30	30	619.23	325.55	293.69	8,374.23	91,625.77
56	31	31	619.23	324.51	294.73	8,668.96	91,331.04
57	32	32	619.23	323.46	295.77	8,964.73	91,035.27
58	33	33	619.23	322.42	296.82	9,261.55	90,738.45
59	34	34	619.23	321.37	297.87	9,559.42	90,440.58
60	35	35	619.23	320.31	298.92	9,858.34	90,141.66
61	36	36	619.23	319.25	299.98	10,158.32	89,841.68
62	37	37	619.23	318.19	301.05	10,459.37	89,540.63
63	38	38	619.23	317.12	302.11	10,761.48	89,238.52
64	39	39	619.23	316.05	303.18	11,064.66	88,935.34
65	40	40	619.23	314.98	304.26	11,368.92	88,631.08
66	41	41	619.23	313.90	305.33	11,674.25	88,325.75
67	42	42	619.23	312.82	306.41	11,980.66	88,019.34
68	43	43	619.23	311.74	307.50	12,288.16	87,711.84
69	44	44	619.23	310.65	308.59	12,596.75	87,403.25
70	45	45	619.23	309.55	309.68	12,906.43	87,093.57
71	46	46	619.23	308.46	310.78	13,217.21	86,782.79
72	47	47	619.23	307.36	311.88	13,529.09	86,470.91
73	48	48	619.23	306.25	312.98	13,842.07	86,157.93
74	49	49	619.23	305.14	314.09	14,156.16	85,843.84
75	50	50	619.23	304.03	315.20	14,471.37	85,528.63
76	51	51	619.23	302.91	316.32	14,787.69	85,212.31
77	52	52	619.23	301.79	317.44	15,105.13	84,894.87
78	53	53	619.23	300.67	318.57	15,423.69	84,576.31
79	54	54	619.23	299.54	319.69	15,743.39	84,256.61
80	55	55	619.23	298.41	320.83	16,064.21	83,935.79
81	56	56	619.23	297.27	321.96	16,386.18	83,613.82
82	57	57	619.23	296.13	323.10	16,709.28	83,290.72
83	58	58	619.23	294.99	324.25	17,033.52	82,966.48
84	59	59	619.23	293.84	325.39	17,358.92	82,641.08
85	60	60	619.23	292.69	326.55	17,685.47	82,314.53
86	61	61	619.23	291.53	327.70	18,013.17	81,986.83
87	62	62	619.23	290.37	328.86	18,342.03	81,657.97
88	63	63	619.23	289.21	330.03	18,672.06	81,327.94
89	64	64	619.23	288.04	331.20	19,003.26	80,996.74
90	65	65	619.23	286.86	332.37	19,335.63	80,664.37
91	66	66	619.23	285.69	333.55	19,669.18	80,330.82
92	67	67	619.23	284.50	334.73	20,003.91	79,996.09
93	68	68	619.23	283.32	335.91	20,339.83	79,660.17
94	69	69	619.23	282.13	337.10	20,676.93	79,323.07
95	70	70	619.23	280.94	338.30	21,015.23	78,984.77
96	71	71	619.23	279.74	339.50	21,354.73	78,645.27
97	72	72	619.23	278.54	340.70	21,695.42	78,304.58
98	73	73	619.23	277.33	341.91	22,037.33	77,962.67
99	74	74	619.23	276.12	343.12	22,380.45	77,619.55
100	75	75	619.23	274.90	344.33	22,724.78	77,275.22
101	76	76	619.23	273.68	345.55	23,070.33	76,929.67
102	77	77	619.23	272.46	346.78	23,417.11	76,582.89
103	78	78	619.23	271.23	348.00	23,765.11	76,234.89