Info
Foto sezione
Logo Bocconi

Course 2018-2019 a.y.

30177 - FINANCIAL MODELLING

Department of Finance

Course taught in English

Go to class group/s: 31

CLEAM (6 credits - II sem. - OP  |  SECS-P/06) - CLEF (6 credits - II sem. - OP  |  SECS-P/06) - CLEACC (6 credits - II sem. - OP  |  SECS-P/06) - BESS-CLES (6 credits - II sem. - OP  |  SECS-P/06) - WBB (6 credits - II sem. - OP  |  SECS-P/06) - BIEF (6 credits - II sem. - OP  |  SECS-P/06) - BIEM (6 credits - II sem. - OP  |  SECS-P/06) - BIG (6 credits - II sem. - OP  |  SECS-P/06) - BEMACS (6 credits - II sem. - OP  |  SECS-P/06)
Course Director:
PAOLO COLLA

Classes: 31 (II sem.)
Instructors:
Class 31: PAOLO COLLA


Class-group lessons delivered  on campus

Prerequisites

An intermediate level of Excel knowledge is assumed. Students with a basic knowledge are expected to fill their gaps before starting the course. Several Excel user manuals can come handy, for instance: M.MILLER, "Idiot's Guides: Microsoft Excel 2013", Penguin Group, 2014.


Mission & Content Summary
MISSION

The course provides the technical skills for implementing financial models with Excel. Students are equipped with the basic operational tools to understand financial markets and employ the modelling abilities developed via sample applications to build their own models. Coursework mainly focuses on functions already embedded in the worksheet as well as on procedures designed to solve specific problems. The course concentrates on the application of several theoretical models for financial valuation, optimal portfolio choice and performance evaluation.

CONTENT SUMMARY
  • Tools: introduction to Excel (array, financial and statistical functions) and add-ins (Solver and Data Analysis).
  • Mean-variance portfolio choice: efficient frontier with and without shortselling constraints 
  • Bonds: duration, immunization and the term structure of interest rates.
  • Stocks: CAPM, beta estimation and the security market line; APT and multi-factor models.
  • Options: binomial model, lognormal distribution and Black-Scholes model.
  • Further topics: event study, style analysis.

Intended Learning Outcomes (ILO)
KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
  • Understand the functioning of financial markets.
APPLYING KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
  • Implement financial models for asset pricing and portfolio formation.

Teaching methods
  • Face-to-face lectures
  • Exercises (exercises, database, software etc.)
DETAILS

Exercises include Excel worksheets to analyse asset pricing and portfolio investment based on real world data.


Assessment methods
  Continuous assessment Partial exams General exam
  • Written individual exam (traditional/online)
  •     x

    Teaching materials
    ATTENDING AND NOT ATTENDING STUDENTS
    • S. BENNINGA, Financial Modeling, MIT Press, 2014, 4th Edition.
    Last change 02/06/2018 21:19