WHU | Logo

Financial Modeling in Excel/VBA - F-

Kurs ID
FIN625
Art des Kurses
MSc Kurs
Wochenstunden
2,5
ECTS
5,0
Semester
FS 2023
Vortragssprache
Englisch
Vortragende/r
Juniorprof. Dr. Simon Straumann
Bitte beachten Sie, dass AustauschstudentInnen im BSc-Programm der WHU eine höhere Anzahl an Credits erwerben als hier aufgeführt. Für weitere Informationen wenden Sie sich bitte direkt an das [International Relations Office].
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
  • User Forms
  • Recording and editing Macros
Date Time
Wednesday, 11.01.2023 15:30 - 18:45
Wednesday, 18.01.2023 15:30 - 18:45
Wednesday, 01.02.2023 15:30 - 18:45
Tuesday, 07.02.2023 11:30 - 15:15
Wednesday, 08.02.2023 15:30 - 18:45
Wednesday, 15.02.2023 15:30 - 18:45
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
  • Create UserForms in Excel VBA
  • Record and edit Macros
  • Automate processes/tasks using Excel VBA
The course is structured as a workshop. After an introduction to VBA, we will mainly solve case studies.

Additional e-learning material is provided.

The grading is based on a written take-home exam (100%).
All the material covered in the course is relevant for the exam.
Prior knowledge in Finance is expected. I recommend having attended the Capital Market Theory class.
150
WHU | Logo