proyecto - hacienda san patricio - 2
Post on 14-Dec-2015
28 Views
Preview:
DESCRIPTION
TRANSCRIPT
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%
PRESTAMO DE CAPITAL 40/60 1
51%TASA 17%NPER 4PRESTAMO $ -117,658.28
Costo de TerrenoValor Contable
Deuda de capitalInversion inicial
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%
PRESTAMO DE CAPITAL 10/90 1
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.
Deuda de capitalInversion inicial
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
C$ 31,934.52 C$ 65,590.53 C$ 33,496.87 Costo de Oportunidad
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
C$ 378,168.71 C$ 501,918.37 C$ 586,431.47 Costo de Oportunidad
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
top related