ejercicios capitulo 6 v2.0 versión excel 2003

94
Año FC( Millones) r VPN 0 -100 1% S/. 2,509.84 1 30 5% S/. 499.97 2 30 10% S/. 200.00 3 30 15% S/. 100.00 4 30 20% S/. 50.00 5 30 25% S/. 20.00 6 30 30% S/. 0.00 7 30 35% S/. -14.29 8 30 40% S/. -25.00 9 30 45% S/. -33.33 10 30 50% S/. -40.00 11 30 35% S/. -14.29 12 30 40% S/. -25.00 13 30 45% S/. -33.33 14 30 50% S/. -40.00 15 30 55% S/. -45.45 16 30 60% S/. -50.00 17 30 65% S/. -53.85 18 30 70% S/. -57.14 19 30 75% S/. -60.00 20 30 80% S/. -62.50 21 30 85% S/. -64.71 22 30 90% S/. -66.67 23 30 95% S/. -68.42 24 30 25 30 26 30 27 30 28 30 29 30 30 30 31 30 32 30 33 30 34 30 35 30 36 30 37 30 38 30 39 30 40 30 41 30 42 30 43 30

Upload: rbogicevic

Post on 04-Dec-2015

356 views

Category:

Documents


1 download

DESCRIPTION

Ejercicios para Estudiantes de Maestria, Decisiones Financieras 2

TRANSCRIPT

Page 1: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Año FC( Millones) r VPN0 -100 1% S/. 2,509.841 30 5% S/. 499.972 30 10% S/. 200.003 30 15% S/. 100.004 30 20% S/. 50.005 30 25% S/. 20.006 30 30% S/. 0.007 30 35% S/. -14.298 30 40% S/. -25.009 30 45% S/. -33.33

10 30 50% S/. -40.0011 30 35% S/. -14.2912 30 40% S/. -25.0013 30 45% S/. -33.3314 30 50% S/. -40.0015 30 55% S/. -45.4516 30 60% S/. -50.0017 30 65% S/. -53.8518 30 70% S/. -57.1419 30 75% S/. -60.0020 30 80% S/. -62.5021 30 85% S/. -64.7122 30 90% S/. -66.6723 30 95% S/. -68.4224 3025 3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 30

0% 15% 30% 45% 60% 75% 90% 105%

S/. -500.00

S/. 0.00

S/. 500.00

S/. 1,000.00

S/. 1,500.00

S/. 2,000.00

S/. 2,500.00

S/. 3,000.00

VPN

VPN

r(Costo de capital)

E11
rbogicevic: Tasa de decuento r donde VPN=0, por definición es el TIR
Page 2: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 30

Page 3: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

92 3093 3094 3095 3096 3097 3098 3099 30

100 30101 30102 30103 30104 30105 30106 30107 30108 30109 30110 30111 30112 30113 30114 30115 30116 30117 30118 30119 30120 30121 30122 30123 30124 30125 30126 30127 30128 30129 30130 30131 30132 30133 30134 30135 30136 30137 30138 30139 30

Page 4: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

140 30141 30142 30143 30144 30145 30146 30147 30148 30149 30150 30151 30152 30153 30154 30155 30156 30157 30158 30159 30160 30161 30162 30163 30164 30165 30166 30167 30168 30169 30170 30171 30172 30173 30174 30175 30176 30177 30178 30179 30180 30181 30182 30183 30184 30185 30186 30187 30

Page 5: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

188 30189 30190 30191 30192 30193 30194 30195 30196 30197 30198 30199 30200 30201 30202 30203 30204 30205 30

Page 6: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 8%

VPN= $275 TIR= 30% ∆(TIR-r)= 22%

Respuesta:El VPN=

0% 15% 30% 45% 60% 75% 90% 105%

S/. -500.00

S/. 0.00

S/. 500.00

S/. 1,000.00

S/. 1,500.00

S/. 2,000.00

S/. 2,500.00

S/. 3,000.00

VPN

VPN

r(Costo de capital)

TIR = 30 %

I4
rbogicevic: El VPN = 275 > 0 y TIR= 30% > r=8% Debe hacerse la inversión
L5
rbogicevic: Desviación máxima permisible en el costo de capital para que la decisión no cambie
Page 7: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Año FC( Maillones) r VPN0 10 10.00% S/. -9.891 -8 15.00% S/. -8.272 -8 20.00% S/. -6.853 -8 25.00% S/. -5.62

30.00% S/. -4.5335.00% S/. -3.5740.00% S/. -2.7145.00% S/. -1.9550.00% S/. -1.2655.00% S/. -0.6460.00% S/. -0.0860.74% S/. 0.0070.00% S/. 0.9075.00% S/. 1.3280.00% S/. 1.7185.00% S/. 2.0790.00% S/. 2.4195.00% S/. 2.71

100.00% S/. 3.00

E16
rbogicevic: Tasa de decuento r donde VPN=0, por definición es el TIR
Page 8: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 10%

VPN= S/. -9.89TIR= 60.74%

0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00%

S/. -12.00

S/. -10.00

S/. -8.00

S/. -6.00

S/. -4.00

S/. -2.00

S/. 0.00

S/. 2.00

S/. 4.00

VPN

VPN

r (costo del capital)

Page 9: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00%

S/. -12.00

S/. -10.00

S/. -8.00

S/. -6.00

S/. -4.00

S/. -2.00

S/. 0.00

S/. 2.00

S/. 4.00

VPN

VPN

r (costo del capital)

Page 10: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Libro My Way de Bill Clinton

Año FC (Millones) r VPN(Millones)0 10 1.000% S/. 2.131 -8 1.500% S/. 1.882 -8 2.000% S/. 1.653 -8 2.500% S/. 1.444 5 Decrecimiento 3.000% S/. 1.245 3.5 30% 3.500% S/. 1.056 2.4 4.000% S/. 0.877 1.7 4.500% S/. 0.718 1.2 5.000% S/. 0.559 0.8 5.500% S/. 0.41

10 0.6 6.000% S/. 0.2811 0.4 6.500% S/. 0.1512 0.3 7.165% S/. 0.0013 0.2 7.665% S/. -0.1114 0.1 8.165% S/. -0.2015 0.1 8.665% S/. -0.2916 0.1 9.165% S/. -0.3817 0.0 9.665% S/. -0.4518 0.0 10.165% S/. -0.5319 0.0 10.665% S/. -0.5920 0.0 11.165% S/. -0.6521 0.0 11.665% S/. -0.7122 0.0 12.165% S/. -0.7623 0.0 12.665% S/. -0.8024 0.0 13.165% S/. -0.8425 0.0 13.665% S/. -0.8826 0.0 14.165% S/. -0.9127 0.0 14.665% S/. -0.9428 0.0 15.165% S/. -0.9729 0.0 15.665% S/. -0.9930 0.0 16.165% S/. -1.0131 0.0 16.665% S/. -1.0332 0.0 17.165% S/. -1.0433 0.0 17.665% S/. -1.0534 0.0 18.165% S/. -1.0635 0.0 18.665% S/. -1.0636 0.0 19.165% S/. -1.0637 0.0 19.665% S/. -1.0738 0.0 20.165% S/. -1.0639 0.0 20.665% S/. -1.0640 0.0 21.165% S/. -1.0641 0.0 21.665% S/. -1.0542 0.0 22.165% S/. -1.0443 0.0 22.665% S/. -1.03

C10
rbogicevic: Decrecimiento de las regalias 30% al año a perpetuidad
Page 11: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44 0.0 23.165% S/. -1.0245 0.0 23.665% S/. -1.0046 0.0 24.165% S/. -0.9947 0.0 24.665% S/. -0.9748 0.0 25.165% S/. -0.9649 0.0 25.665% S/. -0.9450 0.0 26.165% S/. -0.9251 0.0 26.665% S/. -0.9052 0.0 27.165% S/. -0.8853 0.0 27.665% S/. -0.8554 0.0 28.165% S/. -0.8355 0.0 28.665% S/. -0.8056 0.0 29.165% S/. -0.7857 0.0 29.665% S/. -0.7558 0.0 30.165% S/. -0.7359 0.0 30.665% S/. -0.7060 0.0 31.165% S/. -0.6761 0.0 31.665% S/. -0.6462 0.0 32.165% S/. -0.6163 0.0 32.665% S/. -0.5864 0.0 33.165% S/. -0.5565 0.0 33.665% S/. -0.5266 0.0 34.165% S/. -0.4967 0.0 34.665% S/. -0.4668 0.0 35.165% S/. -0.4369 0.0 35.665% S/. -0.4070 0.0 36.165% S/. -0.3771 0.0 36.665% S/. -0.3372 0.0 37.165% S/. -0.3073 0.0 37.665% S/. -0.2774 0.0 38.165% S/. -0.2375 0.0 38.665% S/. -0.2076 0.0 39.165% S/. -0.1777 0.0 39.665% S/. -0.1378 0.0 40.165% S/. -0.1079 0.0 40.665% S/. -0.0680 0.0 41.165% S/. -0.0381 0.0 41.170% S/. -0.0382 0.0 41.220% S/. -0.0283 0.0 41.320% S/. -0.0284 0.0 41.330% S/. -0.0285 0.0 41.430% S/. -0.0186 0.0 41.480% S/. -0.0187 0.0 41.580% S/. 0.0088 0.0 42.080% S/. 0.0489 0.0 42.580% S/. 0.0790 0.0 43.080% S/. 0.1191 0.0 43.580% S/. 0.14

Page 12: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

92 0.0 44.080% S/. 0.1893 0.0 44.580% S/. 0.2194 0.0 45.080% S/. 0.2595 0.0 45.580% S/. 0.2896 0.0 46.080% S/. 0.3297 0.0 46.580% S/. 0.3598 0.0 47.080% S/. 0.3999 0.0 47.580% S/. 0.42

100 0.0 48.080% S/. 0.46101 0.0 48.580% S/. 0.49102 0.0 49.080% S/. 0.53103 0.0 49.580% S/. 0.56104 0.0 50.080% S/. 0.60105 0.0 50.580% S/. 0.63106 0.0 51.080% S/. 0.67107 0.0 51.580% S/. 0.70108 0.0 52.080% S/. 0.74109 0.0 52.580% S/. 0.77110 0.0 53.080% S/. 0.81

Page 13: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 10%

VPN(US $ Millone)= S/. -0.50TIR 1= 7.165%TIR 2= 41.580%

0.000% 10.000% 20.000% 30.000% 40.000% 50.000% 60.000%

$ -1.5

$ -1.0

$ -0.5

$ 0.0

$ 0.5

$ 1.0

$ 1.5

$ 2.0

$ 2.5

VPN(Millones)

VPN(Millones)

r ( tasa de descuento)

TIR 1 = 7.165 %

TIR 2 = 41.580 %

I4
rbogicevic: VPN del Libro con el pago de regalias
I5
rbogicevic: La TIR No Existe
Page 14: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

0.000% 10.000% 20.000% 30.000% 40.000% 50.000% 60.000%

$ -1.5

$ -1.0

$ -0.5

$ 0.0

$ 0.5

$ 1.0

$ 1.5

$ 2.0

$ 2.5

VPN(Millones)

VPN(Millones)

r ( tasa de descuento)

TIR 1 = 7.165 %

TIR 2 = 41.580 %

Page 15: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

FastTrack Bike, Inc, Bicicleta de carrera

Escenario con desarrollo de planta a 6 años según el enunciadoAño FC (US $) r VPN(Millones)

0 0 1.00% S/. 1,517,623.90Desarrollo 1 -200000 1.50% S/. 1,390,785.63Desarrollo 2 -200000 2.00% S/. 1,272,597.35Desarrollo 3 -200000 2.50% S/. 1,162,438.12Desarrollo 4 -200000 3.00% S/. 1,059,734.89Desarrollo 5 -200000 3.50% S/. 963,958.53Desarrollo 6 -200000 4.00% S/. 874,620.25

7 300000 4.50% S/. 791,268.278 300000 5.00% S/. 713,484.839 300000 5.50% S/. 640,883.46

10 300000 6.00% S/. 573,106.4211 300000 6.50% S/. 509,822.4812 300000 7.00% S/. 450,724.7513 300000 7.50% S/. 395,528.8114 300000 8.00% S/. 343,970.9115 300000 8.50% S/. 295,806.3916 300000 9.00% S/. 250,808.16

9.50% S/. 208,765.4010.00% S/. 169,482.24

Año FC (US $) 10.50% S/. 132,776.710 0 11.00% S/. 98,479.61

Desarrollo 1 -200000 11.50% S/. 66,433.57Desarrollo 2 -200000 12.00% S/. 36,492.18Desarrollo 3 -200000 12.50% S/. 8,519.17Desarrollo 4 -200000 12.66% S/. 0.00Desarrollo 5 -200000 13.00% S/. -17,612.38Desarrollo 6 -200000 13.50% S/. -42,020.67Desarrollo 7 -200000 14.00% S/. -64,815.87

8 300000 14.50% S/. -86,100.689 300000 15.00% S/. -105,970.89

10 300000 15.50% S/. -124,515.8411 300000 16.00% S/. -141,818.9512 300000 16.50% S/. -157,958.0613 300000 17.00% S/. -173,005.9114 300000 17.50% S/. -187,030.4315 300000 18.00% S/. -200,095.1216 300000 18.50% S/. -212,259.3617 300000 19.00% S/. -223,578.66

19.50% S/. -234,104.9720.00% S/. -243,886.9020.50% S/. -252,969.9621.00% S/. -261,396.7821.50% S/. -269,207.26

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%

S/. -500,000.00

S/. 0.00

S/. 500,000.00

S/. 1,000,000.00

S/. 1,500,000.00

S/. 2,000,000.00

VPN(US$)

VPN(Millones)

r (Costo de Capital)

Axis Title

Page 16: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

22.00% S/. -276,438.8322.50% S/. -283,126.5323.00% S/. -289,303.2523.50% S/. -294,999.8224.00% S/. -300,245.1424.50% S/. -305,066.3825.00% S/. -309,489.0025.50% S/. -313,536.9126.00% S/. -317,232.5926.50% S/. -320,597.1227.00% S/. -323,650.3427.50% S/. -326,410.8828.00% S/. -328,896.2628.50% S/. -331,122.9429.00% S/. -333,106.4129.50% S/. -334,861.2530.00% S/. -336,401.1630.50% S/. -337,739.0631.00% S/. -338,887.0831.50% S/. -339,856.6632.00% S/. -340,658.5732.50% S/. -341,302.9533.00% S/. -341,799.3633.50% S/. -342,156.8034.00% S/. -342,383.7534.50% S/. -342,488.2235.00% S/. -342,477.7235.50% S/. -342,359.3836.00% S/. -342,139.8936.50% S/. -341,825.5837.00% S/. -341,422.3937.50% S/. -340,935.9738.00% S/. -340,371.6038.50% S/. -339,734.3039.00% S/. -339,028.7939.50% S/. -338,259.5340.00% S/. -337,430.7140.50% S/. -336,546.3341.00% S/. -335,610.1141.50% S/. -334,625.6142.00% S/. -333,596.1642.50% S/. -332,524.9143.00% S/. -331,414.8543.50% S/. -330,268.7844.00% S/. -329,089.3744.50% S/. -327,879.1145.00% S/. -326,640.3845.50% S/. -325,375.40

Page 17: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

46.00% S/. -324,086.3046.50% S/. -322,775.0647.00% S/. -321,443.5647.50% S/. -320,093.5848.00% S/. -318,726.8048.50% S/. -317,344.7949.00% S/. -315,949.0649.50% S/. -314,541.0150.00% S/. -313,121.9750.50% S/. -311,693.2051.00% S/. -310,255.8851.50% S/. -308,811.1352.00% S/. -307,360.0052.50% S/. -305,903.4853.00% S/. -304,442.5253.50% S/. -302,977.9954.00% S/. -301,510.7354.50% S/. -300,041.5155.00% S/. -298,571.0855.50% S/. -297,100.12

Page 18: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 10%

Escenario con desarrallo de planta en 6 años:VPN(US $ Millone)= S/. 169,482.24

TIR= 12.66% ∆(TIR-r)= 2.66%

Escenario con desarrallo de planta en 7 años:VPN(US $ Millone)= S/. -27,743.42

TIR= 9.61%

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%

S/. -500,000.00

S/. 0.00

S/. 500,000.00

S/. 1,000,000.00

S/. 1,500,000.00

S/. 2,000,000.00

VPN(US$)

VPN(Millones)

r (Costo de Capital)

Axis Title

I5
rbogicevic: El VPN es positivo, la compañía debería hacer la inversión
I6
rbogicevic: La TIR= 12.66% es mayor que el costo del capital r= 10% TIR>R, corrobora que dado que VPN >0 la TIR >r, entonces se debe hacer la inversión
L6
rbogicevic: Desviación máxima permisible en el costo para que la decisión no cambie
I26
rbogicevic: El VPN se convierte en negativo a más de 6 años, el desarrollo no deberia tomar más de 6 años para que el inversión sea viable
I27
rbogicevic: La TIR corrobora la inviabilidad el proyecto a más de 6 años debido a que TIR=9.61% < r= 10%
Page 19: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

FastTrack Bike, Inc, Bicicleta de carrera

Escenario con desarrollo de planta a 6 años según el enunciadoAño FC (US $) r VPN(Millones)

0 0 1.00% S/. 1,517,623.90Desarrollo 1 -200000 1.50% S/. 1,390,785.63Desarrollo 2 -200000 2.00% S/. 1,272,597.35Desarrollo 3 -200000 2.50% S/. 1,162,438.12Desarrollo 4 -200000 3.00% S/. 1,059,734.89Desarrollo 5 -200000 3.50% S/. 963,958.53Desarrollo 6 -200000 4.00% S/. 874,620.25

7 300000 4.50% S/. 791,268.278 300000 5.00% S/. 713,484.839 300000 5.50% S/. 640,883.46

10 300000 6.00% S/. 573,106.4211 300000 6.50% S/. 509,822.4812 300000 7.00% S/. 450,724.7513 300000 7.50% S/. 395,528.8114 300000 8.00% S/. 343,970.9115 300000 8.50% S/. 295,806.3916 300000 9.00% S/. 250,808.16

9.50% S/. 208,765.4010.00% S/. 169,482.24

Año FC (US $) 10.50% S/. 132,776.710 0 11.00% S/. 98,479.61

Desarrollo 1 -200000 11.50% S/. 66,433.57Desarrollo 2 -200000 12.00% S/. 36,492.18Desarrollo 3 -200000 12.50% S/. 8,519.17Desarrollo 4 -200000 12.66% S/. 0.00Desarrollo 5 -200000 13.00% S/. -17,612.38

6 300000 13.50% S/. -42,020.677 300000 14.00% S/. -64,815.878 300000 14.50% S/. -86,100.689 300000 15.00% S/. -105,970.89

10 300000 15.50% S/. -124,515.8411 300000 16.00% S/. -141,818.9512 300000 16.50% S/. -157,958.0613 300000 17.00% S/. -173,005.9114 300000 17.50% S/. -187,030.4315 300000 18.00% S/. -200,095.12

18.50% S/. -212,259.3619.00% S/. -223,578.6619.50% S/. -234,104.9720.00% S/. -243,886.9020.50% S/. -252,969.9621.00% S/. -261,396.7821.50% S/. -269,207.26

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%

S/. -500,000.00

S/. 0.00

S/. 500,000.00

S/. 1,000,000.00

S/. 1,500,000.00

S/. 2,000,000.00

VPN(US$)

VPN(Millones)

r (Costo de Capital)

Page 20: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

22.00% S/. -276,438.8322.50% S/. -283,126.5323.00% S/. -289,303.2523.50% S/. -294,999.8224.00% S/. -300,245.1424.50% S/. -305,066.3825.00% S/. -309,489.0025.50% S/. -313,536.9126.00% S/. -317,232.5926.50% S/. -320,597.1227.00% S/. -323,650.3427.50% S/. -326,410.8828.00% S/. -328,896.2628.50% S/. -331,122.9429.00% S/. -333,106.4129.50% S/. -334,861.2530.00% S/. -336,401.1630.50% S/. -337,739.0631.00% S/. -338,887.0831.50% S/. -339,856.6632.00% S/. -340,658.5732.50% S/. -341,302.9533.00% S/. -341,799.3633.50% S/. -342,156.8034.00% S/. -342,383.7534.50% S/. -342,488.2235.00% S/. -342,477.7235.50% S/. -342,359.3836.00% S/. -342,139.8936.50% S/. -341,825.5837.00% S/. -341,422.3937.50% S/. -340,935.9738.00% S/. -340,371.6038.50% S/. -339,734.3039.00% S/. -339,028.7939.50% S/. -338,259.5340.00% S/. -337,430.7140.50% S/. -336,546.3341.00% S/. -335,610.1141.50% S/. -334,625.6142.00% S/. -333,596.1642.50% S/. -332,524.9143.00% S/. -331,414.8543.50% S/. -330,268.7844.00% S/. -329,089.3744.50% S/. -327,879.1145.00% S/. -326,640.3845.50% S/. -325,375.40

Page 21: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

46.00% S/. -324,086.3046.50% S/. -322,775.0647.00% S/. -321,443.5647.50% S/. -320,093.5848.00% S/. -318,726.8048.50% S/. -317,344.7949.00% S/. -315,949.0649.50% S/. -314,541.0150.00% S/. -313,121.9750.50% S/. -311,693.2051.00% S/. -310,255.8851.50% S/. -308,811.1352.00% S/. -307,360.0052.50% S/. -305,903.4853.00% S/. -304,442.5253.50% S/. -302,977.9954.00% S/. -301,510.7354.50% S/. -300,041.5155.00% S/. -298,571.0855.50% S/. -297,100.12

Page 22: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital(r) = 14%

Escenario con desarrallo de planta en 6 años:VPN(US $ Millone)= S/. -64,815.87

TIR= 12.66% ∆(TIR-r)= 1.34%

Escenario con desarrallo de planta en 5 años:VPN(US $ Millone)= S/. 126,109.91

TIR= 16.93%

El desarrollo de la planta no deberia tomar mas de 5 años para cambiar la decisión de No invertir en el desarrollo de la planta.

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%

S/. -500,000.00

S/. 0.00

S/. 500,000.00

S/. 1,000,000.00

S/. 1,500,000.00

S/. 2,000,000.00

VPN(US$)

VPN(Millones)

r (Costo de Capital)

I5
rbogicevic: El VPN es negativo, la compañía No debería hacer la inversión
I6
rbogicevic: La TIR= 12.66% es menor que el costo del capital r= 10% TIR<R, corrobora que dado que VPN >0 la TIR <r, entonces NO se debe hacer la inversión
L6
rbogicevic: La Desviación máxima permisible en el costo para que la decisión cambie, debería ser del 1.34%
I25
rbogicevic: El VPN se convierte en positivo con menos de 5 años, el desarrollo no deberia tomar más de 5 años para que la inversión sea viable
I26
rbogicevic: La TIR corrobora la viabilidad del proyecto a menos de 5 años debido a que TIR=16.93% > r= 14%
Page 23: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Mes 0 Mes 1 Mes 2 Mes 3 Mes 4 Mes 5Inversión -$5,000Recuperación $500 $500 $500 $500 $500Flujo -$4,500 -$4,000 -$3,500 -$3,000 -$2,500

C4
rbogicevic:
Page 24: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Mes 6 Mes 7 Mes 8 Mes 9 Mes 10 Mes 11 Mes 12

$500 $500 $500 $500 $500 $500 $500-$2,000 -$1,500 -$1,000 -$500 $0 $500 $1,000

M6
rbogicevic: El Periodo 10 o mes 10 es el periodo en el cual se recupera la inversión
Page 25: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital =

VPN=TIR=

Respuesta:Debido a que el VPN > 0Y el el TIR =30% > r= 30%La regla del TIR está de acuerdo con la del VPN

Page 26: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

8%

S/. 275.0030.00%

Debido a que el VPN > 0Y el el TIR =30% > r= 30%La regla del TIR está de acuerdo con la del VPN

Page 27: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Respuesta:El problema tiene dos TIR, el primero es de 7.165% y el segundo es de 41.580 %La regla del TIR no funciona, lo que se puede concluir de la regla del VPN es que si el costo del capital esta por debajo 7.165% o por arriba de 41.580% se debe aceptar la inversión.ya que para esos rangos el VPN es mayor que CERO

0.000% 10.000% 20.000% 30.000% 40.000% 50.000% 60.000%

$ -1.5

$ -1.0

$ -0.5

$ 0.0

$ 0.5

$ 1.0

$ 1.5

$ 2.0

$ 2.5

VPN(Millones)

VPN(Millones)

r ( tasa de descuento)

TIR 1 = 7.165 %

TIR 2 = 41.580 %

Page 28: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

VPN(US $ Millone)= S/. -0.50

El problema tiene dos TIR, el primero es de 7.165% y el segundo es de 41.580 %La regla del TIR no funciona, lo que se puede concluir de la regla del VPN es que si el costo del capital esta por debajo 7.165% o por arriba de 41.580% se debe aceptar la inversión.

0.000% 10.000% 20.000% 30.000% 40.000% 50.000% 60.000%

$ -1.5

$ -1.0

$ -0.5

$ 0.0

$ 0.5

$ 1.0

$ 1.5

$ 2.0

$ 2.5

VPN(Millones)

VPN(Millones)

r ( tasa de descuento)

TIR 1 = 7.165 %

TIR 2 = 41.580 %

Page 29: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

TEA=(TEM)r=

Año FC (Millones) r VPN(Millones)0 $50,000 1% S/. 99,522.34 VPN=1 $4,400 2% S/. 96,531.50 TIR=2 $4,400 3% S/. 93,797.623 $4,400 4% S/. 91,294.324 $4,400 5% S/. 88,998.315 $4,400 6% S/. 86,888.916 $4,400 7% S/. 84,947.827 $4,400 8% S/. 83,158.748 $4,400 9% S/. 81,507.199 $4,400 10% S/. 79,980.24

10 $4,400 11% S/. 78,566.3711 $4,400 12% S/. 77,255.2512 $4,400 13% S/. 76,037.65

14% S/. 74,905.2915% S/. 73,850.7216% S/. 72,867.2717% S/. 71,948.9018% S/. 71,090.1919% S/. 70,286.2220% S/. 69,532.55

21% S/. 68,825.18 Respuesta:22% S/. 68,160.45 La Regla del TIR no se puede aplicar porque no existe TIR para el problema23% S/. 67,535.06 Nunca intersecta el eje de abcisas para cumplir la condición VPN=024% S/. 66,946.00 La regla de VPN aconseja invertir dado VPN = $ 98,990 que es mayor que CERO25% S/. 66,390.54 y mayor a la inversión incial.26% S/. 65,866.1827% S/. 65,370.6528% S/. 64,901.8829% S/. 64,457.9530% S/. 64,037.1431% S/. 63,637.8532% S/. 63,258.6233% S/. 62,898.1034% S/. 62,555.0635% S/. 62,228.3636% S/. 61,916.9537% S/. 61,619.8738% S/. 61,336.2239% S/. 61,065.1840% S/. 60,805.9841% S/. 60,557.9142% S/. 60,320.3343% S/. 60,092.61

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. 0.00

S/. 20,000.00

S/. 40,000.00

S/. 60,000.00

S/. 80,000.00

S/. 100,000.00

S/. 120,000.00

VPN(US $)

VPN(Millones)

TME(r costo del capital)

C10
rbogicevic: Decrecimiento de las regalias 30% al año a perpetuidad
Page 30: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44% S/. 59,874.2145% S/. 59,664.5846% S/. 59,463.2547% S/. 59,269.7548% S/. 59,083.6749% S/. 58,904.6050% S/. 58,732.1851% S/. 58,566.0552% S/. 58,405.9153% S/. 58,251.4354% S/. 58,102.3555% S/. 57,958.4056% S/. 57,819.3257% S/. 57,684.8858% S/. 57,554.8659% S/. 57,429.0660% S/. 57,307.2861% S/. 57,189.3362% S/. 57,075.0563% S/. 56,964.2764% S/. 56,856.8465% S/. 56,752.6166% S/. 56,651.4467% S/. 56,553.2168% S/. 56,457.7969% S/. 56,365.0670% S/. 56,274.9371% S/. 56,187.2772% S/. 56,102.0073% S/. 56,019.0174% S/. 55,938.2375% S/. 55,859.5676% S/. 55,782.9277% S/. 55,708.2478% S/. 55,635.4579% S/. 55,564.4780% S/. 55,495.2581% S/. 55,427.7182% S/. 55,361.7983% S/. 55,297.4584% S/. 55,234.62

Page 31: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

15.00%1.17%

$98,990Err:523

Respuesta:La Regla del TIR no se puede aplicar porque no existe TIR para el problemaNunca intersecta el eje de abcisas para cumplir la condición VPN=0La regla de VPN aconseja invertir dado VPN = $ 98,990 que es mayor que CEROy mayor a la inversión incial.

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. 0.00

S/. 20,000.00

S/. 40,000.00

S/. 60,000.00

S/. 80,000.00

S/. 100,000.00

S/. 120,000.00

VPN(US $)

VPN(Millones)

TME(r costo del capital)

I3
rbogicevic: TEM calculado a partir del TEM = (1+.TEA)ⁿ-1 donde n = 1/12 para convertir a Taza mensual
Page 32: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Año FC( Millones) r VPN0 -$5,000,000 1.0000% S/. -3,281,041.011 $1,000,000 1.5000% S/. -1,207,220.482 $1,000,000 1.6000% S/. -917,768.203 $1,000,000 2.0187966% S/. -0.00 TIR 14 $1,000,000 2.5000% S/. 652,602.215 $1,000,000 2.6000% S/. 751,503.506 $1,000,000 2.745784% S/. 878,310.697 $1,000,000 2.8000% S/. 920,722.528 $1,000,000 2.9000% S/. 992,843.559 $1,000,000 3.0000% S/. 1,057,674.59

10 $1,000,000 3.1000% S/. 1,115,886.2111 -$100,000 3.2000% S/. 1,168,076.6212 -$100,000 3.3000% S/. 1,214,780.5813 -$100,000 3.4000% S/. 1,256,477.0014 -$100,000 3.5000% S/. 1,293,595.6315 -$100,000 3.6000% S/. 1,326,522.8616 -$100,000 3.7000% S/. 1,355,606.6817 -$100,000 3.8000% S/. 1,381,161.1618 -$100,000 3.9000% S/. 1,403,470.2019 -$100,000 4.0000% S/. 1,422,790.9320 -$100,000 4.1000% S/. 1,439,356.6321 -$100,000 4.2000% S/. 1,453,379.3022 -$100,000 4.3000% S/. 1,465,051.9323 -$100,000 4.4000% S/. 1,474,550.4824 -$100,000 4.5000% S/. 1,482,035.6625 -$100,000 4.6000% S/. 1,487,654.4726 -$100,000 4.7000% S/. 1,491,541.5927 -$100,000 4.8000% S/. 1,493,820.5628 -$100,000 4.9000% S/. 1,494,604.9029 -$100,000 5.438761% S/. 1,477,179.0930 -$100,000 6.0000% S/. 1,429,439.9131 -$100,000 7.0000% S/. 1,297,369.6232 -$100,000 8.0000% S/. 1,131,089.7133 -$100,000 9.0000% S/. 948,312.3834 -$100,000 10.0000% S/. 759,023.8235 -$100,000 10.879183% S/. 591,918.6836 -$100,000 11.8792% S/. 404,295.5237 -$100,000 12.8792% S/. 221,353.8538 -$100,000 13.8792% S/. 44,380.4139 -$100,000 14.1359% S/. 0.00 TIR 240 -$100,000 15.1359% S/. -168,518.0441 -$100,000 16.1359% S/. -329,980.8342 -$100,000 17.1359% S/. -484,339.4643 -$100,000 18.1359% S/. -631,684.32

E8
rbogicevic: TIR 1= 2.0187966%
Page 33: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44 -$100,000 19.1359% S/. -772,194.9345 -$100,000 20.1359% S/. -906,106.3046 -$100,000 21.1359% S/. -1,033,686.0847 -$100,000 22.1359% S/. -1,155,219.1348 -$100,000 23.1359% S/. -1,270,996.8549 -$100,000 24.1359% S/. -1,381,310.0650 -$100,000 25.1359% S/. -1,486,444.1451 -$100,000 26.1359% S/. -1,586,675.9152 -$100,000 27.1359% S/. -1,682,271.5353 -$100,000 28.1359% S/. -1,773,485.4254 -$100,000 29.1359% S/. -1,860,559.5755 -$100,000 30.1359% S/. -1,943,723.3956 -$100,000 31.1359% S/. -2,023,193.7257 -$100,000 32.1359% S/. -2,099,175.1858 -$100,000 33.1359% S/. -2,171,860.5059 -$100,000 34.1359% S/. -2,241,431.0360 -$100,000 35.1359% S/. -2,308,057.2861 -$100,000 36.1359% S/. -2,371,899.4462 -$100,000 37.1359% S/. -2,433,107.9963 -$100,000 38.1359% S/. -2,491,824.2164 -$100,00065 -$100,00066 -$100,00067 -$100,00068 -$100,00069 -$100,00070 -$100,00071 -$100,00072 -$100,00073 -$100,00074 -$100,00075 -$100,00076 -$100,00077 -$100,00078 -$100,00079 -$100,00080 -$100,00081 -$100,00082 -$100,00083 -$100,00084 -$100,00085 -$100,00086 -$100,00087 -$100,00088 -$100,00089 -$100,00090 -$100,00091 -$100,000

Page 34: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

92 -$100,00093 -$100,00094 -$100,00095 -$100,00096 -$100,00097 -$100,00098 -$100,00099 -$100,000

100 -$100,000101 -$100,000102 -$100,000103 -$100,000104 -$100,000105 -$100,000106 -$100,000107 -$100,000108 -$100,000109 -$100,000110 -$100,000111 -$100,000112 -$100,000113 -$100,000114 -$100,000115 -$100,000116 -$100,000117 -$100,000118 -$100,000119 -$100,000120 -$100,000121 -$100,000122 -$100,000123 -$100,000124 -$100,000125 -$100,000126 -$100,000127 -$100,000128 -$100,000129 -$100,000130 -$100,000131 -$100,000132 -$100,000133 -$100,000134 -$100,000135 -$100,000136 -$100,000137 -$100,000138 -$100,000139 -$100,000

Page 35: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

140 -$100,000141 -$100,000142 -$100,000143 -$100,000144 -$100,000145 -$100,000146 -$100,000147 -$100,000148 -$100,000149 -$100,000150 -$100,000151 -$100,000152 -$100,000153 -$100,000154 -$100,000155 -$100,000156 -$100,000157 -$100,000158 -$100,000159 -$100,000160 -$100,000161 -$100,000162 -$100,000163 -$100,000164 -$100,000165 -$100,000166 -$100,000167 -$100,000168 -$100,000169 -$100,000170 -$100,000171 -$100,000172 -$100,000173 -$100,000174 -$100,000175 -$100,000176 -$100,000177 -$100,000178 -$100,000179 -$100,000180 -$100,000181 -$100,000182 -$100,000183 -$100,000184 -$100,000185 -$100,000186 -$100,000187 -$100,000

Page 36: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

188 -$100,000189 -$100,000190 -$100,000191 -$100,000192 -$100,000193 -$100,000194 -$100,000195 -$100,000196 -$100,000197 -$100,000198 -$100,000199 -$100,000200 -$100,000201 -$100,000202 -$100,000203 -$100,000204 -$100,000205 -$100,000

Page 37: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 5.438761%

VPN( 5.438761%)= $1,477,179TIR 1= 2.0187966%TIR 2= 14.1359%

Respuesta:a.- Para un costo de capital de 5.438761%, el VPN = $ 1´477,179 > 0 se debe emprender el negocioPara las tasa 2.745784% el VPN= $ 878,310 > 0 también se recomienda emprender el proyectoPara las tasa 10.879183% el VPN= $ 591,918> 0 también se recomienda emprender el proyectob.- Esta oportunidad no tiene un TIR unico, tiene dos TIR´s , TIR 1= 2.0187966%y TIR 2= 14.1359%c.- La Regla del TIR indica que las inversiones que se encuentran con VPN del lado positivo de lagráfica son las oportunidades que de inversión que debemos aceptar.La mejor oportunidad para esta inversión entre las tres de la pregunta a sería la que tiene uncosto de capital de 5.438761% porque tiene el mayor VPN entre las tres VPN=$!´477,179

0.0000% 10.0000% 20.0000% 30.0000% 40.0000% 50.0000%

S/. -4,000,000.00

S/. -3,000,000.00

S/. -2,000,000.00

S/. -1,000,000.00

S/. 0.00

S/. 1,000,000.00

S/. 2,000,000.00

VPN

VPN

L5
rbogicevic: Desviación máxima permisible en el costo de capital para que la decisión no cambie
Page 38: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

a.- Para un costo de capital de 5.438761%, el VPN = $ 1´477,179 > 0 se debe emprender el negocio

Page 39: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Minera de Carbón

Año FC( Millones) r VPN0 -$120 1.0000% S/. -85.621 $20 2.0000% S/. -20.662 $20 2.9105% S/. -0.00 TIR 13 $20 3.0000% S/. 1.154 $20 4.0000% S/. 8.465 $20 5.0000% S/. 9.886 $20 6.0000% S/. 8.597 $20 7.0000% S/. 5.958 $20 8.0000% S/. 2.629 $20 8.7226% S/. -0.00 TIR 2

10 $20 9.0000% S/. -1.0311 -$2 10.0000% S/. -4.8212 -$2 11.0000% S/. -8.6213 -$2 12.0000% S/. -12.3614 -$2 13.0000% S/. -16.0115 -$2 14.0000% S/. -19.5316 -$2 15.0000% S/. -22.9217 -$2 16.0000% S/. -26.1718 -$2 17.0000% S/. -29.2819 -$2 18.0000% S/. -32.2420 -$2 19.0000% S/. -35.0721 -$2 20.0000% S/. -37.7722 -$2 21.0000% S/. -40.3323 -$2 22.0000% S/. -42.7824 -$2 23.0000% S/. -45.1125 -$2 24.0000% S/. -47.3326 -$2 25.0000% S/. -49.4527 -$2 26.0000% S/. -51.4728 -$2 27.0000% S/. -53.3929 -$2 28.0000% S/. -55.2330 -$2 29.0000% S/. -56.9831 -$2 30.0000% S/. -58.6532 -$2 31.0000% S/. -60.2533 -$2 32.0000% S/. -61.7834 -$2 33.0000% S/. -63.2435 -$2 34.0000% S/. -64.6436 -$2 35.0000% S/. -65.9837 -$2 36.0000% S/. -67.2738 -$2 37.0000% S/. -68.5039 -$2 38.0000% S/. -69.6840 -$2 39.0000% S/. -70.8141 -$2 40.0000% S/. -71.9042 -$243 -$2

Page 40: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44 -$245 -$246 -$247 -$248 -$249 -$250 -$251 -$252 -$253 -$254 -$255 -$256 -$257 -$258 -$259 -$260 -$261 -$262 -$263 -$264 -$265 -$266 -$267 -$268 -$269 -$270 -$271 -$272 -$273 -$274 -$275 -$276 -$277 -$278 -$279 -$280 -$281 -$282 -$283 -$284 -$285 -$286 -$287 -$288 -$289 -$290 -$291 -$2

Page 41: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

92 -$293 -$294 -$295 -$296 -$297 -$298 -$299 -$2

100 -$2101 -$2102 -$2103 -$2104 -$2105 -$2106 -$2107 -$2108 -$2109 -$2110 -$2111 -$2112 -$2113 -$2114 -$2115 -$2116 -$2117 -$2118 -$2119 -$2120 -$2121 -$2122 -$2123 -$2124 -$2125 -$2126 -$2127 -$2128 -$2129 -$2130 -$2131 -$2132 -$2133 -$2134 -$2135 -$2136 -$2137 -$2138 -$2139 -$2

Page 42: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

140 -$2141 -$2142 -$2143 -$2144 -$2145 -$2146 -$2147 -$2148 -$2149 -$2150 -$2151 -$2152 -$2153 -$2154 -$2155 -$2156 -$2157 -$2158 -$2159 -$2160 -$2161 -$2162 -$2163 -$2164 -$2165 -$2166 -$2167 -$2168 -$2169 -$2170 -$2171 -$2172 -$2173 -$2174 -$2175 -$2176 -$2177 -$2178 -$2179 -$2180 -$2181 -$2182 -$2183 -$2184 -$2185 -$2186 -$2187 -$2

Page 43: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

188 -$2189 -$2190 -$2191 -$2192 -$2193 -$2194 -$2195 -$2196 -$2197 -$2198 -$2199 -$2200 -$2201 -$2202 -$2203 -$2204 -$2205 -$2

Page 44: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Costo de Capital = 8.00%

VPN= $2.622

TIR 2= 8.7226%

Respuesta:a.- Como tiene TIR multiples, el rango que nos aconseja el TIR es de costos de capital de2.9105 < r < 8.7226 entre esos valores el VPN el positivo, y esta regla nos aconseja invertir en ese rangomientras la regla de VPN nos aconseja invertir entre los valores de VPN´s entre 8% < r < 8.7226% para cumplir con que la inversión rinda mas que el costo del dinero(8%)

0.0000% 10.0000% 20.0000% 30.0000% 40.0000% 50.0000%

S/. -100.00

S/. -80.00

S/. -60.00

S/. -40.00

S/. -20.00

S/. 0.00

S/. 20.00

VPN

VPN

Zona en la cual el VPN >0 y tasa de retorno > costo del dinero, zon recomendable de inver-tir

I4
rbogicevic: El VPN = 275 > 0 y TIR= 30% > r=8% Debe hacerse la inversión
L5
rbogicevic: Desviación máxima permisible en el costo de capital para que la decisión no cambie
Page 45: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2.9105 < r < 8.7226 entre esos valores el VPN el positivo, y esta regla nos aconseja invertir en ese rangomientras la regla de VPN nos aconseja invertir entre los valores de VPN´s entre 8% < r < 8.7226%

0.0000% 10.0000% 20.0000% 30.0000% 40.0000% 50.0000%

S/. -100.00

S/. -80.00

S/. -60.00

S/. -40.00

S/. -20.00

S/. 0.00

S/. 20.00

VPN

VPN

Zona en la cual el VPN >0 y tasa de retorno > costo del dinero, zon recomendable de inver-tir

Page 46: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Mina de Oro en Sudafrica

Año FC( Millones) r VPN0 -$250 1% S/. -233.831 $20 2% S/. -86.902 $20 3% S/. -44.343 $20 4% S/. -35.204 $20 5% S/. -38.445 $20 6% S/. -46.586 $20 7% S/. -56.587 $20 8% S/. -67.058 $20 9% S/. -77.349 $20 10% S/. -87.16

10 $20 11% S/. -96.3711 $20 12% S/. -104.9312 $20 13% S/. -112.8413 $20 14% S/. -120.1414 $20 15% S/. -126.8515 $20 16% S/. -133.0316 $20 17% S/. -138.7217 $20 18% S/. -143.9618 $20 19% S/. -148.7919 $20 20% S/. -153.2620 $20 21% S/. -157.3921 -$5 22% S/. -161.2222 -$5 23% S/. -164.7723 -$5 24% S/. -168.0824 -$5 25% S/. -171.1525 -$5 26% S/. -174.0226 -$5 27% S/. -176.7027 -$5 28% S/. -179.2128 -$5 29% S/. -181.5629 -$5 30% S/. -183.7730 -$5 31% S/. -185.8531 -$5 32% S/. -187.8032 -$5 33% S/. -189.6533 -$5 34% S/. -191.3934 -$5 35% S/. -193.0335 -$5 36% S/. -194.5936 -$5 37% S/. -196.0737 -$5 38% S/. -197.4738 -$5 39% S/. -198.8139 -$5 40% S/. -200.0740 -$5 41% S/. -201.2841 -$5 42% S/. -202.4342 -$5 43% S/. -203.5343 -$5 44% S/. -204.58

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

S/. -250.00

S/. -200.00

S/. -150.00

S/. -100.00

S/. -50.00

S/. 0.00

VPN

VPN

r (Costo de Capital)

C6
rbogicevic: Flujo= 30-10= 20 US30 Millones produce US10 MillonesCosto de operación de la mina
Page 47: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

44 -$5 45% S/. -205.5945 -$5 46% S/. -206.5546 -$5 47% S/. -207.4747 -$5 48% S/. -208.3548 -$5 49% S/. -209.2049 -$5 50% S/. -210.0250 -$5 51% S/. -210.8051 -$5 52% S/. -211.5552 -$5 53% S/. -212.2753 -$5 54% S/. -212.9754 -$5 55% S/. -213.6455 -$5 56% S/. -214.2956 -$5 57% S/. -214.9257 -$5 58% S/. -215.5258 -$5 59% S/. -216.1159 -$5 60% S/. -216.6760 -$5 61% S/. -217.2261 -$5 62% S/. -217.7462 -$5 63% S/. -218.2663 -$5 64% S/. -218.7564 -$5 65% S/. -219.2365 -$5 66% S/. -219.7066 -$5 67% S/. -220.1567 -$5 68% S/. -220.5968 -$5 69% S/. -221.0269 -$5 70% S/. -221.4370 -$5 71% S/. -221.8371 -$5 72% S/. -222.2272 -$5 73% S/. -222.6073 -$5 74% S/. -222.9774 -$5 75% S/. -223.3375 -$5 76% S/. -223.6876 -$5 77% S/. -224.0377 -$578 -$579 -$580 -$581 -$582 -$583 -$584 -$585 -$586 -$587 -$588 -$589 -$590 -$591 -$5

Page 48: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

92 -$593 -$594 -$595 -$596 -$597 -$598 -$599 -$5

100 -$5101 -$5102 -$5103 -$5104 -$5105 -$5106 -$5107 -$5108 -$5109 -$5110 -$5111 -$5112 -$5113 -$5114 -$5115 -$5116 -$5117 -$5118 -$5119 -$5120 -$5121 -$5122 -$5123 -$5124 -$5125 -$5126 -$5127 -$5128 -$5129 -$5130 -$5131 -$5132 -$5133 -$5134 -$5135 -$5136 -$5137 -$5138 -$5139 -$5

Page 49: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

140 -$5141 -$5142 -$5143 -$5144 -$5145 -$5146 -$5147 -$5148 -$5149 -$5150 -$5151 -$5152 -$5153 -$5154 -$5155 -$5156 -$5157 -$5158 -$5159 -$5160 -$5161 -$5162 -$5163 -$5164 -$5165 -$5166 -$5167 -$5168 -$5169 -$5170 -$5171 -$5172 -$5173 -$5174 -$5175 -$5176 -$5177 -$5178 -$5179 -$5180 -$5181 -$5182 -$5183 -$5184 -$5185 -$5186 -$5187 -$5

Page 50: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

188 -$5189 -$5190 -$5191 -$5192 -$5193 -$5194 -$5195 -$5196 -$5197 -$5198 -$5199 -$5200 -$5201 -$5202 -$5203 -$5204 -$5205 -$5

Page 51: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

TIR = Err:523

Respuesta:La inversión no tiene TIR, la curva nunca intersecta el eje de abcisas (r costo de capital)Los VPN siempre son negativos, la inversión no es rentable.

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

S/. -250.00

S/. -200.00

S/. -150.00

S/. -100.00

S/. -50.00

S/. 0.00

VPN

VPN

r (Costo de Capital)

La inversión no tiene TIR, los valores de VPN nunca superan a CERO

I4
rbogicevic: No existe TIR
Page 52: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

S/. -250.00

S/. -200.00

S/. -150.00

S/. -100.00

S/. -50.00

S/. 0.00

VPN

VPN

r (Costo de Capital)

Page 53: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Inversion Inicial $100 millonesBeneficio periodico $30 millones

8%

VP(VEA)= $275

Respuesta:Este valor coincide con el cálculo anterior del VPN del proyecto del problema 1La empresa debería realizar la inversión si el costo del capital es menor a 8%

r(tasa de descuento para el periodo)

F7
rbogicevic: Se aplicó la fórmula del VEA a perpetuidad VP(VEA)=(30/r)-100
Page 54: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Este valor coincide con el cálculo anterior del VPN del proyecto del problema 1La empresa debería realizar la inversión si el costo del capital es menor a 8%

Page 55: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Planta producto novedoso Costo de Capital 12%

Año FC( Millones) VPN= $14.11500 -$1001 $15 TIR = 14.1350%2 $153 $154 $155 $15 Año 0 16 $15 Capital 100 957 $15 Flujo de efectivo 158 $15 Cargo Capital -129 $15 Depreciación -5

10 $15 Valor de Rescate11 $15 VEA -212 $15 VEAn -1.7857142913 $15 VP(VEA)= Σ VEAn= $14.115014 $1515 $15

16 $15 Respuesta:17 $15 Se comprueba que los valores de VPN y VP(VEA) son iguales18 $1519 $1520 $35

r VPN1% Err:5222% Err:5223% Err:5224% Err:5225% Err:5226% Err:5227% Err:5228% Err:5229% Err:522

10% Err:52211% Err:52212% Err:52213% Err:52214% Err:522

14.1350% Err:52215% Err:52216% Err:52217% Err:52218% Err:52219% Err:522

VPN = VP(VEA)

F4
rbogicevic: El VPN = 275 > 0 y TIR= 30% > r=8% Debe hacerse la inversión
C6
rbogicevic:
F6
rbogicevic: No existe TIR
C25
rbogicevic: Se agregó el valor de resxate de la plantaq FC(20)= 15+20=35
Page 56: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

20% Err:52221% Err:52222% Err:52223% Err:52224% Err:52225% Err:52226% Err:52227% Err:52228% Err:52229% Err:52230% Err:52231% Err:52232% Err:52233% Err:52234% Err:52235% Err:52236% Err:52237% Err:52238% Err:52239% Err:52240% Err:52241% Err:52242% Err:52243% Err:52244% Err:52245% Err:52246% Err:52247% Err:52248% Err:52249% Err:52250% Err:52251% Err:52252% Err:52253% Err:52254% Err:52255% Err:52256% Err:52257% Err:52258% Err:52259% Err:52260% Err:522

Page 57: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

depreciación 5

2 3 4 5 6 7 890 85 80 75 70 65 6015 15 15 15 15 15 15

-11.4 -10.8 -10.2 -9.6 -9 -8.4 -7.8-5 -5 -5 -5 -5 -5 -5

-1.4 -0.8 -0.2 0.4 1 1.6 2.2-1.116071429 -0.5694242 -0.12710362 0.22697074 0.50663112 0.72375874 0.8885431

Se comprueba que los valores de VPN y VP(VEA) son iguales

VPN = VP(VEA)

I8
rbogicevic: Depreciación Capital / Periodo 100/20=5
Page 58: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

9 10 11 12 13 14 15 1655 50 45 40 35 30 25 2015 15 15 15 15 15 15 15

-7.2 -6.6 -6 -5.4 -4.8 -4.2 -3.6 -3-5 -5 -5 -5 -5 -5 -5 -5

2.8 3.4 4 4.6 5.2 5.8 6.4 71.00970807 1.094709 1.14990442 1.18070543 1.19170579 1.18679491 1.16925607 1.14185163

Page 59: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

17 18 19 2015 10 5 015 15 15 15

-2.4 -1.8 -1.2 -0.6-5 -5 -5 -5

207.6 8.2 8.8 29.4

1.10689699 1.06632464 1.02173964 3.04780289 14.1150

Page 60: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Periodo 0 Periodo 1 Periodo 2

FC (US Millones) -10 5 2-10 -5 -3

+

3 +

3.5 años

VPN = $0.31 Millones

Respuesta:Si se requiere u periodo de recuperación de 2 años no se debe hacer la inversión ya que el periodo de recuperación cálculado es de 3.5 añosSin embargo la regla del VPN nos aconseja realizare la pelicula dado que VPN = US 310,000 que cumple la regla VPN > 0

Periodo de

Recuperación =

Año anterior a la

recuperación

total

Periodo de Recuperación =

Periodo de Recuperación =

Page 61: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Periodo 3 Periodo 4 Periodo 5

2 2 2-1 1 3

/

1 / 2

Si se requiere u periodo de recuperación de 2 años no se debe hacer la inversión ya que el periodo de recuperación cálculado es de 3.5 añosSin embargo la regla del VPN nos aconseja realizare la pelicula dado que VPN = US 310,000 que

Costo no

recuperado al

inicio del año

Flujo de efectivo

durante el año recupación

Page 62: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Respuesta:

Sabiendo que es importante evaluar primero La regla del Valor Presente Neto sea Mayor que CERO, y mas aun un valor aceptable Que permita ganancias a la compañía, nosotros buscariamos una tasa de referencia de mercado que haya conseguido la empresao que corresponda al riesgo del sector, calculariamos el VPN y si cumple ( VPN > 0) y el TIR que se encuentre sea mayor a la tasa de descuento correspondiente al sector y un rango de seguridad recomendaría invertir en el proyecto, de lo contrario alertariamosen no invertir en ese proyecto.

Page 63: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Sabiendo que es importante evaluar primero La regla del Valor Presente Neto sea Mayor que CERO, y mas aun un valor aceptable Que permita ganancias a la compañía, nosotros buscariamos una tasa de referencia de mercado que haya conseguido la empresao que corresponda al riesgo del sector, calculariamos el VPN y si cumple ( VPN > 0) y el TIR que se encuentre sea mayor a la tasa de descuento correspondiente al sector y un rango de seguridad recomendaría invertir en el proyecto, de lo contrario alertariamos

Page 64: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Inversión A Inversión B rA VPNA rB-10 -10 1% S/. 163.99 1%2 1.5 3% S/. 56.51 3%2 1.53 5% S/. 30.00 5%2 1.5606 6% S/. 23.33 6%2 1.591812 7% S/. 18.57 7%2 1.62364824 8% S/. 15.00 8%2 1.656121205 9% S/. 12.22 9%2 1.689243629 10% S/. 10.00 10%2 1.723028501 11% S/. 8.18 11%2 1.757489072 12% S/. 6.67 12%2 1.792638853 13% S/. 5.38 13%2 1.82849163 14% S/. 4.29 14%2 1.865061463 15% S/. 3.33 15%2 1.902362692 16% S/. 2.50 16%2 1.940409946 17% S/. 1.76 17%2 1.979218145 18% S/. 1.11 18%2 2.018802507 19% S/. 0.53 19%2 2.059178558 20% S/. 0.00 20%2 2.100362129 21% S/. -0.48 21%2 2.142369371 22% S/. -0.91 22%2 2.185216759 23% S/. -1.30 23%2 2.228921094 24% S/. -1.67 24%2 2.273499516 25% S/. -2.00 25%2 2.318969506 26% S/. -2.31 26%2 2.365348896 27% S/. -2.59 27%2 2.412655874 28% S/. -2.86 28%2 2.460908992 29% S/. -3.10 29%2 2.510127172 30% S/. -3.33 30%2 2.560329715 31% S/. -3.55 31%2 2.611536309 32% S/. -3.75 32%2 2.663767035 33% S/. -3.94 33%2 2.717042376 34% S/. -4.12 34%2 2.771383224 35% S/. -4.29 35%2 2.826810888 36% S/. -4.44 36%2 2.883347106 37% S/. -4.59 37%2 2.941014048 38% S/. -4.74 38%2 2.999834329 39% S/. -4.87 39%2 3.059831016 40% S/. -5.00 40%2 3.121027636 41% S/. -5.12 41%2 3.183448189 42% S/. -5.24 42%2 3.247117152 43% S/. -5.35 43%2 3.312059495 44% S/. -5.45 44%2 3.378300685 45% S/. -5.56 45%2 3.445866699 46% S/. -5.65 46%

Page 65: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 3.514784033 47% S/. -5.74 47%2 3.585079714 48% S/. -5.83 48%2 3.656781308 49% S/. -5.92 49%2 3.729916934 50% S/. -6.00 50%2 3.804515273 51% S/. -6.08 51%2 3.880605578 52% S/. -6.15 52%2 3.95821769 53% S/. -6.23 53%2 4.037382044 54% S/. -6.30 54%2 4.118129684 55% S/. -6.36 55%2 4.200492278 56% S/. -6.43 56%2 4.284502124 57% S/. -6.49 57%2 4.370192166 58% S/. -6.55 58%2 4.45759601 59% S/. -6.61 59%2 4.54674793 60% S/. -6.67 60%2 4.637682888 61% S/. -6.72 61%2 4.730436546 62% S/. -6.77 62%2 4.825045277 63% S/. -6.83 63%2 4.921546183 64% S/. -6.88 64%2 5.019977106 65% S/. -6.92 65%2 5.120376648 66% S/. -6.97 66%2 5.222784181 67% S/. -7.01 67%2 5.327239865 68% S/. -7.06 68%2 5.433784662 69% S/. -7.10 69%2 5.542460355 70% S/. -7.14 70%2 5.653309563 71% S/. -7.18 71%2 5.766375754 72% S/. -7.22 72%2 5.881703269 73% S/. -7.26 73%2 5.999337334 74% S/. -7.30 74%2 6.119324081 75% S/. -7.33 75%2 6.241710563 76% S/. -7.37 76%2 6.366544774 77% S/. -7.40 77%2 6.493875669 78% S/. -7.44 78%2 6.623753183 79% S/. -7.47 79%2 6.756228246 80% S/. -7.50 80%2 6.891352811 81% S/. -7.53 81%2 7.029179867 82% S/. -8.13 82%2 7.1697634652 7.3131587342 7.4594219092 7.6086103472 7.7607825542 7.9159982052 8.0743181692 8.2358045332 8.4005206232 8.5685310362 8.7399016562 8.914699689

Page 66: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 9.0929936832 9.2748535572 9.4603506282 9.6495576412 9.8425487932 10.039399772 10.240187762 10.444991522 10.653891352 10.866969182 11.084308562 11.305994732 11.532114632 11.762756922 11.998012062 12.23797232 12.482731742 12.732386382 12.987034112 13.246774792 13.511710292 13.781944492 14.057583382 14.338735052 14.625509752 14.918019942 15.216380342 15.520707952 15.831122112 16.147744552 16.470699442 16.800113432 17.13611572 17.478838012 17.828414772 18.184983072 18.548682732 18.919656392 19.298049512 19.68401052 20.077690712 20.479244532 20.888829422 21.306606012 21.732738132 22.167392892 22.610740752 23.06295556

Page 67: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 23.524214672 23.994698972 24.474592952 24.964084812 25.46336652 25.972633832 26.492086512 27.021928242 27.56236682 28.113614142 28.675886422 29.249404152 29.834392232 30.431080082 31.039701682 31.660495712 32.293705632 32.939579742 33.598371332 34.270338762 34.955745542 35.654860452 36.367957662 37.095316812 37.837223152 38.593967612 39.365846962 40.15316392 40.956227182 41.775351722 42.610858762 43.463075932 44.332337452 45.21898422 46.123363882 47.045831162 47.986747782 48.946482742 49.925412392 50.923920642 51.942399052 52.981247042 54.040871982 55.121689422 56.22412322 57.348605672 58.495577782 59.66548934

Page 68: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 60.858799122 62.075975112 63.317494612 64.58384452 65.875521392 67.193031822 68.536892452 69.90763032 71.305782912 72.731898572 74.186536542 75.670267272 77.183672622 78.727346072 80.301892992 81.907930852 83.546089472 85.217011262 86.921351482 88.659778512 90.432974082 92.241633562 94.086466232 95.968195562 97.887559472 99.845310662 101.84221692 103.8790612

Page 69: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

VPNBS/. 970.43 a)S/. 119.70 TIR A = 20%

S/. 39.87 TIR B = 17%S/. 27.49 B)S/. 20.00 Costo de Capital= 7%S/. 15.00S/. 11.43 VAN A = S/. 18.57

S/. 8.75 VAN B = S/. 20.00S/. 6.67S/. 5.00 Respuesta:S/. 3.64 a).- La Inversión A tiene mayor TIRS/. 2.50 TIR A = 20% > TIR B = 17%S/. 1.54 b).- Le VPN B(Inversión B) es la mas elevadaS/. 0.71 VPN B = US 20 Millo> VPN A = US 18.57Millo.

S/. -0.00 VPN B > VPN AS/. -0.63 c) La TIR mas elevada lleva a la respuesta S/. -1.18 correcta, cuando ocurre primero que la S/. -1.67 VPN es mayor. El criterio de la VPN prima.S/. -2.11S/. -2.50S/. -2.86S/. -3.18S/. -3.48S/. -3.75S/. -4.00S/. -4.23S/. -4.44S/. -4.64S/. -4.83S/. -5.00S/. -5.16S/. -5.31S/. -5.45S/. -5.59S/. -5.71S/. -5.83S/. -5.95S/. -6.05S/. -6.15S/. -6.25S/. -6.34S/. -6.43S/. -6.51S/. -6.59

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -20.00

S/. 0.00

S/. 20.00

S/. 40.00

S/. 60.00

S/. 80.00

S/. 100.00

S/. 120.00

S/. 140.00

S/. 160.00

S/. 180.00

VPNA

VPNA

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -200.00

S/. 0.00

S/. 200.00

S/. 400.00

S/. 600.00

S/. 800.00

S/. 1,000.00

S/. 1,200.00

VPNB

VPNB

Page 70: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

S/. -6.67S/. -6.74S/. -6.81S/. -6.88S/. -6.94S/. -7.00S/. -7.06S/. -7.12S/. -7.17S/. -7.22S/. -7.27S/. -7.32S/. -7.37S/. -7.41S/. -7.46S/. -7.50S/. -7.54S/. -7.58S/. -7.62S/. -7.66S/. -7.69S/. -7.73S/. -7.76S/. -7.79S/. -7.83S/. -7.86S/. -7.89S/. -7.92S/. -7.95S/. -7.97S/. -8.00S/. -8.03S/. -8.05S/. -8.08S/. -8.10S/. -8.13

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -200.00

S/. 0.00

S/. 200.00

S/. 400.00

S/. 600.00

S/. 800.00

S/. 1,000.00

S/. 1,200.00

VPNB

VPNB

Page 71: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -20.00

S/. 0.00

S/. 20.00

S/. 40.00

S/. 60.00

S/. 80.00

S/. 100.00

S/. 120.00

S/. 140.00

S/. 160.00

S/. 180.00

VPNA

VPNA

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -200.00

S/. 0.00

S/. 200.00

S/. 400.00

S/. 600.00

S/. 800.00

S/. 1,000.00

S/. 1,200.00

VPNB

VPNB

Page 72: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

0% 10% 20% 30% 40% 50% 60% 70% 80% 90%S/. -200.00

S/. 0.00

S/. 200.00

S/. 400.00

S/. 600.00

S/. 800.00

S/. 1,000.00

S/. 1,200.00

VPNB

VPNB

Page 73: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Inversión A Inversión B rA VPNA rB VPNB-10 -10 1% S/. 163.99 1% S/. 970.432 1.5 3% S/. 56.51 3% S/. 119.702 1.53 5% S/. 30.00 5% S/. 39.872 1.5606 6% S/. 23.33 6% S/. 27.49

2 1.591812 7% S/. 18.57 7% S/. 20.002 1.62364824 8% S/. 15.00 8% S/. 15.002 1.656121205 9% S/. 12.22 9% S/. 11.432 1.689243629 10% S/. 10.00 10% S/. 8.752 1.723028501 11% S/. 8.18 11% S/. 6.672 1.757489072 12% S/. 6.67 12% S/. 5.002 1.792638853 13% S/. 5.38 13% S/. 3.642 1.82849163 14% S/. 4.29 14% S/. 2.502 1.865061463 15% S/. 3.33 15% S/. 1.542 1.902362692 16% S/. 2.50 16% S/. 0.712 1.940409946 17% S/. 1.76 17% S/. -0.002 1.979218145 18% S/. 1.11 18% S/. -0.632 2.018802507 19% S/. 0.53 19% S/. -1.182 2.059178558 20% S/. 0.00 20% S/. -1.672 2.100362129 21% S/. -0.48 21% S/. -2.112 2.142369371 22% S/. -0.91 22% S/. -2.502 2.185216759 23% S/. -1.30 23% S/. -2.862 2.228921094 24% S/. -1.67 24% S/. -3.182 2.273499516 25% S/. -2.00 25% S/. -3.482 2.318969506 26% S/. -2.31 26% S/. -3.752 2.365348896 27% S/. -2.59 27% S/. -4.002 2.412655874 28% S/. -2.86 28% S/. -4.232 2.460908992 29% S/. -3.10 29% S/. -4.442 2.510127172 30% S/. -3.33 30% S/. -4.642 2.560329715 31% S/. -3.55 31% S/. -4.832 2.611536309 32% S/. -3.75 32% S/. -5.002 2.663767035 33% S/. -3.94 33% S/. -5.162 2.717042376 34% S/. -4.12 34% S/. -5.312 2.771383224 35% S/. -4.29 35% S/. -5.452 2.826810888 36% S/. -4.44 36% S/. -5.592 2.883347106 37% S/. -4.59 37% S/. -5.712 2.941014048 38% S/. -4.74 38% S/. -5.832 2.999834329 39% S/. -4.87 39% S/. -5.952 3.059831016 40% S/. -5.00 40% S/. -6.052 3.121027636 41% S/. -5.12 41% S/. -6.152 3.183448189 42% S/. -5.24 42% S/. -6.252 3.247117152 43% S/. -5.35 43% S/. -6.342 3.312059495 44% S/. -5.45 44% S/. -6.432 3.378300685 45% S/. -5.56 45% S/. -6.512 3.445866699 46% S/. -5.65 46% S/. -6.59

Page 74: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 3.514784033 47% S/. -5.74 47% S/. -6.672 3.585079714 48% S/. -5.83 48% S/. -6.742 3.656781308 49% S/. -5.92 49% S/. -6.812 3.729916934 50% S/. -6.00 50% S/. -6.882 3.804515273 51% S/. -6.08 51% S/. -6.942 3.880605578 52% S/. -6.15 52% S/. -7.002 3.95821769 53% S/. -6.23 53% S/. -7.062 4.037382044 54% S/. -6.30 54% S/. -7.122 4.118129684 55% S/. -6.36 55% S/. -7.172 4.200492278 56% S/. -6.43 56% S/. -7.222 4.284502124 57% S/. -6.49 57% S/. -7.272 4.370192166 58% S/. -6.55 58% S/. -7.322 4.45759601 59% S/. -6.61 59% S/. -7.372 4.54674793 60% S/. -6.67 60% S/. -7.412 4.637682888 61% S/. -6.72 61% S/. -7.462 4.730436546 62% S/. -6.77 62% S/. -7.502 4.825045277 63% S/. -6.83 63% S/. -7.542 4.921546183 64% S/. -6.88 64% S/. -7.582 5.019977106 65% S/. -6.92 65% S/. -7.622 5.120376648 66% S/. -6.97 66% S/. -7.662 5.222784181 67% S/. -7.01 67% S/. -7.692 5.327239865 68% S/. -7.06 68% S/. -7.732 5.433784662 69% S/. -7.10 69% S/. -7.762 5.542460355 70% S/. -7.14 70% S/. -7.792 5.653309563 71% S/. -7.18 71% S/. -7.832 5.766375754 72% S/. -7.22 72% S/. -7.862 5.881703269 73% S/. -7.26 73% S/. -7.892 5.999337334 74% S/. -7.30 74% S/. -7.922 6.119324081 75% S/. -7.33 75% S/. -7.952 6.241710563 76% S/. -7.37 76% S/. -7.972 6.366544774 77% S/. -7.40 77% S/. -8.002 6.493875669 78% S/. -7.44 78% S/. -8.032 6.623753183 79% S/. -7.47 79% S/. -8.052 6.756228246 80% S/. -7.50 80% S/. -8.082 6.891352811 81% S/. -7.53 81% S/. -8.102 7.029179867 82% S/. -7.56 82% S/. -8.132 7.1697634652 7.3131587342 7.4594219092 7.6086103472 7.7607825542 7.9159982052 8.0743181692 8.2358045332 8.4005206232 8.5685310362 8.7399016562 8.914699689

Page 75: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 9.0929936832 9.2748535572 9.4603506282 9.6495576412 9.8425487932 10.039399772 10.240187762 10.444991522 10.653891352 10.866969182 11.084308562 11.305994732 11.532114632 11.762756922 11.998012062 12.23797232 12.482731742 12.732386382 12.987034112 13.246774792 13.511710292 13.781944492 14.057583382 14.338735052 14.625509752 14.918019942 15.216380342 15.520707952 15.831122112 16.147744552 16.470699442 16.800113432 17.13611572 17.478838012 17.828414772 18.184983072 18.548682732 18.919656392 19.298049512 19.68401052 20.077690712 20.479244532 20.888829422 21.306606012 21.732738132 22.167392892 22.610740752 23.06295556

Page 76: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 23.524214672 23.994698972 24.474592952 24.964084812 25.46336652 25.972633832 26.492086512 27.021928242 27.56236682 28.113614142 28.675886422 29.249404152 29.834392232 30.431080082 31.039701682 31.660495712 32.293705632 32.939579742 33.598371332 34.270338762 34.955745542 35.654860452 36.367957662 37.095316812 37.837223152 38.593967612 39.365846962 40.15316392 40.956227182 41.775351722 42.610858762 43.463075932 44.332337452 45.21898422 46.123363882 47.045831162 47.986747782 48.946482742 49.925412392 50.923920642 51.942399052 52.981247042 54.040871982 55.121689422 56.22412322 57.348605672 58.495577782 59.66548934

Page 77: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

2 60.858799122 62.075975112 63.317494612 64.58384452 65.875521392 67.193031822 68.536892452 69.90763032 71.305782912 72.731898572 74.186536542 75.670267272 77.183672622 78.727346072 80.301892992 81.907930852 83.546089472 85.217011262 86.921351482 88.659778512 90.432974082 92.241633562 94.086466232 95.968195562 97.887559472 99.845310662 101.84221692 103.8790612

Page 78: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

VPN = 1.5 - 2r + 0.02 R

El TIR Incremental se da cuando VPN de la diferencia es igual a CERO

0 = 1.5 - 2r + 0.02 R

TIR Incremental = 8%

Respuesta:Se deberia aceptar las inversiones que tengan menor tasa o costo del capital menor a 8 %

0% 5% 10% 15% 20% 25% 30%S/. -10.00

S/. 0.00

S/. 10.00

S/. 20.00

S/. 30.00

S/. 40.00

S/. 50.00

S/. 60.00

S/. 70.00

S/. 80.00

VPNA

rB

VPNB

TIR Incremental = 8 %

Page 79: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Flujos de efectivo al final del año(miles de $)

Proyecto 0 1 2 TIRCasita -30 15 20 10.4%Fuente -80 39 52 8.6%

-50 24 32 7.52%

r VPN Casita r VPN Fuente1% $4.46 1% $9.59 2% $3.93 2% $8.22 3% $3.42 3% $6.88 4% $2.91 4% $5.58 5% $2.43 5% $4.31 6% $1.95 6% $3.07

7.52% $1.25 7.52% $1.25 8% $1.04 8.6% $0.00 9% $0.60 10% -$1.13

10.0% $0.17 11% -$2.23 10.4% $0.00 12% -$3.30 11% -$0.42 13% -$4.35 12% -$0.82 14% -$5.38 13% -$1.22 15% -$6.38 14% -$1.60 16% -$7.35 15% -$1.98 17% -$8.31 16% -$2.35 18% -$9.24 17% -$2.71 19% -$10.15 18% -$3.06 20% -$11.04 19% -$3.41 21% -$11.91 20% -$3.74 22% -$12.76 21% -$4.07 23% -$13.59 22% -$4.39 24% -$14.41 23% -$4.71 25% -$15.21 24% -$5.02 26% -$15.99 25% -$5.32 27% -$16.75 26% -$5.61 28% -$17.50

Flujos de Efectivo incrementales

F19
rbogicevic: TIR Proyecto Fuente
C22
rbogicevic: TIR Proyecto Casita
Page 80: Ejercicios Capitulo 6 v2.0 Versión Excel 2003
Page 81: Ejercicios Capitulo 6 v2.0 Versión Excel 2003

Repuesta:Si el costo de capital es del 8% se recomienda escoger a partir del TIR incrementalque es del 7.52% la curva del proyecto Casita, debido que es el que tiene mayor VPNel gráfico muestra que la línea azul corresponde al "proyecto casita" tiene un TIR = 10.4% y sus valores de VPN son mayores en el rango del costo del capital de 8%

0% 5% 10% 15% 20% 25% 30%

-$15.00

-$10.00

-$5.00

$0.00

$5.00

$10.00

$15.00

VPN CasitaVPN Fuente

r(Costo de Capital)

VPN ($ miles)

TIR Incremental 7.52%

TIR Fuente= 8.6%TIR Fuente= 8.6%

TIR Casita= 10.4%TIR Casita= 10.4%