Advanced DCF Valuation Model  
   Venue Date
E4D Training Centre,

MKO Crescent,

Toyin, Ikeja


20-21 September 2017

9:00 am to 4:00 pm

   Course Objective:
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 modeling, 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.
   Key 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

  Who should attend this course?
  This highly practical program has been specifically designed for:

·         Chief Accountants

·         Group Finance Directors

·         Heads of Finance

·         Finance Managers

·         Financial Controllers

·         Aspiring Investment Bankers

·         Graduates who pursue a career in Corporate Finance

·         Professionals who would like to deepen their Valuation skills

·         Financial Analysts

·         Senior Management of Non-Finance

   Pre-requisites Basic Microsoft Excel knowledge

A high level of concentration

Basic grip of Financial Statements

Participants are required to bring their laptops with MS Excel 2013 installed in it

   Course Outline:
·         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

o   Calculating Unlevered free cash flows

o   Forecasting future cash flows

o   Caclulating Terminal value

o   Discounting future cash flows

o   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

o   Perpetuity approach

o   EBITDA multiple approach

o   Common pitfalls

·         Forecasting of key P&L items

o   Revenue

o   Other Revenues and Cogs

o   Operating Expenses and D&A

o   Interest Expenses, Extraordinary Items and Taxes

·         Additional analyses accompanying the Financial Model

·         Excel Tools in Practice –

o   Sensitivity Analysis for WACC and Perpetuity Growth

o   Application of Goal Seek

   Registration Fee ₦50,000.00 per participant (inclusive of training mat, refreshments and lunch)
   Enjoy 20% discount!!!

Pay ₦40,000.00

Early Birds –

Valid for registration and payment received on or before 15 September 2017

Valid for 3 or more participants registering under the same company or group of companies
   For further enquiries,

please contact

Tina        +234 817 915 1225  

Oye         +234 817 745 0870

  To register    visit: