Module Catalogues

Financial Modelling with Excel VBA

Module Title Financial Modelling with Excel VBA
Module Level Level 2
Module Credits 5.00

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.