Practical Financial Modelling

(5 Credit Hours) · Undergraduate

Financial modelling using Microsoft Excel is used in many fields such as investment banking, mergers and acquisitions (M and A), equity research, risk analysis, valuations, investment management, credit analysis, financial projections and project evaluations. This module is designed to equip students with skills to implement financial models using Excel. It will also introduce the use of VBA (Visual Basic for Applications, Microsoft's programming language) in financial modelling. This is an applied module with an emphasis on the practical application of finance theory through in-depth Excel based laboratories. Material will be made relevant to the international finance industry with real world examples and problems relevant to global financial markets. The goal of this module is to provide students with extensive knowledge of the quantitative models used by financial institutions around the world.