Amortización de capital

	A	B	C	D	E	F	G
1	PANEL DE CONTROL
2	A pagar	97000	€
3	i	0.055	anual
4	n	15	años
5
6	Cuota anual	9663.682968	€/año
7
8		TABLA DE AMORTIZACIONES
9		Años	Deuda pendiente	i * (deuda pendiente)	Amortización	Cuota	Deuda después del pago
10		1	97000.00	5335.00	4328.68	9663.68	92671.32
11		2	92671.32	5096.92	4566.76	9663.68	88104.56
12		3	88104.56	4845.75	4817.93	9663.68	83286.62
13		4	83286.62	4580.76	5082.92	9663.68	78203.71
14		5	78203.71	4301.20	5362.48	9663.68	72841.23
15		6	72841.23	4006.27	5657.42	9663.68	67183.81
16		7	67183.81	3695.11	5968.57	9663.68	61215.24
17		8	61215.24	3366.84	6296.84	9663.68	54918.39
18		9	54918.39	3020.51	6643.17	9663.68	48275.22
19		10	48275.22	2655.14	7008.55	9663.68	41266.68
20		11	41266.68	2269.67	7394.02	9663.68	33872.66
21		12	33872.66	1863.00	7800.69	9663.68	26071.97
22		13	26071.97	1433.96	8229.72	9663.68	17842.25
23		14	17842.25	981.32	8682.36	9663.68	9159.89
24		15	9159.89	503.79	9159.89	9663.68	0.00
25
26		Totales		47955.24	97000.00	144955.24
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100