Faculty of Business and Economics

Skip to content | Change text size

print version

Monash University

Monash University Handbook 2010 Undergraduate - Unit

6 points, SCA Band 3, 0.125 EFTSL

FacultyFaculty of Business and Economics
OfferedClayton First semester 2010 (Day)


Topics include the development and application of financial spreadsheets, Excel and Visual Basic programming in financial modelling, modelling company financial statements, fixed income securities analysis, asset allocation and portfolio analysis, optimization using Solver, technical analysis of financial markets, Interest rate models, option pricing models, numerical methods and risk management models.


The learning goals associated with this unit are to:

  • apply knowledge and skills in the use of Excel and Visual Basic
  • develop skills in the design and implementation of efficient and robust financial models such as option pricing, portfolio and interest rate models
  • apply critical thinking, problem solving and presentation skills to individual and/or group activities dealing with advanced modelling in finance.


Within semester assessment: 60%
Examination (3 hours): 40%

Chief examiner(s)

Paul Lajbcygier

Contact hours

Three hours per week


One of the following units: AFC2140, AFC2240, AFC2340