Course Title: Modelling in Finance

Part A: Course Overview

Course Title: Modelling in Finance

Credit Points: 12.00

Course Coordinator: TBC

Course Coordinator Phone: +61 3 9925

Course Coordinator Email:

Course Coordinator Location: City Campus

Course Coordinator Availability: Appointment via email

Pre-requisite Courses and Assumed Knowledge and Capabilities

Course ID: 054164 BAFI3258 Managerial Finance

Course Description

This course introduces you to concept and principles of financial modelling. You will design and implement financial models, conduct data and sensitivity analysis, implement portfolio optimisation and simulations. You will explore how to use Excel to model financial problems and process financial data effectively.

Objectives/Learning Outcomes/Capability Development


CLO1: Apply the concept and principles of financial modelling.

CLO2: Use Excel to model financial problems and handle financial data.

CLO3: Conduct data and sensitivity analysis of financial market data.

CLO4: Implement portfolio optimisation and simulations and evaluate the effectiveness of the simulations.

CLO5: Communicate financial modelling findings to decision makers, stakeholders and the general public.

Overview of Learning Activities

In this course you will be encouraged to be an active learner. Your learning will be supported through various in-class and online activities comprising individual and group work. These may include assignments; prescribed readings; sourcing, researching and analysing specific information; solving problems; producing written work and collaborating with peers on set research tasks or projects.

Overview of Learning Resources

Various learning resources are available online through MyRMIT Studies\Canvas. The lecture notes and workshop notes are posted on Canvas.

Resources are also available online through RMIT Library databases and other facilities. Visit the RMIT library website for further details. Assistance is available online via our chat and email services, face to face at our campus libraries or via the telephone on (03) 9925 2020.

Additional resources and/or sources to assist your learning will be identified by your course coordinator and will be made available to you as required during the teaching period. 

Access to Microsoft Excel is required.

Overview of Assessment

The assessment tasks, their weighting and the course learning outcomes to which they are aligned are as follows:

Assessment Task 1: 30%
Linked CLOs: 1, 2

Assessment Task 2: 30%
Linked CLOs: 1, 4

Assessment Task 3: 40%
Linked CLOs: 1, 2, 3, 4,5

Feedback will be provided throughout the semester in class and/or in online forums through individual and group feedback on practical exercises and by individual consultation.