| Unit name | Financial Modelling |
|---|---|
| Unit code | ACFIM0040 |
| Credit points | 20 |
| Level of study | M/7 |
| Teaching block(s) |
Teaching Block 2 (weeks 13 - 24) |
| Unit director | Professor. Harris |
| Open unit status | Not open |
| Units you must take before you take this one (pre-requisite units) |
None |
| Units you must take alongside this one (co-requisite units) |
None |
| Units you may not take alongside this one |
None |
| School/department | School of Accounting and Finance - Business School |
| Faculty | Faculty of Social Sciences and Law |
Why is this unit important?
Financial Modelling bridges the gap between theory and practice, equipping students with the knowledge and tools that are needed to solve real-world problems that are faced by investment banks, fund management companies and other financial institutions. The unit introduces students to the general principles of financial modelling, the use of financial data, as well as methodological tools that are useful for implementing a financial model, such as matrix operations, numerical optimisation, sensitivity analysis and simulation. These methods are applied to a wide range of applications in finance drawn from investment analysis, corporate finance, fixed income analysis, risk management and financial econometrics. The emphasis of the unit is on practical application of the theory through the extensive use of realistic case studies that students solve using Excel, VBA and, optionally, Python.
How does this unit fit into your programme of study?
Financial Modelling builds on several units delivered in Teaching Block 1, including Asset Pricing and Fundamentals of Corporate Finance. In particular, it provides students with the tools to implement some of the theories and concepts that are covered in these units in a real-world setting through the extensive use of practical case studies. It also complements several of the optional units that are delivered in Teaching Block 2, such as Derivatives and Investment Management, by extending some of the material that is covered by these units to include models and techniques that are widely used in the finance industry.
An overview of content
The unit covers both the general principles of financial modelling and the specific tools that prove to be useful to implement a financial model in practice. These techniques are illustrated with a wide range of applications in finance drawn from investment analysis, corporate finance, fixed income analysis, risk management and financial econometrics, including the estimation of the required returns on debt and equity, construction of optimal passive and active investment portfolios, forecasting the volatility of financial asset returns and the estimation of portfolio risk. The emphasis of the unit is on practical application of the theory, with lectures on each topic followed by in-depth practical classes in which students work through comprehensive realistic case studies using Excel, VBA and, optionally, Python.
How will students, personally, be different as a result of the unit
The unit develops in students the ability to solve some of the practical challenges that they are likely to encounter in a career in the finance industry. In so doing students will acquire not only an understanding of the principles and practice of financial modelling, but also valuable transferable analytical skills such as the ability to analyse data and write a professional report, as well as proficiency in Excel, VBA and Python.
Learning Outcomes
By the end of the unit, students should be able to:
How you will learn
Teaching will be delivered through a combination of lectures, exercise lectures and online clinics. Lectures will cover the principles and methods of financial modelling, illustrated with extensive practical examples. In the exercise lectures, students will work through practical case studies that allow them to implement, under guidance, what they have learned in the lectures. The online clinics give students the opportunity to raise and discuss questions related to any aspect of the unit, including the lecture material, practical case studies and the formative and summative assessment.
Tasks which help you learn and prepare you for summative tasks (formative):
Students will undertake a group assignment of similar form to that of the individual summative assessment (see below), with written feedback provided on the content and presentation of the submitted report.
Tasks which count towards your unit mark (summative):
The unit is assessed by a single individual assignment (2,500 words) in which students will use the financial modelling techniques that they have learned to solve a comprehensive practical case study, and write up the details of the financial model together with their results and conclusions into a professionally presented report. The assignment tests ILO1, ILO2 and ILO3.
When assessment does not go to plan
The re-assessment will take the same form as the original assessment.
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. ACFIM0040).
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 University Workload statement relating to this unit for more information.
Assessment
The assessment methods listed in this unit specification are designed to enable students to demonstrate the named learning outcomes (LOs). Where a disability prevents a student from undertaking a specific method of assessment, schools will make reasonable adjustments to support a student to demonstrate the LO by an alternative method or with additional resources.
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. For appropriate assessments, if you have self-certificated your absence, you will normally be required to complete it the next time it runs (for assessments at the end of TB1 and TB2 this is usually in the next re-assessment period).
The Board of Examiners will take into account any exceptional circumstances and operates
within the Regulations and Code of Practice for Taught Programmes.
