University of St Andrews

Key information

SCOTCAT credits : 20

ECTS credits : 10

Level : SCQF level 10

Semester: 2

Availability restrictions: Available to General Degree students with the permission of the Honours Adviser

Planned timetable: To be arranged

Financial modelling using Microsoft Excel is used in many fields such as investment banking, mergers and acquisitions (M and A), equity research, risk analysis, valuations, investment management, credit analysis, financial projections and project evaluations. This module is designed to equip students with skills to implement financial models using Excel. It will also introduce the use of VBA (Visual Basic for Applications, Microsoft's programming language) in financial modelling. This is an applied module with an emphasis on the practical application of finance theory through in-depth Excel based laboratories. Material will be made relevant to the international finance industry with real world examples and problems relevant to global financial markets. The goal of this module is to provide students with extensive knowledge of the quantitative models used by financial institutions around the world.

Relationship to other modules

Pre-requisite(s): Before taking this module you must pass EC4430 and pass EC4417

Learning and teaching methods and delivery

Weekly contact: 1-hour lecture (X11 weeks), 2-hour practical classes, Excel labs (X 11 weeks)

Scheduled learning hours: 33

Guided independent study hours: 168

Assessment pattern

As used by St Andrews: 100% Coursework

As defined by QAA
Written examinations : 0%
Practical examinations : 0%
Coursework: 100%

Re-assessment: 100% Coursework

Personnel

Module coordinator: Dr M C Iannino
Module teaching staff: Dr Maria Chiara Iannino