ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Interes Compuesto
2
Información calculadoraEscenarios inversión al largo plazo
3
4
INSTRUCCIONES: HAZ TU COPIA DE ESTE ARCHIVO E INGRESA UNICAMENTE LOS CAMPOS EN VERDE
5
EdadPeriodoTipoSaldo inicialEntradasSalidasNeto (D-N)InteresesFinalContribución
6
Edad36361Acumulación 1,000,000.00 360,000.00 - 360,000.00 129,200.000 1,489,200.000 1,360,000.00
7
Plazo Inversión30372Acumulación 1,489,200.000 360000 - 360,000.00 175,674.000 2,024,874.000 1,720,000.00
8
CapitalizaciónAnual383Acumulación 2,024,874.000 360000 - 360,000.00 226,563.030 2,611,437.030 2,080,000.00
9
Monto inicial $ 1,000,000.00 394Acumulación 2,611,437.030 360000 - 360,000.00 282,286.518 3,253,723.548 2,440,000.00
10
405Acumulación 3,253,723.548 360000 - 360,000.00 343,303.737 3,957,027.285 2,800,000.00
11
 Contribuciones416Acumulación 3,957,027.285 360000 - 360,000.00 410,117.592 4,727,144.877 3,160,000.00
12
Mensuales $ 30,000.00 427Acumulación 4,727,144.877 360000 - 360,000.00 483,278.763 5,570,423.640 3,520,000.00
13
Anuales $ 360,000.00 438Acumulación 5,570,423.640 360000 - 360,000.00 563,390.246 6,493,813.886 3,880,000.00
14
% Cumplimiento100%449Acumulación 6,493,813.886 360000 - 360,000.00 651,112.319 7,504,926.205 4,240,000.00
15
Incrementa con inflaciónNo4510Acumulación 7,504,926.205 360000 - 360,000.00 747,167.990 8,612,094.195 4,600,000.00
16
4611Acumulación 8,612,094.195 360000 - 360,000.00 852,348.949 9,824,443.143 4,960,000.00
17
Inflación4.50%4712Acumulación 9,824,443.143 360000 - 360,000.00 967,522.099 11,151,965.242 5,320,000.00
18
Tasa Real5.00%4813Acumulación 11,151,965.242 360000 - 360,000.00 1,093,636.698 12,605,601.940 5,680,000.00
19
Retorno total9.50%4914Acumulación 12,605,601.940 360000 - 360,000.00 1,231,732.184 14,197,334.124 6,040,000.00
20
5015Acumulación 14,197,334.124 360000 - 360,000.00 1,382,946.742 15,940,280.866 6,400,000.00
21
 Escenarios5116Acumulación 15,940,280.866 360000 - 360,000.00 1,548,526.682 17,848,807.548 6,760,000.00
22
5217Acumulación 17,848,807.548 360000 - 360,000.00 1,729,836.717 19,938,644.265 7,120,000.00
23
Retorno totalValor final5318Acumulación 19,938,644.265 360000 - 360,000.00 1,928,371.205 22,227,015.471 7,480,000.00
24
10.00%$76,667,250.445419Acumulación 22,227,015.471 360000 - 360,000.00 2,145,766.470 24,732,781.940 7,840,000.00
25
9.00%$62,338,392.355520Acumulación 24,732,781.940 360000 - 360,000.00 2,383,814.284 27,476,596.225 8,200,000.00
26
7.00%$41,618,138.125621Acumulación 27,476,596.225 360000 - 360,000.00 2,644,476.641 30,481,072.866 8,560,000.00
27
5722Acumulación 30,481,072.866 360000 - 360,000.00 2,929,901.922 33,770,974.788 8,920,000.00
28
5823Acumulación 33,770,974.788 360000 - 360,000.00 3,242,442.605 37,373,417.393 9,280,000.00
29
15924Acumulación 37,373,417.393 360000 - 360,000.00 3,584,674.652 41,318,092.045 9,640,000.00
30
26025Acumulación 41,318,092.045 360000 - 360,000.00 3,959,418.744 45,637,510.790 10,000,000.00
31
36126Acumulación 45,637,510.790 360000 - 360,000.00 4,369,763.525 50,367,274.315 10,360,000.00
32
6227Acumulación 50,367,274.315 360000 - 360,000.00 4,819,091.060 55,546,365.375 10,720,000.00
33
6328Acumulación 55,546,365.375 360000 - 360,000.00 5,311,104.711 61,217,470.085 11,080,000.00
34
6429Acumulación 61,217,470.085 360000 - 360,000.00 5,849,859.658 67,427,329.743 11,440,000.00
35
6530Acumulación 67,427,329.743 360000 - 360,000.00 6,439,796.326 74,227,126.069 11,800,000.00
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