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

28 - 31 Jan, 2019  4 days

Follow Event

  

NGN 150,000

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. Jan 28 - 31 Jan, 2019

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

Class Session: 09:00:am - 04:00:am

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.
Related Courses
Financial Statement Analysis Course Financial Statement Analysis Course

3 days, 16 - 18 Oct, 2019 

2019-10-16 12:10:00
State, Nigeria

Tom Associates Training

This financial statement analysis course is oriented around interpreting financial results of live companies and financial institutions so candidates can gain a solid understanding of financial ...

Talent Optimization: Pillars of Talent Management Practices Course Talent Optimization: Pillars of Talent Management Practices Course

4 days, 17 - 20 Sep, 2019 

2019-09-17 12:09:00
Lagos State, Nigeria

Tom Associates Training

Successful organizations, both public and private, are recognizing that the employee assessment and selection process must be viewed as part of a larger, inter-connected talent management strategy; a ...

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

5 days, 22 - 26 Jul, 2019 

2019-07-22 12:07:00
Kwara 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 ...

Value Added Marketing: Advanced Marketing Strategies Course Value Added Marketing: Advanced Marketing Strategies Course

4 days, 14 - 17 May, 2019 

2019-05-14 12:05:00
Lagos State, Nigeria

Tom Associates Training

At the end of this Value Added Marketting Strategies Course, participants will:       Develop enhanced skills in formulating strategic marketing plans ...