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

23 - 26 Apr, 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. Apr 23 - 26 Apr, 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
Advanced Selling Skills Course Advanced Selling Skills Course

4 days, 08 - 11 Oct, 2019 

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

Tom Associates Training

A four-day programme to address how the organisation’s senior sales persons can: Battle successfully for greater share of the customer spend Attract premium customers who trust and remain ...

Budgeting, Forecasting and Budgetary Control Course Budgeting, Forecasting and Budgetary Control Course

4 days, 03 - 06 Dec, 2019 

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

Tom Associates Training

The programme is designed to equip Managers and Heads of departments entrusted with departmental or organisational budgets with knowledge and skills necessary to enable them effectively manage and ...

Growing as an Entrepreneur Course  - What Set Successful Entrepreneurs Apart Growing as an Entrepreneur Course - What Set Successful Entrepreneurs Apart

5 days, 02 - 06 Dec, 2019 

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

Tom Associates Training

To choose a path of entrepreneurship is a very major decision. To some the feeling is very great. To those forced into the choice, it is with trepidation. This course breaks down the Entrepreneurial ...

Intermediate Course on Procurement and Vendor Management Intermediate Course on Procurement and Vendor Management

5 days, 26 - 30 Aug, 2019 

2019-08-26 12:08:00
Lagos State, Nigeria

Tom Associates Training

This course provides participants with the necessary knowledge and skills to effectively and efficiently manage company and project procurement functions. The topics covered will include: The ...