proyecciones
TRANSCRIPT
RESUMEN DE LA DEMANDA TOTAL
DEMANDA DESCRIPCIONUniversidad SEÑOR DE SIPAN. (Personas entre 18-27 años) 4,968Universidad de Chiclayo. (Personas entre 18-27 años) 4,020 Universidad Cesar Vallejo. (Personas entre 18-27 años) 2,892Universidad San Martin de Porres. (Personas entre 18-27 años) 3,923Demanda en Urbanización los Sauces. Demanda futura 988
DEMANDA TOTAL 16,791PARTICIPACION EN EL MERCADO
Universidad SEÑOR DE SIPAN.(40%) (Personas entre 18-27 años) 1,987Universidad de Chiclayo.(35%) (Personas entre 18-27 años) 1,407 Universidad Cesar Vallejo.(20%) (Personas entre 18-27 años) 578Universidad San Martin de Porres.(18%) (Personas entre 18-27 años) 706.14
PARTICIPACION EN EL MERCADO TOTAL 5,877
AFORO= 2474 Pers.
INGRESOS
DETALLE PRECIO UNITARIO CANTIDAD
PISCINAENTRADA GENERAL S/. 5.00 1Ingresos por consumo de cerveza S/. 5.00 2Ingresos por consumo de comedor S/. 15.00 0.25TOTAL COSTO POR MANTENIMIENTO
EGRESOS
DETALLE COSTOS DIARIOS COSTO MENSUAL
COMPRA DE SUMINISTROS ( COMEDOR) S/. 3,247.13 S/. 71,436.75
COMPRA DE CERVEZA(S./45.6*280 CAJAS) S/. 12,768.00 S/. 383,040.00
GASTOS ADICIONALES S/. 4,544.77 S/. 90,895.35
GASTOS OPERATIVOS S/. 1,208.00 S/. 36,240.00
GASTOS DE MANTENIMIENTO S/. 712.99 S/. 21,389.81 TOTAL EGRESOS S/. 22,480.89 S/. 603,001.91
FLUJO DE CAJA PROYECTADO INGRESOS AÑO 1 AÑO 2ENTRADA GENERAL S/. 2,968,800.00 S/. 3,562,560.00 Ingresos por consumo de cerveza S/. 5,937,600.00 S/. 7,125,120.00 Ingresos por consumo de comedor S/. 2,226,600.00 S/. 2,671,920.00 INGRESO TOTAL S/. 11,133,000.00 S/. 13,359,600.00 EGRESOS
COMPRA DE SUMINISTROS ( COMEDOR) S/. 857,241.00 S/. 1,068,768.00 COMPRA DE CERVEZA(S./41*280 CAJAS) S/. 4,596,480.00 S/. 5,515,776.00 GASTOS ADICIONALES S/. 1,090,744.20 S/. 1,316,908.80
N° de personas diario
GASTOS OPERATIVOS S/. 434,880.00 S/. 521,856.00 GASTOS DE MANTENIMIENTO S/. 256,677.75 S/. 308,013.30 TOTAL EGRESOS S/. 7,236,022.95 S/. 8,731,322.10 SALDO FLUJO ECONOMICO S/. 3,896,977.05 S/. 4,628,277.90
VALOR ACTUAL NETO
Con un proyecto de inversión de 15´021´893.5 y una tasa efectiva de 20%
Ingresos0 15,021,893.501 S/. 11,133,000.00 2 S/. 13,359,600.00 3 S/. 16,031,520.00 4 S/. 19,237,824.00 5 S/. 23,085,388.80
VAN S/. 3,896,977.05 1.20
S/. 3,247,480.88
TASA INTERNA DE RETORNO TIR
TIR =
TASAR 20%
X TIRR 60%
O S/. 15,021,893.50 S/. 3,896,977.05 1.60
x60%-20%
x40.0%
x
x
TIR Err:523
van
Mensual Anual99,360 1,192,32080,400 964,80057,840 694,08078,460 941,52019,760 237,120
335,820 4,029,840
39,744 476,92828,140 337,68011,568 138,81614,123 169,47493,575 1,122,898
INGRESOS
PERSONAS
2,474 S/. 12,370.00 S/. 247,400.00 S/. 2,968,800.00 2,474 S/. 24,740.00 S/. 494,800.00 S/. 5,937,600.00 2,474 S/. 9,277.50 S/. 185,550.00 S/. 2,226,600.00
S/. 46,387.50 S/. 927,750.00 S/. 11,133,000.00
EGRESOS
COSTO ANUAL
S/. 857,241.00
S/. 4,596,480.00
S/. 1,090,744.20 S/. 434,880.00
256,677.75
S/. 7,236,022.95
FLUJO DE CAJA PROYECTADO AÑO 3 AÑO 4 AÑO 5 S/. 4,275,072.00 S/. 5,130,086.40 S/. 6,156,103.68 S/. 8,550,144.00 S/. 10,260,172.80 S/. 12,312,207.36 S/. 3,206,304.00 S/. 3,847,564.80 S/. 4,617,077.76 S/. 16,031,520.00 S/. 19,237,824.00 S/. 23,085,388.80
S/. 1,282,521.60 S/. 1,539,025.92 S/. 1,846,831.10 S/. 6,618,931.20 S/. 7,942,717.44 S/. 9,531,260.93 S/. 1,580,290.56 S/. 1,896,348.67 S/. 2,275,618.41
INGRESOS DIARIO
INGRESO MENSUAL
INGRESO TOTAL ANUAL
S/. 626,227.20 S/. 751,472.64 S/. 901,767.17 S/. 369,615.96 S/. 443,539.15 S/. 532,246.98 S/. 10,477,586.52 S/. 12,573,103.82 S/. 15,087,724.59 S/. 5,553,933.48 S/. 6,664,720.18 S/. 7,997,664.21
S/. 901,595.73
Egresos FN-15,021,893.50 van
S/. 7,236,022.95 S/. 3,896,977.05 tir S/. 8,731,322.10 S/. 4,628,277.90 S/. 10,477,586.52 S/. 5,553,933.48 S/. 12,573,103.82 S/. 6,664,720.18 S/. 15,087,724.59 S/. 7,997,664.21
S/. 4,628,277.90 S/. 5,553,933.48 S/. 6,664,720.18 S/. 7,997,664.21 1.44 1.73 2.07 2.49
S/. 3,214,081.87 S/. 3,214,081.88 S/. 3,214,081.87 S/. 3,214,081.88
VAN
VAN S/. 1,081,914.88 (+)
(-)
S/. 4,628,277.90 S/. 5,553,933.48 S/. 6,664,720.18 S/. 7,997,664.21 2.56 4.10 6.55 10.49
0 - S/. 1,081,914.88 0 - S/. 1,081,914.88
-1081914.875 1-1081914.875
0.004
40.00%
3.41666667
S/. 412.33 S/. 18,802.40
GANACIA DE LA CERVEZA300 *12*6 S/. 21,600.00 300 *12*3.42 S/. 12,312.00
S/. 9,288.00
50,860.93
85,192.34
17,066.59
153,119.86
S/. 901,595.7323%
S/. 15,021,893.50 S/. 1,081,914.88
S/. 16,103,808.38 S/. 1,081,914.88
S/. 7,379,144.79
S/. -7,642,748.71
PERSONAL NUMERO C. UNITARIO TOTAL (MENSUAL)
PORTERIA 2 S/. 750.00 S/. 1,500.00
ADMINISTRADOR 1 S/. 2,500.00 S/. 2,500.00
SALVAVIDAS 2 S/. 750.00 S/. 1,500.00
AUX. ENFERMERIA 1 S/. 800.00 S/. 800.00
VIGILANTES 4 S/. 750.00 S/. 3,000.00
ASEO Y JARDINES 6 S/. 450.00 S/. 2,700.00
BARMAN 3 S/. 1,200.00 S/. 3,600.00
CHEF 2 S/. 1,500.00 S/. 3,000.00
ASISTENTE DE COCINA 4 S/. 750.00 S/. 3,000.00
ASAFATAS 8 S/. 750.00 S/. 6,000.00
LUZ 1 S/. 5,000.00 S/. 5,400.00
AGUA 1 S/. 3,000.00 S/. 3,240.00
SUBTOTALES S/. -
TOTAL AÑO S/. 36,240.00
ANUAL
S/. 18,000.00
S/. 30,000.00
S/. 18,000.00
S/. 9,600.00
S/. 36,000.00
S/. 32,400.00
S/. 43,200.00
S/. 36,000.00
S/. 36,000.00
S/. 72,000.00
S/. 64,800.00
S/. 38,880.00
S/. -
S/. 434,880.00
CALCULO DEL AFOROAREA PERSONAS
1.00 Salón de bailePista de baile 190.83 303area de asientos 409.17 409.17
2.00 PISCINAS 403Piscina 400 89area de asientos 878.32 314
3.00 Instalaciones deportivas Deportiva 244.00 Comedor común 222.53 1486.00 Áreas verdes 1569.62 784.81
TOTAL 2474
REFERENCIA: http://febe.vivienda.gob.pe/dnv/documentos/RNE/15.pdf
http://febe.vivienda.gob.pe/dnv/documentos/RNE/15.pdf