2015/2016
KAN-CCMVV1616U Financial Models in Excel (full semester
version)
| English Title |
| Financial Models in Excel (full
semester version) |
|
|
| Language |
English |
| Course ECTS |
7.5 ECTS |
| Type |
Elective |
| Level |
Full Degree Master |
| Duration |
One Semester |
| Start time of the course |
Autumn, Spring |
| Timetable |
Course schedule will be posted at
calendar.cbs.dk |
| Max. participants |
100 |
| Study board |
Study Board for MSc in Economics and Business
Administration
|
| Course
coordinator |
- Peter Raahauge - Department of Finance (FI)
|
Teacher: Peter
Raahauge - pr.fi@cbs.dk
Kontaktinformation:
https://e-campus.dk/studium/kontakt
eller Contact information:
https://e-campus.dk/studium/kontakt |
| Main academic
disciplines |
|
|
|
Last updated on
26-03-2015
|
| Learning objectives |
| To achieve the grade 12, students
should meet the following learning objectives with no or only minor
mistakes or errors: The student should be able implement correctly
in Excel the right method for solving the questions asked at the
exam. |
| Course prerequisites |
The course is oriented towards a
second year master student (at CBS) with the following background:
1. Master course in portfolio theory,
2. Master course in bond and option analysis
3. Introductory course in statistics
4. Basic knowledge about optimization and matrix algebra.
Students at cand. merc.mat, cand.oecon, and cand.merc.fin cannot
follow this course due to overlap. Instead, they are referred to
the course Financial Models in Excel and VBA.
Due to overlap, students cannot follow both this course and
Financial Models in Excel and VBA. |
| Examination |
|
Financial
Models in Excel (full semester version):
|
| Exam ECTS |
7,5 |
| Examination form |
Written sit-in exam |
| Individual or group exam |
Individual |
| Assignment type |
Written assignment |
| Duration |
4 hours |
| Grading scale |
7-step scale |
| Examiner(s) |
One internal examiner |
| Exam period |
Winter and Summer |
| Aids allowed to bring to the exam |
Limited aids, see the list below:
- Written sit-in-exam on CBS' computers
- Books and compendia brought by the examinee
- Allowed dictionaries
- Allowed calculators
- Notes in paper format brought by the examinee
- Access to personal drive (S-drive) on CBS' network
- USB key to upload your notes before the
exam
|
| Make-up exam/re-exam |
Same examination form as the ordinary exam
If the number of registered candidates for the make-up
examination/re-take examination warrants that it may most
appropriately be held as an oral examination, the programme office
will inform the students that the make-up examination/re-take
examination will be held as an oral examination
instead.
|
Description of the exam
procedure
PC exam on CBS computers without print.
It is not allowed to bring your own PC and printer.
No access to the internet and Learn.
Access to personal S:/drive.
Before the exam starts information can also be uploaded from a
USB-key to PC, then the USB-Key should be put away during
exam.
|
|
| Course content and
structure |
|
The aim of the course is to provide capabilities of practical
implementation of financial theory using real world data.
The course is very exercises based, and the main workload consists
of solving exercises in Excel for each of the 14 topics dealt with
during the course.
The course provide lectures online as screencasts and
physical lessons. The former will assist the students understanding
and ability to solve the exercises. The latter will be driven
by problems and questions raised by the students.
The 14 topics/exercises dealt with in the course are as
follows:
- Introduction to Excel (Names, array functions, matrix/vector
calculation, the Excel-solver, regression analysis etc.)
- Datastream, mean values and standard deviations of stock
portfolios
- Portfolios at the efficient frontier
- The eff. frontier without short-sale and empirical test of
CAPM
- Performance evaluation of investment funds.
- Black-Scholes and implied volatility
- Volatility predictions (Moving average, ARCH, GARCH)
- European, American, and Bermuda options in binomial grids
- European and Asian option prices based on Monte Carlo
- Portfolio choice under parameter uncertainty
- Bonds, duration, and immunization strategies
- Term structure estimation and advanced immunization
- Term structure estimation, cubic spline
- Interest rates in binomial grids and callable bond
prices
|
| Teaching methods |
The course is very exercises based,
and the main workload consists of solving exercises in Excel for
each of the 14 topics dealt with during the course.
The course provide lectures online as screencasts and physical
lessons. The former will assist the students understanding and
ability to solve the exercises. The latter will be driven by
problems and questions raised by the students. |
| Further Information |
|
Term papers are not allowed due to the special nature of the
course.
|
| Expected literature |
|
Simon Benninga, Financial Modeling
- ISBN-10:0262027283
- MIT Press
- 4. edition
Notes and exercises
|
Last updated on
26-03-2015
Permalink