Tabla de Amortizacion

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

TABLA DE AMORTIZACION COMPRA DE

PRECIO CARRO $ 31,000,000.00


Inicial $ 6,200,000.00
Valor del prestamo: $24,800,000.00
Interes Efectivo Anual(TASA) 13.50%
Años 1
Periodos por años 12
Numero de Pagos 12
Comision 3%
valor del Seguro todo Riesgo 2.00%
Valor de la Cuota $2,220,890.28

Periodos Intereses
1 $279,000.00
2 $257,153.73
3 $235,061.70
4 $212,721.13
5 $190,129.22
6 $167,283.16
7 $144,180.08
8 $120,817.09
9 $97,191.27
10 $73,299.65
11 $49,139.26
12 $24,707.06
13 $0.00
14 $0.00
15 $0.00
16 $0.00
17 $0.00
18 $0.00
19 $0.00
20 $0.00
21 $0.00
22 $0.00
23 $0.00
24 $0.00
25 $0.00
26 $0.00
27 $0.00
28 $0.00
29 $0.00
30 $0.00
31 $0.00
32 $0.00
33 $0.00
34 $0.00
35 $0.00
36 $0.00
37 $0.00
38 $0.00
39 $0.00
40 $0.00
41 $0.00
42 $0.00
43 $0.00
44 $0.00
45 $0.00
46 $0.00
47 $0.00
48 $0.00
49 $0.00
50 $0.00
51 $0.00
52 $0.00
53 $0.00
54 $0.00
55 $0.00
56 $0.00
57 $0.00
58 $0.00
59 $0.00
60 $0.00
61 $0.00
62 $0.00
63 $0.00
64 $0.00
65 $0.00
66 $0.00
67 $0.00
68 $0.00
69 $0.00
70 $0.00
71 $0.00
72 $0.00
73 $0.00
74 $0.00
75 $0.00
76 $0.00
77 $0.00
78 $0.00
79 $0.00
80 $0.00
81 $0.00
82 $0.00
83 $0.00
84 $0.00
85 $0.00
86 $0.00
87 $0.00
88 $0.00
89 $0.00
90 $0.00
91 $0.00
92 $0.00
93 $0.00
94 $0.00
95 $0.00
96 $0.00
97 $0.00
98 $0.00
99 $0.00
100 $0.00
101 $0.00
102 $0.00
103 $0.00
104 $0.00
105 $0.00
106 $0.00
107 $0.00
108 $0.00
109 $0.00
110 $0.00
111 $0.00
112 $0.00
113 $0.00
114 $0.00
115 $0.00
116 $0.00
117 $0.00
118 $0.00
119 $0.00
120 $0.00
121 $0.00
122 $0.00
123 $0.00
124 $0.00
125 $0.00
126 $0.00
127 $0.00
128 $0.00
129 $0.00
130 $0.00
131 $0.00
132 $0.00
133 $0.00
134 $0.00
135 $0.00
136 $0.00
137 $0.00
138 $0.00
139 $0.00
140 $0.00
141 $0.00
142 $0.00
143 $0.00
144 $0.00
145 $0.00
146 $0.00
147 $0.00
148 $0.00
149 $0.00
150 $0.00
151 $0.00
152 $0.00
153 $0.00
154 $0.00
155 $0.00
156 $0.00
157 $0.00
158 $0.00
159 $0.00
160 $0.00
161 $0.00
162 $0.00
163 $0.00
164 $0.00
165 $0.00
166 $0.00
167 $0.00
168 $0.00
169 $0.00
170 $0.00
171 $0.00
172 $0.00
173 $0.00
174 $0.00
175 $0.00
176 $0.00
177 $0.00
178 $0.00
179 $0.00
180 $0.00
TIZACION COMPRA DE VEHICULO
cuota inicial %
20%

Intereses pagados: Suma de cuotas: suma de Comision seguro


$1,850,683.36 $26,650,683.36 $799,520.50 $533,013.67

Amortizacion Valor de la cuota comision seguro


$1,941,890.28 $2,220,890.28 $66,626.71 $44,417.81
$1,963,736.55 $2,220,890.28 $66,626.71 $44,417.81
$1,985,828.58 $2,220,890.28 $66,626.71 $44,417.81
$2,008,169.15 $2,220,890.28 $66,626.71 $44,417.81
$2,030,761.06 $2,220,890.28 $66,626.71 $44,417.81
$2,053,607.12 $2,220,890.28 $66,626.71 $44,417.81
$2,076,710.20 $2,220,890.28 $66,626.71 $44,417.81
$2,100,073.19 $2,220,890.28 $66,626.71 $44,417.81
$2,123,699.01 $2,220,890.28 $66,626.71 $44,417.81
$2,147,590.63 $2,220,890.28 $66,626.71 $44,417.81
$2,171,751.02 $2,220,890.28 $66,626.71 $44,417.81
$2,196,183.22 $2,220,890.28 $66,626.71 $44,417.81
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
calcular valor actual
p $ 30,000,000.00 Monto solicitado -$ 6,000,000.00
n 18 periodo
i 3.00% interes p $ 6,000,000.00
pago $ 2,181,260.88 valor de la cuota n 12
i 3.00%
pago $ 602,772.51
calcular valor actual

escribir el periodo que lleva ejemplo a pagado 16 veces

You might also like