Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Building Financial Models

By: Tom Associates Training  

Lagos State, Nigeria

22 - 24 May, 2017  3 days

Follow Event

  

NGN 115,500

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
  • 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 

Day Two

  • 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. 
  • 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 

Day Three

  • 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 answer
  • Sensitivity and tables 
  • Creating sensitivity graphs
  • Scenario planning based on economic climate
  • Alternative scenario methods 
  • 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

NOTE: Participants Must Be With Their Computers

5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. May 22 - 24 May, 2017
NGN 115,500.00(including VAT)
(Convert Currency)

08033019120

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
Related Courses
Making Your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies Making Your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies

4 days, 17 - 20 Apr, 2018 

2018-04-17 12:04:00
Lagos State, Nigeria

Tom Associates Training

This courses teaches pungent lessons to any business that will successfully wade through a period when its counterparts are experiencing comatose: How much time managers spend on problem definition, ...

Advancing Performance through Targets Setting and Appraisal Processes: Employee Performance Assurance Training Advancing Performance through Targets Setting and Appraisal Processes: Employee Performance Assurance Training

4 days, 06 - 09 Feb, 2018 

2018-02-06 12:02:00
Lagos State, Nigeria

Tom Associates Training

By the time the programme ends, participants would become conversant with the procedure of: Determining performance measures at the Corporate, Business Unit and Individual levels. Managing the ...

Competency Training For Business Development Executives Competency Training For Business Development Executives

3 days, 11 - 13 Apr, 2018 

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

Tom Associates Training

A Business Development skill is an enterprise management capability, and all participants in this course will acquire Seven Major Competencies: Ability to develop business trendsetter ideas Ability ...

Fleet Management for Profitability Fleet Management for Profitability

3 days, 21 - 23 Feb, 2018 

2018-02-21 12:02:00
Lagos State, Nigeria

Tom Associates Training

This is a comprehensive fleet management course that covers important and vital aspects of the fleet life cycle. Fleet management practitioners and owners must keep abreast of the latest ...