ACT4-6.xlsx - a w k 40 12 tx=35 60 15(0.40(0.12 1...

This preview shows 1 out of 8 pages.

a) w k Deuda bancaria 40% 12% tx=35% Capital Social 60% 15% waac = (0.40) (0.12) ( 1 - 0.35) + (0.60 ) (0.15) 0.1212 waac =12.12% b) Inversión Año FEN* Factor de DescuFENd 0 -$1,350,000 -$1,350,000 1 $355,000 0.8919015341 $316,625.04 2 $369,000 0.7954883465 $293,535.20 3 $383,700 0.7094972766 $272,234.11 4 $399,135 0.6328017094 $252,573.31 5 $515,342 0.5643968154 $290,857.38 VPN $75,825.04 c) TIR Año FEN* Factor de DescuFENd tasa 0 -$1,350,000 -$1,350,000 0.2 1 $355,000 0.8333333333 $295,833.33 2 $369,000 0.6944444444 $256,250.00 3 $383,700 0.5787037037 $222,048.61 4 $399,135 0.4822530864 $192,484.09 5 $515,342 0.401877572 $207,104.39 VPN -$176,279.58 Datos k1 0.12 --> $75,825.04 k2 0.20 --> -$176,279.58 K2-k1 = 0.08 dif * VPN >0 5975.01341646 resultado / VPN1 - VPN2 0.0237 TIR = 0.1449 TIR = 14.49% d) Índice de Rentabilidad IR = 1 + VPN / Io
Image of page 1

Subscribe to view the full document.

IR = 1+ 0.0562 IR = 1.0562 e) PRI Descontado Año FENd acumulando 0 1 295,833.33 295,833.33 2 256,250.00 552,083.33 3 222,048.61 774,131.94 4 192,484.09 966,616.03 4 5 207,104.39 1,173,720.42 PRI Descontado = 4 + 383,383.97 1,173,720.42 PRI Descontado = 4+ 0.3266399415 PRI Descontado = 4.3266399415 a) Tasa Promedio de Rendimiento b) Periodo de recuperación de la inversión Año FEN* Acumulado 0 1 355,000.00 355,000.00 2 369,000.00 724,000.00 3 383,700.00 1,107,700.00 242,300.00 0.6070627732 4 399,135.00 1,506,835.00 5 515,342.00 1,667,177.00 a) TRP 1,350,000
Image of page 2
$355,000 $369,000 $383,700 $399,135 $515,342 TOTAL $2,022,177 $404,435.40 $0.30 b) ROI $231,200 $252,960 $275,400 $298,554 -0.83 -0.81 -0.80 -0.78 c) ROE 810000 $231,200 $252,960 $275,400 $298,554 $0.29 $0.31 $0.34 $0.37 INDICADOR NIC´S PASTELES FINOS VPN $75,825.04 3,218,667 TIR 14.49 0.32 PRI 3.61 2.4 PRIFEND 4.32 3.3 IR 1.05 1.42 ROI -0.76 -60 ROE 0.4 0.56 Pasteles Finos es la mejor opción
Image of page 3

Subscribe to view the full document.

Image of page 4
3.60706277
Image of page 5

Subscribe to view the full document.

$322,458 -0.76 $322,458 $0.40
Image of page 6
0.25 A ñ o FEN* 0 1 2,172,804 2 2018388.88 3 1,669,460.48 4 1381126.96 5 1252537.72 8,494,318.04 994308.04 0.26 0.25 A ñ o FEN* 0 1 2,281,444.80 2281444.8 2 2,119,297.92 3 1,752,933.37 4 1,450,183.47 5 1,315,164.65 1,419,024.21 8,919,024.21 0.2 A ñ o FEN* 0 1 1,912,068 2 1,776,173.44 Escenario  base INVERSI Ó N -$   7,500,000 FEN  1
Image of page 7

Subscribe to view the full document.

Image of page 8
You've reached the end of this preview.
  • Fall '17
  • Desviación típica, $1,350,000, Escenario base, FEN*, FEN* ­$ , PASTELES FINOS opción

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern