2013/2014, Semester 1
School of Business (Finance)
Modular Credits: 4
The objective of this course is to provide students with an understanding of the theories and methodologies of financial modelling. It trains students to apply finance theories to solve various problems in financial management, investments, portfolio management, and risk management. This objective is achieved by teaching students how to design and implement financial models in the computer, with Excel as the main tool. It covers four classes of models: Corporate Finance models, Portfolio Models, Option-Pricing Models and Bond Models. It also covers simulation, some numerical methods, and VBA programming as well.
ACC1002 Financial Accounting • FIN2004 Finance • FIN3102 Investment Analysis and Portfolio Management • An aptitude with mathematics and programming would be a plus.
Workload Components : A-B-C-D-E
A: no. of lecture hours per week
B: no. of tutorial hours per week
C: no. of lab hours per week
D: no. of hours for projects, assignments, fieldwork etc per week
E: no. of hours for preparatory work by a student per week