ANALISIS DE SENSIBILIDAD SEGÚN VARIACION DE PRECIOS Precio Externo Precio Interno % Disminución VAN TIR $683 $431 0 155,057,640 33% $546 $345 20 79,366,027 26% $478 $302 30 41,692,421 22% $410 $259 40 4,018,816 18% $376 $237 45 -14,987,688 16%
ANALISIS DE SENSIBILIDAD SEGÚN VARIACION DE PRODUCCION % Disminución VAN TIR 0 155,057,640 33% 10 117,243,274 29% 20 79,433,907 26% 30 41,624,541 22% 40 3,815,175 18% 50 -33,994,192 14%
FLUJOS DE CAJA Item
0
Ingresos por venta
1
2
3
4
5
$-
-
$10,200,320
$20,400,640
$40,801,280
$61,201,920
Gastos Mano de Obra $(15,840,000)
($17,360,000)
($17,360,000)
$(14,480,000)
$(14,830,000)
$(15,005,000)
Gasto Fertilización
$-
$(563,720)
$(416,080)
$(1,188,060)
$(1,808,340)
$(2,161,440)
Gasto Control Maleza
$-
$(937,260)
$(623,900)
$(571,900)
$(432,580)
$(432,580)
Gasto Control Plagas y Enfermedades $$(356,720)
$(1,366,440)
$(1,944,040)
$(327,180)
$(396,060)
Gastos Varios
$(5,481,860)
$(7,068,260)
$(7,691,820)
$(8,258,220)
$(8,664,620)
$-
Gasto Implantación$(14,266,455) Depreciación
$-
$(10,946,666)
$(14,803,666)
$(14,803,667)
$(11,820,333)
$(11,820,334)
Valor Salvamento Predio
$-
-
-
-
-
-
Valor Salvamento Maquinaria $-
-
-
-
-
-
Valor Salvamento Acciones de $Agua
-
-
-
-
-
$(5,224,800)
$(4,702,320)
$(4,179,840)
$(3,657,360) $19,064,526
Intereses Préstamo Bancario UTIL. (PERD.) A/IMPUESTO $(30,106,455)
$(35,646,226)
$(36,662,826)
$(24,981,167)
$(855,213)
Impuesto a la Renda $4,515,968 efectiva
$5,346,934
$5,499,424
$3,747,175
$128,282
$(2,859,679)
$10,946,666
$14,803,666
$14,803,667
$11,820,333
$11,820,334
$(3,732,000)
$(3,732,000)
$(3,732,000)
$(3,732,000)
Depreciación
$-
Amortización Préstamo Bancario Préstamo Bancario $37,320,000 Subsidio Ley de Riego
$10,815,000
Inversión Activo Fijo $(63,672,000) Inversión Maquinaria UTIL. (PERD.) NETA $(60,974,423)
$(682,525)
$(10,334,920)
$(1,017,000)
$(2,597,093)
$(454,600)
$(19,914,019)
$(41,425,504)
$(18,673,675)
$4,764,309
$23,838,581
Tasa de descuento VAN
18%
(14,987,688)
TIR
16%
1664
4
9984
3328 50% 1664 $376 $625,664
6656 50% 3328 $376 $1,251,328
9984 50% 4992 $376 $1,876,992
% Mercado Interno 0% Kg. Mercado Interno 0 Precio/Kg. Mercado Interno $237 Ingreso por mercado interno $-
50% 832 $237 $197,184
50% 1664 $237 $394,368
50% 3328 $237 $788,736
50% 4992 $237 $1,183,104
$510,016 $10,200,320
$1,020,032 $20,400,640
$2,040,064 $40,801,280
$3,060,096 $61,201,920
$$-
3
6656
1664 50% 832 $376 $312,832
Ingresos por Há TOTAL INGRESOS
2
3328
1 Kg. Producidos por Há 0 % Exportación 0% Kg. Exportación 0 Precio/Kg. Exportado $376 Ingreso por exportación $-
5
6
7
8
9
10
11
12
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(10,613,334)
-
-
-
-
$(168,000)
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
$(3,134,880)
$(2,612,400)
$(2,089,920)
$(1,567,440)
$(1,044,960)
$(522,480)
$35,790,226
$46,926,040
$47,448,520
$47,971,000
$48,493,480
$48,847,960
$49,538,440
$(5,368,534)
$(7,038,906)
$(7,117,278)
$(7,195,650)
$(7,274,022)
$(7,327,194)
$(7,430,766)
$10,613,334
-
-
-
-
$168,000
-
$(3,732,000)
$(3,732,000)
$(3,732,000)
$(3,732,000)
$(3,732,000)
$(3,732,000)
$(541,760)
$(454,600)
$(373,760)
$(454,600)
$(373,760)
$(454,600)
$(373,760)
$36,761,266
$35,700,534
$36,225,482
$36,588,750
$37,113,698
$37,502,166
$41,733,914
12480 6
12480 7
12480 8
12480 9
12480 10-20
12480 50% 6240 $376 $2,346,240
12480 50% 6240 $376 $2,346,240
12480 50% 6240 $376 $2,346,240
12480 50% 6240 $376 $2,346,240
12480 50% 6240 $376 $2,346,240
50% 6240 $237 $1,478,880
50% 6240 $237 $1,478,880
50% 6240 $237 $1,478,880
50% 6240 $237 $1,478,880
50% 6240 $237 $1,478,880
$3,825,120 $76,502,400
$3,825,120 $76,502,400
$3,825,120 $76,502,400
$3,825,120 $76,502,400
$3,825,120 $76,502,400
13
14
15
16
17
18
19
20
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$76,502,400
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(15,005,000)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(2,337,540)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(432,580)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(396,060)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
$(8,792,780)
-
-
-
$(168,000)
-
-
-
$182,367,200 $548,400
-
-
-
-
-
-
-
$16,000,000
$49,538,440
$49,538,440
$49,538,440
$49,370,440
$49,538,440
$49,538,440
$49,538,440
$248,454,040
$(7,430,766)
$(7,430,766)
$(7,430,766)
$(7,405,566)
$(7,430,766)
$(7,430,766)
$(7,430,766)
$(37,268,106)
-
-
-
$168,000
-
-
-
-
$(454,600)
$(373,760)
$(454,600)
$(373,760)
$(454,600)
$(373,760)
$(454,600)
$(373,760)
$41,653,074
$41,733,914
$41,653,074
$41,759,114
$41,653,074
$41,733,914
$41,653,074
$210,812,174
FLUJOS DE CAJA Item Ingresos por venta Gastos Mano de Obra Gasto Fertilización Gasto Control Maleza Gasto Control Plagas y Enfermedades Gastos Varios Gasto Implantación Depreciación Valor Salvamento Predio Valor Salvamento Maquinaria Valor Salvamento Acciones de Agua Intereses Préstamo Bancario UTIL. (PERD.) A/IMPUESTO Impuesto a la Renda efectiva Depreciación Amortización Préstamo Bancario Préstamo Bancario Subsidio Ley de Riego Inversión Activo Fijo Inversión Maquinaria UTIL. (PERD.) NETA
0
1
2
3
4
$$(15,840,000) $$$$$(14,266,455) $$$$-
($17,360,000) $(563,720) $(937,260) $(356,720) $(5,481,860)
$18,536,960 ($17,360,000) $(416,080) $(623,900) $(1,366,440) $(7,068,260)
$37,073,920 $(14,480,000) $(1,188,060) $(571,900) $(1,944,040) $(7,691,820)
$74,147,840 $(14,830,000) $(1,808,340) $(432,580) $(327,180) $(8,258,220)
$(10,946,666) -
$(30,106,455) $4,515,968 $-
$(35,646,226) $5,346,934 $10,946,666
$(14,803,666) $(5,224,800) $(28,326,186) $4,248,928 $14,803,666 $(3,732,000)
$(14,803,667) $(4,702,320) $(8,307,887) $1,246,183 $14,803,667 $(3,732,000)
$(11,820,333) $(4,179,840) $32,491,347 $(4,873,702) $11,820,333 $(3,732,000)
$(10,334,920) $(31,838,368)
$(1,017,000) $500,597
$(2,597,093) $33,108,885
$37,320,000 $10,815,000 $(63,672,000) $(60,974,423)
$(682,525) $(19,914,019)
Tasa de descuento 18% VAN 155,052,640 TIR 33%
5
6
7
8
9
10
11
$111,221,760 $(15,005,000) $(2,161,440) $(432,580) $(396,060) $(8,664,620)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$(11,820,334) $(3,657,360) $69,084,366 $(10,362,655) $11,820,334 $(3,732,000)
$(10,613,334) $(3,134,880) $98,315,026 $(14,747,254) $10,613,334 $(3,732,000)
$(2,612,400) $109,450,840 $(16,417,626) $(3,732,000)
$(2,089,920) $109,973,320 $(16,495,998) $(3,732,000)
$(1,567,440) $110,495,800 $(16,574,370) $(3,732,000)
-
$(168,000)
$(1,044,960) $111,018,280 $(16,652,742) $(3,732,000)
$(522,480) $111,372,760 $(16,705,914) $168,000 $(3,732,000)
$(454,600) $66,355,445
$(541,760) $89,907,346
$(454,600) $88,846,614
$(373,760) $89,371,562
$(454,600) $89,734,830
$(373,760) $90,259,778
$(454,600) $90,648,246
12
13
14
15
16
17
18
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
-
-
-
-
$(168,000)
-
-
-
-
-
-
-
-
-
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$111,895,240 $(16,784,286) $168,000
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $94,905,194
$(454,600) $94,799,154
$(373,760) $94,879,994
19
20
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
$139,027,200 $(15,005,000) $(2,337,540) $(432,580) $(396,060) $(8,792,780)
-
-
$182,367,200 $548,400 $16,000,000
$112,063,240 $(16,809,486) -
$310,978,840 $(46,646,826) -
$(454,600) $94,799,154
$(373,760) $263,958,254
FLUJOS DE CAJA Item Ingresos por venta Gastos Mano de Obra Gasto Fertilización Gasto Control Maleza Gasto Control Plagas y Enfermedades Gastos Varios Gasto Implantación Depreciación Valor Salvamento Predio Valor Salvamento Maquinaria Valor Salvamento Acciones de Agua UTIL. (PERD.) A/IMPUESTO Impuesto a la Renda efectiva Depreciación Inversión Activo Fijo Inversión Maquinaria UTIL. (PERD.) NETA
0 $$(15,840,000) $$0.00 $0.00 $0.00 -$14,266,455.00 $$$$-
1
2
4
$18,536,960 $74,147,840 ($17,360,000) ($17,360,000) $(14,830,000) $(563,720) $(416,080) $(1,808,340) -$937,260.00 -$623,900.00 -$432,580.00 -$356,720.00 -$1,366,440.00 -$327,180.00 -$5,481,860.00 -$7,068,260.00 -$8,258,220.00
5
6
7
8
9
10
11
$111,221,760 $(15,005,000) $(2,161,440) -$432,580.00 -$396,060.00 -$8,664,620.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$(10,946,666) -
$(14,803,666) -
$(11,820,333) -
$(11,820,334) -
$(10,613,334) -
-
-
-
-
$(168,000)
-
-
$(35,646,226) $5,346,934 $10,946,666
$(23,101,386) $3,465,208 $14,803,666
$36,671,187 $(5,500,678) $11,820,333
$72,741,726 $(10,911,259) $11,820,334
$101,449,906 $(15,217,486) $10,613,334
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$111,895,240 $(16,784,286) $168,000
$(98,294,423)
$(682,525) $(30,729,019)
$(10,334,920) $(22,097,848)
$(2,597,093) $40,393,749
$(454,600) $73,196,201
$(541,760) $96,303,994
$(454,600) $94,799,154
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $94,879,994
$(454,600) $94,824,354
Tasa de descuento VAN TIR
18% 136,277,527 28%
$(30,106,455) $4,515,968 $$(63,672,000)
12
13
14
15
16
17
18
19
20
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
$139,027,200 $(15,005,000) $(2,337,540) -$432,580.00 -$396,060.00 -$8,792,780.00
-
-
-
-
$(168,000)
-
-
-
-
-
-
-
-
-
-
-
$182,367,200 $548,400 $16,000,000
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$111,895,240 $(16,784,286) $168,000
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$112,063,240 $(16,809,486) -
$310,978,840 $(46,646,826) -
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $94,905,194
$(454,600) $94,799,154
$(373,760) $94,879,994
$(454,600) $94,799,154
$(373,760) $263,958,254
$(319,950,000) $(41,200,740) ($9,486,920.00) ($10,331,340.00) ($169,056,480.00) ($14,266,455.00) $(564,291,935)
-$21,426,418.00
VARIOS Item
AÑO 1
2
Costo de la electricidad
$22,750
Costo de cada colmena
$6,000
$70,110
3 $85,128
$6,000
$6,000
3
5
N° de colmenas por ha
-
Costo Polinización por ha
-
$18,000
$168,000 $168
4
5
6
7
8
9
$85,128
$85,128
$85,128
$85,128
$85,128
$85,128
$6,000
$6,000
$6,000
$6,000
$6,000
$6,000
8
8
10
10
10
10
$30,000
$48,000
$60,000
$60,000
$60,000
$60,000
$60,000
$9,968,000
$9,968,000
$11,968,000
$11,968,000
$12,136,000
$12,136,000
$12,136,000
$12,136,000
$9,968
$9,968
$11,968
$11,968
$12,136
$12,136
$12,136
$12,136
$4,575
$4,575
$4,575
$4,575
$4,575
$4,575
$4,575
$4,575
$4,575
Reparaciones diversas por há
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
Asesorías
$30,000
$30,000
$30,000
$30,000
$30,000
$30,000
$30,000
$30,000
$30,000
$120,000
$120,000
$120,000
$120,000
$120,000
$120,000
$120,000
$120,000
$120,000
$4,160
$8,320
$16,640
$24,960
$31,200
$31,200
$31,200
$31,200
$25,000
$25,000
$25,000
$25,000
$25,000
$25,000
$25,000
$25,000
$25,000
$9,600
$9,600
$9,600
$9,600
$9,600
$9,600
$9,600
$9,600
$9,600
$12,000
$12,000
$12,000
$12,000
$12,000
$12,000
$12,000
$12,000
$12,000
Subtotal Máquinas Mantención maquinaria (2% costo inicial) Mantención construcción (1% del costo)
Costo del petróleo por ha Costo de transporte a exportadora por há Contribuciones por há Cuotas Asoc. y Fed. Productores por há Consumo Telefónico por há COSTOS VARIOS POR HA TOTAL COSTOS VARIOS
$274,093
$353,413
$384,591
$412,911
$433,231
$439,639
$439,639
$439,639
$439,639
$5,481,860
$7,068,260
$7,691,820
$8,258,220
$8,664,620
$8,792,780
$8,792,780
$8,792,780
$8,792,780
AÑO 10-20 $85,128 $6,000 10 $60,000 $12,136,000 $12,136 $4,575 $50,000 $30,000 $120,000 $31,200 $25,000 $9,600 $12,000 $439,639 $8,792,780
PRODUCTOS NECESARIOS PARA EL CONTROL DE PLAGAS Y ENFERMEDADES, POR HA PRODUCTO DOSIS % árboles que recibe aceite Aceite miscible (litro)
AÑO 1 20% 1%
2 20% 0.83
3 20% 1.66
4 20% 4.99
5 20% 8.32
6 20% 9.98
7 20% 9.98
8 20% 9.98
9 20% 9.98
% árboles que recibió S montaje S montaje (Kg) 0.30%
20% 0.25
20% 0.50
20% 1.50
20% 2.50
20% 3.00
20% 3.00
20% 3.00
20% 3.00
20% 3.00
% árboles que recibió el tratamiento Acido fosforoso (Kg) 20.0% Hidróx. Potasio (kg) 20.0%
0% 0.00 0.00
0% 0.00 0.00
0% 0.00 0.00
5% 0.25 0.25
5% 0.33 0.33
5% 0.33 0.33
5% 0.33 0.33
5% 0.33 0.33
5% 0.33 0.33
% de la ha que recibió Metalaxil: Metalaxil (5% G), 50 gr/m2
5% 1.04
5% 4.16
3% 5.62
0% 0.00
0% 0.00
0% 0.00
0% 0.00
0% 0.00
0% 0.00
% de la ha que recibió Metomilo Metomilo (P.C. 90%, SP)
10.0% 0.02
10.0% 0.04
10.0% 0.12
10.0% 0.21
10.0% 0.25
10.0% 0.25
10.0% 0.25
10.0% 0.25
10.0% 0.25
4 $8,154 $1,872 $1,061 $245 $5,027 $16,359 $327,180
5 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
6 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
7 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
8 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
9 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
COSTO ANUAL DEL CONTROL DE PLAGAS Y ENFERMEDADES Producto $/unidad AÑO 1 2 3 Aceite miscible (litro) $980 $818 $1,631 $4,892 S mojable (Kg) $750 $187 $374 $1,123 Acido fosforoso (Kg) $4,250 Hidróxido de Potasio (Kg) $980 Metalaxil (Kg) $15,700 $16,328 $65,312 $88,171 Metomilo (kg) $24,169 $503 $1,005 $3,016 COSTO POR HA $17,836 $68,322 $97,202 COSTO TOTAL $356,720 $1,366,440 $1,944,040
10-20 20% 9.98 20% 3.00 5% 0.33 0.33 0% 0.00 10.0% 0.25
10-20 $9,784 $2,246 $1,414 $326 $6,033 $19,803 $396,060
CANTIDAD DE HERBICIDA NECESARIO PARA EL CONTROL DE MALEZAS (litros de p.c. por ha) Producto 1 2 3 4 Gilfosato (litros de producto comercial 48%) 8.0 4.4 3.0 2.0 Aminotriazon (litros de producto comercial 50%) 5.0 2.0 2.0 1.0 Simazina (litros de p.c. al 48%) 4.0 6.0 6.0 5.0 MCPA (litros de p.c. al 75%) 1.0 1.0 1.0 1.0 Humectante adherente no iónico 1.0 1.0 1.0 1.0
COSTO DEL CONTROL DE MALEZAS Producto $/litro de i.a. Gilfosato (litro) $2,600 Aminotriazon (litro) $2,800 Simazina (litro) $1,566 MCPA (litro) $2,899 Humectante adherente $2,900 COSTO CONTROL DE MALEZAS POR HA TOTAL COSTO CONTROL DE MALEZAS
1 $20,800 $14,000 $6,264 $2,899 $2,900 $46,863 $937,260
2 $10,400 $5,600 $9,396 $2,899 $2,900 $31,195 $623,900
3 $7,800 $5,600 $9,396 $2,899 $2,900 $28,595 $571,900
4 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
5 2.0 1.0 5.0 1.0 1.0
5 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
6 2.0 1.0 5.0 1.0 1.0
6 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
7 2.0 1.0 5.0 1.0 1.0
7 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
8 2.0 1.0 5.0 1.0 1.0
8 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
9 2.0 1.0 5.0 1.0 1.0
9 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
10-20 2.0 1.0 5.0 1.0 1.0
10-20 $5,200 $2,800 $7,830 $2,899 $2,900 $21,629 $432,580
DOSIS DE FERTILIZANTES USADOS Elemento o Producto N U.N. P U.P. K U.K. Sn Sulfato de Zinc gr/100I B ácido bórico gr/m2
Año 1 34 6 20 180 0
MOJAMIENTO PARA APLICACIONES FOLIARES Año 1 Litros por árbol 0.00 Litros por ha 0.00
PROYECTO DE CANOPIA PARA APLICAR ACIDO BORICO Año 1 1.00 m2 por planta
2 70 0 0 180 0
3 120 0 0 180 8
4 180 0 0 180 8
5 220 0 0 180 8
6 250 0 0 180 8
7 250 0 0 180 8
8 250 0 0 180 8
9 250 0 0 180 8
2 1.00 416.00
3 2.00 832.00
4 3.00 1248.00
5 5.50 2288.00
6 5.50 2288.00
7 5.50 2288.00
8 5.50 2288.00
9 5.50 2288.00
2 4.00
3 9.00
4 14.00
5 16.00
6 16.00
7 16.00
8 16.00
9 16.00
3 260.87 0.00 0.00 1.50 29.95
4 391.30 0.00 0.00 2.25 46.59
5 478.26 0.00 0.00 4.12 53.25
6 543.48 0.00 0.00 4.12 53.25
7 543.48 0.00 0.00 4.12 53.25
8 543.48 0.00 0.00 4.12 53.25
9 543.48 0.00 0.00 4.12 53.25
CANTIDAD DE FERTILIZANTES NECESARIA POR HA (EN KG) % nutriente 1 2 N urea 46% 73.91 152.17 P ácido fosfórico 54% 11.11 0.00 K Nitrato de potasio 46% 43.48 0.00 Zn Sulfato de Zinc 0.00 0.75 B ácido bórico 0.00 0.00
COSTO DE LA FERTILIZACIÓN EN TOTAL Costo por Kg N urea $135 P ácido fosfórico $950 K Nitrato de potasio $176 Zn Sulfato de Zinc $350 B ácido bórico $790 COSTO DE LA FERTILIZACION POR HA COSTO TOTAL DE LA FERTILIZACION
1 $9,978 $10,556 $7,652 $28,186 $563,720
2 $20,542 $262 $20,804 $416,080
3 $35,217 $524 $23,662 $59,403 $1,188,060
4 $52,823 $786 $36,808 $90,417 $1,808,340
5 $64,565 $1,441 $42,066 $108,072 $2,161,440
6 $73,370 $1,441 $42,066 $116,877 $2,337,540
7 $73,370 $1,441 $42,066 $116,877 $2,337,540
8 $73,370 $1,441 $42,066 $116,877 $2,337,540
9 $73,370 $1,441 $42,066 $116,877 $2,337,540
10 250 0 0 180 8
10 5.50 2288.00
10-20 16.00
10-20 543.48 0.00 0.00 4.12 53.25
10-20 $73,370 $1,441 $42,066 $116,877 $2,337,540
NECESIDADES DE MANO DE OBRA Año Item: Administrador Capataz Regador Trabajadores Permanentes Jornadas Cosechador J. Varios (jornada)
0
1
2
3
4
5
6
7
8
1 1 1 1 0 0
1 1 1 1 0 20
1 1 1 2 0 20
1 1 1 2 0 20
1 1 1 2 70 20
1 1 1 2 105 20
1 1 1 2 204 20
1 1 1 2 204 20
1 1 1 2 204 20
1 -
2 850
3 800
4 750
5 700
6 650
7 650
8 650
0
1
2
3
4
5
6
7
RENDIMIENTO DE LOS COSECHEROS Año Kg. Por Jornada
COSTO DE LA MANO DE OBRA Año Item: $/año Administrador $8,400,000 Capataz $3,600,000 Regador $2,400,000 Trabajadores Permanentes $1,440,000 Jornadas Cosechador $5,000 J. Varios (jornada) $4,000 COSTO DE LA MANO DE OBRA POR HA COSTO TOTAL DE LA MANO DE OBRA
$8,400,000 $3,600,000 $2,400,000 $1,440,000 $792,000 $15,840,000
$8,400,000 $3,600,000 $2,400,000 $2,880,000 $80,000 $868,000 $17,360,000
$8,400,000 $3,600,000 $2,400,000 $2,880,000 $80,000 $868,000 $17,360,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $80,000 $724,000 $14,480,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $350,000 $80,000 $741,500 $14,830,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $525,000 $80,000 $750,250 $15,005,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $1,020,000 $80,000 $775,000 $15,500,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $1,020,000 $80,000 $775,000 $15,500,000
9
10-20
1 1 1 2 204 20
1 1 1 2 204 20
9 650
10-20 650
8
9
$8,400,000 $3,600,000 $2,400,000 2.880.000 $1,020,000 $80,000 $775,000 $15,500,000
$8,400,000 $3,600,000 $2,400,000 2.880.000 $1,020,000 $80,000 $775,000 $15,500,000
10-20 $8,400,000 $3,600,000 $2,400,000 2.880.000 $1,020,000 $80,000 $775,000 $15,500,000
COSTO DE COMPRA DE MAQUINARIA E IMPLEMENTACION EN EL TIEMPO Item Costo/u Año 1 2 Máquinas: Tractor Coloso Pulverizadora Tractoelevador Portabins Bombas espalda Arriendo de Maquinaria (horas: Pulverizadora/Tractor Herramientas: Chuzos Picotas Palas Capachos cosecheros Escaleras de 6m Tijeras podadoras varios (global) Vestimenta operarios: Ropa trabajo Ropa impermeable Zapatos Botas Kit implement. Seguridad
3
4
5
6
7
8
$6,000,000 $1,500,000 $2,000,000 $1,300,000 $1,000,000 $42,000
$168,000
$6,000,000 $1,500,000 $1,300,000 $1,000,000
-
$2,000,000 -
-
$168,000
-
-
$11,000
$114,400
$249,600
$582,400
-
-
-
-
-
$6,700 $5,000 $4,100 $5,000 $38,000 $17,500 $100,000
$13,400 $10,000 $16,400 $52,500 $100,000
$10,000 $100,000
$5,000 $52,500 $100,000
$10,000 $253,333 $100,000
$25,000 $52,500 $100,000
$40,000 $100,000
$25,000 $52,500 $100,000
$40,000 $100,000
$9,680 $3,835 $11,900 $5,600 $7,000
$87,120 $11,505 $71,400 $16,800 $21,000
$87,120 $71,400 $16,800
$116,160 $15,340 $95,200 $22,400 $28,000
$116,160 $95,200 $22,400 -
$116,160 $15,340 $95,200 $22,400 $28,000
$116,160 $95,200 $22,400 -
$116,160 $15,340 $95,200 $22,400 $28,000
$116,160 $95,200 $22,400 -
COSTO MAQUINARIA Y HERRAMIENTAS $34,126 COSTO TOTAL MAQUINARIAS Y HERRAMIENTAS $682,525
$516,746 $10,334,920
$50,850 $1,017,000
$129,855 $2,597,093
$22,730 $454,600
$27,088 $541,760
$22,730 $454,600
$18,688 $373,760
9
10-20
-
-
-
-
$25,000 $52,500 $100,000
$40,000 $100,000
$116,160 $15,340 $95,200 $22,400 $28,000
$116,160 $95,200 $22,400 -
$22,730 $454,600
$18,688 $373,760
NECESIDADES DE LA MAQUINA E IMPLEMENTACION EN EL TIEMPO Item Año 1 2 3 Máquinas: Tractor 0 1 0 Coloso 0 1 0 Pulverizadora 0 0 0 Tractoelevador 0 1 0 Portabins 0 1 0 Bombas espalda 4 0 0 Arriendo de Maquinaria (horas: Pulverizadora 10 62 146 Herramientas: Chuzos 2 0 0 Picotas 2 0 0 Palas 4 0 0 Capachos cosecheros 0 2 1 Escaleras de 6m 0 0 0 Tijeras podadoras 3 0 3 varios (global) 1 1 1 Vestimenta operarios: Ropa trabajo 9 9 12 Ropa impermeable 3 0 4 Zapatos 6 6 8 Botas 3 3 4 Kit implement. Seguridad 3 0 4
4
5
6
7
8
9
10-20
0 0 1 0 0 0
0 0 0 0 0 0
0 0 0 0 0 4
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0
0
0
0
0
0
0
0 0 0 2 7 0 1
0 0 0 7 0 3 1
0 0 0 8 0 0 1
0 0 0 7 0 3 1
0 0 0 8 0 0 1
0 0 0 7 0 3 1
0 0 0 8 0 0 1
12 0 8 4 0
12 4 8 4 4
12 0 8 4 0
12 4 8 4 4
12 0 8 4 0
12 4 8 4 4
12 0 8 4 0
EVALUACION ECONOMICA DEL CULTIVO DEL PALTO HASS PROYECTO DE PLANTACION Marco de plantación: 6 por 4 m. N° de ha del Predio : 22 Valor Comercial por ha : $ 8,000,000 Valor Comercial Total : $ 176,000,000
NUMERO DE HECTAREAS PLANTADAS Año 1 2 3 4 5 Paltos Hass 20.0 20.0 20.0 20.0 20.0 TOTAL 20.0 20.0 20.0 20.0 20.0
6 20.0 20.0
7 20.0 20.0
8 20.0 20.0
9 20.0 20.0
10-20 20.0 20.0
DENSIDAD DE PLANTAS Año 1 2 Arboles por ha 416 416
3 416
RENDIMIENTO POR ARBOL Año 1 2 3 Kilos por árbol 0 4 8
4 416
5 416
6 416
7 416
8 416
9 416
10-20 416
4 16
5 24
6 30
7 30
8 30
9 30
10-20 30
RENDIMIENTO POR HECTAREA Año 1 2 3 4 Kilos por ha 0 1.66 3.33 6.66
5 9.98
6 7 8 9 10-20 12.480 12.480 12.480 12.480 12.480
1
2
3
INGRESOS POR VENTA PALTA HASS AÑO 4 5 6 6656 9984 12480 50% 50% 50% 3328 4992 6240 $683 $683 $683 $2,273,024 $3,409,536 $4,261,920
12480 50% 6240 $683 $4,261,920
12480 50% 6240 $683 $4,261,920
7
8
Kg. Producidos por Há % Exportación Kg. Exportación Precio/Kg. Exportado Ingreso por exportación
0 0% 0 $683 $-
1664 50% 832 $683 $568,256
3328 50% 1664 $683 $1,136,512
% Mercado Interno Kg. Mercado Interno Precio/Kg. Mercado Interno Ingreso por mercado interno
0% 0 $431 $-
50% 832 $431 $358,592
50% 1664 $431 $717,184
50% 3328 $431 $1,434,368
50% 4992 $431 $2,151,552
50% 6240 $431 $2,689,440
50% 6240 $431 $2,689,440
50% 6240 $431 $2,689,440
$$-
$926,848 $18,536,960
$1,853,696 $37,073,920
$3,707,392 $74,147,840
$5,561,088 $111,221,760
$6,951,360 $139,027,200
$6,951,360 $139,027,200
$6,951,360 $139,027,200
Ingresos por Há TOTAL INGRESOS
GRESOS POR VENTA PALTA HASS AÑO 9
10-20
12480 50% 6240 $683 $4,261,920
12480 50% 6240 $683 $4,261,920
50% 6240 $431 $2,689,440
50% 6240 $431 $2,689,440
$6,951,360 $139,027,200
$6,951,360 $139,027,200
Item Obtención de agua : Análisis de agua Subtotal Obtención de agua
GASTO DE IMPLANTACION unidad costo n°/há
Manejo del suelo : Calicatas Análisis de suelo Levantamiento topográfico Limpieza del terreno Subsolado Camellones Caminos Subtotal Manejo del Suelo Plantación : Hoyadura, plantar y tapar Fertilización Tutorar Control conejos 2% replantes Subtotal Plantación
COSTO IMPLANTACION POR Há TOTAL COSTO DE IMPLANTACION
global
$ total
u.
$12,500
1
u. u. há há há há ml.
$1,000 $12,500 $14,000 $20,000 $110,000 $240,000 $90
0.5 0.2 1 1 1 1 122
$500 $2,500 $14,000 $20,000 $110,000 $240,000 $10,980
$10,000 $50,000 $280,000 $400,000 $2,200,000 $4,800,000 $219,600 $7,959,600
$100 $61 $342 $122 $2,500
416 416 416 416 8.3
$41,600 $25,376 $142,272 $50,752 $20,750
$832,000 $507,520 $2,845,440 $1,015,040 $415,000 $5,615,000
por planta por planta por planta por planta u.
Varios e Imprevistos : 5% de los costos
$/há
global
$12,500 $12,500
$679,355 $713,323 $14,266,455
VALOR DE SALVAMENTO DE LA INFRAESTRUCTURA, MAQUINARIA Y OTRAS INVERSIONES Item Terreno Acciones de Agua Plantación : Paltos Construcciones : Casa cuidador Oficina Muebles Oficina Bodega Instalación eléctrica : Postación alta tensión Transformadores (25 KVA) Emp. Tarifa horaria Equipo de Medida Sistema de riego : Sistema de riego Tranques acumuladores Caseta bombas Maquinaria : Tractor Coloso Pulverizadora Tractoelevador Bombas Espalda TOTAL
Valor Salvamento
Depreciación acelerada
Valor Inicial
Vida útil
Años de uso
-
-
20 20
$176,000,000 $16,000,000
$17,472,000
20
20
$1,747,200
$2,912,000
$4,900,000 $1,750,000 $1,000,000 $2,500,000
20 20 10 20
20 20 20 20
$490,000 $175,000 $100,000 $250,000
$816,667 $291,667 $333,333 $416,667
$2,000,000 $1,200,000 $950,000 $1,850,000
20 20 20 20
20 20 20 20
$200,000 $120,000 $95,000 $185,000
$333,333 $200,000 $158,333 $308,333
$26,000,000 $3,800,000 $250,000
20 20 20
20 20 20
$2,600,000 $380,000 $25,000
$4,333,333 $633,333 $41,667
$6,000,000 $1,500,000 $2,000,000 $1,300,000 $168,000 $74,640,000
8 12 8 8 5
20 20 20 20 5
$300,000 $75,000 $100,000 $65,000 $8,400 $198,915,600
$3,000,000 $375,000 $1,000,000 $650,000 $168,000 $15,971,667
-
LA INFRAESTRUCTURA, MAQUINARIA Y OTRAS INVERSIONES Años Depreciación 6 6 6 3 6 6 6 6 6 6 6 6 2 4 2 2 1 6