• Build and modify financial models to support decision-making

• Master techniques for forecasting financial statements

• Perform scenario and sensitivity analysis in financial models

• Use models for business valuation and risk assessment

Introduction to Financial Modelling

• The role of financial models in decision-making

• Common uses of financial models in corporate finance

• Best practices for building structured and dynamic models

• Practical case: Design the framework of a financial model for a retail company

Building a Basic Financial Model

• Introduction to Excel functions and tools used in financial modelling

• Building income statements, balance sheets, and cash flow forecasts

• Handling assumptions and variables in financial models

• Practical case: Build a simple three-statement financial model for a startup

Advanced Financial Modelling Techniques

• Modeling complex financial instruments (loans, equity, debt)

• Advanced forecasting techniques for revenue and expenses

• Incorporating key performance indicators (KPIs) into financial models

• Quiz: Test your understanding of advanced financial modelling techniques

Scenario and Sensitivity Analysis

• Understanding the importance of scenario analysis in financial planning

• Using sensitivity analysis to evaluate key assumptions

• Building scenarios for best, base, and worst-case outcomes

• Practical case: Perform scenario analysis on a company’s financial performance

Business Valuation and Risk Assessment

• Introduction to business valuation methods (DCF, comparable company analysis)

• Incorporating risk and uncertainty into financial models

• Assessing the impact of financial risks on business valuation

• Practical case: Build a discounted cash flow (DCF) model to value a company

• Numerous practical examples illustrating the different studied concepts

• Practical cases to draw parallels with the concepts learned

• Financial analysts and corporate finance professionals

• Investment bankers and equity researchers

• Accountants and financial controllers

• Business consultants and strategy professionals

• Basic knowledge of Excel and financial statements is recommended

• Training structured around skill transfer

• Acquisition of operational skills through practice and experimentation

• Collaborative learning during synchronous sessions

• Multi-stage learning path to allow engagement, learning, and transfer

• Training promoting participant engagement for better anchoring of lessons

• Skill evaluation will be conducted throughout the training by the participant (self-evaluation) and/or the trainer according to the training methods.

• Online training evaluation on your participant space:

  • Immediate evaluation at the end of the training to measure your satisfaction and perception of skill improvement against training objectives. With your agreement, your overall rating and comments will be published on our site via Verified Reviews.

  • Post-training evaluation 40 days later to validate the transfer of your acquired skills in the workplace

• Attendance tracking and issuance of an individual training certificate or a certificate of completion