Course Title: Modelling in Finance

Part A: Course Overview

Course Title: Modelling in Finance

Credit Points: 12.00

Important Information:

Please note that this course may have compulsory in-person attendance requirements for some teaching activities. 

To participate in any RMIT course in-person activities or assessment, you will need to comply with RMIT vaccination requirements which are applicable during the duration of the course. This RMIT requirement includes being vaccinated against COVID-19 or holding a valid medical exemption. 

Please read this RMIT Enrolment Procedure as it has important information regarding COVID vaccination and your study at RMIT: https://policies.rmit.edu.au/document/view.php?id=209

Please read the Student website for additional requirements of in-person attendance: https://www.rmit.edu.au/covid/coming-to-campus 

Please check your Canvas course shell closer to when the course starts to see if this course requires mandatory in-person attendance. The delivery method of the course might have to change quickly in response to changes in the local state/national directive regarding in-person course attendance. 


Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

BAFI3252

City Campus

Postgraduate

625H Economics, Finance and Marketing

Face-to-Face

Sem 2 2021,
Sem 1 2022,
Sem 2 2022

Course Coordinator: Dr Daniel Chai

Course Coordinator Phone: +61 3 9925 7378

Course Coordinator Email: daniel.chai@rmit.edu.au

Course Coordinator Location: City Campus

Course Coordinator Availability: Appointment via email


Pre-requisite Courses and Assumed Knowledge and Capabilities

None.


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 models and simulations. You will explore how to use Excel to model financial problems and process financial data effectively.


Objectives/Learning Outcomes/Capability Development

.


On successful completion of this course you will be able to:

CLO1: Recognize the concept and principles of financial modelling.

CLO2: Manage financial data using Excel and VBA.

CLO3: Perform data analysis of financial market data to facilitate decision making.

CLO4: Analyze financial problems and generate solutions with Excel and VBA techniques.

CLO5: Evaluate 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.