Caso Pecosa FI 2014-I RES
Caso Pecosa FI 2014-I RES
Caso Pecosa FI 2014-I RES
Presupuesto:
Terreno US$
Construccin US$
Equipamiento US$
Gastos de Ventas (mensual) US$
Gastos Operativos (mensual) US$
Capacidad de Produccin (cajas)
Costo de Ventas (por caja) US$
Primeros 5 aos
Ao del Proyecto
Precio de Venta x Caja
Precio Vta.
5,000,000
10,000,000
100,000,000
5,000
500,000
10,000,000
8
Cajas
30,000,000
30,000,000
20,000,000
20,000,000
100,000,000
-5,000,000
-9,005,000
-84,745,763
-16,249,237
-115,000,000
Capacidad de Produccin
Crecimiento de Ventas
Ingresos por Ventas al Exterior
Ingresos por Ventas Locales
Costo de Ventas
Gastos de Ventas
Gastos Operativos
Depreciacin
Gastos Financieros
Utilidad Operativa
Impuesto a la Renta
Utilidad Neta
Fondos Generados
Amortizacin del Bono
7.15
%
30.0%
30.0%
20.0%
20.0%
Se firma TLC
5 aos siguientes
10
Ao 1
Ao 2
Ao 3
Ao 4
$15,00
Ao 6
Ao 5
Ao 7
Ao 8
Ao 9
Ao 10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5,000,000
6,276,212
0
16,249,237
27,525,449
25%
20%
30.0%
25.0%
35.0%
28.0%
40.0%
33.0%
45.0%
40.0%
47.0%
30.0%
51.0%
20.0%
58.0%
13.0%
65.0%
10.0%
100.0%
6.4%
26,125,000
1,375,000
-17,875,000
-53,580
-5,372,400
-8,747,455
-8,050,000
-12,598,435
0
-12,598,435
31,350,000
1,650,000
-21,450,000
-66,975
-6,715,500
-8,747,455
-8,050,000
-12,029,930
0
-12,029,930
36,575,000
19,250,000
-25,025,000
-85,728
-8,864,460
-8,747,455
-8,050,000
5,052,357
1,515,707
6,568,064
41,800,000
22,000,000
-28,600,000
-114,018
-11,967,021
-8,747,455
-8,050,000
6,321,506
1,896,452
8,217,957
47,025,000
24,750,000
-32,175,000
-159,626
-16,753,829
-8,747,455
-8,050,000
5,889,090
1,766,727
7,655,817
52,250,000
27,500,000
-35,750,000
-207,513
-21,779,978
-8,747,455
-8,050,000
5,215,054
1,564,516
6,779,570
57,475,000
30,250,000
-39,325,000
-249,016
-26,135,974
-8,747,455
-8,050,000
5,217,555
1,565,267
6,782,822
62,700,000
33,000,000
-42,900,000
-281,388
-29,533,650
-8,747,455
-8,050,000
6,187,507
1,856,252
8,043,759
83,600,000
44,000,000
-57,200,000
-309,527
-32,487,016
-8,747,455
-8,050,000
20,806,003
6,241,801
27,047,804
104,500,000
55,000,000
-71,500,000
-329,336
-34,566,185
-8,747,455
-8,050,000
36,307,024
10,892,107
47,199,131
-3,850,980
-3,282,475
15,315,519
16,965,412
16,403,272
15,527,025
15,530,277
16,791,214
35,795,259
55,946,586
-115,000,000
-3,282,475
15,315,519
16,965,412
16,403,272
15,527,025
15,530,277
16,791,214
35,795,259
-31,527,965
-115,000,000
-3,850,980
-7,133,455
8,182,064
25,147,477
41,550,749
57,077,773
72,608,050
89,399,264
125,194,522
93,666,558
Ao 0
$ 115,000,000
Ao 1
$ 115,000,000
$0
-8,050,000
Ao 2
$ 115,000,000
$0
-8,050,000
Ao 3
$ 115,000,000
$0
-8,050,000
Ao 4
$ 115,000,000
$0
-8,050,000
Ao 5
$ 115,000,000
$0
-8,050,000
Ao 6
$ 115,000,000
$0
-8,050,000
Ao 7
$ 115,000,000
$0
-8,050,000
Ao 8
$ 115,000,000
$0
-8,050,000
Ao 9
$ 115,000,000
$0
-8,050,000
-115,000,000
VAN al 7.00%
TIR
$ -51,092,466
-3.58%
Amortizacin Bonos
Saldo
Amortizacin
Tasa Anual
0.85
-3,850,980
Flujo de Caja
PAYBACK
995,000
15,254,237
535
52,300
Valor Vta.
5,000,000
9,005,000
84,745,763
4,465
447,700
5
$ 11.00
Ao 0
INVERSIN
Terreno
Construccin
Equipamiento
Capital de Trabajo
Total Inversin
IGV
7.00%
Ao 10
$0
-115,000,000
-8,050,000
PECOSA
Presupuesto:
Terreno US$
Construccin US$
Equipamiento US$
Gastos de Ventas (mensual) US$
Gastos Operativos (mensual) US$
Capacidad de Produccin (cajas)
Costo de Ventas (por caja) US$
Primeros 5 aos
Ao del Proyecto
Precio de Venta x Caja
Precio Vta.
5,000,000
10,000,000
100,000,000
5,000
500,000
10,000,000
8
Cajas
30,000,000
30,000,000
20,000,000
20,000,000
100,000,000
Capacidad de Produccin
Crecimiento de Ventas
Ingresos por Ventas al Exterior
Ingresos por Ventas Locales
Costo de Ventas
Gastos de Ventas
Gastos Operativos
Depreciacin
Gastos Financieros
Utilidad Operativa
Impuesto a la Renta
Utilidad Neta
Fondos Generados
995,000
15,254,237
535
52,300
Valor Vta.
5,000,000
9,005,000
84,745,763
4,465
447,700
0.85
7.15
%
30.0%
30.0%
20.0%
20.0%
5
$ 14.00
Ao 0
INVERSIN
Terreno
Construccin
Equipamiento
Capital de Trabajo
Total Inversin
IGV
-5,000,000
-9,005,000
-84,745,763
-16,249,237
-115,000,000
Ao 1
Ao 2
0
0
0
0
0
0
0
0
0
0
25%
20%
30.0%
25.0%
33,250,000
1,750,000
-17,875,000
-53,580
-5,372,400
-8,747,455
-8,050,000
-5,098,435
0
-5,098,435
39,900,000
2,100,000
-21,450,000
-66,975
-6,715,500
-8,747,455
-8,050,000
-3,029,930
0
-3,029,930
3,649,020
5,717,525
3,649,020
5,717,525
-115,000,000
3,649,020
9,366,545
Ao 0
$ 115,000,000
Ao 1
$ 115,000,000
$0
-8,050,000
Ao 2
$ 115,000,000
$0
-8,050,000
Flujo de Caja
-115,000,000
VAN al 7.00%
TIR
$ 163,751,055
23.70%
PAYBACK
Amortizacin Bonos
Saldo
Amortizacin
Tasa Anual
7.00%
Se firma TLC
5 aos siguientes
10
Ao 3
Ao 4
$15,00
Ao 6
Ao 5
Ao 7
Ao 8
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
35.0%
28.0%
40.0%
33.0%
45.0%
40.0%
50.0%
30.0%
55.0%
20.0%
60.0%
13.0%
46,550,000
24,500,000
-25,025,000
-85,728
-8,864,460
-8,747,455
-8,050,000
20,277,357
6,083,207
26,360,564
53,200,000
28,000,000
-28,600,000
-114,018
-11,967,021
-8,747,455
-8,050,000
23,721,506
7,116,452
30,837,957
59,850,000
31,500,000
-32,175,000
-159,626
-16,753,829
-8,747,455
-8,050,000
25,464,090
7,639,227
33,103,317
71,250,000
37,500,000
-35,750,000
-207,513
-21,779,978
-8,747,455
-8,050,000
34,215,054
10,264,516
44,479,570
78,375,000
41,250,000
-39,325,000
-249,016
-26,135,974
-8,747,455
-8,050,000
37,117,555
11,135,267
48,252,822
85,500,000
45,000,000
-42,900,000
-281,388
-29,533,650
-8,747,455
-8,050,000
40,987,507
12,296,252
53,283,759
35,108,019
39,585,412
41,850,772
53,227,025
57,000,277
62,031,214
35,108,019
39,585,412
41,850,772
53,227,025
57,000,277
62,031,214
44,474,564
84,059,977
125,910,749
179,137,773
236,138,050
298,169,264
Ao 3
$ 115,000,000
$0
-8,050,000
Ao 4
$ 115,000,000
$0
-8,050,000
Ao 5
$ 115,000,000
$0
-8,050,000
Ao 6
$ 115,000,000
$0
-8,050,000
Ao 7
$ 115,000,000
$0
-8,050,000
Ao 8
$ 115,000,000
$0
-8,050,000
Ao 9
Ao 10
0
0
0
0
0
5,000,000
6,276,212
0
16,249,237
27,525,449
80.0%
10.0%
100.0%
6.4%
114,000,000
60,000,000
-57,200,000
-309,527
-32,487,016
-8,747,455
-8,050,000
67,206,003
20,161,801
87,367,804
142,500,000
75,000,000
-71,500,000
-329,336
-34,566,185
-8,747,455
-8,050,000
94,307,024
28,292,107
122,599,131
96,115,259
131,346,586
-115,000,000
96,115,259
43,872,035
394,284,522
438,156,558
Ao 9
$ 115,000,000
$0
-8,050,000
Ao 10
$0
-115,000,000
-8,050,000