Finanzas flujo de efectivo.

COMERCIALIZADORA CERRO COLORADO, SA DE CV

FLUJO DE EFECTIVO

SEGUNDO SEMESTRE 2015

INGRESOS MAYO JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE

VENTAS REALES Y PRONOSTICADAS $70,000.00 $80,000.00 $170,000.00 $180,000.00 $140,000.00 $195,000.00 $190,000.00 $215,000.00

VENTAS EN EFECTIVO 70% $49,000.00 $56,000.00 $119,000.00 $126,000.00 $98,000.00 $136,500.00 $133,000.00 $150,500.00

COBROS POR VENTAS A CREDITO 1 MES 15% $10,500.00 $12,000.00 $25,500.00 $27,000.00 $21,000.00 $29,250.00 $28,500.00

COBROS POR VENTAS A CREDITO 2 MES 10% $7,000.00 $8,000.00 $17,000.00 $18,000.00 $14,000.00 $19,500.00

COBROS POR VENTAS A CREDITO 3 MES 5% $3,500.00 $4,000.00 $8,500.00 $9,000.00 $7,000.00

INGRESOS ORDINARIOS $49,000.00 $66,500.00 $138,000.00 $163,000.00 $146,000.00 $184,000.00 $185,250.00 $205,500.00

APORTACION DE LOS SOCIOS $- $- $- $- $- $75,200.00 $- $-

INGRESOS EXTRAORDINARIOS $- $- $- $- $- $75,200.00 $- $-

INGRESOS TOTALES $49,000.00 $66,500.00 $138,000.00 $163,000.00 $146,000.00 $259,200.00 $185,250.00 $205,500.00

EGRESOS

COMPRAS REALES Y PRONOSTICADAS $28,000.00 $32,000.00 $68,000.00 $72,000.00 $56,000.00 $78,000.00 $76,000.00 $86,000.00

COMPRAS DE CONTADO 50% $14,000.00 $16,000.00 $34,000.00 $36,000.00 $28,000.00 $39,000.00 $38,000.00 $43,000.00

PAGOS POR COMPRAS A CREDITO A 1 MES 30% $8,400.00 $9,600.00 $20,400.00 $21,600.00 $16,800.00 $23,400.00 $22,800.00

PAGOS POR COMPRAS A CREDITO A 2 MES 20% $5,600.00 $6,400.00 $13,600.00 $14,400.00 $11,200.00 $15,600.00

RENTAS $20,500.00 $20,500.00 $20,500.00 $20,500.00 $20,500.00 $20,500.00

SUELDOS Y SALARIOS $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00

MERCADOTECNIA $12,750.00 $12,750.00 $12,750.00 $12,750.00 $12,750.00 $12,750.00

SERVICIOS PUBLICOS $10,590.00 $10,590.00 $10,590.00 $10,590.00 $10,590.00 $10,590.00

EGRESOS ORDINARIOS $118,040.00 $131,640.00 $132,040.00 $139,040.00 $141,440.00 $150,240.00

PAGO DE DIVIDENDOS $42,000.00 ADQ. EQ. TRASP.

PAGO DE AGUINALDOS $72,000.00 VALOR COMERCIAL $130,000.00

ADQ. EQ. TRASP. ENGANCHE Y PAGO MENSUAL $45,000.00 $8,500.00 $8,500.00 $8,500.00 ENGANCHE $45,000.00

EGRESOS EXTRAORDINARIOS $- $42,000.00 $45,000.00 $8,500.00 $8,500.00 $80,500.00 SALDO A PAGAR $85,000.00

EGRESOS TOTALES $118,040.00 $173,640.00 $177,040.00 $147,540.00 $149,940.00 $230,740.00 NUM. PAGOS 10

FLUJO DE EFECTIVO (INGRESOS - EGRESOS) $19,960.00 -$10,640.00 -$31,040.00 $111,660.00 $35,310.00 -$25,240.00 PAGO MENSUAL $8,500.00

+ EFECTIVO INICIAL $12,500.00 $32,460.00 $21,820.00 -$9,220.00 $102,440.00 $137,750.00

= EFECTIVO FINAL $32,460.00 $21,820.00 -$9,220.00 $102,440.00 $137,750.00 $112,510.00

-EFECTIVO DESEADO EN CAJA CHICA $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00 $15,000.00

= EXCEDENTE / (FALTANTE) $17,460.00 $6,820.00 -$24,220.00 $87,440.00 $122,750.00 $97,510.00

...