FINANCIAL MODELING AND EVALUATION SEMINAR

FINANCIAL MODELING AND EVALUATION SEMINAR

Organizer: Skills for Africa Training Institute (https://skillsforafrica.org)

Registrations

https://skillsforafrica.org/course/81

Course Date

Location

06/03/2023-10/03/2023

Nairobi,Kenya

03/04/2023-07/04/2023

Nairobi,Kenya

01/05/2023-05/05/2023

Dubai,UAE

05/06/2023-09/06/2023

Mombasa,Kenya

03/07/2023-07/07/2023

Kigali, Rwanda

INTRODUCTION

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

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

· 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: [email protected]

· The training will be conducted at SKILLS FOR AFRICA TRAINING INSTITUTE IN NAIROBI KENYA.

· The training fee covers tuition fees, training materials, lunch and training venue. Accommodation and airport transfer are arranged for our participants upon request.

· Payment should be sent to our bank account before start of training and proof of payment sent to: [email protected]