Analisis Tecnico y Financiero de Cacao
Analisis Tecnico y Financiero de Cacao
Analisis Tecnico y Financiero de Cacao
Estadsticas de la regresin
Coeficiente de correlacin mltiple 0.6124822
Coeficiente de determinacin R^2 0.37513445
R^2 ajustado 0.16684593
Error tpico 72.575478
Observaciones 5
ANLISIS DE VARIANZA
Grados de libertad
Suma de cuadrados
Promedio de los cuadradosF Valor crtico de F
Regresin 1 9486.4 9486.4 1.80103281 0.27211792
Residuos 3 15801.6 5267.2
Total 4 25288
Poblacion
Poblacion Inicial
Final
n AO PI (1+0.0037)
PF
(Hab)
(Hab)
0 2014 60,795,612.00 1.0000 60,795,612
1 2015 60,795,612.00 1.0037 61,020,556
2 2016 60,795,612.00 1.0074 61,246,332
DEMANDA FUTURA
Poblacion
Poblacion Inicial
Final
n AO PI (1+0.0037)
PF
(Hab)
(Hab)
3 2017 60,795,612.00 1.0111 61,472,943
4 2018 60,795,612.00 1.0149 61,700,393
5 2019 60,795,612.00 1.0186 61,928,685
6 2020 60,795,612.00 1.0224 62,157,821
7 2021 60,795,612.00 1.0262 62,387,805
Poblacion Consumo
potencialmente promedio x Total Total Consumo
AO
demandante hab. (Kg) ( TM)
(Hab) Kg. /hab
2017 61,472,943 2.2 135,240,475 135,240.5
2018 61,700,393 2.2 135,740,865 135,740.9
2019 61,928,685 2.2 136,243,106 136,243.1
2020 62,157,821 2.2 136,747,206 136,747.2
2021 62,387,805 2.2 137,253,170 137,253.2
HISTORICO DE OFERTA DE CACAO
OFERTA DE
AO CACAO
(TM)
700.00
2011 418.00
2012 448.00 600.00
2013 618.00
f(x) = 30.8x
2014 500.00 500.00
2015 546.00
418.00
400.00
300.00
a 30.8 31
b 413.6 414
Y = 31 X + 414
700.00
660.00
650.00
629.20
600.00
550.00
2017 2018 20
OFERTA HISTORICA DE CACAO
700.00
618.00
600.00
f(x) = 30.8x + 413.6 546.00
500.00 500.00
448.00
418.00
400.00
300.00
200.00
100.00
0.00
2011 2012 2013 2014 2015
752.40
721.60
690.80
660.00
VEHICULOS
VALOR
TOTAL
DESCRIPCION CANTIDAD UNITARIO
S/.
S/.
Montacarga 1 50,000.00 50,000.00
Camion de 5 TM 1 120,000.00 120,000.00
TOTAL VEHICULOS 170,000.00
MUEBLES Y ENSERES
VALOR
TOTAL
DESCRIPCION CANTIDAD UNITARIO
S/.
S/.
Mesa de trabajo 2 2,500.0 5,000.00
Escritorio completo 4 400 1,600.00
Escritorios de madera 2 250 500.00
Sillones metlicos 4 120 480.00
Sillas de madera 10 50 500.00
Armarios 2 250 500.00
TOTAL MUEBLES Y ENSERES 8,580.00
INVERSION FIJA INTANGIBLE
DESCRIPCION TOTAL
Elaboracin ExpedienteTcnico de edificacin 25,000.00
Consultoria para el fortalecimiento organizacional 30,000.00
Capacitacion pre operacin (pruebas en vacio, manejo de
equipos, etc) 5,000.00
Licencia Municipal 250.00
Certificado Defensa Civil 200.00
Registro sanitario 3,000.00
Gestion de certificacion HACCP 30,000.00
Habilitacion Sanitaria de Planta 200.00
Constitucin y tramites de Sunat 2,500.00
TOTAL INVERSION FIJA INTANGIBLE 96,150.00
2 3 4 5
14,839.78 16,323.76 17,956.13 19,751.75
14,812.46 16,293.71 17,923.08 19,715.39
27.32 30.05 33.05 36.36
APORTE AEO
APORTE TOTAL
CONCEPTO APORTE DE
PRESTAMO PROCOMPITE FINANCIAMIENTO
SOCIOS
I.INVERSION FIJA 373,350.00 - 455,670.00 829,020.00
I.1. INVERSION FIJA TANGIBLE 277,200.00 455,670.00 732,870.00
I.1.1. TERRENOS Y OBRAS CIVILES 16,000.00 447,090.00 463,090.00
I.1.2. MAQUINARIA Y EQUIPO 91,200.00 91,200.00
I.1.3. VEHICULOS 170,000.00 170,000.00
I.1.4. MUEBLES Y ENSERES 8,580.00 8,580.00
I.2. INVERSION FIJA INTANGIBLE 96,150.00 96,150.00
II. CAPITAL DE TRABAJO 173,307.08 173,307.08
III. GASTOS GENERALES ( 5 % ) IF 41,451.00 41,451.00
IV. GASTOS DE SUPERVISION (3%) IF 24,870.60 24,870.60
TOTAL INVERSIN 373,350.00 173,307.08 521,991.60 1,068,648.68
PORCENTAJE 34.94% 16.22% 48.85% 100%
PRESTAMO 173,307.08
APORTE ESTADO+SOCIOS 895,341.60
TOTAL 1,068,648.68
PRESTAMO 173,307.08
APORTE PROPIO -
PRERIODO (MESES) 60
TEA 0.2
Tim 0.01530947
CUOTA -4,435.95
CUOTA 4,435.95
ESCUDO FISCAL 0.3 DEL INTERES
COSTOS DE PRODUCCION
PRECIO
CONCEPTO UNIDAD CANTIDAD UNITARIO
S/. / Unidad
I. COSTOS DIRECTOS
Cacao Kg 149,000 7.23
Sacos de Yute de 60 Kg. unidad 2,483 0.80
Mano de Obra Directa mes 12 9,200
II. COSTOS INDIRECTOS
Mano de Obra Indirecta mes 12 9,000
Otros Costos indirectos global
TOTAL COSTOS DE PRODUCCION
GASTOS DE OPERACIN
PRECIO
CONCEPTO UNIDAD CANTIDAD UNITARIO
S/.
I. GASTOS EN VENTAS
Responsable de comercializacion global 12 1,250.00
Publicidad mes 12 650.00
II. GASTOS ADMINISTRATIVOS
Mano de obra Administrativa mes 12 9,000.00
Utiles de Oficina mes 12 50.00
TOTAL GASTOS DE OPERACIN
Costo total
6,000.00
1,800.00
1,800.00
1,800.00
11,400.00
Costo total
1,200.00
6,000.00
7,200.00
O
COSTO TOTAL
3,000.00
3,000.00
COSTO TOTAL
1,079,256.67
1,077,270.00
1,987
2 3 4 5
EMENTO DEL 10% ANUAL DE MATERIAS PRIMAS E INSUMOS, DURANTE LOS 5 AOS
DEPRECIACION DEL ACTIVO FIJO TANGIBLE Y AMORTIZACION INTANGIBLES
Factor de DEPRECIACIN
CONCEPTO
depreciacion 1 2 3
I. ACTIVO NO DEPRECIADO
I.1.1. TERRENOS 0.00 - - -
II. DEPRECIACIN DEL ACTIVO FIJO TANGIBLE 41,633.90 41,633.90 41,633.90
I.1.2. OBRAS CIVILES 0.05 18,771.19 18,771.19 18,771.19
I.1.3. MAQUINARIA Y EQUIPO 0.10 7,728.81 7,728.81 7,728.81
I.1.4. VEHICULOS 0.10 14,406.78 14,406.78 14,406.78
I.1.5. MUEBLES Y ENSERES 0.10 727.12 727.12 727.12
III. AMORTIZACIN INTANGIBLES 19,230.00 19,230.00 19,230.00
II.1.INVERSIN FIJA INTANGIBLE 0.20 19,230.00 19,230.00 19,230.00
TOTAL ( II + III) 60,863.90 60,863.90 60,863.90
CION INTANGIBLES
PRECIACIN VALOR
4 5 RESIDUAL
- - 20,090.00
41,633.90 41,633.90 504,610.51
18,771.19 18,771.19 349,144.07
7,728.81 7,728.81 52,555.93
14,406.78 14,406.78 97,966.10
727.12 727.12 4,944.41
19,230.00 19,230.00
19,230.00 19,230.00
60,863.90 60,863.90 524,700.51
COSTOS TOTALES
AOS
CONCEPTO
1 2 3 4
I. COSTOS DE PRODUCCIN 1,318,056.67 1,485,232.18 1,678,308.98 1,901,300.66
I.1. COSTOS DIRECTOS 1,189,656.67 1,356,832.18 1,549,908.98 1,772,900.66
I.1.1. MATERIALES DIRECTOS 1,079,256.67 1,246,432.18 1,439,508.98 1,662,500.66
I.1.2. MANO DE OBRA DIRECTA. 110,400.00 110,400.00 110,400.00 110,400.00
I.2. COSTOS INDIRECTOS 128,400.00 128,400.00 128,400.00 128,400.00
MANO DE OBRA INDIRECTA. 108,000.00 108,000.00 108,000.00 108,000.00
OTROS COSTOS INDIRECTOS 20,400.00 20,400.00 20,400.00 20,400.00
II. GASTOS DE OPERACIN 67,800.00 67,800.00 67,800.00 67,800.00
II.1. GASTOS DE VENTA 22,800.00 22,800.00 22,800.00 22,800.00
II.2. GASTOS ADMINISTRATIVOS 45,000.00 45,000.00 45,000.00 45,000.00
III. DEPRECIACIN DE ACT.FIJO
Y AMORTIZACION INTANG. 60,863.90 60,863.90 60,863.90 60,863.90
IV. GASTOS FINANCIEROS 53,231.37 53,231.37 53,231.37 53,231.37
PAGO DE PRESTAMO 53,231.37 53,231.37 53,231.37 53,231.37
TOTAL EGRESOS 1,499,951.93 1,667,127.45 1,860,204.25 2,083,195.93
5
2,158,842.83
2,030,442.83
1,920,042.83
110,400.00
128,400.00
108,000.00
20,400.00
67,800.00
22,800.00
45,000.00
60,863.90
53,231.37
53,231.37
2,340,738.09
PLAN DE PRODUCCION
PRODUCCION en TM
AO
Ene. Feb. Mar. Abr. May. Jun. Jul. Ago. Set.
464,284.00 1,615,708.32
561,783.64 1,955,007.07
679,758.20 2,365,558.55
822,507.43 2,862,325.85
995,233.99 3,463,414.27
INVERSION 1,068,648.68
PUNTO DE EQUILIBRIO
AOS
RUBROS
1 2 3
COSTOS FIJOS. 159,095.27 159,095.27 159,095.27
DEPRECIACIN DE A.F. Y AMORT. INTANG 60,863.90 60,863.90 60,863.90
GASTOS FINANCIEROS (Pago de prestamo) 53,231.37 53,231.37 53,231.37
GASTOS ADMINISTRATIVOS 45,000.00 45,000.00 45,000.00
COSTOS VARIABLES 1,340,856.67 1,508,032.18 1,701,108.98
COSTOS DE PRODUCCIN 1,318,056.67 1,485,232.18 1,678,308.98
GASTOS DE VENTA 22,800.00 22,800.00 22,800.00
COSTOS TOTALES 1,499,951.93 1,667,127.45 1,860,204.25
VENTAS PROMEDIO (Q) 149,000.00 163,900.00 180,290.00
COSTO VARIABLE UNITARIO (CVu) 9.00 9.20 9.44
PRECIO DE VENTA UNITARIO 10.84 11.93 13.12
PUNTO DE EQUILIBRIO (Q) 86,247 58,338 43,168
PUNTO DE EQUILIBRIO (S/.) 935,237.41 695,860.96 566,407.43
PE(Q) = CF/(Pu-Cvu)
PE (S/.) = CF/(1-CV/VENTAS)
AOS
RUBROS
1 2
VENTAS 1,615,708.3 3,570,715.4
COSTOS TOTALES
ACUMULADOS 2,568,600.62 4,235,728.07
COSTOS FIJOS 159,095.27 159,095.27
14,000,000.00
12,000,000.00
10,000,000.00
8,000,000.00
6,000,000.00
12,000,000.00
10,000,000.00
8,000,000.00
6,000,000.00
4,000,000.00
2,000,000.00
-
1 2 3
OS
CONCEPTO
4 5
2,862,325.85 3,988,114.78 I. INGRESOS (VENTAS)
2,862,325.85 3,463,414.27 VENTAS
524,700.51 INGRESOS EXTRAORDINARIOS
1,901,300.66 2,158,842.83 II. COSTOS DE PRODUCCIN
961,025.19 1,829,271.96 III. UTILIDAD BRUTA
67,800.00 67,800.00 IV. GASTOS DE OPERACIN
22,800.00 22,800.00 GASTOS DE VENTA
45,000.00 45,000.00 GASTOS ADMINISTRATIVOS
60,863.90 60,863.90 V. DEPRECIACIN DE A.F. Y AMORT. INTANG
832,361.29 1,700,608.06 VI. UTILIDAD OPERATIVA
12,988.06 4,939.39 IX. IMPUESTO A LA RENTA ( 30 % )
819,373.23 1,695,668.67 UTILIDAD NETA
245,811.97 508,700.60
573,561.26 1,186,968.07 INVERSION
OS
4 5
159,095.27 159,095.27 cf
60,863.90 60,863.90
53,231.37 53,231.37
45,000.00 45,000.00
1,924,100.66 2,181,642.83
1,901,300.66 2,158,842.83
22,800.00 22,800.00
2,083,195.93 2,340,738.09
198,319.00 218,150.90 vt
9.70 10.00
14.43 15.88
33,629 27,077
485,365.88 429,883.83
AOS
3 4 5
5,936,273.9 8,798,599.8 12,786,714.6
1,068,648.68
FLUJO DE CAJA ECONMICO Y FINANCIERO
CONCEPTO 0 1 2 3 4 5
I. INGRESOS - 1,615,708.32 1,955,007.07 2,365,558.55 2,862,325.85 4,243,783.99
INGRESOS POR VENTA 1,615,708.32 1,955,007.07 2,365,558.55 2,862,325.85 3,463,414.27
VALOR RESIDUAL 524,700.51
RECUPERO DE CAPITAL 255,669.21
II. EGRESOS (1,450,043.70) (1,670,205.26) (1,930,008.44) (2,236,765.18) (2,756,576.99)
II.1. INVERSION FIJA AO 0 (1,068,648.68)
II.1.1 INVERSION FIJA TANGIBLE 732,870.00
II.1.2 INVERSION FIJA INTANGIBLE 96,150.00
II.1.3 CAPITAL DE TRABAJO 173,307.08 (13,490.71) (14,839.78) (16,323.76) (17,956.13) (19,751.75)
II.1.4 GASTOS GENERALES 41,451.00
II.1.5 GASTOS DE SUPERVISION 24,870.60
II.2. COSTOS DE PRODUCCIN (1,318,056.67) (1,485,232.18) (1,678,308.98) (1,901,300.66) (2,158,842.83)
II.3. GASTOS DE OPERACIN (67,800.00) (67,800.00) (67,800.00) (67,800.00) (67,800.00)
II.4. IMPUESTO A LA RENTA (50,696.33) (102,333.30) (167,575.70) (249,708.39) (510,182.42)
FLUJO DE CAJA ECONMICO (1,068,648.68) 165,664.62 284,801.81 435,550.11 625,560.67 1,487,207.00
PRESTAMO 173,307.08
SERVICIO DE DEUDA (53,231.37) (53,231.37) (53,231.37) (53,231.37) (53,231.37)
ESCUDO FISCAL 8,982.72 7,585.39 5,908.58 3,896.42 1,481.82
FLUJO DE CAJA FINANCIERO (895,341.60) 121,415.97 239,155.83 388,227.33 576,225.72 1,435,457.45
ELABORACION PROPIA
FLUJO DE CAJA
CONCEPTO 0 1 2 3 4 5
NOPAT 118,291.43 238,777.69 391,009.97 582,652.90 1,190,425.64
Depreciacion 60,863.90 60,863.90 60,863.90 60,863.90 60,863.90
Recupero de CT 255,669.21
INVERSION (1,068,648.68)
Activo Fijo 732,870.00
Activo Intagi 96,150.00
Capital de t 173,307.08 (13,490.71) (14,839.78) (16,323.76) (17,956.13) (19,751.75)
Gastos Gene 41,451.00
Gastos de S 24,870.60
FLUJO DE C (1,068,648.68) 165,664.62 284,801.81 435,550.11 625,560.67 1,487,207.00
Prestamo 173,307.08
Servicio a la deuda (53,231.37) (53,231.37) (53,231.37) (53,231.37) (53,231.37)
Escudo Fiscal Tributario 8,982.72 7,585.39 5,908.58 3,896.42 1,481.82
FLUJO DE (895,341.60) 121,415.97 239,155.83 388,227.33 576,225.72 1,435,457.45
CALCULO DEL VALOR ACTUAL NETO ECONOMICO (VANE) CALCULO TASA INTERNA DE CALCULO DEL VALOR ACTUAL NETO FINANCIERO
RETORNO ECONOMICO
Flujo de caja Flujo de caja
Tasa de
Periodo (n) economico (1+r) FC / (1+r) VANE Periodo (n) financiero
descuento
(FC) (FC)
0 -1,068,648.68 1.00 -1,068,648.68 0% 1,930,135.53 0 -895,341.60
1 165,664.62 1.19 139,182.44 5% 1,403,611.26 1 121,415.97
2 284,801.81 1.42 201,025.94 10% 995,269.05 2 239,155.83
3 435,550.11 1.69 258,286.77 15% 674,210.93 3 388,227.33
4 625,560.67 2.01 311,665.07 20% 418,592.37 4 576,225.72
5 1,487,207.00 2.39 622,507.79 25% 212,715.47 5 1,435,457.45
TOTAL 464,019.32 30% 45,129.34
35% -92,634.71
40% -206,920.03
VANE = S. 464,019.32 45% -302,534.30
50% -383,161.41
55% -451,653.09
60% -510,238.02
65% -560,673.53
70% -604,356.95
TIRE = 31.53%
VALORES
5
Anual
20%
Tasa de
(1+r) FC / (1+r) VANF
descuento
1.00 -895,341.60 0% 1,865,140.69
1.20 101,179.98 5% 1,371,360.20
1.44 166,080.44 10% 989,242.99
1.73 224,668.59 15% 689,474.41
2.07 277,886.63 20% 451,352.19
2.49 576,878.15 25% 260,016.05
TOTAL 451,352.19 30% 104,638.62
35% -22,778.21
40% -128,218.12
VANF = 451,352.19 45% -216,210.59
50% -290,222.02
55% -352,932.38
60% -406,433.35
65% -452,372.13
70% -492,056.69
TIRF = 34.03%
WACC 19.03%
EVALUACION ECONOMICA
AO FCE FAS VAN
0 (1,068,648.68) 1.000000 (1,068,648.68)
1 165,664.62 1.190270 139,182.44
2 284,801.81 1.416742 201,025.94
3 435,550.11 1.686304 258,286.77
4 625,560.67 2.007157 311,665.07
5 1,487,207.00 2.389058 622,507.79
VANE 464,019.32
TIRE 31.53%
Caida de la produccion en 5 %
AO FCE FAS VAN
0 (1,068,648.68) 1.00 (1,068,648.68)
1 109,114.83 1.19 91,672.37
2 216,376.56 1.42 152,728.32
3 352,755.56 1.69 209,188.54
4 525,379.26 2.01 261,752.97
5 1,365,987.50 2.39 571,768.33
VANE 218,461.84
TIRE 25.02%
Caida de la produccion en 10 %
AO FCE FAS VAN
0 (1,068,648.68) 1.00 (1,068,648.68)
1 52,565.04 1.19 44,162.30
2 147,951.31 1.42 104,430.70
3 269,961.01 1.69 160,090.32
4 425,197.86 2.01 211,840.88
5 1,244,768.00 2.39 521,028.87
VANE (27,095.63)
TIRE 18.27%
EVALUACION FINANCIERA
AO FCF FAS VANF
0 (895,341.60) 1.00 (895,341.60)
1 121,415.97 1.20 101,179.98
2 239,155.83 1.44 166,080.44
3 388,227.33 1.73 224,668.59
4 576,225.72 2.07 277,886.63
5 1,435,457.45 2.49 576,878.15
VANF 451,352.19
TIRF 34.03%
25.02%
18.27%
23.55%
18.65%
Mazorca de cacao
Mazorcas daadas
Desgrane
3,2
Mazorca vacia
Fermentado
4,3
5,4 Secado
Grano defectuoso,
palillo, hojas, etc.
7,6 Clasificacion
Grano cacao
Sacos de yute
7 Envasado
1 Almacenamiento
(2 a 7 dias max.)
1 Almacenamiento
(2 a 7 dias max.)
Resumen
Operacin 7
Inspeccion 8
Almacen 1
PRODUCCION MENSUAL (TM / MES)
Enero Febrero Marzo Abril Mayo Junio Julio Agosto Setiembre
0.00 0.00 7.00 29.00 25.00 6.00 25.00 39.00 12.00
2010
59364690
1.0241039
1.0059723
0.60%
S)
Octubre Noviembre Diciembre TOTAL ANUAL
4.00 1.00 1.00 149.00
2014
60795612