Financial Modelling

This course introduces a set of analytical tools to solve practical problems in finance using Microsoft Excel. The objective is to bridge the gap between theory and practice by understanding the theoretical foundations of financial models, implementing these models in Excel with real-world data, and using the outcomes to support financial decision making. The course helps students to gain the financial knowledge and modeling skills needed to succeed in the financial industry that is increasingly relying on quantitative models. Topics covered in the course include portfolio optimization techniques, performance evaluation methods, option pricing models, and risk management models. The course builds on the introduction to financial markets and portfolio theory given in the Investments course and prepares students for more advanced elective courses in quantitative finance.