Palto Estudiofinanciero

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Palto Estudiofinanciero as PDF for free.

More details

  • Words: 3,822
  • Pages: 29
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

Related Documents

Palto Estudiofinanciero
November 2019 6
Cultivo De Palto
August 2019 32