Master financial modelling in Excel with hands-on case studies, forecasting, valuation, risk assessment, corporate finance, capital budgeting, scenario analysis, sensitivity analysis, cost of capital, financial statements, investment evaluation, and advanced modelling techniques.
| Date | Venue | Duration | |
|---|---|---|---|
| 09 - 11 June 2025 | Sandton | 3 Days | Register Now |
| 14 - 18 July 2025 | Sandton | 5 Days | Register Now |
| 13 - 15 August 2025 | Sandton | 3 Days | Register Now |
| 01 - 03 October 2025 | Pretoria | 3 Days | Register Now |
This interactive Financial Modelling Workshop Using Excel course provides a practical approach to financial modelling using Excel, integrating theoretical knowledge with hands-on exercises. Participants will engage with real-life case studies and have opportunities to present their work, enhancing both learning and practical application.
Upon completion, participants will be able to:
Master time value of money calculations.
Conduct detailed financial analyses.
Calculate the cost of capital using various techniques.
Build and assess forecasted financial statement models, including sensitivity analysis.
Evaluate projects and companies using the free cash flow method.
Craft advanced financial models leveraging diverse Excel functionalities.
Designed for professionals involved in:
Corporate finance
Financial analysis
Investment banking
Financial control
Finance management
Project valuation and finance
Portfolio management
Private investment sector
Target Competencies
Financial application development in Excel.
Capital budgeting and investment analysis.
Proficiency in PV, NPV, and IRR calculations.
Calculation and application of WACC.
Excel-based financial modeling and scenario analysis.
Our diverse instructional approaches ensure effective learning:
– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.
Part 1: Foundations of Financial Calculations
Time value of money principles: PV, NPV, IRR, MIRR.
Amortization schedules and effective yield computations.
Part 2: Corporate Financial Analysis
Comparative analyses of profit and loss versus balance sheet.
Techniques for comparable company and building block analysis.
Vertical, trend, and horizontal financial analysis.
Analysis of liquidity, solvency, and profitability metrics.
Part 3: Cost of Capital and Capital Structure
Understanding the Gordon dividend model and supernormal growth.
Calculating equity and debt costs.
Estimating market returns and computing WACC.
Part 4: Financial Statement Modelling
Principles of financial model construction.
Detailed modelling of income statements and balance sheets.
Measuring and valuing firms using Free Cash Flow.
Sensitivity and discounted cash flow analysis.
Building an integrated financial model.
Part 5: Advanced Modelling Techniques
Designing data tables and managing assumptions.
Employing array functions and advanced formulas.
Interactive data modelling with form controls.
Data acquisition from various sources including text files, databases, and the web.
*Note: The workshop will include practical Excel sessions, case studies, and group presentations. Customized modules can be arranged to address specific organizational needs. Participants are encouraged to bring their laptops for hands-on experience.
Discover how our courses enhance professionals’ effectiveness in their workplaces.
is a Training and Consulting Services Provider
