Download - Planilla1 Flujo de Caja Inicial

Transcript
Page 1: Planilla1 Flujo de Caja Inicial

1.- EJEMPLO DE FLUJO DE CAJA INICIAL: sin prestamos, créditos ni aportes pag Nº 141. ITEMS Mes 1 Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9 Mes 10 Mes 11 Mes 12

2.INGRESOS

0 0 0 0 0 0 0 0 0 0 0

1,500,000 2,000,000 2,000,000 2,500,000 2,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000

0 0 1,000,000 2,000,000 3,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,0006.Prestamos (bancarios) 0 0 0 0 0 0 0 0 0 0 0

7.Otros Ingresos 0 0 0 0 0 0 0 0 0 0 0 0

8.TOTAL DE INGRESOS 3 al 7 1,500,000 2,000,000 3,000,000 4,500,000 5,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000

0 0 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000

0 0 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,00012.Sueldos fijos (3) 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,00013.Sueldos variables (7) 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,00014.Arriendo loc fca. 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,00015.Servicios;( todos) 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,00016.Publicidad y Promocion 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,00017.Mantencion y reparaciones 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,00018.Seguros 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,00019.Gastos de viajes 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,00020.Servicios profesionales 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000

21.Impuestos IVA 13,150 298,150 498,150 868,150 868,150 1,058,150 1,058,150 1,058,150 1,058,150 1,058,150 1,058,150 1,058,15022.Gastos varios 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,00023.Art. Materiales de oficina 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000

24.Compra de activos, contado 4,000,000 0 0 0 0 0 0 0 0 0 0 0

85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000

27.Otros gastos , especificar

28.GASTO TOTAL 10 al 27 7,433,150 3,718,150 5,118,150 5,488,150 5,488,150 5,678,150 5,678,150 5,678,150 5,678,150 5,678,150 5,678,150 5,678,150

29.TOTAL MES = (8 - 28) 5,933,150 1,718,150 2,118,150 988,150 488,150 2,321,850 2,501,700 2,501,700 2,501,700 2,501,700 2,501,700 2,501,70030.ACUMULADO MENSUAL 5,933,150 6,104,965 8,223,115 9,211,265 9,699,415 7,377,565 4,875,865 2,374,165 127,535 2,629,235 5,130,935 7,632,635

3.Efectivo inicial socios (aporte socios)

4.Ventas en efectivo (plan de ventas al contado)

5.Ventas a credito (60 días) plan de ventas a credito

9.EGRESOS DE; Gastos,compras10.Compras de materia prima (credito a 60 días)11.Compras de accesorios (credito 60 días)

25.Pagos credito banco, 48 dividendos mensuales iguales26.Amortizaciones lineal (mensual) en 4 años