Flujo de efectivo

Home Tech, S. A.

Flujo de Efectivo
Del 02 de enero al 30 de diciembre del 2010

Concepto Ene-Feb Mar-Abr May-Jun Jul-Ago Sep-OctNov-Dic
Saldo Inicial en caja $94,050.00
INGRESOS
Ventas (servicios) $99,000.00 $103,950.00 $109,147.50 $114,604.88 $120,335.12 $126,351.87
Capitalaportado $600,000.00
Préstamos bancarios $100,000.00
Cuentas por cobrar $30,000.00 $31,500.00 $33,075.00 $35,059.50 $37,864.26 $41,650.69Subtotal de ingresos $829,000.00 $135,450.00 $142,222.50 $149,664.38 $158,199.38 $168,002.56

EGRESOS
COSTO FIJO
Sueldos $63,200.00 $63,200.00$63,200.00 $63,200.00 $63,200.00 $63,200.00
Cuentas por pagar $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00
Servicios de WebHosting $14,255.00 $14,255.00 $14,255.00 $14,255.00 $14,255.00 $14,255.00
Lìneas telefónicas/Internet $4,578.00 $4,578.00 $4,578.00 $4,578.00 $4,578.00$4,578.00
Luz y agua $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00
COSTO VARIABLE
Comisiones $49,500.00 $51,975.00 $54,573.75$57,848.18 $62,476.03 $68,723.63
Equipo de Transporte (5 compactos) $500,000.00
Equipo de Cómputo $50,000.00
Herramientas $15,000.00
Capacitación$200,000.00
Trámites legales $7,600.00

Gasolina $14,000.00 $14,700.00 $15,435.00 $16,361.10 $17,669.99 $19,436.99
Subtotal de egresos$958,133.00 $188,708.00 $192,041.75 $196,242.28 $202,179.02 $210,193.62
Total -$129,133.00 -$53,258.00 -$49,819.25 -$46,577.90 -$43,979.64 -$42,191.06