| Partida |
Mes 1 |
Mes 2 |
Mes 3 |
Mes 4 |
Mes 5 |
Mes 6 |
Mes 7 |
Mes 8 |
Mes 9 |
Mes 10 |
Mes 11 |
Mes 12 |
Mes 13 |
Mes 14 |
Mes 15 |
Mes 16 |
Mes 17 |
Mes 18 |
Totales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Compra
Terreno |
105.000.000 |
|
|
|
|
|
|
|
|
|
|
|
|
105.000.000 |
|
| Permisología |
187.732.000 |
|
|
|
|
|
|
|
|
|
|
|
|
187.732.000 |
|
| Movimiento de Tierra |
|
164.884.367,54 |
164.884.367,54 |
|
|
|
|
|
|
|
|
|
|
329.768.735 |
|
| Sistema
Drenaje |
|
|
|
67.844.959,57 |
|
|
|
|
|
|
|
|
|
67.844.960 |
|
| Sistema
Agua Potable |
|
|
|
18.967.425,47 |
18.967.425,47 |
|
|
|
|
|
|
|
|
37.934.851 |
|
| Instalación
Eléctrica |
|
|
|
12.915.897,01 |
12.915.897,01 |
12.915.897,01 |
12.915.897,01 |
|
|
|
|
|
|
51.663.588 |
|
| Pavimentos
y Señalización |
|
|
|
|
|
63.040.572,59 |
63.040.572,59 |
|
|
|
|
|
|
126.081.145 |
|
| Diversos |
|
|
11.543.208,40 |
11.543.208,40 |
11.543.208,40 |
11.543.208,40 |
11.543.208,40 |
|
|
|
|
|
|
57.716.042 |
|
| Obras
Preliminares |
|
|
|
|
|
86.220.610 |
|
|
|
|
|
|
|
86.220.610 |
|
| Losas y
Estructuras |
|
|
|
|
|
|
190.638.934 |
190.638.934 |
190.638.934 |
190.638.934 |
190.638.934 |
|
|
953.194.670 |
|
| Albañilería |
|
|
|
24.495.339,61 |
24.495.339,61 |
|
171.229.363,50 |
285.382.272,50 |
285.382.272,50 |
285.382.272,50 |
114.152.909 |
|
|
1.190.519.769 |
|
| Carpintería
y Herrería |
|
|
|
|
|
|
|
31.706.934 |
31.706.934 |
31.706.934 |
31.706.934 |
31.706.934 |
|
158.534.670 |
|
| Techos
y Acabados |
|
|
|
|
|
|
|
204.307.086 |
204.307.086 |
204.307.086 |
204.307.086 |
204.307.086 |
|
1.021.535.430 |
|
| Inst.
Hidráulicas y Sanitarias |
|
|
|
|
|
|
|
122.457.106 |
122.457.106 |
122.457.106 |
122.457.106 |
122.457.106 |
|
612.285.530 |
|
| Gastos
Administrativos |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total
Gastos |
292.732.000 |
164.884.367,54 |
176.427.575,94 |
135.766.830,06 |
67.921.870,49 |
173.720.288 |
449.367.975,50 |
834.492.332,50 |
834.492.332,50 |
834.492.332,50 |
663.262.969,00 |
358.471.126,00 |
|
4.986.032.000,03 |
|
| Total
gastos real |
|
140.151.712,41 |
149.963.439,55 |
115.401.805,55 |
57.733.589,92 |
147.662.244,80 |
381.962.779,18 |
709.318.482,63 |
709.318.482,63 |
709.318.482,63 |
563.773.523,65 |
304.700.457,10 |
|
3.989.305.000,03 |
|
| Ganancia |
|
24.732.655,13 |
26.464.136,39 |
20.365.024,51 |
10.188.280,57 |
26.058.043,20 |
67.405.196,33 |
125.173.849,88 |
125.173.849,88 |
125.173.849,88 |
99.489.445,35 |
53.770.668,90 |
|
703.995.000 |
|
| Aporte
BANAVIH |
|
211.198.500 |
|
|
|
|
|
716.225.025 |
1.193.708.375 |
1.193.708.375 |
1.193.708.375 |
477.483.350 |
|
4.986.032.000 |
|
| Aporte
Institución Financiera |
|
492.796.500 |
164.884.367,54 |
176.427.575,94 |
135.766.830,03 |
67.921.870,49 |
173.720.288,00 |
37.478.212,00 |
|
|
|
|
|
1.248.995.644 |
|
| Pago
del credito |
|
|
|
|
|
|
|
(187.349.346,6) |
(312.248.911) |
(312.248.911) |
(312.248.911) |
(124.899.564,40) |
|
(1.248.995.644,0) |
|
| Pago
Interes |
|
|
|
|
|
|
|
|
|
|
|
(48.506.586,71) |
|
(48.506.586,7) |
|
| ISLR |
|
|
|
|
|
|
|
|
|
|
|
(5.899.395,72) |
|
(5.899.395,7) |
|
| Total
Ingresos |
-292.732.000 |
703.995.000 |
164.884.368 |
176.427.576 |
135.766.830 |
67.921.870,49 |
173.720.288,00 |
566.353.890,40 |
881.459.464,00 |
881.459.464,00 |
881.459.464,00 |
298.177.803,17 |
|
4.638.894.018 |
|
| Flujo
de efectivo |
0 |
563.843.288 |
14.920.928 |
61.025.770 |
78.033.240 |
-79.740.374 |
-208.242.491 |
-142.964.592 |
172.140.981 |
172.140.981 |
317.685.940 |
-6.522.654 |
|
649.589.017,55 |
|
| |
Mes 1 |
Mes 2 |
Mes 3 |
Mes 4 |
Mes 5 |
Mes 6 |
Mes 7 |
Mes 8 |
Mes 9 |
Mes 10 |
Mes 11 |
Mes 12 |
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
Tabla de Intereses |
|
|
|
|
|
|
|
|
|
|
Aporte Banavih |
Aporte Inst. Finan. |
Egresos |
Prestamo |
Abono Prestamo |
Saldo Prestamo |
Interes Prestamo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 1 |
|
292.732.000,00 |
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 2 |
211.198.500,00 |
492.796.500,00 |
164.884.367,54 |
703.995.000,00 |
|
492.796.500,00 |
4.223.970,00 |
|
|
|
|
|
|
|
| Mes 3 |
|
164.884.367,54 |
176.427.575,94 |
164.884.367,54 |
|
657.680.867,54 |
3.946.085,21 |
|
|
|
- |
|
|
|
| Mes 4 |
|
176.427.575,94 |
135.766.830,06 |
176.427.575,94 |
|
834.108.443,48 |
5.004.650,66 |
|
|
|
- |
|
|
|
| Mes 5 |
|
135.766.830,03 |
67.921.870,49 |
135.766.830,03 |
|
969.875.273,51 |
5.819.251,64 |
|
|
|
- |
|
|
|
| Mes 6 |
|
67.921.870,49 |
173.720.288,00 |
67.921.870,49 |
|
1.037.797.144,00 |
6.226.782,86 |
|
|
|
- |
|
|
|
| Mes 7 |
|
173.720.288,00 |
449.367.975,50 |
173.720.288,00 |
|
1.211.517.432,00 |
7.269.104,59 |
|
|
|
- |
|
|
|
| Mes 8 |
477.483.350,00 |
37.478.212,00 |
834.492.332,50 |
514.961.562,00 |
|
1.248.995.644,00 |
7.493.973,86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 9 |
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
1.201.247.309,00 |
7.207.483,85 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 10 |
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
1.153.498.974,00 |
6.920.993,84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 11 |
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
1.105.750.639,00 |
6.634.503,83 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 12 |
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
1.058.002.304,00 |
6.348.013,82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 13 |
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
1.010.253.969,00 |
6.061.523,81 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
477.483.350,00 |
|
429.735.015,00 |
|
47.748.335,00 |
962.505.634,00 |
5.775.033,80 |
|
|
|
| Mes 14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 15 |
477.483.350,00 |
|
112.308.669,97 |
|
365.174.680,03 |
597.330.953,97 |
3.583.985,72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 16 |
477.483.350,00 |
|
477.483.350,00 |
119.847.603,97 |
719.085,62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 17 |
477.483.350,00 |
|
119.847.603,97 |
-
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Aporte |
#¡REF! |
|
|
|
|
|
|
Anticipo |
545.000.000 |
|
| Mes 18 |
|
|
|
|
|
Saldo |
#¡REF! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Aporte |
#¡REF! |
|
|
|
|
|
|
|
Anticipo |
545.000.000 |
|
|
|
|
|
|
|
Saldo |
#¡REF! |
|
| Total Aportes |
4.986.032.000,00 |
1.248.995.644,00 |
4.986.032.000,00 |
|
1.248.995.644,00 |
- |
83.234.443,15 |
|
|
|
|
|
|
|
|
|
|
|
Totales Interes |
|
|
Aporte |
#¡REF! |
|
|
|
Tabla de Intereses |
|
|
|
|
|
|
|
|
|
|
Aporte Banavih |
Aporte Inst. Finan. |
Egresos |
Egresos Real |
Prestamo |
Flujo de efectivo |
Abono Prestamo |
Saldo Prestamo |
Interes Prestamo |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 1 |
|
292.732.000,00 |
292.732.000,00 |
|
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 2 |
211.198.500,00 |
492.796.500,00 |
164.884.367,54 |
140.151.712,41 |
492.796.500,00 |
352.644.787,59 |
|
492.796.500,00 |
4.223.970,00 |
|
|
|
|
|
|
|
|
|
|
|
| Mes 3 |
|
164.884.367,54 |
176.427.575,94 |
149.963.439,55 |
164.884.367,54 |
14.920.927,99 |
|
657.680.867,54 |
3.946.085,21 |
|
|
|
Anticipo |
545.000.000 |
|
|
|
|
- |
|
|
|
|
Saldo |
#¡REF! |
|
| Mes 4 |
|
176.427.575,94 |
135.766.830,06 |
115.401.805,55 |
176.427.575,94 |
61.025.770,39 |
|
834.108.443,48 |
5.004.650,66 |
|
|
|
|
|
|
- |
|
|
|
|
Aporte |
#¡REF! |
|
| Mes 5 |
|
135.766.830,03 |
67.921.870,49 |
57.733.589,92 |
135.766.830,03 |
78.033.240,11 |
|
969.875.273,51 |
5.819.251,64 |
|
Anticipo |
545.000.000 |
|
|
|
|
- |
|
|
|
|
Saldo |
#¡REF! |
|
| Mes 6 |
|
67.921.870,49 |
173.720.288,00 |
147.662.244,80 |
67.921.870,49 |
(79.740.374,31) |
|
1.037.797.144,00 |
6.226.782,86 |
|
|
|
|
|
|
|
- |
|
|
|
|
| Mes 7 |
|
173.720.288,00 |
449.367.975,50 |
381.962.779,18 |
173.720.288,00 |
(208.242.491,18) |
|
1.211.517.432,00 |
7.269.104,59 |
|
|
|
|
- |
|
|
|
|
| Mes 8 |
477.483.350,00 |
37.478.212,00 |
834.492.332,50 |
709.318.482,63 |
37.478.212,00 |
(194.356.920,63) |
|
1.248.995.644,00 |
7.493.973,86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 9 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
1.201.247.309,00 |
7.207.483,85 |
|
|
|
Anticipo |
|
Intereses |
|
|
|
|
|
|
|
|
|
211.198.500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
mes 18 |
|
Costo |
Viviendas |
Aporte |
Menos anticipo |
Aporte |
|
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
- |
|
mes 8 |
| Mes 10 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
1.153.498.974,00 |
6.920.993,84 |
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
- |
|
mes 9 |
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
- |
|
mes 10 |
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
- |
|
mes 11 |
|
|
|
|
|
|
|
|
Aporte total |
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
- |
|
mes 12 |
| Mes 11 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
1.105.750.639,00 |
6.634.503,83 |
|
0 |
########## |
- |
- |
- |
- |
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
|
mes 13 |
|
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
|
mes 14 |
|
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
|
mes 15 |
|
|
|
|
|
|
|
|
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
|
mes 16 |
| Mes 12 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
1.058.002.304,00 |
6.348.013,82 |
|
|
49.860.320 |
10 |
########## |
21.119.850 |
########## |
|
mes 17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 13 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
1.010.253.969,00 |
6.061.523,81 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 14 |
477.483.350,00 |
|
429.735.015,00 |
365.274.762,75 |
|
64.460.252,25 |
47.748.335,00 |
962.505.634,00 |
5.775.033,80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 15 |
477.483.350,00 |
|
112.308.669,97 |
95.462.369,47 |
|
16.846.300,50 |
365.174.680,03 |
597.330.953,97 |
3.583.985,72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 16 |
477.483.350,00 |
|
|
|
- |
477.483.350,00 |
119.847.603,97 |
719.085,62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 17 |
477.483.350,00 |
|
|
|
274.401.302,88 |
119.847.603,97 |
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mes 18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4.986.032.000,00 |
1.248.995.644,00 |
4.986.032.000,00 |
4.282.037.000,00 |
1.248.995.644,00 |
409.562.056,85 |
1.248.995.644,00 |
|
83.234.443,13 |
|
|
|
|
|
|
|
|
|
|
|
|
51.224.779,62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0,38 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Flujo de caja |
|
|
|
|
|
| Mes 1 |
0 |
|
|
|
|
|
| Mes 2 |
352.644.788 |
|
|
|
|
|
| Mes 3 |
14.920.928 |
|
|
|
|
|
| Mes 4 |
61.025.770 |
|
|
|
|
|
| Mes 5 |
78.033.240 |
|
|
|
|
|
| Mes 6 |
-79.740.374 |
|
|
|
|
|
| Mes 7 |
-208.242.491 |
|
|
|
|
|
| Mes 8 |
-194.356.921 |
|
|
|
|
|
| Mes 9 |
64.460.252 |
|
|
|
|
|
| Mes 10 |
64.460.252 |
|
|
|
|
|
| Mes 11 |
64.460.252 |
|
|
|
|
|
| Mes 12 |
64.460.252 |
|
|
|
|
|
| Mes 13 |
64.460.252 |
|
|
|
|
|
| Mes 14 |
64.460.252 |
|
|
|
|
|
| Mes 15 |
16.846.300 |
|
|
|
|
|
| Mes 16 |
0 |
|
|
|
|
|
| Mes 17 |
274.401.303 |
|
|
|
|
|
| Mes 18 |
409.562.056,85 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Ganancia en 18 meses |
Ganancia en 12 meses |
|
|
|
|
|
| Ganancia |
409.562.056,85 |
|
646.870.824,66 |
|
|
|
|
|
|
|
|
|
|
| Variación de Ganancia |
0,37 |
|
|
|
|
|
|
|
|
|
|
|
|
- |
########## |
|
|
| Inversión Inicial |
292.732.000,00 |
|
|
|
|
|
|
Totales Interes |
|
|
|
|
|
|
| Tasa de descuento |
13% |
|
|
|
|
|
|
|
|
|
|
| VPN |
345.737.444,54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TIR |
0,168 |
|
|
|
|
|
|
|
|
|
|
| Rendimiento |
1,40 |
|
|
|
|
|
|
|
|
|
|
| Porcentaje
VPN / Inversión |
118% |
|
|
|
|
|
|
|
|
|
|
|
|
Calculo del TIR |
|
|
|
|
|
|
(292.732.000,00) |
|
|
|
|
|
| Mes 1 |
0 |
|
|
|
|
|
| Mes 2 |
352.644.788 |
|
|
|
|
|
| Mes 3 |
14.920.928 |
|
|
|
|
|
| Mes 4 |
61.025.770 |
|
|
|
|
|
| Mes 5 |
78.033.240 |
|
|
|
|
|
| Mes 6 |
-79.740.374 |
|
|
|
| Mes 7 |
-208.242.491 |
|
|
|
| Mes 8 |
-194.356.921 |
|
|
|
| Mes 9 |
64.460.252 |
|
|
|
| Mes 10 |
64.460.252 |
|
|
|
| Mes 11 |
64.460.252 |
|
|
|
| Mes 12 |
64.460.252 |
|
|
|
| Mes 13 |
64.460.252 |
|
|
|
| Mes 14 |
64.460.252 |
|
|
|
| Mes 15 |
16.846.300 |
|
|
|
| Mes 16 |
0 |
|
|
|
| Mes 17 |
274.401.303 |
|
|
|
| Mes 18 |
409.562.057 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|