FIN41490 Financial Modelling

Academic Year 2017/2018

Financial Modelling is an Elective option designed to provide a practical understanding of how businesses assess and forecast financial performance. Through case studies, this course will focus on modeling and evaluating operational cash flow, working capital requirements, financing instruments, tax, pensions and depreciation, with a focus on the capital structure of a business. Interpretation of the financial modelling output will form an important part of the course.

Financial modelling is a fundamental requirement in assessing businesses performance. This course is essential for any student wishing to gain a deeper understanding of how to evaluate financial performance and assess capital structure issues and is vital for those wishing to pursue a career in Corporate Finance. A core component of the course will be Microsoft Excel based and a base level of knowledge in that area is assumed.

Show/hide contentOpenClose All

Curricular information is subject to change

Learning Outcomes:

On completion of this module students should be able to:
- Demonstrate their ability to interpret financial information and use it to assess historic and forecast company performance.
- Model the key cashflow items within a business, with a focus on operational and financing cashflows including working capital, debt instruments, tax, depreciation and pensions through Microsoft Excel.
- Understand the capital restructuring process and the options available to businesses.
- Recommend an appropriate restructuring route, understand the implications of a capital restructuring process and how to maximise success.
- Comment on the strategies, opportunities and risks of investing in distressed situations.

Student Effort Type Hours
Lectures

24

Autonomous Student Learning

80

Total

104

Requirements, Exclusions and Recommendations

Not applicable to this module.



 
Description % of Final Grade Timing
Continuous Assessment: 2 x projects, one group based, one individual

70

Varies over the Trimester
Examination: 2 hour written exam

30

2 hour End of Trimester Exam

Compensation

This module is not passable by compensation

Resit Opportunities

In-semester assessment

Remediation

If you fail this module you may repeat, resit or substitute where permissible

Discover our Rankings and Accreditations