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
Recommended