Aims and Fit of Module
This course gives an introduction to financial modeling with hands on experience in Excel
VBA programming. The module is designed to complement the theoretical knowledge
developed in the financial mathematics programme with practical applications. The module
not only contributes to the development of programming and computational skills of students
but also improves the understanding of the financial mathematics theory via hands on practice
with one of the most commonly used software.
Learning outcomes
A Understand and implement advanced modeling techniques in Excel VBA
B Define and implement user defined Excel VBA functions
C Understand, analyze and apply portfolio optimization and CAPM model
D Understand, analyze and implement option pricing models in Excel VBA
E Understands, analyze and implement term structure models for pricing fixed income securities
Method of teaching and learning
This module will be delivered by a combination of formal lectures and tutorials.
Furthermore, assignments and continuous work provides sufficient practice and timely
feedback.