Sorry, this course has now expired.
Overview
Introduction
The course extends the core theory introduced in Principles of Finance by emphasizing its practical application to strategic financial decisions and potential financial problems.
Duration
5 days
Who should attend?
- Financial Analysis
- Business Entrepreneurs
- Accountants
- Bookkeepers
- Business managers
- Investment officers
- Managing directors
Course Objective:
- Analyzing and understand an income statement
- Analyzing and understand a balance sheet
- Analyzing and understand a cash flow
- Understanding use of financial modeling in financial reporting
- Use of Discounted Cash Flow (DCF) and Weighted Average Cost of Capital
- Use of excel in financial modelling
Course content
Module 1: Valuation
Introduction to valuation
- The importance of valuation
- Understanding enterprise value and equity value
Comparable Company Analysis
- Selecting comparable companies
- Spreading comparable companies
- Analyzing the valuation multiples
- Concluding and understanding value
Precedent Transactions Analysis
- Selecting comparable transactions
- Spreading comparable transactions
Discounted Cash Flow (DCF) analysis
- Understanding unlevered free cash flow
- Forecasting free cash flow
- Forecasting terminal value
- Present value and discounting
- Understanding stub periods
- Performing sensitivity analysis
Weighted Average Cost of Capital (WACC)
- Using the CAPM to estimate the cost of equity
- Estimating the cost of debt
- Understanding and analyzing WACC
Module 2: Building an Integrated Cash Flow Model
Introduction to financial modeling
- Understanding the links between the financial statements
- Understanding circularity
- Setting up and formatting the model
- Selecting model drivers and assumptions
Modeling and projecting the financial statements
- Projecting the income statement
- Projecting the balance sheet
- Projecting the cash flow statement
- Creating the debt and interest schedule
- Revolver modeling
Analyzing and concluding the model
- Analyzing the output
- Stress testing the model
- Fixing modeling errors
- Advanced modeling techniques
- Using the model to create a Discounted Cash Flow (DCF) Analysis
Training Approach
This course will be delivered by our skilled trainers who have vast knowledge and experience as expert professionals in the fields. The course is taught in English and through a mix of theory, practical activities, group discussion and case studies. Course manuals and additional training materials will be provided to the participants upon completion of the training.
Tailor-Made Course
This course can also be tailor-made to meet organization requirement. For further inquiries, please contact us on: Email: [email protected] Tel: +254 721 331 808 Website: www.upskilldevelopment.com
What you will learn
Course Objective:
- Analyzing and understand an income statement
- Analyzing and understand a balance sheet
- Analyzing and understand a cash flow
- Understanding use of financial modeling in financial reporting
- Use of Discounted Cash Flow (DCF) and Weighted Average Cost of Capital
- Use of excel in financial modelling