Module Catalogues

Financial Modelling with Excel VBA

Module Title Financial Modelling with Excel VBA
Module Level Level 2
Module Credits 5.00
Academic Year 2021/22
Semester SEM2

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.