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: Passo a passo do valor terminalExercise 3: Calculando o valor terminalExercise 4: Calculando o valor por açãoExercise 5: Vantagens e desvantagens do DCFExercise 6: Função NPVExercise 7: Função XNPVExercise 8: Taxa Interna de RetornoExercise 9: DCF usando funções do ExcelExercise 10: Aplicando funções do Excel no nosso modelo – Parte 1Exercise 11: Aplicando funções do Excel no nosso modelo - Parte 2Exercise 12: Definição de Taxa Interna de RetornoExercise 13: Check-in 4Exercise 14: Valuation RelativoExercise 15: Múltiplo adequadoExercise 16: Ciclo de vida da empresaExercise 17: Vantagens e desvantagens da avaliação relativaExercise 18: Diferenças em MúltiplosExercise 19: Cálculo de múltiplos