Undergraduate Course: Financial Modelling with Excel (BUST10025)
Course Outline
| School | Business School |
College | College of Humanities and Social Science |
| Credit level (Normal year taken) | SCQF Level 10 (Year 4 Undergraduate) |
Availability | Available to all students |
| SCQF Credits | 20 |
ECTS Credits | 10 |
| Summary | The course is aimed at students in their final year of study taking MA Business Management or Business joint degrees. The course extends the core theory introduced in Principles of Finance by emphasizing its practical application to strategic financial decisions and potential financial problems. |
| Course description |
Construct and examine the characteristics of distributions of returns; calculate the variance co-variance matrix and use it to select portfolios; test for market efficiency using simple tests; develop, construct and run event studies; estimate betas and calculate a firm¿s cost of capital; calculate the value of an option using the Black-Scholes model; apply Monte Carlo methods to financial problems; use and develop spreadsheet based solutions to financial problems; use Visual Basic for Applications (VBA) techniques.
SYLLABUS
Introduction - basic financial calculations in Excel;
Portfolio models;
Market efficiency;
Event studies;
Bonds;
Option pricing models;
Monte Carlo methods;
Corporate finance models.
STUDENT LEARNING EXPERIENCE
Financial Modelling with Excel is intended to give students the opportunity to widen and deepen their knowledge of financial theory and practice by explaining how financial models and techniques may be implemented. Students are expected to use Excel to model a number of common applications including the construction of portfolios, tests of market efficiency, estimation of risk measures, performance measurement and the valuation of options. By the end of the course students should have a much clearer understanding of finance concepts as well as an extended knowledge of the spreadsheet package.
|
Entry Requirements (not applicable to Visiting Students)
| Pre-requisites |
Students MUST have passed:
Principles of Finance (BUST08003)
|
Co-requisites | |
| Prohibited Combinations | |
Other requirements | None |
Information for Visiting Students
| Pre-requisites | None |
| High Demand Course? |
Yes |
Course Delivery Information
|
| Academic year 2015/16, Available to all students (SV1)
|
Quota: 40 |
| Course Start |
Semester 2 |
Timetable |
Timetable |
| Learning and Teaching activities (Further Info) |
Total Hours:
200
(
Lecture Hours 20,
Programme Level Learning and Teaching Hours 4,
Directed Learning and Independent Learning Hours
176 )
|
| Assessment (Further Info) |
Written Exam
0 %,
Coursework
100 %,
Practical Exam
0 %
|
| Additional Information (Assessment) |
Two final research projects count for 100% of the grade. The first project (50%) will be individual with a maximum of 3,000 words. It will cover the work of the first part of the course (Portfolio Models, Market Efficiency and Event Studies). The second project (50%) will be individual with a maximum of 3,000 words. It will cover the second part of the course (Bonds, Option Pricing Models and Corporate Finance Models). Both projects must be handed in during the April/May exam diet. |
| Feedback |
Project marks will be posted on Learn, together with mark statistics and generic feedback on both projects, as soon as possible after the Boards of Examiners¿ meeting (normally early-mid June). Students can also look at their manuscripts after publication of marks in the Business School Undergraduate Office (Room 1.11, Business School, 29 Buccleuch Place).
|
| No Exam Information |
Learning Outcomes
On completion of this course, the student will be able to:
- Construct and examine the characteristics of distributions of returns, and calculate the variance co-variance matrix and use it to select optional portfolios.
- Test for market efficiency using simple tests.
- Develop, construct and run an event study analysis of the abnormal returns.
- Estimate betas and calculate a firm's cost of capital.
- Calculate the value of an option using Black Scholes and the binomial model.
|
Reading List
Benninga, S., 2008, Financial Modeling, The MIT Press, Third Edition.
J & S: Jackson M. and Staunton M., 2001, Advanced Modelling in Finance using Excel and VBA, John Wiley and Sons Ltd.
B & M: Brealey R.A. and Myers S., 2003, Principles of Corporate Finance, Seventh Edition, McGraw Hill.
|
Additional Information
| Course URL |
http://www.bus.ed.ac.uk/programmes/ugpc.html |
| Graduate Attributes and Skills |
Financial Modelling is designed to be interesting and practical. The multitude of skills that students will acquire in this course will enhance their marketability to potential employers in the field of finance. The course is intended to give students the opportunity to widen and deepen their knowledge of financial theory by explaining how financial models and techniques may be implemented. |
| Keywords | FME |
Contacts
| Course organiser | Ms Tatiana Rodionova
Tel: (0131 6)50 3789
Email: |
Course secretary | Dr Caroline Hall
Tel: (0131 6)50 8336
Email: |
|
© Copyright 2015 The University of Edinburgh - 27 July 2015 10:45 am
|
University Homepage