AFF2051

Financial modelling ( 6 points, SCA Band 2, 0.125 EFTSL)

Leader: Dr Ian Beaman

Offered:
Caulfield First semester 2006 (Day)
Caulfield First semester 2006 (Evening)
Caulfield First semester 2006 (OCL)
Malaysia First semester 2006 (OCL)
Singapore First semester 2006 (OCL)
Caulfield Second semester 2006 (Day)

Synopsis: Corporate modelling theory; models as decision support tools; models and user types; 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 spreadsheet; package comparisons; effective spreadsheet model design; planning and development of various financial models using an industry standard spreadsheet; auditing spreadsheet models.

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

Contact Hours: 3 hours per week

Prerequisites: AFF1110 or AFF1121 and ETX1100

Prohibitions: BUS3030