tara ingresos egresos 30 has van y tmar sin color 10 de abril (1)

Click here to load reader

Post on 23-Oct-2014

28 views

Category:

Documents

2 download

Embed Size (px)

TRANSCRIPT

PROYECTO DE TARA:PRODUCCION E INGRESOSParametros Iniciales Has. De Tara Has. De Maracuy rendimiento/mes de maracuya US $/Ha porcentaje de la inversin en participacin por el propietario costo de la tarea Informacin Requerida Has. Fundo Quintal (01) en Kgr. Precio Quintal n.s. Tipo de Cambio ( S/.) Plantas de Tara x Hectarea iniciales Plantas de Tara x Hectarea despues de 02 aos Rendimiento Kgr./Arbol Tara N de Cosechas Tara N de Cosechas Maracuya INGRESOS X PRODUCCION DE TARA Fundo (area) (has.) Rendimiento x Arbol (kg/rbol) Plantas x Ha.(arboles/ha) Rendimiento x ha. (kg/ha.) No. De cosechas/ao Rendi. Fundo (kg/ao) Rend.Fundo (quintales/ao/ha) precio/quintal n.s. Ingresos brutos fundo/ao ( por tara) (US $) tipo de cambio dlar/soles ingresos brutos fundo ($/mes) PRODUCCION DE MARACUYA Fundo (area) (has.) No. De cosechas/ao ingresos brutos fundo ($/Ha) ingresos brutos fundo ($/Ao) ingresos brutosfundo ($/mes) INVERSION SOLO CAMPO DE MARACUYA INVERSION EXTERNA TOTAL US $ Inversin Inicial Infraestructura instalacion campo de maracuya Equipos Costo de Operacin Costo de Operacin (Costo de mantenimiento campos) Gastos administrativos gastos de personal INVERSION DEL PROPIETARIO US $ % de la Inversin Global INVERSION REQUERIDA US $ AO 1 267,900 210,045 52,750 98,080 59,214 57,855 41,655 16,200 0 133,950 50% 133,950 AO 2 57,855 TOTAL 325,755 210,045 52,750 98,080 59,214 115,710 83,310 32,400 0 162,878 1 0 162,878 30 46 100 2.80 625 800

30 30 3,000 50% 25 AO 1 AO 2 AO 3 AO 4 AO 5

625 0 1 1 AO 1 30 625 100 2.80 AO2

625 10 1 6

800 15 2 6 AO 3 30 15 800 12,000 2 720,000 15,652 100 559,006 2.80 46,584 AO 4

800 20 2 6

800 25 2 6 AO 5 30 25 800 20,000 2 1,200,000 26,087 100 931,677 2.80 77,640

30 10 800 8,000 1 240,000 5,217 100 186,335 2.80 15,528

30 20 800 16,000 2 960,000 20,870 100 745,342 2.80 62,112

No de sacos 26,087

30 1 3,000 90,000 18,000

30 6 18,000 540,000 45,000

30 6 18,000 540,000 45,000

30 6 18,000 540,000 45,000

30 6 18,000 540,000 45,000

INVERSION SOLO CAMPO DE MARACUYA325,755 Capital en prestamo $ tasa de interes/mes numero de periodos cuota/mes $ costo total $ costo financiero $ 501,000 2% 12 47,374 568,492 67,492 501,000 2% 24 26,488 635,722 134,722

57,855 41,655 16,200 0 28,928 50% 28,928

Para 5 aos 501,000 2% 36 19,656 707,604 206,604

501,000 2% 48 16,334 784,009 283,009

501,000 2% 60 14,413 864,765 363,765

563,000 2% 12 53,237 638,845 75,845

para 3 aos 563,000 2% 24 29,766 714,394 151,394

563,000 2% 36 22,088 795,171 232,171 4,299.17 14,331

SOLO CAMPO DE MARACUYACONCEPTO Ingreso Financiero Ingresos x vtas (maracuya) Inversion conjunta (propietario + inversion.) EGRESOS Costos de Infraestructura y Equipos Infraestructura Equipo Costos de Produccin Costo de Plantacin Maracuy Costo de Operacin Maracuy Gastos Personal Tcnico Gastos Administrativos Depreciacin pago de la inversion (cuota/mes) Saldo (Ingre.-Egre) antes de impuestos Impuesto a la renta (30 %) Saldo (ingre-Egre)despues de Impuestos Mes 0 501,000 0 267,900 240,714 111,964 52,750 59,214 128,750 98,080 3,471 7,733 1,350 3,702 14,413 260,286 260,286 Mes 1 260,286 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 229,616 229,616

PAGOS EN 5 AOSMes 2 229,616 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 198,947 198,947 AO 1 Mes 3 198,947 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 168,278 168,278 Mes 4 168,278 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 137,608 137,608 Mes 5 137,608 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 106,939 106,939 Mes 6 106,939 0 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 76,269 76,269 Mes 7 94,269 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 63,600 63,600 Mes 8 81,600 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 50,930 50,930 Mes 9 68,930 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 38,261 38,261 0 Mes 10 56,261 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 25,592 25,592 Mes 11 43,592 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 12,922 12,922 Mes 12 30,922 18,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 253 253 Mes 13 45,253 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 14,583 4,299 10,284

466,050

Mes 14 55,284 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 24,615 4,299 20,316

Mes 15 65,316 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 34,646 4,299 30,347

Mes 16 75,347 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 44,678 4,299 40,378

Mes 17 85,378 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 54,709 4,299 50,410

Mes 18 95,410 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 64,740 4,299 60,441

Mes 19 105,441 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 74,772 4,299 70,473

Mes 20 115,473 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 84,803 4,299 80,504

Mes 21 125,504 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 94,835 4,299 90,535

Mes 22 135,535 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 104,866 4,299 100,567

Mes 23 145,567 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 114,897 4,299 110,598

Mes 24 155,598 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 124,929 4,299 120,630

Mes 25 165,630 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 134,960 4,299 130,661

Mes 26 175,661 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 144,992 4,299 140,692

Mes 27 185,692 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 155,023 4,299 150,724

Mes 28 195,724 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 165,054 4,299 160,755

Mes 29 205,755 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 175,086 4,299 170,787

Mes 30 215,787 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 185,117 4,299 180,818

Mes 31 225,818 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 195,149 4,299 190,849

Mes 32 235,849 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 205,180 4,299 200,881

Mes 33 245,881 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 215,211 4,299 210,912

Mes 34 255,912 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 225,243 4,299 220,944

Mes 35 265,944 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 235,274 4,299 230,975

Mes 36 275,975 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 245,306 4,299 241,006

Mes 37 286,006 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 255,337 4,299 251,038

Mes 38 296,038 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 265,368 4,299 261,069

Mes 39 306,069 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 275,400 4,299 271,101

Mes 40 316,101 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 285,431 4,299 281,132

Mes 41 326,132 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 295,463 4,299 291,163

Mes 42 336,163 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 305,494 4,299 301,195

Mes 43 346,195 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 315,525 4,299 311,226

Mes 44 356,226 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 325,557 4,299 321,258

Mes 45 366,258 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 335,588 4,299 331,289

Mes 46 376,289 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 345,620 4,299 341,320

Mes 47 386,320 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 355,651 4,299 351,352

Mes 48 396,352 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 365,682 4,299 361,383

Mes 49 406,383 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 375,714 4,299 371,415

Mes 50 416,415 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 385,745 4,299 381,446

Mes 51 426,446 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 395,777 4,299 391,477

Mes 52 436,477 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 405,808 4,299 401,509

Mes 53 446,509 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 415,839 4,299 411,540

Mes 54 456,540 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 425,871 4,299 421,572

Mes 55 466,572 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 435,902 4,299 431,603

Mes 56 476,603 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 445,934 4,299 441,634

Mes 57 486,634 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 455,965 4,299 451,666

Mes 58 496,666 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 465,996 4,299 461,697

Mes 59 506,697 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 476,028 4,299 471,729

Mes 60 516,729 45,000 0 30,669 0 0 0 30,669 0 3,471 7,733 1,350 3,702 14,413 486,059 4,299 481,760

SOLO CAMPO DE MARACUYACONCEPTO Ingreso Financiero Ingresos x vtas (maracuya) Inversion conjunta (propietario + inversion.) EGRESOS Costos de Infraestructura y Equipos Infraestructura Equipo Costos de Produccin Costo de Plantacin Maracuy Costo de Operacin Maracuy Gastos Personal Tcnico Gastos Administrativos Depreciacin pago de la inversion (cuota/mes) Saldo (Ingre.-Egre) antes de impuestos Impuesto a la renta (30 %) Saldo (ingre-Egre)despues de Impuestos Mes 13 45,253 45,000 30,669 30,669 3,471 7,733 1,350 3,702 14,413 14,583 4,299