Introduction
With the rapid pace of change in business today, the ability to construct robust financial models is not just a skill but a strategic advantage. This course is designed to equip finance professionals with the expertise needed to navigate complex financial scenarios, perform rigorous analysis, and communicate insights effectively. In this course, we go beyond basic modelling principles to explore advanced methodologies that enhance accuracy, flexibility, and strategic relevance. Participants will gain skills to use Excel’s advanced features, mastering valuation techniques, and conducting comprehensive scenario analyses.
Course Outline
- Module 1
- Module 2
- Module 3
- Module 4
- Module 5
- Course Objectives
- Target Audience
Excel Financial Modelling
- Advanced functions and formulas in Excel.
- Data manipulation and analysis.
- Conditional formatting.
- Excel VBA basics for financial modelling.
Scenario Analysis & Sensitivity Testing
- Scenario-specific financial models.
- Sensitivity analysis.
- Stress testing.
- Interpreting results.
Valuation Modelling Techniques
- Discounted cash flow (DCF) analysis.
- Comparable company analysis (CCA).
- Precedent transactions analysis.
- ESG-adjusted valuation models..
Risk Management Techniques
- Risk types and tools for risk measurement.
- Effective risk control measures.
- Integrating risk management into the investment process.
- Insurance products and their role in risk management.
- The use of options and futures in managing portfolio risks
Presentation and Communication
- Presentation of model outputs.
- Documentation and reporting of financial models.
- Reporting tools and techniques.
- Interactive financial dashboards.
By the end of this course, participants will be able to:
- Master advanced Excel functions and tools necessary for complex financial modelling.
- Learn to construct dynamic and flexible financial models.
- Analyze financial outcomes through scenario analysis and sensitivity testing.
- Learn valuation techniques like discounted cash flow and comparable company analysis.
- Apply financial modelling skills to support decision-making processes.
- Explore techniques to effectively present and communicate model results to stakeholders.
This course is ideal for
- Financial Analysts
- Investment Bankers
- Corporate Finance Professionals
- Asset Managers
- Business Analysts
- Finance Managers
- Consultants.
- Risk Managers.
- Entrepreneurs & Start-up Founders.
Course Schedule & Fees
- Kuala Lumpur
- Singapore
- Amsterdam
- Online
- Course Fees
This course will take place in Kuala Lumpur on the following dates:
| 26/05/2025 | 09/06/2025 | 23/06/2025 | 07/07/2025 |
| 21/07/2025 | 04/08/2025 | 18/08/2025 | 01/09/2025 |
| 15/09/2025 | 29/09/2025 | 13/10/2025 | 27/10/2025 |
| 10/11/2025 | 24/11/2025 | 08/12/2025 | 22/12/2025 |
| 05/01/2026 | 19/01/2026 | 02/02/2026 | 16/02/2026 |
This course will take place in Singapore on the following dates:
| 19/05/2025 | 09/06/2025 | 30/06/2025 | 21/07/2025 |
| 11/08/2025 | 01/09/2025 | 22/09/2025 | 13/10/2025 |
| 03/11/2025 | 15/12/2025 | 05/01/2026 | 26/01/2026 |
| 16/02/2026 |
This course will take place in Amsterdam on the following dates:
| 26/05/2025 | 16/06/2025 | 07/07/2025 | 28/07/2025 |
| 18/08/2025 | 08/09/2025 | 29/09/2025 | 20/10/2025 |
| 10/11/2025 | 01/12/2025 | 22/12/2025 | 12/01/2026 |
| 02/02/2026 | 23/02/2026 |
This course will take place Online the following dates:
| 20/05/2025 | 17/06/2025 | 15/07/2025 | 12/08/2025 |
| 09/09/2025 | 07/10/2025 | 04/11/2025 | 02/12/2025 |
| 30/12/2025 | 27/01/2026 | 24/02/2026 |
| Kuala Lumpur | Singapore | Amsterdam | Online |
| USD$ 3,580 | USD$ 5,600 | USD$ 5,600 | USD$ 1,920 |
