ProspenAfrica | Training and Consulting Services Provider

Financial Modelling Workshop Using Excel

5 Day Accredited Training

Dates: 24 – 28 June 2024

Locations: Johannesburg, South Africa

Platform: Available In-Class 

Price: Available on request

This is a Non-Accredited Course

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

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.

Request a call back

Related Courses

Accounting For Value Added Tax
Dates: 04 - 05 Apr 2024

Accouting for Value Added Tax

2 Day Training

View More
Accounting For Value Added Tax (With Updates)
Dates: 27 Mar 2024

Accounting For Value Added Tax (With Updates)

1 Day Training

View More
Accounts Payables, Reconciliations and Income Tax Training
Dates: 10 - 11 Apr 2024

Accounts Payables, Reconciliations and Income Tax Training

View More
Accounts Payable: From Accounting to Management
Dates: 17 - 18 Apr | 08 - 09 May 2024

Accounts Payable: From Accounting to Management

2 Day Training

View More

Open chat
Need Help? Chat with Us
Scan the code
Powered by Prospen Africa
Welcome to Prospen Africa!
Check out our 15% Off sale when you purchase QCTO Training Material