Firstly, This chapter explores terminal value in discounted cash flow (DCF) analysis, covering different calculation methods, value per share estimation, and the advantages and disadvantages of DCF valuation. Secondly, it focuses on calculating net present value (NPV) and internal rate of return (IRR) using Excel functions, covering standard and extended formulas and practical modeling applications. Lastly, it covers the principles of relative valuation, including the selection of appropriate valuation multiples, firm life cycle considerations, and the advantages and disadvantages of this approach.
Exercise 1: Métodos de valor terminalExercise 2: Recorrido por el valor terminalExercise 3: Cálculo del valor terminalExercise 4: Cálculo del valor por acciónExercise 5: Ventajas y desventajas del DCFExercise 6: Función NPVExercise 7: Función XNPVExercise 8: Tasa Interna de RetornoExercise 9: DCF con funciones de ExcelExercise 10: Aplicar funciones de Excel en nuestro modelo (Parte 1)Exercise 11: Aplicar funciones de Excel en nuestro modelo (Parte 2)Exercise 12: Definición de la Tasa Interna de RetornoExercise 13: Control 4Exercise 14: Valoración relativaExercise 15: Múltiplo adecuadoExercise 16: Ciclo de vida de la empresaExercise 17: Ventajas y desventajas de la valoración relativaExercise 18: Diferencias en múltiplosExercise 19: Cálculo de múltiplos