316549137-LAB-solucion-VPN-2014-1-xls

SOLUCION LABORA

1

INGECO S.A. actualmete c c&%'$e '$e!a$& la la *& *&%'+'l'$a$ $e $e u $e &+!a &+!a e/u' e/u'a ale lete te a 150 15000 00 a$em)% .a+!) c&%t&% $e mat 'te! 'te!% % $e $e 15 15 u *e!-&$ *e!-&$& &$ t!a%*&! t!a%*&!ta$& ta$&!e% !e% al ('al ('al $e

150

2

0

1

38

435

2

VP DE LOS BENEFICIOS = VP COSTOS DIFERENCIA

7a 7a c& c&m*a *a-a *ue$e e$e c& c&m*! %'"u'ete

C&%t& I'c'al 9)/u'a A

 15000

9)/u'a B

:000

L&% L&% c&%t c&%t&% &% e '"! '"!e% e%&% &% %& %& aua auall m)/u'a $e+e c&m*!a!

9A;7INA A  = 15 a&%

12000 FEN= 6000 0

1

<000

15000  A VAN = ,> VAN = 9A;7INA B  = 15 a&%

8000 FEN= 3000 0

1

C&%t& I'c'al 9)/u'a A

 15000

9)/u'a B

:000

L&% L&% c&%t c&%t&% &% e '"! '"!e% e%&% &% %& %& aua auall m)/u'a $e+e c&m*!a!

9A;7INA A  = 15 a&%

12000 FEN= 6000 0

1

<000

15000  A VAN = ,> VAN = 9A;7INA B  = 15 a&%

8000 FEN= 3000 0

1

5000

:000

VAN= C&clu%'6

,>:000 ,>:00 0  :000>VAF10 :000>VAF10

 

VAN =

-

9,000.00

4,708.42

4 7a em*!e%a e e*a%'6 ec 7a c&m*a-a le &(!e a El *la $e al/u'le! c& 100 100000 000 $u!at $u!ate e 5 a&% a&% al ca+ c&m*uta$&!a *&! c'e!ta cat'$a$, mate'm'et& aual *&! el u%& + El *la *la $e c&m*! c&m*!a a !e/u !e/u'e! 'e!e eu a$em) a$em)% % el c&m*! c&m*!a$& a$&!! te$! te$!-a -a /u /u e/u'*& /ue a%c'e$e a 25000 aual aual cu)l cu)l e% la cat cat'$a '$a$ $ m)'m m)'m *&! la c&m*uta$&!a c& el *la '"uale%@ 4

ALQUILER n = 5 años

0

1

100000

100000

41<:8 671,561

VF al/u'le! 

CO!RA n = 5 años 0

1

25000 330000 VF c&m*!a

VP al/u'le! = =

El m&t& t&tal $e la 'e!%'6 !e e %u eta*a $e E%tu$'& $e Fac 'e!%'6 /ue %e ec

5

Activo Fijo Intangible: Estudios Previos Estudios definitivos   Organización   Supervisión Gastos puesta en marcha Intereses pre operativos   Contingencias · · ·

·

· · ·

·

Know How

Activo Fijo Tangible:   Terreno   Edificaciones · ·

a!uinaria " e!uipo ue#$es " enseres

· · ·

 

Imprevistos

Capital de Trabajo:

US$ 230,000

L&% acc'&'%ta% $el *!e%ete *! ua ta%a $e c&%t& $e &*&!tu'

El 'm*&!te $e la eta $e l&% % calcula$& e 100000 t&ela$a eta% e 25

El *!ec'& $e eta ('G& e%t) $e(' 100 *a!a el me!ca$& 'te! c&+!a$

El c&%t& $e *!&$ucc'6 aual %' 1H000000 *a!a el *!'me! a& & %e"u$& a&, A%'m'%m& el m& Veta% %' 'clu'! la am&!t'Jac'6

El m&t& $e la am&!t'Jac'6 $ $e*!ec'ac'6 $e ma/u'a!'a% # 3 aual $e*!ec'ac'6 $e mue+ la ''c'at'a $e catal&"a! a l&% ' ua $e*!ec'

De+e c&%'$e!a!%e u *a"& $e

F'almete la 'm*lemetac'6 $ $e ca*'tal $e t!a+aG& %ea !ecu &*e!at'&K $e la m'%ma mae! %u% e(ect&% al ('al $el < a& l'+!&% %e c&'e!te e al&! Se solicita d

a/

Vao$ +% $ -/ F*2o +

ESTADO DE RES7LTADOS V&lume $e eta% P!ec'& In#$%so &o$ '%n(as

1 100000 30 3,000,000

C&%t& $e *!&$ucc'6 a%t&% ee!ale%

1000000 500000

" 125000 30 3,750,000 Cos(os )*% SI so 1100000 500000

 Am&!t'Jac'6 De*!ec'ac'6 7t'l'$a$ ate% $e 'm*, Im*ue%t& >30 U(+a+ +%s&. +% &. > Am&!t'Jac'6 > De*!ec'ac'6 F.N.E. 8FLU;O
12200 150:0 1202210 3<0<<3 41,57 12200 150:0 1,13,337

Cos(os )*% NO so 12200 150:0 1852210 555<<3 1,"6,57 12200 150:0 1,5,337

Vao$ $%*&%$an 8año 6/9

ca*'tal $e t!a+aG&

230000

1: 0 :3,500,000 V!N :3,500,000

1 1,13,337

" 1,5,337

57,"6

1,1"5,465

3,65,657

V!N

3,65,657

3,65,657 3,65,657

PROBLEMA No. 6

C&m*a!e la% %"t% alte!at'a% $e la% m)/u'a% /ue %e mue%t!a a

C&%t& ''c'al C&%t& aual &*e!ac'6 Val&! %alamet& Ite!% V'$a ?t'l a&% Se pide :

a, !a('/ue el (luG& $e e(ect'&% $e am+a% ma/u'a% c& u c'cl& +, Cual $e la% $&% alte!at'a% > ma/u'a A 6 9a/u'a B  e% m

1400

1800

A = 3"00 0 1

15000

"

3



5

6

15000 V!N = 15000 13"008!>F?15@?3/  V!N =

15000 8<:,21 M 12110,34 M 8,1: M

35011,3

V!N = 2100

0

""000

A = "000 1 " 3



5

6

V!N = ""000  "0008!>A?15@?6/ :

V!N =

22000 5<8,: M :0,8: M

V!N =

28<<1,08

E2%$o 7

C&%'$e!e l&% $&% %'"u'ete% *lae% $e 'e!%'6 Pla A t'ee u c&%t& ''c' a$'c'&ale% $e  5000 al ('al $el te!ce! me% # $e  8000 al ('al $el %*t'm '$a # *!&$uce  10000 me%uale% $e +ee('c'&% a *a!t'

Pla B t'ee u c&%t& ''c'al $e  20000 # !e/u'e!e ua 'e!%'6 a$'c'&a *!'me!&% me%e% $e '$a e%te *la *!&$uce 8000 me%uale% $e '"!

Su*&'e$& ua ta%a $e $e%cuet& $el 3 me%ual $ete!m'e c

PLAN A:

i%=

Costo inicial: inversiones

$25,000 $5,000 $8,000

Benefcios

$10,000

3%

mensal

Costo inicial: inversiones

$20,000 $10,000

Benefcios

$8,000 $12,000

PLAN B:

!ROBLEA No: 4

INECO S,A, eal?a ua 'e!%'6 *&tec'al e u %'%tema alte!at'a e% c&t'ua! *!&$uc'e$& c& el e/u'*& c&ec'&al am+a% t'ee ua '$a ?t'l $e < a&%, La ta%a $e $e%cuet& a$/u'%'c'6 $el e/u'*& e% $e 25 m'll&e% el %&(ta!e # (&!ma m'll&e%, E%ta 'e!%'6 t'ee u al&! !e%'$ual & $e %al

S(*an on &$o%(o B%n%os +$%(os9

9a& $e &+!a $'!ecta

4000000

Re$ucc'6 $e%ec.&%

1800000

9eG&!a $e *!&ce$'m'et&%

1500000

B%n%os n(an#-%s9 cal'$a$  Re.ace! t!a+aG&

cal'$a$  a!at-a% 9ate'm'et& *&%'c'6 c&m*et't'a B%n%os n+$%(os9 P!&"!amac'6 *!&$ucc'6

Se $e+e!) *!&#ect&@

ace*ta!

500000 1500000

2500000

1200000

Pe!%&al '$'!ect&

100000

caGa et& auale% $e%*u% $e 'm*ue%t&%

13100000

el

EVALUACION
 ALTERNATIVA A  ALTERNATIVA B Ta%a $e%cuet& *e!'&$&

E;7IPO CONVENCIONAL N7EVO SISTE9A 18 <

a&%

1

"

Bee('c'&% $'!ect&% 9a& $e &+!a $'!ecta Re$ucc'6 $e%ec.&% 9eG&!a $e *!&ce$'m'et&%

00000 <00000 200000

00000 <00000 200000

F.N.E.

1,500,000

1,500,000

1 1500000

" 1500000

1500000

1500000

18 0 0 V!N 0 ,000,000 5,"6,0 5,"6,0

C&m*!a $e e/u'*& %&(ta!e # (&!mac'6 al&! !ecu*e!ac'6 T&tal 'e!%'6 Bee('c'&% $'!ect&% 9a& $e &+!a $'!ecta Re$ucc'6 $e%ec.&% 9eG&!a $e *!&ce$'m'et&% Bee('c'&% 'ta"'+le% &!!&% $e cal'$a$  Re.ace! t!

V!N

 A& 0 "5,000,000 14,000,000 3,000,000 1

2

4000000 1800000 1500000

4000000 1800000 1500000

500000

500000

 A.&!!&% $e cal'$a$  a!at1500000 ate'm'et& *&%'c'6 c&m*et' 2500000 Bee('c'&% '$'!ect&% P!&"!amac'6 *!&$ucc'6 1200000 Pe!%&al '$'!ect& 100000 F.N.E. 13,100,000 18 0

:3,000,000

1500000 2500000 1200000 100000 13,100,000

1 13100000

2 13100000

13100000

13100000

37,600,000 3,55,57 3,55,57

V!N

!ROBLEA No. 

 ARONOR e%t) e%tu$'a$& u *!&#ect& /ue c&%'%te e la *!e ma-J e ua !e"'6 $el *a-%, Pa!a el *!&#ect& !e/u'e!e c&m*!a! c& ua '$a ?t'l $e 10 a&% # u al&! !e%'$ual '"ual  5 m'll&, alcaJa!-a a 24 m'll&e% auale% c& u c&%t& t&tal $e 5 m'll m)/u'a,

Pa!a ('ac'a! el *!&#ect& l&% %&c'&% *&$!-a 40 m'll&e% # el l& &+te$!-a $e u *!%tam& +aca!'& c& ua ta%a $e 'te!% $ a& $e *e!'&$& $e "!ac'a, Da$& /ue l&% '"!e%&% %e "ee!a $ !e/ue!'!) $e Ca*'tal $e T!a+aG& al ' C&%'$e!a! ua ta%a 'm*&%'t'a >'m*ue%t& a la !eta $el 30 # 20,

a + c $

Ela+&!a! el *!&"!ama $e *a"& $e la $eu$a *a!a P!e%eta! el e%ta$& $e !e%ulta$&% *!&#ecta$& a P!e%eta! el (luG& $e caGa *!&#ecta$& a 10 a&% Calcula! el VAN *a!a e%te *!&#ect&,

SOLUCION CRONOGRAMA DE LA DEUDA

Ie!%'6 t&tal P!%tam& +ac&

<0 20

>C&%t& &*&!tu'$a$ T9AR

20

cu&ta c&%tate  A& $eu$a

m'll&e% m'll&e%

E m'll&e% $e  1 20,00

*!'c'*al>Am&!t'Jac'6 'te!%

0,00 1,<0

cu&ta '=

1,<0 8

ESTADO DE RESULTADOS

E%ta$& $e !e%ulta$&%

E m'll&e% $e 

 A& '"!e%&% c&%t&% /ue S' %& $e%em+&l%&

1 24,00 5,00

De*!ec'ac'6 m)/u'a Ite!% >c&%t& ('ac'e!&

5,50 1,<0

ut'l'$a$ ate% $e 'm*ue%t&% Im*ue%t&% >30

11,:0 3,5

ut'l'$a$ $e%*u% $e 'm*ue%t&%

8,33

FLUJO DE CAJA

(luG& $e caGa

E m'll&e% $e 

 A& ut'l'$a$ $e%*u% $e 'm*ue%t&% m)% $e*!ec'ac'6 'e!%'6 *!%tam& >Am&!t'Jac'&

0

1 8,33 5,50

<0,00 20,00 0,00

Val&! $e Salamet& *2o n%(o

:0.00

13.43

 A& *2o n%(o

0 :0.00

1 13.43

VAN

10.0

Da$& /ue el VAN Q 0  et&ce% & $e+e !eal'Ja!%e el *!&#ect&

ORIO VAN

!"a # $e%ca!"a l&% c&%tale% $e t!'"& $e (&!ma maual # e%t) %a! +a$a% t!a%*&!ta$&!a%, E%t& cau%a!-a u a.&!!& $e ma& auale%, Pa!a l&"!a! e%t& e% ece%a!'& 'e!t'! 435000 # e'm'et& $e l&% t!a%*&!ta$&!e% *&! 38000 al a&, C& u e a)l'%'% $e 8 a&% # u al&! $e %alamet& $e 0 *a!a l&% l *e!-&$& $ete!m-e%e la c&e'ec'a $e %u '%talac'6,

150

150

150

150

150

2

3

4

5

<

38

38

38

38

38

<30:8 10518 502580

<580

<580 <580,01 435000

<580

$e+e u%a!%e l&% t!a%*&!ta$&!e%

! ua $e $&% m)/u'a% A # B c& la% % ca!acte!-%t'ca%

I"!e%&%

C&%t&% &*e!at'&%



 12000

 <000

5

8000

5000

3

e% # n e% la '$a ?t'l $e la m)/u'a, ;u e c& u 'te!% $e 10 aual@

12000

12000

12000

12000

12000

2

3

4

5

<

<000

<000

<000

<000

<000

15000 15000>AP105  <000 2043 $u!ate 15 a&% ,>15000 15000>VAF105  15000>VAF1010 15000,00 :313,82 583,15  1553:,51 8000

8000

8000

8000

8000

2

3

4

5

<

5000

5000

5000

5000

:000

5000

:000

3:000>VAF10<:000>VAF10::000>VAF1012  3000>VAA101

!,"!1.8#

5,080.2"

#,81!.88

2,8!".!8

no e&e ace'tarse

%'ta ua c&m*uta$&!a $e alta ca*ac'$a$, e $&% *lae% $e a$/u'%'c'6 %'%te e el *a"& *&! a$elata$& $e $e l&% cuale% %e *ue$e c&m*!a! la E e%te *la el c&m*!a$&! & *a"a el e/u'*&,  $e%em+&l%& ''c'al $e 330000 # *a"a! el mate'm'et& aual $el a$a (' $e a&, C& ua ta%a $e 10 /ue %e $e+e *a"a! al ('al $e 5 a&% e al/u'le! *a!a /ue am+&% *lae% %ea

2

3

4

5

100000

100000

100000

=@

22,818.2

100000 >FP105 100000>FA 10 4>FPK10K1  671,561 .  671,561 .  1<1051 4<4100 1,100 2

3

4

5

25000

25000

25000

25000

330000>FP105  25000>FA 10 5 64,06 64,06 .= 671,561 .  VP c&m*!a 12535 *a"& $e la c&m*uta$&!a al ('al $el a&

ue!'$a *a!a u *!&#ect& el m'%m& /ue %e ecuet!a '+'l'$a$ a!!&Ga u t&tal e%t'ma$& $e 7S 3H500000 uet!a $etalla$a e l&% %'"u'ete% !u+!&%

 

%&'((( )('((( *%'((( )*'((( +&'((( ,%-'((( +*'((( .('(((

US$ 1´22,000

 

*+('((( %(&'(((

 

1,#"0,000 /('((( %/('(((

US$ 2´0!3,000

#ect& .a $ete!m'a$& 'e!t'! %u% *!&*'&% (&$&% a a$ a*!&'ma$a *a!a el ca*'tal a*&!ta$& $el 1:,

!'c'&% $e la *lata $e t!atam'et& $e !e%'$u&% e%ta *a!a el *!'me! a& c& u 'c!emet& aual e la% 00 t&ela$a% a *a!t'! $el 2$& a&,

'$& e 7S 30t&, Se a%ume /ue la eta %e!) $e # t&$& l& /ue %e *!&$uce e el a& e% e$'$& # $et!& $el m'%m& *e!'&$&,

'clu'! la $e*!ec'ac'6 (a+!'l %e .a calcula$& e 7S e!at'& c& u 'c!emet& aual $el 10 a *a!t'! $el t& aual $e l&% a%t&% ee!ale% >A$m''%t!ac'6 # $e act'&% 'ta"'+le% # la $e*!ec'ac'6 & (a+!'l e% $e 7S 500000,

'ta"'+le% %e calcula!) a !aJ6 $el 10 aual la e/u'*&% e 10 aual $e*!ec'ac'6 $e e$'('c'&% $el le% # e%e!e% $el 10 aualK a%'m'%m& %e .a t&ma$& *!e'%t&% c&m& act'&% ('G&% ta"'+le% (a+!'le%  c& ac'6 e/u'alete al 10 aual,

30 $e 'm*ue%t& a la !eta $et!& $e ca$a *e!'&$&,

l *!&#ect& *!e /ue el m&t& 'e!t'$& *&! c&ce*t& e!a$& *&! l&% acc'&'%ta% al ('al $el a& < >?lt'm& %e a%ume /ue el *!&#ect& e% l'/u'$a$& *a!a t&$&% *&! el cu)l el al&! !e%'$ual $e l&% act'&% >al&! e $e !ecu*e!& *a!a el *!&#ect& >al&! $e me!ca$&, terminar lo siguiente:

%*&%$o +% &$o%(o a2a +% &$o%(o / V!N

 

3 150000 30 ,500,000 +%s%-oso 1210000 500000

 15000 30 5,"50,000

5 200000 30 6,000,000

6 225000 30 6,750,000

1331000 500000

14<4100 500000

1<10510 500000

 

+%s%-oso 12200 150:0 24:2210 4<<3 1,7,57 12200 150:0 ",0",337

12200 150:0 3121210 :3<3<3 ",14,47 12200 150:0 ",4",637

12200 150:0 338110 1121433 ",616,677 12200 150:0 ",1,67

12200 150:0 434100 1302510 3,03,10 12200 150:0 3,0,1"5 653,15

3 ",0",337

 ",4",637

5 ",1,67

6 3,0,1"5

1,"11,55

1,"34,013

1,""1,306

1,05,0"

t!ee% $el VAN 

Máq. A

  

15000 3200 1800

Máq. B

 22000  2000  2100

15 aual

3

!

$e '$a '"uale%, % c&e'ete ec&6m'camete c&m*!a!,

3"008!>A?15@?6/ : 14008!>F?15@?6/

  "1008!>F?15@?6/

" !TOS

 9AS CONVENIENTE POR SER 9AOR EL VPN

l $e  25000 # !e/u'e!e 'e!%'&e% me%, E%te *la t'ee 12 me%e% $e $el *!'me! me%,

l $e  10000 al ('al $el &cta& me%, Du!ate %u% 11 %&%  12000 al t!m'& $el *!&#ect& >me% 12,

u)l $e l&% $&% *lae% e% m)% c&e'ete,

mes 0 # "

12

meses

VAN:

$63,459.60

meses

VAN:

$54,543.46

mes 0 8

11 12

e *!&$ucc'6 (le'+le, La & 'c&!*&!a! u ue& %'%tema % $el 18, El *!ec'& $e la c'6 t'ee u c&%t& $e 18 met& $e 2 m'll&e%,

S(*an a(*a

00000 <00000 200000

1500000

ALTERNATIVA A9 3



5

6

00000 <00000 200000

00000 <00000 200000

00000 <00000 200000

00000 <00000 200000

1,500,000

1,500,000

1,500,000

1,500,000

3 1500000

 1500000

5 1500000

6 1500000

1500000

1500000

1500000

1500000

ALTERNATIVA B9

2000000 3

4

5

<

4000000 1800000 1500000

4000000 1800000 1500000

4000000 1800000 1500000

4000000 1800000 1500000

500000

500000

500000

500000

1500000 2500000

1500000 2500000

1500000 2500000

1500000 2500000

1200000 100000 13,100,000

1200000 100000 13,100,000

1200000 100000 13,100,000

1200000 100000 15,100,000

3 13100000

4 13100000

5 13100000

< 15100000

13100000

13100000

13100000

15100000

tac'6 $e %e!'c'&% $e c&%ec.a $e a!!&J # $e u m&l'& /ue t'ee u c&%t& $e <0 m'll&e% Ell&% e%t'ma /ue l&% '"!e%&% $e &*e!ac'6 e% auale% >& 'clu#e la $e*!ec'ac'6 $e la

e%t& $el $'e!& *a!a la c&m*!a $e la m)/u'a l 8 aual *laJ& < a&% cu&ta% '"uale% # u %$e /ue el *!&#ect& em*'eJa a &*e!a! & %e 'c'& $el m'%m&,  c&%t& $e &*&!tu'$a$ $e l&% acc'&'%ta% $el

el ('ac'am'et& '$'ca$&, 10 a&% *a!a e%te *!&#ect&, a!a e%te *!&#ect&,

2 20,00

3 1<,5:

4 12,:1

5 8,:3

< 4,<4

3,41 1,<0

3,<8 1,33

3,:8 1,03

4,2: 0,1

4,<4 0,3

5,01

5,01

5,01

5,01

5,01

2 24,00 5,00

3 24,00 5,00

4 24,00 5,00

5 24,00 5,00

< 24,00 5,00

5,50 1,<0

5,50 1,33

5,50 1,03

5,50 0,1

5,50 0,3

11,:0 3,5

12,1 3,<5

12,4 3,4

12,: 3,84

13,13 3,:4

8,33

8,52

8,3

8,:5

:,1:

2 8,33

3 8,52

4 8,3

5 8,:5

< :,1:

5,50

5,50

5,50

5,50

5,50

3,41

3,<8

3,:8

4,2:

4,<4

10."

10.3

10."5

10.16

10.05

2 10."

3 10.3

4 10."5

5 10.16

< 10.05

S>. 10.0

S, 10,:0

150

150



8

38

38

112000

12000

12000

14

15

<000

<000

  <000>VAA1015 45<3<,48

8000

8000

14

15

5000



5000

11

00 <00 200 1,500,000

 0,00

 24,00 5,00

8 24,00 5,00

: 24,00 5,00

10 24,00 5,00

5,50 0,00

5,50 0,00

5,50 0,00

5,50 0,00

13,50 4,05

13,50 4,05

13,50 4,05

13,50 4,05

:,45

:,45

:,45

:,45