TRAINING COURSE ON FINANCIAL MODELING AND EVALUATION

Type of Resource	Format	Language
On-site training	Certificate	English

TRAINING COURSE ON FINANCIAL MODELING AND EVALUATION Start Date: 01/07/2019 End Date: 05/07/2019 for 5 days Register online: https://bit.ly/2Drog81 Organizer: DATA-AFRIQUE CONSULTANCY (www.data-afriqueconsultancy.org) Course fee: KSH 70,000, USD 1,000 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: 
• The training will be conducted at DATA-AFRIQUE TRAINING CENTRE, NAIROBI KENYA.
• The training fee covers tuition fees, training materirals, 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:

---

Developed by / Author

DATA-AFRIQUE CONSULTANCY

---

Cost

1000 USD

---

Issue Certification

YES

---

Publisher

DATA-AFRIQUE CONSULTANCY

---

Date

Start Date: 01/07/2019 End Date: 05/07/2019 for 5 days

---

Typical Duration

5 days

---

Country

KENYA

---

Audience

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

---

Contact

+254723360025

---

Link

https://bit.ly/2Bv9XPo

---