DCF Valuation Modelling

Course Overview

The course is the ultimate Guide to Company Valuation for Aspiring Investment Bankers and Corporate Finance Practitioners. Participants will be introduced to valuation analysis in general, and the DCF model in particular.

Participants will also learn step-by-step DCF modelling, estimate the weighted average cost of capital (WACC) in the real world, and build several commonly used approaches to calculating terminal value. Finally, we will use data tables to analyze a broad range of scenarios given different assumptions.

Takeaways
  • Be able to build a Cash Flow statement
  • Know how to value a company
  • Be able to build a Valuation model from scratch
  • Know how to create a model with multiple scenarios
  • Be able to perform sensitivity analysis
  • Know how to create professional and good-looking advanced charts
Course Outlines
  • Introduction to Company Valuation
  • Why value a company?
  • Company Valuation – Theoretical Framework
  • What drives a firm’s value?
  • Forecasting of key Balance Sheet items
  • How to Forecast Balance Sheet Items – The Practical and Easy to Understand Way
  • A Key Concept for Finance Practitioners – the “Days” Methodology
  • Forecasting Property Plant & Equipment, Other assets, and Other liabilities
  • Tools for valuing a company
  • Calculating Unlevered free cash flows
  • Forecasting future cash flows
  • Calculating Terminal value
  • Discounting future cash flows
  • Calculating Enterprise and Equity value of the firm
  • Calculating Present Value of Cash Flows within the forecast period
  • Introducing WACC and Perpetuity Growth Rate
  • Present Value of Future Cash Flows in Financial Models
  • Discounted Cash Flow model in Excel
  • Learning by Doing – Learn How to Value a Company
  • Stages of a Complete DCF Valuation
  • Structure of the DCF Model in Excel
  • Estimating terminal value
  • Perpetuity approach
  • EBITDA multiple approaches
  • Common pitfalls
  • Forecasting of key P&L items
  • Revenue
  • Other Revenues and Cogs
  • Operating Expenses and D&A
  • Interest Expenses, Extraordinary Items, and Taxes
  • Additional analyses accompanying the Financial Model
  • Excel Tools in Practice –
  • Sensitivity Analysis for WACC and Perpetuity Growth
  • Application of Goal Seek

Subscribe to our newsletter

Sign up to receive latest news, updates, promotions, and special offers delivered directly to your inbox.
No, thanks