Course Title: Modelling in Finance
Part A: Course Overview
Course Title: Modelling in Finance
Credit Points: 12.00
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.
625H Economics, Finance and Marketing
Sem 2 2021,
Sem 1 2022,
Sem 2 2022
Course Coordinator: Dr Daniel Chai
Course Coordinator Phone: +61 3 9925 7378
Course Coordinator Email: email@example.com
Course Coordinator Location: City Campus
Course Coordinator Availability: Appointment via email
Pre-requisite Courses and Assumed Knowledge and Capabilities
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.