AFW2051

Financial modelling (6 points)

(BUS)

Leader: Berwick, Peninsula: Mr Peter Krueger (Chief examiner); Gippsland: To be advised; Malaysia: Mr Steven Howe; South Africa: To be advised

Offered:
Berwick First semester 2003 (Day)
Gippsland First semester 2003 (Day)
Gippsland First semester 2003 (OCL)
Hong Kong First semester 2003 (OCL)
Malaysia First semester 2003 (Day)
Peninsula First semester 2003 (Day)
Perth First semester 2003 (Day)
Singapore First semester 2003 (OCL)
Gippsland Summer 2003 (OCL)
Hong Kong Summer 2003 (OCL)
Peninsula Summer 2003 (Day)
Perth Summer 2003 (Day)
Singapore Summer 2003 (OCL)
Berwick First semester 2004 (Day)
Gippsland First semester 2004 (Day)
Gippsland First semester 2004 (OCL)
Hong Kong First semester 2004 (OCL)
Malaysia First semester 2004 (Day)
Peninsula First semester 2004 (Day)
Perth First semester 2004 (Day)
Singapore First semester 2004 (OCL)
Gippsland Summer 2004 (OCL)
Hong Kong Summer 2004 (OCL)
Peninsula Summer 2004 (Day)
Perth Summer 2004 (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 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 'macros'.

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