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: Methoden zur Ermittlung des Terminal ValueExercise 2: Schritt-für-Schritt zur Terminal ValueExercise 3: Terminal Value berechnenExercise 4: Wert je Aktie berechnenExercise 5: Vor- und Nachteile der DCF-MethodeExercise 6: NPV-FunktionExercise 7: XNPV-FunktionExercise 8: Interner ZinsfußExercise 9: DCF mit Excel-FunktionenExercise 10: Excel-Funktionen in unserem Modell anwenden, Teil 1Exercise 11: Excel-Funktionen in unserem Modell anwenden, Teil 2Exercise 12: Definition der Internal Rate of ReturnExercise 13: Check-in 4Exercise 14: Relative BewertungExercise 15: Passender MultipleExercise 16: Lebenszyklus eines UnternehmensExercise 17: Vor- und Nachteile der relativen BewertungExercise 18: Unterschiede bei MultiplikatorenExercise 19: Multiple-Berechnung