AFW2051

Financial modelling

(BUS)

Mr Chris Gan

6 points + First semester + 3 hours per week + Prerequisites: AFW1022 or AFW1032, plus either ETW1640 or ETW1020

Synopsis: Corporate modelling theory; models as decision support tools; models and user types0 uses of models; types and characteristics of models; benefits and limitations of models; spreadsheets and financial modelling systems. Development of models including reasons for choosing a spread sheet; package comparisons; effective spread sheet model design; planning and development of various financial models using an industry standard spread sheet; auditing existing spreadsheet models; advanced modelling techniques using spreadsheets /macros0.

Assessment: Report writing assignment/essay: 20% + Examination (3 hours): 80%