Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Training on Financial Modeling and Evaluation

By: Data-Afrique Consultants

Kenya

03 - 07 Feb, 2020  5 days

Follow Event

  

USD 1,000

Venue: Data-Afrique Training Centre, Nairobi, Kenya.

Other Dates

Venue Date Fee  
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 06 - 10 Apr, 2020 USD1000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 02 - 06 Mar, 2020 USD1000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 04 - 08 May, 2020 USD1000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 01 - 05 Jun, 2020 USD1000

The course extends the core theory introduced in the Principles of Finance by emphasizing its practical application to strategic financial decisions and potential problems.

Course Objectives

  • Understanding and analyzing income statements
  • Understanding and analyzing balance sheets
  • Understanding and analyzing cash flow
  • Understanding financial modeling usage in financial reporting
  • Use of Discounted Cash Flow (DCF) and Weighted Average Cost of Capital
  • Use of Excel in financial modeling

Who Should Attend?

The course targets financial analysts, Business entrepreneurs, accountants, bookkeepers, business managers, investment officers, and managing directors.

Course Outline

Introduction to evaluation

  • Importance of evaluation
  • Enterprise value and equity value

Comparable Company Analysis

  • Selection of companies that are comparable
  • Spreading of comparable companies
  • Analyzing the valuation multiples
  • Understanding value and making conclusions

Precedent Transaction Analysis

  • selection of transactions that are comparable
  • Spreading comparable transactions

Analysis of Discounted Cash Flows (DCF)

  • Unlevered free cash flow
  • Free cash flow forecasting
  • Terminal value forecasting
  • Presentation of value and discounting
  • Stub periods
  • Sensitivity analysis

Weighted Average Cost of Capital (WACC)

  • Estimating equity cost using CAPM
  • Estimating debt cost
  • Analysis of WACC

Building and Integrated Cash Flow Model

  • Introduction to financial modeling
  • Financial statement links
  • Understanding circularity
  • Set up and formation of the model
  • Selection of model drivers and assumptions

Modeling and Projecting the Financial Statements

  • Income statement projection
  • Balance sheet projection
  • Cash flow statement projection
  • Debt and interest schedule creation
  • Revolver modeling

Utilizing and Concluding the Model

  • Output analysis
  • Stress testing of the model
  • Fixing of modeling errors
  • Techniques of advanced modeling
  • Creating a Discounted Cash Flow (DCF) Analysis using the model

General Notes

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

Training manuals and additional reference materials are provided to the participants.

Upon successful completion of this course, participants will be issued with a certificate.

We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more.

Data-Afrique Training Centre, Nairobi, Kenya. Feb 03 - 07 Feb, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 06 - 10 Apr, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 02 - 06 Mar, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 04 - 08 May, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 01 - 05 Jun, 2020

Registration: 08:00:am - 04:00:am

USD 1,000.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY
Related Courses
Information Security and Data Management Training Information Security and Data Management Training

5 days, 03 - 07 Feb, 2020 

2020-02-03 12:02:00
Kenya

Data-Afrique Consultants

Vulnerabilities and lack of necessary security skills applicable to today's technology environments have reached a crisis point and therefore, in order to maintain privacy required and to ...

Installation Use and Management of Data Using Open HDS and ODK Training Installation Use and Management of Data Using Open HDS and ODK Training

5 days, 03 - 07 Feb, 2020 

2020-02-03 12:02:00
Kenya

Data-Afrique Consultants

OpenHDS is an open source Android tablet application that enables community field workers to collect births, deaths, migrations, pregnancies, deliveries, immunization and other pertinent health ...

Training on Monitoring Evaluation and Data Analysis for Community Based Projects Training on Monitoring Evaluation and Data Analysis for Community Based Projects

12 days, 03 - 14 Feb, 2020 

2020-02-03 12:02:00
Kenya

Data-Afrique Consultants

This course focuses on the operations of community projects. The course aims at educating participants on the programmes of monitoring and evaluation implemented to ensure successful community ...

Training on SMEs Guarantee and Credit Analysis Training on SMEs Guarantee and Credit Analysis

5 days, 03 - 07 Feb, 2020 

2020-02-03 12:02:00
Kenya

Data-Afrique Consultants

The overall goal of this course is to build analytic skills needed to evaluate the credit standing of small and medium sized enterprises. The training will demonstrate how to combine a qualitative ...