Financial Modelling And Evaluation
ENDED
Training by
Data-Afrique Consultancy
Inquire Now
On-Site
/ Training
USD 1,000.00
Details
TRAINING COURSE ON FINANCIAL MODELING AND EVALUATION
Register online: https://bit.ly/2sRTbWg
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 DATA-AFRIQUE TRAINING CENTRE, 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.
Register online: https://bit.ly/2sRTbWg
Reviews
Be the first to write a review about this course.
Write a Review
Data-Afrique Data-Afrique is a global capacity building and consultancy company that offers training and Consultancy services with its head office in Nairobi, Kenya. Data-Afrique offers training and consultancy services designed for individuals’ and groups from organizations working in public, not for profit organizations and the private sectors.
Data-Afrique has collaborated with Government ministries, agencies and departments, UN agencies, Non-Governmental Organizations, from Europe, Africa, Asia, Middle-East and the Caribbean.
We have also worked with academic institutions, international research organizations, financial institutions and private companies from across the globe. By nurturing a culture of collaboration, we attract the highest calibre of people who have the ability and desire to influence and shape the future.
Data-Afrique has collaborated with Government ministries, agencies and departments, UN agencies, Non-Governmental Organizations, from Europe, Africa, Asia, Middle-East and the Caribbean.
We have also worked with academic institutions, international research organizations, financial institutions and private companies from across the globe. By nurturing a culture of collaboration, we attract the highest calibre of people who have the ability and desire to influence and shape the future.