units

AFX4030

Faculty of Business and Economics

Undergraduate, Postgraduate - Unit

This unit entry is for students who completed this unit in 2014 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

print version

6 points, SCA Band 3, 0.125 EFTSL

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered, or view unit timetables.

LevelUndergraduate, Postgraduate
FacultyFaculty of Business and Economics
Organisational UnitDepartment of Accounting and Finance
OfferedNot offered in 2014

Synopsis

This unit has two key components. The first half covers aspects of theoretical and empirical financial modelling, including modelling the stock price behaviour, consumption-based asset pricing models, multifactor models, two beta, ICAPM, intertemporal asset pricing models, mean-variance frontier and beta representations, bayesian alphas and mutual fund persistence, a bayesian and bootstrap analysis, performance measures of the hedge fund returns. The second half covers technical skills in building Excel models to solve problems in Finance. The aim is to bridge the gap between financial theory and practice. To achieve this, students will learn modelling skills in Excel and be introduced to VBA programming concepts and techniques.

Outcomes

The learning goals associated with this unit are to:

  1. apply advanced knowledge and skills in the use of Excel and Visual Basic
  2. develop advanced skills in the design and implementation of efficient and robust financial models such as option pricing, portfolio and interest rate models
  3. apply critical thinking, problem solving and presentation skills to individual and/or group activities dealing with advanced modelling in finance and demonstrate in an individual summative assessment tasks the acquisition of a comprehensive understanding of the topics covered by AFX4030.

Assessment

Within semester assessment: 50%
Examination: 50%

Chief examiner(s)

Workload requirements

36 hours per semester

Prerequisites

Students must be enrolled in course 0181 or 0171 or 4416 to undertake this unit.