AFW2051

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

Leader: Mr Peter Krueger

Offered:
Berwick First semester 2005 (Day)
Gippsland First semester 2005 (Day)
Gippsland First semester 2005 (OCL)
Hong Kong First semester 2005 (OCL)
Malaysia First semester 2005 (Day)
Peninsula First semester 2005 (Day)
Singapore First semester 2005 (OCL)
Gippsland SA-02 2005 (OCL)
Hong Kong SA-02 2005 (OCL)
Peninsula SA-02 2005 (Day)
Singapore SA-02 2005 (OCL)
Gippsland Summer 2005 (OCL)
Hong Kong Summer 2005 (OCL)
Peninsula Summer 2005 (Day)
Perth Summer 2005 (Day)
Singapore Summer 2005 (OCL)

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 spread sheet; 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