Document

download Document

of 21

  • date post

    08-Nov-2014
  • Category

    Documents

  • view

    45
  • download

    0

Embed Size (px)

Transcript of Document

PLAN DE INVERSIONPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION: DESCRIPCIONUNIDAD UNITARIO PROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA

VALOR UNIDADES

CONSTRUCCIONES E INST.

0 0

0 0 0

0 0 0

MAQUINARIA Y EQUIPO

0

INFRAESTRUCTURA

0 0

0 0 0 Lps.67,309 Lps.0

0 0 0 0 0

GALLINAS PONEDORASLevante de polla millar Mantenimiento de gallina millar

0 1.000 1.50 0

IMPREVISTOS

TOTAL DEL PROYECTO APORTE DEL PRODUCTOR PRESTAMO SOLICITADO REEMBOLSO FONAPROVI

COSTO TOTAL

Lps.0.00 Lps.0.00 Lps.0.00

Lps.0.00 Lps.0.00 Lps.67,309.00 Lps.67,309.00 Lps.0.00

Lps.67,309.0 (Lps.432,691.0) Lps.500,000.0 Lps.500,000.0

PROYECCION DE INGRESOS Y GASTOS DE OPERACIONPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION:DESCRIPCION Antes del Proyecto 1 2 3 4 5 6 7 PROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA

Aves en produccion millar Total cajas de huevo Precio caja de huevo Ventas Brutas Mantenimiento de las aves Postura fase 1 QQ Antibioticos Vitaminas y Electrolitos Lts Re-vacunacion anual newcasttle Promotores de alimento Kg Luz Separadores de carton Reemplazo anual Mano de Obra Asistencia tecnica Mano de obra Transporte/Comercializacion Imprevistos GRAN TOTAL

1.500 1,320 Lps.306.00 Lps.403,920

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

2.500 2,200 Lps.324.00 Lps.712,800

Lps.225,844 Lps.525 Lps.180 Lps.450 Lps.525 Lps.450 Lps.6,336 Lps.0

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.376,406 Lps.875 Lps.300 Lps.750 Lps.875 Lps.750 Lps.10,560 Lps.67,309

Lps.225 Lps.13,500 Lps.96,584.58 Lps.24,804.00 Lps.369,423

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

Lps.375 Lps.22,500 Lps.160,974 Lps.41,340.00 Lps.683,015

PLAN DE AMORTIZACIONPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION: TASA DE INTERESPROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA 21%

AOS

SEMESTRE

SALDO CAPITAL

AMORTIZACION SEMESTRAL ANUAL

INTERESES SEMESTRAL ANUAL

CUOTA TOTAL SEMESTRAL ANUAL

1

A B

Lps.500,000.00 Lps.500,000.00 Lps.500,000.00 Lps.500,000.00 Lps.500,000.00 Lps.450,000.00 Lps.400,000.00 Lps.350,000.00 Lps.300,000.00 Lps.250,000.00 Lps.200,000.00 Lps.150,000.00 Lps.100,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.50,000.00 Lps.100,000.00 Lps.500,000.00 Lps.100,000.00 Lps.100,000.00 Lps.100,000.00 Lps.100,000.00

Lps.52,500.00 Lps.52,500.00 Lps.52,500.00 Lps.52,500.00 Lps.52,500.00 Lps.47,250.00 Lps.42,000.00 Lps.36,750.00 Lps.31,500.00 Lps.26,250.00 Lps.21,000.00 Lps.15,750.00 Lps.10,500.00 Lps.5,250.00 Lps.15,750.00 Lps.498,750.00 Lps.36,750.00 Lps.57,750.00 Lps.78,750.00 Lps.99,750.00 Lps.105,000.00 Lps.105,000.00

Lps.52,500.00 Lps.52,500.00 Lps.52,500.00 Lps.52,500.00 Lps.102,500.00 Lps.97,250.00 Lps.92,000.00 Lps.86,750.00 Lps.81,500.00 Lps.76,250.00 Lps.71,000.00 Lps.65,750.00 Lps.60,500.00 Lps.55,250.00 Lps.115,750.00 Lps.998,750.00 Lps.136,750.00 Lps.157,750.00 Lps.178,750.00 Lps.199,750.00 Lps.105,000.00 Lps.105,000.00

2

A B

3

A B

4

A B

5

A B

6

A B

7

A B

TOTALES

PROYECCION FINANCIERAPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION:CONCEPTO ANTES DEL PROYECTO 1 2 3 PROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA A 4 O S 5 6 7 TOTALES

1-INGRESOSVentas Totales Prestamo Redescuento-FONAPROVI Aporte Prestatario Otros Prestamos Otros

Lps.403,920

Lps.712,800 Lps.500,000

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.4,989,600 Lps.500,000

TOTAL INGRESOS 2-EGRESOSInversion Construccion de Galeras Gastos de Operacion Otros Prestamos

Lps.403,920

Lps.1,212,800 Lps.67,309

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.712,800

Lps.5,489,600

Lps.369,423 Lps.369,423 Lps.34,497

Lps.683,015 Lps.750,324 Lps.462,476 Lps.105,000

Lps.683,015 Lps.683,015 Lps.29,785 Lps.105,000 Lps.0 Lps.105,000 (Lps.75,215)

Lps.683,015 Lps.683,015 Lps.29,785 Lps.99,750 Lps.0 Lps.99,750 (Lps.69,965) Lps.100,000

Lps.683,015 Lps.683,015 Lps.29,785 Lps.78,750 Lps.0 Lps.78,750 (Lps.48,965) Lps.100,000 Lps.0 Lps.100,000 (Lps.148,965) (Lps.2,171)

Lps.683,015 Lps.683,015 Lps.29,785 Lps.57,750 Lps.0 Lps.57,750 (Lps.27,965) Lps.100,000 Lps.0 Lps.100,000 (Lps.127,965) (Lps.130,135)

Lps.683,015 Lps.683,015 Lps.29,785 Lps.36,750 Lps.0 Lps.36,750 (Lps.6,965) Lps.100,000 Lps.0 Lps.100,000 (Lps.106,965) (Lps.237,100)

Lps.683,015 Lps.683,015 Lps.29,785 Lps.15,750 Lps.0 Lps.15,750 Lps.14,035 Lps.100,000 Lps.0 Lps.100,000 (Lps.85,965) (Lps.323,064)

Lps.4,781,102 Lps.4,848,411 Lps.641,189 Lps.498,750 Lps.0 Lps.498,750 Lps.142,439 Lps.500,000 Lps.0 Lps.500,000 (Lps.323,064)

TOTAL EGRESOS 3-SALDO EN EFECTIVO(1-2) 4-INTERESESPrestamos Redescu. FONAPROVI Prestamo Intermediario Financ Otros

TOTAL INTERESES 5-SALDO DESPUES INT.(3-4) 6-AMORTIZACIONESPrestamos Redescu. FONAPROVI Prestamo Intermediario Financ Otros

Lps.0 Lps.0 Lps.34,497

Lps.0 Lps.105,000 Lps.357,476

TOTAL AMORTIZACION 7-SALDO TOTAL GRAL. 8-SALDO ACUMULADO

Lps.0 Lps.0 Lps.34,497 Lps.34,497

Lps.0 Lps.0 Lps.357,476 Lps.391,973

Lps.0 Lps.0 (Lps.75,215) Lps.316,759

Lps.0 Lps.100,000 (Lps.169,965) Lps.146,794

ANALISIS BENEFICIO/COSTOPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION:PROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA

AOS

BENEFICIOS

BENEFICIO ACTUALIZADO 21%

COSTOS

0 1 2 3 4 5 6 7 TOTALES

Lps.403,920.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00

Lps.403,920.00 Lps.589,090.91 Lps.486,851.99 Lps.402,357.02 Lps.332,526.46 Lps.274,815.26 Lps.227,120.05 Lps.187,702.52 Lps.2,904,384.20

(Lps.369,423.33) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55)

RELACION B/C

1.05

VAN:

COSTO

COSTO ACTUALIZADO 21%

(Lps.369,423.33) (Lps.564,474.83) (Lps.466,508.13) (Lps.385,543.91) (Lps.318,631.33) (Lps.263,331.68) (Lps.217,629.48) (Lps.179,859.08) (Lps.2,765,401.76)

Lps.138,982.44

CALCULO TASA INTERNA DE RETORNOPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION:PROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA

AOS

INGRESO VENTAS

INVERSION

GASTOS

CAPITAL DE TRABAJO

FLUJO NETO

VALOR PRESENTE 32%

VALOR PRESENTE 34%

0 1 2 3 4 5 6 7

Lps.403,920.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00 Lps.712,800.00

(Lps.500,000.00)

(Lps.369,423.33) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55) (Lps.683,014.55)

(Lps.465,503.33) Lps.29,785.45 Lps.29,785.45 Lps.29,785.45 Lps.29,785.45 Lps.29,785.45 Lps.29,785.45 Lps.29,785.45 (Lps.257,005.17)Lps.500,000.00

(Lps.465,503.33) Lps.22,564.74 Lps.17,094.50 Lps.12,950.38 Lps.9,810.89 Lps.7,432.49 Lps.5,630.68 Lps.4,265.66 (Lps.385,754.00)Lps.114,246.00

(Lps.465,503.33) Lps.22,227.95 Lps.16,588.02 Lps.12,379.12 Lps.9,238.15 Lps.6,894.14 Lps.5,144.88 Lps.3,839.46 (Lps.389,191.60)Lps.110,808.40

TOTALES

(Lps.500,000.00)

TIR.

-192.43%

COSTO DE LEVANTE DE POLLITAPROYECTO: PROPIETARIO: BANCO: MONTO DE CREDITO: PLAZO: PERIODOS DE GRACIA: UBICACION: ACTIVIDADES POR C/1,000 AVESPROYECTO MANDARINA EMPRESA MANDARIN BANCAHFE Lps.500,000.00 6 AOS 1 AOS EL VENADO, VILLANUEVA

UNIDAD

VALOR UNITARIO

Costo cada 1000 pollitas Preparacion de galera pollita Vacunas-Despiques Antibioticos Vitaminas y electrolitos Coccidiostatos Desinfeccion galera Mano de Obra Sub Total Alimento QQ Inicio 1-3 sem QQ Crecimiento 4-12 sem QQ Desarrollo 13-18 sem QQ pre-postura 18-21 sem QQ postura hasta huevo vendible Mano de Obra casetero. Sub Total Imprevistos 10% del costo

1 1 15 1 1 1 1 5