2016/2017  KAN-CCMVV2006U  Financial Models in Excel and VBA

 English Title Financial Models in Excel and VBA

Course information

Language English
Course ECTS 7.5 ECTS
Type Elective
Level Full Degree Master
Duration One Semester
Start time of the course Autumn
Timetable Course schedule will be posted at calendar.cbs.dk
Max. participants 100
Study board
Course coordinator
• Peter Raahauge - Department of Finance (FI)
Contact information: https:/​/​e-campus.dk/​studium/​kontakt
• Finance
Last updated on 01-12-2016
Learning objectives
To achieve the grade 12, students should meet the following learning objectives with no or only minor mistakes or errors: The student should be able to implement correctly in Excel and VBA the right method for solving the questions asked at the exam.
Course prerequisites
The course is oriented towards a master-students with solid quantitative skills and the following background:

1. Master course in portfolio theory,
2. Master course in bond and option analysis
4. Math course in optimization and basic matrix algebra.

Due to overlap, students cannot follow both this course and Financial Models in Excel.

Note that it is not possible to write a term paper in this course.
Examination
Course content and structure

The aim of the course is to provide capabilities of practical implementation of financial theory using real world data.

Compared to Financial Models in Excel, the course utilizes the the students quantitative skills and VBA to a greater extend.

The course is very exercises based, and the main workload consists of solving exercises in Excel for each of the 14 topics dealt with during the course.

The course provide lectures online as screencasts and physical lessons. The former will assist the students understanding and ability to solve the exercises. The latter will be driven by problems and questions raised by the students.

The topics/exercises dealt with in the course are as follows:

1. Introduction to Excel and VBA for basic financial problems
2. Monte Carlo, return properties, and portfolios.
4. Black-Litterman
5. Empirical tests of the CAPM
6. Factor models
7. Performance evaluation of investment funds.
8. Black-Scholes and implied volatility
9. Volatility predictions (Moving average, ARCH, GARCH)
10. European, American, and Bermuda options in binomial grids
11. European and Asian option prices based on Monte Carlo
12. Bonds and immunization strategies
13. Term structure estimation and advanced immunization
14. Interest rates in binomial grids and callable bond prices
15. (If time permits) Risk Management
Teaching methods
The course is very exercises based, and the main workload consists of solving exercises in Excel for each of the 14 topics dealt with during the course.

The course provide lectures online as screencasts and physical lessons. The former will assist the students understanding and ability to solve the exercises. The latter will be driven by problems and questions raised by the students.
 Course Introduction 2 hours 14x12 hours work outside classroom (online) with 14 worked examples 168 hours Scheduled "flipped classroom" classes with instructor 31 hours Exam preparation 5 hours
Further Information

Term papers are not allowed due to the special nature of the course

Expected literature

Simon Benninga, Financial Modelling

• ISBN-10:0262027283
• MIT Press
• 4. edition

Notes and exercises

Last updated on 01-12-2016