INFO PROYECTO 10.1 INFORMACIÓN GENERAL DEL PROYECTO - LINEA ACTUALIZADA Promotor : INVEB INMOBILIARIA SAC Constructora : INVEB SAC Proyecto: URBAN COLLECTION MAGDALENA Distrito / Ciudad: Magdalena/Lima Dirección: Jr. Echenique Mz / Lote / N° 623-611 Sec/ Etapa/Zona Urb. DATOS DE DISEÑO Terreno - áreas Unidades inmobiliarias Area Total Terreno (m2) 1,076.00 # Edificios del proyecto 1.00 Area Aportes (m2) - 0 # Pisos por edificio 10.00 Area de vías (m2) - 0 # unidades por piso 9.00 Area neta del terreno (m2) 1,076.00 # Unidades en proyecto 81.00 # Estacionamientos 62.00 Techado 54.00 Area techada vendible (m2) 6,462.15 Sin techar 8.00 Area s comunes y libres (m2) 158.54 # Depósitos 37.00 Areas sótanos (m2) 2,246.82 # Comercio 8.00 Area construida Total (m2) 8,867.51 Total unidades inmobiliarias 188.00 I. DETALLE DE INGRESOS Nº Total m2 Precio x m2 Monto US$ Vivienda 81 5,115.47 1,396.36 7,238,630.46 85% Departamento flat 75 4,574.38 1,352.69 6,187,732.81 Departamento dúplex 6 541.09 1,942.19 1,050,897.65 Comercio 8 458.38 1,000.00 458,380.00 5% Estacionamientos 62 849.74 826.00 703,500.00 8% Techado 54 749.74 847.63 635,500.00 No techado 8 100.00 680.00 68,000.00 Otros 37 138.56 900.00 124,704.00 1% Depósito 37 138.56 900.00 124,704.00 TOTAL 188 6,562.15 4,122.36 8,525,214.46 100% II. INVERSIÓN (Cifras en US$) % Unitarios $/m2 Terreno (incluye valor de terreno, alcabala, etc) 2,104,999 28.1% 1,956.32 Construcción Costo directo + equipamiento (Incl. IGV) 4,036,693.52 53.9% 455.22 Costo Directo Casco 2,632,490.36 Costo Directo Acabados 1,215,905.00 Equipamiento 142,780.00 Póliza CAR 7,982.35 Conexiones de Agua y Desagüe (Sedapal) 7,080.00 Medidores de Luz 30,455.80 Gastos Generales y Utilidad Constructora 478,941.04 VALOR TOTAL (m2 útil) 4,515,635 60.3% Costos indirectos Honorarios del proyecto 36,381 0.49% 97.36 Gastos Notariales, Licencias y Titulación 72,145 0.96% Publicidad y comisión de ventas 234,482 3.13% Gastos administrativos 294,000 3.93% Gastos financieros y comisiones 226,301 3.02% Total Otros 863,309 11.5% TOTAL INVERSIÓN 7,483,943 100.0% III. UTILIDAD Y RENTABILIDAD US$ Utilidad antes de Impuestos 1,041,271.54 Rentabilidad Bruta 12.2% Impuesto a la Renta 291,556.03 Utilidad despues de Impuestos 749,715.51 Rentabilidad Sobre Ventas 8.8% Sobre Inversión Total 10.0% Sobre Aporte 29.4% IV. ESTRUCTURA DE FINANCIAMIENTO Aporte Propio 2,550,496 34.1% Aporte Banco 2,381,604 31.8% Pre - Ventas 2,551,843 34.1% INVERSIÓN TOTAL 7,483,943 100.0% Estudio de Ejemplo Cuadro de Sondeo de Mercado de Pueblo libre CARACTERÍSTICAS E - 1 E - 2 E-3 E-4 E-5 E- 6 E-7 E-8 E-9 E - 10 E-11 E-12 E- 13 Edificio San Felipe Condominio Circolo Edificio Alto mirador 2 Concepto Atlantis Residencial Arboleda casa club Edificio alcala Residencial La mar IV Edificio mirador el carmen II Pasos de los andes Residencial Edificio Libertad Edificio del parque Edificio conquistador Condominio parque san martin Av. San Felipe 164 Jesus Maria Jr. Gral Pedro Morales Bermudez 480 Pueblo Libre Av. Brasil 1399 Av. Universitaria esq. La mar Pueblo libre Av. Mariano cornejo 1433 pueblo libre Av. Antonio de sucre 1355 pueblo libre Av. La mar 1430 pueblo libre Jr. General clovis 717 pueblo libre Av. Paso de los andes 380/382 Pueblo libre Jr. 8 de octubre 496 Alt. 13 de sucre Jr. America 198 entre 12 y 13 de la Av. Bolivar pueblo libre Jr. Jose ramon pizarro (valle riestra) 680 pueblo libre Jr. Bernardo o'higgins (antes andalucia) 281 pueblo libre Telef: (511) 650-9749 Nextel 826*7679 Telef: 423-4969 Cel. 945019879 Telef: 4333494 Telef: 717-2000 Cel. 99358-5227 Telef: 625-0210 Cel. 993281909 Telef: 460 2493 Telef:796 7519 cel. 989 758 392 Telef: 785 6059 cel: 980 244 340 Telef: 261-3525 Cel. 9924 85407 Telef: 989 079 765 Telef:460 5223 Telef: 261 1871 Cel. 99408*1819 Telf.:481 2929 cel.: 997 108 149 www.mcinmobiliaria.com.pe www.dominiigrupoinmobiliario.com www.casaideal.com.pe www.imagina.com.pe www.ciudaris.com www.edificacionesinmobiliarias.com www.inversionesgdp.com www.dominiigrupoinmobiliario.com www.serviprosrl.com www.parametros.com.pe www.edificacionesinmobiliarias.com www.inmobiliariamundoverde.com Datos generales Nombre del proyecto Edificio San Felipe Condominio Circolo Edificio Alto Mirador 2 Concepto Atlantis Residencial Arboleda casa club Edificio alcala Residencial la mar iv Edificio mirador el carmen II Pasos de los andes Residencial Edificio Libertad Edificio del parque Edificio conquistador Condominio parque san martin Empresa Inmobiliaria Inmobiliaria San Felipe SAC Domini Grupo Inmobiliario Casa Ideal Imagina Promotora y constructora ciudaris s.a. Edificaciones Inmobiliarias S.A.C Inversiones giraldo del portal Dominii grupo inmobiliario Construye y promueve servipro s.r.l. Parametros Edificaciones inmobiliarias S.A.C Inmobiliaria mundo verde s.a.c k y b contratists generales Empresa constructora Inversiones Inmobiliaria SAC Domini Grupo Inmobiliario Casa Ideal Imagina Promotora y constructora ciudaris s.a. Edificaciones Inmobiliarias S.A.C Inversiones giraldo del portal Dominii grupo inmobiliario Construye y promueve servipro s.r.l. Parametros Edificaciones inmobiliarias S.A.C Inmobiliaria mundo verde s.a.c k y b contratists generales Entidad que financia BIF Por Definir Banco BCP Interbank Interbank Continental BCP Incasa Continental Continetal Continental Continental scotiabank Tiene caseta de ventas (si-no) SI Si Si Si Si Si Si SI Si Si Si Si SI Tiene departamentos piloto (si-no) No Si No SI si No No NO No NO No No NO Datos específicos Número de torres 2 1 1 4 1 2 1 1 1 1 1 1 2 Número de pisos 20 10 20 20 20 16 13 10 8 6 8 6 5 Número de unidades inmobiliarias 48 20 100 14 96 46 24 31 16 12 16 12 20 Número de sotanos y semi sotanos 0% 0% 0% sotano y sst 1 sotano 0% 1 semi sotano Área promedio ocupada de los departamentos 91 m2 82 m2 81.27 m2 Aprox. 88 m2 80 m2 80 m2 110 m2 79 m2 192 m2 Duplex 88.50 m2 86 m2 185 m2 duplex 98 M2 Área promedio techada de los departamentos 91 m2 82 m2 81.27 m2 Aprox. 88 m2 80 m2 80 m2 110 m2 79 m2 192 m2 Duplex 88.50 m2 86 m2 185 m2 duplex 98 M2 Número de dormitorios 3 3 3 3 3 3 3 3 3 3 3 3 3 Número de baños 2.00 2.00 2.00 2.00 2.00 2 3.00 2.00 2.00 2.00 2.00 3.00 2 Dormitorio empleada (si-no) si No No si No No No NO si No No No NO Baño de servicio(si-no) Si No NO si No No No NO si No NO No NO Número de cocheras si 443 SI si 11 9 SI Número de dépositos si 253 Número de ascensores 2 ascensores 2 ascensores 2 ascensores 2 ascensores 2 ascensores 2 ascensor 1 ascensor 1 ascensor 2 ascensores 1 ascensor ascensor ascensore No tiene ascensor Acabados Pisos Laminados Laminados Laminados Laminados Ceramico celima ceramicos Laminados Laminados ceramico celima piso parquet coricaspi oscuro Laminados Muebles de cocina Muebles altos y bajos en melamine Cocina amoblada con tablero de granito Muebles altos y bajos en melamine Cocina equipada con muebles bajos en melamina Tableros de granito Muebles bajos Muebles altos y bajos con table. Post. Formado Muebles altos y bajos en melamine Porcelanato Muebles altos y bajos en melamine Muebles bajos Muebles altos y bajos en melamine Muebles bajos en melamine Muebles bajos Muebles de baño Enchape cerámico Cocina amoblada con tablero de granito Cerámica Piso ceramico y lavadero de pedestal Cerámica Lavatorios e inodoros blancos marca trebol Melamine Cerámica Ceramica los inodoros modelos sifon-jet sistema dual Cerámica Closets Melamine Melamine Melamine Melamine Melamine Melamine Puertas y maleteros Melamine Melamine Sanitarios Cerámica Porcelanato Cerámica Cerámica Modelo sifon-jet y griferia marca italgrif Puertas Ventanas Tina Otros Precios de venta Precio de venta de departamento 303850 Recepcion: Recepcion: duplex 8 piso 363.140 nuevos soles $ 94,300.00 271000 Recepcion: Recepcion 3 piso 279.800 piso interior 80mt2 12 al 16 263.900 vista la Av. Brasil Favio: Favio: 315416 Recepcion: Recepcion: no exicte ese numero 230000 Recepcion: Recepcion: 13 piso 242.000 soles Entrega 28 febrero 17 piso 233.200 soles 8 piso 211.750 soles 3 dormitorios vista interna 212800 Recepcion: Recepcion: no exicte el numero $ 120,000 Recepcion: Recepcion: no contestan Recepcion: Recepcion: duplex 8 piso 363.140 nuevos soles $ 98,750 397450 $ 76,000.00 276600 445000 245000 Precio de venta de estacionamiento $ 10,000.00 Incluido en el precio del dpto 18900 S/. 18,000 y s/. 20,000 s/. 18,000.00 $ 8,500 $ 10,000 19250 19000 s/. 24,000 23800 19600 Precio de venta de déposito Precio promedio por m2 de área ocupada $US 1,245.00 $us 1,150 $us 1,244 $us 1,337 $us 1,072 $US 992.53 $US 1,090 $US 1,250 $US 772.40 $US 858.75 $US 1,200 $US 897.53 $US 932.83 Precio promedio por m2 de área libre Velocidad de ventas 5 al mes 4 al mes 10 al mes 4 al mes 10 al mes 3 al mes Fecha de inicio del proyecto Apr-12 Jan-12 Fecha de inicio de pre ventas Fecha de entrega de de los departamentos Jul-12 Mar-13 Dec-12 2do semestre del 2013 Jun-13 Mar-13 Apr-13 Mar-13 May-12 Dec-12 Dec-12 Aug-12 Dec-12 Número de departamentos que quedan a la fecha 5 ultimos departamentos 9 15 2 3 4 Número de estacionamientos que quedan a la fecha 13 2 2 2 Número de dépositos que quedan a la fecha Comentarios u observaciones Piscina con terraza y area de parrilla.Acabados de primera Amplia recepcion y rampa para discapasitados Piscina con vista panorámica, terraza con BBQ y gimnacio equipado Sala Home theater,piscina con tobogan y gimnasio Salon social y sala de niños Sala de reuniones Ascensor con apertura directa a los Dptos. Acabados de primera Plataforma o elevador para discapacitados Todos los departamentos tiene vista a la calle Terraza con vista al parque Cocheras techadas en semi sotano Amplias areas comnes Acumula KMS LANPASS Tienen promociones(si-no), cuales? No No No No No No No NO No No NO Fecha de realización del levantamiento 2/28/12 2/28/12 2/28/12 2/28/12 2/29/12 2/29/12 2/29/12 2/29/12 2/29/12 2/29/12 2/29/12 8/29/12 2/29/12 Nombre de la persona que levantó la información Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Cesar Diaz Dpto. Piloto NO SI NO SI SI NO NO NO NO NO NO NO NO Areas Comunes SI NO SI SI SI NO NO NO NO NO NO NO NO Gas Calidda SI NO SI SI SI NO NO NO NO SI NO NO SI http://www.dominiigrupoinmobiliario.com/http://www.mcinmobiliaria.com.pe/http://www.casaideal.com.pe/http://www.imagina.com.pe/http://www.edificacionesinmobiliarias.com/http://www.ciudaris.com/http://www.inversionesgdp.com/http://www.dominiigrupoinmobiliario.com/ CUADRO DE VENTAS 10.2 RELACION Y PRECIO DE LOS INMUEBLES - LINEA ACTUALIZADA Proyecto: URBAN COLLECTION MAGDALENA (Expresado en Dólares Americanos) Actualizacion 3/21/16 VIVENDA Piso Dpto. Area Techada (m2) Area No techada (m2) Area Ocupada (m2) Valor de Venta terreno (US$) Valor de Venta fábrica (US$) IGV US$ Precio de Venta US$ Precio de Venta (US$/m2) Ubicación Separado Prevendido 1327.54 Permuta Valor Venta Final Departamento flat 2 201 63.9 17.8 81.7 48,101.7 48,101.7 8,658.3 104,861.7 1,440.1 Exterior 1.0847966936 356,529.72 Departamento flat 2 202 66.9 - 0 66.9 39,770.6 39,770.6 7,158.7 86,700.0 1,295.4 Exterior 1 1 1.0847966936 86,700.0 294,780.00 Departamento flat 2 203 67.3 - 0 67.3 42,362.4 42,362.4 7,625.2 92,350.0 1,373.2 Exterior 1 1 1.0847966936 92,350.0 313,990.00 Departamento flat 2 204 40.0 - 0 40.0 24,954.1 24,954.1 4,491.7 54,400.0 1,359.0 Exterior 1 1 1.0847966936 54,400.0 184,960.00 Departamento flat 2 205 72.1 24.7 96.7 50,160.6 50,160.6 9,028.9 109,350.0 1,295.7 Exterior 1 1 1.0847966936 109,350.0 371,790.00 Departamento flat 2 206 55.6 33.8 89.4 47,391.8 47,391.8 8,530.5 103,314.1 1,425.7 Interior 1.0739487266 Departamento flat 2 207 65.2 27.2 92.4 51,518.5 51,518.5 9,273.3 112,310.3 1,425.7 Interior 1.0739487266 Departamento flat 2 208 66.3 50.2 116.5 59,765.4 59,765.4 10,757.8 130,288.5 1,425.7 Interior 1.0739487266 Departamento flat 2 209 55.4 33.5 88.9 47,195.6 47,195.6 8,495.2 102,886.4 1,425.7 Interior 1.0739487266 Departamento flat 3 301 63.9 63.9 41,807.6 41,807.6 7,525.4 91,140.5 1,425.9 Exterior 1.0740561322 Departamento flat 3 302 66.9 66.9 43,776.3 43,776.3 7,879.7 95,432.3 1,425.9 Exterior 1.0740561322 Departamento flat 3 303 67.3 67.3 43,985.6 43,985.6 7,917.4 95,888.6 1,425.9 Exterior 1.0740561322 Departamento flat 3 304 40.0 40.0 25,000.0 25,000.0 4,500.0 54,500.0 1,361.5 Exterior 1 1 1.0740561322 54,500.0 Departamento flat 3 305 72.1 72.1 47,138.2 47,138.2 8,484.9 102,761.2 1,425.9 Exterior 1.0740561322 Departamento flat 3 306 55.6 55.6 35,989.2 35,989.2 6,478.1 78,456.4 1,411.6 Interior 1.0633155709 Departamento flat 3 307 65.2 65.2 42,205.4 42,205.4 7,597.0 92,007.7 1,411.6 Interior 1 1.0633155709 Departamento flat 3 308 66.3 66.3 42,917.6 42,917.6 7,725.2 93,560.4 1,411.6 Interior 1.0633155709 Departamento flat 3 309 55.4 55.4 35,898.5 35,898.5 6,461.7 78,258.8 1,411.6 Interior 1 1.0633155709 Departamento flat 4 401 63.9 63.9 41,393.6 41,393.6 7,450.9 90,238.1 1,411.7 Exterior 1.0634219131 Departamento flat 4 402 66.9 66.9 43,342.9 43,342.9 7,801.7 94,487.4 1,411.7 Exterior 1.0634219131 Departamento flat 4 403 67.3 67.3 43,550.1 43,550.1 7,839.0 94,939.2 1,411.7 Exterior 1.0634219131 Departamento flat 4 404 40.0 40.0 25,922.8 25,922.8 4,666.1 56,511.8 1,411.7 Exterior 1.0634219131 Departamento flat 4 405 72.1 72.1 46,671.4 46,671.4 8,400.9 101,743.8 1,411.7 Exterior 1.0634219131 Departamento flat 4 406 55.6 55.6 35,632.8 35,632.8 6,413.9 77,679.6 1,397.6 Interior 1.052787694 Departamento flat 4 407 65.2 65.2 41,787.5 41,787.5 7,521.7 91,096.7 1,397.6 Interior 1.052787694 Departamento flat 4 408 66.3 66.3 42,492.7 42,492.7 7,648.7 92,634.1 1,397.6 Interior 1.052787694 Departamento flat 4 409 55.4 55.4 35,543.1 35,543.1 6,397.8 77,483.9 1,397.6 Interior 1.052787694 Departamento flat 5 501 63.9 63.9 40,983.8 40,983.8 7,377.1 89,344.7 1,397.8 Exterior 1.0528929833 Departamento flat 5 502 66.9 66.9 42,913.7 42,913.7 7,724.5 93,551.9 1,397.8 Exterior 1.0528929833 Departamento flat 5 503 67.3 67.3 43,118.9 43,118.9 7,761.4 93,999.2 1,397.8 Exterior 1.0528929833 Departamento flat 5 504 40.0 40.0 25,666.2 25,666.2 4,619.9 55,952.2 1,397.8 Exterior 1.0528929833 Departamento flat 5 505 72.1 72.1 46,209.4 46,209.4 8,317.7 100,736.4 1,397.8 Exterior 1.0528929833 Departamento flat 5 506 55.6 55.6 35,280.0 35,280.0 6,350.4 76,910.5 1,383.8 Interior 1.0423640534 Departamento flat 5 507 65.2 65.2 41,373.8 41,373.8 7,447.3 90,194.8 1,383.8 Interior 1.0423640534 Departamento flat 5 508 66.3 66.3 42,072.0 42,072.0 7,573.0 91,716.9 1,383.8 Interior 1.0423640534 Departamento flat 5 509 55.4 55.4 35,191.2 35,191.2 6,334.4 76,716.8 1,383.8 Interior 1.0423640534 Departamento flat 6 601 63.9 63.9 40,578.0 40,578.0 7,304.0 88,460.1 1,383.9 Exterior 1.0424683003 Departamento flat 6 602 66.9 66.9 42,488.8 42,488.8 7,648.0 92,625.7 1,383.9 Exterior 1.0424683003 Departamento flat 6 603 67.3 67.3 42,692.0 42,692.0 7,684.6 93,068.5 1,383.9 Exterior 1.0424683003 Departamento flat 6 604 40.0 40.0 25,412.0 25,412.0 4,574.2 55,398.3 1,383.9 Exterior 1.0424683003 Departamento flat 6 605 72.1 72.1 45,751.8 45,751.8 8,235.3 99,739.0 1,383.9 Exterior 1.0424683003 Departamento flat 6 606 55.6 55.6 34,930.7 34,930.7 6,287.5 76,149.0 1,370.1 Interior 1.0320436173 Departamento flat 6 607 65.2 65.2 40,964.1 40,964.1 7,373.5 89,301.8 1,370.1 Interior 1.0320436173 Departamento flat 6 608 66.3 66.3 41,655.4 41,655.4 7,498.0 90,808.8 1,370.1 Interior 1.0320436173 Departamento flat 6 609 55.4 55.4 34,842.7 34,842.7 6,271.7 75,957.2 1,370.1 Interior 1.0320436173 Departamento flat 7 701 63.9 63.9 40,172.2 40,172.2 7,231.0 87,575.5 1,370.1 Exterior 1.0320436173 Departamento flat 7 702 66.9 66.9 42,063.9 42,063.9 7,571.5 91,699.4 1,370.1 Exterior 1.0320436173 Departamento flat 7 703 67.3 67.3 42,265.1 42,265.1 7,607.7 92,137.8 1,370.1 Exterior 1.0320436173 Departamento flat 7 704 40.0 40.0 25,157.9 25,157.9 4,528.4 54,844.3 1,370.1 Exterior 1.0320436173 Departamento flat 7 705 72.1 72.1 45,294.3 45,294.3 8,153.0 98,741.6 1,370.1 Exterior 1.0320436173 Departamento flat 7 706 55.6 55.6 34,581.4 34,581.4 6,224.7 75,387.5 1,356.4 Interior 1.0217231811 Departamento flat 7 707 65.2 65.2 40,554.5 40,554.5 7,299.8 88,408.7 1,356.4 Interior 1.0217231811 Departamento flat 7 708 66.3 66.3 41,238.9 41,238.9 7,423.0 89,900.8 1,356.4 Interior 1.0217231811 Departamento flat 7 709 55.4 55.4 34,494.3 34,494.3 6,209.0 75,197.6 1,356.4 Interior 1.0217231811 Departamento flat 8 801 63.9 63.9 39,766.4 39,766.4 7,158.0 86,690.9 1,356.2 Exterior 1.0216189343 Departamento flat 8 802 66.9 66.9 41,639.1 41,639.1 7,495.0 90,773.1 1,356.2 Exterior 1.0216189343 Departamento flat 8 803 67.3 67.3 41,838.1 41,838.1 7,530.9 91,207.1 1,356.2 Exterior 1.0216189343 Departamento flat 8 804 40.0 40.0 23,211.0 23,211.0 4,178.0 50,600.0 1,264.1 Exterior 1 1 1.0216189343 50,600.0 Departamento flat 8 805 72.1 72.1 40,344.0 40,344.0 7,261.9 87,950.0 1,220.3 Exterior 1 1 1.0216189343 87,950.0 Departamento flat 8 806 55.6 55.6 34,232.1 34,232.1 6,161.8 74,626.0 1,342.7 Interior 1 1.0114027449 Departamento flat 8 807 65.2 65.2 40,144.8 40,144.8 7,226.1 87,515.7 1,342.7 Interior 1.0114027449 Departamento flat 8 808 66.3 66.3 40,822.3 40,822.3 7,348.0 88,992.7 1,342.7 Interior 1.0114027449 Departamento flat 8 809 55.4 55.4 34,145.9 34,145.9 6,146.3 74,438.0 1,342.7 Interior 1.0114027449 Departamento flat 9 901 63.9 63.9 39,360.7 39,360.7 7,084.9 85,806.3 1,342.4 Exterior 1 1.0111942513 Departamento flat 9 902 66.9 66.9 37,087.2 37,087.2 6,675.7 80,850.0 1,208.0 Exterior 1 1 1.0111942513 80,850.0 Departamento flat 9 903 67.3 67.3 41,411.2 41,411.2 7,454.0 90,276.5 1,342.4 Exterior 1.0111942513 Departamento flat 9 904 40.0 40.0 22,408.3 22,408.3 4,033.5 48,850.0 1,220.3 Exterior 1 1 1.0111942513 48,850.0 Departamento flat 9 905 72.1 72.1 39,954.1 39,954.1 7,191.7 87,100.0 1,208.5 Exterior 1 1 1.0111942513 87,100.0 Departamento flat 9 906 55.6 55.6 33,882.8 33,882.8 6,098.9 73,864.5 1,329.0 Interior 1.0010823088 Departamento flat 9 907 65.2 65.2 39,735.2 39,735.2 7,152.3 86,622.7 1,329.0 Interior 1.0010823088 Departamento flat 9 908 66.3 66.3 40,405.8 40,405.8 7,273.0 88,084.6 1,329.0 Interior 1.0010823088 Departamento flat 9 909 55.4 55.4 33,797.5 33,797.5 6,083.5 73,678.5 1,329.0 Interior 1.0010823088 Departamento dúplex 10 1001 85.8 40.5 126.2 58,165.1 58,165.1 10,469.7 126,800.0 1,196.1 Exterior 1 1 1.0007695683 126,800.0 Departamento dúplex 10 1002 87.2 45.9 133.1 57,889.9 57,889.9 10,420.2 126,200.0 1,145.4 Exterior 1 1 1.0007695683 126,200.0 Departamento dúplex 10 1003 89.5 43.6 133.1 67,829.8 67,829.8 12,209.4 147,868.9 1,328.6 Exterior 1.0007695683 Departamento flat 10 1004 40.0 - 0 40.0 24,395.6 24,395.6 4,391.2 53,182.3 1,328.6 Exterior 1 1.0007695683 Departamento dúplex 10 1005 100.6 42.4 143.0 74,231.9 74,231.9 13,361.7 161,825.4 1,328.6 Exterior 1.0007695683 Departamento flat 10 1006 56.5 - 0 56.5 34,058.4 34,058.4 6,130.5 74,247.3 1,315.3 Interior 0.9907618726 Departamento dúplex 10 1007 88.4 40.2 128.6 65,450.1 65,450.1 11,781.0 142,681.1 1,315.3 Interior 0.9907618726 Departamento dúplex 10 1008 89.6 39.5 129.1 65,978.0 65,978.0 11,876.0 143,832.0 1,315.3 Interior 0.9907618726 Departamento flat 10 1009 56.5 - 0 56.5 34,064.4 34,064.4 6,131.6 74,260.5 1,315.3 Interior 0.9907618726 TOTAL 5,115.5 439.1 5,554.6 3,320,472.7 3,320,472.7 597,685.1 7,238,630.5 17.0 12.0 84.1 - 0 1,005,650.0 COMERCIO (TIPO) Piso Tienda Area Techada (m2) Area No techada (m2) Area Ocupada (m2) Valor de Venta terreno (US$) Valor de Venta fábrica (US$) IGV US$ Precio de Venta US$ Precio de Venta (US$/M2) Ubicación Separado Prevendido Permuta Valor Venta Final Local comercial 1 Com-01 51.1 - 0 51.1 23,445.0 23,445.0 4,220.1 51,110.0 1,000.0 Exterior Si 1 Local comercial 1 Com-02 52.4 - 0 52.4 24,036.7 24,036.7 4,326.6 52,400.0 1,000.0 Exterior Si 1 Local comercial 1 Com-03 47.1 - 0 47.1 21,619.3 21,619.3 3,891.5 47,130.0 1,000.0 Exterior Si 1 Local comercial 1 Com-04 42.0 - 0 42.0 19,270.6 19,270.6 3,468.7 42,010.0 1,000.0 Exterior Si 1 Oficinas 1 Ofi-01 54.6 - 0 54.6 25,050.5 25,050.5 4,509.1 54,610.0 1,000.0 Interior Si 1 Oficinas 1 Ofi-02 52.5 - 0 52.5 24,096.3 24,096.3 4,337.3 52,530.0 1,000.0 Interior Si 1 Oficinas 1 Ofi-03 81.8 - 0 81.8 37,500.0 37,500.0 6,750.0 81,750.0 1,000.0 Interior Si 1 Oficinas 1 Ofi-04 76.8 - 0 76.8 35,247.7 35,247.7 6,344.6 76,840.0 1,000.0 Interior Si 1 TOTAL 458.4 - 0 458.4 210,266.1 210,266.1 37,847.9 458,380.0 - 0 - 0 - 0 8.0 ESTACIONAMIENTOS (tipo) Techado Relacion Cantidad Area Techada (m2) Area No techada (m2) Valor de Venta terreno (US$) Valor de Venta fábrica (US$) IGV US$ Precio de Venta US$ Precio de Venta (US$/M2) Ubicación Separado Prevendido Permuta Permuta Valor Venta Final Simple Techado 1 1.0 14.1 5,733.9 5,733.9 1,032.1 12,500.0 885.3 Sotano 1 Simple Techado 2 1.0 14.1 5,733.9 5,733.9 1,032.1 12,500.0 885.3 Sotano 1 Simple Techado 3 1.0 14.1 5,733.9 5,733.9 1,032.1 12,500.0 885.3 Sotano 1 Simple Techado 4 1.0 14.1 5,733.9 5,733.9 1,032.1 12,500.0 885.3 Sotano 1 Simple Techado 5 1.0 14.1 5,733.9 5,733.9 1,032.1 12,500.0 885.3 Sotano 1 Simple Techado 6 1.0 15.3 5,733.9 5,733.9 1,032.1 12,500.0 819.7 Sotano 1 Simple Techado 7 1.0 13.5 5,733.9 5,733.9 1,032.1 12,500.0 925.9 Sotano 1 Simple Techado 8 1.0 13.5 5,733.9 5,733.9 1,032.1 12,500.0 925.9 Sotano 1 Simple Techado 9 1.0 13.5 5,733.9 5,733.9 1,032.1 12,500.0 925.9 Sotano 1 Simple Techado 10 1.0 13.5 5,733.9 5,733.9 1,032.1 12,500.0 925.9 Sotano 1 Simple Techado 11 1.0 14.5 5,733.9 5,733.9 1,032.1 12,500.0 862.1 Sotano 1 Simple Techado 12 1.0 14.5 5,733.9 5,733.9 1,032.1 12,500.0 862.1 Sotano 1 Simple Techado 13 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 14 1.0 12.6 5,504.6 5,504.6 990.8 12,000.0 949.4 Sotano 1 Simple Techado 15 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 16 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 17 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 18 1.0 13.9 5,733.9 5,733.9 1,032.1 12,500.0 899.9 Sotano 1 Simple Techado 19 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 20 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 21 1.0 16.8 5,963.3 5,963.3 1,073.4 13,000.0 776.1 Sotano 1 1.0 1.0 10,000.0 Simple Techado 22 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 23 1.0 12.5 5,504.6 5,504.6 990.8 12,000.0 960.0 Sotano 1 Simple Techado 24 1.0 13.5 5,504.6 5,504.6 990.8 12,000.0 889.5 Sotano 1 Simple Techado 25 1.0 14.4 5,504.6 5,504.6 990.8 12,000.0 835.7 Sotano 1 Simple Techado 26 1.0 14.5 5,275.2 5,275.2 949.5 11,500.0 792.6 Sotano 1 Simple Techado 27 1.0 14.1 5,275.2 5,275.2 949.5 11,500.0 814.4 Sotano 1 Simple Techado 28 1.0 14.1 5,275.2 5,275.2 949.5 11,500.0 814.4 Sotano 1 Simple Techado 29 1.0 14.1 5,275.2 5,275.2 949.5 11,500.0 814.4 Sotano 1 simple Techado 30 1.0 14.1 5,275.2 5,275.2 949.5 11,500.0 814.4 Sotano 1 Simple Techado 31 1.0 14.1 5,275.2 5,275.2 949.5 11,500.0 814.4 Sotano 2 Simple Techado 32 1.0 15.3 5,275.2 5,275.2 949.5 11,500.0 754.1 Sotano 2 Simple Techado 33 1.0 13.5 5,275.2 5,275.2 949.5 11,500.0 851.9 Sotano 2 Simple Techado 34 1.0 13.5 5,275.2 5,275.2 949.5 11,500.0 851.9 Sotano 2 Simple Techado 35 1.0 13.5 5,275.2 5,275.2 949.5 11,500.0 851.9 Sotano 2 Doble Techado 36 1.0 27.8 6,880.7 6,880.7 1,238.5 15,000.0 540.5 Sotano 2 1.0 Simple Techado 37 1.0 13.5 5,275.2 5,275.2 949.5 11,500.0 851.9 Sotano 2 Simple Techado 38 1.0 14.5 5,045.9 5,045.9 908.3 11,000.0 758.6 Sotano 2 Simple Techado 39 1.0 14.5 5,045.9 5,045.9 908.3 11,000.0 759.7 Sotano 2 Simple Techado 40 1.0 15.0 5,275.2 5,275.2 949.5 11,500.0 764.6 Sotano 2 Simple Techado 41 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 42 1.0 12.6 5,045.9 5,045.9 908.3 11,000.0 870.3 Sotano 2 Simple Techado 43 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 44 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 45 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 46 1.0 13.9 5,275.2 5,275.2 949.5 11,500.0 827.9 Sotano 2 Simple Techado 47 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 1.0 Simple Techado 48 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 49 1.0 16.8 5,504.6 5,504.6 990.8 12,000.0 716.4 Sotano 2 Simple Techado 50 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 51 1.0 12.5 5,045.9 5,045.9 908.3 11,000.0 880.0 Sotano 2 Simple Techado 52 1.0 13.5 5,045.9 5,045.9 908.3 11,000.0 815.4 Sotano 2 Simple Techado 53 1.0 14.4 5,045.9 5,045.9 908.3 11,000.0 766.0 Sotano 2 Simple No Tech. 1 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Sotano 2 1.0 1.0 Simple No Tech. 2 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 3 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 4 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 5 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 6 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 7 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple No Tech. 8 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 Simple Techado 9 1.0 12.5 3,899.1 3,899.1 701.8 8,500.0 680.0 Piso 1 1.0 1.0 TOTAL 62.0 749.7 100.0 322,706.4 322,706.4 58,087.2 703,500.0 3.0 1.0 9.0 9.0 Depositos Relacion Cantidad Area Techada (m2) Area No techada (m2) Valor de Venta terreno (US$) Valor de Venta fábrica (US$) IGV US$ Precio de Venta US$ Precio de Venta (US$/M2) Ubicación Separado Prevendido Permuta Permuta Valor Venta Final Sótano 1 1.0 2.7 1,098.2 1,098.2 197.7 2,394.0 900.0 Sotano 1 Sótano 2 1.0 3.6 1,486.2 1,486.2 267.5 3,240.0 900.0 Sotano 1 Sótano 3 1.0 2.7 1,098.2 1,098.2 197.7 2,394.0 900.0 Sotano 1 Sótano 4 1.0 3.5 1,436.7 1,436.7 258.6 3,132.0 900.0 Sotano 1 Sótano 5 1.0 2.8 1,164.2 1,164.2 209.6 2,538.0 900.0 Sotano 1 Sótano 6 1.0 3.7 1,539.9 1,539.9 277.2 3,357.0 900.0 Sotano 1 Sótano 7 1.0 2.9 1,184.9 1,184.9 213.3 2,583.0 900.0 Sotano 1 Sótano 8 1.0 3.7 1,539.9 1,539.9 277.2 3,357.0 900.0 Sotano 1 Sótano 9 1.0 3.5 1,445.0 1,445.0 260.1 3,150.0 900.0 Sotano 1 Sótano 10 1.0 3.6 1,494.5 1,494.5 269.0 3,258.0 900.0 Sotano 1 Sótano 11 1.0 3.7 1,506.9 1,506.9 271.2 3,285.0 900.0 Sotano 1 Sótano 12 1.0 3.9 1,597.7 1,597.7 287.6 3,483.0 900.0 Sotano 1 Sótano 13 1.0 3.9 1,601.8 1,601.8 288.3 3,492.0 900.0 Sotano 1 Sótano 14 1.0 4.7 1,948.6 1,948.6 350.8 4,248.0 900.0 Sotano 1 Sótano 15 1.0 4.8 1,994.0 1,994.0 358.9 4,347.0 900.0 Sotano 1 Sótano 16 1.0 5.5 2,266.5 2,266.5 408.0 4,941.0 900.0 Sotano 1 Sótano 17 1.0 3.7 1,506.9 1,506.9 271.2 3,285.0 900.0 Sotano 1 Sótano 18 1.0 3.7 1,506.9 1,506.9 271.2 3,285.0 900.0 Sotano 1 Sótano 19 1.0 2.7 1,098.2 1,098.2 197.7 2,394.0 900.0 Sotano 1 Sótano 20 1.0 3.6 1,486.2 1,486.2 267.5 3,240.0 900.0 Sotano 2 Sótano 21 1.0 2.6 1,056.9 1,056.9 190.2 2,304.0 900.0 Sotano 2 Sótano 22 1.0 3.5 1,428.4 1,428.4 257.1 3,114.0 900.0 Sotano 2 Sótano 23 1.0 2.8 1,164.2 1,164.2 209.6 2,538.0 900.0 Sotano 2 Sótano 24 1.0 3.7 1,539.9 1,539.9 277.2 3,357.0 900.0 Sotano 2 Sótano 25 1.0 2.9 1,184.9 1,184.9 213.3 2,583.0 900.0 Sotano 2 Sótano 26 1.0 3.7 1,539.9 1,539.9 277.2 3,357.0 900.0 Sotano 2 Sótano 27 1.0 3.5 1,445.0 1,445.0 260.1 3,150.0 900.0 Sotano 2 Sótano 28 1.0 3.6 1,494.5 1,494.5 269.0 3,258.0 900.0 Sotano 2 Sótano 29 1.0 3.7 1,506.9 1,506.9 271.2 3,285.0 900.0 Sotano 2 Sótano 30 1.0 3.9 1,597.7 1,597.7 287.6 3,483.0 900.0 Sotano 2 Sótano 31 1.0 5.3 2,183.9 2,183.9 393.1 4,761.0 900.0 Sotano 2 Sótano 32 1.0 5.7 2,369.7 2,369.7 426.6 5,166.0 900.0 Sotano 2 Sótano 33 1.0 4.0 1,659.6 1,659.6 298.7 3,618.0 900.0 Sotano 2 Sótano 34 1.0 3.7 1,544.0 1,544.0 277.9 3,366.0 900.0 Sotano 2 Sótano 35 1.0 3.7 1,544.0 1,544.0 277.9 3,366.0 900.0 Sotano 2 Sótano 36 1.0 4.7 1,948.6 1,948.6 350.8 4,248.0 900.0 Sotano 2 Sótano 37 1.0 4.8 1,994.0 1,994.0 358.9 4,347.0 900.0 Sotano 2 TOTAL 37 139 - 0 57,203.67 57,203.67 10,296.66 124,704.00 - 0 - 0 - 0 - 0 RESUMEN DE VENTAS Unidades Inmobiliarias Cantidad Area Techada (m2) Area No techada (m2) Valor de Venta terreno (US$) Valor de Venta fábrica (US$) IGV US$ Precio US$ Incidencia % Departamentos 81 5,115.47 439.14 3,320,472.69 3,320,472.69 597,685.08 7,238,630.46 85% Tipo Flat 75 4,574.38 187.06 2,838,409.55 2,838,409.55 510,913.72 6,187,732.81 73% Tipo Duplex 6 541.09 252.08 482,063.14 482,063.14 86,771.37 1,050,897.65 12% Comercio 8 458.38 - 0 210,266.06 210,266.06 37,847.89 458,380.00 5% Locales Comerciales 4 192.65 - 0 88,371.56 88,371.56 15,906.88 192,650.00 2% Oficinas 4 265.73 - 0 121,894.50 121,894.50 21,941.01 265,730.00 3% Estacionamientos 62 749.74 100.00 322,706.42 322,706.42 58,087.16 703,500.00 8% Estacionamientos Techados 54 749.74 291,513.76 291,513.76 52,472.48 635,500.00 7% Estacionamientos No techados 8 100.00 31,192.66 31,192.66 5,614.68 68,000.00 1% Otros 37 138.6 - 0 57,203.7 57,203.7 10,296.7 124,704.0 1% Depósitos 37 138.56 57,203.67 57,203.67 10,296.66 124,704.00 1% Total 188 6,462.15 539.14 3,910,648.84 3,910,648.84 703,916.79 8,525,214.46 100% 7,821,297.67 CONSTRUCCION 10.3 COSTO DIRECTO DE CONSTRUCCION Y EQUIPAMIENTO - LINEA ACTUALIZADA Edificio Comercial y Residencial URBAN COLLECTION MAGDALENA (Expresado en Dólares Americanos, tipo de cambio 2.80) Total m2 construidos (Sótanos, Cisterna y Cuarto de Bombas) 2,246.82 Total m2 construidos (Comercio 1er piso) 862.06 Total m2 construidos (Vivienda 9 pisos) 5,758.63 TOTAL M2 CONSTRUIDOS 8,867.51 COSTO DIRECTO SOTANO Unidad Metrado Ratio $/m2 CU Total S/IGV IGV Total C/IGV Costos por m2 (sótano) Obras Preliminares Demolición glb 1.00 16,950.00 16,950.00 3,051.00 20,001.00 7.54 1.36 8.90 Excavación glb 1.00 147,392.57 147,392.57 26,530.66 173,923.23 65.60 11.81 77.41 Anclaje muros pantalla m2 990.00 34.00 33,660.00 6,058.80 39,718.80 14.98 2.70 17.68 Estructuras m2 2,246.82 166.50 374,095.53 67,337.20 441,432.73 166.50 29.97 196.47 Arquitectura m2 2,246.82 29.35 65,944.17 11,869.95 77,814.12 29.35 5.28 34.63 Instalaciones sanitarias m2 2,246.82 9.80 22,018.84 3,963.39 25,982.23 9.80 1.76 11.56 Instalaciones eléctricas m2 2,246.82 19.60 44,037.67 7,926.78 51,964.45 19.60 3.53 23.13 Total costo directo casco 704,098.78 126,737.78 830,836.55 313.38 56.41 369.78 Gastos Generales 6% 42,245.93 7,604.27 49,850.19 18.80 3.38 22.19 Utilidad 6% 42,245.93 7,604.27 49,850.19 18.80 3.38 22.19 Total presupuesto casco 260.00 788,590.63 141,946.31 930,536.94 350.98 63.18 414.16 COSTO DIRECTO TORRE Unidad Metrado Ratio $/m2 CU Total S/IGV IGV Total C/IGV Costos por m2 (torre) Estructuras m2 6,620.69 172.00 1,138,758.68 204,976.56 1,343,735.24 172.00 30.96 202.96 Arquitectura vivienda m2 5,758.63 160.00 921,380.80 165,848.54 1,087,229.34 139.17 25.05 164.22 Arquitectura comercio m2 862.06 50.00 43,103.00 7,758.54 50,861.54 6.51 1.17 7.68 Instalaciones sanitarias m2 6,620.69 25.00 165,517.25 29,793.11 195,310.36 25.00 4.50 29.50 Instalaciones eléctricas m2 6,620.69 30.00 198,620.70 35,751.73 234,372.43 30.00 5.40 35.40 Implementación ACI m2 2246.82 40.00 89,872.80 16,177.10 106,049.90 40.00 7.20 47.20 Total costo directo casco 2,557,253.23 460,305.58 3,017,558.81 412.68 74.28 486.96 Gastos Generales 6% 153,435.19 27,618.33 181,053.53 23.18 4.17 27.35 Utilidad 6% 153,435.19 27,618.33 181,053.53 23.18 4.17 27.35 Total presupuesto torre 380.00 2,864,123.62 515,542.25 3,379,665.87 459.03 82.62 541.65 COSTO DIRECTO EQUIPAMIENTO Y OTROS Unidad Metrado Ratio $/m2 CU Total S/IGV IGV Total C/IGV Costos por m2 total construcción Ascensores Parada 24.00 4,000.00 96,000.00 17,280.00 113,280.00 10.83 1.95 12.77 Bombas glb 1.00 25,000.00 25,000.00 4,500.00 29,500.00 2.82 0.51 3.33 Total costo directo Equipamiento y otros 121,000.00 21,780.00 142,780.00 13.65 2.46 16.10 Gastos Generales 6% 7,260.00 1,306.80 8,566.80 0.82 0.15 0.97 Utilidad 6% 7,260.00 1,306.80 8,566.80 0.82 0.15 0.97 Total presupuesto equipamiento 135,520.00 24,393.60 159,913.60 15.28 2.75 18.03 TOTAL PRESUPUESTO 3,788,234.25 681,882.16 4,470,116.41 427.20 76.90 504.10 TOTAL COSTO DIRECTO 3,382,352.01 608,823.36 3,991,175.37 381.43 68.66 450.09 TOTAL COSTO DIRECTO SIN EQUIPAMIENTO 3,261,352.01 587,043.36 3,848,395.37 367.79 66.20 433.99 OTROS COSTOS CONSTRUCCION Unidad Metrado Ratio $/m2 CU Total S/IGV IGV Total C/IGV Póliza CAR % 0.20% 3,382,352.01 6,764.70 1,217.65 7,982.35 Conexiones de Agua y Desagüe (Sedapal) Glb 4 1500 6,000.00 1,080.00 7,080.00 Medidores de Luz Und 89.00 290 25,810.00 4,645.80 30,455.80 Total 38,574.70 6,943.45 45,518.15 CRONOG VALORIZADO DE OBRA 10.4 CRONOGRAMA VALORIZADO DE OBRA - LINEA ACTUALIZADA PROYECTO: URBAN COLLECTION MAGDALENA Area construida Torre: 830.06 m2 Tipo de cambio: 2.80 (Expresado en Dólares Americanos) PARTIDA / TIPO Total Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 TOTAL COSTO DIRECTO SOTANO 704,098.78 0.00 0.00 8,475.00 8,475.00 0.00 0.00 60,350.86 201,563.49 201,563.49 141,212.64 16,514.13 0.00 32,972.08 32,972.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 704,098.78 OK Demolición 16,950.00 8,475.00 8,475.00 - 0 - 0 - 0 - 0 16,950.00 OK Excavación 147,392.57 49,130.86 49,130.86 49,130.86 147,392.57 OK Anclaje muros pantalla 33,660.00 11,220.00 11,220.00 11,220.00 33,660.00 OK Estructuras 374,095.53 124,698.51 124,698.51 124,698.51 374,095.53 OK Arquitectura 65,944.17 32,972.08 32,972.08 65,944.17 OK Instalaciones sanitarias 22,018.84 5,504.71 5,504.71 5,504.71 5,504.71 22,018.84 OK Instalaciones eléctricas 44,037.67 11,009.42 11,009.42 11,009.42 11,009.42 44,037.67 OK COSTO DIRECTO TORRE 2,557,253.23 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 237,441.01 237,441.01 237,441.01 237,441.01 391,004.48 391,004.48 222,762.86 222,762.86 189,977.26 189,977.26 - 0 - 0 - 0 - 0 2,557,253.23 OK Estructuras 1,138,758.68 189,793.11 189,793.11 189,793.11 189,793.11 189,793.11 189,793.11 1,138,758.68 OK Arquitectura vivienda 921,380.80 153,563.47 153,563.47 153,563.47 153,563.47 153,563.47 153,563.47 921,380.80 OK Arquitectura comercio 43,103.00 21,551.50 21,551.50 43,103.00 OK Instalaciones sanitarias 165,517.25 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 165,517.25 OK Instalaciones eléctricas 198,620.70 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 198,620.70 OK Implementación ACI 89,872.80 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 89,872.80 OK EQUIPAMIENTO 121,000.00 - 0 - 0 - 0 - 0 19,200.00 - 0 - 0 - 0 - 0 - 0 19,200.00 - 0 - 0 - 0 - 0 - 0 60,500.00 - 0 - 0 22,100.00 - 0 - 0 - 0 - 0 121,000.00 OK Ascensores 96,000.00 19,200.00 19,200.00 48,000.00 9,600.00 96,000.00 OK Bombas 25,000.00 12,500.00 12,500.00 25,000.00 OK COSTO DIRECTO SIN/EQUIPAM. 3,261,352.01 - 0 - 0 8,475.00 8,475.00 - 0 - 0 60,350.86 201,563.49 201,563.49 141,212.64 253,955.14 237,441.01 270,413.09 270,413.09 391,004.48 391,004.48 222,762.86 222,762.86 189,977.26 189,977.26 - 0 - 0 - 0 - 0 3,261,352.01 OK COSTO DIRECTO ACUMULADO - 0 - 0 8,475.00 16,950.00 16,950.00 16,950.00 77,300.86 278,864.35 480,427.84 621,640.48 875,595.62 270,413.09 OK EQUIPAMIENTO 121,000.00 - 0 - 0 - 0 - 0 19,200.00 - 0 - 0 - 0 - 0 - 0 19,200.00 - 0 - 0 - 0 - 0 - 0 60,500.00 - 0 - 0 22,100.00 - 0 - 0 - 0 - 0 121,000.00 OK COSTO DIRECTO CON EQUIPAMIENTO 3,382,352.01 - 0 - 0 8,475.00 8,475.00 19,200.00 - 0 60,350.86 201,563.49 201,563.49 141,212.64 273,155.14 237,441.01 270,413.09 270,413.09 391,004.48 391,004.48 283,262.86 222,762.86 189,977.26 212,077.26 - 0 - 0 - 0 - 0 3,382,352.01 OK GG (6%) 202,941.12 - 0 - 0 508.50 508.50 1,152.00 - 0 3,621.05 12,093.81 12,093.81 8,472.76 16,389.31 14,246.46 16,224.79 16,224.79 23,460.27 23,460.27 16,995.77 13,365.77 11,398.64 12,724.64 - 0 - 0 - 0 - 0 202,941.12 OK UTILIDAD (6%) 202,941.12 - 0 - 0 508.50 508.50 1,152.00 - 0 3,621.05 12,093.81 12,093.81 8,472.76 16,389.31 14,246.46 16,224.79 16,224.79 23,460.27 23,460.27 16,995.77 13,365.77 11,398.64 12,724.64 - 0 - 0 - 0 - 0 202,941.12 OK IGV 18% 681,882.16 - 0 - 0 1,708.56 1,708.56 3,870.72 - 0 12,166.73 40,635.20 40,635.20 28,468.47 55,068.08 47,868.11 54,515.28 54,515.28 78,826.50 78,826.50 57,105.79 44,908.99 38,299.42 42,754.78 - 0 - 0 - 0 - 0 681,882.16 OK TOTAL COSTO OBRA, CON GG y IGV 4,470,116.41 - 0 - 0 11,200.56 11,200.56 25,374.72 - 0 79,759.69 266,386.31 266,386.31 186,626.62 361,001.83 313,802.04 357,377.94 357,377.94 516,751.51 516,751.51 374,360.20 294,403.40 251,073.95 280,281.31 - 0 - 0 - 0 - 0 4,470,116.41 OK 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 0 79759.692170666662 266386.31322986673 266386.31322986673 186626.6210592 361001.82685653341 313802.03661333339 357377.94216693344 357377.94216693344 516751.51416000002 516751.51416000002 374360.19797866663 294403.3979786667 251073.94901866672 280281.30901866674 0 0 0 Desembolsos Acumulados EGRESOS DETALLADO 10.5. DETALLE DE GASTOS -LINEA ACTUALIZADA Nombre del Proyecto URBAN COLLECTION MAGDALENA DETALLE DE GASTOS (Expresado en Dólares Americanos) FLUJO DE EGRESOS (Tipo de cambio: 2.80) TERRENO Unid. Cantidad P.U. Sin IGV IGV TOTAL % Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Terreno m2 1,076.0 1,900.0 2,044,400.0 2,044,400.0 27.32% 20,000.00 184,259.95 1,155,260.05 150,000.00 534,880.00 2,044,400.00 OK Pago Alcabala glb 1.0 60,598.9 60,598.9 0.81% 60,598.88 60,598.88 OK Gastos Notariales Glb 1.0 0.002 4,088.8 736.0 4,824.8 0.06% 4,088.80 4,088.80 OK Gastos Registrales Glb 1.0 3,000.000 3,000.0 3,000.0 0.04% 3,000.00 3,000.00 OK TOTAL TERRENO 2,112,087.7 736.0 2,112,823.7 28.23% 20,000.00 0.00 0.00 184,259.95 0.00 1,222,947.73 0.00 0.00 150,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.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 534,880.00 0.00 0.00 0.00 0.00 0.00 2,112,087.68 OK - 0 736.0 736.0 HONORARIOS PROYECTOS Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Levantamiento Topográfico glb 1.0 400.0 400.0 - 0 400.0 0.01% 400.00 400.00 OK Estudio de Suelos glb 1.0 1,230.0 1,230.0 221.4 1,451.4 0.02% 1,230.00 1,230.00 OK Estudio Impacto Vial glb 1.0 - 0 - 0 - 0 - 0 0.00% 0.00 0.00 OK Estudio Impacto Ambiental glb 1.0 - 0 - 0 - 0 - 0 0.00% 0.00 0.00 OK Proyecto de Arquitectura m2 8,867.5 0.80 7,094.0 1,276.9 8,370.9 0.11% 1,418.80 3,547.00 2,128.20 7,094.01 OK Proyecto de Estructuras m2 8,867.5 0.90 7,980.8 1,436.5 9,417.3 0.13% 1,596.15 2,394.23 3,990.38 7,980.76 OK Proyecto de IIEE y EEMM m2 8,867.5 0.60 5,320.5 957.7 6,278.2 0.08% 1,064.10 1,596.15 2,660.25 5,320.51 OK Proyecto de IISS m2 8,867.5 0.60 5,320.5 957.7 6,278.2 0.08% 1,064.10 1,596.15 2,660.25 5,320.51 OK Proyecto de Gas m2 8,867.5 0.40 3,547.0 638.5 4,185.5 0.06% 709.40 1,064.10 1,773.50 3,547.00 OK TOTAL GASTOS DE PROYECTO H.U. 30,892.8 5,488.7 36,381.5 0.49% 1,818.80 4,777.00 0.00 2,128.20 4,433.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,650.63 0.00 0.00 0.00 11,084.39 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30,892.78 255.38 859.9 383.08 798.08 1,197.11 1995.18975 5,488.70 GASTOS LICENCIAS CONSTRUCCION Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Copias certificadas de planos Glb 1.0 110.00 110.00 110.00 0.00% 110.00 110.00 OK Certificado de Parámetros Urbanísticos Glb 1.0 30.00 30.00 30.00 0.00% 30.00 30.00 OK Revisión de Anteproyecto Glb 1.0 1,900.00 1,900.00 1,900.00 0.03% 1,900.00 1,900.00 OK Licencia de demolición Glb 1.0 500.00 500.00 500.00 0.01% 500.00 500.00 OK Finalización de demolición Glb 1.0 300.00 300.00 300.00 0.00% 300.00 300.00 OK Licencia de Construcción Obra Nueva Glb 1.0 35,000.00 35,000.00 35,000.00 0.47% 35,000.00 35,000.00 OK Certificado finalización obra y zonificación Glb 1.0 1,350.00 1,350.00 1,350.00 0.02% 1,350.00 1,350.00 OK Certificado de Numeración Glb 1.0 3,780.00 3,780.00 3,780.00 0.05% 3,780.00 3,780.00 OK Declaratoria de Fábrica Glb 1.0 1,350.00 1,350.00 1,350.00 0.02% 1,350.00 1,350.00 OK Inscripción inmuebles en Mun. Distrital Glb 1.0 1,000.00 1,000.00 1,000.00 0.01% 1,000.00 1,000.00 OK Pago a SERPAR Glb 1.0 15,000.00 15,000.00 15,000.00 0.20% 15,000.00 15,000.00 OK TOTAL GASTOS LICENCIAS CONSTRUCCION 60,320.00 - 0 60,320.00 0.81% 2,040.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 500.00 300.00 0.00 0.00 0.00 0.00 0.00 35,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 16,350.00 5,130.00 1,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60,320.00 CONSTRUCCION Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Costo Directo Sótano Glb 1.0 704,098.78 704,098.8 126,737.8 830,836.55 11.10% 8,475.00 8,475.00 0.00 60,350.86 201,563.49 201,563.49 141,212.64 16,514.13 0.00 32,972.08 32,972.08 0.00 0.00 0.00 0.00 0.00 0.00 704,098.78 OK Costo Directo Torre Glb 1.00 2,557,253.23 2,557,253.2 460,305.6 3,017,558.81 40.32% 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 237,441.01 237,441.01 237,441.01 237,441.01 391,004.48 391,004.48 222,762.86 222,762.86 189,977.26 189,977.26 0.00 0.00 0.00 0.00 2,557,253.23 OK Equipamiento Glb 1.0 121,000.00 121,000.0 21,780.0 142,780.00 1.91% 0.00 0.00 19,200.00 0.00 0.00 0.00 0.00 0.00 19,200.00 0.00 0.00 0.00 0.00 0.00 60,500.00 0.00 0.00 22,100.00 0.00 0.00 0.00 0.00 121,000.00 OK Gastos Generales y Utilidad Constructora Glb 1.0 405,882.24 405,882.2 73,058.8 478,941.04 6.40% 1,017.00 1,017.00 2,304.00 0.00 7,242.10 24,187.62 24,187.62 16,945.52 32,778.62 28,492.92 32,449.57 32,449.57 46,920.54 46,920.54 33,991.54 26,731.54 22,797.27 25,449.27 405,882.24 OK Póliza CAR % 0.20% 3,382,352.01 6,764.7 1,217.6 7,982.4 0.11% 6,764.70 6,764.70 OK Conexiones de Agua y Desagüe (Sedapal) Glb 4.00 1,500.00 6,000.0 1,080.0 7,080.0 0.09% 3,000.00 3,000.00 6,000.00 OK Medidores de Luz Und 89.00 290.00 25,810.0 4,645.8 30,455.8 0.41% 12,905.00 12,905.00 25,810.00 OK TOTAL CONSTRUCCION 3,826,808.9 688,825.6 4,515,634.56 60.34% 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 9,492.00 9,492.00 21,504.00 0.00 74,357.66 225,751.11 225,751.11 158,158.15 305,933.75 265,933.93 302,862.66 302,862.66 437,925.01 437,925.01 317,254.41 249,494.41 212,774.53 237,526.53 0.00 0.00 15,905.00 15,905.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,826,808.95 0.00 1708.56 1708.56 3870.72 0.00 13384.38 40635.20 40635.20 28468.47 55068.08 47868.11 54515.28 54515.28 78826.50 78826.50 57105.79 44908.99 38299.42 42754.78 0.00 0.00 2862.90 2862.90 688,825.61 TITULACION Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Inscripción Declaratoria de Fábrica Glb 1.0 1,000.00 1,000.00 1,000.00 0.01% 1,000.00 1,000.00 OK Independizacion y reglamento interno Glb 1.0 2,500.00 2,500.00 2,500.00 0.03% 2,500.00 2,500.00 OK Certificados Registrales Inmobiliarios Glb 1.0 500.00 500.00 500.00 0.01% 500.00 500.00 OK TOTAL TITULACION 4,000.00 - 0 4,000.00 0.05% 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 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 1,000.00 2,500.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,000.00 GASTOS ADMINISTRATIVOS Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Gastos Administrativos mes 42.0 7,000.0 294,000.0 294,000.0 3.93% 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 294,000.00 OK 0.00% 0.00 OK TOTAL GASTOS ADMINISTRATIVOS 294,000.0 - 0 294,000.0 3.93% 0.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 0.00 0.00 0.00 0.00 0.00 0.00 294,000.00 PUBLICIDAD Y VENTAS Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Plan de MK glb 1.0 9,048.8 9,048.8 1,628.8 10,677.6 0.14% 4,524.42 4,524.42 9,048.83 OK Sala de Ventas y letrero glb 1.0 22,886.8 22,886.8 4,119.6 27,006.4 0.36% 11,443.41 9,154.73 2,288.68 22,886.82 OK Material impreso glb 1.0 5,577.4 5,577.4 1,003.9 6,581.4 0.09% 929.57 929.57 929.57 929.57 929.57 929.57 5,577.42 OK Publicidad en medios (diarios, TV, radio, letreros externos, web, etc.) glb 1.0 66,290.0 66,290.0 11,932.2 78,222.3 1.05% 11,048.34 11,048.34 11,048.34 11,048.34 11,048.34 11,048.34 66,290.04 OK Otros Publicidad (Ferias, etc.) und 5.0 7,244.8 36,224.0 6,520.3 42,744.4 0.57% 7,244.81 7,244.81 7,244.81 7,244.81 7,244.81 36,224.03 OK Staff de ventas mes 24.5 2,000.0 49,000.0 49,000.0 0.65% 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 49,000.00 OK Comision por Ventas u 81.0 250.0 20,250.0 20,250.0 0.27% 250.00 500.00 1,000.00 0.00 0.00 250.00 250.00 250.00 250.00 250.00 0.00 500.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 250.00 0.00 0.00 0.00 20,250.00 OK 0.00% 0.00 OK TOTAL PUBLICIDAD 209,277.1 25,204.9 234,482.0 3.13% 0.00 4,524.42 0.00 0.00 4,524.42 0.00 250.00 25,921.32 3,000.00 2,000.00 21,222.71 9,494.81 2,250.00 9,494.81 30,627.44 2,250.00 2,000.00 9,744.81 14,727.91 4,038.68 1,750.00 1,750.00 1,750.00 13,727.91 1,750.00 13,727.91 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,250.00 1,000.00 1,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 209,277.13 814.39 814.39 4215.84 3460.09 1304.06 1304.06 5107.94 1304.06 2156.02 411.9627500136 2156.02 2156.02 25,204.88 GASTOS BANCARIOS Y FINANCIEROS Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Comisión estructuración % 1.3 4,132,352.0 55,606.2 10,009.1 65,615.27 0.88% 21,186.44 34,419.72 55,606.16 OK Costos financieros 152,661.9 27,479.1 152,661.9 2.04% 0.00 0.00 0.00 0.00 0.00 0.00 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 152,661.93 Tasación 1.0 800.0 800.0 144.0 944.0 0.01% 800.00 800.00 OK Inspecciones de Avance de Obra 15.0 400.0 6,000.0 1,080.0 7,080.0 0.09% 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 6,000.00 OK TOTAL GASTOS BANCARIOS 215,068.1 38,712.3 226,301.2 3.02% 0.00 0.00 800.00 0.00 0.00 0.00 25,427.05 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,640.61 4,640.61 39,060.33 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,640.61 4,240.61 4,240.61 4,240.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 215,068.09 144.0 3813.56 72 72 6267.55 72 72 72 72 72 72 72 72 72 72 72 72 11,233.11 OTROS EGRESOS (Especificar) Unid. Cantidad P.U. Sin IGV IGV TOTAL Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Imprevistos / Contingencia - 0 - 0 - 0 0.00% 0.00 OK 0.00% 0.00 OK TOTAL OTROS EGRESOS - 0 - 0 - 0 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 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OK 100.00% Total IGV 758,967.44 IGV 255.38 1,674.26 144.00 383.08 1,612.47 735.98 3,813.56 4,215.84 - 0 - 0 3,460.09 1,304.06 - 0 2,501.18 5,107.94 - 0 - 0 3,299.25 2,156.02 2,120.52 1,708.56 3,870.72 - 0 15,540.40 40,707.20 42,863.22 34,736.02 55,140.08 47,940.11 54,587.28 54,587.28 78,898.50 78,898.50 57,177.79 44,980.99 38,371.42 42,826.78 72.00 72.00 2,862.90 2,862.90 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 731,488.29 Total Costos 6,752,454.63 758,967.44 7,483,942.92 PRESUPUESTO Octubre 2015 Aporte Cliente Interbank Preventa 31% Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL TERRENO 2,104,998.88 1,354,998.88 750,000.00 0.00 20,000.00 0.00 0.00 184,259.95 0.00 1,215,858.93 0.00 0.00 150,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.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 534,880.00 0.00 0.00 0.00 0.00 0.00 2,104,998.88 COSTO DE OBRA 4,515,634.56 367,187.56 1,631,604.00 2,516,843.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 11,200.56 11,200.56 25,374.72 0.00 87,742.04 266,386.31 266,386.31 186,626.62 361,001.83 313,802.04 357,377.94 357,377.94 516,751.51 516,751.51 374,360.20 294,403.40 251,073.95 280,281.31 0.00 0.00 18,767.90 18,767.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,515,634.56 COSTOS INDIRECTOS 863,309.48 828,309.48 0.00 35,000.00 4,114.19 17,975.67 7,944.00 9,511.28 17,570.64 14,824.78 36,490.61 41,377.77 14,240.61 13,240.61 35,923.41 22,039.48 13,490.61 29,887.23 46,975.99 13,490.61 13,240.61 35,869.06 28,424.54 15,691.25 12,990.61 12,990.61 12,990.61 27,124.54 48,462.61 27,596.54 54,077.88 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 29,812.61 19,120.61 15,990.61 12,740.61 8,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 863,309.48 TOTAL INVERSION 7,483,942.92 2,550,495.92 2,381,604.00 2,551,843.00 24,114.19 17,975.67 7,944.00 193,771.23 17,570.64 1,230,683.72 36,490.61 41,377.77 164,240.61 13,240.61 35,923.41 22,039.48 13,490.61 29,887.23 46,975.99 13,490.61 13,240.61 35,869.06 28,424.54 26,891.81 24,191.17 38,365.33 12,990.61 114,866.59 314,848.92 293,982.86 240,704.50 374,464.44 327,264.65 370,840.55 370,840.55 530,214.12 530,214.12 387,822.81 307,866.01 264,536.56 293,743.92 13,462.61 29,812.61 37,888.51 34,758.51 12,740.61 8,000.00 535,880.00 0.00 0.00 0.00 0.00 0.00 7,483,942.92 100% 34% 32% 34% 3,277,979.91 -761,135.91 COSTO DE OBRA 4,515,634.56 367,186.56 1,631,604.00 2,516,844.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 11,200.56 11,200.56 25,374.72 0.00 87,742.04 266,386.31 266,386.31 186,626.62 361,001.83 313,802.04 357,377.94 357,377.94 516,751.51 516,751.51 374,360.20 294,403.40 251,073.95 280,281.31 0.00 0.00 18,767.90 18,767.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,515,634.56 Obras Preliminares 198,002.57 198,002.57 0.00 0.00 0.00 0.00 8,475.00 8,475.00 0.00 0.00 60,350.86 60,350.86 60,350.86 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 198,002.57 Estructuras 1,512,854.21 122,348.18 495,154.00 895,352.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 124,698.51 124,698.51 124,698.51 189,793.11 189,793.11 189,793.11 189,793.11 189,793.11 189,793.11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,512,854.21 Arquitectura 1,030,427.97 0.00 426,425.00 604,002.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 32,972.08 32,972.08 153,563.47 153,563.47 175,114.97 175,114.97 153,563.47 153,563.47 0.00 0.00 0.00 0.00 1,030,427.97 Instalaciones Sanitarias 193,536.09 4,762.09 77,588.00 111,186.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,504.71 5,504.71 5,504.71 22,056.43 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 16,551.73 0.00 0.00 3,000.00 3,000.00 193,536.09 Instalaciones Electricas 268,468.37 24,333.37 100,342.00 143,793.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,009.42 11,009.42 11,009.42 30,871.49 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 19,862.07 0.00 0.00 12,905.00 12,905.00 268,468.37 Implementación ACI 89,872.80 1,847.80 36,179.00 51,846.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 11,234.10 0.00 0.00 0.00 0.00 0.00 0.00 89,872.80 Equipamiento 121,000.00 0.00 49,732.00 71,268.00 0.00 0.00 0.00 0.00 19,200.00 0.00 0.00 0.00 0.00 0.00 19,200.00 0.00 0.00 0.00 0.00 0.00 60,500.00 0.00 0.00 22,100.00 0.00 0.00 0.00 0.00 121,000.00 Gastos Generales 202,941.12 408.12 83,243.00 119,290.00 0.00 0.00 508.50 508.50 1,152.00 0.00 3,621.05 12,093.81 12,093.81 8,472.76 16,389.31 14,246.46 16,224.79 16,224.79 23,460.27 23,460.27 16,995.77 13,365.77 11,398.64 12,724.64 0.00 0.00 0.00 0.00 202,941.12 Utilidad y Honorarios 202,941.12 408.12 83,243.00 119,290.00 0.00 0.00 508.50 508.50 1,152.00 0.00 3,621.05 12,093.81 12,093.81 8,472.76 16,389.31 14,246.46 16,224.79 16,224.79 23,460.27 23,460.27 16,995.77 13,365.77 11,398.64 12,724.64 0.00 0.00 0.00 0.00 202,941.12 IGV de la Constructora 688,825.61 8,311.61 279,698.00 400,816.00 0.00 0.00 1,708.56 1,708.56 3,870.72 0.00 13,384.38 40,635.20 40,635.20 28,468.47 55,068.08 47,868.11 54,515.28 54,515.28 78,826.50 78,826.50 57,105.79 44,908.99 38,299.42 42,754.78 0.00 0.00 2,862.90 2,862.90 688,825.61 Instalación de Poliza CAR 6,764.70 6,764.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,764.70 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 6,764.70 COSTOS INDIRECTOS 863,309.48 828,309.48 0.00 35,000.00 4,114.19 17,975.67 7,944.00 9,511.28 17,570.64 14,824.78 36,490.61 41,377.77 14,240.61 13,240.61 35,923.41 22,039.48 13,490.61 29,887.23 46,975.99 13,490.61 13,240.61 35,869.06 28,424.54 15,691.25 12,990.61 12,990.61 12,990.61 27,124.54 48,462.61 27,596.54 54,077.88 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 13,462.61 29,812.61 19,120.61 15,990.61 12,740.61 8,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 863,309.48 Honorarios de Diseño Proyecto 36,381.48 36,381.48 0.00 0.00 2,074.19 5,636.86 0.00 2,511.28 5,231.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,847.75 0.00 0.00 0.00 13,079.58 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36,381.48 Gastos Legales Notariales, Municipales y Titulación 72,144.78 72,144.78 0.00 0.00 2,040.00 0.00 0.00 0.00 0.00 7,824.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 500.00 300.00 0.00 0.00 0.00 0.00 0.00 35,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 16,350.00 6,130.00 3,500.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 72,144.78 Gastos de Ventas 234,482.02 234,482.02 0.00 0.00 0.00 5,338.81 0.00 0.00 5,338.81 0.00 250.00 30,137.16 3,000.00 2,000.00 24,682.80 10,798.87 2,250.00 10,798.87 35,735.38 2,250.00 2,000.00 11,048.87 16,883.93 4,450.64 1,750.00 1,750.00 1,750.00 15,883.93 1,750.00 15,883.93 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,250.00 1,000.00 1,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 234,482.02 Gastos Administrativos 294,000.00 294,000.00 0.00 0.00 0.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 0.00 0.00 0.00 0.00 0.00 0.00 294,000.00 Comision de Estructuracion 226,301.19 191,301.19 0.00 35,000.00 0.00 0.00 944.00 0.00 0.00 0.00 29,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,240.61 4,712.61 4,712.61 45,327.88 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,712.61 4,240.61 4,240.61 4,240.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 226,301.19 Valorización Aporte Cliente 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 11,200.56 11,200.56 25,374.72 0.00 87,742.04 231,668.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 0.00 0.00 0.00 367,186.56 0.00 Valorizacion Preventa (Costo de Obra) 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 0.00 0.00 0.00 34,717.64 266,386.31 186,626.62 361,001.83 313,802.04 357,377.94 357,377.94 516,751.51 122,802.17 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 2,516,844.00 0.00 Valorizacion Preventa (Costos Indirectos) 35,000.00 Valorizacion Ventas 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 393,949.35 374,360.20 294,403.40 251,073.95 280,281.31 0.00 0.00 18,767.90 18,767.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,631,604.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 Ventas 2,200,000.00 749,750.64 700,102.72 750,146.64 INVERSION 1,400,000.00 477,114.05 445,519.91 477,366.04 Utilidad 800,000.00 ESTRUCTURA FIN 10.6. ESTRUCTURA DE FINANCIAMIENTO - LINEA ACTUALIZADA Nombre del Proyecto URBAN COLLECTION MAGDALENA (Expresado en Dólares Americanos) PRESUPUESTO Junio 2015 Aporte Cliente Interbank Preventa 31% PRESUPUESTO Octubre 2015 Aporte Cliente Interbank Preventa 31% TERRENO 2,104,999.00 1,354,999.00 750,000.00 - 0 2,104,998.88 1,354,998.88 750,000.00 - 0 COSTO DE OBRA 4,506,644.00 358,196.00 1,631,604.00 2,516,843.00 4,515,634.56 367,187.56 1,631,604.00 2,516,843.00 COSTOS INDIRECTOS 474,884.00 439,884.00 - 0 35,000.00 863,309.48 828,309.48 - 0 35,000.00 TOTAL INVERSION 7,086,527.00 2,153,079.00 2,381,604.00 2,551,843.00 7,483,942.92 2,550,495.92 2,381,604.00 2,551,843.00 100% 30% 34% 36% 100% 34% 32% 34% COSTO DE OBRA 4,506,645.00 358,197.00 1,631,604.00 2,516,844.00 4,515,634.56 367,186.56 1,631,604.00 2,516,844.00 Obras Preliminares 187,993.00 187,993.00 - 0 - 0 198,002.57 198,002.57 - 0 - 0 Estructuras 1,508,130.00 124,702.00 495,154.00 888,274.00 1,512,854.21 122,348.18 495,154.00 895,352.03 Arquitectura 1,037,506.00 - 0 426,425.00 611,081.00 1,030,427.97 - 0 426,425.00 604,002.97 Instalaciones Sanitarias 188,774.00 - 0 77,588.00 111,186.00 193,536.09 4,762.09 77,588.00 111,186.00 Instalaciones Electricas 244,134.00 - 0 100,342.00 143,793.00 268,468.37 24,333.37 100,342.00 143,793.00 Implementación ACI 88,025.00 - 0 36,179.00 51,846.00 89,872.80 1,847.80 36,179.00 51,846.00 Equipamiento 121,000.00 - 0 49,732.00 71,268.00 121,000.00 - 0 49,732.00 71,268.00 Gastos Generales 202,534.00 - 0 83,243.00 119,290.00 202,941.12 408.12 83,243.00 119,290.00 Utilidad y Honorarios 202,534.00 - 0 83,243.00 119,290.00 202,941.12 408.12 83,243.00 119,290.00 IGV de la Constructora 680,513.00 - 0 279,698.00 400,816.00 688,825.61 8,311.61 279,698.00 400,816.00 Instalación de Poliza CAR 45,502.00 45,502.00 - 0 - 0 6,764.70 6,764.70 - 0 - 0 COSTOS INDIRECTOS 474,884.00 439,884.00 0.00 35,000.00 863,309.48 828,309.48 0.00 35,000.00 Honorarios de Diseño Proyecto 36,784.00 36,784.00 - 0 - 0 36,381.48 36,381.48 - 0 - 0 Gastos Legales Notariales, Municipales y Titulación 66,820.00 66,820.00 - 0 - 0 72,144.78 72,144.78 - 0 - 0 Gastos de Ventas 154,280.00 154,280.00 - 0 - 0 234,482.02 234,482.02 - 0 - 0 Gastos Administrativos 182,000.00 182,000.00 - 0 - 0 294,000.00 294,000.00 - 0 - 0 Comision de Estructuracion 35,000.00 - 0 - 0 35,000.00 226,301.19 191,301.19 - 0 35,000.00 Flujo Ingresos 10.7. FLUJO DE INGRESOS - LINEA ACTUALIZADA VELOCIDAD DE VENTA DE INMUEBLES Velocidad de Ventas 3 (Expresado en Dólares Americanos) Tipo de cambio 2.80 PROGRAMACIÓN Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Compra de terreno Anteproyecto Acumulación de lotes Proyecto Licencia Demolición Demolición Licencia Construcción Construcción Caseta de Ventas Publicidad Entrega a clientes y Finalizacion de Obra Independización Pre-venta Ventas Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Total Separaciones 1.0 2.0 4.0 - 0 - 0 1.0 1.0 1.0 1.0 1.0 - 0 4.0 1.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 - 0 - 0 - 0 - 0 - 0 - 0 81.0 81 Velocidad de ventas de departamentos - 0 - 0 - 0 1.0 2.0 4.0 - 0 - 0 1.0 1.0 1.0 1.0 1.0 - 0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 1.0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 81.0 -0 Velocidad de ventas de estacionamientos techados - 0 - 0 1.0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 54.0 -0 Velocidad de ventas de estacionamientos no techados - 0 8.0 8.0 -0 Velocidad de ventas de depósitos - 0 - 0 - 0 - 0 - 0 - 0 1.0 - 0 1.0 - 0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 37.0 -0 Velocidad de ventas de comercio 8.0 8.0 -0 Total Unidades - 0 - 0 - 0 - 0 - 0 - 0 2.0 4.0 9.0 - 0 - 0 2.0 2.0 2.0 2.0 2.0 - 0 7.0 5.0 5.0 6.0 6.0 7.0 6.0 7.0 6.0 8.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 10.0 11.0 11.0 12.0 12.0 12.0 10.0 9.0 9.0 22.0 - 0 - 0 - 0 - 0 - 0 188.0 35.0 FLUJO DE INGRESOS (Expresado en Dólares Americanos) Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Total Ingresos por ventas de departamentos Separaciones 250 500 1,000 - 0 - 0 250 250 250 250 250 - 0 1,000 250 250 500 500 500 500 500 500 750 750 750 750 750 750 750 750 750 750 750 750 750 750 750 750 750 - 0 - 0 - 0 - 0 - 0 - 0 20,250 - 0 Inicial - 0 7,949 15,897 31,795 - 0 - 0 7,949 7,949 7,949 7,949 7,949 - 0 15,897 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 23,846 7,949 - 0 - 0 - 0 - 0 - 0 - 0 - 0 643,845 - 0 Ingresos por ventas de estacionamientos techados Inicial - 0 - 0 - 0 - 0 1,080 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 2,159 2,159 2,159 2,159 2,159 2,159 2,159 2,159 3,239 3,239 3,239 3,239 3,239 3,239 3,239 3,239 3,239 - 0 - 0 - 0 - 0 58,303 - 0 Ingresos por ventas de estacionamientos no techados Desembolso al contado - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 62,385 - 0 - 0 - 0 - 0 - 0 62,385 - 0 Ingresos por ventas de depósitos Inicial - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 309 - 0 309 - 0 309 309 309 309 309 309 309 309 618 618 618 928 928 928 928 928 928 928 - 0 - 0 - 0 - 0 11,441 - 0 Ingresos por ventas de comercio Desembolso al contado - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 420,532 - 0 - 0 - 0 - 0 - 0 420,532 - 0 Ingresos por Valorización Cuenta Recaudadora - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 40,064 160,951 335,017 286,737 330,313 330,313 489,687 489,687 347,296 267,339 - 0 - 0 - 0 - 0 3,438,139 89,000 6,604,542 4,383,159.0 TOTAL INGRESOS SIN IGV - 0 - 0 - 0 - 0 - 0 - 0 250 8,449 16,897 32,874 - 0 250 8,199 8,199 8,199 8,199 7,949 1,000 17,227 25,176 25,426 25,426 25,426 25,735 25,426 65,799 186,627 361,002 313,802 357,378 357,378 516,752 516,752 374,360 294,403 27,374 28,454 28,454 28,763 28,763 28,763 3,451,004 4,917 487,084 93,167 - 0 - 0 - 0 - 0 7,821,298 7,821,297.7 IGV - 0 - 0 - 0 - 0 - 0 - 0 23 760 1,521 2,959 - 0 23 738 738 738 738 715 90 1,550 2,266 2,288 2,288 2,288 2,316 2,288 5,922 16,796 32,490 28,242 32,164 32,164 46,508 46,508 33,692 26,496 2,464 2,561 2,561 2,589 2,589 2,589 310,590 443 43,838 8,385 - 0 - 0 - 0 - 0 703,917 703,916.8 TOTAL INGRESOS INCL. IGV - 0 - 0 - 0 - 0 - 0 - 0 273 9,209 18,418 35,833 - 0 273 8,937 8,937 8,937 8,937 8,664 1,090 18,778 27,442 27,714 27,714 27,714 28,051 27,714 71,721 203,423 393,492 342,044 389,542 389,542 563,259 563,259 408,053 320,900 29,838 31,014 31,014 31,351 31,351 31,351 3,761,594 5,359 530,922 101,552 - 0 - 0 - 0 - 0 8,525,214 8,525,214.5 Total Ingresos Acumulado Supuestos Monto de separaciones Departamentos (Dólares) 250.00 Cuota Inicial 10.00% Pago cuota inicial calculada desde la separación (Número de días) 30 Pago Saldo precio de venta calculada desde la separación(Número de días) 60 Retención del Banco sobre saldo de precio de venta 0.00% Plazo de devolución de la retención del Banco (Número de días después de terminada la construcción) 90 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! PREVENTA VALORIZACION PREVENTA - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 69,718 266,386 186,627 361,002 313,802 357,378 357,378 516,752 122,802 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 2,551,844.0 - 0 VALORIZACION VENTA - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 393,949 374,360 294,403 251,074 280,281 - 0 - 0 18,768 18,768 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 INICIALES 10% + PAGOS AL CONTADO (Inveb) - 0 - 0 - 0 - 0 - 0 - 0 250 8,449 16,897 32,874 - 0 250 8,199 8,199 8,199 8,199 7,949 1,000 17,227 25,176 25,426 25,426 25,426 25,735 25,426 25,735 25,676 25,985 27,065 27,065 27,065 27,065 27,065 27,065 27,065 27,374 28,454 28,454 28,763 28,763 28,763 12,865 4,917 487,084 4,167 - 0 - 0 - 0 - 0 1,216,755.5 - 0 SALDO A VALORIZACION SIN CREDITO ACUMULADO - 0 - 0 - 0 - 0 - 0 - 0 (250) (8,449) (16,897) (32,874) - 0 (250) (8,199) (8,199) (8,199) (8,199) (7,949) (1,000) (17,227) (25,176) (25,426) (25,426) (25,426) (25,735) 44,292 240,651 160,951 335,017 286,737 330,313 330,313 489,687 489,687 347,296 267,339 (27,374) (28,454) (28,454) (28,763) (28,763) (28,763) (12,865) (4,917) (487,084) (4,167) - 0 - 0 - 0 - 0 2,397,801.5 CREDITO DE INICIALES INVEB ACUMULADO - 0 - 0 - 0 - 0 - 0 - 0 250 8,699 25,596 58,471 58,471 58,721 66,919 75,118 83,317 91,515 99,464 100,464 117,691 142,867 168,293 193,718 219,144 244,879 200,587 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 27,374 55,827 84,281 113,044 141,807 170,569 183,435 188,351 675,435 679,602 679,602 679,602 679,602 679,602 VALORIZACION (cargado a Cuenta Recaudadora) - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 40,064 160,951 335,017 286,737 330,313 330,313 489,687 489,687 347,296 267,339 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 3,077,403.6 CUENTA RECAUDADORA (Banco) Desembolso Departamentos 2,582,590 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 221,365 73,788 - 0 - 0 - 0 - 0 - 0 - 0 - 0 5,976,850.8 Desembolso estacionamientos techados 87,454 9,717 9,717 19,434 19,434 19,434 19,434 19,434 19,434 19,434 19,434 29,151 29,151 29,151 29,151 29,151 29,151 29,151 29,151 29,151 - 0 - 0 - 0 - 0 524,724.8 Desembolso depositos 5,566 - 0 2,783 2,783 2,783 2,783 2,783 2,783 2,783 2,783 5,566 5,566 5,566 8,349 8,349 8,349 8,349 8,349 8,349 8,349 - 0 - 0 - 0 - 0 102,966.6 - 0 Flujo de Caja Cuenta Recaudadora - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 2,635,546 70,131 (101,152) (43,155) (86,731) (86,731) (246,105) (246,105) (103,714) (23,757) 246,365 256,082 256,082 258,865 258,865 258,865 111,288 37,500 37,500 37,500 - 0 - 0 - 0 - 0 3,527,138.7 Flujo de Caja Acumulado - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 2,635,546 2,705,677 2,604,525 2,561,370 2,474,638 2,387,907 2,141,802 1,895,697 1,791,984 1,768,227 2,014,592 2,270,674 2,526,756 2,785,621 3,044,485 3,303,350 3,414,639 3,452,139 3,489,639 3,527,139 3,527,139 3,527,139 3,527,139 3,527,139 Necesidad de Financiamiento - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Flujo de Ingresos Acumulado sin IGV 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 0 0 0 0 0 0 250 8448.6979967445604 16897.395993489121 32874.472585007461 0 250 8198.6979967445604 8198.6979967445604 8198.6979967445604 8198.6979967445604 7948.6979967445604 1000 17227.076591518344 25175.774588262906 25425.774588262906 25425.774588262906 25425.774588262906 25734.983613802207 25425.774588262906 65798.959116800746 186626.6210592 361001.82685653341 313802.03661333339 357377.94216693344 357377.94216693344 516751.51416000002 516751.51416000002 374360.19797866663 294403.3979786667 27373.873237370732 28453.553835399951 28453.553835399951 28762.762860939249 28762.762860939249 28762.762860939249 3451004.0216826424 4916.6688707055691 487084.10006336606 93166.668870705573 0 0 0 0 Flujo Egresos 10.8. FLUJO DE EGRESOS - LINEA ACTUALIZADA PROGRAMACIÓN Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Compra de terreno Anteproyecto Acumulación de lotes Proyecto Licencia Demolición Demolición Licencia Construcción Construcción Caseta de Ventas Publicidad Entrega a clientes y Finalizacion de Obra Independización Pre-venta Ventas FLUJO DE EGRESOS (Expresado en Dólares Americanos) Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Total TERRENO 20,000 0 0 184,260 0 1,215,859 0 0 150,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 534,880 0 0 0 0 0 2,104,999 - 0 COSTO DE OBRA Obras Preliminares 0 0 8,475 8,475 0 0 60,351 60,351 60,351 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 198,003 - 0 Estructuras 0 0 0 0 0 0 0 124,699 124,699 124,699 189,793 189,793 189,793 189,793 189,793 189,793 0 0 0 0 0 0 0 0 1,512,854 - 0 Arquitectura 0 0 0 0 0 0 0 0 0 0 0 0 32,972 32,972 153,563 153,563 175,115 175,115 153,563 153,563 0 0 0 0 1,030,428 - 0 Instalaciones Sanitarias 0 0 0 0 0 0 0 5,505 5,505 5,505 22,056 16,552 16,552 16,552 16,552 16,552 16,552 16,552 16,552 16,552 0 0 3,000 3,000 193,536 - 0 Instalaciones Electricas 0 0 0 0 0 0 0 11,009 11,009 11,009 30,871 19,862 19,862 19,862 19,862 19,862 19,862 19,862 19,862 19,862 0 0 12,905 12,905 268,468 - 0 Implementación ACI 0 0 0 0 0 0 0 0 0 0 11,234 11,234 11,234 11,234 11,234 11,234 11,234 11,234 0 0 0 0 0 0 89,873 - 0 Equipamiento 0 0 0 0 19,200 0 0 0 0 0 19,200 0 0 0 0 0 60,500 0 0 22,100 0 0 0 0 121,000 - 0 Gastos Generales 0 0 509 509 1,152 0 3,621 12,094 12,094 8,473 16,389 14,246 16,225 16,225 23,460 23,460 16,996 13,366 11,399 12,725 0 0 0 0 202,941 - 0 Utilidad y Honorarios 0 0 509 509 1,152 0 3,621 12,094 12,094 8,473 16,389 14,246 16,225 16,225 23,460 23,460 16,996 13,366 11,399 12,725 0 0 0 0 202,941 - 0 Instalación de Poliza CAR 0 0 0 0 0 0 6,765 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,765 - 0 COSTOS INDIRECTOS Honorarios de Diseño Proyecto 1,819 4,777 0 2,128 4,434 0 0 0 0 0 0 0 0 6,651 0 0 0 11,084 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30,893 - 0 Gastos Legales Notariales, Municipales y Titulación 2,040 0 0 0 0 7,089 0 0 0 0 0 0 0 0 0 0 0 500 300 0 0 0 0 0 35,000 0 0 0 0 0 0 0 0 0 0 0 0 0 16,350 6,130 3,500 500 0 0 0 0 0 0 0 71,409 - 0 Gastos de Ventas 0 4,524 0 0 4,524 0 250 25,921 3,000 2,000 21,223 9,495 2,250 9,495 30,627 2,250 2,000 9,745 14,728 4,039 1,750 1,750 1,750 13,728 1,750 13,728 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,250 1,000 1,000 1,000 0 0 0 0 0 209,277 - 0 Gastos Administrativos 0 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 0 0 0 0 0 0 294,000 - 0 Gastos Financieros 0 0 800 0 0 0 25,427 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,641 4,641 39,060 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,641 4,241 4,241 4,241 0 0 0 0 0 0 0 215,068 - 0 Total Egresos sin IGV 23,858.8 16,301.4 7,800.0 193,388.2 15,958.2 1,229,947.7 32,677.0 37,161.9 164,240.6 13,240.6 32,463.3 20,735.4 13,490.6 27,386.0 41,868.1 13,490.6 13,240.6 32,569.8 26,268.5 24,771.3 22,482.6 34,494.6 12,990.6 99,326.2 274,141.7 251,119.6 205,968.5 319,324.4 279,324.5 316,253.3 316,253.3 451,315.6 451,315.6 330,645.0 262,885.0 226,165.1 250,917.1 13,390.6 29,740.6 35,025.6 31,895.6 12,740.6 8,000.0 535,880.0 - 0 - 0 - 0 - 0 - 0 6,752,454.63 6,752,454.63 IGV 255.4 1,674.3 144.0 383.1 1,612.5 736.0 3,813.6 4,215.8 - 0 - 0 3,460.1 1,304.1 - 0 2,501.2 5,107.9 - 0 - 0 3,299.3 2,156.0 2,120.5 1,708.6 3,870.7 - 0 15,540.4 40,707.2 42,863.2 34,736.0 55,140.1 47,940.1 54,587.3 54,587.3 78,898.5 78,898.5 57,177.8 44,981.0 38,371.4 42,826.8 72.0 72.0 2,862.9 2,862.9 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 731,488.29 758,967.44 TOTAL EGRESOS con IGV 24,114.2 17,975.7 7,944.0 193,771.2 17,570.6 1,230,683.7 36,490.6 41,377.8 164,240.6 13,240.6 35,923.4 22,039.5 13,490.6 29,887.2 46,976.0 13,490.6 13,240.6 35,869.1 28,424.5 26,891.8 24,191.2 38,365.3 12,990.6 114,866.6 314,848.9 293,982.9 240,704.5 374,464.4 327,264.6 370,840.6 370,840.6 530,214.1 530,214.1 387,822.8 307,866.0 264,536.6 293,743.9 13,462.6 29,812.6 37,888.5 34,758.5 12,740.6 8,000.0 535,880.0 - 0 - 0 - 0 - 0 - 0 7,483,942.92 7,483,942.92 Flujo de Egresos Acumulado sin IGV 41791 41821 41852 41883 41913 41944 41974 42005 42036 4206 4 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 23858.801599999999 16301.419254237289 7800 193388.15240000002 15958.170254237288 1229947.7310289389 32677.049718520058 37161.928367674423 164240.60904055394 13240.609040553954 32463.323729819491 20735.414125299718 13490.609040553954 27386.046625299718 41868.051507900047 13490.609040553954 13240.609040553954 32569.801625299719 26268.518645073727 24771.290985074094 22482.609040553954 34494.609040553958 12990.609040553954 99326.182121740407 274141.72194722068 251119.63155174043 205968.48182276537 319324.36061388737 279324.53837388736 316253.27189388737 316253.27189388737 451315.62104055402 451315.62104055402 330645.01410722063 262885.01410722069 226165.14210722066 250917.14210722066 13390.609040553954 29740.609040553954 35025.609040553958 31895.609040553954 12740.609040553954 8000 535880 0 0 0 0 0 FC 1 10.9. FLUJO DE CAJA ECONÓMICO Y FINANCIERO - LINEA ACTUALIZADA FLUJO DE CAJA ECONÓMICO (Expresado en Dólares Americanos) Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 TOTAL Valor venta - 0 - 0 - 0 - 0 - 0 - 0 250 8,449 16,897 32,874 - 0 250 8,199 8,199 8,199 8,199 7,949 1,000 17,227 25,176 25,426 25,426 25,426 25,735 25,426 65,799 186,627 361,002 313,802 357,378 357,378 516,752 516,752 374,360 294,403 27,374 28,454 28,454 28,763 28,763 28,763 3,451,004 4,917 487,084 93,167 - 0 - 0 - 0 - 0 7,821,297.67 IGV 18% sobre valor de fabrica - 0 - 0 - 0 - 0 - 0 - 0 23 760 1,521 2,959 - 0 23 738 738 738 738 715 90 1,550 2,266 2,288 2,288 2,288 2,316 2,288 5,922 16,796 32,490 28,242 32,164 32,164 46,508 46,508 33,692 26,496 2,464 2,561 2,561 2,589 2,589 2,589 310,590 443 43,838 8,385 - 0 - 0 - 0 - 0 703,916.79 INGRESOS INC IGV - 0 - 0 - 0 - 0 - 0 - 0 273 9,209 18,418 35,833 - 0 273 8,937 8,937 8,937 8,937 8,664 1,090 18,778 27,442 27,714 27,714 27,714 28,051 27,714 71,721 203,423 393,492 342,044 389,542 389,542 563,259 563,259 408,053 320,900 29,838 31,014 31,014 31,351 31,351 31,351 3,761,594 5,359 530,922 101,552 - 0 - 0 - 0 - 0 8,525,214.46 Valor venta 23,859 16,301 7,800 193,388 15,958 1,229,948 32,677 37,162 164,241 13,241 32,463 20,735 13,491 27,386 41,868 13,491 13,241 32,570 26,269 24,771 22,483 34,495 12,991 99,326 274,142 251,120 205,968 319,324 279,325 316,253 316,253 451,316 451,316 330,645 262,885 226,165 250,917 13,391 29,741 35,026 31,896 12,741 8,000 535,880 - 0 - 0 - 0 - 0 - 0 6,752,454.63 IGV 255 1,674 144 383 1,612 736 3,814 4,216 - 0 - 0 3,460 1,304 - 0 2,501 5,108 - 0 - 0 3,299 2,156 2,121 1,709 3,871 - 0 15,540 40,707 42,863 34,736 55,140 47,940 54,587 54,587 78,899 78,899 57,178 44,981 38,371 42,827 72 72 2,863 2,863 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 731,488.29 EGRESOS INC IGV 24,114 17,976 7,944 193,771 17,571 1,230,684 36,491 41,378 164,241 13,241 35,923 22,039 13,491 29,887 46,976 13,491 13,241 35,869 28,425 26,892 24,191 38,365 12,991 114,867 314,849 293,983 240,704 374,464 327,265 370,841 370,841 530,214 530,214 387,823 307,866 264,537 293,744 13,463 29,813 37,889 34,759 12,741 8,000 535,880 - 0 - 0 - 0 - 0 - 0 7,483,942.92 UTILIDAD OPERATIVA NETA (EBIT) (24,114) (17,976) (7,944) (193,771) (17,571) (1,230,684) (36,218) (32,169) (145,822) 22,593 (35,923) (21,767) (4,554) (20,951) (38,039) (4,554) (4,577) (34,779) (9,647) 550 3,523 (10,651) 14,723 (86,815) (287,135) (222,262) (37,281) 19,028 14,780 18,701 18,701 33,045 33,045 20,230 13,034 (234,699) (262,730) 17,552 1,539 (6,537) (3,407) 3,748,854 (2,641) (4,958) 101,552 - 0 - 0 - 0 - 0 1,041,271.54 IMPUESTOS IGV por pagar al estado - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 RENTA por pagar al estado - 0 - 0 - 0 - 0 - 0 - 0 4 138 276 537 - 0 4 134 134 134 134 130 16 282 412 416 416 416 421 416 1,076 3,051 5,902 5,131 5,843 5,843 8,449 8,449 6,121 4,813 448 465 465 470 470 470 56,424 80 7,964 1,523 - 0 - 0 - 0 163,678 291,556.03 FLUJO DE CAJA OPERATIVO (24,114) (17,976) (7,944) (193,771) (17,571) (1,230,684) (36,222) (32,307) (146,099) 22,055 (35,923) (21,771) (4,688) (21,085) (38,173) (4,688) (4,706) (34,795) (9,929) 138 3,107 (11,067) 14,308 (87,236) (287,551) (223,338) (40,333) 13,125 9,649 12,858 12,858 24,596 24,596 14,109 8,220 (235,147) (263,195) 17,087 1,069 (7,007) (3,877) 3,692,430 (2,721) (12,922) 100,028 - 0 - 0 - 0 (163,678) 749,715.51 FLUJO DE CAJA OPERATIVO ACUMULADO (24,114) (42,090) (50,034) (243,805) (261,376) (1,492,059) (1,528,282) (1,560,588) (1,706,687) (1,684,632) (1,720,556) (1,742,327) (1,747,015) (1,768,099) (1,806,273) (1,810,961) (1,815,667) (1,850,463) (1,860,391) (1,860,253) (1,857,146) (1,868,213) (1,853,905) (1,941,142) (2,228,692) (2,452,030) (2,492,363) (2,479,238) (2,469,589) (2,456,730) (2,443,872) (2,419,276) (2,394,680) (2,380,571) (2,372,351) (2,607,497) (2,870,692) (2,853,605) (2,852,537) (2,859,544) (2,863,422) 829,008 826,287 813,365 913,393 913,393 913,393 913,393 749,716 APORTE DE CAPITAL Aporte Propio 0.0% 24,200 17,900 8,000 193,800 17,500 480,700 36,200 33,000 147,300 16,300 21,800 5,300 21,700 38,800 5,300 5,300 34,800 11,100 1,700 11,700 76,600 289,400 203,700 40,300 117,000 265,000 100 2,124,500 Permuta - 0 Devolución Aporte Propio 0.0% - 0 2,124,500 2,124,500 FLUJO CAJA ECONOMICO 86 (76) 56 29 (71) (749,984) (22) 693 1,201 22,055 (19,623) 29 612 615 627 612 594 5 1,171 1,838 3,107 633 14,308 (10,636) 1,849 (19,638) (33) 13,125 9,649 12,858 12,858 24,596 24,596 14,109 8,220 (118,147) 1,805 17,087 1,069 (7,007) (3,777) 3,692,430 (2,721) (12,922) 100,028 - 0 - 0 - 0 (2,288,178) FLUJO CAJA ECONOMICO ACUM 86 10 66 95 24 (749,959) (749,982) (749,288) (748,087) (726,032) (745,656) (745,627) (745,015) (744,399) (743,773) (743,161) (742,567) (742,563) (741,391) (739,553) (736,446) (735,813) (721,505) (732,142) (730,292) (749,930) (749,963) (736,838) (727,189) (714,330) (701,472) (676,876) (652,280) (638,171) (629,951) (748,097) (746,292) (729,205) (728,137) (735,144) (738,922) 2,953,508 2,950,787 2,937,865 3,037,893 3,037,893 3,037,893 3,037,893 749,716 Financiamiento Bancario 750,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 750,000 Financiamiento Acumulado - 0 - 0 - 0 - 0 - 0 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Amortizacion financiamiento bancario 750,000 - 0 750,000 Gastos Financieros 7.0% - 0 - 0 - 0 - 0 - 0 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 4,241 - 0 - 0 - 0 - 0 - 0 - 0 152,662 0.57% 152,662 152,662 Escudo fiscal intereses - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 42,745.34 - 0 - 0 - 0 - 0 - 0 - 0 - 0 42,745.34 FLUJO DE CAJA DE LA DEUDA - 0 - 0 - 0 - 0 - 0 750,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 (859,917) - 0 - 0 - 0 - 0 - 0 - 0 - 0 (109,917) FLUJO DE CAJA FINANCIERO 86 (76) 56 29 (71) 16 (22) 693 1,201 22,055 (19,623) 29 612 615 627 612 594 5 1,171 1,838 3,107 633 14,308 (10,636) 1,849 (19,638) (33) 13,125 9,649 12,858 12,858 24,596 24,596 14,109 8,220 (118,147) 1,805 17,087 1,069 (7,007) (3,777) 2,832,513 (2,721) (12,922) 100,028 - 0 - 0 - 0 (2,288,178) FLUJO DE CAJA FINANCIERO ACUM. 86 10 66 95 24 41 18 712 1,913 23,968 4,344 4,373 4,985 5,601 6,227 6,839 7,433 7,437 8,609 10,447 13,554 14,187 28,495 17,858 19,708 70 37 13,162 22,811 35,670 48,528 73,124 97,720 111,829 120,049 1,903 3,708 20,795 21,863 14,856 11,078 2,843,592 2,840,870 2,827,948 2,927,977 2,927,977 2,927,977 2,927,977 639,799 RESUMEN FLUJO DE CAJA (expresado en USD) FLUJO CAJA OPERACIONAL (económico o del proyecto) (24,114) (17,976) (7,944) (193,771) (17,571) (1,230,684) (36,222) (32,307) (146,099) 22,055 (35,923) (21,771) (4,688) (21,085) (38,173) (4,688) (4,706) (34,795) (9,929) 138 3,107 (11,067) 14,308 (87,236) (287,551) (223,338) (40,333) 13,125 9,649 12,858 12,858 24,596 24,596 14,109 8,220 (235,147) (263,195) 17,087 1,069 (7,007) (3,877) 3,692,430 (2,721) (12,922) 100,028 - 0 - 0 - 0 (163,678) ( - ) FLUJO CAJA DE LA DEUDA - 0 - 0 - 0 - 0 - 0 750,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 (859,917) - 0 - 0 - 0 - 0 - 0 - 0 - 0 ( = ) FLUJO DE CAJA FINANCIERO (accionista) (24,114) (17,976) (7,944) (193,771) (17,571) (480,684) (36,222) (32,307) (146,099) 22,055 (35,923) (21,771) (4,688) (21,085) (38,173) (4,688) (4,706) (34,795) (9,929) 138 3,107 (11,067) 14,308 (87,236) (287,551) (223,338) (40,333) 13,125 9,649 12,858 12,858 24,596 24,596 14,109 8,220 (235,147) (263,195) 17,087 1,069 (7,007) (3,877) 2,832,513 (2,721) (12,922) 100,028 - 0 - 0 - 0 (163,678) FLUJO DE CAJA FINANCIERO ACUM. (24,114) (42,090) (50,034) (243,805) (261,376) (742,059) (778,282) (810,588) (956,687) (934,632) (970,556) (992,327) (997,015) (1,018,099) (1,056,273) (1,060,961) (1,065,667) (1,100,463) (1,110,391) (1,110,253) (1,107,146) (1,118,213) (1,103,905) (1,191,142) (1,478,692) (1,702,030) (1,742,363) (1,729,238) (1,719,589) (1,706,730) (1,693,872) (1,669,276) (1,644,680) (1,630,571) (1,622,351) (1,857,497) (2,120,692) (2,103,605) (2,102,537) (2,109,544) (2,113,422) 719,092 716,370 703,448 803,477 803,477 803,477 803,477 639,799 ECONOMICO FINANCIERO SUPUESTOS INICIALES VAN -68,033.92 63,532.81 639,799 Precio $/m2 1327.54 TIR mensual 0.85% 1.09% Velocidad de Ventas 3 TIR anual 10.70% 13.86% COK mensual 0.95% 0.95% COK anual 12.00% 12.00% ANALISIS IGV IGV VENTA - 0 - 0 - 0 - 0 - 0 - 0 22.50 760.38 1,520.77 2,958.70 - 0 22.50 737.88 737.88 737.88 737.88 715.38 90.00 1,550.44 2,265.82 2,288.32 2,288.32 2,288.32 2,316.15 2,288.32 5,921.91 16,796.40 32,490.16 28,242.18 32,164.01 32,164.01 46,507.64 46,507.64 33,692.42 26,496.31 2,463.65 2,560.82 2,560.82 2,588.65 2,588.65 2,588.65 310,590.36 442.50 43,837.57 8,385.00 - 0 - 0 - 0 - 0 298,814 IGV COMPRAS 255.38 1,674.26 144.00 383.08 1,612.47 735.98 3,813.56 4,215.84 - 0 - 0 3,460.09 1,304.06 - 0 2,501.18 5,107.94 - 0 - 0 3,299.25 2,156.02 2,120.52 1,708.56 3,870.72 - 0 15,540.40 40,707.20 42,863.22 34,736.02 55,140.08 47,940.11 54,587.28 54,587.28 78,898.50 78,898.50 57,177.79 44,980.99 38,371.42 42,826.78 72.00 72.00 2,862.90 2,862.90 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 599,439 IGV A PAGAR SIN CF (255.38) (1,674.26) (144.00) (383.08) (1,612.47) (735.98) (3,791.06) (3,455.45) 1,520.77 2,958.70 (3,460.09) (1,281.56) 737.88 (1,763.30) (4,370.06) 737.88 715.38 (3,209.25) (605.59) 145.30 579.76 (1,582.40) 2,288.32 (13,224.25) (38,418.88) (36,941.32) (17,939.62) (22,649.91) (19,697.92) (22,423.26) (22,423.26) (32,390.87) (32,390.87) (23,485.38) (18,484.69) (35,907.77) (40,265.96) 2,488.82 2,516.65 (274.25) (274.25) 310,590.36 442.50 43,837.57 8,385.00 - 0 - 0 - 0 - 0 898,253 CREDITO FISCAL ACUMULADO 255.38 1,929.64 2,073.64 2,456.72 4,069.19 4,805.17 8,596.23 12,051.68 10,530.92 7,572.22 11,032.31 12,313.87 11,575.99 13,339.28 17,709.34 16,971.46 16,256.07 19,465.33 20,070.92 19,925.62 19,345.86 20,928.26 18,639.94 31,864.19 70,283.08 107,224.39 125,164.01 147,813.92 167,511.85 189,935.11 212,358.38 244,749.24 277,140.11 300,625.48 319,110.17 355,017.94 395,283.90 392,795.08 390,278.43 390,552.68 390,826.93 80,236.57 79,794.07 35,956.50 27,571.50 27,571.50 27,571.50 27,571.50 27,571.50 IGV A PAGAR AL ESTADO - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Velocidad de Ventas 63,532.81 1 2 3 4 5 1000 (633,407) (708,945) (710,365) (711,572) (711,561) 1050 (520,994) (594,727) (592,227) (593,472) (593,450) 1100 (414,007) (476,915) (474,089) (475,372) (475,243) 1200 (200,950) (239,969) (237,813) (239,173) (238,812) Precio de Preventa 1250 (93,678) (122,016) (119,676) (121,073) (120,597) Precio $/m2 1300 14,307 (4,063) (1,538) (2,898) (2,382) 1327.54 79,851 60,906 63,533 62,200 62,731 Precio de Venta 1400 245,887 231,513 234,396 233,137 233,706 1450 347,707 336,736 339,669 338,461 339,057 FLUJO DE CAJA FINANCIERO ACUMULADO 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 -24114.185888 -42089.8606080000 03 -50033.860608000003 -243805.08944000001 -261375.73034000001 -742059.44536893885 -778281.64190949278 -810588.4631518441 -956687.18298398843 -934632.11453364918 -970555.52690753643 -992326.59344809037 -997014.67038443952 -1018099.3636707887 -1056272.8227186063 -1060960.8996549556 -1065667.3890913047 -1100462.7953818587 -1110391.4869732624 -1110253.3303216617 -1107146.1164755272 -1118213.0626293926 -1103905.2887832581 -1191141.5089026534 -1478692.0482863856 -1702029.8514343866 -1742362.6786577399 -1729237.5031503101 -1719588.5921942922 -1706730.3157942514 -1693872.0393942106 -1669275.8994168804 -1644679.7594395503 -1630570.7398989755 -1622350.5386784007 -1857497.1377363182 -2120691.8977201618 -2103605.3486853386 -2102536.8173802453 -2109544.1860751519 -2113421.5547700585 719091.71773779811 716370.49927083112 703448.34330386401 803476.73733689706 803476.73733689706 803476.73733689706 803476.73733689706 639798.92289216002 FLUJO DE CAJA OPERATIVO ACUMULADO 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 85.814112000000023 10.139391999997315 66.139391999997 315 94.910559999974794 24.269659999976284 -749959.44536893885 -749981.64190949278 -749288.4631518441 -748087.18298398843 -726032.11453364918 -745655.52690753643 -745626.59344809037 -745014.67038443952 -744399.36367078871 -743772.82271860621 -743160.89965495537 -742567.3890913045 -742562.79538185848 -741391.48697326204 -739553.33032166131 -736446.11647552683 -735813.06262939237 -721505.28878325783 -732141.508902653 -730292.04828638525 -749929.8514343861 -749962.67865773942 -736837.50315030967 -727188.59219429165 -714330.31579425093 -701472.03939421021 -676875.89941688022 -652279.75943955022 -638170.73989897536 -629950.53867840045 -748097.13773631805 -746291.89772016159 -729205.34868533839 -728136.81738024496 -735144.18607515155 -738921.55477005802 2953508.304068957 2950787.0856019901 2937864.9296350232 3037893.3236680562 3037893.3236680562 3037893.3236680562 3037893.3236680562 749715.50922331912 image7.jpeg image8.jpeg image9.jpeg image10.jpeg image11.jpeg image12.jpeg image13.jpeg image1.jpeg image2.jpeg image3.jpeg image4.jpeg image5.jpeg image6.jpeg