Course Detail

Financial Modeling and DCF Valuation

This training is aimed at making you proficient in building financial models and carrying out valuation for existing businesses and startups. You will learn to create financial models from scratch using Microsoft Excel and build one during the training. You will also learn how to keep your financial modelling skills sharp and apply them to real world situations – help friends with their business valuations, help your company with financial planning and advise clients on equity funding. The training is strictly targeting people with accounting background and basic knowledge of corporate finance.

The trainer is a certified Advanced Financial Modeler (AFM), has a master of science in Financial Engineering and has built financial models for companies in the US, UK, Zambia, Senegal and Nigeria involving over US$ 1bn.

UrBizEdge is an approved training provider by the global financial modeling certifying body, Financial Modeling Institute, and this training is an important step for those seeking to do the Advanced Financial Modeler (AFM) certification.

What sets our training apart from most other financial modeling training is that our trainer has walked the talk and will not just teach you but show you a clear path to you becoming a hireable financial modeler.  You will also get access to our after training package that ensures you keep putting to practice and internalising what you have learned till you finally become an expert at financial modeling and valuation.

More Details

Training Package

The training pack covers your tea break, sumptuous lunch, our training materials and templates, training notepad with pen, a training certificate from us (as an approved training provider by the global financial modeling certifications body, FMI), access to our online community and after training support.

In our training sessions, we have had participants from Guinness Nigeria, Nigerian Breweries, Schlumberger, Chevron, Periscope, Brains and Hammers, GfK, Palladium Group, First Bank, Citi Bank, Dalberg, PMI, EatNGO, NLNG, GSK, Promasidor, SaveTheChildren, Mobil, FMDQ, NSE, Biofem Pharmaceuticals, Total E&P, Vodacom, Nestle, Nigerian Breweries, Delta Afrik, LATC Marine, Broll, Habanera (JTI), SABMiller, IBM, Airtel, Diamond Bank, ECOWAS, Ministry of Finance, Transmission Company of Nigeria, Nokia Siemens Networks and DDB.

Training Outline

  • a. Refresher on the fundamental accounting principles 
    b. Trial Balance 
    c. Building the Income Statement from the Trial Balance 
    d. Building the Balance Sheet Statement from the Trial Balance 
    e. Building the Cash Flow Statement from the Trial Balance 
    f. Introduction to Financial Ratios 
  • a. Template Building from Scratch 
    i. Creating the Required Sheets and Having an Index Sheet 
    ii. General Model Structure Design 
    iii. Working Across Multiple Sheets at Once 
    iv. Linking Sheets 
    v. Absolute and Relative References 
    vi. Template Building Tricks 
    b. Required Excel Tools and Formulas 
  • a. Modelling Stage One: Projection Ratios and Scenarios (Optimistic, Base and Pessimistic) 
    i. Income Statement Drivers Projections – from schedules or moving average
    ii. Balance Sheet Drivers Projections – from schedules or moving average
    b. Modelling Stage Two: Financial Statements Forecasts 
    i. Income Statement Forecast 
    ii. Balance Sheet Forecast 
    iii. Cashflow Statement Forecast – extracting the Cashflow from Income Statement & Balance Sheet
    iv. Extracting the Unlevered Free Cashflow
  • a. Discounted Cash Flow (DCF) Model 
    b. Comparative Company Analysis (comps) Model (and precedent transaction valuation multiples)
    c. Sum-of-the-parts Model 
    d. Leveraged Buy Out (LBO) Model 
    e. Merger and Acquisition (M&A) Model 
    f. Book value Model 
    g. Depreciated Replacement Cost (DRC)
    h. Dividend Discount Model

a. Enterprise Value = Discounted Cashflow of Explicit Forecast Period + Discounted Terminal Value 
b. Calculation of WACC, CAPM and Cost of Debt 
c. Practical Reality of the Nigerian Economic Space 
d. Extracting The Equity Value from The Enterprise Value 
e. Sensitivity Analysis: WACC vs Perpetuity growth 
f. Practical Use of The Results 
g. Company Valuation: Sell-side, Buy-side and Advisory 
h. Business Unit or Subsidiary Valuation 
i. Capital Project Valuation 

a. Liquidity Ratios 
b. Asset Management Ratios 
c. Leverage Ratios 
d. Profitability Ratios 
e. Valuation Ratios 
f. Financial Project Planning Excel formulas 

Related Courses

Increase your Productivity

Get the special edge you need. Register for our premium online classes.