Undergraduate - UnitBFC3540 - Modelling in finance

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.

Level	Undergraduate
Faculty	Faculty of Business and Economics
Organisational Unit	Department of Banking and Finance
Offered	Clayton First semester 2014 (Day)

Synopsis

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.

Outcomes

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 and demonstrate in an individual summative assessment task the acquisition of a comprehensive understanding of the topics covered in BFC3540.

Assessment

Within semester assessment: 60%
Examination: 40%

Chief examiner(s)

Associate Professor Paul Lajbcygier

Workload requirements

Minimum total expected workload equals 144 hours per semester

Prerequisites

Students must have passed one of the following before undertaking this unit: AFC2140, BFC2140, AFC2240, BFC2240, AFC2340, BFC2340.

Prohibitions

AFC3540