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.
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.
Introduction to Financial Modeling and Valuation
- 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
Building a Financial Model Template from Scratch
- 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
The Financial Model Core
- 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
Different Types of Valuation Models
- 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
Increase your Productivity
Get the special edge you need. Register for our premium online classes.