Home | Teaching | CV | Resources |Excel tips| Send a message

Professor André FARBER
Solvay Brussels School of Economics and Management

Université Libre de Bruxelles

Blogs: finance@solvay & André Farber

GEST-S-502 DERIVATIVES
2011-2012

Announcements
April 25, 2012 Update with slides and Excel files used in class
March 20, 2012 Posted several Excel files used class
M
arch 7, 2012 Posted Case study 1 + Data
-----------------Excel files: CDS Bund valuation + Duration hedge

February 13, 2012
Added links to new blogs & Class note 1 update
January 22, 2012
Class will start Wednesday February 8 at 8 AM room R42.5.110
I start udpdating the Derivatives website. New files will be posted as the course proceeds.

Course outline 2012
Meet
John Hull
at his website

Class notes (to be updated)
Class note 1 - Session 1
Introduction
Case study: Gamma Airlines + Solution
DB Research OTC derivatives’ new market infrastructure

WSJ Futures prices p1 and p2
Class note 2 - Session 2
Pricing Forward and Futures
Case study: Silver Mining + PP Solution
Class note 3 – Session 3 + Hedging with futures
Case study: Texoil + PP Solution + Excel Solution
Class note 4 - Session 4
Interest Rate Derivatives
Additional class note - duration
Case study: Peoples’ Car + PP Solution

Class note 5 - Session 5
Swaps
Case study 1 2012 + Data case study 1 2012 NEW

Class note 6 - Session 6
Pricing options
Case study: BNPParibas + Solution
Class note 7 - Session 7 Inside Black Scholes
Case study: AluFrance + Solution
Class note 8 - Session 8 Greeks NEW 2011
Case study: under construction
Class note 9 - Session 9 Using options
Strategies used by Madoff and Kerviel
Case study: Ask Agatha + Solution
Class note 10 – Session 9
Beyond Black Scholes
Classe note 10/1 Beyond Black Scholes: more on lognormal distribution
Class note 11 - Session 11 Options on bonds and interest rates
Class note 11/1: Options on bonds and interest rates (I)NEW 2012
Class note 11/2: Options on bonds and interest rates (II)

Case study 2 2012:

Teaching notes:
IR Derivatives - Summary (pdf)
Futures on Government Bonds
Interest Rates Futures
Swap - Summary (pdf)
Binomial option pricing model (pdf)

Additional Short case studies
Comtrade
Forward contract
Société Automobile Belge
Interest Rate Futures
Orange County
Updated 2011
Belgofin
Interest Rate Swap
Microswiss
Currency Swap
Belcom, pension fund
- lognormal property of stock prices

Questions and Problems
Practice is the only way to master the derivative beasts. Below are some suggestions of useful Q&P in Hull (6th ed). Work them out before looking at the solution.
Hull 6th ed Selected solutions
Hull 7th ed Selected solutions NEW 2011

Here are the formulas that I will join to the final exam.
Old exam questions in English with short answer
Past exams + Solutions (up to 1999)
Examen Janvier 2001
+ Solution
Exam January 2000
+ Solution
Exam January 2002
+ Solution
Exam January 2003 + Solution
Exam January 2004 + Solution
Exam January 2005 + Solution
Exam January 2006 + Solution
Exam January 2007 + Solution
Exam January 2008 + Solution

Excel Files used in class (Exx) + some older files
Futures
Illustrations of futures price calculations
E21 Fwd Price vs Expected spot price NEW 2012
E22 Fwd Rate vs Expected spot rate NEW 2012
E30 Fwd on Zero Coupon - Review NEW 2012
E31 Index Futures Simulation NEW 2012
E40 Government Bond Futures Valuation : To understand FGBL futures
E41 Duration hedge

E50 Interest Rate Swap
Illustration
E51 Currency Swap
Illustration
Geometric Brownian motion
- Illustration
E60 Binomial representation of GBM
NEW 2012
E61 RN pricing and CAPM
NEW 2012
E62 Binomial 3-period
NEW 2012
E70 Lognormal distribution
NEW 2012
E71 Black Scholes in Excel
Option strategies 

E81 Delta and Gamma Hedging NEW 2012
E82 Portfolio insurance NEW 2012
E101 IROPT Ho & Lee (I)

E102 IROPT Ho & Lee (II)
E103 IROPT BDT
Barrier options valuation in Excel
E111 Exotic option: binomial presentation 
E112 Exotic option: binomial Monte Carlo 
Options on bonds and interest rates

Additional readings
(to download from various Web sites)
Risk Management Lessons from LTCM - P. Jorion

Last update : Mai 6, 2012