Financial Modeling in Excel/VBA - (F) - Group 1
Course code
FIN625
Course type
MSc Course
Weekly Hours
2,5
ECTS
5,0
Term
FS 2024
Language
Englisch
Lecturers
Juniorprof. Dr. Simon Straumann
Please note that exchange students obtain a higher number of credits in the BSc-program at WHU than listed here. For further information please contact directly the International Relations Office.
Course content
In this course, students will learn how to apply financial models and theories such as option pricing and asset pricing models in practice using Excel VBA. The course is designed as a workshop in which students will solve specific problems by writing their own computer code under the guidance of the lecturer. This course is for students with no or only limited prior programming skills.
Among others, this course covers the following topics:
- Basic Syntax
- User-defined Macros/Subroutines
- User-defined Functions
- Conditional Statements
- Loops
- Arrays
- Regressions
- Debugging
Class dates
| Date | Time |
|---|---|
| Monday, 08.01.2024 | 15:30 - 18:45 |
| Wednesday, 10.01.2024 | 11:30 - 15:15 |
| Tuesday, 16.01.2024 | 15:30 - 18:45 |
| Thursday, 18.01.2024 | 15:30 - 18:45 |
| Wednesday, 24.01.2024 | 15:30 - 18:45 |
| Friday, 26.01.2024 | 15:30 - 18:45 |
| Thursday, 22.02.2024 | 13:00 - 17:00 |
Learning outcomes
The course is designed as a computer workshop. Guided by the lecturer, students will solve specific problems in finance using Excel VBA. Students will learn the essential Excel VBA features and advance their prior knowledge in finance theory by implementing finance theory into practice using Excel VBA.
Upon completion of the seminar, students will be able to…
- Write user-defined Subroutines and Functions in Excel VBA
- Use debugging tools to correct/optimize their code
- Model stock prices
- Evaluate the price of (exotic) options
- Conduct a performance analysis
Learningmethods
The course is structured as a workshop. After an introduction to VBA, we will mainly solve case studies.
Exam
An assignment (30% / 30 points) and a take-home exam (70% / 70 points)
All the material covered in the course is relevant for the exam.
Requirements
Prior knowledge in Finance is expected. I recommend having attended the Capital Market Theory class.
Total workload
150