Course Title: Modelling in Finance

Part A: Course Overview

Course Title: Modelling in Finance

Credit Points: 12.00

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

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

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

.


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.