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: Terminal Value MethodsExercise 2: Terminal Value WalkthroughExercise 3: Calculating Terminal ValueExercise 4: Calculating Value per ShareExercise 5: DCF Advantages and DisadvantagesExercise 6: NPV FunctionExercise 7: XNPV FunctionExercise 8: Internal Rate of ReturnExercise 9: DCF Using Excel FunctionsExercise 10: Applying Excel Functions in our Model Part 1Exercise 11: Applying Excel Functions in our Model Part 2Exercise 12: Internal Rate of Return DefinitionExercise 13: Check-in 4Exercise 14: Relative ValuationExercise 15: Appropriate MultipleExercise 16: Firm Life CycleExercise 17: Relative Valuation Advantages and DisadvantagesExercise 18: Differences in MultiplesExercise 19: Multiple Calculation