Financial Modeling And Evaluation Seminar

  • Overview

INTRODUCTION

The course builds on the fundamental concepts covered in Principles of Finance by stressing how they might be used to solve real-world financial issues..

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

DURATION

5 Days

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

  • Our seasoned instructors, who have years of experience as seasoned professionals in their respective fields of work, will be teaching this course. A combination of practical exercises, theory, group projects, and case studies are used to teach the course.
  • The participants receive training manuals and supplementary reading materials.
  • Participants who complete this course successfully will receive a certificate.
  • We can also create a course specifically for your organization to match your needs. To learn more, get in touch with us at training@dealsontrainers.org.
  • The training will take place at DEALSON TRAINERS IN NAIROBI, KENYA in Nairobi, Kenya.
  • The training fee includes lunch, course materials, and lodging for the training session. Upon request, we may arrange for our participants' lodging and transportation to the airport.
  • Payment must be made to our bank account before the training begins, and documentation of payment should be emailed to training@dealsontrainers.org

Course Schedule:
Dates Duration Fees Location Action