Skip to main content

Unit information: Financial Modelling in 2021/22

Unit name Financial Modelling
Unit code EFIMM0049
Credit points 15
Level of study M/7
Teaching block(s) Teaching Block 2 (weeks 13 - 24)
Unit director Professor. Harris
Open unit status Not open




School/department School of Accounting and Finance
Faculty Faculty of Social Sciences and Law

Description including Unit Aims

The aim of this module is to equip students with the knowledge and tools to implement financial models using Excel and VBA. The course introduces students to the general principles of building financial models, as well as a number of specific financial modelling tools, including the calculation of present and future value, matrix calculations, optimisation, regression analysis, maximum likelihood estimation and simulation. These methods are applied to a range of practical problems in finance, including passive and active portfolio management, performance measurement, risk management and currency valuation. The emphasis of the course is on practical application of the theory, with lectures on each topic followed by in-depth practical classes, in which students work through real world problems using Excel and VBA.

Intended Learning Outcomes

1. Understand the objectives of financial modelling and the characteristics of financial data.

2. Download financial data from the internet for a range of securities, including stocks, bonds, derivatives and currencies.

3. Undertake a range of financial and statistical calculations in Excel and VBA and apply them to specific topics.

4. Design a modelling strategy relevant to a given topic.

5. Manage complex tasks in a team.

6. Present results of the analysis in a formal way.

Teaching Information

Teaching will be delivered through a combination of synchronous and asynchronous sessions including lectures, tutorials, drop-in sessions, discussion boards and other online learning opportunities

Assessment Information

This unit will be assessed by group coursework 60% and individual coursework 40%


If this unit has a Resource List, you will normally find a link to it in the Blackboard area for the unit. Sometimes there will be a separate link for each weekly topic.

If you are unable to access a list through Blackboard, you can also find it via the Resource Lists homepage. Search for the list by the unit name or code (e.g. EFIMM0049).

How much time the unit requires
Each credit equates to 10 hours of total student input. For example a 20 credit unit will take you 200 hours of study to complete. Your total learning time is made up of contact time, directed learning tasks, independent learning and assessment activity.

See the Faculty workload statement relating to this unit for more information.

The Board of Examiners will consider all cases where students have failed or not completed the assessments required for credit. The Board considers each student's outcomes across all the units which contribute to each year's programme of study. If you have self-certificated your absence from an assessment, you will normally be required to complete it the next time it runs (this is usually in the next assessment period).
The Board of Examiners will take into account any extenuating circumstances and operates within the Regulations and Code of Practice for Taught Programmes.