Financial Modelling

The first day introduces the theoretical foundations of financial modelling and guides participants through structuring assumptions, gathering data, and designing the logic of pro forma financial statements. Participants begin working hands-on in Excel to lay the groundwork for a dynamic financial model.

The second day focuses on applying and finalizing the financial model, visualizing outputs, and interpreting results in a strategic context. Topics such as responsible decision-making and ESG considerations are integrated. The day concludes with a practical case study and development of a stakeholder-oriented dashboard.

Upon completion of the course the student:
1. Values organization and management theories, research findings and best practices for running international business organizations.
-Explain the theoretical foundations of financial modeling, including the role of assumptions in model construction.
-Describe the process of developing and documenting financial assumptions through triangulation of data sources.
-Discuss the relevance of financial projections in corporate decision-making

2. Applies evidence-based methods to address managerial problems under conditions of uncertainty and limited information.
-Construct integrated pro forma financial statements—including the Income Statement, Balance Sheet, and Statement of Cash Flows—based on researched and documented assumptions.
-Develop dynamic dashboards using Microsoft Excel and Power BI to visualize and communicate key financial performance indicators to stakeholders.
-Apply financial modeling techniques to evaluate corporate decisions related to dividend policy, capital budgeting, capital structure, and mergers and acquisitions.

3. Collaborates in diverse teams, demonstrating creativity and initiative to propose strategic solutions for digitalization and ESG-related business challenges
-Demonstrate ethics through and responsible financial decision-making aligned to global environmental, social, and governance (ESG) standards.
-Collaborate in cross-cultural and interdisciplinary teams to develop appreciation for different approaches to solving financial performance challenges.

4. Reflects on personal and professional growth to prepare for a role as an international business leader.
-Evaluate their own decision-making processes in financial modeling, identifying personal biases, ethical considerations, and areas for improvement.
-Reflect on their growth in applying financial modeling tools and theories, assessing how these skills contribute to their professional development and strategic thinking capabilities.

5. Communicates effectively across cultural and professional boundaries.
-Communicate complex financial information clearly and effectively to diverse stakeholders using data visualization and storytelling techniques.
-Participate as critical contributor to financial decision making processes.

To successfully complete the course and receive a certificate, participants must actively participate in sessions, complete independent assignments, and submit a final project.

• Assignments: Tasks related to the integration of financial statements, sensitivity analysis, and scenario modelling.
• Final project (exam): Development of a comprehensive financial model in Excel/Power BI, including a management dashboard and strategic interpretation.
• Active participation: Engagement in workshops, group work, and class discussions.

The course is delivered on-site at EBS with access to a modern learning environment, including the cloud-based Canvas platform, study materials, and the EBS library. Digital tools and financial data sources (APIs, databases, reporting platforms) are used throughout. Software tools include Excel, Power BI, and Python (with Pandas and Matplotlib). Participants must bring a laptop with at least 8GB RAM, Excel, free Power BI Desktop, and a working Python environment.