proyecto - hacienda san patricio - 2

Proyecto: Plantacion de Platanos

ManzanasArea de Produccion $ 66,000.00 33Area de Barreras RV $ 6,000.00 3Porcentaje de desperdicio 5%

36%

% Valor Remante 1%% Valor Remante Amortización 0%Numero de Periodos 10.00 Horizonte de planeacionPorcentaje de Inflacion 20%Porcentaje de Imprevistos 10%% Capital Trabajo 10%

Inversiones AñosCercado C$ 26,500.00 5Drenajes C$ 32,000.00 5Pozo y Bomba de Riego C$ 554,400.00 10Construcciones C$ 99,200.00 10Bombas de Fumigacion C$ 4,800.00 5Vehiculo(camion) C$ 120,000.00 5Plantacion

Semilla C$ 171,000.00 5MO e Insumos C$ 146,300.00 5Subtotal C$ 1,154,200.00 Imprevisto C$ 115,420.00 5Total de Inversiones C$ 1,269,620.00

Reparacion de camion C$ 49,765.00 5Reposicion de Bomba C$ 11,944.00 5

10%FinanciamientoTasa 17% x DollarPeriodo 5% añosAño de Gracia 1 ISR 40%Devaluación 20%Tasa de Cambio Actual C$ 8.00 Cordobas x Dollar

Costo de Oportunidad/Costo de Capital

% capital de trabajo Anual / Ingreso por Ventas

Costo de Oportunidad 36%

Año 0 1IngresosProducción/Manzana 1080Desperdicio 54Produccion Racimos 33,858.00 Platano por racimo 25.00 Total produccion Platano/mi 846.45 P. Venta/mi C$ 785.00 Ingreso por Venta C$ 664,463.25

Ingreso Total C$ 664,463.25

CostosCosto Variable de Producción C$ 42,435.00 Gastos por Comercialización C$ 12,000.00 Gastos Administrativos C$ 140,864.00

Depreciación y Amortización C$ 187,543.80 Costo Total C$ 382,842.80

UAII C$ 281,620.45 InteresesUAI C$ 281,620.45 ISR C$ 112,648.18 Utilidad neta C$ 168,972.27 DepreciaciónPozo y Bomba de Riego C$ 54,885.60 Construcciones C$ 9,820.80 Cercado C$ 5,247.00

Drenajes C$ 6,336.00 Bombas de Fumigacion C$ 950.40 Vehiculo(camion) C$ 23,760.00 Repocicion de BombaReparacion de camionAmortizaciónSemilla C$ 34,200.00

Venta de TerrenoValor Comercial

Venta de TerrenoValor Comercial

Costo de TerrenoValor Contable

MO e Insumos C$ 29,260.00 Imprevisto C$ 23,084.00

Total Depreciación + Amortización C$ 187,543.80

Inversion InicialInversión Inicial -C$ 1,269,620.00 ReinversiónCapital de Trabajo -C$ 14,630.00

Recuperación del Capital de TrabajoTerreno -C$ 576,000.00

Total Inversion inicial -C$ 1,845,620.00 -C$ 14,630.00

FEO -C$ 1,845,620.00 C$ 341,886.07 VPN -C$ 120,795.63 TIR 34.13%

PRESTAMO DE CAPITAL 100/0 1

0%TASA 17%NPER 4PRESTAMO $ - CUOTA DE PRESTAMO $ - INTERESES $ - ABONO A CAPITAL $ - EFECTO FISCAL $ -

FLUJOS DE INVERSIONISTA -C$ 1,845,620.00 C$ 341,886.07 VPN -C$ 120,795.63 36%TIR 34.13%


51%TASA 17%NPER 4PRESTAMO $ -117,658.28

Costo de TerrenoValor Contable

Deuda de capitalInversion inicial


CUOTA DE PRESTAMO $ - INTERESES $ 20,001.91 ABONO A CAPITAL $ - EFECTO FISCAL $ 8,000.76

FLUJOS DE INVERSIONISTA -C$ 904,353.80 C$ 226,675.09 VPN -C$ 40,246.85 26.31%


30%TASA 8%NPER 20PRESTAMO $ -69,210.75 CUOTA DE PRESTAMO $ - INTERESES $ 5,536.86 ABONO A CAPITAL $ - EFECTO FISCAL $ 2,214.74

FLUJOS DE INVERSIONISTA -C$ 1,291,934.00 C$ 309,993.76 VPN C$ 307,205.87 27.60%

R// Recomendamos tomar el préstamo en el cual el banco nos financia el 90% del mismo, al inertir menos nos da un beneficio mayor en cuanto al VPN.


Precio xManzana $ 2,000.00 $ 2,000.00

Depreciación C$ 5,247.00 C$ 6,336.00 C$ 54,885.60 C$ 9,820.80 C$ 950.40 C$ 23,760.00

C$ 34,200.00 C$ 29,260.00

C$ 23,084.00

C$ 9,853.47 L9,953.00 C$ 2,364.91

1 2 3 C$ 9.60 C$ 11.52 C$ 13.82

2 3 4

1300 1400 140065 70 70

40,755.00 43,890.00 43,890.00 30 30 30

1,222.65 1,316.70 1,316.70 C$ 942.00 C$ 1,130.40 C$ 1,356.48 C$ 1,151,736.30 C$ 1,488,397.68 C$ 1,786,077.22

C$ 1,151,736.30 C$ 1,488,397.68 C$ 1,786,077.22

C$ 365,348.00 C$ 438,417.60 C$ 526,101.12 C$ 14,400.00 C$ 17,280.00 C$ 20,736.00 C$ 169,036.80 C$ 202,844.16 C$ 243,412.99

C$ 187,543.80 C$ 187,543.80 C$ 187,543.80 C$ 736,328.60 C$ 846,085.56 C$ 977,793.91

C$ 415,407.70 C$ 642,312.12 C$ 808,283.30

C$ 415,407.70 C$ 642,312.12 C$ 808,283.30 C$ 166,163.08 C$ 256,924.85 C$ 323,313.32 C$ 249,244.62 C$ 385,387.27 C$ 484,969.98

C$ 54,885.60 C$ 54,885.60 C$ 54,885.60 C$ 9,820.80 C$ 9,820.80 C$ 9,820.80 C$ 5,247.00 C$ 5,247.00 C$ 5,247.00

C$ 6,336.00 C$ 6,336.00 C$ 6,336.00 C$ 950.40 C$ 950.40 C$ 950.40 C$ 23,760.00 C$ 23,760.00 C$ 23,760.00

C$ 34,200.00 C$ 34,200.00 C$ 34,200.00

C$ 29,260.00 C$ 29,260.00 C$ 29,260.00 C$ 23,084.00 C$ 23,084.00 C$ 23,084.00

C$ 187,543.80 C$ 187,543.80 C$ 187,543.80

-C$ 2,926.00 -C$ 3,511.20 -C$ 4,213.44

-C$ 2,926.00 -C$ 3,511.20 -C$ 4,213.44

C$ 433,862.42 C$ 569,419.87 C$ 668,300.34

2 3 4

$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

C$ 433,862.42 C$ 569,419.87 C$ 668,300.34 Costo de Oportunidad

2 3 4

$ 42,890.34 $ 42,890.34 $ 42,890.34 $ 20,001.91 $ 16,110.87 $ 11,558.36 $ 22,888.43 $ 26,779.46 $ 31,331.97 $ 8,000.76 $ 6,444.35 $ 4,623.35


2 3 4

$ 7,049.27 $ 7,049.27 $ 7,049.27 $ 5,536.86 $ 5,415.87 $ 5,285.20 $ 1,512.41 $ 1,633.40 $ 1,764.07 $ 2,214.74 $ 2,166.35 $ 2,114.08


R// Recomendamos tomar el préstamo en el cual el banco nos financia el 90% del mismo, al inertir menos nos da un beneficio mayor en cuanto al VPN.

4 5 6 7 C$ 16.59 C$ 19.91 C$ 23.89 C$ 28.67

5 6 7 8

1400 1400 1400 140070 70 70 70

43,890.00 43,890.00 43,890.00 43,890.00 30 30 30 30

1,316.70 1,316.70 1,316.70 1,316.70 C$ 1,627.78 C$ 1,953.33 C$ 2,344.00 C$ 2,812.80 C$ 2,143,292.66 C$ 2,571,951.19 C$ 3,086,341.43 C$ 3,703,609.72

C$ 2,143,292.66 C$ 2,571,951.19 C$ 3,086,341.43 C$ 3,703,609.72

C$ 631,321.34 C$ 757,585.61 C$ 909,102.74 C$ 1,090,923.28 C$ 24,883.20 C$ 29,859.84 C$ 35,831.81 C$ 42,998.17 C$ 292,095.59 C$ 350,514.71 C$ 420,617.65 C$ 504,741.18

C$ 187,543.80 C$ 76,924.78 C$ 76,924.78 C$ 76,924.78 C$ 1,135,843.93 C$ 1,214,884.94 C$ 1,442,476.98 C$ 1,715,587.41

C$ 1,007,448.72 C$ 1,357,066.25 C$ 1,643,864.45 C$ 1,988,022.30

C$ 1,007,448.72 C$ 1,357,066.25 C$ 1,643,864.45 C$ 1,988,022.30 C$ 402,979.49 C$ 542,826.50 C$ 657,545.78 C$ 795,208.92 C$ 604,469.23 C$ 814,239.75 C$ 986,318.67 C$ 1,192,813.38

C$ 54,885.60 C$ 54,885.60 C$ 54,885.60 C$ 54,885.60 C$ 9,820.80 C$ 9,820.80 C$ 9,820.80 C$ 9,820.80 C$ 5,247.00

C$ 6,336.00 C$ 950.40 C$ 23,760.00

C$ 2,364.91 C$ 2,364.91 C$ 2,364.91 C$ 9,853.47 C$ 9,853.47 C$ 9,853.47

C$ 34,200.00

C$ 29,260.00 C$ 23,084.00

C$ 187,543.80 C$ 76,924.78 C$ 76,924.78 C$ 76,924.78

-C$ 61,709.00 -C$ 5,056.13 -C$ 6,067.35 -C$ 7,280.82 -C$ 8,736.99

-C$ 66,765.13 -C$ 6,067.35 -C$ 7,280.82 -C$ 8,736.99

C$ 725,247.91 C$ 885,097.18 C$ 1,055,962.63 C$ 1,261,001.17

5 6 7 8

$ - $ - $ - $ -

C$ 725,247.91 C$ 885,097.18 C$ 1,055,962.63 C$ 1,261,001.17

5 6 7 8

$ 42,890.34 $ 6,231.93 $ 36,658.41 $ 2,492.77

-C$ 78,928.66 C$ 885,097.18 C$ 1,055,962.63 C$ 1,261,001.17

5 6 7 8

$ 7,049.27 $ 5,144.07 $ 1,905.20 $ 2,057.63

C$ 625,881.53 C$ 885,097.18 C$ 1,055,962.63 C$ 1,261,001.17

8 9 10 C$ 34.40 C$ 41.28 C$ 49.53

9 10

1400 140070 70

43,890.00 43,890.00 30 30

1,316.70 1,316.70 C$ 3,375.36 C$ 4,050.43 C$ 4,444,331.66 C$ 5,333,197.99

C$ 3,566,440.18

C$ 4,444,331.66 C$ 8,899,638.17

C$ 1,309,107.94 C$ 1,570,929.53 C$ 51,597.80 C$ 61,917.36 C$ 605,689.42 C$ 726,827.30

C$ 576,000.00 C$ 76,924.78 C$ 76,924.78 C$ 2,043,319.94 C$ 3,012,598.97

C$ 2,401,011.72 C$ 5,887,039.20

C$ 2,401,011.72 C$ 5,887,039.20 C$ 960,404.69 C$ 2,354,815.68 C$ 1,440,607.03 C$ 3,532,223.52

C$ 54,885.60 C$ 54,885.60 C$ 9,820.80 C$ 9,820.80

C$ 2,364.91 C$ 2,364.91 C$ 9,853.47 C$ 9,853.47

C$ 76,924.78 C$ 76,924.78

C$ 576,000.00

-C$ 10,484.39 -C$ 12,581.26

C$ 75,487.59

-C$ 10,484.39 C$ 62,906.32

C$ 1,507,047.43 C$ 4,248,054.62

9 10

C$ 1,507,047.43 C$ 4,248,054.62

9 10

C$ 1,507,047.43 C$ 4,248,054.62

9 10

C$ 1,507,047.43 C$ 4,248,054.62

proyecto - hacienda san patricio - 2

Documents