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

11 - 13 Sep, 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. Sep 11 - 13 Sep, 2017

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

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

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.
NST PPC Advert
Related Courses
 	Risk Assessment and Emergency Management Course Risk Assessment and Emergency Management Course

3 days, 27 - 29 Jun, 2018 

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

Tom Associates Training

It is not possible to control or manage 100% of risk, but knowing what do before, during, and after an event will mitigate the damage and harm. Identifying potential hazards and risks and making it ...

Understanding Business Models: Innovations to Deliver Strategic Goals Understanding Business Models: Innovations to Deliver Strategic Goals

3 days, 22 - 24 Mar, 2018 

2018-03-22 12:03:00
Lagos State, Nigeria

Tom Associates Training

  Understanding Business Models: Innovations to Deliver Strategic Goals is a robust opportunity to plan for the future of the business. Course Contents DAY ONE Creating New Models Central ...

Bank Treasury Management Training Bank Treasury Management Training

4 days, 20 - 23 Feb, 2018 

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

Tom Associates Training

 Bank Treasury Management Training participants will be equipped with knowledge and skills in the following areas: Government policies on funding, monetary and fiscal policies Deposits ...

Delivering Results through Teams Delivering Results through Teams

3 days, 25 - 27 Jul, 2018 

2018-07-25 12:07:00
Lagos State, Nigeria

Tom Associates Training

This training course Delivering Results through Teams will discuss the following: How to develop a team that delivers results through: Harnessing quality staff and aligning the employees efficiently ...