FLUJO DE CAJA DURANTE EL PRIMER AO DE OPERACIN DEL PROYECTO

CONCEPTOMESESTOTAL

123456789101112

A. INGRESOS

Caja inicial0.0047092.3994184.77125683.32172775.70219868.09251366.63298459.02345551.41377049.95424142.34471234.720.00

Venta de bebida131767.17131767.17131767.17131767.17131767.17131767.17131767.17131767.17131767.17131767.17131767.17131767.171581206.01

TOTAL DE INGRESOS131767.17178859.55225951.94257450.48304542.87351635.25383133.80430226.19477318.57508817.12555909.50603001.891581206.01

B. EGRESOS

Materia prima e insumos52152.4952152.4952152.4952152.4952152.4952152.4952152.4952152.4952152.4952152.4952152.4952152.49625829.86

Materiales indirectos18679.1618679.1618679.1618679.1618679.1618679.1618679.1618679.1618679.1618679.1618679.1618679.16224149.89

Mano de obra directa6506.246506.246506.246506.246506.246506.246506.246506.246506.246506.246506.246506.2478074.82

Mano de obra indirecta6506.246506.246506.246506.246506.246506.246506.246506.246506.246506.246506.246506.2478074.82

Gastos administrativos194.00194.00194.00194.00194.00194.00194.00194.00194.00194.00194.00194.002328.00

Gastos de ventas636.67636.67636.67636.67636.67636.67636.67636.67636.67636.67636.67636.677640.00

Intereses15593.8415593.8415593.8415593.8462375.3525

Amortizacin0.000.000.0055261.5755261.5679

Reinversion00

Impuesto a la renta00

TOTAL EGRESOS84674.7884674.78100268.6284674.7884674.78100268.6284674.7884674.78100268.6284674.7884674.78155530.191133734.30

CAJA FINAL (A-B)47092.3994184.77125683.32172775.70219868.09251366.63298459.02345551.41377049.95424142.34471234.72447471.70447471.70

FLUJO DE FONDOS ECONOMICO FINANCIERO

CONCEPTOAOSTOTAL

01234567

A. FLUJO DE INGRESOS

Ventas0.001581206.012108274.673689480.685270686.697906030.038433098.7010541373.3739530150.15

Valor residual11649.0611649.06

Recuperacin de capital de trabajo91678.1291678.12

TOTAL DE INGRESOS0.001581206.012108274.673689480.685270686.697906030.038433098.7010644700.5539633477.33

B. FLUJO DE EGRESOS

Inversin fija345388.67345388.67

Inversion en capital de trabajo91678.1291678.12

costo de fabricacin0.001006129.381287801.362132757.702977714.494385955.654667629.475794229.6322252217.69

Gastos de operacin0.009968.009968.009968.009968.009968.009968.009968.0069776.00

TOTAL DE EGRESOS437066.791016097.381297769.362142725.702987682.494395923.654677597.475804197.6322759060.48

FLUJO DE FONDOS ECONMICOS-437066.79565108.62810505.311546754.982283004.203510106.383755501.234840502.9116874416.85

MS:

PRSTAMO305946.75305946.7497

MENOS

SERVICIO A LA DEUDA117636.92283421.62401058.5446

IMPUESTO A LA RENTA147215.73229726.41460422.25681297.011049427.661123046.121417548.475108683.655

FLUJO DE FONDOS FINANCIERO-131120.04300255.97297357.281086332.741601707.192460678.722632455.113422954.4411670621.40

VANES/. 9,349,444.56TIRE182%R B/CE1.76

VANFS/. 6,443,470.73TIRF280%R B/CF7.05