Simulador Libre inversión.xlsx

	B	C	D	E	F	G	H
1
2			Prestamo		10.000.000
3			Cuotas		12,00
4			Interes efectivo anual		16,00%	N.M.V	1,24
5			Cuota de Manejo/Seguro de vida		0	Tasa Mensual	1,33
6
7			Detalle de pagos
8			Pago Total		10.827.270
9			Int + Costos Ad		827.270
10					Cuota Fija
11					902.272
12
13		LIBRE INVERSIÓN
14	#	INT ACUM	CUOTA	COSTOS ADICIONALES	INTERESES	ABONO A CAPITAL	SALDO
15	#	INT ACUM	CUOTA	COSTOS ADICIONALES	INTERESES	ABONO A CAPITAL	SALDO
16	1	124.451	902.272	0	124.451	777.821	10.000.000
17	2	239.223	902.272	0	114.771	787.501	9.222.179
18	3	344.193	902.272	0	104.971	797.302	8.434.678
19	4	439.242	902.272	0	95.048	807.224	7.637.376
20	5	524.244	902.272	0	85.002	817.270	6.830.152
21	6	599.075	902.272	0	74.831	827.441	6.012.881
22	7	663.608	902.272	0	64.534	837.739	5.185.440
23	8	717.716	902.272	0	54.108	848.165	4.347.701
24	9	761.268	902.272	0	43.552	858.720	3.499.536
25	10	794.134	902.272	0	32.865	869.407	2.640.816
26	11	816.179	902.272	0	22.045	880.227	1.771.409
27	12	827.270	902.272	0	11.091	891.182	891.182
28	0	0	0	0	0	0	0
29	0	0	0	0	0	0	0
30	0	0	0	0	0	0	0
31	0	0	0	0	0	0	0
32	0	0	0	0	0	0	0
33	0	0	0	0	0	0	0
34	0	0	0	0	0	0	0
35	0	0	0	0	0	0	0
36	0	0	0	0	0	0	0
37	0	0	0	0	0	0	0
38	0	0	0	0	0	0	0
39	0	0	0	0	0	0	0
40	0	0	0	0	0	0	0
41	0	0	0	0	0	0	0
42	0	0	0	0	0	0	0
43	0	0	0	0	0	0	0
44	0	0	0	0	0	0	0
45	0	0	0	0	0	0	0
46	0	0	0	0	0	0	0
47	0	0	0	0	0	0	0
48	0	0	0	0	0	0	0
49	0	0	0	0	0	0	0
50	0	0	0	0	0	0	0
51	0	0	0	0	0	0	0
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