Discounted cash flow modelling using Excel

In this recorded webinar, you will learn how to utilise Discounted Cash Flow (DCF) valuation, a critical metric in various financial settings. You will be guided through a basic DCF example in Excel, including how to generate a DCF model from a set of projections, make informed assumptions, and divide the DCF model to assess different aspects of a business. The webinar will also touch upon the advantages and disadvantages of DCF modelling, with particular emphasis on the significance of dependable cash flow projections.  

Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.  

Key topics:;

• Create a basic DCF model in Excel
• Use DCF formula in Excel
• Avoid pitfalls when creating DCF models

As part of this webinar you will receive,

• Downloadable worksheets with practical tasks to embed the knowledge
• A learning manual with step-by-step instructions

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.

Course updated: May 2023