AFW2051

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

Leader: Mr Peter Krueger

Offered:
Berwick First semester 2006 (Day)
Gippsland First semester 2006 (Day)
Gippsland First semester 2006 (OCL)
Hong Kong First semester 2006 (OCL)
Malaysia First semester 2006 (Day)
Peninsula First semester 2006 (Day)
Singapore First semester 2006 (OCL)
Peninsula SA-02 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 spread sheet model design; spreadsheet modelling techniques; 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: AFW1001 or AFW1002 and ETW1000 or ETX1100 or ETW1102