Financial Modeling and Analytics

This course introduces a set of analytical tools to solve practical problems in finance using Microsoft Excel and VBA programming. The objective is to bridge the gap between theory and practice by implementing financial models in Excel, taking them to real-world data, and using the outcomes to support financial decision making. The course helps students to gain important financial, statistical, and programming knowledge necessary to succeed in the financial industry that is increasingly relying on data analytics. Topics include risk measurement and management, option pricing, hedging, portfolio optimization, and performance evaluation. 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, programming, and data analytics.