Organisation:		News:
Instructors:	Prof. Dr. G. Löffler and	First session on Monday, 26th of April, between 2-4pm in Heho 18, room 120.
	Jürgen Bohrmann,Alina Maurer,
	Matthias Böhm and Thomas Verchow
Lecture:	Monday, 2-4 pm, He18, Room E20 & 120

You can send an (even anonymous) feedback using the feedback form and choosing your desired recipient. Contact Jürgen Bohrmann if you have questions about this course.

Please bring your own laptop. Only roughly ten university laptops are available.

Downloads are password protected. The username is „student“ and the password will be given in the lecture and is available on the withboard in front of our rooms. You can use your ANA (Authentifizierter Netzzugangs-Account) from kiz and the webVPN to bypass the protection.

 

Prerequisites:

Familiarity with basic concepts from financial economics (discounting, risk and return, option pricing). The course is structured such that you can acquire such a knowledge by parallel attendance of the lecture „Finanzierung“.

Know the basics of Excel. If you're an Excel novice watch the Video Excel for Beginners (avi, 71 MB) or the German version of it (Excel für Excel Anfänger (avi, 51 MB)) before classes start. Videos are available on our Webomaut. A flash version of the video (swf, 3.9 MB) is available too.

   

Dates & Downloads:

Date	Instructor	Content
26.04.2010	Bohrmann	Introduction to Excel, Problem (xls, 30k)
03.05.2010	Bohrmann	Bond pricing, Problem (xls, 27k)
10.05.2010	Maurer	Yield curves, spot rates, bond stripping
17.05.2010	Maurer	Working with multi-stage Dividend Discount Model
24.05.2010	Bohrmann	Introduction Excel's VBA (xls, 29k), Handout (pdf, 63k), for an extensive VBA introduction see our webomaut
31.05.2010	Löffler	Technical trading
07.06.2010	Löffler	Momentum strategies
14.06.2010	Verchow	Portfolio analysis
21.06.2010	Verchow	Portfolio analysis II
28.06.2010	Böhm	Fund valuation
05.07.2010	Böhm	DCF analysis
12.07.2010	Böhm	Simulations
-	-	Sample Questions (pdf, 44k) for the exam.

Course:

A typical session will look like this:

• The instructor introduces the problem (10 minutes)
• Students solve the problem on the PC with Excel; instructor is available to answer questions (70 minutes)
• Some results may be presented in the meantime
• Discussion of the modelling approaches and the final results (10 minutes)

A restricted number of laptops is available in the classroom. You can bring your own laptop.

Language of instruction is most probably English; individual questions can be discussed in German.

Course contents:

• Bond pricing and interest rate analysis
• Risk and return
• Investment strategies
• Financial statement modeling
• Valuation

 

Learning goals:

Students are able to solve practical financial problems with Excel, using spreadsheet functions as well as VBA programming. Students will also have an increased familiarity with methods and concepts from finance.

 

Exam:

Master of Finance students earn 3 credits for this course.

There will be a written exam at the end of the semester.