Financial Modelling Workshop Using Excel

5 Day Training

Dates: 07 – 11 October 2024

Locations: Grayston Ridge Office Park, Sandton

Platform: Available In-Class

Price: Available on request

Course Introduction

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.

Course Objectives

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.

Who should attend?

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.

Training Methodology

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.

Training Outline

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.