Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Building Financial Models Course

By: Tom Associates Training  

Lagos State, Nigeria

10 - 13 Sep, 2019  4 days

Follow Event

  

NGN 150,000

Venue: 5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos.

Financial modeling demands a logical, consistent approach. This workshop builds a financial analysis and a valuation model through a series of logical and practical stages.

Upon completion, delegates will have a comprehensive understanding of advanced modeling, as well as how each technique can practically be applied through: 

  • Building a financial model from a blank sheet 
  • Designing models which minimize errors 
  • Writing models which can be maintained and augmented in the future
  • Developing models with advanced techniques such as risk, sensitivity, and optimization and forecasting. 

Course Contents

DAY ONE

Financial Analysis and Valuation

  • Different approaches to valuation 
  • Financial analysis and valuation framework model
  • Useful Excel methods, features and techniques 
  • Common pitfalls and mistakes in Excel.

Alternative Model Review

  • Model Structure and Planning
  • Model design and structure – key stop
  • Planning the equity valuation model 
  • Required sheets, calculations and DAYs 
  • Five essential auditing techniques. 

Completing and Checking the Financial Analysis/Valuation Template

  • Adding Cash Flows and Ratios
  • Structured model with a menu and accounting statements
  • Calculating key financial ratios

DAY TWO

Adding Cash Flow and Ratios to Template

  • Non-cash Flow Valuation
  • Non-cash flow methods
  • Accounting methods 
  • Dividend discount models 
  • Market-based methods – EPS and multiples 
  • Peer groups 
  • Calculating Accounting and Market Value on Template 

Forecasting and Equity Valuation 

  • Forecasting Methods 
  • Review of forecasting methods 
  • Macro forecasting 
  • Linear methods 
  • Review of historical performance 
  • Relationship between company and financial strategy 
  • Identifying and forecasting key drivers 
  • Linkages and modeling problems 
  • Reviewing Performance and Adding a Forecast. 

DAY THREE

  • The Case Template and Deriving Forecast
  • Financial Statements. 
  • Free Cash Flows 
  • Derivation of free cash flow
  • Checking model results and redefining forecast 
  • Reasonableness of forecast and results. 
  • Adding Free Cash Flow to the Model. 
  • Cost of Capital:
  • Alternative theories – bonds and arbitrage pricing theory 
  • Capital Asset Pricing Model constituents 
  • Discussion and agreement on WACC inputs
  • Asset and equity betas and risk 
  • Mathematical derivation 
  • Deriving Beta from Data and Adding WACC to Case 
  • Initial Equity Valuation: 
  • Methods of adding terminal value 
  • Producing an equity valuation 
  • Comparison to existing share price 
  • Adding Equity Valuation to the Template 
  • Risk, Targeting and Other Layers
  • Alternative Cash Flow Valuation 
  • Time varying WACC
  • Adjustments to value
  • Adjusted Present Value (APV) method 
  • Existence and addition of financial and operational synergies 
  • Reconciliation to economic profit
  • Adding APV to the Template
  • Risk and Sensitivity 
  • Understanding of risk and multiple answers
  • Sensitivity and tables 
  • Creating sensitivity graphs
  • Scenario planning based on economic climate
  • Alternative scenario methods 

DAY FOUR

  • Testing the Models with Different Sensitivity
  • and Risk Matrices 
  • Optimum Structure and Targeting 
  • Achieving a target valuation 
  • Goal seeking method
  • Testing valuation with leverage and structure 
  • Targeting the Case to Improve Valuation Sensitivity 
  • Management Reporting and Model Review:
  • Management reporting and summary
  • Suggestion for other improvements to the valuation model 
  • Final audit 
  • Help and user assistance
  • Securing and protection 
  • Documentation and maintenance. 
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Sep 10 - 13 Sep, 2019

Registration: 08:30:am - 09:00:am

Class Session: 09:00:am - 16:00:pm

NGN 150,000.00(VAT Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
NST PPC Advert
Related Courses
Managing Conflict and Difficult Situations at Work Course Managing Conflict and Difficult Situations at Work Course

2 day, 15 - 16 Oct, 2019 

2019-10-15 12:10:00
Lagos State, Nigeria

Tom Associates Training

This Managing Conflict and Difficult Situations at Work will discuss the following: Course Contents Day One Common causes of conflicts at work Signs of conflicts Common Conflict Triggers Different ...

Frontline Leadership: Emerging Leadership Course Frontline Leadership: Emerging Leadership Course

3 days, 07 - 09 Oct, 2019 

2019-10-07 12:10:00
Lagos State, Nigeria

Tom Associates Training

The  course presents the basic principles that are the foundation of all the leadership activities and central to senior level effectiveness: Building and maintaining a positive, ...

Administrative Functions and Office Management Course Administrative Functions and Office Management Course

5 days, 04 - 08 Nov, 2019 

2019-11-04 12:11:00
Lagos State, Nigeria

Tom Associates Training

A training to deliver the requirements of Administrative Officers, so they are brought up-to-date with what is expected of them at all times. The contents will make administrative staff to be highly ...

Designing Effective Distribution Channels Course Designing Effective Distribution Channels Course

3 days, 11 - 13 Dec, 2019 

2019-12-11 12:12:00
Lagos State, Nigeria

Tom Associates Training

Course Contents Day One Analysing Customer Needs Choosing the Target Customers What the Targeted Customers truly want through the channels Possibility/practicality of the customer wants How ...