Flujo de Cada Mensual - Ok Modelo Biatifull
2
FLUJO DE CADA MENSUAL Instrucciones: solo debes completar las celdas numéricas con fondo blanco Meses Mes 1 Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9 Mes 10 Mes 11 Mes 12 Total Dinero líquido al inicio (caja y bancos) 5.000, 0 Suma de cobros (entradas de efectivo) 8.403, 0 5.403, 0 1.403, 0 2.403, 0 3.403, 0 2.353, 0 6.203, 0 1.403, 0 7.403, 0 1.403, 0 5.403, 0 1.403, 0 46.586, 0 Suma de pagos (salidas de efectivo) (2.656 ,0) (2.656 ,0) (2.556 ,0) (16.40 6,0) (2.486 ,0) (2.036 ,0) (2.536 ,0) (2.486 ,0) (10.40 6,0) (2.656 ,0) (2.656 ,0) (2.656 ,0) (52.192 ,0) Flujo de caja neto (cobros - pagos) 5.747, 0 2.747, 0 (1.153 ,0) (14.00 3,0) 917,0 317,0 3.667, 0 (1.083 ,0) (3.003 ,0) (1.253 ,0) 2.747, 0 (1.253 ,0) (5.606, 0) Dinero líquido al final (caja y bancos) 10.747 ,0 13.494 ,0 12.341 ,0 (1.662 ,0) (745,0 ) (428,0 ) 3.239, 0 2.156, 0 (847,0 ) (2.100 ,0) 647,0 (606,0 ) (606,0) Flujos operativos 6.200, 0 3.200, 0 (700,0 ) (13.55 0,0) 1.370, 0 770,0 4.120, 0 (630,0 ) (2.550 ,0) (800,0 ) 3.200, 0 (800,0 ) (170,0) Cobros por ventas al contado 8.000, 0 5.000, 0 1.000, 0 2.000, 0 3.000, 0 1.950, 0 1.000, 0 1.000, 0 7.000, 0 1.000, 0 5.000, 0 1.000, 0 36.950, 0 Cobros por ventas a plazo 200,0 200,0 200,0 200,0 200,0 200,0 5.000, 0 200,0 200,0 200,0 200,0 200,0 7.200,0 Pagos de nóminas (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (100,0 ) (1.100, 0) Pagos de aportes a la seguridad social (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (500,0 ) (5.500, 0) Pagos a proveedores (1.200 ,0) (1.200 ,0) (1.200 ,0) (15.00 0,0) (1.200 ,0) (1.200 ,0) (1.200 ,0) (1.200 ,0) (9.000 ,0) (1.200 ,0) (1.200 ,0) (1.200 ,0) (36.000 ,0) Pagos de arrendamientos (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (400,0) Pagos de servicios públicos (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (360,0)
-
Upload
rogelio-esperilla-alvares -
Category
Documents
-
view
4 -
download
2
description
Un modelo de flujo de caja
Transcript of Flujo de Cada Mensual - Ok Modelo Biatifull
FLUJO DE CADA MENSUAL Instrucciones: solo debes completar las celdas numéricas con fondo blanco
Meses Mes 1 Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9 Mes 10 Mes 11 Mes 12 Total
Dinero líquido al inicio (caja y bancos) 5.000,0 Suma de cobros (entradas de efectivo) 8.403,0 5.403,0 1.403,0 2.403,0 3.403,0 2.353,0 6.203,0 1.403,0 7.403,0 1.403,0 5.403,0 1.403,0 46.586,0
Suma de pagos (salidas de efectivo) (2.656,0) (2.656,0) (2.556,0) (16.406,0) (2.486,0) (2.036,0) (2.536,0) (2.486,0)(10.406,0
) (2.656,0) (2.656,0) (2.656,0) (52.192,0)Flujo de caja neto (cobros - pagos) 5.747,0 2.747,0 (1.153,0) (14.003,0) 917,0 317,0 3.667,0 (1.083,0) (3.003,0) (1.253,0) 2.747,0 (1.253,0) (5.606,0)
Dinero líquido al final (caja y bancos) 10.747,0 13.494,0 12.341,0 (1.662,0) (745,0) (428,0) 3.239,0 2.156,0 (847,0) (2.100,0) 647,0 (606,0) (606,0)
Flujos operativos 6.200,0 3.200,0 (700,0)(13.550,0
) 1.370,0 770,0 4.120,0 (630,0) (2.550,0) (800,0) 3.200,0 (800,0) (170,0)Cobros por ventas al contado 8.000,0 5.000,0 1.000,0 2.000,0 3.000,0 1.950,0 1.000,0 1.000,0 7.000,0 1.000,0 5.000,0 1.000,0 36.950,0
Cobros por ventas a plazo 200,0 200,0 200,0 200,0 200,0 200,0 5.000,0 200,0 200,0 200,0 200,0 200,0 7.200,0Pagos de nóminas (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (1.100,0)
Pagos de aportes a la seguridad social (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (5.500,0)Pagos a proveedores (1.200,0) (1.200,0) (1.200,0) (15.000,0) (1.200,0) (1.200,0) (1.200,0) (1.200,0) (9.000,0) (1.200,0) (1.200,0) (1.200,0) (36.000,0)
Pagos de arrendamientos (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (400,0)Pagos de servicios públicos (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (30,0) (360,0)
Pagos de impuestos (120,0) (120,0) (120,0) (120,0) (120,0) (120,0) (120,0) (120,0) (960,0)
Flujos de inversión (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (300,0) (3.600,0)Pagos por compras de activo fijo (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (500,0) (6.000,0)Cobros por ventas de activo fijo 200,0 200,0 200,0 200,0 200,0 200,0 200,0 200,0 200,0 200,0 200,0 200,0 2.400,0
Flujos financieros (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (153,0) (1.836,0)Pagos de intereses (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (50,0) (600,0)
Pagos de préstamos bancarios (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (100,0) (1.200,0)Pagos de dividendos (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (5,0) (60,0)
Pagos de acciones (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (1,0) (12,0)Cobros por intereses 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 12,0
Cobros por préstamos bancarios 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0
Cobros por dividendos 2,0 2,0 2,0 2,0 2,0 2,0 2,0 2,0 2,0 2,0 2,0 2,0 24,0
