Financial Modelling Using MS Excel and VBA

Financial modelling expertise is of paramount importance to financial professionals, academics and students. Excel and its embedded Visual Basic for Applications (VBA) programming language are therefore preferred tools for them, because with less programming skills complex financial and business models can be developed, solved or simulated therein. This course gives introduction to the Excel and programming techniques of VBA language, and then focuses on the implementation of techniques and financial models (such as data simulation, portfolio optimization, general asset pricing, option pricing, risk management, and corporate finance). The course serves to bridge the gap between financial theory and its implementation.