Bussines plan volquetas carboneras

en este cash flow se tiene como premisas las siguientes: se inicia entregando 30 camiones en Mayo en calidad de Renta y Turnos a partir de Junio se adicionan camiones por mes hasta Dias Habiles completar 300 en Leasing, IMPORTANTE, Se usa el anticipo Dias De mantenimiento como enganche de los siguientes camiones Meses contrato Cannon Mensual

1 26 0 36 $ 19,000,000

Renta 30 Iniciales Costode cada Vehiculo Valor de Enganche Leasing Valor SOAT (Anual) Seguro Todo Riesgo Plan de Comunicaciones Aparatos Telefónicos Mantenimiento Preventivo cada 350 Horas

$ 16,000,000 $ 250,000,000 10% $ 900,000 $ 2,500,000 estimado $ 100,000 $ 80,000 $ 2,000,000 ( Imprevistos solamente)

PETROLEOS AGUILA S.A.S.
FLUJO DE CAJA MENSUAL PROYECTO 300 Volquetas Material Esteril INGRESOS CONCEPTO SALDOANTERIOR PAGO DE CLIENTES ANTICIPO DE CLIENTES PRESTAMOS 30 $2,052,000,000 1 May-11 1 2 2 3 $0 $0 $2,052,000,000 80 $3,933,000,000 2 Jun-11 $1,053,900,000 $513,000,000 $3,420,000,000 130 $4,788,000,000 3 Jul-11 $2,172,052,000 $1,368,000,000 $3,420,000,000 230 $10,773,000,000 4 Aug-11 $3,470,924,000 $3,933,000,000 $6,840,000,000 330 $12,483,000,000 5 Sep-11 $7,912,266,000 $5,643,000,000$6,840,000,000 330 $5,643,000,000 6 Oct-11 $12,881,048,000 $5,643,000,000 $0 330 $5,643,000,000 7 Nov-11 $13,728,888,000 $5,643,000,000 $0 330 $5,643,000,000 8 Dec-11 $14,566,728,000 $5,643,000,000 $0 330 $5,643,000,000 9 Jan-12 $15,414,568,000 $5,643,000,000 $0 330 $5,643,000,000 10 Feb-12 $16,262,408,000 $5,643,000,000 $0 330 $5,643,000,000 11 Mar-12 $17,100,248,000 $5,643,000,000 $0

ITEM

ITEM 1 23 4 5 6 7 8 8 9 10 11 12 13 14 15 16 17 18 19 20 21

TOTAL DE INGRESOS $2,052,000,000 SALIDAS CONCEPTO INVERSIÓN ENGANCHE LEASING $0 PAGO RENTA 30 VEHICULOS INICIALES SERVICIOS (ELECTRICIDAD, TELEFONO, INTERNET) $2,000,000 COMPRA DE CAMIONETAS $156,000,000 SOAT $27,000,000 SEGURO TODO RIESGO $75,000,000 TELEFONIA ( Conductores) $3,000,000 APARATOS TELEFONICOS $2,400,000 MOBILIARIO $15,000,000EQUIPOS ( Computadores, Tableros de Control, Etc) $30,000,000 GPS $1,800,000 PAPELERIA $10,000,000 ANTICIPO 30 INICIALES (Se paga Anualmente) $576,000,000 POLIZAS $20,520,000 MANTENIMIENTO PREVENTIVO LAVADO DE VEHICULOS $15,600,000 PAGO DE LEASING VOLQUETAS SEGUROS (prima 3% anual) $18,750,000 ADMINISTRACION (PLANILLEROS (5), FACTURACION (3), SUPERVISORES (2)) $15,030,000 GERENCIA $30,000,000IMPUESTOS IMPREVISTOS TOTAL EGRESOS $998,100,000 BALANCE 1,053,900,000.00 SALDO 1,053,900,000.00 Rentabilidad

$3,933,000,000

$4,788,000,000

$10,773,000,000

$12,483,000,000

$5,643,000,000

$5,643,000,000

$5,643,000,000

$5,643,000,000

$5,643,000,000

$5,643,000,000

$1,250,000,000 $432,000,000 $2,000,000 $45,000,000 $125,000,000 $8,000,000 $4,000,000

$1,250,000,000$432,000,000 $2,000,000 $45,000,000 $125,000,000 $13,000,000 $4,000,000

$2,500,000,000 $432,000,000 $2,000,000 $156,000,000 $90,000,000 $250,000,000 $23,000,000 $8,000,000

$2,500,000,000 $432,000,000 $2,000,000 $90,000,000 $250,000,000 $33,000,000 $8,000,000

$0 $432,000,000 $2,000,000

$0 $432,000,000 $2,000,000

$0 $432,000,000 $2,000,000

$0 $432,000,000 $2,000,000

$0$432,000,000 $2,000,000

$0 $432,000,000 $2,000,000

$33,000,000 $0

$33,000,000 $0

$33,000,000 $0

$33,000,000 $0

$33,000,000 $0

$33,000,000 $0

$4,800,000

$7,800,000

$13,800,000 $10,000,000

$19,800,000

$19,800,000

$19,800,000 $10,000,000

$19,800,000

$19,800,000

$19,800,000 $10,000,000

$19,800,000

$60,000,000 $41,600,000 $254,118,000 $50,000,000 $15,030,000$30,000,000 $393,300,000 $100,000,000 $2,814,848,000 1,118,152,000.00 2,172,052,000.00 28.4%

$160,000,000 $67,600,000 $677,648,000 $81,250,000 $15,030,000 $30,000,000 $478,800,000 $100,000,000 $3,489,128,000 1,298,872,000.00 3,470,924,000.00 27.1%

$260,000,000 $119,600,000 $1,101,178,000 $143,750,000 $15,030,000 $30,000,000 $1,077,300,000 $100,000,000 $6,331,658,000 4,441,342,000.00...