Evidencia 2
Evidencia 2
Evidencia 2
Valor Futuro
Datos
A= 25,000.00
i= 10% 0.83% mensual
t= 6 meses
Capitalización mensual
Anualidad Vencida
VF = 26,059.17 25,843.81 25,630.22 25,418.40 25,208.33 25,000.00
VF = 153,159.94
Datos
A= 2,500.00 3,000.00
i= 9% 0.75% mensual
t= 15 años 180 meses
90 meses
Valor Presente
Datos
A= 10,000.00 𝑉P=𝐴(1-(1+𝑖)^-𝑛)/𝑖)
i= 15.0% 1.25% mensual
t= 2 años 24 meses VP = 206,242.35
Capitalización mensual
VP = 206,242.35
A=(VP∗i)/(1-(1+i)^-n))
A= 10,000.00
𝑉𝐹=𝐴(((1+𝑖)^𝑛)−1)/𝑖)
VF = 153,159.94 $153,159.94
I= 3,159.94
𝑉𝐹=𝐴((1+𝑖)^𝑛−1)/𝑖)
VF = 946,014.42 $946,014.42
I= 496,014.42
A=(VF∗i)/((1+i)^n)-1)
A= 2,500.00
𝑉𝐹=𝐴((1+𝑖)^𝑛−1)/𝑖)
VF = 319,697.49
VF = 626,316.94 1,009,953.92
383,636.98
I= 514,953.92
$206,242.35
ACTIVIDADES
Cálcula el monto a recibir y los intereses de un plan de inversión que consiste en realizar
un depósito trimestral de $5,500.00 durante los próximos 20 años, con una tasa de
interés del 13%.
Determina la mejor opción para la venta de una casa, tomando como base una tasa de
interés del 12% anual
Ejercicio 2
Datos
A= $ 6,800.00 𝑉P=𝐴(1-(1+𝑖)^-𝑛)/𝑖)
i= 12.0% 3.00% mensual
t= 2 años 24 meses VP = 115,161.69 $115,161.69
Capitalización mensual
I = 115,161.69
VP = 115,161.69
A=(VP∗i)/(1-(1+i)^-n))
A= 6,800.00
Ejercicio 3
Datos
A= $ 19,000.00
i= 12% 1.00% mensual
t= 2 años 24 meses
VF = 512,495.83
Capitalización mensual
Ejercicio 4
Datos
A= 13,888.89
i= 4% 0.67% mensual
t= 3 años 18 bimestres
VF = 264,683.22
Capitalización mensual
Depósito tota 250,000.02
Ejercicio 5
Datos
A= $ 5,000.00
i= 15% 1.25% mensual
t= 1.5 años 18 meses
VF = 100,230.96
VF(AA)=
Capitalización mensual
𝑉𝐹=𝐴((1+𝑖)^𝑛−1)/𝑖)
VF = 512,495.83 $512,495.83
I= 56,495.83
A=(VF∗i)/((1+i)n)-1)
A= 19,000.00
𝑉𝐹=𝐴((1+𝑖)^𝑛−1)/𝑖)
VF = 264,683.22 $264,683.22
I= 14,683.20
A=(VF∗i)/((1+i)n)-1)
A= 13,888.89
𝑉𝐹=𝐴((1+𝑖)^𝑛−1)/𝑖) VF=A((1+i)^n-1)/i)(1+i)
I= 10,230.96
A=(VF∗i)/((1+i)n)-1)
A= 5,000.00
Amortización con interés global
Datos
VP = 25,000.00
i= 24% 2.00% mensual
n= 10 meses
a= 2,500.00
Amortización constante
Datos
P= 25,000.00
i= 24% 2.00% mensual
n= 10 meses
a= 2,500.00
1 I= =25000*2%*1 500
2 I= =22500*2%*1 450
3 I= =25000*2%*1 400
4 I= =25000*2%*1 350
5 I= =25000*2%*1 300
6 I= =25000*2%*1 250
7 I= =25000*2%*1 200
8 I= =25000*2%*1 150
9 I= =25000*2%*1 100
10 I= =25000*2%*1 50
Amortización gradual
A= Abono mensual
P= 25000
n 10
i= 24% anual
2% mensual
VF = VP * i * t
VF = 30,000.00
Mensualidad = 3,000.00
Tabla de Amortiza
Mes Amortización
0
𝐼=((𝑛∗𝑖)/2)(2P-a(n-1)) 1 2,500.00
2 2,500.00
I= 2,750.00 3 2,500.00
4 2,500.00
Monto = 27,750.00 5 2,500.00
6 2,500.00
Mensualidad = 2,775.00 7 2,500.00
8 2,500.00
9 2,500.00
10 2,500.00
TOTAL 25,000.00
A=(𝑃∗𝑖)/(〖(1−(1+𝑖)〗^(−𝑛)))
Tabla de Amortiza
Mes Amortización
A= $ 2,783.16 0
1 2,283.16
𝑉𝑃=𝐴(1−(1+𝑖)^(−𝑛))/𝑖) 2 2,328.83
3 2,375.40
VP= 13,118.33 4 2,422.91
5 2,471.37
𝐼= C * i * t 6 2,520.80
7 2,571.21
I= 262.37 8 2,622.64
9 2,675.09
10 2,728.59
TOTAL 27,831.63
Tabla de Amortización
25,000.00
500.00 3,000.00 22,500.00
450.00 2,950.00 20,000.00
400.00 2,900.00 17,500.00
350.00 2,850.00 15,000.00
300.00 2,800.00 12,500.00
250.00 2,750.00 10,000.00
200.00 2,700.00 7,500.00
150.00 2,650.00 5,000.00
100.00 2,600.00 2,500.00
50.00 2,550.00 -
2,750.00 27,750.00
2,775.00
Tabla de Amortización
Interés Abono Saldo
Insoluto
25,000.00
500.00 2,783.16 22,716.84
454.34 2,783.16 20,388.01
407.76 2,783.16 18,012.61
360.25 2,783.16 15,589.70
311.79 2,783.16 13,118.33
262.37 2,783.16 10,597.53
211.95 2,783.16 8,026.32
160.53 2,783.16 5,403.68
108.07 2,783.16 2,728.59
54.57 2,783.16 - 0.00
2,831.63 27,831.63
ACTIVIDADES
𝐼= C * i * t
I= 488.19
Ejercicio 2
A= $ 24,736.30 A= $24,736.30
P= $ 350,000.00
n 18 𝑉𝑃=𝐴(1−(1+𝑖)^(−𝑛))/𝑖)
i= 32% anual
3% mensual VP= 251,197.49
𝐼= C * i * t
I= 659.63
Ejercicio 3
Prestamo Personal
Caja de Ahorro
Banco XYZ
A= Abono mensual A=
P= $ 2,500,000.00
n 240
i= 20% anual
2% mensual VP=
Comisión por Apertura= $ 500,000.00
I=
Mensual Anual
13,500,000.00 13,500,000.00
VP * (1 + i * t ) 16,000,000.00 16,000,000.00
VF / (1 + i * t) 2,500,000.00 2,500,000.00
Mensual Anual
15,000,000.00 15,000,000.00
VP * (1 + i * t ) 17,500,000.00 17,500,000.00
VF / (1 + i * t) 2,500,000.00 2,500,000.00
I= 46,875.00
Tabla de Amortización
Quincenas Amortización Interés Abono Saldo Insoluto
0 2,500,000.00
1 6.29 46,875.00 46,881.29 2,499,993.71
2 6.41 46,874.88 46,881.29 2,499,987.31
3 6.53 46,874.76 46,881.29 2,499,980.78
4 6.65 46,874.64 46,881.29 2,499,974.13
5 6.77 46,874.51 46,881.29 2,499,967.36
6 6.90 46,874.39 46,881.29 2,499,960.46
7 7.03 46,874.26 46,881.29 2,499,953.43
8 7.16 46,874.13 46,881.29 2,499,946.26
9 7.30 46,873.99 46,881.29 2,499,938.97
10 7.43 46,873.86 46,881.29 2,499,931.54
11 7.57 46,873.72 46,881.29 2,499,923.96
12 7.71 46,873.57 46,881.29 2,499,916.25
13 7.86 46,873.43 46,881.29 2,499,908.39
14 8.01 46,873.28 46,881.29 2,499,900.38
15 8.16 46,873.13 46,881.29 2,499,892.23
16 8.31 46,872.98 46,881.29 2,499,883.92
17 8.46 46,872.82 46,881.29 2,499,875.45
18 8.62 46,872.66 46,881.29 2,499,866.83
19 8.79 46,872.50 46,881.29 2,499,858.05
20 8.95 46,872.34 46,881.29 2,499,849.10
21 9.12 46,872.17 46,881.29 2,499,839.98
22 9.29 46,872.00 46,881.29 2,499,830.69
23 9.46 46,871.83 46,881.29 2,499,821.23
24 9.64 46,871.65 46,881.29 2,499,811.59
25 9.82 46,871.47 46,881.29 2,499,801.76
26 10.01 46,871.28 46,881.29 2,499,791.76
27 10.19 46,871.10 46,881.29 2,499,781.57
28 10.38 46,870.90 46,881.29 2,499,771.18
29 10.58 46,870.71 46,881.29 2,499,760.60
30 10.78 46,870.51 46,881.29 2,499,749.83
31 10.98 46,870.31 46,881.29 2,499,738.85
32 11.19 46,870.10 46,881.29 2,499,727.66
33 11.39 46,869.89 46,881.29 2,499,716.27
34 11.61 46,869.68 46,881.29 2,499,704.66
35 11.83 46,869.46 46,881.29 2,499,692.83
36 12.05 46,869.24 46,881.29 2,499,680.78
37 12.27 46,869.01 46,881.29 2,499,668.51
38 12.50 46,868.78 46,881.29 2,499,656.01
39 12.74 46,868.55 46,881.29 2,499,643.27
40 12.98 46,868.31 46,881.29 2,499,630.29
41 13.22 46,868.07 46,881.29 2,499,617.07
42 13.47 46,867.82 46,881.29 2,499,603.60
43 13.72 46,867.57 46,881.29 2,499,589.88
44 13.98 46,867.31 46,881.29 2,499,575.90
45 14.24 46,867.05 46,881.29 2,499,561.66
46 14.51 46,866.78 46,881.29 2,499,547.16
47 14.78 46,866.51 46,881.29 2,499,532.38
48 15.06 46,866.23 46,881.29 2,499,517.32
49 15.34 46,865.95 46,881.29 2,499,501.98
50 15.63 46,865.66 46,881.29 2,499,486.36
51 15.92 46,865.37 46,881.29 2,499,470.44
52 16.22 46,865.07 46,881.29 2,499,454.22
53 16.52 46,864.77 46,881.29 2,499,437.70
54 16.83 46,864.46 46,881.29 2,499,420.87
55 17.15 46,864.14 46,881.29 2,499,403.72
56 17.47 46,863.82 46,881.29 2,499,386.25
57 17.80 46,863.49 46,881.29 2,499,368.45
58 18.13 46,863.16 46,881.29 2,499,350.32
59 18.47 46,862.82 46,881.29 2,499,331.85
60 18.82 46,862.47 46,881.29 2,499,313.04
61 19.17 46,862.12 46,881.29 2,499,293.87
62 19.53 46,861.76 46,881.29 2,499,274.34
63 19.89 46,861.39 46,881.29 2,499,254.45
64 20.27 46,861.02 46,881.29 2,499,234.18
65 20.65 46,860.64 46,881.29 2,499,213.53
66 21.03 46,860.25 46,881.29 2,499,192.50
67 21.43 46,859.86 46,881.29 2,499,171.07
68 21.83 46,859.46 46,881.29 2,499,149.24
69 22.24 46,859.05 46,881.29 2,499,127.00
70 22.66 46,858.63 46,881.29 2,499,104.34
71 23.08 46,858.21 46,881.29 2,499,081.26
72 23.51 46,857.77 46,881.29 2,499,057.74
73 23.96 46,857.33 46,881.29 2,499,033.79
74 24.40 46,856.88 46,881.29 2,499,009.38
75 24.86 46,856.43 46,881.29 2,498,984.52
76 25.33 46,855.96 46,881.29 2,498,959.19
77 25.80 46,855.48 46,881.29 2,498,933.39
78 26.29 46,855.00 46,881.29 2,498,907.10
79 26.78 46,854.51 46,881.29 2,498,880.32
80 27.28 46,854.01 46,881.29 2,498,853.04
81 27.79 46,853.49 46,881.29 2,498,825.24
82 28.32 46,852.97 46,881.29 2,498,796.93
83 28.85 46,852.44 46,881.29 2,498,768.08
84 29.39 46,851.90 46,881.29 2,498,738.69
85 29.94 46,851.35 46,881.29 2,498,708.76
86 30.50 46,850.79 46,881.29 2,498,678.26
87 31.07 46,850.22 46,881.29 2,498,647.19
88 31.65 46,849.63 46,881.29 2,498,615.53
89 32.25 46,849.04 46,881.29 2,498,583.28
90 32.85 46,848.44 46,881.29 2,498,550.43
91 33.47 46,847.82 46,881.29 2,498,516.97
92 34.10 46,847.19 46,881.29 2,498,482.87
93 34.73 46,846.55 46,881.29 2,498,448.14
94 35.39 46,845.90 46,881.29 2,498,412.75
95 36.05 46,845.24 46,881.29 2,498,376.70
96 36.73 46,844.56 46,881.29 2,498,339.97
97 37.41 46,843.87 46,881.29 2,498,302.56
98 38.12 46,843.17 46,881.29 2,498,264.45
99 38.83 46,842.46 46,881.29 2,498,225.62
100 39.56 46,841.73 46,881.29 2,498,186.06
101 40.30 46,840.99 46,881.29 2,498,145.76
102 41.06 46,840.23 46,881.29 2,498,104.70
103 41.83 46,839.46 46,881.29 2,498,062.88
104 42.61 46,838.68 46,881.29 2,498,020.27
105 43.41 46,837.88 46,881.29 2,497,976.86
106 44.22 46,837.07 46,881.29 2,497,932.64
107 45.05 46,836.24 46,881.29 2,497,887.59
108 45.90 46,835.39 46,881.29 2,497,841.69
109 46.76 46,834.53 46,881.29 2,497,794.93
110 47.63 46,833.65 46,881.29 2,497,747.30
111 48.53 46,832.76 46,881.29 2,497,698.77
112 49.44 46,831.85 46,881.29 2,497,649.34
113 50.36 46,830.93 46,881.29 2,497,598.97
114 51.31 46,829.98 46,881.29 2,497,547.66
115 52.27 46,829.02 46,881.29 2,497,495.40
116 53.25 46,828.04 46,881.29 2,497,442.15
117 54.25 46,827.04 46,881.29 2,497,387.90
118 55.27 46,826.02 46,881.29 2,497,332.63
119 56.30 46,824.99 46,881.29 2,497,276.33
120 57.36 46,823.93 46,881.29 2,497,218.97
121 58.43 46,822.86 46,881.29 2,497,160.54
122 59.53 46,821.76 46,881.29 2,497,101.01
123 60.64 46,820.64 46,881.29 2,497,040.37
124 61.78 46,819.51 46,881.29 2,496,978.59
125 62.94 46,818.35 46,881.29 2,496,915.65
126 64.12 46,817.17 46,881.29 2,496,851.53
127 65.32 46,815.97 46,881.29 2,496,786.20
128 66.55 46,814.74 46,881.29 2,496,719.66
129 67.79 46,813.49 46,881.29 2,496,651.86
130 69.07 46,812.22 46,881.29 2,496,582.80
131 70.36 46,810.93 46,881.29 2,496,512.44
132 71.68 46,809.61 46,881.29 2,496,440.75
133 73.02 46,808.26 46,881.29 2,496,367.73
134 74.39 46,806.89 46,881.29 2,496,293.34
135 75.79 46,805.50 46,881.29 2,496,217.55
136 77.21 46,804.08 46,881.29 2,496,140.34
137 78.66 46,802.63 46,881.29 2,496,061.68
138 80.13 46,801.16 46,881.29 2,495,981.55
139 81.63 46,799.65 46,881.29 2,495,899.92
140 83.16 46,798.12 46,881.29 2,495,816.75
141 84.72 46,796.56 46,881.29 2,495,732.03
142 86.31 46,794.98 46,881.29 2,495,645.71
143 87.93 46,793.36 46,881.29 2,495,557.78
144 89.58 46,791.71 46,881.29 2,495,468.20
145 91.26 46,790.03 46,881.29 2,495,376.94
146 92.97 46,788.32 46,881.29 2,495,283.97
147 94.71 46,786.57 46,881.29 2,495,189.26
148 96.49 46,784.80 46,881.29 2,495,092.77
149 98.30 46,782.99 46,881.29 2,494,994.47
150 100.14 46,781.15 46,881.29 2,494,894.33
151 102.02 46,779.27 46,881.29 2,494,792.31
152 103.93 46,777.36 46,881.29 2,494,688.37
153 105.88 46,775.41 46,881.29 2,494,582.49
154 107.87 46,773.42 46,881.29 2,494,474.63
155 109.89 46,771.40 46,881.29 2,494,364.74
156 111.95 46,769.34 46,881.29 2,494,252.79
157 114.05 46,767.24 46,881.29 2,494,138.74
158 116.19 46,765.10 46,881.29 2,494,022.55
159 118.37 46,762.92 46,881.29 2,493,904.19
160 120.58 46,760.70 46,881.29 2,493,783.60
161 122.85 46,758.44 46,881.29 2,493,660.76
162 125.15 46,756.14 46,881.29 2,493,535.61
163 127.50 46,753.79 46,881.29 2,493,408.11
164 129.89 46,751.40 46,881.29 2,493,278.22
165 132.32 46,748.97 46,881.29 2,493,145.90
166 134.80 46,746.49 46,881.29 2,493,011.10
167 137.33 46,743.96 46,881.29 2,492,873.77
168 139.91 46,741.38 46,881.29 2,492,733.86
169 142.53 46,738.76 46,881.29 2,492,591.34
170 145.20 46,736.09 46,881.29 2,492,446.14
171 147.92 46,733.37 46,881.29 2,492,298.21
172 150.70 46,730.59 46,881.29 2,492,147.52
173 153.52 46,727.77 46,881.29 2,491,993.99
174 156.40 46,724.89 46,881.29 2,491,837.59
175 159.33 46,721.95 46,881.29 2,491,678.26
176 162.32 46,718.97 46,881.29 2,491,515.94
177 165.36 46,715.92 46,881.29 2,491,350.57
178 168.47 46,712.82 46,881.29 2,491,182.11
179 171.62 46,709.66 46,881.29 2,491,010.48
180 174.84 46,706.45 46,881.29 2,490,835.64
181 178.12 46,703.17 46,881.29 2,490,657.52
182 181.46 46,699.83 46,881.29 2,490,476.06
183 184.86 46,696.43 46,881.29 2,490,291.20
184 188.33 46,692.96 46,881.29 2,490,102.87
185 191.86 46,689.43 46,881.29 2,489,911.01
186 195.46 46,685.83 46,881.29 2,489,715.55
187 199.12 46,682.17 46,881.29 2,489,516.43
188 202.86 46,678.43 46,881.29 2,489,313.58
189 206.66 46,674.63 46,881.29 2,489,106.92
190 210.53 46,670.75 46,881.29 2,488,896.38
191 214.48 46,666.81 46,881.29 2,488,681.90
192 218.50 46,662.79 46,881.29 2,488,463.40
193 222.60 46,658.69 46,881.29 2,488,240.80
194 226.77 46,654.52 46,881.29 2,488,014.03
195 231.03 46,650.26 46,881.29 2,487,783.00
196 235.36 46,645.93 46,881.29 2,487,547.65
197 239.77 46,641.52 46,881.29 2,487,307.88
198 244.27 46,637.02 46,881.29 2,487,063.61
199 248.85 46,632.44 46,881.29 2,486,814.76
200 253.51 46,627.78 46,881.29 2,486,561.25
201 258.26 46,623.02 46,881.29 2,486,302.99
202 263.11 46,618.18 46,881.29 2,486,039.88
203 268.04 46,613.25 46,881.29 2,485,771.84
204 273.07 46,608.22 46,881.29 2,485,498.77
205 278.19 46,603.10 46,881.29 2,485,220.59
206 283.40 46,597.89 46,881.29 2,484,937.18
207 288.72 46,592.57 46,881.29 2,484,648.47
208 294.13 46,587.16 46,881.29 2,484,354.34
209 299.64 46,581.64 46,881.29 2,484,054.69
210 305.26 46,576.03 46,881.29 2,483,749.43
211 310.99 46,570.30 46,881.29 2,483,438.44
212 316.82 46,564.47 46,881.29 2,483,121.63
213 322.76 46,558.53 46,881.29 2,482,798.87
214 328.81 46,552.48 46,881.29 2,482,470.06
215 334.97 46,546.31 46,881.29 2,482,135.08
216 341.26 46,540.03 46,881.29 2,481,793.83
217 347.65 46,533.63 46,881.29 2,481,446.17
218 354.17 46,527.12 46,881.29 2,481,092.00
219 360.81 46,520.48 46,881.29 2,480,731.19
220 367.58 46,513.71 46,881.29 2,480,363.61
221 374.47 46,506.82 46,881.29 2,479,989.14
222 381.49 46,499.80 46,881.29 2,479,607.65
223 388.65 46,492.64 46,881.29 2,479,219.00
224 395.93 46,485.36 46,881.29 2,478,823.07
225 403.36 46,477.93 46,881.29 2,478,419.71
226 410.92 46,470.37 46,881.29 2,478,008.79
227 418.62 46,462.66 46,881.29 2,477,590.17
228 426.47 46,454.82 46,881.29 2,477,163.70
229 434.47 46,446.82 46,881.29 2,476,729.23
230 442.62 46,438.67 46,881.29 2,476,286.61
231 450.91 46,430.37 46,881.29 2,475,835.70
232 459.37 46,421.92 46,881.29 2,475,376.33
233 467.98 46,413.31 46,881.29 2,474,908.35
234 476.76 46,404.53 46,881.29 2,474,431.59
235 485.70 46,395.59 46,881.29 2,473,945.90
236 494.80 46,386.49 46,881.29 2,473,451.09
237 504.08 46,377.21 46,881.29 2,472,947.01
238 513.53 46,367.76 46,881.29 2,472,433.48
239 523.16 46,358.13 46,881.29 2,471,910.32
240 532.97 46,348.32 46,881.29 2,471,377.35
241 542.96 46,338.33 46,881.29 2,470,834.39
242 553.14 46,328.14 46,881.29 2,470,281.24
243 563.52 46,317.77 46,881.29 2,469,717.73
244 574.08 46,307.21 46,881.29 2,469,143.65
245 584.85 46,296.44 46,881.29 2,468,558.80
246 595.81 46,285.48 46,881.29 2,467,962.99
247 606.98 46,274.31 46,881.29 2,467,356.01
248 618.36 46,262.93 46,881.29 2,466,737.65
249 629.96 46,251.33 46,881.29 2,466,107.69
250 641.77 46,239.52 46,881.29 2,465,465.92
251 653.80 46,227.49 46,881.29 2,464,812.12
252 666.06 46,215.23 46,881.29 2,464,146.05
253 678.55 46,202.74 46,881.29 2,463,467.51
254 691.27 46,190.02 46,881.29 2,462,776.23
255 704.23 46,177.05 46,881.29 2,462,072.00
256 717.44 46,163.85 46,881.29 2,461,354.56
257 730.89 46,150.40 46,881.29 2,460,623.67
258 744.59 46,136.69 46,881.29 2,459,879.07
259 758.56 46,122.73 46,881.29 2,459,120.52
260 772.78 46,108.51 46,881.29 2,458,347.74
261 787.27 46,094.02 46,881.29 2,457,560.47
262 802.03 46,079.26 46,881.29 2,456,758.44
263 817.07 46,064.22 46,881.29 2,455,941.37
264 832.39 46,048.90 46,881.29 2,455,108.99
265 847.99 46,033.29 46,881.29 2,454,260.99
266 863.89 46,017.39 46,881.29 2,453,397.10
267 880.09 46,001.20 46,881.29 2,452,517.00
268 896.59 45,984.69 46,881.29 2,451,620.41
269 913.41 45,967.88 46,881.29 2,450,707.00
270 930.53 45,950.76 46,881.29 2,449,776.47
271 947.98 45,933.31 46,881.29 2,448,828.49
272 965.75 45,915.53 46,881.29 2,447,862.74
273 983.86 45,897.43 46,881.29 2,446,878.88
274 1,002.31 45,878.98 46,881.29 2,445,876.57
275 1,021.10 45,860.19 46,881.29 2,444,855.46
276 1,040.25 45,841.04 46,881.29 2,443,815.22
277 1,059.75 45,821.54 46,881.29 2,442,755.46
278 1,079.62 45,801.66 46,881.29 2,441,675.84
279 1,099.87 45,781.42 46,881.29 2,440,575.97
280 1,120.49 45,760.80 46,881.29 2,439,455.48
281 1,141.50 45,739.79 46,881.29 2,438,313.99
282 1,162.90 45,718.39 46,881.29 2,437,151.08
283 1,184.71 45,696.58 46,881.29 2,435,966.38
284 1,206.92 45,674.37 46,881.29 2,434,759.46
285 1,229.55 45,651.74 46,881.29 2,433,529.91
286 1,252.60 45,628.69 46,881.29 2,432,277.31
287 1,276.09 45,605.20 46,881.29 2,431,001.22
288 1,300.02 45,581.27 46,881.29 2,429,701.20
289 1,324.39 45,556.90 46,881.29 2,428,376.81
290 1,349.22 45,532.07 46,881.29 2,427,027.59
291 1,374.52 45,506.77 46,881.29 2,425,653.07
292 1,400.29 45,481.00 46,881.29 2,424,252.78
293 1,426.55 45,454.74 46,881.29 2,422,826.23
294 1,453.30 45,427.99 46,881.29 2,421,372.93
295 1,480.55 45,400.74 46,881.29 2,419,892.38
296 1,508.31 45,372.98 46,881.29 2,418,384.08
297 1,536.59 45,344.70 46,881.29 2,416,847.49
298 1,565.40 45,315.89 46,881.29 2,415,282.09
299 1,594.75 45,286.54 46,881.29 2,413,687.34
300 1,624.65 45,256.64 46,881.29 2,412,062.69
301 1,655.11 45,226.18 46,881.29 2,410,407.58
302 1,686.15 45,195.14 46,881.29 2,408,721.43
303 1,717.76 45,163.53 46,881.29 2,407,003.67
304 1,749.97 45,131.32 46,881.29 2,405,253.70
305 1,782.78 45,098.51 46,881.29 2,403,470.92
306 1,816.21 45,065.08 46,881.29 2,401,654.71
307 1,850.26 45,031.03 46,881.29 2,399,804.45
308 1,884.95 44,996.33 46,881.29 2,397,919.50
309 1,920.30 44,960.99 46,881.29 2,395,999.20
310 1,956.30 44,924.98 46,881.29 2,394,042.89
311 1,992.98 44,888.30 46,881.29 2,392,049.91
312 2,030.35 44,850.94 46,881.29 2,390,019.56
313 2,068.42 44,812.87 46,881.29 2,387,951.14
314 2,107.20 44,774.08 46,881.29 2,385,843.93
315 2,146.71 44,734.57 46,881.29 2,383,697.22
316 2,186.97 44,694.32 46,881.29 2,381,510.25
317 2,227.97 44,653.32 46,881.29 2,379,282.28
318 2,269.75 44,611.54 46,881.29 2,377,012.53
319 2,312.30 44,568.99 46,881.29 2,374,700.23
320 2,355.66 44,525.63 46,881.29 2,372,344.57
321 2,399.83 44,481.46 46,881.29 2,369,944.74
322 2,444.82 44,436.46 46,881.29 2,367,499.92
323 2,490.66 44,390.62 46,881.29 2,365,009.26
324 2,537.36 44,343.92 46,881.29 2,362,471.89
325 2,584.94 44,296.35 46,881.29 2,359,886.95
326 2,633.41 44,247.88 46,881.29 2,357,253.54
327 2,682.78 44,198.50 46,881.29 2,354,570.76
328 2,733.09 44,148.20 46,881.29 2,351,837.67
329 2,784.33 44,096.96 46,881.29 2,349,053.34
330 2,836.54 44,044.75 46,881.29 2,346,216.80
331 2,889.72 43,991.57 46,881.29 2,343,327.08
332 2,943.91 43,937.38 46,881.29 2,340,383.17
333 2,999.10 43,882.18 46,881.29 2,337,384.07
334 3,055.34 43,825.95 46,881.29 2,334,328.73
335 3,112.62 43,768.66 46,881.29 2,331,216.11
336 3,170.99 43,710.30 46,881.29 2,328,045.12
337 3,230.44 43,650.85 46,881.29 2,324,814.68
338 3,291.01 43,590.28 46,881.29 2,321,523.66
339 3,352.72 43,528.57 46,881.29 2,318,170.94
340 3,415.58 43,465.71 46,881.29 2,314,755.36
341 3,479.63 43,401.66 46,881.29 2,311,275.73
342 3,544.87 43,336.42 46,881.29 2,307,730.87
343 3,611.33 43,269.95 46,881.29 2,304,119.53
344 3,679.05 43,202.24 46,881.29 2,300,440.48
345 3,748.03 43,133.26 46,881.29 2,296,692.46
346 3,818.30 43,062.98 46,881.29 2,292,874.15
347 3,889.90 42,991.39 46,881.29 2,288,984.25
348 3,962.83 42,918.45 46,881.29 2,285,021.42
349 4,037.14 42,844.15 46,881.29 2,280,984.28
350 4,112.83 42,768.46 46,881.29 2,276,871.45
351 4,189.95 42,691.34 46,881.29 2,272,681.50
352 4,268.51 42,612.78 46,881.29 2,268,412.99
353 4,348.54 42,532.74 46,881.29 2,264,064.44
354 4,430.08 42,451.21 46,881.29 2,259,634.36
355 4,513.14 42,368.14 46,881.29 2,255,121.22
356 4,597.77 42,283.52 46,881.29 2,250,523.45
357 4,683.97 42,197.31 46,881.29 2,245,839.48
358 4,771.80 42,109.49 46,881.29 2,241,067.68
359 4,861.27 42,020.02 46,881.29 2,236,206.41
360 4,952.42 41,928.87 46,881.29 2,231,254.00
361 5,045.28 41,836.01 46,881.29 2,226,208.72
362 5,139.87 41,741.41 46,881.29 2,221,068.84
363 5,236.25 41,645.04 46,881.29 2,215,832.60
364 5,334.43 41,546.86 46,881.29 2,210,498.17
365 5,434.45 41,446.84 46,881.29 2,205,063.72
366 5,536.34 41,344.94 46,881.29 2,199,527.38
367 5,640.15 41,241.14 46,881.29 2,193,887.23
368 5,745.90 41,135.39 46,881.29 2,188,141.33
369 5,853.64 41,027.65 46,881.29 2,182,287.69
370 5,963.39 40,917.89 46,881.29 2,176,324.29
371 6,075.21 40,806.08 46,881.29 2,170,249.08
372 6,189.12 40,692.17 46,881.29 2,164,059.97
373 6,305.16 40,576.12 46,881.29 2,157,754.80
374 6,423.39 40,457.90 46,881.29 2,151,331.42
375 6,543.82 40,337.46 46,881.29 2,144,787.59
376 6,666.52 40,214.77 46,881.29 2,138,121.07
377 6,791.52 40,089.77 46,881.29 2,131,329.55
378 6,918.86 39,962.43 46,881.29 2,124,410.69
379 7,048.59 39,832.70 46,881.29 2,117,362.11
380 7,180.75 39,700.54 46,881.29 2,110,181.36
381 7,315.39 39,565.90 46,881.29 2,102,865.97
382 7,452.55 39,428.74 46,881.29 2,095,413.42
383 7,592.29 39,289.00 46,881.29 2,087,821.13
384 7,734.64 39,146.65 46,881.29 2,080,086.49
385 7,879.67 39,001.62 46,881.29 2,072,206.82
386 8,027.41 38,853.88 46,881.29 2,064,179.41
387 8,177.92 38,703.36 46,881.29 2,056,001.49
388 8,331.26 38,550.03 46,881.29 2,047,670.23
389 8,487.47 38,393.82 46,881.29 2,039,182.75
390 8,646.61 38,234.68 46,881.29 2,030,536.14
391 8,808.74 38,072.55 46,881.29 2,021,727.41
392 8,973.90 37,907.39 46,881.29 2,012,753.51
393 9,142.16 37,739.13 46,881.29 2,003,611.35
394 9,313.58 37,567.71 46,881.29 1,994,297.77
395 9,488.21 37,393.08 46,881.29 1,984,809.57
396 9,666.11 37,215.18 46,881.29 1,975,143.46
397 9,847.35 37,033.94 46,881.29 1,965,296.11
398 10,031.99 36,849.30 46,881.29 1,955,264.12
399 10,220.09 36,661.20 46,881.29 1,945,044.04
400 10,411.71 36,469.58 46,881.29 1,934,632.32
401 10,606.93 36,274.36 46,881.29 1,924,025.39
402 10,805.81 36,075.48 46,881.29 1,913,219.58
403 11,008.42 35,872.87 46,881.29 1,902,211.16
404 11,214.83 35,666.46 46,881.29 1,890,996.33
405 11,425.11 35,456.18 46,881.29 1,879,571.22
406 11,639.33 35,241.96 46,881.29 1,867,931.89
407 11,857.57 35,023.72 46,881.29 1,856,074.33
408 12,079.89 34,801.39 46,881.29 1,843,994.43
409 12,306.39 34,574.90 46,881.29 1,831,688.04
410 12,537.14 34,344.15 46,881.29 1,819,150.90
411 12,772.21 34,109.08 46,881.29 1,806,378.69
412 13,011.69 33,869.60 46,881.29 1,793,367.01
413 13,255.66 33,625.63 46,881.29 1,780,111.35
414 13,504.20 33,377.09 46,881.29 1,766,607.15
415 13,757.40 33,123.88 46,881.29 1,752,849.74
416 14,015.36 32,865.93 46,881.29 1,738,834.39
417 14,278.14 32,603.14 46,881.29 1,724,556.24
418 14,545.86 32,335.43 46,881.29 1,710,010.39
419 14,818.59 32,062.69 46,881.29 1,695,191.79
420 15,096.44 31,784.85 46,881.29 1,680,095.35
421 15,379.50 31,501.79 46,881.29 1,664,715.85
422 15,667.87 31,213.42 46,881.29 1,649,047.98
423 15,961.64 30,919.65 46,881.29 1,633,086.34
424 16,260.92 30,620.37 46,881.29 1,616,825.42
425 16,565.81 30,315.48 46,881.29 1,600,259.61
426 16,876.42 30,004.87 46,881.29 1,583,383.19
427 17,192.85 29,688.43 46,881.29 1,566,190.34
428 17,515.22 29,366.07 46,881.29 1,548,675.12
429 17,843.63 29,037.66 46,881.29 1,530,831.49
430 18,178.20 28,703.09 46,881.29 1,512,653.29
431 18,519.04 28,362.25 46,881.29 1,494,134.25
432 18,866.27 28,015.02 46,881.29 1,475,267.98
433 19,220.01 27,661.27 46,881.29 1,456,047.97
434 19,580.39 27,300.90 46,881.29 1,436,467.58
435 19,947.52 26,933.77 46,881.29 1,416,520.06
436 20,321.54 26,559.75 46,881.29 1,396,198.52
437 20,702.57 26,178.72 46,881.29 1,375,495.95
438 21,090.74 25,790.55 46,881.29 1,354,405.21
439 21,486.19 25,395.10 46,881.29 1,332,919.02
440 21,889.06 24,992.23 46,881.29 1,311,029.97
441 22,299.48 24,581.81 46,881.29 1,288,730.49
442 22,717.59 24,163.70 46,881.29 1,266,012.90
443 23,143.55 23,737.74 46,881.29 1,242,869.35
444 23,577.49 23,303.80 46,881.29 1,219,291.86
445 24,019.57 22,861.72 46,881.29 1,195,272.30
446 24,469.93 22,411.36 46,881.29 1,170,802.36
447 24,928.74 21,952.54 46,881.29 1,145,873.62
448 25,396.16 21,485.13 46,881.29 1,120,477.46
449 25,872.34 21,008.95 46,881.29 1,094,605.13
450 26,357.44 20,523.85 46,881.29 1,068,247.68
451 26,851.64 20,029.64 46,881.29 1,041,396.04
452 27,355.11 19,526.18 46,881.29 1,014,040.93
453 27,868.02 19,013.27 46,881.29 986,172.91
454 28,390.55 18,490.74 46,881.29 957,782.36
455 28,922.87 17,958.42 46,881.29 928,859.49
456 29,465.17 17,416.12 46,881.29 899,394.32
457 30,017.64 16,863.64 46,881.29 869,376.67
458 30,580.48 16,300.81 46,881.29 838,796.20
459 31,153.86 15,727.43 46,881.29 807,642.34
460 31,737.99 15,143.29 46,881.29 775,904.34
461 32,333.08 14,548.21 46,881.29 743,571.26
462 32,939.33 13,941.96 46,881.29 710,631.93
463 33,556.94 13,324.35 46,881.29 677,074.99
464 34,186.13 12,695.16 46,881.29 642,888.86
465 34,827.12 12,054.17 46,881.29 608,061.74
466 35,480.13 11,401.16 46,881.29 572,581.61
467 36,145.38 10,735.91 46,881.29 536,436.22
468 36,823.11 10,058.18 46,881.29 499,613.12
469 37,513.54 9,367.75 46,881.29 462,099.57
470 38,216.92 8,664.37 46,881.29 423,882.65
471 38,933.49 7,947.80 46,881.29 384,949.16
472 39,663.49 7,217.80 46,881.29 345,285.67
473 40,407.18 6,474.11 46,881.29 304,878.49
474 41,164.82 5,716.47 46,881.29 263,713.67
475 41,936.66 4,944.63 46,881.29 221,777.02
476 42,722.97 4,158.32 46,881.29 179,054.05
477 43,524.03 3,357.26 46,881.29 135,530.02
478 44,340.10 2,541.19 46,881.29 91,189.92
479 45,171.48 1,709.81 46,881.29 46,018.44
480 46,018.44 862.85 46,881.29 0.00
TOTAL 468,812.88 468,744.42 468,812.88
Imagina que obtienes un premio de $1,000,000.00 con el que planeas comprar una casa en un plazo de 1 a 5 años.
- Certificados de gobierno
- Inversión en instituciones financieras
- Acciones
- Criptomonedas
- Moneda extranjera
En tu análisis considera las diferentes variables (tasa, comisiones, periodicidad, requisitos, montos, etc…)
0de%20inversi%C3%B3n.pdf
Ejercicio 1 Valor Futuro (Formula VF) VP
$ 13,500,000.00 $ 2,500,000.00
i Tiempo Abono
1.667% 240 $ 42,470.62
i Tiempo Abono
0.938% 480 $ 23,706.43
0 -$ 6,500,000.00 - 6,500,000.00
1 $ 900,000.00 757,939.49 900,000.00
2 $ 1,012,500.00 718,090.35 1,912,500.00
3 $ 1,139,062.50 680,336.29 3,051,562.50
4 $ 1,281,445.31 644,567.18 4,333,007.81
5 $ 1,441,625.98 610,678.66 5,774,633.79
6 $ 1,621,829.22 578,571.84 7,396,463.01
7 $ 1,824,557.88 548,153.06 9,221,020.89
8 $ 2,052,627.61 519,333.57 11,273,648.50
9 $ 2,309,206.06 492,029.28 13,582,854.56
10 $ 2,597,856.82 466,160.53 16,180,711.38
11 $ 2,922,588.92 441,651.84
12 $ 3,287,912.54 418,431.72
13 $ 3,698,901.61 396,432.41
14 $ 4,161,264.31 375,589.72
15 $ 4,681,422.34 355,842.86
1,503,808.81
2.-
Flujo de
Año Flujo de efectivo efectivo
descontados
0 -$ 6,500,000.00 - 6,500,000.00
1 $ 900,000.00 757,939.49
2 $ 1,012,500.00 718,090.35
3 $ 1,139,062.50 680,336.29
4 $ 1,281,445.31 644,567.18
5 $ 1,441,625.98 610,678.66
6 $ 1,621,829.22 578,571.84
7 $ 1,824,557.88 548,153.06
8 $ 2,052,627.61 519,333.57
9 $ 2,309,206.06 492,029.28
10 $ 2,597,856.82 466,160.53
11 $ 2,922,588.92 441,651.84
12 $ 3,287,912.54 418,431.72
13 $ 3,698,901.61 396,432.41
14 $ 4,161,264.31 375,589.72
15 $ 4,681,422.34 355,842.86
1,503,808.81
3.-
Flujo de
Año Flujo de efectivo efectivo
descontados
0 -$ 6,500,000.00 - 6,500,000.00
1 $ 900,000.00 757,939.49
2 $ 1,012,500.00 718,090.35
3 $ 1,139,062.50 680,336.29
4 $ 1,281,445.31 644,567.18
5 $ 1,441,625.98 610,678.66
6 $ 1,621,829.22 578,571.84
7 $ 1,824,557.88 548,153.06
8 $ 2,052,627.61 519,333.57
9 $ 2,309,206.06 492,029.28
10 $ 2,597,856.82 466,160.53
11 $ 2,922,588.92 441,651.84
12 $ 3,287,912.54 418,431.72
13 $ 3,698,901.61 396,432.41
14 $ 4,161,264.31 375,589.72
15 $ 4,681,422.34 355,842.86
1,503,808.81
4.-
Flujo de
Año Flujo de efectivo efectivo
descontados
0 -$ 6,500,000.00 - 6,500,000.00
1 $ 900,000.00 757,939.49
2 $ 1,012,500.00 718,090.35
3 $ 1,139,062.50 680,336.29
4 $ 1,281,445.31 644,567.18
5 $ 1,441,625.98 610,678.66
6 $ 1,621,829.22 578,571.84
7 $ 1,824,557.88 548,153.06
8 $ 2,052,627.61 519,333.57
9 $ 2,309,206.06 492,029.28
10 $ 2,597,856.82 466,160.53
11 $ 2,922,588.92 441,651.84
12 $ 3,287,912.54 418,431.72
13 $ 3,698,901.61 396,432.41
14 $ 4,161,264.31 375,589.72
15 $ 4,681,422.34 355,842.86
1,503,808.81
Inversión $ 2,500,000.00 CAPM = 36%
Ventas $ 900,000.00 Mejor CAT = 26.78%
Incremento 12.5%
CAPITAL
Weight 0.00%
Costo 36.00%
La opción 1 es la mejor opción a elegir pues p
al WACC y el VPN es positivo en cambio las
WACC 18.74% mayor a su TIR por lo que no vco
VPN 1,503,808.81
TIR 22%
Flujo de efectivo
recuperados
Inversión $ 2,500,000.00
900,000.00 Ventas $ 900,000.00
1,912,500.00 Incremento 12.5%
3,051,562.50
4,333,007.81
5,774,633.79 DEUDA
7,396,463.01 Weight 0.00%
9,221,020.89 Costo 0.00%
11,273,648.50 Tasa impositi 30.00%
13,582,854.56
16,180,711.38 CAPITAL
Weight 100.00%
Costo 36.00%
WACC 36.00%
VPN 1,503,808.81
TIR 22%
Flujo de efectivo
recuperados
Inversión $ 2,500,000.00
900,000.00 Ventas $ 900,000.00
1,912,500.00 Incremento 12.5%
3,051,562.50
4,333,007.81
5,774,633.79 DEUDA
7,396,463.01 Weight 50.00%
9,221,020.89 Costo 0.00%
11,273,648.50 Tasa impositi 30.00%
13,582,854.56
16,180,711.38 CAPITAL
Weight 50.00%
Costo 36.00%
WACC 18.00%
VPN 1,503,808.81
TIR 22%
Flujo de efectivo
recuperados
Inversión $ 2,500,000.00
900,000.00 Ventas $ 900,000.00
1,912,500.00 Incremento 12.5%
3,051,562.50
4,333,007.81
5,774,633.79 DEUDA
7,396,463.01 Weight 80.00%
9,221,020.89 Costo 0.00%
11,273,648.50 Tasa impositi 30.00%
13,582,854.56
16,180,711.38 CAPITAL
Weight 20.00%
Costo 36.00%
WACC 7.20%
VPN 1,503,808.81
TIR 22%
Opción 3 Opción 4
27.37% 22.19%
- 1,388,076.00 96,885.70
22% 22%