Flujo Economico Financiero Gerencia de La Construccion

CUADRO DE ÁREAS

ÁREA DE TERRENO (M2) 200

ÁREA VENDIBLE ÁREA CONSTRUIDA

Nivel Departamento Área (m2) Nivel

1101 77.48 1 45102 42.64 2

2201 67.56 3202 91.20 4

3301 67.56 5302 91.20 Total 45

4401 67.56402 91.20

5501 67.56502 91.20

Estacionamientos Área (m2)

1A 15B 15C 15

Estacionamientos (m2)

CUADRO DE ÁREAS

ÁREA CONSTRUIDA

Total (m2)

13.5 120.12 178.6213.5 158.76 172.2613.5 158.76 172.2613.5 158.76 172.2613.5 158.76 172.2667.5 755.16 867.66

Err:509Err:509

Áreas comunes (m2)

Área neta de Dptos. (m2)

COSTO DE CONSTRUCCIÓN

Resumen de PresupuestoPartida Costo parcial (S/.) Costo sin IGV

Arquitectura 246,189.88 216,907.38Estructura 225,150.78 198,370.73Instalaciones Eléctricas 37,095.22 32,683.01Instalaciones Sanitarias 24,633.34 21,703.38

Total 533,069.22 469,664.51

no aplico todo el igv solo el 75 %


Resumen de PresupuestoRatio S/. / m2

249.99 208635.492228.63 190805.74637.67 31436.627125.01 20875.7119

541.30

ESTRUCTURA DE EGRESOS (GASTOS)

COSTOS DEL SOLAR Unidad Cantidad P.U. (S/.)Solar o terreno m2 200 1,600.00Pago Alcabala % 3% 320,000.00Gastos Notariales % 0.10% 320,000.00Gastos Registrales % 0.30% 320,000.00TOTAL SOLAR

ESTUDIOS Y PROYECTOS Unidad Cantidad P.U. (S/.)Estudios de Suelos m2 Solar 200 2.52Estudios Topográficos m2 Solar 200 1.26Estudio del Mercado glb 1 500.00Arquitectura m2 867.66 7.27Estructuras m2 867.66 4.10Instalaciones Eléctricas m2 867.66 1.89Instalaciones Sanitarias m2 867.66 1.55Copias planos glb 1 750.00Otros glb 1 500.00TOTAL ESTUDIOS Y PROYECTOS

APROBACIONES Y LICENCIAS Unidad Cantidad P.U. (S/.)

Certificado de parámetros Urbanísticos glb 1 125.00

% 0.08% 533,069.22

Licencia de Construcción % 0.51% 533,069.22Certificado de finalización de obra glb 1 315.00Cert. De Numeración glb 1 450.00Predeclaratoria de fábrica glb 1 630.00Declaratoria de fábrica glb 1 850.00Inscripción de inmuebles glb 1 1,550.00Factibilidad servicios (Luz, agua) glb 1 4,350.00TOTAL APROBACIONES Y LICENCIAS

CONSTRUCCIÓN Unidad Cantidad P.U. (S/.)Estructura m2 867.66 249.99Arquitectura m2 867.66 228.63Instalaciones Eléctricas m2 867.66 37.67Instalaciones Sanitarias m2 867.66 25.01

Costo DirectoG.G. Constructor % 0% 469,664.51Utilidad Constructor % 0% 469,664.51Supervisión % 0% 469,664.51TOTAL CONSTRUCCION

GASTOS ADMINISTRATIVOS Unidad Cantidad P.U. (S/.)

Aprobación de Anteproyecto de Edificaciones

Gastos legales mes 18 775.00Gastos contabilidad mes 18 775.00Servicios Dptos. 10 155.00Autovaluo de terreno sin construir m2 200 3.75Arbitrios Dptos. 10 125.00Predial Dptos. 10 250.00Poliza de seguro % 0.10% 533,069.22Gastos varios glb 1 1,500.00TOTAL GASTOS ADMINISTRATIVOS

POST CONSTRUCCIÓN Unidad Cantidad P.U. (S/.)Mantenimiento de Unidades Dptos. 10 250.00Vigilancia mes 12 650.00Gastos varios glb 1 1,500.00TOTAL POST CONSTRUCCIÓN

TITULACION Unidad Cantidad P.U. (S/.)

Dptos. 10 875.00

Dptos. 10 525.00

Gastos registrales Dptos. 10 775.00TOTAL TITULACIÓN

PUBLICIDAD Y VENTA Unidad Cantidad P.U. (S/.)Promoción del proyecto % 1.5% 2,237,791.83Comisión de Venta % 2.0% 2,237,791.83TOTAL PUBLICIDAD Y VENTA

GASTOS BANCARIOS Unidad Cantidad P.U. (S/.)Estructuración financiera % 2.0% 533,069.22Carta fianza % 1.0% 533,069.22Supervisión bancaria mes 6 350.00TOTAL GASTOS BANCARIOS

GERENCIA DEL PROYECTO Unidad Cantidad P.U. (S/.)Gerencia de proyecto % 2.0% 2,237,791.83Gastos Generales de oficina % 0.5% 2,237,791.83TOTAL PUBLICIDAD Y VENTA

COSTO TOTAL DEL PROYECTO

RESUMEN DE COSTOS PARA EL ESTUDIO DE PRE - FACTIBILIDADCOSTO TOTALES Ratios % US$ % / Costo total

Terreno 320,000.00 29.45%Alcabala 3.0% 9,600.00 0.88%Proyectos y Licencias 2.5% 13,326.73 1.23%Administrativos 2.0% 10,661.38 0.98%

Planos de independización y redacción de expediente

Gastos notariales y legalización de expediente

Notariales y Registrales 0.6% 13,426.75 1.24%Post construcción 1.0% 5,330.69 0.49%Gerencia de Proyecto 2.5% 55,944.80 5.15%Titulación e Impuestos Municipales 0.5% 11,188.96 1.03%Construcción 533,069.22 49.06%Financieros 2.5% 13,326.73 1.23%Marketing y Publicidad 2.0% 44,755.84 4.12%Comisiones de venta 2.0% 44,755.84 4.12%Imprevistos 0.5% 11,188.96 1.03%

Total costo de proyecto 1,086,575.90

Venta Total 2,237,791.83

Resumen de Costos del ProyectoCOSTO TOTALES Parcial US$ IGV (US$) Total US$

Terreno 330,880.00 0.00 330,880.00Estudios y Proyectos 15,356.04 2,764.09 18,120.13Aprobaciones y licencia 11,441.76 0.00 11,441.76Construcción 469,664.51 63,404.71 533,069.22Gastos Administrativos 35,983.07 5,706.00 41,689.07Post construcción 11,800.00 0.00 11,800.00Titulación 21,750.00 945.00 22,695.00Publicidad y Venta 78,322.71 14,098.09 92,420.80Gastos Bancarios 18,092.08 0.00 18,092.08Gerencia de Proyectos 55,944.80 0.00 55,944.80

Total Costo de Proyecto 1,049,234.97 86,917.89 1,136,152.86

ESTRUCTURA DE EGRESOS (GASTOS)

con terreno igv a favor COSTO DE SOLAR% IGV IGV TOTAL (US$) Mes 1

320,000.00 0% 0.00 320,000.00 320,000.009,600.00 0% 0.00 9,600.00 9,600.00

320.00 0% 0.00 320.00 320.00960.00 0% 0.00 960.00 960.00

330,880.00 0.00 330,880.00 29.12% 330,880.00ESTUDIOS Y PROYECTOS

P. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 1504.00 18% 90.72 594.72252.00 18% 45.36 297.36500.00 18% 90.00 590.00

6,307.89 18% 1,135.42 7,443.313,557.41 18% 640.33 4,197.741,639.88 18% 295.18 1,935.061,344.87 18% 242.08 1,586.95

750.00 18% 135.00 885.00500.00 18% 90.00 590.00

15,356.04 2,764.09 18,120.13 1.59% 0.00APROBACIONES Y LICENCIAS

P. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 1

125.00 0% 0.00 125.00

453.11 0% 0.00 453.11

2,718.65 0% 0.00 2,718.65315.00 0% 0.00 315.00450.00 0% 0.00 450.00630.00 0% 0.00 630.00850.00 0% 0.00 850.00

1,550.00 0% 0.00 1,550.004,350.00 0% 0.00 4,350.00

11,441.76 0.00 11,441.76 1.01% 0.00CONSTRUCCIÓN

P. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 1216,907.38 14% 29,282.50 246,189.88198,370.73 14% 26,780.05 225,150.78

32,683.01 14% 4,412.21 37,095.2221,703.38 14% 2,929.96 24,633.34

469,664.51 63,404.71 533,069.220.00 18% 0.00 0.000.00 18% 0.00 0.000.00 18% 0.00 0.00

469,664.51 63,404.71 533,069.22 46.92% 0.00GASTOS ADMINISTRATIVOS


13,950.00 18% 2,511.00 16,461.00 775.0013,950.00 18% 2,511.00 16,461.00 775.00

1,550.00 18% 279.00 1,829.00750.00 18% 135.00 885.00 750.00

1,250.00 0% 0.00 1,250.002,500.00 0% 0.00 2,500.00

533.07 0% 0.00 533.071,500.00 18% 270.00 1,770.00 83.33

35,983.07 5,706.00 41,689.07 3.67% 2,383.33POST CONSTRUCCIÓN

P. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 12,500.00 0% 0.00 2,500.007,800.00 0% 0.00 7,800.001,500.00 0% 0.00 1,500.00

11,800.00 0.00 11,800.00 1.04% 0.00TITULACIÓN


8,750.00 0% 0.00 8,750.00

5,250.00 18% 945.00 6,195.00

7,750.00 0% 0.00 7,750.0021,750.00 945.00 22,695.00 2.00% 0.00

PUBLICIDAD Y VENTAP. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 1

33,566.88 18% 6,042.04 39,608.9244,755.84 18% 8,056.05 52,811.8978,322.71 14,098.09 92,420.80 8.13% 0.00

GASTOS BANCARIOSP. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 1

10,661.38 0% 0.00 10,661.385,330.69 0% 0.00 5,330.692,100.00 0% 0.00 2,100.00

18,092.08 0.00 18,092.08 1.59% 0.00GERENCIA DEL PROYECTO

P. Parcial (S/.) % IGV IGV TOTAL (US$) Mes 144,755.84 0% 0.00 44,755.84 2,486.4411,188.96 0% 0.00 11,188.9655,944.80 0.00 55,944.80 4.92% 2,486.44

P. Parcial IGV TOTAL1,049,234.97 86,917.89 1,136,152.86

RESUMEN DE COSTOS PARA EL ESTUDIO DE PRE - FACTIBILIDAD

terreno gatio fijo% Valor del Solar% Valor de Construcción% Valor de Construcción

% Valor de Ventas% Valor de Construcción% Valor de Ventas% Valor de Ventas

% Valor de Construcción% Valor de Ventas% Valor de Ventas% Valor de Ventas

% / Costo total29.12%

1.59%1.01%

46.92%3.67%1.04%2.00%8.13%1.59%4.92%

100.00%

COSTO DE SOLARMes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00ESTUDIOS Y PROYECTOS

Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9126.00 126.00 126.00 126.0063.00 63.00 63.00 63.00

125.00 125.00 125.00 125.001,576.97 1,576.97 1,576.97 1,576.97889.35 889.35 889.35 889.35409.97 409.97 409.97 409.97336.22 336.22 336.22 336.22187.50 187.50 187.50 187.50125.00 125.00 125.00 125.003,839.01 3,839.01 0.00 3,839.01 3,839.01 0.00 0.00 0.00

APROBACIONES Y LICENCIASMes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9

125.00

453.11

679.66 2,038.99

578.11 679.66 2,038.99 0.00 0.00 0.00 0.00 0.00CONSTRUCCIÓN 9% 13% 13%

Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 919,521.66 28,197.96 28,197.9617,853.37 25,788.20 25,788.202,941.47 4,248.79 4,248.791,953.30 2,821.44 2,821.44

0.00 0.000.00 0.000.00 0.00

0.00 0.00 0.00 0.00 0.00 42,269.81 61,056.39 61,056.39GASTOS ADMINISTRATIVOS

Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9

775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00

155.00

750.001,500.00

533.0783.33 83.33 83.33 83.33 83.33 83.33 83.33 83.33

1,633.33 1,633.33 1,633.33 1,633.33 2,166.40 1,633.33 3,883.33 1,788.33POST CONSTRUCCIÓN


650.00 650.00 650.00

0.00 0.00 0.00 0.00 0.00 650.00 650.00 650.00


0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00PUBLICIDAD Y VENTA

Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 92,797.24 2,797.24 2,797.24 2,797.24

4,068.71 4,068.710.00 0.00 0.00 0.00 2,797.24 2,797.24 6,865.95 6,865.95

GASTOS BANCARIOSMes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00GERENCIA DEL PROYECTO

Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 92,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44658.17 658.17 658.17 658.17 658.17 658.17 658.17 658.173,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61


0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00


105.00 105.00150.00 150.00210.00 210.00283.33 283.33516.67 516.67

1,450.00 1,450.000.00 0.00 0.00 0.00 0.00 0.00 2,715.00 2,715.0012% 12% 5% 12% 12% 12%

Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 1726,028.89 26,028.89 10,845.37 26,028.89 26,028.89 26,028.8923,804.49 23,804.49 9,918.54 23,804.49 23,804.49 23,804.493,921.96 3,921.96 1,634.15 3,921.96 3,921.96 3,921.962,604.41 2,604.41 1,085.17 2,604.41 2,604.41 2,604.41

0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

56,359.74 56,359.74 23,483.23 56,359.74 56,359.74 56,359.74 0.00 0.00


775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00155.00 155.00 155.00 155.00 155.00 155.00 155.00 155.00

500.001,000.00

83.33 83.33 83.33 83.33 83.33 83.33 83.33 83.331,788.33 1,788.33 1,788.33 1,788.33 1,788.33 1,788.33 3,288.33 1,788.33

Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 17833.33 833.33

650.00 650.00 650.00 650.00 650.00 650.00 650.00 650.00500.00 500.00

650.00 650.00 650.00 650.00 650.00 650.00 1,983.33 1,983.33


4,375.00

2,625.00

3,875.000.00 0.00 0.00 0.00 0.00 0.00 0.00 10,875.00

Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 172,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.244,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71

6,865.95 6,865.95 6,865.95 6,865.95 6,865.95 6,865.95 6,865.95 6,865.95

Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 171,523.05 1,523.05 1,523.05 1,523.05 1,523.05 1,523.05761.53 761.53 761.53 761.53 761.53 761.53300.00 300.00 300.00 300.00 300.00 300.00

0.00 0.00 2,584.58 2,584.58 2,584.58 2,584.58 2,584.58 2,584.58

Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 172,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44658.17 658.17 658.17 658.17 658.17 658.17 658.17 658.173,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61

19.3333333

Mes 18 TOTAL320,000.00 0.00

9,600.00 0.00320.00 0.00960.00 0.00

0.00 330,880.00 0.000.00

Mes 18 TOTAL 0.00504.00 0.00252.00 0.00500.00 0.00

6,307.89 0.003,557.41 0.001,639.88 0.001,344.87 0.00750.00 0.00500.00 0.00

0.00 15,356.04 0.000.00

Mes 18 TOTAL 0.00

125.000.00

453.110.00

2,718.65 0.00105.00 315.00 0.00150.00 450.00 0.00210.00 630.00 0.00283.33 850.00 0.00516.67 1,550.00 0.00

1,450.00 4,350.00 0.002,715.00 11,441.76 0.00

0.00Mes 18 TOTAL 0.00

216,907.38 0.00198,370.73 0.0032,683.01 0.0021,703.38 0.00

469,664.510.00 0.000.00 0.000.00 0.00

0.00 469,664.51 0.000.00

Mes 18 TOTAL 0.00

775.00 13,950.00 0.00775.00 13,950.00 0.00155.00 1,550.00 0.00

750.00 0.001,250.00 0.002,500.00 0.00533.07 0.00

83.33 1,500.00 0.001,788.33 35,983.07 0.00

0.00Mes 18 TOTAL 0.00833.33 2,500.00 0.00650.00 7,800.00 0.00500.00 1,500.00 0.001,983.33 11,800.00 0.00

0.00Mes 18 TOTAL 0.00

4,375.00 8,750.000.00

2,625.00 5,250.000.00

3,875.00 7,750.00 0.0010,875.00 21,750.00 0.00

0.00Mes 18 TOTAL 0.00

33,566.88 0.004,068.71 44,755.84 0.00

4,068.71 78,322.71 0.000.00

Mes 18 TOTAL 0.001,523.05 10,661.38 0.00761.53 5,330.69 0.00300.00 2,100.00 0.002,584.58 18,092.08 0.00

0.00Mes 18 TOTAL 0.00

2,486.44 44,755.84 0.00658.17 11,188.96 0.003,144.61 55,944.80 0.00

ESTRUCTURA DE INGRESOS POR VENTAS

RESUMEN DE VENTAS

Descripción Cantidad

Departamentos 8.00 755.16 989,989.91 989,989.91Estacionamientos 3.00 45.00 41,284.40 41,284.40

Totales 11.00 1,031,274.31 1,031,274.31

Precios establecidos(S/.) (US$)

2,750.00 846.15 Precio M2 área vendible interior2,950.00 907.69 Precio M2 área vendible exterior

30,000.00 9,230.77 Precio de cada estacionamiento

BLOQUE A

Nivel Departamento

1101 I 77.48 97,738.53102 E 42.64 57,700.92

2201 I 67.56 85,224.77202 E 91.20 123,412.84

3301 I 67.56 85,224.77302 E 91.20 123,412.84

4401 I 67.56 85,224.77402 E 91.20 123,412.84

5501 I 67.56 85,224.77502 E 91.20 123,412.84

Sub Total 755.16 989,989.91

120.00 145,000.00 471,250.00 3,927.08128.00 150,000.00 487,500.00 3,808.59110.00 94,461.54 307,000.00 2,790.91130.00 70,769.23 230,000.00 1,769.23150.00 110,000.00 357,500.00 2,383.33140.00 110,000.00 357,500.00 2,553.57

2,872.12

Área vendible

(m2)Valor de Venta

Solar (US$)Valor de Venta fábrica (US$)

Área vendible (m2)

Valor de Venta Terreno (S/.)

ESTRUCTURA DE INGRESOS POR VENTAS

RESUMEN DE VENTAS

IGV US$ 18%

1,979,979.82 167,812.02 2,147,791.8382,568.81 7,431.19 90,000.00

2,062,548.62 175,243.21 2,237,791.83

Cambio Dólar3.25

BLOQUE A

IGV 18% (S/.)

97,738.53 195,477.06 17,592.94 213,070.00 65,560.0057,700.92 115,401.83 0.00 115,401.83 35,508.2685,224.77 170,449.54 15,340.46 185,790.00 57,166.15

123,412.84 246,825.69 22,214.31 269,040.00 82,781.5485,224.77 170,449.54 15,340.46 185,790.00 57,166.15

123,412.84 246,825.69 22,214.31 269,040.00 82,781.5485,224.77 170,449.54 15,340.46 185,790.00 57,166.15

123,412.84 246,825.69 22,214.31 269,040.00 82,781.5485,224.77 170,449.54 15,340.46 185,790.00 57,166.15

123,412.84 246,825.69 22,214.31 269,040.00 82,781.54

989,989.91 1,979,979.82 167,812.02 2,147,791.83

Precio US$ sin IGV

Precio US$ con IGV

Valor de Venta fábrica

(S/.)Precio US$ sin

IGVPrecio US$ con

IGV

Sep-14 Oct-14 Nov-14 Dec-14 Jan-15

CRONOGRAMA DEL PROYECTO Mes 1 Mes 2 Mes 3 Mes 4 Mes 5

FASE 0 - INICIOCompra del Terreno

FASE 1 - ANTEPROYECTODesarrollo de AnteproyectoAprobación de Anteproyecto

FASE 2 - PROYECTODesarrollo de especialidadesAprobación de Proyecto

FASE 3 - CONSTRUCCIÓNInicio de ObraEjecución de ObraFin de Obra

FASE 4 - ENTREGAConformidad de obra - InscripciónEntrega

VENTASPre ventas de Dptos.Venta de Dptos.Vendedores Inmobiliarios

PUBLICIDADPublicidad en medios

FINANCIAMIENTODesenbolso del Bancoç

Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16Mes 6 Mes 7 Mes 8 Mes 9 Mes 10 Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 17

9% 13% 13% 12% 12% 5% 12% 12% 12%

Feb-16Mes 18

CASH FLOW

ANTEPROYECTO PROYECTO

Porcentaje de Avance de Obra 100.00%Porcentaje de Avance de Obra Acumulado

Mes1 Mes2 Mes3 Mes4 Mes5

VELOCIDAD DE VENTA Velocidad venta de Viviendas 8Velocidad venta de Estacionamientos 3

FLUJO DE INGRESOS

1201 Cuota Incial 3,068.09

Crédito Hipot. 12,272.37

202 Cuota Incial 4,442.86Crédito Hipot. 17,771.45



102 Cuota Incial 0.00Crédito Hipot. 0.00





Com

pra

del

terr

eno

/Ant

epro

yect

o

Apro

b.

Ante

proy

ecto

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

4401






1

E - 1 Cuota Incial 2,477.06Crédito Hipot. 0.00



IGV 175,243.21 0.00 0.00 0.00 0.00 0.00

Apro

b. P

roye

cto

Inic

io d

e ob

ra

Obr

a m

es 2

Obr

a m

es 3

Obr

a m

es 4

Obr

a m

es 5

Obr

a m

es 6

Obr

a m

es 7

Obr

a m

es 8

Fin

de O

bra

PROYECTO CONSTRUCCIÓNPRE VENTAS VENTAS

9% 13.00% 13.00% 12.00% 13.00% 5.00% 12.00% 12.00% 11.00%9% 22.00% 35.00% 47.00% 60.00% 65.00% 77.00% 89.00% 100.00%

Mes6 Mes7 Mes8 Mes9 Mes10 Mes11 Mes12 Mes13 Mes14 Mes15

2 21

3,068.099,830.17

4,442.8614,234.933,518.59

0.00

2,477.06

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,510.95 30,060.75

Entr

ega

VENTAS CONFORMIDAD Y ENTREGA100.00%

Mes16 Mes17 Mes18 TOTAL

2 2 81 1 3

3,068.091,214.96 1,227.24 12,272.37

4,442.861,759.37 1,777.14 17,771.45

3,518.5912,666.91 1,407.43 14,074.35

0.000.00 0.00 0.00

3,068.09 3,068.0911,045.13 1,227.24 12,272.37

4,442.86 4,442.8615,994.30 1,777.14 17,771.45

3,068.09 3,068.09

Conf

orm

idad

de

obra

Conf

orm

idad

de

obra

11,045.13 1,227.24 12,272.374,442.86 4,442.86

17,771.45 17,771.453,068.09 3,068.09

12,272.37 12,272.374,442.86 4,442.86

17,771.45 17,771.452,477.06

0.002,477.06 2,477.06

0.002,477.06 2,477.06

0.00

28,697.36 52,515.45 56,458.70 175,243.21

CASH FLOW

ANTEPROYECTO PROYECTO

Porcentaje de Avance de Obra 100.00%Porcentaje de Avance de Obra Acumulado


Sep-14 Oct-14 Nov-14 Dec-14 Jan-15

VELOCIDAD DE VENTA Velocidad venta de Viviendas 10Velocidad venta de Estacionamientos 3

FLUJO DE INGRESOS











Com

pra

del

terr

eno

/Ant

epro

yect

o

Apro

b.

Ante

proy

ecto

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

4401






1




Ingreso por venta de Dptos. y Estacionamientos 2,062,548.62 0.00 0.00 0.00 0.00 0.00

IGV 175,243.21 0.00 0.00 0.00 0.00 0.00

Total Ingresos (Incluido IGV) 2,237,791.83 0.00 0.00 0.00 0.00 0.00

FLUJO DE EGRESOSTERRENOTerreno 320,000.00 320,000.00 0.00 0.00 0.00 0.00Pago Alcabala 9,600.00 9,600.00 0.00 0.00 0.00 0.00Gastos Notariales 320.00 320.00 0.00 0.00 0.00 0.00Gastos Registrales 960.00 960.00 0.00 0.00 0.00 0.00ESTUDIOS Y PROYECTOSEstudios de Suelos 504.00 0.00 126.00 126.00 0.00 126.00Estudios Topográficos 252.00 0.00 63.00 63.00 0.00 63.00Estudio del Mercado 500.00 0.00 125.00 125.00 0.00 125.00Arquitectura 6,307.89 0.00 1,576.97 1,576.97 0.00 1,576.97Estructuras 3,557.41 0.00 889.35 889.35 0.00 889.35

Instalaciones Eléctricas 1,639.88 0.00 409.97 409.97 0.00 409.97Instalaciones Sanitarias 1,344.87 0.00 336.22 336.22 0.00 336.22Copias planos 750.00 0.00 187.50 187.50 0.00 187.50Otros 500.00 0.00 125.00 125.00 0.00 125.00APROBACIONES Y LICENCIASCertificado de parámetros Urbanísticos 125.00 0.00 125.00 0.00 0.00 0.00Aprobación de Anteproyecto de Edificaciones 453.11 0.00 453.11 0.00 0.00 0.00Licencia de Construcción 2,718.65 0.00 0.00 679.66 2,038.99 0.00Certificado de finalización de obra 315.00 0.00 0.00 0.00 0.00 0.00Cert. De Numeración 450.00 0.00 0.00 0.00 0.00 0.00Predeclaratoria de fábrica 630.00 0.00 0.00 0.00 0.00 0.00Declaratoria de fábrica 850.00 0.00 0.00 0.00 0.00 0.00Inscripción de inmuebles 1,550.00 0.00 0.00 0.00 0.00 0.00Factibilidad servicios (SEDAPAL, ELECTROCENTRO) 4,350.00 0.00 0.00 0.00 0.00 0.00CONSTRUCCIÓNEstructura 216,907.38 0.00 0.00 0.00 0.00 0.00Arquitectura 198,370.73 0.00 0.00 0.00 0.00 0.00Instalaciones Eléctricas 32,683.01 0.00 0.00 0.00 0.00 0.00Instalaciones Sanitarias 21,703.38 0.00 0.00 0.00 0.00 0.00

Costo DirectoG.G. Constructor 0.00 0.00 0.00 0.00 0.00 0.00Utilidad Constructor 0.00 0.00 0.00 0.00 0.00 0.00Supervisión 0.00 0.00 0.00 0.00 0.00 0.00GASTOS ADMINISTRATIVOSGastos legales 13,950.00 775.00 775.00 775.00 775.00 775.00Gastos contabilidad 13,950.00 775.00 775.00 775.00 775.00 775.00Servicios 1,550.00 0.00 0.00 0.00 0.00 0.00Autovaluo de terreno sin construir 750.00 750.00 0.00 0.00 0.00 0.00Arbitrios 1,250.00 0.00 0.00 0.00 0.00 0.00Predial 2,500.00 0.00 0.00 0.00 0.00 0.00Poliza de seguro 533.07 0.00 0.00 0.00 0.00 0.00Gastos varios 1,500.00 83.33 83.33 83.33 83.33 83.33

POST CONSTRUCCIÓNMantenimiento de Unidades 2,500.00 0.00 0.00 0.00 0.00 0.00Vigilancia 7,800.00 0.00 0.00 0.00 0.00 0.00Gastos varios 1,500.00 0.00 0.00 0.00 0.00 0.00TITULACIONPlanos de independización y redacción de expediente 8,750.00 0.00 0.00 0.00 0.00 0.00Gastos notariales y legalización de expediente 5,250.00 0.00 0.00 0.00 0.00 0.00Gastos registrales 7,750.00 0.00 0.00 0.00 0.00 0.00PUBLICIDAD Y VENTAPromoción del proyecto 33,566.88 0.00 0.00 0.00 0.00 0.00Comisión de Venta 44,755.84 0.00 0.00 0.00 0.00 0.00GASTOS BANCARIOSEstructuración financiera 10,661.38 0.00 0.00 0.00 0.00 0.00Carta fianza 5,330.69 0.00 0.00 0.00 0.00 0.00Supervisión bancaria 2,100.00 0.00 0.00 0.00 0.00 0.00GERENCIA DEL PROYECTOGerencia de proyecto 44,755.84 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44Gastos Generales de oficina 11,188.96 0.00 658.17 658.17 658.17 658.17

Egresos totales sin IGV 1,049,234.97 335,749.77 9,195.06 9,296.62 6,816.93 8,616.95

IGV 86,917.89 429.00 985.02 985.02 294.00 985.02

Total Egresos (Incluido IGV) 1,136,152.86 336,178.77 10,180.08 10,281.64 7,110.93 9,601.98

IGV por Pagar

IGV Repercutido (Ventas) 175,243.21 0.00 0.00 0.00 0.00 0.00 IGV Soportado (Gastos) 86,917.89 429.00 985.02 985.02 294.00 985.02

IGV a pagar 153,451.11 0.00 0.00 0.00 0.00 0.00 Crédito Fiscal 65,125.78 429.00 985.02 985.02 294.00 985.02

IGV Soportado - IGV Repercutido -88,325.33 429.00 985.02 985.02 294.00 985.02 Acumulado 429.00 1,414.02 2,399.04 2,693.04 3,678.07

Crédito fiscal acumulado al final del período 429.00 1,414.02 2,399.04 2,693.04 3,678.07

88,325.33 0.00 0.00 0.00 0.00 0.00

Impuesto a la Renta (Imp. Sociedades)Impuesto a la renta 30% 301,721.10 -100724.93061 -2758.51882844 -2788.985154 -2045.079762 -2585.086177Acumulado -100724.93061 -103483.44944 -106272.4346 -108317.5144 -110902.6005Flujo de Impuesto a la Renta 301,721.10 0.00 0.00 0.00 0.00 0.00

FLUJO DE CAJA ECONÓMICO ADIINGRESOS (Inc. IGV) 2,237,791.83 0.00 0.00 0.00 0.00 0.00 EGRESOS (Inc. IGV) 1,526,199.29 336,178.77 10,180.08 10,281.64 7,110.93 9,601.98 Saldo Mensual 711,592.55 -336,178.77 -10,180.08 -10,281.64 -7,110.93 -9,601.98 Saldo Acumulado -336,178.77 -346,358.85 -356,640.49 -363,751.43 -373,353.40

INDICADORES ECONÓMICOS DEL PROYECTOVAN Proyecto (US$) 496,843.71 Tasa de descuento anual 15%Tasa de descuento mensual 1.17%TIR PROYECTO 5.538%TIR PROYECTO (% anual) 90.93%


FLUJO FINANCIEROFlujo de caja económico 711,592.55 -336,178.77 -10,180.08 -10,281.64 -7,110.93 -9,601.98 Saldo acumulado -336,178.77 -346,358.85 -356,640.49 -363,751.43 -373,353.40

PRO

MO

TOR Aporte del inversionista 705,167.86 336,178.77 10,180.08 10,281.64 7,110.93 9,601.98

Aporte del inversionista acumulado 336,178.77 346,358.85 356,640.49 363,751.43 373,353.40 Amortización de aporte del inversionista 1,409,183.76 0.00 0.00 0.00 0.00 0.00

IGV por pagar (ó a devolver por SUNAT)

PRO

MO

TOR

Flujo del Inversionista 704,015.91 -336,178.77 -10,180.08 -10,281.64 -7,110.93 -9,601.98 Flujo acumulado del inversionista -336,178.77 -346,358.85 -356,640.49 -363,751.43 -373,353.40

BAN

CO

Financiamiento Bancario (deuda senior) 190,763.90 0.00 0.00 0.00 0.00 0.00 Financiamiento Acumulado (saldo vivo de la deuda senior) 0.00 0.00 0.00 0.00 0.00 Gastos financieros (gf deuda senior) 7,576.64 0.00 0.00 0.00 0.00 0.00 Amortización de Préstamo Bancario (Devolución) 190,763.90 0.00 0.00 0.00 0.00

Saldo de Caja 1,409,183.76 0.00 0.00 0.00 0.00 0.00 1,409,183.76 0.00 0.00 0.00 0.00 0.00

INDICADORES FINANCIEROS (INVERSIONISTA)VAN Inversionista 495,785.17 613,403.28 €Tasa de descuento anual 15% 0.12 €Tasa de descuento mensual 1.17% 0.009488792935TIR Inversionista 5.692% 0.032944257597TIR INVERSIONISTA (anual) 94.32% 0.475443649902

Apro

b. P

roye

cto

Inic

io d

e ob

ra

Obr

a m

es 2

Obr

a m

es 3

Obr

a m

es 4

Obr

a m

es 5

Obr

a m

es 6

Obr

a m

es 7

Obr

a m

es 8

Fin

de O

bra

PROYECTO CONSTRUCCIÓNPRE VENTAS VENTAS

9% 13% 13% 12% 12% 5% 12% 12% 12%9% 22.00% 35.00% 47.00% 59.00% 64.00% 76.00% 88.00% 100.00%


Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15

1 1 1 1 1 1 1 1 11 1 1

34,089.91 34,089.9126,999.21 107,996.83

49,365.14156,388.7639,095.41

23,080.37

27,522.94

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 83,455.05 354,084.30

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,510.95 30,060.75

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 90,966.00 384,145.05

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

126.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0063.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

125.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001,576.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00889.35 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

409.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00336.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00187.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00125.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 19,521.66 28,197.96 28,197.96 26,028.89 26,028.89 10,845.37 26,028.89 26,028.89 26,028.890.00 17,853.37 25,788.20 25,788.20 23,804.49 23,804.49 9,918.54 23,804.49 23,804.49 23,804.490.00 2,941.47 4,248.79 4,248.79 3,921.96 3,921.96 1,634.15 3,921.96 3,921.96 3,921.960.00 1,953.30 2,821.44 2,821.44 2,604.41 2,604.41 1,085.17 2,604.41 2,604.41 2,604.41

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00 775.00

0.00 0.00 0.00 155.00 155.00 155.00 155.00 155.00 155.00 155.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 1,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

533.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0083.33 83.33 83.33 83.33 83.33 83.33 83.33 83.33 83.33 83.33

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 650.00 650.00 650.00 650.00 650.00 650.00 650.00 650.00 650.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.24 2,797.240.00 0.00 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71 4,068.71

0.00 0.00 0.00 0.00 0.00 0.00 1,523.05 1,523.05 1,523.05 1,523.050.00 0.00 0.00 0.00 0.00 0.00 761.53 761.53 761.53 761.530.00 0.00 0.00 0.00 0.00 0.00 300.00 300.00 300.00 300.00

2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44 2,486.44658.17 658.17 658.17 658.17 658.17 658.17 658.17 658.17 658.17 658.17

11,947.26 50,494.99 75,600.28 73,505.28 68,808.64 68,808.64 38,516.70 71,393.22 71,393.22 71,393.22

1,488.53 6,503.93 9,772.48 9,800.38 9,166.34 9,166.34 4,728.01 9,166.34 9,166.34 9,166.34

13,435.79 56,998.92 85,372.76 83,305.66 77,974.97 77,974.97 43,244.71 80,559.56 80,559.56 80,559.56

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,510.95 30,060.75 1,488.53 6,503.93 9,772.48 9,800.38 9,166.34 9,166.34 4,728.01 9,166.34 9,166.34 9,166.34

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,894.41 1,488.53 6,503.93 9,772.48 9,800.38 9,166.34 9,166.34 4,728.01 9,166.34 1,655.38 0.00

1,488.53 6,503.93 9,772.48 9,800.38 9,166.34 9,166.34 4,728.01 9,166.34 1,655.38 -20,894.41 5,166.59 11,670.52 21,443.00 31,243.39 40,409.72 49,576.06 54,304.07 63,470.40 65,125.78 44,231.37

5,166.59 11,670.52 21,443.00 31,243.39 40,409.72 49,576.06 54,304.07 63,470.40 65,125.78 44,231.37

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

-3584.178881 -15148.496568 -22680.08443 -22051.58443 -20642.590895 -20775.27591 -11912.95672 -22040.638112 2839.99776823 84426.185954-114486.7794 -129635.27598 -152315.3604 -174366.9448 -195009.535734 -215784.8116 -227697.7684 -249738.40647 -246898.4087 -162472.2227

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 90,966.00 384,145.05 13,435.79 56,998.92 85,372.76 83,305.66 77,974.97 77,974.97 43,244.71 80,559.56 80,559.56 80,559.56 -13,435.79 -56,998.92 -85,372.76 -83,305.66 -77,974.97 -77,974.97 -43,244.71 -80,559.56 10,406.44 303,585.49

-386,789.19 -443,788.10 -529,160.87 -612,466.53 -690,441.51 -768,416.48 -811,661.19 -892,220.75 -881,814.30 -578,228.81

Interés Bancario Proyecto 18%Interés Bancario Proyecto (mensual) 1.39%


-13,435.79 -56,998.92 -85,372.76 -83,305.66 -77,974.97 -77,974.97 -43,244.71 -80,559.56 10,406.44 303,585.49 -386,789.19 -443,788.10 -529,160.87 -612,466.53 -690,441.51 -768,416.48 -811,661.19 -892,220.75 -881,814.30 -578,228.81

13,435.79 56,998.92 85,372.76 83,305.66 77,974.97 14,726.35 386,789.19 443,788.10 529,160.87 612,466.53 690,441.51 705,167.86 705,167.86 705,167.86 705,167.86 705,167.86

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 119,362.41

-13,435.79 -56,998.92 -85,372.76 -83,305.66 -77,974.97 -14,726.35 0.00 0.00 0.00 119,362.41 -386,789.19 -443,788.10 -529,160.87 -612,466.53 -690,441.51 -705,167.86 -705,167.86 -705,167.86 -705,167.86 -585,805.45

0.00 0.00 0.00 0.00 0.00 63,690.91 44,437.86 82,635.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 63,690.91 108,128.77 190,763.90 182,952.62 0.00 0.00 0.00 0.00 0.00 0.00 442.28 1,193.15 2,075.58 2,595.17 1,270.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,811.28 182,952.62

0.00 0.00 0.00 0.00 0.00 -0.00 0.00 0.00 0.00 119,362.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 119,362.41

Entr

ega

VENTAS CONFORMIDAD Y ENTREGA100.00%


Dec-15 Jan-16 Feb-16

1 103

34,089.9114,726.84 13,635.96 136,359.63

49,365.1421,325.74 19,746.06 197,460.55

39,095.41140,743.49 15,638.17 156,381.65

23,080.3783,089.32 9,232.15 92,321.4734,089.91 34,089.91

122,723.67 13,635.96 136,359.6349,365.14 49,365.14

177,714.50 19,746.06 197,460.5534,089.91 34,089.91

Conf

orm

idad

de

obra

Conf

orm

idad

de

obra

122,723.67 13,635.96 136,359.6349,365.14 49,365.14

197,460.55 197,460.5534,089.91 34,089.91

136,359.63 136,359.6349,365.14 49,365.14

197,460.55 197,460.5527,522.94

0.0027,522.94 27,522.94

0.0027,522.94 27,522.94

0.00

404,953.28 583,504.95 636,551.05 2,062,548.62

28,697.36 52,515.45 56,458.70 175,243.21

433,650.64 636,020.40 693,009.75 2,237,791.83

0.00 0.00 0.00 320,000.000.00 0.00 0.00 9,600.000.00 0.00 0.00 320.000.00 0.00 0.00 960.00

0.00 0.00 0.00 504.000.00 0.00 0.00 252.000.00 0.00 0.00 500.000.00 0.00 0.00 6,307.890.00 0.00 0.00 3,557.41

0.00 0.00 0.00 1,639.880.00 0.00 0.00 1,344.870.00 0.00 0.00 750.000.00 0.00 0.00 500.00

0.00 0.00 0.00 125.000.00 0.00 0.00 453.110.00 0.00 0.00 2,718.65

105.00 105.00 105.00 315.00150.00 150.00 150.00 450.00210.00 210.00 210.00 630.00283.33 283.33 283.33 850.00516.67 516.67 516.67 1,550.00

1,450.00 1,450.00 1,450.00 4,350.00

0.00 0.00 0.00 216,907.380.00 0.00 0.00 198,370.730.00 0.00 0.00 32,683.010.00 0.00 0.00 21,703.38

0.00 0.00 0.00 0.000.00 0.00 0.00 0.000.00 0.00 0.00 0.00

775.00 775.00 775.00 13,950.00775.00 775.00 775.00 13,950.00155.00 155.00 155.00 1,550.00

0.00 0.00 0.00 750.00500.00 0.00 0.00 1,250.00

1,000.00 0.00 0.00 2,500.000.00 0.00 0.00 533.07

83.33 83.33 83.33 1,500.00

833.33 833.33 833.33 2,500.00650.00 650.00 650.00 7,800.00500.00 500.00 500.00 1,500.00

0.00 4,375.00 4,375.00 8,750.000.00 2,625.00 2,625.00 5,250.000.00 3,875.00 3,875.00 7,750.00

2,797.24 2,797.24 0.00 33,566.884,068.71 4,068.71 4,068.71 44,755.84

1,523.05 1,523.05 1,523.05 10,661.38761.53 761.53 761.53 5,330.69300.00 300.00 300.00 2,100.00

2,486.44 2,486.44 2,486.44 44,755.84658.17 658.17 658.17 11,188.96

20,581.81 29,956.81 27,159.57 1,049,234.97

1,557.77 2,030.27 1,526.77 86,917.89

22,139.58 31,987.08 28,686.34 1,136,152.86

28,697.36 52,515.45 56,458.70 175,243.21 1,557.77 2,030.27 1,526.77

27,139.59 50,485.17 54,931.93 153,451.11 0.00 0.00 0.00

-27,139.59 -50,485.17 -54,931.93 17,091.78 -33,393.39 -88,325.33

17,091.78 -33,393.39 -54,931.93

0.00 33,393.39 54,931.93 88,325.33

115311.43991 166064.44303 182817.44249-47160.78284 118903.66019 301721.10268

0.00 118,903.66 182,817.44

433,650.64 636,020.40 693,009.75 2,237,791.83 22,139.58 184,284.14 266,435.71 1,526,199.29

411,511.06 451,736.26 426,574.03 711,592.55 -166,717.75 285,018.52 711,592.55


411,511.06 451,736.26 426,574.03 711,592.55 -166,717.75 285,018.52 711,592.55

705,167.86 705,167.86 705,167.86 705,167.86 411,511.06 451,736.26 426,574.03 1,409,183.76

411,511.06 451,736.26 426,574.03 704,015.91 -174,294.39 277,441.87 704,015.91

0.00 0.00 0.00 190,763.90 0.00 0.00 0.00 0.00 0.00 0.00 7,576.64 0.00 0.00 0.00 190,763.90

411,511.06 451,736.26 426,574.03 1,409,183.76 411,511.06 451,736.26 426,574.03

CUENTA DE RESULTADOS

Cuenta de Pérdidas y Ganancias

CONCEPTO TOTAL US$

INGRESOS 2,062,548.62

Por venta de Departamentos y Estacionamientos 2,062,548.62

EGRESOS 952,820.18

Terreno 330,880.00 Estudios y Proyectos 15,356.04 Aprobaciones y Licencias 11,441.76 Construcción 469,664.51 Gastos Administrativos 35,983.07 Post Construcción 11,800.00 Titulación 21,750.00 Gerencia de Proyectos 55,944.80

UTILIDAD BRUTA (EBITDA) 1,109,728.44

Publicidad y Ventas (Comercialización) 78,322.71

UTILIDAD DE OPERACIÓN (BAII) 1,031,405.73

Gastos Bancarios y Financieros 25,668.72

UTILIDAD FINANCIERA (BAI) 1,005,737.01

Impuesto de Sociedades ( A la renta) 301,721.10 Impuesto de Sociedades Acumulado

UTILIDAD NETA (BDI) 704,015.91

ANÁLISIS DE RENTABILIDAD98.30%50.01%99.84%

Repercusión del suelo sobre ventas 16.04%Repercusión del suelo sobre sup. Construida (US$ / m2) 381.35

Rentabilidad sobre la inversión (Egresos) - ROI (Return on investment)Rentabilidad sobre las ventas (Ingresos) - ROS (Return on sales)Rentabilidad financiera (Fondos Propios promotor) - ROE (Return on equity)

Apro

b. P

roye

cto

Inic

io d

e ob

ra

Mes1 Mes2 Mes3 Mes4 Mes5 Mes6 Mes7ANTEPROYECTO PROYECTO CONSTRUCCIÓN

PRE VENTAS0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

335,749.77 9,195.06 9,296.62 6,816.93 8,616.95 9,150.02 47,697.75

330,880.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,839.01 3,839.01 0.00 3,839.01 3,839.01 0.00 0.00 578.11 679.66 2,038.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 42,269.81

2,383.33 1,633.33 1,633.33 1,633.33 1,633.33 2,166.40 1,633.33 0.00 0.00 0.00 0.00 0.00 0.00 650.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2,486.44 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61

-335,749.77 -9,195.06 -9,296.62 -6,816.93 -8,616.95 -9,150.02 -47,697.75

0.00 0.00 0.00 0.00 0.00 2,797.24 2,797.24

-335,749.77 -9,195.06 -9,296.62 -6,816.93 -8,616.95 -11,947.26 -50,494.99

0.00 0.00 0.00 0.00 0.00 0.00 0.00

-335,749.77 -9,195.06 -9,296.62 -6,816.93 -8,616.95 -11,947.26 -50,494.99

-100,724.93 -2,758.52 -2,788.99 -2,045.08 -2,585.09 -3,584.18 -15,148.50 -100,724.93 -103,483.45 -106,272.43 -108,317.51 -110,902.60 -114,486.78 -129,635.28

-235,024.84 -6,436.54 -6,507.63 -4,771.85 -6,031.87 -8,363.08 -35,346.49

Com

pra

del

terr

eno

/Ant

epro

yect

o

Apro

b.

Ante

proy

ecto

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

Des

arro

llo d

e Es

peci

alid

ades

Obr

a m

es 2

Obr

a m

es 3

Obr

a m

es 4

Obr

a m

es 5

Obr

a m

es 6

Obr

a m

es 7

Obr

a m

es 8

Mes8 Mes9 Mes10 Mes11 Mes12 Mes13 Mes14CONSTRUCCIÓN

VENTAS0.00 0.00 0.00 0.00 0.00 0.00 83,455.05

0.00 0.00 0.00 0.00 0.00 0.00 83,455.05

68,734.33 66,639.33 61,942.68 61,942.68 29,066.17 61,942.68 61,942.68

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

61,056.39 61,056.39 56,359.74 56,359.74 23,483.23 56,359.74 56,359.74 3,883.33 1,788.33 1,788.33 1,788.33 1,788.33 1,788.33 1,788.33

650.00 650.00 650.00 650.00 650.00 650.00 650.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61 3,144.61

-68,734.33 -66,639.33 -61,942.68 -61,942.68 -29,066.17 -61,942.68 21,512.36

6,865.95 6,865.95 6,865.95 6,865.95 6,865.95 6,865.95 6,865.95

-75,600.28 -73,505.28 -68,808.64 -68,808.64 -35,932.12 -68,808.64 14,646.41

0.00 0.00 0.00 442.28 3,777.74 4,660.16 5,179.75

-75,600.28 -73,505.28 -68,808.64 -69,250.92 -39,709.86 -73,468.79 9,466.66

-22,680.08 -22,051.58 -20,642.59 -20,775.28 -11,912.96 -22,040.64 2,840.00 -152,315.36 -174,366.94 -195,009.54 -215,784.81 -227,697.77 -249,738.41 -246,898.41

-52,920.20 -51,453.70 -48,166.05 -48,475.64 -27,796.90 -51,428.16 6,626.66

Fin

de O

bra

Entr

ega

Mes15 Mes16 Mes17 Mes18CONSTRUCCIÓN

VENTAS CONFORMIDAD Y ENTREGA354,084.30 404,953.28 583,504.95 636,551.05

354,084.30 404,953.28 583,504.95 636,551.05

61,942.68 11,131.28 20,506.28 20,506.28

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,715.00 2,715.00 2,715.00

56,359.74 0.00 0.00 0.00 1,788.33 3,288.33 1,788.33 1,788.33

650.00 1,983.33 1,983.33 1,983.33 0.00 0.00 10,875.00 10,875.00

3,144.61 3,144.61 3,144.61 3,144.61

292,141.62 393,822.00 562,998.68 616,044.77

6,865.95 6,865.95 6,865.95 4,068.71

285,275.66 386,956.05 556,132.73 611,976.06

3,855.04 2,584.58 2,584.58 2,584.58

281,420.62 384,371.47 553,548.14 609,391.47

84,426.19 115,311.44 166,064.44 182,817.44 -162,472.22 -47,160.78 118,903.66 301,721.10

196,994.43 269,060.03 387,483.70 426,574.03

Conf

orm

idad

de

obra

Conf

orm

idad

de

obra

ESTRUCTURACIÓN FINANCIERA

ESTRUCTURA DEL PROYECTOVenta total 2,237,791.83Costos sin financieros 1,136,152.86Financieros 7,576.64Costo Total del proyecto 1,143,729.50Margen del proyecto 1,094,062.33

INVERSIÓN REQUERIDACosto total del proyecto 1,143,729.50Aporte del Promotor 705,167.86Cuotas iniciales 247,797.74Desembolso créditos clientes 0.00Financiamiento Bancario 190,763.90

ESTRUCTURA DEL FINANCIAMIENTO BANCARIOLínea directa 190,763.90Línea Créditos clientes 0.00

ESTRUCTURA DEL CAPITALAporte del promotor 705,167.86 61.66%Cuotas iniciales y créditos clientes 247,797.74 21.67%Línea directa financiamiento bancario 190,763.90 16.68%

Resumen de Ingresos y Egresos

Ingresos 101 213,070.00102 115,401.83201 185,790.00202 269,040.00301 185,790.00302 269,040.00401 185,790.00402 269,040.00501 185,790.00502 269,040.00E 1 30,000.00E 2 30,000.00E 3 30,000.00

Total 2,237,791.83

EgresosBanco 198,340.54Gastos Bancarios 7,753.75Dpto 302 269,040.00Dpto 202 269,040.00E1 30,000.00Gastos de Publicidad 44,755.84Gastos Entrega 82,813.00Impuesto de sociedades 301,721.10IGV 88,325.33Deuda Interbank 230,000.00Deuda Caja Huancayo 40,000.00Saldo Terreno 30,000.00Deuda Tochi 50,000.00Deuda Yo 35,000.00Total 1,676,789.56

Saldo o Ganancia 561,002.28

ANÁLISIS DE SENSIBILIDAD

COSTO DEL SOLAR

Variación Costo (US$/M2) VAN-E (US$) TIR-E

-12.00% 202.40 386,714.73 662,510.54 50.28%-9.00% 209.30 399,898.18 649,327.09 48.93%-6.00% 216.20 413,081.64 636,143.63 47.62%-3.00% 223.10 426,265.10 622,960.17 46.36%0.00% 230.00 439,448.55 609,776.72 45.14%3.00% 236.90 452,632.01 596,593.26 43.95%6.00% 243.80 465,815.47 583,409.80 42.81%9.00% 250.70 478,998.92 570,226.35 41.69%

12.00% 257.60 492,182.38 557,042.89 40.62%

PRECIO DE VENTA

Variación Flats (US$/M2) Dúplex (US$/M2) VAN-E (US$) TIR-E

-17.42% 495.48 536.77 212.36 12.01%-12.00% 528.00 572.00 196,870.21 22.99%

-9.00% 546.00 591.50 293,797.45 28.29%-6.00% 564.00 611.00 414,410.38 34.82%-3.00% 582.00 630.50 512,093.55 40.01%0.00% 600.00 650.00 609,776.72 45.14%3.00% 618.00 669.50 707,459.88 50.19%6.00% 636.00 689.00 825,351.68 56.26%9.00% 654.00 708.50 939,762.68 61.84%

12.00% 672.00 728.00 1,046,536.06 67.03%


Variación Costo (US$/M2) VAN-E (US$) TIR-E

-12.00% 205.50 2,290,098.34 873,791.21 60.76%-9.00% 212.50 2,368,169.87 807,787.58 56.79%-6.00% 219.51 2,446,241.40 741,783.96 52.87%-3.00% 226.51 2,524,312.94 675,780.34 48.98%0.00% 233.52 2,602,384.47 609,776.72 45.14%3.00% 240.53 2,680,456.01 543,773.09 41.33%6.00% 247.53 2,758,527.54 477,769.47 37.58%9.00% 254.54 2,836,599.07 411,765.85 33.87%

12.00% 261.54 2,914,670.61 345,762.23 30.22%27.71% 298.23 3,323,505.21 123.26 12.01%

COSTO SOLAR (US$)

Costo Construcción

(US$)

VAN (US$) COSTO DE CONSTRUCCIÓNVariación -9% -6% -3% 0% 3%

PREC

IO D

E VE

NTA

-12% 394,881.08 328,877.45 262,873.83 196,870.21 130,866.59 -9% 491,808.32 425,804.69 359,801.07 293,797.45 227,793.83 -6% 612,421.25 546,417.63 480,414.01 414,410.38 348,406.76 -3% 710,104.42 644,100.79 578,097.17 512,093.55 446,089.93 0% 807,787.58 741,783.96 675,780.34 609,776.72 543,773.09 3% 905,470.75 839,467.13 773,463.50 707,459.88 641,456.26 6% 1,023,362.54 957,358.92 891,355.30 825,351.68 759,348.05 9% 1,137,868.87 1,071,769.93 1,005,766.31 939,762.68 873,759.06

TIR (%) COSTO DE CONSTRUCCIÓNVariación -9% -6% -3% 0% 3%

PREC

IO D

E VE

NTA

-12% 34.58% 30.66% 26.80% 22.99% 19.24%-9% 39.91% 35.98% 32.11% 28.29% 24.53%-6% 46.47% 42.54% 38.66% 34.82% 31.04%-3% 51.67% 47.74% 43.86% 40.01% 36.22%0% 56.79% 52.87% 48.98% 45.14% 41.33%3% 61.85% 57.93% 54.04% 50.19% 46.39%6% 67.92% 64.00% 60.11% 56.26% 52.44%9% 73.46% 69.55% 65.68% 61.84% 58.04%

COSTO SOLAR VAN-E (US$) TIR-E330,880.00 496,843.71 90.93%

VAN-E (US$) TIR-E496843.706 90.93%

Costo ConstrucVAN-E (US$) TIR-E533,069.22 496843.706 90.93%

COSTO DE CONSTRUCCIÓN6% 9% 12%

64,862.96 -1,140.66 -67,144.28 161,790.20 95,786.58 29,782.96 282,403.14 216,399.52 150,395.89 380,086.30 314,082.68 248,079.06 477,769.47 411,765.85 345,762.23 575,452.64 509,449.01 443,445.39 693,344.43 627,340.81 561,337.19 807,755.44 741,751.82 675,748.19

COSTO DE CONSTRUCCIÓN6% 9% 12%

15.56% 11.94% 8.39%20.82% 17.17% 13.59%27.30% 23.63% 20.01%32.47% 28.78% 25.14%37.58% 33.87% 30.22%42.62% 38.91% 35.24%48.67% 44.94% 41.25%54.27% 50.55% 46.86%

INGRESOS VS. TIEMPO1 2 3 4

INGRESOS 0.00 0.00 0.00 0.00

EGRESOS VS. TIEMPO1 2 3 4

EGRESOS 336,178.77 10,180.08 10,281.64 7,110.93

FLUJO ECONÓMICO VS TIEMPO1 2 3 4

Saldo Mensual -336,178.77 -10,180.08 -10,281.64 -7,110.93 Acumulado -336,178.77 -346,358.85 -356,640.49 -363,751.43

FLUJO DEL INVERSIONISTA VS TIEMPO1 2 3 4

Flujo del Inversionista -336,178.77 -10,180.08 -10,281.64 -7,110.93 Acumulado -336,178.77 -346,358.85 -356,640.49 -363,751.43

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00

FLUJO DE INGRESOS

TIEMPO (Meses)

INGR

ESO

S US

$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00

FLUJO DE INGRESOS Y EGRESOS VS TIEMPO

INGRESOS EGRESOS

TIEMPO (Meses)

INGR

ESO

S - E

GRES

OS

US$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00


INGRESOS EGRESOS

TIEMPO (Meses)

INGR

ESO

S - E

GRES

OS

US$

5 6 7 8 9 10 11 120.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

5 6 7 8 9 10 11 129,601.98 13,435.79 56,998.92 85,372.76 83,305.66 77,974.97 77,974.97 43,244.71

5 6 7 8 9 10 11 12-9,601.98 -13,435.79 -56,998.92 -85,372.76 -83,305.66 -77,974.97 -77,974.97 -43,244.71

-373,353.40 -386,789.19 -443,788.10 -529,160.87 -612,466.53 -690,441.51 -768,416.48 -811,661.19

5 6 7 8 9 10 11 12-9,601.98 -13,435.79 -56,998.92 -85,372.76 -83,305.66 -77,974.97 -14,726.35 0.00

-373,353.40 -386,789.19 -443,788.10 -529,160.87 -612,466.53 -690,441.51 -705,167.86 -705,167.86

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00

FLUJO DE INGRESOS

TIEMPO (Meses)

INGR

ESO

S US

$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

50,000.00

100,000.00

150,000.00

200,000.00

250,000.00

300,000.00

350,000.00

400,000.00

FLUJO DE EGRESOS

TIEMPO (Meses)

EGRE

SOS

US$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00


INGRESOS EGRESOS

TIEMPO (Meses)

INGR

ESO

S - E

GRES

OS

US$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

100,000.00

200,000.00

300,000.00

400,000.00

500,000.00

600,000.00

700,000.00

800,000.00


INGRESOS EGRESOS

TIEMPO (Meses)

INGR

ESO

S - E

GRES

OS

US$

13 14 15 16 17 180.00 90,966.00 384,145.05 433,650.64 636,020.40 693,009.75

13 14 15 16 17 1880,559.56 80,559.56 80,559.56 22,139.58 31,987.08 28,686.34

13 14 15 16 17 18-80,559.56 10,406.44 303,585.49 411,511.06 451,736.26 426,574.03

-892,220.75 -881,814.30 -578,228.81 -166,717.75 285,018.52 711,592.55

13 14 15 16 17 180.00 0.00 119,362.41 411,511.06 451,736.26 426,574.03

-705,167.86 -705,167.86 -585,805.45 -174,294.39 277,441.87 704,015.91

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 180.00

50,000.00

100,000.00

150,000.00

200,000.00

250,000.00

300,000.00

350,000.00

400,000.00

FLUJO DE EGRESOS

TIEMPO (Meses)

EGRE

SOS

US$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-1,000,000.00

-800,000.00

-600,000.00

-400,000.00

-200,000.00

0.00

200,000.00

400,000.00

600,000.00

800,000.00

FLUJO ECONÓMICO (MENSUAL - ACUMULADO)

SALDO MENSUAL SALDO ACUMULADO

TIEMPO (Meses)

FLUJ

O E

CONÓ

MIC

O U

S$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-1,000,000.00

-800,000.00

-600,000.00

-400,000.00

-200,000.00

0.00

200,000.00

400,000.00

600,000.00

800,000.00

FLUJO ECONÓMICO (MENSUAL - ACUMULADO)


TIEMPO (Meses)

FLUJ

O E

CONÓ

MIC

O U

S$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-800,000.00

-600,000.00

-400,000.00

-200,000.00

0.00

200,000.00

400,000.00

600,000.00

800,000.00

FLUJO FINANCIERO (PROMOTOR)


TIEMPO (Meses)

FLUJ

O F

INAN

CIER

O U

S$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-800,000.00

-600,000.00

-400,000.00

-200,000.00

0.00

200,000.00

400,000.00

600,000.00

800,000.00

FLUJO FINANCIERO (PROMOTOR)


TIEMPO (Meses)

FLUJ

O F

INAN

CIER

O U

S$

PUNTO DE EQUILIBRIOPROYECTO 1 (DEPARTAMENTOS)

Variable

Precio del Solar 230.00 565.35 245.80%Precio de Venta 600,00 / 650,00 495,48 / 536,77 82.58%Costo de Construcción 233.52 298.23 127.71%

PROYECTO 2 (CASAS)

Variable

Precio del Solar 230.00 300.61 130.70%Precio de Venta 715.00 641.07 89.66%Costo de Construcción 233.52 279.94 119.88%

Valor inicial (US$/m2)

Valor VANe=0 (US$/m2)

Valor Porcentual

Valor inicial (US$/m2)

Valor VANe=0 (US$/m2)

Valor Porcentual

PUNTO DE EQUILIBRIOPROYECTO 1 (DEPARTAMENTOS)

145.80%-17.42% -12%

27.71% 9%

PROYECTO 2 (CASAS)

30.70%-10.34% -9%19.88% 3%

Variación Porcentual

Variación de CC VS.

PV* VANe≤0

Variación Porcentual

Variación de CC VS.

PV* VANe≤0

Documents

Flujo Economico Financiero Gerencia de La Construccion