Perfil Financiero - Modelo
Perfil Financiero - Modelo
Perfil Financiero - Modelo
88
Proyecto larapa 15
Terreno 454,149,918
Incidencia sobre ventas del terreno 4452.9%
Precio directo de adquisición S/.440,916,736
Alcabala S/.13,226,182
Comisiones S/.0
Gastos Notariales y Registrales S/.7,000
Tasación S/.0
Aportes S/.0
Area Total (m2) 304
Precio del terreno por m2 - PEN 1,450,384 3.67 304 1300 1450384
Area libre 20%
Estacionamientos por vivienda 0.6
Pisos 10
Sotano 1
Costo Directo 4,514,400
Costo de construcción (PEN/m2) 1,650 3.67 450 1651.5
Total Area Construida 2,736
Costo de Construccion total 4,514,400
Habilitacion Urbana 0
Plazo de Construcción 12
Indirectos 16,569,780
Costo indirecto 484,190
Arquitectura (USD 4) 42,452
Costo de desarrollo de proyecto (USD 10/m2 + USD50,000) 300,079
Seguros (0.5% de edificación) 22,572
Saneamiento (S/ 1000 por und) 60,400
Licencias, arbitrios, municipales, etc. (0.3%) 13,543
Postventa (0.5%) 22,572
Otros (0.5%) 22,572
Gastos 16,085,589
Gerenciamiento 495,086
Gasto de ventas 495,086
Gasto Financiero 15,095,418
Costo indirecto (PEN/m2) - sin intereses 177
Costos totales 475,234,098
Condiciones de Financiamiento 15
Tasa de terreno 4.5%
Tasa de capital de trabajo 6.0%
Proyecto 1 Ingresos 1 2 3
Cash Flow (PEN) Etapa de Venta Anteproyecto Anteproyecto
Total Departamentos (un) 30
Locales Comerciales (und.) -
Total Estacionamientos (un) 10
Construcción (%) 100%
Valor del departamento 312,390
Crecimiento por fase 0%
Ingresos TOTAL Mes 0 Mes 1 Mes 2
Saldo de Caja Inicial 0 -35,367 -77,506
Ingresos
Separacion 120,000 0
Cuota Inicial 1,754,342
Desembolso de Saldo / Hipotecario / Bonos 16,869,082
Locales Comerciales 0 0 0
Venta Estacionamientos 1,060,000 0 0
Ingreso Total 19,803,424 - -
Costo
Precio Directo del Terreno 0 0 0 0
Alcabala -13,226,182 0 0 -13,226,182
Comisiones 0 0 0 0
Gastos Notariales y Registrales -7,000 0 0 -7,000
Tasación 0 0 0 0
Aportes 0 0 0 0
Ingreso acumulado - - -
Flujo de Sensibilidad
Ticket promedio #REF!
Ingresos
Separación 60,000 0 0
Cuota Inicial #REF! #REF!
Desembolso de Saldo / Hipotecario / Bonos #REF!
Venta Estacionamientos 1,060,000 0 0
Desistimiento 0
Cuentas por Cobrar 0
Ingreso Total #REF! 0 #REF!
Caja Inicial 0 -35,367 -77,506
Flujo Escenarios antes de aportes -35,367 -42,139 #REF!
Caja antes de aportes -35,367 -77,506 #REF!
Aportes y Utilidades
Aporte 0 0 0 0
Devolución de aporte 0 0 0 0
Utilidad #REF! 0 0 0
Flujo de aportes 0 0 0 0
Caja despues de aportes -35,367 -77,506 #REF!
Flujo Corporativo 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
4,000 62,478 62,478 62,478 62,478 62,478 62,478
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
-10,613 0 0 0 0 0 0
-50,013 -50,013 -50,013 -50,013 -50,013 0 0
0 0 0 0 0 -4,514 0
0 0 0 0 0 0 0
0 0 0 0 0 -6,772 0
0 0 0 0 0 0 0
0 -7,524 0 0 0 0 0
-60,626 -57,537 -50,013 -50,013 -50,013 -11,286 0
0 0 0 0 0 0 0
-60,626 -57,537 -50,013 -50,013 -50,013 -11,286 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 220,458,368 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 -48,302 0 0 0
0 0 0 220,410,066 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 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
0 0 0 0 0 0 0
11 12 13 14 15 16 17
Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1
2.00 2.00 2.00 2.00 2.00 2.00 2.00
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 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 -7,524 0 0 0 0
0 0 -7,524 0 0 0 0
0 0 0 -451,440 -135,432 -180,576 -180,576
0 0 -7,524 -451,440 -135,432 -180,576 -180,576
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 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 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
0 0 0 0 0 0 0
18 19 20 21 22 23 24
Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1
2.00 2.00 2.00 2.00 2.00 2.00 2.00
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 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 -22,572
0 -7,524 0 0 0 0 0
0 -7,524 0 0 0 0 -22,572
-225,720 -225,720 -270,864 -316,008 -361,152 -361,152 -316,008
-225,720 -233,244 -270,864 -316,008 -361,152 -361,152 -338,580
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 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 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
0 0 0 0 0 0 0
25 26 27 28 29 30 31
Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1
2.00 2.00 2.00 2.00 2.00 2.00 2.00
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 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 0 0 0 0 0
-316,008 -270,864 -225,720 -180,576 -135,432 -135,432 -135,432
-316,008 -270,864 -225,720 -180,576 -135,432 -135,432 -135,432
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
-220,458,368 0 0 0 0 0 0
-15,047,116 0 0 0 0 0 0
0 0 0 0 0 0 0
-235,505,484 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 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
0 0 0 0 0 0 0
32 33 34 35 36 37 38
Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1 Fase 1
2.00 2.00
0.67 0.67
2%
312,390 312,390 312,390 312,390 312,390 312,390 312,390
4,000 4,000 0 0 0 0 0
58,478 58,478 58,478 0 0 0 0
562,303 562,303 562,303 562,303 0 0 0
0 0 0 0 0 0 0
35,333 35,333 35,333 0 0 0 0
660,114 660,114 656,114 562,303 - - -
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 0 0 0 0 0 0
0 0 0 0 0 0 0
-18,058 0 0 0 0 0 0
-60,400 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
-78,458 0 0 0 0 0 0
-90,288 0 0 0 0 0 0
-168,746 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 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
2,000 2,000 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
35,333 35,333 35,333 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
312,390 312,390
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 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 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 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
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 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 0 0 0 0
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
0 0 0 0 0 0 0 0
#REF! #REF!
0 0
#REF! #REF!
#REF! #REF!
0 0
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
0 0
#REF! #REF!
0 0
Mes 46 Mes 47 Mes 48 Mes 49 Mes 50 Mes 51 Mes 52 Mes 53
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
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 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 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 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
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 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 0 0 0 0
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
0 0 0 0 0 0 0 0
Mes 54 Mes 55 Mes 56 Mes 57 Mes 58 Mes 59 Mes 60 Mes 61
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
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 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 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 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
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 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 0 0 0 0
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
0 0 0 0 0 0 0 0
Mes 62 Mes 63 Mes 64 Mes 65 Mes 66 Mes 67 Mes 68 Mes 69
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
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 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 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 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
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 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 0 0 0 0
-14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955 -14,612,955
0 0 0 0 0 0 0 0
Mes 70 Mes 71
-14,612,955 -14,612,955
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
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 14,612,955
0 14,612,955
0 14,612,955
-14,612,955 0
0 -14,612,955
ESTRUCTURA DE INVERSION - PEN
Costo de Construcción
Costo de Construcción 3,829,179 - 13,643,301
Utilidad de Construcción 201,536 - 718,068
IGV 483,686 - 1,723,364
Indirectos
Arquitectura (USD 4) 42,452 42,452 -
Costo de desarrollo de proyecto (USD 300,079 300,079 -
Seguros (0.5% de edificación) 22,572 22,572 -
Saneamiento (S/ 1000 por und) 60,400 - -
Licencias, arbitrios, municipales, etc. 13,543 13,543 -
Postventa (0.5%) 22,572 - -
Otros (0.5%) 22,572 - -
Gerenciamiento 495,086 495,086 -
Gasto de ventas 495,086 495,086 -
Gasto Financiero 15,095,418 - -
Otros
Impuesto a la Renta - - -
Flujo total 462,000,916 221,827,186 236,543,102
% 100.0% 48.0% 51.2%
-
-1,368,818
URA DE INVERSION - PEN
-9,814,123 - -
-516,533 - -
-1,239,679 - -
- - -
- - -
- - -
60,400 - -
- - -
22,572 - -
22,572 - -
- - -
- - -
15,095,418 - -
- - -
3,630,628 0 0
0.8% 0.0% 0.0%