BFC3540 · Modelling in finance

Overview

The focus of this unit is on the development of financial models using Excel. The financial models revolve around: equity portfolio analysis, optimisation and technical analysis.

Offerings

Assessment

The Handbook lists an examination for this unit.

Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.

Requisites

Learning outcomes

1. apply knowledge and skills in the use of Excel.
2. develop 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 task the acquisition of a comprehensive understanding of the topics covered in BFC3540.

Workload

Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled learning activities and independent study. Independent study may include associated readings, assessment and preparation for scheduled activities. You are expected to complete all pre-class activities prior to your scheduled class, and post-class activities should be completed after your scheduled class. Learning activities may include a combination of teacher directed, peer directed and online engagement activities.

Student experience, not official rules. Nothing here changes what the Handbook says.