• Author / Uploaded
• Johan Salazar

Citation preview

Variables del Proyecto Extension total del terreno (Manzanas) Valor de mercado del terreno $

26 $

No de manzanas a cultivar

33

No. de racimos por manzana promedio No. de dedos por racimo promedio Desperdicio por dano mecanico, plagas y Transp. Precio Base Cordovas (por millar)

2,000.00 1080

1300

25

30

5% C$

785.00

Inflacion Anual

20%

Imprevistos

10%

Impuesto sobre la Renta

30%

Impuesto sobre ganacias en venta de activos

30%

Costo de oportunidad de recursos propios

36%

Apalancamiento del proyecto Tasa de interes anual (Financiamiento)$ Tipo de cambio al inicio (Cordovas X $) Tasa de devaluacion anual Capital de trabajo inicial Escenarios Financiado Fondos propios

17% 8 20% C$ 14,630.00 1 0% 100%

2 40% 60%

1400

3 90% 10%

Ano 1

Ano 2

Produccion y Ventas

Area Cultivable Racimos por manzana (Promedio) Dedos por racimo (Promedio) Produccion Bruta (Dedos) Desperdicio por dano mecanico Produccion Neta Dedos Precio (Cordovas x millar de dedos) Ingresos por Ventas

C$

33

33

1,080

1,300

25

30

891,000

1,287,000

44,550

64,350

846,450

1,222,650

785.00 C$ ###

942.00 ###

Ano 3

C$

Ano 4

Ano 5

Ano 6

33

33

33

33

1,400

1,400

1,400

1,400

30

30

30

30

1,386,000

1,386,000

1,386,000

1,386,000

69,300

69,300

69,300

69,300

1,316,700

1,316,700

1,316,700

1,316,700

1,130.40 C$

1,356.48 C$

1,627.78 C$

###

###

###

1,953.33 ###

Ano 7

C$

Ano 8

Ano 9

Ano 10

33

33

33

33

1,400

1,400

1,400

1,400

30

30

30

30

1,386,000

1,386,000

1,386,000

1,386,000

69,300

69,300

69,300

69,300

1,316,700

1,316,700

1,316,700

1,316,700

2,344.00 C$

2,812.80 C$

3,375.36 C$

###

###

###

4,050.43 ###

Ano 1 Inversion en Capital de trabajo

14,630.00

Ano 2 17,556.00 2,926.00

Ano 3

Ano 4

Ano 5

Ano 6

Ano 7

21,067.20

25,280.64

30,336.77

36,404.13

43,684.96

3,511.20

4,213.44

5,056.13

6,067.36

7,280.83

Ano 8

Ano 9

Ano 10

52,421.96

62,906.36

75,487.64

8,737.00

10,484.40

12,581.28

Precio de compra del inmueble

No. de manzanas Precio por manzana $ Costo Total $ Tipo de cambio en el ano cero Precio de compra en cordovas

$ $ C$

36 2,000.00 72,000.00 8.00 576,000.00

Calculo del tipo de cambio en el ano 10

Tipo de cambio en el ano cero Devaluacion anual Tiempo transcurrido Tipo de cambio en el ano 10

8.00 20% 10 49.54

Precio de venta del inmueble

No. de manzanas Precio por manzana $ Precio de venta total $ Tipo de cambio en el ano 10 Precio de venta en cordovas Precio de compra valor en libros Utilidad generada por la venta Impuesto sobre las ganancias (30%) Valor residual

36 2,000.00 72,000.00 49.54 C$ 3,566,880.00 C$ 576,000.00 $ 2,990,880.00 $ 897,264.00 $ 2,669,616.00 Esta es la entrada en efectivo $ $

la entrada en efectivo en el ano 10

Ano 0 Cercado

C$

26,500.00

Drenaje

C$

32,000.00

Pozo de agua y bomba de riego

C$

554,400.00

Construcciones

C$

99,200.00

Bombas de fumigacion

C$

4,800.00

Vehiculo

C$

120,000.00

Plantacion

C$

317,300.00

Semilla

C$ 171,000.00

Mano de obra e insumos

C$ 146,300.00

Sub Total

C$ 1,154,200.00

Imprevistos

10% C$

Costo de capital

10%

115,420.00

Sub Total

C$ 1,269,620.00

Terreno

C$

Total Inversion

576,000.00 ###

Ano 1

C$

Ano 2

-

C$

Ano 3

2,926.00

C$

Ano 4

3,511.20

C$

Ano 5

4,213.44

C$

-

C$

14,630.00

5,056.13

C$

14,630.00 C$ 2,926.00 C$ 3,511.20 C$ 4,213.44 C$ 5,056.13

C$ 14,630.00 C$ 2,926.00 C$ 3,511.20 C$ 4,213.44 C$ 5,056.13

Ano 6

Ano 7

Ano 8

Ano 9

Ano 10

11,944.00 49,765.00

C$ 61,709.00 C$ 6,067.36

7,280.83

C$

8,737.00

C$

10,484.40

C$

12,581.28

C$ 67,776.36 C$ 7,280.83 C$ 8,737.00 C$ 10,484.40 C$ 12,581.28 C$ 67,776.36 C$ 7,280.83 C$ 8,737.00 C$ 10,484.40 C$ 12,581.28

Ano 1

Ano 2

Ano 3

Sueldo Administrador

76,800.00

92,160.00

110,592.00

Sueldo Contador

12,000.00

14,400.00

17,280.00

Seguridad

19,200.00

23,040.00

27,648.00

Seguros

13,824.00

16,588.80

19,906.56

4,000.00

4,800.00

5,760.00

125,824.00

150,988.80

181,186.56

Sueldo Motorista

9,600.00

11,520.00

13,824.00

Mantenimiento de camion

5,440.00

6,528.00

7,833.60

Gastos de comercializacion

12,000.00

14,400.00

17,280.00

Total de Gastos de Venta

27,040.00

32,448.00

38,937.60

Variables Gastos Variables de Produccion

42,435.00

365,348.00

438,417.60

Administracion

Herramientas Total Gastos de Admon Ventas

Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

Ano 9

132,710.40

159,252.48

191,102.98

229,323.57

275,188.29

330,225.94

20,736.00

24,883.20

29,859.84

35,831.81

42,998.17

51,597.80

33,177.60

39,813.12

47,775.74

57,330.89

68,797.07

82,556.49

23,887.87

28,665.45

34,398.54

41,278.24

49,533.89

59,440.67

6,912.00

8,294.40

9,953.28

11,943.94

14,332.72

17,199.27

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

541,020.17

16,588.80

19,906.56

23,887.87

28,665.45

34,398.54

41,278.24

9,400.32

11,280.38

13,536.46

16,243.75

19,492.50

23,391.00

20,736.00

24,883.20

29,859.84

35,831.81

42,998.17

51,597.80

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

116,267.05

526,101.12

631,321.34

757,585.61

909,102.74 1,090,923.28 1,309,107.94

Ano 10

396,271.13 61,917.36 99,067.78 71,328.80 20,639.12 649,224.20 49,533.89 28,069.21 61,917.36 139,520.46

1,570,929.53

Ano 1 Vida Util

Valor Original

Depreciaciones Cercado

5

26,500.00

5,300.00

Drenajes

5

32,000.00

6,400.00

Riego, Pozo, Bomba

10

554,400.00

55,440.00

Construcciones

10

99,200.00

9,920.00

Bombas Fumigacion

5

4,800.00

960.00

Vehiculo

5

120,000.00

24,000.00

Total Depreciaciones

836,900.00 102,020.00

Amortizaciones Semilla Plantacion

(Mano de obra e Insumos)

Imprevistos Total Amortizaciones

5

171,000.00

34,200.00

5

146,300.00

29,260.00

5

115,420.00

23,084.00

432,720.00

86,544.00

Ano 2

Ano 3

Ano 4

Ano 5

Ano 6

Ano 7

5,300.00

5,300.00

5,300.00

5,300.00

6,400.00

6,400.00

6,400.00

6,400.00

55,440.00

55,440.00

55,440.00

55,440.00

55,440.00

55,440.00

9,920.00

9,920.00

9,920.00

9,920.00

9,920.00

9,920.00

960.00

960.00

960.00

960.00

2,388.80

2,388.80

24,000.00

24,000.00

24,000.00

24,000.00

9,953.00

9,953.00

102,020.00 102,020.00 102,020.00 102,020.00

77,701.80

77,701.80

34,200.00

34,200.00

34,200.00

34,200.00

29,260.00

29,260.00

29,260.00

29,260.00

23,084.00

23,084.00

23,084.00

23,084.00

86,544.00

86,544.00

86,544.00

86,544.00

Ano 8

Ano 9

Ano 10

55,440.00

55,440.00

55,440.00

9,920.00

9,920.00

9,920.00

2,388.80

2,388.80

2,388.80

9,953.00

9,953.00

9,953.00

77,701.80

77,701.80

77,701.80

Amortizacion Prestamo 2do Escenario Importe del Prestamo

C$ 738,248.00

Tasa de Interes Anual

17%

Plazo del prestamo

5

Plazo para pago de capital

4

Numero de pagos al ano

Cuota Programada

Interes Total

12

Capital

Interes

Cuota

Saldo Inicial Mes 1

C$

10,458.51 C$

10,458.51

Mes 2

C$

10,458.51 C$

10,458.51

Mes 3

C$

10,458.51 C$

10,458.51

Mes 4

C$

10,458.51 C$

10,458.51

Mes 5

C$

10,458.51 C$

10,458.51

Mes 6

C$

10,458.51 C$

10,458.51

Mes 7

C$

10,458.51 C$

10,458.51

Mes 8

C$

10,458.51 C$

10,458.51

Mes 9

C$

10,458.51 C$

10,458.51

Mes 10

C$

10,458.51 C$

10,458.51

Mes 11

C$

10,458.51 C$

10,458.51

Mes 12

C$

10,458.51 C$

10,458.51

Total Ano 1

C$

-

C$

125,502.16

C$ 125,502.16

Mes 1

C$

10,843.66

C$

10,458.51 C$

21,302.18

Mes 2

C$

10,997.28

C$

10,304.89 C$

21,302.18

Mes 3

C$

11,153.08

C$

10,149.10 C$

21,302.18

Mes 4

C$

11,311.08

C$

9,991.10 C$

21,302.18

Mes 5

C$

11,471.32

C$

9,830.86 C$

21,302.18

Mes 6

C$

11,633.83

C$

9,668.35 C$

21,302.18

Mes 7

C$

11,798.64

C$

9,503.53 C$

21,302.18

Mes 8

C$

11,965.79

C$

9,336.39 C$

21,302.18

Mes 9

C$

12,135.31

C$

9,166.87 C$

21,302.18

Mes 10

C$

12,307.22

C$

8,994.96 C$

21,302.18

Mes 11

C$

12,481.57

C$

8,820.60 C$

21,302.18

Mes 12

C$

12,658.40

C$

8,643.78 C$

21,302.18

Total Ano 2

### C$

114,868.94

C$ 255,626.13

Mes 1

C$

12,837.72

C$

8,464.45 C$

21,302.18

Mes 2

C$

13,019.59

C$

8,282.59 C$

21,302.18

Mes 3

C$

13,204.04

C$

8,098.14 C$

21,302.18

Mes 4

C$

13,391.09

C$

7,911.08 C$

21,302.18

Mes 5

C$

13,580.80

C$

7,721.38 C$

21,302.18

Mes 6

C$

13,773.20

C$

7,528.98 C$

21,302.18

Mes 7

C$

13,968.32

C$

7,333.86 C$

21,302.18

Mes 8

C$

14,166.20

C$

7,135.98 C$

21,302.18

Mes 9

C$

14,366.89

C$

6,935.29 C$

21,302.18

Mes 10

C$

14,570.42

C$

6,731.76 C$

21,302.18

Mes 11

C$

14,776.83

C$

6,525.34 C$

21,302.18

Mes 12

C$

14,986.17

C$

6,316.01 C$

21,302.18

Total Ano 3

### C$

88,984.86

C$ 255,626.13

Mes 1

C$

15,198.48

C$

6,103.70 C$

21,302.18

Mes 2

C$

15,413.79

C$

5,888.39 C$

21,302.18

Mes 3

C$

15,632.15

C$

5,670.03 C$

21,302.18

Mes 4

C$

15,853.60

C$

5,448.57 C$

21,302.18

Mes 5

C$

16,078.20

C$

5,223.98 C$

21,302.18

Mes 6

C$

16,305.97

C$

4,996.21 C$

21,302.18

Mes 7

C$

16,536.97

C$

4,765.20 C$

21,302.18

Mes 8

C$

16,771.25

C$

4,530.93 C$

21,302.18

Mes 9

C$

17,008.84

C$

4,293.34 C$

21,302.18

Mes 10

C$

17,249.80

C$

4,052.38 C$

21,302.18

Mes 11

C$

17,494.17

C$

3,808.01 C$

21,302.18

Mes 12

C$

17,742.00

C$

3,560.17 C$

21,302.18

Total Ano 4

### C$

58,340.91

C$ 255,626.13

Mes 1

C$

17,993.35

C$

3,308.83 C$

21,302.18

Mes 2

C$

18,248.25

C$

3,053.92 C$

21,302.18

Mes 3

C$

18,506.77

C$

2,795.41 C$

21,302.18

Mes 4

C$

18,768.95

C$

2,533.23 C$

21,302.18

Mes 5

C$

19,034.84

C$

2,267.33 C$

21,302.18

Mes 6

C$

19,304.50

C$

1,997.67 C$

21,302.18

Mes 7

C$

19,577.99

C$

1,724.19 C$

21,302.18

Mes 8

C$

19,855.34

C$

1,446.84 C$

21,302.18

Mes 9

C$

20,136.62

C$

1,165.55 C$

21,302.18

Mes 10

C$

20,421.89

C$

880.28

C$

21,302.18

Mes 11

C$

20,711.20

C$

590.97

C$

21,302.18

Mes 12

C$

21,004.61

C$

297.57

C$

21,302.18

### C$

22,061.79

Total Ano 5

C$ 255,626.13

rio

Amortizacion Prestamo 3er Escenar C$

21,302.18

Importe del Prestamo

C$ 1,661,058.00

C$ 409,758.67

Tasa de Interes Anual

17%

Plazo del prestamo

5

Plazo para pago de capital

4

Numero de pagos al ano

12

Saldo C$ 738,248.00

Capital

Interes

Saldo Inicial

C$ 738,248.00

Mes 1

C$

23,531.66

C$ 738,248.00

Mes 2

C$

23,531.66

C$ 738,248.00

Mes 3

C$

23,531.66

C$ 738,248.00

Mes 4

C$

23,531.66

C$ 738,248.00

Mes 5

C$

23,531.66

C$ 738,248.00

Mes 6

C$

23,531.66

C$ 738,248.00

Mes 7

C$

23,531.66

C$ 738,248.00

Mes 8

C$

23,531.66

C$ 738,248.00

Mes 9

C$

23,531.66

C$ 738,248.00

Mes 10

C$

23,531.66

C$ 738,248.00

Mes 11

C$

23,531.66

C$ 738,248.00

Mes 12

C$

23,531.66

C$

282,379.86

Total Ano 1

C$

-

C$ 727,404.34

Mes 1

C$

24,398.24

C$

23,531.66

C$ 716,407.05

Mes 2

C$

24,743.89

C$

23,186.01

C$ 705,253.98

Mes 3

C$

25,094.42

C$

22,835.47

C$ 693,942.90

Mes 4

C$

25,449.93

C$

22,479.97

C$ 682,471.58

Mes 5

C$

25,810.47

C$

22,119.43

C$ 670,837.75

Mes 6

C$

26,176.12

C$

21,753.78

C$ 659,039.10

Mes 7

C$

26,546.95

C$

21,382.95

C$ 647,073.31

Mes 8

C$

26,923.03

C$

21,006.87

C$ 634,938.01

Mes 9

C$

27,304.44

C$

20,625.46

C$ 622,630.79

Mes 10

C$

27,691.25

C$

20,238.65

C$ 610,149.21

Mes 11

C$

28,083.54

C$

19,846.36

C$ 597,490.82

Mes 12

C$

28,481.39

C$

19,448.51

C$

316,703.66

C$

258,455.12

Total Ano 2 C$ 584,653.09

Mes 1

C$

28,884.88

C$

19,045.02

C$ 571,633.50

Mes 2

C$

29,294.08

C$

18,635.82

C$ 558,429.46

Mes 3

C$

29,709.08

C$

18,220.82

C$ 545,038.37

Mes 4

C$

30,129.96

C$

17,799.94

C$ 531,457.57

Mes 5

C$

30,556.80

C$

17,373.10

C$ 517,684.38

Mes 6

C$

30,989.69

C$

16,940.21

C$ 503,716.06

Mes 7

C$

31,428.71

C$

16,501.19

C$ 489,549.86

Mes 8

C$

31,873.95

C$

16,055.95

C$ 475,182.97

Mes 9

C$

32,325.50

C$

15,604.40

C$ 460,612.55

Mes 10

C$

32,783.44

C$

15,146.46

C$ 445,835.72

Mes 11

C$

33,247.87

C$

14,682.03

C$ 430,849.55

Mes 12

C$

33,718.89

C$

14,211.01

C$

374,942.85

C$

200,215.94

Total Ano 3 C$ 415,651.08

Mes 1

C$

34,196.57

C$

13,733.33

C$ 400,237.29

Mes 2

C$

34,681.02

C$

13,248.88

C$ 384,605.14

Mes 3

C$

35,172.34

C$

12,757.56

C$ 368,751.54

Mes 4

C$

35,670.61

C$

12,259.29

C$ 352,673.34

Mes 5

C$

36,175.94

C$

11,753.96

C$ 336,367.37

Mes 6

C$

36,688.44

C$

11,241.46

C$ 319,830.39

Mes 7

C$

37,208.19

C$

10,721.71

C$ 303,059.15

Mes 8

C$

37,735.31

C$

10,194.59

C$ 286,050.31

Mes 9

C$

38,269.89

C$

9,660.01

C$ 268,800.51

Mes 10

C$

38,812.05

C$

9,117.85

C$ 251,306.34

Mes 11

C$

39,361.88

C$

8,568.02

C$ 233,564.34

Mes 12

C$

39,919.51

C$

8,010.39

C$

443,891.74

C$

131,267.05

Total Ano 4

C$ 215,570.99

Mes 1

C$

40,485.04

C$

7,444.86

C$ 197,322.73

Mes 2

C$

41,058.57

C$

6,871.33

C$ 178,815.96

Mes 3

C$

41,640.24

C$

6,289.66

C$ 160,047.01

Mes 4

C$

42,230.14

C$

5,699.76

C$ 141,012.16

Mes 5

C$

42,828.40

C$

5,101.50

C$ 121,707.66

Mes 6

C$

43,435.14

C$

4,494.76

C$ 102,129.67

Mes 7

C$

44,050.47

C$

3,879.43

C$

82,274.33

Mes 8

C$

44,674.52

C$

3,255.38

C$

62,137.71

Mes 9

C$

45,307.40

C$

2,622.49

C$

41,715.82

Mes 10

C$

45,949.26

C$

1,980.64

C$

21,004.61

Mes 11

C$

46,600.21

C$

1,329.69

Mes 12

C$

47,260.38

C$

669.52

C$

525,519.75

C$

49,639.03

C$

(0.00)

Total Ano 5

o 3er Escenario C$

47,929.90

Interes Total C$

921,957.01

Cuota

Saldo

Cuota Programada

C$ 1,661,058.00 C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$

23,531.66

C$ 1,661,058.00

C$ 282,379.86 C$

47,929.90

C$ 1,636,659.76

C$

47,929.90

C$ 1,611,915.87

C$

47,929.90

C$ 1,586,821.45

C$

47,929.90

C$ 1,561,371.52

C$

47,929.90

C$ 1,535,561.05

C$

47,929.90

C$ 1,509,384.93

C$

47,929.90

C$ 1,482,837.99

C$

47,929.90

C$ 1,455,914.96

C$

47,929.90

C$ 1,428,610.52

C$

47,929.90

C$ 1,400,919.27

C$

47,929.90

C$ 1,372,835.73

C$

47,929.90

C$ 1,344,354.34

C$ 575,158.79 C$

47,929.90

C$ 1,315,469.46

C$

47,929.90

C$ 1,286,175.38

C$

47,929.90

C$ 1,256,466.29

C$

47,929.90

C$ 1,226,336.34

C$

47,929.90

C$ 1,195,779.53

C$

47,929.90

C$ 1,164,789.85

C$

47,929.90

C$ 1,133,361.14

C$

47,929.90

C$ 1,101,487.19

C$

47,929.90

C$ 1,069,161.69

C$

47,929.90

C$ 1,036,378.25

C$

47,929.90

C$ 1,003,130.37

C$

47,929.90

C$

969,411.49

C$ 575,158.79 C$

47,929.90

C$

935,214.92

C$

47,929.90

C$

900,533.90

C$

47,929.90

C$

865,361.56

C$

47,929.90

C$

829,690.95

C$

47,929.90

C$

793,515.01

C$

47,929.90

C$

756,826.57

C$

47,929.90

C$

719,618.38

C$

47,929.90

C$

681,883.08

C$

47,929.90

C$

643,613.19

C$

47,929.90

C$

604,801.15

C$

47,929.90

C$

565,439.26

C$

47,929.90

C$

525,519.75

C$ 575,158.79

C$

47,929.90

C$

485,034.72

C$

47,929.90

C$

443,976.14

C$

47,929.90

C$

402,335.91

C$

47,929.90

C$

360,105.77

C$

47,929.90

C$

317,277.37

C$

47,929.90

C$

273,842.23

C$

47,929.90

C$

229,791.76

C$

47,929.90

C$

185,117.25

C$

47,929.90

C$

139,809.84

C$

47,929.90

C$

93,860.58

C$

47,929.90

C$

47,260.38

C$

47,929.90

C$

0.00

C$ 575,158.79

1er Escenario Ano 1 Ventas

Ano 2

Ano 3

664,463.25 1,151,736.30 1,488,397.68

Venta del terreno Ingresos

664,463.25

###

###

42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

0.00

0.00

0.00

Depreciacion

102,020.00

102,020.00

102,020.00

Amortizacion

86,544.00

86,544.00

86,544.00

Costos Variables Gastos de admon Gastos de Venta Gastos Financieros

Egresos Utilidad antes de Impuesto Impuesto 30% Resultados del ejercicio

383,863.00 737,348.80 847,105.76 280,600.25

414,387.50

641,291.92

84,180.08

124,316.25

192,387.58

196,420.17 290,071.25 448,904.34

2do Escenario Ano 1 Ventas

Ano 2

Ano 3

664,463.25 1,151,736.30 1,488,397.68

Venta del terreno Ingresos

664,463.25

###

###

42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

Gastos Financieros

125,502.16

114,868.94

88,984.86

Depreciacion

102,020.00

102,020.00

102,020.00

Amortizacion

86,544.00

86,544.00

86,544.00

Costos Variables Gastos de admon Gastos de Venta

Egresos Utilidad antes de Impuesto Impuesto 30% Resultados del ejercicio

509,365.16 852,217.74 936,090.62 155,098.09

299,518.56

552,307.06

46,529.43

89,855.57

165,692.12

108,568.66 209,662.99 386,614.94

3er Escenario Ano 1 Ventas

Ano 2

Ano 3

664,463.25 1,151,736.30 1,488,397.68

Venta del terreno Ingresos

664,463.25

###

###

42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

Gastos Financieros

282,379.86

258,455.12

200,215.94

Depreciacion

102,020.00

102,020.00

102,020.00

Amortizacion

86,544.00

86,544.00

86,544.00

666,242.86 995,803.92

###

Costos Variables Gastos de admon Gastos de Venta

Egresos Utilidad antes de Impuesto Impuesto 30% Resultados del ejercicio

-1,779.61

155,932.38

441,075.98

46,779.72

132,322.80

-1,779.61 109,152.66 308,753.18

1er Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

Ano 9

1,786,077.22 2,143,292.66 2,571,951.20 3,086,341.43 3,703,609.72 4,444,331.66 ###

###

###

###

###

###

526,101.12

631,321.34

757,585.61

909,102.74 1,090,923.28 1,309,107.94

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

541,020.17

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

116,267.05

0.00

0.00

0.00

0.00

0.00

0.00

102,020.00

102,020.00

77,701.80

77,701.80

77,701.80

77,701.80

86,544.00

86,544.00

0.00

0.00

0.00

0.00

978,814.11

###

###

###

###

###

807,263.11 1,006,428.53 1,356,289.24 1,643,087.44 1,987,245.29 2,400,234.70 242,178.94

301,928.56

406,886.78

492,926.24

596,173.59

720,070.42

565,084.17 704,499.97 949,402.46

###

###

###

2do Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

Ano 9

1,786,077.22 2,143,292.66 2,571,951.20 3,086,341.43 3,703,609.72 4,444,331.66 ###

###

###

###

###

###

526,101.12

631,321.34

757,585.61

909,102.74 1,090,923.28 1,309,107.94

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

541,020.17

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

116,267.05

58,340.91

22,061.79

0.00

0.00

0.00

0.00

102,020.00

102,020.00

77,701.80

77,701.80

77,701.80

77,701.80

86,544.00

86,544.00

0.00

0.00

0.00

0.00

###

###

###

###

###

###

748,922.20

984,366.73 1,356,289.24 1,643,087.44 1,987,245.29 2,400,234.70

224,676.66

295,310.03

406,886.78

492,926.24

596,173.59

720,070.42

524,245.54 689,056.70 949,402.46

###

###

###

3er Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

Ano 9

1,786,077.22 2,143,292.66 2,571,951.20 3,086,341.43 3,703,609.72 4,444,331.66 ###

###

###

###

###

###

526,101.12

631,321.34

757,585.61

909,102.74 1,090,923.28 1,309,107.94

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

541,020.17

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

116,267.05

131,267.05

49,639.03

0.00

0.00

0.00

0.00

102,020.00

102,020.00

77,701.80

77,701.80

77,701.80

77,701.80

86,544.00

86,544.00

0.00

0.00

0.00

0.00

###

###

###

###

###

###

675,996.06

956,789.49 1,356,289.24 1,643,087.44 1,987,245.29 2,400,234.70

202,798.82

287,036.85

406,886.78

492,926.24

596,173.59

720,070.42

473,197.24 669,752.64 949,402.46

###

###

###

Ano 10 5,333,197.99 2,669,616.00 ### 1,570,929.53 649,224.20 139,520.46 0.00 77,701.80 0.00 ### 5,565,438.00 1,669,631.40 ###

Ano 10 5,333,197.99 2,669,616.00 ### 1,570,929.53 649,224.20 139,520.46 0.00 77,701.80 0.00 ### 5,565,438.00 1,669,631.40 ###

Ano 10 5,333,197.99 2,669,616.00 ### 1,570,929.53 649,224.20 139,520.46 0.00 77,701.80 0.00 ### 5,565,438.00 1,669,631.40 ###

1er Escena Ano 1 Saldo Inicial

Ano 2 399,614.17

Ano 3 881,175.42

(+) Ingresos por Financiamiento Ingresos por ventas Aporte de Socios

664,463.25 1,151,736.30 1,488,397.68 14,630.00

2,926.00

3,511.20

Ingresos por venta de terreno Saldo Disponible (-) Costos variables de Produccion Gastos de administracion Gastos de Venta

679,093.25 1,554,276.47 2,373,084.30 42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

84,180.08

124,316.25

192,387.58

279,479.08

673,101.05

850,929.34

399,614.17

881,175.42

###

384,984.17

478,635.25

637,468.34

Intereses Pagados Impuesto Sobre la Renta Abono a Capital Compra de Equipo Total Salidas Saldo Final Flujo Operativo

2do Escena Ano 1 Saldo Inicial (+) Ingresos por Financiamiento Ingresos por ventas Aporte de Socios

Ano 2

Ano 3

1,050,010.66 1,310,406.46 738,248.00 664,463.25 1,151,736.30 1,488,397.68 14,630.00

2,926.00

3,511.20

Ingresos por venta de terreno Saldo Disponible (-) Costos variables de Produccion Gastos de administracion Gastos de Venta Intereses Pagados

1,417,341.25 2,204,672.96 2,802,315.34 42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

125,502.16

114,868.94

88,984.86

Impuesto Sobre la Renta Abono a Capital

46,529.43

89,855.57

165,692.12

0.00

140,757.18

166,641.27

Compra de Equipo Total Salidas Saldo Final Flujo Operativo

367,330.59

894,266.50 1,079,860.01

###

###

###

297,132.66

257,469.80

408,537.67

3er Escena Ano 1 Saldo Inicial (+) Ingresos por Financiamiento Ingresos por ventas Aporte de Socios

Ano 2

Ano 3

1,862,472.39 1,846,411.38 1,661,058.00 664,463.25 1,151,736.30 1,488,397.68 14,630.00

2,926.00

3,511.20

Ingresos por venta de terreno Saldo Disponible (-) Costos variables de Produccion

2,340,151.25 3,017,134.69 3,338,320.26 42,435.00

365,348.00

438,417.60

125,824.00

150,988.80

181,186.56

27,040.00

32,448.00

38,937.60

282,379.86

258,455.12

200,215.94

Impuesto Sobre la Renta

0.00

46,779.72

132,322.80

Abono a Capital

0.00

316,703.66

374,942.85

Gastos de administracion Gastos de Venta Intereses Pagados

Compra de Equipo Total Salidas Saldo Final Flujo Operativo

477,678.86 1,170,723.31 1,366,023.35 ###

###

###

186,784.39

-18,987.01

122,374.33

1er Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,522,154.96 2,280,016.57

3,178,136.66

4,149,599.28

5,384,743.11

1,786,077.22 2,143,292.66

2,571,951.20

3,086,341.43

3,703,609.72

5,056.13

6,067.36

7,280.83

8,737.00

3,312,445.62 4,428,365.36

5,756,155.22

7,243,221.54

9,097,089.83

4,213.44

526,101.12

631,321.34

757,585.61

909,102.74

1,090,923.28

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

242,178.94

301,928.56

406,886.78

492,926.24

596,173.59

1,858,478.43

2,234,836.22

61,709.00 1,032,429.05 1,250,228.69 ### 753,648.17

1,606,555.94

### 4,149,599.28 5,384,743.11 6,862,253.61 893,063.97

965,395.26

1,227,863.00

1,468,773.50

2do Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,722,455.34 2,242,193.10

2,891,305.59

3,862,768.21

5,097,912.04

1,786,077.22 2,143,292.66

2,571,951.20

3,086,341.43

3,703,609.72

5,056.13

6,067.36

7,280.83

8,737.00

3,512,746.00 4,390,541.89

5,469,324.15

6,956,390.47

8,810,258.76

4,213.44

526,101.12

631,321.34

757,585.61

909,102.74

1,090,923.28

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

58,340.91

22,061.79

224,676.66

295,310.03

197,285.22

233,564.34

406,886.78

492,926.24

596,173.59

1,858,478.43

2,234,836.22

61,709.00 1,270,552.90 1,499,236.29 ### 515,524.32

1,606,555.94

### 3,862,768.21 5,097,912.04 6,575,422.54 644,056.37

965,395.26

1,227,863.00

1,468,773.50

3er Escenario Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,972,296.92 2,194,379.86

2,532,232.88

3,503,695.50

4,738,839.32

1,786,077.22 2,143,292.66

2,571,951.20

3,086,341.43

3,703,609.72

5,056.13

6,067.36

7,280.83

8,737.00

3,762,587.58 4,342,728.65

5,110,251.44

6,597,317.76

8,451,186.04

4,213.44

526,101.12

631,321.34

757,585.61

909,102.74

1,090,923.28

217,423.87

260,908.65

313,090.38

375,708.45

450,850.14

46,725.12

56,070.14

67,284.17

80,741.01

96,889.21

131,267.05

49,639.03

202,798.82

287,036.85

406,886.78

492,926.24

596,173.59

443,891.74

525,519.75 1,858,478.43

2,234,836.22

61,709.00 1,568,207.72 1,810,495.77 ### 217,869.50

1,606,555.94

### 3,503,695.50 4,738,839.32 6,216,349.82 332,796.89

965,395.26

1,227,863.00

1,468,773.50

Ano 9

Ano 10

6,862,253.61

8,630,604.09

4,444,331.66

5,333,197.99

10,484.40

12,581.28 2,669,616.00

11,317,069.67 16,645,999.36 1,309,107.94

1,570,929.53

541,020.17

649,224.20

116,267.05

139,520.46

720,070.42

1,669,631.40

2,686,465.58

4,029,305.59

8,630,604.09

###

1,757,866.08

3,973,508.40

Ano 9

Ano 10

6,575,422.54

8,343,773.02

4,444,331.66

5,333,197.99

10,484.40

12,581.28 2,669,616.00

11,030,238.60 16,359,168.29 1,309,107.94

1,570,929.53

541,020.17

649,224.20

116,267.05

139,520.46

720,070.42

1,669,631.40

2,686,465.58

4,029,305.59

8,343,773.02

###

1,757,866.08

3,973,508.40

Ano 9

Ano 10

6,216,349.82

7,984,700.30

4,444,331.66

5,333,197.99

10,484.40

12,581.28 2,669,616.00

10,671,165.88 16,000,095.57 1,309,107.94

1,570,929.53

541,020.17

649,224.20

116,267.05

139,520.46

720,070.42

1,669,631.40

2,686,465.58

4,029,305.59

7,984,700.30

###

1,757,866.08

3,973,508.40

Balance Ano 1

Ano 2

ACTIVOS Activos Corrientes Caja y Bancos

399,614.17

881,175.42

576,000.00

576,000.00

Cercado

26,500.00

26,500.00

Drenaje

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

4,800.00

4,800.00

Vehiculo

120,000.00

120,000.00

Plantacion

317,300.00

317,300.00

Imprevistos

115,420.00

115,420.00

Depreciacion y Amortizacion Acumulada

188,564.00

377,128.00

Activos No Corrientes Terrenos

Pozo y bomba de riego Construcciones

1er Escenario

Bombas de fumigacion

Total Activos No Corrientes TOTAL ACTIVOS

1,657,056.00 1,468,492.00 ###

###

PASIVOS Pasivos Corrientes Prestamos por Pagar Total Pasivos Corrientes Pasivos No Corrientes Prestamos por Pagar Total Pasivos No Corrientes TOTAL PASIVOS PATRIMONIO Capital

1,845,620.00 1,860,250.00

Aumentos a Capital

14,630.00

2,926.00

Utilidad del Periodo

196,420.17

290,071.25

Utilidad Acumulada TOTAL PATRIMONIO

196,420.17 2,056,670.17 2,349,667.42

Total Pasivo Mas Capital

###

###

0.00

0.00

Ano 1

Ano 2

ACTIVOS Activos Corrientes Caja y Bancos

1,050,010.66 1,310,406.46

Activos No Corrientes Terrenos

576,000.00

576,000.00

Cercado

26,500.00

26,500.00

Drenaje

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

4,800.00

4,800.00

Vehiculo

120,000.00

120,000.00

Plantacion

317,300.00

317,300.00

Imprevistos

115,420.00

115,420.00

Depreciacion y Amortizacion Acumulada

188,564.00

377,128.00

Pozo y bomba de riego Construcciones

2do Escenario

Bombas de fumigacion

Total Activos No Corrientes TOTAL ACTIVOS

1,657,056.00 1,468,492.00 ###

###

Prestamos por Pagar

738,248.00

597,490.82

Total Pasivos NoCorrientes

738,248.00

597,490.82

TOTAL PASIVOS

738,248.00

597,490.82

PASIVOS Pasivos Corrientes Prestamos por Pagar Total Pasivos Corrientes Pasivos No Corrientes

PATRIMONIO Capital

1,845,620.00 1,860,250.00

Aumentos a Capital

14,630.00

2,926.00

Utilidad del Periodo

108,568.66

209,662.99

Utilidad Acumulada

108,568.66

TOTAL PATRIMONIO

Total Pasivo Mas Capital

1,968,818.66 2,181,407.65 ###

###

0.00

0.00

Ano 1

Ano 2

ACTIVOS Activos Corrientes Caja y Bancos

1,862,472.39 1,846,411.38

Activos No Corrientes Terrenos

576,000.00

576,000.00

Cercado

26,500.00

26,500.00

Drenaje

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

4,800.00

4,800.00

Vehiculo

120,000.00

120,000.00

Plantacion

317,300.00

317,300.00

Imprevistos

115,420.00

115,420.00

Depreciacion y Amortizacion Acumulada

188,564.00

377,128.00

Pozo y bomba de riego Construcciones

3er Escenario

Bombas de fumigacion

Total Activos No Corrientes TOTAL ACTIVOS

1,657,056.00 1,468,492.00 ###

###

PASIVOS Pasivos Corrientes Prestamos por Pagar Total Pasivos Corrientes Pasivos No Corrientes Prestamos por Pagar

1,661,058.00 1,344,354.34

Total Pasivos No Corrientes

1,661,058.00 1,344,354.34

TOTAL PASIVOS

1,661,058.00 1,344,354.34

PATRIMONIO Capital

1,845,620.00 1,860,250.00

Aumentos a Capital

14,630.00

2,926.00

Utilidad del Periodo

-1,779.61

109,152.66

Utilidad Acumulada TOTAL PATRIMONIO

Total Pasivo Mas Capital

-1,779.61 1,858,470.39 1,970,549.05 ###

###

0.00

0.00

Balance General Ano 3

Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,522,154.96 2,280,016.57 3,178,136.66 4,149,599.28 5,384,743.11 6,862,253.61 576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

4,800.00

4,800.00

4,800.00

16,744.00

16,744.00

16,744.00

120,000.00

120,000.00

120,000.00

169,765.00

169,765.00

169,765.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

565,692.00

754,256.00

942,820.00 1,020,521.80 1,098,223.60 1,175,925.40

1,279,928.00 1,091,364.00 2,802,082.96

###

902,800.00

886,807.20

809,105.40

731,403.60

###

###

###

###

1,863,176.00 1,866,687.20 1,870,900.64 1,875,956.77 1,882,024.13 1,889,304.96 3,511.20

4,213.44

5,056.13

6,067.36

7,280.83

8,737.00

448,904.34

565,084.17

704,499.97

486,491.42

935,395.76 1,500,479.93 2,204,979.89 3,154,382.35 4,304,543.55

949,402.46 1,150,161.20 1,391,071.70

2,802,082.96 3,371,380.57 4,080,936.66 5,036,406.48 6,193,848.51 7,593,657.21

2,802,082.96

###

###

###

###

###

0.00

0.00

0.00

0.00

0.00

0.00

Ano 3

Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,722,455.34 2,242,193.10 2,891,305.59 3,862,768.21 5,097,912.04 6,575,422.54 576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

4,800.00

4,800.00

4,800.00

16,744.00

16,744.00

16,744.00

120,000.00

120,000.00

120,000.00

169,765.00

169,765.00

169,765.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

565,692.00

754,256.00

942,820.00 1,020,521.80 1,098,223.60 1,175,925.40

1,279,928.00 1,091,364.00

902,800.00

886,807.20

809,105.40

731,403.60

###

###

###

3,002,383.34

###

###

430,849.55

233,564.34

0.00

430,849.55

233,564.34

0.00

430,849.55

233,564.34

0.00

1,863,176.00 1,866,687.20 1,870,900.64 1,875,956.77 1,882,024.13 1,889,304.96 3,511.20

4,213.44

5,056.13

6,067.36

7,280.83

8,737.00

386,614.94

524,245.54

689,056.70

318,231.65

704,846.58 1,229,092.12 1,918,148.82 2,867,551.28 4,017,712.48

949,402.46 1,150,161.20 1,391,071.70

2,571,533.78 3,099,992.76 3,794,105.59 4,749,575.41 5,907,017.44 7,306,826.14 3,002,383.34

###

###

###

###

###

0.00

0.00

0.00

0.00

0.00

0.00

Ano 3

Ano 4

Ano 5

Ano 6

Ano 7

Ano 8

1,972,296.92 2,194,379.86 2,532,232.88 3,503,695.50 4,738,839.32 6,216,349.82 576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

576,000.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

26,500.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

32,000.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

554,400.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

99,200.00

4,800.00

4,800.00

4,800.00

16,744.00

16,744.00

16,744.00

120,000.00

120,000.00

120,000.00

169,765.00

169,765.00

169,765.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

317,300.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

115,420.00

565,692.00

754,256.00

942,820.00 1,020,521.80 1,098,223.60 1,175,925.40

1,279,928.00 1,091,364.00

902,800.00

886,807.20

809,105.40

731,403.60

###

###

###

3,252,224.92

###

###

969,411.49

525,519.75

0.00

969,411.49

525,519.75

0.00

969,411.49

525,519.75

0.00

1,863,176.00 1,866,687.20 1,870,900.64 1,875,956.77 1,882,024.13 1,889,304.96 3,511.20

4,213.44

5,056.13

308,753.18

473,197.24

669,752.64

6,067.36

7,280.83

8,737.00

949,402.46 1,150,161.20 1,391,071.70

107,373.05

416,126.23

889,323.46 1,559,076.11 2,508,478.57 3,658,639.76

2,282,813.43 2,760,224.10 3,435,032.88 4,390,502.70 5,547,944.72 6,947,753.42 3,252,224.92

###

###

###

###

###

0.00

0.00

0.00

0.00

0.00

0.00

Ano 9

Ano 10

8,630,604.09 12,616,693.77 576,000.00

576,000.00

26,500.00

26,500.00

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

16,744.00

16,744.00

169,765.00

169,765.00

317,300.00

317,300.00

115,420.00

115,420.00

1,253,627.20

1,331,329.00

653,701.80

576,000.00

9,284,305.89

###

1,898,041.96

1,908,526.36

10,484.40

12,581.28

1,680,164.28

3,895,806.60

5,695,615.25

7,375,779.53

9,284,305.89 13,192,693.77

9,284,305.89

###

0.00

0.00

Ano 9

Ano 10

8,343,773.02 12,329,862.70 576,000.00

576,000.00

26,500.00

26,500.00

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

16,744.00

16,744.00

169,765.00

169,765.00

317,300.00

317,300.00

115,420.00

115,420.00

1,253,627.20

1,331,329.00

653,701.80

576,000.00

8,997,474.82

###

0.00 0.00 1,898,041.96

1,908,526.36

10,484.40

12,581.28

1,680,164.28

3,895,806.60

5,408,784.18

7,088,948.46

8,997,474.82 12,905,862.70 8,997,474.82

###

0.00

0.00

Ano 9

Ano 10

7,984,700.30 11,970,789.98 576,000.00

576,000.00

26,500.00

26,500.00

32,000.00

32,000.00

554,400.00

554,400.00

99,200.00

99,200.00

16,744.00

16,744.00

169,765.00

169,765.00

317,300.00

317,300.00

115,420.00

115,420.00

1,253,627.20

1,331,329.00

653,701.80

576,000.00

8,638,402.10

###

1,898,041.96

1,908,526.36

10,484.40

12,581.28

1,680,164.28

3,895,806.60

5,049,711.46

6,729,875.74

8,638,402.10 12,546,789.98 8,638,402.10

###

0.00

0.00

Escenario 1 0 1 2 3 4 5 6 7 8 9 10

Escenario 2 CCPP Propios Financiamiento

1845620.00 384,984.17 478,635.25 637,468.34 753,648.17 893,063.97 965,395.26 1,227,863.00 1,468,773.50 1,757,866.08 3,973,508.40

60% 40%

0 1 2 3 4 5 6 7 8 9 10

Escenario 3 CCPP Propios Financiamiento

1845620.00 297,132.66 257,469.80 408,537.67 515,524.32 644,056.37 965,395.26 1,227,863.00 1,468,773.50 1,757,866.08 3,973,508.40

10% 90%

0 1 2 3 4 5 6 7

1845620.00 186,784.39 -18,987.01 122,374.33 217,869.50 332,796.89 965,395.26 1,227,863.00

36% VNA 76,665.00

36% 12%

21.600% 5% 26.36%

26.36% VNA 454,212.61

36% 12%

4% 11% 14.31%

14.31% VNA 1,671,915.97

8 9 10

1,468,773.50 1,757,866.08 3,973,508.40

PRI 283,076.60 258,777.71 253,420.59 220,299.25 191,949.96 152,570.90 142,684.75 125,499.95 110,442.34 183,562.96

283,076.60 541,854.30 795,274.89 1,015,574.14 1,207,524.10 1,360,095.00 1,502,779.75 1,628,279.70 1,738,722.04 1,922,285.00

TIR 9.58 -1,845,620.00 384,984.17 478,635.25 637,468.34 753,648.17 893,063.97 965,395.26 1,227,863.00 1,468,773.50 1,757,866.08 3,973,508.40

PRI 235,147.72 161,252.73 202,489.85 202,213.75 199,929.00 237,163.29 238,716.58 225,984.10 214,042.11 382,893.47

235,147.72 396,400.45 598,890.30 801,104.05 1,001,033.05 1,238,196.34 1,476,912.92 1,702,897.02 1,916,939.14 2,299,832.61

TIR 8.67 -1,845,620.00 297,132.66 257,469.80 408,537.67 515,524.32 644,056.37 965,395.26 1,227,863.00 1,468,773.50 1,757,866.08 3,973,508.40

PRI 163,401.62 163,401.62 -14,530.75 148,870.87 81,929.00 230,799.87 127,602.61 358,402.48 170,513.25 528,915.73 432,712.87 961,628.60 481,460.14 1,443,088.74

TIR 7.80 -1,845,620.00 186,784.39 -18,987.01 122,374.33 217,869.50 332,796.89 965,395.26

37.18%

31.28%

24.73%

503,826.53 1,946,915.26 527,506.44 2,474,421.70 1,043,114.27 3,517,535.97

1,227,863.00 1,468,773.50 1,757,866.08 3,973,508.40