English   Danish

2016/2017  KAN-CCMVI2017U  Graduate Financial Modeling

English Title
Graduate Financial Modeling

Course information
Language English
Course ECTS 7.5 ECTS
Type Elective
Level Full Degree Master
Duration Summer
Start time of the course Summer
Timetable Course schedule will be posted at calendar.cbs.dk
Max. participants 80
Study board
Study Board for MSc in Economics and Business Administration
Course coordinator
  • Course instructor - Dr Hassan Tanha, College of Business, Victoria University Melbourne Australia, ht.acc@cbs.dk
    Sven Bislev - Department of Management, Society and Communication (MSC)
In case of any academic questions related to the course, please contact the course instructor or the academic director, Sven Bislev at sb.ikl@cbs.dk
Main academic disciplines
  • Finance
Last updated on 29/05/2017
Learning objectives
To achieve the grade 12, students should meet the following learning objectives with no or only minor mistakes or errors:
  • Technical aspects of advanced Excel: Master VBA on a basic level. Learn to use Data tables to do sensitivity analysis, incorporate the Excel Personal Notebook in your work to make your work more efficient.
  • Understand the use of random number generation for financial simulations. Learn to simulate uniform and normal distributions and to generate correlated random numbers that can be used in finance.
  • Understand log-normality of financial data and how to use this in Monte Carlo simulations of investment performance.
  • Implement standard option models: the Black-Scholes model and the binomial model.
  • Simulate option models using Monte Carlo methods. Special emphasis will be placed on path-dependent and exotic options.
  • Download stock data, calculate the var-cov matrix and Find optimal portfolios.
Course prerequisites
At least two previous courses in finance (Introduction to finance or corporate finance and an investments course) plus a basic knowledge of Excel (advanced concepts will be covered in class).
Examination
Graduate Financial Modeling:
Exam ECTS 7.5
Examination form Written sit-in exam
Individual or group exam Individual exam
Assignment type Written assignment
Duration 4 hours
Grading scale 7-step scale
Examiner(s) One internal examiner
Exam period Summer, Ordinary exam: End of July - beginning of August 2017.

Retake exam: End of September - beginning of October 2017.

3rd attempt (2nd retake) exam: End November - beginning of December 2017.

Exam schedule is available on http://www.cbs.dk/summer http:/​/​www.cbs.dk/​uddannelse/​summer-university-programme/​exam.
Aids allowed to bring to the exam Closed book: no aids
Make-up exam/re-exam
Same examination form as the ordinary exam
If the number of registered candidates for the make-up examination/re-take examination warrants that it may most appropriately be held as an oral examination, the programme office will inform the students that the make-up examination/re-take examination will be held as an oral examination instead.
4 hour written sit-in exam, new exam question.

Exam form for 3rd attempt (2nd retake): 72 hours home project assignment, max. 10 pages.
Course content and structure

This course focuses on simulation and Monte Carlo techniques in financial markets. We will use Excel throughout. The course is numerically intensive and requires a considerable amount of student input. It will be taught in a computer lab. The course topics include random number generation, financial analysis under uncertainty, savings and consumptions  problems, Monte Carlo simulation to compute financial values of complex assets, option pricing with Monte Carlo (Black-Scholes, binomial model, structured securities, exotic options). 
 The learning objectives of this course are to deepen the student’s understanding of advanced financial models under uncertainty. We will emphasize numerical proficiency in Excel, the most widely used computational tool in finance. The combination of Excel as a numerical tool to implement financial modelling is a winning combination.

 

Class 1: Preliminary Assignment; Simple VBA, Data Tables, Excel Personal Notebook (Pre-reading, Ch 31)
Class 2: Introduction to portfolio theory and risk diversification (FM4 Chapter 8)
Class 3:Calculating the Var-Cov Matrix (FM4 Chapter 10) + Calculating Efficient portfolios (FM4 Chapter 9)
Class 4:Estimating Betas and the Security Market Line (FM4 Chapter 11)+ Efficient Portfolios Without Short Sales(FM4 Chapter 12)
Class 5:Black-Litterman Model (FM4 Chapter 13)
Class 6: Introduction to options (FM4, Chapter 15) + Black-Scholes model and structured securities (FM4, Chapter 17)

feedback activity: 

Class 7:The binomial model (FM4 Chapter 16)

Class 8: Random numbers (FM4, Chapter 24)

Class 9:Introduction to Monte Carlo (FM4 Chapter 25)
Class 10:Lognormality — generating price simulations (FM4 Chapter 26) + Monte Carlo for investments (FM4, Chapter 27)
Class 11: Simulating option strategies, Monte Carlo for options (FM4, Chapters 29-30)
Teaching methods
I teach interactively—a combination of lecture, theory of finance, Excel. I expect students to follow along with my lectures, implementing in Excel the models that are explained in class. Home works are an important part of this process—the student must learn to independently implement the financial models.
Student workload
Preliminary assignment 10 hours
Classroom attendance 33 hours
Preparation 144 hours
Feedback activity 7 hours
Examination 12 hours
Further Information

Preliminary Assignment: To help students get maximum value from ISUP courses, instructors provide a reading or a small number of readings or video clips to be read or viewed before the start of classes with a related task scheduled for class 1 in order to 'jump-start' the learning process.

 

Feedback Activity: A feedback activity defined by the course instructor will take place approx. half-way through the course.

 

Course timetable is available on http://www.cbs.dk/uddannelse/summer-university-programme/courses.
Expected literature

Simon Benninga. (n.d.). Financial Modelling. 4th Edition. MIT Press.
Last updated on 29/05/2017