planilla1 flujo de caja inicial

1
1.- EJEMPLO DE FLUJO DE CAJA INICIAL: sin prestamos, créditos ni aportes pag Nº 14 1. 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,000 6.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,000 12.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,000 13.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,000 14.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,000 15.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,000 16.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,000 17.Mantencion y reparacione 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 18.Seguros 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 19.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,000 20.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,150 22.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,000 23.Art. Materiales de ofici 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 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,700 30.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 9.EGRESOS DE; Gastos,compras 10.Compras de materia prima (credito a 60 días) 11.Compras de accesorios (credito 60 días) 24.Compra de activos, 25.Pagos credito banco, 48 dividendos mensuales 26.Amortizaciones lineal

Upload: betzabe-alejandra-munoz-palza

Post on 11-Feb-2016

218 views

Category:

Documents


0 download

DESCRIPTION

PLANTILLA

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