Tabla de amortizacion de creditos

TABLA DE AMORTIZACION DE CREDITOS
CONTIENE LA FORMULACION PARA REALIZAR CUALQUIER TIPO DE CONSULTA EN CREDITOS DE CUALQUIER INDOLE, HASTA 180 MESES.
DATOS DEL CREDITO INGRESE AQUÍ LOS DATOS CONFIRMACION DE LOS DATOS
Importe del préstamo 18.000.000,00 18.000.000,00 Capital
Tipo de interés nominal anual: 15,00% 1,25 Interes mensual
Número de cuotas mesuales: 96 8 Años
DATOS FINALESDEL CREDITO
31009660 Deuda total
18.000.000,00 Total capital
13.009.660,38 Total interes

Liquidación: Cuota fija (intereses + capital) mensual vencida

Cálculo de la cuota mensual: 323017


VALORES DE PRUEBA
PAGO
Cálculo de los intereses cuota nº 1: 225.000,00
Cálculo de los intereses cuota nº 2: 223.774,78
Cálculo delos intereses cuota nº 17: 203.447,02

DATOS DE CARTERA
Periodo Ppal.Inicial Cuota Total Intereses Devoluc.ppal. Ppal.Final
1 18.000.000,00 323.017,30 225.000,00 98.017,30 17.901.982,70
2 17.901.982,70 323.017,30 223.774,78 99.242,51 17.802.740,19
3 17.802.740,19 323.017,30 222.534,25 100.483,04 17.702.257,15
4 17.702.257,15 323.017,30 221.278,21 101.739,08 17.600.518,07
517.600.518,07 323.017,30 220.006,48 103.010,82 17.497.507,25
6 17.497.507,25 323.017,30 218.718,84 104.298,45 17.393.208,79
7 17.393.208,79 323.017,30 217.415,11 105.602,19 17.287.606,61
8 17.287.606,61 323.017,30 216.095,08 106.922,21 17.180.684,39
9 17.180.684,39 323.017,30 214.758,55 108.258,74 17.072.425,65
10 17.072.425,65 323.017,30 213.405,32 109.611,97 16.962.813,68
11 16.962.813,68323.017,30 212.035,17 110.982,12 16.851.831,55
12 16.851.831,55 323.017,30 210.647,89 112.369,40 16.739.462,15
13 16.739.462,15 323.017,30 209.243,28 113.774,02 16.625.688,13
14 16.625.688,13 323.017,30 207.821,10 115.196,19 16.510.491,94
15 16.510.491,94 323.017,30 206.381,15 116.636,15 16.393.855,79
16 16.393.855,79 323.017,30 204.923,20 118.094,10 16.275.761,70
17 16.275.761,70 323.017,30203.447,02 119.570,27 16.156.191,42
18 16.156.191,42 323.017,30 201.952,39 121.064,90 16.035.126,52
19 16.035.126,52 323.017,30 200.439,08 122.578,21 15.912.548,31
20 15.912.548,31 323.017,30 198.906,85 124.110,44 15.788.437,86
21 15.788.437,86 323.017,30 197.355,47 125.661,82 15.662.776,04
22 15.662.776,04 323.017,30 195.784,70 127.232,60 15.535.543,45
23 15.535.543,45 323.017,30194.194,29 128.823,00 15.406.720,44
24 15.406.720,44 323.017,30 192.584,01 130.433,29 15.276.287,15
25 15.276.287,15 323.017,30 190.953,59 132.063,71 15.144.223,45
26 15.144.223,45 323.017,30 189.302,79 133.714,50 15.010.508,95
27 15.010.508,95 323.017,30 187.631,36 135.385,93 14.875.123,01
28 14.875.123,01 323.017,30 185.939,04 137.078,26 14.738.044,75
29 14.738.044,75 323.017,30 184.225,56138.791,74 14.599.253,02
30 14.599.253,02 323.017,30 182.490,66 140.526,63 14.458.726,38
31 14.458.726,38 323.017,30 180.734,08 142.283,22 14.316.443,17
32 14.316.443,17 323.017,30 178.955,54 144.061,76 14.172.381,41
33 14.172.381,41 323.017,30 177.154,77 145.862,53 14.026.518,88
34 14.026.518,88 323.017,30 175.331,49 147.685,81 13.878.833,08
35 13.878.833,08 323.017,30 173.485,41 149.531,8813.729.301,19
36 13.729.301,19 323.017,30 171.616,26 151.401,03 13.577.900,16
37 13.577.900,16 323.017,30 169.723,75 153.293,54 13.424.606,62
38 13.424.606,62 323.017,30 167.807,58 155.209,71 13.269.396,91
39 13.269.396,91 323.017,30 165.867,46 157.149,83 13.112.247,07
40 13.112.247,07 323.017,30 163.903,09 159.114,21 12.953.132,86
41 12.953.132,86 323.017,30 161.914,16 161.103,13 12.792.029,73
4212.792.029,73 323.017,30 159.900,37 163.116,92 12.628.912,81
43 12.628.912,81 323.017,30 157.861,41 165.155,89 12.463.756,92
44 12.463.756,92 323.017,30 155.796,96 167.220,33 12.296.536,59
45 12.296.536,59 323.017,30 153.706,71 169.310,59 12.127.226,00
46 12.127.226,00 323.017,30 151.590,32 171.426,97 11.955.799,03
47 11.955.799,03 323.017,30 149.447,49 173.569,81 11.782.229,22
48...