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

25 - 27 May, 2016  3 days

Follow Event

  

NGN 115,500

Financial modeling demands a logical consistent approach and this workshop builds a financial analysis and a valuation model through a series of 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, optimization and forecasting.

Course Contents

Day One

  • Financial Analysis and Valuation
  • Exercise: Alternative Model Review.
  • Model Structure and Planning
  • Case: Completing and Checking the Financial Analysis/Valuation Template.
  • Adding Cash Flows and Ratios
  • Case: Adding Cash Flow and Ratios to Template.
  • Non-cash Flow Valuation
  • Case: Calculating Accounting and Market Value on Template.

Day Two

  • Forecasting and Equity Valuation
  • Case: Reviewing Performance and Adding a Forecast.
  • The Case Template and Deriving Forecast Financial Statements
  • Free Cash Flows
  • Case: Adding Free Cash Flow to the Model.
  • Cost of Capital
  • Exercise: Deriving Beta from Data and Adding WACC to Case.
  • Initial Equity Valuation
  • Exercise: Adding Equity Valuation to the Template.

Day Three

  • Risk, Targeting and Other Layers
  • Exercise: Adding APV to the Template.
  • Risk and Sensitivity
  • Case: Testing the Models with Different Sensitivity and Risk Matrices.
  • Optimum Structure and Targeting
  • Case: Targeting the Case to Improve Valuation Sensitivity.
  • Management Reporting and Model Review
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 25 - 27 May, 2016
NGN 115,500.00(VAT Inclusive)
(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
Financial Modeling and Forecasting Techniques Using Advanced Excel Tools Financial Modeling and Forecasting Techniques Using Advanced Excel Tools

4 days, 26 - 29 Sep, 2017 

2017-09-26 12:09:00
Lagos State, Nigeria

Tom Associates Training

Modeling techniques that this course teaches are used in investment appraisal, capital planning, budgeting, valuation, financial analysis, and forecasting to make accurate financial and business ...

Effective Management of Time, Priority and Work Pressure Effective Management of Time, Priority and Work Pressure
On going

3 days, 21 - 23 Jun, 2017 

2017-06-21 12:06:00
Lagos State, Nigeria

Tom Associates Training

Managers and executives must consistently add more value, in the limited time they have in hand, just to remain in contention today. To achieve more than the ordinary, managers must have the special ...

Mastering Internal Controls: Operations, Financial, Management Mastering Internal Controls: Operations, Financial, Management

4 days, 12 - 15 Sep, 2017 

2017-09-12 12:09:00
Lagos State, Nigeria

Tom Associates Training

Internal controls are highly integral to the success of any business and it is important to establish a clear understanding of their importance. This training is for professionals who must know how ...

Business Data Analysis and Modeling with Excel Business Data Analysis and Modeling with Excel

4 days, 19 - 22 Sep, 2017 

2017-09-19 12:09:00
State, Nigeria

Tom Associates Training

This program will make participants with little or no knowledge in modeling understand how to build a working data analysis model in excel. They will be equipped with advanced excel functions vital ...