Estados Finaciero de Cemento PACASMAYO
Estados Finaciero de Cemento PACASMAYO
Estados Finaciero de Cemento PACASMAYO
CONSORSIO
CEMENTERO
DEL SUR SA
265,964
2,694,938
9.87%
0.195
1.92%
CEMENTOS
PACASMAYO
152,283
3,114,537
4.89%
0.225
1.10%
UNION ANDINA
DE CEMENTOS
SAA
193,291
8,039,864
2.40%
0.581
1.40%
FLUJO DE EFECTIVO
2011
2012
S/. 994,970.00 S/. 1,169,808.00
S/. 569,515.00
S/. 713,058.00
S/. 425,455.00
S/. 456,750.00
S/. 23,707.00
S/. 30,865.00
S/. 196,196.00
S/. 203,067.00
S/. 9,338.00
S/. 7,706.00
S/. 95,994.00
S/. 118,896.00
S/. 230,524.00
S/. 2,695.00
S/. 23,326.00
S/. 19,219.00
S/. 23,771.00
S/. 1,476.00
-S/. 736.00
S/. 103,848.00
S/. 229,343.00
S/. 38,379.00
S/. 73,743.00
S/. 65,469.00
S/. 155,600.00
S/. 65,469.00
S/. 155,600.00
Costo de Ventas
Ingresos
Costo Ventas
Porcentaje
Gastos de venta y Distribucin:
Gastos administrativos:
2011
2012
S/. 994,970.00 S/. 1,169,808.00
S/. 569,515.00
S/. 713,058.00
57.24%
60.96%
Ingresos Financieros
Gastos Financieros
ACTIVO TOTAL
Inv Inicial
FLUJO
FLUJO DESCONTADO
0
S/. 1,947,825
S/. 1,947,825
2011
2012
S/. 1,476.00
-S/. 736.00
S/. 994,970.00 S/. 1,169,808.00
0.15%
-0.06%
2011
S/. 1,947,825
2012
S/. 2,383,324
2011
1
65469
62700
2012
2
155600
142718
-S/. 329,422.08
ROA =
4.44%
0.93%
r=
Flujo Efect.
0
1
2
3
4
5
6
7
8
(1,947,825)
65469
155,600
152,283
235540
279,708
329357
385148
447818
TIR
0.93%
=
<
4.4156%
Fact. Actualiz.
0.95771
0.91721
0.87842
0.84127
0.80570
0.77163
0.73899
0.70774
VAN
COK =
FLUJO DE EFECTIVO
2011
2012
S/. 994,970.00 S/. 1,169,808.00
S/. 569,515.00
S/. 713,058.00
S/. 425,455.00
S/. 456,750.00
S/. 23,707.00
S/. 30,865.00
S/. 196,196.00
S/. 203,067.00
S/. 9,338.00
S/. 7,706.00
S/. 95,994.00
ACTIVO TOTAL
S/. 118,896.00
S/. 2,695.00
S/. 19,219.00
S/. 1,476.00
S/. 103,848.00
S/. 38,379.00
S/. 65,469.00
S/. 65,469.00
S/. 230,524.00
S/. 23,326.00
S/. 23,771.00
-S/. 736.00
S/. 229,343.00
S/. 73,743.00
S/. 155,600.00
S/. 155,600.00
2011
S/. 1,947,825
2012
S/. 2,383,324
2011
1
65469
62700
2012
2
155600
142718
Inv Inicial
FLUJO
FLUJO DESCONTADO
0
S/. 1,947,825
S/. 1,947,825
S/. 409,481.17
ROA=
3.70%
7.48%
r=
Flujo Efect.
0
1
2
3
4
5
6
7
8
9
10
(1,947,825)
65469
155,600
152,283
235540
279,708
329357
385,148
447,818
518192
597,192
TIR
7.48%
=
>
4.4156%
Fact. Actualiz.
0.95771
0.91721
0.87842
0.84127
0.80570
0.77163
0.73899
0.70774
0.67781
0.64915
VAN
COK =
Con una vida til de 10 aos (3 los reales y 7 los proyectados), la empresa Cementos Pacasmayo
La TIR del Proyecto para los inversionistas es de 7.48% , el Proyecto ademas de cumplir con la ren
La empresa Cementos Pacasmayo es rentable con la opcion de alargar la vida til del Proyecto
La empresa Cementos Pacasmayo es rentable con la opcion de alargar la vida til del Proyecto
50.00%
Inv Inicial
0
ACTIVO TOTAL
FLUJO INICIAL
FLUJO DESCONTADO INICIAL
FLUJO CON AUM 50% INV Y FLUJOS
FLUJO DESCONTADO CON AUM 50%
S/. 1,947,825
S/. 1,947,825
S/. 2,921,738
S/. 2,921,738
2011
1
S/. 1,947,825
65469
62700
S/. 94,051
90073
2012
2
S/. 2,383,324
155600
142718
S/. 214,077
196353
-S/. 255,933.01
ROA=
2.34%
CALCULO DEL TIR
r=
Flujo Efect.
0
1
2
3
4
5
6
7
8
9
10
(2,921,738)
94051
214,077
200,653
297230
338,040
381,211
426933
475,410
526855
581,499
TIR
2.94%
=
<
4.4156%
Fact. Actualiz.
0.95771
0.91721
0.87842
0.84127
0.80570
0.77163
0.73899
0.70774
0.67781
0.64915
VAN
COK =
Con un aumento del 50% tanto en la Inversion Fija como en los Flujos de Efectivo,
La tasa de interes promedio que el Proyecto devuelve a sus inversionistas. (TIR ) es de 2.94%
Bajo estas proyecciones la Inversion no cumplira con la rentabilidad mnima esperada. de 4.44% que
que quiere decir que el Proyecto no es viable.
Bajo estas proyecciones la Inversion no cumplira con la rentabilidad mnima esperada. de 4.44% que
que quiere decir que el Proyecto no es viable.
Para la empresa Cementos Pacasmayo , el aumentar su inversin inicial en un 50% , no le genera mejo
10.00%
Inv Inicial
0
ACTIVO TOTAL
FLUJO INICIAL
FLUJO DESCONTADO INICIAL
FLUJO CON AUM 10% INV Y FLUJOS
FLUJO DESCONTADO CON AUM 50%
VAN CEMENTOS PACASMAYO=
ROA=
CALCULO DEL TIR =
S/. 1,947,825
S/. 1,947,825
S/. 2,142,608
S/. 2,142,608
2011
1
S/. 1,947,825
65469
62700
S/. 72,016
68970
2012
2
S/. 2,383,324
155600
142718
S/. 171,160
156990
S/. 450,429.28
2.64%
7.4847%
r=
Flujo Efect.
0
1
2
3
4
5
6
7
8
9
10
(2,142,608)
72016
171,160
167,511
259094
307,679
362,293
423663
492,600
570011
656,911
TIR
7.48%
=
>
4.4156%
Fact. Actualiz.
0.95771
0.91721
0.87842
0.84127
0.80570
0.77163
0.73899
0.70774
0.67781
0.64915
VAN
COK =
OS PACASMAYO"
TOTAL
13,849,339
4.42%
Ao 2013
EFECTIVO
2013 (2011-2012)
S/. 1,239,688.00
17.57%
S/. 716,239.00
25.20%
7.36%
S/. 523,449.00
S/. 29,817.00
30.19%
S/. 208,915.00
3.50%
S/. 8,281.00
-17.48%
-100.00%
S/. 292,998.00
93.89%
S/. 27,213.00
765.53%
S/. 37,103.00
23.68%
-S/. 48,430.00
-149.86%
S/. 234,678.00
120.84%
S/. 82,395.00
92.14%
S/. 152,283.00
137.67%
S/. 152,283.00
137.67%
Tasa de C
PROYECT
(2012-2013)
Tasa de C
2,014
2,015
5.97%
11.77% S/. 1,385,635.34 S/. 1,548,764.93
0.45%
12.83%
S/. 812,768.85
S/. 908,455.39
14.60%
10.98%
S/. 572,866.49
S/. 640,309.54
-3.40%
13.40%
S/. 28,804.58
S/. 27,826.54
2.88%
3.19%
S/. 214,931.41
S/. 221,121.09
7.46%
-5.01%
S/. 10,462.71
S/. 11,694.48
27.10%
16.66%
56.09%
6480.16%
2.33%
11.73%
-2.13%
-2.13%
60.49%
391.10%
39.89%
3165.15%
61.59%
51.94%
67.77%
67.77%
S/. 339,593.20
S/. 29,023.18
S/. 32,130.99
S/. 403,056.38
S/. 32,440.05
S/. 35,913.74
S/. 336,485.40
S/. 100,945.62
S/. 235,539.78
S/. 235,539.78
S/. 399,582.70
S/. 119,874.81
S/. 279,707.89
S/. 279,707.89
2013 Promedio
S/. 1,239,688.00
S/. 716,239.00
57.78%
58.66%
2013 Promedio
-S/. 48,430.00
S/. 1,239,688.00
-3.91%
-1.27%
2013 (2011-2012) (2012-2013)
Tasa de C
S/. 3,114,537
22.36%
30.68%
26.52%
2013
3
152283
133769
2,014
4
235540
198154
2,015
5
279708
225360
2,016
6
329357
254140
2,014
S/. 3,940,491
2,015
S/. 4,985,481
2,017
7
385148
284622
2,018
8
447818
316940
r=
Valor Actual
Flujo Efect.
(1947825)
62700
142718
133769
198154
225360
254140
284622
316940
-329422.08
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
1.0000%
r=
Fact. Actualiz.
Valor Actual
Flujo Efect.
0.99010
0.98030
0.97059
0.96098
0.95147
0.94205
0.93272
0.92348
VAN
(1947825)
64821
152534
147804
226349
266132
310270
359235
413552
-7127.82
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
0.9330%
Fact. Actualiz
0.99076
0.98160
0.97252
0.96353
0.95463
0.94580
0.93706
0.92840
VAN
4.42%
Proyecto devuelve a sus inversionistas. Como se puede apreciar , bajo las condiciones actuales el Poyecto no es
iento promedio sectorial que asciende a 4.42%. Adicionalmente a ello el VAN es negativo, lo que quiere decir q
quieren estrategias para mejorar los indicadores., como sabemos Cementos Pacasmayo es una industria, no pod
da til del Proyecto.
EFECTIVO
2013 (2011-2012)
S/. 1,239,688.00
17.57%
S/. 716,239.00
25.20%
7.36%
S/. 523,449.00
S/. 29,817.00
30.19%
S/. 208,915.00
3.50%
S/. 8,281.00
-17.48%
-100.00%
Tasa de C
PROYECT
(2012-2013)
Tasa de C
2,014
2,015
5.97%
11.77% S/. 1,385,635.34 S/. 1,548,764.93
0.45%
12.83%
S/. 812,768.85
S/. 908,455.39
14.60%
10.98%
S/. 572,866.49
S/. 640,309.54
-3.40%
13.40%
S/. 28,804.58
S/. 27,826.54
2.88%
3.19%
S/. 214,931.41
S/. 221,121.09
7.46%
-5.01%
S/. 10,462.71
S/. 11,694.48
S/. 292,998.00
S/. 27,213.00
S/. 37,103.00
-S/. 48,430.00
S/. 234,678.00
S/. 82,395.00
S/. 152,283.00
S/. 152,283.00
60.49%
391.10%
39.89%
3165.15%
61.59%
51.94%
67.77%
67.77%
S/. 339,593.20
S/. 29,023.18
S/. 32,130.99
S/. 403,056.38
S/. 32,440.05
S/. 35,913.74
S/. 336,485.40
S/. 100,945.62
S/. 235,539.78
S/. 235,539.78
S/. 399,582.70
S/. 119,874.81
S/. 279,707.89
S/. 279,707.89
2,014
S/. 3,940,491
2,015
S/. 4,985,481
2,017
7
385148
284622
2,018
8
447818
316940
2013
3
152283
133769
93.89%
765.53%
23.68%
-149.86%
120.84%
92.14%
137.67%
137.67%
2,014
4
235540
198154
r=
Valor Actual
Flujo Efect.
(1947825)
62700
142718
133769
198154
225360
254140
284622
316940
351237
387666
409481.17
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
518192
597192
27.10%
16.66%
56.09%
6480.16%
2.33%
11.73%
-2.13%
-2.13%
2,015
5
279708
225360
2,016
6
329357
254140
7.5000%
r=
Fact. Actualiz.
Valor Actual
Flujo Efect.
0.93023
0.86533
0.80496
0.74880
0.69656
0.64796
0.60275
0.56070
0.52158
0.48519
VAN
(1947825)
60901
134646
122582
176372
194833
213411
232150
251092
270280
289754
-1803.40
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
518192
597192
4.42%
Cementos Pacasmayo genera un Van Positivo y adicionalmente una TIR mayor al COK.
e cumplir con la rentabilidad mnima esperada, genera valor adicional.
del Proyecto.
7.4000%
Fact. Actualiz
0.93110
0.86694
0.80721
0.75159
0.69981
0.65159
0.60669
0.56489
0.52597
0.48973
VAN
del Proyecto.
2013
3
S/. 3,114,537
152283
133769
S/. 200,653
176258
2,014
4
3,940,491
235540
198154
S/. 297,230
250052
r=
Valor Actual
Flujo Efect.
(2921738)
90073
196353
176258
250052
272358
294152
315501
336468
357109
377480
-255933.01
(2921738)
94051
214077
200653
297230
338040
381211
426933
475410
526855
581499
2,015
5
4,985,481
279708
225360
S/. 338,040
272358
2,016
6
6,307,596
329357
254140
S/. 381,211
294152
2.9000%
2,017
7
7,980,326
385148
284622
S/. 426,933
315501
r=
Fact. Actualiz.
Valor Actual
Flujo Efect.
0.97182
0.94443
0.91781
0.89195
0.86681
0.84238
0.81864
0.79557
0.77315
0.75136
VAN
(2921738)
91400
202180
184162
265113
293016
321124
349504
378220
407336
436914
7232.46
(2921738)
94051
214077
200653
297230
338040
381211
426933
475410
526855
581499
2,018
8
10,096,653
447818
316940
S/. 475,410
336468
2.9500%
Fact. Actualiz
0.97135
0.94351
0.91648
0.89021
0.86471
0.83993
0.81586
0.79248
0.76977
0.74772
VAN
4.42%
ectivo,
R ) es de 2.94%.
rada. de 4.44% que es la Tasa de rendimiento promedio sectoria l. Adicionalmente a ello el VAN es negativo, lo
rada. de 4.44% que es la Tasa de rendimiento promedio sectoria l. Adicionalmente a ello el VAN es negativo, lo
% , no le genera mejores ingresos , por el contrario el Van de la inversion se hace negativa y la TIR disminuye.
2013
3
S/. 3,114,537
152283
133769
S/. 167,511
147146
2,014
4
3,940,491
235540
198154
S/. 259,094
217969
r=
Valor Actual
Flujo Efect.
(2142608)
68970
156990
147146
217969
247896
279555
313084
348634
386361
426433
450429.28
(2142608)
72016
171160
167511
259094
307679
362293
423663
492600
570011
656911
2,015
5
4,985,481
279708
225360
S/. 307,679
247896
2,016
6
6,307,596
329357
254140
S/. 362,293
279555
7.5000%
2,017
7
7,980,326
385148
284622
S/. 423,663
313084
r=
Fact. Actualiz.
Valor Actual
Flujo Efect.
0.93023
0.86533
0.80496
0.74880
0.69656
0.64796
0.60275
0.56070
0.52158
0.48519
VAN
(2142608)
66992
148110
134840
194010
214316
234752
255365
276202
297308
318729
-1983.74
(2142608)
72016
171160
167511
259094
307679
362293
423663
492600
570011
656911
2,018
8
10,096,653
447818
316940
S/. 492,600
348634
7.4900%
Fact. Actualiz
0.93032
0.86549
0.80519
0.74908
0.69688
0.64832
0.60315
0.56112
0.52202
0.48565
VAN
4.42%
R mayor al COK.
aumenta Inversion , sin embarg o el Van se hace mayor , genera un valor mayor. Esta opcion es
PROYECTADOS
2,016
2,017
2,018
S/. 1,731,099.61 S/. 1,934,900.39 S/. 2,162,694.46
S/. 1,015,407.02 S/. 1,134,949.96 S/. 1,268,566.58
S/. 715,692.60
S/. 799,950.44
S/. 894,127.87
S/. 26,881.71
S/. 25,968.96
S/. 25,087.20
S/. 227,489.02
S/. 234,040.33
S/. 240,780.31
S/. 13,071.26
S/. 14,610.12
S/. 16,330.16
S/. 474,393.12
S/. 36,259.19
S/. 40,141.83
S/. 554,551.26
S/. 40,527.95
S/. 44,867.69
S/. 644,590.51
S/. 45,299.27
S/. 50,149.92
S/. 470,510.49
S/. 141,153.15
S/. 329,357.34
S/. 329,357.34
S/. 550,211.53
S/. 165,063.46
S/. 385,148.07
S/. 385,148.07
S/. 639,739.86
S/. 191,921.96
S/. 447,817.90
S/. 447,817.90
2,016
S/. 6,307,596
2,017
S/. 7,980,326
2,018
S/. 10,096,653
r=
Valor Actual
Flujo Efect.
(1947825)
64864
152737
148099
226951
267017
311507
360907
415754
10.04
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
0.9331%
Fact. Actualiz.
Valor Actual
0.99076
0.98160
0.97252
0.96353
0.95462
0.94580
0.93705
0.92839
VAN
(1947825)
64864
152736
148098
226950
267016
311505
360905
415750
-0.64
PROYECTADOS
2,016
2,017
2,018
2,019
2,020
S/. 1,731,099.61 S/. 1,934,900.39 S/. 2,162,694.46 S/. 2,417,306.51 S/. 2,701,893.80
S/. 1,015,407.02 S/. 1,134,949.96 S/. 1,268,566.58 S/. 1,417,913.77 S/. 1,584,843.47
S/. 715,692.60
S/. 799,950.44
S/. 894,127.87
S/. 999,392.73 S/. 1,117,050.33
S/. 26,881.71
S/. 25,968.96
S/. 25,087.20
S/. 24,235.39
S/. 23,412.49
S/. 227,489.02
S/. 234,040.33
S/. 240,780.31
S/. 247,714.40
S/. 254,848.17
S/. 13,071.26
S/. 14,610.12
S/. 16,330.16
S/. 18,252.69
S/. 20,401.57
S/. 474,393.12
S/. 36,259.19
S/. 40,141.83
S/. 554,551.26
S/. 40,527.95
S/. 44,867.69
S/. 644,590.51
S/. 45,299.27
S/. 50,149.92
S/. 745,695.65
S/. 50,632.32
S/. 56,054.03
S/. 859,191.24
S/. 56,593.21
S/. 62,653.22
S/. 470,510.49
S/. 141,153.15
S/. 329,357.34
S/. 329,357.34
S/. 550,211.53
S/. 165,063.46
S/. 385,148.07
S/. 385,148.07
S/. 639,739.86
S/. 191,921.96
S/. 447,817.90
S/. 447,817.90
S/. 740,273.93
S/. 222,082.18
S/. 518,191.75
S/. 518,191.75
S/. 853,131.23
S/. 255,939.37
S/. 597,191.86
S/. 597,191.86
2,016
S/. 6,307,596
2,017
S/. 7,980,326
2,018
S/. 10,096,653
2,019
S/. 12,774,215
2,020
S/. 16,161,848
2,019
9
518192
351237
2,020
10
597192
387666
r=
Valor Actual
Flujo Efect.
(1947825)
60958
134897
122925
177030
195742
214606
233667
252969
272554
292463
9984.79
(1947825)
65469
155600
152283
235540
279708
329357
385148
447818
518192
597192
7.4847%
Fact. Actualiz.
Valor Actual
0.93037
0.86558
0.80531
0.74923
0.69706
0.64852
0.60336
0.56134
0.52225
0.48589
VAN
(1947825)
60910
134684
122634
176473
194972
213594
232382
251380
270628
290168
0.00
2,019
9
12,774,215
518192
351237
S/. 526,855
357109
2,020
10
16,161,848
597192
387666
S/. 581,499
377480
r=
Valor Actual
Flujo Efect.
(2921738)
91356
201984
183894
264599
292305
320189
348318
376753
405559
434796
-1984.50
(2921738)
94051
214077
200653
297230
338040
381211
426933
475410
526855
581499
VAN es negativo, lo
2.9392%
Fact. Actualiz.
Valor Actual
0.97145
0.94371
0.91676
0.89059
0.86516
0.84046
0.81646
0.79315
0.77050
0.74850
VAN
(2921738)
91365
202026
183952
264710
292458
320391
348573
377070
405942
435253
3.12
VAN es negativo, lo
y la TIR disminuye.
2,019
9
12,774,215
518192
351237
S/. 570,011
386361
2,020
10
16,161,848
597192
387666
S/. 656,911
426433
r=
Valor Actual
Flujo Efect.
(2142608)
66998
148138
134878
194082
214416
234883
255531
276407
297557
319026
-691.68
(2142608)
72016
171160
167511
259094
307679
362293
423663
492600
570011
656911
7.4847%
Fact. Actualiz.
Valor Actual
0.93037
0.86558
0.80531
0.74923
0.69706
0.64852
0.60336
0.56134
0.52225
0.48589
VAN
(2142608)
67001
148153
134898
194120
214469
234953
255620
276517
297691
319185
0.00